• Thirunarayanan Balathandayuthapani's avatar
    MDEV-23332 Index online status assert failure in btr_search_drop_page_hash_index · 8a612314
    Thirunarayanan Balathandayuthapani authored
    Problem:
    ========
    In row_merge_drop_indexes(), InnoDB drops only the index from
    dictionary and frees the index pages but it maintains the index
    object if the table is being used by other DML threads. It sets
    the online status of the index to ONLINE_INDEX_ABORTED_DROPPED.
    Removing the index from dictionary doesn't remove the
    corressponding ahi entries of the index. When block is being
    reused, InnoDB tries to remove ahi entries for the block and
    it fails if index online status is ONLINE_INDEX_ABORTED_DROPPED.
    
    Fix:
    ====
    MDEV-22456 allows the index ahi entries to be dropped lazily.
    so checking online status in btr_search_drop_page_hash_index()
    is meaningless and should be removed.
    8a612314
btr0sea.cc 52.6 KB