Re: [sqlite] Unlocking locked database and preventing locking to start with

"Smells" like database corruption, but I can't say for certain as there could be a couple things holding back. - If a rogue thread that isn't killed has its finger on it, it could prevent further access, but that'd depend on whether you're doing a full file lock with that thread. - As mentioned,

Re: [sqlite] Unlocking locked database and preventing locking to start with

On 8 Feb 2013, at 8:57am, Paul Sanderson wrote: > Is there a faster method for clearing a lock? SQLite does not use a persistent locking mechanism. It doesn't write something to the file saying "this file is locked" and refuse to open a file with that status.

[sqlite] Unlocking locked database and preventing locking to start with

I have a user who has a locked database. I don't know why the db is locked but suspect either he killed the program when it was adding an index or my program crashed (he was using a beta version). Irrespective of wghich he has a db that is locked and I'd like to unlock it. My database would