2024-05-20 12:26:47 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command 2024-05-20 12:26:47 [INFO] Dumping current MySQL Servers structures for hostgroup ALL HID: 101 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: SHUNNED , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 101 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: SHUNNED , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 101 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 103 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 103 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 102 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 102 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 102 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 2024-05-20 12:26:47 [INFO] Dumping mysql_servers: ALL +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | 101 | node002 | 3301 | 0 | 1000 | 1 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271712 | | 102 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705272352 | | 102 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272192 | | 102 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272032 | | 103 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271872 | | 103 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705271392 | | 101 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272672 | | 101 | node003 | 3301 | 0 | 999 | 1 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272512 | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ 2024-05-20 12:26:47 [INFO] Dumping mysql_servers_incoming +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ | 101 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | | 103 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | | 103 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | | 102 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | | 102 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | | 102 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | | 101 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | | 101 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ 2024-05-20 12:26:47 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming +-------------+--------------+----------+------+ | mem_pointer | hostgroup_id | hostname | port | +-------------+--------------+----------+------+ +-------------+--------------+----------+------+ 2024-05-20 12:26:47 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ | 101 | node002 | 3301 | 0 | 1000 | 1 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271712 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | | 101 | node003 | 3301 | 0 | 999 | 1 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272512 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ 2024-05-20 12:26:47 [INFO] Changing status for server 101:node002:3301 (node002:3301) from 1 (1) to 0 2024-05-20 12:26:47 [INFO] Changing status for server 101:node003:3301 (node003:3301) from 1 (1) to 0 2024-05-20 12:26:47 [INFO] New mysql_replication_hostgroups table 2024-05-20 12:26:47 [INFO] New mysql_group_replication_hostgroups table 2024-05-20 12:26:47 [INFO] New mysql_galera_hostgroups table 2024-05-20 12:26:47 [INFO] Loading Galera info for (101,103,102,199,on,1,1,0,"release-2631_hostgroups") 2024-05-20 12:26:47 [INFO] New mysql_aws_aurora_hostgroups table 2024-05-20 12:26:47 [INFO] Dumping current MySQL Servers structures for hostgroup ALL HID: 101 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 101 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 101 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 103 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 103 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 102 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 102 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 102 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 2024-05-20 12:26:47 [INFO] Dumping mysql_servers: ALL +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | 101 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271712 | | 102 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705272352 | | 102 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272192 | | 102 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272032 | | 103 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271872 | | 103 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705271392 | | 101 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272672 | | 101 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272512 | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ 2024-05-20 12:26:47 [INFO] Checksum for table mysql_servers is 17672624197412064041 2024-05-20 12:26:47 [INFO] Checksum for table mysql_galera_hostgroups is 4834423415408873146 2024-05-20 12:26:47 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms 2024-05-20 12:26:47 [INFO] Dumping current MySQL Servers structures for hostgroup ALL HID: 101 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 101 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 101 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 103 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 103 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 102 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 102 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 102 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 2024-05-20 12:26:47 [INFO] Dumping mysql_servers: ALL +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | 101 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271712 | | 102 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705272352 | | 102 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272192 | | 102 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272032 | | 103 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271872 | | 103 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705271392 | | 101 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272672 | | 101 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272512 | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ 2024-05-20 12:26:48 MySQL_HostGroups_Manager.cpp:5548:update_galera_set_writer(): [WARNING] Galera: too many writers in HG 101. Max=1, current=3 2024-05-20 12:26:48 MySQL_HostGroups_Manager.cpp:5643:update_galera_set_writer(): [WARNING] Galera: setting host node001:3301 as writer 2024-05-20 12:26:48 [INFO] Galera: Node status changed by ProxySQL, dumping all galera nodes status: +-----------------------------------------------------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+ | hostname | port | start_time | check_time | primary_partition | read_only | wsrep_local_recv_queue | wsrep_local_state | wsrep_desync | wsrep_reject_queries | wsrep_sst_donor_rejects_queries | pxc_maint_mode | error | +-----------------------------------------------------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+ | node001 | 3301 | 1716208008348193 | 1287 | 1 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | | | node002 | 3301 | 1716208008348350 | 1238 | 1 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | | | node003 | 3301 | 1716208006352627 | 836 | 1 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | | +-----------------------------------------------------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+ 2024-05-20 12:26:48 [INFO] Dumping current MySQL Servers structures for hostgroup ALL HID: 101 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 101 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 101 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 103 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 103 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 102 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 102 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 102 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 2024-05-20 12:26:48 [INFO] Dumping mysql_servers: ALL +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | 101 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271712 | | 102 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705272352 | | 102 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272192 | | 102 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272032 | | 103 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271872 | | 103 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705271392 | | 101 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272672 | | 101 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272512 | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ 2024-05-20 12:26:48 [INFO] Dumping mysql_servers_incoming +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ | 101 | node002 | 3301 | 0 | 1000 | 1 | 0 | 15000 | 0 | 1 | 0 | node002 | | 102 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | | 102 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | | 103 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | | 103 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | | 101 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | | 101 | node003 | 3301 | 0 | 999 | 1 | 0 | 15000 | 0 | 1 | 0 | node003 | | 102 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ 2024-05-20 12:26:48 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming +-------------+--------------+----------+------+ | mem_pointer | hostgroup_id | hostname | port | +-------------+--------------+----------+------+ +-------------+--------------+----------+------+ 2024-05-20 12:26:48 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ | 101 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271712 | 0 | 1000 | 1 | 0 | 15000 | 0 | 1 | 0 | node002 | | 101 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272512 | 0 | 999 | 1 | 0 | 15000 | 0 | 1 | 0 | node003 | +--------------+-----------------------------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+-----------------------------------------------------+ 2024-05-20 12:26:48 [INFO] Changing status for server 101:node002:3301 (node002:3301) from 0 (0) to 1 2024-05-20 12:26:48 [INFO] Changing status for server 101:node003:3301 (node003:3301) from 0 (0) to 1 2024-05-20 12:26:48 [INFO] Dumping current MySQL Servers structures for hostgroup ALL HID: 101 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: SHUNNED , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 101 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: SHUNNED , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 101 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 103 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 103 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 HID: 102 , address: node001 , port: 3301 , gtid_port: 0 , weight: 1001 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node001 HID: 102 , address: node003 , port: 3301 , gtid_port: 0 , weight: 999 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node003 HID: 102 , address: node002 , port: 3301 , gtid_port: 0 , weight: 1000 , status: ONLINE , max_connections: 15000 , max_replication_lag: 0 , use_ssl: 1 , max_latency_ms: 0 , comment: node002 2024-05-20 12:26:48 [INFO] Dumping mysql_servers: ALL +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ | 101 | node002 | 3301 | 0 | 1000 | 1 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271712 | | 102 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705272352 | | 102 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272192 | | 102 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272032 | | 103 | node002 | 3301 | 0 | 1000 | 0 | 0 | 15000 | 0 | 1 | 0 | node002 | 140418705271872 | | 103 | node003 | 3301 | 0 | 999 | 0 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705271392 | | 101 | node001 | 3301 | 0 | 1001 | 0 | 0 | 15000 | 0 | 1 | 0 | node001 | 140418705272672 | | 101 | node003 | 3301 | 0 | 999 | 1 | 0 | 15000 | 0 | 1 | 0 | node003 | 140418705272512 | +-----+-----------------------------------------------------+------+------+--------+--------+-----+-----------+---------+-----+---------+-----------------------------------------------------+-----------------+ 2024-05-20 12:26:48 [INFO] Checksum for table mysql_servers is 17672624197412064041 2024-05-20 12:26:48 [INFO] Checksum for table mysql_galera_hostgroups is 4834423415408873146 2024-05-20 12:26:48 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms 2024-05-20 12:26:48 [INFO] Dumping current MySQL Servers structures for hostgroup 101