Forum Stats

  • 3,733,341 Users
  • 2,246,744 Discussions
  • 7,856,662 Comments

Discussions

Replication slave connection failing

3720642
3720642 Member Posts: 10
edited August 2018 in MySQL Community Space

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 [email protected]: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?

Tagged:

Answers

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 350 Employee
    edited August 2018

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

  • 3720642
    3720642 Member Posts: 10
    edited August 2018

    As shown on syslog:

    [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master '[email protected]: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.

Sign In or Register to comment.