[BUG] standby node can not provide service even it replays all logfiles

Поиск
Список
Период
Сортировка
От Thunder
Тема [BUG] standby node can not provide service even it replays all logfiles
Дата
Msg-id 54405037.5bef.16ded428de1.Coremail.thunder1@126.com
обсуждение исходный текст
Ответы Re:[BUG] standby node can not provide service even it replays alllog files  (Thunder <thunder1@126.com>)
Список pgsql-hackers
Дерево обсуждения
Hi hackers,
I found this issue when restart standby node and then try to connect it.
It return "psql: FATAL:  the database system is starting up".

The steps to reproduce this issue.
1.  Create a session to run uncommit_trans.sql
2.  Create the other session to do checkpoint
3.  Restart standby node.
4.  standby node can not provide service even it has replayed all log files.

I think the issue is in ProcArrayApplyRecoveryInfo function.
The standby state is in STANDBY_SNAPSHOT_PENDING, but the lastOverflowedXid is not committed.

Any idea to fix this issue?
Thanks.



 

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: dropdb --force
Следующее
От: Michael Paquier
Дата:
Сообщение: Incorrect relation locked at beginning of REINDEX CONCURRENTLY