Re: Is there possibility btree_redo with XLOG_BTREE_DELETE done between standby_redo and the end of backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: y39chen <yan-jack(dot)chen(at)nokia(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is there possibility btree_redo with XLOG_BTREE_DELETE done between standby_redo and the end of backup
Date: 2017-05-24 15:18:48
Message-ID: 2253.1495639128@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

y39chen <yan-jack(dot)chen(at)nokia(dot)com> writes:
> is there possibility btree_redo with XLOG_BTREE_DELETE info done between
> standby_redo and the end of backup? I have PostgreSQL 9.3.14 which have
> some patches to use and easy to happen.
> ...
> //inconsistent detected in btree_xlog_delete_get_latestRemovedXid()
> [26005-59251d35.6595-726087] 2017-05-24 05:42:22.513 GMT < > WARNING:
> 01000: btree_xlog_delete_get_latestRemovedXid: cannot operate with
> inconsistent data

This looks a whole lot like a bug we fixed in 9.3.15, cf

https://www.postgresql.org/message-id/flat/DB5PR07MB15416C65687A1EA9AC0D26F8D6E00%40DB5PR07MB1541.eurprd07.prod.outlook.com

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2017-05-24 15:30:14 Re: logical replication in PG10 BETA
Previous Message Bill Moran 2017-05-24 14:52:01 Re: Current best practice for maximum shared_buffers settings on big hardware?