Hi D. Richard, Your comments / suggestions made me think and widen my exception tracking - and it does indeed seem that it is caused by statement that fails with a NULL-pointer exception when sqlite3_prepare is called. Why this is I need to figure out - but I suspect that the Finisar.SQLite wrapper maybe has a weird bug somewhere which causes sqlite3_prepare to be called with a NULL-pointer (propably the string containing the sql statement). Why thousands of sql-statements can be run before the exception is thrown I do not know - but at least I got a bit further.
Thank you for you help :) /Michael -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 9. maj 2006 12:26 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Transactions and 'library routine called out of sequence' locks the database "Michael B. Hansen" <[EMAIL PROTECTED]> wrote: > > However, I keep getting 'library routine called out of sequence' at > random interval. > This is caused when you do things like try to use a database connection that has already been closed or try to use a prepared statement that has already been finalized or by trying to use the same database handle at the same time in two different threads. -- D. Richard Hipp <[EMAIL PROTECTED]>