[sqlite] database is locked when using SQLite3 and MPI to generate different databases

2016-05-09 Thread Rowan Worth
On 8 May 2016 at 10:14, just_rookie <925345468 at qq.com> wrote: > Obviously, I did not do incompatible things with a database at the same > time. > You are attempting to drop a table in databases 300_500.db and 600_900.db. Obviously another process must create that table, since your test code

[sqlite] database is locked when using SQLite3 and MPI to generate different databases

2016-05-08 Thread just_rookie
Hi all, I would like to use SQLite3 and MPI to generate many databases, and different processes produce and process different databases. But when I ran the program in Linux, I got an error message from sqlite3_exec() that ?database is locked?. I know this message means I tried to do

[sqlite] database is locked when using SQLite3 and MPI to generate different databases

2016-05-08 Thread Simon Slavin
On 8 May 2016, at 3:14am, just_rookie <925345468 at qq.com> wrote: > But when I ran the program in Linux, I got an error message from > sqlite3_exec() that ?database is locked?. You have not set a timeout, so SQLite is quitting as soon as it is told that another thread/process has the