Debian Codegraph @

mysql-test/suite/perfschema/r/table_plugin_in_use.result

raw
1 #################
2 # INITIAL STATE #
3 #################
4 update performance_schema.setup_objects
5 set ENABLED = "YES", TIMED = "YES"
6 where OBJECT_TYPE = "TABLE" and OBJECT_SCHEMA = "performance_schema";
7 FLUSH TABLES;
8 select * from INFORMATION_SCHEMA.tables
9 where TABLE_NAME like "pfs_example_%";
10 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
11 describe performance_schema.pfs_example_employee_name;
12 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
13 show create table performance_schema.pfs_example_employee_name;
14 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
15 select * from performance_schema.pfs_example_employee_name;
16 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
17 ###########
18 # INSTALL #
19 ###########
20 INSTALL PLUGIN pfs_example_plugin_employee SONAME 'pfs_example_plugin_employee.xxx';
21 select name from mysql.plugin
22 where name like 'pfs_example_%';
23 name
24 pfs_example_plugin_employee
25 select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
26 from INFORMATION_SCHEMA.tables
27 where TABLE_NAME like "pfs_example_%"
28 order by table_name;
29 TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
30 performance_schema pfs_example_employee_name PERFORMANCE_SCHEMA 10
31 performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
32 performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
33 performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
34 describe performance_schema.pfs_example_employee_name;
35 Field Type Null Key Default Extra
36 EMPLOYEE_NUMBER int NO PRI NULL
37 FIRST_NAME char(20) YES MUL NULL
38 LAST_NAME varchar(20) YES NULL
39 show create table performance_schema.pfs_example_employee_name;
40 Table Create Table
41 pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
42 `EMPLOYEE_NUMBER` int NOT NULL,
43 `FIRST_NAME` char(20) DEFAULT NULL,
44 `LAST_NAME` varchar(20) DEFAULT NULL,
45 PRIMARY KEY (`EMPLOYEE_NUMBER`),
46 KEY `FIRST_NAME` (`FIRST_NAME`)
47 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
48 select * from performance_schema.pfs_example_employee_name;
49 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
50 1 foo1 bar1
51 2 foo2 bar2
52 3 foo3 bar3
53 "===== In con1 : Issue query"
54 select * from performance_schema.pfs_example_employee_name;
55 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
56 1 foo1 bar1
57 2 foo2 bar2
58 3 foo3 bar3
59 "===== In con2 : Starting transaction"
60 begin;
61 select * from performance_schema.pfs_example_employee_name;
62 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
63 1 foo1 bar1
64 2 foo2 bar2
65 3 foo3 bar3
66 ##############
67 # UN INSTALL #
68 ##############
69 "===== In default : Sending UNINSTALL"
70 UNINSTALL PLUGIN pfs_example_plugin_employee;
71 "===== Check table lock status "
72 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OWNER_THREAD_ID INTERNAL_LOCK EXTERNAL_LOCK
73 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
74 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
75 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
76 "===== Check Thread Status for default connection "
77 NAME PROCESSLIST_COMMAND PROCESSLIST_STATE PROCESSLIST_INFO
78 thread/sql/one_connection Query Waiting for table metadata lock UNINSTALL PLUGIN pfs_example_plugin_employee
79 "===== Check metadata lock status "
80 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
81 TABLE performance_schema pfs_example_employee_name SHARED_READ TRANSACTION GRANTED
82 TABLE performance_schema pfs_example_employee_name EXCLUSIVE TRANSACTION PENDING
83 select name from mysql.plugin
84 where name like 'pfs_example_%';
85 name
86 pfs_example_plugin_employee
87 "===== In con1 : Send a query. About to block"
88 select * from performance_schema.pfs_example_employee_name;
89 "===== In con2 : Still alive. Issue a query."
90 select * from performance_schema.pfs_example_employee_name;
91 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
92 1 foo1 bar1
93 2 foo2 bar2
94 3 foo3 bar3
95 "===== Check table lock status "
96 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OWNER_THREAD_ID INTERNAL_LOCK EXTERNAL_LOCK
97 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
98 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
99 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
100 "===== Check Thread Status for default connection "
101 NAME PROCESSLIST_COMMAND PROCESSLIST_STATE PROCESSLIST_INFO
102 thread/sql/one_connection Query Waiting for table metadata lock UNINSTALL PLUGIN pfs_example_plugin_employee
103 "===== Check metadata lock status "
104 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
105 TABLE performance_schema pfs_example_employee_name SHARED_READ TRANSACTION GRANTED
106 TABLE performance_schema pfs_example_employee_name EXCLUSIVE TRANSACTION PENDING
107 TABLE performance_schema pfs_example_employee_name SHARED_READ TRANSACTION PENDING
108 "===== In con2 : Closing transaction"
109 commit;
110 ########
111 # CON1 #
112 ########
113 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
114 ########################
115 # UNINSTALL completing #
116 ########################
117 select name from mysql.plugin
118 where name like 'pfs_example_%';
119 name
120 select * from INFORMATION_SCHEMA.tables
121 where TABLE_NAME like "pfs_example_%";
122 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
123 describe performance_schema.pfs_example_employee_name;
124 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
125 show create table performance_schema.pfs_example_employee_name;
126 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
127 select * from performance_schema.pfs_example_employee_name;
128 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
129 ###############
130 # INSTALL (2) #
131 ###############
132 INSTALL PLUGIN pfs_example_plugin_employee SONAME 'pfs_example_plugin_employee.xxx';
133 select name from mysql.plugin
134 where name like 'pfs_example_%';
135 name
136 pfs_example_plugin_employee
137 select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
138 from INFORMATION_SCHEMA.tables
139 where TABLE_NAME like "pfs_example_%"
140 order by table_name;
141 TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
142 performance_schema pfs_example_employee_name PERFORMANCE_SCHEMA 10
143 performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
144 performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
145 performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
146 describe performance_schema.pfs_example_employee_name;
147 Field Type Null Key Default Extra
148 EMPLOYEE_NUMBER int NO PRI NULL
149 FIRST_NAME char(20) YES MUL NULL
150 LAST_NAME varchar(20) YES NULL
151 show create table performance_schema.pfs_example_employee_name;
152 Table Create Table
153 pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
154 `EMPLOYEE_NUMBER` int NOT NULL,
155 `FIRST_NAME` char(20) DEFAULT NULL,
156 `LAST_NAME` varchar(20) DEFAULT NULL,
157 PRIMARY KEY (`EMPLOYEE_NUMBER`),
158 KEY `FIRST_NAME` (`FIRST_NAME`)
159 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
160 select * from performance_schema.pfs_example_employee_name;
161 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
162 1 foo1 bar1
163 2 foo2 bar2
164 3 foo3 bar3
165 "===== In con1 : Issue query."
166 select * from performance_schema.pfs_example_employee_name;
167 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
168 1 foo1 bar1
169 2 foo2 bar2
170 3 foo3 bar3
171 "===== In con2 : Start transaction."
172 begin;
173 select * from performance_schema.pfs_example_employee_name;
174 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
175 1 foo1 bar1
176 2 foo2 bar2
177 3 foo3 bar3
178 ##################
179 # UN INSTALL (2) #
180 ##################
181 "===== In default : Sending UNINSTALL"
182 UNINSTALL PLUGIN pfs_example_plugin_employee;
183 "===== Check table lock status "
184 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OWNER_THREAD_ID INTERNAL_LOCK EXTERNAL_LOCK
185 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
186 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
187 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
188 "===== Check Thread Status for default connection "
189 NAME PROCESSLIST_COMMAND PROCESSLIST_STATE PROCESSLIST_INFO
190 thread/sql/one_connection Query Waiting for table metadata lock UNINSTALL PLUGIN pfs_example_plugin_employee
191 "===== Check metadata lock status "
192 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
193 TABLE performance_schema pfs_example_employee_name SHARED_READ TRANSACTION GRANTED
194 TABLE performance_schema pfs_example_employee_name EXCLUSIVE TRANSACTION PENDING
195 select name from mysql.plugin
196 where name like 'pfs_example_%';
197 name
198 pfs_example_plugin_employee
199 "===== In con1 : Send query. About to block"
200 select * from performance_schema.pfs_example_employee_name;
201 "===== In con2 : Still alive. Issue query."
202 select * from performance_schema.pfs_example_employee_name;
203 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
204 1 foo1 bar1
205 2 foo2 bar2
206 3 foo3 bar3
207 "===== Check table lock status "
208 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OWNER_THREAD_ID INTERNAL_LOCK EXTERNAL_LOCK
209 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
210 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
211 TABLE performance_schema pfs_example_employee_name NULL NULL NULL
212 "===== Check Thread Status for default connection "
213 NAME PROCESSLIST_COMMAND PROCESSLIST_STATE PROCESSLIST_INFO
214 thread/sql/one_connection Query Waiting for table metadata lock UNINSTALL PLUGIN pfs_example_plugin_employee
215 "===== Check metadata lock status "
216 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME LOCK_TYPE LOCK_DURATION LOCK_STATUS
217 TABLE performance_schema pfs_example_employee_name SHARED_READ TRANSACTION GRANTED
218 TABLE performance_schema pfs_example_employee_name EXCLUSIVE TRANSACTION PENDING
219 TABLE performance_schema pfs_example_employee_name SHARED_READ TRANSACTION PENDING
220 #########################
221 # KILLING UNINSTALL (2) #
222 #########################
223 kill query @pid;
224 "===== In con2 : Closing transaction"
225 commit;
226 ########
227 # CON1 #
228 ########
229 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
230 1 foo1 bar1
231 2 foo2 bar2
232 3 foo3 bar3
233 ############################
234 # UNINSTALL (2) completing #
235 ############################
236 ERROR 70100: Query execution was interrupted
237 show errors;
238 Level Code Message
239 Error 1317 Query execution was interrupted
240 Error 1883 Plugin 'pfs_example_plugin_employee' cannot be uninstalled now. Plugin is still in use.
241 select name from mysql.plugin
242 where name like 'pfs_example_%';
243 name
244 pfs_example_plugin_employee
245 select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
246 from INFORMATION_SCHEMA.tables
247 where TABLE_NAME like "pfs_example_%"
248 order by table_name;
249 TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
250 performance_schema pfs_example_employee_name PERFORMANCE_SCHEMA 10
251 performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
252 performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
253 performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
254 describe performance_schema.pfs_example_employee_name;
255 Field Type Null Key Default Extra
256 EMPLOYEE_NUMBER int NO PRI NULL
257 FIRST_NAME char(20) YES MUL NULL
258 LAST_NAME varchar(20) YES NULL
259 show create table performance_schema.pfs_example_employee_name;
260 Table Create Table
261 pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
262 `EMPLOYEE_NUMBER` int NOT NULL,
263 `FIRST_NAME` char(20) DEFAULT NULL,
264 `LAST_NAME` varchar(20) DEFAULT NULL,
265 PRIMARY KEY (`EMPLOYEE_NUMBER`),
266 KEY `FIRST_NAME` (`FIRST_NAME`)
267 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
268 select * from performance_schema.pfs_example_employee_name;
269 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
270 1 foo1 bar1
271 2 foo2 bar2
272 3 foo3 bar3
273 ##################
274 # UN INSTALL (3) #
275 ##################
276 UNINSTALL PLUGIN pfs_example_plugin_employee;
277 select * from INFORMATION_SCHEMA.tables
278 where TABLE_NAME like "pfs_example_%";
279 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
280 describe performance_schema.pfs_example_employee_name;
281 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
282 show create table performance_schema.pfs_example_employee_name;
283 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
284 select * from performance_schema.pfs_example_employee_name;
285 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
286 ###########
287 # CLEANUP #
288 ###########
289 update performance_schema.setup_objects
290 set ENABLED = "NO", TIMED = "NO"
291 where OBJECT_TYPE = "TABLE" and OBJECT_SCHEMA = "performance_schema";
292 FLUSH TABLES;