php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #19416 unproperly use of the ESQL Library?
Submitted: 2002-09-15 09:51 UTC Modified: 2003-01-15 20:56 UTC
Votes:2
Avg. Score:3.0 ± 1.0
Reproduced:2 of 2 (100.0%)
Same Version:1 (50.0%)
Same OS:1 (50.0%)
From: phantom at h07 dot org Assigned:
Status: Not a bug Package: Informix related
PHP Version: 4.2.2 OS: Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2002-09-15 09:51 UTC] phantom at h07 dot org 
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?

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-10-18 08:24 UTC] cvb at clausvb dot de 
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
 [2003-01-15 20:56 UTC] iliaa@php.net 
Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions. 

Thank you for your interest in PHP.

Read above message for explanation.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 26 05:01:30 2024 UTC