2024-01-10T17:41:16.754366Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 51673b8a with addr ssl://10.42.1.27:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 580 rttvar: 959 rto: 1632000 lost: 1 last_data_recv: 3024 cwnd: 1 last_queued_since: 19977 last_delivered_since: 3024813076 send_queue_length: 1 send_queue_bytes: 360 segment: 0 messages: 1 2024-01-10T17:41:16.754560Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: ssl://10.42.1.27:4567 2024-01-10T17:41:18.198229Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') reconnecting to 51673b8a (ssl://10.42.1.27:4567), attempt 0 2024-01-10T17:41:19.280568Z 0 [Note] WSREP: declaring node with index 1 suspected, timeout PT5S (evs.suspect_timeout) 2024-01-10T17:41:19.280645Z 0 [Note] WSREP: evs::proto(1aacdd80, GATHER, view_id(REG,1aacdd80,18)) suspecting node: 51673b8a 2024-01-10T17:41:19.280666Z 0 [Note] WSREP: evs::proto(1aacdd80, GATHER, view_id(REG,1aacdd80,18)) suspected node without join message, declaring inactive 2024-01-10T17:41:19.780916Z 0 [Note] WSREP: declaring node with index 1 inactive (evs.inactive_timeout) 2024-01-10T17:41:19.781599Z 0 [Note] WSREP: declaring 894c37e2 at ssl://10.42.2.13:4567 stable 2024-01-10T17:41:21.698983Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 00000000 with addr ssl://10.42.1.27:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 0 rttvar: 250000 rto: 4000000 lost: 1 last_data_recv: 554302860 cwnd: 1 last_queued_since: 554604660614359 last_delivered_since: 554604660614359 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:41:23.199233Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 894c37e2 with addr ssl://10.42.2.13:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 193 rttvar: 77 rto: 204000 lost: 0 last_data_recv: 3420 cwnd: 10 last_queued_since: 416285173 last_delivered_since: 3417652230 send_queue_length: 0 send_queue_bytes: 0 segment: 0 messages: 0 2024-01-10T17:41:47.789908Z 0 [Note] WSREP: Received shutdown signal. Will sleep for 10 secs before initiating shutdown. pxc_maint_mode switched to SHUTDOWN 2024-01-10T17:41:58.384555Z 0 [Warning] WSREP: last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT35.6016S), skipping check 2024-01-10T17:41:58.404656Z 2814 [Note] Aborted connection 2814 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.404690Z 2813 [Note] Aborted connection 2813 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-pxc-2.mycluster-pxc-db-pxc.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.408575Z 2819 [Note] Aborted connection 2819 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.420128Z 2826 [Note] Aborted connection 2826 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-haproxy-0.mycluster-pxc-db-haproxy.pxc.svc.cl' (Got an error reading communication packets) 2024-01-10T17:41:58.422565Z 2829 [Note] Aborted connection 2829 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.425941Z 2840 [Note] Aborted connection 2840 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-pxc-2.mycluster-pxc-db-pxc.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.429385Z 2849 [Note] Aborted connection 2849 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.431766Z 2853 [Note] Aborted connection 2853 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.435821Z 2815 [Note] Aborted connection 2815 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-pxc-2.mycluster-pxc-db-pxc.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.435941Z 2816 [Note] Aborted connection 2816 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.437124Z 2825 [Note] Aborted connection 2825 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.437140Z 2822 [Note] Aborted connection 2822 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.442349Z 2820 [Note] Aborted connection 2820 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-haproxy-0.mycluster-pxc-db-haproxy.pxc.svc.cl' (Got an error reading communication packets) 2024-01-10T17:41:58.443839Z 2831 [Note] Aborted connection 2831 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.445732Z 2841 [Note] Aborted connection 2841 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.445789Z 2836 [Note] Aborted connection 2836 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.445801Z 2827 [Note] Aborted connection 2827 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-haproxy-0.mycluster-pxc-db-haproxy.pxc.svc.cl' (Got an error reading communication packets) 2024-01-10T17:41:58.445793Z 2830 [Note] Aborted connection 2830 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-haproxy-1.mycluster-pxc-db-haproxy.pxc.svc.cl' (Got an error reading communication packets) 2024-01-10T17:41:58.445927Z 2839 [Note] Aborted connection 2839 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.445937Z 2842 [Note] Aborted connection 2842 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-pxc-2.mycluster-pxc-db-pxc.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.445992Z 2843 [Note] Aborted connection 2843 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.446032Z 2835 [Note] Aborted connection 2835 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.446523Z 2838 [Note] Aborted connection 2838 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-haproxy-1.mycluster-pxc-db-haproxy.pxc.svc.cl' (Got an error reading communication packets) 2024-01-10T17:41:58.446556Z 2837 [Note] Aborted connection 2837 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.449855Z 2850 [Note] Aborted connection 2850 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.449877Z 2851 [Note] Aborted connection 2851 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.454643Z 2818 [Note] Aborted connection 2818 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.454785Z 2817 [Note] Aborted connection 2817 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.455928Z 2821 [Note] Aborted connection 2821 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.456269Z 2824 [Note] Aborted connection 2824 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.456292Z 2832 [Note] Aborted connection 2832 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-haproxy-1.mycluster-pxc-db-haproxy.pxc.svc.cl' (Got an error reading communication packets) 2024-01-10T17:41:58.456442Z 2834 [Note] Aborted connection 2834 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.457691Z 2833 [Note] Aborted connection 2833 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.459879Z 2844 [Note] Aborted connection 2844 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.459885Z 2847 [Note] Aborted connection 2847 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.465693Z 2828 [Note] Aborted connection 2828 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.465732Z 2848 [Note] Aborted connection 2848 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.465826Z 2852 [Note] Aborted connection 2852 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.476827Z 2854 [Note] Aborted connection 2854 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.488561Z 2856 [Note] Aborted connection 2856 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.490337Z 2855 [Note] Aborted connection 2855 to db: 'unconnected' user: 'monitor' host: '10-42-2-15.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.498092Z 2857 [Note] Aborted connection 2857 to db: 'unconnected' user: 'monitor' host: '10-42-0-244.mycluster-pxc-db-haproxy-replicas.pxc.svc.cluster.l' (Got an error reading communication packets) 2024-01-10T17:41:58.884799Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 00000000 with addr ssl://10.42.1.27:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 0 rttvar: 250000 rto: 32000000 lost: 1 last_data_recv: 554340044 cwnd: 1 last_queued_since: 554641846460763 last_delivered_since: 554641846460763 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:41:58.885004Z 0 [Note] WSREP: declaring node with index 1 suspected, timeout PT5S (evs.suspect_timeout) 2024-01-10T17:41:58.885024Z 0 [Note] WSREP: declaring node with index 1 inactive (evs.inactive_timeout) 2024-01-10T17:41:58.885043Z 0 [Note] WSREP: evs::proto(1aacdd80, OPERATIONAL, view_id(REG,1aacdd80,19)) detected inactive node: 894c37e2 2024-01-10T17:41:59.384879Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') reconnecting to 894c37e2 (ssl://10.42.2.13:4567), attempt 0 2024-01-10T17:41:59.393991Z 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.42.2.13:4567 local endpoint ssl://10.42.0.249:59146 cipher: TLS_AES_256_GCM_SHA384 compression: none 2024-01-10T17:41:59.400917Z 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.42.2.13:53858 local endpoint ssl://10.42.0.249:4567 cipher: TLS_AES_256_GCM_SHA384 compression: none 2024-01-10T17:41:59.401078Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection established to 894c37e2 ssl://10.42.2.13:4567 2024-01-10T17:41:59.401399Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection established to 894c37e2 ssl://10.42.2.13:4567 2024-01-10T17:41:59.885941Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,1aacdd80,19) memb { 1aacdd80,0 } joined { } left { } partitioned { 51673b8a,0 894c37e2,0 } ) 2024-01-10T17:41:59.886124Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2024-01-10T17:41:59.886182Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2024-01-10T17:41:59.886200Z 0 [Note] WSREP: Received NON-PRIMARY. 2024-01-10T17:41:59.886204Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,1aacdd80,20) memb { 1aacdd80,0 } joined { } left { } partitioned { 51673b8a,0 894c37e2,0 } ) 2024-01-10T17:41:59.886213Z 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 932630) 2024-01-10T17:41:59.886403Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2024-01-10T17:41:59.886436Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2024-01-10T17:41:59.886449Z 0 [Note] WSREP: Received NON-PRIMARY. 2024-01-10T17:41:59.886613Z 4 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2024-01-10T17:41:59.886651Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:41:59.886709Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:41:59.886750Z 4 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2024-01-10T17:41:59.886760Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:41:59.886768Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:41:59.895124Z 2600 [Warning] WSREP: Send action {(nil), 1088, TORDERED} returned -107 (Transport endpoint is not connected) 2024-01-10T17:42:00.394484Z 0 [Note] WSREP: declaring 894c37e2 at ssl://10.42.2.13:4567 stable 2024-01-10T17:42:00.395117Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,1aacdd80,21) memb { 1aacdd80,0 894c37e2,0 } joined { } left { } partitioned { 51673b8a,0 } ) 2024-01-10T17:42:00.395197Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 2 2024-01-10T17:42:00.395236Z 0 [Note] WSREP: Flow-control interval: [141, 141] 2024-01-10T17:42:00.395248Z 0 [Note] WSREP: Received NON-PRIMARY. 2024-01-10T17:42:00.395314Z 4 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, view# -1: non-Primary, number of nodes: 2, my index: 0, protocol version 3 2024-01-10T17:42:00.395337Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:42:00.395345Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:42:02.886216Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 00000000 with addr ssl://10.42.1.27:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 0 rttvar: 250000 rto: 2000000 lost: 1 last_data_recv: 554344044 cwnd: 1 last_queued_since: 554645847854663 last_delivered_since: 554645847854663 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:42:07.387024Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 00000000 with addr ssl://10.42.1.27:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 0 rttvar: 250000 rto: 2000000 lost: 1 last_data_recv: 554348548 cwnd: 1 last_queued_since: 554650348679477 last_delivered_since: 554650348679477 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:42:08.385501Z 0 [Note] WSREP: Stop replication 2024-01-10T17:42:08.385575Z 0 [Note] WSREP: Closing send monitor... 2024-01-10T17:42:08.385633Z 0 [Note] WSREP: Closed send monitor. 2024-01-10T17:42:08.385677Z 0 [Note] WSREP: gcomm: terminating thread 2024-01-10T17:42:08.385705Z 0 [Note] WSREP: gcomm: joining thread 2024-01-10T17:42:08.386234Z 0 [Note] WSREP: gcomm: closing backend 2024-01-10T17:42:11.387108Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 894c37e2 with addr ssl://10.42.2.13:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 1408 rttvar: 2343 rto: 204000 lost: 0 last_data_recv: 3000 cwnd: 10 last_queued_since: 713429 last_delivered_since: 3000146892 send_queue_length: 0 send_queue_bytes: 0 segment: 0 messages: 0 2024-01-10T17:42:12.387126Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 00000000 with addr ssl://10.42.1.27:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 0 rttvar: 250000 rto: 4000000 lost: 1 last_data_recv: 554353548 cwnd: 1 last_queued_since: 554655348789324 last_delivered_since: 554655348789324 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:42:12.387243Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') reconnecting to 894c37e2 (ssl://10.42.2.13:4567), attempt 0 2024-01-10T17:42:13.886524Z 0 [Note] WSREP: declaring node with index 1 suspected, timeout PT5S (evs.suspect_timeout) 2024-01-10T17:42:13.886564Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:14.386607Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:14.886701Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:15.386767Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:15.886843Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:16.386909Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:16.886984Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:17.387044Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:17.387135Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 00000000 with addr ssl://10.42.1.27:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 0 rttvar: 250000 rto: 4000000 lost: 1 last_data_recv: 554358548 cwnd: 1 last_queued_since: 554660348832259 last_delivered_since: 554660348832259 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:42:17.887113Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:18.387180Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:18.887256Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:19.387316Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:19.887468Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:20.387532Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:20.887596Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:21.387685Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:21.887280Z 0 [Note] WSREP: (1aacdd80, 'ssl://0.0.0.0:4567') connection to peer 00000000 with addr ssl://10.42.1.27:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 0 rttvar: 250000 rto: 4000000 lost: 1 last_data_recv: 554363048 cwnd: 1 last_queued_since: 554664848954288 last_delivered_since: 554664848954288 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:42:21.887730Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:22.387775Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:22.887843Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) suspecting node: 894c37e2 2024-01-10T17:42:23.387889Z 0 [Note] WSREP: declaring node with index 1 inactive (evs.inactive_timeout) 2024-01-10T17:42:23.387919Z 0 [Note] WSREP: evs::proto(1aacdd80, LEAVING, view_id(REG,1aacdd80,21)) detected inactive node: 894c37e2 2024-01-10T17:42:23.387952Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,1aacdd80,21) memb { 1aacdd80,0 } joined { } left { } partitioned { 51673b8a,0 894c37e2,0 } ) 2024-01-10T17:42:23.387994Z 0 [Note] WSREP: Current view of cluster as seen by this node view ((empty)) 2024-01-10T17:42:23.388267Z 0 [Note] WSREP: gcomm: closed 2024-01-10T17:42:23.388298Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2024-01-10T17:42:23.388353Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2024-01-10T17:42:23.388365Z 0 [Note] WSREP: Received NON-PRIMARY. 2024-01-10T17:42:23.388412Z 0 [Note] WSREP: Received self-leave message. 2024-01-10T17:42:23.388428Z 0 [Note] WSREP: Flow-control interval: [0, 0] 2024-01-10T17:42:23.388444Z 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2024-01-10T17:42:23.388454Z 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 932630) 2024-01-10T17:42:23.388466Z 0 [Note] WSREP: RECV thread exiting 0: Success 2024-01-10T17:42:23.388516Z 4 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3 2024-01-10T17:42:23.388551Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:42:23.388563Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:42:23.388589Z 4 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, view# -1: non-Primary, number of nodes: 0, my index: -1, protocol version 3 2024-01-10T17:42:23.388602Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:42:23.388614Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:42:23.388633Z 0 [Note] WSREP: recv_thread() joined. 2024-01-10T17:42:23.388648Z 0 [Note] WSREP: Closing replication queue. 2024-01-10T17:42:23.388653Z 0 [Note] WSREP: Closing slave action queue. 2024-01-10T17:42:23.388658Z 0 [Note] WSREP: Waiting for active wsrep applier to exit 2024-01-10T17:42:23.398165Z 4 [Note] WSREP: applier thread exiting (code:0) 2024-01-10T17:42:23.398599Z 2 [Note] WSREP: applier thread exiting (code:6) 2024-01-10T17:42:23.398848Z 1 [Note] WSREP: rollbacker thread exiting 2024-01-10T17:42:23.622403Z 0 [Note] Giving 65 client threads a chance to die gracefully 2024-01-10T17:42:23.622829Z 0 [Note] Shutting down slave threads 2024-01-10T17:42:25.622950Z 0 [Note] Forcefully disconnecting 48 remaining clients 2024-01-10T17:42:25.623022Z 0 [Warning] mysqld: Forcing close of thread 1489 user: 'some-user' 2024-01-10T17:42:25.623119Z 0 [Warning] mysqld: Forcing close of thread 1177 user: 'some-user' 2024-01-10T17:42:25.623188Z 0 [Warning] mysqld: Forcing close of thread 2459 user: 'some-user' 2024-01-10T17:42:25.623257Z 0 [Warning] mysqld: Forcing close of thread 1494 user: 'some-user' 2024-01-10T17:42:25.623335Z 0 [Warning] mysqld: Forcing close of thread 1794 user: 'some-user' 2024-01-10T17:42:25.623402Z 0 [Warning] mysqld: Forcing close of thread 1729 user: 'some-user' 2024-01-10T17:42:25.623463Z 0 [Warning] mysqld: Forcing close of thread 1733 user: 'some-user' 2024-01-10T17:42:25.623518Z 0 [Warning] mysqld: Forcing close of thread 2281 user: 'some-user' 2024-01-10T17:42:25.623599Z 0 [Warning] mysqld: Forcing close of thread 1178 user: 'some-user' 2024-01-10T17:42:25.623668Z 0 [Warning] mysqld: Forcing close of thread 1805 user: 'some-user' 2024-01-10T17:42:25.623733Z 0 [Warning] mysqld: Forcing close of thread 1802 user: 'some-user' 2024-01-10T17:42:25.623792Z 0 [Warning] mysqld: Forcing close of thread 1795 user: 'some-user' 2024-01-10T17:42:25.623860Z 0 [Warning] mysqld: Forcing close of thread 1803 user: 'some-user' 2024-01-10T17:42:25.623924Z 0 [Warning] mysqld: Forcing close of thread 2464 user: 'some-user' 2024-01-10T17:42:25.623984Z 0 [Warning] mysqld: Forcing close of thread 1488 user: 'some-user' 2024-01-10T17:42:25.624038Z 0 [Warning] mysqld: Forcing close of thread 1535 user: 'some-user' 2024-01-10T17:42:25.624087Z 0 [Warning] mysqld: Forcing close of thread 1496 user: 'some-user' 2024-01-10T17:42:25.624143Z 0 [Warning] mysqld: Forcing close of thread 1793 user: 'some-user' 2024-01-10T17:42:25.624199Z 0 [Warning] mysqld: Forcing close of thread 1265 user: 'some-user' 2024-01-10T17:42:25.624257Z 0 [Warning] mysqld: Forcing close of thread 1493 user: 'some-user' 2024-01-10T17:42:25.624313Z 0 [Warning] mysqld: Forcing close of thread 1492 user: 'some-user' 2024-01-10T17:42:25.624380Z 0 [Warning] mysqld: Forcing close of thread 1497 user: 'some-user' 2024-01-10T17:42:25.624464Z 0 [Warning] mysqld: Forcing close of thread 1734 user: 'some-user' 2024-01-10T17:42:25.624541Z 0 [Warning] mysqld: Forcing close of thread 1495 user: 'some-user' 2024-01-10T17:42:25.624603Z 0 [Warning] mysqld: Forcing close of thread 1804 user: 'some-user' 2024-01-10T17:42:25.624662Z 0 [Warning] mysqld: Forcing close of thread 1796 user: 'some-user' 2024-01-10T17:42:25.624712Z 0 [Warning] mysqld: Forcing close of thread 1536 user: 'some-user' 2024-01-10T17:42:25.624773Z 0 [Warning] mysqld: Forcing close of thread 1487 user: 'some-user' 2024-01-10T17:42:25.624830Z 0 [Warning] mysqld: Forcing close of thread 1499 user: 'some-user' 2024-01-10T17:42:25.624881Z 0 [Warning] mysqld: Forcing close of thread 1483 user: 'some-user' 2024-01-10T17:42:25.624930Z 0 [Warning] mysqld: Forcing close of thread 1490 user: 'some-user' 2024-01-10T17:42:25.624983Z 0 [Warning] mysqld: Forcing close of thread 1799 user: 'some-user' 2024-01-10T17:42:25.625039Z 0 [Warning] mysqld: Forcing close of thread 1798 user: 'some-user' 2024-01-10T17:42:25.625094Z 0 [Warning] mysqld: Forcing close of thread 1797 user: 'some-user' 2024-01-10T17:42:25.625154Z 0 [Warning] mysqld: Forcing close of thread 1486 user: 'some-user' 2024-01-10T17:42:25.625240Z 0 [Warning] mysqld: Forcing close of thread 1498 user: 'some-user' 2024-01-10T17:42:25.625307Z 0 [Warning] mysqld: Forcing close of thread 1485 user: 'some-user' 2024-01-10T17:42:25.625371Z 0 [Warning] mysqld: Forcing close of thread 1484 user: 'some-user' 2024-01-10T17:42:25.625443Z 0 [Warning] mysqld: Forcing close of thread 1179 user: 'some-user' 2024-01-10T17:42:25.625509Z 0 [Warning] mysqld: Forcing close of thread 1728 user: 'some-user' 2024-01-10T17:42:25.625574Z 0 [Warning] mysqld: Forcing close of thread 2823 user: 'some-user' 2024-01-10T17:42:25.625627Z 0 [Warning] mysqld: Forcing close of thread 1226 user: 'some-user' 2024-01-10T17:42:25.625677Z 0 [Warning] mysqld: Forcing close of thread 1800 user: 'some-user' 2024-01-10T17:42:25.625739Z 0 [Warning] mysqld: Forcing close of thread 1267 user: 'some-user' 2024-01-10T17:42:25.625836Z 0 [Warning] mysqld: Forcing close of thread 2457 user: 'some-user' 2024-01-10T17:42:25.625922Z 0 [Warning] mysqld: Forcing close of thread 1801 user: 'some-user' 2024-01-10T17:42:25.626000Z 0 [Warning] mysqld: Forcing close of thread 1079 user: 'some-user' 2024-01-10T17:42:25.626068Z 0 [Warning] mysqld: Forcing close of thread 1266 user: 'some-user' 2024-01-10T17:42:25.626139Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2024-01-10T17:42:25.648808Z 0 [Note] WSREP: Service thread queue flushed. 2024-01-10T17:42:25.649120Z 0 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0.705202, misses: 102, in use: 0, in pool: 102 2024-01-10T17:42:25.666590Z 0 [Note] Binlog end 2024-01-10T17:42:25.681714Z 0 [Note] Shutting down plugin 'ngram' 2024-01-10T17:42:25.681747Z 0 [Note] Shutting down plugin 'partition' 2024-01-10T17:42:25.681753Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2024-01-10T17:42:25.681758Z 0 [Note] Shutting down plugin 'ARCHIVE' 2024-01-10T17:42:25.681761Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2024-01-10T17:42:25.681765Z 0 [Note] Shutting down plugin 'MyISAM' 2024-01-10T17:42:25.681784Z 0 [Note] Shutting down plugin 'INNODB_TABLESPACES_SCRUBBING' 2024-01-10T17:42:25.681789Z 0 [Note] Shutting down plugin 'INNODB_TABLESPACES_ENCRYPTION' 2024-01-10T17:42:25.681793Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2024-01-10T17:42:25.681796Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2024-01-10T17:42:25.681800Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2024-01-10T17:42:25.681803Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2024-01-10T17:42:25.681807Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2024-01-10T17:42:25.681810Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2024-01-10T17:42:25.681813Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2024-01-10T17:42:25.681817Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2024-01-10T17:42:25.681820Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2024-01-10T17:42:25.681824Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2024-01-10T17:42:25.681829Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2024-01-10T17:42:25.681834Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2024-01-10T17:42:25.681839Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2024-01-10T17:42:25.681845Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2024-01-10T17:42:25.681849Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2024-01-10T17:42:25.681854Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2024-01-10T17:42:25.681860Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2024-01-10T17:42:25.681867Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2024-01-10T17:42:25.681872Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2024-01-10T17:42:25.681877Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2024-01-10T17:42:25.681882Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2024-01-10T17:42:25.681887Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2024-01-10T17:42:25.681891Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2024-01-10T17:42:25.681894Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2024-01-10T17:42:25.681898Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2024-01-10T17:42:25.681901Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2024-01-10T17:42:25.681904Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2024-01-10T17:42:25.681907Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2024-01-10T17:42:25.681911Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2024-01-10T17:42:25.681914Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2024-01-10T17:42:25.681918Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2024-01-10T17:42:25.681921Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2024-01-10T17:42:25.681924Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2024-01-10T17:42:25.681927Z 0 [Note] Shutting down plugin 'XTRADB_RSEG' 2024-01-10T17:42:25.681931Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2024-01-10T17:42:25.681934Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2024-01-10T17:42:25.681942Z 0 [Note] Shutting down plugin 'InnoDB' 2024-01-10T17:42:25.685249Z 0 [Note] InnoDB: FTS optimize thread exiting. 2024-01-10T17:42:25.685410Z 0 [Note] InnoDB: Starting shutdown... 2024-01-10T17:42:25.785643Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2024-01-10T17:42:25.786190Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240110 17:42:25 2024-01-10T17:42:25.985751Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2024-01-10T17:42:26.984169Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1991634571 2024-01-10T17:42:26.984333Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2024-01-10T17:42:26.984353Z 0 [Note] Shutting down plugin 'MEMORY' 2024-01-10T17:42:26.984361Z 0 [Note] Shutting down plugin 'CSV' 2024-01-10T17:42:26.984367Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2024-01-10T17:42:26.984417Z 0 [Note] Shutting down plugin 'sha256_password' 2024-01-10T17:42:26.984423Z 0 [Note] Shutting down plugin 'mysql_native_password' 2024-01-10T17:42:26.984426Z 0 [Note] Shutting down plugin 'wsrep' 2024-01-10T17:42:26.984635Z 0 [Note] Shutting down plugin 'binlog' 2024-01-10T17:42:27.004459Z 0 [Note] mysqld: Shutdown complete 2024-01-10T18:03:41.132840Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2024-01-10T18:03:41.134955Z 0 [Note] mysqld (mysqld 5.7.43-47-57-log) starting as process 1 ... 2024-01-10T18:03:41.138600Z 0 [Note] WSREP: Skipping automatic SSL certificate generation (enabled only in bootstrap mode) 2024-01-10T18:03:41.139176Z 0 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T18:03:41.139211Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization. 2024-01-10T18:03:41.139224Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera3/libgalera_smm.so' 2024-01-10T18:03:41.140239Z 0 [Note] WSREP: wsrep_load(): Galera 3.65(rf47405c) by Codership Oy loaded successfully. 2024-01-10T18:03:41.140312Z 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2024-01-10T18:03:41.141703Z 0 [Note] WSREP: Found saved state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, safe_to_bootstrap: 0 2024-01-10T18:03:41.147382Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.42.0.249; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.freeze_purge_at_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 10; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 9; socket.checksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto; socket.ssl_ca = /etc/mysql/ssl-internal/ca.crt; socket.ssl_cert = /etc/mysql/ssl-internal/tls.crt; socket.ssl_cipher = ; socket.ssl_compression = YES; socket.ssl_key = /etc/mysql/ssl-internal/tls.key; 2024-01-10T18:03:41.168788Z 0 [Note] WSREP: GCache history reset: 4525a31a-a337-11ee-86ef-5aca530f9a97:0 -> 4525a31a-a337-11ee-86ef-5aca530f9a97:932630 2024-01-10T18:03:41.173192Z 0 [Note] WSREP: Assign initial position for certification: 932630, protocol version: -1 2024-01-10T18:03:41.173244Z 0 [Note] WSREP: Preparing to initiate SST/IST 2024-01-10T18:03:41.173252Z 0 [Note] WSREP: Starting replication 2024-01-10T18:03:41.173263Z 0 [Note] WSREP: Setting initial position to 4525a31a-a337-11ee-86ef-5aca530f9a97:932630 2024-01-10T18:03:41.173674Z 0 [Note] WSREP: Using CRC-32C for message checksums. 2024-01-10T18:03:41.173712Z 0 [Note] WSREP: initializing ssl context 2024-01-10T18:03:41.174065Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2024-01-10T18:03:41.174166Z 0 [Note] WSREP: Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown 2024-01-10T18:03:41.174176Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown 2024-01-10T18:03:41.174360Z 0 [Note] WSREP: GMCast version 0 2024-01-10T18:03:41.281686Z 0 [Warning] WSREP: Failed to resolve ssl://mycluster-pxc-db-pxc-1.mycluster-pxc-db-pxc:4567 2024-01-10T18:03:41.281928Z 0 [Note] WSREP: (96281114, 'ssl://0.0.0.0:4567') listening at ssl://0.0.0.0:4567 2024-01-10T18:03:41.281950Z 0 [Note] WSREP: (96281114, 'ssl://0.0.0.0:4567') multicast: , ttl: 1 2024-01-10T18:03:41.282582Z 0 [Note] WSREP: EVS version 0 2024-01-10T18:03:41.282755Z 0 [Note] WSREP: gcomm: connecting to group 'mycluster-pxc-db-pxc', peer 'mycluster-pxc-db-pxc-0.mycluster-pxc-db-pxc:,mycluster-pxc-db-pxc-1.mycluster-pxc-db-pxc:' 2024-01-10T18:03:41.290787Z 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.42.2.13:4567 local endpoint ssl://10.42.0.249:47370 cipher: TLS_AES_256_GCM_SHA384 compression: none 2024-01-10T18:03:41.293667Z 0 [Note] WSREP: (96281114, 'ssl://0.0.0.0:4567') connection established to 74e398cb ssl://10.42.2.13:4567 2024-01-10T18:03:41.293869Z 0 [Note] WSREP: (96281114, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: ssl://10.42.1.59:4567 2024-01-10T18:03:41.587917Z 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.42.1.59:35970 local endpoint ssl://10.42.0.249:4567 cipher: TLS_AES_256_GCM_SHA384 compression: none 2024-01-10T18:03:41.588575Z 0 [Note] WSREP: (96281114, 'ssl://0.0.0.0:4567') connection established to 51673b8a ssl://10.42.1.59:4567 2024-01-10T18:03:41.785988Z 0 [Note] WSREP: declaring 51673b8a at ssl://10.42.1.59:4567 stable 2024-01-10T18:03:41.786052Z 0 [Note] WSREP: declaring 74e398cb at ssl://10.42.2.13:4567 stable 2024-01-10T18:03:41.787235Z 0 [Note] WSREP: Node 51673b8a state primary 2024-01-10T18:03:41.788020Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(PRIM,51673b8a,21) memb { 51673b8a,0 74e398cb,0 96281114,0 } joined { } left { } partitioned { } ) 2024-01-10T18:03:41.788062Z 0 [Note] WSREP: Save the discovered primary-component to disk 2024-01-10T18:03:42.283595Z 0 [Note] WSREP: gcomm: connected 2024-01-10T18:03:42.283795Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2024-01-10T18:03:42.284065Z 0 [Note] WSREP: Waiting for SST/IST to complete. 2024-01-10T18:03:42.284573Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 2, memb_num = 3 2024-01-10T18:03:42.284622Z 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2024-01-10T18:03:42.284677Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 9687c0c2-afe2-11ee-ac4a-c743039977bb 2024-01-10T18:03:42.284694Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9687c0c2-afe2-11ee-ac4a-c743039977bb from 0 (mycluster-pxc-db-pxc-1) 2024-01-10T18:03:42.284707Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9687c0c2-afe2-11ee-ac4a-c743039977bb from 1 (mycluster-pxc-db-pxc-0) 2024-01-10T18:03:42.285831Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9687c0c2-afe2-11ee-ac4a-c743039977bb from 2 (mycluster-pxc-db-pxc-2) 2024-01-10T18:03:42.285867Z 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 2, members = 2/3 (primary/total), act_id = 932635, last_appl. = -1, protocols = 0/9/3 (gcs/repl/appl), group UUID = 4525a31a-a337-11ee-86ef-5aca530f9a97 2024-01-10T18:03:42.285929Z 0 [Note] WSREP: Flow-control interval: [173, 173] 2024-01-10T18:03:42.285940Z 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 932635) 2024-01-10T18:03:42.286049Z 1 [Note] WSREP: State transfer required: Group state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932635 Local state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630 2024-01-10T18:03:42.286104Z 1 [Note] WSREP: REPL Protocols: 9 (4, 2) 2024-01-10T18:03:42.286119Z 1 [Note] WSREP: REPL Protocols: 9 (4, 2) 2024-01-10T18:03:42.286146Z 1 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932635, view# 3: Primary, number of nodes: 3, my index: 2, protocol version 3 2024-01-10T18:03:42.286162Z 1 [Note] WSREP: Setting wsrep_ready to true 2024-01-10T18:03:42.286172Z 1 [Warning] WSREP: Gap in state sequence. Need state transfer. 2024-01-10T18:03:42.286181Z 1 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T18:03:42.286378Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep_sst_xtrabackup-v2 --role 'joiner' --address '10.42.0.249' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '1' --mysqld-version '5.7.43-47-57' '' ) 2024-01-10T18:03:42.800588Z WSREP_SST: [INFO] Streaming with xbstream 2024-01-10T18:03:43.262572Z 1 [Note] WSREP: Prepared SST/IST request: xtrabackup-v2|10.42.0.249:4444/xtrabackup_sst//1 2024-01-10T18:03:43.262649Z 1 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 3) (Increment: 1 -> 3) 2024-01-10T18:03:43.262735Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T18:03:43.262799Z 1 [Note] WSREP: Assign initial position for certification: 932635, protocol version: 4 2024-01-10T18:03:43.262898Z 0 [Note] WSREP: Service thread queue flushed. 2024-01-10T18:03:43.262974Z 1 [Note] WSREP: Check if state gap can be serviced using IST 2024-01-10T18:03:43.263101Z 1 [Note] WSREP: IST receiver addr using ssl://10.42.0.249:4568 2024-01-10T18:03:43.263209Z 1 [Note] WSREP: IST receiver using ssl 2024-01-10T18:03:43.263899Z 1 [Note] WSREP: Prepared IST receiver, listening at: ssl://10.42.0.249:4568 2024-01-10T18:03:43.263929Z 1 [Note] WSREP: State gap can be likely serviced using IST. SST request though present would be void. 2024-01-10T18:03:43.276508Z 0 [Note] WSREP: may fallback to sst. ist_seqno [932630] < safe_ist_seqno [932631] 2024-01-10T18:03:43.276531Z 0 [Note] WSREP: Member 2.0 (mycluster-pxc-db-pxc-2) requested state transfer from 'mycluster-pxc-db-pxc-1,'. Selected 0.0 (mycluster-pxc-db-pxc-1)(SYNCED) as donor. 2024-01-10T18:03:43.276540Z 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 932635) 2024-01-10T18:03:43.276583Z 1 [Note] WSREP: Requesting state transfer: success, donor: 0 2024-01-10T18:03:43.276623Z 1 [Note] WSREP: GCache history reset: 4525a31a-a337-11ee-86ef-5aca530f9a97:0 -> 4525a31a-a337-11ee-86ef-5aca530f9a97:932635 joiner: => Rate:[ 174 B/s] Avg:[ 174 B/s] Elapsed:0:00:00 Bytes: 166 B 2024-01-10T18:03:44.784030Z 0 [Note] WSREP: (96281114, 'ssl://0.0.0.0:4567') turning message relay requesting off 2024-01-10T18:03:45.244539Z WSREP_SST: [INFO] Streaming with xbstream 2024-01-10T18:03:45.259877Z WSREP_SST: [INFO] Proceeding with SST......... 2024-01-10T18:03:45.345740Z WSREP_SST: [INFO] ............Waiting for SST streaming to complete! joiner: => Rate:[0.00 B/s] Avg:[0.00 B/s] Elapsed:0:00:10 Bytes: 0.00 B joiner: => Rate:[72.2MiB/s] Avg:[36.1MiB/s] Elapsed:0:00:20 Bytes: 722MiB joiner: => Rate:[84.8MiB/s] Avg:[52.3MiB/s] Elapsed:0:00:30 Bytes: 1.53GiB 2024-01-10T18:04:15.361345Z 0 [Note] WSREP: 0.0 (mycluster-pxc-db-pxc-1): State transfer to 2.0 (mycluster-pxc-db-pxc-2) complete. 2024-01-10T18:04:15.362322Z 0 [Note] WSREP: Member 0.0 (mycluster-pxc-db-pxc-1) synced with group. joiner: => Rate:[42.9MiB/s] Avg:[42.9MiB/s] Elapsed:0:00:36 Bytes: 1.54GiB 2024-01-10T18:04:22.090611Z WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql//.sst 2024-01-10T18:04:27.009306Z WSREP_SST: [INFO] Moving the backup to /var/lib/mysql/ 2024-01-10T18:04:27.139887Z WSREP_SST: [INFO] Galera co-ords from recovery: 4525a31a-a337-11ee-86ef-5aca530f9a97:932654 2024-01-10T18:04:27.161047Z 0 [Note] WSREP: SST complete, seqno: 932654 2024-01-10T18:04:27.164463Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-01-10T18:04:27.164511Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-01-10T18:04:27.164524Z 0 [Note] InnoDB: Uses event mutexes 2024-01-10T18:04:27.164535Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-01-10T18:04:27.164547Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2024-01-10T18:04:27.164556Z 0 [Note] InnoDB: Using Linux native AIO 2024-01-10T18:04:27.165948Z 0 [Note] InnoDB: Number of pools: 1 2024-01-10T18:04:27.166193Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-01-10T18:04:27.173464Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2024-01-10T18:04:27.181978Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-01-10T18:04:27.185041Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-01-10T18:04:27.204096Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite 2024-01-10T18:04:27.205465Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-01-10T18:04:27.345082Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes 2024-01-10T18:04:27.610901Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2024-01-10T18:04:27.610944Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-01-10T18:04:27.611025Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-01-10T18:04:27.779148Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2024-01-10T18:04:27.780740Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2024-01-10T18:04:27.780779Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2024-01-10T18:04:27.782281Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.43-47 started; log sequence number 1991670312 2024-01-10T18:04:27.782617Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2024-01-10T18:04:27.783026Z 0 [Note] Plugin 'FEDERATED' is disabled. 2024-01-10T18:04:27.795678Z 0 [Note] Salting uuid generator variables, current_pid: 1, server_start_time: 1704909821, bytes_sent: 0, 2024-01-10T18:04:27.795762Z 0 [Note] Generated uuid: 'b1f1f3d7-afe2-11ee-a18a-dadde6d34092', server_start_time: 281476681620478, bytes_sent: 53186464 2024-01-10T18:04:27.795783Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: b1f1f3d7-afe2-11ee-a18a-dadde6d34092. 2024-01-10T18:04:27.815120Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2024-01-10T18:04:27.815175Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2024-01-10T18:04:27.815188Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2024-01-10T18:04:27.816643Z 0 [Warning] CA certificate /etc/mysql/ssl-internal/ca.crt is self signed. 2024-01-10T18:04:27.816726Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2024-01-10T18:04:27.816892Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2024-01-10T18:04:27.816923Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2024-01-10T18:04:27.816969Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2024-01-10T18:04:27.817010Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 33062 2024-01-10T18:04:27.817020Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2024-01-10T18:04:27.817034Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2024-01-10T18:04:27.918046Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240110 18:04:27 2024-01-10T18:04:27.931846Z 0 [Note] Failed to start slave threads for channel '' 2024-01-10T18:04:27.942427Z 0 [Note] Event Scheduler: Loaded 0 events 2024-01-10T18:04:27.942638Z 0 [Note] WSREP: Signalling provider to continue on SST completion. 2024-01-10T18:04:27.942668Z 0 [Note] WSREP: Initialized wsrep sidno 2 2024-01-10T18:04:27.942691Z 0 [Note] WSREP: SST received: 4525a31a-a337-11ee-86ef-5aca530f9a97:932654 2024-01-10T18:04:27.942852Z 0 [Note] mysqld: ready for connections. Version: '5.7.43-47-57-log' socket: '/tmp/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel47, Revision 69b5c96, WSREP version 31.65, wsrep_31.65 2024-01-10T18:04:27.967549Z 0 [Note] WSREP: 2.0 (mycluster-pxc-db-pxc-2): State transfer from 0.0 (mycluster-pxc-db-pxc-1) complete. 2024-01-10T18:04:27.967605Z 0 [Note] WSREP: SST leaving flow control 2024-01-10T18:04:27.967617Z 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 932656) 2024-01-10T18:04:27.968508Z 0 [Note] WSREP: Member 2.0 (mycluster-pxc-db-pxc-2) synced with group. 2024-01-10T18:04:27.968547Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 932656) 2024-01-10T18:04:27.975389Z 1 [Note] WSREP: Synchronized with group, ready for connections 2024-01-10T18:04:27.975420Z 1 [Note] WSREP: Setting wsrep_ready to true 2024-01-10T18:04:27.975433Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.