Debian Codegraph @

mysql-test/suite/ndb/t/ndb_dd_schema_distribution.test

raw
1 --source include/have_multi_ndb.inc
2
3 --echo MySQL Server 1
4
5 # Create logfile group
6 CREATE LOGFILE GROUP lg1
7 ADD UNDOFILE 'lg1_undofile1.dat'
8 INITIAL_SIZE 1M
9 UNDO_BUFFER_SIZE = 1M
10 ENGINE=NDB;
11
12 # Create tablespaces using the logfile group
13 CREATE TABLESPACE ts1
14 ADD DATAFILE 'ts1_datafile1.dat'
15 USE LOGFILE GROUP lg1
16 INITIAL_SIZE 2M
17 ENGINE=NDB;
18
19 CREATE TABLESPACE ts2
20 ADD DATAFILE 'ts2_datafile1.dat'
21 USE LOGFILE GROUP lg1
22 INITIAL_SIZE 2M
23 ENGINE=NDB;
24
25 CREATE TABLESPACE ts3
26 ADD DATAFILE 'ts3_datafile1.dat'
27 USE LOGFILE GROUP lg1
28 INITIAL_SIZE 2M
29 ENGINE=NDB;
30
31 connection server2;
32 --echo MySQL Server 2
33
34 # Time to run some ALTER queries. This tests the ALTER ADD UNDO/DATAFILE
35 # functionality and also proves that the CREATE queries have been
36 # successfully distributed
37 ALTER LOGFILE GROUP lg1
38 ADD UNDOFILE 'lg1_undofile2.dat'
39 ENGINE=NDB;
40
41 ALTER LOGFILE GROUP lg1
42 ADD UNDOFILE 'lg1_undofile3.dat'
43 ENGINE=NDB;
44
45 ALTER TABLESPACE ts1
46 ADD DATAFILE 'ts1_datafile2.dat';
47
48 ALTER TABLESPACE ts2
49 ADD DATAFILE 'ts2_datafile2.dat';
50
51 ALTER TABLESPACE ts3
52 ADD DATAFILE 'ts3_datafile2.dat';
53
54 connection server1;
55 --echo MySQL Server 1
56
57 # Check if the previous ALTER's have been distributed. This is done by repeating
58 # the previous queries which should now fail
59 --error ER_ALTER_FILEGROUP_FAILED
60 ALTER LOGFILE GROUP lg1
61 ADD UNDOFILE 'lg1_undofile2.dat'
62 ENGINE=NDB;
63 SHOW WARNINGS;
64
65 --error ER_ALTER_FILEGROUP_FAILED
66 ALTER LOGFILE GROUP lg1
67 ADD UNDOFILE 'lg1_undofile3.dat'
68 ENGINE=NDB;
69 SHOW WARNINGS;
70
71 --error ER_ALTER_FILEGROUP_FAILED
72 ALTER TABLESPACE ts1
73 ADD DATAFILE 'ts1_datafile2.dat';
74 SHOW WARNINGS;
75
76 --error ER_ALTER_FILEGROUP_FAILED
77 ALTER TABLESPACE ts2
78 ADD DATAFILE 'ts2_datafile2.dat';
79 SHOW WARNINGS;
80
81 --error ER_ALTER_FILEGROUP_FAILED
82 ALTER TABLESPACE ts3
83 ADD DATAFILE 'ts3_datafile2.dat';
84 SHOW WARNINGS;
85
86 # More ALTER queries, this time with the DROP DATAFILE variant
87 ALTER TABLESPACE ts1
88 DROP DATAFILE 'ts1_datafile1.dat';
89
90 ALTER TABLESPACE ts2
91 DROP DATAFILE 'ts2_datafile1.dat';
92
93 ALTER TABLESPACE ts3
94 DROP DATAFILE 'ts3_datafile1.dat';
95
96 connection server2;
97 --echo MySQL Server 2
98
99 # Check if the latest ALTER queries have been distributed
100 --error ER_MISSING_TABLESPACE_FILE
101 ALTER TABLESPACE ts1
102 DROP DATAFILE 'ts1_datafile1.dat';
103
104 --error ER_MISSING_TABLESPACE_FILE
105 ALTER TABLESPACE ts2
106 DROP DATAFILE 'ts2_datafile1.dat';
107
108 --error ER_MISSING_TABLESPACE_FILE
109 ALTER TABLESPACE ts3
110 DROP DATAFILE 'ts3_datafile1.dat';
111
112 # And finally time to drop everything
113 ALTER TABLESPACE ts1
114 DROP DATAFILE 'ts1_datafile2.dat';
115
116 DROP TABLESPACE ts1;
117
118 ALTER TABLESPACE ts2
119 DROP DATAFILE 'ts2_datafile2.dat';
120
121 DROP TABLESPACE ts2;
122
123 ALTER TABLESPACE ts3
124 DROP DATAFILE 'ts3_datafile2.dat';
125
126 DROP TABLESPACE ts3;
127
128 DROP LOGFILE GROUP lg1
129 ENGINE=NDB;
130
131 connection server1;
132 --echo MySQL Server 1
133
134 # Finish up by confirming that the DROP queries have been distributed
135 --error ER_TABLESPACE_MISSING_WITH_NAME
136 DROP TABLESPACE ts1;
137
138 --error ER_TABLESPACE_MISSING_WITH_NAME
139 DROP TABLESPACE ts2;
140
141 --error ER_TABLESPACE_MISSING_WITH_NAME
142 DROP TABLESPACE ts3;
143
144 --error ER_DROP_FILEGROUP_FAILED
145 DROP LOGFILE GROUP lg1
146 ENGINE=NDB;
147 SHOW WARNINGS;
148
149 #
150 # Bug#29389168 DISK DATA TABLE UNUSABLE ON PARTICIPANT MYSQLD AFTER ALTER TABLESPACE
151 #
152 # Create logfile group
153 CREATE LOGFILE GROUP lg1
154 ADD UNDOFILE 'lg1_undofile.dat'
155 INITIAL_SIZE 1M
156 UNDO_BUFFER_SIZE = 1M
157 ENGINE NDB;
158
159 # Create tablespace using the logfile group
160 CREATE TABLESPACE ts1
161 ADD DATAFILE 'ts1_datafile.dat'
162 USE LOGFILE GROUP lg1
163 INITIAL_SIZE 16M
164 ENGINE NDB;
165
166 # Create disk data tables
167 CREATE TABLE t1 (
168 a int PRIMARY KEY,
169 b varchar(255)
170 )
171 ENGINE NDB TABLESPACE ts1 STORAGE DISK;
172 INSERT INTO t1 VALUES(1,'Omar Comin');
173
174 CREATE TABLE t2 (
175 a int PRIMARY KEY,
176 b varchar(255)
177 )
178 ENGINE NDB TABLESPACE ts1 STORAGE DISK;
179 INSERT INTO t2 VALUES(2,'Harry - yer a wizard');
180
181 --connection server2
182 --echo MySQL Server 2
183 ALTER TABLESPACE ts1
184 ADD DATAFILE 'ts1_datafile2.dat';
185
186 --connection server1
187 --echo MySQL Server 1
188 SELECT * FROM t1;
189 SELECT * FROM t2;
190 DROP TABLE t1,t2;
191 ALTER TABLESPACE ts1
192 DROP DATAFILE 'ts1_datafile.dat';
193 ALTER TABLESPACE ts1
194 DROP DATAFILE 'ts1_datafile2.dat';
195 DROP TABLESPACE ts1;
196 DROP LOGFILE GROUP lg1
197 ENGINE NDB;