Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [2021-06-18 10:28:36] [WARNING] unable to ping "host=192.168.33.34 user=repmgr password=repmgrpass dbname=repmgr"
- [2021-06-18 10:28:36] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
- [2021-06-18 10:28:36] [WARNING] unable to connect to upstream node "pg1" (ID: 1)
- [2021-06-18 10:28:36] [INFO] checking state of node "pg1" (ID: 1), 1 of 6 attempts
- [2021-06-18 10:28:38] [WARNING] unable to ping "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.34 connect_timeout=2 fallback_application_name=repmgr"
- [2021-06-18 10:28:38] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
- [2021-06-18 10:28:38] [INFO] sleeping up to 1 seconds until next reconnection attempt
- [2021-06-18 10:28:39] [INFO] checking state of node "pg1" (ID: 1), 2 of 6 attempts
- [2021-06-18 10:28:39] [WARNING] unable to ping "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.34 connect_timeout=2 fallback_application_name=repmgr"
- [2021-06-18 10:28:39] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
- [2021-06-18 10:28:39] [INFO] sleeping up to 1 seconds until next reconnection attempt
- [2021-06-18 10:28:40] [INFO] checking state of node "pg1" (ID: 1), 3 of 6 attempts
- [2021-06-18 10:28:42] [WARNING] unable to ping "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.34 connect_timeout=2 fallback_application_name=repmgr"
- [2021-06-18 10:28:42] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
- [2021-06-18 10:28:42] [INFO] sleeping up to 1 seconds until next reconnection attempt
- [2021-06-18 10:28:43] [INFO] checking state of node "pg1" (ID: 1), 4 of 6 attempts
- [2021-06-18 10:28:45] [WARNING] unable to ping "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.34 connect_timeout=2 fallback_application_name=repmgr"
- [2021-06-18 10:28:45] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
- [2021-06-18 10:28:45] [INFO] sleeping up to 1 seconds until next reconnection attempt
- [2021-06-18 10:28:46] [INFO] checking state of node "pg1" (ID: 1), 5 of 6 attempts
- [2021-06-18 10:28:48] [WARNING] unable to ping "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.34 connect_timeout=2 fallback_application_name=repmgr"
- [2021-06-18 10:28:48] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
- [2021-06-18 10:28:48] [INFO] sleeping up to 1 seconds until next reconnection attempt
- [2021-06-18 10:28:49] [INFO] checking state of node "pg1" (ID: 1), 6 of 6 attempts
- [2021-06-18 10:28:51] [WARNING] unable to ping "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.34 connect_timeout=2 fallback_application_name=repmgr"
- [2021-06-18 10:28:51] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
- [2021-06-18 10:28:51] [WARNING] unable to reconnect to node "pg1" (ID: 1) after 6 attempts
- [2021-06-18 10:28:51] [DEBUG] do_election(): electoral term is 1
- [2021-06-18 10:28:51] [INFO] 1 active sibling nodes registered
- [2021-06-18 10:28:51] [INFO] 3 total nodes registered
- [2021-06-18 10:28:51] [INFO] primary node "pg1" (ID: 1) and this node have the same location ("eu-es-mad-1")
- [2021-06-18 10:28:51] [INFO] local node's last receive lsn: 0/70000A0
- [2021-06-18 10:28:51] [INFO] checking state of sibling node "pg3" (ID: 3)
- [2021-06-18 10:28:51] [DEBUG] connecting to: "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.36 connect_timeout=2 fallback_application_name=repmgr options=-csearch_path="
- [2021-06-18 10:28:51] [INFO] node "pg3" (ID: 3) reports its upstream is node 1, last seen 85 second(s) ago
- [2021-06-18 10:28:51] [INFO] standby node "pg3" (ID: 3) last saw primary node 85 second(s) ago
- [2021-06-18 10:28:51] [INFO] last receive LSN for sibling node "pg3" (ID: 3) is: 0/70000A0
- [2021-06-18 10:28:51] [INFO] node "pg3" (ID: 3) has same LSN as current candidate "pg2" (ID: 2)
- [2021-06-18 10:28:51] [INFO] visible nodes: 2; total nodes: 2; no nodes have seen the primary within the last 4 seconds
- [2021-06-18 10:28:51] [NOTICE] promotion candidate is "pg2" (ID: 2)
- [2021-06-18 10:28:51] [DEBUG] election result: WON
- [2021-06-18 10:28:51] [NOTICE] this node is the winner, will now promote itself and inform other nodes
- [2021-06-18 10:28:51] [INFO] promote_command is:
- "/usr/local/bin/repmgrd_promote"
- [2021-06-18 10:28:52] [NOTICE] redirecting logging output to "/var/log/postgresql/repmgr.log"
- [2021-06-18 10:28:52] [DEBUG] connecting to: "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.35 connect_timeout=2 fallback_application_name=repmgr options=-csearch_path="
- [2021-06-18 10:28:52] [DEBUG] connecting to: "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.34 connect_timeout=2 fallback_application_name=repmgr options=-csearch_path="
- [2021-06-18 10:28:52] [DEBUG] connecting to: "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.35 connect_timeout=2 fallback_application_name=repmgr options=-csearch_path="
- [2021-06-18 10:28:52] [DEBUG] connecting to: "user=repmgr password=repmgrpass dbname=repmgr host=192.168.33.36 connect_timeout=2 fallback_application_name=repmgr options=-csearch_path="
- [2021-06-18 10:28:52] [WARNING] 1 sibling nodes found, but option "--siblings-follow" not specified
- [2021-06-18 10:28:52] [DETAIL] these nodes will remain attached to the current primary:
- pg3 (node ID: 3)
- [2021-06-18 10:28:52] [NOTICE] promoting standby to primary
- [2021-06-18 10:28:52] [DETAIL] promoting server "pg2" (ID: 2) using pg_promote()
- [2021-06-18 10:28:52] [NOTICE] waiting up to 60 seconds (parameter "promote_check_timeout") for promotion to complete
- [2021-06-18 10:28:53] [DEBUG] setting node 2 as primary and marking existing primary as failed
- [2021-06-18 10:28:53] [NOTICE] STANDBY PROMOTE successful
- [2021-06-18 10:28:53] [DETAIL] server "pg2" (ID: 2) was successfully promoted to primary
- [2021-06-18 10:28:54] [DEBUG] result of promote_command: 0
- [2021-06-18 10:28:54] [INFO] checking state of node 2, 1 of 6 attempts
- [2021-06-18 10:28:54] [NOTICE] node 2 has recovered, reconnecting
- [2021-06-18 10:28:54] [INFO] connection to node 2 succeeded
- [2021-06-18 10:28:54] [INFO] original connection is still available
- [2021-06-18 10:28:54] [INFO] 1 followers to notify
- [2021-06-18 10:28:54] [NOTICE] notifying node "pg3" (ID: 3) to follow node 2
- INFO: node 3 received notification to follow node 2
- [2021-06-18 10:28:54] [INFO] switching to primary monitoring mode
- [2021-06-18 10:28:54] [NOTICE] monitoring cluster primary "pg2" (ID: 2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement