• Nisha Gopalakrishnan's avatar
    BUG#28642318: POINT IN TIME RECOVERY USING MYSQLBINLOG BROKEN WITH TEMPORARY TABLE -> ERRORS · 2536c0b1
    Nisha Gopalakrishnan authored
    Analysis
    ========
    Point in time recovery using mysqlbinlog containing queries
    operating on temporary tables results in an error.
    
    While writing the query log event in the binary log, the
    thread id used for execution of DROP TABLE and DELETE commands
    were incorrect. The thread variable 'thread_specific_used'
    is used to determine whether a specific thread id is to used
    while executing the statements i.e using 'SET
    @@session.pseudo_thread_id'. This variable was not set
    correctly for DROP TABLE query and was never set for DELETE
    query. The thread id is important for temporary tables
    since the tables are session specific. DROP TABLE and DELETE
    queries executed using a wrong thread id resulted in errors
    while applying the queries generated by mysqlbinlog utility.
    
    Fix
    ===
    Set the 'thread_specific_used' THD variable for DROP TABLE and
    DELETE queries.
    
    ReviewBoard: 21833
    2536c0b1
drop_temp_table.test 4.78 KB