Hi,
In our project we use SQLite3 database on EXT4 filesystem partition on
microSD card. On unexpected power failure/system crash or just hardware
reset, we observe occasional database corruption. SQLite3 developers
claim their part is free of risk of database corruption, as long as
fsync call is doing it's job properly. We tried several SD cards,
including industrial grade which should have proper firmware (at least
their manufacturers say there is no risk of data corruption on power
loss). We tried several different mount settings and after some reading
we found, that the safest (and slowest) option (that should never fail,
as far as we understand) would be like:
rw,relatime,barrier=1,journal_checksum,nodelalloc,data=journal,usrquota
In spite of all that, we still observe random database corruption on
power-down/reset. Can you confirm there is no problem in EXT4 filesystem?
Best regards,
Greg
--
ExchangeDefender Message Security: Click below to verify authenticity
https://admin.exchangedefender.com/verify.php?id=s69CHHv3024052&from=g.sikorski@xxxxxxxxxxxxxxxxxxxxxx
--
To unsubscribe from this list: send the line "unsubscribe linux-ext4" in
the body of a message to majordomo@xxxxxxxxxxxxxxx
More majordomo info at http://vger.kernel.org/majordomo-info.html
