#45671 [NEW]: nextRowset/closeCursor memory issues

From: dejuannonley at yahoo dot com Operating system: Win/Lin PHP version: 5.2.6 PHP Bug Type: PDO related Bug description: nextRowset/closeCursor memory issues Description: ------------ Multiple calls to nextRowset() or closeCursor() (only for PDO drivers that support nextRowset()) greatly increases memory allocation to the script. I've confirmed this problem with PHP 5.2.x and 6. These results are from using PDO_ODBC with MS-SQL 2005. PDO_MYSQL and PDO_SQLITE would return 512 KiB no matter how many SELECT statements are run because they don't support nextRowset(). Reproduce code: --------------- for ($i=0; $i<1000; $i++) { $result = $conn->query('SELECT * FROM foo'); $result->closeCursor(); } $mem = memory_get_peak_usage(true) / 1024; echo $mem; // Following run in a separate script to reset mem usage for ($i=0; $i<100000; $i++) { $result = $conn->query('SELECT * FROM foo'); $result->closeCursor(); } $mem = memory_get_peak_usage(true) / 1024; echo $mem; Expected result: ---------------- 512 512 Actual result: -------------- 1536 111872 -- Edit bug report at http://bugs.php.net/?id=45671&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=45671&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=45671&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=45671&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=45671&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=45671&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=45671&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=45671&r=needscript Try newer version: http://bugs.php.net/fix.php?id=45671&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=45671&r=support Expected behavior: http://bugs.php.net/fix.php?id=45671&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=45671&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=45671&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=45671&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=45671&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=45671&r=dst IIS Stability: http://bugs.php.net/fix.php?id=45671&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=45671&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=45671&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=45671&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=45671&r=mysqlcfg