Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETE done between standby_redo and the end of backup - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETE done between standby_redo and the end of backup
Date
Msg-id 2253.1495639128@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETE done betweenstandby_redo and the end of backup  (y39chen <yan-jack.chen@nokia.com>)
Responses Re: [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETEdone between standby_redo and the end of backup
List pgsql-general
Tree view 
y39chen <yan-jack.chen@nokia.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

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: [GENERAL] Current best practice for maximum shared_bufferssettings on big hardware?
Next
From: Igor Neyman
Date:
Subject: Re: [GENERAL] logical replication in PG10 BETA