Thread: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

[Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Joshua D. Drake"
Date:
I have seen this email 3 times... is something stuck?

-------- Original Message --------
Subject: [ANNOUNCE] PostgreSQL RPM Yum repository is available
Date: Mon, 07 Jan 2008 14:22:32 -0800
From: Devrim GÜNDÜZ <devrim@commandprompt.com>
Organization: Command Prompt, Inc.
To: pgsql-announce@postgresql.org


I want to announce that PostgreSQL RPM Yum repository is now available.

With this repository, you will be able to install your favorite
PostgreSQL version with the other compatible PostgreSQL related software
to your favorite OS . You don't have to stick to OS-supplied RPM
packages.

Please visit http://yum.pgsqlrpms.org for details.

Please note that we are currently testing this repository, even though
there are no problems found so far. I expect to finish the tests at the
end of this week. Please report any problems to me.

Again, thanks a lot to Darcy Buskermolen for his great support.

Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/


Attachment

Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Josh Berkus
Date:
On Tuesday 08 January 2008 07:23, Joshua D. Drake wrote:
> I have seen this email 3 times... is something stuck?

I only got it once.  I think Devrim bcc'd you.

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco


Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Magnus Hagander
Date:
On Tue, Jan 08, 2008 at 07:26:32AM -0800, Josh Berkus wrote:
> On Tuesday 08 January 2008 07:23, Joshua D. Drake wrote:
> > I have seen this email 3 times... is something stuck?
> 
> I only got it once.  I think Devrim bcc'd you.

I think I've got 4 or 5. So far I've only kept the headers of the latest one,
but I'll keep any further ones I receive as well. Here's the latest one:

Received: from mx2.hub.org (mx2.hub.org [200.46.204.254])       by svr2.hagander.net (Postfix) with ESMTP id
476F9DCC195      for <magnus@hagander.net>; Tue,  8 Jan 2008 15:43:24 +0100 (CET)
 
Received: from postgresql.org (postgresql.org [200.46.204.71])       by mx2.hub.org (Postfix) with ESMTP id
281FC12A672F;      Tue,  8 Jan 2008 10:42:57 -0400 (AST)
 
Received: from localhost (unknown [200.46.204.187])       by postgresql.org (Postfix) with ESMTP id 7374E2E0383
for<pgsql-announce-postgresql.org@postgresql.org>; Mon,  7 Jan
 
2008 18:22:55 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port
10024)withESMTP id 86638-06 for <pgsql-announce-postgresql.org@postgresql.org>;Mon,  7 Jan 2008 18:22:44 -0400 (AST)
 
Received: from lists.commandprompt.com (host-159.commandprompt.net
[207.173.203.159])       by postgresql.org (Postfix) with ESMTP id 233F12E3355       for
<pgsql-announce@PostgreSQL.org>;Mon,  7 Jan 2008 18:22:48
 
-0400 (AST)


Seems to me that it was re-injected between postgresql.org (AKA localhost
AKA unknown AKA 200.46.204.71 - there's still some serious DNS breakage
going on there) and mx2.hub.org.

//Magnus


Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Joshua D. Drake"
Date:
Magnus Hagander wrote:
> On Tue, Jan 08, 2008 at 07:26:32AM -0800, Josh Berkus wrote:
>> On Tuesday 08 January 2008 07:23, Joshua D. Drake wrote:
>>> I have seen this email 3 times... is something stuck?
>> I only got it once.  I think Devrim bcc'd you.

O.k. guys this is a big deal. This went out on our announce list which 
means lots of people are receiving this more than once. This is the 
second time this has happen in recent history.

What is it going to take to *fix* it.

Joshua D. Drake




Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Devrim GÜNDÜZ
Date:
Hi,

On Tue, 2008-01-08 at 07:26 -0800, Josh Berkus wrote:
> I think Devrim bcc'd you.

No, I did not.

Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/

Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Alvaro Herrera
Date:
Joshua D. Drake wrote:
> Magnus Hagander wrote:
>> On Tue, Jan 08, 2008 at 07:26:32AM -0800, Josh Berkus wrote:
>>> On Tuesday 08 January 2008 07:23, Joshua D. Drake wrote:
>>>> I have seen this email 3 times... is something stuck?
>>> I only got it once.  I think Devrim bcc'd you.
>
> O.k. guys this is a big deal. This went out on our announce list which 
> means lots of people are receiving this more than once. This is the second 
> time this has happen in recent history.
>
> What is it going to take to *fix* it.

The mail servers logs need to be examined ... who has access to them?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Magnus Hagander
Date:
Alvaro Herrera wrote:
> Joshua D. Drake wrote:
>> Magnus Hagander wrote:
>>> On Tue, Jan 08, 2008 at 07:26:32AM -0800, Josh Berkus wrote:
>>>> On Tuesday 08 January 2008 07:23, Joshua D. Drake wrote:
>>>>> I have seen this email 3 times... is something stuck?
>>>> I only got it once.  I think Devrim bcc'd you.
>> O.k. guys this is a big deal. This went out on our announce list which 
>> means lots of people are receiving this more than once. This is the second 
>> time this has happen in recent history.
>>
>> What is it going to take to *fix* it.
> 
> The mail servers logs need to be examined ... who has access to them?

AFAIK, only Marc since it's a hub.org box.

//Magnus


Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Alvaro Herrera
Date:
Magnus Hagander wrote:
> Alvaro Herrera wrote:
>> Joshua D. Drake wrote:
>>> Magnus Hagander wrote:
>>>> On Tue, Jan 08, 2008 at 07:26:32AM -0800, Josh Berkus wrote:
>>>>> On Tuesday 08 January 2008 07:23, Joshua D. Drake wrote:
>>>>>> I have seen this email 3 times... is something stuck?
>>>>> I only got it once.  I think Devrim bcc'd you.
>>> O.k. guys this is a big deal. This went out on our announce list which 
>>> means lots of people are receiving this more than once. This is the 
>>> second time this has happen in recent history.
>>>
>>> What is it going to take to *fix* it.
>>
>> The mail servers logs need to be examined ... who has access to them?
>
> AFAIK, only Marc since it's a hub.org box.

Perhaps that is something that oughta be fixed by itself.

Perhaps Marc got hit in the head by his collection of Panama maps.
Who's to know?  If and when it happens, how are we going to fix it?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 8 Jan 2008 15:10:05 -0300
Alvaro Herrera <alvherre@commandprompt.com> wrote:


> > AFAIK, only Marc since it's a hub.org box.
> 
> Perhaps that is something that oughta be fixed by itself.
> 
> Perhaps Marc got hit in the head by his collection of Panama maps.
> Who's to know?  If and when it happens, how are we going to fix it?
> 

Dave also has access to my knowledge.

However, Marc might be hard to get a hold of as he has a day job now.

Joshua D. Drake


- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHg76aATb/zqfZUUQRAh7UAKCh097SDDR+cMLuAe+CFs+s6f0dSgCgi2v7
giRRfeFEiMj8Ns0CvMMip/Y=
=KHJb
-----END PGP SIGNATURE-----

Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Tuesday, January 08, 2008 08:14:47 -0800 "Joshua D. Drake" 
<jd@commandprompt.com> wrote:

> Magnus Hagander wrote:
>> On Tue, Jan 08, 2008 at 07:26:32AM -0800, Josh Berkus wrote:
>>> On Tuesday 08 January 2008 07:23, Joshua D. Drake wrote:
>>>> I have seen this email 3 times... is something stuck?
>>> I only got it once.  I think Devrim bcc'd you.
>
> O.k. guys this is a big deal. This went out on our announce list which means
> lots of people are receiving this more than once. This is the second time
> this has happen in recent history.
>
> What is it going to take to *fix* it.

Fix what?  You report duplicates, JoshB reports 1 ... as I say each time you 
bitch about this, *save copies of the messages* so that I can see them ... did 
you do that this time?

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHhB234QvfyHIvDvMRAtCaAJ4nqJiHO/TcWMni7kPW6YppVuv8wACg7MqT
iN5AAlXTgKF3Qr1t1FylMz4=
=Uoxb
-----END PGP SIGNATURE-----



Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Tuesday, January 08, 2008 10:19:04 -0800 "Joshua D. Drake" 
<jd@commandprompt.com> wrote:

> However, Marc might be hard to get a hold of as he has a day job now.

Right, which means that I don't read my mailbox for a few hours of the day... 
I'm  still waiting for all those various headers that you've save about this, 
like I ask each and every time it happens ...

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHhB4z4QvfyHIvDvMRAoj9AJ9b9Os1kj6toxNmeVWM5f2tmA3U3ACfb38/
IyZ/DeeJRwEOzcR2g6WJaeU=
=FXAw
-----END PGP SIGNATURE-----



Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 08 Jan 2008 21:04:55 -0400
"Marc G. Fournier" <scrappy@hub.org> wrote:


> > What is it going to take to *fix* it.
> 
> Fix what?  You report duplicates, JoshB reports 1 ... as I say each
> time you bitch about this, *save copies of the messages* so that I
> can see them ... did you do that this time?
> 

If you read the thread instead of bitching, you will see that Magnus
already provided the headers. 

Next time you want to slam someone I suggest you wash your own
underwear first.

Sincerely,

Joshua D. Drake

- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHhCLqATb/zqfZUUQRApJJAKCfmWOuH3MlnVxiAlUl+w8kOfulqwCfQ9kz
VJG8R9HnJlxRJgAOHwtSXcY=
=bgcw
-----END PGP SIGNATURE-----

Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 08 Jan 2008 21:06:58 -0400
"Marc G. Fournier" <scrappy@hub.org> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> 
> - --On Tuesday, January 08, 2008 10:19:04 -0800 "Joshua D. Drake" 
> <jd@commandprompt.com> wrote:
> 
> > However, Marc might be hard to get a hold of as he has a day job
> > now.
> 
> Right, which means that I don't read my mailbox for a few hours of
> the day... I'm  still waiting for all those various headers that
> you've save about this, like I ask each and every time it happens ...

See Magnus's email to thread.

Joshua D. Drake



- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHhCMbATb/zqfZUUQRAh+pAJoCug4YYjzNHxKIBj5ra+dxpKbotwCeN1uK
p8GNvXGANNYncENlKZX618c=
=8tm3
-----END PGP SIGNATURE-----

Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Funny, maybe Magnus sent you some he didn't send me?  All I saw in his email 
was:

"So far I've only kept the headers of the latest one ..."

Next time you want to slam someone back, I suggest you actually *read* that 
which you refer to ...

- --On Tuesday, January 08, 2008 17:27:06 -0800 "Joshua D. Drake" 
<jd@commandprompt.com> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Tue, 08 Jan 2008 21:04:55 -0400
> "Marc G. Fournier" <scrappy@hub.org> wrote:
>
>
>> > What is it going to take to *fix* it.
>>
>> Fix what?  You report duplicates, JoshB reports 1 ... as I say each
>> time you bitch about this, *save copies of the messages* so that I
>> can see them ... did you do that this time?
>>
>
> If you read the thread instead of bitching, you will see that Magnus
> already provided the headers.
>
> Next time you want to slam someone I suggest you wash your own
> underwear first.
>
> Sincerely,
>
> Joshua D. Drake
>
> - --
> The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
> Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFHhCLqATb/zqfZUUQRApJJAKCfmWOuH3MlnVxiAlUl+w8kOfulqwCfQ9kz
> VJG8R9HnJlxRJgAOHwtSXcY=
> =bgcw
> -----END PGP SIGNATURE-----



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHhCad4QvfyHIvDvMRAndbAKCIN+ybZnEysbZdccob9a/TA/vW5QCcCBC2
W4GGQhgqirkavhAbbEOpagc=
=1zaa
-----END PGP SIGNATURE-----



Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Tuesday, January 08, 2008 17:27:55 -0800 "Joshua D. Drake" 
<jd@commandprompt.com> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Tue, 08 Jan 2008 21:06:58 -0400
> "Marc G. Fournier" <scrappy@hub.org> wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>>
>>
>> - --On Tuesday, January 08, 2008 10:19:04 -0800 "Joshua D. Drake"
>> <jd@commandprompt.com> wrote:
>>
>> > However, Marc might be hard to get a hold of as he has a day job
>> > now.
>>
>> Right, which means that I don't read my mailbox for a few hours of
>> the day... I'm  still waiting for all those various headers that
>> you've save about this, like I ask each and every time it happens ...
>
> See Magnus's email to thread.

I did ... he sent one header, for the latest version he received, after having 
deleted the other ones ... but if you had actually *read* his, you would have 
not only read *that*, but also noticed that his email did only include *one* 
header ...


Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHhCbf4QvfyHIvDvMRAj7CAJ9CLXp017/tVwOayCSfs2WtRPosbwCg7rFj
QqF0B//qaDQGeN69r8PKQss=
=oJIE
-----END PGP SIGNATURE-----



Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Alvaro Herrera
Date:
Marc G. Fournier wrote:

> Fix what?  You report duplicates, JoshB reports 1 ... as I say each time you 
> bitch about this, *save copies of the messages* so that I can see them ... did 
> you do that this time?

Surely you can grep the logs for the Message-Id?

1199744552.30375.57.camel@localhost.localdomain

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Since nobody actually  understands *why* I need multiple headers, let me 
explain:

Nothing in the headers below tells me *where* the problem is ... for instance, 
according to the below, it was sent and received in the moderator queue at 
around 16:30 on Monday ... it appears that at ~10:42am, it was then released 
out of the queue and proceeded to be sent to Magnus, and delivered within a 
couple of minutes ... so delivery time looks to be okay ...

A second set of headers would at least let me see at what point the message 
id's divert ... for instance, if "ESMTP id 281FC12A672F" stay'd constant, but 
"ESMTP id 476F9DCC195" changed, then mx2.hub.org resent it to magnus multiple 
times, and I can look at that ...

According to mx2.hub.org itself, that ESMTP id sent to magnus *once*:

mx2# grep 281FC12A672F /var/log/maillog | grep magnus
Jan  8 10:43:25 mx2 postfix/smtp[83356]: 281FC12A672F: 
to=<magnus@hagander.net>, relay=svr2.hagander.net[88.198.128.226]:25, delay=28, 
delays=0.19/27/0.54/0.36, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 
476F9DCC195)

And with next to no delay (28s) ...

Now, what we don't know ... those other 4 to 5 copies, do they all have the 
same ESMTP id as this one, or did somehow 4 to 5 different copies get into the 
queue, with seperate ESMTP ids ...

And, of course, each time everyone brings this up, I ask for the same thing, so 
it isn't as if its the first time I ask for this ...

Even doing a grep on magnus@hagander.net doesn't show any errors ... connection 
to his host don't appear to have much in the way of delay ... that 28 second 
one seems to be about the biggest one ...


- --On Tuesday, January 08, 2008 16:40:21 +0100 Magnus Hagander 
<magnus@hagander.net> wrote:

> On Tue, Jan 08, 2008 at 07:26:32AM -0800, Josh Berkus wrote:
>> On Tuesday 08 January 2008 07:23, Joshua D. Drake wrote:
>> > I have seen this email 3 times... is something stuck?
>>
>> I only got it once.  I think Devrim bcc'd you.
>
> I think I've got 4 or 5. So far I've only kept the headers of the latest one,
> but I'll keep any further ones I receive as well. Here's the latest one:
>
> Received: from mx2.hub.org (mx2.hub.org [200.46.204.254])
>         by svr2.hagander.net (Postfix) with ESMTP id 476F9DCC195
>         for <magnus@hagander.net>; Tue,  8 Jan 2008 15:43:24 +0100 (CET)
> Received: from postgresql.org (postgresql.org [200.46.204.71])
>         by mx2.hub.org (Postfix) with ESMTP id 281FC12A672F;
>         Tue,  8 Jan 2008 10:42:57 -0400 (AST)
> Received: from localhost (unknown [200.46.204.187])
>         by postgresql.org (Postfix) with ESMTP id 7374E2E0383
>         for <pgsql-announce-postgresql.org@postgresql.org>; Mon,  7 Jan
> 2008 18:22:55 -0400 (AST)
> Received: from postgresql.org ([200.46.204.71])
>  by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
>  with ESMTP id 86638-06 for <pgsql-announce-postgresql.org@postgresql.org>;
>  Mon,  7 Jan 2008 18:22:44 -0400 (AST)
> Received: from lists.commandprompt.com (host-159.commandprompt.net
> [207.173.203.159])
>         by postgresql.org (Postfix) with ESMTP id 233F12E3355
>         for <pgsql-announce@PostgreSQL.org>; Mon,  7 Jan 2008 18:22:48
> -0400 (AST)
>
>
> Seems to me that it was re-injected between postgresql.org (AKA localhost
> AKA unknown AKA 200.46.204.71 - there's still some serious DNS breakage
> going on there) and mx2.hub.org.
>
> //Magnus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHhCo84QvfyHIvDvMRAiEaAJ9gSO/M/456rTRbdV8EMqaFUzMyTgCfWTWn
urAzHvskECHUwswulPxHjZs=
=IJJP
-----END PGP SIGNATURE-----



Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Tuesday, January 08, 2008 22:46:36 -0300 Alvaro Herrera 
<alvherre@commandprompt.com> wrote:

> Marc G. Fournier wrote:
>
>> Fix what?  You report duplicates, JoshB reports 1 ... as I say each time you
>> bitch about this, *save copies of the messages* so that I can see them ...
>> did  you do that this time?
>
> Surely you can grep the logs for the Message-Id?
>
> 1199744552.30375.57.camel@localhost.localdomain

Sure, and that proves what?

mx2# grep 1199744552.30375.57.camel@localhost.localdomain /var/log/maillog | wc 
- -l    230

mx2# grep 1199744552.30375.57.camel@localhost.localdomain /var/log/maillog | 
grep 'to=' | awk '{print $7}'
to=<emilio@lavall.net>,
to=<larry@boeldt.net>,
to=<f.lopinto@arsretia.net>,
to=<m.ottone@arsretia.net>,
to=<barmstrong@claytoncountyiowa.net>,
to=<christie@lipa.net>,
to=<jaw@ic.net>,
to=<rik@devroede.net>,
to=<adrien.dessemond@softhome.net>,
to=<arkangr@softhome.net>,
to=<leobonilla@softhome.net>,
to=<scottpetersen@softhome.net>,
to=<somphong@softhome.net>,
to=<zeljko_vujaklija@softhome.net>,
to=<postgre@mbusse.net>,
to=<davidh@saltydog.net>,
to=<pgsql@ml.altern8.net>,
to=<shastie@fulcrum.net>,
to=<nate@nateirwin.net>,
to=<clive@compucar.net>,
to=<oldingr@ifiber.net>,
to=<jsr@magiclamp.net>,
to=<avi.neer@jenzabar.net>,
to=<john.blazevich@jenzabar.net>,
to=<2117916_dgb@21cn.net>,
to=<freed_yang@21cn.net>,
to=<davidnhim@whitecap.net>,
to=<support@hightechcenter.net>,
to=<rfdudley@dundeeassociates.net>,
to=<Brendan@cpks.net>,
to=<kcundick@konnections.net>,
to=<tomd@ultraasp.net>,
to=<acas@cpovo.net>,
to=<lou@w3net.net>,
to=<mfried@coversant.net>,
to=<mkurtz@intellidot.net>,
to=<Iggy@4gateway.net>,
to=<kkaveh@pedec.net>,
to=<mikew@carlton.hostmailer.net>,
to=<ssykes@olympiasports.net>,
mx2# grep 1199744552.30375.57.camel@localhost.localdomain /var/log/maillog | 
grep 'to='|grep magnus
mx2#

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHhCsK4QvfyHIvDvMRAgnVAKCKxxYQLP9VbyJ88+EeJBbkb3xDoQCg7V8r
ziTtk9FfbSUYy0PUBDPywqc=
=wlaV
-----END PGP SIGNATURE-----



Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Magnus Hagander
Date:
On Tue, Jan 08, 2008 at 09:58:20PM -0400, Marc G. Fournier wrote:
> 
> Since nobody actually  understands *why* I need multiple headers, let me 
> explain:
> 
> Nothing in the headers below tells me *where* the problem is ... for instance, 
> according to the below, it was sent and received in the moderator queue at 
> around 16:30 on Monday ... it appears that at ~10:42am, it was then released 
> out of the queue and proceeded to be sent to Magnus, and delivered within a 
> couple of minutes ... so delivery time looks to be okay ...

If that's so, then that's the problem. Because the first copy of this email
was received *way* earlier than that. As in right after it was sent. Maybe
you can get a bunch of the original headers fromt he MBOX files in the
archives? (they have only one copy of it, but I'll bet it shows a
completely different delivery time)


> A second set of headers would at least let me see at what point the message 
> id's divert ... for instance, if "ESMTP id 281FC12A672F" stay'd constant, but 
> "ESMTP id 476F9DCC195" changed, then mx2.hub.org resent it to magnus multiple 
> times, and I can look at that ...

Yeah, I wish I did keep them. But it's not like I expected more copies to
arrive later :-( And they arrived far enough apart not to still be
available in the trash.


> According to mx2.hub.org itself, that ESMTP id sent to magnus *once*:

That corresponds to my logs. Actually, grepping for the messageid it only
turns up once.

Who generates the messageid? Devrim? majordomo? maia? Because I only see that
exact messageid once (not ESMTP id here, actual message id
"1199744552.30375.57.camel@localhost.localdomain") only shows up once in my
logs. So the different copies of the mail was delivered with different
messageids.



> Now, what we don't know ... those other 4 to 5 copies, do they all have the 
> same ESMTP id as this one, or did somehow 4 to 5 different copies get into the 
> queue, with seperate ESMTP ids ...

They don't have teh same ESMTP on my end at least, and not even the same
"actual" id. 


> Even doing a grep on magnus@hagander.net doesn't show any errors ... connection 
> to his host don't appear to have much in the way of delay ... that 28 second 
> one seems to be about the biggest one ...

Yeah, the delay is usually early in the chain, but usualliy not that bad.
But the total delay in the mod queue is the problem here I think - because
I certainly received the first copy a *lot* earlier than this one left the
moderator queue (if that's what's done at the step of that long delay)


//Magnus


Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Guillaume Smet
Date:
Magnus Hagander a écrit :
> If that's so, then that's the problem. Because the first copy of this email
> was received *way* earlier than that. As in right after it was sent. Maybe
> you can get a bunch of the original headers fromt he MBOX files in the
> archives? (they have only one copy of it, but I'll bet it shows a
> completely different delivery time)

Be careful because there were 2 different emails:
[ANNOUNCE] Announcing PostgreSQL RPM Buildfarm
[ANNOUNCE] PostgreSQL RPM Yum repository is available

Just to be sure everyone did notice that because they were highly 
related. The last time we had the problem, I got the message three times 
but this time I have only one copy of each.

--
Guillaume



Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Magnus Hagander
Date:
On Wed, Jan 09, 2008 at 09:52:14AM +0100, Guillaume Smet wrote:
> Magnus Hagander a écrit :
> >If that's so, then that's the problem. Because the first copy of this email
> >was received *way* earlier than that. As in right after it was sent. Maybe
> >you can get a bunch of the original headers fromt he MBOX files in the
> >archives? (they have only one copy of it, but I'll bet it shows a
> >completely different delivery time)
> 
> Be careful because there were 2 different emails:
> [ANNOUNCE] Announcing PostgreSQL RPM Buildfarm
> [ANNOUNCE] PostgreSQL RPM Yum repository is available
> 
> Just to be sure everyone did notice that because they were highly 
> related. The last time we had the problem, I got the message three times 
> but this time I have only one copy of each.

Oops. I'm totally guilty of that. That means I didn't get four copies, but
I certainly got more than one of at least one of them. But you can probably
scratch my comment about the long time difference.

//Magnus


Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Guillaume Smet
Date:
Magnus Hagander a écrit :
> If that's so, then that's the problem. Because the first copy of this email
> was received *way* earlier than that. As in right after it was sent. Maybe
> you can get a bunch of the original headers fromt he MBOX files in the
> archives? (they have only one copy of it, but I'll bet it shows a
> completely different delivery time)

Just to be sure everyone noticed that, there were two different emails, 
one announcing the RPM buildfarm and one announcing the Yum repo.

Is anyone interested in the headers of the last time the problem occurs 
(errata to beta4 release)? I just digged in my archives and I still have 
them if anyone is interested.

This time, I got each email once so I can't help.

--
Guillaume




Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Wednesday, January 09, 2008 09:37:00 +0100 Magnus Hagander 
<magnus@hagander.net> wrote:

> If that's so, then that's the problem. Because the first copy of this email
> was received *way* earlier than that. As in right after it was sent. Maybe
> you can get a bunch of the original headers fromt he MBOX files in the
> archives? (they have only one copy of it, but I'll bet it shows a
> completely different delivery time)

The archives would only have one copy ... its after it was written to the 
archives that anything would have been duplicated ...

> Who generates the messageid? Devrim? majordomo? maia? Because I only see that
> exact messageid once (not ESMTP id here, actual message id
> "1199744552.30375.57.camel@localhost.localdomain") only shows up once in my
> logs. So the different copies of the mail was delivered with different
> messageids.

To the best of my knowledge, the message id its is generated by Devrim's system 
... in fact, if you look at the headers of this 'thread', you will also see a 
References header which is the message ids of other messages in this thread:

References: <4783956A.9060800@commandprompt.com> 
<200801080726.32233.josh@agliodbs.com> 
<20080108154021.GJ25881@svr2.hagander.net> 
<C522C01EE1A0A98ECCF6D5C4@ganymede.hub.org>
MIME-Version: 1.0

And, from the message I'm responding to:

Message-ID: <20080109083700.GA25870@svr2.hagander.net>

Notice that your domain name is in the @ part?

Now, I'm not 100% certain what happens if someone *re-injected* the message, 
but suspect it would end up with a new message id .. which *could* explain what 
happened (if we had headers to check) ... there are multiple moderators for the 
list, so if someone re-injected the message a few times, th emoderators could 
have re-approved each one without realizing they were doing it ...

... but, that woudln't explain why JoshB or I received multiple copies, just 
you and JD, so I don't really consider that one a high probability, just low 
possibility ... in fact, very low possibility, as we shoudl then see multiple 
copies in the archives ...

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD4DBQFHhL914QvfyHIvDvMRAuOIAJiWbXw2fuVrjvfZp3QR992YId5RAJ4iDT8Q
XaOnvrmPk+veyRjPRaXzlg==
=ecci
-----END PGP SIGNATURE-----



Re: [Fwd: [ANNOUNCE] PostgreSQL RPM Yum repository is available]

From
Alvaro Herrera
Date:
Marc G. Fournier wrote:

> Now, I'm not 100% certain what happens if someone *re-injected* the message, 
> but suspect it would end up with a new message id .. which *could* explain what 
> happened (if we had headers to check) ... there are multiple moderators for the 
> list, so if someone re-injected the message a few times, th emoderators could 
> have re-approved each one without realizing they were doing it ...

Note that when a duplicated message is sent to a moderator, the
moderation notice says so -- "Partial duplicate checksum" or something
like that.  I have noticed a couple of idiotic mail systems reinjecting
old mail that way.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.