Debian Codegraph @

mysql-test/suite/galera/r/galera_bf_background_statistics.result

raw
1 connection node_2;
2 connection node_1;
3 SELECT @@innodb_stats_persistent;
4 @@innodb_stats_persistent
5 1
6 CREATE TABLE t1 (f1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, f2 INTEGER DEFAULT 1) ENGINE=InnoDB;
7 INSERT INTO t1(f1) values (NULL);
8 INSERT INTO t1(f1) select NULL from t1;
9 INSERT INTO t1(f1) select NULL from t1;
10 INSERT INTO t1(f1) select NULL from t1;
11 INSERT INTO t1(f1) select NULL from t1;
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 SELECT count(1) from t1;
23 count(1)
24 16384
25 connection node_2;
26 SET AUTOCOMMIT=OFF;
27 INSERT INTO t1 VALUES (9999999,NULL);
28 SELECT SLEEP(1000);;
29 connection node_1;
30 ALTER TABLE t1 CHANGE f2 f2 INTEGER NOT NULL DEFAULT 1;
31 connection node_2;
32 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
33 wsrep_local_aborts_increment
34 1
35 DROP TABLE t1;