On Wed, 2005-06-15 at 10:05 -0400, D. Richard Hipp wrote: > There are currently two outstanding tickets against SQLite > for deadlocks while running multiple threads on RedHat 9. > See > > http://www.sqlite.org/cvstrac/tktview?tn=1285 > http://www.sqlite.org/cvstrac/tktview?tn=1272 >
The group that posted ticket #1285 have now modified their code to store sqlite3* database handles in thread-specific data using pthread_getspecific(). This has cleared their problem indicating that the problem originated when database handles were shared across threads. This leaves only ticket #1272 which I suspect originates from the same cause. I have checked in changes to SQLite that will raise an SQLITE_MISUSE error (on unix) if you try to share database handles across threads. That should prevent this kind of problem from coming up again in the future. -- D. Richard Hipp <[EMAIL PROTECTED]>
