Re: Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tech 2010 <tch072(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227
Date: 2009-11-19 15:36:38
Message-ID: 14984.1258644998@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tech 2010 <tch072(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray Stell 2009-11-19 15:43:57 index storage planning
Previous Message Bruno Lavoie 2009-11-19 14:42:36 Re: Dblink to Oracle