Hi,
I had upgraded my gateway from 9.2 to 9.3.
But i found replication issue after upgrade.
Please find below status:
Master_UUID: 1686f92c-073d-11e8-8782-0050568ddd82
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Please find below steps, I had executed and let me know if you know any solution.
1. [root@host ~]# mysqladmin stop-slave
2. [root@host ~]# mysql -e "reset master"
3.[root@host ~]# mysql -e "reset slave; reset slave all"
4. /opt/SecureSpan/Appliance/bin/create_slave.sh
From my SQL Log:
While initializing dump thread for slave with UUID <1686f92c-073d-11e8-8782-0050568ddd82>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(32).