The new "consumer" SSDs from Samsung carry a 1200 TBW/8 year warranty on a 4 TB device. That is a lot of writing for a "consumer desktop" computer ... that is about 400 GB written per DAY every day for 8 years!
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Scott Doctor >Sent: Monday, 18 June, 2018 22:27 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Strange Corruption Issue > >SSD's have a limited number of write cycles. You may have a >failing SSD. Those are still, IMO, another 5-10 years before >they solve the write lifetime reliabilty issue. > >------------------------- >Scott Doctor >sc...@scottdoctor.com >------------------------- > >On 6/18/2018 20:15, Patrick Herbst 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? >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >users > >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
