MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d76c0 , MYSQL 0x7f2aac859600 , FD 41 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
[root@localhost data]# mysql -uadmin -padmin -h127.0.0.1 -P6032
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 8.0.12 (ProxySQL Admin Module)
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select hostgroup_id, hostname, port,status from runtime_mysql_servers order by hostgroup_id;
+--------------+-----------------+------+--------+
| hostgroup_id | hostname | port | status |
+--------------+-----------------+------+--------+
| 4 | 192.168.211.129 | 3306 | ONLINE |
| 4 | 192.168.211.133 | 3306 | ONLINE |
| 4 | 192.168.211.134 | 3306 | ONLINE |
+--------------+-----------------+------+--------+
[root@localhost data]# tail -f /data/proxysql/proxysql.log
2024-08-14 00:12:17 MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d76c0 , MYSQL 0x7f2aac859600 , FD 41 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
2024-08-14 00:12:22 MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d7900 , MYSQL 0x7f2aac7ff500 , FD 40 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
2024-08-14 00:12:22 MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d7c00 , MYSQL 0x7f2aac801800 , FD 41 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
2024-08-14 00:12:22 MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d7cc0 , MYSQL 0x7f2aac7ff500 , FD 40 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
2024-08-14 00:12:27 MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d85c0 , MYSQL 0x7f2aac801800 , FD 40 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
2024-08-14 00:12:27 MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d8a40 , MYSQL 0x7f2aac7ff500 , FD 41 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
2024-08-14 00:12:27 MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d8740 , MYSQL 0x7f2ab06f7800 , FD 43 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
2024-08-14 00:12:32 MySQL_Monitor.cpp:1484:monitor_group_replication_thread(): [ERROR] Got error. mmsd 0x7f2ab06d9100 , MYSQL 0x7f2aac7ff500 , FD 40 : Table 'sys.gr_member_routing_candidate_status' doesn't exist
在主库执行以下SQL解决
mysql> source /data/addition_to_sys.sql;