Max level shown:
1 2026.03.09 10:56:04.136317 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: 3042d295d963012962f5c683bd2776fa331a38c3, build id: <unknown>), PID 2945
2 2026.03.09 10:56:04.136501 [ 1 ] {} <Information> Application: starting up
3 2026.03.09 10:56:04.136546 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc
4 2026.03.09 10:56:04.156651 [ 1 ] {} <Information> Application: Available RAM: 250.63 GiB; physical cores: 32; logical cores: 32.
5 2026.03.09 10:56:04.160300 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536
6 2026.03.09 10:56:04.160333 [ 1 ] {} <Debug> Application: Initializing DateLUT.
7 2026.03.09 10:56:04.160340 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
8 2026.03.09 10:56:04.160365 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/datastore/tmp/ to store temporary data in it
9 2026.03.09 10:56:04.160770 [ 1 ] {} <Debug> Application: Initializing interserver credentials.
10 2026.03.09 10:56:04.161526 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/config.xml'
11 2026.03.09 10:56:04.162003 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/config.xml', performing update on configuration
12 2026.03.09 10:56:04.162310 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 225.57 GiB (250.63 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
13 2026.03.09 10:56:04.162332 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 125.32 GiB (250.63 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
14 2026.03.09 10:56:04.162340 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 125.32 GiB
15 2026.03.09 10:56:04.162474 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
16 2026.03.09 10:56:04.165135 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
17 2026.03.09 10:56:04.250773 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
18 2026.03.09 10:56:04.252234 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
19 2026.03.09 10:56:04.253831 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
20 2026.03.09 10:56:04.253924 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/config.xml', performed update on configuration
21 2026.03.09 10:56:04.257887 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/config.xml'
22 2026.03.09 10:56:04.270358 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/config.xml', performing update on configuration
23 2026.03.09 10:56:04.271715 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/config.xml', performed update on configuration
24 2026.03.09 10:56:04.272093 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/config.xml
25 2026.03.09 10:56:04.320539 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
26 2026.03.09 10:56:04.322214 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
27 2026.03.09 10:56:04.322637 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
28 2026.03.09 10:56:04.323386 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
29 2026.03.09 10:56:04.324269 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
30 2026.03.09 10:56:04.324294 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/datastore/
31 2026.03.09 10:56:04.324653 [ 187 ] {} <Debug> DNSResolver: Updating DNS cache
32 2026.03.09 10:56:04.324735 [ 187 ] {} <Debug> DNSResolver: Updated DNS cache
33 2026.03.09 10:56:04.326955 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
34 2026.03.09 10:56:04.326991 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000227444 sec
35 2026.03.09 10:56:04.327001 [ 1 ] {} <Trace> ReferentialDeps: No tables
36 2026.03.09 10:56:04.327020 [ 1 ] {} <Trace> LoadingDeps: No tables
37 2026.03.09 10:56:04.327250 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables.
38 2026.03.09 10:56:04.327324 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log
39 2026.03.09 10:56:04.333204 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
40 2026.03.09 10:56:04.333285 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
41 2026.03.09 10:56:04.333441 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
42 2026.03.09 10:56:04.333461 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
43 2026.03.09 10:56:04.333504 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
44 2026.03.09 10:56:04.333524 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
45 2026.03.09 10:56:04.337577 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
46 2026.03.09 10:56:04.337642 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
47 2026.03.09 10:56:04.337653 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
48 2026.03.09 10:56:04.337827 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
49 2026.03.09 10:56:04.337862 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
50 2026.03.09 10:56:04.337871 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
51 2026.03.09 10:56:04.337897 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
52 2026.03.09 10:56:04.337907 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
53 2026.03.09 10:56:04.337936 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
54 2026.03.09 10:56:04.337948 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
55 2026.03.09 10:56:04.369490 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
56 2026.03.09 10:56:04.406990 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
57 2026.03.09 10:56:04.407032 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000251951 sec
58 2026.03.09 10:56:04.407090 [ 1 ] {} <Trace> ReferentialDeps: No tables
59 2026.03.09 10:56:04.407097 [ 1 ] {} <Trace> LoadingDeps: No tables
60 2026.03.09 10:56:04.407133 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables.
61 2026.03.09 10:56:04.407310 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-be3221e1b6456e6e-test_update_status.2869.1-clickhouse-WIDR0s/datastore/user_defined/
62 2026.03.09 10:56:04.407355 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
63 2026.03.09 10:56:04.407362 [ 1 ] {} <Debug> Application: Loaded metadata.
64 2026.03.09 10:56:04.407368 [ 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).
65 2026.03.09 10:56:04.407373 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled.
66 2026.03.09 10:56:04.408266 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 33413
67 2026.03.09 10:56:04.408497 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 58474
68 2026.03.09 10:56:04.409115 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 63662
69 2026.03.09 10:56:04.409173 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 42636
70 2026.03.09 10:56:04.409202 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
71 2026.03.09 10:56:04.409450 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.78 MiB, peak 24.78 MiB, free memory in arenas 0.00 B, will set to 143.07 MiB (RSS), difference: 118.28 MiB
72 2026.03.09 10:56:04.409810 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.3608e-05 sec.
73 2026.03.09 10:56:04.410247 [ 1 ] {} <Information> Application: Listening for http://[::1]:33413
74 2026.03.09 10:56:04.410338 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:58474
75 2026.03.09 10:56:04.411951 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:63662
76 2026.03.09 10:56:04.412034 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:42636
77 2026.03.09 10:56:04.412054 [ 1 ] {} <Information> Application: Ready for connections.
78 2026.03.09 10:56:05.000451 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 143.08 MiB, peak 143.08 MiB, free memory in arenas 0.00 B, will set to 144.49 MiB (RSS), difference: 1.41 MiB
79 2026.03.09 10:56:06.551506 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:48675
80 2026.03.09 10:56:06.551900 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
81 2026.03.09 10:56:06.551953 [ 3 ] {} <Debug> TCP-Session: 904ab4fd-9d1d-4ee3-89ac-f6b9481599a2 Authenticating user 'default' from [::1]:48675
82 2026.03.09 10:56:06.551993 [ 3 ] {} <Debug> TCP-Session: 904ab4fd-9d1d-4ee3-89ac-f6b9481599a2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
83 2026.03.09 10:56:06.552045 [ 3 ] {} <Debug> TCP-Session: 904ab4fd-9d1d-4ee3-89ac-f6b9481599a2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
84 2026.03.09 10:56:06.552179 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
85 2026.03.09 10:56:06.552208 [ 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
86 2026.03.09 10:56:06.552227 [ 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
87 2026.03.09 10:56:06.552800 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:34442
88 2026.03.09 10:56:06.553134 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:38658
89 2026.03.09 10:56:06.553212 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
90 2026.03.09 10:56:06.553247 [ 4 ] {} <Debug> TCP-Session: 323d600f-6438-4aa9-b0d0-b0520461dafc Authenticating user 'default' from [::1]:34442
91 2026.03.09 10:56:06.553267 [ 4 ] {} <Debug> TCP-Session: 323d600f-6438-4aa9-b0d0-b0520461dafc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
92 2026.03.09 10:56:06.553282 [ 4 ] {} <Debug> TCP-Session: 323d600f-6438-4aa9-b0d0-b0520461dafc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
93 2026.03.09 10:56:06.553339 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37467
94 2026.03.09 10:56:06.553522 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57763
95 2026.03.09 10:56:06.554112 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:49232
96 2026.03.09 10:56:06.554058 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
97 2026.03.09 10:56:06.554131 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:49703
98 2026.03.09 10:56:06.554176 [ 255 ] {} <Debug> TCP-Session: 058481e0-27e3-4455-9932-4ba5395a7f0a Authenticating user 'default' from [::1]:38658
99 2026.03.09 10:56:06.554159 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
100 2026.03.09 10:56:06.554221 [ 255 ] {} <Debug> TCP-Session: 058481e0-27e3-4455-9932-4ba5395a7f0a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
101 2026.03.09 10:56:06.554271 [ 257 ] {} <Debug> TCP-Session: f8717cfd-d2ff-4590-8f86-6b98c96df474 Authenticating user 'default' from [::1]:37467
102 2026.03.09 10:56:06.554274 [ 255 ] {} <Debug> TCP-Session: 058481e0-27e3-4455-9932-4ba5395a7f0a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
103 2026.03.09 10:56:06.554291 [ 257 ] {} <Debug> TCP-Session: f8717cfd-d2ff-4590-8f86-6b98c96df474 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
104 2026.03.09 10:56:06.554298 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
105 2026.03.09 10:56:06.554308 [ 257 ] {} <Debug> TCP-Session: f8717cfd-d2ff-4590-8f86-6b98c96df474 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
106 2026.03.09 10:56:06.554324 [ 259 ] {} <Debug> TCP-Session: b5c2954a-661e-490e-9ca3-1066c6fe9331 Authenticating user 'default' from [::1]:49232
107 2026.03.09 10:56:06.554324 [ 260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:48458
108 2026.03.09 10:56:06.554344 [ 259 ] {} <Debug> TCP-Session: b5c2954a-661e-490e-9ca3-1066c6fe9331 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
109 2026.03.09 10:56:06.554367 [ 259 ] {} <Debug> TCP-Session: b5c2954a-661e-490e-9ca3-1066c6fe9331 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
110 2026.03.09 10:56:06.554626 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
111 2026.03.09 10:56:06.554656 [ 5 ] {} <Debug> TCP-Session: 84f6595e-d3a6-4c38-ba42-6ab5747456e6 Authenticating user 'default' from [::1]:49703
112 2026.03.09 10:56:06.554672 [ 5 ] {} <Debug> TCP-Session: 84f6595e-d3a6-4c38-ba42-6ab5747456e6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
113 2026.03.09 10:56:06.554691 [ 5 ] {} <Debug> TCP-Session: 84f6595e-d3a6-4c38-ba42-6ab5747456e6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
114 2026.03.09 10:56:06.554706 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
115 2026.03.09 10:56:06.554733 [ 258 ] {} <Debug> TCP-Session: 2c65f578-a249-4fa3-acf4-ee7af01bbc90 Authenticating user 'default' from [::1]:57763
116 2026.03.09 10:56:06.554745 [ 258 ] {} <Debug> TCP-Session: 2c65f578-a249-4fa3-acf4-ee7af01bbc90 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
117 2026.03.09 10:56:06.554760 [ 260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
118 2026.03.09 10:56:06.554783 [ 258 ] {} <Debug> TCP-Session: 2c65f578-a249-4fa3-acf4-ee7af01bbc90 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
119 2026.03.09 10:56:06.554808 [ 260 ] {} <Debug> TCP-Session: 73aa9ba8-dc9f-4687-9497-6d2256cfbd65 Authenticating user 'default' from [::1]:48458
120 2026.03.09 10:56:06.554837 [ 260 ] {} <Debug> TCP-Session: 73aa9ba8-dc9f-4687-9497-6d2256cfbd65 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
121 2026.03.09 10:56:06.554845 [ 260 ] {} <Debug> TCP-Session: 73aa9ba8-dc9f-4687-9497-6d2256cfbd65 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
122 2026.03.09 10:56:11.845582 [ 242 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488
123 2026.03.09 10:56:11.845635 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8
124 2026.03.09 10:56:11.845705 [ 242 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog
125 2026.03.09 10:56:11.845716 [ 243 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog
126 2026.03.09 10:56:11.848763 [ 242 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
127 2026.03.09 10:56:11.849159 [ 242 ] {} <Debug> system.asynchronous_metric_log (1c15f4d3-5264-4c35-ba4e-e6d5800b9e39): Loading data parts
128 2026.03.09 10:56:11.849860 [ 242 ] {} <Debug> system.asynchronous_metric_log (1c15f4d3-5264-4c35-ba4e-e6d5800b9e39): There are no data parts
129 2026.03.09 10:56:11.851719 [ 242 ] {} <Trace> system.asynchronous_metric_log (1c15f4d3-5264-4c35-ba4e-e6d5800b9e39): Trying to reserve 1.00 MiB using storage policy from min volume index 0
130 2026.03.09 10:56:11.851775 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 89.33 GiB.
131 2026.03.09 10:56:11.853560 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
132 2026.03.09 10:56:11.854002 [ 242 ] {} <Trace> system.asynchronous_metric_log (1c15f4d3-5264-4c35-ba4e-e6d5800b9e39): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
133 2026.03.09 10:56:11.854312 [ 242 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488
134 2026.03.09 10:56:11.858279 [ 243 ] {} <Debug> system.metric_log (eae2064e-920d-48b7-acf8-eab2cc22f2ea): Loading data parts
135 2026.03.09 10:56:11.858604 [ 243 ] {} <Debug> system.metric_log (eae2064e-920d-48b7-acf8-eab2cc22f2ea): There are no data parts
136 2026.03.09 10:56:11.886871 [ 243 ] {} <Trace> system.metric_log (eae2064e-920d-48b7-acf8-eab2cc22f2ea): Trying to reserve 1.00 MiB using storage policy from min volume index 0
137 2026.03.09 10:56:11.886977 [ 243 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 89.33 GiB.
138 2026.03.09 10:56:11.894050 [ 243 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
139 2026.03.09 10:56:11.895156 [ 243 ] {} <Trace> system.metric_log (eae2064e-920d-48b7-acf8-eab2cc22f2ea): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
140 2026.03.09 10:56:11.900005 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8
141 2026.03.09 10:56:12.000414 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 149.92 MiB, peak 153.92 MiB, free memory in arenas 0.00 B, will set to 160.39 MiB (RSS), difference: 10.47 MiB
142 2026.03.09 10:56:12.364161 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:61220
143 2026.03.09 10:56:12.364356 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
144 2026.03.09 10:56:12.364405 [ 262 ] {} <Debug> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Authenticating user 'default' from [::1]:61220
145 2026.03.09 10:56:12.364426 [ 262 ] {} <Debug> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
146 2026.03.09 10:56:12.364435 [ 262 ] {} <Debug> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
147 2026.03.09 10:56:12.366804 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:43674
148 2026.03.09 10:56:12.367302 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:55549
149 2026.03.09 10:56:12.367581 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56424
150 2026.03.09 10:56:12.367701 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:49885
151 2026.03.09 10:56:12.367803 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45019
152 2026.03.09 10:56:12.368059 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:49663
153 2026.03.09 10:56:12.368184 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:62985
154 2026.03.09 10:56:12.368268 [ 270 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57715
155 2026.03.09 10:56:12.368273 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
156 2026.03.09 10:56:12.368301 [ 263 ] {} <Debug> TCP-Session: 1114de2f-88e0-4d15-a583-94dad037b564 Authenticating user 'default' from [::1]:43674
157 2026.03.09 10:56:12.368332 [ 263 ] {} <Debug> TCP-Session: 1114de2f-88e0-4d15-a583-94dad037b564 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
158 2026.03.09 10:56:12.368341 [ 263 ] {} <Debug> TCP-Session: 1114de2f-88e0-4d15-a583-94dad037b564 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
159 2026.03.09 10:56:12.368451 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
160 2026.03.09 10:56:12.368474 [ 264 ] {} <Debug> TCP-Session: 1d01e0d9-2b89-48f5-ab2b-494555bb3fbe Authenticating user 'default' from [::1]:55549
161 2026.03.09 10:56:12.368473 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
162 2026.03.09 10:56:12.368483 [ 264 ] {} <Debug> TCP-Session: 1d01e0d9-2b89-48f5-ab2b-494555bb3fbe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
163 2026.03.09 10:56:12.368497 [ 265 ] {} <Debug> TCP-Session: 54feb12a-acad-45f5-a3c3-ba74ea80fbdf Authenticating user 'default' from [::1]:45019
164 2026.03.09 10:56:12.368499 [ 264 ] {} <Debug> TCP-Session: 1d01e0d9-2b89-48f5-ab2b-494555bb3fbe Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
165 2026.03.09 10:56:12.368511 [ 265 ] {} <Debug> TCP-Session: 54feb12a-acad-45f5-a3c3-ba74ea80fbdf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
166 2026.03.09 10:56:12.368517 [ 265 ] {} <Debug> TCP-Session: 54feb12a-acad-45f5-a3c3-ba74ea80fbdf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
167 2026.03.09 10:56:12.368531 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
168 2026.03.09 10:56:12.368552 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
169 2026.03.09 10:56:12.368555 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
170 2026.03.09 10:56:12.368603 [ 268 ] {} <Debug> TCP-Session: ff41bb75-dde1-4507-89ab-4a3587531d20 Authenticating user 'default' from [::1]:62985
171 2026.03.09 10:56:12.368615 [ 268 ] {} <Debug> TCP-Session: ff41bb75-dde1-4507-89ab-4a3587531d20 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
172 2026.03.09 10:56:12.368615 [ 266 ] {} <Debug> TCP-Session: f29d8c82-ee00-4bb9-9972-3779b9898f12 Authenticating user 'default' from [::1]:56424
173 2026.03.09 10:56:12.368663 [ 266 ] {} <Debug> TCP-Session: f29d8c82-ee00-4bb9-9972-3779b9898f12 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
174 2026.03.09 10:56:12.368625 [ 268 ] {} <Debug> TCP-Session: ff41bb75-dde1-4507-89ab-4a3587531d20 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
175 2026.03.09 10:56:12.368678 [ 266 ] {} <Debug> TCP-Session: f29d8c82-ee00-4bb9-9972-3779b9898f12 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
176 2026.03.09 10:56:12.368615 [ 270 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
177 2026.03.09 10:56:12.368722 [ 270 ] {} <Debug> TCP-Session: c8346167-5af6-4f8d-90cd-20e32bd4e749 Authenticating user 'default' from [::1]:57715
178 2026.03.09 10:56:12.368740 [ 270 ] {} <Debug> TCP-Session: c8346167-5af6-4f8d-90cd-20e32bd4e749 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
179 2026.03.09 10:56:12.368751 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
180 2026.03.09 10:56:12.368754 [ 270 ] {} <Debug> TCP-Session: c8346167-5af6-4f8d-90cd-20e32bd4e749 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
181 2026.03.09 10:56:12.368812 [ 269 ] {} <Debug> TCP-Session: 730d9db9-3b5b-44ec-9122-51ded546baaa Authenticating user 'default' from [::1]:49663
182 2026.03.09 10:56:12.368554 [ 267 ] {} <Debug> TCP-Session: a9a506fe-8980-49c5-a3af-c397f178a3f3 Authenticating user 'default' from [::1]:49885
183 2026.03.09 10:56:12.368828 [ 269 ] {} <Debug> TCP-Session: 730d9db9-3b5b-44ec-9122-51ded546baaa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
184 2026.03.09 10:56:12.368835 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
185 2026.03.09 10:56:12.368855 [ 267 ] {} <Debug> TCP-Session: a9a506fe-8980-49c5-a3af-c397f178a3f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
186 2026.03.09 10:56:12.368914 [ 267 ] {} <Debug> TCP-Session: a9a506fe-8980-49c5-a3af-c397f178a3f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
187 2026.03.09 10:56:12.368856 [ 269 ] {} <Debug> TCP-Session: 730d9db9-3b5b-44ec-9122-51ded546baaa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
188 2026.03.09 10:56:12.369416 [ 262 ] {998f6b3a-710b-4365-b11e-1451a03717f0} <Debug> executeQuery: (from [::1]:61220) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete)
189 2026.03.09 10:56:12.376872 [ 262 ] {998f6b3a-710b-4365-b11e-1451a03717f0} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:61220) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
190 
191 0. StackTrace::tryCapture() @ 0x000000000f9acdb7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
192 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f97f7df in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
193 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> >&&) @ 0x000000000a3c7817 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
194 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x00000000147ad091 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
195 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x000000001476347d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
196 5. DB::JoinedTables::getLeftTableStorage() @ 0x00000000148ec08b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
197 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>) @ 0x0000000014866701 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
198 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&) @ 0x0000000014864f66 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
199 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&) @ 0x00000000148b3d46 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
200 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&) @ 0x00000000148b2a83 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
201 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&) @ 0x000000001483d407 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
202 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x000000001483c8d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
203 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000014a5f216 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
204 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) @ 0x0000000014a5bd46 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
205 14. DB::TCPHandler::runImpl() @ 0x00000000153fbaaa in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
206 15. DB::TCPHandler::run() @ 0x000000001540bc5c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
207 16. Poco::Net::TCPServerConnection::start() @ 0x00000000187a058c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
208 17. Poco::Net::TCPServerDispatcher::run() @ 0x00000000187a0a61 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
209 18. Poco::PooledThread::run() @ 0x0000000018805972 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
210 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000018803425 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
211 20. _thrp_setup @ 0x0000000000116f97 in /lib/amd64/libc.so.1
212 
213 2026.03.09 10:56:12.377088 [ 262 ] {998f6b3a-710b-4365-b11e-1451a03717f0} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
214 
215 0. StackTrace::tryCapture() @ 0x000000000f9acdb7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
216 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f97f7df in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
217 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> >&&) @ 0x000000000a3c7817 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
218 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x00000000147ad091 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
219 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x000000001476347d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
220 5. DB::JoinedTables::getLeftTableStorage() @ 0x00000000148ec08b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
221 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>) @ 0x0000000014866701 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
222 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&) @ 0x0000000014864f66 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
223 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&) @ 0x00000000148b3d46 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
224 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&) @ 0x00000000148b2a83 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
225 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&) @ 0x000000001483d407 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
226 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x000000001483c8d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
227 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000014a5f216 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
228 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) @ 0x0000000014a5bd46 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
229 14. DB::TCPHandler::runImpl() @ 0x00000000153fbaaa in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
230 15. DB::TCPHandler::run() @ 0x000000001540bc5c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
231 16. Poco::Net::TCPServerConnection::start() @ 0x00000000187a058c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
232 17. Poco::Net::TCPServerDispatcher::run() @ 0x00000000187a0a61 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
233 18. Poco::PooledThread::run() @ 0x0000000018805972 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
234 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000018803425 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
235 20. _thrp_setup @ 0x0000000000116f97 in /lib/amd64/libc.so.1
236 
237 2026.03.09 10:56:12.377146 [ 262 ] {998f6b3a-710b-4365-b11e-1451a03717f0} <Debug> TCPHandler: Processed in 0.009394514 sec.
238 2026.03.09 10:56:12.386919 [ 264 ] {} <Trace> TCP-Session: 1d01e0d9-2b89-48f5-ab2b-494555bb3fbe Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
239 2026.03.09 10:56:12.387153 [ 264 ] {071d72f2-cb56-4bbd-9016-71ad80803c90} <Debug> executeQuery: (from [::1]:55549) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete)
240 2026.03.09 10:56:12.387550 [ 264 ] {071d72f2-cb56-4bbd-9016-71ad80803c90} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:55549) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
241 
242 0. StackTrace::tryCapture() @ 0x000000000f9acdb7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
243 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f97f7df in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
244 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> >&&) @ 0x000000000a3c7817 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
245 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x00000000147ad091 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
246 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x000000001476347d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
247 5. DB::JoinedTables::getLeftTableStorage() @ 0x00000000148ec08b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
248 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>) @ 0x0000000014866701 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
249 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&) @ 0x0000000014864f66 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
250 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&) @ 0x00000000148b3d46 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
251 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&) @ 0x00000000148b2a83 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
252 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&) @ 0x000000001483d407 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
253 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x000000001483c8d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
254 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000014a5f216 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
255 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) @ 0x0000000014a5bd46 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
256 14. DB::TCPHandler::runImpl() @ 0x00000000153fbaaa in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
257 15. DB::TCPHandler::run() @ 0x000000001540bc5c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
258 16. Poco::Net::TCPServerConnection::start() @ 0x00000000187a058c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
259 17. Poco::Net::TCPServerDispatcher::run() @ 0x00000000187a0a61 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
260 18. Poco::PooledThread::run() @ 0x0000000018805972 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
261 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000018803425 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
262 20. _thrp_setup @ 0x0000000000116f97 in /lib/amd64/libc.so.1
263 
264 2026.03.09 10:56:12.387689 [ 264 ] {071d72f2-cb56-4bbd-9016-71ad80803c90} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
265 
266 0. StackTrace::tryCapture() @ 0x000000000f9acdb7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
267 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000f97f7df in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
268 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> >&&) @ 0x000000000a3c7817 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
269 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x00000000147ad091 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
270 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x000000001476347d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
271 5. DB::JoinedTables::getLeftTableStorage() @ 0x00000000148ec08b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
272 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>) @ 0x0000000014866701 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
273 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&) @ 0x0000000014864f66 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
274 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&) @ 0x00000000148b3d46 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
275 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&) @ 0x00000000148b2a83 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
276 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&) @ 0x000000001483d407 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
277 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x000000001483c8d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
278 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000014a5f216 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
279 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) @ 0x0000000014a5bd46 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
280 14. DB::TCPHandler::runImpl() @ 0x00000000153fbaaa in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
281 15. DB::TCPHandler::run() @ 0x000000001540bc5c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
282 16. Poco::Net::TCPServerConnection::start() @ 0x00000000187a058c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
283 17. Poco::Net::TCPServerDispatcher::run() @ 0x00000000187a0a61 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
284 18. Poco::PooledThread::run() @ 0x0000000018805972 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
285 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000018803425 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
286 20. _thrp_setup @ 0x0000000000116f97 in /lib/amd64/libc.so.1
287 
288 2026.03.09 10:56:12.387746 [ 264 ] {071d72f2-cb56-4bbd-9016-71ad80803c90} <Debug> TCPHandler: Processed in 0.001056385 sec.
289 2026.03.09 10:56:12.402404 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
290 2026.03.09 10:56:12.402642 [ 262 ] {d021721a-e962-4282-9287-db077b2adcb0} <Debug> executeQuery: (from [::1]:61220) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
291 2026.03.09 10:56:12.402744 [ 262 ] {d021721a-e962-4282-9287-db077b2adcb0} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
292 2026.03.09 10:56:12.403223 [ 262 ] {d021721a-e962-4282-9287-db077b2adcb0} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
293 2026.03.09 10:56:12.403238 [ 262 ] {d021721a-e962-4282-9287-db077b2adcb0} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.5401e-05 sec
294 2026.03.09 10:56:12.403258 [ 262 ] {d021721a-e962-4282-9287-db077b2adcb0} <Trace> ReferentialDeps: No tables
295 2026.03.09 10:56:12.403264 [ 262 ] {d021721a-e962-4282-9287-db077b2adcb0} <Trace> LoadingDeps: No tables
296 2026.03.09 10:56:12.403284 [ 262 ] {d021721a-e962-4282-9287-db077b2adcb0} <Information> DatabaseAtomic (oximeter): Starting up tables.
297 2026.03.09 10:56:12.403369 [ 262 ] {d021721a-e962-4282-9287-db077b2adcb0} <Debug> TCPHandler: Processed in 0.001140732 sec.
298 2026.03.09 10:56:12.407156 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
299 2026.03.09 10:56:12.407395 [ 262 ] {8e07a5b9-822e-4905-a44d-d860b8e126f2} <Debug> executeQuery: (from [::1]:61220) /* The version table contains metadata about the `oximeter` database */
300 CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete)
301 2026.03.09 10:56:12.407490 [ 262 ] {8e07a5b9-822e-4905-a44d-d860b8e126f2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
302 2026.03.09 10:56:12.408566 [ 262 ] {8e07a5b9-822e-4905-a44d-d860b8e126f2} <Debug> oximeter.version (0ca79403-db1b-4f7f-b700-f590db7340dd): Loading data parts
303 2026.03.09 10:56:12.408932 [ 262 ] {8e07a5b9-822e-4905-a44d-d860b8e126f2} <Debug> oximeter.version (0ca79403-db1b-4f7f-b700-f590db7340dd): There are no data parts
304 2026.03.09 10:56:12.409494 [ 262 ] {8e07a5b9-822e-4905-a44d-d860b8e126f2} <Debug> TCPHandler: Processed in 0.002482232 sec.
305 2026.03.09 10:56:12.410732 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
306 2026.03.09 10:56:12.410940 [ 262 ] {f7d54dd2-2e03-413e-973a-afb5c66786e0} <Debug> executeQuery: (from [::1]:61220) /* The measurement tables contain all individual samples from each timeseries.
307 *
308 * Each table stores a single datum type, and otherwise contains nearly the same
309 * structure. The primary sorting key is on the timeseries name, key, and then
310 * timestamp, so that all timeseries from the same schema are grouped, followed
311 * by all samples from the same timeseries.
312 *
313 * This reflects that one usually looks up the _key_ in one or more field table,
314 * and then uses that to index quickly into the measurements tables.
315 */
316 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)
317 2026.03.09 10:56:12.411001 [ 262 ] {f7d54dd2-2e03-413e-973a-afb5c66786e0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
318 2026.03.09 10:56:12.412113 [ 262 ] {f7d54dd2-2e03-413e-973a-afb5c66786e0} <Debug> oximeter.measurements_bool (5130101e-e436-4979-889f-322769e37027): Loading data parts
319 2026.03.09 10:56:12.412488 [ 262 ] {f7d54dd2-2e03-413e-973a-afb5c66786e0} <Debug> oximeter.measurements_bool (5130101e-e436-4979-889f-322769e37027): There are no data parts
320 2026.03.09 10:56:12.412912 [ 262 ] {f7d54dd2-2e03-413e-973a-afb5c66786e0} <Debug> TCPHandler: Processed in 0.002262597 sec.
321 2026.03.09 10:56:12.413727 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
322 2026.03.09 10:56:12.413911 [ 262 ] {11dd9c1f-415a-4906-a2d9-0c3fd89557ce} <Debug> executeQuery: (from [::1]:61220) 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)
323 2026.03.09 10:56:12.413962 [ 262 ] {11dd9c1f-415a-4906-a2d9-0c3fd89557ce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
324 2026.03.09 10:56:12.414754 [ 262 ] {11dd9c1f-415a-4906-a2d9-0c3fd89557ce} <Debug> oximeter.measurements_i8 (56ad1d1b-9378-48de-843d-e015ab081723): Loading data parts
325 2026.03.09 10:56:12.415007 [ 262 ] {11dd9c1f-415a-4906-a2d9-0c3fd89557ce} <Debug> oximeter.measurements_i8 (56ad1d1b-9378-48de-843d-e015ab081723): There are no data parts
326 2026.03.09 10:56:12.415432 [ 262 ] {11dd9c1f-415a-4906-a2d9-0c3fd89557ce} <Debug> TCPHandler: Processed in 0.001778953 sec.
327 2026.03.09 10:56:12.416757 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
328 2026.03.09 10:56:12.416949 [ 262 ] {945c9c49-4adf-4117-9cb0-cd7d980073e4} <Debug> executeQuery: (from [::1]:61220) 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)
329 2026.03.09 10:56:12.417010 [ 262 ] {945c9c49-4adf-4117-9cb0-cd7d980073e4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
330 2026.03.09 10:56:12.417912 [ 262 ] {945c9c49-4adf-4117-9cb0-cd7d980073e4} <Debug> oximeter.measurements_u8 (ef62ece4-6c06-4397-8d6f-9fff417019a4): Loading data parts
331 2026.03.09 10:56:12.418277 [ 262 ] {945c9c49-4adf-4117-9cb0-cd7d980073e4} <Debug> oximeter.measurements_u8 (ef62ece4-6c06-4397-8d6f-9fff417019a4): There are no data parts
332 2026.03.09 10:56:12.418671 [ 262 ] {945c9c49-4adf-4117-9cb0-cd7d980073e4} <Debug> TCPHandler: Processed in 0.001990219 sec.
333 2026.03.09 10:56:12.422787 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
334 2026.03.09 10:56:12.423141 [ 262 ] {f465efb5-7420-4f9e-a673-9684634525fc} <Debug> executeQuery: (from [::1]:61220) 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)
335 2026.03.09 10:56:12.423227 [ 262 ] {f465efb5-7420-4f9e-a673-9684634525fc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
336 2026.03.09 10:56:12.424621 [ 262 ] {f465efb5-7420-4f9e-a673-9684634525fc} <Debug> oximeter.measurements_i16 (c7e85df0-86bd-46f2-9bd2-ffe16ec169c3): Loading data parts
337 2026.03.09 10:56:12.424921 [ 262 ] {f465efb5-7420-4f9e-a673-9684634525fc} <Debug> oximeter.measurements_i16 (c7e85df0-86bd-46f2-9bd2-ffe16ec169c3): There are no data parts
338 2026.03.09 10:56:12.425358 [ 262 ] {f465efb5-7420-4f9e-a673-9684634525fc} <Debug> TCPHandler: Processed in 0.002731904 sec.
339 2026.03.09 10:56:12.427073 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
340 2026.03.09 10:56:12.427273 [ 262 ] {11c09609-3a15-4b92-b0b5-3fe08582463d} <Debug> executeQuery: (from [::1]:61220) 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)
341 2026.03.09 10:56:12.427333 [ 262 ] {11c09609-3a15-4b92-b0b5-3fe08582463d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
342 2026.03.09 10:56:12.428362 [ 262 ] {11c09609-3a15-4b92-b0b5-3fe08582463d} <Debug> oximeter.measurements_u16 (4f73f24b-6d3d-4945-bbed-227fcea41aac): Loading data parts
343 2026.03.09 10:56:12.428643 [ 262 ] {11c09609-3a15-4b92-b0b5-3fe08582463d} <Debug> oximeter.measurements_u16 (4f73f24b-6d3d-4945-bbed-227fcea41aac): There are no data parts
344 2026.03.09 10:56:12.429055 [ 262 ] {11c09609-3a15-4b92-b0b5-3fe08582463d} <Debug> TCPHandler: Processed in 0.002057349 sec.
345 2026.03.09 10:56:12.429804 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
346 2026.03.09 10:56:12.430042 [ 262 ] {44151785-f899-4840-8e01-4b9f8b31d387} <Debug> executeQuery: (from [::1]:61220) 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)
347 2026.03.09 10:56:12.430086 [ 262 ] {44151785-f899-4840-8e01-4b9f8b31d387} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
348 2026.03.09 10:56:12.431072 [ 262 ] {44151785-f899-4840-8e01-4b9f8b31d387} <Debug> oximeter.measurements_i32 (fd3f8afa-60a0-4e11-b8f3-a40ec25be530): Loading data parts
349 2026.03.09 10:56:12.431296 [ 262 ] {44151785-f899-4840-8e01-4b9f8b31d387} <Debug> oximeter.measurements_i32 (fd3f8afa-60a0-4e11-b8f3-a40ec25be530): There are no data parts
350 2026.03.09 10:56:12.431745 [ 262 ] {44151785-f899-4840-8e01-4b9f8b31d387} <Debug> TCPHandler: Processed in 0.002001648 sec.
351 2026.03.09 10:56:12.432822 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
352 2026.03.09 10:56:12.432980 [ 262 ] {0f7529b8-0925-4382-acf8-3e6b1d379eb5} <Debug> executeQuery: (from [::1]:61220) 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)
353 2026.03.09 10:56:12.433081 [ 262 ] {0f7529b8-0925-4382-acf8-3e6b1d379eb5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
354 2026.03.09 10:56:12.434193 [ 262 ] {0f7529b8-0925-4382-acf8-3e6b1d379eb5} <Debug> oximeter.measurements_u32 (e7c8a635-fa07-4264-ad20-318754eddcc1): Loading data parts
355 2026.03.09 10:56:12.434458 [ 262 ] {0f7529b8-0925-4382-acf8-3e6b1d379eb5} <Debug> oximeter.measurements_u32 (e7c8a635-fa07-4264-ad20-318754eddcc1): There are no data parts
356 2026.03.09 10:56:12.434978 [ 262 ] {0f7529b8-0925-4382-acf8-3e6b1d379eb5} <Debug> TCPHandler: Processed in 0.002214704 sec.
357 2026.03.09 10:56:12.435467 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
358 2026.03.09 10:56:12.435726 [ 262 ] {7890d88a-7125-49be-bd78-53049da3f8c1} <Debug> executeQuery: (from [::1]:61220) 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)
359 2026.03.09 10:56:12.435784 [ 262 ] {7890d88a-7125-49be-bd78-53049da3f8c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
360 2026.03.09 10:56:12.436850 [ 262 ] {7890d88a-7125-49be-bd78-53049da3f8c1} <Debug> oximeter.measurements_i64 (4da29b89-614f-4773-bb97-758c329e4d4d): Loading data parts
361 2026.03.09 10:56:12.437061 [ 262 ] {7890d88a-7125-49be-bd78-53049da3f8c1} <Debug> oximeter.measurements_i64 (4da29b89-614f-4773-bb97-758c329e4d4d): There are no data parts
362 2026.03.09 10:56:12.437534 [ 262 ] {7890d88a-7125-49be-bd78-53049da3f8c1} <Debug> TCPHandler: Processed in 0.002208955 sec.
363 2026.03.09 10:56:12.438738 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
364 2026.03.09 10:56:12.438970 [ 262 ] {af250646-ff76-4340-8bd4-12096da251cc} <Debug> executeQuery: (from [::1]:61220) 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)
365 2026.03.09 10:56:12.439037 [ 262 ] {af250646-ff76-4340-8bd4-12096da251cc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
366 2026.03.09 10:56:12.439977 [ 262 ] {af250646-ff76-4340-8bd4-12096da251cc} <Debug> oximeter.measurements_u64 (0111f70f-5ba9-4122-af8a-fa162018b6a9): Loading data parts
367 2026.03.09 10:56:12.440315 [ 262 ] {af250646-ff76-4340-8bd4-12096da251cc} <Debug> oximeter.measurements_u64 (0111f70f-5ba9-4122-af8a-fa162018b6a9): There are no data parts
368 2026.03.09 10:56:12.440828 [ 262 ] {af250646-ff76-4340-8bd4-12096da251cc} <Debug> TCPHandler: Processed in 0.002177091 sec.
369 2026.03.09 10:56:12.442186 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
370 2026.03.09 10:56:12.442429 [ 262 ] {dbcca642-82f1-4b6e-a897-aacc5a1c4de8} <Debug> executeQuery: (from [::1]:61220) 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)
371 2026.03.09 10:56:12.442481 [ 262 ] {dbcca642-82f1-4b6e-a897-aacc5a1c4de8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
372 2026.03.09 10:56:12.443899 [ 262 ] {dbcca642-82f1-4b6e-a897-aacc5a1c4de8} <Debug> oximeter.measurements_f32 (7e564174-b816-46f3-83fb-7a5e07e3588e): Loading data parts
373 2026.03.09 10:56:12.444161 [ 262 ] {dbcca642-82f1-4b6e-a897-aacc5a1c4de8} <Debug> oximeter.measurements_f32 (7e564174-b816-46f3-83fb-7a5e07e3588e): There are no data parts
374 2026.03.09 10:56:12.444576 [ 262 ] {dbcca642-82f1-4b6e-a897-aacc5a1c4de8} <Debug> TCPHandler: Processed in 0.002479014 sec.
375 2026.03.09 10:56:12.446582 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
376 2026.03.09 10:56:12.446828 [ 262 ] {7b74d635-2da7-4a55-b727-21bfb1a53f8c} <Debug> executeQuery: (from [::1]:61220) 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)
377 2026.03.09 10:56:12.446908 [ 262 ] {7b74d635-2da7-4a55-b727-21bfb1a53f8c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
378 2026.03.09 10:56:12.447941 [ 262 ] {7b74d635-2da7-4a55-b727-21bfb1a53f8c} <Debug> oximeter.measurements_f64 (2d901f22-76ba-4190-9d54-54cc1b3a0a65): Loading data parts
379 2026.03.09 10:56:12.448228 [ 262 ] {7b74d635-2da7-4a55-b727-21bfb1a53f8c} <Debug> oximeter.measurements_f64 (2d901f22-76ba-4190-9d54-54cc1b3a0a65): There are no data parts
380 2026.03.09 10:56:12.448657 [ 262 ] {7b74d635-2da7-4a55-b727-21bfb1a53f8c} <Debug> TCPHandler: Processed in 0.002193948 sec.
381 2026.03.09 10:56:12.448974 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
382 2026.03.09 10:56:12.449166 [ 262 ] {ed1dfeee-445f-4259-a223-becd1cb14ab4} <Debug> executeQuery: (from [::1]:61220) 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)
383 2026.03.09 10:56:12.449224 [ 262 ] {ed1dfeee-445f-4259-a223-becd1cb14ab4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
384 2026.03.09 10:56:12.450020 [ 262 ] {ed1dfeee-445f-4259-a223-becd1cb14ab4} <Debug> oximeter.measurements_string (56bb374f-99d7-4193-a756-2044c5bf7759): Loading data parts
385 2026.03.09 10:56:12.450309 [ 262 ] {ed1dfeee-445f-4259-a223-becd1cb14ab4} <Debug> oximeter.measurements_string (56bb374f-99d7-4193-a756-2044c5bf7759): There are no data parts
386 2026.03.09 10:56:12.450812 [ 262 ] {ed1dfeee-445f-4259-a223-becd1cb14ab4} <Debug> TCPHandler: Processed in 0.001904113 sec.
387 2026.03.09 10:56:12.451620 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
388 2026.03.09 10:56:12.451822 [ 262 ] {84b292f4-ee62-4c29-83f7-92ea7a393c0d} <Debug> executeQuery: (from [::1]:61220) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /*
389 * NOTE: Right now we can't unambiguously record a nullable byte array.
390 * Arrays cannot be nested in `Nullable()` types, and encoding the array as
391 * a string isn't palatable for a few reasons.
392 * See: https://github.com/oxidecomputer/omicron/issues/4551 for more
393 * details.
394 */
395 datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
396 2026.03.09 10:56:12.451873 [ 262 ] {84b292f4-ee62-4c29-83f7-92ea7a393c0d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
397 2026.03.09 10:56:12.453170 [ 262 ] {84b292f4-ee62-4c29-83f7-92ea7a393c0d} <Debug> oximeter.measurements_bytes (b103cfce-cd52-4c79-bdbd-77aa2fefc97c): Loading data parts
398 2026.03.09 10:56:12.453483 [ 262 ] {84b292f4-ee62-4c29-83f7-92ea7a393c0d} <Debug> oximeter.measurements_bytes (b103cfce-cd52-4c79-bdbd-77aa2fefc97c): There are no data parts
399 2026.03.09 10:56:12.453946 [ 262 ] {84b292f4-ee62-4c29-83f7-92ea7a393c0d} <Debug> TCPHandler: Processed in 0.002409054 sec.
400 2026.03.09 10:56:12.456770 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
401 2026.03.09 10:56:12.457023 [ 262 ] {c5f4edc6-4070-4206-94fb-38e6811a1714} <Debug> executeQuery: (from [::1]:61220) 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)
402 2026.03.09 10:56:12.457101 [ 262 ] {c5f4edc6-4070-4206-94fb-38e6811a1714} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
403 2026.03.09 10:56:12.458223 [ 262 ] {c5f4edc6-4070-4206-94fb-38e6811a1714} <Debug> oximeter.measurements_cumulativei64 (91508217-4bc9-44de-9f2a-51368a530769): Loading data parts
404 2026.03.09 10:56:12.458525 [ 262 ] {c5f4edc6-4070-4206-94fb-38e6811a1714} <Debug> oximeter.measurements_cumulativei64 (91508217-4bc9-44de-9f2a-51368a530769): There are no data parts
405 2026.03.09 10:56:12.459132 [ 262 ] {c5f4edc6-4070-4206-94fb-38e6811a1714} <Debug> TCPHandler: Processed in 0.002570149 sec.
406 2026.03.09 10:56:12.460285 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
407 2026.03.09 10:56:12.460540 [ 262 ] {05d58caf-e34d-41c7-a5de-c70f4d98dfe9} <Debug> executeQuery: (from [::1]:61220) 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)
408 2026.03.09 10:56:12.460597 [ 262 ] {05d58caf-e34d-41c7-a5de-c70f4d98dfe9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
409 2026.03.09 10:56:12.461612 [ 262 ] {05d58caf-e34d-41c7-a5de-c70f4d98dfe9} <Debug> oximeter.measurements_cumulativeu64 (a86449c1-e302-438d-ab2c-4142d8890e4c): Loading data parts
410 2026.03.09 10:56:12.462442 [ 262 ] {05d58caf-e34d-41c7-a5de-c70f4d98dfe9} <Debug> oximeter.measurements_cumulativeu64 (a86449c1-e302-438d-ab2c-4142d8890e4c): There are no data parts
411 2026.03.09 10:56:12.463164 [ 262 ] {05d58caf-e34d-41c7-a5de-c70f4d98dfe9} <Debug> TCPHandler: Processed in 0.002953689 sec.
412 2026.03.09 10:56:12.463676 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
413 2026.03.09 10:56:12.463932 [ 262 ] {9609ec65-e3be-4ce6-9840-19e723261516} <Debug> executeQuery: (from [::1]:61220) 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)
414 2026.03.09 10:56:12.464005 [ 262 ] {9609ec65-e3be-4ce6-9840-19e723261516} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
415 2026.03.09 10:56:12.465053 [ 262 ] {9609ec65-e3be-4ce6-9840-19e723261516} <Debug> oximeter.measurements_cumulativef32 (3c3c8b2f-c583-4ea6-ad53-d1909f8a0255): Loading data parts
416 2026.03.09 10:56:12.465524 [ 262 ] {9609ec65-e3be-4ce6-9840-19e723261516} <Debug> oximeter.measurements_cumulativef32 (3c3c8b2f-c583-4ea6-ad53-d1909f8a0255): There are no data parts
417 2026.03.09 10:56:12.466212 [ 262 ] {9609ec65-e3be-4ce6-9840-19e723261516} <Debug> TCPHandler: Processed in 0.002708927 sec.
418 2026.03.09 10:56:12.466936 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
419 2026.03.09 10:56:12.467360 [ 262 ] {a2c539bf-55a4-4500-ab47-afac0f6c40e4} <Debug> executeQuery: (from [::1]:61220) 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)
420 2026.03.09 10:56:12.467445 [ 262 ] {a2c539bf-55a4-4500-ab47-afac0f6c40e4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
421 2026.03.09 10:56:12.468804 [ 262 ] {a2c539bf-55a4-4500-ab47-afac0f6c40e4} <Debug> oximeter.measurements_cumulativef64 (bf9de5bf-c4f8-4d4e-b199-821465a399ac): Loading data parts
422 2026.03.09 10:56:12.469095 [ 262 ] {a2c539bf-55a4-4500-ab47-afac0f6c40e4} <Debug> oximeter.measurements_cumulativef64 (bf9de5bf-c4f8-4d4e-b199-821465a399ac): There are no data parts
423 2026.03.09 10:56:12.469659 [ 262 ] {a2c539bf-55a4-4500-ab47-afac0f6c40e4} <Debug> TCPHandler: Processed in 0.002956379 sec.
424 2026.03.09 10:56:12.472743 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
425 2026.03.09 10:56:12.473057 [ 262 ] {b158e58d-804f-4954-bcf3-ced0b8433c48} <Debug> executeQuery: (from [::1]:61220) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /*
426 * NOTE: Array types cannot be Nullable, see
427 * https://clickhouse.com/docs/en/sql-reference/data-types/nullable
428 * for more details.
429 *
430 * This means we need to use empty arrays to indicate a missing value. This
431 * is unfortunate, and at this point relies on the fact that an
432 * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need
433 * to figure out another way to represent missing samples here.
434 */
435 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)
436 2026.03.09 10:56:12.473135 [ 262 ] {b158e58d-804f-4954-bcf3-ced0b8433c48} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
437 2026.03.09 10:56:12.474561 [ 262 ] {b158e58d-804f-4954-bcf3-ced0b8433c48} <Debug> oximeter.measurements_histogrami8 (1c6409f5-7146-4556-8785-971194520108): Loading data parts
438 2026.03.09 10:56:12.474940 [ 262 ] {b158e58d-804f-4954-bcf3-ced0b8433c48} <Debug> oximeter.measurements_histogrami8 (1c6409f5-7146-4556-8785-971194520108): There are no data parts
439 2026.03.09 10:56:12.475511 [ 262 ] {b158e58d-804f-4954-bcf3-ced0b8433c48} <Debug> TCPHandler: Processed in 0.002881071 sec.
440 2026.03.09 10:56:12.477338 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
441 2026.03.09 10:56:12.477587 [ 262 ] {a67beb2d-cc8e-4d7e-b765-143e9f4ebdca} <Debug> executeQuery: (from [::1]:61220) 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)
442 2026.03.09 10:56:12.477648 [ 262 ] {a67beb2d-cc8e-4d7e-b765-143e9f4ebdca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
443 2026.03.09 10:56:12.478776 [ 262 ] {a67beb2d-cc8e-4d7e-b765-143e9f4ebdca} <Debug> oximeter.measurements_histogramu8 (6a24600c-d7d9-43aa-9d6e-78b4a1647cfc): Loading data parts
444 2026.03.09 10:56:12.479064 [ 262 ] {a67beb2d-cc8e-4d7e-b765-143e9f4ebdca} <Debug> oximeter.measurements_histogramu8 (6a24600c-d7d9-43aa-9d6e-78b4a1647cfc): There are no data parts
445 2026.03.09 10:56:12.479552 [ 262 ] {a67beb2d-cc8e-4d7e-b765-143e9f4ebdca} <Debug> TCPHandler: Processed in 0.002291782 sec.
446 2026.03.09 10:56:12.480100 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
447 2026.03.09 10:56:12.480377 [ 262 ] {0bf56bb8-e039-4e29-9833-9952868ad724} <Debug> executeQuery: (from [::1]:61220) 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)
448 2026.03.09 10:56:12.480440 [ 262 ] {0bf56bb8-e039-4e29-9833-9952868ad724} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
449 2026.03.09 10:56:12.481368 [ 262 ] {0bf56bb8-e039-4e29-9833-9952868ad724} <Debug> oximeter.measurements_histogrami16 (e2d931d1-1280-4a39-ae7c-df141670109c): Loading data parts
450 2026.03.09 10:56:12.481521 [ 262 ] {0bf56bb8-e039-4e29-9833-9952868ad724} <Debug> oximeter.measurements_histogrami16 (e2d931d1-1280-4a39-ae7c-df141670109c): There are no data parts
451 2026.03.09 10:56:12.481851 [ 262 ] {0bf56bb8-e039-4e29-9833-9952868ad724} <Debug> TCPHandler: Processed in 0.001817057 sec.
452 2026.03.09 10:56:12.482229 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
453 2026.03.09 10:56:12.482447 [ 262 ] {ba3dba7e-f764-4c49-addf-d90f03f78e68} <Debug> executeQuery: (from [::1]:61220) 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)
454 2026.03.09 10:56:12.482501 [ 262 ] {ba3dba7e-f764-4c49-addf-d90f03f78e68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
455 2026.03.09 10:56:12.483598 [ 262 ] {ba3dba7e-f764-4c49-addf-d90f03f78e68} <Debug> oximeter.measurements_histogramu16 (0eef2db8-d3f1-4a01-ba5c-dc54d7d9b10c): Loading data parts
456 2026.03.09 10:56:12.483752 [ 262 ] {ba3dba7e-f764-4c49-addf-d90f03f78e68} <Debug> oximeter.measurements_histogramu16 (0eef2db8-d3f1-4a01-ba5c-dc54d7d9b10c): There are no data parts
457 2026.03.09 10:56:12.484135 [ 262 ] {ba3dba7e-f764-4c49-addf-d90f03f78e68} <Debug> TCPHandler: Processed in 0.001963743 sec.
458 2026.03.09 10:56:12.485362 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
459 2026.03.09 10:56:12.485918 [ 262 ] {af9dc7e5-8289-4a93-b0ce-42b08228804e} <Debug> executeQuery: (from [::1]:61220) 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)
460 2026.03.09 10:56:12.486025 [ 262 ] {af9dc7e5-8289-4a93-b0ce-42b08228804e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
461 2026.03.09 10:56:12.487635 [ 262 ] {af9dc7e5-8289-4a93-b0ce-42b08228804e} <Debug> oximeter.measurements_histogrami32 (17d5f00b-5426-47a5-b351-d80e00057427): Loading data parts
462 2026.03.09 10:56:12.488041 [ 262 ] {af9dc7e5-8289-4a93-b0ce-42b08228804e} <Debug> oximeter.measurements_histogrami32 (17d5f00b-5426-47a5-b351-d80e00057427): There are no data parts
463 2026.03.09 10:56:12.488627 [ 262 ] {af9dc7e5-8289-4a93-b0ce-42b08228804e} <Debug> TCPHandler: Processed in 0.003534829 sec.
464 2026.03.09 10:56:12.489022 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
465 2026.03.09 10:56:12.489356 [ 262 ] {15f2b0c2-ad75-49db-9b18-5d02f6041dfd} <Debug> executeQuery: (from [::1]:61220) 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)
466 2026.03.09 10:56:12.489430 [ 262 ] {15f2b0c2-ad75-49db-9b18-5d02f6041dfd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
467 2026.03.09 10:56:12.490587 [ 262 ] {15f2b0c2-ad75-49db-9b18-5d02f6041dfd} <Debug> oximeter.measurements_histogramu32 (c4df43c9-c1de-46ae-a901-7745b0c736eb): Loading data parts
468 2026.03.09 10:56:12.490863 [ 262 ] {15f2b0c2-ad75-49db-9b18-5d02f6041dfd} <Debug> oximeter.measurements_histogramu32 (c4df43c9-c1de-46ae-a901-7745b0c736eb): There are no data parts
469 2026.03.09 10:56:12.491415 [ 262 ] {15f2b0c2-ad75-49db-9b18-5d02f6041dfd} <Debug> TCPHandler: Processed in 0.002474974 sec.
470 2026.03.09 10:56:12.492120 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
471 2026.03.09 10:56:12.492347 [ 262 ] {32bd1e95-521d-4895-8952-e9ecef5f230a} <Debug> executeQuery: (from [::1]:61220) 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)
472 2026.03.09 10:56:12.492417 [ 262 ] {32bd1e95-521d-4895-8952-e9ecef5f230a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
473 2026.03.09 10:56:12.493402 [ 262 ] {32bd1e95-521d-4895-8952-e9ecef5f230a} <Debug> oximeter.measurements_histogrami64 (5453f50e-db9a-40fa-a811-56050bebef5a): Loading data parts
474 2026.03.09 10:56:12.493705 [ 262 ] {32bd1e95-521d-4895-8952-e9ecef5f230a} <Debug> oximeter.measurements_histogrami64 (5453f50e-db9a-40fa-a811-56050bebef5a): There are no data parts
475 2026.03.09 10:56:12.494557 [ 262 ] {32bd1e95-521d-4895-8952-e9ecef5f230a} <Debug> TCPHandler: Processed in 0.00249979 sec.
476 2026.03.09 10:56:12.495181 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
477 2026.03.09 10:56:12.495568 [ 262 ] {ddb839d3-d19d-4bbd-ad88-96735ec57866} <Debug> executeQuery: (from [::1]:61220) 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)
478 2026.03.09 10:56:12.495686 [ 262 ] {ddb839d3-d19d-4bbd-ad88-96735ec57866} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
479 2026.03.09 10:56:12.497044 [ 262 ] {ddb839d3-d19d-4bbd-ad88-96735ec57866} <Debug> oximeter.measurements_histogramu64 (3e9f13ed-9257-4580-a231-5851e04a8f1e): Loading data parts
480 2026.03.09 10:56:12.497208 [ 262 ] {ddb839d3-d19d-4bbd-ad88-96735ec57866} <Debug> oximeter.measurements_histogramu64 (3e9f13ed-9257-4580-a231-5851e04a8f1e): There are no data parts
481 2026.03.09 10:56:12.497599 [ 262 ] {ddb839d3-d19d-4bbd-ad88-96735ec57866} <Debug> TCPHandler: Processed in 0.002546373 sec.
482 2026.03.09 10:56:12.498359 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
483 2026.03.09 10:56:12.498611 [ 262 ] {b6b739a6-f60d-4736-ac2c-3751ea137be7} <Debug> executeQuery: (from [::1]:61220) 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)
484 2026.03.09 10:56:12.498682 [ 262 ] {b6b739a6-f60d-4736-ac2c-3751ea137be7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
485 2026.03.09 10:56:12.499953 [ 262 ] {b6b739a6-f60d-4736-ac2c-3751ea137be7} <Debug> oximeter.measurements_histogramf32 (4f1c26bc-e573-4a71-8c5f-7c944ee617d7): Loading data parts
486 2026.03.09 10:56:12.500117 [ 262 ] {b6b739a6-f60d-4736-ac2c-3751ea137be7} <Debug> oximeter.measurements_histogramf32 (4f1c26bc-e573-4a71-8c5f-7c944ee617d7): There are no data parts
487 2026.03.09 10:56:12.500528 [ 262 ] {b6b739a6-f60d-4736-ac2c-3751ea137be7} <Debug> TCPHandler: Processed in 0.002275485 sec.
488 2026.03.09 10:56:12.501864 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
489 2026.03.09 10:56:12.502233 [ 262 ] {560b6c27-a577-4bf2-9cea-e2caf6010ca5} <Debug> executeQuery: (from [::1]:61220) 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)
490 2026.03.09 10:56:12.502302 [ 262 ] {560b6c27-a577-4bf2-9cea-e2caf6010ca5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
491 2026.03.09 10:56:12.504221 [ 262 ] {560b6c27-a577-4bf2-9cea-e2caf6010ca5} <Debug> oximeter.measurements_histogramf64 (d520f3ee-e0b8-43be-a94d-6e0f8acd4c6a): Loading data parts
492 2026.03.09 10:56:12.504441 [ 262 ] {560b6c27-a577-4bf2-9cea-e2caf6010ca5} <Debug> oximeter.measurements_histogramf64 (d520f3ee-e0b8-43be-a94d-6e0f8acd4c6a): There are no data parts
493 2026.03.09 10:56:12.504859 [ 262 ] {560b6c27-a577-4bf2-9cea-e2caf6010ca5} <Debug> TCPHandler: Processed in 0.003109465 sec.
494 2026.03.09 10:56:12.505211 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
495 2026.03.09 10:56:12.505401 [ 262 ] {adbcecde-72d6-4ae9-9c44-5f1e24851f0f} <Debug> executeQuery: (from [::1]:61220) /* The field tables store named dimensions of each timeseries.
496 *
497 * As with the measurement tables, there is one field table for each field data
498 * type. Fields are deduplicated by using the "replacing merge tree", though
499 * this behavior **must not** be relied upon for query correctness.
500 *
501 * The index for the fields differs from the measurements, however. Rows are
502 * sorted by timeseries name, then field name, field value, and finally
503 * timeseries key. This reflects the most common pattern for looking them up:
504 * by field name and possibly value, within a timeseries. The resulting keys are
505 * usually then used to look up measurements.
506 *
507 * NOTE: We may want to consider a secondary index on these tables, sorting by
508 * timeseries name and then key, since it would improve lookups where one
509 * already has the key. Realistically though, these tables are quite small and
510 * so performance benefits will be low in absolute terms.
511 *
512 * TTL: We use a materialized column to expire old field table records. This
513 * column is generated automatically by the database whenever a new row is
514 * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *`
515 * query. Since these tables are `ReplacingMergeTree`s, that means the last
516 * record will remain during a deduplication, which will have the last
517 * timestamp. ClickHouse will then expire old data for us, similar to the
518 * measurement tables.
519 */
520 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)
521 2026.03.09 10:56:12.505469 [ 262 ] {adbcecde-72d6-4ae9-9c44-5f1e24851f0f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
522 2026.03.09 10:56:12.506304 [ 262 ] {adbcecde-72d6-4ae9-9c44-5f1e24851f0f} <Debug> oximeter.fields_bool (c23baec2-02d4-451a-9566-93183d120d2d): Loading data parts
523 2026.03.09 10:56:12.506513 [ 262 ] {adbcecde-72d6-4ae9-9c44-5f1e24851f0f} <Debug> oximeter.fields_bool (c23baec2-02d4-451a-9566-93183d120d2d): There are no data parts
524 2026.03.09 10:56:12.506907 [ 262 ] {adbcecde-72d6-4ae9-9c44-5f1e24851f0f} <Debug> TCPHandler: Processed in 0.001798449 sec.
525 2026.03.09 10:56:12.507254 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
526 2026.03.09 10:56:12.507483 [ 262 ] {e5999bf8-c65a-4a54-9fce-6be435368cda} <Debug> executeQuery: (from [::1]:61220) 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)
527 2026.03.09 10:56:12.507639 [ 262 ] {e5999bf8-c65a-4a54-9fce-6be435368cda} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
528 2026.03.09 10:56:12.508444 [ 262 ] {e5999bf8-c65a-4a54-9fce-6be435368cda} <Debug> oximeter.fields_i8 (bdccb187-5b49-424d-aef0-5ab9b98404c7): Loading data parts
529 2026.03.09 10:56:12.508764 [ 262 ] {e5999bf8-c65a-4a54-9fce-6be435368cda} <Debug> oximeter.fields_i8 (bdccb187-5b49-424d-aef0-5ab9b98404c7): There are no data parts
530 2026.03.09 10:56:12.509153 [ 262 ] {e5999bf8-c65a-4a54-9fce-6be435368cda} <Debug> TCPHandler: Processed in 0.001954785 sec.
531 2026.03.09 10:56:12.509423 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
532 2026.03.09 10:56:12.509611 [ 262 ] {fc7e5846-f705-44f3-acd2-f409ea2dd19a} <Debug> executeQuery: (from [::1]:61220) 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)
533 2026.03.09 10:56:12.509673 [ 262 ] {fc7e5846-f705-44f3-acd2-f409ea2dd19a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
534 2026.03.09 10:56:12.510996 [ 262 ] {fc7e5846-f705-44f3-acd2-f409ea2dd19a} <Debug> oximeter.fields_u8 (a29ba272-6c1f-4f47-bf56-7d23f6aec475): Loading data parts
535 2026.03.09 10:56:12.511295 [ 262 ] {fc7e5846-f705-44f3-acd2-f409ea2dd19a} <Debug> oximeter.fields_u8 (a29ba272-6c1f-4f47-bf56-7d23f6aec475): There are no data parts
536 2026.03.09 10:56:12.511703 [ 262 ] {fc7e5846-f705-44f3-acd2-f409ea2dd19a} <Debug> TCPHandler: Processed in 0.002341515 sec.
537 2026.03.09 10:56:12.511998 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
538 2026.03.09 10:56:12.512164 [ 262 ] {c6f586fb-6d47-47ff-b148-c2370fca6bdb} <Debug> executeQuery: (from [::1]:61220) 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)
539 2026.03.09 10:56:12.512216 [ 262 ] {c6f586fb-6d47-47ff-b148-c2370fca6bdb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
540 2026.03.09 10:56:12.513363 [ 262 ] {c6f586fb-6d47-47ff-b148-c2370fca6bdb} <Debug> oximeter.fields_i16 (54c04d71-ff51-4020-8e76-a1ae2f4e5f1b): Loading data parts
541 2026.03.09 10:56:12.513622 [ 262 ] {c6f586fb-6d47-47ff-b148-c2370fca6bdb} <Debug> oximeter.fields_i16 (54c04d71-ff51-4020-8e76-a1ae2f4e5f1b): There are no data parts
542 2026.03.09 10:56:12.514064 [ 262 ] {c6f586fb-6d47-47ff-b148-c2370fca6bdb} <Debug> TCPHandler: Processed in 0.002134797 sec.
543 2026.03.09 10:56:12.515237 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
544 2026.03.09 10:56:12.515427 [ 262 ] {9a49c842-1ac2-4e08-9bf8-021d73665ff1} <Debug> executeQuery: (from [::1]:61220) 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)
545 2026.03.09 10:56:12.515478 [ 262 ] {9a49c842-1ac2-4e08-9bf8-021d73665ff1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
546 2026.03.09 10:56:12.516565 [ 262 ] {9a49c842-1ac2-4e08-9bf8-021d73665ff1} <Debug> oximeter.fields_u16 (bf3a55cc-9185-4a21-821d-44991014bfcc): Loading data parts
547 2026.03.09 10:56:12.516958 [ 262 ] {9a49c842-1ac2-4e08-9bf8-021d73665ff1} <Debug> oximeter.fields_u16 (bf3a55cc-9185-4a21-821d-44991014bfcc): There are no data parts
548 2026.03.09 10:56:12.517645 [ 262 ] {9a49c842-1ac2-4e08-9bf8-021d73665ff1} <Debug> TCPHandler: Processed in 0.002487342 sec.
549 2026.03.09 10:56:12.518058 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
550 2026.03.09 10:56:12.518284 [ 262 ] {6f405b70-b04d-4ccd-af06-fd1c9df7bd8b} <Debug> executeQuery: (from [::1]:61220) 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)
551 2026.03.09 10:56:12.518415 [ 262 ] {6f405b70-b04d-4ccd-af06-fd1c9df7bd8b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
552 2026.03.09 10:56:12.520586 [ 262 ] {6f405b70-b04d-4ccd-af06-fd1c9df7bd8b} <Debug> oximeter.fields_i32 (b6a60808-686a-48ff-acbb-d0c8467523e4): Loading data parts
553 2026.03.09 10:56:12.520896 [ 262 ] {6f405b70-b04d-4ccd-af06-fd1c9df7bd8b} <Debug> oximeter.fields_i32 (b6a60808-686a-48ff-acbb-d0c8467523e4): There are no data parts
554 2026.03.09 10:56:12.521536 [ 262 ] {6f405b70-b04d-4ccd-af06-fd1c9df7bd8b} <Debug> TCPHandler: Processed in 0.003544227 sec.
555 2026.03.09 10:56:12.524297 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
556 2026.03.09 10:56:12.524628 [ 262 ] {df1142a6-2c05-425f-9c70-c4632bbedc8e} <Debug> executeQuery: (from [::1]:61220) 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)
557 2026.03.09 10:56:12.524701 [ 262 ] {df1142a6-2c05-425f-9c70-c4632bbedc8e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
558 2026.03.09 10:56:12.526437 [ 262 ] {df1142a6-2c05-425f-9c70-c4632bbedc8e} <Debug> oximeter.fields_u32 (7afb8db3-bda8-4b5f-9094-9d48cbf4cafd): Loading data parts
559 2026.03.09 10:56:12.527792 [ 262 ] {df1142a6-2c05-425f-9c70-c4632bbedc8e} <Debug> oximeter.fields_u32 (7afb8db3-bda8-4b5f-9094-9d48cbf4cafd): There are no data parts
560 2026.03.09 10:56:12.528821 [ 262 ] {df1142a6-2c05-425f-9c70-c4632bbedc8e} <Debug> TCPHandler: Processed in 0.004685539 sec.
561 2026.03.09 10:56:12.529383 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
562 2026.03.09 10:56:12.529617 [ 262 ] {bd85f3d7-7c70-4593-87a6-cb2100593c0c} <Debug> executeQuery: (from [::1]:61220) 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)
563 2026.03.09 10:56:12.529705 [ 262 ] {bd85f3d7-7c70-4593-87a6-cb2100593c0c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
564 2026.03.09 10:56:12.531284 [ 262 ] {bd85f3d7-7c70-4593-87a6-cb2100593c0c} <Debug> oximeter.fields_i64 (4a2c51fd-7bab-4576-9049-d352ed7434af): Loading data parts
565 2026.03.09 10:56:12.531743 [ 262 ] {bd85f3d7-7c70-4593-87a6-cb2100593c0c} <Debug> oximeter.fields_i64 (4a2c51fd-7bab-4576-9049-d352ed7434af): There are no data parts
566 2026.03.09 10:56:12.532322 [ 262 ] {bd85f3d7-7c70-4593-87a6-cb2100593c0c} <Debug> TCPHandler: Processed in 0.003090048 sec.
567 2026.03.09 10:56:12.535148 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
568 2026.03.09 10:56:12.535392 [ 262 ] {d7649a79-2dc3-4ee8-a441-4564c8fcfe6f} <Debug> executeQuery: (from [::1]:61220) 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)
569 2026.03.09 10:56:12.535458 [ 262 ] {d7649a79-2dc3-4ee8-a441-4564c8fcfe6f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
570 2026.03.09 10:56:12.536552 [ 262 ] {d7649a79-2dc3-4ee8-a441-4564c8fcfe6f} <Debug> oximeter.fields_u64 (afc2f8a9-3cd7-4b24-aa60-4a9c2bbf2d12): Loading data parts
571 2026.03.09 10:56:12.538006 [ 262 ] {d7649a79-2dc3-4ee8-a441-4564c8fcfe6f} <Debug> oximeter.fields_u64 (afc2f8a9-3cd7-4b24-aa60-4a9c2bbf2d12): There are no data parts
572 2026.03.09 10:56:12.538478 [ 262 ] {d7649a79-2dc3-4ee8-a441-4564c8fcfe6f} <Debug> TCPHandler: Processed in 0.003475528 sec.
573 2026.03.09 10:56:12.541037 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
574 2026.03.09 10:56:12.541321 [ 262 ] {c0154e65-2e77-48a1-997a-f5bde36d2193} <Debug> executeQuery: (from [::1]:61220) 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)
575 2026.03.09 10:56:12.541403 [ 262 ] {c0154e65-2e77-48a1-997a-f5bde36d2193} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
576 2026.03.09 10:56:12.542521 [ 262 ] {c0154e65-2e77-48a1-997a-f5bde36d2193} <Debug> oximeter.fields_ipaddr (9b06aedc-794f-493a-90ec-72278cfb2efb): Loading data parts
577 2026.03.09 10:56:12.542838 [ 262 ] {c0154e65-2e77-48a1-997a-f5bde36d2193} <Debug> oximeter.fields_ipaddr (9b06aedc-794f-493a-90ec-72278cfb2efb): There are no data parts
578 2026.03.09 10:56:12.543271 [ 262 ] {c0154e65-2e77-48a1-997a-f5bde36d2193} <Debug> TCPHandler: Processed in 0.002932553 sec.
579 2026.03.09 10:56:12.546272 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
580 2026.03.09 10:56:12.546621 [ 262 ] {c86a9f58-a817-43ae-8fe3-27dfd1051c91} <Debug> executeQuery: (from [::1]:61220) 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)
581 2026.03.09 10:56:12.546780 [ 262 ] {c86a9f58-a817-43ae-8fe3-27dfd1051c91} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
582 2026.03.09 10:56:12.548301 [ 262 ] {c86a9f58-a817-43ae-8fe3-27dfd1051c91} <Debug> oximeter.fields_string (a143e33a-636f-4a5b-b57f-3dc07e275121): Loading data parts
583 2026.03.09 10:56:12.548661 [ 262 ] {c86a9f58-a817-43ae-8fe3-27dfd1051c91} <Debug> oximeter.fields_string (a143e33a-636f-4a5b-b57f-3dc07e275121): There are no data parts
584 2026.03.09 10:56:12.549321 [ 262 ] {c86a9f58-a817-43ae-8fe3-27dfd1051c91} <Debug> TCPHandler: Processed in 0.003137001 sec.
585 2026.03.09 10:56:12.553700 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
586 2026.03.09 10:56:12.554084 [ 262 ] {dde12962-96f8-47c9-a636-748a77afa046} <Debug> executeQuery: (from [::1]:61220) 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)
587 2026.03.09 10:56:12.554216 [ 262 ] {dde12962-96f8-47c9-a636-748a77afa046} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
588 2026.03.09 10:56:12.555484 [ 262 ] {dde12962-96f8-47c9-a636-748a77afa046} <Debug> oximeter.fields_uuid (46f04f88-184a-4dd1-89b2-347ee0542637): Loading data parts
589 2026.03.09 10:56:12.555783 [ 262 ] {dde12962-96f8-47c9-a636-748a77afa046} <Debug> oximeter.fields_uuid (46f04f88-184a-4dd1-89b2-347ee0542637): There are no data parts
590 2026.03.09 10:56:12.556365 [ 262 ] {dde12962-96f8-47c9-a636-748a77afa046} <Debug> TCPHandler: Processed in 0.003070231 sec.
591 2026.03.09 10:56:12.557494 [ 262 ] {} <Trace> TCP-Session: 98126f6f-92c0-4113-95c9-b80f96e3b785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
592 2026.03.09 10:56:12.557957 [ 262 ] {1ba4402a-64df-4b86-ad12-bbb19266d62d} <Debug> executeQuery: (from [::1]:61220) /* The timeseries schema table stores the extracted schema for the samples
593 * oximeter collects.
594 */
595 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)
596 2026.03.09 10:56:12.561833 [ 262 ] {1ba4402a-64df-4b86-ad12-bbb19266d62d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
597 2026.03.09 10:56:12.564144 [ 262 ] {1ba4402a-64df-4b86-ad12-bbb19266d62d} <Debug> oximeter.timeseries_schema (da2cb6c1-b9fe-4c9e-9f13-0967af518c3a): Loading data parts
598 2026.03.09 10:56:12.564361 [ 262 ] {1ba4402a-64df-4b86-ad12-bbb19266d62d} <Debug> oximeter.timeseries_schema (da2cb6c1-b9fe-4c9e-9f13-0967af518c3a): There are no data parts
599 2026.03.09 10:56:12.564958 [ 262 ] {1ba4402a-64df-4b86-ad12-bbb19266d62d} <Debug> TCPHandler: Processed in 0.007585786 sec.
600 2026.03.09 10:56:12.565378 [ 264 ] {} <Trace> TCP-Session: 1d01e0d9-2b89-48f5-ab2b-494555bb3fbe Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
601 2026.03.09 10:56:12.565584 [ 264 ] {40cc6620-0f19-4063-bfe5-2630b901da1a} <Debug> executeQuery: (from [::1]:55549) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
602 2026.03.09 10:56:12.565741 [ 264 ] {40cc6620-0f19-4063-bfe5-2630b901da1a} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
603 2026.03.09 10:56:12.566911 [ 261 ] {40cc6620-0f19-4063-bfe5-2630b901da1a} <Trace> oximeter.version (0ca79403-db1b-4f7f-b700-f590db7340dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0
604 2026.03.09 10:56:12.566972 [ 261 ] {40cc6620-0f19-4063-bfe5-2630b901da1a} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 89.33 GiB.
605 2026.03.09 10:56:12.567484 [ 261 ] {40cc6620-0f19-4063-bfe5-2630b901da1a} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
606 2026.03.09 10:56:12.567746 [ 261 ] {40cc6620-0f19-4063-bfe5-2630b901da1a} <Trace> oximeter.version (0ca79403-db1b-4f7f-b700-f590db7340dd): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
607 2026.03.09 10:56:12.567937 [ 264 ] {40cc6620-0f19-4063-bfe5-2630b901da1a} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.002466 sec., 405.5150040551501 rows/sec., 6.34 KiB/sec.
608 2026.03.09 10:56:12.568111 [ 264 ] {40cc6620-0f19-4063-bfe5-2630b901da1a} <Debug> TCPHandler: Processed in 0.002837317 sec.
609 2026.03.09 10:56:13.000241 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 167.74 MiB, peak 167.74 MiB, free memory in arenas 0.00 B, will set to 169.18 MiB (RSS), difference: 1.44 MiB