Re: how can i bugfix "idle in transaction" lockups ?

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: how can i bugfix "idle in transaction" lockups ?
Дата
Msg-id 38C4C998-5A67-4D0A-9207-33A9C95E6360@thebuild.com
обсуждение исходный текст
Ответ на how can i bugfix "idle in transaction" lockups ?  (Jonathan Vanasco <postgres@2xlp.com>)
Список pgsql-general
On Nov 30, 2010, at 7:21 AM, Jonathan Vanasco wrote:

> i couldn't find anything in the docs, and the project has decent traffic, so its going to be an issue to log all
statementsso I can sift through the data by PID 

With machine-readable logs, it shouldn't be *that* serious an issue.

1. Are you using connection pooling?
2. What's the application server environment?

--
-- Christophe Pettus
   xof@thebuild.com


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

Предыдущее
От: Jonathan Vanasco
Дата:
Сообщение: Re: how can i bugfix "idle in transaction" lockups ?
Следующее
От: Konstantin Izmailov
Дата:
Сообщение: Re: number of rows returned by a query