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.
uncommit_trans.sql
Description: Binary data