From owner-freebsd-stable Thu Apr 19 5:27:48 2001 Delivered-To: freebsd-stable@freebsd.org Received: from hugo10.ka.punkt.de (kagate.punkt.de [194.77.232.254]) by hub.freebsd.org (Postfix) with ESMTP id 7698437B422 for ; Thu, 19 Apr 2001 05:27:45 -0700 (PDT) (envelope-from hausen@punkt.de) Received: (from ry93@localhost) by hugo10.ka.punkt.de (8.9.3/8.9.3) id LAA99115; Thu, 19 Apr 2001 11:15:15 +0200 (CEST) (envelope-from ry93) From: "Patrick M. Hausen" Message-Id: <200104190915.LAA99115@hugo10.ka.punkt.de> Subject: Re: Apache13-modssl & PHP4 In-Reply-To: from "Alastair D'Silva" at "Apr 19, 2001 04:58:35 pm" To: deece@newmillennium.net.au (Alastair D'Silva) Date: Thu, 19 Apr 2001 11:15:15 +0200 (CEST) Cc: freebsd-stable@FreeBSD.ORG X-Mailer: ELM [version 2.4ME+ PL54 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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