i finalizeevery statement right before closing the database, and every finalize returns sqlite_ok. but then closing returns sqlite_busy.
Am 22.06.2011 19:04, schrieb Pavel Ivanov: >> there are no statements open, as far as i can see. > Your eyes can miss something. Does sqlite3_close return SQLITE_OK or > something else? > > > Pavel > > > On Wed, Jun 22, 2011 at 12:36 PM, Thorsten Kersting > <thorsten.kerst...@itp1.uni-stuttgart.de> wrote: >> there are no statements open, as far as i can see. >> >> On 06/22/2011 05:29 PM, Pavel Ivanov wrote: >>> Do you check result code of connection closing? Is it successful? >>> If it's not successful then some statements are still active and >>> reading transaction is still open. That could be the reason of error >>> in write process. >>> >>> >>> Pavel >>> >>> >>> On Wed, Jun 22, 2011 at 10:58 AM, Thorsten Kersting >>> <thorsten.kerst...@itp1.uni-stuttgart.de> wrote: >>>> i use openmpi fo parallelization, an c++ as the interface to sqlite. >>>> in my program one process only writes into the database, and the other >>>> processes read at the beginning, and then never do anything with it. But >>>> even when i close the database-connection of the non-writing processes, >>>> my write process says, that the database is locked. And this lock never >>>> gets released. >>>> I don't understand, why there is a lock on the database, when no other >>>> connection exists. Is there a way, that i can see, which connection has >>>> the lock? >>>> i tried this in a testprogramm, and there it worked, but not in the >>>> programm i want to use. >>>> >>>> thanks for any help >>>> _______________________________________________ >>>> sqlite-users mailing list >>>> sqlite-users@sqlite.org >>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>>> >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users