[Bug 117730] Re: cannot use sqlite3 on cifs mount

[dkg]

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 dkg at squeak ~]$ 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 dkg at squeak ~]$ rm -f /tmp/testdb 
[0 dkg at squeak ~]$ echo 'create table foo (x int); insert into foo (x) values (1);' | sqlite3 /tmp/testdb
[0 dkg at squeak ~]$ echo 'select * from foo;' | sqlite3 /tmp/testdb
1
[0 dkg at squeak ~]$ cp /tmp/testdb /mnt/testdb
cp: overwrite `/mnt/testdb'? y
[0 dkg at squeak ~]$ echo 'select * from foo;' | sqlite3 /mnt/testdb
1
[0 dkg at squeak ~]$ echo 'insert into foo (x) values (2);' | sqlite3 /mnt/testdb
SQL error near line 1: database is locked
[1 dkg at squeak ~]$

-- 
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.