One session's data loss
I've lost a couple of hours' worth of edits. I only noticed after closing FF down, as everything had appeared normal whilst editing. But the sqlite files were still dated yesterday. There was no journal file, and FF had closed down normally. Puzzled, I started FF up again, and, sure enough, none of my edits were present.
I've tried and can't get this to happen again, and, obviously as the sqlite.bak file has been written I'm not expecting to get my edits back. But has anyone seen this before, have any ideas re what may have caused it, and have any tips on how to avoid it happening again?
I've tried and can't get this to happen again, and, obviously as the sqlite.bak file has been written I'm not expecting to get my edits back. But has anyone seen this before, have any ideas re what may have caused it, and have any tips on how to avoid it happening again?
I would have thought the sqlite file would only be updated if edits/additions were made?
If you can reproduce this, we'd certainly want to know how, but unfortunately without more info there's not much we can do. It's possible you've hit upon some bug in the Firefox 2 storage system or perhaps even an OS/filesystem issue. The DB changes you're seeing are due to the daily translator/style updates.
I'm going to keep an eye out on the sqlite file to see if I ever get this again (I imagine the obvious symptom would be that during edits the sqlite file wouldn't change, and the journal file wouldn't appear). But given that I have thousands of items, built up using Zotero since the beginning, and have never seen anything like this behaviour before, I guess it's (fortunately) very unlikely.
Actually given how much I've used zotero, its record for data safety has probably been as good as any piece of software I've been familiar with.