| 1 | 2025.02.11 20:10:17.051642 [ 47145 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2025.02.11 20:10:17.051715 [ 47145 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2025.02.11 20:10:17.104368 [ 47145 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 47145 | ||
| 4 | 2025.02.11 20:10:17.104428 [ 47145 ] {} <Information> Application: starting up | ||
| 5 | 2025.02.11 20:10:17.104444 [ 47145 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2025.02.11 20:10:17.107309 [ 47145 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2025.02.11 20:10:17.128591 [ 47145 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2025.02.11 20:10:17.128659 [ 47145 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2025.02.11 20:10:17.128744 [ 47145 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2025.02.11 20:10:17.128765 [ 47145 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2025.02.11 20:10:17.375651 [ 47145 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2025.02.11 20:10:17.375702 [ 47145 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 13 | 2025.02.11 20:10:17.380836 [ 47145 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2025.02.11 20:10:17.382321 [ 47145 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2025.02.11 20:10:17.382336 [ 47145 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2025.02.11 20:10:17.382342 [ 47145 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2025.02.11 20:10:17.382370 [ 47145 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/datastore/tmp/ to store temporary data in it | ||
| 18 | 2025.02.11 20:10:17.382804 [ 47145 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2025.02.11 20:10:17.386834 [ 47145 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/config.xml' | ||
| 20 | 2025.02.11 20:10:17.387407 [ 47145 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/config.xml', performing update on configuration | ||
| 21 | 2025.02.11 20:10:17.388609 [ 47145 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 22 | 2025.02.11 20:10:17.388624 [ 47145 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 23 | 2025.02.11 20:10:17.388630 [ 47145 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2025.02.11 20:10:17.388672 [ 47145 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2025.02.11 20:10:17.389277 [ 47145 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2025.02.11 20:10:17.404665 [ 47145 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2025.02.11 20:10:17.408671 [ 47145 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2025.02.11 20:10:17.411983 [ 47145 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2025.02.11 20:10:17.412011 [ 47145 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/config.xml', performed update on configuration | ||
| 30 | 2025.02.11 20:10:17.414360 [ 47145 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/config.xml' | ||
| 31 | 2025.02.11 20:10:17.415343 [ 47145 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/config.xml', performing update on configuration | ||
| 32 | 2025.02.11 20:10:17.422294 [ 47145 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/config.xml', performed update on configuration | ||
| 33 | 2025.02.11 20:10:17.422645 [ 47145 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/config.xml | ||
| 34 | 2025.02.11 20:10:17.432953 [ 47145 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2025.02.11 20:10:17.433381 [ 47145 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2025.02.11 20:10:17.434404 [ 47145 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2025.02.11 20:10:17.434664 [ 47145 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2025.02.11 20:10:17.436890 [ 47145 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2025.02.11 20:10:17.436942 [ 47145 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/datastore/ | ||
| 40 | 2025.02.11 20:10:17.446306 [ 47161 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 41 | 2025.02.11 20:10:17.446348 [ 47161 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 42 | 2025.02.11 20:10:17.454429 [ 47145 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2025.02.11 20:10:17.454457 [ 47145 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.742e-05 sec | ||
| 44 | 2025.02.11 20:10:17.454464 [ 47145 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2025.02.11 20:10:17.454479 [ 47145 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2025.02.11 20:10:17.454506 [ 47145 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2025.02.11 20:10:17.454520 [ 47145 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2025.02.11 20:10:17.464980 [ 47145 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2025.02.11 20:10:17.465008 [ 47145 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2025.02.11 20:10:17.465016 [ 47145 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2025.02.11 20:10:17.465022 [ 47145 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2025.02.11 20:10:17.465028 [ 47145 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2025.02.11 20:10:17.465036 [ 47145 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 54 | 2025.02.11 20:10:17.468651 [ 47145 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2025.02.11 20:10:17.468676 [ 47145 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2025.02.11 20:10:17.468686 [ 47145 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 57 | 2025.02.11 20:10:17.468843 [ 47145 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2025.02.11 20:10:17.468855 [ 47145 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2025.02.11 20:10:17.468862 [ 47145 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2025.02.11 20:10:17.468869 [ 47145 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2025.02.11 20:10:17.468876 [ 47145 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2025.02.11 20:10:17.468883 [ 47145 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2025.02.11 20:10:17.468889 [ 47145 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2025.02.11 20:10:17.490258 [ 47145 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2025.02.11 20:10:17.495949 [ 47145 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2025.02.11 20:10:17.495984 [ 47145 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.864e-05 sec | ||
| 67 | 2025.02.11 20:10:17.495993 [ 47145 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2025.02.11 20:10:17.495998 [ 47145 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2025.02.11 20:10:17.496053 [ 47145 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2025.02.11 20:10:17.496182 [ 47145 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/omicron_nexus-dc2824d5190bf2d6-test_driver_basic.47114.1-clickhouse-UmQ9qj/datastore/user_defined/ | ||
| 71 | 2025.02.11 20:10:17.496221 [ 47145 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2025.02.11 20:10:17.496229 [ 47145 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2025.02.11 20:10:17.496251 [ 47145 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2025.02.11 20:10:17.496256 [ 47145 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 75 | 2025.02.11 20:10:17.496330 [ 47145 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 36403 | ||
| 76 | 2025.02.11 20:10:17.496401 [ 47145 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40225 | ||
| 77 | 2025.02.11 20:10:17.496550 [ 47145 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34273 | ||
| 78 | 2025.02.11 20:10:17.496588 [ 47145 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41739 | ||
| 79 | 2025.02.11 20:10:17.496606 [ 47145 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2025.02.11 20:10:17.496965 [ 47145 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.62 MiB, peak 20.62 MiB, free memory in arenas 8.65 MiB, will set to 386.24 MiB (RSS), difference: 365.62 MiB | ||
| 81 | 2025.02.11 20:10:17.498032 [ 47145 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.829e-05 sec. | ||
| 82 | 2025.02.11 20:10:17.499464 [ 47145 ] {} <Information> Application: Listening for http://[::1]:36403 | ||
| 83 | 2025.02.11 20:10:17.499508 [ 47145 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:40225 | ||
| 84 | 2025.02.11 20:10:17.499552 [ 47145 ] {} <Information> Application: Listening for http://127.0.0.1:34273 | ||
| 85 | 2025.02.11 20:10:17.499588 [ 47145 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:41739 | ||
| 86 | 2025.02.11 20:10:17.499596 [ 47145 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2025.02.11 20:10:18.175548 [ 47147 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35514 | ||
| 88 | 2025.02.11 20:10:18.182493 [ 47147 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2025.02.11 20:10:18.182881 [ 47147 ] {} <Debug> TCP-Session: 99cc691b-9d8c-4c5a-92d8-fb1d45d7cf39 Authenticating user 'default' from [::1]:35514 | ||
| 90 | 2025.02.11 20:10:18.182903 [ 47147 ] {} <Debug> TCP-Session: 99cc691b-9d8c-4c5a-92d8-fb1d45d7cf39 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2025.02.11 20:10:18.182908 [ 47147 ] {} <Debug> TCP-Session: 99cc691b-9d8c-4c5a-92d8-fb1d45d7cf39 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2025.02.11 20:10:18.183010 [ 47147 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2025.02.11 20:10:18.183037 [ 47147 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 94 | 2025.02.11 20:10:18.183046 [ 47147 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 95 | 2025.02.11 20:10:18.184870 [ 47148 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35516 | ||
| 96 | 2025.02.11 20:10:18.185216 [ 47149 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35518 | ||
| 97 | 2025.02.11 20:10:18.185847 [ 47148 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 98 | 2025.02.11 20:10:18.185887 [ 47148 ] {} <Debug> TCP-Session: c8deea80-ec04-4d66-8416-4a8c8c2111f0 Authenticating user 'default' from [::1]:35516 | ||
| 99 | 2025.02.11 20:10:18.185900 [ 47148 ] {} <Debug> TCP-Session: c8deea80-ec04-4d66-8416-4a8c8c2111f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 100 | 2025.02.11 20:10:18.185907 [ 47148 ] {} <Debug> TCP-Session: c8deea80-ec04-4d66-8416-4a8c8c2111f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 101 | 2025.02.11 20:10:18.186047 [ 47149 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 102 | 2025.02.11 20:10:18.186080 [ 47149 ] {} <Debug> TCP-Session: db042f54-bf95-43c4-91f6-684d9def0596 Authenticating user 'default' from [::1]:35518 | ||
| 103 | 2025.02.11 20:10:18.186090 [ 47149 ] {} <Debug> TCP-Session: db042f54-bf95-43c4-91f6-684d9def0596 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 104 | 2025.02.11 20:10:18.186096 [ 47149 ] {} <Debug> TCP-Session: db042f54-bf95-43c4-91f6-684d9def0596 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2025.02.11 20:10:18.202190 [ 47452 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35522 | ||
| 106 | 2025.02.11 20:10:18.202320 [ 47452 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2025.02.11 20:10:18.202356 [ 47452 ] {} <Debug> TCP-Session: 348da6c0-f7b2-4a05-8263-fc821105b1ff Authenticating user 'default' from [::1]:35522 | ||
| 108 | 2025.02.11 20:10:18.202375 [ 47452 ] {} <Debug> TCP-Session: 348da6c0-f7b2-4a05-8263-fc821105b1ff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2025.02.11 20:10:18.202388 [ 47452 ] {} <Debug> TCP-Session: 348da6c0-f7b2-4a05-8263-fc821105b1ff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2025.02.11 20:10:18.222580 [ 47451 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35520 | ||
| 111 | 2025.02.11 20:10:18.222592 [ 47455 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35530 | ||
| 112 | 2025.02.11 20:10:18.222758 [ 47454 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35528 | ||
| 113 | 2025.02.11 20:10:18.223722 [ 47454 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 114 | 2025.02.11 20:10:18.223758 [ 47454 ] {} <Debug> TCP-Session: ed74b605-16d3-4bb1-af31-fcc5df77d369 Authenticating user 'default' from [::1]:35528 | ||
| 115 | 2025.02.11 20:10:18.223776 [ 47454 ] {} <Debug> TCP-Session: ed74b605-16d3-4bb1-af31-fcc5df77d369 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 116 | 2025.02.11 20:10:18.223759 [ 47451 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 117 | 2025.02.11 20:10:18.223821 [ 47451 ] {} <Debug> TCP-Session: 686899a1-f6e7-4070-bf1b-e6e732565217 Authenticating user 'default' from [::1]:35520 | ||
| 118 | 2025.02.11 20:10:18.223836 [ 47451 ] {} <Debug> TCP-Session: 686899a1-f6e7-4070-bf1b-e6e732565217 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 119 | 2025.02.11 20:10:18.223846 [ 47451 ] {} <Debug> TCP-Session: 686899a1-f6e7-4070-bf1b-e6e732565217 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 120 | 2025.02.11 20:10:18.223832 [ 47453 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35526 | ||
| 121 | 2025.02.11 20:10:18.223970 [ 47453 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 122 | 2025.02.11 20:10:18.224002 [ 47453 ] {} <Debug> TCP-Session: 0412ec83-190c-4186-a98a-a156a154febc Authenticating user 'default' from [::1]:35526 | ||
| 123 | 2025.02.11 20:10:18.224012 [ 47453 ] {} <Debug> TCP-Session: 0412ec83-190c-4186-a98a-a156a154febc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 124 | 2025.02.11 20:10:18.224024 [ 47453 ] {} <Debug> TCP-Session: 0412ec83-190c-4186-a98a-a156a154febc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 125 | 2025.02.11 20:10:18.223783 [ 47454 ] {} <Debug> TCP-Session: ed74b605-16d3-4bb1-af31-fcc5df77d369 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 126 | 2025.02.11 20:10:18.227205 [ 47455 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2025.02.11 20:10:18.227604 [ 47455 ] {} <Debug> TCP-Session: 46192a3a-73e8-4bfd-b417-2d5f80198143 Authenticating user 'default' from [::1]:35530 | ||
| 128 | 2025.02.11 20:10:18.227618 [ 47455 ] {} <Debug> TCP-Session: 46192a3a-73e8-4bfd-b417-2d5f80198143 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2025.02.11 20:10:18.227625 [ 47455 ] {} <Debug> TCP-Session: 46192a3a-73e8-4bfd-b417-2d5f80198143 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2025.02.11 20:10:24.996092 [ 47390 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 131 | 2025.02.11 20:10:24.996153 [ 47390 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 132 | 2025.02.11 20:10:24.996268 [ 47393 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1728 entries to flush up to offset 1728 | ||
| 133 | 2025.02.11 20:10:24.996314 [ 47393 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 134 | 2025.02.11 20:10:24.997384 [ 47393 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 135 | 2025.02.11 20:10:25.015177 [ 47393 ] {} <Debug> system.asynchronous_metric_log (3855bb15-20f2-4f4f-b0ed-943bf8c2fb74): Loading data parts | ||
| 136 | 2025.02.11 20:10:25.015542 [ 47393 ] {} <Debug> system.asynchronous_metric_log (3855bb15-20f2-4f4f-b0ed-943bf8c2fb74): There are no data parts | ||
| 137 | 2025.02.11 20:10:25.020530 [ 47393 ] {} <Trace> system.asynchronous_metric_log (3855bb15-20f2-4f4f-b0ed-943bf8c2fb74): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 138 | 2025.02.11 20:10:25.020560 [ 47393 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.30 GiB. | ||
| 139 | 2025.02.11 20:10:25.021329 [ 47393 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 140 | 2025.02.11 20:10:25.021474 [ 47390 ] {} <Debug> system.metric_log (5812f884-0d18-4490-9da1-45618726e1c2): Loading data parts | ||
| 141 | 2025.02.11 20:10:25.021497 [ 47393 ] {} <Trace> system.asynchronous_metric_log (3855bb15-20f2-4f4f-b0ed-943bf8c2fb74): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 142 | 2025.02.11 20:10:25.021627 [ 47393 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1728 | ||
| 143 | 2025.02.11 20:10:25.021655 [ 47390 ] {} <Debug> system.metric_log (5812f884-0d18-4490-9da1-45618726e1c2): There are no data parts | ||
| 144 | 2025.02.11 20:10:25.042610 [ 47390 ] {} <Trace> system.metric_log (5812f884-0d18-4490-9da1-45618726e1c2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 145 | 2025.02.11 20:10:25.042658 [ 47390 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.30 GiB. | ||
| 146 | 2025.02.11 20:10:25.047877 [ 47390 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 147 | 2025.02.11 20:10:25.048620 [ 47390 ] {} <Trace> system.metric_log (5812f884-0d18-4490-9da1-45618726e1c2): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 148 | 2025.02.11 20:10:25.050521 [ 47390 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 149 | 2025.02.11 20:10:26.686163 [ 49180 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35532 | ||
| 150 | 2025.02.11 20:10:26.686260 [ 49180 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 151 | 2025.02.11 20:10:26.686284 [ 49180 ] {} <Debug> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Authenticating user 'default' from [::1]:35532 | ||
| 152 | 2025.02.11 20:10:26.686301 [ 49180 ] {} <Debug> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 153 | 2025.02.11 20:10:26.686308 [ 49180 ] {} <Debug> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2025.02.11 20:10:26.692250 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 155 | 2025.02.11 20:10:26.699219 [ 49180 ] {6753a5e9-da2a-414e-9adf-c1a2ab2508e9} <Debug> executeQuery: (from [::1]:35532) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 156 | 2025.02.11 20:10:26.699953 [ 49180 ] {6753a5e9-da2a-414e-9adf-c1a2ab2508e9} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:35532) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 157 | |||
| 158 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 159 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 160 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 161 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 162 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 163 | 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 | ||
| 164 | 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 | ||
| 165 | 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 | ||
| 166 | 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 | ||
| 167 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 168 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 171 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 172 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 173 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 174 | 16. ? @ 0x00007fc2b04d6ac3 in ? | ||
| 175 | 17. ? @ 0x00007fc2b0568850 in ? | ||
| 176 | |||
| 177 | 2025.02.11 20:10:26.701128 [ 49180 ] {6753a5e9-da2a-414e-9adf-c1a2ab2508e9} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 178 | |||
| 179 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 180 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 181 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 182 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 183 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 184 | 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 | ||
| 185 | 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 | ||
| 186 | 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 | ||
| 187 | 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 | ||
| 188 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 189 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 195 | 16. ? @ 0x00007fc2b04d6ac3 in ? | ||
| 196 | 17. ? @ 0x00007fc2b0568850 in ? | ||
| 197 | |||
| 198 | 2025.02.11 20:10:26.701190 [ 49180 ] {6753a5e9-da2a-414e-9adf-c1a2ab2508e9} <Debug> TCPHandler: Processed in 0.00914868 sec. | ||
| 199 | 2025.02.11 20:10:26.705022 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 200 | 2025.02.11 20:10:26.706886 [ 49180 ] {a0b039ef-e823-47af-ac89-45a7958a0c95} <Debug> executeQuery: (from [::1]:35532) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 201 | 2025.02.11 20:10:26.707150 [ 49180 ] {a0b039ef-e823-47af-ac89-45a7958a0c95} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:35532) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 202 | |||
| 203 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 204 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 205 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 206 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 207 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 208 | 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 | ||
| 209 | 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 | ||
| 210 | 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 | ||
| 211 | 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 | ||
| 212 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 213 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 214 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 215 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 216 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 217 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 218 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 219 | 16. ? @ 0x00007fc2b04d6ac3 in ? | ||
| 220 | 17. ? @ 0x00007fc2b0568850 in ? | ||
| 221 | |||
| 222 | 2025.02.11 20:10:26.707247 [ 49180 ] {a0b039ef-e823-47af-ac89-45a7958a0c95} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 223 | |||
| 224 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 225 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 226 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 227 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 228 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 229 | 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 | ||
| 230 | 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 | ||
| 231 | 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 | ||
| 232 | 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 | ||
| 233 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 234 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 235 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 236 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 237 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 238 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 239 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 240 | 16. ? @ 0x00007fc2b04d6ac3 in ? | ||
| 241 | 17. ? @ 0x00007fc2b0568850 in ? | ||
| 242 | |||
| 243 | 2025.02.11 20:10:26.707291 [ 49180 ] {a0b039ef-e823-47af-ac89-45a7958a0c95} <Debug> TCPHandler: Processed in 0.00243785 sec. | ||
| 244 | 2025.02.11 20:10:26.723263 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 245 | 2025.02.11 20:10:26.723471 [ 49180 ] {98a3d23f-6241-41ec-87ac-68ab34a4a40a} <Debug> executeQuery: (from [::1]:35532) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 246 | 2025.02.11 20:10:26.723571 [ 49180 ] {98a3d23f-6241-41ec-87ac-68ab34a4a40a} <Debug> TCPHandler: Processed in 0.00050796 sec. | ||
| 247 | 2025.02.11 20:10:26.726716 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 248 | 2025.02.11 20:10:26.726869 [ 49180 ] {b63f2f84-9dfb-41db-b693-a993c11c4a1e} <Debug> executeQuery: (from [::1]:35532) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 249 | 2025.02.11 20:10:26.726906 [ 49180 ] {b63f2f84-9dfb-41db-b693-a993c11c4a1e} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 250 | 2025.02.11 20:10:26.730731 [ 49180 ] {b63f2f84-9dfb-41db-b693-a993c11c4a1e} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 251 | 2025.02.11 20:10:26.730753 [ 49180 ] {b63f2f84-9dfb-41db-b693-a993c11c4a1e} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.195e-05 sec | ||
| 252 | 2025.02.11 20:10:26.730762 [ 49180 ] {b63f2f84-9dfb-41db-b693-a993c11c4a1e} <Trace> ReferentialDeps: No tables | ||
| 253 | 2025.02.11 20:10:26.730769 [ 49180 ] {b63f2f84-9dfb-41db-b693-a993c11c4a1e} <Trace> LoadingDeps: No tables | ||
| 254 | 2025.02.11 20:10:26.730793 [ 49180 ] {b63f2f84-9dfb-41db-b693-a993c11c4a1e} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 255 | 2025.02.11 20:10:26.730865 [ 49180 ] {b63f2f84-9dfb-41db-b693-a993c11c4a1e} <Debug> TCPHandler: Processed in 0.00426559 sec. | ||
| 256 | 2025.02.11 20:10:26.732027 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 257 | 2025.02.11 20:10:26.732252 [ 49180 ] {9a73ec50-3543-4633-bc9a-439205983af8} <Debug> executeQuery: (from [::1]:35532) /* The version table contains metadata about the `oximeter` database */ | ||
| 258 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 259 | 2025.02.11 20:10:26.732324 [ 49180 ] {9a73ec50-3543-4633-bc9a-439205983af8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 260 | 2025.02.11 20:10:26.740516 [ 49180 ] {9a73ec50-3543-4633-bc9a-439205983af8} <Debug> oximeter.version (e4a1f4fa-31f8-4672-a812-308f88834b8f): Loading data parts | ||
| 261 | 2025.02.11 20:10:26.741215 [ 49180 ] {9a73ec50-3543-4633-bc9a-439205983af8} <Debug> oximeter.version (e4a1f4fa-31f8-4672-a812-308f88834b8f): There are no data parts | ||
| 262 | 2025.02.11 20:10:26.744620 [ 49184 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35540 | ||
| 263 | 2025.02.11 20:10:26.744737 [ 49184 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 264 | 2025.02.11 20:10:26.744767 [ 49184 ] {} <Debug> TCP-Session: b1e926d5-645d-4aed-9b99-bab5baf443e5 Authenticating user 'default' from [::1]:35540 | ||
| 265 | 2025.02.11 20:10:26.744785 [ 49184 ] {} <Debug> TCP-Session: b1e926d5-645d-4aed-9b99-bab5baf443e5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 266 | 2025.02.11 20:10:26.744792 [ 49184 ] {} <Debug> TCP-Session: b1e926d5-645d-4aed-9b99-bab5baf443e5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 267 | 2025.02.11 20:10:26.744890 [ 49184 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 268 | 2025.02.11 20:10:26.744914 [ 49184 ] {} <Debug> TCP-Session: b1e926d5-645d-4aed-9b99-bab5baf443e5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2025.02.11 20:10:26.745070 [ 49185 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35542 | ||
| 270 | 2025.02.11 20:10:26.745144 [ 49185 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 271 | 2025.02.11 20:10:26.745185 [ 49185 ] {} <Debug> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Authenticating user 'default' from [::1]:35542 | ||
| 272 | 2025.02.11 20:10:26.745200 [ 49185 ] {} <Debug> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2025.02.11 20:10:26.745207 [ 49185 ] {} <Debug> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 274 | 2025.02.11 20:10:26.746040 [ 49186 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35544 | ||
| 275 | 2025.02.11 20:10:26.746153 [ 49186 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 276 | 2025.02.11 20:10:26.746180 [ 49186 ] {} <Debug> TCP-Session: 4046c4c2-d862-4a03-a289-fd3428f7c318 Authenticating user 'default' from [::1]:35544 | ||
| 277 | 2025.02.11 20:10:26.746191 [ 49186 ] {} <Debug> TCP-Session: 4046c4c2-d862-4a03-a289-fd3428f7c318 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 278 | 2025.02.11 20:10:26.746198 [ 49186 ] {} <Debug> TCP-Session: 4046c4c2-d862-4a03-a289-fd3428f7c318 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2025.02.11 20:10:26.746396 [ 49187 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35546 | ||
| 280 | 2025.02.11 20:10:26.746423 [ 49181 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35534 | ||
| 281 | 2025.02.11 20:10:26.746502 [ 49187 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 282 | 2025.02.11 20:10:26.746541 [ 49187 ] {} <Debug> TCP-Session: bfb272a4-280b-4ff1-a142-f38304739d93 Authenticating user 'default' from [::1]:35546 | ||
| 283 | 2025.02.11 20:10:26.746543 [ 49181 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 284 | 2025.02.11 20:10:26.746552 [ 49187 ] {} <Debug> TCP-Session: bfb272a4-280b-4ff1-a142-f38304739d93 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 285 | 2025.02.11 20:10:26.746575 [ 49187 ] {} <Debug> TCP-Session: bfb272a4-280b-4ff1-a142-f38304739d93 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 286 | 2025.02.11 20:10:26.746577 [ 49181 ] {} <Debug> TCP-Session: cf940e7a-9cf9-438d-a2c9-79745aba4742 Authenticating user 'default' from [::1]:35534 | ||
| 287 | 2025.02.11 20:10:26.746602 [ 49181 ] {} <Debug> TCP-Session: cf940e7a-9cf9-438d-a2c9-79745aba4742 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2025.02.11 20:10:26.746609 [ 49181 ] {} <Debug> TCP-Session: cf940e7a-9cf9-438d-a2c9-79745aba4742 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 289 | 2025.02.11 20:10:26.746715 [ 49183 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35538 | ||
| 290 | 2025.02.11 20:10:26.746801 [ 49183 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 291 | 2025.02.11 20:10:26.746824 [ 49183 ] {} <Debug> TCP-Session: b4d59ae0-f983-4af0-90c5-41ddd21e0695 Authenticating user 'default' from [::1]:35538 | ||
| 292 | 2025.02.11 20:10:26.746833 [ 49183 ] {} <Debug> TCP-Session: b4d59ae0-f983-4af0-90c5-41ddd21e0695 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2025.02.11 20:10:26.746838 [ 49183 ] {} <Debug> TCP-Session: b4d59ae0-f983-4af0-90c5-41ddd21e0695 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2025.02.11 20:10:26.746947 [ 49181 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 295 | 2025.02.11 20:10:26.746967 [ 49181 ] {} <Debug> TCP-Session: cf940e7a-9cf9-438d-a2c9-79745aba4742 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 296 | 2025.02.11 20:10:26.746969 [ 49183 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 297 | 2025.02.11 20:10:26.746991 [ 49183 ] {} <Debug> TCP-Session: b4d59ae0-f983-4af0-90c5-41ddd21e0695 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 298 | 2025.02.11 20:10:26.747477 [ 49180 ] {9a73ec50-3543-4633-bc9a-439205983af8} <Debug> TCPHandler: Processed in 0.01563772 sec. | ||
| 299 | 2025.02.11 20:10:26.751347 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 300 | 2025.02.11 20:10:26.768205 [ 49185 ] {91f8fa58-1b9e-472d-b509-5d7ce0d83392} <Debug> executeQuery: (from [::1]:35542) /* The measurement tables contain all individual samples from each timeseries. | ||
| 301 | * | ||
| 302 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 303 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 304 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 305 | * by all samples from the same timeseries. | ||
| 306 | * | ||
| 307 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 308 | * and then uses that to index quickly into the measurements tables. | ||
| 309 | */ | ||
| 310 | 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) | ||
| 311 | 2025.02.11 20:10:26.768477 [ 49185 ] {91f8fa58-1b9e-472d-b509-5d7ce0d83392} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 312 | 2025.02.11 20:10:26.776503 [ 49191 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35554 | ||
| 313 | 2025.02.11 20:10:26.793328 [ 49191 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 314 | 2025.02.11 20:10:26.793382 [ 49191 ] {} <Debug> TCP-Session: 2451ba86-d2cf-4637-9184-ca81ae4887e0 Authenticating user 'default' from [::1]:35554 | ||
| 315 | 2025.02.11 20:10:26.793401 [ 49191 ] {} <Debug> TCP-Session: 2451ba86-d2cf-4637-9184-ca81ae4887e0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 316 | 2025.02.11 20:10:26.793409 [ 49191 ] {} <Debug> TCP-Session: 2451ba86-d2cf-4637-9184-ca81ae4887e0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 317 | 2025.02.11 20:10:26.777519 [ 49192 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35556 | ||
| 318 | 2025.02.11 20:10:26.777665 [ 49182 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35536 | ||
| 319 | 2025.02.11 20:10:26.777675 [ 49189 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35550 | ||
| 320 | 2025.02.11 20:10:26.800298 [ 49182 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 321 | 2025.02.11 20:10:26.800445 [ 49182 ] {} <Debug> TCP-Session: 92c4e9c2-be3f-4b98-afa1-3e32e5d1d4e5 Authenticating user 'default' from [::1]:35536 | ||
| 322 | 2025.02.11 20:10:26.800444 [ 49189 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 323 | 2025.02.11 20:10:26.800464 [ 49182 ] {} <Debug> TCP-Session: 92c4e9c2-be3f-4b98-afa1-3e32e5d1d4e5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 324 | 2025.02.11 20:10:26.800472 [ 49182 ] {} <Debug> TCP-Session: 92c4e9c2-be3f-4b98-afa1-3e32e5d1d4e5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 325 | 2025.02.11 20:10:26.800474 [ 49189 ] {} <Debug> TCP-Session: f3390d08-af4a-4045-896a-c646d92002f7 Authenticating user 'default' from [::1]:35550 | ||
| 326 | 2025.02.11 20:10:26.800487 [ 49189 ] {} <Debug> TCP-Session: f3390d08-af4a-4045-896a-c646d92002f7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 327 | 2025.02.11 20:10:26.800494 [ 49189 ] {} <Debug> TCP-Session: f3390d08-af4a-4045-896a-c646d92002f7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 328 | 2025.02.11 20:10:26.796938 [ 49185 ] {91f8fa58-1b9e-472d-b509-5d7ce0d83392} <Debug> oximeter.measurements_bool (641ce092-a8fc-4a20-a812-60a5aa71ce97): Loading data parts | ||
| 329 | 2025.02.11 20:10:26.780990 [ 49188 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35548 | ||
| 330 | 2025.02.11 20:10:26.800610 [ 49182 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 331 | 2025.02.11 20:10:26.800625 [ 49188 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 332 | 2025.02.11 20:10:26.800639 [ 49182 ] {} <Debug> TCP-Session: 92c4e9c2-be3f-4b98-afa1-3e32e5d1d4e5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 333 | 2025.02.11 20:10:26.800659 [ 49188 ] {} <Debug> TCP-Session: cf51891e-2755-49f3-b913-4bc837c415a3 Authenticating user 'default' from [::1]:35548 | ||
| 334 | 2025.02.11 20:10:26.800671 [ 49188 ] {} <Debug> TCP-Session: cf51891e-2755-49f3-b913-4bc837c415a3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 335 | 2025.02.11 20:10:26.800678 [ 49188 ] {} <Debug> TCP-Session: cf51891e-2755-49f3-b913-4bc837c415a3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 336 | 2025.02.11 20:10:26.800795 [ 49188 ] {} <Debug> TCPHandler: Done processing connection. | ||
| 337 | 2025.02.11 20:10:26.800813 [ 49188 ] {} <Debug> TCP-Session: cf51891e-2755-49f3-b913-4bc837c415a3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 338 | 2025.02.11 20:10:26.800850 [ 49185 ] {91f8fa58-1b9e-472d-b509-5d7ce0d83392} <Debug> oximeter.measurements_bool (641ce092-a8fc-4a20-a812-60a5aa71ce97): There are no data parts | ||
| 339 | 2025.02.11 20:10:26.777743 [ 49190 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:35552 | ||
| 340 | 2025.02.11 20:10:26.800962 [ 49190 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 341 | 2025.02.11 20:10:26.800987 [ 49190 ] {} <Debug> TCP-Session: b9262fd4-26c1-4124-9de6-812fb5ea1b10 Authenticating user 'default' from [::1]:35552 | ||
| 342 | 2025.02.11 20:10:26.800997 [ 49190 ] {} <Debug> TCP-Session: b9262fd4-26c1-4124-9de6-812fb5ea1b10 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2025.02.11 20:10:26.801003 [ 49190 ] {} <Debug> TCP-Session: b9262fd4-26c1-4124-9de6-812fb5ea1b10 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 344 | 2025.02.11 20:10:26.801151 [ 49192 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 345 | 2025.02.11 20:10:26.801179 [ 49192 ] {} <Debug> TCP-Session: 91a833fb-d8c1-4378-b426-59a777af7546 Authenticating user 'default' from [::1]:35556 | ||
| 346 | 2025.02.11 20:10:26.801191 [ 49192 ] {} <Debug> TCP-Session: 91a833fb-d8c1-4378-b426-59a777af7546 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 347 | 2025.02.11 20:10:26.801197 [ 49192 ] {} <Debug> TCP-Session: 91a833fb-d8c1-4378-b426-59a777af7546 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 348 | 2025.02.11 20:10:26.808238 [ 49185 ] {91f8fa58-1b9e-472d-b509-5d7ce0d83392} <Debug> TCPHandler: Processed in 0.0571582 sec. | ||
| 349 | 2025.02.11 20:10:26.809173 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 350 | 2025.02.11 20:10:26.809468 [ 49180 ] {9d3839c4-6f6b-4a78-bdd1-3cf61b0323e4} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 351 | 2025.02.11 20:10:26.809524 [ 49180 ] {9d3839c4-6f6b-4a78-bdd1-3cf61b0323e4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 352 | 2025.02.11 20:10:26.815461 [ 49180 ] {9d3839c4-6f6b-4a78-bdd1-3cf61b0323e4} <Debug> oximeter.measurements_i8 (7510c930-c834-4520-9c5b-e3735e74b957): Loading data parts | ||
| 353 | 2025.02.11 20:10:26.815709 [ 49180 ] {9d3839c4-6f6b-4a78-bdd1-3cf61b0323e4} <Debug> oximeter.measurements_i8 (7510c930-c834-4520-9c5b-e3735e74b957): There are no data parts | ||
| 354 | 2025.02.11 20:10:26.819724 [ 49180 ] {9d3839c4-6f6b-4a78-bdd1-3cf61b0323e4} <Debug> TCPHandler: Processed in 0.010733371 sec. | ||
| 355 | 2025.02.11 20:10:26.820534 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 356 | 2025.02.11 20:10:26.824693 [ 49185 ] {486a2a71-e1a7-4642-a333-fc90db86be41} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 357 | 2025.02.11 20:10:26.824758 [ 49185 ] {486a2a71-e1a7-4642-a333-fc90db86be41} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 358 | 2025.02.11 20:10:26.830836 [ 49185 ] {486a2a71-e1a7-4642-a333-fc90db86be41} <Debug> oximeter.measurements_u8 (264ed717-da83-4586-8b50-d6875eec25f2): Loading data parts | ||
| 359 | 2025.02.11 20:10:26.832457 [ 49185 ] {486a2a71-e1a7-4642-a333-fc90db86be41} <Debug> oximeter.measurements_u8 (264ed717-da83-4586-8b50-d6875eec25f2): There are no data parts | ||
| 360 | 2025.02.11 20:10:26.838286 [ 49185 ] {486a2a71-e1a7-4642-a333-fc90db86be41} <Debug> TCPHandler: Processed in 0.01792503 sec. | ||
| 361 | 2025.02.11 20:10:26.839172 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 362 | 2025.02.11 20:10:26.839441 [ 49180 ] {8fe6dc2a-c846-4771-84e6-7d4f47c9bba8} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 363 | 2025.02.11 20:10:26.839484 [ 49180 ] {8fe6dc2a-c846-4771-84e6-7d4f47c9bba8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 364 | 2025.02.11 20:10:26.846662 [ 49180 ] {8fe6dc2a-c846-4771-84e6-7d4f47c9bba8} <Debug> oximeter.measurements_i16 (aa6801d0-78d6-4bdc-8df5-6fb155d5f7a4): Loading data parts | ||
| 365 | 2025.02.11 20:10:26.847032 [ 49180 ] {8fe6dc2a-c846-4771-84e6-7d4f47c9bba8} <Debug> oximeter.measurements_i16 (aa6801d0-78d6-4bdc-8df5-6fb155d5f7a4): There are no data parts | ||
| 366 | 2025.02.11 20:10:26.851599 [ 49180 ] {8fe6dc2a-c846-4771-84e6-7d4f47c9bba8} <Debug> TCPHandler: Processed in 0.01260893 sec. | ||
| 367 | 2025.02.11 20:10:26.854596 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 368 | 2025.02.11 20:10:26.854892 [ 49185 ] {86d495d0-de37-4b77-8209-051aa98ff4b9} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 369 | 2025.02.11 20:10:26.854946 [ 49185 ] {86d495d0-de37-4b77-8209-051aa98ff4b9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 370 | 2025.02.11 20:10:26.859762 [ 49185 ] {86d495d0-de37-4b77-8209-051aa98ff4b9} <Debug> oximeter.measurements_u16 (e9432919-bf63-453e-bb4d-57b0492d246b): Loading data parts | ||
| 371 | 2025.02.11 20:10:26.860010 [ 49185 ] {86d495d0-de37-4b77-8209-051aa98ff4b9} <Debug> oximeter.measurements_u16 (e9432919-bf63-453e-bb4d-57b0492d246b): There are no data parts | ||
| 372 | 2025.02.11 20:10:26.864704 [ 49185 ] {86d495d0-de37-4b77-8209-051aa98ff4b9} <Debug> TCPHandler: Processed in 0.01029397 sec. | ||
| 373 | 2025.02.11 20:10:26.865535 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 374 | 2025.02.11 20:10:26.865797 [ 49180 ] {2c4ecac5-e0d9-4b5c-bae0-d8a82b02f12f} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 375 | 2025.02.11 20:10:26.865859 [ 49180 ] {2c4ecac5-e0d9-4b5c-bae0-d8a82b02f12f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 376 | 2025.02.11 20:10:26.872920 [ 49180 ] {2c4ecac5-e0d9-4b5c-bae0-d8a82b02f12f} <Debug> oximeter.measurements_i32 (8980f595-08bd-4712-a54e-52c141b29ff2): Loading data parts | ||
| 377 | 2025.02.11 20:10:26.873583 [ 49180 ] {2c4ecac5-e0d9-4b5c-bae0-d8a82b02f12f} <Debug> oximeter.measurements_i32 (8980f595-08bd-4712-a54e-52c141b29ff2): There are no data parts | ||
| 378 | 2025.02.11 20:10:26.882695 [ 49180 ] {2c4ecac5-e0d9-4b5c-bae0-d8a82b02f12f} <Debug> TCPHandler: Processed in 0.017347261 sec. | ||
| 379 | 2025.02.11 20:10:26.884620 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 380 | 2025.02.11 20:10:26.884918 [ 49185 ] {a2edfea8-3f22-4ccc-acf9-f3c21167f5f5} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 381 | 2025.02.11 20:10:26.884997 [ 49185 ] {a2edfea8-3f22-4ccc-acf9-f3c21167f5f5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 382 | 2025.02.11 20:10:26.891520 [ 49185 ] {a2edfea8-3f22-4ccc-acf9-f3c21167f5f5} <Debug> oximeter.measurements_u32 (4df3551d-8120-4395-ac9b-d21b486d54bd): Loading data parts | ||
| 383 | 2025.02.11 20:10:26.891942 [ 49185 ] {a2edfea8-3f22-4ccc-acf9-f3c21167f5f5} <Debug> oximeter.measurements_u32 (4df3551d-8120-4395-ac9b-d21b486d54bd): There are no data parts | ||
| 384 | 2025.02.11 20:10:26.896959 [ 49185 ] {a2edfea8-3f22-4ccc-acf9-f3c21167f5f5} <Debug> TCPHandler: Processed in 0.01258951 sec. | ||
| 385 | 2025.02.11 20:10:26.898374 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 386 | 2025.02.11 20:10:26.899177 [ 49180 ] {2ca43b6f-f16d-477a-a3b5-a8a4c732ab45} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 387 | 2025.02.11 20:10:26.899235 [ 49180 ] {2ca43b6f-f16d-477a-a3b5-a8a4c732ab45} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 388 | 2025.02.11 20:10:26.906993 [ 49180 ] {2ca43b6f-f16d-477a-a3b5-a8a4c732ab45} <Debug> oximeter.measurements_i64 (2f614c49-b324-48a7-ad20-a0c3e41a7977): Loading data parts | ||
| 389 | 2025.02.11 20:10:26.908079 [ 49180 ] {2ca43b6f-f16d-477a-a3b5-a8a4c732ab45} <Debug> oximeter.measurements_i64 (2f614c49-b324-48a7-ad20-a0c3e41a7977): There are no data parts | ||
| 390 | 2025.02.11 20:10:26.911585 [ 49180 ] {2ca43b6f-f16d-477a-a3b5-a8a4c732ab45} <Debug> TCPHandler: Processed in 0.01335737 sec. | ||
| 391 | 2025.02.11 20:10:26.912447 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 392 | 2025.02.11 20:10:26.912757 [ 49185 ] {7c10e14c-9971-44b3-9c4a-a502b0d6e72f} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 393 | 2025.02.11 20:10:26.912810 [ 49185 ] {7c10e14c-9971-44b3-9c4a-a502b0d6e72f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 394 | 2025.02.11 20:10:26.923932 [ 49185 ] {7c10e14c-9971-44b3-9c4a-a502b0d6e72f} <Debug> oximeter.measurements_u64 (4bece7aa-af8d-4975-835a-6f252abc7728): Loading data parts | ||
| 395 | 2025.02.11 20:10:26.924398 [ 49185 ] {7c10e14c-9971-44b3-9c4a-a502b0d6e72f} <Debug> oximeter.measurements_u64 (4bece7aa-af8d-4975-835a-6f252abc7728): There are no data parts | ||
| 396 | 2025.02.11 20:10:26.928115 [ 49185 ] {7c10e14c-9971-44b3-9c4a-a502b0d6e72f} <Debug> TCPHandler: Processed in 0.01588063 sec. | ||
| 397 | 2025.02.11 20:10:26.928815 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 398 | 2025.02.11 20:10:26.929118 [ 49180 ] {958069ab-6cb1-47c7-8bb8-7a969ac28be7} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 399 | 2025.02.11 20:10:26.929168 [ 49180 ] {958069ab-6cb1-47c7-8bb8-7a969ac28be7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 400 | 2025.02.11 20:10:26.935669 [ 49180 ] {958069ab-6cb1-47c7-8bb8-7a969ac28be7} <Debug> oximeter.measurements_f32 (e8e3d512-228a-4904-83e1-56c45fb99819): Loading data parts | ||
| 401 | 2025.02.11 20:10:26.935956 [ 49180 ] {958069ab-6cb1-47c7-8bb8-7a969ac28be7} <Debug> oximeter.measurements_f32 (e8e3d512-228a-4904-83e1-56c45fb99819): There are no data parts | ||
| 402 | 2025.02.11 20:10:26.940254 [ 49180 ] {958069ab-6cb1-47c7-8bb8-7a969ac28be7} <Debug> TCPHandler: Processed in 0.01158173 sec. | ||
| 403 | 2025.02.11 20:10:26.941088 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 404 | 2025.02.11 20:10:26.941369 [ 49185 ] {95642a16-7bd2-4d99-891c-722075be4449} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 405 | 2025.02.11 20:10:26.941423 [ 49185 ] {95642a16-7bd2-4d99-891c-722075be4449} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 406 | 2025.02.11 20:10:26.947779 [ 49185 ] {95642a16-7bd2-4d99-891c-722075be4449} <Debug> oximeter.measurements_f64 (50c10614-cfde-4335-a333-a64232f2f7b0): Loading data parts | ||
| 407 | 2025.02.11 20:10:26.948097 [ 49185 ] {95642a16-7bd2-4d99-891c-722075be4449} <Debug> oximeter.measurements_f64 (50c10614-cfde-4335-a333-a64232f2f7b0): There are no data parts | ||
| 408 | 2025.02.11 20:10:26.952320 [ 49185 ] {95642a16-7bd2-4d99-891c-722075be4449} <Debug> TCPHandler: Processed in 0.011417751 sec. | ||
| 409 | 2025.02.11 20:10:26.953328 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 410 | 2025.02.11 20:10:26.953561 [ 49180 ] {26394dcf-f18e-4d41-9be8-04c74d181647} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 411 | 2025.02.11 20:10:26.953605 [ 49180 ] {26394dcf-f18e-4d41-9be8-04c74d181647} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 412 | 2025.02.11 20:10:26.960997 [ 49180 ] {26394dcf-f18e-4d41-9be8-04c74d181647} <Debug> oximeter.measurements_string (a73d24f8-3241-4e38-b54c-0615fda27b0c): Loading data parts | ||
| 413 | 2025.02.11 20:10:26.961280 [ 49180 ] {26394dcf-f18e-4d41-9be8-04c74d181647} <Debug> oximeter.measurements_string (a73d24f8-3241-4e38-b54c-0615fda27b0c): There are no data parts | ||
| 414 | 2025.02.11 20:10:26.965434 [ 49180 ] {26394dcf-f18e-4d41-9be8-04c74d181647} <Debug> TCPHandler: Processed in 0.01224757 sec. | ||
| 415 | 2025.02.11 20:10:26.966205 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 416 | 2025.02.11 20:10:26.967725 [ 49185 ] {5b1de977-b3c7-470b-8456-0e67941d9203} <Debug> executeQuery: (from [::1]:35542) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 417 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 418 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 419 | * a string isn't palatable for a few reasons. | ||
| 420 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 421 | * details. | ||
| 422 | */ | ||
| 423 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 424 | 2025.02.11 20:10:26.967773 [ 49185 ] {5b1de977-b3c7-470b-8456-0e67941d9203} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 425 | 2025.02.11 20:10:26.973908 [ 49185 ] {5b1de977-b3c7-470b-8456-0e67941d9203} <Debug> oximeter.measurements_bytes (d543b0b8-193a-43c6-ae16-b86c038011ce): Loading data parts | ||
| 426 | 2025.02.11 20:10:26.974172 [ 49185 ] {5b1de977-b3c7-470b-8456-0e67941d9203} <Debug> oximeter.measurements_bytes (d543b0b8-193a-43c6-ae16-b86c038011ce): There are no data parts | ||
| 427 | 2025.02.11 20:10:26.979384 [ 49185 ] {5b1de977-b3c7-470b-8456-0e67941d9203} <Debug> TCPHandler: Processed in 0.01333153 sec. | ||
| 428 | 2025.02.11 20:10:26.981506 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 429 | 2025.02.11 20:10:26.982739 [ 49180 ] {4ca388e3-bf2c-4c6b-a338-9a0ae10d1f86} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 430 | 2025.02.11 20:10:26.982800 [ 49180 ] {4ca388e3-bf2c-4c6b-a338-9a0ae10d1f86} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 431 | 2025.02.11 20:10:26.987973 [ 49180 ] {4ca388e3-bf2c-4c6b-a338-9a0ae10d1f86} <Debug> oximeter.measurements_cumulativei64 (a5a786b5-b2d6-40a7-90e6-86c48b7d2232): Loading data parts | ||
| 432 | 2025.02.11 20:10:26.988690 [ 49180 ] {4ca388e3-bf2c-4c6b-a338-9a0ae10d1f86} <Debug> oximeter.measurements_cumulativei64 (a5a786b5-b2d6-40a7-90e6-86c48b7d2232): There are no data parts | ||
| 433 | 2025.02.11 20:10:26.992635 [ 49180 ] {4ca388e3-bf2c-4c6b-a338-9a0ae10d1f86} <Debug> TCPHandler: Processed in 0.01130611 sec. | ||
| 434 | 2025.02.11 20:10:26.993427 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 435 | 2025.02.11 20:10:26.993686 [ 49185 ] {7fb3e98f-26ac-4ecb-84c0-40678376dbf2} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 436 | 2025.02.11 20:10:26.993737 [ 49185 ] {7fb3e98f-26ac-4ecb-84c0-40678376dbf2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 437 | 2025.02.11 20:10:27.001100 [ 49185 ] {7fb3e98f-26ac-4ecb-84c0-40678376dbf2} <Debug> oximeter.measurements_cumulativeu64 (107eec97-b8c5-4a6f-806b-0abd4f03a1b3): Loading data parts | ||
| 438 | 2025.02.11 20:10:27.001362 [ 49185 ] {7fb3e98f-26ac-4ecb-84c0-40678376dbf2} <Debug> oximeter.measurements_cumulativeu64 (107eec97-b8c5-4a6f-806b-0abd4f03a1b3): There are no data parts | ||
| 439 | 2025.02.11 20:10:27.007627 [ 49185 ] {7fb3e98f-26ac-4ecb-84c0-40678376dbf2} <Debug> TCPHandler: Processed in 0.01437025 sec. | ||
| 440 | 2025.02.11 20:10:27.008449 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 441 | 2025.02.11 20:10:27.008751 [ 49180 ] {97542360-b44f-487b-a043-3cfe2a486beb} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 442 | 2025.02.11 20:10:27.008805 [ 49180 ] {97542360-b44f-487b-a043-3cfe2a486beb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 443 | 2025.02.11 20:10:27.015224 [ 49180 ] {97542360-b44f-487b-a043-3cfe2a486beb} <Debug> oximeter.measurements_cumulativef32 (7c9173e1-83c0-421f-ad46-0884724968cc): Loading data parts | ||
| 444 | 2025.02.11 20:10:27.015495 [ 49180 ] {97542360-b44f-487b-a043-3cfe2a486beb} <Debug> oximeter.measurements_cumulativef32 (7c9173e1-83c0-421f-ad46-0884724968cc): There are no data parts | ||
| 445 | 2025.02.11 20:10:27.020242 [ 49180 ] {97542360-b44f-487b-a043-3cfe2a486beb} <Debug> TCPHandler: Processed in 0.01199211 sec. | ||
| 446 | 2025.02.11 20:10:27.021040 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 447 | 2025.02.11 20:10:27.021335 [ 49185 ] {b322b663-0c11-48c7-be9d-da6913661cc4} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 448 | 2025.02.11 20:10:27.021391 [ 49185 ] {b322b663-0c11-48c7-be9d-da6913661cc4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 449 | 2025.02.11 20:10:27.027760 [ 49185 ] {b322b663-0c11-48c7-be9d-da6913661cc4} <Debug> oximeter.measurements_cumulativef64 (2b012b6c-7a6e-4d34-9eaa-c3f96bce6ac4): Loading data parts | ||
| 450 | 2025.02.11 20:10:27.028020 [ 49185 ] {b322b663-0c11-48c7-be9d-da6913661cc4} <Debug> oximeter.measurements_cumulativef64 (2b012b6c-7a6e-4d34-9eaa-c3f96bce6ac4): There are no data parts | ||
| 451 | 2025.02.11 20:10:27.036711 [ 49185 ] {b322b663-0c11-48c7-be9d-da6913661cc4} <Debug> TCPHandler: Processed in 0.015837381 sec. | ||
| 452 | 2025.02.11 20:10:27.038065 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 453 | 2025.02.11 20:10:27.038449 [ 49180 ] {01692d82-c02e-4a73-afd7-55dc6a2a04e6} <Debug> executeQuery: (from [::1]:35532) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 454 | * NOTE: Array types cannot be Nullable, see | ||
| 455 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 456 | * for more details. | ||
| 457 | * | ||
| 458 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 459 | * is unfortunate, and at this point relies on the fact that an | ||
| 460 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 461 | * to figure out another way to represent missing samples here. | ||
| 462 | */ | ||
| 463 | 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) | ||
| 464 | 2025.02.11 20:10:27.038526 [ 49180 ] {01692d82-c02e-4a73-afd7-55dc6a2a04e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 465 | 2025.02.11 20:10:27.043311 [ 49180 ] {01692d82-c02e-4a73-afd7-55dc6a2a04e6} <Debug> oximeter.measurements_histogrami8 (a7c6cb2f-49b0-4c84-818f-8f321613579f): Loading data parts | ||
| 466 | 2025.02.11 20:10:27.043621 [ 49180 ] {01692d82-c02e-4a73-afd7-55dc6a2a04e6} <Debug> oximeter.measurements_histogrami8 (a7c6cb2f-49b0-4c84-818f-8f321613579f): There are no data parts | ||
| 467 | 2025.02.11 20:10:27.048405 [ 49180 ] {01692d82-c02e-4a73-afd7-55dc6a2a04e6} <Debug> TCPHandler: Processed in 0.01051184 sec. | ||
| 468 | 2025.02.11 20:10:27.049201 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 469 | 2025.02.11 20:10:27.049546 [ 49185 ] {2df465dd-83bc-4733-b2c5-fdfe16ccc848} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 470 | 2025.02.11 20:10:27.049603 [ 49185 ] {2df465dd-83bc-4733-b2c5-fdfe16ccc848} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 471 | 2025.02.11 20:10:27.060698 [ 49185 ] {2df465dd-83bc-4733-b2c5-fdfe16ccc848} <Debug> oximeter.measurements_histogramu8 (7068870b-e5f8-4dd3-9d66-369e54a6f524): Loading data parts | ||
| 472 | 2025.02.11 20:10:27.063038 [ 49185 ] {2df465dd-83bc-4733-b2c5-fdfe16ccc848} <Debug> oximeter.measurements_histogramu8 (7068870b-e5f8-4dd3-9d66-369e54a6f524): There are no data parts | ||
| 473 | 2025.02.11 20:10:27.071194 [ 49185 ] {2df465dd-83bc-4733-b2c5-fdfe16ccc848} <Debug> TCPHandler: Processed in 0.02213576 sec. | ||
| 474 | 2025.02.11 20:10:27.071993 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 475 | 2025.02.11 20:10:27.072377 [ 49180 ] {b6342a2e-5622-4a4c-b71d-a5a255d8c568} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 476 | 2025.02.11 20:10:27.072628 [ 49180 ] {b6342a2e-5622-4a4c-b71d-a5a255d8c568} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 477 | 2025.02.11 20:10:27.080762 [ 49180 ] {b6342a2e-5622-4a4c-b71d-a5a255d8c568} <Debug> oximeter.measurements_histogrami16 (e233a786-b254-4958-8734-8fd49e3c588a): Loading data parts | ||
| 478 | 2025.02.11 20:10:27.089970 [ 49180 ] {b6342a2e-5622-4a4c-b71d-a5a255d8c568} <Debug> oximeter.measurements_histogrami16 (e233a786-b254-4958-8734-8fd49e3c588a): There are no data parts | ||
| 479 | 2025.02.11 20:10:27.095350 [ 49180 ] {b6342a2e-5622-4a4c-b71d-a5a255d8c568} <Debug> TCPHandler: Processed in 0.023588181 sec. | ||
| 480 | 2025.02.11 20:10:27.141945 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 481 | 2025.02.11 20:10:27.144711 [ 49185 ] {b9e656cd-ddf9-4677-bf62-3a649478440b} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 482 | 2025.02.11 20:10:27.144786 [ 49185 ] {b9e656cd-ddf9-4677-bf62-3a649478440b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 483 | 2025.02.11 20:10:27.150927 [ 49185 ] {b9e656cd-ddf9-4677-bf62-3a649478440b} <Debug> oximeter.measurements_histogramu16 (ec2ddd3e-86bd-4c6b-85d2-83be579a068e): Loading data parts | ||
| 484 | 2025.02.11 20:10:27.151375 [ 49185 ] {b9e656cd-ddf9-4677-bf62-3a649478440b} <Debug> oximeter.measurements_histogramu16 (ec2ddd3e-86bd-4c6b-85d2-83be579a068e): There are no data parts | ||
| 485 | 2025.02.11 20:10:27.157286 [ 49185 ] {b9e656cd-ddf9-4677-bf62-3a649478440b} <Debug> TCPHandler: Processed in 0.015525761 sec. | ||
| 486 | 2025.02.11 20:10:27.158205 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 487 | 2025.02.11 20:10:27.159591 [ 49180 ] {bab8572c-9737-4d38-86a7-2265e6aa9f49} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 488 | 2025.02.11 20:10:27.159661 [ 49180 ] {bab8572c-9737-4d38-86a7-2265e6aa9f49} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 489 | 2025.02.11 20:10:27.169583 [ 49180 ] {bab8572c-9737-4d38-86a7-2265e6aa9f49} <Debug> oximeter.measurements_histogrami32 (eca312bc-9743-4e18-8b17-506df5629124): Loading data parts | ||
| 490 | 2025.02.11 20:10:27.169894 [ 49180 ] {bab8572c-9737-4d38-86a7-2265e6aa9f49} <Debug> oximeter.measurements_histogrami32 (eca312bc-9743-4e18-8b17-506df5629124): There are no data parts | ||
| 491 | 2025.02.11 20:10:27.174519 [ 49180 ] {bab8572c-9737-4d38-86a7-2265e6aa9f49} <Debug> TCPHandler: Processed in 0.01654063 sec. | ||
| 492 | 2025.02.11 20:10:27.175371 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 493 | 2025.02.11 20:10:27.176652 [ 49185 ] {ddf7a5d1-158e-43f6-a705-cd4ae9c13150} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 494 | 2025.02.11 20:10:27.176722 [ 49185 ] {ddf7a5d1-158e-43f6-a705-cd4ae9c13150} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 495 | 2025.02.11 20:10:27.182591 [ 49185 ] {ddf7a5d1-158e-43f6-a705-cd4ae9c13150} <Debug> oximeter.measurements_histogramu32 (0c298fc3-006b-4fce-8121-c00b6de527c0): Loading data parts | ||
| 496 | 2025.02.11 20:10:27.182962 [ 49185 ] {ddf7a5d1-158e-43f6-a705-cd4ae9c13150} <Debug> oximeter.measurements_histogramu32 (0c298fc3-006b-4fce-8121-c00b6de527c0): There are no data parts | ||
| 497 | 2025.02.11 20:10:27.186743 [ 49185 ] {ddf7a5d1-158e-43f6-a705-cd4ae9c13150} <Debug> TCPHandler: Processed in 0.01152195 sec. | ||
| 498 | 2025.02.11 20:10:27.187806 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 499 | 2025.02.11 20:10:27.188162 [ 49180 ] {0521b11c-8487-4cc5-8960-378063fb0087} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 500 | 2025.02.11 20:10:27.188224 [ 49180 ] {0521b11c-8487-4cc5-8960-378063fb0087} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 501 | 2025.02.11 20:10:27.196563 [ 49180 ] {0521b11c-8487-4cc5-8960-378063fb0087} <Debug> oximeter.measurements_histogrami64 (e7b491e7-7d51-46bd-82a1-2325b73a6eb5): Loading data parts | ||
| 502 | 2025.02.11 20:10:27.196930 [ 49180 ] {0521b11c-8487-4cc5-8960-378063fb0087} <Debug> oximeter.measurements_histogrami64 (e7b491e7-7d51-46bd-82a1-2325b73a6eb5): There are no data parts | ||
| 503 | 2025.02.11 20:10:27.202708 [ 49180 ] {0521b11c-8487-4cc5-8960-378063fb0087} <Debug> TCPHandler: Processed in 0.01507545 sec. | ||
| 504 | 2025.02.11 20:10:27.204550 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 505 | 2025.02.11 20:10:27.205346 [ 49185 ] {a6bc6940-7cb1-4660-8bc7-65c737579379} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 506 | 2025.02.11 20:10:27.205425 [ 49185 ] {a6bc6940-7cb1-4660-8bc7-65c737579379} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 507 | 2025.02.11 20:10:27.210588 [ 49185 ] {a6bc6940-7cb1-4660-8bc7-65c737579379} <Debug> oximeter.measurements_histogramu64 (023635d8-8c26-48ef-abfb-96b45503ef7b): Loading data parts | ||
| 508 | 2025.02.11 20:10:27.211048 [ 49185 ] {a6bc6940-7cb1-4660-8bc7-65c737579379} <Debug> oximeter.measurements_histogramu64 (023635d8-8c26-48ef-abfb-96b45503ef7b): There are no data parts | ||
| 509 | 2025.02.11 20:10:27.215911 [ 49185 ] {a6bc6940-7cb1-4660-8bc7-65c737579379} <Debug> TCPHandler: Processed in 0.0115499 sec. | ||
| 510 | 2025.02.11 20:10:27.216693 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 511 | 2025.02.11 20:10:27.217052 [ 49180 ] {aceb5f94-81bd-42a9-8956-0fb23205d0ee} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 512 | 2025.02.11 20:10:27.218563 [ 49180 ] {aceb5f94-81bd-42a9-8956-0fb23205d0ee} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 513 | 2025.02.11 20:10:27.223756 [ 49180 ] {aceb5f94-81bd-42a9-8956-0fb23205d0ee} <Debug> oximeter.measurements_histogramf32 (1c3cdaea-176d-4684-bb23-4527d5aa1221): Loading data parts | ||
| 514 | 2025.02.11 20:10:27.224012 [ 49180 ] {aceb5f94-81bd-42a9-8956-0fb23205d0ee} <Debug> oximeter.measurements_histogramf32 (1c3cdaea-176d-4684-bb23-4527d5aa1221): There are no data parts | ||
| 515 | 2025.02.11 20:10:27.231710 [ 49180 ] {aceb5f94-81bd-42a9-8956-0fb23205d0ee} <Debug> TCPHandler: Processed in 0.01519136 sec. | ||
| 516 | 2025.02.11 20:10:27.234072 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 517 | 2025.02.11 20:10:27.234459 [ 49185 ] {13d1d337-be9c-426b-af56-9bf28c13971a} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 518 | 2025.02.11 20:10:27.234529 [ 49185 ] {13d1d337-be9c-426b-af56-9bf28c13971a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 519 | 2025.02.11 20:10:27.240273 [ 49185 ] {13d1d337-be9c-426b-af56-9bf28c13971a} <Debug> oximeter.measurements_histogramf64 (efe20a97-81ef-45c4-8e25-8a0c3f15306a): Loading data parts | ||
| 520 | 2025.02.11 20:10:27.240645 [ 49185 ] {13d1d337-be9c-426b-af56-9bf28c13971a} <Debug> oximeter.measurements_histogramf64 (efe20a97-81ef-45c4-8e25-8a0c3f15306a): There are no data parts | ||
| 521 | 2025.02.11 20:10:27.247687 [ 49185 ] {13d1d337-be9c-426b-af56-9bf28c13971a} <Debug> TCPHandler: Processed in 0.01380424 sec. | ||
| 522 | 2025.02.11 20:10:27.249014 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 523 | 2025.02.11 20:10:27.249343 [ 49180 ] {8fafe71d-1775-4a72-acf7-28fe3512ddbc} <Debug> executeQuery: (from [::1]:35532) /* The field tables store named dimensions of each timeseries. | ||
| 524 | * | ||
| 525 | * As with the measurement tables, there is one field table for each field data | ||
| 526 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 527 | * this behavior **must not** be relied upon for query correctness. | ||
| 528 | * | ||
| 529 | * The index for the fields differs from the measurements, however. Rows are | ||
| 530 | * sorted by timeseries name, then field name, field value, and finally | ||
| 531 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 532 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 533 | * usually then used to look up measurements. | ||
| 534 | * | ||
| 535 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 536 | * timeseries name and then key, since it would improve lookups where one | ||
| 537 | * already has the key. Realistically though, these tables are quite small and | ||
| 538 | * so performance benefits will be low in absolute terms. | ||
| 539 | * | ||
| 540 | * TTL: We use a materialized column to expire old field table records. This | ||
| 541 | * column is generated automatically by the database whenever a new row is | ||
| 542 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 543 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 544 | * record will remain during a deduplication, which will have the last | ||
| 545 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 546 | * measurement tables. | ||
| 547 | */ | ||
| 548 | 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) | ||
| 549 | 2025.02.11 20:10:27.251091 [ 49180 ] {8fafe71d-1775-4a72-acf7-28fe3512ddbc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 550 | 2025.02.11 20:10:27.258649 [ 49180 ] {8fafe71d-1775-4a72-acf7-28fe3512ddbc} <Debug> oximeter.fields_bool (da04936b-f9e7-4183-aba9-986de685c58e): Loading data parts | ||
| 551 | 2025.02.11 20:10:27.258986 [ 49180 ] {8fafe71d-1775-4a72-acf7-28fe3512ddbc} <Debug> oximeter.fields_bool (da04936b-f9e7-4183-aba9-986de685c58e): There are no data parts | ||
| 552 | 2025.02.11 20:10:27.264401 [ 49180 ] {8fafe71d-1775-4a72-acf7-28fe3512ddbc} <Debug> TCPHandler: Processed in 0.0155806 sec. | ||
| 553 | 2025.02.11 20:10:27.265295 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 554 | 2025.02.11 20:10:27.265572 [ 49185 ] {c2d54c98-a0b8-48d3-b7d0-b1f45b1fd24e} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 555 | 2025.02.11 20:10:27.265633 [ 49185 ] {c2d54c98-a0b8-48d3-b7d0-b1f45b1fd24e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 556 | 2025.02.11 20:10:27.272547 [ 49185 ] {c2d54c98-a0b8-48d3-b7d0-b1f45b1fd24e} <Debug> oximeter.fields_i8 (e217386b-78d6-4079-823f-838d4be91a80): Loading data parts | ||
| 557 | 2025.02.11 20:10:27.272835 [ 49185 ] {c2d54c98-a0b8-48d3-b7d0-b1f45b1fd24e} <Debug> oximeter.fields_i8 (e217386b-78d6-4079-823f-838d4be91a80): There are no data parts | ||
| 558 | 2025.02.11 20:10:27.284905 [ 49185 ] {c2d54c98-a0b8-48d3-b7d0-b1f45b1fd24e} <Debug> TCPHandler: Processed in 0.01980692 sec. | ||
| 559 | 2025.02.11 20:10:27.285808 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 560 | 2025.02.11 20:10:27.288496 [ 49180 ] {acac2c31-491d-4b2b-ac40-defae6f754ce} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 561 | 2025.02.11 20:10:27.288557 [ 49180 ] {acac2c31-491d-4b2b-ac40-defae6f754ce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 562 | 2025.02.11 20:10:27.296111 [ 49180 ] {acac2c31-491d-4b2b-ac40-defae6f754ce} <Debug> oximeter.fields_u8 (1b6cab80-0011-44d6-9b7d-da2f58a0231c): Loading data parts | ||
| 563 | 2025.02.11 20:10:27.304495 [ 49180 ] {acac2c31-491d-4b2b-ac40-defae6f754ce} <Debug> oximeter.fields_u8 (1b6cab80-0011-44d6-9b7d-da2f58a0231c): There are no data parts | ||
| 564 | 2025.02.11 20:10:27.310453 [ 49180 ] {acac2c31-491d-4b2b-ac40-defae6f754ce} <Debug> TCPHandler: Processed in 0.024843201 sec. | ||
| 565 | 2025.02.11 20:10:27.311457 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 566 | 2025.02.11 20:10:27.312979 [ 49185 ] {27b04633-39aa-43fb-a98f-f5f1992f4f44} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 567 | 2025.02.11 20:10:27.313034 [ 49185 ] {27b04633-39aa-43fb-a98f-f5f1992f4f44} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 568 | 2025.02.11 20:10:27.323547 [ 49185 ] {27b04633-39aa-43fb-a98f-f5f1992f4f44} <Debug> oximeter.fields_i16 (5f9d72fa-768f-436c-9fb9-48c1430fd480): Loading data parts | ||
| 569 | 2025.02.11 20:10:27.323889 [ 49185 ] {27b04633-39aa-43fb-a98f-f5f1992f4f44} <Debug> oximeter.fields_i16 (5f9d72fa-768f-436c-9fb9-48c1430fd480): There are no data parts | ||
| 570 | 2025.02.11 20:10:27.329304 [ 49185 ] {27b04633-39aa-43fb-a98f-f5f1992f4f44} <Debug> TCPHandler: Processed in 0.01800828 sec. | ||
| 571 | 2025.02.11 20:10:27.332755 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 572 | 2025.02.11 20:10:27.333089 [ 49180 ] {9ffbf800-3d3a-49b7-9d44-bd7457f48610} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 573 | 2025.02.11 20:10:27.333146 [ 49180 ] {9ffbf800-3d3a-49b7-9d44-bd7457f48610} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 574 | 2025.02.11 20:10:27.340603 [ 49180 ] {9ffbf800-3d3a-49b7-9d44-bd7457f48610} <Debug> oximeter.fields_u16 (b5d5cdc5-c4ef-4bcf-855e-d180e6b9cbdc): Loading data parts | ||
| 575 | 2025.02.11 20:10:27.340875 [ 49180 ] {9ffbf800-3d3a-49b7-9d44-bd7457f48610} <Debug> oximeter.fields_u16 (b5d5cdc5-c4ef-4bcf-855e-d180e6b9cbdc): There are no data parts | ||
| 576 | 2025.02.11 20:10:27.344746 [ 49180 ] {9ffbf800-3d3a-49b7-9d44-bd7457f48610} <Debug> TCPHandler: Processed in 0.0121657 sec. | ||
| 577 | 2025.02.11 20:10:27.345679 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 578 | 2025.02.11 20:10:27.345980 [ 49185 ] {a483b265-d509-44f6-b410-2dcc472d03c8} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 579 | 2025.02.11 20:10:27.346039 [ 49185 ] {a483b265-d509-44f6-b410-2dcc472d03c8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 580 | 2025.02.11 20:10:27.354784 [ 49185 ] {a483b265-d509-44f6-b410-2dcc472d03c8} <Debug> oximeter.fields_i32 (3cc9eaa8-c541-47d8-a600-cc7a0c305be6): Loading data parts | ||
| 581 | 2025.02.11 20:10:27.355122 [ 49185 ] {a483b265-d509-44f6-b410-2dcc472d03c8} <Debug> oximeter.fields_i32 (3cc9eaa8-c541-47d8-a600-cc7a0c305be6): There are no data parts | ||
| 582 | 2025.02.11 20:10:27.362151 [ 49185 ] {a483b265-d509-44f6-b410-2dcc472d03c8} <Debug> TCPHandler: Processed in 0.016654921 sec. | ||
| 583 | 2025.02.11 20:10:27.362985 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 584 | 2025.02.11 20:10:27.363232 [ 49180 ] {1f579496-f115-4268-a794-746c3882dd0f} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 585 | 2025.02.11 20:10:27.363278 [ 49180 ] {1f579496-f115-4268-a794-746c3882dd0f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 586 | 2025.02.11 20:10:27.371396 [ 49180 ] {1f579496-f115-4268-a794-746c3882dd0f} <Debug> oximeter.fields_u32 (55cab44b-7401-4d29-9ab5-e20c4bf05d42): Loading data parts | ||
| 587 | 2025.02.11 20:10:27.371770 [ 49180 ] {1f579496-f115-4268-a794-746c3882dd0f} <Debug> oximeter.fields_u32 (55cab44b-7401-4d29-9ab5-e20c4bf05d42): There are no data parts | ||
| 588 | 2025.02.11 20:10:27.379135 [ 49180 ] {1f579496-f115-4268-a794-746c3882dd0f} <Debug> TCPHandler: Processed in 0.01632327 sec. | ||
| 589 | 2025.02.11 20:10:27.381175 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 590 | 2025.02.11 20:10:27.382633 [ 49185 ] {e75580ed-321c-44cd-9b1c-f6985ff1265a} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 591 | 2025.02.11 20:10:27.382689 [ 49185 ] {e75580ed-321c-44cd-9b1c-f6985ff1265a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 592 | 2025.02.11 20:10:27.387843 [ 49185 ] {e75580ed-321c-44cd-9b1c-f6985ff1265a} <Debug> oximeter.fields_i64 (ce705d04-bb45-4cb9-a3c4-1f796bbbee34): Loading data parts | ||
| 593 | 2025.02.11 20:10:27.388112 [ 49185 ] {e75580ed-321c-44cd-9b1c-f6985ff1265a} <Debug> oximeter.fields_i64 (ce705d04-bb45-4cb9-a3c4-1f796bbbee34): There are no data parts | ||
| 594 | 2025.02.11 20:10:27.393505 [ 49185 ] {e75580ed-321c-44cd-9b1c-f6985ff1265a} <Debug> TCPHandler: Processed in 0.01250792 sec. | ||
| 595 | 2025.02.11 20:10:27.394419 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 596 | 2025.02.11 20:10:27.394678 [ 49180 ] {b940cccb-555c-4239-b6f2-12ac7ca6a1fd} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 597 | 2025.02.11 20:10:27.394730 [ 49180 ] {b940cccb-555c-4239-b6f2-12ac7ca6a1fd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 598 | 2025.02.11 20:10:27.403434 [ 49180 ] {b940cccb-555c-4239-b6f2-12ac7ca6a1fd} <Debug> oximeter.fields_u64 (bbb1467f-fc1e-4a22-989d-0959399b4816): Loading data parts | ||
| 599 | 2025.02.11 20:10:27.403911 [ 49180 ] {b940cccb-555c-4239-b6f2-12ac7ca6a1fd} <Debug> oximeter.fields_u64 (bbb1467f-fc1e-4a22-989d-0959399b4816): There are no data parts | ||
| 600 | 2025.02.11 20:10:27.408327 [ 49180 ] {b940cccb-555c-4239-b6f2-12ac7ca6a1fd} <Debug> TCPHandler: Processed in 0.01408013 sec. | ||
| 601 | 2025.02.11 20:10:27.409177 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 602 | 2025.02.11 20:10:27.409471 [ 49185 ] {efc601e4-64d3-4644-99c2-2548b28683b1} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 603 | 2025.02.11 20:10:27.409525 [ 49185 ] {efc601e4-64d3-4644-99c2-2548b28683b1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 604 | 2025.02.11 20:10:27.416153 [ 49185 ] {efc601e4-64d3-4644-99c2-2548b28683b1} <Debug> oximeter.fields_ipaddr (1d72f742-8954-4b94-a4a3-2bf61453ef94): Loading data parts | ||
| 605 | 2025.02.11 20:10:27.416491 [ 49185 ] {efc601e4-64d3-4644-99c2-2548b28683b1} <Debug> oximeter.fields_ipaddr (1d72f742-8954-4b94-a4a3-2bf61453ef94): There are no data parts | ||
| 606 | 2025.02.11 20:10:27.422940 [ 49185 ] {efc601e4-64d3-4644-99c2-2548b28683b1} <Debug> TCPHandler: Processed in 0.013940951 sec. | ||
| 607 | 2025.02.11 20:10:27.423904 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 608 | 2025.02.11 20:10:27.424711 [ 49180 ] {06149d88-7919-4cfc-884f-177a48b93638} <Debug> executeQuery: (from [::1]:35532) 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) | ||
| 609 | 2025.02.11 20:10:27.424767 [ 49180 ] {06149d88-7919-4cfc-884f-177a48b93638} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 610 | 2025.02.11 20:10:27.429748 [ 49180 ] {06149d88-7919-4cfc-884f-177a48b93638} <Debug> oximeter.fields_string (f0a8212b-22c1-4113-be52-93f88d731e9a): Loading data parts | ||
| 611 | 2025.02.11 20:10:27.430026 [ 49180 ] {06149d88-7919-4cfc-884f-177a48b93638} <Debug> oximeter.fields_string (f0a8212b-22c1-4113-be52-93f88d731e9a): There are no data parts | ||
| 612 | 2025.02.11 20:10:27.434478 [ 49180 ] {06149d88-7919-4cfc-884f-177a48b93638} <Debug> TCPHandler: Processed in 0.010753051 sec. | ||
| 613 | 2025.02.11 20:10:27.435399 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 614 | 2025.02.11 20:10:27.435720 [ 49185 ] {6930e8a9-2527-4810-a50c-2194eb140831} <Debug> executeQuery: (from [::1]:35542) 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) | ||
| 615 | 2025.02.11 20:10:27.435781 [ 49185 ] {6930e8a9-2527-4810-a50c-2194eb140831} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 616 | 2025.02.11 20:10:27.444385 [ 49185 ] {6930e8a9-2527-4810-a50c-2194eb140831} <Debug> oximeter.fields_uuid (a696fb08-6198-4012-9002-b4308bdafa93): Loading data parts | ||
| 617 | 2025.02.11 20:10:27.444764 [ 49185 ] {6930e8a9-2527-4810-a50c-2194eb140831} <Debug> oximeter.fields_uuid (a696fb08-6198-4012-9002-b4308bdafa93): There are no data parts | ||
| 618 | 2025.02.11 20:10:27.451196 [ 49185 ] {6930e8a9-2527-4810-a50c-2194eb140831} <Debug> TCPHandler: Processed in 0.01606821 sec. | ||
| 619 | 2025.02.11 20:10:27.452032 [ 49180 ] {} <Trace> TCP-Session: 4553d390-cde4-4c22-b646-6667141c9f5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 620 | 2025.02.11 20:10:27.452404 [ 49180 ] {766996cf-e6b5-4fa1-acd3-5ebd217248bb} <Debug> executeQuery: (from [::1]:35532) /* The timeseries schema table stores the extracted schema for the samples | ||
| 621 | * oximeter collects. | ||
| 622 | */ | ||
| 623 | 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) | ||
| 624 | 2025.02.11 20:10:27.452484 [ 49180 ] {766996cf-e6b5-4fa1-acd3-5ebd217248bb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 625 | 2025.02.11 20:10:27.459414 [ 49180 ] {766996cf-e6b5-4fa1-acd3-5ebd217248bb} <Debug> oximeter.timeseries_schema (4aeb0868-8a25-4f0a-816c-247da10f6a40): Loading data parts | ||
| 626 | 2025.02.11 20:10:27.459707 [ 49180 ] {766996cf-e6b5-4fa1-acd3-5ebd217248bb} <Debug> oximeter.timeseries_schema (4aeb0868-8a25-4f0a-816c-247da10f6a40): There are no data parts | ||
| 627 | 2025.02.11 20:10:27.464308 [ 49180 ] {766996cf-e6b5-4fa1-acd3-5ebd217248bb} <Debug> TCPHandler: Processed in 0.01244782 sec. | ||
| 628 | 2025.02.11 20:10:27.465083 [ 49185 ] {} <Trace> TCP-Session: 305be6e8-5a1c-4b29-b9ad-31f3bc749839 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 629 | 2025.02.11 20:10:27.465284 [ 49185 ] {c923d4c5-90c1-41bb-b20d-93d5e956f2a1} <Debug> executeQuery: (from [::1]:35542) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 630 | 2025.02.11 20:10:27.465378 [ 49185 ] {c923d4c5-90c1-41bb-b20d-93d5e956f2a1} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 631 | 2025.02.11 20:10:27.466248 [ 49193 ] {c923d4c5-90c1-41bb-b20d-93d5e956f2a1} <Trace> oximeter.version (e4a1f4fa-31f8-4672-a812-308f88834b8f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 632 | 2025.02.11 20:10:27.469973 [ 49193 ] {c923d4c5-90c1-41bb-b20d-93d5e956f2a1} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.22 GiB. | ||
| 633 | 2025.02.11 20:10:27.470347 [ 49193 ] {c923d4c5-90c1-41bb-b20d-93d5e956f2a1} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 634 | 2025.02.11 20:10:27.470520 [ 49193 ] {c923d4c5-90c1-41bb-b20d-93d5e956f2a1} <Trace> oximeter.version (e4a1f4fa-31f8-4672-a812-308f88834b8f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 635 | 2025.02.11 20:10:27.470745 [ 49185 ] {c923d4c5-90c1-41bb-b20d-93d5e956f2a1} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.005521 sec., 181.12660749864156 rows/sec., 2.83 KiB/sec. | ||
| 636 | 2025.02.11 20:10:27.470955 [ 49185 ] {c923d4c5-90c1-41bb-b20d-93d5e956f2a1} <Debug> TCPHandler: Processed in 0.00604873 sec. | ||
| 637 | 2025.02.11 20:10:27.487112 [ 47394 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 90 entries to flush up to offset 90 | ||
| 638 | 2025.02.11 20:10:27.487184 [ 47394 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
| 639 | 2025.02.11 20:10:27.493462 [ 47394 ] {} <Debug> system.query_log (f8f24e13-a3e3-41ea-afaa-f5bb29735f69): Loading data parts | ||
| 640 | 2025.02.11 20:10:27.493702 [ 47394 ] {} <Debug> system.query_log (f8f24e13-a3e3-41ea-afaa-f5bb29735f69): There are no data parts | ||
| 641 | 2025.02.11 20:10:27.503444 [ 47394 ] {} <Trace> system.query_log (f8f24e13-a3e3-41ea-afaa-f5bb29735f69): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 642 | 2025.02.11 20:10:27.503480 [ 47394 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 162.22 GiB. | ||
| 643 | 2025.02.11 20:10:27.507066 [ 47394 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 644 | 2025.02.11 20:10:27.507293 [ 47394 ] {} <Trace> system.query_log (f8f24e13-a3e3-41ea-afaa-f5bb29735f69): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 645 | 2025.02.11 20:10:27.507627 [ 47394 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 90 | ||
| 646 | 2025.02.11 20:10:28.000452 [ 47396 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 404.78 MiB, peak 404.78 MiB, free memory in arenas 29.86 MiB, will set to 403.08 MiB (RSS), difference: -1.70 MiB | ||