| 1 | 2024.12.13 21:18:14.251578 [ 157693 ] {} <Information> SentryWriter: Sending crash reports is disabled | ||
| 2 | 2024.12.13 21:18:14.251649 [ 157693 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB | ||
| 3 | 2024.12.13 21:18:14.302825 [ 157693 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 157693 | ||
| 4 | 2024.12.13 21:18:14.302871 [ 157693 ] {} <Information> Application: starting up | ||
| 5 | 2024.12.13 21:18:14.302885 [ 157693 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 | ||
| 6 | 2024.12.13 21:18:14.305495 [ 157693 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. | ||
| 7 | 2024.12.13 21:18:14.322652 [ 157693 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal | ||
| 8 | 2024.12.13 21:18:14.328574 [ 157693 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block | ||
| 9 | 2024.12.13 21:18:14.328661 [ 157693 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac | ||
| 10 | 2024.12.13 21:18:14.328701 [ 157693 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon | ||
| 11 | 2024.12.13 21:18:14.691892 [ 157693 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) | ||
| 12 | 2024.12.13 21:18:14.691943 [ 157693 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 13 | 2024.12.13 21:18:14.699591 [ 157693 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024). | ||
| 14 | 2024.12.13 21:18:14.699617 [ 157693 ] {} <Debug> Application: rlimit on number of threads is 125612 | ||
| 15 | 2024.12.13 21:18:14.699625 [ 157693 ] {} <Debug> Application: Initializing DateLUT. | ||
| 16 | 2024.12.13 21:18:14.699630 [ 157693 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 17 | 2024.12.13 21:18:14.699653 [ 157693 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/datastore/tmp/ to store temporary data in it | ||
| 18 | 2024.12.13 21:18:14.700000 [ 157693 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 19 | 2024.12.13 21:18:14.700428 [ 157693 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml' | ||
| 20 | 2024.12.13 21:18:14.701941 [ 157693 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml', performing update on configuration | ||
| 21 | 2024.12.13 21:18:14.702482 [ 157693 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 22 | 2024.12.13 21:18:14.703418 [ 157693 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 23 | 2024.12.13 21:18:14.703428 [ 157693 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB | ||
| 24 | 2024.12.13 21:18:14.703500 [ 157693 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 25 | 2024.12.13 21:18:14.717112 [ 157693 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 26 | 2024.12.13 21:18:14.722416 [ 157693 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 27 | 2024.12.13 21:18:14.723388 [ 157693 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 28 | 2024.12.13 21:18:14.723930 [ 157693 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 29 | 2024.12.13 21:18:14.724961 [ 157693 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml', performed update on configuration | ||
| 30 | 2024.12.13 21:18:14.739555 [ 157693 ] {} <Debug> ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml' | ||
| 31 | 2024.12.13 21:18:14.740097 [ 157693 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml', performing update on configuration | ||
| 32 | 2024.12.13 21:18:14.740943 [ 157693 ] {} <Debug> ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml', performed update on configuration | ||
| 33 | 2024.12.13 21:18:14.743594 [ 157693 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml | ||
| 34 | 2024.12.13 21:18:14.780952 [ 157693 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 35 | 2024.12.13 21:18:14.806466 [ 157693 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 36 | 2024.12.13 21:18:14.806830 [ 157693 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 37 | 2024.12.13 21:18:14.807135 [ 157693 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 38 | 2024.12.13 21:18:14.825419 [ 157693 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 39 | 2024.12.13 21:18:14.825470 [ 157693 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/datastore/ | ||
| 40 | 2024.12.13 21:18:14.825535 [ 157707 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 41 | 2024.12.13 21:18:14.825752 [ 157707 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 42 | 2024.12.13 21:18:14.840191 [ 157693 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 43 | 2024.12.13 21:18:14.840217 [ 157693 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000133691 sec | ||
| 44 | 2024.12.13 21:18:14.840222 [ 157693 ] {} <Trace> ReferentialDeps: No tables | ||
| 45 | 2024.12.13 21:18:14.840227 [ 157693 ] {} <Trace> LoadingDeps: No tables | ||
| 46 | 2024.12.13 21:18:14.840265 [ 157693 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 47 | 2024.12.13 21:18:14.840285 [ 157693 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 48 | 2024.12.13 21:18:14.841973 [ 157693 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 49 | 2024.12.13 21:18:14.841989 [ 157693 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 50 | 2024.12.13 21:18:14.841997 [ 157693 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 51 | 2024.12.13 21:18:14.842004 [ 157693 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 52 | 2024.12.13 21:18:14.842011 [ 157693 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 53 | 2024.12.13 21:18:14.842019 [ 157693 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 54 | 2024.12.13 21:18:14.846193 [ 157693 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 55 | 2024.12.13 21:18:14.846213 [ 157693 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 56 | 2024.12.13 21:18:14.846223 [ 157693 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 57 | 2024.12.13 21:18:14.846440 [ 157693 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 58 | 2024.12.13 21:18:14.846455 [ 157693 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 59 | 2024.12.13 21:18:14.846462 [ 157693 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 60 | 2024.12.13 21:18:14.846469 [ 157693 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 61 | 2024.12.13 21:18:14.846476 [ 157693 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 62 | 2024.12.13 21:18:14.846483 [ 157693 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 63 | 2024.12.13 21:18:14.846490 [ 157693 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 64 | 2024.12.13 21:18:14.866046 [ 157693 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 65 | 2024.12.13 21:18:14.877367 [ 157693 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 66 | 2024.12.13 21:18:14.877396 [ 157693 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.297e-05 sec | ||
| 67 | 2024.12.13 21:18:14.877404 [ 157693 ] {} <Trace> ReferentialDeps: No tables | ||
| 68 | 2024.12.13 21:18:14.877410 [ 157693 ] {} <Trace> LoadingDeps: No tables | ||
| 69 | 2024.12.13 21:18:14.877439 [ 157693 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 70 | 2024.12.13 21:18:14.877589 [ 157693 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/datastore/user_defined/ | ||
| 71 | 2024.12.13 21:18:14.877626 [ 157693 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 72 | 2024.12.13 21:18:14.877633 [ 157693 ] {} <Debug> Application: Loaded metadata. | ||
| 73 | 2024.12.13 21:18:14.877656 [ 157693 ] {} <Information> Application: Tasks stats provider: procfs | ||
| 74 | 2024.12.13 21:18:14.877663 [ 157693 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems. | ||
| 75 | 2024.12.13 21:18:14.877750 [ 157693 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 42229 | ||
| 76 | 2024.12.13 21:18:14.877804 [ 157693 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40789 | ||
| 77 | 2024.12.13 21:18:14.877973 [ 157693 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 33805 | ||
| 78 | 2024.12.13 21:18:14.878014 [ 157693 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 43283 | ||
| 79 | 2024.12.13 21:18:14.878036 [ 157693 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 80 | 2024.12.13 21:18:14.878525 [ 157693 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 20.64 MiB, peak 20.64 MiB, free memory in arenas 19.92 MiB, will set to 387.44 MiB (RSS), difference: 366.80 MiB | ||
| 81 | 2024.12.13 21:18:14.882439 [ 157693 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.952e-05 sec. | ||
| 82 | 2024.12.13 21:18:14.882791 [ 157693 ] {} <Information> Application: Listening for http://[::1]:42229 | ||
| 83 | 2024.12.13 21:18:14.882852 [ 157693 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:40789 | ||
| 84 | 2024.12.13 21:18:14.882899 [ 157693 ] {} <Information> Application: Listening for http://127.0.0.1:33805 | ||
| 85 | 2024.12.13 21:18:14.882940 [ 157693 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:43283 | ||
| 86 | 2024.12.13 21:18:14.882948 [ 157693 ] {} <Information> Application: Ready for connections. | ||
| 87 | 2024.12.13 21:18:15.790527 [ 157696 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58154 | ||
| 88 | 2024.12.13 21:18:15.790725 [ 157696 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 89 | 2024.12.13 21:18:15.790767 [ 157696 ] {} <Debug> TCP-Session: 7d777e19-271c-49bf-b88c-bbb86ec5f145 Authenticating user 'default' from [::1]:58154 | ||
| 90 | 2024.12.13 21:18:15.790784 [ 157696 ] {} <Debug> TCP-Session: 7d777e19-271c-49bf-b88c-bbb86ec5f145 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2024.12.13 21:18:15.790790 [ 157696 ] {} <Debug> TCP-Session: 7d777e19-271c-49bf-b88c-bbb86ec5f145 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 92 | 2024.12.13 21:18:15.790872 [ 157696 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 93 | 2024.12.13 21:18:15.790898 [ 157696 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 94 | 2024.12.13 21:18:15.790906 [ 157696 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 95 | 2024.12.13 21:18:15.795081 [ 157697 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58156 | ||
| 96 | 2024.12.13 21:18:15.795292 [ 157698 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58158 | ||
| 97 | 2024.12.13 21:18:15.796998 [ 157697 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 98 | 2024.12.13 21:18:15.797032 [ 157697 ] {} <Debug> TCP-Session: 73d18c5a-355d-4c72-ad75-354017a1932e Authenticating user 'default' from [::1]:58156 | ||
| 99 | 2024.12.13 21:18:15.797049 [ 157697 ] {} <Debug> TCP-Session: 73d18c5a-355d-4c72-ad75-354017a1932e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 100 | 2024.12.13 21:18:15.797056 [ 157697 ] {} <Debug> TCP-Session: 73d18c5a-355d-4c72-ad75-354017a1932e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 101 | 2024.12.13 21:18:15.798059 [ 157698 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 102 | 2024.12.13 21:18:15.798229 [ 157698 ] {} <Debug> TCP-Session: a41cf591-7a6e-45e9-8a88-c44c1d5d3e74 Authenticating user 'default' from [::1]:58158 | ||
| 103 | 2024.12.13 21:18:15.798248 [ 157698 ] {} <Debug> TCP-Session: a41cf591-7a6e-45e9-8a88-c44c1d5d3e74 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 104 | 2024.12.13 21:18:15.798256 [ 157698 ] {} <Debug> TCP-Session: a41cf591-7a6e-45e9-8a88-c44c1d5d3e74 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 105 | 2024.12.13 21:18:15.827033 [ 158358 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58160 | ||
| 106 | 2024.12.13 21:18:15.827032 [ 158363 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58164 | ||
| 107 | 2024.12.13 21:18:15.827198 [ 158363 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 108 | 2024.12.13 21:18:15.827269 [ 158358 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 109 | 2024.12.13 21:18:15.828517 [ 158358 ] {} <Debug> TCP-Session: 0a82b362-8ab4-434e-91da-bc33ed3a24aa Authenticating user 'default' from [::1]:58160 | ||
| 110 | 2024.12.13 21:18:15.828554 [ 158358 ] {} <Debug> TCP-Session: 0a82b362-8ab4-434e-91da-bc33ed3a24aa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 111 | 2024.12.13 21:18:15.828561 [ 158358 ] {} <Debug> TCP-Session: 0a82b362-8ab4-434e-91da-bc33ed3a24aa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 112 | 2024.12.13 21:18:15.828961 [ 158363 ] {} <Debug> TCP-Session: 06134f7c-dcb2-4538-aaba-f5026993830b Authenticating user 'default' from [::1]:58164 | ||
| 113 | 2024.12.13 21:18:15.828976 [ 158363 ] {} <Debug> TCP-Session: 06134f7c-dcb2-4538-aaba-f5026993830b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 114 | 2024.12.13 21:18:15.828983 [ 158363 ] {} <Debug> TCP-Session: 06134f7c-dcb2-4538-aaba-f5026993830b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 115 | 2024.12.13 21:18:15.827306 [ 158365 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58166 | ||
| 116 | 2024.12.13 21:18:15.827346 [ 158368 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58168 | ||
| 117 | 2024.12.13 21:18:15.827398 [ 158364 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58162 | ||
| 118 | 2024.12.13 21:18:15.829206 [ 158365 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 119 | 2024.12.13 21:18:15.830521 [ 158365 ] {} <Debug> TCP-Session: d7a68c9a-9999-410b-92a8-bf64be6180b5 Authenticating user 'default' from [::1]:58166 | ||
| 120 | 2024.12.13 21:18:15.830534 [ 158365 ] {} <Debug> TCP-Session: d7a68c9a-9999-410b-92a8-bf64be6180b5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 121 | 2024.12.13 21:18:15.830541 [ 158365 ] {} <Debug> TCP-Session: d7a68c9a-9999-410b-92a8-bf64be6180b5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 122 | 2024.12.13 21:18:15.830611 [ 158364 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 123 | 2024.12.13 21:18:15.830634 [ 158364 ] {} <Debug> TCP-Session: b41a892a-f720-4f00-8cf7-a9b3d9d6992a Authenticating user 'default' from [::1]:58162 | ||
| 124 | 2024.12.13 21:18:15.830643 [ 158364 ] {} <Debug> TCP-Session: b41a892a-f720-4f00-8cf7-a9b3d9d6992a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 125 | 2024.12.13 21:18:15.830648 [ 158364 ] {} <Debug> TCP-Session: b41a892a-f720-4f00-8cf7-a9b3d9d6992a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 126 | 2024.12.13 21:18:15.830695 [ 158368 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2024.12.13 21:18:15.830721 [ 158368 ] {} <Debug> TCP-Session: 013e17c0-e302-467d-8741-5263471c6094 Authenticating user 'default' from [::1]:58168 | ||
| 128 | 2024.12.13 21:18:15.830731 [ 158368 ] {} <Debug> TCP-Session: 013e17c0-e302-467d-8741-5263471c6094 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2024.12.13 21:18:15.830737 [ 158368 ] {} <Debug> TCP-Session: 013e17c0-e302-467d-8741-5263471c6094 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2024.12.13 21:18:22.348323 [ 158124 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 1960 entries to flush up to offset 1960 | ||
| 131 | 2024.12.13 21:18:22.348387 [ 158124 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 132 | 2024.12.13 21:18:22.349144 [ 158123 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 133 | 2024.12.13 21:18:22.349194 [ 158123 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 134 | 2024.12.13 21:18:22.351011 [ 158124 ] {} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 135 | 2024.12.13 21:18:22.359725 [ 158124 ] {} <Debug> system.asynchronous_metric_log (af8332b9-01a9-4123-89c9-2f959110a6f3): Loading data parts | ||
| 136 | 2024.12.13 21:18:22.366691 [ 158124 ] {} <Debug> system.asynchronous_metric_log (af8332b9-01a9-4123-89c9-2f959110a6f3): There are no data parts | ||
| 137 | 2024.12.13 21:18:22.373223 [ 158124 ] {} <Trace> system.asynchronous_metric_log (af8332b9-01a9-4123-89c9-2f959110a6f3): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 138 | 2024.12.13 21:18:22.373257 [ 158124 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.24 GiB. | ||
| 139 | 2024.12.13 21:18:22.374052 [ 158124 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 140 | 2024.12.13 21:18:22.374252 [ 158124 ] {} <Trace> system.asynchronous_metric_log (af8332b9-01a9-4123-89c9-2f959110a6f3): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 141 | 2024.12.13 21:18:22.374415 [ 158124 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1960 | ||
| 142 | 2024.12.13 21:18:22.391979 [ 158123 ] {} <Debug> system.metric_log (ee510121-94f3-49b2-afa0-1733ea60203b): Loading data parts | ||
| 143 | 2024.12.13 21:18:22.392291 [ 158123 ] {} <Debug> system.metric_log (ee510121-94f3-49b2-afa0-1733ea60203b): There are no data parts | ||
| 144 | 2024.12.13 21:18:22.452619 [ 158123 ] {} <Trace> system.metric_log (ee510121-94f3-49b2-afa0-1733ea60203b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 145 | 2024.12.13 21:18:22.452666 [ 158123 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.24 GiB. | ||
| 146 | 2024.12.13 21:18:22.512173 [ 158123 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 147 | 2024.12.13 21:18:22.513734 [ 158123 ] {} <Trace> system.metric_log (ee510121-94f3-49b2-afa0-1733ea60203b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 148 | 2024.12.13 21:18:22.516002 [ 158123 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 149 | 2024.12.13 21:18:23.000465 [ 158184 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 393.02 MiB, peak 397.02 MiB, free memory in arenas 31.10 MiB, will set to 396.29 MiB (RSS), difference: 3.27 MiB | ||
| 150 | 2024.12.13 21:18:25.482167 [ 159551 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58174 | ||
| 151 | 2024.12.13 21:18:25.482268 [ 159551 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 152 | 2024.12.13 21:18:25.482291 [ 159551 ] {} <Debug> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Authenticating user 'default' from [::1]:58174 | ||
| 153 | 2024.12.13 21:18:25.482307 [ 159551 ] {} <Debug> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2024.12.13 21:18:25.482313 [ 159551 ] {} <Debug> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 155 | 2024.12.13 21:18:25.484123 [ 159554 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58182 | ||
| 156 | 2024.12.13 21:18:25.484321 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 157 | 2024.12.13 21:18:25.489180 [ 159554 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 158 | 2024.12.13 21:18:25.490290 [ 159554 ] {} <Debug> TCP-Session: 2a4fc627-bc92-4402-9afe-b4c6c9237358 Authenticating user 'default' from [::1]:58182 | ||
| 159 | 2024.12.13 21:18:25.490307 [ 159554 ] {} <Debug> TCP-Session: 2a4fc627-bc92-4402-9afe-b4c6c9237358 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 160 | 2024.12.13 21:18:25.490314 [ 159554 ] {} <Debug> TCP-Session: 2a4fc627-bc92-4402-9afe-b4c6c9237358 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 161 | 2024.12.13 21:18:25.489793 [ 159556 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58186 | ||
| 162 | 2024.12.13 21:18:25.490470 [ 159556 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 163 | 2024.12.13 21:18:25.490494 [ 159556 ] {} <Debug> TCP-Session: ec137411-2e7b-41e7-81ae-380732445bb2 Authenticating user 'default' from [::1]:58186 | ||
| 164 | 2024.12.13 21:18:25.490501 [ 159556 ] {} <Debug> TCP-Session: ec137411-2e7b-41e7-81ae-380732445bb2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 165 | 2024.12.13 21:18:25.490506 [ 159556 ] {} <Debug> TCP-Session: ec137411-2e7b-41e7-81ae-380732445bb2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 166 | 2024.12.13 21:18:25.490640 [ 159559 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58192 | ||
| 167 | 2024.12.13 21:18:25.490723 [ 159559 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 168 | 2024.12.13 21:18:25.490743 [ 159559 ] {} <Debug> TCP-Session: 8030a1d7-70e1-47ab-b639-309c3feb61b0 Authenticating user 'default' from [::1]:58192 | ||
| 169 | 2024.12.13 21:18:25.490751 [ 159559 ] {} <Debug> TCP-Session: 8030a1d7-70e1-47ab-b639-309c3feb61b0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 170 | 2024.12.13 21:18:25.490756 [ 159559 ] {} <Debug> TCP-Session: 8030a1d7-70e1-47ab-b639-309c3feb61b0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 171 | 2024.12.13 21:18:25.489804 [ 159552 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58176 | ||
| 172 | 2024.12.13 21:18:25.490895 [ 159552 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 173 | 2024.12.13 21:18:25.490926 [ 159552 ] {} <Debug> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Authenticating user 'default' from [::1]:58176 | ||
| 174 | 2024.12.13 21:18:25.490937 [ 159552 ] {} <Debug> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 175 | 2024.12.13 21:18:25.490944 [ 159552 ] {} <Debug> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 176 | 2024.12.13 21:18:25.491089 [ 159551 ] {205213f2-3993-4620-906b-af2fe6c0ebf1} <Debug> executeQuery: (from [::1]:58174) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 177 | 2024.12.13 21:18:25.490112 [ 159553 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58178 | ||
| 178 | 2024.12.13 21:18:25.492475 [ 159553 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 179 | 2024.12.13 21:18:25.492501 [ 159553 ] {} <Debug> TCP-Session: c5881f14-6d36-4094-9c46-51cd397241cc Authenticating user 'default' from [::1]:58178 | ||
| 180 | 2024.12.13 21:18:25.492512 [ 159553 ] {} <Debug> TCP-Session: c5881f14-6d36-4094-9c46-51cd397241cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 181 | 2024.12.13 21:18:25.492519 [ 159553 ] {} <Debug> TCP-Session: c5881f14-6d36-4094-9c46-51cd397241cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 182 | 2024.12.13 21:18:25.490059 [ 159557 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58188 | ||
| 183 | 2024.12.13 21:18:25.492654 [ 159557 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 184 | 2024.12.13 21:18:25.492676 [ 159557 ] {} <Debug> TCP-Session: d3773d18-5281-4657-aaaa-21523e948ce6 Authenticating user 'default' from [::1]:58188 | ||
| 185 | 2024.12.13 21:18:25.492686 [ 159557 ] {} <Debug> TCP-Session: d3773d18-5281-4657-aaaa-21523e948ce6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 186 | 2024.12.13 21:18:25.492691 [ 159557 ] {} <Debug> TCP-Session: d3773d18-5281-4657-aaaa-21523e948ce6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 187 | 2024.12.13 21:18:25.493710 [ 159551 ] {205213f2-3993-4620-906b-af2fe6c0ebf1} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:58174) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 188 | |||
| 189 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 195 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 197 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 198 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 199 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 200 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 201 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 202 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 203 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 204 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 205 | 16. ? @ 0x00007ff3e48f3ac3 in ? | ||
| 206 | 17. ? @ 0x00007ff3e4985850 in ? | ||
| 207 | |||
| 208 | 2024.12.13 21:18:25.495818 [ 159551 ] {205213f2-3993-4620-906b-af2fe6c0ebf1} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 209 | |||
| 210 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 211 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 212 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 213 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 214 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 215 | 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 | ||
| 216 | 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 | ||
| 217 | 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 | ||
| 218 | 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 | ||
| 219 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 220 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 221 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 222 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 223 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 224 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 225 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 226 | 16. ? @ 0x00007ff3e48f3ac3 in ? | ||
| 227 | 17. ? @ 0x00007ff3e4985850 in ? | ||
| 228 | |||
| 229 | 2024.12.13 21:18:25.495883 [ 159551 ] {205213f2-3993-4620-906b-af2fe6c0ebf1} <Debug> TCPHandler: Processed in 0.011747439 sec. | ||
| 230 | 2024.12.13 21:18:25.497024 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 231 | 2024.12.13 21:18:25.497248 [ 159552 ] {b5e85475-afbd-49ae-a56e-8079d7a6a375} <Debug> executeQuery: (from [::1]:58176) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 232 | 2024.12.13 21:18:25.497521 [ 159552 ] {b5e85475-afbd-49ae-a56e-8079d7a6a375} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:58176) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 233 | |||
| 234 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 235 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 236 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 237 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 238 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 239 | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 240 | 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 241 | 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 242 | 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 243 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 244 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 245 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 246 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 247 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 248 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 249 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 250 | 16. ? @ 0x00007ff3e48f3ac3 in ? | ||
| 251 | 17. ? @ 0x00007ff3e4985850 in ? | ||
| 252 | |||
| 253 | 2024.12.13 21:18:25.497628 [ 159552 ] {b5e85475-afbd-49ae-a56e-8079d7a6a375} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 254 | |||
| 255 | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 256 | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 257 | 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 258 | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 259 | 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 260 | 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 | ||
| 261 | 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 | ||
| 262 | 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 | ||
| 263 | 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 | ||
| 264 | 9. DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 265 | 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 266 | 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 267 | 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 268 | 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 269 | 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 270 | 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 271 | 16. ? @ 0x00007ff3e48f3ac3 in ? | ||
| 272 | 17. ? @ 0x00007ff3e4985850 in ? | ||
| 273 | |||
| 274 | 2024.12.13 21:18:25.497679 [ 159552 ] {b5e85475-afbd-49ae-a56e-8079d7a6a375} <Debug> TCPHandler: Processed in 0.000842201 sec. | ||
| 275 | 2024.12.13 21:18:25.498131 [ 159553 ] {} <Trace> TCP-Session: c5881f14-6d36-4094-9c46-51cd397241cc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 276 | 2024.12.13 21:18:25.498316 [ 159553 ] {766595c2-2e34-495d-b3eb-40e067765dee} <Debug> executeQuery: (from [::1]:58178) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 277 | 2024.12.13 21:18:25.498445 [ 159553 ] {766595c2-2e34-495d-b3eb-40e067765dee} <Debug> TCPHandler: Processed in 0.000408971 sec. | ||
| 278 | 2024.12.13 21:18:25.490142 [ 159555 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58184 | ||
| 279 | 2024.12.13 21:18:25.490065 [ 159558 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [::1]:58190 | ||
| 280 | 2024.12.13 21:18:25.498982 [ 159555 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 281 | 2024.12.13 21:18:25.499005 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 282 | 2024.12.13 21:18:25.499027 [ 159555 ] {} <Debug> TCP-Session: fb686690-bd49-4ac8-afe3-66c513402dfb Authenticating user 'default' from [::1]:58184 | ||
| 283 | 2024.12.13 21:18:25.499031 [ 159558 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 284 | 2024.12.13 21:18:25.499045 [ 159555 ] {} <Debug> TCP-Session: fb686690-bd49-4ac8-afe3-66c513402dfb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 285 | 2024.12.13 21:18:25.499051 [ 159555 ] {} <Debug> TCP-Session: fb686690-bd49-4ac8-afe3-66c513402dfb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 286 | 2024.12.13 21:18:25.499054 [ 159558 ] {} <Debug> TCP-Session: 99ff2aa9-fcbe-4245-81af-a4c4ef5e39e2 Authenticating user 'default' from [::1]:58190 | ||
| 287 | 2024.12.13 21:18:25.499061 [ 159558 ] {} <Debug> TCP-Session: 99ff2aa9-fcbe-4245-81af-a4c4ef5e39e2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2024.12.13 21:18:25.499067 [ 159558 ] {} <Debug> TCP-Session: 99ff2aa9-fcbe-4245-81af-a4c4ef5e39e2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 289 | 2024.12.13 21:18:25.501522 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} <Debug> executeQuery: (from [::1]:58174) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 290 | 2024.12.13 21:18:25.502934 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 291 | 2024.12.13 21:18:25.508279 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 292 | 2024.12.13 21:18:25.508311 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.6229e-05 sec | ||
| 293 | 2024.12.13 21:18:25.508320 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} <Trace> ReferentialDeps: No tables | ||
| 294 | 2024.12.13 21:18:25.508327 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} <Trace> LoadingDeps: No tables | ||
| 295 | 2024.12.13 21:18:25.508353 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 296 | 2024.12.13 21:18:25.508449 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} <Debug> TCPHandler: Processed in 0.009519448 sec. | ||
| 297 | 2024.12.13 21:18:25.509280 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 298 | 2024.12.13 21:18:25.509532 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} <Debug> executeQuery: (from [::1]:58176) /* The version table contains metadata about the `oximeter` database */ | ||
| 299 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 300 | 2024.12.13 21:18:25.509581 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 301 | 2024.12.13 21:18:25.515578 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} <Debug> oximeter.version (be4ed63e-651f-4062-8a60-0c2ddc363cbb): Loading data parts | ||
| 302 | 2024.12.13 21:18:25.515853 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} <Debug> oximeter.version (be4ed63e-651f-4062-8a60-0c2ddc363cbb): There are no data parts | ||
| 303 | 2024.12.13 21:18:25.520667 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} <Debug> TCPHandler: Processed in 0.011594129 sec. | ||
| 304 | 2024.12.13 21:18:25.521627 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 305 | 2024.12.13 21:18:25.522806 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} <Debug> executeQuery: (from [::1]:58174) /* The measurement tables contain all individual samples from each timeseries. | ||
| 306 | * | ||
| 307 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 308 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 309 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 310 | * by all samples from the same timeseries. | ||
| 311 | * | ||
| 312 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 313 | * and then uses that to index quickly into the measurements tables. | ||
| 314 | */ | ||
| 315 | 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) | ||
| 316 | 2024.12.13 21:18:25.522864 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 317 | 2024.12.13 21:18:25.527283 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} <Debug> oximeter.measurements_bool (b51b41fb-f5f1-40e3-8611-7fcf262d282d): Loading data parts | ||
| 318 | 2024.12.13 21:18:25.533924 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} <Debug> oximeter.measurements_bool (b51b41fb-f5f1-40e3-8611-7fcf262d282d): There are no data parts | ||
| 319 | 2024.12.13 21:18:25.540420 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} <Debug> TCPHandler: Processed in 0.018994026 sec. | ||
| 320 | 2024.12.13 21:18:25.541358 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 321 | 2024.12.13 21:18:25.541684 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} <Debug> executeQuery: (from [::1]:58176) 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) | ||
| 322 | 2024.12.13 21:18:25.541760 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 323 | 2024.12.13 21:18:25.548495 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} <Debug> oximeter.measurements_i8 (a6db089c-67c7-40dd-a256-a809bc841eec): Loading data parts | ||
| 324 | 2024.12.13 21:18:25.549139 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} <Debug> oximeter.measurements_i8 (a6db089c-67c7-40dd-a256-a809bc841eec): There are no data parts | ||
| 325 | 2024.12.13 21:18:25.553858 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} <Debug> TCPHandler: Processed in 0.01271446 sec. | ||
| 326 | 2024.12.13 21:18:25.556396 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 327 | 2024.12.13 21:18:25.562766 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} <Debug> executeQuery: (from [::1]:58174) 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) | ||
| 328 | 2024.12.13 21:18:25.562834 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 329 | 2024.12.13 21:18:25.567798 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} <Debug> oximeter.measurements_u8 (8463bc78-46b6-401b-b4e6-5a537085e186): Loading data parts | ||
| 330 | 2024.12.13 21:18:25.568722 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} <Debug> oximeter.measurements_u8 (8463bc78-46b6-401b-b4e6-5a537085e186): There are no data parts | ||
| 331 | 2024.12.13 21:18:25.573959 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} <Debug> TCPHandler: Processed in 0.017739885 sec. | ||
| 332 | 2024.12.13 21:18:25.574903 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 333 | 2024.12.13 21:18:25.575221 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} <Debug> executeQuery: (from [::1]:58176) 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) | ||
| 334 | 2024.12.13 21:18:25.575274 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 335 | 2024.12.13 21:18:25.581638 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} <Debug> oximeter.measurements_i16 (2740ca33-b2e6-497d-82d8-cb394e68e79f): Loading data parts | ||
| 336 | 2024.12.13 21:18:25.582002 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} <Debug> oximeter.measurements_i16 (2740ca33-b2e6-497d-82d8-cb394e68e79f): There are no data parts | ||
| 337 | 2024.12.13 21:18:25.588544 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} <Debug> TCPHandler: Processed in 0.013816321 sec. | ||
| 338 | 2024.12.13 21:18:25.589646 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 339 | 2024.12.13 21:18:25.589916 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} <Debug> executeQuery: (from [::1]:58174) 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) | ||
| 340 | 2024.12.13 21:18:25.589970 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 341 | 2024.12.13 21:18:25.595684 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} <Debug> oximeter.measurements_u16 (b6855f23-5c84-4637-b602-1a0c7ff6d484): Loading data parts | ||
| 342 | 2024.12.13 21:18:25.596140 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} <Debug> oximeter.measurements_u16 (b6855f23-5c84-4637-b602-1a0c7ff6d484): There are no data parts | ||
| 343 | 2024.12.13 21:18:25.599956 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} <Debug> TCPHandler: Processed in 0.010488058 sec. | ||
| 344 | 2024.12.13 21:18:25.600911 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 345 | 2024.12.13 21:18:25.601220 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} <Debug> executeQuery: (from [::1]:58176) 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) | ||
| 346 | 2024.12.13 21:18:25.601278 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 347 | 2024.12.13 21:18:25.607702 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} <Debug> oximeter.measurements_i32 (b8414e21-511c-461b-a161-bf2e2264c726): Loading data parts | ||
| 348 | 2024.12.13 21:18:25.608024 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} <Debug> oximeter.measurements_i32 (b8414e21-511c-461b-a161-bf2e2264c726): There are no data parts | ||
| 349 | 2024.12.13 21:18:25.612703 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} <Debug> TCPHandler: Processed in 0.01196944 sec. | ||
| 350 | 2024.12.13 21:18:25.613557 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 351 | 2024.12.13 21:18:25.613832 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} <Debug> executeQuery: (from [::1]:58174) 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) | ||
| 352 | 2024.12.13 21:18:25.613886 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 353 | 2024.12.13 21:18:25.622235 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} <Debug> oximeter.measurements_u32 (79d365ee-2dd8-4c99-952f-ef65aaec1968): Loading data parts | ||
| 354 | 2024.12.13 21:18:25.622549 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} <Debug> oximeter.measurements_u32 (79d365ee-2dd8-4c99-952f-ef65aaec1968): There are no data parts | ||
| 355 | 2024.12.13 21:18:25.628423 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} <Debug> TCPHandler: Processed in 0.015052342 sec. | ||
| 356 | 2024.12.13 21:18:25.629297 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 357 | 2024.12.13 21:18:25.629631 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} <Debug> executeQuery: (from [::1]:58176) 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) | ||
| 358 | 2024.12.13 21:18:25.629692 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 359 | 2024.12.13 21:18:25.637157 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} <Debug> oximeter.measurements_i64 (925d1041-4bc6-41c3-ae96-bb3b36318e7c): Loading data parts | ||
| 360 | 2024.12.13 21:18:25.637445 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} <Debug> oximeter.measurements_i64 (925d1041-4bc6-41c3-ae96-bb3b36318e7c): There are no data parts | ||
| 361 | 2024.12.13 21:18:25.644393 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} <Debug> TCPHandler: Processed in 0.015283172 sec. | ||
| 362 | 2024.12.13 21:18:25.645218 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 363 | 2024.12.13 21:18:25.645532 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} <Debug> executeQuery: (from [::1]:58174) 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) | ||
| 364 | 2024.12.13 21:18:25.645595 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 365 | 2024.12.13 21:18:25.651788 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} <Debug> oximeter.measurements_u64 (02767283-4b7c-4c2d-a87b-4993146b1158): Loading data parts | ||
| 366 | 2024.12.13 21:18:25.652073 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} <Debug> oximeter.measurements_u64 (02767283-4b7c-4c2d-a87b-4993146b1158): There are no data parts | ||
| 367 | 2024.12.13 21:18:25.655830 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} <Debug> TCPHandler: Processed in 0.010820509 sec. | ||
| 368 | 2024.12.13 21:18:25.659474 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 369 | 2024.12.13 21:18:25.659889 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} <Debug> executeQuery: (from [::1]:58176) 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) | ||
| 370 | 2024.12.13 21:18:25.661225 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 371 | 2024.12.13 21:18:25.667240 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} <Debug> oximeter.measurements_f32 (beb8106f-31e2-45eb-8d0d-e480b9c21685): Loading data parts | ||
| 372 | 2024.12.13 21:18:25.667600 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} <Debug> oximeter.measurements_f32 (beb8106f-31e2-45eb-8d0d-e480b9c21685): There are no data parts | ||
| 373 | 2024.12.13 21:18:25.671562 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} <Debug> TCPHandler: Processed in 0.01227049 sec. | ||
| 374 | 2024.12.13 21:18:25.672376 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 375 | 2024.12.13 21:18:25.672661 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} <Debug> executeQuery: (from [::1]:58174) 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) | ||
| 376 | 2024.12.13 21:18:25.672715 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 377 | 2024.12.13 21:18:25.679401 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} <Debug> oximeter.measurements_f64 (74cdcf0c-74f8-494f-9c2c-3c4e03610ff9): Loading data parts | ||
| 378 | 2024.12.13 21:18:25.679745 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} <Debug> oximeter.measurements_f64 (74cdcf0c-74f8-494f-9c2c-3c4e03610ff9): There are no data parts | ||
| 379 | 2024.12.13 21:18:25.684568 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} <Debug> TCPHandler: Processed in 0.01237903 sec. | ||
| 380 | 2024.12.13 21:18:25.685391 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 381 | 2024.12.13 21:18:25.685703 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} <Debug> executeQuery: (from [::1]:58176) 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) | ||
| 382 | 2024.12.13 21:18:25.687041 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 383 | 2024.12.13 21:18:25.692120 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} <Debug> oximeter.measurements_string (d77272e5-5b4e-4285-87b4-304adf39b1f8): Loading data parts | ||
| 384 | 2024.12.13 21:18:25.692409 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} <Debug> oximeter.measurements_string (d77272e5-5b4e-4285-87b4-304adf39b1f8): There are no data parts | ||
| 385 | 2024.12.13 21:18:25.696794 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} <Debug> TCPHandler: Processed in 0.011586539 sec. | ||
| 386 | 2024.12.13 21:18:25.698673 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 387 | 2024.12.13 21:18:25.699015 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 388 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 389 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 390 | * a string isn't palatable for a few reasons. | ||
| 391 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 392 | * details. | ||
| 393 | */ | ||
| 394 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 395 | 2024.12.13 21:18:25.699072 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 396 | 2024.12.13 21:18:25.704922 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} <Debug> oximeter.measurements_bytes (5050bdea-d7d7-4a2a-bf80-b80560174a6f): Loading data parts | ||
| 397 | 2024.12.13 21:18:25.705252 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} <Debug> oximeter.measurements_bytes (5050bdea-d7d7-4a2a-bf80-b80560174a6f): There are no data parts | ||
| 398 | 2024.12.13 21:18:25.709558 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} <Debug> TCPHandler: Processed in 0.011079999 sec. | ||
| 399 | 2024.12.13 21:18:25.710457 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 400 | 2024.12.13 21:18:25.710750 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} <Debug> executeQuery: (from [::1]:58176) 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) | ||
| 401 | 2024.12.13 21:18:25.710806 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 402 | 2024.12.13 21:18:25.717628 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} <Debug> oximeter.measurements_cumulativei64 (aaa0c3f8-617a-40fb-9de8-7332b22d3d24): Loading data parts | ||
| 403 | 2024.12.13 21:18:25.717930 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} <Debug> oximeter.measurements_cumulativei64 (aaa0c3f8-617a-40fb-9de8-7332b22d3d24): There are no data parts | ||
| 404 | 2024.12.13 21:18:25.723850 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} <Debug> TCPHandler: Processed in 0.013579681 sec. | ||
| 405 | 2024.12.13 21:18:25.724699 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 406 | 2024.12.13 21:18:25.726482 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} <Debug> executeQuery: (from [::1]:58174) 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) | ||
| 407 | 2024.12.13 21:18:25.726546 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 408 | 2024.12.13 21:18:25.732252 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} <Debug> oximeter.measurements_cumulativeu64 (ad5c098b-0edd-4a8d-bf4d-bcbb5d69ea42): Loading data parts | ||
| 409 | 2024.12.13 21:18:25.732505 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} <Debug> oximeter.measurements_cumulativeu64 (ad5c098b-0edd-4a8d-bf4d-bcbb5d69ea42): There are no data parts | ||
| 410 | 2024.12.13 21:18:25.737535 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} <Debug> TCPHandler: Processed in 0.013004691 sec. | ||
| 411 | 2024.12.13 21:18:25.738511 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 412 | 2024.12.13 21:18:25.738822 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} <Debug> executeQuery: (from [::1]:58176) 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) | ||
| 413 | 2024.12.13 21:18:25.738880 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 414 | 2024.12.13 21:18:25.745154 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} <Debug> oximeter.measurements_cumulativef32 (41043f24-7d4a-4934-a870-129028016fa6): Loading data parts | ||
| 415 | 2024.12.13 21:18:25.745485 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} <Debug> oximeter.measurements_cumulativef32 (41043f24-7d4a-4934-a870-129028016fa6): There are no data parts | ||
| 416 | 2024.12.13 21:18:25.749568 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} <Debug> TCPHandler: Processed in 0.011261549 sec. | ||
| 417 | 2024.12.13 21:18:25.785372 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 418 | 2024.12.13 21:18:25.785712 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} <Debug> executeQuery: (from [::1]:58174) 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) | ||
| 419 | 2024.12.13 21:18:25.785773 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 420 | 2024.12.13 21:18:25.791851 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} <Debug> oximeter.measurements_cumulativef64 (f59f9eb2-a3b1-4069-afb4-49164c8acb16): Loading data parts | ||
| 421 | 2024.12.13 21:18:25.793519 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} <Debug> oximeter.measurements_cumulativef64 (f59f9eb2-a3b1-4069-afb4-49164c8acb16): There are no data parts | ||
| 422 | 2024.12.13 21:18:25.797839 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} <Debug> TCPHandler: Processed in 0.012663371 sec. | ||
| 423 | 2024.12.13 21:18:25.807917 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 424 | 2024.12.13 21:18:25.808348 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 425 | * NOTE: Array types cannot be Nullable, see | ||
| 426 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 427 | * for more details. | ||
| 428 | * | ||
| 429 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 430 | * is unfortunate, and at this point relies on the fact that an | ||
| 431 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 432 | * to figure out another way to represent missing samples here. | ||
| 433 | */ | ||
| 434 | 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) | ||
| 435 | 2024.12.13 21:18:25.808426 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 436 | 2024.12.13 21:18:25.812731 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} <Debug> oximeter.measurements_histogrami8 (e4b2f145-1857-4bb7-9650-e7eb76a68198): Loading data parts | ||
| 437 | 2024.12.13 21:18:25.813024 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} <Debug> oximeter.measurements_histogrami8 (e4b2f145-1857-4bb7-9650-e7eb76a68198): There are no data parts | ||
| 438 | 2024.12.13 21:18:25.816640 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} <Debug> TCPHandler: Processed in 0.008916807 sec. | ||
| 439 | 2024.12.13 21:18:25.915372 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 440 | 2024.12.13 21:18:25.916248 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} <Debug> executeQuery: (from [::1]:58174) 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) | ||
| 441 | 2024.12.13 21:18:25.916317 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 442 | 2024.12.13 21:18:25.921713 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} <Debug> oximeter.measurements_histogramu8 (a7af3409-45e7-42b5-aa29-99e1de915fd6): Loading data parts | ||
| 443 | 2024.12.13 21:18:25.922014 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} <Debug> oximeter.measurements_histogramu8 (a7af3409-45e7-42b5-aa29-99e1de915fd6): There are no data parts | ||
| 444 | 2024.12.13 21:18:25.925791 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} <Debug> TCPHandler: Processed in 0.010613018 sec. | ||
| 445 | 2024.12.13 21:18:26.000406 [ 158184 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 403.92 MiB, peak 403.92 MiB, free memory in arenas 26.23 MiB, will set to 401.48 MiB (RSS), difference: -2.43 MiB | ||
| 446 | 2024.12.13 21:18:26.439119 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 447 | 2024.12.13 21:18:26.443300 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 448 | 2024.12.13 21:18:26.443379 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 449 | 2024.12.13 21:18:26.448360 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} <Debug> oximeter.measurements_histogrami16 (29317412-128c-464f-a8e7-deddfe77f369): Loading data parts | ||
| 450 | 2024.12.13 21:18:26.448634 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} <Debug> oximeter.measurements_histogrami16 (29317412-128c-464f-a8e7-deddfe77f369): There are no data parts | ||
| 451 | 2024.12.13 21:18:26.452176 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} <Debug> TCPHandler: Processed in 0.013265721 sec. | ||
| 452 | 2024.12.13 21:18:26.473831 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 453 | 2024.12.13 21:18:26.474193 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 454 | 2024.12.13 21:18:26.474257 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 455 | 2024.12.13 21:18:26.479252 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} <Debug> oximeter.measurements_histogramu16 (85deb8a0-a48a-4a1b-811e-fc2158f013c3): Loading data parts | ||
| 456 | 2024.12.13 21:18:26.481595 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} <Debug> oximeter.measurements_histogramu16 (85deb8a0-a48a-4a1b-811e-fc2158f013c3): There are no data parts | ||
| 457 | 2024.12.13 21:18:26.495853 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} <Debug> TCPHandler: Processed in 0.022206798 sec. | ||
| 458 | 2024.12.13 21:18:26.516300 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 459 | 2024.12.13 21:18:26.516625 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 460 | 2024.12.13 21:18:26.516692 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 461 | 2024.12.13 21:18:26.523007 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} <Debug> oximeter.measurements_histogrami32 (b96d424b-7177-4d3e-b553-a851f6322d39): Loading data parts | ||
| 462 | 2024.12.13 21:18:26.523293 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} <Debug> oximeter.measurements_histogrami32 (b96d424b-7177-4d3e-b553-a851f6322d39): There are no data parts | ||
| 463 | 2024.12.13 21:18:26.528758 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} <Debug> TCPHandler: Processed in 0.01253537 sec. | ||
| 464 | 2024.12.13 21:18:26.580602 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 465 | 2024.12.13 21:18:26.581036 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 466 | 2024.12.13 21:18:26.587167 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 467 | 2024.12.13 21:18:26.594676 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} <Debug> oximeter.measurements_histogramu32 (9eef532d-6a46-4c33-bd80-25e6141e29a3): Loading data parts | ||
| 468 | 2024.12.13 21:18:26.594954 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} <Debug> oximeter.measurements_histogramu32 (9eef532d-6a46-4c33-bd80-25e6141e29a3): There are no data parts | ||
| 469 | 2024.12.13 21:18:26.599732 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} <Debug> TCPHandler: Processed in 0.019261126 sec. | ||
| 470 | 2024.12.13 21:18:26.606046 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 471 | 2024.12.13 21:18:26.606407 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 472 | 2024.12.13 21:18:26.606467 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 473 | 2024.12.13 21:18:26.613064 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} <Debug> oximeter.measurements_histogrami64 (2b2d14ca-cd06-468b-853e-56c42c09448d): Loading data parts | ||
| 474 | 2024.12.13 21:18:26.617264 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} <Debug> oximeter.measurements_histogrami64 (2b2d14ca-cd06-468b-853e-56c42c09448d): There are no data parts | ||
| 475 | 2024.12.13 21:18:26.623052 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} <Debug> TCPHandler: Processed in 0.017091403 sec. | ||
| 476 | 2024.12.13 21:18:26.628736 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 477 | 2024.12.13 21:18:26.629033 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 478 | 2024.12.13 21:18:26.629078 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 479 | 2024.12.13 21:18:26.644995 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} <Debug> oximeter.measurements_histogramu64 (002bd09d-9269-4d3c-9ab5-09d1f1e69b84): Loading data parts | ||
| 480 | 2024.12.13 21:18:26.645249 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} <Debug> oximeter.measurements_histogramu64 (002bd09d-9269-4d3c-9ab5-09d1f1e69b84): There are no data parts | ||
| 481 | 2024.12.13 21:18:26.655281 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} <Debug> TCPHandler: Processed in 0.026638822 sec. | ||
| 482 | 2024.12.13 21:18:26.661209 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 483 | 2024.12.13 21:18:26.661611 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 484 | 2024.12.13 21:18:26.661676 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 485 | 2024.12.13 21:18:26.667490 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} <Debug> oximeter.measurements_histogramf32 (24a3a243-1bb6-4677-9ff1-d8d11e85ef36): Loading data parts | ||
| 486 | 2024.12.13 21:18:26.672671 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} <Debug> oximeter.measurements_histogramf32 (24a3a243-1bb6-4677-9ff1-d8d11e85ef36): There are no data parts | ||
| 487 | 2024.12.13 21:18:26.678510 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} <Debug> TCPHandler: Processed in 0.017467304 sec. | ||
| 488 | 2024.12.13 21:18:26.679126 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 489 | 2024.12.13 21:18:26.679434 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 490 | 2024.12.13 21:18:26.679489 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 491 | 2024.12.13 21:18:26.690534 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} <Debug> oximeter.measurements_histogramf64 (b4e3c083-71a1-4ca1-bf13-c69588b8fe4b): Loading data parts | ||
| 492 | 2024.12.13 21:18:26.690985 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} <Debug> oximeter.measurements_histogramf64 (b4e3c083-71a1-4ca1-bf13-c69588b8fe4b): There are no data parts | ||
| 493 | 2024.12.13 21:18:26.703715 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} <Debug> TCPHandler: Processed in 0.02466589 sec. | ||
| 494 | 2024.12.13 21:18:26.704805 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 495 | 2024.12.13 21:18:26.706596 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} <Debug> executeQuery: (from [::1]:58176) /* The field tables store named dimensions of each timeseries. | ||
| 496 | * | ||
| 497 | * As with the measurement tables, there is one field table for each field data | ||
| 498 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 499 | * this behavior **must not** be relied upon for query correctness. | ||
| 500 | * | ||
| 501 | * The index for the fields differs from the measurements, however. Rows are | ||
| 502 | * sorted by timeseries name, then field name, field value, and finally | ||
| 503 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 504 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 505 | * usually then used to look up measurements. | ||
| 506 | * | ||
| 507 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 508 | * timeseries name and then key, since it would improve lookups where one | ||
| 509 | * already has the key. Realistically though, these tables are quite small and | ||
| 510 | * so performance benefits will be low in absolute terms. | ||
| 511 | * | ||
| 512 | * TTL: We use a materialized column to expire old field table records. This | ||
| 513 | * column is generated automatically by the database whenever a new row is | ||
| 514 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 515 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 516 | * record will remain during a deduplication, which will have the last | ||
| 517 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 518 | * measurement tables. | ||
| 519 | */ | ||
| 520 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 521 | 2024.12.13 21:18:26.706657 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 522 | 2024.12.13 21:18:26.713911 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} <Debug> oximeter.fields_bool (ba587e66-cf30-435e-843b-845f70132169): Loading data parts | ||
| 523 | 2024.12.13 21:18:26.714231 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} <Debug> oximeter.fields_bool (ba587e66-cf30-435e-843b-845f70132169): There are no data parts | ||
| 524 | 2024.12.13 21:18:26.719260 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} <Debug> TCPHandler: Processed in 0.014607712 sec. | ||
| 525 | 2024.12.13 21:18:26.720120 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 526 | 2024.12.13 21:18:26.720383 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 527 | 2024.12.13 21:18:26.720431 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 528 | 2024.12.13 21:18:26.726274 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} <Debug> oximeter.fields_i8 (bbabfe2f-d40d-4e0e-b4d7-8f126e47ab5d): Loading data parts | ||
| 529 | 2024.12.13 21:18:26.726528 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} <Debug> oximeter.fields_i8 (bbabfe2f-d40d-4e0e-b4d7-8f126e47ab5d): There are no data parts | ||
| 530 | 2024.12.13 21:18:26.732662 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} <Debug> TCPHandler: Processed in 0.01265099 sec. | ||
| 531 | 2024.12.13 21:18:26.733957 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 532 | 2024.12.13 21:18:26.734696 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 533 | 2024.12.13 21:18:26.734746 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 534 | 2024.12.13 21:18:26.739854 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} <Debug> oximeter.fields_u8 (3bd102d6-9b09-42db-8c12-e7dffc9e0255): Loading data parts | ||
| 535 | 2024.12.13 21:18:26.740439 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} <Debug> oximeter.fields_u8 (3bd102d6-9b09-42db-8c12-e7dffc9e0255): There are no data parts | ||
| 536 | 2024.12.13 21:18:26.749304 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} <Debug> TCPHandler: Processed in 0.015447492 sec. | ||
| 537 | 2024.12.13 21:18:26.750025 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 538 | 2024.12.13 21:18:26.752364 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 539 | 2024.12.13 21:18:26.752422 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 540 | 2024.12.13 21:18:26.758075 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} <Debug> oximeter.fields_i16 (812dcf75-3c8e-4362-84fe-70d4bde628e4): Loading data parts | ||
| 541 | 2024.12.13 21:18:26.758595 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} <Debug> oximeter.fields_i16 (812dcf75-3c8e-4362-84fe-70d4bde628e4): There are no data parts | ||
| 542 | 2024.12.13 21:18:26.768749 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} <Debug> TCPHandler: Processed in 0.018828075 sec. | ||
| 543 | 2024.12.13 21:18:26.769552 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 544 | 2024.12.13 21:18:26.769841 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 545 | 2024.12.13 21:18:26.769895 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 546 | 2024.12.13 21:18:26.777379 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} <Debug> oximeter.fields_u16 (bd3dae6b-c364-489a-89d1-4baf100f04e6): Loading data parts | ||
| 547 | 2024.12.13 21:18:26.781981 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} <Debug> oximeter.fields_u16 (bd3dae6b-c364-489a-89d1-4baf100f04e6): There are no data parts | ||
| 548 | 2024.12.13 21:18:26.790405 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} <Debug> TCPHandler: Processed in 0.020959347 sec. | ||
| 549 | 2024.12.13 21:18:26.791049 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 550 | 2024.12.13 21:18:26.791295 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 551 | 2024.12.13 21:18:26.791342 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 552 | 2024.12.13 21:18:26.799517 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} <Debug> oximeter.fields_i32 (38bf6fe5-1255-4c7d-b183-fe95999f997b): Loading data parts | ||
| 553 | 2024.12.13 21:18:26.800038 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} <Debug> oximeter.fields_i32 (38bf6fe5-1255-4c7d-b183-fe95999f997b): There are no data parts | ||
| 554 | 2024.12.13 21:18:26.808462 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} <Debug> TCPHandler: Processed in 0.017491144 sec. | ||
| 555 | 2024.12.13 21:18:26.809125 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 556 | 2024.12.13 21:18:26.809693 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 557 | 2024.12.13 21:18:26.810921 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 558 | 2024.12.13 21:18:26.816831 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} <Debug> oximeter.fields_u32 (41f8b545-eeec-4cf1-88d6-b0c1e6397faf): Loading data parts | ||
| 559 | 2024.12.13 21:18:26.819084 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} <Debug> oximeter.fields_u32 (41f8b545-eeec-4cf1-88d6-b0c1e6397faf): There are no data parts | ||
| 560 | 2024.12.13 21:18:26.828773 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} <Debug> TCPHandler: Processed in 0.019730476 sec. | ||
| 561 | 2024.12.13 21:18:26.829479 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 562 | 2024.12.13 21:18:26.829732 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 563 | 2024.12.13 21:18:26.829786 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 564 | 2024.12.13 21:18:26.838433 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} <Debug> oximeter.fields_i64 (7107145a-df41-4305-9a27-b74b1f53cb63): Loading data parts | ||
| 565 | 2024.12.13 21:18:26.841815 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} <Debug> oximeter.fields_i64 (7107145a-df41-4305-9a27-b74b1f53cb63): There are no data parts | ||
| 566 | 2024.12.13 21:18:26.847702 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} <Debug> TCPHandler: Processed in 0.018344384 sec. | ||
| 567 | 2024.12.13 21:18:26.848344 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 568 | 2024.12.13 21:18:26.848559 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 569 | 2024.12.13 21:18:26.848601 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 570 | 2024.12.13 21:18:26.854996 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} <Debug> oximeter.fields_u64 (6f71ebd2-3e00-4751-b9e0-33dba0c95de5): Loading data parts | ||
| 571 | 2024.12.13 21:18:26.855372 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} <Debug> oximeter.fields_u64 (6f71ebd2-3e00-4751-b9e0-33dba0c95de5): There are no data parts | ||
| 572 | 2024.12.13 21:18:26.862638 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} <Debug> TCPHandler: Processed in 0.014379941 sec. | ||
| 573 | 2024.12.13 21:18:26.863384 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 574 | 2024.12.13 21:18:26.863644 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 575 | 2024.12.13 21:18:26.863698 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 576 | 2024.12.13 21:18:26.876881 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} <Debug> oximeter.fields_ipaddr (a817c0b2-352d-46f5-b0c0-ffacef4ae20b): Loading data parts | ||
| 577 | 2024.12.13 21:18:26.877163 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} <Debug> oximeter.fields_ipaddr (a817c0b2-352d-46f5-b0c0-ffacef4ae20b): There are no data parts | ||
| 578 | 2024.12.13 21:18:26.890760 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} <Debug> TCPHandler: Processed in 0.027527262 sec. | ||
| 579 | 2024.12.13 21:18:26.891539 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 580 | 2024.12.13 21:18:26.893565 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} <Debug> executeQuery: (from [::1]:58176) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 581 | 2024.12.13 21:18:26.893622 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 582 | 2024.12.13 21:18:26.899851 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} <Debug> oximeter.fields_string (7250caeb-794c-43f6-8cf4-6618ee28eba0): Loading data parts | ||
| 583 | 2024.12.13 21:18:26.901220 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} <Debug> oximeter.fields_string (7250caeb-794c-43f6-8cf4-6618ee28eba0): There are no data parts | ||
| 584 | 2024.12.13 21:18:26.906692 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} <Debug> TCPHandler: Processed in 0.015274063 sec. | ||
| 585 | 2024.12.13 21:18:26.907485 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 586 | 2024.12.13 21:18:26.907753 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} <Debug> executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 587 | 2024.12.13 21:18:26.907802 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 588 | 2024.12.13 21:18:26.913961 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} <Debug> oximeter.fields_uuid (57e72ffe-7c2d-48a9-9887-28eb1675f0b4): Loading data parts | ||
| 589 | 2024.12.13 21:18:26.917130 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} <Debug> oximeter.fields_uuid (57e72ffe-7c2d-48a9-9887-28eb1675f0b4): There are no data parts | ||
| 590 | 2024.12.13 21:18:26.925259 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} <Debug> TCPHandler: Processed in 0.018007755 sec. | ||
| 591 | 2024.12.13 21:18:26.926027 [ 159552 ] {} <Trace> TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 592 | 2024.12.13 21:18:26.926326 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} <Debug> executeQuery: (from [::1]:58176) /* The timeseries schema table stores the extracted schema for the samples | ||
| 593 | * oximeter collects. | ||
| 594 | */ | ||
| 595 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
| 596 | 2024.12.13 21:18:26.927771 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 597 | 2024.12.13 21:18:26.933490 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} <Debug> oximeter.timeseries_schema (9958e62e-3f65-4986-8574-71a38cde4102): Loading data parts | ||
| 598 | 2024.12.13 21:18:26.933774 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} <Debug> oximeter.timeseries_schema (9958e62e-3f65-4986-8574-71a38cde4102): There are no data parts | ||
| 599 | 2024.12.13 21:18:26.939817 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} <Debug> TCPHandler: Processed in 0.013872682 sec. | ||
| 600 | 2024.12.13 21:18:26.941642 [ 159551 ] {} <Trace> TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 601 | 2024.12.13 21:18:26.944085 [ 159551 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} <Debug> executeQuery: (from [::1]:58174) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 602 | 2024.12.13 21:18:26.944174 [ 159551 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 603 | 2024.12.13 21:18:26.944914 [ 159522 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} <Trace> oximeter.version (be4ed63e-651f-4062-8a60-0c2ddc363cbb): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 604 | 2024.12.13 21:18:26.946343 [ 159522 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.22 GiB. | ||
| 605 | 2024.12.13 21:18:26.946729 [ 159522 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 606 | 2024.12.13 21:18:26.990566 [ 159522 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} <Trace> oximeter.version (be4ed63e-651f-4062-8a60-0c2ddc363cbb): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 607 | 2024.12.13 21:18:26.990821 [ 159551 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.046772 sec., 21.380313007782433 rows/sec., 342.09 B/sec. | ||
| 608 | 2024.12.13 21:18:26.991004 [ 159551 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} <Debug> TCPHandler: Processed in 0.04943923 sec. | ||
| 609 | 2024.12.13 21:18:27.001124 [ 158184 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 403.09 MiB, peak 403.92 MiB, free memory in arenas 20.64 MiB, will set to 404.33 MiB (RSS), difference: 1.24 MiB | ||
| 610 | 2024.12.13 21:18:27.755342 [ 157696 ] {} <Trace> TCP-Session: 7d777e19-271c-49bf-b88c-bbb86ec5f145 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 611 | 2024.12.13 21:18:27.755628 [ 157696 ] {c8a408ef-a57f-4faf-898e-6dbbec237849} <Debug> executeQuery: (from [::1]:58154) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) | ||
| 612 | 2024.12.13 21:18:27.756872 [ 157696 ] {c8a408ef-a57f-4faf-898e-6dbbec237849} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
| 613 | 2024.12.13 21:18:27.756925 [ 157696 ] {c8a408ef-a57f-4faf-898e-6dbbec237849} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 614 | 2024.12.13 21:18:27.757507 [ 157696 ] {c8a408ef-a57f-4faf-898e-6dbbec237849} <Debug> TCPHandler: Processed in 0.002385781 sec. | ||
| 615 | 2024.12.13 21:18:28.000531 [ 158184 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 406.38 MiB, peak 406.38 MiB, free memory in arenas 19.06 MiB, will set to 404.78 MiB (RSS), difference: -1.60 MiB | ||