Debian Codegraph @

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

raw
1 #
2 # Write a warning to error log if Galera replicates table with no primary key
3 #
4 # For InnoDB
5 # * push warning to client if wsrep_mode == REQUIRED_PRIMARY_KEY
6 # * push warning to error log if log_warnings > 1
7 # For MyIsam
8 # * push warning to client if wsrep_mode == REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM
9 # * push warning to error log if log_warnings > 1
10 # For Aria
11 # * push warning to client if wsrep_mode == REQUIRED_PRIMARY_KEY,REPLICATE_ARIA
12 # * push warning to error log if log_warnings > 1
13 #
14 # In both cases apply flood control if >= 10 same warning
15 #
16 --source include/galera_cluster.inc
17 --source include/have_innodb.inc
18 --source include/have_aria.inc
19
20 call mtr.add_suppression("WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled\\. Table ");
21
22 CREATE TABLE t1(a int, b varchar(50)) ENGINE=INNODB;
23 CREATE TABLE t2(a int, b varchar(50)) ENGINE=MYISAM;
24 CREATE TABLE t3(a int, b varchar(50)) ENGINE=MEMORY;
25 CREATE TABLE t4(a int, b varchar(50)) ENGINE=ARIA;
26
27 SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA";
28 SET GLOBAL log_warnings=2;
29
30 INSERT INTO t1 values (1,'test1');
31 INSERT INTO t2 values (1,'myisam1');
32 INSERT INTO t3 values (1,'memory1');
33 INSERT INTO t4 values (1,'aria1');
34
35 # these will not replicate
36 SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_ARIA";
37 INSERT INTO t2 values (2,'myisam2');
38 SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM";
39 INSERT INTO t4 values (2,'ARIA2');
40
41 # these should not write warning to error log
42 SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA";
43 SET GLOBAL log_warnings=1;
44 INSERT INTO t1 values (21,'not1');
45 INSERT INTO t1 values (22,'not2');
46 INSERT INTO t2 values (21,'not1');
47 INSERT INTO t2 values (22,'not2');
48 INSERT INTO t4 values (21,'not1');
49 INSERT INTO t4 values (22,'not2');
50
51 --let $assert_count = 3
52 --let $assert_file = $MYSQLTEST_VARDIR/log/mysqld.1.err
53 --let $assert_text = WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled.
54 --let $assert_select = WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled.
55 --source include/assert_grep.inc
56
57 # force flood
58 SET GLOBAL log_warnings=2;
59 INSERT INTO t1 values (6,'test6');
60 INSERT INTO t1 values (7,'test7');
61 INSERT INTO t1 values (8,'test8');
62 INSERT INTO t1 values (9,'test9');
63 INSERT INTO t1 values (10,'test10');
64 INSERT INTO t1 values (11,'test11');
65 INSERT INTO t1 values (12,'test12');
66 INSERT INTO t1 values (13,'test13');
67
68 INSERT INTO t1 values (33,'test13');
69 INSERT INTO t1 values (34,'test13');
70 INSERT INTO t1 values (35,'test13');
71 INSERT INTO t1 values (36,'test13');
72 INSERT INTO t1 values (37,'test13');
73 INSERT INTO t1 values (38,'test13');
74 INSERT INTO t1 values (39,'test13');
75
76 INSERT INTO t2 values (6,'test6');
77 INSERT INTO t2 values (7,'test7');
78 INSERT INTO t2 values (8,'test8');
79 INSERT INTO t2 values (9,'test9');
80 INSERT INTO t2 values (10,'test10');
81 INSERT INTO t2 values (11,'test11');
82 INSERT INTO t2 values (12,'test12');
83 INSERT INTO t2 values (13,'test13');
84
85 INSERT INTO t2 values (33,'test13');
86 INSERT INTO t2 values (34,'test13');
87 INSERT INTO t2 values (35,'test13');
88 INSERT INTO t2 values (36,'test13');
89 INSERT INTO t2 values (37,'test13');
90 INSERT INTO t2 values (38,'test13');
91 INSERT INTO t2 values (39,'test13');
92
93 INSERT INTO t4 values (6,'test6');
94 INSERT INTO t4 values (7,'test7');
95 INSERT INTO t4 values (8,'test8');
96 INSERT INTO t4 values (9,'test9');
97 INSERT INTO t4 values (10,'test10');
98 INSERT INTO t4 values (11,'test11');
99 INSERT INTO t4 values (12,'test12');
100 INSERT INTO t4 values (13,'test13');
101
102 INSERT INTO t4 values (33,'test13');
103 INSERT INTO t4 values (34,'test13');
104 INSERT INTO t4 values (35,'test13');
105 INSERT INTO t4 values (36,'test13');
106 INSERT INTO t4 values (37,'test13');
107 INSERT INTO t4 values (38,'test13');
108 INSERT INTO t4 values (39,'test13');
109
110 SELECT COUNT(*) AS EXPECT_18 FROM t1;
111 SELECT COUNT(*) AS EXPECT_19 FROM t2;
112 SELECT COUNT(*) AS EXPECT_1 FROM t3;
113 SELECT COUNT(*) AS EXPECT_19 FROM t4;
114
115 --connection node_2
116 SELECT COUNT(*) AS EXPECT_18 FROM t1;
117 SELECT COUNT(*) AS EXPECT_18 FROM t2;
118 SELECT COUNT(*) AS EXPECT_0 FROM t3;
119 SELECT COUNT(*) AS EXPECT_18 FROM t4;
120
121 --connection node_1
122 DROP TABLE t1,t2,t3,t4;
123
124 #
125 # Verify warning is on error log and check that no flood
126 #
127 --let $assert_count =
128 --let $assert_file = $MYSQLTEST_VARDIR/log/mysqld.1.err
129 --let $assert_text = WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled.
130 --let $assert_select = WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled.
131 --let $assert_match = WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled.
132 --source include/assert_grep.inc
133 --let $assert_count = 1
134 --let $assert_text = WSREP: Suppressing warnings of type 'WSREP_REQUIRE_PRIMARY_KEY' for up to 300 seconds because of flooding
135 --let $assert_select = WSREP: Suppressing warnings of type 'WSREP_REQUIRE_PRIMARY_KEY' for up to 300 seconds because of flooding
136 --let $assert_match =
137 --source include/assert_grep.inc
138
139 # reset env
140 --disable_query_log
141 SET GLOBAL log_warnings=DEFAULT;
142 SET GLOBAL wsrep_mode=DEFAULT;
143 --disable_query_log