Skip to Main Content
Forums

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replication slave connection failing

3720642Aug 22 2018 — edited Aug 23 2018

I'm starting to suspect this is some sort of bug. Every time I stop a slave and then restart it, it fails to connect with the master, with this error message showing:

error connecting to master replica@belem.cidades.gov.br:3306 - retry-time: 60  retries: 2

To notice, I can connect to the mysql server using the replication user, with the mysql command, from the slave host. After I do this, the slave connects. What exactly is going on that this kind of thing happens? Is it really a bug or some sort of feature that's not working properly?

Comments

What is appearing in the logs of both servers in regards to the connection failure?

3720642

As shown on syslog:

[ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'replica@belem.cidades.gov.br:3306 - retry-time: 60  retries: 1040, Error_code: MY-001129

The last error code given, after a stop slave and some changes to the master (file and log_pos), was Error_code: MY-002061, the rest of the line was the same.

Again, I have no idea what these errors actually are, nor why they went away as soon as I connected manually to the mysql console with the replication user.

1 - 2

Post Details

Added on Aug 22 2018
#mysql
2 comments
1,306 views