Debian Codegraph @

mysql-test/suite/galera_sr/t/mysql-wsrep-features#32.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # mysql-wsrep-features#32 Assertion `meta->gtid.seqno == wsrep_thd_trx_seqno(thd)' failed in wsrep_commit_cb with SR
6 #
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
10
11 SET SESSION wsrep_trx_fragment_size = 1;
12
13 SET AUTOCOMMIT=OFF;
14 START TRANSACTION;
15
16 INSERT INTO t1 VALUES (1);
17 INSERT INTO t1 VALUES (2);
18 INSERT INTO t1 VALUES (3);
19 INSERT INTO t1 VALUES (4);
20 INSERT INTO t1 VALUES (5);
21
22 --connection node_2
23 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
24 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1;
25 --source include/wait_condition.inc
26
27 SET AUTOCOMMIT=OFF;
28
29 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
30 START TRANSACTION;
31
32 INSERT INTO t1 VALUES (9);
33 INSERT INTO t1 VALUES (8);
34 INSERT INTO t1 VALUES (7);
35 INSERT INTO t1 VALUES (6);
36
37 --error ER_LOCK_WAIT_TIMEOUT
38 INSERT INTO t1 VALUES (5);
39 ROLLBACK;
40
41 --connection node_1
42 COMMIT;
43
44 DROP TABLE t1;