Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

PHPs PDO, apache and "never ending sessions" - Mailing list pgsql-general

From Andrej Ricnik-Bay
Subject PHPs PDO, apache and "never ending sessions"
Date
Msg-id b35603930803061801t12540aepbdf9f1aa55dbaf0c@mail.gmail.com
Whole thread Raw
Responses Re: PHPs PDO, apache and "never ending sessions"
List pgsql-general
Hi,

Not sure whether this is the right place to ask (probably isn't)
but I've seen much mention of PHP and some of PDO on this
list ...

I'm currently playing with the above, today I got a message
"FATAL:  connection limit exceeded for non-superusers"
even though there were no sessions I was aware of open.

A bit of poking around with ps and lsof showed me that a PHP
application I closed days ago (no browser open) was still active
tying up backend sessions;  the problem went away when I
restarted my apache.  Is this "normal behaviour"?  How do I
deal with it under normal circumstance, am I just supposed
to increase the number of allowed connections and not worry
about apache holding sessions open even after the "client"
has long gone?

Versions of products in question:
apache2 2.2.8 (Unix)
PHP 5.2.5
postgres 8.3


Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [DOCS] Incrementally Updated Backups: Docs Clarification
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PHPs PDO, apache and "never ending sessions"