Debian Codegraph @

mysql-test/suite/ndb/r/ndb_dd_schema_synchronization.result

raw
1 "MySQL Server 1"
2 CREATE LOGFILE GROUP lg1
3 ADD UNDOFILE 'lg1_undofile.dat'
4 INITIAL_SIZE 1M
5 UNDO_BUFFER_SIZE = 1M
6 ENGINE=NDB;
7 CREATE TABLESPACE ts1
8 ADD DATAFILE 'ts1_datafile.dat'
9 USE LOGFILE GROUP lg1
10 INITIAL_SIZE 2M
11 ENGINE NDB;
12 CREATE TABLESPACE ts2
13 ADD DATAFILE 'ts2_datafile.dat'
14 USE LOGFILE GROUP lg1
15 INITIAL_SIZE 2M
16 ENGINE NDB;
17 CREATE TABLESPACE ts3
18 ADD DATAFILE 'ts3_datafile.dat'
19 USE LOGFILE GROUP lg1
20 INITIAL_SIZE 2M
21 ENGINE NDB;
22 "Start Backup"
23 ALTER TABLESPACE ts1
24 DROP DATAFILE 'ts1_datafile.dat';
25 DROP TABLESPACE ts1;
26 ALTER TABLESPACE ts2
27 DROP DATAFILE 'ts2_datafile.dat';
28 DROP TABLESPACE ts2;
29 ALTER TABLESPACE ts3
30 DROP DATAFILE 'ts3_datafile.dat';
31 DROP TABLESPACE ts3;
32 DROP LOGFILE GROUP lg1
33 ENGINE=NDB;
34 "Restore backup"
35 # restart
36 # restart
37 CREATE LOGFILE GROUP lg1
38 ADD UNDOFILE 'lg1_undofile.dat'
39 INITIAL_SIZE 1M
40 UNDO_BUFFER_SIZE = 1M
41 ENGINE=NDB;
42 ERROR HY000: Failed to create LOGFILE GROUP
43 SHOW WARNINGS;
44 Level Code Message
45 Warning 1296 Got error 721 'Schema object with given name already exists' from NDB
46 Warning 1296 Failed to create logfile group 'lg1' in NDB
47 Error 1528 Failed to create LOGFILE GROUP
48 CREATE TABLESPACE ts1
49 ADD DATAFILE 'ts1_datafile.dat'
50 USE LOGFILE GROUP lg1
51 INITIAL_SIZE 2M
52 ENGINE NDB;
53 ERROR HY000: Tablespace 'ts1' exists.
54 CREATE TABLESPACE ts2
55 ADD DATAFILE 'ts2_datafile.dat'
56 USE LOGFILE GROUP lg1
57 INITIAL_SIZE 2M
58 ENGINE NDB;
59 ERROR HY000: Tablespace 'ts2' exists.
60 CREATE TABLESPACE ts3
61 ADD DATAFILE 'ts3_datafile.dat'
62 USE LOGFILE GROUP lg1
63 INITIAL_SIZE 2M
64 ENGINE NDB;
65 ERROR HY000: Tablespace 'ts3' exists.
66 ALTER TABLESPACE ts1
67 DROP DATAFILE 'ts1_datafile.dat';
68 DROP TABLESPACE ts1;
69 CREATE TABLESPACE ts1
70 ADD DATAFILE 'ts1_datafile.dat'
71 USE LOGFILE GROUP lg1
72 INITIAL_SIZE 2M
73 ENGINE NDB;
74 ALTER TABLESPACE ts2
75 ADD DATAFILE 'ts2_datafile2.dat';
76 ALTER TABLESPACE ts3
77 ADD DATAFILE 'ts3_datafile2.dat';
78 ALTER TABLESPACE ts3
79 DROP DATAFILE 'ts3_datafile.dat';
80 ALTER LOGFILE GROUP lg1
81 ADD UNDOFILE 'lg1_undofile2.dat'
82 ENGINE=NDB;
83 "MySQL Server 2 after reconnect"
84 CREATE TABLESPACE ts1
85 ADD DATAFILE 'ts1_datafile.dat'
86 USE LOGFILE GROUP lg1
87 INITIAL_SIZE 2M
88 ENGINE NDB;
89 ERROR HY000: Tablespace 'ts1' exists.
90 ALTER TABLESPACE ts2
91 ADD DATAFILE 'ts2_datafile2.dat';
92 ERROR HY000: Failed to alter: CREATE DATAFILE FAILED
93 SHOW WARNINGS;
94 Level Code Message
95 Warning 1296 Got error 760 'File already exists' from NDB
96 Warning 1296 Failed to create datafile 'ts2_datafile2.dat' in NDB
97 Error 1533 Failed to alter: CREATE DATAFILE FAILED
98 ALTER TABLESPACE ts3
99 ADD DATAFILE 'ts3_datafile2.dat';
100 ERROR HY000: Failed to alter: CREATE DATAFILE FAILED
101 SHOW WARNINGS;
102 Level Code Message
103 Warning 1296 Got error 760 'File already exists' from NDB
104 Warning 1296 Failed to create datafile 'ts3_datafile2.dat' in NDB
105 Error 1533 Failed to alter: CREATE DATAFILE FAILED
106 ALTER TABLESPACE ts3
107 DROP DATAFILE 'ts3_datafile.dat';
108 ERROR HY000: Tablespace 'ts3' does not have a file named 'ts3_datafile.dat'
109 ALTER LOGFILE GROUP lg1
110 ADD UNDOFILE 'lg1_undofile2.dat'
111 ENGINE=NDB;
112 ERROR HY000: Failed to alter: CREATE UNDOFILE FAILED
113 SHOW WARNINGS;
114 Level Code Message
115 Warning 1296 Got error 760 'File already exists' from NDB
116 Warning 1296 Failed to create undofile 'lg1_undofile2.dat' in NDB
117 Error 1533 Failed to alter: CREATE UNDOFILE FAILED
118 ALTER TABLESPACE ts1
119 DROP DATAFILE 'ts1_datafile.dat';
120 DROP TABLESPACE ts1;
121 ALTER TABLESPACE ts2
122 DROP DATAFILE 'ts2_datafile.dat';
123 ALTER TABLESPACE ts2
124 DROP DATAFILE 'ts2_datafile2.dat';
125 DROP TABLESPACE ts2;
126 ALTER TABLESPACE ts3
127 DROP DATAFILE 'ts3_datafile2.dat';
128 DROP TABLESPACE ts3;
129 DROP LOGFILE GROUP lg1
130 ENGINE=NDB;
131 "MySQL Server 1 after reconnect"
132 DROP TABLESPACE ts1;
133 ERROR HY000: Tablespace ts1 doesn't exist.
134 DROP TABLESPACE ts2;
135 ERROR HY000: Tablespace ts2 doesn't exist.
136 DROP TABLESPACE ts3;
137 ERROR HY000: Tablespace ts3 doesn't exist.
138 DROP LOGFILE GROUP lg1
139 ENGINE=NDB;
140 ERROR HY000: Failed to drop LOGFILE GROUP
141 SHOW WARNINGS;
142 Level Code Message
143 Warning 1296 Got error 723 'No such table existed' from NDB
144 Warning 1296 Failed to get logfile group 'lg1' from NDB
145 Error 1529 Failed to drop LOGFILE GROUP
146 CREATE LOGFILE GROUP lg1
147 ADD UNDOFILE 'lg1_undofile.dat'
148 INITIAL_SIZE 1M
149 UNDO_BUFFER_SIZE = 1M
150 ENGINE NDB;
151 CREATE TABLESPACE ts1
152 ADD DATAFILE 'ts1_datafile.dat'
153 USE LOGFILE GROUP lg1
154 INITIAL_SIZE 2M
155 ENGINE NDB;
156 CREATE TABLE t1 (
157 a INT PRIMARY KEY,
158 b VARCHAR(255)
159 ) ENGINE NDB
160 TABLESPACE ts1
161 STORAGE DISK;
162 SHOW CREATE TABLE t1;
163 Table Create Table
164 t1 CREATE TABLE `t1` (
165 `a` int NOT NULL,
166 `b` varchar(255) DEFAULT NULL,
167 PRIMARY KEY (`a`)
168 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
169 DROP TABLE t1;
170 ALTER TABLESPACE ts1
171 DROP DATAFILE 'ts1_datafile.dat';
172 DROP TABLESPACE ts1;
173 DROP LOGFILE GROUP lg1
174 ENGINE NDB;
175 # restart
176 # restart
177 SHOW CREATE TABLE t1;
178 Table Create Table
179 t1 CREATE TABLE `t1` (
180 `a` int NOT NULL,
181 `b` varchar(255) DEFAULT NULL,
182 PRIMARY KEY (`a`)
183 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
184 SHOW CREATE TABLE t1;
185 Table Create Table
186 t1 CREATE TABLE `t1` (
187 `a` int NOT NULL,
188 `b` varchar(255) DEFAULT NULL,
189 PRIMARY KEY (`a`)
190 ) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
191 INSERT INTO t1 VALUES(1,'a');
192 SELECT * FROM t1;
193 a b
194 1 a
195 ALTER TABLE t1 DROP COLUMN b;
196 DROP TABLE t1;
197 ALTER TABLESPACE ts1
198 DROP DATAFILE 'ts1_datafile.dat';
199 DROP TABLESPACE ts1;
200 DROP LOGFILE GROUP lg1
201 ENGINE NDB;