Just a note. If you change the #define settings to the below values you also get table locks
#define MAX_THREAD 100 #define MAX_LOOP 100 Thanks, -Alex On Sat, Aug 23, 2008 at 3:35 PM, Alex Katebi <[EMAIL PROTECTED]> wrote: > Hi, > > I am getting a table lock for no apparent reason in my application. > > To reproduce this I have written a test file that behaves the same way with > the difference that it reports database lock instead of table lock. My > application database is in memory the test uses a file database. I think it > is the same locking issue. > > Attached is "test.c" > gcc -Wall test.c -lsqlite3 -o test > run two test at the same time you will see the problem. > > Thanks, > -Alex > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

