Re: Another possible corruption bug in 9.3.2 or possibly a known MultiXact problem?
От | Greg Stark |
---|---|
Тема | Re: Another possible corruption bug in 9.3.2 or possibly a known MultiXact problem? |
Дата | |
Msg-id | CAM-w4HP8fHERDtFwsqTPpaS=JOf6LkEWrp7E1zZN7xZ6g3_DTA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Another possible corruption bug in 9.3.2 or possibly a known MultiXact problem? (Greg Stark <stark@mit.edu>) |
Ответы |
Re: Another possible corruption bug in 9.3.2 or possibly a
known MultiXact problem?
|
Список | pgsql-hackers |
Though I notice something I can't understand here. After activating the new clone subsequent attempts to select rows from the page bump the LSN, presumably due to touching hint bits (since the prune xid hasn't changed). But the checksum hasn't changed even after running CHECKPOINT. How is it possible for the LSN to get updated without changing the checksum? postgres=# select (page_header(get_raw_page('users',13065))).* ; lsn | checksum | flags | lower | upper | special| pagesize | version | prune_xid -------------+----------+-------+-------+-------+---------+----------+---------+-----------FD/330EC998 | -25547 | 1| 152 | 2576 | 8192 | 8192 | 4 | 5638282 (1 row) postgres=# select (page_header(get_raw_page('users',13065))).* ; lsn | checksum | flags | lower | upper | special| pagesize | version | prune_xid -------------+----------+-------+-------+-------+---------+----------+---------+-----------FD/33140160 | -25547 | 1| 152 | 2576 | 8192 | 8192 | 4 | 5638282 (1 row) postgres=# select (page_header(get_raw_page('users',13065))).* ; lsn | checksum | flags | lower | upper | special| pagesize | version | prune_xid -------------+----------+-------+-------+-------+---------+----------+---------+-----------FD/350016E8 | -25547 | 1| 152 | 2576 | 8192 | 8192 | 4 | 5638282 (1 row)
В списке pgsql-hackers по дате отправления: