From: gemery at bmihs dot co dot uk Operating system: RedHat Linux 8 PHP version: 4.3.3 PHP Bug Type: Informix related Bug description: Sporadic -439 errors on ifx_connect()
Description: ------------ This problem has been around for quite some time. The system will run fine for some time, then will suddenly start to throw these errors: [error] PHP Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-439] in /var/www/html/casetrack/login.php on line 60, and [error] PHP Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-439] in /var/www/html/appointments/functions.php on line 41 for some time. The system will eventually settle down again, and a restart of apache will always sort the problem out. 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. I'm running php with this configure: './configure' '--with-informix=/opt/informix' '--with-apxs' '--prefix=/opt/php' '--enable-track-vars' '--enable-magic-quotes' against apache 1.3.23 IDS 7.31, ESQL/C version 9.5 Reproduce code: --------------- I'm afraid I can't reproduce this without running our live system. The best I can come up with is: $connection = ifx_connect($db,$user,$pass); Expected result: ---------------- Successful connection Actual result: -------------- [error] PHP Warning: ifx_connect(): E [SQLSTATE=IX 000 SQLCODE=-439] in blah.php on line 1 -- Edit bug report at http://bugs.php.net/?id=26608&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=26608&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=26608&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=26608&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=26608&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=26608&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=26608&r=needscript Try newer version: http://bugs.php.net/fix.php?id=26608&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=26608&r=support Expected behavior: http://bugs.php.net/fix.php?id=26608&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=26608&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=26608&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=26608&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=26608&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=26608&r=dst IIS Stability: http://bugs.php.net/fix.php?id=26608&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=26608&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=26608&r=float