Description:
error.log:
2021-11-01T16:51:58.759982+08:00 0 [ERROR] Read semi-sync reply magic number error
2021-11-01T16:51:58.759988+08:00 0 [ERROR] /data/mysqlbase/mysql3306/bin/mysqld: Got packets out of order
2021-11-01T16:51:58.759993+08:00 0 [ERROR] /data/mysqlbase/mysql3306/bin/mysqld: Got packets out of order
2021-11-01T16:51:58.759998+08:00 0 [ERROR] /data/mysqlbase/mysql3306/bin/mysqld: Got packets out of order
2021-11-01T16:51:58.760011+08:00 0 [ERROR] /data/mysqlbase/mysql3306/bin/mysqld: Got packets out of order
2021-11-01T16:54:25.245784+08:00 0 [ERROR] /data/mysqlbase/mysql3306/bin/mysqld: Got timeout reading communication packets
2021-11-01T16:54:25.278458+08:00 0 [ERROR] /data/mysqlbase/mysql3306/bin/mysqld: Got packets out of order
2021-11-01T16:54:25.278476+08:00 0 [ERROR] /data/mysqlbase/mysql3306/bin/mysqld: Got packets out of order
2021-11-01T16:54:25.278482+08:00 0 [ERROR] /data/mysqlbase/mysql3306/bin/mysqld: Got packets out of order
Current parameter value：
mysql> SHOW VARIABLES LIKE '%max_allowed_packet%';
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| max_allowed_packet | 1073741824 |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+
2 rows in set (0.00 sec)
mysql> show variables like "%slave_compressed_protocol%";
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| slave_compressed_protocol | OFF |
+---------------------------+-------+
1 row in set (0.00 sec)
mysql> select version();
+------------+
| version() |
+------------+
| 5.7.32-log |
+------------+
1 row in set (0.00 sec)
1.max_allowed_packet has been set to the maximum value, but it is not resolved.
2.According to the error information: [ERROR] Read semi-sync reply magic number error, find the solution to the same error: there is a conflict between semi-sync reply and slave_compressed_protocol running at the same time before MySQL 5.7.21, but the current version is 5.7.32 and slave_compressed_protocol is not opened
How to repeat:
don't know
Suggested fix:
ACK packet
