Re: [sqlite] SQL error: database is locked
Thanks I'll try. -Original Message- From: Mihai Limbasan [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 4:29 PM To: [EMAIL PROTECTED]; General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: database is locked M.Kursad DARA wrote: > Hi folks, > > I want to move my sqlite db's to another location and wants to mount > on nfs. > > when i try to select some data from my sqlitedb on nfs i'm getting > error > below: > > SQL error: Database is locked. > > What's is the solution. > > Thanks. > > ps : I googled but cant find exact solution. > Hi there. The SQLite FAQ entry #5 at http://sqlite.org/faq.html#q5 has this to say: SQLite uses reader/writer locks to control access to the database. [...] *But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem.* This is because fcntl() file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS if multiple processes might try to access the file at the same time. So, basically, it's a "don't do that" situation. Try using CIFS sharing. You could search for more mentions of NFS on sqlite.org by using Google this way: http://www.google.com/search?q=nfs+site:sqlite.org HTH ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL error: database is locked
M.Kursad DARA wrote: Hi folks, I want to move my sqlite db's to another location and wants to mount on nfs. when i try to select some data from my sqlitedb on nfs i'm getting error below: SQL error: Database is locked. What's is the solution. Thanks. ps : I googled but cant find exact solution. Hi there. The SQLite FAQ entry #5 at http://sqlite.org/faq.html#q5 has this to say: SQLite uses reader/writer locks to control access to the database. [...] *But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem.* This is because fcntl() file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS if multiple processes might try to access the file at the same time. So, basically, it's a "don't do that" situation. Try using CIFS sharing. You could search for more mentions of NFS on sqlite.org by using Google this way: http://www.google.com/search?q=nfs+site:sqlite.org HTH ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQL error: database is locked
On second thought, instead of -D__DJGPP__, comment out the following lines in src/os_unix.c instead: /* #ifdef __DJGPP__ */ # define fcntl(A,B,C) 0 /* #endif */ --- Joe Wilson <[EMAIL PROTECTED]> wrote: > I suspect file locking via fcntl() is not working in your embedded libc. > > Try compiling the source code with -D__DJGPP__ which will make fcntl() a no > op. > > - Or - if that fails try compiling with -DSQLITE_LOCK_TRACE -DSQLITE_DEBUG to > see what errors it generates. > > (Don't do both at the same time) No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. http://mobile.yahoo.com/mail - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQL error: database is locked
> > 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>: > > > Dear Friends > > > Please let me know what should i do with this? > > > > > > SQLite version 3.3.13 > > > Enter ".help" for instructions > > > sqlite> create table tbl1(one varchar(10), two smallint); > > > SQL error: database is locked > > > sqlite> > > > > > > (sqlite is launched by root) I suspect file locking via fcntl() is not working in your embedded libc. Try compiling the source code with -D__DJGPP__ which will make fcntl() a no op. - Or - if that fails try compiling with -DSQLITE_LOCK_TRACE -DSQLITE_DEBUG to see what errors it generates. (Don't do both at the same time) Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQL error: database is locked
Dne úterý 27 únor 2007 16:44 anis chaaba napsal(a): > there's another process using the data base or executing a transaction No there's not. :-( I have fear, that is some bug in croscompilation. Jakub Ladman > > 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>: > > Dear Friends > > Please let me know what should i do with this? > > > > SQLite version 3.3.13 > > Enter ".help" for instructions > > sqlite> create table tbl1(one varchar(10), two smallint); > > SQL error: database is locked > > sqlite> > > > > (sqlite is launched by root) > > > > Jakub Ladman > > > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > > > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQL error: database is locked
there's another process using the data base or executing a transaction 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>: Dear Friends Please let me know what should i do with this? SQLite version 3.3.13 Enter ".help" for instructions sqlite> create table tbl1(one varchar(10), two smallint); SQL error: database is locked sqlite> (sqlite is launched by root) Jakub Ladman - To unsubscribe, send email to [EMAIL PROTECTED] -