Changes between Initial Version and Version 1 of Ticket #366


Ignore:
Timestamp:
10/11/06 05:06:25 (10 years ago)
Author:
dstillman
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #366 – Description

    initial v1  
    11Slight flaw in the current backup strategy: if you corrupt your SQLite DB while Firefox is open, Zotero will happily copy the corrupted file to the backup file, leaving you with two worthless files. 
    22 
    3 Unfortunately the caching prevents us (as far as I can tell) from actually determining if the DB on disk is corrupt or not after we've first opened a working one, even if the connection is manually unset. And there doesn't seem to be a way to do a .dump from mozStorage, which would solve all our problems. 
     3Unfortunately the mozStorage caching prevents us (as far as I can tell) from actually determining if the DB on disk is corrupt or not after we've first opened a working one, even if the connection is manually unset. And there doesn't seem to be a way to do a .dump from mozStorage, which would solve all our problems. 
    44 
    55If we were OK with requiring storage space for three copies of the DB, we could back up pre-connect at startup to a temporary file, try to open the main DB, if successful replace the last shutdown backup with the new one, and otherwise delete the new startup backup and try to restore from the shutdown. Then at shutdown move the startup backup down one and make a copy of the DB, which may or may not be corrupt, but at least we then have protection for corruption both  when Firefox is running and when it's not.