On 4 Nov 2009, at 1:17pm, Nico Coesel wrote: > Two seperate processes (process A and process B) on a Linux system > read > and write to the same database. Process A performs a transaction > every 5 > seconds. Every now and then the locks from process A are not released > (judging from /proc/locks). It seems this situation occurs when > process > A and B both try to access the database at the same time. I have not > found a way to release the lock besides closing the database handle. > I'm > using the sqlite3_exec function to execute a query; this function > calls > slite3_finalize at the end so this should release the locks.
Are you checking how every sqlite3_ function call returns, in both processes, to see whether it is reporting an error ? Even a function like 'COMMIT' can correctly make the changes you want but return an error message anyway. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
