Debian Codegraph @

mysql-test/suite/galera/r/MDEV-30764.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_1;
6 SET GLOBAL wsrep_provider_options ='pc.ignore_sb=true;pc.weight=2';
7 connection node_2;
8 SET GLOBAL read_only=1;
9 SET SESSION wsrep_trx_fragment_size = 64;
10 set default_storage_engine=SEQUENCE;
11 SET AUTOCOMMIT = OFF;
12 CREATE TABLE t1(c1 NUMERIC NOT NULL);
13 ERROR HY000: Can't create table `test`.`t1` (errno: 131 "Command not supported by the engine")
14 CREATE TABLE t1 (id INT PRIMARY KEY) engine=innodb;
15 SET SESSION SQL_MODE='HIGH_NOT_PRECEDENCE';
16 INSERT INTO t1 VALUES (1),(2),(3);
17 SET GLOBAL SQL_MODE='NO_ENGINE_SUBSTITUTION';
18 DROP TABLE dummy;
19 ERROR 42S02: Unknown table 'test.dummy'
20 INSERT INTO t1 VALUES('a');
21 Warnings:
22 Warning 1366 Incorrect integer value: 'a' for column `test`.`t1`.`id` at row 1
23 # In this point there should be one fragment
24 select count(*) AS EXPECT_1 from mysql.wsrep_streaming_log;
25 EXPECT_1
26 1
27 SET @@global.wsrep_cluster_address='gcomm://';
28 SET SESSION SQL_MODE='TRADITIONAL ';
29 # Killing cluster because we have messed with wsrep_cluster_address
30 connection node_2;
31 SET SESSION wsrep_sync_wait = 0;
32 Killing server ...
33 connection node_1;
34 SET SESSION wsrep_sync_wait = 0;
35 Killing server ...
36 connection node_2;
37 call mtr.add_suppression("WSREP: BF applier thread");
38 call mtr.add_suppression("WSREP: Event");
39 call mtr.add_suppression("WSREP: SR trx recovery applying returned 1290");
40 call mtr.add_suppression("WSREP: Adopting a transaction");
41 call mtr.add_suppression("WSREP: Could not find applier context for");
42 call mtr.add_suppression("WSREP: It may not be safe to bootstrap the cluster");
43 call mtr.add_suppression("WSREP: Failed to vote on request for");
44 select count(*) AS EXPECT_0 from mysql.wsrep_streaming_log;
45 EXPECT_0
46 0
47 SELECT * FROM t1;
48 c1
49 connection node_1;
50 select count(*) AS EXPECT_0 from mysql.wsrep_streaming_log;
51 EXPECT_0
52 0
53 SELECT * FROM t1;
54 c1
55 DROP TABLE t1;
56 SET GLOBAL wsrep_provider_options ='pc.ignore_sb=false;pc.weight=1';
57 connection node_2;
58 connection node_1;
59 call mtr.add_suppression("WSREP: Event");
60 call mtr.add_suppression("WSREP: Inconsistency detected: Inconsistent by consensus on");
61 call mtr.add_suppression("WSREP: Failed to apply write set: gtid");
62 call mtr.add_suppression("WSREP: It may not be safe to bootstrap the cluster");
63 call mtr.add_suppression("WSREP: Could not find applier context for");
64 call mtr.add_suppression("WSREP: Failed to vote on request for");
65 disconnect node_2;
66 disconnect node_1;