Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8B7E4633FC7 for ; Thu, 6 Aug 2009 12:47:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79156-01 for ; Thu, 6 Aug 2009 15:47:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by mail.postgresql.org (Postfix) with ESMTP id E7254633531 for ; Thu, 6 Aug 2009 12:47:20 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-220-118-158.bk10-dsl.surnet.cl [201.220.118.158]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id n76Fu9S6032013 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 6 Aug 2009 08:56:11 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 1E6DAD419E; Thu, 6 Aug 2009 11:47:08 -0400 (CLT) Date: Thu, 6 Aug 2009 11:47:08 -0400 From: Alvaro Herrera To: Luke Koops Cc: "'Nikhil Sontakke'" , Magnus Hagander , "pgsql-bugs@postgresql.org" Subject: Re: BUG #4958: Stats collector hung on WaitForMultipleObjectsEx while attempting to recv a datagram Message-ID: <20090806154708.GE7769@alvh.no-ip.org> References: <9837222c0908030656m6ed69a26gc90a6c94b41a4c47@mail.gmail.com> <9837222c0908030716r416d789ewef3f77c65b39d916@mail.gmail.com> <9837222c0908030730kd59b9c2v7583666c5716aead@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Thu, 06 Aug 2009 08:56:11 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/35 X-Sequence-Number: 23862 Luke Koops wrote: > When this sequence happens, I can see a backend postgres.exe process > start up and then exit very quickly. Note the absence of the > "incomplete startup package" message. > > Could it be related to the stats collector problem? The stats > collector on this system has been hung for over 6 weeks, so the timing > of this problem is quite delayed. Maybe you should try a network sniffer and see if you can spot anything weird. I think Wireshark can decode the Postgres protocol. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support