Re: More along the lines of "WEIRD CRASH?!?!"? - Mailing list pgsql-admin

From Tom Lane
Subject Re: More along the lines of "WEIRD CRASH?!?!"?
Date
Msg-id 274.1048014178@sss.pgh.pa.us
Whole thread Raw
In response to Re: More along the lines of "WEIRD CRASH?!?!"?  (Murthy Kambhampaty <murthy.kambhampaty@goeci.com>)
List pgsql-admin
Murthy Kambhampaty <murthy.kambhampaty@goeci.com> writes:
> I am not running initdb between tries to get rid of the corruption (I am
> dropping the tables that are created). However, the filename is not always
> the same (the repeated ones are almost certainly cases where I forgot to
> drop the tables between iterations):

Hm.  This looks like ongoing data corruption to me --- the 'pg_clog'
failure is often the first visible symptom of a trashed tuple header
(or completely trashed page --- which is a case that we should detect
earlier, but don't at the moment).

Have you run memory and disk diagnostics recently on this machine?
I think it's dropping data every so often.

            regards, tom lane

pgsql-admin by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: Re: More along the lines of "WEIRD CRASH?!?!"?
Next
From: Murthy Kambhampaty
Date:
Subject: Re: More along the lines of "WEIRD CRASH?!?!"?