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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
