From: shizius at hotmail dot com
Operating system: Windows XP, 2K, 2003
PHP version: 5.1.3
PHP Bug Type: InterBase related
Bug description: Interbase Library Causes Firebird instability under load
Description:
------------
Using the php_interbase.dll extension causes Firebird instability
(Crashes, Deadlocks, and BUGCHECKs).
I tried Firebird 1.5.2, Firbeird 1.5.3 and Firebird 2.0 RC1
I tried PHP 5.1.2, PHP 5.0.5
It happens most often while PHP is running as an Apache2 module. It
happens less often, but still happens, when
PHP is running as a CGI under Apache2
I believe it is a thread-safety issue in the
php_interbase.dll or in the gds32.dll that comes with PHP.
I tried using the GDS32.dll from Firebird, and it has similar
problems.
I know that this is a problem either with php_interbase.dll
or with gds32.dll because when I use ODBC to connect to
firebird everything works great.
Reproduce code:
---------------
The database has to be under heavy load to reproduce this.
I have 50-200 simultaneous connections to the database with
a combination of read-only and write transactions and a lot
data going back and forth.
Expected result:
----------------
I expect the native access method to firebird to be stable.
Actual result:
--------------
I get BUGCHEKs, CRASHES, and unexplained DEADLOCKS.
FB2.0 RC1:
PDD-STANK (Server) Wed May 03 21:04:29 2006
Database: C:\DB.FDB
internal gds software consistency check (invalid SEND request (167),
file: exe.cpp line: 494)
FB 1.5.3:
PDD-STANK (Server) Tue Apr 18 16:46:58 2006
Database: C:\DB.FDB
internal gds software consistency check (invalid SEND request (167))
PDD-STANK (Client) Tue Apr 18 18:13:03 2006
C:\Firebird\bin\fbserver.exe: terminated abnormally (4294967295)
--
Edit bug report at http://bugs.php.net/?id=37312&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=37312&r=trysnapshot44
Try a CVS snapshot (PHP 5.1):
http://bugs.php.net/fix.php?id=37312&r=trysnapshot51
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=37312&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37312&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=37312&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37312&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37312&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37312&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37312&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37312&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=37312&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=37312&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37312&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37312&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37312&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37312&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37312&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37312&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37312&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37312&r=mysqlcfg
