Re: BUG #5077: Corrupted Table - Mailing list pgsql-bugs
From | Kaelten |
---|---|
Subject | Re: BUG #5077: Corrupted Table |
Date | |
Msg-id | bc5784710909232011t27409bfcs9b908e2e02ddeb0c@mail.gmail.com Whole thread Raw |
In response to | Re: BUG #5077: Corrupted Table (Andrew Gierth <andrew@tao11.riddles.org.uk>) |
List | pgsql-bugs |
I do have said copies and would be glad to help in whatever ways I am able = too. Bryan McLemore Kaelten On Wed, Sep 23, 2009 at 9:38 PM, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote: >>>>>> "Bryan" =3D=3D "Bryan McLemore" <kaelten@gmail.com> writes: > > =C2=A0Bryan> "invalid page header in block 900 of relation pg_tblspc/3204= 1/138911/187737" > > =C2=A0Bryan> http://pgsql.privatepaste.com/83JfmQGtS5 > > Privatepaste urls do expire, so for the record here is the relevant > part of the data in question: > > 00000000 =C2=A082 00 00 00 50 01 72 8a =C2=A001 00 04 00 00 00 84 03 =C2= =A0|....P.r.........| > 00000010 =C2=A002 00 04 20 13 01 d9 00 =C2=A0a8 8e a2 01 d0 8d a2 01 =C2= =A0|... ............| > 00000020 =C2=A000 00 00 00 00 00 00 00 =C2=A000 00 00 00 00 00 00 00 =C2= =A0|................| > 00000030 =C2=A000 00 00 00 00 00 00 00 =C2=A016 00 01 00 17 00 01 00 =C2= =A0|................| > 00000040 =C2=A018 00 01 00 19 00 01 00 =C2=A01a 00 01 00 00 00 00 00 =C2= =A0|................| > 00000050 =C2=A01b 00 01 00 00 00 00 00 =C2=A000 00 00 00 00 00 00 00 =C2= =A0|................| > 00000060 =C2=A000 00 00 00 00 00 00 00 =C2=A000 00 00 00 e8 9e 24 02 =C2= =A0|..............$.| > 00000070 =C2=A060 9e 0c 01 d0 9d 1c 01 =C2=A010 9d 74 01 48 9c 84 01 =C2= =A0|`.........t.H...| > 00000080 =C2=A0c0 9b 0c 01 e8 9a a2 01 =C2=A030 9a 6c 01 50 99 bc 01 =C2= =A0|........0.l.P...| > 00000090 =C2=A01c 00 01 00 1d 00 01 00 =C2=A01e 00 01 00 28 00 01 00 =C2= =A0|............(...| > 000000a0 =C2=A029 00 01 00 2a 00 01 00 =C2=A02b 00 01 00 2c 00 01 00 =C2= =A0|)...*...+...,...| > 000000b0 =C2=A02d 00 01 00 30 98 32 02 =C2=A068 97 8c 01 80 96 cc 01 =C2= =A0|-...0.2.h.......| > 000000c0 =C2=A0d8 95 44 01 98 94 74 02 =C2=A0c0 93 a8 01 a8 92 24 02 =C2= =A0|..D...t.......$.| > 000000d0 =C2=A020 92 0c 01 90 91 1c 01 =C2=A0d0 90 74 01 08 90 84 01 =C2= =A0| .........t.....| > 000000e0 =C2=A080 8f 0c 01 00 00 00 00 =C2=A000 00 00 00 00 00 00 00 =C2= =A0|................| > 000000f0 =C2=A000 00 00 00 00 00 00 00 =C2=A000 00 00 00 00 00 00 00 =C2= =A0|................| > > The data appears intact other than invalid values for pd_lower and pd_spe= cial > (and possibly pd_upper, wasn't sure about that one). > > =C2=A0Bryan> The reason they asked me to report this is that it appears > =C2=A0Bryan> this occured when a disk filled up while pg_dump was running. > > I have no idea whether the disk full was the cause of this, but there > was no evidence in the page data of a hardware failure, so it could do > with investigation. (I don't know of any external cause that could damage > pd_lower while leaving the rest of the page intact.) > > I did ask Bryan on IRC to make a copy of his data directory before doing > the fix. > > -- > Andrew (irc:RhodiumToad) >
pgsql-bugs by date: