Debian Codegraph @

mysql-test/suite/perfschema/t/error_stats_summary.test

raw
1 ############# suite/perfschema/t/ees.test ####################
2
3 --source include/no_protocol.inc
4
5 --echo
6 --echo ========================================================================
7 --echo STEP 1 - SETUP
8 --echo ========================================================================
9
10 # Create a stored procedure which handles ER_NO_SUCH_TABLE error
11 delimiter //;
12
13 CREATE PROCEDURE handleError()
14 BEGIN
15 DECLARE no_such_table CONDITION FOR 1146;
16 DECLARE CONTINUE HANDLER FOR no_such_table select 1;
17 INSERT INTO test.no_table values (1);
18 END//
19
20 CREATE PROCEDURE signalError()
21 BEGIN
22 DECLARE mycond CONDITION FOR SQLSTATE '42S02';
23 SIGNAL mycond SET MESSAGE_TEXT = 'An error occurred';
24 END//
25
26 CREATE PROCEDURE bigError()
27 BEGIN
28 SIGNAL SQLSTATE "HY000" SET MYSQL_ERRNO = 40000, MESSAGE_TEXT = "A big error number";
29 END//
30
31 delimiter ;//
32
33 truncate performance_schema.events_errors_summary_by_thread_by_error;
34 truncate performance_schema.events_errors_summary_by_user_by_error;
35 truncate performance_schema.events_errors_summary_by_host_by_error;
36 truncate performance_schema.events_errors_summary_by_account_by_error;
37 truncate performance_schema.events_errors_summary_global_by_error;
38
39 --echo
40 --echo # Control thread
41 --echo
42 --connection default
43
44 #-------------------------------------------------------------
45 # Create new users
46 #-------------------------------------------------------------
47 --echo
48 --echo # Create new user user1.
49 --echo
50 create user user1@localhost;
51 grant ALL on *.* to user1@localhost;
52
53 --echo
54 --echo # Create new user user2.
55 --echo
56 create user user2@localhost;
57 grant ALL on *.* to user2@localhost;
58
59 #-------------------------------------------------------------
60 # Run some queries which give errors.
61 #-------------------------------------------------------------
62 --echo
63 --echo # Connection 1
64 --echo
65 connect(con1, localhost, user1,,);
66 let $con1_thread_id = `SELECT THREAD_ID FROM performance_schema.threads WHERE
67 PROCESSLIST_ID = connection_id()`;
68 # BAD db name
69 --error ER_BAD_DB_ERROR
70 use bad_db;
71 # Syntax error
72 --error ER_NO_SUCH_TABLE
73 SELECT * from test.no_table;
74
75 --error 1644
76 # Call the stored procedure
77 call signalError();
78 --error 40000
79 call bigError();
80
81 --echo
82 --echo # Connection 2
83 --echo
84 connect(con2, localhost, user2,,);
85 let $con2_thread_id = `SELECT THREAD_ID FROM performance_schema.threads WHERE
86 PROCESSLIST_ID = connection_id()`;
87 # Table doesn't exist error
88 --error ER_NO_SUCH_TABLE
89 SELECT * from test.no_table;
90 --error ER_PARSE_ERROR
91 I dont know the syntax;
92
93 # Call the stored procedure
94 call handleError();
95
96
97
98 --echo #-------------------------------------------------------------
99 --echo # Now see the error stats from P_S tables.
100 --echo #-------------------------------------------------------------
101
102 --connection default
103
104 --echo
105 --echo # events_errors_summary_by_thread_by_error.
106 --disable_query_log
107 eval SELECT ERROR_NUMBER, ERROR_NAME, SQL_STATE, SUM_ERROR_RAISED, SUM_ERROR_HANDLED from performance_schema.events_errors_summary_by_thread_by_error where (SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0) AND THREAD_ID = $con1_thread_id;
108 eval SELECT ERROR_NUMBER, ERROR_NAME, SQL_STATE, SUM_ERROR_RAISED, SUM_ERROR_HANDLED from performance_schema.events_errors_summary_by_thread_by_error where (SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0) AND THREAD_ID = $con2_thread_id;
109 --enable_query_log
110
111 --echo
112 --echo # events_errors_summary_by_user_by_error.
113 SELECT USER, ERROR_NUMBER, ERROR_NAME, SQL_STATE, SUM_ERROR_RAISED, SUM_ERROR_HANDLED from performance_schema.events_errors_summary_by_user_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
114 --echo
115 --echo # events_errors_summary_by_host_by_error.
116 SELECT HOST, ERROR_NUMBER, ERROR_NAME, SQL_STATE, SUM_ERROR_RAISED, SUM_ERROR_HANDLED from performance_schema.events_errors_summary_by_host_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
117 --echo
118 --echo # events_errors_summary_by_account_by_error.
119 SELECT USER, HOST, ERROR_NUMBER, ERROR_NAME, SQL_STATE, SUM_ERROR_RAISED, SUM_ERROR_HANDLED from performance_schema.events_errors_summary_by_account_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
120 --echo
121 --echo # events_errors_summary_global_by_error.
122 SELECT ERROR_NUMBER, ERROR_NAME, SQL_STATE, SUM_ERROR_RAISED, SUM_ERROR_HANDLED from performance_schema.events_errors_summary_global_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
123 --echo
124
125 --echo #-----------------------------------------------------
126 --echo # Truncate stats
127 --echo #-----------------------------------------------------
128 TRUNCATE performance_schema.events_errors_summary_by_thread_by_error;
129 TRUNCATE performance_schema.events_errors_summary_by_user_by_error;
130 TRUNCATE performance_schema.events_errors_summary_by_host_by_error;
131 TRUNCATE performance_schema.events_errors_summary_by_account_by_error;
132 TRUNCATE performance_schema.events_errors_summary_global_by_error;
133
134 SELECT * from performance_schema.events_errors_summary_by_thread_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
135 SELECT * from performance_schema.events_errors_summary_by_user_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
136 SELECT * from performance_schema.events_errors_summary_by_host_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
137 SELECT * from performance_schema.events_errors_summary_by_account_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
138 SELECT * from performance_schema.events_errors_summary_global_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
139
140
141
142 #-------------------------------------------------------------
143 # Cleanup
144 #-------------------------------------------------------------
145 #--disconnect con1;
146 #--disconnect con2;
147 drop procedure handleError;
148 drop procedure signalError;
149 drop procedure bigError;
150 drop user user1@localhost;
151 drop user user2@localhost;
152
153 #-------------------------------------------------------------
154 # BUG#30311574 PERFORMANCE SCHEMA ERROR STATS FOR IMPOSSIBLE ERRORS
155 #-------------------------------------------------------------
156
157 # List specific errors to make sure instrumentation is correct.
158 # - ER_HASHCHK : obsolete
159 # - ER_NO : not an error
160 # - ER_YES : not an error
161 # - ER_CANT_CREATE_FILE : first in range 1000
162 # - WARN_NAMED_PIPE_ACCESS_EVERYONE : last in range 1000
163 # - ER_FILE_CORRUPT : first in range 3000
164 # - ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE : last in range 3000
165 # - ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE : first in range 3500
166 # - ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET : last in range 3500
167 # - ER_PARSER_TRACE : first in range 10000 (global only)
168 # - ER_GR_ELECTED_PRIMARY_GTID_INFORMATION : last in range 10000 (global only)
169
170 select distinct ERROR_NUMBER, ERROR_NAME
171 from performance_schema.events_errors_summary_by_thread_by_error
172 where ERROR_NAME in (
173 'ER_HASHCHK',
174 'ER_NO',
175 'ER_YES',
176 'ER_CANT_CREATE_FILE',
177 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
178 'ER_FILE_CORRUPT',
179 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
180 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
181 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
182 'ER_PARSER_TRACE',
183 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
184 order by ERROR_NUMBER;
185
186 select distinct ERROR_NUMBER, ERROR_NAME
187 from performance_schema.events_errors_summary_by_account_by_error
188 where ERROR_NAME in (
189 'ER_HASHCHK',
190 'ER_NO',
191 'ER_YES',
192 'ER_CANT_CREATE_FILE',
193 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
194 'ER_FILE_CORRUPT',
195 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
196 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
197 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
198 'ER_PARSER_TRACE',
199 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
200 order by ERROR_NUMBER;
201
202 select distinct ERROR_NUMBER, ERROR_NAME
203 from performance_schema.events_errors_summary_by_user_by_error
204 where ERROR_NAME in (
205 'ER_HASHCHK',
206 'ER_NO',
207 'ER_YES',
208 'ER_CANT_CREATE_FILE',
209 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
210 'ER_FILE_CORRUPT',
211 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
212 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
213 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
214 'ER_PARSER_TRACE',
215 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
216 order by ERROR_NUMBER;
217
218 select distinct ERROR_NUMBER, ERROR_NAME
219 from performance_schema.events_errors_summary_by_host_by_error
220 where ERROR_NAME in (
221 'ER_HASHCHK',
222 'ER_NO',
223 'ER_YES',
224 'ER_CANT_CREATE_FILE',
225 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
226 'ER_FILE_CORRUPT',
227 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
228 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
229 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
230 'ER_PARSER_TRACE',
231 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
232 order by ERROR_NUMBER;
233
234 select distinct ERROR_NUMBER, ERROR_NAME
235 from performance_schema.events_errors_summary_global_by_error
236 where ERROR_NAME in (
237 'ER_HASHCHK',
238 'ER_NO',
239 'ER_YES',
240 'ER_CANT_CREATE_FILE',
241 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
242 'ER_FILE_CORRUPT',
243 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
244 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
245 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
246 'ER_PARSER_TRACE',
247 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
248 order by ERROR_NUMBER;
249