Sunday, 22 June 2025

A replica with the same server_uuid/server_id as this replica has connected to the source

 Error: 

 Last_IO_Error: Got fatal error 1236 from source when reading data from binary log: 

 'A replica with the same server_uuid/server_id as this replica has connected to the source;

 the first event 'ON.000014' at 277, the last event read from './ON.000014' at 479, the last byte read from 

 './ON.000014' at 479.'


 Solution: 

      - Stop mysql service 

 [root@node02 ~]# systemctl stop mysqld

      - Go to mysql server database directory and take the backup 

 [root@node02 mysql]# pwd

       /var/lib/mysql

  [root@node02 mysql]# mv auto.cnf auto.cnf_bkp

  [root@node02 mysql]#

  - Start mysqld service 

 [root@node02 ~]# systemctl start  mysqld

No comments:

Post a Comment

PRKO-2012 : filesystem object is not supported in Oracle Restart

  Subject :      ACFS  not supported in Oracle Restart on 19c  Error :   [oracle@asm-node01 ~]$ srvctl status filesystem -d /dev/asm/ggdisk-...