[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

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, > &g

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

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

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

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

Re: [sqlite] SQL error: database is locked

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

Re: [sqlite] SQL error: database is locked

2007-02-27 Thread anis chaaba
two smallint); SQL error: database is locked sqlite> (sqlite is launched by root) Jakub Ladman - To unsubscribe, send email to [EMAIL PROTECTED] -

[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