From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com> |
Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <amit(dot)kapila(at)enterprisedb(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Peter Geoghegan <pg(at)heroku(dot)com> |
Subject: | Re: WAL consistency check facility |
Date: | 2016-08-26 14:24:25 |
Message-ID: | 20160826142425.GA311664@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Kuntal Ghosh wrote:
> Thanks a lot.
>
> I just want to mention the situation where I was getting the
> speculative token related inconsistency.
>
> ItemPointer in backup page from master:
> LOG: ItemPointer BlockNumber: 1 OffsetNumber:65534 Speculative: true
> CONTEXT: xlog redo at 0/127F4A48 for Heap/INSERT+INIT: off 1
>
> ItemPointer in current page from slave after redo:
> LOG: ItemPointer BlockNumber: 0 OffsetNumber:1 Speculative: false
> CONTEXT: xlog redo at 0/127F4A48 for Heap/INSERT+INIT: off 1
>
> As the block numbers are different, I was getting the following warning:
> WARNING: Inconsistent page (at byte 8166) found for record
> 0/127F4A48, rel 1663/16384/16946, forknum 0, blkno 0, Backup Page
> Header : (pd_lower: 28 pd_upper: 8152 pd_special: 8192) Current Page
> Header: (pd_lower: 28 pd_upper: 8152 pd_special: 8192)
> CONTEXT: xlog redo at 0/127F4A48 for Heap/INSERT+INIT: off 1
>
> In heap_xlog_insert, t_ctid is always set to blkno and xlrec->offnum.
> I think this is why I was getting the above warning.
Umm, really? Then perhaps this *is* a bug. Peter?
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Fabien COELHO | 2016-08-26 14:34:13 | Re: Set log_line_prefix and application name in test drivers |
Previous Message | Martín Marqués | 2016-08-26 13:53:26 | Re: pg_dump with tables created in schemas created by extensions |