We have also run into this problem with our installations. We have over 300 workstations at our university, all have CIFS-mounted home directories. So far we managed to somehow avoid using any applications that used SQLite, but now with Firefox3 using it we are in a very difficult situation.
As a temporary measure we use a custom compiled SQLite library with the -DSQLITE_DISABLE_DIRSYNC=1 flag enabled, as per advice in http://sqlite.org/cvstrac/tktview?tn=1751
Of course this makes all the databases sensitive to data corruption.
We have also run into this problem with our installations. We have over 300 workstations at our university, all have CIFS-mounted home directories. So far we managed to somehow avoid using any applications that used SQLite, but now with Firefox3 using it we are in a very difficult situation.
As a temporary measure we use a custom compiled SQLite library with the -DSQLITE_ DISABLE_ DIRSYNC= 1 flag enabled, as per advice in http:// sqlite. org/cvstrac/ tktview? tn=1751
Of course this makes all the databases sensitive to data corruption.