Skip site navigation (1) Skip section navigation (2)

Re: BUG #3567: invalid page header in block XXXXof relation

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: sapna kapoor <sapna(dot)kapoor(at)nic(dot)in>, pgsql-bugs(at)postgresql(dot)org, Robert Mach <mach(dot)robert(at)gmail(dot)com>
Subject: Re: BUG #3567: invalid page header in block XXXXof relation
Date: 2007-08-23 08:55:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Tom Lane wrote:
> "sapna kapoor" <sapna(dot)kapoor(at)nic(dot)in> writes:
>> some tables are giving error : 
>> ERROR:  invalid page header in block 32655 of relation "AAAA" while
>> accessing. 
>> Some are giving
>> ERROR:  could not access status of transaction 1778384896
>> DETAIL:  could not open file "pg_clog/06A0": No such file or directory
> If you had just one of these, I might think it suggested a software
> problem.  

The similar clog problem was reported there

It looks like vacuum truncate clog file but, some tuples still have xmin or xmax 
from truncated clog.


You try following project. It is still in 
alpha, but page check 
( should 
be work.


In response to

pgsql-bugs by date

Next:From: Dave PageDate: 2007-08-23 11:30:29
Subject: Cannot create a type in pg_catalog
Previous:From: Marko KreenDate: 2007-08-23 08:54:58
Subject: Re: BUG #3571: call to decrypt causes segfault

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group