On Fri, Dec 18, 2009 at 6:27 PM, Gianandrea Gobbo <go...@solari.it> wrote:
> I'm using sqlite (2.8) on an embedded product, running a Linux kernel. > I'm experiencing sometimes a database corruption, and listing some > tables contents gets me a "SQL error: database disk image is malformed". > Ok, there can be many reasons for this, but the strange thing that > puzzles me is that the database file has always the same size: 409Kb > (418816 bytes). > Gianandrea, I once had an experience with fixing a modified code that led to database disk image malformation. If you can reproduce the bug with a comparatively few number of steps, I'd recommend running the program with checking PRAGMA integrity_check; almost on every step. It costs a little in terms of performance, but in my case it helped, a report about invalid Index entries was way ahead of this particular error so it helped to narrow it to several queries and finally to the invalid code fragment _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users