Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2052D2E003A for ; Mon, 25 Feb 2008 13:03:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 01833-08 for ; Mon, 25 Feb 2008 13:03:53 -0400 (AST) X-Greylist: delayed 00:16:30.004061 by SQLgrey-1.7.5 Received: from outmail137094.authsmtp.co.uk (outmail137094.authsmtp.co.uk [62.13.137.94]) by postgresql.org (Postfix) with ESMTP id DF43F2E0039 for ; Mon, 25 Feb 2008 13:03:53 -0400 (AST) Received: from outmail128181.authsmtp.net (outmail128181.authsmtp.net [62.13.128.181]) by punt4.authsmtp.com (8.14.1/8.14.1/Kp) with ESMTP id m1PGkWLX071692; Mon, 25 Feb 2008 16:46:32 GMT Received: from [192.168.0.3] (85-211-31-42.dyn.gotadsl.co.uk [85.211.31.42]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m1PGlJQR058378; Mon, 25 Feb 2008 16:47:20 GMT Subject: Re: System in Recovery Mode From: Simon Riggs To: Aaron Bono Cc: Postgres In-Reply-To: References: <1203954173.4252.59.camel@ebony.site> Content-Type: text/plain Date: Mon, 25 Feb 2008 16:48:15 +0000 Message-Id: <1203958095.4252.79.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 54d36ef2-e3c1-11dc-9670-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagBba1xT HGQLW1xEUVt7XWR/ aQofZQBDYEtPQQZr TkxLXVBXCwUmXB1h cUJkM3tycg1Ff3Y+ ZERjWj5eWBB5cxMr QFMBFj4HeGZhPDMC WUZfdx5UcAJLdhoR aVd4ByJDAzANdhER MyoSGQV5BiRENClQ CgALZWgfSkEVEyQt DzUFEThH X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:787/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/320 X-Sequence-Number: 28394 On Mon, 2008-02-25 at 09:53 -0600, Aaron Bono wrote: <2008-02-25 07:15:24 CST username 127.0.0.1>ERROR: unrecognized node type: 4260493 > ... > <2008-02-25 07:15:49 CST username 127.0.0.1>CONTEXT: PL/pgSQL > function "get_branch_for_zip" line 61 at fetch ... > <2008-02-25 07:15:56 CST >LOG: could not truncate directory > "pg_multixact/members": apparent wraparound Some interesting failures there. Is this a modified Postgres server? Are you running externally supplied C language functions? Have you had hardware problems? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com