> 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

Reply via email to