Debian Codegraph @

mysql-test/suite/galera_3nodes/t/galera_certification_double_failure.test

raw
1 #
2 # This test creates a transaction whose certification will fail on two separate nodes
3 # for two different reasons.
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 --let $galera_connection_name = node_3
10 --let $galera_server_number = 3
11 --source include/galera_connect.inc
12
13 --connection node_1
14 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
15 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
16
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 INSERT INTO t1 VALUES (1);
20 INSERT INTO t2 VALUES (1);
21
22 --connection node_2
23 INSERT INTO t1 VALUES (1);
24
25 --connection node_3
26 INSERT INTO t2 VALUES (1);
27
28 --connection node_1
29 --error ER_LOCK_DEADLOCK
30 COMMIT;
31
32 --connection node_3
33 --source include/galera_wait_ready.inc
34 DROP TABLE t1;
35 DROP TABLE t2;