• Brandon Nesterenko's avatar
    MDEV-16091: Seconds_Behind_Master spikes to millions of seconds · 8b15d0d4
    Brandon Nesterenko authored
    This patch addresses two problems with
    rpl.rpl_seconds_behind_master_spike
    
    First, --sync_slave_with_master / select master_pos_wait
    seems to have a bug where it will hang after all master
    events have been executed.
    
    This patch removes the sync_slave_with_master command from
    the test, where it not required anyway as it is used to
    declare explicit cleanup
    
    Second, the test uses timestamps to ensure that the
    Seconds_Behind_Master value does not point to a time too
    far in the past. The checks of these timestamps were
    too strict, because they could be slightly inconsistent
    with the master and the SBM would be counted as invalid
    when it was actually correct.
    
    To fix this, a slight buffer was added to the check
    to ensure the value is valid but still does not point
    too far in the past
    
    Reviewed By:
    ===========
    Andrei Elkin <andrei.elkin@mariadb.com>
    8b15d0d4
rpl_seconds_behind_master_spike.test 3.11 KB