Debian Codegraph @

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

raw
1 # Assertion `total_length + thd->wsrep_fragment_base == saved_pos' failed in wsrep_write_cache_inc() with ROLLBACK TO SAVEPOINT and SR
2
3 --source include/galera_cluster.inc
4 --source include/have_innodb.inc
5
6 --connection node_1
7 CREATE TABLE t1 (f1 INTEGER, f2 VARCHAR(10)) ENGINE=InnoDB;
8 SET AUTOCOMMIT=OFF;
9 SET SESSION wsrep_trx_fragment_size=1;
10 START TRANSACTION;
11 INSERT INTO t1 VALUES (1, 'a');
12 INSERT INTO t1 VALUES (2, 'a');
13 INSERT INTO t1 VALUES (3, 'a');
14 INSERT INTO t1 VALUES (4, 'a');
15 INSERT INTO t1 VALUES (5, 'a');
16 --connection node_2
17 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
18 --let $wait_condition = SELECT COUNT(*) = 5 FROM t1;
19 --source include/wait_condition.inc
20
21 --connection node_1
22 SAVEPOINT s1;
23 INSERT INTO t1 VALUES (11, 'b');
24 INSERT INTO t1 VALUES (12, 'b');
25 INSERT INTO t1 VALUES (13, 'b');
26 INSERT INTO t1 VALUES (14, 'b');
27 INSERT INTO t1 VALUES (15, 'b');
28
29 --connection node_2
30 --let $wait_condition = SELECT COUNT(*) = 10 FROM t1;
31 --source include/wait_condition.inc
32
33 --connection node_1
34 ROLLBACK TO SAVEPOINT s1;
35
36 INSERT INTO t1 VALUES (21, 'c');
37
38 COMMIT;
39
40 --connection node_1
41 SELECT COUNT(*) = 6 FROM t1;
42
43 --connection node_2
44 SELECT COUNT(*) = 6 FROM t1;
45
46 DROP TABLE t1;