1 | 2025.03.07 23:25:43.760471 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 25047 | ||
2 | 2025.03.07 23:25:43.760718 [ 1 ] {} <Information> Application: starting up | ||
3 | 2025.03.07 23:25:43.760783 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2025.03.07 23:25:43.768000 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2025.03.07 23:25:43.775430 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2025.03.07 23:25:43.775469 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2025.03.07 23:25:43.775482 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2025.03.07 23:25:43.775550 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/datastore/tmp/ to store temporary data in it | ||
9 | 2025.03.07 23:25:43.776088 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2025.03.07 23:25:43.776795 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/config.xml' | ||
11 | 2025.03.07 23:25:43.777826 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/config.xml', performing update on configuration | ||
12 | 2025.03.07 23:25:43.778316 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.18 GiB (31.32 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
13 | 2025.03.07 23:25:43.778344 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.66 GiB (31.32 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
14 | 2025.03.07 23:25:43.778356 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2025.03.07 23:25:43.778499 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2025.03.07 23:25:43.779559 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2025.03.07 23:25:43.821856 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2025.03.07 23:25:43.823286 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2025.03.07 23:25:43.825245 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
20 | 2025.03.07 23:25:43.825333 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/config.xml', performed update on configuration | ||
21 | 2025.03.07 23:25:43.826244 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/config.xml' | ||
22 | 2025.03.07 23:25:43.827004 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/config.xml', performing update on configuration | ||
23 | 2025.03.07 23:25:43.828487 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/config.xml', performed update on configuration | ||
24 | 2025.03.07 23:25:43.829072 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/config.xml | ||
25 | 2025.03.07 23:25:43.830722 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
26 | 2025.03.07 23:25:43.831395 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2025.03.07 23:25:43.832115 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2025.03.07 23:25:43.832705 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
29 | 2025.03.07 23:25:43.834659 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2025.03.07 23:25:43.834700 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/datastore/ | ||
31 | 2025.03.07 23:25:43.836305 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
32 | 2025.03.07 23:25:43.836330 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000131136 sec | ||
33 | 2025.03.07 23:25:43.836361 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
34 | 2025.03.07 23:25:43.836371 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
35 | 2025.03.07 23:25:43.836442 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
36 | 2025.03.07 23:25:43.836490 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
37 | 2025.03.07 23:25:43.838496 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
38 | 2025.03.07 23:25:43.838542 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
39 | 2025.03.07 23:25:43.838560 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
40 | 2025.03.07 23:25:43.838580 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
41 | 2025.03.07 23:25:43.838608 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
42 | 2025.03.07 23:25:43.838625 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
43 | 2025.03.07 23:25:43.841988 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
44 | 2025.03.07 23:25:43.842045 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
45 | 2025.03.07 23:25:43.842063 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
46 | 2025.03.07 23:25:43.842306 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
47 | 2025.03.07 23:25:43.842332 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
48 | 2025.03.07 23:25:43.842355 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
49 | 2025.03.07 23:25:43.842367 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
50 | 2025.03.07 23:25:43.842395 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
51 | 2025.03.07 23:25:43.842407 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
52 | 2025.03.07 23:25:43.842419 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
53 | 2025.03.07 23:25:43.843772 [ 157 ] {} <Debug> DNSResolver: Updating DNS cache | ||
54 | 2025.03.07 23:25:43.843828 [ 157 ] {} <Debug> DNSResolver: Updated DNS cache | ||
55 | 2025.03.07 23:25:43.871227 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2025.03.07 23:25:43.871839 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2025.03.07 23:25:43.871865 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.1105e-05 sec | ||
58 | 2025.03.07 23:25:43.871878 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2025.03.07 23:25:43.871887 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2025.03.07 23:25:43.871914 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2025.03.07 23:25:43.872083 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-af17aa9935ab6510-test_roles_builtin.25031.1-clickhouse-k7fDTr/datastore/user_defined/ | ||
62 | 2025.03.07 23:25:43.872148 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2025.03.07 23:25:43.872160 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2025.03.07 23:25:43.872171 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
65 | 2025.03.07 23:25:43.872182 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2025.03.07 23:25:43.872546 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 58186 | ||
67 | 2025.03.07 23:25:43.872716 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 63713 | ||
68 | 2025.03.07 23:25:43.873807 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 48555 | ||
69 | 2025.03.07 23:25:43.873872 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44779 | ||
70 | 2025.03.07 23:25:43.873909 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
71 | 2025.03.07 23:25:43.874210 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.76 MiB, peak 24.76 MiB, free memory in arenas 0.00 B, will set to 134.86 MiB (RSS), difference: 110.10 MiB | ||
72 | 2025.03.07 23:25:43.874540 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.516e-05 sec. | ||
73 | 2025.03.07 23:25:43.875353 [ 1 ] {} <Information> Application: Listening for http://[::1]:58186 | ||
74 | 2025.03.07 23:25:43.875428 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:63713 | ||
75 | 2025.03.07 23:25:43.883985 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:48555 | ||
76 | 2025.03.07 23:25:43.884538 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:44779 | ||
77 | 2025.03.07 23:25:43.884624 [ 1 ] {} <Information> Application: Ready for connections. | ||
78 | 2025.03.07 23:25:44.002534 [ 248 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 134.87 MiB, peak 134.87 MiB, free memory in arenas 0.00 B, will set to 136.17 MiB (RSS), difference: 1.29 MiB | ||
79 | 2025.03.07 23:25:44.766635 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:48584 | ||
80 | 2025.03.07 23:25:44.772222 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
81 | 2025.03.07 23:25:44.772332 [ 3 ] {} <Debug> TCP-Session: d9540b53-b202-41a0-a833-f25fd56d2f1a Authenticating user 'default' from [::1]:48584 | ||
82 | 2025.03.07 23:25:44.772374 [ 3 ] {} <Debug> TCP-Session: d9540b53-b202-41a0-a833-f25fd56d2f1a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
83 | 2025.03.07 23:25:44.772393 [ 3 ] {} <Debug> TCP-Session: d9540b53-b202-41a0-a833-f25fd56d2f1a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2025.03.07 23:25:44.772500 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
85 | 2025.03.07 23:25:44.772536 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
86 | 2025.03.07 23:25:44.772576 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
87 | 2025.03.07 23:25:44.778939 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:33160 | ||
88 | 2025.03.07 23:25:44.779250 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:34121 | ||
89 | 2025.03.07 23:25:44.779438 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:38785 | ||
90 | 2025.03.07 23:25:44.779921 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:38757 | ||
91 | 2025.03.07 23:25:44.779923 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:59794 | ||
92 | 2025.03.07 23:25:44.780326 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:60021 | ||
93 | 2025.03.07 23:25:44.780333 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:42254 | ||
94 | 2025.03.07 23:25:44.780846 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
95 | 2025.03.07 23:25:44.780884 [ 5 ] {} <Debug> TCP-Session: ab0975a0-4104-4701-abb6-58ec018aa03c Authenticating user 'default' from [::1]:33160 | ||
96 | 2025.03.07 23:25:44.780910 [ 5 ] {} <Debug> TCP-Session: ab0975a0-4104-4701-abb6-58ec018aa03c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
97 | 2025.03.07 23:25:44.780930 [ 5 ] {} <Debug> TCP-Session: ab0975a0-4104-4701-abb6-58ec018aa03c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
98 | 2025.03.07 23:25:44.781053 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
99 | 2025.03.07 23:25:44.781103 [ 255 ] {} <Debug> TCP-Session: 9de314bc-2f26-4a72-a758-81637ff8279d Authenticating user 'default' from [::1]:34121 | ||
100 | 2025.03.07 23:25:44.781115 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
101 | 2025.03.07 23:25:44.781130 [ 255 ] {} <Debug> TCP-Session: 9de314bc-2f26-4a72-a758-81637ff8279d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
102 | 2025.03.07 23:25:44.781167 [ 256 ] {} <Debug> TCP-Session: 72684cc0-ca53-4a0a-acbe-d246a757bd2a Authenticating user 'default' from [::1]:38785 | ||
103 | 2025.03.07 23:25:44.781181 [ 255 ] {} <Debug> TCP-Session: 9de314bc-2f26-4a72-a758-81637ff8279d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
104 | 2025.03.07 23:25:44.781190 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
105 | 2025.03.07 23:25:44.781205 [ 256 ] {} <Debug> TCP-Session: 72684cc0-ca53-4a0a-acbe-d246a757bd2a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
106 | 2025.03.07 23:25:44.781252 [ 4 ] {} <Debug> TCP-Session: 41b51436-0347-443d-82c2-afc35e257bec Authenticating user 'default' from [::1]:38757 | ||
107 | 2025.03.07 23:25:44.781257 [ 256 ] {} <Debug> TCP-Session: 72684cc0-ca53-4a0a-acbe-d246a757bd2a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
108 | 2025.03.07 23:25:44.781290 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
109 | 2025.03.07 23:25:44.781298 [ 4 ] {} <Debug> TCP-Session: 41b51436-0347-443d-82c2-afc35e257bec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
110 | 2025.03.07 23:25:44.781352 [ 257 ] {} <Debug> TCP-Session: 0c5c7f7c-4093-425e-b03f-e5b4401936d1 Authenticating user 'default' from [::1]:59794 | ||
111 | 2025.03.07 23:25:44.781357 [ 4 ] {} <Debug> TCP-Session: 41b51436-0347-443d-82c2-afc35e257bec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
112 | 2025.03.07 23:25:44.781377 [ 257 ] {} <Debug> TCP-Session: 0c5c7f7c-4093-425e-b03f-e5b4401936d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
113 | 2025.03.07 23:25:44.781378 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
114 | 2025.03.07 23:25:44.781414 [ 257 ] {} <Debug> TCP-Session: 0c5c7f7c-4093-425e-b03f-e5b4401936d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
115 | 2025.03.07 23:25:44.781446 [ 259 ] {} <Debug> TCP-Session: 075ee5cc-146e-485d-b472-19c7c612ec79 Authenticating user 'default' from [::1]:42254 | ||
116 | 2025.03.07 23:25:44.781466 [ 259 ] {} <Debug> TCP-Session: 075ee5cc-146e-485d-b472-19c7c612ec79 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
117 | 2025.03.07 23:25:44.781492 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
118 | 2025.03.07 23:25:44.781493 [ 259 ] {} <Debug> TCP-Session: 075ee5cc-146e-485d-b472-19c7c612ec79 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
119 | 2025.03.07 23:25:44.781540 [ 258 ] {} <Debug> TCP-Session: d2f37448-7cdb-4a1f-9aea-a90028e2dc20 Authenticating user 'default' from [::1]:60021 | ||
120 | 2025.03.07 23:25:44.781565 [ 258 ] {} <Debug> TCP-Session: d2f37448-7cdb-4a1f-9aea-a90028e2dc20 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
121 | 2025.03.07 23:25:44.781580 [ 258 ] {} <Debug> TCP-Session: d2f37448-7cdb-4a1f-9aea-a90028e2dc20 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
122 | 2025.03.07 23:25:51.342916 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 549 entries to flush up to offset 549 | ||
123 | 2025.03.07 23:25:51.342937 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
124 | 2025.03.07 23:25:51.343076 [ 244 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
125 | 2025.03.07 23:25:51.343093 [ 245 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
126 | 2025.03.07 23:25:51.349868 [ 244 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
127 | 2025.03.07 23:25:51.350292 [ 244 ] {} <Debug> system.asynchronous_metric_log (605d7eba-545d-4417-9969-dfec92cd79c4): Loading data parts | ||
128 | 2025.03.07 23:25:51.351006 [ 244 ] {} <Debug> system.asynchronous_metric_log (605d7eba-545d-4417-9969-dfec92cd79c4): There are no data parts | ||
129 | 2025.03.07 23:25:51.355381 [ 244 ] {} <Trace> system.asynchronous_metric_log (605d7eba-545d-4417-9969-dfec92cd79c4): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
130 | 2025.03.07 23:25:51.355467 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
131 | 2025.03.07 23:25:51.357273 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
132 | 2025.03.07 23:25:51.357978 [ 244 ] {} <Trace> system.asynchronous_metric_log (605d7eba-545d-4417-9969-dfec92cd79c4): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
133 | 2025.03.07 23:25:51.358650 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 549 | ||
134 | 2025.03.07 23:25:51.371103 [ 245 ] {} <Debug> system.metric_log (d59909d1-ccaa-4d06-9b30-88209bb422b6): Loading data parts | ||
135 | 2025.03.07 23:25:51.371515 [ 245 ] {} <Debug> system.metric_log (d59909d1-ccaa-4d06-9b30-88209bb422b6): There are no data parts | ||
136 | 2025.03.07 23:25:51.409678 [ 245 ] {} <Trace> system.metric_log (d59909d1-ccaa-4d06-9b30-88209bb422b6): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
137 | 2025.03.07 23:25:51.409794 [ 245 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
138 | 2025.03.07 23:25:51.447812 [ 245 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
139 | 2025.03.07 23:25:51.449732 [ 245 ] {} <Trace> system.metric_log (d59909d1-ccaa-4d06-9b30-88209bb422b6): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
140 | 2025.03.07 23:25:51.455342 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
141 | 2025.03.07 23:25:52.000465 [ 248 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 141.56 MiB, peak 145.56 MiB, free memory in arenas 0.00 B, will set to 148.43 MiB (RSS), difference: 6.87 MiB | ||
142 | 2025.03.07 23:25:55.008134 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:42346 | ||
143 | 2025.03.07 23:25:55.008622 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
144 | 2025.03.07 23:25:55.008678 [ 261 ] {} <Debug> TCP-Session: dea0c175-e65e-4421-ab7b-86d114105f1c Authenticating user 'default' from [::1]:42346 | ||
145 | 2025.03.07 23:25:55.008706 [ 261 ] {} <Debug> TCP-Session: dea0c175-e65e-4421-ab7b-86d114105f1c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2025.03.07 23:25:55.008722 [ 261 ] {} <Debug> TCP-Session: dea0c175-e65e-4421-ab7b-86d114105f1c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
147 | 2025.03.07 23:25:55.025204 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:63260 | ||
148 | 2025.03.07 23:25:55.025351 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:60653 | ||
149 | 2025.03.07 23:25:55.025537 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:36165 | ||
150 | 2025.03.07 23:25:55.025732 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:42036 | ||
151 | 2025.03.07 23:25:55.026107 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:49882 | ||
152 | 2025.03.07 23:25:55.026289 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56469 | ||
153 | 2025.03.07 23:25:55.026304 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:36847 | ||
154 | 2025.03.07 23:25:55.026478 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:61749 | ||
155 | 2025.03.07 23:25:55.027117 [ 261 ] {} <Trace> TCP-Session: dea0c175-e65e-4421-ab7b-86d114105f1c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
156 | 2025.03.07 23:25:55.027592 [ 261 ] {7d810ac3-2f38-4394-92db-8832fdcf0c09} <Debug> executeQuery: (from [::1]:42346) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
157 | 2025.03.07 23:25:55.034673 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
158 | 2025.03.07 23:25:55.034700 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
159 | 2025.03.07 23:25:55.034736 [ 262 ] {} <Debug> TCP-Session: 75e8f273-b112-42f9-b439-4081104bdcc9 Authenticating user 'default' from [::1]:63260 | ||
160 | 2025.03.07 23:25:55.034737 [ 264 ] {} <Debug> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Authenticating user 'default' from [::1]:60653 | ||
161 | 2025.03.07 23:25:55.034751 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
162 | 2025.03.07 23:25:55.034767 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
163 | 2025.03.07 23:25:55.034787 [ 262 ] {} <Debug> TCP-Session: 75e8f273-b112-42f9-b439-4081104bdcc9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
164 | 2025.03.07 23:25:55.034802 [ 263 ] {} <Debug> TCP-Session: fbeb2898-3f2d-4044-bb55-c32317d0ae4e Authenticating user 'default' from [::1]:36847 | ||
165 | 2025.03.07 23:25:55.034820 [ 262 ] {} <Debug> TCP-Session: 75e8f273-b112-42f9-b439-4081104bdcc9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
166 | 2025.03.07 23:25:55.034824 [ 265 ] {} <Debug> TCP-Session: 7bc9d635-ffd0-4521-afc9-e191be9e0323 Authenticating user 'default' from [::1]:36165 | ||
167 | 2025.03.07 23:25:55.034785 [ 264 ] {} <Debug> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
168 | 2025.03.07 23:25:55.034851 [ 263 ] {} <Debug> TCP-Session: fbeb2898-3f2d-4044-bb55-c32317d0ae4e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
169 | 2025.03.07 23:25:55.034858 [ 265 ] {} <Debug> TCP-Session: 7bc9d635-ffd0-4521-afc9-e191be9e0323 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
170 | 2025.03.07 23:25:55.034877 [ 264 ] {} <Debug> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
171 | 2025.03.07 23:25:55.034893 [ 263 ] {} <Debug> TCP-Session: fbeb2898-3f2d-4044-bb55-c32317d0ae4e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
172 | 2025.03.07 23:25:55.034902 [ 265 ] {} <Debug> TCP-Session: 7bc9d635-ffd0-4521-afc9-e191be9e0323 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
173 | 2025.03.07 23:25:55.035054 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
174 | 2025.03.07 23:25:55.035085 [ 266 ] {} <Debug> TCP-Session: 6755dd4b-7c4e-42cb-8e43-f066e9844b0c Authenticating user 'default' from [::1]:42036 | ||
175 | 2025.03.07 23:25:55.035101 [ 266 ] {} <Debug> TCP-Session: 6755dd4b-7c4e-42cb-8e43-f066e9844b0c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
176 | 2025.03.07 23:25:55.035122 [ 266 ] {} <Debug> TCP-Session: 6755dd4b-7c4e-42cb-8e43-f066e9844b0c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
177 | 2025.03.07 23:25:55.035149 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
178 | 2025.03.07 23:25:55.035165 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
179 | 2025.03.07 23:25:55.035188 [ 267 ] {} <Debug> TCP-Session: e90c5aeb-267e-4135-812a-b895bd62d48f Authenticating user 'default' from [::1]:56469 | ||
180 | 2025.03.07 23:25:55.035212 [ 268 ] {} <Debug> TCP-Session: 9bd6b85d-4c24-455b-94b1-1f22860cf58f Authenticating user 'default' from [::1]:49882 | ||
181 | 2025.03.07 23:25:55.035214 [ 267 ] {} <Debug> TCP-Session: e90c5aeb-267e-4135-812a-b895bd62d48f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
182 | 2025.03.07 23:25:55.035233 [ 268 ] {} <Debug> TCP-Session: 9bd6b85d-4c24-455b-94b1-1f22860cf58f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
183 | 2025.03.07 23:25:55.035244 [ 267 ] {} <Debug> TCP-Session: e90c5aeb-267e-4135-812a-b895bd62d48f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
184 | 2025.03.07 23:25:55.035252 [ 268 ] {} <Debug> TCP-Session: 9bd6b85d-4c24-455b-94b1-1f22860cf58f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
185 | 2025.03.07 23:25:55.035639 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
186 | 2025.03.07 23:25:55.035675 [ 269 ] {} <Debug> TCP-Session: da85ddc4-f4ab-468b-9517-fbcf45ee1c16 Authenticating user 'default' from [::1]:61749 | ||
187 | 2025.03.07 23:25:55.035693 [ 269 ] {} <Debug> TCP-Session: da85ddc4-f4ab-468b-9517-fbcf45ee1c16 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
188 | 2025.03.07 23:25:55.035707 [ 269 ] {} <Debug> TCP-Session: da85ddc4-f4ab-468b-9517-fbcf45ee1c16 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
189 | 2025.03.07 23:25:55.037341 [ 261 ] {7d810ac3-2f38-4394-92db-8832fdcf0c09} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:42346) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
190 | |||
191 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
192 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
193 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
197 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
198 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
199 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
200 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
201 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
202 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
203 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
204 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
205 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
206 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
207 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
208 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
209 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
210 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
211 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
212 | |||
213 | 2025.03.07 23:25:55.037592 [ 261 ] {7d810ac3-2f38-4394-92db-8832fdcf0c09} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
214 | |||
215 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
216 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
217 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
218 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
219 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
220 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
221 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
222 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
223 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
224 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
225 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
226 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
227 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
228 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
229 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
230 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
231 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
232 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
233 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
234 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
235 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
236 | |||
237 | 2025.03.07 23:25:55.037678 [ 261 ] {7d810ac3-2f38-4394-92db-8832fdcf0c09} <Debug> TCPHandler: Processed in 0.011133138 sec. | ||
238 | 2025.03.07 23:25:55.138891 [ 261 ] {} <Debug> TCPHandler: Done processing connection. | ||
239 | 2025.03.07 23:25:55.138970 [ 261 ] {} <Debug> TCP-Session: dea0c175-e65e-4421-ab7b-86d114105f1c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
240 | 2025.03.07 23:25:55.139628 [ 262 ] {} <Trace> TCP-Session: 75e8f273-b112-42f9-b439-4081104bdcc9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
241 | 2025.03.07 23:25:55.139936 [ 262 ] {50bace13-3d4a-4a20-9224-c25327a4bba7} <Debug> executeQuery: (from [::1]:63260) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
242 | 2025.03.07 23:25:55.140453 [ 262 ] {50bace13-3d4a-4a20-9224-c25327a4bba7} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:63260) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
243 | |||
244 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
245 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
246 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
247 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
248 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
249 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
250 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
251 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
252 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
253 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
254 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
255 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
256 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
257 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
258 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
259 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
260 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
261 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
262 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
263 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
264 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
265 | |||
266 | 2025.03.07 23:25:55.140611 [ 262 ] {50bace13-3d4a-4a20-9224-c25327a4bba7} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
267 | |||
268 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
269 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
270 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
271 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
272 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
273 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
274 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
275 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
276 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
277 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
278 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
279 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
280 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
281 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
282 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
283 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
284 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
285 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
286 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
287 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
288 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
289 | |||
290 | 2025.03.07 23:25:55.140682 [ 262 ] {50bace13-3d4a-4a20-9224-c25327a4bba7} <Debug> TCPHandler: Processed in 0.001292513 sec. | ||
291 | 2025.03.07 23:25:55.153232 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
292 | 2025.03.07 23:25:55.153495 [ 264 ] {04904292-854f-42c9-b8d1-533f3076d914} <Debug> executeQuery: (from [::1]:60653) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
293 | 2025.03.07 23:25:55.153616 [ 264 ] {04904292-854f-42c9-b8d1-533f3076d914} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
294 | 2025.03.07 23:25:55.154187 [ 264 ] {04904292-854f-42c9-b8d1-533f3076d914} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
295 | 2025.03.07 23:25:55.154211 [ 264 ] {04904292-854f-42c9-b8d1-533f3076d914} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.0379e-05 sec | ||
296 | 2025.03.07 23:25:55.154227 [ 264 ] {04904292-854f-42c9-b8d1-533f3076d914} <Trace> ReferentialDeps: No tables | ||
297 | 2025.03.07 23:25:55.154239 [ 264 ] {04904292-854f-42c9-b8d1-533f3076d914} <Trace> LoadingDeps: No tables | ||
298 | 2025.03.07 23:25:55.154277 [ 264 ] {04904292-854f-42c9-b8d1-533f3076d914} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
299 | 2025.03.07 23:25:55.154357 [ 264 ] {04904292-854f-42c9-b8d1-533f3076d914} <Debug> TCPHandler: Processed in 0.001363773 sec. | ||
300 | 2025.03.07 23:25:55.247310 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
301 | 2025.03.07 23:25:55.247667 [ 264 ] {c59eb6e7-9441-4ff8-9b7e-dc6fbf32ba11} <Debug> executeQuery: (from [::1]:60653) /* The version table contains metadata about the `oximeter` database */ | ||
302 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
303 | 2025.03.07 23:25:55.247915 [ 264 ] {c59eb6e7-9441-4ff8-9b7e-dc6fbf32ba11} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
304 | 2025.03.07 23:25:55.249241 [ 264 ] {c59eb6e7-9441-4ff8-9b7e-dc6fbf32ba11} <Debug> oximeter.version (4cafda08-ace9-45ba-8eb9-d4371fa52489): Loading data parts | ||
305 | 2025.03.07 23:25:55.249605 [ 264 ] {c59eb6e7-9441-4ff8-9b7e-dc6fbf32ba11} <Debug> oximeter.version (4cafda08-ace9-45ba-8eb9-d4371fa52489): There are no data parts | ||
306 | 2025.03.07 23:25:55.250182 [ 264 ] {c59eb6e7-9441-4ff8-9b7e-dc6fbf32ba11} <Debug> TCPHandler: Processed in 0.003138861 sec. | ||
307 | 2025.03.07 23:25:55.261371 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
308 | 2025.03.07 23:25:55.261864 [ 264 ] {ba73c559-bdbe-405b-a8b9-c3618d846891} <Debug> executeQuery: (from [::1]:60653) /* The measurement tables contain all individual samples from each timeseries. | ||
309 | * | ||
310 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
311 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
312 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
313 | * by all samples from the same timeseries. | ||
314 | * | ||
315 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
316 | * and then uses that to index quickly into the measurements tables. | ||
317 | */ | ||
318 | 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) | ||
319 | 2025.03.07 23:25:55.261964 [ 264 ] {ba73c559-bdbe-405b-a8b9-c3618d846891} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
320 | 2025.03.07 23:25:55.263805 [ 264 ] {ba73c559-bdbe-405b-a8b9-c3618d846891} <Debug> oximeter.measurements_bool (6e2fbe7d-6157-45fc-a4cb-f7f400e8f491): Loading data parts | ||
321 | 2025.03.07 23:25:55.264157 [ 264 ] {ba73c559-bdbe-405b-a8b9-c3618d846891} <Debug> oximeter.measurements_bool (6e2fbe7d-6157-45fc-a4cb-f7f400e8f491): There are no data parts | ||
322 | 2025.03.07 23:25:55.264777 [ 264 ] {ba73c559-bdbe-405b-a8b9-c3618d846891} <Debug> TCPHandler: Processed in 0.003648655 sec. | ||
323 | 2025.03.07 23:25:55.274854 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
324 | 2025.03.07 23:25:55.275312 [ 264 ] {8639f403-949e-4b2d-a361-9cb7b8a4f160} <Debug> executeQuery: (from [::1]:60653) 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) | ||
325 | 2025.03.07 23:25:55.275420 [ 264 ] {8639f403-949e-4b2d-a361-9cb7b8a4f160} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
326 | 2025.03.07 23:25:55.277165 [ 264 ] {8639f403-949e-4b2d-a361-9cb7b8a4f160} <Debug> oximeter.measurements_i8 (bceea910-7a95-49a0-a138-3cdb0bf4ea1a): Loading data parts | ||
327 | 2025.03.07 23:25:55.277552 [ 264 ] {8639f403-949e-4b2d-a361-9cb7b8a4f160} <Debug> oximeter.measurements_i8 (bceea910-7a95-49a0-a138-3cdb0bf4ea1a): There are no data parts | ||
328 | 2025.03.07 23:25:55.278183 [ 264 ] {8639f403-949e-4b2d-a361-9cb7b8a4f160} <Debug> TCPHandler: Processed in 0.003494741 sec. | ||
329 | 2025.03.07 23:25:55.937131 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
330 | 2025.03.07 23:25:55.937542 [ 264 ] {9350f8b2-18c5-4126-bcb9-3186a076f6f2} <Debug> executeQuery: (from [::1]:60653) 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) | ||
331 | 2025.03.07 23:25:55.937634 [ 264 ] {9350f8b2-18c5-4126-bcb9-3186a076f6f2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
332 | 2025.03.07 23:25:55.939220 [ 264 ] {9350f8b2-18c5-4126-bcb9-3186a076f6f2} <Debug> oximeter.measurements_u8 (356db155-958c-4e58-8698-16c28645dc7c): Loading data parts | ||
333 | 2025.03.07 23:25:55.939576 [ 264 ] {9350f8b2-18c5-4126-bcb9-3186a076f6f2} <Debug> oximeter.measurements_u8 (356db155-958c-4e58-8698-16c28645dc7c): There are no data parts | ||
334 | 2025.03.07 23:25:55.940188 [ 264 ] {9350f8b2-18c5-4126-bcb9-3186a076f6f2} <Debug> TCPHandler: Processed in 0.003358013 sec. | ||
335 | 2025.03.07 23:25:56.000470 [ 248 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 152.93 MiB, peak 152.93 MiB, free memory in arenas 0.00 B, will set to 154.50 MiB (RSS), difference: 1.57 MiB | ||
336 | 2025.03.07 23:25:56.058721 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
337 | 2025.03.07 23:25:56.059159 [ 264 ] {a66c957e-e634-4695-923b-04af1a1db726} <Debug> executeQuery: (from [::1]:60653) 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) | ||
338 | 2025.03.07 23:25:56.059256 [ 264 ] {a66c957e-e634-4695-923b-04af1a1db726} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
339 | 2025.03.07 23:25:56.061053 [ 264 ] {a66c957e-e634-4695-923b-04af1a1db726} <Debug> oximeter.measurements_i16 (8e726f53-691b-4b9a-9023-f2fd0543c2a5): Loading data parts | ||
340 | 2025.03.07 23:25:56.061467 [ 264 ] {a66c957e-e634-4695-923b-04af1a1db726} <Debug> oximeter.measurements_i16 (8e726f53-691b-4b9a-9023-f2fd0543c2a5): There are no data parts | ||
341 | 2025.03.07 23:25:56.062085 [ 264 ] {a66c957e-e634-4695-923b-04af1a1db726} <Debug> TCPHandler: Processed in 0.003581486 sec. | ||
342 | 2025.03.07 23:25:56.062872 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
343 | 2025.03.07 23:25:56.063176 [ 264 ] {b5de157f-9474-4986-90c4-a98e3d59b47b} <Debug> executeQuery: (from [::1]:60653) 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) | ||
344 | 2025.03.07 23:25:56.063261 [ 264 ] {b5de157f-9474-4986-90c4-a98e3d59b47b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
345 | 2025.03.07 23:25:56.064767 [ 264 ] {b5de157f-9474-4986-90c4-a98e3d59b47b} <Debug> oximeter.measurements_u16 (d8e47b1c-56f4-4ab1-a9f9-3f4432e35940): Loading data parts | ||
346 | 2025.03.07 23:25:56.065129 [ 264 ] {b5de157f-9474-4986-90c4-a98e3d59b47b} <Debug> oximeter.measurements_u16 (d8e47b1c-56f4-4ab1-a9f9-3f4432e35940): There are no data parts | ||
347 | 2025.03.07 23:25:56.065663 [ 264 ] {b5de157f-9474-4986-90c4-a98e3d59b47b} <Debug> TCPHandler: Processed in 0.002908767 sec. | ||
348 | 2025.03.07 23:25:56.073656 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
349 | 2025.03.07 23:25:56.074083 [ 264 ] {0d4a2310-c4e0-459e-bebf-3661fdbb23b4} <Debug> executeQuery: (from [::1]:60653) 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) | ||
350 | 2025.03.07 23:25:56.074246 [ 264 ] {0d4a2310-c4e0-459e-bebf-3661fdbb23b4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
351 | 2025.03.07 23:25:56.075825 [ 264 ] {0d4a2310-c4e0-459e-bebf-3661fdbb23b4} <Debug> oximeter.measurements_i32 (b75eb8c8-416f-4b46-8a46-3beef09ba40d): Loading data parts | ||
352 | 2025.03.07 23:25:56.076205 [ 264 ] {0d4a2310-c4e0-459e-bebf-3661fdbb23b4} <Debug> oximeter.measurements_i32 (b75eb8c8-416f-4b46-8a46-3beef09ba40d): There are no data parts | ||
353 | 2025.03.07 23:25:56.076890 [ 264 ] {0d4a2310-c4e0-459e-bebf-3661fdbb23b4} <Debug> TCPHandler: Processed in 0.003432524 sec. | ||
354 | 2025.03.07 23:25:56.080659 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
355 | 2025.03.07 23:25:56.080983 [ 264 ] {a147eb81-c2b2-49a6-8951-fbbc193e1710} <Debug> executeQuery: (from [::1]:60653) 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) | ||
356 | 2025.03.07 23:25:56.081070 [ 264 ] {a147eb81-c2b2-49a6-8951-fbbc193e1710} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
357 | 2025.03.07 23:25:56.082530 [ 264 ] {a147eb81-c2b2-49a6-8951-fbbc193e1710} <Debug> oximeter.measurements_u32 (15f18de1-c810-45b6-8519-8cc5e4ea2974): Loading data parts | ||
358 | 2025.03.07 23:25:56.082840 [ 264 ] {a147eb81-c2b2-49a6-8951-fbbc193e1710} <Debug> oximeter.measurements_u32 (15f18de1-c810-45b6-8519-8cc5e4ea2974): There are no data parts | ||
359 | 2025.03.07 23:25:56.083442 [ 264 ] {a147eb81-c2b2-49a6-8951-fbbc193e1710} <Debug> TCPHandler: Processed in 0.002949438 sec. | ||
360 | 2025.03.07 23:25:56.084070 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
361 | 2025.03.07 23:25:56.084352 [ 264 ] {047581cb-0eb7-4f8e-9700-ada1f98948c9} <Debug> executeQuery: (from [::1]:60653) 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) | ||
362 | 2025.03.07 23:25:56.084473 [ 264 ] {047581cb-0eb7-4f8e-9700-ada1f98948c9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
363 | 2025.03.07 23:25:56.085741 [ 264 ] {047581cb-0eb7-4f8e-9700-ada1f98948c9} <Debug> oximeter.measurements_i64 (899e9dc9-def7-4bfe-b84c-eeeba6e551d0): Loading data parts | ||
364 | 2025.03.07 23:25:56.086035 [ 264 ] {047581cb-0eb7-4f8e-9700-ada1f98948c9} <Debug> oximeter.measurements_i64 (899e9dc9-def7-4bfe-b84c-eeeba6e551d0): There are no data parts | ||
365 | 2025.03.07 23:25:56.086627 [ 264 ] {047581cb-0eb7-4f8e-9700-ada1f98948c9} <Debug> TCPHandler: Processed in 0.0026333 sec. | ||
366 | 2025.03.07 23:25:56.094664 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
367 | 2025.03.07 23:25:56.095067 [ 264 ] {718f87f9-2145-433b-b0bc-dcfbdf47a805} <Debug> executeQuery: (from [::1]:60653) 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) | ||
368 | 2025.03.07 23:25:56.095166 [ 264 ] {718f87f9-2145-433b-b0bc-dcfbdf47a805} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
369 | 2025.03.07 23:25:56.097190 [ 264 ] {718f87f9-2145-433b-b0bc-dcfbdf47a805} <Debug> oximeter.measurements_u64 (7eda65b7-5146-4c14-b979-1a7b637aee86): Loading data parts | ||
370 | 2025.03.07 23:25:56.097533 [ 264 ] {718f87f9-2145-433b-b0bc-dcfbdf47a805} <Debug> oximeter.measurements_u64 (7eda65b7-5146-4c14-b979-1a7b637aee86): There are no data parts | ||
371 | 2025.03.07 23:25:56.098145 [ 264 ] {718f87f9-2145-433b-b0bc-dcfbdf47a805} <Debug> TCPHandler: Processed in 0.004115666 sec. | ||
372 | 2025.03.07 23:25:56.101262 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
373 | 2025.03.07 23:25:56.101557 [ 264 ] {00f173c2-d926-4774-9212-4432c3bd0c71} <Debug> executeQuery: (from [::1]:60653) 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) | ||
374 | 2025.03.07 23:25:56.101640 [ 264 ] {00f173c2-d926-4774-9212-4432c3bd0c71} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
375 | 2025.03.07 23:25:56.102969 [ 264 ] {00f173c2-d926-4774-9212-4432c3bd0c71} <Debug> oximeter.measurements_f32 (43439aac-f9b1-4fc0-ab12-eec006b0997d): Loading data parts | ||
376 | 2025.03.07 23:25:56.103433 [ 264 ] {00f173c2-d926-4774-9212-4432c3bd0c71} <Debug> oximeter.measurements_f32 (43439aac-f9b1-4fc0-ab12-eec006b0997d): There are no data parts | ||
377 | 2025.03.07 23:25:56.103931 [ 264 ] {00f173c2-d926-4774-9212-4432c3bd0c71} <Debug> TCPHandler: Processed in 0.002798426 sec. | ||
378 | 2025.03.07 23:25:56.108011 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
379 | 2025.03.07 23:25:56.108497 [ 264 ] {548dd945-1ac1-46bd-acbc-75fb58e17c44} <Debug> executeQuery: (from [::1]:60653) 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) | ||
380 | 2025.03.07 23:25:56.108597 [ 264 ] {548dd945-1ac1-46bd-acbc-75fb58e17c44} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
381 | 2025.03.07 23:25:56.110018 [ 264 ] {548dd945-1ac1-46bd-acbc-75fb58e17c44} <Debug> oximeter.measurements_f64 (dad568fa-f462-4d60-91be-b08c6cb89259): Loading data parts | ||
382 | 2025.03.07 23:25:56.110385 [ 264 ] {548dd945-1ac1-46bd-acbc-75fb58e17c44} <Debug> oximeter.measurements_f64 (dad568fa-f462-4d60-91be-b08c6cb89259): There are no data parts | ||
383 | 2025.03.07 23:25:56.110979 [ 264 ] {548dd945-1ac1-46bd-acbc-75fb58e17c44} <Debug> TCPHandler: Processed in 0.003823754 sec. | ||
384 | 2025.03.07 23:25:56.119324 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
385 | 2025.03.07 23:25:56.119804 [ 264 ] {255f2dcc-f567-4a90-a7e0-ea587fda637c} <Debug> executeQuery: (from [::1]:60653) 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) | ||
386 | 2025.03.07 23:25:56.119922 [ 264 ] {255f2dcc-f567-4a90-a7e0-ea587fda637c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
387 | 2025.03.07 23:25:56.121696 [ 264 ] {255f2dcc-f567-4a90-a7e0-ea587fda637c} <Debug> oximeter.measurements_string (b16bf060-3a20-4704-94ae-6342b5fd1a60): Loading data parts | ||
388 | 2025.03.07 23:25:56.122093 [ 264 ] {255f2dcc-f567-4a90-a7e0-ea587fda637c} <Debug> oximeter.measurements_string (b16bf060-3a20-4704-94ae-6342b5fd1a60): There are no data parts | ||
389 | 2025.03.07 23:25:56.122697 [ 264 ] {255f2dcc-f567-4a90-a7e0-ea587fda637c} <Debug> TCPHandler: Processed in 0.003573394 sec. | ||
390 | 2025.03.07 23:25:56.123115 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
391 | 2025.03.07 23:25:56.123426 [ 264 ] {7a7d5311-f516-4b71-a2f0-bab2ba3aab46} <Debug> executeQuery: (from [::1]:60653) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
392 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
393 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
394 | * a string isn't palatable for a few reasons. | ||
395 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
396 | * details. | ||
397 | */ | ||
398 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
399 | 2025.03.07 23:25:56.123511 [ 264 ] {7a7d5311-f516-4b71-a2f0-bab2ba3aab46} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
400 | 2025.03.07 23:25:56.124864 [ 264 ] {7a7d5311-f516-4b71-a2f0-bab2ba3aab46} <Debug> oximeter.measurements_bytes (28d268c0-efb9-4d06-90db-fe8348f2b58e): Loading data parts | ||
401 | 2025.03.07 23:25:56.125170 [ 264 ] {7a7d5311-f516-4b71-a2f0-bab2ba3aab46} <Debug> oximeter.measurements_bytes (28d268c0-efb9-4d06-90db-fe8348f2b58e): There are no data parts | ||
402 | 2025.03.07 23:25:56.125774 [ 264 ] {7a7d5311-f516-4b71-a2f0-bab2ba3aab46} <Debug> TCPHandler: Processed in 0.002756105 sec. | ||
403 | 2025.03.07 23:25:56.127179 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
404 | 2025.03.07 23:25:56.127547 [ 264 ] {db7238e3-7f06-4b29-88ec-289133e73da8} <Debug> executeQuery: (from [::1]:60653) 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) | ||
405 | 2025.03.07 23:25:56.127636 [ 264 ] {db7238e3-7f06-4b29-88ec-289133e73da8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
406 | 2025.03.07 23:25:56.129198 [ 264 ] {db7238e3-7f06-4b29-88ec-289133e73da8} <Debug> oximeter.measurements_cumulativei64 (01d9eeb3-bbf4-4b78-8e39-c1309b5b89da): Loading data parts | ||
407 | 2025.03.07 23:25:56.129520 [ 264 ] {db7238e3-7f06-4b29-88ec-289133e73da8} <Debug> oximeter.measurements_cumulativei64 (01d9eeb3-bbf4-4b78-8e39-c1309b5b89da): There are no data parts | ||
408 | 2025.03.07 23:25:56.130535 [ 264 ] {db7238e3-7f06-4b29-88ec-289133e73da8} <Debug> TCPHandler: Processed in 0.003531202 sec. | ||
409 | 2025.03.07 23:25:56.134562 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
410 | 2025.03.07 23:25:56.134931 [ 264 ] {1a173efb-ab3b-444e-92bb-2b7dd0e9e140} <Debug> executeQuery: (from [::1]:60653) 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) | ||
411 | 2025.03.07 23:25:56.135036 [ 264 ] {1a173efb-ab3b-444e-92bb-2b7dd0e9e140} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
412 | 2025.03.07 23:25:56.136597 [ 264 ] {1a173efb-ab3b-444e-92bb-2b7dd0e9e140} <Debug> oximeter.measurements_cumulativeu64 (165c8892-d6e4-4462-b512-580c8ce98e37): Loading data parts | ||
413 | 2025.03.07 23:25:56.136887 [ 264 ] {1a173efb-ab3b-444e-92bb-2b7dd0e9e140} <Debug> oximeter.measurements_cumulativeu64 (165c8892-d6e4-4462-b512-580c8ce98e37): There are no data parts | ||
414 | 2025.03.07 23:25:56.137465 [ 264 ] {1a173efb-ab3b-444e-92bb-2b7dd0e9e140} <Debug> TCPHandler: Processed in 0.00306235 sec. | ||
415 | 2025.03.07 23:25:56.139141 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
416 | 2025.03.07 23:25:56.139462 [ 264 ] {3ec5df7c-80e8-4b4f-af04-cd7d7d1e16b4} <Debug> executeQuery: (from [::1]:60653) 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) | ||
417 | 2025.03.07 23:25:56.139551 [ 264 ] {3ec5df7c-80e8-4b4f-af04-cd7d7d1e16b4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
418 | 2025.03.07 23:25:56.140998 [ 264 ] {3ec5df7c-80e8-4b4f-af04-cd7d7d1e16b4} <Debug> oximeter.measurements_cumulativef32 (39fb8c1f-5157-4222-a78d-50d77a89d052): Loading data parts | ||
419 | 2025.03.07 23:25:56.141860 [ 264 ] {3ec5df7c-80e8-4b4f-af04-cd7d7d1e16b4} <Debug> oximeter.measurements_cumulativef32 (39fb8c1f-5157-4222-a78d-50d77a89d052): There are no data parts | ||
420 | 2025.03.07 23:25:56.142633 [ 264 ] {3ec5df7c-80e8-4b4f-af04-cd7d7d1e16b4} <Debug> TCPHandler: Processed in 0.003601162 sec. | ||
421 | 2025.03.07 23:25:56.152449 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
422 | 2025.03.07 23:25:56.153336 [ 264 ] {c76e3421-3959-4095-9054-b502a1ca7a23} <Debug> executeQuery: (from [::1]:60653) 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) | ||
423 | 2025.03.07 23:25:56.153456 [ 264 ] {c76e3421-3959-4095-9054-b502a1ca7a23} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
424 | 2025.03.07 23:25:56.155469 [ 264 ] {c76e3421-3959-4095-9054-b502a1ca7a23} <Debug> oximeter.measurements_cumulativef64 (7f253594-c098-4790-b565-b240297b5293): Loading data parts | ||
425 | 2025.03.07 23:25:56.155868 [ 264 ] {c76e3421-3959-4095-9054-b502a1ca7a23} <Debug> oximeter.measurements_cumulativef64 (7f253594-c098-4790-b565-b240297b5293): There are no data parts | ||
426 | 2025.03.07 23:25:56.156569 [ 264 ] {c76e3421-3959-4095-9054-b502a1ca7a23} <Debug> TCPHandler: Processed in 0.004463925 sec. | ||
427 | 2025.03.07 23:25:56.161657 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
428 | 2025.03.07 23:25:56.162146 [ 264 ] {9c5c2024-8658-4226-b535-d6422c443f15} <Debug> executeQuery: (from [::1]:60653) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
429 | * NOTE: Array types cannot be Nullable, see | ||
430 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
431 | * for more details. | ||
432 | * | ||
433 | * This means we need to use empty arrays to indicate a missing value. This | ||
434 | * is unfortunate, and at this point relies on the fact that an | ||
435 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
436 | * to figure out another way to represent missing samples here. | ||
437 | */ | ||
438 | 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) | ||
439 | 2025.03.07 23:25:56.162265 [ 264 ] {9c5c2024-8658-4226-b535-d6422c443f15} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
440 | 2025.03.07 23:25:56.164786 [ 264 ] {9c5c2024-8658-4226-b535-d6422c443f15} <Debug> oximeter.measurements_histogrami8 (f3b31951-45fd-4b48-bdbe-0515a9bd65d8): Loading data parts | ||
441 | 2025.03.07 23:25:56.165195 [ 264 ] {9c5c2024-8658-4226-b535-d6422c443f15} <Debug> oximeter.measurements_histogrami8 (f3b31951-45fd-4b48-bdbe-0515a9bd65d8): There are no data parts | ||
442 | 2025.03.07 23:25:56.165952 [ 264 ] {9c5c2024-8658-4226-b535-d6422c443f15} <Debug> TCPHandler: Processed in 0.004471676 sec. | ||
443 | 2025.03.07 23:25:56.166939 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
444 | 2025.03.07 23:25:56.167692 [ 264 ] {16b902cf-1eca-4b29-89fd-70d066ec974b} <Debug> executeQuery: (from [::1]:60653) 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) | ||
445 | 2025.03.07 23:25:56.167823 [ 264 ] {16b902cf-1eca-4b29-89fd-70d066ec974b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
446 | 2025.03.07 23:25:56.170962 [ 264 ] {16b902cf-1eca-4b29-89fd-70d066ec974b} <Debug> oximeter.measurements_histogramu8 (a45807a1-115c-4201-9e55-56df13662938): Loading data parts | ||
447 | 2025.03.07 23:25:56.171329 [ 264 ] {16b902cf-1eca-4b29-89fd-70d066ec974b} <Debug> oximeter.measurements_histogramu8 (a45807a1-115c-4201-9e55-56df13662938): There are no data parts | ||
448 | 2025.03.07 23:25:56.172051 [ 264 ] {16b902cf-1eca-4b29-89fd-70d066ec974b} <Debug> TCPHandler: Processed in 0.005226569 sec. | ||
449 | 2025.03.07 23:25:56.180712 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
450 | 2025.03.07 23:25:56.181352 [ 264 ] {ddd9590c-61f8-4633-8ccc-baac9bfb559f} <Debug> executeQuery: (from [::1]:60653) 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) | ||
451 | 2025.03.07 23:25:56.181610 [ 264 ] {ddd9590c-61f8-4633-8ccc-baac9bfb559f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
452 | 2025.03.07 23:25:56.184347 [ 264 ] {ddd9590c-61f8-4633-8ccc-baac9bfb559f} <Debug> oximeter.measurements_histogrami16 (5f4cfece-8f1d-4408-a98d-31803aa94141): Loading data parts | ||
453 | 2025.03.07 23:25:56.184997 [ 264 ] {ddd9590c-61f8-4633-8ccc-baac9bfb559f} <Debug> oximeter.measurements_histogrami16 (5f4cfece-8f1d-4408-a98d-31803aa94141): There are no data parts | ||
454 | 2025.03.07 23:25:56.185919 [ 264 ] {ddd9590c-61f8-4633-8ccc-baac9bfb559f} <Debug> TCPHandler: Processed in 0.005457803 sec. | ||
455 | 2025.03.07 23:25:56.189751 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
456 | 2025.03.07 23:25:56.190601 [ 264 ] {cb62f8c0-a6ae-4a46-b54f-23d53a8f847a} <Debug> executeQuery: (from [::1]:60653) 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) | ||
457 | 2025.03.07 23:25:56.190728 [ 264 ] {cb62f8c0-a6ae-4a46-b54f-23d53a8f847a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
458 | 2025.03.07 23:25:56.193568 [ 264 ] {cb62f8c0-a6ae-4a46-b54f-23d53a8f847a} <Debug> oximeter.measurements_histogramu16 (97a28031-b55f-4f7f-aad9-fea8887b5c0a): Loading data parts | ||
459 | 2025.03.07 23:25:56.193943 [ 264 ] {cb62f8c0-a6ae-4a46-b54f-23d53a8f847a} <Debug> oximeter.measurements_histogramu16 (97a28031-b55f-4f7f-aad9-fea8887b5c0a): There are no data parts | ||
460 | 2025.03.07 23:25:56.194956 [ 264 ] {cb62f8c0-a6ae-4a46-b54f-23d53a8f847a} <Debug> TCPHandler: Processed in 0.008510211 sec. | ||
461 | 2025.03.07 23:25:56.195645 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
462 | 2025.03.07 23:25:56.196130 [ 264 ] {e80640c8-ffdf-4cc0-9fb8-d292d53ce040} <Debug> executeQuery: (from [::1]:60653) 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) | ||
463 | 2025.03.07 23:25:56.196248 [ 264 ] {e80640c8-ffdf-4cc0-9fb8-d292d53ce040} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
464 | 2025.03.07 23:25:56.198752 [ 264 ] {e80640c8-ffdf-4cc0-9fb8-d292d53ce040} <Debug> oximeter.measurements_histogrami32 (f3268d88-22a5-4d93-8bc5-4d87e943847d): Loading data parts | ||
465 | 2025.03.07 23:25:56.199024 [ 264 ] {e80640c8-ffdf-4cc0-9fb8-d292d53ce040} <Debug> oximeter.measurements_histogrami32 (f3268d88-22a5-4d93-8bc5-4d87e943847d): There are no data parts | ||
466 | 2025.03.07 23:25:56.199778 [ 264 ] {e80640c8-ffdf-4cc0-9fb8-d292d53ce040} <Debug> TCPHandler: Processed in 0.004230188 sec. | ||
467 | 2025.03.07 23:25:56.203522 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
468 | 2025.03.07 23:25:56.204027 [ 264 ] {b7ae73db-d91d-47e3-9cc6-cde0c03d41bb} <Debug> executeQuery: (from [::1]:60653) 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) | ||
469 | 2025.03.07 23:25:56.204287 [ 264 ] {b7ae73db-d91d-47e3-9cc6-cde0c03d41bb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
470 | 2025.03.07 23:25:56.206646 [ 264 ] {b7ae73db-d91d-47e3-9cc6-cde0c03d41bb} <Debug> oximeter.measurements_histogramu32 (ea25a802-785d-42de-902b-9a3ff4fbff24): Loading data parts | ||
471 | 2025.03.07 23:25:56.207061 [ 264 ] {b7ae73db-d91d-47e3-9cc6-cde0c03d41bb} <Debug> oximeter.measurements_histogramu32 (ea25a802-785d-42de-902b-9a3ff4fbff24): There are no data parts | ||
472 | 2025.03.07 23:25:56.208036 [ 264 ] {b7ae73db-d91d-47e3-9cc6-cde0c03d41bb} <Debug> TCPHandler: Processed in 0.0048744 sec. | ||
473 | 2025.03.07 23:25:56.208810 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
474 | 2025.03.07 23:25:56.209407 [ 264 ] {62ad387e-1512-4592-bdf9-a1c7a18789ea} <Debug> executeQuery: (from [::1]:60653) 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) | ||
475 | 2025.03.07 23:25:56.209516 [ 264 ] {62ad387e-1512-4592-bdf9-a1c7a18789ea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
476 | 2025.03.07 23:25:56.212176 [ 264 ] {62ad387e-1512-4592-bdf9-a1c7a18789ea} <Debug> oximeter.measurements_histogrami64 (b808d7e5-d0c9-4468-ac87-03bbf51a468f): Loading data parts | ||
477 | 2025.03.07 23:25:56.212497 [ 264 ] {62ad387e-1512-4592-bdf9-a1c7a18789ea} <Debug> oximeter.measurements_histogrami64 (b808d7e5-d0c9-4468-ac87-03bbf51a468f): There are no data parts | ||
478 | 2025.03.07 23:25:56.214121 [ 264 ] {62ad387e-1512-4592-bdf9-a1c7a18789ea} <Debug> TCPHandler: Processed in 0.005429705 sec. | ||
479 | 2025.03.07 23:25:56.215584 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
480 | 2025.03.07 23:25:56.216117 [ 264 ] {051d1244-86d4-475a-8b28-3e0eab353e01} <Debug> executeQuery: (from [::1]:60653) 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) | ||
481 | 2025.03.07 23:25:56.216234 [ 264 ] {051d1244-86d4-475a-8b28-3e0eab353e01} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
482 | 2025.03.07 23:25:56.218391 [ 264 ] {051d1244-86d4-475a-8b28-3e0eab353e01} <Debug> oximeter.measurements_histogramu64 (09709fd5-0592-4117-9ab3-25266ca7686e): Loading data parts | ||
483 | 2025.03.07 23:25:56.218689 [ 264 ] {051d1244-86d4-475a-8b28-3e0eab353e01} <Debug> oximeter.measurements_histogramu64 (09709fd5-0592-4117-9ab3-25266ca7686e): There are no data parts | ||
484 | 2025.03.07 23:25:56.219409 [ 264 ] {051d1244-86d4-475a-8b28-3e0eab353e01} <Debug> TCPHandler: Processed in 0.003971476 sec. | ||
485 | 2025.03.07 23:25:56.219785 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
486 | 2025.03.07 23:25:56.220246 [ 264 ] {453466c4-14e1-47b8-b273-40da7631b59c} <Debug> executeQuery: (from [::1]:60653) 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) | ||
487 | 2025.03.07 23:25:56.220348 [ 264 ] {453466c4-14e1-47b8-b273-40da7631b59c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
488 | 2025.03.07 23:25:56.222325 [ 264 ] {453466c4-14e1-47b8-b273-40da7631b59c} <Debug> oximeter.measurements_histogramf32 (248436b8-362f-45c0-80d2-41a9d93d530e): Loading data parts | ||
489 | 2025.03.07 23:25:56.222904 [ 264 ] {453466c4-14e1-47b8-b273-40da7631b59c} <Debug> oximeter.measurements_histogramf32 (248436b8-362f-45c0-80d2-41a9d93d530e): There are no data parts | ||
490 | 2025.03.07 23:25:56.223643 [ 264 ] {453466c4-14e1-47b8-b273-40da7631b59c} <Debug> TCPHandler: Processed in 0.003957421 sec. | ||
491 | 2025.03.07 23:25:56.224597 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
492 | 2025.03.07 23:25:56.225128 [ 264 ] {4d4a3727-be0d-4366-8b74-3d2726ec0a62} <Debug> executeQuery: (from [::1]:60653) 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) | ||
493 | 2025.03.07 23:25:56.225243 [ 264 ] {4d4a3727-be0d-4366-8b74-3d2726ec0a62} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
494 | 2025.03.07 23:25:56.227895 [ 264 ] {4d4a3727-be0d-4366-8b74-3d2726ec0a62} <Debug> oximeter.measurements_histogramf64 (c36fd138-349b-488f-8932-f94b2784c31b): Loading data parts | ||
495 | 2025.03.07 23:25:56.228634 [ 264 ] {4d4a3727-be0d-4366-8b74-3d2726ec0a62} <Debug> oximeter.measurements_histogramf64 (c36fd138-349b-488f-8932-f94b2784c31b): There are no data parts | ||
496 | 2025.03.07 23:25:56.229378 [ 264 ] {4d4a3727-be0d-4366-8b74-3d2726ec0a62} <Debug> TCPHandler: Processed in 0.004926274 sec. | ||
497 | 2025.03.07 23:25:56.230348 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
498 | 2025.03.07 23:25:56.230719 [ 264 ] {cbe0def4-e8f8-467a-97cb-fffb0c5879af} <Debug> executeQuery: (from [::1]:60653) /* The field tables store named dimensions of each timeseries. | ||
499 | * | ||
500 | * As with the measurement tables, there is one field table for each field data | ||
501 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
502 | * this behavior **must not** be relied upon for query correctness. | ||
503 | * | ||
504 | * The index for the fields differs from the measurements, however. Rows are | ||
505 | * sorted by timeseries name, then field name, field value, and finally | ||
506 | * timeseries key. This reflects the most common pattern for looking them up: | ||
507 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
508 | * usually then used to look up measurements. | ||
509 | * | ||
510 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
511 | * timeseries name and then key, since it would improve lookups where one | ||
512 | * already has the key. Realistically though, these tables are quite small and | ||
513 | * so performance benefits will be low in absolute terms. | ||
514 | * | ||
515 | * TTL: We use a materialized column to expire old field table records. This | ||
516 | * column is generated automatically by the database whenever a new row is | ||
517 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
518 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
519 | * record will remain during a deduplication, which will have the last | ||
520 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
521 | * measurement tables. | ||
522 | */ | ||
523 | 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) | ||
524 | 2025.03.07 23:25:56.230888 [ 264 ] {cbe0def4-e8f8-467a-97cb-fffb0c5879af} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
525 | 2025.03.07 23:25:56.232787 [ 264 ] {cbe0def4-e8f8-467a-97cb-fffb0c5879af} <Debug> oximeter.fields_bool (280d3b79-6c4d-4159-90cf-0d7a23406a9c): Loading data parts | ||
526 | 2025.03.07 23:25:56.233103 [ 264 ] {cbe0def4-e8f8-467a-97cb-fffb0c5879af} <Debug> oximeter.fields_bool (280d3b79-6c4d-4159-90cf-0d7a23406a9c): There are no data parts | ||
527 | 2025.03.07 23:25:56.234161 [ 264 ] {cbe0def4-e8f8-467a-97cb-fffb0c5879af} <Debug> TCPHandler: Processed in 0.003956722 sec. | ||
528 | 2025.03.07 23:25:56.235050 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
529 | 2025.03.07 23:25:56.235404 [ 264 ] {27ea4a85-21ab-4eb6-aba7-651b2448a839} <Debug> executeQuery: (from [::1]:60653) 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) | ||
530 | 2025.03.07 23:25:56.235496 [ 264 ] {27ea4a85-21ab-4eb6-aba7-651b2448a839} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
531 | 2025.03.07 23:25:56.237208 [ 264 ] {27ea4a85-21ab-4eb6-aba7-651b2448a839} <Debug> oximeter.fields_i8 (24dde33b-c4c1-4fa5-a490-27749f932598): Loading data parts | ||
532 | 2025.03.07 23:25:56.237659 [ 264 ] {27ea4a85-21ab-4eb6-aba7-651b2448a839} <Debug> oximeter.fields_i8 (24dde33b-c4c1-4fa5-a490-27749f932598): There are no data parts | ||
533 | 2025.03.07 23:25:56.238601 [ 264 ] {27ea4a85-21ab-4eb6-aba7-651b2448a839} <Debug> TCPHandler: Processed in 0.003677073 sec. | ||
534 | 2025.03.07 23:25:56.239349 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
535 | 2025.03.07 23:25:56.239847 [ 264 ] {6473a88c-d09a-4bf9-b0bb-bf4dd5ad8c3b} <Debug> executeQuery: (from [::1]:60653) 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) | ||
536 | 2025.03.07 23:25:56.239918 [ 264 ] {6473a88c-d09a-4bf9-b0bb-bf4dd5ad8c3b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
537 | 2025.03.07 23:25:56.242131 [ 264 ] {6473a88c-d09a-4bf9-b0bb-bf4dd5ad8c3b} <Debug> oximeter.fields_u8 (b93d0312-98eb-4def-9e68-1e3f5e67f87b): Loading data parts | ||
538 | 2025.03.07 23:25:56.242444 [ 264 ] {6473a88c-d09a-4bf9-b0bb-bf4dd5ad8c3b} <Debug> oximeter.fields_u8 (b93d0312-98eb-4def-9e68-1e3f5e67f87b): There are no data parts | ||
539 | 2025.03.07 23:25:56.244102 [ 264 ] {6473a88c-d09a-4bf9-b0bb-bf4dd5ad8c3b} <Debug> TCPHandler: Processed in 0.004985461 sec. | ||
540 | 2025.03.07 23:25:56.246158 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
541 | 2025.03.07 23:25:56.246642 [ 264 ] {b181146e-274c-416b-bb53-7c7d6cd7c4e6} <Debug> executeQuery: (from [::1]:60653) 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) | ||
542 | 2025.03.07 23:25:56.246807 [ 264 ] {b181146e-274c-416b-bb53-7c7d6cd7c4e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
543 | 2025.03.07 23:25:56.248647 [ 264 ] {b181146e-274c-416b-bb53-7c7d6cd7c4e6} <Debug> oximeter.fields_i16 (637a48fc-6546-44b8-9fe3-6f7ec83e516d): Loading data parts | ||
544 | 2025.03.07 23:25:56.249242 [ 264 ] {b181146e-274c-416b-bb53-7c7d6cd7c4e6} <Debug> oximeter.fields_i16 (637a48fc-6546-44b8-9fe3-6f7ec83e516d): There are no data parts | ||
545 | 2025.03.07 23:25:56.249980 [ 264 ] {b181146e-274c-416b-bb53-7c7d6cd7c4e6} <Debug> TCPHandler: Processed in 0.003964433 sec. | ||
546 | 2025.03.07 23:25:56.250501 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
547 | 2025.03.07 23:25:56.250923 [ 264 ] {68a381ab-37cb-46d0-adc0-e4496ae34de9} <Debug> executeQuery: (from [::1]:60653) 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) | ||
548 | 2025.03.07 23:25:56.251001 [ 264 ] {68a381ab-37cb-46d0-adc0-e4496ae34de9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
549 | 2025.03.07 23:25:56.252708 [ 264 ] {68a381ab-37cb-46d0-adc0-e4496ae34de9} <Debug> oximeter.fields_u16 (09c852c3-5536-4e37-bf36-1e065dd68a99): Loading data parts | ||
550 | 2025.03.07 23:25:56.253136 [ 264 ] {68a381ab-37cb-46d0-adc0-e4496ae34de9} <Debug> oximeter.fields_u16 (09c852c3-5536-4e37-bf36-1e065dd68a99): There are no data parts | ||
551 | 2025.03.07 23:25:56.253813 [ 264 ] {68a381ab-37cb-46d0-adc0-e4496ae34de9} <Debug> TCPHandler: Processed in 0.003414149 sec. | ||
552 | 2025.03.07 23:25:56.254155 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
553 | 2025.03.07 23:25:56.254457 [ 264 ] {358d21ad-2695-4441-8d9a-d6f1c079db7b} <Debug> executeQuery: (from [::1]:60653) 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) | ||
554 | 2025.03.07 23:25:56.254571 [ 264 ] {358d21ad-2695-4441-8d9a-d6f1c079db7b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
555 | 2025.03.07 23:25:56.256432 [ 264 ] {358d21ad-2695-4441-8d9a-d6f1c079db7b} <Debug> oximeter.fields_i32 (ae31a6fc-d851-4901-96b2-b4422de5373b): Loading data parts | ||
556 | 2025.03.07 23:25:56.256875 [ 264 ] {358d21ad-2695-4441-8d9a-d6f1c079db7b} <Debug> oximeter.fields_i32 (ae31a6fc-d851-4901-96b2-b4422de5373b): There are no data parts | ||
557 | 2025.03.07 23:25:56.257545 [ 264 ] {358d21ad-2695-4441-8d9a-d6f1c079db7b} <Debug> TCPHandler: Processed in 0.003448999 sec. | ||
558 | 2025.03.07 23:25:56.258341 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
559 | 2025.03.07 23:25:56.258782 [ 264 ] {3aaaec35-0cdf-4a60-a884-5e989a84d4ed} <Debug> executeQuery: (from [::1]:60653) 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) | ||
560 | 2025.03.07 23:25:56.258900 [ 264 ] {3aaaec35-0cdf-4a60-a884-5e989a84d4ed} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
561 | 2025.03.07 23:25:56.260618 [ 264 ] {3aaaec35-0cdf-4a60-a884-5e989a84d4ed} <Debug> oximeter.fields_u32 (2777c13a-d158-4e0e-90d0-db06562ca012): Loading data parts | ||
562 | 2025.03.07 23:25:56.261073 [ 264 ] {3aaaec35-0cdf-4a60-a884-5e989a84d4ed} <Debug> oximeter.fields_u32 (2777c13a-d158-4e0e-90d0-db06562ca012): There are no data parts | ||
563 | 2025.03.07 23:25:56.261637 [ 264 ] {3aaaec35-0cdf-4a60-a884-5e989a84d4ed} <Debug> TCPHandler: Processed in 0.003414799 sec. | ||
564 | 2025.03.07 23:25:56.262608 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
565 | 2025.03.07 23:25:56.263066 [ 264 ] {5400953f-4f34-408b-9438-081adbc8e37b} <Debug> executeQuery: (from [::1]:60653) 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) | ||
566 | 2025.03.07 23:25:56.263273 [ 264 ] {5400953f-4f34-408b-9438-081adbc8e37b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
567 | 2025.03.07 23:25:56.265857 [ 264 ] {5400953f-4f34-408b-9438-081adbc8e37b} <Debug> oximeter.fields_i64 (fb40b86b-c7ca-4543-a835-3e0ba3b320f5): Loading data parts | ||
568 | 2025.03.07 23:25:56.266444 [ 264 ] {5400953f-4f34-408b-9438-081adbc8e37b} <Debug> oximeter.fields_i64 (fb40b86b-c7ca-4543-a835-3e0ba3b320f5): There are no data parts | ||
569 | 2025.03.07 23:25:56.267024 [ 264 ] {5400953f-4f34-408b-9438-081adbc8e37b} <Debug> TCPHandler: Processed in 0.004538575 sec. | ||
570 | 2025.03.07 23:25:56.267583 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
571 | 2025.03.07 23:25:56.267946 [ 264 ] {179ee74c-335e-42c6-93f9-f54244f4b640} <Debug> executeQuery: (from [::1]:60653) 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) | ||
572 | 2025.03.07 23:25:56.268044 [ 264 ] {179ee74c-335e-42c6-93f9-f54244f4b640} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
573 | 2025.03.07 23:25:56.270107 [ 264 ] {179ee74c-335e-42c6-93f9-f54244f4b640} <Debug> oximeter.fields_u64 (e20af55c-b181-4e7f-a156-68da91198442): Loading data parts | ||
574 | 2025.03.07 23:25:56.270419 [ 264 ] {179ee74c-335e-42c6-93f9-f54244f4b640} <Debug> oximeter.fields_u64 (e20af55c-b181-4e7f-a156-68da91198442): There are no data parts | ||
575 | 2025.03.07 23:25:56.271061 [ 264 ] {179ee74c-335e-42c6-93f9-f54244f4b640} <Debug> TCPHandler: Processed in 0.003602752 sec. | ||
576 | 2025.03.07 23:25:56.271479 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
577 | 2025.03.07 23:25:56.271792 [ 264 ] {3f48e231-3ce5-4170-ad78-fa87c0b4cb44} <Debug> executeQuery: (from [::1]:60653) 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) | ||
578 | 2025.03.07 23:25:56.271878 [ 264 ] {3f48e231-3ce5-4170-ad78-fa87c0b4cb44} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
579 | 2025.03.07 23:25:56.273792 [ 264 ] {3f48e231-3ce5-4170-ad78-fa87c0b4cb44} <Debug> oximeter.fields_ipaddr (72e04991-d1f3-48bd-bb43-1601df463129): Loading data parts | ||
580 | 2025.03.07 23:25:56.274288 [ 264 ] {3f48e231-3ce5-4170-ad78-fa87c0b4cb44} <Debug> oximeter.fields_ipaddr (72e04991-d1f3-48bd-bb43-1601df463129): There are no data parts | ||
581 | 2025.03.07 23:25:56.275247 [ 264 ] {3f48e231-3ce5-4170-ad78-fa87c0b4cb44} <Debug> TCPHandler: Processed in 0.003885611 sec. | ||
582 | 2025.03.07 23:25:56.277019 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
583 | 2025.03.07 23:25:56.277401 [ 264 ] {d22dedb4-d97c-4b3b-8bf4-5636c2ca9bf0} <Debug> executeQuery: (from [::1]:60653) 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) | ||
584 | 2025.03.07 23:25:56.277485 [ 264 ] {d22dedb4-d97c-4b3b-8bf4-5636c2ca9bf0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
585 | 2025.03.07 23:25:56.279493 [ 264 ] {d22dedb4-d97c-4b3b-8bf4-5636c2ca9bf0} <Debug> oximeter.fields_string (473476c5-ffa5-4ab8-85ef-d7c09320ef84): Loading data parts | ||
586 | 2025.03.07 23:25:56.279783 [ 264 ] {d22dedb4-d97c-4b3b-8bf4-5636c2ca9bf0} <Debug> oximeter.fields_string (473476c5-ffa5-4ab8-85ef-d7c09320ef84): There are no data parts | ||
587 | 2025.03.07 23:25:56.280433 [ 264 ] {d22dedb4-d97c-4b3b-8bf4-5636c2ca9bf0} <Debug> TCPHandler: Processed in 0.003570923 sec. | ||
588 | 2025.03.07 23:25:56.281208 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
589 | 2025.03.07 23:25:56.281585 [ 264 ] {4964f169-f849-42f3-854d-a4beed02bd13} <Debug> executeQuery: (from [::1]:60653) 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) | ||
590 | 2025.03.07 23:25:56.281671 [ 264 ] {4964f169-f849-42f3-854d-a4beed02bd13} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
591 | 2025.03.07 23:25:56.283222 [ 264 ] {4964f169-f849-42f3-854d-a4beed02bd13} <Debug> oximeter.fields_uuid (dd8388d4-3241-4f68-9132-8588dab02b38): Loading data parts | ||
592 | 2025.03.07 23:25:56.283563 [ 264 ] {4964f169-f849-42f3-854d-a4beed02bd13} <Debug> oximeter.fields_uuid (dd8388d4-3241-4f68-9132-8588dab02b38): There are no data parts | ||
593 | 2025.03.07 23:25:56.284139 [ 264 ] {4964f169-f849-42f3-854d-a4beed02bd13} <Debug> TCPHandler: Processed in 0.0030262 sec. | ||
594 | 2025.03.07 23:25:56.285529 [ 264 ] {} <Trace> TCP-Session: 450dbf4e-fdfe-4087-8ee0-7a2c989faff8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
595 | 2025.03.07 23:25:56.285959 [ 264 ] {30399b47-0ba5-4286-aaf7-744f0fbf3dec} <Debug> executeQuery: (from [::1]:60653) /* The timeseries schema table stores the extracted schema for the samples | ||
596 | * oximeter collects. | ||
597 | */ | ||
598 | 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) | ||
599 | 2025.03.07 23:25:56.286063 [ 264 ] {30399b47-0ba5-4286-aaf7-744f0fbf3dec} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
600 | 2025.03.07 23:25:56.287731 [ 264 ] {30399b47-0ba5-4286-aaf7-744f0fbf3dec} <Debug> oximeter.timeseries_schema (811e95c3-5731-4abe-b892-9e5659045006): Loading data parts | ||
601 | 2025.03.07 23:25:56.287994 [ 264 ] {30399b47-0ba5-4286-aaf7-744f0fbf3dec} <Debug> oximeter.timeseries_schema (811e95c3-5731-4abe-b892-9e5659045006): There are no data parts | ||
602 | 2025.03.07 23:25:56.288975 [ 264 ] {30399b47-0ba5-4286-aaf7-744f0fbf3dec} <Debug> TCPHandler: Processed in 0.003530672 sec. | ||
603 | 2025.03.07 23:25:56.289515 [ 262 ] {} <Trace> TCP-Session: 75e8f273-b112-42f9-b439-4081104bdcc9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
604 | 2025.03.07 23:25:56.289753 [ 262 ] {839abb8f-ab99-479f-aab8-9876cd362ebd} <Debug> executeQuery: (from [::1]:63260) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
605 | 2025.03.07 23:25:56.289920 [ 262 ] {839abb8f-ab99-479f-aab8-9876cd362ebd} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
606 | 2025.03.07 23:25:56.291458 [ 260 ] {839abb8f-ab99-479f-aab8-9876cd362ebd} <Trace> oximeter.version (4cafda08-ace9-45ba-8eb9-d4371fa52489): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
607 | 2025.03.07 23:25:56.291506 [ 260 ] {839abb8f-ab99-479f-aab8-9876cd362ebd} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
608 | 2025.03.07 23:25:56.292130 [ 260 ] {839abb8f-ab99-479f-aab8-9876cd362ebd} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
609 | 2025.03.07 23:25:56.292517 [ 260 ] {839abb8f-ab99-479f-aab8-9876cd362ebd} <Trace> oximeter.version (4cafda08-ace9-45ba-8eb9-d4371fa52489): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
610 | 2025.03.07 23:25:56.292769 [ 262 ] {839abb8f-ab99-479f-aab8-9876cd362ebd} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003138 sec., 318.674314850223 rows/sec., 4.98 KiB/sec. | ||
611 | 2025.03.07 23:25:56.293089 [ 262 ] {839abb8f-ab99-479f-aab8-9876cd362ebd} <Debug> TCPHandler: Processed in 0.003663019 sec. | ||
612 | 2025.03.07 23:25:57.000470 [ 248 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 157.61 MiB, peak 157.61 MiB, free memory in arenas 0.00 B, will set to 155.95 MiB (RSS), difference: -1.66 MiB |