Bug #16221: Crash after 50-164 odbc queries on db2 dbase server

From: j.marijne@webxpose.nl Operating system: Windows 2000 UK Advanced Server PHP version: 4.1.2 PHP Bug Type: Reproducible crash Bug description: Crash after 50-164 odbc queries on db2 dbase server 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 -- Edit bug report at http://bugs.php.net/?id=16221&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=16221&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=16221&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16221&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16221&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16221&r=support Expected behavior: http://bugs.php.net/fix.php?id=16221&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16221&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16221&r=submittedtwice