Search Postgresql Archives

Re: Could not open file "pg_clog/...."

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux