John Karp wrote: > 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. > > I am experiencing intermittent "database malformed" error when multiple processes access the database. I was hoping to narrow down to the last process that holds the lock. I'm thinking to add another level of locking for the meantime until this issue (i think this is a bug) is resolved. Has anyone successfully implemented a workaround or solution to deal with "database malformed" error?
Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
