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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers