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
|
| Список | 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 по дате отправления: