Re: Recovery inconsistencies, standby much larger than primary

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Recovery inconsistencies, standby much larger than primary
Дата
Msg-id CAM-w4HPEkA6oKO4UBtpB8dewp4q9WOa+DYFxM4Buj_6jmJM4Ww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recovery inconsistencies, standby much larger than primary  (Greg Stark <stark@mit.edu>)
Ответы Re: Recovery inconsistencies, standby much larger than primary  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: mvcc catalo gsnapshots and TopTransactionContext
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Recovery inconsistencies, standby much larger than primary