Edit report at http://bugs.php.net/bug.php?id=51680&edit=1

 ID:               51680
 Updated by:       fel...@php.net
 Reported by:      ncoesel at dealogic dot nl
 Summary:          Sqlite returns without waiting for timeout
-Status:           Open
+Status:           Assigned
 Type:             Bug
 Package:          SQLite related
 Operating System: Linux
 PHP Version:      Irrelevant
-Assigned To:      
+Assigned To:      scottmac



Previous Comments:
------------------------------------------------------------------------
[2010-04-28 10:49:22] ncoesel at dealogic dot nl

Description:
------------
Sqlite has a protection mechanism that prevents firing two (or) more
queries from the same process and wait for the database to become
available. 



The typical behaviour is that every now and then (depending on the
database load) a query exits immediately with "SQLSTATE[HY000]: General
error: 5 database is locked". Setting other busy timeout values doesn't
help.



I've attached a patch that solves the problem unless the database is
locked for a very long time (as usual some error . The patch is created
for an older version of PHP. I've checked the latest CVS version and I'm
quite sure the patch will still apply.



------------------------------------------------------------------------



-- 
Edit this bug report at http://bugs.php.net/bug.php?id=51680&edit=1

Reply via email to