I created the database like this: echo 'create table foo (x int); insert into foo (x) values (1);' | sqlite3 testdb
and tested it like this: echo 'select * from foo;' | sqlite3 testdb This worked fine on a tmpfs, but not on a cifsmount. I've tested this against a debian etch samba version (3.0.24-6etch9) -- previous versions seem to fail as well, but the etch version of samba is the most recent i've tested. [0 [EMAIL PROTECTED] ~]$ mount | egrep '/(tmp|mnt)' /tmp on /tmp type tmpfs (rw,nosuid,nodev) //bob/dmz on /mnt type cifs (rw,mand,unc=\\bob\dmz,username=,uid=1000,posixpaths,rsize=16384,wsize=57344) [0 [EMAIL PROTECTED] ~]$ rm -f /tmp/testdb [0 [EMAIL PROTECTED] ~]$ echo 'create table foo (x int); insert into foo (x) values (1);' | sqlite3 /tmp/testdb [0 [EMAIL PROTECTED] ~]$ echo 'select * from foo;' | sqlite3 /tmp/testdb 1 [0 [EMAIL PROTECTED] ~]$ cp /tmp/testdb /mnt/testdb cp: overwrite `/mnt/testdb'? y [0 [EMAIL PROTECTED] ~]$ echo 'select * from foo;' | sqlite3 /mnt/testdb 1 [0 [EMAIL PROTECTED] ~]$ echo 'insert into foo (x) values (2);' | sqlite3 /mnt/testdb SQL error near line 1: database is locked [1 [EMAIL PROTECTED] ~]$ -- cannot use sqlite3 on cifs mount https://bugs.launchpad.net/bugs/117730 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to samba in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
