BSOD results in SQLite, Google Drive failure

-
I am losing count, having just recovered from the third or fourth Google Drive failure in a month across two PC's.  This latest followed an unexpected shutdown, (a BSOD of an as yet unknown nature), which left a SQLite database in an unusable state:

 Google Drive needs to be closed.
...unknown error occurred and Google Drive needs to be closed.
Error: database disk image is malformed
If you continue to see this error, try to disassociate your account

 [*sigh*]

 One Google (overlord) Groups thread from 2012 suggests using other services. e.g. EverNote, DropBox, and even (gasp!) Microsoft SkyDrive--Really?

 (Lord) Google searches revealed that virtually anyone with some SQL skills might be able to recover from this.  I am not a DBA.  Having some very skilled DBA's at work has resulted in my leaving that skillset wanting....

Folks working in I.T. and/or with related skills can generally deal with and recover from interruptions/failures like these one way or another.  (Incident response is something I enjoy--solving interesting & difficult puzzles in an almost House M.D. manner, which probably makes me some sort of Holmesian-Windows-barbarian, who knows).  Considering some of the rubbish I have encountered with Google Drive, it is difficult to imagine folks with different skillsets responding to these interruptions.  Either of my brothers would react vehemently, and perhaps rightfully so.  Anyhow.  Not cool, Lord Google.

 There's a post on Twitter by Arul Dhesiaseelan (@aruld) which mentions Google Drive uses SQLite and includes a capture of an oft-encountered earlier Google Drive failure, (for which a search via...your favorite search engine will demonstrate others have also encountered this), "...PRIMARY KEY must be unique".  Another one which, for most folks including myself, means starting from scratch and downloading everything again.  (Where the hell is the frowny-face emoticon in Blogger?).

 Now, in true geek (really hacker, but thanks to the media, that's usually used incorrectly--see cracker) fashion, we ought to be able to automate the backup any SQLite database that Google Drive uses and restore it from a backup, quickly & easily.  This is especially important since Google Drive appears to be in some sort of immature, pre-release, beta state.  (Where the hell is a good Slashdot article when you need one).

Hopefully in a future post: my humble attempts to automate backing up the Google (overlord) Drive SQLite DB in Windows.

Popular posts from this blog

first bugger

-
As soon as ewido started it's scan, it found a couple of threats. And after cleaning those threats, MS Anti-Spyware Beta found, cleaned, and repeatedly does the same for something called "startup.nameshifter.og". Keeps. Finding. It. Every. Minute. Sucks. Google currently has one hit for this on a Japanese site. I can actually speak a tiny bit of Japanese, but can't read it. Translation sites are only so-so. Anyhoo, it appears that the Ewido anti-malware is a decent tool. While the demo for Webroot Spy Sweeper found a variety of objects, it won't remove anything without a subscription. Good for them; wankers. Remember the crazy chick with the buzz haircut with the infomercials a decade ago, always screaming "Stop the Insanity!"? She should be doing ads to sell anti-malware apps.
Read more

Make Firefox Look Like Internet Explorer

-
I know, I know, why would you do this? What can I say...I like the way I can customize IE. But after getting hit with this stupid WMF vulnerability (the popups are back, by the way, the box is hosed), IE is dead to me. When running at higher resolutions (XGA & up), it's great to be able to combine toolbars. In IE, you can drag and drop toolbars onto the same level. Turns out in Firefox, you can customize & put all the objects onto one or two toolbars . Beautiful. You can even get a skin to make Firefox look like IE. I know, I know. But it's all about comfort level. And not getting infected with the next zero-freaking-day-freaking-exploit. Besides, if you can make Firefox look like IE, then make it the default browser for you end-users....most of them won't know or won't care. There are some exceptions (Exchange 2003's Outlook Web Access is positively beautiful in IE). I'm more/less talking about day-to-day usage.
Read more

Windows XP Activation and P2V

-
At the office, I'm gradually converting a ton of legacy PC's to virtual machines. The quick & easy way is to run ntbackup on the old box, bring up a vanilla virtual machine, and restore it onto that. NTbackup is also great when, months from now, someone says oops..I need n . The P2V assisitant, and VMWare's Knoppix distro , is also incredibly good. Sometimes, however, even when the P2V process is flawless, Windows still wants to sh!t a bit. Twice now, I've converted Dell laptops to virtual machines, and had Windows Product Activation rear it's ugly head. we have a volume licensing agreement, but for some ungodly reason, these machines were deployed (before I was here) with the image that came from Dell. With all the crapware that they include. And low and behold, following the ntbackup restore and reboot, Windows XP wants you to reactivate. No thanks. I boot from the Ultimate P2V ISO, just because I love it, and you can customize it with a ton of great t...
Read more