PHP and Informix Error -439

cjnoll

We have an Intranet that serves over 3000 users. We have been up in Production status for a week and today we are now getting Informix -439 errors randomly. I suspect we either have a bug in the code that tracks session information or could it be a configuration issue. We are running Apache (v1.3.26) and PHP (v4.2.3) on a Solaris 280R (v5.8).

Any suggestions are appreciated.

=========== -439 error ===============
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.
=========== -439 error ===============

marschen

Hi ~

May I ask if the problem solved ???
what version of IDS engine you are using ????

I now run IDS 7.31 UD2 in RedHat 7.3
seems work perfect ~~~~

you use ifx_pconnect or ifx_connect ????

cjnoll

We "resolved" the problem by stopping and restarting Apache at midnight each night.

We are running Informix 7.24 UC8.
We use ifx_connect instead of ifx_pconnect.
Have you an opinion on the use of ifx_connect versus ifx_pconnect?
Thanks,
Chuck

marschen

Hi ~~~

Pconnect will use connction pool for Informix connections
so you wont need to call ifx_close for each php
it is fast , while many connections created in connection pool,
it won't create unless suddenly much more connections needed
over the connection pool have ~~
( I know my english is poor ^⁾

I think you might be interested in MaxKeepAliveRequests
in /usr/local/apache/conf/httpd.conf
As I remember I have encountered the same problem with you
but the case is different , I use pconnect so that it is important
to me ~~~ in your case , I dont know~~ ~