[PHP-DB] apache mod_php memory leak, need help.

[Ray Aspeitia]

I'm posting this here as well in hopes that someone can help me out.

Thanks,

Ray A.

Just another note,

it seems that for every page access, there is exactly 680k of memory 
that accumulates.

Any php developer know of any odbc function that takes up 680k of 
overhead that might not be getting cleaned up?

Thanks,

Ray A.

Hello,

I hope someone can help me or point me in a good direction.

I have a database driven website, all ODBC to postgresql, that 
little by little eats up resources on apache.

The child processes will start off at 30Mb of virtual memory and 
run up around 230Mb each child. (see below ps output) before they 
start dying.

It does not even take 700 accesses per child to max out memory.

I then start getting funny errors like access denied to file or 
could not open socket, or file not found.

I read all to documentation and as far as I know, php should 
release any defined query resources once the script executes.

I already code with odbc_close($conn); on all my pages. It is not 
feasible to use odbc_free_result() on every query, due to the 
complexity of scripts, but the documentation for odbc_free_result 
says you shouldn't have to.

That is the only thing that I can think of that could be draining 
this much resources. Is there any good way to find out what is 
eating up the memory. Anyone else run into this.

I'm running apache 1.3.27 with php 4.3.2 (happened in version 4.3.1 
also) on mac OSX SERVER 10.2.4

Thanks in advance,

Ray A.

PS OUTPUT 
---------------------------------------------------------------------------
root       468   0.0  0.3    30992   2152  ??  Ss    4Jun03 1:30.04 
/usr/sbin/httpd
www       1743   0.0  1.2   222600  10032  ??  S     8:00AM 2:16.31 
/usr/sbin/httpd
www       1767   0.0  1.1   220560   9592  ??  S     8:01AM 1:58.56 
/usr/sbin/httpd
www       1806   0.0  1.1   215800   9588  ??  S     8:13AM 1:46.92 
/usr/sbin/httpd
www       1876   0.0  1.1   210360   9532  ??  S     8:44AM 1:56.10 
/usr/sbin/httpd
www       1878   0.0  1.3   224304  10904  ??  S     8:44AM 2:13.93 
/usr/sbin/httpd
www       1879   0.0  1.2   219880   9912  ??  S     8:44AM 2:10.85 
/usr/sbin/httpd



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php