Bug #51680 [Opn->Asn]: Sqlite returns without waiting for timeout

From: Date: Thu, 29 Apr 2010 19:13:40 +0000
Subject: Bug #51680 [Opn->Asn]: Sqlite returns without waiting for timeout
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-150034@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: felipe@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

« previous php.bugs (#150034) next »