Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 108602E0093 for ; Tue, 4 Dec 2007 14:04:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 23361-07 for ; Tue, 4 Dec 2007 14:03:57 -0400 (AST) Received: from is.rice.edu (is.rice.edu [128.42.42.24]) by postgresql.org (Postfix) with ESMTP id 0C5832E0062 for ; Tue, 4 Dec 2007 14:03:58 -0400 (AST) Received: from scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160]) by is.rice.edu (Postfix) with ESMTP id C0F5741884; Tue, 4 Dec 2007 12:03:56 -0600 (CST) Received: from is.rice.edu ([128.42.42.24]) by scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160]) (amavisd-new, port 10024) with ESMTP id 23055-02; Tue, 4 Dec 2007 12:03:56 -0600 (CST) Received: by is.rice.edu (Postfix, from userid 18612) id 169CD41880; Tue, 4 Dec 2007 12:03:56 -0600 (CST) Date: Tue, 4 Dec 2007 12:03:55 -0600 From: Kenneth Marshall To: Scott Whitney Cc: pgsql-admin@postgresql.org Subject: Re: PANIC: right sibling Message-ID: <20071204180355.GE1837@it.is.rice.edu> References: <20071204170252.00BAA3F276D@mail.int.journyx.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20071204170252.00BAA3F276D@mail.int.journyx.com> User-Agent: Mutt/1.5.16 (2007-06-09) X-Virus-Scanned: by amavis-2.2.1 at scan1.mail.rice.edu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/10 X-Sequence-Number: 27527 You have a corrupt index, run: REINDEX INDEX tickets1; Ken On Tue, Dec 04, 2007 at 11:03:15AM -0600, Scott Whitney wrote: > I don't really understand the postings I've found on this issue. This has > been going on for quite some time, but now that I'm regularly vacuuming this > db, I was looking for any info on how to fix this problem...I don't even > know enough about it to know what to include in this message. > > > This is the last output of: > > vacuumdb -f -z -v rt3 > > > > vacuumdb: vacuuming of database "rt3" failed: PANIC: right sibling is not > next child in "tickets1" > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate >