mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-02-05 13:22:17 +01:00
Code Issues Projects Releases Packages Wiki Activity Actions
mariadb/mysql-test/suite/galera_sr/r/mysql-wsrep-features#165.result
tommijkl 00a81516b0 MDEV-28953 sporadic failures with galera_sr.mysql-wsrep-features#165 
Modified galera_sr.mysql-wsrep-features#165 test to be deterministic:
Added one wait condition to catch execution state after --send command.
Changed another wait condition to better match the execution state of the test thread.

Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
2023-12-21 21:06:28 +01:00

1061 lines
21 KiB
Text
Raw Permalink Blame History

connection node_2;
connection node_1;
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 VARCHAR(1)) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1, 'x'), (2, 'x'), (4, 'x'), (5, 'x');
connection node_1a;
START TRANSACTION;
UPDATE t1 SET f2 = 'a' WHERE f1 = 1;
UPDATE t1 SET f2 = 'a' WHERE f1 = 4;
UPDATE t1 SET f2 = 'a' WHERE f1 = 5;
connection node_1b;
START TRANSACTION;
SET SESSION wsrep_trx_fragment_size = 1;
INSERT INTO t1 VALUES (3, 'b');
UPDATE t1 SET f2 = 'b' WHERE f1 = 2;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1c;
SET AUTOCOMMIT=ON;
INSERT INTO t1 VALUES (3, 'c');
connection node_1;
connection node_2;
SELECT * FROM t1;
f1 f2
1 x
2 x
4 x
5 x
connection node_1a;
UPDATE t1 SET f2 = 'a' WHERE f1 = 2;
connection node_1;
connection node_1b;
SET DEBUG_SYNC = 'wsrep_before_SR_rollback SIGNAL wait WAIT_FOR continue';
UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
connection node_1;
SET DEBUG_SYNC = 'now WAIT_FOR wait';
connection node_1;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_1c;
UPDATE t1 SET f2 = 'x' WHERE f1 = 3;
connection node_1a;
COMMIT;
connection node_1b;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection node_1;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_2;
SELECT * FROM t1;
f1 f2
1 a
2 a
3 x
4 a
5 a
connection node_1;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
Reference in a new issue View git blame Copy permalink