On Mon, Jun 18, 2018 at 9:15 PM, Patrick Herbst <paher...@gmail.com> wrote: > 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?
My first guess would be failing RAM chips. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
