Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B9BC99F98E1 for ; Thu, 1 Nov 2007 19:22:31 -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 11545-01 for ; Thu, 1 Nov 2007 19:22:20 -0300 (ADT) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 8DE709F9B67 for ; Thu, 1 Nov 2007 19:19:17 -0300 (ADT) Received: from localhost (unknown [200.46.204.184]) by hub.org (Postfix) with ESMTP id D8007B475D5 for ; Thu, 1 Nov 2007 19:19:16 -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 03954-01-6; Thu, 1 Nov 2007 19:18:53 -0300 (ADT) Received: from fserv.hub.org (blk-137-93-67.eastlink.ca [24.137.93.67]) by hub.org (Postfix) with ESMTP id BA304B477DE; Thu, 1 Nov 2007 19:05:39 -0300 (ADT) Received: from [192.168.1.2] (unknown [192.168.1.2]) by fserv.hub.org (Postfix) with ESMTP id 69AB84E3BE; Thu, 1 Nov 2007 19:05:42 -0300 (ADT) Date: Thu, 01 Nov 2007 19:05:07 -0300 From: "Marc G. Fournier" To: Tom Lane cc: "Joshua D. Drake" , Magnus Hagander , Andrew Sullivan , pgsql-www@postgresql.org Subject: Re: what is up with the PG mailing lists? Message-ID: 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-Archive-Number: 200711/52 X-Sequence-Number: 12830 -----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= Nov 1 14:23:58 postgresql postfix/qmgr[7655]: E4E039FC8E6: from=, size=3553, nrcpt=1 (queue active) Nov 1 16:12:19 postgresql postfix/smtp[51424]: E4E039FC8E6: to=, orig_to=, 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 wrote: > "Marc G. Fournier" 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 ; 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 ; 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 ; 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 ; > 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 ; 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 ; 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" > To: "Joshua D. Drake" > cc: Magnus Hagander , > Andrew Sullivan , pgsql-www@postgresql.org > Subject: Re: [pgsql-www] what is up with the PG mailing lists? > Message-ID: > In-Reply-To: <20071101092806.3b1fa452@scratch> > References: <25716.1193887595@sss.pgh.pa.us> > <26669.1193891360@sss.pgh.pa.us> > <47299585.7030402@hagander.net> <47299957.5020605@postgresql.org> > <2968.1193919208@sss.pgh.pa.us> <20071101080959.49f3087b@scratch> > <20071101152333.GM27676@crankycanuck.ca> <4729F105.30704@hagander.net> > <1127E6493CBA8A29F343C4D7@ganymede.hub.org> <4729F7D2.6050608@hagander.net> > > <20071101092806.3b1fa452@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: > List-Help: > List-ID: > List-Owner: > List-Post: > List-Subscribe: > List-Unsubscribe: > Precedence: bulk > Sender: pgsql-www-owner@postgresql.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@hub.org MSN . scrappy@hub.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-----