• Sujatha's avatar
    MDEV-20188: binlog.binlog_stm_drop_tmp_tbl fails in buildbot with Unknown table on exec · 4a9fb905
    Sujatha authored
    Analysis:
    ========
    As part of BUG#28642318 fix, two new test cases were added. The first test
    case tests a scenario where two sessions are present, in which the first
    session has a regular table named 't1' and another session has a temporary
    table named 't1'. Test executes a DELETE statement on regular table. These
    statements are captured from binary log and replayed back on new client
    connection to prove that DELETE statement is applied successfully. Note that
    the binlog contains only CREATE TEMPORARY TABLE part hence a temporary table
    gets created in new connection. This replaying logic is implemented by using
    '--exec $MYSQL' command. If the new connection gets disconnected within the
    scope of first test case the test passes, i.e the temporary table gets dropped
    as part thread cleanup. But on slow platforms the connection gets closed at
    the time of execution of test case 2. When the temporary table is dropped as
    part thread cleanup a "DROP TEMPORARY TABLE t1" is written into the binary
    log. In test case two the same sessions continue to exist and and table names
    are reused to test a new bug scenario. The additional "DROP TEMPORARY TABLE"
    command drops second test specific tables which results in "Unknown table"
    error.
    
    Fix:
    ====
    Rename the second case specific table to 't2'. Even if the close connection
    from test case one happens later the drop command with has
    'DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t1`' will not result in an error.
    4a9fb905
binlog_row_drop_tmp_tbl.result 2.82 KB