2024.12.20 21:46:17.250971 [ 163674 ] {} SentryWriter: Sending crash reports is disabled 2024.12.20 21:46:17.251134 [ 163674 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.12.20 21:46:17.334264 [ 163674 ] {} Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 163674 2024.12.20 21:46:17.334328 [ 163674 ] {} Application: starting up 2024.12.20 21:46:17.334342 [ 163674 ] {} Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 2024.12.20 21:46:17.342050 [ 163674 ] {} Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. 2024.12.20 21:46:17.386332 [ 163674 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.12.20 21:46:17.386587 [ 163674 ] {} AsynchronousMetrics: Scanning /sys/block 2024.12.20 21:46:17.386642 [ 163674 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.12.20 21:46:17.386659 [ 163674 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.12.20 21:46:17.640522 [ 163674 ] {} Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) 2024.12.20 21:46:17.640566 [ 163674 ] {} Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. 2024.12.20 21:46:17.647480 [ 163674 ] {} Application: Set max number of file descriptors to 524288 (was 1024). 2024.12.20 21:46:17.647504 [ 163674 ] {} Application: rlimit on number of threads is 125612 2024.12.20 21:46:17.647514 [ 163674 ] {} Application: Initializing DateLUT. 2024.12.20 21:46:17.647520 [ 163674 ] {} Application: Initialized DateLUT with time zone 'UTC'. 2024.12.20 21:46:17.647547 [ 163674 ] {} Context: Setting up /var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/datastore/tmp/ to store temporary data in it 2024.12.20 21:46:17.647851 [ 163674 ] {} Application: Initializing interserver credentials. 2024.12.20 21:46:17.648489 [ 163674 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml' 2024.12.20 21:46:17.649076 [ 163674 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml', performing update on configuration 2024.12.20 21:46:17.650050 [ 163674 ] {} Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) 2024.12.20 21:46:17.651539 [ 163674 ] {} Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) 2024.12.20 21:46:17.651553 [ 163674 ] {} Application: Merges and mutations memory limit is set to 15.34 GiB 2024.12.20 21:46:17.651622 [ 163674 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.20 21:46:17.652588 [ 163674 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.12.20 21:46:17.660947 [ 163674 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.20 21:46:17.666812 [ 163674 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.20 21:46:17.668550 [ 163674 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.20 21:46:17.668569 [ 163674 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml', performed update on configuration 2024.12.20 21:46:17.670747 [ 163674 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml' 2024.12.20 21:46:17.671248 [ 163674 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml', performing update on configuration 2024.12.20 21:46:17.672002 [ 163674 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml', performed update on configuration 2024.12.20 21:46:17.672278 [ 163674 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml 2024.12.20 21:46:17.672827 [ 163674 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.12.20 21:46:17.673074 [ 163674 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.12.20 21:46:17.673325 [ 163674 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.12.20 21:46:17.673550 [ 163674 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.12.20 21:46:17.674097 [ 163674 ] {} DNSCacheUpdater: Update period 15 seconds 2024.12.20 21:46:17.674113 [ 163674 ] {} Application: Loading metadata from /var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/datastore/ 2024.12.20 21:46:17.674575 [ 163694 ] {} DNSResolver: Updating DNS cache 2024.12.20 21:46:17.674595 [ 163694 ] {} DNSResolver: Updated DNS cache 2024.12.20 21:46:17.698996 [ 163674 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.12.20 21:46:17.699026 [ 163674 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.007974566 sec 2024.12.20 21:46:17.699035 [ 163674 ] {} ReferentialDeps: No tables 2024.12.20 21:46:17.699040 [ 163674 ] {} LoadingDeps: No tables 2024.12.20 21:46:17.699077 [ 163674 ] {} DatabaseAtomic (system): Starting up tables. 2024.12.20 21:46:17.699104 [ 163674 ] {} SystemLog: Creating system.query_log from query_log 2024.12.20 21:46:17.699999 [ 163674 ] {} SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config 2024.12.20 21:46:17.700018 [ 163674 ] {} SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config 2024.12.20 21:46:17.700026 [ 163674 ] {} SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config 2024.12.20 21:46:17.700053 [ 163674 ] {} SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config 2024.12.20 21:46:17.700060 [ 163674 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.12.20 21:46:17.700069 [ 163674 ] {} SystemLog: Creating system.metric_log from metric_log 2024.12.20 21:46:17.702199 [ 163674 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.12.20 21:46:17.702216 [ 163674 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.12.20 21:46:17.702224 [ 163674 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.12.20 21:46:17.702382 [ 163674 ] {} SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config 2024.12.20 21:46:17.702394 [ 163674 ] {} SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config 2024.12.20 21:46:17.702402 [ 163674 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.12.20 21:46:17.702409 [ 163674 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.12.20 21:46:17.702416 [ 163674 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.12.20 21:46:17.702423 [ 163674 ] {} SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config 2024.12.20 21:46:17.702429 [ 163674 ] {} SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config 2024.12.20 21:46:17.721834 [ 163674 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.12.20 21:46:17.727940 [ 163674 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.12.20 21:46:17.727963 [ 163674 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.79e-05 sec 2024.12.20 21:46:17.727970 [ 163674 ] {} ReferentialDeps: No tables 2024.12.20 21:46:17.727975 [ 163674 ] {} LoadingDeps: No tables 2024.12.20 21:46:17.727999 [ 163674 ] {} DatabaseAtomic (default): Starting up tables. 2024.12.20 21:46:17.728097 [ 163674 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/datastore/user_defined/ 2024.12.20 21:46:17.728130 [ 163674 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.12.20 21:46:17.728137 [ 163674 ] {} Application: Loaded metadata. 2024.12.20 21:46:17.728157 [ 163674 ] {} Application: Tasks stats provider: procfs 2024.12.20 21:46:17.728163 [ 163674 ] {} Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. 2024.12.20 21:46:17.728230 [ 163674 ] {} Application: Requested any available port (port == 0), actual port is 36651 2024.12.20 21:46:17.728343 [ 163674 ] {} Application: Requested any available port (port == 0), actual port is 35117 2024.12.20 21:46:17.728583 [ 163674 ] {} Application: Requested any available port (port == 0), actual port is 34307 2024.12.20 21:46:17.730755 [ 163674 ] {} Application: Requested any available port (port == 0), actual port is 38999 2024.12.20 21:46:17.730786 [ 163674 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.20 21:46:17.731177 [ 163674 ] {} AsynchronousMetrics: MemoryTracking: was 20.64 MiB, peak 20.64 MiB, free memory in arenas 21.78 MiB, will set to 386.88 MiB (RSS), difference: 366.24 MiB 2024.12.20 21:46:17.731726 [ 163674 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.882e-05 sec. 2024.12.20 21:46:17.732719 [ 163674 ] {} Application: Listening for http://[::1]:36651 2024.12.20 21:46:17.733219 [ 163674 ] {} Application: Listening for native protocol (tcp): [::1]:35117 2024.12.20 21:46:17.733294 [ 163674 ] {} Application: Listening for http://127.0.0.1:34307 2024.12.20 21:46:17.733339 [ 163674 ] {} Application: Listening for native protocol (tcp): 127.0.0.1:38999 2024.12.20 21:46:17.733348 [ 163674 ] {} Application: Ready for connections. 2024.12.20 21:46:18.713946 [ 163685 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37710 2024.12.20 21:46:18.714111 [ 163685 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:18.714154 [ 163685 ] {} TCP-Session: c01cd7dc-be2c-4497-8425-84fc3d9b40d5 Authenticating user 'default' from [::1]:37710 2024.12.20 21:46:18.714172 [ 163685 ] {} TCP-Session: c01cd7dc-be2c-4497-8425-84fc3d9b40d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.714180 [ 163685 ] {} TCP-Session: c01cd7dc-be2c-4497-8425-84fc3d9b40d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.714276 [ 163685 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.20 21:46:18.714301 [ 163685 ] {} 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 2024.12.20 21:46:18.714312 [ 163685 ] {} 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 2024.12.20 21:46:18.717558 [ 163686 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37712 2024.12.20 21:46:18.718347 [ 163686 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:18.718384 [ 163686 ] {} TCP-Session: cb85dd48-2b54-45af-a109-90ba2625871b Authenticating user 'default' from [::1]:37712 2024.12.20 21:46:18.718395 [ 163686 ] {} TCP-Session: cb85dd48-2b54-45af-a109-90ba2625871b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.718400 [ 163686 ] {} TCP-Session: cb85dd48-2b54-45af-a109-90ba2625871b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.762571 [ 164295 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37716 2024.12.20 21:46:18.762717 [ 164295 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:18.762720 [ 164297 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37718 2024.12.20 21:46:18.762758 [ 164295 ] {} TCP-Session: 89f1b19f-3cd9-47d3-85ff-990c20f333b4 Authenticating user 'default' from [::1]:37716 2024.12.20 21:46:18.762748 [ 164296 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37720 2024.12.20 21:46:18.762778 [ 164295 ] {} TCP-Session: 89f1b19f-3cd9-47d3-85ff-990c20f333b4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.762788 [ 164295 ] {} TCP-Session: 89f1b19f-3cd9-47d3-85ff-990c20f333b4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.762846 [ 164297 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:18.762871 [ 164297 ] {} TCP-Session: a4e35bbc-09fd-406a-8cd8-f143116b327e Authenticating user 'default' from [::1]:37718 2024.12.20 21:46:18.762881 [ 164297 ] {} TCP-Session: a4e35bbc-09fd-406a-8cd8-f143116b327e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.762900 [ 164297 ] {} TCP-Session: a4e35bbc-09fd-406a-8cd8-f143116b327e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.762950 [ 164296 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:18.762962 [ 164299 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37724 2024.12.20 21:46:18.762979 [ 164296 ] {} TCP-Session: eee21fc0-c0a2-4fd3-be7c-3d10ae4254d5 Authenticating user 'default' from [::1]:37720 2024.12.20 21:46:18.762991 [ 164296 ] {} TCP-Session: eee21fc0-c0a2-4fd3-be7c-3d10ae4254d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.762998 [ 164296 ] {} TCP-Session: eee21fc0-c0a2-4fd3-be7c-3d10ae4254d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.763054 [ 163687 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37714 2024.12.20 21:46:18.763066 [ 164299 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:18.763091 [ 164299 ] {} TCP-Session: 1ba093a6-8e4e-4e11-a2c4-618d63a655d1 Authenticating user 'default' from [::1]:37724 2024.12.20 21:46:18.763099 [ 164299 ] {} TCP-Session: 1ba093a6-8e4e-4e11-a2c4-618d63a655d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.763105 [ 164299 ] {} TCP-Session: 1ba093a6-8e4e-4e11-a2c4-618d63a655d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.763714 [ 163687 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:18.763741 [ 163687 ] {} TCP-Session: b35065ad-e78a-408b-b80a-038cb6f3387b Authenticating user 'default' from [::1]:37714 2024.12.20 21:46:18.763751 [ 163687 ] {} TCP-Session: b35065ad-e78a-408b-b80a-038cb6f3387b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.763756 [ 163687 ] {} TCP-Session: b35065ad-e78a-408b-b80a-038cb6f3387b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.763886 [ 164298 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37722 2024.12.20 21:46:18.764026 [ 164298 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:18.764053 [ 164298 ] {} TCP-Session: e4260139-2245-434d-b2fd-48c112175f41 Authenticating user 'default' from [::1]:37722 2024.12.20 21:46:18.764064 [ 164298 ] {} TCP-Session: e4260139-2245-434d-b2fd-48c112175f41 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:18.764158 [ 164298 ] {} TCP-Session: e4260139-2245-434d-b2fd-48c112175f41 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:25.205959 [ 163761 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 1958 entries to flush up to offset 1958 2024.12.20 21:46:25.206022 [ 163761 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.12.20 21:46:25.207083 [ 163761 ] {} StoragePolicy (default): Storage policy default created, total volumes 1 2024.12.20 21:46:25.209422 [ 163931 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 2024.12.20 21:46:25.210046 [ 163931 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.12.20 21:46:25.210940 [ 163761 ] {} system.asynchronous_metric_log (3a5108c8-8292-4572-a2cf-f2befc479079): Loading data parts 2024.12.20 21:46:25.216729 [ 163761 ] {} system.asynchronous_metric_log (3a5108c8-8292-4572-a2cf-f2befc479079): There are no data parts 2024.12.20 21:46:25.221214 [ 163761 ] {} system.asynchronous_metric_log (3a5108c8-8292-4572-a2cf-f2befc479079): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.20 21:46:25.221245 [ 163761 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.13 GiB. 2024.12.20 21:46:25.223093 [ 163761 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.20 21:46:25.224854 [ 163761 ] {} system.asynchronous_metric_log (3a5108c8-8292-4572-a2cf-f2befc479079): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.20 21:46:25.225028 [ 163761 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1958 2024.12.20 21:46:25.231519 [ 163931 ] {} system.metric_log (b95523a4-032e-497a-aa58-ff365afef9e1): Loading data parts 2024.12.20 21:46:25.232534 [ 163931 ] {} system.metric_log (b95523a4-032e-497a-aa58-ff365afef9e1): There are no data parts 2024.12.20 21:46:25.255443 [ 163931 ] {} system.metric_log (b95523a4-032e-497a-aa58-ff365afef9e1): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.20 21:46:25.255486 [ 163931 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.13 GiB. 2024.12.20 21:46:25.263871 [ 163931 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.20 21:46:25.265540 [ 163931 ] {} system.metric_log (b95523a4-032e-497a-aa58-ff365afef9e1): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.20 21:46:25.268376 [ 163931 ] {} SystemLog (system.metric_log): Flushed system log up to offset 8 2024.12.20 21:46:27.836497 [ 165543 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37730 2024.12.20 21:46:27.836730 [ 165543 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.836760 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Authenticating user 'default' from [::1]:37730 2024.12.20 21:46:27.836777 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.836785 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.846223 [ 165544 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37732 2024.12.20 21:46:27.846401 [ 165545 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37734 2024.12.20 21:46:27.846939 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.847146 [ 165545 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.847185 [ 165545 ] {} TCP-Session: 58429971-7778-45ba-b04b-a73e16fef1b4 Authenticating user 'default' from [::1]:37734 2024.12.20 21:46:27.847248 [ 165543 ] {122169d1-2475-41ee-84da-4890f22c85ac} executeQuery: (from [::1]:37730) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.12.20 21:46:27.847281 [ 165545 ] {} TCP-Session: 58429971-7778-45ba-b04b-a73e16fef1b4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.847578 [ 165545 ] {} TCP-Session: 58429971-7778-45ba-b04b-a73e16fef1b4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.847584 [ 165544 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.847637 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Authenticating user 'default' from [::1]:37732 2024.12.20 21:46:27.847647 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.847653 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.847940 [ 165543 ] {122169d1-2475-41ee-84da-4890f22c85ac} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:37730) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 7. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 9. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. ? @ 0x00007f3668970ac3 in ? 17. ? @ 0x00007f3668a02850 in ? 2024.12.20 21:46:27.848071 [ 165543 ] {122169d1-2475-41ee-84da-4890f22c85ac} TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 7. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 9. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. ? @ 0x00007f3668970ac3 in ? 17. ? @ 0x00007f3668a02850 in ? 2024.12.20 21:46:27.848125 [ 165543 ] {122169d1-2475-41ee-84da-4890f22c85ac} TCPHandler: Processed in 0.001379041 sec. 2024.12.20 21:46:27.852393 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.859616 [ 165544 ] {252d26dc-b329-46af-bb9c-cb2e9867bc02} executeQuery: (from [::1]:37732) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.12.20 21:46:27.859916 [ 165544 ] {252d26dc-b329-46af-bb9c-cb2e9867bc02} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:37732) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 7. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 9. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. ? @ 0x00007f3668970ac3 in ? 17. ? @ 0x00007f3668a02850 in ? 2024.12.20 21:46:27.860037 [ 165544 ] {252d26dc-b329-46af-bb9c-cb2e9867bc02} TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 7. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 9. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. ? @ 0x00007f3668970ac3 in ? 17. ? @ 0x00007f3668a02850 in ? 2024.12.20 21:46:27.860087 [ 165544 ] {252d26dc-b329-46af-bb9c-cb2e9867bc02} TCPHandler: Processed in 0.008327347 sec. 2024.12.20 21:46:27.862038 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.862175 [ 165543 ] {c7b2e616-ad39-45af-9d6a-5b9d2e5cfaea} executeQuery: (from [::1]:37730) DROP DATABASE IF EXISTS oximeter (stage: Complete) 2024.12.20 21:46:27.863345 [ 165543 ] {c7b2e616-ad39-45af-9d6a-5b9d2e5cfaea} TCPHandler: Processed in 0.001388691 sec. 2024.12.20 21:46:27.864088 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.864251 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} executeQuery: (from [::1]:37732) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) 2024.12.20 21:46:27.865340 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* 2024.12.20 21:46:27.871188 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. 2024.12.20 21:46:27.871213 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.894e-05 sec 2024.12.20 21:46:27.871221 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} ReferentialDeps: No tables 2024.12.20 21:46:27.871226 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} LoadingDeps: No tables 2024.12.20 21:46:27.871249 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} DatabaseAtomic (oximeter): Starting up tables. 2024.12.20 21:46:27.871330 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} TCPHandler: Processed in 0.007355016 sec. 2024.12.20 21:46:27.873096 [ 165546 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37736 2024.12.20 21:46:27.873216 [ 165546 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.873248 [ 165546 ] {} TCP-Session: 10d6ca1d-4817-4479-9f9d-ae595630a092 Authenticating user 'default' from [::1]:37736 2024.12.20 21:46:27.873264 [ 165546 ] {} TCP-Session: 10d6ca1d-4817-4479-9f9d-ae595630a092 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.873271 [ 165546 ] {} TCP-Session: 10d6ca1d-4817-4479-9f9d-ae595630a092 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.873372 [ 165546 ] {} TCPHandler: Done processing connection. 2024.12.20 21:46:27.873393 [ 165546 ] {} TCP-Session: 10d6ca1d-4817-4479-9f9d-ae595630a092 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.874651 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.875169 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} executeQuery: (from [::1]:37730) /* The version table contains metadata about the `oximeter` database */ CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) 2024.12.20 21:46:27.875213 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version 2024.12.20 21:46:27.881411 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} oximeter.version (3644c0ed-2391-49f4-bd3a-2f24dfda9862): Loading data parts 2024.12.20 21:46:27.881750 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} oximeter.version (3644c0ed-2391-49f4-bd3a-2f24dfda9862): There are no data parts 2024.12.20 21:46:27.887240 [ 165548 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37740 2024.12.20 21:46:27.887276 [ 165546 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37744 2024.12.20 21:46:27.887353 [ 165549 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37742 2024.12.20 21:46:27.887368 [ 165547 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37738 2024.12.20 21:46:27.887424 [ 165550 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37746 2024.12.20 21:46:27.888739 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} TCPHandler: Processed in 0.014237842 sec. 2024.12.20 21:46:27.888947 [ 165546 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.888967 [ 165546 ] {} TCP-Session: 6852bcbb-857d-41ef-b1e1-8ec87f8245ed Authenticating user 'default' from [::1]:37744 2024.12.20 21:46:27.888982 [ 165546 ] {} TCP-Session: 6852bcbb-857d-41ef-b1e1-8ec87f8245ed Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.888989 [ 165546 ] {} TCP-Session: 6852bcbb-857d-41ef-b1e1-8ec87f8245ed Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.889054 [ 165548 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.889024 [ 165547 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.889122 [ 165547 ] {} TCP-Session: e610013a-9d17-4639-910d-9d6dc971b6b3 Authenticating user 'default' from [::1]:37738 2024.12.20 21:46:27.889133 [ 165547 ] {} TCP-Session: e610013a-9d17-4639-910d-9d6dc971b6b3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.889139 [ 165547 ] {} TCP-Session: e610013a-9d17-4639-910d-9d6dc971b6b3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.889198 [ 165549 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.889224 [ 165548 ] {} TCP-Session: 925db6ea-1932-4a0c-8825-65c00c12daf4 Authenticating user 'default' from [::1]:37740 2024.12.20 21:46:27.889235 [ 165549 ] {} TCP-Session: f69b76c5-42b9-43a2-8cec-bb0f88a03bc0 Authenticating user 'default' from [::1]:37742 2024.12.20 21:46:27.889237 [ 165548 ] {} TCP-Session: 925db6ea-1932-4a0c-8825-65c00c12daf4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.889257 [ 165549 ] {} TCP-Session: f69b76c5-42b9-43a2-8cec-bb0f88a03bc0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.889262 [ 165548 ] {} TCP-Session: 925db6ea-1932-4a0c-8825-65c00c12daf4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.889281 [ 165549 ] {} TCP-Session: f69b76c5-42b9-43a2-8cec-bb0f88a03bc0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.889859 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.891114 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} executeQuery: (from [::1]:37732) /* The measurement tables contain all individual samples from each timeseries. * * Each table stores a single datum type, and otherwise contains nearly the same * structure. The primary sorting key is on the timeseries name, key, and then * timestamp, so that all timeseries from the same schema are grouped, followed * by all samples from the same timeseries. * * This reflects that one usually looks up the _key_ in one or more field table, * and then uses that to index quickly into the measurements tables. */ 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) 2024.12.20 21:46:27.891167 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool 2024.12.20 21:46:27.892744 [ 165550 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.20 21:46:27.892846 [ 165550 ] {} TCP-Session: 1694b5a7-acbd-4c39-b386-52310c3372cb Authenticating user 'default' from [::1]:37746 2024.12.20 21:46:27.892860 [ 165550 ] {} TCP-Session: 1694b5a7-acbd-4c39-b386-52310c3372cb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.892866 [ 165550 ] {} TCP-Session: 1694b5a7-acbd-4c39-b386-52310c3372cb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.20 21:46:27.895933 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} oximeter.measurements_bool (93dba19e-fdf8-4770-9a55-753c2be8f5f8): Loading data parts 2024.12.20 21:46:27.896166 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} oximeter.measurements_bool (93dba19e-fdf8-4770-9a55-753c2be8f5f8): There are no data parts 2024.12.20 21:46:27.903488 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} TCPHandler: Processed in 0.013785311 sec. 2024.12.20 21:46:27.904555 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.904825 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:27.904874 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 2024.12.20 21:46:27.910478 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} oximeter.measurements_i8 (babc3f8a-1776-4969-a2f6-04e2ff32e1d8): Loading data parts 2024.12.20 21:46:27.910759 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} oximeter.measurements_i8 (babc3f8a-1776-4969-a2f6-04e2ff32e1d8): There are no data parts 2024.12.20 21:46:27.915255 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} TCPHandler: Processed in 0.010849579 sec. 2024.12.20 21:46:27.916636 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.917166 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:27.924163 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 2024.12.20 21:46:27.932364 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} oximeter.measurements_u8 (cdc95b54-953b-4b2b-b713-b890b5c9453b): Loading data parts 2024.12.20 21:46:27.932626 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} oximeter.measurements_u8 (cdc95b54-953b-4b2b-b713-b890b5c9453b): There are no data parts 2024.12.20 21:46:27.937166 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} TCPHandler: Processed in 0.020695137 sec. 2024.12.20 21:46:27.938094 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.938365 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:27.938419 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 2024.12.20 21:46:27.946034 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} oximeter.measurements_i16 (206b2f94-9234-42fe-8787-ae636f80c2d6): Loading data parts 2024.12.20 21:46:27.946878 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} oximeter.measurements_i16 (206b2f94-9234-42fe-8787-ae636f80c2d6): There are no data parts 2024.12.20 21:46:27.952970 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} TCPHandler: Processed in 0.015037672 sec. 2024.12.20 21:46:27.954434 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.956625 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:27.956693 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 2024.12.20 21:46:27.966552 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} oximeter.measurements_u16 (31b82669-8ca0-498a-89e3-79044944e444): Loading data parts 2024.12.20 21:46:27.966908 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} oximeter.measurements_u16 (31b82669-8ca0-498a-89e3-79044944e444): There are no data parts 2024.12.20 21:46:27.972719 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} TCPHandler: Processed in 0.018449204 sec. 2024.12.20 21:46:27.978620 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:27.979493 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:27.979549 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 2024.12.20 21:46:27.985622 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} oximeter.measurements_i32 (672895fe-1596-4bc7-ae25-345301138cbf): Loading data parts 2024.12.20 21:46:27.985997 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} oximeter.measurements_i32 (672895fe-1596-4bc7-ae25-345301138cbf): There are no data parts 2024.12.20 21:46:27.995013 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} TCPHandler: Processed in 0.016594853 sec. 2024.12.20 21:46:28.007337 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.007654 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.009486 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 2024.12.20 21:46:28.015845 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} oximeter.measurements_u32 (ea6e7868-fd7e-40e2-8db5-73523747ee19): Loading data parts 2024.12.20 21:46:28.016101 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} oximeter.measurements_u32 (ea6e7868-fd7e-40e2-8db5-73523747ee19): There are no data parts 2024.12.20 21:46:28.020364 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} TCPHandler: Processed in 0.013203881 sec. 2024.12.20 21:46:28.055567 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.055837 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.055889 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 2024.12.20 21:46:28.062154 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Loading data parts 2024.12.20 21:46:28.062465 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): There are no data parts 2024.12.20 21:46:28.069414 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} TCPHandler: Processed in 0.013933021 sec. 2024.12.20 21:46:28.072037 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.073114 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.073182 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 2024.12.20 21:46:28.077638 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} oximeter.measurements_u64 (9c767a36-becb-4dab-824e-caf19706013d): Loading data parts 2024.12.20 21:46:28.077965 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} oximeter.measurements_u64 (9c767a36-becb-4dab-824e-caf19706013d): There are no data parts 2024.12.20 21:46:28.082118 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} TCPHandler: Processed in 0.010307718 sec. 2024.12.20 21:46:28.084070 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.085166 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.085223 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 2024.12.20 21:46:28.090741 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} oximeter.measurements_f32 (b2f9f887-b80f-4732-96ce-bdef1dacf269): Loading data parts 2024.12.20 21:46:28.091687 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} oximeter.measurements_f32 (b2f9f887-b80f-4732-96ce-bdef1dacf269): There are no data parts 2024.12.20 21:46:28.099225 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} TCPHandler: Processed in 0.015335262 sec. 2024.12.20 21:46:28.102431 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.102781 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.102836 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 2024.12.20 21:46:28.107728 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} oximeter.measurements_f64 (1e5ae190-2f60-479e-93e4-88710e3991ec): Loading data parts 2024.12.20 21:46:28.107985 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} oximeter.measurements_f64 (1e5ae190-2f60-479e-93e4-88710e3991ec): There are no data parts 2024.12.20 21:46:28.112183 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} TCPHandler: Processed in 0.009923117 sec. 2024.12.20 21:46:28.113213 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.113529 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.115238 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string 2024.12.20 21:46:28.120683 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} oximeter.measurements_string (786ae8f7-ed5d-4f4a-bd9f-ed1e8f6dc21b): Loading data parts 2024.12.20 21:46:28.121287 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} oximeter.measurements_string (786ae8f7-ed5d-4f4a-bd9f-ed1e8f6dc21b): There are no data parts 2024.12.20 21:46:28.128555 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} TCPHandler: Processed in 0.015496753 sec. 2024.12.20 21:46:28.133173 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.133478 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} executeQuery: (from [::1]:37732) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* * NOTE: Right now we can't unambiguously record a nullable byte array. * Arrays cannot be nested in `Nullable()` types, and encoding the array as * a string isn't palatable for a few reasons. * See: https://github.com/oxidecomputer/omicron/issues/4551 for more * details. */ datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.12.20 21:46:28.133538 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes 2024.12.20 21:46:28.139148 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} oximeter.measurements_bytes (c0f62f9c-cf82-4647-b9db-ac4793563c3b): Loading data parts 2024.12.20 21:46:28.139520 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} oximeter.measurements_bytes (c0f62f9c-cf82-4647-b9db-ac4793563c3b): There are no data parts 2024.12.20 21:46:28.143300 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} TCPHandler: Processed in 0.010292548 sec. 2024.12.20 21:46:28.144306 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.144579 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.144632 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 2024.12.20 21:46:28.150543 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} oximeter.measurements_cumulativei64 (13336fed-f2c3-4c13-8595-2d75ed852ea9): Loading data parts 2024.12.20 21:46:28.150788 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} oximeter.measurements_cumulativei64 (13336fed-f2c3-4c13-8595-2d75ed852ea9): There are no data parts 2024.12.20 21:46:28.155356 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} TCPHandler: Processed in 0.011229409 sec. 2024.12.20 21:46:28.158775 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.159063 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.159125 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 2024.12.20 21:46:28.164534 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} oximeter.measurements_cumulativeu64 (31027c17-1895-4c12-9b1f-1ba227214b8f): Loading data parts 2024.12.20 21:46:28.166710 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} oximeter.measurements_cumulativeu64 (31027c17-1895-4c12-9b1f-1ba227214b8f): There are no data parts 2024.12.20 21:46:28.174445 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} TCPHandler: Processed in 0.015839193 sec. 2024.12.20 21:46:28.175204 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.181416 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.181484 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 2024.12.20 21:46:28.188005 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} oximeter.measurements_cumulativef32 (2b26719b-6077-4394-ab9a-5b84448ded2e): Loading data parts 2024.12.20 21:46:28.188327 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} oximeter.measurements_cumulativef32 (2b26719b-6077-4394-ab9a-5b84448ded2e): There are no data parts 2024.12.20 21:46:28.192446 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} TCPHandler: Processed in 0.017350224 sec. 2024.12.20 21:46:28.193365 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.193628 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.193680 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 2024.12.20 21:46:28.200018 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} oximeter.measurements_cumulativef64 (4eec1da7-33ba-433c-ab7c-3ede9b01fa0e): Loading data parts 2024.12.20 21:46:28.201558 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} oximeter.measurements_cumulativef64 (4eec1da7-33ba-433c-ab7c-3ede9b01fa0e): There are no data parts 2024.12.20 21:46:28.205215 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} TCPHandler: Processed in 0.012029559 sec. 2024.12.20 21:46:28.205953 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.206536 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} executeQuery: (from [::1]:37730) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* * NOTE: Array types cannot be Nullable, see * https://clickhouse.com/docs/en/sql-reference/data-types/nullable * for more details. * * This means we need to use empty arrays to indicate a missing value. This * is unfortunate, and at this point relies on the fact that an * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need * to figure out another way to represent missing samples here. */ 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) 2024.12.20 21:46:28.206611 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 2024.12.20 21:46:28.215002 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} oximeter.measurements_histogrami8 (28f4a2f0-87dc-4ea3-92e3-b3bd9d037735): Loading data parts 2024.12.20 21:46:28.215315 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} oximeter.measurements_histogrami8 (28f4a2f0-87dc-4ea3-92e3-b3bd9d037735): There are no data parts 2024.12.20 21:46:28.219552 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} TCPHandler: Processed in 0.013753351 sec. 2024.12.20 21:46:28.220921 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.221186 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.221246 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 2024.12.20 21:46:28.226374 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} oximeter.measurements_histogramu8 (bbc706d7-f2ee-4e35-a942-17ad60c21289): Loading data parts 2024.12.20 21:46:28.226651 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} oximeter.measurements_histogramu8 (bbc706d7-f2ee-4e35-a942-17ad60c21289): There are no data parts 2024.12.20 21:46:28.231026 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} TCPHandler: Processed in 0.010173348 sec. 2024.12.20 21:46:28.231707 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.231979 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.232046 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 2024.12.20 21:46:28.239938 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} oximeter.measurements_histogrami16 (bd11fa3e-ca31-4fe6-b13e-dd979b0d4897): Loading data parts 2024.12.20 21:46:28.242661 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} oximeter.measurements_histogrami16 (bd11fa3e-ca31-4fe6-b13e-dd979b0d4897): There are no data parts 2024.12.20 21:46:28.248101 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} TCPHandler: Processed in 0.016481573 sec. 2024.12.20 21:46:28.248869 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.249251 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.249318 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 2024.12.20 21:46:28.258812 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} oximeter.measurements_histogramu16 (4716f374-3bdb-41c6-9fc1-7ef74e3bef75): Loading data parts 2024.12.20 21:46:28.260460 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} oximeter.measurements_histogramu16 (4716f374-3bdb-41c6-9fc1-7ef74e3bef75): There are no data parts 2024.12.20 21:46:28.264118 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} TCPHandler: Processed in 0.015432973 sec. 2024.12.20 21:46:28.264897 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.265227 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.265284 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 2024.12.20 21:46:28.275509 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} oximeter.measurements_histogrami32 (1d0cc353-e624-4b65-8a55-7e76257a54f6): Loading data parts 2024.12.20 21:46:28.276375 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} oximeter.measurements_histogrami32 (1d0cc353-e624-4b65-8a55-7e76257a54f6): There are no data parts 2024.12.20 21:46:28.289758 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} TCPHandler: Processed in 0.0249338 sec. 2024.12.20 21:46:28.290653 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.291026 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.291090 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 2024.12.20 21:46:28.302353 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} oximeter.measurements_histogramu32 (3fd8d6bc-d17b-4a75-a35b-d10f6351ead9): Loading data parts 2024.12.20 21:46:28.302886 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} oximeter.measurements_histogramu32 (3fd8d6bc-d17b-4a75-a35b-d10f6351ead9): There are no data parts 2024.12.20 21:46:28.306733 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} TCPHandler: Processed in 0.016171333 sec. 2024.12.20 21:46:28.307573 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.307922 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.309752 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 2024.12.20 21:46:28.314717 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} oximeter.measurements_histogrami64 (f1fafa90-3aa0-476a-8a78-81d7dee7f8f7): Loading data parts 2024.12.20 21:46:28.315007 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} oximeter.measurements_histogrami64 (f1fafa90-3aa0-476a-8a78-81d7dee7f8f7): There are no data parts 2024.12.20 21:46:28.318858 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} TCPHandler: Processed in 0.011446669 sec. 2024.12.20 21:46:28.319855 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.320180 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.320242 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 2024.12.20 21:46:28.325923 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} oximeter.measurements_histogramu64 (85f2f4ad-30bd-4b42-ad8c-960c4d5607c1): Loading data parts 2024.12.20 21:46:28.326235 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} oximeter.measurements_histogramu64 (85f2f4ad-30bd-4b42-ad8c-960c4d5607c1): There are no data parts 2024.12.20 21:46:28.330604 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} TCPHandler: Processed in 0.010932579 sec. 2024.12.20 21:46:28.331414 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.333487 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.333559 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 2024.12.20 21:46:28.339885 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} oximeter.measurements_histogramf32 (63720de0-422c-423f-8f47-943ab5043f7b): Loading data parts 2024.12.20 21:46:28.340144 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} oximeter.measurements_histogramf32 (63720de0-422c-423f-8f47-943ab5043f7b): There are no data parts 2024.12.20 21:46:28.344468 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} TCPHandler: Processed in 0.01326673 sec. 2024.12.20 21:46:28.345171 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.345419 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.345483 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 2024.12.20 21:46:28.350266 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} oximeter.measurements_histogramf64 (dfb04165-cfd9-4621-acb4-1e1db6b770b7): Loading data parts 2024.12.20 21:46:28.350538 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} oximeter.measurements_histogramf64 (dfb04165-cfd9-4621-acb4-1e1db6b770b7): There are no data parts 2024.12.20 21:46:28.356781 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} TCPHandler: Processed in 0.011731079 sec. 2024.12.20 21:46:28.357650 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.357930 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} executeQuery: (from [::1]:37730) /* The field tables store named dimensions of each timeseries. * * As with the measurement tables, there is one field table for each field data * type. Fields are deduplicated by using the "replacing merge tree", though * this behavior **must not** be relied upon for query correctness. * * The index for the fields differs from the measurements, however. Rows are * sorted by timeseries name, then field name, field value, and finally * timeseries key. This reflects the most common pattern for looking them up: * by field name and possibly value, within a timeseries. The resulting keys are * usually then used to look up measurements. * * NOTE: We may want to consider a secondary index on these tables, sorting by * timeseries name and then key, since it would improve lookups where one * already has the key. Realistically though, these tables are quite small and * so performance benefits will be low in absolute terms. * * TTL: We use a materialized column to expire old field table records. This * column is generated automatically by the database whenever a new row is * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` * query. Since these tables are `ReplacingMergeTree`s, that means the last * record will remain during a deduplication, which will have the last * timestamp. ClickHouse will then expire old data for us, similar to the * measurement tables. */ 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) 2024.12.20 21:46:28.357989 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool 2024.12.20 21:46:28.362867 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} oximeter.fields_bool (7dc74bd0-ccfb-44e3-82a8-5e58b602ad1b): Loading data parts 2024.12.20 21:46:28.370816 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} oximeter.fields_bool (7dc74bd0-ccfb-44e3-82a8-5e58b602ad1b): There are no data parts 2024.12.20 21:46:28.377214 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} TCPHandler: Processed in 0.019729696 sec. 2024.12.20 21:46:28.378024 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.380029 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.380088 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 2024.12.20 21:46:28.385724 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} oximeter.fields_i8 (9309d7da-65d1-4d11-83fe-ddd785b1e3a9): Loading data parts 2024.12.20 21:46:28.387727 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} oximeter.fields_i8 (9309d7da-65d1-4d11-83fe-ddd785b1e3a9): There are no data parts 2024.12.20 21:46:28.393320 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} TCPHandler: Processed in 0.015493683 sec. 2024.12.20 21:46:28.394195 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.394442 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.394513 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 2024.12.20 21:46:28.405555 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} oximeter.fields_u8 (c5e1ef3c-823b-40a9-be41-a5d6968a53f7): Loading data parts 2024.12.20 21:46:28.406258 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} oximeter.fields_u8 (c5e1ef3c-823b-40a9-be41-a5d6968a53f7): There are no data parts 2024.12.20 21:46:28.410118 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} TCPHandler: Processed in 0.016085073 sec. 2024.12.20 21:46:28.410783 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.411097 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.411150 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 2024.12.20 21:46:28.417573 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} oximeter.fields_i16 (8407da7b-71ce-448e-958c-0a59591332d9): Loading data parts 2024.12.20 21:46:28.417970 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} oximeter.fields_i16 (8407da7b-71ce-448e-958c-0a59591332d9): There are no data parts 2024.12.20 21:46:28.424782 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} TCPHandler: Processed in 0.014077941 sec. 2024.12.20 21:46:28.425699 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.425962 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.426022 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 2024.12.20 21:46:28.431245 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} oximeter.fields_u16 (724f5d3a-2b25-4f4e-80cf-53e639f45f30): Loading data parts 2024.12.20 21:46:28.431539 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} oximeter.fields_u16 (724f5d3a-2b25-4f4e-80cf-53e639f45f30): There are no data parts 2024.12.20 21:46:28.436960 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} TCPHandler: Processed in 0.011428319 sec. 2024.12.20 21:46:28.437748 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.438010 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.438063 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 2024.12.20 21:46:28.445467 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} oximeter.fields_i32 (5f89e1f8-2f62-485f-a5fd-d539c094ff6b): Loading data parts 2024.12.20 21:46:28.445717 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} oximeter.fields_i32 (5f89e1f8-2f62-485f-a5fd-d539c094ff6b): There are no data parts 2024.12.20 21:46:28.449983 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} TCPHandler: Processed in 0.01239978 sec. 2024.12.20 21:46:28.450797 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.452232 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.452313 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 2024.12.20 21:46:28.463760 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} oximeter.fields_u32 (77824b7b-33c4-4d3a-8caa-e6e5e8ba3b26): Loading data parts 2024.12.20 21:46:28.465270 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} oximeter.fields_u32 (77824b7b-33c4-4d3a-8caa-e6e5e8ba3b26): There are no data parts 2024.12.20 21:46:28.470928 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} TCPHandler: Processed in 0.020296126 sec. 2024.12.20 21:46:28.471756 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.472029 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.472092 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 2024.12.20 21:46:28.479541 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} oximeter.fields_i64 (6ed979b5-bf55-44c5-ba7a-9905ac8eb4df): Loading data parts 2024.12.20 21:46:28.479809 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} oximeter.fields_i64 (6ed979b5-bf55-44c5-ba7a-9905ac8eb4df): There are no data parts 2024.12.20 21:46:28.484226 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} TCPHandler: Processed in 0.01264126 sec. 2024.12.20 21:46:28.485049 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.485316 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.485370 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 2024.12.20 21:46:28.491720 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} oximeter.fields_u64 (6a552b17-2538-4c57-aa46-ac8e8fbabaef): Loading data parts 2024.12.20 21:46:28.492023 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} oximeter.fields_u64 (6a552b17-2538-4c57-aa46-ac8e8fbabaef): There are no data parts 2024.12.20 21:46:28.495725 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} TCPHandler: Processed in 0.010836619 sec. 2024.12.20 21:46:28.496900 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.497208 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.497263 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr 2024.12.20 21:46:28.505386 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} oximeter.fields_ipaddr (5bbcb034-4ace-4430-b831-4f771785418e): Loading data parts 2024.12.20 21:46:28.507526 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} oximeter.fields_ipaddr (5bbcb034-4ace-4430-b831-4f771785418e): There are no data parts 2024.12.20 21:46:28.516179 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} TCPHandler: Processed in 0.019450995 sec. 2024.12.20 21:46:28.517499 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.519741 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} executeQuery: (from [::1]:37730) 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) 2024.12.20 21:46:28.519806 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string 2024.12.20 21:46:28.524879 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Loading data parts 2024.12.20 21:46:28.525118 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): There are no data parts 2024.12.20 21:46:28.529731 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} TCPHandler: Processed in 0.012405579 sec. 2024.12.20 21:46:28.530497 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.531736 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} executeQuery: (from [::1]:37732) 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) 2024.12.20 21:46:28.531793 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid 2024.12.20 21:46:28.539595 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} oximeter.fields_uuid (b439313f-731a-42b5-a120-f2d5bf712e62): Loading data parts 2024.12.20 21:46:28.539884 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} oximeter.fields_uuid (b439313f-731a-42b5-a120-f2d5bf712e62): There are no data parts 2024.12.20 21:46:28.547640 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} TCPHandler: Processed in 0.017291484 sec. 2024.12.20 21:46:28.548539 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.549820 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} executeQuery: (from [::1]:37730) /* The timeseries schema table stores the extracted schema for the samples * oximeter collects. */ 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) 2024.12.20 21:46:28.549893 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema 2024.12.20 21:46:28.555718 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305): Loading data parts 2024.12.20 21:46:28.555971 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305): There are no data parts 2024.12.20 21:46:28.560888 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} TCPHandler: Processed in 0.012518821 sec. 2024.12.20 21:46:28.561662 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:28.561840 [ 165544 ] {33677a07-1512-4782-803e-471949d3edba} executeQuery: (from [::1]:37732) INSERT INTO oximeter.version (*) VALUES (stage: Complete) 2024.12.20 21:46:28.561938 [ 165544 ] {33677a07-1512-4782-803e-471949d3edba} ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version 2024.12.20 21:46:28.562763 [ 165498 ] {33677a07-1512-4782-803e-471949d3edba} oximeter.version (3644c0ed-2391-49f4-bd3a-2f24dfda9862): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.20 21:46:28.563917 [ 165498 ] {33677a07-1512-4782-803e-471949d3edba} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.12 GiB. 2024.12.20 21:46:28.564233 [ 165498 ] {33677a07-1512-4782-803e-471949d3edba} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.20 21:46:28.564427 [ 165498 ] {33677a07-1512-4782-803e-471949d3edba} oximeter.version (3644c0ed-2391-49f4-bd3a-2f24dfda9862): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.20 21:46:28.564613 [ 165544 ] {33677a07-1512-4782-803e-471949d3edba} executeQuery: Read 1 rows, 16.00 B in 0.002829 sec., 353.4817956875221 rows/sec., 5.52 KiB/sec. 2024.12.20 21:46:28.564756 [ 165544 ] {33677a07-1512-4782-803e-471949d3edba} TCPHandler: Processed in 0.003247273 sec. 2024.12.20 21:46:29.000430 [ 163934 ] {} AsynchronousMetrics: MemoryTracking: was 399.65 MiB, peak 399.65 MiB, free memory in arenas 28.53 MiB, will set to 393.55 MiB (RSS), difference: -6.09 MiB 2024.12.20 21:46:30.322055 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:30.322250 [ 165543 ] {a9e1a756-cef9-499d-9746-305be312b9f7} executeQuery: (from [::1]:37730) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) 2024.12.20 21:46:30.323587 [ 165543 ] {a9e1a756-cef9-499d-9746-305be312b9f7} ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema 2024.12.20 21:46:30.323649 [ 165543 ] {a9e1a756-cef9-499d-9746-305be312b9f7} InterpreterSelectQuery: FetchColumns -> Complete 2024.12.20 21:46:30.324189 [ 165543 ] {a9e1a756-cef9-499d-9746-305be312b9f7} TCPHandler: Processed in 0.002311793 sec. 2024.12.20 21:46:30.345511 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:30.345706 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} executeQuery: (from [::1]:37732) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) 2024.12.20 21:46:30.345772 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema 2024.12.20 21:46:30.347618 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.20 21:46:30.347880 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. 2024.12.20 21:46:30.348381 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.20 21:46:30.348562 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.20 21:46:30.348782 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} executeQuery: Read 1 rows, 123.00 B in 0.003129 sec., 319.59092361776925 rows/sec., 38.39 KiB/sec. 2024.12.20 21:46:30.348846 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} TCPHandler: Processed in 0.003516843 sec. 2024.12.20 21:46:30.353250 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:30.353412 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} executeQuery: (from [::1]:37730) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) 2024.12.20 21:46:30.353463 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string 2024.12.20 21:46:30.354555 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.20 21:46:30.354581 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. 2024.12.20 21:46:30.354899 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.20 21:46:30.355114 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.20 21:46:30.356622 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} executeQuery: Read 2 rows, 212.00 B in 0.003256 sec., 614.2506142506143 rows/sec., 63.58 KiB/sec. 2024.12.20 21:46:30.356663 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} TCPHandler: Processed in 0.003543982 sec. 2024.12.20 21:46:30.363334 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:30.363483 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} executeQuery: (from [::1]:37732) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) 2024.12.20 21:46:30.364794 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 2024.12.20 21:46:30.369368 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.20 21:46:30.369403 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. 2024.12.20 21:46:30.369819 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.20 21:46:30.369996 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.20 21:46:30.370175 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} executeQuery: Read 1 rows, 71.00 B in 0.006734 sec., 148.5001485001485 rows/sec., 10.30 KiB/sec. 2024.12.20 21:46:30.370219 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} TCPHandler: Processed in 0.006984305 sec. 2024.12.20 21:46:30.376837 [ 165543 ] {} TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:30.377001 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} executeQuery: (from [::1]:37730) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) 2024.12.20 21:46:30.377058 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string 2024.12.20 21:46:30.377874 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.20 21:46:30.378823 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. 2024.12.20 21:46:30.379201 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) 2024.12.20 21:46:30.379394 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.20 21:46:30.379598 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} executeQuery: Read 2 rows, 212.00 B in 0.002648 sec., 755.2870090634441 rows/sec., 78.18 KiB/sec. 2024.12.20 21:46:30.379662 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} TCPHandler: Processed in 0.002984102 sec. 2024.12.20 21:46:30.380679 [ 165544 ] {} TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:30.380809 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} executeQuery: (from [::1]:37732) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) 2024.12.20 21:46:30.382272 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 2024.12.20 21:46:30.383522 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.20 21:46:30.383547 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. 2024.12.20 21:46:30.383888 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) 2024.12.20 21:46:30.384070 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.20 21:46:30.384243 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} executeQuery: Read 1 rows, 71.00 B in 0.003468 sec., 288.3506343713956 rows/sec., 19.99 KiB/sec. 2024.12.20 21:46:30.384279 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} TCPHandler: Processed in 0.003691323 sec. 2024.12.20 21:46:30.517813 [ 163685 ] {} TCP-Session: c01cd7dc-be2c-4497-8425-84fc3d9b40d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.20 21:46:30.518019 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} executeQuery: (from [::1]:37710) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) 2024.12.20 21:46:30.518294 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema 2024.12.20 21:46:30.518363 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} InterpreterSelectQuery: FetchColumns -> Complete 2024.12.20 21:46:30.519133 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305) (SelectExecutor): Key condition: unknown 2024.12.20 21:46:30.519175 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305) (SelectExecutor): Selected 1/1 parts by partition key, 1 parts by primary key, 1/1 marks by primary key, 1 marks to read from 1 ranges 2024.12.20 21:46:30.519186 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305) (SelectExecutor): Spreading mark ranges among streams (default reading) 2024.12.20 21:46:30.519221 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} MergeTreeInOrderSelectProcessor: Reading 1 ranges in order from part all_1_1_0, approx. 1 rows starting from 0 2024.12.20 21:46:30.520234 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} executeQuery: Read 1 rows, 123.00 B in 0.002264 sec., 441.69611307420496 rows/sec., 53.06 KiB/sec. 2024.12.20 21:46:30.520306 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} TCPHandler: Processed in 0.002624412 sec.