Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test a local transaction being aborted by a slave one while it is running a SLEEP()
6 #
7
8 SELECT @@innodb_stats_persistent;
9
10 CREATE TABLE t1 (f1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, f2 INTEGER DEFAULT 1) ENGINE=InnoDB;
11 INSERT INTO t1(f1) values (NULL);
12 INSERT INTO t1(f1) select NULL from t1;
13 INSERT INTO t1(f1) select NULL from t1;
14 INSERT INTO t1(f1) select NULL from t1;
15 INSERT INTO t1(f1) select NULL from t1;
16 INSERT INTO t1(f1) select NULL from t1;
17 INSERT INTO t1(f1) select NULL from t1;
18 INSERT INTO t1(f1) select NULL from t1;
19 INSERT INTO t1(f1) select NULL from t1;
20 INSERT INTO t1(f1) select NULL from t1;
21 INSERT INTO t1(f1) select NULL from t1;
22 INSERT INTO t1(f1) select NULL from t1;
23 INSERT INTO t1(f1) select NULL from t1;
24 INSERT INTO t1(f1) select NULL from t1;
25 INSERT INTO t1(f1) select NULL from t1;
26 SELECT count(1) from t1;
27
28 --connection node_2
29 SET AUTOCOMMIT=OFF;
30 --let $wsrep_local_bf_aborts_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
31 INSERT INTO t1 VALUES (9999999,NULL);
32 --send SELECT SLEEP(1000);
33
34 --connection node_1
35 ALTER TABLE t1 CHANGE f2 f2 INTEGER NOT NULL DEFAULT 1;
36
37 --connection node_2
38 --error ER_LOCK_DEADLOCK
39 --reap
40
41 --let $wsrep_local_bf_aborts_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_bf_aborts'`
42
43 # Check that wsrep_local_bf_aborts has been incremented by exactly 1
44 --disable_query_log
45 --eval SELECT $wsrep_local_bf_aborts_after - $wsrep_local_bf_aborts_before = 1 AS wsrep_local_aborts_increment;
46 --enable_query_log
47
48 DROP TABLE t1;