Debian Codegraph @

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

raw
1 MySQL Server 1
2 CREATE LOGFILE GROUP lg1
3 ADD UNDOFILE 'lg1_undofile1.dat'
4 INITIAL_SIZE 1M
5 UNDO_BUFFER_SIZE = 1M
6 ENGINE=NDB;
7 CREATE TABLESPACE ts1
8 ADD DATAFILE 'ts1_datafile1.dat'
9 USE LOGFILE GROUP lg1
10 INITIAL_SIZE 2M
11 ENGINE=NDB;
12 CREATE TABLESPACE ts2
13 ADD DATAFILE 'ts2_datafile1.dat'
14 USE LOGFILE GROUP lg1
15 INITIAL_SIZE 2M
16 ENGINE=NDB;
17 CREATE TABLESPACE ts3
18 ADD DATAFILE 'ts3_datafile1.dat'
19 USE LOGFILE GROUP lg1
20 INITIAL_SIZE 2M
21 ENGINE=NDB;
22 MySQL Server 2
23 ALTER LOGFILE GROUP lg1
24 ADD UNDOFILE 'lg1_undofile2.dat'
25 ENGINE=NDB;
26 ALTER LOGFILE GROUP lg1
27 ADD UNDOFILE 'lg1_undofile3.dat'
28 ENGINE=NDB;
29 ALTER TABLESPACE ts1
30 ADD DATAFILE 'ts1_datafile2.dat';
31 ALTER TABLESPACE ts2
32 ADD DATAFILE 'ts2_datafile2.dat';
33 ALTER TABLESPACE ts3
34 ADD DATAFILE 'ts3_datafile2.dat';
35 MySQL Server 1
36 ALTER LOGFILE GROUP lg1
37 ADD UNDOFILE 'lg1_undofile2.dat'
38 ENGINE=NDB;
39 ERROR HY000: Failed to alter: CREATE UNDOFILE FAILED
40 SHOW WARNINGS;
41 Level Code Message
42 Warning 1296 Got error 760 'File already exists' from NDB
43 Warning 1296 Failed to create undofile 'lg1_undofile2.dat' in NDB
44 Error 1533 Failed to alter: CREATE UNDOFILE FAILED
45 ALTER LOGFILE GROUP lg1
46 ADD UNDOFILE 'lg1_undofile3.dat'
47 ENGINE=NDB;
48 ERROR HY000: Failed to alter: CREATE UNDOFILE FAILED
49 SHOW WARNINGS;
50 Level Code Message
51 Warning 1296 Got error 760 'File already exists' from NDB
52 Warning 1296 Failed to create undofile 'lg1_undofile3.dat' in NDB
53 Error 1533 Failed to alter: CREATE UNDOFILE FAILED
54 ALTER TABLESPACE ts1
55 ADD DATAFILE 'ts1_datafile2.dat';
56 ERROR HY000: Failed to alter: CREATE DATAFILE FAILED
57 SHOW WARNINGS;
58 Level Code Message
59 Warning 1296 Got error 760 'File already exists' from NDB
60 Warning 1296 Failed to create datafile 'ts1_datafile2.dat' in NDB
61 Error 1533 Failed to alter: CREATE DATAFILE FAILED
62 ALTER TABLESPACE ts2
63 ADD DATAFILE 'ts2_datafile2.dat';
64 ERROR HY000: Failed to alter: CREATE DATAFILE FAILED
65 SHOW WARNINGS;
66 Level Code Message
67 Warning 1296 Got error 760 'File already exists' from NDB
68 Warning 1296 Failed to create datafile 'ts2_datafile2.dat' in NDB
69 Error 1533 Failed to alter: CREATE DATAFILE FAILED
70 ALTER TABLESPACE ts3
71 ADD DATAFILE 'ts3_datafile2.dat';
72 ERROR HY000: Failed to alter: CREATE DATAFILE FAILED
73 SHOW WARNINGS;
74 Level Code Message
75 Warning 1296 Got error 760 'File already exists' from NDB
76 Warning 1296 Failed to create datafile 'ts3_datafile2.dat' in NDB
77 Error 1533 Failed to alter: CREATE DATAFILE FAILED
78 ALTER TABLESPACE ts1
79 DROP DATAFILE 'ts1_datafile1.dat';
80 ALTER TABLESPACE ts2
81 DROP DATAFILE 'ts2_datafile1.dat';
82 ALTER TABLESPACE ts3
83 DROP DATAFILE 'ts3_datafile1.dat';
84 MySQL Server 2
85 ALTER TABLESPACE ts1
86 DROP DATAFILE 'ts1_datafile1.dat';
87 ERROR HY000: Tablespace 'ts1' does not have a file named 'ts1_datafile1.dat'
88 ALTER TABLESPACE ts2
89 DROP DATAFILE 'ts2_datafile1.dat';
90 ERROR HY000: Tablespace 'ts2' does not have a file named 'ts2_datafile1.dat'
91 ALTER TABLESPACE ts3
92 DROP DATAFILE 'ts3_datafile1.dat';
93 ERROR HY000: Tablespace 'ts3' does not have a file named 'ts3_datafile1.dat'
94 ALTER TABLESPACE ts1
95 DROP DATAFILE 'ts1_datafile2.dat';
96 DROP TABLESPACE ts1;
97 ALTER TABLESPACE ts2
98 DROP DATAFILE 'ts2_datafile2.dat';
99 DROP TABLESPACE ts2;
100 ALTER TABLESPACE ts3
101 DROP DATAFILE 'ts3_datafile2.dat';
102 DROP TABLESPACE ts3;
103 DROP LOGFILE GROUP lg1
104 ENGINE=NDB;
105 MySQL Server 1
106 DROP TABLESPACE ts1;
107 ERROR HY000: Tablespace ts1 doesn't exist.
108 DROP TABLESPACE ts2;
109 ERROR HY000: Tablespace ts2 doesn't exist.
110 DROP TABLESPACE ts3;
111 ERROR HY000: Tablespace ts3 doesn't exist.
112 DROP LOGFILE GROUP lg1
113 ENGINE=NDB;
114 ERROR HY000: Failed to drop LOGFILE GROUP
115 SHOW WARNINGS;
116 Level Code Message
117 Warning 1296 Got error 723 'No such table existed' from NDB
118 Warning 1296 Failed to get logfile group 'lg1' from NDB
119 Error 1529 Failed to drop LOGFILE GROUP
120 CREATE LOGFILE GROUP lg1
121 ADD UNDOFILE 'lg1_undofile.dat'
122 INITIAL_SIZE 1M
123 UNDO_BUFFER_SIZE = 1M
124 ENGINE NDB;
125 CREATE TABLESPACE ts1
126 ADD DATAFILE 'ts1_datafile.dat'
127 USE LOGFILE GROUP lg1
128 INITIAL_SIZE 16M
129 ENGINE NDB;
130 CREATE TABLE t1 (
131 a int PRIMARY KEY,
132 b varchar(255)
133 )
134 ENGINE NDB TABLESPACE ts1 STORAGE DISK;
135 INSERT INTO t1 VALUES(1,'Omar Comin');
136 CREATE TABLE t2 (
137 a int PRIMARY KEY,
138 b varchar(255)
139 )
140 ENGINE NDB TABLESPACE ts1 STORAGE DISK;
141 INSERT INTO t2 VALUES(2,'Harry - yer a wizard');
142 MySQL Server 2
143 ALTER TABLESPACE ts1
144 ADD DATAFILE 'ts1_datafile2.dat';
145 MySQL Server 1
146 SELECT * FROM t1;
147 a b
148 1 Omar Comin
149 SELECT * FROM t2;
150 a b
151 2 Harry - yer a wizard
152 DROP TABLE t1,t2;
153 ALTER TABLESPACE ts1
154 DROP DATAFILE 'ts1_datafile.dat';
155 ALTER TABLESPACE ts1
156 DROP DATAFILE 'ts1_datafile2.dat';
157 DROP TABLESPACE ts1;
158 DROP LOGFILE GROUP lg1
159 ENGINE NDB;