#19796 [Opn->Fbk]: Oracle query in array, returned by function: memory leak (no more high CPU load)

ID: 19796 Updated by: sniper@php.net Reported By: gko@gko.net -Status: Open +Status: Feedback Bug Type: Performance problem Operating System: Digital Unix V4.0F PHP Version: 4.2.3 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2002-10-10 15:52:18] gko@gko.net With 4.2.3, the link with Oracle seems to have some problems as the server looks less responsive and with many queries, I have "arithmeric exceptions" in error_log of httpd so I'm going back to 4.0.4pl1 and its high CPU load... ------------------------------------------------------------------------ [2002-10-09 13:11:15] gko@gko.net What I'm wondering is wheter the memory is going to be given back to the system if it needs it ? With 4.0.4pl1, the VSZ/RSS numbers were above 150 M and never shrunk, which worried the system maintenance staff. I know such memory readings have to be carefully interpreted but it's still troubling... ------------------------------------------------------------------------ [2002-10-09 11:18:34] gko@gko.net Does this 'latest' version fix some items that could be related to my problems? ------------------------------------------------------------------------ [2002-10-09 09:38:30] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-10-09 04:43:15] gko@gko.net I have compiled PHP 4.2.3 (was 4.0.4pl1) and tested my code: the high CPU load after code execution is no more there, but there is still memory leak: before: nobody 19621 0.0 0.0 14.3M 560K ?? S 16:32:09 0:00.00 /www/bin/httpd after: nobody 19621 0.0 0.9 50.3M 37M ?? S 16:32:09 0:33.91 /www/bin/httpd ^^^^^ ^^^ If I comment out "$retval[$key][$col_name]= $value", then I have: nobody 20871 0.0 0.0 14.8M 1.9M ?? S 17:24:49 0:00.03 /www/bin/httpd ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19796 -- Edit this bug report at http://bugs.php.net/?id=19796&edit=1