Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:47254
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain zend.com designates 212.25.124.185 as permitted sender)
Message-ID: <4B9C96E2.8060500@zend.com>
Date: Sun, 14 Mar 2010 09:57:22 +0200
User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706)
MIME-Version: 1.0
To: Mark Karpeles <mark@hell.ne.jp>
CC: PHP Developers Mailing List <internals@lists.php.net>
References: <1268552350.11885.76099.camel@localhost>
In-Reply-To: <1268552350.11885.76099.camel@localhost>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] Req #51295: busyTimeout method for SQLite3
From: jess@zend.com (Jess Portnoy)

Hello Mark,

Note that while indeed sqlite3_busy_timeout() is not extended by the 
SQLite3 and PDO_SQLITE extensions, it is called internally in 
ext/pdo_sqlite/sqlite_driver.c.
I think it is a good idea to extend it but also, that if you do, it 
should probably also be done for PDO_SQLITE as it may be useful there as 
well.

May the source be with you,
Best regards,
Jess Portnoy



Mark Karpeles wrote:
> Hello,
>
> I've been encountering a problem with SELECT queries and SQLite3 as load
> was growing on my system. From times to times I was getting this error:
>
> Warning: SQLite3Stmt::execute(): Unable to execute statement: database
> is locked
>
> After searching on google I saw I should call sqlite3_busy_timeout() and
> found out that there was no way to call it from the SQLite3 extension
> (which is new to PHP 5.3.x).
>
> Here's a patch that will add this method to the SQLite3 class:
>
> http://bugs.php.net/51295
> https://ookoo.org/svn/snip/php_5_3-sqlite3-busytimeout-method.patch
>
> Any comment welcome.
>
>
> Mark
>
>
>