Bug #51680 [Asn->Dup]: Sqlite returns without waiting for timeout
| From: | magicaltux@php.net | Date: | Mon, 07 Jun 2010 05:10:06 +0000 |
| Subject: | Bug #51680 [Asn->Dup]: Sqlite returns without waiting for timeout | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-151143@lists.php.net to get a copy of this message | ||
Edit report at http://bugs.php.net/bug.php?id=51680&edit=1
ID: 51680
Updated by: magicaltux@php.net
Reported by: ncoesel at dealogic dot nl
Summary: Sqlite returns without waiting for timeout
-Status: Assigned
+Status: Duplicate
Type: Bug
Package: SQLite related
Operating System: Linux
PHP Version: Irrelevant
Assigned To: scottmac
New Comment:
This bug is a duplicate of http://bugs.php.net/51295 (which
includes a
slightly
better way of fixing this).
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