Date: Mon, 28 May 2001 10:25:31 -0700 (PDT)
From: <pgsql-interfaces@commandprompt.com>
To: <pgsql-interfaces@postgresql.org>
cc: "J. T. Vermeulen" <jtv@cistron.nl>
Subject: Re: libpq++ in Apache Problem.
In-Reply-To: <20010528163302.H9655@cistron.nl>
Message-ID: <Pine.LNX.4.30.0105281018560.24512-100000@commandprompt.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Mon, 28 May 2001, J. T. Vermeulen wrote:
>On Sun, 27 May 2001, pgsql-interfaces@commandprompt.com wrote:
>>So... I'm really at a loss here on what's going on, and wondering if
>>anyone has some insight? I can give more technical details if necessary,
>>that's just the gist of the problem.
>Just a thought: You're not using exit(), are you?

Heh, nope. ;) I wish it were that simple.

The httpd process itself doesn't end, in fact. It just keeps on running,
which is the problem, because it accumulates postmaster connections with
each request until it's killed.

What is perplexing is why the destructor doesn't seem to be doing its job
when called from inside httpd, inexplicably. It is definitely reaching
that point in the code, but it just doesn't disconnect.

Further frustrating the matter, I tried not dynamically creating the
PgDatabase on the heap, and just made it a local variable on the stack.
Eg, PgDatabase foo(); instead of PgDatabase *foo = new PgDatabase.

Guess what? It still keeps the connection after leaving its scope. Grr.

This is easily the most frustrating programming problem I have experienced
in using PostgreSQL.


Jw.
--
John Worsley, Command Prompt, Inc.
jlx@commandprompt.com by way of pgsql-interfaces@commandprompt.com.