2024.11.15 20:11:20.608685 [ 155515 ] {} SentryWriter: Sending crash reports is disabled 2024.11.15 20:11:20.608755 [ 155515 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.11.15 20:11:20.734556 [ 155515 ] {} Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 155515 2024.11.15 20:11:20.734620 [ 155515 ] {} Application: starting up 2024.11.15 20:11:20.749847 [ 155515 ] {} Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 2024.11.15 20:11:20.755483 [ 155515 ] {} Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. 2024.11.15 20:11:20.810469 [ 155515 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.11.15 20:11:20.810508 [ 155515 ] {} AsynchronousMetrics: Scanning /sys/block 2024.11.15 20:11:20.810565 [ 155515 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.11.15 20:11:20.810580 [ 155515 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.11.15 20:11:21.334628 [ 155515 ] {} Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) 2024.11.15 20:11:21.335143 [ 155515 ] {} 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.15 20:11:21.339476 [ 155515 ] {} Application: Set max number of file descriptors to 524288 (was 1024). 2024.11.15 20:11:21.340402 [ 155515 ] {} Application: rlimit on number of threads is 125612 2024.11.15 20:11:21.340416 [ 155515 ] {} Application: Initializing DateLUT. 2024.11.15 20:11:21.340422 [ 155515 ] {} Application: Initialized DateLUT with time zone 'UTC'. 2024.11.15 20:11:21.340449 [ 155515 ] {} Context: Setting up /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/datastore/tmp/ to store temporary data in it 2024.11.15 20:11:21.340864 [ 155515 ] {} Application: Initializing interserver credentials. 2024.11.15 20:11:21.341386 [ 155515 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml' 2024.11.15 20:11:21.342999 [ 155515 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml', performing update on configuration 2024.11.15 20:11:21.343405 [ 155515 ] {} 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.15 20:11:21.343418 [ 155515 ] {} 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.15 20:11:21.343423 [ 155515 ] {} Application: Merges and mutations memory limit is set to 15.34 GiB 2024.11.15 20:11:21.343459 [ 155515 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.11.15 20:11:21.345286 [ 155515 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.11.15 20:11:21.355895 [ 155515 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.11.15 20:11:21.356447 [ 155515 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.11.15 20:11:21.359105 [ 155515 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.11.15 20:11:21.359598 [ 155515 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml', performed update on configuration 2024.11.15 20:11:21.360226 [ 155515 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml' 2024.11.15 20:11:21.361670 [ 155515 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml', performing update on configuration 2024.11.15 20:11:21.362522 [ 155515 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml', performed update on configuration 2024.11.15 20:11:21.363876 [ 155515 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/config.xml 2024.11.15 20:11:21.364438 [ 155515 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.11.15 20:11:21.364776 [ 155515 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.11.15 20:11:21.365909 [ 155515 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.11.15 20:11:21.366175 [ 155515 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.11.15 20:11:21.366883 [ 155515 ] {} DNSCacheUpdater: Update period 15 seconds 2024.11.15 20:11:21.367607 [ 155543 ] {} DNSResolver: Updating DNS cache 2024.11.15 20:11:21.367636 [ 155543 ] {} DNSResolver: Updated DNS cache 2024.11.15 20:11:21.367581 [ 155515 ] {} Application: Loading metadata from /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/datastore/ 2024.11.15 20:11:21.381027 [ 155515 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.11.15 20:11:21.382823 [ 155515 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.001868291 sec 2024.11.15 20:11:21.382837 [ 155515 ] {} ReferentialDeps: No tables 2024.11.15 20:11:21.382843 [ 155515 ] {} LoadingDeps: No tables 2024.11.15 20:11:21.382870 [ 155515 ] {} DatabaseAtomic (system): Starting up tables. 2024.11.15 20:11:21.382901 [ 155515 ] {} SystemLog: Creating system.query_log from query_log 2024.11.15 20:11:21.383661 [ 155515 ] {} SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config 2024.11.15 20:11:21.383675 [ 155515 ] {} SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config 2024.11.15 20:11:21.383683 [ 155515 ] {} SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config 2024.11.15 20:11:21.383689 [ 155515 ] {} SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config 2024.11.15 20:11:21.383696 [ 155515 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.11.15 20:11:21.383702 [ 155515 ] {} SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config 2024.11.15 20:11:21.383709 [ 155515 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.11.15 20:11:21.383715 [ 155515 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.11.15 20:11:21.383722 [ 155515 ] {} SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config 2024.11.15 20:11:21.383733 [ 155515 ] {} SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config 2024.11.15 20:11:21.383740 [ 155515 ] {} SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config 2024.11.15 20:11:21.383746 [ 155515 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.11.15 20:11:21.383752 [ 155515 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.11.15 20:11:21.383758 [ 155515 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.11.15 20:11:21.383764 [ 155515 ] {} SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config 2024.11.15 20:11:21.383771 [ 155515 ] {} SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config 2024.11.15 20:11:21.452581 [ 155515 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.11.15 20:11:21.464203 [ 155515 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.11.15 20:11:21.464690 [ 155515 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.004699714 sec 2024.11.15 20:11:21.464703 [ 155515 ] {} ReferentialDeps: No tables 2024.11.15 20:11:21.464708 [ 155515 ] {} LoadingDeps: No tables 2024.11.15 20:11:21.464734 [ 155515 ] {} DatabaseAtomic (default): Starting up tables. 2024.11.15 20:11:21.465073 [ 155515 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-2d920668872ead29-test_mgs_metrics.155440.1-clickhouse-wB5jkX/datastore/user_defined/ 2024.11.15 20:11:21.465473 [ 155515 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.11.15 20:11:21.465485 [ 155515 ] {} Application: Loaded metadata. 2024.11.15 20:11:21.465511 [ 155515 ] {} Application: Tasks stats provider: procfs 2024.11.15 20:11:21.465522 [ 155515 ] {} 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.15 20:11:21.465627 [ 155515 ] {} Application: Requested any available port (port == 0), actual port is 46135 2024.11.15 20:11:21.465701 [ 155515 ] {} Application: Requested any available port (port == 0), actual port is 38159 2024.11.15 20:11:21.466029 [ 155515 ] {} Application: Requested any available port (port == 0), actual port is 41049 2024.11.15 20:11:21.466300 [ 155515 ] {} Application: Requested any available port (port == 0), actual port is 43127 2024.11.15 20:11:21.466328 [ 155515 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.11.15 20:11:21.466768 [ 155515 ] {} AsynchronousMetrics: MemoryTracking: was 20.62 MiB, peak 20.62 MiB, free memory in arenas 3.09 MiB, will set to 380.07 MiB (RSS), difference: 359.45 MiB 2024.11.15 20:11:21.467157 [ 155515 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.103e-05 sec. 2024.11.15 20:11:21.467646 [ 155515 ] {} Application: Listening for http://[::1]:46135 2024.11.15 20:11:21.468193 [ 155515 ] {} Application: Listening for native protocol (tcp): [::1]:38159 2024.11.15 20:11:21.468234 [ 155515 ] {} Application: Listening for http://127.0.0.1:41049 2024.11.15 20:11:21.468270 [ 155515 ] {} Application: Listening for native protocol (tcp): 127.0.0.1:43127 2024.11.15 20:11:21.468278 [ 155515 ] {} Application: Ready for connections. 2024.11.15 20:11:22.674129 [ 155521 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57338 2024.11.15 20:11:22.674609 [ 155521 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:22.675310 [ 155521 ] {} TCP-Session: a8ffe3dd-4704-43e7-b842-698cbd4ef1f8 Authenticating user 'default' from [::1]:57338 2024.11.15 20:11:22.675333 [ 155521 ] {} TCP-Session: a8ffe3dd-4704-43e7-b842-698cbd4ef1f8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.675343 [ 155521 ] {} TCP-Session: a8ffe3dd-4704-43e7-b842-698cbd4ef1f8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.675446 [ 155521 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.11.15 20:11:22.675480 [ 155521 ] {} 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.15 20:11:22.675492 [ 155521 ] {} 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.15 20:11:22.679075 [ 155524 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57340 2024.11.15 20:11:22.687745 [ 155524 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:22.687807 [ 155524 ] {} TCP-Session: d778fe34-3c59-4945-baec-de89e00f268d Authenticating user 'default' from [::1]:57340 2024.11.15 20:11:22.687827 [ 155524 ] {} TCP-Session: d778fe34-3c59-4945-baec-de89e00f268d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.687835 [ 155524 ] {} TCP-Session: d778fe34-3c59-4945-baec-de89e00f268d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.694404 [ 156196 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57346 2024.11.15 20:11:22.694522 [ 156196 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:22.694554 [ 156196 ] {} TCP-Session: bd0cecef-ecc1-46bb-9b88-d4d4e2b7681d Authenticating user 'default' from [::1]:57346 2024.11.15 20:11:22.696273 [ 156196 ] {} TCP-Session: bd0cecef-ecc1-46bb-9b88-d4d4e2b7681d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.698251 [ 156196 ] {} TCP-Session: bd0cecef-ecc1-46bb-9b88-d4d4e2b7681d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.704779 [ 155523 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57342 2024.11.15 20:11:22.705751 [ 155523 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:22.705804 [ 155523 ] {} TCP-Session: f81c8791-e7ca-4ca6-a72c-03f54485477d Authenticating user 'default' from [::1]:57342 2024.11.15 20:11:22.705757 [ 156197 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57348 2024.11.15 20:11:22.705834 [ 155523 ] {} TCP-Session: f81c8791-e7ca-4ca6-a72c-03f54485477d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.705793 [ 156194 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57350 2024.11.15 20:11:22.704849 [ 156195 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57344 2024.11.15 20:11:22.704890 [ 156198 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57352 2024.11.15 20:11:22.705843 [ 155523 ] {} TCP-Session: f81c8791-e7ca-4ca6-a72c-03f54485477d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.705989 [ 156197 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:22.706033 [ 156197 ] {} TCP-Session: c1eb3063-4dcd-4c17-992b-8cdad4da0cce Authenticating user 'default' from [::1]:57348 2024.11.15 20:11:22.706043 [ 156197 ] {} TCP-Session: c1eb3063-4dcd-4c17-992b-8cdad4da0cce Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.706049 [ 156197 ] {} TCP-Session: c1eb3063-4dcd-4c17-992b-8cdad4da0cce Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.706092 [ 156195 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:22.706124 [ 156195 ] {} TCP-Session: 207c2ad8-767d-4c61-8dea-25501444c872 Authenticating user 'default' from [::1]:57344 2024.11.15 20:11:22.706134 [ 156195 ] {} TCP-Session: 207c2ad8-767d-4c61-8dea-25501444c872 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.706141 [ 156195 ] {} TCP-Session: 207c2ad8-767d-4c61-8dea-25501444c872 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.706162 [ 156194 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:22.706193 [ 156194 ] {} TCP-Session: 57183c68-d66f-473e-a9a9-f025934c3d4d Authenticating user 'default' from [::1]:57350 2024.11.15 20:11:22.706204 [ 156194 ] {} TCP-Session: 57183c68-d66f-473e-a9a9-f025934c3d4d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.706211 [ 156194 ] {} TCP-Session: 57183c68-d66f-473e-a9a9-f025934c3d4d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.706290 [ 156198 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:22.706316 [ 156198 ] {} TCP-Session: e403fd97-feab-46b9-9cf6-fe27bd9d4028 Authenticating user 'default' from [::1]:57352 2024.11.15 20:11:22.706324 [ 156198 ] {} TCP-Session: e403fd97-feab-46b9-9cf6-fe27bd9d4028 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:22.706505 [ 156198 ] {} TCP-Session: e403fd97-feab-46b9-9cf6-fe27bd9d4028 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.162603 [ 156349 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57354 2024.11.15 20:11:32.414176 [ 156349 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.414231 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Authenticating user 'default' from [::1]:57354 2024.11.15 20:11:32.415127 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.415142 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.452674 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.452951 [ 156349 ] {1bdb7cbc-9314-4c28-b4bb-e9548a4f0463} executeQuery: (from [::1]:57354) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.11.15 20:11:32.453870 [ 156349 ] {1bdb7cbc-9314-4c28-b4bb-e9548a4f0463} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:57354) (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. ? @ 0x00007f2740232ac3 in ? 17. ? @ 0x00007f27402c4850 in ? 2024.11.15 20:11:32.454843 [ 156349 ] {1bdb7cbc-9314-4c28-b4bb-e9548a4f0463} 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. ? @ 0x00007f2740232ac3 in ? 17. ? @ 0x00007f27402c4850 in ? 2024.11.15 20:11:32.454903 [ 156349 ] {1bdb7cbc-9314-4c28-b4bb-e9548a4f0463} TCPHandler: Processed in 0.002453092 sec. 2024.11.15 20:11:32.456297 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.456439 [ 156349 ] {f215dcb8-f304-4f6b-ab3e-07f916d322af} executeQuery: (from [::1]:57354) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.11.15 20:11:32.456667 [ 156349 ] {f215dcb8-f304-4f6b-ab3e-07f916d322af} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:57354) (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. ? @ 0x00007f2740232ac3 in ? 17. ? @ 0x00007f27402c4850 in ? 2024.11.15 20:11:32.456760 [ 156349 ] {f215dcb8-f304-4f6b-ab3e-07f916d322af} 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. ? @ 0x00007f2740232ac3 in ? 17. ? @ 0x00007f27402c4850 in ? 2024.11.15 20:11:32.456797 [ 156349 ] {f215dcb8-f304-4f6b-ab3e-07f916d322af} TCPHandler: Processed in 0.000595631 sec. 2024.11.15 20:11:32.458262 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.458361 [ 156349 ] {032d8eb8-eb72-4379-b97b-d8bd84ec7a47} executeQuery: (from [::1]:57354) DROP DATABASE IF EXISTS oximeter (stage: Complete) 2024.11.15 20:11:32.458437 [ 156349 ] {032d8eb8-eb72-4379-b97b-d8bd84ec7a47} TCPHandler: Processed in 0.000687871 sec. 2024.11.15 20:11:32.459862 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.460970 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} executeQuery: (from [::1]:57354) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) 2024.11.15 20:11:32.461006 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* 2024.11.15 20:11:32.469086 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. 2024.11.15 20:11:32.469125 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.4009e-05 sec 2024.11.15 20:11:32.469134 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} ReferentialDeps: No tables 2024.11.15 20:11:32.469139 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} LoadingDeps: No tables 2024.11.15 20:11:32.469160 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} DatabaseAtomic (oximeter): Starting up tables. 2024.11.15 20:11:32.469235 [ 156349 ] {f3ffca51-a953-4dd4-9823-bfcb40ea245b} TCPHandler: Processed in 0.009451828 sec. 2024.11.15 20:11:32.472120 [ 156380 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57356 2024.11.15 20:11:32.472234 [ 156380 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.472279 [ 156380 ] {} TCP-Session: 860b2e74-812a-45de-a944-7c635bb3f3c3 Authenticating user 'default' from [::1]:57356 2024.11.15 20:11:32.472297 [ 156380 ] {} TCP-Session: 860b2e74-812a-45de-a944-7c635bb3f3c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.472305 [ 156380 ] {} TCP-Session: 860b2e74-812a-45de-a944-7c635bb3f3c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.472408 [ 156380 ] {} TCPHandler: Done processing connection. 2024.11.15 20:11:32.472437 [ 156380 ] {} TCP-Session: 860b2e74-812a-45de-a944-7c635bb3f3c3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.474535 [ 156384 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57364 2024.11.15 20:11:32.474844 [ 156384 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.474870 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Authenticating user 'default' from [::1]:57364 2024.11.15 20:11:32.474883 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.474889 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.483873 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.484176 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} executeQuery: (from [::1]:57364) /* 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.15 20:11:32.484238 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version 2024.11.15 20:11:32.484937 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} StoragePolicy (default): Storage policy default created, total volumes 1 2024.11.15 20:11:32.490219 [ 156386 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57368 2024.11.15 20:11:32.490228 [ 156391 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57376 2024.11.15 20:11:32.490342 [ 156386 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.490373 [ 156386 ] {} TCP-Session: af3ec7c3-7846-47cf-bc87-212268696ddb Authenticating user 'default' from [::1]:57368 2024.11.15 20:11:32.490390 [ 156386 ] {} TCP-Session: af3ec7c3-7846-47cf-bc87-212268696ddb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490398 [ 156386 ] {} TCP-Session: af3ec7c3-7846-47cf-bc87-212268696ddb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490523 [ 156381 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57358 2024.11.15 20:11:32.490616 [ 156381 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.490644 [ 156381 ] {} TCP-Session: 86ca9897-91c2-4f43-af0c-c5882f9a793d Authenticating user 'default' from [::1]:57358 2024.11.15 20:11:32.490654 [ 156381 ] {} TCP-Session: 86ca9897-91c2-4f43-af0c-c5882f9a793d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490660 [ 156381 ] {} TCP-Session: 86ca9897-91c2-4f43-af0c-c5882f9a793d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490738 [ 156381 ] {} TCPHandler: Done processing connection. 2024.11.15 20:11:32.490767 [ 156381 ] {} TCP-Session: 86ca9897-91c2-4f43-af0c-c5882f9a793d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490763 [ 156387 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57370 2024.11.15 20:11:32.490794 [ 156381 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57378 2024.11.15 20:11:32.490813 [ 156381 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.490827 [ 156381 ] {} TCP-Session: 84ca9b07-7aa5-41ef-8256-bd0f2072eead Authenticating user 'default' from [::1]:57378 2024.11.15 20:11:32.490840 [ 156381 ] {} TCP-Session: 84ca9b07-7aa5-41ef-8256-bd0f2072eead Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490847 [ 156381 ] {} TCP-Session: 84ca9b07-7aa5-41ef-8256-bd0f2072eead Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490858 [ 156387 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.490881 [ 156387 ] {} TCP-Session: 1b4d0b18-9a6e-4695-a43d-0b81c02af48f Authenticating user 'default' from [::1]:57370 2024.11.15 20:11:32.490891 [ 156387 ] {} TCP-Session: 1b4d0b18-9a6e-4695-a43d-0b81c02af48f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490898 [ 156387 ] {} TCP-Session: 1b4d0b18-9a6e-4695-a43d-0b81c02af48f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.490990 [ 156382 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57360 2024.11.15 20:11:32.491061 [ 156382 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.491071 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} oximeter.version (b72dd4e2-96b6-45ef-9b16-a5d74d56658c): Loading data parts 2024.11.15 20:11:32.491083 [ 156382 ] {} TCP-Session: 1d26e478-e9d8-4d64-bd1c-270bb4510f95 Authenticating user 'default' from [::1]:57360 2024.11.15 20:11:32.491094 [ 156382 ] {} TCP-Session: 1d26e478-e9d8-4d64-bd1c-270bb4510f95 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.491101 [ 156382 ] {} TCP-Session: 1d26e478-e9d8-4d64-bd1c-270bb4510f95 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.491208 [ 156389 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57374 2024.11.15 20:11:32.491294 [ 156382 ] {} TCPHandler: Done processing connection. 2024.11.15 20:11:32.491313 [ 156382 ] {} TCP-Session: 1d26e478-e9d8-4d64-bd1c-270bb4510f95 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.491273 [ 156388 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57372 2024.11.15 20:11:32.492966 [ 156388 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.492997 [ 156388 ] {} TCP-Session: c21259b1-963b-4d1f-9dfe-314c6ec06d52 Authenticating user 'default' from [::1]:57372 2024.11.15 20:11:32.493009 [ 156388 ] {} TCP-Session: c21259b1-963b-4d1f-9dfe-314c6ec06d52 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.493016 [ 156388 ] {} TCP-Session: c21259b1-963b-4d1f-9dfe-314c6ec06d52 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.491493 [ 156389 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.493127 [ 156389 ] {} TCP-Session: 734f4397-c6fd-4e81-9b8b-d4d8d4ad2a4b Authenticating user 'default' from [::1]:57374 2024.11.15 20:11:32.493140 [ 156389 ] {} TCP-Session: 734f4397-c6fd-4e81-9b8b-d4d8d4ad2a4b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.493148 [ 156389 ] {} TCP-Session: 734f4397-c6fd-4e81-9b8b-d4d8d4ad2a4b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.491627 [ 156385 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57366 2024.11.15 20:11:32.491730 [ 156391 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.493517 [ 156385 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.493489 [ 156391 ] {} TCP-Session: e26237cb-ad84-496a-b756-4286d01f0eff Authenticating user 'default' from [::1]:57376 2024.11.15 20:11:32.493581 [ 156391 ] {} TCP-Session: e26237cb-ad84-496a-b756-4286d01f0eff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.493589 [ 156391 ] {} TCP-Session: e26237cb-ad84-496a-b756-4286d01f0eff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.493826 [ 156385 ] {} TCP-Session: 9ccc3166-aab6-4fe1-b488-823c7ec98e21 Authenticating user 'default' from [::1]:57366 2024.11.15 20:11:32.493844 [ 156385 ] {} TCP-Session: 9ccc3166-aab6-4fe1-b488-823c7ec98e21 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.493852 [ 156385 ] {} TCP-Session: 9ccc3166-aab6-4fe1-b488-823c7ec98e21 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.503179 [ 156383 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:57362 2024.11.15 20:11:32.503292 [ 156383 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.11.15 20:11:32.503321 [ 156383 ] {} TCP-Session: 8ddfaf4e-b55c-4493-ae5e-3fda3301e7b7 Authenticating user 'default' from [::1]:57362 2024.11.15 20:11:32.503337 [ 156383 ] {} TCP-Session: 8ddfaf4e-b55c-4493-ae5e-3fda3301e7b7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.503344 [ 156383 ] {} TCP-Session: 8ddfaf4e-b55c-4493-ae5e-3fda3301e7b7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.503424 [ 156383 ] {} TCPHandler: Done processing connection. 2024.11.15 20:11:32.503441 [ 156383 ] {} TCP-Session: 8ddfaf4e-b55c-4493-ae5e-3fda3301e7b7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.11.15 20:11:32.508101 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} oximeter.version (b72dd4e2-96b6-45ef-9b16-a5d74d56658c): There are no data parts 2024.11.15 20:11:32.511259 [ 156384 ] {f9e19bd5-3bb4-4629-95d8-a892aae4c50f} TCPHandler: Processed in 0.027701952 sec. 2024.11.15 20:11:32.512822 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.513050 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} executeQuery: (from [::1]:57354) /* 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.15 20:11:32.514480 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool 2024.11.15 20:11:32.520398 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} oximeter.measurements_bool (73d9d576-f80f-4984-b6bd-be09df14bd35): Loading data parts 2024.11.15 20:11:32.520756 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} oximeter.measurements_bool (73d9d576-f80f-4984-b6bd-be09df14bd35): There are no data parts 2024.11.15 20:11:32.525173 [ 156349 ] {10f3e132-d48b-4a7c-b9bb-5a39a595762e} TCPHandler: Processed in 0.01243857 sec. 2024.11.15 20:11:32.526306 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.526548 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} executeQuery: (from [::1]:57364) 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.15 20:11:32.526593 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 2024.11.15 20:11:32.531785 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} oximeter.measurements_i8 (f2f138da-f296-477f-87cc-06a12b8db2ad): Loading data parts 2024.11.15 20:11:32.533999 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} oximeter.measurements_i8 (f2f138da-f296-477f-87cc-06a12b8db2ad): There are no data parts 2024.11.15 20:11:32.540253 [ 156384 ] {76761a58-8d55-43c9-a5b2-c49f54ac0c89} TCPHandler: Processed in 0.014069371 sec. 2024.11.15 20:11:32.541848 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.543397 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} executeQuery: (from [::1]:57354) 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.15 20:11:32.543448 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 2024.11.15 20:11:32.554265 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} oximeter.measurements_u8 (875feb6d-bd48-4f06-af38-7d7dbf68e976): Loading data parts 2024.11.15 20:11:32.558710 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} oximeter.measurements_u8 (875feb6d-bd48-4f06-af38-7d7dbf68e976): There are no data parts 2024.11.15 20:11:32.563926 [ 156349 ] {be3ecec0-f12c-4398-947b-773276982b33} TCPHandler: Processed in 0.022218148 sec. 2024.11.15 20:11:32.565138 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.565381 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} executeQuery: (from [::1]:57364) 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.15 20:11:32.567101 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 2024.11.15 20:11:32.572710 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} oximeter.measurements_i16 (d5646f8f-7a28-49ba-942a-78554ea7dcfa): Loading data parts 2024.11.15 20:11:32.574623 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} oximeter.measurements_i16 (d5646f8f-7a28-49ba-942a-78554ea7dcfa): There are no data parts 2024.11.15 20:11:32.579788 [ 156384 ] {73ddfe94-504d-45b8-8112-81d9358066e6} TCPHandler: Processed in 0.014808501 sec. 2024.11.15 20:11:32.580377 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.580634 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} executeQuery: (from [::1]:57354) 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.15 20:11:32.582000 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 2024.11.15 20:11:32.587087 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} oximeter.measurements_u16 (f8459f0c-e467-49d9-a7f9-896c167bcfe4): Loading data parts 2024.11.15 20:11:32.587362 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} oximeter.measurements_u16 (f8459f0c-e467-49d9-a7f9-896c167bcfe4): There are no data parts 2024.11.15 20:11:32.592296 [ 156349 ] {89b793fa-f552-403b-9ff9-a554c24c16bc} TCPHandler: Processed in 0.0119903 sec. 2024.11.15 20:11:32.592965 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.593215 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} executeQuery: (from [::1]:57364) 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.15 20:11:32.593259 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 2024.11.15 20:11:32.600565 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} oximeter.measurements_i32 (354d9ef4-220a-404c-b589-2666df727601): Loading data parts 2024.11.15 20:11:32.602100 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} oximeter.measurements_i32 (354d9ef4-220a-404c-b589-2666df727601): There are no data parts 2024.11.15 20:11:32.608808 [ 156384 ] {660b47ff-d63b-421b-ae4d-a716102ebb73} TCPHandler: Processed in 0.015940033 sec. 2024.11.15 20:11:32.609426 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.609691 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} executeQuery: (from [::1]:57354) 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.15 20:11:32.609731 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 2024.11.15 20:11:32.615971 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} oximeter.measurements_u32 (5e211cf7-0901-4ab8-a686-3663876cbac6): Loading data parts 2024.11.15 20:11:32.616345 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} oximeter.measurements_u32 (5e211cf7-0901-4ab8-a686-3663876cbac6): There are no data parts 2024.11.15 20:11:32.620878 [ 156349 ] {a1e1961d-2e26-4e78-b539-15d55b04e163} TCPHandler: Processed in 0.01152732 sec. 2024.11.15 20:11:32.622401 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.622646 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} executeQuery: (from [::1]:57364) 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.15 20:11:32.623867 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 2024.11.15 20:11:32.628654 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Loading data parts 2024.11.15 20:11:32.630798 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): There are no data parts 2024.11.15 20:11:32.635154 [ 156384 ] {b8629a45-64c7-4ac8-832a-2cc1f35f43e6} TCPHandler: Processed in 0.01282914 sec. 2024.11.15 20:11:32.636363 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.638024 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} executeQuery: (from [::1]:57354) 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.15 20:11:32.638070 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 2024.11.15 20:11:32.644069 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} oximeter.measurements_u64 (1788dfbb-993a-427d-8953-171a23bb5918): Loading data parts 2024.11.15 20:11:32.645208 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} oximeter.measurements_u64 (1788dfbb-993a-427d-8953-171a23bb5918): There are no data parts 2024.11.15 20:11:32.650965 [ 156349 ] {3ca647b2-0666-401d-85ca-95dc9edb8f61} TCPHandler: Processed in 0.014675032 sec. 2024.11.15 20:11:32.658068 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.658468 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} executeQuery: (from [::1]:57364) 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.15 20:11:32.658518 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 2024.11.15 20:11:32.665524 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} oximeter.measurements_f32 (76505047-c6eb-414b-acb6-f8157783f4ee): Loading data parts 2024.11.15 20:11:32.665855 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} oximeter.measurements_f32 (76505047-c6eb-414b-acb6-f8157783f4ee): There are no data parts 2024.11.15 20:11:32.685983 [ 156384 ] {79638e4e-e44e-4187-8c7d-95a67bae96c4} TCPHandler: Processed in 0.028075502 sec. 2024.11.15 20:11:32.687132 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.688149 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} executeQuery: (from [::1]:57354) 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.15 20:11:32.688195 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 2024.11.15 20:11:32.694007 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} oximeter.measurements_f64 (a42ec2a0-226d-417e-ab15-af3dbe4b7078): Loading data parts 2024.11.15 20:11:32.694256 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} oximeter.measurements_f64 (a42ec2a0-226d-417e-ab15-af3dbe4b7078): There are no data parts 2024.11.15 20:11:32.697443 [ 156349 ] {16c387a0-acfc-438e-a9d4-09ffa1af909c} TCPHandler: Processed in 0.010422458 sec. 2024.11.15 20:11:32.755771 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:32.756067 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} executeQuery: (from [::1]:57364) 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.15 20:11:32.756120 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string 2024.11.15 20:11:32.760189 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} oximeter.measurements_string (ecf9728f-a19b-4557-abdd-0608b7ce0ef9): Loading data parts 2024.11.15 20:11:32.760408 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} oximeter.measurements_string (ecf9728f-a19b-4557-abdd-0608b7ce0ef9): There are no data parts 2024.11.15 20:11:32.766510 [ 156384 ] {be726403-3272-4127-89f0-73e63b6b25e8} TCPHandler: Processed in 0.010950339 sec. 2024.11.15 20:11:33.000441 [ 155784 ] {} AsynchronousMetrics: MemoryTracking: was 385.70 MiB, peak 385.70 MiB, free memory in arenas 7.39 MiB, will set to 386.77 MiB (RSS), difference: 1.08 MiB 2024.11.15 20:11:33.122360 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.122667 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} executeQuery: (from [::1]:57354) 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.15 20:11:33.122719 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes 2024.11.15 20:11:33.130967 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} oximeter.measurements_bytes (b6190f1b-badb-423c-8f04-ab671c4c1cef): Loading data parts 2024.11.15 20:11:33.131236 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} oximeter.measurements_bytes (b6190f1b-badb-423c-8f04-ab671c4c1cef): There are no data parts 2024.11.15 20:11:33.140411 [ 156349 ] {dce7571e-0d3c-4e8d-a735-2fbf20fe0a69} TCPHandler: Processed in 0.018220115 sec. 2024.11.15 20:11:33.150996 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.151241 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} executeQuery: (from [::1]:57364) 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.15 20:11:33.151321 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 2024.11.15 20:11:33.158687 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} oximeter.measurements_cumulativei64 (971c4021-f7f5-4ae3-93b7-dd3642803b3a): Loading data parts 2024.11.15 20:11:33.158946 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} oximeter.measurements_cumulativei64 (971c4021-f7f5-4ae3-93b7-dd3642803b3a): There are no data parts 2024.11.15 20:11:33.163197 [ 156384 ] {3be8a441-c3e1-43ad-a73b-e740719fdac3} TCPHandler: Processed in 0.01229142 sec. 2024.11.15 20:11:33.164014 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.164251 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} executeQuery: (from [::1]:57354) 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.15 20:11:33.164300 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 2024.11.15 20:11:33.168855 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} oximeter.measurements_cumulativeu64 (a589a9c8-b9d3-45f0-808f-1a54b8467f2e): Loading data parts 2024.11.15 20:11:33.170579 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} oximeter.measurements_cumulativeu64 (a589a9c8-b9d3-45f0-808f-1a54b8467f2e): There are no data parts 2024.11.15 20:11:33.175906 [ 156349 ] {59fbf127-1e33-4ddb-a82d-4718deaf9884} TCPHandler: Processed in 0.01203305 sec. 2024.11.15 20:11:33.208142 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.208435 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} executeQuery: (from [::1]:57364) 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.15 20:11:33.209563 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 2024.11.15 20:11:33.217273 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} oximeter.measurements_cumulativef32 (91d0fa85-16dd-40eb-a6f7-55adc54b02ca): Loading data parts 2024.11.15 20:11:33.217754 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} oximeter.measurements_cumulativef32 (91d0fa85-16dd-40eb-a6f7-55adc54b02ca): There are no data parts 2024.11.15 20:11:33.226680 [ 156384 ] {2700e428-6a63-4fe0-90d1-4e40b3b8b015} TCPHandler: Processed in 0.018664715 sec. 2024.11.15 20:11:33.227777 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.228062 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} executeQuery: (from [::1]:57354) 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.15 20:11:33.228106 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 2024.11.15 20:11:33.233420 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} oximeter.measurements_cumulativef64 (bfd9c141-e190-406f-a6cc-d65c425df316): Loading data parts 2024.11.15 20:11:33.233695 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} oximeter.measurements_cumulativef64 (bfd9c141-e190-406f-a6cc-d65c425df316): There are no data parts 2024.11.15 20:11:33.237283 [ 156349 ] {c3cf2129-a72e-446d-af6a-c9331e938886} TCPHandler: Processed in 0.009586128 sec. 2024.11.15 20:11:33.247622 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.248002 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} executeQuery: (from [::1]:57364) 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.15 20:11:33.248064 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 2024.11.15 20:11:33.255466 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} oximeter.measurements_histogrami8 (0a1bc4a7-ba73-40f9-9449-c654f58cb4a9): Loading data parts 2024.11.15 20:11:33.256456 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} oximeter.measurements_histogrami8 (0a1bc4a7-ba73-40f9-9449-c654f58cb4a9): There are no data parts 2024.11.15 20:11:33.261878 [ 156384 ] {a40587d3-d4a1-43b8-8454-33fc4b84a08b} TCPHandler: Processed in 0.014357121 sec. 2024.11.15 20:11:33.262548 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.262948 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} executeQuery: (from [::1]:57354) 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.15 20:11:33.263006 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 2024.11.15 20:11:33.269675 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} oximeter.measurements_histogramu8 (42196a6d-3761-4c96-ab44-802a69c004f5): Loading data parts 2024.11.15 20:11:33.272628 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} oximeter.measurements_histogramu8 (42196a6d-3761-4c96-ab44-802a69c004f5): There are no data parts 2024.11.15 20:11:33.278312 [ 156349 ] {23be2946-8ed9-43f0-aa2c-482d2f9edcad} TCPHandler: Processed in 0.015855053 sec. 2024.11.15 20:11:33.278875 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.280050 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} executeQuery: (from [::1]:57364) 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.15 20:11:33.280110 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 2024.11.15 20:11:33.290730 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} oximeter.measurements_histogrami16 (216dfbb7-6a93-4090-8e4a-1e856d4c1674): Loading data parts 2024.11.15 20:11:33.292610 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} oximeter.measurements_histogrami16 (216dfbb7-6a93-4090-8e4a-1e856d4c1674): There are no data parts 2024.11.15 20:11:33.304945 [ 156384 ] {f6b6451d-d6f9-4c29-b0ca-7ba80d9d37cf} TCPHandler: Processed in 0.026144561 sec. 2024.11.15 20:11:33.305782 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.306096 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} executeQuery: (from [::1]:57354) 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.15 20:11:33.306150 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 2024.11.15 20:11:33.313417 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} oximeter.measurements_histogramu16 (a3a3f5e8-9bff-4656-ae2e-41672f3dcb3f): Loading data parts 2024.11.15 20:11:33.314608 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} oximeter.measurements_histogramu16 (a3a3f5e8-9bff-4656-ae2e-41672f3dcb3f): There are no data parts 2024.11.15 20:11:33.318571 [ 156349 ] {1de86600-eb4f-4c60-86b9-e3fae0a3c539} TCPHandler: Processed in 0.01292144 sec. 2024.11.15 20:11:33.319194 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.319514 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} executeQuery: (from [::1]:57364) 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.15 20:11:33.319568 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 2024.11.15 20:11:33.326936 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} oximeter.measurements_histogrami32 (2391a543-573a-4be0-a29b-a11d4456234b): Loading data parts 2024.11.15 20:11:33.327215 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} oximeter.measurements_histogrami32 (2391a543-573a-4be0-a29b-a11d4456234b): There are no data parts 2024.11.15 20:11:33.331547 [ 156384 ] {851e0992-1704-4dd7-a811-515127eb6dc6} TCPHandler: Processed in 0.01242983 sec. 2024.11.15 20:11:33.332356 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.332710 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} executeQuery: (from [::1]:57354) 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.15 20:11:33.332770 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 2024.11.15 20:11:33.337629 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} oximeter.measurements_histogramu32 (c8edfb4b-abbb-45b6-a042-c2d200993285): Loading data parts 2024.11.15 20:11:33.342847 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} oximeter.measurements_histogramu32 (c8edfb4b-abbb-45b6-a042-c2d200993285): There are no data parts 2024.11.15 20:11:33.348009 [ 156349 ] {0ce37429-69b3-47a5-896d-c4d5cea0f3a4} TCPHandler: Processed in 0.015807303 sec. 2024.11.15 20:11:33.348834 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.349176 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} executeQuery: (from [::1]:57364) 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.15 20:11:33.349240 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 2024.11.15 20:11:33.355958 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} oximeter.measurements_histogrami64 (3805a6d2-b707-48f2-8040-8a74dfc6879d): Loading data parts 2024.11.15 20:11:33.356202 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} oximeter.measurements_histogrami64 (3805a6d2-b707-48f2-8040-8a74dfc6879d): There are no data parts 2024.11.15 20:11:33.360456 [ 156384 ] {71f2d177-6cc7-44e2-bf3a-322a5c0235c6} TCPHandler: Processed in 0.01178966 sec. 2024.11.15 20:11:33.361201 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.361534 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} executeQuery: (from [::1]:57354) 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.15 20:11:33.361590 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 2024.11.15 20:11:33.367247 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} oximeter.measurements_histogramu64 (d4d6b31e-5887-46ba-852c-83de0d4ec1aa): Loading data parts 2024.11.15 20:11:33.367509 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} oximeter.measurements_histogramu64 (d4d6b31e-5887-46ba-852c-83de0d4ec1aa): There are no data parts 2024.11.15 20:11:33.371304 [ 156349 ] {3f28e7f9-fb4c-4bc8-b009-9e877cd004a3} TCPHandler: Processed in 0.010249878 sec. 2024.11.15 20:11:33.372162 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.373403 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} executeQuery: (from [::1]:57364) 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.15 20:11:33.373469 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 2024.11.15 20:11:33.378967 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} oximeter.measurements_histogramf32 (9eb2a5da-7409-4b89-9a7f-b01cb146264f): Loading data parts 2024.11.15 20:11:33.379218 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} oximeter.measurements_histogramf32 (9eb2a5da-7409-4b89-9a7f-b01cb146264f): There are no data parts 2024.11.15 20:11:33.383858 [ 156384 ] {340e50fc-54c6-4adf-90b8-e5fa2d33f4b7} TCPHandler: Processed in 0.011825059 sec. 2024.11.15 20:11:33.384712 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.385026 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} executeQuery: (from [::1]:57354) 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.15 20:11:33.385081 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 2024.11.15 20:11:33.392102 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} oximeter.measurements_histogramf64 (3c5f9729-8e7e-497b-abc0-41b54f32bfb9): Loading data parts 2024.11.15 20:11:33.392419 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} oximeter.measurements_histogramf64 (3c5f9729-8e7e-497b-abc0-41b54f32bfb9): There are no data parts 2024.11.15 20:11:33.396296 [ 156349 ] {c79c3ef8-710f-4052-a729-b64b3949664b} TCPHandler: Processed in 0.011714889 sec. 2024.11.15 20:11:33.397087 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.397379 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} executeQuery: (from [::1]:57364) /* 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.15 20:11:33.397445 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool 2024.11.15 20:11:33.403569 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} oximeter.fields_bool (001a21df-4333-45a6-b52d-2366a98e6bd6): Loading data parts 2024.11.15 20:11:33.403807 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} oximeter.fields_bool (001a21df-4333-45a6-b52d-2366a98e6bd6): There are no data parts 2024.11.15 20:11:33.408772 [ 156384 ] {a5db707c-5446-4f84-9ac8-07fd8daa3cb2} TCPHandler: Processed in 0.01183002 sec. 2024.11.15 20:11:33.409612 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.409911 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} executeQuery: (from [::1]:57354) 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.15 20:11:33.409964 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 2024.11.15 20:11:33.415799 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} oximeter.fields_i8 (55b4d09c-2526-465c-9a23-3b041311c1a5): Loading data parts 2024.11.15 20:11:33.416150 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} oximeter.fields_i8 (55b4d09c-2526-465c-9a23-3b041311c1a5): There are no data parts 2024.11.15 20:11:33.427704 [ 156349 ] {6fdd8747-ce62-49b0-89c6-950a4f9023cd} TCPHandler: Processed in 0.018341335 sec. 2024.11.15 20:11:33.428477 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.431821 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} executeQuery: (from [::1]:57364) 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.15 20:11:33.431872 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 2024.11.15 20:11:33.436981 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} oximeter.fields_u8 (a8ab95b2-d872-4bd4-8f0c-665a55716125): Loading data parts 2024.11.15 20:11:33.437260 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} oximeter.fields_u8 (a8ab95b2-d872-4bd4-8f0c-665a55716125): There are no data parts 2024.11.15 20:11:33.442309 [ 156384 ] {cf8147cd-ac65-4efa-ae81-dff9e7f98980} TCPHandler: Processed in 0.014009642 sec. 2024.11.15 20:11:33.443231 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.443488 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} executeQuery: (from [::1]:57354) 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.15 20:11:33.443536 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 2024.11.15 20:11:33.453284 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} oximeter.fields_i16 (2e807c20-d604-4bcf-9799-756594a429fa): Loading data parts 2024.11.15 20:11:33.453614 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} oximeter.fields_i16 (2e807c20-d604-4bcf-9799-756594a429fa): There are no data parts 2024.11.15 20:11:33.463497 [ 156349 ] {0f3e8be1-51a1-4af0-a0c2-1fbf3b135e1d} TCPHandler: Processed in 0.020452437 sec. 2024.11.15 20:11:33.464260 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.467327 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} executeQuery: (from [::1]:57364) 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.15 20:11:33.467391 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 2024.11.15 20:11:33.472250 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} oximeter.fields_u16 (a1511d18-6e66-4a22-990f-c299c44f2ca9): Loading data parts 2024.11.15 20:11:33.472700 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} oximeter.fields_u16 (a1511d18-6e66-4a22-990f-c299c44f2ca9): There are no data parts 2024.11.15 20:11:33.477990 [ 156384 ] {6939e25c-6408-423b-a5af-d8bb78ad4aad} TCPHandler: Processed in 0.013909221 sec. 2024.11.15 20:11:33.478873 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.490447 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} executeQuery: (from [::1]:57354) 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.15 20:11:33.494252 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 2024.11.15 20:11:33.523836 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} oximeter.fields_i32 (d1b7bd00-a9a0-441d-8d30-ce5318dd0978): Loading data parts 2024.11.15 20:11:33.527576 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} oximeter.fields_i32 (d1b7bd00-a9a0-441d-8d30-ce5318dd0978): There are no data parts 2024.11.15 20:11:33.533016 [ 156349 ] {4f421894-5873-4457-b4f9-d1b0154e41bb} TCPHandler: Processed in 0.054340494 sec. 2024.11.15 20:11:33.533854 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.534122 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} executeQuery: (from [::1]:57364) 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.15 20:11:33.536397 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 2024.11.15 20:11:33.543431 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} oximeter.fields_u32 (d2a20529-3f93-4289-8706-93b7ba7f03a8): Loading data parts 2024.11.15 20:11:33.543759 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} oximeter.fields_u32 (d2a20529-3f93-4289-8706-93b7ba7f03a8): There are no data parts 2024.11.15 20:11:33.546955 [ 156384 ] {b09cd218-077d-4b34-b90b-b50d894d4e29} TCPHandler: Processed in 0.013279431 sec. 2024.11.15 20:11:33.547988 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.548277 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} executeQuery: (from [::1]:57354) 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.15 20:11:33.548333 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 2024.11.15 20:11:33.554901 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} oximeter.fields_i64 (6be13903-2991-4ad3-bd0e-c7f134f8d7f8): Loading data parts 2024.11.15 20:11:33.556988 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} oximeter.fields_i64 (6be13903-2991-4ad3-bd0e-c7f134f8d7f8): There are no data parts 2024.11.15 20:11:33.560558 [ 156349 ] {c9e2b882-91f1-4118-a0e6-1b19eb1b3425} TCPHandler: Processed in 0.01275001 sec. 2024.11.15 20:11:33.561410 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.562422 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} executeQuery: (from [::1]:57364) 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.15 20:11:33.562474 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 2024.11.15 20:11:33.567816 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} oximeter.fields_u64 (5d43c54b-ecdc-4859-a6fd-955abe1a9941): Loading data parts 2024.11.15 20:11:33.569933 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} oximeter.fields_u64 (5d43c54b-ecdc-4859-a6fd-955abe1a9941): There are no data parts 2024.11.15 20:11:33.576465 [ 156384 ] {f63dc627-3d42-4395-8742-1413169d9888} TCPHandler: Processed in 0.015182012 sec. 2024.11.15 20:11:33.577197 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.586958 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} executeQuery: (from [::1]:57354) 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.15 20:11:33.587027 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr 2024.11.15 20:11:33.593839 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} oximeter.fields_ipaddr (fa53718b-5c24-466b-94f4-099ffe08c6c9): Loading data parts 2024.11.15 20:11:33.600748 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} oximeter.fields_ipaddr (fa53718b-5c24-466b-94f4-099ffe08c6c9): There are no data parts 2024.11.15 20:11:33.607118 [ 156349 ] {3835d81c-d05a-4a7f-bb65-da24f19b15f6} TCPHandler: Processed in 0.030048654 sec. 2024.11.15 20:11:33.607933 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.608151 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} executeQuery: (from [::1]:57364) 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.15 20:11:33.608206 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string 2024.11.15 20:11:33.613405 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Loading data parts 2024.11.15 20:11:33.614691 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): There are no data parts 2024.11.15 20:11:33.620035 [ 156384 ] {02e91df7-b128-4714-8ddb-cd20dc3c7512} TCPHandler: Processed in 0.012269339 sec. 2024.11.15 20:11:33.623764 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.624059 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} executeQuery: (from [::1]:57354) 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.15 20:11:33.624113 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid 2024.11.15 20:11:33.628963 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} oximeter.fields_uuid (8584400f-a65b-4d10-a860-0187a55fdc47): Loading data parts 2024.11.15 20:11:33.629448 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} oximeter.fields_uuid (8584400f-a65b-4d10-a860-0187a55fdc47): There are no data parts 2024.11.15 20:11:33.632892 [ 156349 ] {4b28f518-2939-468c-b92a-c42082c88a8e} TCPHandler: Processed in 0.009299107 sec. 2024.11.15 20:11:33.633737 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.636176 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} executeQuery: (from [::1]:57364) /* 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.15 20:11:33.636253 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema 2024.11.15 20:11:33.640316 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822): Loading data parts 2024.11.15 20:11:33.640590 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822): There are no data parts 2024.11.15 20:11:33.646811 [ 156384 ] {87539ae3-f194-47d2-984f-4f55b2018dd6} TCPHandler: Processed in 0.01323151 sec. 2024.11.15 20:11:33.652344 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:33.655959 [ 156349 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} executeQuery: (from [::1]:57354) INSERT INTO oximeter.version (*) VALUES (stage: Complete) 2024.11.15 20:11:33.656062 [ 156349 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version 2024.11.15 20:11:33.657230 [ 156394 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} oximeter.version (b72dd4e2-96b6-45ef-9b16-a5d74d56658c): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.15 20:11:33.657259 [ 156394 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.69 GiB. 2024.11.15 20:11:33.657710 [ 156394 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.11.15 20:11:33.657898 [ 156394 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} oximeter.version (b72dd4e2-96b6-45ef-9b16-a5d74d56658c): 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.15 20:11:33.658230 [ 156349 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} executeQuery: Read 1 rows, 16.00 B in 0.002332 sec., 428.81646655231566 rows/sec., 6.70 KiB/sec. 2024.11.15 20:11:33.658371 [ 156349 ] {aeafa868-aaa0-482b-8dba-16f5635fe08e} TCPHandler: Processed in 0.006217585 sec. 2024.11.15 20:11:34.000394 [ 155784 ] {} AsynchronousMetrics: MemoryTracking: was 388.93 MiB, peak 388.93 MiB, free memory in arenas 16.67 MiB, will set to 390.19 MiB (RSS), difference: 1.26 MiB 2024.11.15 20:11:34.345367 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.345569 [ 156349 ] {09eaa75b-4d26-4fea-88dd-f18222775723} executeQuery: (from [::1]:57354) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) 2024.11.15 20:11:34.346695 [ 156349 ] {09eaa75b-4d26-4fea-88dd-f18222775723} ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema 2024.11.15 20:11:34.346756 [ 156349 ] {09eaa75b-4d26-4fea-88dd-f18222775723} InterpreterSelectQuery: FetchColumns -> Complete 2024.11.15 20:11:34.347335 [ 156349 ] {09eaa75b-4d26-4fea-88dd-f18222775723} TCPHandler: Processed in 0.002147562 sec. 2024.11.15 20:11:34.349333 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.351257 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} executeQuery: (from [::1]:57364) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) 2024.11.15 20:11:34.351314 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema 2024.11.15 20:11:34.353031 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.15 20:11:34.353056 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. 2024.11.15 20:11:34.353520 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.11.15 20:11:34.353698 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822): 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.15 20:11:34.353913 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} executeQuery: Read 1 rows, 123.00 B in 0.002709 sec., 369.1399040236249 rows/sec., 44.34 KiB/sec. 2024.11.15 20:11:34.355416 [ 156384 ] {d0b635f9-2334-46d0-a036-afa2332f0238} TCPHandler: Processed in 0.006208805 sec. 2024.11.15 20:11:34.356195 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.356358 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} executeQuery: (from [::1]:57354) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) 2024.11.15 20:11:34.356410 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string 2024.11.15 20:11:34.357246 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.15 20:11:34.358492 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. 2024.11.15 20:11:34.359989 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.11.15 20:11:34.360186 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): 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.15 20:11:34.360354 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} executeQuery: Read 2 rows, 212.00 B in 0.004043 sec., 494.6821667078902 rows/sec., 51.21 KiB/sec. 2024.11.15 20:11:34.360479 [ 156349 ] {b6f3752c-e5d2-4872-bb49-ab459fd541c0} TCPHandler: Processed in 0.004418983 sec. 2024.11.15 20:11:34.363328 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.364283 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} executeQuery: (from [::1]:57364) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) 2024.11.15 20:11:34.364345 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 2024.11.15 20:11:34.365190 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.15 20:11:34.366160 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. 2024.11.15 20:11:34.366502 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.11.15 20:11:34.366668 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): 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.15 20:11:34.366842 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} executeQuery: Read 1 rows, 71.00 B in 0.002611 sec., 382.99502106472613 rows/sec., 26.56 KiB/sec. 2024.11.15 20:11:34.366882 [ 156384 ] {bb6c3ebc-7502-4cf5-aa7b-588ac46710f6} TCPHandler: Processed in 0.003716023 sec. 2024.11.15 20:11:34.372857 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.373038 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} executeQuery: (from [::1]:57354) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) 2024.11.15 20:11:34.373098 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string 2024.11.15 20:11:34.374146 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.15 20:11:34.375025 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. 2024.11.15 20:11:34.377424 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) 2024.11.15 20:11:34.377597 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.11.15 20:11:34.377813 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} executeQuery: Read 2 rows, 212.00 B in 0.004827 sec., 414.33602651750573 rows/sec., 42.89 KiB/sec. 2024.11.15 20:11:34.377866 [ 156349 ] {e1060df9-22df-4ae9-a92a-cd462c3a7d27} TCPHandler: Processed in 0.005234044 sec. 2024.11.15 20:11:34.379280 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.380456 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} executeQuery: (from [::1]:57364) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) 2024.11.15 20:11:34.380530 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 2024.11.15 20:11:34.381649 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.15 20:11:34.382341 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. 2024.11.15 20:11:34.382727 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) 2024.11.15 20:11:34.382943 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.11.15 20:11:34.384906 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} executeQuery: Read 1 rows, 71.00 B in 0.004494 sec., 222.51891410769917 rows/sec., 15.43 KiB/sec. 2024.11.15 20:11:34.384960 [ 156384 ] {15281682-1966-4e3a-a883-6caccf2bc9e6} TCPHandler: Processed in 0.005826255 sec. 2024.11.15 20:11:34.392357 [ 156349 ] {} TCP-Session: 8990a5fd-92f6-4d6f-a66f-19b9e7d2ba67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.392570 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} executeQuery: (from [::1]:57354) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) 2024.11.15 20:11:34.392652 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string 2024.11.15 20:11:34.394042 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.15 20:11:34.397070 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. 2024.11.15 20:11:34.397473 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) 2024.11.15 20:11:34.399978 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} oximeter.fields_string (7d2f5679-3070-4d73-98ff-92eab6418834): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.11.15 20:11:34.400194 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} executeQuery: Read 2 rows, 212.00 B in 0.007714 sec., 259.26886180969666 rows/sec., 26.84 KiB/sec. 2024.11.15 20:11:34.400247 [ 156349 ] {28482563-8d22-49d6-975e-5c4f9ff1e1e6} TCPHandler: Processed in 0.008064716 sec. 2024.11.15 20:11:34.410157 [ 156384 ] {} TCP-Session: c7ea39b4-cf94-4221-a36e-c0883c6c1447 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.412447 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} executeQuery: (from [::1]:57364) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) 2024.11.15 20:11:34.412530 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 2024.11.15 20:11:34.413471 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.11.15 20:11:34.413499 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.48 GiB. 2024.11.15 20:11:34.417294 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) 2024.11.15 20:11:34.417467 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} oximeter.measurements_i64 (faa6d7c4-ee18-4392-8aa7-9015ace5435e): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.11.15 20:11:34.417712 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} executeQuery: Read 1 rows, 71.00 B in 0.00532 sec., 187.9699248120301 rows/sec., 13.03 KiB/sec. 2024.11.15 20:11:34.418825 [ 156384 ] {21c40ff7-eef1-410e-8cdd-e59fdc5e59c0} TCPHandler: Processed in 0.008870787 sec. 2024.11.15 20:11:34.476366 [ 155521 ] {} TCP-Session: a8ffe3dd-4704-43e7-b842-698cbd4ef1f8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.11.15 20:11:34.476605 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} executeQuery: (from [::1]:57338) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) 2024.11.15 20:11:34.476878 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema 2024.11.15 20:11:34.476946 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} InterpreterSelectQuery: FetchColumns -> Complete 2024.11.15 20:11:34.477912 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822) (SelectExecutor): Key condition: unknown 2024.11.15 20:11:34.477937 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822) (SelectExecutor): Selected 1/1 parts by partition key, 1 parts by primary key, 1/1 marks by primary key, 1 marks to read from 1 ranges 2024.11.15 20:11:34.477944 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} oximeter.timeseries_schema (45ea570f-08f6-47df-86cc-ec5b87f04822) (SelectExecutor): Spreading mark ranges among streams (default reading) 2024.11.15 20:11:34.477972 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} MergeTreeInOrderSelectProcessor: Reading 1 ranges in order from part all_1_1_0, approx. 1 rows starting from 0 2024.11.15 20:11:34.478866 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} executeQuery: Read 1 rows, 123.00 B in 0.002317 sec., 431.59257660768236 rows/sec., 51.84 KiB/sec. 2024.11.15 20:11:34.479609 [ 155521 ] {1bf7c030-557e-4e22-b15e-9f4dfca437f5} TCPHandler: Processed in 0.003434823 sec.