Debian Codegraph @

mysql-test/suite/galera/t/galera_many_rows.test

raw
1 --source include/big_test.inc
2 --source include/galera_cluster.inc
3 --source include/have_innodb.inc
4
5 # Save original auto_increment_offset values.
6 --let $node_1=node_1
7 --let $node_2=node_2
8 --source include/auto_increment_offset_save.inc
9
10 --connection node_1
11 SET SESSION innodb_lock_wait_timeout=600;
12 SET SESSION lock_wait_timeout=600;
13
14 CREATE TABLE ten (f1 INTEGER NOT NULL PRIMARY KEY) engine=InnoDB;
15 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
16
17 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) Engine=InnoDB;
18 INSERT INTO t1 (f2) SELECT a1.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
19
20 --connection node_2
21 SET SESSION wsrep_sync_wait = 0;
22 --let $wsrep_provider_options_node2 = `SELECT @@wsrep_provider_options`
23 SET SESSION wsrep_sync_wait = 15;
24
25 SET GLOBAL wsrep_provider_options = 'repl.causal_read_timeout=PT1H';
26
27 SELECT COUNT(*) FROM t1;
28 INSERT INTO t1 (f2) SELECT a1.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
29
30 --connection node_1
31 SELECT COUNT(*) FROM t1;
32 UPDATE t1 SET f2 = 1;
33
34 --connection node_2
35 SELECT COUNT(*) FROM t1 WHERE f2 = 1;
36
37 --connection node_1
38 START TRANSACTION;
39 SELECT COUNT(*) FROM t1;
40 UPDATE t1 SET f2 = 3;
41
42 --connection node_2
43 START TRANSACTION;
44 UPDATE t1 SET f2 = 4;
45
46 --connection node_1
47 COMMIT;
48
49 --connection node_2
50 --error ER_LOCK_DEADLOCK
51 COMMIT;
52
53 --disable_query_log
54 --eval SET GLOBAL wsrep_provider_options = '$wsrep_provider_options_node2';
55 --enable_query_log
56
57 --source include/auto_increment_offset_restore.inc
58
59 DROP TABLE t1;
60 DROP TABLE ten;