From: roche dot mathieu at free dot fr Operating system: linux debian 3.0 kernel 2.4.18 PHP version: 4.3.5 PHP Bug Type: Informix related Bug description: random -439 errors on ifx_connect()
Description: ------------ The system will run fine for some time, then will suddenly start to throw these errors: [13-Apr-2004 12:07:42] PHP Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE= -439] in /data/site-ACA/librairies/lib_db.php3 on line 41 [13-Apr-2004 12:07:54] PHP Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE= -439] in /data/site-ACA/librairies/lib_db.php3 on line 41 ... A restart of apache will always solve the problem I'm running php with this configure: './configure' '--with-informix=yes' '--with-apache=../apache_1.3.29' '--enable-track-vars' '--enable-sockets' '--enable-wddx' '--with-xmlrpc' '--enable-xslt' '--with-xslt-sablot=/usr/local/' '--with-expat-dir=/usr/local' '--with-iconv-dir=/usr/local/' on apache 1.3.29. Informix SDK: 2.81UC3 Informix Dynamic Server: 9.30.UC1 This is the description of that error from informix: -439 Database server is currently processing an SQL task. You attempted to call an SQL routine or attempted to execute an SQL statement within a signal handling function/routine or a callback function/procedure. Use only the sqldone() and sqlbreak() library functions inside your IBM Informix ESQL/C callback function. Use only the ECO-SQD and ECO-SQB library routines inside your ESQL/COBOL callback procedure. In addition, if you want to unregister your callback function in IBM Informix ESQL/C, you can invoke the sqlbreakcallback() callback registration function within your callback procedure. If you want to unregister your callback procedure in ESQL/COBOL, you can invoke the ECO-SQBCB callback registration routine within your callback procedure. Reproduce code: --------------- I'm sorry i can't reproduce this without running my live system. The best I can come up with is: $connection = ifx_connect($db,$user,$pass); Expected result: ---------------- Successful connection Actual result: -------------- [13-Apr-2004 12:07:54] PHP Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE= -439] in /data/site-ACA/librairies/lib_db.php3 on line 41 -- Edit bug report at http://bugs.php.net/?id=27973&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27973&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27973&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=27973&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=27973&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=27973&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=27973&r=needscript Try newer version: http://bugs.php.net/fix.php?id=27973&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=27973&r=support Expected behavior: http://bugs.php.net/fix.php?id=27973&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=27973&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=27973&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=27973&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27973&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=27973&r=dst IIS Stability: http://bugs.php.net/fix.php?id=27973&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=27973&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=27973&r=float
