| 1 | 2024.10.09 22:38:19.538712 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 14423 | ||
| 2 | 2024.10.09 22:38:19.538902 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.10.09 22:38:19.538963 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.10.09 22:38:19.587715 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.10.09 22:38:19.596072 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.10.09 22:38:19.596130 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.10.09 22:38:19.596144 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2024.10.09 22:38:19.601685 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_metrics.14376.1-clickhouse-QTd4B4/datastore/tmp/ to store temporary data in it | ||
| 9 | 2024.10.09 22:38:19.602218 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.10.09 22:38:19.602954 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.10.09 22:38:19.603471 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 2024.10.09 22:38:19.603965 [ 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:38:19.603991 [ 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:38:19.604051 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.10.09 22:38:19.604152 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.10.09 22:38:19.604970 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.10.09 22:38:19.670983 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.10.09 22:38:19.674595 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2024.10.09 22:38:19.680305 [ 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:38:19.680362 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.10.09 22:38:19.681478 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.10.09 22:38:19.682164 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.10.09 22:38:19.685092 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.10.09 22:38:19.685643 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 2024.10.09 22:38:19.697609 [ 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:38:19.700993 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.10.09 22:38:19.721004 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2024.10.09 22:38:19.721820 [ 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:38:19.723483 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2024.10.09 22:38:19.723524 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_metrics.14376.1-clickhouse-QTd4B4/datastore/ | ||
| 31 | 2024.10.09 22:38:19.723584 [ 109 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 32 | 2024.10.09 22:38:19.723642 [ 109 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 33 | 2024.10.09 22:38:19.728583 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 34 | 2024.10.09 22:38:19.728613 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000148793 sec | ||
| 35 | 2024.10.09 22:38:19.728645 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 36 | 2024.10.09 22:38:19.728659 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 37 | 2024.10.09 22:38:19.728786 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 38 | 2024.10.09 22:38:19.728840 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 39 | 2024.10.09 22:38:19.728858 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 40 | 2024.10.09 22:38:19.728884 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 41 | 2024.10.09 22:38:19.728904 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 42 | 2024.10.09 22:38:19.728917 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 43 | 2024.10.09 22:38:19.728942 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 44 | 2024.10.09 22:38:19.728958 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 45 | 2024.10.09 22:38:19.728979 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 46 | 2024.10.09 22:38:19.729007 [ 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:38:19.745008 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 48 | 2024.10.09 22:38:19.745046 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 49 | 2024.10.09 22:38:19.745063 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 50 | 2024.10.09 22:38:19.745097 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2024.10.09 22:38:19.745116 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 2024.10.09 22:38:19.745129 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 53 | 2024.10.09 22:38:19.745155 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 54 | 2024.10.09 22:38:19.745175 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 55 | 2024.10.09 22:38:19.867992 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.10.09 22:38:19.869779 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.10.09 22:38:19.869813 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.7457e-05 sec | ||
| 58 | 2024.10.09 22:38:19.869827 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.10.09 22:38:19.869837 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.10.09 22:38:19.869879 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2024.10.09 22:38:19.870141 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_metrics.14376.1-clickhouse-QTd4B4/datastore/user_defined/ | ||
| 62 | 2024.10.09 22:38:19.870199 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.10.09 22:38:19.870212 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2024.10.09 22:38:19.870222 [ 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:38:19.870235 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.10.09 22:38:19.870503 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 37868 | ||
| 67 | 2024.10.09 22:38:19.870776 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 59111 | ||
| 68 | 2024.10.09 22:38:19.872180 [ 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:38:19.872290 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 48679 | ||
| 70 | 2024.10.09 22:38:19.872347 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 60682 | ||
| 71 | 2024.10.09 22:38:19.872413 [ 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:38:19.872448 [ 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:38:19.872676 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 15.77 MiB, free memory in arenas 0.00 B, will set to 139.55 MiB (RSS), difference: 129.65 MiB | ||
| 74 | 2024.10.09 22:38:19.873300 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.5138e-05 sec. | ||
| 75 | 2024.10.09 22:38:19.873829 [ 1 ] {} <Information> Application: Listening for http://[::1]:37868 | ||
| 76 | 2024.10.09 22:38:19.873907 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:59111 | ||
| 77 | 2024.10.09 22:38:19.874057 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:48679 | ||
| 78 | 2024.10.09 22:38:19.874170 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:60682 | ||
| 79 | 2024.10.09 22:38:19.874232 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 80 | 2024.10.09 22:38:33.689518 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 81 | 2024.10.09 22:38:33.689746 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 82 | 2024.10.09 22:38:33.689789 [ 3 ] {} <Debug> HTTP-Session: a6217ee3-ba3b-4673-9540-3d67d7a24435 Authenticating user 'default' from [::1]:45919 | ||
| 83 | 2024.10.09 22:38:33.689831 [ 3 ] {} <Debug> HTTP-Session: a6217ee3-ba3b-4673-9540-3d67d7a24435 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 84 | 2024.10.09 22:38:33.689847 [ 3 ] {} <Debug> HTTP-Session: a6217ee3-ba3b-4673-9540-3d67d7a24435 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 85 | 2024.10.09 22:38:33.689943 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 86 | 2024.10.09 22:38:33.689989 [ 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:38:33.690014 [ 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:38:33.690064 [ 3 ] {} <Trace> HTTP-Session: a6217ee3-ba3b-4673-9540-3d67d7a24435 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 89 | 2024.10.09 22:38:33.690586 [ 3 ] {ae5445b9-ecc4-4730-8573-fc1d45f26c2c} <Debug> executeQuery: (from [::1]:45919) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 90 | 2024.10.09 22:38:33.699614 [ 3 ] {ae5445b9-ecc4-4730-8573-fc1d45f26c2c} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:45919) (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:38:33.699868 [ 3 ] {ae5445b9-ecc4-4730-8573-fc1d45f26c2c} <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:38:33.700196 [ 3 ] {} <Debug> HTTP-Session: a6217ee3-ba3b-4673-9540-3d67d7a24435 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 141 | 2024.10.09 22:38:33.725437 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 142 | 2024.10.09 22:38:33.725564 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 143 | 2024.10.09 22:38:33.725619 [ 3 ] {} <Debug> HTTP-Session: 61c69748-7ba5-4c61-b645-af9af2266035 Authenticating user 'default' from [::1]:45919 | ||
| 144 | 2024.10.09 22:38:33.725664 [ 3 ] {} <Debug> HTTP-Session: 61c69748-7ba5-4c61-b645-af9af2266035 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 145 | 2024.10.09 22:38:33.725682 [ 3 ] {} <Debug> HTTP-Session: 61c69748-7ba5-4c61-b645-af9af2266035 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 146 | 2024.10.09 22:38:33.725753 [ 3 ] {} <Trace> HTTP-Session: 61c69748-7ba5-4c61-b645-af9af2266035 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 147 | 2024.10.09 22:38:33.726070 [ 3 ] {6d5fd6dd-df8d-4f93-b50f-99c02c2fda9d} <Debug> executeQuery: (from [::1]:45919) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 148 | 2024.10.09 22:38:33.726490 [ 3 ] {6d5fd6dd-df8d-4f93-b50f-99c02c2fda9d} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:45919) (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:38:33.726681 [ 3 ] {6d5fd6dd-df8d-4f93-b50f-99c02c2fda9d} <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:38:33.726902 [ 3 ] {} <Debug> HTTP-Session: 61c69748-7ba5-4c61-b645-af9af2266035 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 199 | 2024.10.09 22:38:33.729976 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 200 | 2024.10.09 22:38:33.730081 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 201 | 2024.10.09 22:38:33.730107 [ 3 ] {} <Debug> HTTP-Session: 9323b4bf-f29c-4fe9-8354-3a07d8de0d33 Authenticating user 'default' from [::1]:45919 | ||
| 202 | 2024.10.09 22:38:33.730137 [ 3 ] {} <Debug> HTTP-Session: 9323b4bf-f29c-4fe9-8354-3a07d8de0d33 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 203 | 2024.10.09 22:38:33.730153 [ 3 ] {} <Debug> HTTP-Session: 9323b4bf-f29c-4fe9-8354-3a07d8de0d33 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 204 | 2024.10.09 22:38:33.730196 [ 3 ] {} <Trace> HTTP-Session: 9323b4bf-f29c-4fe9-8354-3a07d8de0d33 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 205 | 2024.10.09 22:38:33.730421 [ 3 ] {44e1d114-ca4a-4206-a52e-46b1f5238497} <Debug> executeQuery: (from [::1]:45919) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 206 | 2024.10.09 22:38:33.730646 [ 3 ] {44e1d114-ca4a-4206-a52e-46b1f5238497} <Debug> DynamicQueryHandler: Done processing query | ||
| 207 | 2024.10.09 22:38:33.730671 [ 3 ] {} <Debug> HTTP-Session: 9323b4bf-f29c-4fe9-8354-3a07d8de0d33 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 208 | 2024.10.09 22:38:33.731917 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 209 | 2024.10.09 22:38:33.731984 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 210 | 2024.10.09 22:38:33.732036 [ 3 ] {} <Debug> HTTP-Session: 5838e28c-fe60-457b-88a7-c8c4b0fefaf8 Authenticating user 'default' from [::1]:45919 | ||
| 211 | 2024.10.09 22:38:33.732065 [ 3 ] {} <Debug> HTTP-Session: 5838e28c-fe60-457b-88a7-c8c4b0fefaf8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 212 | 2024.10.09 22:38:33.732082 [ 3 ] {} <Debug> HTTP-Session: 5838e28c-fe60-457b-88a7-c8c4b0fefaf8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 213 | 2024.10.09 22:38:33.732121 [ 3 ] {} <Trace> HTTP-Session: 5838e28c-fe60-457b-88a7-c8c4b0fefaf8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 214 | 2024.10.09 22:38:33.732272 [ 3 ] {84dc38f6-5aa1-43e4-903e-a7c20c057705} <Debug> executeQuery: (from [::1]:45919) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 215 | 2024.10.09 22:38:33.732351 [ 3 ] {84dc38f6-5aa1-43e4-903e-a7c20c057705} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 216 | 2024.10.09 22:38:33.733881 [ 3 ] {84dc38f6-5aa1-43e4-903e-a7c20c057705} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 217 | 2024.10.09 22:38:33.733916 [ 3 ] {84dc38f6-5aa1-43e4-903e-a7c20c057705} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.3266e-05 sec | ||
| 218 | 2024.10.09 22:38:33.733930 [ 3 ] {84dc38f6-5aa1-43e4-903e-a7c20c057705} <Trace> ReferentialDeps: No tables | ||
| 219 | 2024.10.09 22:38:33.733942 [ 3 ] {84dc38f6-5aa1-43e4-903e-a7c20c057705} <Trace> LoadingDeps: No tables | ||
| 220 | 2024.10.09 22:38:33.733966 [ 3 ] {84dc38f6-5aa1-43e4-903e-a7c20c057705} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 221 | 2024.10.09 22:38:33.734146 [ 3 ] {84dc38f6-5aa1-43e4-903e-a7c20c057705} <Debug> DynamicQueryHandler: Done processing query | ||
| 222 | 2024.10.09 22:38:33.734170 [ 3 ] {} <Debug> HTTP-Session: 5838e28c-fe60-457b-88a7-c8c4b0fefaf8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 223 | 2024.10.09 22:38:33.736392 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 224 | 2024.10.09 22:38:33.736472 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 225 | 2024.10.09 22:38:33.736494 [ 3 ] {} <Debug> HTTP-Session: ddffeaac-e233-4d61-a8cd-746808bfc63b Authenticating user 'default' from [::1]:45919 | ||
| 226 | 2024.10.09 22:38:33.736513 [ 3 ] {} <Debug> HTTP-Session: ddffeaac-e233-4d61-a8cd-746808bfc63b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 227 | 2024.10.09 22:38:33.736537 [ 3 ] {} <Debug> HTTP-Session: ddffeaac-e233-4d61-a8cd-746808bfc63b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 228 | 2024.10.09 22:38:33.736581 [ 3 ] {} <Trace> HTTP-Session: ddffeaac-e233-4d61-a8cd-746808bfc63b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 229 | 2024.10.09 22:38:33.736816 [ 3 ] {08c0b18d-74ba-409e-a24c-196ce37edf95} <Debug> executeQuery: (from [::1]:45919) /* 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:38:33.736897 [ 3 ] {08c0b18d-74ba-409e-a24c-196ce37edf95} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 232 | 2024.10.09 22:38:33.738620 [ 3 ] {08c0b18d-74ba-409e-a24c-196ce37edf95} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 233 | 2024.10.09 22:38:33.739924 [ 3 ] {08c0b18d-74ba-409e-a24c-196ce37edf95} <Debug> oximeter.version (509396b0-67e1-4b9b-b537-d350e20ed6c5): Loading data parts | ||
| 234 | 2024.10.09 22:38:33.740498 [ 3 ] {08c0b18d-74ba-409e-a24c-196ce37edf95} <Debug> oximeter.version (509396b0-67e1-4b9b-b537-d350e20ed6c5): There are no data parts | ||
| 235 | 2024.10.09 22:38:33.742271 [ 3 ] {08c0b18d-74ba-409e-a24c-196ce37edf95} <Debug> DynamicQueryHandler: Done processing query | ||
| 236 | 2024.10.09 22:38:33.742299 [ 3 ] {} <Debug> HTTP-Session: ddffeaac-e233-4d61-a8cd-746808bfc63b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 237 | 2024.10.09 22:38:33.744618 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 238 | 2024.10.09 22:38:33.744701 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 239 | 2024.10.09 22:38:33.744739 [ 3 ] {} <Debug> HTTP-Session: 52bb221f-fbe5-4e12-9f0c-fe75a08f2bd9 Authenticating user 'default' from [::1]:45919 | ||
| 240 | 2024.10.09 22:38:33.744766 [ 3 ] {} <Debug> HTTP-Session: 52bb221f-fbe5-4e12-9f0c-fe75a08f2bd9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 241 | 2024.10.09 22:38:33.744783 [ 3 ] {} <Debug> HTTP-Session: 52bb221f-fbe5-4e12-9f0c-fe75a08f2bd9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 242 | 2024.10.09 22:38:33.744836 [ 3 ] {} <Trace> HTTP-Session: 52bb221f-fbe5-4e12-9f0c-fe75a08f2bd9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 243 | 2024.10.09 22:38:33.745205 [ 3 ] {acb530f0-5500-4308-a164-29c3fd327680} <Debug> executeQuery: (from [::1]:45919) /* 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:38:33.745289 [ 3 ] {acb530f0-5500-4308-a164-29c3fd327680} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 255 | 2024.10.09 22:38:33.747863 [ 3 ] {acb530f0-5500-4308-a164-29c3fd327680} <Debug> oximeter.measurements_bool (7051e6f9-035a-48ca-8e46-aea56e87101b): Loading data parts | ||
| 256 | 2024.10.09 22:38:33.748202 [ 3 ] {acb530f0-5500-4308-a164-29c3fd327680} <Debug> oximeter.measurements_bool (7051e6f9-035a-48ca-8e46-aea56e87101b): There are no data parts | ||
| 257 | 2024.10.09 22:38:33.750071 [ 3 ] {acb530f0-5500-4308-a164-29c3fd327680} <Debug> DynamicQueryHandler: Done processing query | ||
| 258 | 2024.10.09 22:38:33.750101 [ 3 ] {} <Debug> HTTP-Session: 52bb221f-fbe5-4e12-9f0c-fe75a08f2bd9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 259 | 2024.10.09 22:38:33.754190 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 260 | 2024.10.09 22:38:33.754326 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 261 | 2024.10.09 22:38:33.754381 [ 3 ] {} <Debug> HTTP-Session: e2633c24-d699-4656-8ef3-87e3ae71131c Authenticating user 'default' from [::1]:45919 | ||
| 262 | 2024.10.09 22:38:33.754413 [ 3 ] {} <Debug> HTTP-Session: e2633c24-d699-4656-8ef3-87e3ae71131c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 263 | 2024.10.09 22:38:33.754434 [ 3 ] {} <Debug> HTTP-Session: e2633c24-d699-4656-8ef3-87e3ae71131c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 264 | 2024.10.09 22:38:33.754493 [ 3 ] {} <Trace> HTTP-Session: e2633c24-d699-4656-8ef3-87e3ae71131c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 265 | 2024.10.09 22:38:33.754881 [ 3 ] {875450ff-3cda-4b87-af94-8ede3be78858} <Debug> executeQuery: (from [::1]:45919) 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:38:33.754963 [ 3 ] {875450ff-3cda-4b87-af94-8ede3be78858} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 267 | 2024.10.09 22:38:33.757467 [ 3 ] {875450ff-3cda-4b87-af94-8ede3be78858} <Debug> oximeter.measurements_i8 (f6df0947-44b3-4250-9f11-d4b8b7e73b02): Loading data parts | ||
| 268 | 2024.10.09 22:38:33.757780 [ 3 ] {875450ff-3cda-4b87-af94-8ede3be78858} <Debug> oximeter.measurements_i8 (f6df0947-44b3-4250-9f11-d4b8b7e73b02): There are no data parts | ||
| 269 | 2024.10.09 22:38:33.759738 [ 3 ] {875450ff-3cda-4b87-af94-8ede3be78858} <Debug> DynamicQueryHandler: Done processing query | ||
| 270 | 2024.10.09 22:38:33.759777 [ 3 ] {} <Debug> HTTP-Session: e2633c24-d699-4656-8ef3-87e3ae71131c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2024.10.09 22:38:33.760375 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 272 | 2024.10.09 22:38:33.760456 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 273 | 2024.10.09 22:38:33.760478 [ 3 ] {} <Debug> HTTP-Session: 6449539e-cfb0-4130-b287-aac38993e35b Authenticating user 'default' from [::1]:45919 | ||
| 274 | 2024.10.09 22:38:33.760516 [ 3 ] {} <Debug> HTTP-Session: 6449539e-cfb0-4130-b287-aac38993e35b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2024.10.09 22:38:33.760532 [ 3 ] {} <Debug> HTTP-Session: 6449539e-cfb0-4130-b287-aac38993e35b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 276 | 2024.10.09 22:38:33.760582 [ 3 ] {} <Trace> HTTP-Session: 6449539e-cfb0-4130-b287-aac38993e35b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 277 | 2024.10.09 22:38:33.760912 [ 3 ] {5139f5f5-5605-4682-89f1-7215e5f482cf} <Debug> executeQuery: (from [::1]:45919) 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:38:33.760992 [ 3 ] {5139f5f5-5605-4682-89f1-7215e5f482cf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 279 | 2024.10.09 22:38:33.763371 [ 3 ] {5139f5f5-5605-4682-89f1-7215e5f482cf} <Debug> oximeter.measurements_u8 (79454bc0-7c13-4fdd-9a08-7bb1ae11cc52): Loading data parts | ||
| 280 | 2024.10.09 22:38:33.763785 [ 3 ] {5139f5f5-5605-4682-89f1-7215e5f482cf} <Debug> oximeter.measurements_u8 (79454bc0-7c13-4fdd-9a08-7bb1ae11cc52): There are no data parts | ||
| 281 | 2024.10.09 22:38:33.765877 [ 3 ] {5139f5f5-5605-4682-89f1-7215e5f482cf} <Debug> DynamicQueryHandler: Done processing query | ||
| 282 | 2024.10.09 22:38:33.765910 [ 3 ] {} <Debug> HTTP-Session: 6449539e-cfb0-4130-b287-aac38993e35b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.10.09 22:38:33.767892 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 284 | 2024.10.09 22:38:33.768046 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 285 | 2024.10.09 22:38:33.768079 [ 3 ] {} <Debug> HTTP-Session: a1c3dbf7-bf18-4466-8263-4689698cca91 Authenticating user 'default' from [::1]:45919 | ||
| 286 | 2024.10.09 22:38:33.768169 [ 3 ] {} <Debug> HTTP-Session: a1c3dbf7-bf18-4466-8263-4689698cca91 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 287 | 2024.10.09 22:38:33.768195 [ 3 ] {} <Debug> HTTP-Session: a1c3dbf7-bf18-4466-8263-4689698cca91 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2024.10.09 22:38:33.768256 [ 3 ] {} <Trace> HTTP-Session: a1c3dbf7-bf18-4466-8263-4689698cca91 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 289 | 2024.10.09 22:38:33.768596 [ 3 ] {a46f464c-e5f7-4094-b7f6-67859b07900b} <Debug> executeQuery: (from [::1]:45919) 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:38:33.768817 [ 3 ] {a46f464c-e5f7-4094-b7f6-67859b07900b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 291 | 2024.10.09 22:38:33.773752 [ 3 ] {a46f464c-e5f7-4094-b7f6-67859b07900b} <Debug> oximeter.measurements_i16 (cb1a58e4-8109-4b20-a12a-b7ece082af4b): Loading data parts | ||
| 292 | 2024.10.09 22:38:33.774086 [ 3 ] {a46f464c-e5f7-4094-b7f6-67859b07900b} <Debug> oximeter.measurements_i16 (cb1a58e4-8109-4b20-a12a-b7ece082af4b): There are no data parts | ||
| 293 | 2024.10.09 22:38:33.776146 [ 3 ] {a46f464c-e5f7-4094-b7f6-67859b07900b} <Debug> DynamicQueryHandler: Done processing query | ||
| 294 | 2024.10.09 22:38:33.776183 [ 3 ] {} <Debug> HTTP-Session: a1c3dbf7-bf18-4466-8263-4689698cca91 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.10.09 22:38:33.788775 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 296 | 2024.10.09 22:38:33.788972 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 297 | 2024.10.09 22:38:33.789023 [ 3 ] {} <Debug> HTTP-Session: bdfced4a-8d4b-4085-a431-e6e037ccd8ac Authenticating user 'default' from [::1]:45919 | ||
| 298 | 2024.10.09 22:38:33.789058 [ 3 ] {} <Debug> HTTP-Session: bdfced4a-8d4b-4085-a431-e6e037ccd8ac Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 299 | 2024.10.09 22:38:33.789073 [ 3 ] {} <Debug> HTTP-Session: bdfced4a-8d4b-4085-a431-e6e037ccd8ac Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 300 | 2024.10.09 22:38:33.789130 [ 3 ] {} <Trace> HTTP-Session: bdfced4a-8d4b-4085-a431-e6e037ccd8ac Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 301 | 2024.10.09 22:38:33.789557 [ 3 ] {9fc0d2d9-ebbb-4bef-a14d-3eb21be6e73e} <Debug> executeQuery: (from [::1]:45919) 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:38:33.789633 [ 3 ] {9fc0d2d9-ebbb-4bef-a14d-3eb21be6e73e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 303 | 2024.10.09 22:38:33.792352 [ 3 ] {9fc0d2d9-ebbb-4bef-a14d-3eb21be6e73e} <Debug> oximeter.measurements_u16 (f1d2da43-7fbd-4a6d-b840-138a98a380ea): Loading data parts | ||
| 304 | 2024.10.09 22:38:33.792659 [ 3 ] {9fc0d2d9-ebbb-4bef-a14d-3eb21be6e73e} <Debug> oximeter.measurements_u16 (f1d2da43-7fbd-4a6d-b840-138a98a380ea): There are no data parts | ||
| 305 | 2024.10.09 22:38:33.794874 [ 3 ] {9fc0d2d9-ebbb-4bef-a14d-3eb21be6e73e} <Debug> DynamicQueryHandler: Done processing query | ||
| 306 | 2024.10.09 22:38:33.794915 [ 3 ] {} <Debug> HTTP-Session: bdfced4a-8d4b-4085-a431-e6e037ccd8ac Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.10.09 22:38:33.797295 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 308 | 2024.10.09 22:38:33.797373 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 309 | 2024.10.09 22:38:33.797411 [ 3 ] {} <Debug> HTTP-Session: c35f24ee-d029-4d60-ad1f-70dfb030fcad Authenticating user 'default' from [::1]:45919 | ||
| 310 | 2024.10.09 22:38:33.797436 [ 3 ] {} <Debug> HTTP-Session: c35f24ee-d029-4d60-ad1f-70dfb030fcad Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2024.10.09 22:38:33.797488 [ 3 ] {} <Debug> HTTP-Session: c35f24ee-d029-4d60-ad1f-70dfb030fcad Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 312 | 2024.10.09 22:38:33.797557 [ 3 ] {} <Trace> HTTP-Session: c35f24ee-d029-4d60-ad1f-70dfb030fcad Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 313 | 2024.10.09 22:38:33.798023 [ 3 ] {a3b919d9-b4af-4524-97a8-586dad81ea5d} <Debug> executeQuery: (from [::1]:45919) 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:38:33.798100 [ 3 ] {a3b919d9-b4af-4524-97a8-586dad81ea5d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 315 | 2024.10.09 22:38:33.800513 [ 3 ] {a3b919d9-b4af-4524-97a8-586dad81ea5d} <Debug> oximeter.measurements_i32 (28c9ee13-e958-4c3d-a86d-0176d00f3f88): Loading data parts | ||
| 316 | 2024.10.09 22:38:33.800826 [ 3 ] {a3b919d9-b4af-4524-97a8-586dad81ea5d} <Debug> oximeter.measurements_i32 (28c9ee13-e958-4c3d-a86d-0176d00f3f88): There are no data parts | ||
| 317 | 2024.10.09 22:38:33.802619 [ 3 ] {a3b919d9-b4af-4524-97a8-586dad81ea5d} <Debug> DynamicQueryHandler: Done processing query | ||
| 318 | 2024.10.09 22:38:33.802646 [ 3 ] {} <Debug> HTTP-Session: c35f24ee-d029-4d60-ad1f-70dfb030fcad Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.10.09 22:38:33.806456 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 320 | 2024.10.09 22:38:33.806549 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 321 | 2024.10.09 22:38:33.806574 [ 3 ] {} <Debug> HTTP-Session: 5c20e8dc-3ea3-4113-abb2-bbf5fc5b7488 Authenticating user 'default' from [::1]:45919 | ||
| 322 | 2024.10.09 22:38:33.806596 [ 3 ] {} <Debug> HTTP-Session: 5c20e8dc-3ea3-4113-abb2-bbf5fc5b7488 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 323 | 2024.10.09 22:38:33.806622 [ 3 ] {} <Debug> HTTP-Session: 5c20e8dc-3ea3-4113-abb2-bbf5fc5b7488 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 324 | 2024.10.09 22:38:33.806668 [ 3 ] {} <Trace> HTTP-Session: 5c20e8dc-3ea3-4113-abb2-bbf5fc5b7488 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 325 | 2024.10.09 22:38:33.807143 [ 3 ] {9d7c7daa-60ba-4fff-bae6-169fcf54dc95} <Debug> executeQuery: (from [::1]:45919) 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:38:33.807219 [ 3 ] {9d7c7daa-60ba-4fff-bae6-169fcf54dc95} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 327 | 2024.10.09 22:38:33.809941 [ 3 ] {9d7c7daa-60ba-4fff-bae6-169fcf54dc95} <Debug> oximeter.measurements_u32 (f805c928-2f78-4da3-a10f-c8e358ebf251): Loading data parts | ||
| 328 | 2024.10.09 22:38:33.810274 [ 3 ] {9d7c7daa-60ba-4fff-bae6-169fcf54dc95} <Debug> oximeter.measurements_u32 (f805c928-2f78-4da3-a10f-c8e358ebf251): There are no data parts | ||
| 329 | 2024.10.09 22:38:33.812183 [ 3 ] {9d7c7daa-60ba-4fff-bae6-169fcf54dc95} <Debug> DynamicQueryHandler: Done processing query | ||
| 330 | 2024.10.09 22:38:33.812209 [ 3 ] {} <Debug> HTTP-Session: 5c20e8dc-3ea3-4113-abb2-bbf5fc5b7488 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 331 | 2024.10.09 22:38:33.816859 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 332 | 2024.10.09 22:38:33.816945 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 333 | 2024.10.09 22:38:33.816980 [ 3 ] {} <Debug> HTTP-Session: 264b475a-4cf3-4d3d-950c-54ea90c7e7ef Authenticating user 'default' from [::1]:45919 | ||
| 334 | 2024.10.09 22:38:33.817032 [ 3 ] {} <Debug> HTTP-Session: 264b475a-4cf3-4d3d-950c-54ea90c7e7ef Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 335 | 2024.10.09 22:38:33.817047 [ 3 ] {} <Debug> HTTP-Session: 264b475a-4cf3-4d3d-950c-54ea90c7e7ef Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 336 | 2024.10.09 22:38:33.817191 [ 3 ] {} <Trace> HTTP-Session: 264b475a-4cf3-4d3d-950c-54ea90c7e7ef Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 337 | 2024.10.09 22:38:33.817598 [ 3 ] {18fb5ccb-cc5b-41df-9036-97f3aa8f54e9} <Debug> executeQuery: (from [::1]:45919) 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:38:33.817698 [ 3 ] {18fb5ccb-cc5b-41df-9036-97f3aa8f54e9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 339 | 2024.10.09 22:38:33.820335 [ 3 ] {18fb5ccb-cc5b-41df-9036-97f3aa8f54e9} <Debug> oximeter.measurements_i64 (73f0ef12-c65e-4b55-8579-c10770e17891): Loading data parts | ||
| 340 | 2024.10.09 22:38:33.820880 [ 3 ] {18fb5ccb-cc5b-41df-9036-97f3aa8f54e9} <Debug> oximeter.measurements_i64 (73f0ef12-c65e-4b55-8579-c10770e17891): There are no data parts | ||
| 341 | 2024.10.09 22:38:33.824173 [ 3 ] {18fb5ccb-cc5b-41df-9036-97f3aa8f54e9} <Debug> DynamicQueryHandler: Done processing query | ||
| 342 | 2024.10.09 22:38:33.824206 [ 3 ] {} <Debug> HTTP-Session: 264b475a-4cf3-4d3d-950c-54ea90c7e7ef Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2024.10.09 22:38:33.825031 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 344 | 2024.10.09 22:38:33.825116 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 345 | 2024.10.09 22:38:33.825144 [ 3 ] {} <Debug> HTTP-Session: 6f000b27-ad1c-49db-8458-c683205806c2 Authenticating user 'default' from [::1]:45919 | ||
| 346 | 2024.10.09 22:38:33.825168 [ 3 ] {} <Debug> HTTP-Session: 6f000b27-ad1c-49db-8458-c683205806c2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 347 | 2024.10.09 22:38:33.825225 [ 3 ] {} <Debug> HTTP-Session: 6f000b27-ad1c-49db-8458-c683205806c2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 348 | 2024.10.09 22:38:33.825298 [ 3 ] {} <Trace> HTTP-Session: 6f000b27-ad1c-49db-8458-c683205806c2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 349 | 2024.10.09 22:38:33.825600 [ 3 ] {2249b0bf-7733-44b6-90ce-ea2d8fd0c31a} <Debug> executeQuery: (from [::1]:45919) 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:38:33.825690 [ 3 ] {2249b0bf-7733-44b6-90ce-ea2d8fd0c31a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 351 | 2024.10.09 22:38:33.828282 [ 3 ] {2249b0bf-7733-44b6-90ce-ea2d8fd0c31a} <Debug> oximeter.measurements_u64 (d130a2b3-0050-48bd-aaf6-968c4a0ec123): Loading data parts | ||
| 352 | 2024.10.09 22:38:33.828697 [ 3 ] {2249b0bf-7733-44b6-90ce-ea2d8fd0c31a} <Debug> oximeter.measurements_u64 (d130a2b3-0050-48bd-aaf6-968c4a0ec123): There are no data parts | ||
| 353 | 2024.10.09 22:38:33.830630 [ 3 ] {2249b0bf-7733-44b6-90ce-ea2d8fd0c31a} <Debug> DynamicQueryHandler: Done processing query | ||
| 354 | 2024.10.09 22:38:33.830657 [ 3 ] {} <Debug> HTTP-Session: 6f000b27-ad1c-49db-8458-c683205806c2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 355 | 2024.10.09 22:38:33.832621 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 356 | 2024.10.09 22:38:33.832694 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 357 | 2024.10.09 22:38:33.832719 [ 3 ] {} <Debug> HTTP-Session: 688aa15c-2157-45dd-9bd7-5c5fb85bae91 Authenticating user 'default' from [::1]:45919 | ||
| 358 | 2024.10.09 22:38:33.832764 [ 3 ] {} <Debug> HTTP-Session: 688aa15c-2157-45dd-9bd7-5c5fb85bae91 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 359 | 2024.10.09 22:38:33.832782 [ 3 ] {} <Debug> HTTP-Session: 688aa15c-2157-45dd-9bd7-5c5fb85bae91 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 360 | 2024.10.09 22:38:33.832850 [ 3 ] {} <Trace> HTTP-Session: 688aa15c-2157-45dd-9bd7-5c5fb85bae91 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 361 | 2024.10.09 22:38:33.833180 [ 3 ] {265ec56e-226c-412e-9ac1-01a7780d2716} <Debug> executeQuery: (from [::1]:45919) 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:38:33.833265 [ 3 ] {265ec56e-226c-412e-9ac1-01a7780d2716} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 363 | 2024.10.09 22:38:33.841733 [ 3 ] {265ec56e-226c-412e-9ac1-01a7780d2716} <Debug> oximeter.measurements_f32 (40c460c6-00a1-4e86-9259-81f3d17d415d): Loading data parts | ||
| 364 | 2024.10.09 22:38:33.842130 [ 3 ] {265ec56e-226c-412e-9ac1-01a7780d2716} <Debug> oximeter.measurements_f32 (40c460c6-00a1-4e86-9259-81f3d17d415d): There are no data parts | ||
| 365 | 2024.10.09 22:38:33.844177 [ 3 ] {265ec56e-226c-412e-9ac1-01a7780d2716} <Debug> DynamicQueryHandler: Done processing query | ||
| 366 | 2024.10.09 22:38:33.844221 [ 3 ] {} <Debug> HTTP-Session: 688aa15c-2157-45dd-9bd7-5c5fb85bae91 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 367 | 2024.10.09 22:38:33.844982 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 368 | 2024.10.09 22:38:33.845098 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 369 | 2024.10.09 22:38:33.845133 [ 3 ] {} <Debug> HTTP-Session: ff5b751e-dc15-4bf7-9adf-1061897d45b0 Authenticating user 'default' from [::1]:45919 | ||
| 370 | 2024.10.09 22:38:33.845160 [ 3 ] {} <Debug> HTTP-Session: ff5b751e-dc15-4bf7-9adf-1061897d45b0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 371 | 2024.10.09 22:38:33.845181 [ 3 ] {} <Debug> HTTP-Session: ff5b751e-dc15-4bf7-9adf-1061897d45b0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 372 | 2024.10.09 22:38:33.845249 [ 3 ] {} <Trace> HTTP-Session: ff5b751e-dc15-4bf7-9adf-1061897d45b0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 373 | 2024.10.09 22:38:33.845696 [ 3 ] {5ee4ae74-1c45-40df-9499-ac986eb317b4} <Debug> executeQuery: (from [::1]:45919) 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:38:33.845784 [ 3 ] {5ee4ae74-1c45-40df-9499-ac986eb317b4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 375 | 2024.10.09 22:38:33.848448 [ 3 ] {5ee4ae74-1c45-40df-9499-ac986eb317b4} <Debug> oximeter.measurements_f64 (1360f064-21ce-46e2-8fdc-79b9310f7b33): Loading data parts | ||
| 376 | 2024.10.09 22:38:33.848771 [ 3 ] {5ee4ae74-1c45-40df-9499-ac986eb317b4} <Debug> oximeter.measurements_f64 (1360f064-21ce-46e2-8fdc-79b9310f7b33): There are no data parts | ||
| 377 | 2024.10.09 22:38:33.850573 [ 3 ] {5ee4ae74-1c45-40df-9499-ac986eb317b4} <Debug> DynamicQueryHandler: Done processing query | ||
| 378 | 2024.10.09 22:38:33.850604 [ 3 ] {} <Debug> HTTP-Session: ff5b751e-dc15-4bf7-9adf-1061897d45b0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 379 | 2024.10.09 22:38:33.851607 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 380 | 2024.10.09 22:38:33.851692 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 381 | 2024.10.09 22:38:33.851714 [ 3 ] {} <Debug> HTTP-Session: d3598e67-9339-4a56-9c8d-590a1024b74c Authenticating user 'default' from [::1]:45919 | ||
| 382 | 2024.10.09 22:38:33.851736 [ 3 ] {} <Debug> HTTP-Session: d3598e67-9339-4a56-9c8d-590a1024b74c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 383 | 2024.10.09 22:38:33.851753 [ 3 ] {} <Debug> HTTP-Session: d3598e67-9339-4a56-9c8d-590a1024b74c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 384 | 2024.10.09 22:38:33.851798 [ 3 ] {} <Trace> HTTP-Session: d3598e67-9339-4a56-9c8d-590a1024b74c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 385 | 2024.10.09 22:38:33.852089 [ 3 ] {1b26b7c6-e62d-40d5-820a-543987d4537d} <Debug> executeQuery: (from [::1]:45919) 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:38:33.852153 [ 3 ] {1b26b7c6-e62d-40d5-820a-543987d4537d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 387 | 2024.10.09 22:38:33.854929 [ 3 ] {1b26b7c6-e62d-40d5-820a-543987d4537d} <Debug> oximeter.measurements_string (9a612e11-202e-47e9-8d02-3c7977b1c2ab): Loading data parts | ||
| 388 | 2024.10.09 22:38:33.855259 [ 3 ] {1b26b7c6-e62d-40d5-820a-543987d4537d} <Debug> oximeter.measurements_string (9a612e11-202e-47e9-8d02-3c7977b1c2ab): There are no data parts | ||
| 389 | 2024.10.09 22:38:33.856968 [ 3 ] {1b26b7c6-e62d-40d5-820a-543987d4537d} <Debug> DynamicQueryHandler: Done processing query | ||
| 390 | 2024.10.09 22:38:33.857034 [ 3 ] {} <Debug> HTTP-Session: d3598e67-9339-4a56-9c8d-590a1024b74c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 391 | 2024.10.09 22:38:33.858105 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 392 | 2024.10.09 22:38:33.858175 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 393 | 2024.10.09 22:38:33.858209 [ 3 ] {} <Debug> HTTP-Session: 950bcc2e-3a29-469d-9385-55c90a2c86b9 Authenticating user 'default' from [::1]:45919 | ||
| 394 | 2024.10.09 22:38:33.858233 [ 3 ] {} <Debug> HTTP-Session: 950bcc2e-3a29-469d-9385-55c90a2c86b9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 395 | 2024.10.09 22:38:33.858247 [ 3 ] {} <Debug> HTTP-Session: 950bcc2e-3a29-469d-9385-55c90a2c86b9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 396 | 2024.10.09 22:38:33.858300 [ 3 ] {} <Trace> HTTP-Session: 950bcc2e-3a29-469d-9385-55c90a2c86b9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 397 | 2024.10.09 22:38:33.858623 [ 3 ] {ca5fbfa3-3f26-469c-999f-3b65a578abaa} <Debug> executeQuery: (from [::1]:45919) 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:38:33.858698 [ 3 ] {ca5fbfa3-3f26-469c-999f-3b65a578abaa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 406 | 2024.10.09 22:38:33.861256 [ 3 ] {ca5fbfa3-3f26-469c-999f-3b65a578abaa} <Debug> oximeter.measurements_bytes (1ba306b8-46e3-4592-9e25-8987a7e8d7d2): Loading data parts | ||
| 407 | 2024.10.09 22:38:33.861511 [ 3 ] {ca5fbfa3-3f26-469c-999f-3b65a578abaa} <Debug> oximeter.measurements_bytes (1ba306b8-46e3-4592-9e25-8987a7e8d7d2): There are no data parts | ||
| 408 | 2024.10.09 22:38:33.863287 [ 3 ] {ca5fbfa3-3f26-469c-999f-3b65a578abaa} <Debug> DynamicQueryHandler: Done processing query | ||
| 409 | 2024.10.09 22:38:33.863334 [ 3 ] {} <Debug> HTTP-Session: 950bcc2e-3a29-469d-9385-55c90a2c86b9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 410 | 2024.10.09 22:38:33.864155 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 411 | 2024.10.09 22:38:33.864228 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 412 | 2024.10.09 22:38:33.864263 [ 3 ] {} <Debug> HTTP-Session: 8ee5eefd-e4f7-4a8c-9b80-ea06f9008884 Authenticating user 'default' from [::1]:45919 | ||
| 413 | 2024.10.09 22:38:33.864287 [ 3 ] {} <Debug> HTTP-Session: 8ee5eefd-e4f7-4a8c-9b80-ea06f9008884 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 414 | 2024.10.09 22:38:33.864300 [ 3 ] {} <Debug> HTTP-Session: 8ee5eefd-e4f7-4a8c-9b80-ea06f9008884 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 415 | 2024.10.09 22:38:33.864354 [ 3 ] {} <Trace> HTTP-Session: 8ee5eefd-e4f7-4a8c-9b80-ea06f9008884 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 416 | 2024.10.09 22:38:33.864821 [ 3 ] {357702b4-6e29-4aec-86bc-885fcd757bbd} <Debug> executeQuery: (from [::1]:45919) 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:38:33.864916 [ 3 ] {357702b4-6e29-4aec-86bc-885fcd757bbd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 418 | 2024.10.09 22:38:33.867522 [ 3 ] {357702b4-6e29-4aec-86bc-885fcd757bbd} <Debug> oximeter.measurements_cumulativei64 (87b3de48-bd71-432d-9f56-85cae3273fb6): Loading data parts | ||
| 419 | 2024.10.09 22:38:33.867983 [ 3 ] {357702b4-6e29-4aec-86bc-885fcd757bbd} <Debug> oximeter.measurements_cumulativei64 (87b3de48-bd71-432d-9f56-85cae3273fb6): There are no data parts | ||
| 420 | 2024.10.09 22:38:33.869844 [ 3 ] {357702b4-6e29-4aec-86bc-885fcd757bbd} <Debug> DynamicQueryHandler: Done processing query | ||
| 421 | 2024.10.09 22:38:33.869976 [ 3 ] {} <Debug> HTTP-Session: 8ee5eefd-e4f7-4a8c-9b80-ea06f9008884 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 422 | 2024.10.09 22:38:33.872184 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 423 | 2024.10.09 22:38:33.872268 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 424 | 2024.10.09 22:38:33.872294 [ 3 ] {} <Debug> HTTP-Session: 79d8f628-8052-4fdf-9d46-4ee49489d6de Authenticating user 'default' from [::1]:45919 | ||
| 425 | 2024.10.09 22:38:33.872362 [ 3 ] {} <Debug> HTTP-Session: 79d8f628-8052-4fdf-9d46-4ee49489d6de Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 426 | 2024.10.09 22:38:33.872407 [ 3 ] {} <Debug> HTTP-Session: 79d8f628-8052-4fdf-9d46-4ee49489d6de Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 427 | 2024.10.09 22:38:33.872536 [ 3 ] {} <Trace> HTTP-Session: 79d8f628-8052-4fdf-9d46-4ee49489d6de Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 428 | 2024.10.09 22:38:33.872939 [ 3 ] {1d6930d3-aa6f-428e-8900-b5c4bfc7b654} <Debug> executeQuery: (from [::1]:45919) 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:38:33.873028 [ 3 ] {1d6930d3-aa6f-428e-8900-b5c4bfc7b654} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 430 | 2024.10.09 22:38:33.876174 [ 3 ] {1d6930d3-aa6f-428e-8900-b5c4bfc7b654} <Debug> oximeter.measurements_cumulativeu64 (90480485-0b6c-45bc-bb09-e75baf29f8a6): Loading data parts | ||
| 431 | 2024.10.09 22:38:33.876480 [ 3 ] {1d6930d3-aa6f-428e-8900-b5c4bfc7b654} <Debug> oximeter.measurements_cumulativeu64 (90480485-0b6c-45bc-bb09-e75baf29f8a6): There are no data parts | ||
| 432 | 2024.10.09 22:38:33.878324 [ 3 ] {1d6930d3-aa6f-428e-8900-b5c4bfc7b654} <Debug> DynamicQueryHandler: Done processing query | ||
| 433 | 2024.10.09 22:38:33.878354 [ 3 ] {} <Debug> HTTP-Session: 79d8f628-8052-4fdf-9d46-4ee49489d6de Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 434 | 2024.10.09 22:38:33.879327 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 435 | 2024.10.09 22:38:33.879415 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 436 | 2024.10.09 22:38:33.879441 [ 3 ] {} <Debug> HTTP-Session: 573c455e-99fd-45ff-88e2-0e23ece81c72 Authenticating user 'default' from [::1]:45919 | ||
| 437 | 2024.10.09 22:38:33.879465 [ 3 ] {} <Debug> HTTP-Session: 573c455e-99fd-45ff-88e2-0e23ece81c72 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 438 | 2024.10.09 22:38:33.879487 [ 3 ] {} <Debug> HTTP-Session: 573c455e-99fd-45ff-88e2-0e23ece81c72 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 439 | 2024.10.09 22:38:33.879539 [ 3 ] {} <Trace> HTTP-Session: 573c455e-99fd-45ff-88e2-0e23ece81c72 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 440 | 2024.10.09 22:38:33.879875 [ 3 ] {fd397ded-db26-4a13-9ed8-376e296c92ae} <Debug> executeQuery: (from [::1]:45919) 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:38:33.879949 [ 3 ] {fd397ded-db26-4a13-9ed8-376e296c92ae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 442 | 2024.10.09 22:38:33.882735 [ 3 ] {fd397ded-db26-4a13-9ed8-376e296c92ae} <Debug> oximeter.measurements_cumulativef32 (ab4462be-0a5f-4acd-bf6b-ce6d4ae2d1f0): Loading data parts | ||
| 443 | 2024.10.09 22:38:33.883084 [ 3 ] {fd397ded-db26-4a13-9ed8-376e296c92ae} <Debug> oximeter.measurements_cumulativef32 (ab4462be-0a5f-4acd-bf6b-ce6d4ae2d1f0): There are no data parts | ||
| 444 | 2024.10.09 22:38:33.884966 [ 3 ] {fd397ded-db26-4a13-9ed8-376e296c92ae} <Debug> DynamicQueryHandler: Done processing query | ||
| 445 | 2024.10.09 22:38:33.885002 [ 3 ] {} <Debug> HTTP-Session: 573c455e-99fd-45ff-88e2-0e23ece81c72 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 446 | 2024.10.09 22:38:33.885920 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 447 | 2024.10.09 22:38:33.886012 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 448 | 2024.10.09 22:38:33.886040 [ 3 ] {} <Debug> HTTP-Session: c28d5059-ab99-47c5-9cea-71f53b41ac7f Authenticating user 'default' from [::1]:45919 | ||
| 449 | 2024.10.09 22:38:33.886083 [ 3 ] {} <Debug> HTTP-Session: c28d5059-ab99-47c5-9cea-71f53b41ac7f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 450 | 2024.10.09 22:38:33.886143 [ 3 ] {} <Debug> HTTP-Session: c28d5059-ab99-47c5-9cea-71f53b41ac7f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 451 | 2024.10.09 22:38:33.886212 [ 3 ] {} <Trace> HTTP-Session: c28d5059-ab99-47c5-9cea-71f53b41ac7f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 452 | 2024.10.09 22:38:33.886656 [ 3 ] {a142d0b3-87d9-43af-b678-4dd91dba076e} <Debug> executeQuery: (from [::1]:45919) 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:38:33.886744 [ 3 ] {a142d0b3-87d9-43af-b678-4dd91dba076e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 454 | 2024.10.09 22:38:33.889576 [ 3 ] {a142d0b3-87d9-43af-b678-4dd91dba076e} <Debug> oximeter.measurements_cumulativef64 (c40ae227-fe23-4e1e-8623-1088c0692c01): Loading data parts | ||
| 455 | 2024.10.09 22:38:33.889853 [ 3 ] {a142d0b3-87d9-43af-b678-4dd91dba076e} <Debug> oximeter.measurements_cumulativef64 (c40ae227-fe23-4e1e-8623-1088c0692c01): There are no data parts | ||
| 456 | 2024.10.09 22:38:33.891722 [ 3 ] {a142d0b3-87d9-43af-b678-4dd91dba076e} <Debug> DynamicQueryHandler: Done processing query | ||
| 457 | 2024.10.09 22:38:33.891754 [ 3 ] {} <Debug> HTTP-Session: c28d5059-ab99-47c5-9cea-71f53b41ac7f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 458 | 2024.10.09 22:38:33.892450 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 459 | 2024.10.09 22:38:33.892543 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 460 | 2024.10.09 22:38:33.892570 [ 3 ] {} <Debug> HTTP-Session: 2fef93d7-35a8-4de9-9e62-176ca7e034fc Authenticating user 'default' from [::1]:45919 | ||
| 461 | 2024.10.09 22:38:33.892595 [ 3 ] {} <Debug> HTTP-Session: 2fef93d7-35a8-4de9-9e62-176ca7e034fc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 462 | 2024.10.09 22:38:33.892617 [ 3 ] {} <Debug> HTTP-Session: 2fef93d7-35a8-4de9-9e62-176ca7e034fc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 463 | 2024.10.09 22:38:33.892666 [ 3 ] {} <Trace> HTTP-Session: 2fef93d7-35a8-4de9-9e62-176ca7e034fc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 464 | 2024.10.09 22:38:33.893107 [ 3 ] {1d19d8af-167d-41e7-b4e5-c1eb9e3336e3} <Debug> executeQuery: (from [::1]:45919) 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:38:33.893199 [ 3 ] {1d19d8af-167d-41e7-b4e5-c1eb9e3336e3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 476 | 2024.10.09 22:38:33.896666 [ 3 ] {1d19d8af-167d-41e7-b4e5-c1eb9e3336e3} <Debug> oximeter.measurements_histogrami8 (848b1bcb-0eec-4de5-bb69-fd9aa3488b87): Loading data parts | ||
| 477 | 2024.10.09 22:38:33.897046 [ 3 ] {1d19d8af-167d-41e7-b4e5-c1eb9e3336e3} <Debug> oximeter.measurements_histogrami8 (848b1bcb-0eec-4de5-bb69-fd9aa3488b87): There are no data parts | ||
| 478 | 2024.10.09 22:38:33.899018 [ 3 ] {1d19d8af-167d-41e7-b4e5-c1eb9e3336e3} <Debug> DynamicQueryHandler: Done processing query | ||
| 479 | 2024.10.09 22:38:33.899053 [ 3 ] {} <Debug> HTTP-Session: 2fef93d7-35a8-4de9-9e62-176ca7e034fc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 480 | 2024.10.09 22:38:33.899846 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 481 | 2024.10.09 22:38:33.899923 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 482 | 2024.10.09 22:38:33.899951 [ 3 ] {} <Debug> HTTP-Session: 02fca1fe-f865-4b5f-b4df-fd24c6e9c6a8 Authenticating user 'default' from [::1]:45919 | ||
| 483 | 2024.10.09 22:38:33.899990 [ 3 ] {} <Debug> HTTP-Session: 02fca1fe-f865-4b5f-b4df-fd24c6e9c6a8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 484 | 2024.10.09 22:38:33.900039 [ 3 ] {} <Debug> HTTP-Session: 02fca1fe-f865-4b5f-b4df-fd24c6e9c6a8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 485 | 2024.10.09 22:38:33.900091 [ 3 ] {} <Trace> HTTP-Session: 02fca1fe-f865-4b5f-b4df-fd24c6e9c6a8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 486 | 2024.10.09 22:38:33.900557 [ 3 ] {7d563e05-08fd-4091-be6a-3021786f815b} <Debug> executeQuery: (from [::1]:45919) 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:38:33.900650 [ 3 ] {7d563e05-08fd-4091-be6a-3021786f815b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 488 | 2024.10.09 22:38:33.903698 [ 3 ] {7d563e05-08fd-4091-be6a-3021786f815b} <Debug> oximeter.measurements_histogramu8 (bd375219-1b68-43de-8aa1-0ceadd7cda51): Loading data parts | ||
| 489 | 2024.10.09 22:38:33.903955 [ 3 ] {7d563e05-08fd-4091-be6a-3021786f815b} <Debug> oximeter.measurements_histogramu8 (bd375219-1b68-43de-8aa1-0ceadd7cda51): There are no data parts | ||
| 490 | 2024.10.09 22:38:33.905818 [ 3 ] {7d563e05-08fd-4091-be6a-3021786f815b} <Debug> DynamicQueryHandler: Done processing query | ||
| 491 | 2024.10.09 22:38:33.905847 [ 3 ] {} <Debug> HTTP-Session: 02fca1fe-f865-4b5f-b4df-fd24c6e9c6a8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 492 | 2024.10.09 22:38:33.906581 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 493 | 2024.10.09 22:38:33.906659 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 494 | 2024.10.09 22:38:33.906677 [ 3 ] {} <Debug> HTTP-Session: 2312295e-d71f-4407-93f4-edb52908696a Authenticating user 'default' from [::1]:45919 | ||
| 495 | 2024.10.09 22:38:33.906695 [ 3 ] {} <Debug> HTTP-Session: 2312295e-d71f-4407-93f4-edb52908696a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 496 | 2024.10.09 22:38:33.906705 [ 3 ] {} <Debug> HTTP-Session: 2312295e-d71f-4407-93f4-edb52908696a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 497 | 2024.10.09 22:38:33.906749 [ 3 ] {} <Trace> HTTP-Session: 2312295e-d71f-4407-93f4-edb52908696a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 498 | 2024.10.09 22:38:33.907202 [ 3 ] {174fb1e5-fbfc-4e4d-902f-e7d03257ec55} <Debug> executeQuery: (from [::1]:45919) 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:38:33.907310 [ 3 ] {174fb1e5-fbfc-4e4d-902f-e7d03257ec55} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 500 | 2024.10.09 22:38:33.910793 [ 3 ] {174fb1e5-fbfc-4e4d-902f-e7d03257ec55} <Debug> oximeter.measurements_histogrami16 (af0271e2-9c13-45b1-af9d-67f115dcfaf4): Loading data parts | ||
| 501 | 2024.10.09 22:38:33.912352 [ 3 ] {174fb1e5-fbfc-4e4d-902f-e7d03257ec55} <Debug> oximeter.measurements_histogrami16 (af0271e2-9c13-45b1-af9d-67f115dcfaf4): There are no data parts | ||
| 502 | 2024.10.09 22:38:33.914862 [ 3 ] {174fb1e5-fbfc-4e4d-902f-e7d03257ec55} <Debug> DynamicQueryHandler: Done processing query | ||
| 503 | 2024.10.09 22:38:33.914893 [ 3 ] {} <Debug> HTTP-Session: 2312295e-d71f-4407-93f4-edb52908696a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 504 | 2024.10.09 22:38:33.915680 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 505 | 2024.10.09 22:38:33.915816 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 506 | 2024.10.09 22:38:33.915849 [ 3 ] {} <Debug> HTTP-Session: 829e7533-b39a-404e-bf83-e353693b2bf7 Authenticating user 'default' from [::1]:45919 | ||
| 507 | 2024.10.09 22:38:33.915886 [ 3 ] {} <Debug> HTTP-Session: 829e7533-b39a-404e-bf83-e353693b2bf7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 508 | 2024.10.09 22:38:33.915900 [ 3 ] {} <Debug> HTTP-Session: 829e7533-b39a-404e-bf83-e353693b2bf7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 509 | 2024.10.09 22:38:33.915955 [ 3 ] {} <Trace> HTTP-Session: 829e7533-b39a-404e-bf83-e353693b2bf7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 510 | 2024.10.09 22:38:33.916454 [ 3 ] {335fc446-612f-44d8-b89e-e26012abbc11} <Debug> executeQuery: (from [::1]:45919) 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:38:33.916552 [ 3 ] {335fc446-612f-44d8-b89e-e26012abbc11} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 512 | 2024.10.09 22:38:33.919834 [ 3 ] {335fc446-612f-44d8-b89e-e26012abbc11} <Debug> oximeter.measurements_histogramu16 (7b421e4d-5721-4928-8280-6826312968bc): Loading data parts | ||
| 513 | 2024.10.09 22:38:33.920190 [ 3 ] {335fc446-612f-44d8-b89e-e26012abbc11} <Debug> oximeter.measurements_histogramu16 (7b421e4d-5721-4928-8280-6826312968bc): There are no data parts | ||
| 514 | 2024.10.09 22:38:33.922363 [ 3 ] {335fc446-612f-44d8-b89e-e26012abbc11} <Debug> DynamicQueryHandler: Done processing query | ||
| 515 | 2024.10.09 22:38:33.922416 [ 3 ] {} <Debug> HTTP-Session: 829e7533-b39a-404e-bf83-e353693b2bf7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 516 | 2024.10.09 22:38:33.924606 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 517 | 2024.10.09 22:38:33.924845 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 518 | 2024.10.09 22:38:33.924897 [ 3 ] {} <Debug> HTTP-Session: 7ba97aad-f26f-4feb-92cc-8bc7d203cfd5 Authenticating user 'default' from [::1]:45919 | ||
| 519 | 2024.10.09 22:38:33.924926 [ 3 ] {} <Debug> HTTP-Session: 7ba97aad-f26f-4feb-92cc-8bc7d203cfd5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 520 | 2024.10.09 22:38:33.924945 [ 3 ] {} <Debug> HTTP-Session: 7ba97aad-f26f-4feb-92cc-8bc7d203cfd5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 521 | 2024.10.09 22:38:33.925010 [ 3 ] {} <Trace> HTTP-Session: 7ba97aad-f26f-4feb-92cc-8bc7d203cfd5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 522 | 2024.10.09 22:38:33.925607 [ 3 ] {753386dc-1c72-4ac1-97fb-2e16a7bfbea4} <Debug> executeQuery: (from [::1]:45919) 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) | ||
| 523 | 2024.10.09 22:38:33.925831 [ 3 ] {753386dc-1c72-4ac1-97fb-2e16a7bfbea4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 524 | 2024.10.09 22:38:33.928964 [ 3 ] {753386dc-1c72-4ac1-97fb-2e16a7bfbea4} <Debug> oximeter.measurements_histogrami32 (980768f6-edd8-4e34-874c-aa9b091b37bc): Loading data parts | ||
| 525 | 2024.10.09 22:38:33.929277 [ 3 ] {753386dc-1c72-4ac1-97fb-2e16a7bfbea4} <Debug> oximeter.measurements_histogrami32 (980768f6-edd8-4e34-874c-aa9b091b37bc): There are no data parts | ||
| 526 | 2024.10.09 22:38:33.931244 [ 3 ] {753386dc-1c72-4ac1-97fb-2e16a7bfbea4} <Debug> DynamicQueryHandler: Done processing query | ||
| 527 | 2024.10.09 22:38:33.931272 [ 3 ] {} <Debug> HTTP-Session: 7ba97aad-f26f-4feb-92cc-8bc7d203cfd5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 528 | 2024.10.09 22:38:33.932455 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 529 | 2024.10.09 22:38:33.932542 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 530 | 2024.10.09 22:38:33.932568 [ 3 ] {} <Debug> HTTP-Session: 562c56ee-6f44-404e-96ec-c1c9614c7180 Authenticating user 'default' from [::1]:45919 | ||
| 531 | 2024.10.09 22:38:33.932591 [ 3 ] {} <Debug> HTTP-Session: 562c56ee-6f44-404e-96ec-c1c9614c7180 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 532 | 2024.10.09 22:38:33.932618 [ 3 ] {} <Debug> HTTP-Session: 562c56ee-6f44-404e-96ec-c1c9614c7180 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 533 | 2024.10.09 22:38:33.932665 [ 3 ] {} <Trace> HTTP-Session: 562c56ee-6f44-404e-96ec-c1c9614c7180 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 534 | 2024.10.09 22:38:33.933143 [ 3 ] {f0b4f8fb-a2a5-40ba-accf-afadd2651da7} <Debug> executeQuery: (from [::1]:45919) 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) | ||
| 535 | 2024.10.09 22:38:33.933248 [ 3 ] {f0b4f8fb-a2a5-40ba-accf-afadd2651da7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 536 | 2024.10.09 22:38:33.936567 [ 3 ] {f0b4f8fb-a2a5-40ba-accf-afadd2651da7} <Debug> oximeter.measurements_histogramu32 (142f0a7f-c1b8-4ff2-ace6-016bbecb4ae0): Loading data parts | ||
| 537 | 2024.10.09 22:38:33.936885 [ 3 ] {f0b4f8fb-a2a5-40ba-accf-afadd2651da7} <Debug> oximeter.measurements_histogramu32 (142f0a7f-c1b8-4ff2-ace6-016bbecb4ae0): There are no data parts | ||
| 538 | 2024.10.09 22:38:33.939155 [ 3 ] {f0b4f8fb-a2a5-40ba-accf-afadd2651da7} <Debug> DynamicQueryHandler: Done processing query | ||
| 539 | 2024.10.09 22:38:33.939187 [ 3 ] {} <Debug> HTTP-Session: 562c56ee-6f44-404e-96ec-c1c9614c7180 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 540 | 2024.10.09 22:38:33.939930 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 541 | 2024.10.09 22:38:33.940008 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 542 | 2024.10.09 22:38:33.940047 [ 3 ] {} <Debug> HTTP-Session: dc2d10ce-8851-4716-9510-537cec1c1eaa Authenticating user 'default' from [::1]:45919 | ||
| 543 | 2024.10.09 22:38:33.940075 [ 3 ] {} <Debug> HTTP-Session: dc2d10ce-8851-4716-9510-537cec1c1eaa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 544 | 2024.10.09 22:38:33.940090 [ 3 ] {} <Debug> HTTP-Session: dc2d10ce-8851-4716-9510-537cec1c1eaa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 545 | 2024.10.09 22:38:33.940143 [ 3 ] {} <Trace> HTTP-Session: dc2d10ce-8851-4716-9510-537cec1c1eaa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 546 | 2024.10.09 22:38:33.940783 [ 3 ] {a6027fc8-c6ce-46ff-a0af-332d387eeaaa} <Debug> executeQuery: (from [::1]:45919) 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) | ||
| 547 | 2024.10.09 22:38:33.940888 [ 3 ] {a6027fc8-c6ce-46ff-a0af-332d387eeaaa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 548 | 2024.10.09 22:38:33.983520 [ 3 ] {a6027fc8-c6ce-46ff-a0af-332d387eeaaa} <Debug> oximeter.measurements_histogrami64 (3688d084-8324-49cb-a55e-7e45785b82c3): Loading data parts | ||
| 549 | 2024.10.09 22:38:33.992157 [ 3 ] {a6027fc8-c6ce-46ff-a0af-332d387eeaaa} <Debug> oximeter.measurements_histogrami64 (3688d084-8324-49cb-a55e-7e45785b82c3): There are no data parts | ||
| 550 | 2024.10.09 22:38:33.999884 [ 3 ] {a6027fc8-c6ce-46ff-a0af-332d387eeaaa} <Debug> DynamicQueryHandler: Done processing query | ||
| 551 | 2024.10.09 22:38:34.000395 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 143.19 MiB, peak 143.19 MiB, free memory in arenas 0.00 B, will set to 146.76 MiB (RSS), difference: 3.56 MiB | ||
| 552 | 2024.10.09 22:38:33.999972 [ 3 ] {} <Debug> HTTP-Session: dc2d10ce-8851-4716-9510-537cec1c1eaa Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 553 | 2024.10.09 22:38:34.004640 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 554 | 2024.10.09 22:38:34.004750 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 555 | 2024.10.09 22:38:34.004775 [ 3 ] {} <Debug> HTTP-Session: b2ce6764-979f-41bf-a327-5c321130563a Authenticating user 'default' from [::1]:45919 | ||
| 556 | 2024.10.09 22:38:34.004817 [ 3 ] {} <Debug> HTTP-Session: b2ce6764-979f-41bf-a327-5c321130563a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 557 | 2024.10.09 22:38:34.004831 [ 3 ] {} <Debug> HTTP-Session: b2ce6764-979f-41bf-a327-5c321130563a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 558 | 2024.10.09 22:38:34.004883 [ 3 ] {} <Trace> HTTP-Session: b2ce6764-979f-41bf-a327-5c321130563a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 559 | 2024.10.09 22:38:34.005680 [ 3 ] {af5688e0-1364-4491-b38b-1749a3d30128} <Debug> executeQuery: (from [::1]:45919) 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:38:34.005775 [ 3 ] {af5688e0-1364-4491-b38b-1749a3d30128} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 561 | 2024.10.09 22:38:34.011168 [ 3 ] {af5688e0-1364-4491-b38b-1749a3d30128} <Debug> oximeter.measurements_histogramu64 (fc30bb9f-9301-467e-89e2-eab7dcbd0646): Loading data parts | ||
| 562 | 2024.10.09 22:38:34.011662 [ 3 ] {af5688e0-1364-4491-b38b-1749a3d30128} <Debug> oximeter.measurements_histogramu64 (fc30bb9f-9301-467e-89e2-eab7dcbd0646): There are no data parts | ||
| 563 | 2024.10.09 22:38:34.014456 [ 3 ] {af5688e0-1364-4491-b38b-1749a3d30128} <Debug> DynamicQueryHandler: Done processing query | ||
| 564 | 2024.10.09 22:38:34.014507 [ 3 ] {} <Debug> HTTP-Session: b2ce6764-979f-41bf-a327-5c321130563a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 565 | 2024.10.09 22:38:34.015396 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 566 | 2024.10.09 22:38:34.015476 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 567 | 2024.10.09 22:38:34.015513 [ 3 ] {} <Debug> HTTP-Session: 47a0fa32-7a4c-405a-8399-e167c42faf7d Authenticating user 'default' from [::1]:45919 | ||
| 568 | 2024.10.09 22:38:34.015534 [ 3 ] {} <Debug> HTTP-Session: 47a0fa32-7a4c-405a-8399-e167c42faf7d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 569 | 2024.10.09 22:38:34.015548 [ 3 ] {} <Debug> HTTP-Session: 47a0fa32-7a4c-405a-8399-e167c42faf7d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 570 | 2024.10.09 22:38:34.015599 [ 3 ] {} <Trace> HTTP-Session: 47a0fa32-7a4c-405a-8399-e167c42faf7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 571 | 2024.10.09 22:38:34.016005 [ 3 ] {14ddc48e-2796-43eb-b201-2c7b1f77a6d9} <Debug> executeQuery: (from [::1]:45919) 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:38:34.016097 [ 3 ] {14ddc48e-2796-43eb-b201-2c7b1f77a6d9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 573 | 2024.10.09 22:38:34.025801 [ 3 ] {14ddc48e-2796-43eb-b201-2c7b1f77a6d9} <Debug> oximeter.measurements_histogramf32 (8596da64-9a6e-4c8b-8a54-072e341b1c84): Loading data parts | ||
| 574 | 2024.10.09 22:38:34.026431 [ 3 ] {14ddc48e-2796-43eb-b201-2c7b1f77a6d9} <Debug> oximeter.measurements_histogramf32 (8596da64-9a6e-4c8b-8a54-072e341b1c84): There are no data parts | ||
| 575 | 2024.10.09 22:38:34.030436 [ 3 ] {14ddc48e-2796-43eb-b201-2c7b1f77a6d9} <Debug> DynamicQueryHandler: Done processing query | ||
| 576 | 2024.10.09 22:38:34.030474 [ 3 ] {} <Debug> HTTP-Session: 47a0fa32-7a4c-405a-8399-e167c42faf7d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 577 | 2024.10.09 22:38:34.031850 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 578 | 2024.10.09 22:38:34.031952 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 579 | 2024.10.09 22:38:34.031980 [ 3 ] {} <Debug> HTTP-Session: da24c40c-1aef-4353-bb4a-ab0ac2188782 Authenticating user 'default' from [::1]:45919 | ||
| 580 | 2024.10.09 22:38:34.032007 [ 3 ] {} <Debug> HTTP-Session: da24c40c-1aef-4353-bb4a-ab0ac2188782 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 581 | 2024.10.09 22:38:34.032034 [ 3 ] {} <Debug> HTTP-Session: da24c40c-1aef-4353-bb4a-ab0ac2188782 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 582 | 2024.10.09 22:38:34.032087 [ 3 ] {} <Trace> HTTP-Session: da24c40c-1aef-4353-bb4a-ab0ac2188782 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 583 | 2024.10.09 22:38:34.034544 [ 3 ] {fad47075-fa0e-4c3b-85c9-ec8857dd1d0e} <Debug> executeQuery: (from [::1]:45919) 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:38:34.034652 [ 3 ] {fad47075-fa0e-4c3b-85c9-ec8857dd1d0e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 585 | 2024.10.09 22:38:34.038960 [ 3 ] {fad47075-fa0e-4c3b-85c9-ec8857dd1d0e} <Debug> oximeter.measurements_histogramf64 (cba73617-c439-48c3-9061-71f5f00b5ccc): Loading data parts | ||
| 586 | 2024.10.09 22:38:34.039570 [ 3 ] {fad47075-fa0e-4c3b-85c9-ec8857dd1d0e} <Debug> oximeter.measurements_histogramf64 (cba73617-c439-48c3-9061-71f5f00b5ccc): There are no data parts | ||
| 587 | 2024.10.09 22:38:34.041600 [ 3 ] {fad47075-fa0e-4c3b-85c9-ec8857dd1d0e} <Debug> DynamicQueryHandler: Done processing query | ||
| 588 | 2024.10.09 22:38:34.041650 [ 3 ] {} <Debug> HTTP-Session: da24c40c-1aef-4353-bb4a-ab0ac2188782 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 589 | 2024.10.09 22:38:34.042322 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 590 | 2024.10.09 22:38:34.042413 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 591 | 2024.10.09 22:38:34.042722 [ 3 ] {} <Debug> HTTP-Session: b0eb66b0-1000-4bea-a4bf-5b777538796f Authenticating user 'default' from [::1]:45919 | ||
| 592 | 2024.10.09 22:38:34.042863 [ 3 ] {} <Debug> HTTP-Session: b0eb66b0-1000-4bea-a4bf-5b777538796f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 593 | 2024.10.09 22:38:34.042880 [ 3 ] {} <Debug> HTTP-Session: b0eb66b0-1000-4bea-a4bf-5b777538796f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 594 | 2024.10.09 22:38:34.042936 [ 3 ] {} <Trace> HTTP-Session: b0eb66b0-1000-4bea-a4bf-5b777538796f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 595 | 2024.10.09 22:38:34.043244 [ 3 ] {de46ac59-cd0f-4ea3-bf5a-dc9319fef666} <Debug> executeQuery: (from [::1]:45919) /* 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:38:34.045111 [ 3 ] {de46ac59-cd0f-4ea3-bf5a-dc9319fef666} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 622 | 2024.10.09 22:38:34.048655 [ 3 ] {de46ac59-cd0f-4ea3-bf5a-dc9319fef666} <Debug> oximeter.fields_bool (c652d175-33be-4037-af5e-b54d6e005b0b): Loading data parts | ||
| 623 | 2024.10.09 22:38:34.048973 [ 3 ] {de46ac59-cd0f-4ea3-bf5a-dc9319fef666} <Debug> oximeter.fields_bool (c652d175-33be-4037-af5e-b54d6e005b0b): There are no data parts | ||
| 624 | 2024.10.09 22:38:34.051892 [ 3 ] {de46ac59-cd0f-4ea3-bf5a-dc9319fef666} <Debug> DynamicQueryHandler: Done processing query | ||
| 625 | 2024.10.09 22:38:34.051921 [ 3 ] {} <Debug> HTTP-Session: b0eb66b0-1000-4bea-a4bf-5b777538796f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 626 | 2024.10.09 22:38:34.056019 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 627 | 2024.10.09 22:38:34.056121 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 628 | 2024.10.09 22:38:34.056143 [ 3 ] {} <Debug> HTTP-Session: 5e209905-5b55-4e15-97cd-c54dcbfc1fd4 Authenticating user 'default' from [::1]:45919 | ||
| 629 | 2024.10.09 22:38:34.056164 [ 3 ] {} <Debug> HTTP-Session: 5e209905-5b55-4e15-97cd-c54dcbfc1fd4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 630 | 2024.10.09 22:38:34.056188 [ 3 ] {} <Debug> HTTP-Session: 5e209905-5b55-4e15-97cd-c54dcbfc1fd4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 631 | 2024.10.09 22:38:34.056230 [ 3 ] {} <Trace> HTTP-Session: 5e209905-5b55-4e15-97cd-c54dcbfc1fd4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 632 | 2024.10.09 22:38:34.056887 [ 3 ] {7fe79ab7-adcb-4304-b046-cfb83cd24943} <Debug> executeQuery: (from [::1]:45919) 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:38:34.056964 [ 3 ] {7fe79ab7-adcb-4304-b046-cfb83cd24943} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 634 | 2024.10.09 22:38:34.059956 [ 3 ] {7fe79ab7-adcb-4304-b046-cfb83cd24943} <Debug> oximeter.fields_i8 (94b3764b-32c8-4655-993b-1e225eba4957): Loading data parts | ||
| 635 | 2024.10.09 22:38:34.060466 [ 3 ] {7fe79ab7-adcb-4304-b046-cfb83cd24943} <Debug> oximeter.fields_i8 (94b3764b-32c8-4655-993b-1e225eba4957): There are no data parts | ||
| 636 | 2024.10.09 22:38:34.062462 [ 3 ] {7fe79ab7-adcb-4304-b046-cfb83cd24943} <Debug> DynamicQueryHandler: Done processing query | ||
| 637 | 2024.10.09 22:38:34.062491 [ 3 ] {} <Debug> HTTP-Session: 5e209905-5b55-4e15-97cd-c54dcbfc1fd4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 638 | 2024.10.09 22:38:34.063588 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 639 | 2024.10.09 22:38:34.063653 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 640 | 2024.10.09 22:38:34.063673 [ 3 ] {} <Debug> HTTP-Session: 5ef63e47-f27c-4726-a226-73cd16a8146c Authenticating user 'default' from [::1]:45919 | ||
| 641 | 2024.10.09 22:38:34.063793 [ 3 ] {} <Debug> HTTP-Session: 5ef63e47-f27c-4726-a226-73cd16a8146c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 642 | 2024.10.09 22:38:34.063867 [ 3 ] {} <Debug> HTTP-Session: 5ef63e47-f27c-4726-a226-73cd16a8146c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 643 | 2024.10.09 22:38:34.063959 [ 3 ] {} <Trace> HTTP-Session: 5ef63e47-f27c-4726-a226-73cd16a8146c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 644 | 2024.10.09 22:38:34.064324 [ 3 ] {18d1a1fa-dfc8-4005-8035-3db44bc9f829} <Debug> executeQuery: (from [::1]:45919) 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:38:34.064395 [ 3 ] {18d1a1fa-dfc8-4005-8035-3db44bc9f829} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 646 | 2024.10.09 22:38:34.068559 [ 3 ] {18d1a1fa-dfc8-4005-8035-3db44bc9f829} <Debug> oximeter.fields_u8 (9023069e-f01f-4094-96d4-ff3103b59f77): Loading data parts | ||
| 647 | 2024.10.09 22:38:34.068838 [ 3 ] {18d1a1fa-dfc8-4005-8035-3db44bc9f829} <Debug> oximeter.fields_u8 (9023069e-f01f-4094-96d4-ff3103b59f77): There are no data parts | ||
| 648 | 2024.10.09 22:38:34.074099 [ 3 ] {18d1a1fa-dfc8-4005-8035-3db44bc9f829} <Debug> DynamicQueryHandler: Done processing query | ||
| 649 | 2024.10.09 22:38:34.074145 [ 3 ] {} <Debug> HTTP-Session: 5ef63e47-f27c-4726-a226-73cd16a8146c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 650 | 2024.10.09 22:38:34.078472 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 651 | 2024.10.09 22:38:34.078710 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 652 | 2024.10.09 22:38:34.078746 [ 3 ] {} <Debug> HTTP-Session: 29312081-ba3d-4d8a-8c4e-6fe54c02d64b Authenticating user 'default' from [::1]:45919 | ||
| 653 | 2024.10.09 22:38:34.078774 [ 3 ] {} <Debug> HTTP-Session: 29312081-ba3d-4d8a-8c4e-6fe54c02d64b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 654 | 2024.10.09 22:38:34.078790 [ 3 ] {} <Debug> HTTP-Session: 29312081-ba3d-4d8a-8c4e-6fe54c02d64b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 655 | 2024.10.09 22:38:34.078862 [ 3 ] {} <Trace> HTTP-Session: 29312081-ba3d-4d8a-8c4e-6fe54c02d64b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 656 | 2024.10.09 22:38:34.079298 [ 3 ] {7c697b06-590e-4200-818a-0d645312c7b4} <Debug> executeQuery: (from [::1]:45919) 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:38:34.079395 [ 3 ] {7c697b06-590e-4200-818a-0d645312c7b4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 658 | 2024.10.09 22:38:34.084146 [ 3 ] {7c697b06-590e-4200-818a-0d645312c7b4} <Debug> oximeter.fields_i16 (785f81a5-b606-43d4-9064-6485ac2b9314): Loading data parts | ||
| 659 | 2024.10.09 22:38:34.084613 [ 3 ] {7c697b06-590e-4200-818a-0d645312c7b4} <Debug> oximeter.fields_i16 (785f81a5-b606-43d4-9064-6485ac2b9314): There are no data parts | ||
| 660 | 2024.10.09 22:38:34.087658 [ 3 ] {7c697b06-590e-4200-818a-0d645312c7b4} <Debug> DynamicQueryHandler: Done processing query | ||
| 661 | 2024.10.09 22:38:34.087691 [ 3 ] {} <Debug> HTTP-Session: 29312081-ba3d-4d8a-8c4e-6fe54c02d64b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 662 | 2024.10.09 22:38:34.088585 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 663 | 2024.10.09 22:38:34.088704 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 664 | 2024.10.09 22:38:34.088735 [ 3 ] {} <Debug> HTTP-Session: d0f8075f-c962-438c-a55f-6023b669619c Authenticating user 'default' from [::1]:45919 | ||
| 665 | 2024.10.09 22:38:34.088771 [ 3 ] {} <Debug> HTTP-Session: d0f8075f-c962-438c-a55f-6023b669619c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 666 | 2024.10.09 22:38:34.088785 [ 3 ] {} <Debug> HTTP-Session: d0f8075f-c962-438c-a55f-6023b669619c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 667 | 2024.10.09 22:38:34.088827 [ 3 ] {} <Trace> HTTP-Session: d0f8075f-c962-438c-a55f-6023b669619c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 668 | 2024.10.09 22:38:34.089150 [ 3 ] {c8ae9ef0-ba7d-49a8-ac0b-19ce4ebd6f68} <Debug> executeQuery: (from [::1]:45919) 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:38:34.089234 [ 3 ] {c8ae9ef0-ba7d-49a8-ac0b-19ce4ebd6f68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 670 | 2024.10.09 22:38:34.091852 [ 3 ] {c8ae9ef0-ba7d-49a8-ac0b-19ce4ebd6f68} <Debug> oximeter.fields_u16 (0658a46d-deac-49ef-8718-b023eed565f9): Loading data parts | ||
| 671 | 2024.10.09 22:38:34.092639 [ 3 ] {c8ae9ef0-ba7d-49a8-ac0b-19ce4ebd6f68} <Debug> oximeter.fields_u16 (0658a46d-deac-49ef-8718-b023eed565f9): There are no data parts | ||
| 672 | 2024.10.09 22:38:34.095449 [ 3 ] {c8ae9ef0-ba7d-49a8-ac0b-19ce4ebd6f68} <Debug> DynamicQueryHandler: Done processing query | ||
| 673 | 2024.10.09 22:38:34.095502 [ 3 ] {} <Debug> HTTP-Session: d0f8075f-c962-438c-a55f-6023b669619c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 674 | 2024.10.09 22:38:34.118417 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 675 | 2024.10.09 22:38:34.118715 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 676 | 2024.10.09 22:38:34.118955 [ 3 ] {} <Debug> HTTP-Session: 6025d2b0-a5b4-488a-863b-cd8e6cd6af46 Authenticating user 'default' from [::1]:45919 | ||
| 677 | 2024.10.09 22:38:34.118991 [ 3 ] {} <Debug> HTTP-Session: 6025d2b0-a5b4-488a-863b-cd8e6cd6af46 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 678 | 2024.10.09 22:38:34.120300 [ 3 ] {} <Debug> HTTP-Session: 6025d2b0-a5b4-488a-863b-cd8e6cd6af46 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 679 | 2024.10.09 22:38:34.120456 [ 3 ] {} <Trace> HTTP-Session: 6025d2b0-a5b4-488a-863b-cd8e6cd6af46 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 680 | 2024.10.09 22:38:34.120898 [ 3 ] {88db7ef4-2760-42f4-9068-e50fa18d9496} <Debug> executeQuery: (from [::1]:45919) 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:38:34.121243 [ 3 ] {88db7ef4-2760-42f4-9068-e50fa18d9496} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 682 | 2024.10.09 22:38:34.128584 [ 3 ] {88db7ef4-2760-42f4-9068-e50fa18d9496} <Debug> oximeter.fields_i32 (bb3bd75f-bd09-4be0-8efb-8aad2df6b1ff): Loading data parts | ||
| 683 | 2024.10.09 22:38:34.128979 [ 3 ] {88db7ef4-2760-42f4-9068-e50fa18d9496} <Debug> oximeter.fields_i32 (bb3bd75f-bd09-4be0-8efb-8aad2df6b1ff): There are no data parts | ||
| 684 | 2024.10.09 22:38:34.139123 [ 3 ] {88db7ef4-2760-42f4-9068-e50fa18d9496} <Debug> DynamicQueryHandler: Done processing query | ||
| 685 | 2024.10.09 22:38:34.139281 [ 3 ] {} <Debug> HTTP-Session: 6025d2b0-a5b4-488a-863b-cd8e6cd6af46 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 686 | 2024.10.09 22:38:34.247049 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 687 | 2024.10.09 22:38:34.247199 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 688 | 2024.10.09 22:38:34.247226 [ 3 ] {} <Debug> HTTP-Session: d1fc390b-1739-497d-8c81-cd0343f6f67b Authenticating user 'default' from [::1]:45919 | ||
| 689 | 2024.10.09 22:38:34.247253 [ 3 ] {} <Debug> HTTP-Session: d1fc390b-1739-497d-8c81-cd0343f6f67b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 690 | 2024.10.09 22:38:34.247276 [ 3 ] {} <Debug> HTTP-Session: d1fc390b-1739-497d-8c81-cd0343f6f67b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 691 | 2024.10.09 22:38:34.247377 [ 3 ] {} <Trace> HTTP-Session: d1fc390b-1739-497d-8c81-cd0343f6f67b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 692 | 2024.10.09 22:38:34.247969 [ 3 ] {61d4353e-3031-4b6f-9e6c-9c0518bf2f73} <Debug> executeQuery: (from [::1]:45919) 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:38:34.248053 [ 3 ] {61d4353e-3031-4b6f-9e6c-9c0518bf2f73} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 694 | 2024.10.09 22:38:34.266047 [ 3 ] {61d4353e-3031-4b6f-9e6c-9c0518bf2f73} <Debug> oximeter.fields_u32 (edf57ff4-103d-4325-912d-ec0969f70931): Loading data parts | ||
| 695 | 2024.10.09 22:38:34.266826 [ 3 ] {61d4353e-3031-4b6f-9e6c-9c0518bf2f73} <Debug> oximeter.fields_u32 (edf57ff4-103d-4325-912d-ec0969f70931): There are no data parts | ||
| 696 | 2024.10.09 22:38:34.269182 [ 3 ] {61d4353e-3031-4b6f-9e6c-9c0518bf2f73} <Debug> DynamicQueryHandler: Done processing query | ||
| 697 | 2024.10.09 22:38:34.269232 [ 3 ] {} <Debug> HTTP-Session: d1fc390b-1739-497d-8c81-cd0343f6f67b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 698 | 2024.10.09 22:38:34.270159 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 699 | 2024.10.09 22:38:34.270241 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 700 | 2024.10.09 22:38:34.270293 [ 3 ] {} <Debug> HTTP-Session: 797c93f4-54b1-4ea7-b1cd-f1d834f5e598 Authenticating user 'default' from [::1]:45919 | ||
| 701 | 2024.10.09 22:38:34.270323 [ 3 ] {} <Debug> HTTP-Session: 797c93f4-54b1-4ea7-b1cd-f1d834f5e598 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 702 | 2024.10.09 22:38:34.270339 [ 3 ] {} <Debug> HTTP-Session: 797c93f4-54b1-4ea7-b1cd-f1d834f5e598 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 703 | 2024.10.09 22:38:34.270524 [ 3 ] {} <Trace> HTTP-Session: 797c93f4-54b1-4ea7-b1cd-f1d834f5e598 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 704 | 2024.10.09 22:38:34.271123 [ 3 ] {4959d2f5-19ff-4660-8f8e-3e488a302d6f} <Debug> executeQuery: (from [::1]:45919) 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:38:34.271212 [ 3 ] {4959d2f5-19ff-4660-8f8e-3e488a302d6f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 706 | 2024.10.09 22:38:34.274309 [ 3 ] {4959d2f5-19ff-4660-8f8e-3e488a302d6f} <Debug> oximeter.fields_i64 (1e65f236-3738-456e-ad7b-7458f2398058): Loading data parts | ||
| 707 | 2024.10.09 22:38:34.274770 [ 3 ] {4959d2f5-19ff-4660-8f8e-3e488a302d6f} <Debug> oximeter.fields_i64 (1e65f236-3738-456e-ad7b-7458f2398058): There are no data parts | ||
| 708 | 2024.10.09 22:38:34.282290 [ 3 ] {4959d2f5-19ff-4660-8f8e-3e488a302d6f} <Debug> DynamicQueryHandler: Done processing query | ||
| 709 | 2024.10.09 22:38:34.282321 [ 3 ] {} <Debug> HTTP-Session: 797c93f4-54b1-4ea7-b1cd-f1d834f5e598 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 710 | 2024.10.09 22:38:34.285287 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 711 | 2024.10.09 22:38:34.285438 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 712 | 2024.10.09 22:38:34.285470 [ 3 ] {} <Debug> HTTP-Session: 4355ea5c-3855-496e-846d-7cd3a61ec726 Authenticating user 'default' from [::1]:45919 | ||
| 713 | 2024.10.09 22:38:34.285491 [ 3 ] {} <Debug> HTTP-Session: 4355ea5c-3855-496e-846d-7cd3a61ec726 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 714 | 2024.10.09 22:38:34.285504 [ 3 ] {} <Debug> HTTP-Session: 4355ea5c-3855-496e-846d-7cd3a61ec726 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 715 | 2024.10.09 22:38:34.285545 [ 3 ] {} <Trace> HTTP-Session: 4355ea5c-3855-496e-846d-7cd3a61ec726 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 716 | 2024.10.09 22:38:34.285818 [ 3 ] {0d39348f-6011-44d2-9fd0-deecce760e01} <Debug> executeQuery: (from [::1]:45919) 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:38:34.285882 [ 3 ] {0d39348f-6011-44d2-9fd0-deecce760e01} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 718 | 2024.10.09 22:38:34.289734 [ 3 ] {0d39348f-6011-44d2-9fd0-deecce760e01} <Debug> oximeter.fields_u64 (3d9c73a3-9b0a-472d-835f-41b81f9661ec): Loading data parts | ||
| 719 | 2024.10.09 22:38:34.289983 [ 3 ] {0d39348f-6011-44d2-9fd0-deecce760e01} <Debug> oximeter.fields_u64 (3d9c73a3-9b0a-472d-835f-41b81f9661ec): There are no data parts | ||
| 720 | 2024.10.09 22:38:34.295052 [ 3 ] {0d39348f-6011-44d2-9fd0-deecce760e01} <Debug> DynamicQueryHandler: Done processing query | ||
| 721 | 2024.10.09 22:38:34.295137 [ 3 ] {} <Debug> HTTP-Session: 4355ea5c-3855-496e-846d-7cd3a61ec726 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 722 | 2024.10.09 22:38:34.296304 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 723 | 2024.10.09 22:38:34.296382 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 724 | 2024.10.09 22:38:34.296406 [ 3 ] {} <Debug> HTTP-Session: c9501aa6-4c28-4434-823b-336e0a52efc8 Authenticating user 'default' from [::1]:45919 | ||
| 725 | 2024.10.09 22:38:34.296432 [ 3 ] {} <Debug> HTTP-Session: c9501aa6-4c28-4434-823b-336e0a52efc8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 726 | 2024.10.09 22:38:34.296446 [ 3 ] {} <Debug> HTTP-Session: c9501aa6-4c28-4434-823b-336e0a52efc8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 727 | 2024.10.09 22:38:34.296494 [ 3 ] {} <Trace> HTTP-Session: c9501aa6-4c28-4434-823b-336e0a52efc8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 728 | 2024.10.09 22:38:34.296835 [ 3 ] {48f49b8c-1b63-40eb-ad4a-f608176b23ea} <Debug> executeQuery: (from [::1]:45919) 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:38:34.296910 [ 3 ] {48f49b8c-1b63-40eb-ad4a-f608176b23ea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 730 | 2024.10.09 22:38:34.303202 [ 3 ] {48f49b8c-1b63-40eb-ad4a-f608176b23ea} <Debug> oximeter.fields_ipaddr (8212cd7f-ef32-41f6-8019-da23e2f14e35): Loading data parts | ||
| 731 | 2024.10.09 22:38:34.304983 [ 3 ] {48f49b8c-1b63-40eb-ad4a-f608176b23ea} <Debug> oximeter.fields_ipaddr (8212cd7f-ef32-41f6-8019-da23e2f14e35): There are no data parts | ||
| 732 | 2024.10.09 22:38:34.306946 [ 3 ] {48f49b8c-1b63-40eb-ad4a-f608176b23ea} <Debug> DynamicQueryHandler: Done processing query | ||
| 733 | 2024.10.09 22:38:34.306981 [ 3 ] {} <Debug> HTTP-Session: c9501aa6-4c28-4434-823b-336e0a52efc8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2024.10.09 22:38:34.308544 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 735 | 2024.10.09 22:38:34.308620 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 736 | 2024.10.09 22:38:34.308646 [ 3 ] {} <Debug> HTTP-Session: 73f97703-4b5b-4f94-b68a-d8dbe84d9287 Authenticating user 'default' from [::1]:45919 | ||
| 737 | 2024.10.09 22:38:34.308670 [ 3 ] {} <Debug> HTTP-Session: 73f97703-4b5b-4f94-b68a-d8dbe84d9287 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 738 | 2024.10.09 22:38:34.308688 [ 3 ] {} <Debug> HTTP-Session: 73f97703-4b5b-4f94-b68a-d8dbe84d9287 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 739 | 2024.10.09 22:38:34.308738 [ 3 ] {} <Trace> HTTP-Session: 73f97703-4b5b-4f94-b68a-d8dbe84d9287 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 740 | 2024.10.09 22:38:34.309063 [ 3 ] {80154cd4-a39e-4330-816f-ad75bd35cec9} <Debug> executeQuery: (from [::1]:45919) 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:38:34.309134 [ 3 ] {80154cd4-a39e-4330-816f-ad75bd35cec9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 742 | 2024.10.09 22:38:34.312859 [ 3 ] {80154cd4-a39e-4330-816f-ad75bd35cec9} <Debug> oximeter.fields_string (e12a7b55-f1ab-4b2e-85e2-d326c8b333be): Loading data parts | ||
| 743 | 2024.10.09 22:38:34.313128 [ 3 ] {80154cd4-a39e-4330-816f-ad75bd35cec9} <Debug> oximeter.fields_string (e12a7b55-f1ab-4b2e-85e2-d326c8b333be): There are no data parts | ||
| 744 | 2024.10.09 22:38:34.315604 [ 3 ] {80154cd4-a39e-4330-816f-ad75bd35cec9} <Debug> DynamicQueryHandler: Done processing query | ||
| 745 | 2024.10.09 22:38:34.315634 [ 3 ] {} <Debug> HTTP-Session: 73f97703-4b5b-4f94-b68a-d8dbe84d9287 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 746 | 2024.10.09 22:38:34.316278 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 747 | 2024.10.09 22:38:34.316444 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 748 | 2024.10.09 22:38:34.316519 [ 3 ] {} <Debug> HTTP-Session: a7128bfe-c41e-4a18-acec-7370bed490c6 Authenticating user 'default' from [::1]:45919 | ||
| 749 | 2024.10.09 22:38:34.316539 [ 3 ] {} <Debug> HTTP-Session: a7128bfe-c41e-4a18-acec-7370bed490c6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 750 | 2024.10.09 22:38:34.316553 [ 3 ] {} <Debug> HTTP-Session: a7128bfe-c41e-4a18-acec-7370bed490c6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 751 | 2024.10.09 22:38:34.316596 [ 3 ] {} <Trace> HTTP-Session: a7128bfe-c41e-4a18-acec-7370bed490c6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 752 | 2024.10.09 22:38:34.316843 [ 3 ] {d793dc56-eaa1-460f-a5ed-47ba5617796d} <Debug> executeQuery: (from [::1]:45919) 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) | ||
| 753 | 2024.10.09 22:38:34.316945 [ 3 ] {d793dc56-eaa1-460f-a5ed-47ba5617796d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 754 | 2024.10.09 22:38:34.321250 [ 3 ] {d793dc56-eaa1-460f-a5ed-47ba5617796d} <Debug> oximeter.fields_uuid (365f0bb5-5f28-4903-8ed4-f5b0c4e7f42d): Loading data parts | ||
| 755 | 2024.10.09 22:38:34.322577 [ 3 ] {d793dc56-eaa1-460f-a5ed-47ba5617796d} <Debug> oximeter.fields_uuid (365f0bb5-5f28-4903-8ed4-f5b0c4e7f42d): There are no data parts | ||
| 756 | 2024.10.09 22:38:34.326342 [ 3 ] {d793dc56-eaa1-460f-a5ed-47ba5617796d} <Debug> DynamicQueryHandler: Done processing query | ||
| 757 | 2024.10.09 22:38:34.326374 [ 3 ] {} <Debug> HTTP-Session: a7128bfe-c41e-4a18-acec-7370bed490c6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 758 | 2024.10.09 22:38:34.328534 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 759 | 2024.10.09 22:38:34.328608 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 760 | 2024.10.09 22:38:34.328633 [ 3 ] {} <Debug> HTTP-Session: dafb3275-cefb-46ce-bab1-40978bb90b8b Authenticating user 'default' from [::1]:45919 | ||
| 761 | 2024.10.09 22:38:34.328731 [ 3 ] {} <Debug> HTTP-Session: dafb3275-cefb-46ce-bab1-40978bb90b8b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 762 | 2024.10.09 22:38:34.328757 [ 3 ] {} <Debug> HTTP-Session: dafb3275-cefb-46ce-bab1-40978bb90b8b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 763 | 2024.10.09 22:38:34.328802 [ 3 ] {} <Trace> HTTP-Session: dafb3275-cefb-46ce-bab1-40978bb90b8b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 764 | 2024.10.09 22:38:34.329204 [ 3 ] {2a3de66f-0b66-4f52-922d-397d612f955c} <Debug> executeQuery: (from [::1]:45919) /* The timeseries schema table stores the extracted schema for the samples | ||
| 765 | * oximeter collects. | ||
| 766 | */ | ||
| 767 | 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) | ||
| 768 | 2024.10.09 22:38:34.329298 [ 3 ] {2a3de66f-0b66-4f52-922d-397d612f955c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 769 | 2024.10.09 22:38:34.352634 [ 3 ] {2a3de66f-0b66-4f52-922d-397d612f955c} <Debug> oximeter.timeseries_schema (3bc6c8e0-9e8d-417c-a452-ce0ff354e967): Loading data parts | ||
| 770 | 2024.10.09 22:38:34.352973 [ 3 ] {2a3de66f-0b66-4f52-922d-397d612f955c} <Debug> oximeter.timeseries_schema (3bc6c8e0-9e8d-417c-a452-ce0ff354e967): There are no data parts | ||
| 771 | 2024.10.09 22:38:34.361045 [ 3 ] {2a3de66f-0b66-4f52-922d-397d612f955c} <Debug> DynamicQueryHandler: Done processing query | ||
| 772 | 2024.10.09 22:38:34.361084 [ 3 ] {} <Debug> HTTP-Session: dafb3275-cefb-46ce-bab1-40978bb90b8b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 773 | 2024.10.09 22:38:34.365487 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45919, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 774 | 2024.10.09 22:38:34.365592 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 775 | 2024.10.09 22:38:34.365626 [ 3 ] {} <Debug> HTTP-Session: c429f2fe-596f-4d01-85c2-7f4db384eb18 Authenticating user 'default' from [::1]:45919 | ||
| 776 | 2024.10.09 22:38:34.365669 [ 3 ] {} <Debug> HTTP-Session: c429f2fe-596f-4d01-85c2-7f4db384eb18 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 777 | 2024.10.09 22:38:34.365687 [ 3 ] {} <Debug> HTTP-Session: c429f2fe-596f-4d01-85c2-7f4db384eb18 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 778 | 2024.10.09 22:38:34.365744 [ 3 ] {} <Trace> HTTP-Session: c429f2fe-596f-4d01-85c2-7f4db384eb18 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 779 | 2024.10.09 22:38:34.366035 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Debug> executeQuery: (from [::1]:45919) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 780 | 2024.10.09 22:38:34.366255 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 781 | 2024.10.09 22:38:34.368181 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Trace> oximeter.version (509396b0-67e1-4b9b-b537-d350e20ed6c5): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 782 | 2024.10.09 22:38:34.368243 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.28 GiB. | ||
| 783 | 2024.10.09 22:38:34.369205 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 784 | 2024.10.09 22:38:34.369919 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Trace> oximeter.version (509396b0-67e1-4b9b-b537-d350e20ed6c5): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 785 | 2024.10.09 22:38:34.370253 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.004302 sec., 232.4500232450023 rows/sec., 3.63 KiB/sec. | ||
| 786 | 2024.10.09 22:38:34.370521 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Debug> DynamicQueryHandler: Done processing query | ||
| 787 | 2024.10.09 22:38:34.370553 [ 3 ] {a4f1ae43-c0cd-4eed-b28e-49be383b165c} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 788 | 2024.10.09 22:38:34.371567 [ 3 ] {} <Debug> HTTP-Session: c429f2fe-596f-4d01-85c2-7f4db384eb18 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 789 | 2024.10.09 22:38:34.723794 [ 57 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 790 | 2024.10.09 22:38:34.723842 [ 57 ] {} <Debug> DNSResolver: Updated DNS cache | ||