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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: pete at byways dot org
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 06 12:01:29 2025 UTC