2024.10.09 22:55:33.949688 [ 1 ] {} Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: ), PID 23284 2024.10.09 22:55:33.949812 [ 1 ] {} Application: starting up 2024.10.09 22:55:33.949848 [ 1 ] {} Application: OS name: SunOS, version: 5.11, architecture: i86pc 2024.10.09 22:55:33.958201 [ 1 ] {} Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. 2024.10.09 22:55:33.960591 [ 1 ] {} Application: rlimit on number of file descriptors is 65536 2024.10.09 22:55:33.960621 [ 1 ] {} Application: Initializing DateLUT. 2024.10.09 22:55:33.960631 [ 1 ] {} Application: Initialized DateLUT with time zone 'UTC'. 2024.10.09 22:55:33.960673 [ 1 ] {} Context: Setting up /var/tmp/omicron_tmp/test_basic-bf0e85416c80c4ce-test_blueprint_edit.23235.1-clickhouse-lqtBRF/datastore/tmp/ to store temporary data in it 2024.10.09 22:55:33.961072 [ 1 ] {} Application: Initializing interserver credentials. 2024.10.09 22:55:33.961658 [ 1 ] {} ConfigReloader: Loading config 'config.xml' 2024.10.09 22:55:33.962013 [ 1 ] {} ConfigReloader: Loaded config 'config.xml', performing update on configuration 2024.10.09 22:55:33.962321 [ 1 ] {} Application: Setting max_server_memory_usage was set to 28.18 GiB (31.32 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) 2024.10.09 22:55:33.962333 [ 1 ] {} Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.66 GiB (31.32 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) 2024.10.09 22:55:33.962346 [ 1 ] {} Application: Merges and mutations memory limit is set to 15.66 GiB 2024.10.09 22:55:33.962403 [ 1 ] {} BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.09 22:55:33.963400 [ 1 ] {} BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads 2024.10.09 22:55:33.979934 [ 1 ] {} BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.09 22:55:33.981115 [ 1 ] {} BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads 2024.10.09 22:55:33.982295 [ 1 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.10.09 22:55:33.982366 [ 1 ] {} ConfigReloader: Loaded config 'config.xml', performed update on configuration 2024.10.09 22:55:33.983425 [ 1 ] {} ConfigReloader: Loading config 'config.xml' 2024.10.09 22:55:33.983947 [ 1 ] {} ConfigReloader: Loaded config 'config.xml', performing update on configuration 2024.10.09 22:55:33.984980 [ 1 ] {} ConfigReloader: Loaded config 'config.xml', performed update on configuration 2024.10.09 22:55:33.985318 [ 1 ] {} Access(user directories): Added users_xml access storage 'users_xml', path: config.xml 2024.10.09 22:55:33.986585 [ 1 ] {} Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin 2024.10.09 22:55:33.987306 [ 1 ] {} Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 2024.10.09 22:55:33.987915 [ 1 ] {} Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 2024.10.09 22:55:33.988621 [ 1 ] {} Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 2024.10.09 22:55:33.989929 [ 1 ] {} DNSCacheUpdater: Update period 15 seconds 2024.10.09 22:55:33.989971 [ 1 ] {} Application: Loading metadata from /var/tmp/omicron_tmp/test_basic-bf0e85416c80c4ce-test_blueprint_edit.23235.1-clickhouse-lqtBRF/datastore/ 2024.10.09 22:55:33.990005 [ 132 ] {} DNSResolver: Updating DNS cache 2024.10.09 22:55:33.990059 [ 132 ] {} DNSResolver: Updated DNS cache 2024.10.09 22:55:33.995094 [ 1 ] {} DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. 2024.10.09 22:55:33.995116 [ 1 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000116324 sec 2024.10.09 22:55:33.995136 [ 1 ] {} ReferentialDeps: No tables 2024.10.09 22:55:33.995143 [ 1 ] {} LoadingDeps: No tables 2024.10.09 22:55:33.995204 [ 1 ] {} DatabaseAtomic (system): Starting up tables. 2024.10.09 22:55:33.995250 [ 1 ] {} SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config 2024.10.09 22:55:33.995262 [ 1 ] {} SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config 2024.10.09 22:55:33.995281 [ 1 ] {} SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config 2024.10.09 22:55:33.995292 [ 1 ] {} SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config 2024.10.09 22:55:33.995300 [ 1 ] {} SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config 2024.10.09 22:55:33.995317 [ 1 ] {} SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config 2024.10.09 22:55:33.995325 [ 1 ] {} SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config 2024.10.09 22:55:33.995335 [ 1 ] {} SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config 2024.10.09 22:55:33.995354 [ 1 ] {} SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config 2024.10.09 22:55:33.995362 [ 1 ] {} SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config 2024.10.09 22:55:33.995373 [ 1 ] {} SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config 2024.10.09 22:55:33.995381 [ 1 ] {} SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config 2024.10.09 22:55:33.995394 [ 1 ] {} SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config 2024.10.09 22:55:33.995404 [ 1 ] {} SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config 2024.10.09 22:55:33.995421 [ 1 ] {} SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config 2024.10.09 22:55:33.995429 [ 1 ] {} SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config 2024.10.09 22:55:33.995440 [ 1 ] {} SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config 2024.10.09 22:55:34.026486 [ 1 ] {} DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. 2024.10.09 22:55:34.029799 [ 1 ] {} DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. 2024.10.09 22:55:34.029842 [ 1 ] {} TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.7056e-05 sec 2024.10.09 22:55:34.029931 [ 1 ] {} ReferentialDeps: No tables 2024.10.09 22:55:34.029942 [ 1 ] {} LoadingDeps: No tables 2024.10.09 22:55:34.029968 [ 1 ] {} DatabaseAtomic (default): Starting up tables. 2024.10.09 22:55:34.030761 [ 1 ] {} UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_basic-bf0e85416c80c4ce-test_blueprint_edit.23235.1-clickhouse-lqtBRF/datastore/user_defined/ 2024.10.09 22:55:34.030955 [ 1 ] {} UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded 2024.10.09 22:55:34.030999 [ 1 ] {} Application: Loaded metadata. 2024.10.09 22:55:34.031015 [ 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.10.09 22:55:34.031110 [ 1 ] {} Application: TaskStats is not implemented for this OS. IO accounting will be disabled. 2024.10.09 22:55:34.031540 [ 1 ] {} Application: Requested any available port (port == 0), actual port is 64588 2024.10.09 22:55:34.031772 [ 1 ] {} Application: Requested any available port (port == 0), actual port is 50790 2024.10.09 22:55:34.033342 [ 1 ] {} MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1) 2024.10.09 22:55:34.114298 [ 1 ] {} MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1) 2024.10.09 22:55:34.114333 [ 1 ] {} MySQLHandlerFactory: Generating new RSA key pair. 2024.10.09 22:55:34.193186 [ 1 ] {} Application: Requested any available port (port == 0), actual port is 50169 2024.10.09 22:55:34.193274 [ 1 ] {} Application: Requested any available port (port == 0), actual port is 64152 2024.10.09 22:55:34.193354 [ 1 ] {} MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1) 2024.10.09 22:55:34.232156 [ 1 ] {} MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1) 2024.10.09 22:55:34.232198 [ 1 ] {} MySQLHandlerFactory: Generating new RSA key pair. 2024.10.09 22:55:34.472619 [ 1 ] {} CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. 2024.10.09 22:55:34.472896 [ 1 ] {} AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.08 MiB, free memory in arenas 0.00 B, will set to 170.77 MiB (RSS), difference: 160.90 MiB 2024.10.09 22:55:34.473203 [ 1 ] {} AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.3389e-05 sec. 2024.10.09 22:55:34.473741 [ 1 ] {} Application: Listening for http://[::1]:64588 2024.10.09 22:55:34.473820 [ 1 ] {} Application: Listening for native protocol (tcp): [::1]:50790 2024.10.09 22:55:34.473891 [ 1 ] {} Application: Listening for MySQL compatibility protocol: [::1]:9004 2024.10.09 22:55:34.473979 [ 1 ] {} Application: Listening for http://127.0.0.1:50169 2024.10.09 22:55:34.474079 [ 1 ] {} Application: Listening for native protocol (tcp): 127.0.0.1:64152 2024.10.09 22:55:34.474168 [ 1 ] {} Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004 2024.10.09 22:55:34.474192 [ 1 ] {} Application: Ready for connections. 2024.10.09 22:55:41.527067 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.527312 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.527361 [ 3 ] {} HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.527413 [ 3 ] {} HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.527430 [ 3 ] {} HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.527546 [ 3 ] {} ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false 2024.10.09 22:55:41.527602 [ 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.10.09 22:55:41.527622 [ 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.10.09 22:55:41.527690 [ 3 ] {} HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.528304 [ 3 ] {cb42f087-aedf-4666-8e6f-3068e21ab79d} executeQuery: (from [::1]:33250) SELECT MAX(value) FROM oximeter.version; (stage: Complete) 2024.10.09 22:55:41.536477 [ 3 ] {cb42f087-aedf-4666-8e6f-3068e21ab79d} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:33250) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr, std::function, std::optional const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 2024.10.09 22:55:41.536722 [ 3 ] {cb42f087-aedf-4666-8e6f-3068e21ab79d} DynamicQueryHandler: 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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr, std::function, std::optional const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 (version 23.8.7.1) 2024.10.09 22:55:41.537054 [ 3 ] {} HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.538279 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.538376 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.538454 [ 3 ] {} HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.538484 [ 3 ] {} HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.538522 [ 3 ] {} HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.538573 [ 3 ] {} HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.538796 [ 3 ] {e1b1eb1d-bf82-47e4-bd41-fc7495876555} executeQuery: (from [::1]:33250) SELECT MAX(value) FROM oximeter.version; (stage: Complete) 2024.10.09 22:55:41.539147 [ 3 ] {e1b1eb1d-bf82-47e4-bd41-fc7495876555} executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:33250) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr, std::function, std::optional const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 2024.10.09 22:55:41.539301 [ 3 ] {e1b1eb1d-bf82-47e4-bd41-fc7495876555} DynamicQueryHandler: 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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 2. DB::Exception::Exception, std::allocator > >(int, FormatStringHelperImpl, std::allocator > >::type>, std::__cxx11::basic_string, std::allocator >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string, std::allocator > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr const&, std::vector, std::allocator >, std::allocator, std::allocator > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/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 /work/oxidecomputer/omicron/out/clickhouse/clickhouse 11. DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr, std::function, std::optional const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 (version 23.8.7.1) 2024.10.09 22:55:41.539501 [ 3 ] {} HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.540659 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.540735 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.540757 [ 3 ] {} HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.540773 [ 3 ] {} HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.540794 [ 3 ] {} HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.540831 [ 3 ] {} HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.541059 [ 3 ] {1f08e7b2-8b3f-492b-b05b-7b0e220a45c6} executeQuery: (from [::1]:33250) DROP DATABASE IF EXISTS oximeter (stage: Complete) 2024.10.09 22:55:41.541375 [ 3 ] {1f08e7b2-8b3f-492b-b05b-7b0e220a45c6} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.541447 [ 3 ] {} HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.544721 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.544845 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.544874 [ 3 ] {} HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.544892 [ 3 ] {} HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.544914 [ 3 ] {} HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.544976 [ 3 ] {} HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.545105 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} executeQuery: (from [::1]:33250) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) 2024.10.09 22:55:41.545185 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* 2024.10.09 22:55:41.546654 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. 2024.10.09 22:55:41.546678 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.3758e-05 sec 2024.10.09 22:55:41.546712 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} ReferentialDeps: No tables 2024.10.09 22:55:41.546724 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} LoadingDeps: No tables 2024.10.09 22:55:41.546747 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} DatabaseAtomic (oximeter): Starting up tables. 2024.10.09 22:55:41.546896 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.546928 [ 3 ] {} HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.549746 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.549806 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.549855 [ 3 ] {} HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.549875 [ 3 ] {} HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.549891 [ 3 ] {} HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.549973 [ 3 ] {} HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.550679 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} executeQuery: (from [::1]:33250) /* 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.10.09 22:55:41.550775 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version 2024.10.09 22:55:41.552487 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} StoragePolicy (default): Storage policy default created, total volumes 1 2024.10.09 22:55:41.554244 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} oximeter.version (fcc73285-839e-4734-a652-af3fe4b1b91e): Loading data parts 2024.10.09 22:55:41.555819 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} oximeter.version (fcc73285-839e-4734-a652-af3fe4b1b91e): There are no data parts 2024.10.09 22:55:41.557813 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.557840 [ 3 ] {} HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.559381 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.559444 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.559510 [ 3 ] {} HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.559540 [ 3 ] {} HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.559557 [ 3 ] {} HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.559597 [ 3 ] {} HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.559860 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} executeQuery: (from [::1]:33250) /* 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(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) 2024.10.09 22:55:41.559957 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool 2024.10.09 22:55:41.562428 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} oximeter.measurements_bool (8c3fc2e4-d5ad-44e4-9d62-9c8d0ae921a7): Loading data parts 2024.10.09 22:55:41.562740 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} oximeter.measurements_bool (8c3fc2e4-d5ad-44e4-9d62-9c8d0ae921a7): There are no data parts 2024.10.09 22:55:41.564347 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.564386 [ 3 ] {} HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.566335 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.566399 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.566433 [ 3 ] {} HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.566455 [ 3 ] {} HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.566470 [ 3 ] {} HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.566519 [ 3 ] {} HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.566825 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.566903 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 2024.10.09 22:55:41.569087 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} oximeter.measurements_i8 (9d5b4d2d-e744-44f6-a846-54700ed93cf2): Loading data parts 2024.10.09 22:55:41.569377 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} oximeter.measurements_i8 (9d5b4d2d-e744-44f6-a846-54700ed93cf2): There are no data parts 2024.10.09 22:55:41.571206 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.571232 [ 3 ] {} HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.575443 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.575571 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.575601 [ 3 ] {} HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.575624 [ 3 ] {} HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.575652 [ 3 ] {} HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.575696 [ 3 ] {} HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.575966 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.576034 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 2024.10.09 22:55:41.578267 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} oximeter.measurements_u8 (b8b0a85b-60bd-4c12-b177-c5a6a005db57): Loading data parts 2024.10.09 22:55:41.578549 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} oximeter.measurements_u8 (b8b0a85b-60bd-4c12-b177-c5a6a005db57): There are no data parts 2024.10.09 22:55:41.580180 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.580213 [ 3 ] {} HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.583524 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.583594 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.583625 [ 3 ] {} HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.583646 [ 3 ] {} HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.583661 [ 3 ] {} HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.583703 [ 3 ] {} HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.583967 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.584032 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 2024.10.09 22:55:41.586188 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} oximeter.measurements_i16 (07890d97-3c17-41c7-a400-31a6454bb616): Loading data parts 2024.10.09 22:55:41.586432 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} oximeter.measurements_i16 (07890d97-3c17-41c7-a400-31a6454bb616): There are no data parts 2024.10.09 22:55:41.588610 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.588638 [ 3 ] {} HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.592629 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.592805 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.592833 [ 3 ] {} HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.592852 [ 3 ] {} HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.592876 [ 3 ] {} HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.592914 [ 3 ] {} HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.601454 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.601577 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 2024.10.09 22:55:41.603694 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} oximeter.measurements_u16 (a12119ac-1a35-4181-a502-c4e3a18a86a5): Loading data parts 2024.10.09 22:55:41.604036 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} oximeter.measurements_u16 (a12119ac-1a35-4181-a502-c4e3a18a86a5): There are no data parts 2024.10.09 22:55:41.605576 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.605602 [ 3 ] {} HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.606403 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.606539 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.606579 [ 3 ] {} HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.606628 [ 3 ] {} HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.606642 [ 3 ] {} HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.606680 [ 3 ] {} HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.606969 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.607036 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 2024.10.09 22:55:41.609188 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} oximeter.measurements_i32 (02695081-6199-46ad-a200-11203d5df21e): Loading data parts 2024.10.09 22:55:41.609451 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} oximeter.measurements_i32 (02695081-6199-46ad-a200-11203d5df21e): There are no data parts 2024.10.09 22:55:41.611206 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.611232 [ 3 ] {} HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.611747 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.611814 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.611837 [ 3 ] {} HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.611856 [ 3 ] {} HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.611866 [ 3 ] {} HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.611900 [ 3 ] {} HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.612112 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.612165 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 2024.10.09 22:55:41.613969 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} oximeter.measurements_u32 (0fc7ac17-3c2b-4a70-92cd-292b986d9307): Loading data parts 2024.10.09 22:55:41.614281 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} oximeter.measurements_u32 (0fc7ac17-3c2b-4a70-92cd-292b986d9307): There are no data parts 2024.10.09 22:55:41.615940 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.615964 [ 3 ] {} HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.616496 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.616571 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.616595 [ 3 ] {} HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.616622 [ 3 ] {} HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.616638 [ 3 ] {} HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.616676 [ 3 ] {} HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.616940 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.616994 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 2024.10.09 22:55:41.619174 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} oximeter.measurements_i64 (e2e9aa12-bb57-4a2a-aaae-3d0866d536d1): Loading data parts 2024.10.09 22:55:41.619460 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} oximeter.measurements_i64 (e2e9aa12-bb57-4a2a-aaae-3d0866d536d1): There are no data parts 2024.10.09 22:55:41.621060 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.621127 [ 3 ] {} HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.621531 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.621580 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.621604 [ 3 ] {} HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.621618 [ 3 ] {} HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.621628 [ 3 ] {} HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.621666 [ 3 ] {} HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.621856 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.621903 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 2024.10.09 22:55:41.623815 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} oximeter.measurements_u64 (83fb8ff2-a618-4de5-82e1-2d80bf206a8f): Loading data parts 2024.10.09 22:55:41.624088 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} oximeter.measurements_u64 (83fb8ff2-a618-4de5-82e1-2d80bf206a8f): There are no data parts 2024.10.09 22:55:41.625722 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.625747 [ 3 ] {} HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.626228 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.626352 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.626374 [ 3 ] {} HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.626393 [ 3 ] {} HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.626417 [ 3 ] {} HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.626452 [ 3 ] {} HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.626701 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.626766 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 2024.10.09 22:55:41.629022 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} oximeter.measurements_f32 (d3c26788-af2a-425b-ba47-b41654f63e6c): Loading data parts 2024.10.09 22:55:41.629733 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} oximeter.measurements_f32 (d3c26788-af2a-425b-ba47-b41654f63e6c): There are no data parts 2024.10.09 22:55:41.631426 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.631481 [ 3 ] {} HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.632501 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.632557 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.632585 [ 3 ] {} HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.632604 [ 3 ] {} HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.632617 [ 3 ] {} HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.632653 [ 3 ] {} HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.633500 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.633636 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 2024.10.09 22:55:41.636162 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} oximeter.measurements_f64 (78c03f87-9f53-4fba-ab08-5504e9cb2fda): Loading data parts 2024.10.09 22:55:41.636436 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} oximeter.measurements_f64 (78c03f87-9f53-4fba-ab08-5504e9cb2fda): There are no data parts 2024.10.09 22:55:41.638167 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.638194 [ 3 ] {} HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.639165 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.639269 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.639295 [ 3 ] {} HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.639314 [ 3 ] {} HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.639341 [ 3 ] {} HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.639398 [ 3 ] {} HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.639597 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.639665 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string 2024.10.09 22:55:41.643434 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} oximeter.measurements_string (b9d61580-a40a-49ad-9fa1-5073eae36896): Loading data parts 2024.10.09 22:55:41.643766 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} oximeter.measurements_string (b9d61580-a40a-49ad-9fa1-5073eae36896): There are no data parts 2024.10.09 22:55:41.646489 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.646518 [ 3 ] {} HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.650506 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.650948 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.650982 [ 3 ] {} HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.651158 [ 3 ] {} HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.651223 [ 3 ] {} HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.651281 [ 3 ] {} HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.651890 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.651983 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes 2024.10.09 22:55:41.655701 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} oximeter.measurements_bytes (1787bff8-de9f-4e90-994e-134e9e9a99e5): Loading data parts 2024.10.09 22:55:41.656289 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} oximeter.measurements_bytes (1787bff8-de9f-4e90-994e-134e9e9a99e5): There are no data parts 2024.10.09 22:55:41.658204 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.658231 [ 3 ] {} HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.659727 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.659790 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.659810 [ 3 ] {} HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.659846 [ 3 ] {} HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.659860 [ 3 ] {} HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.659950 [ 3 ] {} HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.660248 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.660354 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 2024.10.09 22:55:41.662585 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} oximeter.measurements_cumulativei64 (d3f9e3b8-9c91-4856-88d5-70d8d9fa4b9f): Loading data parts 2024.10.09 22:55:41.662903 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} oximeter.measurements_cumulativei64 (d3f9e3b8-9c91-4856-88d5-70d8d9fa4b9f): There are no data parts 2024.10.09 22:55:41.664937 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.664966 [ 3 ] {} HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.666133 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.666317 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.666348 [ 3 ] {} HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.666370 [ 3 ] {} HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.666397 [ 3 ] {} HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.666439 [ 3 ] {} HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.666743 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.666844 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 2024.10.09 22:55:41.670707 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} oximeter.measurements_cumulativeu64 (a7ad0f82-8a7c-42a0-912f-74f079bcb834): Loading data parts 2024.10.09 22:55:41.671065 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} oximeter.measurements_cumulativeu64 (a7ad0f82-8a7c-42a0-912f-74f079bcb834): There are no data parts 2024.10.09 22:55:41.673128 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.673174 [ 3 ] {} HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.677562 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.677637 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.677680 [ 3 ] {} HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.677706 [ 3 ] {} HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.677721 [ 3 ] {} HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.677778 [ 3 ] {} HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.678309 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.678394 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 2024.10.09 22:55:41.683247 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} oximeter.measurements_cumulativef32 (d361cd63-5409-4772-8694-a1e356ae217a): Loading data parts 2024.10.09 22:55:41.683596 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} oximeter.measurements_cumulativef32 (d361cd63-5409-4772-8694-a1e356ae217a): There are no data parts 2024.10.09 22:55:41.686705 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.686735 [ 3 ] {} HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.688215 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.688372 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.688440 [ 3 ] {} HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.688507 [ 3 ] {} HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.688609 [ 3 ] {} HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.688668 [ 3 ] {} HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.688996 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.689334 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 2024.10.09 22:55:41.691976 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} oximeter.measurements_cumulativef64 (4b7d39e3-662a-4cbf-b375-5bf4c51500e0): Loading data parts 2024.10.09 22:55:41.692300 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} oximeter.measurements_cumulativef64 (4b7d39e3-662a-4cbf-b375-5bf4c51500e0): There are no data parts 2024.10.09 22:55:41.694485 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.694514 [ 3 ] {} HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.699662 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.699757 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.699782 [ 3 ] {} HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.699807 [ 3 ] {} HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.699820 [ 3 ] {} HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.699877 [ 3 ] {} HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.700315 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.700408 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 2024.10.09 22:55:41.703102 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} oximeter.measurements_histogrami8 (e562d6a8-a28f-4ce4-b975-73f6ccd65ea3): Loading data parts 2024.10.09 22:55:41.703431 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} oximeter.measurements_histogrami8 (e562d6a8-a28f-4ce4-b975-73f6ccd65ea3): There are no data parts 2024.10.09 22:55:41.704963 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.704989 [ 3 ] {} HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.707973 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.708064 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.708094 [ 3 ] {} HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.708116 [ 3 ] {} HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.708144 [ 3 ] {} HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.708191 [ 3 ] {} HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.708591 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.708664 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 2024.10.09 22:55:41.711123 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} oximeter.measurements_histogramu8 (be25e011-6d4b-40ae-aaf6-e373e87318c7): Loading data parts 2024.10.09 22:55:41.711426 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} oximeter.measurements_histogramu8 (be25e011-6d4b-40ae-aaf6-e373e87318c7): There are no data parts 2024.10.09 22:55:41.713597 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.713632 [ 3 ] {} HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.715570 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.715627 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.715655 [ 3 ] {} HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.715671 [ 3 ] {} HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.715683 [ 3 ] {} HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.715723 [ 3 ] {} HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.716110 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.716179 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 2024.10.09 22:55:41.718674 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} oximeter.measurements_histogrami16 (e09dfd1c-b2c9-4817-b0a7-17fb097d5802): Loading data parts 2024.10.09 22:55:41.718920 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} oximeter.measurements_histogrami16 (e09dfd1c-b2c9-4817-b0a7-17fb097d5802): There are no data parts 2024.10.09 22:55:41.720580 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.720602 [ 3 ] {} HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.782789 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.783051 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.783086 [ 3 ] {} HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.783118 [ 3 ] {} HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.783159 [ 3 ] {} HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.783217 [ 3 ] {} HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.783761 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.783867 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 2024.10.09 22:55:41.787948 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} oximeter.measurements_histogramu16 (caa8ba1b-044e-4a0b-9546-dfd2c8a7da96): Loading data parts 2024.10.09 22:55:41.788359 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} oximeter.measurements_histogramu16 (caa8ba1b-044e-4a0b-9546-dfd2c8a7da96): There are no data parts 2024.10.09 22:55:41.790440 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.790481 [ 3 ] {} HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.799213 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.799327 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.799356 [ 3 ] {} HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.799401 [ 3 ] {} HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.799417 [ 3 ] {} HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.799539 [ 3 ] {} HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.800439 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.800960 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 2024.10.09 22:55:41.804836 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} oximeter.measurements_histogrami32 (2ee06efc-1459-49c0-9c89-f9b572f5b35f): Loading data parts 2024.10.09 22:55:41.805113 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} oximeter.measurements_histogrami32 (2ee06efc-1459-49c0-9c89-f9b572f5b35f): There are no data parts 2024.10.09 22:55:41.807622 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.807655 [ 3 ] {} HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.808918 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.809132 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.809165 [ 3 ] {} HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.809186 [ 3 ] {} HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.809207 [ 3 ] {} HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.809320 [ 3 ] {} HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.809811 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.810271 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 2024.10.09 22:55:41.814253 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} oximeter.measurements_histogramu32 (a8ac0791-1f74-4264-9902-b3f9217f6d6d): Loading data parts 2024.10.09 22:55:41.814721 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} oximeter.measurements_histogramu32 (a8ac0791-1f74-4264-9902-b3f9217f6d6d): There are no data parts 2024.10.09 22:55:41.816798 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.816824 [ 3 ] {} HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.819337 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.819495 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.819525 [ 3 ] {} HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.819565 [ 3 ] {} HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.819580 [ 3 ] {} HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.819630 [ 3 ] {} HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.820203 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.820324 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 2024.10.09 22:55:41.823176 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} oximeter.measurements_histogrami64 (79fd0448-5740-48f8-a4a3-458ee231c737): Loading data parts 2024.10.09 22:55:41.823523 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} oximeter.measurements_histogrami64 (79fd0448-5740-48f8-a4a3-458ee231c737): There are no data parts 2024.10.09 22:55:41.825334 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.825427 [ 3 ] {} HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.826070 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.826132 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.826164 [ 3 ] {} HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.826186 [ 3 ] {} HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.826198 [ 3 ] {} HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.826248 [ 3 ] {} HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.826631 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.826767 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 2024.10.09 22:55:41.829945 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} oximeter.measurements_histogramu64 (c1fb6300-d85c-4c42-b202-aa0647cf61f0): Loading data parts 2024.10.09 22:55:41.830434 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} oximeter.measurements_histogramu64 (c1fb6300-d85c-4c42-b202-aa0647cf61f0): There are no data parts 2024.10.09 22:55:41.832324 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.832356 [ 3 ] {} HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.833180 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.833330 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.833359 [ 3 ] {} HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.833383 [ 3 ] {} HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.833413 [ 3 ] {} HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.833459 [ 3 ] {} HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.834135 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.834479 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 2024.10.09 22:55:41.837629 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} oximeter.measurements_histogramf32 (16d66e33-0b7c-4d24-be1b-64a6d2bd4566): Loading data parts 2024.10.09 22:55:41.837915 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} oximeter.measurements_histogramf32 (16d66e33-0b7c-4d24-be1b-64a6d2bd4566): There are no data parts 2024.10.09 22:55:41.839898 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.840005 [ 3 ] {} HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.840692 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.840749 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.840827 [ 3 ] {} HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.840849 [ 3 ] {} HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.840859 [ 3 ] {} HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.840920 [ 3 ] {} HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.841351 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.841449 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 2024.10.09 22:55:41.844457 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} oximeter.measurements_histogramf64 (808318be-2f94-4db2-ac81-570104f3ae88): Loading data parts 2024.10.09 22:55:41.844775 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} oximeter.measurements_histogramf64 (808318be-2f94-4db2-ac81-570104f3ae88): There are no data parts 2024.10.09 22:55:41.846823 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.846855 [ 3 ] {} HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.848120 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.848249 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.848274 [ 3 ] {} HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.848299 [ 3 ] {} HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.848325 [ 3 ] {} HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.848372 [ 3 ] {} HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.848614 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} executeQuery: (from [::1]:33250) /* 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 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.10.09 22:55:41.848723 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool 2024.10.09 22:55:41.851248 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} oximeter.fields_bool (03b31b64-8ac4-408a-9ffb-922a41d4d9bb): Loading data parts 2024.10.09 22:55:41.851537 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} oximeter.fields_bool (03b31b64-8ac4-408a-9ffb-922a41d4d9bb): There are no data parts 2024.10.09 22:55:41.853147 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.853194 [ 3 ] {} HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.853824 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.853889 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.853912 [ 3 ] {} HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.854007 [ 3 ] {} HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.854022 [ 3 ] {} HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.854062 [ 3 ] {} HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.854371 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.854432 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 2024.10.09 22:55:41.856781 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} oximeter.fields_i8 (efc11e9f-db80-457e-bc37-c0403686a281): Loading data parts 2024.10.09 22:55:41.857090 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} oximeter.fields_i8 (efc11e9f-db80-457e-bc37-c0403686a281): There are no data parts 2024.10.09 22:55:41.858846 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.858948 [ 3 ] {} HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.859500 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.859626 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.859756 [ 3 ] {} HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.859781 [ 3 ] {} HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.859797 [ 3 ] {} HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.859849 [ 3 ] {} HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.860113 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.860178 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 2024.10.09 22:55:41.862561 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} oximeter.fields_u8 (e3bfbcb7-89df-464b-948e-dff70951e494): Loading data parts 2024.10.09 22:55:41.862834 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} oximeter.fields_u8 (e3bfbcb7-89df-464b-948e-dff70951e494): There are no data parts 2024.10.09 22:55:41.864594 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.864627 [ 3 ] {} HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.865309 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.865443 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.865465 [ 3 ] {} HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.865491 [ 3 ] {} HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.865515 [ 3 ] {} HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.865551 [ 3 ] {} HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.866244 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.866308 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 2024.10.09 22:55:41.869133 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} oximeter.fields_i16 (8516586c-c896-49e3-9d53-7d9ee3c81c54): Loading data parts 2024.10.09 22:55:41.869394 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} oximeter.fields_i16 (8516586c-c896-49e3-9d53-7d9ee3c81c54): There are no data parts 2024.10.09 22:55:41.871303 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.871378 [ 3 ] {} HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.872145 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.872210 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.872323 [ 3 ] {} HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.872351 [ 3 ] {} HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.872366 [ 3 ] {} HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.872425 [ 3 ] {} HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.872844 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.872927 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 2024.10.09 22:55:41.875614 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} oximeter.fields_u16 (b6ed26de-9e6a-40cf-9f27-2fb4a3df9767): Loading data parts 2024.10.09 22:55:41.875962 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} oximeter.fields_u16 (b6ed26de-9e6a-40cf-9f27-2fb4a3df9767): There are no data parts 2024.10.09 22:55:41.877741 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.877770 [ 3 ] {} HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.878315 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.878440 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.878467 [ 3 ] {} HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.878486 [ 3 ] {} HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.878574 [ 3 ] {} HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.878614 [ 3 ] {} HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.878924 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.879002 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 2024.10.09 22:55:41.881212 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} oximeter.fields_i32 (52047e55-858e-4489-b426-b63002d8587f): Loading data parts 2024.10.09 22:55:41.881671 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} oximeter.fields_i32 (52047e55-858e-4489-b426-b63002d8587f): There are no data parts 2024.10.09 22:55:41.883319 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.883441 [ 3 ] {} HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.884143 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.884267 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.884321 [ 3 ] {} HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.884342 [ 3 ] {} HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.884358 [ 3 ] {} HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.884409 [ 3 ] {} HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.884758 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.884934 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 2024.10.09 22:55:41.887710 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} oximeter.fields_u32 (0aa338a0-4c78-4185-87d6-402c0b9ee35f): Loading data parts 2024.10.09 22:55:41.887956 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} oximeter.fields_u32 (0aa338a0-4c78-4185-87d6-402c0b9ee35f): There are no data parts 2024.10.09 22:55:41.889700 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.889758 [ 3 ] {} HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.890262 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.890380 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.890401 [ 3 ] {} HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.890426 [ 3 ] {} HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.890451 [ 3 ] {} HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.890515 [ 3 ] {} HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.890731 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.890839 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 2024.10.09 22:55:41.893148 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} oximeter.fields_i64 (6f5c8688-0a01-4560-8537-15b148ce17fc): Loading data parts 2024.10.09 22:55:41.893411 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} oximeter.fields_i64 (6f5c8688-0a01-4560-8537-15b148ce17fc): There are no data parts 2024.10.09 22:55:41.895778 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.895847 [ 3 ] {} HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.896836 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.896905 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.896966 [ 3 ] {} HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.896985 [ 3 ] {} HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.896996 [ 3 ] {} HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.897033 [ 3 ] {} HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.897304 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.897401 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 2024.10.09 22:55:41.900466 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} oximeter.fields_u64 (a41071e0-9a43-46db-a5b2-414659af02ce): Loading data parts 2024.10.09 22:55:41.900851 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} oximeter.fields_u64 (a41071e0-9a43-46db-a5b2-414659af02ce): There are no data parts 2024.10.09 22:55:41.902748 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.902779 [ 3 ] {} HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.903862 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.903925 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.903948 [ 3 ] {} HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.903971 [ 3 ] {} HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.903987 [ 3 ] {} HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.904030 [ 3 ] {} HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.904342 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.904389 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr 2024.10.09 22:55:41.906925 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} oximeter.fields_ipaddr (1c157377-1674-46b7-a423-509ee51ffb37): Loading data parts 2024.10.09 22:55:41.907236 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} oximeter.fields_ipaddr (1c157377-1674-46b7-a423-509ee51ffb37): There are no data parts 2024.10.09 22:55:41.909195 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.909223 [ 3 ] {} HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.910183 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.910237 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.910261 [ 3 ] {} HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.910316 [ 3 ] {} HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.910353 [ 3 ] {} HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.910446 [ 3 ] {} HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.910722 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.910786 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string 2024.10.09 22:55:41.913507 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} oximeter.fields_string (f3f960c8-59eb-4d52-a021-e1e894158eba): Loading data parts 2024.10.09 22:55:41.913776 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} oximeter.fields_string (f3f960c8-59eb-4d52-a021-e1e894158eba): There are no data parts 2024.10.09 22:55:41.915646 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.915678 [ 3 ] {} HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.916230 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.916304 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.916327 [ 3 ] {} HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.916349 [ 3 ] {} HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.916364 [ 3 ] {} HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.916403 [ 3 ] {} HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.916664 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} executeQuery: (from [::1]:33250) 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.10.09 22:55:41.916727 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid 2024.10.09 22:55:41.919389 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} oximeter.fields_uuid (fbe08b88-8716-4cbd-9288-5f75d28cfa73): Loading data parts 2024.10.09 22:55:41.919646 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} oximeter.fields_uuid (fbe08b88-8716-4cbd-9288-5f75d28cfa73): There are no data parts 2024.10.09 22:55:41.921398 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.921427 [ 3 ] {} HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.922040 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.922105 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.922129 [ 3 ] {} HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.922151 [ 3 ] {} HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.922164 [ 3 ] {} HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.922199 [ 3 ] {} HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.922541 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} executeQuery: (from [::1]:33250) /* 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.10.09 22:55:41.922626 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema 2024.10.09 22:55:41.925072 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} oximeter.timeseries_schema (d05637a4-532c-4743-bf1b-84f5194ebe8f): Loading data parts 2024.10.09 22:55:41.925306 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} oximeter.timeseries_schema (d05637a4-532c-4743-bf1b-84f5194ebe8f): There are no data parts 2024.10.09 22:55:41.927012 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.927034 [ 3 ] {} HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.927609 [ 3 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) 2024.10.09 22:55:41.927671 [ 3 ] {} DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 2024.10.09 22:55:41.927694 [ 3 ] {} HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Authenticating user 'default' from [::1]:33250 2024.10.09 22:55:41.927718 [ 3 ] {} HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.927735 [ 3 ] {} HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:41.927778 [ 3 ] {} HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default 2024.10.09 22:55:41.927969 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} executeQuery: (from [::1]:33250) INSERT INTO oximeter.version (*) VALUES (stage: Complete) 2024.10.09 22:55:41.928152 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version 2024.10.09 22:55:41.929592 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} oximeter.version (fcc73285-839e-4734-a652-af3fe4b1b91e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 2024.10.09 22:55:41.929643 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.09 GiB. 2024.10.09 22:55:41.930421 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) 2024.10.09 22:55:41.930951 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} oximeter.version (fcc73285-839e-4734-a652-af3fe4b1b91e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). 2024.10.09 22:55:41.931239 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} executeQuery: Read 1 rows, 16.00 B in 0.003347 sec., 298.7750224081267 rows/sec., 4.67 KiB/sec. 2024.10.09 22:55:41.931427 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} DynamicQueryHandler: Done processing query 2024.10.09 22:55:41.931449 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} MemoryTracker: Peak memory usage (for query): 4.19 MiB. 2024.10.09 22:55:41.931464 [ 3 ] {} HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db 2024.10.09 22:55:42.000538 [ 244 ] {} AsynchronousMetrics: MemoryTracking: was 174.77 MiB, peak 179.91 MiB, free memory in arenas 0.00 B, will set to 180.19 MiB (RSS), difference: 5.42 MiB