On 28 May 2011, at 5:02pm, john darnell wrote:

> This time I have (I hope) a much simpler question.  While debugging my code, 
> I managed to lock the database for all time.  The only way I was able to 
> unlock the database was by retrieving a copy of the database I had tucked 
> away for just such contingencies.  I looked in Jay Kreibich's very fine book, 
> Using SQLite, but found no function that would unlock a database.  Is there a 
> function, method or process whereby I can unlock the database when it gets 
> locked?

SQLite locking is a function of your OS.  It's not static things something like 
"Byte 4 of the file is set to 'L'", it's transient things handled with file 
handles or low level FS stuff.

So reboot.  Or possibly find everything that might have that file open and kill 
them all.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to