Recently I have a replication node that has errored. I noticed something that I think is impossible, but want to confirm:
The coordinates in the show slave status command seems impossible. Please note both IO and SQL threads are pointing to the same binary log file bin-1.084438. And yet the SQL thread coordinate is higher than the IO thread.
The exec_master_log_pos is a higher number than read_master_log_pos within the same binary log file. I would think that exec_master_log_pos can never be a higher number when in the same binary log file and at most can be the same number. Unless my logic is wrong it would seem at some point things got really messed up here and the sql thread somehow jumped ahead.
Any thoughts/comments would be appreciated. Perhaps my understanding of binary log position is not correct?