• Marko Mäkelä's avatar
    MDEV-13039 innodb_fast_shutdown=0 may fail to purge all undo log · 417434f1
    Marko Mäkelä authored
    When a slow shutdown is performed soon after spawning some work for
    background threads that can create or commit transactions, it is possible
    that new transactions are started or committed after the purge has finished.
    This is violating the specification of innodb_fast_shutdown=0, namely that
    the purge must be completed. (None of the history of the recent transactions
    would be purged.)
    
    Also, it is possible that the purge threads would exit in slow shutdown
    while there exist active transactions, such as recovered incomplete
    transactions that are being rolled back. Thus, the slow shutdown could
    fail to purge some undo log that becomes purgeable after the transaction
    commit or rollback.
    
    srv_undo_sources: A flag that indicates if undo log can be generated
    or the persistent, whether by background threads or by user SQL.
    Even when this flag is clear, active transactions that already exist
    in the system may be committed or rolled back.
    
    innodb_shutdown(): Renamed from innobase_shutdown_for_mysql().
    Do not return an error code; the operation never fails.
    Clear the srv_undo_sources flag, and also ensure that the background
    DROP TABLE queue is empty.
    
    srv_purge_should_exit(): Do not allow the purge to exit if
    srv_undo_sources are active or the background DROP TABLE queue is not
    empty, or in slow shutdown, if any active transactions exist
    (and are being rolled back).
    
    srv_purge_coordinator_thread(): Remove some previous workarounds
    for this bug.
    
    innobase_start_or_create_for_mysql(): Set buf_page_cleaner_is_active
    and srv_dict_stats_thread_active directly. Set srv_undo_sources before
    starting the purge subsystem, to prevent immediate shutdown of the purge.
    Create dict_stats_thread and fts_optimize_thread immediately
    after setting srv_undo_sources, so that shutdown can use this flag to
    determine if these subsystems were started.
    
    dict_stats_shutdown(): Shut down dict_stats_thread. Backported from 10.2.
    
    srv_shutdown_table_bg_threads(): Remove (unused).
    417434f1
srv0start.h 5.51 KB