Re: Could not open file "pg_clog/...." - Mailing list pgsql-general

Alvaro Herrera wrote:
> Markus Wollny wrote:

> > magazine=# vacuum analyze pcaction.article;
> > PANIC:  corrupted item pointer: 5
> > server closed the connection unexpectedly
> >         This probably means the server terminated abnormally
> >         before or while processing the request.
> > The connection to the server was lost. Attempting reset: Failed.
>
> This error comes from this piece of PageRepairFragmentation:

>                 if (itemidptr->itemoff < (int) pd_upper ||
>                     itemidptr->itemoff >= (int) pd_special)
>                     ereport(ERROR,
>                             (errcode(ERRCODE_DATA_CORRUPTED),
>                              errmsg("corrupted item pointer: %u",
>                                     itemidptr->itemoff)));

I forgot to mention that this ERROR is promoted to PANIC by the
critical section defined in lazy_vacuum_page().

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.