From: Grzegorz Sikorski <g.sikorski@kelvatek.com>
To: linux-ext4@vger.kernel.org
Subject: Question about data integrity on SD cards
Date: Wed, 09 Jul 2014 13:17:25 +0100 [thread overview]
Message-ID: <53BD32D5.3000804@kelvatek.com> (raw)
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@camlintechnologies.com
next reply other threads:[~2014-07-09 12:25 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2014-07-09 12:17 Grzegorz Sikorski [this message]
2014-07-09 12:51 ` Question about data integrity on SD cards Lukáš Czerner
2014-07-09 13:23 ` Grzegorz Sikorski
2014-07-15 7:09 ` David Jander
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=53BD32D5.3000804@kelvatek.com \
--to=g.sikorski@kelvatek.com \
--cc=linux-ext4@vger.kernel.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.