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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "Hanging Connection" blocks access to table (JBossMQ)
Дата
Msg-id 16380.1160754948@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "Hanging Connection" blocks access to table (JBossMQ)  (Markus Schaber <schabi@logix-tt.com>)
Список pgsql-jdbc
Markus Schaber <schabi@logix-tt.com> writes:
> Tom Lane wrote:
>> I don't think it'd be a net win to add cycles to every query to check
>> the connection every so often.

> The SIGIO could set a flag variable via the interrupt handler,

SIGIO isn't portable (nowhere to be seen in Single Unix Spec), and where
it does exist, it seems to report I/O ready on *any* descriptor not only
the one you want.  That would lead to a whole lot of useless interrupts
and status-checks.

            regards, tom lane

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

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: "Hanging Connection" blocks access to table (JBossMQ)
Следующее
От: Ashish Goel
Дата:
Сообщение: IO error while sending to backend