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
https://www.sqlite.org/src/tktview/f68
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 (sqlite database) from user
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,
Mi
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 causes the problem.
Please a
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:
I'
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 co
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?
__
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 wrote:
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 wro
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
___
sqlite-users mailing list
sq
*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 not seem to enable "PRAGMA secure_delete" bef
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
sqlite-users@mailinglists.sqlite.org
http:/
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.
You might want to take do
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 database
14 matches
Mail list logo