-439

Hi all Informix users, Does anybody knows what this SQL code error mean ? -439 : Database server is currently processing SQL task. I have an internet server and sometimes it can't be reached or is too long to respond and returns this code. by using finderr -439, it returns that is follow -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 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. our spec are OS version : SunOS 5.7 sun4u sparc SUNW,Ultra-60 INFORMIX server engine version : Informix Dynamic Server Version 9.30.UC1 CSDK version : 2.81 UC1 and 2.60 PHP version : 4.0.6 Apache version : 1.3.23

On Tue, 19 Aug 2003 09:33:31 -0400, St'''fan L wrote: Your app probably has a SIGALARM() timeout handler that is trying to detach from the engine before exiting with a DISCONNECT statement but the engine cannot respond because it is busy with the long running statement that caused the timeout. The timeout handler has to execute the sqlbreak() ESQL/C function to terminate the current statement which will return with a -613 error. Then either the handler can DISCONNECT directly or just return and let the mainline code handle the -613 as a timeout and exit gracefully. Your choice. Art S. Kagel > Hi all Informix users, > > Does anybody knows what this SQL code error mean ? > > -439 : Database server is currently processing SQL task. > > I have an internet server and sometimes it can't be reached or is too > long to respond and returns this code. > > by using finderr -439, it returns that is follow > > -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 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. > > our spec are > OS version : SunOS 5.7 sun4u sparc SUNW,Ultra-60 INFORMIX server engine > version : Informix Dynamic Server Version 9.30.UC1 CSDK version : 2.81 > UC1 and 2.60 > PHP version : 4.0.6 > Apache version : 1.3.23