Re: PANIC: corrupted item pointer - Mailing list pgsql-general

From Jeff Davis
Subject Re: PANIC: corrupted item pointer
Date
Msg-id 1333131887.28198.6.camel@sussancws0025
Whole thread Raw
In response to Re: PANIC: corrupted item pointer  (Janning Vygen <vygen@kicktipp.de>)
Responses Re: PANIC: corrupted item pointer
List pgsql-general
On Fri, 2012-03-30 at 16:02 +0200, Janning Vygen wrote:
> The PANIC occurred first on March, 19. My servers uptime ist 56 days, so
> about 4th of February. There was no power failure since i started to use
> this machine. This machine is in use since March, 7. I checked it twice:
> Now power failure.

Just to be sure: the postgres instance didn't exist before you started
to use it, right?

> > Did you get the PANIC and WARNINGs on the primary or the replica? It
> > might be worth doing some comparisons between the two systems.
>
> It only happend on my primary server. My backup server has no suspicious
> log entries.

Do you have a full copy of the two data directories? It might be worth
exploring the differences there, but that could be a tedious process.

> It is pretty obvious to me the segmentation fault is the main reason for
> getting the PANIC afterwards. What can cause a segmentation fault? Is
> there anything to analyse further?

It's clear that they are connected, but it's not clear that it was the
cause. To speculate: it might be that disk corruption caused the
segfault as well as the PANICs.

Do you have any core files? Can you get backtraces?

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: where to find initdb log file?
Next
From: "Hu, William"
Date:
Subject: PSQL 9.1.3 segmentation fault