| 1 | 2024.10.09 22:35:58.399999 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 13131 | ||
| 2 | 2024.10.09 22:35:58.400258 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.10.09 22:35:58.400322 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.10.09 22:35:58.410648 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.10.09 22:35:58.417692 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.10.09 22:35:58.417746 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.10.09 22:35:58.417803 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2024.10.09 22:35:58.417877 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_saga_basic_usage_succeeds.13109.1-clickhouse-jppKaL/datastore/tmp/ to store temporary data in it | ||
| 9 | 2024.10.09 22:35:58.418304 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.10.09 22:35:58.435218 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.10.09 22:35:58.435810 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 2024.10.09 22:35:58.438295 [ 1 ] {} <Information> 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) | ||
| 13 | 2024.10.09 22:35:58.438366 [ 1 ] {} <Information> 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) | ||
| 14 | 2024.10.09 22:35:58.438398 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.10.09 22:35:58.438492 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.10.09 22:35:58.439151 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.10.09 22:35:58.456967 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.10.09 22:35:58.460172 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2024.10.09 22:35:58.473278 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 20 | 2024.10.09 22:35:58.473360 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.10.09 22:35:58.475031 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.10.09 22:35:58.475641 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.10.09 22:35:58.477525 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.10.09 22:35:58.478084 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 2024.10.09 22:35:58.575158 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 26 | 2024.10.09 22:35:58.576853 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.10.09 22:35:58.577977 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2024.10.09 22:35:58.579342 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 29 | 2024.10.09 22:35:58.581034 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2024.10.09 22:35:58.581078 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_saga_basic_usage_succeeds.13109.1-clickhouse-jppKaL/datastore/ | ||
| 31 | 2024.10.09 22:35:58.581422 [ 222 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 32 | 2024.10.09 22:35:58.581540 [ 222 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 33 | 2024.10.09 22:35:58.587199 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 34 | 2024.10.09 22:35:58.587231 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000158163 sec | ||
| 35 | 2024.10.09 22:35:58.587265 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 36 | 2024.10.09 22:35:58.587278 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 37 | 2024.10.09 22:35:58.587406 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 38 | 2024.10.09 22:35:58.587471 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 39 | 2024.10.09 22:35:58.587491 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 40 | 2024.10.09 22:35:58.587521 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 41 | 2024.10.09 22:35:58.587541 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 42 | 2024.10.09 22:35:58.587554 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 43 | 2024.10.09 22:35:58.587634 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 44 | 2024.10.09 22:35:58.587658 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 45 | 2024.10.09 22:35:58.587678 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 46 | 2024.10.09 22:35:58.587709 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 47 | 2024.10.09 22:35:58.587725 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 48 | 2024.10.09 22:35:58.587744 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 49 | 2024.10.09 22:35:58.587756 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 50 | 2024.10.09 22:35:58.587786 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2024.10.09 22:35:58.587804 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 2024.10.09 22:35:58.587817 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 53 | 2024.10.09 22:35:58.587846 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 54 | 2024.10.09 22:35:58.587867 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 55 | 2024.10.09 22:35:58.621108 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.10.09 22:35:58.623262 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.10.09 22:35:58.623333 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000106425 sec | ||
| 58 | 2024.10.09 22:35:58.623348 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.10.09 22:35:58.623357 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.10.09 22:35:58.623386 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2024.10.09 22:35:58.623573 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_saga_basic_usage_succeeds.13109.1-clickhouse-jppKaL/datastore/user_defined/ | ||
| 62 | 2024.10.09 22:35:58.623637 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.10.09 22:35:58.623653 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2024.10.09 22:35:58.623664 [ 1 ] {} <Information> 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). | ||
| 65 | 2024.10.09 22:35:58.623681 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.10.09 22:35:58.625063 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 50511 | ||
| 67 | 2024.10.09 22:35:58.625274 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 52487 | ||
| 68 | 2024.10.09 22:35:58.630216 [ 1 ] {} <Warning> Application: Listen [::1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: [::1]:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host> | ||
| 69 | 2024.10.09 22:35:58.630354 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 60339 | ||
| 70 | 2024.10.09 22:35:58.630439 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 33343 | ||
| 71 | 2024.10.09 22:35:58.630527 [ 1 ] {} <Warning> Application: Listen [127.0.0.1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: 127.0.0.1:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host> | ||
| 72 | 2024.10.09 22:35:58.630571 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 73 | 2024.10.09 22:35:58.630813 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.88 MiB, peak 16.08 MiB, free memory in arenas 0.00 B, will set to 139.55 MiB (RSS), difference: 129.67 MiB | ||
| 74 | 2024.10.09 22:35:58.650262 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.1168e-05 sec. | ||
| 75 | 2024.10.09 22:35:58.651378 [ 1 ] {} <Information> Application: Listening for http://[::1]:50511 | ||
| 76 | 2024.10.09 22:35:58.651453 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:52487 | ||
| 77 | 2024.10.09 22:35:58.651508 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:60339 | ||
| 78 | 2024.10.09 22:35:58.651574 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:33343 | ||
| 79 | 2024.10.09 22:35:58.651761 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 80 | 2024.10.09 22:36:12.024904 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 81 | 2024.10.09 22:36:12.025142 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 82 | 2024.10.09 22:36:12.025187 [ 3 ] {} <Debug> HTTP-Session: 7c14a233-5f41-4af8-898a-99c9409e4d6c Authenticating user 'default' from [::1]:50315 | ||
| 83 | 2024.10.09 22:36:12.025215 [ 3 ] {} <Debug> HTTP-Session: 7c14a233-5f41-4af8-898a-99c9409e4d6c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 84 | 2024.10.09 22:36:12.025231 [ 3 ] {} <Debug> HTTP-Session: 7c14a233-5f41-4af8-898a-99c9409e4d6c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 85 | 2024.10.09 22:36:12.025333 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 86 | 2024.10.09 22:36:12.025380 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 87 | 2024.10.09 22:36:12.025405 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 88 | 2024.10.09 22:36:12.025475 [ 3 ] {} <Trace> HTTP-Session: 7c14a233-5f41-4af8-898a-99c9409e4d6c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 89 | 2024.10.09 22:36:12.026081 [ 3 ] {d5e8b038-fc04-48b7-95cd-ff30c10066c1} <Debug> executeQuery: (from [::1]:50315) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 90 | 2024.10.09 22:36:12.035337 [ 3 ] {d5e8b038-fc04-48b7-95cd-ff30c10066c1} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:50315) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 91 | |||
| 92 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 93 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 94 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 95 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 96 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 97 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 98 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 99 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 100 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 101 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 102 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 103 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 104 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 105 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 106 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 107 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 108 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 109 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 110 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 111 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 112 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 113 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 114 | |||
| 115 | 2024.10.09 22:36:12.035636 [ 3 ] {d5e8b038-fc04-48b7-95cd-ff30c10066c1} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 116 | |||
| 117 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 118 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 119 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 120 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 121 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 122 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 123 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 124 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 125 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 126 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 127 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 128 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 129 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 130 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 131 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 132 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 133 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 134 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 135 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 136 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 137 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 138 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 139 | (version 23.8.7.1) | ||
| 140 | 2024.10.09 22:36:12.035965 [ 3 ] {} <Debug> HTTP-Session: 7c14a233-5f41-4af8-898a-99c9409e4d6c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 141 | 2024.10.09 22:36:12.084232 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 142 | 2024.10.09 22:36:12.084368 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 143 | 2024.10.09 22:36:12.084398 [ 3 ] {} <Debug> HTTP-Session: 423b266e-60aa-4b69-a8b7-6ae8168f9686 Authenticating user 'default' from [::1]:50315 | ||
| 144 | 2024.10.09 22:36:12.084434 [ 3 ] {} <Debug> HTTP-Session: 423b266e-60aa-4b69-a8b7-6ae8168f9686 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 145 | 2024.10.09 22:36:12.084449 [ 3 ] {} <Debug> HTTP-Session: 423b266e-60aa-4b69-a8b7-6ae8168f9686 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 146 | 2024.10.09 22:36:12.084505 [ 3 ] {} <Trace> HTTP-Session: 423b266e-60aa-4b69-a8b7-6ae8168f9686 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 147 | 2024.10.09 22:36:12.084841 [ 3 ] {33c1e529-1c12-4f1c-bb65-b0267a53ea0f} <Debug> executeQuery: (from [::1]:50315) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 148 | 2024.10.09 22:36:12.085279 [ 3 ] {33c1e529-1c12-4f1c-bb65-b0267a53ea0f} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:50315) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 149 | |||
| 150 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 151 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 152 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 153 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 154 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 155 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 156 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 157 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 158 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 159 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 160 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 161 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 162 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 163 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 164 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 165 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 166 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 167 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 168 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 171 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 172 | |||
| 173 | 2024.10.09 22:36:12.085464 [ 3 ] {33c1e529-1c12-4f1c-bb65-b0267a53ea0f} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 174 | |||
| 175 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 176 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 177 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 178 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 179 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 180 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 181 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 182 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 183 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 184 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 185 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 186 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 187 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 188 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 189 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 195 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 197 | (version 23.8.7.1) | ||
| 198 | 2024.10.09 22:36:12.085695 [ 3 ] {} <Debug> HTTP-Session: 423b266e-60aa-4b69-a8b7-6ae8168f9686 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 199 | 2024.10.09 22:36:12.267603 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 200 | 2024.10.09 22:36:12.267729 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 201 | 2024.10.09 22:36:12.267756 [ 3 ] {} <Debug> HTTP-Session: ce330a0a-fe86-49ce-a099-e53eda66f5be Authenticating user 'default' from [::1]:50315 | ||
| 202 | 2024.10.09 22:36:12.267797 [ 3 ] {} <Debug> HTTP-Session: ce330a0a-fe86-49ce-a099-e53eda66f5be Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 203 | 2024.10.09 22:36:12.267811 [ 3 ] {} <Debug> HTTP-Session: ce330a0a-fe86-49ce-a099-e53eda66f5be Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 204 | 2024.10.09 22:36:12.267868 [ 3 ] {} <Trace> HTTP-Session: ce330a0a-fe86-49ce-a099-e53eda66f5be Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 205 | 2024.10.09 22:36:12.268165 [ 3 ] {dcdbd983-7d10-4077-a528-99c7f7d45b40} <Debug> executeQuery: (from [::1]:50315) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 206 | 2024.10.09 22:36:12.268434 [ 3 ] {dcdbd983-7d10-4077-a528-99c7f7d45b40} <Debug> DynamicQueryHandler: Done processing query | ||
| 207 | 2024.10.09 22:36:12.268460 [ 3 ] {} <Debug> HTTP-Session: ce330a0a-fe86-49ce-a099-e53eda66f5be Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 208 | 2024.10.09 22:36:12.279398 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 209 | 2024.10.09 22:36:12.279519 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 210 | 2024.10.09 22:36:12.279550 [ 3 ] {} <Debug> HTTP-Session: 490ee9ce-2976-4ad0-b9ed-b58227a19ec1 Authenticating user 'default' from [::1]:50315 | ||
| 211 | 2024.10.09 22:36:12.279592 [ 3 ] {} <Debug> HTTP-Session: 490ee9ce-2976-4ad0-b9ed-b58227a19ec1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 212 | 2024.10.09 22:36:12.279609 [ 3 ] {} <Debug> HTTP-Session: 490ee9ce-2976-4ad0-b9ed-b58227a19ec1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 213 | 2024.10.09 22:36:12.279668 [ 3 ] {} <Trace> HTTP-Session: 490ee9ce-2976-4ad0-b9ed-b58227a19ec1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 214 | 2024.10.09 22:36:12.279869 [ 3 ] {0aa97100-371c-4f72-8349-bdf56166116c} <Debug> executeQuery: (from [::1]:50315) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 215 | 2024.10.09 22:36:12.279972 [ 3 ] {0aa97100-371c-4f72-8349-bdf56166116c} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 216 | 2024.10.09 22:36:12.281544 [ 3 ] {0aa97100-371c-4f72-8349-bdf56166116c} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 217 | 2024.10.09 22:36:12.281577 [ 3 ] {0aa97100-371c-4f72-8349-bdf56166116c} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.0226e-05 sec | ||
| 218 | 2024.10.09 22:36:12.281591 [ 3 ] {0aa97100-371c-4f72-8349-bdf56166116c} <Trace> ReferentialDeps: No tables | ||
| 219 | 2024.10.09 22:36:12.281602 [ 3 ] {0aa97100-371c-4f72-8349-bdf56166116c} <Trace> LoadingDeps: No tables | ||
| 220 | 2024.10.09 22:36:12.281631 [ 3 ] {0aa97100-371c-4f72-8349-bdf56166116c} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 221 | 2024.10.09 22:36:12.281806 [ 3 ] {0aa97100-371c-4f72-8349-bdf56166116c} <Debug> DynamicQueryHandler: Done processing query | ||
| 222 | 2024.10.09 22:36:12.281828 [ 3 ] {} <Debug> HTTP-Session: 490ee9ce-2976-4ad0-b9ed-b58227a19ec1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 223 | 2024.10.09 22:36:12.355565 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 224 | 2024.10.09 22:36:12.355703 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 225 | 2024.10.09 22:36:12.355729 [ 3 ] {} <Debug> HTTP-Session: de9020e0-e237-4039-96a7-6ee5254e2189 Authenticating user 'default' from [::1]:50315 | ||
| 226 | 2024.10.09 22:36:12.355754 [ 3 ] {} <Debug> HTTP-Session: de9020e0-e237-4039-96a7-6ee5254e2189 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 227 | 2024.10.09 22:36:12.355775 [ 3 ] {} <Debug> HTTP-Session: de9020e0-e237-4039-96a7-6ee5254e2189 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 228 | 2024.10.09 22:36:12.355832 [ 3 ] {} <Trace> HTTP-Session: de9020e0-e237-4039-96a7-6ee5254e2189 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 229 | 2024.10.09 22:36:12.356142 [ 3 ] {61455881-9d55-434d-9030-96be18d4e556} <Debug> executeQuery: (from [::1]:50315) /* The version table contains metadata about the `oximeter` database */ | ||
| 230 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 231 | 2024.10.09 22:36:12.356234 [ 3 ] {61455881-9d55-434d-9030-96be18d4e556} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 232 | 2024.10.09 22:36:12.358003 [ 3 ] {61455881-9d55-434d-9030-96be18d4e556} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 233 | 2024.10.09 22:36:12.359338 [ 3 ] {61455881-9d55-434d-9030-96be18d4e556} <Debug> oximeter.version (971021cc-3a06-4512-a46b-7dbb92c1d782): Loading data parts | ||
| 234 | 2024.10.09 22:36:12.359919 [ 3 ] {61455881-9d55-434d-9030-96be18d4e556} <Debug> oximeter.version (971021cc-3a06-4512-a46b-7dbb92c1d782): There are no data parts | ||
| 235 | 2024.10.09 22:36:12.361798 [ 3 ] {61455881-9d55-434d-9030-96be18d4e556} <Debug> DynamicQueryHandler: Done processing query | ||
| 236 | 2024.10.09 22:36:12.361840 [ 3 ] {} <Debug> HTTP-Session: de9020e0-e237-4039-96a7-6ee5254e2189 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 237 | 2024.10.09 22:36:12.398346 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 238 | 2024.10.09 22:36:12.398479 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 239 | 2024.10.09 22:36:12.398527 [ 3 ] {} <Debug> HTTP-Session: 4fe712f7-cef2-4d93-8c49-7e37d3b15733 Authenticating user 'default' from [::1]:50315 | ||
| 240 | 2024.10.09 22:36:12.398557 [ 3 ] {} <Debug> HTTP-Session: 4fe712f7-cef2-4d93-8c49-7e37d3b15733 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 241 | 2024.10.09 22:36:12.398573 [ 3 ] {} <Debug> HTTP-Session: 4fe712f7-cef2-4d93-8c49-7e37d3b15733 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 242 | 2024.10.09 22:36:12.398642 [ 3 ] {} <Trace> HTTP-Session: 4fe712f7-cef2-4d93-8c49-7e37d3b15733 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 243 | 2024.10.09 22:36:12.399086 [ 3 ] {5b008910-1758-4a5d-a717-a28d244e243f} <Debug> executeQuery: (from [::1]:50315) /* The measurement tables contain all individual samples from each timeseries. | ||
| 244 | * | ||
| 245 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 246 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 247 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 248 | * by all samples from the same timeseries. | ||
| 249 | * | ||
| 250 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 251 | * and then uses that to index quickly into the measurements tables. | ||
| 252 | */ | ||
| 253 | 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) | ||
| 254 | 2024.10.09 22:36:12.399174 [ 3 ] {5b008910-1758-4a5d-a717-a28d244e243f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 255 | 2024.10.09 22:36:12.402023 [ 3 ] {5b008910-1758-4a5d-a717-a28d244e243f} <Debug> oximeter.measurements_bool (d930968c-4eb3-436a-9cfd-3aacc128bb0d): Loading data parts | ||
| 256 | 2024.10.09 22:36:12.402371 [ 3 ] {5b008910-1758-4a5d-a717-a28d244e243f} <Debug> oximeter.measurements_bool (d930968c-4eb3-436a-9cfd-3aacc128bb0d): There are no data parts | ||
| 257 | 2024.10.09 22:36:12.404243 [ 3 ] {5b008910-1758-4a5d-a717-a28d244e243f} <Debug> DynamicQueryHandler: Done processing query | ||
| 258 | 2024.10.09 22:36:12.404275 [ 3 ] {} <Debug> HTTP-Session: 4fe712f7-cef2-4d93-8c49-7e37d3b15733 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 259 | 2024.10.09 22:36:12.412168 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 260 | 2024.10.09 22:36:12.412309 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 261 | 2024.10.09 22:36:12.412342 [ 3 ] {} <Debug> HTTP-Session: 808c4150-0d30-4e14-8eff-6ffec2636d57 Authenticating user 'default' from [::1]:50315 | ||
| 262 | 2024.10.09 22:36:12.412371 [ 3 ] {} <Debug> HTTP-Session: 808c4150-0d30-4e14-8eff-6ffec2636d57 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 263 | 2024.10.09 22:36:12.412396 [ 3 ] {} <Debug> HTTP-Session: 808c4150-0d30-4e14-8eff-6ffec2636d57 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 264 | 2024.10.09 22:36:12.412457 [ 3 ] {} <Trace> HTTP-Session: 808c4150-0d30-4e14-8eff-6ffec2636d57 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 265 | 2024.10.09 22:36:12.412849 [ 3 ] {14cd832d-5069-4dc5-87d4-79b9b841dda1} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 266 | 2024.10.09 22:36:12.412931 [ 3 ] {14cd832d-5069-4dc5-87d4-79b9b841dda1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 267 | 2024.10.09 22:36:12.415508 [ 3 ] {14cd832d-5069-4dc5-87d4-79b9b841dda1} <Debug> oximeter.measurements_i8 (ce294798-b591-42f1-838d-3f189bf6d23c): Loading data parts | ||
| 268 | 2024.10.09 22:36:12.415860 [ 3 ] {14cd832d-5069-4dc5-87d4-79b9b841dda1} <Debug> oximeter.measurements_i8 (ce294798-b591-42f1-838d-3f189bf6d23c): There are no data parts | ||
| 269 | 2024.10.09 22:36:12.417639 [ 3 ] {14cd832d-5069-4dc5-87d4-79b9b841dda1} <Debug> DynamicQueryHandler: Done processing query | ||
| 270 | 2024.10.09 22:36:12.417709 [ 3 ] {} <Debug> HTTP-Session: 808c4150-0d30-4e14-8eff-6ffec2636d57 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2024.10.09 22:36:12.428171 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 272 | 2024.10.09 22:36:12.428291 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 273 | 2024.10.09 22:36:12.428336 [ 3 ] {} <Debug> HTTP-Session: 4dbd83de-bc05-4f8b-86ec-149efb9ddda6 Authenticating user 'default' from [::1]:50315 | ||
| 274 | 2024.10.09 22:36:12.428366 [ 3 ] {} <Debug> HTTP-Session: 4dbd83de-bc05-4f8b-86ec-149efb9ddda6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2024.10.09 22:36:12.428383 [ 3 ] {} <Debug> HTTP-Session: 4dbd83de-bc05-4f8b-86ec-149efb9ddda6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 276 | 2024.10.09 22:36:12.428441 [ 3 ] {} <Trace> HTTP-Session: 4dbd83de-bc05-4f8b-86ec-149efb9ddda6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 277 | 2024.10.09 22:36:12.428861 [ 3 ] {6d52f9ff-3586-40d1-ab56-c80f665c1b6b} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 278 | 2024.10.09 22:36:12.428946 [ 3 ] {6d52f9ff-3586-40d1-ab56-c80f665c1b6b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 279 | 2024.10.09 22:36:12.431579 [ 3 ] {6d52f9ff-3586-40d1-ab56-c80f665c1b6b} <Debug> oximeter.measurements_u8 (71fb6218-1e01-4d3d-9d71-c0e403f87922): Loading data parts | ||
| 280 | 2024.10.09 22:36:12.431906 [ 3 ] {6d52f9ff-3586-40d1-ab56-c80f665c1b6b} <Debug> oximeter.measurements_u8 (71fb6218-1e01-4d3d-9d71-c0e403f87922): There are no data parts | ||
| 281 | 2024.10.09 22:36:12.433730 [ 3 ] {6d52f9ff-3586-40d1-ab56-c80f665c1b6b} <Debug> DynamicQueryHandler: Done processing query | ||
| 282 | 2024.10.09 22:36:12.433765 [ 3 ] {} <Debug> HTTP-Session: 4dbd83de-bc05-4f8b-86ec-149efb9ddda6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.10.09 22:36:12.447699 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 284 | 2024.10.09 22:36:12.447842 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 285 | 2024.10.09 22:36:12.447873 [ 3 ] {} <Debug> HTTP-Session: e7f9aa7f-819f-4fbf-b3cc-6fc3c69c3cc6 Authenticating user 'default' from [::1]:50315 | ||
| 286 | 2024.10.09 22:36:12.447902 [ 3 ] {} <Debug> HTTP-Session: e7f9aa7f-819f-4fbf-b3cc-6fc3c69c3cc6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 287 | 2024.10.09 22:36:12.447929 [ 3 ] {} <Debug> HTTP-Session: e7f9aa7f-819f-4fbf-b3cc-6fc3c69c3cc6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2024.10.09 22:36:12.448024 [ 3 ] {} <Trace> HTTP-Session: e7f9aa7f-819f-4fbf-b3cc-6fc3c69c3cc6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 289 | 2024.10.09 22:36:12.448423 [ 3 ] {8c2b14de-2fcb-4002-b1b8-34c7419736cf} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 290 | 2024.10.09 22:36:12.448512 [ 3 ] {8c2b14de-2fcb-4002-b1b8-34c7419736cf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 291 | 2024.10.09 22:36:12.451326 [ 3 ] {8c2b14de-2fcb-4002-b1b8-34c7419736cf} <Debug> oximeter.measurements_i16 (159930b5-a065-4608-b1f4-f24311c62c5c): Loading data parts | ||
| 292 | 2024.10.09 22:36:12.451707 [ 3 ] {8c2b14de-2fcb-4002-b1b8-34c7419736cf} <Debug> oximeter.measurements_i16 (159930b5-a065-4608-b1f4-f24311c62c5c): There are no data parts | ||
| 293 | 2024.10.09 22:36:12.453570 [ 3 ] {8c2b14de-2fcb-4002-b1b8-34c7419736cf} <Debug> DynamicQueryHandler: Done processing query | ||
| 294 | 2024.10.09 22:36:12.453606 [ 3 ] {} <Debug> HTTP-Session: e7f9aa7f-819f-4fbf-b3cc-6fc3c69c3cc6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.10.09 22:36:12.454205 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 296 | 2024.10.09 22:36:12.454282 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 297 | 2024.10.09 22:36:12.454312 [ 3 ] {} <Debug> HTTP-Session: 78cd70b7-61e5-4d60-8a31-751f02959db7 Authenticating user 'default' from [::1]:50315 | ||
| 298 | 2024.10.09 22:36:12.454348 [ 3 ] {} <Debug> HTTP-Session: 78cd70b7-61e5-4d60-8a31-751f02959db7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 299 | 2024.10.09 22:36:12.454367 [ 3 ] {} <Debug> HTTP-Session: 78cd70b7-61e5-4d60-8a31-751f02959db7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 300 | 2024.10.09 22:36:12.454420 [ 3 ] {} <Trace> HTTP-Session: 78cd70b7-61e5-4d60-8a31-751f02959db7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 301 | 2024.10.09 22:36:12.454790 [ 3 ] {989882c7-f919-4692-95ad-adc9445dba80} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 302 | 2024.10.09 22:36:12.454873 [ 3 ] {989882c7-f919-4692-95ad-adc9445dba80} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 303 | 2024.10.09 22:36:12.457463 [ 3 ] {989882c7-f919-4692-95ad-adc9445dba80} <Debug> oximeter.measurements_u16 (07692d5d-c7e0-4bd0-8183-09c85dd4dcef): Loading data parts | ||
| 304 | 2024.10.09 22:36:12.457733 [ 3 ] {989882c7-f919-4692-95ad-adc9445dba80} <Debug> oximeter.measurements_u16 (07692d5d-c7e0-4bd0-8183-09c85dd4dcef): There are no data parts | ||
| 305 | 2024.10.09 22:36:12.459416 [ 3 ] {989882c7-f919-4692-95ad-adc9445dba80} <Debug> DynamicQueryHandler: Done processing query | ||
| 306 | 2024.10.09 22:36:12.459459 [ 3 ] {} <Debug> HTTP-Session: 78cd70b7-61e5-4d60-8a31-751f02959db7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.10.09 22:36:12.460264 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 308 | 2024.10.09 22:36:12.460399 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 309 | 2024.10.09 22:36:12.460438 [ 3 ] {} <Debug> HTTP-Session: d5cf0b05-44ba-452a-9cc4-d68060686a6a Authenticating user 'default' from [::1]:50315 | ||
| 310 | 2024.10.09 22:36:12.460463 [ 3 ] {} <Debug> HTTP-Session: d5cf0b05-44ba-452a-9cc4-d68060686a6a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2024.10.09 22:36:12.460479 [ 3 ] {} <Debug> HTTP-Session: d5cf0b05-44ba-452a-9cc4-d68060686a6a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 312 | 2024.10.09 22:36:12.460536 [ 3 ] {} <Trace> HTTP-Session: d5cf0b05-44ba-452a-9cc4-d68060686a6a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 313 | 2024.10.09 22:36:12.460852 [ 3 ] {b19b6814-3e27-403f-b538-031eed8c4861} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 314 | 2024.10.09 22:36:12.460928 [ 3 ] {b19b6814-3e27-403f-b538-031eed8c4861} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 315 | 2024.10.09 22:36:12.463403 [ 3 ] {b19b6814-3e27-403f-b538-031eed8c4861} <Debug> oximeter.measurements_i32 (1e503267-59f8-48ea-a4ce-3bf1f8266a61): Loading data parts | ||
| 316 | 2024.10.09 22:36:12.463817 [ 3 ] {b19b6814-3e27-403f-b538-031eed8c4861} <Debug> oximeter.measurements_i32 (1e503267-59f8-48ea-a4ce-3bf1f8266a61): There are no data parts | ||
| 317 | 2024.10.09 22:36:12.465624 [ 3 ] {b19b6814-3e27-403f-b538-031eed8c4861} <Debug> DynamicQueryHandler: Done processing query | ||
| 318 | 2024.10.09 22:36:12.465655 [ 3 ] {} <Debug> HTTP-Session: d5cf0b05-44ba-452a-9cc4-d68060686a6a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.10.09 22:36:12.469043 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 320 | 2024.10.09 22:36:12.469143 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 321 | 2024.10.09 22:36:12.469168 [ 3 ] {} <Debug> HTTP-Session: 76f142f9-9f6d-437c-98ae-1f82abbc0fd4 Authenticating user 'default' from [::1]:50315 | ||
| 322 | 2024.10.09 22:36:12.469194 [ 3 ] {} <Debug> HTTP-Session: 76f142f9-9f6d-437c-98ae-1f82abbc0fd4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 323 | 2024.10.09 22:36:12.469219 [ 3 ] {} <Debug> HTTP-Session: 76f142f9-9f6d-437c-98ae-1f82abbc0fd4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 324 | 2024.10.09 22:36:12.469275 [ 3 ] {} <Trace> HTTP-Session: 76f142f9-9f6d-437c-98ae-1f82abbc0fd4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 325 | 2024.10.09 22:36:12.470522 [ 3 ] {368cb7e1-268d-4dc9-b321-e9df21943657} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 326 | 2024.10.09 22:36:12.470626 [ 3 ] {368cb7e1-268d-4dc9-b321-e9df21943657} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 327 | 2024.10.09 22:36:12.473550 [ 3 ] {368cb7e1-268d-4dc9-b321-e9df21943657} <Debug> oximeter.measurements_u32 (977a6bcf-8fd3-4190-a39c-68186a1235d3): Loading data parts | ||
| 328 | 2024.10.09 22:36:12.473894 [ 3 ] {368cb7e1-268d-4dc9-b321-e9df21943657} <Debug> oximeter.measurements_u32 (977a6bcf-8fd3-4190-a39c-68186a1235d3): There are no data parts | ||
| 329 | 2024.10.09 22:36:12.475803 [ 3 ] {368cb7e1-268d-4dc9-b321-e9df21943657} <Debug> DynamicQueryHandler: Done processing query | ||
| 330 | 2024.10.09 22:36:12.475840 [ 3 ] {} <Debug> HTTP-Session: 76f142f9-9f6d-437c-98ae-1f82abbc0fd4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 331 | 2024.10.09 22:36:12.478168 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 332 | 2024.10.09 22:36:12.478257 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 333 | 2024.10.09 22:36:12.478318 [ 3 ] {} <Debug> HTTP-Session: bf842efd-5d28-4ebc-a72b-d2e884f7f9a1 Authenticating user 'default' from [::1]:50315 | ||
| 334 | 2024.10.09 22:36:12.478346 [ 3 ] {} <Debug> HTTP-Session: bf842efd-5d28-4ebc-a72b-d2e884f7f9a1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 335 | 2024.10.09 22:36:12.478363 [ 3 ] {} <Debug> HTTP-Session: bf842efd-5d28-4ebc-a72b-d2e884f7f9a1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 336 | 2024.10.09 22:36:12.478425 [ 3 ] {} <Trace> HTTP-Session: bf842efd-5d28-4ebc-a72b-d2e884f7f9a1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 337 | 2024.10.09 22:36:12.478778 [ 3 ] {f690aac1-40b3-484d-ad7d-45b44a2d5313} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 338 | 2024.10.09 22:36:12.478860 [ 3 ] {f690aac1-40b3-484d-ad7d-45b44a2d5313} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 339 | 2024.10.09 22:36:12.481431 [ 3 ] {f690aac1-40b3-484d-ad7d-45b44a2d5313} <Debug> oximeter.measurements_i64 (5c6f8182-1b74-4e30-8803-7ab7135ff590): Loading data parts | ||
| 340 | 2024.10.09 22:36:12.481814 [ 3 ] {f690aac1-40b3-484d-ad7d-45b44a2d5313} <Debug> oximeter.measurements_i64 (5c6f8182-1b74-4e30-8803-7ab7135ff590): There are no data parts | ||
| 341 | 2024.10.09 22:36:12.483835 [ 3 ] {f690aac1-40b3-484d-ad7d-45b44a2d5313} <Debug> DynamicQueryHandler: Done processing query | ||
| 342 | 2024.10.09 22:36:12.483876 [ 3 ] {} <Debug> HTTP-Session: bf842efd-5d28-4ebc-a72b-d2e884f7f9a1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2024.10.09 22:36:12.486239 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 344 | 2024.10.09 22:36:12.486357 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 345 | 2024.10.09 22:36:12.486387 [ 3 ] {} <Debug> HTTP-Session: a834f16f-056f-4cfb-ab74-6cd3a75b3d13 Authenticating user 'default' from [::1]:50315 | ||
| 346 | 2024.10.09 22:36:12.486423 [ 3 ] {} <Debug> HTTP-Session: a834f16f-056f-4cfb-ab74-6cd3a75b3d13 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 347 | 2024.10.09 22:36:12.486445 [ 3 ] {} <Debug> HTTP-Session: a834f16f-056f-4cfb-ab74-6cd3a75b3d13 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 348 | 2024.10.09 22:36:12.486508 [ 3 ] {} <Trace> HTTP-Session: a834f16f-056f-4cfb-ab74-6cd3a75b3d13 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 349 | 2024.10.09 22:36:12.486931 [ 3 ] {14abc6c7-7bb8-4768-adde-bc79ee1babe3} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 350 | 2024.10.09 22:36:12.487025 [ 3 ] {14abc6c7-7bb8-4768-adde-bc79ee1babe3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 351 | 2024.10.09 22:36:12.489768 [ 3 ] {14abc6c7-7bb8-4768-adde-bc79ee1babe3} <Debug> oximeter.measurements_u64 (92ffb62c-8603-4641-ad19-527922551c62): Loading data parts | ||
| 352 | 2024.10.09 22:36:12.490117 [ 3 ] {14abc6c7-7bb8-4768-adde-bc79ee1babe3} <Debug> oximeter.measurements_u64 (92ffb62c-8603-4641-ad19-527922551c62): There are no data parts | ||
| 353 | 2024.10.09 22:36:12.492105 [ 3 ] {14abc6c7-7bb8-4768-adde-bc79ee1babe3} <Debug> DynamicQueryHandler: Done processing query | ||
| 354 | 2024.10.09 22:36:12.492144 [ 3 ] {} <Debug> HTTP-Session: a834f16f-056f-4cfb-ab74-6cd3a75b3d13 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 355 | 2024.10.09 22:36:12.494435 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 356 | 2024.10.09 22:36:12.494536 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 357 | 2024.10.09 22:36:12.494572 [ 3 ] {} <Debug> HTTP-Session: 1a6463bd-5c44-4524-941d-b4bb21138e2c Authenticating user 'default' from [::1]:50315 | ||
| 358 | 2024.10.09 22:36:12.494614 [ 3 ] {} <Debug> HTTP-Session: 1a6463bd-5c44-4524-941d-b4bb21138e2c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 359 | 2024.10.09 22:36:12.494639 [ 3 ] {} <Debug> HTTP-Session: 1a6463bd-5c44-4524-941d-b4bb21138e2c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 360 | 2024.10.09 22:36:12.494698 [ 3 ] {} <Trace> HTTP-Session: 1a6463bd-5c44-4524-941d-b4bb21138e2c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 361 | 2024.10.09 22:36:12.495098 [ 3 ] {2378faff-80ac-494b-b7e4-5b2b8148e0f1} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 362 | 2024.10.09 22:36:12.495191 [ 3 ] {2378faff-80ac-494b-b7e4-5b2b8148e0f1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 363 | 2024.10.09 22:36:12.497851 [ 3 ] {2378faff-80ac-494b-b7e4-5b2b8148e0f1} <Debug> oximeter.measurements_f32 (7546f693-e8bf-44e7-b916-6ffa99525ce9): Loading data parts | ||
| 364 | 2024.10.09 22:36:12.498158 [ 3 ] {2378faff-80ac-494b-b7e4-5b2b8148e0f1} <Debug> oximeter.measurements_f32 (7546f693-e8bf-44e7-b916-6ffa99525ce9): There are no data parts | ||
| 365 | 2024.10.09 22:36:12.500293 [ 3 ] {2378faff-80ac-494b-b7e4-5b2b8148e0f1} <Debug> DynamicQueryHandler: Done processing query | ||
| 366 | 2024.10.09 22:36:12.500326 [ 3 ] {} <Debug> HTTP-Session: 1a6463bd-5c44-4524-941d-b4bb21138e2c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 367 | 2024.10.09 22:36:12.505049 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 368 | 2024.10.09 22:36:12.505197 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 369 | 2024.10.09 22:36:12.505262 [ 3 ] {} <Debug> HTTP-Session: f928e56d-c899-4f51-8553-f1ec64c93380 Authenticating user 'default' from [::1]:50315 | ||
| 370 | 2024.10.09 22:36:12.505292 [ 3 ] {} <Debug> HTTP-Session: f928e56d-c899-4f51-8553-f1ec64c93380 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 371 | 2024.10.09 22:36:12.505316 [ 3 ] {} <Debug> HTTP-Session: f928e56d-c899-4f51-8553-f1ec64c93380 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 372 | 2024.10.09 22:36:12.505378 [ 3 ] {} <Trace> HTTP-Session: f928e56d-c899-4f51-8553-f1ec64c93380 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 373 | 2024.10.09 22:36:12.505817 [ 3 ] {90974e0e-7b84-4397-a570-fbee07caecb7} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 374 | 2024.10.09 22:36:12.505907 [ 3 ] {90974e0e-7b84-4397-a570-fbee07caecb7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 375 | 2024.10.09 22:36:12.508669 [ 3 ] {90974e0e-7b84-4397-a570-fbee07caecb7} <Debug> oximeter.measurements_f64 (e862bb64-4933-4108-a134-f0b4c06cec0e): Loading data parts | ||
| 376 | 2024.10.09 22:36:12.509004 [ 3 ] {90974e0e-7b84-4397-a570-fbee07caecb7} <Debug> oximeter.measurements_f64 (e862bb64-4933-4108-a134-f0b4c06cec0e): There are no data parts | ||
| 377 | 2024.10.09 22:36:12.510777 [ 3 ] {90974e0e-7b84-4397-a570-fbee07caecb7} <Debug> DynamicQueryHandler: Done processing query | ||
| 378 | 2024.10.09 22:36:12.510806 [ 3 ] {} <Debug> HTTP-Session: f928e56d-c899-4f51-8553-f1ec64c93380 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 379 | 2024.10.09 22:36:12.514974 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 380 | 2024.10.09 22:36:12.515086 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 381 | 2024.10.09 22:36:12.515116 [ 3 ] {} <Debug> HTTP-Session: 5016e304-e793-466f-8725-a0c91607a38a Authenticating user 'default' from [::1]:50315 | ||
| 382 | 2024.10.09 22:36:12.515159 [ 3 ] {} <Debug> HTTP-Session: 5016e304-e793-466f-8725-a0c91607a38a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 383 | 2024.10.09 22:36:12.515175 [ 3 ] {} <Debug> HTTP-Session: 5016e304-e793-466f-8725-a0c91607a38a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 384 | 2024.10.09 22:36:12.515229 [ 3 ] {} <Trace> HTTP-Session: 5016e304-e793-466f-8725-a0c91607a38a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 385 | 2024.10.09 22:36:12.515591 [ 3 ] {65940d06-ac22-4ab6-92b8-806e315ef8d8} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 386 | 2024.10.09 22:36:12.515729 [ 3 ] {65940d06-ac22-4ab6-92b8-806e315ef8d8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 387 | 2024.10.09 22:36:12.518393 [ 3 ] {65940d06-ac22-4ab6-92b8-806e315ef8d8} <Debug> oximeter.measurements_string (39e4fea5-1122-4e5b-84ad-b17508632cc7): Loading data parts | ||
| 388 | 2024.10.09 22:36:12.518717 [ 3 ] {65940d06-ac22-4ab6-92b8-806e315ef8d8} <Debug> oximeter.measurements_string (39e4fea5-1122-4e5b-84ad-b17508632cc7): There are no data parts | ||
| 389 | 2024.10.09 22:36:12.520528 [ 3 ] {65940d06-ac22-4ab6-92b8-806e315ef8d8} <Debug> DynamicQueryHandler: Done processing query | ||
| 390 | 2024.10.09 22:36:12.520571 [ 3 ] {} <Debug> HTTP-Session: 5016e304-e793-466f-8725-a0c91607a38a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 391 | 2024.10.09 22:36:12.532281 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 392 | 2024.10.09 22:36:12.532418 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 393 | 2024.10.09 22:36:12.532468 [ 3 ] {} <Debug> HTTP-Session: 81f2be52-d73a-4951-9f1f-b9751f099aed Authenticating user 'default' from [::1]:50315 | ||
| 394 | 2024.10.09 22:36:12.532495 [ 3 ] {} <Debug> HTTP-Session: 81f2be52-d73a-4951-9f1f-b9751f099aed Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 395 | 2024.10.09 22:36:12.532511 [ 3 ] {} <Debug> HTTP-Session: 81f2be52-d73a-4951-9f1f-b9751f099aed Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 396 | 2024.10.09 22:36:12.532574 [ 3 ] {} <Trace> HTTP-Session: 81f2be52-d73a-4951-9f1f-b9751f099aed Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 397 | 2024.10.09 22:36:12.532962 [ 3 ] {09d281c4-c330-4db4-9bf5-aeaa1755d76e} <Debug> executeQuery: (from [::1]:50315) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 398 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 399 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 400 | * a string isn't palatable for a few reasons. | ||
| 401 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 402 | * details. | ||
| 403 | */ | ||
| 404 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 405 | 2024.10.09 22:36:12.533047 [ 3 ] {09d281c4-c330-4db4-9bf5-aeaa1755d76e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 406 | 2024.10.09 22:36:12.535796 [ 3 ] {09d281c4-c330-4db4-9bf5-aeaa1755d76e} <Debug> oximeter.measurements_bytes (af79bee3-2ca0-464e-b1ad-398beddc8fa8): Loading data parts | ||
| 407 | 2024.10.09 22:36:12.536152 [ 3 ] {09d281c4-c330-4db4-9bf5-aeaa1755d76e} <Debug> oximeter.measurements_bytes (af79bee3-2ca0-464e-b1ad-398beddc8fa8): There are no data parts | ||
| 408 | 2024.10.09 22:36:12.538116 [ 3 ] {09d281c4-c330-4db4-9bf5-aeaa1755d76e} <Debug> DynamicQueryHandler: Done processing query | ||
| 409 | 2024.10.09 22:36:12.538149 [ 3 ] {} <Debug> HTTP-Session: 81f2be52-d73a-4951-9f1f-b9751f099aed Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 410 | 2024.10.09 22:36:12.539034 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 411 | 2024.10.09 22:36:12.539124 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 412 | 2024.10.09 22:36:12.539153 [ 3 ] {} <Debug> HTTP-Session: a775bd3b-d6d5-44a5-a07b-a9d524668500 Authenticating user 'default' from [::1]:50315 | ||
| 413 | 2024.10.09 22:36:12.539179 [ 3 ] {} <Debug> HTTP-Session: a775bd3b-d6d5-44a5-a07b-a9d524668500 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 414 | 2024.10.09 22:36:12.539196 [ 3 ] {} <Debug> HTTP-Session: a775bd3b-d6d5-44a5-a07b-a9d524668500 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 415 | 2024.10.09 22:36:12.539258 [ 3 ] {} <Trace> HTTP-Session: a775bd3b-d6d5-44a5-a07b-a9d524668500 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 416 | 2024.10.09 22:36:12.539586 [ 3 ] {1b099eb1-2c39-4aba-8c2d-51dde759db5e} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 417 | 2024.10.09 22:36:12.539666 [ 3 ] {1b099eb1-2c39-4aba-8c2d-51dde759db5e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 418 | 2024.10.09 22:36:12.542117 [ 3 ] {1b099eb1-2c39-4aba-8c2d-51dde759db5e} <Debug> oximeter.measurements_cumulativei64 (9e7b5396-b182-4dad-9d0a-872af9596335): Loading data parts | ||
| 419 | 2024.10.09 22:36:12.542443 [ 3 ] {1b099eb1-2c39-4aba-8c2d-51dde759db5e} <Debug> oximeter.measurements_cumulativei64 (9e7b5396-b182-4dad-9d0a-872af9596335): There are no data parts | ||
| 420 | 2024.10.09 22:36:12.544264 [ 3 ] {1b099eb1-2c39-4aba-8c2d-51dde759db5e} <Debug> DynamicQueryHandler: Done processing query | ||
| 421 | 2024.10.09 22:36:12.544295 [ 3 ] {} <Debug> HTTP-Session: a775bd3b-d6d5-44a5-a07b-a9d524668500 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 422 | 2024.10.09 22:36:12.545073 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 423 | 2024.10.09 22:36:12.545149 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 424 | 2024.10.09 22:36:12.545175 [ 3 ] {} <Debug> HTTP-Session: cb886e28-df30-46b1-9571-cd1f7f6256ed Authenticating user 'default' from [::1]:50315 | ||
| 425 | 2024.10.09 22:36:12.545210 [ 3 ] {} <Debug> HTTP-Session: cb886e28-df30-46b1-9571-cd1f7f6256ed Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 426 | 2024.10.09 22:36:12.545226 [ 3 ] {} <Debug> HTTP-Session: cb886e28-df30-46b1-9571-cd1f7f6256ed Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 427 | 2024.10.09 22:36:12.545273 [ 3 ] {} <Trace> HTTP-Session: cb886e28-df30-46b1-9571-cd1f7f6256ed Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 428 | 2024.10.09 22:36:12.545591 [ 3 ] {2b3997cd-c36a-48ad-ac93-fac8ffa62f4d} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 429 | 2024.10.09 22:36:12.545667 [ 3 ] {2b3997cd-c36a-48ad-ac93-fac8ffa62f4d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 430 | 2024.10.09 22:36:12.548149 [ 3 ] {2b3997cd-c36a-48ad-ac93-fac8ffa62f4d} <Debug> oximeter.measurements_cumulativeu64 (758a8caf-c152-4627-a0a4-28144907e076): Loading data parts | ||
| 431 | 2024.10.09 22:36:12.548445 [ 3 ] {2b3997cd-c36a-48ad-ac93-fac8ffa62f4d} <Debug> oximeter.measurements_cumulativeu64 (758a8caf-c152-4627-a0a4-28144907e076): There are no data parts | ||
| 432 | 2024.10.09 22:36:12.550721 [ 3 ] {2b3997cd-c36a-48ad-ac93-fac8ffa62f4d} <Debug> DynamicQueryHandler: Done processing query | ||
| 433 | 2024.10.09 22:36:12.550753 [ 3 ] {} <Debug> HTTP-Session: cb886e28-df30-46b1-9571-cd1f7f6256ed Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 434 | 2024.10.09 22:36:12.551630 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 435 | 2024.10.09 22:36:12.551725 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 436 | 2024.10.09 22:36:12.551751 [ 3 ] {} <Debug> HTTP-Session: 767da5f8-d952-4a6c-983d-767bbbd54237 Authenticating user 'default' from [::1]:50315 | ||
| 437 | 2024.10.09 22:36:12.551775 [ 3 ] {} <Debug> HTTP-Session: 767da5f8-d952-4a6c-983d-767bbbd54237 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 438 | 2024.10.09 22:36:12.551800 [ 3 ] {} <Debug> HTTP-Session: 767da5f8-d952-4a6c-983d-767bbbd54237 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 439 | 2024.10.09 22:36:12.551849 [ 3 ] {} <Trace> HTTP-Session: 767da5f8-d952-4a6c-983d-767bbbd54237 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 440 | 2024.10.09 22:36:12.552386 [ 3 ] {94e34363-d13b-4325-b46d-5b2095046738} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 441 | 2024.10.09 22:36:12.552633 [ 3 ] {94e34363-d13b-4325-b46d-5b2095046738} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 442 | 2024.10.09 22:36:12.560062 [ 3 ] {94e34363-d13b-4325-b46d-5b2095046738} <Debug> oximeter.measurements_cumulativef32 (15222a0b-aebe-45d6-bb66-306749704b32): Loading data parts | ||
| 443 | 2024.10.09 22:36:12.560508 [ 3 ] {94e34363-d13b-4325-b46d-5b2095046738} <Debug> oximeter.measurements_cumulativef32 (15222a0b-aebe-45d6-bb66-306749704b32): There are no data parts | ||
| 444 | 2024.10.09 22:36:12.562482 [ 3 ] {94e34363-d13b-4325-b46d-5b2095046738} <Debug> DynamicQueryHandler: Done processing query | ||
| 445 | 2024.10.09 22:36:12.562529 [ 3 ] {} <Debug> HTTP-Session: 767da5f8-d952-4a6c-983d-767bbbd54237 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 446 | 2024.10.09 22:36:12.564098 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 447 | 2024.10.09 22:36:12.564184 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 448 | 2024.10.09 22:36:12.564225 [ 3 ] {} <Debug> HTTP-Session: 45754a38-96cc-4aa3-92f6-fd572bcb265a Authenticating user 'default' from [::1]:50315 | ||
| 449 | 2024.10.09 22:36:12.564253 [ 3 ] {} <Debug> HTTP-Session: 45754a38-96cc-4aa3-92f6-fd572bcb265a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 450 | 2024.10.09 22:36:12.564307 [ 3 ] {} <Debug> HTTP-Session: 45754a38-96cc-4aa3-92f6-fd572bcb265a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 451 | 2024.10.09 22:36:12.564380 [ 3 ] {} <Trace> HTTP-Session: 45754a38-96cc-4aa3-92f6-fd572bcb265a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 452 | 2024.10.09 22:36:12.564957 [ 3 ] {d8f6bf99-5bb0-4e38-8c1e-2bd8fd5c0f76} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 453 | 2024.10.09 22:36:12.565045 [ 3 ] {d8f6bf99-5bb0-4e38-8c1e-2bd8fd5c0f76} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 454 | 2024.10.09 22:36:12.567805 [ 3 ] {d8f6bf99-5bb0-4e38-8c1e-2bd8fd5c0f76} <Debug> oximeter.measurements_cumulativef64 (3a747787-a30f-4b13-b9e8-2f7a234bdedd): Loading data parts | ||
| 455 | 2024.10.09 22:36:12.568125 [ 3 ] {d8f6bf99-5bb0-4e38-8c1e-2bd8fd5c0f76} <Debug> oximeter.measurements_cumulativef64 (3a747787-a30f-4b13-b9e8-2f7a234bdedd): There are no data parts | ||
| 456 | 2024.10.09 22:36:12.570386 [ 3 ] {d8f6bf99-5bb0-4e38-8c1e-2bd8fd5c0f76} <Debug> DynamicQueryHandler: Done processing query | ||
| 457 | 2024.10.09 22:36:12.570415 [ 3 ] {} <Debug> HTTP-Session: 45754a38-96cc-4aa3-92f6-fd572bcb265a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 458 | 2024.10.09 22:36:12.579203 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 459 | 2024.10.09 22:36:12.579346 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 460 | 2024.10.09 22:36:12.579372 [ 3 ] {} <Debug> HTTP-Session: 416a8281-be0a-477c-8b60-779e0660d512 Authenticating user 'default' from [::1]:50315 | ||
| 461 | 2024.10.09 22:36:12.579398 [ 3 ] {} <Debug> HTTP-Session: 416a8281-be0a-477c-8b60-779e0660d512 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 462 | 2024.10.09 22:36:12.579419 [ 3 ] {} <Debug> HTTP-Session: 416a8281-be0a-477c-8b60-779e0660d512 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 463 | 2024.10.09 22:36:12.579474 [ 3 ] {} <Trace> HTTP-Session: 416a8281-be0a-477c-8b60-779e0660d512 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 464 | 2024.10.09 22:36:12.580128 [ 3 ] {04a11f76-5754-406b-b53c-2b0bb8674a98} <Debug> executeQuery: (from [::1]:50315) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 465 | * NOTE: Array types cannot be Nullable, see | ||
| 466 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 467 | * for more details. | ||
| 468 | * | ||
| 469 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 470 | * is unfortunate, and at this point relies on the fact that an | ||
| 471 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 472 | * to figure out another way to represent missing samples here. | ||
| 473 | */ | ||
| 474 | 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) | ||
| 475 | 2024.10.09 22:36:12.581303 [ 3 ] {04a11f76-5754-406b-b53c-2b0bb8674a98} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 476 | 2024.10.09 22:36:12.595062 [ 3 ] {04a11f76-5754-406b-b53c-2b0bb8674a98} <Debug> oximeter.measurements_histogrami8 (a54ca419-5135-4d2e-8f3a-037a49b7a18c): Loading data parts | ||
| 477 | 2024.10.09 22:36:12.595481 [ 3 ] {04a11f76-5754-406b-b53c-2b0bb8674a98} <Debug> oximeter.measurements_histogrami8 (a54ca419-5135-4d2e-8f3a-037a49b7a18c): There are no data parts | ||
| 478 | 2024.10.09 22:36:12.597631 [ 3 ] {04a11f76-5754-406b-b53c-2b0bb8674a98} <Debug> DynamicQueryHandler: Done processing query | ||
| 479 | 2024.10.09 22:36:12.597664 [ 3 ] {} <Debug> HTTP-Session: 416a8281-be0a-477c-8b60-779e0660d512 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 480 | 2024.10.09 22:36:12.599332 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 481 | 2024.10.09 22:36:12.599417 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 482 | 2024.10.09 22:36:12.599443 [ 3 ] {} <Debug> HTTP-Session: 145ee3db-b77d-431d-8423-5b63718787af Authenticating user 'default' from [::1]:50315 | ||
| 483 | 2024.10.09 22:36:12.599483 [ 3 ] {} <Debug> HTTP-Session: 145ee3db-b77d-431d-8423-5b63718787af Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 484 | 2024.10.09 22:36:12.599500 [ 3 ] {} <Debug> HTTP-Session: 145ee3db-b77d-431d-8423-5b63718787af Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 485 | 2024.10.09 22:36:12.599553 [ 3 ] {} <Trace> HTTP-Session: 145ee3db-b77d-431d-8423-5b63718787af Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 486 | 2024.10.09 22:36:12.600409 [ 3 ] {d908f72f-ed3f-42d9-8d4b-87f66edb74e6} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 487 | 2024.10.09 22:36:12.600513 [ 3 ] {d908f72f-ed3f-42d9-8d4b-87f66edb74e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 488 | 2024.10.09 22:36:12.611583 [ 3 ] {d908f72f-ed3f-42d9-8d4b-87f66edb74e6} <Debug> oximeter.measurements_histogramu8 (16127cf4-7169-4bfd-8b86-c7b0a3ca0930): Loading data parts | ||
| 489 | 2024.10.09 22:36:12.614241 [ 3 ] {d908f72f-ed3f-42d9-8d4b-87f66edb74e6} <Debug> oximeter.measurements_histogramu8 (16127cf4-7169-4bfd-8b86-c7b0a3ca0930): There are no data parts | ||
| 490 | 2024.10.09 22:36:12.616441 [ 3 ] {d908f72f-ed3f-42d9-8d4b-87f66edb74e6} <Debug> DynamicQueryHandler: Done processing query | ||
| 491 | 2024.10.09 22:36:12.616474 [ 3 ] {} <Debug> HTTP-Session: 145ee3db-b77d-431d-8423-5b63718787af Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 492 | 2024.10.09 22:36:12.620371 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 493 | 2024.10.09 22:36:12.620691 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 494 | 2024.10.09 22:36:12.620719 [ 3 ] {} <Debug> HTTP-Session: 36933e9f-8016-4cd6-a56c-35e85bf92582 Authenticating user 'default' from [::1]:50315 | ||
| 495 | 2024.10.09 22:36:12.620745 [ 3 ] {} <Debug> HTTP-Session: 36933e9f-8016-4cd6-a56c-35e85bf92582 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 496 | 2024.10.09 22:36:12.620772 [ 3 ] {} <Debug> HTTP-Session: 36933e9f-8016-4cd6-a56c-35e85bf92582 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 497 | 2024.10.09 22:36:12.620830 [ 3 ] {} <Trace> HTTP-Session: 36933e9f-8016-4cd6-a56c-35e85bf92582 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 498 | 2024.10.09 22:36:12.621340 [ 3 ] {d5813efa-6939-41b6-9c59-c22185594356} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 499 | 2024.10.09 22:36:12.621445 [ 3 ] {d5813efa-6939-41b6-9c59-c22185594356} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 500 | 2024.10.09 22:36:12.624780 [ 3 ] {d5813efa-6939-41b6-9c59-c22185594356} <Debug> oximeter.measurements_histogrami16 (eb34b5dd-d29b-4e45-b3d5-0922a2cab4d7): Loading data parts | ||
| 501 | 2024.10.09 22:36:12.625153 [ 3 ] {d5813efa-6939-41b6-9c59-c22185594356} <Debug> oximeter.measurements_histogrami16 (eb34b5dd-d29b-4e45-b3d5-0922a2cab4d7): There are no data parts | ||
| 502 | 2024.10.09 22:36:12.627248 [ 3 ] {d5813efa-6939-41b6-9c59-c22185594356} <Debug> DynamicQueryHandler: Done processing query | ||
| 503 | 2024.10.09 22:36:12.627281 [ 3 ] {} <Debug> HTTP-Session: 36933e9f-8016-4cd6-a56c-35e85bf92582 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 504 | 2024.10.09 22:36:12.977554 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 505 | 2024.10.09 22:36:12.977710 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 506 | 2024.10.09 22:36:12.977751 [ 3 ] {} <Debug> HTTP-Session: 70f4f802-c387-4344-a525-a1e0eca79706 Authenticating user 'default' from [::1]:50315 | ||
| 507 | 2024.10.09 22:36:12.978008 [ 3 ] {} <Debug> HTTP-Session: 70f4f802-c387-4344-a525-a1e0eca79706 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 508 | 2024.10.09 22:36:12.978085 [ 3 ] {} <Debug> HTTP-Session: 70f4f802-c387-4344-a525-a1e0eca79706 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 509 | 2024.10.09 22:36:12.978473 [ 3 ] {} <Trace> HTTP-Session: 70f4f802-c387-4344-a525-a1e0eca79706 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 510 | 2024.10.09 22:36:12.979295 [ 3 ] {24a0e7d5-584b-4cf8-a506-1ea7b14ca48f} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 511 | 2024.10.09 22:36:12.979453 [ 3 ] {24a0e7d5-584b-4cf8-a506-1ea7b14ca48f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 512 | 2024.10.09 22:36:12.983393 [ 3 ] {24a0e7d5-584b-4cf8-a506-1ea7b14ca48f} <Debug> oximeter.measurements_histogramu16 (0c3228e6-992a-41ae-a709-6ffe13d1eda7): Loading data parts | ||
| 513 | 2024.10.09 22:36:12.983757 [ 3 ] {24a0e7d5-584b-4cf8-a506-1ea7b14ca48f} <Debug> oximeter.measurements_histogramu16 (0c3228e6-992a-41ae-a709-6ffe13d1eda7): There are no data parts | ||
| 514 | 2024.10.09 22:36:12.985838 [ 3 ] {24a0e7d5-584b-4cf8-a506-1ea7b14ca48f} <Debug> DynamicQueryHandler: Done processing query | ||
| 515 | 2024.10.09 22:36:12.985885 [ 3 ] {} <Debug> HTTP-Session: 70f4f802-c387-4344-a525-a1e0eca79706 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 516 | 2024.10.09 22:36:13.000439 [ 246 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 141.92 MiB, peak 142.94 MiB, free memory in arenas 0.00 B, will set to 146.89 MiB (RSS), difference: 4.97 MiB | ||
| 517 | 2024.10.09 22:36:13.002690 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 518 | 2024.10.09 22:36:13.002834 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 519 | 2024.10.09 22:36:13.002862 [ 3 ] {} <Debug> HTTP-Session: 26742b2e-8bd4-46cc-8325-b7da71c6004e Authenticating user 'default' from [::1]:50315 | ||
| 520 | 2024.10.09 22:36:13.002891 [ 3 ] {} <Debug> HTTP-Session: 26742b2e-8bd4-46cc-8325-b7da71c6004e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 521 | 2024.10.09 22:36:13.002916 [ 3 ] {} <Debug> HTTP-Session: 26742b2e-8bd4-46cc-8325-b7da71c6004e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 522 | 2024.10.09 22:36:13.002978 [ 3 ] {} <Trace> HTTP-Session: 26742b2e-8bd4-46cc-8325-b7da71c6004e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 523 | 2024.10.09 22:36:13.004221 [ 3 ] {d3952d9c-0219-423d-a78b-89866edb61a6} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 524 | 2024.10.09 22:36:13.004329 [ 3 ] {d3952d9c-0219-423d-a78b-89866edb61a6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 525 | 2024.10.09 22:36:13.011033 [ 3 ] {d3952d9c-0219-423d-a78b-89866edb61a6} <Debug> oximeter.measurements_histogrami32 (15a67b89-7abb-4786-ad60-9aa2d9552eca): Loading data parts | ||
| 526 | 2024.10.09 22:36:13.017398 [ 3 ] {d3952d9c-0219-423d-a78b-89866edb61a6} <Debug> oximeter.measurements_histogrami32 (15a67b89-7abb-4786-ad60-9aa2d9552eca): There are no data parts | ||
| 527 | 2024.10.09 22:36:13.020275 [ 3 ] {d3952d9c-0219-423d-a78b-89866edb61a6} <Debug> DynamicQueryHandler: Done processing query | ||
| 528 | 2024.10.09 22:36:13.020440 [ 3 ] {} <Debug> HTTP-Session: 26742b2e-8bd4-46cc-8325-b7da71c6004e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 529 | 2024.10.09 22:36:13.033702 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 530 | 2024.10.09 22:36:13.033833 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 531 | 2024.10.09 22:36:13.033890 [ 3 ] {} <Debug> HTTP-Session: 86452a27-a6ed-4ecf-af7f-4ed5e605d031 Authenticating user 'default' from [::1]:50315 | ||
| 532 | 2024.10.09 22:36:13.033918 [ 3 ] {} <Debug> HTTP-Session: 86452a27-a6ed-4ecf-af7f-4ed5e605d031 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 533 | 2024.10.09 22:36:13.033934 [ 3 ] {} <Debug> HTTP-Session: 86452a27-a6ed-4ecf-af7f-4ed5e605d031 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 534 | 2024.10.09 22:36:13.034017 [ 3 ] {} <Trace> HTTP-Session: 86452a27-a6ed-4ecf-af7f-4ed5e605d031 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 535 | 2024.10.09 22:36:13.034563 [ 3 ] {e5492c5a-33de-4eae-a93c-87f47425d847} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 536 | 2024.10.09 22:36:13.034666 [ 3 ] {e5492c5a-33de-4eae-a93c-87f47425d847} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 537 | 2024.10.09 22:36:13.037975 [ 3 ] {e5492c5a-33de-4eae-a93c-87f47425d847} <Debug> oximeter.measurements_histogramu32 (3a976c1f-bfd2-4670-b62b-928c49ca7541): Loading data parts | ||
| 538 | 2024.10.09 22:36:13.038397 [ 3 ] {e5492c5a-33de-4eae-a93c-87f47425d847} <Debug> oximeter.measurements_histogramu32 (3a976c1f-bfd2-4670-b62b-928c49ca7541): There are no data parts | ||
| 539 | 2024.10.09 22:36:13.040864 [ 3 ] {e5492c5a-33de-4eae-a93c-87f47425d847} <Debug> DynamicQueryHandler: Done processing query | ||
| 540 | 2024.10.09 22:36:13.040898 [ 3 ] {} <Debug> HTTP-Session: 86452a27-a6ed-4ecf-af7f-4ed5e605d031 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 541 | 2024.10.09 22:36:13.049597 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 542 | 2024.10.09 22:36:13.049742 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 543 | 2024.10.09 22:36:13.049770 [ 3 ] {} <Debug> HTTP-Session: b8b022b1-196e-443a-a833-a61a012495b3 Authenticating user 'default' from [::1]:50315 | ||
| 544 | 2024.10.09 22:36:13.049838 [ 3 ] {} <Debug> HTTP-Session: b8b022b1-196e-443a-a833-a61a012495b3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 545 | 2024.10.09 22:36:13.049899 [ 3 ] {} <Debug> HTTP-Session: b8b022b1-196e-443a-a833-a61a012495b3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 546 | 2024.10.09 22:36:13.049967 [ 3 ] {} <Trace> HTTP-Session: b8b022b1-196e-443a-a833-a61a012495b3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 547 | 2024.10.09 22:36:13.050569 [ 3 ] {de768883-8923-4eed-be89-ed0bb4fea748} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 548 | 2024.10.09 22:36:13.051193 [ 3 ] {de768883-8923-4eed-be89-ed0bb4fea748} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 549 | 2024.10.09 22:36:13.058116 [ 3 ] {de768883-8923-4eed-be89-ed0bb4fea748} <Debug> oximeter.measurements_histogrami64 (6dd056ba-97bd-4522-827e-da314a36e9d4): Loading data parts | ||
| 550 | 2024.10.09 22:36:13.058503 [ 3 ] {de768883-8923-4eed-be89-ed0bb4fea748} <Debug> oximeter.measurements_histogrami64 (6dd056ba-97bd-4522-827e-da314a36e9d4): There are no data parts | ||
| 551 | 2024.10.09 22:36:13.060862 [ 3 ] {de768883-8923-4eed-be89-ed0bb4fea748} <Debug> DynamicQueryHandler: Done processing query | ||
| 552 | 2024.10.09 22:36:13.060899 [ 3 ] {} <Debug> HTTP-Session: b8b022b1-196e-443a-a833-a61a012495b3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 553 | 2024.10.09 22:36:13.064726 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 554 | 2024.10.09 22:36:13.064867 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 555 | 2024.10.09 22:36:13.064894 [ 3 ] {} <Debug> HTTP-Session: 8386dfb6-05b1-4aed-965e-0480092538da Authenticating user 'default' from [::1]:50315 | ||
| 556 | 2024.10.09 22:36:13.064936 [ 3 ] {} <Debug> HTTP-Session: 8386dfb6-05b1-4aed-965e-0480092538da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 557 | 2024.10.09 22:36:13.064951 [ 3 ] {} <Debug> HTTP-Session: 8386dfb6-05b1-4aed-965e-0480092538da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 558 | 2024.10.09 22:36:13.065004 [ 3 ] {} <Trace> HTTP-Session: 8386dfb6-05b1-4aed-965e-0480092538da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 559 | 2024.10.09 22:36:13.065595 [ 3 ] {6968cde2-9db1-47f3-8bc3-77beb283e3bf} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 560 | 2024.10.09 22:36:13.065706 [ 3 ] {6968cde2-9db1-47f3-8bc3-77beb283e3bf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 561 | 2024.10.09 22:36:13.070922 [ 3 ] {6968cde2-9db1-47f3-8bc3-77beb283e3bf} <Debug> oximeter.measurements_histogramu64 (41e20ed8-663b-4c7a-8ed7-d770f6a2c4bf): Loading data parts | ||
| 562 | 2024.10.09 22:36:13.071313 [ 3 ] {6968cde2-9db1-47f3-8bc3-77beb283e3bf} <Debug> oximeter.measurements_histogramu64 (41e20ed8-663b-4c7a-8ed7-d770f6a2c4bf): There are no data parts | ||
| 563 | 2024.10.09 22:36:13.073304 [ 3 ] {6968cde2-9db1-47f3-8bc3-77beb283e3bf} <Debug> DynamicQueryHandler: Done processing query | ||
| 564 | 2024.10.09 22:36:13.073336 [ 3 ] {} <Debug> HTTP-Session: 8386dfb6-05b1-4aed-965e-0480092538da Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 565 | 2024.10.09 22:36:13.088301 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 566 | 2024.10.09 22:36:13.088466 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 567 | 2024.10.09 22:36:13.088494 [ 3 ] {} <Debug> HTTP-Session: 54bc2ef0-955c-4068-bdc4-6cf4d5c80b55 Authenticating user 'default' from [::1]:50315 | ||
| 568 | 2024.10.09 22:36:13.088541 [ 3 ] {} <Debug> HTTP-Session: 54bc2ef0-955c-4068-bdc4-6cf4d5c80b55 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 569 | 2024.10.09 22:36:13.088562 [ 3 ] {} <Debug> HTTP-Session: 54bc2ef0-955c-4068-bdc4-6cf4d5c80b55 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 570 | 2024.10.09 22:36:13.088636 [ 3 ] {} <Trace> HTTP-Session: 54bc2ef0-955c-4068-bdc4-6cf4d5c80b55 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 571 | 2024.10.09 22:36:13.089159 [ 3 ] {4975a958-dcc1-4953-a8d8-2696f6ce7543} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 572 | 2024.10.09 22:36:13.089264 [ 3 ] {4975a958-dcc1-4953-a8d8-2696f6ce7543} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 573 | 2024.10.09 22:36:13.092635 [ 3 ] {4975a958-dcc1-4953-a8d8-2696f6ce7543} <Debug> oximeter.measurements_histogramf32 (d855f1ad-284d-4a00-bede-561d746c218c): Loading data parts | ||
| 574 | 2024.10.09 22:36:13.092989 [ 3 ] {4975a958-dcc1-4953-a8d8-2696f6ce7543} <Debug> oximeter.measurements_histogramf32 (d855f1ad-284d-4a00-bede-561d746c218c): There are no data parts | ||
| 575 | 2024.10.09 22:36:13.095050 [ 3 ] {4975a958-dcc1-4953-a8d8-2696f6ce7543} <Debug> DynamicQueryHandler: Done processing query | ||
| 576 | 2024.10.09 22:36:13.095091 [ 3 ] {} <Debug> HTTP-Session: 54bc2ef0-955c-4068-bdc4-6cf4d5c80b55 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 577 | 2024.10.09 22:36:13.125736 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 578 | 2024.10.09 22:36:13.125879 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 579 | 2024.10.09 22:36:13.125907 [ 3 ] {} <Debug> HTTP-Session: 4c0c94c2-76cd-4d90-8930-3054ff257940 Authenticating user 'default' from [::1]:50315 | ||
| 580 | 2024.10.09 22:36:13.125960 [ 3 ] {} <Debug> HTTP-Session: 4c0c94c2-76cd-4d90-8930-3054ff257940 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 581 | 2024.10.09 22:36:13.125978 [ 3 ] {} <Debug> HTTP-Session: 4c0c94c2-76cd-4d90-8930-3054ff257940 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 582 | 2024.10.09 22:36:13.126039 [ 3 ] {} <Trace> HTTP-Session: 4c0c94c2-76cd-4d90-8930-3054ff257940 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 583 | 2024.10.09 22:36:13.126578 [ 3 ] {8928a1cd-cdd6-4ee2-a131-5b4f69b57aa8} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 584 | 2024.10.09 22:36:13.126680 [ 3 ] {8928a1cd-cdd6-4ee2-a131-5b4f69b57aa8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 585 | 2024.10.09 22:36:13.130033 [ 3 ] {8928a1cd-cdd6-4ee2-a131-5b4f69b57aa8} <Debug> oximeter.measurements_histogramf64 (4c417def-4ce0-4d87-8411-f45bcacaa10b): Loading data parts | ||
| 586 | 2024.10.09 22:36:13.130401 [ 3 ] {8928a1cd-cdd6-4ee2-a131-5b4f69b57aa8} <Debug> oximeter.measurements_histogramf64 (4c417def-4ce0-4d87-8411-f45bcacaa10b): There are no data parts | ||
| 587 | 2024.10.09 22:36:13.132401 [ 3 ] {8928a1cd-cdd6-4ee2-a131-5b4f69b57aa8} <Debug> DynamicQueryHandler: Done processing query | ||
| 588 | 2024.10.09 22:36:13.132458 [ 3 ] {} <Debug> HTTP-Session: 4c0c94c2-76cd-4d90-8930-3054ff257940 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 589 | 2024.10.09 22:36:13.133570 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 590 | 2024.10.09 22:36:13.133698 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 591 | 2024.10.09 22:36:13.133749 [ 3 ] {} <Debug> HTTP-Session: 8f56ca98-c6e1-4f97-8f6f-a022b7225e2d Authenticating user 'default' from [::1]:50315 | ||
| 592 | 2024.10.09 22:36:13.133781 [ 3 ] {} <Debug> HTTP-Session: 8f56ca98-c6e1-4f97-8f6f-a022b7225e2d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 593 | 2024.10.09 22:36:13.133802 [ 3 ] {} <Debug> HTTP-Session: 8f56ca98-c6e1-4f97-8f6f-a022b7225e2d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 594 | 2024.10.09 22:36:13.133874 [ 3 ] {} <Trace> HTTP-Session: 8f56ca98-c6e1-4f97-8f6f-a022b7225e2d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 595 | 2024.10.09 22:36:13.134244 [ 3 ] {cbba3c49-4de6-4e63-b562-df7921e60d5d} <Debug> executeQuery: (from [::1]:50315) /* The field tables store named dimensions of each timeseries. | ||
| 596 | * | ||
| 597 | * As with the measurement tables, there is one field table for each field data | ||
| 598 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 599 | * this behavior **must not** be relied upon for query correctness. | ||
| 600 | * | ||
| 601 | * The index for the fields differs from the measurements, however. Rows are | ||
| 602 | * sorted by timeseries name, then field name, field value, and finally | ||
| 603 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 604 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 605 | * usually then used to look up measurements. | ||
| 606 | * | ||
| 607 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 608 | * timeseries name and then key, since it would improve lookups where one | ||
| 609 | * already has the key. Realistically though, these tables are quite small and | ||
| 610 | * so performance benefits will be low in absolute terms. | ||
| 611 | * | ||
| 612 | * TTL: We use a materialized column to expire old field table records. This | ||
| 613 | * column is generated automatically by the database whenever a new row is | ||
| 614 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 615 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 616 | * record will remain during a deduplication, which will have the last | ||
| 617 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 618 | * measurement tables. | ||
| 619 | */ | ||
| 620 | 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) | ||
| 621 | 2024.10.09 22:36:13.134345 [ 3 ] {cbba3c49-4de6-4e63-b562-df7921e60d5d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 622 | 2024.10.09 22:36:13.137336 [ 3 ] {cbba3c49-4de6-4e63-b562-df7921e60d5d} <Debug> oximeter.fields_bool (84bbcf75-3c10-4b23-9c71-a65776481bc2): Loading data parts | ||
| 623 | 2024.10.09 22:36:13.137787 [ 3 ] {cbba3c49-4de6-4e63-b562-df7921e60d5d} <Debug> oximeter.fields_bool (84bbcf75-3c10-4b23-9c71-a65776481bc2): There are no data parts | ||
| 624 | 2024.10.09 22:36:13.139657 [ 3 ] {cbba3c49-4de6-4e63-b562-df7921e60d5d} <Debug> DynamicQueryHandler: Done processing query | ||
| 625 | 2024.10.09 22:36:13.139694 [ 3 ] {} <Debug> HTTP-Session: 8f56ca98-c6e1-4f97-8f6f-a022b7225e2d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 626 | 2024.10.09 22:36:13.141224 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 627 | 2024.10.09 22:36:13.141341 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 628 | 2024.10.09 22:36:13.141373 [ 3 ] {} <Debug> HTTP-Session: e0dc26d6-17c2-4a71-94a5-6835161b4f4b Authenticating user 'default' from [::1]:50315 | ||
| 629 | 2024.10.09 22:36:13.141401 [ 3 ] {} <Debug> HTTP-Session: e0dc26d6-17c2-4a71-94a5-6835161b4f4b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 630 | 2024.10.09 22:36:13.141431 [ 3 ] {} <Debug> HTTP-Session: e0dc26d6-17c2-4a71-94a5-6835161b4f4b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 631 | 2024.10.09 22:36:13.141487 [ 3 ] {} <Trace> HTTP-Session: e0dc26d6-17c2-4a71-94a5-6835161b4f4b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 632 | 2024.10.09 22:36:13.141842 [ 3 ] {ce016623-cd10-4fa2-aba0-2de58f9ba9a4} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 633 | 2024.10.09 22:36:13.141930 [ 3 ] {ce016623-cd10-4fa2-aba0-2de58f9ba9a4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 634 | 2024.10.09 22:36:13.144993 [ 3 ] {ce016623-cd10-4fa2-aba0-2de58f9ba9a4} <Debug> oximeter.fields_i8 (34a23f89-4345-4971-8c67-d7b9accbc05c): Loading data parts | ||
| 635 | 2024.10.09 22:36:13.145334 [ 3 ] {ce016623-cd10-4fa2-aba0-2de58f9ba9a4} <Debug> oximeter.fields_i8 (34a23f89-4345-4971-8c67-d7b9accbc05c): There are no data parts | ||
| 636 | 2024.10.09 22:36:13.147452 [ 3 ] {ce016623-cd10-4fa2-aba0-2de58f9ba9a4} <Debug> DynamicQueryHandler: Done processing query | ||
| 637 | 2024.10.09 22:36:13.147485 [ 3 ] {} <Debug> HTTP-Session: e0dc26d6-17c2-4a71-94a5-6835161b4f4b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 638 | 2024.10.09 22:36:13.153379 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 639 | 2024.10.09 22:36:13.153506 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 640 | 2024.10.09 22:36:13.153604 [ 3 ] {} <Debug> HTTP-Session: 990412be-017e-4b86-b5fd-31bbc2130d2c Authenticating user 'default' from [::1]:50315 | ||
| 641 | 2024.10.09 22:36:13.155933 [ 3 ] {} <Debug> HTTP-Session: 990412be-017e-4b86-b5fd-31bbc2130d2c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 642 | 2024.10.09 22:36:13.155960 [ 3 ] {} <Debug> HTTP-Session: 990412be-017e-4b86-b5fd-31bbc2130d2c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 643 | 2024.10.09 22:36:13.156047 [ 3 ] {} <Trace> HTTP-Session: 990412be-017e-4b86-b5fd-31bbc2130d2c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 644 | 2024.10.09 22:36:13.156521 [ 3 ] {d0f0c4ac-f0fd-4f3b-a3e8-40594d076994} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 645 | 2024.10.09 22:36:13.156665 [ 3 ] {d0f0c4ac-f0fd-4f3b-a3e8-40594d076994} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 646 | 2024.10.09 22:36:13.161148 [ 3 ] {d0f0c4ac-f0fd-4f3b-a3e8-40594d076994} <Debug> oximeter.fields_u8 (8e915f26-73fd-49e8-abf8-1387161787d8): Loading data parts | ||
| 647 | 2024.10.09 22:36:13.161634 [ 3 ] {d0f0c4ac-f0fd-4f3b-a3e8-40594d076994} <Debug> oximeter.fields_u8 (8e915f26-73fd-49e8-abf8-1387161787d8): There are no data parts | ||
| 648 | 2024.10.09 22:36:13.167721 [ 3 ] {d0f0c4ac-f0fd-4f3b-a3e8-40594d076994} <Debug> DynamicQueryHandler: Done processing query | ||
| 649 | 2024.10.09 22:36:13.167816 [ 3 ] {} <Debug> HTTP-Session: 990412be-017e-4b86-b5fd-31bbc2130d2c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 650 | 2024.10.09 22:36:13.169413 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 651 | 2024.10.09 22:36:13.169586 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 652 | 2024.10.09 22:36:13.169616 [ 3 ] {} <Debug> HTTP-Session: 29d5225c-9f59-45aa-81e1-8f1fa09be657 Authenticating user 'default' from [::1]:50315 | ||
| 653 | 2024.10.09 22:36:13.169640 [ 3 ] {} <Debug> HTTP-Session: 29d5225c-9f59-45aa-81e1-8f1fa09be657 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 654 | 2024.10.09 22:36:13.169702 [ 3 ] {} <Debug> HTTP-Session: 29d5225c-9f59-45aa-81e1-8f1fa09be657 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 655 | 2024.10.09 22:36:13.169763 [ 3 ] {} <Trace> HTTP-Session: 29d5225c-9f59-45aa-81e1-8f1fa09be657 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 656 | 2024.10.09 22:36:13.170252 [ 3 ] {698c2024-0653-429b-963f-974fbe0c1b7e} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 657 | 2024.10.09 22:36:13.170354 [ 3 ] {698c2024-0653-429b-963f-974fbe0c1b7e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 658 | 2024.10.09 22:36:13.187093 [ 3 ] {698c2024-0653-429b-963f-974fbe0c1b7e} <Debug> oximeter.fields_i16 (80f02749-b703-4e23-bfbe-0d95f56d70dc): Loading data parts | ||
| 659 | 2024.10.09 22:36:13.188260 [ 3 ] {698c2024-0653-429b-963f-974fbe0c1b7e} <Debug> oximeter.fields_i16 (80f02749-b703-4e23-bfbe-0d95f56d70dc): There are no data parts | ||
| 660 | 2024.10.09 22:36:13.193878 [ 3 ] {698c2024-0653-429b-963f-974fbe0c1b7e} <Debug> DynamicQueryHandler: Done processing query | ||
| 661 | 2024.10.09 22:36:13.193934 [ 3 ] {} <Debug> HTTP-Session: 29d5225c-9f59-45aa-81e1-8f1fa09be657 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 662 | 2024.10.09 22:36:13.212123 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 663 | 2024.10.09 22:36:13.212257 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 664 | 2024.10.09 22:36:13.212289 [ 3 ] {} <Debug> HTTP-Session: 05b83c35-9c63-4bbf-bedb-2851cf1f3f75 Authenticating user 'default' from [::1]:50315 | ||
| 665 | 2024.10.09 22:36:13.212344 [ 3 ] {} <Debug> HTTP-Session: 05b83c35-9c63-4bbf-bedb-2851cf1f3f75 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 666 | 2024.10.09 22:36:13.212361 [ 3 ] {} <Debug> HTTP-Session: 05b83c35-9c63-4bbf-bedb-2851cf1f3f75 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 667 | 2024.10.09 22:36:13.212418 [ 3 ] {} <Trace> HTTP-Session: 05b83c35-9c63-4bbf-bedb-2851cf1f3f75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 668 | 2024.10.09 22:36:13.212923 [ 3 ] {aa5c8ce9-f6b7-49d0-b704-eb67d72bf631} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 669 | 2024.10.09 22:36:13.213524 [ 3 ] {aa5c8ce9-f6b7-49d0-b704-eb67d72bf631} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 670 | 2024.10.09 22:36:13.230953 [ 3 ] {aa5c8ce9-f6b7-49d0-b704-eb67d72bf631} <Debug> oximeter.fields_u16 (308f0fd1-d0b2-416d-8401-e0f7fd02c694): Loading data parts | ||
| 671 | 2024.10.09 22:36:13.231420 [ 3 ] {aa5c8ce9-f6b7-49d0-b704-eb67d72bf631} <Debug> oximeter.fields_u16 (308f0fd1-d0b2-416d-8401-e0f7fd02c694): There are no data parts | ||
| 672 | 2024.10.09 22:36:13.237361 [ 3 ] {aa5c8ce9-f6b7-49d0-b704-eb67d72bf631} <Debug> DynamicQueryHandler: Done processing query | ||
| 673 | 2024.10.09 22:36:13.237404 [ 3 ] {} <Debug> HTTP-Session: 05b83c35-9c63-4bbf-bedb-2851cf1f3f75 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 674 | 2024.10.09 22:36:13.246180 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 675 | 2024.10.09 22:36:13.246355 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 676 | 2024.10.09 22:36:13.246385 [ 3 ] {} <Debug> HTTP-Session: d55b1867-426c-4e00-9274-9f4c657c4f3c Authenticating user 'default' from [::1]:50315 | ||
| 677 | 2024.10.09 22:36:13.246413 [ 3 ] {} <Debug> HTTP-Session: d55b1867-426c-4e00-9274-9f4c657c4f3c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 678 | 2024.10.09 22:36:13.246428 [ 3 ] {} <Debug> HTTP-Session: d55b1867-426c-4e00-9274-9f4c657c4f3c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 679 | 2024.10.09 22:36:13.246495 [ 3 ] {} <Trace> HTTP-Session: d55b1867-426c-4e00-9274-9f4c657c4f3c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 680 | 2024.10.09 22:36:13.247099 [ 3 ] {3301cbe6-9cbd-48c0-b992-65b96fed3192} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 681 | 2024.10.09 22:36:13.247197 [ 3 ] {3301cbe6-9cbd-48c0-b992-65b96fed3192} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 682 | 2024.10.09 22:36:13.267069 [ 3 ] {3301cbe6-9cbd-48c0-b992-65b96fed3192} <Debug> oximeter.fields_i32 (fba7de85-8498-4f86-866a-3c35079a71d7): Loading data parts | ||
| 683 | 2024.10.09 22:36:13.292196 [ 3 ] {3301cbe6-9cbd-48c0-b992-65b96fed3192} <Debug> oximeter.fields_i32 (fba7de85-8498-4f86-866a-3c35079a71d7): There are no data parts | ||
| 684 | 2024.10.09 22:36:13.302493 [ 3 ] {3301cbe6-9cbd-48c0-b992-65b96fed3192} <Debug> DynamicQueryHandler: Done processing query | ||
| 685 | 2024.10.09 22:36:13.302536 [ 3 ] {} <Debug> HTTP-Session: d55b1867-426c-4e00-9274-9f4c657c4f3c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 686 | 2024.10.09 22:36:13.318380 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 687 | 2024.10.09 22:36:13.318987 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 688 | 2024.10.09 22:36:13.319023 [ 3 ] {} <Debug> HTTP-Session: 649b2f5a-575c-4a6e-913b-c6ac2b772af7 Authenticating user 'default' from [::1]:50315 | ||
| 689 | 2024.10.09 22:36:13.319078 [ 3 ] {} <Debug> HTTP-Session: 649b2f5a-575c-4a6e-913b-c6ac2b772af7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 690 | 2024.10.09 22:36:13.319096 [ 3 ] {} <Debug> HTTP-Session: 649b2f5a-575c-4a6e-913b-c6ac2b772af7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 691 | 2024.10.09 22:36:13.319155 [ 3 ] {} <Trace> HTTP-Session: 649b2f5a-575c-4a6e-913b-c6ac2b772af7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 692 | 2024.10.09 22:36:13.319763 [ 3 ] {731de5af-aa99-45a6-bce8-9e4674297ad4} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 693 | 2024.10.09 22:36:13.319857 [ 3 ] {731de5af-aa99-45a6-bce8-9e4674297ad4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 694 | 2024.10.09 22:36:13.328572 [ 3 ] {731de5af-aa99-45a6-bce8-9e4674297ad4} <Debug> oximeter.fields_u32 (16e03e56-6c9f-4e39-9ac4-2892053b3695): Loading data parts | ||
| 695 | 2024.10.09 22:36:13.330243 [ 3 ] {731de5af-aa99-45a6-bce8-9e4674297ad4} <Debug> oximeter.fields_u32 (16e03e56-6c9f-4e39-9ac4-2892053b3695): There are no data parts | ||
| 696 | 2024.10.09 22:36:13.336600 [ 3 ] {731de5af-aa99-45a6-bce8-9e4674297ad4} <Debug> DynamicQueryHandler: Done processing query | ||
| 697 | 2024.10.09 22:36:13.336634 [ 3 ] {} <Debug> HTTP-Session: 649b2f5a-575c-4a6e-913b-c6ac2b772af7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 698 | 2024.10.09 22:36:13.427458 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 699 | 2024.10.09 22:36:13.427668 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 700 | 2024.10.09 22:36:13.427698 [ 3 ] {} <Debug> HTTP-Session: 181e7ab8-02ca-4896-8c9f-b42675b1f468 Authenticating user 'default' from [::1]:50315 | ||
| 701 | 2024.10.09 22:36:13.427726 [ 3 ] {} <Debug> HTTP-Session: 181e7ab8-02ca-4896-8c9f-b42675b1f468 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 702 | 2024.10.09 22:36:13.427742 [ 3 ] {} <Debug> HTTP-Session: 181e7ab8-02ca-4896-8c9f-b42675b1f468 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 703 | 2024.10.09 22:36:13.427812 [ 3 ] {} <Trace> HTTP-Session: 181e7ab8-02ca-4896-8c9f-b42675b1f468 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 704 | 2024.10.09 22:36:13.428279 [ 3 ] {c30fae90-9ecb-4706-bf9c-91e6380ad6f6} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 705 | 2024.10.09 22:36:13.428374 [ 3 ] {c30fae90-9ecb-4706-bf9c-91e6380ad6f6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 706 | 2024.10.09 22:36:13.432632 [ 3 ] {c30fae90-9ecb-4706-bf9c-91e6380ad6f6} <Debug> oximeter.fields_i64 (4469106b-965c-403d-8261-8e06e5ba3786): Loading data parts | ||
| 707 | 2024.10.09 22:36:13.432985 [ 3 ] {c30fae90-9ecb-4706-bf9c-91e6380ad6f6} <Debug> oximeter.fields_i64 (4469106b-965c-403d-8261-8e06e5ba3786): There are no data parts | ||
| 708 | 2024.10.09 22:36:13.439835 [ 3 ] {c30fae90-9ecb-4706-bf9c-91e6380ad6f6} <Debug> DynamicQueryHandler: Done processing query | ||
| 709 | 2024.10.09 22:36:13.439911 [ 3 ] {} <Debug> HTTP-Session: 181e7ab8-02ca-4896-8c9f-b42675b1f468 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 710 | 2024.10.09 22:36:13.504529 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 711 | 2024.10.09 22:36:13.504717 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 712 | 2024.10.09 22:36:13.504760 [ 3 ] {} <Debug> HTTP-Session: 59965bf4-13c1-4f4c-a2d6-9e5d4626626f Authenticating user 'default' from [::1]:50315 | ||
| 713 | 2024.10.09 22:36:13.504796 [ 3 ] {} <Debug> HTTP-Session: 59965bf4-13c1-4f4c-a2d6-9e5d4626626f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 714 | 2024.10.09 22:36:13.504811 [ 3 ] {} <Debug> HTTP-Session: 59965bf4-13c1-4f4c-a2d6-9e5d4626626f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 715 | 2024.10.09 22:36:13.504879 [ 3 ] {} <Trace> HTTP-Session: 59965bf4-13c1-4f4c-a2d6-9e5d4626626f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 716 | 2024.10.09 22:36:13.505749 [ 3 ] {33fee26a-72eb-49b8-ad47-894b57a990c4} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 717 | 2024.10.09 22:36:13.505847 [ 3 ] {33fee26a-72eb-49b8-ad47-894b57a990c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 718 | 2024.10.09 22:36:13.509315 [ 3 ] {33fee26a-72eb-49b8-ad47-894b57a990c4} <Debug> oximeter.fields_u64 (639e43fe-d55c-448c-8437-f27e23c7e70a): Loading data parts | ||
| 719 | 2024.10.09 22:36:13.511199 [ 3 ] {33fee26a-72eb-49b8-ad47-894b57a990c4} <Debug> oximeter.fields_u64 (639e43fe-d55c-448c-8437-f27e23c7e70a): There are no data parts | ||
| 720 | 2024.10.09 22:36:13.513633 [ 3 ] {33fee26a-72eb-49b8-ad47-894b57a990c4} <Debug> DynamicQueryHandler: Done processing query | ||
| 721 | 2024.10.09 22:36:13.513676 [ 3 ] {} <Debug> HTTP-Session: 59965bf4-13c1-4f4c-a2d6-9e5d4626626f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 722 | 2024.10.09 22:36:13.525306 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 723 | 2024.10.09 22:36:13.525441 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 724 | 2024.10.09 22:36:13.525468 [ 3 ] {} <Debug> HTTP-Session: 57717bdf-de1b-4b3c-bcc8-39d40b2b4bbb Authenticating user 'default' from [::1]:50315 | ||
| 725 | 2024.10.09 22:36:13.525496 [ 3 ] {} <Debug> HTTP-Session: 57717bdf-de1b-4b3c-bcc8-39d40b2b4bbb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 726 | 2024.10.09 22:36:13.525512 [ 3 ] {} <Debug> HTTP-Session: 57717bdf-de1b-4b3c-bcc8-39d40b2b4bbb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 727 | 2024.10.09 22:36:13.525570 [ 3 ] {} <Trace> HTTP-Session: 57717bdf-de1b-4b3c-bcc8-39d40b2b4bbb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 728 | 2024.10.09 22:36:13.526016 [ 3 ] {cd23148f-5878-432a-b5b2-af9cc2f40064} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 729 | 2024.10.09 22:36:13.528936 [ 3 ] {cd23148f-5878-432a-b5b2-af9cc2f40064} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 730 | 2024.10.09 22:36:13.534585 [ 3 ] {cd23148f-5878-432a-b5b2-af9cc2f40064} <Debug> oximeter.fields_ipaddr (eae80b50-f3c4-4e9f-9e8e-56c61f280626): Loading data parts | ||
| 731 | 2024.10.09 22:36:13.539318 [ 3 ] {cd23148f-5878-432a-b5b2-af9cc2f40064} <Debug> oximeter.fields_ipaddr (eae80b50-f3c4-4e9f-9e8e-56c61f280626): There are no data parts | ||
| 732 | 2024.10.09 22:36:13.543348 [ 3 ] {cd23148f-5878-432a-b5b2-af9cc2f40064} <Debug> DynamicQueryHandler: Done processing query | ||
| 733 | 2024.10.09 22:36:13.543390 [ 3 ] {} <Debug> HTTP-Session: 57717bdf-de1b-4b3c-bcc8-39d40b2b4bbb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2024.10.09 22:36:13.545406 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 735 | 2024.10.09 22:36:13.545502 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 736 | 2024.10.09 22:36:13.545533 [ 3 ] {} <Debug> HTTP-Session: af4b6b0a-6df3-4798-9131-94cb7b1555a7 Authenticating user 'default' from [::1]:50315 | ||
| 737 | 2024.10.09 22:36:13.545563 [ 3 ] {} <Debug> HTTP-Session: af4b6b0a-6df3-4798-9131-94cb7b1555a7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 738 | 2024.10.09 22:36:13.545581 [ 3 ] {} <Debug> HTTP-Session: af4b6b0a-6df3-4798-9131-94cb7b1555a7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 739 | 2024.10.09 22:36:13.545639 [ 3 ] {} <Trace> HTTP-Session: af4b6b0a-6df3-4798-9131-94cb7b1555a7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 740 | 2024.10.09 22:36:13.546588 [ 3 ] {edc7f53b-828c-4697-b1fe-cb626391b3e1} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 741 | 2024.10.09 22:36:13.546672 [ 3 ] {edc7f53b-828c-4697-b1fe-cb626391b3e1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 742 | 2024.10.09 22:36:13.555904 [ 3 ] {edc7f53b-828c-4697-b1fe-cb626391b3e1} <Debug> oximeter.fields_string (fc03bf86-392a-45ba-a85a-a9d4c6c3395e): Loading data parts | ||
| 743 | 2024.10.09 22:36:13.566402 [ 3 ] {edc7f53b-828c-4697-b1fe-cb626391b3e1} <Debug> oximeter.fields_string (fc03bf86-392a-45ba-a85a-a9d4c6c3395e): There are no data parts | ||
| 744 | 2024.10.09 22:36:13.571831 [ 3 ] {edc7f53b-828c-4697-b1fe-cb626391b3e1} <Debug> DynamicQueryHandler: Done processing query | ||
| 745 | 2024.10.09 22:36:13.571989 [ 3 ] {} <Debug> HTTP-Session: af4b6b0a-6df3-4798-9131-94cb7b1555a7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 746 | 2024.10.09 22:36:13.581848 [ 134 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 747 | 2024.10.09 22:36:13.581903 [ 134 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 748 | 2024.10.09 22:36:13.583027 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 749 | 2024.10.09 22:36:13.583230 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 750 | 2024.10.09 22:36:13.583262 [ 3 ] {} <Debug> HTTP-Session: b0b45e3e-5c3a-410c-b0b8-adb854485958 Authenticating user 'default' from [::1]:50315 | ||
| 751 | 2024.10.09 22:36:13.583287 [ 3 ] {} <Debug> HTTP-Session: b0b45e3e-5c3a-410c-b0b8-adb854485958 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 752 | 2024.10.09 22:36:13.583301 [ 3 ] {} <Debug> HTTP-Session: b0b45e3e-5c3a-410c-b0b8-adb854485958 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 753 | 2024.10.09 22:36:13.583452 [ 3 ] {} <Trace> HTTP-Session: b0b45e3e-5c3a-410c-b0b8-adb854485958 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 754 | 2024.10.09 22:36:13.584773 [ 3 ] {69d4feca-557e-4c23-82ce-78a7c0e8c02f} <Debug> executeQuery: (from [::1]:50315) 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) | ||
| 755 | 2024.10.09 22:36:13.584855 [ 3 ] {69d4feca-557e-4c23-82ce-78a7c0e8c02f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 756 | 2024.10.09 22:36:13.592191 [ 3 ] {69d4feca-557e-4c23-82ce-78a7c0e8c02f} <Debug> oximeter.fields_uuid (9ecb5992-46eb-4e49-b47b-dde55471cc4e): Loading data parts | ||
| 757 | 2024.10.09 22:36:13.592635 [ 3 ] {69d4feca-557e-4c23-82ce-78a7c0e8c02f} <Debug> oximeter.fields_uuid (9ecb5992-46eb-4e49-b47b-dde55471cc4e): There are no data parts | ||
| 758 | 2024.10.09 22:36:13.594541 [ 3 ] {69d4feca-557e-4c23-82ce-78a7c0e8c02f} <Debug> DynamicQueryHandler: Done processing query | ||
| 759 | 2024.10.09 22:36:13.594575 [ 3 ] {} <Debug> HTTP-Session: b0b45e3e-5c3a-410c-b0b8-adb854485958 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 760 | 2024.10.09 22:36:13.595147 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 761 | 2024.10.09 22:36:13.595225 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 762 | 2024.10.09 22:36:13.595255 [ 3 ] {} <Debug> HTTP-Session: 39f8df3a-aa9c-4a8a-bb67-2ed8bd06ac82 Authenticating user 'default' from [::1]:50315 | ||
| 763 | 2024.10.09 22:36:13.595284 [ 3 ] {} <Debug> HTTP-Session: 39f8df3a-aa9c-4a8a-bb67-2ed8bd06ac82 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 764 | 2024.10.09 22:36:13.595301 [ 3 ] {} <Debug> HTTP-Session: 39f8df3a-aa9c-4a8a-bb67-2ed8bd06ac82 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 765 | 2024.10.09 22:36:13.595358 [ 3 ] {} <Trace> HTTP-Session: 39f8df3a-aa9c-4a8a-bb67-2ed8bd06ac82 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 766 | 2024.10.09 22:36:13.595734 [ 3 ] {64c38bd8-61f5-48fe-abd5-a5db0b2663af} <Debug> executeQuery: (from [::1]:50315) /* The timeseries schema table stores the extracted schema for the samples | ||
| 767 | * oximeter collects. | ||
| 768 | */ | ||
| 769 | 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) | ||
| 770 | 2024.10.09 22:36:13.595831 [ 3 ] {64c38bd8-61f5-48fe-abd5-a5db0b2663af} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 771 | 2024.10.09 22:36:13.598424 [ 3 ] {64c38bd8-61f5-48fe-abd5-a5db0b2663af} <Debug> oximeter.timeseries_schema (8203fe00-0a32-4fe7-8f73-27530deba813): Loading data parts | ||
| 772 | 2024.10.09 22:36:13.599286 [ 3 ] {64c38bd8-61f5-48fe-abd5-a5db0b2663af} <Debug> oximeter.timeseries_schema (8203fe00-0a32-4fe7-8f73-27530deba813): There are no data parts | ||
| 773 | 2024.10.09 22:36:13.601238 [ 3 ] {64c38bd8-61f5-48fe-abd5-a5db0b2663af} <Debug> DynamicQueryHandler: Done processing query | ||
| 774 | 2024.10.09 22:36:13.601267 [ 3 ] {} <Debug> HTTP-Session: 39f8df3a-aa9c-4a8a-bb67-2ed8bd06ac82 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 775 | 2024.10.09 22:36:13.602805 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:50315, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 776 | 2024.10.09 22:36:13.602878 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 777 | 2024.10.09 22:36:13.602900 [ 3 ] {} <Debug> HTTP-Session: 802257a7-46d1-4b8b-80a5-f356ac07c3e9 Authenticating user 'default' from [::1]:50315 | ||
| 778 | 2024.10.09 22:36:13.602923 [ 3 ] {} <Debug> HTTP-Session: 802257a7-46d1-4b8b-80a5-f356ac07c3e9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 779 | 2024.10.09 22:36:13.602937 [ 3 ] {} <Debug> HTTP-Session: 802257a7-46d1-4b8b-80a5-f356ac07c3e9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 780 | 2024.10.09 22:36:13.602978 [ 3 ] {} <Trace> HTTP-Session: 802257a7-46d1-4b8b-80a5-f356ac07c3e9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 781 | 2024.10.09 22:36:13.603187 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Debug> executeQuery: (from [::1]:50315) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 782 | 2024.10.09 22:36:13.603359 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 783 | 2024.10.09 22:36:13.605093 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Trace> oximeter.version (971021cc-3a06-4512-a46b-7dbb92c1d782): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 784 | 2024.10.09 22:36:13.605147 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.30 GiB. | ||
| 785 | 2024.10.09 22:36:13.606017 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 786 | 2024.10.09 22:36:13.606533 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Trace> oximeter.version (971021cc-3a06-4512-a46b-7dbb92c1d782): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 787 | 2024.10.09 22:36:13.606828 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003718 sec., 268.9618074233459 rows/sec., 4.20 KiB/sec. | ||
| 788 | 2024.10.09 22:36:13.607073 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Debug> DynamicQueryHandler: Done processing query | ||
| 789 | 2024.10.09 22:36:13.607102 [ 3 ] {feade320-97bd-452b-b2fa-d36bca51fbac} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 790 | 2024.10.09 22:36:13.607121 [ 3 ] {} <Debug> HTTP-Session: 802257a7-46d1-4b8b-80a5-f356ac07c3e9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||