• Thirunarayanan Balathandayuthapani's avatar
    MDEV-28399 Assertion failure in dict_table_check_for_dup_indexes upon concurrent DML/DDL · fc391df5
    Thirunarayanan Balathandayuthapani authored
    Problem:
    ========
     InnoDB DDL fails to remove the newly added table or index from
    dictionary and index stub from the table cache if the alter
    transaction encounters DEADLOCK error in commit phase.
    
    Solution:
    ========
    Restart the alter table transaction if it encounters DEADLOCK
    in commit phase. So that index stubs and index, table removal from
    dictionary can be done in rollback_inplace_alter_table()
    
    - Added one assert in rollback_inplace_alter_table() to indicate that
    the online log for the old table shouldn't exist.
    fc391df5
innodb-alter-debug.test 4.99 KB