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