Can anybody offer suggestions for solving a problem that appears to
be a memory issue when connecting to a mysql database since the
latest php update?
We generate a report that is ridiculously complex and requires a
boat-load of database queries. PHP crashes every time since the
upgrade to 4.06 from 4.04pl1.
Here is the scoop, I am happy to include any additional
information that may be helpful:
--The script tanks after the 34th query, at which point it begins
displaying:
"Supplied argument is not a valid MySQL result resource."
--We have tried the script using:
*one connection for the entire script (mysql_pconnect)
*recalling mysql_pconnect() before every query without mysql_close()
*new connections for every query (mysql_connect...mysql_close)
--Same outcome with Mysql versions 3.23.39, 3.23.38 and 3.23.28
--Works perfectly well in PHP 4.04pl1, but not at all 4.06
--Debug logs repeatedly contain two messages:
FATAL: erealloc(): Unable to allocate 1515870836 bytes
[Wed Jul 11 09:12:17 2001] [notice] child pid 16719 exit signal
Segmentation
fault (11)
- ---------------------------------------
./zend_execute.c(358) : Block 0x083FFD78 status:
zend_variables.c(62) : Actual location (location was relayed)
Beginning: OK (allocated on zend_API.c:379, 10 bytes)
End: Overflown (magic=0x2A8FCC82 instead of 0x2A8FCC84)
1 byte(s) overflown
- ---------------------------------------
Thank you for your time and help,
Chris Chew