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