Loading...

sqlite-users@sqlite.org

[Prev] Thread [Next]  |  [Prev] Date [Next]

Re: [sqlite] Bug hunting in SQLite Roger Binns Sun Feb 26 13:00:06 2012

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 26/02/12 11:29, Patrik Nilsson wrote:
> How do I set up a log

A log of what?  This will get you queries:

 http://www.sqlite.org/c3ref/profile.html

This will get you disk operations:

 http://www.sqlite.org/compile.html#enable_iotrace

> I have made a verify function for the whole table of the data-blobs.

Yet more reason for this to be implemented:

  http://www.sqlite.org/src/tktview?name=72b01a982a

One thing you should do is run your program under valgrind.  It is quite
likely that it is other code messing with SQLite's memory.  I like to set
the --freelist-vol flag to a huge number to ensure freed memory is never
reused - this is especially good at catching problems in long running
programs.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk9KkgUACgkQmOOfHg372QRGFACfRr2G/0Pvs2zi6Sr+KM/oodVC
otsAnjSongLQfaaV0n2zugNoRTOGUlh5
=iRa2
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
[EMAIL PROTECTED]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users