[php-maint] Bug#589473: php5-sqlite: sqlite3 does not provide a way to call sqlite3_busy_timeout

[Alan Chandler]

Package: php5-sqlite
Version: 5.3.2-1
Severity: wishlist

php5-sqlite does not provide anyway to call the sqlite3_busy_timeout
function.  This means that any contention (pretty well unavoidable in
a web application) causes any calls to perform a sqlite3 function to
fail immediately with an sqlite_busy error.

The sqlite3_busy_timeout provides a mechanism for lock contention to
provide a smalll wait before retrying.  This is particularly important
for locks that can be taken in the middle of an existing call (for
instance as the library tries to take a reserved lock to a pending
lock) where without the sqlite3_busy_timeout this activity would fail
and require the whole call to be backed out of and repeated.  It also means it is
necessary to build another infrastructure layer around the whole
library to intercept sqlite_busy failures and repeat them after a
small timeout.

There is already a bug report (51295) and a patch to fix this problem in the
upstream php repository - but it appears that upstream will only schedule this
for the next release of php.

http://bugs.php.net/patch-display.php?bug_id=51295&patch=php_5_3-sqlite3-busytimeout-method.patch&revision=latest




-- System Information:
Debian Release: squeeze/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.32-5-686 (SMP w/2 CPU cores)
Locale: LANG=en_GB.utf8, LC_CTYPE=en_GB.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages php5-sqlite depends on:
ii  libapache2-mod-php5 [phpapi-2 5.3.2-1    server-side, HTML-embedded scripti
ii  libc6                         2.11.2-2   Embedded GNU C Library: Shared lib
ii  libsqlite0                    2.8.17-6   SQLite shared library
ii  libsqlite3-0                  3.6.23.1-4 SQLite 3 shared library
ii  php5-cli [phpapi-20090626+lfs 5.3.2-1    command-line interpreter for the p
ii  php5-common                   5.3.2-1    Common files for packages built fr

php5-sqlite recommends no packages.

php5-sqlite suggests no packages.

-- no debconf information