Re: [sqlite] Possible index corruption

Thank you Richard. Do you plan to make a code release or perhaps to release a new code snapshot, so that I can avoid this situation from happening again? Regards, Miroslav On 14.7.2016. 20:48, Richard Hipp wrote: This problem is written up in ticket

Re: [sqlite] Possible index corruption

This problem is written up in ticket https://www.sqlite.org/src/tktview/f68bf68513a1 Short answer: Simply run REINDEX to clear the problem On 7/13/16, Miroslav Rajcic wrote: > I am using sqlite to implement document file format in my program. > I got a document file

Re: [sqlite] Possible index corruption

Thank you Simon, tried that, but nothing was reported as faulty whatsoever, for any of the command that corrupted the database. The same integrity check reports issues in another script that tests the database on subsequent load. I will now send data and a recipe to Richard. Regards,

Re: [sqlite] Possible index corruption

On 14 Jul 2016, at 6:37am, Miroslav Rajcic wrote: > Good news: actually those SQL commands perfectly reproduce the issue, I just > forgot to reload the database before checking the issue with "SELECT" query. We'd like your help identifying the specific line which

Re: [sqlite] Possible index corruption

Good news: actually those SQL commands perfectly reproduce the issue, I just forgot to reload the database before checking the issue with "SELECT" query. I'll now ask a customer for a permission to send you a document off-list. Regards, Miroslav On 14.7.2016. 7:24, Miroslav Rajcic wrote:

Re: [sqlite] Possible index corruption

I've recorded the SQLs done to the original file (with all the tables, not the stripped one) which makes it corrupted, see below (I've removed "SELECT" queries from the list, assuming they are not relevant). The issue is that it works OK when I feed it into sqlite command line tool with (it

Re: [sqlite] Possible index corruption

I will work on tracing all SQL calls and will get back to you. Regards, Miroslav On 13.7.2016. 13:05, Richard Hipp wrote: On 7/13/16, Miroslav Rajcic wrote: Issue can be reproduced on Windows and Mac Can you please send the steps needed to reproduce the problem?

Re: [sqlite] Possible index corruption

No big deal, we were aware of the fact before my post and I got a green light from Daniel. It is that "VACUUM" of the database would cause the issue to go away, so we choose to send it as it is. Regards, Miroslav On 13.7.2016. 16:13, Richard Hipp wrote: On 7/13/16, Chris Locke

Re: [sqlite] Possible index corruption

Hi Richard, I'm aware of the fact, but Daniel Hertrich, who is the customer in question (he replied in this thread), looked into the file with hex editor before giving the approval. Regards, Miroslav On 13.7.2016. 13:02, Richard Hipp wrote: Off-list reply On 7/13/16, Miroslav Rajcic

Re: [sqlite] Possible index corruption

On 7/13/16, Chris Locke wrote: > *everyone rushes to download the files to have a nose* Yeah - I messed up on that "off-list" reply. I have already grovelled before Miroslav. Sorry. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Possible index corruption

*everyone rushes to download the files to have a nose* On Wed, Jul 13, 2016 at 12:02 PM, Richard Hipp wrote: > Off-list reply > > On 7/13/16, Miroslav Rajcic wrote: > > > > Note that I had to delete other tables to protect customer info. > > You did

Re: [sqlite] Possible index corruption

On 7/13/16, Miroslav Rajcic wrote: > Issue can be reproduced on Windows and Mac Can you please send the steps needed to reproduce the problem? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Possible index corruption

Off-list reply On 7/13/16, Miroslav Rajcic wrote: > > Note that I had to delete other tables to protect customer info. You did not seem to enable "PRAGMA secure_delete" before deleting the other tables. Hence, much of the content is still in the file, on the freelist.

[sqlite] Possible index corruption

I am using sqlite to implement document file format in my program. I got a document file (sqlite database) from user where the image embedded into the document note is displayed OK, but disappears on the next load of the same document (even if no user editing action was done). The only