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
|
#
# WL#9343: log TNG: log writers
#
#
# This test verifies the interaction with the 'ix syslog.
# It is disabled by default, to be run manually, so we
# won't spam the test host's syslog on a regular and concurrent
# basis. Besides, we'd have to make an unpleasant amount of
# assumptions about where the logs are located, how they're structured,
# and that we had the privileges to access them.
# This test is therefore provided for convenience, but disabled by
# default, and is not expect to pass on all platforms.
#
SET @@global.log_error_verbosity=3;
FLUSH LOGS;
SET @@session.debug="+d,parser_stmt_to_error_log";
SET @@session.debug="+d,log_error_normalize";
SET @@session.debug="+d,parser_stmt_to_error_log_with_system_prio";
SELECT @@global.log_error_services;
@@global.log_error_services
log_filter_internal; log_sink_internal
SELECT @@syseventlog.tag;
ERROR HY000: Unknown system variable 'syseventlog.tag'
SELECT "*** SWITCHING ERROR LOG TO SYSEVENTLOG ***";
*** SWITCHING ERROR LOG TO SYSEVENTLOG ***
*** SWITCHING ERROR LOG TO SYSEVENTLOG ***
INSTALL COMPONENT "file://component_log_sink_syseventlog";
# default value
SELECT @@global.syseventlog.tag;
@@global.syseventlog.tag
# change tag
SET @@global.syseventlog.tag="wl9343";
SELECT @@global.syseventlog.tag;
@@global.syseventlog.tag
wl9343
SET @@global.log_error_services="log_filter_internal; log_sink_internal; log_sink_syseventlog";
SELECT "logging to syslog";
logging to syslog
logging to syslog
# change while component is active
SET @@global.syseventlog.tag="wl9343_2";
SELECT @@global.syseventlog.tag;
@@global.syseventlog.tag
wl9343_2
SET @@global.log_error_services="log_filter_internal; log_sink_internal";
# change while component is loaded, but inactive
SET @@global.syseventlog.tag=DEFAULT;
SELECT @@global.syseventlog.tag;
@@global.syseventlog.tag
SET GLOBAL syseventlog.include_pid = OFF;
ERROR HY000: Unknown system variable 'syseventlog.include_pid'
SET GLOBAL syseventlog.facility = "local1";
ERROR HY000: Unknown system variable 'syseventlog.facility'
SET PERSIST syseventlog.tag = "wl11828";
SET @@global.log_error_services=DEFAULT;
UNINSTALL COMPONENT "file://component_log_sink_syseventlog";
# restart: --no-console --log-error-services=log_filter_internal;log_sink_syseventlog;log_sink_internal
SELECT @@syseventlog.tag;
@@syseventlog.tag
wl11828
RESET PERSIST `syseventlog.tag`;
# restart: --no-console --log-error-services=log_filter_internal;log_sink_syseventlog;log_sink_internal --syseventlog.tag=wl11828_2
SELECT @@syseventlog.tag;
@@syseventlog.tag
wl11828_2
# restart: --no-console --log-error-services=log_filter_internal;log_sink_syseventlog;log_sink_internal --syseventlog.tag=wl11828/2
SELECT @@syseventlog.tag;
@@syseventlog.tag
SET GLOBAL log_error_services= default;
# cleanup
SET @@session.debug="-d,parser_stmt_to_error_log_with_system_prio";
SET @@session.debug="-d,parser_stmt_to_error_log";
SET @@session.debug="-d,log_error_normalize";
FLUSH ERROR LOGS;
###
### done
###
|
