| 1 | 2025.03.07 23:05:54.942450 [ 187218 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2025.03.07 23:05:54.942520 [ 187218 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2025.03.07 23:05:55.081926 [ 187218 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 187218 | ||
| 4 | 2025.03.07 23:05:55.081988 [ 187218 ] {} <Information> Application: starting up | ||
| 5 | 2025.03.07 23:05:55.082003 [ 187218 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2025.03.07 23:05:55.085447 [ 187218 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2025.03.07 23:05:55.088455 [ 187218 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2025.03.07 23:05:55.088630 [ 187218 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2025.03.07 23:05:55.088674 [ 187218 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2025.03.07 23:05:55.088688 [ 187218 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2025.03.07 23:05:55.489645 [ 187218 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2025.03.07 23:05:55.495085 [ 187218 ] {} <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.03.07 23:05:55.500092 [ 187218 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2025.03.07 23:05:55.501107 [ 187218 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2025.03.07 23:05:55.501120 [ 187218 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2025.03.07 23:05:55.501126 [ 187218 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2025.03.07 23:05:55.501153 [ 187218 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/datastore/tmp/ to store temporary data in it | ||
| 18 | 2025.03.07 23:05:55.501445 [ 187218 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2025.03.07 23:05:55.501939 [ 187218 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml' | ||
| 20 | 2025.03.07 23:05:55.502498 [ 187218 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml', performing update on configuration | ||
| 21 | 2025.03.07 23:05:55.503069 [ 187218 ] {} <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.03.07 23:05:55.504690 [ 187218 ] {} <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.03.07 23:05:55.504701 [ 187218 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2025.03.07 23:05:55.504747 [ 187218 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2025.03.07 23:05:55.505388 [ 187218 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2025.03.07 23:05:55.509721 [ 187218 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2025.03.07 23:05:55.510326 [ 187218 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2025.03.07 23:05:55.511811 [ 187218 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2025.03.07 23:05:55.511831 [ 187218 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml', performed update on configuration | ||
| 30 | 2025.03.07 23:05:55.512427 [ 187218 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml' | ||
| 31 | 2025.03.07 23:05:55.513774 [ 187218 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml', performing update on configuration | ||
| 32 | 2025.03.07 23:05:55.516063 [ 187218 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml', performed update on configuration | ||
| 33 | 2025.03.07 23:05:55.516460 [ 187218 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/config.xml | ||
| 34 | 2025.03.07 23:05:55.517082 [ 187218 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2025.03.07 23:05:55.519624 [ 187218 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2025.03.07 23:05:55.548944 [ 187218 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2025.03.07 23:05:55.572339 [ 187218 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2025.03.07 23:05:55.573853 [ 187218 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2025.03.07 23:05:55.574210 [ 187218 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/datastore/ | ||
| 40 | 2025.03.07 23:05:55.574481 [ 187316 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 41 | 2025.03.07 23:05:55.574507 [ 187316 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 42 | 2025.03.07 23:05:55.595523 [ 187218 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2025.03.07 23:05:55.595549 [ 187218 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.005667321 sec | ||
| 44 | 2025.03.07 23:05:55.595556 [ 187218 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2025.03.07 23:05:55.595561 [ 187218 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2025.03.07 23:05:55.596294 [ 187218 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2025.03.07 23:05:55.596329 [ 187218 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2025.03.07 23:05:55.605674 [ 187218 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2025.03.07 23:05:55.608542 [ 187218 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2025.03.07 23:05:55.608560 [ 187218 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2025.03.07 23:05:55.608567 [ 187218 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2025.03.07 23:05:55.608574 [ 187218 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2025.03.07 23:05:55.608583 [ 187218 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 54 | 2025.03.07 23:05:55.610801 [ 187218 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2025.03.07 23:05:55.611869 [ 187218 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2025.03.07 23:05:55.611889 [ 187218 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 57 | 2025.03.07 23:05:55.612089 [ 187218 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2025.03.07 23:05:55.612102 [ 187218 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2025.03.07 23:05:55.612109 [ 187218 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2025.03.07 23:05:55.612116 [ 187218 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2025.03.07 23:05:55.612123 [ 187218 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2025.03.07 23:05:55.612129 [ 187218 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2025.03.07 23:05:55.612136 [ 187218 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2025.03.07 23:05:55.681066 [ 187218 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2025.03.07 23:05:55.685776 [ 187218 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2025.03.07 23:05:55.685799 [ 187218 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.516e-05 sec | ||
| 67 | 2025.03.07 23:05:55.685806 [ 187218 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2025.03.07 23:05:55.685810 [ 187218 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2025.03.07 23:05:55.685832 [ 187218 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2025.03.07 23:05:55.685948 [ 187218 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-64f9d44dd0510a95-test_roles_builtin.187124.1-clickhouse-LAo647/datastore/user_defined/ | ||
| 71 | 2025.03.07 23:05:55.685980 [ 187218 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2025.03.07 23:05:55.685985 [ 187218 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2025.03.07 23:05:55.686007 [ 187218 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2025.03.07 23:05:55.686012 [ 187218 ] {} <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.03.07 23:05:55.686091 [ 187218 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 33493 | ||
| 76 | 2025.03.07 23:05:55.686143 [ 187218 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 46387 | ||
| 77 | 2025.03.07 23:05:55.686299 [ 187218 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34575 | ||
| 78 | 2025.03.07 23:05:55.686340 [ 187218 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 43477 | ||
| 79 | 2025.03.07 23:05:55.686359 [ 187218 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2025.03.07 23:05:55.686742 [ 187218 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.64 MiB, peak 20.64 MiB, free memory in arenas 16.24 MiB, will set to 382.98 MiB (RSS), difference: 362.34 MiB | ||
| 81 | 2025.03.07 23:05:55.721508 [ 187218 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.3071e-05 sec. | ||
| 82 | 2025.03.07 23:05:55.722440 [ 187218 ] {} <Information> Application: Listening for http://[::1]:33493 | ||
| 83 | 2025.03.07 23:05:55.723298 [ 187218 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:46387 | ||
| 84 | 2025.03.07 23:05:55.723348 [ 187218 ] {} <Information> Application: Listening for http://127.0.0.1:34575 | ||
| 85 | 2025.03.07 23:05:55.723392 [ 187218 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:43477 | ||
| 86 | 2025.03.07 23:05:55.723400 [ 187218 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2025.03.07 23:05:56.544126 [ 187227 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37176 | ||
| 88 | 2025.03.07 23:05:56.544489 [ 187227 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2025.03.07 23:05:56.544534 [ 187227 ] {} <Debug> TCP-Session: 3086cd28-8fd7-4392-918a-08e806160208 Authenticating user 'default' from [::1]:37176 | ||
| 90 | 2025.03.07 23:05:56.544551 [ 187227 ] {} <Debug> TCP-Session: 3086cd28-8fd7-4392-918a-08e806160208 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2025.03.07 23:05:56.544557 [ 187227 ] {} <Debug> TCP-Session: 3086cd28-8fd7-4392-918a-08e806160208 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2025.03.07 23:05:56.544646 [ 187227 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2025.03.07 23:05:56.544670 [ 187227 ] {} <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.03.07 23:05:56.544678 [ 187227 ] {} <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.03.07 23:05:56.545530 [ 187228 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37178 | ||
| 96 | 2025.03.07 23:05:56.545717 [ 187229 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37180 | ||
| 97 | 2025.03.07 23:05:56.545907 [ 188146 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37182 | ||
| 98 | 2025.03.07 23:05:56.546336 [ 188147 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37184 | ||
| 99 | 2025.03.07 23:05:56.546455 [ 188148 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37186 | ||
| 100 | 2025.03.07 23:05:56.546750 [ 187228 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 101 | 2025.03.07 23:05:56.546841 [ 187228 ] {} <Debug> TCP-Session: 010201ff-3318-4f53-bbb1-374d29b1e5d5 Authenticating user 'default' from [::1]:37178 | ||
| 102 | 2025.03.07 23:05:56.546859 [ 187228 ] {} <Debug> TCP-Session: 010201ff-3318-4f53-bbb1-374d29b1e5d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 103 | 2025.03.07 23:05:56.546858 [ 187229 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 104 | 2025.03.07 23:05:56.546867 [ 187228 ] {} <Debug> TCP-Session: 010201ff-3318-4f53-bbb1-374d29b1e5d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2025.03.07 23:05:56.546980 [ 188146 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 106 | 2025.03.07 23:05:56.547024 [ 188146 ] {} <Debug> TCP-Session: 544a178c-c819-465e-941d-a52cdea2b9f1 Authenticating user 'default' from [::1]:37182 | ||
| 107 | 2025.03.07 23:05:56.547034 [ 188146 ] {} <Debug> TCP-Session: 544a178c-c819-465e-941d-a52cdea2b9f1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 108 | 2025.03.07 23:05:56.547040 [ 188146 ] {} <Debug> TCP-Session: 544a178c-c819-465e-941d-a52cdea2b9f1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2025.03.07 23:05:56.547101 [ 187229 ] {} <Debug> TCP-Session: a2108406-f093-4099-bfb1-fed50be7fb78 Authenticating user 'default' from [::1]:37180 | ||
| 110 | 2025.03.07 23:05:56.547117 [ 187229 ] {} <Debug> TCP-Session: a2108406-f093-4099-bfb1-fed50be7fb78 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 111 | 2025.03.07 23:05:56.547122 [ 187229 ] {} <Debug> TCP-Session: a2108406-f093-4099-bfb1-fed50be7fb78 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 112 | 2025.03.07 23:05:56.547381 [ 188147 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 113 | 2025.03.07 23:05:56.548931 [ 188147 ] {} <Debug> TCP-Session: 09aba7f8-a1e5-4cf6-b665-ecdfed7ab784 Authenticating user 'default' from [::1]:37184 | ||
| 114 | 2025.03.07 23:05:56.548948 [ 188147 ] {} <Debug> TCP-Session: 09aba7f8-a1e5-4cf6-b665-ecdfed7ab784 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 115 | 2025.03.07 23:05:56.548955 [ 188147 ] {} <Debug> TCP-Session: 09aba7f8-a1e5-4cf6-b665-ecdfed7ab784 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 116 | 2025.03.07 23:05:56.547418 [ 188148 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 117 | 2025.03.07 23:05:56.548510 [ 188149 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37188 | ||
| 118 | 2025.03.07 23:05:56.548699 [ 188150 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37190 | ||
| 119 | 2025.03.07 23:05:56.549150 [ 188148 ] {} <Debug> TCP-Session: 7ec78d3c-10c5-4488-82b9-6c2f9b7f304e Authenticating user 'default' from [::1]:37186 | ||
| 120 | 2025.03.07 23:05:56.549181 [ 188148 ] {} <Debug> TCP-Session: 7ec78d3c-10c5-4488-82b9-6c2f9b7f304e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 121 | 2025.03.07 23:05:56.549190 [ 188148 ] {} <Debug> TCP-Session: 7ec78d3c-10c5-4488-82b9-6c2f9b7f304e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 122 | 2025.03.07 23:05:56.549331 [ 188149 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 123 | 2025.03.07 23:05:56.549361 [ 188149 ] {} <Debug> TCP-Session: dac0653a-ec81-4c6a-a2d2-0be6475d7154 Authenticating user 'default' from [::1]:37188 | ||
| 124 | 2025.03.07 23:05:56.549370 [ 188149 ] {} <Debug> TCP-Session: dac0653a-ec81-4c6a-a2d2-0be6475d7154 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 125 | 2025.03.07 23:05:56.549377 [ 188149 ] {} <Debug> TCP-Session: dac0653a-ec81-4c6a-a2d2-0be6475d7154 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 126 | 2025.03.07 23:05:56.549727 [ 188150 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2025.03.07 23:05:56.550470 [ 188150 ] {} <Debug> TCP-Session: 6e235efa-4371-4881-b585-ea07ceb48f3b Authenticating user 'default' from [::1]:37190 | ||
| 128 | 2025.03.07 23:05:56.550489 [ 188150 ] {} <Debug> TCP-Session: 6e235efa-4371-4881-b585-ea07ceb48f3b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2025.03.07 23:05:56.550496 [ 188150 ] {} <Debug> TCP-Session: 6e235efa-4371-4881-b585-ea07ceb48f3b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2025.03.07 23:06:03.127320 [ 187524 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 131 | 2025.03.07 23:06:03.127384 [ 187524 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 132 | 2025.03.07 23:06:03.142578 [ 187524 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 133 | 2025.03.07 23:06:03.146418 [ 187524 ] {} <Debug> system.metric_log (8e785c2a-631f-4c97-8d70-14002e02c3f0): Loading data parts | ||
| 134 | 2025.03.07 23:06:03.158486 [ 187524 ] {} <Debug> system.metric_log (8e785c2a-631f-4c97-8d70-14002e02c3f0): There are no data parts | ||
| 135 | 2025.03.07 23:06:03.159943 [ 187587 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1958 entries to flush up to offset 1958 | ||
| 136 | 2025.03.07 23:06:03.160026 [ 187587 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 137 | 2025.03.07 23:06:03.164484 [ 187587 ] {} <Debug> system.asynchronous_metric_log (958ad1e4-3b8a-4a5f-b099-4b6f6836dc95): Loading data parts | ||
| 138 | 2025.03.07 23:06:03.164649 [ 187587 ] {} <Debug> system.asynchronous_metric_log (958ad1e4-3b8a-4a5f-b099-4b6f6836dc95): There are no data parts | ||
| 139 | 2025.03.07 23:06:03.170017 [ 187587 ] {} <Trace> system.asynchronous_metric_log (958ad1e4-3b8a-4a5f-b099-4b6f6836dc95): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 140 | 2025.03.07 23:06:03.170055 [ 187587 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 160.65 GiB. | ||
| 141 | 2025.03.07 23:06:03.172169 [ 187587 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 142 | 2025.03.07 23:06:03.172415 [ 187587 ] {} <Trace> system.asynchronous_metric_log (958ad1e4-3b8a-4a5f-b099-4b6f6836dc95): 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.03.07 23:06:03.172630 [ 187587 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1958 | ||
| 144 | 2025.03.07 23:06:03.214623 [ 187524 ] {} <Trace> system.metric_log (8e785c2a-631f-4c97-8d70-14002e02c3f0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 145 | 2025.03.07 23:06:03.214667 [ 187524 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 160.65 GiB. | ||
| 146 | 2025.03.07 23:06:03.247146 [ 187524 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 147 | 2025.03.07 23:06:03.258113 [ 187524 ] {} <Trace> system.metric_log (8e785c2a-631f-4c97-8d70-14002e02c3f0): 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.03.07 23:06:03.268150 [ 187524 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 149 | 2025.03.07 23:06:04.000485 [ 187754 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 388.56 MiB, peak 392.56 MiB, free memory in arenas 28.64 MiB, will set to 393.51 MiB (RSS), difference: 4.96 MiB | ||
| 150 | 2025.03.07 23:06:06.374441 [ 189480 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37192 | ||
| 151 | 2025.03.07 23:06:06.374591 [ 189480 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 152 | 2025.03.07 23:06:06.374621 [ 189480 ] {} <Debug> TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Authenticating user 'default' from [::1]:37192 | ||
| 153 | 2025.03.07 23:06:06.374648 [ 189480 ] {} <Debug> TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2025.03.07 23:06:06.374655 [ 189480 ] {} <Debug> TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 155 | 2025.03.07 23:06:06.388121 [ 189480 ] {} <Trace> TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 156 | 2025.03.07 23:06:06.394493 [ 189480 ] {4b92d933-0695-4c44-ab2a-60b5bd531272} <Debug> executeQuery: (from [::1]:37192) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 157 | 2025.03.07 23:06:06.395271 [ 189480 ] {4b92d933-0695-4c44-ab2a-60b5bd531272} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:37192) (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. ? @ 0x00007f8b06392ac3 in ? | ||
| 176 | 17. ? @ 0x00007f8b06424850 in ? | ||
| 177 | |||
| 178 | 2025.03.07 23:06:06.395427 [ 189480 ] {4b92d933-0695-4c44-ab2a-60b5bd531272} <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. ? @ 0x00007f8b06392ac3 in ? | ||
| 197 | 17. ? @ 0x00007f8b06424850 in ? | ||
| 198 | |||
| 199 | 2025.03.07 23:06:06.395494 [ 189480 ] {4b92d933-0695-4c44-ab2a-60b5bd531272} <Debug> TCPHandler: Processed in 0.007549469 sec. | ||
| 200 | 2025.03.07 23:06:06.397770 [ 189480 ] {} <Trace> TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 201 | 2025.03.07 23:06:06.397924 [ 189480 ] {92f3dd67-01b5-44fe-abc6-b9e9ed2c6e23} <Debug> executeQuery: (from [::1]:37192) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 202 | 2025.03.07 23:06:06.398157 [ 189480 ] {92f3dd67-01b5-44fe-abc6-b9e9ed2c6e23} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:37192) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 203 | |||
| 204 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 205 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 206 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 207 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 208 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 209 | 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 | ||
| 210 | 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 | ||
| 211 | 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 | ||
| 212 | 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 | ||
| 213 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 214 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 215 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 216 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 217 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 218 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 219 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 220 | 16. ? @ 0x00007f8b06392ac3 in ? | ||
| 221 | 17. ? @ 0x00007f8b06424850 in ? | ||
| 222 | |||
| 223 | 2025.03.07 23:06:06.398264 [ 189480 ] {92f3dd67-01b5-44fe-abc6-b9e9ed2c6e23} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 224 | |||
| 225 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 226 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 227 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 228 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 229 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 230 | 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 | ||
| 231 | 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 | ||
| 232 | 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 | ||
| 233 | 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 | ||
| 234 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 235 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 236 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 237 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 238 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 239 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 240 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 241 | 16. ? @ 0x00007f8b06392ac3 in ? | ||
| 242 | 17. ? @ 0x00007f8b06424850 in ? | ||
| 243 | |||
| 244 | 2025.03.07 23:06:06.412010 [ 189480 ] {92f3dd67-01b5-44fe-abc6-b9e9ed2c6e23} <Debug> TCPHandler: Processed in 0.01432706 sec. | ||
| 245 | 2025.03.07 23:06:06.418147 [ 189540 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37198 | ||
| 246 | 2025.03.07 23:06:06.418279 [ 189540 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 247 | 2025.03.07 23:06:06.418303 [ 189540 ] {} <Debug> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Authenticating user 'default' from [::1]:37198 | ||
| 248 | 2025.03.07 23:06:06.418317 [ 189540 ] {} <Debug> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 249 | 2025.03.07 23:06:06.418342 [ 189540 ] {} <Debug> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 250 | 2025.03.07 23:06:06.432126 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 251 | 2025.03.07 23:06:06.432541 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} <Debug> executeQuery: (from [::1]:37198) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 252 | 2025.03.07 23:06:06.432592 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 253 | 2025.03.07 23:06:06.437233 [ 189546 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37204 | ||
| 254 | 2025.03.07 23:06:06.437317 [ 189546 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 255 | 2025.03.07 23:06:06.437344 [ 189546 ] {} <Debug> TCP-Session: ddde36ec-f378-4f76-822b-9dd02b20e6c0 Authenticating user 'default' from [::1]:37204 | ||
| 256 | 2025.03.07 23:06:06.437357 [ 189546 ] {} <Debug> TCP-Session: ddde36ec-f378-4f76-822b-9dd02b20e6c0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 257 | 2025.03.07 23:06:06.437363 [ 189546 ] {} <Debug> TCP-Session: ddde36ec-f378-4f76-822b-9dd02b20e6c0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 258 | 2025.03.07 23:06:06.437483 [ 189541 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37200 | ||
| 259 | 2025.03.07 23:06:06.437555 [ 189541 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 260 | 2025.03.07 23:06:06.437574 [ 189541 ] {} <Debug> TCP-Session: a786b0a4-9ce6-4bf0-8574-2554a76f6e51 Authenticating user 'default' from [::1]:37200 | ||
| 261 | 2025.03.07 23:06:06.437596 [ 189541 ] {} <Debug> TCP-Session: a786b0a4-9ce6-4bf0-8574-2554a76f6e51 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 262 | 2025.03.07 23:06:06.437601 [ 189541 ] {} <Debug> TCP-Session: a786b0a4-9ce6-4bf0-8574-2554a76f6e51 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 263 | 2025.03.07 23:06:06.437703 [ 189538 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37196 | ||
| 264 | 2025.03.07 23:06:06.437764 [ 189538 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 265 | 2025.03.07 23:06:06.437781 [ 189538 ] {} <Debug> TCP-Session: c95696c4-5a12-4036-8083-e0f8f9f642cc Authenticating user 'default' from [::1]:37196 | ||
| 266 | 2025.03.07 23:06:06.437789 [ 189538 ] {} <Debug> TCP-Session: c95696c4-5a12-4036-8083-e0f8f9f642cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 267 | 2025.03.07 23:06:06.437794 [ 189538 ] {} <Debug> TCP-Session: c95696c4-5a12-4036-8083-e0f8f9f642cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 268 | 2025.03.07 23:06:06.437899 [ 189550 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37206 | ||
| 269 | 2025.03.07 23:06:06.437999 [ 189550 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 270 | 2025.03.07 23:06:06.438022 [ 189550 ] {} <Debug> TCP-Session: 6fd6a72d-2f93-4108-8905-c8b06fe03fc8 Authenticating user 'default' from [::1]:37206 | ||
| 271 | 2025.03.07 23:06:06.438035 [ 189550 ] {} <Debug> TCP-Session: 6fd6a72d-2f93-4108-8905-c8b06fe03fc8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 272 | 2025.03.07 23:06:06.438041 [ 189550 ] {} <Debug> TCP-Session: 6fd6a72d-2f93-4108-8905-c8b06fe03fc8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2025.03.07 23:06:06.438128 [ 189542 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37202 | ||
| 274 | 2025.03.07 23:06:06.437953 [ 189481 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37194 | ||
| 275 | 2025.03.07 23:06:06.438309 [ 189542 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 276 | 2025.03.07 23:06:06.438332 [ 189542 ] {} <Debug> TCP-Session: c5b544fb-a1d8-4387-8d4d-27138802512e Authenticating user 'default' from [::1]:37202 | ||
| 277 | 2025.03.07 23:06:06.438340 [ 189542 ] {} <Debug> TCP-Session: c5b544fb-a1d8-4387-8d4d-27138802512e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 278 | 2025.03.07 23:06:06.438348 [ 189542 ] {} <Debug> TCP-Session: c5b544fb-a1d8-4387-8d4d-27138802512e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2025.03.07 23:06:06.438475 [ 189551 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37208 | ||
| 280 | 2025.03.07 23:06:06.438565 [ 189551 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 281 | 2025.03.07 23:06:06.438593 [ 189551 ] {} <Debug> TCP-Session: 91bd81b0-c5d7-4a9c-98fe-adeb601d2ce9 Authenticating user 'default' from [::1]:37208 | ||
| 282 | 2025.03.07 23:06:06.438604 [ 189551 ] {} <Debug> TCP-Session: 91bd81b0-c5d7-4a9c-98fe-adeb601d2ce9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2025.03.07 23:06:06.438611 [ 189551 ] {} <Debug> TCP-Session: 91bd81b0-c5d7-4a9c-98fe-adeb601d2ce9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 284 | 2025.03.07 23:06:06.438716 [ 189481 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 285 | 2025.03.07 23:06:06.438742 [ 189481 ] {} <Debug> TCP-Session: 6809418f-b6f2-4379-9899-08681dbbbbde Authenticating user 'default' from [::1]:37194 | ||
| 286 | 2025.03.07 23:06:06.438751 [ 189481 ] {} <Debug> TCP-Session: 6809418f-b6f2-4379-9899-08681dbbbbde Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 287 | 2025.03.07 23:06:06.438757 [ 189481 ] {} <Debug> TCP-Session: 6809418f-b6f2-4379-9899-08681dbbbbde Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2025.03.07 23:06:06.438853 [ 189481 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 289 | 2025.03.07 23:06:06.438882 [ 189481 ] {} <Debug> TCP-Session: 6809418f-b6f2-4379-9899-08681dbbbbde Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 290 | 2025.03.07 23:06:06.438909 [ 189481 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37212 | ||
| 291 | 2025.03.07 23:06:06.438941 [ 189481 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 292 | 2025.03.07 23:06:06.438953 [ 189481 ] {} <Debug> TCP-Session: f305560a-b8bd-48d1-8e6c-e9e6cb8bd789 Authenticating user 'default' from [::1]:37212 | ||
| 293 | 2025.03.07 23:06:06.438962 [ 189481 ] {} <Debug> TCP-Session: f305560a-b8bd-48d1-8e6c-e9e6cb8bd789 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2025.03.07 23:06:06.438968 [ 189481 ] {} <Debug> TCP-Session: f305560a-b8bd-48d1-8e6c-e9e6cb8bd789 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2025.03.07 23:06:06.439541 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 296 | 2025.03.07 23:06:06.439558 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00116319 sec | ||
| 297 | 2025.03.07 23:06:06.439568 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} <Trace> ReferentialDeps: No tables | ||
| 298 | 2025.03.07 23:06:06.439582 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} <Trace> LoadingDeps: No tables | ||
| 299 | 2025.03.07 23:06:06.439605 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 300 | 2025.03.07 23:06:06.439691 [ 189540 ] {91fb2ac1-8040-4d6a-98d3-afdeee4a9d0f} <Debug> TCPHandler: Processed in 0.00777707 sec. | ||
| 301 | 2025.03.07 23:06:06.440109 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 302 | 2025.03.07 23:06:06.440375 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} <Debug> executeQuery: (from [::1]:37198) /* 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.03.07 23:06:06.438865 [ 189552 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37210 | ||
| 305 | 2025.03.07 23:06:06.441927 [ 189552 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 306 | 2025.03.07 23:06:06.441952 [ 189552 ] {} <Debug> TCP-Session: 506cac86-e47f-43c9-8df0-155b0c97cb03 Authenticating user 'default' from [::1]:37210 | ||
| 307 | 2025.03.07 23:06:06.441963 [ 189552 ] {} <Debug> TCP-Session: 506cac86-e47f-43c9-8df0-155b0c97cb03 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 308 | 2025.03.07 23:06:06.441970 [ 189552 ] {} <Debug> TCP-Session: 506cac86-e47f-43c9-8df0-155b0c97cb03 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 309 | 2025.03.07 23:06:06.442071 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 310 | 2025.03.07 23:06:06.448195 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} <Debug> oximeter.version (6e8d9d1c-e902-4bd9-8343-d5745ada33f7): Loading data parts | ||
| 311 | 2025.03.07 23:06:06.449638 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} <Debug> oximeter.version (6e8d9d1c-e902-4bd9-8343-d5745ada33f7): There are no data parts | ||
| 312 | 2025.03.07 23:06:06.460059 [ 189540 ] {efb97706-141c-4ca8-8812-617b1033726e} <Debug> TCPHandler: Processed in 0.020012091 sec. | ||
| 313 | 2025.03.07 23:06:06.462349 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 314 | 2025.03.07 23:06:06.462601 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} <Debug> executeQuery: (from [::1]:37198) /* The measurement tables contain all individual samples from each timeseries. | ||
| 315 | * | ||
| 316 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 317 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 318 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 319 | * by all samples from the same timeseries. | ||
| 320 | * | ||
| 321 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 322 | * and then uses that to index quickly into the measurements tables. | ||
| 323 | */ | ||
| 324 | 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) | ||
| 325 | 2025.03.07 23:06:06.462652 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 326 | 2025.03.07 23:06:06.469473 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} <Debug> oximeter.measurements_bool (b2b09582-adff-4398-bffe-12a5c2eba123): Loading data parts | ||
| 327 | 2025.03.07 23:06:06.493137 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} <Debug> oximeter.measurements_bool (b2b09582-adff-4398-bffe-12a5c2eba123): There are no data parts | ||
| 328 | 2025.03.07 23:06:06.497617 [ 189540 ] {bf8f3fd8-a11d-4115-842e-3bdaf71cfb5b} <Debug> TCPHandler: Processed in 0.035380301 sec. | ||
| 329 | 2025.03.07 23:06:06.498207 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 330 | 2025.03.07 23:06:06.498438 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 331 | 2025.03.07 23:06:06.498586 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 332 | 2025.03.07 23:06:06.504011 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} <Debug> oximeter.measurements_i8 (8bb2d539-e6f3-420b-983c-41bf6dbcc810): Loading data parts | ||
| 333 | 2025.03.07 23:06:06.504289 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} <Debug> oximeter.measurements_i8 (8bb2d539-e6f3-420b-983c-41bf6dbcc810): There are no data parts | ||
| 334 | 2025.03.07 23:06:06.510214 [ 189540 ] {f31bd7e4-e782-4182-9016-a913a04a322c} <Debug> TCPHandler: Processed in 0.01207692 sec. | ||
| 335 | 2025.03.07 23:06:06.511081 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 336 | 2025.03.07 23:06:06.512996 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 337 | 2025.03.07 23:06:06.513046 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 338 | 2025.03.07 23:06:06.519994 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} <Debug> oximeter.measurements_u8 (7f4e19a0-61e9-4500-8adf-4ce7244d404d): Loading data parts | ||
| 339 | 2025.03.07 23:06:06.520205 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} <Debug> oximeter.measurements_u8 (7f4e19a0-61e9-4500-8adf-4ce7244d404d): There are no data parts | ||
| 340 | 2025.03.07 23:06:06.524939 [ 189540 ] {ebea8a64-fd3f-4cc2-b11c-57e8f9eb87f7} <Debug> TCPHandler: Processed in 0.014208741 sec. | ||
| 341 | 2025.03.07 23:06:06.525595 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 342 | 2025.03.07 23:06:06.525878 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 343 | 2025.03.07 23:06:06.527337 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 344 | 2025.03.07 23:06:06.534529 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} <Debug> oximeter.measurements_i16 (d3cb43f5-7ed3-4ee1-b92a-5fce612b9bd7): Loading data parts | ||
| 345 | 2025.03.07 23:06:06.534805 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} <Debug> oximeter.measurements_i16 (d3cb43f5-7ed3-4ee1-b92a-5fce612b9bd7): There are no data parts | ||
| 346 | 2025.03.07 23:06:06.539246 [ 189540 ] {74cb3cc0-d1a3-47df-a1bd-21b8dccc7ce1} <Debug> TCPHandler: Processed in 0.013764681 sec. | ||
| 347 | 2025.03.07 23:06:06.540118 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 348 | 2025.03.07 23:06:06.540346 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 349 | 2025.03.07 23:06:06.540401 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 350 | 2025.03.07 23:06:06.548337 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} <Debug> oximeter.measurements_u16 (4924d3ee-f18c-4c1f-91ef-c21e0d475367): Loading data parts | ||
| 351 | 2025.03.07 23:06:06.548705 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} <Debug> oximeter.measurements_u16 (4924d3ee-f18c-4c1f-91ef-c21e0d475367): There are no data parts | ||
| 352 | 2025.03.07 23:06:06.553086 [ 189540 ] {ae46841b-b373-4c80-95e7-996ecd230190} <Debug> TCPHandler: Processed in 0.01307319 sec. | ||
| 353 | 2025.03.07 23:06:06.633519 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 354 | 2025.03.07 23:06:06.635602 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 355 | 2025.03.07 23:06:06.635661 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 356 | 2025.03.07 23:06:06.643612 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} <Debug> oximeter.measurements_i32 (c164e8f4-bb50-407a-9a00-9544b05185a5): Loading data parts | ||
| 357 | 2025.03.07 23:06:06.643873 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} <Debug> oximeter.measurements_i32 (c164e8f4-bb50-407a-9a00-9544b05185a5): There are no data parts | ||
| 358 | 2025.03.07 23:06:06.653340 [ 189540 ] {4ce32cb4-d0b2-42ad-949c-e92990c93038} <Debug> TCPHandler: Processed in 0.020009221 sec. | ||
| 359 | 2025.03.07 23:06:07.012115 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 360 | 2025.03.07 23:06:07.012429 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 361 | 2025.03.07 23:06:07.012485 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 362 | 2025.03.07 23:06:07.018890 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} <Debug> oximeter.measurements_u32 (320a758f-3ad5-4b35-a062-983e02c8160c): Loading data parts | ||
| 363 | 2025.03.07 23:06:07.019177 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} <Debug> oximeter.measurements_u32 (320a758f-3ad5-4b35-a062-983e02c8160c): There are no data parts | ||
| 364 | 2025.03.07 23:06:07.023444 [ 189540 ] {348ac6eb-7915-4002-a2ff-23d13b662a34} <Debug> TCPHandler: Processed in 0.01151963 sec. | ||
| 365 | 2025.03.07 23:06:07.059258 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 366 | 2025.03.07 23:06:07.059582 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 367 | 2025.03.07 23:06:07.059645 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 368 | 2025.03.07 23:06:07.064588 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} <Debug> oximeter.measurements_i64 (7aaafe7b-bf9c-4ccb-b97a-423d3a83877f): Loading data parts | ||
| 369 | 2025.03.07 23:06:07.064842 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} <Debug> oximeter.measurements_i64 (7aaafe7b-bf9c-4ccb-b97a-423d3a83877f): There are no data parts | ||
| 370 | 2025.03.07 23:06:07.068916 [ 189540 ] {4654502a-b7cc-48f3-a133-05def01eb110} <Debug> TCPHandler: Processed in 0.009846431 sec. | ||
| 371 | 2025.03.07 23:06:07.074094 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 372 | 2025.03.07 23:06:07.074381 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 373 | 2025.03.07 23:06:07.074438 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 374 | 2025.03.07 23:06:07.079961 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} <Debug> oximeter.measurements_u64 (124d25ab-716a-4a57-9d83-2b728a67ae1e): Loading data parts | ||
| 375 | 2025.03.07 23:06:07.081871 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} <Debug> oximeter.measurements_u64 (124d25ab-716a-4a57-9d83-2b728a67ae1e): There are no data parts | ||
| 376 | 2025.03.07 23:06:07.089102 [ 189540 ] {a6e88a9f-5f81-46f6-8740-e4b57491f371} <Debug> TCPHandler: Processed in 0.01517988 sec. | ||
| 377 | 2025.03.07 23:06:07.090064 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 378 | 2025.03.07 23:06:07.091318 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 379 | 2025.03.07 23:06:07.091378 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 380 | 2025.03.07 23:06:07.097412 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} <Debug> oximeter.measurements_f32 (8f5faeb5-6e94-4463-a3c8-9f0a208ff856): Loading data parts | ||
| 381 | 2025.03.07 23:06:07.098263 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} <Debug> oximeter.measurements_f32 (8f5faeb5-6e94-4463-a3c8-9f0a208ff856): There are no data parts | ||
| 382 | 2025.03.07 23:06:07.102882 [ 189540 ] {6d994fdd-cc14-4142-93cd-abdc71b877d7} <Debug> TCPHandler: Processed in 0.01297828 sec. | ||
| 383 | 2025.03.07 23:06:07.104474 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 384 | 2025.03.07 23:06:07.104760 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 385 | 2025.03.07 23:06:07.104816 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 386 | 2025.03.07 23:06:07.110540 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} <Debug> oximeter.measurements_f64 (1c465c38-2efb-44c7-865b-a77cbfbda405): Loading data parts | ||
| 387 | 2025.03.07 23:06:07.110765 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} <Debug> oximeter.measurements_f64 (1c465c38-2efb-44c7-865b-a77cbfbda405): There are no data parts | ||
| 388 | 2025.03.07 23:06:07.116317 [ 189540 ] {0c8673f2-3838-4cf3-bcd9-f70b7a2d25f6} <Debug> TCPHandler: Processed in 0.01202232 sec. | ||
| 389 | 2025.03.07 23:06:07.117689 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 390 | 2025.03.07 23:06:07.118420 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 391 | 2025.03.07 23:06:07.118472 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 392 | 2025.03.07 23:06:07.123366 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} <Debug> oximeter.measurements_string (f429d33b-4321-4a4b-a3c3-da8234b21f41): Loading data parts | ||
| 393 | 2025.03.07 23:06:07.123814 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} <Debug> oximeter.measurements_string (f429d33b-4321-4a4b-a3c3-da8234b21f41): There are no data parts | ||
| 394 | 2025.03.07 23:06:07.135234 [ 189540 ] {7fcf17d5-7e53-4bae-8d57-28bd4fd3385d} <Debug> TCPHandler: Processed in 0.017732241 sec. | ||
| 395 | 2025.03.07 23:06:07.137521 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 396 | 2025.03.07 23:06:07.137808 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} <Debug> executeQuery: (from [::1]:37198) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 397 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 398 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 399 | * a string isn't palatable for a few reasons. | ||
| 400 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 401 | * details. | ||
| 402 | */ | ||
| 403 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 404 | 2025.03.07 23:06:07.137864 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 405 | 2025.03.07 23:06:07.145064 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} <Debug> oximeter.measurements_bytes (ef30098d-4c42-45a0-a1ef-614ee82e9b96): Loading data parts | ||
| 406 | 2025.03.07 23:06:07.145317 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} <Debug> oximeter.measurements_bytes (ef30098d-4c42-45a0-a1ef-614ee82e9b96): There are no data parts | ||
| 407 | 2025.03.07 23:06:07.152072 [ 189540 ] {d97f1cd2-d062-4fdd-9838-8f65677f0b13} <Debug> TCPHandler: Processed in 0.01470774 sec. | ||
| 408 | 2025.03.07 23:06:07.152881 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 409 | 2025.03.07 23:06:07.154157 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 410 | 2025.03.07 23:06:07.154206 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 411 | 2025.03.07 23:06:07.159779 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} <Debug> oximeter.measurements_cumulativei64 (e940844d-a06d-4af2-a0ed-278c8104d49a): Loading data parts | ||
| 412 | 2025.03.07 23:06:07.160029 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} <Debug> oximeter.measurements_cumulativei64 (e940844d-a06d-4af2-a0ed-278c8104d49a): There are no data parts | ||
| 413 | 2025.03.07 23:06:07.167322 [ 189540 ] {88d65687-1383-4595-b941-7098608779a0} <Debug> TCPHandler: Processed in 0.01453574 sec. | ||
| 414 | 2025.03.07 23:06:07.167998 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 415 | 2025.03.07 23:06:07.169636 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 416 | 2025.03.07 23:06:07.169692 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 417 | 2025.03.07 23:06:07.176331 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} <Debug> oximeter.measurements_cumulativeu64 (238e3de2-a6e6-4f92-810e-da14f1eda6f3): Loading data parts | ||
| 418 | 2025.03.07 23:06:07.176970 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} <Debug> oximeter.measurements_cumulativeu64 (238e3de2-a6e6-4f92-810e-da14f1eda6f3): There are no data parts | ||
| 419 | 2025.03.07 23:06:07.182667 [ 189540 ] {23824af6-0ddd-48e9-96d1-365625bed196} <Debug> TCPHandler: Processed in 0.01480704 sec. | ||
| 420 | 2025.03.07 23:06:07.183477 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 421 | 2025.03.07 23:06:07.187436 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 422 | 2025.03.07 23:06:07.187495 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 423 | 2025.03.07 23:06:07.194092 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} <Debug> oximeter.measurements_cumulativef32 (edcea3a2-f6a0-4556-92ff-c4c7fa67c542): Loading data parts | ||
| 424 | 2025.03.07 23:06:07.195652 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} <Debug> oximeter.measurements_cumulativef32 (edcea3a2-f6a0-4556-92ff-c4c7fa67c542): There are no data parts | ||
| 425 | 2025.03.07 23:06:07.202133 [ 189540 ] {48ba37a7-7fc9-43c0-a32d-1d7eca17bf32} <Debug> TCPHandler: Processed in 0.018771341 sec. | ||
| 426 | 2025.03.07 23:06:07.202721 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 427 | 2025.03.07 23:06:07.202950 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 428 | 2025.03.07 23:06:07.203034 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 429 | 2025.03.07 23:06:07.210318 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} <Debug> oximeter.measurements_cumulativef64 (fa7eb5a9-2c03-4163-a722-abe6b9dc2cb5): Loading data parts | ||
| 430 | 2025.03.07 23:06:07.210683 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} <Debug> oximeter.measurements_cumulativef64 (fa7eb5a9-2c03-4163-a722-abe6b9dc2cb5): There are no data parts | ||
| 431 | 2025.03.07 23:06:07.219203 [ 189540 ] {f4a9023b-87f4-44b0-aab8-5ce648921e91} <Debug> TCPHandler: Processed in 0.01659801 sec. | ||
| 432 | 2025.03.07 23:06:07.219684 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 433 | 2025.03.07 23:06:07.220053 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} <Debug> executeQuery: (from [::1]:37198) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 434 | * NOTE: Array types cannot be Nullable, see | ||
| 435 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 436 | * for more details. | ||
| 437 | * | ||
| 438 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 439 | * is unfortunate, and at this point relies on the fact that an | ||
| 440 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 441 | * to figure out another way to represent missing samples here. | ||
| 442 | */ | ||
| 443 | 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) | ||
| 444 | 2025.03.07 23:06:07.220118 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 445 | 2025.03.07 23:06:07.229307 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} <Debug> oximeter.measurements_histogrami8 (7e417eee-062f-4f30-9136-f8fda29e3a31): Loading data parts | ||
| 446 | 2025.03.07 23:06:07.231049 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} <Debug> oximeter.measurements_histogrami8 (7e417eee-062f-4f30-9136-f8fda29e3a31): There are no data parts | ||
| 447 | 2025.03.07 23:06:07.238643 [ 189540 ] {8be5d0c1-266c-4bde-aa34-e194da1e6ef6} <Debug> TCPHandler: Processed in 0.0190908 sec. | ||
| 448 | 2025.03.07 23:06:07.239125 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 449 | 2025.03.07 23:06:07.239471 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 450 | 2025.03.07 23:06:07.241169 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 451 | 2025.03.07 23:06:07.249603 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} <Debug> oximeter.measurements_histogramu8 (7cc852d4-397e-41e4-8f16-448e0f834dc3): Loading data parts | ||
| 452 | 2025.03.07 23:06:07.249806 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} <Debug> oximeter.measurements_histogramu8 (7cc852d4-397e-41e4-8f16-448e0f834dc3): There are no data parts | ||
| 453 | 2025.03.07 23:06:07.256152 [ 189540 ] {15e85cae-18c6-4657-af4a-57785c1a816f} <Debug> TCPHandler: Processed in 0.01719913 sec. | ||
| 454 | 2025.03.07 23:06:07.256473 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 455 | 2025.03.07 23:06:07.256704 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 456 | 2025.03.07 23:06:07.256743 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 457 | 2025.03.07 23:06:07.264118 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} <Debug> oximeter.measurements_histogrami16 (5087c0fd-9ef4-4957-8889-76bb46a9a65d): Loading data parts | ||
| 458 | 2025.03.07 23:06:07.265434 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} <Debug> oximeter.measurements_histogrami16 (5087c0fd-9ef4-4957-8889-76bb46a9a65d): There are no data parts | ||
| 459 | 2025.03.07 23:06:07.271340 [ 189540 ] {c991918f-9abd-4119-b793-bfd830fb305c} <Debug> TCPHandler: Processed in 0.014943891 sec. | ||
| 460 | 2025.03.07 23:06:07.272000 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 461 | 2025.03.07 23:06:07.272290 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 462 | 2025.03.07 23:06:07.272342 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 463 | 2025.03.07 23:06:07.285308 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} <Debug> oximeter.measurements_histogramu16 (a6fc5e08-1138-4198-849e-260c62e0cb9e): Loading data parts | ||
| 464 | 2025.03.07 23:06:07.291110 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} <Debug> oximeter.measurements_histogramu16 (a6fc5e08-1138-4198-849e-260c62e0cb9e): There are no data parts | ||
| 465 | 2025.03.07 23:06:07.299061 [ 189540 ] {8e71ec91-8385-428f-90e1-e97ec8c4bec2} <Debug> TCPHandler: Processed in 0.02713668 sec. | ||
| 466 | 2025.03.07 23:06:07.299536 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 467 | 2025.03.07 23:06:07.300967 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 468 | 2025.03.07 23:06:07.301030 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 469 | 2025.03.07 23:06:07.323252 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} <Debug> oximeter.measurements_histogrami32 (9ce7fb8f-6539-4648-9423-ba3a0af93156): Loading data parts | ||
| 470 | 2025.03.07 23:06:07.331107 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} <Debug> oximeter.measurements_histogrami32 (9ce7fb8f-6539-4648-9423-ba3a0af93156): There are no data parts | ||
| 471 | 2025.03.07 23:06:07.336103 [ 189540 ] {01ded20c-29c8-4b72-b907-994175eb2df7} <Debug> TCPHandler: Processed in 0.036691421 sec. | ||
| 472 | 2025.03.07 23:06:07.336491 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 473 | 2025.03.07 23:06:07.336770 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 474 | 2025.03.07 23:06:07.336962 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 475 | 2025.03.07 23:06:07.350339 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} <Debug> oximeter.measurements_histogramu32 (270836f9-9da3-4650-81df-6a8c6deb4c04): Loading data parts | ||
| 476 | 2025.03.07 23:06:07.351537 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} <Debug> oximeter.measurements_histogramu32 (270836f9-9da3-4650-81df-6a8c6deb4c04): There are no data parts | ||
| 477 | 2025.03.07 23:06:07.355296 [ 189540 ] {93227c88-94fb-4c9e-b6cc-9459cee394e8} <Debug> TCPHandler: Processed in 0.01887635 sec. | ||
| 478 | 2025.03.07 23:06:07.355873 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 479 | 2025.03.07 23:06:07.356172 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 480 | 2025.03.07 23:06:07.356248 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 481 | 2025.03.07 23:06:07.361313 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} <Debug> oximeter.measurements_histogrami64 (000024c6-c866-4d5d-8eb2-dafd73580abe): Loading data parts | ||
| 482 | 2025.03.07 23:06:07.362468 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} <Debug> oximeter.measurements_histogrami64 (000024c6-c866-4d5d-8eb2-dafd73580abe): There are no data parts | ||
| 483 | 2025.03.07 23:06:07.369093 [ 189540 ] {b70ffab7-67d7-4faa-805a-8242f205a5a7} <Debug> TCPHandler: Processed in 0.01328888 sec. | ||
| 484 | 2025.03.07 23:06:07.369506 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 485 | 2025.03.07 23:06:07.369818 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 486 | 2025.03.07 23:06:07.372014 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 487 | 2025.03.07 23:06:07.380645 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} <Debug> oximeter.measurements_histogramu64 (8db5744f-6573-41b3-bc7c-0808f4458f54): Loading data parts | ||
| 488 | 2025.03.07 23:06:07.381276 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} <Debug> oximeter.measurements_histogramu64 (8db5744f-6573-41b3-bc7c-0808f4458f54): There are no data parts | ||
| 489 | 2025.03.07 23:06:07.387721 [ 189540 ] {26a3a6d9-8e88-489a-b4ea-518cb57dfd21} <Debug> TCPHandler: Processed in 0.01834111 sec. | ||
| 490 | 2025.03.07 23:06:07.388150 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 491 | 2025.03.07 23:06:07.388483 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 492 | 2025.03.07 23:06:07.389706 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 493 | 2025.03.07 23:06:07.395401 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} <Debug> oximeter.measurements_histogramf32 (f63570e8-0014-48a9-ad33-e42178af179f): Loading data parts | ||
| 494 | 2025.03.07 23:06:07.395683 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} <Debug> oximeter.measurements_histogramf32 (f63570e8-0014-48a9-ad33-e42178af179f): There are no data parts | ||
| 495 | 2025.03.07 23:06:07.401476 [ 189540 ] {91674d78-c78a-4055-8e43-ac660a552a7b} <Debug> TCPHandler: Processed in 0.01345926 sec. | ||
| 496 | 2025.03.07 23:06:07.402193 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 497 | 2025.03.07 23:06:07.404899 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 498 | 2025.03.07 23:06:07.404963 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 499 | 2025.03.07 23:06:07.412369 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} <Debug> oximeter.measurements_histogramf64 (52a6bb77-8ee5-46e5-9423-d59efd9383d0): Loading data parts | ||
| 500 | 2025.03.07 23:06:07.412653 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} <Debug> oximeter.measurements_histogramf64 (52a6bb77-8ee5-46e5-9423-d59efd9383d0): There are no data parts | ||
| 501 | 2025.03.07 23:06:07.417478 [ 189540 ] {edcf8d51-eae3-4aee-95a8-93a5640a8c4f} <Debug> TCPHandler: Processed in 0.015369861 sec. | ||
| 502 | 2025.03.07 23:06:07.417888 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 503 | 2025.03.07 23:06:07.419560 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} <Debug> executeQuery: (from [::1]:37198) /* The field tables store named dimensions of each timeseries. | ||
| 504 | * | ||
| 505 | * As with the measurement tables, there is one field table for each field data | ||
| 506 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 507 | * this behavior **must not** be relied upon for query correctness. | ||
| 508 | * | ||
| 509 | * The index for the fields differs from the measurements, however. Rows are | ||
| 510 | * sorted by timeseries name, then field name, field value, and finally | ||
| 511 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 512 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 513 | * usually then used to look up measurements. | ||
| 514 | * | ||
| 515 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 516 | * timeseries name and then key, since it would improve lookups where one | ||
| 517 | * already has the key. Realistically though, these tables are quite small and | ||
| 518 | * so performance benefits will be low in absolute terms. | ||
| 519 | * | ||
| 520 | * TTL: We use a materialized column to expire old field table records. This | ||
| 521 | * column is generated automatically by the database whenever a new row is | ||
| 522 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 523 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 524 | * record will remain during a deduplication, which will have the last | ||
| 525 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 526 | * measurement tables. | ||
| 527 | */ | ||
| 528 | 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) | ||
| 529 | 2025.03.07 23:06:07.419627 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 530 | 2025.03.07 23:06:07.425164 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} <Debug> oximeter.fields_bool (b00057c3-d4f8-4f64-8628-3482b987b43e): Loading data parts | ||
| 531 | 2025.03.07 23:06:07.428491 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} <Debug> oximeter.fields_bool (b00057c3-d4f8-4f64-8628-3482b987b43e): There are no data parts | ||
| 532 | 2025.03.07 23:06:07.436335 [ 189540 ] {211de9c4-324e-4c65-b860-abe1f55c7aa0} <Debug> TCPHandler: Processed in 0.01854937 sec. | ||
| 533 | 2025.03.07 23:06:07.436706 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 534 | 2025.03.07 23:06:07.436926 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 535 | 2025.03.07 23:06:07.436990 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 536 | 2025.03.07 23:06:07.443047 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} <Debug> oximeter.fields_i8 (efde99ef-587c-4e14-a429-3c58fa388b02): Loading data parts | ||
| 537 | 2025.03.07 23:06:07.444488 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} <Debug> oximeter.fields_i8 (efde99ef-587c-4e14-a429-3c58fa388b02): There are no data parts | ||
| 538 | 2025.03.07 23:06:07.452245 [ 189540 ] {ccbbb1b0-8a05-4600-b793-71cfcfc88201} <Debug> TCPHandler: Processed in 0.01564622 sec. | ||
| 539 | 2025.03.07 23:06:07.453090 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 540 | 2025.03.07 23:06:07.454443 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 541 | 2025.03.07 23:06:07.454492 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 542 | 2025.03.07 23:06:07.462210 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} <Debug> oximeter.fields_u8 (cc91961d-1107-432e-a0e9-fcf2071614ab): Loading data parts | ||
| 543 | 2025.03.07 23:06:07.462475 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} <Debug> oximeter.fields_u8 (cc91961d-1107-432e-a0e9-fcf2071614ab): There are no data parts | ||
| 544 | 2025.03.07 23:06:07.468768 [ 189540 ] {2db7c686-afdc-4548-9738-19541fc06f2c} <Debug> TCPHandler: Processed in 0.015766811 sec. | ||
| 545 | 2025.03.07 23:06:07.469555 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 546 | 2025.03.07 23:06:07.471127 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 547 | 2025.03.07 23:06:07.471183 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 548 | 2025.03.07 23:06:07.476594 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} <Debug> oximeter.fields_i16 (81d4cb92-032a-4459-ab44-ee557e049542): Loading data parts | ||
| 549 | 2025.03.07 23:06:07.476880 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} <Debug> oximeter.fields_i16 (81d4cb92-032a-4459-ab44-ee557e049542): There are no data parts | ||
| 550 | 2025.03.07 23:06:07.483101 [ 189540 ] {bc57eca8-d826-40b4-8013-85eb9cb0714c} <Debug> TCPHandler: Processed in 0.01364968 sec. | ||
| 551 | 2025.03.07 23:06:07.483442 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 552 | 2025.03.07 23:06:07.483597 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 553 | 2025.03.07 23:06:07.483630 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 554 | 2025.03.07 23:06:07.493289 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} <Debug> oximeter.fields_u16 (5072ede2-61d3-4946-af95-9803a053bd51): Loading data parts | ||
| 555 | 2025.03.07 23:06:07.493639 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} <Debug> oximeter.fields_u16 (5072ede2-61d3-4946-af95-9803a053bd51): There are no data parts | ||
| 556 | 2025.03.07 23:06:07.500771 [ 189540 ] {77c93f9e-9dcc-40a5-90a9-a6f5c14b91db} <Debug> TCPHandler: Processed in 0.0173971 sec. | ||
| 557 | 2025.03.07 23:06:07.501123 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 558 | 2025.03.07 23:06:07.501305 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 559 | 2025.03.07 23:06:07.501346 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 560 | 2025.03.07 23:06:07.508766 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} <Debug> oximeter.fields_i32 (9f3ad90e-d1f2-4714-b651-923b5a45873c): Loading data parts | ||
| 561 | 2025.03.07 23:06:07.508947 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} <Debug> oximeter.fields_i32 (9f3ad90e-d1f2-4714-b651-923b5a45873c): There are no data parts | ||
| 562 | 2025.03.07 23:06:07.518605 [ 189540 ] {67036dab-c06f-41cc-bfc0-f8e10c6dbdfd} <Debug> TCPHandler: Processed in 0.01754631 sec. | ||
| 563 | 2025.03.07 23:06:07.518926 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 564 | 2025.03.07 23:06:07.519214 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 565 | 2025.03.07 23:06:07.519274 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 566 | 2025.03.07 23:06:07.527321 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} <Debug> oximeter.fields_u32 (a78d85c5-cdcc-4d95-905a-8ed201c203ce): Loading data parts | ||
| 567 | 2025.03.07 23:06:07.529404 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} <Debug> oximeter.fields_u32 (a78d85c5-cdcc-4d95-905a-8ed201c203ce): There are no data parts | ||
| 568 | 2025.03.07 23:06:07.543724 [ 189540 ] {ea067207-8895-4a3f-8b95-65f7ef49aa7c} <Debug> TCPHandler: Processed in 0.024870251 sec. | ||
| 569 | 2025.03.07 23:06:07.544145 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 570 | 2025.03.07 23:06:07.545871 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 571 | 2025.03.07 23:06:07.545924 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 572 | 2025.03.07 23:06:07.552482 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} <Debug> oximeter.fields_i64 (45f58419-48f7-4132-ad99-da5cecddfd3b): Loading data parts | ||
| 573 | 2025.03.07 23:06:07.552714 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} <Debug> oximeter.fields_i64 (45f58419-48f7-4132-ad99-da5cecddfd3b): There are no data parts | ||
| 574 | 2025.03.07 23:06:07.559522 [ 189540 ] {0bd77e5b-d5d2-4a31-bc3a-e8313770481d} <Debug> TCPHandler: Processed in 0.01550932 sec. | ||
| 575 | 2025.03.07 23:06:07.559890 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 576 | 2025.03.07 23:06:07.561613 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 577 | 2025.03.07 23:06:07.561657 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 578 | 2025.03.07 23:06:07.569696 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} <Debug> oximeter.fields_u64 (a153f92f-27a4-4732-a175-7bbe24ac2fda): Loading data parts | ||
| 579 | 2025.03.07 23:06:07.571626 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} <Debug> oximeter.fields_u64 (a153f92f-27a4-4732-a175-7bbe24ac2fda): There are no data parts | ||
| 580 | 2025.03.07 23:06:07.578909 [ 189540 ] {7db3ce8b-e3b7-4b36-9426-039379b8c224} <Debug> TCPHandler: Processed in 0.01910419 sec. | ||
| 581 | 2025.03.07 23:06:07.579816 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 582 | 2025.03.07 23:06:07.581481 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 583 | 2025.03.07 23:06:07.581528 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 584 | 2025.03.07 23:06:07.587116 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} <Debug> oximeter.fields_ipaddr (79407497-43eb-4460-9ce0-b97f1145122b): Loading data parts | ||
| 585 | 2025.03.07 23:06:07.587322 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} <Debug> oximeter.fields_ipaddr (79407497-43eb-4460-9ce0-b97f1145122b): There are no data parts | ||
| 586 | 2025.03.07 23:06:07.598117 [ 189540 ] {c7ead0d6-f8ed-4e64-ab73-720a31255033} <Debug> TCPHandler: Processed in 0.01837679 sec. | ||
| 587 | 2025.03.07 23:06:07.598532 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 588 | 2025.03.07 23:06:07.598771 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 589 | 2025.03.07 23:06:07.598824 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 590 | 2025.03.07 23:06:07.606424 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} <Debug> oximeter.fields_string (2ffeab99-1849-4cb4-be7a-0029de35d59f): Loading data parts | ||
| 591 | 2025.03.07 23:06:07.607973 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} <Debug> oximeter.fields_string (2ffeab99-1849-4cb4-be7a-0029de35d59f): There are no data parts | ||
| 592 | 2025.03.07 23:06:07.613652 [ 189540 ] {b7b3b1c8-0262-426e-804c-0b7ae7e59af4} <Debug> TCPHandler: Processed in 0.01523978 sec. | ||
| 593 | 2025.03.07 23:06:07.614079 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 594 | 2025.03.07 23:06:07.614367 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} <Debug> executeQuery: (from [::1]:37198) 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) | ||
| 595 | 2025.03.07 23:06:07.614418 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 596 | 2025.03.07 23:06:07.620520 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} <Debug> oximeter.fields_uuid (e4271603-6969-442b-b562-f16e0a9d5ad6): Loading data parts | ||
| 597 | 2025.03.07 23:06:07.622068 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} <Debug> oximeter.fields_uuid (e4271603-6969-442b-b562-f16e0a9d5ad6): There are no data parts | ||
| 598 | 2025.03.07 23:06:07.629422 [ 189540 ] {f1928736-28c4-4017-a6b7-da17efbc78cc} <Debug> TCPHandler: Processed in 0.01545026 sec. | ||
| 599 | 2025.03.07 23:06:07.629805 [ 189540 ] {} <Trace> TCP-Session: 597cb623-2208-44b2-8906-4561806b0baa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 600 | 2025.03.07 23:06:07.632154 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} <Debug> executeQuery: (from [::1]:37198) /* The timeseries schema table stores the extracted schema for the samples | ||
| 601 | * oximeter collects. | ||
| 602 | */ | ||
| 603 | 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) | ||
| 604 | 2025.03.07 23:06:07.632210 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 605 | 2025.03.07 23:06:07.638769 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} <Debug> oximeter.timeseries_schema (a29c0f74-def9-45c8-9eb7-96cb7a9b0eed): Loading data parts | ||
| 606 | 2025.03.07 23:06:07.639058 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} <Debug> oximeter.timeseries_schema (a29c0f74-def9-45c8-9eb7-96cb7a9b0eed): There are no data parts | ||
| 607 | 2025.03.07 23:06:07.647658 [ 189540 ] {ca4f0add-2970-4dac-bd3e-0b0fe283ce40} <Debug> TCPHandler: Processed in 0.01796871 sec. | ||
| 608 | 2025.03.07 23:06:07.648215 [ 189480 ] {} <Trace> TCP-Session: 1d8a70c8-d285-449b-ad84-c86b1d57db6c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 609 | 2025.03.07 23:06:07.648388 [ 189480 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} <Debug> executeQuery: (from [::1]:37192) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 610 | 2025.03.07 23:06:07.648468 [ 189480 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 611 | 2025.03.07 23:06:07.649264 [ 189621 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} <Trace> oximeter.version (6e8d9d1c-e902-4bd9-8343-d5745ada33f7): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 612 | 2025.03.07 23:06:07.649288 [ 189621 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 160.50 GiB. | ||
| 613 | 2025.03.07 23:06:07.650246 [ 189621 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 614 | 2025.03.07 23:06:07.650445 [ 189621 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} <Trace> oximeter.version (6e8d9d1c-e902-4bd9-8343-d5745ada33f7): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 615 | 2025.03.07 23:06:07.650625 [ 189480 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.002298 sec., 435.1610095735422 rows/sec., 6.80 KiB/sec. | ||
| 616 | 2025.03.07 23:06:07.650783 [ 189480 ] {f88d5ec3-3e29-4b6c-b70b-ab4742d7def5} <Debug> TCPHandler: Processed in 0.00269855 sec. | ||