#27973 [Opn->Bgs]: random -439 errors on ifx_connect()

ID: 27973 Updated by: derick@php.net Reported By: roche dot mathieu at free dot fr -Status: Open +Status: Bogus Bug Type: Informix related Operating System: linux debian 3.0 kernel 2.4.18 PHP Version: 4.3.5 New Comment: Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Thank you for your interest in PHP. Please search the bug database first before posting. Previous Comments: ------------------------------------------------------------------------ [2004-04-13 07:23:24] roche dot mathieu at free dot fr 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 this bug report at http://bugs.php.net/?id=27973&edit=1