View Revisions: Issue #578

Summary 0000578: 4.1: Cannot get standby online after a pcp_promote_node, instead getting "... failed to start in 90 second"
Revision 2020-01-28 14:46 by pengbo
Description Here the log output
...
- PCP: processing promote node
- promoting Node ID 1
- received promote backend request for node_id: 1 from pid [3888]
- starting to select new master node
- starting promotion. promote host /var/run/pgpool(11003)
- starting follow degeneration. shutdown host /var/run/pgpool(11002)
- starting follow degeneration. shutdown host /var/run/pgpool(11004)
- failover: 2 follow backends have been degenerated
- failover: set new primary node: 1
- failover: set new master node: 1
- promotion done. promoted host /var/run/pgpool(11003)
- start triggering follow command.
- execute command: /opt/pgpool/etc/follow_master.sh 0 /var/run/pgpool 11002 /opt/pgpool/data0 1 0 /var/run/pgpool 0 11003 /opt/pgpool/data1
- initializing backend status
- start online recovery
- starting recovering node 0
- starting recovery command: "SELECT pgpool_recovery('basebackup.sh', 'localhost', '/opt/pgpool/data0', '11003', 0, '11002')- executing recovery
- executing recovery, start recovery
- executing recovery, finish recovery
- node recovery, 1st stage is done
- executing remote start
- finish pgpool_remote_start
- checking if postmaster is started
....
Revision 2020-01-27 22:45 by giminni
Description Here the log output
...
- PCP: processing promote node
- promoting Node ID 1
- received promote backend request for node_id: 1 from pid [3888]
- starting to select new master node
- starting promotion. promote host /var/run/pgpool(11003)
- starting follow degeneration. shutdown host /var/run/pgpool(11002)
- starting follow degeneration. shutdown host /var/run/pgpool(11004)
- failover: 2 follow backends have been degenerated
- failover: set new primary node: 1
- failover: set new master node: 1
- promotion done. promoted host /var/run/pgpool(11003)
- start triggering follow command.
- execute command: /opt/pgpool/etc/follow_master.sh 0 /var/run/pgpool 11002 /opt/pgpool/data0 1 0 /var/run/pgpool 0 11003 /opt/pgpool/data1
- initializing backend status
- start online recovery
- starting recovering node 0
- starting recovery command: "SELECT pgpool_recovery('basebackup.sh', 'localhost', '/opt/pgpool/data0', '11003', 0, '11002')- executing recovery
- executing recovery, start recovery
- executing recovery, finish recovery
- node recovery, 1st stage is done
- executing remote start
- finish pgpool_remote_start
- checking if postmaster is started
....