Re: hung back end

----- Original Message -----
From: "Thomas T. Thai" <tom@minnesota.com>


> i'm porting some apps from mysql to pgsql and i'm using php4.0.5-cvs with
> phplib db classes. i'm starting to see that when ever i load a web page,
> it starts a backend. then when i try to reload the page, i get:
>
> sure i could increase the # of child processes, but instead i decided to
> check why it was doing this. it appears that after a webpage is openned, a
> new child process or backend starts. the persistent link doesn't seem to
> exist any longer. on the next reload, a new process. but the old one never
> disappeared. it'll sit there for hours and days.

IIRC there is a known problem with PHP's cached db connections to postgres.
Basically, as you've seen it doesn't reuse old backends, so you run out of
connections. See the archive for details. I think someone is looking at this
on the PHP side.

- Richard Huxton