> -----Original Message-----
> From: sqlite-users-boun...@sqlite.org 
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
> Sent: Friday, October 24, 2014 4:45 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] quasi-bug related to locking,and 
> attached databases....
> Not gonna ask for this since you've now given enough info for 
> someone to reproduce and test the issue.  They might come 
> back asking for further information but I'll leave that up to 
> the experts.
> Simon.

Alas, but I'm going to offer it, haha.  OK, it happens on Linux, too:

login as: person
person@'s password:
Access denied
person@'s password:
Last login: Thu Oct 23 22:24:23 2014
[person@localhost ~]$ which sqlite3
[person@localhost ~]$ sqlite3 db1.db
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> create table dest ( name text, value text );
sqlite> create table source ( name text, value text );
sqlite> insert into source ( name, value ) values ( 'allow', 'yes' );
sqlite> .exit
[person@localhost ~]$ sqlite3 db1.db
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> attach database 'db1.db' as aux;
sqlite> .databases
seq  name             file
---  ---------------
0    main             /home/person/db1.db
2    aux              /home/person/db1.db
sqlite> insert or replace into main.dest ( name, value ) values
   ...> ('allow',(select value from aux.source where name = 'allow'));
SQL error: database is locked

Looking forward to hearing back from folks.  Maybe I should have put this
thread on 'dev', too, so I am dong so now.  (Dev q.v. thread on users for
context -- it's short)


sqlite-users mailing list

Reply via email to