• Marko Mäkelä's avatar
    Follow-up to MDEV-13407 innodb.drop_table_background failed in buildbot with... · 8dcacd3b
    Marko Mäkelä authored
    Follow-up to MDEV-13407 innodb.drop_table_background failed in buildbot with "Tablespace for table exists"
    
    This is a backport of commit 88aff5f4.
    
    The InnoDB background DROP TABLE queue is something that we should
    really remove, but are unable to until we remove dict_operation_lock
    so that DDL and DML operations can be combined in a single transaction.
    
    Because the queue is not persistent, it is not crash-safe. We should
    in some way ensure that the deferred-dropped tables will be dropped
    after server restart.
    
    The existence of two separate transactions complicates the error handling
    of CREATE TABLE...SELECT. We should really not break locks in DROP TABLE.
    
    Our solution to these problems is to rename the table to a temporary
    name, and to drop such-named tables on InnoDB startup. Also, the
    queue will use table IDs instead of names from now on.
    
    check-testcase.test: Ignore #sql-ib*.ibd files, because tables may enter
    the background DROP TABLE queue shortly before the test finishes.
    
    innodb.drop_table_background: Test CREATE...SELECT and the creation of
    tables whose file name starts with #sql-ib.
    
    innodb.alter_crash: Adjust the recovery, now that the #sql-ib tables
    will be dropped on InnoDB startup.
    
    row_mysql_drop_garbage_tables(): New function, to drop all #sql-ib tables
    on InnoDB startup.
    
    row_drop_table_for_mysql_in_background(): Remove an unnecessary and
    misplaced call to log_buffer_flush_to_disk(). (The call should have been
    after the transaction commit. We do not care about flushing the redo log
    here, because the table would be dropped again at server startup.)
    
    Remove the entry from the list after the table no longer exists.
    
    If server shutdown has been initiated, empty the list without actually
    dropping any tables. They will be dropped again on startup.
    
    row_drop_table_for_mysql(): Do not call lock_remove_all_on_table().
    Instead, if locks exist, defer the DROP TABLE until they do not exist.
    If the table name does not start with #sql-ib, rename it to that prefix
    before adding it to the background DROP TABLE queue.
    8dcacd3b
drop_table_background.result 1015 Bytes