Informix Issue

GaryC

We have developed a PHP application that accesses an Informix database. We are using Apache 2.0.46 with PHP 4.3.2 running on RedHat Linux 8 and connecting to an Informix Standard engine version 7.2 (running on HP-UX 10.2 server).

Within parts of the PHP scripts we have declared cursors to loop round the data performing various calculations. We have noticed that if the number of records processed is large then we get the following PHP error, repeated for every iteration after the error occurs:

Warning: ifx_query(): Open cursor fails ( [SQLSTATE=00 000 SQLCODE=-242]) in /var/www/includefiles/ifx_ddlfunctions.inc on line 58

Line 58 has the ifx_query statement in it to perform the select.

It appears that we are exceeding some limit but do not understand what this limit can be. We can probably mask the issue programtically but we really need to resolve it properly.

Any advice you may be able to give would be greatly appreciated.

Sxooter

That's an error directly from the database, i.e. PHP isn't at fault here.

You might wanna check with the folks you get your database from (Informix) to see if it's a known issue.

Can you reproduce this failure from a SQL monitor (I assume Informix has some kind of interactive query program thingie...)???

marschen

$ finderr 242
-242 Could not open database table table-name.

The database server cannot begin reading a table. Check the
accompanying ISAM error code for more information. The problem might be
file permissions, a hardware error, or a corrupted system catalog.
Unless the ISAM error code or an operating-system message points to
another cause, run the bcheck or secheck utility to verify file
integrity.

what we encountered mostly in php + informix
is that we did not close cursor correctly
that run out of DB resource!!!

$DbObj=ifx_pconnect("stores7@ifx1","informix","ifxpass");
$SQL="select * from customers" ;
$oRs=ifx_prepare($SQL,$DbObj);
ifx_do($oRs);
$array1=ifx_fetch_row($oRs,"next");
while() .....
ifx_free_result($oRs);

if you are positive it is not timeout issue of apache webpage
try the preceding sample , make the table large
see what happen ??? be careful of cursor free !!!!