[sqlite] Problem with locked database

2015-11-04 Thread ALBERT Aurélien
-- De?: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] De la part de R.Smith Envoy??: mardi 3 novembre 2015 19:43 ??: sqlite-users at mailinglists.sqlite.org Objet?: Re: [sqlite] Problem with locked database On 2015-11-03 06:31 PM, ALBERT Aur?l

[sqlite] Problem with locked database

2015-11-04 Thread Simon Slavin
On 4 Nov 2015, at 8:00am, ALBERT Aur?lien wrote: > - this thread uses a transaction : BEGIN at import start, COMMIT/ROLLBACK at > import end > - during the import (which is very long to execute, sometimes several hours), > another thread execute reads on the same database (different connectio

[sqlite] Problem with locked database

2015-11-03 Thread R.Smith
On 2015-11-03 06:31 PM, ALBERT Aur?lien wrote: > Hi, > > I'm often getting the "Database is locked" error message and I don't really > understand what can lead to this. > > I'm using these settings : >- sqlite3_config(SQLITE_CONFIG_MULTITHREAD) >- multiple threads >- only one sqlite

[sqlite] Problem with locked database

2015-11-03 Thread ALBERT Aurélien
Hi, I'm often getting the "Database is locked" error message and I don't really understand what can lead to this. I'm using these settings : - sqlite3_config(SQLITE_CONFIG_MULTITHREAD) - multiple threads - only one sqlite connection per thread - each thread have a different connection in

[sqlite] Problem with locked database

2015-11-03 Thread Simon Slavin
On 3 Nov 2015, at 4:31pm, ALBERT Aur?lien wrote: > I'm using these settings : > - sqlite3_config(SQLITE_CONFIG_MULTITHREAD) > - multiple threads > - only one sqlite connection per thread > - each thread have a different connection instance You must set a timeout for each connection you ope