故障报告
1. 问题(故障)描述
错误描述:
[ERR] remote read log faild, ZCBUS-20050: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.002788' at 468023199, the last event read from '/teledb3388/p1/app/teledb/data1/teledb_654953418816750592/mysql_data8801/binlog/mysql-bin.002788' at 469098037, the last byte read from '/teledb3388/p1/app/teledb/data1/teledb_654953418816750592/mysql_data8801/binlog/mysql-bin.002788' at 469098037.
error at file[mysql/binlog.c] line[1206], ZCBUS-20050: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.002788' at 468023199, the last event read from '/teledb3388/p1/app/teledb/data1/teledb_654953418816750592/mysql_data8801/binlog/mysql-bin.002788' at 469098037, the last byte read from '/teledb3388/p1/app/teledb/data1/teledb_654953418816750592/mysql_data8801/binlog/mysql-bin.002788' at 469098037.
error at file[mysql/binlog.c] line[1678], ZCBUS-20050: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.002788' at 468023199, the last event read from '/teledb3388/p1/app/teledb/data1/teledb_654953418816750592/mysql_data8801/binlog/mysql-bin.002788' at 469098037, the last byte read from '/teledb3388/p1/app/teledb/data1/teledb_654953418816750592/mysql_data8801/binlog/mysql-bin.002788' at 469098037.
2. 问题(故障)原因
slave_server_id配置错误,默认为nodeid
3. 解决
发布参数中指定一个单独的数字id即可
4. 参考
文档更新时间: 2023-08-01 16:28 作者:阿力