Home > mailing lists

[BUG] standby node can not provide service even it replays all logfiles - Mailing list pgsql-hackers

From	Thunder
Subject	[BUG] standby node can not provide service even it replays all logfiles
Date	October 21, 2019 10:40:24
Msg-id	54405037.5bef.16ded428de1.Coremail.thunder1@126.com Whole thread Raw
Responses	Re:[BUG] standby node can not provide service even it replays alllog files
List	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.

From: Pavel Stehule
Date: 21 October 2019, 10:22:21
Subject: Re: dropdb --force

From: Michael Paquier
Date: 21 October 2019, 10:43:23
Subject: Incorrect relation locked at beginning of REINDEX CONCURRENTLY