| 1 | 2024.10.09 22:46:09.955625 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 17861 | ||
| 2 | 2024.10.09 22:46:09.955847 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.10.09 22:46:09.955916 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.10.09 22:46:09.968341 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.10.09 22:46:09.974161 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.10.09 22:46:09.974291 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.10.09 22:46:09.974310 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2024.10.09 22:46:09.974387 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_project_deletion_with_snapshot.17828.1-clickhouse-v8crkC/datastore/tmp/ to store temporary data in it | ||
| 9 | 2024.10.09 22:46:09.974994 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.10.09 22:46:09.976413 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.10.09 22:46:09.977119 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 2024.10.09 22:46:09.977720 [ 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:46:09.977789 [ 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:46:09.977873 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.10.09 22:46:09.977988 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.10.09 22:46:09.979889 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.10.09 22:46:09.991856 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.10.09 22:46:09.992515 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2024.10.09 22:46:09.993242 [ 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:46:09.993291 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.10.09 22:46:09.994238 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.10.09 22:46:09.995069 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.10.09 22:46:10.003683 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.10.09 22:46:10.006417 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 2024.10.09 22:46:10.030152 [ 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:46:10.030692 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.10.09 22:46:10.031498 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2024.10.09 22:46:10.032071 [ 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:46:10.043594 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2024.10.09 22:46:10.043639 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_project_deletion_with_snapshot.17828.1-clickhouse-v8crkC/datastore/ | ||
| 31 | 2024.10.09 22:46:10.044375 [ 184 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 32 | 2024.10.09 22:46:10.044494 [ 184 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 33 | 2024.10.09 22:46:10.051836 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 34 | 2024.10.09 22:46:10.051902 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000246568 sec | ||
| 35 | 2024.10.09 22:46:10.051968 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 36 | 2024.10.09 22:46:10.051986 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 37 | 2024.10.09 22:46:10.052141 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 38 | 2024.10.09 22:46:10.052206 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 39 | 2024.10.09 22:46:10.052224 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 40 | 2024.10.09 22:46:10.052251 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 41 | 2024.10.09 22:46:10.052268 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 42 | 2024.10.09 22:46:10.052280 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 43 | 2024.10.09 22:46:10.052306 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 44 | 2024.10.09 22:46:10.052359 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 45 | 2024.10.09 22:46:10.052385 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 46 | 2024.10.09 22:46:10.052430 [ 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:46:10.052445 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 48 | 2024.10.09 22:46:10.052503 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 49 | 2024.10.09 22:46:10.052519 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 50 | 2024.10.09 22:46:10.052550 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2024.10.09 22:46:10.052567 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 2024.10.09 22:46:10.052580 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 53 | 2024.10.09 22:46:10.052608 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 54 | 2024.10.09 22:46:10.052626 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 55 | 2024.10.09 22:46:10.107968 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.10.09 22:46:10.110790 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.10.09 22:46:10.110831 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.1296e-05 sec | ||
| 58 | 2024.10.09 22:46:10.110846 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.10.09 22:46:10.112407 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.10.09 22:46:10.112448 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2024.10.09 22:46:10.112657 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_project_deletion_with_snapshot.17828.1-clickhouse-v8crkC/datastore/user_defined/ | ||
| 62 | 2024.10.09 22:46:10.112726 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.10.09 22:46:10.112743 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2024.10.09 22:46:10.112755 [ 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:46:10.112902 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.10.09 22:46:10.118159 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 55547 | ||
| 67 | 2024.10.09 22:46:10.118408 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44514 | ||
| 68 | 2024.10.09 22:46:10.119803 [ 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:46:10.119945 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 56503 | ||
| 70 | 2024.10.09 22:46:10.120031 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 49770 | ||
| 71 | 2024.10.09 22:46:10.120123 [ 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:46:10.120169 [ 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:46:10.120438 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 16.08 MiB, free memory in arenas 0.00 B, will set to 139.71 MiB (RSS), difference: 129.81 MiB | ||
| 74 | 2024.10.09 22:46:10.120859 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.2208e-05 sec. | ||
| 75 | 2024.10.09 22:46:10.121286 [ 1 ] {} <Information> Application: Listening for http://[::1]:55547 | ||
| 76 | 2024.10.09 22:46:10.121360 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:44514 | ||
| 77 | 2024.10.09 22:46:10.121425 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:56503 | ||
| 78 | 2024.10.09 22:46:10.121491 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:49770 | ||
| 79 | 2024.10.09 22:46:10.121510 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 80 | 2024.10.09 22:46:21.668299 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 81 | 2024.10.09 22:46:21.668551 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 82 | 2024.10.09 22:46:21.668592 [ 3 ] {} <Debug> HTTP-Session: 015e410e-ae04-489e-bb23-1eb3fbfd5b09 Authenticating user 'default' from [::1]:54963 | ||
| 83 | 2024.10.09 22:46:21.668619 [ 3 ] {} <Debug> HTTP-Session: 015e410e-ae04-489e-bb23-1eb3fbfd5b09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 84 | 2024.10.09 22:46:21.668632 [ 3 ] {} <Debug> HTTP-Session: 015e410e-ae04-489e-bb23-1eb3fbfd5b09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 85 | 2024.10.09 22:46:21.668728 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 86 | 2024.10.09 22:46:21.668769 [ 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:46:21.668791 [ 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:46:21.668847 [ 3 ] {} <Trace> HTTP-Session: 015e410e-ae04-489e-bb23-1eb3fbfd5b09 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 89 | 2024.10.09 22:46:21.669476 [ 3 ] {d997875a-9711-47bb-bd75-1eb0182daac5} <Debug> executeQuery: (from [::1]:54963) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 90 | 2024.10.09 22:46:21.678056 [ 3 ] {d997875a-9711-47bb-bd75-1eb0182daac5} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:54963) (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:46:21.678311 [ 3 ] {d997875a-9711-47bb-bd75-1eb0182daac5} <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:46:21.678629 [ 3 ] {} <Debug> HTTP-Session: 015e410e-ae04-489e-bb23-1eb3fbfd5b09 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 141 | 2024.10.09 22:46:21.687706 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 142 | 2024.10.09 22:46:21.687834 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 143 | 2024.10.09 22:46:21.687864 [ 3 ] {} <Debug> HTTP-Session: cfda1635-1729-4a28-a781-9524a7dbf82a Authenticating user 'default' from [::1]:54963 | ||
| 144 | 2024.10.09 22:46:21.687918 [ 3 ] {} <Debug> HTTP-Session: cfda1635-1729-4a28-a781-9524a7dbf82a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 145 | 2024.10.09 22:46:21.687933 [ 3 ] {} <Debug> HTTP-Session: cfda1635-1729-4a28-a781-9524a7dbf82a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 146 | 2024.10.09 22:46:21.687993 [ 3 ] {} <Trace> HTTP-Session: cfda1635-1729-4a28-a781-9524a7dbf82a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 147 | 2024.10.09 22:46:21.688279 [ 3 ] {959d9339-bdd6-4702-a591-cd141fc5cf73} <Debug> executeQuery: (from [::1]:54963) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 148 | 2024.10.09 22:46:21.688709 [ 3 ] {959d9339-bdd6-4702-a591-cd141fc5cf73} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:54963) (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:46:21.688895 [ 3 ] {959d9339-bdd6-4702-a591-cd141fc5cf73} <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:46:21.689120 [ 3 ] {} <Debug> HTTP-Session: cfda1635-1729-4a28-a781-9524a7dbf82a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 199 | 2024.10.09 22:46:21.690660 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 200 | 2024.10.09 22:46:21.690736 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 201 | 2024.10.09 22:46:21.690762 [ 3 ] {} <Debug> HTTP-Session: 1f09b6ad-b1f6-40c8-9f9d-8858ebd9b3d1 Authenticating user 'default' from [::1]:54963 | ||
| 202 | 2024.10.09 22:46:21.690799 [ 3 ] {} <Debug> HTTP-Session: 1f09b6ad-b1f6-40c8-9f9d-8858ebd9b3d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 203 | 2024.10.09 22:46:21.690815 [ 3 ] {} <Debug> HTTP-Session: 1f09b6ad-b1f6-40c8-9f9d-8858ebd9b3d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 204 | 2024.10.09 22:46:21.690855 [ 3 ] {} <Trace> HTTP-Session: 1f09b6ad-b1f6-40c8-9f9d-8858ebd9b3d1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 205 | 2024.10.09 22:46:21.691077 [ 3 ] {fee04567-f688-40e2-b52f-483fa9111405} <Debug> executeQuery: (from [::1]:54963) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 206 | 2024.10.09 22:46:21.691305 [ 3 ] {fee04567-f688-40e2-b52f-483fa9111405} <Debug> DynamicQueryHandler: Done processing query | ||
| 207 | 2024.10.09 22:46:21.691329 [ 3 ] {} <Debug> HTTP-Session: 1f09b6ad-b1f6-40c8-9f9d-8858ebd9b3d1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 208 | 2024.10.09 22:46:21.706517 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 209 | 2024.10.09 22:46:21.706641 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 210 | 2024.10.09 22:46:21.706667 [ 3 ] {} <Debug> HTTP-Session: e9a4fba9-5d20-484e-8d4e-cdc029e0e16b Authenticating user 'default' from [::1]:54963 | ||
| 211 | 2024.10.09 22:46:21.706706 [ 3 ] {} <Debug> HTTP-Session: e9a4fba9-5d20-484e-8d4e-cdc029e0e16b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 212 | 2024.10.09 22:46:21.706739 [ 3 ] {} <Debug> HTTP-Session: e9a4fba9-5d20-484e-8d4e-cdc029e0e16b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 213 | 2024.10.09 22:46:21.706800 [ 3 ] {} <Trace> HTTP-Session: e9a4fba9-5d20-484e-8d4e-cdc029e0e16b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 214 | 2024.10.09 22:46:21.707020 [ 3 ] {71ec12fe-5db7-4e3d-bdc0-c5c1db3537c4} <Debug> executeQuery: (from [::1]:54963) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 215 | 2024.10.09 22:46:21.707105 [ 3 ] {71ec12fe-5db7-4e3d-bdc0-c5c1db3537c4} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 216 | 2024.10.09 22:46:21.708707 [ 3 ] {71ec12fe-5db7-4e3d-bdc0-c5c1db3537c4} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 217 | 2024.10.09 22:46:21.708768 [ 3 ] {71ec12fe-5db7-4e3d-bdc0-c5c1db3537c4} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.9035e-05 sec | ||
| 218 | 2024.10.09 22:46:21.708786 [ 3 ] {71ec12fe-5db7-4e3d-bdc0-c5c1db3537c4} <Trace> ReferentialDeps: No tables | ||
| 219 | 2024.10.09 22:46:21.708799 [ 3 ] {71ec12fe-5db7-4e3d-bdc0-c5c1db3537c4} <Trace> LoadingDeps: No tables | ||
| 220 | 2024.10.09 22:46:21.708879 [ 3 ] {71ec12fe-5db7-4e3d-bdc0-c5c1db3537c4} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 221 | 2024.10.09 22:46:21.709088 [ 3 ] {71ec12fe-5db7-4e3d-bdc0-c5c1db3537c4} <Debug> DynamicQueryHandler: Done processing query | ||
| 222 | 2024.10.09 22:46:21.709116 [ 3 ] {} <Debug> HTTP-Session: e9a4fba9-5d20-484e-8d4e-cdc029e0e16b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 223 | 2024.10.09 22:46:21.713018 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 224 | 2024.10.09 22:46:21.713143 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 225 | 2024.10.09 22:46:21.713173 [ 3 ] {} <Debug> HTTP-Session: 4b448568-b40f-4c27-af17-5f0c7202be0c Authenticating user 'default' from [::1]:54963 | ||
| 226 | 2024.10.09 22:46:21.713198 [ 3 ] {} <Debug> HTTP-Session: 4b448568-b40f-4c27-af17-5f0c7202be0c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 227 | 2024.10.09 22:46:21.713221 [ 3 ] {} <Debug> HTTP-Session: 4b448568-b40f-4c27-af17-5f0c7202be0c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 228 | 2024.10.09 22:46:21.713295 [ 3 ] {} <Trace> HTTP-Session: 4b448568-b40f-4c27-af17-5f0c7202be0c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 229 | 2024.10.09 22:46:21.713586 [ 3 ] {f38448a0-b6d0-46da-a0e6-f9e7babe687d} <Debug> executeQuery: (from [::1]:54963) /* 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:46:21.713672 [ 3 ] {f38448a0-b6d0-46da-a0e6-f9e7babe687d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 232 | 2024.10.09 22:46:21.715428 [ 3 ] {f38448a0-b6d0-46da-a0e6-f9e7babe687d} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 233 | 2024.10.09 22:46:21.716719 [ 3 ] {f38448a0-b6d0-46da-a0e6-f9e7babe687d} <Debug> oximeter.version (1d9cffa9-8721-46e3-a24a-60c37185e046): Loading data parts | ||
| 234 | 2024.10.09 22:46:21.717334 [ 3 ] {f38448a0-b6d0-46da-a0e6-f9e7babe687d} <Debug> oximeter.version (1d9cffa9-8721-46e3-a24a-60c37185e046): There are no data parts | ||
| 235 | 2024.10.09 22:46:21.719129 [ 3 ] {f38448a0-b6d0-46da-a0e6-f9e7babe687d} <Debug> DynamicQueryHandler: Done processing query | ||
| 236 | 2024.10.09 22:46:21.719194 [ 3 ] {} <Debug> HTTP-Session: 4b448568-b40f-4c27-af17-5f0c7202be0c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 237 | 2024.10.09 22:46:21.724423 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 238 | 2024.10.09 22:46:21.724534 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 239 | 2024.10.09 22:46:21.724574 [ 3 ] {} <Debug> HTTP-Session: f5c38934-3eae-41b9-92d9-4e850da4e2dd Authenticating user 'default' from [::1]:54963 | ||
| 240 | 2024.10.09 22:46:21.724601 [ 3 ] {} <Debug> HTTP-Session: f5c38934-3eae-41b9-92d9-4e850da4e2dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 241 | 2024.10.09 22:46:21.724614 [ 3 ] {} <Debug> HTTP-Session: f5c38934-3eae-41b9-92d9-4e850da4e2dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 242 | 2024.10.09 22:46:21.724672 [ 3 ] {} <Trace> HTTP-Session: f5c38934-3eae-41b9-92d9-4e850da4e2dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 243 | 2024.10.09 22:46:21.725026 [ 3 ] {a0b59105-10ae-41b4-b26c-5e88611e2032} <Debug> executeQuery: (from [::1]:54963) /* 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:46:21.725117 [ 3 ] {a0b59105-10ae-41b4-b26c-5e88611e2032} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 255 | 2024.10.09 22:46:21.727669 [ 3 ] {a0b59105-10ae-41b4-b26c-5e88611e2032} <Debug> oximeter.measurements_bool (ab7176a7-26dc-4f91-a3f5-ebe81520384a): Loading data parts | ||
| 256 | 2024.10.09 22:46:21.728032 [ 3 ] {a0b59105-10ae-41b4-b26c-5e88611e2032} <Debug> oximeter.measurements_bool (ab7176a7-26dc-4f91-a3f5-ebe81520384a): There are no data parts | ||
| 257 | 2024.10.09 22:46:21.729749 [ 3 ] {a0b59105-10ae-41b4-b26c-5e88611e2032} <Debug> DynamicQueryHandler: Done processing query | ||
| 258 | 2024.10.09 22:46:21.729777 [ 3 ] {} <Debug> HTTP-Session: f5c38934-3eae-41b9-92d9-4e850da4e2dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 259 | 2024.10.09 22:46:21.733793 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 260 | 2024.10.09 22:46:21.733896 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 261 | 2024.10.09 22:46:21.733919 [ 3 ] {} <Debug> HTTP-Session: 89377aa2-f421-474e-a69d-09391c9d0749 Authenticating user 'default' from [::1]:54963 | ||
| 262 | 2024.10.09 22:46:21.733944 [ 3 ] {} <Debug> HTTP-Session: 89377aa2-f421-474e-a69d-09391c9d0749 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 263 | 2024.10.09 22:46:21.733963 [ 3 ] {} <Debug> HTTP-Session: 89377aa2-f421-474e-a69d-09391c9d0749 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 264 | 2024.10.09 22:46:21.734012 [ 3 ] {} <Trace> HTTP-Session: 89377aa2-f421-474e-a69d-09391c9d0749 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 265 | 2024.10.09 22:46:21.734327 [ 3 ] {f2666b68-4afb-4620-a116-934329197f57} <Debug> executeQuery: (from [::1]:54963) 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:46:21.734403 [ 3 ] {f2666b68-4afb-4620-a116-934329197f57} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 267 | 2024.10.09 22:46:21.736753 [ 3 ] {f2666b68-4afb-4620-a116-934329197f57} <Debug> oximeter.measurements_i8 (b6c51b45-089c-4acc-9068-d7a486910fb1): Loading data parts | ||
| 268 | 2024.10.09 22:46:21.737144 [ 3 ] {f2666b68-4afb-4620-a116-934329197f57} <Debug> oximeter.measurements_i8 (b6c51b45-089c-4acc-9068-d7a486910fb1): There are no data parts | ||
| 269 | 2024.10.09 22:46:21.742864 [ 3 ] {f2666b68-4afb-4620-a116-934329197f57} <Debug> DynamicQueryHandler: Done processing query | ||
| 270 | 2024.10.09 22:46:21.742902 [ 3 ] {} <Debug> HTTP-Session: 89377aa2-f421-474e-a69d-09391c9d0749 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2024.10.09 22:46:21.743858 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 272 | 2024.10.09 22:46:21.743943 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 273 | 2024.10.09 22:46:21.743974 [ 3 ] {} <Debug> HTTP-Session: e4fec7ab-e9ce-446f-87af-3a679ff3f951 Authenticating user 'default' from [::1]:54963 | ||
| 274 | 2024.10.09 22:46:21.743999 [ 3 ] {} <Debug> HTTP-Session: e4fec7ab-e9ce-446f-87af-3a679ff3f951 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2024.10.09 22:46:21.744012 [ 3 ] {} <Debug> HTTP-Session: e4fec7ab-e9ce-446f-87af-3a679ff3f951 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 276 | 2024.10.09 22:46:21.744079 [ 3 ] {} <Trace> HTTP-Session: e4fec7ab-e9ce-446f-87af-3a679ff3f951 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 277 | 2024.10.09 22:46:21.744427 [ 3 ] {fe83066d-a091-48aa-b7ee-d063dfc15d04} <Debug> executeQuery: (from [::1]:54963) 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:46:21.744510 [ 3 ] {fe83066d-a091-48aa-b7ee-d063dfc15d04} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 279 | 2024.10.09 22:46:21.746832 [ 3 ] {fe83066d-a091-48aa-b7ee-d063dfc15d04} <Debug> oximeter.measurements_u8 (89b2d03d-fff8-44f8-86a2-4e8b70602655): Loading data parts | ||
| 280 | 2024.10.09 22:46:21.747152 [ 3 ] {fe83066d-a091-48aa-b7ee-d063dfc15d04} <Debug> oximeter.measurements_u8 (89b2d03d-fff8-44f8-86a2-4e8b70602655): There are no data parts | ||
| 281 | 2024.10.09 22:46:21.748893 [ 3 ] {fe83066d-a091-48aa-b7ee-d063dfc15d04} <Debug> DynamicQueryHandler: Done processing query | ||
| 282 | 2024.10.09 22:46:21.748919 [ 3 ] {} <Debug> HTTP-Session: e4fec7ab-e9ce-446f-87af-3a679ff3f951 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.10.09 22:46:21.749591 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 284 | 2024.10.09 22:46:21.749671 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 285 | 2024.10.09 22:46:21.749693 [ 3 ] {} <Debug> HTTP-Session: 896abd77-fcaa-4b67-8511-f385f9f4908d Authenticating user 'default' from [::1]:54963 | ||
| 286 | 2024.10.09 22:46:21.749715 [ 3 ] {} <Debug> HTTP-Session: 896abd77-fcaa-4b67-8511-f385f9f4908d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 287 | 2024.10.09 22:46:21.749734 [ 3 ] {} <Debug> HTTP-Session: 896abd77-fcaa-4b67-8511-f385f9f4908d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2024.10.09 22:46:21.749778 [ 3 ] {} <Trace> HTTP-Session: 896abd77-fcaa-4b67-8511-f385f9f4908d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 289 | 2024.10.09 22:46:21.750048 [ 3 ] {c2e4c19e-2803-4dce-ad3f-7156b3076582} <Debug> executeQuery: (from [::1]:54963) 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:46:21.750118 [ 3 ] {c2e4c19e-2803-4dce-ad3f-7156b3076582} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 291 | 2024.10.09 22:46:21.752377 [ 3 ] {c2e4c19e-2803-4dce-ad3f-7156b3076582} <Debug> oximeter.measurements_i16 (6870088a-42cc-4432-8f27-cf9b6d55e0f1): Loading data parts | ||
| 292 | 2024.10.09 22:46:21.752713 [ 3 ] {c2e4c19e-2803-4dce-ad3f-7156b3076582} <Debug> oximeter.measurements_i16 (6870088a-42cc-4432-8f27-cf9b6d55e0f1): There are no data parts | ||
| 293 | 2024.10.09 22:46:21.754367 [ 3 ] {c2e4c19e-2803-4dce-ad3f-7156b3076582} <Debug> DynamicQueryHandler: Done processing query | ||
| 294 | 2024.10.09 22:46:21.754392 [ 3 ] {} <Debug> HTTP-Session: 896abd77-fcaa-4b67-8511-f385f9f4908d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.10.09 22:46:21.755113 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 296 | 2024.10.09 22:46:21.755179 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 297 | 2024.10.09 22:46:21.755200 [ 3 ] {} <Debug> HTTP-Session: e271dc5a-867f-4e0c-8df2-6a42a5f83c83 Authenticating user 'default' from [::1]:54963 | ||
| 298 | 2024.10.09 22:46:21.755242 [ 3 ] {} <Debug> HTTP-Session: e271dc5a-867f-4e0c-8df2-6a42a5f83c83 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 299 | 2024.10.09 22:46:21.755255 [ 3 ] {} <Debug> HTTP-Session: e271dc5a-867f-4e0c-8df2-6a42a5f83c83 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 300 | 2024.10.09 22:46:21.755301 [ 3 ] {} <Trace> HTTP-Session: e271dc5a-867f-4e0c-8df2-6a42a5f83c83 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 301 | 2024.10.09 22:46:21.755601 [ 3 ] {ff530004-c07c-47ac-b793-d7c74f310275} <Debug> executeQuery: (from [::1]:54963) 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:46:21.755692 [ 3 ] {ff530004-c07c-47ac-b793-d7c74f310275} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 303 | 2024.10.09 22:46:21.757884 [ 3 ] {ff530004-c07c-47ac-b793-d7c74f310275} <Debug> oximeter.measurements_u16 (a5d04dd9-79ee-4779-ba1b-b0cd2bfc64d8): Loading data parts | ||
| 304 | 2024.10.09 22:46:21.758176 [ 3 ] {ff530004-c07c-47ac-b793-d7c74f310275} <Debug> oximeter.measurements_u16 (a5d04dd9-79ee-4779-ba1b-b0cd2bfc64d8): There are no data parts | ||
| 305 | 2024.10.09 22:46:21.759932 [ 3 ] {ff530004-c07c-47ac-b793-d7c74f310275} <Debug> DynamicQueryHandler: Done processing query | ||
| 306 | 2024.10.09 22:46:21.759969 [ 3 ] {} <Debug> HTTP-Session: e271dc5a-867f-4e0c-8df2-6a42a5f83c83 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.10.09 22:46:21.761159 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 308 | 2024.10.09 22:46:21.761230 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 309 | 2024.10.09 22:46:21.761260 [ 3 ] {} <Debug> HTTP-Session: 06644090-4511-4e18-9092-ec3b04b260cc Authenticating user 'default' from [::1]:54963 | ||
| 310 | 2024.10.09 22:46:21.761283 [ 3 ] {} <Debug> HTTP-Session: 06644090-4511-4e18-9092-ec3b04b260cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2024.10.09 22:46:21.761297 [ 3 ] {} <Debug> HTTP-Session: 06644090-4511-4e18-9092-ec3b04b260cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 312 | 2024.10.09 22:46:21.761348 [ 3 ] {} <Trace> HTTP-Session: 06644090-4511-4e18-9092-ec3b04b260cc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 313 | 2024.10.09 22:46:21.761655 [ 3 ] {6312291b-ee6e-4448-b708-e1b37dc1992a} <Debug> executeQuery: (from [::1]:54963) 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:46:21.761766 [ 3 ] {6312291b-ee6e-4448-b708-e1b37dc1992a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 315 | 2024.10.09 22:46:21.764030 [ 3 ] {6312291b-ee6e-4448-b708-e1b37dc1992a} <Debug> oximeter.measurements_i32 (6c936b45-0e26-421e-8746-f177f8139d92): Loading data parts | ||
| 316 | 2024.10.09 22:46:21.764373 [ 3 ] {6312291b-ee6e-4448-b708-e1b37dc1992a} <Debug> oximeter.measurements_i32 (6c936b45-0e26-421e-8746-f177f8139d92): There are no data parts | ||
| 317 | 2024.10.09 22:46:21.766114 [ 3 ] {6312291b-ee6e-4448-b708-e1b37dc1992a} <Debug> DynamicQueryHandler: Done processing query | ||
| 318 | 2024.10.09 22:46:21.766140 [ 3 ] {} <Debug> HTTP-Session: 06644090-4511-4e18-9092-ec3b04b260cc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.10.09 22:46:21.771237 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 320 | 2024.10.09 22:46:21.771365 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 321 | 2024.10.09 22:46:21.771390 [ 3 ] {} <Debug> HTTP-Session: 1f78b856-01a5-4109-b20c-29c8e376aebd Authenticating user 'default' from [::1]:54963 | ||
| 322 | 2024.10.09 22:46:21.771415 [ 3 ] {} <Debug> HTTP-Session: 1f78b856-01a5-4109-b20c-29c8e376aebd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 323 | 2024.10.09 22:46:21.771442 [ 3 ] {} <Debug> HTTP-Session: 1f78b856-01a5-4109-b20c-29c8e376aebd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 324 | 2024.10.09 22:46:21.771494 [ 3 ] {} <Trace> HTTP-Session: 1f78b856-01a5-4109-b20c-29c8e376aebd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 325 | 2024.10.09 22:46:21.771831 [ 3 ] {84b086fe-ddd0-4611-8768-af3cf1512b68} <Debug> executeQuery: (from [::1]:54963) 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:46:21.771902 [ 3 ] {84b086fe-ddd0-4611-8768-af3cf1512b68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 327 | 2024.10.09 22:46:21.776053 [ 3 ] {84b086fe-ddd0-4611-8768-af3cf1512b68} <Debug> oximeter.measurements_u32 (1bbab389-321e-4706-89b2-1897bd2b902c): Loading data parts | ||
| 328 | 2024.10.09 22:46:21.776434 [ 3 ] {84b086fe-ddd0-4611-8768-af3cf1512b68} <Debug> oximeter.measurements_u32 (1bbab389-321e-4706-89b2-1897bd2b902c): There are no data parts | ||
| 329 | 2024.10.09 22:46:21.779300 [ 3 ] {84b086fe-ddd0-4611-8768-af3cf1512b68} <Debug> DynamicQueryHandler: Done processing query | ||
| 330 | 2024.10.09 22:46:21.779335 [ 3 ] {} <Debug> HTTP-Session: 1f78b856-01a5-4109-b20c-29c8e376aebd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 331 | 2024.10.09 22:46:21.780474 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 332 | 2024.10.09 22:46:21.780542 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 333 | 2024.10.09 22:46:21.780572 [ 3 ] {} <Debug> HTTP-Session: 0a793232-928c-4e64-83db-cfa7a87f8c5d Authenticating user 'default' from [::1]:54963 | ||
| 334 | 2024.10.09 22:46:21.780593 [ 3 ] {} <Debug> HTTP-Session: 0a793232-928c-4e64-83db-cfa7a87f8c5d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 335 | 2024.10.09 22:46:21.780665 [ 3 ] {} <Debug> HTTP-Session: 0a793232-928c-4e64-83db-cfa7a87f8c5d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 336 | 2024.10.09 22:46:21.780725 [ 3 ] {} <Trace> HTTP-Session: 0a793232-928c-4e64-83db-cfa7a87f8c5d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 337 | 2024.10.09 22:46:21.781045 [ 3 ] {bd32d74a-c900-4a9e-8e9b-4a22f931bfd6} <Debug> executeQuery: (from [::1]:54963) 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:46:21.781134 [ 3 ] {bd32d74a-c900-4a9e-8e9b-4a22f931bfd6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 339 | 2024.10.09 22:46:21.783973 [ 3 ] {bd32d74a-c900-4a9e-8e9b-4a22f931bfd6} <Debug> oximeter.measurements_i64 (f5f3e10b-8071-4f41-994d-0b89b6a0d81a): Loading data parts | ||
| 340 | 2024.10.09 22:46:21.784324 [ 3 ] {bd32d74a-c900-4a9e-8e9b-4a22f931bfd6} <Debug> oximeter.measurements_i64 (f5f3e10b-8071-4f41-994d-0b89b6a0d81a): There are no data parts | ||
| 341 | 2024.10.09 22:46:21.786553 [ 3 ] {bd32d74a-c900-4a9e-8e9b-4a22f931bfd6} <Debug> DynamicQueryHandler: Done processing query | ||
| 342 | 2024.10.09 22:46:21.786580 [ 3 ] {} <Debug> HTTP-Session: 0a793232-928c-4e64-83db-cfa7a87f8c5d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2024.10.09 22:46:21.789572 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 344 | 2024.10.09 22:46:21.789667 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 345 | 2024.10.09 22:46:21.789688 [ 3 ] {} <Debug> HTTP-Session: 8146011d-a5de-4ebd-87d3-bc5d1fba273d Authenticating user 'default' from [::1]:54963 | ||
| 346 | 2024.10.09 22:46:21.789708 [ 3 ] {} <Debug> HTTP-Session: 8146011d-a5de-4ebd-87d3-bc5d1fba273d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 347 | 2024.10.09 22:46:21.789728 [ 3 ] {} <Debug> HTTP-Session: 8146011d-a5de-4ebd-87d3-bc5d1fba273d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 348 | 2024.10.09 22:46:21.789768 [ 3 ] {} <Trace> HTTP-Session: 8146011d-a5de-4ebd-87d3-bc5d1fba273d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 349 | 2024.10.09 22:46:21.790037 [ 3 ] {a7d11a02-2420-42a8-8a88-ad95f8d1ff5e} <Debug> executeQuery: (from [::1]:54963) 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:46:21.790105 [ 3 ] {a7d11a02-2420-42a8-8a88-ad95f8d1ff5e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 351 | 2024.10.09 22:46:21.793182 [ 3 ] {a7d11a02-2420-42a8-8a88-ad95f8d1ff5e} <Debug> oximeter.measurements_u64 (a3c2600e-4cc7-4773-8050-dc3b28478347): Loading data parts | ||
| 352 | 2024.10.09 22:46:21.793510 [ 3 ] {a7d11a02-2420-42a8-8a88-ad95f8d1ff5e} <Debug> oximeter.measurements_u64 (a3c2600e-4cc7-4773-8050-dc3b28478347): There are no data parts | ||
| 353 | 2024.10.09 22:46:21.795689 [ 3 ] {a7d11a02-2420-42a8-8a88-ad95f8d1ff5e} <Debug> DynamicQueryHandler: Done processing query | ||
| 354 | 2024.10.09 22:46:21.795713 [ 3 ] {} <Debug> HTTP-Session: 8146011d-a5de-4ebd-87d3-bc5d1fba273d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 355 | 2024.10.09 22:46:21.938942 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 356 | 2024.10.09 22:46:21.939084 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 357 | 2024.10.09 22:46:21.939119 [ 3 ] {} <Debug> HTTP-Session: b15be612-d577-44ff-ad8e-66cbf64b46f7 Authenticating user 'default' from [::1]:54963 | ||
| 358 | 2024.10.09 22:46:21.939211 [ 3 ] {} <Debug> HTTP-Session: b15be612-d577-44ff-ad8e-66cbf64b46f7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 359 | 2024.10.09 22:46:21.939229 [ 3 ] {} <Debug> HTTP-Session: b15be612-d577-44ff-ad8e-66cbf64b46f7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 360 | 2024.10.09 22:46:21.939294 [ 3 ] {} <Trace> HTTP-Session: b15be612-d577-44ff-ad8e-66cbf64b46f7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 361 | 2024.10.09 22:46:21.939712 [ 3 ] {81ecec8c-e354-4067-b82e-f675a0e1e790} <Debug> executeQuery: (from [::1]:54963) 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:46:21.939818 [ 3 ] {81ecec8c-e354-4067-b82e-f675a0e1e790} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 363 | 2024.10.09 22:46:21.942271 [ 3 ] {81ecec8c-e354-4067-b82e-f675a0e1e790} <Debug> oximeter.measurements_f32 (eacc0fa4-0999-43b2-9d7b-05af190ba618): Loading data parts | ||
| 364 | 2024.10.09 22:46:21.942658 [ 3 ] {81ecec8c-e354-4067-b82e-f675a0e1e790} <Debug> oximeter.measurements_f32 (eacc0fa4-0999-43b2-9d7b-05af190ba618): There are no data parts | ||
| 365 | 2024.10.09 22:46:21.944375 [ 3 ] {81ecec8c-e354-4067-b82e-f675a0e1e790} <Debug> DynamicQueryHandler: Done processing query | ||
| 366 | 2024.10.09 22:46:21.944415 [ 3 ] {} <Debug> HTTP-Session: b15be612-d577-44ff-ad8e-66cbf64b46f7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 367 | 2024.10.09 22:46:21.946459 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 368 | 2024.10.09 22:46:21.946624 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 369 | 2024.10.09 22:46:21.946665 [ 3 ] {} <Debug> HTTP-Session: 1de49db6-6298-4a83-af34-4a4183f7f4ea Authenticating user 'default' from [::1]:54963 | ||
| 370 | 2024.10.09 22:46:21.946694 [ 3 ] {} <Debug> HTTP-Session: 1de49db6-6298-4a83-af34-4a4183f7f4ea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 371 | 2024.10.09 22:46:21.946733 [ 3 ] {} <Debug> HTTP-Session: 1de49db6-6298-4a83-af34-4a4183f7f4ea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 372 | 2024.10.09 22:46:21.946796 [ 3 ] {} <Trace> HTTP-Session: 1de49db6-6298-4a83-af34-4a4183f7f4ea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 373 | 2024.10.09 22:46:21.947188 [ 3 ] {65666796-e1c9-4f6f-85be-c514454491bb} <Debug> executeQuery: (from [::1]:54963) 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:46:21.947281 [ 3 ] {65666796-e1c9-4f6f-85be-c514454491bb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 375 | 2024.10.09 22:46:21.949748 [ 3 ] {65666796-e1c9-4f6f-85be-c514454491bb} <Debug> oximeter.measurements_f64 (c49f8c0a-f08f-4ddb-8b64-2aca33051ae7): Loading data parts | ||
| 376 | 2024.10.09 22:46:21.950222 [ 3 ] {65666796-e1c9-4f6f-85be-c514454491bb} <Debug> oximeter.measurements_f64 (c49f8c0a-f08f-4ddb-8b64-2aca33051ae7): There are no data parts | ||
| 377 | 2024.10.09 22:46:21.952282 [ 3 ] {65666796-e1c9-4f6f-85be-c514454491bb} <Debug> DynamicQueryHandler: Done processing query | ||
| 378 | 2024.10.09 22:46:21.952322 [ 3 ] {} <Debug> HTTP-Session: 1de49db6-6298-4a83-af34-4a4183f7f4ea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 379 | 2024.10.09 22:46:22.000255 [ 245 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 141.22 MiB, peak 142.23 MiB, free memory in arenas 0.00 B, will set to 146.72 MiB (RSS), difference: 5.51 MiB | ||
| 380 | 2024.10.09 22:46:22.045926 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 381 | 2024.10.09 22:46:22.046057 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 382 | 2024.10.09 22:46:22.046162 [ 3 ] {} <Debug> HTTP-Session: fc2e5547-94dc-4813-89e0-e04fde4317ec Authenticating user 'default' from [::1]:54963 | ||
| 383 | 2024.10.09 22:46:22.046193 [ 3 ] {} <Debug> HTTP-Session: fc2e5547-94dc-4813-89e0-e04fde4317ec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 384 | 2024.10.09 22:46:22.046214 [ 3 ] {} <Debug> HTTP-Session: fc2e5547-94dc-4813-89e0-e04fde4317ec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 385 | 2024.10.09 22:46:22.046294 [ 3 ] {} <Trace> HTTP-Session: fc2e5547-94dc-4813-89e0-e04fde4317ec Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 386 | 2024.10.09 22:46:22.046690 [ 3 ] {fa754c21-5774-4735-8667-7549a7e56c93} <Debug> executeQuery: (from [::1]:54963) 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) | ||
| 387 | 2024.10.09 22:46:22.046785 [ 3 ] {fa754c21-5774-4735-8667-7549a7e56c93} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 388 | 2024.10.09 22:46:22.049499 [ 3 ] {fa754c21-5774-4735-8667-7549a7e56c93} <Debug> oximeter.measurements_string (129cbc22-fcc8-4b7e-84a7-a0f4e0761ffd): Loading data parts | ||
| 389 | 2024.10.09 22:46:22.049873 [ 3 ] {fa754c21-5774-4735-8667-7549a7e56c93} <Debug> oximeter.measurements_string (129cbc22-fcc8-4b7e-84a7-a0f4e0761ffd): There are no data parts | ||
| 390 | 2024.10.09 22:46:22.051932 [ 3 ] {fa754c21-5774-4735-8667-7549a7e56c93} <Debug> DynamicQueryHandler: Done processing query | ||
| 391 | 2024.10.09 22:46:22.051966 [ 3 ] {} <Debug> HTTP-Session: fc2e5547-94dc-4813-89e0-e04fde4317ec Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 392 | 2024.10.09 22:46:22.052712 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 393 | 2024.10.09 22:46:22.053273 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 394 | 2024.10.09 22:46:22.053308 [ 3 ] {} <Debug> HTTP-Session: 6aef0802-504e-49f4-ab4b-76f835b34e07 Authenticating user 'default' from [::1]:54963 | ||
| 395 | 2024.10.09 22:46:22.053338 [ 3 ] {} <Debug> HTTP-Session: 6aef0802-504e-49f4-ab4b-76f835b34e07 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 396 | 2024.10.09 22:46:22.053365 [ 3 ] {} <Debug> HTTP-Session: 6aef0802-504e-49f4-ab4b-76f835b34e07 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 397 | 2024.10.09 22:46:22.053417 [ 3 ] {} <Trace> HTTP-Session: 6aef0802-504e-49f4-ab4b-76f835b34e07 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 398 | 2024.10.09 22:46:22.053858 [ 3 ] {ff2823fb-e383-4282-9fa6-98584df4e703} <Debug> executeQuery: (from [::1]:54963) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 399 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 400 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 401 | * a string isn't palatable for a few reasons. | ||
| 402 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 403 | * details. | ||
| 404 | */ | ||
| 405 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 406 | 2024.10.09 22:46:22.053945 [ 3 ] {ff2823fb-e383-4282-9fa6-98584df4e703} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 407 | 2024.10.09 22:46:22.056399 [ 3 ] {ff2823fb-e383-4282-9fa6-98584df4e703} <Debug> oximeter.measurements_bytes (09e81131-93ba-4ea7-921a-b3c2370b1cf6): Loading data parts | ||
| 408 | 2024.10.09 22:46:22.056722 [ 3 ] {ff2823fb-e383-4282-9fa6-98584df4e703} <Debug> oximeter.measurements_bytes (09e81131-93ba-4ea7-921a-b3c2370b1cf6): There are no data parts | ||
| 409 | 2024.10.09 22:46:22.058451 [ 3 ] {ff2823fb-e383-4282-9fa6-98584df4e703} <Debug> DynamicQueryHandler: Done processing query | ||
| 410 | 2024.10.09 22:46:22.058479 [ 3 ] {} <Debug> HTTP-Session: 6aef0802-504e-49f4-ab4b-76f835b34e07 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 411 | 2024.10.09 22:46:22.079951 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 412 | 2024.10.09 22:46:22.080080 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 413 | 2024.10.09 22:46:22.080107 [ 3 ] {} <Debug> HTTP-Session: d33202fc-b42c-4f5b-ae18-e2b759d7adfe Authenticating user 'default' from [::1]:54963 | ||
| 414 | 2024.10.09 22:46:22.080135 [ 3 ] {} <Debug> HTTP-Session: d33202fc-b42c-4f5b-ae18-e2b759d7adfe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 415 | 2024.10.09 22:46:22.080166 [ 3 ] {} <Debug> HTTP-Session: d33202fc-b42c-4f5b-ae18-e2b759d7adfe Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 416 | 2024.10.09 22:46:22.080213 [ 3 ] {} <Trace> HTTP-Session: d33202fc-b42c-4f5b-ae18-e2b759d7adfe Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 417 | 2024.10.09 22:46:22.080591 [ 3 ] {968ad6f7-1cb5-4247-bba0-af104ac2eb66} <Debug> executeQuery: (from [::1]:54963) 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) | ||
| 418 | 2024.10.09 22:46:22.080664 [ 3 ] {968ad6f7-1cb5-4247-bba0-af104ac2eb66} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 419 | 2024.10.09 22:46:22.083455 [ 3 ] {968ad6f7-1cb5-4247-bba0-af104ac2eb66} <Debug> oximeter.measurements_cumulativei64 (6248cfaa-9374-49f9-a7e1-06b5d81cd4fd): Loading data parts | ||
| 420 | 2024.10.09 22:46:22.083933 [ 3 ] {968ad6f7-1cb5-4247-bba0-af104ac2eb66} <Debug> oximeter.measurements_cumulativei64 (6248cfaa-9374-49f9-a7e1-06b5d81cd4fd): There are no data parts | ||
| 421 | 2024.10.09 22:46:22.098594 [ 3 ] {968ad6f7-1cb5-4247-bba0-af104ac2eb66} <Debug> DynamicQueryHandler: Done processing query | ||
| 422 | 2024.10.09 22:46:22.099137 [ 3 ] {} <Debug> HTTP-Session: d33202fc-b42c-4f5b-ae18-e2b759d7adfe Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 423 | 2024.10.09 22:46:22.101976 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 424 | 2024.10.09 22:46:22.102099 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 425 | 2024.10.09 22:46:22.102130 [ 3 ] {} <Debug> HTTP-Session: 81df710f-c938-4adb-bd6c-6f3f516ebba9 Authenticating user 'default' from [::1]:54963 | ||
| 426 | 2024.10.09 22:46:22.102157 [ 3 ] {} <Debug> HTTP-Session: 81df710f-c938-4adb-bd6c-6f3f516ebba9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 427 | 2024.10.09 22:46:22.102173 [ 3 ] {} <Debug> HTTP-Session: 81df710f-c938-4adb-bd6c-6f3f516ebba9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 428 | 2024.10.09 22:46:22.102241 [ 3 ] {} <Trace> HTTP-Session: 81df710f-c938-4adb-bd6c-6f3f516ebba9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 429 | 2024.10.09 22:46:22.102678 [ 3 ] {e3b17c5e-4090-42b7-b3a2-ff58d2f1d89d} <Debug> executeQuery: (from [::1]:54963) 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) | ||
| 430 | 2024.10.09 22:46:22.102896 [ 3 ] {e3b17c5e-4090-42b7-b3a2-ff58d2f1d89d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 431 | 2024.10.09 22:46:22.105514 [ 3 ] {e3b17c5e-4090-42b7-b3a2-ff58d2f1d89d} <Debug> oximeter.measurements_cumulativeu64 (8ce9b499-4a01-42da-84e8-8cc2adfa0f9b): Loading data parts | ||
| 432 | 2024.10.09 22:46:22.106585 [ 3 ] {e3b17c5e-4090-42b7-b3a2-ff58d2f1d89d} <Debug> oximeter.measurements_cumulativeu64 (8ce9b499-4a01-42da-84e8-8cc2adfa0f9b): There are no data parts | ||
| 433 | 2024.10.09 22:46:22.108320 [ 3 ] {e3b17c5e-4090-42b7-b3a2-ff58d2f1d89d} <Debug> DynamicQueryHandler: Done processing query | ||
| 434 | 2024.10.09 22:46:22.108354 [ 3 ] {} <Debug> HTTP-Session: 81df710f-c938-4adb-bd6c-6f3f516ebba9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 435 | 2024.10.09 22:46:22.109615 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 436 | 2024.10.09 22:46:22.109697 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 437 | 2024.10.09 22:46:22.109724 [ 3 ] {} <Debug> HTTP-Session: 6c1bdd83-ece7-429c-8c32-d7df2a53b485 Authenticating user 'default' from [::1]:54963 | ||
| 438 | 2024.10.09 22:46:22.109765 [ 3 ] {} <Debug> HTTP-Session: 6c1bdd83-ece7-429c-8c32-d7df2a53b485 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 439 | 2024.10.09 22:46:22.109783 [ 3 ] {} <Debug> HTTP-Session: 6c1bdd83-ece7-429c-8c32-d7df2a53b485 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 440 | 2024.10.09 22:46:22.109834 [ 3 ] {} <Trace> HTTP-Session: 6c1bdd83-ece7-429c-8c32-d7df2a53b485 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 441 | 2024.10.09 22:46:22.110190 [ 3 ] {41ca0c2f-14b2-463a-b8e2-08202a907994} <Debug> executeQuery: (from [::1]:54963) 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) | ||
| 442 | 2024.10.09 22:46:22.110280 [ 3 ] {41ca0c2f-14b2-463a-b8e2-08202a907994} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 443 | 2024.10.09 22:46:22.118563 [ 3 ] {41ca0c2f-14b2-463a-b8e2-08202a907994} <Debug> oximeter.measurements_cumulativef32 (42ebef0c-f1bf-4c9b-a817-295c5995bf3e): Loading data parts | ||
| 444 | 2024.10.09 22:46:22.119055 [ 3 ] {41ca0c2f-14b2-463a-b8e2-08202a907994} <Debug> oximeter.measurements_cumulativef32 (42ebef0c-f1bf-4c9b-a817-295c5995bf3e): There are no data parts | ||
| 445 | 2024.10.09 22:46:22.121223 [ 3 ] {41ca0c2f-14b2-463a-b8e2-08202a907994} <Debug> DynamicQueryHandler: Done processing query | ||
| 446 | 2024.10.09 22:46:22.121255 [ 3 ] {} <Debug> HTTP-Session: 6c1bdd83-ece7-429c-8c32-d7df2a53b485 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 447 | 2024.10.09 22:46:22.122187 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 448 | 2024.10.09 22:46:22.122309 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 449 | 2024.10.09 22:46:22.122335 [ 3 ] {} <Debug> HTTP-Session: 58253011-e87c-49fa-ad65-2bf3f150a965 Authenticating user 'default' from [::1]:54963 | ||
| 450 | 2024.10.09 22:46:22.122361 [ 3 ] {} <Debug> HTTP-Session: 58253011-e87c-49fa-ad65-2bf3f150a965 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 451 | 2024.10.09 22:46:22.122386 [ 3 ] {} <Debug> HTTP-Session: 58253011-e87c-49fa-ad65-2bf3f150a965 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 452 | 2024.10.09 22:46:22.122438 [ 3 ] {} <Trace> HTTP-Session: 58253011-e87c-49fa-ad65-2bf3f150a965 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 453 | 2024.10.09 22:46:22.122887 [ 3 ] {7cc9a443-9f1d-4bf5-b503-b311f863b962} <Debug> executeQuery: (from [::1]:54963) 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) | ||
| 454 | 2024.10.09 22:46:22.122974 [ 3 ] {7cc9a443-9f1d-4bf5-b503-b311f863b962} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 455 | 2024.10.09 22:46:22.126588 [ 3 ] {7cc9a443-9f1d-4bf5-b503-b311f863b962} <Debug> oximeter.measurements_cumulativef64 (097684b2-84d7-4338-8a80-76adfefb2c57): Loading data parts | ||
| 456 | 2024.10.09 22:46:22.126860 [ 3 ] {7cc9a443-9f1d-4bf5-b503-b311f863b962} <Debug> oximeter.measurements_cumulativef64 (097684b2-84d7-4338-8a80-76adfefb2c57): There are no data parts | ||
| 457 | 2024.10.09 22:46:22.128811 [ 3 ] {7cc9a443-9f1d-4bf5-b503-b311f863b962} <Debug> DynamicQueryHandler: Done processing query | ||
| 458 | 2024.10.09 22:46:22.128856 [ 3 ] {} <Debug> HTTP-Session: 58253011-e87c-49fa-ad65-2bf3f150a965 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 459 | 2024.10.09 22:46:22.130806 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 460 | 2024.10.09 22:46:22.130888 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 461 | 2024.10.09 22:46:22.130944 [ 3 ] {} <Debug> HTTP-Session: e4e1ec3a-a0ed-4506-b532-38974756c97a Authenticating user 'default' from [::1]:54963 | ||
| 462 | 2024.10.09 22:46:22.130972 [ 3 ] {} <Debug> HTTP-Session: e4e1ec3a-a0ed-4506-b532-38974756c97a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 463 | 2024.10.09 22:46:22.130987 [ 3 ] {} <Debug> HTTP-Session: e4e1ec3a-a0ed-4506-b532-38974756c97a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 464 | 2024.10.09 22:46:22.131049 [ 3 ] {} <Trace> HTTP-Session: e4e1ec3a-a0ed-4506-b532-38974756c97a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 465 | 2024.10.09 22:46:22.131539 [ 3 ] {2aaf20ee-0ef1-4274-aa61-5bc1a381c1da} <Debug> executeQuery: (from [::1]:54963) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 466 | * NOTE: Array types cannot be Nullable, see | ||
| 467 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 468 | * for more details. | ||
| 469 | * | ||
| 470 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 471 | * is unfortunate, and at this point relies on the fact that an | ||
| 472 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 473 | * to figure out another way to represent missing samples here. | ||
| 474 | */ | ||
| 475 | 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) | ||
| 476 | 2024.10.09 22:46:22.131679 [ 3 ] {2aaf20ee-0ef1-4274-aa61-5bc1a381c1da} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 477 | 2024.10.09 22:46:22.134959 [ 3 ] {2aaf20ee-0ef1-4274-aa61-5bc1a381c1da} <Debug> oximeter.measurements_histogrami8 (e4530fb2-1f4a-4276-92af-62859d09f51d): Loading data parts | ||
| 478 | 2024.10.09 22:46:22.135292 [ 3 ] {2aaf20ee-0ef1-4274-aa61-5bc1a381c1da} <Debug> oximeter.measurements_histogrami8 (e4530fb2-1f4a-4276-92af-62859d09f51d): There are no data parts | ||
| 479 | 2024.10.09 22:46:22.138275 [ 3 ] {2aaf20ee-0ef1-4274-aa61-5bc1a381c1da} <Debug> DynamicQueryHandler: Done processing query | ||
| 480 | 2024.10.09 22:46:22.138312 [ 3 ] {} <Debug> HTTP-Session: e4e1ec3a-a0ed-4506-b532-38974756c97a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 481 | 2024.10.09 22:46:22.143864 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 482 | 2024.10.09 22:46:22.144035 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 483 | 2024.10.09 22:46:22.144069 [ 3 ] {} <Debug> HTTP-Session: b5914aa0-5e43-4a09-9d5b-ae6891fc8e5d Authenticating user 'default' from [::1]:54963 | ||
| 484 | 2024.10.09 22:46:22.144098 [ 3 ] {} <Debug> HTTP-Session: b5914aa0-5e43-4a09-9d5b-ae6891fc8e5d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 485 | 2024.10.09 22:46:22.144114 [ 3 ] {} <Debug> HTTP-Session: b5914aa0-5e43-4a09-9d5b-ae6891fc8e5d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 486 | 2024.10.09 22:46:22.144185 [ 3 ] {} <Trace> HTTP-Session: b5914aa0-5e43-4a09-9d5b-ae6891fc8e5d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 487 | 2024.10.09 22:46:22.144654 [ 3 ] {c2b1afb4-869a-4715-a090-42fb35b9ee3b} <Debug> executeQuery: (from [::1]:54963) 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) | ||
| 488 | 2024.10.09 22:46:22.144751 [ 3 ] {c2b1afb4-869a-4715-a090-42fb35b9ee3b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 489 | 2024.10.09 22:46:22.147954 [ 3 ] {c2b1afb4-869a-4715-a090-42fb35b9ee3b} <Debug> oximeter.measurements_histogramu8 (b8cd740e-94e1-474c-85cc-a4411f817812): Loading data parts | ||
| 490 | 2024.10.09 22:46:22.148325 [ 3 ] {c2b1afb4-869a-4715-a090-42fb35b9ee3b} <Debug> oximeter.measurements_histogramu8 (b8cd740e-94e1-474c-85cc-a4411f817812): There are no data parts | ||
| 491 | 2024.10.09 22:46:22.150414 [ 3 ] {c2b1afb4-869a-4715-a090-42fb35b9ee3b} <Debug> DynamicQueryHandler: Done processing query | ||
| 492 | 2024.10.09 22:46:22.150442 [ 3 ] {} <Debug> HTTP-Session: b5914aa0-5e43-4a09-9d5b-ae6891fc8e5d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 493 | 2024.10.09 22:46:22.151738 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 494 | 2024.10.09 22:46:22.151815 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 495 | 2024.10.09 22:46:22.151841 [ 3 ] {} <Debug> HTTP-Session: d596c43d-7c07-4126-afc6-312267915c1a Authenticating user 'default' from [::1]:54963 | ||
| 496 | 2024.10.09 22:46:22.151878 [ 3 ] {} <Debug> HTTP-Session: d596c43d-7c07-4126-afc6-312267915c1a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 497 | 2024.10.09 22:46:22.151895 [ 3 ] {} <Debug> HTTP-Session: d596c43d-7c07-4126-afc6-312267915c1a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 498 | 2024.10.09 22:46:22.151947 [ 3 ] {} <Trace> HTTP-Session: d596c43d-7c07-4126-afc6-312267915c1a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 499 | 2024.10.09 22:46:22.152496 [ 3 ] {f46aa754-1848-423d-83ba-09b495223489} <Debug> executeQuery: (from [::1]:54963) 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) | ||
| 500 | 2024.10.09 22:46:22.152696 [ 3 ] {f46aa754-1848-423d-83ba-09b495223489} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 501 | 2024.10.09 22:46:22.157771 [ 3 ] {f46aa754-1848-423d-83ba-09b495223489} <Debug> oximeter.measurements_histogrami16 (dc61249b-c042-48ba-ae79-4d9cb0281bd7): Loading data parts | ||
| 502 | 2024.10.09 22:46:22.158104 [ 3 ] {f46aa754-1848-423d-83ba-09b495223489} <Debug> oximeter.measurements_histogrami16 (dc61249b-c042-48ba-ae79-4d9cb0281bd7): There are no data parts | ||
| 503 | 2024.10.09 22:46:22.162782 [ 3 ] {f46aa754-1848-423d-83ba-09b495223489} <Debug> DynamicQueryHandler: Done processing query | ||
| 504 | 2024.10.09 22:46:22.163115 [ 3 ] {} <Debug> HTTP-Session: d596c43d-7c07-4126-afc6-312267915c1a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 505 | 2024.10.09 22:46:22.163751 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 506 | 2024.10.09 22:46:22.163833 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 507 | 2024.10.09 22:46:22.163874 [ 3 ] {} <Debug> HTTP-Session: 38be009b-5153-4fc8-ba9e-8cd44d64916b Authenticating user 'default' from [::1]:54963 | ||
| 508 | 2024.10.09 22:46:22.163902 [ 3 ] {} <Debug> HTTP-Session: 38be009b-5153-4fc8-ba9e-8cd44d64916b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 509 | 2024.10.09 22:46:22.163920 [ 3 ] {} <Debug> HTTP-Session: 38be009b-5153-4fc8-ba9e-8cd44d64916b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 510 | 2024.10.09 22:46:22.164005 [ 3 ] {} <Trace> HTTP-Session: 38be009b-5153-4fc8-ba9e-8cd44d64916b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 511 | 2024.10.09 22:46:22.164535 [ 3 ] {f727cfc9-d5a1-4f8a-96b1-054ec5d9cf14} <Debug> executeQuery: (from [::1]:54963) 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) | ||
| 512 | 2024.10.09 22:46:22.164631 [ 3 ] {f727cfc9-d5a1-4f8a-96b1-054ec5d9cf14} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 513 | 2024.10.09 22:46:22.167903 [ 3 ] {f727cfc9-d5a1-4f8a-96b1-054ec5d9cf14} <Debug> oximeter.measurements_histogramu16 (d5099c5e-3947-4822-874a-de7f7a7c8047): Loading data parts | ||
| 514 | 2024.10.09 22:46:22.168293 [ 3 ] {f727cfc9-d5a1-4f8a-96b1-054ec5d9cf14} <Debug> oximeter.measurements_histogramu16 (d5099c5e-3947-4822-874a-de7f7a7c8047): There are no data parts | ||
| 515 | 2024.10.09 22:46:22.170887 [ 3 ] {f727cfc9-d5a1-4f8a-96b1-054ec5d9cf14} <Debug> DynamicQueryHandler: Done processing query | ||
| 516 | 2024.10.09 22:46:22.170928 [ 3 ] {} <Debug> HTTP-Session: 38be009b-5153-4fc8-ba9e-8cd44d64916b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 517 | 2024.10.09 22:46:22.172169 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 518 | 2024.10.09 22:46:22.172261 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 519 | 2024.10.09 22:46:22.172290 [ 3 ] {} <Debug> HTTP-Session: 7cf728fb-ac32-41bf-8765-2e7b93838683 Authenticating user 'default' from [::1]:54963 | ||
| 520 | 2024.10.09 22:46:22.172317 [ 3 ] {} <Debug> HTTP-Session: 7cf728fb-ac32-41bf-8765-2e7b93838683 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 521 | 2024.10.09 22:46:22.172344 [ 3 ] {} <Debug> HTTP-Session: 7cf728fb-ac32-41bf-8765-2e7b93838683 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 522 | 2024.10.09 22:46:22.172398 [ 3 ] {} <Trace> HTTP-Session: 7cf728fb-ac32-41bf-8765-2e7b93838683 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 523 | 2024.10.09 22:46:22.173218 [ 3 ] {26ade0b8-0029-4a6d-993e-63c300434cdf} <Debug> executeQuery: (from [::1]:54963) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 524 | 2024.10.09 22:46:22.173397 [ 3 ] {26ade0b8-0029-4a6d-993e-63c300434cdf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 525 | 2024.10.09 22:46:22.179113 [ 3 ] {26ade0b8-0029-4a6d-993e-63c300434cdf} <Debug> oximeter.measurements_histogrami32 (3e0a63d6-9af6-4a3f-a680-59c66cb802af): Loading data parts | ||
| 526 | 2024.10.09 22:46:22.180538 [ 3 ] {26ade0b8-0029-4a6d-993e-63c300434cdf} <Debug> oximeter.measurements_histogrami32 (3e0a63d6-9af6-4a3f-a680-59c66cb802af): There are no data parts | ||
| 527 | 2024.10.09 22:46:22.190426 [ 3 ] {26ade0b8-0029-4a6d-993e-63c300434cdf} <Debug> DynamicQueryHandler: Done processing query | ||
| 528 | 2024.10.09 22:46:22.190498 [ 3 ] {} <Debug> HTTP-Session: 7cf728fb-ac32-41bf-8765-2e7b93838683 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 529 | 2024.10.09 22:46:22.192539 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 530 | 2024.10.09 22:46:22.192668 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 531 | 2024.10.09 22:46:22.192728 [ 3 ] {} <Debug> HTTP-Session: ec713977-0d43-4499-b5ba-9b78b0f8db0a Authenticating user 'default' from [::1]:54963 | ||
| 532 | 2024.10.09 22:46:22.192763 [ 3 ] {} <Debug> HTTP-Session: ec713977-0d43-4499-b5ba-9b78b0f8db0a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 533 | 2024.10.09 22:46:22.192781 [ 3 ] {} <Debug> HTTP-Session: ec713977-0d43-4499-b5ba-9b78b0f8db0a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 534 | 2024.10.09 22:46:22.192885 [ 3 ] {} <Trace> HTTP-Session: ec713977-0d43-4499-b5ba-9b78b0f8db0a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 535 | 2024.10.09 22:46:22.193827 [ 3 ] {e97b6ebd-f00b-44da-aca1-cea832038db0} <Debug> executeQuery: (from [::1]:54963) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 536 | 2024.10.09 22:46:22.193942 [ 3 ] {e97b6ebd-f00b-44da-aca1-cea832038db0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 537 | 2024.10.09 22:46:22.209914 [ 3 ] {e97b6ebd-f00b-44da-aca1-cea832038db0} <Debug> oximeter.measurements_histogramu32 (303cfc0e-efd0-4d6b-af43-8f6e2e4ff421): Loading data parts | ||
| 538 | 2024.10.09 22:46:22.211045 [ 3 ] {e97b6ebd-f00b-44da-aca1-cea832038db0} <Debug> oximeter.measurements_histogramu32 (303cfc0e-efd0-4d6b-af43-8f6e2e4ff421): There are no data parts | ||
| 539 | 2024.10.09 22:46:22.220129 [ 3 ] {e97b6ebd-f00b-44da-aca1-cea832038db0} <Debug> DynamicQueryHandler: Done processing query | ||
| 540 | 2024.10.09 22:46:22.220178 [ 3 ] {} <Debug> HTTP-Session: ec713977-0d43-4499-b5ba-9b78b0f8db0a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 541 | 2024.10.09 22:46:22.223038 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 542 | 2024.10.09 22:46:22.223156 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 543 | 2024.10.09 22:46:22.223184 [ 3 ] {} <Debug> HTTP-Session: ada7f42d-3572-4247-b8d5-1f20d894e650 Authenticating user 'default' from [::1]:54963 | ||
| 544 | 2024.10.09 22:46:22.223209 [ 3 ] {} <Debug> HTTP-Session: ada7f42d-3572-4247-b8d5-1f20d894e650 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 545 | 2024.10.09 22:46:22.223236 [ 3 ] {} <Debug> HTTP-Session: ada7f42d-3572-4247-b8d5-1f20d894e650 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 546 | 2024.10.09 22:46:22.223292 [ 3 ] {} <Trace> HTTP-Session: ada7f42d-3572-4247-b8d5-1f20d894e650 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 547 | 2024.10.09 22:46:22.223770 [ 3 ] {add9cbd1-75f5-4738-8c15-7addd9322bd1} <Debug> executeQuery: (from [::1]:54963) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 548 | 2024.10.09 22:46:22.223867 [ 3 ] {add9cbd1-75f5-4738-8c15-7addd9322bd1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 549 | 2024.10.09 22:46:22.228146 [ 3 ] {add9cbd1-75f5-4738-8c15-7addd9322bd1} <Debug> oximeter.measurements_histogrami64 (b6389218-0e7b-4107-8ca8-7ad9c23f12ce): Loading data parts | ||
| 550 | 2024.10.09 22:46:22.228732 [ 3 ] {add9cbd1-75f5-4738-8c15-7addd9322bd1} <Debug> oximeter.measurements_histogrami64 (b6389218-0e7b-4107-8ca8-7ad9c23f12ce): There are no data parts | ||
| 551 | 2024.10.09 22:46:22.231149 [ 3 ] {add9cbd1-75f5-4738-8c15-7addd9322bd1} <Debug> DynamicQueryHandler: Done processing query | ||
| 552 | 2024.10.09 22:46:22.231242 [ 3 ] {} <Debug> HTTP-Session: ada7f42d-3572-4247-b8d5-1f20d894e650 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 553 | 2024.10.09 22:46:22.232355 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 554 | 2024.10.09 22:46:22.232432 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 555 | 2024.10.09 22:46:22.232456 [ 3 ] {} <Debug> HTTP-Session: bcfa86b0-acc0-4484-a62c-39d0707ecbf6 Authenticating user 'default' from [::1]:54963 | ||
| 556 | 2024.10.09 22:46:22.232505 [ 3 ] {} <Debug> HTTP-Session: bcfa86b0-acc0-4484-a62c-39d0707ecbf6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 557 | 2024.10.09 22:46:22.232523 [ 3 ] {} <Debug> HTTP-Session: bcfa86b0-acc0-4484-a62c-39d0707ecbf6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 558 | 2024.10.09 22:46:22.232607 [ 3 ] {} <Trace> HTTP-Session: bcfa86b0-acc0-4484-a62c-39d0707ecbf6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 559 | 2024.10.09 22:46:22.233137 [ 3 ] {8fd7da09-eba2-4f4f-85ae-977a222f3aad} <Debug> executeQuery: (from [::1]:54963) 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:46:22.233241 [ 3 ] {8fd7da09-eba2-4f4f-85ae-977a222f3aad} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 561 | 2024.10.09 22:46:22.238915 [ 3 ] {8fd7da09-eba2-4f4f-85ae-977a222f3aad} <Debug> oximeter.measurements_histogramu64 (86c6cf9f-5ca4-4780-927f-b492cc0101b7): Loading data parts | ||
| 562 | 2024.10.09 22:46:22.239341 [ 3 ] {8fd7da09-eba2-4f4f-85ae-977a222f3aad} <Debug> oximeter.measurements_histogramu64 (86c6cf9f-5ca4-4780-927f-b492cc0101b7): There are no data parts | ||
| 563 | 2024.10.09 22:46:22.242655 [ 3 ] {8fd7da09-eba2-4f4f-85ae-977a222f3aad} <Debug> DynamicQueryHandler: Done processing query | ||
| 564 | 2024.10.09 22:46:22.242696 [ 3 ] {} <Debug> HTTP-Session: bcfa86b0-acc0-4484-a62c-39d0707ecbf6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 565 | 2024.10.09 22:46:22.243262 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 566 | 2024.10.09 22:46:22.243359 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 567 | 2024.10.09 22:46:22.243513 [ 3 ] {} <Debug> HTTP-Session: 65ba16d1-50f2-4403-b03a-c07257c45645 Authenticating user 'default' from [::1]:54963 | ||
| 568 | 2024.10.09 22:46:22.243544 [ 3 ] {} <Debug> HTTP-Session: 65ba16d1-50f2-4403-b03a-c07257c45645 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 569 | 2024.10.09 22:46:22.243560 [ 3 ] {} <Debug> HTTP-Session: 65ba16d1-50f2-4403-b03a-c07257c45645 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 570 | 2024.10.09 22:46:22.243633 [ 3 ] {} <Trace> HTTP-Session: 65ba16d1-50f2-4403-b03a-c07257c45645 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 571 | 2024.10.09 22:46:22.244419 [ 3 ] {7698311f-509f-48ed-87ab-2ade3b7e627b} <Debug> executeQuery: (from [::1]:54963) 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:46:22.244528 [ 3 ] {7698311f-509f-48ed-87ab-2ade3b7e627b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 573 | 2024.10.09 22:46:22.248019 [ 3 ] {7698311f-509f-48ed-87ab-2ade3b7e627b} <Debug> oximeter.measurements_histogramf32 (22ecac68-a3b2-4b06-99ad-28a52749e18a): Loading data parts | ||
| 574 | 2024.10.09 22:46:22.248528 [ 3 ] {7698311f-509f-48ed-87ab-2ade3b7e627b} <Debug> oximeter.measurements_histogramf32 (22ecac68-a3b2-4b06-99ad-28a52749e18a): There are no data parts | ||
| 575 | 2024.10.09 22:46:22.252866 [ 3 ] {7698311f-509f-48ed-87ab-2ade3b7e627b} <Debug> DynamicQueryHandler: Done processing query | ||
| 576 | 2024.10.09 22:46:22.252909 [ 3 ] {} <Debug> HTTP-Session: 65ba16d1-50f2-4403-b03a-c07257c45645 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 577 | 2024.10.09 22:46:22.253675 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 578 | 2024.10.09 22:46:22.253794 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 579 | 2024.10.09 22:46:22.253839 [ 3 ] {} <Debug> HTTP-Session: 7c43704b-279b-4dfb-80eb-b1bf873da2d5 Authenticating user 'default' from [::1]:54963 | ||
| 580 | 2024.10.09 22:46:22.253996 [ 3 ] {} <Debug> HTTP-Session: 7c43704b-279b-4dfb-80eb-b1bf873da2d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 581 | 2024.10.09 22:46:22.254025 [ 3 ] {} <Debug> HTTP-Session: 7c43704b-279b-4dfb-80eb-b1bf873da2d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 582 | 2024.10.09 22:46:22.254075 [ 3 ] {} <Trace> HTTP-Session: 7c43704b-279b-4dfb-80eb-b1bf873da2d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 583 | 2024.10.09 22:46:22.254541 [ 3 ] {3e2cb39a-d63d-4ac6-baf6-2369855bdaef} <Debug> executeQuery: (from [::1]:54963) 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:46:22.254631 [ 3 ] {3e2cb39a-d63d-4ac6-baf6-2369855bdaef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 585 | 2024.10.09 22:46:22.259101 [ 3 ] {3e2cb39a-d63d-4ac6-baf6-2369855bdaef} <Debug> oximeter.measurements_histogramf64 (b5378d50-ab3a-45e5-8b92-0338b2c984bb): Loading data parts | ||
| 586 | 2024.10.09 22:46:22.259380 [ 3 ] {3e2cb39a-d63d-4ac6-baf6-2369855bdaef} <Debug> oximeter.measurements_histogramf64 (b5378d50-ab3a-45e5-8b92-0338b2c984bb): There are no data parts | ||
| 587 | 2024.10.09 22:46:22.261517 [ 3 ] {3e2cb39a-d63d-4ac6-baf6-2369855bdaef} <Debug> DynamicQueryHandler: Done processing query | ||
| 588 | 2024.10.09 22:46:22.261612 [ 3 ] {} <Debug> HTTP-Session: 7c43704b-279b-4dfb-80eb-b1bf873da2d5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 589 | 2024.10.09 22:46:22.263002 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 590 | 2024.10.09 22:46:22.263087 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 591 | 2024.10.09 22:46:22.263135 [ 3 ] {} <Debug> HTTP-Session: 5c524489-1628-41a7-a66b-ee4d1683960d Authenticating user 'default' from [::1]:54963 | ||
| 592 | 2024.10.09 22:46:22.263164 [ 3 ] {} <Debug> HTTP-Session: 5c524489-1628-41a7-a66b-ee4d1683960d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 593 | 2024.10.09 22:46:22.263181 [ 3 ] {} <Debug> HTTP-Session: 5c524489-1628-41a7-a66b-ee4d1683960d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 594 | 2024.10.09 22:46:22.263243 [ 3 ] {} <Trace> HTTP-Session: 5c524489-1628-41a7-a66b-ee4d1683960d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 595 | 2024.10.09 22:46:22.264002 [ 3 ] {ee8ecd87-94b2-498d-9531-0831f9c73cc8} <Debug> executeQuery: (from [::1]:54963) /* 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:46:22.264110 [ 3 ] {ee8ecd87-94b2-498d-9531-0831f9c73cc8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 622 | 2024.10.09 22:46:22.269950 [ 3 ] {ee8ecd87-94b2-498d-9531-0831f9c73cc8} <Debug> oximeter.fields_bool (b4ecba0e-2dd8-4b05-99af-3ef3b534df59): Loading data parts | ||
| 623 | 2024.10.09 22:46:22.270390 [ 3 ] {ee8ecd87-94b2-498d-9531-0831f9c73cc8} <Debug> oximeter.fields_bool (b4ecba0e-2dd8-4b05-99af-3ef3b534df59): There are no data parts | ||
| 624 | 2024.10.09 22:46:22.274204 [ 3 ] {ee8ecd87-94b2-498d-9531-0831f9c73cc8} <Debug> DynamicQueryHandler: Done processing query | ||
| 625 | 2024.10.09 22:46:22.274240 [ 3 ] {} <Debug> HTTP-Session: 5c524489-1628-41a7-a66b-ee4d1683960d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 626 | 2024.10.09 22:46:22.280074 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 627 | 2024.10.09 22:46:22.280395 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 628 | 2024.10.09 22:46:22.280434 [ 3 ] {} <Debug> HTTP-Session: 4158fb95-4a04-4cfd-9f8f-cdd2f83c3a36 Authenticating user 'default' from [::1]:54963 | ||
| 629 | 2024.10.09 22:46:22.280544 [ 3 ] {} <Debug> HTTP-Session: 4158fb95-4a04-4cfd-9f8f-cdd2f83c3a36 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 630 | 2024.10.09 22:46:22.280585 [ 3 ] {} <Debug> HTTP-Session: 4158fb95-4a04-4cfd-9f8f-cdd2f83c3a36 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 631 | 2024.10.09 22:46:22.280650 [ 3 ] {} <Trace> HTTP-Session: 4158fb95-4a04-4cfd-9f8f-cdd2f83c3a36 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 632 | 2024.10.09 22:46:22.281316 [ 3 ] {0e9dea8d-46be-4f87-9c68-b8a9c1133dc5} <Debug> executeQuery: (from [::1]:54963) 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:46:22.281412 [ 3 ] {0e9dea8d-46be-4f87-9c68-b8a9c1133dc5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 634 | 2024.10.09 22:46:22.285909 [ 3 ] {0e9dea8d-46be-4f87-9c68-b8a9c1133dc5} <Debug> oximeter.fields_i8 (80f4b861-ec10-48ff-85cb-59560f1e9b24): Loading data parts | ||
| 635 | 2024.10.09 22:46:22.286256 [ 3 ] {0e9dea8d-46be-4f87-9c68-b8a9c1133dc5} <Debug> oximeter.fields_i8 (80f4b861-ec10-48ff-85cb-59560f1e9b24): There are no data parts | ||
| 636 | 2024.10.09 22:46:22.291847 [ 3 ] {0e9dea8d-46be-4f87-9c68-b8a9c1133dc5} <Debug> DynamicQueryHandler: Done processing query | ||
| 637 | 2024.10.09 22:46:22.295544 [ 3 ] {} <Debug> HTTP-Session: 4158fb95-4a04-4cfd-9f8f-cdd2f83c3a36 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 638 | 2024.10.09 22:46:22.299701 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 639 | 2024.10.09 22:46:22.299812 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 640 | 2024.10.09 22:46:22.299844 [ 3 ] {} <Debug> HTTP-Session: 6bc1534c-9b66-4291-8c2c-324ef28f3424 Authenticating user 'default' from [::1]:54963 | ||
| 641 | 2024.10.09 22:46:22.299891 [ 3 ] {} <Debug> HTTP-Session: 6bc1534c-9b66-4291-8c2c-324ef28f3424 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 642 | 2024.10.09 22:46:22.299908 [ 3 ] {} <Debug> HTTP-Session: 6bc1534c-9b66-4291-8c2c-324ef28f3424 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 643 | 2024.10.09 22:46:22.299969 [ 3 ] {} <Trace> HTTP-Session: 6bc1534c-9b66-4291-8c2c-324ef28f3424 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 644 | 2024.10.09 22:46:22.300323 [ 3 ] {771fc799-334e-471b-a69c-2bdc6fe2e38e} <Debug> executeQuery: (from [::1]:54963) 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:46:22.300497 [ 3 ] {771fc799-334e-471b-a69c-2bdc6fe2e38e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 646 | 2024.10.09 22:46:22.308740 [ 3 ] {771fc799-334e-471b-a69c-2bdc6fe2e38e} <Debug> oximeter.fields_u8 (53d80f67-7ad4-4083-bbcf-ef53e47cb268): Loading data parts | ||
| 647 | 2024.10.09 22:46:22.309266 [ 3 ] {771fc799-334e-471b-a69c-2bdc6fe2e38e} <Debug> oximeter.fields_u8 (53d80f67-7ad4-4083-bbcf-ef53e47cb268): There are no data parts | ||
| 648 | 2024.10.09 22:46:22.326455 [ 3 ] {771fc799-334e-471b-a69c-2bdc6fe2e38e} <Debug> DynamicQueryHandler: Done processing query | ||
| 649 | 2024.10.09 22:46:22.326504 [ 3 ] {} <Debug> HTTP-Session: 6bc1534c-9b66-4291-8c2c-324ef28f3424 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 650 | 2024.10.09 22:46:22.432319 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 651 | 2024.10.09 22:46:22.432887 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 652 | 2024.10.09 22:46:22.432947 [ 3 ] {} <Debug> HTTP-Session: ab65e05c-8952-4a31-8bd8-f6b7763408e9 Authenticating user 'default' from [::1]:54963 | ||
| 653 | 2024.10.09 22:46:22.432978 [ 3 ] {} <Debug> HTTP-Session: ab65e05c-8952-4a31-8bd8-f6b7763408e9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 654 | 2024.10.09 22:46:22.433009 [ 3 ] {} <Debug> HTTP-Session: ab65e05c-8952-4a31-8bd8-f6b7763408e9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 655 | 2024.10.09 22:46:22.433075 [ 3 ] {} <Trace> HTTP-Session: ab65e05c-8952-4a31-8bd8-f6b7763408e9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 656 | 2024.10.09 22:46:22.433843 [ 3 ] {c216710c-148c-4bdc-9339-12c58fbc7f9f} <Debug> executeQuery: (from [::1]:54963) 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:46:22.433987 [ 3 ] {c216710c-148c-4bdc-9339-12c58fbc7f9f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 658 | 2024.10.09 22:46:22.438740 [ 3 ] {c216710c-148c-4bdc-9339-12c58fbc7f9f} <Debug> oximeter.fields_i16 (bd8f4396-fdda-4990-a445-7d799cee6185): Loading data parts | ||
| 659 | 2024.10.09 22:46:22.439162 [ 3 ] {c216710c-148c-4bdc-9339-12c58fbc7f9f} <Debug> oximeter.fields_i16 (bd8f4396-fdda-4990-a445-7d799cee6185): There are no data parts | ||
| 660 | 2024.10.09 22:46:22.442634 [ 3 ] {c216710c-148c-4bdc-9339-12c58fbc7f9f} <Debug> DynamicQueryHandler: Done processing query | ||
| 661 | 2024.10.09 22:46:22.442671 [ 3 ] {} <Debug> HTTP-Session: ab65e05c-8952-4a31-8bd8-f6b7763408e9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 662 | 2024.10.09 22:46:22.451109 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 663 | 2024.10.09 22:46:22.451214 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 664 | 2024.10.09 22:46:22.451239 [ 3 ] {} <Debug> HTTP-Session: 63c43821-78fd-416c-ae80-52eff501595d Authenticating user 'default' from [::1]:54963 | ||
| 665 | 2024.10.09 22:46:22.451284 [ 3 ] {} <Debug> HTTP-Session: 63c43821-78fd-416c-ae80-52eff501595d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 666 | 2024.10.09 22:46:22.451299 [ 3 ] {} <Debug> HTTP-Session: 63c43821-78fd-416c-ae80-52eff501595d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 667 | 2024.10.09 22:46:22.451351 [ 3 ] {} <Trace> HTTP-Session: 63c43821-78fd-416c-ae80-52eff501595d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 668 | 2024.10.09 22:46:22.451835 [ 3 ] {08557c83-258b-457d-9bc5-bfaa9c70f6c4} <Debug> executeQuery: (from [::1]:54963) 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:46:22.451951 [ 3 ] {08557c83-258b-457d-9bc5-bfaa9c70f6c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 670 | 2024.10.09 22:46:22.455388 [ 3 ] {08557c83-258b-457d-9bc5-bfaa9c70f6c4} <Debug> oximeter.fields_u16 (7aeb7002-aafd-429b-8c07-5056cb679e40): Loading data parts | ||
| 671 | 2024.10.09 22:46:22.455649 [ 3 ] {08557c83-258b-457d-9bc5-bfaa9c70f6c4} <Debug> oximeter.fields_u16 (7aeb7002-aafd-429b-8c07-5056cb679e40): There are no data parts | ||
| 672 | 2024.10.09 22:46:22.457200 [ 3 ] {08557c83-258b-457d-9bc5-bfaa9c70f6c4} <Debug> DynamicQueryHandler: Done processing query | ||
| 673 | 2024.10.09 22:46:22.457230 [ 3 ] {} <Debug> HTTP-Session: 63c43821-78fd-416c-ae80-52eff501595d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 674 | 2024.10.09 22:46:22.461109 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 675 | 2024.10.09 22:46:22.461291 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 676 | 2024.10.09 22:46:22.461620 [ 3 ] {} <Debug> HTTP-Session: 0d6e6716-a94f-4b1e-b3c0-bf17bd85e72c Authenticating user 'default' from [::1]:54963 | ||
| 677 | 2024.10.09 22:46:22.461806 [ 3 ] {} <Debug> HTTP-Session: 0d6e6716-a94f-4b1e-b3c0-bf17bd85e72c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 678 | 2024.10.09 22:46:22.461854 [ 3 ] {} <Debug> HTTP-Session: 0d6e6716-a94f-4b1e-b3c0-bf17bd85e72c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 679 | 2024.10.09 22:46:22.461921 [ 3 ] {} <Trace> HTTP-Session: 0d6e6716-a94f-4b1e-b3c0-bf17bd85e72c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 680 | 2024.10.09 22:46:22.462479 [ 3 ] {751de58d-e964-4e04-861b-cfc194b88c7a} <Debug> executeQuery: (from [::1]:54963) 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:46:22.462790 [ 3 ] {751de58d-e964-4e04-861b-cfc194b88c7a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 682 | 2024.10.09 22:46:22.465669 [ 3 ] {751de58d-e964-4e04-861b-cfc194b88c7a} <Debug> oximeter.fields_i32 (2aa74d42-ef04-4475-9399-a7afa668d033): Loading data parts | ||
| 683 | 2024.10.09 22:46:22.466061 [ 3 ] {751de58d-e964-4e04-861b-cfc194b88c7a} <Debug> oximeter.fields_i32 (2aa74d42-ef04-4475-9399-a7afa668d033): There are no data parts | ||
| 684 | 2024.10.09 22:46:22.467886 [ 3 ] {751de58d-e964-4e04-861b-cfc194b88c7a} <Debug> DynamicQueryHandler: Done processing query | ||
| 685 | 2024.10.09 22:46:22.467913 [ 3 ] {} <Debug> HTTP-Session: 0d6e6716-a94f-4b1e-b3c0-bf17bd85e72c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 686 | 2024.10.09 22:46:22.471125 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 687 | 2024.10.09 22:46:22.471210 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 688 | 2024.10.09 22:46:22.471233 [ 3 ] {} <Debug> HTTP-Session: e9cf8685-e7e6-4ce2-b783-1deb6a8c5fad Authenticating user 'default' from [::1]:54963 | ||
| 689 | 2024.10.09 22:46:22.471273 [ 3 ] {} <Debug> HTTP-Session: e9cf8685-e7e6-4ce2-b783-1deb6a8c5fad Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 690 | 2024.10.09 22:46:22.471288 [ 3 ] {} <Debug> HTTP-Session: e9cf8685-e7e6-4ce2-b783-1deb6a8c5fad Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 691 | 2024.10.09 22:46:22.471337 [ 3 ] {} <Trace> HTTP-Session: e9cf8685-e7e6-4ce2-b783-1deb6a8c5fad Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 692 | 2024.10.09 22:46:22.471756 [ 3 ] {b564fef9-d11c-4762-a049-22be4a77833f} <Debug> executeQuery: (from [::1]:54963) 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:46:22.471839 [ 3 ] {b564fef9-d11c-4762-a049-22be4a77833f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 694 | 2024.10.09 22:46:22.475384 [ 3 ] {b564fef9-d11c-4762-a049-22be4a77833f} <Debug> oximeter.fields_u32 (05985206-78cf-4850-9e1c-79aa2230dade): Loading data parts | ||
| 695 | 2024.10.09 22:46:22.476495 [ 3 ] {b564fef9-d11c-4762-a049-22be4a77833f} <Debug> oximeter.fields_u32 (05985206-78cf-4850-9e1c-79aa2230dade): There are no data parts | ||
| 696 | 2024.10.09 22:46:22.478655 [ 3 ] {b564fef9-d11c-4762-a049-22be4a77833f} <Debug> DynamicQueryHandler: Done processing query | ||
| 697 | 2024.10.09 22:46:22.478775 [ 3 ] {} <Debug> HTTP-Session: e9cf8685-e7e6-4ce2-b783-1deb6a8c5fad Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 698 | 2024.10.09 22:46:22.485720 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 699 | 2024.10.09 22:46:22.485861 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 700 | 2024.10.09 22:46:22.485909 [ 3 ] {} <Debug> HTTP-Session: 022437a4-ab9d-425c-927f-576d52e668dd Authenticating user 'default' from [::1]:54963 | ||
| 701 | 2024.10.09 22:46:22.485935 [ 3 ] {} <Debug> HTTP-Session: 022437a4-ab9d-425c-927f-576d52e668dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 702 | 2024.10.09 22:46:22.485977 [ 3 ] {} <Debug> HTTP-Session: 022437a4-ab9d-425c-927f-576d52e668dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 703 | 2024.10.09 22:46:22.486198 [ 3 ] {} <Trace> HTTP-Session: 022437a4-ab9d-425c-927f-576d52e668dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 704 | 2024.10.09 22:46:22.486792 [ 3 ] {c80e899f-075e-416f-95ca-56de2481cb5b} <Debug> executeQuery: (from [::1]:54963) 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:46:22.486896 [ 3 ] {c80e899f-075e-416f-95ca-56de2481cb5b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 706 | 2024.10.09 22:46:22.490481 [ 3 ] {c80e899f-075e-416f-95ca-56de2481cb5b} <Debug> oximeter.fields_i64 (ee7c6cf6-d9d4-4f37-ac95-eb42d82f41f9): Loading data parts | ||
| 707 | 2024.10.09 22:46:22.490843 [ 3 ] {c80e899f-075e-416f-95ca-56de2481cb5b} <Debug> oximeter.fields_i64 (ee7c6cf6-d9d4-4f37-ac95-eb42d82f41f9): There are no data parts | ||
| 708 | 2024.10.09 22:46:22.493182 [ 3 ] {c80e899f-075e-416f-95ca-56de2481cb5b} <Debug> DynamicQueryHandler: Done processing query | ||
| 709 | 2024.10.09 22:46:22.493222 [ 3 ] {} <Debug> HTTP-Session: 022437a4-ab9d-425c-927f-576d52e668dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 710 | 2024.10.09 22:46:22.495102 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 711 | 2024.10.09 22:46:22.495245 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 712 | 2024.10.09 22:46:22.495339 [ 3 ] {} <Debug> HTTP-Session: f4eab63b-b934-4e1c-acd8-0c1d167f6947 Authenticating user 'default' from [::1]:54963 | ||
| 713 | 2024.10.09 22:46:22.495366 [ 3 ] {} <Debug> HTTP-Session: f4eab63b-b934-4e1c-acd8-0c1d167f6947 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 714 | 2024.10.09 22:46:22.495382 [ 3 ] {} <Debug> HTTP-Session: f4eab63b-b934-4e1c-acd8-0c1d167f6947 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 715 | 2024.10.09 22:46:22.495437 [ 3 ] {} <Trace> HTTP-Session: f4eab63b-b934-4e1c-acd8-0c1d167f6947 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 716 | 2024.10.09 22:46:22.495782 [ 3 ] {a989f862-90c4-4ecb-b5a5-0291cc5c5c93} <Debug> executeQuery: (from [::1]:54963) 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:46:22.496144 [ 3 ] {a989f862-90c4-4ecb-b5a5-0291cc5c5c93} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 718 | 2024.10.09 22:46:22.499457 [ 3 ] {a989f862-90c4-4ecb-b5a5-0291cc5c5c93} <Debug> oximeter.fields_u64 (8e690ad9-5bc2-4ba4-b567-6d934f0786b0): Loading data parts | ||
| 719 | 2024.10.09 22:46:22.499738 [ 3 ] {a989f862-90c4-4ecb-b5a5-0291cc5c5c93} <Debug> oximeter.fields_u64 (8e690ad9-5bc2-4ba4-b567-6d934f0786b0): There are no data parts | ||
| 720 | 2024.10.09 22:46:22.501609 [ 3 ] {a989f862-90c4-4ecb-b5a5-0291cc5c5c93} <Debug> DynamicQueryHandler: Done processing query | ||
| 721 | 2024.10.09 22:46:22.501783 [ 3 ] {} <Debug> HTTP-Session: f4eab63b-b934-4e1c-acd8-0c1d167f6947 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 722 | 2024.10.09 22:46:22.502871 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 723 | 2024.10.09 22:46:22.502952 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 724 | 2024.10.09 22:46:22.502980 [ 3 ] {} <Debug> HTTP-Session: 86b94715-df95-4ce1-93a4-86796b259174 Authenticating user 'default' from [::1]:54963 | ||
| 725 | 2024.10.09 22:46:22.503007 [ 3 ] {} <Debug> HTTP-Session: 86b94715-df95-4ce1-93a4-86796b259174 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 726 | 2024.10.09 22:46:22.503022 [ 3 ] {} <Debug> HTTP-Session: 86b94715-df95-4ce1-93a4-86796b259174 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 727 | 2024.10.09 22:46:22.503069 [ 3 ] {} <Trace> HTTP-Session: 86b94715-df95-4ce1-93a4-86796b259174 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 728 | 2024.10.09 22:46:22.503469 [ 3 ] {9269b5f0-678e-4ab8-96ae-faf1464bfbd9} <Debug> executeQuery: (from [::1]:54963) 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:46:22.503556 [ 3 ] {9269b5f0-678e-4ab8-96ae-faf1464bfbd9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 730 | 2024.10.09 22:46:22.506282 [ 3 ] {9269b5f0-678e-4ab8-96ae-faf1464bfbd9} <Debug> oximeter.fields_ipaddr (f19782c9-3b7e-4aa2-95bd-7038c9974ade): Loading data parts | ||
| 731 | 2024.10.09 22:46:22.506641 [ 3 ] {9269b5f0-678e-4ab8-96ae-faf1464bfbd9} <Debug> oximeter.fields_ipaddr (f19782c9-3b7e-4aa2-95bd-7038c9974ade): There are no data parts | ||
| 732 | 2024.10.09 22:46:22.508610 [ 3 ] {9269b5f0-678e-4ab8-96ae-faf1464bfbd9} <Debug> DynamicQueryHandler: Done processing query | ||
| 733 | 2024.10.09 22:46:22.508643 [ 3 ] {} <Debug> HTTP-Session: 86b94715-df95-4ce1-93a4-86796b259174 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2024.10.09 22:46:22.509400 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 735 | 2024.10.09 22:46:22.509484 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 736 | 2024.10.09 22:46:22.509512 [ 3 ] {} <Debug> HTTP-Session: 81899093-2536-4e6d-b93d-42d7977f4be0 Authenticating user 'default' from [::1]:54963 | ||
| 737 | 2024.10.09 22:46:22.509548 [ 3 ] {} <Debug> HTTP-Session: 81899093-2536-4e6d-b93d-42d7977f4be0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 738 | 2024.10.09 22:46:22.509566 [ 3 ] {} <Debug> HTTP-Session: 81899093-2536-4e6d-b93d-42d7977f4be0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 739 | 2024.10.09 22:46:22.509622 [ 3 ] {} <Trace> HTTP-Session: 81899093-2536-4e6d-b93d-42d7977f4be0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 740 | 2024.10.09 22:46:22.510059 [ 3 ] {0e663954-506b-4e0c-855a-bcde2c0c6cc1} <Debug> executeQuery: (from [::1]:54963) 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:46:22.510162 [ 3 ] {0e663954-506b-4e0c-855a-bcde2c0c6cc1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 742 | 2024.10.09 22:46:22.513266 [ 3 ] {0e663954-506b-4e0c-855a-bcde2c0c6cc1} <Debug> oximeter.fields_string (2e230bff-dc95-4764-9cf6-aa8490ebdb11): Loading data parts | ||
| 743 | 2024.10.09 22:46:22.513796 [ 3 ] {0e663954-506b-4e0c-855a-bcde2c0c6cc1} <Debug> oximeter.fields_string (2e230bff-dc95-4764-9cf6-aa8490ebdb11): There are no data parts | ||
| 744 | 2024.10.09 22:46:22.515663 [ 3 ] {0e663954-506b-4e0c-855a-bcde2c0c6cc1} <Debug> DynamicQueryHandler: Done processing query | ||
| 745 | 2024.10.09 22:46:22.515700 [ 3 ] {} <Debug> HTTP-Session: 81899093-2536-4e6d-b93d-42d7977f4be0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 746 | 2024.10.09 22:46:22.516342 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 747 | 2024.10.09 22:46:22.516420 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 748 | 2024.10.09 22:46:22.516453 [ 3 ] {} <Debug> HTTP-Session: 26ba8234-0843-4f95-a2fb-1154101749df Authenticating user 'default' from [::1]:54963 | ||
| 749 | 2024.10.09 22:46:22.516477 [ 3 ] {} <Debug> HTTP-Session: 26ba8234-0843-4f95-a2fb-1154101749df Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 750 | 2024.10.09 22:46:22.516494 [ 3 ] {} <Debug> HTTP-Session: 26ba8234-0843-4f95-a2fb-1154101749df Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 751 | 2024.10.09 22:46:22.516549 [ 3 ] {} <Trace> HTTP-Session: 26ba8234-0843-4f95-a2fb-1154101749df Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 752 | 2024.10.09 22:46:22.516888 [ 3 ] {5a82d7ee-c34d-42c1-a540-dbeea00adb72} <Debug> executeQuery: (from [::1]:54963) 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:46:22.516992 [ 3 ] {5a82d7ee-c34d-42c1-a540-dbeea00adb72} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 754 | 2024.10.09 22:46:22.519554 [ 3 ] {5a82d7ee-c34d-42c1-a540-dbeea00adb72} <Debug> oximeter.fields_uuid (960e87a9-c6cd-45d5-a13d-95b9370eaf01): Loading data parts | ||
| 755 | 2024.10.09 22:46:22.519857 [ 3 ] {5a82d7ee-c34d-42c1-a540-dbeea00adb72} <Debug> oximeter.fields_uuid (960e87a9-c6cd-45d5-a13d-95b9370eaf01): There are no data parts | ||
| 756 | 2024.10.09 22:46:22.521886 [ 3 ] {5a82d7ee-c34d-42c1-a540-dbeea00adb72} <Debug> DynamicQueryHandler: Done processing query | ||
| 757 | 2024.10.09 22:46:22.521918 [ 3 ] {} <Debug> HTTP-Session: 26ba8234-0843-4f95-a2fb-1154101749df Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 758 | 2024.10.09 22:46:22.522635 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 759 | 2024.10.09 22:46:22.522711 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 760 | 2024.10.09 22:46:22.522740 [ 3 ] {} <Debug> HTTP-Session: 1ee0ba75-7914-4089-9dc6-512948fdf256 Authenticating user 'default' from [::1]:54963 | ||
| 761 | 2024.10.09 22:46:22.522758 [ 3 ] {} <Debug> HTTP-Session: 1ee0ba75-7914-4089-9dc6-512948fdf256 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 762 | 2024.10.09 22:46:22.522773 [ 3 ] {} <Debug> HTTP-Session: 1ee0ba75-7914-4089-9dc6-512948fdf256 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 763 | 2024.10.09 22:46:22.522860 [ 3 ] {} <Trace> HTTP-Session: 1ee0ba75-7914-4089-9dc6-512948fdf256 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 764 | 2024.10.09 22:46:22.523488 [ 3 ] {5c4f4ca2-cb3e-4f12-973d-982d101ef751} <Debug> executeQuery: (from [::1]:54963) /* 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:46:22.523586 [ 3 ] {5c4f4ca2-cb3e-4f12-973d-982d101ef751} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 769 | 2024.10.09 22:46:22.527175 [ 3 ] {5c4f4ca2-cb3e-4f12-973d-982d101ef751} <Debug> oximeter.timeseries_schema (b1517feb-1198-4cd1-ae04-bc9e9fe26518): Loading data parts | ||
| 770 | 2024.10.09 22:46:22.527511 [ 3 ] {5c4f4ca2-cb3e-4f12-973d-982d101ef751} <Debug> oximeter.timeseries_schema (b1517feb-1198-4cd1-ae04-bc9e9fe26518): There are no data parts | ||
| 771 | 2024.10.09 22:46:22.529909 [ 3 ] {5c4f4ca2-cb3e-4f12-973d-982d101ef751} <Debug> DynamicQueryHandler: Done processing query | ||
| 772 | 2024.10.09 22:46:22.529943 [ 3 ] {} <Debug> HTTP-Session: 1ee0ba75-7914-4089-9dc6-512948fdf256 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 773 | 2024.10.09 22:46:22.530766 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54963, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 774 | 2024.10.09 22:46:22.530935 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 775 | 2024.10.09 22:46:22.530974 [ 3 ] {} <Debug> HTTP-Session: 482d0371-9302-4e94-9c9a-16c5aaf56fea Authenticating user 'default' from [::1]:54963 | ||
| 776 | 2024.10.09 22:46:22.531005 [ 3 ] {} <Debug> HTTP-Session: 482d0371-9302-4e94-9c9a-16c5aaf56fea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 777 | 2024.10.09 22:46:22.531023 [ 3 ] {} <Debug> HTTP-Session: 482d0371-9302-4e94-9c9a-16c5aaf56fea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 778 | 2024.10.09 22:46:22.531074 [ 3 ] {} <Trace> HTTP-Session: 482d0371-9302-4e94-9c9a-16c5aaf56fea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 779 | 2024.10.09 22:46:22.531313 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Debug> executeQuery: (from [::1]:54963) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 780 | 2024.10.09 22:46:22.531514 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 781 | 2024.10.09 22:46:22.533426 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Trace> oximeter.version (1d9cffa9-8721-46e3-a24a-60c37185e046): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 782 | 2024.10.09 22:46:22.533488 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.16 GiB. | ||
| 783 | 2024.10.09 22:46:22.535227 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 784 | 2024.10.09 22:46:22.535910 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Trace> oximeter.version (1d9cffa9-8721-46e3-a24a-60c37185e046): 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:46:22.536211 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.004995 sec., 200.2002002002002 rows/sec., 3.13 KiB/sec. | ||
| 786 | 2024.10.09 22:46:22.536443 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Debug> DynamicQueryHandler: Done processing query | ||
| 787 | 2024.10.09 22:46:22.536470 [ 3 ] {88792d5b-0dbd-4620-be51-61a4df6a8434} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 788 | 2024.10.09 22:46:22.536488 [ 3 ] {} <Debug> HTTP-Session: 482d0371-9302-4e94-9c9a-16c5aaf56fea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 789 | 2024.10.09 22:46:23.000629 [ 245 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 149.24 MiB, peak 154.38 MiB, free memory in arenas 0.00 B, will set to 148.09 MiB (RSS), difference: -1.15 MiB | ||
| 790 | 2024.10.09 22:46:25.045058 [ 156 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 791 | 2024.10.09 22:46:25.045112 [ 156 ] {} <Debug> DNSResolver: Updated DNS cache | ||