From: Operating system: Linux PHP version: Irrelevant Package: SQLite related Bug Type: Bug Bug description:Sqlite returns without waiting for timeout
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 bug report at http://bugs.php.net/bug.php?id=51680&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=51680&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=51680&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=51680&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=51680&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=51680&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=51680&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=51680&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=51680&r=needscript Try newer version: http://bugs.php.net/fix.php?id=51680&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=51680&r=support Expected behavior: http://bugs.php.net/fix.php?id=51680&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=51680&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=51680&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=51680&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=51680&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=51680&r=dst IIS Stability: http://bugs.php.net/fix.php?id=51680&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=51680&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=51680&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=51680&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=51680&r=mysqlcfg