[sqlite] SQL error: database is locked

2008-07-09 Thread Shain Lee
Hi I am using sqlite in Fedora 9. Database created and done every thing perfectly. But when i going to test the DB via small transactions , inserting of records are failing. SQL error: database is locked DBD::SQLite::db commit failed: database is locked(5) at dbdimp.c line 218 at db_access.pl

Re: [sqlite] SQL error: database is locked

2008-06-04 Thread M.Kursad DARA
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, >

Re: [sqlite] SQL error: database is locked

2008-06-04 Thread Mihai Limbasan
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 exa

[sqlite] SQL error: database is locked

2008-06-04 Thread M.Kursad DARA
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. M.Kursa

Re: [sqlite] SQL error: database is locked

2007-02-27 Thread Joe Wilson
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 comp

Re: [sqlite] SQL error: database is locked

2007-02-27 Thread Joe Wilson
> > 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 > > > s

Re: [sqlite] SQL error: database is locked

2007-02-27 Thread Jakub Ladman
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

Re: [sqlite] SQL error: database is locked

2007-02-27 Thread anis chaaba
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 err

[sqlite] SQL error: database is locked

2007-02-27 Thread Jakub Ladman
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 ---