Re: [sqlite] Database is locked when working in 2 processes

2007-01-16 Thread Yuriy Martsynovskyy
This issue has been resolved. I did not call sqlite3_finalize() in the reader process and kept the READ lock How to read after the database was written by another process? Reading function should wait until other process finishes writing and unlocks the file. But in our case unlocking never

Re: [sqlite] Database is locked when working in 2 processes

2007-01-16 Thread Yuriy Martsynovskyy
Many threads or process can read, but just one can write, and when is writen the DB is locked, even for read. How to read after the database was written by another process? Reading function should wait until other process finishes writing and unlocks the file. But in our case unlocking never

Re: [sqlite] Database is locked when working in 2 processes

2007-01-16 Thread Cesar Rodas
Many threads or process can read, but just one can write, and when is writen the DB is locked, even for read. On 16/01/07, Yuriy Martsynovskyy <[EMAIL PROTECTED]> wrote: I have a problem with SQLite when accessing DB file from two processes. Process 1 is writing to the database periodically in

[sqlite] Database is locked when working in 2 processes

2007-01-16 Thread Yuriy Martsynovskyy
I have a problem with SQLite when accessing DB file from two processes. Process 1 is writing to the database periodically in autocommit mode. Process 2 only reads from the same database file. After awhile Process 2 starts getting "Database is locked " error and can not read anymore until you