#37312 [NEW]: Interbase Library Causes Firebird instability under load

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