2025.03.07 23:05:54.942450 [ 187218 ] {} SentryWriter: Sending crash reports is disabled 2025.03.07 23:05:54.942520 [ 187218 ] {} Pipe: Pipe capacity is 1.00 MiB 2025.03.07 23:05:55.081926 [ 187218 ] {} Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 187218 2025.03.07 23:05:55.081988 [ 187218 ] {} Application: starting up 2025.03.07 23:05:55.082003 [ 187218 ] {} Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 2025.03.07 23:05:55.085447 [ 187218 ] {} Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. 2025.03.07 23:05:55.088455 [ 187218 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2025.03.07 23:05:55.088630 [ 187218 ] {} AsynchronousMetrics: Scanning /sys/block 2025.03.07 23:05:55.088674 [ 187218 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2025.03.07 23:05:55.088688 [ 187218 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2025.03.07 23:05:55.489645 [ 187218 ] {} Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) 2025.03.07 23:05:55.495085 [ 187218 ] {} 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. 2025.03.07 23:05:55.500092 [ 187218 ] {} Application: Set max number of file descriptors to 524288 (was 1024). 2025.03.07 23:05:55.501107 [ 187218 ] {} Application: rlimit on number of threads is 125612 2025.03.07 23:05:55.501120 [ 187218 ] {} Application: Initializing DateLUT. 2025.03.07 23:05:55.501126 [ 187218 ] {} Application: Initialized DateLUT with time zone 'UTC'. 2025.03.07 23:05:55.501153 [ 187218 ] {} Context: Setting up /var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/datastore/tmp/ to store temporary data in it 2025.03.07 23:05:55.501445 [ 187218 ] {} Application: Initializing interserver credentials. 2025.03.07 23:05:55.501939 [ 187218 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml' 2025.03.07 23:05:55.502498 [ 187218 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml', performing update on configuration 2025.03.07 23:05:55.503069 [ 187218 ] {} 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) 2025.03.07 23:05:55.504690 [ 187218 ] {} 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) 2025.03.07 23:05:55.504701 [ 187218 ] {} Application: Merges and mutations memory limit is set to 15.34 GiB 2025.03.07 23:05:55.504747 [ 187218 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2025.03.07 23:05:55.505388 [ 187218 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2025.03.07 23:05:55.509721 [ 187218 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2025.03.07 23:05:55.510326 [ 187218 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2025.03.07 23:05:55.511811 [ 187218 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2025.03.07 23:05:55.511831 [ 187218 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml', performed update on configuration 2025.03.07 23:05:55.512427 [ 187218 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml' 2025.03.07 23:05:55.513774 [ 187218 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml', performing update on configuration 2025.03.07 23:05:55.516063 [ 187218 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml', performed update on configuration 2025.03.07 23:05:55.516460 [ 187218 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml 2025.03.07 23:05:55.517082 [ 187218 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2025.03.07 23:05:55.519624 [ 187218 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2025.03.07 23:05:55.548944 [ 187218 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2025.03.07 23:05:55.572339 [ 187218 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2025.03.07 23:05:55.573853 [ 187218 ] {} DNSCacheUpdater: Update period 15 seconds 2025.03.07 23:05:55.574210 [ 187218 ] {} Application: Loading metadata from /var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/datastore/ 2025.03.07 23:05:55.574481 [ 187316 ] {} DNSResolver: Updating DNS cache 2025.03.07 23:05:55.574507 [ 187316 ] {} DNSResolver: Updated DNS cache 2025.03.07 23:05:55.595523 [ 187218 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2025.03.07 23:05:55.595549 [ 187218 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.005667321 sec 2025.03.07 23:05:55.595556 [ 187218 ] {} ReferentialDeps: No tables 2025.03.07 23:05:55.595561 [ 187218 ] {} LoadingDeps: No tables 2025.03.07 23:05:55.596294 [ 187218 ] {} DatabaseAtomic (system): Starting up tables. 2025.03.07 23:05:55.596329 [ 187218 ] {} SystemLog: Creating system.query_log from query_log 2025.03.07 23:05:55.605674 [ 187218 ] {} SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config 2025.03.07 23:05:55.608542 [ 187218 ] {} SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config 2025.03.07 23:05:55.608560 [ 187218 ] {} SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config 2025.03.07 23:05:55.608567 [ 187218 ] {} SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config 2025.03.07 23:05:55.608574 [ 187218 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2025.03.07 23:05:55.608583 [ 187218 ] {} SystemLog: Creating system.metric_log from metric_log 2025.03.07 23:05:55.610801 [ 187218 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2025.03.07 23:05:55.611869 [ 187218 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2025.03.07 23:05:55.611889 [ 187218 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2025.03.07 23:05:55.612089 [ 187218 ] {} SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config 2025.03.07 23:05:55.612102 [ 187218 ] {} SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config 2025.03.07 23:05:55.612109 [ 187218 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2025.03.07 23:05:55.612116 [ 187218 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2025.03.07 23:05:55.612123 [ 187218 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2025.03.07 23:05:55.612129 [ 187218 ] {} SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config 2025.03.07 23:05:55.612136 [ 187218 ] {} SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config 2025.03.07 23:05:55.681066 [ 187218 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2025.03.07 23:05:55.685776 [ 187218 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2025.03.07 23:05:55.685799 [ 187218 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.516e-05 sec 2025.03.07 23:05:55.685806 [ 187218 ] {} ReferentialDeps: No tables 2025.03.07 23:05:55.685810 [ 187218 ] {} LoadingDeps: No tables 2025.03.07 23:05:55.685832 [ 187218 ] {} DatabaseAtomic (default): Starting up tables. 2025.03.07 23:05:55.685948 [ 187218 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/datastore/user_defined/ 2025.03.07 23:05:55.685980 [ 187218 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2025.03.07 23:05:55.685985 [ 187218 ] {} Application: Loaded metadata. 2025.03.07 23:05:55.686007 [ 187218 ] {} Application: Tasks stats provider: procfs 2025.03.07 23:05:55.686012 [ 187218 ] {} 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. 2025.03.07 23:05:55.686091 [ 187218 ] {} Application: Requested any available port (port == 0), actual port is 33493 2025.03.07 23:05:55.686143 [ 187218 ] {} Application: Requested any available port (port == 0), actual port is 46387 2025.03.07 23:05:55.686299 [ 187218 ] {} Application: Requested any available port (port == 0), actual port is 34575 2025.03.07 23:05:55.686340 [ 187218 ] {} Application: Requested any available port (port == 0), actual port is 43477 2025.03.07 23:05:55.686359 [ 187218 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2025.03.07 23:05:55.686742 [ 187218 ] {} AsynchronousMetrics: MemoryTracking: was 20.64 MiB, peak 20.64 MiB, free memory in arenas 16.24 MiB, will set to 382.98 MiB (RSS), difference: 362.34 MiB 2025.03.07 23:05:55.721508 [ 187218 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.3071e-05 sec. 2025.03.07 23:05:55.722440 [ 187218 ] {} Application: Listening for http://[::1]:33493 2025.03.07 23:05:55.723298 [ 187218 ] {} Application: Listening for native protocol (tcp): [::1]:46387 2025.03.07 23:05:55.723348 [ 187218 ] {} Application: Listening for http://127.0.0.1:34575 2025.03.07 23:05:55.723392 [ 187218 ] {} Application: Listening for native protocol (tcp): 127.0.0.1:43477 2025.03.07 23:05:55.723400 [ 187218 ] {} Application: Ready for connections. 2025.03.07 23:05:56.544126 [ 187227 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37176 2025.03.07 23:05:56.544489 [ 187227 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:05:56.544534 [ 187227 ] {} TCP-Session: 3086cd28-8fd7-4392-918a-08e806160208 Authenticating user 'default' from [::1]:37176 2025.03.07 23:05:56.544551 [ 187227 ] {} TCP-Session: 3086cd28-8fd7-4392-918a-08e806160208 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.544557 [ 187227 ] {} TCP-Session: 3086cd28-8fd7-4392-918a-08e806160208 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.544646 [ 187227 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2025.03.07 23:05:56.544670 [ 187227 ] {} 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 2025.03.07 23:05:56.544678 [ 187227 ] {} 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 2025.03.07 23:05:56.545530 [ 187228 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37178 2025.03.07 23:05:56.545717 [ 187229 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37180 2025.03.07 23:05:56.545907 [ 188146 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37182 2025.03.07 23:05:56.546336 [ 188147 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37184 2025.03.07 23:05:56.546455 [ 188148 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37186 2025.03.07 23:05:56.546750 [ 187228 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:05:56.546841 [ 187228 ] {} TCP-Session: 010201ff-3318-4f53-bbb1-374d29b1e5d5 Authenticating user 'default' from [::1]:37178 2025.03.07 23:05:56.546859 [ 187228 ] {} TCP-Session: 010201ff-3318-4f53-bbb1-374d29b1e5d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.546858 [ 187229 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:05:56.546867 [ 187228 ] {} TCP-Session: 010201ff-3318-4f53-bbb1-374d29b1e5d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.546980 [ 188146 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:05:56.547024 [ 188146 ] {} TCP-Session: 544a178c-c819-465e-941d-a52cdea2b9f1 Authenticating user 'default' from [::1]:37182 2025.03.07 23:05:56.547034 [ 188146 ] {} TCP-Session: 544a178c-c819-465e-941d-a52cdea2b9f1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.547040 [ 188146 ] {} TCP-Session: 544a178c-c819-465e-941d-a52cdea2b9f1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.547101 [ 187229 ] {} TCP-Session: a2108406-f093-4099-bfb1-fed50be7fb78 Authenticating user 'default' from [::1]:37180 2025.03.07 23:05:56.547117 [ 187229 ] {} TCP-Session: a2108406-f093-4099-bfb1-fed50be7fb78 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.547122 [ 187229 ] {} TCP-Session: a2108406-f093-4099-bfb1-fed50be7fb78 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.547381 [ 188147 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:05:56.548931 [ 188147 ] {} TCP-Session: 09aba7f8-a1e5-4cf6-b665-ecdfed7ab784 Authenticating user 'default' from [::1]:37184 2025.03.07 23:05:56.548948 [ 188147 ] {} TCP-Session: 09aba7f8-a1e5-4cf6-b665-ecdfed7ab784 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.548955 [ 188147 ] {} TCP-Session: 09aba7f8-a1e5-4cf6-b665-ecdfed7ab784 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.547418 [ 188148 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:05:56.548510 [ 188149 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37188 2025.03.07 23:05:56.548699 [ 188150 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37190 2025.03.07 23:05:56.549150 [ 188148 ] {} TCP-Session: 7ec78d3c-10c5-4488-82b9-6c2f9b7f304e Authenticating user 'default' from [::1]:37186 2025.03.07 23:05:56.549181 [ 188148 ] {} TCP-Session: 7ec78d3c-10c5-4488-82b9-6c2f9b7f304e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.549190 [ 188148 ] {} TCP-Session: 7ec78d3c-10c5-4488-82b9-6c2f9b7f304e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.549331 [ 188149 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:05:56.549361 [ 188149 ] {} TCP-Session: dac0653a-ec81-4c6a-a2d2-0be6475d7154 Authenticating user 'default' from [::1]:37188 2025.03.07 23:05:56.549370 [ 188149 ] {} TCP-Session: dac0653a-ec81-4c6a-a2d2-0be6475d7154 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.549377 [ 188149 ] {} TCP-Session: dac0653a-ec81-4c6a-a2d2-0be6475d7154 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.549727 [ 188150 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:05:56.550470 [ 188150 ] {} TCP-Session: 6e235efa-4371-4881-b585-ea07ceb48f3b Authenticating user 'default' from [::1]:37190 2025.03.07 23:05:56.550489 [ 188150 ] {} TCP-Session: 6e235efa-4371-4881-b585-ea07ceb48f3b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:05:56.550496 [ 188150 ] {} TCP-Session: 6e235efa-4371-4881-b585-ea07ceb48f3b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:03.127320 [ 187524 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 2025.03.07 23:06:03.127384 [ 187524 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2025.03.07 23:06:03.142578 [ 187524 ] {} StoragePolicy (default): Storage policy default created, total volumes 1 2025.03.07 23:06:03.146418 [ 187524 ] {} system.metric_log (8e785c2a-631f-4c97-8d70-14002e02c3f0): Loading data parts 2025.03.07 23:06:03.158486 [ 187524 ] {} system.metric_log (8e785c2a-631f-4c97-8d70-14002e02c3f0): There are no data parts 2025.03.07 23:06:03.159943 [ 187587 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 1958 entries to flush up to offset 1958 2025.03.07 23:06:03.160026 [ 187587 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2025.03.07 23:06:03.164484 [ 187587 ] {} system.asynchronous_metric_log (958ad1e4-3b8a-4a5f-b099-4b6f6836dc95): Loading data parts 2025.03.07 23:06:03.164649 [ 187587 ] {} system.asynchronous_metric_log (958ad1e4-3b8a-4a5f-b099-4b6f6836dc95): There are no data parts 2025.03.07 23:06:03.170017 [ 187587 ] {} system.asynchronous_metric_log (958ad1e4-3b8a-4a5f-b099-4b6f6836dc95): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2025.03.07 23:06:03.170055 [ 187587 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 160.65 GiB. 2025.03.07 23:06:03.172169 [ 187587 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2025.03.07 23:06:03.172415 [ 187587 ] {} system.asynchronous_metric_log (958ad1e4-3b8a-4a5f-b099-4b6f6836dc95): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2025.03.07 23:06:03.172630 [ 187587 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1958 2025.03.07 23:06:03.214623 [ 187524 ] {} system.metric_log (8e785c2a-631f-4c97-8d70-14002e02c3f0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2025.03.07 23:06:03.214667 [ 187524 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 160.65 GiB. 2025.03.07 23:06:03.247146 [ 187524 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2025.03.07 23:06:03.258113 [ 187524 ] {} system.metric_log (8e785c2a-631f-4c97-8d70-14002e02c3f0): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2025.03.07 23:06:03.268150 [ 187524 ] {} SystemLog (system.metric_log): Flushed system log up to offset 8 2025.03.07 23:06:04.000485 [ 187754 ] {} AsynchronousMetrics: MemoryTracking: was 388.56 MiB, peak 392.56 MiB, free memory in arenas 28.64 MiB, will set to 393.51 MiB (RSS), difference: 4.96 MiB 2025.03.07 23:06:06.374441 [ 189480 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37192 2025.03.07 23:06:06.374591 [ 189480 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.374621 [ 189480 ] {} TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Authenticating user 'default' from [::1]:37192 2025.03.07 23:06:06.374648 [ 189480 ] {} TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.374655 [ 189480 ] {} TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.388121 [ 189480 ] {} TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.394493 [ 189480 ] {4b92d933-0695-4c44-ab2a-60b5bd531272} executeQuery: (from [::1]:37192) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2025.03.07 23:06:06.395271 [ 189480 ] {4b92d933-0695-4c44-ab2a-60b5bd531272} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:37192) (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. ? @ 0x00007f8b06392ac3 in ? 17. ? @ 0x00007f8b06424850 in ? 2025.03.07 23:06:06.395427 [ 189480 ] {4b92d933-0695-4c44-ab2a-60b5bd531272} 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. ? @ 0x00007f8b06392ac3 in ? 17. ? @ 0x00007f8b06424850 in ? 2025.03.07 23:06:06.395494 [ 189480 ] {4b92d933-0695-4c44-ab2a-60b5bd531272} TCPHandler: Processed in 0.007549469 sec. 2025.03.07 23:06:06.397770 [ 189480 ] {} TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.397924 [ 189480 ] {92f3dd67-01b5-44fe-abc6-b9e9ed2c6e23} executeQuery: (from [::1]:37192) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2025.03.07 23:06:06.398157 [ 189480 ] {92f3dd67-01b5-44fe-abc6-b9e9ed2c6e23} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:37192) (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. ? @ 0x00007f8b06392ac3 in ? 17. ? @ 0x00007f8b06424850 in ? 2025.03.07 23:06:06.398264 [ 189480 ] {92f3dd67-01b5-44fe-abc6-b9e9ed2c6e23} 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. ? @ 0x00007f8b06392ac3 in ? 17. ? @ 0x00007f8b06424850 in ? 2025.03.07 23:06:06.412010 [ 189480 ] {92f3dd67-01b5-44fe-abc6-b9e9ed2c6e23} TCPHandler: Processed in 0.01432706 sec. 2025.03.07 23:06:06.418147 [ 189540 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37198 2025.03.07 23:06:06.418279 [ 189540 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.418303 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Authenticating user 'default' from [::1]:37198 2025.03.07 23:06:06.418317 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.418342 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.432126 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.432541 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} executeQuery: (from [::1]:37198) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) 2025.03.07 23:06:06.432592 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* 2025.03.07 23:06:06.437233 [ 189546 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37204 2025.03.07 23:06:06.437317 [ 189546 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.437344 [ 189546 ] {} TCP-Session: ddde36ec-f378-4f76-822b-9dd02b20e6c0 Authenticating user 'default' from [::1]:37204 2025.03.07 23:06:06.437357 [ 189546 ] {} TCP-Session: ddde36ec-f378-4f76-822b-9dd02b20e6c0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.437363 [ 189546 ] {} TCP-Session: ddde36ec-f378-4f76-822b-9dd02b20e6c0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.437483 [ 189541 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37200 2025.03.07 23:06:06.437555 [ 189541 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.437574 [ 189541 ] {} TCP-Session: a786b0a4-9ce6-4bf0-8574-2554a76f6e51 Authenticating user 'default' from [::1]:37200 2025.03.07 23:06:06.437596 [ 189541 ] {} TCP-Session: a786b0a4-9ce6-4bf0-8574-2554a76f6e51 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.437601 [ 189541 ] {} TCP-Session: a786b0a4-9ce6-4bf0-8574-2554a76f6e51 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.437703 [ 189538 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37196 2025.03.07 23:06:06.437764 [ 189538 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.437781 [ 189538 ] {} TCP-Session: c95696c4-5a12-4036-8083-e0f8f9f642cc Authenticating user 'default' from [::1]:37196 2025.03.07 23:06:06.437789 [ 189538 ] {} TCP-Session: c95696c4-5a12-4036-8083-e0f8f9f642cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.437794 [ 189538 ] {} TCP-Session: c95696c4-5a12-4036-8083-e0f8f9f642cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.437899 [ 189550 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37206 2025.03.07 23:06:06.437999 [ 189550 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.438022 [ 189550 ] {} TCP-Session: 6fd6a72d-2f93-4108-8905-c8b06fe03fc8 Authenticating user 'default' from [::1]:37206 2025.03.07 23:06:06.438035 [ 189550 ] {} TCP-Session: 6fd6a72d-2f93-4108-8905-c8b06fe03fc8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438041 [ 189550 ] {} TCP-Session: 6fd6a72d-2f93-4108-8905-c8b06fe03fc8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438128 [ 189542 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37202 2025.03.07 23:06:06.437953 [ 189481 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37194 2025.03.07 23:06:06.438309 [ 189542 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.438332 [ 189542 ] {} TCP-Session: c5b544fb-a1d8-4387-8d4d-27138802512e Authenticating user 'default' from [::1]:37202 2025.03.07 23:06:06.438340 [ 189542 ] {} TCP-Session: c5b544fb-a1d8-4387-8d4d-27138802512e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438348 [ 189542 ] {} TCP-Session: c5b544fb-a1d8-4387-8d4d-27138802512e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438475 [ 189551 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37208 2025.03.07 23:06:06.438565 [ 189551 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.438593 [ 189551 ] {} TCP-Session: 91bd81b0-c5d7-4a9c-98fe-adeb601d2ce9 Authenticating user 'default' from [::1]:37208 2025.03.07 23:06:06.438604 [ 189551 ] {} TCP-Session: 91bd81b0-c5d7-4a9c-98fe-adeb601d2ce9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438611 [ 189551 ] {} TCP-Session: 91bd81b0-c5d7-4a9c-98fe-adeb601d2ce9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438716 [ 189481 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.438742 [ 189481 ] {} TCP-Session: 6809418f-b6f2-4379-9899-08681dbbbbde Authenticating user 'default' from [::1]:37194 2025.03.07 23:06:06.438751 [ 189481 ] {} TCP-Session: 6809418f-b6f2-4379-9899-08681dbbbbde Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438757 [ 189481 ] {} TCP-Session: 6809418f-b6f2-4379-9899-08681dbbbbde Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438853 [ 189481 ] {} TCPHandler: Done processing connection. 2025.03.07 23:06:06.438882 [ 189481 ] {} TCP-Session: 6809418f-b6f2-4379-9899-08681dbbbbde Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438909 [ 189481 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37212 2025.03.07 23:06:06.438941 [ 189481 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.438953 [ 189481 ] {} TCP-Session: f305560a-b8bd-48d1-8e6c-e9e6cb8bd789 Authenticating user 'default' from [::1]:37212 2025.03.07 23:06:06.438962 [ 189481 ] {} TCP-Session: f305560a-b8bd-48d1-8e6c-e9e6cb8bd789 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.438968 [ 189481 ] {} TCP-Session: f305560a-b8bd-48d1-8e6c-e9e6cb8bd789 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.439541 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. 2025.03.07 23:06:06.439558 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00116319 sec 2025.03.07 23:06:06.439568 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} ReferentialDeps: No tables 2025.03.07 23:06:06.439582 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} LoadingDeps: No tables 2025.03.07 23:06:06.439605 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} DatabaseAtomic (oximeter): Starting up tables. 2025.03.07 23:06:06.439691 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} TCPHandler: Processed in 0.00777707 sec. 2025.03.07 23:06:06.440109 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.440375 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} executeQuery: (from [::1]:37198) /* 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) 2025.03.07 23:06:06.438865 [ 189552 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:37210 2025.03.07 23:06:06.441927 [ 189552 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2025.03.07 23:06:06.441952 [ 189552 ] {} TCP-Session: 506cac86-e47f-43c9-8df0-155b0c97cb03 Authenticating user 'default' from [::1]:37210 2025.03.07 23:06:06.441963 [ 189552 ] {} TCP-Session: 506cac86-e47f-43c9-8df0-155b0c97cb03 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.441970 [ 189552 ] {} TCP-Session: 506cac86-e47f-43c9-8df0-155b0c97cb03 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2025.03.07 23:06:06.442071 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version 2025.03.07 23:06:06.448195 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} oximeter.version (6e8d9d1c-e902-4bd9-8343-d5745ada33f7): Loading data parts 2025.03.07 23:06:06.449638 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} oximeter.version (6e8d9d1c-e902-4bd9-8343-d5745ada33f7): There are no data parts 2025.03.07 23:06:06.460059 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} TCPHandler: Processed in 0.020012091 sec. 2025.03.07 23:06:06.462349 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.462601 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} executeQuery: (from [::1]:37198) /* 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) 2025.03.07 23:06:06.462652 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool 2025.03.07 23:06:06.469473 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} oximeter.measurements_bool (b2b09582-adff-4398-bffe-12a5c2eba123): Loading data parts 2025.03.07 23:06:06.493137 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} oximeter.measurements_bool (b2b09582-adff-4398-bffe-12a5c2eba123): There are no data parts 2025.03.07 23:06:06.497617 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} TCPHandler: Processed in 0.035380301 sec. 2025.03.07 23:06:06.498207 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.498438 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:06.498586 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 2025.03.07 23:06:06.504011 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} oximeter.measurements_i8 (8bb2d539-e6f3-420b-983c-41bf6dbcc810): Loading data parts 2025.03.07 23:06:06.504289 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} oximeter.measurements_i8 (8bb2d539-e6f3-420b-983c-41bf6dbcc810): There are no data parts 2025.03.07 23:06:06.510214 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} TCPHandler: Processed in 0.01207692 sec. 2025.03.07 23:06:06.511081 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.512996 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:06.513046 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 2025.03.07 23:06:06.519994 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} oximeter.measurements_u8 (7f4e19a0-61e9-4500-8adf-4ce7244d404d): Loading data parts 2025.03.07 23:06:06.520205 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} oximeter.measurements_u8 (7f4e19a0-61e9-4500-8adf-4ce7244d404d): There are no data parts 2025.03.07 23:06:06.524939 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} TCPHandler: Processed in 0.014208741 sec. 2025.03.07 23:06:06.525595 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.525878 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:06.527337 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 2025.03.07 23:06:06.534529 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} oximeter.measurements_i16 (d3cb43f5-7ed3-4ee1-b92a-5fce612b9bd7): Loading data parts 2025.03.07 23:06:06.534805 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} oximeter.measurements_i16 (d3cb43f5-7ed3-4ee1-b92a-5fce612b9bd7): There are no data parts 2025.03.07 23:06:06.539246 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} TCPHandler: Processed in 0.013764681 sec. 2025.03.07 23:06:06.540118 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.540346 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:06.540401 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 2025.03.07 23:06:06.548337 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} oximeter.measurements_u16 (4924d3ee-f18c-4c1f-91ef-c21e0d475367): Loading data parts 2025.03.07 23:06:06.548705 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} oximeter.measurements_u16 (4924d3ee-f18c-4c1f-91ef-c21e0d475367): There are no data parts 2025.03.07 23:06:06.553086 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} TCPHandler: Processed in 0.01307319 sec. 2025.03.07 23:06:06.633519 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:06.635602 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:06.635661 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 2025.03.07 23:06:06.643612 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} oximeter.measurements_i32 (c164e8f4-bb50-407a-9a00-9544b05185a5): Loading data parts 2025.03.07 23:06:06.643873 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} oximeter.measurements_i32 (c164e8f4-bb50-407a-9a00-9544b05185a5): There are no data parts 2025.03.07 23:06:06.653340 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} TCPHandler: Processed in 0.020009221 sec. 2025.03.07 23:06:07.012115 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.012429 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.012485 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 2025.03.07 23:06:07.018890 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} oximeter.measurements_u32 (320a758f-3ad5-4b35-a062-983e02c8160c): Loading data parts 2025.03.07 23:06:07.019177 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} oximeter.measurements_u32 (320a758f-3ad5-4b35-a062-983e02c8160c): There are no data parts 2025.03.07 23:06:07.023444 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} TCPHandler: Processed in 0.01151963 sec. 2025.03.07 23:06:07.059258 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.059582 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.059645 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 2025.03.07 23:06:07.064588 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} oximeter.measurements_i64 (7aaafe7b-bf9c-4ccb-b97a-423d3a83877f): Loading data parts 2025.03.07 23:06:07.064842 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} oximeter.measurements_i64 (7aaafe7b-bf9c-4ccb-b97a-423d3a83877f): There are no data parts 2025.03.07 23:06:07.068916 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} TCPHandler: Processed in 0.009846431 sec. 2025.03.07 23:06:07.074094 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.074381 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.074438 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 2025.03.07 23:06:07.079961 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} oximeter.measurements_u64 (124d25ab-716a-4a57-9d83-2b728a67ae1e): Loading data parts 2025.03.07 23:06:07.081871 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} oximeter.measurements_u64 (124d25ab-716a-4a57-9d83-2b728a67ae1e): There are no data parts 2025.03.07 23:06:07.089102 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} TCPHandler: Processed in 0.01517988 sec. 2025.03.07 23:06:07.090064 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.091318 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.091378 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 2025.03.07 23:06:07.097412 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} oximeter.measurements_f32 (8f5faeb5-6e94-4463-a3c8-9f0a208ff856): Loading data parts 2025.03.07 23:06:07.098263 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} oximeter.measurements_f32 (8f5faeb5-6e94-4463-a3c8-9f0a208ff856): There are no data parts 2025.03.07 23:06:07.102882 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} TCPHandler: Processed in 0.01297828 sec. 2025.03.07 23:06:07.104474 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.104760 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.104816 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 2025.03.07 23:06:07.110540 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} oximeter.measurements_f64 (1c465c38-2efb-44c7-865b-a77cbfbda405): Loading data parts 2025.03.07 23:06:07.110765 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} oximeter.measurements_f64 (1c465c38-2efb-44c7-865b-a77cbfbda405): There are no data parts 2025.03.07 23:06:07.116317 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} TCPHandler: Processed in 0.01202232 sec. 2025.03.07 23:06:07.117689 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.118420 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.118472 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string 2025.03.07 23:06:07.123366 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} oximeter.measurements_string (f429d33b-4321-4a4b-a3c3-da8234b21f41): Loading data parts 2025.03.07 23:06:07.123814 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} oximeter.measurements_string (f429d33b-4321-4a4b-a3c3-da8234b21f41): There are no data parts 2025.03.07 23:06:07.135234 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} TCPHandler: Processed in 0.017732241 sec. 2025.03.07 23:06:07.137521 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.137808 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.137864 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes 2025.03.07 23:06:07.145064 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} oximeter.measurements_bytes (ef30098d-4c42-45a0-a1ef-614ee82e9b96): Loading data parts 2025.03.07 23:06:07.145317 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} oximeter.measurements_bytes (ef30098d-4c42-45a0-a1ef-614ee82e9b96): There are no data parts 2025.03.07 23:06:07.152072 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} TCPHandler: Processed in 0.01470774 sec. 2025.03.07 23:06:07.152881 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.154157 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.154206 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 2025.03.07 23:06:07.159779 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} oximeter.measurements_cumulativei64 (e940844d-a06d-4af2-a0ed-278c8104d49a): Loading data parts 2025.03.07 23:06:07.160029 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} oximeter.measurements_cumulativei64 (e940844d-a06d-4af2-a0ed-278c8104d49a): There are no data parts 2025.03.07 23:06:07.167322 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} TCPHandler: Processed in 0.01453574 sec. 2025.03.07 23:06:07.167998 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.169636 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.169692 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 2025.03.07 23:06:07.176331 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} oximeter.measurements_cumulativeu64 (238e3de2-a6e6-4f92-810e-da14f1eda6f3): Loading data parts 2025.03.07 23:06:07.176970 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} oximeter.measurements_cumulativeu64 (238e3de2-a6e6-4f92-810e-da14f1eda6f3): There are no data parts 2025.03.07 23:06:07.182667 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} TCPHandler: Processed in 0.01480704 sec. 2025.03.07 23:06:07.183477 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.187436 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.187495 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 2025.03.07 23:06:07.194092 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} oximeter.measurements_cumulativef32 (edcea3a2-f6a0-4556-92ff-c4c7fa67c542): Loading data parts 2025.03.07 23:06:07.195652 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} oximeter.measurements_cumulativef32 (edcea3a2-f6a0-4556-92ff-c4c7fa67c542): There are no data parts 2025.03.07 23:06:07.202133 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} TCPHandler: Processed in 0.018771341 sec. 2025.03.07 23:06:07.202721 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.202950 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.203034 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 2025.03.07 23:06:07.210318 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} oximeter.measurements_cumulativef64 (fa7eb5a9-2c03-4163-a722-abe6b9dc2cb5): Loading data parts 2025.03.07 23:06:07.210683 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} oximeter.measurements_cumulativef64 (fa7eb5a9-2c03-4163-a722-abe6b9dc2cb5): There are no data parts 2025.03.07 23:06:07.219203 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} TCPHandler: Processed in 0.01659801 sec. 2025.03.07 23:06:07.219684 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.220053 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.220118 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 2025.03.07 23:06:07.229307 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} oximeter.measurements_histogrami8 (7e417eee-062f-4f30-9136-f8fda29e3a31): Loading data parts 2025.03.07 23:06:07.231049 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} oximeter.measurements_histogrami8 (7e417eee-062f-4f30-9136-f8fda29e3a31): There are no data parts 2025.03.07 23:06:07.238643 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} TCPHandler: Processed in 0.0190908 sec. 2025.03.07 23:06:07.239125 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.239471 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.241169 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 2025.03.07 23:06:07.249603 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} oximeter.measurements_histogramu8 (7cc852d4-397e-41e4-8f16-448e0f834dc3): Loading data parts 2025.03.07 23:06:07.249806 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} oximeter.measurements_histogramu8 (7cc852d4-397e-41e4-8f16-448e0f834dc3): There are no data parts 2025.03.07 23:06:07.256152 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} TCPHandler: Processed in 0.01719913 sec. 2025.03.07 23:06:07.256473 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.256704 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.256743 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 2025.03.07 23:06:07.264118 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} oximeter.measurements_histogrami16 (5087c0fd-9ef4-4957-8889-76bb46a9a65d): Loading data parts 2025.03.07 23:06:07.265434 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} oximeter.measurements_histogrami16 (5087c0fd-9ef4-4957-8889-76bb46a9a65d): There are no data parts 2025.03.07 23:06:07.271340 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} TCPHandler: Processed in 0.014943891 sec. 2025.03.07 23:06:07.272000 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.272290 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.272342 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 2025.03.07 23:06:07.285308 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} oximeter.measurements_histogramu16 (a6fc5e08-1138-4198-849e-260c62e0cb9e): Loading data parts 2025.03.07 23:06:07.291110 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} oximeter.measurements_histogramu16 (a6fc5e08-1138-4198-849e-260c62e0cb9e): There are no data parts 2025.03.07 23:06:07.299061 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} TCPHandler: Processed in 0.02713668 sec. 2025.03.07 23:06:07.299536 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.300967 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.301030 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 2025.03.07 23:06:07.323252 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} oximeter.measurements_histogrami32 (9ce7fb8f-6539-4648-9423-ba3a0af93156): Loading data parts 2025.03.07 23:06:07.331107 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} oximeter.measurements_histogrami32 (9ce7fb8f-6539-4648-9423-ba3a0af93156): There are no data parts 2025.03.07 23:06:07.336103 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} TCPHandler: Processed in 0.036691421 sec. 2025.03.07 23:06:07.336491 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.336770 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.336962 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 2025.03.07 23:06:07.350339 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} oximeter.measurements_histogramu32 (270836f9-9da3-4650-81df-6a8c6deb4c04): Loading data parts 2025.03.07 23:06:07.351537 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} oximeter.measurements_histogramu32 (270836f9-9da3-4650-81df-6a8c6deb4c04): There are no data parts 2025.03.07 23:06:07.355296 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} TCPHandler: Processed in 0.01887635 sec. 2025.03.07 23:06:07.355873 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.356172 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.356248 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 2025.03.07 23:06:07.361313 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} oximeter.measurements_histogrami64 (000024c6-c866-4d5d-8eb2-dafd73580abe): Loading data parts 2025.03.07 23:06:07.362468 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} oximeter.measurements_histogrami64 (000024c6-c866-4d5d-8eb2-dafd73580abe): There are no data parts 2025.03.07 23:06:07.369093 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} TCPHandler: Processed in 0.01328888 sec. 2025.03.07 23:06:07.369506 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.369818 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.372014 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 2025.03.07 23:06:07.380645 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} oximeter.measurements_histogramu64 (8db5744f-6573-41b3-bc7c-0808f4458f54): Loading data parts 2025.03.07 23:06:07.381276 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} oximeter.measurements_histogramu64 (8db5744f-6573-41b3-bc7c-0808f4458f54): There are no data parts 2025.03.07 23:06:07.387721 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} TCPHandler: Processed in 0.01834111 sec. 2025.03.07 23:06:07.388150 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.388483 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.389706 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 2025.03.07 23:06:07.395401 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} oximeter.measurements_histogramf32 (f63570e8-0014-48a9-ad33-e42178af179f): Loading data parts 2025.03.07 23:06:07.395683 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} oximeter.measurements_histogramf32 (f63570e8-0014-48a9-ad33-e42178af179f): There are no data parts 2025.03.07 23:06:07.401476 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} TCPHandler: Processed in 0.01345926 sec. 2025.03.07 23:06:07.402193 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.404899 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.404963 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 2025.03.07 23:06:07.412369 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} oximeter.measurements_histogramf64 (52a6bb77-8ee5-46e5-9423-d59efd9383d0): Loading data parts 2025.03.07 23:06:07.412653 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} oximeter.measurements_histogramf64 (52a6bb77-8ee5-46e5-9423-d59efd9383d0): There are no data parts 2025.03.07 23:06:07.417478 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} TCPHandler: Processed in 0.015369861 sec. 2025.03.07 23:06:07.417888 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.419560 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} executeQuery: (from [::1]:37198) /* 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) 2025.03.07 23:06:07.419627 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool 2025.03.07 23:06:07.425164 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} oximeter.fields_bool (b00057c3-d4f8-4f64-8628-3482b987b43e): Loading data parts 2025.03.07 23:06:07.428491 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} oximeter.fields_bool (b00057c3-d4f8-4f64-8628-3482b987b43e): There are no data parts 2025.03.07 23:06:07.436335 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} TCPHandler: Processed in 0.01854937 sec. 2025.03.07 23:06:07.436706 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.436926 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.436990 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 2025.03.07 23:06:07.443047 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} oximeter.fields_i8 (efde99ef-587c-4e14-a429-3c58fa388b02): Loading data parts 2025.03.07 23:06:07.444488 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} oximeter.fields_i8 (efde99ef-587c-4e14-a429-3c58fa388b02): There are no data parts 2025.03.07 23:06:07.452245 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} TCPHandler: Processed in 0.01564622 sec. 2025.03.07 23:06:07.453090 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.454443 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.454492 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 2025.03.07 23:06:07.462210 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} oximeter.fields_u8 (cc91961d-1107-432e-a0e9-fcf2071614ab): Loading data parts 2025.03.07 23:06:07.462475 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} oximeter.fields_u8 (cc91961d-1107-432e-a0e9-fcf2071614ab): There are no data parts 2025.03.07 23:06:07.468768 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} TCPHandler: Processed in 0.015766811 sec. 2025.03.07 23:06:07.469555 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.471127 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.471183 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 2025.03.07 23:06:07.476594 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} oximeter.fields_i16 (81d4cb92-032a-4459-ab44-ee557e049542): Loading data parts 2025.03.07 23:06:07.476880 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} oximeter.fields_i16 (81d4cb92-032a-4459-ab44-ee557e049542): There are no data parts 2025.03.07 23:06:07.483101 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} TCPHandler: Processed in 0.01364968 sec. 2025.03.07 23:06:07.483442 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.483597 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.483630 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 2025.03.07 23:06:07.493289 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} oximeter.fields_u16 (5072ede2-61d3-4946-af95-9803a053bd51): Loading data parts 2025.03.07 23:06:07.493639 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} oximeter.fields_u16 (5072ede2-61d3-4946-af95-9803a053bd51): There are no data parts 2025.03.07 23:06:07.500771 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} TCPHandler: Processed in 0.0173971 sec. 2025.03.07 23:06:07.501123 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.501305 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.501346 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 2025.03.07 23:06:07.508766 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} oximeter.fields_i32 (9f3ad90e-d1f2-4714-b651-923b5a45873c): Loading data parts 2025.03.07 23:06:07.508947 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} oximeter.fields_i32 (9f3ad90e-d1f2-4714-b651-923b5a45873c): There are no data parts 2025.03.07 23:06:07.518605 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} TCPHandler: Processed in 0.01754631 sec. 2025.03.07 23:06:07.518926 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.519214 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.519274 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 2025.03.07 23:06:07.527321 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} oximeter.fields_u32 (a78d85c5-cdcc-4d95-905a-8ed201c203ce): Loading data parts 2025.03.07 23:06:07.529404 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} oximeter.fields_u32 (a78d85c5-cdcc-4d95-905a-8ed201c203ce): There are no data parts 2025.03.07 23:06:07.543724 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} TCPHandler: Processed in 0.024870251 sec. 2025.03.07 23:06:07.544145 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.545871 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.545924 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 2025.03.07 23:06:07.552482 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} oximeter.fields_i64 (45f58419-48f7-4132-ad99-da5cecddfd3b): Loading data parts 2025.03.07 23:06:07.552714 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} oximeter.fields_i64 (45f58419-48f7-4132-ad99-da5cecddfd3b): There are no data parts 2025.03.07 23:06:07.559522 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} TCPHandler: Processed in 0.01550932 sec. 2025.03.07 23:06:07.559890 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.561613 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.561657 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 2025.03.07 23:06:07.569696 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} oximeter.fields_u64 (a153f92f-27a4-4732-a175-7bbe24ac2fda): Loading data parts 2025.03.07 23:06:07.571626 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} oximeter.fields_u64 (a153f92f-27a4-4732-a175-7bbe24ac2fda): There are no data parts 2025.03.07 23:06:07.578909 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} TCPHandler: Processed in 0.01910419 sec. 2025.03.07 23:06:07.579816 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.581481 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.581528 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr 2025.03.07 23:06:07.587116 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} oximeter.fields_ipaddr (79407497-43eb-4460-9ce0-b97f1145122b): Loading data parts 2025.03.07 23:06:07.587322 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} oximeter.fields_ipaddr (79407497-43eb-4460-9ce0-b97f1145122b): There are no data parts 2025.03.07 23:06:07.598117 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} TCPHandler: Processed in 0.01837679 sec. 2025.03.07 23:06:07.598532 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.598771 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.598824 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string 2025.03.07 23:06:07.606424 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} oximeter.fields_string (2ffeab99-1849-4cb4-be7a-0029de35d59f): Loading data parts 2025.03.07 23:06:07.607973 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} oximeter.fields_string (2ffeab99-1849-4cb4-be7a-0029de35d59f): There are no data parts 2025.03.07 23:06:07.613652 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} TCPHandler: Processed in 0.01523978 sec. 2025.03.07 23:06:07.614079 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.614367 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} executeQuery: (from [::1]:37198) 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) 2025.03.07 23:06:07.614418 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid 2025.03.07 23:06:07.620520 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} oximeter.fields_uuid (e4271603-6969-442b-b562-f16e0a9d5ad6): Loading data parts 2025.03.07 23:06:07.622068 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} oximeter.fields_uuid (e4271603-6969-442b-b562-f16e0a9d5ad6): There are no data parts 2025.03.07 23:06:07.629422 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} TCPHandler: Processed in 0.01545026 sec. 2025.03.07 23:06:07.629805 [ 189540 ] {} TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.632154 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} executeQuery: (from [::1]:37198) /* 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) 2025.03.07 23:06:07.632210 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema 2025.03.07 23:06:07.638769 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} oximeter.timeseries_schema (a29c0f74-def9-45c8-9eb7-96cb7a9b0eed): Loading data parts 2025.03.07 23:06:07.639058 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} oximeter.timeseries_schema (a29c0f74-def9-45c8-9eb7-96cb7a9b0eed): There are no data parts 2025.03.07 23:06:07.647658 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} TCPHandler: Processed in 0.01796871 sec. 2025.03.07 23:06:07.648215 [ 189480 ] {} TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2025.03.07 23:06:07.648388 [ 189480 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} executeQuery: (from [::1]:37192) INSERT INTO oximeter.version (*) VALUES (stage: Complete) 2025.03.07 23:06:07.648468 [ 189480 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version 2025.03.07 23:06:07.649264 [ 189621 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} oximeter.version (6e8d9d1c-e902-4bd9-8343-d5745ada33f7): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2025.03.07 23:06:07.649288 [ 189621 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 160.50 GiB. 2025.03.07 23:06:07.650246 [ 189621 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2025.03.07 23:06:07.650445 [ 189621 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} oximeter.version (6e8d9d1c-e902-4bd9-8343-d5745ada33f7): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2025.03.07 23:06:07.650625 [ 189480 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} executeQuery: Read 1 rows, 16.00 B in 0.002298 sec., 435.1610095735422 rows/sec., 6.80 KiB/sec. 2025.03.07 23:06:07.650783 [ 189480 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} TCPHandler: Processed in 0.00269855 sec.