mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
1c48950e1f
After closing https://github.com/codership/galera-bugs/issues/947, Galera now correctly certifies table-level keys, which made bulk insert work again. The corresponding MTR test is made deterministic and re-enabled. Requires Galera 26.4.19 Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
47 lines
1.4 KiB
Text
47 lines
1.4 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connection node_1;
|
|
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
|
|
SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
|
|
connection node_1;
|
|
SET foreign_key_checks = 0;
|
|
SET unique_checks = 0;
|
|
START TRANSACTION;
|
|
connection node_2;
|
|
SET foreign_key_checks = 1;
|
|
SET unique_checks = 1;
|
|
INSERT INTO t1 VALUES (1001);
|
|
connection node_1;
|
|
SET DEBUG_SYNC = 'wsrep_before_certification WAIT_FOR sync.wsrep_apply_cb_reached';
|
|
SET DEBUG_SYNC = 'wsrep_after_certification SIGNAL signal.wsrep_apply_cb';
|
|
COMMIT;
|
|
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
|
|
DROP TABLE t1;
|
|
SET GLOBAL DEBUG_DBUG = '';
|
|
SET DEBUG_SYNC = 'RESET';
|
|
connection node_1;
|
|
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
|
|
connection node_2;
|
|
SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_apply_cb';
|
|
connection node_1;
|
|
SET foreign_key_checks = 0;
|
|
SET unique_checks = 0;
|
|
START TRANSACTION;
|
|
connection node_2;
|
|
SET foreign_key_checks = 1;
|
|
SET unique_checks = 1;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES (1001);
|
|
connection node_1;
|
|
COMMIT;
|
|
3
|
|
connection node_2;
|
|
SET DEBUG_SYNC = 'wsrep_before_certification WAIT_FOR sync.wsrep_apply_cb_reached';
|
|
SET DEBUG_SYNC = 'wsrep_after_certification SIGNAL signal.wsrep_apply_cb';
|
|
COMMIT;
|
|
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
|
|
DROP TABLE t1;
|
|
SET GLOBAL DEBUG_DBUG = '';
|
|
SET DEBUG_SYNC = 'RESET';
|
|
disconnect node_2;
|
|
disconnect node_1;
|