From: donnie dot rivera at doc dot state dot co dot us
Operating system: Solaris 5.6
PHP version: Irrelevant
PHP Bug Type: Informix related
Bug description: Informix error -439
Description:
------------
Our current production environment is as follows:
Apache 1.3.26
PHP 4.2.3
Informix 7.24 UC8
About a year ago, we went into production with our Intranet web site.
Initially we ran into the Informix error -439, which we were able to
control by starting and stopping Apache every six hours. This seemed to
resolve the problem, but now it is recurring again. Has anybody resolved
what the problem is? We have an instance of Informix 9.30.UC3, but do not
know if this will resolve the problem. Also, we were wondering if the PHP
php_ifx.dll has been update with the newer versions. Our long term goal is
to migrate to DB2, but take considerable time to accomplish. Any
suggestions on how to resolve this problem would be greatly appreciated.
Thanks,
Donnie Rivera
Reproduce code:
---------------
ifx_query("SELECT * FROM ANNOUNCEMENT", $id);
Expected result:
----------------
25 records
Actual result:
--------------
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 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 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.
--
Edit bug report at http://bugs.php.net/?id=25889&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25889&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25889&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=25889&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=25889&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=25889&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=25889&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=25889&r=support
Expected behavior: http://bugs.php.net/fix.php?id=25889&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=25889&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=25889&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=25889&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25889&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=25889&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=25889&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=25889&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=25889&r=float
