On Wed, Nov 26, 2008 at 3:38 AM, Ronnel P. Maglasang <[EMAIL PROTECTED]> wrote: > Hi All, > > Is there a way to identify which process currently > holding the lock (I am aware of several type locks) of > the database? And how long the lock has been held. I am > looking for a functionality similar to Unix semaphores. I > initially thought that these information are stored in the > database, or are they? > > Thanks, > sho
I've had to deal with the same question. At least on Unix-type operating systems, you can use 'lsof <path to database file>' to get some information. Its better than nothing. One idea is to add some tracing code into sqlite, that would log the process and thread ids to a log file whenever the lock changed states. -John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
