Re: pg_dumpall failure - could not access status of transaction

From: "Robert Leftwich" <pg(at)rtl(dot)fmailbox(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dumpall failure - could not access status of transaction
Date: 2007-02-03 03:09:33
Message-ID: 1170472173.30402.1172683791@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Fri, 02 Feb 2007 21:21:47 -0500, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> said:
>
> Yeah. What file names are actually present in $PGDATA/pg_clog/, and
> what does pg_controldata say about the current XID counter? We have
> seen some bugs where clog files get deleted before they're not needed
> anymore :-(

pg_clog only has 2 files:

0000 0001

pg_controldata's only reference to XID is:

Latest checkpoint's NextXID: 1927588

>
> Also, can you show us the pg_filedump output for the page of
> pg_description you think is trashed? I find "-i -f" options give
> the most useful output usually.
>

Block 4 ********************************************************
<Header> -----
Block Offset: 0x00008000 Offsets: Lower 536 (0x0218)
Block: Size 8192 Version 3 Upper 556 (0x022c)
LSN: logid 0 recoff 0x0018440c Special 8192 (0x2000)
Items: 129 Free Space: 20
Length (including item array): 540

0000: 00000000 0c441800 01000000 18022c02 .....D........,.
0010: 00200320 cc9f6800 989f6400 649f6800 . . ..h...d.d.h.
0020: 309f6400 009f5e00 d09e5e00 9c9e6200 0.d...^...^...b.
0030: 649e6a00 2c9e6a00 ec9d7c00 b49d7000 d.j.,.j...|...p.
0040: 709d8200 409d5e00 0c9d6800 d89c6800 p(dot)(dot)(dot)(at)(dot)^(dot)(dot)(dot)h(dot)(dot)(dot)h(dot)
0050: a49c6400 689c7200 2c9c7400 f89b6800 ..d.h.r.,.t...h.
0060: b49b8400 809b6600 4c9b6600 189b6600 ......f.L.f...f.
0070: e49a6600 b09a6600 7c9a6600 3c9a8000 ..f...f.|.f.<...
0080: fc998000 ac999e00 5c999e00 1c997a00 ........\.....z.
0090: dc987c00 9c987a00 5c987c00 1c987a00 ..|...z.\.|...z.
00a0: dc977e00 9c977e00 58978200 1c977400 ..~...~.X.....t.
00b0: e0967200 9c968200 4896a200 00969000 ..r.....H.......
00c0: b8958e00 80956c00 4c956800 14956a00 ......l.L.h...j.
00d0: dc946c00 98948400 54948200 08949400 ..l.....T.......
00e0: d0937000 98936a00 60937000 2c936200 ..p...j.`.p.,.b.
00f0: ec927c00 a8928200 60928e00 28926a00 ..|.....`...(.j.
0100: e8917e00 a4918200 68917800 28918000 ..~.....h.x.(...
0110: dc909400 a4906c00 6c906a00 30907400 ......l.l.j.0.t.
0120: f88f6a00 c08f6e00 8c8f6200 4c8f8000 ..j...n...b.L...
0130: 0c8f8000 cc8e8000 8c8e8000 488e8400 ............H...
0140: 048e8400 b48d9a00 7c8d6c00 448d6c00 ........|.l.D.l.
0150: 148d5e00 e48c5e00 a48c7e00 688c7600 ..^...^...~.h.v.
0160: 248c8400 d88b9600 9c8b7200 6c8b5e00 $.........r.l.^.
0170: 3c8b5e00 0c8b5e00 dc8a5e00 a88a6200 <.^...^...^...b.
0180: 708a6a00 308a7c00 f8897000 b4898200 p.j.0.|...p.....
0190: 7c896a00 40897200 04897400 c4887c00 |(dot)j(dot)(at)(dot)r(dot)(dot)(dot)t(dot)(dot)(dot)|.
01a0: 94886000 3888b800 08885e00 d8875e00 ..`.8.....^...^.
01b0: a4876200 6c876a00 2c877c00 f4867000 ..b.l.j.,.|...p.
01c0: b0868200 78866a00 38867c00 00866a00 ....x.j.8.|...j.
01d0: c0857c00 88857000 44858200 0c856a00 ..|...p.D.....j.
01e0: cc847c00 90847200 54847400 20846800 ..|...r.T.t. .h.
01f0: f0835e00 bc836800 8c835e00 5c835e00 ..^...h...^.\.^.
0200: 28836200 f8825e00 c4826800 90826800 (.b...^...h...h.
0210: 5c826400 2c825e00 00000000 \.d.,.^.....

<Data> ------
Item 1 -- Length: 52 Offset: 8140 (0x1fcc) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1fcc: 00000000 00000000 00000000 00000000 ................
1fdc: 00000000 00000000 00020000 00000000 ................
1fec: 00000000 00000000 00000000 00000000 ................
1ffc: 00000000 ....

Item 2 -- Length: 50 Offset: 8088 (0x1f98) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1f98: 00000000 00000000 00000000 00000000 ................
1fa8: 00000000 00000000 00020000 00000000 ................
1fb8: 00000000 00000000 00000000 00000000 ................
1fc8: 0000 ..

Item 3 -- Length: 52 Offset: 8036 (0x1f64) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1f64: 00000000 00000000 00000000 00000000 ................
1f74: 00000000 00000000 00020000 00000000 ................
1f84: 00000000 00000000 00000000 00000000 ................
1f94: 00000000 ....

Item 4 -- Length: 50 Offset: 7984 (0x1f30) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1f30: 00000000 00000000 00000000 00000000 ................
1f40: 00000000 00000000 00020000 00000000 ................
1f50: 00000000 00000000 00000000 00000000 ................
1f60: 0000 ..

Item 5 -- Length: 47 Offset: 7936 (0x1f00) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1f00: 00000000 00000000 00000000 00000000 ................
1f10: 00000000 00000000 00020000 00000000 ................
1f20: 00000000 00000000 00000000 000000 ...............

Item 6 -- Length: 47 Offset: 7888 (0x1ed0) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1ed0: 00000000 00000000 00000000 00000000 ................
1ee0: 00000000 00000000 00020000 00000000 ................
1ef0: 00000000 00000000 00000000 000000 ...............

Item 7 -- Length: 49 Offset: 7836 (0x1e9c) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1e9c: 00000000 00000000 00000000 00000000 ................
1eac: 00000000 00000000 00020000 00000000 ................
1ebc: 00000000 00000000 00000000 00000000 ................
1ecc: 00 .

Item 8 -- Length: 53 Offset: 7780 (0x1e64) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1e64: 00000000 00000000 00000000 00000000 ................
1e74: 00000000 00000000 00020000 00000000 ................
1e84: 00000000 00000000 00000000 00000000 ................
1e94: 00000000 00 .....

Item 9 -- Length: 53 Offset: 7724 (0x1e2c) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1e2c: 00000000 00000000 00000000 00000000 ................
1e3c: 00000000 00000000 00020000 00000000 ................
1e4c: 00000000 00000000 00000000 00000000 ................
1e5c: 00000000 00 .....

Item 10 -- Length: 62 Offset: 7660 (0x1dec) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1dec: 00000000 00000000 00000000 00000000 ................
1dfc: 00000000 00000000 00020000 00000000 ................
1e0c: 00000000 00000000 00000000 00000000 ................
1e1c: 00000000 00000000 00000000 0000 ..............

Item 11 -- Length: 56 Offset: 7604 (0x1db4) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1db4: 00000000 00000000 00000000 00000000 ................
1dc4: 00000000 00000000 00020000 00000000 ................
1dd4: 00000000 00000000 00000000 00000000 ................
1de4: 00000000 00000000 ........

Item 12 -- Length: 65 Offset: 7536 (0x1d70) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1d70: 00000000 00000000 00000000 00000000 ................
1d80: 00000000 00000000 00020000 00000000 ................
1d90: 00000000 00000000 00000000 00000000 ................
1da0: 00000000 00000000 00000000 00000000 ................
1db0: 00 .

Item 13 -- Length: 47 Offset: 7488 (0x1d40) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1d40: 00000000 00000000 00000000 00000000 ................
1d50: 00000000 00000000 00020000 00000000 ................
1d60: 00000000 00000000 00000000 000000 ...............

Item 14 -- Length: 52 Offset: 7436 (0x1d0c) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1d0c: 00000000 00000000 00000000 00000000 ................
1d1c: 00000000 00000000 00020000 00000000 ................
1d2c: 00000000 00000000 00000000 00000000 ................
1d3c: 00000000 ....

Item 15 -- Length: 52 Offset: 7384 (0x1cd8) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1cd8: 00000000 00000000 00000000 00000000 ................
1ce8: 00000000 00000000 00020000 00000000 ................
1cf8: 00000000 00000000 00000000 00000000 ................
1d08: 00000000 ....

Item 16 -- Length: 50 Offset: 7332 (0x1ca4) Flags: USED
XMIN: 0 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0200 (XMIN_INVALID)
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1ca4: 00000000 00000000 00000000 00000000 ................
1cb4: 00000000 00000000 00020000 00000000 ................
1cc4: 00000000 00000000 00000000 00000000 ................
1cd4: 0000 ..

Item 17 -- Length: 57 Offset: 7272 (0x1c68) Flags: USED
XMIN: 3183024 CMIN: 3183000 XMAX: 3182976 CMAX|XVAC: 3182952
Block Id: 0 linp Index: 0 Attributes: 0 Size: 0
infomask: 0x0000 ()
Error: Computed header length not equal to header size.
Computed <28> Header: <0>

1c68: b0913000 98913000 80913000 68913000 ..0...0...0.h.0.
1c78: 00000000 00000000 00000000 00000000 ................
1c88: 00000000 00000000 00000000 00000000 ................
1c98: 00000000 00000000 00 .........

Item 18 -- Length: 58 Offset: 7212 (0x1c2c) Flags: USED
XMIN: 3183384 CMIN: 3183360 XMAX: 3183336 CMAX|XVAC: 3183312
Block Id: 2461532208 linp Index: 37536 Attributes: 48 Size: 48
infomask: 0x9288
(HASCOMPRESSED|XMAX_SHARED_LOCK|XMIN_INVALID|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <48>

1c2c: 18933000 00933000 e8923000 d0923000 ..0...0...0...0.
1c3c: b8923000 a0923000 88923000 70923000 ..0...0...0.p.0.
1c4c: 58923000 40923000 28923000 10923000 X(dot)0(dot)(at)(dot)0(dot)(.0...0.
1c5c: f8913000 e0913000 c891 ..0...0...

Item 19 -- Length: 52 Offset: 7160 (0x1bf8) Flags: USED
XMIN: 3183696 CMIN: 3183672 XMAX: 3183648 CMAX|XVAC: 3183624
Block Id: 2481979440 linp Index: 37848 Attributes: 48 Size: 48
infomask: 0x93c0
(XMAX_EXCL_LOCK|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMIN_INVALID|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <48>

1bf8: 50943000 38943000 20943000 08943000 P.0.8.0. .0...0.
1c08: f0933000 d8933000 c0933000 a8933000 ..0...0...0...0.
1c18: 90933000 78933000 60933000 48933000 ..0.x.0.`.0.H.0.
1c28: 30933000 0.0.

Item 20 -- Length: 66 Offset: 7092 (0x1bb4) Flags: USED
XMIN: 3184104 CMIN: 3184080 XMAX: 3184056 CMAX|XVAC: 3184032 OID:
3183840
Block Id: 2508718128 linp Index: 38256 Attributes: 48 Size: 48
infomask: 0x9558
(HASCOMPRESSED|HASOID|XMAX_EXCL_LOCK|XMIN_COMMITTED|XMAX_COMMITTED|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <32> Header: <48>

1bb4: e8953000 d0953000 b8953000 a0953000 ..0...0...0...0.
1bc4: 88953000 70953000 58953000 40953000 (dot)(dot)0(dot)p(dot)0(dot)X(dot)0(dot)(at)(dot)0(dot)
1bd4: 28953000 10953000 f8943000 e0943000 (.0...0...0...0.
1be4: c8943000 b0943000 98943000 80943000 ..0...0...0...0.
1bf4: 6894 h.

Item 21 -- Length: 51 Offset: 7040 (0x1b80) Flags: USED
XMIN: 3184416 CMIN: 3184392 XMAX: 3184368 CMAX|XVAC: 3184344 OID:
3184152
Block Id: 2529165360 linp Index: 38568 Attributes: 48 Size: 48
infomask: 0x9690
(HASOID|XMAX_SHARED_LOCK|XMIN_INVALID|XMAX_COMMITTED|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <32> Header: <48>

1b80: 20973000 08973000 f0963000 d8963000 .0...0...0...0.
1b90: c0963000 a8963000 90963000 78963000 ..0...0...0.x.0.
1ba0: 60963000 48963000 30963000 18963000 `.0.H.0.0.0...0.
1bb0: 009630 ..0

Item 22 -- Length: 51 Offset: 6988 (0x1b4c) Flags: USED
XMIN: 3184728 CMIN: 3184704 XMAX: 3184680 CMAX|XVAC: 3184656
Block Id: 2549612592 linp Index: 38880 Attributes: 48 Size: 48
infomask: 0x97c8
(HASCOMPRESSED|XMAX_EXCL_LOCK|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMIN_INVALID|XMAX_COMMITTED|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <48>

1b4c: 58983000 40983000 28983000 10983000 X(dot)0(dot)(at)(dot)0(dot)(.0...0.
1b5c: f8973000 e0973000 c8973000 b0973000 ..0...0...0...0.
1b6c: 98973000 80973000 68973000 50973000 ..0...0.h.0.P.0.
1b7c: 389730 8.0

Item 23 -- Length: 51 Offset: 6936 (0x1b18) Flags: USED
XMIN: 3247672 CMIN: 3247720 XMAX: 3247768 CMAX|XVAC: 3247816 OID:
3247240
Block Id: 2398617649 linp Index: 36648 Attributes: 49 Size: 48
infomask: 0x8b98
(HASCOMPRESSED|HASOID|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMIN_INVALID|XMAX_INVALID|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <32> Header: <48>

1b18: 388e3100 688e3100 988e3100 c88e3100 8.1.h.1...1...1.
1b28: f88e3100 288f3100 988b3000 c88b3100 ..1.(.1...0...1.
1b38: f88b3100 288c3100 588c3100 888c3100 ..1.(.1.X.1...1.
1b48: 709830 p.0

Item 24 -- Length: 51 Offset: 6884 (0x1ae4) Flags: USED
XMIN: 3248056 CMIN: 3248104 XMAX: 3248152 CMAX|XVAC: 3248200
Block Id: 2423783473 linp Index: 36024 Attributes: 48 Size: 49
infomask: 0x8ce8
(HASCOMPRESSED|XMAX_EXCL_LOCK|XMAX_SHARED_LOCK|XMAX_COMMITTED|XMAX_INVALID|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <49>

1ae4: b88f3100 e88f3100 18903100 48903100 ..1...1...1.H.1.
1af4: 78903100 b88c3000 e88c3100 188d3100 x.1...0...1...1.
1b04: 488d3100 788d3100 a88d3100 d88d3100 H.1.x.1...1...1.
1b14: 088e31 ..1

Item 25 -- Length: 51 Offset: 6832 (0x1ab0) Flags: USED
XMIN: 3184920 CMIN: 3184896 XMAX: 3184872 CMAX|XVAC: 3184848
Block Id: 2562195504 linp Index: 39072 Attributes: 48 Size: 48
infomask: 0x90a8
(HASCOMPRESSED|XMAX_SHARED_LOCK|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <48>

1ab0: 18993000 00993000 e8983000 d0983000 ..0...0...0...0.
1ac0: b8983000 a0983000 a8903000 d8903100 ..0...0...0...1.
1ad0: 08913100 38913100 88983100 588f3000 ..1.8.1...1.X.0.
1ae0: 888f31 ..1

Item 26 -- Length: 51 Offset: 6780 (0x1a7c) Flags: USED
XMIN: 3185232 CMIN: 3185208 XMAX: 3185184 CMAX|XVAC: 3185160
Block Id: 2582642736 linp Index: 39384 Attributes: 48 Size: 48
infomask: 0x99c0
(XMAX_EXCL_LOCK|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_INVALID|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <48>

1a7c: 509a3000 389a3000 209a3000 089a3000 P.0.8.0. .0...0.
1a8c: f0993000 d8993000 c0993000 a8993000 ..0...0...0...0.
1a9c: 90993000 78993000 60993000 48993000 ..0.x.0.`.0.H.0.
1aac: 309930 0.0

Item 27 -- Length: 64 Offset: 6716 (0x1a3c) Flags: USED
XMIN: 3185616 CMIN: 3185592 XMAX: 3185568 CMAX|XVAC: 3185544
Block Id: 2607808560 linp Index: 39768 Attributes: 48 Size: 48
infomask: 0x9b40
(XMAX_EXCL_LOCK|XMIN_COMMITTED|XMIN_INVALID|XMAX_INVALID|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <48>

1a3c: d09b3000 b89b3000 a09b3000 889b3000 ..0...0...0...0.
1a4c: 709b3000 589b3000 409b3000 289b3000 p(dot)0(dot)X(dot)0(dot)(at)(dot)0(dot)(.0.
1a5c: 109b3000 f89a3000 e09a3000 c89a3000 ..0...0...0...0.
1a6c: b09a3000 989a3000 809a3000 689a3000 ..0...0...0.h.0.

Item 28 -- Length: 64 Offset: 6652 (0x19fc) Flags: USED
XMIN: 3247168 CMIN: 3247216 XMAX: 3247264 CMAX|XVAC: 3185928
Block Id: 2632974384 linp Index: 40152 Attributes: 48 Size: 48
infomask: 0x9cc0
(XMAX_EXCL_LOCK|XMAX_SHARED_LOCK|XMAX_COMMITTED|XMAX_INVALID|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <48>

19fc: 408c3100 708c3100 a08c3100 089d3000 @.1.p.1...1...0.
1a0c: f09c3000 d89c3000 c09c3000 a89c3000 ..0...0...0...0.
1a1c: 909c3000 789c3000 609c3000 489c3000 ..0.x.0.`.0.H.0.
1a2c: 309c3000 189c3000 009c3000 e89b3000 0.0...0...0...0.

Item 29 -- Length: 79 Offset: 6572 (0x19ac) Flags: USED
XMIN: 3248176 CMIN: 3248224 XMAX: 3248272 CMAX|XVAC: 3181776
Block Id: 2365587505 linp Index: 36144 Attributes: 49 Size: 49
infomask: 0x8d60
(XMAX_EXCL_LOCK|XMIN_COMMITTED|XMAX_COMMITTED|XMAX_INVALID|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <28> Header: <49>

19ac: 30903100 60903100 90903100 d08c3000 0.1.`.1...1...0.
19bc: 008d3100 308d3100 608d3100 908d3100 ..1.0.1.`.1...1.
19cc: c08d3100 f08d3100 208e3100 508e3100 ..1...1. .1.P.1.
19dc: 808e3100 b08e3100 e08e3100 108f3100 ..1...1...1...1.
19ec: 408f3100 b08b3000 e08b3100 108c31 @.1...0...1...1

Item 30 -- Length: 79 Offset: 6492 (0x195c) Flags: USED
XMIN: 3186216 CMIN: 3186192 XMAX: 3186168 CMAX|XVAC: 3186144 OID:
3182784
Block Id: 2647130160 linp Index: 40368 Attributes: 48 Size: 48
infomask: 0x9d98
(HASCOMPRESSED|HASOID|XMAX_SHARED_LOCK|XMIN_COMMITTED|XMAX_COMMITTED|XMAX_INVALID|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <32> Header: <48>

195c: 289e3000 109e3000 f89d3000 e09d3000 (.0...0...0...0.
196c: c89d3000 b09d3000 989d3000 809d3000 ..0...0...0...0.
197c: 689d3000 509d3000 389d3000 c0903000 h.0.P.0.8.0...0.
198c: f0903100 20913100 50913100 209d3100 ..1. .1.P.1. .1.
199c: 708f3000 a08f3100 d08f3100 009031 p.0...1...1...1

Item 31 -- Length: 61 Offset: 6428 (0x191c) Flags: USED
XMIN: 3186600 CMIN: 3186576 XMAX: 3186552 CMAX|XVAC: 3186528 OID:
3186336
Block Id: 2672295984 linp Index: 40752 Attributes: 48 Size: 48
infomask: 0x9f18
(HASCOMPRESSED|HASOID|XMIN_COMMITTED|XMIN_INVALID|XMAX_COMMITTED|XMAX_INVALID|XMAX_IS_MULTI|MOVED_IN)
Error: Computed header length not equal to header size.
Computed <32> Header: <48>

191c: a89f3000 909f3000 789f3000 609f3000 ..0...0.x.0.`.0.
192c: 489f3000 309f3000 189f3000 009f3000 H.0.0.0...0...0.
193c: e89e3000 d09e3000 b89e3000 a09e3000 ..0...0...0...0.
194c: 889e3000 709e3000 589e3000 40 ..0.p.0.X.0.@

Item 32 -- Length: 62 Offset: 6364 (0x18dc) Flags: USED
XMIN: 2 CMIN: 0 XMAX: 0 CMAX|XVAC: 0
Block Id: 4 linp Index: 32 Attributes: 4 Size: 28
infomask: 0x0902 (HASVARWIDTH|XMIN_COMMITTED|XMAX_INVALID)

18dc: 02000000 00000000 00000000 00000000 ................
18ec: 00000400 20000400 02091c00 b9030000 .... ...........
18fc: e7040000 14000000 78dfec73 01000000 ........x..s....
190c: 7803980b f01f0320 d89f3000 c09f x...... ..0...

SNIP NO MORE ERRORS...

*** End of Requested Range Encountered. Last Block Read: 4 ***

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-02-03 03:28:42 Re: pg_dumpall failure - could not access status of transaction
Previous Message Tom Lane 2007-02-03 02:21:47 Re: pg_dumpall failure - could not access status of transaction