#47514 [Bgs]: memory leak in PDO::prepare while using pdo_pgsql
ID: 47514 User updated by: lukasz at fsi dot pl Reported By: lukasz at fsi dot pl Status: Bogus Bug Type: PDO related Operating System: FreeBSD 6.4 PHP Version: 5.2.8 New Comment: The problem this exists in 5.2.9. I think that for some reason in my case native prepared statements are not used. Previous Comments: [2009-03-03 01:18:19] il...@php.net Thank you for taking the time to report a problem with PHP. Unfortunately you are not using a current version of PHP -- the problem might already be fixed. Please download a new PHP version from http://www.php.net/downloads.php If you are able to reproduce the bug with one of the latest versions of PHP, please change the PHP version on this bug report to the version you tested and change the status back to Open. Again, thank you for your continued support of PHP. memory usage does not appear to change is latest cvs [2009-02-26 23:25:52] lukasz at fsi dot pl Description: Calling prepare() for pdo_pgsql connection consumes memory which is never being freed. Specified query doesn't matter. It seems that this happen because in my case pdo_pgsql does not use native prepared statements, but I can't find the reason for this. I think so because calling prepare(foo) does not cause an error as it does when I use pdo_mysql. Reproduce code: --- $a = new PDO('pgsql:'.$some_pdo_pgsql_dsn); for ($i = 0; $i 100; $i++) { $st = $a-prepare(); print(memory_get_usage(true).\n); unset($st); } Expected result: constant memory usage Actual result: -- increasing memory usage -- Edit this bug report at http://bugs.php.net/?id=47514edit=1
#47514 [Bgs]: memory leak in PDO::prepare while using pdo_pgsql
ID: 47514 User updated by: lukasz at fsi dot pl Reported By: lukasz at fsi dot pl Status: Bogus Bug Type: PDO related Operating System: FreeBSD 6.4 -PHP Version: 5.2.8 +PHP Version: 5.2.9 New Comment: I've tried to change bug status to open but I can't do this. Previous Comments: [2009-03-04 18:49:48] lukasz at fsi dot pl The problem this exists in 5.2.9. I think that for some reason in my case native prepared statements are not used. [2009-03-03 01:18:19] il...@php.net Thank you for taking the time to report a problem with PHP. Unfortunately you are not using a current version of PHP -- the problem might already be fixed. Please download a new PHP version from http://www.php.net/downloads.php If you are able to reproduce the bug with one of the latest versions of PHP, please change the PHP version on this bug report to the version you tested and change the status back to Open. Again, thank you for your continued support of PHP. memory usage does not appear to change is latest cvs [2009-02-26 23:25:52] lukasz at fsi dot pl Description: Calling prepare() for pdo_pgsql connection consumes memory which is never being freed. Specified query doesn't matter. It seems that this happen because in my case pdo_pgsql does not use native prepared statements, but I can't find the reason for this. I think so because calling prepare(foo) does not cause an error as it does when I use pdo_mysql. Reproduce code: --- $a = new PDO('pgsql:'.$some_pdo_pgsql_dsn); for ($i = 0; $i 100; $i++) { $st = $a-prepare(); print(memory_get_usage(true).\n); unset($st); } Expected result: constant memory usage Actual result: -- increasing memory usage -- Edit this bug report at http://bugs.php.net/?id=47514edit=1
#47514 [NEW]: memory leak in PDO::prepare while using pdo_pgsql
From: lukasz at fsi dot pl Operating system: FreeBSD 6.4 PHP version: 5.2.8 PHP Bug Type: PDO related Bug description: memory leak in PDO::prepare while using pdo_pgsql Description: Calling prepare() for pdo_pgsql connection consumes memory which is never being freed. Specified query doesn't matter. It seems that this happen because in my case pdo_pgsql does not use native prepared statements, but I can't find the reason for this. I think so because calling prepare(foo) does not cause an error as it does when I use pdo_mysql. Reproduce code: --- $a = new PDO('pgsql:'.$some_pdo_pgsql_dsn); for ($i = 0; $i 100; $i++) { $st = $a-prepare(); print(memory_get_usage(true).\n); unset($st); } Expected result: constant memory usage Actual result: -- increasing memory usage -- Edit bug report at http://bugs.php.net/?id=47514edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=47514r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=47514r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=47514r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=47514r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47514r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=47514r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=47514r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=47514r=needscript Try newer version: http://bugs.php.net/fix.php?id=47514r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=47514r=support Expected behavior: http://bugs.php.net/fix.php?id=47514r=notwrong Not enough info: http://bugs.php.net/fix.php?id=47514r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=47514r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=47514r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47514r=php4 Daylight Savings:http://bugs.php.net/fix.php?id=47514r=dst IIS Stability: http://bugs.php.net/fix.php?id=47514r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=47514r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=47514r=float No Zend Extensions: http://bugs.php.net/fix.php?id=47514r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=47514r=mysqlcfg