MySQL Forums
Forum List  »  Replication

error reconnecting to master
Posted by: sok bunthoeun
Date: September 02, 2020 09:49PM

Hello everyone

I have setup and configure MySQL Master-Master Replication on Window server 20212 R2

Currently, I'm facing the issue on the happen on node 2 'Last_IO_Error: error reconnecting to master 'repl@10.8.8.27:1755'

So. I concern data not replicate from node 1 to node 2


If anyone know the issue happened , please help guide me



mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.8.8.27
Master_User: repl
Master_Port: 17555
Connect_Retry: 60
Master_Log_File: mysql-bin.000107
Read_Master_Log_Pos: 939469753
Relay_Log_File: biodr-relay-bin.005248
Relay_Log_Pos: 134318466
Relay_Master_Log_File: mysql-bin.000107
Slave_IO_Running: Yes
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: 939469753
Relay_Log_Space: 134318766
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2003
Last_IO_Error: error reconnecting to master 'repl@10.8.8.27:1755
5' - retry-time: 60 retries: 86400
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)

mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
error reconnecting to master
803
September 02, 2020 09:49PM
260
September 03, 2020 09:49AM
194
September 29, 2020 01:30AM
214
September 29, 2020 10:06AM
187
September 29, 2020 08:15PM
187
September 29, 2020 10:30PM
225
September 30, 2020 02:32AM
211
October 05, 2020 09:27AM


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.