• Marko Mäkelä's avatar
    MDEV-22618 Assertion !dict_index_is_online_ddl ... in lock_table_locks_lookup · c93f8aca
    Marko Mäkelä authored
    lock_table_locks_lookup(): Relax the assertion.
    Locks must not exist while online secondary index creation is
    in progress. However, if CREATE UNIQUE INDEX has not been committed
    yet, but the index creation has been completed, concurrent DML
    transactions may acquire record locks on the index. Furthermore,
    such concurrent DML may cause duplicate key violation, causing
    the DDL operation to be rolled back. After that, the online_status
    may be ONLINE_INDEX_ABORTED or ONLINE_INDEX_ABORTED_DROPPED.
    
    So, the debug assertion may only forbid the state ONLINE_INDEX_CREATION.
    c93f8aca
lock0lock.cc 198 KB