| 1 | 2025.04.01 18:06:00.395731 [ 244493 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2025.04.01 18:06:00.395800 [ 244493 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2025.04.01 18:06:00.467728 [ 244493 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 244493 | ||
| 4 | 2025.04.01 18:06:00.467779 [ 244493 ] {} <Information> Application: starting up | ||
| 5 | 2025.04.01 18:06:00.467792 [ 244493 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2025.04.01 18:06:00.470915 [ 244493 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2025.04.01 18:06:00.484211 [ 244493 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2025.04.01 18:06:00.484248 [ 244493 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2025.04.01 18:06:00.484305 [ 244493 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2025.04.01 18:06:00.484322 [ 244493 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2025.04.01 18:06:00.762823 [ 244493 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2025.04.01 18:06:00.762871 [ 244493 ] {} <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.04.01 18:06:00.771586 [ 244493 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2025.04.01 18:06:00.771615 [ 244493 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2025.04.01 18:06:00.771625 [ 244493 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2025.04.01 18:06:00.771630 [ 244493 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2025.04.01 18:06:00.771656 [ 244493 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/datastore/tmp/ to store temporary data in it | ||
| 18 | 2025.04.01 18:06:00.771957 [ 244493 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2025.04.01 18:06:00.772415 [ 244493 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/config.xml' | ||
| 20 | 2025.04.01 18:06:00.774454 [ 244493 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/config.xml', performing update on configuration | ||
| 21 | 2025.04.01 18:06:00.774849 [ 244493 ] {} <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.04.01 18:06:00.774885 [ 244493 ] {} <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.04.01 18:06:00.774890 [ 244493 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2025.04.01 18:06:00.774925 [ 244493 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2025.04.01 18:06:00.777960 [ 244493 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2025.04.01 18:06:00.782708 [ 244493 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2025.04.01 18:06:00.783332 [ 244493 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2025.04.01 18:06:00.791934 [ 244493 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2025.04.01 18:06:00.792952 [ 244493 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/config.xml', performed update on configuration | ||
| 30 | 2025.04.01 18:06:00.806739 [ 244493 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/config.xml' | ||
| 31 | 2025.04.01 18:06:00.855678 [ 244493 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/config.xml', performing update on configuration | ||
| 32 | 2025.04.01 18:06:00.859192 [ 244493 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/config.xml', performed update on configuration | ||
| 33 | 2025.04.01 18:06:00.859614 [ 244493 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/config.xml | ||
| 34 | 2025.04.01 18:06:00.860266 [ 244493 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2025.04.01 18:06:00.860651 [ 244493 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2025.04.01 18:06:00.861704 [ 244493 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2025.04.01 18:06:00.861974 [ 244493 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2025.04.01 18:06:00.863078 [ 244493 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2025.04.01 18:06:00.865378 [ 244493 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/datastore/ | ||
| 40 | 2025.04.01 18:06:00.866607 [ 244590 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 41 | 2025.04.01 18:06:00.867935 [ 244590 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 42 | 2025.04.01 18:06:00.882702 [ 244493 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2025.04.01 18:06:00.882731 [ 244493 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000104851 sec | ||
| 44 | 2025.04.01 18:06:00.882738 [ 244493 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2025.04.01 18:06:00.882743 [ 244493 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2025.04.01 18:06:00.882782 [ 244493 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2025.04.01 18:06:00.882799 [ 244493 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2025.04.01 18:06:00.883750 [ 244493 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2025.04.01 18:06:00.883768 [ 244493 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2025.04.01 18:06:00.883775 [ 244493 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2025.04.01 18:06:00.883781 [ 244493 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2025.04.01 18:06:00.883787 [ 244493 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2025.04.01 18:06:00.883795 [ 244493 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 54 | 2025.04.01 18:06:00.885976 [ 244493 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2025.04.01 18:06:00.885993 [ 244493 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2025.04.01 18:06:00.886011 [ 244493 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 57 | 2025.04.01 18:06:00.886173 [ 244493 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2025.04.01 18:06:00.886198 [ 244493 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2025.04.01 18:06:00.886206 [ 244493 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2025.04.01 18:06:00.886213 [ 244493 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2025.04.01 18:06:00.886220 [ 244493 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2025.04.01 18:06:00.886227 [ 244493 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2025.04.01 18:06:00.886234 [ 244493 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2025.04.01 18:06:00.954802 [ 244493 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2025.04.01 18:06:00.959052 [ 244493 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2025.04.01 18:06:00.959079 [ 244493 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.649e-05 sec | ||
| 67 | 2025.04.01 18:06:00.959088 [ 244493 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2025.04.01 18:06:00.959093 [ 244493 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2025.04.01 18:06:00.959122 [ 244493 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2025.04.01 18:06:00.959253 [ 244493 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all_output-46de5ff2794a4264-test_omdb_success_cases.244445.1-clickhouse-zulOLh/datastore/user_defined/ | ||
| 71 | 2025.04.01 18:06:00.959287 [ 244493 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2025.04.01 18:06:00.959294 [ 244493 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2025.04.01 18:06:00.959317 [ 244493 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2025.04.01 18:06:00.959324 [ 244493 ] {} <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.04.01 18:06:00.959411 [ 244493 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 36105 | ||
| 76 | 2025.04.01 18:06:00.959463 [ 244493 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44311 | ||
| 77 | 2025.04.01 18:06:00.959650 [ 244493 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44671 | ||
| 78 | 2025.04.01 18:06:00.959693 [ 244493 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34363 | ||
| 79 | 2025.04.01 18:06:00.959717 [ 244493 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2025.04.01 18:06:00.960111 [ 244493 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.64 MiB, peak 20.64 MiB, free memory in arenas 21.29 MiB, will set to 387.45 MiB (RSS), difference: 366.82 MiB | ||
| 81 | 2025.04.01 18:06:00.962892 [ 244493 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.315e-05 sec. | ||
| 82 | 2025.04.01 18:06:00.964445 [ 244493 ] {} <Information> Application: Listening for http://[::1]:36105 | ||
| 83 | 2025.04.01 18:06:00.964491 [ 244493 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:44311 | ||
| 84 | 2025.04.01 18:06:00.964529 [ 244493 ] {} <Information> Application: Listening for http://127.0.0.1:44671 | ||
| 85 | 2025.04.01 18:06:00.964564 [ 244493 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:34363 | ||
| 86 | 2025.04.01 18:06:00.968486 [ 244493 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2025.04.01 18:06:01.679344 [ 244503 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53310 | ||
| 88 | 2025.04.01 18:06:01.679450 [ 244503 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2025.04.01 18:06:01.679477 [ 244503 ] {} <Debug> TCP-Session: d5dd60a1-3454-4b86-ab9b-2bf50833e226 Authenticating user 'default' from [::1]:53310 | ||
| 90 | 2025.04.01 18:06:01.679493 [ 244503 ] {} <Debug> TCP-Session: d5dd60a1-3454-4b86-ab9b-2bf50833e226 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2025.04.01 18:06:01.679499 [ 244503 ] {} <Debug> TCP-Session: d5dd60a1-3454-4b86-ab9b-2bf50833e226 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2025.04.01 18:06:01.679607 [ 244503 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2025.04.01 18:06:01.679632 [ 244503 ] {} <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.04.01 18:06:01.679641 [ 244503 ] {} <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.04.01 18:06:01.680556 [ 244504 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53312 | ||
| 96 | 2025.04.01 18:06:01.680618 [ 244505 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53314 | ||
| 97 | 2025.04.01 18:06:01.680853 [ 244876 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53316 | ||
| 98 | 2025.04.01 18:06:01.681859 [ 244504 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 99 | 2025.04.01 18:06:01.681892 [ 244504 ] {} <Debug> TCP-Session: 34b5b8ee-5366-4f8b-8a98-d97571a3e6d9 Authenticating user 'default' from [::1]:53312 | ||
| 100 | 2025.04.01 18:06:01.681906 [ 244504 ] {} <Debug> TCP-Session: 34b5b8ee-5366-4f8b-8a98-d97571a3e6d9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 101 | 2025.04.01 18:06:01.681913 [ 244504 ] {} <Debug> TCP-Session: 34b5b8ee-5366-4f8b-8a98-d97571a3e6d9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 102 | 2025.04.01 18:06:01.682463 [ 244505 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 103 | 2025.04.01 18:06:01.682496 [ 244505 ] {} <Debug> TCP-Session: c3f6b183-822d-45c8-9ce8-727270667b19 Authenticating user 'default' from [::1]:53314 | ||
| 104 | 2025.04.01 18:06:01.682507 [ 244505 ] {} <Debug> TCP-Session: c3f6b183-822d-45c8-9ce8-727270667b19 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2025.04.01 18:06:01.682514 [ 244505 ] {} <Debug> TCP-Session: c3f6b183-822d-45c8-9ce8-727270667b19 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 106 | 2025.04.01 18:06:01.682665 [ 244876 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2025.04.01 18:06:01.682693 [ 244876 ] {} <Debug> TCP-Session: 5a1d94c2-5690-4966-bfaf-51d600e3cd7e Authenticating user 'default' from [::1]:53316 | ||
| 108 | 2025.04.01 18:06:01.682709 [ 244876 ] {} <Debug> TCP-Session: 5a1d94c2-5690-4966-bfaf-51d600e3cd7e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2025.04.01 18:06:01.682716 [ 244876 ] {} <Debug> TCP-Session: 5a1d94c2-5690-4966-bfaf-51d600e3cd7e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2025.04.01 18:06:01.704164 [ 244878 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53320 | ||
| 111 | 2025.04.01 18:06:01.704284 [ 244878 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 112 | 2025.04.01 18:06:01.704312 [ 244878 ] {} <Debug> TCP-Session: e28e7a1b-8bf0-49db-b1d7-aaa0c488bd06 Authenticating user 'default' from [::1]:53320 | ||
| 113 | 2025.04.01 18:06:01.704329 [ 244878 ] {} <Debug> TCP-Session: e28e7a1b-8bf0-49db-b1d7-aaa0c488bd06 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 114 | 2025.04.01 18:06:01.704336 [ 244878 ] {} <Debug> TCP-Session: e28e7a1b-8bf0-49db-b1d7-aaa0c488bd06 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 115 | 2025.04.01 18:06:01.720870 [ 244877 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53318 | ||
| 116 | 2025.04.01 18:06:01.720993 [ 244877 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 117 | 2025.04.01 18:06:01.721029 [ 244877 ] {} <Debug> TCP-Session: 79f731a8-d8cf-4966-91be-da726543c88d Authenticating user 'default' from [::1]:53318 | ||
| 118 | 2025.04.01 18:06:01.721049 [ 244877 ] {} <Debug> TCP-Session: 79f731a8-d8cf-4966-91be-da726543c88d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 119 | 2025.04.01 18:06:01.721057 [ 244877 ] {} <Debug> TCP-Session: 79f731a8-d8cf-4966-91be-da726543c88d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 120 | 2025.04.01 18:06:01.721205 [ 244888 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53324 | ||
| 121 | 2025.04.01 18:06:01.721284 [ 244888 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 122 | 2025.04.01 18:06:01.721390 [ 244887 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53322 | ||
| 123 | 2025.04.01 18:06:01.721470 [ 244887 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 124 | 2025.04.01 18:06:01.721494 [ 244887 ] {} <Debug> TCP-Session: b65ca276-10bf-4ac3-8aaf-09a6e772915d Authenticating user 'default' from [::1]:53322 | ||
| 125 | 2025.04.01 18:06:01.721505 [ 244887 ] {} <Debug> TCP-Session: b65ca276-10bf-4ac3-8aaf-09a6e772915d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 126 | 2025.04.01 18:06:01.721512 [ 244887 ] {} <Debug> TCP-Session: b65ca276-10bf-4ac3-8aaf-09a6e772915d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 127 | 2025.04.01 18:06:01.721309 [ 244888 ] {} <Debug> TCP-Session: e0d7f36d-e0a9-47d2-92dc-4b74fa9c78e5 Authenticating user 'default' from [::1]:53324 | ||
| 128 | 2025.04.01 18:06:01.721608 [ 244888 ] {} <Debug> TCP-Session: e0d7f36d-e0a9-47d2-92dc-4b74fa9c78e5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2025.04.01 18:06:01.721614 [ 244888 ] {} <Debug> TCP-Session: e0d7f36d-e0a9-47d2-92dc-4b74fa9c78e5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2025.04.01 18:06:08.386644 [ 244755 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1958 entries to flush up to offset 1958 | ||
| 131 | 2025.04.01 18:06:08.386729 [ 244755 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 132 | 2025.04.01 18:06:08.387730 [ 244755 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 133 | 2025.04.01 18:06:08.386646 [ 244758 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 134 | 2025.04.01 18:06:08.387978 [ 244758 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 135 | 2025.04.01 18:06:08.395596 [ 244755 ] {} <Debug> system.asynchronous_metric_log (9d2f8a89-c408-4630-abce-92a5bfd6f0d3): Loading data parts | ||
| 136 | 2025.04.01 18:06:08.395961 [ 244755 ] {} <Debug> system.asynchronous_metric_log (9d2f8a89-c408-4630-abce-92a5bfd6f0d3): There are no data parts | ||
| 137 | 2025.04.01 18:06:08.403935 [ 244755 ] {} <Trace> system.asynchronous_metric_log (9d2f8a89-c408-4630-abce-92a5bfd6f0d3): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 138 | 2025.04.01 18:06:08.404846 [ 244755 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.10 GiB. | ||
| 139 | 2025.04.01 18:06:08.404615 [ 244758 ] {} <Debug> system.metric_log (1cf940e2-9b2b-43c4-beb6-acbbea69f953): Loading data parts | ||
| 140 | 2025.04.01 18:06:08.405242 [ 244758 ] {} <Debug> system.metric_log (1cf940e2-9b2b-43c4-beb6-acbbea69f953): There are no data parts | ||
| 141 | 2025.04.01 18:06:08.405879 [ 244755 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 142 | 2025.04.01 18:06:08.406147 [ 244755 ] {} <Trace> system.asynchronous_metric_log (9d2f8a89-c408-4630-abce-92a5bfd6f0d3): 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.04.01 18:06:08.406362 [ 244755 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1958 | ||
| 144 | 2025.04.01 18:06:08.445495 [ 244758 ] {} <Trace> system.metric_log (1cf940e2-9b2b-43c4-beb6-acbbea69f953): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 145 | 2025.04.01 18:06:08.445544 [ 244758 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.10 GiB. | ||
| 146 | 2025.04.01 18:06:08.464359 [ 244758 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 147 | 2025.04.01 18:06:08.465293 [ 244758 ] {} <Trace> system.metric_log (1cf940e2-9b2b-43c4-beb6-acbbea69f953): 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.04.01 18:06:08.468634 [ 244758 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 149 | 2025.04.01 18:06:09.001232 [ 244768 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 393.31 MiB, peak 397.31 MiB, free memory in arenas 35.68 MiB, will set to 400.78 MiB (RSS), difference: 7.48 MiB | ||
| 150 | 2025.04.01 18:06:10.332125 [ 245253 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53326 | ||
| 151 | 2025.04.01 18:06:10.332235 [ 245253 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 152 | 2025.04.01 18:06:10.332265 [ 245253 ] {} <Debug> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Authenticating user 'default' from [::1]:53326 | ||
| 153 | 2025.04.01 18:06:10.332284 [ 245253 ] {} <Debug> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2025.04.01 18:06:10.332290 [ 245253 ] {} <Debug> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 155 | 2025.04.01 18:06:10.343567 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 156 | 2025.04.01 18:06:10.343846 [ 245253 ] {c837ff69-34a7-4a07-b362-be57558b2ef1} <Debug> executeQuery: (from [::1]:53326) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 157 | 2025.04.01 18:06:10.344555 [ 245253 ] {c837ff69-34a7-4a07-b362-be57558b2ef1} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:53326) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 158 | |||
| 159 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 160 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 161 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 162 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 163 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 164 | 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 | ||
| 165 | 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 | ||
| 166 | 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 | ||
| 167 | 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 | ||
| 168 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 171 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 172 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 173 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 174 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 175 | 16. ? @ 0x00007ff64a4d8ac3 in ? | ||
| 176 | 17. ? @ 0x00007ff64a56a850 in ? | ||
| 177 | |||
| 178 | 2025.04.01 18:06:10.344689 [ 245253 ] {c837ff69-34a7-4a07-b362-be57558b2ef1} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 179 | |||
| 180 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 181 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 182 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 183 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 184 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 185 | 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 | ||
| 186 | 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 | ||
| 187 | 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 | ||
| 188 | 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 | ||
| 189 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 195 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 16. ? @ 0x00007ff64a4d8ac3 in ? | ||
| 197 | 17. ? @ 0x00007ff64a56a850 in ? | ||
| 198 | |||
| 199 | 2025.04.01 18:06:10.344739 [ 245253 ] {c837ff69-34a7-4a07-b362-be57558b2ef1} <Debug> TCPHandler: Processed in 0.001394062 sec. | ||
| 200 | 2025.04.01 18:06:10.349590 [ 245266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53330 | ||
| 201 | 2025.04.01 18:06:10.349739 [ 245266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 202 | 2025.04.01 18:06:10.351127 [ 245266 ] {} <Debug> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Authenticating user 'default' from [::1]:53330 | ||
| 203 | 2025.04.01 18:06:10.351150 [ 245266 ] {} <Debug> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 204 | 2025.04.01 18:06:10.351157 [ 245266 ] {} <Debug> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 205 | 2025.04.01 18:06:10.351493 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 206 | 2025.04.01 18:06:10.351706 [ 245253 ] {434bb176-da3c-4b2e-a989-f7c0913cfbfe} <Debug> executeQuery: (from [::1]:53326) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 207 | 2025.04.01 18:06:10.351856 [ 245268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53338 | ||
| 208 | 2025.04.01 18:06:10.352787 [ 245268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 209 | 2025.04.01 18:06:10.352815 [ 245268 ] {} <Debug> TCP-Session: d8e81472-3a0c-4509-ac26-2e7bd1442b7f Authenticating user 'default' from [::1]:53338 | ||
| 210 | 2025.04.01 18:06:10.352828 [ 245268 ] {} <Debug> TCP-Session: d8e81472-3a0c-4509-ac26-2e7bd1442b7f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 211 | 2025.04.01 18:06:10.352835 [ 245268 ] {} <Debug> TCP-Session: d8e81472-3a0c-4509-ac26-2e7bd1442b7f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 212 | 2025.04.01 18:06:10.352121 [ 245269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53340 | ||
| 213 | 2025.04.01 18:06:10.353112 [ 245269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 214 | 2025.04.01 18:06:10.353137 [ 245269 ] {} <Debug> TCP-Session: 311f3ffe-8bd4-4192-891a-e18f172e6798 Authenticating user 'default' from [::1]:53340 | ||
| 215 | 2025.04.01 18:06:10.353147 [ 245269 ] {} <Debug> TCP-Session: 311f3ffe-8bd4-4192-891a-e18f172e6798 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 216 | 2025.04.01 18:06:10.353158 [ 245269 ] {} <Debug> TCP-Session: 311f3ffe-8bd4-4192-891a-e18f172e6798 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 217 | 2025.04.01 18:06:10.353303 [ 245253 ] {434bb176-da3c-4b2e-a989-f7c0913cfbfe} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:53326) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 218 | |||
| 219 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 220 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 221 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 222 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 223 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 224 | 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 | ||
| 225 | 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 | ||
| 226 | 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 | ||
| 227 | 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 | ||
| 228 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 229 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 230 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 231 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 232 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 233 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 234 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 235 | 16. ? @ 0x00007ff64a4d8ac3 in ? | ||
| 236 | 17. ? @ 0x00007ff64a56a850 in ? | ||
| 237 | |||
| 238 | 2025.04.01 18:06:10.353423 [ 245253 ] {434bb176-da3c-4b2e-a989-f7c0913cfbfe} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 239 | |||
| 240 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 241 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 242 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 243 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 244 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 245 | 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 | ||
| 246 | 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 | ||
| 247 | 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 | ||
| 248 | 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 | ||
| 249 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 250 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 251 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 252 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 253 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 254 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 255 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 256 | 16. ? @ 0x00007ff64a4d8ac3 in ? | ||
| 257 | 17. ? @ 0x00007ff64a56a850 in ? | ||
| 258 | |||
| 259 | 2025.04.01 18:06:10.353472 [ 245253 ] {434bb176-da3c-4b2e-a989-f7c0913cfbfe} <Debug> TCPHandler: Processed in 0.002139443 sec. | ||
| 260 | 2025.04.01 18:06:10.358661 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 261 | 2025.04.01 18:06:10.358879 [ 245266 ] {6afb6233-46ff-46fb-ba5a-26e6c2bce2e7} <Debug> executeQuery: (from [::1]:53330) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 262 | 2025.04.01 18:06:10.364471 [ 245265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53332 | ||
| 263 | 2025.04.01 18:06:10.364864 [ 245266 ] {6afb6233-46ff-46fb-ba5a-26e6c2bce2e7} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 264 | 2025.04.01 18:06:10.364879 [ 245265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 265 | 2025.04.01 18:06:10.364908 [ 245265 ] {} <Debug> TCP-Session: 799e6298-d3d6-4b0d-a342-e26c3d0cb990 Authenticating user 'default' from [::1]:53332 | ||
| 266 | 2025.04.01 18:06:10.364926 [ 245265 ] {} <Debug> TCP-Session: 799e6298-d3d6-4b0d-a342-e26c3d0cb990 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 267 | 2025.04.01 18:06:10.364932 [ 245265 ] {} <Debug> TCP-Session: 799e6298-d3d6-4b0d-a342-e26c3d0cb990 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 268 | 2025.04.01 18:06:10.365757 [ 245267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53336 | ||
| 269 | 2025.04.01 18:06:10.365861 [ 245267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 270 | 2025.04.01 18:06:10.368768 [ 245267 ] {} <Debug> TCP-Session: 081d71fa-86e4-4109-ab9e-9db516047326 Authenticating user 'default' from [::1]:53336 | ||
| 271 | 2025.04.01 18:06:10.368793 [ 245267 ] {} <Debug> TCP-Session: 081d71fa-86e4-4109-ab9e-9db516047326 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 272 | 2025.04.01 18:06:10.368802 [ 245267 ] {} <Debug> TCP-Session: 081d71fa-86e4-4109-ab9e-9db516047326 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2025.04.01 18:06:10.364535 [ 245272 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53346 | ||
| 274 | 2025.04.01 18:06:10.365989 [ 245263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53328 | ||
| 275 | 2025.04.01 18:06:10.365998 [ 245271 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53344 | ||
| 276 | 2025.04.01 18:06:10.369299 [ 245272 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 277 | 2025.04.01 18:06:10.369336 [ 245272 ] {} <Debug> TCP-Session: 34c6d3ee-329b-42c4-ab95-154031fd0d40 Authenticating user 'default' from [::1]:53346 | ||
| 278 | 2025.04.01 18:06:10.369352 [ 245272 ] {} <Debug> TCP-Session: 34c6d3ee-329b-42c4-ab95-154031fd0d40 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2025.04.01 18:06:10.369358 [ 245272 ] {} <Debug> TCP-Session: 34c6d3ee-329b-42c4-ab95-154031fd0d40 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 280 | 2025.04.01 18:06:10.364483 [ 245270 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:53342 | ||
| 281 | 2025.04.01 18:06:10.369294 [ 245263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 282 | 2025.04.01 18:06:10.369400 [ 245271 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 283 | 2025.04.01 18:06:10.369458 [ 245263 ] {} <Debug> TCP-Session: 68fc19ce-96ec-4e6c-8f81-925d01b0a393 Authenticating user 'default' from [::1]:53328 | ||
| 284 | 2025.04.01 18:06:10.369470 [ 245263 ] {} <Debug> TCP-Session: 68fc19ce-96ec-4e6c-8f81-925d01b0a393 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 285 | 2025.04.01 18:06:10.369477 [ 245263 ] {} <Debug> TCP-Session: 68fc19ce-96ec-4e6c-8f81-925d01b0a393 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 286 | 2025.04.01 18:06:10.369494 [ 245271 ] {} <Debug> TCP-Session: db476806-a2a1-41a8-aae3-3b113c56e1dd Authenticating user 'default' from [::1]:53344 | ||
| 287 | 2025.04.01 18:06:10.369506 [ 245271 ] {} <Debug> TCP-Session: db476806-a2a1-41a8-aae3-3b113c56e1dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2025.04.01 18:06:10.369512 [ 245271 ] {} <Debug> TCP-Session: db476806-a2a1-41a8-aae3-3b113c56e1dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 289 | 2025.04.01 18:06:10.369531 [ 245270 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 290 | 2025.04.01 18:06:10.369559 [ 245270 ] {} <Debug> TCP-Session: 81df27bb-80f0-4050-8d87-f4726b732fa3 Authenticating user 'default' from [::1]:53342 | ||
| 291 | 2025.04.01 18:06:10.369559 [ 245263 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 292 | 2025.04.01 18:06:10.369582 [ 245270 ] {} <Debug> TCP-Session: 81df27bb-80f0-4050-8d87-f4726b732fa3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2025.04.01 18:06:10.369622 [ 245270 ] {} <Debug> TCP-Session: 81df27bb-80f0-4050-8d87-f4726b732fa3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2025.04.01 18:06:10.369624 [ 245263 ] {} <Debug> TCP-Session: 68fc19ce-96ec-4e6c-8f81-925d01b0a393 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2025.04.01 18:06:10.370847 [ 245266 ] {6afb6233-46ff-46fb-ba5a-26e6c2bce2e7} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 296 | 2025.04.01 18:06:10.370864 [ 245266 ] {6afb6233-46ff-46fb-ba5a-26e6c2bce2e7} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.899e-05 sec | ||
| 297 | 2025.04.01 18:06:10.370878 [ 245266 ] {6afb6233-46ff-46fb-ba5a-26e6c2bce2e7} <Trace> ReferentialDeps: No tables | ||
| 298 | 2025.04.01 18:06:10.370884 [ 245266 ] {6afb6233-46ff-46fb-ba5a-26e6c2bce2e7} <Trace> LoadingDeps: No tables | ||
| 299 | 2025.04.01 18:06:10.370909 [ 245266 ] {6afb6233-46ff-46fb-ba5a-26e6c2bce2e7} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 300 | 2025.04.01 18:06:10.370981 [ 245266 ] {6afb6233-46ff-46fb-ba5a-26e6c2bce2e7} <Debug> TCPHandler: Processed in 0.012509258 sec. | ||
| 301 | 2025.04.01 18:06:10.385515 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 302 | 2025.04.01 18:06:10.385776 [ 245266 ] {263ca391-6a2d-49ac-9f54-99175c4cffd8} <Debug> executeQuery: (from [::1]:53330) /* The version table contains metadata about the `oximeter` database */ | ||
| 303 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 304 | 2025.04.01 18:06:10.385851 [ 245266 ] {263ca391-6a2d-49ac-9f54-99175c4cffd8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 305 | 2025.04.01 18:06:10.391018 [ 245266 ] {263ca391-6a2d-49ac-9f54-99175c4cffd8} <Debug> oximeter.version (554c19e9-eb95-4c3f-8044-6dfa2ddc1b65): Loading data parts | ||
| 306 | 2025.04.01 18:06:10.391277 [ 245266 ] {263ca391-6a2d-49ac-9f54-99175c4cffd8} <Debug> oximeter.version (554c19e9-eb95-4c3f-8044-6dfa2ddc1b65): There are no data parts | ||
| 307 | 2025.04.01 18:06:10.395165 [ 245266 ] {263ca391-6a2d-49ac-9f54-99175c4cffd8} <Debug> TCPHandler: Processed in 0.009825325 sec. | ||
| 308 | 2025.04.01 18:06:10.395778 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 309 | 2025.04.01 18:06:10.396047 [ 245266 ] {1fc96bec-4cd1-4334-9076-cbddfaec0758} <Debug> executeQuery: (from [::1]:53330) /* The measurement tables contain all individual samples from each timeseries. | ||
| 310 | * | ||
| 311 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 312 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 313 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 314 | * by all samples from the same timeseries. | ||
| 315 | * | ||
| 316 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 317 | * and then uses that to index quickly into the measurements tables. | ||
| 318 | */ | ||
| 319 | 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) | ||
| 320 | 2025.04.01 18:06:10.396101 [ 245266 ] {1fc96bec-4cd1-4334-9076-cbddfaec0758} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 321 | 2025.04.01 18:06:10.403582 [ 245266 ] {1fc96bec-4cd1-4334-9076-cbddfaec0758} <Debug> oximeter.measurements_bool (e72f9476-262f-4a6e-a409-c9d9a0b4c75b): Loading data parts | ||
| 322 | 2025.04.01 18:06:10.403858 [ 245266 ] {1fc96bec-4cd1-4334-9076-cbddfaec0758} <Debug> oximeter.measurements_bool (e72f9476-262f-4a6e-a409-c9d9a0b4c75b): There are no data parts | ||
| 323 | 2025.04.01 18:06:10.409499 [ 245266 ] {1fc96bec-4cd1-4334-9076-cbddfaec0758} <Debug> TCPHandler: Processed in 0.01388481 sec. | ||
| 324 | 2025.04.01 18:06:10.413600 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 325 | 2025.04.01 18:06:10.413943 [ 245266 ] {b9e48c1a-21d4-4bef-aa97-1944e2ad10b7} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 326 | 2025.04.01 18:06:10.414873 [ 245266 ] {b9e48c1a-21d4-4bef-aa97-1944e2ad10b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 327 | 2025.04.01 18:06:10.421021 [ 245266 ] {b9e48c1a-21d4-4bef-aa97-1944e2ad10b7} <Debug> oximeter.measurements_i8 (0895d390-082c-441f-a859-de4d5396e707): Loading data parts | ||
| 328 | 2025.04.01 18:06:10.421294 [ 245266 ] {b9e48c1a-21d4-4bef-aa97-1944e2ad10b7} <Debug> oximeter.measurements_i8 (0895d390-082c-441f-a859-de4d5396e707): There are no data parts | ||
| 329 | 2025.04.01 18:06:10.426984 [ 245266 ] {b9e48c1a-21d4-4bef-aa97-1944e2ad10b7} <Debug> TCPHandler: Processed in 0.013576599 sec. | ||
| 330 | 2025.04.01 18:06:10.427474 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 331 | 2025.04.01 18:06:10.427781 [ 245266 ] {f57f8644-f9ef-4264-9e57-7e3c34c60b77} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 332 | 2025.04.01 18:06:10.427839 [ 245266 ] {f57f8644-f9ef-4264-9e57-7e3c34c60b77} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 333 | 2025.04.01 18:06:10.433907 [ 245266 ] {f57f8644-f9ef-4264-9e57-7e3c34c60b77} <Debug> oximeter.measurements_u8 (b11b394e-cdda-46a9-95e0-b346d6fbf6b2): Loading data parts | ||
| 334 | 2025.04.01 18:06:10.434247 [ 245266 ] {f57f8644-f9ef-4264-9e57-7e3c34c60b77} <Debug> oximeter.measurements_u8 (b11b394e-cdda-46a9-95e0-b346d6fbf6b2): There are no data parts | ||
| 335 | 2025.04.01 18:06:10.439527 [ 245266 ] {f57f8644-f9ef-4264-9e57-7e3c34c60b77} <Debug> TCPHandler: Processed in 0.012232007 sec. | ||
| 336 | 2025.04.01 18:06:10.440740 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 337 | 2025.04.01 18:06:10.441036 [ 245266 ] {8850e270-3234-403b-a4a0-410ec74c77e9} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 338 | 2025.04.01 18:06:10.443447 [ 245266 ] {8850e270-3234-403b-a4a0-410ec74c77e9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 339 | 2025.04.01 18:06:10.448986 [ 245266 ] {8850e270-3234-403b-a4a0-410ec74c77e9} <Debug> oximeter.measurements_i16 (81af611a-cf24-4c3c-a707-3566d1658030): Loading data parts | ||
| 340 | 2025.04.01 18:06:10.449234 [ 245266 ] {8850e270-3234-403b-a4a0-410ec74c77e9} <Debug> oximeter.measurements_i16 (81af611a-cf24-4c3c-a707-3566d1658030): There are no data parts | ||
| 341 | 2025.04.01 18:06:10.454842 [ 245266 ] {8850e270-3234-403b-a4a0-410ec74c77e9} <Debug> TCPHandler: Processed in 0.01429933 sec. | ||
| 342 | 2025.04.01 18:06:10.455478 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 343 | 2025.04.01 18:06:10.455804 [ 245266 ] {ea484e22-826f-4916-8048-8b706bd65057} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 344 | 2025.04.01 18:06:10.457404 [ 245266 ] {ea484e22-826f-4916-8048-8b706bd65057} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 345 | 2025.04.01 18:06:10.463397 [ 245266 ] {ea484e22-826f-4916-8048-8b706bd65057} <Debug> oximeter.measurements_u16 (a3a33b9f-a315-4056-a5b9-56765b9db819): Loading data parts | ||
| 346 | 2025.04.01 18:06:10.465279 [ 245266 ] {ea484e22-826f-4916-8048-8b706bd65057} <Debug> oximeter.measurements_u16 (a3a33b9f-a315-4056-a5b9-56765b9db819): There are no data parts | ||
| 347 | 2025.04.01 18:06:10.471015 [ 245266 ] {ea484e22-826f-4916-8048-8b706bd65057} <Debug> TCPHandler: Processed in 0.015621303 sec. | ||
| 348 | 2025.04.01 18:06:10.472515 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 349 | 2025.04.01 18:06:10.472816 [ 245266 ] {99abe2ba-5bfa-49ea-b96a-f2940d880c4a} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 350 | 2025.04.01 18:06:10.474220 [ 245266 ] {99abe2ba-5bfa-49ea-b96a-f2940d880c4a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 351 | 2025.04.01 18:06:10.479694 [ 245266 ] {99abe2ba-5bfa-49ea-b96a-f2940d880c4a} <Debug> oximeter.measurements_i32 (796a4b85-701b-4cf7-87ca-8178d1648f4b): Loading data parts | ||
| 352 | 2025.04.01 18:06:10.480050 [ 245266 ] {99abe2ba-5bfa-49ea-b96a-f2940d880c4a} <Debug> oximeter.measurements_i32 (796a4b85-701b-4cf7-87ca-8178d1648f4b): There are no data parts | ||
| 353 | 2025.04.01 18:06:10.484395 [ 245266 ] {99abe2ba-5bfa-49ea-b96a-f2940d880c4a} <Debug> TCPHandler: Processed in 0.012057887 sec. | ||
| 354 | 2025.04.01 18:06:10.484996 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 355 | 2025.04.01 18:06:10.485275 [ 245266 ] {0bd7c41e-3925-4c87-a33a-1996fd5be3a8} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 356 | 2025.04.01 18:06:10.485329 [ 245266 ] {0bd7c41e-3925-4c87-a33a-1996fd5be3a8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 357 | 2025.04.01 18:06:10.501826 [ 245266 ] {0bd7c41e-3925-4c87-a33a-1996fd5be3a8} <Debug> oximeter.measurements_u32 (22d21c44-2abe-48e4-844f-b6a0dbb899f5): Loading data parts | ||
| 358 | 2025.04.01 18:06:10.508296 [ 245266 ] {0bd7c41e-3925-4c87-a33a-1996fd5be3a8} <Debug> oximeter.measurements_u32 (22d21c44-2abe-48e4-844f-b6a0dbb899f5): There are no data parts | ||
| 359 | 2025.04.01 18:06:10.515929 [ 245266 ] {0bd7c41e-3925-4c87-a33a-1996fd5be3a8} <Debug> TCPHandler: Processed in 0.031114044 sec. | ||
| 360 | 2025.04.01 18:06:10.516700 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 361 | 2025.04.01 18:06:10.517004 [ 245266 ] {0dc44b5a-4fb2-4c0b-b252-dd969db84499} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 362 | 2025.04.01 18:06:10.517058 [ 245266 ] {0dc44b5a-4fb2-4c0b-b252-dd969db84499} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 363 | 2025.04.01 18:06:10.524204 [ 245266 ] {0dc44b5a-4fb2-4c0b-b252-dd969db84499} <Debug> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Loading data parts | ||
| 364 | 2025.04.01 18:06:10.524511 [ 245266 ] {0dc44b5a-4fb2-4c0b-b252-dd969db84499} <Debug> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): There are no data parts | ||
| 365 | 2025.04.01 18:06:10.530360 [ 245266 ] {0dc44b5a-4fb2-4c0b-b252-dd969db84499} <Debug> TCPHandler: Processed in 0.01385897 sec. | ||
| 366 | 2025.04.01 18:06:10.530932 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 367 | 2025.04.01 18:06:10.531231 [ 245266 ] {9f90bdfc-6818-4bb5-a3f3-e67aad148d54} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 368 | 2025.04.01 18:06:10.531283 [ 245266 ] {9f90bdfc-6818-4bb5-a3f3-e67aad148d54} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 369 | 2025.04.01 18:06:10.536374 [ 245266 ] {9f90bdfc-6818-4bb5-a3f3-e67aad148d54} <Debug> oximeter.measurements_u64 (56dc4de3-dac7-436f-8ae7-1fde39d34155): Loading data parts | ||
| 370 | 2025.04.01 18:06:10.536643 [ 245266 ] {9f90bdfc-6818-4bb5-a3f3-e67aad148d54} <Debug> oximeter.measurements_u64 (56dc4de3-dac7-436f-8ae7-1fde39d34155): There are no data parts | ||
| 371 | 2025.04.01 18:06:10.541783 [ 245266 ] {9f90bdfc-6818-4bb5-a3f3-e67aad148d54} <Debug> TCPHandler: Processed in 0.011026175 sec. | ||
| 372 | 2025.04.01 18:06:10.542390 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 373 | 2025.04.01 18:06:10.542681 [ 245266 ] {26033755-1bc4-4973-b179-d8b8d9faa88c} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 374 | 2025.04.01 18:06:10.542733 [ 245266 ] {26033755-1bc4-4973-b179-d8b8d9faa88c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 375 | 2025.04.01 18:06:10.547527 [ 245266 ] {26033755-1bc4-4973-b179-d8b8d9faa88c} <Debug> oximeter.measurements_f32 (59b0b50e-b51a-4edc-a519-13722c5db3b9): Loading data parts | ||
| 376 | 2025.04.01 18:06:10.547838 [ 245266 ] {26033755-1bc4-4973-b179-d8b8d9faa88c} <Debug> oximeter.measurements_f32 (59b0b50e-b51a-4edc-a519-13722c5db3b9): There are no data parts | ||
| 377 | 2025.04.01 18:06:10.553091 [ 245266 ] {26033755-1bc4-4973-b179-d8b8d9faa88c} <Debug> TCPHandler: Processed in 0.010890316 sec. | ||
| 378 | 2025.04.01 18:06:10.554070 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 379 | 2025.04.01 18:06:10.554316 [ 245266 ] {1486e06f-9fa4-44b1-b151-9dac4cccd318} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 380 | 2025.04.01 18:06:10.554363 [ 245266 ] {1486e06f-9fa4-44b1-b151-9dac4cccd318} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 381 | 2025.04.01 18:06:10.559398 [ 245266 ] {1486e06f-9fa4-44b1-b151-9dac4cccd318} <Debug> oximeter.measurements_f64 (4eb0cb1e-d649-4346-b418-8f6fcbfe2fe7): Loading data parts | ||
| 382 | 2025.04.01 18:06:10.559737 [ 245266 ] {1486e06f-9fa4-44b1-b151-9dac4cccd318} <Debug> oximeter.measurements_f64 (4eb0cb1e-d649-4346-b418-8f6fcbfe2fe7): There are no data parts | ||
| 383 | 2025.04.01 18:06:10.567013 [ 245266 ] {1486e06f-9fa4-44b1-b151-9dac4cccd318} <Debug> TCPHandler: Processed in 0.013532399 sec. | ||
| 384 | 2025.04.01 18:06:10.567682 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 385 | 2025.04.01 18:06:10.568007 [ 245266 ] {db8e6043-9393-4d02-84ba-8dc8817be60f} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 386 | 2025.04.01 18:06:10.568058 [ 245266 ] {db8e6043-9393-4d02-84ba-8dc8817be60f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 387 | 2025.04.01 18:06:10.572496 [ 245266 ] {db8e6043-9393-4d02-84ba-8dc8817be60f} <Debug> oximeter.measurements_string (87ca7a89-ebc1-40a0-a084-17028919ba20): Loading data parts | ||
| 388 | 2025.04.01 18:06:10.572748 [ 245266 ] {db8e6043-9393-4d02-84ba-8dc8817be60f} <Debug> oximeter.measurements_string (87ca7a89-ebc1-40a0-a084-17028919ba20): There are no data parts | ||
| 389 | 2025.04.01 18:06:10.577441 [ 245266 ] {db8e6043-9393-4d02-84ba-8dc8817be60f} <Debug> TCPHandler: Processed in 0.010045515 sec. | ||
| 390 | 2025.04.01 18:06:10.578010 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 391 | 2025.04.01 18:06:10.578266 [ 245266 ] {fdef0871-c531-4c42-9e5d-67f9585b2338} <Debug> executeQuery: (from [::1]:53330) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 392 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 393 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 394 | * a string isn't palatable for a few reasons. | ||
| 395 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 396 | * details. | ||
| 397 | */ | ||
| 398 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 399 | 2025.04.01 18:06:10.578328 [ 245266 ] {fdef0871-c531-4c42-9e5d-67f9585b2338} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 400 | 2025.04.01 18:06:10.585081 [ 245266 ] {fdef0871-c531-4c42-9e5d-67f9585b2338} <Debug> oximeter.measurements_bytes (58db77ff-f6e3-4343-8378-103bfc5c6365): Loading data parts | ||
| 401 | 2025.04.01 18:06:10.585403 [ 245266 ] {fdef0871-c531-4c42-9e5d-67f9585b2338} <Debug> oximeter.measurements_bytes (58db77ff-f6e3-4343-8378-103bfc5c6365): There are no data parts | ||
| 402 | 2025.04.01 18:06:10.589222 [ 245266 ] {fdef0871-c531-4c42-9e5d-67f9585b2338} <Debug> TCPHandler: Processed in 0.011370496 sec. | ||
| 403 | 2025.04.01 18:06:10.589742 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 404 | 2025.04.01 18:06:10.590042 [ 245266 ] {165f1b83-f2a9-48c0-a366-354e2a432894} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 405 | 2025.04.01 18:06:10.590093 [ 245266 ] {165f1b83-f2a9-48c0-a366-354e2a432894} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 406 | 2025.04.01 18:06:10.597769 [ 245266 ] {165f1b83-f2a9-48c0-a366-354e2a432894} <Debug> oximeter.measurements_cumulativei64 (02be4458-9e55-4d9e-9f70-bfcfca758817): Loading data parts | ||
| 407 | 2025.04.01 18:06:10.598093 [ 245266 ] {165f1b83-f2a9-48c0-a366-354e2a432894} <Debug> oximeter.measurements_cumulativei64 (02be4458-9e55-4d9e-9f70-bfcfca758817): There are no data parts | ||
| 408 | 2025.04.01 18:06:10.602323 [ 245266 ] {165f1b83-f2a9-48c0-a366-354e2a432894} <Debug> TCPHandler: Processed in 0.012717928 sec. | ||
| 409 | 2025.04.01 18:06:10.602948 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 410 | 2025.04.01 18:06:10.604469 [ 245266 ] {77558883-1b8b-4a61-a605-23c4e8d42c6f} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 411 | 2025.04.01 18:06:10.604518 [ 245266 ] {77558883-1b8b-4a61-a605-23c4e8d42c6f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 412 | 2025.04.01 18:06:10.609028 [ 245266 ] {77558883-1b8b-4a61-a605-23c4e8d42c6f} <Debug> oximeter.measurements_cumulativeu64 (aaa9a5e4-35ad-4eb9-ab34-ee818ea038cc): Loading data parts | ||
| 413 | 2025.04.01 18:06:10.609406 [ 245266 ] {77558883-1b8b-4a61-a605-23c4e8d42c6f} <Debug> oximeter.measurements_cumulativeu64 (aaa9a5e4-35ad-4eb9-ab34-ee818ea038cc): There are no data parts | ||
| 414 | 2025.04.01 18:06:10.614585 [ 245266 ] {77558883-1b8b-4a61-a605-23c4e8d42c6f} <Debug> TCPHandler: Processed in 0.011853767 sec. | ||
| 415 | 2025.04.01 18:06:10.615284 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 416 | 2025.04.01 18:06:10.616489 [ 245266 ] {b6ca273c-5efd-4593-b3f5-c0c71d717838} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 417 | 2025.04.01 18:06:10.616542 [ 245266 ] {b6ca273c-5efd-4593-b3f5-c0c71d717838} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 418 | 2025.04.01 18:06:10.621310 [ 245266 ] {b6ca273c-5efd-4593-b3f5-c0c71d717838} <Debug> oximeter.measurements_cumulativef32 (0d8a0a23-0f77-4c63-a7d5-a7c5f5672186): Loading data parts | ||
| 419 | 2025.04.01 18:06:10.623552 [ 245266 ] {b6ca273c-5efd-4593-b3f5-c0c71d717838} <Debug> oximeter.measurements_cumulativef32 (0d8a0a23-0f77-4c63-a7d5-a7c5f5672186): There are no data parts | ||
| 420 | 2025.04.01 18:06:10.628895 [ 245266 ] {b6ca273c-5efd-4593-b3f5-c0c71d717838} <Debug> TCPHandler: Processed in 0.013863699 sec. | ||
| 421 | 2025.04.01 18:06:10.630097 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 422 | 2025.04.01 18:06:10.630410 [ 245266 ] {e4bb3f54-04b7-4392-ac11-b8afc825f340} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 423 | 2025.04.01 18:06:10.630478 [ 245266 ] {e4bb3f54-04b7-4392-ac11-b8afc825f340} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 424 | 2025.04.01 18:06:10.637130 [ 245266 ] {e4bb3f54-04b7-4392-ac11-b8afc825f340} <Debug> oximeter.measurements_cumulativef64 (9c99190c-35b1-4ae2-aed8-d63853976ae4): Loading data parts | ||
| 425 | 2025.04.01 18:06:10.638111 [ 245266 ] {e4bb3f54-04b7-4392-ac11-b8afc825f340} <Debug> oximeter.measurements_cumulativef64 (9c99190c-35b1-4ae2-aed8-d63853976ae4): There are no data parts | ||
| 426 | 2025.04.01 18:06:10.644652 [ 245266 ] {e4bb3f54-04b7-4392-ac11-b8afc825f340} <Debug> TCPHandler: Processed in 0.014723131 sec. | ||
| 427 | 2025.04.01 18:06:10.645322 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 428 | 2025.04.01 18:06:10.647305 [ 245266 ] {8fa8b289-2764-49a0-a2fd-786a921bef4f} <Debug> executeQuery: (from [::1]:53330) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 429 | * NOTE: Array types cannot be Nullable, see | ||
| 430 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 431 | * for more details. | ||
| 432 | * | ||
| 433 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 434 | * is unfortunate, and at this point relies on the fact that an | ||
| 435 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 436 | * to figure out another way to represent missing samples here. | ||
| 437 | */ | ||
| 438 | 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) | ||
| 439 | 2025.04.01 18:06:10.647390 [ 245266 ] {8fa8b289-2764-49a0-a2fd-786a921bef4f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 440 | 2025.04.01 18:06:10.652995 [ 245266 ] {8fa8b289-2764-49a0-a2fd-786a921bef4f} <Debug> oximeter.measurements_histogrami8 (f04dd538-a0f9-48ef-a04a-e8d9f7e43770): Loading data parts | ||
| 441 | 2025.04.01 18:06:10.653275 [ 245266 ] {8fa8b289-2764-49a0-a2fd-786a921bef4f} <Debug> oximeter.measurements_histogrami8 (f04dd538-a0f9-48ef-a04a-e8d9f7e43770): There are no data parts | ||
| 442 | 2025.04.01 18:06:10.658344 [ 245266 ] {8fa8b289-2764-49a0-a2fd-786a921bef4f} <Debug> TCPHandler: Processed in 0.013233909 sec. | ||
| 443 | 2025.04.01 18:06:10.658864 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 444 | 2025.04.01 18:06:10.659155 [ 245266 ] {8f808056-a909-4acf-87ca-8e54f316bbb6} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 445 | 2025.04.01 18:06:10.659213 [ 245266 ] {8f808056-a909-4acf-87ca-8e54f316bbb6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 446 | 2025.04.01 18:06:10.665151 [ 245266 ] {8f808056-a909-4acf-87ca-8e54f316bbb6} <Debug> oximeter.measurements_histogramu8 (58794de8-dad6-4c18-bbfe-17840e9a4db6): Loading data parts | ||
| 447 | 2025.04.01 18:06:10.665783 [ 245266 ] {8f808056-a909-4acf-87ca-8e54f316bbb6} <Debug> oximeter.measurements_histogramu8 (58794de8-dad6-4c18-bbfe-17840e9a4db6): There are no data parts | ||
| 448 | 2025.04.01 18:06:10.670377 [ 245266 ] {8f808056-a909-4acf-87ca-8e54f316bbb6} <Debug> TCPHandler: Processed in 0.011649897 sec. | ||
| 449 | 2025.04.01 18:06:10.670880 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 450 | 2025.04.01 18:06:10.672796 [ 245266 ] {6f70008b-9ea2-4e22-86af-856aa1e623e3} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 451 | 2025.04.01 18:06:10.672852 [ 245266 ] {6f70008b-9ea2-4e22-86af-856aa1e623e3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 452 | 2025.04.01 18:06:10.678531 [ 245266 ] {6f70008b-9ea2-4e22-86af-856aa1e623e3} <Debug> oximeter.measurements_histogrami16 (ff482e58-d6f7-4191-856b-2c935440f06c): Loading data parts | ||
| 453 | 2025.04.01 18:06:10.678783 [ 245266 ] {6f70008b-9ea2-4e22-86af-856aa1e623e3} <Debug> oximeter.measurements_histogrami16 (ff482e58-d6f7-4191-856b-2c935440f06c): There are no data parts | ||
| 454 | 2025.04.01 18:06:10.683023 [ 245266 ] {6f70008b-9ea2-4e22-86af-856aa1e623e3} <Debug> TCPHandler: Processed in 0.012302627 sec. | ||
| 455 | 2025.04.01 18:06:10.683565 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 456 | 2025.04.01 18:06:10.685307 [ 245266 ] {1d91538a-4c3b-48b9-911c-fb51c24f0929} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 457 | 2025.04.01 18:06:10.685373 [ 245266 ] {1d91538a-4c3b-48b9-911c-fb51c24f0929} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 458 | 2025.04.01 18:06:10.695554 [ 245266 ] {1d91538a-4c3b-48b9-911c-fb51c24f0929} <Debug> oximeter.measurements_histogramu16 (37809e24-3a99-4b15-b7da-054ccd787580): Loading data parts | ||
| 459 | 2025.04.01 18:06:10.695903 [ 245266 ] {1d91538a-4c3b-48b9-911c-fb51c24f0929} <Debug> oximeter.measurements_histogramu16 (37809e24-3a99-4b15-b7da-054ccd787580): There are no data parts | ||
| 460 | 2025.04.01 18:06:10.700868 [ 245266 ] {1d91538a-4c3b-48b9-911c-fb51c24f0929} <Debug> TCPHandler: Processed in 0.017459445 sec. | ||
| 461 | 2025.04.01 18:06:10.701426 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 462 | 2025.04.01 18:06:10.701803 [ 245266 ] {b1271731-23c5-46df-81e3-0f716a27cdcd} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 463 | 2025.04.01 18:06:10.703503 [ 245266 ] {b1271731-23c5-46df-81e3-0f716a27cdcd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 464 | 2025.04.01 18:06:10.711362 [ 245266 ] {b1271731-23c5-46df-81e3-0f716a27cdcd} <Debug> oximeter.measurements_histogrami32 (70e7974e-fb0f-4cce-a045-4472b2b39392): Loading data parts | ||
| 465 | 2025.04.01 18:06:10.711678 [ 245266 ] {b1271731-23c5-46df-81e3-0f716a27cdcd} <Debug> oximeter.measurements_histogrami32 (70e7974e-fb0f-4cce-a045-4472b2b39392): There are no data parts | ||
| 466 | 2025.04.01 18:06:10.716638 [ 245266 ] {b1271731-23c5-46df-81e3-0f716a27cdcd} <Debug> TCPHandler: Processed in 0.015393662 sec. | ||
| 467 | 2025.04.01 18:06:10.717576 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 468 | 2025.04.01 18:06:10.717893 [ 245266 ] {5b552ba5-53ee-427a-9555-cdb3b5fca418} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 469 | 2025.04.01 18:06:10.717960 [ 245266 ] {5b552ba5-53ee-427a-9555-cdb3b5fca418} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 470 | 2025.04.01 18:06:10.723977 [ 245266 ] {5b552ba5-53ee-427a-9555-cdb3b5fca418} <Debug> oximeter.measurements_histogramu32 (11c92b5b-9845-428e-9976-895e3e3e950f): Loading data parts | ||
| 471 | 2025.04.01 18:06:10.724276 [ 245266 ] {5b552ba5-53ee-427a-9555-cdb3b5fca418} <Debug> oximeter.measurements_histogramu32 (11c92b5b-9845-428e-9976-895e3e3e950f): There are no data parts | ||
| 472 | 2025.04.01 18:06:10.729068 [ 245266 ] {5b552ba5-53ee-427a-9555-cdb3b5fca418} <Debug> TCPHandler: Processed in 0.011630346 sec. | ||
| 473 | 2025.04.01 18:06:10.729771 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 474 | 2025.04.01 18:06:10.731238 [ 245266 ] {96d18e07-b202-4101-8141-caa22eaa8fbe} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 475 | 2025.04.01 18:06:10.731299 [ 245266 ] {96d18e07-b202-4101-8141-caa22eaa8fbe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 476 | 2025.04.01 18:06:10.736936 [ 245266 ] {96d18e07-b202-4101-8141-caa22eaa8fbe} <Debug> oximeter.measurements_histogrami64 (6a095cc8-a078-4bab-9452-1e66aac4fba2): Loading data parts | ||
| 477 | 2025.04.01 18:06:10.737299 [ 245266 ] {96d18e07-b202-4101-8141-caa22eaa8fbe} <Debug> oximeter.measurements_histogrami64 (6a095cc8-a078-4bab-9452-1e66aac4fba2): There are no data parts | ||
| 478 | 2025.04.01 18:06:10.740976 [ 245266 ] {96d18e07-b202-4101-8141-caa22eaa8fbe} <Debug> TCPHandler: Processed in 0.011396096 sec. | ||
| 479 | 2025.04.01 18:06:10.741555 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 480 | 2025.04.01 18:06:10.741823 [ 245266 ] {b217b959-441f-4ff0-b34b-8bf5fb578b1f} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 481 | 2025.04.01 18:06:10.741889 [ 245266 ] {b217b959-441f-4ff0-b34b-8bf5fb578b1f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 482 | 2025.04.01 18:06:10.746525 [ 245266 ] {b217b959-441f-4ff0-b34b-8bf5fb578b1f} <Debug> oximeter.measurements_histogramu64 (6541f4e1-dddd-441f-b1f7-5f94bb7d3eb9): Loading data parts | ||
| 483 | 2025.04.01 18:06:10.746778 [ 245266 ] {b217b959-441f-4ff0-b34b-8bf5fb578b1f} <Debug> oximeter.measurements_histogramu64 (6541f4e1-dddd-441f-b1f7-5f94bb7d3eb9): There are no data parts | ||
| 484 | 2025.04.01 18:06:10.751882 [ 245266 ] {b217b959-441f-4ff0-b34b-8bf5fb578b1f} <Debug> TCPHandler: Processed in 0.010522285 sec. | ||
| 485 | 2025.04.01 18:06:10.752529 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 486 | 2025.04.01 18:06:10.752929 [ 245266 ] {36aabb39-05ce-4380-8f61-afe8a4a8d55d} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 487 | 2025.04.01 18:06:10.755011 [ 245266 ] {36aabb39-05ce-4380-8f61-afe8a4a8d55d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 488 | 2025.04.01 18:06:10.759691 [ 245266 ] {36aabb39-05ce-4380-8f61-afe8a4a8d55d} <Debug> oximeter.measurements_histogramf32 (8489066a-af92-47bc-9f34-77cd5a9eaa1a): Loading data parts | ||
| 489 | 2025.04.01 18:06:10.759995 [ 245266 ] {36aabb39-05ce-4380-8f61-afe8a4a8d55d} <Debug> oximeter.measurements_histogramf32 (8489066a-af92-47bc-9f34-77cd5a9eaa1a): There are no data parts | ||
| 490 | 2025.04.01 18:06:10.766242 [ 245266 ] {36aabb39-05ce-4380-8f61-afe8a4a8d55d} <Debug> TCPHandler: Processed in 0.01387576 sec. | ||
| 491 | 2025.04.01 18:06:10.766879 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 492 | 2025.04.01 18:06:10.767280 [ 245266 ] {3a1232a9-40fc-48c6-bf93-7ee3783bf2b3} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 493 | 2025.04.01 18:06:10.768365 [ 245266 ] {3a1232a9-40fc-48c6-bf93-7ee3783bf2b3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 494 | 2025.04.01 18:06:10.774549 [ 245266 ] {3a1232a9-40fc-48c6-bf93-7ee3783bf2b3} <Debug> oximeter.measurements_histogramf64 (32fd2446-68ab-458b-9732-3eb2f4122487): Loading data parts | ||
| 495 | 2025.04.01 18:06:10.774869 [ 245266 ] {3a1232a9-40fc-48c6-bf93-7ee3783bf2b3} <Debug> oximeter.measurements_histogramf64 (32fd2446-68ab-458b-9732-3eb2f4122487): There are no data parts | ||
| 496 | 2025.04.01 18:06:10.778845 [ 245266 ] {3a1232a9-40fc-48c6-bf93-7ee3783bf2b3} <Debug> TCPHandler: Processed in 0.012189348 sec. | ||
| 497 | 2025.04.01 18:06:10.779584 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 498 | 2025.04.01 18:06:10.779869 [ 245266 ] {39488120-70ac-45c9-b2d0-823ae6dfa9fa} <Debug> executeQuery: (from [::1]:53330) /* The field tables store named dimensions of each timeseries. | ||
| 499 | * | ||
| 500 | * As with the measurement tables, there is one field table for each field data | ||
| 501 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 502 | * this behavior **must not** be relied upon for query correctness. | ||
| 503 | * | ||
| 504 | * The index for the fields differs from the measurements, however. Rows are | ||
| 505 | * sorted by timeseries name, then field name, field value, and finally | ||
| 506 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 507 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 508 | * usually then used to look up measurements. | ||
| 509 | * | ||
| 510 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 511 | * timeseries name and then key, since it would improve lookups where one | ||
| 512 | * already has the key. Realistically though, these tables are quite small and | ||
| 513 | * so performance benefits will be low in absolute terms. | ||
| 514 | * | ||
| 515 | * TTL: We use a materialized column to expire old field table records. This | ||
| 516 | * column is generated automatically by the database whenever a new row is | ||
| 517 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 518 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 519 | * record will remain during a deduplication, which will have the last | ||
| 520 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 521 | * measurement tables. | ||
| 522 | */ | ||
| 523 | 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) | ||
| 524 | 2025.04.01 18:06:10.779929 [ 245266 ] {39488120-70ac-45c9-b2d0-823ae6dfa9fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 525 | 2025.04.01 18:06:10.784908 [ 245266 ] {39488120-70ac-45c9-b2d0-823ae6dfa9fa} <Debug> oximeter.fields_bool (87ac3c23-0ede-471c-a042-d4747cd5fee8): Loading data parts | ||
| 526 | 2025.04.01 18:06:10.785214 [ 245266 ] {39488120-70ac-45c9-b2d0-823ae6dfa9fa} <Debug> oximeter.fields_bool (87ac3c23-0ede-471c-a042-d4747cd5fee8): There are no data parts | ||
| 527 | 2025.04.01 18:06:10.800033 [ 245266 ] {39488120-70ac-45c9-b2d0-823ae6dfa9fa} <Debug> TCPHandler: Processed in 0.02065141 sec. | ||
| 528 | 2025.04.01 18:06:10.821100 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 529 | 2025.04.01 18:06:10.821459 [ 245266 ] {fececbf6-64ba-444f-aeaa-e3b3985cf939} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 530 | 2025.04.01 18:06:10.821528 [ 245266 ] {fececbf6-64ba-444f-aeaa-e3b3985cf939} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 531 | 2025.04.01 18:06:10.829292 [ 245266 ] {fececbf6-64ba-444f-aeaa-e3b3985cf939} <Debug> oximeter.fields_i8 (c6b9b215-be34-42f3-adc0-3f26b687ff44): Loading data parts | ||
| 532 | 2025.04.01 18:06:10.829628 [ 245266 ] {fececbf6-64ba-444f-aeaa-e3b3985cf939} <Debug> oximeter.fields_i8 (c6b9b215-be34-42f3-adc0-3f26b687ff44): There are no data parts | ||
| 533 | 2025.04.01 18:06:10.833422 [ 245266 ] {fececbf6-64ba-444f-aeaa-e3b3985cf939} <Debug> TCPHandler: Processed in 0.012539148 sec. | ||
| 534 | 2025.04.01 18:06:10.833942 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 535 | 2025.04.01 18:06:10.834224 [ 245266 ] {79c21c65-73f1-408d-8fd4-2f832854ebaf} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 536 | 2025.04.01 18:06:10.834278 [ 245266 ] {79c21c65-73f1-408d-8fd4-2f832854ebaf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 537 | 2025.04.01 18:06:10.838675 [ 245266 ] {79c21c65-73f1-408d-8fd4-2f832854ebaf} <Debug> oximeter.fields_u8 (42535178-b476-45cb-8513-b0c748c9864d): Loading data parts | ||
| 538 | 2025.04.01 18:06:10.843848 [ 245266 ] {79c21c65-73f1-408d-8fd4-2f832854ebaf} <Debug> oximeter.fields_u8 (42535178-b476-45cb-8513-b0c748c9864d): There are no data parts | ||
| 539 | 2025.04.01 18:06:10.851071 [ 245266 ] {79c21c65-73f1-408d-8fd4-2f832854ebaf} <Debug> TCPHandler: Processed in 0.017297665 sec. | ||
| 540 | 2025.04.01 18:06:10.852866 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 541 | 2025.04.01 18:06:10.853825 [ 245266 ] {6e13321c-f771-418a-9a99-8e1011d77e00} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 542 | 2025.04.01 18:06:10.853886 [ 245266 ] {6e13321c-f771-418a-9a99-8e1011d77e00} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 543 | 2025.04.01 18:06:10.864543 [ 245266 ] {6e13321c-f771-418a-9a99-8e1011d77e00} <Debug> oximeter.fields_i16 (fb857ff1-e0d4-40a1-b719-835d08383b70): Loading data parts | ||
| 544 | 2025.04.01 18:06:10.864974 [ 245266 ] {6e13321c-f771-418a-9a99-8e1011d77e00} <Debug> oximeter.fields_i16 (fb857ff1-e0d4-40a1-b719-835d08383b70): There are no data parts | ||
| 545 | 2025.04.01 18:06:10.870845 [ 245266 ] {6e13321c-f771-418a-9a99-8e1011d77e00} <Debug> TCPHandler: Processed in 0.018174756 sec. | ||
| 546 | 2025.04.01 18:06:10.873992 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 547 | 2025.04.01 18:06:10.874288 [ 245266 ] {6f540346-e618-42e1-a813-22d29fed3a70} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 548 | 2025.04.01 18:06:10.874351 [ 245266 ] {6f540346-e618-42e1-a813-22d29fed3a70} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 549 | 2025.04.01 18:06:10.879273 [ 245266 ] {6f540346-e618-42e1-a813-22d29fed3a70} <Debug> oximeter.fields_u16 (e6ff0326-bb83-4cbd-93ae-d62007b2c854): Loading data parts | ||
| 550 | 2025.04.01 18:06:10.879618 [ 245266 ] {6f540346-e618-42e1-a813-22d29fed3a70} <Debug> oximeter.fields_u16 (e6ff0326-bb83-4cbd-93ae-d62007b2c854): There are no data parts | ||
| 551 | 2025.04.01 18:06:10.883850 [ 245266 ] {6f540346-e618-42e1-a813-22d29fed3a70} <Debug> TCPHandler: Processed in 0.010043415 sec. | ||
| 552 | 2025.04.01 18:06:10.884398 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 553 | 2025.04.01 18:06:10.884710 [ 245266 ] {16a4c1f7-513f-494a-ac48-c55cbb42f27e} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 554 | 2025.04.01 18:06:10.884770 [ 245266 ] {16a4c1f7-513f-494a-ac48-c55cbb42f27e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 555 | 2025.04.01 18:06:10.886495 [ 244756 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 70 entries to flush up to offset 70 | ||
| 556 | 2025.04.01 18:06:10.886546 [ 244756 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
| 557 | 2025.04.01 18:06:10.890610 [ 245266 ] {16a4c1f7-513f-494a-ac48-c55cbb42f27e} <Debug> oximeter.fields_i32 (6f8f8465-bda7-41f1-8c54-509f0dab15f7): Loading data parts | ||
| 558 | 2025.04.01 18:06:10.892614 [ 245266 ] {16a4c1f7-513f-494a-ac48-c55cbb42f27e} <Debug> oximeter.fields_i32 (6f8f8465-bda7-41f1-8c54-509f0dab15f7): There are no data parts | ||
| 559 | 2025.04.01 18:06:10.895709 [ 244756 ] {} <Debug> system.query_log (8ef258a2-1356-4e8a-8b0a-67c4f5b2d19a): Loading data parts | ||
| 560 | 2025.04.01 18:06:10.896730 [ 244756 ] {} <Debug> system.query_log (8ef258a2-1356-4e8a-8b0a-67c4f5b2d19a): There are no data parts | ||
| 561 | 2025.04.01 18:06:10.899456 [ 245266 ] {16a4c1f7-513f-494a-ac48-c55cbb42f27e} <Debug> TCPHandler: Processed in 0.015245882 sec. | ||
| 562 | 2025.04.01 18:06:10.900040 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 563 | 2025.04.01 18:06:10.900327 [ 245266 ] {14bddbc6-1dbd-4f21-acd9-eb9cbb6d8c78} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 564 | 2025.04.01 18:06:10.901857 [ 245266 ] {14bddbc6-1dbd-4f21-acd9-eb9cbb6d8c78} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 565 | 2025.04.01 18:06:10.906153 [ 244756 ] {} <Trace> system.query_log (8ef258a2-1356-4e8a-8b0a-67c4f5b2d19a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 566 | 2025.04.01 18:06:10.906205 [ 244756 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.24 GiB. | ||
| 567 | 2025.04.01 18:06:10.907896 [ 244756 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 568 | 2025.04.01 18:06:10.907993 [ 245266 ] {14bddbc6-1dbd-4f21-acd9-eb9cbb6d8c78} <Debug> oximeter.fields_u32 (ce4266a3-9a26-4edd-a9a1-8502a189b73c): Loading data parts | ||
| 569 | 2025.04.01 18:06:10.909418 [ 244756 ] {} <Trace> system.query_log (8ef258a2-1356-4e8a-8b0a-67c4f5b2d19a): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 570 | 2025.04.01 18:06:10.909419 [ 245266 ] {14bddbc6-1dbd-4f21-acd9-eb9cbb6d8c78} <Debug> oximeter.fields_u32 (ce4266a3-9a26-4edd-a9a1-8502a189b73c): There are no data parts | ||
| 571 | 2025.04.01 18:06:10.909767 [ 244756 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 70 | ||
| 572 | 2025.04.01 18:06:10.916547 [ 245266 ] {14bddbc6-1dbd-4f21-acd9-eb9cbb6d8c78} <Debug> TCPHandler: Processed in 0.016706564 sec. | ||
| 573 | 2025.04.01 18:06:10.917074 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 574 | 2025.04.01 18:06:10.919100 [ 245266 ] {45cabcca-babc-4677-b913-5a4af8c2be76} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 575 | 2025.04.01 18:06:10.919163 [ 245266 ] {45cabcca-babc-4677-b913-5a4af8c2be76} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 576 | 2025.04.01 18:06:10.924430 [ 245266 ] {45cabcca-babc-4677-b913-5a4af8c2be76} <Debug> oximeter.fields_i64 (9d62b2e1-8972-48fd-9aa1-f007e114c6b5): Loading data parts | ||
| 577 | 2025.04.01 18:06:10.924744 [ 245266 ] {45cabcca-babc-4677-b913-5a4af8c2be76} <Debug> oximeter.fields_i64 (9d62b2e1-8972-48fd-9aa1-f007e114c6b5): There are no data parts | ||
| 578 | 2025.04.01 18:06:10.929592 [ 245266 ] {45cabcca-babc-4677-b913-5a4af8c2be76} <Debug> TCPHandler: Processed in 0.012658458 sec. | ||
| 579 | 2025.04.01 18:06:10.930994 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 580 | 2025.04.01 18:06:10.933543 [ 245266 ] {b7c76011-a152-49d3-94f4-d2dc757519d4} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 581 | 2025.04.01 18:06:10.933614 [ 245266 ] {b7c76011-a152-49d3-94f4-d2dc757519d4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 582 | 2025.04.01 18:06:10.938161 [ 245266 ] {b7c76011-a152-49d3-94f4-d2dc757519d4} <Debug> oximeter.fields_u64 (a5f3facf-b9f0-443c-a86c-f2d6eeefadd1): Loading data parts | ||
| 583 | 2025.04.01 18:06:10.938499 [ 245266 ] {b7c76011-a152-49d3-94f4-d2dc757519d4} <Debug> oximeter.fields_u64 (a5f3facf-b9f0-443c-a86c-f2d6eeefadd1): There are no data parts | ||
| 584 | 2025.04.01 18:06:10.943428 [ 245266 ] {b7c76011-a152-49d3-94f4-d2dc757519d4} <Debug> TCPHandler: Processed in 0.012696578 sec. | ||
| 585 | 2025.04.01 18:06:10.944035 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 586 | 2025.04.01 18:06:10.944327 [ 245266 ] {05ccdaae-55cc-439a-9f65-54f547657b20} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 587 | 2025.04.01 18:06:10.944383 [ 245266 ] {05ccdaae-55cc-439a-9f65-54f547657b20} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 588 | 2025.04.01 18:06:10.952259 [ 245266 ] {05ccdaae-55cc-439a-9f65-54f547657b20} <Debug> oximeter.fields_ipaddr (42b049c6-22e9-4343-beb3-4fb0bd6521a0): Loading data parts | ||
| 589 | 2025.04.01 18:06:10.952539 [ 245266 ] {05ccdaae-55cc-439a-9f65-54f547657b20} <Debug> oximeter.fields_ipaddr (42b049c6-22e9-4343-beb3-4fb0bd6521a0): There are no data parts | ||
| 590 | 2025.04.01 18:06:10.956689 [ 245266 ] {05ccdaae-55cc-439a-9f65-54f547657b20} <Debug> TCPHandler: Processed in 0.012826418 sec. | ||
| 591 | 2025.04.01 18:06:10.957271 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 592 | 2025.04.01 18:06:10.958810 [ 245266 ] {771e30ee-d52a-44cd-8e6f-011be8fcfe2e} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 593 | 2025.04.01 18:06:10.958867 [ 245266 ] {771e30ee-d52a-44cd-8e6f-011be8fcfe2e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 594 | 2025.04.01 18:06:10.963959 [ 245266 ] {771e30ee-d52a-44cd-8e6f-011be8fcfe2e} <Debug> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Loading data parts | ||
| 595 | 2025.04.01 18:06:10.964218 [ 245266 ] {771e30ee-d52a-44cd-8e6f-011be8fcfe2e} <Debug> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): There are no data parts | ||
| 596 | 2025.04.01 18:06:10.972545 [ 245266 ] {771e30ee-d52a-44cd-8e6f-011be8fcfe2e} <Debug> TCPHandler: Processed in 0.015480152 sec. | ||
| 597 | 2025.04.01 18:06:10.973123 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 598 | 2025.04.01 18:06:10.973426 [ 245266 ] {b1cf671e-9e2b-41c4-b07f-921ffe35dff4} <Debug> executeQuery: (from [::1]:53330) 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) | ||
| 599 | 2025.04.01 18:06:10.973487 [ 245266 ] {b1cf671e-9e2b-41c4-b07f-921ffe35dff4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 600 | 2025.04.01 18:06:10.979449 [ 245266 ] {b1cf671e-9e2b-41c4-b07f-921ffe35dff4} <Debug> oximeter.fields_uuid (36982c55-0bd8-4ede-aa8e-4151928b8637): Loading data parts | ||
| 601 | 2025.04.01 18:06:10.979832 [ 245266 ] {b1cf671e-9e2b-41c4-b07f-921ffe35dff4} <Debug> oximeter.fields_uuid (36982c55-0bd8-4ede-aa8e-4151928b8637): There are no data parts | ||
| 602 | 2025.04.01 18:06:10.985132 [ 245266 ] {b1cf671e-9e2b-41c4-b07f-921ffe35dff4} <Debug> TCPHandler: Processed in 0.012190268 sec. | ||
| 603 | 2025.04.01 18:06:10.986543 [ 245266 ] {} <Trace> TCP-Session: ca1f93ab-3cbd-4875-9fef-9949d750cc24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 604 | 2025.04.01 18:06:10.986987 [ 245266 ] {4d394324-cd19-4eac-b60a-8ddf61a1b602} <Debug> executeQuery: (from [::1]:53330) /* The timeseries schema table stores the extracted schema for the samples | ||
| 605 | * oximeter collects. | ||
| 606 | */ | ||
| 607 | 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) | ||
| 608 | 2025.04.01 18:06:10.987080 [ 245266 ] {4d394324-cd19-4eac-b60a-8ddf61a1b602} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 609 | 2025.04.01 18:06:10.992390 [ 245266 ] {4d394324-cd19-4eac-b60a-8ddf61a1b602} <Debug> oximeter.timeseries_schema (ab916bd9-f09b-482c-9328-a2ee339dfdb0): Loading data parts | ||
| 610 | 2025.04.01 18:06:10.992949 [ 245266 ] {4d394324-cd19-4eac-b60a-8ddf61a1b602} <Debug> oximeter.timeseries_schema (ab916bd9-f09b-482c-9328-a2ee339dfdb0): There are no data parts | ||
| 611 | 2025.04.01 18:06:10.997017 [ 245266 ] {4d394324-cd19-4eac-b60a-8ddf61a1b602} <Debug> TCPHandler: Processed in 0.010753195 sec. | ||
| 612 | 2025.04.01 18:06:10.997669 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 613 | 2025.04.01 18:06:10.997871 [ 245253 ] {743fed1d-f875-4501-8d86-397acd39d93c} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 614 | 2025.04.01 18:06:10.997977 [ 245253 ] {743fed1d-f875-4501-8d86-397acd39d93c} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 615 | 2025.04.01 18:06:11.000461 [ 244768 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 411.92 MiB, peak 411.92 MiB, free memory in arenas 27.89 MiB, will set to 408.96 MiB (RSS), difference: -2.96 MiB | ||
| 616 | 2025.04.01 18:06:11.001619 [ 245284 ] {743fed1d-f875-4501-8d86-397acd39d93c} <Trace> oximeter.version (554c19e9-eb95-4c3f-8044-6dfa2ddc1b65): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 617 | 2025.04.01 18:06:11.003493 [ 245284 ] {743fed1d-f875-4501-8d86-397acd39d93c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.24 GiB. | ||
| 618 | 2025.04.01 18:06:11.003930 [ 245284 ] {743fed1d-f875-4501-8d86-397acd39d93c} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 619 | 2025.04.01 18:06:11.004114 [ 245284 ] {743fed1d-f875-4501-8d86-397acd39d93c} <Trace> oximeter.version (554c19e9-eb95-4c3f-8044-6dfa2ddc1b65): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 620 | 2025.04.01 18:06:11.004310 [ 245253 ] {743fed1d-f875-4501-8d86-397acd39d93c} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.006518 sec., 153.42129487572873 rows/sec., 2.40 KiB/sec. | ||
| 621 | 2025.04.01 18:06:11.004480 [ 245253 ] {743fed1d-f875-4501-8d86-397acd39d93c} <Debug> TCPHandler: Processed in 0.00701718 sec. | ||
| 622 | 2025.04.01 18:06:13.009642 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 623 | 2025.04.01 18:06:13.009860 [ 245253 ] {60353d81-2f03-4ad0-8bd2-e63d1fb69320} <Debug> executeQuery: (from [::1]:53326) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 624 | 2025.04.01 18:06:13.010143 [ 245253 ] {60353d81-2f03-4ad0-8bd2-e63d1fb69320} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 625 | 2025.04.01 18:06:13.010222 [ 245253 ] {60353d81-2f03-4ad0-8bd2-e63d1fb69320} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 626 | 2025.04.01 18:06:13.010783 [ 245253 ] {60353d81-2f03-4ad0-8bd2-e63d1fb69320} <Debug> TCPHandler: Processed in 0.001350812 sec. | ||
| 627 | 2025.04.01 18:06:13.012397 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 628 | 2025.04.01 18:06:13.012541 [ 245253 ] {450f4354-75ce-40b9-9281-611f68fe0b90} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
| 629 | 2025.04.01 18:06:13.012588 [ 245253 ] {450f4354-75ce-40b9-9281-611f68fe0b90} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 630 | 2025.04.01 18:06:13.014029 [ 245253 ] {450f4354-75ce-40b9-9281-611f68fe0b90} <Trace> oximeter.timeseries_schema (ab916bd9-f09b-482c-9328-a2ee339dfdb0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 631 | 2025.04.01 18:06:13.014058 [ 245253 ] {450f4354-75ce-40b9-9281-611f68fe0b90} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.38 GiB. | ||
| 632 | 2025.04.01 18:06:13.014489 [ 245253 ] {450f4354-75ce-40b9-9281-611f68fe0b90} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 633 | 2025.04.01 18:06:13.014690 [ 245253 ] {450f4354-75ce-40b9-9281-611f68fe0b90} <Trace> oximeter.timeseries_schema (ab916bd9-f09b-482c-9328-a2ee339dfdb0): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 634 | 2025.04.01 18:06:13.014876 [ 245253 ] {450f4354-75ce-40b9-9281-611f68fe0b90} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.00238 sec., 420.16806722689074 rows/sec., 50.47 KiB/sec. | ||
| 635 | 2025.04.01 18:06:13.014909 [ 245253 ] {450f4354-75ce-40b9-9281-611f68fe0b90} <Debug> TCPHandler: Processed in 0.002606814 sec. | ||
| 636 | 2025.04.01 18:06:13.015285 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 637 | 2025.04.01 18:06:13.015387 [ 245253 ] {d8222e9c-87d3-45e8-beb7-9ec65d234504} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 638 | 2025.04.01 18:06:13.015422 [ 245253 ] {d8222e9c-87d3-45e8-beb7-9ec65d234504} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 639 | 2025.04.01 18:06:13.016138 [ 245253 ] {d8222e9c-87d3-45e8-beb7-9ec65d234504} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 640 | 2025.04.01 18:06:13.016165 [ 245253 ] {d8222e9c-87d3-45e8-beb7-9ec65d234504} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.38 GiB. | ||
| 641 | 2025.04.01 18:06:13.016535 [ 245253 ] {d8222e9c-87d3-45e8-beb7-9ec65d234504} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 642 | 2025.04.01 18:06:13.016821 [ 245253 ] {d8222e9c-87d3-45e8-beb7-9ec65d234504} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 643 | 2025.04.01 18:06:13.017133 [ 245253 ] {d8222e9c-87d3-45e8-beb7-9ec65d234504} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.00177 sec., 1129.9435028248588 rows/sec., 116.97 KiB/sec. | ||
| 644 | 2025.04.01 18:06:13.017168 [ 245253 ] {d8222e9c-87d3-45e8-beb7-9ec65d234504} <Debug> TCPHandler: Processed in 0.001978823 sec. | ||
| 645 | 2025.04.01 18:06:13.017464 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 646 | 2025.04.01 18:06:13.017586 [ 245253 ] {b1645eb7-8f7a-4e81-8c31-57be71a81b19} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 647 | 2025.04.01 18:06:13.017630 [ 245253 ] {b1645eb7-8f7a-4e81-8c31-57be71a81b19} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 648 | 2025.04.01 18:06:13.018262 [ 245253 ] {b1645eb7-8f7a-4e81-8c31-57be71a81b19} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 649 | 2025.04.01 18:06:13.018287 [ 245253 ] {b1645eb7-8f7a-4e81-8c31-57be71a81b19} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.38 GiB. | ||
| 650 | 2025.04.01 18:06:13.018603 [ 245253 ] {b1645eb7-8f7a-4e81-8c31-57be71a81b19} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 651 | 2025.04.01 18:06:13.018818 [ 245253 ] {b1645eb7-8f7a-4e81-8c31-57be71a81b19} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 652 | 2025.04.01 18:06:13.019006 [ 245253 ] {b1645eb7-8f7a-4e81-8c31-57be71a81b19} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.00145 sec., 689.6551724137931 rows/sec., 47.82 KiB/sec. | ||
| 653 | 2025.04.01 18:06:13.019037 [ 245253 ] {b1645eb7-8f7a-4e81-8c31-57be71a81b19} <Debug> TCPHandler: Processed in 0.001640133 sec. | ||
| 654 | 2025.04.01 18:06:14.000452 [ 244768 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 409.12 MiB, peak 411.92 MiB, free memory in arenas 28.10 MiB, will set to 410.40 MiB (RSS), difference: 1.28 MiB | ||
| 655 | 2025.04.01 18:06:14.009437 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 656 | 2025.04.01 18:06:14.009702 [ 245253 ] {ea14b1fe-449e-442b-aad4-fdcdf335d847} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 657 | 2025.04.01 18:06:14.009796 [ 245253 ] {ea14b1fe-449e-442b-aad4-fdcdf335d847} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 658 | 2025.04.01 18:06:14.011056 [ 245253 ] {ea14b1fe-449e-442b-aad4-fdcdf335d847} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 659 | 2025.04.01 18:06:14.011093 [ 245253 ] {ea14b1fe-449e-442b-aad4-fdcdf335d847} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.67 GiB. | ||
| 660 | 2025.04.01 18:06:14.011517 [ 245253 ] {ea14b1fe-449e-442b-aad4-fdcdf335d847} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 661 | 2025.04.01 18:06:14.011759 [ 245253 ] {ea14b1fe-449e-442b-aad4-fdcdf335d847} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 662 | 2025.04.01 18:06:14.011998 [ 245253 ] {ea14b1fe-449e-442b-aad4-fdcdf335d847} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002378 sec., 841.0428931875526 rows/sec., 87.06 KiB/sec. | ||
| 663 | 2025.04.01 18:06:14.012045 [ 245253 ] {ea14b1fe-449e-442b-aad4-fdcdf335d847} <Debug> TCPHandler: Processed in 0.002883154 sec. | ||
| 664 | 2025.04.01 18:06:14.012413 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 665 | 2025.04.01 18:06:14.012547 [ 245253 ] {b60d6359-41fc-4dd1-8f89-166c823cf896} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 666 | 2025.04.01 18:06:14.012592 [ 245253 ] {b60d6359-41fc-4dd1-8f89-166c823cf896} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 667 | 2025.04.01 18:06:14.013235 [ 245253 ] {b60d6359-41fc-4dd1-8f89-166c823cf896} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 668 | 2025.04.01 18:06:14.013260 [ 245253 ] {b60d6359-41fc-4dd1-8f89-166c823cf896} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.67 GiB. | ||
| 669 | 2025.04.01 18:06:14.013560 [ 245253 ] {b60d6359-41fc-4dd1-8f89-166c823cf896} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 670 | 2025.04.01 18:06:14.013726 [ 245253 ] {b60d6359-41fc-4dd1-8f89-166c823cf896} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 671 | 2025.04.01 18:06:14.013921 [ 245253 ] {b60d6359-41fc-4dd1-8f89-166c823cf896} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.001413 sec., 707.7140835102618 rows/sec., 49.07 KiB/sec. | ||
| 672 | 2025.04.01 18:06:14.013954 [ 245253 ] {b60d6359-41fc-4dd1-8f89-166c823cf896} <Debug> TCPHandler: Processed in 0.001639053 sec. | ||
| 673 | 2025.04.01 18:06:15.008959 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 674 | 2025.04.01 18:06:15.009176 [ 245253 ] {118af59c-40c9-4e0f-ae8a-f6b953c7dfcc} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 675 | 2025.04.01 18:06:15.009243 [ 245253 ] {118af59c-40c9-4e0f-ae8a-f6b953c7dfcc} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 676 | 2025.04.01 18:06:15.010260 [ 245253 ] {118af59c-40c9-4e0f-ae8a-f6b953c7dfcc} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 677 | 2025.04.01 18:06:15.011451 [ 245253 ] {118af59c-40c9-4e0f-ae8a-f6b953c7dfcc} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.19 GiB. | ||
| 678 | 2025.04.01 18:06:15.012006 [ 245253 ] {118af59c-40c9-4e0f-ae8a-f6b953c7dfcc} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
| 679 | 2025.04.01 18:06:15.013497 [ 245253 ] {118af59c-40c9-4e0f-ae8a-f6b953c7dfcc} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 680 | 2025.04.01 18:06:15.013742 [ 245253 ] {118af59c-40c9-4e0f-ae8a-f6b953c7dfcc} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004629 sec., 432.0587599913588 rows/sec., 44.72 KiB/sec. | ||
| 681 | 2025.04.01 18:06:15.013801 [ 245253 ] {118af59c-40c9-4e0f-ae8a-f6b953c7dfcc} <Debug> TCPHandler: Processed in 0.005049117 sec. | ||
| 682 | 2025.04.01 18:06:15.015162 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 683 | 2025.04.01 18:06:15.015715 [ 245253 ] {d59523a5-9f53-4977-937d-0296d71eba6a} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 684 | 2025.04.01 18:06:15.015775 [ 245253 ] {d59523a5-9f53-4977-937d-0296d71eba6a} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 685 | 2025.04.01 18:06:15.016676 [ 245253 ] {d59523a5-9f53-4977-937d-0296d71eba6a} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 686 | 2025.04.01 18:06:15.017540 [ 245253 ] {d59523a5-9f53-4977-937d-0296d71eba6a} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.19 GiB. | ||
| 687 | 2025.04.01 18:06:15.017938 [ 245253 ] {d59523a5-9f53-4977-937d-0296d71eba6a} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
| 688 | 2025.04.01 18:06:15.018141 [ 245253 ] {d59523a5-9f53-4977-937d-0296d71eba6a} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 689 | 2025.04.01 18:06:15.018383 [ 245253 ] {d59523a5-9f53-4977-937d-0296d71eba6a} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002723 sec., 367.2420124862284 rows/sec., 25.46 KiB/sec. | ||
| 690 | 2025.04.01 18:06:15.018426 [ 245253 ] {d59523a5-9f53-4977-937d-0296d71eba6a} <Debug> TCPHandler: Processed in 0.003411195 sec. | ||
| 691 | 2025.04.01 18:06:15.868063 [ 244638 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 692 | 2025.04.01 18:06:15.868102 [ 244638 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 693 | 2025.04.01 18:06:15.906546 [ 244755 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1618 entries to flush up to offset 3576 | ||
| 694 | 2025.04.01 18:06:15.907840 [ 244755 ] {} <Trace> system.asynchronous_metric_log (9d2f8a89-c408-4630-abce-92a5bfd6f0d3): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 695 | 2025.04.01 18:06:15.908997 [ 244755 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.05 GiB. | ||
| 696 | 2025.04.01 18:06:15.909796 [ 244755 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 697 | 2025.04.01 18:06:15.912146 [ 244755 ] {} <Trace> system.asynchronous_metric_log (9d2f8a89-c408-4630-abce-92a5bfd6f0d3): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 698 | 2025.04.01 18:06:15.912331 [ 244755 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 3576 | ||
| 699 | 2025.04.01 18:06:15.969606 [ 244758 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16 | ||
| 700 | 2025.04.01 18:06:15.988067 [ 244758 ] {} <Trace> system.metric_log (1cf940e2-9b2b-43c4-beb6-acbbea69f953): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 701 | 2025.04.01 18:06:15.988113 [ 244758 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.46 GiB. | ||
| 702 | 2025.04.01 18:06:15.995927 [ 244758 ] {} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 703 | 2025.04.01 18:06:15.996502 [ 244758 ] {} <Trace> system.metric_log (1cf940e2-9b2b-43c4-beb6-acbbea69f953): 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.04.01 18:06:15.998668 [ 244758 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 16 | ||
| 705 | 2025.04.01 18:06:16.000408 [ 244768 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 407.23 MiB, peak 415.23 MiB, free memory in arenas 37.40 MiB, will set to 419.98 MiB (RSS), difference: 12.75 MiB | ||
| 706 | 2025.04.01 18:06:16.122071 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 707 | 2025.04.01 18:06:16.122303 [ 245253 ] {7ea6d4f9-201f-441c-8faa-906f7bd6c88e} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 708 | 2025.04.01 18:06:16.123397 [ 245253 ] {7ea6d4f9-201f-441c-8faa-906f7bd6c88e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 709 | 2025.04.01 18:06:16.128694 [ 245253 ] {7ea6d4f9-201f-441c-8faa-906f7bd6c88e} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 710 | 2025.04.01 18:06:16.128732 [ 245253 ] {7ea6d4f9-201f-441c-8faa-906f7bd6c88e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.39 GiB. | ||
| 711 | 2025.04.01 18:06:16.129098 [ 245253 ] {7ea6d4f9-201f-441c-8faa-906f7bd6c88e} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
| 712 | 2025.04.01 18:06:16.129321 [ 245253 ] {7ea6d4f9-201f-441c-8faa-906f7bd6c88e} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 713 | 2025.04.01 18:06:16.129597 [ 245253 ] {7ea6d4f9-201f-441c-8faa-906f7bd6c88e} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.007347 sec., 272.21995372260784 rows/sec., 28.18 KiB/sec. | ||
| 714 | 2025.04.01 18:06:16.129666 [ 245253 ] {7ea6d4f9-201f-441c-8faa-906f7bd6c88e} <Debug> TCPHandler: Processed in 0.007748351 sec. | ||
| 715 | 2025.04.01 18:06:16.132518 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 716 | 2025.04.01 18:06:16.132703 [ 245253 ] {be7487f1-b571-40ed-8123-9884f94be5c4} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 717 | 2025.04.01 18:06:16.132772 [ 245253 ] {be7487f1-b571-40ed-8123-9884f94be5c4} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 718 | 2025.04.01 18:06:16.137720 [ 245253 ] {be7487f1-b571-40ed-8123-9884f94be5c4} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 719 | 2025.04.01 18:06:16.138079 [ 245253 ] {be7487f1-b571-40ed-8123-9884f94be5c4} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.39 GiB. | ||
| 720 | 2025.04.01 18:06:16.138489 [ 245253 ] {be7487f1-b571-40ed-8123-9884f94be5c4} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
| 721 | 2025.04.01 18:06:16.138665 [ 245253 ] {be7487f1-b571-40ed-8123-9884f94be5c4} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 722 | 2025.04.01 18:06:16.138867 [ 245253 ] {be7487f1-b571-40ed-8123-9884f94be5c4} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.006224 sec., 160.66838046272494 rows/sec., 11.14 KiB/sec. | ||
| 723 | 2025.04.01 18:06:16.139012 [ 245253 ] {be7487f1-b571-40ed-8123-9884f94be5c4} <Debug> TCPHandler: Processed in 0.006593349 sec. | ||
| 724 | 2025.04.01 18:06:17.147396 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 725 | 2025.04.01 18:06:17.147605 [ 245253 ] {f7bade2f-d5da-4bd7-a990-bf4a75706fe7} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 726 | 2025.04.01 18:06:17.147668 [ 245253 ] {f7bade2f-d5da-4bd7-a990-bf4a75706fe7} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 727 | 2025.04.01 18:06:17.151455 [ 245253 ] {f7bade2f-d5da-4bd7-a990-bf4a75706fe7} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 728 | 2025.04.01 18:06:17.151486 [ 245253 ] {f7bade2f-d5da-4bd7-a990-bf4a75706fe7} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.39 GiB. | ||
| 729 | 2025.04.01 18:06:17.152147 [ 245253 ] {f7bade2f-d5da-4bd7-a990-bf4a75706fe7} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
| 730 | 2025.04.01 18:06:17.152309 [ 245253 ] {f7bade2f-d5da-4bd7-a990-bf4a75706fe7} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 731 | 2025.04.01 18:06:17.152509 [ 245253 ] {f7bade2f-d5da-4bd7-a990-bf4a75706fe7} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004972 sec., 402.2526146419952 rows/sec., 41.64 KiB/sec. | ||
| 732 | 2025.04.01 18:06:17.152562 [ 245253 ] {f7bade2f-d5da-4bd7-a990-bf4a75706fe7} <Debug> TCPHandler: Processed in 0.005289037 sec. | ||
| 733 | 2025.04.01 18:06:17.152849 [ 244521 ] {} <Debug> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
| 734 | 2025.04.01 18:06:17.154243 [ 244521 ] {} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 735 | 2025.04.01 18:06:17.154276 [ 244521 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.39 GiB. | ||
| 736 | 2025.04.01 18:06:17.154488 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
| 737 | 2025.04.01 18:06:17.154559 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
| 738 | 2025.04.01 18:06:17.154582 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 2 rows starting from the beginning of the part | ||
| 739 | 2025.04.01 18:06:17.154671 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 2 rows starting from the beginning of the part | ||
| 740 | 2025.04.01 18:06:17.154711 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 2 rows starting from the beginning of the part | ||
| 741 | 2025.04.01 18:06:17.154798 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 2 rows starting from the beginning of the part | ||
| 742 | 2025.04.01 18:06:17.154895 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 2 rows starting from the beginning of the part | ||
| 743 | 2025.04.01 18:06:17.156097 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 10 rows, containing 5 columns (5 merged, 0 gathered) in 0.001698222 sec., 5888.511631577026 rows/sec., 632.55 KiB/sec. | ||
| 744 | 2025.04.01 18:06:17.158230 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
| 745 | 2025.04.01 18:06:17.158471 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 746 | 2025.04.01 18:06:17.158524 [ 244713 ] {75b82def-03a6-4a99-95f6-fbfa1b5f5949::all_1_5_1} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
| 747 | 2025.04.01 18:06:17.158637 [ 244713 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.34 MiB. | ||
| 748 | 2025.04.01 18:06:17.157972 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 749 | 2025.04.01 18:06:17.158820 [ 245253 ] {ed7255a2-b1f3-4acd-b25d-01822eef005f} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 750 | 2025.04.01 18:06:17.158876 [ 245253 ] {ed7255a2-b1f3-4acd-b25d-01822eef005f} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 751 | 2025.04.01 18:06:17.161546 [ 245253 ] {ed7255a2-b1f3-4acd-b25d-01822eef005f} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 752 | 2025.04.01 18:06:17.161573 [ 245253 ] {ed7255a2-b1f3-4acd-b25d-01822eef005f} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.39 GiB. | ||
| 753 | 2025.04.01 18:06:17.161920 [ 245253 ] {ed7255a2-b1f3-4acd-b25d-01822eef005f} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
| 754 | 2025.04.01 18:06:17.185042 [ 245253 ] {ed7255a2-b1f3-4acd-b25d-01822eef005f} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 755 | 2025.04.01 18:06:17.185348 [ 245253 ] {ed7255a2-b1f3-4acd-b25d-01822eef005f} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.026563 sec., 37.64635018634944 rows/sec., 2.61 KiB/sec. | ||
| 756 | 2025.04.01 18:06:17.185418 [ 245253 ] {ed7255a2-b1f3-4acd-b25d-01822eef005f} <Debug> TCPHandler: Processed in 0.027531789 sec. | ||
| 757 | 2025.04.01 18:06:17.185538 [ 244563 ] {} <Debug> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
| 758 | 2025.04.01 18:06:17.185569 [ 244563 ] {} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 759 | 2025.04.01 18:06:17.185583 [ 244563 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.39 GiB. | ||
| 760 | 2025.04.01 18:06:17.186244 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
| 761 | 2025.04.01 18:06:17.186939 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
| 762 | 2025.04.01 18:06:17.186975 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 1 rows starting from the beginning of the part | ||
| 763 | 2025.04.01 18:06:17.187054 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 1 rows starting from the beginning of the part | ||
| 764 | 2025.04.01 18:06:17.187096 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 1 rows starting from the beginning of the part | ||
| 765 | 2025.04.01 18:06:17.187132 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 1 rows starting from the beginning of the part | ||
| 766 | 2025.04.01 18:06:17.187170 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 1 rows starting from the beginning of the part | ||
| 767 | 2025.04.01 18:06:17.188081 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 5 rows, containing 4 columns (4 merged, 0 gathered) in 0.001952662 sec., 2560.607007254712 rows/sec., 177.54 KiB/sec. | ||
| 768 | 2025.04.01 18:06:17.189428 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
| 769 | 2025.04.01 18:06:17.189635 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 770 | 2025.04.01 18:06:17.189679 [ 244753 ] {7d9cb024-23c2-48f3-a593-ccecb628de45::all_1_5_1} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
| 771 | 2025.04.01 18:06:17.189750 [ 244753 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.27 MiB. | ||
| 772 | 2025.04.01 18:06:18.026510 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 773 | 2025.04.01 18:06:18.026776 [ 245253 ] {81b62731-a73f-42ec-b03b-bea6b1892151} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 774 | 2025.04.01 18:06:18.026847 [ 245253 ] {81b62731-a73f-42ec-b03b-bea6b1892151} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 775 | 2025.04.01 18:06:18.028158 [ 245253 ] {81b62731-a73f-42ec-b03b-bea6b1892151} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 776 | 2025.04.01 18:06:18.028200 [ 245253 ] {81b62731-a73f-42ec-b03b-bea6b1892151} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.32 GiB. | ||
| 777 | 2025.04.01 18:06:18.030641 [ 245253 ] {81b62731-a73f-42ec-b03b-bea6b1892151} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
| 778 | 2025.04.01 18:06:18.030784 [ 245253 ] {81b62731-a73f-42ec-b03b-bea6b1892151} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 779 | 2025.04.01 18:06:18.030976 [ 245253 ] {81b62731-a73f-42ec-b03b-bea6b1892151} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.004255 sec., 470.0352526439483 rows/sec., 48.66 KiB/sec. | ||
| 780 | 2025.04.01 18:06:18.031031 [ 245253 ] {81b62731-a73f-42ec-b03b-bea6b1892151} <Debug> TCPHandler: Processed in 0.004622976 sec. | ||
| 781 | 2025.04.01 18:06:18.035468 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 782 | 2025.04.01 18:06:18.036846 [ 245253 ] {da24eb6f-bce3-4cb8-9a13-cf7434408219} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 783 | 2025.04.01 18:06:18.036919 [ 245253 ] {da24eb6f-bce3-4cb8-9a13-cf7434408219} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 784 | 2025.04.01 18:06:18.040220 [ 245253 ] {da24eb6f-bce3-4cb8-9a13-cf7434408219} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 785 | 2025.04.01 18:06:18.043704 [ 245253 ] {da24eb6f-bce3-4cb8-9a13-cf7434408219} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.46 GiB. | ||
| 786 | 2025.04.01 18:06:18.044096 [ 245253 ] {da24eb6f-bce3-4cb8-9a13-cf7434408219} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
| 787 | 2025.04.01 18:06:18.044270 [ 245253 ] {da24eb6f-bce3-4cb8-9a13-cf7434408219} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 788 | 2025.04.01 18:06:18.044478 [ 245253 ] {da24eb6f-bce3-4cb8-9a13-cf7434408219} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.007691 sec., 130.0221037576388 rows/sec., 9.02 KiB/sec. | ||
| 789 | 2025.04.01 18:06:18.044529 [ 245253 ] {da24eb6f-bce3-4cb8-9a13-cf7434408219} <Debug> TCPHandler: Processed in 0.009208063 sec. | ||
| 790 | 2025.04.01 18:06:19.123231 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 791 | 2025.04.01 18:06:19.124842 [ 245253 ] {bf75b042-78db-4704-b2c6-454b0923b594} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 792 | 2025.04.01 18:06:19.124924 [ 245253 ] {bf75b042-78db-4704-b2c6-454b0923b594} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 793 | 2025.04.01 18:06:19.126176 [ 245253 ] {bf75b042-78db-4704-b2c6-454b0923b594} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 794 | 2025.04.01 18:06:19.126223 [ 245253 ] {bf75b042-78db-4704-b2c6-454b0923b594} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.47 GiB. | ||
| 795 | 2025.04.01 18:06:19.126540 [ 245253 ] {bf75b042-78db-4704-b2c6-454b0923b594} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
| 796 | 2025.04.01 18:06:19.128289 [ 245253 ] {bf75b042-78db-4704-b2c6-454b0923b594} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 797 | 2025.04.01 18:06:19.128507 [ 245253 ] {bf75b042-78db-4704-b2c6-454b0923b594} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003735 sec., 535.475234270415 rows/sec., 55.43 KiB/sec. | ||
| 798 | 2025.04.01 18:06:19.128551 [ 245253 ] {bf75b042-78db-4704-b2c6-454b0923b594} <Debug> TCPHandler: Processed in 0.005486458 sec. | ||
| 799 | 2025.04.01 18:06:19.130593 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 800 | 2025.04.01 18:06:19.131144 [ 245253 ] {da541177-2b58-4105-8cfc-6e83fbed432d} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 801 | 2025.04.01 18:06:19.131194 [ 245253 ] {da541177-2b58-4105-8cfc-6e83fbed432d} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 802 | 2025.04.01 18:06:19.133649 [ 245253 ] {da541177-2b58-4105-8cfc-6e83fbed432d} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 803 | 2025.04.01 18:06:19.133679 [ 245253 ] {da541177-2b58-4105-8cfc-6e83fbed432d} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.47 GiB. | ||
| 804 | 2025.04.01 18:06:19.134067 [ 245253 ] {da541177-2b58-4105-8cfc-6e83fbed432d} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
| 805 | 2025.04.01 18:06:19.134299 [ 245253 ] {da541177-2b58-4105-8cfc-6e83fbed432d} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 806 | 2025.04.01 18:06:19.134514 [ 245253 ] {da541177-2b58-4105-8cfc-6e83fbed432d} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.00341 sec., 293.2551319648094 rows/sec., 20.33 KiB/sec. | ||
| 807 | 2025.04.01 18:06:19.134581 [ 245253 ] {da541177-2b58-4105-8cfc-6e83fbed432d} <Debug> TCPHandler: Processed in 0.004065346 sec. | ||
| 808 | 2025.04.01 18:06:20.008934 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 809 | 2025.04.01 18:06:20.009121 [ 245253 ] {6608d558-9573-4066-a8ba-3b48a8201d95} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 810 | 2025.04.01 18:06:20.009236 [ 245253 ] {6608d558-9573-4066-a8ba-3b48a8201d95} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 811 | 2025.04.01 18:06:20.010155 [ 245253 ] {6608d558-9573-4066-a8ba-3b48a8201d95} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 812 | 2025.04.01 18:06:20.010197 [ 245253 ] {6608d558-9573-4066-a8ba-3b48a8201d95} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.40 GiB. | ||
| 813 | 2025.04.01 18:06:20.011631 [ 245253 ] {6608d558-9573-4066-a8ba-3b48a8201d95} <Trace> MergedBlockOutputStream: filled checksums all_8_8_0 (state Temporary) | ||
| 814 | 2025.04.01 18:06:20.011817 [ 245253 ] {6608d558-9573-4066-a8ba-3b48a8201d95} <Trace> oximeter.fields_string (75b82def-03a6-4a99-95f6-fbfa1b5f5949): Renaming temporary part tmp_insert_all_8_8_0 to all_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 815 | 2025.04.01 18:06:20.012030 [ 245253 ] {6608d558-9573-4066-a8ba-3b48a8201d95} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002964 sec., 674.7638326585695 rows/sec., 69.85 KiB/sec. | ||
| 816 | 2025.04.01 18:06:20.012074 [ 245253 ] {6608d558-9573-4066-a8ba-3b48a8201d95} <Debug> TCPHandler: Processed in 0.003324625 sec. | ||
| 817 | 2025.04.01 18:06:20.012399 [ 245253 ] {} <Trace> TCP-Session: 47277da7-07a4-48f3-875c-9442cac42134 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 818 | 2025.04.01 18:06:20.012524 [ 245253 ] {49a0bb44-78c8-4e26-bb62-4e64d189cf7c} <Debug> executeQuery: (from [::1]:53326) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 819 | 2025.04.01 18:06:20.012571 [ 245253 ] {49a0bb44-78c8-4e26-bb62-4e64d189cf7c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 820 | 2025.04.01 18:06:20.013210 [ 245253 ] {49a0bb44-78c8-4e26-bb62-4e64d189cf7c} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 821 | 2025.04.01 18:06:20.014594 [ 245253 ] {49a0bb44-78c8-4e26-bb62-4e64d189cf7c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 161.40 GiB. | ||
| 822 | 2025.04.01 18:06:20.014928 [ 245253 ] {49a0bb44-78c8-4e26-bb62-4e64d189cf7c} <Trace> MergedBlockOutputStream: filled checksums all_8_8_0 (state Temporary) | ||
| 823 | 2025.04.01 18:06:20.015107 [ 245253 ] {49a0bb44-78c8-4e26-bb62-4e64d189cf7c} <Trace> oximeter.measurements_i64 (7d9cb024-23c2-48f3-a593-ccecb628de45): Renaming temporary part tmp_insert_all_8_8_0 to all_8_8_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 824 | 2025.04.01 18:06:20.015308 [ 245253 ] {49a0bb44-78c8-4e26-bb62-4e64d189cf7c} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002813 sec., 355.49235691432636 rows/sec., 24.65 KiB/sec. | ||
| 825 | 2025.04.01 18:06:20.015344 [ 245253 ] {49a0bb44-78c8-4e26-bb62-4e64d189cf7c} <Debug> TCPHandler: Processed in 0.003014404 sec. | ||