[sqlite] Why SQLITE_BUSY?

2015-12-14 Thread sanhua.zh
I queue all my db operation into one thread with single sqlite conn. neither multi-thread nor multi-process operation happened.But some SQLITE_BUSY error code still be catched. I can not re-produce this error code indeveloping environment,because it happen in alow probability. I only catch this

Re: [sqlite] why SQLITE_BUSY when read the database

2010-03-10 Thread a1rex
>Do The words mean that while one process is writing the database other >processes could not read the database at the same time? The reader fails since it cannot obtain SHARED lock required for reading. It cannot obtain that lock since the writer already managed to obtain PENDING or EXCLUSIVE

Re: [sqlite] why SQLITE_BUSY when read the database

2010-03-10 Thread a1rex
>Do The words mean that while one process is writing the database other >processes could not read the database at the same time? In short:: YES __ Be smarter than spam. See how smart SpamGuard is at giving junk email the

[sqlite] why SQLITE_BUSY when read the database

2010-03-10 Thread liubin liu
why SQLITE_BUSY when read the database My application suffered a problem that sqlite3_step(*) of SELECT returns SQLITE_BUSY. I know "Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however." from the