mariadb/mysql-test/suite/galera/r/MDEV-33136.result
Marko Mäkelä d68f5ea9f0 MDEV-35000 fixup: galera.MDEV-33136
TRUNCATE TABLE will no longer cause a reload of InnoDB statistics.
RENAME TABLE will.
2025-03-27 08:19:40 +02:00

21 lines
662 B
Text

connection node_2;
connection node_1;
connect node_1a,127.0.0.1,root,,test,$NODE_MYPORT_1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
connection node_1a;
RENAME TABLE t1 TO tmp, tmp TO t1;
SET SESSION wsrep_retry_autocommit = 0;
SET DEBUG_SYNC = 'dict_stats_mdl_acquired SIGNAL may_toi WAIT_FOR bf_abort';
INSERT INTO t1 VALUES (1);
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR may_toi';
TRUNCATE TABLE t1;
connection node_1a;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
disconnect node_1a;
disconnect node_2;
disconnect node_1;