> (1) Recompile with the following compile-time options: -DSQLITE_DEBUG > -DSQLITE_OMIT_LOOKASIDE > > (2) Enable whatever AddressSanitizer tools > (https://en.wikipedia.org/wiki/AddressSanitizer) you have available on your > platform, in addition to (1) above. > > (3) If you do not have an easily accessible address sanitizer utility, > consider recompiling SQLite using -DSQLITE_MEMDEBUG (in > > addition to the > compile-time options shown in (1) above). > > -- > D. Richard Hipp
@D. Richard Hipp: We have recompiled SQLITE with the following options and have it up and running now: Recompiled with: -DSQLITE_DEBUG, -DSQLITE_OMIT_LOOKASIDE and -DSQLITE_MEMDEBUG. It is clear to us why we have to compile with -DSQLITE_OMIT_LOOKASIDE, but what about the other two options? 1. What is the effect of -DSQLITE_DEBUG? 2. What is the effect of -DSQLITE_MEMDEBUG? Could we expect any extra output or extra info while analyzing crash dumps by using these compile-time options? > Can you run > > PRAGMA integrity_check > > on the database ? If you don't want to tie up your live copy, copy it > somewhere else and run the PRAGMA on the copy. > > Simon. @Simon: The result of this pragma was "Ok".