"WAL replay is paused on node with WAL replay pending; this node cannot be manually promoted until WAL replay is resumed" error in Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

When executing the repmgr cluster show command in a VMware Cloud Director (VCD) environment, the following error is returned: WAL replay is paused on node with WAL replay pending; this node cannot be manually promoted until WAL replay is resumed.

The postgres.log indicates a failure during the standby mode entry:

####-##-## ##:##:##.### UTC [4915] FATAL:  recovery aborted because of insufficient parameter settings
####-##-## ##:##:##.### UTC [4915] DETAIL:  max_worker_processes = 8 is a lower setting than on the primary server, where its value was 24.
####-##-## ##:##:##.### UTC [4915] HINT:  You can restart the server after making the necessary configuration changes.

Cause

A mismatch in hardware resources (CPU/Memory) between VCD nodes caused the max_worker_processes parameter on the standby node to be lower than the value set on the primary server, preventing WAL recovery.

Resolution

1. Shut down the impacted VMware Cloud Director (VCD) cell.
2. Increase the CPU and memory resources of the virtual machine to match with those of the other cells in the cluster.
3. Power on the VCD cell and verify if the issue is resolved.
4. If the problem persists, perform a sequential reboot of the cluster.

•  

Additional Information

Cloud Director における "WAL replay is paused on node with WAL replay pending; this node cannot be manually promoted until WAL replay is resumed" エラー