Hi List
I have a python script that runs 3 instances simultaneously on a
quadcore x86 system. I'm not using the multiprocessing libraries. The
programs are just run in parallel. They all access (for reading only)
a single sqlite3 database. I'm setting the following pragma commands:
offset_db.execute('pragma synchronous = 0')
offset_db.execute('pragma temp_store = 2')
offset_db.execute('pragma read_uncommitted = true')
offset_db.execute('pragma cache_size = 20000000')
offset_db.execute('pragma default_cache_size = 20000000')
offset_db.execute('pragma journal_mode = off')
Nine times out of ten I get the following error when I run my code:
offset_db.execute('pragma synchronous = 0')
sqlite3.OperationalError: database is locked
If I simply run the script again, it will always work the second time.
The script only make select statements. There is no writing
whatsoever. Any ideas what's going on here? I should that there is
another program that runs before these that inserts data into the
database. Could it be that something is not closing correctly?
Thanks in advance for any guidance.
-Sean
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
