Re: Waiting for master to send event

[graylog learn]

Hi Team,

Thanks for the link,
We have tried before only all the basic checks, however we could not resolve the issue permanently.

From Master END:The below output from master end.

mysql> show master status;
+---------------+-----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+---------------+-----------+--------------+------------------+-------------------+
| binlog.008389 | 450656892 | | | |
+---------------+-----------+--------------+------------------+-------------------+
1 row in set (0.02 sec)

Yes,Server ID is also set in /etc/my.cnf

server_id=1

From Slave END:

Yes,Server ID is also set in /etc/my.cnf

server_id=3 (We have slave also so we defined server_id as 3)

mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: XXXXX
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: binlog.008389
Read_Master_Log_Pos: 404819379
Relay_Log_File: relaylogbin.000187
Relay_Log_Pos: 104394331
Relay_Master_Log_File: binlog.008359
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

mysql> show processlist;
+--------+-------------+-----------+------+---------+--------+----------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-------------+-----------+------+---------+--------+----------------------------------+------------------+
| 404868 | system user | | NULL | Connect | 74674 | Waiting for master to send event | NULL |
| 404869 | system user | | NULL | Connect | 141034 | Reading event from the relay log | NULL |
| 413257 | root | localhost | NULL | Query | 0 | init | show processlist


mysql> show grants for repl_user;
+----------------------------------------------------------------------------------------------------------------------+
| Grants for repl_user@% |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT REPLICATION SLAVE ON *.* TO 'repl_user'@'%' IDENTIFIED BY PASSWORD '*****' |
| GRANT ALL PRIVILEGES ON `db_new`.* TO 'repl_user'@'%' |
+----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec


We tried below using commands


mysql> stop slave;

mysql> reset slave all;




CHANGE MASTER TO MASTER_HOST='XXXX',MASTER_USER='repl_user',MASTER_PASSWORD='repl123', MASTER_LOG_FILE='binlog.008302', MASTER_LOG_POS= 212301479;

start slave;

After executing the above commands its work for 1 hr again issue is occurring.