ERROR: Got error reading packet from server: A slave with the same server_uuid/server_id as this sla...

weixin_34208283

于 2019-04-02 22:56:00 发布

阅读量858

点赞数 1

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/lvhanzhi/p/10646041.html

本文介绍在CentOS7.5上配置binlog-server时遇到的一个错误：由于UUID重复导致无法从主库拉取binlog。通过删除auto.cnf文件并重启服务解决了该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

centos7.5 做binlog-server,拉取主库binlog报错

问题:

[root@db03-53 binlog]# mysqlbinlog  -R --host=10.0.0.55 --user=mha --password=mha --raw  --stop-never mysql-bin.000001 &
[5] 31058
[root@db03-53 binlog]# Warning: Using a password on the command line interface can be insecure.
ERROR: Got error reading packet from server: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.000001' at 4, the last event read from './mysql-bin.000001' at 151, the last byte read from './mysql-bin.000001' at 151.

原因:

gtid是由tid+uuid组成的,gtid是唯一的标识符 ,报错里说明了uuid重复

解决方法:

删掉auto.cnf 文件,重启就会自动生成
[root@db01-51 ~]# rm -rf /application/mysql/data/auto.cnf
[root@db01-51 ~]# /etc/init.d/mysqld restart

转载于:https://www.cnblogs.com/lvhanzhi/p/10646041.html