On 16 Nov 2016, at 7:25am, Jens Alfke <j...@mooseyard.com> wrote: > The case I’m concerned about happens on Macs, as I said, and the developer > says he can trigger it in his app via a power failure or a forced shutdown > (holding the power button for 5 seconds.) This version of our library is one > I wrote, in Objective-C; it uses a thin Obj-C wrapper around SQLite, but it > doesn’t do anything magic, and although it started out as 3rd party code I’ve > tweaked it enough that I know it inside and out.
Ah, that's enough information that someone around here should be able to help. Can you use the shell tool to run PRAGMA integrity_check on one such corrupt file and post what it finds ? If the output is long, posting a summary is fine. There's also a tool from the SQLite team which can analyze a corrupt SQLite file and tell some things about how it is corrupt. Unfortunately I can't remember what it's called or where to find it. But I heard about it on this list and I hope someone can. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users