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
|
#
# WL#6661: Error logging: Allow control of verbosity
#
CALL mtr.add_suppression("option 'log_error_verbosity'");
CALL mtr.add_suppression("--verbose is for use with");
SET @old_log_error_verbosity= @@global.log_error_verbosity;
SET @old_log_timestamps = @@global.log_timestamps;
# Spec 1: Nomenclature, no test
# The following four can be verified using mysqld--help-[not]win.test:
#
# Spec 2a: "--help works"
# Spec 2b: "default verbosity for --help is 1, errors only"
#
# Spec 3a: "--help --verbose works"
# Spec 3b: "default verbosity for --help --verbose is 1, errors only"
# Spec 4a "new sys-var log_error_verbosity"
# Spec 4d "--log_error_verbosity settable on command-line"
# Spec B "later options replace earlier ones."
SELECT @@global.log_error_verbosity;
@@global.log_error_verbosity
1
# Spec 4b "default"
SET GLOBAL log_error_verbosity=DEFAULT;
SELECT @@global.log_error_verbosity;
@@global.log_error_verbosity
2
# Spec 4c "range"
SET GLOBAL log_error_verbosity=0;
Warnings:
Warning 1292 Truncated incorrect log_error_verbosity value: '0'
SELECT @@global.log_error_verbosity;
@@global.log_error_verbosity
1
# Spec 4c "range"
SET GLOBAL log_error_verbosity=4;
Warnings:
Warning 1292 Truncated incorrect log_error_verbosity value: '4'
SELECT @@global.log_error_verbosity;
@@global.log_error_verbosity
3
# Spec 4d -- see above at 4a, and below in error log
# Spec 4e "global only"
SET SESSION log_error_verbosity=DEFAULT;
ERROR HY000: Variable 'log_error_verbosity' is a GLOBAL variable and should be set with SET GLOBAL
# Spec 4e "SUPER required for log_error_verbosity"
# Spec Ed "SUPER required for log_timestamps"
CREATE USER mysqltest_1;
# as unprivileged user:
SET GLOBAL log_error_verbosity=1;
ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
SET GLOBAL log_timestamps=SYSTEM;
ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
# as root:
DROP USER mysqltest_1;
# Spec 5 "--verbose without --help throws an error" -- see below in error log
# Spec 6 "example for things previously governed by log_warnings"
# see error log below for results
SET GLOBAL init_connect='wombat;';
CREATE USER mysqltest_yeslog;
CREATE USER mysqltest_nolog;
# Spec 6a "log_error_warnings=2+ includes warnings"
SET GLOBAL log_error_verbosity=2;
# Spec 6c "warnings now gagged by log_error_verbosity=1"
SET GLOBAL log_error_verbosity=1;
DROP USER mysqltest_yeslog;
DROP USER mysqltest_nolog;
SET GLOBAL init_connect='';
# Spec 6b "log_error_warnings=3 includes notes"
SET GLOBAL log_error_verbosity=2;
connect(localhost,mysqltest_2_nolog,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'mysqltest_2_nolog'@'localhost' (using password: NO)
SET GLOBAL log_error_verbosity=3;
connect(localhost,mysqltest_3_yeslog,,,MASTER_PORT,MASTER_SOCKET);
ERROR 28000: Access denied for user 'mysqltest_3_yeslog'@'localhost' (using password: NO)
SET GLOBAL log_error_verbosity=DEFAULT;
# Spec 7 "--log_warning throws deprecation warning" -- now removed
# Spec 8/Spec 8a "log_warnings sets log_error_verbosity" -- now removed
# Spec 9 -- no test; limits part shown in Spec 4c/Spec 8
# Spec A -- see Spec 4c "range" and Spec 8
# Spec B -- see above at 4a, and below in error log
# Spec C "bootstrap" -- no test
# Spec D "timestamp format" -- results in log below = regex was matched
# Spec Ea "log_timestamps"
SELECT @@global.log_timestamps;
@@global.log_timestamps
SYSTEM
# Spec Eb "log_timestamps -- values UTC|SYSTEM"
SET GLOBAL log_timestamps=UTC;
SELECT @@global.log_timestamps;
@@global.log_timestamps
UTC
SET GLOBAL log_timestamps=SYSTEM;
SELECT @@global.log_timestamps;
@@global.log_timestamps
SYSTEM
# Spec Ec "log_timestamps -- default UTC"
SET GLOBAL log_timestamps=DEFAULT;
SELECT @@global.log_timestamps;
@@global.log_timestamps
UTC
# Spec Ed "SUPER required" -- see 4e
# Spec Ee "SYSTEM = old behavior" -- no test
# Spec 4d "--log_error_verbosity settable on command-line"
# Spec 5 "--verbose without --help throws an error"
# Spec 7 "--log_warning throws deprecation warning" -- now removed
# Spec D "ISO 8601 / RFC 3339 compliant timestamps"
#
# error log:
DATE_TIME [Note] [MY-010926] [Server] Access denied for user 'mysqltest_3_yeslog'@'localhost' (using password: NO)
# cleanup
SET GLOBAL log_error_verbosity = @old_log_error_verbosity;
SET GLOBAL log_timestamps = @old_log_timestamps;
FLUSH LOGS;
#
# end WL#6661
|
