I'm using sqlite in an embedded application, running on SSD. journal_mode=persist so that it is more resilient to loss of power.
I'm seeing corruption. I'm using sqlite to log events on the system, and the corruption is well in the middle of a power session; not at the tail end of log when a power loss might occur. What i'm seeing is just a few pages corrupted with random bits being flipped. looking in a hex editor I can see the corrupted data, and where I can tell what values it SHOULD be, I see that they're wrong, but only by a single bit flip.... in random bytes here and there. for example a "A" is "a", or a "E" is "A". These are all changes of a single bit. there are far more examples... but in pretty much every case (even when RowID's are wrong) its just off by a bit. I'm using sqlite 3.7 (i know, old, but this this system is old). Has anyone else seen random bit flips? Any idea what could be causing it? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
