pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PANIC: right sibling
3+ messages / 3 participants
[nested] [flat]

* PANIC: right sibling
@ 2007-12-04 17:03 Scott Whitney <swhitney@journyx.com>
  2007-12-04 18:03 ` Re: PANIC: right sibling Kenneth Marshall <ktm@rice.edu>
  2007-12-04 18:05 ` Re: PANIC: right sibling Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 2 replies; 3+ messages in thread

From: Scott Whitney @ 2007-12-04 17:03 UTC (permalink / raw)
  To: pgsql-admin

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.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PANIC: right sibling
  2007-12-04 17:03 PANIC: right sibling Scott Whitney <swhitney@journyx.com>
@ 2007-12-04 18:03 ` Kenneth Marshall <ktm@rice.edu>
  1 sibling, 0 replies; 3+ messages in thread

From: Kenneth Marshall @ 2007-12-04 18:03 UTC (permalink / raw)
  To: Scott Whitney <swhitney@journyx.com>; +Cc: pgsql-admin

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
> 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: PANIC: right sibling
  2007-12-04 17:03 PANIC: right sibling Scott Whitney <swhitney@journyx.com>
@ 2007-12-04 18:05 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Alvaro Herrera @ 2007-12-04 18:05 UTC (permalink / raw)
  To: Scott Whitney <swhitney@journyx.com>; +Cc: pgsql-admin

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.

Probably a REINDEX on the corrupted index would solve it.

I'm not sure if there's a known bug in the version you're using.  If
there is, obviously you should upgrade to a fixed one.  Otherwise you
may be able to help us find it by saving the corrupted index before
reindexing it, for examination.

-- 
Alvaro Herrera                          Developer, http://www.PostgreSQL.org/
"The only difference is that Saddam would kill you on private, where the
Americans will kill you in public" (Mohammad Saleh, 39, a building contractor)



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-12-04 18:05 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-12-04 17:03 PANIC: right sibling Scott Whitney <swhitney@journyx.com>
2007-12-04 18:03 ` Kenneth Marshall <ktm@rice.edu>
2007-12-04 18:05 ` Alvaro Herrera <alvherre@alvh.no-ip.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox