subject:"\[sqlite\] bug in sqlite when"

Re: [sqlite] bug in sqlite when

2016-08-24 Thread Richard Hipp

On 8/24/16, Sergey Shamshyn wrote: > - *PRAGMA journal_mode=OFF* (when not execute this pragma, all is ok). With journal_mode=OFF, the database may go corrupt if: (1) The program is ever terminated (ex: using SIGKILL) while the database is open. (2) If a COMMIT

Re: [sqlite] bug in sqlite when

2016-08-24 Thread Igor Korot

Hi, Sergey, On Wed, Aug 24, 2016 at 8:55 AM, Sergey Shamshyn wrote: > Hi. > I have a big trouble using SQLite: got an error SQLITE_CORRUPT (11), I think > this is a 100% SQLite bug, because: > - only ONE THREAD of my process is writing periodically to db file > - onlt

[sqlite] bug in sqlite when

2016-08-24 Thread Sergey Shamshyn

Hi. I have a big trouble using SQLite: got an error SQLITE_CORRUPT (11), I think this is a 100% SQLite bug, because: - only ONE THREAD of my process is writing periodically to db file - onlt ONE ANOTHER THREAD of my another process reads from this db file - version 3.14.1 - PRAGMA