On Tue, Jun 8, 2010 at 10:02 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> I'm not sure whether a power-cut at a particularly bad time could cause > something like this. The journaling mechanism built into SQLite should be > avoiding it, but your combination of PRAGMAs might be defeating the normal > defence mechanism. > If my combination of pragmas defeat the defense mechanisms, that would be an SQLite bug, wouldn't it? The documentation for them certainly does not suggest that there would be any loss in reliability. Can anyone confirm or deny that they might be causing a problem? I started using PRAGMA locking_mode = EXCLUSIVE and PRAGMA journal_mode = TRUNCATE because certain aggressive virus-scanners/system-software lock files when they're scanning them. With those pragmas, I can lock the database and journal once at the beginning and not worry about getting "unable to open database file" errors later. -- Daniel Stutzbach, Ph.D. President, Stutzbach Enterprises, LLC <http://stutzbachenterprises.com> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
