Mashery Local Slave not syncing with Master with error: “Slave failed to initialize relay log info structure from the repository’” 

 python /opt/mashery/utilities/debug_util.py 

Select from the following: 

1: Collect Logs 

2: Test connectivity for Cloud Sync 

3: Show Slave status 

4: Check IP address 

5: Update record of Master IP address in Master node (Master IP address has changed and registration of new Slave with cluster fails) 

6: Fix Slave corruption (Restart Slave at last valid read position) 

7: Update record of Master IP address in old Slave node ( Master IP address has changed and cluster is not updated ) 

8: System manager (Remove non-functional or unused Slaves from Master) 

9: Collect system state (Disk health, process health, time setting, network settings) 

menu: Show this menu 

exit: Quit 

Select: 3 

{'results': {'Replicate_Wild_Do_Table': '', 'Retrieved_Gtid_Set': '', 'Master_TLS_Version': '', 'Master_SSL_CA_Path': '', 'Last_Error': 'Slave failed to initialize relay log info structure from the repository', 'Until_Log_File': '', 'SQL_Delay': 0L, 'Seconds_Behind_Master': None, 'Master_User': 'mashonpremrepl', 'Master_Port': 3306L, 'Master_Retry_Count': 86400L, 'Until_Log_Pos': 0L, 'Replicate_Rewrite_DB': '', 'Master_Log_File': 'mysql-bin.000005', 'Read_Master_Log_Pos': 464098477L, 'Replicate_Do_DB': '', 'Master_SSL_Verify_Server_Cert': 'No', 'Exec_Master_Log_Pos': 464098477L, 'Replicate_Ignore_Server_Ids': '', 'Replicate_Ignore_Table': '', 'Master_Server_Id': 0L, 'Relay_Log_Space': 0L, 'Last_SQL_Error': 'Slave failed to initialize relay log info structure from the repository', 'SQL_Remaining_Delay': None, 'Relay_Master_Log_File': 'mysql-bin.000005', 'Master_SSL_Allowed': 'No', 'Master_SSL_CA_File': '', 'Slave_IO_State': '', 'Last_SQL_Error_Timestamp': '180622 14:54:43', 'Relay_Log_File': 'localhost-relay-bin.000010', 'Replicate_Ignore_DB': '', 'Last_IO_Error': '', 'Channel_Name': '', 'Until_Condition': 'None', 'Slave_SQL_Running_State': '', 'Replicate_Do_Table': '', 'Last_Errno': 1872L, 'Master_Host': '11.48.44.216', 'Master_Info_File': '/mnt/mysql/master.info', 'Master_SSL_Key': '', 'Executed_Gtid_Set': '', 'Master_Bind': '', 'Skip_Counter': 0L, 'Slave_SQL_Running': 'No', 'Relay_Log_Pos': 333574L, 'Master_SSL_Cert': '', 'Last_IO_Errno': 0L, 'Slave_IO_Running': 'No', 'Connect_Retry': 60L, 'Last_SQL_Errno': 1872L, 'Last_IO_Error_Timestamp': '', 'Replicate_Wild_Ignore_Table': '', 'Master_UUID': 'c1de4794-6a70-11e8-b1e4-0050569b9376', 'Auto_Position': 0L, 'Master_SSL_Crl': '', 'Master_SSL_Cipher': '', 'Master_SSL_Crlpath': ''}, 'error': None} 

1. restart mysqld with command 'service mysqld restart'
2. python /opt/mashery/utilities/debug_util.py
3. Fix slave corruption (Restart slave at last valid read position)
4. Start Slave:

----------------------------------------

step 1: login to linux console of slave;

step 2: login to mysql console of slave (mysql -u ... -p onprem)

step 3: start slave

----------------------------------------------

1. If Slave does not start and “Show Slave Status” in Python Util still have same error 'Last_SQL_Error': 'Slave failed to initialize relay log info structure from the repository', Try following steps: 
2. Login to My sql DB of ML :mysql -u masheryonprem -p
   Enter password: ( password can be retrieved from cat /etc/mashery-proxy-config.json), use onprem DB.

use onprem 

reset slave;

start slave IO_THREAD;

stop slave IO_THREAD;

reset slave;

start slave;

Check Show Slave Status again to verify Slave status. It should not show error.