You had written that server restarts. Upon restart it has to write something to the log about binary/relay log positions. My idea was to check binary log content around that position. This may be problematic because of the following settings:
sync_master_info = 0 sync_relay_log = 0 sync_relay_log_info = 0
So, after crash, both relay log content and information about positions may be not correct.
You had written that server restarts. Upon restart it has to write something to the log about binary/relay log positions. My idea was to check binary log content around that position. This may be problematic because of the following settings:
sync_master_info = 0
sync_relay_log = 0
sync_relay_log_info = 0
So, after crash, both relay log content and information about positions may be not correct.