MySQL8.0.25 centos7.8 x86-64
增強半同步異常io程式不能啟動
2022-10-12T19:19:50.075245+08:00 111 [System] [MY-010562] [Repl] Slave I/O thread for channel ‘’: connected to master ‘repl@idc-mysql-113-40:3306’,replication started in log ‘idc-mysql-113-40.000849’ at position 196
2022-10-12T19:19:53.601304+08:00 111 [ERROR] [MY-011178] [Repl] Missing magic number for semi-sync packet, packet len: 46.
2022-10-12T19:19:53.601334+08:00 111 [ERROR] [MY-010207] [Repl] Run function ‘after_read_event’ in plugin ‘rpl_semi_sync_slave’ failed
2022-10-12T19:19:53.601346+08:00 111 [ERROR] [MY-013117] [Repl] Slave I/O for channel ‘’: Fatal error: Failed to run ‘after_read_event’ hook, Error_code: MY-013117
2022-10-12T19:19:53.601354+08:00 111 [Note] [MY-010570] [Repl] Slave I/O thread exiting for channel ‘’, read up to log ‘idc-mysql-113-40.000849’, position 196
2022-10-12T19:19:54.338315+08:00 112 [Note] [MY-011179] [Repl] Slave I/O thread: Start semi-sync replication to master ‘repl@idc-mysql-113-40:3306’ in log ‘idc-mysql-113-40.000849’ at position 196.
2022-10-12T19:19:54.338388+08:00 112 [Warning] [MY-010897] [Repl] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the ‘START SLAVE Syntax’ in the MySQL Manual for more information.
2022-10-12T19:19:54.339678+08:00 112 [System] [MY-010562] [Repl] Slave I/O thread for channel ‘’: connected to master ‘repl@idc-mysql-113-40:3306’,replication started in log ‘idc-mysql-113-40.000849’ at position 196
2022-10-12T19:19:57.916802+08:00 112 [ERROR] [MY-011178] [Repl] Missing magic number for semi-sync packet, packet len: 46.
2022-10-12T19:19:57.916834+08:00 112 [ERROR] [MY-010207] [Repl] Run function ‘after_read_event’ in plugin ‘rpl_semi_sync_slave’ failed
2022-10-12T19:19:57.916845+08:00 112 [ERROR] [MY-013117] [Repl] Slave I/O for channel ‘’: Fatal error: Failed to run ‘after_read_event’ hook, Error_code: MY-013117
2022-10-12T19:19:57.916856+08:00 112 [Note] [MY-010570] [Repl] Slave I/O thread exiting for channel ‘’, read up to log ‘idc-mysql-113-40.000849’, position 196
本作品採用《CC 協議》，轉載必須註明作者和本文連結