1 | 2025.03.07 23:34:04.354779 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 28335 | ||
2 | 2025.03.07 23:34:04.354982 [ 1 ] {} <Information> Application: starting up | ||
3 | 2025.03.07 23:34:04.355024 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2025.03.07 23:34:04.408490 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2025.03.07 23:34:04.413544 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2025.03.07 23:34:04.413581 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2025.03.07 23:34:04.413593 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2025.03.07 23:34:04.413645 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/datastore/tmp/ to store temporary data in it | ||
9 | 2025.03.07 23:34:04.415099 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2025.03.07 23:34:04.416136 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/config.xml' | ||
11 | 2025.03.07 23:34:04.416985 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/config.xml', performing update on configuration | ||
12 | 2025.03.07 23:34:04.417498 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.18 GiB (31.32 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
13 | 2025.03.07 23:34:04.417526 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.66 GiB (31.32 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
14 | 2025.03.07 23:34:04.417539 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2025.03.07 23:34:04.417629 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2025.03.07 23:34:04.418537 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2025.03.07 23:34:04.425471 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2025.03.07 23:34:04.489017 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2025.03.07 23:34:04.490041 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
20 | 2025.03.07 23:34:04.490117 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/config.xml', performed update on configuration | ||
21 | 2025.03.07 23:34:04.491926 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/config.xml' | ||
22 | 2025.03.07 23:34:04.493591 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/config.xml', performing update on configuration | ||
23 | 2025.03.07 23:34:04.495151 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/config.xml', performed update on configuration | ||
24 | 2025.03.07 23:34:04.495782 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/config.xml | ||
25 | 2025.03.07 23:34:04.544358 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
26 | 2025.03.07 23:34:04.544775 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2025.03.07 23:34:04.576207 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2025.03.07 23:34:04.578841 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
29 | 2025.03.07 23:34:04.589575 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2025.03.07 23:34:04.589611 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/datastore/ | ||
31 | 2025.03.07 23:34:04.590755 [ 131 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2025.03.07 23:34:04.591295 [ 131 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2025.03.07 23:34:04.591726 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2025.03.07 23:34:04.591751 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000127996 sec | ||
35 | 2025.03.07 23:34:04.591777 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2025.03.07 23:34:04.591788 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2025.03.07 23:34:04.591875 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2025.03.07 23:34:04.591925 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
39 | 2025.03.07 23:34:04.635391 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
40 | 2025.03.07 23:34:04.635453 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2025.03.07 23:34:04.635465 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2025.03.07 23:34:04.635476 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2025.03.07 23:34:04.635497 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2025.03.07 23:34:04.635527 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
45 | 2025.03.07 23:34:04.638588 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2025.03.07 23:34:04.638634 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
47 | 2025.03.07 23:34:04.638657 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
48 | 2025.03.07 23:34:04.638879 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2025.03.07 23:34:04.638898 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2025.03.07 23:34:04.638924 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2025.03.07 23:34:04.638935 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2025.03.07 23:34:04.638960 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2025.03.07 23:34:04.638971 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2025.03.07 23:34:04.638985 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2025.03.07 23:34:04.830441 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2025.03.07 23:34:04.831316 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2025.03.07 23:34:04.831356 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.3474e-05 sec | ||
58 | 2025.03.07 23:34:04.831372 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2025.03.07 23:34:04.831383 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2025.03.07 23:34:04.831415 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2025.03.07 23:34:04.831742 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all_output-dffb8234c21e858b-test_omdb_success_cases.28317.1-clickhouse-Fja5AK/datastore/user_defined/ | ||
62 | 2025.03.07 23:34:04.831821 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2025.03.07 23:34:04.831837 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2025.03.07 23:34:04.831847 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
65 | 2025.03.07 23:34:04.831863 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2025.03.07 23:34:04.832249 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 49666 | ||
67 | 2025.03.07 23:34:04.832663 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 59341 | ||
68 | 2025.03.07 23:34:04.833496 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 55383 | ||
69 | 2025.03.07 23:34:04.833580 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 62197 | ||
70 | 2025.03.07 23:34:04.833618 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
71 | 2025.03.07 23:34:04.833933 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.79 MiB, peak 24.79 MiB, free memory in arenas 0.00 B, will set to 127.52 MiB (RSS), difference: 102.73 MiB | ||
72 | 2025.03.07 23:34:04.834380 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 5.0284e-05 sec. | ||
73 | 2025.03.07 23:34:04.835216 [ 1 ] {} <Information> Application: Listening for http://[::1]:49666 | ||
74 | 2025.03.07 23:34:04.835285 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:59341 | ||
75 | 2025.03.07 23:34:04.849054 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:55383 | ||
76 | 2025.03.07 23:34:04.849171 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:62197 | ||
77 | 2025.03.07 23:34:04.849192 [ 1 ] {} <Information> Application: Ready for connections. | ||
78 | 2025.03.07 23:34:05.006620 [ 249 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 127.54 MiB, peak 127.54 MiB, free memory in arenas 0.00 B, will set to 128.84 MiB (RSS), difference: 1.30 MiB | ||
79 | 2025.03.07 23:34:07.380003 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56954 | ||
80 | 2025.03.07 23:34:07.392839 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
81 | 2025.03.07 23:34:07.392947 [ 3 ] {} <Debug> TCP-Session: 672a61ad-2d9e-4c6f-858c-64f502a78b49 Authenticating user 'default' from [::1]:56954 | ||
82 | 2025.03.07 23:34:07.392996 [ 3 ] {} <Debug> TCP-Session: 672a61ad-2d9e-4c6f-858c-64f502a78b49 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
83 | 2025.03.07 23:34:07.393015 [ 3 ] {} <Debug> TCP-Session: 672a61ad-2d9e-4c6f-858c-64f502a78b49 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2025.03.07 23:34:07.393142 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
85 | 2025.03.07 23:34:07.393280 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
86 | 2025.03.07 23:34:07.393325 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
87 | 2025.03.07 23:34:07.405926 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:62800 | ||
88 | 2025.03.07 23:34:07.406037 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:43488 | ||
89 | 2025.03.07 23:34:07.406655 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:57375 | ||
90 | 2025.03.07 23:34:07.406659 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:47796 | ||
91 | 2025.03.07 23:34:07.407494 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:50149 | ||
92 | 2025.03.07 23:34:07.407512 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:41195 | ||
93 | 2025.03.07 23:34:07.407679 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:38295 | ||
94 | 2025.03.07 23:34:07.410577 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
95 | 2025.03.07 23:34:07.410619 [ 4 ] {} <Debug> TCP-Session: 269c2530-da00-4c0d-93fb-536fcab94c0a Authenticating user 'default' from [::1]:62800 | ||
96 | 2025.03.07 23:34:07.410641 [ 4 ] {} <Debug> TCP-Session: 269c2530-da00-4c0d-93fb-536fcab94c0a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
97 | 2025.03.07 23:34:07.410662 [ 4 ] {} <Debug> TCP-Session: 269c2530-da00-4c0d-93fb-536fcab94c0a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
98 | 2025.03.07 23:34:07.411535 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
99 | 2025.03.07 23:34:07.411572 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
100 | 2025.03.07 23:34:07.411575 [ 5 ] {} <Debug> TCP-Session: d07b1020-f795-4435-a4c9-fb2a6d12e336 Authenticating user 'default' from [::1]:43488 | ||
101 | 2025.03.07 23:34:07.411620 [ 255 ] {} <Debug> TCP-Session: 09fa1986-af7c-4490-a8c1-8904a9c778f9 Authenticating user 'default' from [::1]:47796 | ||
102 | 2025.03.07 23:34:07.411626 [ 5 ] {} <Debug> TCP-Session: d07b1020-f795-4435-a4c9-fb2a6d12e336 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
103 | 2025.03.07 23:34:07.411646 [ 255 ] {} <Debug> TCP-Session: 09fa1986-af7c-4490-a8c1-8904a9c778f9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
104 | 2025.03.07 23:34:07.411658 [ 5 ] {} <Debug> TCP-Session: d07b1020-f795-4435-a4c9-fb2a6d12e336 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
105 | 2025.03.07 23:34:07.411667 [ 255 ] {} <Debug> TCP-Session: 09fa1986-af7c-4490-a8c1-8904a9c778f9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
106 | 2025.03.07 23:34:07.411860 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
107 | 2025.03.07 23:34:07.411879 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
108 | 2025.03.07 23:34:07.411899 [ 256 ] {} <Debug> TCP-Session: 97cec556-7e61-49b4-ae4f-de4c883650fd Authenticating user 'default' from [::1]:57375 | ||
109 | 2025.03.07 23:34:07.411919 [ 257 ] {} <Debug> TCP-Session: 8143f6d1-7c6b-4b61-b84b-ac27b59bb524 Authenticating user 'default' from [::1]:41195 | ||
110 | 2025.03.07 23:34:07.411924 [ 256 ] {} <Debug> TCP-Session: 97cec556-7e61-49b4-ae4f-de4c883650fd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
111 | 2025.03.07 23:34:07.411949 [ 257 ] {} <Debug> TCP-Session: 8143f6d1-7c6b-4b61-b84b-ac27b59bb524 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
112 | 2025.03.07 23:34:07.411955 [ 256 ] {} <Debug> TCP-Session: 97cec556-7e61-49b4-ae4f-de4c883650fd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
113 | 2025.03.07 23:34:07.411968 [ 257 ] {} <Debug> TCP-Session: 8143f6d1-7c6b-4b61-b84b-ac27b59bb524 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
114 | 2025.03.07 23:34:07.413153 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
115 | 2025.03.07 23:34:07.413190 [ 258 ] {} <Debug> TCP-Session: fb9092d5-3ec8-4ee8-b350-26b0d7005829 Authenticating user 'default' from [::1]:50149 | ||
116 | 2025.03.07 23:34:07.413204 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
117 | 2025.03.07 23:34:07.413236 [ 258 ] {} <Debug> TCP-Session: fb9092d5-3ec8-4ee8-b350-26b0d7005829 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
118 | 2025.03.07 23:34:07.413249 [ 259 ] {} <Debug> TCP-Session: 2302a48d-36c4-4ea1-8e45-7db07f007f12 Authenticating user 'default' from [::1]:38295 | ||
119 | 2025.03.07 23:34:07.413252 [ 258 ] {} <Debug> TCP-Session: fb9092d5-3ec8-4ee8-b350-26b0d7005829 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
120 | 2025.03.07 23:34:07.413271 [ 259 ] {} <Debug> TCP-Session: 2302a48d-36c4-4ea1-8e45-7db07f007f12 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
121 | 2025.03.07 23:34:07.413285 [ 259 ] {} <Debug> TCP-Session: 2302a48d-36c4-4ea1-8e45-7db07f007f12 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
122 | 2025.03.07 23:34:12.199352 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
123 | 2025.03.07 23:34:12.199352 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 549 entries to flush up to offset 549 | ||
124 | 2025.03.07 23:34:12.199507 [ 245 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
125 | 2025.03.07 23:34:12.199513 [ 244 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
126 | 2025.03.07 23:34:12.203621 [ 244 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
127 | 2025.03.07 23:34:12.204072 [ 244 ] {} <Debug> system.asynchronous_metric_log (21d2aba1-0395-4f26-8a83-239f2cf92f88): Loading data parts | ||
128 | 2025.03.07 23:34:12.204757 [ 244 ] {} <Debug> system.asynchronous_metric_log (21d2aba1-0395-4f26-8a83-239f2cf92f88): There are no data parts | ||
129 | 2025.03.07 23:34:12.209133 [ 244 ] {} <Trace> system.asynchronous_metric_log (21d2aba1-0395-4f26-8a83-239f2cf92f88): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
130 | 2025.03.07 23:34:12.209227 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
131 | 2025.03.07 23:34:12.210800 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
132 | 2025.03.07 23:34:12.211424 [ 244 ] {} <Trace> system.asynchronous_metric_log (21d2aba1-0395-4f26-8a83-239f2cf92f88): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
133 | 2025.03.07 23:34:12.211934 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 549 | ||
134 | 2025.03.07 23:34:12.223785 [ 245 ] {} <Debug> system.metric_log (a8177820-099d-4483-b768-aa36523de9da): Loading data parts | ||
135 | 2025.03.07 23:34:12.224073 [ 245 ] {} <Debug> system.metric_log (a8177820-099d-4483-b768-aa36523de9da): There are no data parts | ||
136 | 2025.03.07 23:34:12.259962 [ 245 ] {} <Trace> system.metric_log (a8177820-099d-4483-b768-aa36523de9da): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
137 | 2025.03.07 23:34:12.260093 [ 245 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
138 | 2025.03.07 23:34:12.273470 [ 245 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
139 | 2025.03.07 23:34:12.275419 [ 245 ] {} <Trace> system.metric_log (a8177820-099d-4483-b768-aa36523de9da): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
140 | 2025.03.07 23:34:12.281068 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
141 | 2025.03.07 23:34:13.000282 [ 249 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 134.08 MiB, peak 138.08 MiB, free memory in arenas 0.00 B, will set to 140.14 MiB (RSS), difference: 6.05 MiB | ||
142 | 2025.03.07 23:34:16.594700 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:36135 | ||
143 | 2025.03.07 23:34:16.595353 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
144 | 2025.03.07 23:34:16.595415 [ 261 ] {} <Debug> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Authenticating user 'default' from [::1]:36135 | ||
145 | 2025.03.07 23:34:16.595444 [ 261 ] {} <Debug> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2025.03.07 23:34:16.595459 [ 261 ] {} <Debug> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
147 | 2025.03.07 23:34:16.603155 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:36277 | ||
148 | 2025.03.07 23:34:16.603492 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:45372 | ||
149 | 2025.03.07 23:34:16.603493 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:42820 | ||
150 | 2025.03.07 23:34:16.603839 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:39431 | ||
151 | 2025.03.07 23:34:16.604173 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:46972 | ||
152 | 2025.03.07 23:34:16.604183 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:47014 | ||
153 | 2025.03.07 23:34:16.604627 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:62801 | ||
154 | 2025.03.07 23:34:16.604640 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53319 | ||
155 | 2025.03.07 23:34:16.606146 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
156 | 2025.03.07 23:34:16.606656 [ 261 ] {17e222c1-2dfc-4913-bf38-2230e6be821a} <Debug> executeQuery: (from [::1]:36135) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
157 | 2025.03.07 23:34:16.607769 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
158 | 2025.03.07 23:34:16.607796 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
159 | 2025.03.07 23:34:16.607813 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
160 | 2025.03.07 23:34:16.607853 [ 263 ] {} <Debug> TCP-Session: a0e077b8-c7f8-4709-b459-2507b4debbcc Authenticating user 'default' from [::1]:42820 | ||
161 | 2025.03.07 23:34:16.607876 [ 263 ] {} <Debug> TCP-Session: a0e077b8-c7f8-4709-b459-2507b4debbcc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
162 | 2025.03.07 23:34:16.607880 [ 264 ] {} <Debug> TCP-Session: a201399f-a300-454f-847e-92ba93da6f81 Authenticating user 'default' from [::1]:45372 | ||
163 | 2025.03.07 23:34:16.607899 [ 263 ] {} <Debug> TCP-Session: a0e077b8-c7f8-4709-b459-2507b4debbcc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
164 | 2025.03.07 23:34:16.607926 [ 264 ] {} <Debug> TCP-Session: a201399f-a300-454f-847e-92ba93da6f81 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
165 | 2025.03.07 23:34:16.607988 [ 264 ] {} <Debug> TCP-Session: a201399f-a300-454f-847e-92ba93da6f81 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
166 | 2025.03.07 23:34:16.607824 [ 262 ] {} <Debug> TCP-Session: 287610ca-b0f5-4f4c-b6e1-931b66c54528 Authenticating user 'default' from [::1]:36277 | ||
167 | 2025.03.07 23:34:16.608050 [ 262 ] {} <Debug> TCP-Session: 287610ca-b0f5-4f4c-b6e1-931b66c54528 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
168 | 2025.03.07 23:34:16.608069 [ 262 ] {} <Debug> TCP-Session: 287610ca-b0f5-4f4c-b6e1-931b66c54528 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
169 | 2025.03.07 23:34:16.608103 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
170 | 2025.03.07 23:34:16.608138 [ 265 ] {} <Debug> TCP-Session: 1a0ffa07-40be-4dfc-a112-59ff0a0aa95f Authenticating user 'default' from [::1]:39431 | ||
171 | 2025.03.07 23:34:16.608155 [ 265 ] {} <Debug> TCP-Session: 1a0ffa07-40be-4dfc-a112-59ff0a0aa95f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
172 | 2025.03.07 23:34:16.608186 [ 265 ] {} <Debug> TCP-Session: 1a0ffa07-40be-4dfc-a112-59ff0a0aa95f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
173 | 2025.03.07 23:34:16.608387 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
174 | 2025.03.07 23:34:16.608457 [ 266 ] {} <Debug> TCP-Session: 4b0d70f4-980b-49fb-afc6-2504b892245f Authenticating user 'default' from [::1]:47014 | ||
175 | 2025.03.07 23:34:16.608481 [ 266 ] {} <Debug> TCP-Session: 4b0d70f4-980b-49fb-afc6-2504b892245f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
176 | 2025.03.07 23:34:16.608494 [ 266 ] {} <Debug> TCP-Session: 4b0d70f4-980b-49fb-afc6-2504b892245f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
177 | 2025.03.07 23:34:16.608605 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
178 | 2025.03.07 23:34:16.608645 [ 267 ] {} <Debug> TCP-Session: 79d9e4c2-1523-4aac-aa68-5001a47e1b89 Authenticating user 'default' from [::1]:46972 | ||
179 | 2025.03.07 23:34:16.608661 [ 267 ] {} <Debug> TCP-Session: 79d9e4c2-1523-4aac-aa68-5001a47e1b89 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
180 | 2025.03.07 23:34:16.608684 [ 267 ] {} <Debug> TCP-Session: 79d9e4c2-1523-4aac-aa68-5001a47e1b89 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
181 | 2025.03.07 23:34:16.608822 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
182 | 2025.03.07 23:34:16.608859 [ 268 ] {} <Debug> TCP-Session: 5c027120-1e78-4830-b29b-b7da3e0d098f Authenticating user 'default' from [::1]:53319 | ||
183 | 2025.03.07 23:34:16.608879 [ 268 ] {} <Debug> TCP-Session: 5c027120-1e78-4830-b29b-b7da3e0d098f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
184 | 2025.03.07 23:34:16.608894 [ 268 ] {} <Debug> TCP-Session: 5c027120-1e78-4830-b29b-b7da3e0d098f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
185 | 2025.03.07 23:34:16.609005 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
186 | 2025.03.07 23:34:16.609036 [ 269 ] {} <Debug> TCP-Session: b6455dd6-c8be-492a-8ae6-658494b417db Authenticating user 'default' from [::1]:62801 | ||
187 | 2025.03.07 23:34:16.609052 [ 269 ] {} <Debug> TCP-Session: b6455dd6-c8be-492a-8ae6-658494b417db Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
188 | 2025.03.07 23:34:16.609070 [ 269 ] {} <Debug> TCP-Session: b6455dd6-c8be-492a-8ae6-658494b417db Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
189 | 2025.03.07 23:34:16.616003 [ 261 ] {17e222c1-2dfc-4913-bf38-2230e6be821a} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:36135) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
190 | |||
191 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
192 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
193 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
197 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
198 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
199 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
200 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
201 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
202 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
203 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
204 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
205 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
206 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
207 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
208 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
209 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
210 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
211 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
212 | |||
213 | 2025.03.07 23:34:16.616311 [ 261 ] {17e222c1-2dfc-4913-bf38-2230e6be821a} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
214 | |||
215 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
216 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
217 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
218 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
219 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
220 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
221 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
222 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
223 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
224 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
225 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
226 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
227 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
228 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
229 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
230 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
231 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
232 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
233 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
234 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
235 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
236 | |||
237 | 2025.03.07 23:34:16.616431 [ 261 ] {17e222c1-2dfc-4913-bf38-2230e6be821a} <Debug> TCPHandler: Processed in 0.010798943 sec. | ||
238 | 2025.03.07 23:34:16.621721 [ 262 ] {} <Trace> TCP-Session: 287610ca-b0f5-4f4c-b6e1-931b66c54528 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
239 | 2025.03.07 23:34:16.622012 [ 262 ] {66dd1826-d984-4019-b9f0-436fcf1e4c85} <Debug> executeQuery: (from [::1]:36277) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
240 | 2025.03.07 23:34:16.622460 [ 262 ] {66dd1826-d984-4019-b9f0-436fcf1e4c85} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:36277) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
241 | |||
242 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
243 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
244 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
245 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
246 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
247 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
248 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
249 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
250 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
251 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
252 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
253 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
254 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
255 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
256 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
257 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
258 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
259 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
260 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
261 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
262 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
263 | |||
264 | 2025.03.07 23:34:16.622619 [ 262 ] {66dd1826-d984-4019-b9f0-436fcf1e4c85} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
265 | |||
266 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
267 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
268 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
269 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
270 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
271 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
272 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
273 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
274 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
275 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
276 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
277 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
278 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
279 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
280 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
281 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
282 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
283 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
284 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
285 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
286 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
287 | |||
288 | 2025.03.07 23:34:16.622720 [ 262 ] {66dd1826-d984-4019-b9f0-436fcf1e4c85} <Debug> TCPHandler: Processed in 0.001232256 sec. | ||
289 | 2025.03.07 23:34:16.632636 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
290 | 2025.03.07 23:34:16.632927 [ 261 ] {4028c3eb-a665-4eac-b1d8-4b7d13c67d73} <Debug> executeQuery: (from [::1]:36135) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
291 | 2025.03.07 23:34:16.633056 [ 261 ] {4028c3eb-a665-4eac-b1d8-4b7d13c67d73} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
292 | 2025.03.07 23:34:16.633692 [ 261 ] {4028c3eb-a665-4eac-b1d8-4b7d13c67d73} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
293 | 2025.03.07 23:34:16.633731 [ 261 ] {4028c3eb-a665-4eac-b1d8-4b7d13c67d73} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.1796e-05 sec | ||
294 | 2025.03.07 23:34:16.633749 [ 261 ] {4028c3eb-a665-4eac-b1d8-4b7d13c67d73} <Trace> ReferentialDeps: No tables | ||
295 | 2025.03.07 23:34:16.633761 [ 261 ] {4028c3eb-a665-4eac-b1d8-4b7d13c67d73} <Trace> LoadingDeps: No tables | ||
296 | 2025.03.07 23:34:16.633790 [ 261 ] {4028c3eb-a665-4eac-b1d8-4b7d13c67d73} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
297 | 2025.03.07 23:34:16.633893 [ 261 ] {4028c3eb-a665-4eac-b1d8-4b7d13c67d73} <Debug> TCPHandler: Processed in 0.001456969 sec. | ||
298 | 2025.03.07 23:34:16.637450 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
299 | 2025.03.07 23:34:16.637747 [ 261 ] {52df60f2-7a5a-4ecc-afa1-4f09bd447339} <Debug> executeQuery: (from [::1]:36135) /* The version table contains metadata about the `oximeter` database */ | ||
300 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
301 | 2025.03.07 23:34:16.637890 [ 261 ] {52df60f2-7a5a-4ecc-afa1-4f09bd447339} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
302 | 2025.03.07 23:34:16.639077 [ 261 ] {52df60f2-7a5a-4ecc-afa1-4f09bd447339} <Debug> oximeter.version (4d7b09ee-4b36-4ac3-9c03-0596e4f8d75a): Loading data parts | ||
303 | 2025.03.07 23:34:16.639416 [ 261 ] {52df60f2-7a5a-4ecc-afa1-4f09bd447339} <Debug> oximeter.version (4d7b09ee-4b36-4ac3-9c03-0596e4f8d75a): There are no data parts | ||
304 | 2025.03.07 23:34:16.639894 [ 261 ] {52df60f2-7a5a-4ecc-afa1-4f09bd447339} <Debug> TCPHandler: Processed in 0.002635711 sec. | ||
305 | 2025.03.07 23:34:16.653089 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
306 | 2025.03.07 23:34:16.653533 [ 261 ] {88086ce2-0882-48d6-bd05-fa9cdb2cd705} <Debug> executeQuery: (from [::1]:36135) /* The measurement tables contain all individual samples from each timeseries. | ||
307 | * | ||
308 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
309 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
310 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
311 | * by all samples from the same timeseries. | ||
312 | * | ||
313 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
314 | * and then uses that to index quickly into the measurements tables. | ||
315 | */ | ||
316 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Bool) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
317 | 2025.03.07 23:34:16.653638 [ 261 ] {88086ce2-0882-48d6-bd05-fa9cdb2cd705} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
318 | 2025.03.07 23:34:16.655299 [ 261 ] {88086ce2-0882-48d6-bd05-fa9cdb2cd705} <Debug> oximeter.measurements_bool (2a13dcc1-4b2b-4558-af0a-8e68db1b5a44): Loading data parts | ||
319 | 2025.03.07 23:34:16.655682 [ 261 ] {88086ce2-0882-48d6-bd05-fa9cdb2cd705} <Debug> oximeter.measurements_bool (2a13dcc1-4b2b-4558-af0a-8e68db1b5a44): There are no data parts | ||
320 | 2025.03.07 23:34:16.656284 [ 261 ] {88086ce2-0882-48d6-bd05-fa9cdb2cd705} <Debug> TCPHandler: Processed in 0.003425502 sec. | ||
321 | 2025.03.07 23:34:16.658763 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
322 | 2025.03.07 23:34:16.659149 [ 261 ] {e05bfd71-1ea1-482b-82a1-3367c074d31d} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
323 | 2025.03.07 23:34:16.659261 [ 261 ] {e05bfd71-1ea1-482b-82a1-3367c074d31d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
324 | 2025.03.07 23:34:16.660965 [ 261 ] {e05bfd71-1ea1-482b-82a1-3367c074d31d} <Debug> oximeter.measurements_i8 (9c63dcf4-81a6-469c-aff8-ea86486ff499): Loading data parts | ||
325 | 2025.03.07 23:34:16.661349 [ 261 ] {e05bfd71-1ea1-482b-82a1-3367c074d31d} <Debug> oximeter.measurements_i8 (9c63dcf4-81a6-469c-aff8-ea86486ff499): There are no data parts | ||
326 | 2025.03.07 23:34:16.661947 [ 261 ] {e05bfd71-1ea1-482b-82a1-3367c074d31d} <Debug> TCPHandler: Processed in 0.003354762 sec. | ||
327 | 2025.03.07 23:34:16.665202 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
328 | 2025.03.07 23:34:16.665539 [ 261 ] {c5c8ab95-93c2-45e5-aaeb-e6929c90bfcb} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
329 | 2025.03.07 23:34:16.665616 [ 261 ] {c5c8ab95-93c2-45e5-aaeb-e6929c90bfcb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
330 | 2025.03.07 23:34:16.667132 [ 261 ] {c5c8ab95-93c2-45e5-aaeb-e6929c90bfcb} <Debug> oximeter.measurements_u8 (f0b664d7-3709-4d27-be2a-f216f55c30f2): Loading data parts | ||
331 | 2025.03.07 23:34:16.667380 [ 261 ] {c5c8ab95-93c2-45e5-aaeb-e6929c90bfcb} <Debug> oximeter.measurements_u8 (f0b664d7-3709-4d27-be2a-f216f55c30f2): There are no data parts | ||
332 | 2025.03.07 23:34:16.667898 [ 261 ] {c5c8ab95-93c2-45e5-aaeb-e6929c90bfcb} <Debug> TCPHandler: Processed in 0.002852031 sec. | ||
333 | 2025.03.07 23:34:16.677522 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
334 | 2025.03.07 23:34:16.677978 [ 261 ] {d16728e0-3dbc-47a6-920f-f62ca067ba4d} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
335 | 2025.03.07 23:34:16.678088 [ 261 ] {d16728e0-3dbc-47a6-920f-f62ca067ba4d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
336 | 2025.03.07 23:34:16.679592 [ 261 ] {d16728e0-3dbc-47a6-920f-f62ca067ba4d} <Debug> oximeter.measurements_i16 (57c4a7ba-e617-4291-94d1-695223b12d14): Loading data parts | ||
337 | 2025.03.07 23:34:16.679945 [ 261 ] {d16728e0-3dbc-47a6-920f-f62ca067ba4d} <Debug> oximeter.measurements_i16 (57c4a7ba-e617-4291-94d1-695223b12d14): There are no data parts | ||
338 | 2025.03.07 23:34:16.680532 [ 261 ] {d16728e0-3dbc-47a6-920f-f62ca067ba4d} <Debug> TCPHandler: Processed in 0.003224466 sec. | ||
339 | 2025.03.07 23:34:16.687017 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
340 | 2025.03.07 23:34:16.687361 [ 261 ] {dd64773c-7981-4758-8aec-dad556644bde} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
341 | 2025.03.07 23:34:16.687454 [ 261 ] {dd64773c-7981-4758-8aec-dad556644bde} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
342 | 2025.03.07 23:34:16.688997 [ 261 ] {dd64773c-7981-4758-8aec-dad556644bde} <Debug> oximeter.measurements_u16 (4ae7dc69-ab6d-45fa-9524-cc8c6d4ba2ea): Loading data parts | ||
343 | 2025.03.07 23:34:16.689259 [ 261 ] {dd64773c-7981-4758-8aec-dad556644bde} <Debug> oximeter.measurements_u16 (4ae7dc69-ab6d-45fa-9524-cc8c6d4ba2ea): There are no data parts | ||
344 | 2025.03.07 23:34:16.689791 [ 261 ] {dd64773c-7981-4758-8aec-dad556644bde} <Debug> TCPHandler: Processed in 0.002970705 sec. | ||
345 | 2025.03.07 23:34:16.700079 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
346 | 2025.03.07 23:34:16.700447 [ 261 ] {654d223c-d32c-49b5-acbf-0309d3df66ea} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
347 | 2025.03.07 23:34:16.700545 [ 261 ] {654d223c-d32c-49b5-acbf-0309d3df66ea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
348 | 2025.03.07 23:34:16.701931 [ 261 ] {654d223c-d32c-49b5-acbf-0309d3df66ea} <Debug> oximeter.measurements_i32 (2266f237-63fd-4757-88c5-0f7157d2301c): Loading data parts | ||
349 | 2025.03.07 23:34:16.702356 [ 261 ] {654d223c-d32c-49b5-acbf-0309d3df66ea} <Debug> oximeter.measurements_i32 (2266f237-63fd-4757-88c5-0f7157d2301c): There are no data parts | ||
350 | 2025.03.07 23:34:16.703168 [ 261 ] {654d223c-d32c-49b5-acbf-0309d3df66ea} <Debug> TCPHandler: Processed in 0.003323193 sec. | ||
351 | 2025.03.07 23:34:16.777129 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
352 | 2025.03.07 23:34:16.777454 [ 261 ] {31a73826-14eb-4a82-a5c3-97871acbeb2b} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
353 | 2025.03.07 23:34:16.777546 [ 261 ] {31a73826-14eb-4a82-a5c3-97871acbeb2b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
354 | 2025.03.07 23:34:16.779165 [ 261 ] {31a73826-14eb-4a82-a5c3-97871acbeb2b} <Debug> oximeter.measurements_u32 (bd54e4c9-ee3f-4707-8236-a49f376115ea): Loading data parts | ||
355 | 2025.03.07 23:34:16.779480 [ 261 ] {31a73826-14eb-4a82-a5c3-97871acbeb2b} <Debug> oximeter.measurements_u32 (bd54e4c9-ee3f-4707-8236-a49f376115ea): There are no data parts | ||
356 | 2025.03.07 23:34:16.780096 [ 261 ] {31a73826-14eb-4a82-a5c3-97871acbeb2b} <Debug> TCPHandler: Processed in 0.00313019 sec. | ||
357 | 2025.03.07 23:34:16.864083 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
358 | 2025.03.07 23:34:16.864537 [ 261 ] {2bf1125c-891f-4df0-a94f-897a5a67567b} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
359 | 2025.03.07 23:34:16.864628 [ 261 ] {2bf1125c-891f-4df0-a94f-897a5a67567b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
360 | 2025.03.07 23:34:16.866129 [ 261 ] {2bf1125c-891f-4df0-a94f-897a5a67567b} <Debug> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Loading data parts | ||
361 | 2025.03.07 23:34:16.866513 [ 261 ] {2bf1125c-891f-4df0-a94f-897a5a67567b} <Debug> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): There are no data parts | ||
362 | 2025.03.07 23:34:16.867127 [ 261 ] {2bf1125c-891f-4df0-a94f-897a5a67567b} <Debug> TCPHandler: Processed in 0.003267308 sec. | ||
363 | 2025.03.07 23:34:16.874490 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
364 | 2025.03.07 23:34:16.877290 [ 261 ] {2224c222-06c0-4207-8cde-cc2e766bfa6a} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
365 | 2025.03.07 23:34:16.877444 [ 261 ] {2224c222-06c0-4207-8cde-cc2e766bfa6a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
366 | 2025.03.07 23:34:16.878981 [ 261 ] {2224c222-06c0-4207-8cde-cc2e766bfa6a} <Debug> oximeter.measurements_u64 (9d556897-ce03-440d-a535-c8789d9962ae): Loading data parts | ||
367 | 2025.03.07 23:34:16.884434 [ 261 ] {2224c222-06c0-4207-8cde-cc2e766bfa6a} <Debug> oximeter.measurements_u64 (9d556897-ce03-440d-a535-c8789d9962ae): There are no data parts | ||
368 | 2025.03.07 23:34:16.885154 [ 261 ] {2224c222-06c0-4207-8cde-cc2e766bfa6a} <Debug> TCPHandler: Processed in 0.01074998 sec. | ||
369 | 2025.03.07 23:34:16.889256 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
370 | 2025.03.07 23:34:16.889569 [ 261 ] {019fbf3c-6e21-4c1e-b68b-f6659106d3d3} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
371 | 2025.03.07 23:34:16.889650 [ 261 ] {019fbf3c-6e21-4c1e-b68b-f6659106d3d3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
372 | 2025.03.07 23:34:16.891153 [ 261 ] {019fbf3c-6e21-4c1e-b68b-f6659106d3d3} <Debug> oximeter.measurements_f32 (c346f57e-6739-488b-8883-e56fa36f9609): Loading data parts | ||
373 | 2025.03.07 23:34:16.891444 [ 261 ] {019fbf3c-6e21-4c1e-b68b-f6659106d3d3} <Debug> oximeter.measurements_f32 (c346f57e-6739-488b-8883-e56fa36f9609): There are no data parts | ||
374 | 2025.03.07 23:34:16.892000 [ 261 ] {019fbf3c-6e21-4c1e-b68b-f6659106d3d3} <Debug> TCPHandler: Processed in 0.002839808 sec. | ||
375 | 2025.03.07 23:34:16.909934 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
376 | 2025.03.07 23:34:16.910270 [ 261 ] {40c3a437-0f9a-49a3-a778-0cdde2ad1401} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_f64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
377 | 2025.03.07 23:34:16.910416 [ 261 ] {40c3a437-0f9a-49a3-a778-0cdde2ad1401} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
378 | 2025.03.07 23:34:16.911879 [ 261 ] {40c3a437-0f9a-49a3-a778-0cdde2ad1401} <Debug> oximeter.measurements_f64 (3a68239d-67a1-4ad4-a86c-69b46811a31b): Loading data parts | ||
379 | 2025.03.07 23:34:16.912155 [ 261 ] {40c3a437-0f9a-49a3-a778-0cdde2ad1401} <Debug> oximeter.measurements_f64 (3a68239d-67a1-4ad4-a86c-69b46811a31b): There are no data parts | ||
380 | 2025.03.07 23:34:16.912685 [ 261 ] {40c3a437-0f9a-49a3-a778-0cdde2ad1401} <Debug> TCPHandler: Processed in 0.0028826 sec. | ||
381 | 2025.03.07 23:34:16.914269 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
382 | 2025.03.07 23:34:16.914560 [ 261 ] {bc5c41d7-ad83-4d6d-8fb8-35e58129a5d6} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_string ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(String) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
383 | 2025.03.07 23:34:16.914622 [ 261 ] {bc5c41d7-ad83-4d6d-8fb8-35e58129a5d6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
384 | 2025.03.07 23:34:16.916260 [ 261 ] {bc5c41d7-ad83-4d6d-8fb8-35e58129a5d6} <Debug> oximeter.measurements_string (defadf49-1c43-4005-a980-a6b91d5e53a5): Loading data parts | ||
385 | 2025.03.07 23:34:16.916551 [ 261 ] {bc5c41d7-ad83-4d6d-8fb8-35e58129a5d6} <Debug> oximeter.measurements_string (defadf49-1c43-4005-a980-a6b91d5e53a5): There are no data parts | ||
386 | 2025.03.07 23:34:16.917355 [ 261 ] {bc5c41d7-ad83-4d6d-8fb8-35e58129a5d6} <Debug> TCPHandler: Processed in 0.003181164 sec. | ||
387 | 2025.03.07 23:34:16.918649 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
388 | 2025.03.07 23:34:16.918909 [ 261 ] {a570ccca-69f9-4633-b7c6-a66d0a444b5e} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
389 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
390 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
391 | * a string isn't palatable for a few reasons. | ||
392 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
393 | * details. | ||
394 | */ | ||
395 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
396 | 2025.03.07 23:34:16.919007 [ 261 ] {a570ccca-69f9-4633-b7c6-a66d0a444b5e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
397 | 2025.03.07 23:34:16.920369 [ 261 ] {a570ccca-69f9-4633-b7c6-a66d0a444b5e} <Debug> oximeter.measurements_bytes (998c800f-5859-40aa-b902-9f452140df54): Loading data parts | ||
398 | 2025.03.07 23:34:16.920691 [ 261 ] {a570ccca-69f9-4633-b7c6-a66d0a444b5e} <Debug> oximeter.measurements_bytes (998c800f-5859-40aa-b902-9f452140df54): There are no data parts | ||
399 | 2025.03.07 23:34:16.921229 [ 261 ] {a570ccca-69f9-4633-b7c6-a66d0a444b5e} <Debug> TCPHandler: Processed in 0.002649924 sec. | ||
400 | 2025.03.07 23:34:16.921533 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
401 | 2025.03.07 23:34:16.921814 [ 261 ] {0280b6fd-5fe1-4e2b-9c5c-3c02e4b7af37} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativei64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
402 | 2025.03.07 23:34:16.921887 [ 261 ] {0280b6fd-5fe1-4e2b-9c5c-3c02e4b7af37} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
403 | 2025.03.07 23:34:16.923109 [ 261 ] {0280b6fd-5fe1-4e2b-9c5c-3c02e4b7af37} <Debug> oximeter.measurements_cumulativei64 (5cdf4b21-8ee4-4b79-bf05-64d8cea56dda): Loading data parts | ||
404 | 2025.03.07 23:34:16.923406 [ 261 ] {0280b6fd-5fe1-4e2b-9c5c-3c02e4b7af37} <Debug> oximeter.measurements_cumulativei64 (5cdf4b21-8ee4-4b79-bf05-64d8cea56dda): There are no data parts | ||
405 | 2025.03.07 23:34:16.924181 [ 261 ] {0280b6fd-5fe1-4e2b-9c5c-3c02e4b7af37} <Debug> TCPHandler: Processed in 0.002722135 sec. | ||
406 | 2025.03.07 23:34:16.924627 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
407 | 2025.03.07 23:34:16.925029 [ 261 ] {28089811-d2c8-4f4e-90d4-5b867a58a6dc} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
408 | 2025.03.07 23:34:16.925109 [ 261 ] {28089811-d2c8-4f4e-90d4-5b867a58a6dc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
409 | 2025.03.07 23:34:16.926540 [ 261 ] {28089811-d2c8-4f4e-90d4-5b867a58a6dc} <Debug> oximeter.measurements_cumulativeu64 (d5ce249d-a67c-48cc-be19-4f99876cff12): Loading data parts | ||
410 | 2025.03.07 23:34:16.926968 [ 261 ] {28089811-d2c8-4f4e-90d4-5b867a58a6dc} <Debug> oximeter.measurements_cumulativeu64 (d5ce249d-a67c-48cc-be19-4f99876cff12): There are no data parts | ||
411 | 2025.03.07 23:34:16.927508 [ 261 ] {28089811-d2c8-4f4e-90d4-5b867a58a6dc} <Debug> TCPHandler: Processed in 0.002957541 sec. | ||
412 | 2025.03.07 23:34:16.927775 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
413 | 2025.03.07 23:34:16.928109 [ 261 ] {b91919a4-ab10-406d-8ee7-f21c8496ee73} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
414 | 2025.03.07 23:34:16.928188 [ 261 ] {b91919a4-ab10-406d-8ee7-f21c8496ee73} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
415 | 2025.03.07 23:34:16.929516 [ 261 ] {b91919a4-ab10-406d-8ee7-f21c8496ee73} <Debug> oximeter.measurements_cumulativef32 (a89947d7-e4a2-4140-98ef-dd0f2ec8a333): Loading data parts | ||
416 | 2025.03.07 23:34:16.929757 [ 261 ] {b91919a4-ab10-406d-8ee7-f21c8496ee73} <Debug> oximeter.measurements_cumulativef32 (a89947d7-e4a2-4140-98ef-dd0f2ec8a333): There are no data parts | ||
417 | 2025.03.07 23:34:16.930322 [ 261 ] {b91919a4-ab10-406d-8ee7-f21c8496ee73} <Debug> TCPHandler: Processed in 0.002614874 sec. | ||
418 | 2025.03.07 23:34:16.930673 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
419 | 2025.03.07 23:34:16.930952 [ 261 ] {92518835-1eac-4c6d-b916-45220732a987} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
420 | 2025.03.07 23:34:16.931038 [ 261 ] {92518835-1eac-4c6d-b916-45220732a987} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
421 | 2025.03.07 23:34:16.932413 [ 261 ] {92518835-1eac-4c6d-b916-45220732a987} <Debug> oximeter.measurements_cumulativef64 (c9a134b7-2791-41b1-b4b4-81cc7ccd3db2): Loading data parts | ||
422 | 2025.03.07 23:34:16.932694 [ 261 ] {92518835-1eac-4c6d-b916-45220732a987} <Debug> oximeter.measurements_cumulativef64 (c9a134b7-2791-41b1-b4b4-81cc7ccd3db2): There are no data parts | ||
423 | 2025.03.07 23:34:16.933244 [ 261 ] {92518835-1eac-4c6d-b916-45220732a987} <Debug> TCPHandler: Processed in 0.002639592 sec. | ||
424 | 2025.03.07 23:34:16.936048 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
425 | 2025.03.07 23:34:16.936755 [ 261 ] {bf591dd1-d993-4e6d-9704-1fcfa5a00b2d} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
426 | * NOTE: Array types cannot be Nullable, see | ||
427 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
428 | * for more details. | ||
429 | * | ||
430 | * This means we need to use empty arrays to indicate a missing value. This | ||
431 | * is unfortunate, and at this point relies on the fact that an | ||
432 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
433 | * to figure out another way to represent missing samples here. | ||
434 | */ | ||
435 | bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
436 | 2025.03.07 23:34:16.936847 [ 261 ] {bf591dd1-d993-4e6d-9704-1fcfa5a00b2d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
437 | 2025.03.07 23:34:16.938942 [ 261 ] {bf591dd1-d993-4e6d-9704-1fcfa5a00b2d} <Debug> oximeter.measurements_histogrami8 (8aedf77e-f25e-4d04-8427-5f19c2627186): Loading data parts | ||
438 | 2025.03.07 23:34:16.939203 [ 261 ] {bf591dd1-d993-4e6d-9704-1fcfa5a00b2d} <Debug> oximeter.measurements_histogrami8 (8aedf77e-f25e-4d04-8427-5f19c2627186): There are no data parts | ||
439 | 2025.03.07 23:34:16.939817 [ 261 ] {bf591dd1-d993-4e6d-9704-1fcfa5a00b2d} <Debug> TCPHandler: Processed in 0.003901145 sec. | ||
440 | 2025.03.07 23:34:16.940103 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
441 | 2025.03.07 23:34:16.940553 [ 261 ] {035c2381-8009-4130-9178-b78e28a1c717} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
442 | 2025.03.07 23:34:16.940647 [ 261 ] {035c2381-8009-4130-9178-b78e28a1c717} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
443 | 2025.03.07 23:34:16.942463 [ 261 ] {035c2381-8009-4130-9178-b78e28a1c717} <Debug> oximeter.measurements_histogramu8 (881dd2f4-cc2a-491b-8a41-0528b98c0f30): Loading data parts | ||
444 | 2025.03.07 23:34:16.942747 [ 261 ] {035c2381-8009-4130-9178-b78e28a1c717} <Debug> oximeter.measurements_histogramu8 (881dd2f4-cc2a-491b-8a41-0528b98c0f30): There are no data parts | ||
445 | 2025.03.07 23:34:16.943321 [ 261 ] {035c2381-8009-4130-9178-b78e28a1c717} <Debug> TCPHandler: Processed in 0.003301748 sec. | ||
446 | 2025.03.07 23:34:16.943725 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
447 | 2025.03.07 23:34:16.944206 [ 261 ] {4235b7bb-0aad-4cc2-93e1-17e25ff4de3b} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
448 | 2025.03.07 23:34:16.944308 [ 261 ] {4235b7bb-0aad-4cc2-93e1-17e25ff4de3b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
449 | 2025.03.07 23:34:16.946302 [ 261 ] {4235b7bb-0aad-4cc2-93e1-17e25ff4de3b} <Debug> oximeter.measurements_histogrami16 (82fc673a-b3b0-4ff2-917a-59043ed4fd2a): Loading data parts | ||
450 | 2025.03.07 23:34:16.946599 [ 261 ] {4235b7bb-0aad-4cc2-93e1-17e25ff4de3b} <Debug> oximeter.measurements_histogrami16 (82fc673a-b3b0-4ff2-917a-59043ed4fd2a): There are no data parts | ||
451 | 2025.03.07 23:34:16.947359 [ 261 ] {4235b7bb-0aad-4cc2-93e1-17e25ff4de3b} <Debug> TCPHandler: Processed in 0.003816962 sec. | ||
452 | 2025.03.07 23:34:16.948597 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
453 | 2025.03.07 23:34:16.949010 [ 261 ] {fb66ff40-0c6d-46fa-af95-b85c6ebe0591} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
454 | 2025.03.07 23:34:16.949104 [ 261 ] {fb66ff40-0c6d-46fa-af95-b85c6ebe0591} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
455 | 2025.03.07 23:34:16.951462 [ 261 ] {fb66ff40-0c6d-46fa-af95-b85c6ebe0591} <Debug> oximeter.measurements_histogramu16 (58df9d08-a229-428f-902d-9adaf2399773): Loading data parts | ||
456 | 2025.03.07 23:34:16.951767 [ 261 ] {fb66ff40-0c6d-46fa-af95-b85c6ebe0591} <Debug> oximeter.measurements_histogramu16 (58df9d08-a229-428f-902d-9adaf2399773): There are no data parts | ||
457 | 2025.03.07 23:34:16.952662 [ 261 ] {fb66ff40-0c6d-46fa-af95-b85c6ebe0591} <Debug> TCPHandler: Processed in 0.004175653 sec. | ||
458 | 2025.03.07 23:34:16.953290 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
459 | 2025.03.07 23:34:16.953794 [ 261 ] {93dbf3f7-a663-4f8a-ac02-0aca0e440050} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
460 | 2025.03.07 23:34:16.953942 [ 261 ] {93dbf3f7-a663-4f8a-ac02-0aca0e440050} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
461 | 2025.03.07 23:34:16.956033 [ 261 ] {93dbf3f7-a663-4f8a-ac02-0aca0e440050} <Debug> oximeter.measurements_histogrami32 (1585fbc0-3ebb-4fb3-9282-ce63742931d5): Loading data parts | ||
462 | 2025.03.07 23:34:16.956296 [ 261 ] {93dbf3f7-a663-4f8a-ac02-0aca0e440050} <Debug> oximeter.measurements_histogrami32 (1585fbc0-3ebb-4fb3-9282-ce63742931d5): There are no data parts | ||
463 | 2025.03.07 23:34:16.956927 [ 261 ] {93dbf3f7-a663-4f8a-ac02-0aca0e440050} <Debug> TCPHandler: Processed in 0.003761167 sec. | ||
464 | 2025.03.07 23:34:16.958144 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
465 | 2025.03.07 23:34:16.958683 [ 261 ] {f9f4de56-f019-47d9-a1d6-c86f6f90bb9e} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
466 | 2025.03.07 23:34:16.959134 [ 261 ] {f9f4de56-f019-47d9-a1d6-c86f6f90bb9e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
467 | 2025.03.07 23:34:16.961728 [ 261 ] {f9f4de56-f019-47d9-a1d6-c86f6f90bb9e} <Debug> oximeter.measurements_histogramu32 (816e3eb1-f306-4d2c-9a59-8c51b38eac07): Loading data parts | ||
468 | 2025.03.07 23:34:16.961984 [ 261 ] {f9f4de56-f019-47d9-a1d6-c86f6f90bb9e} <Debug> oximeter.measurements_histogramu32 (816e3eb1-f306-4d2c-9a59-8c51b38eac07): There are no data parts | ||
469 | 2025.03.07 23:34:16.963123 [ 261 ] {f9f4de56-f019-47d9-a1d6-c86f6f90bb9e} <Debug> TCPHandler: Processed in 0.004725498 sec. | ||
470 | 2025.03.07 23:34:16.964889 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
471 | 2025.03.07 23:34:16.965358 [ 261 ] {e2c2fdca-51de-4f5f-ae54-cd3870bb69be} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
472 | 2025.03.07 23:34:16.965486 [ 261 ] {e2c2fdca-51de-4f5f-ae54-cd3870bb69be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
473 | 2025.03.07 23:34:16.967989 [ 261 ] {e2c2fdca-51de-4f5f-ae54-cd3870bb69be} <Debug> oximeter.measurements_histogrami64 (2a6c0dcb-6e8a-43a1-be51-60b9928332d8): Loading data parts | ||
474 | 2025.03.07 23:34:16.968554 [ 261 ] {e2c2fdca-51de-4f5f-ae54-cd3870bb69be} <Debug> oximeter.measurements_histogrami64 (2a6c0dcb-6e8a-43a1-be51-60b9928332d8): There are no data parts | ||
475 | 2025.03.07 23:34:16.969334 [ 261 ] {e2c2fdca-51de-4f5f-ae54-cd3870bb69be} <Debug> TCPHandler: Processed in 0.004602233 sec. | ||
476 | 2025.03.07 23:34:16.970304 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
477 | 2025.03.07 23:34:16.971006 [ 261 ] {05ff32a5-f8bb-4923-8580-da8ff1959998} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
478 | 2025.03.07 23:34:16.971112 [ 261 ] {05ff32a5-f8bb-4923-8580-da8ff1959998} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
479 | 2025.03.07 23:34:16.974588 [ 261 ] {05ff32a5-f8bb-4923-8580-da8ff1959998} <Debug> oximeter.measurements_histogramu64 (e98dab7c-ecc8-4823-978b-5000d78c021e): Loading data parts | ||
480 | 2025.03.07 23:34:16.975251 [ 261 ] {05ff32a5-f8bb-4923-8580-da8ff1959998} <Debug> oximeter.measurements_histogramu64 (e98dab7c-ecc8-4823-978b-5000d78c021e): There are no data parts | ||
481 | 2025.03.07 23:34:16.976259 [ 261 ] {05ff32a5-f8bb-4923-8580-da8ff1959998} <Debug> TCPHandler: Processed in 0.006122991 sec. | ||
482 | 2025.03.07 23:34:16.979298 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
483 | 2025.03.07 23:34:16.979802 [ 261 ] {6d1a23f8-1132-418b-bacb-99a09f38737e} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
484 | 2025.03.07 23:34:16.979916 [ 261 ] {6d1a23f8-1132-418b-bacb-99a09f38737e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
485 | 2025.03.07 23:34:16.981932 [ 261 ] {6d1a23f8-1132-418b-bacb-99a09f38737e} <Debug> oximeter.measurements_histogramf32 (1ddd4476-9ca3-4d09-a43c-7cbe08c9a7e3): Loading data parts | ||
486 | 2025.03.07 23:34:16.983231 [ 261 ] {6d1a23f8-1132-418b-bacb-99a09f38737e} <Debug> oximeter.measurements_histogramf32 (1ddd4476-9ca3-4d09-a43c-7cbe08c9a7e3): There are no data parts | ||
487 | 2025.03.07 23:34:16.983930 [ 261 ] {6d1a23f8-1132-418b-bacb-99a09f38737e} <Debug> TCPHandler: Processed in 0.00480628 sec. | ||
488 | 2025.03.07 23:34:16.984326 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
489 | 2025.03.07 23:34:16.984769 [ 261 ] {28777d67-a344-4b0f-959e-2300d1cb104d} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
490 | 2025.03.07 23:34:16.984865 [ 261 ] {28777d67-a344-4b0f-959e-2300d1cb104d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
491 | 2025.03.07 23:34:16.986819 [ 261 ] {28777d67-a344-4b0f-959e-2300d1cb104d} <Debug> oximeter.measurements_histogramf64 (d6e50076-06e5-41ed-8570-ae08d16f49de): Loading data parts | ||
492 | 2025.03.07 23:34:16.987195 [ 261 ] {28777d67-a344-4b0f-959e-2300d1cb104d} <Debug> oximeter.measurements_histogramf64 (d6e50076-06e5-41ed-8570-ae08d16f49de): There are no data parts | ||
493 | 2025.03.07 23:34:16.987958 [ 261 ] {28777d67-a344-4b0f-959e-2300d1cb104d} <Debug> TCPHandler: Processed in 0.003752964 sec. | ||
494 | 2025.03.07 23:34:16.988413 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
495 | 2025.03.07 23:34:16.988716 [ 261 ] {09a170f5-b3e1-4850-a3cc-38b65bf80b97} <Debug> executeQuery: (from [::1]:36135) /* The field tables store named dimensions of each timeseries. | ||
496 | * | ||
497 | * As with the measurement tables, there is one field table for each field data | ||
498 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
499 | * this behavior **must not** be relied upon for query correctness. | ||
500 | * | ||
501 | * The index for the fields differs from the measurements, however. Rows are | ||
502 | * sorted by timeseries name, then field name, field value, and finally | ||
503 | * timeseries key. This reflects the most common pattern for looking them up: | ||
504 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
505 | * usually then used to look up measurements. | ||
506 | * | ||
507 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
508 | * timeseries name and then key, since it would improve lookups where one | ||
509 | * already has the key. Realistically though, these tables are quite small and | ||
510 | * so performance benefits will be low in absolute terms. | ||
511 | * | ||
512 | * TTL: We use a materialized column to expire old field table records. This | ||
513 | * column is generated automatically by the database whenever a new row is | ||
514 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
515 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
516 | * record will remain during a deduplication, which will have the last | ||
517 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
518 | * measurement tables. | ||
519 | */ | ||
520 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
521 | 2025.03.07 23:34:16.988920 [ 261 ] {09a170f5-b3e1-4850-a3cc-38b65bf80b97} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
522 | 2025.03.07 23:34:16.990556 [ 261 ] {09a170f5-b3e1-4850-a3cc-38b65bf80b97} <Debug> oximeter.fields_bool (119aa4dc-aa42-4c4c-903b-fc01f6dfec89): Loading data parts | ||
523 | 2025.03.07 23:34:16.990949 [ 261 ] {09a170f5-b3e1-4850-a3cc-38b65bf80b97} <Debug> oximeter.fields_bool (119aa4dc-aa42-4c4c-903b-fc01f6dfec89): There are no data parts | ||
524 | 2025.03.07 23:34:16.991771 [ 261 ] {09a170f5-b3e1-4850-a3cc-38b65bf80b97} <Debug> TCPHandler: Processed in 0.00345461 sec. | ||
525 | 2025.03.07 23:34:16.992168 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
526 | 2025.03.07 23:34:16.992510 [ 261 ] {04d6c9f0-03c7-4684-8ac0-eaaa02c4ba68} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
527 | 2025.03.07 23:34:16.992593 [ 261 ] {04d6c9f0-03c7-4684-8ac0-eaaa02c4ba68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
528 | 2025.03.07 23:34:16.994506 [ 261 ] {04d6c9f0-03c7-4684-8ac0-eaaa02c4ba68} <Debug> oximeter.fields_i8 (19129464-fe2d-4667-b7d3-4a77912a6522): Loading data parts | ||
529 | 2025.03.07 23:34:16.994843 [ 261 ] {04d6c9f0-03c7-4684-8ac0-eaaa02c4ba68} <Debug> oximeter.fields_i8 (19129464-fe2d-4667-b7d3-4a77912a6522): There are no data parts | ||
530 | 2025.03.07 23:34:16.995613 [ 261 ] {04d6c9f0-03c7-4684-8ac0-eaaa02c4ba68} <Debug> TCPHandler: Processed in 0.003536614 sec. | ||
531 | 2025.03.07 23:34:17.081249 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
532 | 2025.03.07 23:34:17.081966 [ 261 ] {c4959afa-1162-4f80-acf1-6c298fc75b82} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
533 | 2025.03.07 23:34:17.082170 [ 261 ] {c4959afa-1162-4f80-acf1-6c298fc75b82} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
534 | 2025.03.07 23:34:17.085169 [ 261 ] {c4959afa-1162-4f80-acf1-6c298fc75b82} <Debug> oximeter.fields_u8 (5044ecaa-f72c-4916-9ce5-79ac09e6ee30): Loading data parts | ||
535 | 2025.03.07 23:34:17.085497 [ 261 ] {c4959afa-1162-4f80-acf1-6c298fc75b82} <Debug> oximeter.fields_u8 (5044ecaa-f72c-4916-9ce5-79ac09e6ee30): There are no data parts | ||
536 | 2025.03.07 23:34:17.086588 [ 261 ] {c4959afa-1162-4f80-acf1-6c298fc75b82} <Debug> TCPHandler: Processed in 0.005630671 sec. | ||
537 | 2025.03.07 23:34:17.087322 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
538 | 2025.03.07 23:34:17.087642 [ 261 ] {9258b8a1-f16b-4d31-90bd-22cb1090f0ab} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
539 | 2025.03.07 23:34:17.087737 [ 261 ] {9258b8a1-f16b-4d31-90bd-22cb1090f0ab} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
540 | 2025.03.07 23:34:17.090428 [ 261 ] {9258b8a1-f16b-4d31-90bd-22cb1090f0ab} <Debug> oximeter.fields_i16 (2bbd7f0e-8a82-43c3-838c-ae8d1cab733e): Loading data parts | ||
541 | 2025.03.07 23:34:17.090750 [ 261 ] {9258b8a1-f16b-4d31-90bd-22cb1090f0ab} <Debug> oximeter.fields_i16 (2bbd7f0e-8a82-43c3-838c-ae8d1cab733e): There are no data parts | ||
542 | 2025.03.07 23:34:17.091389 [ 261 ] {9258b8a1-f16b-4d31-90bd-22cb1090f0ab} <Debug> TCPHandler: Processed in 0.004198799 sec. | ||
543 | 2025.03.07 23:34:17.091913 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
544 | 2025.03.07 23:34:17.092246 [ 261 ] {cd7507bc-9c18-48f3-b4a4-8261ed18d183} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
545 | 2025.03.07 23:34:17.092327 [ 261 ] {cd7507bc-9c18-48f3-b4a4-8261ed18d183} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
546 | 2025.03.07 23:34:17.094336 [ 261 ] {cd7507bc-9c18-48f3-b4a4-8261ed18d183} <Debug> oximeter.fields_u16 (816f0f49-3b68-4861-bcc4-ce7b46de3bbf): Loading data parts | ||
547 | 2025.03.07 23:34:17.094643 [ 261 ] {cd7507bc-9c18-48f3-b4a4-8261ed18d183} <Debug> oximeter.fields_u16 (816f0f49-3b68-4861-bcc4-ce7b46de3bbf): There are no data parts | ||
548 | 2025.03.07 23:34:17.095241 [ 261 ] {cd7507bc-9c18-48f3-b4a4-8261ed18d183} <Debug> TCPHandler: Processed in 0.00345398 sec. | ||
549 | 2025.03.07 23:34:17.095800 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
550 | 2025.03.07 23:34:17.096138 [ 261 ] {32c1fbd2-f06b-4be8-a8c1-c4cb6cbfe53a} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
551 | 2025.03.07 23:34:17.096247 [ 261 ] {32c1fbd2-f06b-4be8-a8c1-c4cb6cbfe53a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
552 | 2025.03.07 23:34:17.099048 [ 261 ] {32c1fbd2-f06b-4be8-a8c1-c4cb6cbfe53a} <Debug> oximeter.fields_i32 (fd8fe73c-9e04-4c34-a5b4-1357988df643): Loading data parts | ||
553 | 2025.03.07 23:34:17.099400 [ 261 ] {32c1fbd2-f06b-4be8-a8c1-c4cb6cbfe53a} <Debug> oximeter.fields_i32 (fd8fe73c-9e04-4c34-a5b4-1357988df643): There are no data parts | ||
554 | 2025.03.07 23:34:17.100090 [ 261 ] {32c1fbd2-f06b-4be8-a8c1-c4cb6cbfe53a} <Debug> TCPHandler: Processed in 0.004393084 sec. | ||
555 | 2025.03.07 23:34:17.100581 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
556 | 2025.03.07 23:34:17.100904 [ 261 ] {18dd6fd4-3a4c-464b-888e-f35170b44a9c} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
557 | 2025.03.07 23:34:17.101024 [ 261 ] {18dd6fd4-3a4c-464b-888e-f35170b44a9c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
558 | 2025.03.07 23:34:17.102450 [ 261 ] {18dd6fd4-3a4c-464b-888e-f35170b44a9c} <Debug> oximeter.fields_u32 (a2d48e8e-abfb-49eb-ac47-1cf54a0fabbc): Loading data parts | ||
559 | 2025.03.07 23:34:17.102705 [ 261 ] {18dd6fd4-3a4c-464b-888e-f35170b44a9c} <Debug> oximeter.fields_u32 (a2d48e8e-abfb-49eb-ac47-1cf54a0fabbc): There are no data parts | ||
560 | 2025.03.07 23:34:17.103645 [ 261 ] {18dd6fd4-3a4c-464b-888e-f35170b44a9c} <Debug> TCPHandler: Processed in 0.003173332 sec. | ||
561 | 2025.03.07 23:34:17.104240 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
562 | 2025.03.07 23:34:17.104687 [ 261 ] {eb30799b-684b-4715-95d2-82f646abc69b} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
563 | 2025.03.07 23:34:17.104824 [ 261 ] {eb30799b-684b-4715-95d2-82f646abc69b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
564 | 2025.03.07 23:34:17.106465 [ 261 ] {eb30799b-684b-4715-95d2-82f646abc69b} <Debug> oximeter.fields_i64 (aab70a40-6ffb-485c-b0e6-c2293cb3d747): Loading data parts | ||
565 | 2025.03.07 23:34:17.106723 [ 261 ] {eb30799b-684b-4715-95d2-82f646abc69b} <Debug> oximeter.fields_i64 (aab70a40-6ffb-485c-b0e6-c2293cb3d747): There are no data parts | ||
566 | 2025.03.07 23:34:17.107261 [ 261 ] {eb30799b-684b-4715-95d2-82f646abc69b} <Debug> TCPHandler: Processed in 0.003121396 sec. | ||
567 | 2025.03.07 23:34:17.107845 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
568 | 2025.03.07 23:34:17.108486 [ 261 ] {62138c8a-cde3-4d4e-a54b-461cdd9a2bd7} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
569 | 2025.03.07 23:34:17.108577 [ 261 ] {62138c8a-cde3-4d4e-a54b-461cdd9a2bd7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
570 | 2025.03.07 23:34:17.110133 [ 261 ] {62138c8a-cde3-4d4e-a54b-461cdd9a2bd7} <Debug> oximeter.fields_u64 (ec43b259-7796-494a-9cf3-05aa2c6c1ca1): Loading data parts | ||
571 | 2025.03.07 23:34:17.110560 [ 261 ] {62138c8a-cde3-4d4e-a54b-461cdd9a2bd7} <Debug> oximeter.fields_u64 (ec43b259-7796-494a-9cf3-05aa2c6c1ca1): There are no data parts | ||
572 | 2025.03.07 23:34:17.111247 [ 261 ] {62138c8a-cde3-4d4e-a54b-461cdd9a2bd7} <Debug> TCPHandler: Processed in 0.003551227 sec. | ||
573 | 2025.03.07 23:34:17.111636 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
574 | 2025.03.07 23:34:17.111956 [ 261 ] {8a8a2a75-2498-41fe-8d7f-77a58809f193} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
575 | 2025.03.07 23:34:17.112042 [ 261 ] {8a8a2a75-2498-41fe-8d7f-77a58809f193} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
576 | 2025.03.07 23:34:17.114040 [ 261 ] {8a8a2a75-2498-41fe-8d7f-77a58809f193} <Debug> oximeter.fields_ipaddr (cc14634c-ab6c-4744-af7c-a128db20193a): Loading data parts | ||
577 | 2025.03.07 23:34:17.114333 [ 261 ] {8a8a2a75-2498-41fe-8d7f-77a58809f193} <Debug> oximeter.fields_ipaddr (cc14634c-ab6c-4744-af7c-a128db20193a): There are no data parts | ||
578 | 2025.03.07 23:34:17.114985 [ 261 ] {8a8a2a75-2498-41fe-8d7f-77a58809f193} <Debug> TCPHandler: Processed in 0.003459901 sec. | ||
579 | 2025.03.07 23:34:17.115428 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
580 | 2025.03.07 23:34:17.115783 [ 261 ] {b8b5903a-bcd3-4983-b0af-d6cf290ca008} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
581 | 2025.03.07 23:34:17.115873 [ 261 ] {b8b5903a-bcd3-4983-b0af-d6cf290ca008} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
582 | 2025.03.07 23:34:17.117590 [ 261 ] {b8b5903a-bcd3-4983-b0af-d6cf290ca008} <Debug> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Loading data parts | ||
583 | 2025.03.07 23:34:17.117905 [ 261 ] {b8b5903a-bcd3-4983-b0af-d6cf290ca008} <Debug> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): There are no data parts | ||
584 | 2025.03.07 23:34:17.118686 [ 261 ] {b8b5903a-bcd3-4983-b0af-d6cf290ca008} <Debug> TCPHandler: Processed in 0.003407407 sec. | ||
585 | 2025.03.07 23:34:17.119135 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
586 | 2025.03.07 23:34:17.119442 [ 261 ] {cd2e4da0-24db-4c73-bc8c-32f57e630dda} <Debug> executeQuery: (from [::1]:36135) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
587 | 2025.03.07 23:34:17.119555 [ 261 ] {cd2e4da0-24db-4c73-bc8c-32f57e630dda} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
588 | 2025.03.07 23:34:17.121027 [ 261 ] {cd2e4da0-24db-4c73-bc8c-32f57e630dda} <Debug> oximeter.fields_uuid (b14a443f-7c1a-4db5-b7d4-23205db5d9d0): Loading data parts | ||
589 | 2025.03.07 23:34:17.121304 [ 261 ] {cd2e4da0-24db-4c73-bc8c-32f57e630dda} <Debug> oximeter.fields_uuid (b14a443f-7c1a-4db5-b7d4-23205db5d9d0): There are no data parts | ||
590 | 2025.03.07 23:34:17.122024 [ 261 ] {cd2e4da0-24db-4c73-bc8c-32f57e630dda} <Debug> TCPHandler: Processed in 0.002906906 sec. | ||
591 | 2025.03.07 23:34:17.122959 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
592 | 2025.03.07 23:34:17.123352 [ 261 ] {53f31ffd-64ad-4fc5-b91f-b18eac8854ef} <Debug> executeQuery: (from [::1]:36135) /* The timeseries schema table stores the extracted schema for the samples | ||
593 | * oximeter collects. | ||
594 | */ | ||
595 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
596 | 2025.03.07 23:34:17.123460 [ 261 ] {53f31ffd-64ad-4fc5-b91f-b18eac8854ef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
597 | 2025.03.07 23:34:17.124827 [ 261 ] {53f31ffd-64ad-4fc5-b91f-b18eac8854ef} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944): Loading data parts | ||
598 | 2025.03.07 23:34:17.125109 [ 261 ] {53f31ffd-64ad-4fc5-b91f-b18eac8854ef} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944): There are no data parts | ||
599 | 2025.03.07 23:34:17.125746 [ 261 ] {53f31ffd-64ad-4fc5-b91f-b18eac8854ef} <Debug> TCPHandler: Processed in 0.002903516 sec. | ||
600 | 2025.03.07 23:34:17.128041 [ 262 ] {} <Trace> TCP-Session: 287610ca-b0f5-4f4c-b6e1-931b66c54528 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
601 | 2025.03.07 23:34:17.128428 [ 262 ] {eb46ab41-ee3e-43ca-a443-915187e0908a} <Debug> executeQuery: (from [::1]:36277) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
602 | 2025.03.07 23:34:17.128588 [ 262 ] {eb46ab41-ee3e-43ca-a443-915187e0908a} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
603 | 2025.03.07 23:34:17.130044 [ 260 ] {eb46ab41-ee3e-43ca-a443-915187e0908a} <Trace> oximeter.version (4d7b09ee-4b36-4ac3-9c03-0596e4f8d75a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
604 | 2025.03.07 23:34:17.130115 [ 260 ] {eb46ab41-ee3e-43ca-a443-915187e0908a} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
605 | 2025.03.07 23:34:17.130740 [ 260 ] {eb46ab41-ee3e-43ca-a443-915187e0908a} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
606 | 2025.03.07 23:34:17.131130 [ 260 ] {eb46ab41-ee3e-43ca-a443-915187e0908a} <Trace> oximeter.version (4d7b09ee-4b36-4ac3-9c03-0596e4f8d75a): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
607 | 2025.03.07 23:34:17.131394 [ 262 ] {eb46ab41-ee3e-43ca-a443-915187e0908a} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003106 sec., 321.9575016097875 rows/sec., 5.03 KiB/sec. | ||
608 | 2025.03.07 23:34:17.131608 [ 262 ] {eb46ab41-ee3e-43ca-a443-915187e0908a} <Debug> TCPHandler: Processed in 0.003710382 sec. | ||
609 | 2025.03.07 23:34:19.591396 [ 237 ] {} <Debug> DNSResolver: Updating DNS cache | ||
610 | 2025.03.07 23:34:19.591453 [ 237 ] {} <Debug> DNSResolver: Updated DNS cache | ||
611 | 2025.03.07 23:34:19.712094 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 427 entries to flush up to offset 976 | ||
612 | 2025.03.07 23:34:19.713318 [ 244 ] {} <Trace> system.asynchronous_metric_log (21d2aba1-0395-4f26-8a83-239f2cf92f88): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
613 | 2025.03.07 23:34:19.713368 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
614 | 2025.03.07 23:34:19.714414 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
615 | 2025.03.07 23:34:19.714838 [ 244 ] {} <Trace> system.asynchronous_metric_log (21d2aba1-0395-4f26-8a83-239f2cf92f88): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
616 | 2025.03.07 23:34:19.715109 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 976 | ||
617 | 2025.03.07 23:34:19.781187 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16 | ||
618 | 2025.03.07 23:34:19.818913 [ 245 ] {} <Trace> system.metric_log (a8177820-099d-4483-b768-aa36523de9da): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
619 | 2025.03.07 23:34:19.818997 [ 245 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
620 | 2025.03.07 23:34:19.829973 [ 245 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
621 | 2025.03.07 23:34:19.831725 [ 245 ] {} <Trace> system.metric_log (a8177820-099d-4483-b768-aa36523de9da): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
622 | 2025.03.07 23:34:19.837965 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 16 | ||
623 | 2025.03.07 23:34:20.000868 [ 249 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 147.47 MiB, peak 151.47 MiB, free memory in arenas 0.00 B, will set to 152.80 MiB (RSS), difference: 5.33 MiB | ||
624 | 2025.03.07 23:34:22.141203 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
625 | 2025.03.07 23:34:22.141474 [ 261 ] {8d50e65d-a689-43f4-af1b-d54ccff6dfbe} <Debug> executeQuery: (from [::1]:36135) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
626 | 2025.03.07 23:34:22.142010 [ 261 ] {8d50e65d-a689-43f4-af1b-d54ccff6dfbe} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
627 | 2025.03.07 23:34:22.142179 [ 261 ] {8d50e65d-a689-43f4-af1b-d54ccff6dfbe} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
628 | 2025.03.07 23:34:22.143059 [ 261 ] {8d50e65d-a689-43f4-af1b-d54ccff6dfbe} <Debug> TCPHandler: Processed in 0.002081064 sec. | ||
629 | 2025.03.07 23:34:22.147190 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
630 | 2025.03.07 23:34:22.147429 [ 261 ] {7685d8e2-d043-47b4-9ad9-5469ea9f9ed4} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
631 | 2025.03.07 23:34:22.147530 [ 261 ] {7685d8e2-d043-47b4-9ad9-5469ea9f9ed4} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
632 | 2025.03.07 23:34:22.154591 [ 261 ] {7685d8e2-d043-47b4-9ad9-5469ea9f9ed4} <Trace> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
633 | 2025.03.07 23:34:22.154673 [ 261 ] {7685d8e2-d043-47b4-9ad9-5469ea9f9ed4} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
634 | 2025.03.07 23:34:22.155697 [ 261 ] {7685d8e2-d043-47b4-9ad9-5469ea9f9ed4} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
635 | 2025.03.07 23:34:22.156139 [ 261 ] {7685d8e2-d043-47b4-9ad9-5469ea9f9ed4} <Trace> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
636 | 2025.03.07 23:34:22.156489 [ 261 ] {7685d8e2-d043-47b4-9ad9-5469ea9f9ed4} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.009123 sec., 109.6130658774526 rows/sec., 13.17 KiB/sec. | ||
637 | 2025.03.07 23:34:22.156612 [ 261 ] {7685d8e2-d043-47b4-9ad9-5469ea9f9ed4} <Debug> TCPHandler: Processed in 0.009601978 sec. | ||
638 | 2025.03.07 23:34:22.165185 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
639 | 2025.03.07 23:34:22.165414 [ 261 ] {8194fa01-f0f9-4568-a904-fc8a27264d8e} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
640 | 2025.03.07 23:34:22.165577 [ 261 ] {8194fa01-f0f9-4568-a904-fc8a27264d8e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
641 | 2025.03.07 23:34:22.167690 [ 261 ] {8194fa01-f0f9-4568-a904-fc8a27264d8e} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
642 | 2025.03.07 23:34:22.167766 [ 261 ] {8194fa01-f0f9-4568-a904-fc8a27264d8e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
643 | 2025.03.07 23:34:22.168380 [ 261 ] {8194fa01-f0f9-4568-a904-fc8a27264d8e} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
644 | 2025.03.07 23:34:22.168744 [ 261 ] {8194fa01-f0f9-4568-a904-fc8a27264d8e} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
645 | 2025.03.07 23:34:22.169057 [ 261 ] {8194fa01-f0f9-4568-a904-fc8a27264d8e} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003715 sec., 538.3580080753701 rows/sec., 55.73 KiB/sec. | ||
646 | 2025.03.07 23:34:22.169128 [ 261 ] {8194fa01-f0f9-4568-a904-fc8a27264d8e} <Debug> TCPHandler: Processed in 0.004145605 sec. | ||
647 | 2025.03.07 23:34:22.169994 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
648 | 2025.03.07 23:34:22.170176 [ 261 ] {2b96c006-d9c2-4f8b-b343-08edcdc0c7ed} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
649 | 2025.03.07 23:34:22.170305 [ 261 ] {2b96c006-d9c2-4f8b-b343-08edcdc0c7ed} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
650 | 2025.03.07 23:34:22.171131 [ 261 ] {2b96c006-d9c2-4f8b-b343-08edcdc0c7ed} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
651 | 2025.03.07 23:34:22.171271 [ 261 ] {2b96c006-d9c2-4f8b-b343-08edcdc0c7ed} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
652 | 2025.03.07 23:34:22.171956 [ 261 ] {2b96c006-d9c2-4f8b-b343-08edcdc0c7ed} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
653 | 2025.03.07 23:34:22.172379 [ 261 ] {2b96c006-d9c2-4f8b-b343-08edcdc0c7ed} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
654 | 2025.03.07 23:34:22.172627 [ 261 ] {2b96c006-d9c2-4f8b-b343-08edcdc0c7ed} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002492 sec., 401.2841091492777 rows/sec., 27.82 KiB/sec. | ||
655 | 2025.03.07 23:34:22.172693 [ 261 ] {2b96c006-d9c2-4f8b-b343-08edcdc0c7ed} <Debug> TCPHandler: Processed in 0.002800377 sec. | ||
656 | 2025.03.07 23:34:23.141889 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
657 | 2025.03.07 23:34:23.142416 [ 261 ] {31886cc4-d714-47fe-81c8-f3c3e7235b99} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
658 | 2025.03.07 23:34:23.142526 [ 261 ] {31886cc4-d714-47fe-81c8-f3c3e7235b99} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
659 | 2025.03.07 23:34:23.146563 [ 261 ] {31886cc4-d714-47fe-81c8-f3c3e7235b99} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
660 | 2025.03.07 23:34:23.146618 [ 261 ] {31886cc4-d714-47fe-81c8-f3c3e7235b99} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
661 | 2025.03.07 23:34:23.147263 [ 261 ] {31886cc4-d714-47fe-81c8-f3c3e7235b99} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
662 | 2025.03.07 23:34:23.147652 [ 261 ] {31886cc4-d714-47fe-81c8-f3c3e7235b99} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
663 | 2025.03.07 23:34:23.147922 [ 261 ] {31886cc4-d714-47fe-81c8-f3c3e7235b99} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.005822 sec., 343.52456200618343 rows/sec., 35.56 KiB/sec. | ||
664 | 2025.03.07 23:34:23.148058 [ 261 ] {31886cc4-d714-47fe-81c8-f3c3e7235b99} <Debug> TCPHandler: Processed in 0.006383193 sec. | ||
665 | 2025.03.07 23:34:23.155907 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
666 | 2025.03.07 23:34:23.156120 [ 261 ] {3b6fd084-2cc8-4bad-9065-aa801303cffd} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
667 | 2025.03.07 23:34:23.156232 [ 261 ] {3b6fd084-2cc8-4bad-9065-aa801303cffd} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
668 | 2025.03.07 23:34:23.157627 [ 261 ] {3b6fd084-2cc8-4bad-9065-aa801303cffd} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
669 | 2025.03.07 23:34:23.157700 [ 261 ] {3b6fd084-2cc8-4bad-9065-aa801303cffd} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
670 | 2025.03.07 23:34:23.158345 [ 261 ] {3b6fd084-2cc8-4bad-9065-aa801303cffd} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
671 | 2025.03.07 23:34:23.158984 [ 261 ] {3b6fd084-2cc8-4bad-9065-aa801303cffd} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
672 | 2025.03.07 23:34:23.159270 [ 261 ] {3b6fd084-2cc8-4bad-9065-aa801303cffd} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003216 sec., 310.9452736318408 rows/sec., 21.56 KiB/sec. | ||
673 | 2025.03.07 23:34:23.159348 [ 261 ] {3b6fd084-2cc8-4bad-9065-aa801303cffd} <Debug> TCPHandler: Processed in 0.003852573 sec. | ||
674 | 2025.03.07 23:34:24.140210 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
675 | 2025.03.07 23:34:24.140424 [ 261 ] {b1348fa7-c3c5-44a2-b11f-13510aa7ed55} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
676 | 2025.03.07 23:34:24.140497 [ 261 ] {b1348fa7-c3c5-44a2-b11f-13510aa7ed55} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
677 | 2025.03.07 23:34:24.141730 [ 261 ] {b1348fa7-c3c5-44a2-b11f-13510aa7ed55} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
678 | 2025.03.07 23:34:24.141779 [ 261 ] {b1348fa7-c3c5-44a2-b11f-13510aa7ed55} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
679 | 2025.03.07 23:34:24.142253 [ 261 ] {b1348fa7-c3c5-44a2-b11f-13510aa7ed55} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
680 | 2025.03.07 23:34:24.142555 [ 261 ] {b1348fa7-c3c5-44a2-b11f-13510aa7ed55} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
681 | 2025.03.07 23:34:24.142772 [ 261 ] {b1348fa7-c3c5-44a2-b11f-13510aa7ed55} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002403 sec., 832.2929671244277 rows/sec., 86.16 KiB/sec. | ||
682 | 2025.03.07 23:34:24.142832 [ 261 ] {b1348fa7-c3c5-44a2-b11f-13510aa7ed55} <Debug> TCPHandler: Processed in 0.002805348 sec. | ||
683 | 2025.03.07 23:34:24.146884 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
684 | 2025.03.07 23:34:24.147063 [ 261 ] {2295715c-fc22-46cf-b1eb-cf44c8729901} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
685 | 2025.03.07 23:34:24.147125 [ 261 ] {2295715c-fc22-46cf-b1eb-cf44c8729901} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
686 | 2025.03.07 23:34:24.147837 [ 261 ] {2295715c-fc22-46cf-b1eb-cf44c8729901} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
687 | 2025.03.07 23:34:24.147877 [ 261 ] {2295715c-fc22-46cf-b1eb-cf44c8729901} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
688 | 2025.03.07 23:34:24.148331 [ 261 ] {2295715c-fc22-46cf-b1eb-cf44c8729901} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
689 | 2025.03.07 23:34:24.148648 [ 261 ] {2295715c-fc22-46cf-b1eb-cf44c8729901} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
690 | 2025.03.07 23:34:24.148894 [ 261 ] {2295715c-fc22-46cf-b1eb-cf44c8729901} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001861 sec., 537.345513164965 rows/sec., 37.26 KiB/sec. | ||
691 | 2025.03.07 23:34:24.149031 [ 261 ] {2295715c-fc22-46cf-b1eb-cf44c8729901} <Debug> TCPHandler: Processed in 0.002255754 sec. | ||
692 | 2025.03.07 23:34:24.699126 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 104 entries to flush up to offset 104 | ||
693 | 2025.03.07 23:34:24.699238 [ 242 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
694 | 2025.03.07 23:34:24.704247 [ 242 ] {} <Debug> system.query_log (247d883d-3e4e-49e9-9b75-43594ec42297): Loading data parts | ||
695 | 2025.03.07 23:34:24.704565 [ 242 ] {} <Debug> system.query_log (247d883d-3e4e-49e9-9b75-43594ec42297): There are no data parts | ||
696 | 2025.03.07 23:34:24.712041 [ 242 ] {} <Trace> system.query_log (247d883d-3e4e-49e9-9b75-43594ec42297): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
697 | 2025.03.07 23:34:24.712107 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
698 | 2025.03.07 23:34:24.714754 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
699 | 2025.03.07 23:34:24.715221 [ 242 ] {} <Trace> system.query_log (247d883d-3e4e-49e9-9b75-43594ec42297): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
700 | 2025.03.07 23:34:24.716080 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 104 | ||
701 | 2025.03.07 23:34:25.000308 [ 249 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 157.49 MiB, peak 157.49 MiB, free memory in arenas 0.00 B, will set to 153.44 MiB (RSS), difference: -4.04 MiB | ||
702 | 2025.03.07 23:34:25.247571 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
703 | 2025.03.07 23:34:25.247846 [ 261 ] {0fedab9d-c447-43ed-8cb5-8bdf0a367da0} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
704 | 2025.03.07 23:34:25.248057 [ 261 ] {0fedab9d-c447-43ed-8cb5-8bdf0a367da0} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
705 | 2025.03.07 23:34:25.252609 [ 261 ] {0fedab9d-c447-43ed-8cb5-8bdf0a367da0} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
706 | 2025.03.07 23:34:25.253210 [ 261 ] {0fedab9d-c447-43ed-8cb5-8bdf0a367da0} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
707 | 2025.03.07 23:34:25.254537 [ 261 ] {0fedab9d-c447-43ed-8cb5-8bdf0a367da0} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
708 | 2025.03.07 23:34:25.254880 [ 261 ] {0fedab9d-c447-43ed-8cb5-8bdf0a367da0} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
709 | 2025.03.07 23:34:25.255241 [ 261 ] {0fedab9d-c447-43ed-8cb5-8bdf0a367da0} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.007502 sec., 266.5955745134631 rows/sec., 27.60 KiB/sec. | ||
710 | 2025.03.07 23:34:25.255325 [ 261 ] {0fedab9d-c447-43ed-8cb5-8bdf0a367da0} <Debug> TCPHandler: Processed in 0.008097885 sec. | ||
711 | 2025.03.07 23:34:25.259607 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
712 | 2025.03.07 23:34:25.259883 [ 261 ] {3b7993fc-bffc-4bd9-a537-a7d33b0f0001} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
713 | 2025.03.07 23:34:25.259962 [ 261 ] {3b7993fc-bffc-4bd9-a537-a7d33b0f0001} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
714 | 2025.03.07 23:34:25.263011 [ 261 ] {3b7993fc-bffc-4bd9-a537-a7d33b0f0001} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
715 | 2025.03.07 23:34:25.263060 [ 261 ] {3b7993fc-bffc-4bd9-a537-a7d33b0f0001} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
716 | 2025.03.07 23:34:25.263618 [ 261 ] {3b7993fc-bffc-4bd9-a537-a7d33b0f0001} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
717 | 2025.03.07 23:34:25.263955 [ 261 ] {3b7993fc-bffc-4bd9-a537-a7d33b0f0001} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
718 | 2025.03.07 23:34:25.264234 [ 261 ] {3b7993fc-bffc-4bd9-a537-a7d33b0f0001} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.004408 sec., 226.8602540834846 rows/sec., 15.73 KiB/sec. | ||
719 | 2025.03.07 23:34:25.264318 [ 261 ] {3b7993fc-bffc-4bd9-a537-a7d33b0f0001} <Debug> TCPHandler: Processed in 0.004881961 sec. | ||
720 | 2025.03.07 23:34:26.178706 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
721 | 2025.03.07 23:34:26.178954 [ 261 ] {fbb0a757-45a9-48ba-8738-b3ead3f3ac18} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
722 | 2025.03.07 23:34:26.179080 [ 261 ] {fbb0a757-45a9-48ba-8738-b3ead3f3ac18} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
723 | 2025.03.07 23:34:26.181229 [ 261 ] {fbb0a757-45a9-48ba-8738-b3ead3f3ac18} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
724 | 2025.03.07 23:34:26.181292 [ 261 ] {fbb0a757-45a9-48ba-8738-b3ead3f3ac18} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
725 | 2025.03.07 23:34:26.181925 [ 261 ] {fbb0a757-45a9-48ba-8738-b3ead3f3ac18} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
726 | 2025.03.07 23:34:26.182339 [ 261 ] {fbb0a757-45a9-48ba-8738-b3ead3f3ac18} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
727 | 2025.03.07 23:34:26.182579 [ 18 ] {} <Debug> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
728 | 2025.03.07 23:34:26.182637 [ 261 ] {fbb0a757-45a9-48ba-8738-b3ead3f3ac18} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003757 sec., 532.3396326856534 rows/sec., 55.11 KiB/sec. | ||
729 | 2025.03.07 23:34:26.182645 [ 18 ] {} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
730 | 2025.03.07 23:34:26.182686 [ 18 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
731 | 2025.03.07 23:34:26.182739 [ 261 ] {fbb0a757-45a9-48ba-8738-b3ead3f3ac18} <Debug> TCPHandler: Processed in 0.004262088 sec. | ||
732 | 2025.03.07 23:34:26.182913 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
733 | 2025.03.07 23:34:26.183054 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
734 | 2025.03.07 23:34:26.183103 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 2 rows starting from the beginning of the part | ||
735 | 2025.03.07 23:34:26.183266 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::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.07 23:34:26.183370 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 2 rows starting from the beginning of the part | ||
737 | 2025.03.07 23:34:26.183568 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 2 rows starting from the beginning of the part | ||
738 | 2025.03.07 23:34:26.183743 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 2 rows starting from the beginning of the part | ||
739 | 2025.03.07 23:34:26.185044 [ 86 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 10 rows, containing 5 columns (5 merged, 0 gathered) in 0.002222454 sec., 4499.5306989481 rows/sec., 483.35 KiB/sec. | ||
740 | 2025.03.07 23:34:26.185245 [ 86 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
741 | 2025.03.07 23:34:26.185655 [ 86 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
742 | 2025.03.07 23:34:26.185755 [ 86 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_5_1} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
743 | 2025.03.07 23:34:26.185848 [ 86 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.32 MiB. | ||
744 | 2025.03.07 23:34:26.187112 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
745 | 2025.03.07 23:34:26.187287 [ 261 ] {512dedc5-ca2d-4bc5-8157-8bcc8c05a0a0} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
746 | 2025.03.07 23:34:26.187366 [ 261 ] {512dedc5-ca2d-4bc5-8157-8bcc8c05a0a0} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
747 | 2025.03.07 23:34:26.191395 [ 261 ] {512dedc5-ca2d-4bc5-8157-8bcc8c05a0a0} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
748 | 2025.03.07 23:34:26.191454 [ 261 ] {512dedc5-ca2d-4bc5-8157-8bcc8c05a0a0} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
749 | 2025.03.07 23:34:26.192095 [ 261 ] {512dedc5-ca2d-4bc5-8157-8bcc8c05a0a0} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
750 | 2025.03.07 23:34:26.192480 [ 261 ] {512dedc5-ca2d-4bc5-8157-8bcc8c05a0a0} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
751 | 2025.03.07 23:34:26.192709 [ 18 ] {} <Debug> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
752 | 2025.03.07 23:34:26.192760 [ 18 ] {} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
753 | 2025.03.07 23:34:26.192766 [ 261 ] {512dedc5-ca2d-4bc5-8157-8bcc8c05a0a0} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.005532 sec., 180.76644974692698 rows/sec., 12.53 KiB/sec. | ||
754 | 2025.03.07 23:34:26.192789 [ 18 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
755 | 2025.03.07 23:34:26.192874 [ 261 ] {512dedc5-ca2d-4bc5-8157-8bcc8c05a0a0} <Debug> TCPHandler: Processed in 0.005963505 sec. | ||
756 | 2025.03.07 23:34:26.193023 [ 178 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
757 | 2025.03.07 23:34:26.193155 [ 178 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
758 | 2025.03.07 23:34:26.193212 [ 178 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 1 rows starting from the beginning of the part | ||
759 | 2025.03.07 23:34:26.193327 [ 178 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 1 rows starting from the beginning of the part | ||
760 | 2025.03.07 23:34:26.193446 [ 178 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 1 rows starting from the beginning of the part | ||
761 | 2025.03.07 23:34:26.193601 [ 178 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 1 rows starting from the beginning of the part | ||
762 | 2025.03.07 23:34:26.193731 [ 178 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 1 rows starting from the beginning of the part | ||
763 | 2025.03.07 23:34:26.195156 [ 166 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 5 rows, containing 4 columns (4 merged, 0 gathered) in 0.002255323 sec., 2216.9773464820782 rows/sec., 153.72 KiB/sec. | ||
764 | 2025.03.07 23:34:26.195376 [ 129 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
765 | 2025.03.07 23:34:26.195820 [ 129 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
766 | 2025.03.07 23:34:26.195936 [ 129 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_5_1} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
767 | 2025.03.07 23:34:26.196027 [ 129 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.24 MiB. | ||
768 | 2025.03.07 23:34:27.215340 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 1464 | ||
769 | 2025.03.07 23:34:27.216346 [ 244 ] {} <Trace> system.asynchronous_metric_log (21d2aba1-0395-4f26-8a83-239f2cf92f88): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
770 | 2025.03.07 23:34:27.216409 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
771 | 2025.03.07 23:34:27.217160 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
772 | 2025.03.07 23:34:27.217561 [ 244 ] {} <Trace> system.asynchronous_metric_log (21d2aba1-0395-4f26-8a83-239f2cf92f88): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
773 | 2025.03.07 23:34:27.217822 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1464 | ||
774 | 2025.03.07 23:34:27.270406 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
775 | 2025.03.07 23:34:27.270706 [ 261 ] {39866e52-d7cf-46c4-9353-4b111bf0d908} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
776 | 2025.03.07 23:34:27.270811 [ 261 ] {39866e52-d7cf-46c4-9353-4b111bf0d908} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
777 | 2025.03.07 23:34:27.274860 [ 261 ] {39866e52-d7cf-46c4-9353-4b111bf0d908} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
778 | 2025.03.07 23:34:27.274922 [ 261 ] {39866e52-d7cf-46c4-9353-4b111bf0d908} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
779 | 2025.03.07 23:34:27.275722 [ 261 ] {39866e52-d7cf-46c4-9353-4b111bf0d908} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
780 | 2025.03.07 23:34:27.276268 [ 261 ] {39866e52-d7cf-46c4-9353-4b111bf0d908} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
781 | 2025.03.07 23:34:27.276652 [ 261 ] {39866e52-d7cf-46c4-9353-4b111bf0d908} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.006017 sec., 332.39155725444573 rows/sec., 34.41 KiB/sec. | ||
782 | 2025.03.07 23:34:27.276746 [ 261 ] {39866e52-d7cf-46c4-9353-4b111bf0d908} <Debug> TCPHandler: Processed in 0.006546239 sec. | ||
783 | 2025.03.07 23:34:27.279039 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
784 | 2025.03.07 23:34:27.279219 [ 261 ] {d4f12860-60c0-471e-a91f-79abb977e432} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
785 | 2025.03.07 23:34:27.279331 [ 261 ] {d4f12860-60c0-471e-a91f-79abb977e432} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
786 | 2025.03.07 23:34:27.282617 [ 261 ] {d4f12860-60c0-471e-a91f-79abb977e432} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
787 | 2025.03.07 23:34:27.282667 [ 261 ] {d4f12860-60c0-471e-a91f-79abb977e432} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
788 | 2025.03.07 23:34:27.283425 [ 261 ] {d4f12860-60c0-471e-a91f-79abb977e432} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
789 | 2025.03.07 23:34:27.283924 [ 261 ] {d4f12860-60c0-471e-a91f-79abb977e432} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
790 | 2025.03.07 23:34:27.284254 [ 261 ] {d4f12860-60c0-471e-a91f-79abb977e432} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.005084 sec., 196.6955153422502 rows/sec., 13.64 KiB/sec. | ||
791 | 2025.03.07 23:34:27.284335 [ 261 ] {d4f12860-60c0-471e-a91f-79abb977e432} <Debug> TCPHandler: Processed in 0.005431936 sec. | ||
792 | 2025.03.07 23:34:27.338292 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 7 entries to flush up to offset 23 | ||
793 | 2025.03.07 23:34:27.375096 [ 245 ] {} <Trace> system.metric_log (a8177820-099d-4483-b768-aa36523de9da): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
794 | 2025.03.07 23:34:27.375170 [ 245 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.21 GiB. | ||
795 | 2025.03.07 23:34:27.385708 [ 245 ] {} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
796 | 2025.03.07 23:34:27.388293 [ 245 ] {} <Trace> system.metric_log (a8177820-099d-4483-b768-aa36523de9da): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
797 | 2025.03.07 23:34:27.396204 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 23 | ||
798 | 2025.03.07 23:34:28.000306 [ 249 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 154.47 MiB, peak 158.47 MiB, free memory in arenas 0.00 B, will set to 157.17 MiB (RSS), difference: 2.70 MiB | ||
799 | 2025.03.07 23:34:28.215671 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
800 | 2025.03.07 23:34:28.216683 [ 261 ] {2f734bad-8bd7-4083-9bf2-88aaa0941382} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
801 | 2025.03.07 23:34:28.216797 [ 261 ] {2f734bad-8bd7-4083-9bf2-88aaa0941382} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
802 | 2025.03.07 23:34:28.225347 [ 261 ] {2f734bad-8bd7-4083-9bf2-88aaa0941382} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
803 | 2025.03.07 23:34:28.225418 [ 261 ] {2f734bad-8bd7-4083-9bf2-88aaa0941382} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
804 | 2025.03.07 23:34:28.226163 [ 261 ] {2f734bad-8bd7-4083-9bf2-88aaa0941382} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
805 | 2025.03.07 23:34:28.226586 [ 261 ] {2f734bad-8bd7-4083-9bf2-88aaa0941382} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
806 | 2025.03.07 23:34:28.226898 [ 261 ] {2f734bad-8bd7-4083-9bf2-88aaa0941382} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.010387 sec., 192.5483777799172 rows/sec., 19.93 KiB/sec. | ||
807 | 2025.03.07 23:34:28.227056 [ 261 ] {2f734bad-8bd7-4083-9bf2-88aaa0941382} <Debug> TCPHandler: Processed in 0.012239878 sec. | ||
808 | 2025.03.07 23:34:28.230179 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
809 | 2025.03.07 23:34:28.230378 [ 261 ] {174a0758-31eb-43c2-972c-d361dfeca8db} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
810 | 2025.03.07 23:34:28.230464 [ 261 ] {174a0758-31eb-43c2-972c-d361dfeca8db} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
811 | 2025.03.07 23:34:28.244499 [ 261 ] {174a0758-31eb-43c2-972c-d361dfeca8db} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
812 | 2025.03.07 23:34:28.244583 [ 261 ] {174a0758-31eb-43c2-972c-d361dfeca8db} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
813 | 2025.03.07 23:34:28.245461 [ 261 ] {174a0758-31eb-43c2-972c-d361dfeca8db} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
814 | 2025.03.07 23:34:28.245866 [ 261 ] {174a0758-31eb-43c2-972c-d361dfeca8db} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
815 | 2025.03.07 23:34:28.246179 [ 261 ] {174a0758-31eb-43c2-972c-d361dfeca8db} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.015856 sec., 63.06760847628659 rows/sec., 4.37 KiB/sec. | ||
816 | 2025.03.07 23:34:28.246329 [ 261 ] {174a0758-31eb-43c2-972c-d361dfeca8db} <Debug> TCPHandler: Processed in 0.016468697 sec. | ||
817 | 2025.03.07 23:34:28.885705 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
818 | 2025.03.07 23:34:28.886012 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Debug> executeQuery: (from [::1]:36135) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('integration_target:integration_metric') FORMAT Native; (stage: Complete) | ||
819 | 2025.03.07 23:34:28.886962 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Trace> InterpreterSelectQuery: The min valid primary key position for moving to the tail of PREWHERE is 0 | ||
820 | 2025.03.07 23:34:28.887019 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "timeseries_name NOT IN ('integration_target:integration_metric')" moved to PREWHERE | ||
821 | 2025.03.07 23:34:28.887419 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
822 | 2025.03.07 23:34:28.887563 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
823 | 2025.03.07 23:34:28.887919 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Key condition: (column 0 notIn 1-element set) | ||
824 | 2025.03.07 23:34:28.888001 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Trace> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Used generic exclusion search over index for part all_1_1_0 with 1 steps | ||
825 | 2025.03.07 23:34:28.888039 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Selected 1/1 parts by partition key, 0 parts by primary key, 0/1 marks by primary key, 0 marks to read from 0 ranges | ||
826 | 2025.03.07 23:34:28.888769 [ 261 ] {3d468f78-f5ac-40dc-9c93-13030d102a50} <Debug> TCPHandler: Processed in 0.003268738 sec. | ||
827 | 2025.03.07 23:34:28.909916 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
828 | 2025.03.07 23:34:28.910213 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Debug> executeQuery: (from [::1]:36135) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('http_service:request_latency_histogram', 'integration_target:integration_metric') FORMAT Native; (stage: Complete) | ||
829 | 2025.03.07 23:34:28.910703 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Trace> InterpreterSelectQuery: The min valid primary key position for moving to the tail of PREWHERE is 0 | ||
830 | 2025.03.07 23:34:28.910746 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "timeseries_name NOT IN ('http_service:request_latency_histogram', 'integration_target:integration_metric')" moved to PREWHERE | ||
831 | 2025.03.07 23:34:28.911106 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
832 | 2025.03.07 23:34:28.911221 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
833 | 2025.03.07 23:34:28.911484 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Key condition: (column 0 notIn 2-element set) | ||
834 | 2025.03.07 23:34:28.911538 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Trace> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Used generic exclusion search over index for part all_1_1_0 with 1 steps | ||
835 | 2025.03.07 23:34:28.911568 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Selected 1/1 parts by partition key, 0 parts by primary key, 0/1 marks by primary key, 0 marks to read from 0 ranges | ||
836 | 2025.03.07 23:34:28.912160 [ 261 ] {c1276469-75a1-4d29-b259-cebdbb6d215c} <Debug> TCPHandler: Processed in 0.002467903 sec. | ||
837 | 2025.03.07 23:34:28.914113 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
838 | 2025.03.07 23:34:28.914331 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Debug> executeQuery: (from [::1]:36135) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('collection_target:cpus_provisioned', 'http_service:request_latency_histogram', 'integration_target:integration_metric') FORMAT Native; (stage: Complete) | ||
839 | 2025.03.07 23:34:28.914677 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Trace> InterpreterSelectQuery: The min valid primary key position for moving to the tail of PREWHERE is 0 | ||
840 | 2025.03.07 23:34:28.914714 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "timeseries_name NOT IN ('collection_target:cpus_provisioned', 'http_service:request_latency_histogram', 'integration_target:integration_metric')" moved to PREWHERE | ||
841 | 2025.03.07 23:34:28.915000 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
842 | 2025.03.07 23:34:28.915804 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
843 | 2025.03.07 23:34:28.916027 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Key condition: (column 0 notIn 3-element set) | ||
844 | 2025.03.07 23:34:28.916075 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Trace> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Used generic exclusion search over index for part all_1_1_0 with 1 steps | ||
845 | 2025.03.07 23:34:28.916104 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Selected 1/1 parts by partition key, 0 parts by primary key, 0/1 marks by primary key, 0 marks to read from 0 ranges | ||
846 | 2025.03.07 23:34:28.916629 [ 261 ] {35aa936e-1354-4c73-935b-ffb3c5822551} <Debug> TCPHandler: Processed in 0.002597169 sec. | ||
847 | 2025.03.07 23:34:28.919719 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
848 | 2025.03.07 23:34:28.920273 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Debug> executeQuery: (from [::1]:36135) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('collection_target:cpus_provisioned', 'collection_target:ram_provisioned', 'http_service:request_latency_histogram', 'integration_target:integration_metric') FORMAT Native; (stage: Complete) | ||
849 | 2025.03.07 23:34:28.920667 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Trace> InterpreterSelectQuery: The min valid primary key position for moving to the tail of PREWHERE is 0 | ||
850 | 2025.03.07 23:34:28.920706 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "timeseries_name NOT IN ('collection_target:cpus_provisioned', 'collection_target:ram_provisioned', 'http_service:request_latency_histogram', 'integration_target:integration_metric')" moved to PREWHERE | ||
851 | 2025.03.07 23:34:28.921022 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
852 | 2025.03.07 23:34:28.921119 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
853 | 2025.03.07 23:34:28.921336 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Key condition: (column 0 notIn 4-element set) | ||
854 | 2025.03.07 23:34:28.921381 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Trace> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Used generic exclusion search over index for part all_1_1_0 with 1 steps | ||
855 | 2025.03.07 23:34:28.921410 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Debug> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944) (SelectExecutor): Selected 1/1 parts by partition key, 0 parts by primary key, 0/1 marks by primary key, 0 marks to read from 0 ranges | ||
856 | 2025.03.07 23:34:28.921964 [ 261 ] {52f79c00-ca26-4f68-8740-652b15bc1d66} <Debug> TCPHandler: Processed in 0.002557648 sec. | ||
857 | 2025.03.07 23:34:28.931000 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
858 | 2025.03.07 23:34:28.931245 [ 261 ] {26b93d64-3ce9-497d-b3d3-b9f355022bad} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
859 | 2025.03.07 23:34:28.931354 [ 261 ] {26b93d64-3ce9-497d-b3d3-b9f355022bad} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
860 | 2025.03.07 23:34:28.938866 [ 261 ] {26b93d64-3ce9-497d-b3d3-b9f355022bad} <Trace> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
861 | 2025.03.07 23:34:28.938935 [ 261 ] {26b93d64-3ce9-497d-b3d3-b9f355022bad} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
862 | 2025.03.07 23:34:28.939748 [ 261 ] {26b93d64-3ce9-497d-b3d3-b9f355022bad} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
863 | 2025.03.07 23:34:28.940106 [ 261 ] {26b93d64-3ce9-497d-b3d3-b9f355022bad} <Trace> oximeter.timeseries_schema (351d9ef9-4d57-4ebb-8854-fb0f1193e944): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
864 | 2025.03.07 23:34:28.940424 [ 261 ] {26b93d64-3ce9-497d-b3d3-b9f355022bad} <Debug> executeQuery: Read 4 rows, 433.00 B in 0.009255 sec., 432.19881145326855 rows/sec., 45.69 KiB/sec. | ||
865 | 2025.03.07 23:34:28.940549 [ 261 ] {26b93d64-3ce9-497d-b3d3-b9f355022bad} <Debug> TCPHandler: Processed in 0.009763442 sec. | ||
866 | 2025.03.07 23:34:28.946941 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
867 | 2025.03.07 23:34:28.947406 [ 261 ] {145676f4-71a0-435c-a953-e0394c2a3e10} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
868 | 2025.03.07 23:34:28.947530 [ 261 ] {145676f4-71a0-435c-a953-e0394c2a3e10} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
869 | 2025.03.07 23:34:28.952943 [ 261 ] {145676f4-71a0-435c-a953-e0394c2a3e10} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
870 | 2025.03.07 23:34:28.953032 [ 261 ] {145676f4-71a0-435c-a953-e0394c2a3e10} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
871 | 2025.03.07 23:34:28.953582 [ 261 ] {145676f4-71a0-435c-a953-e0394c2a3e10} <Trace> MergedBlockOutputStream: filled checksums all_8_8_0 (state Temporary) | ||
872 | 2025.03.07 23:34:28.953909 [ 261 ] {145676f4-71a0-435c-a953-e0394c2a3e10} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_8_8_0 to all_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
873 | 2025.03.07 23:34:28.954198 [ 261 ] {145676f4-71a0-435c-a953-e0394c2a3e10} <Debug> executeQuery: Read 26 rows, 2.47 KiB in 0.006863 sec., 3788.4307154305698 rows/sec., 359.72 KiB/sec. | ||
874 | 2025.03.07 23:34:28.954292 [ 261 ] {145676f4-71a0-435c-a953-e0394c2a3e10} <Debug> TCPHandler: Processed in 0.00754376 sec. | ||
875 | 2025.03.07 23:34:28.957630 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
876 | 2025.03.07 23:34:28.957806 [ 261 ] {456c5bda-bd36-4e85-8a4d-43b631a4e1fb} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_u16 FORMAT Native (stage: Complete) | ||
877 | 2025.03.07 23:34:28.957881 [ 261 ] {456c5bda-bd36-4e85-8a4d-43b631a4e1fb} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_u16 | ||
878 | 2025.03.07 23:34:28.960785 [ 261 ] {456c5bda-bd36-4e85-8a4d-43b631a4e1fb} <Trace> oximeter.fields_u16 (816f0f49-3b68-4861-bcc4-ce7b46de3bbf): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
879 | 2025.03.07 23:34:28.960843 [ 261 ] {456c5bda-bd36-4e85-8a4d-43b631a4e1fb} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
880 | 2025.03.07 23:34:28.961587 [ 261 ] {456c5bda-bd36-4e85-8a4d-43b631a4e1fb} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
881 | 2025.03.07 23:34:28.962024 [ 261 ] {456c5bda-bd36-4e85-8a4d-43b631a4e1fb} <Trace> oximeter.fields_u16 (816f0f49-3b68-4861-bcc4-ce7b46de3bbf): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
882 | 2025.03.07 23:34:28.962329 [ 261 ] {456c5bda-bd36-4e85-8a4d-43b631a4e1fb} <Debug> executeQuery: Read 12 rows, 924.00 B in 0.004576 sec., 2622.377622377622 rows/sec., 197.19 KiB/sec. | ||
883 | 2025.03.07 23:34:28.962418 [ 261 ] {456c5bda-bd36-4e85-8a4d-43b631a4e1fb} <Debug> TCPHandler: Processed in 0.004964104 sec. | ||
884 | 2025.03.07 23:34:28.964435 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
885 | 2025.03.07 23:34:28.964636 [ 261 ] {c713660d-43be-4eb1-9061-3101a3f19576} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_uuid FORMAT Native (stage: Complete) | ||
886 | 2025.03.07 23:34:28.964720 [ 261 ] {c713660d-43be-4eb1-9061-3101a3f19576} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_uuid | ||
887 | 2025.03.07 23:34:28.970317 [ 261 ] {c713660d-43be-4eb1-9061-3101a3f19576} <Trace> oximeter.fields_uuid (b14a443f-7c1a-4db5-b7d4-23205db5d9d0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
888 | 2025.03.07 23:34:28.970385 [ 261 ] {c713660d-43be-4eb1-9061-3101a3f19576} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
889 | 2025.03.07 23:34:28.971104 [ 261 ] {c713660d-43be-4eb1-9061-3101a3f19576} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
890 | 2025.03.07 23:34:28.971496 [ 261 ] {c713660d-43be-4eb1-9061-3101a3f19576} <Trace> oximeter.fields_uuid (b14a443f-7c1a-4db5-b7d4-23205db5d9d0): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
891 | 2025.03.07 23:34:28.971918 [ 261 ] {c713660d-43be-4eb1-9061-3101a3f19576} <Debug> executeQuery: Read 24 rows, 1.93 KiB in 0.007339 sec., 3270.2002997683608 rows/sec., 262.40 KiB/sec. | ||
892 | 2025.03.07 23:34:28.972032 [ 261 ] {c713660d-43be-4eb1-9061-3101a3f19576} <Debug> TCPHandler: Processed in 0.007756659 sec. | ||
893 | 2025.03.07 23:34:28.972582 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
894 | 2025.03.07 23:34:28.972777 [ 261 ] {388e1a44-fee2-4a92-b806-ff671914fe79} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_histogramu64 FORMAT Native (stage: Complete) | ||
895 | 2025.03.07 23:34:28.972879 [ 261 ] {388e1a44-fee2-4a92-b806-ff671914fe79} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, start_time, timestamp, bins, counts, min, max, sum_of_samples, squared_mean, p50_marker_heights, p50_marker_positions, p50_desired_marker_positions, p90_marker_heights, p90_marker_positions, p90_desired_marker_positions, p99_marker_heights, p99_marker_positions, p99_desired_marker_positions) ON oximeter.measurements_histogramu64 | ||
896 | 2025.03.07 23:34:28.975036 [ 261 ] {388e1a44-fee2-4a92-b806-ff671914fe79} <Trace> oximeter.measurements_histogramu64 (e98dab7c-ecc8-4823-978b-5000d78c021e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
897 | 2025.03.07 23:34:28.975084 [ 261 ] {388e1a44-fee2-4a92-b806-ff671914fe79} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
898 | 2025.03.07 23:34:28.976126 [ 261 ] {388e1a44-fee2-4a92-b806-ff671914fe79} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
899 | 2025.03.07 23:34:28.976517 [ 261 ] {388e1a44-fee2-4a92-b806-ff671914fe79} <Trace> oximeter.measurements_histogramu64 (e98dab7c-ecc8-4823-978b-5000d78c021e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
900 | 2025.03.07 23:34:28.976832 [ 261 ] {388e1a44-fee2-4a92-b806-ff671914fe79} <Debug> executeQuery: Read 12 rows, 22.02 KiB in 0.004131 sec., 2904.865649963689 rows/sec., 5.21 MiB/sec. | ||
901 | 2025.03.07 23:34:28.976979 [ 261 ] {388e1a44-fee2-4a92-b806-ff671914fe79} <Debug> TCPHandler: Processed in 0.004576356 sec. | ||
902 | 2025.03.07 23:34:28.977589 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
903 | 2025.03.07 23:34:28.977740 [ 261 ] {21cc7f76-0d9a-40f1-ad8b-bf7db830ae76} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
904 | 2025.03.07 23:34:28.977808 [ 261 ] {21cc7f76-0d9a-40f1-ad8b-bf7db830ae76} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
905 | 2025.03.07 23:34:28.978664 [ 261 ] {21cc7f76-0d9a-40f1-ad8b-bf7db830ae76} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
906 | 2025.03.07 23:34:28.978734 [ 261 ] {21cc7f76-0d9a-40f1-ad8b-bf7db830ae76} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
907 | 2025.03.07 23:34:28.979256 [ 261 ] {21cc7f76-0d9a-40f1-ad8b-bf7db830ae76} <Trace> MergedBlockOutputStream: filled checksums all_8_8_0 (state Temporary) | ||
908 | 2025.03.07 23:34:28.979678 [ 261 ] {21cc7f76-0d9a-40f1-ad8b-bf7db830ae76} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_8_8_0 to all_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
909 | 2025.03.07 23:34:28.979959 [ 261 ] {21cc7f76-0d9a-40f1-ad8b-bf7db830ae76} <Debug> executeQuery: Read 13 rows, 939.00 B in 0.002262 sec., 5747.126436781609 rows/sec., 405.39 KiB/sec. | ||
910 | 2025.03.07 23:34:28.980045 [ 261 ] {21cc7f76-0d9a-40f1-ad8b-bf7db830ae76} <Debug> TCPHandler: Processed in 0.002562951 sec. | ||
911 | 2025.03.07 23:34:30.205749 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
912 | 2025.03.07 23:34:30.205967 [ 261 ] {857203aa-c2a0-45f1-bafe-038d75d1ed54} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
913 | 2025.03.07 23:34:30.206052 [ 261 ] {857203aa-c2a0-45f1-bafe-038d75d1ed54} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
914 | 2025.03.07 23:34:30.212550 [ 261 ] {857203aa-c2a0-45f1-bafe-038d75d1ed54} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
915 | 2025.03.07 23:34:30.212606 [ 261 ] {857203aa-c2a0-45f1-bafe-038d75d1ed54} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
916 | 2025.03.07 23:34:30.213327 [ 261 ] {857203aa-c2a0-45f1-bafe-038d75d1ed54} <Trace> MergedBlockOutputStream: filled checksums all_9_9_0 (state Temporary) | ||
917 | 2025.03.07 23:34:30.213824 [ 261 ] {857203aa-c2a0-45f1-bafe-038d75d1ed54} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_9_9_0 to all_9_9_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
918 | 2025.03.07 23:34:30.214324 [ 261 ] {857203aa-c2a0-45f1-bafe-038d75d1ed54} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.008419 sec., 237.55790473928022 rows/sec., 24.59 KiB/sec. | ||
919 | 2025.03.07 23:34:30.214503 [ 261 ] {857203aa-c2a0-45f1-bafe-038d75d1ed54} <Debug> TCPHandler: Processed in 0.008954896 sec. | ||
920 | 2025.03.07 23:34:30.216636 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
921 | 2025.03.07 23:34:30.216836 [ 261 ] {ee8baf3d-a8d6-40d8-ab6b-a198c7de07a9} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
922 | 2025.03.07 23:34:30.216923 [ 261 ] {ee8baf3d-a8d6-40d8-ab6b-a198c7de07a9} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
923 | 2025.03.07 23:34:30.223147 [ 261 ] {ee8baf3d-a8d6-40d8-ab6b-a198c7de07a9} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
924 | 2025.03.07 23:34:30.223236 [ 261 ] {ee8baf3d-a8d6-40d8-ab6b-a198c7de07a9} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
925 | 2025.03.07 23:34:30.224217 [ 261 ] {ee8baf3d-a8d6-40d8-ab6b-a198c7de07a9} <Trace> MergedBlockOutputStream: filled checksums all_9_9_0 (state Temporary) | ||
926 | 2025.03.07 23:34:30.225209 [ 261 ] {ee8baf3d-a8d6-40d8-ab6b-a198c7de07a9} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_9_9_0 to all_9_9_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
927 | 2025.03.07 23:34:30.225658 [ 261 ] {ee8baf3d-a8d6-40d8-ab6b-a198c7de07a9} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.008879 sec., 112.62529564140107 rows/sec., 7.81 KiB/sec. | ||
928 | 2025.03.07 23:34:30.225743 [ 261 ] {ee8baf3d-a8d6-40d8-ab6b-a198c7de07a9} <Debug> TCPHandler: Processed in 0.009269694 sec. | ||
929 | 2025.03.07 23:34:31.146170 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
930 | 2025.03.07 23:34:31.146399 [ 261 ] {fa1155ea-4165-4b56-85a1-32d13daa0b9f} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
931 | 2025.03.07 23:34:31.146507 [ 261 ] {fa1155ea-4165-4b56-85a1-32d13daa0b9f} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
932 | 2025.03.07 23:34:31.147754 [ 261 ] {fa1155ea-4165-4b56-85a1-32d13daa0b9f} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
933 | 2025.03.07 23:34:31.147807 [ 261 ] {fa1155ea-4165-4b56-85a1-32d13daa0b9f} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
934 | 2025.03.07 23:34:31.148505 [ 261 ] {fa1155ea-4165-4b56-85a1-32d13daa0b9f} <Trace> MergedBlockOutputStream: filled checksums all_10_10_0 (state Temporary) | ||
935 | 2025.03.07 23:34:31.148972 [ 261 ] {fa1155ea-4165-4b56-85a1-32d13daa0b9f} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_insert_all_10_10_0 to all_10_10_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
936 | 2025.03.07 23:34:31.149190 [ 21 ] {} <Debug> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267) (MergerMutator): Selected 6 parts from all_1_5_1 to all_10_10_0 | ||
937 | 2025.03.07 23:34:31.149235 [ 21 ] {} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
938 | 2025.03.07 23:34:31.149250 [ 261 ] {fa1155ea-4165-4b56-85a1-32d13daa0b9f} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002919 sec., 685.166152792052 rows/sec., 70.93 KiB/sec. | ||
939 | 2025.03.07 23:34:31.149271 [ 21 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
940 | 2025.03.07 23:34:31.149473 [ 261 ] {fa1155ea-4165-4b56-85a1-32d13daa0b9f} <Debug> TCPHandler: Processed in 0.003480697 sec. | ||
941 | 2025.03.07 23:34:31.149617 [ 178 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTask::PrepareStage: Merging 6 parts: from all_1_5_1 to all_10_10_0 into Compact with storage Full | ||
942 | 2025.03.07 23:34:31.149773 [ 178 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
943 | 2025.03.07 23:34:31.149825 [ 178 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_5_1, total 2 rows starting from the beginning of the part | ||
944 | 2025.03.07 23:34:31.150025 [ 178 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_6_6_0, total 2 rows starting from the beginning of the part | ||
945 | 2025.03.07 23:34:31.150144 [ 178 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_7_7_0, total 2 rows starting from the beginning of the part | ||
946 | 2025.03.07 23:34:31.150239 [ 178 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_8_8_0, total 26 rows starting from the beginning of the part | ||
947 | 2025.03.07 23:34:31.150402 [ 178 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_9_9_0, total 2 rows starting from the beginning of the part | ||
948 | 2025.03.07 23:34:31.150525 [ 178 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_10_10_0, total 2 rows starting from the beginning of the part | ||
949 | 2025.03.07 23:34:31.151824 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 36 rows, containing 5 columns (5 merged, 0 gathered) in 0.002449038 sec., 14699.64941336149 rows/sec., 1.45 MiB/sec. | ||
950 | 2025.03.07 23:34:31.151984 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Trace> MergedBlockOutputStream: filled checksums all_1_10_2 (state Temporary) | ||
951 | 2025.03.07 23:34:31.152364 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267): Renaming temporary part tmp_merge_all_1_10_2 to all_1_10_2 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
952 | 2025.03.07 23:34:31.152470 [ 166 ] {6b505cee-dd87-4ea2-bd44-d5122b0fa267::all_1_10_2} <Trace> oximeter.fields_string (6b505cee-dd87-4ea2-bd44-d5122b0fa267) (MergerMutator): Merged 6 parts: [all_1_5_1, all_10_10_0] -> all_1_10_2 | ||
953 | 2025.03.07 23:34:31.152552 [ 166 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.27 MiB. | ||
954 | 2025.03.07 23:34:31.155487 [ 261 ] {} <Trace> TCP-Session: 0a6c3a8d-b037-467e-80ba-1e64f397faab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
955 | 2025.03.07 23:34:31.155707 [ 261 ] {54d92379-c250-42ae-8c34-733ee0518a31} <Debug> executeQuery: (from [::1]:36135) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
956 | 2025.03.07 23:34:31.155792 [ 261 ] {54d92379-c250-42ae-8c34-733ee0518a31} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
957 | 2025.03.07 23:34:31.157156 [ 261 ] {54d92379-c250-42ae-8c34-733ee0518a31} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
958 | 2025.03.07 23:34:31.157201 [ 261 ] {54d92379-c250-42ae-8c34-733ee0518a31} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
959 | 2025.03.07 23:34:31.157751 [ 261 ] {54d92379-c250-42ae-8c34-733ee0518a31} <Trace> MergedBlockOutputStream: filled checksums all_10_10_0 (state Temporary) | ||
960 | 2025.03.07 23:34:31.158122 [ 261 ] {54d92379-c250-42ae-8c34-733ee0518a31} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_insert_all_10_10_0 to all_10_10_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
961 | 2025.03.07 23:34:31.158354 [ 21 ] {} <Debug> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815) (MergerMutator): Selected 6 parts from all_1_5_1 to all_10_10_0 | ||
962 | 2025.03.07 23:34:31.158403 [ 261 ] {54d92379-c250-42ae-8c34-733ee0518a31} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002754 sec., 363.10820624546113 rows/sec., 25.18 KiB/sec. | ||
963 | 2025.03.07 23:34:31.158404 [ 21 ] {} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
964 | 2025.03.07 23:34:31.158449 [ 21 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 137.22 GiB. | ||
965 | 2025.03.07 23:34:31.158501 [ 261 ] {54d92379-c250-42ae-8c34-733ee0518a31} <Debug> TCPHandler: Processed in 0.003186605 sec. | ||
966 | 2025.03.07 23:34:31.158655 [ 171 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTask::PrepareStage: Merging 6 parts: from all_1_5_1 to all_10_10_0 into Compact with storage Full | ||
967 | 2025.03.07 23:34:31.158782 [ 171 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
968 | 2025.03.07 23:34:31.158826 [ 171 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_5_1, total 5 rows starting from the beginning of the part | ||
969 | 2025.03.07 23:34:31.158932 [ 171 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_6_6_0, total 1 rows starting from the beginning of the part | ||
970 | 2025.03.07 23:34:31.159056 [ 171 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_7_7_0, total 1 rows starting from the beginning of the part | ||
971 | 2025.03.07 23:34:31.159263 [ 171 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_8_8_0, total 13 rows starting from the beginning of the part | ||
972 | 2025.03.07 23:34:31.159373 [ 171 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_9_9_0, total 1 rows starting from the beginning of the part | ||
973 | 2025.03.07 23:34:31.159481 [ 171 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_10_10_0, total 1 rows starting from the beginning of the part | ||
974 | 2025.03.07 23:34:31.160964 [ 166 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 22 rows, containing 4 columns (4 merged, 0 gathered) in 0.002387251 sec., 9215.620812390485 rows/sec., 645.52 KiB/sec. | ||
975 | 2025.03.07 23:34:31.161137 [ 166 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Trace> MergedBlockOutputStream: filled checksums all_1_10_2 (state Temporary) | ||
976 | 2025.03.07 23:34:31.161532 [ 166 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815): Renaming temporary part tmp_merge_all_1_10_2 to all_1_10_2 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
977 | 2025.03.07 23:34:31.161636 [ 166 ] {83da133d-f33f-4e68-bd11-197cb1e57815::all_1_10_2} <Trace> oximeter.measurements_i64 (83da133d-f33f-4e68-bd11-197cb1e57815) (MergerMutator): Merged 6 parts: [all_1_5_1, all_10_10_0] -> all_1_10_2 | ||
978 | 2025.03.07 23:34:31.161720 [ 166 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.27 MiB. |