Hi.
I use sqlite in my code for a while now, and at first I parsed all queries each time, but now I'm migrating my code to using prepared statements (using sqlite3_prepare_v2 and binding parameters). At some point I started receiving 'library routine called out of sequence' error every now and then while the application is running. I run the code in multithreaded environment + once in a while the command line utility accesses the same database. I use a single connection to the database and use a mutex to protect access to db. I was using version 2.6.23.1 when the error occurred. Once I upgraded to 3.7.3 the problem seem to have disappeared (without changing any of my code). I went over my code and I could not find any problem (for example calling something without my mutex held). Is it possible that I stumbled upon a bug in 2.6.23.1 that was fixed in 3.7.3, or do I still have a problem that is harder to reproduce? I don't like problems that go away on their own. Btw, I'm accessing the database in embedded linux environment from jffs2 filesystem if that matters. Also, I have a potential case where I may compile the same statement twice, but in theory this should not be a problem, since this is at most a one time resource leak. I would really appreciate some help. Thanks in advance Yan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
