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.w6N6bDnQ028675@ccmail04.silk.ntt-tx.co.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.toshi@po.ntt-tx.co.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.w6N6bDnQ028675@ccmail04.silk.ntt-tx.co.jp
2018-07-23 06:38:09 [12569] 1fhUTs-0003Ge-Vl => pgsql-hackers@postgresql.org R=forward_to_pg_destinations_legacy
T=manual_smtp_affixH=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.toshi@po.ntt-tx.co.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.w6N6bDnQ028675@ccmail04.silk.ntt-tx.co.jp
2018-07-23 06:38:09 [6764] 1fhUTx-0001l5-Aj => pgsql-hackers <pgsql-hackers@lists.postgresql.org> R=pglister_router
T=pglister_pipeQT=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