| From: | Mike Diehl <jdiehl(at)sandia(dot)gov> |
|---|---|
| To: | "Roberto Mello" <rmello(at)cc(dot)usu(dot)edu>, "Mike Diehl" <jdiehl(at)sandia(dot)gov> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Ran out of connections |
| Date: | 2002-12-04 23:52:58 |
| Message-ID: | 20021204234919.CA46678E6@dominion.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wednesday 04 December 2002 03:25 pm, Roberto Mello wrote:
> On Wed, Dec 04, 2002 at 03:08:35PM -0700, Mike Diehl wrote:
> > Can anyone tell me how to fix this? The out put of the ps command
> > can be seen at http://dominion.dyndns.org/~mdiehl/ps.txt
>
> Are you using PHP by chance? I've seen this behavior under Apache+PHP
> before. My "fix" (workaround rather) was to disable persistent
> connections.
Nope. I'm using Perl and cgi. I've got some perl that runs via cron, and
some more that runs via apache. I'm not even using ModPerl.
It did occur to me that since some of my scripts communicate with other
devices, that I may have some IO blocking, or zombies, but the ps output
didn't indicate that. I can't see that many scripts running. Usually, I see
one postgres process for each script/cgi that is running. Not in this case.
--
Mike Diehl
Network Tools Devl.
SAIC at Sandia Labs
(505) 284-3137
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Mello | 2002-12-05 00:00:08 | Re: Ran out of connections |
| Previous Message | Robert Treat | 2002-12-04 23:23:21 | Re: Ran out of connections |