Max level shown:
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