ID: 8769
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Old Status: Feedback
Status: Closed
Bug Type: PostgreSQL related
Operating System: RedHat 7.0/Linux 2.2.16 x86
PHP Version: 4.0.4pl1
New Comment:

Seems to be fixed as of PHP 4.1.0 and Apache 1.3.22

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

[2001-12-05 18:45:27] [EMAIL PROTECTED]

Status => feedback

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

[2001-12-05 18:36:27] [EMAIL PROTECTED]

Does this happen with 4.1.0RC5?
http://www.php.net/~zeev/php-4.1.0RC5.tar.gz

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

[2001-01-17 23:01:09] [EMAIL PROTECTED]

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.

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

[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.
 

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



Edit this bug report at http://bugs.php.net/?id=8769&edit=1


-- 
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