2024-01-10T17:41:16.755525Z 0 [Note] WSREP: (894c37e2, '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: 219 rttvar: 60 rto: 1632000 lost: 1 last_data_recv: 3024 cwnd: 1 last_queued_since: 24388495 last_delivered_since: 3023822715 send_queue_length: 0 send_queue_bytes: 0 segment: 0 messages: 0 2024-01-10T17:41:16.755943Z 0 [Note] WSREP: (894c37e2, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: ssl://10.42.1.27:4567 2024-01-10T17:41:18.255730Z 0 [Note] WSREP: (894c37e2, 'ssl://0.0.0.0:4567') reconnecting to 51673b8a (ssl://10.42.1.27:4567), attempt 0 2024-01-10T17:41:18.782115Z 0 [Note] WSREP: declaring node with index 1 suspected, timeout PT5S (evs.suspect_timeout) 2024-01-10T17:41:18.782200Z 0 [Note] WSREP: evs::proto(894c37e2, OPERATIONAL, view_id(REG,1aacdd80,18)) suspecting node: 51673b8a 2024-01-10T17:41:18.782220Z 0 [Note] WSREP: evs::proto(894c37e2, OPERATIONAL, view_id(REG,1aacdd80,18)) suspected node without join message, declaring inactive 2024-01-10T17:41:19.282396Z 0 [Note] WSREP: declaring node with index 1 inactive (evs.inactive_timeout) 2024-01-10T17:41:19.783764Z 0 [Note] WSREP: declaring 1aacdd80 at ssl://10.42.0.249:4567 stable 2024-01-10T17:41:49.480302Z 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.393243Z 0 [Note] WSREP: (894c37e2, 'ssl://0.0.0.0:4567') connection to peer 1aacdd80 with addr ssl://10.42.0.249:4567 timed out, no messages seen in PT3S (gmcast.peer_timeout), socket stats: rtt: 2252 rttvar: 3985 rto: 204000 lost: 0 last_data_recv: 35608 cwnd: 10 last_queued_since: 38609658718 last_delivered_since: 38609484319 send_queue_length: 0 send_queue_bytes: 0 segment: 0 messages: 0 2024-01-10T17:41:58.393611Z 0 [Note] WSREP: (894c37e2, '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: 554385756 cwnd: 1 last_queued_since: 554687558160664 last_delivered_since: 554687558160664 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:41:58.411591Z 2393 [Note] Aborted connection 2393 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.419506Z 2370 [Note] Aborted connection 2370 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.427018Z 2371 [Note] Aborted connection 2371 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.431924Z 2373 [Note] Aborted connection 2373 to db: 'unconnected' user: 'monitor' host: 'localhost' (Got an error reading communication packets) 2024-01-10T17:41:58.435719Z 2398 [Note] Aborted connection 2398 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.435933Z 2374 [Note] Aborted connection 2374 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.442478Z 2414 [Note] Aborted connection 2414 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.442793Z 2384 [Note] Aborted connection 2384 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.447687Z 2405 [Note] Aborted connection 2405 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-pxc-0.mycluster-pxc-db-pxc.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.454707Z 2412 [Note] Aborted connection 2412 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.454879Z 2419 [Note] Aborted connection 2419 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.459594Z 2435 [Note] Aborted connection 2435 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.459651Z 2428 [Note] Aborted connection 2428 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.461773Z 2387 [Note] Aborted connection 2387 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.461867Z 2386 [Note] Aborted connection 2386 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.461932Z 2382 [Note] Aborted connection 2382 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.461966Z 2396 [Note] Aborted connection 2396 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.462009Z 2388 [Note] Aborted connection 2388 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.462045Z 2395 [Note] Aborted connection 2395 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.462093Z 2380 [Note] Aborted connection 2380 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.462125Z 2381 [Note] Aborted connection 2381 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.462257Z 2385 [Note] Aborted connection 2385 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.462272Z 2383 [Note] Aborted connection 2383 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.466075Z 2399 [Note] Aborted connection 2399 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.466097Z 2377 [Note] Aborted connection 2377 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.466315Z 2401 [Note] Aborted connection 2401 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.473513Z 2415 [Note] Aborted connection 2415 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.473537Z 2423 [Note] Aborted connection 2423 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.473686Z 2421 [Note] Aborted connection 2421 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.473687Z 2420 [Note] Aborted connection 2420 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.473738Z 2430 [Note] Aborted connection 2430 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.473863Z 2422 [Note] Aborted connection 2422 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.473881Z 2434 [Note] Aborted connection 2434 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.473945Z 2376 [Note] Aborted connection 2376 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.473987Z 2375 [Note] Aborted connection 2375 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.474008Z 2433 [Note] Aborted connection 2433 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.473872Z 2429 [Note] Aborted connection 2429 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-pxc-0.mycluster-pxc-db-pxc.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.474052Z 2390 [Note] Aborted connection 2390 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.474094Z 2372 [Note] Aborted connection 2372 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.475012Z 2391 [Note] Aborted connection 2391 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-pxc-0.mycluster-pxc-db-pxc.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.475086Z 2392 [Note] Aborted connection 2392 to db: 'unconnected' user: 'monitor' host: 'mycluster-pxc-db-pxc-0.mycluster-pxc-db-pxc.pxc.svc.cluster.lo' (Got an error reading communication packets) 2024-01-10T17:41:58.475105Z 2411 [Note] Aborted connection 2411 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.475225Z 2413 [Note] Aborted connection 2413 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.475247Z 2409 [Note] Aborted connection 2409 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.476502Z 2425 [Note] Aborted connection 2425 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.476575Z 2410 [Note] Aborted connection 2410 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.476644Z 2432 [Note] Aborted connection 2432 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.476612Z 2424 [Note] Aborted connection 2424 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.476822Z 2418 [Note] Aborted connection 2418 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.477115Z 2397 [Note] Aborted connection 2397 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.477490Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21156ms. The settings might not be optimal. (flushed=2, during the time.) 2024-01-10T17:41:58.478778Z 2426 [Note] Aborted connection 2426 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.492445Z 2436 [Note] Aborted connection 2436 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.893846Z 0 [Warning] WSREP: last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT39.1112S), skipping check 2024-01-10T17:41:59.393968Z 0 [Note] WSREP: declaring node with index 0 suspected, timeout PT5S (evs.suspect_timeout) 2024-01-10T17:41:59.394020Z 0 [Note] WSREP: declaring node with index 0 inactive (evs.inactive_timeout) 2024-01-10T17:41:59.394042Z 0 [Note] WSREP: evs::proto(894c37e2, OPERATIONAL, view_id(REG,1aacdd80,19)) detected inactive node: 1aacdd80 2024-01-10T17:41:59.394234Z 0 [Note] WSREP: (894c37e2, 'ssl://0.0.0.0:4567') reconnecting to 1aacdd80 (ssl://10.42.0.249:4567), attempt 0 2024-01-10T17:41:59.397593Z 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.42.0.249:59146 local endpoint ssl://10.42.2.13:4567 cipher: TLS_AES_256_GCM_SHA384 compression: none 2024-01-10T17:41:59.402514Z 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.42.0.249:4567 local endpoint ssl://10.42.2.13:53858 cipher: TLS_AES_256_GCM_SHA384 compression: none 2024-01-10T17:41:59.402731Z 0 [Note] WSREP: (894c37e2, 'ssl://0.0.0.0:4567') connection established to 1aacdd80 ssl://10.42.0.249:4567 2024-01-10T17:41:59.403990Z 0 [Note] WSREP: (894c37e2, 'ssl://0.0.0.0:4567') connection established to 1aacdd80 ssl://10.42.0.249:4567 2024-01-10T17:42:00.394288Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,1aacdd80,19) memb { 894c37e2,0 } joined { } left { } partitioned { 1aacdd80,0 51673b8a,0 } ) 2024-01-10T17:42:00.394429Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2024-01-10T17:42:00.394490Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,894c37e2,20) memb { 894c37e2,0 } joined { } left { } partitioned { 1aacdd80,0 51673b8a,0 } ) 2024-01-10T17:42:00.394536Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2024-01-10T17:42:00.394582Z 0 [Note] WSREP: Received NON-PRIMARY. 2024-01-10T17:42:00.394593Z 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 932630) 2024-01-10T17:42:00.394638Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2024-01-10T17:42:00.394669Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2024-01-10T17:42:00.394682Z 0 [Note] WSREP: Received NON-PRIMARY. 2024-01-10T17:42:00.394703Z 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:00.394731Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:42:00.394793Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:42:00.394852Z 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:00.394861Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:42:00.394869Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:42:00.396860Z 0 [Note] WSREP: declaring 1aacdd80 at ssl://10.42.0.249:4567 stable 2024-01-10T17:42:00.397429Z 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.397541Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 1, memb_num = 2 2024-01-10T17:42:00.397586Z 0 [Note] WSREP: Flow-control interval: [141, 141] 2024-01-10T17:42:00.397603Z 0 [Note] WSREP: Received NON-PRIMARY. 2024-01-10T17:42:00.397686Z 4 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, view# -1: non-Primary, number of nodes: 2, my index: 1, protocol version 3 2024-01-10T17:42:00.397715Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:42:00.397726Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:42:00.402120Z 2117 [Warning] WSREP: Send action {(nil), 704, TORDERED} returned -107 (Transport endpoint is not connected) 2024-01-10T17:42:02.395122Z 0 [Note] WSREP: (894c37e2, '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: 554389756 cwnd: 1 last_queued_since: 554691559647037 last_delivered_since: 554691559647037 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:42:06.395855Z 0 [Note] WSREP: (894c37e2, '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: 554393760 cwnd: 1 last_queued_since: 554695560367904 last_delivered_since: 554695560367904 send_queue_length: 0 send_queue_bytes: 0 2024-01-10T17:42:08.394060Z 0 [Note] WSREP: Stop replication 2024-01-10T17:42:08.394114Z 0 [Note] WSREP: Closing send monitor... 2024-01-10T17:42:08.394134Z 0 [Note] WSREP: Closed send monitor. 2024-01-10T17:42:08.394166Z 0 [Note] WSREP: gcomm: terminating thread 2024-01-10T17:42:08.394187Z 0 [Note] WSREP: gcomm: joining thread 2024-01-10T17:42:08.394579Z 0 [Note] WSREP: gcomm: closing backend 2024-01-10T17:42:09.389193Z 0 [Note] WSREP: forgetting 1aacdd80 (ssl://10.42.0.249:4567) 2024-01-10T17:42:09.389278Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(NON_PRIM,894c37e2,22) memb { 894c37e2,0 } joined { } left { } partitioned { 1aacdd80,0 51673b8a,0 } ) 2024-01-10T17:42:09.389323Z 0 [Note] WSREP: Current view of cluster as seen by this node view ((empty)) 2024-01-10T17:42:09.389566Z 0 [Note] WSREP: gcomm: closed 2024-01-10T17:42:09.389595Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2024-01-10T17:42:09.389639Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2024-01-10T17:42:09.389650Z 0 [Note] WSREP: Received NON-PRIMARY. 2024-01-10T17:42:09.389676Z 0 [Note] WSREP: Received self-leave message. 2024-01-10T17:42:09.389714Z 0 [Note] WSREP: Flow-control interval: [0, 0] 2024-01-10T17:42:09.389725Z 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2024-01-10T17:42:09.389734Z 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 932630) 2024-01-10T17:42:09.389747Z 0 [Note] WSREP: RECV thread exiting 0: Success 2024-01-10T17:42:09.389760Z 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:09.389795Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:42:09.389827Z 0 [Note] WSREP: recv_thread() joined. 2024-01-10T17:42:09.389847Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:42:09.389853Z 0 [Note] WSREP: Closing replication queue. 2024-01-10T17:42:09.389880Z 0 [Note] WSREP: Closing slave action queue. 2024-01-10T17:42:09.389886Z 0 [Note] WSREP: Waiting for active wsrep applier to exit 2024-01-10T17:42:09.389893Z 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:09.389913Z 4 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T17:42:09.389928Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T17:42:09.411575Z 4 [Note] WSREP: applier thread exiting (code:0) 2024-01-10T17:42:09.419982Z 2 [Note] WSREP: applier thread exiting (code:6) 2024-01-10T17:42:09.420157Z 1 [Note] WSREP: rollbacker thread exiting 2024-01-10T17:42:09.420831Z 0 [Note] Giving 80 client threads a chance to die gracefully 2024-01-10T17:42:09.421181Z 0 [Note] Shutting down slave threads 2024-01-10T17:42:11.421312Z 0 [Note] Forcefully disconnecting 66 remaining clients 2024-01-10T17:42:11.421386Z 0 [Warning] mysqld: Forcing close of thread 2438 user: 'some-user' 2024-01-10T17:42:11.421467Z 0 [Warning] mysqld: Forcing close of thread 2379 user: 'some-user' 2024-01-10T17:42:11.421576Z 0 [Warning] mysqld: Forcing close of thread 1932 user: 'some-user' 2024-01-10T17:42:11.421657Z 0 [Warning] mysqld: Forcing close of thread 1871 user: 'some-user' 2024-01-10T17:42:11.421768Z 0 [Warning] mysqld: Forcing close of thread 1460 user: 'some-user' 2024-01-10T17:42:11.421866Z 0 [Warning] mysqld: Forcing close of thread 1933 user: 'some-user' 2024-01-10T17:42:11.421977Z 0 [Warning] mysqld: Forcing close of thread 1150 user: 'some-user' 2024-01-10T17:42:11.422057Z 0 [Warning] mysqld: Forcing close of thread 837 user: 'some-user' 2024-01-10T17:42:11.422147Z 0 [Warning] mysqld: Forcing close of thread 888 user: 'some-user' 2024-01-10T17:42:11.422235Z 0 [Warning] mysqld: Forcing close of thread 1149 user: 'some-user' 2024-01-10T17:42:11.422308Z 0 [Warning] mysqld: Forcing close of thread 1071 user: 'some-user' 2024-01-10T17:42:11.422354Z 0 [Warning] mysqld: Forcing close of thread 841 user: 'some-user' 2024-01-10T17:42:11.422419Z 0 [Warning] mysqld: Forcing close of thread 843 user: 'some-user' 2024-01-10T17:42:11.422490Z 0 [Warning] mysqld: Forcing close of thread 889 user: 'some-user' 2024-01-10T17:42:11.422554Z 0 [Warning] mysqld: Forcing close of thread 839 user: 'some-user' 2024-01-10T17:42:11.422612Z 0 [Warning] mysqld: Forcing close of thread 854 user: 'some-user' 2024-01-10T17:42:11.422675Z 0 [Warning] mysqld: Forcing close of thread 847 user: 'some-user' 2024-01-10T17:42:11.422736Z 0 [Warning] mysqld: Forcing close of thread 849 user: 'some-user' 2024-01-10T17:42:11.422815Z 0 [Warning] mysqld: Forcing close of thread 838 user: 'some-user' 2024-01-10T17:42:11.422921Z 0 [Warning] mysqld: Forcing close of thread 845 user: 'some-user' 2024-01-10T17:42:11.422977Z 0 [Warning] mysqld: Forcing close of thread 1072 user: 'some-user' 2024-01-10T17:42:11.423033Z 0 [Warning] mysqld: Forcing close of thread 1940 user: 'some-user' 2024-01-10T17:42:11.423091Z 0 [Warning] mysqld: Forcing close of thread 851 user: 'some-user' 2024-01-10T17:42:11.423145Z 0 [Warning] mysqld: Forcing close of thread 1139 user: 'some-user' 2024-01-10T17:42:11.423199Z 0 [Warning] mysqld: Forcing close of thread 850 user: 'some-user' 2024-01-10T17:42:11.423255Z 0 [Warning] mysqld: Forcing close of thread 852 user: 'some-user' 2024-01-10T17:42:11.423337Z 0 [Warning] mysqld: Forcing close of thread 840 user: 'some-user' 2024-01-10T17:42:11.423403Z 0 [Warning] mysqld: Forcing close of thread 1138 user: 'some-user' 2024-01-10T17:42:11.423500Z 0 [Warning] mysqld: Forcing close of thread 664 user: 'some-user' 2024-01-10T17:42:11.423561Z 0 [Warning] mysqld: Forcing close of thread 890 user: 'some-user' 2024-01-10T17:42:11.423625Z 0 [Warning] mysqld: Forcing close of thread 663 user: 'some-user' 2024-01-10T17:42:11.423689Z 0 [Warning] mysqld: Forcing close of thread 662 user: 'some-user' 2024-01-10T17:42:11.423729Z 0 [Warning] mysqld: Forcing close of thread 624 user: 'some-user' 2024-01-10T17:42:11.423782Z 0 [Warning] mysqld: Forcing close of thread 625 user: 'some-user' 2024-01-10T17:42:11.423829Z 0 [Warning] mysqld: Forcing close of thread 574 user: 'some-user' 2024-01-10T17:42:11.423878Z 0 [Warning] mysqld: Forcing close of thread 570 user: 'some-user' 2024-01-10T17:42:11.423975Z 0 [Warning] mysqld: Forcing close of thread 573 user: 'some-user' 2024-01-10T17:42:11.424058Z 0 [Warning] mysqld: Forcing close of thread 550 user: 'some-user' 2024-01-10T17:42:11.424121Z 0 [Warning] mysqld: Forcing close of thread 572 user: 'some-user' 2024-01-10T17:42:11.424159Z 0 [Warning] mysqld: Forcing close of thread 546 user: 'some-user' 2024-01-10T17:42:11.424206Z 0 [Warning] mysqld: Forcing close of thread 549 user: 'some-user' 2024-01-10T17:42:11.424261Z 0 [Warning] mysqld: Forcing close of thread 548 user: 'some-user' 2024-01-10T17:42:11.424329Z 0 [Warning] mysqld: Forcing close of thread 547 user: 'some-user' 2024-01-10T17:42:11.424376Z 0 [Warning] mysqld: Forcing close of thread 517 user: 'some-user' 2024-01-10T17:42:11.424428Z 0 [Warning] mysqld: Forcing close of thread 518 user: 'some-user' 2024-01-10T17:42:11.424528Z 0 [Warning] mysqld: Forcing close of thread 515 user: 'some-user' 2024-01-10T17:42:11.424625Z 0 [Warning] mysqld: Forcing close of thread 516 user: 'some-user' 2024-01-10T17:42:11.424678Z 0 [Warning] mysqld: Forcing close of thread 514 user: 'some-user' 2024-01-10T17:42:11.424799Z 0 [Warning] mysqld: Forcing close of thread 1145 user: 'some-user' 2024-01-10T17:42:11.424898Z 0 [Warning] mysqld: Forcing close of thread 1144 user: 'some-user' 2024-01-10T17:42:11.424964Z 0 [Warning] mysqld: Forcing close of thread 442 user: 'some-user' 2024-01-10T17:42:11.425016Z 0 [Warning] mysqld: Forcing close of thread 1073 user: 'some-user' 2024-01-10T17:42:11.425064Z 0 [Warning] mysqld: Forcing close of thread 1137 user: 'some-user' 2024-01-10T17:42:11.425126Z 0 [Warning] mysqld: Forcing close of thread 1147 user: 'some-user' 2024-01-10T17:42:11.425200Z 0 [Warning] mysqld: Forcing close of thread 1140 user: 'some-user' 2024-01-10T17:42:11.425262Z 0 [Warning] mysqld: Forcing close of thread 1944 user: 'some-user' 2024-01-10T17:42:11.425318Z 0 [Warning] mysqld: Forcing close of thread 1002 user: 'some-user' 2024-01-10T17:42:11.425384Z 0 [Warning] mysqld: Forcing close of thread 1148 user: 'some-user' 2024-01-10T17:42:11.425450Z 0 [Warning] mysqld: Forcing close of thread 1141 user: 'some-user' 2024-01-10T17:42:11.425524Z 0 [Warning] mysqld: Forcing close of thread 1142 user: 'some-user' 2024-01-10T17:42:11.425617Z 0 [Warning] mysqld: Forcing close of thread 1146 user: 'some-user' 2024-01-10T17:42:11.425681Z 0 [Warning] mysqld: Forcing close of thread 1143 user: 'some-user' 2024-01-10T17:42:11.425761Z 0 [Warning] mysqld: Forcing close of thread 887 user: 'some-user' 2024-01-10T17:42:11.425849Z 0 [Warning] mysqld: Forcing close of thread 848 user: 'some-user' 2024-01-10T17:42:11.425969Z 0 [Warning] mysqld: Forcing close of thread 853 user: 'some-user' 2024-01-10T17:42:11.426094Z 0 [Warning] mysqld: Forcing close of thread 842 user: 'some-user' 2024-01-10T17:42:11.426172Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2024-01-10T17:42:11.451819Z 0 [Note] WSREP: Service thread queue flushed. 2024-01-10T17:42:11.452241Z 0 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0.597403, misses: 124, in use: 0, in pool: 124 2024-01-10T17:42:11.477968Z 0 [Note] Binlog end 2024-01-10T17:42:11.491340Z 0 [Note] Shutting down plugin 'ngram' 2024-01-10T17:42:11.491384Z 0 [Note] Shutting down plugin 'partition' 2024-01-10T17:42:11.491395Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2024-01-10T17:42:11.491406Z 0 [Note] Shutting down plugin 'ARCHIVE' 2024-01-10T17:42:11.491414Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2024-01-10T17:42:11.491423Z 0 [Note] Shutting down plugin 'MyISAM' 2024-01-10T17:42:11.491471Z 0 [Note] Shutting down plugin 'INNODB_TABLESPACES_SCRUBBING' 2024-01-10T17:42:11.491501Z 0 [Note] Shutting down plugin 'INNODB_TABLESPACES_ENCRYPTION' 2024-01-10T17:42:11.491513Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2024-01-10T17:42:11.491522Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2024-01-10T17:42:11.491530Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2024-01-10T17:42:11.491538Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2024-01-10T17:42:11.491546Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2024-01-10T17:42:11.491553Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2024-01-10T17:42:11.491561Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2024-01-10T17:42:11.491569Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2024-01-10T17:42:11.491577Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2024-01-10T17:42:11.491585Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2024-01-10T17:42:11.491593Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2024-01-10T17:42:11.491602Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2024-01-10T17:42:11.491610Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2024-01-10T17:42:11.491618Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2024-01-10T17:42:11.491627Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2024-01-10T17:42:11.491636Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2024-01-10T17:42:11.491644Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2024-01-10T17:42:11.491651Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2024-01-10T17:42:11.491660Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2024-01-10T17:42:11.491668Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2024-01-10T17:42:11.491676Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2024-01-10T17:42:11.491687Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2024-01-10T17:42:11.491695Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2024-01-10T17:42:11.491703Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2024-01-10T17:42:11.491711Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2024-01-10T17:42:11.491719Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2024-01-10T17:42:11.491727Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2024-01-10T17:42:11.491736Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2024-01-10T17:42:11.491746Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2024-01-10T17:42:11.491753Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2024-01-10T17:42:11.491761Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2024-01-10T17:42:11.491770Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2024-01-10T17:42:11.491779Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2024-01-10T17:42:11.491789Z 0 [Note] Shutting down plugin 'XTRADB_RSEG' 2024-01-10T17:42:11.491798Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2024-01-10T17:42:11.491806Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2024-01-10T17:42:11.491813Z 0 [Note] Shutting down plugin 'InnoDB' 2024-01-10T17:42:11.494018Z 0 [Note] InnoDB: FTS optimize thread exiting. 2024-01-10T17:42:11.494214Z 0 [Note] InnoDB: Starting shutdown... 2024-01-10T17:42:11.594606Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2024-01-10T17:42:11.595506Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240110 17:42:11 2024-01-10T17:42:11.794693Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2024-01-10T17:42:13.279924Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1991708222 2024-01-10T17:42:13.280102Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2024-01-10T17:42:13.280125Z 0 [Note] Shutting down plugin 'MEMORY' 2024-01-10T17:42:13.280136Z 0 [Note] Shutting down plugin 'CSV' 2024-01-10T17:42:13.280144Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2024-01-10T17:42:13.280207Z 0 [Note] Shutting down plugin 'sha256_password' 2024-01-10T17:42:13.280216Z 0 [Note] Shutting down plugin 'mysql_native_password' 2024-01-10T17:42:13.280233Z 0 [Note] Shutting down plugin 'wsrep' 2024-01-10T17:42:13.280517Z 0 [Note] Shutting down plugin 'binlog' 2024-01-10T17:42:13.303109Z 0 [Note] mysqld: Shutdown complete 2024-01-10T18:02:45.321158Z 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:02:45.323293Z 0 [Note] mysqld (mysqld 5.7.43-47-57-log) starting as process 1 ... 2024-01-10T18:02:45.326639Z 0 [Note] WSREP: Skipping automatic SSL certificate generation (enabled only in bootstrap mode) 2024-01-10T18:02:45.327139Z 0 [Note] WSREP: Setting wsrep_ready to false 2024-01-10T18:02:45.327169Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization. 2024-01-10T18:02:45.327177Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera3/libgalera_smm.so' 2024-01-10T18:02:45.327923Z 0 [Note] WSREP: wsrep_load(): Galera 3.65(rf47405c) by Codership Oy loaded successfully. 2024-01-10T18:02:45.327969Z 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration. 2024-01-10T18:02:45.328853Z 0 [Note] WSREP: Found saved state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, safe_to_bootstrap: 1 2024-01-10T18:02:45.334936Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.42.2.13; 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:02:45.355465Z 0 [Note] WSREP: GCache history reset: 4525a31a-a337-11ee-86ef-5aca530f9a97:0 -> 4525a31a-a337-11ee-86ef-5aca530f9a97:932630 2024-01-10T18:02:45.359752Z 0 [Note] WSREP: Assign initial position for certification: 932630, protocol version: -1 2024-01-10T18:02:45.359772Z 0 [Note] WSREP: Preparing to initiate SST/IST 2024-01-10T18:02:45.359779Z 0 [Note] WSREP: Starting replication 2024-01-10T18:02:45.359788Z 0 [Note] WSREP: Setting initial position to 4525a31a-a337-11ee-86ef-5aca530f9a97:932630 2024-01-10T18:02:45.360182Z 0 [Note] WSREP: Using CRC-32C for message checksums. 2024-01-10T18:02:45.360223Z 0 [Note] WSREP: initializing ssl context 2024-01-10T18:02:45.360513Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 2024-01-10T18:02:45.360598Z 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:02:45.360619Z 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:02:45.360799Z 0 [Note] WSREP: GMCast version 0 2024-01-10T18:02:45.360884Z 0 [Note] WSREP: (74e398cb, 'ssl://0.0.0.0:4567') listening at ssl://0.0.0.0:4567 2024-01-10T18:02:45.360892Z 0 [Note] WSREP: (74e398cb, 'ssl://0.0.0.0:4567') multicast: , ttl: 1 2024-01-10T18:02:45.361168Z 0 [Note] WSREP: EVS version 0 2024-01-10T18:02:45.361238Z 0 [Note] WSREP: gcomm: connecting to group 'mycluster-pxc-db-pxc', peer '' 2024-01-10T18:02:45.361263Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2024-01-10T18:02:45.361461Z 0 [Note] WSREP: Node 74e398cb state primary 2024-01-10T18:02:45.361485Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(PRIM,74e398cb,1) memb { 74e398cb,0 } joined { } left { } partitioned { } ) 2024-01-10T18:02:45.361492Z 0 [Note] WSREP: Save the discovered primary-component to disk 2024-01-10T18:02:45.375742Z 0 [Note] WSREP: gcomm: connected 2024-01-10T18:02:45.375887Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2024-01-10T18:02:45.375975Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2024-01-10T18:02:45.376087Z 0 [Note] WSREP: Waiting for SST/IST to complete. 2024-01-10T18:02:45.376127Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 74e5f317-afe2-11ee-87f1-12d12be791d5 2024-01-10T18:02:45.376147Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 74e5f317-afe2-11ee-87f1-12d12be791d5 2024-01-10T18:02:45.376157Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 74e5f317-afe2-11ee-87f1-12d12be791d5 from 0 (mycluster-pxc-db-pxc-0) 2024-01-10T18:02:45.376169Z 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 0, members = 1/1 (primary/total), act_id = 932630, last_appl. = -1, protocols = 0/9/3 (gcs/repl/appl), group UUID = 4525a31a-a337-11ee-86ef-5aca530f9a97 2024-01-10T18:02:45.376178Z 0 [Note] WSREP: Flow-control interval: [100, 100] 2024-01-10T18:02:45.376185Z 0 [Note] WSREP: Restored state OPEN -> JOINED (932630) 2024-01-10T18:02:45.376214Z 0 [Note] WSREP: Member 0.0 (mycluster-pxc-db-pxc-0) synced with group. 2024-01-10T18:02:45.376223Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 932630) 2024-01-10T18:02:45.376301Z 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2024-01-10T18:02:45.376328Z 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2024-01-10T18:02:45.376343Z 2 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 2024-01-10T18:02:45.376349Z 2 [Note] WSREP: Setting wsrep_ready to true 2024-01-10T18:02:45.376391Z 0 [Note] WSREP: SST complete, seqno: 932630 2024-01-10T18:02:45.379355Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-01-10T18:02:45.379384Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-01-10T18:02:45.379394Z 0 [Note] InnoDB: Uses event mutexes 2024-01-10T18:02:45.379403Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-01-10T18:02:45.379413Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2024-01-10T18:02:45.379421Z 0 [Note] InnoDB: Using Linux native AIO 2024-01-10T18:02:45.380607Z 0 [Note] InnoDB: Number of pools: 1 2024-01-10T18:02:45.380798Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-01-10T18:02:45.727916Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2024-01-10T18:02:45.737127Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-01-10T18:02:45.740907Z 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:02:45.766830Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite 2024-01-10T18:02:45.769060Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-01-10T18:02:45.859534Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes 2024-01-10T18:02:46.169799Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2024-01-10T18:02:46.169899Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2024-01-10T18:02:46.337301Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2024-01-10T18:02:46.338737Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2024-01-10T18:02:46.338768Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2024-01-10T18:02:46.340481Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.43-47 started; log sequence number 1991708222 2024-01-10T18:02:46.340731Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2024-01-10T18:02:46.341105Z 0 [Note] Plugin 'FEDERATED' is disabled. 2024-01-10T18:02:46.355291Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2024-01-10T18:02:46.355317Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2024-01-10T18:02:46.355322Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2024-01-10T18:02:46.356165Z 0 [Warning] CA certificate /etc/mysql/ssl-internal/ca.crt is self signed. 2024-01-10T18:02:46.356209Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2024-01-10T18:02:46.356297Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2024-01-10T18:02:46.356324Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2024-01-10T18:02:46.356356Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2024-01-10T18:02:46.356379Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 33062 2024-01-10T18:02:46.356384Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2024-01-10T18:02:46.356391Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2024-01-10T18:02:46.475111Z 0 [Note] InnoDB: Buffer pool(s) load completed at 240110 18:02:46 2024-01-10T18:02:46.502480Z 0 [Note] Failed to start slave threads for channel '' 2024-01-10T18:02:46.513864Z 0 [Note] Event Scheduler: Loaded 0 events 2024-01-10T18:02:46.514300Z 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:02:46.528621Z 2 [Note] WSREP: Initialized wsrep sidno 2 2024-01-10T18:02:46.528661Z 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 -> 1) 2024-01-10T18:02:46.528728Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T18:02:46.528768Z 2 [Note] WSREP: Assign initial position for certification: 932630, protocol version: 4 2024-01-10T18:02:46.528887Z 0 [Note] WSREP: Service thread queue flushed. 2024-01-10T18:02:46.528957Z 2 [Note] WSREP: GCache history reset: 4525a31a-a337-11ee-86ef-5aca530f9a97:0 -> 4525a31a-a337-11ee-86ef-5aca530f9a97:932630 2024-01-10T18:02:46.546826Z 2 [Note] WSREP: Synchronized with group, ready for connections 2024-01-10T18:02:46.546850Z 2 [Note] WSREP: Setting wsrep_ready to true 2024-01-10T18:02:46.546857Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T18:02:47.447932Z 7 [Warning] IP address '10.42.2.15' could not be resolved: Name or service not known 2024-01-10T18:02:48.490152Z 8 [Warning] IP address '10.42.0.244' could not be resolved: Name or service not known 2024-01-10T18:02:49.892667Z 9 [Warning] IP address '10.42.2.15' could not be resolved: Name or service not known 2024-01-10T18:02:50.490654Z 12 [Warning] IP address '10.42.2.15' could not be resolved: Name or service not known 2024-01-10T18:02:50.936332Z 13 [Warning] IP address '10.42.0.244' could not be resolved: Name or service not known 2024-01-10T18:02:52.508974Z 16 [Warning] IP address '10.42.0.244' could not be resolved: Name or service not known 2024-01-10T18:02:52.677948Z 19 [Warning] IP address '10.42.0.244' could not be resolved: Name or service not known 2024-01-10T18:02:54.109704Z 27 [Warning] IP address '10.42.0.244' could not be resolved: Name or service not known 2024-01-10T18:02:55.104209Z 33 [Warning] IP address '10.42.0.244' could not be resolved: Name or service not known 2024-01-10T18:03:13.468457Z 164 [Note] Got an error reading communication packets 2024-01-10T18:03:20.587383Z 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.42.1.59:38806 local endpoint ssl://10.42.2.13:4567 cipher: TLS_AES_256_GCM_SHA384 compression: none 2024-01-10T18:03:20.588147Z 0 [Note] WSREP: (74e398cb, 'ssl://0.0.0.0:4567') connection established to 51673b8a ssl://10.42.1.59:4567 2024-01-10T18:03:20.588794Z 0 [Note] WSREP: (74e398cb, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2024-01-10T18:03:21.079474Z 0 [Note] WSREP: declaring 51673b8a at ssl://10.42.1.59:4567 stable 2024-01-10T18:03:21.080250Z 0 [Note] WSREP: Node 74e398cb state primary 2024-01-10T18:03:21.096449Z 0 [Note] WSREP: Current view of cluster as seen by this node view (view_id(PRIM,51673b8a,20) memb { 51673b8a,0 74e398cb,0 } joined { } left { } partitioned { } ) 2024-01-10T18:03:21.096511Z 0 [Note] WSREP: Save the discovered primary-component to disk 2024-01-10T18:03:21.110931Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 2024-01-10T18:03:21.110994Z 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2024-01-10T18:03:21.579592Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 8a7863b0-afe2-11ee-bde1-62d52fda42bc 2024-01-10T18:03:21.579944Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8a7863b0-afe2-11ee-bde1-62d52fda42bc from 0 (mycluster-pxc-db-pxc-1) 2024-01-10T18:03:21.579967Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 8a7863b0-afe2-11ee-bde1-62d52fda42bc from 1 (mycluster-pxc-db-pxc-0) 2024-01-10T18:03:21.579985Z 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 1, members = 1/2 (primary/total), act_id = 932634, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = 4525a31a-a337-11ee-86ef-5aca530f9a97 2024-01-10T18:03:21.580001Z 0 [Note] WSREP: Flow-control interval: [141, 141] 2024-01-10T18:03:21.580166Z 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2024-01-10T18:03:21.580208Z 2 [Note] WSREP: REPL Protocols: 9 (4, 2) 2024-01-10T18:03:21.580231Z 2 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932634, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 3 2024-01-10T18:03:21.580241Z 2 [Note] WSREP: Setting wsrep_ready to true 2024-01-10T18:03:21.580252Z 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 2) (Increment: 1 -> 2) 2024-01-10T18:03:21.580298Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T18:03:21.580346Z 2 [Note] WSREP: Assign initial position for certification: 932634, protocol version: 4 2024-01-10T18:03:21.580438Z 0 [Note] WSREP: Service thread queue flushed. 2024-01-10T18:03:22.677442Z 0 [Note] WSREP: may fallback to sst. ist_seqno [932630] < safe_ist_seqno [932631] 2024-01-10T18:03:22.677504Z 0 [Note] WSREP: Member 0.0 (mycluster-pxc-db-pxc-1) requested state transfer from '*any*'. Selected 1.0 (mycluster-pxc-db-pxc-0)(SYNCED) as donor. 2024-01-10T18:03:22.677520Z 0 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 932634) 2024-01-10T18:03:22.677647Z 2 [Note] WSREP: IST request: 4525a31a-a337-11ee-86ef-5aca530f9a97:932630-932634|ssl://10.42.1.59:4568 2024-01-10T18:03:22.677707Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T18:03:22.677992Z 0 [Note] WSREP: Initiating SST/IST transfer on DONOR side (wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.42.1.59:4444/xtrabackup_sst//1' --socket '/tmp/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --mysqld-version '5.7.43-47-57' '' --gtid '4525a31a-a337-11ee-86ef-5aca530f9a97:932630' --bypass) 2024-01-10T18:03:22.678814Z 2 [Note] WSREP: DONOR thread signaled with 0 2024-01-10T18:03:22.679631Z 2 [Note] WSREP: IST sender using ssl 2024-01-10T18:03:22.691034Z 0 [Note] WSREP: async IST sender starting to serve ssl://10.42.1.59:4568 sending 932631-932634 2024-01-10T18:03:23.245834Z WSREP_SST: [INFO] Streaming with xbstream 2024-01-10T18:03:23.506894Z WSREP_SST: [INFO] Bypassing SST. Can work it through IST 2024-01-10T18:03:23.879951Z 0 [Note] WSREP: (74e398cb, 'ssl://0.0.0.0:4567') turning message relay requesting off 2024-01-10T18:03:24.614773Z 0 [Note] WSREP: 1.0 (mycluster-pxc-db-pxc-0): State transfer to 0.0 (mycluster-pxc-db-pxc-1) complete. 2024-01-10T18:03:24.614826Z 0 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 932635) 2024-01-10T18:03:24.615111Z 0 [Note] WSREP: Member 1.0 (mycluster-pxc-db-pxc-0) synced with group. 2024-01-10T18:03:24.615127Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 932635) 2024-01-10T18:03:24.615169Z 2 [Note] WSREP: Synchronized with group, ready for connections 2024-01-10T18:03:24.615202Z 2 [Note] WSREP: Setting wsrep_ready to true 2024-01-10T18:03:24.615215Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T18:03:25.240884Z 0 [Note] WSREP: async IST sender served 2024-01-10T18:03:25.242010Z 0 [Note] WSREP: 0.0 (mycluster-pxc-db-pxc-1): State transfer from 1.0 (mycluster-pxc-db-pxc-0) complete. 2024-01-10T18:03:25.242276Z 0 [Note] WSREP: Member 0.0 (mycluster-pxc-db-pxc-1) synced with group. 2024-01-10T18:03:41.295402Z 0 [Note] WSREP: SSL handshake successful, remote endpoint ssl://10.42.0.249:47370 local endpoint ssl://10.42.2.13:4567 cipher: TLS_AES_256_GCM_SHA384 compression: none 2024-01-10T18:03:41.296068Z 0 [Note] WSREP: (74e398cb, 'ssl://0.0.0.0:4567') connection established to 96281114 ssl://10.42.0.249:4567 2024-01-10T18:03:41.296573Z 0 [Note] WSREP: (74e398cb, 'ssl://0.0.0.0:4567') turning message relay requesting on, nonlive peers: 2024-01-10T18:03:41.788663Z 0 [Note] WSREP: declaring 51673b8a at ssl://10.42.1.59:4567 stable 2024-01-10T18:03:41.788738Z 0 [Note] WSREP: declaring 96281114 at ssl://10.42.0.249:4567 stable 2024-01-10T18:03:41.789879Z 0 [Note] WSREP: Node 51673b8a state primary 2024-01-10T18:03:41.790718Z 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.790763Z 0 [Note] WSREP: Save the discovered primary-component to disk 2024-01-10T18:03:41.808500Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3 2024-01-10T18:03:41.808576Z 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. 2024-01-10T18:03:41.815224Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 9687c0c2-afe2-11ee-ac4a-c743039977bb 2024-01-10T18:03:41.815932Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9687c0c2-afe2-11ee-ac4a-c743039977bb from 0 (mycluster-pxc-db-pxc-1) 2024-01-10T18:03:41.815983Z 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.288548Z 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.288600Z 0 [Note] WSREP: Quorum results: version = 6, component = PRIMARY, conf_id = 2, members = 2/3 (primary/total), act_id = 932635, last_appl. = 0, protocols = 0/9/3 (gcs/repl/appl), group UUID = 4525a31a-a337-11ee-86ef-5aca530f9a97 2024-01-10T18:03:42.288616Z 0 [Note] WSREP: Flow-control interval: [173, 173] 2024-01-10T18:03:42.288767Z 4 [Note] WSREP: REPL Protocols: 9 (4, 2) 2024-01-10T18:03:42.288831Z 4 [Note] WSREP: REPL Protocols: 9 (4, 2) 2024-01-10T18:03:42.288855Z 4 [Note] WSREP: New cluster view: global state: 4525a31a-a337-11ee-86ef-5aca530f9a97:932635, view# 3: Primary, number of nodes: 3, my index: 1, protocol version 3 2024-01-10T18:03:42.288865Z 4 [Note] WSREP: Setting wsrep_ready to true 2024-01-10T18:03:42.288877Z 4 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 2 -> 2) (Increment: 2 -> 3) 2024-01-10T18:03:42.288993Z 4 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2024-01-10T18:03:42.289137Z 4 [Note] WSREP: Assign initial position for certification: 932635, protocol version: 4 2024-01-10T18:03:42.289220Z 0 [Note] WSREP: Service thread queue flushed. 2024-01-10T18:03:43.279127Z 0 [Note] WSREP: may fallback to sst. ist_seqno [932630] < safe_ist_seqno [932631] 2024-01-10T18:03:43.279183Z 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:44.382562Z 0 [Note] WSREP: (74e398cb, 'ssl://0.0.0.0:4567') turning message relay requesting off 2024-01-10T18:04:15.363988Z 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.364910Z 0 [Note] WSREP: Member 0.0 (mycluster-pxc-db-pxc-1) synced with group. 2024-01-10T18:04:27.970260Z 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.971236Z 0 [Note] WSREP: Member 2.0 (mycluster-pxc-db-pxc-2) synced with group. 2024-01-10T18:04:57.928785Z 663 [Note] Got an error reading communication packets