2024.12.13 21:18:14.251578 [ 157693 ] {} SentryWriter: Sending crash reports is disabled 2024.12.13 21:18:14.251649 [ 157693 ] {} Pipe: Pipe capacity is 1.00 MiB 2024.12.13 21:18:14.302825 [ 157693 ] {} Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 157693 2024.12.13 21:18:14.302871 [ 157693 ] {} Application: starting up 2024.12.13 21:18:14.302885 [ 157693 ] {} Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64 2024.12.13 21:18:14.305495 [ 157693 ] {} Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8. 2024.12.13 21:18:14.322652 [ 157693 ] {} AsynchronousMetrics: Scanning /sys/class/thermal 2024.12.13 21:18:14.328574 [ 157693 ] {} AsynchronousMetrics: Scanning /sys/block 2024.12.13 21:18:14.328661 [ 157693 ] {} AsynchronousMetrics: Scanning /sys/devices/system/edac 2024.12.13 21:18:14.328701 [ 157693 ] {} AsynchronousMetrics: Scanning /sys/class/hwmon 2024.12.13 21:18:14.691892 [ 157693 ] {} Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF) 2024.12.13 21:18:14.691943 [ 157693 ] {} 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. 2024.12.13 21:18:14.699591 [ 157693 ] {} Application: Set max number of file descriptors to 524288 (was 1024). 2024.12.13 21:18:14.699617 [ 157693 ] {} Application: rlimit on number of threads is 125612 2024.12.13 21:18:14.699625 [ 157693 ] {} Application: Initializing DateLUT. 2024.12.13 21:18:14.699630 [ 157693 ] {} Application: Initialized DateLUT with time zone 'UTC'. 2024.12.13 21:18:14.699653 [ 157693 ] {} 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 2024.12.13 21:18:14.700000 [ 157693 ] {} Application: Initializing interserver credentials. 2024.12.13 21:18:14.700428 [ 157693 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml' 2024.12.13 21:18:14.701941 [ 157693 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml', performing update on configuration 2024.12.13 21:18:14.702482 [ 157693 ] {} 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) 2024.12.13 21:18:14.703418 [ 157693 ] {} 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) 2024.12.13 21:18:14.703428 [ 157693 ] {} Application: Merges and mutations memory limit is set to 15.34 GiB 2024.12.13 21:18:14.703500 [ 157693 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.13 21:18:14.717112 [ 157693 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.12.13 21:18:14.722416 [ 157693 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.13 21:18:14.723388 [ 157693 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.13 21:18:14.723930 [ 157693 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.13 21:18:14.724961 [ 157693 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml', performed update on configuration 2024.12.13 21:18:14.739555 [ 157693 ] {} ConfigReloader: Loading config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml' 2024.12.13 21:18:14.740097 [ 157693 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml', performing update on configuration 2024.12.13 21:18:14.740943 [ 157693 ] {} ConfigReloader: Loaded config '/var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/config.xml', performed update on configuration 2024.12.13 21:18:14.743594 [ 157693 ] {} 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 2024.12.13 21:18:14.780952 [ 157693 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.12.13 21:18:14.806466 [ 157693 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.12.13 21:18:14.806830 [ 157693 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.12.13 21:18:14.807135 [ 157693 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.12.13 21:18:14.825419 [ 157693 ] {} DNSCacheUpdater: Update period 15 seconds 2024.12.13 21:18:14.825470 [ 157693 ] {} Application: Loading metadata from /var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/datastore/ 2024.12.13 21:18:14.825535 [ 157707 ] {} DNSResolver: Updating DNS cache 2024.12.13 21:18:14.825752 [ 157707 ] {} DNSResolver: Updated DNS cache 2024.12.13 21:18:14.840191 [ 157693 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.12.13 21:18:14.840217 [ 157693 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000133691 sec 2024.12.13 21:18:14.840222 [ 157693 ] {} ReferentialDeps: No tables 2024.12.13 21:18:14.840227 [ 157693 ] {} LoadingDeps: No tables 2024.12.13 21:18:14.840265 [ 157693 ] {} DatabaseAtomic (system): Starting up tables. 2024.12.13 21:18:14.840285 [ 157693 ] {} SystemLog: Creating system.query_log from query_log 2024.12.13 21:18:14.841973 [ 157693 ] {} SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config 2024.12.13 21:18:14.841989 [ 157693 ] {} SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config 2024.12.13 21:18:14.841997 [ 157693 ] {} SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config 2024.12.13 21:18:14.842004 [ 157693 ] {} SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config 2024.12.13 21:18:14.842011 [ 157693 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.12.13 21:18:14.842019 [ 157693 ] {} SystemLog: Creating system.metric_log from metric_log 2024.12.13 21:18:14.846193 [ 157693 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.12.13 21:18:14.846213 [ 157693 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.12.13 21:18:14.846223 [ 157693 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.12.13 21:18:14.846440 [ 157693 ] {} SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config 2024.12.13 21:18:14.846455 [ 157693 ] {} SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config 2024.12.13 21:18:14.846462 [ 157693 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.12.13 21:18:14.846469 [ 157693 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.12.13 21:18:14.846476 [ 157693 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.12.13 21:18:14.846483 [ 157693 ] {} SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config 2024.12.13 21:18:14.846490 [ 157693 ] {} SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config 2024.12.13 21:18:14.866046 [ 157693 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.12.13 21:18:14.877367 [ 157693 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.12.13 21:18:14.877396 [ 157693 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.297e-05 sec 2024.12.13 21:18:14.877404 [ 157693 ] {} ReferentialDeps: No tables 2024.12.13 21:18:14.877410 [ 157693 ] {} LoadingDeps: No tables 2024.12.13 21:18:14.877439 [ 157693 ] {} DatabaseAtomic (default): Starting up tables. 2024.12.13 21:18:14.877589 [ 157693 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-8d56dd55232261ef-test_mgs_metrics.157603.1-clickhouse-VvroXz/datastore/user_defined/ 2024.12.13 21:18:14.877626 [ 157693 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.12.13 21:18:14.877633 [ 157693 ] {} Application: Loaded metadata. 2024.12.13 21:18:14.877656 [ 157693 ] {} Application: Tasks stats provider: procfs 2024.12.13 21:18:14.877663 [ 157693 ] {} 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. 2024.12.13 21:18:14.877750 [ 157693 ] {} Application: Requested any available port (port == 0), actual port is 42229 2024.12.13 21:18:14.877804 [ 157693 ] {} Application: Requested any available port (port == 0), actual port is 40789 2024.12.13 21:18:14.877973 [ 157693 ] {} Application: Requested any available port (port == 0), actual port is 33805 2024.12.13 21:18:14.878014 [ 157693 ] {} Application: Requested any available port (port == 0), actual port is 43283 2024.12.13 21:18:14.878036 [ 157693 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.13 21:18:14.878525 [ 157693 ] {} 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 2024.12.13 21:18:14.882439 [ 157693 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 1.952e-05 sec. 2024.12.13 21:18:14.882791 [ 157693 ] {} Application: Listening for http://[::1]:42229 2024.12.13 21:18:14.882852 [ 157693 ] {} Application: Listening for native protocol (tcp): [::1]:40789 2024.12.13 21:18:14.882899 [ 157693 ] {} Application: Listening for http://127.0.0.1:33805 2024.12.13 21:18:14.882940 [ 157693 ] {} Application: Listening for native protocol (tcp): 127.0.0.1:43283 2024.12.13 21:18:14.882948 [ 157693 ] {} Application: Ready for connections. 2024.12.13 21:18:15.790527 [ 157696 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58154 2024.12.13 21:18:15.790725 [ 157696 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:15.790767 [ 157696 ] {} TCP-Session: 7d777e19-271c-49bf-b88c-bbb86ec5f145 Authenticating user 'default' from [::1]:58154 2024.12.13 21:18:15.790784 [ 157696 ] {} TCP-Session: 7d777e19-271c-49bf-b88c-bbb86ec5f145 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.790790 [ 157696 ] {} TCP-Session: 7d777e19-271c-49bf-b88c-bbb86ec5f145 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.790872 [ 157696 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.13 21:18:15.790898 [ 157696 ] {} 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 2024.12.13 21:18:15.790906 [ 157696 ] {} 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 2024.12.13 21:18:15.795081 [ 157697 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58156 2024.12.13 21:18:15.795292 [ 157698 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58158 2024.12.13 21:18:15.796998 [ 157697 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:15.797032 [ 157697 ] {} TCP-Session: 73d18c5a-355d-4c72-ad75-354017a1932e Authenticating user 'default' from [::1]:58156 2024.12.13 21:18:15.797049 [ 157697 ] {} TCP-Session: 73d18c5a-355d-4c72-ad75-354017a1932e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.797056 [ 157697 ] {} TCP-Session: 73d18c5a-355d-4c72-ad75-354017a1932e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.798059 [ 157698 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:15.798229 [ 157698 ] {} TCP-Session: a41cf591-7a6e-45e9-8a88-c44c1d5d3e74 Authenticating user 'default' from [::1]:58158 2024.12.13 21:18:15.798248 [ 157698 ] {} TCP-Session: a41cf591-7a6e-45e9-8a88-c44c1d5d3e74 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.798256 [ 157698 ] {} TCP-Session: a41cf591-7a6e-45e9-8a88-c44c1d5d3e74 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.827033 [ 158358 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58160 2024.12.13 21:18:15.827032 [ 158363 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58164 2024.12.13 21:18:15.827198 [ 158363 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:15.827269 [ 158358 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:15.828517 [ 158358 ] {} TCP-Session: 0a82b362-8ab4-434e-91da-bc33ed3a24aa Authenticating user 'default' from [::1]:58160 2024.12.13 21:18:15.828554 [ 158358 ] {} TCP-Session: 0a82b362-8ab4-434e-91da-bc33ed3a24aa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.828561 [ 158358 ] {} TCP-Session: 0a82b362-8ab4-434e-91da-bc33ed3a24aa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.828961 [ 158363 ] {} TCP-Session: 06134f7c-dcb2-4538-aaba-f5026993830b Authenticating user 'default' from [::1]:58164 2024.12.13 21:18:15.828976 [ 158363 ] {} TCP-Session: 06134f7c-dcb2-4538-aaba-f5026993830b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.828983 [ 158363 ] {} TCP-Session: 06134f7c-dcb2-4538-aaba-f5026993830b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.827306 [ 158365 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58166 2024.12.13 21:18:15.827346 [ 158368 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58168 2024.12.13 21:18:15.827398 [ 158364 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58162 2024.12.13 21:18:15.829206 [ 158365 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:15.830521 [ 158365 ] {} TCP-Session: d7a68c9a-9999-410b-92a8-bf64be6180b5 Authenticating user 'default' from [::1]:58166 2024.12.13 21:18:15.830534 [ 158365 ] {} TCP-Session: d7a68c9a-9999-410b-92a8-bf64be6180b5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.830541 [ 158365 ] {} TCP-Session: d7a68c9a-9999-410b-92a8-bf64be6180b5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.830611 [ 158364 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:15.830634 [ 158364 ] {} TCP-Session: b41a892a-f720-4f00-8cf7-a9b3d9d6992a Authenticating user 'default' from [::1]:58162 2024.12.13 21:18:15.830643 [ 158364 ] {} TCP-Session: b41a892a-f720-4f00-8cf7-a9b3d9d6992a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.830648 [ 158364 ] {} TCP-Session: b41a892a-f720-4f00-8cf7-a9b3d9d6992a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.830695 [ 158368 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:15.830721 [ 158368 ] {} TCP-Session: 013e17c0-e302-467d-8741-5263471c6094 Authenticating user 'default' from [::1]:58168 2024.12.13 21:18:15.830731 [ 158368 ] {} TCP-Session: 013e17c0-e302-467d-8741-5263471c6094 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:15.830737 [ 158368 ] {} TCP-Session: 013e17c0-e302-467d-8741-5263471c6094 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:22.348323 [ 158124 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 1960 entries to flush up to offset 1960 2024.12.13 21:18:22.348387 [ 158124 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.12.13 21:18:22.349144 [ 158123 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 2024.12.13 21:18:22.349194 [ 158123 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.12.13 21:18:22.351011 [ 158124 ] {} StoragePolicy (default): Storage policy default created, total volumes 1 2024.12.13 21:18:22.359725 [ 158124 ] {} system.asynchronous_metric_log (af8332b9-01a9-4123-89c9-2f959110a6f3): Loading data parts 2024.12.13 21:18:22.366691 [ 158124 ] {} system.asynchronous_metric_log (af8332b9-01a9-4123-89c9-2f959110a6f3): There are no data parts 2024.12.13 21:18:22.373223 [ 158124 ] {} system.asynchronous_metric_log (af8332b9-01a9-4123-89c9-2f959110a6f3): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.13 21:18:22.373257 [ 158124 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.24 GiB. 2024.12.13 21:18:22.374052 [ 158124 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.13 21:18:22.374252 [ 158124 ] {} 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). 2024.12.13 21:18:22.374415 [ 158124 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 1960 2024.12.13 21:18:22.391979 [ 158123 ] {} system.metric_log (ee510121-94f3-49b2-afa0-1733ea60203b): Loading data parts 2024.12.13 21:18:22.392291 [ 158123 ] {} system.metric_log (ee510121-94f3-49b2-afa0-1733ea60203b): There are no data parts 2024.12.13 21:18:22.452619 [ 158123 ] {} system.metric_log (ee510121-94f3-49b2-afa0-1733ea60203b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.13 21:18:22.452666 [ 158123 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.24 GiB. 2024.12.13 21:18:22.512173 [ 158123 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.13 21:18:22.513734 [ 158123 ] {} 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). 2024.12.13 21:18:22.516002 [ 158123 ] {} SystemLog (system.metric_log): Flushed system log up to offset 8 2024.12.13 21:18:23.000465 [ 158184 ] {} 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 2024.12.13 21:18:25.482167 [ 159551 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58174 2024.12.13 21:18:25.482268 [ 159551 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.482291 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Authenticating user 'default' from [::1]:58174 2024.12.13 21:18:25.482307 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.482313 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.484123 [ 159554 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58182 2024.12.13 21:18:25.484321 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.489180 [ 159554 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.490290 [ 159554 ] {} TCP-Session: 2a4fc627-bc92-4402-9afe-b4c6c9237358 Authenticating user 'default' from [::1]:58182 2024.12.13 21:18:25.490307 [ 159554 ] {} TCP-Session: 2a4fc627-bc92-4402-9afe-b4c6c9237358 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.490314 [ 159554 ] {} TCP-Session: 2a4fc627-bc92-4402-9afe-b4c6c9237358 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.489793 [ 159556 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58186 2024.12.13 21:18:25.490470 [ 159556 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.490494 [ 159556 ] {} TCP-Session: ec137411-2e7b-41e7-81ae-380732445bb2 Authenticating user 'default' from [::1]:58186 2024.12.13 21:18:25.490501 [ 159556 ] {} TCP-Session: ec137411-2e7b-41e7-81ae-380732445bb2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.490506 [ 159556 ] {} TCP-Session: ec137411-2e7b-41e7-81ae-380732445bb2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.490640 [ 159559 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58192 2024.12.13 21:18:25.490723 [ 159559 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.490743 [ 159559 ] {} TCP-Session: 8030a1d7-70e1-47ab-b639-309c3feb61b0 Authenticating user 'default' from [::1]:58192 2024.12.13 21:18:25.490751 [ 159559 ] {} TCP-Session: 8030a1d7-70e1-47ab-b639-309c3feb61b0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.490756 [ 159559 ] {} TCP-Session: 8030a1d7-70e1-47ab-b639-309c3feb61b0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.489804 [ 159552 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58176 2024.12.13 21:18:25.490895 [ 159552 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.490926 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Authenticating user 'default' from [::1]:58176 2024.12.13 21:18:25.490937 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.490944 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.491089 [ 159551 ] {205213f2-3993-4620-906b-af2fe6c0ebf1} executeQuery: (from [::1]:58174) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.12.13 21:18:25.490112 [ 159553 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58178 2024.12.13 21:18:25.492475 [ 159553 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.492501 [ 159553 ] {} TCP-Session: c5881f14-6d36-4094-9c46-51cd397241cc Authenticating user 'default' from [::1]:58178 2024.12.13 21:18:25.492512 [ 159553 ] {} TCP-Session: c5881f14-6d36-4094-9c46-51cd397241cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.492519 [ 159553 ] {} TCP-Session: c5881f14-6d36-4094-9c46-51cd397241cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.490059 [ 159557 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58188 2024.12.13 21:18:25.492654 [ 159557 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.492676 [ 159557 ] {} TCP-Session: d3773d18-5281-4657-aaaa-21523e948ce6 Authenticating user 'default' from [::1]:58188 2024.12.13 21:18:25.492686 [ 159557 ] {} TCP-Session: d3773d18-5281-4657-aaaa-21523e948ce6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.492691 [ 159557 ] {} TCP-Session: d3773d18-5281-4657-aaaa-21523e948ce6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.493710 [ 159551 ] {205213f2-3993-4620-906b-af2fe6c0ebf1} 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): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 7. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 9. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. ? @ 0x00007ff3e48f3ac3 in ? 17. ? @ 0x00007ff3e4985850 in ? 2024.12.13 21:18:25.495818 [ 159551 ] {205213f2-3993-4620-906b-af2fe6c0ebf1} TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 7. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 9. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. ? @ 0x00007ff3e48f3ac3 in ? 17. ? @ 0x00007ff3e4985850 in ? 2024.12.13 21:18:25.495883 [ 159551 ] {205213f2-3993-4620-906b-af2fe6c0ebf1} TCPHandler: Processed in 0.011747439 sec. 2024.12.13 21:18:25.497024 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.497248 [ 159552 ] {b5e85475-afbd-49ae-a56e-8079d7a6a375} executeQuery: (from [::1]:58176) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.12.13 21:18:25.497521 [ 159552 ] {b5e85475-afbd-49ae-a56e-8079d7a6a375} 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): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 7. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 9. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. ? @ 0x00007ff3e48f3ac3 in ? 17. ? @ 0x00007ff3e4985850 in ? 2024.12.13 21:18:25.497628 [ 159552 ] {b5e85475-afbd-49ae-a56e-8079d7a6a375} TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(int, FormatStringHelperImpl::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 7. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 9. DB::executeQuery(String const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x00000000122e15d5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 10. DB::TCPHandler::runImpl() @ 0x0000000013156f39 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::TCPHandler::run() @ 0x00000000131691b9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. ? @ 0x00007ff3e48f3ac3 in ? 17. ? @ 0x00007ff3e4985850 in ? 2024.12.13 21:18:25.497679 [ 159552 ] {b5e85475-afbd-49ae-a56e-8079d7a6a375} TCPHandler: Processed in 0.000842201 sec. 2024.12.13 21:18:25.498131 [ 159553 ] {} TCP-Session: c5881f14-6d36-4094-9c46-51cd397241cc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.498316 [ 159553 ] {766595c2-2e34-495d-b3eb-40e067765dee} executeQuery: (from [::1]:58178) DROP DATABASE IF EXISTS oximeter (stage: Complete) 2024.12.13 21:18:25.498445 [ 159553 ] {766595c2-2e34-495d-b3eb-40e067765dee} TCPHandler: Processed in 0.000408971 sec. 2024.12.13 21:18:25.490142 [ 159555 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58184 2024.12.13 21:18:25.490065 [ 159558 ] {} TCPHandlerFactory: TCP Request. Address: [::1]:58190 2024.12.13 21:18:25.498982 [ 159555 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.499005 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.499027 [ 159555 ] {} TCP-Session: fb686690-bd49-4ac8-afe3-66c513402dfb Authenticating user 'default' from [::1]:58184 2024.12.13 21:18:25.499031 [ 159558 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.13 21:18:25.499045 [ 159555 ] {} TCP-Session: fb686690-bd49-4ac8-afe3-66c513402dfb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.499051 [ 159555 ] {} TCP-Session: fb686690-bd49-4ac8-afe3-66c513402dfb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.499054 [ 159558 ] {} TCP-Session: 99ff2aa9-fcbe-4245-81af-a4c4ef5e39e2 Authenticating user 'default' from [::1]:58190 2024.12.13 21:18:25.499061 [ 159558 ] {} TCP-Session: 99ff2aa9-fcbe-4245-81af-a4c4ef5e39e2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.499067 [ 159558 ] {} TCP-Session: 99ff2aa9-fcbe-4245-81af-a4c4ef5e39e2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.13 21:18:25.501522 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} executeQuery: (from [::1]:58174) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) 2024.12.13 21:18:25.502934 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* 2024.12.13 21:18:25.508279 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. 2024.12.13 21:18:25.508311 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.6229e-05 sec 2024.12.13 21:18:25.508320 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} ReferentialDeps: No tables 2024.12.13 21:18:25.508327 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} LoadingDeps: No tables 2024.12.13 21:18:25.508353 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} DatabaseAtomic (oximeter): Starting up tables. 2024.12.13 21:18:25.508449 [ 159551 ] {ddab4dca-9dbe-4a32-bbd6-598093619aac} TCPHandler: Processed in 0.009519448 sec. 2024.12.13 21:18:25.509280 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.509532 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} executeQuery: (from [::1]:58176) /* The version table contains metadata about the `oximeter` database */ CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) 2024.12.13 21:18:25.509581 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version 2024.12.13 21:18:25.515578 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} oximeter.version (be4ed63e-651f-4062-8a60-0c2ddc363cbb): Loading data parts 2024.12.13 21:18:25.515853 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} oximeter.version (be4ed63e-651f-4062-8a60-0c2ddc363cbb): There are no data parts 2024.12.13 21:18:25.520667 [ 159552 ] {47459697-4def-4f8d-8717-1a73d531778d} TCPHandler: Processed in 0.011594129 sec. 2024.12.13 21:18:25.521627 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.522806 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} executeQuery: (from [::1]:58174) /* The measurement tables contain all individual samples from each timeseries. * * Each table stores a single datum type, and otherwise contains nearly the same * structure. The primary sorting key is on the timeseries name, key, and then * timestamp, so that all timeseries from the same schema are grouped, followed * by all samples from the same timeseries. * * This reflects that one usually looks up the _key_ in one or more field table, * and then uses that to index quickly into the measurements tables. */ 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) 2024.12.13 21:18:25.522864 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool 2024.12.13 21:18:25.527283 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} oximeter.measurements_bool (b51b41fb-f5f1-40e3-8611-7fcf262d282d): Loading data parts 2024.12.13 21:18:25.533924 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} oximeter.measurements_bool (b51b41fb-f5f1-40e3-8611-7fcf262d282d): There are no data parts 2024.12.13 21:18:25.540420 [ 159551 ] {d37b2ca2-b2b6-496c-bd6f-aa47a22721ac} TCPHandler: Processed in 0.018994026 sec. 2024.12.13 21:18:25.541358 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.541684 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} 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) 2024.12.13 21:18:25.541760 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 2024.12.13 21:18:25.548495 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} oximeter.measurements_i8 (a6db089c-67c7-40dd-a256-a809bc841eec): Loading data parts 2024.12.13 21:18:25.549139 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} oximeter.measurements_i8 (a6db089c-67c7-40dd-a256-a809bc841eec): There are no data parts 2024.12.13 21:18:25.553858 [ 159552 ] {a7c51f0d-b754-4a8c-95f8-96a85adeec31} TCPHandler: Processed in 0.01271446 sec. 2024.12.13 21:18:25.556396 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.562766 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} 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) 2024.12.13 21:18:25.562834 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 2024.12.13 21:18:25.567798 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} oximeter.measurements_u8 (8463bc78-46b6-401b-b4e6-5a537085e186): Loading data parts 2024.12.13 21:18:25.568722 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} oximeter.measurements_u8 (8463bc78-46b6-401b-b4e6-5a537085e186): There are no data parts 2024.12.13 21:18:25.573959 [ 159551 ] {4e0e012e-b985-4e3c-b2d8-68bf6a1547b7} TCPHandler: Processed in 0.017739885 sec. 2024.12.13 21:18:25.574903 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.575221 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} 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) 2024.12.13 21:18:25.575274 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 2024.12.13 21:18:25.581638 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} oximeter.measurements_i16 (2740ca33-b2e6-497d-82d8-cb394e68e79f): Loading data parts 2024.12.13 21:18:25.582002 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} oximeter.measurements_i16 (2740ca33-b2e6-497d-82d8-cb394e68e79f): There are no data parts 2024.12.13 21:18:25.588544 [ 159552 ] {07d3778d-c875-4c7b-a7f1-95eac71a58b6} TCPHandler: Processed in 0.013816321 sec. 2024.12.13 21:18:25.589646 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.589916 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} 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) 2024.12.13 21:18:25.589970 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 2024.12.13 21:18:25.595684 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} oximeter.measurements_u16 (b6855f23-5c84-4637-b602-1a0c7ff6d484): Loading data parts 2024.12.13 21:18:25.596140 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} oximeter.measurements_u16 (b6855f23-5c84-4637-b602-1a0c7ff6d484): There are no data parts 2024.12.13 21:18:25.599956 [ 159551 ] {46051de4-6578-4217-9f20-73c99ccb6821} TCPHandler: Processed in 0.010488058 sec. 2024.12.13 21:18:25.600911 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.601220 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} 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) 2024.12.13 21:18:25.601278 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 2024.12.13 21:18:25.607702 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} oximeter.measurements_i32 (b8414e21-511c-461b-a161-bf2e2264c726): Loading data parts 2024.12.13 21:18:25.608024 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} oximeter.measurements_i32 (b8414e21-511c-461b-a161-bf2e2264c726): There are no data parts 2024.12.13 21:18:25.612703 [ 159552 ] {b724d2e9-ce16-440e-ac4b-48c388e0d6ff} TCPHandler: Processed in 0.01196944 sec. 2024.12.13 21:18:25.613557 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.613832 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} 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) 2024.12.13 21:18:25.613886 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 2024.12.13 21:18:25.622235 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} oximeter.measurements_u32 (79d365ee-2dd8-4c99-952f-ef65aaec1968): Loading data parts 2024.12.13 21:18:25.622549 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} oximeter.measurements_u32 (79d365ee-2dd8-4c99-952f-ef65aaec1968): There are no data parts 2024.12.13 21:18:25.628423 [ 159551 ] {97fbb71b-0d61-4862-929f-0ce3952a7f24} TCPHandler: Processed in 0.015052342 sec. 2024.12.13 21:18:25.629297 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.629631 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} 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) 2024.12.13 21:18:25.629692 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 2024.12.13 21:18:25.637157 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} oximeter.measurements_i64 (925d1041-4bc6-41c3-ae96-bb3b36318e7c): Loading data parts 2024.12.13 21:18:25.637445 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} oximeter.measurements_i64 (925d1041-4bc6-41c3-ae96-bb3b36318e7c): There are no data parts 2024.12.13 21:18:25.644393 [ 159552 ] {f058fce4-47af-40aa-bd6f-d922d7535834} TCPHandler: Processed in 0.015283172 sec. 2024.12.13 21:18:25.645218 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.645532 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} 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) 2024.12.13 21:18:25.645595 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 2024.12.13 21:18:25.651788 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} oximeter.measurements_u64 (02767283-4b7c-4c2d-a87b-4993146b1158): Loading data parts 2024.12.13 21:18:25.652073 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} oximeter.measurements_u64 (02767283-4b7c-4c2d-a87b-4993146b1158): There are no data parts 2024.12.13 21:18:25.655830 [ 159551 ] {e1b926de-c6d6-4e48-9b3b-64c9a99fcdac} TCPHandler: Processed in 0.010820509 sec. 2024.12.13 21:18:25.659474 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.659889 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} 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) 2024.12.13 21:18:25.661225 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 2024.12.13 21:18:25.667240 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} oximeter.measurements_f32 (beb8106f-31e2-45eb-8d0d-e480b9c21685): Loading data parts 2024.12.13 21:18:25.667600 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} oximeter.measurements_f32 (beb8106f-31e2-45eb-8d0d-e480b9c21685): There are no data parts 2024.12.13 21:18:25.671562 [ 159552 ] {798c05ff-7658-4153-acd0-3b9bd109b56b} TCPHandler: Processed in 0.01227049 sec. 2024.12.13 21:18:25.672376 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.672661 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} 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) 2024.12.13 21:18:25.672715 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 2024.12.13 21:18:25.679401 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} oximeter.measurements_f64 (74cdcf0c-74f8-494f-9c2c-3c4e03610ff9): Loading data parts 2024.12.13 21:18:25.679745 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} oximeter.measurements_f64 (74cdcf0c-74f8-494f-9c2c-3c4e03610ff9): There are no data parts 2024.12.13 21:18:25.684568 [ 159551 ] {5d956679-ae05-4119-9f22-19641071030f} TCPHandler: Processed in 0.01237903 sec. 2024.12.13 21:18:25.685391 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.685703 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} 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) 2024.12.13 21:18:25.687041 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string 2024.12.13 21:18:25.692120 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} oximeter.measurements_string (d77272e5-5b4e-4285-87b4-304adf39b1f8): Loading data parts 2024.12.13 21:18:25.692409 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} oximeter.measurements_string (d77272e5-5b4e-4285-87b4-304adf39b1f8): There are no data parts 2024.12.13 21:18:25.696794 [ 159552 ] {62847b38-91e7-410d-9325-72aa7626a84b} TCPHandler: Processed in 0.011586539 sec. 2024.12.13 21:18:25.698673 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.699015 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} executeQuery: (from [::1]:58174) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* * NOTE: Right now we can't unambiguously record a nullable byte array. * Arrays cannot be nested in `Nullable()` types, and encoding the array as * a string isn't palatable for a few reasons. * See: https://github.com/oxidecomputer/omicron/issues/4551 for more * details. */ datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.12.13 21:18:25.699072 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes 2024.12.13 21:18:25.704922 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} oximeter.measurements_bytes (5050bdea-d7d7-4a2a-bf80-b80560174a6f): Loading data parts 2024.12.13 21:18:25.705252 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} oximeter.measurements_bytes (5050bdea-d7d7-4a2a-bf80-b80560174a6f): There are no data parts 2024.12.13 21:18:25.709558 [ 159551 ] {a235b237-7810-43d1-81d8-4a91a56db8aa} TCPHandler: Processed in 0.011079999 sec. 2024.12.13 21:18:25.710457 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.710750 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} 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) 2024.12.13 21:18:25.710806 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 2024.12.13 21:18:25.717628 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} oximeter.measurements_cumulativei64 (aaa0c3f8-617a-40fb-9de8-7332b22d3d24): Loading data parts 2024.12.13 21:18:25.717930 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} oximeter.measurements_cumulativei64 (aaa0c3f8-617a-40fb-9de8-7332b22d3d24): There are no data parts 2024.12.13 21:18:25.723850 [ 159552 ] {ddcf0ecf-9433-4563-aa88-5b1520bd8444} TCPHandler: Processed in 0.013579681 sec. 2024.12.13 21:18:25.724699 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.726482 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} 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) 2024.12.13 21:18:25.726546 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 2024.12.13 21:18:25.732252 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} oximeter.measurements_cumulativeu64 (ad5c098b-0edd-4a8d-bf4d-bcbb5d69ea42): Loading data parts 2024.12.13 21:18:25.732505 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} oximeter.measurements_cumulativeu64 (ad5c098b-0edd-4a8d-bf4d-bcbb5d69ea42): There are no data parts 2024.12.13 21:18:25.737535 [ 159551 ] {3356d1b4-4093-4aef-bc0f-5e0d41c06ed2} TCPHandler: Processed in 0.013004691 sec. 2024.12.13 21:18:25.738511 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.738822 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} 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) 2024.12.13 21:18:25.738880 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 2024.12.13 21:18:25.745154 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} oximeter.measurements_cumulativef32 (41043f24-7d4a-4934-a870-129028016fa6): Loading data parts 2024.12.13 21:18:25.745485 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} oximeter.measurements_cumulativef32 (41043f24-7d4a-4934-a870-129028016fa6): There are no data parts 2024.12.13 21:18:25.749568 [ 159552 ] {58a4cd9a-aecf-4928-b428-62d426f51a85} TCPHandler: Processed in 0.011261549 sec. 2024.12.13 21:18:25.785372 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.785712 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} 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) 2024.12.13 21:18:25.785773 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 2024.12.13 21:18:25.791851 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} oximeter.measurements_cumulativef64 (f59f9eb2-a3b1-4069-afb4-49164c8acb16): Loading data parts 2024.12.13 21:18:25.793519 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} oximeter.measurements_cumulativef64 (f59f9eb2-a3b1-4069-afb4-49164c8acb16): There are no data parts 2024.12.13 21:18:25.797839 [ 159551 ] {96213303-3975-4bb8-af2c-4ca94b84556d} TCPHandler: Processed in 0.012663371 sec. 2024.12.13 21:18:25.807917 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.808348 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} 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'), /* * NOTE: Array types cannot be Nullable, see * https://clickhouse.com/docs/en/sql-reference/data-types/nullable * for more details. * * This means we need to use empty arrays to indicate a missing value. This * is unfortunate, and at this point relies on the fact that an * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need * to figure out another way to represent missing samples here. */ 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) 2024.12.13 21:18:25.808426 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 2024.12.13 21:18:25.812731 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} oximeter.measurements_histogrami8 (e4b2f145-1857-4bb7-9650-e7eb76a68198): Loading data parts 2024.12.13 21:18:25.813024 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} oximeter.measurements_histogrami8 (e4b2f145-1857-4bb7-9650-e7eb76a68198): There are no data parts 2024.12.13 21:18:25.816640 [ 159552 ] {e32c3e53-25b9-4a79-939f-89cd00606f91} TCPHandler: Processed in 0.008916807 sec. 2024.12.13 21:18:25.915372 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:25.916248 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} 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) 2024.12.13 21:18:25.916317 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 2024.12.13 21:18:25.921713 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} oximeter.measurements_histogramu8 (a7af3409-45e7-42b5-aa29-99e1de915fd6): Loading data parts 2024.12.13 21:18:25.922014 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} oximeter.measurements_histogramu8 (a7af3409-45e7-42b5-aa29-99e1de915fd6): There are no data parts 2024.12.13 21:18:25.925791 [ 159551 ] {d33597f7-0d86-48e9-b3f9-4b25055056d2} TCPHandler: Processed in 0.010613018 sec. 2024.12.13 21:18:26.000406 [ 158184 ] {} 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 2024.12.13 21:18:26.439119 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.443300 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} 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) 2024.12.13 21:18:26.443379 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 2024.12.13 21:18:26.448360 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} oximeter.measurements_histogrami16 (29317412-128c-464f-a8e7-deddfe77f369): Loading data parts 2024.12.13 21:18:26.448634 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} oximeter.measurements_histogrami16 (29317412-128c-464f-a8e7-deddfe77f369): There are no data parts 2024.12.13 21:18:26.452176 [ 159552 ] {de65027c-e1d8-4331-89af-4e5ae37b8c39} TCPHandler: Processed in 0.013265721 sec. 2024.12.13 21:18:26.473831 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.474193 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} 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) 2024.12.13 21:18:26.474257 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 2024.12.13 21:18:26.479252 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} oximeter.measurements_histogramu16 (85deb8a0-a48a-4a1b-811e-fc2158f013c3): Loading data parts 2024.12.13 21:18:26.481595 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} oximeter.measurements_histogramu16 (85deb8a0-a48a-4a1b-811e-fc2158f013c3): There are no data parts 2024.12.13 21:18:26.495853 [ 159551 ] {8e0e58d4-e11e-4e69-b37e-06bdcbec3371} TCPHandler: Processed in 0.022206798 sec. 2024.12.13 21:18:26.516300 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.516625 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} 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) 2024.12.13 21:18:26.516692 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 2024.12.13 21:18:26.523007 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} oximeter.measurements_histogrami32 (b96d424b-7177-4d3e-b553-a851f6322d39): Loading data parts 2024.12.13 21:18:26.523293 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} oximeter.measurements_histogrami32 (b96d424b-7177-4d3e-b553-a851f6322d39): There are no data parts 2024.12.13 21:18:26.528758 [ 159552 ] {3c11a13b-b24c-4994-96f5-ae2c328d35b1} TCPHandler: Processed in 0.01253537 sec. 2024.12.13 21:18:26.580602 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.581036 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} 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) 2024.12.13 21:18:26.587167 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 2024.12.13 21:18:26.594676 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} oximeter.measurements_histogramu32 (9eef532d-6a46-4c33-bd80-25e6141e29a3): Loading data parts 2024.12.13 21:18:26.594954 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} oximeter.measurements_histogramu32 (9eef532d-6a46-4c33-bd80-25e6141e29a3): There are no data parts 2024.12.13 21:18:26.599732 [ 159551 ] {1f18262e-6f0c-492b-8dd8-6e246c5be726} TCPHandler: Processed in 0.019261126 sec. 2024.12.13 21:18:26.606046 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.606407 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} 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) 2024.12.13 21:18:26.606467 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 2024.12.13 21:18:26.613064 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} oximeter.measurements_histogrami64 (2b2d14ca-cd06-468b-853e-56c42c09448d): Loading data parts 2024.12.13 21:18:26.617264 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} oximeter.measurements_histogrami64 (2b2d14ca-cd06-468b-853e-56c42c09448d): There are no data parts 2024.12.13 21:18:26.623052 [ 159552 ] {dcdbfbca-c73b-4c7c-ad03-8d0efd21d612} TCPHandler: Processed in 0.017091403 sec. 2024.12.13 21:18:26.628736 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.629033 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} 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) 2024.12.13 21:18:26.629078 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 2024.12.13 21:18:26.644995 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} oximeter.measurements_histogramu64 (002bd09d-9269-4d3c-9ab5-09d1f1e69b84): Loading data parts 2024.12.13 21:18:26.645249 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} oximeter.measurements_histogramu64 (002bd09d-9269-4d3c-9ab5-09d1f1e69b84): There are no data parts 2024.12.13 21:18:26.655281 [ 159551 ] {7b4431b3-c664-419e-9385-54aa57f24a1e} TCPHandler: Processed in 0.026638822 sec. 2024.12.13 21:18:26.661209 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.661611 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} 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) 2024.12.13 21:18:26.661676 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 2024.12.13 21:18:26.667490 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} oximeter.measurements_histogramf32 (24a3a243-1bb6-4677-9ff1-d8d11e85ef36): Loading data parts 2024.12.13 21:18:26.672671 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} oximeter.measurements_histogramf32 (24a3a243-1bb6-4677-9ff1-d8d11e85ef36): There are no data parts 2024.12.13 21:18:26.678510 [ 159552 ] {b91d5e67-caef-4a1f-9a36-65800ac1e74b} TCPHandler: Processed in 0.017467304 sec. 2024.12.13 21:18:26.679126 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.679434 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} 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) 2024.12.13 21:18:26.679489 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 2024.12.13 21:18:26.690534 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} oximeter.measurements_histogramf64 (b4e3c083-71a1-4ca1-bf13-c69588b8fe4b): Loading data parts 2024.12.13 21:18:26.690985 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} oximeter.measurements_histogramf64 (b4e3c083-71a1-4ca1-bf13-c69588b8fe4b): There are no data parts 2024.12.13 21:18:26.703715 [ 159551 ] {420e4054-98e9-4860-903b-0c4ceab14f1e} TCPHandler: Processed in 0.02466589 sec. 2024.12.13 21:18:26.704805 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.706596 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} executeQuery: (from [::1]:58176) /* The field tables store named dimensions of each timeseries. * * As with the measurement tables, there is one field table for each field data * type. Fields are deduplicated by using the "replacing merge tree", though * this behavior **must not** be relied upon for query correctness. * * The index for the fields differs from the measurements, however. Rows are * sorted by timeseries name, then field name, field value, and finally * timeseries key. This reflects the most common pattern for looking them up: * by field name and possibly value, within a timeseries. The resulting keys are * usually then used to look up measurements. * * NOTE: We may want to consider a secondary index on these tables, sorting by * timeseries name and then key, since it would improve lookups where one * already has the key. Realistically though, these tables are quite small and * so performance benefits will be low in absolute terms. * * TTL: We use a materialized column to expire old field table records. This * column is generated automatically by the database whenever a new row is * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` * query. Since these tables are `ReplacingMergeTree`s, that means the last * record will remain during a deduplication, which will have the last * timestamp. ClickHouse will then expire old data for us, similar to the * measurement tables. */ 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) 2024.12.13 21:18:26.706657 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool 2024.12.13 21:18:26.713911 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} oximeter.fields_bool (ba587e66-cf30-435e-843b-845f70132169): Loading data parts 2024.12.13 21:18:26.714231 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} oximeter.fields_bool (ba587e66-cf30-435e-843b-845f70132169): There are no data parts 2024.12.13 21:18:26.719260 [ 159552 ] {ed8c39f5-b322-4146-8c85-446da897a313} TCPHandler: Processed in 0.014607712 sec. 2024.12.13 21:18:26.720120 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.720383 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} 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) 2024.12.13 21:18:26.720431 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 2024.12.13 21:18:26.726274 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} oximeter.fields_i8 (bbabfe2f-d40d-4e0e-b4d7-8f126e47ab5d): Loading data parts 2024.12.13 21:18:26.726528 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} oximeter.fields_i8 (bbabfe2f-d40d-4e0e-b4d7-8f126e47ab5d): There are no data parts 2024.12.13 21:18:26.732662 [ 159551 ] {3149b0b1-a6f9-4322-8ea1-54235ce4ed07} TCPHandler: Processed in 0.01265099 sec. 2024.12.13 21:18:26.733957 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.734696 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} 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) 2024.12.13 21:18:26.734746 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 2024.12.13 21:18:26.739854 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} oximeter.fields_u8 (3bd102d6-9b09-42db-8c12-e7dffc9e0255): Loading data parts 2024.12.13 21:18:26.740439 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} oximeter.fields_u8 (3bd102d6-9b09-42db-8c12-e7dffc9e0255): There are no data parts 2024.12.13 21:18:26.749304 [ 159552 ] {a0a6316f-97fa-4bc2-919c-92397649fe84} TCPHandler: Processed in 0.015447492 sec. 2024.12.13 21:18:26.750025 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.752364 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} 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) 2024.12.13 21:18:26.752422 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 2024.12.13 21:18:26.758075 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} oximeter.fields_i16 (812dcf75-3c8e-4362-84fe-70d4bde628e4): Loading data parts 2024.12.13 21:18:26.758595 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} oximeter.fields_i16 (812dcf75-3c8e-4362-84fe-70d4bde628e4): There are no data parts 2024.12.13 21:18:26.768749 [ 159551 ] {a9584218-45fa-4bfa-b6b9-436c3f8e9658} TCPHandler: Processed in 0.018828075 sec. 2024.12.13 21:18:26.769552 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.769841 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} 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) 2024.12.13 21:18:26.769895 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 2024.12.13 21:18:26.777379 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} oximeter.fields_u16 (bd3dae6b-c364-489a-89d1-4baf100f04e6): Loading data parts 2024.12.13 21:18:26.781981 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} oximeter.fields_u16 (bd3dae6b-c364-489a-89d1-4baf100f04e6): There are no data parts 2024.12.13 21:18:26.790405 [ 159552 ] {aa3f0ddc-4903-4f29-bc3d-b9c1f89901f2} TCPHandler: Processed in 0.020959347 sec. 2024.12.13 21:18:26.791049 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.791295 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} 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) 2024.12.13 21:18:26.791342 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 2024.12.13 21:18:26.799517 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} oximeter.fields_i32 (38bf6fe5-1255-4c7d-b183-fe95999f997b): Loading data parts 2024.12.13 21:18:26.800038 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} oximeter.fields_i32 (38bf6fe5-1255-4c7d-b183-fe95999f997b): There are no data parts 2024.12.13 21:18:26.808462 [ 159551 ] {48ba030f-cc00-4d86-8bf5-8708dafc7bb7} TCPHandler: Processed in 0.017491144 sec. 2024.12.13 21:18:26.809125 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.809693 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} 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) 2024.12.13 21:18:26.810921 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 2024.12.13 21:18:26.816831 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} oximeter.fields_u32 (41f8b545-eeec-4cf1-88d6-b0c1e6397faf): Loading data parts 2024.12.13 21:18:26.819084 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} oximeter.fields_u32 (41f8b545-eeec-4cf1-88d6-b0c1e6397faf): There are no data parts 2024.12.13 21:18:26.828773 [ 159552 ] {4fb66b7f-a16a-4c26-82a7-618a191ad6d7} TCPHandler: Processed in 0.019730476 sec. 2024.12.13 21:18:26.829479 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.829732 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} 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) 2024.12.13 21:18:26.829786 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 2024.12.13 21:18:26.838433 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} oximeter.fields_i64 (7107145a-df41-4305-9a27-b74b1f53cb63): Loading data parts 2024.12.13 21:18:26.841815 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} oximeter.fields_i64 (7107145a-df41-4305-9a27-b74b1f53cb63): There are no data parts 2024.12.13 21:18:26.847702 [ 159551 ] {a459bc02-a17a-46ea-83c0-fad413544f9a} TCPHandler: Processed in 0.018344384 sec. 2024.12.13 21:18:26.848344 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.848559 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} 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) 2024.12.13 21:18:26.848601 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 2024.12.13 21:18:26.854996 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} oximeter.fields_u64 (6f71ebd2-3e00-4751-b9e0-33dba0c95de5): Loading data parts 2024.12.13 21:18:26.855372 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} oximeter.fields_u64 (6f71ebd2-3e00-4751-b9e0-33dba0c95de5): There are no data parts 2024.12.13 21:18:26.862638 [ 159552 ] {383d99c3-9e23-4f09-9dbb-428fee2ebfce} TCPHandler: Processed in 0.014379941 sec. 2024.12.13 21:18:26.863384 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.863644 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} 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) 2024.12.13 21:18:26.863698 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr 2024.12.13 21:18:26.876881 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} oximeter.fields_ipaddr (a817c0b2-352d-46f5-b0c0-ffacef4ae20b): Loading data parts 2024.12.13 21:18:26.877163 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} oximeter.fields_ipaddr (a817c0b2-352d-46f5-b0c0-ffacef4ae20b): There are no data parts 2024.12.13 21:18:26.890760 [ 159551 ] {923eb637-58a8-4536-abbe-65ff05cd02d5} TCPHandler: Processed in 0.027527262 sec. 2024.12.13 21:18:26.891539 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.893565 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} 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) 2024.12.13 21:18:26.893622 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string 2024.12.13 21:18:26.899851 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} oximeter.fields_string (7250caeb-794c-43f6-8cf4-6618ee28eba0): Loading data parts 2024.12.13 21:18:26.901220 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} oximeter.fields_string (7250caeb-794c-43f6-8cf4-6618ee28eba0): There are no data parts 2024.12.13 21:18:26.906692 [ 159552 ] {7e8530eb-aa5e-444a-90f6-6c2dc21ba598} TCPHandler: Processed in 0.015274063 sec. 2024.12.13 21:18:26.907485 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.907753 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} 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) 2024.12.13 21:18:26.907802 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid 2024.12.13 21:18:26.913961 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} oximeter.fields_uuid (57e72ffe-7c2d-48a9-9887-28eb1675f0b4): Loading data parts 2024.12.13 21:18:26.917130 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} oximeter.fields_uuid (57e72ffe-7c2d-48a9-9887-28eb1675f0b4): There are no data parts 2024.12.13 21:18:26.925259 [ 159551 ] {40f3a98d-5df9-40d6-a862-f202a5c9f57b} TCPHandler: Processed in 0.018007755 sec. 2024.12.13 21:18:26.926027 [ 159552 ] {} TCP-Session: f7f4ceb0-eb69-4cad-856d-ae33bcd2d7db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.926326 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} executeQuery: (from [::1]:58176) /* The timeseries schema table stores the extracted schema for the samples * oximeter collects. */ 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) 2024.12.13 21:18:26.927771 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema 2024.12.13 21:18:26.933490 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} oximeter.timeseries_schema (9958e62e-3f65-4986-8574-71a38cde4102): Loading data parts 2024.12.13 21:18:26.933774 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} oximeter.timeseries_schema (9958e62e-3f65-4986-8574-71a38cde4102): There are no data parts 2024.12.13 21:18:26.939817 [ 159552 ] {01ec70e7-59fe-4ccb-a98e-92c0e521a075} TCPHandler: Processed in 0.013872682 sec. 2024.12.13 21:18:26.941642 [ 159551 ] {} TCP-Session: f972a5a5-40e7-4ed6-a188-a4b69a3ed5da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:26.944085 [ 159551 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} executeQuery: (from [::1]:58174) INSERT INTO oximeter.version (*) VALUES (stage: Complete) 2024.12.13 21:18:26.944174 [ 159551 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version 2024.12.13 21:18:26.944914 [ 159522 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} oximeter.version (be4ed63e-651f-4062-8a60-0c2ddc363cbb): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.13 21:18:26.946343 [ 159522 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 163.22 GiB. 2024.12.13 21:18:26.946729 [ 159522 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.13 21:18:26.990566 [ 159522 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} 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). 2024.12.13 21:18:26.990821 [ 159551 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} executeQuery: Read 1 rows, 16.00 B in 0.046772 sec., 21.380313007782433 rows/sec., 342.09 B/sec. 2024.12.13 21:18:26.991004 [ 159551 ] {e608ed7e-5a1f-4ee5-ae02-8b1ed1666fe6} TCPHandler: Processed in 0.04943923 sec. 2024.12.13 21:18:27.001124 [ 158184 ] {} 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 2024.12.13 21:18:27.755342 [ 157696 ] {} TCP-Session: 7d777e19-271c-49bf-b88c-bbb86ec5f145 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.13 21:18:27.755628 [ 157696 ] {c8a408ef-a57f-4faf-898e-6dbbec237849} executeQuery: (from [::1]:58154) SELECT * FROM oximeter.timeseries_schema FORMAT Native; (stage: Complete) 2024.12.13 21:18:27.756872 [ 157696 ] {c8a408ef-a57f-4faf-898e-6dbbec237849} ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema 2024.12.13 21:18:27.756925 [ 157696 ] {c8a408ef-a57f-4faf-898e-6dbbec237849} InterpreterSelectQuery: FetchColumns -> Complete 2024.12.13 21:18:27.757507 [ 157696 ] {c8a408ef-a57f-4faf-898e-6dbbec237849} TCPHandler: Processed in 0.002385781 sec. 2024.12.13 21:18:28.000531 [ 158184 ] {} 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