Re: Orphaned statements issue

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Orphaned statements issue
Дата
Msg-id 21534.1295559410@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Orphaned statements issue  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Orphaned statements issue  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> One of our clients is seeing an unusual issue with statements which are
> waiting going into sleep forever and never completing.   This first
> e-mail is for a "has anyone else seen this problem before?" while we try
> to collect additional information for a diagnosis.

> An strace on the process shows it to be in RECV, and otherwise doing
> nothing.

I would take that to mean that it's waiting on the client.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: ALTER TABLE ... REPLACE WITH
Следующее
От: "Simone Aiken"
Дата:
Сообщение: Re: ToDo List Item - System Table Index Clustering