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@users.sourceforge.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.org@localhost.postgresql.org
 Received: from localhost (unknown [200.46.204.144])
        by svr1.postgresql.org (Postfix) with ESMTP id 9F4A852F9D
        for <pgsql-general-postgresql.org@localhost.postgresql.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.org@localhost.postgresql.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@postgresql.org>; Wed, 27 Jul 2005 13:30:36 -0300
(ADT)
 Received: by wproxy.gmail.com with SMTP id i21so208751wra
        for <pgsql-general@postgresql.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@mail.gmail.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@users.sourceforge.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.org@localhost.postgresql.org
 Received: from localhost (unknown [200.46.204.144])
        by svr1.postgresql.org (Postfix) with ESMTP id 9F4A852F9D
        for <pgsql-general-postgresql.org@localhost.postgresql.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.org@localhost.postgresql.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@postgresql.org>; Wed, 27 Jul 2005 13:30:36 -0300
(ADT)
 Received: by wproxy.gmail.com with SMTP id i21so208751wra
        for <pgsql-general@postgresql.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@mail.gmail.com>

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