Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1E6EE2E002F for ; Mon, 25 Feb 2008 12:59:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51139-01 for ; Mon, 25 Feb 2008 12:59:32 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.230]) by postgresql.org (Postfix) with ESMTP id 9BDF22E003A for ; Mon, 25 Feb 2008 12:59:31 -0400 (AST) Received: by qb-out-0506.google.com with SMTP id o12so2575430qba.17 for ; Mon, 25 Feb 2008 08:59:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; bh=bW+0SXkiXDyfbQUSlPbkaEhNWgSlHMomFIKYvC70diY=; b=HegOXDwBNgNbZRmSAej+6atG2noRibA4FKDplg80ISXD43hdB7bwbSSXSc9zItl3GG9x93xob9oobwHx3pqP8VuwKtZ6iziXHOJZRP9+auuLcCEv6+5cdKSKDpZeBrtMuvRDzUbAMd0X+tT1lmUNKYfb5cpDW7ma5D1HgpgA4go= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=mc0e/XL4qMXJLr6pSGRWU+OWYTUT4os4hfjxYsmvUEo9fUsuIwZ3eCM3LVKs1gCJmeKV47IWAV+6gcmDMw93xGeJbHvTDp9abkgy7oQPECcdmqkfs4RV93YcQ4zvAoKcp+gJuBE7KV4nAfDDcl8POVT2mVpiEL2e6Bf/q4m3Gz0= Received: by 10.140.163.3 with SMTP id l3mr2295019rve.68.1203958769182; Mon, 25 Feb 2008 08:59:29 -0800 (PST) Received: by 10.140.142.20 with HTTP; Mon, 25 Feb 2008 08:59:29 -0800 (PST) Message-ID: Date: Mon, 25 Feb 2008 10:59:29 -0600 From: "Aaron Bono" To: "Simon Riggs" Subject: Re: System in Recovery Mode Cc: Postgres In-Reply-To: <1203958095.4252.79.camel@ebony.site> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17234_13507171.1203958769178" References: <1203954173.4252.59.camel@ebony.site> <1203958095.4252.79.camel@ebony.site> X-Google-Sender-Auth: 98008f7f991a22a2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.903 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001, URIBL_RHS_DOB=0.901 X-Spam-Level: X-Archive-Number: 200802/319 X-Sequence-Number: 28393 ------=_Part_17234_13507171.1203958769178 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Mon, Feb 25, 2008 at 10:48 AM, Simon Riggs wrote: > 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? This is NOT a modified PostgreSQL server. We are not using any externally supplied C language functions or modules. However, we did have to upgrade from what CPanel put on the server (it used version 7.x) and I don't know what CPanel has done. We did have a hard drive problem (errors on the drive) in the past and they had to swap out a drive. It is a RAID configuration so no backup/restore was necessary. We do have intermittent problems with the server and believe it is related to Postgres. Our SA assures us there are currently no system errors or other indications of hard drive problems. We want to do an upgrade but are apprehensive as this is a production server. Is there a place we can go to to get a good idea of how to perform an upgrade with as little interruption to service as possible? Thanks, Aaron -- ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_17234_13507171.1203958769178 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Mon, Feb 25, 2008 at 10:48 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
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?

This is NOT a modified PostgreSQL server.  We are not using any externally supplied C language functions or modules.  However, we did have to upgrade from what CPanel put on the server (it used version 7.x) and I don't know what CPanel has done.

We did have a hard drive problem (errors on the drive) in the past and they had to swap out a drive.  It is a RAID configuration so no backup/restore was necessary.  We do have intermittent problems with the server and believe it is related to Postgres.  Our SA assures us there are currently no system errors or other indications of hard drive problems.

We want to do an upgrade but are apprehensive as this is a production server.  Is there a place we can go to to get a good idea of how to perform an upgrade with as little interruption to service as possible?

Thanks,
Aaron


--
==================================================================
  Aaron Bono
  Aranya Software Technologies, Inc.
  http://www.aranya.com
  http://codeelixir.com
================================================================== ------=_Part_17234_13507171.1203958769178--