• 's avatar
    Bug#56118 STOP SLAVE does not wait till trx with CREATE TMP TABLE ends, · 131e3e38
    authored
              replication aborts
    
    When recieving a 'SLAVE STOP' command, slave SQL thread will roll back the
    transaction and stop immidiately if there is only transactional table updated,
    even through 'CREATE|DROP TEMPOARY TABLE' statement are in it. But These
    statements can never be rolled back. Because the temporary tables to the user
    session mapping remain until 'RESET SLAVE', Therefore it will abort SQL thread
    with an error that the table already exists or doesn't exist, when it restarts
    and executes the whole transaction again.
    
    After this patch, SQL thread always waits till the transaction ends and then stops,
    if 'CREATE|DROP TEMPOARY TABLE' statement are in it.
    131e3e38
rpl_stop_slave.test 1.32 KB