Max level shown:
1 2025.03.17 16:40:48.638136 [ 242361 ] {} <Information> SentryWriter: Sending crash reports is disabled
2 2025.03.17 16:40:48.638239 [ 242361 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
3 2025.03.17 16:40:48.743306 [ 242361 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 242361
4 2025.03.17 16:40:48.743374 [ 242361 ] {} <Information> Application: starting up
5 2025.03.17 16:40:48.743388 [ 242361 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64
6 2025.03.17 16:40:48.746148 [ 242361 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8.
7 2025.03.17 16:40:48.754282 [ 242361 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
8 2025.03.17 16:40:48.754308 [ 242361 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
9 2025.03.17 16:40:48.754353 [ 242361 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
10 2025.03.17 16:40:48.754370 [ 242361 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
11 2025.03.17 16:40:48.976394 [ 242361 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF)
12 2025.03.17 16:40:48.976445 [ 242361 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
13 2025.03.17 16:40:48.980146 [ 242361 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024).
14 2025.03.17 16:40:48.980162 [ 242361 ] {} <Debug> Application: rlimit on number of threads is 125612
15 2025.03.17 16:40:48.980169 [ 242361 ] {} <Debug> Application: Initializing DateLUT.
16 2025.03.17 16:40:48.980172 [ 242361 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
17 2025.03.17 16:40:48.980190 [ 242361 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/datastore/tmp/ to store temporary data in it
18 2025.03.17 16:40:48.980457 [ 242361 ] {} <Debug> Application: Initializing interserver credentials.
19 2025.03.17 16:40:48.980874 [ 242361 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/config.xml'
20 2025.03.17 16:40:48.981248 [ 242361 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/config.xml', performing update on configuration
21 2025.03.17 16:40:48.981726 [ 242361 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
22 2025.03.17 16:40:48.981737 [ 242361 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
23 2025.03.17 16:40:48.981742 [ 242361 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB
24 2025.03.17 16:40:48.981783 [ 242361 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
25 2025.03.17 16:40:48.982469 [ 242361 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
26 2025.03.17 16:40:49.013282 [ 242361 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
27 2025.03.17 16:40:49.014758 [ 242361 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
28 2025.03.17 16:40:49.017016 [ 242361 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
29 2025.03.17 16:40:49.017047 [ 242361 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/config.xml', performed update on configuration
30 2025.03.17 16:40:49.020585 [ 242361 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/config.xml'
31 2025.03.17 16:40:49.021375 [ 242361 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/config.xml', performing update on configuration
32 2025.03.17 16:40:49.022941 [ 242361 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/config.xml', performed update on configuration
33 2025.03.17 16:40:49.023241 [ 242361 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/config.xml
34 2025.03.17 16:40:49.024237 [ 242361 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
35 2025.03.17 16:40:49.025363 [ 242361 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
36 2025.03.17 16:40:49.025614 [ 242361 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
37 2025.03.17 16:40:49.025947 [ 242361 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
38 2025.03.17 16:40:49.026613 [ 242361 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
39 2025.03.17 16:40:49.026672 [ 242642 ] {} <Debug> DNSResolver: Updating DNS cache
40 2025.03.17 16:40:49.026859 [ 242642 ] {} <Debug> DNSResolver: Updated DNS cache
41 2025.03.17 16:40:49.026901 [ 242361 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/datastore/
42 2025.03.17 16:40:49.041455 [ 242361 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
43 2025.03.17 16:40:49.041488 [ 242361 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00011683 sec
44 2025.03.17 16:40:49.041495 [ 242361 ] {} <Trace> ReferentialDeps: No tables
45 2025.03.17 16:40:49.041501 [ 242361 ] {} <Trace> LoadingDeps: No tables
46 2025.03.17 16:40:49.041537 [ 242361 ] {} <Information> DatabaseAtomic (system): Starting up tables.
47 2025.03.17 16:40:49.041554 [ 242361 ] {} <Debug> SystemLog: Creating system.query_log from query_log
48 2025.03.17 16:40:49.042827 [ 242361 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
49 2025.03.17 16:40:49.042852 [ 242361 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
50 2025.03.17 16:40:49.042864 [ 242361 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
51 2025.03.17 16:40:49.042875 [ 242361 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
52 2025.03.17 16:40:49.042882 [ 242361 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
53 2025.03.17 16:40:49.042892 [ 242361 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log
54 2025.03.17 16:40:49.045338 [ 242361 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
55 2025.03.17 16:40:49.045854 [ 242361 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
56 2025.03.17 16:40:49.045878 [ 242361 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log
57 2025.03.17 16:40:49.046133 [ 242361 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
58 2025.03.17 16:40:49.046146 [ 242361 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
59 2025.03.17 16:40:49.046179 [ 242361 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
60 2025.03.17 16:40:49.046190 [ 242361 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
61 2025.03.17 16:40:49.046199 [ 242361 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
62 2025.03.17 16:40:49.046205 [ 242361 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
63 2025.03.17 16:40:49.046212 [ 242361 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
64 2025.03.17 16:40:49.067771 [ 242361 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
65 2025.03.17 16:40:49.071462 [ 242361 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
66 2025.03.17 16:40:49.071483 [ 242361 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.606e-05 sec
67 2025.03.17 16:40:49.071489 [ 242361 ] {} <Trace> ReferentialDeps: No tables
68 2025.03.17 16:40:49.071494 [ 242361 ] {} <Trace> LoadingDeps: No tables
69 2025.03.17 16:40:49.071515 [ 242361 ] {} <Information> DatabaseAtomic (default): Starting up tables.
70 2025.03.17 16:40:49.071611 [ 242361 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all_output-59963dfb91521ad2-test_omdb_success_cases.242309.1-clickhouse-cC9IM8/datastore/user_defined/
71 2025.03.17 16:40:49.071642 [ 242361 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
72 2025.03.17 16:40:49.071648 [ 242361 ] {} <Debug> Application: Loaded metadata.
73 2025.03.17 16:40:49.071669 [ 242361 ] {} <Information> Application: Tasks stats provider: procfs
74 2025.03.17 16:40:49.071675 [ 242361 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
75 2025.03.17 16:40:49.071745 [ 242361 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 39627
76 2025.03.17 16:40:49.071788 [ 242361 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 35629
77 2025.03.17 16:40:49.071936 [ 242361 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44193
78 2025.03.17 16:40:49.071969 [ 242361 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 45715
79 2025.03.17 16:40:49.071987 [ 242361 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
80 2025.03.17 16:40:49.072347 [ 242361 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.62 MiB, peak 20.62 MiB, free memory in arenas 9.76 MiB, will set to 374.52 MiB (RSS), difference: 353.90 MiB
81 2025.03.17 16:40:49.072869 [ 242361 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.702e-05 sec.
82 2025.03.17 16:40:49.073303 [ 242361 ] {} <Information> Application: Listening for http://[::1]:39627
83 2025.03.17 16:40:49.073347 [ 242361 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:35629
84 2025.03.17 16:40:49.073414 [ 242361 ] {} <Information> Application: Listening for http://127.0.0.1:44193
85 2025.03.17 16:40:49.073460 [ 242361 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:45715
86 2025.03.17 16:40:49.073469 [ 242361 ] {} <Information> Application: Ready for connections.
87 2025.03.17 16:40:50.535892 [ 242366 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44204
88 2025.03.17 16:40:50.540853 [ 242366 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
89 2025.03.17 16:40:50.540913 [ 242366 ] {} <Debug> TCP-Session: e72df328-bb29-4b07-9ded-f03739b8d1cf Authenticating user 'default' from [::1]:44204
90 2025.03.17 16:40:50.540930 [ 242366 ] {} <Debug> TCP-Session: e72df328-bb29-4b07-9ded-f03739b8d1cf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
91 2025.03.17 16:40:50.540937 [ 242366 ] {} <Debug> TCP-Session: e72df328-bb29-4b07-9ded-f03739b8d1cf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
92 2025.03.17 16:40:50.541028 [ 242366 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
93 2025.03.17 16:40:50.541054 [ 242366 ] {} <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
94 2025.03.17 16:40:50.541064 [ 242366 ] {} <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
95 2025.03.17 16:40:50.550123 [ 242367 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44206
96 2025.03.17 16:40:50.553106 [ 242367 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
97 2025.03.17 16:40:50.553620 [ 242367 ] {} <Debug> TCP-Session: a6b1e293-1bc5-4f75-b85e-2cebf3181a17 Authenticating user 'default' from [::1]:44206
98 2025.03.17 16:40:50.553643 [ 242367 ] {} <Debug> TCP-Session: a6b1e293-1bc5-4f75-b85e-2cebf3181a17 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
99 2025.03.17 16:40:50.553651 [ 242367 ] {} <Debug> TCP-Session: a6b1e293-1bc5-4f75-b85e-2cebf3181a17 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
100 2025.03.17 16:40:50.567084 [ 243051 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44212
101 2025.03.17 16:40:50.567211 [ 243051 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
102 2025.03.17 16:40:50.570791 [ 243051 ] {} <Debug> TCP-Session: 6ee3fde6-b645-4db9-b568-2e52e728dadb Authenticating user 'default' from [::1]:44212
103 2025.03.17 16:40:50.570818 [ 243051 ] {} <Debug> TCP-Session: 6ee3fde6-b645-4db9-b568-2e52e728dadb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
104 2025.03.17 16:40:50.570826 [ 243051 ] {} <Debug> TCP-Session: 6ee3fde6-b645-4db9-b568-2e52e728dadb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
105 2025.03.17 16:40:50.598336 [ 243054 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44218
106 2025.03.17 16:40:50.598346 [ 243052 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44214
107 2025.03.17 16:40:50.598418 [ 243050 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44210
108 2025.03.17 16:40:50.598570 [ 243050 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
109 2025.03.17 16:40:50.598607 [ 243050 ] {} <Debug> TCP-Session: ffd82942-c6f6-4ff9-b14e-0b0beae329d4 Authenticating user 'default' from [::1]:44210
110 2025.03.17 16:40:50.598624 [ 243050 ] {} <Debug> TCP-Session: ffd82942-c6f6-4ff9-b14e-0b0beae329d4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
111 2025.03.17 16:40:50.598631 [ 243050 ] {} <Debug> TCP-Session: ffd82942-c6f6-4ff9-b14e-0b0beae329d4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
112 2025.03.17 16:40:50.613347 [ 243052 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
113 2025.03.17 16:40:50.613377 [ 243053 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44216
114 2025.03.17 16:40:50.613347 [ 242368 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44208
115 2025.03.17 16:40:50.613426 [ 243052 ] {} <Debug> TCP-Session: 173d1ece-8521-4c66-8692-5fe63ba97b41 Authenticating user 'default' from [::1]:44214
116 2025.03.17 16:40:50.613446 [ 243052 ] {} <Debug> TCP-Session: 173d1ece-8521-4c66-8692-5fe63ba97b41 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
117 2025.03.17 16:40:50.613457 [ 243052 ] {} <Debug> TCP-Session: 173d1ece-8521-4c66-8692-5fe63ba97b41 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
118 2025.03.17 16:40:50.613528 [ 243054 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
119 2025.03.17 16:40:50.613551 [ 243054 ] {} <Debug> TCP-Session: a489e2e4-3938-4ee9-96b9-c25393ff6d16 Authenticating user 'default' from [::1]:44218
120 2025.03.17 16:40:50.613560 [ 243054 ] {} <Debug> TCP-Session: a489e2e4-3938-4ee9-96b9-c25393ff6d16 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
121 2025.03.17 16:40:50.613565 [ 243054 ] {} <Debug> TCP-Session: a489e2e4-3938-4ee9-96b9-c25393ff6d16 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
122 2025.03.17 16:40:50.613813 [ 242368 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
123 2025.03.17 16:40:50.614895 [ 242368 ] {} <Debug> TCP-Session: ae415a02-de0f-4062-8beb-913c3200ade5 Authenticating user 'default' from [::1]:44208
124 2025.03.17 16:40:50.614911 [ 242368 ] {} <Debug> TCP-Session: ae415a02-de0f-4062-8beb-913c3200ade5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
125 2025.03.17 16:40:50.614917 [ 242368 ] {} <Debug> TCP-Session: ae415a02-de0f-4062-8beb-913c3200ade5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
126 2025.03.17 16:40:50.613857 [ 243053 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
127 2025.03.17 16:40:50.615037 [ 243053 ] {} <Debug> TCP-Session: d9b9691d-6220-42b8-b5ba-5deaed53579a Authenticating user 'default' from [::1]:44216
128 2025.03.17 16:40:50.615047 [ 243053 ] {} <Debug> TCP-Session: d9b9691d-6220-42b8-b5ba-5deaed53579a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
129 2025.03.17 16:40:50.615053 [ 243053 ] {} <Debug> TCP-Session: d9b9691d-6220-42b8-b5ba-5deaed53579a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
130 2025.03.17 16:40:56.555038 [ 242859 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1722 entries to flush up to offset 1722
131 2025.03.17 16:40:56.555105 [ 242859 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog
132 2025.03.17 16:40:56.556158 [ 242859 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
133 2025.03.17 16:40:56.558204 [ 242856 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8
134 2025.03.17 16:40:56.558893 [ 242856 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog
135 2025.03.17 16:40:56.559687 [ 242859 ] {} <Debug> system.asynchronous_metric_log (0e9e5c8e-893f-4682-9cfd-b357a3c3e3a9): Loading data parts
136 2025.03.17 16:40:56.568143 [ 242859 ] {} <Debug> system.asynchronous_metric_log (0e9e5c8e-893f-4682-9cfd-b357a3c3e3a9): There are no data parts
137 2025.03.17 16:40:56.572690 [ 242856 ] {} <Debug> system.metric_log (c233b063-754f-4bc8-bd08-48c353aadc53): Loading data parts
138 2025.03.17 16:40:56.573935 [ 242859 ] {} <Trace> system.asynchronous_metric_log (0e9e5c8e-893f-4682-9cfd-b357a3c3e3a9): Trying to reserve 1.00 MiB using storage policy from min volume index 0
139 2025.03.17 16:40:56.573962 [ 242859 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.14 GiB.
140 2025.03.17 16:40:56.574727 [ 242859 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
141 2025.03.17 16:40:56.574958 [ 242859 ] {} <Trace> system.asynchronous_metric_log (0e9e5c8e-893f-4682-9cfd-b357a3c3e3a9): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
142 2025.03.17 16:40:56.575104 [ 242859 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1722
143 2025.03.17 16:40:56.575251 [ 242856 ] {} <Debug> system.metric_log (c233b063-754f-4bc8-bd08-48c353aadc53): There are no data parts
144 2025.03.17 16:40:56.615423 [ 242856 ] {} <Trace> system.metric_log (c233b063-754f-4bc8-bd08-48c353aadc53): Trying to reserve 1.00 MiB using storage policy from min volume index 0
145 2025.03.17 16:40:56.615469 [ 242856 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.14 GiB.
146 2025.03.17 16:40:56.627393 [ 242856 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
147 2025.03.17 16:40:56.628196 [ 242856 ] {} <Trace> system.metric_log (c233b063-754f-4bc8-bd08-48c353aadc53): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
148 2025.03.17 16:40:56.630546 [ 242856 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8
149 2025.03.17 16:40:57.001010 [ 242861 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 379.90 MiB, peak 383.90 MiB, free memory in arenas 18.50 MiB, will set to 384.34 MiB (RSS), difference: 4.44 MiB
150 2025.03.17 16:40:59.544876 [ 243409 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44220
151 2025.03.17 16:40:59.545006 [ 243409 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
152 2025.03.17 16:40:59.545043 [ 243409 ] {} <Debug> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Authenticating user 'default' from [::1]:44220
153 2025.03.17 16:40:59.545064 [ 243409 ] {} <Debug> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
154 2025.03.17 16:40:59.545073 [ 243409 ] {} <Debug> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
155 2025.03.17 16:40:59.553101 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
156 2025.03.17 16:40:59.553419 [ 243409 ] {e4007f50-f0cc-434b-9883-11bbb0458840} <Debug> executeQuery: (from [::1]:44220) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete)
157 2025.03.17 16:40:59.557511 [ 243409 ] {e4007f50-f0cc-434b-9883-11bbb0458840} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:44220) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
158 
159 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
160 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
161 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
162 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
163 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
164 5. 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<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
165 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
166 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
167 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
168 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
169 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
170 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
171 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
172 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
173 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
174 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
175 16. ? @ 0x00007f2f6586bac3 in ?
176 17. ? @ 0x00007f2f658fd850 in ?
177 
178 2025.03.17 16:40:59.557694 [ 243409 ] {e4007f50-f0cc-434b-9883-11bbb0458840} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
179 
180 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
181 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
182 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
183 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
184 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
185 5. 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<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
186 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
187 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
188 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
189 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
190 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
191 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
192 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
193 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
194 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
195 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
196 16. ? @ 0x00007f2f6586bac3 in ?
197 17. ? @ 0x00007f2f658fd850 in ?
198 
199 2025.03.17 16:40:59.557755 [ 243409 ] {e4007f50-f0cc-434b-9883-11bbb0458840} <Debug> TCPHandler: Processed in 0.004923364 sec.
200 2025.03.17 16:40:59.565858 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
201 2025.03.17 16:40:59.566070 [ 243409 ] {ee2996af-21e6-4d0c-a287-0ba4eb516704} <Debug> executeQuery: (from [::1]:44220) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete)
202 2025.03.17 16:40:59.566475 [ 243409 ] {ee2996af-21e6-4d0c-a287-0ba4eb516704} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:44220) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
203 
204 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
205 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
206 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
207 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
208 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
209 5. 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<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
210 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
211 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
212 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
213 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
214 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
215 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
216 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
217 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
218 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
219 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
220 16. ? @ 0x00007f2f6586bac3 in ?
221 17. ? @ 0x00007f2f658fd850 in ?
222 
223 2025.03.17 16:40:59.567559 [ 243409 ] {ee2996af-21e6-4d0c-a287-0ba4eb516704} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
224 
225 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
226 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
227 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
228 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
229 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
230 5. 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<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
231 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
232 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
233 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
234 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
235 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
236 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
237 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
238 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
239 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
240 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
241 16. ? @ 0x00007f2f6586bac3 in ?
242 17. ? @ 0x00007f2f658fd850 in ?
243 
244 2025.03.17 16:40:59.567609 [ 243409 ] {ee2996af-21e6-4d0c-a287-0ba4eb516704} <Debug> TCPHandler: Processed in 0.001934432 sec.
245 2025.03.17 16:40:59.572543 [ 243410 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44222
246 2025.03.17 16:40:59.572642 [ 243410 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
247 2025.03.17 16:40:59.572669 [ 243410 ] {} <Debug> TCP-Session: 6f7c7723-ab6c-4b30-a1eb-02afcda4615e Authenticating user 'default' from [::1]:44222
248 2025.03.17 16:40:59.572686 [ 243410 ] {} <Debug> TCP-Session: 6f7c7723-ab6c-4b30-a1eb-02afcda4615e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
249 2025.03.17 16:40:59.572692 [ 243410 ] {} <Debug> TCP-Session: 6f7c7723-ab6c-4b30-a1eb-02afcda4615e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
250 2025.03.17 16:40:59.572783 [ 243410 ] {} <Debug> TCPHandler: Done processing connection.
251 2025.03.17 16:40:59.572801 [ 243410 ] {} <Debug> TCP-Session: 6f7c7723-ab6c-4b30-a1eb-02afcda4615e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
252 2025.03.17 16:40:59.574322 [ 243412 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44226
253 2025.03.17 16:40:59.575910 [ 243412 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
254 2025.03.17 16:40:59.575942 [ 243412 ] {} <Debug> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Authenticating user 'default' from [::1]:44226
255 2025.03.17 16:40:59.575956 [ 243412 ] {} <Debug> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
256 2025.03.17 16:40:59.575962 [ 243412 ] {} <Debug> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
257 2025.03.17 16:40:59.582244 [ 243410 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44228
258 2025.03.17 16:40:59.582292 [ 243410 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
259 2025.03.17 16:40:59.582306 [ 243410 ] {} <Debug> TCP-Session: c3a159a3-396b-4813-813f-32daddfbb249 Authenticating user 'default' from [::1]:44228
260 2025.03.17 16:40:59.582322 [ 243410 ] {} <Debug> TCP-Session: c3a159a3-396b-4813-813f-32daddfbb249 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
261 2025.03.17 16:40:59.582330 [ 243410 ] {} <Debug> TCP-Session: c3a159a3-396b-4813-813f-32daddfbb249 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
262 2025.03.17 16:40:59.582589 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
263 2025.03.17 16:40:59.582769 [ 243412 ] {0b12b991-f907-45ab-8957-64d2b88316c9} <Debug> executeQuery: (from [::1]:44226) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
264 2025.03.17 16:40:59.582823 [ 243412 ] {0b12b991-f907-45ab-8957-64d2b88316c9} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
265 2025.03.17 16:40:59.587859 [ 243412 ] {0b12b991-f907-45ab-8957-64d2b88316c9} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
266 2025.03.17 16:40:59.587880 [ 243412 ] {0b12b991-f907-45ab-8957-64d2b88316c9} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.303e-05 sec
267 2025.03.17 16:40:59.587889 [ 243412 ] {0b12b991-f907-45ab-8957-64d2b88316c9} <Trace> ReferentialDeps: No tables
268 2025.03.17 16:40:59.587894 [ 243412 ] {0b12b991-f907-45ab-8957-64d2b88316c9} <Trace> LoadingDeps: No tables
269 2025.03.17 16:40:59.587924 [ 243412 ] {0b12b991-f907-45ab-8957-64d2b88316c9} <Information> DatabaseAtomic (oximeter): Starting up tables.
270 2025.03.17 16:40:59.588067 [ 243412 ] {0b12b991-f907-45ab-8957-64d2b88316c9} <Debug> TCPHandler: Processed in 0.010161298 sec.
271 2025.03.17 16:40:59.592897 [ 243411 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44224
272 2025.03.17 16:40:59.593009 [ 243411 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
273 2025.03.17 16:40:59.593030 [ 243411 ] {} <Debug> TCP-Session: 33bddf20-dffc-4ccc-b5b3-e645b476c542 Authenticating user 'default' from [::1]:44224
274 2025.03.17 16:40:59.593048 [ 243411 ] {} <Debug> TCP-Session: 33bddf20-dffc-4ccc-b5b3-e645b476c542 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
275 2025.03.17 16:40:59.593055 [ 243411 ] {} <Debug> TCP-Session: 33bddf20-dffc-4ccc-b5b3-e645b476c542 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
276 2025.03.17 16:40:59.599987 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
277 2025.03.17 16:40:59.600457 [ 243413 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44230
278 2025.03.17 16:40:59.602946 [ 243413 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
279 2025.03.17 16:40:59.602984 [ 243413 ] {} <Debug> TCP-Session: 8d9b3e59-0cd4-48cc-a2da-f648113dcd92 Authenticating user 'default' from [::1]:44230
280 2025.03.17 16:40:59.603002 [ 243413 ] {} <Debug> TCP-Session: 8d9b3e59-0cd4-48cc-a2da-f648113dcd92 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
281 2025.03.17 16:40:59.600586 [ 243415 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44234
282 2025.03.17 16:40:59.603008 [ 243412 ] {8fba77a4-b14a-4df0-b75d-c34e76428f19} <Debug> executeQuery: (from [::1]:44226) /* The version table contains metadata about the `oximeter` database */
283 CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete)
284 2025.03.17 16:40:59.603062 [ 243412 ] {8fba77a4-b14a-4df0-b75d-c34e76428f19} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
285 2025.03.17 16:40:59.603108 [ 243415 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
286 2025.03.17 16:40:59.603135 [ 243415 ] {} <Debug> TCP-Session: f248e01c-38a8-43bf-8484-6e17ebe9e6e6 Authenticating user 'default' from [::1]:44234
287 2025.03.17 16:40:59.603144 [ 243415 ] {} <Debug> TCP-Session: f248e01c-38a8-43bf-8484-6e17ebe9e6e6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
288 2025.03.17 16:40:59.603151 [ 243415 ] {} <Debug> TCP-Session: f248e01c-38a8-43bf-8484-6e17ebe9e6e6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
289 2025.03.17 16:40:59.603010 [ 243413 ] {} <Debug> TCP-Session: 8d9b3e59-0cd4-48cc-a2da-f648113dcd92 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
290 2025.03.17 16:40:59.600738 [ 243417 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44238
291 2025.03.17 16:40:59.600831 [ 243416 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44236
292 2025.03.17 16:40:59.603466 [ 243416 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
293 2025.03.17 16:40:59.603474 [ 243417 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
294 2025.03.17 16:40:59.603489 [ 243416 ] {} <Debug> TCP-Session: 431a49a4-8667-4c0c-8533-4f5edb0b7d20 Authenticating user 'default' from [::1]:44236
295 2025.03.17 16:40:59.603499 [ 243416 ] {} <Debug> TCP-Session: 431a49a4-8667-4c0c-8533-4f5edb0b7d20 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
296 2025.03.17 16:40:59.603505 [ 243416 ] {} <Debug> TCP-Session: 431a49a4-8667-4c0c-8533-4f5edb0b7d20 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
297 2025.03.17 16:40:59.600842 [ 243418 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44240
298 2025.03.17 16:40:59.600866 [ 243414 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44232
299 2025.03.17 16:40:59.603520 [ 243417 ] {} <Debug> TCP-Session: e731c5c4-f9a1-48e9-a82d-a45b9ef6c4d7 Authenticating user 'default' from [::1]:44238
300 2025.03.17 16:40:59.603603 [ 243417 ] {} <Debug> TCP-Session: e731c5c4-f9a1-48e9-a82d-a45b9ef6c4d7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
301 2025.03.17 16:40:59.603611 [ 243417 ] {} <Debug> TCP-Session: e731c5c4-f9a1-48e9-a82d-a45b9ef6c4d7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
302 2025.03.17 16:40:59.603691 [ 243414 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
303 2025.03.17 16:40:59.603716 [ 243414 ] {} <Debug> TCP-Session: 189f036d-9b1f-4681-8222-75438af46269 Authenticating user 'default' from [::1]:44232
304 2025.03.17 16:40:59.603726 [ 243414 ] {} <Debug> TCP-Session: 189f036d-9b1f-4681-8222-75438af46269 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
305 2025.03.17 16:40:59.603732 [ 243414 ] {} <Debug> TCP-Session: 189f036d-9b1f-4681-8222-75438af46269 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
306 2025.03.17 16:40:59.603988 [ 243418 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default.
307 2025.03.17 16:40:59.604017 [ 243418 ] {} <Debug> TCP-Session: 2f367a5b-e3b6-41b3-9a02-e2e540c5daec Authenticating user 'default' from [::1]:44240
308 2025.03.17 16:40:59.604027 [ 243418 ] {} <Debug> TCP-Session: 2f367a5b-e3b6-41b3-9a02-e2e540c5daec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
309 2025.03.17 16:40:59.604034 [ 243418 ] {} <Debug> TCP-Session: 2f367a5b-e3b6-41b3-9a02-e2e540c5daec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
310 2025.03.17 16:40:59.607397 [ 243412 ] {8fba77a4-b14a-4df0-b75d-c34e76428f19} <Debug> oximeter.version (36ca87dc-9588-4b9e-acda-6bbc739f9b06): Loading data parts
311 2025.03.17 16:40:59.607692 [ 243412 ] {8fba77a4-b14a-4df0-b75d-c34e76428f19} <Debug> oximeter.version (36ca87dc-9588-4b9e-acda-6bbc739f9b06): There are no data parts
312 2025.03.17 16:40:59.614547 [ 243412 ] {8fba77a4-b14a-4df0-b75d-c34e76428f19} <Debug> TCPHandler: Processed in 0.014756451 sec.
313 2025.03.17 16:40:59.615317 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
314 2025.03.17 16:40:59.617125 [ 243412 ] {5c3e7d35-fad5-44b2-9456-04c9875107f8} <Debug> executeQuery: (from [::1]:44226) /* The measurement tables contain all individual samples from each timeseries.
315 *
316 * Each table stores a single datum type, and otherwise contains nearly the same
317 * structure. The primary sorting key is on the timeseries name, key, and then
318 * timestamp, so that all timeseries from the same schema are grouped, followed
319 * by all samples from the same timeseries.
320 *
321 * This reflects that one usually looks up the _key_ in one or more field table,
322 * and then uses that to index quickly into the measurements tables.
323 */
324 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)
325 2025.03.17 16:40:59.617175 [ 243412 ] {5c3e7d35-fad5-44b2-9456-04c9875107f8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
326 2025.03.17 16:40:59.623518 [ 243412 ] {5c3e7d35-fad5-44b2-9456-04c9875107f8} <Debug> oximeter.measurements_bool (c43c1e2a-f868-454c-aa45-3b1d5ab270e6): Loading data parts
327 2025.03.17 16:40:59.623894 [ 243412 ] {5c3e7d35-fad5-44b2-9456-04c9875107f8} <Debug> oximeter.measurements_bool (c43c1e2a-f868-454c-aa45-3b1d5ab270e6): There are no data parts
328 2025.03.17 16:40:59.628630 [ 243412 ] {5c3e7d35-fad5-44b2-9456-04c9875107f8} <Debug> TCPHandler: Processed in 0.013412821 sec.
329 2025.03.17 16:40:59.629531 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
330 2025.03.17 16:40:59.629784 [ 243412 ] {b88b9b96-812e-4816-a2d0-e42dd14a15d1} <Debug> executeQuery: (from [::1]:44226) 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)
331 2025.03.17 16:40:59.629853 [ 243412 ] {b88b9b96-812e-4816-a2d0-e42dd14a15d1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
332 2025.03.17 16:40:59.635816 [ 243412 ] {b88b9b96-812e-4816-a2d0-e42dd14a15d1} <Debug> oximeter.measurements_i8 (2ea86e18-391e-43a0-b834-e6ba35494616): Loading data parts
333 2025.03.17 16:40:59.636468 [ 243412 ] {b88b9b96-812e-4816-a2d0-e42dd14a15d1} <Debug> oximeter.measurements_i8 (2ea86e18-391e-43a0-b834-e6ba35494616): There are no data parts
334 2025.03.17 16:40:59.641537 [ 243412 ] {b88b9b96-812e-4816-a2d0-e42dd14a15d1} <Debug> TCPHandler: Processed in 0.01207717 sec.
335 2025.03.17 16:40:59.642244 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
336 2025.03.17 16:40:59.644189 [ 243412 ] {7b7c9e77-e518-4209-babd-876ef8c9b519} <Debug> executeQuery: (from [::1]:44226) 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)
337 2025.03.17 16:40:59.644236 [ 243412 ] {7b7c9e77-e518-4209-babd-876ef8c9b519} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
338 2025.03.17 16:40:59.650385 [ 243412 ] {7b7c9e77-e518-4209-babd-876ef8c9b519} <Debug> oximeter.measurements_u8 (4fe98ded-89a2-491d-ad4a-4648dd7b9d7d): Loading data parts
339 2025.03.17 16:40:59.662084 [ 243412 ] {7b7c9e77-e518-4209-babd-876ef8c9b519} <Debug> oximeter.measurements_u8 (4fe98ded-89a2-491d-ad4a-4648dd7b9d7d): There are no data parts
340 2025.03.17 16:40:59.667356 [ 243412 ] {7b7c9e77-e518-4209-babd-876ef8c9b519} <Debug> TCPHandler: Processed in 0.02531512 sec.
341 2025.03.17 16:40:59.668118 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
342 2025.03.17 16:40:59.668407 [ 243412 ] {eb074e14-393a-413b-87b0-71bdeed5e6aa} <Debug> executeQuery: (from [::1]:44226) 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)
343 2025.03.17 16:40:59.668465 [ 243412 ] {eb074e14-393a-413b-87b0-71bdeed5e6aa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
344 2025.03.17 16:40:59.673125 [ 243412 ] {eb074e14-393a-413b-87b0-71bdeed5e6aa} <Debug> oximeter.measurements_i16 (51e23a2b-36dc-4d05-9a4f-ef1b3445e2b0): Loading data parts
345 2025.03.17 16:40:59.673387 [ 243412 ] {eb074e14-393a-413b-87b0-71bdeed5e6aa} <Debug> oximeter.measurements_i16 (51e23a2b-36dc-4d05-9a4f-ef1b3445e2b0): There are no data parts
346 2025.03.17 16:40:59.678991 [ 243412 ] {eb074e14-393a-413b-87b0-71bdeed5e6aa} <Debug> TCPHandler: Processed in 0.011191649 sec.
347 2025.03.17 16:40:59.679801 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
348 2025.03.17 16:40:59.680080 [ 243412 ] {94125ae1-bdbe-4d4f-b2ab-85f574c3981e} <Debug> executeQuery: (from [::1]:44226) 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)
349 2025.03.17 16:40:59.680130 [ 243412 ] {94125ae1-bdbe-4d4f-b2ab-85f574c3981e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
350 2025.03.17 16:40:59.685625 [ 243412 ] {94125ae1-bdbe-4d4f-b2ab-85f574c3981e} <Debug> oximeter.measurements_u16 (98e146da-b960-47c4-bacb-086f6f8f4e38): Loading data parts
351 2025.03.17 16:40:59.685935 [ 243412 ] {94125ae1-bdbe-4d4f-b2ab-85f574c3981e} <Debug> oximeter.measurements_u16 (98e146da-b960-47c4-bacb-086f6f8f4e38): There are no data parts
352 2025.03.17 16:40:59.689610 [ 243412 ] {94125ae1-bdbe-4d4f-b2ab-85f574c3981e} <Debug> TCPHandler: Processed in 0.009983978 sec.
353 2025.03.17 16:40:59.690119 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
354 2025.03.17 16:40:59.690437 [ 243412 ] {47ce2d78-148b-4e41-b2ee-bf6cfc9a1a17} <Debug> executeQuery: (from [::1]:44226) 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)
355 2025.03.17 16:40:59.690493 [ 243412 ] {47ce2d78-148b-4e41-b2ee-bf6cfc9a1a17} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
356 2025.03.17 16:40:59.698951 [ 243412 ] {47ce2d78-148b-4e41-b2ee-bf6cfc9a1a17} <Debug> oximeter.measurements_i32 (78a0fe3a-5a7d-4c95-86aa-a5568ed9ed88): Loading data parts
357 2025.03.17 16:40:59.701882 [ 243412 ] {47ce2d78-148b-4e41-b2ee-bf6cfc9a1a17} <Debug> oximeter.measurements_i32 (78a0fe3a-5a7d-4c95-86aa-a5568ed9ed88): There are no data parts
358 2025.03.17 16:40:59.705481 [ 243412 ] {47ce2d78-148b-4e41-b2ee-bf6cfc9a1a17} <Debug> TCPHandler: Processed in 0.015555493 sec.
359 2025.03.17 16:40:59.706348 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
360 2025.03.17 16:40:59.706630 [ 243412 ] {9f46d67a-768d-4445-9ab5-eaedf6e361eb} <Debug> executeQuery: (from [::1]:44226) 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)
361 2025.03.17 16:40:59.706683 [ 243412 ] {9f46d67a-768d-4445-9ab5-eaedf6e361eb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
362 2025.03.17 16:40:59.712314 [ 243412 ] {9f46d67a-768d-4445-9ab5-eaedf6e361eb} <Debug> oximeter.measurements_u32 (dd4f0e61-cdf9-4c51-988b-49e169704334): Loading data parts
363 2025.03.17 16:40:59.712626 [ 243412 ] {9f46d67a-768d-4445-9ab5-eaedf6e361eb} <Debug> oximeter.measurements_u32 (dd4f0e61-cdf9-4c51-988b-49e169704334): There are no data parts
364 2025.03.17 16:40:59.716931 [ 243412 ] {9f46d67a-768d-4445-9ab5-eaedf6e361eb} <Debug> TCPHandler: Processed in 0.010773919 sec.
365 2025.03.17 16:40:59.717566 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
366 2025.03.17 16:40:59.717839 [ 243412 ] {92af2762-5b87-4b94-97db-25f0940090a2} <Debug> executeQuery: (from [::1]:44226) 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)
367 2025.03.17 16:40:59.717897 [ 243412 ] {92af2762-5b87-4b94-97db-25f0940090a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
368 2025.03.17 16:40:59.725237 [ 243412 ] {92af2762-5b87-4b94-97db-25f0940090a2} <Debug> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Loading data parts
369 2025.03.17 16:40:59.725569 [ 243412 ] {92af2762-5b87-4b94-97db-25f0940090a2} <Debug> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): There are no data parts
370 2025.03.17 16:40:59.729519 [ 243412 ] {92af2762-5b87-4b94-97db-25f0940090a2} <Debug> TCPHandler: Processed in 0.01217713 sec.
371 2025.03.17 16:40:59.730315 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
372 2025.03.17 16:40:59.730653 [ 243412 ] {d24d89a5-6c37-44bb-a1a1-3643cc9d8522} <Debug> executeQuery: (from [::1]:44226) 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)
373 2025.03.17 16:40:59.730707 [ 243412 ] {d24d89a5-6c37-44bb-a1a1-3643cc9d8522} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
374 2025.03.17 16:40:59.737672 [ 243412 ] {d24d89a5-6c37-44bb-a1a1-3643cc9d8522} <Debug> oximeter.measurements_u64 (c77b72b8-8d29-4719-8e2d-986b17db0c38): Loading data parts
375 2025.03.17 16:40:59.738020 [ 243412 ] {d24d89a5-6c37-44bb-a1a1-3643cc9d8522} <Debug> oximeter.measurements_u64 (c77b72b8-8d29-4719-8e2d-986b17db0c38): There are no data parts
376 2025.03.17 16:40:59.742874 [ 243412 ] {d24d89a5-6c37-44bb-a1a1-3643cc9d8522} <Debug> TCPHandler: Processed in 0.01274742 sec.
377 2025.03.17 16:40:59.744702 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
378 2025.03.17 16:40:59.745604 [ 243412 ] {656ca976-f285-48c4-ac2c-039b0c82e888} <Debug> executeQuery: (from [::1]:44226) 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)
379 2025.03.17 16:40:59.745665 [ 243412 ] {656ca976-f285-48c4-ac2c-039b0c82e888} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
380 2025.03.17 16:40:59.754089 [ 243412 ] {656ca976-f285-48c4-ac2c-039b0c82e888} <Debug> oximeter.measurements_f32 (4542de2d-20fc-405c-be13-7db8952948a0): Loading data parts
381 2025.03.17 16:40:59.755166 [ 243412 ] {656ca976-f285-48c4-ac2c-039b0c82e888} <Debug> oximeter.measurements_f32 (4542de2d-20fc-405c-be13-7db8952948a0): There are no data parts
382 2025.03.17 16:40:59.760065 [ 243412 ] {656ca976-f285-48c4-ac2c-039b0c82e888} <Debug> TCPHandler: Processed in 0.015536483 sec.
383 2025.03.17 16:40:59.760767 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
384 2025.03.17 16:40:59.761045 [ 243412 ] {5a07e9a6-95e6-4bfd-8d19-e8dd90d04a8a} <Debug> executeQuery: (from [::1]:44226) 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)
385 2025.03.17 16:40:59.761099 [ 243412 ] {5a07e9a6-95e6-4bfd-8d19-e8dd90d04a8a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
386 2025.03.17 16:40:59.765325 [ 243412 ] {5a07e9a6-95e6-4bfd-8d19-e8dd90d04a8a} <Debug> oximeter.measurements_f64 (d52fee2b-7ac8-4d6d-8c1b-a9d41b5cf412): Loading data parts
387 2025.03.17 16:40:59.765634 [ 243412 ] {5a07e9a6-95e6-4bfd-8d19-e8dd90d04a8a} <Debug> oximeter.measurements_f64 (d52fee2b-7ac8-4d6d-8c1b-a9d41b5cf412): There are no data parts
388 2025.03.17 16:40:59.769141 [ 243412 ] {5a07e9a6-95e6-4bfd-8d19-e8dd90d04a8a} <Debug> TCPHandler: Processed in 0.008623237 sec.
389 2025.03.17 16:40:59.769650 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
390 2025.03.17 16:40:59.769921 [ 243412 ] {87fae9b2-fdc6-4ca6-bc72-776d8d2fc2f0} <Debug> executeQuery: (from [::1]:44226) 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)
391 2025.03.17 16:40:59.769975 [ 243412 ] {87fae9b2-fdc6-4ca6-bc72-776d8d2fc2f0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
392 2025.03.17 16:40:59.775482 [ 243412 ] {87fae9b2-fdc6-4ca6-bc72-776d8d2fc2f0} <Debug> oximeter.measurements_string (d3e19ccb-1ab6-409a-b589-86a6d1631a70): Loading data parts
393 2025.03.17 16:40:59.775782 [ 243412 ] {87fae9b2-fdc6-4ca6-bc72-776d8d2fc2f0} <Debug> oximeter.measurements_string (d3e19ccb-1ab6-409a-b589-86a6d1631a70): There are no data parts
394 2025.03.17 16:40:59.781518 [ 243412 ] {87fae9b2-fdc6-4ca6-bc72-776d8d2fc2f0} <Debug> TCPHandler: Processed in 0.0120437 sec.
395 2025.03.17 16:40:59.782909 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
396 2025.03.17 16:40:59.783175 [ 243412 ] {74399402-ff42-4b93-a791-6d94b4b3dc0d} <Debug> executeQuery: (from [::1]:44226) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /*
397 * NOTE: Right now we can't unambiguously record a nullable byte array.
398 * Arrays cannot be nested in `Nullable()` types, and encoding the array as
399 * a string isn't palatable for a few reasons.
400 * See: https://github.com/oxidecomputer/omicron/issues/4551 for more
401 * details.
402 */
403 datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
404 2025.03.17 16:40:59.783227 [ 243412 ] {74399402-ff42-4b93-a791-6d94b4b3dc0d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
405 2025.03.17 16:40:59.787670 [ 243412 ] {74399402-ff42-4b93-a791-6d94b4b3dc0d} <Debug> oximeter.measurements_bytes (8f1252b8-b0d9-4071-8f6f-2d5486b848cc): Loading data parts
406 2025.03.17 16:40:59.787936 [ 243412 ] {74399402-ff42-4b93-a791-6d94b4b3dc0d} <Debug> oximeter.measurements_bytes (8f1252b8-b0d9-4071-8f6f-2d5486b848cc): There are no data parts
407 2025.03.17 16:40:59.792878 [ 243412 ] {74399402-ff42-4b93-a791-6d94b4b3dc0d} <Debug> TCPHandler: Processed in 0.010140498 sec.
408 2025.03.17 16:40:59.793338 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
409 2025.03.17 16:40:59.793604 [ 243412 ] {bda8bb9f-ff3b-41f7-a3b9-d7382824bf3d} <Debug> executeQuery: (from [::1]:44226) 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)
410 2025.03.17 16:40:59.795070 [ 243412 ] {bda8bb9f-ff3b-41f7-a3b9-d7382824bf3d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
411 2025.03.17 16:40:59.800340 [ 243412 ] {bda8bb9f-ff3b-41f7-a3b9-d7382824bf3d} <Debug> oximeter.measurements_cumulativei64 (72be8067-277e-4822-93ac-6a0286eda0e2): Loading data parts
412 2025.03.17 16:40:59.800661 [ 243412 ] {bda8bb9f-ff3b-41f7-a3b9-d7382824bf3d} <Debug> oximeter.measurements_cumulativei64 (72be8067-277e-4822-93ac-6a0286eda0e2): There are no data parts
413 2025.03.17 16:40:59.805422 [ 243412 ] {bda8bb9f-ff3b-41f7-a3b9-d7382824bf3d} <Debug> TCPHandler: Processed in 0.0122521 sec.
414 2025.03.17 16:40:59.806108 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
415 2025.03.17 16:40:59.806422 [ 243412 ] {fb41e0b4-71e9-4b47-8a15-fb92dfb6e606} <Debug> executeQuery: (from [::1]:44226) 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)
416 2025.03.17 16:40:59.806484 [ 243412 ] {fb41e0b4-71e9-4b47-8a15-fb92dfb6e606} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
417 2025.03.17 16:40:59.811131 [ 243412 ] {fb41e0b4-71e9-4b47-8a15-fb92dfb6e606} <Debug> oximeter.measurements_cumulativeu64 (a19e86f7-3ef0-4ee9-9bef-cb46cb5c3d4e): Loading data parts
418 2025.03.17 16:40:59.811439 [ 243412 ] {fb41e0b4-71e9-4b47-8a15-fb92dfb6e606} <Debug> oximeter.measurements_cumulativeu64 (a19e86f7-3ef0-4ee9-9bef-cb46cb5c3d4e): There are no data parts
419 2025.03.17 16:40:59.816842 [ 243412 ] {fb41e0b4-71e9-4b47-8a15-fb92dfb6e606} <Debug> TCPHandler: Processed in 0.011008539 sec.
420 2025.03.17 16:40:59.817655 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
421 2025.03.17 16:40:59.819199 [ 243412 ] {4d690e10-8c4d-45f7-a240-e553e6d562d0} <Debug> executeQuery: (from [::1]:44226) 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)
422 2025.03.17 16:40:59.819261 [ 243412 ] {4d690e10-8c4d-45f7-a240-e553e6d562d0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
423 2025.03.17 16:40:59.824391 [ 243412 ] {4d690e10-8c4d-45f7-a240-e553e6d562d0} <Debug> oximeter.measurements_cumulativef32 (6cfefb56-e1a9-415c-9932-854d2e510389): Loading data parts
424 2025.03.17 16:40:59.824623 [ 243412 ] {4d690e10-8c4d-45f7-a240-e553e6d562d0} <Debug> oximeter.measurements_cumulativef32 (6cfefb56-e1a9-415c-9932-854d2e510389): There are no data parts
425 2025.03.17 16:40:59.849155 [ 243412 ] {4d690e10-8c4d-45f7-a240-e553e6d562d0} <Debug> TCPHandler: Processed in 0.031809895 sec.
426 2025.03.17 16:40:59.849626 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
427 2025.03.17 16:40:59.849882 [ 243412 ] {1c95ec76-bada-4c68-9cf7-cf0d310de9de} <Debug> executeQuery: (from [::1]:44226) 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)
428 2025.03.17 16:40:59.849940 [ 243412 ] {1c95ec76-bada-4c68-9cf7-cf0d310de9de} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
429 2025.03.17 16:40:59.856379 [ 243412 ] {1c95ec76-bada-4c68-9cf7-cf0d310de9de} <Debug> oximeter.measurements_cumulativef64 (609bf1e8-ab69-4686-b40b-557fd72f2841): Loading data parts
430 2025.03.17 16:40:59.856637 [ 243412 ] {1c95ec76-bada-4c68-9cf7-cf0d310de9de} <Debug> oximeter.measurements_cumulativef64 (609bf1e8-ab69-4686-b40b-557fd72f2841): There are no data parts
431 2025.03.17 16:40:59.860744 [ 243412 ] {1c95ec76-bada-4c68-9cf7-cf0d310de9de} <Debug> TCPHandler: Processed in 0.011198839 sec.
432 2025.03.17 16:40:59.861380 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
433 2025.03.17 16:40:59.863114 [ 243412 ] {f6d3c614-ef91-41e5-89ec-59b54e401720} <Debug> executeQuery: (from [::1]:44226) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /*
434 * NOTE: Array types cannot be Nullable, see
435 * https://clickhouse.com/docs/en/sql-reference/data-types/nullable
436 * for more details.
437 *
438 * This means we need to use empty arrays to indicate a missing value. This
439 * is unfortunate, and at this point relies on the fact that an
440 * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need
441 * to figure out another way to represent missing samples here.
442 */
443 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)
444 2025.03.17 16:40:59.863190 [ 243412 ] {f6d3c614-ef91-41e5-89ec-59b54e401720} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
445 2025.03.17 16:40:59.871947 [ 243412 ] {f6d3c614-ef91-41e5-89ec-59b54e401720} <Debug> oximeter.measurements_histogrami8 (b9e8f76a-7709-46ff-a8e2-210f7d467ac8): Loading data parts
446 2025.03.17 16:40:59.872247 [ 243412 ] {f6d3c614-ef91-41e5-89ec-59b54e401720} <Debug> oximeter.measurements_histogrami8 (b9e8f76a-7709-46ff-a8e2-210f7d467ac8): There are no data parts
447 2025.03.17 16:40:59.876908 [ 243412 ] {f6d3c614-ef91-41e5-89ec-59b54e401720} <Debug> TCPHandler: Processed in 0.015700623 sec.
448 2025.03.17 16:40:59.877968 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
449 2025.03.17 16:40:59.879396 [ 243412 ] {20decfba-8a1e-45d5-97a2-55458afbe645} <Debug> executeQuery: (from [::1]:44226) 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)
450 2025.03.17 16:40:59.879507 [ 243412 ] {20decfba-8a1e-45d5-97a2-55458afbe645} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
451 2025.03.17 16:40:59.884062 [ 243412 ] {20decfba-8a1e-45d5-97a2-55458afbe645} <Debug> oximeter.measurements_histogramu8 (8ae4586c-f46a-4175-9bc5-e8b3050d14ce): Loading data parts
452 2025.03.17 16:40:59.884312 [ 243412 ] {20decfba-8a1e-45d5-97a2-55458afbe645} <Debug> oximeter.measurements_histogramu8 (8ae4586c-f46a-4175-9bc5-e8b3050d14ce): There are no data parts
453 2025.03.17 16:40:59.887876 [ 243412 ] {20decfba-8a1e-45d5-97a2-55458afbe645} <Debug> TCPHandler: Processed in 0.010087058 sec.
454 2025.03.17 16:40:59.888281 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
455 2025.03.17 16:40:59.888633 [ 243412 ] {c9d0864e-ae2c-4024-be74-e9a512635644} <Debug> executeQuery: (from [::1]:44226) 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)
456 2025.03.17 16:40:59.888696 [ 243412 ] {c9d0864e-ae2c-4024-be74-e9a512635644} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
457 2025.03.17 16:40:59.894864 [ 243412 ] {c9d0864e-ae2c-4024-be74-e9a512635644} <Debug> oximeter.measurements_histogrami16 (a26d3ef5-3c32-4516-bbba-aab86ea1b77a): Loading data parts
458 2025.03.17 16:40:59.895084 [ 243412 ] {c9d0864e-ae2c-4024-be74-e9a512635644} <Debug> oximeter.measurements_histogrami16 (a26d3ef5-3c32-4516-bbba-aab86ea1b77a): There are no data parts
459 2025.03.17 16:40:59.898752 [ 243412 ] {c9d0864e-ae2c-4024-be74-e9a512635644} <Debug> TCPHandler: Processed in 0.010535978 sec.
460 2025.03.17 16:40:59.899345 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
461 2025.03.17 16:40:59.899653 [ 243412 ] {5518b723-4391-4edf-b796-8c959ec6ed1c} <Debug> executeQuery: (from [::1]:44226) 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)
462 2025.03.17 16:40:59.899712 [ 243412 ] {5518b723-4391-4edf-b796-8c959ec6ed1c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
463 2025.03.17 16:40:59.905088 [ 243412 ] {5518b723-4391-4edf-b796-8c959ec6ed1c} <Debug> oximeter.measurements_histogramu16 (052810c2-3216-4c0b-b321-7e4e21e6b085): Loading data parts
464 2025.03.17 16:40:59.905420 [ 243412 ] {5518b723-4391-4edf-b796-8c959ec6ed1c} <Debug> oximeter.measurements_histogramu16 (052810c2-3216-4c0b-b321-7e4e21e6b085): There are no data parts
465 2025.03.17 16:40:59.909587 [ 243412 ] {5518b723-4391-4edf-b796-8c959ec6ed1c} <Debug> TCPHandler: Processed in 0.010380098 sec.
466 2025.03.17 16:40:59.910152 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
467 2025.03.17 16:40:59.910526 [ 243412 ] {64b13229-170d-4c75-aa49-d717c3190cd5} <Debug> executeQuery: (from [::1]:44226) 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)
468 2025.03.17 16:40:59.910591 [ 243412 ] {64b13229-170d-4c75-aa49-d717c3190cd5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
469 2025.03.17 16:40:59.918025 [ 243412 ] {64b13229-170d-4c75-aa49-d717c3190cd5} <Debug> oximeter.measurements_histogrami32 (bd2e3185-9e87-4786-9b6e-255bcb7d4706): Loading data parts
470 2025.03.17 16:40:59.918360 [ 243412 ] {64b13229-170d-4c75-aa49-d717c3190cd5} <Debug> oximeter.measurements_histogrami32 (bd2e3185-9e87-4786-9b6e-255bcb7d4706): There are no data parts
471 2025.03.17 16:40:59.925558 [ 243412 ] {64b13229-170d-4c75-aa49-d717c3190cd5} <Debug> TCPHandler: Processed in 0.015579543 sec.
472 2025.03.17 16:40:59.928466 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
473 2025.03.17 16:40:59.928838 [ 243412 ] {f0f81454-0069-4806-af13-5e0fe2a7b3f6} <Debug> executeQuery: (from [::1]:44226) 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)
474 2025.03.17 16:40:59.930526 [ 243412 ] {f0f81454-0069-4806-af13-5e0fe2a7b3f6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
475 2025.03.17 16:40:59.936306 [ 243412 ] {f0f81454-0069-4806-af13-5e0fe2a7b3f6} <Debug> oximeter.measurements_histogramu32 (1ef5b9ae-f9f1-42d1-b3ab-cf6b9de85b65): Loading data parts
476 2025.03.17 16:40:59.936576 [ 243412 ] {f0f81454-0069-4806-af13-5e0fe2a7b3f6} <Debug> oximeter.measurements_histogramu32 (1ef5b9ae-f9f1-42d1-b3ab-cf6b9de85b65): There are no data parts
477 2025.03.17 16:40:59.945630 [ 243412 ] {f0f81454-0069-4806-af13-5e0fe2a7b3f6} <Debug> TCPHandler: Processed in 0.017338734 sec.
478 2025.03.17 16:40:59.946255 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
479 2025.03.17 16:40:59.946626 [ 243412 ] {a87312fd-4b40-4aa8-91ca-8a4c0156f18e} <Debug> executeQuery: (from [::1]:44226) 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)
480 2025.03.17 16:40:59.946703 [ 243412 ] {a87312fd-4b40-4aa8-91ca-8a4c0156f18e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
481 2025.03.17 16:40:59.957424 [ 243412 ] {a87312fd-4b40-4aa8-91ca-8a4c0156f18e} <Debug> oximeter.measurements_histogrami64 (b843f74d-99c7-4205-a476-50e599b78dde): Loading data parts
482 2025.03.17 16:40:59.957839 [ 243412 ] {a87312fd-4b40-4aa8-91ca-8a4c0156f18e} <Debug> oximeter.measurements_histogrami64 (b843f74d-99c7-4205-a476-50e599b78dde): There are no data parts
483 2025.03.17 16:40:59.962956 [ 243412 ] {a87312fd-4b40-4aa8-91ca-8a4c0156f18e} <Debug> TCPHandler: Processed in 0.016889574 sec.
484 2025.03.17 16:40:59.963622 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
485 2025.03.17 16:40:59.965387 [ 243412 ] {a5ec6df0-a075-4186-99c8-22f5d84e71a2} <Debug> executeQuery: (from [::1]:44226) 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)
486 2025.03.17 16:40:59.965451 [ 243412 ] {a5ec6df0-a075-4186-99c8-22f5d84e71a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
487 2025.03.17 16:40:59.971802 [ 243412 ] {a5ec6df0-a075-4186-99c8-22f5d84e71a2} <Debug> oximeter.measurements_histogramu64 (fc55eb37-ac5f-4c9e-9c39-dde89e855d7b): Loading data parts
488 2025.03.17 16:40:59.972462 [ 243412 ] {a5ec6df0-a075-4186-99c8-22f5d84e71a2} <Debug> oximeter.measurements_histogramu64 (fc55eb37-ac5f-4c9e-9c39-dde89e855d7b): There are no data parts
489 2025.03.17 16:40:59.977691 [ 243412 ] {a5ec6df0-a075-4186-99c8-22f5d84e71a2} <Debug> TCPHandler: Processed in 0.014268232 sec.
490 2025.03.17 16:40:59.978308 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
491 2025.03.17 16:40:59.978647 [ 243412 ] {ab2a0802-1ef6-4dfd-886b-0ad64085ad65} <Debug> executeQuery: (from [::1]:44226) 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)
492 2025.03.17 16:40:59.980110 [ 243412 ] {ab2a0802-1ef6-4dfd-886b-0ad64085ad65} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
493 2025.03.17 16:40:59.985901 [ 243412 ] {ab2a0802-1ef6-4dfd-886b-0ad64085ad65} <Debug> oximeter.measurements_histogramf32 (59ce867f-0231-46de-bf13-2342fea3db2e): Loading data parts
494 2025.03.17 16:40:59.986218 [ 243412 ] {ab2a0802-1ef6-4dfd-886b-0ad64085ad65} <Debug> oximeter.measurements_histogramf32 (59ce867f-0231-46de-bf13-2342fea3db2e): There are no data parts
495 2025.03.17 16:40:59.990464 [ 243412 ] {ab2a0802-1ef6-4dfd-886b-0ad64085ad65} <Debug> TCPHandler: Processed in 0.01231675 sec.
496 2025.03.17 16:40:59.991105 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
497 2025.03.17 16:40:59.992731 [ 243412 ] {8bde6849-2251-4796-9994-7114e95fdf83} <Debug> executeQuery: (from [::1]:44226) 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)
498 2025.03.17 16:40:59.992787 [ 243412 ] {8bde6849-2251-4796-9994-7114e95fdf83} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
499 2025.03.17 16:40:59.997921 [ 243412 ] {8bde6849-2251-4796-9994-7114e95fdf83} <Debug> oximeter.measurements_histogramf64 (e85a36f0-92e6-43ab-b57d-c7e39e6bc801): Loading data parts
500 2025.03.17 16:40:59.998255 [ 243412 ] {8bde6849-2251-4796-9994-7114e95fdf83} <Debug> oximeter.measurements_histogramf64 (e85a36f0-92e6-43ab-b57d-c7e39e6bc801): There are no data parts
501 2025.03.17 16:41:00.004309 [ 243412 ] {8bde6849-2251-4796-9994-7114e95fdf83} <Debug> TCPHandler: Processed in 0.013359251 sec.
502 2025.03.17 16:41:00.005069 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
503 2025.03.17 16:41:00.005304 [ 243412 ] {c0506c0a-f5ea-44eb-91c2-145a29d07eeb} <Debug> executeQuery: (from [::1]:44226) /* The field tables store named dimensions of each timeseries.
504 *
505 * As with the measurement tables, there is one field table for each field data
506 * type. Fields are deduplicated by using the "replacing merge tree", though
507 * this behavior **must not** be relied upon for query correctness.
508 *
509 * The index for the fields differs from the measurements, however. Rows are
510 * sorted by timeseries name, then field name, field value, and finally
511 * timeseries key. This reflects the most common pattern for looking them up:
512 * by field name and possibly value, within a timeseries. The resulting keys are
513 * usually then used to look up measurements.
514 *
515 * NOTE: We may want to consider a secondary index on these tables, sorting by
516 * timeseries name and then key, since it would improve lookups where one
517 * already has the key. Realistically though, these tables are quite small and
518 * so performance benefits will be low in absolute terms.
519 *
520 * TTL: We use a materialized column to expire old field table records. This
521 * column is generated automatically by the database whenever a new row is
522 * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *`
523 * query. Since these tables are `ReplacingMergeTree`s, that means the last
524 * record will remain during a deduplication, which will have the last
525 * timestamp. ClickHouse will then expire old data for us, similar to the
526 * measurement tables.
527 */
528 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)
529 2025.03.17 16:41:00.005360 [ 243412 ] {c0506c0a-f5ea-44eb-91c2-145a29d07eeb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
530 2025.03.17 16:41:00.009943 [ 243412 ] {c0506c0a-f5ea-44eb-91c2-145a29d07eeb} <Debug> oximeter.fields_bool (c7367f55-f723-4412-bcd8-3ad0c1224e3b): Loading data parts
531 2025.03.17 16:41:00.012239 [ 243412 ] {c0506c0a-f5ea-44eb-91c2-145a29d07eeb} <Debug> oximeter.fields_bool (c7367f55-f723-4412-bcd8-3ad0c1224e3b): There are no data parts
532 2025.03.17 16:41:00.018467 [ 243412 ] {c0506c0a-f5ea-44eb-91c2-145a29d07eeb} <Debug> TCPHandler: Processed in 0.013698911 sec.
533 2025.03.17 16:41:00.019053 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
534 2025.03.17 16:41:00.019361 [ 243412 ] {42613a07-19ae-47f4-af2a-6161dba82abd} <Debug> executeQuery: (from [::1]:44226) 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)
535 2025.03.17 16:41:00.019422 [ 243412 ] {42613a07-19ae-47f4-af2a-6161dba82abd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
536 2025.03.17 16:41:00.023827 [ 243412 ] {42613a07-19ae-47f4-af2a-6161dba82abd} <Debug> oximeter.fields_i8 (24231078-00ea-4b72-a7ab-7b1344f02df5): Loading data parts
537 2025.03.17 16:41:00.024158 [ 243412 ] {42613a07-19ae-47f4-af2a-6161dba82abd} <Debug> oximeter.fields_i8 (24231078-00ea-4b72-a7ab-7b1344f02df5): There are no data parts
538 2025.03.17 16:41:00.029652 [ 243412 ] {42613a07-19ae-47f4-af2a-6161dba82abd} <Debug> TCPHandler: Processed in 0.010796349 sec.
539 2025.03.17 16:41:00.030293 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
540 2025.03.17 16:41:00.030561 [ 243412 ] {f379fe90-60f2-442d-9972-0433605dfd8b} <Debug> executeQuery: (from [::1]:44226) 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)
541 2025.03.17 16:41:00.030618 [ 243412 ] {f379fe90-60f2-442d-9972-0433605dfd8b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
542 2025.03.17 16:41:00.035105 [ 243412 ] {f379fe90-60f2-442d-9972-0433605dfd8b} <Debug> oximeter.fields_u8 (096170d6-0d30-4ca1-9edd-65c1861909fb): Loading data parts
543 2025.03.17 16:41:00.035409 [ 243412 ] {f379fe90-60f2-442d-9972-0433605dfd8b} <Debug> oximeter.fields_u8 (096170d6-0d30-4ca1-9edd-65c1861909fb): There are no data parts
544 2025.03.17 16:41:00.040387 [ 243412 ] {f379fe90-60f2-442d-9972-0433605dfd8b} <Debug> TCPHandler: Processed in 0.010317138 sec.
545 2025.03.17 16:41:00.040962 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
546 2025.03.17 16:41:00.041224 [ 243412 ] {102373e8-cc09-4f98-b88f-4b0e11b92d59} <Debug> executeQuery: (from [::1]:44226) 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)
547 2025.03.17 16:41:00.041277 [ 243412 ] {102373e8-cc09-4f98-b88f-4b0e11b92d59} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
548 2025.03.17 16:41:00.047120 [ 243412 ] {102373e8-cc09-4f98-b88f-4b0e11b92d59} <Debug> oximeter.fields_i16 (01c0688e-9020-4071-ab9a-99301847bd92): Loading data parts
549 2025.03.17 16:41:00.053288 [ 243412 ] {102373e8-cc09-4f98-b88f-4b0e11b92d59} <Debug> oximeter.fields_i16 (01c0688e-9020-4071-ab9a-99301847bd92): There are no data parts
550 2025.03.17 16:41:00.057239 [ 243412 ] {102373e8-cc09-4f98-b88f-4b0e11b92d59} <Debug> TCPHandler: Processed in 0.016448254 sec.
551 2025.03.17 16:41:00.088594 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
552 2025.03.17 16:41:00.088915 [ 243412 ] {c5e5d00e-4c39-47b0-9437-343e58e19468} <Debug> executeQuery: (from [::1]:44226) 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)
553 2025.03.17 16:41:00.090062 [ 243412 ] {c5e5d00e-4c39-47b0-9437-343e58e19468} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
554 2025.03.17 16:41:00.095833 [ 243412 ] {c5e5d00e-4c39-47b0-9437-343e58e19468} <Debug> oximeter.fields_u16 (79f3a29b-9606-4f1a-8d68-67eb4e15b583): Loading data parts
555 2025.03.17 16:41:00.096422 [ 243412 ] {c5e5d00e-4c39-47b0-9437-343e58e19468} <Debug> oximeter.fields_u16 (79f3a29b-9606-4f1a-8d68-67eb4e15b583): There are no data parts
556 2025.03.17 16:41:00.102114 [ 243412 ] {c5e5d00e-4c39-47b0-9437-343e58e19468} <Debug> TCPHandler: Processed in 0.013715871 sec.
557 2025.03.17 16:41:00.104252 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
558 2025.03.17 16:41:00.104549 [ 243412 ] {15d4846c-47b0-4d8e-aa4a-5cb77ca0700d} <Debug> executeQuery: (from [::1]:44226) 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)
559 2025.03.17 16:41:00.104607 [ 243412 ] {15d4846c-47b0-4d8e-aa4a-5cb77ca0700d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
560 2025.03.17 16:41:00.110759 [ 243412 ] {15d4846c-47b0-4d8e-aa4a-5cb77ca0700d} <Debug> oximeter.fields_i32 (05ab6907-31b4-4090-8bad-c87c55667ec3): Loading data parts
561 2025.03.17 16:41:00.111090 [ 243412 ] {15d4846c-47b0-4d8e-aa4a-5cb77ca0700d} <Debug> oximeter.fields_i32 (05ab6907-31b4-4090-8bad-c87c55667ec3): There are no data parts
562 2025.03.17 16:41:00.116855 [ 243412 ] {15d4846c-47b0-4d8e-aa4a-5cb77ca0700d} <Debug> TCPHandler: Processed in 0.012782011 sec.
563 2025.03.17 16:41:00.122298 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
564 2025.03.17 16:41:00.122600 [ 243412 ] {b7d4f0b3-1bb5-423b-b4bd-240a985fd4b7} <Debug> executeQuery: (from [::1]:44226) 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)
565 2025.03.17 16:41:00.122664 [ 243412 ] {b7d4f0b3-1bb5-423b-b4bd-240a985fd4b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
566 2025.03.17 16:41:00.133271 [ 243412 ] {b7d4f0b3-1bb5-423b-b4bd-240a985fd4b7} <Debug> oximeter.fields_u32 (3d4999ae-febd-4ee2-83dd-81e3e7bf641d): Loading data parts
567 2025.03.17 16:41:00.133499 [ 243412 ] {b7d4f0b3-1bb5-423b-b4bd-240a985fd4b7} <Debug> oximeter.fields_u32 (3d4999ae-febd-4ee2-83dd-81e3e7bf641d): There are no data parts
568 2025.03.17 16:41:00.139709 [ 243412 ] {b7d4f0b3-1bb5-423b-b4bd-240a985fd4b7} <Debug> TCPHandler: Processed in 0.017626864 sec.
569 2025.03.17 16:41:00.140545 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
570 2025.03.17 16:41:00.142309 [ 243412 ] {830876fc-49e7-4187-a923-321e8dc9efc1} <Debug> executeQuery: (from [::1]:44226) 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)
571 2025.03.17 16:41:00.142356 [ 243412 ] {830876fc-49e7-4187-a923-321e8dc9efc1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
572 2025.03.17 16:41:00.148968 [ 243412 ] {830876fc-49e7-4187-a923-321e8dc9efc1} <Debug> oximeter.fields_i64 (3dfcb74e-121b-4204-a8cf-6aeaa355f6b9): Loading data parts
573 2025.03.17 16:41:00.149271 [ 243412 ] {830876fc-49e7-4187-a923-321e8dc9efc1} <Debug> oximeter.fields_i64 (3dfcb74e-121b-4204-a8cf-6aeaa355f6b9): There are no data parts
574 2025.03.17 16:41:00.154386 [ 243412 ] {830876fc-49e7-4187-a923-321e8dc9efc1} <Debug> TCPHandler: Processed in 0.013996231 sec.
575 2025.03.17 16:41:00.155056 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
576 2025.03.17 16:41:00.155368 [ 243412 ] {a4784271-1bd6-4fd4-9fc9-34b3efa0ce91} <Debug> executeQuery: (from [::1]:44226) 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)
577 2025.03.17 16:41:00.155413 [ 243412 ] {a4784271-1bd6-4fd4-9fc9-34b3efa0ce91} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
578 2025.03.17 16:41:00.162859 [ 243412 ] {a4784271-1bd6-4fd4-9fc9-34b3efa0ce91} <Debug> oximeter.fields_u64 (b4c01124-d76f-49e5-a486-45abdafe2e16): Loading data parts
579 2025.03.17 16:41:00.163166 [ 243412 ] {a4784271-1bd6-4fd4-9fc9-34b3efa0ce91} <Debug> oximeter.fields_u64 (b4c01124-d76f-49e5-a486-45abdafe2e16): There are no data parts
580 2025.03.17 16:41:00.167646 [ 243412 ] {a4784271-1bd6-4fd4-9fc9-34b3efa0ce91} <Debug> TCPHandler: Processed in 0.01277129 sec.
581 2025.03.17 16:41:00.169146 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
582 2025.03.17 16:41:00.170832 [ 243412 ] {ed389140-b26b-4fc0-b70b-8b60c21eeffe} <Debug> executeQuery: (from [::1]:44226) 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)
583 2025.03.17 16:41:00.170892 [ 243412 ] {ed389140-b26b-4fc0-b70b-8b60c21eeffe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
584 2025.03.17 16:41:00.176773 [ 243412 ] {ed389140-b26b-4fc0-b70b-8b60c21eeffe} <Debug> oximeter.fields_ipaddr (eb95c7aa-d871-4621-8eb3-deef7d2dbf5a): Loading data parts
585 2025.03.17 16:41:00.177076 [ 243412 ] {ed389140-b26b-4fc0-b70b-8b60c21eeffe} <Debug> oximeter.fields_ipaddr (eb95c7aa-d871-4621-8eb3-deef7d2dbf5a): There are no data parts
586 2025.03.17 16:41:00.181110 [ 243412 ] {ed389140-b26b-4fc0-b70b-8b60c21eeffe} <Debug> TCPHandler: Processed in 0.012145309 sec.
587 2025.03.17 16:41:00.181755 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
588 2025.03.17 16:41:00.182507 [ 243412 ] {c502e7b9-23ce-4e7c-b09e-fea4f851126c} <Debug> executeQuery: (from [::1]:44226) 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)
589 2025.03.17 16:41:00.182572 [ 243412 ] {c502e7b9-23ce-4e7c-b09e-fea4f851126c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
590 2025.03.17 16:41:00.187493 [ 243412 ] {c502e7b9-23ce-4e7c-b09e-fea4f851126c} <Debug> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Loading data parts
591 2025.03.17 16:41:00.187827 [ 243412 ] {c502e7b9-23ce-4e7c-b09e-fea4f851126c} <Debug> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): There are no data parts
592 2025.03.17 16:41:00.194100 [ 243412 ] {c502e7b9-23ce-4e7c-b09e-fea4f851126c} <Debug> TCPHandler: Processed in 0.01249592 sec.
593 2025.03.17 16:41:00.194807 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
594 2025.03.17 16:41:00.196577 [ 243412 ] {8facc916-fc00-4964-b6a2-4adc56620aed} <Debug> executeQuery: (from [::1]:44226) 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)
595 2025.03.17 16:41:00.196638 [ 243412 ] {8facc916-fc00-4964-b6a2-4adc56620aed} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
596 2025.03.17 16:41:00.202420 [ 243412 ] {8facc916-fc00-4964-b6a2-4adc56620aed} <Debug> oximeter.fields_uuid (519b93a7-e740-4e31-9fdb-5c8ca958407b): Loading data parts
597 2025.03.17 16:41:00.202628 [ 243412 ] {8facc916-fc00-4964-b6a2-4adc56620aed} <Debug> oximeter.fields_uuid (519b93a7-e740-4e31-9fdb-5c8ca958407b): There are no data parts
598 2025.03.17 16:41:00.209169 [ 243412 ] {8facc916-fc00-4964-b6a2-4adc56620aed} <Debug> TCPHandler: Processed in 0.014597192 sec.
599 2025.03.17 16:41:00.212100 [ 243412 ] {} <Trace> TCP-Session: 8f1fc29c-636f-46df-b8c9-9d474d8750d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
600 2025.03.17 16:41:00.212461 [ 243412 ] {c9ef9146-4446-4e3d-b50b-675c2a98bb34} <Debug> executeQuery: (from [::1]:44226) /* The timeseries schema table stores the extracted schema for the samples
601 * oximeter collects.
602 */
603 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)
604 2025.03.17 16:41:00.212548 [ 243412 ] {c9ef9146-4446-4e3d-b50b-675c2a98bb34} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
605 2025.03.17 16:41:00.220577 [ 243412 ] {c9ef9146-4446-4e3d-b50b-675c2a98bb34} <Debug> oximeter.timeseries_schema (5f95f06b-44d3-4c58-a573-5ea9350bc9d3): Loading data parts
606 2025.03.17 16:41:00.224673 [ 243412 ] {c9ef9146-4446-4e3d-b50b-675c2a98bb34} <Debug> oximeter.timeseries_schema (5f95f06b-44d3-4c58-a573-5ea9350bc9d3): There are no data parts
607 2025.03.17 16:41:00.232240 [ 243412 ] {c9ef9146-4446-4e3d-b50b-675c2a98bb34} <Debug> TCPHandler: Processed in 0.022628898 sec.
608 2025.03.17 16:41:00.234407 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
609 2025.03.17 16:41:00.234613 [ 243409 ] {3d888cca-52cf-4979-9936-d170cd047ad1} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
610 2025.03.17 16:41:00.234711 [ 243409 ] {3d888cca-52cf-4979-9936-d170cd047ad1} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
611 2025.03.17 16:41:00.235617 [ 243264 ] {3d888cca-52cf-4979-9936-d170cd047ad1} <Trace> oximeter.version (36ca87dc-9588-4b9e-acda-6bbc739f9b06): Trying to reserve 1.00 MiB using storage policy from min volume index 0
612 2025.03.17 16:41:00.235642 [ 243264 ] {3d888cca-52cf-4979-9936-d170cd047ad1} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.13 GiB.
613 2025.03.17 16:41:00.236007 [ 243264 ] {3d888cca-52cf-4979-9936-d170cd047ad1} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
614 2025.03.17 16:41:00.236151 [ 243264 ] {3d888cca-52cf-4979-9936-d170cd047ad1} <Trace> oximeter.version (36ca87dc-9588-4b9e-acda-6bbc739f9b06): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
615 2025.03.17 16:41:00.237140 [ 243409 ] {3d888cca-52cf-4979-9936-d170cd047ad1} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.002605 sec., 383.8771593090211 rows/sec., 6.00 KiB/sec.
616 2025.03.17 16:41:00.239011 [ 243409 ] {3d888cca-52cf-4979-9936-d170cd047ad1} <Debug> TCPHandler: Processed in 0.004797524 sec.
617 2025.03.17 16:41:02.245744 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
618 2025.03.17 16:41:02.245945 [ 243409 ] {503e0d01-7239-4459-8e03-aba27aa3881d} <Debug> executeQuery: (from [::1]:44220) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete)
619 2025.03.17 16:41:02.246222 [ 243409 ] {503e0d01-7239-4459-8e03-aba27aa3881d} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema
620 2025.03.17 16:41:02.246282 [ 243409 ] {503e0d01-7239-4459-8e03-aba27aa3881d} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
621 2025.03.17 16:41:02.246891 [ 243409 ] {503e0d01-7239-4459-8e03-aba27aa3881d} <Debug> TCPHandler: Processed in 0.001344021 sec.
622 2025.03.17 16:41:02.251987 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
623 2025.03.17 16:41:02.252165 [ 243409 ] {43e642f2-68a0-4e1f-815c-a5f541f1ac5f} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete)
624 2025.03.17 16:41:02.252243 [ 243409 ] {43e642f2-68a0-4e1f-815c-a5f541f1ac5f} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema
625 2025.03.17 16:41:02.254182 [ 243409 ] {43e642f2-68a0-4e1f-815c-a5f541f1ac5f} <Trace> oximeter.timeseries_schema (5f95f06b-44d3-4c58-a573-5ea9350bc9d3): Trying to reserve 1.00 MiB using storage policy from min volume index 0
626 2025.03.17 16:41:02.254217 [ 243409 ] {43e642f2-68a0-4e1f-815c-a5f541f1ac5f} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.13 GiB.
627 2025.03.17 16:41:02.254763 [ 243409 ] {43e642f2-68a0-4e1f-815c-a5f541f1ac5f} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
628 2025.03.17 16:41:02.254982 [ 243409 ] {43e642f2-68a0-4e1f-815c-a5f541f1ac5f} <Trace> oximeter.timeseries_schema (5f95f06b-44d3-4c58-a573-5ea9350bc9d3): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
629 2025.03.17 16:41:02.255177 [ 243409 ] {43e642f2-68a0-4e1f-815c-a5f541f1ac5f} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.003067 sec., 326.0515161395501 rows/sec., 39.16 KiB/sec.
630 2025.03.17 16:41:02.255220 [ 243409 ] {43e642f2-68a0-4e1f-815c-a5f541f1ac5f} <Debug> TCPHandler: Processed in 0.003409333 sec.
631 2025.03.17 16:41:02.256309 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
632 2025.03.17 16:41:02.256996 [ 243409 ] {35ecaa29-dfc1-4665-9213-23ae5a0a64b2} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete)
633 2025.03.17 16:41:02.257055 [ 243409 ] {35ecaa29-dfc1-4665-9213-23ae5a0a64b2} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
634 2025.03.17 16:41:02.258247 [ 243409 ] {35ecaa29-dfc1-4665-9213-23ae5a0a64b2} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Trying to reserve 1.00 MiB using storage policy from min volume index 0
635 2025.03.17 16:41:02.258275 [ 243409 ] {35ecaa29-dfc1-4665-9213-23ae5a0a64b2} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.13 GiB.
636 2025.03.17 16:41:02.260690 [ 243409 ] {35ecaa29-dfc1-4665-9213-23ae5a0a64b2} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
637 2025.03.17 16:41:02.261003 [ 243409 ] {35ecaa29-dfc1-4665-9213-23ae5a0a64b2} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
638 2025.03.17 16:41:02.261212 [ 243409 ] {35ecaa29-dfc1-4665-9213-23ae5a0a64b2} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004268 sec., 468.6035613870665 rows/sec., 48.51 KiB/sec.
639 2025.03.17 16:41:02.261276 [ 243409 ] {35ecaa29-dfc1-4665-9213-23ae5a0a64b2} <Debug> TCPHandler: Processed in 0.005124194 sec.
640 2025.03.17 16:41:02.261853 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
641 2025.03.17 16:41:02.262002 [ 243409 ] {c2a6be35-7c6c-4af5-a149-f0086fbfb551} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete)
642 2025.03.17 16:41:02.262057 [ 243409 ] {c2a6be35-7c6c-4af5-a149-f0086fbfb551} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
643 2025.03.17 16:41:02.262843 [ 243409 ] {c2a6be35-7c6c-4af5-a149-f0086fbfb551} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
644 2025.03.17 16:41:02.262868 [ 243409 ] {c2a6be35-7c6c-4af5-a149-f0086fbfb551} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.13 GiB.
645 2025.03.17 16:41:02.263237 [ 243409 ] {c2a6be35-7c6c-4af5-a149-f0086fbfb551} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
646 2025.03.17 16:41:02.263474 [ 243409 ] {c2a6be35-7c6c-4af5-a149-f0086fbfb551} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
647 2025.03.17 16:41:02.263649 [ 243409 ] {c2a6be35-7c6c-4af5-a149-f0086fbfb551} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001697 sec., 589.2751915144372 rows/sec., 40.86 KiB/sec.
648 2025.03.17 16:41:02.263683 [ 243409 ] {c2a6be35-7c6c-4af5-a149-f0086fbfb551} <Debug> TCPHandler: Processed in 0.001980322 sec.
649 2025.03.17 16:41:03.245955 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
650 2025.03.17 16:41:03.247996 [ 243409 ] {e95b7434-c270-488e-8bbe-16fa5f4dd9bd} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete)
651 2025.03.17 16:41:03.248069 [ 243409 ] {e95b7434-c270-488e-8bbe-16fa5f4dd9bd} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
652 2025.03.17 16:41:03.249325 [ 243409 ] {e95b7434-c270-488e-8bbe-16fa5f4dd9bd} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Trying to reserve 1.00 MiB using storage policy from min volume index 0
653 2025.03.17 16:41:03.250322 [ 243409 ] {e95b7434-c270-488e-8bbe-16fa5f4dd9bd} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.27 GiB.
654 2025.03.17 16:41:03.250657 [ 243409 ] {e95b7434-c270-488e-8bbe-16fa5f4dd9bd} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary)
655 2025.03.17 16:41:03.250845 [ 243409 ] {e95b7434-c270-488e-8bbe-16fa5f4dd9bd} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
656 2025.03.17 16:41:03.251021 [ 243409 ] {e95b7434-c270-488e-8bbe-16fa5f4dd9bd} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003096 sec., 645.9948320413437 rows/sec., 66.87 KiB/sec.
657 2025.03.17 16:41:03.251056 [ 243409 ] {e95b7434-c270-488e-8bbe-16fa5f4dd9bd} <Debug> TCPHandler: Processed in 0.005300625 sec.
658 2025.03.17 16:41:03.256500 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
659 2025.03.17 16:41:03.256718 [ 243409 ] {e6bda774-7bbb-4822-ae1a-f984e1879e28} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete)
660 2025.03.17 16:41:03.256801 [ 243409 ] {e6bda774-7bbb-4822-ae1a-f984e1879e28} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
661 2025.03.17 16:41:03.258621 [ 243409 ] {e6bda774-7bbb-4822-ae1a-f984e1879e28} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
662 2025.03.17 16:41:03.258658 [ 243409 ] {e6bda774-7bbb-4822-ae1a-f984e1879e28} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.27 GiB.
663 2025.03.17 16:41:03.259117 [ 243409 ] {e6bda774-7bbb-4822-ae1a-f984e1879e28} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary)
664 2025.03.17 16:41:03.259335 [ 243409 ] {e6bda774-7bbb-4822-ae1a-f984e1879e28} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
665 2025.03.17 16:41:03.259587 [ 243409 ] {e6bda774-7bbb-4822-ae1a-f984e1879e28} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002932 sec., 341.06412005457025 rows/sec., 23.65 KiB/sec.
666 2025.03.17 16:41:03.259648 [ 243409 ] {e6bda774-7bbb-4822-ae1a-f984e1879e28} <Debug> TCPHandler: Processed in 0.003355972 sec.
667 2025.03.17 16:41:04.026975 [ 242718 ] {} <Debug> DNSResolver: Updating DNS cache
668 2025.03.17 16:41:04.027013 [ 242718 ] {} <Debug> DNSResolver: Updated DNS cache
669 2025.03.17 16:41:04.075247 [ 242859 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1852 entries to flush up to offset 3574
670 2025.03.17 16:41:04.076563 [ 242859 ] {} <Trace> system.asynchronous_metric_log (0e9e5c8e-893f-4682-9cfd-b357a3c3e3a9): Trying to reserve 1.00 MiB using storage policy from min volume index 0
671 2025.03.17 16:41:04.076602 [ 242859 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.56 GiB.
672 2025.03.17 16:41:04.077413 [ 242859 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary)
673 2025.03.17 16:41:04.077621 [ 242859 ] {} <Trace> system.asynchronous_metric_log (0e9e5c8e-893f-4682-9cfd-b357a3c3e3a9): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
674 2025.03.17 16:41:04.077772 [ 242859 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 3574
675 2025.03.17 16:41:04.130657 [ 242856 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16
676 2025.03.17 16:41:04.148787 [ 242856 ] {} <Trace> system.metric_log (c233b063-754f-4bc8-bd08-48c353aadc53): Trying to reserve 1.00 MiB using storage policy from min volume index 0
677 2025.03.17 16:41:04.148834 [ 242856 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.56 GiB.
678 2025.03.17 16:41:04.153685 [ 242856 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary)
679 2025.03.17 16:41:04.154471 [ 242856 ] {} <Trace> system.metric_log (c233b063-754f-4bc8-bd08-48c353aadc53): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
680 2025.03.17 16:41:04.156371 [ 242856 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 16
681 2025.03.17 16:41:04.359309 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
682 2025.03.17 16:41:04.359533 [ 243409 ] {24a9c719-ba64-4dbf-860b-8a598bb5e8fe} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete)
683 2025.03.17 16:41:04.359603 [ 243409 ] {24a9c719-ba64-4dbf-860b-8a598bb5e8fe} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
684 2025.03.17 16:41:04.361204 [ 243409 ] {24a9c719-ba64-4dbf-860b-8a598bb5e8fe} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Trying to reserve 1.00 MiB using storage policy from min volume index 0
685 2025.03.17 16:41:04.361237 [ 243409 ] {24a9c719-ba64-4dbf-860b-8a598bb5e8fe} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.71 GiB.
686 2025.03.17 16:41:04.361687 [ 243409 ] {24a9c719-ba64-4dbf-860b-8a598bb5e8fe} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary)
687 2025.03.17 16:41:04.361883 [ 243409 ] {24a9c719-ba64-4dbf-860b-8a598bb5e8fe} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
688 2025.03.17 16:41:04.362086 [ 243409 ] {24a9c719-ba64-4dbf-860b-8a598bb5e8fe} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002621 sec., 763.0675314765357 rows/sec., 78.99 KiB/sec.
689 2025.03.17 16:41:04.362126 [ 243409 ] {24a9c719-ba64-4dbf-860b-8a598bb5e8fe} <Debug> TCPHandler: Processed in 0.003036613 sec.
690 2025.03.17 16:41:04.363466 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
691 2025.03.17 16:41:04.363620 [ 243409 ] {beb6d29b-4ee1-481c-b736-1b487305f220} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete)
692 2025.03.17 16:41:04.363672 [ 243409 ] {beb6d29b-4ee1-481c-b736-1b487305f220} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
693 2025.03.17 16:41:04.367205 [ 243409 ] {beb6d29b-4ee1-481c-b736-1b487305f220} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
694 2025.03.17 16:41:04.367235 [ 243409 ] {beb6d29b-4ee1-481c-b736-1b487305f220} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.71 GiB.
695 2025.03.17 16:41:04.367623 [ 243409 ] {beb6d29b-4ee1-481c-b736-1b487305f220} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary)
696 2025.03.17 16:41:04.367799 [ 243409 ] {beb6d29b-4ee1-481c-b736-1b487305f220} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
697 2025.03.17 16:41:04.367991 [ 243409 ] {beb6d29b-4ee1-481c-b736-1b487305f220} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.004417 sec., 226.39800769753228 rows/sec., 15.70 KiB/sec.
698 2025.03.17 16:41:04.368026 [ 243409 ] {beb6d29b-4ee1-481c-b736-1b487305f220} <Debug> TCPHandler: Processed in 0.004699353 sec.
699 2025.03.17 16:41:05.000401 [ 242861 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 389.86 MiB, peak 397.79 MiB, free memory in arenas 32.68 MiB, will set to 402.06 MiB (RSS), difference: 12.20 MiB
700 2025.03.17 16:41:05.347864 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
701 2025.03.17 16:41:05.348042 [ 243409 ] {f7c7491c-62d8-47b5-867e-e811cac6615f} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete)
702 2025.03.17 16:41:05.348107 [ 243409 ] {f7c7491c-62d8-47b5-867e-e811cac6615f} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
703 2025.03.17 16:41:05.349792 [ 243409 ] {f7c7491c-62d8-47b5-867e-e811cac6615f} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Trying to reserve 1.00 MiB using storage policy from min volume index 0
704 2025.03.17 16:41:05.349824 [ 243409 ] {f7c7491c-62d8-47b5-867e-e811cac6615f} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.64 GiB.
705 2025.03.17 16:41:05.350221 [ 243409 ] {f7c7491c-62d8-47b5-867e-e811cac6615f} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary)
706 2025.03.17 16:41:05.350405 [ 243409 ] {f7c7491c-62d8-47b5-867e-e811cac6615f} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
707 2025.03.17 16:41:05.350591 [ 243409 ] {f7c7491c-62d8-47b5-867e-e811cac6615f} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002596 sec., 770.4160246533129 rows/sec., 79.75 KiB/sec.
708 2025.03.17 16:41:05.350631 [ 243409 ] {f7c7491c-62d8-47b5-867e-e811cac6615f} <Debug> TCPHandler: Processed in 0.002957302 sec.
709 2025.03.17 16:41:05.351462 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
710 2025.03.17 16:41:05.351611 [ 243409 ] {3a194730-1b53-4500-92ff-71cf7eedffc1} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete)
711 2025.03.17 16:41:05.351660 [ 243409 ] {3a194730-1b53-4500-92ff-71cf7eedffc1} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
712 2025.03.17 16:41:05.352293 [ 243409 ] {3a194730-1b53-4500-92ff-71cf7eedffc1} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
713 2025.03.17 16:41:05.352319 [ 243409 ] {3a194730-1b53-4500-92ff-71cf7eedffc1} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.64 GiB.
714 2025.03.17 16:41:05.352660 [ 243409 ] {3a194730-1b53-4500-92ff-71cf7eedffc1} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary)
715 2025.03.17 16:41:05.352869 [ 243409 ] {3a194730-1b53-4500-92ff-71cf7eedffc1} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
716 2025.03.17 16:41:05.353052 [ 243409 ] {3a194730-1b53-4500-92ff-71cf7eedffc1} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001479 sec., 676.1325219743069 rows/sec., 46.88 KiB/sec.
717 2025.03.17 16:41:05.353094 [ 243409 ] {3a194730-1b53-4500-92ff-71cf7eedffc1} <Debug> TCPHandler: Processed in 0.001731641 sec.
718 2025.03.17 16:41:06.245840 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
719 2025.03.17 16:41:06.246028 [ 243409 ] {84c2411e-1cc6-415c-af96-fb20d765295d} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete)
720 2025.03.17 16:41:06.246079 [ 243409 ] {84c2411e-1cc6-415c-af96-fb20d765295d} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
721 2025.03.17 16:41:06.246922 [ 243409 ] {84c2411e-1cc6-415c-af96-fb20d765295d} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Trying to reserve 1.00 MiB using storage policy from min volume index 0
722 2025.03.17 16:41:06.247948 [ 243409 ] {84c2411e-1cc6-415c-af96-fb20d765295d} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.15 GiB.
723 2025.03.17 16:41:06.248255 [ 243409 ] {84c2411e-1cc6-415c-af96-fb20d765295d} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary)
724 2025.03.17 16:41:06.248379 [ 243409 ] {84c2411e-1cc6-415c-af96-fb20d765295d} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
725 2025.03.17 16:41:06.248472 [ 242664 ] {} <Debug> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0
726 2025.03.17 16:41:06.248499 [ 242664 ] {} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Trying to reserve 1.00 MiB using storage policy from min volume index 0
727 2025.03.17 16:41:06.248508 [ 242664 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.15 GiB.
728 2025.03.17 16:41:06.248595 [ 243409 ] {84c2411e-1cc6-415c-af96-fb20d765295d} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002614 sec., 765.1109410864575 rows/sec., 79.20 KiB/sec.
729 2025.03.17 16:41:06.248633 [ 243409 ] {84c2411e-1cc6-415c-af96-fb20d765295d} <Debug> TCPHandler: Processed in 0.002956873 sec.
730 2025.03.17 16:41:06.248764 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full
731 2025.03.17 16:41:06.248835 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal
732 2025.03.17 16:41:06.248957 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
733 2025.03.17 16:41:06.250168 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 2 rows starting from the beginning of the part
734 2025.03.17 16:41:06.250260 [ 243409 ] {c165d3b4-0fbb-4c80-8d41-5c69d98b6878} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete)
735 2025.03.17 16:41:06.250289 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 2 rows starting from the beginning of the part
736 2025.03.17 16:41:06.250297 [ 243409 ] {c165d3b4-0fbb-4c80-8d41-5c69d98b6878} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
737 2025.03.17 16:41:06.250345 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 2 rows starting from the beginning of the part
738 2025.03.17 16:41:06.250462 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 2 rows starting from the beginning of the part
739 2025.03.17 16:41:06.250577 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 2 rows starting from the beginning of the part
740 2025.03.17 16:41:06.282884 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 10 rows, containing 5 columns (5 merged, 0 gathered) in 0.034249468 sec., 291.97533812787987 rows/sec., 31.36 KiB/sec.
741 2025.03.17 16:41:06.283064 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary)
742 2025.03.17 16:41:06.285010 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
743 2025.03.17 16:41:06.285077 [ 242794 ] {f56deebf-3f0a-44aa-89dc-a92ce1124800::all_1_5_1} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1
744 2025.03.17 16:41:06.285176 [ 242794 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.34 MiB.
745 2025.03.17 16:41:06.380003 [ 243409 ] {c165d3b4-0fbb-4c80-8d41-5c69d98b6878} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
746 2025.03.17 16:41:06.380052 [ 243409 ] {c165d3b4-0fbb-4c80-8d41-5c69d98b6878} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.09 GiB.
747 2025.03.17 16:41:06.380507 [ 243409 ] {c165d3b4-0fbb-4c80-8d41-5c69d98b6878} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary)
748 2025.03.17 16:41:06.380717 [ 243409 ] {c165d3b4-0fbb-4c80-8d41-5c69d98b6878} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
749 2025.03.17 16:41:06.380882 [ 242683 ] {} <Debug> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0
750 2025.03.17 16:41:06.380914 [ 242683 ] {} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
751 2025.03.17 16:41:06.380928 [ 242683 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.09 GiB.
752 2025.03.17 16:41:06.380943 [ 243409 ] {c165d3b4-0fbb-4c80-8d41-5c69d98b6878} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.130705 sec., 7.6508167246853604 rows/sec., 543.21 B/sec.
753 2025.03.17 16:41:06.381021 [ 243409 ] {c165d3b4-0fbb-4c80-8d41-5c69d98b6878} <Debug> TCPHandler: Processed in 0.132135946 sec.
754 2025.03.17 16:41:06.381251 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full
755 2025.03.17 16:41:06.381328 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal
756 2025.03.17 16:41:06.381357 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 1 rows starting from the beginning of the part
757 2025.03.17 16:41:06.381443 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 1 rows starting from the beginning of the part
758 2025.03.17 16:41:06.381496 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 1 rows starting from the beginning of the part
759 2025.03.17 16:41:06.381543 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 1 rows starting from the beginning of the part
760 2025.03.17 16:41:06.381681 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 1 rows starting from the beginning of the part
761 2025.03.17 16:41:06.382695 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 5 rows, containing 4 columns (4 merged, 0 gathered) in 0.001563222 sec., 3198.522026941791 rows/sec., 221.77 KiB/sec.
762 2025.03.17 16:41:06.382850 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary)
763 2025.03.17 16:41:06.383011 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
764 2025.03.17 16:41:06.383048 [ 242849 ] {97a0062f-5a6b-4dfa-8966-748336e3661f::all_1_5_1} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1
765 2025.03.17 16:41:06.383106 [ 242849 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.27 MiB.
766 2025.03.17 16:41:08.245865 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
767 2025.03.17 16:41:08.246028 [ 243409 ] {5c2afdf8-f689-4fbc-bb1f-247295db5cae} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete)
768 2025.03.17 16:41:08.246079 [ 243409 ] {5c2afdf8-f689-4fbc-bb1f-247295db5cae} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
769 2025.03.17 16:41:08.246827 [ 243409 ] {5c2afdf8-f689-4fbc-bb1f-247295db5cae} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Trying to reserve 1.00 MiB using storage policy from min volume index 0
770 2025.03.17 16:41:08.246855 [ 243409 ] {5c2afdf8-f689-4fbc-bb1f-247295db5cae} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.43 GiB.
771 2025.03.17 16:41:08.247136 [ 243409 ] {5c2afdf8-f689-4fbc-bb1f-247295db5cae} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary)
772 2025.03.17 16:41:08.247262 [ 243409 ] {5c2afdf8-f689-4fbc-bb1f-247295db5cae} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
773 2025.03.17 16:41:08.247413 [ 243409 ] {5c2afdf8-f689-4fbc-bb1f-247295db5cae} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.001432 sec., 1396.6480446927376 rows/sec., 144.57 KiB/sec.
774 2025.03.17 16:41:08.247469 [ 243409 ] {5c2afdf8-f689-4fbc-bb1f-247295db5cae} <Debug> TCPHandler: Processed in 0.001789601 sec.
775 2025.03.17 16:41:08.247732 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
776 2025.03.17 16:41:08.247850 [ 243409 ] {0d2db107-1a8c-40e5-92ce-58fccfb230cf} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete)
777 2025.03.17 16:41:08.247890 [ 243409 ] {0d2db107-1a8c-40e5-92ce-58fccfb230cf} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
778 2025.03.17 16:41:08.248529 [ 243409 ] {0d2db107-1a8c-40e5-92ce-58fccfb230cf} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
779 2025.03.17 16:41:08.250176 [ 243409 ] {0d2db107-1a8c-40e5-92ce-58fccfb230cf} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.43 GiB.
780 2025.03.17 16:41:08.250437 [ 243409 ] {0d2db107-1a8c-40e5-92ce-58fccfb230cf} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary)
781 2025.03.17 16:41:08.250604 [ 243409 ] {0d2db107-1a8c-40e5-92ce-58fccfb230cf} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
782 2025.03.17 16:41:08.250804 [ 243409 ] {0d2db107-1a8c-40e5-92ce-58fccfb230cf} <Debug> executeQuery: Read 2 rows, 142.00 B in 0.002983 sec., 670.465973851827 rows/sec., 46.49 KiB/sec.
783 2025.03.17 16:41:08.250842 [ 243409 ] {0d2db107-1a8c-40e5-92ce-58fccfb230cf} <Debug> TCPHandler: Processed in 0.003177033 sec.
784 2025.03.17 16:41:09.047588 [ 242855 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 116 entries to flush up to offset 116
785 2025.03.17 16:41:09.049160 [ 242855 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog
786 2025.03.17 16:41:09.057190 [ 242855 ] {} <Debug> system.query_log (ec8380c4-9f0b-4959-88d3-d1193fdd19a0): Loading data parts
787 2025.03.17 16:41:09.057508 [ 242855 ] {} <Debug> system.query_log (ec8380c4-9f0b-4959-88d3-d1193fdd19a0): There are no data parts
788 2025.03.17 16:41:09.070444 [ 242855 ] {} <Trace> system.query_log (ec8380c4-9f0b-4959-88d3-d1193fdd19a0): Trying to reserve 1.00 MiB using storage policy from min volume index 0
789 2025.03.17 16:41:09.070477 [ 242855 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.36 GiB.
790 2025.03.17 16:41:09.073536 [ 242855 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
791 2025.03.17 16:41:09.073724 [ 242855 ] {} <Trace> system.query_log (ec8380c4-9f0b-4959-88d3-d1193fdd19a0): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
792 2025.03.17 16:41:09.073959 [ 242855 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 116
793 2025.03.17 16:41:09.245548 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
794 2025.03.17 16:41:09.245743 [ 243409 ] {9e0426e8-8ce2-4caa-9ff0-47d25d6e05d6} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete)
795 2025.03.17 16:41:09.245805 [ 243409 ] {9e0426e8-8ce2-4caa-9ff0-47d25d6e05d6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
796 2025.03.17 16:41:09.246688 [ 243409 ] {9e0426e8-8ce2-4caa-9ff0-47d25d6e05d6} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Trying to reserve 1.00 MiB using storage policy from min volume index 0
797 2025.03.17 16:41:09.247579 [ 243409 ] {9e0426e8-8ce2-4caa-9ff0-47d25d6e05d6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.36 GiB.
798 2025.03.17 16:41:09.248030 [ 243409 ] {9e0426e8-8ce2-4caa-9ff0-47d25d6e05d6} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary)
799 2025.03.17 16:41:09.248230 [ 243409 ] {9e0426e8-8ce2-4caa-9ff0-47d25d6e05d6} <Trace> oximeter.fields_string (f56deebf-3f0a-44aa-89dc-a92ce1124800): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
800 2025.03.17 16:41:09.248464 [ 243409 ] {9e0426e8-8ce2-4caa-9ff0-47d25d6e05d6} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002777 sec., 720.2016564638099 rows/sec., 74.55 KiB/sec.
801 2025.03.17 16:41:09.248507 [ 243409 ] {9e0426e8-8ce2-4caa-9ff0-47d25d6e05d6} <Debug> TCPHandler: Processed in 0.003111312 sec.
802 2025.03.17 16:41:09.248884 [ 243409 ] {} <Trace> TCP-Session: ad2da48b-191b-4c24-92d7-5a72b8e82df0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
803 2025.03.17 16:41:09.250051 [ 243409 ] {0c70407e-d213-478a-814c-8dad83034e56} <Debug> executeQuery: (from [::1]:44220) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete)
804 2025.03.17 16:41:09.250101 [ 243409 ] {0c70407e-d213-478a-814c-8dad83034e56} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
805 2025.03.17 16:41:09.250752 [ 243409 ] {0c70407e-d213-478a-814c-8dad83034e56} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
806 2025.03.17 16:41:09.252174 [ 243409 ] {0c70407e-d213-478a-814c-8dad83034e56} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.36 GiB.
807 2025.03.17 16:41:09.252471 [ 243409 ] {0c70407e-d213-478a-814c-8dad83034e56} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary)
808 2025.03.17 16:41:09.252649 [ 243409 ] {0c70407e-d213-478a-814c-8dad83034e56} <Trace> oximeter.measurements_i64 (97a0062f-5a6b-4dfa-8966-748336e3661f): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
809 2025.03.17 16:41:09.252845 [ 243409 ] {0c70407e-d213-478a-814c-8dad83034e56} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002828 sec., 353.60678925035364 rows/sec., 24.52 KiB/sec.
810 2025.03.17 16:41:09.252887 [ 243409 ] {0c70407e-d213-478a-814c-8dad83034e56} <Debug> TCPHandler: Processed in 0.004077333 sec.
811 2025.03.17 16:41:10.000441 [ 242861 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 406.95 MiB, peak 406.95 MiB, free memory in arenas 30.29 MiB, will set to 403.61 MiB (RSS), difference: -3.34 MiB