• Luis Soares's avatar
    BUG#47312: RBR: Disabling key on slave breaks replication: · 80f96fae
    Luis Soares authored
    HA_ERR_WRONG_INDEX
          
    In RBR, disabling keys on slave table will break replication when
    updating or deleting a record. When the slave thread tries to
    find the row, by searching in the storage engine, it checks
    whether the table has a key or not. If it has one, then the slave
    thread uses it to search the record.
          
    Nonetheless, the slave only checks whether the key exists or not,
    it does not verify if it is active. Should the key be
    disabled (eg, DBA has issued an ALTER TABLE ... DISABLE KEYS)
    then it will result in error: HA_ERR_WRONG_INDEX.
          
    This patch addresses this issue by making the slave thread also
    check whether the key is active or not before actually using it.
    80f96fae
rpl_row_disabled_slave_key.test 1.5 KB