Debian Codegraph @

mysql-test/suite/federated/r/telemetry_traces_server.result

raw
1 CREATE DATABASE federated;
2 CREATE DATABASE federated;
3 DROP TABLE IF EXISTS federated.t1;
4 CREATE TABLE federated.t1 (
5 a int
6 );
7 INSERT INTO federated.t1 (a) VALUES (42);
8 INSTALL COMPONENT 'file://component_query_attributes';
9 INSTALL COMPONENT 'file://component_test_server_telemetry_traces';
10 # check initial telemetry session refcount (should be 1)
11 SELECT variable_value FROM performance_schema.global_status WHERE variable_name="test_server_telemetry_traces.live_sessions";
12 variable_value
13 1
14 # check telemetry session refcount on master server (variable should not exist)
15 SELECT variable_value FROM performance_schema.global_status WHERE variable_name="test_server_telemetry_traces.live_sessions";
16 variable_value
17 CREATE SERVER fedlink
18 FOREIGN DATA WRAPPER mysql
19 OPTIONS (
20 HOST '127.0.0.1',
21 PORT SLAVE_PORT,
22 USER 'root',
23 PASSWORD '',
24 DATABASE 'federated');
25 DROP TABLE IF EXISTS federated.t1;
26 CREATE TABLE federated.t1 (
27 a int
28 ) ENGINE="FEDERATED"
29 CONNECTION='fedlink/t1';
30 SELECT * FROM federated.t1;
31 a
32 42
33 # check telemetry session refcount before component uninstall (should be 2)
34 SELECT variable_value FROM performance_schema.global_status WHERE variable_name="test_server_telemetry_traces.live_sessions";
35 variable_value
36 2
37 UNINSTALL COMPONENT 'file://component_test_server_telemetry_traces';;
38 SELECT * FROM federated.t1;
39 a
40 42
41 UNINSTALL COMPONENT 'file://component_query_attributes';
42 Component logs:
43 test_server_telemetry_traces_component_init init:
44 - System variables registered.
45 - Status variables registered.
46 - Telemetry per-session data slot registered.
47 - Telemetry session callbacks registered.
48 - Telemetry statement callbacks registered.
49 End of init
50 tm_session_create: telemetry session started, increase refcount by user=root to 1
51 > tm_stmt_start: proceed further (depth=1, user=root, host=localhost, db=test, query='')
52 > tm_stmt_notify_qa: skip tracing, no qa (depth=1, with_qa=0, user=root, query='SELECT variable_value FROM performance_schema.global_status WHERE variable_name="test_server_telemetry_traces.live_sessions"')
53 tm_session_connect: client session started (user=root)
54 tm_session_create: telemetry session started, increase refcount by user=root to 2
55 > tm_stmt_start: proceed further (depth=1, user=root, host=localhost, db=federated, query='')
56 > tm_stmt_notify_qa: skip tracing, no qa (depth=1, with_qa=0, user=root, query='SELECT `a` FROM `t1` WHERE 1=0')
57 > tm_stmt_start: proceed further (depth=1, user=root, host=localhost, db=federated, query='')
58 > tm_stmt_notify_qa: skip tracing, no qa (depth=1, with_qa=0, user=root, query='SHOW TABLE STATUS LIKE 't1'')
59 > tm_stmt_start: proceed further (depth=1, user=root, host=localhost, db=federated, query='')
60 > tm_stmt_notify_qa: skip tracing, no qa (depth=1, with_qa=0, user=root, query='SHOW TABLE STATUS LIKE 't1'')
61 > tm_stmt_start: proceed further (depth=1, user=root, host=localhost, db=federated, query='')
62 > tm_stmt_notify_qa: skip tracing, no qa (depth=1, with_qa=0, user=root, query='SELECT `a` FROM `t1`')
63 > tm_stmt_start: proceed further (depth=1, user=root, host=localhost, db=test, query='')
64 > tm_stmt_notify_qa: skip tracing, no qa (depth=1, with_qa=0, user=root, query='SELECT variable_value FROM performance_schema.global_status WHERE variable_name="test_server_telemetry_traces.live_sessions"')
65 > tm_stmt_start: proceed further (depth=1, user=root, host=localhost, db=test, query='')
66 > tm_stmt_notify_qa: skip tracing, no qa (depth=1, with_qa=0, user=root, query='UNINSTALL COMPONENT 'file://component_test_server_telemetry_traces'')
67 test_server_telemetry_traces_component_deinit:
68 - Telemetry statement callbacks unregistered.
69 tm_session_destroy: telemetry session ended, decrease refcount to 1
70 - Current session aborted.
71 tm_session_destroy: telemetry session ended, decrease refcount to 0
72 - Done waiting for telemetry sessions to finish (refcount = 0).
73 - Telemetry session callbacks unregistered.
74 - Telemetry per-session data slot unregistered.
75 - Status variables unregistered.
76 - System variables unregistered.
77 End of deinit
78 DROP TABLE IF EXISTS federated.t1;
79 DROP SERVER fedlink;
80 DROP TABLE IF EXISTS federated.t1;
81 DROP DATABASE federated;
82 DROP TABLE IF EXISTS federated.t1;
83 DROP DATABASE federated;