1 | [ Dec 21 08:14:24 Enabled. ] | ||
2 | [ Dec 21 08:14:24 Rereading configuration. ] | ||
3 | [ Dec 21 08:14:28 Rereading configuration. ] | ||
4 | [ Dec 21 08:14:41 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ] | ||
5 | + set -o errexit | ||
6 | + set -o pipefail | ||
7 | + . /lib/svc/share/smf_include.sh | ||
8 | ++ SMF_EXIT_OK=0 | ||
9 | ++ SMF_EXIT_NODAEMON=94 | ||
10 | ++ SMF_EXIT_ERR_FATAL=95 | ||
11 | ++ SMF_EXIT_ERR_CONFIG=96 | ||
12 | ++ SMF_EXIT_MON_DEGRADE=97 | ||
13 | ++ SMF_EXIT_MON_OFFLINE=98 | ||
14 | ++ SMF_EXIT_ERR_NOSMF=99 | ||
15 | ++ SMF_EXIT_ERR_PERM=100 | ||
16 | ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default | ||
17 | + LISTEN_ADDR=fd00:1122:3344:101::e | ||
18 | ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default | ||
19 | + LISTEN_PORT=8123 | ||
20 | ++ svcprop -c -p config/store svc:/oxide/clickhouse:default | ||
21 | + DATASTORE=/data | ||
22 | + args=("--config-file" "/opt/oxide/clickhouse/config.xml" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
23 | + exec /opt/oxide/clickhouse/clickhouse server --config-file /opt/oxide/clickhouse/config.xml -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123 | ||
24 | [ Dec 21 08:14:41 Method "start" exited with status 0. ] | ||
25 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
26 | Logging trace to /var/tmp/clickhouse-server.log | ||
27 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
28 | 2024.12.21 08:14:42.043571 [ 1 ] {} <Information> Application: Will watch for the process with pid 23131 | ||
29 | 2024.12.21 08:14:42.043996 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
30 | 2024.12.21 08:14:42.286770 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 23131 | ||
31 | 2024.12.21 08:14:42.287491 [ 1 ] {} <Information> Application: starting up | ||
32 | 2024.12.21 08:14:42.288163 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
33 | 2024.12.21 08:14:42.374830 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
34 | 2024.12.21 08:14:42.431664 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
35 | 2024.12.21 08:14:42.431712 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
36 | 2024.12.21 08:14:42.431725 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
37 | 2024.12.21 08:14:42.431788 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
38 | 2024.12.21 08:14:42.432147 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
39 | 2024.12.21 08:14:42.433663 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
40 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
41 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
42 | 2024.12.21 08:14:42.434379 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
43 | 2024.12.21 08:14:42.435200 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
44 | 2024.12.21 08:14:42.435222 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
45 | 2024.12.21 08:14:42.435238 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
46 | 2024.12.21 08:14:42.435407 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
47 | 2024.12.21 08:14:42.436271 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
48 | 2024.12.21 08:14:42.441587 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
49 | 2024.12.21 08:14:42.442361 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
50 | 2024.12.21 08:14:42.443695 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
51 | 2024.12.21 08:14:42.443759 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
52 | 2024.12.21 08:14:42.445304 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
53 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
54 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
55 | 2024.12.21 08:14:42.445841 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
56 | 2024.12.21 08:14:42.450241 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
57 | 2024.12.21 08:14:42.450907 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml | ||
58 | 2024.12.21 08:14:42.452351 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
59 | 2024.12.21 08:14:42.452751 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
60 | 2024.12.21 08:14:42.453135 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
61 | 2024.12.21 08:14:42.453519 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
62 | 2024.12.21 08:14:42.454815 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
63 | 2024.12.21 08:14:42.454841 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
64 | 2024.12.21 08:14:42.454932 [ 164 ] {} <Debug> DNSResolver: Updating DNS cache | ||
65 | 2024.12.21 08:14:42.455102 [ 164 ] {} <Debug> DNSResolver: Updated DNS cache | ||
66 | 2024.12.21 08:14:42.480141 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
67 | 2024.12.21 08:14:42.480175 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000165032 sec | ||
68 | 2024.12.21 08:14:42.480224 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
69 | 2024.12.21 08:14:42.480240 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
70 | 2024.12.21 08:14:42.481353 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
71 | 2024.12.21 08:14:42.482385 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
72 | 2024.12.21 08:14:42.494078 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
73 | 2024.12.21 08:14:42.494122 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
74 | 2024.12.21 08:14:42.494145 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
75 | 2024.12.21 08:14:42.494158 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
76 | 2024.12.21 08:14:42.494187 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
77 | 2024.12.21 08:14:42.494209 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
78 | 2024.12.21 08:14:42.496790 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
79 | 2024.12.21 08:14:42.496834 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
80 | 2024.12.21 08:14:42.496857 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
81 | 2024.12.21 08:14:42.497041 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
82 | 2024.12.21 08:14:42.497061 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
83 | 2024.12.21 08:14:42.497096 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
84 | 2024.12.21 08:14:42.497116 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
85 | 2024.12.21 08:14:42.497129 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
86 | 2024.12.21 08:14:42.497157 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
87 | 2024.12.21 08:14:42.497176 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
88 | 2024.12.21 08:14:42.524019 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
89 | 2024.12.21 08:14:42.531015 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
90 | 2024.12.21 08:14:42.531047 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.4021e-05 sec | ||
91 | 2024.12.21 08:14:42.531060 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
92 | 2024.12.21 08:14:42.531071 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
93 | 2024.12.21 08:14:42.531096 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
94 | 2024.12.21 08:14:42.531299 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
95 | 2024.12.21 08:14:42.531345 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
96 | 2024.12.21 08:14:42.531359 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
97 | 2024.12.21 08:14:42.531371 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
98 | 2024.12.21 08:14:42.531383 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
99 | 2024.12.21 08:14:42.535720 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
100 | 2024.12.21 08:14:42.535939 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.78 MiB, peak 24.78 MiB, free memory in arenas 0.00 B, will set to 117.12 MiB (RSS), difference: 92.34 MiB | ||
101 | 2024.12.21 08:14:42.536857 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.439e-05 sec. | ||
102 | 2024.12.21 08:14:42.537821 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
103 | 2024.12.21 08:14:42.537919 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
104 | 2024.12.21 08:14:42.537938 [ 1 ] {} <Information> Application: Ready for connections. | ||
105 | 2024.12.21 08:14:42.570867 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:53728 | ||
106 | 2024.12.21 08:14:42.571119 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
107 | 2024.12.21 08:14:42.571173 [ 3 ] {} <Debug> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Authenticating user 'default' from [fd00:1122:3344:101::d]:53728 | ||
108 | 2024.12.21 08:14:42.571206 [ 3 ] {} <Debug> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
109 | 2024.12.21 08:14:42.571228 [ 3 ] {} <Debug> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
110 | 2024.12.21 08:14:42.571315 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
111 | 2024.12.21 08:14:42.571343 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
112 | 2024.12.21 08:14:42.571370 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
113 | 2024.12.21 08:14:42.571866 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:60436 | ||
114 | 2024.12.21 08:14:42.572037 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
115 | 2024.12.21 08:14:42.572079 [ 4 ] {} <Debug> TCP-Session: 3517b3bb-343c-4ad2-b59f-8a44053646d5 Authenticating user 'default' from [fd00:1122:3344:101::d]:60436 | ||
116 | 2024.12.21 08:14:42.572112 [ 4 ] {} <Debug> TCP-Session: 3517b3bb-343c-4ad2-b59f-8a44053646d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
117 | 2024.12.21 08:14:42.572149 [ 4 ] {} <Debug> TCP-Session: 3517b3bb-343c-4ad2-b59f-8a44053646d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
118 | 2024.12.21 08:14:42.572824 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:60888 | ||
119 | 2024.12.21 08:14:42.572826 [ 253 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:58472 | ||
120 | 2024.12.21 08:14:42.573077 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
121 | 2024.12.21 08:14:42.573087 [ 253 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
122 | 2024.12.21 08:14:42.572938 [ 254 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:44959 | ||
123 | 2024.12.21 08:14:42.573158 [ 5 ] {} <Debug> TCP-Session: 524c8fd2-408a-402a-b374-f3a1bb3a735b Authenticating user 'default' from [fd00:1122:3344:101::d]:60888 | ||
124 | 2024.12.21 08:14:42.573182 [ 253 ] {} <Debug> TCP-Session: 4c6f8e87-5e9a-4718-babc-e36e887c0165 Authenticating user 'default' from [fd00:1122:3344:101::d]:58472 | ||
125 | 2024.12.21 08:14:42.573139 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:52401 | ||
126 | 2024.12.21 08:14:42.573290 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:37281 | ||
127 | 2024.12.21 08:14:42.573373 [ 5 ] {} <Debug> TCP-Session: 524c8fd2-408a-402a-b374-f3a1bb3a735b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
128 | 2024.12.21 08:14:42.573388 [ 253 ] {} <Debug> TCP-Session: 4c6f8e87-5e9a-4718-babc-e36e887c0165 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
129 | 2024.12.21 08:14:42.573388 [ 254 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
130 | 2024.12.21 08:14:42.573632 [ 5 ] {} <Debug> TCP-Session: 524c8fd2-408a-402a-b374-f3a1bb3a735b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
131 | 2024.12.21 08:14:42.573881 [ 253 ] {} <Debug> TCP-Session: 4c6f8e87-5e9a-4718-babc-e36e887c0165 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
132 | 2024.12.21 08:14:42.573882 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
133 | 2024.12.21 08:14:42.573464 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:50864 | ||
134 | 2024.12.21 08:14:42.573914 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
135 | 2024.12.21 08:14:42.574029 [ 256 ] {} <Debug> TCP-Session: 94fab291-9373-4ddb-ad63-9260e71e95bb Authenticating user 'default' from [fd00:1122:3344:101::d]:37281 | ||
136 | 2024.12.21 08:14:42.574719 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:57520 | ||
137 | 2024.12.21 08:14:42.574821 [ 254 ] {} <Debug> TCP-Session: de105a21-83aa-476b-8852-395882cf08ba Authenticating user 'default' from [fd00:1122:3344:101::d]:44959 | ||
138 | 2024.12.21 08:14:42.574867 [ 255 ] {} <Debug> TCP-Session: bb1e022d-1015-42bd-b735-72acd26548bf Authenticating user 'default' from [fd00:1122:3344:101::d]:52401 | ||
139 | 2024.12.21 08:14:42.574861 [ 256 ] {} <Debug> TCP-Session: 94fab291-9373-4ddb-ad63-9260e71e95bb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
140 | 2024.12.21 08:14:42.574841 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
141 | 2024.12.21 08:14:42.575650 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
142 | 2024.12.21 08:14:42.575659 [ 254 ] {} <Debug> TCP-Session: de105a21-83aa-476b-8852-395882cf08ba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
143 | 2024.12.21 08:14:42.575640 [ 255 ] {} <Debug> TCP-Session: bb1e022d-1015-42bd-b735-72acd26548bf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
144 | 2024.12.21 08:14:42.575643 [ 256 ] {} <Debug> TCP-Session: 94fab291-9373-4ddb-ad63-9260e71e95bb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
145 | 2024.12.21 08:14:42.575816 [ 258 ] {} <Debug> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Authenticating user 'default' from [fd00:1122:3344:101::d]:57520 | ||
146 | 2024.12.21 08:14:42.575849 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
147 | 2024.12.21 08:14:42.575890 [ 254 ] {} <Debug> TCP-Session: de105a21-83aa-476b-8852-395882cf08ba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
148 | 2024.12.21 08:14:42.575891 [ 255 ] {} <Debug> TCP-Session: bb1e022d-1015-42bd-b735-72acd26548bf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
149 | 2024.12.21 08:14:42.575924 [ 258 ] {} <Debug> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
150 | 2024.12.21 08:14:42.576069 [ 257 ] {} <Debug> TCP-Session: 9b508fc1-42f6-43a1-8b08-92f0c51cb3c3 Authenticating user 'default' from [fd00:1122:3344:101::d]:50864 | ||
151 | 2024.12.21 08:14:42.576086 [ 258 ] {} <Debug> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
152 | 2024.12.21 08:14:42.576179 [ 257 ] {} <Debug> TCP-Session: 9b508fc1-42f6-43a1-8b08-92f0c51cb3c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
153 | 2024.12.21 08:14:42.576220 [ 257 ] {} <Debug> TCP-Session: 9b508fc1-42f6-43a1-8b08-92f0c51cb3c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
154 | 2024.12.21 08:14:42.579516 [ 3 ] {e7da30a8-2af8-46c2-a34b-8395afd207b6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
155 | 2024.12.21 08:14:42.635850 [ 3 ] {e7da30a8-2af8-46c2-a34b-8395afd207b6} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:53728) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
156 | |||
157 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
158 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
159 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
160 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
161 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
162 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
163 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
164 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
165 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
166 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
167 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
168 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
169 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
170 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
171 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
172 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
173 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
174 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
175 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
176 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
177 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
178 | |||
179 | 2024.12.21 08:14:42.637157 [ 3 ] {e7da30a8-2af8-46c2-a34b-8395afd207b6} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
180 | |||
181 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
182 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
183 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
184 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
185 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
186 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
187 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
188 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
189 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
190 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
191 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
192 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
193 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
194 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
195 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
196 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
197 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
198 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
199 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
200 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
201 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
202 | |||
203 | 2024.12.21 08:14:42.637260 [ 3 ] {e7da30a8-2af8-46c2-a34b-8395afd207b6} <Debug> TCPHandler: Processed in 0.063537799 sec. | ||
204 | 2024.12.21 08:14:42.637599 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
205 | 2024.12.21 08:14:42.637785 [ 258 ] {c33ed8d6-e879-4879-91c9-b617137ecbfa} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
206 | 2024.12.21 08:14:42.638097 [ 258 ] {c33ed8d6-e879-4879-91c9-b617137ecbfa} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:57520) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
207 | |||
208 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
209 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
210 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
211 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
212 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
213 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
214 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
215 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
216 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
217 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
218 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
219 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
220 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
221 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
222 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
223 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
224 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
225 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
226 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
227 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
228 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
229 | |||
230 | 2024.12.21 08:14:42.638209 [ 258 ] {c33ed8d6-e879-4879-91c9-b617137ecbfa} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
231 | |||
232 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
233 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
234 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
235 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
236 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
237 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
238 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
239 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
240 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
241 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
242 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
243 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
244 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
245 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
246 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
247 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
248 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
249 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
250 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
251 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
252 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
253 | |||
254 | 2024.12.21 08:14:42.638297 [ 258 ] {c33ed8d6-e879-4879-91c9-b617137ecbfa} <Debug> TCPHandler: Processed in 0.00084666 sec. | ||
255 | 2024.12.21 08:14:42.638502 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
256 | 2024.12.21 08:14:42.639690 [ 3 ] {7519e2b0-5292-4540-92c2-7aa92e55d75c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
257 | 2024.12.21 08:14:42.640301 [ 3 ] {7519e2b0-5292-4540-92c2-7aa92e55d75c} <Debug> TCPHandler: Processed in 0.001854592 sec. | ||
258 | 2024.12.21 08:14:42.640506 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
259 | 2024.12.21 08:14:42.640611 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
260 | 2024.12.21 08:14:42.640704 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
261 | 2024.12.21 08:14:42.650283 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
262 | 2024.12.21 08:14:42.650311 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.2721e-05 sec | ||
263 | 2024.12.21 08:14:42.650326 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} <Trace> ReferentialDeps: No tables | ||
264 | 2024.12.21 08:14:42.650354 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} <Trace> LoadingDeps: No tables | ||
265 | 2024.12.21 08:14:42.650379 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
266 | 2024.12.21 08:14:42.650428 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} <Debug> TCPHandler: Processed in 0.009976811 sec. | ||
267 | 2024.12.21 08:14:42.650638 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
268 | 2024.12.21 08:14:42.650835 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) /* The version table contains metadata about the `oximeter` database */ | ||
269 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
270 | 2024.12.21 08:14:42.650884 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
271 | 2024.12.21 08:14:42.658932 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
272 | 2024.12.21 08:14:42.667692 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} <Debug> oximeter.version (d34c5ef1-ce0f-4147-b76e-f668c6b48f34): Loading data parts | ||
273 | 2024.12.21 08:14:42.668247 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} <Debug> oximeter.version (d34c5ef1-ce0f-4147-b76e-f668c6b48f34): There are no data parts | ||
274 | 2024.12.21 08:14:42.669027 [ 260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:56740 | ||
275 | 2024.12.21 08:14:42.669182 [ 260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
276 | 2024.12.21 08:14:42.669209 [ 260 ] {} <Debug> TCP-Session: 2faeb2e0-3b49-4538-b353-fdddefae3d8b Authenticating user 'default' from [fd00:1122:3344:101::e]:56740 | ||
277 | 2024.12.21 08:14:42.669231 [ 260 ] {} <Debug> TCP-Session: 2faeb2e0-3b49-4538-b353-fdddefae3d8b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
278 | 2024.12.21 08:14:42.669268 [ 260 ] {} <Debug> TCP-Session: 2faeb2e0-3b49-4538-b353-fdddefae3d8b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
279 | 2024.12.21 08:14:42.669334 [ 260 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
280 | 2024.12.21 08:14:42.669360 [ 260 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
281 | 2024.12.21 08:14:42.669393 [ 260 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
282 | 2024.12.21 08:14:42.669832 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:33495 | ||
283 | 2024.12.21 08:14:42.670023 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:39069 | ||
284 | 2024.12.21 08:14:42.670027 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
285 | 2024.12.21 08:14:42.670086 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:49119 | ||
286 | 2024.12.21 08:14:42.670158 [ 261 ] {} <Debug> TCP-Session: bde5e1e4-629f-42c5-8362-e32a89182f56 Authenticating user 'default' from [fd00:1122:3344:101::e]:33495 | ||
287 | 2024.12.21 08:14:42.670278 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
288 | 2024.12.21 08:14:42.670274 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:56920 | ||
289 | 2024.12.21 08:14:42.670351 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
290 | 2024.12.21 08:14:42.670382 [ 261 ] {} <Debug> TCP-Session: bde5e1e4-629f-42c5-8362-e32a89182f56 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
291 | 2024.12.21 08:14:42.670409 [ 262 ] {} <Debug> TCP-Session: e0605171-1076-4071-a65f-2b7ead1e1cfe Authenticating user 'default' from [fd00:1122:3344:101::e]:39069 | ||
292 | 2024.12.21 08:14:42.670530 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:36849 | ||
293 | 2024.12.21 08:14:42.670547 [ 263 ] {} <Debug> TCP-Session: 72c00914-199c-4a36-a162-0eaa033fd27b Authenticating user 'default' from [fd00:1122:3344:101::e]:49119 | ||
294 | 2024.12.21 08:14:42.670554 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
295 | 2024.12.21 08:14:42.670563 [ 262 ] {} <Debug> TCP-Session: e0605171-1076-4071-a65f-2b7ead1e1cfe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
296 | 2024.12.21 08:14:42.670678 [ 261 ] {} <Debug> TCP-Session: bde5e1e4-629f-42c5-8362-e32a89182f56 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
297 | 2024.12.21 08:14:42.670730 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
298 | 2024.12.21 08:14:42.670750 [ 263 ] {} <Debug> TCP-Session: 72c00914-199c-4a36-a162-0eaa033fd27b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
299 | 2024.12.21 08:14:42.670756 [ 264 ] {} <Debug> TCP-Session: 879c30fa-8007-4d23-b106-fca64acc8917 Authenticating user 'default' from [fd00:1122:3344:101::e]:56920 | ||
300 | 2024.12.21 08:14:42.670835 [ 263 ] {} <Debug> TCP-Session: 72c00914-199c-4a36-a162-0eaa033fd27b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
301 | 2024.12.21 08:14:42.670753 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:42051 | ||
302 | 2024.12.21 08:14:42.670962 [ 264 ] {} <Debug> TCP-Session: 879c30fa-8007-4d23-b106-fca64acc8917 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
303 | 2024.12.21 08:14:42.670967 [ 265 ] {} <Debug> TCP-Session: cb8f7397-6d71-4adf-83f7-71550ebd3521 Authenticating user 'default' from [fd00:1122:3344:101::e]:36849 | ||
304 | 2024.12.21 08:14:42.670981 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:36462 | ||
305 | 2024.12.21 08:14:42.671028 [ 262 ] {} <Debug> TCP-Session: e0605171-1076-4071-a65f-2b7ead1e1cfe Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
306 | 2024.12.21 08:14:42.671046 [ 265 ] {} <Debug> TCP-Session: cb8f7397-6d71-4adf-83f7-71550ebd3521 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
307 | 2024.12.21 08:14:42.671069 [ 264 ] {} <Debug> TCP-Session: 879c30fa-8007-4d23-b106-fca64acc8917 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
308 | 2024.12.21 08:14:42.671224 [ 265 ] {} <Debug> TCP-Session: cb8f7397-6d71-4adf-83f7-71550ebd3521 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
309 | 2024.12.21 08:14:42.671335 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
310 | 2024.12.21 08:14:42.671418 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
311 | 2024.12.21 08:14:42.671472 [ 266 ] {} <Debug> TCP-Session: 0e5d9ab7-b968-4c0f-82ff-0461a33143da Authenticating user 'default' from [fd00:1122:3344:101::e]:42051 | ||
312 | 2024.12.21 08:14:42.671526 [ 267 ] {} <Debug> TCP-Session: 5196033a-52ff-496e-a688-667cf3a2d34d Authenticating user 'default' from [fd00:1122:3344:101::e]:36462 | ||
313 | 2024.12.21 08:14:42.671556 [ 266 ] {} <Debug> TCP-Session: 0e5d9ab7-b968-4c0f-82ff-0461a33143da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
314 | 2024.12.21 08:14:42.671568 [ 267 ] {} <Debug> TCP-Session: 5196033a-52ff-496e-a688-667cf3a2d34d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
315 | 2024.12.21 08:14:42.671586 [ 266 ] {} <Debug> TCP-Session: 0e5d9ab7-b968-4c0f-82ff-0461a33143da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
316 | 2024.12.21 08:14:42.671622 [ 267 ] {} <Debug> TCP-Session: 5196033a-52ff-496e-a688-667cf3a2d34d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
317 | 2024.12.21 08:14:42.687981 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} <Debug> TCPHandler: Processed in 0.037412682 sec. | ||
318 | 2024.12.21 08:14:42.688245 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
319 | 2024.12.21 08:14:42.688588 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) /* The measurement tables contain all individual samples from each timeseries. | ||
320 | * | ||
321 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
322 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
323 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
324 | * by all samples from the same timeseries. | ||
325 | * | ||
326 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
327 | * and then uses that to index quickly into the measurements tables. | ||
328 | */ | ||
329 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Bool) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
330 | 2024.12.21 08:14:42.688682 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
331 | 2024.12.21 08:14:42.705718 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} <Debug> oximeter.measurements_bool (862e8eba-562e-4700-8f06-ac02a71bb573): Loading data parts | ||
332 | 2024.12.21 08:14:42.705999 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} <Debug> oximeter.measurements_bool (862e8eba-562e-4700-8f06-ac02a71bb573): There are no data parts | ||
333 | 2024.12.21 08:14:42.710542 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} <Debug> TCPHandler: Processed in 0.02237223 sec. | ||
334 | 2024.12.21 08:14:42.710750 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
335 | 2024.12.21 08:14:42.710970 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
336 | 2024.12.21 08:14:42.711018 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
337 | 2024.12.21 08:14:42.716953 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} <Debug> oximeter.measurements_i8 (1b0195eb-eb2c-4c6e-8587-cd51a7f5981b): Loading data parts | ||
338 | 2024.12.21 08:14:42.717124 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} <Debug> oximeter.measurements_i8 (1b0195eb-eb2c-4c6e-8587-cd51a7f5981b): There are no data parts | ||
339 | 2024.12.21 08:14:42.724888 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} <Debug> TCPHandler: Processed in 0.014195252 sec. | ||
340 | 2024.12.21 08:14:42.725096 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
341 | 2024.12.21 08:14:42.725289 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
342 | 2024.12.21 08:14:42.725350 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
343 | 2024.12.21 08:14:42.730977 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} <Debug> oximeter.measurements_u8 (d4cdfee9-7b23-4162-a10f-df8e63993c59): Loading data parts | ||
344 | 2024.12.21 08:14:42.731160 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} <Debug> oximeter.measurements_u8 (d4cdfee9-7b23-4162-a10f-df8e63993c59): There are no data parts | ||
345 | 2024.12.21 08:14:42.738881 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} <Debug> TCPHandler: Processed in 0.013837707 sec. | ||
346 | 2024.12.21 08:14:42.739078 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
347 | 2024.12.21 08:14:42.739277 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
348 | 2024.12.21 08:14:42.739328 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
349 | 2024.12.21 08:14:42.742032 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} <Debug> oximeter.measurements_i16 (4cb14704-e3cc-4265-9b39-f945d0f5fc6e): Loading data parts | ||
350 | 2024.12.21 08:14:42.742209 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} <Debug> oximeter.measurements_i16 (4cb14704-e3cc-4265-9b39-f945d0f5fc6e): There are no data parts | ||
351 | 2024.12.21 08:14:42.743505 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} <Debug> TCPHandler: Processed in 0.004480424 sec. | ||
352 | 2024.12.21 08:14:42.743687 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
353 | 2024.12.21 08:14:42.743881 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
354 | 2024.12.21 08:14:42.743943 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
355 | 2024.12.21 08:14:42.756245 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} <Debug> oximeter.measurements_u16 (9cd36132-2d3d-4e10-bac3-c096ab65bff7): Loading data parts | ||
356 | 2024.12.21 08:14:42.756436 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} <Debug> oximeter.measurements_u16 (9cd36132-2d3d-4e10-bac3-c096ab65bff7): There are no data parts | ||
357 | 2024.12.21 08:14:42.759445 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} <Debug> TCPHandler: Processed in 0.015811271 sec. | ||
358 | 2024.12.21 08:14:42.759615 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
359 | 2024.12.21 08:14:42.759805 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
360 | 2024.12.21 08:14:42.759861 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
361 | 2024.12.21 08:14:42.762471 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} <Debug> oximeter.measurements_i32 (53a5eae1-83b0-4cd7-9158-e1da2f0cf7de): Loading data parts | ||
362 | 2024.12.21 08:14:42.762636 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} <Debug> oximeter.measurements_i32 (53a5eae1-83b0-4cd7-9158-e1da2f0cf7de): There are no data parts | ||
363 | 2024.12.21 08:14:42.763956 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} <Debug> TCPHandler: Processed in 0.004394343 sec. | ||
364 | 2024.12.21 08:14:42.764139 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
365 | 2024.12.21 08:14:42.764381 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
366 | 2024.12.21 08:14:42.764454 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
367 | 2024.12.21 08:14:42.778735 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} <Debug> oximeter.measurements_u32 (fa24f4d2-fbf2-4abd-9ec9-8e5f0e2214ff): Loading data parts | ||
368 | 2024.12.21 08:14:42.778929 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} <Debug> oximeter.measurements_u32 (fa24f4d2-fbf2-4abd-9ec9-8e5f0e2214ff): There are no data parts | ||
369 | 2024.12.21 08:14:42.786243 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} <Debug> TCPHandler: Processed in 0.022166898 sec. | ||
370 | 2024.12.21 08:14:42.786409 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
371 | 2024.12.21 08:14:42.786598 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
372 | 2024.12.21 08:14:42.786658 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
373 | 2024.12.21 08:14:42.792658 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} <Debug> oximeter.measurements_i64 (af6cc4ae-b944-4ccc-bb0e-82fcc5873a50): Loading data parts | ||
374 | 2024.12.21 08:14:42.792833 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} <Debug> oximeter.measurements_i64 (af6cc4ae-b944-4ccc-bb0e-82fcc5873a50): There are no data parts | ||
375 | 2024.12.21 08:14:42.796808 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} <Debug> TCPHandler: Processed in 0.010451527 sec. | ||
376 | 2024.12.21 08:14:42.796989 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
377 | 2024.12.21 08:14:42.797198 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
378 | 2024.12.21 08:14:42.797261 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
379 | 2024.12.21 08:14:42.799391 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} <Debug> oximeter.measurements_u64 (738aab94-5281-4b88-a5e2-6b7c491a8edd): Loading data parts | ||
380 | 2024.12.21 08:14:42.799567 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} <Debug> oximeter.measurements_u64 (738aab94-5281-4b88-a5e2-6b7c491a8edd): There are no data parts | ||
381 | 2024.12.21 08:14:42.811071 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} <Debug> TCPHandler: Processed in 0.014136261 sec. | ||
382 | 2024.12.21 08:14:42.811255 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
383 | 2024.12.21 08:14:42.811447 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
384 | 2024.12.21 08:14:42.811509 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
385 | 2024.12.21 08:14:42.815725 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} <Debug> oximeter.measurements_f32 (3f6dc789-ab80-46ac-8ad2-42f618b82b04): Loading data parts | ||
386 | 2024.12.21 08:14:42.815935 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} <Debug> oximeter.measurements_f32 (3f6dc789-ab80-46ac-8ad2-42f618b82b04): There are no data parts | ||
387 | 2024.12.21 08:14:42.819834 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} <Debug> TCPHandler: Processed in 0.008632804 sec. | ||
388 | 2024.12.21 08:14:42.820016 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
389 | 2024.12.21 08:14:42.820226 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_f64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
390 | 2024.12.21 08:14:42.820289 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
391 | 2024.12.21 08:14:42.826845 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} <Debug> oximeter.measurements_f64 (8427b0fc-9c7d-4dfc-a4bb-904a5459f6fc): Loading data parts | ||
392 | 2024.12.21 08:14:42.827037 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} <Debug> oximeter.measurements_f64 (8427b0fc-9c7d-4dfc-a4bb-904a5459f6fc): There are no data parts | ||
393 | 2024.12.21 08:14:42.832319 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} <Debug> TCPHandler: Processed in 0.012356369 sec. | ||
394 | 2024.12.21 08:14:42.832497 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
395 | 2024.12.21 08:14:42.832690 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_string ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(String) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
396 | 2024.12.21 08:14:42.832752 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
397 | 2024.12.21 08:14:42.841027 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} <Debug> oximeter.measurements_string (24afa182-6736-4d70-b892-b04df9c172b1): Loading data parts | ||
398 | 2024.12.21 08:14:42.841226 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} <Debug> oximeter.measurements_string (24afa182-6736-4d70-b892-b04df9c172b1): There are no data parts | ||
399 | 2024.12.21 08:14:42.845556 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} <Debug> TCPHandler: Processed in 0.013112168 sec. | ||
400 | 2024.12.21 08:14:42.845738 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
401 | 2024.12.21 08:14:42.845956 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
402 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
403 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
404 | * a string isn't palatable for a few reasons. | ||
405 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
406 | * details. | ||
407 | */ | ||
408 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
409 | 2024.12.21 08:14:42.846023 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
410 | 2024.12.21 08:14:42.848100 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} <Debug> oximeter.measurements_bytes (efb16d15-c2a6-47ff-8fd8-a5e7a53d642d): Loading data parts | ||
411 | 2024.12.21 08:14:42.848250 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} <Debug> oximeter.measurements_bytes (efb16d15-c2a6-47ff-8fd8-a5e7a53d642d): There are no data parts | ||
412 | 2024.12.21 08:14:42.861247 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} <Debug> TCPHandler: Processed in 0.015561928 sec. | ||
413 | 2024.12.21 08:14:42.861434 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
414 | 2024.12.21 08:14:42.861643 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativei64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
415 | 2024.12.21 08:14:42.861717 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
416 | 2024.12.21 08:14:42.863146 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:34757 | ||
417 | 2024.12.21 08:14:42.863272 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
418 | 2024.12.21 08:14:42.863321 [ 269 ] {} <Debug> TCP-Session: e9187fef-ea59-4001-aac3-3a00d2a61239 Authenticating user 'default' from [fd00:1122:3344:101::c]:34757 | ||
419 | 2024.12.21 08:14:42.863344 [ 269 ] {} <Debug> TCP-Session: e9187fef-ea59-4001-aac3-3a00d2a61239 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
420 | 2024.12.21 08:14:42.863359 [ 269 ] {} <Debug> TCP-Session: e9187fef-ea59-4001-aac3-3a00d2a61239 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
421 | 2024.12.21 08:14:42.863453 [ 269 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
422 | 2024.12.21 08:14:42.863491 [ 269 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
423 | 2024.12.21 08:14:42.863536 [ 269 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
424 | 2024.12.21 08:14:42.864696 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} <Debug> oximeter.measurements_cumulativei64 (46389ccd-dc88-404b-9488-c6a95c5e4974): Loading data parts | ||
425 | 2024.12.21 08:14:42.864960 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} <Debug> oximeter.measurements_cumulativei64 (46389ccd-dc88-404b-9488-c6a95c5e4974): There are no data parts | ||
426 | 2024.12.21 08:14:42.865068 [ 270 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:55852 | ||
427 | 2024.12.21 08:14:42.865230 [ 270 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
428 | 2024.12.21 08:14:42.865287 [ 271 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:61030 | ||
429 | 2024.12.21 08:14:42.865358 [ 272 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:40845 | ||
430 | 2024.12.21 08:14:42.865376 [ 270 ] {} <Debug> TCP-Session: 918fd8a7-c5b7-4e23-9037-34a538a9f831 Authenticating user 'default' from [fd00:1122:3344:101::c]:55852 | ||
431 | 2024.12.21 08:14:42.865527 [ 270 ] {} <Debug> TCP-Session: 918fd8a7-c5b7-4e23-9037-34a538a9f831 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
432 | 2024.12.21 08:14:42.865596 [ 271 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
433 | 2024.12.21 08:14:42.865637 [ 272 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
434 | 2024.12.21 08:14:42.865683 [ 270 ] {} <Debug> TCP-Session: 918fd8a7-c5b7-4e23-9037-34a538a9f831 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
435 | 2024.12.21 08:14:42.865710 [ 271 ] {} <Debug> TCP-Session: a7728dd4-5e10-414a-8de3-37c5a28f6c6c Authenticating user 'default' from [fd00:1122:3344:101::c]:61030 | ||
436 | 2024.12.21 08:14:42.865737 [ 272 ] {} <Debug> TCP-Session: 250dec3f-a670-4247-81e7-aa825b25b643 Authenticating user 'default' from [fd00:1122:3344:101::c]:40845 | ||
437 | 2024.12.21 08:14:42.865722 [ 273 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:53193 | ||
438 | 2024.12.21 08:14:42.865764 [ 274 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:49830 | ||
439 | 2024.12.21 08:14:42.865806 [ 271 ] {} <Debug> TCP-Session: a7728dd4-5e10-414a-8de3-37c5a28f6c6c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
440 | 2024.12.21 08:14:42.865822 [ 272 ] {} <Debug> TCP-Session: 250dec3f-a670-4247-81e7-aa825b25b643 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
441 | 2024.12.21 08:14:42.865907 [ 275 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:64480 | ||
442 | 2024.12.21 08:14:42.865939 [ 272 ] {} <Debug> TCP-Session: 250dec3f-a670-4247-81e7-aa825b25b643 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
443 | 2024.12.21 08:14:42.865916 [ 271 ] {} <Debug> TCP-Session: a7728dd4-5e10-414a-8de3-37c5a28f6c6c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
444 | 2024.12.21 08:14:42.866135 [ 276 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:60783 | ||
445 | 2024.12.21 08:14:42.866255 [ 274 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
446 | 2024.12.21 08:14:42.866251 [ 275 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
447 | 2024.12.21 08:14:42.866421 [ 275 ] {} <Debug> TCP-Session: ce360c63-f542-4c7a-aa3c-96f87a8f7ec1 Authenticating user 'default' from [fd00:1122:3344:101::c]:64480 | ||
448 | 2024.12.21 08:14:42.866420 [ 273 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
449 | 2024.12.21 08:14:42.866468 [ 275 ] {} <Debug> TCP-Session: ce360c63-f542-4c7a-aa3c-96f87a8f7ec1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
450 | 2024.12.21 08:14:42.866450 [ 274 ] {} <Debug> TCP-Session: 7a89eaf6-acc5-434f-a34b-91913a8325fb Authenticating user 'default' from [fd00:1122:3344:101::c]:49830 | ||
451 | 2024.12.21 08:14:42.866620 [ 273 ] {} <Debug> TCP-Session: 4c5f26ba-0029-4366-bbf7-9c70c59bcd57 Authenticating user 'default' from [fd00:1122:3344:101::c]:53193 | ||
452 | 2024.12.21 08:14:42.866635 [ 276 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
453 | 2024.12.21 08:14:42.866653 [ 275 ] {} <Debug> TCP-Session: ce360c63-f542-4c7a-aa3c-96f87a8f7ec1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
454 | 2024.12.21 08:14:42.866647 [ 274 ] {} <Debug> TCP-Session: 7a89eaf6-acc5-434f-a34b-91913a8325fb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
455 | 2024.12.21 08:14:42.866703 [ 276 ] {} <Debug> TCP-Session: 5e8f9efa-17cf-4b84-8b2f-2b443eda6a26 Authenticating user 'default' from [fd00:1122:3344:101::c]:60783 | ||
456 | 2024.12.21 08:14:42.866685 [ 273 ] {} <Debug> TCP-Session: 4c5f26ba-0029-4366-bbf7-9c70c59bcd57 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
457 | 2024.12.21 08:14:42.866776 [ 274 ] {} <Debug> TCP-Session: 7a89eaf6-acc5-434f-a34b-91913a8325fb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
458 | 2024.12.21 08:14:42.866787 [ 276 ] {} <Debug> TCP-Session: 5e8f9efa-17cf-4b84-8b2f-2b443eda6a26 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
459 | 2024.12.21 08:14:42.866797 [ 273 ] {} <Debug> TCP-Session: 4c5f26ba-0029-4366-bbf7-9c70c59bcd57 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
460 | 2024.12.21 08:14:42.866848 [ 276 ] {} <Debug> TCP-Session: 5e8f9efa-17cf-4b84-8b2f-2b443eda6a26 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
461 | 2024.12.21 08:14:42.884127 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} <Debug> TCPHandler: Processed in 0.022745545 sec. | ||
462 | 2024.12.21 08:14:42.884373 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
463 | 2024.12.21 08:14:42.884629 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
464 | 2024.12.21 08:14:42.884723 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
465 | 2024.12.21 08:14:42.900134 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} <Debug> oximeter.measurements_cumulativeu64 (d9a316ab-11dd-4407-8bbe-f6f4a92dbccc): Loading data parts | ||
466 | 2024.12.21 08:14:42.900331 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} <Debug> oximeter.measurements_cumulativeu64 (d9a316ab-11dd-4407-8bbe-f6f4a92dbccc): There are no data parts | ||
467 | 2024.12.21 08:14:42.904610 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} <Debug> TCPHandler: Processed in 0.020307756 sec. | ||
468 | 2024.12.21 08:14:42.904814 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
469 | 2024.12.21 08:14:42.905014 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
470 | 2024.12.21 08:14:42.905090 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
471 | 2024.12.21 08:14:42.917285 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} <Debug> oximeter.measurements_cumulativef32 (8d5a8ab5-0778-419a-98d2-025e0b5b21ae): Loading data parts | ||
472 | 2024.12.21 08:14:42.917468 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} <Debug> oximeter.measurements_cumulativef32 (8d5a8ab5-0778-419a-98d2-025e0b5b21ae): There are no data parts | ||
473 | 2024.12.21 08:14:42.924070 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} <Debug> TCPHandler: Processed in 0.019311923 sec. | ||
474 | 2024.12.21 08:14:42.924258 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
475 | 2024.12.21 08:14:42.924482 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
476 | 2024.12.21 08:14:42.924548 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
477 | 2024.12.21 08:14:42.930531 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} <Debug> oximeter.measurements_cumulativef64 (4a2a3c7c-fdf5-4859-8bc1-e2d6a1e94aef): Loading data parts | ||
478 | 2024.12.21 08:14:42.930702 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} <Debug> oximeter.measurements_cumulativef64 (4a2a3c7c-fdf5-4859-8bc1-e2d6a1e94aef): There are no data parts | ||
479 | 2024.12.21 08:14:42.937204 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} <Debug> TCPHandler: Processed in 0.012999897 sec. | ||
480 | 2024.12.21 08:14:42.937383 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
481 | 2024.12.21 08:14:42.937669 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
482 | * NOTE: Array types cannot be Nullable, see | ||
483 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
484 | * for more details. | ||
485 | * | ||
486 | * This means we need to use empty arrays to indicate a missing value. This | ||
487 | * is unfortunate, and at this point relies on the fact that an | ||
488 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
489 | * to figure out another way to represent missing samples here. | ||
490 | */ | ||
491 | bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
492 | 2024.12.21 08:14:42.937752 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
493 | 2024.12.21 08:14:42.946751 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} <Debug> oximeter.measurements_histogrami8 (0ad3d64f-5f05-4ec4-9962-5cd69004693f): Loading data parts | ||
494 | 2024.12.21 08:14:42.946958 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} <Debug> oximeter.measurements_histogrami8 (0ad3d64f-5f05-4ec4-9962-5cd69004693f): There are no data parts | ||
495 | 2024.12.21 08:14:42.963841 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} <Debug> TCPHandler: Processed in 0.02651326 sec. | ||
496 | 2024.12.21 08:14:42.964049 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
497 | 2024.12.21 08:14:42.964353 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
498 | 2024.12.21 08:14:42.964430 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
499 | 2024.12.21 08:14:42.968668 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} <Debug> oximeter.measurements_histogramu8 (d9b08376-9816-4b82-8352-4f362587a544): Loading data parts | ||
500 | 2024.12.21 08:14:42.968873 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} <Debug> oximeter.measurements_histogramu8 (d9b08376-9816-4b82-8352-4f362587a544): There are no data parts | ||
501 | 2024.12.21 08:14:42.984073 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} <Debug> TCPHandler: Processed in 0.020078982 sec. | ||
502 | 2024.12.21 08:14:42.984309 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
503 | 2024.12.21 08:14:42.984583 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
504 | 2024.12.21 08:14:42.984667 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
505 | 2024.12.21 08:14:43.000156 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 122.89 MiB, peak 122.89 MiB, free memory in arenas 0.00 B, will set to 135.04 MiB (RSS), difference: 12.14 MiB | ||
506 | 2024.12.21 08:14:43.001502 [ 277 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:41405 | ||
507 | 2024.12.21 08:14:43.001619 [ 277 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
508 | 2024.12.21 08:14:43.001645 [ 277 ] {} <Debug> TCP-Session: 1324b0a6-a930-441d-b271-9370d3c0d295 Authenticating user 'default' from [fd00:1122:3344:101::a]:41405 | ||
509 | 2024.12.21 08:14:43.001667 [ 277 ] {} <Debug> TCP-Session: 1324b0a6-a930-441d-b271-9370d3c0d295 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
510 | 2024.12.21 08:14:43.001702 [ 277 ] {} <Debug> TCP-Session: 1324b0a6-a930-441d-b271-9370d3c0d295 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
511 | 2024.12.21 08:14:43.001755 [ 277 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
512 | 2024.12.21 08:14:43.001777 [ 277 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
513 | 2024.12.21 08:14:43.001813 [ 277 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
514 | 2024.12.21 08:14:43.002818 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} <Debug> oximeter.measurements_histogrami16 (1695ba8d-6698-418c-bf32-d7edbe6b13d5): Loading data parts | ||
515 | 2024.12.21 08:14:43.003028 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} <Debug> oximeter.measurements_histogrami16 (1695ba8d-6698-418c-bf32-d7edbe6b13d5): There are no data parts | ||
516 | 2024.12.21 08:14:43.003343 [ 278 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:36113 | ||
517 | 2024.12.21 08:14:43.003522 [ 278 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
518 | 2024.12.21 08:14:43.003580 [ 280 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:42119 | ||
519 | 2024.12.21 08:14:43.003598 [ 279 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:38749 | ||
520 | 2024.12.21 08:14:43.003607 [ 278 ] {} <Debug> TCP-Session: 1c515b1a-88a4-493a-8ae3-c35c2965a731 Authenticating user 'default' from [fd00:1122:3344:101::a]:36113 | ||
521 | 2024.12.21 08:14:43.003816 [ 280 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
522 | 2024.12.21 08:14:43.003879 [ 279 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
523 | 2024.12.21 08:14:43.003885 [ 278 ] {} <Debug> TCP-Session: 1c515b1a-88a4-493a-8ae3-c35c2965a731 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
524 | 2024.12.21 08:14:43.003945 [ 279 ] {} <Debug> TCP-Session: 0e8e983e-49a5-46c2-896c-4df5ebf9508d Authenticating user 'default' from [fd00:1122:3344:101::a]:38749 | ||
525 | 2024.12.21 08:14:43.003982 [ 282 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:42454 | ||
526 | 2024.12.21 08:14:43.003922 [ 281 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:40382 | ||
527 | 2024.12.21 08:14:43.004033 [ 279 ] {} <Debug> TCP-Session: 0e8e983e-49a5-46c2-896c-4df5ebf9508d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
528 | 2024.12.21 08:14:43.004019 [ 278 ] {} <Debug> TCP-Session: 1c515b1a-88a4-493a-8ae3-c35c2965a731 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
529 | 2024.12.21 08:14:43.003919 [ 280 ] {} <Debug> TCP-Session: 8a5746bb-ce78-46e5-85f1-7f99eec81f28 Authenticating user 'default' from [fd00:1122:3344:101::a]:42119 | ||
530 | 2024.12.21 08:14:43.004335 [ 280 ] {} <Debug> TCP-Session: 8a5746bb-ce78-46e5-85f1-7f99eec81f28 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
531 | 2024.12.21 08:14:43.004341 [ 283 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:62736 | ||
532 | 2024.12.21 08:14:43.004370 [ 281 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
533 | 2024.12.21 08:14:43.004387 [ 279 ] {} <Debug> TCP-Session: 0e8e983e-49a5-46c2-896c-4df5ebf9508d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
534 | 2024.12.21 08:14:43.004431 [ 280 ] {} <Debug> TCP-Session: 8a5746bb-ce78-46e5-85f1-7f99eec81f28 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
535 | 2024.12.21 08:14:43.004291 [ 282 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
536 | 2024.12.21 08:14:43.004636 [ 281 ] {} <Debug> TCP-Session: 7440d9d2-b44b-498f-a5a6-4d66ed9ac190 Authenticating user 'default' from [fd00:1122:3344:101::a]:40382 | ||
537 | 2024.12.21 08:14:43.004637 [ 283 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
538 | 2024.12.21 08:14:43.004673 [ 282 ] {} <Debug> TCP-Session: da024d18-ac3f-4647-acbb-06a16110bc1d Authenticating user 'default' from [fd00:1122:3344:101::a]:42454 | ||
539 | 2024.12.21 08:14:43.004751 [ 283 ] {} <Debug> TCP-Session: 19b33c29-484a-4414-b03c-49df208aa426 Authenticating user 'default' from [fd00:1122:3344:101::a]:62736 | ||
540 | 2024.12.21 08:14:43.004787 [ 284 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:62764 | ||
541 | 2024.12.21 08:14:43.004780 [ 282 ] {} <Debug> TCP-Session: da024d18-ac3f-4647-acbb-06a16110bc1d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
542 | 2024.12.21 08:14:43.004844 [ 283 ] {} <Debug> TCP-Session: 19b33c29-484a-4414-b03c-49df208aa426 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
543 | 2024.12.21 08:14:43.004865 [ 282 ] {} <Debug> TCP-Session: da024d18-ac3f-4647-acbb-06a16110bc1d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
544 | 2024.12.21 08:14:43.004777 [ 281 ] {} <Debug> TCP-Session: 7440d9d2-b44b-498f-a5a6-4d66ed9ac190 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
545 | 2024.12.21 08:14:43.005009 [ 283 ] {} <Debug> TCP-Session: 19b33c29-484a-4414-b03c-49df208aa426 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
546 | 2024.12.21 08:14:43.005032 [ 281 ] {} <Debug> TCP-Session: 7440d9d2-b44b-498f-a5a6-4d66ed9ac190 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
547 | 2024.12.21 08:14:43.005004 [ 284 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
548 | 2024.12.21 08:14:43.005152 [ 284 ] {} <Debug> TCP-Session: d1d65e34-e2b8-4b24-ae64-a35769f6c1b7 Authenticating user 'default' from [fd00:1122:3344:101::a]:62764 | ||
549 | 2024.12.21 08:14:43.005176 [ 284 ] {} <Debug> TCP-Session: d1d65e34-e2b8-4b24-ae64-a35769f6c1b7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
550 | 2024.12.21 08:14:43.005231 [ 284 ] {} <Debug> TCP-Session: d1d65e34-e2b8-4b24-ae64-a35769f6c1b7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
551 | 2024.12.21 08:14:43.013175 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} <Debug> TCPHandler: Processed in 0.028923399 sec. | ||
552 | 2024.12.21 08:14:43.013459 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
553 | 2024.12.21 08:14:43.013865 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
554 | 2024.12.21 08:14:43.013945 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
555 | 2024.12.21 08:14:43.028977 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} <Debug> oximeter.measurements_histogramu16 (cfec980c-c8ae-4415-8809-8f4858bff97f): Loading data parts | ||
556 | 2024.12.21 08:14:43.029171 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} <Debug> oximeter.measurements_histogramu16 (cfec980c-c8ae-4415-8809-8f4858bff97f): There are no data parts | ||
557 | 2024.12.21 08:14:43.033885 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} <Debug> TCPHandler: Processed in 0.020520318 sec. | ||
558 | 2024.12.21 08:14:43.034106 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
559 | 2024.12.21 08:14:43.034440 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
560 | 2024.12.21 08:14:43.034534 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
561 | 2024.12.21 08:14:43.046811 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} <Debug> oximeter.measurements_histogrami32 (6a1e991f-bced-49ee-b85a-ea714581cb80): Loading data parts | ||
562 | 2024.12.21 08:14:43.047006 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} <Debug> oximeter.measurements_histogrami32 (6a1e991f-bced-49ee-b85a-ea714581cb80): There are no data parts | ||
563 | 2024.12.21 08:14:43.051528 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} <Debug> TCPHandler: Processed in 0.017494012 sec. | ||
564 | 2024.12.21 08:14:43.051758 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
565 | 2024.12.21 08:14:43.052051 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
566 | 2024.12.21 08:14:43.052123 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
567 | 2024.12.21 08:14:43.067068 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} <Debug> oximeter.measurements_histogramu32 (aa5a9b7a-a60a-4a60-a3ce-efd707b4675c): Loading data parts | ||
568 | 2024.12.21 08:14:43.067274 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} <Debug> oximeter.measurements_histogramu32 (aa5a9b7a-a60a-4a60-a3ce-efd707b4675c): There are no data parts | ||
569 | 2024.12.21 08:14:43.071682 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} <Debug> TCPHandler: Processed in 0.019978681 sec. | ||
570 | 2024.12.21 08:14:43.071901 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
571 | 2024.12.21 08:14:43.072171 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
572 | 2024.12.21 08:14:43.072250 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
573 | 2024.12.21 08:14:43.084623 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} <Debug> oximeter.measurements_histogrami64 (6b0524c2-5feb-4b2f-bcef-33ad29d55653): Loading data parts | ||
574 | 2024.12.21 08:14:43.084947 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} <Debug> oximeter.measurements_histogrami64 (6b0524c2-5feb-4b2f-bcef-33ad29d55653): There are no data parts | ||
575 | 2024.12.21 08:14:43.089401 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} <Debug> TCPHandler: Processed in 0.017555303 sec. | ||
576 | 2024.12.21 08:14:43.089613 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
577 | 2024.12.21 08:14:43.089913 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
578 | 2024.12.21 08:14:43.089987 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
579 | 2024.12.21 08:14:43.105024 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} <Debug> oximeter.measurements_histogramu64 (1d816bec-bfdf-4b05-be1c-533fccb35687): Loading data parts | ||
580 | 2024.12.21 08:14:43.105190 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} <Debug> oximeter.measurements_histogramu64 (1d816bec-bfdf-4b05-be1c-533fccb35687): There are no data parts | ||
581 | 2024.12.21 08:14:43.109533 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} <Debug> TCPHandler: Processed in 0.019975211 sec. | ||
582 | 2024.12.21 08:14:43.109720 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
583 | 2024.12.21 08:14:43.109990 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
584 | 2024.12.21 08:14:43.110070 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
585 | 2024.12.21 08:14:43.122721 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} <Debug> oximeter.measurements_histogramf32 (d2d94269-7534-46e3-9710-70a458d40aa4): Loading data parts | ||
586 | 2024.12.21 08:14:43.122949 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} <Debug> oximeter.measurements_histogramf32 (d2d94269-7534-46e3-9710-70a458d40aa4): There are no data parts | ||
587 | 2024.12.21 08:14:43.127604 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} <Debug> TCPHandler: Processed in 0.017936597 sec. | ||
588 | 2024.12.21 08:14:43.127830 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
589 | 2024.12.21 08:14:43.128186 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
590 | 2024.12.21 08:14:43.128270 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
591 | 2024.12.21 08:14:43.130757 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} <Debug> oximeter.measurements_histogramf64 (74eeceea-464b-4f45-b091-07df227c6e07): Loading data parts | ||
592 | 2024.12.21 08:14:43.130930 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} <Debug> oximeter.measurements_histogramf64 (74eeceea-464b-4f45-b091-07df227c6e07): There are no data parts | ||
593 | 2024.12.21 08:14:43.143548 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} <Debug> TCPHandler: Processed in 0.015782771 sec. | ||
594 | 2024.12.21 08:14:43.143740 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
595 | 2024.12.21 08:14:43.143938 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) /* The field tables store named dimensions of each timeseries. | ||
596 | * | ||
597 | * As with the measurement tables, there is one field table for each field data | ||
598 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
599 | * this behavior **must not** be relied upon for query correctness. | ||
600 | * | ||
601 | * The index for the fields differs from the measurements, however. Rows are | ||
602 | * sorted by timeseries name, then field name, field value, and finally | ||
603 | * timeseries key. This reflects the most common pattern for looking them up: | ||
604 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
605 | * usually then used to look up measurements. | ||
606 | * | ||
607 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
608 | * timeseries name and then key, since it would improve lookups where one | ||
609 | * already has the key. Realistically though, these tables are quite small and | ||
610 | * so performance benefits will be low in absolute terms. | ||
611 | * | ||
612 | * TTL: We use a materialized column to expire old field table records. This | ||
613 | * column is generated automatically by the database whenever a new row is | ||
614 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
615 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
616 | * record will remain during a deduplication, which will have the last | ||
617 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
618 | * measurement tables. | ||
619 | */ | ||
620 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
621 | 2024.12.21 08:14:43.144015 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
622 | 2024.12.21 08:14:43.147991 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} <Debug> oximeter.fields_bool (6b52f988-6a40-412e-92e4-e728b1e71ae7): Loading data parts | ||
623 | 2024.12.21 08:14:43.148210 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} <Debug> oximeter.fields_bool (6b52f988-6a40-412e-92e4-e728b1e71ae7): There are no data parts | ||
624 | 2024.12.21 08:14:43.157306 [ 285 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:49581 | ||
625 | 2024.12.21 08:14:43.157428 [ 285 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
626 | 2024.12.21 08:14:43.157454 [ 285 ] {} <Debug> TCP-Session: 63cf5652-819e-4854-b891-310a7dfb9150 Authenticating user 'default' from [fd00:1122:3344:101::b]:49581 | ||
627 | 2024.12.21 08:14:43.157504 [ 285 ] {} <Debug> TCP-Session: 63cf5652-819e-4854-b891-310a7dfb9150 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
628 | 2024.12.21 08:14:43.157518 [ 285 ] {} <Debug> TCP-Session: 63cf5652-819e-4854-b891-310a7dfb9150 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
629 | 2024.12.21 08:14:43.157582 [ 285 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
630 | 2024.12.21 08:14:43.157624 [ 285 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
631 | 2024.12.21 08:14:43.157643 [ 285 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
632 | 2024.12.21 08:14:43.159189 [ 286 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:36516 | ||
633 | 2024.12.21 08:14:43.159365 [ 286 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
634 | 2024.12.21 08:14:43.159421 [ 287 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:49204 | ||
635 | 2024.12.21 08:14:43.159424 [ 288 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:49264 | ||
636 | 2024.12.21 08:14:43.159465 [ 286 ] {} <Debug> TCP-Session: 892abc48-f4fc-4267-bc59-78f2fa5fc49d Authenticating user 'default' from [fd00:1122:3344:101::b]:36516 | ||
637 | 2024.12.21 08:14:43.159738 [ 286 ] {} <Debug> TCP-Session: 892abc48-f4fc-4267-bc59-78f2fa5fc49d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
638 | 2024.12.21 08:14:43.159742 [ 287 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
639 | 2024.12.21 08:14:43.159742 [ 290 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:60374 | ||
640 | 2024.12.21 08:14:43.159811 [ 288 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
641 | 2024.12.21 08:14:43.159563 [ 289 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:55859 | ||
642 | 2024.12.21 08:14:43.159859 [ 287 ] {} <Debug> TCP-Session: 18aafa62-2736-4393-8bb6-50002a05c224 Authenticating user 'default' from [fd00:1122:3344:101::b]:49204 | ||
643 | 2024.12.21 08:14:43.159841 [ 286 ] {} <Debug> TCP-Session: 892abc48-f4fc-4267-bc59-78f2fa5fc49d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
644 | 2024.12.21 08:14:43.160056 [ 291 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:56550 | ||
645 | 2024.12.21 08:14:43.160066 [ 287 ] {} <Debug> TCP-Session: 18aafa62-2736-4393-8bb6-50002a05c224 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
646 | 2024.12.21 08:14:43.160159 [ 290 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
647 | 2024.12.21 08:14:43.160238 [ 287 ] {} <Debug> TCP-Session: 18aafa62-2736-4393-8bb6-50002a05c224 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
648 | 2024.12.21 08:14:43.160336 [ 288 ] {} <Debug> TCP-Session: 940ec303-d091-4e1d-98cd-52dff6518072 Authenticating user 'default' from [fd00:1122:3344:101::b]:49264 | ||
649 | 2024.12.21 08:14:43.160379 [ 292 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:42680 | ||
650 | 2024.12.21 08:14:43.160432 [ 291 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
651 | 2024.12.21 08:14:43.160537 [ 288 ] {} <Debug> TCP-Session: 940ec303-d091-4e1d-98cd-52dff6518072 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
652 | 2024.12.21 08:14:43.160569 [ 290 ] {} <Debug> TCP-Session: f672971a-b89d-406c-a567-3844abe50de9 Authenticating user 'default' from [fd00:1122:3344:101::b]:60374 | ||
653 | 2024.12.21 08:14:43.160678 [ 289 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
654 | 2024.12.21 08:14:43.160726 [ 291 ] {} <Debug> TCP-Session: c3b0d24d-081b-48bd-a10e-62ce5b77759d Authenticating user 'default' from [fd00:1122:3344:101::b]:56550 | ||
655 | 2024.12.21 08:14:43.160773 [ 290 ] {} <Debug> TCP-Session: f672971a-b89d-406c-a567-3844abe50de9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
656 | 2024.12.21 08:14:43.160794 [ 289 ] {} <Debug> TCP-Session: a9fd4296-3201-46da-b833-f2b7d7fe9471 Authenticating user 'default' from [fd00:1122:3344:101::b]:55859 | ||
657 | 2024.12.21 08:14:43.160751 [ 292 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
658 | 2024.12.21 08:14:43.160745 [ 288 ] {} <Debug> TCP-Session: 940ec303-d091-4e1d-98cd-52dff6518072 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
659 | 2024.12.21 08:14:43.160849 [ 291 ] {} <Debug> TCP-Session: c3b0d24d-081b-48bd-a10e-62ce5b77759d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
660 | 2024.12.21 08:14:43.160900 [ 289 ] {} <Debug> TCP-Session: a9fd4296-3201-46da-b833-f2b7d7fe9471 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
661 | 2024.12.21 08:14:43.160907 [ 290 ] {} <Debug> TCP-Session: f672971a-b89d-406c-a567-3844abe50de9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
662 | 2024.12.21 08:14:43.160961 [ 291 ] {} <Debug> TCP-Session: c3b0d24d-081b-48bd-a10e-62ce5b77759d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
663 | 2024.12.21 08:14:43.161020 [ 289 ] {} <Debug> TCP-Session: a9fd4296-3201-46da-b833-f2b7d7fe9471 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
664 | 2024.12.21 08:14:43.160935 [ 292 ] {} <Debug> TCP-Session: 2a327223-f05e-4702-9862-7212c5fd8222 Authenticating user 'default' from [fd00:1122:3344:101::b]:42680 | ||
665 | 2024.12.21 08:14:43.161183 [ 292 ] {} <Debug> TCP-Session: 2a327223-f05e-4702-9862-7212c5fd8222 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
666 | 2024.12.21 08:14:43.161242 [ 292 ] {} <Debug> TCP-Session: 2a327223-f05e-4702-9862-7212c5fd8222 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
667 | 2024.12.21 08:14:43.161519 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} <Debug> TCPHandler: Processed in 0.017834346 sec. | ||
668 | 2024.12.21 08:14:43.161743 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
669 | 2024.12.21 08:14:43.161984 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
670 | 2024.12.21 08:14:43.162084 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
671 | 2024.12.21 08:14:43.181558 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} <Debug> oximeter.fields_i8 (786e877c-c5e4-4e1b-a274-fb86ba5b15ff): Loading data parts | ||
672 | 2024.12.21 08:14:43.181792 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} <Debug> oximeter.fields_i8 (786e877c-c5e4-4e1b-a274-fb86ba5b15ff): There are no data parts | ||
673 | 2024.12.21 08:14:43.186508 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} <Debug> TCPHandler: Processed in 0.024819981 sec. | ||
674 | 2024.12.21 08:14:43.186711 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
675 | 2024.12.21 08:14:43.186946 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
676 | 2024.12.21 08:14:43.187014 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
677 | 2024.12.21 08:14:43.199239 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} <Debug> oximeter.fields_u8 (97fff6cd-17f2-4950-b474-4f35dba5a01a): Loading data parts | ||
678 | 2024.12.21 08:14:43.199496 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} <Debug> oximeter.fields_u8 (97fff6cd-17f2-4950-b474-4f35dba5a01a): There are no data parts | ||
679 | 2024.12.21 08:14:43.204251 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} <Debug> TCPHandler: Processed in 0.017622753 sec. | ||
680 | 2024.12.21 08:14:43.204449 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
681 | 2024.12.21 08:14:43.204645 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
682 | 2024.12.21 08:14:43.204714 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
683 | 2024.12.21 08:14:43.219281 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} <Debug> oximeter.fields_i16 (d1b38279-ba4f-4eae-8c53-fdee6982ff87): Loading data parts | ||
684 | 2024.12.21 08:14:43.219517 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} <Debug> oximeter.fields_i16 (d1b38279-ba4f-4eae-8c53-fdee6982ff87): There are no data parts | ||
685 | 2024.12.21 08:14:43.222296 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} <Debug> TCPHandler: Processed in 0.017902006 sec. | ||
686 | 2024.12.21 08:14:43.222495 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
687 | 2024.12.21 08:14:43.222719 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
688 | 2024.12.21 08:14:43.222781 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
689 | 2024.12.21 08:14:43.238338 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} <Debug> oximeter.fields_u16 (a499a5c3-9a96-4f73-9511-36feef801d32): Loading data parts | ||
690 | 2024.12.21 08:14:43.238511 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} <Debug> oximeter.fields_u16 (a499a5c3-9a96-4f73-9511-36feef801d32): There are no data parts | ||
691 | 2024.12.21 08:14:43.243844 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} <Debug> TCPHandler: Processed in 0.021410759 sec. | ||
692 | 2024.12.21 08:14:43.244043 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
693 | 2024.12.21 08:14:43.244231 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
694 | 2024.12.21 08:14:43.244315 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
695 | 2024.12.21 08:14:43.261712 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} <Debug> oximeter.fields_i32 (d4690000-2971-4edb-965d-2fdc0544aafd): Loading data parts | ||
696 | 2024.12.21 08:14:43.261994 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} <Debug> oximeter.fields_i32 (d4690000-2971-4edb-965d-2fdc0544aafd): There are no data parts | ||
697 | 2024.12.21 08:14:43.284966 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} <Debug> TCPHandler: Processed in 0.040976956 sec. | ||
698 | 2024.12.21 08:14:43.285153 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
699 | 2024.12.21 08:14:43.285378 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
700 | 2024.12.21 08:14:43.285442 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
701 | 2024.12.21 08:14:43.290830 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} <Debug> oximeter.fields_u32 (e71112b6-1b15-4450-a4ae-89ab415dd1dd): Loading data parts | ||
702 | 2024.12.21 08:14:43.291008 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} <Debug> oximeter.fields_u32 (e71112b6-1b15-4450-a4ae-89ab415dd1dd): There are no data parts | ||
703 | 2024.12.21 08:14:43.305672 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} <Debug> TCPHandler: Processed in 0.020572929 sec. | ||
704 | 2024.12.21 08:14:43.305902 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
705 | 2024.12.21 08:14:43.306098 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
706 | 2024.12.21 08:14:43.306167 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
707 | 2024.12.21 08:14:43.309355 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} <Debug> oximeter.fields_i64 (9eeeb106-2276-4a67-bee1-a97804ea7cac): Loading data parts | ||
708 | 2024.12.21 08:14:43.309528 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} <Debug> oximeter.fields_i64 (9eeeb106-2276-4a67-bee1-a97804ea7cac): There are no data parts | ||
709 | 2024.12.21 08:14:43.325294 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} <Debug> TCPHandler: Processed in 0.019435105 sec. | ||
710 | 2024.12.21 08:14:43.325788 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
711 | 2024.12.21 08:14:43.326232 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
712 | 2024.12.21 08:14:43.326459 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
713 | 2024.12.21 08:14:43.417388 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} <Debug> oximeter.fields_u64 (2f506b18-b675-4c6c-b8e9-71e0f7eec1f7): Loading data parts | ||
714 | 2024.12.21 08:14:43.417632 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} <Debug> oximeter.fields_u64 (2f506b18-b675-4c6c-b8e9-71e0f7eec1f7): There are no data parts | ||
715 | 2024.12.21 08:14:43.495274 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} <Debug> TCPHandler: Processed in 0.169715683 sec. | ||
716 | 2024.12.21 08:14:43.495598 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
717 | 2024.12.21 08:14:43.495921 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
718 | 2024.12.21 08:14:43.496041 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
719 | 2024.12.21 08:14:43.512273 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} <Debug> oximeter.fields_ipaddr (e7e94254-0eb2-4c88-abec-66e60d25e04f): Loading data parts | ||
720 | 2024.12.21 08:14:43.512474 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} <Debug> oximeter.fields_ipaddr (e7e94254-0eb2-4c88-abec-66e60d25e04f): There are no data parts | ||
721 | 2024.12.21 08:14:43.515000 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} <Debug> TCPHandler: Processed in 0.019549286 sec. | ||
722 | 2024.12.21 08:14:43.515212 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
723 | 2024.12.21 08:14:43.515440 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
724 | 2024.12.21 08:14:43.515520 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
725 | 2024.12.21 08:14:43.517473 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} <Debug> oximeter.fields_string (1061e971-4762-452b-ac64-fea9f861c8b0): Loading data parts | ||
726 | 2024.12.21 08:14:43.517717 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} <Debug> oximeter.fields_string (1061e971-4762-452b-ac64-fea9f861c8b0): There are no data parts | ||
727 | 2024.12.21 08:14:43.530718 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} <Debug> TCPHandler: Processed in 0.015562999 sec. | ||
728 | 2024.12.21 08:14:43.530913 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
729 | 2024.12.21 08:14:43.531118 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
730 | 2024.12.21 08:14:43.531207 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
731 | 2024.12.21 08:14:43.534225 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} <Debug> oximeter.fields_uuid (0a924dbb-8700-41c3-9aeb-443f5622a9ab): Loading data parts | ||
732 | 2024.12.21 08:14:43.534396 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} <Debug> oximeter.fields_uuid (0a924dbb-8700-41c3-9aeb-443f5622a9ab): There are no data parts | ||
733 | 2024.12.21 08:14:43.545960 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} <Debug> TCPHandler: Processed in 0.015102713 sec. | ||
734 | 2024.12.21 08:14:43.546205 [ 3 ] {} <Trace> TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
735 | 2024.12.21 08:14:43.546492 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:53728) /* The timeseries schema table stores the extracted schema for the samples | ||
736 | * oximeter collects. | ||
737 | */ | ||
738 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
739 | 2024.12.21 08:14:43.546590 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
740 | 2024.12.21 08:14:43.549405 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} <Debug> oximeter.timeseries_schema (c5c4abba-4e6e-4b03-8512-2b5b8b1f9c9c): Loading data parts | ||
741 | 2024.12.21 08:14:43.549598 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} <Debug> oximeter.timeseries_schema (c5c4abba-4e6e-4b03-8512-2b5b8b1f9c9c): There are no data parts | ||
742 | 2024.12.21 08:14:43.561400 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} <Debug> TCPHandler: Processed in 0.015250135 sec. | ||
743 | 2024.12.21 08:14:43.561598 [ 258 ] {} <Trace> TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
744 | 2024.12.21 08:14:43.561820 [ 258 ] {49f16a07-dddd-45b1-8063-278f9229448a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57520) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
745 | 2024.12.21 08:14:43.563054 [ 258 ] {49f16a07-dddd-45b1-8063-278f9229448a} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
746 | 2024.12.21 08:14:43.571289 [ 268 ] {49f16a07-dddd-45b1-8063-278f9229448a} <Trace> oximeter.version (d34c5ef1-ce0f-4147-b76e-f668c6b48f34): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
747 | 2024.12.21 08:14:43.571378 [ 268 ] {49f16a07-dddd-45b1-8063-278f9229448a} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. | ||
748 | 2024.12.21 08:14:43.575958 [ 268 ] {49f16a07-dddd-45b1-8063-278f9229448a} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
749 | 2024.12.21 08:14:43.576339 [ 268 ] {49f16a07-dddd-45b1-8063-278f9229448a} <Trace> oximeter.version (d34c5ef1-ce0f-4147-b76e-f668c6b48f34): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
750 | 2024.12.21 08:14:43.576660 [ 258 ] {49f16a07-dddd-45b1-8063-278f9229448a} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.014911 sec., 67.06458319361545 rows/sec., 1.05 KiB/sec. | ||
751 | 2024.12.21 08:14:43.576946 [ 258 ] {49f16a07-dddd-45b1-8063-278f9229448a} <Debug> TCPHandler: Processed in 0.015403547 sec. | ||
752 | 2024.12.21 08:14:44.000171 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 136.84 MiB, peak 136.84 MiB, free memory in arenas 0.00 B, will set to 141.49 MiB (RSS), difference: 4.65 MiB | ||
753 | 2024.12.21 08:14:49.997490 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
754 | 2024.12.21 08:14:49.997539 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488 | ||
755 | 2024.12.21 08:14:49.997623 [ 243 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
756 | 2024.12.21 08:14:49.997669 [ 244 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
757 | 2024.12.21 08:14:50.009091 [ 244 ] {} <Debug> system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Loading data parts | ||
758 | 2024.12.21 08:14:50.009644 [ 244 ] {} <Debug> system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): There are no data parts | ||
759 | 2024.12.21 08:14:50.016601 [ 244 ] {} <Trace> system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
760 | 2024.12.21 08:14:50.016723 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. | ||
761 | 2024.12.21 08:14:50.019874 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
762 | 2024.12.21 08:14:50.020581 [ 244 ] {} <Trace> system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
763 | 2024.12.21 08:14:50.021668 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488 | ||
764 | 2024.12.21 08:14:50.023043 [ 243 ] {} <Debug> system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Loading data parts | ||
765 | 2024.12.21 08:14:50.023257 [ 243 ] {} <Debug> system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): There are no data parts | ||
766 | 2024.12.21 08:14:50.050724 [ 243 ] {} <Trace> system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
767 | 2024.12.21 08:14:50.050770 [ 243 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. | ||
768 | 2024.12.21 08:14:50.058078 [ 243 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
769 | 2024.12.21 08:14:50.058818 [ 243 ] {} <Trace> system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
770 | 2024.12.21 08:14:50.061110 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
771 | 2024.12.21 08:14:51.000186 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 146.72 MiB, peak 150.72 MiB, free memory in arenas 0.00 B, will set to 151.02 MiB (RSS), difference: 4.30 MiB | ||
772 | 2024.12.21 08:14:52.497432 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 90 entries to flush up to offset 90 | ||
773 | 2024.12.21 08:14:52.497553 [ 242 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
774 | 2024.12.21 08:14:52.502747 [ 242 ] {} <Debug> system.query_log (1c862e4c-f56f-4030-b77e-00d41791255b): Loading data parts | ||
775 | 2024.12.21 08:14:52.502925 [ 242 ] {} <Debug> system.query_log (1c862e4c-f56f-4030-b77e-00d41791255b): There are no data parts | ||
776 | 2024.12.21 08:14:52.508743 [ 242 ] {} <Trace> system.query_log (1c862e4c-f56f-4030-b77e-00d41791255b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
777 | 2024.12.21 08:14:52.508784 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. | ||
778 | 2024.12.21 08:14:52.510424 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
779 | 2024.12.21 08:14:52.510727 [ 242 ] {} <Trace> system.query_log (1c862e4c-f56f-4030-b77e-00d41791255b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
780 | 2024.12.21 08:14:52.511227 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 90 | ||
781 | 2024.12.21 08:14:53.000186 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 155.20 MiB, peak 155.20 MiB, free memory in arenas 0.00 B, will set to 151.48 MiB (RSS), difference: -3.72 MiB | ||
782 | 2024.12.21 08:14:57.455162 [ 117 ] {} <Debug> DNSResolver: Updating DNS cache | ||
783 | 2024.12.21 08:14:57.455232 [ 117 ] {} <Debug> DNSResolver: Updated DNS cache | ||
784 | 2024.12.21 08:14:57.521808 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 976 | ||
785 | 2024.12.21 08:14:57.522699 [ 244 ] {} <Trace> system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
786 | 2024.12.21 08:14:57.522738 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. | ||
787 | 2024.12.21 08:14:57.523277 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
788 | 2024.12.21 08:14:57.523530 [ 244 ] {} <Trace> system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
789 | 2024.12.21 08:14:57.523762 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 976 | ||
790 | 2024.12.21 08:14:57.561231 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16 | ||
791 | 2024.12.21 08:14:57.584183 [ 243 ] {} <Trace> system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
792 | 2024.12.21 08:14:57.584244 [ 243 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. | ||
793 | 2024.12.21 08:14:57.591146 [ 243 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
794 | 2024.12.21 08:14:57.591876 [ 243 ] {} <Trace> system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
795 | 2024.12.21 08:14:57.594185 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 16 | ||
796 | 2024.12.21 08:14:58.000164 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 152.16 MiB, peak 156.16 MiB, free memory in arenas 0.00 B, will set to 154.09 MiB (RSS), difference: 1.93 MiB |