Thread: Weird delays on pgsql-committers email traffic

Weird delays on pgsql-committers email traffic

From
Tom Lane
Date:
For the last day or so, I've been seeing that commit emails suffer
a noticeable lag, five minutes or more.  Which is weird because
traffic on other, higher-volume lists is not similarly delayed.
Maybe it's something in the mechanism generating the mail, rather
than the fault of the mailing list server proper.

            regards, tom lane



Re: Weird delays on pgsql-committers email traffic

From
Magnus Hagander
Date:
On Wed, Apr 8, 2020 at 5:38 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> For the last day or so, I've been seeing that commit emails suffer
> a noticeable lag, five minutes or more.  Which is weird because
> traffic on other, higher-volume lists is not similarly delayed.
> Maybe it's something in the mechanism generating the mail, rather
> than the fault of the mailing list server proper.

Hi!

Yeah, there is a strange delay since approximately a day ago. It's in
the outbound delivery from the commit messages. We are currently
investigating where it's coming from -- we're seeing similar patterns
from a couple of other hosts. The delay happens before it even hits
the listserver -- that's why regular email sent to the high volume
lists still deliver quickly. It's stuck in a transient delivery queue
for reasons yet not fully figured out.

Thanks for the report!

-- 
 Magnus Hagander
 Me: https://www.hagander.net/
 Work: https://www.redpill-linpro.com/



Re: Weird delays on pgsql-committers email traffic

From
Alvaro Herrera
Date:
On 2020-Apr-08, Magnus Hagander wrote:

> On Wed, Apr 8, 2020 at 5:38 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> >
> > For the last day or so, I've been seeing that commit emails suffer
> > a noticeable lag, five minutes or more.  Which is weird because
> > traffic on other, higher-volume lists is not similarly delayed.
> > Maybe it's something in the mechanism generating the mail, rather
> > than the fault of the mailing list server proper.
> 
> Yeah, there is a strange delay since approximately a day ago.

What I noticed is that pushing to and pulling from the master repo has
gotten noticeably slow.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



Re: Weird delays on pgsql-committers email traffic

From
Tom Lane
Date:
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> What I noticed is that pushing to and pulling from the master repo has
> gotten noticeably slow.

Hm, haven't really noticed that here.

            regards, tom lane



Re: Weird delays on pgsql-committers email traffic

From
Stefan Kaltenbrunner
Date:
On 4/8/20 5:40 PM, Magnus Hagander wrote:
> On Wed, Apr 8, 2020 at 5:38 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> For the last day or so, I've been seeing that commit emails suffer
>> a noticeable lag, five minutes or more.  Which is weird because
>> traffic on other, higher-volume lists is not similarly delayed.
>> Maybe it's something in the mechanism generating the mail, rather
>> than the fault of the mailing list server proper.
> 
> Hi!
> 
> Yeah, there is a strange delay since approximately a day ago. It's in
> the outbound delivery from the commit messages. We are currently
> investigating where it's coming from -- we're seeing similar patterns
> from a couple of other hosts. The delay happens before it even hits
> the listserver -- that's why regular email sent to the high volume
> lists still deliver quickly. It's stuck in a transient delivery queue
> for reasons yet not fully figured out.

should be fixed - that was caused by both a config thinko on my side
during an upgrade _AND_ the fact that I forgot to remove the thinko
after the upgrade.

It basically caused mails from auxiliary^non-primary mail systems
systems (like gitmaster) to get put in the queue immediately (instead of
being delivered) and only deliver on the next queue run(which in this
case runs on a 300s/5m schedule)...


Stefan



Re: Weird delays on pgsql-committers email traffic

From
Tom Lane
Date:
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> On 4/8/20 5:40 PM, Magnus Hagander wrote:
>> On Wed, Apr 8, 2020 at 5:38 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> For the last day or so, I've been seeing that commit emails suffer
>>> a noticeable lag, five minutes or more.

> should be fixed - that was caused by both a config thinko on my side
> during an upgrade _AND_ the fact that I forgot to remove the thinko
> after the upgrade.

Thanks!

            regards, tom lane