MySQL Forums :: Replication :: Error encountered on slave "Waiting to reconnect after a failed master event read"


Advanced Search

Error encountered on slave "Waiting to reconnect after a failed master event read"
Posted by: Murtaza Doctor ()
Date: July 18, 2014 07:35AM

We followed the below steps to configure replication on slave server:
--------------
Master server: 192.168.21.53:3308
Slave server: 10.103.102.133:3310

1) Modified my.cnf file of slave to include:
server-id=3
read_only

2) Created replication user on 192.168.21.53:
create user drslave identified by '#######';

4) Grant replication privilege to this user on master
grant replication slave on *.* to 'drslave'@'10.103.102.133' identified by '######';
flush privileges;

5) On slave executed
stop slave;
CHANGE MASTER TO MASTER_HOST='192.168.21.53',MASTER_USER='drslave',MASTER_PASSWORD='######',MASTER_PORT=3308,MASTER_LOG_FILE='hdiits_master.000614',MASTER_LOG_POS=107;
start slave;

-------------

Following error is encountered on the slave server:
-------------
140717 15:49:14 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'hdiits_master.000614' at postion 107
140717 15:49:14 [ERROR] Error reading packet from server: Access denied; you need (at least one of) the REPLICATION SLAVE privilege(s) for this operation ( server_errno=1227)

Output of "show slave status" command:
-------------
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting to reconnect after a failed master event read
Master_Host: 192.168.21.53
Master_User: drslave
Master_Port: 3308
Connect_Retry: 60
Master_Log_File: hdiits_master.000614
Read_Master_Log_Pos: 107
Relay_Log_File: mysql-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: hdiits_master.000614
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: 107
Relay_Log_Space: 107
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: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)

------------

We have verified that we are able to connect to the master server from slave node using "drslave" user.
We are able to ping master from slave and vice-versa using their hostnames.
Also following works from slave:
----
telnet <<master hostname>> <<master mysql port>>
------

Please suggest steps to resolve this error.

Thanks,
Murtaza.

Options: ReplyQuote


Subject Views Written By Posted
Error encountered on slave "Waiting to reconnect after a failed master event read" 2356 Murtaza Doctor 07/18/2014 07:35AM
Re: Error encountered on slave "Waiting to reconnect after a failed master event read" 986 Rick James 07/20/2014 08:52AM
Re: Error encountered on slave "Waiting to reconnect after a failed master event read" 827 Murtaza Doctor 07/20/2014 11:44PM
Re: Error encountered on slave "Waiting to reconnect after a failed master event read" 978 Murtaza Doctor 07/24/2014 11:09PM


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.