Re: idle in transaction

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: idle in transaction
Дата
Msg-id 20011208111308.J48625-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на idle in transaction  ("Rich Ryan" <rich@usedcars.com>)
Список pgsql-general
It looks like you've got a transaction which is staying open while holding
a lock. I'm not sure why it'd be different between versions.
If you turn up the debugging level and turn on at least log_pid you should
be able to see what statements the process from that pid has executed.

> If I kill pid 4168, the idle in transaction process, then the vacuum and all
> the other waiting processes will proceed fine. Any clues to what could be
> hanging or how I could get more information from postmaster about what
> transaction is hanging?



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

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: untaring release-7.1.3 -
Следующее
От: Brook Milligan
Дата:
Сообщение: Re: papers on datatype design