Re: Recovery inconsistencies, standby much larger than primary

On Sun, Feb 9, 2014 at 2:54 PM, Greg Stark <stark@mit.edu> wrote:

> Bad block's page header -- this is in the 56'th relation segment:
>
> =# select
(page_header(E'\\x20050000583b05aa050000002800180500200420000000001098e00f2090e00f088d24061885e00f0000000000000000')).*;
>      lsn      | tli | flags | lower | upper | special | pagesize |
> version | prune_xid
> --------------+-----+-------+-------+-------+---------+----------+---------+-----------
>  520/AA053B58 |   5 |     0 |    40 |  1304 |    8192 |     8192 |
>   4 |         0


> Looking at the block at offset 4773121 (which is in the 36th segment):
...
> d9de7pcqls4ib6=# select
>
(page_header(E'\\x20050000a00a0bad050000002c00a00200200420000000001098e00f2090e00f088d24061885e00fa082ec040000000000000000....')).*;
>      lsn      | tli | flags | lower | upper | special | pagesize |
> version | prune_xid
> --------------+-----+-------+-------+-------+---------+----------+---------+-----------
>  520/AD0B0AA0 |   5 |     0 |    44 |   672 |    8192 |     8192 |
>   4 |         0
> (1 row)

And I finally tracked down the xlog record for this stray write:

[cur:520/AA051FE0, xid:7635428, rmid:10(Heap), len/tot_len:21/7005,
info:8, prev:520/AA051F20] insert: s/d/r:1663/16385/16650
blk/off:4773121/4 header: none
[cur:520/AA051FE0, xid:7635428, rmid:10(Heap), len/tot_len:21/7005,
info:8, prev:520/AA051F20] bkpblock[1]: s/d/r:1663/16385/16650
blk:4773121 hole_off/len:40/1264



-- 
greg