php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #8769 Persistent connections aren't closed when using dynamically loaded module
Submitted: 2001-01-17 18:28 UTC Modified: 2002-01-10 17:51 UTC
From: pete at byways dot org Assigned:
Status: Closed Package: PostgreSQL related
PHP Version: 4.0.4pl1 OS: RedHat 7.0/Linux 2.2.16 x86
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2001-01-17 18:28 UTC] pete at byways dot 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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-17 21:46 UTC] rasmus@php.net 
What do you mean by persistent connections not closing?  They are not supposed to close, hence the name.
 [2001-01-17 23:01 UTC] pete at byways dot org 
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-12-05 18:36 UTC] yohgaki@php.net 
Does this happen with 4.1.0RC5?
http://www.php.net/~zeev/php-4.1.0RC5.tar.gz
 [2001-12-05 18:45 UTC] yohgaki@php.net 
Status => feedback
 [2001-12-11 12:19 UTC] pete at byways dot org 
Seems to be fixed as of PHP 4.1.0 and Apache 1.3.22
 [2002-01-10 17:42 UTC] tinus at deephosting dot com 
not here. php 4.1.1 and apache 1.3.22. 
(PostgreSQL 7.1.3).

care to tell where you got this information?
(about it being fixed
 [2002-01-10 17:51 UTC] pete at byways dot org 
> care to tell where you got this information?
> (about it being fixed

I got the information from myself - I built 4.1.0 and didn't run into the maximum connections, as I stated in the original report.  However, there still seems to be something strange going on when using the shared module - I can't quite describe it yet, so I haven't posted a report.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 19 08:01:28 2024 UTC