| From: | Greg Stark <stark(at)mit(dot)edu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Recovery inconsistencies, standby much larger than primary |
| Date: | 2014-02-02 16:59:51 |
| Message-ID: | CAM-w4HPEkA6oKO4UBtpB8dewp4q9WOa+DYFxM4Buj_6jmJM4Ww@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-02-02 17:03:15 | Re: Recovery inconsistencies, standby much larger than primary |
| Previous Message | Tom Lane | 2014-02-02 16:52:22 | Re: mvcc catalo gsnapshots and TopTransactionContext |