Skip to content

Instantly share code, notes, and snippets.

@imcitius
Created August 14, 2018 13:50
Show Gist options
  • Save imcitius/f022dbd6f7f4c38b714e49c9ba0d6bca to your computer and use it in GitHub Desktop.
Save imcitius/f022dbd6f7f4c38b714e49c9ba0d6bca to your computer and use it in GitHub Desktop.
replica->master
авг 14 13:47:48 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:47:48,720 INFO: Lock owner: pgsql-main-2; I am pgsql-main-0
авг 14 13:47:48 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:47:48,720 INFO: does not have lock
авг 14 13:47:48 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:47:48,724 INFO: no action. i am a secondary and i am following a leader
авг 14 13:47:58 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:47:58,369 INFO: Lock owner: pgsql-main-2; I am pgsql-main-0
авг 14 13:47:58 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:47:58,369 INFO: does not have lock
авг 14 13:47:58 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:47:58,371 INFO: no action. i am a secondary and i am following a leader
авг 14 13:48:04 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:04,664 INFO: Starting new HTTP connection (2): 172.29.10.58
авг 14 13:48:04 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:04,667 INFO: received switchover request with leader=pgsql-main-2 candidate=pgsql-main-0 scheduled_at=None
авг 14 13:48:04 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:04,674 INFO: Got response from pgsql-main-0 http://172.29.10.58:8008/patroni: {"database_system_identifier": "6589191000674292929", "postmaster_start_time": "2018-08-14 13:40:48.148 UTC", "timeline": 23, "xlog": {"received_location": 503504872, "replayed_timestamp": "2018-08-14 13:43:39.465 UTC", "paused": false, "replayed_location": 503504872}, "patroni": {"scope": "pgsql-main", "version": "1.4.5"}, "state": "running", "role": "replica", "server_version": 100005}
авг 14 13:48:08 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:08,410 WARNING: Connection pool is full, discarding connection: 172.29.10.58
авг 14 13:48:08 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:08,414 INFO: Lock owner: pgsql-main-2; I am pgsql-main-0
авг 14 13:48:08 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:08,414 INFO: does not have lock
авг 14 13:48:08 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:08,417 INFO: no action. i am a secondary and i am following a leader
авг 14 13:48:08 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:08,792 INFO: Starting new HTTP connection (3): 172.29.10.58
авг 14 13:48:13 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:13,049 WARNING: Connection pool is full, discarding connection: 172.29.10.58
авг 14 13:48:13 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:13,060 INFO: Cleaning up failover key after acquiring leader lock...
авг 14 13:48:13 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:13,073 WARNING: Could not activate Linux watchdog device: "Can't open watchdog device: [Errno 2] No such file or directory: '/dev/watchdog'"
авг 14 13:48:13 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:13,090 INFO: promoted self to leader by acquiring session lock
авг 14 13:48:13 pgsql-main-0 patroni.py[3954]: server promoting
авг 14 13:48:13 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:13,095 INFO: cleared rewind state after becoming the leader
авг 14 13:48:13 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:13,099 INFO: Lock owner: pgsql-main-0; I am pgsql-main-0
авг 14 13:48:13 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:13,113 INFO: updated leader lock during promote
авг 14 13:48:14 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:14,133 INFO: Lock owner: pgsql-main-0; I am pgsql-main-0
авг 14 13:48:14 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:14,170 INFO: no action. i am the leader with the lock
авг 14 13:48:24 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:24,133 INFO: Lock owner: pgsql-main-0; I am pgsql-main-0
авг 14 13:48:24 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:24,158 INFO: Assigning synchronous standby status to pgsql-main-2
авг 14 13:48:24 pgsql-main-0 patroni.py[3954]: server signaled
авг 14 13:48:26 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:26,180 INFO: Synchronous standby status assigned to pgsql-main-2
авг 14 13:48:26 pgsql-main-0 patroni.py[3954]: 2018-08-14 13:48:26,190 INFO: no action. i am the leader with the lock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment