dblnk_is_busy returns 1 for dead connecitons

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема dblnk_is_busy returns 1 for dead connecitons
Дата
Msg-id CAHyXU0wRz265W16bN3zmoGao3X=VN8+cSz09PNHg4NyUp9pLoQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: dblnk_is_busy returns 1 for dead connecitons  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
Hackers,

I have a situation that I am observing where dblink_is_busy returns 1
even though the connection is long gone.   tcp keepalives are on and
the connection has been dead for several hours. Looking at the call
for dblink_is_busy, I see that  it is a thin wrapper to PQusBusy().
If I attempt to call dblink_get_result(), the result comes back with
an error mesage, 'invalid socket'. This however is not helpful since
there is no way to probe for dead connections in dblink that appears
to be 100% reliable.  My workaround that I had been relying on was to
call dblink_get_notify twice, which for some weird reason forced the
connection error to the surface.  However for whatever reason, that is
not working here.

In cases the connection was cancelled via dblink_cancel_query(), so in
some scenarios connections cancelled that way seem to become 'stuck'.
Any thoughts on this?

merlin



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: LDAP check flapping on crake due to race
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Comment simplehash/dynahash trade-offs