Re: what is up with the PG mailing lists?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

This is where I hate debugging email issues ... Bruce IMd me about this, I
looked around and the only problem that I could see was that the caching DNS
server within the VPS itself was still reporting one scanner, so I restarted
named, and postfix after to clear out any caches it might have, and mail
started flowing again ...

The only thing I have in the log file is:

Nov 1 14:22:41 postgresql postfix/smtpd[26360]: E4E039FC8E6:
client=hub.org[200.46.204.220]
Nov 1 14:22:41 postgresql postfix/cleanup[73513]: E4E039FC8E6:
message-id=<A43323733D66A14A086CABF7(at)ganymede(dot)hub(dot)org>
Nov 1 14:23:58 postgresql postfix/qmgr[7655]: E4E039FC8E6:
from=<scrappy(at)hub(dot)org>, size=3553, nrcpt=1 (queue active)
Nov 1 16:12:19 postgresql postfix/smtp[51424]: E4E039FC8E6:
to=<pgsql-www-postgresql(dot)org(at)postgresql(dot)org>,
orig_to=<pgsql-www(at)postgresql(dot)org>, relay=maia.hub.org[200.46.204.184]:10024,
conn_use=7, delay=6578, delays=78/6496/0.01/3.9, dsn=2.6.0, status=sent (250
2.6.0 Ok, id=62395-04-7, from MTA: 250 2.0.0 Ok: queued as 9E4B49FC802)
Nov 1 16:12:19 postgresql postfix/qmgr[7655]: E4E039FC8E6: removed

Which shows the 'delay', but, there are no errors on the scanner server, nor
did I touch either of htem to fix the problem ...

so it looks like the scanner received it and hung trying to send it back, until
I reset the receiving side, whereby it finished ..

But there is nothing on either side to indicate a problem ... but restarting
postfix 'unstuck' it ...

- --On Thursday, November 01, 2007 15:23:12 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:

> "Marc G. Fournier" <scrappy(at)hub(dot)org> writes:
>> But, again, it would be interesting to look at a specific one, with
>> message-id, and see what the logs show for reasons of delays ...
>
> Well, the current problems seem to be entirely inside hub.org, and so
> all this banter about DNS etc seems not relevant. A handy example is
> this same message I'm replying to, which seems to have been hung up
> for 2.5 hours:
>
> Received: from maia-2.hub.org (maia-2.hub.org [200.46.204.187] (may be
> forged)) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lA1JCPC2010552
> for <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Thu, 1 Nov 2007 15:12:26 -0400 (EDT)
> Received: from postgresql.org (postgresql.org [200.46.204.71])
> by maia-2.hub.org (Postfix) with ESMTP id 912252C9544
> for <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Thu, 1 Nov 2007 16:12:22 -0300 (ADT)
> Received: from localhost (unknown [200.46.204.184])
> by postgresql.org (Postfix) with ESMTP id 9E4B49FC802
> for <pgsql-www-postgresql(dot)org(at)postgresql(dot)org>; Thu, 1 Nov 2007 16:12:18
> -0300 (ADT) Received: from postgresql.org ([200.46.204.71])
> by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
> with ESMTP id 62395-04-7 for <pgsql-www-postgresql(dot)org(at)postgresql(dot)org>;
> Thu, 1 Nov 2007 16:12:11 -0300 (ADT)
> Received: from hub.org (hub.org [200.46.204.220])
> by postgresql.org (Postfix) with ESMTP id E4E039FC8E6
> for <pgsql-www(at)postgresql(dot)org>; Thu, 1 Nov 2007 14:22:40 -0300 (ADT)
> Received: from localhost (unknown [200.46.204.184])
> by hub.org (Postfix) with ESMTP id A428DB475C8
> for <pgsql-www(at)postgresql(dot)org>; Thu, 1 Nov 2007 13:43:35 -0300 (ADT)
> Received: from hub.org ([200.46.204.220])
> by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
> with ESMTP id 56221-03; Thu, 1 Nov 2007 13:43:01 -0300 (ADT)
> Received: from fserv.hub.org (blk-137-93-67.eastlink.ca [24.137.93.67])
> by hub.org (Postfix) with ESMTP id BB0BCB47581;
> Thu, 1 Nov 2007 13:43:02 -0300 (ADT)
> Received: from [192.168.1.2] (unknown [192.168.1.2])
> by fserv.hub.org (Postfix) with ESMTP id AD2C34E165;
> Thu, 1 Nov 2007 13:43:02 -0300 (ADT)
> Date: Thu, 01 Nov 2007 13:42:31 -0300
> From: "Marc G. Fournier" <scrappy(at)hub(dot)org>
> To: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
> cc: Magnus Hagander <magnus(at)hagander(dot)net>,
> Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-www(at)postgresql(dot)org
> Subject: Re: [pgsql-www] what is up with the PG mailing lists?
> Message-ID: <A43323733D66A14A086CABF7(at)ganymede(dot)hub(dot)org>
> In-Reply-To: <20071101092806(dot)3b1fa452(at)scratch>
> References: <25716(dot)1193887595(at)sss(dot)pgh(dot)pa(dot)us>
> <DADF296033D290EF9634F611(at)ganymede(dot)hub(dot)org> <26669(dot)1193891360(at)sss(dot)pgh(dot)pa(dot)us>
> <47299585(dot)7030402(at)hagander(dot)net> <47299957(dot)5020605(at)postgresql(dot)org>
> <2968(dot)1193919208(at)sss(dot)pgh(dot)pa(dot)us> <20071101080959(dot)49f3087b(at)scratch>
> <20071101152333(dot)GM27676(at)crankycanuck(dot)ca> <4729F105(dot)30704(at)hagander(dot)net>
> <1127E6493CBA8A29F343C4D7(at)ganymede(dot)hub(dot)org> <4729F7D2(dot)6050608(at)hagander(dot)net>
> <AD9BF3BA60F6634EA7FCDB76(at)ganymede(dot)hub(dot)org>
> <20071101092806(dot)3b1fa452(at)scratch> X-Mailer: Mulberry/4.0.8 (Linux/x86)
> MIME-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline
> X-Virus-Scanned: Maia Mailguard 1.0.1
> X-Virus-Scanned: Maia Mailguard 1.0.1
> X-Mailing-List: pgsql-www
> List-Archive: <http://archives.postgresql.org/pgsql-www>
> List-Help: <mailto:majordomo(at)postgresql(dot)org?body=help>
> List-ID: <pgsql-www.postgresql.org>
> List-Owner: <mailto:pgsql-www-owner(at)postgresql(dot)org>
> List-Post: <mailto:pgsql-www(at)postgresql(dot)org>
> List-Subscribe: <mailto:majordomo(at)postgresql(dot)org?body=sub%20pgsql-www>
> List-Unsubscribe: <mailto:majordomo(at)postgresql(dot)org?body=unsub%20pgsql-www>
> Precedence: bulk
> Sender: pgsql-www-owner(at)postgresql(dot)org
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

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

iD8DBQFHKk2T4QvfyHIvDvMRAsA/AKCFj3U3RNAIvehPULV8S8PfbgeLlwCcDZSp
qCWZnSOOTTQydS1Tk+e1Vs8=
=DFh4
-----END PGP SIGNATURE-----