Re: [sqlite] "Database is locked" error in PHP via PDO despite setting timeout

2006-03-21 Thread John Stanton
If you want to use a lightweight DB like Sqlite and you are setting up your own daemon and server situation then you can place the DB synchronization function in the daemon around the Sqlite so that its action is single streamed. In a similar situation we have installations which manage many h

Re: [sqlite] "Database is locked" error in PHP via PDO despite setting timeout

2006-03-20 Thread Mark Robson
On Monday 20 March 2006 11:47, [EMAIL PROTECTED] wrote: > BTW: Lots of people have multiple processes writing to the same > SQLite database without problems - the SQLite website is a good > example. I do not know what you are doing wrong to get the > locking problems you are experiencing. I don't

Re: [sqlite] "Database is locked" error in PHP via PDO despite setting timeout

2006-03-20 Thread Roger
What i normally do in this scenario is just a simple httpd service restart. That normally does the trick because i am building an application also with PHP/Sqlite. On Mon, 2006-03-20 at 06:47 -0500, [EMAIL PROTECTED] wrote: > Mark Robson <[EMAIL PROTECTED]> wrote: > > > > If the answer is "noth

Re: [sqlite] "Database is locked" error in PHP via PDO despite setting timeout

2006-03-20 Thread drh
Mark Robson <[EMAIL PROTECTED]> wrote: > > If the answer is "nothing", I'm going straight over to MySQL :) > The advantages of SQLite are that there are no administrative hassles - there is nothing to set up or configure and the database is contained in a single disk file that you can copy to a

[sqlite] "Database is locked" error in PHP via PDO despite setting timeout

2006-03-19 Thread Mark Robson
Hi all, I'm using Sqlite3 from PHP via PDO. My application was working fine as long as there was only one process accessing the database, then I ran two instances at once. Now one of the processes is getting "Error message: SQLSTATE[HY000]: General error: 5 database is locked" when trying to