Description

This article provides a work-around for correcting the error condition.

Symptoms

Mysql database is showing "out of sync" on standby node with below error

# mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') -e "show slave status\G show master status\G"

Slave_IO_Running: Connecting 
Slave_SQL_Running: Yes 
Last_IO_Errno: 1045 
Last_IO_Error: error connecting to master '[email protected]:3306' - retry-time: 10 retries: 1

Solution

#Root Cause analysis

Standby JunosSpace node was unable connect to primary node because of mysql.repUser and mysql.repAdmin password mismatch under /etc/sysconfig/JunosSpace/pwd file

 

#Workaround

Step 1: Password needs to be validated under /etc/sysconfig/JunosSpace/pwd file on both Space database nodes by running below command

# cat /etc/sysconfig/JunosSpace/pwd

Step 2: Make sure password under pwd file ( for mysql.repUser and mysql.repAdmin user)  matches on both nodes and if not then take a backup of pwd file and rectify it by comparing the primary database node.

 

Step 3: Once password matches, then follow manual mysql reset replication procedure KB86528  [juniper.net]one more time to synchronise mysql database out of sync issue.

 

Note : If you face any issues, please contact JUNIPER JTAC Support for assistance.

 

 

Modification History

2024-09-23 : Article Created