Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 19 Apr 2001 11:15:15 +0200 (CEST)
From:      "Patrick M. Hausen" <hausen@punkt.de>
To:        deece@newmillennium.net.au (Alastair D'Silva)
Cc:        freebsd-stable@FreeBSD.ORG
Subject:   Re: Apache13-modssl & PHP4
Message-ID:  <200104190915.LAA99115@hugo10.ka.punkt.de>
In-Reply-To: <Pine.BSF.4.31.0104191657520.76627-100000@picard.dyn.newmillennium.net.au> from "Alastair D'Silva" at "Apr 19, 2001 04:58:35 pm"

next in thread | previous in thread | raw e-mail | index | archive | help
Hello!

> I have recently upgraded Apache/modssl via the ports collection to
> 1.3.19-2.8.2. This seems to have broken persistent connections to my
> PostgreSQL database.
> 
> It seems that while persistent connections open fine, they are not being
> returned to the pool for reuse, the end result being that PostgreSQL
> eventually starts refusing connections.
> 
> I have reproduced this behavior on 3 machines, all running different
> versions of 4.2-STABLE.

Just for the record: we encountered exactly the same problem with
PHP and MySQL when we installed a new server with 4.3-RC and moved
an application that ran just fine on 4.2.

I spent an entire weekend rebuilding the various ports involved
again and again with different settings without success.

mysql_pconnect() works a couple of times after restarting
Apache, then doesn't. mysql_connect() works all of the time.

> I have temporarily changed my code to not use persistent connections, but
> I don't consider this to be a proper fix. Can anyone suggest a better
> solution?

Mee too ;-)

TIA,
Patrick
-- 
--- WEB ISS GmbH - Scheffelstr. 17a - 76135 Karlsruhe - 0721/9109-0 ---
------ Patrick M. Hausen - Technical Director - hausen@punkt.de -------
"Two men say, they're Jesus - one of 'em must be wrong." (Dire Straits)

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-stable" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200104190915.LAA99115>