AnsweredAssumed Answered

Upgrade CA API Gateway 9.3

Question asked by Arun.Alampalli on Feb 2, 2018
Latest reply on Feb 2, 2018 by Arun.Alampalli

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).

Outcomes