Hm, I'm not entirely convinced those are erroneous replays to wrong
blocks. They don't look right but there are no blocks of NULs
preceding them. So if they're wrong then they only extended the
relations by a single block.
The relfilenodes that have nul blocks before the last block are:
relfilenode | blockno | segnum | offset | lsn | tli | flags |
lower | upper | special | pagesize | version | prune_xid
-------------+----------+--------+----------+-----+-----+-------+-------+-------+---------+----------+---------+-----------
1261982 | 7141472 | 54 | 7141472 | 0/0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0
473158 | 18090059 | 138 | 18090059 | 0/0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0
1366221 | 2208159 | 16 | 2208159 | 0/0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0
1364767 | 3631161 | 27 | 3631161 | 0/0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0
1519286 | 311808 | 2 | 311808 | 0/0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
