MySQL Forums
Forum List  »  Replication

Exec_Master_Log_Pos Not Updating
Posted by: M F
Date: July 31, 2019 11:09PM

Our DBA left without any backfill aside from me (who is not really a DBA). Yesterday I noticed that the slave has been lagging and up to today, the value of Exec_Master_Log_Post has not been updating at all. Seconds_Behind_Master has been increasing.

Reading articles online, I tried to resolve it by running the script below -

STOP SLAVE;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.001267',MASTER_LOG_POS=305073261;
START SLAVE;

In the online content that I have read, the Master_Log_File and Relay_Master_Log_File are the same. However you can see on my slave status that the master already has a new log file. Is there any other way to resolve this aside from doing a mysqldump?

Thank you all for your help!


*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: <master ip>
Master_User: v_reply
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.001270
Read_Master_Log_Pos: 225827119
Relay_Log_File: V-S36-relay-log.000002
Relay_Log_Pos: 320
Relay_Master_Log_File: mysql-bin.001267
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: 305073261
Relay_Log_Space: 3492173806
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: 72250
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: 35
Master_UUID: 4c067d2f-8c8f-11e7-816c-000d3ae00c4f
Master_Info_File: S:\wamp64\bin\mysql\mysql5.7.14\data\master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Reading event from the relay log
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:

Options: ReplyQuote


Subject
Views
Written By
Posted
Exec_Master_Log_Pos Not Updating
2134
M F
July 31, 2019 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.