Debian Codegraph @

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

raw
1
2 ========================================================================
3 STEP 1 - SETUP
4 ========================================================================
5 CREATE PROCEDURE handleError()
6 BEGIN
7 DECLARE no_such_table CONDITION FOR 1146;
8 DECLARE CONTINUE HANDLER FOR no_such_table select 1;
9 INSERT INTO test.no_table values (1);
10 END//
11 CREATE PROCEDURE signalError()
12 BEGIN
13 DECLARE mycond CONDITION FOR SQLSTATE '42S02';
14 SIGNAL mycond SET MESSAGE_TEXT = 'An error occurred';
15 END//
16 CREATE PROCEDURE bigError()
17 BEGIN
18 SIGNAL SQLSTATE "HY000" SET MYSQL_ERRNO = 40000, MESSAGE_TEXT = "A big error number";
19 END//
20 truncate performance_schema.events_errors_summary_by_thread_by_error;
21 truncate performance_schema.events_errors_summary_by_user_by_error;
22 truncate performance_schema.events_errors_summary_by_host_by_error;
23 truncate performance_schema.events_errors_summary_by_account_by_error;
24 truncate performance_schema.events_errors_summary_global_by_error;
25
26 # Control thread
27
28
29 # Create new user user1.
30
31 create user user1@localhost;
32 grant ALL on *.* to user1@localhost;
33
34 # Create new user user2.
35
36 create user user2@localhost;
37 grant ALL on *.* to user2@localhost;
38
39 # Connection 1
40
41 use bad_db;
42 ERROR 42000: Unknown database 'bad_db'
43 SELECT * from test.no_table;
44 ERROR 42S02: Table 'test.no_table' doesn't exist
45 call signalError();
46 ERROR 42S02: An error occurred
47 call bigError();
48 ERROR HY000: A big error number
49
50 # Connection 2
51
52 SELECT * from test.no_table;
53 ERROR 42S02: Table 'test.no_table' doesn't exist
54 I dont know the syntax;
55 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'I dont know the syntax' at line 1
56 call handleError();
57 1
58 1
59 #-------------------------------------------------------------
60 # Now see the error stats from P_S tables.
61 #-------------------------------------------------------------
62
63 # events_errors_summary_by_thread_by_error.
64 ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED
65 NULL NULL NULL 1 0
66 1049 ER_BAD_DB_ERROR 42000 1 0
67 1146 ER_NO_SUCH_TABLE 42S02 1 0
68 1644 ER_SIGNAL_EXCEPTION HY000 1 0
69 ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED
70 1064 ER_PARSE_ERROR 42000 1 0
71 1146 ER_NO_SUCH_TABLE 42S02 1 1
72
73 # events_errors_summary_by_user_by_error.
74 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;
75 USER ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED
76 user1 NULL NULL NULL 1 0
77 user1 1049 ER_BAD_DB_ERROR 42000 1 0
78 user1 1146 ER_NO_SUCH_TABLE 42S02 1 0
79 user1 1644 ER_SIGNAL_EXCEPTION HY000 1 0
80 user2 1064 ER_PARSE_ERROR 42000 1 0
81 user2 1146 ER_NO_SUCH_TABLE 42S02 1 1
82
83 # events_errors_summary_by_host_by_error.
84 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;
85 HOST ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED
86 localhost NULL NULL NULL 1 0
87 localhost 1049 ER_BAD_DB_ERROR 42000 1 0
88 localhost 1064 ER_PARSE_ERROR 42000 1 0
89 localhost 1146 ER_NO_SUCH_TABLE 42S02 2 1
90 localhost 1644 ER_SIGNAL_EXCEPTION HY000 1 0
91
92 # events_errors_summary_by_account_by_error.
93 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;
94 USER HOST ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED
95 user1 localhost NULL NULL NULL 1 0
96 user1 localhost 1049 ER_BAD_DB_ERROR 42000 1 0
97 user1 localhost 1146 ER_NO_SUCH_TABLE 42S02 1 0
98 user1 localhost 1644 ER_SIGNAL_EXCEPTION HY000 1 0
99 user2 localhost 1064 ER_PARSE_ERROR 42000 1 0
100 user2 localhost 1146 ER_NO_SUCH_TABLE 42S02 1 1
101
102 # events_errors_summary_global_by_error.
103 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;
104 ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED
105 NULL NULL NULL 1 0
106 1049 ER_BAD_DB_ERROR 42000 1 0
107 1064 ER_PARSE_ERROR 42000 1 0
108 1146 ER_NO_SUCH_TABLE 42S02 2 1
109 1644 ER_SIGNAL_EXCEPTION HY000 1 0
110
111 #-----------------------------------------------------
112 # Truncate stats
113 #-----------------------------------------------------
114 TRUNCATE performance_schema.events_errors_summary_by_thread_by_error;
115 TRUNCATE performance_schema.events_errors_summary_by_user_by_error;
116 TRUNCATE performance_schema.events_errors_summary_by_host_by_error;
117 TRUNCATE performance_schema.events_errors_summary_by_account_by_error;
118 TRUNCATE performance_schema.events_errors_summary_global_by_error;
119 SELECT * from performance_schema.events_errors_summary_by_thread_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
120 THREAD_ID ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
121 SELECT * from performance_schema.events_errors_summary_by_user_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
122 USER ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
123 SELECT * from performance_schema.events_errors_summary_by_host_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
124 HOST ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
125 SELECT * from performance_schema.events_errors_summary_by_account_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
126 USER HOST ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
127 SELECT * from performance_schema.events_errors_summary_global_by_error where SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
128 ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
129 drop procedure handleError;
130 drop procedure signalError;
131 drop procedure bigError;
132 drop user user1@localhost;
133 drop user user2@localhost;
134 select distinct ERROR_NUMBER, ERROR_NAME
135 from performance_schema.events_errors_summary_by_thread_by_error
136 where ERROR_NAME in (
137 'ER_HASHCHK',
138 'ER_NO',
139 'ER_YES',
140 'ER_CANT_CREATE_FILE',
141 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
142 'ER_FILE_CORRUPT',
143 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
144 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
145 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
146 'ER_PARSER_TRACE',
147 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
148 order by ERROR_NUMBER;
149 ERROR_NUMBER ERROR_NAME
150 1004 ER_CANT_CREATE_FILE
151 1887 WARN_NAMED_PIPE_ACCESS_EVERYONE
152 3000 ER_FILE_CORRUPT
153 3218 ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE
154 3500 ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
155 3952 ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET
156 select distinct ERROR_NUMBER, ERROR_NAME
157 from performance_schema.events_errors_summary_by_account_by_error
158 where ERROR_NAME in (
159 'ER_HASHCHK',
160 'ER_NO',
161 'ER_YES',
162 'ER_CANT_CREATE_FILE',
163 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
164 'ER_FILE_CORRUPT',
165 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
166 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
167 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
168 'ER_PARSER_TRACE',
169 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
170 order by ERROR_NUMBER;
171 ERROR_NUMBER ERROR_NAME
172 1004 ER_CANT_CREATE_FILE
173 1887 WARN_NAMED_PIPE_ACCESS_EVERYONE
174 3000 ER_FILE_CORRUPT
175 3218 ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE
176 3500 ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
177 3952 ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET
178 select distinct ERROR_NUMBER, ERROR_NAME
179 from performance_schema.events_errors_summary_by_user_by_error
180 where ERROR_NAME in (
181 'ER_HASHCHK',
182 'ER_NO',
183 'ER_YES',
184 'ER_CANT_CREATE_FILE',
185 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
186 'ER_FILE_CORRUPT',
187 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
188 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
189 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
190 'ER_PARSER_TRACE',
191 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
192 order by ERROR_NUMBER;
193 ERROR_NUMBER ERROR_NAME
194 1004 ER_CANT_CREATE_FILE
195 1887 WARN_NAMED_PIPE_ACCESS_EVERYONE
196 3000 ER_FILE_CORRUPT
197 3218 ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE
198 3500 ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
199 3952 ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET
200 select distinct ERROR_NUMBER, ERROR_NAME
201 from performance_schema.events_errors_summary_by_host_by_error
202 where ERROR_NAME in (
203 'ER_HASHCHK',
204 'ER_NO',
205 'ER_YES',
206 'ER_CANT_CREATE_FILE',
207 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
208 'ER_FILE_CORRUPT',
209 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
210 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
211 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
212 'ER_PARSER_TRACE',
213 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
214 order by ERROR_NUMBER;
215 ERROR_NUMBER ERROR_NAME
216 1004 ER_CANT_CREATE_FILE
217 1887 WARN_NAMED_PIPE_ACCESS_EVERYONE
218 3000 ER_FILE_CORRUPT
219 3218 ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE
220 3500 ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
221 3952 ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET
222 select distinct ERROR_NUMBER, ERROR_NAME
223 from performance_schema.events_errors_summary_global_by_error
224 where ERROR_NAME in (
225 'ER_HASHCHK',
226 'ER_NO',
227 'ER_YES',
228 'ER_CANT_CREATE_FILE',
229 'WARN_NAMED_PIPE_ACCESS_EVERYONE',
230 'ER_FILE_CORRUPT',
231 'ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE',
232 'ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE',
233 'ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET',
234 'ER_PARSER_TRACE',
235 'ER_GR_ELECTED_PRIMARY_GTID_INFORMATION')
236 order by ERROR_NUMBER;
237 ERROR_NUMBER ERROR_NAME
238 1004 ER_CANT_CREATE_FILE
239 1887 WARN_NAMED_PIPE_ACCESS_EVERYONE
240 3000 ER_FILE_CORRUPT
241 3218 ER_AUDIT_LOG_UDF_READ_INVALID_MAX_ARRAY_LENGTH_ARG_VALUE
242 3500 ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
243 3952 ER_DA_UDF_INVALID_RETURN_TYPE_TO_SET_CHARSET
244 10000 ER_PARSER_TRACE
245 13519 ER_GR_ELECTED_PRIMARY_GTID_INFORMATION