php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #16221 Crash after 50-164 odbc queries on db2 dbase server
Submitted: 2002-03-22 10:31 UTC Modified: 2002-07-26 01:00 UTC
Votes:7
Avg. Score:4.4 ± 0.9
Reproduced:5 of 5 (100.0%)
Same Version:2 (40.0%)
Same OS:4 (80.0%)
From: j dot marijne at webxpose dot nl Assigned:
Status: No Feedback Package: ODBC related
PHP Version: 4.1.2 OS: Windows 2000 UK Advanced Server
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2002-03-22 10:31 UTC] j dot marijne at webxpose dot nl
After doing between 50-182 query's to IBM DB2 7 on Windows 2000 (localhost) with this script:

<?
$connection = odbc_connect( "test","db2admin", "admin" ) 
or die("Unable to connect to SQL server");
   		}
$result=odbc_exec($connection,"set current sqlid = 'DB2ADMIN'");		
		
$counter=0;
while ($counter <5000)
{
$query="select * from tms_user";
$result=odbc_exec($connection,$query);
$temp=odbc_fetch_row ($result);
echo "counter= $counter <br>";
odbc_free_result($result);
odbc_close_all();

$counter++;
}
?>

I get the following error:
Warning: SQL error: [IBM][CLI Driver][DB2/NT] SQL0954C Not enough storage is available in the application heap to process the statement. SQLSTATE=57011 , SQL state 57011 in SQLExecDirect in f:\inetpub\wwwroot\mr-sales-mysql\test.php on line 13

Warning: Supplied argument is not a valid ODBC result resource in f:\inetpub\wwwroot\mr-sales-mysql\test.php on line 14
counter= 164

If I use an odbc connection to a mysql database server, everything works fine.

Kind regards,

Joop Marijne
WebXpose
The Netherlands


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-06-17 20:44 UTC] sniper@php.net
Does this happen with this snapshot:
http://snaps.php.net/win32/php4-win32-latest.zip

 [2002-07-26 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2007-09-14 07:02 UTC] fj at hf dot hutg
http://www.meta-fx.com/
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 23:01:26 2024 UTC