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,
Miroslav
On 14.7.2016. 13:03, Simon Slavin wrote:
On 14 Jul 2016, at 6:37am, Miroslav Rajcic <miroslav.raj...@inet.hr> 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 add
the command "PRAGMA integrity_check" to the end of that list of commands and
see whether it returns an error. If it doesn't report any problem please reload the
database, try the same command again, and tell us what happens.
If it does report a problem the first time, it gives you a way of diagnosing the problem
without having to reload the database. If that's the case please help us identify the
command which causes the problem for you. So pick, for example, the "BEGIN
EXCLUSIVE" command about half way down the list.
Start with uncorrupted database.
Execute up to this command but no further.
Execute the command "PRAGMA integrity_check"
If the text returned shows an error, then the line causing the problem is before the "PRAGMA
integrity_check". If not, then the problem is after that and you can keep going through your
script line by line, issuing "PRAGMA integrity_check" after each one, until you find the
command that's causing your problem.
Thanks for your help.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users