locked up backends

Поиск
Список
Период
Сортировка
Искать
От
Maurice Balick
Тема
locked up backends
Дата
Msg-id
3ACCE0F8.5030006@smiley.com
Список
Дерево обсуждения
RE: locked up backends "Randall F. Kern" <randy@spoke.net>
Re: locked up backends Tom Lane <tgl@sss.pgh.pa.us>
Re: locked up backends Vince Vielhaber <vev@michvhf.com>
Re: locked up backends Tom Lane <tgl@sss.pgh.pa.us>
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

В списке pgsql-general по дате отправления
От: Joel Burton
Дата:
От: Peter Eisentraut
Дата:
FAQ