Advertisement
Guest User

Untitled

a guest
Jun 18th, 2021
22
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.24 KB | None | 0 0
  1. [2021-06-18 10:28:36] [WARNING] unable to ping "host=192.168.33.34 user=repmgr password=repmgrpass dbname=repmgr"
  2. [2021-06-18 10:28:36] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
  3. [2021-06-18 10:28:36] [WARNING] unable to connect to upstream node "pg1" (ID: 1)
  4. [2021-06-18 10:28:36] [INFO] checking state of node "pg1" (ID: 1), 1 of 6 attempts
  5. [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"
  6. [2021-06-18 10:28:38] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
  7. [2021-06-18 10:28:38] [INFO] sleeping up to 1 seconds until next reconnection attempt
  8. [2021-06-18 10:28:39] [INFO] checking state of node "pg1" (ID: 1), 2 of 6 attempts
  9. [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"
  10. [2021-06-18 10:28:39] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
  11. [2021-06-18 10:28:39] [INFO] sleeping up to 1 seconds until next reconnection attempt
  12. [2021-06-18 10:28:40] [INFO] checking state of node "pg1" (ID: 1), 3 of 6 attempts
  13. [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"
  14. [2021-06-18 10:28:42] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
  15. [2021-06-18 10:28:42] [INFO] sleeping up to 1 seconds until next reconnection attempt
  16. [2021-06-18 10:28:43] [INFO] checking state of node "pg1" (ID: 1), 4 of 6 attempts
  17. [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"
  18. [2021-06-18 10:28:45] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
  19. [2021-06-18 10:28:45] [INFO] sleeping up to 1 seconds until next reconnection attempt
  20. [2021-06-18 10:28:46] [INFO] checking state of node "pg1" (ID: 1), 5 of 6 attempts
  21. [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"
  22. [2021-06-18 10:28:48] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
  23. [2021-06-18 10:28:48] [INFO] sleeping up to 1 seconds until next reconnection attempt
  24. [2021-06-18 10:28:49] [INFO] checking state of node "pg1" (ID: 1), 6 of 6 attempts
  25. [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"
  26. [2021-06-18 10:28:51] [DETAIL] PQping() returned "PQPING_NO_RESPONSE"
  27. [2021-06-18 10:28:51] [WARNING] unable to reconnect to node "pg1" (ID: 1) after 6 attempts
  28. [2021-06-18 10:28:51] [DEBUG] do_election(): electoral term is 1
  29. [2021-06-18 10:28:51] [INFO] 1 active sibling nodes registered
  30. [2021-06-18 10:28:51] [INFO] 3 total nodes registered
  31. [2021-06-18 10:28:51] [INFO] primary node "pg1" (ID: 1) and this node have the same location ("eu-es-mad-1")
  32. [2021-06-18 10:28:51] [INFO] local node's last receive lsn: 0/70000A0
  33. [2021-06-18 10:28:51] [INFO] checking state of sibling node "pg3" (ID: 3)
  34. [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="
  35. [2021-06-18 10:28:51] [INFO] node "pg3" (ID: 3) reports its upstream is node 1, last seen 85 second(s) ago
  36. [2021-06-18 10:28:51] [INFO] standby node "pg3" (ID: 3) last saw primary node 85 second(s) ago
  37. [2021-06-18 10:28:51] [INFO] last receive LSN for sibling node "pg3" (ID: 3) is: 0/70000A0
  38. [2021-06-18 10:28:51] [INFO] node "pg3" (ID: 3) has same LSN as current candidate "pg2" (ID: 2)
  39. [2021-06-18 10:28:51] [INFO] visible nodes: 2; total nodes: 2; no nodes have seen the primary within the last 4 seconds
  40. [2021-06-18 10:28:51] [NOTICE] promotion candidate is "pg2" (ID: 2)
  41. [2021-06-18 10:28:51] [DEBUG] election result: WON
  42. [2021-06-18 10:28:51] [NOTICE] this node is the winner, will now promote itself and inform other nodes
  43. [2021-06-18 10:28:51] [INFO] promote_command is:
  44. "/usr/local/bin/repmgrd_promote"
  45. [2021-06-18 10:28:52] [NOTICE] redirecting logging output to "/var/log/postgresql/repmgr.log"
  46.  
  47. [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="
  48. [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="
  49. [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="
  50. [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="
  51. [2021-06-18 10:28:52] [WARNING] 1 sibling nodes found, but option "--siblings-follow" not specified
  52. [2021-06-18 10:28:52] [DETAIL] these nodes will remain attached to the current primary:
  53. pg3 (node ID: 3)
  54. [2021-06-18 10:28:52] [NOTICE] promoting standby to primary
  55. [2021-06-18 10:28:52] [DETAIL] promoting server "pg2" (ID: 2) using pg_promote()
  56. [2021-06-18 10:28:52] [NOTICE] waiting up to 60 seconds (parameter "promote_check_timeout") for promotion to complete
  57. [2021-06-18 10:28:53] [DEBUG] setting node 2 as primary and marking existing primary as failed
  58. [2021-06-18 10:28:53] [NOTICE] STANDBY PROMOTE successful
  59. [2021-06-18 10:28:53] [DETAIL] server "pg2" (ID: 2) was successfully promoted to primary
  60. [2021-06-18 10:28:54] [DEBUG] result of promote_command: 0
  61. [2021-06-18 10:28:54] [INFO] checking state of node 2, 1 of 6 attempts
  62. [2021-06-18 10:28:54] [NOTICE] node 2 has recovered, reconnecting
  63. [2021-06-18 10:28:54] [INFO] connection to node 2 succeeded
  64. [2021-06-18 10:28:54] [INFO] original connection is still available
  65. [2021-06-18 10:28:54] [INFO] 1 followers to notify
  66. [2021-06-18 10:28:54] [NOTICE] notifying node "pg3" (ID: 3) to follow node 2
  67. INFO: node 3 received notification to follow node 2
  68. [2021-06-18 10:28:54] [INFO] switching to primary monitoring mode
  69. [2021-06-18 10:28:54] [NOTICE] monitoring cluster primary "pg2" (ID: 2)
  70.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement