Re: Where art thou pg_clog?

From: Casey Duncan <casey(at)pandora(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Where art thou pg_clog?
Date: 2007-02-15 22:04:08
Message-ID: 1AC77B42-C907-4EEF-96CE-7D61FC81F56F@pandora.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Feb 15, 2007, at 1:50 PM, Peter Eisentraut wrote:

> Casey Duncan wrote:
>> 2007-02-15 00:35:03.324 PST ERROR: could not access status of
>> transaction 2565134864
>> 2007-02-15 00:35:03.325 PST DETAIL: could not open file "pg_clog/
>> 098E": No such file or directory
>>
>> The first time this happened, I chalked it up to some kind of disk
>> corruption based on the mailing list archives. So I dumped the
>> databases, did a fresh initdb, forced an fsck (these run with a jfs
>> data partition and an ext2 wal partition) which found no problems and
>> then reloaded the databases.
>>
>> Now about a week later
>
> Unless you actually executed 2565134864 transactions in that one week,
> this is still data corruption.
>
> Check for faulty memory.

I'd be more inclined to agree with you if it happened on only one
server machine. But this has now happened on two different machines
in the space of a week.

My understanding is that the transaction id logged is garbage because
the bookkeeping fields have been clobbered for some tuple(s). The one
last week was really low (like < 1000).

-Casey

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2007-02-15 22:07:18 Re: postgresql 8.2 Installation error at "gmake"
Previous Message Peter Eisentraut 2007-02-15 21:50:25 Re: Where art thou pg_clog?