Support IT

- dilihat dari log :
2104:
--
Dec 08 20:28:36 whn2104 mariadbd¹⁶⁰⁵³: 2023-12-08 20:28:36 0 [Note] WSREP: (df960db3-adea, 'tcp://0.0.0.0:4567') connection to peer 8d14fc33-bb81 with addr tcp://192.168.88.103:4567 timed out, no messages seen in PT3S, socket stats: rtt: 3338 rttvar: 867 rto: 204000 lost: 0 last_data_recv: 16770 cwnd: 8 last_queued_since: 25656166 last_delivered_since: 19892222723 send_queue_length: 0 send_queue_bytes: 0 segment: 0 messages: 0
Dec 08 20:28:36 whn2104 mariadbd¹⁶⁰⁵³: 2023-12-08 20:28:36 0 [Note] WSREP: (df960db3-adea, 'tcp://0.0.0.0:4567') connection to peer c9d0eb71-a836 with addr tcp://192.168.88.101:4567 timed out, no messages seen in PT3S, socket stats: rtt: 1072 rttvar: 1359 rto: 202000 lost: 0 last_data_recv: 16736 cwnd: 10 last_queued_since: 59522 last_delivered_since: 19894436704 send_queue_length: 1 send_queue_bytes: 508 segment: 0 messages: 1
Dec 08 20:28:36 whn2104 mariadbd¹⁶⁰⁵³: 2023-12-08 20:28:36 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: tcp://192.168.88.101:4567
Dec 08 20:28:36 whn2104 mariadbd¹⁶⁰⁵³: 2023-12-08 20:28:36 0 [Note] WSREP: (df960db3-adea, 'tcp://0.0.0.0:4567') connection to peer db265544-ad31 with addr tcp://192.168.88.102:4567 timed out, no messages seen in PT3S, socket stats: rtt: 883 rttvar: 816 rto: 201000 lost: 0 last_data_recv: 16736 cwnd: 10 last_queued_since: 28097 last_delivered_since: 19894572169 send_queue_length: 2 send_queue_bytes: 868 segment: 0 messages: 2
Dec 08 20:28:36 whn2104 mariadbd¹⁶⁰⁵³: 2023-12-08 20:28:36 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: tcp://192.168.88.102:4567
Dec 08 20:28:36 whn2104 mariadbd¹⁶⁰⁵³: 2023-12-08 20:28:36 0 [Note] WSREP: (df960db3-adea, 'tcp://0.0.0.0:4567') connection to peer cbeec19f-81dd with addr tcp://192.168.88.105:4567 timed out, no messages seen in PT3S, socket stats: rtt: 912 rttvar: 1029 rto: 201000 lost: 0 last_data_recv: 16737 cwnd: 5 last_queued_since: 27219 last_delivered_since: 19894809898 send_queue_length: 3 send_queue_bytes: 1080 segment: 0 messages: 3
Dec 08 20:28:36 whn2104 mariadbd¹⁶⁰⁵³: 2023-12-08 20:28:36 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: tcp://192.168.88.105:4567
Dec 08 20:28:36 whn2104 mariadbd¹⁶⁰⁵³: 2023-12-08 20:28:36 0 [Note] WSREP: (df960db3-adea, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.88.101:4567 tcp://192.168.88.102:4567 tcp://192.168.88.103:4567 tcp://192.168.88.105:4567

================

2105:
---
Dec 08 20:28:20 whn2105 mariadbd²¹⁸⁹⁶: 2023-12-08 20:28:20 0 [Note] WSREP: (cbeec19f-81dd, 'tcp://0.0.0.0:4567') connection to peer df960db3-adea with addr tcp://192.168.88.104:4567 timed out, no messages seen in PT3S, socket stats: rtt: 1390 rttvar: 2411 rto: 202000 lost: 0 last_data_recv: 3158 cwnd: 3 last_queued_since: 31307 last_delivered_since: 3158075942 send_queue_length: 1 send_queue_bytes: 656 segment: 0 messages: 1
Dec 08 20:28:20 whn2105 mariadbd²¹⁸⁹⁶: 2023-12-08 20:28:20 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: tcp://192.168.88.104:37518
Dec 08 20:28:20 whn2105 mariadbd²¹⁸⁹⁶: 2023-12-08 20:28:20 0 [Note] WSREP: (cbeec19f-81dd, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.88.104:4567
Dec 08 20:28:20 whn2105 mariadbd²¹⁸⁹⁶: 2023-12-08 20:28:20 0 [Note] WSREP: Deferred close timer handle_wait Operation aborted. for 0x7f033826a948
Dec 08 20:28:20 whn2105 mariadbd²¹⁸⁹⁶: 2023-12-08 20:28:20 0 [Note] WSREP: Deferred close timer destruct
Dec 08 20:28:21 whn2105 mariadbd²¹⁸⁹⁶: 2023-12-08 20:28:21 0 [Note] WSREP: (cbeec19f-81dd, 'tcp://0.0.0.0:4567') reconnecting to df960db3-adea (tcp://192.168.88.104:4567), attempt 0
Dec 08 20:28:22 whn2105 mariadbd²¹⁸⁹⁶: 2023-12-08 20:28:22 0 [Note] WSREP: evs::proto(cbeec19f-81dd, GATHER, view_id(REG,8d14fc33-bb81,3505)) suspecting node: df960db3-adea
Dec 08 20:28:22 whn2105 mariadbd²¹⁸⁹⁶: 2023-12-08 20:28:22 0 [Note] WSREP: evs::proto(cbeec19f-81dd, GATHER, view_id(REG,8d14fc33-bb81,3505)) suspected node without join message, declaring inactive

================

- sepertinya 2104 ada problem, mungkin di network.
- masih melakukan analisa lebih lanjut