ID: 8769
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: PostgreSQL related
Description: Persistent connections aren't closed when using dynamically loaded module

It seems that either the PostgreSQL connections are not killed after the Apache child 
process exits, or Apache isn't killing children as normal.  If I use the dynamically 
loaded pgsql module, I run into the maximum number of PostgreSQL clients allowed 
almost immediately, whereas I have never maxed out the number of clients with the 
pgsql module compiled into the php library directly.  Hope that clears it up.

Previous Comments:
---------------------------------------------------------------------------

[2001-01-17 21:46:44] [EMAIL PROTECTED]
What do you mean by persistent connections not closing?  They are not supposed to 
close, hence the name.

---------------------------------------------------------------------------

[2001-01-17 18:28:51] [EMAIL PROTECTED]
When using the PostgreSQL functions that have been compiled as a dynamically loaded 
module, persistent connections do not seem to close properly. 

I'm loading the module using the dl() function call within my script.

My original configure script was:

./configure 
--with-apxs=/usr/sbin/apxs 
--with-gettext=no 
--with-msql 
--with-pgsql=shared 
--without-mysql 
--without-gd 
--with-xml=shared 
--with-pdflib=/usr/local 
--enable-track-vars=yes 
--with-zlib 
--with-jpeg-dir=/usr 
--with-tiff-dir=/usr 
--with-session=/tmp 
--enable-trans-sid

I fixed the problem by removing the "shared" from the --with-pgsql line.
 

---------------------------------------------------------------------------


Full Bug description available at: http://bugs.php.net/?id=8769


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to