Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

2012-09-10 Thread Daniel Frimerman
Yes! The journal file was indeed there. I deleted it before openning the database, and read 50 records. I repeated the process; it's consistent. The way I see it that even though the synchronous setting is FULL, there is no API to tell the OS to physically delete a file from disk, just like there

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

2012-09-09 Thread Dan Kennedy
On 09/10/2012 03:15 AM, Daniel Frimerman wrote: My apologies about the attachment; should have known better. This should be better: https://dl.dropbox.com/u/50838941/SQLite3_Test.zip I only get the problem with DELETE and TRUNCATE journal_mode (synchronous set to NORMAL or FULL), but not with PE

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

2012-09-09 Thread Daniel Frimerman
Actually, I am not using sqlite at the API level. That's why prepared a bunch of batch files that reproduce the issue with sqlite command line shell. To answer your question, the queries complete in sqlite3 command line, and they also complete successfully using the API, albeit, through a wrapper

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

2012-09-09 Thread Simon Slavin
On 9 Sep 2012, at 9:15pm, Daniel Frimerman wrote: > The reason I think there has to be 50 rows is because on FULL mode for > example, the I/O buffers are flushed, and it's consistently missing 1 > record as opposed to any other number of records. I insert 50 records, the > sqlite3 command line u

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

2012-09-09 Thread Daniel Frimerman
My apologies about the attachment; should have known better. This should be better: https://dl.dropbox.com/u/50838941/SQLite3_Test.zip I only get the problem with DELETE and TRUNCATE journal_mode (synchronous set to NORMAL or FULL), but not with PERSIST (synchronous set to NORMAL or FULL) or WAL (

Re: [sqlite] Possible bug - journal_mode DELETE/TRUNCATE

2012-09-09 Thread Pavel Ivanov
Note: attachments are stripped out of this list. So if you want for anybody else to see your zip file you need to put it on some website and post link here. About the problem you have: I wonder how are you sure that there should be 50 rows in the database and not 49? If you are resetting the OS be

[sqlite] Possible bug - journal_mode DELETE/TRUNCATE

2012-09-09 Thread Daniel Frimerman
I am fairly new to sqlite and as a result of not reading the manual and not doing some performance testing, I got punished somewhat. I did not anticipate that on journal_mode=DELETE and synchronous=FULL, I would get no more than 5 inserts (in auto-commit mode) per second. It crippled a certain ba