locked up backends

From: Maurice Balick <balm(at)smiley(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: locked up backends
Date: 2001-04-05 21:17:44
Message-ID: 3ACCE0F8.5030006@smiley.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We are running Postgres 7.0.2 on Linux RH 6.2 Dell servers.

When traffic gets heavy we often get one of the backend locked up in an
UPDATE, INSERT or COMMIT request. Eventually all the other backends end
up locking too as they try to access a row locked by the original
backend. The output of 'ps' shows that the locked up backend is sleeping
waiting for 'select' to return.

This has been occurring once or twice a day for the past few months. We
just stop the postmaster (sometimes we need to kill -USR1 one of the
backends before they all disappear) and then we restart postmaster and
everything works fine until the next lock up.

Any idea what might be wrong? I'd be happy to provide more info, if only
I knew what.

Thanks in advance,

--Maurice

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-05 21:38:00 Re: Problem with large tables
Previous Message Joel Burton 2001-04-05 21:02:47 Re: Database Name Case Sensitivity