Re: [sqlite] db file locked after power loss

2009-11-10 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shawn Boyle wrote: > The sqlite3_open() call returns > SQLITE_IOERR. All attempts to copy the db file from the device fail. That indicates your device is having issues. If you can't read the file then neither can SQLite. Roger -BEGIN PGP

[sqlite] db file locked after power loss

2009-11-10 Thread Shawn Boyle
I'm running SQLite v3.4.0 on an embedded linux device. I am testing a power loss scenario while updating a record. When the device boots back up and the device occasionally gets into a state where the database file seems locked. The sqlite3_open() call returns SQLITE_IOERR. All attempts