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