Request a Demo
Home   >   mailing lists

Re: Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227 - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227
Date
Msg-id 14984.1258644998@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227  (Tech 2010 <tch072@gmail.com>)
List pgsql-general
Tree view 
Tech 2010 <tch072@gmail.com> writes:
>> xy=# reindex table xy_data;
>> ERROR: �concurrent insert in progress

> Should I drop and recreate indexes?

I think that database is pretty well hosed.  (What happened to it to
cause all this, anyway?)  A dump/initdb/reload is probably indicated
at this point.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruno Lavoie
Date:
Subject: Re: Dblink to Oracle
Next
From: Ray Stell
Date:
Subject: index storage planning