Hung backends

From: "Schmidt, Peter" <peter(dot)schmidt(at)prismedia(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Hung backends
Date: 2000-11-17 18:38:37
Message-ID: F1DC8388AD52D411B83B00D0B774D6EB1927E8@winmail.prismedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm new to PostgreSQL and have been tasked with determining the cause of
hung processes on FreeBSD after the frontend app dies. Eventually we run out
of connections when hung processes = MAXBACKENDS.

ps -cl -U postgres returns:

UID PID PPID CPU PRI NI VSZ RSS WCHAN STAT TT TIME COMMAND
500 1395 1 0 2 0 4040 2380 select Ss ?? 0:01.17 postgres
500 2255 1395 0 2 0 4384 2984 sbwait I ?? 0:00.01 postgres
500 2256 1395 0 2 0 4384 2984 sbwait I ?? 0:00.01 postgres
500 2257 1395 0 2 0 4384 2984 sbwait I ?? 0:00.01 postgres
500 2258 1395 0 2 0 4384 2984 sbwait I ?? 0:00.01 postgres
500 2259 1395 0 2 0 4384 2984 sbwait I ?? 0:00.01 postgres
...

The java frontend I'm using to test this scenario makes multiple connections
and crashes(unhandled exception) before disconnecting. This appears to leave
one "postgres" proccess for each connection. Can anyone point me in the
right direction?
SELECT version(); -> PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.0

Thanks for any advice.
Peter Schmidt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Warren Vanichuk 2000-11-17 18:41:04 Several PostGreSQL questions.
Previous Message Rich Shepard 2000-11-17 18:09:55 RE: Strange problem upgrading to 7.0.3x