Sqlite3 on cifs mounted share
Geert Janssens
janssens-geert at telenet.be
Fri Jan 28 07:56:41 EST 2011
Just a heads-up to the other devs: I have been investigating an issue where
GnuCash failed to load an sqlite3 based data file when this is located on a
cifs mounted share. It seems sqlite3 requires a locking mechanishm (brl) that
doesn't work in all combinations of clients and servers.
The workaround is to mount the share using the "nobrl" option of mount.cifs.
This disables the locking completely, which makes the shared file vulnerable
to corruption if modified simultaneaously by two different users. Since we
don't support that anyway (we have our own locking mechanism in place) this
doesn't really pose a problem for now.
But in case you see similar problems on the list or in bugzilla, now you know
what happens.
More details about this can be found in
https://bugzilla.gnome.org/show_bug.cgi?id=637886
I have also added an entry in our FAQ:
http://wiki.gnucash.org/wiki/FAQ#Q:_Opening_an_sqlite3_datafile_which_is_on_a_smb_network_drive_crashes_GnuCash
Geert
More information about the gnucash-devel
mailing list