-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 09/06/2015 10:20 AM, Markus Weiland wrote: > I see. Since this was working under Ubuntu 14.04, I assume this is > a regression with gvfs. I'll check over there.
Nope. SQLite can not maintain data integrity when used with *any* network filesystem. Sometimes it is able to detect problems, and give an error message. And other times you will end up with database corruption. Then you'll post to this list, and we'll tell you not to use network filesystems. The only variable is how long it takes before you eventually find out about the corruption. Sometimes people also come up with various schemes that appear to work, but they won't always. Even something as simple as opening the database for reading only can be very complex - such as if the database wasn't cleanly committed (eg program crashed) - because journals have to be examined and played back/undone as appropriate. That involves two or more files, various forms of locking etc - just the things that are problems with networked filesystems. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlXsncIACgkQmOOfHg372QTweACeORy+Jpo6V4LDY3NXvU0iZ7G4 nW4AnA1ugTztFbRyQOHzhMJsQ8b54F7T =uuQw -----END PGP SIGNATURE-----
