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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETE done between standby_redo and the end of backup
Дата
Msg-id 2253.1495639128@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETE done betweenstandby_redo and the end of backup  (y39chen <yan-jack.chen@nokia.com>)
Ответы Re: [GENERAL] Is there possibility btree_redo with XLOG_BTREE_DELETEdone between standby_redo and the end of backup
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: [GENERAL] Current best practice for maximum shared_bufferssettings on big hardware?
Следующее
От: Igor Neyman
Дата:
Сообщение: Re: [GENERAL] logical replication in PG10 BETA