> From my debugging efforts, the issue appears to be that the process entered > the sqlite library at some point in its operation, acquired a read lock, and > returned from the library, but failed to release the read lock. Under what > circumstances can this occur?
This is a normal behavior for SQLite. When you start to execute some SELECT query first call to sqlite3_step acquires read lock on the database and returns to you (most probably with SQLITE_ROW result code). And then read lock is not released until you call sqlite3_reset or sqlite3_finalize on this statement. So check if you have some not finalized statements - they will hold read lock for you. Pavel On Tue, Mar 1, 2011 at 3:20 PM, mmudi <m_kovalm...@yahoo.com> wrote: > > We are using sqlite version 3.3.17 in a production environment, and are > facing an issue where a particular process is not releasing the read lock on > the sql file. This locks up the database when any write operations are > attempted by other processes. The process under question is not multi > threaded and stack trace reveals that the process is not stuck in an SQLite > library call but is processing other requests. > > A code review of the DB access API has not revealed any resources or calls > that have not been closed/freed properly. > > Questions > -- > From my debugging efforts, the issue appears to be that the process entered > the sqlite library at some point in its operation, acquired a read lock, and > returned from the library, but failed to release the read lock. Under what > circumstances can this occur? > > Is there a known issue in the sqlite library which fixes a similar problem, > that would necessitate us to upgrade to a newer version? > > Thanks in advance > Madhu > > -- > View this message in context: > http://old.nabble.com/Read-Lock-not-released..-tp31043990p31043990.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
