数据库出现13314

⭐⭐⭐出现13114错误⭐⭐⭐
Last_IO_Errno: 13114
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not open log file’
恢复主库binlog文件信息
⭐⭐⭐出现13117错误⭐⭐⭐
Last_IO_Errno: 13117
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids;
these ids must be different for replication to work (or the –replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
Last_IO_Errno: 13117
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs;
these UUIDs must be different for replication to work.
###解决办法:uuid重复了
把从数据库删除uuid \rm -f auto.cnf
重新启动一下数据库 会自动生成新的uuid文件

[root@db02:~]# vim /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/data/3306/data
socket=/tmp/mysql.sock
server_id=52


数据库出现13314
http://example.com/2026/01/17/数据库出现13314/
作者
发布于
2026年1月17日
许可协议