#20999 [Asn->Ana]: memory leak when using DB interface

ID: 20999 Updated by: lsmith@php.net Reported By: dinoklein at hotmail dot com -Status: Assigned +Status: Analyzed Bug Type: PEAR related Operating System: Linux 2.4 PHP Version: 4.3.0RC3 -Assigned To: lsmith +Assigned To: ssb New Comment: My wild guess is that this is related to http://bugs.php.net/bug.php?id=18494 Previous Comments: ------------------------------------------------------------------------ [2003-04-28 04:00:26] arnaud@php.net changing status ------------------------------------------------------------------------ [2002-12-13 14:49:32] dinoklein at hotmail dot com By running the code below, both the http process executing the script, and the php binary (when run on the command line), grow in memory size. In the case of the http module, the memory is not freed once the script has terminated. This happens when using MySQL as the backend, and with PgSQL. This does not happen when I use the pg_* functions directly. I have not tested mysql_*. <?php require 'DB.php'; function db_connect() { //$dsn = 'pgsql://dinoklein@unix+localhost/unicode'; $dsn = 'mysql://test@unix+localhost/test'; return DB::Connect($dsn); } header('Content-Type: text/html'); $db = db_connect(); $sql_ins = 'insert into ttable values (?)'; for ($i=0; $i<25000; $i++) { echo "doing $i\n"; $ret = $db->query($sql_ins, array("code $i")); if (DB::isError($ret)) { echo "error on insert\n"; break; } } $db->disconnect(); ?> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20999&edit=1