Salles, Joaquim Campos wrote:
Now running the command "PRAGMA integrity_check":
sqlite> PRAGMA integrity_check;
*** in database main ***
Main freelist: 138691677 of 4 pages missing from overflow list starting
at 2972
On tree page 322 cell 0: 3 of 4 pages missing from overflow list
starting at 297
1
Page 2936 is never used
Page 2941 is never used
Page 2963 is never used
Page 2966 is never used
Page 2968 is never used
Page 2970 is never used
sqlite>
Running the VACUUM command the sqlite terminate abnormally (in windows).
Any one has some idea what I have to check in my program to avoid
corruption in database?
What I can do, in my program, in startup, to check if the database is
ok?
There is a good description of the things that can cause database
corruption at http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption
which may give you some ideas for things to check.
Your program can check the database on startup by executing a "pragma
integrity_check;" command just like you did from the command line.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
