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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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: Thu Apr 25 17:01:29 2024 UTC