#26608 [NEW]: Sporadic -439 errors on ifx_connect()

From: Date: Fri, 12 Dec 2003 17:55:13 +0000
Subject: #26608 [NEW]: Sporadic -439 errors on ifx_connect()
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-52001@lists.php.net to get a copy of this message 
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

Thread (15 messages)

« previous php.bugs (#52001) next »