1 | 2025.04.30 06:49:55.681240 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 29192 | ||
2 | 2025.04.30 06:49:55.681446 [ 1 ] {} <Information> Application: starting up | ||
3 | 2025.04.30 06:49:55.681487 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2025.04.30 06:49:55.689491 [ 1 ] {} <Information> Application: Available RAM: 31.99 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2025.04.30 06:49:55.691506 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2025.04.30 06:49:55.691532 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2025.04.30 06:49:55.691542 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2025.04.30 06:49:55.691589 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/datastore/tmp/ to store temporary data in it | ||
9 | 2025.04.30 06:49:55.692048 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2025.04.30 06:49:55.693063 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/config.xml' | ||
11 | 2025.04.30 06:49:55.693812 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/config.xml', performing update on configuration | ||
12 | 2025.04.30 06:49:55.694178 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.79 GiB (31.99 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
13 | 2025.04.30 06:49:55.694198 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 16.00 GiB (31.99 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
14 | 2025.04.30 06:49:55.694207 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 16.00 GiB | ||
15 | 2025.04.30 06:49:55.694289 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2025.04.30 06:49:55.695664 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2025.04.30 06:49:55.706456 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2025.04.30 06:49:55.707334 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2025.04.30 06:49:55.708738 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
20 | 2025.04.30 06:49:55.708839 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/config.xml', performed update on configuration | ||
21 | 2025.04.30 06:49:55.710230 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/config.xml' | ||
22 | 2025.04.30 06:49:55.712601 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/config.xml', performing update on configuration | ||
23 | 2025.04.30 06:49:55.713965 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/config.xml', performed update on configuration | ||
24 | 2025.04.30 06:49:55.714876 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/config.xml | ||
25 | 2025.04.30 06:49:55.748439 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
26 | 2025.04.30 06:49:55.749979 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2025.04.30 06:49:55.751002 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2025.04.30 06:49:55.752463 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
29 | 2025.04.30 06:49:55.753835 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2025.04.30 06:49:55.753897 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/datastore/ | ||
31 | 2025.04.30 06:49:55.754036 [ 160 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2025.04.30 06:49:55.756346 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
33 | 2025.04.30 06:49:55.756375 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000144248 sec | ||
34 | 2025.04.30 06:49:55.756393 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
35 | 2025.04.30 06:49:55.756410 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
36 | 2025.04.30 06:49:55.756508 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
37 | 2025.04.30 06:49:55.756555 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
38 | 2025.04.30 06:49:55.758527 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
39 | 2025.04.30 06:49:55.758580 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
40 | 2025.04.30 06:49:55.758603 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
41 | 2025.04.30 06:49:55.758625 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
42 | 2025.04.30 06:49:55.758648 [ 160 ] {} <Debug> DNSResolver: Updated DNS cache | ||
43 | 2025.04.30 06:49:55.758659 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2025.04.30 06:49:55.758900 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
45 | 2025.04.30 06:49:55.761401 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2025.04.30 06:49:55.761458 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
47 | 2025.04.30 06:49:55.761482 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
48 | 2025.04.30 06:49:55.761694 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2025.04.30 06:49:55.761712 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2025.04.30 06:49:55.761744 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2025.04.30 06:49:55.761755 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2025.04.30 06:49:55.761784 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2025.04.30 06:49:55.761795 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2025.04.30 06:49:55.761808 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2025.04.30 06:49:55.788852 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2025.04.30 06:49:55.789580 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2025.04.30 06:49:55.789614 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.7394e-05 sec | ||
58 | 2025.04.30 06:49:55.789626 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2025.04.30 06:49:55.789634 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2025.04.30 06:49:55.789662 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2025.04.30 06:49:55.789830 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all_output-fa9e5ecadb3c2cc3-test_omdb_success_cases.29164.1-clickhouse-IXaT0J/datastore/user_defined/ | ||
62 | 2025.04.30 06:49:55.790140 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2025.04.30 06:49:55.790168 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2025.04.30 06:49:55.790177 [ 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.04.30 06:49:55.790191 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2025.04.30 06:49:55.790387 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 39811 | ||
67 | 2025.04.30 06:49:55.790525 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 35470 | ||
68 | 2025.04.30 06:49:55.791308 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 37095 | ||
69 | 2025.04.30 06:49:55.791385 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44873 | ||
70 | 2025.04.30 06:49:55.791418 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
71 | 2025.04.30 06:49:55.791642 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.79 MiB, peak 24.79 MiB, free memory in arenas 0.00 B, will set to 127.46 MiB (RSS), difference: 102.68 MiB | ||
72 | 2025.04.30 06:49:55.791952 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.5611e-05 sec. | ||
73 | 2025.04.30 06:49:55.792424 [ 1 ] {} <Information> Application: Listening for http://[::1]:39811 | ||
74 | 2025.04.30 06:49:55.792498 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:35470 | ||
75 | 2025.04.30 06:49:55.793790 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:37095 | ||
76 | 2025.04.30 06:49:55.793872 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:44873 | ||
77 | 2025.04.30 06:49:55.793885 [ 1 ] {} <Information> Application: Ready for connections. | ||
78 | 2025.04.30 06:49:56.000978 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 127.48 MiB, peak 127.48 MiB, free memory in arenas 0.00 B, will set to 128.78 MiB (RSS), difference: 1.30 MiB | ||
79 | 2025.04.30 06:49:56.864384 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35952 | ||
80 | 2025.04.30 06:49:56.868180 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
81 | 2025.04.30 06:49:56.868272 [ 3 ] {} <Debug> TCP-Session: 38559034-d1dc-4b0a-a615-78d5194e9865 Authenticating user 'default' from [::1]:35952 | ||
82 | 2025.04.30 06:49:56.868317 [ 3 ] {} <Debug> TCP-Session: 38559034-d1dc-4b0a-a615-78d5194e9865 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
83 | 2025.04.30 06:49:56.868331 [ 3 ] {} <Debug> TCP-Session: 38559034-d1dc-4b0a-a615-78d5194e9865 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2025.04.30 06:49:56.868436 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
85 | 2025.04.30 06:49:56.868469 [ 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.04.30 06:49:56.868491 [ 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.04.30 06:49:56.871683 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:62355 | ||
88 | 2025.04.30 06:49:56.872065 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:40072 | ||
89 | 2025.04.30 06:49:56.872281 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57669 | ||
90 | 2025.04.30 06:49:56.872597 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56694 | ||
91 | 2025.04.30 06:49:56.872629 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:52075 | ||
92 | 2025.04.30 06:49:56.872634 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
93 | 2025.04.30 06:49:56.872888 [ 4 ] {} <Debug> TCP-Session: c2154c53-4d0d-43e3-bbbc-ee4b8a9eff82 Authenticating user 'default' from [::1]:62355 | ||
94 | 2025.04.30 06:49:56.872930 [ 4 ] {} <Debug> TCP-Session: c2154c53-4d0d-43e3-bbbc-ee4b8a9eff82 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
95 | 2025.04.30 06:49:56.872943 [ 4 ] {} <Debug> TCP-Session: c2154c53-4d0d-43e3-bbbc-ee4b8a9eff82 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
96 | 2025.04.30 06:49:56.873085 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
97 | 2025.04.30 06:49:56.873087 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
98 | 2025.04.30 06:49:56.873181 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
99 | 2025.04.30 06:49:56.873219 [ 255 ] {} <Debug> TCP-Session: 89551798-6f05-4c6e-97f0-5a35a36e1381 Authenticating user 'default' from [::1]:40072 | ||
100 | 2025.04.30 06:49:56.873228 [ 256 ] {} <Debug> TCP-Session: d55b6af6-43ca-41a4-9679-6b2cc995f38f Authenticating user 'default' from [::1]:57669 | ||
101 | 2025.04.30 06:49:56.873278 [ 5 ] {} <Debug> TCP-Session: 7cb1635c-2d64-4467-8d24-cd944100b0d6 Authenticating user 'default' from [::1]:52075 | ||
102 | 2025.04.30 06:49:56.873293 [ 255 ] {} <Debug> TCP-Session: 89551798-6f05-4c6e-97f0-5a35a36e1381 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
103 | 2025.04.30 06:49:56.873328 [ 5 ] {} <Debug> TCP-Session: 7cb1635c-2d64-4467-8d24-cd944100b0d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
104 | 2025.04.30 06:49:56.873359 [ 255 ] {} <Debug> TCP-Session: 89551798-6f05-4c6e-97f0-5a35a36e1381 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
105 | 2025.04.30 06:49:56.873312 [ 256 ] {} <Debug> TCP-Session: d55b6af6-43ca-41a4-9679-6b2cc995f38f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
106 | 2025.04.30 06:49:56.873429 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:62375 | ||
107 | 2025.04.30 06:49:56.873485 [ 256 ] {} <Debug> TCP-Session: d55b6af6-43ca-41a4-9679-6b2cc995f38f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
108 | 2025.04.30 06:49:56.873498 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
109 | 2025.04.30 06:49:56.873411 [ 5 ] {} <Debug> TCP-Session: 7cb1635c-2d64-4467-8d24-cd944100b0d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
110 | 2025.04.30 06:49:56.873766 [ 257 ] {} <Debug> TCP-Session: 11ad88f5-3aba-4fe9-9eac-5061a2824882 Authenticating user 'default' from [::1]:56694 | ||
111 | 2025.04.30 06:49:56.873783 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
112 | 2025.04.30 06:49:56.873894 [ 259 ] {} <Debug> TCP-Session: 4fa73a7c-95f6-4016-8b88-9afa30cae6a5 Authenticating user 'default' from [::1]:62375 | ||
113 | 2025.04.30 06:49:56.873822 [ 257 ] {} <Debug> TCP-Session: 11ad88f5-3aba-4fe9-9eac-5061a2824882 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
114 | 2025.04.30 06:49:56.873933 [ 259 ] {} <Debug> TCP-Session: 4fa73a7c-95f6-4016-8b88-9afa30cae6a5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
115 | 2025.04.30 06:49:56.873943 [ 257 ] {} <Debug> TCP-Session: 11ad88f5-3aba-4fe9-9eac-5061a2824882 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
116 | 2025.04.30 06:49:56.873963 [ 259 ] {} <Debug> TCP-Session: 4fa73a7c-95f6-4016-8b88-9afa30cae6a5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
117 | 2025.04.30 06:49:56.874167 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:38276 | ||
118 | 2025.04.30 06:49:56.874293 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
119 | 2025.04.30 06:49:56.874336 [ 258 ] {} <Debug> TCP-Session: 5bbd2d7a-f4d9-4a18-9c14-c0354e880bba Authenticating user 'default' from [::1]:38276 | ||
120 | 2025.04.30 06:49:56.874352 [ 258 ] {} <Debug> TCP-Session: 5bbd2d7a-f4d9-4a18-9c14-c0354e880bba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
121 | 2025.04.30 06:49:56.874362 [ 258 ] {} <Debug> TCP-Session: 5bbd2d7a-f4d9-4a18-9c14-c0354e880bba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
122 | 2025.04.30 06:50:03.268092 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
123 | 2025.04.30 06:50:03.268259 [ 243 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
124 | 2025.04.30 06:50:03.268366 [ 237 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 549 entries to flush up to offset 549 | ||
125 | 2025.04.30 06:50:03.268570 [ 237 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
126 | 2025.04.30 06:50:03.278988 [ 237 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
127 | 2025.04.30 06:50:03.279815 [ 237 ] {} <Debug> system.asynchronous_metric_log (d99f813a-bd9a-43f8-9af6-a99f123f4e37): Loading data parts | ||
128 | 2025.04.30 06:50:03.281165 [ 237 ] {} <Debug> system.asynchronous_metric_log (d99f813a-bd9a-43f8-9af6-a99f123f4e37): There are no data parts | ||
129 | 2025.04.30 06:50:03.289326 [ 237 ] {} <Trace> system.asynchronous_metric_log (d99f813a-bd9a-43f8-9af6-a99f123f4e37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
130 | 2025.04.30 06:50:03.289532 [ 237 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
131 | 2025.04.30 06:50:03.292735 [ 237 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
132 | 2025.04.30 06:50:03.294081 [ 237 ] {} <Trace> system.asynchronous_metric_log (d99f813a-bd9a-43f8-9af6-a99f123f4e37): 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.04.30 06:50:03.295642 [ 237 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 549 | ||
134 | 2025.04.30 06:50:03.302837 [ 243 ] {} <Debug> system.metric_log (7aabd390-a2de-485c-9166-0f73b0a6808c): Loading data parts | ||
135 | 2025.04.30 06:50:03.303122 [ 243 ] {} <Debug> system.metric_log (7aabd390-a2de-485c-9166-0f73b0a6808c): There are no data parts | ||
136 | 2025.04.30 06:50:03.332213 [ 243 ] {} <Trace> system.metric_log (7aabd390-a2de-485c-9166-0f73b0a6808c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
137 | 2025.04.30 06:50:03.332326 [ 243 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
138 | 2025.04.30 06:50:03.342144 [ 243 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
139 | 2025.04.30 06:50:03.343220 [ 243 ] {} <Trace> system.metric_log (7aabd390-a2de-485c-9166-0f73b0a6808c): 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.04.30 06:50:03.346190 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
141 | 2025.04.30 06:50:04.000318 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 134.18 MiB, peak 138.18 MiB, free memory in arenas 0.00 B, will set to 141.02 MiB (RSS), difference: 6.84 MiB | ||
142 | 2025.04.30 06:50:04.804178 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:34437 | ||
143 | 2025.04.30 06:50:04.804519 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
144 | 2025.04.30 06:50:04.804563 [ 261 ] {} <Debug> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Authenticating user 'default' from [::1]:34437 | ||
145 | 2025.04.30 06:50:04.804589 [ 261 ] {} <Debug> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2025.04.30 06:50:04.804600 [ 261 ] {} <Debug> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
147 | 2025.04.30 06:50:04.813930 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:39333 | ||
148 | 2025.04.30 06:50:04.814168 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58863 | ||
149 | 2025.04.30 06:50:04.814606 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:36548 | ||
150 | 2025.04.30 06:50:04.814941 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:33120 | ||
151 | 2025.04.30 06:50:04.815290 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:38484 | ||
152 | 2025.04.30 06:50:04.815683 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:50893 | ||
153 | 2025.04.30 06:50:04.815703 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35942 | ||
154 | 2025.04.30 06:50:04.815707 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:44034 | ||
155 | 2025.04.30 06:50:04.817308 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
156 | 2025.04.30 06:50:04.817498 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
157 | 2025.04.30 06:50:04.817539 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
158 | 2025.04.30 06:50:04.817556 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
159 | 2025.04.30 06:50:04.817592 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
160 | 2025.04.30 06:50:04.817663 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
161 | 2025.04.30 06:50:04.817592 [ 262 ] {} <Debug> TCP-Session: 0b57aa5e-333e-4a2d-9fdc-cf016e1a8f87 Authenticating user 'default' from [::1]:39333 | ||
162 | 2025.04.30 06:50:04.817752 [ 266 ] {} <Debug> TCP-Session: ebb1d9b7-9804-4c1c-ae21-e2d792814e96 Authenticating user 'default' from [::1]:33120 | ||
163 | 2025.04.30 06:50:04.817717 [ 263 ] {} <Debug> TCP-Session: 716af162-4c09-426f-bd5a-efc679d15959 Authenticating user 'default' from [::1]:58863 | ||
164 | 2025.04.30 06:50:04.817783 [ 265 ] {} <Debug> TCP-Session: 7beb77d1-e052-4afc-adef-8bfb43392409 Authenticating user 'default' from [::1]:36548 | ||
165 | 2025.04.30 06:50:04.817874 [ 266 ] {} <Debug> TCP-Session: ebb1d9b7-9804-4c1c-ae21-e2d792814e96 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
166 | 2025.04.30 06:50:04.817931 [ 265 ] {} <Debug> TCP-Session: 7beb77d1-e052-4afc-adef-8bfb43392409 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
167 | 2025.04.30 06:50:04.818006 [ 265 ] {} <Debug> TCP-Session: 7beb77d1-e052-4afc-adef-8bfb43392409 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
168 | 2025.04.30 06:50:04.817999 [ 266 ] {} <Debug> TCP-Session: ebb1d9b7-9804-4c1c-ae21-e2d792814e96 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
169 | 2025.04.30 06:50:04.818085 [ 263 ] {} <Debug> TCP-Session: 716af162-4c09-426f-bd5a-efc679d15959 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
170 | 2025.04.30 06:50:04.817838 [ 264 ] {} <Debug> TCP-Session: fc9a8b49-f2f9-4558-be8a-c0b313fb58ae Authenticating user 'default' from [::1]:50893 | ||
171 | 2025.04.30 06:50:04.818185 [ 263 ] {} <Debug> TCP-Session: 716af162-4c09-426f-bd5a-efc679d15959 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
172 | 2025.04.30 06:50:04.818233 [ 264 ] {} <Debug> TCP-Session: fc9a8b49-f2f9-4558-be8a-c0b313fb58ae Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
173 | 2025.04.30 06:50:04.818210 [ 261 ] {0ae523fb-db14-4655-908d-ab7bb79163c4} <Debug> executeQuery: (from [::1]:34437) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
174 | 2025.04.30 06:50:04.818259 [ 264 ] {} <Debug> TCP-Session: fc9a8b49-f2f9-4558-be8a-c0b313fb58ae Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
175 | 2025.04.30 06:50:04.818289 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
176 | 2025.04.30 06:50:04.818277 [ 262 ] {} <Debug> TCP-Session: 0b57aa5e-333e-4a2d-9fdc-cf016e1a8f87 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
177 | 2025.04.30 06:50:04.818369 [ 267 ] {} <Debug> TCP-Session: c68cb7fd-74dc-4d2d-8c9f-73f7ef957b09 Authenticating user 'default' from [::1]:35942 | ||
178 | 2025.04.30 06:50:04.818416 [ 262 ] {} <Debug> TCP-Session: 0b57aa5e-333e-4a2d-9fdc-cf016e1a8f87 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
179 | 2025.04.30 06:50:04.818450 [ 267 ] {} <Debug> TCP-Session: c68cb7fd-74dc-4d2d-8c9f-73f7ef957b09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
180 | 2025.04.30 06:50:04.818470 [ 267 ] {} <Debug> TCP-Session: c68cb7fd-74dc-4d2d-8c9f-73f7ef957b09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
181 | 2025.04.30 06:50:04.818694 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
182 | 2025.04.30 06:50:04.818734 [ 268 ] {} <Debug> TCP-Session: afe575f3-ab04-428d-8132-7172b5bb78dc Authenticating user 'default' from [::1]:38484 | ||
183 | 2025.04.30 06:50:04.818749 [ 268 ] {} <Debug> TCP-Session: afe575f3-ab04-428d-8132-7172b5bb78dc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
184 | 2025.04.30 06:50:04.818760 [ 268 ] {} <Debug> TCP-Session: afe575f3-ab04-428d-8132-7172b5bb78dc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
185 | 2025.04.30 06:50:04.818909 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
186 | 2025.04.30 06:50:04.818951 [ 269 ] {} <Debug> TCP-Session: de060fd3-8efe-4251-aaa3-ac856b22062b Authenticating user 'default' from [::1]:44034 | ||
187 | 2025.04.30 06:50:04.818969 [ 269 ] {} <Debug> TCP-Session: de060fd3-8efe-4251-aaa3-ac856b22062b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
188 | 2025.04.30 06:50:04.818990 [ 269 ] {} <Debug> TCP-Session: de060fd3-8efe-4251-aaa3-ac856b22062b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
189 | 2025.04.30 06:50:04.827612 [ 261 ] {0ae523fb-db14-4655-908d-ab7bb79163c4} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:34437) (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.04.30 06:50:04.827844 [ 261 ] {0ae523fb-db14-4655-908d-ab7bb79163c4} <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.04.30 06:50:04.827944 [ 261 ] {0ae523fb-db14-4655-908d-ab7bb79163c4} <Debug> TCPHandler: Processed in 0.011152611 sec. | ||
238 | 2025.04.30 06:50:04.829207 [ 262 ] {} <Trace> TCP-Session: 0b57aa5e-333e-4a2d-9fdc-cf016e1a8f87 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
239 | 2025.04.30 06:50:04.829466 [ 262 ] {17a09c28-4327-4cf4-a84c-a4d68dce84b1} <Debug> executeQuery: (from [::1]:39333) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
240 | 2025.04.30 06:50:04.829895 [ 262 ] {17a09c28-4327-4cf4-a84c-a4d68dce84b1} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:39333) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
241 | |||
242 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
243 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
244 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
245 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
246 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
247 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
248 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
249 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
250 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
251 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
252 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
253 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
254 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
255 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
256 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
257 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
258 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
259 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
260 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
261 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
262 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
263 | |||
264 | 2025.04.30 06:50:04.830039 [ 262 ] {17a09c28-4327-4cf4-a84c-a4d68dce84b1} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
265 | |||
266 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
267 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
268 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
269 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
270 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
271 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
272 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
273 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
274 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
275 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
276 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
277 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
278 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
279 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
280 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
281 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
282 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
283 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
284 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
285 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
286 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
287 | |||
288 | 2025.04.30 06:50:04.830153 [ 262 ] {17a09c28-4327-4cf4-a84c-a4d68dce84b1} <Debug> TCPHandler: Processed in 0.00115906 sec. | ||
289 | 2025.04.30 06:50:04.845909 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
290 | 2025.04.30 06:50:04.846197 [ 261 ] {84284a44-0f0f-4d22-980a-6769e2030716} <Debug> executeQuery: (from [::1]:34437) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
291 | 2025.04.30 06:50:04.846306 [ 261 ] {84284a44-0f0f-4d22-980a-6769e2030716} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
292 | 2025.04.30 06:50:04.846901 [ 261 ] {84284a44-0f0f-4d22-980a-6769e2030716} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
293 | 2025.04.30 06:50:04.846939 [ 261 ] {84284a44-0f0f-4d22-980a-6769e2030716} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.9549e-05 sec | ||
294 | 2025.04.30 06:50:04.846954 [ 261 ] {84284a44-0f0f-4d22-980a-6769e2030716} <Trace> ReferentialDeps: No tables | ||
295 | 2025.04.30 06:50:04.846965 [ 261 ] {84284a44-0f0f-4d22-980a-6769e2030716} <Trace> LoadingDeps: No tables | ||
296 | 2025.04.30 06:50:04.846994 [ 261 ] {84284a44-0f0f-4d22-980a-6769e2030716} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
297 | 2025.04.30 06:50:04.847081 [ 261 ] {84284a44-0f0f-4d22-980a-6769e2030716} <Debug> TCPHandler: Processed in 0.001418917 sec. | ||
298 | 2025.04.30 06:50:04.847364 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
299 | 2025.04.30 06:50:04.847713 [ 261 ] {d1ddf7d1-8fb1-45a4-95dd-c58c3944e174} <Debug> executeQuery: (from [::1]:34437) /* The version table contains metadata about the `oximeter` database */ | ||
300 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
301 | 2025.04.30 06:50:04.847809 [ 261 ] {d1ddf7d1-8fb1-45a4-95dd-c58c3944e174} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
302 | 2025.04.30 06:50:04.849042 [ 261 ] {d1ddf7d1-8fb1-45a4-95dd-c58c3944e174} <Debug> oximeter.version (8a6e6ca4-0096-4d19-9305-dcfb7685d1ab): Loading data parts | ||
303 | 2025.04.30 06:50:04.849585 [ 261 ] {d1ddf7d1-8fb1-45a4-95dd-c58c3944e174} <Debug> oximeter.version (8a6e6ca4-0096-4d19-9305-dcfb7685d1ab): There are no data parts | ||
304 | 2025.04.30 06:50:04.850275 [ 261 ] {d1ddf7d1-8fb1-45a4-95dd-c58c3944e174} <Debug> TCPHandler: Processed in 0.002844307 sec. | ||
305 | 2025.04.30 06:50:04.850639 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
306 | 2025.04.30 06:50:04.850908 [ 261 ] {70537637-7aef-4db5-9eb3-a5a441a75e8a} <Debug> executeQuery: (from [::1]:34437) /* The measurement tables contain all individual samples from each timeseries. | ||
307 | * | ||
308 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
309 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
310 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
311 | * by all samples from the same timeseries. | ||
312 | * | ||
313 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
314 | * and then uses that to index quickly into the measurements tables. | ||
315 | */ | ||
316 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Bool) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
317 | 2025.04.30 06:50:04.850979 [ 261 ] {70537637-7aef-4db5-9eb3-a5a441a75e8a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
318 | 2025.04.30 06:50:04.852340 [ 261 ] {70537637-7aef-4db5-9eb3-a5a441a75e8a} <Debug> oximeter.measurements_bool (82668d21-ff7f-415b-bd7d-91d08927fa9a): Loading data parts | ||
319 | 2025.04.30 06:50:04.852784 [ 261 ] {70537637-7aef-4db5-9eb3-a5a441a75e8a} <Debug> oximeter.measurements_bool (82668d21-ff7f-415b-bd7d-91d08927fa9a): There are no data parts | ||
320 | 2025.04.30 06:50:04.853281 [ 261 ] {70537637-7aef-4db5-9eb3-a5a441a75e8a} <Debug> TCPHandler: Processed in 0.002718546 sec. | ||
321 | 2025.04.30 06:50:04.854831 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
322 | 2025.04.30 06:50:04.855084 [ 261 ] {4434c08d-81f5-4007-aae6-fadfaf62d2be} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
323 | 2025.04.30 06:50:04.855155 [ 261 ] {4434c08d-81f5-4007-aae6-fadfaf62d2be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
324 | 2025.04.30 06:50:04.856300 [ 261 ] {4434c08d-81f5-4007-aae6-fadfaf62d2be} <Debug> oximeter.measurements_i8 (49f9bd86-98ca-4145-a62e-b75fe142c92b): Loading data parts | ||
325 | 2025.04.30 06:50:04.856725 [ 261 ] {4434c08d-81f5-4007-aae6-fadfaf62d2be} <Debug> oximeter.measurements_i8 (49f9bd86-98ca-4145-a62e-b75fe142c92b): There are no data parts | ||
326 | 2025.04.30 06:50:04.857216 [ 261 ] {4434c08d-81f5-4007-aae6-fadfaf62d2be} <Debug> TCPHandler: Processed in 0.002460903 sec. | ||
327 | 2025.04.30 06:50:04.857663 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
328 | 2025.04.30 06:50:04.857950 [ 261 ] {02861991-cf0c-40a4-83a5-524fb031d84c} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
329 | 2025.04.30 06:50:04.858006 [ 261 ] {02861991-cf0c-40a4-83a5-524fb031d84c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
330 | 2025.04.30 06:50:04.859043 [ 261 ] {02861991-cf0c-40a4-83a5-524fb031d84c} <Debug> oximeter.measurements_u8 (c8ee12cd-371b-47ec-ab26-a129de509819): Loading data parts | ||
331 | 2025.04.30 06:50:04.859408 [ 261 ] {02861991-cf0c-40a4-83a5-524fb031d84c} <Debug> oximeter.measurements_u8 (c8ee12cd-371b-47ec-ab26-a129de509819): There are no data parts | ||
332 | 2025.04.30 06:50:04.859920 [ 261 ] {02861991-cf0c-40a4-83a5-524fb031d84c} <Debug> TCPHandler: Processed in 0.002327738 sec. | ||
333 | 2025.04.30 06:50:04.860764 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
334 | 2025.04.30 06:50:04.861004 [ 261 ] {3397fd6c-ca5a-45ee-8bb3-d7feaf4c1871} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
335 | 2025.04.30 06:50:04.861070 [ 261 ] {3397fd6c-ca5a-45ee-8bb3-d7feaf4c1871} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
336 | 2025.04.30 06:50:04.862136 [ 261 ] {3397fd6c-ca5a-45ee-8bb3-d7feaf4c1871} <Debug> oximeter.measurements_i16 (4e89a8c7-2c0f-4274-8a8e-c6a405f0e347): Loading data parts | ||
337 | 2025.04.30 06:50:04.862548 [ 261 ] {3397fd6c-ca5a-45ee-8bb3-d7feaf4c1871} <Debug> oximeter.measurements_i16 (4e89a8c7-2c0f-4274-8a8e-c6a405f0e347): There are no data parts | ||
338 | 2025.04.30 06:50:04.863085 [ 261 ] {3397fd6c-ca5a-45ee-8bb3-d7feaf4c1871} <Debug> TCPHandler: Processed in 0.002390303 sec. | ||
339 | 2025.04.30 06:50:04.864538 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
340 | 2025.04.30 06:50:04.864782 [ 261 ] {704dab80-f8b6-49ee-a845-e5c3fbfa8ef3} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
341 | 2025.04.30 06:50:04.864851 [ 261 ] {704dab80-f8b6-49ee-a845-e5c3fbfa8ef3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
342 | 2025.04.30 06:50:04.865899 [ 261 ] {704dab80-f8b6-49ee-a845-e5c3fbfa8ef3} <Debug> oximeter.measurements_u16 (bf92a00f-31ac-4620-afc5-c9df0a77394b): Loading data parts | ||
343 | 2025.04.30 06:50:04.866362 [ 261 ] {704dab80-f8b6-49ee-a845-e5c3fbfa8ef3} <Debug> oximeter.measurements_u16 (bf92a00f-31ac-4620-afc5-c9df0a77394b): There are no data parts | ||
344 | 2025.04.30 06:50:04.866901 [ 261 ] {704dab80-f8b6-49ee-a845-e5c3fbfa8ef3} <Debug> TCPHandler: Processed in 0.00243407 sec. | ||
345 | 2025.04.30 06:50:04.868702 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
346 | 2025.04.30 06:50:04.868946 [ 261 ] {e569ec9e-ebcc-417f-8393-a701a0be01a2} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
347 | 2025.04.30 06:50:04.869012 [ 261 ] {e569ec9e-ebcc-417f-8393-a701a0be01a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
348 | 2025.04.30 06:50:04.870303 [ 261 ] {e569ec9e-ebcc-417f-8393-a701a0be01a2} <Debug> oximeter.measurements_i32 (7b8f1544-720d-491a-bcae-3f4563950624): Loading data parts | ||
349 | 2025.04.30 06:50:04.870678 [ 261 ] {e569ec9e-ebcc-417f-8393-a701a0be01a2} <Debug> oximeter.measurements_i32 (7b8f1544-720d-491a-bcae-3f4563950624): There are no data parts | ||
350 | 2025.04.30 06:50:04.871281 [ 261 ] {e569ec9e-ebcc-417f-8393-a701a0be01a2} <Debug> TCPHandler: Processed in 0.002650381 sec. | ||
351 | 2025.04.30 06:50:04.874637 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
352 | 2025.04.30 06:50:04.874878 [ 261 ] {2f3c47cb-cdbd-47a9-bfae-800ca791602d} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
353 | 2025.04.30 06:50:04.874945 [ 261 ] {2f3c47cb-cdbd-47a9-bfae-800ca791602d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
354 | 2025.04.30 06:50:04.876173 [ 261 ] {2f3c47cb-cdbd-47a9-bfae-800ca791602d} <Debug> oximeter.measurements_u32 (a8caf2cc-5e1b-4bc7-842a-1653edb6070f): Loading data parts | ||
355 | 2025.04.30 06:50:04.876602 [ 261 ] {2f3c47cb-cdbd-47a9-bfae-800ca791602d} <Debug> oximeter.measurements_u32 (a8caf2cc-5e1b-4bc7-842a-1653edb6070f): There are no data parts | ||
356 | 2025.04.30 06:50:04.877157 [ 261 ] {2f3c47cb-cdbd-47a9-bfae-800ca791602d} <Debug> TCPHandler: Processed in 0.002591313 sec. | ||
357 | 2025.04.30 06:50:04.877768 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
358 | 2025.04.30 06:50:04.878017 [ 261 ] {52a2b3c5-9569-4301-b43b-6efe26e6d776} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
359 | 2025.04.30 06:50:04.878082 [ 261 ] {52a2b3c5-9569-4301-b43b-6efe26e6d776} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
360 | 2025.04.30 06:50:04.879099 [ 261 ] {52a2b3c5-9569-4301-b43b-6efe26e6d776} <Debug> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Loading data parts | ||
361 | 2025.04.30 06:50:04.879426 [ 261 ] {52a2b3c5-9569-4301-b43b-6efe26e6d776} <Debug> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): There are no data parts | ||
362 | 2025.04.30 06:50:04.879938 [ 261 ] {52a2b3c5-9569-4301-b43b-6efe26e6d776} <Debug> TCPHandler: Processed in 0.002239742 sec. | ||
363 | 2025.04.30 06:50:04.880640 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
364 | 2025.04.30 06:50:04.880876 [ 261 ] {b5d31e6f-58d0-413a-9a28-2e97a00022fd} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
365 | 2025.04.30 06:50:04.880942 [ 261 ] {b5d31e6f-58d0-413a-9a28-2e97a00022fd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
366 | 2025.04.30 06:50:04.882075 [ 261 ] {b5d31e6f-58d0-413a-9a28-2e97a00022fd} <Debug> oximeter.measurements_u64 (70601aa4-01aa-4d1f-87d0-2e9e96580c14): Loading data parts | ||
367 | 2025.04.30 06:50:04.882421 [ 261 ] {b5d31e6f-58d0-413a-9a28-2e97a00022fd} <Debug> oximeter.measurements_u64 (70601aa4-01aa-4d1f-87d0-2e9e96580c14): There are no data parts | ||
368 | 2025.04.30 06:50:04.882927 [ 261 ] {b5d31e6f-58d0-413a-9a28-2e97a00022fd} <Debug> TCPHandler: Processed in 0.002356806 sec. | ||
369 | 2025.04.30 06:50:04.883930 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
370 | 2025.04.30 06:50:04.884176 [ 261 ] {31da817d-ee6f-4613-a4de-0d4d37c9b20c} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
371 | 2025.04.30 06:50:04.884242 [ 261 ] {31da817d-ee6f-4613-a4de-0d4d37c9b20c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
372 | 2025.04.30 06:50:04.885259 [ 261 ] {31da817d-ee6f-4613-a4de-0d4d37c9b20c} <Debug> oximeter.measurements_f32 (f8bdd3ac-1619-405a-8682-74aeed6056d9): Loading data parts | ||
373 | 2025.04.30 06:50:04.885691 [ 261 ] {31da817d-ee6f-4613-a4de-0d4d37c9b20c} <Debug> oximeter.measurements_f32 (f8bdd3ac-1619-405a-8682-74aeed6056d9): There are no data parts | ||
374 | 2025.04.30 06:50:04.886218 [ 261 ] {31da817d-ee6f-4613-a4de-0d4d37c9b20c} <Debug> TCPHandler: Processed in 0.002357216 sec. | ||
375 | 2025.04.30 06:50:04.886603 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
376 | 2025.04.30 06:50:04.886837 [ 261 ] {b8f677a8-0927-41e4-8c7e-0615320abfdd} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_f64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
377 | 2025.04.30 06:50:04.886903 [ 261 ] {b8f677a8-0927-41e4-8c7e-0615320abfdd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
378 | 2025.04.30 06:50:04.888171 [ 261 ] {b8f677a8-0927-41e4-8c7e-0615320abfdd} <Debug> oximeter.measurements_f64 (37cb4b2e-ec3b-4793-90cd-31a1d2ff2865): Loading data parts | ||
379 | 2025.04.30 06:50:04.888642 [ 261 ] {b8f677a8-0927-41e4-8c7e-0615320abfdd} <Debug> oximeter.measurements_f64 (37cb4b2e-ec3b-4793-90cd-31a1d2ff2865): There are no data parts | ||
380 | 2025.04.30 06:50:04.889410 [ 261 ] {b8f677a8-0927-41e4-8c7e-0615320abfdd} <Debug> TCPHandler: Processed in 0.002869357 sec. | ||
381 | 2025.04.30 06:50:04.889984 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
382 | 2025.04.30 06:50:04.890312 [ 261 ] {f50aef69-5477-43ac-88d1-718d2fbbceb3} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_string ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(String) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
383 | 2025.04.30 06:50:04.890391 [ 261 ] {f50aef69-5477-43ac-88d1-718d2fbbceb3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
384 | 2025.04.30 06:50:04.891639 [ 261 ] {f50aef69-5477-43ac-88d1-718d2fbbceb3} <Debug> oximeter.measurements_string (073b1da6-ec81-4ae8-8d2d-c2ac1de1c289): Loading data parts | ||
385 | 2025.04.30 06:50:04.891978 [ 261 ] {f50aef69-5477-43ac-88d1-718d2fbbceb3} <Debug> oximeter.measurements_string (073b1da6-ec81-4ae8-8d2d-c2ac1de1c289): There are no data parts | ||
386 | 2025.04.30 06:50:04.892512 [ 261 ] {f50aef69-5477-43ac-88d1-718d2fbbceb3} <Debug> TCPHandler: Processed in 0.002683266 sec. | ||
387 | 2025.04.30 06:50:04.893206 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
388 | 2025.04.30 06:50:04.893447 [ 261 ] {1d47622d-e1f2-4406-b697-25e5ffe2c2f8} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
389 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
390 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
391 | * a string isn't palatable for a few reasons. | ||
392 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
393 | * details. | ||
394 | */ | ||
395 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
396 | 2025.04.30 06:50:04.893516 [ 261 ] {1d47622d-e1f2-4406-b697-25e5ffe2c2f8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
397 | 2025.04.30 06:50:04.894576 [ 261 ] {1d47622d-e1f2-4406-b697-25e5ffe2c2f8} <Debug> oximeter.measurements_bytes (0e417c72-333c-4617-bf07-cf947f38539b): Loading data parts | ||
398 | 2025.04.30 06:50:04.895125 [ 261 ] {1d47622d-e1f2-4406-b697-25e5ffe2c2f8} <Debug> oximeter.measurements_bytes (0e417c72-333c-4617-bf07-cf947f38539b): There are no data parts | ||
399 | 2025.04.30 06:50:04.895935 [ 261 ] {1d47622d-e1f2-4406-b697-25e5ffe2c2f8} <Debug> TCPHandler: Processed in 0.002795489 sec. | ||
400 | 2025.04.30 06:50:04.896395 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
401 | 2025.04.30 06:50:04.896781 [ 261 ] {54ec5130-39d3-4167-beba-f473a04e525c} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativei64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
402 | 2025.04.30 06:50:04.896881 [ 261 ] {54ec5130-39d3-4167-beba-f473a04e525c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
403 | 2025.04.30 06:50:04.900374 [ 261 ] {54ec5130-39d3-4167-beba-f473a04e525c} <Debug> oximeter.measurements_cumulativei64 (7743bc8d-a679-4dfa-b6e5-5eb3ee27be5d): Loading data parts | ||
404 | 2025.04.30 06:50:04.900857 [ 261 ] {54ec5130-39d3-4167-beba-f473a04e525c} <Debug> oximeter.measurements_cumulativei64 (7743bc8d-a679-4dfa-b6e5-5eb3ee27be5d): There are no data parts | ||
405 | 2025.04.30 06:50:04.901454 [ 261 ] {54ec5130-39d3-4167-beba-f473a04e525c} <Debug> TCPHandler: Processed in 0.00524485 sec. | ||
406 | 2025.04.30 06:50:04.901770 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
407 | 2025.04.30 06:50:04.902066 [ 261 ] {f9ca1bf3-3ad1-40a0-be03-c6aafbb79cd4} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
408 | 2025.04.30 06:50:04.902142 [ 261 ] {f9ca1bf3-3ad1-40a0-be03-c6aafbb79cd4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
409 | 2025.04.30 06:50:04.903249 [ 261 ] {f9ca1bf3-3ad1-40a0-be03-c6aafbb79cd4} <Debug> oximeter.measurements_cumulativeu64 (4cfae9eb-2255-4d7e-8b32-e2bb6e01e935): Loading data parts | ||
410 | 2025.04.30 06:50:04.903568 [ 261 ] {f9ca1bf3-3ad1-40a0-be03-c6aafbb79cd4} <Debug> oximeter.measurements_cumulativeu64 (4cfae9eb-2255-4d7e-8b32-e2bb6e01e935): There are no data parts | ||
411 | 2025.04.30 06:50:04.904508 [ 261 ] {f9ca1bf3-3ad1-40a0-be03-c6aafbb79cd4} <Debug> TCPHandler: Processed in 0.002819167 sec. | ||
412 | 2025.04.30 06:50:04.906857 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
413 | 2025.04.30 06:50:04.907118 [ 261 ] {54a85b1a-de56-4e1c-bad4-5f16b131bcd0} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
414 | 2025.04.30 06:50:04.907194 [ 261 ] {54a85b1a-de56-4e1c-bad4-5f16b131bcd0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
415 | 2025.04.30 06:50:04.908721 [ 261 ] {54a85b1a-de56-4e1c-bad4-5f16b131bcd0} <Debug> oximeter.measurements_cumulativef32 (431ab6e0-287c-4a5b-87ef-11955b1459bc): Loading data parts | ||
416 | 2025.04.30 06:50:04.909419 [ 261 ] {54a85b1a-de56-4e1c-bad4-5f16b131bcd0} <Debug> oximeter.measurements_cumulativef32 (431ab6e0-287c-4a5b-87ef-11955b1459bc): There are no data parts | ||
417 | 2025.04.30 06:50:04.910195 [ 261 ] {54a85b1a-de56-4e1c-bad4-5f16b131bcd0} <Debug> TCPHandler: Processed in 0.003411557 sec. | ||
418 | 2025.04.30 06:50:04.912225 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
419 | 2025.04.30 06:50:04.912484 [ 261 ] {ef916536-586e-4c4b-a976-78025fcd3ea9} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
420 | 2025.04.30 06:50:04.912558 [ 261 ] {ef916536-586e-4c4b-a976-78025fcd3ea9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
421 | 2025.04.30 06:50:04.913820 [ 261 ] {ef916536-586e-4c4b-a976-78025fcd3ea9} <Debug> oximeter.measurements_cumulativef64 (7f301961-c950-4605-ad30-93fb543044c2): Loading data parts | ||
422 | 2025.04.30 06:50:04.914330 [ 261 ] {ef916536-586e-4c4b-a976-78025fcd3ea9} <Debug> oximeter.measurements_cumulativef64 (7f301961-c950-4605-ad30-93fb543044c2): There are no data parts | ||
423 | 2025.04.30 06:50:04.914890 [ 261 ] {ef916536-586e-4c4b-a976-78025fcd3ea9} <Debug> TCPHandler: Processed in 0.00274053 sec. | ||
424 | 2025.04.30 06:50:04.915907 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
425 | 2025.04.30 06:50:04.916570 [ 261 ] {7baeab98-0456-4073-b141-3febd03dd1b4} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
426 | * NOTE: Array types cannot be Nullable, see | ||
427 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
428 | * for more details. | ||
429 | * | ||
430 | * This means we need to use empty arrays to indicate a missing value. This | ||
431 | * is unfortunate, and at this point relies on the fact that an | ||
432 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
433 | * to figure out another way to represent missing samples here. | ||
434 | */ | ||
435 | bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
436 | 2025.04.30 06:50:04.916658 [ 261 ] {7baeab98-0456-4073-b141-3febd03dd1b4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
437 | 2025.04.30 06:50:04.918105 [ 261 ] {7baeab98-0456-4073-b141-3febd03dd1b4} <Debug> oximeter.measurements_histogrami8 (e8c6b2d9-80c6-4612-8b0f-c1365187c754): Loading data parts | ||
438 | 2025.04.30 06:50:04.918691 [ 261 ] {7baeab98-0456-4073-b141-3febd03dd1b4} <Debug> oximeter.measurements_histogrami8 (e8c6b2d9-80c6-4612-8b0f-c1365187c754): There are no data parts | ||
439 | 2025.04.30 06:50:04.919420 [ 261 ] {7baeab98-0456-4073-b141-3febd03dd1b4} <Debug> TCPHandler: Processed in 0.00358829 sec. | ||
440 | 2025.04.30 06:50:04.920928 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
441 | 2025.04.30 06:50:04.923226 [ 261 ] {7394e0b4-a601-4709-b503-5d8f63067f3c} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
442 | 2025.04.30 06:50:04.923320 [ 261 ] {7394e0b4-a601-4709-b503-5d8f63067f3c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
443 | 2025.04.30 06:50:04.924679 [ 261 ] {7394e0b4-a601-4709-b503-5d8f63067f3c} <Debug> oximeter.measurements_histogramu8 (b41f7b37-2c50-4968-978b-4cbf86c696b9): Loading data parts | ||
444 | 2025.04.30 06:50:04.927242 [ 261 ] {7394e0b4-a601-4709-b503-5d8f63067f3c} <Debug> oximeter.measurements_histogramu8 (b41f7b37-2c50-4968-978b-4cbf86c696b9): There are no data parts | ||
445 | 2025.04.30 06:50:04.927888 [ 261 ] {7394e0b4-a601-4709-b503-5d8f63067f3c} <Debug> TCPHandler: Processed in 0.00713209 sec. | ||
446 | 2025.04.30 06:50:04.934313 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
447 | 2025.04.30 06:50:04.935177 [ 261 ] {cbed3a6f-ff74-46d3-b4c7-eea69a38fb50} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
448 | 2025.04.30 06:50:04.935276 [ 261 ] {cbed3a6f-ff74-46d3-b4c7-eea69a38fb50} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
449 | 2025.04.30 06:50:04.936767 [ 261 ] {cbed3a6f-ff74-46d3-b4c7-eea69a38fb50} <Debug> oximeter.measurements_histogrami16 (56ed9f17-5b1a-4df8-b2ed-7f681f39ed28): Loading data parts | ||
450 | 2025.04.30 06:50:04.937180 [ 261 ] {cbed3a6f-ff74-46d3-b4c7-eea69a38fb50} <Debug> oximeter.measurements_histogrami16 (56ed9f17-5b1a-4df8-b2ed-7f681f39ed28): There are no data parts | ||
451 | 2025.04.30 06:50:04.938473 [ 261 ] {cbed3a6f-ff74-46d3-b4c7-eea69a38fb50} <Debug> TCPHandler: Processed in 0.004240008 sec. | ||
452 | 2025.04.30 06:50:04.961990 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
453 | 2025.04.30 06:50:04.962471 [ 261 ] {bb6658c2-db61-4687-b585-0f43e97ce24d} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
454 | 2025.04.30 06:50:04.962571 [ 261 ] {bb6658c2-db61-4687-b585-0f43e97ce24d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
455 | 2025.04.30 06:50:04.964234 [ 261 ] {bb6658c2-db61-4687-b585-0f43e97ce24d} <Debug> oximeter.measurements_histogramu16 (584728ff-3f53-497d-b297-490303b0de9f): Loading data parts | ||
456 | 2025.04.30 06:50:04.964669 [ 261 ] {bb6658c2-db61-4687-b585-0f43e97ce24d} <Debug> oximeter.measurements_histogramu16 (584728ff-3f53-497d-b297-490303b0de9f): There are no data parts | ||
457 | 2025.04.30 06:50:04.967210 [ 261 ] {bb6658c2-db61-4687-b585-0f43e97ce24d} <Debug> TCPHandler: Processed in 0.005722852 sec. | ||
458 | 2025.04.30 06:50:05.009229 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
459 | 2025.04.30 06:50:05.009736 [ 261 ] {2f97863d-add4-4ce9-b61e-f6d9cc9de09b} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
460 | 2025.04.30 06:50:05.009871 [ 261 ] {2f97863d-add4-4ce9-b61e-f6d9cc9de09b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
461 | 2025.04.30 06:50:05.011737 [ 261 ] {2f97863d-add4-4ce9-b61e-f6d9cc9de09b} <Debug> oximeter.measurements_histogrami32 (16f814c2-e62d-4658-a603-b4a31ab9193c): Loading data parts | ||
462 | 2025.04.30 06:50:05.012381 [ 261 ] {2f97863d-add4-4ce9-b61e-f6d9cc9de09b} <Debug> oximeter.measurements_histogrami32 (16f814c2-e62d-4658-a603-b4a31ab9193c): There are no data parts | ||
463 | 2025.04.30 06:50:05.013149 [ 261 ] {2f97863d-add4-4ce9-b61e-f6d9cc9de09b} <Debug> TCPHandler: Processed in 0.00411062 sec. | ||
464 | 2025.04.30 06:50:05.013825 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
465 | 2025.04.30 06:50:05.014193 [ 261 ] {2747c05a-3be4-482d-811a-f8fb254beb39} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
466 | 2025.04.30 06:50:05.014286 [ 261 ] {2747c05a-3be4-482d-811a-f8fb254beb39} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
467 | 2025.04.30 06:50:05.015804 [ 261 ] {2747c05a-3be4-482d-811a-f8fb254beb39} <Debug> oximeter.measurements_histogramu32 (622d6d96-2a17-4a0c-87af-1da309d19fdb): Loading data parts | ||
468 | 2025.04.30 06:50:05.016306 [ 261 ] {2747c05a-3be4-482d-811a-f8fb254beb39} <Debug> oximeter.measurements_histogramu32 (622d6d96-2a17-4a0c-87af-1da309d19fdb): There are no data parts | ||
469 | 2025.04.30 06:50:05.017066 [ 261 ] {2747c05a-3be4-482d-811a-f8fb254beb39} <Debug> TCPHandler: Processed in 0.00332758 sec. | ||
470 | 2025.04.30 06:50:05.092218 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
471 | 2025.04.30 06:50:05.093013 [ 261 ] {e611485f-0f59-4c02-b9d4-2a56937724a6} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
472 | 2025.04.30 06:50:05.093150 [ 261 ] {e611485f-0f59-4c02-b9d4-2a56937724a6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
473 | 2025.04.30 06:50:05.095012 [ 261 ] {e611485f-0f59-4c02-b9d4-2a56937724a6} <Debug> oximeter.measurements_histogrami64 (7e57cc0d-ef92-4ac6-9c19-2502d992dcc7): Loading data parts | ||
474 | 2025.04.30 06:50:05.095412 [ 261 ] {e611485f-0f59-4c02-b9d4-2a56937724a6} <Debug> oximeter.measurements_histogrami64 (7e57cc0d-ef92-4ac6-9c19-2502d992dcc7): There are no data parts | ||
475 | 2025.04.30 06:50:05.096097 [ 261 ] {e611485f-0f59-4c02-b9d4-2a56937724a6} <Debug> TCPHandler: Processed in 0.004255629 sec. | ||
476 | 2025.04.30 06:50:05.102262 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
477 | 2025.04.30 06:50:05.102628 [ 261 ] {86c3c24c-808e-4e63-80cf-eb8d1d299139} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
478 | 2025.04.30 06:50:05.102717 [ 261 ] {86c3c24c-808e-4e63-80cf-eb8d1d299139} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
479 | 2025.04.30 06:50:05.104388 [ 261 ] {86c3c24c-808e-4e63-80cf-eb8d1d299139} <Debug> oximeter.measurements_histogramu64 (98df941e-8f1b-41c9-b14a-6b2370eb4300): Loading data parts | ||
480 | 2025.04.30 06:50:05.104659 [ 261 ] {86c3c24c-808e-4e63-80cf-eb8d1d299139} <Debug> oximeter.measurements_histogramu64 (98df941e-8f1b-41c9-b14a-6b2370eb4300): There are no data parts | ||
481 | 2025.04.30 06:50:05.105545 [ 261 ] {86c3c24c-808e-4e63-80cf-eb8d1d299139} <Debug> TCPHandler: Processed in 0.003359163 sec. | ||
482 | 2025.04.30 06:50:05.109825 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
483 | 2025.04.30 06:50:05.110323 [ 261 ] {4e40736d-2364-4691-a580-0b53eab1be00} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
484 | 2025.04.30 06:50:05.110442 [ 261 ] {4e40736d-2364-4691-a580-0b53eab1be00} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
485 | 2025.04.30 06:50:05.112243 [ 261 ] {4e40736d-2364-4691-a580-0b53eab1be00} <Debug> oximeter.measurements_histogramf32 (9fa4d909-7fae-43fd-ba50-1a40aae7ae07): Loading data parts | ||
486 | 2025.04.30 06:50:05.112711 [ 261 ] {4e40736d-2364-4691-a580-0b53eab1be00} <Debug> oximeter.measurements_histogramf32 (9fa4d909-7fae-43fd-ba50-1a40aae7ae07): There are no data parts | ||
487 | 2025.04.30 06:50:05.113437 [ 261 ] {4e40736d-2364-4691-a580-0b53eab1be00} <Debug> TCPHandler: Processed in 0.003718239 sec. | ||
488 | 2025.04.30 06:50:05.113769 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
489 | 2025.04.30 06:50:05.114147 [ 261 ] {14d7233c-6008-4d80-a6f6-872e0a7b5290} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
490 | 2025.04.30 06:50:05.114237 [ 261 ] {14d7233c-6008-4d80-a6f6-872e0a7b5290} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
491 | 2025.04.30 06:50:05.115794 [ 261 ] {14d7233c-6008-4d80-a6f6-872e0a7b5290} <Debug> oximeter.measurements_histogramf64 (e64d8658-b681-448d-9857-72029595d666): Loading data parts | ||
492 | 2025.04.30 06:50:05.116152 [ 261 ] {14d7233c-6008-4d80-a6f6-872e0a7b5290} <Debug> oximeter.measurements_histogramf64 (e64d8658-b681-448d-9857-72029595d666): There are no data parts | ||
493 | 2025.04.30 06:50:05.116745 [ 261 ] {14d7233c-6008-4d80-a6f6-872e0a7b5290} <Debug> TCPHandler: Processed in 0.00304666 sec. | ||
494 | 2025.04.30 06:50:05.117933 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
495 | 2025.04.30 06:50:05.118216 [ 261 ] {6050e73a-4f6e-4b9c-90a0-89ae944ad32e} <Debug> executeQuery: (from [::1]:34437) /* The field tables store named dimensions of each timeseries. | ||
496 | * | ||
497 | * As with the measurement tables, there is one field table for each field data | ||
498 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
499 | * this behavior **must not** be relied upon for query correctness. | ||
500 | * | ||
501 | * The index for the fields differs from the measurements, however. Rows are | ||
502 | * sorted by timeseries name, then field name, field value, and finally | ||
503 | * timeseries key. This reflects the most common pattern for looking them up: | ||
504 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
505 | * usually then used to look up measurements. | ||
506 | * | ||
507 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
508 | * timeseries name and then key, since it would improve lookups where one | ||
509 | * already has the key. Realistically though, these tables are quite small and | ||
510 | * so performance benefits will be low in absolute terms. | ||
511 | * | ||
512 | * TTL: We use a materialized column to expire old field table records. This | ||
513 | * column is generated automatically by the database whenever a new row is | ||
514 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
515 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
516 | * record will remain during a deduplication, which will have the last | ||
517 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
518 | * measurement tables. | ||
519 | */ | ||
520 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
521 | 2025.04.30 06:50:05.118299 [ 261 ] {6050e73a-4f6e-4b9c-90a0-89ae944ad32e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
522 | 2025.04.30 06:50:05.119588 [ 261 ] {6050e73a-4f6e-4b9c-90a0-89ae944ad32e} <Debug> oximeter.fields_bool (c9cf35f6-6a81-4702-b75f-1c5722f8c987): Loading data parts | ||
523 | 2025.04.30 06:50:05.119985 [ 261 ] {6050e73a-4f6e-4b9c-90a0-89ae944ad32e} <Debug> oximeter.fields_bool (c9cf35f6-6a81-4702-b75f-1c5722f8c987): There are no data parts | ||
524 | 2025.04.30 06:50:05.120580 [ 261 ] {6050e73a-4f6e-4b9c-90a0-89ae944ad32e} <Debug> TCPHandler: Processed in 0.002718326 sec. | ||
525 | 2025.04.30 06:50:05.122837 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
526 | 2025.04.30 06:50:05.123146 [ 261 ] {8b0dbc5f-7f53-4ed5-85fe-0dfe5baa64b8} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
527 | 2025.04.30 06:50:05.123227 [ 261 ] {8b0dbc5f-7f53-4ed5-85fe-0dfe5baa64b8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
528 | 2025.04.30 06:50:05.124511 [ 261 ] {8b0dbc5f-7f53-4ed5-85fe-0dfe5baa64b8} <Debug> oximeter.fields_i8 (7efc16fa-6931-4108-84f0-3ac4b44ede47): Loading data parts | ||
529 | 2025.04.30 06:50:05.124931 [ 261 ] {8b0dbc5f-7f53-4ed5-85fe-0dfe5baa64b8} <Debug> oximeter.fields_i8 (7efc16fa-6931-4108-84f0-3ac4b44ede47): There are no data parts | ||
530 | 2025.04.30 06:50:05.125513 [ 261 ] {8b0dbc5f-7f53-4ed5-85fe-0dfe5baa64b8} <Debug> TCPHandler: Processed in 0.002747774 sec. | ||
531 | 2025.04.30 06:50:05.126218 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
532 | 2025.04.30 06:50:05.126473 [ 261 ] {004886df-eafd-4260-b8f1-74b7dd6b96e2} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
533 | 2025.04.30 06:50:05.126542 [ 261 ] {004886df-eafd-4260-b8f1-74b7dd6b96e2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
534 | 2025.04.30 06:50:05.127749 [ 261 ] {004886df-eafd-4260-b8f1-74b7dd6b96e2} <Debug> oximeter.fields_u8 (02220bc1-d62a-4c17-afc0-b3d6849fdc3c): Loading data parts | ||
535 | 2025.04.30 06:50:05.128062 [ 261 ] {004886df-eafd-4260-b8f1-74b7dd6b96e2} <Debug> oximeter.fields_u8 (02220bc1-d62a-4c17-afc0-b3d6849fdc3c): There are no data parts | ||
536 | 2025.04.30 06:50:05.128599 [ 261 ] {004886df-eafd-4260-b8f1-74b7dd6b96e2} <Debug> TCPHandler: Processed in 0.002451724 sec. | ||
537 | 2025.04.30 06:50:05.130566 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
538 | 2025.04.30 06:50:05.130806 [ 261 ] {78e846bd-0a27-4512-9f0c-d389717c8cf7} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
539 | 2025.04.30 06:50:05.130880 [ 261 ] {78e846bd-0a27-4512-9f0c-d389717c8cf7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
540 | 2025.04.30 06:50:05.132227 [ 261 ] {78e846bd-0a27-4512-9f0c-d389717c8cf7} <Debug> oximeter.fields_i16 (07994289-a172-4ee0-bc71-dc29739f2b08): Loading data parts | ||
541 | 2025.04.30 06:50:05.132672 [ 261 ] {78e846bd-0a27-4512-9f0c-d389717c8cf7} <Debug> oximeter.fields_i16 (07994289-a172-4ee0-bc71-dc29739f2b08): There are no data parts | ||
542 | 2025.04.30 06:50:05.133253 [ 261 ] {78e846bd-0a27-4512-9f0c-d389717c8cf7} <Debug> TCPHandler: Processed in 0.002758346 sec. | ||
543 | 2025.04.30 06:50:05.134739 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
544 | 2025.04.30 06:50:05.135033 [ 261 ] {1cff5290-9480-44a0-b8cb-c5210c563501} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
545 | 2025.04.30 06:50:05.135107 [ 261 ] {1cff5290-9480-44a0-b8cb-c5210c563501} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
546 | 2025.04.30 06:50:05.136353 [ 261 ] {1cff5290-9480-44a0-b8cb-c5210c563501} <Debug> oximeter.fields_u16 (6e137060-f2f6-435f-9ba2-d8a6913b99ee): Loading data parts | ||
547 | 2025.04.30 06:50:05.136895 [ 261 ] {1cff5290-9480-44a0-b8cb-c5210c563501} <Debug> oximeter.fields_u16 (6e137060-f2f6-435f-9ba2-d8a6913b99ee): There are no data parts | ||
548 | 2025.04.30 06:50:05.137491 [ 261 ] {1cff5290-9480-44a0-b8cb-c5210c563501} <Debug> TCPHandler: Processed in 0.002824548 sec. | ||
549 | 2025.04.30 06:50:05.143535 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
550 | 2025.04.30 06:50:05.143830 [ 261 ] {df5a1680-8c63-45d5-92f6-07f3df0047a3} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
551 | 2025.04.30 06:50:05.143924 [ 261 ] {df5a1680-8c63-45d5-92f6-07f3df0047a3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
552 | 2025.04.30 06:50:05.145864 [ 261 ] {df5a1680-8c63-45d5-92f6-07f3df0047a3} <Debug> oximeter.fields_i32 (d0967136-a582-4508-bf1b-ee02f6db971c): Loading data parts | ||
553 | 2025.04.30 06:50:05.146265 [ 261 ] {df5a1680-8c63-45d5-92f6-07f3df0047a3} <Debug> oximeter.fields_i32 (d0967136-a582-4508-bf1b-ee02f6db971c): There are no data parts | ||
554 | 2025.04.30 06:50:05.147123 [ 261 ] {df5a1680-8c63-45d5-92f6-07f3df0047a3} <Debug> TCPHandler: Processed in 0.003685102 sec. | ||
555 | 2025.04.30 06:50:05.147685 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
556 | 2025.04.30 06:50:05.148151 [ 261 ] {84766d7e-a6fd-4722-a912-4697d2602f0c} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
557 | 2025.04.30 06:50:05.148368 [ 261 ] {84766d7e-a6fd-4722-a912-4697d2602f0c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
558 | 2025.04.30 06:50:05.149799 [ 261 ] {84766d7e-a6fd-4722-a912-4697d2602f0c} <Debug> oximeter.fields_u32 (5b54bbb6-cf36-4275-ab5c-f4b406aed7a2): Loading data parts | ||
559 | 2025.04.30 06:50:05.150148 [ 261 ] {84766d7e-a6fd-4722-a912-4697d2602f0c} <Debug> oximeter.fields_u32 (5b54bbb6-cf36-4275-ab5c-f4b406aed7a2): There are no data parts | ||
560 | 2025.04.30 06:50:05.150834 [ 261 ] {84766d7e-a6fd-4722-a912-4697d2602f0c} <Debug> TCPHandler: Processed in 0.00327209 sec. | ||
561 | 2025.04.30 06:50:05.152501 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
562 | 2025.04.30 06:50:05.152765 [ 261 ] {7b206ebb-102a-45fc-b9fd-3293b47cc746} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
563 | 2025.04.30 06:50:05.152850 [ 261 ] {7b206ebb-102a-45fc-b9fd-3293b47cc746} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
564 | 2025.04.30 06:50:05.154080 [ 261 ] {7b206ebb-102a-45fc-b9fd-3293b47cc746} <Debug> oximeter.fields_i64 (62303836-3096-447a-8eb5-bbdcf429f52c): Loading data parts | ||
565 | 2025.04.30 06:50:05.154317 [ 261 ] {7b206ebb-102a-45fc-b9fd-3293b47cc746} <Debug> oximeter.fields_i64 (62303836-3096-447a-8eb5-bbdcf429f52c): There are no data parts | ||
566 | 2025.04.30 06:50:05.154872 [ 261 ] {7b206ebb-102a-45fc-b9fd-3293b47cc746} <Debug> TCPHandler: Processed in 0.002451034 sec. | ||
567 | 2025.04.30 06:50:05.155214 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
568 | 2025.04.30 06:50:05.155479 [ 261 ] {ab2fc0a9-12db-40d8-841c-f68faa592efb} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
569 | 2025.04.30 06:50:05.155555 [ 261 ] {ab2fc0a9-12db-40d8-841c-f68faa592efb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
570 | 2025.04.30 06:50:05.156692 [ 261 ] {ab2fc0a9-12db-40d8-841c-f68faa592efb} <Debug> oximeter.fields_u64 (d8914e22-3b3f-41ce-ab24-01a5ec5c4590): Loading data parts | ||
571 | 2025.04.30 06:50:05.156903 [ 261 ] {ab2fc0a9-12db-40d8-841c-f68faa592efb} <Debug> oximeter.fields_u64 (d8914e22-3b3f-41ce-ab24-01a5ec5c4590): There are no data parts | ||
572 | 2025.04.30 06:50:05.157435 [ 261 ] {ab2fc0a9-12db-40d8-841c-f68faa592efb} <Debug> TCPHandler: Processed in 0.002291485 sec. | ||
573 | 2025.04.30 06:50:05.159414 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
574 | 2025.04.30 06:50:05.159658 [ 261 ] {b94d358f-a878-4f84-93ad-a54a48b266be} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
575 | 2025.04.30 06:50:05.159734 [ 261 ] {b94d358f-a878-4f84-93ad-a54a48b266be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
576 | 2025.04.30 06:50:05.160929 [ 261 ] {b94d358f-a878-4f84-93ad-a54a48b266be} <Debug> oximeter.fields_ipaddr (a8d7d0f3-f2c5-4805-89b8-9d0e14b3504a): Loading data parts | ||
577 | 2025.04.30 06:50:05.161352 [ 261 ] {b94d358f-a878-4f84-93ad-a54a48b266be} <Debug> oximeter.fields_ipaddr (a8d7d0f3-f2c5-4805-89b8-9d0e14b3504a): There are no data parts | ||
578 | 2025.04.30 06:50:05.161909 [ 261 ] {b94d358f-a878-4f84-93ad-a54a48b266be} <Debug> TCPHandler: Processed in 0.002568758 sec. | ||
579 | 2025.04.30 06:50:05.162292 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
580 | 2025.04.30 06:50:05.162550 [ 261 ] {df708c4e-e111-454c-9614-c760ec9606fc} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
581 | 2025.04.30 06:50:05.162621 [ 261 ] {df708c4e-e111-454c-9614-c760ec9606fc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
582 | 2025.04.30 06:50:05.163740 [ 261 ] {df708c4e-e111-454c-9614-c760ec9606fc} <Debug> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Loading data parts | ||
583 | 2025.04.30 06:50:05.164181 [ 261 ] {df708c4e-e111-454c-9614-c760ec9606fc} <Debug> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): There are no data parts | ||
584 | 2025.04.30 06:50:05.164695 [ 261 ] {df708c4e-e111-454c-9614-c760ec9606fc} <Debug> TCPHandler: Processed in 0.002473849 sec. | ||
585 | 2025.04.30 06:50:05.165080 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
586 | 2025.04.30 06:50:05.165321 [ 261 ] {3d621c1c-deaf-4ad0-bac1-a7a0026c0639} <Debug> executeQuery: (from [::1]:34437) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
587 | 2025.04.30 06:50:05.165399 [ 261 ] {3d621c1c-deaf-4ad0-bac1-a7a0026c0639} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
588 | 2025.04.30 06:50:05.166552 [ 261 ] {3d621c1c-deaf-4ad0-bac1-a7a0026c0639} <Debug> oximeter.fields_uuid (1bd10bd5-bb5f-4dc5-a8de-8eff80f4825f): Loading data parts | ||
589 | 2025.04.30 06:50:05.166897 [ 261 ] {3d621c1c-deaf-4ad0-bac1-a7a0026c0639} <Debug> oximeter.fields_uuid (1bd10bd5-bb5f-4dc5-a8de-8eff80f4825f): There are no data parts | ||
590 | 2025.04.30 06:50:05.167436 [ 261 ] {3d621c1c-deaf-4ad0-bac1-a7a0026c0639} <Debug> TCPHandler: Processed in 0.002427967 sec. | ||
591 | 2025.04.30 06:50:05.175454 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
592 | 2025.04.30 06:50:05.175765 [ 261 ] {f443346f-a412-47f4-b474-b4554c25e24c} <Debug> executeQuery: (from [::1]:34437) /* The timeseries schema table stores the extracted schema for the samples | ||
593 | * oximeter collects. | ||
594 | */ | ||
595 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
596 | 2025.04.30 06:50:05.175861 [ 261 ] {f443346f-a412-47f4-b474-b4554c25e24c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
597 | 2025.04.30 06:50:05.177118 [ 261 ] {f443346f-a412-47f4-b474-b4554c25e24c} <Debug> oximeter.timeseries_schema (7d2ff1a5-e1ad-4730-b466-ea3f59643a11): Loading data parts | ||
598 | 2025.04.30 06:50:05.177763 [ 261 ] {f443346f-a412-47f4-b474-b4554c25e24c} <Debug> oximeter.timeseries_schema (7d2ff1a5-e1ad-4730-b466-ea3f59643a11): There are no data parts | ||
599 | 2025.04.30 06:50:05.178764 [ 261 ] {f443346f-a412-47f4-b474-b4554c25e24c} <Debug> TCPHandler: Processed in 0.003353551 sec. | ||
600 | 2025.04.30 06:50:05.181553 [ 262 ] {} <Trace> TCP-Session: 0b57aa5e-333e-4a2d-9fdc-cf016e1a8f87 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
601 | 2025.04.30 06:50:05.181845 [ 262 ] {658b0217-aec2-408d-93c3-2a60b830ffe8} <Debug> executeQuery: (from [::1]:39333) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
602 | 2025.04.30 06:50:05.182062 [ 262 ] {658b0217-aec2-408d-93c3-2a60b830ffe8} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
603 | 2025.04.30 06:50:05.183668 [ 270 ] {658b0217-aec2-408d-93c3-2a60b830ffe8} <Trace> oximeter.version (8a6e6ca4-0096-4d19-9305-dcfb7685d1ab): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
604 | 2025.04.30 06:50:05.183747 [ 270 ] {658b0217-aec2-408d-93c3-2a60b830ffe8} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.33 GiB. | ||
605 | 2025.04.30 06:50:05.184352 [ 270 ] {658b0217-aec2-408d-93c3-2a60b830ffe8} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
606 | 2025.04.30 06:50:05.184667 [ 270 ] {658b0217-aec2-408d-93c3-2a60b830ffe8} <Trace> oximeter.version (8a6e6ca4-0096-4d19-9305-dcfb7685d1ab): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
607 | 2025.04.30 06:50:05.184958 [ 262 ] {658b0217-aec2-408d-93c3-2a60b830ffe8} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003244 sec., 308.26140567200986 rows/sec., 4.82 KiB/sec. | ||
608 | 2025.04.30 06:50:05.185246 [ 262 ] {658b0217-aec2-408d-93c3-2a60b830ffe8} <Debug> TCPHandler: Processed in 0.003799771 sec. | ||
609 | 2025.04.30 06:50:05.768276 [ 240 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 88 entries to flush up to offset 88 | ||
610 | 2025.04.30 06:50:05.768396 [ 240 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
611 | 2025.04.30 06:50:05.772166 [ 240 ] {} <Debug> system.query_log (58759d09-c360-40ac-91c3-2a8395afc818): Loading data parts | ||
612 | 2025.04.30 06:50:05.772684 [ 240 ] {} <Debug> system.query_log (58759d09-c360-40ac-91c3-2a8395afc818): There are no data parts | ||
613 | 2025.04.30 06:50:05.778809 [ 240 ] {} <Trace> system.query_log (58759d09-c360-40ac-91c3-2a8395afc818): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
614 | 2025.04.30 06:50:05.778964 [ 240 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.33 GiB. | ||
615 | 2025.04.30 06:50:05.781415 [ 240 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
616 | 2025.04.30 06:50:05.781844 [ 240 ] {} <Trace> system.query_log (58759d09-c360-40ac-91c3-2a8395afc818): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
617 | 2025.04.30 06:50:05.782541 [ 240 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 88 | ||
618 | 2025.04.30 06:50:06.000497 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 152.84 MiB, peak 152.84 MiB, free memory in arenas 0.00 B, will set to 148.67 MiB (RSS), difference: -4.17 MiB | ||
619 | 2025.04.30 06:50:09.306077 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
620 | 2025.04.30 06:50:09.306642 [ 261 ] {bd2ac6a4-bedb-47a0-ba83-4a9043e55698} <Debug> executeQuery: (from [::1]:34437) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
621 | 2025.04.30 06:50:09.307159 [ 261 ] {bd2ac6a4-bedb-47a0-ba83-4a9043e55698} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
622 | 2025.04.30 06:50:09.307361 [ 261 ] {bd2ac6a4-bedb-47a0-ba83-4a9043e55698} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
623 | 2025.04.30 06:50:09.308326 [ 261 ] {bd2ac6a4-bedb-47a0-ba83-4a9043e55698} <Debug> TCPHandler: Processed in 0.002496323 sec. | ||
624 | 2025.04.30 06:50:09.311405 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
625 | 2025.04.30 06:50:09.311603 [ 261 ] {a3b8a3f8-6de0-4e6c-aaf9-4a6ac73c2ce0} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
626 | 2025.04.30 06:50:09.311668 [ 261 ] {a3b8a3f8-6de0-4e6c-aaf9-4a6ac73c2ce0} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
627 | 2025.04.30 06:50:09.316193 [ 261 ] {a3b8a3f8-6de0-4e6c-aaf9-4a6ac73c2ce0} <Trace> oximeter.timeseries_schema (7d2ff1a5-e1ad-4730-b466-ea3f59643a11): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
628 | 2025.04.30 06:50:09.316283 [ 261 ] {a3b8a3f8-6de0-4e6c-aaf9-4a6ac73c2ce0} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.33 GiB. | ||
629 | 2025.04.30 06:50:09.317122 [ 261 ] {a3b8a3f8-6de0-4e6c-aaf9-4a6ac73c2ce0} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
630 | 2025.04.30 06:50:09.317491 [ 261 ] {a3b8a3f8-6de0-4e6c-aaf9-4a6ac73c2ce0} <Trace> oximeter.timeseries_schema (7d2ff1a5-e1ad-4730-b466-ea3f59643a11): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
631 | 2025.04.30 06:50:09.317829 [ 261 ] {a3b8a3f8-6de0-4e6c-aaf9-4a6ac73c2ce0} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.006274 sec., 159.38795027095952 rows/sec., 19.15 KiB/sec. | ||
632 | 2025.04.30 06:50:09.317901 [ 261 ] {a3b8a3f8-6de0-4e6c-aaf9-4a6ac73c2ce0} <Debug> TCPHandler: Processed in 0.006568347 sec. | ||
633 | 2025.04.30 06:50:09.319234 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
634 | 2025.04.30 06:50:09.319371 [ 261 ] {554c1edd-740c-4bf2-9d54-40329c0365ea} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
635 | 2025.04.30 06:50:09.319429 [ 261 ] {554c1edd-740c-4bf2-9d54-40329c0365ea} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
636 | 2025.04.30 06:50:09.323968 [ 261 ] {554c1edd-740c-4bf2-9d54-40329c0365ea} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
637 | 2025.04.30 06:50:09.324046 [ 261 ] {554c1edd-740c-4bf2-9d54-40329c0365ea} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.33 GiB. | ||
638 | 2025.04.30 06:50:09.324664 [ 261 ] {554c1edd-740c-4bf2-9d54-40329c0365ea} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
639 | 2025.04.30 06:50:09.325171 [ 261 ] {554c1edd-740c-4bf2-9d54-40329c0365ea} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
640 | 2025.04.30 06:50:09.325553 [ 261 ] {554c1edd-740c-4bf2-9d54-40329c0365ea} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.006192 sec., 322.99741602067184 rows/sec., 33.44 KiB/sec. | ||
641 | 2025.04.30 06:50:09.325831 [ 261 ] {554c1edd-740c-4bf2-9d54-40329c0365ea} <Debug> TCPHandler: Processed in 0.006708866 sec. | ||
642 | 2025.04.30 06:50:09.327939 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
643 | 2025.04.30 06:50:09.328125 [ 261 ] {4ff46ebd-868a-4376-a388-d03fc713f11e} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
644 | 2025.04.30 06:50:09.328243 [ 261 ] {4ff46ebd-868a-4376-a388-d03fc713f11e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
645 | 2025.04.30 06:50:09.329758 [ 261 ] {4ff46ebd-868a-4376-a388-d03fc713f11e} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
646 | 2025.04.30 06:50:09.329843 [ 261 ] {4ff46ebd-868a-4376-a388-d03fc713f11e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.33 GiB. | ||
647 | 2025.04.30 06:50:09.330395 [ 261 ] {4ff46ebd-868a-4376-a388-d03fc713f11e} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
648 | 2025.04.30 06:50:09.330760 [ 261 ] {4ff46ebd-868a-4376-a388-d03fc713f11e} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
649 | 2025.04.30 06:50:09.331117 [ 261 ] {4ff46ebd-868a-4376-a388-d03fc713f11e} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003024 sec., 330.6878306878307 rows/sec., 22.93 KiB/sec. | ||
650 | 2025.04.30 06:50:09.331249 [ 261 ] {4ff46ebd-868a-4376-a388-d03fc713f11e} <Debug> TCPHandler: Processed in 0.003380405 sec. | ||
651 | 2025.04.30 06:50:10.353289 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
652 | 2025.04.30 06:50:10.353609 [ 261 ] {b7d76d5f-bb71-41a1-b457-bdc41a8aa83c} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
653 | 2025.04.30 06:50:10.353710 [ 261 ] {b7d76d5f-bb71-41a1-b457-bdc41a8aa83c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
654 | 2025.04.30 06:50:10.356807 [ 261 ] {b7d76d5f-bb71-41a1-b457-bdc41a8aa83c} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
655 | 2025.04.30 06:50:10.356895 [ 261 ] {b7d76d5f-bb71-41a1-b457-bdc41a8aa83c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
656 | 2025.04.30 06:50:10.358135 [ 261 ] {b7d76d5f-bb71-41a1-b457-bdc41a8aa83c} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
657 | 2025.04.30 06:50:10.358576 [ 261 ] {b7d76d5f-bb71-41a1-b457-bdc41a8aa83c} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
658 | 2025.04.30 06:50:10.359125 [ 261 ] {b7d76d5f-bb71-41a1-b457-bdc41a8aa83c} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.005592 sec., 357.653791130186 rows/sec., 37.02 KiB/sec. | ||
659 | 2025.04.30 06:50:10.359198 [ 261 ] {b7d76d5f-bb71-41a1-b457-bdc41a8aa83c} <Debug> TCPHandler: Processed in 0.006126436 sec. | ||
660 | 2025.04.30 06:50:10.361949 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
661 | 2025.04.30 06:50:10.362259 [ 261 ] {162d688d-edd8-42ea-b2ba-33e72183f808} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
662 | 2025.04.30 06:50:10.362352 [ 261 ] {162d688d-edd8-42ea-b2ba-33e72183f808} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
663 | 2025.04.30 06:50:10.365347 [ 261 ] {162d688d-edd8-42ea-b2ba-33e72183f808} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
664 | 2025.04.30 06:50:10.365445 [ 261 ] {162d688d-edd8-42ea-b2ba-33e72183f808} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
665 | 2025.04.30 06:50:10.366048 [ 261 ] {162d688d-edd8-42ea-b2ba-33e72183f808} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
666 | 2025.04.30 06:50:10.366402 [ 261 ] {162d688d-edd8-42ea-b2ba-33e72183f808} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
667 | 2025.04.30 06:50:10.366704 [ 261 ] {162d688d-edd8-42ea-b2ba-33e72183f808} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.004543 sec., 220.1188641866608 rows/sec., 15.26 KiB/sec. | ||
668 | 2025.04.30 06:50:10.366846 [ 261 ] {162d688d-edd8-42ea-b2ba-33e72183f808} <Debug> TCPHandler: Processed in 0.005138157 sec. | ||
669 | 2025.04.30 06:50:10.758971 [ 128 ] {} <Debug> DNSResolver: Updating DNS cache | ||
670 | 2025.04.30 06:50:10.759021 [ 128 ] {} <Debug> DNSResolver: Updated DNS cache | ||
671 | 2025.04.30 06:50:10.795838 [ 237 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 427 entries to flush up to offset 976 | ||
672 | 2025.04.30 06:50:10.797100 [ 237 ] {} <Trace> system.asynchronous_metric_log (d99f813a-bd9a-43f8-9af6-a99f123f4e37): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
673 | 2025.04.30 06:50:10.797149 [ 237 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
674 | 2025.04.30 06:50:10.798067 [ 237 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
675 | 2025.04.30 06:50:10.798399 [ 237 ] {} <Trace> system.asynchronous_metric_log (d99f813a-bd9a-43f8-9af6-a99f123f4e37): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
676 | 2025.04.30 06:50:10.798728 [ 237 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 976 | ||
677 | 2025.04.30 06:50:10.846362 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16 | ||
678 | 2025.04.30 06:50:10.874897 [ 243 ] {} <Trace> system.metric_log (7aabd390-a2de-485c-9166-0f73b0a6808c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
679 | 2025.04.30 06:50:10.875058 [ 243 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
680 | 2025.04.30 06:50:10.887095 [ 243 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
681 | 2025.04.30 06:50:10.889126 [ 243 ] {} <Trace> system.metric_log (7aabd390-a2de-485c-9166-0f73b0a6808c): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
682 | 2025.04.30 06:50:10.893537 [ 243 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 16 | ||
683 | 2025.04.30 06:50:11.000499 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 149.86 MiB, peak 153.86 MiB, free memory in arenas 0.00 B, will set to 154.59 MiB (RSS), difference: 4.73 MiB | ||
684 | 2025.04.30 06:50:11.196087 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
685 | 2025.04.30 06:50:11.196467 [ 261 ] {108f737a-c609-454c-a55f-52dbb9a37f5e} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
686 | 2025.04.30 06:50:11.196585 [ 261 ] {108f737a-c609-454c-a55f-52dbb9a37f5e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
687 | 2025.04.30 06:50:11.198082 [ 261 ] {108f737a-c609-454c-a55f-52dbb9a37f5e} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
688 | 2025.04.30 06:50:11.198192 [ 261 ] {108f737a-c609-454c-a55f-52dbb9a37f5e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
689 | 2025.04.30 06:50:11.199090 [ 261 ] {108f737a-c609-454c-a55f-52dbb9a37f5e} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
690 | 2025.04.30 06:50:11.199477 [ 261 ] {108f737a-c609-454c-a55f-52dbb9a37f5e} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
691 | 2025.04.30 06:50:11.199845 [ 261 ] {108f737a-c609-454c-a55f-52dbb9a37f5e} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003457 sec., 578.5363031530228 rows/sec., 59.89 KiB/sec. | ||
692 | 2025.04.30 06:50:11.199925 [ 261 ] {108f737a-c609-454c-a55f-52dbb9a37f5e} <Debug> TCPHandler: Processed in 0.004164077 sec. | ||
693 | 2025.04.30 06:50:11.202209 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
694 | 2025.04.30 06:50:11.202573 [ 261 ] {029849f7-ff09-4f20-b44d-33014c4ea639} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
695 | 2025.04.30 06:50:11.202689 [ 261 ] {029849f7-ff09-4f20-b44d-33014c4ea639} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
696 | 2025.04.30 06:50:11.206068 [ 261 ] {029849f7-ff09-4f20-b44d-33014c4ea639} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
697 | 2025.04.30 06:50:11.206216 [ 261 ] {029849f7-ff09-4f20-b44d-33014c4ea639} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
698 | 2025.04.30 06:50:11.206877 [ 261 ] {029849f7-ff09-4f20-b44d-33014c4ea639} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
699 | 2025.04.30 06:50:11.207336 [ 261 ] {029849f7-ff09-4f20-b44d-33014c4ea639} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
700 | 2025.04.30 06:50:11.207658 [ 261 ] {029849f7-ff09-4f20-b44d-33014c4ea639} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.005172 sec., 193.34880123743233 rows/sec., 13.41 KiB/sec. | ||
701 | 2025.04.30 06:50:11.207764 [ 261 ] {029849f7-ff09-4f20-b44d-33014c4ea639} <Debug> TCPHandler: Processed in 0.006201506 sec. | ||
702 | 2025.04.30 06:50:12.196528 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
703 | 2025.04.30 06:50:12.196740 [ 261 ] {673a8d0f-8262-4f4d-9314-91f4321ceebc} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
704 | 2025.04.30 06:50:12.196977 [ 261 ] {673a8d0f-8262-4f4d-9314-91f4321ceebc} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
705 | 2025.04.30 06:50:12.198837 [ 261 ] {673a8d0f-8262-4f4d-9314-91f4321ceebc} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
706 | 2025.04.30 06:50:12.198922 [ 261 ] {673a8d0f-8262-4f4d-9314-91f4321ceebc} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
707 | 2025.04.30 06:50:12.199772 [ 261 ] {673a8d0f-8262-4f4d-9314-91f4321ceebc} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
708 | 2025.04.30 06:50:12.200427 [ 261 ] {673a8d0f-8262-4f4d-9314-91f4321ceebc} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
709 | 2025.04.30 06:50:12.200756 [ 261 ] {673a8d0f-8262-4f4d-9314-91f4321ceebc} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004075 sec., 490.79754601227 rows/sec., 50.81 KiB/sec. | ||
710 | 2025.04.30 06:50:12.201052 [ 261 ] {673a8d0f-8262-4f4d-9314-91f4321ceebc} <Debug> TCPHandler: Processed in 0.004664334 sec. | ||
711 | 2025.04.30 06:50:12.204448 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
712 | 2025.04.30 06:50:12.204810 [ 261 ] {2f0e50f9-bc6c-401c-9bc3-f2b5ef1f18d6} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
713 | 2025.04.30 06:50:12.204908 [ 261 ] {2f0e50f9-bc6c-401c-9bc3-f2b5ef1f18d6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
714 | 2025.04.30 06:50:12.208639 [ 261 ] {2f0e50f9-bc6c-401c-9bc3-f2b5ef1f18d6} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
715 | 2025.04.30 06:50:12.208685 [ 261 ] {2f0e50f9-bc6c-401c-9bc3-f2b5ef1f18d6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
716 | 2025.04.30 06:50:12.209422 [ 261 ] {2f0e50f9-bc6c-401c-9bc3-f2b5ef1f18d6} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
717 | 2025.04.30 06:50:12.209828 [ 261 ] {2f0e50f9-bc6c-401c-9bc3-f2b5ef1f18d6} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
718 | 2025.04.30 06:50:12.210115 [ 261 ] {2f0e50f9-bc6c-401c-9bc3-f2b5ef1f18d6} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.005409 sec., 184.87705675725644 rows/sec., 12.82 KiB/sec. | ||
719 | 2025.04.30 06:50:12.210180 [ 261 ] {2f0e50f9-bc6c-401c-9bc3-f2b5ef1f18d6} <Debug> TCPHandler: Processed in 0.005936558 sec. | ||
720 | 2025.04.30 06:50:13.289595 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
721 | 2025.04.30 06:50:13.289946 [ 261 ] {c0229009-fa12-40e4-ada3-c18f3a810983} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
722 | 2025.04.30 06:50:13.290056 [ 261 ] {c0229009-fa12-40e4-ada3-c18f3a810983} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
723 | 2025.04.30 06:50:13.293022 [ 261 ] {c0229009-fa12-40e4-ada3-c18f3a810983} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
724 | 2025.04.30 06:50:13.293104 [ 261 ] {c0229009-fa12-40e4-ada3-c18f3a810983} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
725 | 2025.04.30 06:50:13.293725 [ 261 ] {c0229009-fa12-40e4-ada3-c18f3a810983} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
726 | 2025.04.30 06:50:13.294105 [ 261 ] {c0229009-fa12-40e4-ada3-c18f3a810983} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
727 | 2025.04.30 06:50:13.294349 [ 261 ] {c0229009-fa12-40e4-ada3-c18f3a810983} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004539 sec., 440.6256884776383 rows/sec., 45.61 KiB/sec. | ||
728 | 2025.04.30 06:50:13.294451 [ 261 ] {c0229009-fa12-40e4-ada3-c18f3a810983} <Debug> TCPHandler: Processed in 0.00507405 sec. | ||
729 | 2025.04.30 06:50:13.294572 [ 116 ] {} <Debug> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
730 | 2025.04.30 06:50:13.294629 [ 116 ] {} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
731 | 2025.04.30 06:50:13.294654 [ 116 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
732 | 2025.04.30 06:50:13.295002 [ 246 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
733 | 2025.04.30 06:50:13.295241 [ 246 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
734 | 2025.04.30 06:50:13.295316 [ 246 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 2 rows starting from the beginning of the part | ||
735 | 2025.04.30 06:50:13.295541 [ 246 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 2 rows starting from the beginning of the part | ||
736 | 2025.04.30 06:50:13.295681 [ 246 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 2 rows starting from the beginning of the part | ||
737 | 2025.04.30 06:50:13.295860 [ 246 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 2 rows starting from the beginning of the part | ||
738 | 2025.04.30 06:50:13.296405 [ 246 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 2 rows starting from the beginning of the part | ||
739 | 2025.04.30 06:50:13.298163 [ 235 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 10 rows, containing 5 columns (5 merged, 0 gathered) in 0.003292049 sec., 3037.621857997861 rows/sec., 326.31 KiB/sec. | ||
740 | 2025.04.30 06:50:13.298488 [ 205 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
741 | 2025.04.30 06:50:13.299059 [ 205 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
742 | 2025.04.30 06:50:13.299182 [ 205 ] {c9225b07-77a7-4c27-a30c-c2cd617d9142::all_1_5_1} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
743 | 2025.04.30 06:50:13.299338 [ 205 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.32 MiB. | ||
744 | 2025.04.30 06:50:13.299691 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
745 | 2025.04.30 06:50:13.299894 [ 261 ] {ea2889b9-1a8b-4e84-b72d-2407ffab8ced} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
746 | 2025.04.30 06:50:13.299989 [ 261 ] {ea2889b9-1a8b-4e84-b72d-2407ffab8ced} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
747 | 2025.04.30 06:50:13.304561 [ 261 ] {ea2889b9-1a8b-4e84-b72d-2407ffab8ced} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
748 | 2025.04.30 06:50:13.304674 [ 261 ] {ea2889b9-1a8b-4e84-b72d-2407ffab8ced} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
749 | 2025.04.30 06:50:13.305374 [ 261 ] {ea2889b9-1a8b-4e84-b72d-2407ffab8ced} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
750 | 2025.04.30 06:50:13.305712 [ 261 ] {ea2889b9-1a8b-4e84-b72d-2407ffab8ced} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
751 | 2025.04.30 06:50:13.305971 [ 261 ] {ea2889b9-1a8b-4e84-b72d-2407ffab8ced} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.006141 sec., 162.83992835043153 rows/sec., 11.29 KiB/sec. | ||
752 | 2025.04.30 06:50:13.306030 [ 151 ] {} <Debug> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
753 | 2025.04.30 06:50:13.306098 [ 261 ] {ea2889b9-1a8b-4e84-b72d-2407ffab8ced} <Debug> TCPHandler: Processed in 0.006604629 sec. | ||
754 | 2025.04.30 06:50:13.306156 [ 151 ] {} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
755 | 2025.04.30 06:50:13.306222 [ 151 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
756 | 2025.04.30 06:50:13.306414 [ 203 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
757 | 2025.04.30 06:50:13.306547 [ 203 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
758 | 2025.04.30 06:50:13.306592 [ 203 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 1 rows starting from the beginning of the part | ||
759 | 2025.04.30 06:50:13.306706 [ 203 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 1 rows starting from the beginning of the part | ||
760 | 2025.04.30 06:50:13.306852 [ 203 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 1 rows starting from the beginning of the part | ||
761 | 2025.04.30 06:50:13.306965 [ 203 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 1 rows starting from the beginning of the part | ||
762 | 2025.04.30 06:50:13.307211 [ 203 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 1 rows starting from the beginning of the part | ||
763 | 2025.04.30 06:50:13.309374 [ 205 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 5 rows, containing 4 columns (4 merged, 0 gathered) in 0.003054647 sec., 1636.8503463739016 rows/sec., 113.49 KiB/sec. | ||
764 | 2025.04.30 06:50:13.309587 [ 205 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
765 | 2025.04.30 06:50:13.310030 [ 205 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
766 | 2025.04.30 06:50:13.310148 [ 205 ] {63189b30-5c16-42bb-8d00-437f79ac12fc::all_1_5_1} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
767 | 2025.04.30 06:50:13.310263 [ 205 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.24 MiB. | ||
768 | 2025.04.30 06:50:14.218436 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
769 | 2025.04.30 06:50:14.218674 [ 261 ] {fad31d3e-13c8-45bf-b0fd-945d4b229b49} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
770 | 2025.04.30 06:50:14.218761 [ 261 ] {fad31d3e-13c8-45bf-b0fd-945d4b229b49} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
771 | 2025.04.30 06:50:14.226528 [ 261 ] {fad31d3e-13c8-45bf-b0fd-945d4b229b49} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
772 | 2025.04.30 06:50:14.226693 [ 261 ] {fad31d3e-13c8-45bf-b0fd-945d4b229b49} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
773 | 2025.04.30 06:50:14.227309 [ 261 ] {fad31d3e-13c8-45bf-b0fd-945d4b229b49} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
774 | 2025.04.30 06:50:14.227699 [ 261 ] {fad31d3e-13c8-45bf-b0fd-945d4b229b49} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
775 | 2025.04.30 06:50:14.228028 [ 261 ] {fad31d3e-13c8-45bf-b0fd-945d4b229b49} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.009428 sec., 212.13406873143825 rows/sec., 21.96 KiB/sec. | ||
776 | 2025.04.30 06:50:14.228195 [ 261 ] {fad31d3e-13c8-45bf-b0fd-945d4b229b49} <Debug> TCPHandler: Processed in 0.009877501 sec. | ||
777 | 2025.04.30 06:50:14.229755 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
778 | 2025.04.30 06:50:14.229937 [ 261 ] {77197ea0-122b-4867-a573-c121fa129d21} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
779 | 2025.04.30 06:50:14.230026 [ 261 ] {77197ea0-122b-4867-a573-c121fa129d21} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
780 | 2025.04.30 06:50:14.234324 [ 261 ] {77197ea0-122b-4867-a573-c121fa129d21} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
781 | 2025.04.30 06:50:14.234383 [ 261 ] {77197ea0-122b-4867-a573-c121fa129d21} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
782 | 2025.04.30 06:50:14.234907 [ 261 ] {77197ea0-122b-4867-a573-c121fa129d21} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
783 | 2025.04.30 06:50:14.235318 [ 261 ] {77197ea0-122b-4867-a573-c121fa129d21} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
784 | 2025.04.30 06:50:14.235565 [ 261 ] {77197ea0-122b-4867-a573-c121fa129d21} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.005686 sec., 175.87055926837846 rows/sec., 12.19 KiB/sec. | ||
785 | 2025.04.30 06:50:14.235628 [ 261 ] {77197ea0-122b-4867-a573-c121fa129d21} <Debug> TCPHandler: Processed in 0.006026828 sec. | ||
786 | 2025.04.30 06:50:15.195173 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
787 | 2025.04.30 06:50:15.195387 [ 261 ] {9a88495f-ba91-4c71-9823-791782bf0998} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
788 | 2025.04.30 06:50:15.195475 [ 261 ] {9a88495f-ba91-4c71-9823-791782bf0998} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
789 | 2025.04.30 06:50:15.205942 [ 261 ] {9a88495f-ba91-4c71-9823-791782bf0998} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
790 | 2025.04.30 06:50:15.206276 [ 261 ] {9a88495f-ba91-4c71-9823-791782bf0998} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
791 | 2025.04.30 06:50:15.207099 [ 261 ] {9a88495f-ba91-4c71-9823-791782bf0998} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
792 | 2025.04.30 06:50:15.207709 [ 261 ] {9a88495f-ba91-4c71-9823-791782bf0998} <Trace> oximeter.fields_string (c9225b07-77a7-4c27-a30c-c2cd617d9142): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
793 | 2025.04.30 06:50:15.208106 [ 261 ] {9a88495f-ba91-4c71-9823-791782bf0998} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.012768 sec., 156.64160401002508 rows/sec., 16.21 KiB/sec. | ||
794 | 2025.04.30 06:50:15.208216 [ 261 ] {9a88495f-ba91-4c71-9823-791782bf0998} <Debug> TCPHandler: Processed in 0.013165862 sec. | ||
795 | 2025.04.30 06:50:15.210613 [ 261 ] {} <Trace> TCP-Session: 6f05018d-c479-42c9-b5c0-ee7ebb18fef3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
796 | 2025.04.30 06:50:15.210899 [ 261 ] {ce479f3e-ad4d-4e3d-a143-0092af3a7e71} <Debug> executeQuery: (from [::1]:34437) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
797 | 2025.04.30 06:50:15.211020 [ 261 ] {ce479f3e-ad4d-4e3d-a143-0092af3a7e71} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
798 | 2025.04.30 06:50:15.213432 [ 261 ] {ce479f3e-ad4d-4e3d-a143-0092af3a7e71} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
799 | 2025.04.30 06:50:15.213496 [ 261 ] {ce479f3e-ad4d-4e3d-a143-0092af3a7e71} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
800 | 2025.04.30 06:50:15.214125 [ 261 ] {ce479f3e-ad4d-4e3d-a143-0092af3a7e71} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
801 | 2025.04.30 06:50:15.214494 [ 261 ] {ce479f3e-ad4d-4e3d-a143-0092af3a7e71} <Trace> oximeter.measurements_i64 (63189b30-5c16-42bb-8d00-437f79ac12fc): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
802 | 2025.04.30 06:50:15.214850 [ 261 ] {ce479f3e-ad4d-4e3d-a143-0092af3a7e71} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.004037 sec., 247.7086945751796 rows/sec., 17.18 KiB/sec. | ||
803 | 2025.04.30 06:50:15.215041 [ 261 ] {ce479f3e-ad4d-4e3d-a143-0092af3a7e71} <Debug> TCPHandler: Processed in 0.004751157 sec. | ||
804 | 2025.04.30 06:50:15.783025 [ 240 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 32 entries to flush up to offset 120 | ||
805 | 2025.04.30 06:50:15.787686 [ 240 ] {} <Trace> system.query_log (58759d09-c360-40ac-91c3-2a8395afc818): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
806 | 2025.04.30 06:50:15.787755 [ 240 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 134.32 GiB. | ||
807 | 2025.04.30 06:50:15.789694 [ 240 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
808 | 2025.04.30 06:50:15.790193 [ 240 ] {} <Trace> system.query_log (58759d09-c360-40ac-91c3-2a8395afc818): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
809 | 2025.04.30 06:50:15.790971 [ 240 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 120 | ||
810 | 2025.04.30 06:50:16.001215 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 151.11 MiB, peak 158.13 MiB, free memory in arenas 0.00 B, will set to 154.98 MiB (RSS), difference: 3.87 MiB |