ID: 19416 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Informix related Operating System: Linux PHP Version: 4.2.2 New Comment:
We had the same problem here once, but in our case it was the programmers fault. He didn't know SQL to well and counted the rows using a WHILE loop instead of "SELECT COUNT(*) ...". It was a large database and when the script was used often our intranet site did not respond. I do not think, that is your problem, but could you post your - OS - INFORMIX RDBMS version (IDS, ODS, SE, ...) - SQL statement that causes the problem? I think this will help, because we encoutered problems on 7.31.UC7, which did not occur on IDS 9.2x.y. Thanks in advance! Claus Previous Comments: ------------------------------------------------------------------------ [2002-09-15 09:51:07] [EMAIL PROTECTED] When you do very much querys at the same time (or big querys with subquerys) Informix reports a Error -439 that means a SQL Query is currently running and you can`t do your query yet. Error 439 means: 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. ---snip--- so do you use a false ESQL Function? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19416&edit=1
