Re: Crash while recovering database index relation

From: Guy Thornley <guy(at)esphion(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Crash while recovering database index relation
Date: 2004-01-07 23:40:23
Message-ID: 20040107234023.GE18564@conker.esphion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> > PANIC: invalid page header in block 6 of relation "17792"
> > This was on postgres 7.4.
>
> I believe this is fixed in 7.4.1:
...

> And no sign of corruption after you'd run through the recovery with
> zero_damaged_pages?
I checked them this morning; there isnt.
Sorry for bugging you about something already fixed

> That's what I'd expect if this scenario applies:
> the pages will be fixed by WAL recovery, it's just that the recently
> added check for broken page headers was interfering :-(

What I don't grok is why all the affected files were indexes, and none
of the heap files appeared to have junk pages

Guy Thornley

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-01-08 05:12:54 Re: Crash while recovering database index relation
Previous Message Seum-Lim Gan 2004-01-07 19:51:23 Re: dyntest.pgc not working in 7.4 ?