1 | 2024.12.21 00:52:29.373132 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 17555 | ||
2 | 2024.12.21 00:52:29.373290 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.12.21 00:52:29.373327 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.12.21 00:52:29.380578 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.12.21 00:52:29.382579 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.12.21 00:52:29.382606 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.12.21 00:52:29.382614 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.12.21 00:52:29.382654 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/datastore/tmp/ to store temporary data in it | ||
9 | 2024.12.21 00:52:29.383089 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.12.21 00:52:29.383805 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/config.xml' | ||
11 | 2024.12.21 00:52:29.384567 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/config.xml', performing update on configuration | ||
12 | 2024.12.21 00:52:29.385242 [ 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 | 2024.12.21 00:52:29.385277 [ 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 | 2024.12.21 00:52:29.385295 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.12.21 00:52:29.385385 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.12.21 00:52:29.387998 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.12.21 00:52:29.408003 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.12.21 00:52:29.409626 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.12.21 00:52:29.410805 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
20 | 2024.12.21 00:52:29.410883 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/config.xml', performed update on configuration | ||
21 | 2024.12.21 00:52:29.411897 [ 1 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/config.xml' | ||
22 | 2024.12.21 00:52:29.413415 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/config.xml', performing update on configuration | ||
23 | 2024.12.21 00:52:29.415116 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/config.xml', performed update on configuration | ||
24 | 2024.12.21 00:52:29.415686 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/config.xml | ||
25 | 2024.12.21 00:52:29.417481 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
26 | 2024.12.21 00:52:29.418596 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.12.21 00:52:29.419530 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.12.21 00:52:29.420205 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
29 | 2024.12.21 00:52:29.421835 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.12.21 00:52:29.421870 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/datastore/ | ||
31 | 2024.12.21 00:52:29.421914 [ 21 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.12.21 00:52:29.422025 [ 21 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.12.21 00:52:29.423457 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.12.21 00:52:29.423487 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000122218 sec | ||
35 | 2024.12.21 00:52:29.423506 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.12.21 00:52:29.423517 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.12.21 00:52:29.423596 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.12.21 00:52:29.423644 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
39 | 2024.12.21 00:52:29.426056 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
40 | 2024.12.21 00:52:29.426137 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.12.21 00:52:29.426154 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.12.21 00:52:29.426176 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.12.21 00:52:29.426204 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.12.21 00:52:29.426220 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
45 | 2024.12.21 00:52:29.429626 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2024.12.21 00:52:29.429686 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
47 | 2024.12.21 00:52:29.429704 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
48 | 2024.12.21 00:52:29.430236 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2024.12.21 00:52:29.430271 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2024.12.21 00:52:29.430295 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.12.21 00:52:29.430307 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.12.21 00:52:29.430339 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2024.12.21 00:52:29.430351 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2024.12.21 00:52:29.430363 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2024.12.21 00:52:29.466399 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.12.21 00:52:29.466993 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.12.21 00:52:29.467015 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.0811e-05 sec | ||
58 | 2024.12.21 00:52:29.467028 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.12.21 00:52:29.467037 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.12.21 00:52:29.467067 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.12.21 00:52:29.467447 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-8c17754d64a7fa50-test_racing_replacements_for_soft_deleted_disk_volume.17541.1-clickhouse-86H1kC/datastore/user_defined/ | ||
62 | 2024.12.21 00:52:29.467511 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.12.21 00:52:29.467531 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.12.21 00:52:29.467541 [ 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 | 2024.12.21 00:52:29.467551 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.12.21 00:52:29.467801 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34542 | ||
67 | 2024.12.21 00:52:29.467998 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 39419 | ||
68 | 2024.12.21 00:52:29.468614 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 39700 | ||
69 | 2024.12.21 00:52:29.468682 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 64934 | ||
70 | 2024.12.21 00:52:29.468715 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
71 | 2024.12.21 00:52:29.469105 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.77 MiB, peak 24.77 MiB, free memory in arenas 0.00 B, will set to 127.68 MiB (RSS), difference: 102.91 MiB | ||
72 | 2024.12.21 00:52:29.469464 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.8553e-05 sec. | ||
73 | 2024.12.21 00:52:29.470069 [ 1 ] {} <Information> Application: Listening for http://[::1]:34542 | ||
74 | 2024.12.21 00:52:29.470140 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:39419 | ||
75 | 2024.12.21 00:52:29.471176 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:39700 | ||
76 | 2024.12.21 00:52:29.471280 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:64934 | ||
77 | 2024.12.21 00:52:29.471296 [ 1 ] {} <Information> Application: Ready for connections. | ||
78 | 2024.12.21 00:52:30.000466 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 127.69 MiB, peak 127.69 MiB, free memory in arenas 0.00 B, will set to 129.00 MiB (RSS), difference: 1.31 MiB | ||
79 | 2024.12.21 00:52:31.056622 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37312 | ||
80 | 2024.12.21 00:52:31.057576 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
81 | 2024.12.21 00:52:31.057649 [ 3 ] {} <Debug> TCP-Session: 2b1bb157-7761-4bd1-83ee-d86b320758d1 Authenticating user 'default' from [::1]:37312 | ||
82 | 2024.12.21 00:52:31.057704 [ 3 ] {} <Debug> TCP-Session: 2b1bb157-7761-4bd1-83ee-d86b320758d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
83 | 2024.12.21 00:52:31.057722 [ 3 ] {} <Debug> TCP-Session: 2b1bb157-7761-4bd1-83ee-d86b320758d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2024.12.21 00:52:31.057819 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
85 | 2024.12.21 00:52:31.057859 [ 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 | 2024.12.21 00:52:31.057881 [ 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 | 2024.12.21 00:52:31.063207 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:40492 | ||
88 | 2024.12.21 00:52:31.063225 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:55453 | ||
89 | 2024.12.21 00:52:31.063919 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56261 | ||
90 | 2024.12.21 00:52:31.064299 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:40907 | ||
91 | 2024.12.21 00:52:31.064307 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35440 | ||
92 | 2024.12.21 00:52:31.064474 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58877 | ||
93 | 2024.12.21 00:52:31.064627 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:59138 | ||
94 | 2024.12.21 00:52:31.064966 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
95 | 2024.12.21 00:52:31.065012 [ 4 ] {} <Debug> TCP-Session: a926af6b-2e63-4741-9a7e-635ccab5deae Authenticating user 'default' from [::1]:40492 | ||
96 | 2024.12.21 00:52:31.065025 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
97 | 2024.12.21 00:52:31.065040 [ 4 ] {} <Debug> TCP-Session: a926af6b-2e63-4741-9a7e-635ccab5deae Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
98 | 2024.12.21 00:52:31.065065 [ 5 ] {} <Debug> TCP-Session: d9858192-587d-4eed-922c-51340f9b9300 Authenticating user 'default' from [::1]:55453 | ||
99 | 2024.12.21 00:52:31.065072 [ 4 ] {} <Debug> TCP-Session: a926af6b-2e63-4741-9a7e-635ccab5deae Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
100 | 2024.12.21 00:52:31.065092 [ 5 ] {} <Debug> TCP-Session: d9858192-587d-4eed-922c-51340f9b9300 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
101 | 2024.12.21 00:52:31.065113 [ 5 ] {} <Debug> TCP-Session: d9858192-587d-4eed-922c-51340f9b9300 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
102 | 2024.12.21 00:52:31.065148 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
103 | 2024.12.21 00:52:31.065157 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
104 | 2024.12.21 00:52:31.065183 [ 255 ] {} <Debug> TCP-Session: 5f13df21-335e-485d-b53a-aae6143aec61 Authenticating user 'default' from [::1]:59138 | ||
105 | 2024.12.21 00:52:31.065195 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
106 | 2024.12.21 00:52:31.065219 [ 255 ] {} <Debug> TCP-Session: 5f13df21-335e-485d-b53a-aae6143aec61 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
107 | 2024.12.21 00:52:31.065208 [ 258 ] {} <Debug> TCP-Session: 8f05f7ff-9194-4be8-b8ed-263bf63aa548 Authenticating user 'default' from [::1]:58877 | ||
108 | 2024.12.21 00:52:31.065241 [ 255 ] {} <Debug> TCP-Session: 5f13df21-335e-485d-b53a-aae6143aec61 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
109 | 2024.12.21 00:52:31.065243 [ 259 ] {} <Debug> TCP-Session: 40f61911-7600-4257-9b39-0bda0f6930c6 Authenticating user 'default' from [::1]:35440 | ||
110 | 2024.12.21 00:52:31.065259 [ 258 ] {} <Debug> TCP-Session: 8f05f7ff-9194-4be8-b8ed-263bf63aa548 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
111 | 2024.12.21 00:52:31.065295 [ 259 ] {} <Debug> TCP-Session: 40f61911-7600-4257-9b39-0bda0f6930c6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
112 | 2024.12.21 00:52:31.065313 [ 258 ] {} <Debug> TCP-Session: 8f05f7ff-9194-4be8-b8ed-263bf63aa548 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
113 | 2024.12.21 00:52:31.065325 [ 259 ] {} <Debug> TCP-Session: 40f61911-7600-4257-9b39-0bda0f6930c6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
114 | 2024.12.21 00:52:31.065358 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
115 | 2024.12.21 00:52:31.065395 [ 257 ] {} <Debug> TCP-Session: d8c23022-7444-4da5-a8aa-1709d6ddeaec Authenticating user 'default' from [::1]:40907 | ||
116 | 2024.12.21 00:52:31.065413 [ 257 ] {} <Debug> TCP-Session: d8c23022-7444-4da5-a8aa-1709d6ddeaec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
117 | 2024.12.21 00:52:31.065471 [ 257 ] {} <Debug> TCP-Session: d8c23022-7444-4da5-a8aa-1709d6ddeaec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
118 | 2024.12.21 00:52:31.065540 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
119 | 2024.12.21 00:52:31.065564 [ 256 ] {} <Debug> TCP-Session: 046d63ae-1dd5-4f00-8e73-59f072b04d8c Authenticating user 'default' from [::1]:56261 | ||
120 | 2024.12.21 00:52:31.065580 [ 256 ] {} <Debug> TCP-Session: 046d63ae-1dd5-4f00-8e73-59f072b04d8c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
121 | 2024.12.21 00:52:31.065599 [ 256 ] {} <Debug> TCP-Session: 046d63ae-1dd5-4f00-8e73-59f072b04d8c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
122 | 2024.12.21 00:52:36.932755 [ 242 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488 | ||
123 | 2024.12.21 00:52:36.932784 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
124 | 2024.12.21 00:52:36.932877 [ 245 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
125 | 2024.12.21 00:52:36.932877 [ 242 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
126 | 2024.12.21 00:52:36.938678 [ 242 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
127 | 2024.12.21 00:52:36.939090 [ 242 ] {} <Debug> system.asynchronous_metric_log (c0262210-8702-4e25-8006-eb8dc4b0b04b): Loading data parts | ||
128 | 2024.12.21 00:52:36.939731 [ 242 ] {} <Debug> system.asynchronous_metric_log (c0262210-8702-4e25-8006-eb8dc4b0b04b): There are no data parts | ||
129 | 2024.12.21 00:52:36.944143 [ 242 ] {} <Trace> system.asynchronous_metric_log (c0262210-8702-4e25-8006-eb8dc4b0b04b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
130 | 2024.12.21 00:52:36.944230 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.42 GiB. | ||
131 | 2024.12.21 00:52:36.946191 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
132 | 2024.12.21 00:52:36.946873 [ 242 ] {} <Trace> system.asynchronous_metric_log (c0262210-8702-4e25-8006-eb8dc4b0b04b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
133 | 2024.12.21 00:52:36.947491 [ 242 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488 | ||
134 | 2024.12.21 00:52:36.960402 [ 245 ] {} <Debug> system.metric_log (d82126f2-4ccb-440b-93e7-9c027a1e05e1): Loading data parts | ||
135 | 2024.12.21 00:52:36.960783 [ 245 ] {} <Debug> system.metric_log (d82126f2-4ccb-440b-93e7-9c027a1e05e1): There are no data parts | ||
136 | 2024.12.21 00:52:36.998008 [ 245 ] {} <Trace> system.metric_log (d82126f2-4ccb-440b-93e7-9c027a1e05e1): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
137 | 2024.12.21 00:52:36.998096 [ 245 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.42 GiB. | ||
138 | 2024.12.21 00:52:37.000815 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 133.67 MiB, peak 133.80 MiB, free memory in arenas 0.00 B, will set to 139.84 MiB (RSS), difference: 6.17 MiB | ||
139 | 2024.12.21 00:52:37.011203 [ 245 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
140 | 2024.12.21 00:52:37.012886 [ 245 ] {} <Trace> system.metric_log (d82126f2-4ccb-440b-93e7-9c027a1e05e1): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
141 | 2024.12.21 00:52:37.018389 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
142 | 2024.12.21 00:52:40.522165 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56695 | ||
143 | 2024.12.21 00:52:40.605698 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
144 | 2024.12.21 00:52:40.605773 [ 261 ] {} <Debug> TCP-Session: 902fd7c9-9e7f-4ac3-b03f-7ca934e69a1a Authenticating user 'default' from [::1]:56695 | ||
145 | 2024.12.21 00:52:40.605844 [ 261 ] {} <Debug> TCP-Session: 902fd7c9-9e7f-4ac3-b03f-7ca934e69a1a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2024.12.21 00:52:40.605863 [ 261 ] {} <Debug> TCP-Session: 902fd7c9-9e7f-4ac3-b03f-7ca934e69a1a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
147 | 2024.12.21 00:52:40.709977 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:48877 | ||
148 | 2024.12.21 00:52:40.710145 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:42286 | ||
149 | 2024.12.21 00:52:40.710610 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:33617 | ||
150 | 2024.12.21 00:52:40.710901 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:46596 | ||
151 | 2024.12.21 00:52:40.710915 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:46163 | ||
152 | 2024.12.21 00:52:40.710940 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:48145 | ||
153 | 2024.12.21 00:52:40.710972 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53256 | ||
154 | 2024.12.21 00:52:40.711440 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:46879 | ||
155 | 2024.12.21 00:52:40.711546 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
156 | 2024.12.21 00:52:40.711597 [ 262 ] {} <Debug> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Authenticating user 'default' from [::1]:48877 | ||
157 | 2024.12.21 00:52:40.711629 [ 262 ] {} <Debug> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
158 | 2024.12.21 00:52:40.711837 [ 262 ] {} <Debug> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
159 | 2024.12.21 00:52:40.711854 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
160 | 2024.12.21 00:52:40.711890 [ 263 ] {} <Debug> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Authenticating user 'default' from [::1]:42286 | ||
161 | 2024.12.21 00:52:40.711915 [ 263 ] {} <Debug> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
162 | 2024.12.21 00:52:40.711931 [ 263 ] {} <Debug> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
163 | 2024.12.21 00:52:40.711930 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
164 | 2024.12.21 00:52:40.711970 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
165 | 2024.12.21 00:52:40.711977 [ 266 ] {} <Debug> TCP-Session: f359bfbf-45dd-40e5-9ba6-ed7c275714f2 Authenticating user 'default' from [::1]:53256 | ||
166 | 2024.12.21 00:52:40.711985 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
167 | 2024.12.21 00:52:40.712016 [ 267 ] {} <Debug> TCP-Session: 79056c29-844a-46dd-a02d-37dd1cbd8637 Authenticating user 'default' from [::1]:46163 | ||
168 | 2024.12.21 00:52:40.712031 [ 266 ] {} <Debug> TCP-Session: f359bfbf-45dd-40e5-9ba6-ed7c275714f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
169 | 2024.12.21 00:52:40.712045 [ 264 ] {} <Debug> TCP-Session: 611cf79f-3dbf-4142-a162-e1bdf7ffb7f4 Authenticating user 'default' from [::1]:48145 | ||
170 | 2024.12.21 00:52:40.712045 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
171 | 2024.12.21 00:52:40.712091 [ 267 ] {} <Debug> TCP-Session: 79056c29-844a-46dd-a02d-37dd1cbd8637 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
172 | 2024.12.21 00:52:40.712084 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
173 | 2024.12.21 00:52:40.712086 [ 266 ] {} <Debug> TCP-Session: f359bfbf-45dd-40e5-9ba6-ed7c275714f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
174 | 2024.12.21 00:52:40.712140 [ 264 ] {} <Debug> TCP-Session: 611cf79f-3dbf-4142-a162-e1bdf7ffb7f4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
175 | 2024.12.21 00:52:40.712164 [ 268 ] {} <Debug> TCP-Session: b044e815-c3b5-4c90-841a-f6db8c03a280 Authenticating user 'default' from [::1]:46596 | ||
176 | 2024.12.21 00:52:40.712189 [ 261 ] {} <Trace> TCP-Session: 902fd7c9-9e7f-4ac3-b03f-7ca934e69a1a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
177 | 2024.12.21 00:52:40.712208 [ 267 ] {} <Debug> TCP-Session: 79056c29-844a-46dd-a02d-37dd1cbd8637 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
178 | 2024.12.21 00:52:40.712254 [ 269 ] {} <Debug> TCP-Session: 23c16378-8cf5-42a2-84c9-fc8bcccff53b Authenticating user 'default' from [::1]:46879 | ||
179 | 2024.12.21 00:52:40.712241 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
180 | 2024.12.21 00:52:40.712260 [ 264 ] {} <Debug> TCP-Session: 611cf79f-3dbf-4142-a162-e1bdf7ffb7f4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
181 | 2024.12.21 00:52:40.712339 [ 268 ] {} <Debug> TCP-Session: b044e815-c3b5-4c90-841a-f6db8c03a280 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
182 | 2024.12.21 00:52:40.712373 [ 269 ] {} <Debug> TCP-Session: 23c16378-8cf5-42a2-84c9-fc8bcccff53b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
183 | 2024.12.21 00:52:40.712400 [ 265 ] {} <Debug> TCP-Session: b722676a-00ac-43f5-ae7c-b152b4aa3b8d Authenticating user 'default' from [::1]:33617 | ||
184 | 2024.12.21 00:52:40.712440 [ 269 ] {} <Debug> TCP-Session: 23c16378-8cf5-42a2-84c9-fc8bcccff53b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
185 | 2024.12.21 00:52:40.712429 [ 268 ] {} <Debug> TCP-Session: b044e815-c3b5-4c90-841a-f6db8c03a280 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
186 | 2024.12.21 00:52:40.712464 [ 265 ] {} <Debug> TCP-Session: b722676a-00ac-43f5-ae7c-b152b4aa3b8d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
187 | 2024.12.21 00:52:40.712496 [ 265 ] {} <Debug> TCP-Session: b722676a-00ac-43f5-ae7c-b152b4aa3b8d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
188 | 2024.12.21 00:52:40.712803 [ 261 ] {f2b1f422-cf9b-4fd1-ba4e-504fafd59efc} <Debug> executeQuery: (from [::1]:56695) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
189 | 2024.12.21 00:52:40.721420 [ 261 ] {f2b1f422-cf9b-4fd1-ba4e-504fafd59efc} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:56695) (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 | 2024.12.21 00:52:40.721649 [ 261 ] {f2b1f422-cf9b-4fd1-ba4e-504fafd59efc} <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 | 2024.12.21 00:52:40.721736 [ 261 ] {f2b1f422-cf9b-4fd1-ba4e-504fafd59efc} <Debug> TCPHandler: Processed in 0.01034783 sec. | ||
238 | 2024.12.21 00:52:40.791945 [ 261 ] {} <Debug> TCPHandler: Done processing connection. | ||
239 | 2024.12.21 00:52:40.792021 [ 261 ] {} <Debug> TCP-Session: 902fd7c9-9e7f-4ac3-b03f-7ca934e69a1a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
240 | 2024.12.21 00:52:40.792366 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
241 | 2024.12.21 00:52:40.792628 [ 262 ] {b7a54f84-992c-4ca5-884f-70c08aa20de7} <Debug> executeQuery: (from [::1]:48877) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
242 | 2024.12.21 00:52:40.793118 [ 262 ] {b7a54f84-992c-4ca5-884f-70c08aa20de7} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:48877) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
243 | |||
244 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
245 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
246 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
247 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
248 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
249 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
250 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
251 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
252 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
253 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
254 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
255 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
256 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
257 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
258 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
259 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
260 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
261 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
262 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
263 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
264 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
265 | |||
266 | 2024.12.21 00:52:40.793275 [ 262 ] {b7a54f84-992c-4ca5-884f-70c08aa20de7} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
267 | |||
268 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
269 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
270 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
271 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
272 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
273 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
274 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
275 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
276 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
277 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
278 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
279 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
280 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
281 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
282 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
283 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
284 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
285 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
286 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
287 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
288 | 20. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
289 | |||
290 | 2024.12.21 00:52:40.793353 [ 262 ] {b7a54f84-992c-4ca5-884f-70c08aa20de7} <Debug> TCPHandler: Processed in 0.001189421 sec. | ||
291 | 2024.12.21 00:52:40.820254 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
292 | 2024.12.21 00:52:40.820596 [ 263 ] {e46636a2-1e30-4d76-b3d4-6efe853d4e76} <Debug> executeQuery: (from [::1]:42286) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
293 | 2024.12.21 00:52:40.820787 [ 263 ] {e46636a2-1e30-4d76-b3d4-6efe853d4e76} <Debug> TCPHandler: Processed in 0.000790521 sec. | ||
294 | 2024.12.21 00:52:40.841361 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
295 | 2024.12.21 00:52:40.841589 [ 262 ] {c6558c03-9e88-4a26-aed3-755c5090728f} <Debug> executeQuery: (from [::1]:48877) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
296 | 2024.12.21 00:52:40.841726 [ 262 ] {c6558c03-9e88-4a26-aed3-755c5090728f} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
297 | 2024.12.21 00:52:40.842308 [ 262 ] {c6558c03-9e88-4a26-aed3-755c5090728f} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
298 | 2024.12.21 00:52:40.842342 [ 262 ] {c6558c03-9e88-4a26-aed3-755c5090728f} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.9126e-05 sec | ||
299 | 2024.12.21 00:52:40.842356 [ 262 ] {c6558c03-9e88-4a26-aed3-755c5090728f} <Trace> ReferentialDeps: No tables | ||
300 | 2024.12.21 00:52:40.842367 [ 262 ] {c6558c03-9e88-4a26-aed3-755c5090728f} <Trace> LoadingDeps: No tables | ||
301 | 2024.12.21 00:52:40.842393 [ 262 ] {c6558c03-9e88-4a26-aed3-755c5090728f} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
302 | 2024.12.21 00:52:40.842479 [ 262 ] {c6558c03-9e88-4a26-aed3-755c5090728f} <Debug> TCPHandler: Processed in 0.001310639 sec. | ||
303 | 2024.12.21 00:52:40.858322 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
304 | 2024.12.21 00:52:40.858644 [ 263 ] {1101a858-5def-4075-b553-8c4a72460620} <Debug> executeQuery: (from [::1]:42286) /* The version table contains metadata about the `oximeter` database */ | ||
305 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
306 | 2024.12.21 00:52:40.858774 [ 263 ] {1101a858-5def-4075-b553-8c4a72460620} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
307 | 2024.12.21 00:52:40.860145 [ 263 ] {1101a858-5def-4075-b553-8c4a72460620} <Debug> oximeter.version (ceb3c345-e14a-424c-aa55-746c37c1faba): Loading data parts | ||
308 | 2024.12.21 00:52:40.860429 [ 263 ] {1101a858-5def-4075-b553-8c4a72460620} <Debug> oximeter.version (ceb3c345-e14a-424c-aa55-746c37c1faba): There are no data parts | ||
309 | 2024.12.21 00:52:40.861017 [ 263 ] {1101a858-5def-4075-b553-8c4a72460620} <Debug> TCPHandler: Processed in 0.002880413 sec. | ||
310 | 2024.12.21 00:52:40.871705 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
311 | 2024.12.21 00:52:40.872106 [ 262 ] {b9e87104-1d86-483f-a862-2e03c0cf0379} <Debug> executeQuery: (from [::1]:48877) /* The measurement tables contain all individual samples from each timeseries. | ||
312 | * | ||
313 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
314 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
315 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
316 | * by all samples from the same timeseries. | ||
317 | * | ||
318 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
319 | * and then uses that to index quickly into the measurements tables. | ||
320 | */ | ||
321 | 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) | ||
322 | 2024.12.21 00:52:40.872191 [ 262 ] {b9e87104-1d86-483f-a862-2e03c0cf0379} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
323 | 2024.12.21 00:52:40.873775 [ 262 ] {b9e87104-1d86-483f-a862-2e03c0cf0379} <Debug> oximeter.measurements_bool (c236f896-c934-4662-b4f6-06dc9ed32307): Loading data parts | ||
324 | 2024.12.21 00:52:40.874682 [ 262 ] {b9e87104-1d86-483f-a862-2e03c0cf0379} <Debug> oximeter.measurements_bool (c236f896-c934-4662-b4f6-06dc9ed32307): There are no data parts | ||
325 | 2024.12.21 00:52:40.875242 [ 262 ] {b9e87104-1d86-483f-a862-2e03c0cf0379} <Debug> TCPHandler: Processed in 0.003628302 sec. | ||
326 | 2024.12.21 00:52:40.884883 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
327 | 2024.12.21 00:52:40.885218 [ 263 ] {a131e337-3425-4a82-aa5a-6ad9dd5ec568} <Debug> executeQuery: (from [::1]:42286) 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) | ||
328 | 2024.12.21 00:52:40.885303 [ 263 ] {a131e337-3425-4a82-aa5a-6ad9dd5ec568} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
329 | 2024.12.21 00:52:40.886890 [ 263 ] {a131e337-3425-4a82-aa5a-6ad9dd5ec568} <Debug> oximeter.measurements_i8 (94a40be5-f35a-442d-8919-a17e01e6b952): Loading data parts | ||
330 | 2024.12.21 00:52:40.887258 [ 263 ] {a131e337-3425-4a82-aa5a-6ad9dd5ec568} <Debug> oximeter.measurements_i8 (94a40be5-f35a-442d-8919-a17e01e6b952): There are no data parts | ||
331 | 2024.12.21 00:52:40.887847 [ 263 ] {a131e337-3425-4a82-aa5a-6ad9dd5ec568} <Debug> TCPHandler: Processed in 0.003101415 sec. | ||
332 | 2024.12.21 00:52:40.901996 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
333 | 2024.12.21 00:52:40.902328 [ 262 ] {d4d90d2a-937b-4039-8380-acd24e0fa953} <Debug> executeQuery: (from [::1]:48877) 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) | ||
334 | 2024.12.21 00:52:40.902414 [ 262 ] {d4d90d2a-937b-4039-8380-acd24e0fa953} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
335 | 2024.12.21 00:52:40.903700 [ 262 ] {d4d90d2a-937b-4039-8380-acd24e0fa953} <Debug> oximeter.measurements_u8 (c297ce0e-6794-4698-929c-d3013626a993): Loading data parts | ||
336 | 2024.12.21 00:52:40.904136 [ 262 ] {d4d90d2a-937b-4039-8380-acd24e0fa953} <Debug> oximeter.measurements_u8 (c297ce0e-6794-4698-929c-d3013626a993): There are no data parts | ||
337 | 2024.12.21 00:52:40.904656 [ 262 ] {d4d90d2a-937b-4039-8380-acd24e0fa953} <Debug> TCPHandler: Processed in 0.002748437 sec. | ||
338 | 2024.12.21 00:52:40.914044 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
339 | 2024.12.21 00:52:40.914482 [ 263 ] {94fdb4d7-337b-4678-899a-8b46dbcb82ae} <Debug> executeQuery: (from [::1]:42286) 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) | ||
340 | 2024.12.21 00:52:40.914583 [ 263 ] {94fdb4d7-337b-4678-899a-8b46dbcb82ae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
341 | 2024.12.21 00:52:40.916100 [ 263 ] {94fdb4d7-337b-4678-899a-8b46dbcb82ae} <Debug> oximeter.measurements_i16 (e89e89b8-4bad-46cd-9c85-c005b6df19fc): Loading data parts | ||
342 | 2024.12.21 00:52:40.916381 [ 263 ] {94fdb4d7-337b-4678-899a-8b46dbcb82ae} <Debug> oximeter.measurements_i16 (e89e89b8-4bad-46cd-9c85-c005b6df19fc): There are no data parts | ||
343 | 2024.12.21 00:52:40.916944 [ 263 ] {94fdb4d7-337b-4678-899a-8b46dbcb82ae} <Debug> TCPHandler: Processed in 0.002997703 sec. | ||
344 | 2024.12.21 00:52:40.935396 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
345 | 2024.12.21 00:52:40.935776 [ 262 ] {19ed487e-1ed6-4020-960d-7210dd1765c4} <Debug> executeQuery: (from [::1]:48877) 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) | ||
346 | 2024.12.21 00:52:40.935871 [ 262 ] {19ed487e-1ed6-4020-960d-7210dd1765c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
347 | 2024.12.21 00:52:40.937727 [ 262 ] {19ed487e-1ed6-4020-960d-7210dd1765c4} <Debug> oximeter.measurements_u16 (9f57ba03-6877-4a8f-a5bc-16b52c04cd16): Loading data parts | ||
348 | 2024.12.21 00:52:40.938129 [ 262 ] {19ed487e-1ed6-4020-960d-7210dd1765c4} <Debug> oximeter.measurements_u16 (9f57ba03-6877-4a8f-a5bc-16b52c04cd16): There are no data parts | ||
349 | 2024.12.21 00:52:40.938730 [ 262 ] {19ed487e-1ed6-4020-960d-7210dd1765c4} <Debug> TCPHandler: Processed in 0.003553875 sec. | ||
350 | 2024.12.21 00:52:40.987464 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
351 | 2024.12.21 00:52:40.987897 [ 263 ] {c2a13dc5-7687-4c73-85b8-975a06b1bca4} <Debug> executeQuery: (from [::1]:42286) 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) | ||
352 | 2024.12.21 00:52:40.988022 [ 263 ] {c2a13dc5-7687-4c73-85b8-975a06b1bca4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
353 | 2024.12.21 00:52:40.989642 [ 263 ] {c2a13dc5-7687-4c73-85b8-975a06b1bca4} <Debug> oximeter.measurements_i32 (e047a608-4dfd-477d-a65f-20ccfb3c62f8): Loading data parts | ||
354 | 2024.12.21 00:52:40.989985 [ 263 ] {c2a13dc5-7687-4c73-85b8-975a06b1bca4} <Debug> oximeter.measurements_i32 (e047a608-4dfd-477d-a65f-20ccfb3c62f8): There are no data parts | ||
355 | 2024.12.21 00:52:40.990592 [ 263 ] {c2a13dc5-7687-4c73-85b8-975a06b1bca4} <Debug> TCPHandler: Processed in 0.003323046 sec. | ||
356 | 2024.12.21 00:52:41.000246 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 145.97 MiB, peak 145.97 MiB, free memory in arenas 0.00 B, will set to 147.38 MiB (RSS), difference: 1.41 MiB | ||
357 | 2024.12.21 00:52:41.007271 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
358 | 2024.12.21 00:52:41.007654 [ 262 ] {f572428e-b057-4e77-b36e-322ec6cef0c0} <Debug> executeQuery: (from [::1]:48877) 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) | ||
359 | 2024.12.21 00:52:41.007728 [ 262 ] {f572428e-b057-4e77-b36e-322ec6cef0c0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
360 | 2024.12.21 00:52:41.009766 [ 262 ] {f572428e-b057-4e77-b36e-322ec6cef0c0} <Debug> oximeter.measurements_u32 (caf377bd-9ec8-4c6b-a882-ed621a386657): Loading data parts | ||
361 | 2024.12.21 00:52:41.010193 [ 262 ] {f572428e-b057-4e77-b36e-322ec6cef0c0} <Debug> oximeter.measurements_u32 (caf377bd-9ec8-4c6b-a882-ed621a386657): There are no data parts | ||
362 | 2024.12.21 00:52:41.010763 [ 262 ] {f572428e-b057-4e77-b36e-322ec6cef0c0} <Debug> TCPHandler: Processed in 0.00358527 sec. | ||
363 | 2024.12.21 00:52:41.011744 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
364 | 2024.12.21 00:52:41.012096 [ 263 ] {0e4e9401-6624-4945-ad2a-11e214f86189} <Debug> executeQuery: (from [::1]:42286) 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) | ||
365 | 2024.12.21 00:52:41.012179 [ 263 ] {0e4e9401-6624-4945-ad2a-11e214f86189} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
366 | 2024.12.21 00:52:41.013661 [ 263 ] {0e4e9401-6624-4945-ad2a-11e214f86189} <Debug> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Loading data parts | ||
367 | 2024.12.21 00:52:41.013953 [ 263 ] {0e4e9401-6624-4945-ad2a-11e214f86189} <Debug> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): There are no data parts | ||
368 | 2024.12.21 00:52:41.014482 [ 263 ] {0e4e9401-6624-4945-ad2a-11e214f86189} <Debug> TCPHandler: Processed in 0.002833612 sec. | ||
369 | 2024.12.21 00:52:41.028526 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
370 | 2024.12.21 00:52:41.029244 [ 262 ] {ab7ecbe6-d5dc-409a-8d2e-079475fc8dbf} <Debug> executeQuery: (from [::1]:48877) 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) | ||
371 | 2024.12.21 00:52:41.029333 [ 262 ] {ab7ecbe6-d5dc-409a-8d2e-079475fc8dbf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
372 | 2024.12.21 00:52:41.031705 [ 262 ] {ab7ecbe6-d5dc-409a-8d2e-079475fc8dbf} <Debug> oximeter.measurements_u64 (3050756f-4325-4adc-a7b1-32beb06cbced): Loading data parts | ||
373 | 2024.12.21 00:52:41.032080 [ 262 ] {ab7ecbe6-d5dc-409a-8d2e-079475fc8dbf} <Debug> oximeter.measurements_u64 (3050756f-4325-4adc-a7b1-32beb06cbced): There are no data parts | ||
374 | 2024.12.21 00:52:41.032661 [ 262 ] {ab7ecbe6-d5dc-409a-8d2e-079475fc8dbf} <Debug> TCPHandler: Processed in 0.004395567 sec. | ||
375 | 2024.12.21 00:52:41.053599 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
376 | 2024.12.21 00:52:41.054059 [ 263 ] {d4451721-6365-4d6e-afcb-8298b9de2ded} <Debug> executeQuery: (from [::1]:42286) 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) | ||
377 | 2024.12.21 00:52:41.054159 [ 263 ] {d4451721-6365-4d6e-afcb-8298b9de2ded} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
378 | 2024.12.21 00:52:41.055649 [ 263 ] {d4451721-6365-4d6e-afcb-8298b9de2ded} <Debug> oximeter.measurements_f32 (5f0e1a49-6446-41fc-9038-b33f10aaf5e1): Loading data parts | ||
379 | 2024.12.21 00:52:41.056009 [ 263 ] {d4451721-6365-4d6e-afcb-8298b9de2ded} <Debug> oximeter.measurements_f32 (5f0e1a49-6446-41fc-9038-b33f10aaf5e1): There are no data parts | ||
380 | 2024.12.21 00:52:41.056540 [ 263 ] {d4451721-6365-4d6e-afcb-8298b9de2ded} <Debug> TCPHandler: Processed in 0.003134029 sec. | ||
381 | 2024.12.21 00:52:41.058305 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
382 | 2024.12.21 00:52:41.058587 [ 262 ] {095ecb93-75d1-4d0b-8ea5-74c32c945695} <Debug> executeQuery: (from [::1]:48877) 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) | ||
383 | 2024.12.21 00:52:41.058667 [ 262 ] {095ecb93-75d1-4d0b-8ea5-74c32c945695} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
384 | 2024.12.21 00:52:41.060089 [ 262 ] {095ecb93-75d1-4d0b-8ea5-74c32c945695} <Debug> oximeter.measurements_f64 (4cf346ea-71b1-4771-a953-2a0e83faf958): Loading data parts | ||
385 | 2024.12.21 00:52:41.060436 [ 262 ] {095ecb93-75d1-4d0b-8ea5-74c32c945695} <Debug> oximeter.measurements_f64 (4cf346ea-71b1-4771-a953-2a0e83faf958): There are no data parts | ||
386 | 2024.12.21 00:52:41.060999 [ 262 ] {095ecb93-75d1-4d0b-8ea5-74c32c945695} <Debug> TCPHandler: Processed in 0.00278772 sec. | ||
387 | 2024.12.21 00:52:41.063801 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
388 | 2024.12.21 00:52:41.064099 [ 263 ] {6c30b0e7-15e4-4a71-af28-eb19a7b63c52} <Debug> executeQuery: (from [::1]:42286) 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) | ||
389 | 2024.12.21 00:52:41.064204 [ 263 ] {6c30b0e7-15e4-4a71-af28-eb19a7b63c52} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
390 | 2024.12.21 00:52:41.065564 [ 263 ] {6c30b0e7-15e4-4a71-af28-eb19a7b63c52} <Debug> oximeter.measurements_string (16f241da-ece6-45b6-a147-ff8c849a60e1): Loading data parts | ||
391 | 2024.12.21 00:52:41.065898 [ 263 ] {6c30b0e7-15e4-4a71-af28-eb19a7b63c52} <Debug> oximeter.measurements_string (16f241da-ece6-45b6-a147-ff8c849a60e1): There are no data parts | ||
392 | 2024.12.21 00:52:41.066440 [ 263 ] {6c30b0e7-15e4-4a71-af28-eb19a7b63c52} <Debug> TCPHandler: Processed in 0.002767383 sec. | ||
393 | 2024.12.21 00:52:41.068604 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
394 | 2024.12.21 00:52:41.068936 [ 262 ] {f5e0f709-eead-41a5-a0a1-9f21fc9bd2a5} <Debug> executeQuery: (from [::1]:48877) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
395 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
396 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
397 | * a string isn't palatable for a few reasons. | ||
398 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
399 | * details. | ||
400 | */ | ||
401 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
402 | 2024.12.21 00:52:41.069065 [ 262 ] {f5e0f709-eead-41a5-a0a1-9f21fc9bd2a5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
403 | 2024.12.21 00:52:41.070546 [ 262 ] {f5e0f709-eead-41a5-a0a1-9f21fc9bd2a5} <Debug> oximeter.measurements_bytes (484fd791-ba18-46a1-abe8-eb0016f4d7e4): Loading data parts | ||
404 | 2024.12.21 00:52:41.070852 [ 262 ] {f5e0f709-eead-41a5-a0a1-9f21fc9bd2a5} <Debug> oximeter.measurements_bytes (484fd791-ba18-46a1-abe8-eb0016f4d7e4): There are no data parts | ||
405 | 2024.12.21 00:52:41.071702 [ 262 ] {f5e0f709-eead-41a5-a0a1-9f21fc9bd2a5} <Debug> TCPHandler: Processed in 0.003210915 sec. | ||
406 | 2024.12.21 00:52:41.073978 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
407 | 2024.12.21 00:52:41.074323 [ 263 ] {c0d49183-4a50-4ae1-add0-8a41cd016fc1} <Debug> executeQuery: (from [::1]:42286) 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) | ||
408 | 2024.12.21 00:52:41.074409 [ 263 ] {c0d49183-4a50-4ae1-add0-8a41cd016fc1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
409 | 2024.12.21 00:52:41.076563 [ 263 ] {c0d49183-4a50-4ae1-add0-8a41cd016fc1} <Debug> oximeter.measurements_cumulativei64 (3c9c8260-0ae2-45fd-961c-813f12e26c23): Loading data parts | ||
410 | 2024.12.21 00:52:41.076897 [ 263 ] {c0d49183-4a50-4ae1-add0-8a41cd016fc1} <Debug> oximeter.measurements_cumulativei64 (3c9c8260-0ae2-45fd-961c-813f12e26c23): There are no data parts | ||
411 | 2024.12.21 00:52:41.077881 [ 263 ] {c0d49183-4a50-4ae1-add0-8a41cd016fc1} <Debug> TCPHandler: Processed in 0.00398331 sec. | ||
412 | 2024.12.21 00:52:41.163608 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
413 | 2024.12.21 00:52:41.164064 [ 262 ] {4c7bec40-2c8b-462c-9c93-f91b10ef7470} <Debug> executeQuery: (from [::1]:48877) 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) | ||
414 | 2024.12.21 00:52:41.164177 [ 262 ] {4c7bec40-2c8b-462c-9c93-f91b10ef7470} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
415 | 2024.12.21 00:52:41.165920 [ 262 ] {4c7bec40-2c8b-462c-9c93-f91b10ef7470} <Debug> oximeter.measurements_cumulativeu64 (ec89a2ff-ddbb-43f1-a964-a0f420b036e4): Loading data parts | ||
416 | 2024.12.21 00:52:41.166321 [ 262 ] {4c7bec40-2c8b-462c-9c93-f91b10ef7470} <Debug> oximeter.measurements_cumulativeu64 (ec89a2ff-ddbb-43f1-a964-a0f420b036e4): There are no data parts | ||
417 | 2024.12.21 00:52:41.166944 [ 262 ] {4c7bec40-2c8b-462c-9c93-f91b10ef7470} <Debug> TCPHandler: Processed in 0.00352896 sec. | ||
418 | 2024.12.21 00:52:41.917266 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
419 | 2024.12.21 00:52:41.917723 [ 263 ] {e302c5a6-95b3-4f6a-a18f-0a83a7b58390} <Debug> executeQuery: (from [::1]:42286) 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) | ||
420 | 2024.12.21 00:52:41.917825 [ 263 ] {e302c5a6-95b3-4f6a-a18f-0a83a7b58390} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
421 | 2024.12.21 00:52:41.919515 [ 263 ] {e302c5a6-95b3-4f6a-a18f-0a83a7b58390} <Debug> oximeter.measurements_cumulativef32 (de73c9a8-5c6d-4c70-b960-c01d173174d6): Loading data parts | ||
422 | 2024.12.21 00:52:41.919766 [ 263 ] {e302c5a6-95b3-4f6a-a18f-0a83a7b58390} <Debug> oximeter.measurements_cumulativef32 (de73c9a8-5c6d-4c70-b960-c01d173174d6): There are no data parts | ||
423 | 2024.12.21 00:52:41.920315 [ 263 ] {e302c5a6-95b3-4f6a-a18f-0a83a7b58390} <Debug> TCPHandler: Processed in 0.003214175 sec. | ||
424 | 2024.12.21 00:52:42.002604 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
425 | 2024.12.21 00:52:42.003036 [ 262 ] {c48fd393-b5f1-407e-ac86-111c56aa9a5d} <Debug> executeQuery: (from [::1]:48877) 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) | ||
426 | 2024.12.21 00:52:42.003198 [ 262 ] {c48fd393-b5f1-407e-ac86-111c56aa9a5d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
427 | 2024.12.21 00:52:42.004987 [ 262 ] {c48fd393-b5f1-407e-ac86-111c56aa9a5d} <Debug> oximeter.measurements_cumulativef64 (aae0e18f-40a6-4be5-9f76-1853c32f7998): Loading data parts | ||
428 | 2024.12.21 00:52:42.005392 [ 262 ] {c48fd393-b5f1-407e-ac86-111c56aa9a5d} <Debug> oximeter.measurements_cumulativef64 (aae0e18f-40a6-4be5-9f76-1853c32f7998): There are no data parts | ||
429 | 2024.12.21 00:52:42.005995 [ 262 ] {c48fd393-b5f1-407e-ac86-111c56aa9a5d} <Debug> TCPHandler: Processed in 0.003598927 sec. | ||
430 | 2024.12.21 00:52:42.013348 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
431 | 2024.12.21 00:52:42.013827 [ 263 ] {4d184ed2-b550-4bb8-ab77-f5fe755b5472} <Debug> executeQuery: (from [::1]:42286) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
432 | * NOTE: Array types cannot be Nullable, see | ||
433 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
434 | * for more details. | ||
435 | * | ||
436 | * This means we need to use empty arrays to indicate a missing value. This | ||
437 | * is unfortunate, and at this point relies on the fact that an | ||
438 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
439 | * to figure out another way to represent missing samples here. | ||
440 | */ | ||
441 | 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) | ||
442 | 2024.12.21 00:52:42.014040 [ 263 ] {4d184ed2-b550-4bb8-ab77-f5fe755b5472} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
443 | 2024.12.21 00:52:42.016198 [ 263 ] {4d184ed2-b550-4bb8-ab77-f5fe755b5472} <Debug> oximeter.measurements_histogrami8 (13513377-9ff3-431b-87c5-8e99499186e5): Loading data parts | ||
444 | 2024.12.21 00:52:42.016552 [ 263 ] {4d184ed2-b550-4bb8-ab77-f5fe755b5472} <Debug> oximeter.measurements_histogrami8 (13513377-9ff3-431b-87c5-8e99499186e5): There are no data parts | ||
445 | 2024.12.21 00:52:42.017399 [ 263 ] {4d184ed2-b550-4bb8-ab77-f5fe755b5472} <Debug> TCPHandler: Processed in 0.00415086 sec. | ||
446 | 2024.12.21 00:52:42.065808 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
447 | 2024.12.21 00:52:42.066379 [ 262 ] {baafdd88-8d3e-4019-ac56-5159f377f235} <Debug> executeQuery: (from [::1]:48877) 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) | ||
448 | 2024.12.21 00:52:42.066643 [ 262 ] {baafdd88-8d3e-4019-ac56-5159f377f235} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
449 | 2024.12.21 00:52:42.068792 [ 262 ] {baafdd88-8d3e-4019-ac56-5159f377f235} <Debug> oximeter.measurements_histogramu8 (fc5eb9e9-db58-4486-9824-8991ed1c370b): Loading data parts | ||
450 | 2024.12.21 00:52:42.069207 [ 262 ] {baafdd88-8d3e-4019-ac56-5159f377f235} <Debug> oximeter.measurements_histogramu8 (fc5eb9e9-db58-4486-9824-8991ed1c370b): There are no data parts | ||
451 | 2024.12.21 00:52:42.069930 [ 262 ] {baafdd88-8d3e-4019-ac56-5159f377f235} <Debug> TCPHandler: Processed in 0.004297195 sec. | ||
452 | 2024.12.21 00:52:42.097072 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
453 | 2024.12.21 00:52:42.097620 [ 263 ] {dfe36a81-1bf7-4623-a140-1dbc674bc6c1} <Debug> executeQuery: (from [::1]:42286) 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) | ||
454 | 2024.12.21 00:52:42.097729 [ 263 ] {dfe36a81-1bf7-4623-a140-1dbc674bc6c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
455 | 2024.12.21 00:52:42.099823 [ 263 ] {dfe36a81-1bf7-4623-a140-1dbc674bc6c1} <Debug> oximeter.measurements_histogrami16 (0da174fa-c67a-4f9e-95e3-d5cc7db30c98): Loading data parts | ||
456 | 2024.12.21 00:52:42.100134 [ 263 ] {dfe36a81-1bf7-4623-a140-1dbc674bc6c1} <Debug> oximeter.measurements_histogrami16 (0da174fa-c67a-4f9e-95e3-d5cc7db30c98): There are no data parts | ||
457 | 2024.12.21 00:52:42.100859 [ 263 ] {dfe36a81-1bf7-4623-a140-1dbc674bc6c1} <Debug> TCPHandler: Processed in 0.003966393 sec. | ||
458 | 2024.12.21 00:52:42.106411 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
459 | 2024.12.21 00:52:42.106838 [ 262 ] {394827a6-7e4f-47f5-bb1d-b850e0846adf} <Debug> executeQuery: (from [::1]:48877) 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) | ||
460 | 2024.12.21 00:52:42.106947 [ 262 ] {394827a6-7e4f-47f5-bb1d-b850e0846adf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
461 | 2024.12.21 00:52:42.108819 [ 262 ] {394827a6-7e4f-47f5-bb1d-b850e0846adf} <Debug> oximeter.measurements_histogramu16 (807b5ca3-78b6-45ae-90d2-874e1ad18b0d): Loading data parts | ||
462 | 2024.12.21 00:52:42.109244 [ 262 ] {394827a6-7e4f-47f5-bb1d-b850e0846adf} <Debug> oximeter.measurements_histogramu16 (807b5ca3-78b6-45ae-90d2-874e1ad18b0d): There are no data parts | ||
463 | 2024.12.21 00:52:42.109823 [ 262 ] {394827a6-7e4f-47f5-bb1d-b850e0846adf} <Debug> TCPHandler: Processed in 0.003514872 sec. | ||
464 | 2024.12.21 00:52:42.140785 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
465 | 2024.12.21 00:52:42.141340 [ 263 ] {4e68f0bc-3494-49e1-8135-5254355d1f3e} <Debug> executeQuery: (from [::1]:42286) 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) | ||
466 | 2024.12.21 00:52:42.141444 [ 263 ] {4e68f0bc-3494-49e1-8135-5254355d1f3e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
467 | 2024.12.21 00:52:42.143520 [ 263 ] {4e68f0bc-3494-49e1-8135-5254355d1f3e} <Debug> oximeter.measurements_histogrami32 (51bdc364-54aa-45d0-be5d-00cd58eb47e1): Loading data parts | ||
468 | 2024.12.21 00:52:42.143898 [ 263 ] {4e68f0bc-3494-49e1-8135-5254355d1f3e} <Debug> oximeter.measurements_histogrami32 (51bdc364-54aa-45d0-be5d-00cd58eb47e1): There are no data parts | ||
469 | 2024.12.21 00:52:42.144611 [ 263 ] {4e68f0bc-3494-49e1-8135-5254355d1f3e} <Debug> TCPHandler: Processed in 0.003988599 sec. | ||
470 | 2024.12.21 00:52:42.155039 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
471 | 2024.12.21 00:52:42.155552 [ 262 ] {4c8e8747-802b-45fd-8130-1bd0556fd93f} <Debug> executeQuery: (from [::1]:48877) 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) | ||
472 | 2024.12.21 00:52:42.155665 [ 262 ] {4c8e8747-802b-45fd-8130-1bd0556fd93f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
473 | 2024.12.21 00:52:42.157718 [ 262 ] {4c8e8747-802b-45fd-8130-1bd0556fd93f} <Debug> oximeter.measurements_histogramu32 (1a1c066d-a4c4-464f-9d4e-c01b08c85dac): Loading data parts | ||
474 | 2024.12.21 00:52:42.158040 [ 262 ] {4c8e8747-802b-45fd-8130-1bd0556fd93f} <Debug> oximeter.measurements_histogramu32 (1a1c066d-a4c4-464f-9d4e-c01b08c85dac): There are no data parts | ||
475 | 2024.12.21 00:52:42.158745 [ 262 ] {4c8e8747-802b-45fd-8130-1bd0556fd93f} <Debug> TCPHandler: Processed in 0.003891816 sec. | ||
476 | 2024.12.21 00:52:42.162804 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
477 | 2024.12.21 00:52:42.163367 [ 263 ] {81171612-e4d4-4cc5-9639-1dffdc39b00a} <Debug> executeQuery: (from [::1]:42286) 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) | ||
478 | 2024.12.21 00:52:42.163474 [ 263 ] {81171612-e4d4-4cc5-9639-1dffdc39b00a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
479 | 2024.12.21 00:52:42.165461 [ 263 ] {81171612-e4d4-4cc5-9639-1dffdc39b00a} <Debug> oximeter.measurements_histogrami64 (5490ce7a-951a-4c8d-83f7-6dda34b6cb33): Loading data parts | ||
480 | 2024.12.21 00:52:42.165801 [ 263 ] {81171612-e4d4-4cc5-9639-1dffdc39b00a} <Debug> oximeter.measurements_histogrami64 (5490ce7a-951a-4c8d-83f7-6dda34b6cb33): There are no data parts | ||
481 | 2024.12.21 00:52:42.166477 [ 263 ] {81171612-e4d4-4cc5-9639-1dffdc39b00a} <Debug> TCPHandler: Processed in 0.003794253 sec. | ||
482 | 2024.12.21 00:52:42.168961 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
483 | 2024.12.21 00:52:42.169871 [ 262 ] {a0bfd145-6e65-46fb-b5b7-e97bbbcb8bfa} <Debug> executeQuery: (from [::1]:48877) 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) | ||
484 | 2024.12.21 00:52:42.170060 [ 262 ] {a0bfd145-6e65-46fb-b5b7-e97bbbcb8bfa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
485 | 2024.12.21 00:52:42.171987 [ 262 ] {a0bfd145-6e65-46fb-b5b7-e97bbbcb8bfa} <Debug> oximeter.measurements_histogramu64 (9e2c22c8-808f-4a63-abac-caddfbac738f): Loading data parts | ||
486 | 2024.12.21 00:52:42.172406 [ 262 ] {a0bfd145-6e65-46fb-b5b7-e97bbbcb8bfa} <Debug> oximeter.measurements_histogramu64 (9e2c22c8-808f-4a63-abac-caddfbac738f): There are no data parts | ||
487 | 2024.12.21 00:52:42.173118 [ 262 ] {a0bfd145-6e65-46fb-b5b7-e97bbbcb8bfa} <Debug> TCPHandler: Processed in 0.004234375 sec. | ||
488 | 2024.12.21 00:52:42.184277 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
489 | 2024.12.21 00:52:42.184863 [ 263 ] {fe384180-eb46-44e4-af37-ef94390f57cd} <Debug> executeQuery: (from [::1]:42286) 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) | ||
490 | 2024.12.21 00:52:42.185062 [ 263 ] {fe384180-eb46-44e4-af37-ef94390f57cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
491 | 2024.12.21 00:52:42.187159 [ 263 ] {fe384180-eb46-44e4-af37-ef94390f57cd} <Debug> oximeter.measurements_histogramf32 (819fe716-d502-4219-a14b-7ab071371e6d): Loading data parts | ||
492 | 2024.12.21 00:52:42.187508 [ 263 ] {fe384180-eb46-44e4-af37-ef94390f57cd} <Debug> oximeter.measurements_histogramf32 (819fe716-d502-4219-a14b-7ab071371e6d): There are no data parts | ||
493 | 2024.12.21 00:52:42.188110 [ 263 ] {fe384180-eb46-44e4-af37-ef94390f57cd} <Debug> TCPHandler: Processed in 0.004031621 sec. | ||
494 | 2024.12.21 00:52:42.190262 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
495 | 2024.12.21 00:52:42.190718 [ 262 ] {ab859441-ff61-43c7-aacc-ce0cbd2fbf07} <Debug> executeQuery: (from [::1]:48877) 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) | ||
496 | 2024.12.21 00:52:42.190861 [ 262 ] {ab859441-ff61-43c7-aacc-ce0cbd2fbf07} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
497 | 2024.12.21 00:52:42.192994 [ 262 ] {ab859441-ff61-43c7-aacc-ce0cbd2fbf07} <Debug> oximeter.measurements_histogramf64 (45e224d9-442b-447c-ad52-71b20cd73500): Loading data parts | ||
498 | 2024.12.21 00:52:42.193322 [ 262 ] {ab859441-ff61-43c7-aacc-ce0cbd2fbf07} <Debug> oximeter.measurements_histogramf64 (45e224d9-442b-447c-ad52-71b20cd73500): There are no data parts | ||
499 | 2024.12.21 00:52:42.193967 [ 262 ] {ab859441-ff61-43c7-aacc-ce0cbd2fbf07} <Debug> TCPHandler: Processed in 0.003902054 sec. | ||
500 | 2024.12.21 00:52:42.195156 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
501 | 2024.12.21 00:52:42.195458 [ 263 ] {44ad8aee-632b-4b53-b2ed-4b4d8b5402fb} <Debug> executeQuery: (from [::1]:42286) /* The field tables store named dimensions of each timeseries. | ||
502 | * | ||
503 | * As with the measurement tables, there is one field table for each field data | ||
504 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
505 | * this behavior **must not** be relied upon for query correctness. | ||
506 | * | ||
507 | * The index for the fields differs from the measurements, however. Rows are | ||
508 | * sorted by timeseries name, then field name, field value, and finally | ||
509 | * timeseries key. This reflects the most common pattern for looking them up: | ||
510 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
511 | * usually then used to look up measurements. | ||
512 | * | ||
513 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
514 | * timeseries name and then key, since it would improve lookups where one | ||
515 | * already has the key. Realistically though, these tables are quite small and | ||
516 | * so performance benefits will be low in absolute terms. | ||
517 | * | ||
518 | * TTL: We use a materialized column to expire old field table records. This | ||
519 | * column is generated automatically by the database whenever a new row is | ||
520 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
521 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
522 | * record will remain during a deduplication, which will have the last | ||
523 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
524 | * measurement tables. | ||
525 | */ | ||
526 | 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) | ||
527 | 2024.12.21 00:52:42.195554 [ 263 ] {44ad8aee-632b-4b53-b2ed-4b4d8b5402fb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
528 | 2024.12.21 00:52:42.199917 [ 263 ] {44ad8aee-632b-4b53-b2ed-4b4d8b5402fb} <Debug> oximeter.fields_bool (34831f95-3ca6-4bd6-ae8d-db49e55d6097): Loading data parts | ||
529 | 2024.12.21 00:52:42.200336 [ 263 ] {44ad8aee-632b-4b53-b2ed-4b4d8b5402fb} <Debug> oximeter.fields_bool (34831f95-3ca6-4bd6-ae8d-db49e55d6097): There are no data parts | ||
530 | 2024.12.21 00:52:42.200894 [ 263 ] {44ad8aee-632b-4b53-b2ed-4b4d8b5402fb} <Debug> TCPHandler: Processed in 0.005868229 sec. | ||
531 | 2024.12.21 00:52:42.202523 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
532 | 2024.12.21 00:52:42.202941 [ 262 ] {e25da295-d413-4bde-9190-863361a9fe88} <Debug> executeQuery: (from [::1]:48877) 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) | ||
533 | 2024.12.21 00:52:42.203027 [ 262 ] {e25da295-d413-4bde-9190-863361a9fe88} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
534 | 2024.12.21 00:52:42.204575 [ 262 ] {e25da295-d413-4bde-9190-863361a9fe88} <Debug> oximeter.fields_i8 (7932a8bf-007e-469d-8e5f-7694085bd9e8): Loading data parts | ||
535 | 2024.12.21 00:52:42.204849 [ 262 ] {e25da295-d413-4bde-9190-863361a9fe88} <Debug> oximeter.fields_i8 (7932a8bf-007e-469d-8e5f-7694085bd9e8): There are no data parts | ||
536 | 2024.12.21 00:52:42.206501 [ 262 ] {e25da295-d413-4bde-9190-863361a9fe88} <Debug> TCPHandler: Processed in 0.004085232 sec. | ||
537 | 2024.12.21 00:52:42.209970 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
538 | 2024.12.21 00:52:42.210301 [ 263 ] {e1f6eec0-3396-409b-a6b2-6f87950b82d9} <Debug> executeQuery: (from [::1]:42286) 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) | ||
539 | 2024.12.21 00:52:42.210387 [ 263 ] {e1f6eec0-3396-409b-a6b2-6f87950b82d9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
540 | 2024.12.21 00:52:42.211870 [ 263 ] {e1f6eec0-3396-409b-a6b2-6f87950b82d9} <Debug> oximeter.fields_u8 (1bce9ebe-277a-4160-bb94-bd6a7c1bdb40): Loading data parts | ||
541 | 2024.12.21 00:52:42.212264 [ 263 ] {e1f6eec0-3396-409b-a6b2-6f87950b82d9} <Debug> oximeter.fields_u8 (1bce9ebe-277a-4160-bb94-bd6a7c1bdb40): There are no data parts | ||
542 | 2024.12.21 00:52:42.212895 [ 263 ] {e1f6eec0-3396-409b-a6b2-6f87950b82d9} <Debug> TCPHandler: Processed in 0.003039946 sec. | ||
543 | 2024.12.21 00:52:42.213865 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
544 | 2024.12.21 00:52:42.214149 [ 262 ] {5b2a9ac4-59e1-4555-a265-3fcae8519446} <Debug> executeQuery: (from [::1]:48877) 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) | ||
545 | 2024.12.21 00:52:42.214217 [ 262 ] {5b2a9ac4-59e1-4555-a265-3fcae8519446} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
546 | 2024.12.21 00:52:42.215556 [ 262 ] {5b2a9ac4-59e1-4555-a265-3fcae8519446} <Debug> oximeter.fields_i16 (2bb67dbe-e7b3-4c69-91cf-888a2cf946f2): Loading data parts | ||
547 | 2024.12.21 00:52:42.215856 [ 262 ] {5b2a9ac4-59e1-4555-a265-3fcae8519446} <Debug> oximeter.fields_i16 (2bb67dbe-e7b3-4c69-91cf-888a2cf946f2): There are no data parts | ||
548 | 2024.12.21 00:52:42.216493 [ 262 ] {5b2a9ac4-59e1-4555-a265-3fcae8519446} <Debug> TCPHandler: Processed in 0.002694736 sec. | ||
549 | 2024.12.21 00:52:42.216962 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
550 | 2024.12.21 00:52:42.217344 [ 263 ] {8430c66c-25b0-4130-a979-d7e2a04798d2} <Debug> executeQuery: (from [::1]:42286) 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) | ||
551 | 2024.12.21 00:52:42.217494 [ 263 ] {8430c66c-25b0-4130-a979-d7e2a04798d2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
552 | 2024.12.21 00:52:42.218994 [ 263 ] {8430c66c-25b0-4130-a979-d7e2a04798d2} <Debug> oximeter.fields_u16 (5e93852f-0d5a-4bcc-b039-2dff4779822b): Loading data parts | ||
553 | 2024.12.21 00:52:42.219323 [ 263 ] {8430c66c-25b0-4130-a979-d7e2a04798d2} <Debug> oximeter.fields_u16 (5e93852f-0d5a-4bcc-b039-2dff4779822b): There are no data parts | ||
554 | 2024.12.21 00:52:42.219898 [ 263 ] {8430c66c-25b0-4130-a979-d7e2a04798d2} <Debug> TCPHandler: Processed in 0.003023408 sec. | ||
555 | 2024.12.21 00:52:42.220359 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
556 | 2024.12.21 00:52:42.220699 [ 262 ] {5ac89185-e3b7-44eb-af93-4c629653f040} <Debug> executeQuery: (from [::1]:48877) 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) | ||
557 | 2024.12.21 00:52:42.220818 [ 262 ] {5ac89185-e3b7-44eb-af93-4c629653f040} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
558 | 2024.12.21 00:52:42.222205 [ 262 ] {5ac89185-e3b7-44eb-af93-4c629653f040} <Debug> oximeter.fields_i32 (4a802d73-359e-4258-b84b-e09a137afbd9): Loading data parts | ||
559 | 2024.12.21 00:52:42.222466 [ 262 ] {5ac89185-e3b7-44eb-af93-4c629653f040} <Debug> oximeter.fields_i32 (4a802d73-359e-4258-b84b-e09a137afbd9): There are no data parts | ||
560 | 2024.12.21 00:52:42.223029 [ 262 ] {5ac89185-e3b7-44eb-af93-4c629653f040} <Debug> TCPHandler: Processed in 0.002725751 sec. | ||
561 | 2024.12.21 00:52:42.223548 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
562 | 2024.12.21 00:52:42.223751 [ 263 ] {16a95e82-e21b-4f4b-aead-292fd1a6be11} <Debug> executeQuery: (from [::1]:42286) 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) | ||
563 | 2024.12.21 00:52:42.223826 [ 263 ] {16a95e82-e21b-4f4b-aead-292fd1a6be11} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
564 | 2024.12.21 00:52:42.225398 [ 263 ] {16a95e82-e21b-4f4b-aead-292fd1a6be11} <Debug> oximeter.fields_u32 (b137c865-5957-4869-9303-93fd38081bb6): Loading data parts | ||
565 | 2024.12.21 00:52:42.225713 [ 263 ] {16a95e82-e21b-4f4b-aead-292fd1a6be11} <Debug> oximeter.fields_u32 (b137c865-5957-4869-9303-93fd38081bb6): There are no data parts | ||
566 | 2024.12.21 00:52:42.226264 [ 263 ] {16a95e82-e21b-4f4b-aead-292fd1a6be11} <Debug> TCPHandler: Processed in 0.002841151 sec. | ||
567 | 2024.12.21 00:52:42.226675 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
568 | 2024.12.21 00:52:42.226937 [ 262 ] {c5dfbc62-1a86-48e0-b515-19b7c944ada0} <Debug> executeQuery: (from [::1]:48877) 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) | ||
569 | 2024.12.21 00:52:42.227002 [ 262 ] {c5dfbc62-1a86-48e0-b515-19b7c944ada0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
570 | 2024.12.21 00:52:42.228475 [ 262 ] {c5dfbc62-1a86-48e0-b515-19b7c944ada0} <Debug> oximeter.fields_i64 (17a53df9-2750-4a05-9e05-083273717ccc): Loading data parts | ||
571 | 2024.12.21 00:52:42.228766 [ 262 ] {c5dfbc62-1a86-48e0-b515-19b7c944ada0} <Debug> oximeter.fields_i64 (17a53df9-2750-4a05-9e05-083273717ccc): There are no data parts | ||
572 | 2024.12.21 00:52:42.229325 [ 262 ] {c5dfbc62-1a86-48e0-b515-19b7c944ada0} <Debug> TCPHandler: Processed in 0.002725241 sec. | ||
573 | 2024.12.21 00:52:42.230020 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
574 | 2024.12.21 00:52:42.230327 [ 263 ] {2a4dfd97-e25a-4d58-8a4b-1debf121a7b1} <Debug> executeQuery: (from [::1]:42286) 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) | ||
575 | 2024.12.21 00:52:42.230414 [ 263 ] {2a4dfd97-e25a-4d58-8a4b-1debf121a7b1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
576 | 2024.12.21 00:52:42.232156 [ 263 ] {2a4dfd97-e25a-4d58-8a4b-1debf121a7b1} <Debug> oximeter.fields_u64 (a6add1c4-7dbf-4102-ab99-50e0fce3c3b4): Loading data parts | ||
577 | 2024.12.21 00:52:42.232505 [ 263 ] {2a4dfd97-e25a-4d58-8a4b-1debf121a7b1} <Debug> oximeter.fields_u64 (a6add1c4-7dbf-4102-ab99-50e0fce3c3b4): There are no data parts | ||
578 | 2024.12.21 00:52:42.233117 [ 263 ] {2a4dfd97-e25a-4d58-8a4b-1debf121a7b1} <Debug> TCPHandler: Processed in 0.003281413 sec. | ||
579 | 2024.12.21 00:52:42.233850 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
580 | 2024.12.21 00:52:42.234167 [ 262 ] {0412351c-69ad-46b6-825d-3ed8c9cc79cd} <Debug> executeQuery: (from [::1]:48877) 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) | ||
581 | 2024.12.21 00:52:42.234256 [ 262 ] {0412351c-69ad-46b6-825d-3ed8c9cc79cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
582 | 2024.12.21 00:52:42.235828 [ 262 ] {0412351c-69ad-46b6-825d-3ed8c9cc79cd} <Debug> oximeter.fields_ipaddr (def4cf28-ea2d-4134-b962-7c7c3390c5d6): Loading data parts | ||
583 | 2024.12.21 00:52:42.236196 [ 262 ] {0412351c-69ad-46b6-825d-3ed8c9cc79cd} <Debug> oximeter.fields_ipaddr (def4cf28-ea2d-4134-b962-7c7c3390c5d6): There are no data parts | ||
584 | 2024.12.21 00:52:42.236784 [ 262 ] {0412351c-69ad-46b6-825d-3ed8c9cc79cd} <Debug> TCPHandler: Processed in 0.003027888 sec. | ||
585 | 2024.12.21 00:52:42.237715 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
586 | 2024.12.21 00:52:42.237987 [ 263 ] {c9ba17cf-24cb-4130-b55f-0186b4a13d9d} <Debug> executeQuery: (from [::1]:42286) 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) | ||
587 | 2024.12.21 00:52:42.238086 [ 263 ] {c9ba17cf-24cb-4130-b55f-0186b4a13d9d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
588 | 2024.12.21 00:52:42.240033 [ 263 ] {c9ba17cf-24cb-4130-b55f-0186b4a13d9d} <Debug> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Loading data parts | ||
589 | 2024.12.21 00:52:42.240345 [ 263 ] {c9ba17cf-24cb-4130-b55f-0186b4a13d9d} <Debug> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): There are no data parts | ||
590 | 2024.12.21 00:52:42.240989 [ 263 ] {c9ba17cf-24cb-4130-b55f-0186b4a13d9d} <Debug> TCPHandler: Processed in 0.003361449 sec. | ||
591 | 2024.12.21 00:52:42.241703 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
592 | 2024.12.21 00:52:42.242003 [ 262 ] {b35e8eea-8544-4c8e-b9b0-13ed32bba96a} <Debug> executeQuery: (from [::1]:48877) 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) | ||
593 | 2024.12.21 00:52:42.242084 [ 262 ] {b35e8eea-8544-4c8e-b9b0-13ed32bba96a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
594 | 2024.12.21 00:52:42.243619 [ 262 ] {b35e8eea-8544-4c8e-b9b0-13ed32bba96a} <Debug> oximeter.fields_uuid (ba8194fa-9c16-4a56-9c0b-d2624827167b): Loading data parts | ||
595 | 2024.12.21 00:52:42.243930 [ 262 ] {b35e8eea-8544-4c8e-b9b0-13ed32bba96a} <Debug> oximeter.fields_uuid (ba8194fa-9c16-4a56-9c0b-d2624827167b): There are no data parts | ||
596 | 2024.12.21 00:52:42.244512 [ 262 ] {b35e8eea-8544-4c8e-b9b0-13ed32bba96a} <Debug> TCPHandler: Processed in 0.002895151 sec. | ||
597 | 2024.12.21 00:52:42.245630 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
598 | 2024.12.21 00:52:42.246022 [ 263 ] {aa6cf675-a715-490e-9ba6-1f8c17d4ecc5} <Debug> executeQuery: (from [::1]:42286) /* The timeseries schema table stores the extracted schema for the samples | ||
599 | * oximeter collects. | ||
600 | */ | ||
601 | 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) | ||
602 | 2024.12.21 00:52:42.246242 [ 263 ] {aa6cf675-a715-490e-9ba6-1f8c17d4ecc5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
603 | 2024.12.21 00:52:42.247722 [ 263 ] {aa6cf675-a715-490e-9ba6-1f8c17d4ecc5} <Debug> oximeter.timeseries_schema (aba7817f-fd4d-484a-86c3-ed8b53a1a39f): Loading data parts | ||
604 | 2024.12.21 00:52:42.248045 [ 263 ] {aa6cf675-a715-490e-9ba6-1f8c17d4ecc5} <Debug> oximeter.timeseries_schema (aba7817f-fd4d-484a-86c3-ed8b53a1a39f): There are no data parts | ||
605 | 2024.12.21 00:52:42.248832 [ 263 ] {aa6cf675-a715-490e-9ba6-1f8c17d4ecc5} <Debug> TCPHandler: Processed in 0.003312677 sec. | ||
606 | 2024.12.21 00:52:42.249499 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
607 | 2024.12.21 00:52:42.249697 [ 262 ] {94528158-d0ac-456a-bb8d-89e580568f18} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
608 | 2024.12.21 00:52:42.249832 [ 262 ] {94528158-d0ac-456a-bb8d-89e580568f18} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
609 | 2024.12.21 00:52:42.251397 [ 270 ] {94528158-d0ac-456a-bb8d-89e580568f18} <Trace> oximeter.version (ceb3c345-e14a-424c-aa55-746c37c1faba): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
610 | 2024.12.21 00:52:42.251447 [ 270 ] {94528158-d0ac-456a-bb8d-89e580568f18} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.41 GiB. | ||
611 | 2024.12.21 00:52:42.252163 [ 270 ] {94528158-d0ac-456a-bb8d-89e580568f18} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
612 | 2024.12.21 00:52:42.252551 [ 270 ] {94528158-d0ac-456a-bb8d-89e580568f18} <Trace> oximeter.version (ceb3c345-e14a-424c-aa55-746c37c1faba): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
613 | 2024.12.21 00:52:42.252794 [ 262 ] {94528158-d0ac-456a-bb8d-89e580568f18} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003177 sec., 314.7623544224111 rows/sec., 4.92 KiB/sec. | ||
614 | 2024.12.21 00:52:42.253004 [ 262 ] {94528158-d0ac-456a-bb8d-89e580568f18} <Debug> TCPHandler: Processed in 0.003601327 sec. | ||
615 | 2024.12.21 00:52:44.422329 [ 163 ] {} <Debug> DNSResolver: Updating DNS cache | ||
616 | 2024.12.21 00:52:44.422385 [ 163 ] {} <Debug> DNSResolver: Updated DNS cache | ||
617 | 2024.12.21 00:52:44.447617 [ 242 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 976 | ||
618 | 2024.12.21 00:52:44.448912 [ 242 ] {} <Trace> system.asynchronous_metric_log (c0262210-8702-4e25-8006-eb8dc4b0b04b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
619 | 2024.12.21 00:52:44.448985 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.40 GiB. | ||
620 | 2024.12.21 00:52:44.449882 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
621 | 2024.12.21 00:52:44.450334 [ 242 ] {} <Trace> system.asynchronous_metric_log (c0262210-8702-4e25-8006-eb8dc4b0b04b): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
622 | 2024.12.21 00:52:44.450638 [ 242 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 976 | ||
623 | 2024.12.21 00:52:44.518487 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16 | ||
624 | 2024.12.21 00:52:44.554055 [ 245 ] {} <Trace> system.metric_log (d82126f2-4ccb-440b-93e7-9c027a1e05e1): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
625 | 2024.12.21 00:52:44.554146 [ 245 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.40 GiB. | ||
626 | 2024.12.21 00:52:44.580717 [ 245 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
627 | 2024.12.21 00:52:44.582387 [ 245 ] {} <Trace> system.metric_log (d82126f2-4ccb-440b-93e7-9c027a1e05e1): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
628 | 2024.12.21 00:52:44.592838 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 16 | ||
629 | 2024.12.21 00:52:45.000424 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 149.52 MiB, peak 153.52 MiB, free memory in arenas 0.00 B, will set to 152.90 MiB (RSS), difference: 3.38 MiB | ||
630 | 2024.12.21 00:52:47.314060 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
631 | 2024.12.21 00:52:47.314287 [ 262 ] {98639f65-deb8-4634-90a8-9042fa481ca3} <Debug> executeQuery: (from [::1]:48877) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
632 | 2024.12.21 00:52:47.314863 [ 262 ] {98639f65-deb8-4634-90a8-9042fa481ca3} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
633 | 2024.12.21 00:52:47.315031 [ 262 ] {98639f65-deb8-4634-90a8-9042fa481ca3} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
634 | 2024.12.21 00:52:47.315947 [ 262 ] {98639f65-deb8-4634-90a8-9042fa481ca3} <Debug> TCPHandler: Processed in 0.002092652 sec. | ||
635 | 2024.12.21 00:52:47.435074 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
636 | 2024.12.21 00:52:47.435344 [ 263 ] {4dde70dc-2f8e-4b1a-9d96-86235ba50246} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
637 | 2024.12.21 00:52:47.435506 [ 263 ] {4dde70dc-2f8e-4b1a-9d96-86235ba50246} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
638 | 2024.12.21 00:52:47.439287 [ 263 ] {4dde70dc-2f8e-4b1a-9d96-86235ba50246} <Trace> oximeter.timeseries_schema (aba7817f-fd4d-484a-86c3-ed8b53a1a39f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
639 | 2024.12.21 00:52:47.439413 [ 263 ] {4dde70dc-2f8e-4b1a-9d96-86235ba50246} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.40 GiB. | ||
640 | 2024.12.21 00:52:47.440292 [ 263 ] {4dde70dc-2f8e-4b1a-9d96-86235ba50246} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
641 | 2024.12.21 00:52:47.440669 [ 263 ] {4dde70dc-2f8e-4b1a-9d96-86235ba50246} <Trace> oximeter.timeseries_schema (aba7817f-fd4d-484a-86c3-ed8b53a1a39f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
642 | 2024.12.21 00:52:47.440968 [ 263 ] {4dde70dc-2f8e-4b1a-9d96-86235ba50246} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.005735 sec., 174.3679163034002 rows/sec., 20.94 KiB/sec. | ||
643 | 2024.12.21 00:52:47.441056 [ 263 ] {4dde70dc-2f8e-4b1a-9d96-86235ba50246} <Debug> TCPHandler: Processed in 0.006175394 sec. | ||
644 | 2024.12.21 00:52:47.449999 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
645 | 2024.12.21 00:52:47.450277 [ 262 ] {768ede10-70c8-430e-a8b3-8007ea6b721c} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
646 | 2024.12.21 00:52:47.450362 [ 262 ] {768ede10-70c8-430e-a8b3-8007ea6b721c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
647 | 2024.12.21 00:52:47.478374 [ 262 ] {768ede10-70c8-430e-a8b3-8007ea6b721c} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
648 | 2024.12.21 00:52:47.478462 [ 262 ] {768ede10-70c8-430e-a8b3-8007ea6b721c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.40 GiB. | ||
649 | 2024.12.21 00:52:47.479089 [ 262 ] {768ede10-70c8-430e-a8b3-8007ea6b721c} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
650 | 2024.12.21 00:52:47.479469 [ 262 ] {768ede10-70c8-430e-a8b3-8007ea6b721c} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
651 | 2024.12.21 00:52:47.479792 [ 262 ] {768ede10-70c8-430e-a8b3-8007ea6b721c} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.029582 sec., 67.60868095463458 rows/sec., 7.00 KiB/sec. | ||
652 | 2024.12.21 00:52:47.479917 [ 262 ] {768ede10-70c8-430e-a8b3-8007ea6b721c} <Debug> TCPHandler: Processed in 0.030072563 sec. | ||
653 | 2024.12.21 00:52:47.485108 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
654 | 2024.12.21 00:52:47.485375 [ 263 ] {860a693c-87be-4787-8481-5ff6f362f2a9} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
655 | 2024.12.21 00:52:47.485488 [ 263 ] {860a693c-87be-4787-8481-5ff6f362f2a9} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
656 | 2024.12.21 00:52:47.501991 [ 263 ] {860a693c-87be-4787-8481-5ff6f362f2a9} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
657 | 2024.12.21 00:52:47.502056 [ 263 ] {860a693c-87be-4787-8481-5ff6f362f2a9} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.40 GiB. | ||
658 | 2024.12.21 00:52:47.502760 [ 263 ] {860a693c-87be-4787-8481-5ff6f362f2a9} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
659 | 2024.12.21 00:52:47.503181 [ 263 ] {860a693c-87be-4787-8481-5ff6f362f2a9} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
660 | 2024.12.21 00:52:47.503442 [ 263 ] {860a693c-87be-4787-8481-5ff6f362f2a9} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.01814 sec., 55.12679162072767 rows/sec., 3.82 KiB/sec. | ||
661 | 2024.12.21 00:52:47.503549 [ 263 ] {860a693c-87be-4787-8481-5ff6f362f2a9} <Debug> TCPHandler: Processed in 0.018645881 sec. | ||
662 | 2024.12.21 00:52:48.259415 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
663 | 2024.12.21 00:52:48.259680 [ 262 ] {497e63d4-3423-4663-9549-4c51b60c4a0f} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
664 | 2024.12.21 00:52:48.259784 [ 262 ] {497e63d4-3423-4663-9549-4c51b60c4a0f} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
665 | 2024.12.21 00:52:48.262196 [ 262 ] {497e63d4-3423-4663-9549-4c51b60c4a0f} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
666 | 2024.12.21 00:52:48.262265 [ 262 ] {497e63d4-3423-4663-9549-4c51b60c4a0f} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.40 GiB. | ||
667 | 2024.12.21 00:52:48.263005 [ 262 ] {497e63d4-3423-4663-9549-4c51b60c4a0f} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
668 | 2024.12.21 00:52:48.263407 [ 262 ] {497e63d4-3423-4663-9549-4c51b60c4a0f} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
669 | 2024.12.21 00:52:48.263727 [ 262 ] {497e63d4-3423-4663-9549-4c51b60c4a0f} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004117 sec., 485.7906242409521 rows/sec., 50.29 KiB/sec. | ||
670 | 2024.12.21 00:52:48.263861 [ 262 ] {497e63d4-3423-4663-9549-4c51b60c4a0f} <Debug> TCPHandler: Processed in 0.004640314 sec. | ||
671 | 2024.12.21 00:52:48.264748 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
672 | 2024.12.21 00:52:48.264913 [ 263 ] {0ef0ca92-9f02-4a4a-850b-bcd767869f50} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
673 | 2024.12.21 00:52:48.264980 [ 263 ] {0ef0ca92-9f02-4a4a-850b-bcd767869f50} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
674 | 2024.12.21 00:52:48.266631 [ 263 ] {0ef0ca92-9f02-4a4a-850b-bcd767869f50} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
675 | 2024.12.21 00:52:48.266692 [ 263 ] {0ef0ca92-9f02-4a4a-850b-bcd767869f50} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.40 GiB. | ||
676 | 2024.12.21 00:52:48.267267 [ 263 ] {0ef0ca92-9f02-4a4a-850b-bcd767869f50} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
677 | 2024.12.21 00:52:48.267870 [ 263 ] {0ef0ca92-9f02-4a4a-850b-bcd767869f50} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
678 | 2024.12.21 00:52:48.268137 [ 263 ] {0ef0ca92-9f02-4a4a-850b-bcd767869f50} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003266 sec., 306.1849357011635 rows/sec., 21.23 KiB/sec. | ||
679 | 2024.12.21 00:52:48.268213 [ 263 ] {0ef0ca92-9f02-4a4a-850b-bcd767869f50} <Debug> TCPHandler: Processed in 0.003568753 sec. | ||
680 | 2024.12.21 00:52:49.260120 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
681 | 2024.12.21 00:52:49.260340 [ 262 ] {968c0ad9-6fd7-4df5-a553-d90410b7a37c} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
682 | 2024.12.21 00:52:49.260428 [ 262 ] {968c0ad9-6fd7-4df5-a553-d90410b7a37c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
683 | 2024.12.21 00:52:49.269836 [ 262 ] {968c0ad9-6fd7-4df5-a553-d90410b7a37c} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
684 | 2024.12.21 00:52:49.269895 [ 262 ] {968c0ad9-6fd7-4df5-a553-d90410b7a37c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
685 | 2024.12.21 00:52:49.270544 [ 262 ] {968c0ad9-6fd7-4df5-a553-d90410b7a37c} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
686 | 2024.12.21 00:52:49.270917 [ 262 ] {968c0ad9-6fd7-4df5-a553-d90410b7a37c} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
687 | 2024.12.21 00:52:49.271225 [ 262 ] {968c0ad9-6fd7-4df5-a553-d90410b7a37c} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.010951 sec., 182.63172313030773 rows/sec., 18.91 KiB/sec. | ||
688 | 2024.12.21 00:52:49.271370 [ 262 ] {968c0ad9-6fd7-4df5-a553-d90410b7a37c} <Debug> TCPHandler: Processed in 0.011445558 sec. | ||
689 | 2024.12.21 00:52:49.272438 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
690 | 2024.12.21 00:52:49.272634 [ 263 ] {1c287949-087a-4ee8-961c-57ed71124698} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
691 | 2024.12.21 00:52:49.272737 [ 263 ] {1c287949-087a-4ee8-961c-57ed71124698} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
692 | 2024.12.21 00:52:49.273599 [ 263 ] {1c287949-087a-4ee8-961c-57ed71124698} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
693 | 2024.12.21 00:52:49.273666 [ 263 ] {1c287949-087a-4ee8-961c-57ed71124698} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
694 | 2024.12.21 00:52:49.274232 [ 263 ] {1c287949-087a-4ee8-961c-57ed71124698} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
695 | 2024.12.21 00:52:49.274661 [ 263 ] {1c287949-087a-4ee8-961c-57ed71124698} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
696 | 2024.12.21 00:52:49.274949 [ 263 ] {1c287949-087a-4ee8-961c-57ed71124698} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002375 sec., 421.0526315789474 rows/sec., 29.19 KiB/sec. | ||
697 | 2024.12.21 00:52:49.275031 [ 263 ] {1c287949-087a-4ee8-961c-57ed71124698} <Debug> TCPHandler: Processed in 0.002766263 sec. | ||
698 | 2024.12.21 00:52:49.432759 [ 244 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 106 entries to flush up to offset 106 | ||
699 | 2024.12.21 00:52:49.432875 [ 244 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
700 | 2024.12.21 00:52:49.437542 [ 244 ] {} <Debug> system.query_log (2ec0c822-94fd-4923-bbbd-bc345335f962): Loading data parts | ||
701 | 2024.12.21 00:52:49.437813 [ 244 ] {} <Debug> system.query_log (2ec0c822-94fd-4923-bbbd-bc345335f962): There are no data parts | ||
702 | 2024.12.21 00:52:49.445455 [ 244 ] {} <Trace> system.query_log (2ec0c822-94fd-4923-bbbd-bc345335f962): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
703 | 2024.12.21 00:52:49.445527 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
704 | 2024.12.21 00:52:49.447799 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
705 | 2024.12.21 00:52:49.448372 [ 244 ] {} <Trace> system.query_log (2ec0c822-94fd-4923-bbbd-bc345335f962): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
706 | 2024.12.21 00:52:49.449168 [ 244 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 106 | ||
707 | 2024.12.21 00:52:50.000246 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 157.63 MiB, peak 157.63 MiB, free memory in arenas 0.00 B, will set to 153.55 MiB (RSS), difference: -4.08 MiB | ||
708 | 2024.12.21 00:52:50.258573 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
709 | 2024.12.21 00:52:50.258834 [ 262 ] {eda74732-5f4f-4b65-9737-3fe47f475deb} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
710 | 2024.12.21 00:52:50.258932 [ 262 ] {eda74732-5f4f-4b65-9737-3fe47f475deb} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
711 | 2024.12.21 00:52:50.260226 [ 262 ] {eda74732-5f4f-4b65-9737-3fe47f475deb} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
712 | 2024.12.21 00:52:50.260315 [ 262 ] {eda74732-5f4f-4b65-9737-3fe47f475deb} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
713 | 2024.12.21 00:52:50.260989 [ 262 ] {eda74732-5f4f-4b65-9737-3fe47f475deb} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
714 | 2024.12.21 00:52:50.261443 [ 262 ] {eda74732-5f4f-4b65-9737-3fe47f475deb} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
715 | 2024.12.21 00:52:50.261746 [ 262 ] {eda74732-5f4f-4b65-9737-3fe47f475deb} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002986 sec., 669.7923643670463 rows/sec., 69.33 KiB/sec. | ||
716 | 2024.12.21 00:52:50.261829 [ 262 ] {eda74732-5f4f-4b65-9737-3fe47f475deb} <Debug> TCPHandler: Processed in 0.003461352 sec. | ||
717 | 2024.12.21 00:52:50.263374 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
718 | 2024.12.21 00:52:50.263577 [ 263 ] {c8130e85-72a1-4bad-b492-9b9e49422b0f} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
719 | 2024.12.21 00:52:50.263650 [ 263 ] {c8130e85-72a1-4bad-b492-9b9e49422b0f} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
720 | 2024.12.21 00:52:50.265431 [ 263 ] {c8130e85-72a1-4bad-b492-9b9e49422b0f} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
721 | 2024.12.21 00:52:50.265485 [ 263 ] {c8130e85-72a1-4bad-b492-9b9e49422b0f} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
722 | 2024.12.21 00:52:50.266142 [ 263 ] {c8130e85-72a1-4bad-b492-9b9e49422b0f} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
723 | 2024.12.21 00:52:50.266622 [ 263 ] {c8130e85-72a1-4bad-b492-9b9e49422b0f} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
724 | 2024.12.21 00:52:50.266973 [ 263 ] {c8130e85-72a1-4bad-b492-9b9e49422b0f} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003476 sec., 287.68699654775605 rows/sec., 19.95 KiB/sec. | ||
725 | 2024.12.21 00:52:50.267063 [ 263 ] {c8130e85-72a1-4bad-b492-9b9e49422b0f} <Debug> TCPHandler: Processed in 0.00380644 sec. | ||
726 | 2024.12.21 00:52:51.263855 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
727 | 2024.12.21 00:52:51.264067 [ 262 ] {3c8d5c1a-d641-494b-8a1a-6b54673091dc} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
728 | 2024.12.21 00:52:51.264194 [ 262 ] {3c8d5c1a-d641-494b-8a1a-6b54673091dc} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
729 | 2024.12.21 00:52:51.265492 [ 262 ] {3c8d5c1a-d641-494b-8a1a-6b54673091dc} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
730 | 2024.12.21 00:52:51.265553 [ 262 ] {3c8d5c1a-d641-494b-8a1a-6b54673091dc} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
731 | 2024.12.21 00:52:51.266207 [ 262 ] {3c8d5c1a-d641-494b-8a1a-6b54673091dc} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
732 | 2024.12.21 00:52:51.266648 [ 262 ] {3c8d5c1a-d641-494b-8a1a-6b54673091dc} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
733 | 2024.12.21 00:52:51.266885 [ 95 ] {} <Debug> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
734 | 2024.12.21 00:52:51.266957 [ 262 ] {3c8d5c1a-d641-494b-8a1a-6b54673091dc} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002938 sec., 680.7351940095302 rows/sec., 70.47 KiB/sec. | ||
735 | 2024.12.21 00:52:51.266966 [ 95 ] {} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
736 | 2024.12.21 00:52:51.267006 [ 95 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
737 | 2024.12.21 00:52:51.267062 [ 262 ] {3c8d5c1a-d641-494b-8a1a-6b54673091dc} <Debug> TCPHandler: Processed in 0.003392403 sec. | ||
738 | 2024.12.21 00:52:51.267229 [ 188 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::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 | ||
739 | 2024.12.21 00:52:51.267378 [ 188 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
740 | 2024.12.21 00:52:51.267441 [ 188 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::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 | ||
741 | 2024.12.21 00:52:51.267656 [ 188 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::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 | ||
742 | 2024.12.21 00:52:51.267748 [ 188 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::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 | ||
743 | 2024.12.21 00:52:51.267918 [ 188 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::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 | ||
744 | 2024.12.21 00:52:51.268093 [ 188 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::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 | ||
745 | 2024.12.21 00:52:51.269307 [ 196 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 10 rows, containing 5 columns (5 merged, 0 gathered) in 0.002178487 sec., 4590.34182898498 rows/sec., 493.10 KiB/sec. | ||
746 | 2024.12.21 00:52:51.269502 [ 191 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
747 | 2024.12.21 00:52:51.269918 [ 191 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::all_1_5_1} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
748 | 2024.12.21 00:52:51.270024 [ 191 ] {cc4ff96d-39d2-405c-9e0e-376e2a3bec15::all_1_5_1} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
749 | 2024.12.21 00:52:51.270122 [ 191 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.32 MiB. | ||
750 | 2024.12.21 00:52:51.271047 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
751 | 2024.12.21 00:52:51.271220 [ 263 ] {d5993132-1446-450b-a537-70b73f4245d5} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
752 | 2024.12.21 00:52:51.271295 [ 263 ] {d5993132-1446-450b-a537-70b73f4245d5} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
753 | 2024.12.21 00:52:51.273770 [ 263 ] {d5993132-1446-450b-a537-70b73f4245d5} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
754 | 2024.12.21 00:52:51.273819 [ 263 ] {d5993132-1446-450b-a537-70b73f4245d5} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
755 | 2024.12.21 00:52:51.274442 [ 263 ] {d5993132-1446-450b-a537-70b73f4245d5} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
756 | 2024.12.21 00:52:51.274838 [ 263 ] {d5993132-1446-450b-a537-70b73f4245d5} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
757 | 2024.12.21 00:52:51.275101 [ 95 ] {} <Debug> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
758 | 2024.12.21 00:52:51.275142 [ 95 ] {} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
759 | 2024.12.21 00:52:51.275170 [ 263 ] {d5993132-1446-450b-a537-70b73f4245d5} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.004 sec., 250 rows/sec., 17.33 KiB/sec. | ||
760 | 2024.12.21 00:52:51.275181 [ 95 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
761 | 2024.12.21 00:52:51.275260 [ 263 ] {d5993132-1446-450b-a537-70b73f4245d5} <Debug> TCPHandler: Processed in 0.004372362 sec. | ||
762 | 2024.12.21 00:52:51.275406 [ 193 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::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 | ||
763 | 2024.12.21 00:52:51.275538 [ 193 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
764 | 2024.12.21 00:52:51.275582 [ 193 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::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 | ||
765 | 2024.12.21 00:52:51.275700 [ 193 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::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 | ||
766 | 2024.12.21 00:52:51.275816 [ 193 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::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 | ||
767 | 2024.12.21 00:52:51.275991 [ 193 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::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 | ||
768 | 2024.12.21 00:52:51.276118 [ 193 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::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 | ||
769 | 2024.12.21 00:52:51.277540 [ 188 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 5 rows, containing 4 columns (4 merged, 0 gathered) in 0.002252514 sec., 2219.742030460188 rows/sec., 153.91 KiB/sec. | ||
770 | 2024.12.21 00:52:51.277706 [ 188 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
771 | 2024.12.21 00:52:51.278140 [ 188 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::all_1_5_1} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
772 | 2024.12.21 00:52:51.278251 [ 188 ] {bf645b0e-7a7a-40be-aab5-5ee2f1ca719c::all_1_5_1} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
773 | 2024.12.21 00:52:51.278336 [ 188 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.24 MiB. | ||
774 | 2024.12.21 00:52:51.950805 [ 242 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 427 entries to flush up to offset 1403 | ||
775 | 2024.12.21 00:52:51.951654 [ 242 ] {} <Trace> system.asynchronous_metric_log (c0262210-8702-4e25-8006-eb8dc4b0b04b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
776 | 2024.12.21 00:52:51.951713 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
777 | 2024.12.21 00:52:51.952572 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
778 | 2024.12.21 00:52:51.952950 [ 242 ] {} <Trace> system.asynchronous_metric_log (c0262210-8702-4e25-8006-eb8dc4b0b04b): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
779 | 2024.12.21 00:52:51.953220 [ 242 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1403 | ||
780 | 2024.12.21 00:52:52.092974 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 7 entries to flush up to offset 23 | ||
781 | 2024.12.21 00:52:52.127636 [ 245 ] {} <Trace> system.metric_log (d82126f2-4ccb-440b-93e7-9c027a1e05e1): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
782 | 2024.12.21 00:52:52.127700 [ 245 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
783 | 2024.12.21 00:52:52.140644 [ 245 ] {} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
784 | 2024.12.21 00:52:52.142610 [ 245 ] {} <Trace> system.metric_log (d82126f2-4ccb-440b-93e7-9c027a1e05e1): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
785 | 2024.12.21 00:52:52.149584 [ 245 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 23 | ||
786 | 2024.12.21 00:52:52.259071 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
787 | 2024.12.21 00:52:52.259302 [ 262 ] {2c07372c-5a9d-48e7-998b-f2bddb98ae20} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
788 | 2024.12.21 00:52:52.259393 [ 262 ] {2c07372c-5a9d-48e7-998b-f2bddb98ae20} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
789 | 2024.12.21 00:52:52.261351 [ 262 ] {2c07372c-5a9d-48e7-998b-f2bddb98ae20} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
790 | 2024.12.21 00:52:52.261404 [ 262 ] {2c07372c-5a9d-48e7-998b-f2bddb98ae20} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
791 | 2024.12.21 00:52:52.262094 [ 262 ] {2c07372c-5a9d-48e7-998b-f2bddb98ae20} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
792 | 2024.12.21 00:52:52.262535 [ 262 ] {2c07372c-5a9d-48e7-998b-f2bddb98ae20} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
793 | 2024.12.21 00:52:52.262780 [ 262 ] {2c07372c-5a9d-48e7-998b-f2bddb98ae20} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003556 sec., 562.429696287964 rows/sec., 58.22 KiB/sec. | ||
794 | 2024.12.21 00:52:52.262849 [ 262 ] {2c07372c-5a9d-48e7-998b-f2bddb98ae20} <Debug> TCPHandler: Processed in 0.003969082 sec. | ||
795 | 2024.12.21 00:52:52.263408 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
796 | 2024.12.21 00:52:52.263572 [ 263 ] {2f75a64a-d406-4a24-9fbf-72b8e7572dfc} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
797 | 2024.12.21 00:52:52.263645 [ 263 ] {2f75a64a-d406-4a24-9fbf-72b8e7572dfc} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
798 | 2024.12.21 00:52:52.264556 [ 263 ] {2f75a64a-d406-4a24-9fbf-72b8e7572dfc} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
799 | 2024.12.21 00:52:52.264606 [ 263 ] {2f75a64a-d406-4a24-9fbf-72b8e7572dfc} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.38 GiB. | ||
800 | 2024.12.21 00:52:52.265224 [ 263 ] {2f75a64a-d406-4a24-9fbf-72b8e7572dfc} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
801 | 2024.12.21 00:52:52.265652 [ 263 ] {2f75a64a-d406-4a24-9fbf-72b8e7572dfc} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
802 | 2024.12.21 00:52:52.265902 [ 263 ] {2f75a64a-d406-4a24-9fbf-72b8e7572dfc} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002372 sec., 421.5851602023609 rows/sec., 29.23 KiB/sec. | ||
803 | 2024.12.21 00:52:52.265967 [ 263 ] {2f75a64a-d406-4a24-9fbf-72b8e7572dfc} <Debug> TCPHandler: Processed in 0.002696096 sec. | ||
804 | 2024.12.21 00:52:53.000453 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 154.58 MiB, peak 158.44 MiB, free memory in arenas 0.00 B, will set to 155.98 MiB (RSS), difference: 1.40 MiB | ||
805 | 2024.12.21 00:52:53.259769 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
806 | 2024.12.21 00:52:53.260014 [ 262 ] {0da6983d-3320-4cab-bbcc-733da05996aa} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
807 | 2024.12.21 00:52:53.260139 [ 262 ] {0da6983d-3320-4cab-bbcc-733da05996aa} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
808 | 2024.12.21 00:52:53.261875 [ 262 ] {0da6983d-3320-4cab-bbcc-733da05996aa} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
809 | 2024.12.21 00:52:53.261993 [ 262 ] {0da6983d-3320-4cab-bbcc-733da05996aa} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.39 GiB. | ||
810 | 2024.12.21 00:52:53.262512 [ 262 ] {0da6983d-3320-4cab-bbcc-733da05996aa} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
811 | 2024.12.21 00:52:53.262982 [ 262 ] {0da6983d-3320-4cab-bbcc-733da05996aa} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
812 | 2024.12.21 00:52:53.263233 [ 262 ] {0da6983d-3320-4cab-bbcc-733da05996aa} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003294 sec., 607.1645415907711 rows/sec., 62.85 KiB/sec. | ||
813 | 2024.12.21 00:52:53.263361 [ 262 ] {0da6983d-3320-4cab-bbcc-733da05996aa} <Debug> TCPHandler: Processed in 0.003793793 sec. | ||
814 | 2024.12.21 00:52:53.264284 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
815 | 2024.12.21 00:52:53.264463 [ 263 ] {388671f1-370c-48bc-8dff-35a1277f8894} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
816 | 2024.12.21 00:52:53.264569 [ 263 ] {388671f1-370c-48bc-8dff-35a1277f8894} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
817 | 2024.12.21 00:52:53.265500 [ 263 ] {388671f1-370c-48bc-8dff-35a1277f8894} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
818 | 2024.12.21 00:52:53.265544 [ 263 ] {388671f1-370c-48bc-8dff-35a1277f8894} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.39 GiB. | ||
819 | 2024.12.21 00:52:53.266083 [ 263 ] {388671f1-370c-48bc-8dff-35a1277f8894} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
820 | 2024.12.21 00:52:53.266471 [ 263 ] {388671f1-370c-48bc-8dff-35a1277f8894} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
821 | 2024.12.21 00:52:53.266970 [ 263 ] {388671f1-370c-48bc-8dff-35a1277f8894} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002556 sec., 391.23630672926447 rows/sec., 27.13 KiB/sec. | ||
822 | 2024.12.21 00:52:53.267078 [ 263 ] {388671f1-370c-48bc-8dff-35a1277f8894} <Debug> TCPHandler: Processed in 0.002932624 sec. | ||
823 | 2024.12.21 00:52:54.259112 [ 262 ] {} <Trace> TCP-Session: 1df90cba-2413-41da-a4c8-d525ac445862 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
824 | 2024.12.21 00:52:54.259294 [ 262 ] {8958d239-c283-4123-9f37-b3b73dcf32de} <Debug> executeQuery: (from [::1]:48877) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
825 | 2024.12.21 00:52:54.259369 [ 262 ] {8958d239-c283-4123-9f37-b3b73dcf32de} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
826 | 2024.12.21 00:52:54.260539 [ 262 ] {8958d239-c283-4123-9f37-b3b73dcf32de} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
827 | 2024.12.21 00:52:54.260594 [ 262 ] {8958d239-c283-4123-9f37-b3b73dcf32de} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.37 GiB. | ||
828 | 2024.12.21 00:52:54.261182 [ 262 ] {8958d239-c283-4123-9f37-b3b73dcf32de} <Trace> MergedBlockOutputStream: filled checksums all_8_8_0 (state Temporary) | ||
829 | 2024.12.21 00:52:54.261601 [ 262 ] {8958d239-c283-4123-9f37-b3b73dcf32de} <Trace> oximeter.fields_string (cc4ff96d-39d2-405c-9e0e-376e2a3bec15): Renaming temporary part tmp_insert_all_8_8_0 to all_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
830 | 2024.12.21 00:52:54.261891 [ 262 ] {8958d239-c283-4123-9f37-b3b73dcf32de} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002644 sec., 756.4296520423601 rows/sec., 78.30 KiB/sec. | ||
831 | 2024.12.21 00:52:54.261973 [ 262 ] {8958d239-c283-4123-9f37-b3b73dcf32de} <Debug> TCPHandler: Processed in 0.002962189 sec. | ||
832 | 2024.12.21 00:52:54.269501 [ 263 ] {} <Trace> TCP-Session: 70536a9c-dfdb-4224-9b2e-db2652148aa1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
833 | 2024.12.21 00:52:54.269713 [ 263 ] {bb7e0e3c-e26d-4296-a0c9-10f648734153} <Debug> executeQuery: (from [::1]:42286) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
834 | 2024.12.21 00:52:54.269803 [ 263 ] {bb7e0e3c-e26d-4296-a0c9-10f648734153} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
835 | 2024.12.21 00:52:54.272251 [ 263 ] {bb7e0e3c-e26d-4296-a0c9-10f648734153} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
836 | 2024.12.21 00:52:54.272301 [ 263 ] {bb7e0e3c-e26d-4296-a0c9-10f648734153} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 138.37 GiB. | ||
837 | 2024.12.21 00:52:54.272916 [ 263 ] {bb7e0e3c-e26d-4296-a0c9-10f648734153} <Trace> MergedBlockOutputStream: filled checksums all_8_8_0 (state Temporary) | ||
838 | 2024.12.21 00:52:54.273385 [ 263 ] {bb7e0e3c-e26d-4296-a0c9-10f648734153} <Trace> oximeter.measurements_i64 (bf645b0e-7a7a-40be-aab5-5ee2f1ca719c): Renaming temporary part tmp_insert_all_8_8_0 to all_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
839 | 2024.12.21 00:52:54.273642 [ 263 ] {bb7e0e3c-e26d-4296-a0c9-10f648734153} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003993 sec., 250.4382669671926 rows/sec., 17.36 KiB/sec. | ||
840 | 2024.12.21 00:52:54.273771 [ 263 ] {bb7e0e3c-e26d-4296-a0c9-10f648734153} <Debug> TCPHandler: Processed in 0.004442919 sec. |