Re: duplicate messages?

On Wednesday 27 July 2005 12:30, Alvaro Herrera wrote:
> On Wed, Jul 27, 2005 at 11:46:05AM -0400, Robert Treat wrote:
> > Seems unlikely unless folks like Tom Lane, Stephan Szabo, and Richard
> > Huxton have unsubscribed and resubscribed lately... Funny thing is it
> > isnt every messages, but maybe half of them. And its not to specific
> > users, sometimes one of Toms emails will duplicate but sometimes not.
> > Further more it only seems to be happening on pgsql-general emails and
> > not on any of the other lists... I also notice this is only happening on
> > one of my subscribed emails, not the other, which is a little weird...
> > according to the headers though, this problem is happening further
> > upstream.
>
> I'd think it would be a problem with your "last mile", because it seems
> to be a localized problem. Maybe an SMTP server dropping connections at
> the last moment, or a deliver program crashing after delivering (leading
> to re-delivery), or something like that.
>
> You'd have to show us the headers though.

I would think that too, however take a look at these message headers:
the critical piece seems to be the handoff between postgresql.org and
commandprompt, where the ESMTP changes into j6RGoF0u002162 and j6RGj9mu001662
for what would otherwise be the same message.

Received: from 128.commandprompt.com ([207.173.200.128]
helo=hosting.commandprompt.com)
by mail.sourceforge.net with esmtps (TLSv1:AES256-SHA:256)
(Exim 4.44)
id 1DxpLy-00015W-19
for xzilla(at)users(dot)sourceforge(dot)net; Wed, 27 Jul 2005 10:06:01 -0700
Received: from postgresql.org (svr1.postgresql.org [200.46.204.71])
by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id
j6RGj9mu001662;
Wed, 27 Jul 2005 09:45:27 -0700
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 9F4A852F9D
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 27
Jul 2005 13:30:42 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 01459-09
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 27 Jul 2005 16:30:37 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200])
by svr1.postgresql.org (Postfix) with ESMTP id E8ECB52FA4
for <pgsql-general(at)postgresql(dot)org>; Wed, 27 Jul 2005 13:30:36 -0300
(ADT)
Received: by wproxy.gmail.com with SMTP id i21so208751wra
for <pgsql-general(at)postgresql(dot)org>; Wed, 27 Jul 2005 09:30:36 -0700
(PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
s=beta; d=gmail.com;
h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
b=nNBziaFbsTlwduR3PYyrUPubs6NRt0AU0/m8aPBQkXbpYYNqBRefNf0io5qZhG4oMSf3FnUwJoNlAfMdHG/R9CKm6XKb0eik8nEBDMcA6DYmBJsbLM3ebzFe6lzilfwxvtMYhSH8SohIDoHPX/CEyLxldB0sDmDLCu6YFXBv3Yg=
Received: by 10.54.13.59 with SMTP id 59mr411070wrm;
Wed, 27 Jul 2005 09:30:36 -0700 (PDT)
Received: by 10.54.100.12 with HTTP; Wed, 27 Jul 2005 09:30:36 -0700 (PDT)
Message-ID: <7256023005072709305aee5839(at)mail(dot)gmail(dot)com>
---
Received: from 128.commandprompt.com ([207.173.200.128]
helo=hosting.commandprompt.com)
by mail.sourceforge.net with esmtps (TLSv1:AES256-SHA:256)
(Exim 4.44)
id 1DxpQt-0003vz-Tr
for xzilla(at)users(dot)sourceforge(dot)net; Wed, 27 Jul 2005 10:11:05 -0700
Received: from postgresql.org (svr1.postgresql.org [200.46.204.71])
by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id
j6RGoF0u002162;
Wed, 27 Jul 2005 09:50:15 -0700
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 9F4A852F9D
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 27
Jul 2005 13:30:42 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 01459-09
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 27 Jul 2005 16:30:37 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200])
by svr1.postgresql.org (Postfix) with ESMTP id E8ECB52FA4
for <pgsql-general(at)postgresql(dot)org>; Wed, 27 Jul 2005 13:30:36 -0300
(ADT)
Received: by wproxy.gmail.com with SMTP id i21so208751wra
for <pgsql-general(at)postgresql(dot)org>; Wed, 27 Jul 2005 09:30:36 -0700
(PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
s=beta; d=gmail.com;
h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
b=nNBziaFbsTlwduR3PYyrUPubs6NRt0AU0/m8aPBQkXbpYYNqBRefNf0io5qZhG4oMSf3FnUwJoNlAfMdHG/R9CKm6XKb0eik8nEBDMcA6DYmBJsbLM3ebzFe6lzilfwxvtMYhSH8SohIDoHPX/CEyLxldB0sDmDLCu6YFXBv3Yg=
Received: by 10.54.13.59 with SMTP id 59mr411070wrm;
Wed, 27 Jul 2005 09:30:36 -0700 (PDT)
Received: by 10.54.100.12 with HTTP; Wed, 27 Jul 2005 09:30:36 -0700 (PDT)
Message-ID: <7256023005072709305aee5839(at)mail(dot)gmail(dot)com>

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL