MySQL Forums
Forum List  »  Replication

Error 2026 Slave-Master replication
Posted by: Chris Vernon-SMith
Date: December 25, 2016 05:25AM

Hi,

I have been troubleshooting a connection issue between our slave and master servers for the last 24 hours without success. The replication process stopped working earlier in the year when the Centos Server was updated. There error log is showing the following:

161225 10:47:08 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000090', position 1068133866
161225 10:47:08 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000090' at position 1068133866, relay log './mysql-relay-bin.000001' position: 4
161225 10:47:09 [ERROR] Slave I/O: error connecting to master 'slave@xx.xxx.xxx.xxx:3306' - retry-time: 60 retries: 86400, Error_code: 2026

Slave table reads as follows:


Variable Value
Slave_IO_State Connecting to master
Master_Host xx.xxx.xxx.xxx
Master_User slave
Master_Port 3306
Connect_Retry 60
Master_Log_File mysql-bin.000090
Read_Master_Log_Pos 1068133866
Relay_Log_File mysql-relay-bin.000005
Relay_Log_Pos 4
Relay_Master_Log_File mysql-bin.000090
Slave_IO_Running Connecting
Slave_SQL_Running Yes
Replicate_Do_DB
Replicate_Ignore_DB
Replicate_Do_Table
Replicate_Ignore_Table
Replicate_Wild_Do_Table
Replicate_Wild_Ignore_Table
Last_Errno 0
Last_Error
Skip_Counter 0
Exec_Master_Log_Pos 1068133866
Relay_Log_Space 107
Until_Condition None
Until_Log_File
Until_Log_Pos 0
Master_SSL_Allowed Yes
Master_SSL_CA_File /var/www/certs/mysql/ca-mysql.pem
Master_SSL_CA_Path
Master_SSL_Cert /var/www/certs/mysql/mysql-client-cert.pem
Master_SSL_Cipher
Master_SSL_Key /var/www/certs/mysql/mysql-client-key.pem
Seconds_Behind_Master


Initial research suggests an issue with SSL but from the console, I am able to connect from the slave to the master without error:

# mysql --ssl-ca=/var/www/certs/mysql/ca-mysql.pem --ssl-cert=/var/www/certs/mysql/mysql-client-cert.pem --ssl-key=/var/www/certs/mysql/mysql-client-key.pem -u slave -p -h xx.xxx.xxx.xxx --port=3306
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11404398
Server version: 5.5.44-log MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


Is the replication process using the wrong password somehow? I have updated the master_password so it should be correct.

What are the next troubleshooting steps to try?

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 2026 Slave-Master replication
7489
December 25, 2016 05:25AM
2197
February 16, 2017 01:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.