故障报告

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   作者:阿力