Re: BUG #3504: Some listening sessions never return from writing, problems ensue - Mailing list pgsql-bugs

From Peter Koczan
Subject Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Date
Msg-id 46B3A0B7.8020700@gmail.com
Whole thread Raw
In response to Re: BUG #3504: Some listening sessions never return from writing, problems ensue  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #3504: Some listening sessions never return from writing, problems ensue
List 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 by date:

Previous
From: "Vlad ROMASCANU"
Date:
Subject: Re: BUG #2393: update fails with unique constraint violation
Next
From: "Adam"
Date:
Subject: BUG #3511: timeofday()::timestamp failing on Saturday when using australian_timezones = on