Am 10.01.2013 14:23, schrieb Clemens Ladisch: > Michael Schlenker wrote: >> I'm trying to track down some lost commits [...] >> The sqlite db file and WAL/SHM files are on some automounted linux SAN >> filesystem (probably NFS beneath it) > > <http://www.sqlite.org/wal.html> says: > | WAL does not work over a network filesystem. > > Also read <http://www.sqlite.org/faq.html#q5>. > I know it is a bad/questionable idea to run things like this. But as no locking or concurrency is involved (single server process with exactly 1 connection to the DB), it should work (and does most of the time).
It actually works over a network file system in the loose sense, if that filesystem is basically just an iSCSI LUN hooked into the local system with a local filesystem applied (otherwise SQLite wouldn't work in most large VM systems, that have no local discs at all). But yes, NFS and stuff like that are making a mess more often than not. Its written in big enough letters in the docs, still people ignore it. Or don't believe the docs, as well 'only misconfigured NFS' breaks or stuff like that. So, the issue for me is, if this is really an NFS/Os Filesystem issue, or if there might be some application error. Its a matter of deeply understanding the issue and putting more drastic safeguards in place to keep people from misconfiguring things if it really is totally unreliable. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax: +49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
