| 1 | 2024.11.07 23:40:05.223412 [ 196466 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2024.11.07 23:40:05.223484 [ 196466 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2024.11.07 23:40:05.294379 [ 196466 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 196466 | ||
| 4 | 2024.11.07 23:40:05.294424 [ 196466 ] {} <Information> Application: starting up | ||
| 5 | 2024.11.07 23:40:05.294437 [ 196466 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2024.11.07 23:40:05.297224 [ 196466 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2024.11.07 23:40:05.297993 [ 196466 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2024.11.07 23:40:05.298011 [ 196466 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2024.11.07 23:40:05.298048 [ 196466 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2024.11.07 23:40:05.298063 [ 196466 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2024.11.07 23:40:05.472111 [ 196466 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2024.11.07 23:40:05.472153 [ 196466 ] {} <Information> 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. | ||
| 13 | 2024.11.07 23:40:05.490130 [ 196466 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2024.11.07 23:40:05.490154 [ 196466 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2024.11.07 23:40:05.490163 [ 196466 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2024.11.07 23:40:05.490168 [ 196466 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2024.11.07 23:40:05.490193 [ 196466 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/datastore/tmp/ to store temporary data in it | ||
| 18 | 2024.11.07 23:40:05.490895 [ 196466 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2024.11.07 23:40:05.491409 [ 196466 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml' | ||
| 20 | 2024.11.07 23:40:05.491784 [ 196466 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml', performing update on configuration | ||
| 21 | 2024.11.07 23:40:05.492252 [ 196466 ] {} <Information> 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) | ||
| 22 | 2024.11.07 23:40:05.492263 [ 196466 ] {} <Information> 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) | ||
| 23 | 2024.11.07 23:40:05.492269 [ 196466 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2024.11.07 23:40:05.492309 [ 196466 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2024.11.07 23:40:05.493054 [ 196466 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2024.11.07 23:40:05.522319 [ 196466 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2024.11.07 23:40:05.526271 [ 196466 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2024.11.07 23:40:05.538053 [ 196466 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2024.11.07 23:40:05.538087 [ 196466 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml', performed update on configuration | ||
| 30 | 2024.11.07 23:40:05.541813 [ 196466 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml' | ||
| 31 | 2024.11.07 23:40:05.542266 [ 196466 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml', performing update on configuration | ||
| 32 | 2024.11.07 23:40:05.549611 [ 196466 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml', performed update on configuration | ||
| 33 | 2024.11.07 23:40:05.553747 [ 196466 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/config.xml | ||
| 34 | 2024.11.07 23:40:05.554490 [ 196466 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2024.11.07 23:40:05.562401 [ 196466 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2024.11.07 23:40:05.562665 [ 196466 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2024.11.07 23:40:05.564070 [ 196466 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2024.11.07 23:40:05.573519 [ 196466 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2024.11.07 23:40:05.573595 [ 196728 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 40 | 2024.11.07 23:40:05.573615 [ 196728 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 41 | 2024.11.07 23:40:05.573635 [ 196466 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/datastore/ | ||
| 42 | 2024.11.07 23:40:05.589940 [ 196466 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2024.11.07 23:40:05.589966 [ 196466 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000140889 sec | ||
| 44 | 2024.11.07 23:40:05.589973 [ 196466 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2024.11.07 23:40:05.589978 [ 196466 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2024.11.07 23:40:05.590000 [ 196466 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2024.11.07 23:40:05.590029 [ 196466 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2024.11.07 23:40:05.591402 [ 196466 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2024.11.07 23:40:05.591418 [ 196466 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2024.11.07 23:40:05.591425 [ 196466 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2024.11.07 23:40:05.591432 [ 196466 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2024.11.07 23:40:05.591438 [ 196466 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2024.11.07 23:40:05.591445 [ 196466 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 54 | 2024.11.07 23:40:05.591451 [ 196466 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2024.11.07 23:40:05.591459 [ 196466 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2024.11.07 23:40:05.591471 [ 196466 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 57 | 2024.11.07 23:40:05.591478 [ 196466 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2024.11.07 23:40:05.591485 [ 196466 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2024.11.07 23:40:05.591491 [ 196466 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2024.11.07 23:40:05.591497 [ 196466 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2024.11.07 23:40:05.591504 [ 196466 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2024.11.07 23:40:05.591510 [ 196466 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2024.11.07 23:40:05.591517 [ 196466 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2024.11.07 23:40:05.625452 [ 196466 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2024.11.07 23:40:05.644281 [ 196466 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2024.11.07 23:40:05.644327 [ 196466 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.035e-05 sec | ||
| 67 | 2024.11.07 23:40:05.644334 [ 196466 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2024.11.07 23:40:05.644339 [ 196466 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2024.11.07 23:40:05.644361 [ 196466 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2024.11.07 23:40:05.644461 [ 196466 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-3963749b3ee9bb2b-test_update_uninitialized.195832.2-clickhouse-QgILTI/datastore/user_defined/ | ||
| 71 | 2024.11.07 23:40:05.644491 [ 196466 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2024.11.07 23:40:05.644497 [ 196466 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2024.11.07 23:40:05.644515 [ 196466 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2024.11.07 23:40:05.644522 [ 196466 ] {} <Information> 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. | ||
| 75 | 2024.11.07 23:40:05.644595 [ 196466 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34915 | ||
| 76 | 2024.11.07 23:40:05.644642 [ 196466 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 42383 | ||
| 77 | 2024.11.07 23:40:05.644790 [ 196466 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 45547 | ||
| 78 | 2024.11.07 23:40:05.644844 [ 196466 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 35949 | ||
| 79 | 2024.11.07 23:40:05.644864 [ 196466 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2024.11.07 23:40:05.645263 [ 196466 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.60 MiB, peak 20.60 MiB, free memory in arenas 9.74 MiB, will set to 373.79 MiB (RSS), difference: 353.19 MiB | ||
| 81 | 2024.11.07 23:40:05.646999 [ 196466 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.1311e-05 sec. | ||
| 82 | 2024.11.07 23:40:05.647747 [ 196466 ] {} <Information> Application: Listening for http://[::1]:34915 | ||
| 83 | 2024.11.07 23:40:05.647925 [ 196466 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:42383 | ||
| 84 | 2024.11.07 23:40:05.648019 [ 196466 ] {} <Information> Application: Listening for http://127.0.0.1:45547 | ||
| 85 | 2024.11.07 23:40:05.648081 [ 196466 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:35949 | ||
| 86 | 2024.11.07 23:40:05.648091 [ 196466 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2024.11.07 23:40:06.499758 [ 196491 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56432 | ||
| 88 | 2024.11.07 23:40:06.514350 [ 196491 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2024.11.07 23:40:06.514379 [ 196491 ] {} <Debug> TCP-Session: e31770f0-5d57-409c-b94c-7c1630329e23 Authenticating user 'default' from [::1]:56432 | ||
| 90 | 2024.11.07 23:40:06.514393 [ 196491 ] {} <Debug> TCP-Session: e31770f0-5d57-409c-b94c-7c1630329e23 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2024.11.07 23:40:06.514399 [ 196491 ] {} <Debug> TCP-Session: e31770f0-5d57-409c-b94c-7c1630329e23 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2024.11.07 23:40:06.514481 [ 196491 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2024.11.07 23:40:06.514503 [ 196491 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 94 | 2024.11.07 23:40:06.514513 [ 196491 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 95 | 2024.11.07 23:40:06.515884 [ 196493 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56436 | ||
| 96 | 2024.11.07 23:40:06.515970 [ 196493 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 97 | 2024.11.07 23:40:06.515997 [ 196493 ] {} <Debug> TCP-Session: 28170af0-0f49-472c-acb9-8085c4962c58 Authenticating user 'default' from [::1]:56436 | ||
| 98 | 2024.11.07 23:40:06.516008 [ 196493 ] {} <Debug> TCP-Session: 28170af0-0f49-472c-acb9-8085c4962c58 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 99 | 2024.11.07 23:40:06.516014 [ 196493 ] {} <Debug> TCP-Session: 28170af0-0f49-472c-acb9-8085c4962c58 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 100 | 2024.11.07 23:40:06.551578 [ 197293 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56438 | ||
| 101 | 2024.11.07 23:40:06.551698 [ 197293 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 102 | 2024.11.07 23:40:06.551726 [ 197293 ] {} <Debug> TCP-Session: f88fdeb4-2f74-4e15-b4c0-96d94adec63a Authenticating user 'default' from [::1]:56438 | ||
| 103 | 2024.11.07 23:40:06.551741 [ 197293 ] {} <Debug> TCP-Session: f88fdeb4-2f74-4e15-b4c0-96d94adec63a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 104 | 2024.11.07 23:40:06.551748 [ 197293 ] {} <Debug> TCP-Session: f88fdeb4-2f74-4e15-b4c0-96d94adec63a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2024.11.07 23:40:06.575979 [ 197294 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56440 | ||
| 106 | 2024.11.07 23:40:06.576005 [ 197296 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56444 | ||
| 107 | 2024.11.07 23:40:06.577577 [ 197294 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 108 | 2024.11.07 23:40:06.577615 [ 197294 ] {} <Debug> TCP-Session: fab74c6b-d4b3-42cf-8d4a-ad723fe9cd4a Authenticating user 'default' from [::1]:56440 | ||
| 109 | 2024.11.07 23:40:06.577632 [ 197294 ] {} <Debug> TCP-Session: fab74c6b-d4b3-42cf-8d4a-ad723fe9cd4a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2024.11.07 23:40:06.577639 [ 197294 ] {} <Debug> TCP-Session: fab74c6b-d4b3-42cf-8d4a-ad723fe9cd4a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 111 | 2024.11.07 23:40:06.577637 [ 197296 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 112 | 2024.11.07 23:40:06.577687 [ 197296 ] {} <Debug> TCP-Session: f3e968e0-afbf-47d1-a8f3-f913fd6f9146 Authenticating user 'default' from [::1]:56444 | ||
| 113 | 2024.11.07 23:40:06.577699 [ 197296 ] {} <Debug> TCP-Session: f3e968e0-afbf-47d1-a8f3-f913fd6f9146 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 114 | 2024.11.07 23:40:06.577706 [ 197296 ] {} <Debug> TCP-Session: f3e968e0-afbf-47d1-a8f3-f913fd6f9146 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 115 | 2024.11.07 23:40:06.591061 [ 196492 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56434 | ||
| 116 | 2024.11.07 23:40:06.591063 [ 197295 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56442 | ||
| 117 | 2024.11.07 23:40:06.592452 [ 197295 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 118 | 2024.11.07 23:40:06.592475 [ 197295 ] {} <Debug> TCP-Session: bf0aa8ec-6434-4939-8e8f-7522a3f8a70a Authenticating user 'default' from [::1]:56442 | ||
| 119 | 2024.11.07 23:40:06.592487 [ 197295 ] {} <Debug> TCP-Session: bf0aa8ec-6434-4939-8e8f-7522a3f8a70a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 120 | 2024.11.07 23:40:06.592494 [ 197295 ] {} <Debug> TCP-Session: bf0aa8ec-6434-4939-8e8f-7522a3f8a70a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 121 | 2024.11.07 23:40:06.592770 [ 196492 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 122 | 2024.11.07 23:40:06.592799 [ 196492 ] {} <Debug> TCP-Session: ac7fff8e-52ae-48aa-b30c-c845bc7e8231 Authenticating user 'default' from [::1]:56434 | ||
| 123 | 2024.11.07 23:40:06.592810 [ 196492 ] {} <Debug> TCP-Session: ac7fff8e-52ae-48aa-b30c-c845bc7e8231 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 124 | 2024.11.07 23:40:06.592817 [ 196492 ] {} <Debug> TCP-Session: ac7fff8e-52ae-48aa-b30c-c845bc7e8231 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 125 | 2024.11.07 23:40:06.591137 [ 197297 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56446 | ||
| 126 | 2024.11.07 23:40:06.592977 [ 197297 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2024.11.07 23:40:06.593001 [ 197297 ] {} <Debug> TCP-Session: 63c94e7e-470e-41d7-8a53-cb994170888b Authenticating user 'default' from [::1]:56446 | ||
| 128 | 2024.11.07 23:40:06.593010 [ 197297 ] {} <Debug> TCP-Session: 63c94e7e-470e-41d7-8a53-cb994170888b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2024.11.07 23:40:06.593078 [ 197297 ] {} <Debug> TCP-Session: 63c94e7e-470e-41d7-8a53-cb994170888b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2024.11.07 23:40:15.286502 [ 197785 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56448 | ||
| 131 | 2024.11.07 23:40:15.286625 [ 197785 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 132 | 2024.11.07 23:40:15.286658 [ 197785 ] {} <Debug> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Authenticating user 'default' from [::1]:56448 | ||
| 133 | 2024.11.07 23:40:15.286673 [ 197785 ] {} <Debug> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 134 | 2024.11.07 23:40:15.286680 [ 197785 ] {} <Debug> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 135 | 2024.11.07 23:40:15.288305 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 136 | 2024.11.07 23:40:15.289959 [ 197785 ] {c7e89b99-bed2-4b6d-8c5f-2d10e5755e4b} <Debug> executeQuery: (from [::1]:56448) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 137 | 2024.11.07 23:40:15.290657 [ 197785 ] {c7e89b99-bed2-4b6d-8c5f-2d10e5755e4b} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:56448) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 138 | |||
| 139 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 140 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 141 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 142 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 143 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 144 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 145 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 146 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 147 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 148 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 149 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 150 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 151 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 152 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 153 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 154 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 155 | 16. ? @ 0x00007fce488faac3 in ? | ||
| 156 | 17. ? @ 0x00007fce4898c850 in ? | ||
| 157 | |||
| 158 | 2024.11.07 23:40:15.290844 [ 197785 ] {c7e89b99-bed2-4b6d-8c5f-2d10e5755e4b} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 159 | |||
| 160 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 161 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 162 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 163 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 164 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 165 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 166 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 167 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 168 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 171 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 172 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 173 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 174 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 175 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 176 | 16. ? @ 0x00007fce488faac3 in ? | ||
| 177 | 17. ? @ 0x00007fce4898c850 in ? | ||
| 178 | |||
| 179 | 2024.11.07 23:40:15.290960 [ 197785 ] {c7e89b99-bed2-4b6d-8c5f-2d10e5755e4b} <Debug> TCPHandler: Processed in 0.002833313 sec. | ||
| 180 | 2024.11.07 23:40:15.291760 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 181 | 2024.11.07 23:40:15.292579 [ 197785 ] {1c3a515b-36f3-4d1d-82d4-69bbb51d13d2} <Debug> executeQuery: (from [::1]:56448) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 182 | 2024.11.07 23:40:15.292839 [ 197785 ] {1c3a515b-36f3-4d1d-82d4-69bbb51d13d2} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:56448) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 183 | |||
| 184 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 185 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 186 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 187 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 188 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 189 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 195 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 197 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 198 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 199 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 200 | 16. ? @ 0x00007fce488faac3 in ? | ||
| 201 | 17. ? @ 0x00007fce4898c850 in ? | ||
| 202 | |||
| 203 | 2024.11.07 23:40:15.292985 [ 197785 ] {1c3a515b-36f3-4d1d-82d4-69bbb51d13d2} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 204 | |||
| 205 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 206 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 207 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 208 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 209 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 210 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 211 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 212 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 213 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 214 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 215 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 216 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 217 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 218 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 219 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 220 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 221 | 16. ? @ 0x00007fce488faac3 in ? | ||
| 222 | 17. ? @ 0x00007fce4898c850 in ? | ||
| 223 | |||
| 224 | 2024.11.07 23:40:15.293078 [ 197785 ] {1c3a515b-36f3-4d1d-82d4-69bbb51d13d2} <Debug> TCPHandler: Processed in 0.001377521 sec. | ||
| 225 | 2024.11.07 23:40:15.293919 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 226 | 2024.11.07 23:40:15.295201 [ 197785 ] {a1ca6010-1e11-4d24-bf2b-52ef6d29f10a} <Debug> executeQuery: (from [::1]:56448) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 227 | 2024.11.07 23:40:15.295288 [ 197785 ] {a1ca6010-1e11-4d24-bf2b-52ef6d29f10a} <Debug> TCPHandler: Processed in 0.001430811 sec. | ||
| 228 | 2024.11.07 23:40:15.296666 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 229 | 2024.11.07 23:40:15.296780 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} <Debug> executeQuery: (from [::1]:56448) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 230 | 2024.11.07 23:40:15.296811 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 231 | 2024.11.07 23:40:15.301143 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 232 | 2024.11.07 23:40:15.301194 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00014685 sec | ||
| 233 | 2024.11.07 23:40:15.301204 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} <Trace> ReferentialDeps: No tables | ||
| 234 | 2024.11.07 23:40:15.301211 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} <Trace> LoadingDeps: No tables | ||
| 235 | 2024.11.07 23:40:15.301232 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 236 | 2024.11.07 23:40:15.301323 [ 197785 ] {e5eea8de-0172-4c8b-b568-d931055d33fa} <Debug> TCPHandler: Processed in 0.004726614 sec. | ||
| 237 | 2024.11.07 23:40:15.302356 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 238 | 2024.11.07 23:40:15.302552 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} <Debug> executeQuery: (from [::1]:56448) /* The version table contains metadata about the `oximeter` database */ | ||
| 239 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 240 | 2024.11.07 23:40:15.302594 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 241 | 2024.11.07 23:40:15.303478 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 242 | 2024.11.07 23:40:15.309272 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} <Debug> oximeter.version (95637719-7cd6-4375-8b6a-0074c61d457f): Loading data parts | ||
| 243 | 2024.11.07 23:40:15.314096 [ 197786 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56450 | ||
| 244 | 2024.11.07 23:40:15.314200 [ 197786 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 245 | 2024.11.07 23:40:15.315136 [ 197786 ] {} <Debug> TCP-Session: 1298bd90-e7f7-4c6f-a291-554d1e3a70ad Authenticating user 'default' from [::1]:56450 | ||
| 246 | 2024.11.07 23:40:15.315178 [ 197786 ] {} <Debug> TCP-Session: 1298bd90-e7f7-4c6f-a291-554d1e3a70ad Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 247 | 2024.11.07 23:40:15.315185 [ 197786 ] {} <Debug> TCP-Session: 1298bd90-e7f7-4c6f-a291-554d1e3a70ad Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 248 | 2024.11.07 23:40:15.323811 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} <Debug> oximeter.version (95637719-7cd6-4375-8b6a-0074c61d457f): There are no data parts | ||
| 249 | 2024.11.07 23:40:15.328643 [ 197785 ] {3fc09305-fc51-4787-a5c1-a81917b68738} <Debug> TCPHandler: Processed in 0.026384941 sec. | ||
| 250 | 2024.11.07 23:40:15.340820 [ 197794 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56462 | ||
| 251 | 2024.11.07 23:40:15.340942 [ 197794 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 252 | 2024.11.07 23:40:15.340958 [ 197791 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56456 | ||
| 253 | 2024.11.07 23:40:15.341005 [ 197794 ] {} <Debug> TCP-Session: b1d7c0a3-6eb6-4cf7-bd38-b6cce2585683 Authenticating user 'default' from [::1]:56462 | ||
| 254 | 2024.11.07 23:40:15.341031 [ 197794 ] {} <Debug> TCP-Session: b1d7c0a3-6eb6-4cf7-bd38-b6cce2585683 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 255 | 2024.11.07 23:40:15.341039 [ 197794 ] {} <Debug> TCP-Session: b1d7c0a3-6eb6-4cf7-bd38-b6cce2585683 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 256 | 2024.11.07 23:40:15.341039 [ 197791 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 257 | 2024.11.07 23:40:15.341065 [ 197791 ] {} <Debug> TCP-Session: f33b0fdd-da1f-4a3a-aa5e-b281a6bd61dc Authenticating user 'default' from [::1]:56456 | ||
| 258 | 2024.11.07 23:40:15.341075 [ 197791 ] {} <Debug> TCP-Session: f33b0fdd-da1f-4a3a-aa5e-b281a6bd61dc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 259 | 2024.11.07 23:40:15.341081 [ 197791 ] {} <Debug> TCP-Session: f33b0fdd-da1f-4a3a-aa5e-b281a6bd61dc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 260 | 2024.11.07 23:40:15.341195 [ 197791 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 261 | 2024.11.07 23:40:15.341220 [ 197791 ] {} <Debug> TCP-Session: f33b0fdd-da1f-4a3a-aa5e-b281a6bd61dc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 262 | 2024.11.07 23:40:15.341445 [ 197798 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56470 | ||
| 263 | 2024.11.07 23:40:15.342544 [ 197798 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 264 | 2024.11.07 23:40:15.342565 [ 197798 ] {} <Debug> TCP-Session: a589fe36-1c8c-4eb9-9c90-98172cf9b4a5 Authenticating user 'default' from [::1]:56470 | ||
| 265 | 2024.11.07 23:40:15.342573 [ 197798 ] {} <Debug> TCP-Session: a589fe36-1c8c-4eb9-9c90-98172cf9b4a5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 266 | 2024.11.07 23:40:15.342577 [ 197798 ] {} <Debug> TCP-Session: a589fe36-1c8c-4eb9-9c90-98172cf9b4a5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 267 | 2024.11.07 23:40:15.341537 [ 197795 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56464 | ||
| 268 | 2024.11.07 23:40:15.342741 [ 197795 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 269 | 2024.11.07 23:40:15.342787 [ 197795 ] {} <Debug> TCP-Session: 5fb0e81e-7c51-4e8b-9ec6-e92af25d75c4 Authenticating user 'default' from [::1]:56464 | ||
| 270 | 2024.11.07 23:40:15.342769 [ 197789 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56454 | ||
| 271 | 2024.11.07 23:40:15.342803 [ 197795 ] {} <Debug> TCP-Session: 5fb0e81e-7c51-4e8b-9ec6-e92af25d75c4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 272 | 2024.11.07 23:40:15.341753 [ 197788 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56452 | ||
| 273 | 2024.11.07 23:40:15.342794 [ 197792 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56458 | ||
| 274 | 2024.11.07 23:40:15.342810 [ 197795 ] {} <Debug> TCP-Session: 5fb0e81e-7c51-4e8b-9ec6-e92af25d75c4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2024.11.07 23:40:15.341751 [ 197796 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56466 | ||
| 276 | 2024.11.07 23:40:15.342904 [ 197789 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 277 | 2024.11.07 23:40:15.342935 [ 197789 ] {} <Debug> TCP-Session: 6c35a915-8e9d-4279-a0bf-825c4a0ed700 Authenticating user 'default' from [::1]:56454 | ||
| 278 | 2024.11.07 23:40:15.342944 [ 197789 ] {} <Debug> TCP-Session: 6c35a915-8e9d-4279-a0bf-825c4a0ed700 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2024.11.07 23:40:15.342951 [ 197789 ] {} <Debug> TCP-Session: 6c35a915-8e9d-4279-a0bf-825c4a0ed700 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 280 | 2024.11.07 23:40:15.343079 [ 197796 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 281 | 2024.11.07 23:40:15.343083 [ 197797 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56468 | ||
| 282 | 2024.11.07 23:40:15.343109 [ 197796 ] {} <Debug> TCP-Session: 0233d11d-c532-46c6-9a89-5697dbd0c6b0 Authenticating user 'default' from [::1]:56466 | ||
| 283 | 2024.11.07 23:40:15.343097 [ 197793 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56460 | ||
| 284 | 2024.11.07 23:40:15.343121 [ 197789 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 285 | 2024.11.07 23:40:15.343120 [ 197796 ] {} <Debug> TCP-Session: 0233d11d-c532-46c6-9a89-5697dbd0c6b0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 286 | 2024.11.07 23:40:15.343143 [ 197796 ] {} <Debug> TCP-Session: 0233d11d-c532-46c6-9a89-5697dbd0c6b0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 287 | 2024.11.07 23:40:15.343166 [ 197797 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 288 | 2024.11.07 23:40:15.343181 [ 197788 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 289 | 2024.11.07 23:40:15.343193 [ 197797 ] {} <Debug> TCP-Session: 2975604e-1615-4dd7-8721-65bce47993cc Authenticating user 'default' from [::1]:56468 | ||
| 290 | 2024.11.07 23:40:15.341574 [ 197799 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:56472 | ||
| 291 | 2024.11.07 23:40:15.343202 [ 197788 ] {} <Debug> TCP-Session: 56009516-2ce1-4b1c-b4a6-97c4d2217676 Authenticating user 'default' from [::1]:56452 | ||
| 292 | 2024.11.07 23:40:15.343201 [ 197797 ] {} <Debug> TCP-Session: 2975604e-1615-4dd7-8721-65bce47993cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2024.11.07 23:40:15.343225 [ 197788 ] {} <Debug> TCP-Session: 56009516-2ce1-4b1c-b4a6-97c4d2217676 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2024.11.07 23:40:15.343236 [ 197797 ] {} <Debug> TCP-Session: 2975604e-1615-4dd7-8721-65bce47993cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.11.07 23:40:15.343143 [ 197789 ] {} <Debug> TCP-Session: 6c35a915-8e9d-4279-a0bf-825c4a0ed700 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 296 | 2024.11.07 23:40:15.343339 [ 197792 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 297 | 2024.11.07 23:40:15.343249 [ 197788 ] {} <Debug> TCP-Session: 56009516-2ce1-4b1c-b4a6-97c4d2217676 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 298 | 2024.11.07 23:40:15.343747 [ 197788 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 299 | 2024.11.07 23:40:15.343767 [ 197788 ] {} <Debug> TCP-Session: 56009516-2ce1-4b1c-b4a6-97c4d2217676 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 300 | 2024.11.07 23:40:15.343412 [ 197799 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 301 | 2024.11.07 23:40:15.343425 [ 197793 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 302 | 2024.11.07 23:40:15.343954 [ 197793 ] {} <Debug> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Authenticating user 'default' from [::1]:56460 | ||
| 303 | 2024.11.07 23:40:15.343965 [ 197793 ] {} <Debug> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 304 | 2024.11.07 23:40:15.343972 [ 197793 ] {} <Debug> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 305 | 2024.11.07 23:40:15.344057 [ 197799 ] {} <Debug> TCP-Session: 852d105e-e1d6-4630-82b3-7c32d27dab1c Authenticating user 'default' from [::1]:56472 | ||
| 306 | 2024.11.07 23:40:15.344072 [ 197799 ] {} <Debug> TCP-Session: 852d105e-e1d6-4630-82b3-7c32d27dab1c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.11.07 23:40:15.344078 [ 197799 ] {} <Debug> TCP-Session: 852d105e-e1d6-4630-82b3-7c32d27dab1c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 308 | 2024.11.07 23:40:15.344103 [ 197792 ] {} <Debug> TCP-Session: 8cbc17a0-b29d-4188-8c46-d5061d5bfaae Authenticating user 'default' from [::1]:56458 | ||
| 309 | 2024.11.07 23:40:15.344121 [ 197792 ] {} <Debug> TCP-Session: 8cbc17a0-b29d-4188-8c46-d5061d5bfaae Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 310 | 2024.11.07 23:40:15.344128 [ 197792 ] {} <Debug> TCP-Session: 8cbc17a0-b29d-4188-8c46-d5061d5bfaae Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2024.11.07 23:40:15.344208 [ 197792 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 312 | 2024.11.07 23:40:15.344224 [ 197792 ] {} <Debug> TCP-Session: 8cbc17a0-b29d-4188-8c46-d5061d5bfaae Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 313 | 2024.11.07 23:40:15.600388 [ 196824 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 314 | 2024.11.07 23:40:15.600471 [ 196824 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
| 315 | 2024.11.07 23:40:15.606863 [ 196824 ] {} <Debug> system.query_log (1cd01d8d-d39a-4ddb-bb15-375667d2687e): Loading data parts | ||
| 316 | 2024.11.07 23:40:15.607023 [ 196824 ] {} <Debug> system.query_log (1cd01d8d-d39a-4ddb-bb15-375667d2687e): There are no data parts | ||
| 317 | 2024.11.07 23:40:15.613915 [ 196824 ] {} <Trace> system.query_log (1cd01d8d-d39a-4ddb-bb15-375667d2687e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 318 | 2024.11.07 23:40:15.613949 [ 196824 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 164.62 GiB. | ||
| 319 | 2024.11.07 23:40:15.616702 [ 196824 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 320 | 2024.11.07 23:40:15.616969 [ 196824 ] {} <Trace> system.query_log (1cd01d8d-d39a-4ddb-bb15-375667d2687e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 321 | 2024.11.07 23:40:15.618159 [ 196824 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 8 | ||
| 322 | 2024.11.07 23:40:15.653963 [ 197794 ] {} <Trace> TCP-Session: b1d7c0a3-6eb6-4cf7-bd38-b6cce2585683 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 323 | 2024.11.07 23:40:15.654322 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} <Debug> executeQuery: (from [::1]:56462) /* The measurement tables contain all individual samples from each timeseries. | ||
| 324 | * | ||
| 325 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 326 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 327 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 328 | * by all samples from the same timeseries. | ||
| 329 | * | ||
| 330 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 331 | * and then uses that to index quickly into the measurements tables. | ||
| 332 | */ | ||
| 333 | 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) | ||
| 334 | 2024.11.07 23:40:15.656096 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 335 | 2024.11.07 23:40:15.660697 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} <Debug> oximeter.measurements_bool (60a8b2e5-1962-49a6-8897-7e778dc36e09): Loading data parts | ||
| 336 | 2024.11.07 23:40:15.663183 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} <Debug> oximeter.measurements_bool (60a8b2e5-1962-49a6-8897-7e778dc36e09): There are no data parts | ||
| 337 | 2024.11.07 23:40:15.675224 [ 197794 ] {86097288-d47f-490f-bf99-8a98480916f5} <Debug> TCPHandler: Processed in 0.021485598 sec. | ||
| 338 | 2024.11.07 23:40:15.676777 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 339 | 2024.11.07 23:40:15.677478 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 340 | 2024.11.07 23:40:15.677548 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 341 | 2024.11.07 23:40:15.682586 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} <Debug> oximeter.measurements_i8 (8024cb19-106d-4cfc-96cb-8efe7cb4c12d): Loading data parts | ||
| 342 | 2024.11.07 23:40:15.682916 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} <Debug> oximeter.measurements_i8 (8024cb19-106d-4cfc-96cb-8efe7cb4c12d): There are no data parts | ||
| 343 | 2024.11.07 23:40:15.686566 [ 197785 ] {9655fb30-8212-49c6-ace8-12dc641f94ac} <Debug> TCPHandler: Processed in 0.009912148 sec. | ||
| 344 | 2024.11.07 23:40:15.688769 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 345 | 2024.11.07 23:40:15.689148 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 346 | 2024.11.07 23:40:15.690348 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 347 | 2024.11.07 23:40:15.694694 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} <Debug> oximeter.measurements_u8 (1ffef74c-df76-4830-ad2b-018748b47379): Loading data parts | ||
| 348 | 2024.11.07 23:40:15.694990 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} <Debug> oximeter.measurements_u8 (1ffef74c-df76-4830-ad2b-018748b47379): There are no data parts | ||
| 349 | 2024.11.07 23:40:15.700546 [ 197793 ] {fed1a0bf-f2d3-4d27-a38c-bcd47614af83} <Debug> TCPHandler: Processed in 0.01195134 sec. | ||
| 350 | 2024.11.07 23:40:15.705336 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 351 | 2024.11.07 23:40:15.705651 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 352 | 2024.11.07 23:40:15.705706 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 353 | 2024.11.07 23:40:15.711126 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} <Debug> oximeter.measurements_i16 (cb4eaa25-220a-4671-a772-4f2c39c0337a): Loading data parts | ||
| 354 | 2024.11.07 23:40:15.714197 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} <Debug> oximeter.measurements_i16 (cb4eaa25-220a-4671-a772-4f2c39c0337a): There are no data parts | ||
| 355 | 2024.11.07 23:40:15.719680 [ 197785 ] {d5f5c8f0-9d24-46c1-83cd-10507bf6ece6} <Debug> TCPHandler: Processed in 0.014507631 sec. | ||
| 356 | 2024.11.07 23:40:15.733061 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 357 | 2024.11.07 23:40:15.733343 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 358 | 2024.11.07 23:40:15.733400 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 359 | 2024.11.07 23:40:15.738589 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} <Debug> oximeter.measurements_u16 (7a1dbfeb-0e8b-4613-8885-23f653a770a4): Loading data parts | ||
| 360 | 2024.11.07 23:40:15.738830 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} <Debug> oximeter.measurements_u16 (7a1dbfeb-0e8b-4613-8885-23f653a770a4): There are no data parts | ||
| 361 | 2024.11.07 23:40:15.742982 [ 197793 ] {c4afe92f-71b6-44d8-a8e9-44b479e7f5d0} <Debug> TCPHandler: Processed in 0.010096528 sec. | ||
| 362 | 2024.11.07 23:40:15.748359 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 363 | 2024.11.07 23:40:15.748638 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 364 | 2024.11.07 23:40:15.748688 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 365 | 2024.11.07 23:40:15.754304 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} <Debug> oximeter.measurements_i32 (8e83bacd-c22a-4c6f-9a6b-a8d8cc4bcd09): Loading data parts | ||
| 366 | 2024.11.07 23:40:15.754503 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} <Debug> oximeter.measurements_i32 (8e83bacd-c22a-4c6f-9a6b-a8d8cc4bcd09): There are no data parts | ||
| 367 | 2024.11.07 23:40:15.759154 [ 197785 ] {20ca8f6e-e963-44a9-a6f7-370ce2cb0341} <Debug> TCPHandler: Processed in 0.010958529 sec. | ||
| 368 | 2024.11.07 23:40:15.760523 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 369 | 2024.11.07 23:40:15.760805 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 370 | 2024.11.07 23:40:15.761907 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 371 | 2024.11.07 23:40:15.769134 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} <Debug> oximeter.measurements_u32 (d40d4583-cf74-4c08-9a11-caafe97e4d68): Loading data parts | ||
| 372 | 2024.11.07 23:40:15.769360 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} <Debug> oximeter.measurements_u32 (d40d4583-cf74-4c08-9a11-caafe97e4d68): There are no data parts | ||
| 373 | 2024.11.07 23:40:15.772984 [ 197793 ] {7cb4b3e9-5857-436a-b8cb-bda212256ce5} <Debug> TCPHandler: Processed in 0.01261882 sec. | ||
| 374 | 2024.11.07 23:40:15.776901 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 375 | 2024.11.07 23:40:15.777759 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 376 | 2024.11.07 23:40:15.777815 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 377 | 2024.11.07 23:40:15.782774 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} <Debug> oximeter.measurements_i64 (48aa8ad5-aa8b-48b3-97da-707086136622): Loading data parts | ||
| 378 | 2024.11.07 23:40:15.782989 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} <Debug> oximeter.measurements_i64 (48aa8ad5-aa8b-48b3-97da-707086136622): There are no data parts | ||
| 379 | 2024.11.07 23:40:15.786204 [ 197785 ] {bce98b9e-6409-4551-9458-7944f8622aa2} <Debug> TCPHandler: Processed in 0.009459018 sec. | ||
| 380 | 2024.11.07 23:40:15.788213 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 381 | 2024.11.07 23:40:15.789640 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 382 | 2024.11.07 23:40:15.789695 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 383 | 2024.11.07 23:40:15.794064 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} <Debug> oximeter.measurements_u64 (1f62ad17-d32b-4df7-b34a-9467cc451c0a): Loading data parts | ||
| 384 | 2024.11.07 23:40:15.794319 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} <Debug> oximeter.measurements_u64 (1f62ad17-d32b-4df7-b34a-9467cc451c0a): There are no data parts | ||
| 385 | 2024.11.07 23:40:15.797601 [ 197793 ] {bbcaef66-562c-466c-8b9f-56f20ca0a9f7} <Debug> TCPHandler: Processed in 0.009536427 sec. | ||
| 386 | 2024.11.07 23:40:15.800475 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 387 | 2024.11.07 23:40:15.801438 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 388 | 2024.11.07 23:40:15.801489 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 389 | 2024.11.07 23:40:15.805374 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} <Debug> oximeter.measurements_f32 (aacfad2c-ac1d-48a2-8df7-996900b3f2cc): Loading data parts | ||
| 390 | 2024.11.07 23:40:15.805636 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} <Debug> oximeter.measurements_f32 (aacfad2c-ac1d-48a2-8df7-996900b3f2cc): There are no data parts | ||
| 391 | 2024.11.07 23:40:15.809359 [ 197785 ] {f6176c42-116c-4898-9d50-a873666e0759} <Debug> TCPHandler: Processed in 0.009034547 sec. | ||
| 392 | 2024.11.07 23:40:15.810668 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 393 | 2024.11.07 23:40:15.811517 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_f64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 394 | 2024.11.07 23:40:15.811564 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 395 | 2024.11.07 23:40:15.815582 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} <Debug> oximeter.measurements_f64 (3e8262d8-3941-4e9e-8ae0-d3cc2c536c24): Loading data parts | ||
| 396 | 2024.11.07 23:40:15.815845 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} <Debug> oximeter.measurements_f64 (3e8262d8-3941-4e9e-8ae0-d3cc2c536c24): There are no data parts | ||
| 397 | 2024.11.07 23:40:15.821256 [ 197793 ] {11203574-fd5f-4fee-9e68-a6efd48f8707} <Debug> TCPHandler: Processed in 0.010710678 sec. | ||
| 398 | 2024.11.07 23:40:15.822007 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 399 | 2024.11.07 23:40:15.822263 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_string ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(String) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 400 | 2024.11.07 23:40:15.823273 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 401 | 2024.11.07 23:40:15.828830 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} <Debug> oximeter.measurements_string (fe858cac-0263-4196-a8d7-43920405195a): Loading data parts | ||
| 402 | 2024.11.07 23:40:15.829074 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} <Debug> oximeter.measurements_string (fe858cac-0263-4196-a8d7-43920405195a): There are no data parts | ||
| 403 | 2024.11.07 23:40:15.833403 [ 197785 ] {8691476f-3266-41c7-a017-c2ca3c1abd85} <Debug> TCPHandler: Processed in 0.011528329 sec. | ||
| 404 | 2024.11.07 23:40:15.834911 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 405 | 2024.11.07 23:40:15.835841 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 406 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 407 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 408 | * a string isn't palatable for a few reasons. | ||
| 409 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 410 | * details. | ||
| 411 | */ | ||
| 412 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 413 | 2024.11.07 23:40:15.835892 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 414 | 2024.11.07 23:40:15.841194 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} <Debug> oximeter.measurements_bytes (1eb64d49-4446-4999-aedd-afd6075fe7b4): Loading data parts | ||
| 415 | 2024.11.07 23:40:15.841407 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} <Debug> oximeter.measurements_bytes (1eb64d49-4446-4999-aedd-afd6075fe7b4): There are no data parts | ||
| 416 | 2024.11.07 23:40:15.845191 [ 197793 ] {ad63cf87-ea55-454a-ba7f-4a916ba155f1} <Debug> TCPHandler: Processed in 0.010398718 sec. | ||
| 417 | 2024.11.07 23:40:15.845898 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 418 | 2024.11.07 23:40:15.846169 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativei64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 419 | 2024.11.07 23:40:15.847245 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 420 | 2024.11.07 23:40:15.851622 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} <Debug> oximeter.measurements_cumulativei64 (ba2b6b82-c51d-4610-b636-4dd79bb073b6): Loading data parts | ||
| 421 | 2024.11.07 23:40:15.851904 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} <Debug> oximeter.measurements_cumulativei64 (ba2b6b82-c51d-4610-b636-4dd79bb073b6): There are no data parts | ||
| 422 | 2024.11.07 23:40:15.855317 [ 197785 ] {c13322a9-baf5-4fd2-9e77-ad8b5062f586} <Debug> TCPHandler: Processed in 0.009564378 sec. | ||
| 423 | 2024.11.07 23:40:15.856129 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 424 | 2024.11.07 23:40:15.856394 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 425 | 2024.11.07 23:40:15.856445 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 426 | 2024.11.07 23:40:15.862924 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} <Debug> oximeter.measurements_cumulativeu64 (20a84a2c-3297-4bdd-b0bf-37ffe42eff2a): Loading data parts | ||
| 427 | 2024.11.07 23:40:15.864776 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} <Debug> oximeter.measurements_cumulativeu64 (20a84a2c-3297-4bdd-b0bf-37ffe42eff2a): There are no data parts | ||
| 428 | 2024.11.07 23:40:15.868349 [ 197793 ] {b065529b-513b-4eaf-a23d-1d635592761c} <Debug> TCPHandler: Processed in 0.01237086 sec. | ||
| 429 | 2024.11.07 23:40:15.871585 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 430 | 2024.11.07 23:40:15.871877 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 431 | 2024.11.07 23:40:15.871934 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 432 | 2024.11.07 23:40:15.876839 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} <Debug> oximeter.measurements_cumulativef32 (e2e56c78-cef1-4eb3-9ac9-de36ad534543): Loading data parts | ||
| 433 | 2024.11.07 23:40:15.877056 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} <Debug> oximeter.measurements_cumulativef32 (e2e56c78-cef1-4eb3-9ac9-de36ad534543): There are no data parts | ||
| 434 | 2024.11.07 23:40:15.880446 [ 197785 ] {b60d6d93-a305-400e-885e-c4b46d09d72c} <Debug> TCPHandler: Processed in 0.009036167 sec. | ||
| 435 | 2024.11.07 23:40:15.881603 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 436 | 2024.11.07 23:40:15.881857 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 437 | 2024.11.07 23:40:15.881904 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 438 | 2024.11.07 23:40:15.887105 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} <Debug> oximeter.measurements_cumulativef64 (2adbd49a-d7b0-4802-8252-fe98f47752ea): Loading data parts | ||
| 439 | 2024.11.07 23:40:15.887313 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} <Debug> oximeter.measurements_cumulativef64 (2adbd49a-d7b0-4802-8252-fe98f47752ea): There are no data parts | ||
| 440 | 2024.11.07 23:40:15.891133 [ 197793 ] {16042966-58ef-4f81-927c-38b3c4e0cffb} <Debug> TCPHandler: Processed in 0.009661827 sec. | ||
| 441 | 2024.11.07 23:40:15.892084 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 442 | 2024.11.07 23:40:15.893037 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 443 | * NOTE: Array types cannot be Nullable, see | ||
| 444 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 445 | * for more details. | ||
| 446 | * | ||
| 447 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 448 | * is unfortunate, and at this point relies on the fact that an | ||
| 449 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 450 | * to figure out another way to represent missing samples here. | ||
| 451 | */ | ||
| 452 | 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) | ||
| 453 | 2024.11.07 23:40:15.893097 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 454 | 2024.11.07 23:40:15.898284 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} <Debug> oximeter.measurements_histogrami8 (52e3c5d1-7501-4c42-82c3-938bf0543914): Loading data parts | ||
| 455 | 2024.11.07 23:40:15.898471 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} <Debug> oximeter.measurements_histogrami8 (52e3c5d1-7501-4c42-82c3-938bf0543914): There are no data parts | ||
| 456 | 2024.11.07 23:40:15.902294 [ 197785 ] {68e1ed29-0a56-4f73-8299-39cde8f4738f} <Debug> TCPHandler: Processed in 0.010334078 sec. | ||
| 457 | 2024.11.07 23:40:15.903404 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 458 | 2024.11.07 23:40:15.903746 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 459 | 2024.11.07 23:40:15.903802 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 460 | 2024.11.07 23:40:15.914023 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} <Debug> oximeter.measurements_histogramu8 (5fe087a5-de3d-40cd-bc22-721d3dae9878): Loading data parts | ||
| 461 | 2024.11.07 23:40:15.914244 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} <Debug> oximeter.measurements_histogramu8 (5fe087a5-de3d-40cd-bc22-721d3dae9878): There are no data parts | ||
| 462 | 2024.11.07 23:40:15.918126 [ 197793 ] {a5eb92f5-cf5a-46c4-a1e2-749a37c1b002} <Debug> TCPHandler: Processed in 0.014828672 sec. | ||
| 463 | 2024.11.07 23:40:15.919135 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 464 | 2024.11.07 23:40:15.919500 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 465 | 2024.11.07 23:40:15.919575 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 466 | 2024.11.07 23:40:15.928695 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} <Debug> oximeter.measurements_histogrami16 (e76b822d-644c-46cc-a348-e83ce601dfae): Loading data parts | ||
| 467 | 2024.11.07 23:40:15.929033 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} <Debug> oximeter.measurements_histogrami16 (e76b822d-644c-46cc-a348-e83ce601dfae): There are no data parts | ||
| 468 | 2024.11.07 23:40:15.933171 [ 197785 ] {bc8720dd-3642-4b8f-9256-a0ed4c9ca220} <Debug> TCPHandler: Processed in 0.014192221 sec. | ||
| 469 | 2024.11.07 23:40:15.934207 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 470 | 2024.11.07 23:40:15.935289 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 471 | 2024.11.07 23:40:15.935365 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 472 | 2024.11.07 23:40:15.940836 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} <Debug> oximeter.measurements_histogramu16 (73caee0b-be3c-4d2c-b7bc-8425a651232f): Loading data parts | ||
| 473 | 2024.11.07 23:40:15.941570 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} <Debug> oximeter.measurements_histogramu16 (73caee0b-be3c-4d2c-b7bc-8425a651232f): There are no data parts | ||
| 474 | 2024.11.07 23:40:15.944965 [ 197793 ] {1f0d7ba1-bb45-4e1f-ba36-dfbeb4df2052} <Debug> TCPHandler: Processed in 0.010908099 sec. | ||
| 475 | 2024.11.07 23:40:15.947963 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 476 | 2024.11.07 23:40:15.948350 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 477 | 2024.11.07 23:40:15.948416 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 478 | 2024.11.07 23:40:15.954162 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} <Debug> oximeter.measurements_histogrami32 (4ffbc0aa-a52c-4eeb-99c0-04cbf4805284): Loading data parts | ||
| 479 | 2024.11.07 23:40:15.954409 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} <Debug> oximeter.measurements_histogrami32 (4ffbc0aa-a52c-4eeb-99c0-04cbf4805284): There are no data parts | ||
| 480 | 2024.11.07 23:40:15.958455 [ 197785 ] {ad9b585c-5c4c-45d4-9743-5bcda931b862} <Debug> TCPHandler: Processed in 0.010651639 sec. | ||
| 481 | 2024.11.07 23:40:15.959405 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 482 | 2024.11.07 23:40:15.960635 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 483 | 2024.11.07 23:40:15.960707 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 484 | 2024.11.07 23:40:15.966847 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} <Debug> oximeter.measurements_histogramu32 (148eef67-95e3-4719-b416-452f78e2282b): Loading data parts | ||
| 485 | 2024.11.07 23:40:15.969734 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} <Debug> oximeter.measurements_histogramu32 (148eef67-95e3-4719-b416-452f78e2282b): There are no data parts | ||
| 486 | 2024.11.07 23:40:15.974280 [ 197793 ] {4059d793-9e8b-4d21-a1ac-70a772fcce84} <Debug> TCPHandler: Processed in 0.015038782 sec. | ||
| 487 | 2024.11.07 23:40:15.975240 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 488 | 2024.11.07 23:40:15.975598 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 489 | 2024.11.07 23:40:15.975658 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 490 | 2024.11.07 23:40:15.980785 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} <Debug> oximeter.measurements_histogrami64 (f9b640cf-4108-41c2-9748-a6816191a31a): Loading data parts | ||
| 491 | 2024.11.07 23:40:15.981216 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} <Debug> oximeter.measurements_histogrami64 (f9b640cf-4108-41c2-9748-a6816191a31a): There are no data parts | ||
| 492 | 2024.11.07 23:40:15.985439 [ 197785 ] {d8f136e6-67b8-4623-89f6-a88cbcca361c} <Debug> TCPHandler: Processed in 0.010357258 sec. | ||
| 493 | 2024.11.07 23:40:15.986506 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 494 | 2024.11.07 23:40:15.986842 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 495 | 2024.11.07 23:40:15.986898 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 496 | 2024.11.07 23:40:15.992485 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} <Debug> oximeter.measurements_histogramu64 (275cca0f-76db-400b-b433-ef4737ab92ec): Loading data parts | ||
| 497 | 2024.11.07 23:40:15.992681 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} <Debug> oximeter.measurements_histogramu64 (275cca0f-76db-400b-b433-ef4737ab92ec): There are no data parts | ||
| 498 | 2024.11.07 23:40:15.997449 [ 197793 ] {7ed6ee99-7021-455c-bfb8-ac454efd9bb4} <Debug> TCPHandler: Processed in 0.011071569 sec. | ||
| 499 | 2024.11.07 23:40:16.000976 [ 197022 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 386.55 MiB, peak 386.55 MiB, free memory in arenas 17.75 MiB, will set to 383.31 MiB (RSS), difference: -3.25 MiB | ||
| 500 | 2024.11.07 23:40:16.033882 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 501 | 2024.11.07 23:40:16.034230 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 502 | 2024.11.07 23:40:16.034293 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 503 | 2024.11.07 23:40:16.038260 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} <Debug> oximeter.measurements_histogramf32 (f695c85a-68e3-41e2-8755-51edec5d47a4): Loading data parts | ||
| 504 | 2024.11.07 23:40:16.038500 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} <Debug> oximeter.measurements_histogramf32 (f695c85a-68e3-41e2-8755-51edec5d47a4): There are no data parts | ||
| 505 | 2024.11.07 23:40:16.046783 [ 197785 ] {9873a87c-e2be-4ec1-b8ba-bcfa994ec920} <Debug> TCPHandler: Processed in 0.013078551 sec. | ||
| 506 | 2024.11.07 23:40:16.052072 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 507 | 2024.11.07 23:40:16.052424 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 508 | 2024.11.07 23:40:16.052492 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 509 | 2024.11.07 23:40:16.058119 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} <Debug> oximeter.measurements_histogramf64 (07486bff-bfe4-4ad2-bbab-8f418b24c3de): Loading data parts | ||
| 510 | 2024.11.07 23:40:16.063425 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} <Debug> oximeter.measurements_histogramf64 (07486bff-bfe4-4ad2-bbab-8f418b24c3de): There are no data parts | ||
| 511 | 2024.11.07 23:40:16.071703 [ 197793 ] {7e6bd82b-c07f-42c6-b491-9f6fe3a2fbd0} <Debug> TCPHandler: Processed in 0.019802726 sec. | ||
| 512 | 2024.11.07 23:40:16.073430 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 513 | 2024.11.07 23:40:16.073751 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} <Debug> executeQuery: (from [::1]:56448) /* The field tables store named dimensions of each timeseries. | ||
| 514 | * | ||
| 515 | * As with the measurement tables, there is one field table for each field data | ||
| 516 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 517 | * this behavior **must not** be relied upon for query correctness. | ||
| 518 | * | ||
| 519 | * The index for the fields differs from the measurements, however. Rows are | ||
| 520 | * sorted by timeseries name, then field name, field value, and finally | ||
| 521 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 522 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 523 | * usually then used to look up measurements. | ||
| 524 | * | ||
| 525 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 526 | * timeseries name and then key, since it would improve lookups where one | ||
| 527 | * already has the key. Realistically though, these tables are quite small and | ||
| 528 | * so performance benefits will be low in absolute terms. | ||
| 529 | * | ||
| 530 | * TTL: We use a materialized column to expire old field table records. This | ||
| 531 | * column is generated automatically by the database whenever a new row is | ||
| 532 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 533 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 534 | * record will remain during a deduplication, which will have the last | ||
| 535 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 536 | * measurement tables. | ||
| 537 | */ | ||
| 538 | 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) | ||
| 539 | 2024.11.07 23:40:16.073814 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 540 | 2024.11.07 23:40:16.078993 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} <Debug> oximeter.fields_bool (85f85151-cd9e-41ca-bb2f-4a9444476e4c): Loading data parts | ||
| 541 | 2024.11.07 23:40:16.079704 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} <Debug> oximeter.fields_bool (85f85151-cd9e-41ca-bb2f-4a9444476e4c): There are no data parts | ||
| 542 | 2024.11.07 23:40:16.091091 [ 197785 ] {3dd60c64-9ed4-4058-89dc-197ed71e1fbb} <Debug> TCPHandler: Processed in 0.017830104 sec. | ||
| 543 | 2024.11.07 23:40:16.092199 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 544 | 2024.11.07 23:40:16.092411 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 545 | 2024.11.07 23:40:16.092452 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 546 | 2024.11.07 23:40:16.102768 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} <Debug> oximeter.fields_i8 (f83230bc-37b4-41d9-b028-5ca8a4d0df66): Loading data parts | ||
| 547 | 2024.11.07 23:40:16.105311 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} <Debug> oximeter.fields_i8 (f83230bc-37b4-41d9-b028-5ca8a4d0df66): There are no data parts | ||
| 548 | 2024.11.07 23:40:16.110488 [ 197793 ] {2e3792a5-6668-4b11-b7cc-71b5c42ee143} <Debug> TCPHandler: Processed in 0.018442955 sec. | ||
| 549 | 2024.11.07 23:40:16.112268 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 550 | 2024.11.07 23:40:16.112570 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 551 | 2024.11.07 23:40:16.112628 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 552 | 2024.11.07 23:40:16.119294 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} <Debug> oximeter.fields_u8 (ad009b0d-559b-465f-8176-7e7b89654ff1): Loading data parts | ||
| 553 | 2024.11.07 23:40:16.119518 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} <Debug> oximeter.fields_u8 (ad009b0d-559b-465f-8176-7e7b89654ff1): There are no data parts | ||
| 554 | 2024.11.07 23:40:16.123498 [ 197785 ] {add710ac-724a-483e-8d07-361573f5b181} <Debug> TCPHandler: Processed in 0.011406799 sec. | ||
| 555 | 2024.11.07 23:40:16.124395 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 556 | 2024.11.07 23:40:16.125166 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 557 | 2024.11.07 23:40:16.125215 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 558 | 2024.11.07 23:40:16.130626 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} <Debug> oximeter.fields_i16 (af709981-b0e0-41d4-91cf-7a3c90d3bb01): Loading data parts | ||
| 559 | 2024.11.07 23:40:16.130910 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} <Debug> oximeter.fields_i16 (af709981-b0e0-41d4-91cf-7a3c90d3bb01): There are no data parts | ||
| 560 | 2024.11.07 23:40:16.134690 [ 197793 ] {0ccfd4c9-ffcf-47f0-aa23-a031689b2583} <Debug> TCPHandler: Processed in 0.010481838 sec. | ||
| 561 | 2024.11.07 23:40:16.135313 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 562 | 2024.11.07 23:40:16.135595 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 563 | 2024.11.07 23:40:16.135644 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 564 | 2024.11.07 23:40:16.141448 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} <Debug> oximeter.fields_u16 (86ed507b-905d-4270-ad83-28e4a65549f1): Loading data parts | ||
| 565 | 2024.11.07 23:40:16.143053 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} <Debug> oximeter.fields_u16 (86ed507b-905d-4270-ad83-28e4a65549f1): There are no data parts | ||
| 566 | 2024.11.07 23:40:16.149368 [ 197785 ] {1d9dd80a-36f7-4bf2-9977-e3dcad618068} <Debug> TCPHandler: Processed in 0.014195201 sec. | ||
| 567 | 2024.11.07 23:40:16.150219 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 568 | 2024.11.07 23:40:16.150486 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 569 | 2024.11.07 23:40:16.150544 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 570 | 2024.11.07 23:40:16.155839 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} <Debug> oximeter.fields_i32 (ce079efc-e6d7-4467-9c5b-db7f4984f430): Loading data parts | ||
| 571 | 2024.11.07 23:40:16.156639 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} <Debug> oximeter.fields_i32 (ce079efc-e6d7-4467-9c5b-db7f4984f430): There are no data parts | ||
| 572 | 2024.11.07 23:40:16.160662 [ 197793 ] {e70ce3a1-8c1f-4610-8580-831a96119cec} <Debug> TCPHandler: Processed in 0.010602118 sec. | ||
| 573 | 2024.11.07 23:40:16.161589 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 574 | 2024.11.07 23:40:16.161906 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 575 | 2024.11.07 23:40:16.163135 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 576 | 2024.11.07 23:40:16.173064 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} <Debug> oximeter.fields_u32 (26a87685-22e6-46da-950d-7028f3e3a4e6): Loading data parts | ||
| 577 | 2024.11.07 23:40:16.173294 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} <Debug> oximeter.fields_u32 (26a87685-22e6-46da-950d-7028f3e3a4e6): There are no data parts | ||
| 578 | 2024.11.07 23:40:16.181417 [ 197785 ] {bb2df688-5b30-4b60-90df-9a9442bf7c59} <Debug> TCPHandler: Processed in 0.020009086 sec. | ||
| 579 | 2024.11.07 23:40:16.182183 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 580 | 2024.11.07 23:40:16.182444 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 581 | 2024.11.07 23:40:16.182496 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 582 | 2024.11.07 23:40:16.187752 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} <Debug> oximeter.fields_i64 (74ebc289-4ad0-47ff-855a-f3559129f410): Loading data parts | ||
| 583 | 2024.11.07 23:40:16.187994 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} <Debug> oximeter.fields_i64 (74ebc289-4ad0-47ff-855a-f3559129f410): There are no data parts | ||
| 584 | 2024.11.07 23:40:16.191628 [ 197793 ] {6c124fc6-a2e4-4e57-a029-cd9338ec8034} <Debug> TCPHandler: Processed in 0.009620777 sec. | ||
| 585 | 2024.11.07 23:40:16.192297 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 586 | 2024.11.07 23:40:16.192590 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 587 | 2024.11.07 23:40:16.192708 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 588 | 2024.11.07 23:40:16.201404 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} <Debug> oximeter.fields_u64 (c21fbf9a-7bf0-46d9-b828-1940c6b5c0f3): Loading data parts | ||
| 589 | 2024.11.07 23:40:16.201874 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} <Debug> oximeter.fields_u64 (c21fbf9a-7bf0-46d9-b828-1940c6b5c0f3): There are no data parts | ||
| 590 | 2024.11.07 23:40:16.207258 [ 197785 ] {b53c1aeb-5795-4897-9924-6d116dbeaebe} <Debug> TCPHandler: Processed in 0.015081572 sec. | ||
| 591 | 2024.11.07 23:40:16.207981 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 592 | 2024.11.07 23:40:16.208249 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 593 | 2024.11.07 23:40:16.208301 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 594 | 2024.11.07 23:40:16.230793 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} <Debug> oximeter.fields_ipaddr (f9d77be4-bc72-4879-ae2d-5cb81e012de3): Loading data parts | ||
| 595 | 2024.11.07 23:40:16.232238 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} <Debug> oximeter.fields_ipaddr (f9d77be4-bc72-4879-ae2d-5cb81e012de3): There are no data parts | ||
| 596 | 2024.11.07 23:40:16.236135 [ 197793 ] {95c67162-a5ea-49d9-9368-1c2a69188107} <Debug> TCPHandler: Processed in 0.028320053 sec. | ||
| 597 | 2024.11.07 23:40:16.237252 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 598 | 2024.11.07 23:40:16.238135 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} <Debug> executeQuery: (from [::1]:56448) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 599 | 2024.11.07 23:40:16.238185 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 600 | 2024.11.07 23:40:16.255545 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} <Debug> oximeter.fields_string (11184ec1-cdd3-4590-b2cd-f281bec498df): Loading data parts | ||
| 601 | 2024.11.07 23:40:16.255792 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} <Debug> oximeter.fields_string (11184ec1-cdd3-4590-b2cd-f281bec498df): There are no data parts | ||
| 602 | 2024.11.07 23:40:16.260176 [ 197785 ] {016e0654-f6a5-4e20-98b4-4b360ae35dfd} <Debug> TCPHandler: Processed in 0.023111468 sec. | ||
| 603 | 2024.11.07 23:40:16.261224 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 604 | 2024.11.07 23:40:16.261533 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} <Debug> executeQuery: (from [::1]:56460) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 605 | 2024.11.07 23:40:16.261588 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 606 | 2024.11.07 23:40:16.266750 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} <Debug> oximeter.fields_uuid (5472167f-1b87-4fee-a144-437934962e0e): Loading data parts | ||
| 607 | 2024.11.07 23:40:16.267028 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} <Debug> oximeter.fields_uuid (5472167f-1b87-4fee-a144-437934962e0e): There are no data parts | ||
| 608 | 2024.11.07 23:40:16.271064 [ 197793 ] {10837ff9-c481-4640-98b4-a366a4029165} <Debug> TCPHandler: Processed in 0.010000428 sec. | ||
| 609 | 2024.11.07 23:40:16.275386 [ 197785 ] {} <Trace> TCP-Session: 98328ea9-8547-4f6b-be3b-4cfa60f7e76a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 610 | 2024.11.07 23:40:16.275949 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} <Debug> executeQuery: (from [::1]:56448) /* The timeseries schema table stores the extracted schema for the samples | ||
| 611 | * oximeter collects. | ||
| 612 | */ | ||
| 613 | 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) | ||
| 614 | 2024.11.07 23:40:16.277106 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 615 | 2024.11.07 23:40:16.281581 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} <Debug> oximeter.timeseries_schema (63cf8843-ba11-4bf3-9222-968fb9b50dee): Loading data parts | ||
| 616 | 2024.11.07 23:40:16.281833 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} <Debug> oximeter.timeseries_schema (63cf8843-ba11-4bf3-9222-968fb9b50dee): There are no data parts | ||
| 617 | 2024.11.07 23:40:16.285628 [ 197785 ] {e3cbab3a-78b2-458f-9113-18d76e2e1b50} <Debug> TCPHandler: Processed in 0.013317611 sec. | ||
| 618 | 2024.11.07 23:40:16.286527 [ 197793 ] {} <Trace> TCP-Session: 471cbc58-2077-4096-8a5f-ab55c6b3944a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 619 | 2024.11.07 23:40:16.286694 [ 197793 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} <Debug> executeQuery: (from [::1]:56460) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 620 | 2024.11.07 23:40:16.286801 [ 197793 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 621 | 2024.11.07 23:40:16.287666 [ 197790 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} <Trace> oximeter.version (95637719-7cd6-4375-8b6a-0074c61d457f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 622 | 2024.11.07 23:40:16.287691 [ 197790 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 164.62 GiB. | ||
| 623 | 2024.11.07 23:40:16.290760 [ 197790 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 624 | 2024.11.07 23:40:16.318931 [ 197790 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} <Trace> oximeter.version (95637719-7cd6-4375-8b6a-0074c61d457f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 625 | 2024.11.07 23:40:16.319214 [ 197793 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.032567 sec., 30.70592931495072 rows/sec., 491.29 B/sec. | ||
| 626 | 2024.11.07 23:40:16.319427 [ 197793 ] {c674e4ec-c016-4a3d-8acb-49f085d81cee} <Debug> TCPHandler: Processed in 0.033063797 sec. | ||