2024.11.07 23:40:05.223412 [ 196466 ] {} SentryWriter: Sending crash reports is disabled 2024.11.07 23:40:05.223484 [ 196466 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.11.07 23:40:05.294379 [ 196466 ] {} Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 196466 2024.11.07 23:40:05.294424 [ 196466 ] {} Application: starting up 2024.11.07 23:40:05.294437 [ 196466 ] {} Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 2024.11.07 23:40:05.297224 [ 196466 ] {} Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. 2024.11.07 23:40:05.297993 [ 196466 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.11.07 23:40:05.298011 [ 196466 ] {} AsynchronousMetrics: Scanning /sys/block 2024.11.07 23:40:05.298048 [ 196466 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.11.07 23:40:05.298063 [ 196466 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.11.07 23:40:05.472111 [ 196466 ] {} Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) 2024.11.07 23:40:05.472153 [ 196466 ] {} Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. 2024.11.07 23:40:05.490130 [ 196466 ] {} Application: Set max number of file descriptors to 524288 (was 1024). 2024.11.07 23:40:05.490154 [ 196466 ] {} Application: rlimit on number of threads is 125612 2024.11.07 23:40:05.490163 [ 196466 ] {} Application: Initializing DateLUT. 2024.11.07 23:40:05.490168 [ 196466 ] {} Application: Initialized DateLUT with time zone 'UTC'. 2024.11.07 23:40:05.490193 [ 196466 ] {} Context: Setting up /var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/datastore/tmp/ to store temporary data in it 2024.11.07 23:40:05.490895 [ 196466 ] {} Application: Initializing interserver credentials. 2024.11.07 23:40:05.491409 [ 196466 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml' 2024.11.07 23:40:05.491784 [ 196466 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml', performing update on configuration 2024.11.07 23:40:05.492252 [ 196466 ] {} Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) 2024.11.07 23:40:05.492263 [ 196466 ] {} Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) 2024.11.07 23:40:05.492269 [ 196466 ] {} Application: Merges and mutations memory limit is set to 15.34 GiB 2024.11.07 23:40:05.492309 [ 196466 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.11.07 23:40:05.493054 [ 196466 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.11.07 23:40:05.522319 [ 196466 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.11.07 23:40:05.526271 [ 196466 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.11.07 23:40:05.538053 [ 196466 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.11.07 23:40:05.538087 [ 196466 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml', performed update on configuration 2024.11.07 23:40:05.541813 [ 196466 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml' 2024.11.07 23:40:05.542266 [ 196466 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml', performing update on configuration 2024.11.07 23:40:05.549611 [ 196466 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml', performed update on configuration 2024.11.07 23:40:05.553747 [ 196466 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml 2024.11.07 23:40:05.554490 [ 196466 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.11.07 23:40:05.562401 [ 196466 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.11.07 23:40:05.562665 [ 196466 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.11.07 23:40:05.564070 [ 196466 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.11.07 23:40:05.573519 [ 196466 ] {} DNSCacheUpdater: Update period 15 seconds 2024.11.07 23:40:05.573595 [ 196728 ] {} DNSResolver: Updating DNS cache 2024.11.07 23:40:05.573615 [ 196728 ] {} DNSResolver: Updated DNS cache 2024.11.07 23:40:05.573635 [ 196466 ] {} Application: Loading metadata from /var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/datastore/ 2024.11.07 23:40:05.589940 [ 196466 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.11.07 23:40:05.589966 [ 196466 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000140889 sec 2024.11.07 23:40:05.589973 [ 196466 ] {} ReferentialDeps: No tables 2024.11.07 23:40:05.589978 [ 196466 ] {} LoadingDeps: No tables 2024.11.07 23:40:05.590000 [ 196466 ] {} DatabaseAtomic (system): Starting up tables. 2024.11.07 23:40:05.590029 [ 196466 ] {} SystemLog: Creating system.query_log from query_log 2024.11.07 23:40:05.591402 [ 196466 ] {} SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config 2024.11.07 23:40:05.591418 [ 196466 ] {} SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config 2024.11.07 23:40:05.591425 [ 196466 ] {} SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config 2024.11.07 23:40:05.591432 [ 196466 ] {} SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config 2024.11.07 23:40:05.591438 [ 196466 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.11.07 23:40:05.591445 [ 196466 ] {} SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config 2024.11.07 23:40:05.591451 [ 196466 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.11.07 23:40:05.591459 [ 196466 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.11.07 23:40:05.591471 [ 196466 ] {} SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config 2024.11.07 23:40:05.591478 [ 196466 ] {} SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config 2024.11.07 23:40:05.591485 [ 196466 ] {} SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config 2024.11.07 23:40:05.591491 [ 196466 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.11.07 23:40:05.591497 [ 196466 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.11.07 23:40:05.591504 [ 196466 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.11.07 23:40:05.591510 [ 196466 ] {} SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config 2024.11.07 23:40:05.591517 [ 196466 ] {} SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config 2024.11.07 23:40:05.625452 [ 196466 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.11.07 23:40:05.644281 [ 196466 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.11.07 23:40:05.644327 [ 196466 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.035e-05 sec 2024.11.07 23:40:05.644334 [ 196466 ] {} ReferentialDeps: No tables 2024.11.07 23:40:05.644339 [ 196466 ] {} LoadingDeps: No tables 2024.11.07 23:40:05.644361 [ 196466 ] {} DatabaseAtomic (default): Starting up tables. 2024.11.07 23:40:05.644461 [ 196466 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/datastore/user_defined/ 2024.11.07 23:40:05.644491 [ 196466 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.11.07 23:40:05.644497 [ 196466 ] {} Application: Loaded metadata. 2024.11.07 23:40:05.644515 [ 196466 ] {} Application: Tasks stats provider: procfs 2024.11.07 23:40:05.644522 [ 196466 ] {} Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. 2024.11.07 23:40:05.644595 [ 196466 ] {} Application: Requested any available port (port == 0), actual port is 34915 2024.11.07 23:40:05.644642 [ 196466 ] {} Application: Requested any available port (port == 0), actual port is 42383 2024.11.07 23:40:05.644790 [ 196466 ] {} Application: Requested any available port (port == 0), actual port is 45547 2024.11.07 23:40:05.644844 [ 196466 ] {} Application: Requested any available port (port == 0), actual port is 35949 2024.11.07 23:40:05.644864 [ 196466 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.11.07 23:40:05.645263 [ 196466 ] {} AsynchronousMetrics: MemoryTracking: was 20.60 MiB, peak 20.60 MiB, free memory in arenas 9.74 MiB, will set to 373.79 MiB (RSS), difference: 353.19 MiB 2024.11.07 23:40:05.646999 [ 196466 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.1311e-05 sec. 2024.11.07 23:40:05.647747 [ 196466 ] {} Application: Listening for http://[::1]:34915 2024.11.07 23:40:05.647925 [ 196466 ] {} Application: Listening for native protocol (tcp): [::1]:42383 2024.11.07 23:40:05.648019 [ 196466 ] {} Application: Listening for http://127.0.0.1:45547 2024.11.07 23:40:05.648081 [ 196466 ] {} Application: Listening for native protocol (tcp): 127.0.0.1:35949 2024.11.07 23:40:05.648091 [ 196466 ] {} Application: Ready for connections. 2024.11.07 23:40:06.499758 [ 196491 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56432 2024.11.07 23:40:06.514350 [ 196491 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:06.514379 [ 196491 ] {} TCP-Session: e31770f0-5d57-409c-b94c-7c1630329e23 Authenticating user 'default' from [::1]:56432 2024.11.07 23:40:06.514393 [ 196491 ] {} TCP-Session: e31770f0-5d57-409c-b94c-7c1630329e23 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.514399 [ 196491 ] {} TCP-Session: e31770f0-5d57-409c-b94c-7c1630329e23 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.514481 [ 196491 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.11.07 23:40:06.514503 [ 196491 ] {} ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION 2024.11.07 23:40:06.514513 [ 196491 ] {} ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION 2024.11.07 23:40:06.515884 [ 196493 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56436 2024.11.07 23:40:06.515970 [ 196493 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:06.515997 [ 196493 ] {} TCP-Session: 28170af0-0f49-472c-acb9-8085c4962c58 Authenticating user 'default' from [::1]:56436 2024.11.07 23:40:06.516008 [ 196493 ] {} TCP-Session: 28170af0-0f49-472c-acb9-8085c4962c58 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.516014 [ 196493 ] {} TCP-Session: 28170af0-0f49-472c-acb9-8085c4962c58 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.551578 [ 197293 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56438 2024.11.07 23:40:06.551698 [ 197293 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:06.551726 [ 197293 ] {} TCP-Session: f88fdeb4-2f74-4e15-b4c0-96d94adec63a Authenticating user 'default' from [::1]:56438 2024.11.07 23:40:06.551741 [ 197293 ] {} TCP-Session: f88fdeb4-2f74-4e15-b4c0-96d94adec63a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.551748 [ 197293 ] {} TCP-Session: f88fdeb4-2f74-4e15-b4c0-96d94adec63a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.575979 [ 197294 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56440 2024.11.07 23:40:06.576005 [ 197296 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56444 2024.11.07 23:40:06.577577 [ 197294 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:06.577615 [ 197294 ] {} TCP-Session: fab74c6b-d4b3-42cf-8d4a-ad723fe9cd4a Authenticating user 'default' from [::1]:56440 2024.11.07 23:40:06.577632 [ 197294 ] {} TCP-Session: fab74c6b-d4b3-42cf-8d4a-ad723fe9cd4a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.577639 [ 197294 ] {} TCP-Session: fab74c6b-d4b3-42cf-8d4a-ad723fe9cd4a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.577637 [ 197296 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:06.577687 [ 197296 ] {} TCP-Session: f3e968e0-afbf-47d1-a8f3-f913fd6f9146 Authenticating user 'default' from [::1]:56444 2024.11.07 23:40:06.577699 [ 197296 ] {} TCP-Session: f3e968e0-afbf-47d1-a8f3-f913fd6f9146 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.577706 [ 197296 ] {} TCP-Session: f3e968e0-afbf-47d1-a8f3-f913fd6f9146 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.591061 [ 196492 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56434 2024.11.07 23:40:06.591063 [ 197295 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56442 2024.11.07 23:40:06.592452 [ 197295 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:06.592475 [ 197295 ] {} TCP-Session: bf0aa8ec-6434-4939-8e8f-7522a3f8a70a Authenticating user 'default' from [::1]:56442 2024.11.07 23:40:06.592487 [ 197295 ] {} TCP-Session: bf0aa8ec-6434-4939-8e8f-7522a3f8a70a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.592494 [ 197295 ] {} TCP-Session: bf0aa8ec-6434-4939-8e8f-7522a3f8a70a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.592770 [ 196492 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:06.592799 [ 196492 ] {} TCP-Session: ac7fff8e-52ae-48aa-b30c-c845bc7e8231 Authenticating user 'default' from [::1]:56434 2024.11.07 23:40:06.592810 [ 196492 ] {} TCP-Session: ac7fff8e-52ae-48aa-b30c-c845bc7e8231 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.592817 [ 196492 ] {} TCP-Session: ac7fff8e-52ae-48aa-b30c-c845bc7e8231 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.591137 [ 197297 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56446 2024.11.07 23:40:06.592977 [ 197297 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:06.593001 [ 197297 ] {} TCP-Session: 63c94e7e-470e-41d7-8a53-cb994170888b Authenticating user 'default' from [::1]:56446 2024.11.07 23:40:06.593010 [ 197297 ] {} TCP-Session: 63c94e7e-470e-41d7-8a53-cb994170888b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:06.593078 [ 197297 ] {} TCP-Session: 63c94e7e-470e-41d7-8a53-cb994170888b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.286502 [ 197785 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56448 2024.11.07 23:40:15.286625 [ 197785 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.286658 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Authenticating user 'default' from [::1]:56448 2024.11.07 23:40:15.286673 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.286680 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.288305 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.289959 [ 197785 ] {c7e89b99-bed2-4b6d-8c5f-2d10e5755e4b} executeQuery: (from [::1]:56448) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.11.07 23:40:15.290657 [ 197785 ] {c7e89b99-bed2-4b6d-8c5f-2d10e5755e4b} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:56448) (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. ? @ 0x00007fce488faac3 in ? 17. ? @ 0x00007fce4898c850 in ? 2024.11.07 23:40:15.290844 [ 197785 ] {c7e89b99-bed2-4b6d-8c5f-2d10e5755e4b} 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. ? @ 0x00007fce488faac3 in ? 17. ? @ 0x00007fce4898c850 in ? 2024.11.07 23:40:15.290960 [ 197785 ] {c7e89b99-bed2-4b6d-8c5f-2d10e5755e4b} TCPHandler: Processed in 0.002833313 sec. 2024.11.07 23:40:15.291760 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.292579 [ 197785 ] {1c3a515b-36f3-4d1d-82d4-69bbb51d13d2} executeQuery: (from [::1]:56448) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.11.07 23:40:15.292839 [ 197785 ] {1c3a515b-36f3-4d1d-82d4-69bbb51d13d2} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:56448) (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. ? @ 0x00007fce488faac3 in ? 17. ? @ 0x00007fce4898c850 in ? 2024.11.07 23:40:15.292985 [ 197785 ] {1c3a515b-36f3-4d1d-82d4-69bbb51d13d2} 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. ? @ 0x00007fce488faac3 in ? 17. ? @ 0x00007fce4898c850 in ? 2024.11.07 23:40:15.293078 [ 197785 ] {1c3a515b-36f3-4d1d-82d4-69bbb51d13d2} TCPHandler: Processed in 0.001377521 sec. 2024.11.07 23:40:15.293919 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.295201 [ 197785 ] {a1ca6010-1e11-4d24-bf2b-52ef6d29f10a} executeQuery: (from [::1]:56448) DROP DATABASE IF EXISTS oximeter (stage: Complete) 2024.11.07 23:40:15.295288 [ 197785 ] {a1ca6010-1e11-4d24-bf2b-52ef6d29f10a} TCPHandler: Processed in 0.001430811 sec. 2024.11.07 23:40:15.296666 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.296780 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} executeQuery: (from [::1]:56448) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) 2024.11.07 23:40:15.296811 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* 2024.11.07 23:40:15.301143 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. 2024.11.07 23:40:15.301194 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00014685 sec 2024.11.07 23:40:15.301204 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} ReferentialDeps: No tables 2024.11.07 23:40:15.301211 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} LoadingDeps: No tables 2024.11.07 23:40:15.301232 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} DatabaseAtomic (oximeter): Starting up tables. 2024.11.07 23:40:15.301323 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} TCPHandler: Processed in 0.004726614 sec. 2024.11.07 23:40:15.302356 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.302552 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} executeQuery: (from [::1]:56448) /* The version table contains metadata about the `oximeter` database */ CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) 2024.11.07 23:40:15.302594 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version 2024.11.07 23:40:15.303478 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} StoragePolicy (default): Storage policy default created, total volumes 1 2024.11.07 23:40:15.309272 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} oximeter.version (95637719-7cd6-4375-8b6a-0074c61d457f): Loading data parts 2024.11.07 23:40:15.314096 [ 197786 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56450 2024.11.07 23:40:15.314200 [ 197786 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.315136 [ 197786 ] {} TCP-Session: 1298bd90-e7f7-4c6f-a291-554d1e3a70ad Authenticating user 'default' from [::1]:56450 2024.11.07 23:40:15.315178 [ 197786 ] {} TCP-Session: 1298bd90-e7f7-4c6f-a291-554d1e3a70ad Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.315185 [ 197786 ] {} TCP-Session: 1298bd90-e7f7-4c6f-a291-554d1e3a70ad Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.323811 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} oximeter.version (95637719-7cd6-4375-8b6a-0074c61d457f): There are no data parts 2024.11.07 23:40:15.328643 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} TCPHandler: Processed in 0.026384941 sec. 2024.11.07 23:40:15.340820 [ 197794 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56462 2024.11.07 23:40:15.340942 [ 197794 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.340958 [ 197791 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56456 2024.11.07 23:40:15.341005 [ 197794 ] {} TCP-Session: b1d7c0a3-6eb6-4cf7-bd38-b6cce2585683 Authenticating user 'default' from [::1]:56462 2024.11.07 23:40:15.341031 [ 197794 ] {} TCP-Session: b1d7c0a3-6eb6-4cf7-bd38-b6cce2585683 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.341039 [ 197794 ] {} TCP-Session: b1d7c0a3-6eb6-4cf7-bd38-b6cce2585683 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.341039 [ 197791 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.341065 [ 197791 ] {} TCP-Session: f33b0fdd-da1f-4a3a-aa5e-b281a6bd61dc Authenticating user 'default' from [::1]:56456 2024.11.07 23:40:15.341075 [ 197791 ] {} TCP-Session: f33b0fdd-da1f-4a3a-aa5e-b281a6bd61dc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.341081 [ 197791 ] {} TCP-Session: f33b0fdd-da1f-4a3a-aa5e-b281a6bd61dc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.341195 [ 197791 ] {} TCPHandler: Done processing connection. 2024.11.07 23:40:15.341220 [ 197791 ] {} TCP-Session: f33b0fdd-da1f-4a3a-aa5e-b281a6bd61dc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.341445 [ 197798 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56470 2024.11.07 23:40:15.342544 [ 197798 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.342565 [ 197798 ] {} TCP-Session: a589fe36-1c8c-4eb9-9c90-98172cf9b4a5 Authenticating user 'default' from [::1]:56470 2024.11.07 23:40:15.342573 [ 197798 ] {} TCP-Session: a589fe36-1c8c-4eb9-9c90-98172cf9b4a5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.342577 [ 197798 ] {} TCP-Session: a589fe36-1c8c-4eb9-9c90-98172cf9b4a5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.341537 [ 197795 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56464 2024.11.07 23:40:15.342741 [ 197795 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.342787 [ 197795 ] {} TCP-Session: 5fb0e81e-7c51-4e8b-9ec6-e92af25d75c4 Authenticating user 'default' from [::1]:56464 2024.11.07 23:40:15.342769 [ 197789 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56454 2024.11.07 23:40:15.342803 [ 197795 ] {} TCP-Session: 5fb0e81e-7c51-4e8b-9ec6-e92af25d75c4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.341753 [ 197788 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56452 2024.11.07 23:40:15.342794 [ 197792 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56458 2024.11.07 23:40:15.342810 [ 197795 ] {} TCP-Session: 5fb0e81e-7c51-4e8b-9ec6-e92af25d75c4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.341751 [ 197796 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56466 2024.11.07 23:40:15.342904 [ 197789 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.342935 [ 197789 ] {} TCP-Session: 6c35a915-8e9d-4279-a0bf-825c4a0ed700 Authenticating user 'default' from [::1]:56454 2024.11.07 23:40:15.342944 [ 197789 ] {} TCP-Session: 6c35a915-8e9d-4279-a0bf-825c4a0ed700 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.342951 [ 197789 ] {} TCP-Session: 6c35a915-8e9d-4279-a0bf-825c4a0ed700 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343079 [ 197796 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.343083 [ 197797 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56468 2024.11.07 23:40:15.343109 [ 197796 ] {} TCP-Session: 0233d11d-c532-46c6-9a89-5697dbd0c6b0 Authenticating user 'default' from [::1]:56466 2024.11.07 23:40:15.343097 [ 197793 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56460 2024.11.07 23:40:15.343121 [ 197789 ] {} TCPHandler: Done processing connection. 2024.11.07 23:40:15.343120 [ 197796 ] {} TCP-Session: 0233d11d-c532-46c6-9a89-5697dbd0c6b0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343143 [ 197796 ] {} TCP-Session: 0233d11d-c532-46c6-9a89-5697dbd0c6b0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343166 [ 197797 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.343181 [ 197788 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.343193 [ 197797 ] {} TCP-Session: 2975604e-1615-4dd7-8721-65bce47993cc Authenticating user 'default' from [::1]:56468 2024.11.07 23:40:15.341574 [ 197799 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:56472 2024.11.07 23:40:15.343202 [ 197788 ] {} TCP-Session: 56009516-2ce1-4b1c-b4a6-97c4d2217676 Authenticating user 'default' from [::1]:56452 2024.11.07 23:40:15.343201 [ 197797 ] {} TCP-Session: 2975604e-1615-4dd7-8721-65bce47993cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343225 [ 197788 ] {} TCP-Session: 56009516-2ce1-4b1c-b4a6-97c4d2217676 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343236 [ 197797 ] {} TCP-Session: 2975604e-1615-4dd7-8721-65bce47993cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343143 [ 197789 ] {} TCP-Session: 6c35a915-8e9d-4279-a0bf-825c4a0ed700 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343339 [ 197792 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.343249 [ 197788 ] {} TCP-Session: 56009516-2ce1-4b1c-b4a6-97c4d2217676 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343747 [ 197788 ] {} TCPHandler: Done processing connection. 2024.11.07 23:40:15.343767 [ 197788 ] {} TCP-Session: 56009516-2ce1-4b1c-b4a6-97c4d2217676 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343412 [ 197799 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.343425 [ 197793 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.07 23:40:15.343954 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Authenticating user 'default' from [::1]:56460 2024.11.07 23:40:15.343965 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.343972 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.344057 [ 197799 ] {} TCP-Session: 852d105e-e1d6-4630-82b3-7c32d27dab1c Authenticating user 'default' from [::1]:56472 2024.11.07 23:40:15.344072 [ 197799 ] {} TCP-Session: 852d105e-e1d6-4630-82b3-7c32d27dab1c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.344078 [ 197799 ] {} TCP-Session: 852d105e-e1d6-4630-82b3-7c32d27dab1c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.344103 [ 197792 ] {} TCP-Session: 8cbc17a0-b29d-4188-8c46-d5061d5bfaae Authenticating user 'default' from [::1]:56458 2024.11.07 23:40:15.344121 [ 197792 ] {} TCP-Session: 8cbc17a0-b29d-4188-8c46-d5061d5bfaae Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.344128 [ 197792 ] {} TCP-Session: 8cbc17a0-b29d-4188-8c46-d5061d5bfaae Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.344208 [ 197792 ] {} TCPHandler: Done processing connection. 2024.11.07 23:40:15.344224 [ 197792 ] {} TCP-Session: 8cbc17a0-b29d-4188-8c46-d5061d5bfaae Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.07 23:40:15.600388 [ 196824 ] {} SystemLog (system.query_log): Flushing system log, 8 entries to flush up to offset 8 2024.11.07 23:40:15.600471 [ 196824 ] {} SystemLog (system.query_log): Creating new table system.query_log for QueryLog 2024.11.07 23:40:15.606863 [ 196824 ] {} system.query_log (1cd01d8d-d39a-4ddb-bb15-375667d2687e): Loading data parts 2024.11.07 23:40:15.607023 [ 196824 ] {} system.query_log (1cd01d8d-d39a-4ddb-bb15-375667d2687e): There are no data parts 2024.11.07 23:40:15.613915 [ 196824 ] {} system.query_log (1cd01d8d-d39a-4ddb-bb15-375667d2687e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.07 23:40:15.613949 [ 196824 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 164.62 GiB. 2024.11.07 23:40:15.616702 [ 196824 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.11.07 23:40:15.616969 [ 196824 ] {} system.query_log (1cd01d8d-d39a-4ddb-bb15-375667d2687e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.11.07 23:40:15.618159 [ 196824 ] {} SystemLog (system.query_log): Flushed system log up to offset 8 2024.11.07 23:40:15.653963 [ 197794 ] {} TCP-Session: b1d7c0a3-6eb6-4cf7-bd38-b6cce2585683 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.654322 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} executeQuery: (from [::1]:56462) /* The measurement tables contain all individual samples from each timeseries. * * Each table stores a single datum type, and otherwise contains nearly the same * structure. The primary sorting key is on the timeseries name, key, and then * timestamp, so that all timeseries from the same schema are grouped, followed * by all samples from the same timeseries. * * This reflects that one usually looks up the _key_ in one or more field table, * and then uses that to index quickly into the measurements tables. */ CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Bool) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.656096 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool 2024.11.07 23:40:15.660697 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} oximeter.measurements_bool (60a8b2e5-1962-49a6-8897-7e778dc36e09): Loading data parts 2024.11.07 23:40:15.663183 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} oximeter.measurements_bool (60a8b2e5-1962-49a6-8897-7e778dc36e09): There are no data parts 2024.11.07 23:40:15.675224 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} TCPHandler: Processed in 0.021485598 sec. 2024.11.07 23:40:15.676777 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.677478 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.677548 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 2024.11.07 23:40:15.682586 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} oximeter.measurements_i8 (8024cb19-106d-4cfc-96cb-8efe7cb4c12d): Loading data parts 2024.11.07 23:40:15.682916 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} oximeter.measurements_i8 (8024cb19-106d-4cfc-96cb-8efe7cb4c12d): There are no data parts 2024.11.07 23:40:15.686566 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} TCPHandler: Processed in 0.009912148 sec. 2024.11.07 23:40:15.688769 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.689148 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.690348 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 2024.11.07 23:40:15.694694 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} oximeter.measurements_u8 (1ffef74c-df76-4830-ad2b-018748b47379): Loading data parts 2024.11.07 23:40:15.694990 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} oximeter.measurements_u8 (1ffef74c-df76-4830-ad2b-018748b47379): There are no data parts 2024.11.07 23:40:15.700546 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} TCPHandler: Processed in 0.01195134 sec. 2024.11.07 23:40:15.705336 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.705651 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.705706 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 2024.11.07 23:40:15.711126 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} oximeter.measurements_i16 (cb4eaa25-220a-4671-a772-4f2c39c0337a): Loading data parts 2024.11.07 23:40:15.714197 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} oximeter.measurements_i16 (cb4eaa25-220a-4671-a772-4f2c39c0337a): There are no data parts 2024.11.07 23:40:15.719680 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} TCPHandler: Processed in 0.014507631 sec. 2024.11.07 23:40:15.733061 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.733343 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.733400 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 2024.11.07 23:40:15.738589 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} oximeter.measurements_u16 (7a1dbfeb-0e8b-4613-8885-23f653a770a4): Loading data parts 2024.11.07 23:40:15.738830 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} oximeter.measurements_u16 (7a1dbfeb-0e8b-4613-8885-23f653a770a4): There are no data parts 2024.11.07 23:40:15.742982 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} TCPHandler: Processed in 0.010096528 sec. 2024.11.07 23:40:15.748359 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.748638 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.748688 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 2024.11.07 23:40:15.754304 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} oximeter.measurements_i32 (8e83bacd-c22a-4c6f-9a6b-a8d8cc4bcd09): Loading data parts 2024.11.07 23:40:15.754503 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} oximeter.measurements_i32 (8e83bacd-c22a-4c6f-9a6b-a8d8cc4bcd09): There are no data parts 2024.11.07 23:40:15.759154 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} TCPHandler: Processed in 0.010958529 sec. 2024.11.07 23:40:15.760523 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.760805 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.761907 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 2024.11.07 23:40:15.769134 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} oximeter.measurements_u32 (d40d4583-cf74-4c08-9a11-caafe97e4d68): Loading data parts 2024.11.07 23:40:15.769360 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} oximeter.measurements_u32 (d40d4583-cf74-4c08-9a11-caafe97e4d68): There are no data parts 2024.11.07 23:40:15.772984 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} TCPHandler: Processed in 0.01261882 sec. 2024.11.07 23:40:15.776901 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.777759 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.777815 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 2024.11.07 23:40:15.782774 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} oximeter.measurements_i64 (48aa8ad5-aa8b-48b3-97da-707086136622): Loading data parts 2024.11.07 23:40:15.782989 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} oximeter.measurements_i64 (48aa8ad5-aa8b-48b3-97da-707086136622): There are no data parts 2024.11.07 23:40:15.786204 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} TCPHandler: Processed in 0.009459018 sec. 2024.11.07 23:40:15.788213 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.789640 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.789695 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 2024.11.07 23:40:15.794064 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} oximeter.measurements_u64 (1f62ad17-d32b-4df7-b34a-9467cc451c0a): Loading data parts 2024.11.07 23:40:15.794319 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} oximeter.measurements_u64 (1f62ad17-d32b-4df7-b34a-9467cc451c0a): There are no data parts 2024.11.07 23:40:15.797601 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} TCPHandler: Processed in 0.009536427 sec. 2024.11.07 23:40:15.800475 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.801438 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.801489 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 2024.11.07 23:40:15.805374 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} oximeter.measurements_f32 (aacfad2c-ac1d-48a2-8df7-996900b3f2cc): Loading data parts 2024.11.07 23:40:15.805636 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} oximeter.measurements_f32 (aacfad2c-ac1d-48a2-8df7-996900b3f2cc): There are no data parts 2024.11.07 23:40:15.809359 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} TCPHandler: Processed in 0.009034547 sec. 2024.11.07 23:40:15.810668 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.811517 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_f64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.811564 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 2024.11.07 23:40:15.815582 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} oximeter.measurements_f64 (3e8262d8-3941-4e9e-8ae0-d3cc2c536c24): Loading data parts 2024.11.07 23:40:15.815845 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} oximeter.measurements_f64 (3e8262d8-3941-4e9e-8ae0-d3cc2c536c24): There are no data parts 2024.11.07 23:40:15.821256 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} TCPHandler: Processed in 0.010710678 sec. 2024.11.07 23:40:15.822007 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.822263 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_string ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(String) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.823273 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string 2024.11.07 23:40:15.828830 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} oximeter.measurements_string (fe858cac-0263-4196-a8d7-43920405195a): Loading data parts 2024.11.07 23:40:15.829074 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} oximeter.measurements_string (fe858cac-0263-4196-a8d7-43920405195a): There are no data parts 2024.11.07 23:40:15.833403 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} TCPHandler: Processed in 0.011528329 sec. 2024.11.07 23:40:15.834911 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.835841 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* * NOTE: Right now we can't unambiguously record a nullable byte array. * Arrays cannot be nested in `Nullable()` types, and encoding the array as * a string isn't palatable for a few reasons. * See: https://github.com/oxidecomputer/omicron/issues/4551 for more * details. */ datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.835892 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes 2024.11.07 23:40:15.841194 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} oximeter.measurements_bytes (1eb64d49-4446-4999-aedd-afd6075fe7b4): Loading data parts 2024.11.07 23:40:15.841407 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} oximeter.measurements_bytes (1eb64d49-4446-4999-aedd-afd6075fe7b4): There are no data parts 2024.11.07 23:40:15.845191 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} TCPHandler: Processed in 0.010398718 sec. 2024.11.07 23:40:15.845898 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.846169 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativei64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.847245 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 2024.11.07 23:40:15.851622 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} oximeter.measurements_cumulativei64 (ba2b6b82-c51d-4610-b636-4dd79bb073b6): Loading data parts 2024.11.07 23:40:15.851904 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} oximeter.measurements_cumulativei64 (ba2b6b82-c51d-4610-b636-4dd79bb073b6): There are no data parts 2024.11.07 23:40:15.855317 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} TCPHandler: Processed in 0.009564378 sec. 2024.11.07 23:40:15.856129 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.856394 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.856445 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 2024.11.07 23:40:15.862924 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} oximeter.measurements_cumulativeu64 (20a84a2c-3297-4bdd-b0bf-37ffe42eff2a): Loading data parts 2024.11.07 23:40:15.864776 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} oximeter.measurements_cumulativeu64 (20a84a2c-3297-4bdd-b0bf-37ffe42eff2a): There are no data parts 2024.11.07 23:40:15.868349 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} TCPHandler: Processed in 0.01237086 sec. 2024.11.07 23:40:15.871585 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.871877 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.871934 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 2024.11.07 23:40:15.876839 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} oximeter.measurements_cumulativef32 (e2e56c78-cef1-4eb3-9ac9-de36ad534543): Loading data parts 2024.11.07 23:40:15.877056 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} oximeter.measurements_cumulativef32 (e2e56c78-cef1-4eb3-9ac9-de36ad534543): There are no data parts 2024.11.07 23:40:15.880446 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} TCPHandler: Processed in 0.009036167 sec. 2024.11.07 23:40:15.881603 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.881857 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.881904 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 2024.11.07 23:40:15.887105 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} oximeter.measurements_cumulativef64 (2adbd49a-d7b0-4802-8252-fe98f47752ea): Loading data parts 2024.11.07 23:40:15.887313 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} oximeter.measurements_cumulativef64 (2adbd49a-d7b0-4802-8252-fe98f47752ea): There are no data parts 2024.11.07 23:40:15.891133 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} TCPHandler: Processed in 0.009661827 sec. 2024.11.07 23:40:15.892084 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.893037 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* * NOTE: Array types cannot be Nullable, see * https://clickhouse.com/docs/en/sql-reference/data-types/nullable * for more details. * * This means we need to use empty arrays to indicate a missing value. This * is unfortunate, and at this point relies on the fact that an * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need * to figure out another way to represent missing samples here. */ bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.893097 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 2024.11.07 23:40:15.898284 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} oximeter.measurements_histogrami8 (52e3c5d1-7501-4c42-82c3-938bf0543914): Loading data parts 2024.11.07 23:40:15.898471 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} oximeter.measurements_histogrami8 (52e3c5d1-7501-4c42-82c3-938bf0543914): There are no data parts 2024.11.07 23:40:15.902294 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} TCPHandler: Processed in 0.010334078 sec. 2024.11.07 23:40:15.903404 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.903746 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.903802 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 2024.11.07 23:40:15.914023 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} oximeter.measurements_histogramu8 (5fe087a5-de3d-40cd-bc22-721d3dae9878): Loading data parts 2024.11.07 23:40:15.914244 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} oximeter.measurements_histogramu8 (5fe087a5-de3d-40cd-bc22-721d3dae9878): There are no data parts 2024.11.07 23:40:15.918126 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} TCPHandler: Processed in 0.014828672 sec. 2024.11.07 23:40:15.919135 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.919500 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.919575 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 2024.11.07 23:40:15.928695 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} oximeter.measurements_histogrami16 (e76b822d-644c-46cc-a348-e83ce601dfae): Loading data parts 2024.11.07 23:40:15.929033 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} oximeter.measurements_histogrami16 (e76b822d-644c-46cc-a348-e83ce601dfae): There are no data parts 2024.11.07 23:40:15.933171 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} TCPHandler: Processed in 0.014192221 sec. 2024.11.07 23:40:15.934207 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.935289 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.935365 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 2024.11.07 23:40:15.940836 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} oximeter.measurements_histogramu16 (73caee0b-be3c-4d2c-b7bc-8425a651232f): Loading data parts 2024.11.07 23:40:15.941570 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} oximeter.measurements_histogramu16 (73caee0b-be3c-4d2c-b7bc-8425a651232f): There are no data parts 2024.11.07 23:40:15.944965 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} TCPHandler: Processed in 0.010908099 sec. 2024.11.07 23:40:15.947963 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.948350 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.948416 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 2024.11.07 23:40:15.954162 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} oximeter.measurements_histogrami32 (4ffbc0aa-a52c-4eeb-99c0-04cbf4805284): Loading data parts 2024.11.07 23:40:15.954409 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} oximeter.measurements_histogrami32 (4ffbc0aa-a52c-4eeb-99c0-04cbf4805284): There are no data parts 2024.11.07 23:40:15.958455 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} TCPHandler: Processed in 0.010651639 sec. 2024.11.07 23:40:15.959405 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.960635 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.960707 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 2024.11.07 23:40:15.966847 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} oximeter.measurements_histogramu32 (148eef67-95e3-4719-b416-452f78e2282b): Loading data parts 2024.11.07 23:40:15.969734 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} oximeter.measurements_histogramu32 (148eef67-95e3-4719-b416-452f78e2282b): There are no data parts 2024.11.07 23:40:15.974280 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} TCPHandler: Processed in 0.015038782 sec. 2024.11.07 23:40:15.975240 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.975598 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.975658 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 2024.11.07 23:40:15.980785 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} oximeter.measurements_histogrami64 (f9b640cf-4108-41c2-9748-a6816191a31a): Loading data parts 2024.11.07 23:40:15.981216 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} oximeter.measurements_histogrami64 (f9b640cf-4108-41c2-9748-a6816191a31a): There are no data parts 2024.11.07 23:40:15.985439 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} TCPHandler: Processed in 0.010357258 sec. 2024.11.07 23:40:15.986506 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:15.986842 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:15.986898 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 2024.11.07 23:40:15.992485 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} oximeter.measurements_histogramu64 (275cca0f-76db-400b-b433-ef4737ab92ec): Loading data parts 2024.11.07 23:40:15.992681 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} oximeter.measurements_histogramu64 (275cca0f-76db-400b-b433-ef4737ab92ec): There are no data parts 2024.11.07 23:40:15.997449 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} TCPHandler: Processed in 0.011071569 sec. 2024.11.07 23:40:16.000976 [ 197022 ] {} AsynchronousMetrics: MemoryTracking: was 386.55 MiB, peak 386.55 MiB, free memory in arenas 17.75 MiB, will set to 383.31 MiB (RSS), difference: -3.25 MiB 2024.11.07 23:40:16.033882 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.034230 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.034293 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 2024.11.07 23:40:16.038260 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} oximeter.measurements_histogramf32 (f695c85a-68e3-41e2-8755-51edec5d47a4): Loading data parts 2024.11.07 23:40:16.038500 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} oximeter.measurements_histogramf32 (f695c85a-68e3-41e2-8755-51edec5d47a4): There are no data parts 2024.11.07 23:40:16.046783 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} TCPHandler: Processed in 0.013078551 sec. 2024.11.07 23:40:16.052072 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.052424 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.052492 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 2024.11.07 23:40:16.058119 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} oximeter.measurements_histogramf64 (07486bff-bfe4-4ad2-bbab-8f418b24c3de): Loading data parts 2024.11.07 23:40:16.063425 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} oximeter.measurements_histogramf64 (07486bff-bfe4-4ad2-bbab-8f418b24c3de): There are no data parts 2024.11.07 23:40:16.071703 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} TCPHandler: Processed in 0.019802726 sec. 2024.11.07 23:40:16.073430 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.073751 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} executeQuery: (from [::1]:56448) /* The field tables store named dimensions of each timeseries. * * As with the measurement tables, there is one field table for each field data * type. Fields are deduplicated by using the "replacing merge tree", though * this behavior **must not** be relied upon for query correctness. * * The index for the fields differs from the measurements, however. Rows are * sorted by timeseries name, then field name, field value, and finally * timeseries key. This reflects the most common pattern for looking them up: * by field name and possibly value, within a timeseries. The resulting keys are * usually then used to look up measurements. * * NOTE: We may want to consider a secondary index on these tables, sorting by * timeseries name and then key, since it would improve lookups where one * already has the key. Realistically though, these tables are quite small and * so performance benefits will be low in absolute terms. * * TTL: We use a materialized column to expire old field table records. This * column is generated automatically by the database whenever a new row is * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` * query. Since these tables are `ReplacingMergeTree`s, that means the last * record will remain during a deduplication, which will have the last * timestamp. ClickHouse will then expire old data for us, similar to the * measurement tables. */ CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.073814 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool 2024.11.07 23:40:16.078993 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} oximeter.fields_bool (85f85151-cd9e-41ca-bb2f-4a9444476e4c): Loading data parts 2024.11.07 23:40:16.079704 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} oximeter.fields_bool (85f85151-cd9e-41ca-bb2f-4a9444476e4c): There are no data parts 2024.11.07 23:40:16.091091 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} TCPHandler: Processed in 0.017830104 sec. 2024.11.07 23:40:16.092199 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.092411 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.092452 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 2024.11.07 23:40:16.102768 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} oximeter.fields_i8 (f83230bc-37b4-41d9-b028-5ca8a4d0df66): Loading data parts 2024.11.07 23:40:16.105311 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} oximeter.fields_i8 (f83230bc-37b4-41d9-b028-5ca8a4d0df66): There are no data parts 2024.11.07 23:40:16.110488 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} TCPHandler: Processed in 0.018442955 sec. 2024.11.07 23:40:16.112268 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.112570 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.112628 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 2024.11.07 23:40:16.119294 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} oximeter.fields_u8 (ad009b0d-559b-465f-8176-7e7b89654ff1): Loading data parts 2024.11.07 23:40:16.119518 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} oximeter.fields_u8 (ad009b0d-559b-465f-8176-7e7b89654ff1): There are no data parts 2024.11.07 23:40:16.123498 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} TCPHandler: Processed in 0.011406799 sec. 2024.11.07 23:40:16.124395 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.125166 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.125215 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 2024.11.07 23:40:16.130626 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} oximeter.fields_i16 (af709981-b0e0-41d4-91cf-7a3c90d3bb01): Loading data parts 2024.11.07 23:40:16.130910 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} oximeter.fields_i16 (af709981-b0e0-41d4-91cf-7a3c90d3bb01): There are no data parts 2024.11.07 23:40:16.134690 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} TCPHandler: Processed in 0.010481838 sec. 2024.11.07 23:40:16.135313 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.135595 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.135644 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 2024.11.07 23:40:16.141448 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} oximeter.fields_u16 (86ed507b-905d-4270-ad83-28e4a65549f1): Loading data parts 2024.11.07 23:40:16.143053 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} oximeter.fields_u16 (86ed507b-905d-4270-ad83-28e4a65549f1): There are no data parts 2024.11.07 23:40:16.149368 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} TCPHandler: Processed in 0.014195201 sec. 2024.11.07 23:40:16.150219 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.150486 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.150544 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 2024.11.07 23:40:16.155839 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} oximeter.fields_i32 (ce079efc-e6d7-4467-9c5b-db7f4984f430): Loading data parts 2024.11.07 23:40:16.156639 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} oximeter.fields_i32 (ce079efc-e6d7-4467-9c5b-db7f4984f430): There are no data parts 2024.11.07 23:40:16.160662 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} TCPHandler: Processed in 0.010602118 sec. 2024.11.07 23:40:16.161589 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.161906 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.163135 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 2024.11.07 23:40:16.173064 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} oximeter.fields_u32 (26a87685-22e6-46da-950d-7028f3e3a4e6): Loading data parts 2024.11.07 23:40:16.173294 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} oximeter.fields_u32 (26a87685-22e6-46da-950d-7028f3e3a4e6): There are no data parts 2024.11.07 23:40:16.181417 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} TCPHandler: Processed in 0.020009086 sec. 2024.11.07 23:40:16.182183 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.182444 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.182496 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 2024.11.07 23:40:16.187752 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} oximeter.fields_i64 (74ebc289-4ad0-47ff-855a-f3559129f410): Loading data parts 2024.11.07 23:40:16.187994 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} oximeter.fields_i64 (74ebc289-4ad0-47ff-855a-f3559129f410): There are no data parts 2024.11.07 23:40:16.191628 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} TCPHandler: Processed in 0.009620777 sec. 2024.11.07 23:40:16.192297 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.192590 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.192708 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 2024.11.07 23:40:16.201404 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} oximeter.fields_u64 (c21fbf9a-7bf0-46d9-b828-1940c6b5c0f3): Loading data parts 2024.11.07 23:40:16.201874 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} oximeter.fields_u64 (c21fbf9a-7bf0-46d9-b828-1940c6b5c0f3): There are no data parts 2024.11.07 23:40:16.207258 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} TCPHandler: Processed in 0.015081572 sec. 2024.11.07 23:40:16.207981 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.208249 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.208301 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr 2024.11.07 23:40:16.230793 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} oximeter.fields_ipaddr (f9d77be4-bc72-4879-ae2d-5cb81e012de3): Loading data parts 2024.11.07 23:40:16.232238 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} oximeter.fields_ipaddr (f9d77be4-bc72-4879-ae2d-5cb81e012de3): There are no data parts 2024.11.07 23:40:16.236135 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} TCPHandler: Processed in 0.028320053 sec. 2024.11.07 23:40:16.237252 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.238135 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.238185 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string 2024.11.07 23:40:16.255545 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} oximeter.fields_string (11184ec1-cdd3-4590-b2cd-f281bec498df): Loading data parts 2024.11.07 23:40:16.255792 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} oximeter.fields_string (11184ec1-cdd3-4590-b2cd-f281bec498df): There are no data parts 2024.11.07 23:40:16.260176 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} TCPHandler: Processed in 0.023111468 sec. 2024.11.07 23:40:16.261224 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.261533 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) 2024.11.07 23:40:16.261588 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid 2024.11.07 23:40:16.266750 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} oximeter.fields_uuid (5472167f-1b87-4fee-a144-437934962e0e): Loading data parts 2024.11.07 23:40:16.267028 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} oximeter.fields_uuid (5472167f-1b87-4fee-a144-437934962e0e): There are no data parts 2024.11.07 23:40:16.271064 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} TCPHandler: Processed in 0.010000428 sec. 2024.11.07 23:40:16.275386 [ 197785 ] {} TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.275949 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} executeQuery: (from [::1]:56448) /* The timeseries schema table stores the extracted schema for the samples * oximeter collects. */ CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) 2024.11.07 23:40:16.277106 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema 2024.11.07 23:40:16.281581 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} oximeter.timeseries_schema (63cf8843-ba11-4bf3-9222-968fb9b50dee): Loading data parts 2024.11.07 23:40:16.281833 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} oximeter.timeseries_schema (63cf8843-ba11-4bf3-9222-968fb9b50dee): There are no data parts 2024.11.07 23:40:16.285628 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} TCPHandler: Processed in 0.013317611 sec. 2024.11.07 23:40:16.286527 [ 197793 ] {} TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.07 23:40:16.286694 [ 197793 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} executeQuery: (from [::1]:56460) INSERT INTO oximeter.version (*) VALUES (stage: Complete) 2024.11.07 23:40:16.286801 [ 197793 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version 2024.11.07 23:40:16.287666 [ 197790 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} oximeter.version (95637719-7cd6-4375-8b6a-0074c61d457f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.07 23:40:16.287691 [ 197790 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 164.62 GiB. 2024.11.07 23:40:16.290760 [ 197790 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.11.07 23:40:16.318931 [ 197790 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} oximeter.version (95637719-7cd6-4375-8b6a-0074c61d457f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.11.07 23:40:16.319214 [ 197793 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} executeQuery: Read 1 rows, 16.00 B in 0.032567 sec., 30.70592931495072 rows/sec., 491.29 B/sec. 2024.11.07 23:40:16.319427 [ 197793 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} TCPHandler: Processed in 0.033063797 sec.