Comment 8 for bug 117730

dkg (dkg0) wrote :

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