PHP 4.0 Bug #8769 Updated: Persistent connections aren't closed when using dynamically loaded module

ID: 8769 User Update by: pete@byways.org 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] rasmus@php.net What do you mean by persistent connections not closing? They are not supposed to close, hence the name. --------------------------------------------------------------------------- [2001-01-17 18:28:51] pete@byways.org 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