set global default_storage_engine=aria; set session default_storage_engine=aria; drop table if exists t1; SET SQL_WARNINGS=1; RESET MASTER; set binlog_format=statement; CREATE TABLE t1 (a int primary key); insert t1 values (1),(2),(3); insert t1 values (4),(2),(5); ERROR 23000: Duplicate entry '2' for key 'PRIMARY' show warnings; Level Code Message Error 1062 Duplicate entry '2' for key 'PRIMARY' Note 4173 Engine Aria does not support rollback. Changes were committed during rollback call Warning 1196 Some non-transactional changed tables couldn't be rolled back select * from t1; a 1 2 3 4 SHOW BINLOG EVENTS FROM ; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid_list 1 # [] master-bin.000001 # Binlog_checkpoint 1 # master-bin.000001 master-bin.000001 # Gtid 1 # GTID 0-1-1 master-bin.000001 # Query 1 # use `test`; CREATE TABLE t1 (a int primary key) master-bin.000001 # Gtid 1 # BEGIN GTID 0-1-2 master-bin.000001 # Query 1 # use `test`; insert t1 values (1),(2),(3) master-bin.000001 # Query 1 # COMMIT master-bin.000001 # Gtid 1 # BEGIN GTID 0-1-3 master-bin.000001 # Query 1 # use `test`; insert t1 values (4),(2),(5) master-bin.000001 # Query 1 # COMMIT drop table t1; set binlog_format=default;