| 1 | 2024.12.20 21:46:17.250971 [ 163674 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2024.12.20 21:46:17.251134 [ 163674 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2024.12.20 21:46:17.334264 [ 163674 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 163674 | ||
| 4 | 2024.12.20 21:46:17.334328 [ 163674 ] {} <Information> Application: starting up | ||
| 5 | 2024.12.20 21:46:17.334342 [ 163674 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2024.12.20 21:46:17.342050 [ 163674 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2024.12.20 21:46:17.386332 [ 163674 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2024.12.20 21:46:17.386587 [ 163674 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2024.12.20 21:46:17.386642 [ 163674 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2024.12.20 21:46:17.386659 [ 163674 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2024.12.20 21:46:17.640522 [ 163674 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2024.12.20 21:46:17.640566 [ 163674 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 13 | 2024.12.20 21:46:17.647480 [ 163674 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2024.12.20 21:46:17.647504 [ 163674 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2024.12.20 21:46:17.647514 [ 163674 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2024.12.20 21:46:17.647520 [ 163674 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2024.12.20 21:46:17.647547 [ 163674 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/datastore/tmp/ to store temporary data in it | ||
| 18 | 2024.12.20 21:46:17.647851 [ 163674 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2024.12.20 21:46:17.648489 [ 163674 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml' | ||
| 20 | 2024.12.20 21:46:17.649076 [ 163674 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml', performing update on configuration | ||
| 21 | 2024.12.20 21:46:17.650050 [ 163674 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 22 | 2024.12.20 21:46:17.651539 [ 163674 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 23 | 2024.12.20 21:46:17.651553 [ 163674 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2024.12.20 21:46:17.651622 [ 163674 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2024.12.20 21:46:17.652588 [ 163674 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2024.12.20 21:46:17.660947 [ 163674 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2024.12.20 21:46:17.666812 [ 163674 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2024.12.20 21:46:17.668550 [ 163674 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2024.12.20 21:46:17.668569 [ 163674 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml', performed update on configuration | ||
| 30 | 2024.12.20 21:46:17.670747 [ 163674 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml' | ||
| 31 | 2024.12.20 21:46:17.671248 [ 163674 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml', performing update on configuration | ||
| 32 | 2024.12.20 21:46:17.672002 [ 163674 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml', performed update on configuration | ||
| 33 | 2024.12.20 21:46:17.672278 [ 163674 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/config.xml | ||
| 34 | 2024.12.20 21:46:17.672827 [ 163674 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2024.12.20 21:46:17.673074 [ 163674 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2024.12.20 21:46:17.673325 [ 163674 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2024.12.20 21:46:17.673550 [ 163674 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2024.12.20 21:46:17.674097 [ 163674 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2024.12.20 21:46:17.674113 [ 163674 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/datastore/ | ||
| 40 | 2024.12.20 21:46:17.674575 [ 163694 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 41 | 2024.12.20 21:46:17.674595 [ 163694 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 42 | 2024.12.20 21:46:17.698996 [ 163674 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2024.12.20 21:46:17.699026 [ 163674 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.007974566 sec | ||
| 44 | 2024.12.20 21:46:17.699035 [ 163674 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2024.12.20 21:46:17.699040 [ 163674 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2024.12.20 21:46:17.699077 [ 163674 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2024.12.20 21:46:17.699104 [ 163674 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2024.12.20 21:46:17.699999 [ 163674 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2024.12.20 21:46:17.700018 [ 163674 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2024.12.20 21:46:17.700026 [ 163674 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2024.12.20 21:46:17.700053 [ 163674 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2024.12.20 21:46:17.700060 [ 163674 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2024.12.20 21:46:17.700069 [ 163674 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 54 | 2024.12.20 21:46:17.702199 [ 163674 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2024.12.20 21:46:17.702216 [ 163674 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2024.12.20 21:46:17.702224 [ 163674 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 57 | 2024.12.20 21:46:17.702382 [ 163674 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2024.12.20 21:46:17.702394 [ 163674 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2024.12.20 21:46:17.702402 [ 163674 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2024.12.20 21:46:17.702409 [ 163674 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2024.12.20 21:46:17.702416 [ 163674 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2024.12.20 21:46:17.702423 [ 163674 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2024.12.20 21:46:17.702429 [ 163674 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2024.12.20 21:46:17.721834 [ 163674 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2024.12.20 21:46:17.727940 [ 163674 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2024.12.20 21:46:17.727963 [ 163674 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.79e-05 sec | ||
| 67 | 2024.12.20 21:46:17.727970 [ 163674 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2024.12.20 21:46:17.727975 [ 163674 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2024.12.20 21:46:17.727999 [ 163674 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2024.12.20 21:46:17.728097 [ 163674 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-e39a2a7c7389546b-test_mgs_metrics.163597.1-clickhouse-LYWAkS/datastore/user_defined/ | ||
| 71 | 2024.12.20 21:46:17.728130 [ 163674 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2024.12.20 21:46:17.728137 [ 163674 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2024.12.20 21:46:17.728157 [ 163674 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2024.12.20 21:46:17.728163 [ 163674 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 75 | 2024.12.20 21:46:17.728230 [ 163674 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 36651 | ||
| 76 | 2024.12.20 21:46:17.728343 [ 163674 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 35117 | ||
| 77 | 2024.12.20 21:46:17.728583 [ 163674 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34307 | ||
| 78 | 2024.12.20 21:46:17.730755 [ 163674 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 38999 | ||
| 79 | 2024.12.20 21:46:17.730786 [ 163674 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2024.12.20 21:46:17.731177 [ 163674 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.64 MiB, peak 20.64 MiB, free memory in arenas 21.78 MiB, will set to 386.88 MiB (RSS), difference: 366.24 MiB | ||
| 81 | 2024.12.20 21:46:17.731726 [ 163674 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.882e-05 sec. | ||
| 82 | 2024.12.20 21:46:17.732719 [ 163674 ] {} <Information> Application: Listening for http://[::1]:36651 | ||
| 83 | 2024.12.20 21:46:17.733219 [ 163674 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:35117 | ||
| 84 | 2024.12.20 21:46:17.733294 [ 163674 ] {} <Information> Application: Listening for http://127.0.0.1:34307 | ||
| 85 | 2024.12.20 21:46:17.733339 [ 163674 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:38999 | ||
| 86 | 2024.12.20 21:46:17.733348 [ 163674 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2024.12.20 21:46:18.713946 [ 163685 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37710 | ||
| 88 | 2024.12.20 21:46:18.714111 [ 163685 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2024.12.20 21:46:18.714154 [ 163685 ] {} <Debug> TCP-Session: c01cd7dc-be2c-4497-8425-84fc3d9b40d5 Authenticating user 'default' from [::1]:37710 | ||
| 90 | 2024.12.20 21:46:18.714172 [ 163685 ] {} <Debug> TCP-Session: c01cd7dc-be2c-4497-8425-84fc3d9b40d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2024.12.20 21:46:18.714180 [ 163685 ] {} <Debug> TCP-Session: c01cd7dc-be2c-4497-8425-84fc3d9b40d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2024.12.20 21:46:18.714276 [ 163685 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2024.12.20 21:46:18.714301 [ 163685 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 94 | 2024.12.20 21:46:18.714312 [ 163685 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 95 | 2024.12.20 21:46:18.717558 [ 163686 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37712 | ||
| 96 | 2024.12.20 21:46:18.718347 [ 163686 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 97 | 2024.12.20 21:46:18.718384 [ 163686 ] {} <Debug> TCP-Session: cb85dd48-2b54-45af-a109-90ba2625871b Authenticating user 'default' from [::1]:37712 | ||
| 98 | 2024.12.20 21:46:18.718395 [ 163686 ] {} <Debug> TCP-Session: cb85dd48-2b54-45af-a109-90ba2625871b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 99 | 2024.12.20 21:46:18.718400 [ 163686 ] {} <Debug> TCP-Session: cb85dd48-2b54-45af-a109-90ba2625871b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 100 | 2024.12.20 21:46:18.762571 [ 164295 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37716 | ||
| 101 | 2024.12.20 21:46:18.762717 [ 164295 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 102 | 2024.12.20 21:46:18.762720 [ 164297 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37718 | ||
| 103 | 2024.12.20 21:46:18.762758 [ 164295 ] {} <Debug> TCP-Session: 89f1b19f-3cd9-47d3-85ff-990c20f333b4 Authenticating user 'default' from [::1]:37716 | ||
| 104 | 2024.12.20 21:46:18.762748 [ 164296 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37720 | ||
| 105 | 2024.12.20 21:46:18.762778 [ 164295 ] {} <Debug> TCP-Session: 89f1b19f-3cd9-47d3-85ff-990c20f333b4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 106 | 2024.12.20 21:46:18.762788 [ 164295 ] {} <Debug> TCP-Session: 89f1b19f-3cd9-47d3-85ff-990c20f333b4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 107 | 2024.12.20 21:46:18.762846 [ 164297 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 108 | 2024.12.20 21:46:18.762871 [ 164297 ] {} <Debug> TCP-Session: a4e35bbc-09fd-406a-8cd8-f143116b327e Authenticating user 'default' from [::1]:37718 | ||
| 109 | 2024.12.20 21:46:18.762881 [ 164297 ] {} <Debug> TCP-Session: a4e35bbc-09fd-406a-8cd8-f143116b327e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2024.12.20 21:46:18.762900 [ 164297 ] {} <Debug> TCP-Session: a4e35bbc-09fd-406a-8cd8-f143116b327e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 111 | 2024.12.20 21:46:18.762950 [ 164296 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 112 | 2024.12.20 21:46:18.762962 [ 164299 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37724 | ||
| 113 | 2024.12.20 21:46:18.762979 [ 164296 ] {} <Debug> TCP-Session: eee21fc0-c0a2-4fd3-be7c-3d10ae4254d5 Authenticating user 'default' from [::1]:37720 | ||
| 114 | 2024.12.20 21:46:18.762991 [ 164296 ] {} <Debug> TCP-Session: eee21fc0-c0a2-4fd3-be7c-3d10ae4254d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 115 | 2024.12.20 21:46:18.762998 [ 164296 ] {} <Debug> TCP-Session: eee21fc0-c0a2-4fd3-be7c-3d10ae4254d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 116 | 2024.12.20 21:46:18.763054 [ 163687 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37714 | ||
| 117 | 2024.12.20 21:46:18.763066 [ 164299 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 118 | 2024.12.20 21:46:18.763091 [ 164299 ] {} <Debug> TCP-Session: 1ba093a6-8e4e-4e11-a2c4-618d63a655d1 Authenticating user 'default' from [::1]:37724 | ||
| 119 | 2024.12.20 21:46:18.763099 [ 164299 ] {} <Debug> TCP-Session: 1ba093a6-8e4e-4e11-a2c4-618d63a655d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 120 | 2024.12.20 21:46:18.763105 [ 164299 ] {} <Debug> TCP-Session: 1ba093a6-8e4e-4e11-a2c4-618d63a655d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 121 | 2024.12.20 21:46:18.763714 [ 163687 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 122 | 2024.12.20 21:46:18.763741 [ 163687 ] {} <Debug> TCP-Session: b35065ad-e78a-408b-b80a-038cb6f3387b Authenticating user 'default' from [::1]:37714 | ||
| 123 | 2024.12.20 21:46:18.763751 [ 163687 ] {} <Debug> TCP-Session: b35065ad-e78a-408b-b80a-038cb6f3387b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 124 | 2024.12.20 21:46:18.763756 [ 163687 ] {} <Debug> TCP-Session: b35065ad-e78a-408b-b80a-038cb6f3387b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 125 | 2024.12.20 21:46:18.763886 [ 164298 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37722 | ||
| 126 | 2024.12.20 21:46:18.764026 [ 164298 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2024.12.20 21:46:18.764053 [ 164298 ] {} <Debug> TCP-Session: e4260139-2245-434d-b2fd-48c112175f41 Authenticating user 'default' from [::1]:37722 | ||
| 128 | 2024.12.20 21:46:18.764064 [ 164298 ] {} <Debug> TCP-Session: e4260139-2245-434d-b2fd-48c112175f41 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2024.12.20 21:46:18.764158 [ 164298 ] {} <Debug> TCP-Session: e4260139-2245-434d-b2fd-48c112175f41 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2024.12.20 21:46:25.205959 [ 163761 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1958 entries to flush up to offset 1958 | ||
| 131 | 2024.12.20 21:46:25.206022 [ 163761 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 132 | 2024.12.20 21:46:25.207083 [ 163761 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 133 | 2024.12.20 21:46:25.209422 [ 163931 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 134 | 2024.12.20 21:46:25.210046 [ 163931 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 135 | 2024.12.20 21:46:25.210940 [ 163761 ] {} <Debug> system.asynchronous_metric_log (3a5108c8-8292-4572-a2cf-f2befc479079): Loading data parts | ||
| 136 | 2024.12.20 21:46:25.216729 [ 163761 ] {} <Debug> system.asynchronous_metric_log (3a5108c8-8292-4572-a2cf-f2befc479079): There are no data parts | ||
| 137 | 2024.12.20 21:46:25.221214 [ 163761 ] {} <Trace> system.asynchronous_metric_log (3a5108c8-8292-4572-a2cf-f2befc479079): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 138 | 2024.12.20 21:46:25.221245 [ 163761 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.13 GiB. | ||
| 139 | 2024.12.20 21:46:25.223093 [ 163761 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 140 | 2024.12.20 21:46:25.224854 [ 163761 ] {} <Trace> system.asynchronous_metric_log (3a5108c8-8292-4572-a2cf-f2befc479079): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 141 | 2024.12.20 21:46:25.225028 [ 163761 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1958 | ||
| 142 | 2024.12.20 21:46:25.231519 [ 163931 ] {} <Debug> system.metric_log (b95523a4-032e-497a-aa58-ff365afef9e1): Loading data parts | ||
| 143 | 2024.12.20 21:46:25.232534 [ 163931 ] {} <Debug> system.metric_log (b95523a4-032e-497a-aa58-ff365afef9e1): There are no data parts | ||
| 144 | 2024.12.20 21:46:25.255443 [ 163931 ] {} <Trace> system.metric_log (b95523a4-032e-497a-aa58-ff365afef9e1): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 145 | 2024.12.20 21:46:25.255486 [ 163931 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.13 GiB. | ||
| 146 | 2024.12.20 21:46:25.263871 [ 163931 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 147 | 2024.12.20 21:46:25.265540 [ 163931 ] {} <Trace> system.metric_log (b95523a4-032e-497a-aa58-ff365afef9e1): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 148 | 2024.12.20 21:46:25.268376 [ 163931 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 149 | 2024.12.20 21:46:27.836497 [ 165543 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37730 | ||
| 150 | 2024.12.20 21:46:27.836730 [ 165543 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 151 | 2024.12.20 21:46:27.836760 [ 165543 ] {} <Debug> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Authenticating user 'default' from [::1]:37730 | ||
| 152 | 2024.12.20 21:46:27.836777 [ 165543 ] {} <Debug> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 153 | 2024.12.20 21:46:27.836785 [ 165543 ] {} <Debug> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2024.12.20 21:46:27.846223 [ 165544 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37732 | ||
| 155 | 2024.12.20 21:46:27.846401 [ 165545 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37734 | ||
| 156 | 2024.12.20 21:46:27.846939 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 157 | 2024.12.20 21:46:27.847146 [ 165545 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 158 | 2024.12.20 21:46:27.847185 [ 165545 ] {} <Debug> TCP-Session: 58429971-7778-45ba-b04b-a73e16fef1b4 Authenticating user 'default' from [::1]:37734 | ||
| 159 | 2024.12.20 21:46:27.847248 [ 165543 ] {122169d1-2475-41ee-84da-4890f22c85ac} <Debug> executeQuery: (from [::1]:37730) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 160 | 2024.12.20 21:46:27.847281 [ 165545 ] {} <Debug> TCP-Session: 58429971-7778-45ba-b04b-a73e16fef1b4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 161 | 2024.12.20 21:46:27.847578 [ 165545 ] {} <Debug> TCP-Session: 58429971-7778-45ba-b04b-a73e16fef1b4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 162 | 2024.12.20 21:46:27.847584 [ 165544 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 163 | 2024.12.20 21:46:27.847637 [ 165544 ] {} <Debug> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Authenticating user 'default' from [::1]:37732 | ||
| 164 | 2024.12.20 21:46:27.847647 [ 165544 ] {} <Debug> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 165 | 2024.12.20 21:46:27.847653 [ 165544 ] {} <Debug> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 166 | 2024.12.20 21:46:27.847940 [ 165543 ] {122169d1-2475-41ee-84da-4890f22c85ac} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:37730) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 167 | |||
| 168 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 171 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 172 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 173 | 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 | ||
| 174 | 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 | ||
| 175 | 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 | ||
| 176 | 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 | ||
| 177 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 178 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 179 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 180 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 181 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 182 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 183 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 184 | 16. ? @ 0x00007f3668970ac3 in ? | ||
| 185 | 17. ? @ 0x00007f3668a02850 in ? | ||
| 186 | |||
| 187 | 2024.12.20 21:46:27.848071 [ 165543 ] {122169d1-2475-41ee-84da-4890f22c85ac} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 188 | |||
| 189 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 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 | ||
| 195 | 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 | ||
| 196 | 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 | ||
| 197 | 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 | ||
| 198 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 199 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 200 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 201 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 202 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 203 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 204 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 205 | 16. ? @ 0x00007f3668970ac3 in ? | ||
| 206 | 17. ? @ 0x00007f3668a02850 in ? | ||
| 207 | |||
| 208 | 2024.12.20 21:46:27.848125 [ 165543 ] {122169d1-2475-41ee-84da-4890f22c85ac} <Debug> TCPHandler: Processed in 0.001379041 sec. | ||
| 209 | 2024.12.20 21:46:27.852393 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 210 | 2024.12.20 21:46:27.859616 [ 165544 ] {252d26dc-b329-46af-bb9c-cb2e9867bc02} <Debug> executeQuery: (from [::1]:37732) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 211 | 2024.12.20 21:46:27.859916 [ 165544 ] {252d26dc-b329-46af-bb9c-cb2e9867bc02} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:37732) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 212 | |||
| 213 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 214 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 215 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 216 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 217 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 218 | 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 | ||
| 219 | 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 | ||
| 220 | 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 | ||
| 221 | 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 | ||
| 222 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 223 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 224 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 225 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 226 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 227 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 228 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 229 | 16. ? @ 0x00007f3668970ac3 in ? | ||
| 230 | 17. ? @ 0x00007f3668a02850 in ? | ||
| 231 | |||
| 232 | 2024.12.20 21:46:27.860037 [ 165544 ] {252d26dc-b329-46af-bb9c-cb2e9867bc02} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 233 | |||
| 234 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 235 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 236 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 237 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 238 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 239 | 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 | ||
| 240 | 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 | ||
| 241 | 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 | ||
| 242 | 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 | ||
| 243 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 244 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 245 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 246 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 247 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 248 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 249 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 250 | 16. ? @ 0x00007f3668970ac3 in ? | ||
| 251 | 17. ? @ 0x00007f3668a02850 in ? | ||
| 252 | |||
| 253 | 2024.12.20 21:46:27.860087 [ 165544 ] {252d26dc-b329-46af-bb9c-cb2e9867bc02} <Debug> TCPHandler: Processed in 0.008327347 sec. | ||
| 254 | 2024.12.20 21:46:27.862038 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 255 | 2024.12.20 21:46:27.862175 [ 165543 ] {c7b2e616-ad39-45af-9d6a-5b9d2e5cfaea} <Debug> executeQuery: (from [::1]:37730) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 256 | 2024.12.20 21:46:27.863345 [ 165543 ] {c7b2e616-ad39-45af-9d6a-5b9d2e5cfaea} <Debug> TCPHandler: Processed in 0.001388691 sec. | ||
| 257 | 2024.12.20 21:46:27.864088 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 258 | 2024.12.20 21:46:27.864251 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} <Debug> executeQuery: (from [::1]:37732) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 259 | 2024.12.20 21:46:27.865340 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 260 | 2024.12.20 21:46:27.871188 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 261 | 2024.12.20 21:46:27.871213 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.894e-05 sec | ||
| 262 | 2024.12.20 21:46:27.871221 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} <Trace> ReferentialDeps: No tables | ||
| 263 | 2024.12.20 21:46:27.871226 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} <Trace> LoadingDeps: No tables | ||
| 264 | 2024.12.20 21:46:27.871249 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 265 | 2024.12.20 21:46:27.871330 [ 165544 ] {99846615-8e0e-4722-a4d9-9c7d2e0f0adf} <Debug> TCPHandler: Processed in 0.007355016 sec. | ||
| 266 | 2024.12.20 21:46:27.873096 [ 165546 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37736 | ||
| 267 | 2024.12.20 21:46:27.873216 [ 165546 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 268 | 2024.12.20 21:46:27.873248 [ 165546 ] {} <Debug> TCP-Session: 10d6ca1d-4817-4479-9f9d-ae595630a092 Authenticating user 'default' from [::1]:37736 | ||
| 269 | 2024.12.20 21:46:27.873264 [ 165546 ] {} <Debug> TCP-Session: 10d6ca1d-4817-4479-9f9d-ae595630a092 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2024.12.20 21:46:27.873271 [ 165546 ] {} <Debug> TCP-Session: 10d6ca1d-4817-4479-9f9d-ae595630a092 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2024.12.20 21:46:27.873372 [ 165546 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 272 | 2024.12.20 21:46:27.873393 [ 165546 ] {} <Debug> TCP-Session: 10d6ca1d-4817-4479-9f9d-ae595630a092 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2024.12.20 21:46:27.874651 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 274 | 2024.12.20 21:46:27.875169 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} <Debug> executeQuery: (from [::1]:37730) /* The version table contains metadata about the `oximeter` database */ | ||
| 275 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 276 | 2024.12.20 21:46:27.875213 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 277 | 2024.12.20 21:46:27.881411 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} <Debug> oximeter.version (3644c0ed-2391-49f4-bd3a-2f24dfda9862): Loading data parts | ||
| 278 | 2024.12.20 21:46:27.881750 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} <Debug> oximeter.version (3644c0ed-2391-49f4-bd3a-2f24dfda9862): There are no data parts | ||
| 279 | 2024.12.20 21:46:27.887240 [ 165548 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37740 | ||
| 280 | 2024.12.20 21:46:27.887276 [ 165546 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37744 | ||
| 281 | 2024.12.20 21:46:27.887353 [ 165549 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37742 | ||
| 282 | 2024.12.20 21:46:27.887368 [ 165547 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37738 | ||
| 283 | 2024.12.20 21:46:27.887424 [ 165550 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:37746 | ||
| 284 | 2024.12.20 21:46:27.888739 [ 165543 ] {e2ddce51-9701-4e81-8042-686a9f1c570b} <Debug> TCPHandler: Processed in 0.014237842 sec. | ||
| 285 | 2024.12.20 21:46:27.888947 [ 165546 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 286 | 2024.12.20 21:46:27.888967 [ 165546 ] {} <Debug> TCP-Session: 6852bcbb-857d-41ef-b1e1-8ec87f8245ed Authenticating user 'default' from [::1]:37744 | ||
| 287 | 2024.12.20 21:46:27.888982 [ 165546 ] {} <Debug> TCP-Session: 6852bcbb-857d-41ef-b1e1-8ec87f8245ed Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2024.12.20 21:46:27.888989 [ 165546 ] {} <Debug> TCP-Session: 6852bcbb-857d-41ef-b1e1-8ec87f8245ed Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 289 | 2024.12.20 21:46:27.889054 [ 165548 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 290 | 2024.12.20 21:46:27.889024 [ 165547 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 291 | 2024.12.20 21:46:27.889122 [ 165547 ] {} <Debug> TCP-Session: e610013a-9d17-4639-910d-9d6dc971b6b3 Authenticating user 'default' from [::1]:37738 | ||
| 292 | 2024.12.20 21:46:27.889133 [ 165547 ] {} <Debug> TCP-Session: e610013a-9d17-4639-910d-9d6dc971b6b3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2024.12.20 21:46:27.889139 [ 165547 ] {} <Debug> TCP-Session: e610013a-9d17-4639-910d-9d6dc971b6b3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2024.12.20 21:46:27.889198 [ 165549 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 295 | 2024.12.20 21:46:27.889224 [ 165548 ] {} <Debug> TCP-Session: 925db6ea-1932-4a0c-8825-65c00c12daf4 Authenticating user 'default' from [::1]:37740 | ||
| 296 | 2024.12.20 21:46:27.889235 [ 165549 ] {} <Debug> TCP-Session: f69b76c5-42b9-43a2-8cec-bb0f88a03bc0 Authenticating user 'default' from [::1]:37742 | ||
| 297 | 2024.12.20 21:46:27.889237 [ 165548 ] {} <Debug> TCP-Session: 925db6ea-1932-4a0c-8825-65c00c12daf4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 298 | 2024.12.20 21:46:27.889257 [ 165549 ] {} <Debug> TCP-Session: f69b76c5-42b9-43a2-8cec-bb0f88a03bc0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 299 | 2024.12.20 21:46:27.889262 [ 165548 ] {} <Debug> TCP-Session: 925db6ea-1932-4a0c-8825-65c00c12daf4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 300 | 2024.12.20 21:46:27.889281 [ 165549 ] {} <Debug> TCP-Session: f69b76c5-42b9-43a2-8cec-bb0f88a03bc0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 301 | 2024.12.20 21:46:27.889859 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 302 | 2024.12.20 21:46:27.891114 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} <Debug> executeQuery: (from [::1]:37732) /* The measurement tables contain all individual samples from each timeseries. | ||
| 303 | * | ||
| 304 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 305 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 306 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 307 | * by all samples from the same timeseries. | ||
| 308 | * | ||
| 309 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 310 | * and then uses that to index quickly into the measurements tables. | ||
| 311 | */ | ||
| 312 | 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) | ||
| 313 | 2024.12.20 21:46:27.891167 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 314 | 2024.12.20 21:46:27.892744 [ 165550 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 315 | 2024.12.20 21:46:27.892846 [ 165550 ] {} <Debug> TCP-Session: 1694b5a7-acbd-4c39-b386-52310c3372cb Authenticating user 'default' from [::1]:37746 | ||
| 316 | 2024.12.20 21:46:27.892860 [ 165550 ] {} <Debug> TCP-Session: 1694b5a7-acbd-4c39-b386-52310c3372cb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 317 | 2024.12.20 21:46:27.892866 [ 165550 ] {} <Debug> TCP-Session: 1694b5a7-acbd-4c39-b386-52310c3372cb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 318 | 2024.12.20 21:46:27.895933 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} <Debug> oximeter.measurements_bool (93dba19e-fdf8-4770-9a55-753c2be8f5f8): Loading data parts | ||
| 319 | 2024.12.20 21:46:27.896166 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} <Debug> oximeter.measurements_bool (93dba19e-fdf8-4770-9a55-753c2be8f5f8): There are no data parts | ||
| 320 | 2024.12.20 21:46:27.903488 [ 165544 ] {8c21d75e-9fe9-45d3-832a-cdbdb49f4281} <Debug> TCPHandler: Processed in 0.013785311 sec. | ||
| 321 | 2024.12.20 21:46:27.904555 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 322 | 2024.12.20 21:46:27.904825 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 323 | 2024.12.20 21:46:27.904874 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 324 | 2024.12.20 21:46:27.910478 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} <Debug> oximeter.measurements_i8 (babc3f8a-1776-4969-a2f6-04e2ff32e1d8): Loading data parts | ||
| 325 | 2024.12.20 21:46:27.910759 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} <Debug> oximeter.measurements_i8 (babc3f8a-1776-4969-a2f6-04e2ff32e1d8): There are no data parts | ||
| 326 | 2024.12.20 21:46:27.915255 [ 165543 ] {cda316af-5967-49b3-a24f-3a0527a3d319} <Debug> TCPHandler: Processed in 0.010849579 sec. | ||
| 327 | 2024.12.20 21:46:27.916636 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 328 | 2024.12.20 21:46:27.917166 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 329 | 2024.12.20 21:46:27.924163 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 330 | 2024.12.20 21:46:27.932364 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} <Debug> oximeter.measurements_u8 (cdc95b54-953b-4b2b-b713-b890b5c9453b): Loading data parts | ||
| 331 | 2024.12.20 21:46:27.932626 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} <Debug> oximeter.measurements_u8 (cdc95b54-953b-4b2b-b713-b890b5c9453b): There are no data parts | ||
| 332 | 2024.12.20 21:46:27.937166 [ 165544 ] {1166afd1-b1c0-477c-bd10-287c0cd33326} <Debug> TCPHandler: Processed in 0.020695137 sec. | ||
| 333 | 2024.12.20 21:46:27.938094 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 334 | 2024.12.20 21:46:27.938365 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 335 | 2024.12.20 21:46:27.938419 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 336 | 2024.12.20 21:46:27.946034 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} <Debug> oximeter.measurements_i16 (206b2f94-9234-42fe-8787-ae636f80c2d6): Loading data parts | ||
| 337 | 2024.12.20 21:46:27.946878 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} <Debug> oximeter.measurements_i16 (206b2f94-9234-42fe-8787-ae636f80c2d6): There are no data parts | ||
| 338 | 2024.12.20 21:46:27.952970 [ 165543 ] {b92ab696-89e4-4a54-addb-0c4a409ce6c9} <Debug> TCPHandler: Processed in 0.015037672 sec. | ||
| 339 | 2024.12.20 21:46:27.954434 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 340 | 2024.12.20 21:46:27.956625 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 341 | 2024.12.20 21:46:27.956693 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 342 | 2024.12.20 21:46:27.966552 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} <Debug> oximeter.measurements_u16 (31b82669-8ca0-498a-89e3-79044944e444): Loading data parts | ||
| 343 | 2024.12.20 21:46:27.966908 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} <Debug> oximeter.measurements_u16 (31b82669-8ca0-498a-89e3-79044944e444): There are no data parts | ||
| 344 | 2024.12.20 21:46:27.972719 [ 165544 ] {a5e5be83-b0ed-4477-8f4c-dde0f27fbbd7} <Debug> TCPHandler: Processed in 0.018449204 sec. | ||
| 345 | 2024.12.20 21:46:27.978620 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 346 | 2024.12.20 21:46:27.979493 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 347 | 2024.12.20 21:46:27.979549 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 348 | 2024.12.20 21:46:27.985622 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} <Debug> oximeter.measurements_i32 (672895fe-1596-4bc7-ae25-345301138cbf): Loading data parts | ||
| 349 | 2024.12.20 21:46:27.985997 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} <Debug> oximeter.measurements_i32 (672895fe-1596-4bc7-ae25-345301138cbf): There are no data parts | ||
| 350 | 2024.12.20 21:46:27.995013 [ 165543 ] {ee4752b8-8435-464f-a2f5-201bf471a0b4} <Debug> TCPHandler: Processed in 0.016594853 sec. | ||
| 351 | 2024.12.20 21:46:28.007337 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 352 | 2024.12.20 21:46:28.007654 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 353 | 2024.12.20 21:46:28.009486 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 354 | 2024.12.20 21:46:28.015845 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} <Debug> oximeter.measurements_u32 (ea6e7868-fd7e-40e2-8db5-73523747ee19): Loading data parts | ||
| 355 | 2024.12.20 21:46:28.016101 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} <Debug> oximeter.measurements_u32 (ea6e7868-fd7e-40e2-8db5-73523747ee19): There are no data parts | ||
| 356 | 2024.12.20 21:46:28.020364 [ 165544 ] {10066ad3-2b2c-476f-a469-e8f4c84186b5} <Debug> TCPHandler: Processed in 0.013203881 sec. | ||
| 357 | 2024.12.20 21:46:28.055567 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 358 | 2024.12.20 21:46:28.055837 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 359 | 2024.12.20 21:46:28.055889 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 360 | 2024.12.20 21:46:28.062154 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} <Debug> oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Loading data parts | ||
| 361 | 2024.12.20 21:46:28.062465 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} <Debug> oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): There are no data parts | ||
| 362 | 2024.12.20 21:46:28.069414 [ 165543 ] {40cd4013-e231-4212-b866-4b6b7b55b82f} <Debug> TCPHandler: Processed in 0.013933021 sec. | ||
| 363 | 2024.12.20 21:46:28.072037 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 364 | 2024.12.20 21:46:28.073114 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 365 | 2024.12.20 21:46:28.073182 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 366 | 2024.12.20 21:46:28.077638 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} <Debug> oximeter.measurements_u64 (9c767a36-becb-4dab-824e-caf19706013d): Loading data parts | ||
| 367 | 2024.12.20 21:46:28.077965 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} <Debug> oximeter.measurements_u64 (9c767a36-becb-4dab-824e-caf19706013d): There are no data parts | ||
| 368 | 2024.12.20 21:46:28.082118 [ 165544 ] {502eaf55-ed92-4ea0-a252-36be0597a71c} <Debug> TCPHandler: Processed in 0.010307718 sec. | ||
| 369 | 2024.12.20 21:46:28.084070 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 370 | 2024.12.20 21:46:28.085166 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 371 | 2024.12.20 21:46:28.085223 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 372 | 2024.12.20 21:46:28.090741 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} <Debug> oximeter.measurements_f32 (b2f9f887-b80f-4732-96ce-bdef1dacf269): Loading data parts | ||
| 373 | 2024.12.20 21:46:28.091687 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} <Debug> oximeter.measurements_f32 (b2f9f887-b80f-4732-96ce-bdef1dacf269): There are no data parts | ||
| 374 | 2024.12.20 21:46:28.099225 [ 165543 ] {1d2c120e-4ce7-4edd-9a67-b850e0f08ef0} <Debug> TCPHandler: Processed in 0.015335262 sec. | ||
| 375 | 2024.12.20 21:46:28.102431 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 376 | 2024.12.20 21:46:28.102781 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 377 | 2024.12.20 21:46:28.102836 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 378 | 2024.12.20 21:46:28.107728 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} <Debug> oximeter.measurements_f64 (1e5ae190-2f60-479e-93e4-88710e3991ec): Loading data parts | ||
| 379 | 2024.12.20 21:46:28.107985 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} <Debug> oximeter.measurements_f64 (1e5ae190-2f60-479e-93e4-88710e3991ec): There are no data parts | ||
| 380 | 2024.12.20 21:46:28.112183 [ 165544 ] {4c135646-fc6f-4e5c-8843-7314e43c558e} <Debug> TCPHandler: Processed in 0.009923117 sec. | ||
| 381 | 2024.12.20 21:46:28.113213 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 382 | 2024.12.20 21:46:28.113529 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 383 | 2024.12.20 21:46:28.115238 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 384 | 2024.12.20 21:46:28.120683 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} <Debug> oximeter.measurements_string (786ae8f7-ed5d-4f4a-bd9f-ed1e8f6dc21b): Loading data parts | ||
| 385 | 2024.12.20 21:46:28.121287 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} <Debug> oximeter.measurements_string (786ae8f7-ed5d-4f4a-bd9f-ed1e8f6dc21b): There are no data parts | ||
| 386 | 2024.12.20 21:46:28.128555 [ 165543 ] {d36d85bb-21df-453a-8e35-82a53aef923e} <Debug> TCPHandler: Processed in 0.015496753 sec. | ||
| 387 | 2024.12.20 21:46:28.133173 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 388 | 2024.12.20 21:46:28.133478 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} <Debug> executeQuery: (from [::1]:37732) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 389 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 390 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 391 | * a string isn't palatable for a few reasons. | ||
| 392 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 393 | * details. | ||
| 394 | */ | ||
| 395 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 396 | 2024.12.20 21:46:28.133538 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 397 | 2024.12.20 21:46:28.139148 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} <Debug> oximeter.measurements_bytes (c0f62f9c-cf82-4647-b9db-ac4793563c3b): Loading data parts | ||
| 398 | 2024.12.20 21:46:28.139520 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} <Debug> oximeter.measurements_bytes (c0f62f9c-cf82-4647-b9db-ac4793563c3b): There are no data parts | ||
| 399 | 2024.12.20 21:46:28.143300 [ 165544 ] {6211f612-1595-4313-9267-7539253ce803} <Debug> TCPHandler: Processed in 0.010292548 sec. | ||
| 400 | 2024.12.20 21:46:28.144306 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 401 | 2024.12.20 21:46:28.144579 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 402 | 2024.12.20 21:46:28.144632 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 403 | 2024.12.20 21:46:28.150543 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} <Debug> oximeter.measurements_cumulativei64 (13336fed-f2c3-4c13-8595-2d75ed852ea9): Loading data parts | ||
| 404 | 2024.12.20 21:46:28.150788 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} <Debug> oximeter.measurements_cumulativei64 (13336fed-f2c3-4c13-8595-2d75ed852ea9): There are no data parts | ||
| 405 | 2024.12.20 21:46:28.155356 [ 165543 ] {f36486b0-28ec-4444-9f21-453b8928b4a1} <Debug> TCPHandler: Processed in 0.011229409 sec. | ||
| 406 | 2024.12.20 21:46:28.158775 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 407 | 2024.12.20 21:46:28.159063 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 408 | 2024.12.20 21:46:28.159125 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 409 | 2024.12.20 21:46:28.164534 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} <Debug> oximeter.measurements_cumulativeu64 (31027c17-1895-4c12-9b1f-1ba227214b8f): Loading data parts | ||
| 410 | 2024.12.20 21:46:28.166710 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} <Debug> oximeter.measurements_cumulativeu64 (31027c17-1895-4c12-9b1f-1ba227214b8f): There are no data parts | ||
| 411 | 2024.12.20 21:46:28.174445 [ 165544 ] {9cf3d63a-85ae-4c46-bb0b-70aad1b276aa} <Debug> TCPHandler: Processed in 0.015839193 sec. | ||
| 412 | 2024.12.20 21:46:28.175204 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 413 | 2024.12.20 21:46:28.181416 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 414 | 2024.12.20 21:46:28.181484 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 415 | 2024.12.20 21:46:28.188005 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} <Debug> oximeter.measurements_cumulativef32 (2b26719b-6077-4394-ab9a-5b84448ded2e): Loading data parts | ||
| 416 | 2024.12.20 21:46:28.188327 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} <Debug> oximeter.measurements_cumulativef32 (2b26719b-6077-4394-ab9a-5b84448ded2e): There are no data parts | ||
| 417 | 2024.12.20 21:46:28.192446 [ 165543 ] {5c167d8c-0810-48df-8549-7890f8362467} <Debug> TCPHandler: Processed in 0.017350224 sec. | ||
| 418 | 2024.12.20 21:46:28.193365 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 419 | 2024.12.20 21:46:28.193628 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 420 | 2024.12.20 21:46:28.193680 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 421 | 2024.12.20 21:46:28.200018 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} <Debug> oximeter.measurements_cumulativef64 (4eec1da7-33ba-433c-ab7c-3ede9b01fa0e): Loading data parts | ||
| 422 | 2024.12.20 21:46:28.201558 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} <Debug> oximeter.measurements_cumulativef64 (4eec1da7-33ba-433c-ab7c-3ede9b01fa0e): There are no data parts | ||
| 423 | 2024.12.20 21:46:28.205215 [ 165544 ] {25622358-2c2e-4593-a45f-b91ee5cc4be7} <Debug> TCPHandler: Processed in 0.012029559 sec. | ||
| 424 | 2024.12.20 21:46:28.205953 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 425 | 2024.12.20 21:46:28.206536 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} <Debug> executeQuery: (from [::1]:37730) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 426 | * NOTE: Array types cannot be Nullable, see | ||
| 427 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 428 | * for more details. | ||
| 429 | * | ||
| 430 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 431 | * is unfortunate, and at this point relies on the fact that an | ||
| 432 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 433 | * to figure out another way to represent missing samples here. | ||
| 434 | */ | ||
| 435 | 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) | ||
| 436 | 2024.12.20 21:46:28.206611 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 437 | 2024.12.20 21:46:28.215002 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} <Debug> oximeter.measurements_histogrami8 (28f4a2f0-87dc-4ea3-92e3-b3bd9d037735): Loading data parts | ||
| 438 | 2024.12.20 21:46:28.215315 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} <Debug> oximeter.measurements_histogrami8 (28f4a2f0-87dc-4ea3-92e3-b3bd9d037735): There are no data parts | ||
| 439 | 2024.12.20 21:46:28.219552 [ 165543 ] {e994dcbb-9224-4caa-9e28-19dae863bb1d} <Debug> TCPHandler: Processed in 0.013753351 sec. | ||
| 440 | 2024.12.20 21:46:28.220921 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 441 | 2024.12.20 21:46:28.221186 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 442 | 2024.12.20 21:46:28.221246 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 443 | 2024.12.20 21:46:28.226374 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} <Debug> oximeter.measurements_histogramu8 (bbc706d7-f2ee-4e35-a942-17ad60c21289): Loading data parts | ||
| 444 | 2024.12.20 21:46:28.226651 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} <Debug> oximeter.measurements_histogramu8 (bbc706d7-f2ee-4e35-a942-17ad60c21289): There are no data parts | ||
| 445 | 2024.12.20 21:46:28.231026 [ 165544 ] {01bd0b60-51f5-43e2-883d-1db7c705c91c} <Debug> TCPHandler: Processed in 0.010173348 sec. | ||
| 446 | 2024.12.20 21:46:28.231707 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 447 | 2024.12.20 21:46:28.231979 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 448 | 2024.12.20 21:46:28.232046 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 449 | 2024.12.20 21:46:28.239938 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} <Debug> oximeter.measurements_histogrami16 (bd11fa3e-ca31-4fe6-b13e-dd979b0d4897): Loading data parts | ||
| 450 | 2024.12.20 21:46:28.242661 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} <Debug> oximeter.measurements_histogrami16 (bd11fa3e-ca31-4fe6-b13e-dd979b0d4897): There are no data parts | ||
| 451 | 2024.12.20 21:46:28.248101 [ 165543 ] {ec96e3f7-cda5-4953-8308-9984d0ba3a3f} <Debug> TCPHandler: Processed in 0.016481573 sec. | ||
| 452 | 2024.12.20 21:46:28.248869 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 453 | 2024.12.20 21:46:28.249251 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 454 | 2024.12.20 21:46:28.249318 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 455 | 2024.12.20 21:46:28.258812 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} <Debug> oximeter.measurements_histogramu16 (4716f374-3bdb-41c6-9fc1-7ef74e3bef75): Loading data parts | ||
| 456 | 2024.12.20 21:46:28.260460 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} <Debug> oximeter.measurements_histogramu16 (4716f374-3bdb-41c6-9fc1-7ef74e3bef75): There are no data parts | ||
| 457 | 2024.12.20 21:46:28.264118 [ 165544 ] {dd176943-12d3-4416-bdff-357dcc35619a} <Debug> TCPHandler: Processed in 0.015432973 sec. | ||
| 458 | 2024.12.20 21:46:28.264897 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 459 | 2024.12.20 21:46:28.265227 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 460 | 2024.12.20 21:46:28.265284 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 461 | 2024.12.20 21:46:28.275509 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} <Debug> oximeter.measurements_histogrami32 (1d0cc353-e624-4b65-8a55-7e76257a54f6): Loading data parts | ||
| 462 | 2024.12.20 21:46:28.276375 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} <Debug> oximeter.measurements_histogrami32 (1d0cc353-e624-4b65-8a55-7e76257a54f6): There are no data parts | ||
| 463 | 2024.12.20 21:46:28.289758 [ 165543 ] {548ece8b-b3ce-4493-aedc-18531832db59} <Debug> TCPHandler: Processed in 0.0249338 sec. | ||
| 464 | 2024.12.20 21:46:28.290653 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 465 | 2024.12.20 21:46:28.291026 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 466 | 2024.12.20 21:46:28.291090 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 467 | 2024.12.20 21:46:28.302353 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} <Debug> oximeter.measurements_histogramu32 (3fd8d6bc-d17b-4a75-a35b-d10f6351ead9): Loading data parts | ||
| 468 | 2024.12.20 21:46:28.302886 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} <Debug> oximeter.measurements_histogramu32 (3fd8d6bc-d17b-4a75-a35b-d10f6351ead9): There are no data parts | ||
| 469 | 2024.12.20 21:46:28.306733 [ 165544 ] {e1e30f92-2883-4598-9f46-0fea8e803495} <Debug> TCPHandler: Processed in 0.016171333 sec. | ||
| 470 | 2024.12.20 21:46:28.307573 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 471 | 2024.12.20 21:46:28.307922 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 472 | 2024.12.20 21:46:28.309752 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 473 | 2024.12.20 21:46:28.314717 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} <Debug> oximeter.measurements_histogrami64 (f1fafa90-3aa0-476a-8a78-81d7dee7f8f7): Loading data parts | ||
| 474 | 2024.12.20 21:46:28.315007 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} <Debug> oximeter.measurements_histogrami64 (f1fafa90-3aa0-476a-8a78-81d7dee7f8f7): There are no data parts | ||
| 475 | 2024.12.20 21:46:28.318858 [ 165543 ] {d3e100d5-e51d-4d25-b338-b0c9591ea42e} <Debug> TCPHandler: Processed in 0.011446669 sec. | ||
| 476 | 2024.12.20 21:46:28.319855 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 477 | 2024.12.20 21:46:28.320180 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 478 | 2024.12.20 21:46:28.320242 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 479 | 2024.12.20 21:46:28.325923 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} <Debug> oximeter.measurements_histogramu64 (85f2f4ad-30bd-4b42-ad8c-960c4d5607c1): Loading data parts | ||
| 480 | 2024.12.20 21:46:28.326235 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} <Debug> oximeter.measurements_histogramu64 (85f2f4ad-30bd-4b42-ad8c-960c4d5607c1): There are no data parts | ||
| 481 | 2024.12.20 21:46:28.330604 [ 165544 ] {fbc29843-a4dd-46fe-984e-210835927ae0} <Debug> TCPHandler: Processed in 0.010932579 sec. | ||
| 482 | 2024.12.20 21:46:28.331414 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 483 | 2024.12.20 21:46:28.333487 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 484 | 2024.12.20 21:46:28.333559 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 485 | 2024.12.20 21:46:28.339885 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} <Debug> oximeter.measurements_histogramf32 (63720de0-422c-423f-8f47-943ab5043f7b): Loading data parts | ||
| 486 | 2024.12.20 21:46:28.340144 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} <Debug> oximeter.measurements_histogramf32 (63720de0-422c-423f-8f47-943ab5043f7b): There are no data parts | ||
| 487 | 2024.12.20 21:46:28.344468 [ 165543 ] {8c23c9aa-2804-463c-a17f-9418525660c0} <Debug> TCPHandler: Processed in 0.01326673 sec. | ||
| 488 | 2024.12.20 21:46:28.345171 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 489 | 2024.12.20 21:46:28.345419 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 490 | 2024.12.20 21:46:28.345483 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 491 | 2024.12.20 21:46:28.350266 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} <Debug> oximeter.measurements_histogramf64 (dfb04165-cfd9-4621-acb4-1e1db6b770b7): Loading data parts | ||
| 492 | 2024.12.20 21:46:28.350538 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} <Debug> oximeter.measurements_histogramf64 (dfb04165-cfd9-4621-acb4-1e1db6b770b7): There are no data parts | ||
| 493 | 2024.12.20 21:46:28.356781 [ 165544 ] {62e9a86b-e7b8-48d6-acd8-b7c9e24d4702} <Debug> TCPHandler: Processed in 0.011731079 sec. | ||
| 494 | 2024.12.20 21:46:28.357650 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 495 | 2024.12.20 21:46:28.357930 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} <Debug> executeQuery: (from [::1]:37730) /* The field tables store named dimensions of each timeseries. | ||
| 496 | * | ||
| 497 | * As with the measurement tables, there is one field table for each field data | ||
| 498 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 499 | * this behavior **must not** be relied upon for query correctness. | ||
| 500 | * | ||
| 501 | * The index for the fields differs from the measurements, however. Rows are | ||
| 502 | * sorted by timeseries name, then field name, field value, and finally | ||
| 503 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 504 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 505 | * usually then used to look up measurements. | ||
| 506 | * | ||
| 507 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 508 | * timeseries name and then key, since it would improve lookups where one | ||
| 509 | * already has the key. Realistically though, these tables are quite small and | ||
| 510 | * so performance benefits will be low in absolute terms. | ||
| 511 | * | ||
| 512 | * TTL: We use a materialized column to expire old field table records. This | ||
| 513 | * column is generated automatically by the database whenever a new row is | ||
| 514 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 515 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 516 | * record will remain during a deduplication, which will have the last | ||
| 517 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 518 | * measurement tables. | ||
| 519 | */ | ||
| 520 | 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) | ||
| 521 | 2024.12.20 21:46:28.357989 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 522 | 2024.12.20 21:46:28.362867 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} <Debug> oximeter.fields_bool (7dc74bd0-ccfb-44e3-82a8-5e58b602ad1b): Loading data parts | ||
| 523 | 2024.12.20 21:46:28.370816 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} <Debug> oximeter.fields_bool (7dc74bd0-ccfb-44e3-82a8-5e58b602ad1b): There are no data parts | ||
| 524 | 2024.12.20 21:46:28.377214 [ 165543 ] {e42d3045-408f-40c6-9582-c4c568db1aee} <Debug> TCPHandler: Processed in 0.019729696 sec. | ||
| 525 | 2024.12.20 21:46:28.378024 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 526 | 2024.12.20 21:46:28.380029 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 527 | 2024.12.20 21:46:28.380088 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 528 | 2024.12.20 21:46:28.385724 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} <Debug> oximeter.fields_i8 (9309d7da-65d1-4d11-83fe-ddd785b1e3a9): Loading data parts | ||
| 529 | 2024.12.20 21:46:28.387727 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} <Debug> oximeter.fields_i8 (9309d7da-65d1-4d11-83fe-ddd785b1e3a9): There are no data parts | ||
| 530 | 2024.12.20 21:46:28.393320 [ 165544 ] {ca4bb4cf-ad55-4c26-b4d3-ad3b96fbaf2a} <Debug> TCPHandler: Processed in 0.015493683 sec. | ||
| 531 | 2024.12.20 21:46:28.394195 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 532 | 2024.12.20 21:46:28.394442 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 533 | 2024.12.20 21:46:28.394513 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 534 | 2024.12.20 21:46:28.405555 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} <Debug> oximeter.fields_u8 (c5e1ef3c-823b-40a9-be41-a5d6968a53f7): Loading data parts | ||
| 535 | 2024.12.20 21:46:28.406258 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} <Debug> oximeter.fields_u8 (c5e1ef3c-823b-40a9-be41-a5d6968a53f7): There are no data parts | ||
| 536 | 2024.12.20 21:46:28.410118 [ 165543 ] {a3a97d66-ce8e-48c1-99a6-f90f8fcd35e2} <Debug> TCPHandler: Processed in 0.016085073 sec. | ||
| 537 | 2024.12.20 21:46:28.410783 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 538 | 2024.12.20 21:46:28.411097 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 539 | 2024.12.20 21:46:28.411150 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 540 | 2024.12.20 21:46:28.417573 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} <Debug> oximeter.fields_i16 (8407da7b-71ce-448e-958c-0a59591332d9): Loading data parts | ||
| 541 | 2024.12.20 21:46:28.417970 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} <Debug> oximeter.fields_i16 (8407da7b-71ce-448e-958c-0a59591332d9): There are no data parts | ||
| 542 | 2024.12.20 21:46:28.424782 [ 165544 ] {92d1d5d8-b5cf-480a-b3cf-52ee46e7bf50} <Debug> TCPHandler: Processed in 0.014077941 sec. | ||
| 543 | 2024.12.20 21:46:28.425699 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 544 | 2024.12.20 21:46:28.425962 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 545 | 2024.12.20 21:46:28.426022 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 546 | 2024.12.20 21:46:28.431245 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} <Debug> oximeter.fields_u16 (724f5d3a-2b25-4f4e-80cf-53e639f45f30): Loading data parts | ||
| 547 | 2024.12.20 21:46:28.431539 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} <Debug> oximeter.fields_u16 (724f5d3a-2b25-4f4e-80cf-53e639f45f30): There are no data parts | ||
| 548 | 2024.12.20 21:46:28.436960 [ 165543 ] {330731dd-9ef2-4ebb-b43a-ed470b0be9a2} <Debug> TCPHandler: Processed in 0.011428319 sec. | ||
| 549 | 2024.12.20 21:46:28.437748 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 550 | 2024.12.20 21:46:28.438010 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 551 | 2024.12.20 21:46:28.438063 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 552 | 2024.12.20 21:46:28.445467 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} <Debug> oximeter.fields_i32 (5f89e1f8-2f62-485f-a5fd-d539c094ff6b): Loading data parts | ||
| 553 | 2024.12.20 21:46:28.445717 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} <Debug> oximeter.fields_i32 (5f89e1f8-2f62-485f-a5fd-d539c094ff6b): There are no data parts | ||
| 554 | 2024.12.20 21:46:28.449983 [ 165544 ] {92f9c49e-911a-46a9-ba09-7fbfcd0a7658} <Debug> TCPHandler: Processed in 0.01239978 sec. | ||
| 555 | 2024.12.20 21:46:28.450797 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 556 | 2024.12.20 21:46:28.452232 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 557 | 2024.12.20 21:46:28.452313 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 558 | 2024.12.20 21:46:28.463760 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} <Debug> oximeter.fields_u32 (77824b7b-33c4-4d3a-8caa-e6e5e8ba3b26): Loading data parts | ||
| 559 | 2024.12.20 21:46:28.465270 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} <Debug> oximeter.fields_u32 (77824b7b-33c4-4d3a-8caa-e6e5e8ba3b26): There are no data parts | ||
| 560 | 2024.12.20 21:46:28.470928 [ 165543 ] {b20ce03d-249c-4111-a818-c322ccbd804b} <Debug> TCPHandler: Processed in 0.020296126 sec. | ||
| 561 | 2024.12.20 21:46:28.471756 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 562 | 2024.12.20 21:46:28.472029 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 563 | 2024.12.20 21:46:28.472092 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 564 | 2024.12.20 21:46:28.479541 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} <Debug> oximeter.fields_i64 (6ed979b5-bf55-44c5-ba7a-9905ac8eb4df): Loading data parts | ||
| 565 | 2024.12.20 21:46:28.479809 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} <Debug> oximeter.fields_i64 (6ed979b5-bf55-44c5-ba7a-9905ac8eb4df): There are no data parts | ||
| 566 | 2024.12.20 21:46:28.484226 [ 165544 ] {0e9ecd82-2a9f-4f2e-b910-d0553e02c609} <Debug> TCPHandler: Processed in 0.01264126 sec. | ||
| 567 | 2024.12.20 21:46:28.485049 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 568 | 2024.12.20 21:46:28.485316 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 569 | 2024.12.20 21:46:28.485370 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 570 | 2024.12.20 21:46:28.491720 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} <Debug> oximeter.fields_u64 (6a552b17-2538-4c57-aa46-ac8e8fbabaef): Loading data parts | ||
| 571 | 2024.12.20 21:46:28.492023 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} <Debug> oximeter.fields_u64 (6a552b17-2538-4c57-aa46-ac8e8fbabaef): There are no data parts | ||
| 572 | 2024.12.20 21:46:28.495725 [ 165543 ] {236b9f36-906a-4716-88b3-0cc8463db7c2} <Debug> TCPHandler: Processed in 0.010836619 sec. | ||
| 573 | 2024.12.20 21:46:28.496900 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 574 | 2024.12.20 21:46:28.497208 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 575 | 2024.12.20 21:46:28.497263 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 576 | 2024.12.20 21:46:28.505386 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} <Debug> oximeter.fields_ipaddr (5bbcb034-4ace-4430-b831-4f771785418e): Loading data parts | ||
| 577 | 2024.12.20 21:46:28.507526 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} <Debug> oximeter.fields_ipaddr (5bbcb034-4ace-4430-b831-4f771785418e): There are no data parts | ||
| 578 | 2024.12.20 21:46:28.516179 [ 165544 ] {36b65389-9f62-4735-8cb9-87b4ce946853} <Debug> TCPHandler: Processed in 0.019450995 sec. | ||
| 579 | 2024.12.20 21:46:28.517499 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 580 | 2024.12.20 21:46:28.519741 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} <Debug> executeQuery: (from [::1]:37730) 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) | ||
| 581 | 2024.12.20 21:46:28.519806 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 582 | 2024.12.20 21:46:28.524879 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} <Debug> oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Loading data parts | ||
| 583 | 2024.12.20 21:46:28.525118 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} <Debug> oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): There are no data parts | ||
| 584 | 2024.12.20 21:46:28.529731 [ 165543 ] {cae00032-ccae-487f-b987-b7273a317a02} <Debug> TCPHandler: Processed in 0.012405579 sec. | ||
| 585 | 2024.12.20 21:46:28.530497 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 586 | 2024.12.20 21:46:28.531736 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} <Debug> executeQuery: (from [::1]:37732) 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) | ||
| 587 | 2024.12.20 21:46:28.531793 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 588 | 2024.12.20 21:46:28.539595 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} <Debug> oximeter.fields_uuid (b439313f-731a-42b5-a120-f2d5bf712e62): Loading data parts | ||
| 589 | 2024.12.20 21:46:28.539884 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} <Debug> oximeter.fields_uuid (b439313f-731a-42b5-a120-f2d5bf712e62): There are no data parts | ||
| 590 | 2024.12.20 21:46:28.547640 [ 165544 ] {edb09137-9f41-448f-ad71-6004f0092783} <Debug> TCPHandler: Processed in 0.017291484 sec. | ||
| 591 | 2024.12.20 21:46:28.548539 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 592 | 2024.12.20 21:46:28.549820 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} <Debug> executeQuery: (from [::1]:37730) /* The timeseries schema table stores the extracted schema for the samples | ||
| 593 | * oximeter collects. | ||
| 594 | */ | ||
| 595 | 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) | ||
| 596 | 2024.12.20 21:46:28.549893 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 597 | 2024.12.20 21:46:28.555718 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} <Debug> oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305): Loading data parts | ||
| 598 | 2024.12.20 21:46:28.555971 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} <Debug> oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305): There are no data parts | ||
| 599 | 2024.12.20 21:46:28.560888 [ 165543 ] {9cf74117-8d2c-4bd0-be30-5318338779fa} <Debug> TCPHandler: Processed in 0.012518821 sec. | ||
| 600 | 2024.12.20 21:46:28.561662 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 601 | 2024.12.20 21:46:28.561840 [ 165544 ] {33677a07-1512-4782-803e-471949d3edba} <Debug> executeQuery: (from [::1]:37732) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 602 | 2024.12.20 21:46:28.561938 [ 165544 ] {33677a07-1512-4782-803e-471949d3edba} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 603 | 2024.12.20 21:46:28.562763 [ 165498 ] {33677a07-1512-4782-803e-471949d3edba} <Trace> oximeter.version (3644c0ed-2391-49f4-bd3a-2f24dfda9862): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 604 | 2024.12.20 21:46:28.563917 [ 165498 ] {33677a07-1512-4782-803e-471949d3edba} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.12 GiB. | ||
| 605 | 2024.12.20 21:46:28.564233 [ 165498 ] {33677a07-1512-4782-803e-471949d3edba} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 606 | 2024.12.20 21:46:28.564427 [ 165498 ] {33677a07-1512-4782-803e-471949d3edba} <Trace> oximeter.version (3644c0ed-2391-49f4-bd3a-2f24dfda9862): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 607 | 2024.12.20 21:46:28.564613 [ 165544 ] {33677a07-1512-4782-803e-471949d3edba} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.002829 sec., 353.4817956875221 rows/sec., 5.52 KiB/sec. | ||
| 608 | 2024.12.20 21:46:28.564756 [ 165544 ] {33677a07-1512-4782-803e-471949d3edba} <Debug> TCPHandler: Processed in 0.003247273 sec. | ||
| 609 | 2024.12.20 21:46:29.000430 [ 163934 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 399.65 MiB, peak 399.65 MiB, free memory in arenas 28.53 MiB, will set to 393.55 MiB (RSS), difference: -6.09 MiB | ||
| 610 | 2024.12.20 21:46:30.322055 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 611 | 2024.12.20 21:46:30.322250 [ 165543 ] {a9e1a756-cef9-499d-9746-305be312b9f7} <Debug> executeQuery: (from [::1]:37730) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 612 | 2024.12.20 21:46:30.323587 [ 165543 ] {a9e1a756-cef9-499d-9746-305be312b9f7} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 613 | 2024.12.20 21:46:30.323649 [ 165543 ] {a9e1a756-cef9-499d-9746-305be312b9f7} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 614 | 2024.12.20 21:46:30.324189 [ 165543 ] {a9e1a756-cef9-499d-9746-305be312b9f7} <Debug> TCPHandler: Processed in 0.002311793 sec. | ||
| 615 | 2024.12.20 21:46:30.345511 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 616 | 2024.12.20 21:46:30.345706 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} <Debug> executeQuery: (from [::1]:37732) INSERT INTO oximeter.timeseries_schema FORMAT Native (stage: Complete) | ||
| 617 | 2024.12.20 21:46:30.345772 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 618 | 2024.12.20 21:46:30.347618 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} <Trace> oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 619 | 2024.12.20 21:46:30.347880 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. | ||
| 620 | 2024.12.20 21:46:30.348381 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 621 | 2024.12.20 21:46:30.348562 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} <Trace> oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 622 | 2024.12.20 21:46:30.348782 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.003129 sec., 319.59092361776925 rows/sec., 38.39 KiB/sec. | ||
| 623 | 2024.12.20 21:46:30.348846 [ 165544 ] {a0be179c-9d42-4ffc-9d10-defe5ddb73b6} <Debug> TCPHandler: Processed in 0.003516843 sec. | ||
| 624 | 2024.12.20 21:46:30.353250 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 625 | 2024.12.20 21:46:30.353412 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} <Debug> executeQuery: (from [::1]:37730) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 626 | 2024.12.20 21:46:30.353463 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 627 | 2024.12.20 21:46:30.354555 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} <Trace> oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 628 | 2024.12.20 21:46:30.354581 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. | ||
| 629 | 2024.12.20 21:46:30.354899 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 630 | 2024.12.20 21:46:30.355114 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} <Trace> oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 631 | 2024.12.20 21:46:30.356622 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.003256 sec., 614.2506142506143 rows/sec., 63.58 KiB/sec. | ||
| 632 | 2024.12.20 21:46:30.356663 [ 165543 ] {da97e6c1-f422-4808-beb9-5caf74e016c4} <Debug> TCPHandler: Processed in 0.003543982 sec. | ||
| 633 | 2024.12.20 21:46:30.363334 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 634 | 2024.12.20 21:46:30.363483 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} <Debug> executeQuery: (from [::1]:37732) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 635 | 2024.12.20 21:46:30.364794 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 636 | 2024.12.20 21:46:30.369368 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} <Trace> oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 637 | 2024.12.20 21:46:30.369403 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. | ||
| 638 | 2024.12.20 21:46:30.369819 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 639 | 2024.12.20 21:46:30.369996 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} <Trace> oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 640 | 2024.12.20 21:46:30.370175 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.006734 sec., 148.5001485001485 rows/sec., 10.30 KiB/sec. | ||
| 641 | 2024.12.20 21:46:30.370219 [ 165544 ] {a9383e51-dbdd-4a19-b53d-e242ef4592d1} <Debug> TCPHandler: Processed in 0.006984305 sec. | ||
| 642 | 2024.12.20 21:46:30.376837 [ 165543 ] {} <Trace> TCP-Session: 7bbc1353-4f3c-4998-b057-165898cce922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 643 | 2024.12.20 21:46:30.377001 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} <Debug> executeQuery: (from [::1]:37730) INSERT INTO oximeter.fields_string FORMAT Native (stage: Complete) | ||
| 644 | 2024.12.20 21:46:30.377058 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
| 645 | 2024.12.20 21:46:30.377874 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} <Trace> oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 646 | 2024.12.20 21:46:30.378823 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. | ||
| 647 | 2024.12.20 21:46:30.379201 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 648 | 2024.12.20 21:46:30.379394 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} <Trace> oximeter.fields_string (0aaa940a-4d70-4fa2-9808-d299ec64df62): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 649 | 2024.12.20 21:46:30.379598 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002648 sec., 755.2870090634441 rows/sec., 78.18 KiB/sec. | ||
| 650 | 2024.12.20 21:46:30.379662 [ 165543 ] {271e88e2-be8f-479e-86c5-fc63b68d3ca6} <Debug> TCPHandler: Processed in 0.002984102 sec. | ||
| 651 | 2024.12.20 21:46:30.380679 [ 165544 ] {} <Trace> TCP-Session: b8862bb0-6125-4ac9-9385-faff189222d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 652 | 2024.12.20 21:46:30.380809 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} <Debug> executeQuery: (from [::1]:37732) INSERT INTO oximeter.measurements_i64 FORMAT Native (stage: Complete) | ||
| 653 | 2024.12.20 21:46:30.382272 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
| 654 | 2024.12.20 21:46:30.383522 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} <Trace> oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 655 | 2024.12.20 21:46:30.383547 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.25 GiB. | ||
| 656 | 2024.12.20 21:46:30.383888 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
| 657 | 2024.12.20 21:46:30.384070 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} <Trace> oximeter.measurements_i64 (d1aadadf-ce89-42ac-ac2d-f6152d860744): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 658 | 2024.12.20 21:46:30.384243 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.003468 sec., 288.3506343713956 rows/sec., 19.99 KiB/sec. | ||
| 659 | 2024.12.20 21:46:30.384279 [ 165544 ] {07b9d131-b495-4c5a-bc89-52453d0af91b} <Debug> TCPHandler: Processed in 0.003691323 sec. | ||
| 660 | 2024.12.20 21:46:30.517813 [ 163685 ] {} <Trace> TCP-Session: c01cd7dc-be2c-4497-8425-84fc3d9b40d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 661 | 2024.12.20 21:46:30.518019 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Debug> executeQuery: (from [::1]:37710) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 662 | 2024.12.20 21:46:30.518294 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 663 | 2024.12.20 21:46:30.518363 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 664 | 2024.12.20 21:46:30.519133 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Debug> oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305) (SelectExecutor): Key condition: unknown | ||
| 665 | 2024.12.20 21:46:30.519175 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Debug> oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305) (SelectExecutor): Selected 1/1 parts by partition key, 1 parts by primary key, 1/1 marks by primary key, 1 marks to read from 1 ranges | ||
| 666 | 2024.12.20 21:46:30.519186 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Trace> oximeter.timeseries_schema (9eb48f1e-c1e7-4c2b-81b0-83ed68992305) (SelectExecutor): Spreading mark ranges among streams (default reading) | ||
| 667 | 2024.12.20 21:46:30.519221 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Trace> MergeTreeInOrderSelectProcessor: Reading 1 ranges in order from part all_1_1_0, approx. 1 rows starting from 0 | ||
| 668 | 2024.12.20 21:46:30.520234 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.002264 sec., 441.69611307420496 rows/sec., 53.06 KiB/sec. | ||
| 669 | 2024.12.20 21:46:30.520306 [ 163685 ] {da6bce5e-fc53-46dd-811d-a4ba56757e55} <Debug> TCPHandler: Processed in 0.002624412 sec. | ||