Re: Recovery inconsistencies, standby much larger than primary - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Recovery inconsistencies, standby much larger than primary
Date
Msg-id CAM-w4HPEkA6oKO4UBtpB8dewp4q9WOa+DYFxM4Buj_6jmJM4Ww@mail.gmail.com
Whole thread Raw
In response to Re: Recovery inconsistencies, standby much larger than primary  (Greg Stark <stark@mit.edu>)
Responses Re: Recovery inconsistencies, standby much larger than primary  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: mvcc catalo gsnapshots and TopTransactionContext
Next
From: Tom Lane
Date:
Subject: Re: Recovery inconsistencies, standby much larger than primary