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

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Tech 2010 <tch072(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227
Date: 2009-11-18 12:40:36
Message-ID: bddc86150911180440n71626014j6c3af4f3784240f9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/11/18 Tech 2010 <tch072(at)gmail(dot)com>:
> Hello!
>
> How do I location of this pointer and how do I zero it so I can access
> the rest of the data?
>
> "zero_damaged_pages = true" did not help in this case, because I
> always get same numbers being zeroed. This is with 8.4.0 and 8.4.1.
>
> Thanks.
>

You probably just need to reindex a table. Try vacuuming each table
individually until you get this error, or just check the vacuum log
output to identify it, then just run a REINDEX on it.

Regards

Thom

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vidhya Bondre 2009-11-18 13:16:40 Re: Creating new database
Previous Message Ivan Sergio Borgonovo 2009-11-18 12:16:24 Re: passing parameters to multiple statements