Re: "Hanging Connection" blocks access to table (JBossMQ)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "Hanging Connection" blocks access to table (JBossMQ)
Дата
Msg-id 13679.1160594122@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "Hanging Connection" blocks access to table (JBossMQ)  (Michael Goldner <mgoldner@agmednet.com>)
Ответы Re: "Hanging Connection" blocks access to table (JBossMQ)
Список pgsql-jdbc
Michael Goldner <mgoldner@agmednet.com> writes:
> When I shutdown Jboss, the idle process disappears, but the 2 "INSERT
> waiting" processes remain indefinitely.

Ah.  That makes sense, because a backend blocked partway through a query
isn't going to notice its client disconnecting.  The question here
though is still "what are they waiting for?".  See pg_locks.

            regards, tom lane

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

Предыдущее
От: Michael Goldner
Дата:
Сообщение: Re: "Hanging Connection" blocks access to table (JBossMQ)
Следующее
От: zhyu 86
Дата:
Сообщение: MBC user cannot connect to server