Bug #11832 Updated: memory exhausted error
| From: | derick@php.net | Date: | Mon, 02 Jul 2001 10:23:28 +0000 |
| Subject: | Bug #11832 Updated: memory exhausted error | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-58663@lists.php.net to get a copy of this message | ||
ID: 11832
Updated by: derick
Reported By: fb@esc-electronics.de
Old-Status: Open
Status: Feedback
Bug Type: *General Issues
Operating system:
PHP Version: 4.0.6
Assigned To:
Comments:
This does look like a normal thing. Your script simply uses too mch memory.
Can you increase the memory_limit to a higher value:
memory_limit = 16M
This should solve the problem if you are fetching too much rows.
Derick
Previous Comments:
---------------------------------------------------------------------------
[2001-07-02 06:20:46] fb@esc-electronics.de
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 9 bytes) in
[somewhere]/mysql.php on line 8
Apache 1.3.19, PHP 4.0.6 configured with:
./configure --prefix=/opt/php4 --with-apxs=/opt/apache/bin/apxs --with-pgsql=/opt/pgsql
--with-mysql=/opt/mysql/ --with-openssl=/usr/local/ssl/ --with-imap=/opt/imap --with-gettext
--with-zlib --with-dom --with-gd --enable-gd-imgstrttf --enable-inline-optimization --with-xml
--with-ttf --with-gdbm --with-mm --enable-versioning --enable-trans-sid --enable-magic-quotes
--enable-safe-mode --enable-sockets --enable-sysvsem --enable-sysvshm --enable-shmop
--enable-calendar --enable-exif --enable-memory-limit
Might "--enable-memory-limit" be the culprit?
(It's a production system and I can not play much with it)
mysql.php worked correctly with php 4.0.5
mysql.php:
<?php
function getData($query)
{
global $host, $user, $password, $db;
//echo $query."<br>";
$conn = mysql_connect ($host, $user, $password);
$result = mysql_db_query($db, $query);
while($row = mysql_fetch_array($result))
$aux[] = $row;
mysql_free_result($result);
return $aux;
};
function putData($query)
{
global $host, $user, $password, $db;
$conn = mysql_connect ($host, $user, $password);
$result = mysql_db_query($db, $query);
return $query;
};
?>
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11832&edit=2