My code is outside the database layer. So I do all my database work, then compress and encrypt it. No errors are returned anywhere. I'm guessing that it's going to be an uninitialized variable or byte alignment problems somewhere.
This code is running on hundreds of machines without a problem and I've never reproduced it but every now and again I get a support ticket showing a corrupt database. So I'm trying to figure out WHERE to look. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Elrick Sent: Wednesday, May 27, 2009 10:59 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] corrupt database recovery Gene Allen wrote: > Ok...it's happened again and I've decided that I need to track this down > once and for all! > > Here is what I'm seeing: I get errors when I do a integrity_check (see > below), but I can .dump it to a text file and then .read it into another > database ok. > > It seems to me that I'm screwing up an index or something. Are indexes > stored at the end of the database file? All I can think of is that my > compression/encryption routines are messing something up and I'm trying to > figure out 'where' to look. > > I guess the real question is, what would I have to do to make an > integrity_check fail, but still let a dump work correctly? > > Many thanks for any advice on tracking down this ugliness. > SNIP Personally, I'd refactor the code to allow me to verify the operation of the compression/encryption routines independently of the database operation. How are you injecting the compression/encryption into the database layer? John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
