Debian Codegraph @

mysql-test/suite/rpl/r/rpl_explicit_undo_tablespaces.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 [Connection Master]
7 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
8 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
9 SELECT name,space_type,state
10 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
11 WHERE space_type = 'Undo' ORDER BY name;
12 name space_type state
13 innodb_undo_001 Undo active
14 innodb_undo_002 Undo active
15 undo_003 Undo active
16 undo_004 Undo active
17 include/sync_slave_sql_with_master.inc
18 [Connection Slave]
19 SELECT name,space_type,state
20 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
21 WHERE space_type = 'Undo' ORDER BY name;
22 name space_type state
23 innodb_undo_001 Undo active
24 innodb_undo_002 Undo active
25 [Connection Master]
26 DROP UNDO TABLESPACE undo_003;
27 ERROR HY000: Failed to drop UNDO TABLESPACE undo_003
28 SHOW WARNINGS;
29 Level Code Message
30 Error 1529 Failed to drop UNDO TABLESPACE undo_003
31 Error 3120 Tablespace `undo_003` is not empty.
32 include/sync_slave_sql_with_master.inc
33 [Connection Slave]
34 DROP UNDO TABLESPACE undo_003;
35 ERROR HY000: Tablespace undo_003 doesn't exist.
36 SHOW WARNINGS;
37 Level Code Message
38 Error 3510 Tablespace undo_003 doesn't exist.
39 [Connection Master]
40 ALTER UNDO TABLESPACE innodb_undo_001 SET INACTIVE;
41 ALTER UNDO TABLESPACE innodb_undo_002 SET INACTIVE;
42 SELECT name,space_type,state
43 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
44 WHERE space_type = 'Undo' ORDER BY name;
45 name space_type state
46 innodb_undo_001 Undo empty
47 innodb_undo_002 Undo empty
48 undo_003 Undo active
49 undo_004 Undo active
50 include/sync_slave_sql_with_master.inc
51 [Connection Slave]
52 SELECT name,space_type,state
53 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
54 WHERE space_type = 'Undo' ORDER BY name;
55 name space_type state
56 innodb_undo_001 Undo active
57 innodb_undo_002 Undo active
58 ALTER UNDO TABLESPACE innodb_undo_001 SET INACTIVE;
59 ERROR HY000: Cannot set innodb_undo_001 inactive since there would be less than 2 undo tablespaces left active.
60 ALTER UNDO TABLESPACE innodb_undo_002 SET INACTIVE;
61 ERROR HY000: Cannot set innodb_undo_002 inactive since there would be less than 2 undo tablespaces left active.
62 SELECT name,space_type,state
63 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
64 WHERE space_type = 'Undo' ORDER BY name;
65 name space_type state
66 innodb_undo_001 Undo active
67 innodb_undo_002 Undo active
68 [Connection Master]
69 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' Engine=InnoDB;
70 CREATE TABLE tab1(c1 int, c2 varchar(10)) TABLESPACE=ts1;
71 INSERT INTO tab1 VALUES(1, 'VISH');
72 CREATE TABLE tab2(c1 int , c2 varchar(10)) Engine=InnoDB;
73 INSERT INTO tab2 VALUES(2, 'VISH');
74 CREATE INDEX ix1 ON tab1(c2) USING BTREE;
75 CREATE INDEX ix2 ON tab2(c2) ;
76 include/sync_slave_sql_with_master.inc
77 [Connection Slave]
78 SHOW CREATE TABLE tab1;
79 Table Create Table
80 tab1 CREATE TABLE `tab1` (
81 `c1` int DEFAULT NULL,
82 `c2` varchar(10) DEFAULT NULL,
83 KEY `ix1` (`c2`) USING BTREE
84 ) /*!50100 TABLESPACE `ts1` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
85 SHOW CREATE TABLE tab2;
86 Table Create Table
87 tab2 CREATE TABLE `tab2` (
88 `c1` int DEFAULT NULL,
89 `c2` varchar(10) DEFAULT NULL,
90 KEY `ix2` (`c2`)
91 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
92 SELECT * FROM tab1;
93 c1 c2
94 1 VISH
95 SELECT * FROM tab2;
96 c1 c2
97 2 VISH
98 [Connection Master]
99 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
100 ERROR HY000: Cannot set undo_003 inactive since there would be less than 2 undo tablespaces left active.
101 SHOW WARNINGS;
102 Level Code Message
103 Error 3655 Cannot set undo_003 inactive since there would be less than 2 undo tablespaces left active.
104 Error 1533 Failed to alter: UNDO TABLESPACE undo_003
105 Error 3655 ALTER UNDO TABLEPSPACE operation is disallowed on undo_003
106 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
107 ERROR HY000: Cannot set undo_004 inactive since there would be less than 2 undo tablespaces left active.
108 SHOW WARNINGS;
109 Level Code Message
110 Error 3655 Cannot set undo_004 inactive since there would be less than 2 undo tablespaces left active.
111 Error 1533 Failed to alter: UNDO TABLESPACE undo_004
112 Error 3655 ALTER UNDO TABLEPSPACE operation is disallowed on undo_004
113 DROP UNDO TABLESPACE innodb_undo_001;
114 ERROR 42000: InnoDB: Tablespace names starting with `innodb_` are reserved.
115 SELECT name,space_type,state
116 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
117 WHERE space_type = 'Undo' ORDER BY name;
118 name space_type state
119 innodb_undo_001 Undo empty
120 innodb_undo_002 Undo empty
121 undo_003 Undo active
122 undo_004 Undo active
123 include/sync_slave_sql_with_master.inc
124 [Connection Slave]
125 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
126 ERROR HY000: Tablespace undo_004 doesn't exist.
127 SHOW WARNINGS;
128 Level Code Message
129 Error 3510 Tablespace undo_004 doesn't exist.
130 SELECT name,space_type,state
131 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
132 WHERE space_type = 'Undo' ORDER BY name;
133 name space_type state
134 innodb_undo_001 Undo active
135 innodb_undo_002 Undo active
136 DROP UNDO TABLESPACE innodb_undo_001;
137 ERROR 42000: InnoDB: Tablespace names starting with `innodb_` are reserved.
138 [Connection Master]
139 ALTER UNDO TABLESPACE innodb_undo_001 SET ACTIVE;
140 ALTER UNDO TABLESPACE innodb_undo_002 SET ACTIVE;
141 SELECT name,space_type,state
142 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
143 WHERE space_type = 'Undo' ORDER BY name;
144 name space_type state
145 innodb_undo_001 Undo active
146 innodb_undo_002 Undo active
147 undo_003 Undo active
148 undo_004 Undo active
149 DROP TABLE tab1;
150 DROP table tab2;
151 DROP TABLESPACE ts1;
152 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
153 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
154 DROP UNDO TABLESPACE undo_003;
155 SELECT name,space_type,state
156 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
157 WHERE space_type = 'Undo';
158 name space_type state
159 innodb_undo_001 Undo active
160 innodb_undo_002 Undo active
161 undo_004 Undo empty
162 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE '../undo_003.ibu';
163 ERROR HY000: The ADD DATAFILE filepath for an UNDO TABLESPACE cannot be a relative path.
164 SHOW WARNINGS;
165 Level Code Message
166 Error 3121 The ADD DATAFILE filepath for an UNDO TABLESPACE cannot be a relative path.
167 Error 3121 The UNDO DATAFILE location must be in a known directory.
168 Error 1528 Failed to create UNDO TABLESPACE undo_003
169 Error 3121 Incorrect File Name '../undo_003.ibu'.
170 include/sync_slave_sql_with_master.inc
171 [Connection Slave]
172 SELECT name,space_type,state
173 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
174 WHERE space_type = 'Undo';
175 name space_type state
176 innodb_undo_001 Undo active
177 innodb_undo_002 Undo active
178 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE '../undo_003.ibu';
179 ERROR HY000: The ADD DATAFILE filepath for an UNDO TABLESPACE cannot be a relative path.
180 SHOW WARNINGS;
181 Level Code Message
182 Error 3121 The ADD DATAFILE filepath for an UNDO TABLESPACE cannot be a relative path.
183 Error 3121 The UNDO DATAFILE location must be in a known directory.
184 Error 1528 Failed to create UNDO TABLESPACE undo_003
185 Error 3121 Incorrect File Name '../undo_003.ibu'.
186 [Connection Master]
187 DROP UNDO TABLESPACE undo_004;
188 SELECT name,space_type,state
189 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
190 WHERE space_type = 'Undo';
191 name space_type state
192 innodb_undo_001 Undo active
193 innodb_undo_002 Undo active
194 include/sync_slave_sql_with_master.inc
195 [Connection Slave]
196 SELECT name,space_type,state
197 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
198 WHERE space_type = 'Undo';
199 name space_type state
200 innodb_undo_001 Undo active
201 innodb_undo_002 Undo active
202 include/rpl_end.inc