php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #27973 random -439 errors on ifx_connect()
Submitted: 2004-04-13 07:23 UTC Modified: 2004-04-13 08:32 UTC
From: roche dot mathieu at free dot fr Assigned:
Status: Not a bug Package: Informix related
PHP Version: 4.3.5 OS: linux debian 3.0 kernel 2.4.18
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: roche dot mathieu at free dot fr
New email:
PHP Version: OS:

 

 [2004-04-13 07:23 UTC] 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


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-04-13 08:32 UTC] derick@php.net
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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun May 05 09:01:30 2024 UTC