Re: BUG #3504: Some listening sessions never return from writing, problems ensue

Поиск
Список
Период
Сортировка
От Peter Koczan
Тема Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Дата
Msg-id 46B3A0B7.8020700@gmail.com
обсуждение исходный текст
Ответ на Re: BUG #3504: Some listening sessions never return from writing, problems ensue  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Список pgsql-bugs
I think the code is somehow interrupt based, but I don't know. I've
asked the primary maintainer of the program to look into this with me.
We should have more insight by early next week.

Peter

Tom Lane wrote:
> "Peter Koczan" <pjkoczan@gmail.com> writes:
>
>> This app uses Perl/DBD::Pg, and the code is basically:
>>
>
>
>> while ($dbh->func('pg_notifies')) {
>>   # do stuff
>> }
>>
>
> If I'm not mistaken, that loop would process all the currently available
> notify messages and then fall out.  So the real question is what's
> around this --- what conditions will make the program come back to this
> loop periodically?  Or not do so?
>

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

Предыдущее
От: "Vlad ROMASCANU"
Дата:
Сообщение: Re: BUG #2393: update fails with unique constraint violation
Следующее
От: "Adam"
Дата:
Сообщение: BUG #3511: timeofday()::timestamp failing on Saturday when using australian_timezones = on