Re: Possible problem of mailing list archive(s)

On 2018-Jul-25, Stefan Kaltenbrunner wrote:

> On 07/25/2018 02:34 PM, Antonin Houska wrote:

> > In this post
> >
> > https://www.postgresql.org/message-id/11824.1532519662%40localhost
> >
> > I replied to an email that I actually don't see in the web archive.
> >
> > Message-Id of the missing email is:
> >
> > 201807230637(dot)w6N6bDnQ028675(at)ccmail04(dot)silk(dot)ntt-tx(dot)co(dot)jp
>
> its not immediately obvious from the quote in your mail but isnt the
> mail you replied too equivalent to this one:
>
> https://www.postgresql.org/message-id/201807242252.w6OMqNx2001418%40ccmail04.silk.ntt-tx.co.jp

> I can't actually find the claimed missing message-id in our mailinglist
> server logs at all - can you please show us the headers from that mail
> to confirm it actually went through our systems and it was not a copy of
> the mail that was directly sent to you or something else?

I looked at makus and malur logs and the message-id Antonin mentions was
there, showing as delivered to pglister.

makus:
2018-07-23 06:38:08 [12564] 1fhUTs-0003Ge-Vl <= harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)jp H=mail05.ics.ntt-tx.co.jp (mail04.ics.ntt-tx.co.jp) [210.232.35.69] P=esmtps X=TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256 CV=no S=6188 id=201807230637(dot)w6N6bDnQ028675(at)ccmail04(dot)silk(dot)ntt-tx(dot)co(dot)jp
2018-07-23 06:38:09 [12569] 1fhUTs-0003Ge-Vl => pgsql-hackers(at)postgresql(dot)org R=forward_to_pg_destinations_legacy T=manual_smtp_affix H=malur.postgresql.org [2a02:16a8:dc51::56] X=TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256 CV=yes DN="CN=lists.postgresql.org" C="250 OK id=1fhUTx-0001l5-Aj" QT=5s DT=1s
2018-07-23 06:38:09 [12569] 1fhUTs-0003Ge-Vl Completed QT=5s

malur:
2018-07-23 06:38:09 [6763] 1fhUTx-0001l5-Aj <= harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)jp H=makus.postgresql.org [2001:4800:1501:1::229] P=esmtps X=TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256 CV=no S=6510 id=201807230637(dot)w6N6bDnQ028675(at)ccmail04(dot)silk(dot)ntt-tx(dot)co(dot)jp
2018-07-23 06:38:09 [6764] 1fhUTx-0001l5-Aj => pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> R=pglister_router T=pglister_pipe QT=0s DT=0s
2018-07-23 06:38:09 [6764] 1fhUTx-0001l5-Aj Completed QT=0s

I then noticed a ton of stuff stuck in the moderator queue and approved
a bunch. I thought Toshi's email was there, but probably what was there
is the one you (Stefan) say, not the one Antonin says -- I didn't
double-check that. But malur pglister logs did list this message-id as
in moderation queue.

Not sure what happened in the archives. The message is still not there.

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