[ Dec 21 08:14:24 Enabled. ] [ Dec 21 08:14:24 Rereading configuration. ] [ Dec 21 08:14:28 Rereading configuration. ] [ Dec 21 08:14:41 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ] + set -o errexit + set -o pipefail + . /lib/svc/share/smf_include.sh ++ SMF_EXIT_OK=0 ++ SMF_EXIT_NODAEMON=94 ++ SMF_EXIT_ERR_FATAL=95 ++ SMF_EXIT_ERR_CONFIG=96 ++ SMF_EXIT_MON_DEGRADE=97 ++ SMF_EXIT_MON_OFFLINE=98 ++ SMF_EXIT_ERR_NOSMF=99 ++ SMF_EXIT_ERR_PERM=100 ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default + LISTEN_ADDR=fd00:1122:3344:101::e ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default + LISTEN_PORT=8123 ++ svcprop -c -p config/store svc:/oxide/clickhouse:default + DATASTORE=/data + args=("--config-file" "/opt/oxide/clickhouse/config.xml" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") + exec /opt/oxide/clickhouse/clickhouse server --config-file /opt/oxide/clickhouse/config.xml -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123 [ Dec 21 08:14:41 Method "start" exited with status 0. ] Processing configuration file '/opt/oxide/clickhouse/config.xml'. Logging trace to /var/tmp/clickhouse-server.log Logging errors to /var/tmp/clickhouse-server.errlog 2024.12.21 08:14:42.043571 [ 1 ] {} Application: Will watch for the process with pid 23131 2024.12.21 08:14:42.043996 [ 1 ] {} Application: Forked a child process to watch 2024.12.21 08:14:42.286770 [ 1 ] {} Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: ), PID 23131 2024.12.21 08:14:42.287491 [ 1 ] {} Application: starting up 2024.12.21 08:14:42.288163 [ 1 ] {} Application: OS name: SunOS, version: 5.11, architecture: i86pc 2024.12.21 08:14:42.374830 [ 1 ] {} Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. 2024.12.21 08:14:42.431664 [ 1 ] {} Application: rlimit on number of file descriptors is 65536 2024.12.21 08:14:42.431712 [ 1 ] {} Application: Initializing DateLUT. 2024.12.21 08:14:42.431725 [ 1 ] {} Application: Initialized DateLUT with time zone 'UTC'. 2024.12.21 08:14:42.431788 [ 1 ] {} Context: Setting up /data/tmp/ to store temporary data in it 2024.12.21 08:14:42.432147 [ 1 ] {} Application: Initializing interserver credentials. 2024.12.21 08:14:42.433663 [ 1 ] {} ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' Processing configuration file '/opt/oxide/clickhouse/config.xml'. Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. 2024.12.21 08:14:42.434379 [ 1 ] {} ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration 2024.12.21 08:14:42.435200 [ 1 ] {} Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) 2024.12.21 08:14:42.435222 [ 1 ] {} Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) 2024.12.21 08:14:42.435238 [ 1 ] {} Application: Merges and mutations memory limit is set to 47.94 GiB 2024.12.21 08:14:42.435407 [ 1 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.21 08:14:42.436271 [ 1 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.12.21 08:14:42.441587 [ 1 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.21 08:14:42.442361 [ 1 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.12.21 08:14:42.443695 [ 1 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.21 08:14:42.443759 [ 1 ] {} ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration 2024.12.21 08:14:42.445304 [ 1 ] {} ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' Processing configuration file '/opt/oxide/clickhouse/config.xml'. Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. 2024.12.21 08:14:42.445841 [ 1 ] {} ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration 2024.12.21 08:14:42.450241 [ 1 ] {} ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration 2024.12.21 08:14:42.450907 [ 1 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml 2024.12.21 08:14:42.452351 [ 1 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.12.21 08:14:42.452751 [ 1 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.12.21 08:14:42.453135 [ 1 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.12.21 08:14:42.453519 [ 1 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.12.21 08:14:42.454815 [ 1 ] {} DNSCacheUpdater: Update period 15 seconds 2024.12.21 08:14:42.454841 [ 1 ] {} Application: Loading metadata from /data/ 2024.12.21 08:14:42.454932 [ 164 ] {} DNSResolver: Updating DNS cache 2024.12.21 08:14:42.455102 [ 164 ] {} DNSResolver: Updated DNS cache 2024.12.21 08:14:42.480141 [ 1 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.12.21 08:14:42.480175 [ 1 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000165032 sec 2024.12.21 08:14:42.480224 [ 1 ] {} ReferentialDeps: No tables 2024.12.21 08:14:42.480240 [ 1 ] {} LoadingDeps: No tables 2024.12.21 08:14:42.481353 [ 1 ] {} DatabaseAtomic (system): Starting up tables. 2024.12.21 08:14:42.482385 [ 1 ] {} SystemLog: Creating system.query_log from query_log 2024.12.21 08:14:42.494078 [ 1 ] {} SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config 2024.12.21 08:14:42.494122 [ 1 ] {} SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config 2024.12.21 08:14:42.494145 [ 1 ] {} SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config 2024.12.21 08:14:42.494158 [ 1 ] {} SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config 2024.12.21 08:14:42.494187 [ 1 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.12.21 08:14:42.494209 [ 1 ] {} SystemLog: Creating system.metric_log from metric_log 2024.12.21 08:14:42.496790 [ 1 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.12.21 08:14:42.496834 [ 1 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.12.21 08:14:42.496857 [ 1 ] {} SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log 2024.12.21 08:14:42.497041 [ 1 ] {} SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config 2024.12.21 08:14:42.497061 [ 1 ] {} SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config 2024.12.21 08:14:42.497096 [ 1 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.12.21 08:14:42.497116 [ 1 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.12.21 08:14:42.497129 [ 1 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.12.21 08:14:42.497157 [ 1 ] {} SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config 2024.12.21 08:14:42.497176 [ 1 ] {} SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config 2024.12.21 08:14:42.524019 [ 1 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.12.21 08:14:42.531015 [ 1 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.12.21 08:14:42.531047 [ 1 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.4021e-05 sec 2024.12.21 08:14:42.531060 [ 1 ] {} ReferentialDeps: No tables 2024.12.21 08:14:42.531071 [ 1 ] {} LoadingDeps: No tables 2024.12.21 08:14:42.531096 [ 1 ] {} DatabaseAtomic (default): Starting up tables. 2024.12.21 08:14:42.531299 [ 1 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ 2024.12.21 08:14:42.531345 [ 1 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.12.21 08:14:42.531359 [ 1 ] {} Application: Loaded metadata. 2024.12.21 08:14:42.531371 [ 1 ] {} Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). 2024.12.21 08:14:42.531383 [ 1 ] {} Application: TaskStats is not implemented for this OS. IO accounting will be disabled. 2024.12.21 08:14:42.535720 [ 1 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.12.21 08:14:42.535939 [ 1 ] {} AsynchronousMetrics: MemoryTracking: was 24.78 MiB, peak 24.78 MiB, free memory in arenas 0.00 B, will set to 117.12 MiB (RSS), difference: 92.34 MiB 2024.12.21 08:14:42.536857 [ 1 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.439e-05 sec. 2024.12.21 08:14:42.537821 [ 1 ] {} Application: Listening for http://[fd00:1122:3344:101::e]:8123 2024.12.21 08:14:42.537919 [ 1 ] {} Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 2024.12.21 08:14:42.537938 [ 1 ] {} Application: Ready for connections. 2024.12.21 08:14:42.570867 [ 3 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:53728 2024.12.21 08:14:42.571119 [ 3 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.571173 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Authenticating user 'default' from [fd00:1122:3344:101::d]:53728 2024.12.21 08:14:42.571206 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.571228 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.571315 [ 3 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.21 08:14:42.571343 [ 3 ] {} 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.21 08:14:42.571370 [ 3 ] {} 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.21 08:14:42.571866 [ 4 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:60436 2024.12.21 08:14:42.572037 [ 4 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.572079 [ 4 ] {} TCP-Session: 3517b3bb-343c-4ad2-b59f-8a44053646d5 Authenticating user 'default' from [fd00:1122:3344:101::d]:60436 2024.12.21 08:14:42.572112 [ 4 ] {} TCP-Session: 3517b3bb-343c-4ad2-b59f-8a44053646d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.572149 [ 4 ] {} TCP-Session: 3517b3bb-343c-4ad2-b59f-8a44053646d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.572824 [ 5 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:60888 2024.12.21 08:14:42.572826 [ 253 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:58472 2024.12.21 08:14:42.573077 [ 5 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.573087 [ 253 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.572938 [ 254 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:44959 2024.12.21 08:14:42.573158 [ 5 ] {} TCP-Session: 524c8fd2-408a-402a-b374-f3a1bb3a735b Authenticating user 'default' from [fd00:1122:3344:101::d]:60888 2024.12.21 08:14:42.573182 [ 253 ] {} TCP-Session: 4c6f8e87-5e9a-4718-babc-e36e887c0165 Authenticating user 'default' from [fd00:1122:3344:101::d]:58472 2024.12.21 08:14:42.573139 [ 255 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:52401 2024.12.21 08:14:42.573290 [ 256 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:37281 2024.12.21 08:14:42.573373 [ 5 ] {} TCP-Session: 524c8fd2-408a-402a-b374-f3a1bb3a735b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.573388 [ 253 ] {} TCP-Session: 4c6f8e87-5e9a-4718-babc-e36e887c0165 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.573388 [ 254 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.573632 [ 5 ] {} TCP-Session: 524c8fd2-408a-402a-b374-f3a1bb3a735b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.573881 [ 253 ] {} TCP-Session: 4c6f8e87-5e9a-4718-babc-e36e887c0165 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.573882 [ 256 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.573464 [ 257 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:50864 2024.12.21 08:14:42.573914 [ 255 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.574029 [ 256 ] {} TCP-Session: 94fab291-9373-4ddb-ad63-9260e71e95bb Authenticating user 'default' from [fd00:1122:3344:101::d]:37281 2024.12.21 08:14:42.574719 [ 258 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:57520 2024.12.21 08:14:42.574821 [ 254 ] {} TCP-Session: de105a21-83aa-476b-8852-395882cf08ba Authenticating user 'default' from [fd00:1122:3344:101::d]:44959 2024.12.21 08:14:42.574867 [ 255 ] {} TCP-Session: bb1e022d-1015-42bd-b735-72acd26548bf Authenticating user 'default' from [fd00:1122:3344:101::d]:52401 2024.12.21 08:14:42.574861 [ 256 ] {} TCP-Session: 94fab291-9373-4ddb-ad63-9260e71e95bb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.574841 [ 257 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.575650 [ 258 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.575659 [ 254 ] {} TCP-Session: de105a21-83aa-476b-8852-395882cf08ba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.575640 [ 255 ] {} TCP-Session: bb1e022d-1015-42bd-b735-72acd26548bf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.575643 [ 256 ] {} TCP-Session: 94fab291-9373-4ddb-ad63-9260e71e95bb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.575816 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Authenticating user 'default' from [fd00:1122:3344:101::d]:57520 2024.12.21 08:14:42.575849 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.575890 [ 254 ] {} TCP-Session: de105a21-83aa-476b-8852-395882cf08ba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.575891 [ 255 ] {} TCP-Session: bb1e022d-1015-42bd-b735-72acd26548bf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.575924 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.576069 [ 257 ] {} TCP-Session: 9b508fc1-42f6-43a1-8b08-92f0c51cb3c3 Authenticating user 'default' from [fd00:1122:3344:101::d]:50864 2024.12.21 08:14:42.576086 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.576179 [ 257 ] {} TCP-Session: 9b508fc1-42f6-43a1-8b08-92f0c51cb3c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.576220 [ 257 ] {} TCP-Session: 9b508fc1-42f6-43a1-8b08-92f0c51cb3c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.579516 [ 3 ] {e7da30a8-2af8-46c2-a34b-8395afd207b6} executeQuery: (from [fd00:1122:3344:101::d]:53728) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.12.21 08:14:42.635850 [ 3 ] {e7da30a8-2af8-46c2-a34b-8395afd207b6} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:53728) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse 10. std::__detail::_MakeUniq::__single_object std::make_unique&, std::shared_ptr&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse 13. DB::executeQuery(std::__cxx11::basic_string, std::allocator > const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 2024.12.21 08:14:42.637157 [ 3 ] {e7da30a8-2af8-46c2-a34b-8395afd207b6} TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse 10. std::__detail::_MakeUniq::__single_object std::make_unique&, std::shared_ptr&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse 13. DB::executeQuery(std::__cxx11::basic_string, std::allocator > const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 2024.12.21 08:14:42.637260 [ 3 ] {e7da30a8-2af8-46c2-a34b-8395afd207b6} TCPHandler: Processed in 0.063537799 sec. 2024.12.21 08:14:42.637599 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.637785 [ 258 ] {c33ed8d6-e879-4879-91c9-b617137ecbfa} executeQuery: (from [fd00:1122:3344:101::d]:57520) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) 2024.12.21 08:14:42.638097 [ 258 ] {c33ed8d6-e879-4879-91c9-b617137ecbfa} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:57520) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse 10. std::__detail::_MakeUniq::__single_object std::make_unique&, std::shared_ptr&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse 13. DB::executeQuery(std::__cxx11::basic_string, std::allocator > const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 2024.12.21 08:14:42.638209 [ 258 ] {c33ed8d6-e879-4879-91c9-b617137ecbfa} TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, std::optional, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&, std::shared_ptr const&, std::shared_ptr) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr const&, std::shared_ptr, DB::SelectQueryOptions const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse 10. std::__detail::_MakeUniq::__single_object std::make_unique&, std::shared_ptr&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse 13. DB::executeQuery(std::__cxx11::basic_string, std::allocator > const&, std::shared_ptr, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 2024.12.21 08:14:42.638297 [ 258 ] {c33ed8d6-e879-4879-91c9-b617137ecbfa} TCPHandler: Processed in 0.00084666 sec. 2024.12.21 08:14:42.638502 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.639690 [ 3 ] {7519e2b0-5292-4540-92c2-7aa92e55d75c} executeQuery: (from [fd00:1122:3344:101::d]:53728) DROP DATABASE IF EXISTS oximeter (stage: Complete) 2024.12.21 08:14:42.640301 [ 3 ] {7519e2b0-5292-4540-92c2-7aa92e55d75c} TCPHandler: Processed in 0.001854592 sec. 2024.12.21 08:14:42.640506 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.640611 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} executeQuery: (from [fd00:1122:3344:101::d]:57520) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) 2024.12.21 08:14:42.640704 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* 2024.12.21 08:14:42.650283 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. 2024.12.21 08:14:42.650311 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.2721e-05 sec 2024.12.21 08:14:42.650326 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} ReferentialDeps: No tables 2024.12.21 08:14:42.650354 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} LoadingDeps: No tables 2024.12.21 08:14:42.650379 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} DatabaseAtomic (oximeter): Starting up tables. 2024.12.21 08:14:42.650428 [ 258 ] {613f46a6-1981-43fd-bf03-7d85884e59f7} TCPHandler: Processed in 0.009976811 sec. 2024.12.21 08:14:42.650638 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.650835 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} executeQuery: (from [fd00:1122:3344:101::d]:53728) /* 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.21 08:14:42.650884 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version 2024.12.21 08:14:42.658932 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} StoragePolicy (default): Storage policy default created, total volumes 1 2024.12.21 08:14:42.667692 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} oximeter.version (d34c5ef1-ce0f-4147-b76e-f668c6b48f34): Loading data parts 2024.12.21 08:14:42.668247 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} oximeter.version (d34c5ef1-ce0f-4147-b76e-f668c6b48f34): There are no data parts 2024.12.21 08:14:42.669027 [ 260 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:56740 2024.12.21 08:14:42.669182 [ 260 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.669209 [ 260 ] {} TCP-Session: 2faeb2e0-3b49-4538-b353-fdddefae3d8b Authenticating user 'default' from [fd00:1122:3344:101::e]:56740 2024.12.21 08:14:42.669231 [ 260 ] {} TCP-Session: 2faeb2e0-3b49-4538-b353-fdddefae3d8b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.669268 [ 260 ] {} TCP-Session: 2faeb2e0-3b49-4538-b353-fdddefae3d8b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.669334 [ 260 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.21 08:14:42.669360 [ 260 ] {} 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.21 08:14:42.669393 [ 260 ] {} 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.21 08:14:42.669832 [ 261 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:33495 2024.12.21 08:14:42.670023 [ 262 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:39069 2024.12.21 08:14:42.670027 [ 261 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.670086 [ 263 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:49119 2024.12.21 08:14:42.670158 [ 261 ] {} TCP-Session: bde5e1e4-629f-42c5-8362-e32a89182f56 Authenticating user 'default' from [fd00:1122:3344:101::e]:33495 2024.12.21 08:14:42.670278 [ 262 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.670274 [ 264 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:56920 2024.12.21 08:14:42.670351 [ 263 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.670382 [ 261 ] {} TCP-Session: bde5e1e4-629f-42c5-8362-e32a89182f56 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.670409 [ 262 ] {} TCP-Session: e0605171-1076-4071-a65f-2b7ead1e1cfe Authenticating user 'default' from [fd00:1122:3344:101::e]:39069 2024.12.21 08:14:42.670530 [ 265 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:36849 2024.12.21 08:14:42.670547 [ 263 ] {} TCP-Session: 72c00914-199c-4a36-a162-0eaa033fd27b Authenticating user 'default' from [fd00:1122:3344:101::e]:49119 2024.12.21 08:14:42.670554 [ 264 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.670563 [ 262 ] {} TCP-Session: e0605171-1076-4071-a65f-2b7ead1e1cfe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.670678 [ 261 ] {} TCP-Session: bde5e1e4-629f-42c5-8362-e32a89182f56 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.670730 [ 265 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.670750 [ 263 ] {} TCP-Session: 72c00914-199c-4a36-a162-0eaa033fd27b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.670756 [ 264 ] {} TCP-Session: 879c30fa-8007-4d23-b106-fca64acc8917 Authenticating user 'default' from [fd00:1122:3344:101::e]:56920 2024.12.21 08:14:42.670835 [ 263 ] {} TCP-Session: 72c00914-199c-4a36-a162-0eaa033fd27b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.670753 [ 266 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:42051 2024.12.21 08:14:42.670962 [ 264 ] {} TCP-Session: 879c30fa-8007-4d23-b106-fca64acc8917 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.670967 [ 265 ] {} TCP-Session: cb8f7397-6d71-4adf-83f7-71550ebd3521 Authenticating user 'default' from [fd00:1122:3344:101::e]:36849 2024.12.21 08:14:42.670981 [ 267 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:36462 2024.12.21 08:14:42.671028 [ 262 ] {} TCP-Session: e0605171-1076-4071-a65f-2b7ead1e1cfe Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.671046 [ 265 ] {} TCP-Session: cb8f7397-6d71-4adf-83f7-71550ebd3521 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.671069 [ 264 ] {} TCP-Session: 879c30fa-8007-4d23-b106-fca64acc8917 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.671224 [ 265 ] {} TCP-Session: cb8f7397-6d71-4adf-83f7-71550ebd3521 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.671335 [ 266 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.671418 [ 267 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.671472 [ 266 ] {} TCP-Session: 0e5d9ab7-b968-4c0f-82ff-0461a33143da Authenticating user 'default' from [fd00:1122:3344:101::e]:42051 2024.12.21 08:14:42.671526 [ 267 ] {} TCP-Session: 5196033a-52ff-496e-a688-667cf3a2d34d Authenticating user 'default' from [fd00:1122:3344:101::e]:36462 2024.12.21 08:14:42.671556 [ 266 ] {} TCP-Session: 0e5d9ab7-b968-4c0f-82ff-0461a33143da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.671568 [ 267 ] {} TCP-Session: 5196033a-52ff-496e-a688-667cf3a2d34d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.671586 [ 266 ] {} TCP-Session: 0e5d9ab7-b968-4c0f-82ff-0461a33143da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.671622 [ 267 ] {} TCP-Session: 5196033a-52ff-496e-a688-667cf3a2d34d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.687981 [ 3 ] {a88df5a3-5dc7-4c02-9f08-f9c02ff63023} TCPHandler: Processed in 0.037412682 sec. 2024.12.21 08:14:42.688245 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.688588 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} executeQuery: (from [fd00:1122:3344:101::d]:57520) /* 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.21 08:14:42.688682 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool 2024.12.21 08:14:42.705718 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} oximeter.measurements_bool (862e8eba-562e-4700-8f06-ac02a71bb573): Loading data parts 2024.12.21 08:14:42.705999 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} oximeter.measurements_bool (862e8eba-562e-4700-8f06-ac02a71bb573): There are no data parts 2024.12.21 08:14:42.710542 [ 258 ] {4e7e5a48-ef9e-43f6-a704-dbf06292e171} TCPHandler: Processed in 0.02237223 sec. 2024.12.21 08:14:42.710750 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.710970 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.711018 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 2024.12.21 08:14:42.716953 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} oximeter.measurements_i8 (1b0195eb-eb2c-4c6e-8587-cd51a7f5981b): Loading data parts 2024.12.21 08:14:42.717124 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} oximeter.measurements_i8 (1b0195eb-eb2c-4c6e-8587-cd51a7f5981b): There are no data parts 2024.12.21 08:14:42.724888 [ 3 ] {190dfbf0-e10c-4a12-b9ae-5646777bd3e6} TCPHandler: Processed in 0.014195252 sec. 2024.12.21 08:14:42.725096 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.725289 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.725350 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 2024.12.21 08:14:42.730977 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} oximeter.measurements_u8 (d4cdfee9-7b23-4162-a10f-df8e63993c59): Loading data parts 2024.12.21 08:14:42.731160 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} oximeter.measurements_u8 (d4cdfee9-7b23-4162-a10f-df8e63993c59): There are no data parts 2024.12.21 08:14:42.738881 [ 258 ] {c815d7a0-0d29-4c83-a607-c9429351f440} TCPHandler: Processed in 0.013837707 sec. 2024.12.21 08:14:42.739078 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.739277 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.739328 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 2024.12.21 08:14:42.742032 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} oximeter.measurements_i16 (4cb14704-e3cc-4265-9b39-f945d0f5fc6e): Loading data parts 2024.12.21 08:14:42.742209 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} oximeter.measurements_i16 (4cb14704-e3cc-4265-9b39-f945d0f5fc6e): There are no data parts 2024.12.21 08:14:42.743505 [ 3 ] {a6cef16c-d215-4016-9e89-eb387ece04db} TCPHandler: Processed in 0.004480424 sec. 2024.12.21 08:14:42.743687 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.743881 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.743943 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 2024.12.21 08:14:42.756245 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} oximeter.measurements_u16 (9cd36132-2d3d-4e10-bac3-c096ab65bff7): Loading data parts 2024.12.21 08:14:42.756436 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} oximeter.measurements_u16 (9cd36132-2d3d-4e10-bac3-c096ab65bff7): There are no data parts 2024.12.21 08:14:42.759445 [ 258 ] {80ead3a1-5ec2-49cb-9bd6-fb6d60ddcf86} TCPHandler: Processed in 0.015811271 sec. 2024.12.21 08:14:42.759615 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.759805 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.759861 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 2024.12.21 08:14:42.762471 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} oximeter.measurements_i32 (53a5eae1-83b0-4cd7-9158-e1da2f0cf7de): Loading data parts 2024.12.21 08:14:42.762636 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} oximeter.measurements_i32 (53a5eae1-83b0-4cd7-9158-e1da2f0cf7de): There are no data parts 2024.12.21 08:14:42.763956 [ 3 ] {cfe817cd-e32a-4085-a138-12f10b798788} TCPHandler: Processed in 0.004394343 sec. 2024.12.21 08:14:42.764139 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.764381 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.764454 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 2024.12.21 08:14:42.778735 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} oximeter.measurements_u32 (fa24f4d2-fbf2-4abd-9ec9-8e5f0e2214ff): Loading data parts 2024.12.21 08:14:42.778929 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} oximeter.measurements_u32 (fa24f4d2-fbf2-4abd-9ec9-8e5f0e2214ff): There are no data parts 2024.12.21 08:14:42.786243 [ 258 ] {19137a06-2673-45f6-9c76-8bfb1deafc90} TCPHandler: Processed in 0.022166898 sec. 2024.12.21 08:14:42.786409 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.786598 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.786658 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 2024.12.21 08:14:42.792658 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} oximeter.measurements_i64 (af6cc4ae-b944-4ccc-bb0e-82fcc5873a50): Loading data parts 2024.12.21 08:14:42.792833 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} oximeter.measurements_i64 (af6cc4ae-b944-4ccc-bb0e-82fcc5873a50): There are no data parts 2024.12.21 08:14:42.796808 [ 3 ] {778fb3e8-5882-43ae-9fd7-9a331ec7cd1e} TCPHandler: Processed in 0.010451527 sec. 2024.12.21 08:14:42.796989 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.797198 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.797261 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 2024.12.21 08:14:42.799391 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} oximeter.measurements_u64 (738aab94-5281-4b88-a5e2-6b7c491a8edd): Loading data parts 2024.12.21 08:14:42.799567 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} oximeter.measurements_u64 (738aab94-5281-4b88-a5e2-6b7c491a8edd): There are no data parts 2024.12.21 08:14:42.811071 [ 258 ] {58084267-6a42-4f75-8302-0cab72aa929a} TCPHandler: Processed in 0.014136261 sec. 2024.12.21 08:14:42.811255 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.811447 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.811509 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 2024.12.21 08:14:42.815725 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} oximeter.measurements_f32 (3f6dc789-ab80-46ac-8ad2-42f618b82b04): Loading data parts 2024.12.21 08:14:42.815935 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} oximeter.measurements_f32 (3f6dc789-ab80-46ac-8ad2-42f618b82b04): There are no data parts 2024.12.21 08:14:42.819834 [ 3 ] {c624fb5c-1747-42f0-8419-01f607416cd9} TCPHandler: Processed in 0.008632804 sec. 2024.12.21 08:14:42.820016 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.820226 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.820289 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 2024.12.21 08:14:42.826845 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} oximeter.measurements_f64 (8427b0fc-9c7d-4dfc-a4bb-904a5459f6fc): Loading data parts 2024.12.21 08:14:42.827037 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} oximeter.measurements_f64 (8427b0fc-9c7d-4dfc-a4bb-904a5459f6fc): There are no data parts 2024.12.21 08:14:42.832319 [ 258 ] {3b5f8b7c-80fc-4264-af04-1905ddaaf4c7} TCPHandler: Processed in 0.012356369 sec. 2024.12.21 08:14:42.832497 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.832690 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.832752 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string 2024.12.21 08:14:42.841027 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} oximeter.measurements_string (24afa182-6736-4d70-b892-b04df9c172b1): Loading data parts 2024.12.21 08:14:42.841226 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} oximeter.measurements_string (24afa182-6736-4d70-b892-b04df9c172b1): There are no data parts 2024.12.21 08:14:42.845556 [ 3 ] {b50891b3-dd66-4448-9bb5-6c2311b9f155} TCPHandler: Processed in 0.013112168 sec. 2024.12.21 08:14:42.845738 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.845956 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.846023 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes 2024.12.21 08:14:42.848100 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} oximeter.measurements_bytes (efb16d15-c2a6-47ff-8fd8-a5e7a53d642d): Loading data parts 2024.12.21 08:14:42.848250 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} oximeter.measurements_bytes (efb16d15-c2a6-47ff-8fd8-a5e7a53d642d): There are no data parts 2024.12.21 08:14:42.861247 [ 258 ] {a2c9fd09-ec19-4318-ad5d-0a2eb664d92f} TCPHandler: Processed in 0.015561928 sec. 2024.12.21 08:14:42.861434 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.861643 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.861717 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 2024.12.21 08:14:42.863146 [ 269 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:34757 2024.12.21 08:14:42.863272 [ 269 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.863321 [ 269 ] {} TCP-Session: e9187fef-ea59-4001-aac3-3a00d2a61239 Authenticating user 'default' from [fd00:1122:3344:101::c]:34757 2024.12.21 08:14:42.863344 [ 269 ] {} TCP-Session: e9187fef-ea59-4001-aac3-3a00d2a61239 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.863359 [ 269 ] {} TCP-Session: e9187fef-ea59-4001-aac3-3a00d2a61239 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.863453 [ 269 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.21 08:14:42.863491 [ 269 ] {} 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.21 08:14:42.863536 [ 269 ] {} 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.21 08:14:42.864696 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} oximeter.measurements_cumulativei64 (46389ccd-dc88-404b-9488-c6a95c5e4974): Loading data parts 2024.12.21 08:14:42.864960 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} oximeter.measurements_cumulativei64 (46389ccd-dc88-404b-9488-c6a95c5e4974): There are no data parts 2024.12.21 08:14:42.865068 [ 270 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:55852 2024.12.21 08:14:42.865230 [ 270 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.865287 [ 271 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:61030 2024.12.21 08:14:42.865358 [ 272 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:40845 2024.12.21 08:14:42.865376 [ 270 ] {} TCP-Session: 918fd8a7-c5b7-4e23-9037-34a538a9f831 Authenticating user 'default' from [fd00:1122:3344:101::c]:55852 2024.12.21 08:14:42.865527 [ 270 ] {} TCP-Session: 918fd8a7-c5b7-4e23-9037-34a538a9f831 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.865596 [ 271 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.865637 [ 272 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.865683 [ 270 ] {} TCP-Session: 918fd8a7-c5b7-4e23-9037-34a538a9f831 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.865710 [ 271 ] {} TCP-Session: a7728dd4-5e10-414a-8de3-37c5a28f6c6c Authenticating user 'default' from [fd00:1122:3344:101::c]:61030 2024.12.21 08:14:42.865737 [ 272 ] {} TCP-Session: 250dec3f-a670-4247-81e7-aa825b25b643 Authenticating user 'default' from [fd00:1122:3344:101::c]:40845 2024.12.21 08:14:42.865722 [ 273 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:53193 2024.12.21 08:14:42.865764 [ 274 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:49830 2024.12.21 08:14:42.865806 [ 271 ] {} TCP-Session: a7728dd4-5e10-414a-8de3-37c5a28f6c6c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.865822 [ 272 ] {} TCP-Session: 250dec3f-a670-4247-81e7-aa825b25b643 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.865907 [ 275 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:64480 2024.12.21 08:14:42.865939 [ 272 ] {} TCP-Session: 250dec3f-a670-4247-81e7-aa825b25b643 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.865916 [ 271 ] {} TCP-Session: a7728dd4-5e10-414a-8de3-37c5a28f6c6c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.866135 [ 276 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:60783 2024.12.21 08:14:42.866255 [ 274 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.866251 [ 275 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.866421 [ 275 ] {} TCP-Session: ce360c63-f542-4c7a-aa3c-96f87a8f7ec1 Authenticating user 'default' from [fd00:1122:3344:101::c]:64480 2024.12.21 08:14:42.866420 [ 273 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.866468 [ 275 ] {} TCP-Session: ce360c63-f542-4c7a-aa3c-96f87a8f7ec1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.866450 [ 274 ] {} TCP-Session: 7a89eaf6-acc5-434f-a34b-91913a8325fb Authenticating user 'default' from [fd00:1122:3344:101::c]:49830 2024.12.21 08:14:42.866620 [ 273 ] {} TCP-Session: 4c5f26ba-0029-4366-bbf7-9c70c59bcd57 Authenticating user 'default' from [fd00:1122:3344:101::c]:53193 2024.12.21 08:14:42.866635 [ 276 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:42.866653 [ 275 ] {} TCP-Session: ce360c63-f542-4c7a-aa3c-96f87a8f7ec1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.866647 [ 274 ] {} TCP-Session: 7a89eaf6-acc5-434f-a34b-91913a8325fb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.866703 [ 276 ] {} TCP-Session: 5e8f9efa-17cf-4b84-8b2f-2b443eda6a26 Authenticating user 'default' from [fd00:1122:3344:101::c]:60783 2024.12.21 08:14:42.866685 [ 273 ] {} TCP-Session: 4c5f26ba-0029-4366-bbf7-9c70c59bcd57 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.866776 [ 274 ] {} TCP-Session: 7a89eaf6-acc5-434f-a34b-91913a8325fb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.866787 [ 276 ] {} TCP-Session: 5e8f9efa-17cf-4b84-8b2f-2b443eda6a26 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.866797 [ 273 ] {} TCP-Session: 4c5f26ba-0029-4366-bbf7-9c70c59bcd57 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.866848 [ 276 ] {} TCP-Session: 5e8f9efa-17cf-4b84-8b2f-2b443eda6a26 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:42.884127 [ 3 ] {70737eda-ece5-4c99-8117-a1a337decee8} TCPHandler: Processed in 0.022745545 sec. 2024.12.21 08:14:42.884373 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.884629 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.884723 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 2024.12.21 08:14:42.900134 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} oximeter.measurements_cumulativeu64 (d9a316ab-11dd-4407-8bbe-f6f4a92dbccc): Loading data parts 2024.12.21 08:14:42.900331 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} oximeter.measurements_cumulativeu64 (d9a316ab-11dd-4407-8bbe-f6f4a92dbccc): There are no data parts 2024.12.21 08:14:42.904610 [ 258 ] {0b04ee9e-3d63-43fa-91c9-f66d51984992} TCPHandler: Processed in 0.020307756 sec. 2024.12.21 08:14:42.904814 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.905014 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.905090 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 2024.12.21 08:14:42.917285 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} oximeter.measurements_cumulativef32 (8d5a8ab5-0778-419a-98d2-025e0b5b21ae): Loading data parts 2024.12.21 08:14:42.917468 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} oximeter.measurements_cumulativef32 (8d5a8ab5-0778-419a-98d2-025e0b5b21ae): There are no data parts 2024.12.21 08:14:42.924070 [ 3 ] {d6c7113f-b376-4ac1-8da4-b5601eacb77f} TCPHandler: Processed in 0.019311923 sec. 2024.12.21 08:14:42.924258 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.924482 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.924548 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 2024.12.21 08:14:42.930531 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} oximeter.measurements_cumulativef64 (4a2a3c7c-fdf5-4859-8bc1-e2d6a1e94aef): Loading data parts 2024.12.21 08:14:42.930702 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} oximeter.measurements_cumulativef64 (4a2a3c7c-fdf5-4859-8bc1-e2d6a1e94aef): There are no data parts 2024.12.21 08:14:42.937204 [ 258 ] {f48c7a4b-7f36-489e-977e-17f920578cdc} TCPHandler: Processed in 0.012999897 sec. 2024.12.21 08:14:42.937383 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.937669 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.937752 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 2024.12.21 08:14:42.946751 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} oximeter.measurements_histogrami8 (0ad3d64f-5f05-4ec4-9962-5cd69004693f): Loading data parts 2024.12.21 08:14:42.946958 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} oximeter.measurements_histogrami8 (0ad3d64f-5f05-4ec4-9962-5cd69004693f): There are no data parts 2024.12.21 08:14:42.963841 [ 3 ] {f9e18d32-b3fb-4527-88b4-f064830ca227} TCPHandler: Processed in 0.02651326 sec. 2024.12.21 08:14:42.964049 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.964353 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:42.964430 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 2024.12.21 08:14:42.968668 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} oximeter.measurements_histogramu8 (d9b08376-9816-4b82-8352-4f362587a544): Loading data parts 2024.12.21 08:14:42.968873 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} oximeter.measurements_histogramu8 (d9b08376-9816-4b82-8352-4f362587a544): There are no data parts 2024.12.21 08:14:42.984073 [ 258 ] {fc66cfc3-20f3-4659-9e0b-54c066d2d3dc} TCPHandler: Processed in 0.020078982 sec. 2024.12.21 08:14:42.984309 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:42.984583 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:42.984667 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 2024.12.21 08:14:43.000156 [ 247 ] {} AsynchronousMetrics: MemoryTracking: was 122.89 MiB, peak 122.89 MiB, free memory in arenas 0.00 B, will set to 135.04 MiB (RSS), difference: 12.14 MiB 2024.12.21 08:14:43.001502 [ 277 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:41405 2024.12.21 08:14:43.001619 [ 277 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.001645 [ 277 ] {} TCP-Session: 1324b0a6-a930-441d-b271-9370d3c0d295 Authenticating user 'default' from [fd00:1122:3344:101::a]:41405 2024.12.21 08:14:43.001667 [ 277 ] {} TCP-Session: 1324b0a6-a930-441d-b271-9370d3c0d295 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.001702 [ 277 ] {} TCP-Session: 1324b0a6-a930-441d-b271-9370d3c0d295 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.001755 [ 277 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.21 08:14:43.001777 [ 277 ] {} 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.21 08:14:43.001813 [ 277 ] {} 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.21 08:14:43.002818 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} oximeter.measurements_histogrami16 (1695ba8d-6698-418c-bf32-d7edbe6b13d5): Loading data parts 2024.12.21 08:14:43.003028 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} oximeter.measurements_histogrami16 (1695ba8d-6698-418c-bf32-d7edbe6b13d5): There are no data parts 2024.12.21 08:14:43.003343 [ 278 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:36113 2024.12.21 08:14:43.003522 [ 278 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.003580 [ 280 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:42119 2024.12.21 08:14:43.003598 [ 279 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:38749 2024.12.21 08:14:43.003607 [ 278 ] {} TCP-Session: 1c515b1a-88a4-493a-8ae3-c35c2965a731 Authenticating user 'default' from [fd00:1122:3344:101::a]:36113 2024.12.21 08:14:43.003816 [ 280 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.003879 [ 279 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.003885 [ 278 ] {} TCP-Session: 1c515b1a-88a4-493a-8ae3-c35c2965a731 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.003945 [ 279 ] {} TCP-Session: 0e8e983e-49a5-46c2-896c-4df5ebf9508d Authenticating user 'default' from [fd00:1122:3344:101::a]:38749 2024.12.21 08:14:43.003982 [ 282 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:42454 2024.12.21 08:14:43.003922 [ 281 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:40382 2024.12.21 08:14:43.004033 [ 279 ] {} TCP-Session: 0e8e983e-49a5-46c2-896c-4df5ebf9508d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.004019 [ 278 ] {} TCP-Session: 1c515b1a-88a4-493a-8ae3-c35c2965a731 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.003919 [ 280 ] {} TCP-Session: 8a5746bb-ce78-46e5-85f1-7f99eec81f28 Authenticating user 'default' from [fd00:1122:3344:101::a]:42119 2024.12.21 08:14:43.004335 [ 280 ] {} TCP-Session: 8a5746bb-ce78-46e5-85f1-7f99eec81f28 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.004341 [ 283 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:62736 2024.12.21 08:14:43.004370 [ 281 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.004387 [ 279 ] {} TCP-Session: 0e8e983e-49a5-46c2-896c-4df5ebf9508d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.004431 [ 280 ] {} TCP-Session: 8a5746bb-ce78-46e5-85f1-7f99eec81f28 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.004291 [ 282 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.004636 [ 281 ] {} TCP-Session: 7440d9d2-b44b-498f-a5a6-4d66ed9ac190 Authenticating user 'default' from [fd00:1122:3344:101::a]:40382 2024.12.21 08:14:43.004637 [ 283 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.004673 [ 282 ] {} TCP-Session: da024d18-ac3f-4647-acbb-06a16110bc1d Authenticating user 'default' from [fd00:1122:3344:101::a]:42454 2024.12.21 08:14:43.004751 [ 283 ] {} TCP-Session: 19b33c29-484a-4414-b03c-49df208aa426 Authenticating user 'default' from [fd00:1122:3344:101::a]:62736 2024.12.21 08:14:43.004787 [ 284 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:62764 2024.12.21 08:14:43.004780 [ 282 ] {} TCP-Session: da024d18-ac3f-4647-acbb-06a16110bc1d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.004844 [ 283 ] {} TCP-Session: 19b33c29-484a-4414-b03c-49df208aa426 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.004865 [ 282 ] {} TCP-Session: da024d18-ac3f-4647-acbb-06a16110bc1d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.004777 [ 281 ] {} TCP-Session: 7440d9d2-b44b-498f-a5a6-4d66ed9ac190 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.005009 [ 283 ] {} TCP-Session: 19b33c29-484a-4414-b03c-49df208aa426 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.005032 [ 281 ] {} TCP-Session: 7440d9d2-b44b-498f-a5a6-4d66ed9ac190 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.005004 [ 284 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.005152 [ 284 ] {} TCP-Session: d1d65e34-e2b8-4b24-ae64-a35769f6c1b7 Authenticating user 'default' from [fd00:1122:3344:101::a]:62764 2024.12.21 08:14:43.005176 [ 284 ] {} TCP-Session: d1d65e34-e2b8-4b24-ae64-a35769f6c1b7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.005231 [ 284 ] {} TCP-Session: d1d65e34-e2b8-4b24-ae64-a35769f6c1b7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.013175 [ 3 ] {06c49421-845e-4f0c-af47-ddc49d078021} TCPHandler: Processed in 0.028923399 sec. 2024.12.21 08:14:43.013459 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.013865 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.013945 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 2024.12.21 08:14:43.028977 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} oximeter.measurements_histogramu16 (cfec980c-c8ae-4415-8809-8f4858bff97f): Loading data parts 2024.12.21 08:14:43.029171 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} oximeter.measurements_histogramu16 (cfec980c-c8ae-4415-8809-8f4858bff97f): There are no data parts 2024.12.21 08:14:43.033885 [ 258 ] {ebb5941a-3d2a-4064-95c9-e381c917043c} TCPHandler: Processed in 0.020520318 sec. 2024.12.21 08:14:43.034106 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.034440 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:43.034534 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 2024.12.21 08:14:43.046811 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} oximeter.measurements_histogrami32 (6a1e991f-bced-49ee-b85a-ea714581cb80): Loading data parts 2024.12.21 08:14:43.047006 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} oximeter.measurements_histogrami32 (6a1e991f-bced-49ee-b85a-ea714581cb80): There are no data parts 2024.12.21 08:14:43.051528 [ 3 ] {99f30ebd-1dcb-4169-b332-9d70063847d2} TCPHandler: Processed in 0.017494012 sec. 2024.12.21 08:14:43.051758 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.052051 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.052123 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 2024.12.21 08:14:43.067068 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} oximeter.measurements_histogramu32 (aa5a9b7a-a60a-4a60-a3ce-efd707b4675c): Loading data parts 2024.12.21 08:14:43.067274 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} oximeter.measurements_histogramu32 (aa5a9b7a-a60a-4a60-a3ce-efd707b4675c): There are no data parts 2024.12.21 08:14:43.071682 [ 258 ] {e8f4e635-f2c7-4d41-86a1-a2fd028804c1} TCPHandler: Processed in 0.019978681 sec. 2024.12.21 08:14:43.071901 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.072171 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:43.072250 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 2024.12.21 08:14:43.084623 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} oximeter.measurements_histogrami64 (6b0524c2-5feb-4b2f-bcef-33ad29d55653): Loading data parts 2024.12.21 08:14:43.084947 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} oximeter.measurements_histogrami64 (6b0524c2-5feb-4b2f-bcef-33ad29d55653): There are no data parts 2024.12.21 08:14:43.089401 [ 3 ] {8fbba7dc-713c-400d-a781-b580bea5e549} TCPHandler: Processed in 0.017555303 sec. 2024.12.21 08:14:43.089613 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.089913 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.089987 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 2024.12.21 08:14:43.105024 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} oximeter.measurements_histogramu64 (1d816bec-bfdf-4b05-be1c-533fccb35687): Loading data parts 2024.12.21 08:14:43.105190 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} oximeter.measurements_histogramu64 (1d816bec-bfdf-4b05-be1c-533fccb35687): There are no data parts 2024.12.21 08:14:43.109533 [ 258 ] {678d407c-75c3-4ea9-bf98-9627d9265cea} TCPHandler: Processed in 0.019975211 sec. 2024.12.21 08:14:43.109720 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.109990 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:43.110070 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 2024.12.21 08:14:43.122721 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} oximeter.measurements_histogramf32 (d2d94269-7534-46e3-9710-70a458d40aa4): Loading data parts 2024.12.21 08:14:43.122949 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} oximeter.measurements_histogramf32 (d2d94269-7534-46e3-9710-70a458d40aa4): There are no data parts 2024.12.21 08:14:43.127604 [ 3 ] {b16fdad7-fb3d-40d2-800f-23b8e8d7ab22} TCPHandler: Processed in 0.017936597 sec. 2024.12.21 08:14:43.127830 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.128186 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.128270 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 2024.12.21 08:14:43.130757 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} oximeter.measurements_histogramf64 (74eeceea-464b-4f45-b091-07df227c6e07): Loading data parts 2024.12.21 08:14:43.130930 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} oximeter.measurements_histogramf64 (74eeceea-464b-4f45-b091-07df227c6e07): There are no data parts 2024.12.21 08:14:43.143548 [ 258 ] {d01b59ff-641a-4552-9794-e8efc3c0df6d} TCPHandler: Processed in 0.015782771 sec. 2024.12.21 08:14:43.143740 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.143938 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} executeQuery: (from [fd00:1122:3344:101::d]:53728) /* 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.21 08:14:43.144015 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool 2024.12.21 08:14:43.147991 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} oximeter.fields_bool (6b52f988-6a40-412e-92e4-e728b1e71ae7): Loading data parts 2024.12.21 08:14:43.148210 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} oximeter.fields_bool (6b52f988-6a40-412e-92e4-e728b1e71ae7): There are no data parts 2024.12.21 08:14:43.157306 [ 285 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:49581 2024.12.21 08:14:43.157428 [ 285 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.157454 [ 285 ] {} TCP-Session: 63cf5652-819e-4854-b891-310a7dfb9150 Authenticating user 'default' from [fd00:1122:3344:101::b]:49581 2024.12.21 08:14:43.157504 [ 285 ] {} TCP-Session: 63cf5652-819e-4854-b891-310a7dfb9150 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.157518 [ 285 ] {} TCP-Session: 63cf5652-819e-4854-b891-310a7dfb9150 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.157582 [ 285 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.12.21 08:14:43.157624 [ 285 ] {} 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.21 08:14:43.157643 [ 285 ] {} 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.21 08:14:43.159189 [ 286 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:36516 2024.12.21 08:14:43.159365 [ 286 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.159421 [ 287 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:49204 2024.12.21 08:14:43.159424 [ 288 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:49264 2024.12.21 08:14:43.159465 [ 286 ] {} TCP-Session: 892abc48-f4fc-4267-bc59-78f2fa5fc49d Authenticating user 'default' from [fd00:1122:3344:101::b]:36516 2024.12.21 08:14:43.159738 [ 286 ] {} TCP-Session: 892abc48-f4fc-4267-bc59-78f2fa5fc49d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.159742 [ 287 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.159742 [ 290 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:60374 2024.12.21 08:14:43.159811 [ 288 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.159563 [ 289 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:55859 2024.12.21 08:14:43.159859 [ 287 ] {} TCP-Session: 18aafa62-2736-4393-8bb6-50002a05c224 Authenticating user 'default' from [fd00:1122:3344:101::b]:49204 2024.12.21 08:14:43.159841 [ 286 ] {} TCP-Session: 892abc48-f4fc-4267-bc59-78f2fa5fc49d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160056 [ 291 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:56550 2024.12.21 08:14:43.160066 [ 287 ] {} TCP-Session: 18aafa62-2736-4393-8bb6-50002a05c224 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160159 [ 290 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.160238 [ 287 ] {} TCP-Session: 18aafa62-2736-4393-8bb6-50002a05c224 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160336 [ 288 ] {} TCP-Session: 940ec303-d091-4e1d-98cd-52dff6518072 Authenticating user 'default' from [fd00:1122:3344:101::b]:49264 2024.12.21 08:14:43.160379 [ 292 ] {} TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:42680 2024.12.21 08:14:43.160432 [ 291 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.160537 [ 288 ] {} TCP-Session: 940ec303-d091-4e1d-98cd-52dff6518072 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160569 [ 290 ] {} TCP-Session: f672971a-b89d-406c-a567-3844abe50de9 Authenticating user 'default' from [fd00:1122:3344:101::b]:60374 2024.12.21 08:14:43.160678 [ 289 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.160726 [ 291 ] {} TCP-Session: c3b0d24d-081b-48bd-a10e-62ce5b77759d Authenticating user 'default' from [fd00:1122:3344:101::b]:56550 2024.12.21 08:14:43.160773 [ 290 ] {} TCP-Session: f672971a-b89d-406c-a567-3844abe50de9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160794 [ 289 ] {} TCP-Session: a9fd4296-3201-46da-b833-f2b7d7fe9471 Authenticating user 'default' from [fd00:1122:3344:101::b]:55859 2024.12.21 08:14:43.160751 [ 292 ] {} TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. 2024.12.21 08:14:43.160745 [ 288 ] {} TCP-Session: 940ec303-d091-4e1d-98cd-52dff6518072 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160849 [ 291 ] {} TCP-Session: c3b0d24d-081b-48bd-a10e-62ce5b77759d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160900 [ 289 ] {} TCP-Session: a9fd4296-3201-46da-b833-f2b7d7fe9471 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160907 [ 290 ] {} TCP-Session: f672971a-b89d-406c-a567-3844abe50de9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160961 [ 291 ] {} TCP-Session: c3b0d24d-081b-48bd-a10e-62ce5b77759d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.161020 [ 289 ] {} TCP-Session: a9fd4296-3201-46da-b833-f2b7d7fe9471 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.160935 [ 292 ] {} TCP-Session: 2a327223-f05e-4702-9862-7212c5fd8222 Authenticating user 'default' from [fd00:1122:3344:101::b]:42680 2024.12.21 08:14:43.161183 [ 292 ] {} TCP-Session: 2a327223-f05e-4702-9862-7212c5fd8222 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.161242 [ 292 ] {} TCP-Session: 2a327223-f05e-4702-9862-7212c5fd8222 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.12.21 08:14:43.161519 [ 3 ] {ae4ac015-54b0-428c-90cb-4088d95fdc26} TCPHandler: Processed in 0.017834346 sec. 2024.12.21 08:14:43.161743 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.161984 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.162084 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 2024.12.21 08:14:43.181558 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} oximeter.fields_i8 (786e877c-c5e4-4e1b-a274-fb86ba5b15ff): Loading data parts 2024.12.21 08:14:43.181792 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} oximeter.fields_i8 (786e877c-c5e4-4e1b-a274-fb86ba5b15ff): There are no data parts 2024.12.21 08:14:43.186508 [ 258 ] {a0ac175b-fc48-4ca2-b499-49f001e01af3} TCPHandler: Processed in 0.024819981 sec. 2024.12.21 08:14:43.186711 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.186946 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:43.187014 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 2024.12.21 08:14:43.199239 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} oximeter.fields_u8 (97fff6cd-17f2-4950-b474-4f35dba5a01a): Loading data parts 2024.12.21 08:14:43.199496 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} oximeter.fields_u8 (97fff6cd-17f2-4950-b474-4f35dba5a01a): There are no data parts 2024.12.21 08:14:43.204251 [ 3 ] {350c6efa-386d-4dab-a561-f4968eb1891f} TCPHandler: Processed in 0.017622753 sec. 2024.12.21 08:14:43.204449 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.204645 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.204714 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 2024.12.21 08:14:43.219281 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} oximeter.fields_i16 (d1b38279-ba4f-4eae-8c53-fdee6982ff87): Loading data parts 2024.12.21 08:14:43.219517 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} oximeter.fields_i16 (d1b38279-ba4f-4eae-8c53-fdee6982ff87): There are no data parts 2024.12.21 08:14:43.222296 [ 258 ] {49c559d8-fec6-47c6-be90-a14db129f0ab} TCPHandler: Processed in 0.017902006 sec. 2024.12.21 08:14:43.222495 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.222719 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:43.222781 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 2024.12.21 08:14:43.238338 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} oximeter.fields_u16 (a499a5c3-9a96-4f73-9511-36feef801d32): Loading data parts 2024.12.21 08:14:43.238511 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} oximeter.fields_u16 (a499a5c3-9a96-4f73-9511-36feef801d32): There are no data parts 2024.12.21 08:14:43.243844 [ 3 ] {37052913-0b45-4e72-a30c-36f9de1178de} TCPHandler: Processed in 0.021410759 sec. 2024.12.21 08:14:43.244043 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.244231 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.244315 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 2024.12.21 08:14:43.261712 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} oximeter.fields_i32 (d4690000-2971-4edb-965d-2fdc0544aafd): Loading data parts 2024.12.21 08:14:43.261994 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} oximeter.fields_i32 (d4690000-2971-4edb-965d-2fdc0544aafd): There are no data parts 2024.12.21 08:14:43.284966 [ 258 ] {024a756b-ac7c-4e3c-b924-90e3ff7f4243} TCPHandler: Processed in 0.040976956 sec. 2024.12.21 08:14:43.285153 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.285378 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:43.285442 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 2024.12.21 08:14:43.290830 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} oximeter.fields_u32 (e71112b6-1b15-4450-a4ae-89ab415dd1dd): Loading data parts 2024.12.21 08:14:43.291008 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} oximeter.fields_u32 (e71112b6-1b15-4450-a4ae-89ab415dd1dd): There are no data parts 2024.12.21 08:14:43.305672 [ 3 ] {8e0cc5b4-bd3b-472e-9153-01fd3f6d7bbc} TCPHandler: Processed in 0.020572929 sec. 2024.12.21 08:14:43.305902 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.306098 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.306167 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 2024.12.21 08:14:43.309355 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} oximeter.fields_i64 (9eeeb106-2276-4a67-bee1-a97804ea7cac): Loading data parts 2024.12.21 08:14:43.309528 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} oximeter.fields_i64 (9eeeb106-2276-4a67-bee1-a97804ea7cac): There are no data parts 2024.12.21 08:14:43.325294 [ 258 ] {7573016f-bd16-4fd0-9a08-88411e4e7f5e} TCPHandler: Processed in 0.019435105 sec. 2024.12.21 08:14:43.325788 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.326232 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:43.326459 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 2024.12.21 08:14:43.417388 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} oximeter.fields_u64 (2f506b18-b675-4c6c-b8e9-71e0f7eec1f7): Loading data parts 2024.12.21 08:14:43.417632 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} oximeter.fields_u64 (2f506b18-b675-4c6c-b8e9-71e0f7eec1f7): There are no data parts 2024.12.21 08:14:43.495274 [ 3 ] {9063471e-5139-4469-8ba5-6c239793b06f} TCPHandler: Processed in 0.169715683 sec. 2024.12.21 08:14:43.495598 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.495921 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.496041 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr 2024.12.21 08:14:43.512273 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} oximeter.fields_ipaddr (e7e94254-0eb2-4c88-abec-66e60d25e04f): Loading data parts 2024.12.21 08:14:43.512474 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} oximeter.fields_ipaddr (e7e94254-0eb2-4c88-abec-66e60d25e04f): There are no data parts 2024.12.21 08:14:43.515000 [ 258 ] {d86948b9-6c09-4672-b4a4-0657ed2920aa} TCPHandler: Processed in 0.019549286 sec. 2024.12.21 08:14:43.515212 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.515440 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} executeQuery: (from [fd00:1122:3344:101::d]:53728) 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.21 08:14:43.515520 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string 2024.12.21 08:14:43.517473 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} oximeter.fields_string (1061e971-4762-452b-ac64-fea9f861c8b0): Loading data parts 2024.12.21 08:14:43.517717 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} oximeter.fields_string (1061e971-4762-452b-ac64-fea9f861c8b0): There are no data parts 2024.12.21 08:14:43.530718 [ 3 ] {44d303a2-1f6f-4e39-8c58-44fe432a3457} TCPHandler: Processed in 0.015562999 sec. 2024.12.21 08:14:43.530913 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.531118 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} executeQuery: (from [fd00:1122:3344:101::d]:57520) 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.21 08:14:43.531207 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid 2024.12.21 08:14:43.534225 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} oximeter.fields_uuid (0a924dbb-8700-41c3-9aeb-443f5622a9ab): Loading data parts 2024.12.21 08:14:43.534396 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} oximeter.fields_uuid (0a924dbb-8700-41c3-9aeb-443f5622a9ab): There are no data parts 2024.12.21 08:14:43.545960 [ 258 ] {aada351a-7ea3-4dfe-914d-d6ed091463d2} TCPHandler: Processed in 0.015102713 sec. 2024.12.21 08:14:43.546205 [ 3 ] {} TCP-Session: 45fdf5f9-159e-48de-b3b0-bf6f859133f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.546492 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} executeQuery: (from [fd00:1122:3344:101::d]:53728) /* 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.21 08:14:43.546590 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema 2024.12.21 08:14:43.549405 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} oximeter.timeseries_schema (c5c4abba-4e6e-4b03-8512-2b5b8b1f9c9c): Loading data parts 2024.12.21 08:14:43.549598 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} oximeter.timeseries_schema (c5c4abba-4e6e-4b03-8512-2b5b8b1f9c9c): There are no data parts 2024.12.21 08:14:43.561400 [ 3 ] {0fa016d9-657e-432a-ac9d-d2e55a017ea7} TCPHandler: Processed in 0.015250135 sec. 2024.12.21 08:14:43.561598 [ 258 ] {} TCP-Session: a4f15510-31f5-4a83-8fce-0969dba47e90 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.12.21 08:14:43.561820 [ 258 ] {49f16a07-dddd-45b1-8063-278f9229448a} executeQuery: (from [fd00:1122:3344:101::d]:57520) INSERT INTO oximeter.version (*) VALUES (stage: Complete) 2024.12.21 08:14:43.563054 [ 258 ] {49f16a07-dddd-45b1-8063-278f9229448a} ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version 2024.12.21 08:14:43.571289 [ 268 ] {49f16a07-dddd-45b1-8063-278f9229448a} oximeter.version (d34c5ef1-ce0f-4147-b76e-f668c6b48f34): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.21 08:14:43.571378 [ 268 ] {49f16a07-dddd-45b1-8063-278f9229448a} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. 2024.12.21 08:14:43.575958 [ 268 ] {49f16a07-dddd-45b1-8063-278f9229448a} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.21 08:14:43.576339 [ 268 ] {49f16a07-dddd-45b1-8063-278f9229448a} oximeter.version (d34c5ef1-ce0f-4147-b76e-f668c6b48f34): 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.21 08:14:43.576660 [ 258 ] {49f16a07-dddd-45b1-8063-278f9229448a} executeQuery: Read 1 rows, 16.00 B in 0.014911 sec., 67.06458319361545 rows/sec., 1.05 KiB/sec. 2024.12.21 08:14:43.576946 [ 258 ] {49f16a07-dddd-45b1-8063-278f9229448a} TCPHandler: Processed in 0.015403547 sec. 2024.12.21 08:14:44.000171 [ 247 ] {} AsynchronousMetrics: MemoryTracking: was 136.84 MiB, peak 136.84 MiB, free memory in arenas 0.00 B, will set to 141.49 MiB (RSS), difference: 4.65 MiB 2024.12.21 08:14:49.997490 [ 243 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 2024.12.21 08:14:49.997539 [ 244 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488 2024.12.21 08:14:49.997623 [ 243 ] {} SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog 2024.12.21 08:14:49.997669 [ 244 ] {} SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog 2024.12.21 08:14:50.009091 [ 244 ] {} system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Loading data parts 2024.12.21 08:14:50.009644 [ 244 ] {} system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): There are no data parts 2024.12.21 08:14:50.016601 [ 244 ] {} system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.21 08:14:50.016723 [ 244 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. 2024.12.21 08:14:50.019874 [ 244 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.21 08:14:50.020581 [ 244 ] {} system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): 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.21 08:14:50.021668 [ 244 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488 2024.12.21 08:14:50.023043 [ 243 ] {} system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Loading data parts 2024.12.21 08:14:50.023257 [ 243 ] {} system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): There are no data parts 2024.12.21 08:14:50.050724 [ 243 ] {} system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.21 08:14:50.050770 [ 243 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. 2024.12.21 08:14:50.058078 [ 243 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.21 08:14:50.058818 [ 243 ] {} system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): 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.21 08:14:50.061110 [ 243 ] {} SystemLog (system.metric_log): Flushed system log up to offset 8 2024.12.21 08:14:51.000186 [ 247 ] {} AsynchronousMetrics: MemoryTracking: was 146.72 MiB, peak 150.72 MiB, free memory in arenas 0.00 B, will set to 151.02 MiB (RSS), difference: 4.30 MiB 2024.12.21 08:14:52.497432 [ 242 ] {} SystemLog (system.query_log): Flushing system log, 90 entries to flush up to offset 90 2024.12.21 08:14:52.497553 [ 242 ] {} SystemLog (system.query_log): Creating new table system.query_log for QueryLog 2024.12.21 08:14:52.502747 [ 242 ] {} system.query_log (1c862e4c-f56f-4030-b77e-00d41791255b): Loading data parts 2024.12.21 08:14:52.502925 [ 242 ] {} system.query_log (1c862e4c-f56f-4030-b77e-00d41791255b): There are no data parts 2024.12.21 08:14:52.508743 [ 242 ] {} system.query_log (1c862e4c-f56f-4030-b77e-00d41791255b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.21 08:14:52.508784 [ 242 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. 2024.12.21 08:14:52.510424 [ 242 ] {} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.12.21 08:14:52.510727 [ 242 ] {} system.query_log (1c862e4c-f56f-4030-b77e-00d41791255b): 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.21 08:14:52.511227 [ 242 ] {} SystemLog (system.query_log): Flushed system log up to offset 90 2024.12.21 08:14:53.000186 [ 247 ] {} AsynchronousMetrics: MemoryTracking: was 155.20 MiB, peak 155.20 MiB, free memory in arenas 0.00 B, will set to 151.48 MiB (RSS), difference: -3.72 MiB 2024.12.21 08:14:57.455162 [ 117 ] {} DNSResolver: Updating DNS cache 2024.12.21 08:14:57.455232 [ 117 ] {} DNSResolver: Updated DNS cache 2024.12.21 08:14:57.521808 [ 244 ] {} SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 976 2024.12.21 08:14:57.522699 [ 244 ] {} system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.21 08:14:57.522738 [ 244 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. 2024.12.21 08:14:57.523277 [ 244 ] {} MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) 2024.12.21 08:14:57.523530 [ 244 ] {} system.asynchronous_metric_log (a8574c94-3e7a-40b0-bd70-b24e600e780e): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.21 08:14:57.523762 [ 244 ] {} SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 976 2024.12.21 08:14:57.561231 [ 243 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 16 2024.12.21 08:14:57.584183 [ 243 ] {} system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.12.21 08:14:57.584244 [ 243 ] {} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.86 GiB. 2024.12.21 08:14:57.591146 [ 243 ] {} MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) 2024.12.21 08:14:57.591876 [ 243 ] {} system.metric_log (235e1de5-1803-469e-9217-a6e9a35d6abc): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.12.21 08:14:57.594185 [ 243 ] {} SystemLog (system.metric_log): Flushed system log up to offset 16 2024.12.21 08:14:58.000164 [ 247 ] {} AsynchronousMetrics: MemoryTracking: was 152.16 MiB, peak 156.16 MiB, free memory in arenas 0.00 B, will set to 154.09 MiB (RSS), difference: 1.93 MiB