Mysql slave alwayws shows “Slave_IO_Running: Connecting,Last_IO_Errno: 2061”, then change to 1129










0














I am configuring mysql master and slave. I confirm when I ran "change master to" command, the following settings are correct and consistent to the values on master side:



MASTER_HOST
MASTER_USER
MASTER_PASSWORD
MASTER_LOG_FILE
MASTER_LOG_POS


Now, on slave side, it shows as below:



mysql> show slave statusG;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 172.16.0.5
Master_User: repl_1
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000003
Read_Master_Log_Pos: 155
Relay_Log_File: slave-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: master-bin.000003
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB: myslave
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: 155
Relay_Log_Space: 155
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: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 2


On master side:



mysql> show master status;
+-------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------------+----------+--------------+------------------+-------------------+
| master-bin.000003 | 155 | myslave | mysql | |
+-------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)


But slave is always unable to connect master, and reports errors in /var/log/mysql/error.log as below:



2018-11-11T13:51:34.706080Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 1, Error_code: MY-002061
2018-11-11T13:52:34.708404Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 2, Error_code: MY-002061
2018-11-11T13:53:34.710593Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 3, Error_code: MY-002061
2018-11-11T13:54:34.713441Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 4, Error_code: MY-002061
2018-11-11T13:55:34.716135Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 5, Error_code: MY-002061


and, after 99 times retires, error_code changes to MY-001129:



2018-11-11T11:24:02.802629Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 99, Error_code: MY-002061
2018-11-11T11:25:02.804339Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 100, Error_code: MY-001129
2018-11-11T11:26:02.806537Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 101, Error_code: MY-001129


On master side, /var/log/mysql/error.log shows nothing. The tcpdump on master side shows that it(172.16.0.5) has received the login request from slave(172.16.0.4) with user "repl_1". But it replies with an "auth switch request". Then the slave initiated termination of connection with "[FIN, ACK]".
I am pretty sure the password of "repl_1" was the same when I created the user on master, and when I executed "change master to ....MASTER_PASSWORD...".
tcpdump










share|improve this question























  • I know the format of my text is too bad. But I am trying to re-format it but because I am a newcomer I didn't find how to format those content like the output of commands and the logs. I really thanks Samir for formatting it.
    – superwizard
    Nov 11 at 14:36
















0














I am configuring mysql master and slave. I confirm when I ran "change master to" command, the following settings are correct and consistent to the values on master side:



MASTER_HOST
MASTER_USER
MASTER_PASSWORD
MASTER_LOG_FILE
MASTER_LOG_POS


Now, on slave side, it shows as below:



mysql> show slave statusG;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 172.16.0.5
Master_User: repl_1
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000003
Read_Master_Log_Pos: 155
Relay_Log_File: slave-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: master-bin.000003
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB: myslave
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: 155
Relay_Log_Space: 155
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: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 2


On master side:



mysql> show master status;
+-------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------------+----------+--------------+------------------+-------------------+
| master-bin.000003 | 155 | myslave | mysql | |
+-------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)


But slave is always unable to connect master, and reports errors in /var/log/mysql/error.log as below:



2018-11-11T13:51:34.706080Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 1, Error_code: MY-002061
2018-11-11T13:52:34.708404Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 2, Error_code: MY-002061
2018-11-11T13:53:34.710593Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 3, Error_code: MY-002061
2018-11-11T13:54:34.713441Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 4, Error_code: MY-002061
2018-11-11T13:55:34.716135Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 5, Error_code: MY-002061


and, after 99 times retires, error_code changes to MY-001129:



2018-11-11T11:24:02.802629Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 99, Error_code: MY-002061
2018-11-11T11:25:02.804339Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 100, Error_code: MY-001129
2018-11-11T11:26:02.806537Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 101, Error_code: MY-001129


On master side, /var/log/mysql/error.log shows nothing. The tcpdump on master side shows that it(172.16.0.5) has received the login request from slave(172.16.0.4) with user "repl_1". But it replies with an "auth switch request". Then the slave initiated termination of connection with "[FIN, ACK]".
I am pretty sure the password of "repl_1" was the same when I created the user on master, and when I executed "change master to ....MASTER_PASSWORD...".
tcpdump










share|improve this question























  • I know the format of my text is too bad. But I am trying to re-format it but because I am a newcomer I didn't find how to format those content like the output of commands and the logs. I really thanks Samir for formatting it.
    – superwizard
    Nov 11 at 14:36














0












0








0







I am configuring mysql master and slave. I confirm when I ran "change master to" command, the following settings are correct and consistent to the values on master side:



MASTER_HOST
MASTER_USER
MASTER_PASSWORD
MASTER_LOG_FILE
MASTER_LOG_POS


Now, on slave side, it shows as below:



mysql> show slave statusG;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 172.16.0.5
Master_User: repl_1
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000003
Read_Master_Log_Pos: 155
Relay_Log_File: slave-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: master-bin.000003
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB: myslave
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: 155
Relay_Log_Space: 155
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: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 2


On master side:



mysql> show master status;
+-------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------------+----------+--------------+------------------+-------------------+
| master-bin.000003 | 155 | myslave | mysql | |
+-------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)


But slave is always unable to connect master, and reports errors in /var/log/mysql/error.log as below:



2018-11-11T13:51:34.706080Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 1, Error_code: MY-002061
2018-11-11T13:52:34.708404Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 2, Error_code: MY-002061
2018-11-11T13:53:34.710593Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 3, Error_code: MY-002061
2018-11-11T13:54:34.713441Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 4, Error_code: MY-002061
2018-11-11T13:55:34.716135Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 5, Error_code: MY-002061


and, after 99 times retires, error_code changes to MY-001129:



2018-11-11T11:24:02.802629Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 99, Error_code: MY-002061
2018-11-11T11:25:02.804339Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 100, Error_code: MY-001129
2018-11-11T11:26:02.806537Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 101, Error_code: MY-001129


On master side, /var/log/mysql/error.log shows nothing. The tcpdump on master side shows that it(172.16.0.5) has received the login request from slave(172.16.0.4) with user "repl_1". But it replies with an "auth switch request". Then the slave initiated termination of connection with "[FIN, ACK]".
I am pretty sure the password of "repl_1" was the same when I created the user on master, and when I executed "change master to ....MASTER_PASSWORD...".
tcpdump










share|improve this question















I am configuring mysql master and slave. I confirm when I ran "change master to" command, the following settings are correct and consistent to the values on master side:



MASTER_HOST
MASTER_USER
MASTER_PASSWORD
MASTER_LOG_FILE
MASTER_LOG_POS


Now, on slave side, it shows as below:



mysql> show slave statusG;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 172.16.0.5
Master_User: repl_1
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000003
Read_Master_Log_Pos: 155
Relay_Log_File: slave-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: master-bin.000003
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB: myslave
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: 155
Relay_Log_Space: 155
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: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2061
Last_IO_Error: error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 2


On master side:



mysql> show master status;
+-------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------------+----------+--------------+------------------+-------------------+
| master-bin.000003 | 155 | myslave | mysql | |
+-------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)


But slave is always unable to connect master, and reports errors in /var/log/mysql/error.log as below:



2018-11-11T13:51:34.706080Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 1, Error_code: MY-002061
2018-11-11T13:52:34.708404Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 2, Error_code: MY-002061
2018-11-11T13:53:34.710593Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 3, Error_code: MY-002061
2018-11-11T13:54:34.713441Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 4, Error_code: MY-002061
2018-11-11T13:55:34.716135Z 22 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 5, Error_code: MY-002061


and, after 99 times retires, error_code changes to MY-001129:



2018-11-11T11:24:02.802629Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 99, Error_code: MY-002061
2018-11-11T11:25:02.804339Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 100, Error_code: MY-001129
2018-11-11T11:26:02.806537Z 11 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'repl_1@172.16.0.5:3306' - retry-time: 60 retries: 101, Error_code: MY-001129


On master side, /var/log/mysql/error.log shows nothing. The tcpdump on master side shows that it(172.16.0.5) has received the login request from slave(172.16.0.4) with user "repl_1". But it replies with an "auth switch request". Then the slave initiated termination of connection with "[FIN, ACK]".
I am pretty sure the password of "repl_1" was the same when I created the user on master, and when I executed "change master to ....MASTER_PASSWORD...".
tcpdump







mysql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 11 at 14:52

























asked Nov 11 at 14:24









superwizard

12




12











  • I know the format of my text is too bad. But I am trying to re-format it but because I am a newcomer I didn't find how to format those content like the output of commands and the logs. I really thanks Samir for formatting it.
    – superwizard
    Nov 11 at 14:36

















  • I know the format of my text is too bad. But I am trying to re-format it but because I am a newcomer I didn't find how to format those content like the output of commands and the logs. I really thanks Samir for formatting it.
    – superwizard
    Nov 11 at 14:36
















I know the format of my text is too bad. But I am trying to re-format it but because I am a newcomer I didn't find how to format those content like the output of commands and the logs. I really thanks Samir for formatting it.
– superwizard
Nov 11 at 14:36





I know the format of my text is too bad. But I am trying to re-format it but because I am a newcomer I didn't find how to format those content like the output of commands and the logs. I really thanks Samir for formatting it.
– superwizard
Nov 11 at 14:36


















active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53249665%2fmysql-slave-alwayws-shows-slave-io-running-connecting-last-io-errno-2061-th%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53249665%2fmysql-slave-alwayws-shows-slave-io-running-connecting-last-io-errno-2061-th%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Darth Vader #20

How to how show current date and time by default on contact form 7 in WordPress without taking input from user in datetimepicker

Ondo