PHP 4.0 Bug #6798: IFX queries fail, SQLCODE -480 (dup. descriptors)
| From: | jim at ark dot org | Date: | Mon, 18 Sep 2000 04:40:38 +0000 |
| Subject: | PHP 4.0 Bug #6798: IFX queries fail, SQLCODE -480 (dup. descriptors) | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-33419@lists.php.net to get a copy of this message | ||
From: jim@ark.org
Operating system: Solaris 2.5.1
PHP version: 4.0.2
PHP Bug Type: Informix related
Bug description: IFX queries fail, SQLCODE -480 (dup. descriptors)
Setup: PHP 4.0.2 running under Netscape Enterprise 3.6SP1 on a Solaris 2.5.1/SPARC server.
Informix-SE v7.23.UC9, Informix ESQL/C 7.24.UC7.
My $INFORMIXDIR/etc/sqlhosts entry for the database looks like this:
foo_se seipcpip foo sqlexec
(which works under other langs)
There are no non-default ifx.* entries in my php.ini file.
After connecting to database foo, the first sql query fails consistently every other time, with
SQLCODE -480. I get the following error:
<b>Warning</b>: Allocate desciptor <descrpb> fails (E [SQLSTATE=IX 000
SQLCODE=-480]) in <b>/web/shtml/development/esd/unempins/emps.php</b> on line
<b>275</b><br>
Invalid query SELECT * FROM emps WHERE esdid=123456789
and the script quits. I looked up -480 and it means that a duplicate descriptor already exists.
I'm closing all my db connections so I don't know why this is happening (I did read the
prior bug report about when Zend really releases the resource).