| 1 | 2025.11.03 21:57:09.485403 [ 141585 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2025.11.03 21:57:09.485479 [ 141585 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2025.11.03 21:57:09.540234 [ 141585 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 141585 | ||
| 4 | 2025.11.03 21:57:09.540288 [ 141585 ] {} <Information> Application: starting up | ||
| 5 | 2025.11.03 21:57:09.540302 [ 141585 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2025.11.03 21:57:09.543245 [ 141585 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2025.11.03 21:57:09.544108 [ 141585 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2025.11.03 21:57:09.544127 [ 141585 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2025.11.03 21:57:09.544165 [ 141585 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2025.11.03 21:57:09.544180 [ 141585 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2025.11.03 21:57:09.695371 [ 141585 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2025.11.03 21:57:09.695417 [ 141585 ] {} <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 | 2025.11.03 21:57:09.700634 [ 141585 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2025.11.03 21:57:09.700660 [ 141585 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2025.11.03 21:57:09.700671 [ 141585 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2025.11.03 21:57:09.700676 [ 141585 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2025.11.03 21:57:09.700705 [ 141585 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/datastore/tmp/ to store temporary data in it | ||
| 18 | 2025.11.03 21:57:09.700994 [ 141585 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2025.11.03 21:57:09.701504 [ 141585 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/config.xml' | ||
| 20 | 2025.11.03 21:57:09.702062 [ 141585 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/config.xml', performing update on configuration | ||
| 21 | 2025.11.03 21:57:09.704807 [ 141585 ] {} <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 | 2025.11.03 21:57:09.704825 [ 141585 ] {} <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 | 2025.11.03 21:57:09.704832 [ 141585 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2025.11.03 21:57:09.704879 [ 141585 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2025.11.03 21:57:09.705517 [ 141585 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2025.11.03 21:57:09.720397 [ 141585 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2025.11.03 21:57:09.721448 [ 141585 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2025.11.03 21:57:09.722130 [ 141585 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2025.11.03 21:57:09.723685 [ 141585 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/config.xml', performed update on configuration | ||
| 30 | 2025.11.03 21:57:09.725355 [ 141585 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/config.xml' | ||
| 31 | 2025.11.03 21:57:09.757146 [ 141585 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/config.xml', performing update on configuration | ||
| 32 | 2025.11.03 21:57:09.757961 [ 141585 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/config.xml', performed update on configuration | ||
| 33 | 2025.11.03 21:57:09.759933 [ 141585 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/config.xml | ||
| 34 | 2025.11.03 21:57:09.760700 [ 141585 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2025.11.03 21:57:09.761128 [ 141585 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2025.11.03 21:57:09.761461 [ 141585 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2025.11.03 21:57:09.762228 [ 141585 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2025.11.03 21:57:09.766455 [ 141585 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2025.11.03 21:57:09.766502 [ 141585 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/datastore/ | ||
| 40 | 2025.11.03 21:57:09.766872 [ 141591 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 41 | 2025.11.03 21:57:09.766895 [ 141591 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 42 | 2025.11.03 21:57:09.782330 [ 141585 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2025.11.03 21:57:09.782355 [ 141585 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.149e-05 sec | ||
| 44 | 2025.11.03 21:57:09.782364 [ 141585 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2025.11.03 21:57:09.782370 [ 141585 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2025.11.03 21:57:09.782400 [ 141585 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2025.11.03 21:57:09.782420 [ 141585 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2025.11.03 21:57:09.783374 [ 141585 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2025.11.03 21:57:09.783387 [ 141585 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2025.11.03 21:57:09.783392 [ 141585 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2025.11.03 21:57:09.783398 [ 141585 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2025.11.03 21:57:09.783406 [ 141585 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2025.11.03 21:57:09.783415 [ 141585 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 54 | 2025.11.03 21:57:09.785365 [ 141585 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2025.11.03 21:57:09.785382 [ 141585 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2025.11.03 21:57:09.785403 [ 141585 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 57 | 2025.11.03 21:57:09.785568 [ 141585 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2025.11.03 21:57:09.790352 [ 141585 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2025.11.03 21:57:09.792147 [ 141585 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2025.11.03 21:57:09.792160 [ 141585 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2025.11.03 21:57:09.792168 [ 141585 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2025.11.03 21:57:09.792174 [ 141585 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2025.11.03 21:57:09.792182 [ 141585 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2025.11.03 21:57:09.805617 [ 141585 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2025.11.03 21:57:09.815468 [ 141585 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2025.11.03 21:57:09.815496 [ 141585 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.111e-05 sec | ||
| 67 | 2025.11.03 21:57:09.815501 [ 141585 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2025.11.03 21:57:09.815505 [ 141585 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2025.11.03 21:57:09.815533 [ 141585 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2025.11.03 21:57:09.815640 [ 141585 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-b53d2be01df229b5-test_device_token_request_ttl.141545.1-clickhouse-p3orBb/datastore/user_defined/ | ||
| 71 | 2025.11.03 21:57:09.815667 [ 141585 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2025.11.03 21:57:09.815671 [ 141585 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2025.11.03 21:57:09.815693 [ 141585 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2025.11.03 21:57:09.815701 [ 141585 ] {} <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 | 2025.11.03 21:57:09.815786 [ 141585 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 35099 | ||
| 76 | 2025.11.03 21:57:09.815834 [ 141585 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40761 | ||
| 77 | 2025.11.03 21:57:09.816021 [ 141585 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 46497 | ||
| 78 | 2025.11.03 21:57:09.816067 [ 141585 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 36529 | ||
| 79 | 2025.11.03 21:57:09.816091 [ 141585 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2025.11.03 21:57:09.817033 [ 141585 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.64 MiB, peak 20.64 MiB, free memory in arenas 2.50 MiB, will set to 381.51 MiB (RSS), difference: 360.87 MiB | ||
| 81 | 2025.11.03 21:57:09.817637 [ 141585 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.1651e-05 sec. | ||
| 82 | 2025.11.03 21:57:09.818133 [ 141585 ] {} <Information> Application: Listening for http://[::1]:35099 | ||
| 83 | 2025.11.03 21:57:09.818186 [ 141585 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:40761 | ||
| 84 | 2025.11.03 21:57:09.818264 [ 141585 ] {} <Information> Application: Listening for http://127.0.0.1:46497 | ||
| 85 | 2025.11.03 21:57:09.818366 [ 141585 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:36529 | ||
| 86 | 2025.11.03 21:57:09.818383 [ 141585 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2025.11.03 21:57:10.759717 [ 141587 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51204 | ||
| 88 | 2025.11.03 21:57:10.759996 [ 141587 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2025.11.03 21:57:10.760053 [ 141587 ] {} <Debug> TCP-Session: 1ecf3929-ef02-4fe6-a523-f83be1662baf Authenticating user 'default' from [::1]:51204 | ||
| 90 | 2025.11.03 21:57:10.760073 [ 141587 ] {} <Debug> TCP-Session: 1ecf3929-ef02-4fe6-a523-f83be1662baf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2025.11.03 21:57:10.760080 [ 141587 ] {} <Debug> TCP-Session: 1ecf3929-ef02-4fe6-a523-f83be1662baf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2025.11.03 21:57:10.760167 [ 141587 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2025.11.03 21:57:10.760192 [ 141587 ] {} <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 | 2025.11.03 21:57:10.760201 [ 141587 ] {} <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 | 2025.11.03 21:57:10.762109 [ 141588 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51206 | ||
| 96 | 2025.11.03 21:57:10.762280 [ 141589 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51208 | ||
| 97 | 2025.11.03 21:57:10.762871 [ 141588 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 98 | 2025.11.03 21:57:10.762906 [ 141588 ] {} <Debug> TCP-Session: 20ec4d52-b546-42dd-a1c6-de8e55a88503 Authenticating user 'default' from [::1]:51206 | ||
| 99 | 2025.11.03 21:57:10.762920 [ 141588 ] {} <Debug> TCP-Session: 20ec4d52-b546-42dd-a1c6-de8e55a88503 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 100 | 2025.11.03 21:57:10.762927 [ 141588 ] {} <Debug> TCP-Session: 20ec4d52-b546-42dd-a1c6-de8e55a88503 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 101 | 2025.11.03 21:57:10.763082 [ 141589 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 102 | 2025.11.03 21:57:10.763114 [ 141589 ] {} <Debug> TCP-Session: 78c4393c-91bf-47f6-a03a-6838a10b2cc5 Authenticating user 'default' from [::1]:51208 | ||
| 103 | 2025.11.03 21:57:10.763124 [ 141589 ] {} <Debug> TCP-Session: 78c4393c-91bf-47f6-a03a-6838a10b2cc5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 104 | 2025.11.03 21:57:10.763130 [ 141589 ] {} <Debug> TCP-Session: 78c4393c-91bf-47f6-a03a-6838a10b2cc5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2025.11.03 21:57:10.769717 [ 141858 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51212 | ||
| 106 | 2025.11.03 21:57:10.769837 [ 141858 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2025.11.03 21:57:10.769869 [ 141858 ] {} <Debug> TCP-Session: ae1c91ae-ef99-4f74-963b-e59230b991d3 Authenticating user 'default' from [::1]:51212 | ||
| 108 | 2025.11.03 21:57:10.769893 [ 141858 ] {} <Debug> TCP-Session: ae1c91ae-ef99-4f74-963b-e59230b991d3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2025.11.03 21:57:10.769901 [ 141858 ] {} <Debug> TCP-Session: ae1c91ae-ef99-4f74-963b-e59230b991d3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2025.11.03 21:57:10.770359 [ 141859 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51214 | ||
| 111 | 2025.11.03 21:57:10.770506 [ 141859 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 112 | 2025.11.03 21:57:10.770555 [ 141860 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51216 | ||
| 113 | 2025.11.03 21:57:10.770579 [ 141861 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51218 | ||
| 114 | 2025.11.03 21:57:10.770569 [ 141859 ] {} <Debug> TCP-Session: 575c9d6c-0dc9-41e3-8420-c29febc97b90 Authenticating user 'default' from [::1]:51214 | ||
| 115 | 2025.11.03 21:57:10.770622 [ 141859 ] {} <Debug> TCP-Session: 575c9d6c-0dc9-41e3-8420-c29febc97b90 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 116 | 2025.11.03 21:57:10.770630 [ 141859 ] {} <Debug> TCP-Session: 575c9d6c-0dc9-41e3-8420-c29febc97b90 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 117 | 2025.11.03 21:57:10.770700 [ 141860 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 118 | 2025.11.03 21:57:10.772578 [ 141860 ] {} <Debug> TCP-Session: ce645094-bccc-4d70-a385-a21c665a2e74 Authenticating user 'default' from [::1]:51216 | ||
| 119 | 2025.11.03 21:57:10.772594 [ 141860 ] {} <Debug> TCP-Session: ce645094-bccc-4d70-a385-a21c665a2e74 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 120 | 2025.11.03 21:57:10.772600 [ 141860 ] {} <Debug> TCP-Session: ce645094-bccc-4d70-a385-a21c665a2e74 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 121 | 2025.11.03 21:57:10.770801 [ 141861 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 122 | 2025.11.03 21:57:10.772693 [ 141861 ] {} <Debug> TCP-Session: 595fb6b8-3236-4f43-9db7-df90f918552a Authenticating user 'default' from [::1]:51218 | ||
| 123 | 2025.11.03 21:57:10.772915 [ 141861 ] {} <Debug> TCP-Session: 595fb6b8-3236-4f43-9db7-df90f918552a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 124 | 2025.11.03 21:57:10.772924 [ 141861 ] {} <Debug> TCP-Session: 595fb6b8-3236-4f43-9db7-df90f918552a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 125 | 2025.11.03 21:57:10.774143 [ 141857 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51210 | ||
| 126 | 2025.11.03 21:57:10.774260 [ 141857 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2025.11.03 21:57:10.774286 [ 141857 ] {} <Debug> TCP-Session: 617d75f7-b2ec-4892-bc88-0f3f4f7886e7 Authenticating user 'default' from [::1]:51210 | ||
| 128 | 2025.11.03 21:57:10.774297 [ 141857 ] {} <Debug> TCP-Session: 617d75f7-b2ec-4892-bc88-0f3f4f7886e7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2025.11.03 21:57:10.774303 [ 141857 ] {} <Debug> TCP-Session: 617d75f7-b2ec-4892-bc88-0f3f4f7886e7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2025.11.03 21:57:17.293735 [ 141826 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 131 | 2025.11.03 21:57:17.293800 [ 141826 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 132 | 2025.11.03 21:57:17.295907 [ 141830 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1948 entries to flush up to offset 1948 | ||
| 133 | 2025.11.03 21:57:17.295966 [ 141830 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 134 | 2025.11.03 21:57:17.296943 [ 141830 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 135 | 2025.11.03 21:57:17.300552 [ 141830 ] {} <Debug> system.asynchronous_metric_log (e26d77c9-a200-4a5e-a1ab-7e68ae547c09): Loading data parts | ||
| 136 | 2025.11.03 21:57:17.301589 [ 141830 ] {} <Debug> system.asynchronous_metric_log (e26d77c9-a200-4a5e-a1ab-7e68ae547c09): There are no data parts | ||
| 137 | 2025.11.03 21:57:17.307995 [ 141830 ] {} <Trace> system.asynchronous_metric_log (e26d77c9-a200-4a5e-a1ab-7e68ae547c09): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 138 | 2025.11.03 21:57:17.308050 [ 141830 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.86 GiB. | ||
| 139 | 2025.11.03 21:57:17.309724 [ 141826 ] {} <Debug> system.metric_log (f308612b-a19b-4ef3-9159-4470ef51c09b): Loading data parts | ||
| 140 | 2025.11.03 21:57:17.316262 [ 141830 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 141 | 2025.11.03 21:57:17.317770 [ 141826 ] {} <Debug> system.metric_log (f308612b-a19b-4ef3-9159-4470ef51c09b): There are no data parts | ||
| 142 | 2025.11.03 21:57:17.318999 [ 141830 ] {} <Trace> system.asynchronous_metric_log (e26d77c9-a200-4a5e-a1ab-7e68ae547c09): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 143 | 2025.11.03 21:57:17.319228 [ 141830 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1948 | ||
| 144 | 2025.11.03 21:57:17.347068 [ 141826 ] {} <Trace> system.metric_log (f308612b-a19b-4ef3-9159-4470ef51c09b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 145 | 2025.11.03 21:57:17.347121 [ 141826 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.86 GiB. | ||
| 146 | 2025.11.03 21:57:17.355020 [ 141826 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 147 | 2025.11.03 21:57:17.356009 [ 141826 ] {} <Trace> system.metric_log (f308612b-a19b-4ef3-9159-4470ef51c09b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 148 | 2025.11.03 21:57:17.358939 [ 141826 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 149 | 2025.11.03 21:57:18.001148 [ 141832 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 387.14 MiB, peak 391.14 MiB, free memory in arenas 18.26 MiB, will set to 392.27 MiB (RSS), difference: 5.13 MiB | ||
| 150 | 2025.11.03 21:57:18.867377 [ 142235 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51222 | ||
| 151 | 2025.11.03 21:57:18.867485 [ 142235 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 152 | 2025.11.03 21:57:18.867512 [ 142235 ] {} <Debug> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Authenticating user 'default' from [::1]:51222 | ||
| 153 | 2025.11.03 21:57:18.867527 [ 142235 ] {} <Debug> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2025.11.03 21:57:18.867534 [ 142235 ] {} <Debug> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 155 | 2025.11.03 21:57:18.872578 [ 142236 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51224 | ||
| 156 | 2025.11.03 21:57:18.872957 [ 142237 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51226 | ||
| 157 | 2025.11.03 21:57:18.873703 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 158 | 2025.11.03 21:57:18.874037 [ 142235 ] {cd5ab8fc-cee6-4568-a0d0-32ef1f486ee5} <Debug> executeQuery: (from [::1]:51222) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 159 | 2025.11.03 21:57:18.874347 [ 142237 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 160 | 2025.11.03 21:57:18.874390 [ 142237 ] {} <Debug> TCP-Session: ad7b34f1-d31f-4472-9a65-0ed73db6cad3 Authenticating user 'default' from [::1]:51226 | ||
| 161 | 2025.11.03 21:57:18.874410 [ 142237 ] {} <Debug> TCP-Session: ad7b34f1-d31f-4472-9a65-0ed73db6cad3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 162 | 2025.11.03 21:57:18.874424 [ 142237 ] {} <Debug> TCP-Session: ad7b34f1-d31f-4472-9a65-0ed73db6cad3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 163 | 2025.11.03 21:57:18.874850 [ 142235 ] {cd5ab8fc-cee6-4568-a0d0-32ef1f486ee5} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:51222) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 164 | |||
| 165 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 166 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 167 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 168 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 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 | ||
| 171 | 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 | ||
| 172 | 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 | ||
| 173 | 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 | ||
| 174 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 175 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 176 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 177 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 178 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 179 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 180 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 181 | 16. ? @ 0x00007f6eb8c1eac3 in ? | ||
| 182 | 17. ? @ 0x00007f6eb8cb08c0 in ? | ||
| 183 | |||
| 184 | 2025.11.03 21:57:18.874974 [ 142235 ] {cd5ab8fc-cee6-4568-a0d0-32ef1f486ee5} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 185 | |||
| 186 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 187 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 188 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 189 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 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 | ||
| 192 | 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 | ||
| 193 | 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 | ||
| 194 | 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 | ||
| 195 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 197 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 198 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 199 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 200 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 201 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 202 | 16. ? @ 0x00007f6eb8c1eac3 in ? | ||
| 203 | 17. ? @ 0x00007f6eb8cb08c0 in ? | ||
| 204 | |||
| 205 | 2025.11.03 21:57:18.875024 [ 142235 ] {cd5ab8fc-cee6-4568-a0d0-32ef1f486ee5} <Debug> TCPHandler: Processed in 0.00152792 sec. | ||
| 206 | 2025.11.03 21:57:18.875057 [ 142236 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 207 | 2025.11.03 21:57:18.875080 [ 142236 ] {} <Debug> TCP-Session: 1d320899-bf51-4a83-8090-f38bd84f3013 Authenticating user 'default' from [::1]:51224 | ||
| 208 | 2025.11.03 21:57:18.875090 [ 142236 ] {} <Debug> TCP-Session: 1d320899-bf51-4a83-8090-f38bd84f3013 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 209 | 2025.11.03 21:57:18.875097 [ 142236 ] {} <Debug> TCP-Session: 1d320899-bf51-4a83-8090-f38bd84f3013 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 210 | 2025.11.03 21:57:18.881537 [ 142236 ] {} <Trace> TCP-Session: 1d320899-bf51-4a83-8090-f38bd84f3013 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 211 | 2025.11.03 21:57:18.881814 [ 142236 ] {b8d69ef1-1834-4fca-afa5-2eafbc422c38} <Debug> executeQuery: (from [::1]:51224) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 212 | 2025.11.03 21:57:18.882113 [ 142236 ] {b8d69ef1-1834-4fca-afa5-2eafbc422c38} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:51224) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 213 | |||
| 214 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 215 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 216 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 217 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 218 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 219 | 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 | ||
| 220 | 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 | ||
| 221 | 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 | ||
| 222 | 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 | ||
| 223 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 224 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 225 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 226 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 227 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 228 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 229 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 230 | 16. ? @ 0x00007f6eb8c1eac3 in ? | ||
| 231 | 17. ? @ 0x00007f6eb8cb08c0 in ? | ||
| 232 | |||
| 233 | 2025.11.03 21:57:18.882359 [ 142236 ] {b8d69ef1-1834-4fca-afa5-2eafbc422c38} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 234 | |||
| 235 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 236 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 237 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 238 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 239 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 240 | 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 | ||
| 241 | 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 | ||
| 242 | 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 | ||
| 243 | 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 | ||
| 244 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 245 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 246 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 247 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 248 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 249 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 250 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 251 | 16. ? @ 0x00007f6eb8c1eac3 in ? | ||
| 252 | 17. ? @ 0x00007f6eb8cb08c0 in ? | ||
| 253 | |||
| 254 | 2025.11.03 21:57:18.882421 [ 142236 ] {b8d69ef1-1834-4fca-afa5-2eafbc422c38} <Debug> TCPHandler: Processed in 0.00108084 sec. | ||
| 255 | 2025.11.03 21:57:18.885371 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 256 | 2025.11.03 21:57:18.885517 [ 142235 ] {383e75a1-0a33-48cf-bd9a-d86240897765} <Debug> executeQuery: (from [::1]:51222) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 257 | 2025.11.03 21:57:18.885555 [ 142235 ] {383e75a1-0a33-48cf-bd9a-d86240897765} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 258 | 2025.11.03 21:57:18.894408 [ 142235 ] {383e75a1-0a33-48cf-bd9a-d86240897765} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 259 | 2025.11.03 21:57:18.894440 [ 142235 ] {383e75a1-0a33-48cf-bd9a-d86240897765} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00010146 sec | ||
| 260 | 2025.11.03 21:57:18.894449 [ 142235 ] {383e75a1-0a33-48cf-bd9a-d86240897765} <Trace> ReferentialDeps: No tables | ||
| 261 | 2025.11.03 21:57:18.894456 [ 142235 ] {383e75a1-0a33-48cf-bd9a-d86240897765} <Trace> LoadingDeps: No tables | ||
| 262 | 2025.11.03 21:57:18.894493 [ 142235 ] {383e75a1-0a33-48cf-bd9a-d86240897765} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 263 | 2025.11.03 21:57:18.894592 [ 142235 ] {383e75a1-0a33-48cf-bd9a-d86240897765} <Debug> TCPHandler: Processed in 0.009322011 sec. | ||
| 264 | 2025.11.03 21:57:18.896337 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 265 | 2025.11.03 21:57:18.897575 [ 142235 ] {84b23723-2c6c-43f7-9062-fa0d60dac8c2} <Debug> executeQuery: (from [::1]:51222) /* The version table contains metadata about the `oximeter` database */ | ||
| 266 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 267 | 2025.11.03 21:57:18.897629 [ 142235 ] {84b23723-2c6c-43f7-9062-fa0d60dac8c2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 268 | 2025.11.03 21:57:18.898412 [ 142239 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51230 | ||
| 269 | 2025.11.03 21:57:18.898530 [ 142239 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 270 | 2025.11.03 21:57:18.898563 [ 142239 ] {} <Debug> TCP-Session: 3f46c043-7ada-4977-92a3-c173e1833fea Authenticating user 'default' from [::1]:51230 | ||
| 271 | 2025.11.03 21:57:18.898579 [ 142239 ] {} <Debug> TCP-Session: 3f46c043-7ada-4977-92a3-c173e1833fea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 272 | 2025.11.03 21:57:18.898586 [ 142239 ] {} <Debug> TCP-Session: 3f46c043-7ada-4977-92a3-c173e1833fea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2025.11.03 21:57:18.918580 [ 142238 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51228 | ||
| 274 | 2025.11.03 21:57:18.918711 [ 142238 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 275 | 2025.11.03 21:57:18.918739 [ 142238 ] {} <Debug> TCP-Session: b6a24a80-0c5d-4861-bdd0-26d15c22bbcd Authenticating user 'default' from [::1]:51228 | ||
| 276 | 2025.11.03 21:57:18.918757 [ 142238 ] {} <Debug> TCP-Session: b6a24a80-0c5d-4861-bdd0-26d15c22bbcd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2025.11.03 21:57:18.918765 [ 142238 ] {} <Debug> TCP-Session: b6a24a80-0c5d-4861-bdd0-26d15c22bbcd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 278 | 2025.11.03 21:57:18.919368 [ 142235 ] {84b23723-2c6c-43f7-9062-fa0d60dac8c2} <Debug> oximeter.version (1b62b654-b5fa-4c15-891c-346380626f0d): Loading data parts | ||
| 279 | 2025.11.03 21:57:18.919673 [ 142235 ] {84b23723-2c6c-43f7-9062-fa0d60dac8c2} <Debug> oximeter.version (1b62b654-b5fa-4c15-891c-346380626f0d): There are no data parts | ||
| 280 | 2025.11.03 21:57:18.923319 [ 142235 ] {84b23723-2c6c-43f7-9062-fa0d60dac8c2} <Debug> TCPHandler: Processed in 0.02716193 sec. | ||
| 281 | 2025.11.03 21:57:18.925799 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 282 | 2025.11.03 21:57:18.926130 [ 142235 ] {7f8212c1-72ef-4c98-8e3b-75c9bf1a1a41} <Debug> executeQuery: (from [::1]:51222) /* The measurement tables contain all individual samples from each timeseries. | ||
| 283 | * | ||
| 284 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 285 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 286 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 287 | * by all samples from the same timeseries. | ||
| 288 | * | ||
| 289 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 290 | * and then uses that to index quickly into the measurements tables. | ||
| 291 | */ | ||
| 292 | 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) | ||
| 293 | 2025.11.03 21:57:18.926191 [ 142235 ] {7f8212c1-72ef-4c98-8e3b-75c9bf1a1a41} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 294 | 2025.11.03 21:57:18.933783 [ 142235 ] {7f8212c1-72ef-4c98-8e3b-75c9bf1a1a41} <Debug> oximeter.measurements_bool (4da1c609-7b26-40f7-b7ac-0ec23c28448c): Loading data parts | ||
| 295 | 2025.11.03 21:57:18.934080 [ 142235 ] {7f8212c1-72ef-4c98-8e3b-75c9bf1a1a41} <Debug> oximeter.measurements_bool (4da1c609-7b26-40f7-b7ac-0ec23c28448c): There are no data parts | ||
| 296 | 2025.11.03 21:57:18.938041 [ 142235 ] {7f8212c1-72ef-4c98-8e3b-75c9bf1a1a41} <Debug> TCPHandler: Processed in 0.01329404 sec. | ||
| 297 | 2025.11.03 21:57:18.938387 [ 142241 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51234 | ||
| 298 | 2025.11.03 21:57:18.938400 [ 142243 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51238 | ||
| 299 | 2025.11.03 21:57:18.938525 [ 142241 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 300 | 2025.11.03 21:57:18.938552 [ 142241 ] {} <Debug> TCP-Session: e69a2b06-7f4c-4869-89ca-c69281d1baeb Authenticating user 'default' from [::1]:51234 | ||
| 301 | 2025.11.03 21:57:18.938574 [ 142241 ] {} <Debug> TCP-Session: e69a2b06-7f4c-4869-89ca-c69281d1baeb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 302 | 2025.11.03 21:57:18.938581 [ 142241 ] {} <Debug> TCP-Session: e69a2b06-7f4c-4869-89ca-c69281d1baeb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 303 | 2025.11.03 21:57:18.938672 [ 142243 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 304 | 2025.11.03 21:57:18.938703 [ 142243 ] {} <Debug> TCP-Session: c87d57b2-290a-410f-a6d6-78657eb098c5 Authenticating user 'default' from [::1]:51238 | ||
| 305 | 2025.11.03 21:57:18.938715 [ 142243 ] {} <Debug> TCP-Session: c87d57b2-290a-410f-a6d6-78657eb098c5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 306 | 2025.11.03 21:57:18.938723 [ 142243 ] {} <Debug> TCP-Session: c87d57b2-290a-410f-a6d6-78657eb098c5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2025.11.03 21:57:18.938815 [ 142242 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51236 | ||
| 308 | 2025.11.03 21:57:18.938902 [ 142242 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 309 | 2025.11.03 21:57:18.938924 [ 142242 ] {} <Debug> TCP-Session: bc911b09-06df-4fd4-92a9-c396a1659b51 Authenticating user 'default' from [::1]:51236 | ||
| 310 | 2025.11.03 21:57:18.938933 [ 142242 ] {} <Debug> TCP-Session: bc911b09-06df-4fd4-92a9-c396a1659b51 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2025.11.03 21:57:18.938940 [ 142242 ] {} <Debug> TCP-Session: bc911b09-06df-4fd4-92a9-c396a1659b51 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 312 | 2025.11.03 21:57:18.939033 [ 142240 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:51232 | ||
| 313 | 2025.11.03 21:57:18.939107 [ 142240 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 314 | 2025.11.03 21:57:18.939125 [ 142240 ] {} <Debug> TCP-Session: 4c58001f-a12c-4f71-a94c-236544e60044 Authenticating user 'default' from [::1]:51232 | ||
| 315 | 2025.11.03 21:57:18.939135 [ 142240 ] {} <Debug> TCP-Session: 4c58001f-a12c-4f71-a94c-236544e60044 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 316 | 2025.11.03 21:57:18.939141 [ 142240 ] {} <Debug> TCP-Session: 4c58001f-a12c-4f71-a94c-236544e60044 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 317 | 2025.11.03 21:57:18.942967 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 318 | 2025.11.03 21:57:18.943444 [ 142235 ] {15b59d02-a112-427b-93e5-2f21e5d68c1a} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 319 | 2025.11.03 21:57:18.943506 [ 142235 ] {15b59d02-a112-427b-93e5-2f21e5d68c1a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 320 | 2025.11.03 21:57:18.948030 [ 142235 ] {15b59d02-a112-427b-93e5-2f21e5d68c1a} <Debug> oximeter.measurements_i8 (b0a489c2-13a9-4750-bcdd-558ff5d95e9e): Loading data parts | ||
| 321 | 2025.11.03 21:57:18.949775 [ 142235 ] {15b59d02-a112-427b-93e5-2f21e5d68c1a} <Debug> oximeter.measurements_i8 (b0a489c2-13a9-4750-bcdd-558ff5d95e9e): There are no data parts | ||
| 322 | 2025.11.03 21:57:18.953676 [ 142235 ] {15b59d02-a112-427b-93e5-2f21e5d68c1a} <Debug> TCPHandler: Processed in 0.011083201 sec. | ||
| 323 | 2025.11.03 21:57:18.955801 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 324 | 2025.11.03 21:57:18.956478 [ 142235 ] {aaab83c3-ff8d-4252-9ac9-1fc97816e1ca} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 325 | 2025.11.03 21:57:18.957215 [ 142235 ] {aaab83c3-ff8d-4252-9ac9-1fc97816e1ca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 326 | 2025.11.03 21:57:18.962911 [ 142235 ] {aaab83c3-ff8d-4252-9ac9-1fc97816e1ca} <Debug> oximeter.measurements_u8 (f62a070b-110b-4e38-b254-33e1454621b4): Loading data parts | ||
| 327 | 2025.11.03 21:57:18.963144 [ 142235 ] {aaab83c3-ff8d-4252-9ac9-1fc97816e1ca} <Debug> oximeter.measurements_u8 (f62a070b-110b-4e38-b254-33e1454621b4): There are no data parts | ||
| 328 | 2025.11.03 21:57:18.966641 [ 142235 ] {aaab83c3-ff8d-4252-9ac9-1fc97816e1ca} <Debug> TCPHandler: Processed in 0.010993741 sec. | ||
| 329 | 2025.11.03 21:57:18.968163 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 330 | 2025.11.03 21:57:18.968449 [ 142235 ] {4c36861e-52b0-43d0-9ab0-5f360ee27c11} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 331 | 2025.11.03 21:57:18.968493 [ 142235 ] {4c36861e-52b0-43d0-9ab0-5f360ee27c11} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 332 | 2025.11.03 21:57:18.972655 [ 142235 ] {4c36861e-52b0-43d0-9ab0-5f360ee27c11} <Debug> oximeter.measurements_i16 (fc28e00c-cbaa-4003-b7fd-f53637aa2958): Loading data parts | ||
| 333 | 2025.11.03 21:57:18.973049 [ 142235 ] {4c36861e-52b0-43d0-9ab0-5f360ee27c11} <Debug> oximeter.measurements_i16 (fc28e00c-cbaa-4003-b7fd-f53637aa2958): There are no data parts | ||
| 334 | 2025.11.03 21:57:18.976677 [ 142235 ] {4c36861e-52b0-43d0-9ab0-5f360ee27c11} <Debug> TCPHandler: Processed in 0.00867244 sec. | ||
| 335 | 2025.11.03 21:57:18.977218 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 336 | 2025.11.03 21:57:18.977490 [ 142235 ] {5ac15237-43ee-4792-b83f-84b5505bc7c3} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 337 | 2025.11.03 21:57:18.977546 [ 142235 ] {5ac15237-43ee-4792-b83f-84b5505bc7c3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 338 | 2025.11.03 21:57:18.981974 [ 142235 ] {5ac15237-43ee-4792-b83f-84b5505bc7c3} <Debug> oximeter.measurements_u16 (e4a82e0e-84fc-4c5c-8b45-442ee61a4f95): Loading data parts | ||
| 339 | 2025.11.03 21:57:18.982383 [ 142235 ] {5ac15237-43ee-4792-b83f-84b5505bc7c3} <Debug> oximeter.measurements_u16 (e4a82e0e-84fc-4c5c-8b45-442ee61a4f95): There are no data parts | ||
| 340 | 2025.11.03 21:57:18.989517 [ 142235 ] {5ac15237-43ee-4792-b83f-84b5505bc7c3} <Debug> TCPHandler: Processed in 0.01248659 sec. | ||
| 341 | 2025.11.03 21:57:18.990199 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 342 | 2025.11.03 21:57:18.990557 [ 142235 ] {571af36c-4260-442f-8a0d-e1c9f1a34887} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 343 | 2025.11.03 21:57:18.990625 [ 142235 ] {571af36c-4260-442f-8a0d-e1c9f1a34887} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 344 | 2025.11.03 21:57:18.995287 [ 142235 ] {571af36c-4260-442f-8a0d-e1c9f1a34887} <Debug> oximeter.measurements_i32 (6ed22303-e57e-4717-ba40-31c594ac08f7): Loading data parts | ||
| 345 | 2025.11.03 21:57:18.995617 [ 142235 ] {571af36c-4260-442f-8a0d-e1c9f1a34887} <Debug> oximeter.measurements_i32 (6ed22303-e57e-4717-ba40-31c594ac08f7): There are no data parts | ||
| 346 | 2025.11.03 21:57:18.998714 [ 142235 ] {571af36c-4260-442f-8a0d-e1c9f1a34887} <Debug> TCPHandler: Processed in 0.00869625 sec. | ||
| 347 | 2025.11.03 21:57:18.999117 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 348 | 2025.11.03 21:57:19.001719 [ 142235 ] {44ac540e-004e-4227-ac9d-a5a437987da2} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 349 | 2025.11.03 21:57:19.001764 [ 142235 ] {44ac540e-004e-4227-ac9d-a5a437987da2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 350 | 2025.11.03 21:57:19.007293 [ 142235 ] {44ac540e-004e-4227-ac9d-a5a437987da2} <Debug> oximeter.measurements_u32 (f21276e8-6a86-4f50-b76d-968438094c84): Loading data parts | ||
| 351 | 2025.11.03 21:57:19.007740 [ 142235 ] {44ac540e-004e-4227-ac9d-a5a437987da2} <Debug> oximeter.measurements_u32 (f21276e8-6a86-4f50-b76d-968438094c84): There are no data parts | ||
| 352 | 2025.11.03 21:57:19.011512 [ 142235 ] {44ac540e-004e-4227-ac9d-a5a437987da2} <Debug> TCPHandler: Processed in 0.01251289 sec. | ||
| 353 | 2025.11.03 21:57:19.012121 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 354 | 2025.11.03 21:57:19.012397 [ 142235 ] {c5ab10de-a027-4a25-99a4-8ce3d1ac0dd1} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 355 | 2025.11.03 21:57:19.012449 [ 142235 ] {c5ab10de-a027-4a25-99a4-8ce3d1ac0dd1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 356 | 2025.11.03 21:57:19.017229 [ 142235 ] {c5ab10de-a027-4a25-99a4-8ce3d1ac0dd1} <Debug> oximeter.measurements_i64 (83b1fa75-e025-4cdf-9312-15232c1d9c3d): Loading data parts | ||
| 357 | 2025.11.03 21:57:19.017557 [ 142235 ] {c5ab10de-a027-4a25-99a4-8ce3d1ac0dd1} <Debug> oximeter.measurements_i64 (83b1fa75-e025-4cdf-9312-15232c1d9c3d): There are no data parts | ||
| 358 | 2025.11.03 21:57:19.021263 [ 142235 ] {c5ab10de-a027-4a25-99a4-8ce3d1ac0dd1} <Debug> TCPHandler: Processed in 0.00932898 sec. | ||
| 359 | 2025.11.03 21:57:19.021710 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 360 | 2025.11.03 21:57:19.021970 [ 142235 ] {d522601e-b0a0-4bc0-a6c2-6a4192c40b7e} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 361 | 2025.11.03 21:57:19.022022 [ 142235 ] {d522601e-b0a0-4bc0-a6c2-6a4192c40b7e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 362 | 2025.11.03 21:57:19.027176 [ 142235 ] {d522601e-b0a0-4bc0-a6c2-6a4192c40b7e} <Debug> oximeter.measurements_u64 (9791b03a-2987-4378-ac23-a330b51ee380): Loading data parts | ||
| 363 | 2025.11.03 21:57:19.027498 [ 142235 ] {d522601e-b0a0-4bc0-a6c2-6a4192c40b7e} <Debug> oximeter.measurements_u64 (9791b03a-2987-4378-ac23-a330b51ee380): There are no data parts | ||
| 364 | 2025.11.03 21:57:19.031258 [ 142235 ] {d522601e-b0a0-4bc0-a6c2-6a4192c40b7e} <Debug> TCPHandler: Processed in 0.009714141 sec. | ||
| 365 | 2025.11.03 21:57:19.031740 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 366 | 2025.11.03 21:57:19.032015 [ 142235 ] {bbacc807-0e70-4f4c-b0cf-ce6fcacbd038} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 367 | 2025.11.03 21:57:19.032067 [ 142235 ] {bbacc807-0e70-4f4c-b0cf-ce6fcacbd038} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 368 | 2025.11.03 21:57:19.036546 [ 142235 ] {bbacc807-0e70-4f4c-b0cf-ce6fcacbd038} <Debug> oximeter.measurements_f32 (e542e60d-5c61-42a5-88ac-0036bf61c496): Loading data parts | ||
| 369 | 2025.11.03 21:57:19.036940 [ 142235 ] {bbacc807-0e70-4f4c-b0cf-ce6fcacbd038} <Debug> oximeter.measurements_f32 (e542e60d-5c61-42a5-88ac-0036bf61c496): There are no data parts | ||
| 370 | 2025.11.03 21:57:19.040771 [ 142235 ] {bbacc807-0e70-4f4c-b0cf-ce6fcacbd038} <Debug> TCPHandler: Processed in 0.00920228 sec. | ||
| 371 | 2025.11.03 21:57:19.041238 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 372 | 2025.11.03 21:57:19.041459 [ 142235 ] {216e93f5-3c12-4b20-b7e2-10b51eca73cc} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 373 | 2025.11.03 21:57:19.041513 [ 142235 ] {216e93f5-3c12-4b20-b7e2-10b51eca73cc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 374 | 2025.11.03 21:57:19.053882 [ 142235 ] {216e93f5-3c12-4b20-b7e2-10b51eca73cc} <Debug> oximeter.measurements_f64 (9eec289f-017c-4047-bc5a-e94ebdf1e4e6): Loading data parts | ||
| 375 | 2025.11.03 21:57:19.054238 [ 142235 ] {216e93f5-3c12-4b20-b7e2-10b51eca73cc} <Debug> oximeter.measurements_f64 (9eec289f-017c-4047-bc5a-e94ebdf1e4e6): There are no data parts | ||
| 376 | 2025.11.03 21:57:19.058256 [ 142235 ] {216e93f5-3c12-4b20-b7e2-10b51eca73cc} <Debug> TCPHandler: Processed in 0.01714375 sec. | ||
| 377 | 2025.11.03 21:57:19.063388 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 378 | 2025.11.03 21:57:19.063660 [ 142235 ] {a9def36b-72f0-41ea-9e27-ee57cb198b52} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 379 | 2025.11.03 21:57:19.063714 [ 142235 ] {a9def36b-72f0-41ea-9e27-ee57cb198b52} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 380 | 2025.11.03 21:57:19.068272 [ 142235 ] {a9def36b-72f0-41ea-9e27-ee57cb198b52} <Debug> oximeter.measurements_string (b55da20f-a733-4960-ae03-bf7644511be6): Loading data parts | ||
| 381 | 2025.11.03 21:57:19.068601 [ 142235 ] {a9def36b-72f0-41ea-9e27-ee57cb198b52} <Debug> oximeter.measurements_string (b55da20f-a733-4960-ae03-bf7644511be6): There are no data parts | ||
| 382 | 2025.11.03 21:57:19.072640 [ 142235 ] {a9def36b-72f0-41ea-9e27-ee57cb198b52} <Debug> TCPHandler: Processed in 0.00943755 sec. | ||
| 383 | 2025.11.03 21:57:19.073269 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 384 | 2025.11.03 21:57:19.073525 [ 142235 ] {07037c87-60c5-4d2b-8e75-10b6f9e2b4ad} <Debug> executeQuery: (from [::1]:51222) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 385 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 386 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 387 | * a string isn't palatable for a few reasons. | ||
| 388 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 389 | * details. | ||
| 390 | */ | ||
| 391 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 392 | 2025.11.03 21:57:19.073574 [ 142235 ] {07037c87-60c5-4d2b-8e75-10b6f9e2b4ad} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 393 | 2025.11.03 21:57:19.077881 [ 142235 ] {07037c87-60c5-4d2b-8e75-10b6f9e2b4ad} <Debug> oximeter.measurements_bytes (9e6ac4b7-39fe-47aa-8263-836d0d94caa1): Loading data parts | ||
| 394 | 2025.11.03 21:57:19.078176 [ 142235 ] {07037c87-60c5-4d2b-8e75-10b6f9e2b4ad} <Debug> oximeter.measurements_bytes (9e6ac4b7-39fe-47aa-8263-836d0d94caa1): There are no data parts | ||
| 395 | 2025.11.03 21:57:19.082057 [ 142235 ] {07037c87-60c5-4d2b-8e75-10b6f9e2b4ad} <Debug> TCPHandler: Processed in 0.00891931 sec. | ||
| 396 | 2025.11.03 21:57:19.082724 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 397 | 2025.11.03 21:57:19.083000 [ 142235 ] {a02f55fc-1714-4d99-b1d5-c61c159a40cb} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 398 | 2025.11.03 21:57:19.083052 [ 142235 ] {a02f55fc-1714-4d99-b1d5-c61c159a40cb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 399 | 2025.11.03 21:57:19.088657 [ 142235 ] {a02f55fc-1714-4d99-b1d5-c61c159a40cb} <Debug> oximeter.measurements_cumulativei64 (79c51b0e-1bde-4b89-9769-2101953f0d61): Loading data parts | ||
| 400 | 2025.11.03 21:57:19.089002 [ 142235 ] {a02f55fc-1714-4d99-b1d5-c61c159a40cb} <Debug> oximeter.measurements_cumulativei64 (79c51b0e-1bde-4b89-9769-2101953f0d61): There are no data parts | ||
| 401 | 2025.11.03 21:57:19.093121 [ 142235 ] {a02f55fc-1714-4d99-b1d5-c61c159a40cb} <Debug> TCPHandler: Processed in 0.01056217 sec. | ||
| 402 | 2025.11.03 21:57:19.093595 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 403 | 2025.11.03 21:57:19.093885 [ 142235 ] {3addfbcb-94b2-4912-b150-b5843ad9a45f} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 404 | 2025.11.03 21:57:19.093943 [ 142235 ] {3addfbcb-94b2-4912-b150-b5843ad9a45f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 405 | 2025.11.03 21:57:19.098975 [ 142235 ] {3addfbcb-94b2-4912-b150-b5843ad9a45f} <Debug> oximeter.measurements_cumulativeu64 (b772b94e-fef1-4dab-8f9d-ac244c3a3e6d): Loading data parts | ||
| 406 | 2025.11.03 21:57:19.099309 [ 142235 ] {3addfbcb-94b2-4912-b150-b5843ad9a45f} <Debug> oximeter.measurements_cumulativeu64 (b772b94e-fef1-4dab-8f9d-ac244c3a3e6d): There are no data parts | ||
| 407 | 2025.11.03 21:57:19.103992 [ 142235 ] {3addfbcb-94b2-4912-b150-b5843ad9a45f} <Debug> TCPHandler: Processed in 0.01053729 sec. | ||
| 408 | 2025.11.03 21:57:19.104521 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 409 | 2025.11.03 21:57:19.104815 [ 142235 ] {d096d2be-292d-4c35-af8c-af15ceb8b949} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 410 | 2025.11.03 21:57:19.104893 [ 142235 ] {d096d2be-292d-4c35-af8c-af15ceb8b949} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 411 | 2025.11.03 21:57:19.110442 [ 142235 ] {d096d2be-292d-4c35-af8c-af15ceb8b949} <Debug> oximeter.measurements_cumulativef32 (39f961a7-8ed5-48e1-a8c8-93d15a873f3b): Loading data parts | ||
| 412 | 2025.11.03 21:57:19.110732 [ 142235 ] {d096d2be-292d-4c35-af8c-af15ceb8b949} <Debug> oximeter.measurements_cumulativef32 (39f961a7-8ed5-48e1-a8c8-93d15a873f3b): There are no data parts | ||
| 413 | 2025.11.03 21:57:19.114390 [ 142235 ] {d096d2be-292d-4c35-af8c-af15ceb8b949} <Debug> TCPHandler: Processed in 0.01004057 sec. | ||
| 414 | 2025.11.03 21:57:19.114934 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 415 | 2025.11.03 21:57:19.115258 [ 142235 ] {ad67314b-d090-4fb2-83df-5cd5f5223d83} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 416 | 2025.11.03 21:57:19.115314 [ 142235 ] {ad67314b-d090-4fb2-83df-5cd5f5223d83} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 417 | 2025.11.03 21:57:19.119939 [ 142235 ] {ad67314b-d090-4fb2-83df-5cd5f5223d83} <Debug> oximeter.measurements_cumulativef64 (bd0e659e-751e-4d9f-b872-64ead9494bc2): Loading data parts | ||
| 418 | 2025.11.03 21:57:19.120363 [ 142235 ] {ad67314b-d090-4fb2-83df-5cd5f5223d83} <Debug> oximeter.measurements_cumulativef64 (bd0e659e-751e-4d9f-b872-64ead9494bc2): There are no data parts | ||
| 419 | 2025.11.03 21:57:19.125488 [ 142235 ] {ad67314b-d090-4fb2-83df-5cd5f5223d83} <Debug> TCPHandler: Processed in 0.01072145 sec. | ||
| 420 | 2025.11.03 21:57:19.126099 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 421 | 2025.11.03 21:57:19.126637 [ 142235 ] {5090a46c-5e10-400a-ae31-bbb62c986a43} <Debug> executeQuery: (from [::1]:51222) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 422 | * NOTE: Array types cannot be Nullable, see | ||
| 423 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 424 | * for more details. | ||
| 425 | * | ||
| 426 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 427 | * is unfortunate, and at this point relies on the fact that an | ||
| 428 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 429 | * to figure out another way to represent missing samples here. | ||
| 430 | */ | ||
| 431 | 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) | ||
| 432 | 2025.11.03 21:57:19.126723 [ 142235 ] {5090a46c-5e10-400a-ae31-bbb62c986a43} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 433 | 2025.11.03 21:57:19.131710 [ 142235 ] {5090a46c-5e10-400a-ae31-bbb62c986a43} <Debug> oximeter.measurements_histogrami8 (9a776ad7-41fe-425b-b932-4ead6f54019e): Loading data parts | ||
| 434 | 2025.11.03 21:57:19.132089 [ 142235 ] {5090a46c-5e10-400a-ae31-bbb62c986a43} <Debug> oximeter.measurements_histogrami8 (9a776ad7-41fe-425b-b932-4ead6f54019e): There are no data parts | ||
| 435 | 2025.11.03 21:57:19.136143 [ 142235 ] {5090a46c-5e10-400a-ae31-bbb62c986a43} <Debug> TCPHandler: Processed in 0.01018247 sec. | ||
| 436 | 2025.11.03 21:57:19.136619 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 437 | 2025.11.03 21:57:19.136988 [ 142235 ] {658f496a-98ad-424d-852e-df19c7124113} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 438 | 2025.11.03 21:57:19.137052 [ 142235 ] {658f496a-98ad-424d-852e-df19c7124113} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 439 | 2025.11.03 21:57:19.141784 [ 142235 ] {658f496a-98ad-424d-852e-df19c7124113} <Debug> oximeter.measurements_histogramu8 (fb10c2c0-08b6-458b-9f16-527f308860a6): Loading data parts | ||
| 440 | 2025.11.03 21:57:19.142284 [ 142235 ] {658f496a-98ad-424d-852e-df19c7124113} <Debug> oximeter.measurements_histogramu8 (fb10c2c0-08b6-458b-9f16-527f308860a6): There are no data parts | ||
| 441 | 2025.11.03 21:57:19.146029 [ 142235 ] {658f496a-98ad-424d-852e-df19c7124113} <Debug> TCPHandler: Processed in 0.0095875 sec. | ||
| 442 | 2025.11.03 21:57:19.146517 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 443 | 2025.11.03 21:57:19.146878 [ 142235 ] {ce2b706c-3771-4ec2-9872-73b4af51c7a6} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 444 | 2025.11.03 21:57:19.146947 [ 142235 ] {ce2b706c-3771-4ec2-9872-73b4af51c7a6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 445 | 2025.11.03 21:57:19.151727 [ 142235 ] {ce2b706c-3771-4ec2-9872-73b4af51c7a6} <Debug> oximeter.measurements_histogrami16 (ed61c4b6-8bb4-44f0-bc9e-fee12fbc67f6): Loading data parts | ||
| 446 | 2025.11.03 21:57:19.152038 [ 142235 ] {ce2b706c-3771-4ec2-9872-73b4af51c7a6} <Debug> oximeter.measurements_histogrami16 (ed61c4b6-8bb4-44f0-bc9e-fee12fbc67f6): There are no data parts | ||
| 447 | 2025.11.03 21:57:19.155751 [ 142235 ] {ce2b706c-3771-4ec2-9872-73b4af51c7a6} <Debug> TCPHandler: Processed in 0.009395209 sec. | ||
| 448 | 2025.11.03 21:57:19.156194 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 449 | 2025.11.03 21:57:19.156513 [ 142235 ] {513019e8-5aa4-489e-bd8a-47586b26bfe2} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 450 | 2025.11.03 21:57:19.156575 [ 142235 ] {513019e8-5aa4-489e-bd8a-47586b26bfe2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 451 | 2025.11.03 21:57:19.168550 [ 142235 ] {513019e8-5aa4-489e-bd8a-47586b26bfe2} <Debug> oximeter.measurements_histogramu16 (353b79e6-ba21-4aeb-a7b3-bcb35cb16f46): Loading data parts | ||
| 452 | 2025.11.03 21:57:19.168836 [ 142235 ] {513019e8-5aa4-489e-bd8a-47586b26bfe2} <Debug> oximeter.measurements_histogramu16 (353b79e6-ba21-4aeb-a7b3-bcb35cb16f46): There are no data parts | ||
| 453 | 2025.11.03 21:57:19.180317 [ 142235 ] {513019e8-5aa4-489e-bd8a-47586b26bfe2} <Debug> TCPHandler: Processed in 0.024296841 sec. | ||
| 454 | 2025.11.03 21:57:19.180870 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 455 | 2025.11.03 21:57:19.181218 [ 142235 ] {ad1ddd5b-d5b4-4438-bf4d-30ac6e9dd493} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 456 | 2025.11.03 21:57:19.181286 [ 142235 ] {ad1ddd5b-d5b4-4438-bf4d-30ac6e9dd493} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 457 | 2025.11.03 21:57:19.186904 [ 142235 ] {ad1ddd5b-d5b4-4438-bf4d-30ac6e9dd493} <Debug> oximeter.measurements_histogrami32 (b707a05e-5d02-449f-ad21-a01af079c76a): Loading data parts | ||
| 458 | 2025.11.03 21:57:19.187228 [ 142235 ] {ad1ddd5b-d5b4-4438-bf4d-30ac6e9dd493} <Debug> oximeter.measurements_histogrami32 (b707a05e-5d02-449f-ad21-a01af079c76a): There are no data parts | ||
| 459 | 2025.11.03 21:57:19.191495 [ 142235 ] {ad1ddd5b-d5b4-4438-bf4d-30ac6e9dd493} <Debug> TCPHandler: Processed in 0.01080607 sec. | ||
| 460 | 2025.11.03 21:57:19.194208 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 461 | 2025.11.03 21:57:19.194585 [ 142235 ] {13db300e-2ae3-447a-9208-6cf31c067e90} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 462 | 2025.11.03 21:57:19.194643 [ 142235 ] {13db300e-2ae3-447a-9208-6cf31c067e90} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 463 | 2025.11.03 21:57:19.202054 [ 142235 ] {13db300e-2ae3-447a-9208-6cf31c067e90} <Debug> oximeter.measurements_histogramu32 (f56e072f-08c9-4e34-b727-4479dbcd8975): Loading data parts | ||
| 464 | 2025.11.03 21:57:19.202519 [ 142235 ] {13db300e-2ae3-447a-9208-6cf31c067e90} <Debug> oximeter.measurements_histogramu32 (f56e072f-08c9-4e34-b727-4479dbcd8975): There are no data parts | ||
| 465 | 2025.11.03 21:57:19.207649 [ 142235 ] {13db300e-2ae3-447a-9208-6cf31c067e90} <Debug> TCPHandler: Processed in 0.01360664 sec. | ||
| 466 | 2025.11.03 21:57:19.210194 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 467 | 2025.11.03 21:57:19.210599 [ 142235 ] {c3af680f-3687-4eb4-84d6-7c9fbf347ff0} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 468 | 2025.11.03 21:57:19.210660 [ 142235 ] {c3af680f-3687-4eb4-84d6-7c9fbf347ff0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 469 | 2025.11.03 21:57:19.216047 [ 142235 ] {c3af680f-3687-4eb4-84d6-7c9fbf347ff0} <Debug> oximeter.measurements_histogrami64 (db5dc778-1ffe-4a35-afa2-a47fad45e1cb): Loading data parts | ||
| 470 | 2025.11.03 21:57:19.217680 [ 142235 ] {c3af680f-3687-4eb4-84d6-7c9fbf347ff0} <Debug> oximeter.measurements_histogrami64 (db5dc778-1ffe-4a35-afa2-a47fad45e1cb): There are no data parts | ||
| 471 | 2025.11.03 21:57:19.221690 [ 142235 ] {c3af680f-3687-4eb4-84d6-7c9fbf347ff0} <Debug> TCPHandler: Processed in 0.01166346 sec. | ||
| 472 | 2025.11.03 21:57:19.230028 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 473 | 2025.11.03 21:57:19.230449 [ 142235 ] {1007da39-afe6-4d95-9702-7e1fd7aa3a7c} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 474 | 2025.11.03 21:57:19.230537 [ 142235 ] {1007da39-afe6-4d95-9702-7e1fd7aa3a7c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 475 | 2025.11.03 21:57:19.235514 [ 142235 ] {1007da39-afe6-4d95-9702-7e1fd7aa3a7c} <Debug> oximeter.measurements_histogramu64 (0ed3779a-3229-4a4d-a202-e866db5f4695): Loading data parts | ||
| 476 | 2025.11.03 21:57:19.235776 [ 142235 ] {1007da39-afe6-4d95-9702-7e1fd7aa3a7c} <Debug> oximeter.measurements_histogramu64 (0ed3779a-3229-4a4d-a202-e866db5f4695): There are no data parts | ||
| 477 | 2025.11.03 21:57:19.239836 [ 142235 ] {1007da39-afe6-4d95-9702-7e1fd7aa3a7c} <Debug> TCPHandler: Processed in 0.00999874 sec. | ||
| 478 | 2025.11.03 21:57:19.241323 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 479 | 2025.11.03 21:57:19.241693 [ 142235 ] {f756536f-a21f-44c1-bfbf-577719540d66} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 480 | 2025.11.03 21:57:19.241756 [ 142235 ] {f756536f-a21f-44c1-bfbf-577719540d66} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 481 | 2025.11.03 21:57:19.254612 [ 142235 ] {f756536f-a21f-44c1-bfbf-577719540d66} <Debug> oximeter.measurements_histogramf32 (d2157323-dc86-4a12-a1e8-b7be686bdeb8): Loading data parts | ||
| 482 | 2025.11.03 21:57:19.254934 [ 142235 ] {f756536f-a21f-44c1-bfbf-577719540d66} <Debug> oximeter.measurements_histogramf32 (d2157323-dc86-4a12-a1e8-b7be686bdeb8): There are no data parts | ||
| 483 | 2025.11.03 21:57:19.260545 [ 142235 ] {f756536f-a21f-44c1-bfbf-577719540d66} <Debug> TCPHandler: Processed in 0.01939396 sec. | ||
| 484 | 2025.11.03 21:57:19.296778 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 485 | 2025.11.03 21:57:19.297210 [ 142235 ] {cc7edaf9-f829-451e-9b26-f7a3ca9b645e} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 486 | 2025.11.03 21:57:19.297289 [ 142235 ] {cc7edaf9-f829-451e-9b26-f7a3ca9b645e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 487 | 2025.11.03 21:57:19.302691 [ 142235 ] {cc7edaf9-f829-451e-9b26-f7a3ca9b645e} <Debug> oximeter.measurements_histogramf64 (d837b1bc-0a74-46b3-9f4e-188b2fd33ea2): Loading data parts | ||
| 488 | 2025.11.03 21:57:19.302986 [ 142235 ] {cc7edaf9-f829-451e-9b26-f7a3ca9b645e} <Debug> oximeter.measurements_histogramf64 (d837b1bc-0a74-46b3-9f4e-188b2fd33ea2): There are no data parts | ||
| 489 | 2025.11.03 21:57:19.307113 [ 142235 ] {cc7edaf9-f829-451e-9b26-f7a3ca9b645e} <Debug> TCPHandler: Processed in 0.01055366 sec. | ||
| 490 | 2025.11.03 21:57:19.308803 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 491 | 2025.11.03 21:57:19.309108 [ 142235 ] {45a9f5db-d28f-4dc3-8400-84ba39d981d3} <Debug> executeQuery: (from [::1]:51222) /* The field tables store named dimensions of each timeseries. | ||
| 492 | * | ||
| 493 | * As with the measurement tables, there is one field table for each field data | ||
| 494 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 495 | * this behavior **must not** be relied upon for query correctness. | ||
| 496 | * | ||
| 497 | * The index for the fields differs from the measurements, however. Rows are | ||
| 498 | * sorted by timeseries name, then field name, field value, and finally | ||
| 499 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 500 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 501 | * usually then used to look up measurements. | ||
| 502 | * | ||
| 503 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 504 | * timeseries name and then key, since it would improve lookups where one | ||
| 505 | * already has the key. Realistically though, these tables are quite small and | ||
| 506 | * so performance benefits will be low in absolute terms. | ||
| 507 | * | ||
| 508 | * TTL: We use a materialized column to expire old field table records. This | ||
| 509 | * column is generated automatically by the database whenever a new row is | ||
| 510 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 511 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 512 | * record will remain during a deduplication, which will have the last | ||
| 513 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 514 | * measurement tables. | ||
| 515 | */ | ||
| 516 | 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) | ||
| 517 | 2025.11.03 21:57:19.309173 [ 142235 ] {45a9f5db-d28f-4dc3-8400-84ba39d981d3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 518 | 2025.11.03 21:57:19.319521 [ 142235 ] {45a9f5db-d28f-4dc3-8400-84ba39d981d3} <Debug> oximeter.fields_bool (6bc8179e-7385-4da5-8967-0eda0010e46c): Loading data parts | ||
| 519 | 2025.11.03 21:57:19.319884 [ 142235 ] {45a9f5db-d28f-4dc3-8400-84ba39d981d3} <Debug> oximeter.fields_bool (6bc8179e-7385-4da5-8967-0eda0010e46c): There are no data parts | ||
| 520 | 2025.11.03 21:57:19.332782 [ 142235 ] {45a9f5db-d28f-4dc3-8400-84ba39d981d3} <Debug> TCPHandler: Processed in 0.02416432 sec. | ||
| 521 | 2025.11.03 21:57:19.333408 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 522 | 2025.11.03 21:57:19.333669 [ 142235 ] {89bcf9d4-873b-4471-89af-c3417986e78a} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 523 | 2025.11.03 21:57:19.333729 [ 142235 ] {89bcf9d4-873b-4471-89af-c3417986e78a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 524 | 2025.11.03 21:57:19.338579 [ 142235 ] {89bcf9d4-873b-4471-89af-c3417986e78a} <Debug> oximeter.fields_i8 (6e33c4ad-1af3-4c31-a0dc-0f590b72bf04): Loading data parts | ||
| 525 | 2025.11.03 21:57:19.338867 [ 142235 ] {89bcf9d4-873b-4471-89af-c3417986e78a} <Debug> oximeter.fields_i8 (6e33c4ad-1af3-4c31-a0dc-0f590b72bf04): There are no data parts | ||
| 526 | 2025.11.03 21:57:19.342696 [ 142235 ] {89bcf9d4-873b-4471-89af-c3417986e78a} <Debug> TCPHandler: Processed in 0.00946646 sec. | ||
| 527 | 2025.11.03 21:57:19.347158 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 528 | 2025.11.03 21:57:19.347429 [ 142235 ] {4b62ba0e-91d0-42a3-a1c9-cc5627925ed4} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 529 | 2025.11.03 21:57:19.347482 [ 142235 ] {4b62ba0e-91d0-42a3-a1c9-cc5627925ed4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 530 | 2025.11.03 21:57:19.356145 [ 142235 ] {4b62ba0e-91d0-42a3-a1c9-cc5627925ed4} <Debug> oximeter.fields_u8 (005a7366-62d7-4088-b1a5-0a154ac2d1db): Loading data parts | ||
| 531 | 2025.11.03 21:57:19.356602 [ 142235 ] {4b62ba0e-91d0-42a3-a1c9-cc5627925ed4} <Debug> oximeter.fields_u8 (005a7366-62d7-4088-b1a5-0a154ac2d1db): There are no data parts | ||
| 532 | 2025.11.03 21:57:19.360533 [ 142235 ] {4b62ba0e-91d0-42a3-a1c9-cc5627925ed4} <Debug> TCPHandler: Processed in 0.013552491 sec. | ||
| 533 | 2025.11.03 21:57:19.364152 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 534 | 2025.11.03 21:57:19.364430 [ 142235 ] {1a408da4-7875-4c48-946c-1d94d397a259} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 535 | 2025.11.03 21:57:19.364488 [ 142235 ] {1a408da4-7875-4c48-946c-1d94d397a259} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 536 | 2025.11.03 21:57:19.370837 [ 142235 ] {1a408da4-7875-4c48-946c-1d94d397a259} <Debug> oximeter.fields_i16 (756dace8-20a9-4cd8-90c3-b12d4359c36b): Loading data parts | ||
| 537 | 2025.11.03 21:57:19.371136 [ 142235 ] {1a408da4-7875-4c48-946c-1d94d397a259} <Debug> oximeter.fields_i16 (756dace8-20a9-4cd8-90c3-b12d4359c36b): There are no data parts | ||
| 538 | 2025.11.03 21:57:19.375292 [ 142235 ] {1a408da4-7875-4c48-946c-1d94d397a259} <Debug> TCPHandler: Processed in 0.01132464 sec. | ||
| 539 | 2025.11.03 21:57:19.376670 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 540 | 2025.11.03 21:57:19.378265 [ 142235 ] {c92ca9b9-b940-4cb3-8618-2bcf51703d9f} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 541 | 2025.11.03 21:57:19.378324 [ 142235 ] {c92ca9b9-b940-4cb3-8618-2bcf51703d9f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 542 | 2025.11.03 21:57:19.383345 [ 142235 ] {c92ca9b9-b940-4cb3-8618-2bcf51703d9f} <Debug> oximeter.fields_u16 (78adabac-e9dd-4aeb-a08b-010a8572ec02): Loading data parts | ||
| 543 | 2025.11.03 21:57:19.383565 [ 142235 ] {c92ca9b9-b940-4cb3-8618-2bcf51703d9f} <Debug> oximeter.fields_u16 (78adabac-e9dd-4aeb-a08b-010a8572ec02): There are no data parts | ||
| 544 | 2025.11.03 21:57:19.387340 [ 142235 ] {c92ca9b9-b940-4cb3-8618-2bcf51703d9f} <Debug> TCPHandler: Processed in 0.01075907 sec. | ||
| 545 | 2025.11.03 21:57:19.387790 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 546 | 2025.11.03 21:57:19.388042 [ 142235 ] {39b36129-4ba7-4c0a-b42f-036c48541862} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 547 | 2025.11.03 21:57:19.388095 [ 142235 ] {39b36129-4ba7-4c0a-b42f-036c48541862} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 548 | 2025.11.03 21:57:19.392992 [ 142235 ] {39b36129-4ba7-4c0a-b42f-036c48541862} <Debug> oximeter.fields_i32 (a4ecef4f-ceeb-46b9-ab4e-f46de8897ad2): Loading data parts | ||
| 549 | 2025.11.03 21:57:19.393286 [ 142235 ] {39b36129-4ba7-4c0a-b42f-036c48541862} <Debug> oximeter.fields_i32 (a4ecef4f-ceeb-46b9-ab4e-f46de8897ad2): There are no data parts | ||
| 550 | 2025.11.03 21:57:19.396820 [ 142235 ] {39b36129-4ba7-4c0a-b42f-036c48541862} <Debug> TCPHandler: Processed in 0.00915482 sec. | ||
| 551 | 2025.11.03 21:57:19.397281 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 552 | 2025.11.03 21:57:19.397554 [ 142235 ] {83296e33-886f-4c65-aa62-9116e3d5375c} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 553 | 2025.11.03 21:57:19.397609 [ 142235 ] {83296e33-886f-4c65-aa62-9116e3d5375c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 554 | 2025.11.03 21:57:19.402023 [ 142235 ] {83296e33-886f-4c65-aa62-9116e3d5375c} <Debug> oximeter.fields_u32 (eb36a73e-14a8-402d-ae13-c16505650dbe): Loading data parts | ||
| 555 | 2025.11.03 21:57:19.402339 [ 142235 ] {83296e33-886f-4c65-aa62-9116e3d5375c} <Debug> oximeter.fields_u32 (eb36a73e-14a8-402d-ae13-c16505650dbe): There are no data parts | ||
| 556 | 2025.11.03 21:57:19.406030 [ 142235 ] {83296e33-886f-4c65-aa62-9116e3d5375c} <Debug> TCPHandler: Processed in 0.00892543 sec. | ||
| 557 | 2025.11.03 21:57:19.406542 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 558 | 2025.11.03 21:57:19.406802 [ 142235 ] {a399e557-1468-488c-add4-719544823895} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 559 | 2025.11.03 21:57:19.406857 [ 142235 ] {a399e557-1468-488c-add4-719544823895} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 560 | 2025.11.03 21:57:19.411688 [ 142235 ] {a399e557-1468-488c-add4-719544823895} <Debug> oximeter.fields_i64 (742bd826-9679-4c2e-85a3-f1d8db1ad3ef): Loading data parts | ||
| 561 | 2025.11.03 21:57:19.411949 [ 142235 ] {a399e557-1468-488c-add4-719544823895} <Debug> oximeter.fields_i64 (742bd826-9679-4c2e-85a3-f1d8db1ad3ef): There are no data parts | ||
| 562 | 2025.11.03 21:57:19.415769 [ 142235 ] {a399e557-1468-488c-add4-719544823895} <Debug> TCPHandler: Processed in 0.00940941 sec. | ||
| 563 | 2025.11.03 21:57:19.416321 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 564 | 2025.11.03 21:57:19.416591 [ 142235 ] {4ae430d6-84be-4e71-9254-10a24b739725} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 565 | 2025.11.03 21:57:19.416643 [ 142235 ] {4ae430d6-84be-4e71-9254-10a24b739725} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 566 | 2025.11.03 21:57:19.421291 [ 142235 ] {4ae430d6-84be-4e71-9254-10a24b739725} <Debug> oximeter.fields_u64 (02a0ff8d-5dd7-4ef5-bb05-1922551026ab): Loading data parts | ||
| 567 | 2025.11.03 21:57:19.421564 [ 142235 ] {4ae430d6-84be-4e71-9254-10a24b739725} <Debug> oximeter.fields_u64 (02a0ff8d-5dd7-4ef5-bb05-1922551026ab): There are no data parts | ||
| 568 | 2025.11.03 21:57:19.425263 [ 142235 ] {4ae430d6-84be-4e71-9254-10a24b739725} <Debug> TCPHandler: Processed in 0.009113931 sec. | ||
| 569 | 2025.11.03 21:57:19.425777 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 570 | 2025.11.03 21:57:19.426033 [ 142235 ] {54addb87-2de4-4b9c-815a-b20e69a019de} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 571 | 2025.11.03 21:57:19.426089 [ 142235 ] {54addb87-2de4-4b9c-815a-b20e69a019de} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 572 | 2025.11.03 21:57:19.430814 [ 142235 ] {54addb87-2de4-4b9c-815a-b20e69a019de} <Debug> oximeter.fields_ipaddr (1c772f3e-2bba-4328-9e8f-bba830cbce19): Loading data parts | ||
| 573 | 2025.11.03 21:57:19.431167 [ 142235 ] {54addb87-2de4-4b9c-815a-b20e69a019de} <Debug> oximeter.fields_ipaddr (1c772f3e-2bba-4328-9e8f-bba830cbce19): There are no data parts | ||
| 574 | 2025.11.03 21:57:19.435309 [ 142235 ] {54addb87-2de4-4b9c-815a-b20e69a019de} <Debug> TCPHandler: Processed in 0.009721761 sec. | ||
| 575 | 2025.11.03 21:57:19.435815 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 576 | 2025.11.03 21:57:19.436025 [ 142235 ] {5f2fc9dd-0d22-48cd-9e26-a7c4ab74b86d} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 577 | 2025.11.03 21:57:19.436067 [ 142235 ] {5f2fc9dd-0d22-48cd-9e26-a7c4ab74b86d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 578 | 2025.11.03 21:57:19.440512 [ 142235 ] {5f2fc9dd-0d22-48cd-9e26-a7c4ab74b86d} <Debug> oximeter.fields_string (608d1611-4802-42b0-89a0-2a7f2e4f8f9e): Loading data parts | ||
| 579 | 2025.11.03 21:57:19.440814 [ 142235 ] {5f2fc9dd-0d22-48cd-9e26-a7c4ab74b86d} <Debug> oximeter.fields_string (608d1611-4802-42b0-89a0-2a7f2e4f8f9e): There are no data parts | ||
| 580 | 2025.11.03 21:57:19.444640 [ 142235 ] {5f2fc9dd-0d22-48cd-9e26-a7c4ab74b86d} <Debug> TCPHandler: Processed in 0.00897189 sec. | ||
| 581 | 2025.11.03 21:57:19.445200 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 582 | 2025.11.03 21:57:19.445450 [ 142235 ] {a26718b6-114b-4b6f-be4e-8acc988cc5f9} <Debug> executeQuery: (from [::1]:51222) 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) | ||
| 583 | 2025.11.03 21:57:19.445529 [ 142235 ] {a26718b6-114b-4b6f-be4e-8acc988cc5f9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 584 | 2025.11.03 21:57:19.453281 [ 142235 ] {a26718b6-114b-4b6f-be4e-8acc988cc5f9} <Debug> oximeter.fields_uuid (dd02705b-8713-4681-837a-68ef79db66e0): Loading data parts | ||
| 585 | 2025.11.03 21:57:19.453571 [ 142235 ] {a26718b6-114b-4b6f-be4e-8acc988cc5f9} <Debug> oximeter.fields_uuid (dd02705b-8713-4681-837a-68ef79db66e0): There are no data parts | ||
| 586 | 2025.11.03 21:57:19.458591 [ 142235 ] {a26718b6-114b-4b6f-be4e-8acc988cc5f9} <Debug> TCPHandler: Processed in 0.01355576 sec. | ||
| 587 | 2025.11.03 21:57:19.461628 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 588 | 2025.11.03 21:57:19.461924 [ 142235 ] {52129cef-f6ea-4958-afe9-d8087ed03114} <Debug> executeQuery: (from [::1]:51222) /* The timeseries schema table stores the extracted schema for the samples | ||
| 589 | * oximeter collects. | ||
| 590 | */ | ||
| 591 | 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) | ||
| 592 | 2025.11.03 21:57:19.462008 [ 142235 ] {52129cef-f6ea-4958-afe9-d8087ed03114} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 593 | 2025.11.03 21:57:19.468453 [ 142235 ] {52129cef-f6ea-4958-afe9-d8087ed03114} <Debug> oximeter.timeseries_schema (50716bf3-157e-487a-b35d-1b9c3773cff8): Loading data parts | ||
| 594 | 2025.11.03 21:57:19.468709 [ 142235 ] {52129cef-f6ea-4958-afe9-d8087ed03114} <Debug> oximeter.timeseries_schema (50716bf3-157e-487a-b35d-1b9c3773cff8): There are no data parts | ||
| 595 | 2025.11.03 21:57:19.472653 [ 142235 ] {52129cef-f6ea-4958-afe9-d8087ed03114} <Debug> TCPHandler: Processed in 0.01110197 sec. | ||
| 596 | 2025.11.03 21:57:19.473152 [ 142236 ] {} <Trace> TCP-Session: 1d320899-bf51-4a83-8090-f38bd84f3013 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 597 | 2025.11.03 21:57:19.473320 [ 142236 ] {3226a7b8-19f6-4009-a49a-a4e8ea32cd6d} <Debug> executeQuery: (from [::1]:51224) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 598 | 2025.11.03 21:57:19.473403 [ 142236 ] {3226a7b8-19f6-4009-a49a-a4e8ea32cd6d} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 599 | 2025.11.03 21:57:19.474260 [ 142244 ] {3226a7b8-19f6-4009-a49a-a4e8ea32cd6d} <Trace> oximeter.version (1b62b654-b5fa-4c15-891c-346380626f0d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 600 | 2025.11.03 21:57:19.474297 [ 142244 ] {3226a7b8-19f6-4009-a49a-a4e8ea32cd6d} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 601 | 2025.11.03 21:57:19.474631 [ 142244 ] {3226a7b8-19f6-4009-a49a-a4e8ea32cd6d} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 602 | 2025.11.03 21:57:19.474811 [ 142244 ] {3226a7b8-19f6-4009-a49a-a4e8ea32cd6d} <Trace> oximeter.version (1b62b654-b5fa-4c15-891c-346380626f0d): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 603 | 2025.11.03 21:57:19.475001 [ 142236 ] {3226a7b8-19f6-4009-a49a-a4e8ea32cd6d} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.001741 sec., 574.3825387708214 rows/sec., 8.97 KiB/sec. | ||
| 604 | 2025.11.03 21:57:19.475139 [ 142236 ] {3226a7b8-19f6-4009-a49a-a4e8ea32cd6d} <Debug> TCPHandler: Processed in 0.00216359 sec. | ||
| 605 | 2025.11.03 21:57:19.792593 [ 141829 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 88 entries to flush up to offset 88 | ||
| 606 | 2025.11.03 21:57:19.792646 [ 141829 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
| 607 | 2025.11.03 21:57:19.798497 [ 141829 ] {} <Debug> system.query_log (9ae2adf1-da36-4184-825b-8fef998470a4): Loading data parts | ||
| 608 | 2025.11.03 21:57:19.798713 [ 141829 ] {} <Debug> system.query_log (9ae2adf1-da36-4184-825b-8fef998470a4): There are no data parts | ||
| 609 | 2025.11.03 21:57:19.809871 [ 141829 ] {} <Trace> system.query_log (9ae2adf1-da36-4184-825b-8fef998470a4): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 610 | 2025.11.03 21:57:19.809914 [ 141829 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 611 | 2025.11.03 21:57:19.811493 [ 141829 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 612 | 2025.11.03 21:57:19.811743 [ 141829 ] {} <Trace> system.query_log (9ae2adf1-da36-4184-825b-8fef998470a4): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 613 | 2025.11.03 21:57:19.812063 [ 141829 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 88 | ||
| 614 | 2025.11.03 21:57:20.000407 [ 141832 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 404.09 MiB, peak 404.09 MiB, free memory in arenas 24.84 MiB, will set to 402.54 MiB (RSS), difference: -1.55 MiB | ||
| 615 | 2025.11.03 21:57:20.479022 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 616 | 2025.11.03 21:57:20.479243 [ 142235 ] {3868ea2f-58ce-489e-bf61-238fe1069763} <Debug> executeQuery: (from [::1]:51222) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 617 | 2025.11.03 21:57:20.479488 [ 142235 ] {3868ea2f-58ce-489e-bf61-238fe1069763} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 618 | 2025.11.03 21:57:20.479535 [ 142235 ] {3868ea2f-58ce-489e-bf61-238fe1069763} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 619 | 2025.11.03 21:57:20.480106 [ 142235 ] {3868ea2f-58ce-489e-bf61-238fe1069763} <Debug> TCPHandler: Processed in 0.00120876 sec. | ||
| 620 | 2025.11.03 21:57:20.482631 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 621 | 2025.11.03 21:57:20.482804 [ 142235 ] {2b68b589-8200-4f52-b9a6-89a3cf99610d} <Debug> executeQuery: (from [::1]:51222) SELECT * FROM oximeter.timeseries_schema WHERE timeseries_name NOT IN ('oximeter_collector:collections') FORMAT Native; (stage: Complete) | ||
| 622 | 2025.11.03 21:57:20.483141 [ 142235 ] {2b68b589-8200-4f52-b9a6-89a3cf99610d} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 623 | 2025.11.03 21:57:20.483197 [ 142235 ] {2b68b589-8200-4f52-b9a6-89a3cf99610d} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 624 | 2025.11.03 21:57:20.483719 [ 142235 ] {2b68b589-8200-4f52-b9a6-89a3cf99610d} <Debug> TCPHandler: Processed in 0.00117022 sec. | ||
| 625 | 2025.11.03 21:57:20.492257 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 626 | 2025.11.03 21:57:20.492452 [ 142235 ] {6fa56576-e105-4fda-9436-d1b229f6dce3} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
| 627 | 2025.11.03 21:57:20.492517 [ 142235 ] {6fa56576-e105-4fda-9436-d1b229f6dce3} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 628 | 2025.11.03 21:57:20.498612 [ 142235 ] {6fa56576-e105-4fda-9436-d1b229f6dce3} <Trace> oximeter.timeseries_schema (50716bf3-157e-487a-b35d-1b9c3773cff8): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 629 | 2025.11.03 21:57:20.498648 [ 142235 ] {6fa56576-e105-4fda-9436-d1b229f6dce3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 630 | 2025.11.03 21:57:20.499178 [ 142235 ] {6fa56576-e105-4fda-9436-d1b229f6dce3} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 631 | 2025.11.03 21:57:20.499372 [ 142235 ] {6fa56576-e105-4fda-9436-d1b229f6dce3} <Trace> oximeter.timeseries_schema (50716bf3-157e-487a-b35d-1b9c3773cff8): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 632 | 2025.11.03 21:57:20.499579 [ 142235 ] {6fa56576-e105-4fda-9436-d1b229f6dce3} <Debug> executeQuery: Read 2 rows, 355.00 B in 0.007184 sec., 278.39643652561244 rows/sec., 48.26 KiB/sec. | ||
| 633 | 2025.11.03 21:57:20.499623 [ 142235 ] {6fa56576-e105-4fda-9436-d1b229f6dce3} <Debug> TCPHandler: Processed in 0.007543449 sec. | ||
| 634 | 2025.11.03 21:57:20.501123 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 635 | 2025.11.03 21:57:20.501263 [ 142235 ] {070aff7b-b9d9-4701-8735-83ab1e450cd3} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.fields_ipaddr FORMAT Native (stage: Complete) | ||
| 636 | 2025.11.03 21:57:20.501312 [ 142235 ] {070aff7b-b9d9-4701-8735-83ab1e450cd3} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_ipaddr | ||
| 637 | 2025.11.03 21:57:20.518875 [ 142235 ] {070aff7b-b9d9-4701-8735-83ab1e450cd3} <Trace> oximeter.fields_ipaddr (1c772f3e-2bba-4328-9e8f-bba830cbce19): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 638 | 2025.11.03 21:57:20.518934 [ 142235 ] {070aff7b-b9d9-4701-8735-83ab1e450cd3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 639 | 2025.11.03 21:57:20.519334 [ 142235 ] {070aff7b-b9d9-4701-8735-83ab1e450cd3} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 640 | 2025.11.03 21:57:20.519510 [ 142235 ] {070aff7b-b9d9-4701-8735-83ab1e450cd3} <Trace> oximeter.fields_ipaddr (1c772f3e-2bba-4328-9e8f-bba830cbce19): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 641 | 2025.11.03 21:57:20.519697 [ 142235 ] {070aff7b-b9d9-4701-8735-83ab1e450cd3} <Debug> executeQuery: Read 2 rows, 167.00 B in 0.018477 sec., 108.242680088759 rows/sec., 8.83 KiB/sec. | ||
| 642 | 2025.11.03 21:57:20.519746 [ 142235 ] {070aff7b-b9d9-4701-8735-83ab1e450cd3} <Debug> TCPHandler: Processed in 0.01877737 sec. | ||
| 643 | 2025.11.03 21:57:20.532014 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 644 | 2025.11.03 21:57:20.532228 [ 142235 ] {dfd51909-cb31-4269-826d-09b1aebf2453} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 645 | 2025.11.03 21:57:20.532301 [ 142235 ] {dfd51909-cb31-4269-826d-09b1aebf2453} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 646 | 2025.11.03 21:57:20.534195 [ 142235 ] {dfd51909-cb31-4269-826d-09b1aebf2453} <Trace> oximeter.fields_string (608d1611-4802-42b0-89a0-2a7f2e4f8f9e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 647 | 2025.11.03 21:57:20.534243 [ 142235 ] {dfd51909-cb31-4269-826d-09b1aebf2453} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 648 | 2025.11.03 21:57:20.534695 [ 142235 ] {dfd51909-cb31-4269-826d-09b1aebf2453} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 649 | 2025.11.03 21:57:20.534950 [ 142235 ] {dfd51909-cb31-4269-826d-09b1aebf2453} <Trace> oximeter.fields_string (608d1611-4802-42b0-89a0-2a7f2e4f8f9e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 650 | 2025.11.03 21:57:20.535141 [ 142235 ] {dfd51909-cb31-4269-826d-09b1aebf2453} <Debug> executeQuery: Read 3 rows, 287.00 B in 0.002978 sec., 1007.3875083948958 rows/sec., 94.11 KiB/sec. | ||
| 651 | 2025.11.03 21:57:20.535179 [ 142235 ] {dfd51909-cb31-4269-826d-09b1aebf2453} <Debug> TCPHandler: Processed in 0.00336808 sec. | ||
| 652 | 2025.11.03 21:57:20.562931 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 653 | 2025.11.03 21:57:20.563130 [ 142235 ] {69185133-883c-4fe8-8485-cb4a6cbc0b8c} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.fields_u16 FORMAT Native (stage: Complete) | ||
| 654 | 2025.11.03 21:57:20.563192 [ 142235 ] {69185133-883c-4fe8-8485-cb4a6cbc0b8c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_u16 | ||
| 655 | 2025.11.03 21:57:20.564337 [ 142235 ] {69185133-883c-4fe8-8485-cb4a6cbc0b8c} <Trace> oximeter.fields_u16 (78adabac-e9dd-4aeb-a08b-010a8572ec02): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 656 | 2025.11.03 21:57:20.564370 [ 142235 ] {69185133-883c-4fe8-8485-cb4a6cbc0b8c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 657 | 2025.11.03 21:57:20.564759 [ 142235 ] {69185133-883c-4fe8-8485-cb4a6cbc0b8c} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 658 | 2025.11.03 21:57:20.564953 [ 142235 ] {69185133-883c-4fe8-8485-cb4a6cbc0b8c} <Trace> oximeter.fields_u16 (78adabac-e9dd-4aeb-a08b-010a8572ec02): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 659 | 2025.11.03 21:57:20.565135 [ 142235 ] {69185133-883c-4fe8-8485-cb4a6cbc0b8c} <Debug> executeQuery: Read 2 rows, 143.00 B in 0.002064 sec., 968.9922480620156 rows/sec., 67.66 KiB/sec. | ||
| 660 | 2025.11.03 21:57:20.565174 [ 142235 ] {69185133-883c-4fe8-8485-cb4a6cbc0b8c} <Debug> TCPHandler: Processed in 0.002434829 sec. | ||
| 661 | 2025.11.03 21:57:20.629280 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 662 | 2025.11.03 21:57:20.629470 [ 142235 ] {555a025f-4cde-43bd-8676-d82fbe39a843} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.fields_uuid FORMAT Native (stage: Complete) | ||
| 663 | 2025.11.03 21:57:20.629530 [ 142235 ] {555a025f-4cde-43bd-8676-d82fbe39a843} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_uuid | ||
| 664 | 2025.11.03 21:57:20.630585 [ 142235 ] {555a025f-4cde-43bd-8676-d82fbe39a843} <Trace> oximeter.fields_uuid (dd02705b-8713-4681-837a-68ef79db66e0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 665 | 2025.11.03 21:57:20.630623 [ 142235 ] {555a025f-4cde-43bd-8676-d82fbe39a843} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 666 | 2025.11.03 21:57:20.631055 [ 142235 ] {555a025f-4cde-43bd-8676-d82fbe39a843} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 667 | 2025.11.03 21:57:20.631250 [ 142235 ] {555a025f-4cde-43bd-8676-d82fbe39a843} <Trace> oximeter.fields_uuid (dd02705b-8713-4681-837a-68ef79db66e0): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 668 | 2025.11.03 21:57:20.631448 [ 142235 ] {555a025f-4cde-43bd-8676-d82fbe39a843} <Debug> executeQuery: Read 2 rows, 167.00 B in 0.002036 sec., 982.3182711198428 rows/sec., 80.10 KiB/sec. | ||
| 669 | 2025.11.03 21:57:20.631486 [ 142235 ] {555a025f-4cde-43bd-8676-d82fbe39a843} <Debug> TCPHandler: Processed in 0.002397289 sec. | ||
| 670 | 2025.11.03 21:57:20.670447 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 671 | 2025.11.03 21:57:20.670657 [ 142235 ] {43a1a543-806e-4d79-b120-29f516f4b424} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.measurements_cumulativeu64 FORMAT Native (stage: Complete) | ||
| 672 | 2025.11.03 21:57:20.670723 [ 142235 ] {43a1a543-806e-4d79-b120-29f516f4b424} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, start_time, timestamp, datum) ON oximeter.measurements_cumulativeu64 | ||
| 673 | 2025.11.03 21:57:20.671863 [ 142235 ] {43a1a543-806e-4d79-b120-29f516f4b424} <Trace> oximeter.measurements_cumulativeu64 (b772b94e-fef1-4dab-8f9d-ac244c3a3e6d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 674 | 2025.11.03 21:57:20.671892 [ 142235 ] {43a1a543-806e-4d79-b120-29f516f4b424} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 675 | 2025.11.03 21:57:20.672268 [ 142235 ] {43a1a543-806e-4d79-b120-29f516f4b424} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 676 | 2025.11.03 21:57:20.672499 [ 142235 ] {43a1a543-806e-4d79-b120-29f516f4b424} <Trace> oximeter.measurements_cumulativeu64 (b772b94e-fef1-4dab-8f9d-ac244c3a3e6d): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 677 | 2025.11.03 21:57:20.672683 [ 142235 ] {43a1a543-806e-4d79-b120-29f516f4b424} <Debug> executeQuery: Read 1 rows, 72.00 B in 0.002085 sec., 479.6163069544364 rows/sec., 33.72 KiB/sec. | ||
| 678 | 2025.11.03 21:57:20.672719 [ 142235 ] {43a1a543-806e-4d79-b120-29f516f4b424} <Debug> TCPHandler: Processed in 0.00247056 sec. | ||
| 679 | 2025.11.03 21:57:20.673598 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 680 | 2025.11.03 21:57:20.673708 [ 142235 ] {99f40ad4-1c58-4e82-83a5-f5430ac5457c} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 681 | 2025.11.03 21:57:20.673746 [ 142235 ] {99f40ad4-1c58-4e82-83a5-f5430ac5457c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 682 | 2025.11.03 21:57:20.674415 [ 142235 ] {99f40ad4-1c58-4e82-83a5-f5430ac5457c} <Trace> oximeter.measurements_i64 (83b1fa75-e025-4cdf-9312-15232c1d9c3d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 683 | 2025.11.03 21:57:20.674437 [ 142235 ] {99f40ad4-1c58-4e82-83a5-f5430ac5457c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 153.79 GiB. | ||
| 684 | 2025.11.03 21:57:20.674722 [ 142235 ] {99f40ad4-1c58-4e82-83a5-f5430ac5457c} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 685 | 2025.11.03 21:57:20.674876 [ 142235 ] {99f40ad4-1c58-4e82-83a5-f5430ac5457c} <Trace> oximeter.measurements_i64 (83b1fa75-e025-4cdf-9312-15232c1d9c3d): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 686 | 2025.11.03 21:57:20.675013 [ 142235 ] {99f40ad4-1c58-4e82-83a5-f5430ac5457c} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001333 sec., 750.1875468867216 rows/sec., 52.01 KiB/sec. | ||
| 687 | 2025.11.03 21:57:20.675047 [ 142235 ] {99f40ad4-1c58-4e82-83a5-f5430ac5457c} <Debug> TCPHandler: Processed in 0.00151828 sec. | ||
| 688 | 2025.11.03 21:57:21.481207 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 689 | 2025.11.03 21:57:21.481409 [ 142235 ] {0b9e6f14-5bf0-44a0-af63-2f37a94999ea} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 690 | 2025.11.03 21:57:21.481471 [ 142235 ] {0b9e6f14-5bf0-44a0-af63-2f37a94999ea} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 691 | 2025.11.03 21:57:21.490966 [ 142235 ] {0b9e6f14-5bf0-44a0-af63-2f37a94999ea} <Trace> oximeter.fields_string (608d1611-4802-42b0-89a0-2a7f2e4f8f9e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 692 | 2025.11.03 21:57:21.491014 [ 142235 ] {0b9e6f14-5bf0-44a0-af63-2f37a94999ea} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 154.06 GiB. | ||
| 693 | 2025.11.03 21:57:21.491458 [ 142235 ] {0b9e6f14-5bf0-44a0-af63-2f37a94999ea} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 694 | 2025.11.03 21:57:21.491638 [ 142235 ] {0b9e6f14-5bf0-44a0-af63-2f37a94999ea} <Trace> oximeter.fields_string (608d1611-4802-42b0-89a0-2a7f2e4f8f9e): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 695 | 2025.11.03 21:57:21.491823 [ 142235 ] {0b9e6f14-5bf0-44a0-af63-2f37a94999ea} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.010473 sec., 190.9672491167765 rows/sec., 19.77 KiB/sec. | ||
| 696 | 2025.11.03 21:57:21.491874 [ 142235 ] {0b9e6f14-5bf0-44a0-af63-2f37a94999ea} <Debug> TCPHandler: Processed in 0.01086083 sec. | ||
| 697 | 2025.11.03 21:57:21.492773 [ 142235 ] {} <Trace> TCP-Session: 0ea2f6cc-a205-4c9c-9848-044c57311b7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 698 | 2025.11.03 21:57:21.492927 [ 142235 ] {deba3e94-ffb3-4f84-80ab-6450a56c8268} <Debug> executeQuery: (from [::1]:51222) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 699 | 2025.11.03 21:57:21.492980 [ 142235 ] {deba3e94-ffb3-4f84-80ab-6450a56c8268} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 700 | 2025.11.03 21:57:21.493637 [ 142235 ] {deba3e94-ffb3-4f84-80ab-6450a56c8268} <Trace> oximeter.measurements_i64 (83b1fa75-e025-4cdf-9312-15232c1d9c3d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 701 | 2025.11.03 21:57:21.493659 [ 142235 ] {deba3e94-ffb3-4f84-80ab-6450a56c8268} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 154.06 GiB. | ||
| 702 | 2025.11.03 21:57:21.493955 [ 142235 ] {deba3e94-ffb3-4f84-80ab-6450a56c8268} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 703 | 2025.11.03 21:57:21.494148 [ 142235 ] {deba3e94-ffb3-4f84-80ab-6450a56c8268} <Trace> oximeter.measurements_i64 (83b1fa75-e025-4cdf-9312-15232c1d9c3d): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 704 | 2025.11.03 21:57:21.494327 [ 142235 ] {deba3e94-ffb3-4f84-80ab-6450a56c8268} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001448 sec., 690.6077348066298 rows/sec., 47.88 KiB/sec. | ||
| 705 | 2025.11.03 21:57:21.494357 [ 142235 ] {deba3e94-ffb3-4f84-80ab-6450a56c8268} <Debug> TCPHandler: Processed in 0.00174417 sec. | ||