| 1 | 2024.10.09 22:40:14.978496 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 15266 | ||
| 2 | 2024.10.09 22:40:14.978685 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.10.09 22:40:14.978808 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.10.09 22:40:15.006548 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.10.09 22:40:15.021736 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.10.09 22:40:15.021820 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.10.09 22:40:15.021842 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2024.10.09 22:40:15.021952 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_image_deletion_permissions.15246.1-clickhouse-gyKgEj/datastore/tmp/ to store temporary data in it | ||
| 9 | 2024.10.09 22:40:15.022435 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.10.09 22:40:15.027538 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.10.09 22:40:15.029694 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 2024.10.09 22:40:15.030382 [ 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:40:15.030414 [ 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:40:15.030476 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.10.09 22:40:15.031301 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.10.09 22:40:15.038428 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.10.09 22:40:15.052634 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.10.09 22:40:15.054359 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2024.10.09 22:40:15.056159 [ 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:40:15.056215 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.10.09 22:40:15.057361 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.10.09 22:40:15.058429 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.10.09 22:40:15.062239 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.10.09 22:40:15.062824 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 2024.10.09 22:40:15.066750 [ 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:40:15.067285 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.10.09 22:40:15.067775 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2024.10.09 22:40:15.068369 [ 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:40:15.072968 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2024.10.09 22:40:15.073007 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_image_deletion_permissions.15246.1-clickhouse-gyKgEj/datastore/ | ||
| 31 | 2024.10.09 22:40:15.094152 [ 135 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 32 | 2024.10.09 22:40:15.094257 [ 135 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 33 | 2024.10.09 22:40:15.094690 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 34 | 2024.10.09 22:40:15.094720 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00021027 sec | ||
| 35 | 2024.10.09 22:40:15.094752 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 36 | 2024.10.09 22:40:15.094763 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 37 | 2024.10.09 22:40:15.094928 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 38 | 2024.10.09 22:40:15.094996 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 39 | 2024.10.09 22:40:15.095018 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 40 | 2024.10.09 22:40:15.095050 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 41 | 2024.10.09 22:40:15.095072 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 42 | 2024.10.09 22:40:15.095085 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 43 | 2024.10.09 22:40:15.097859 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 44 | 2024.10.09 22:40:15.097887 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 45 | 2024.10.09 22:40:15.098023 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 46 | 2024.10.09 22:40:15.098300 [ 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:40:15.098410 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 48 | 2024.10.09 22:40:15.098432 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 49 | 2024.10.09 22:40:15.098446 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 50 | 2024.10.09 22:40:15.098477 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2024.10.09 22:40:15.098494 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 2024.10.09 22:40:15.098528 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 53 | 2024.10.09 22:40:15.098557 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 54 | 2024.10.09 22:40:15.098577 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 55 | 2024.10.09 22:40:15.164661 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.10.09 22:40:15.181380 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.10.09 22:40:15.181432 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000114815 sec | ||
| 58 | 2024.10.09 22:40:15.181449 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.10.09 22:40:15.181462 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.10.09 22:40:15.181500 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2024.10.09 22:40:15.181868 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_image_deletion_permissions.15246.1-clickhouse-gyKgEj/datastore/user_defined/ | ||
| 62 | 2024.10.09 22:40:15.181943 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.10.09 22:40:15.181961 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2024.10.09 22:40:15.181973 [ 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:40:15.181989 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.10.09 22:40:15.182263 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 55863 | ||
| 67 | 2024.10.09 22:40:15.182480 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 58346 | ||
| 68 | 2024.10.09 22:40:15.183856 [ 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:40:15.183985 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 33285 | ||
| 70 | 2024.10.09 22:40:15.184061 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44350 | ||
| 71 | 2024.10.09 22:40:15.184147 [ 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:40:15.184196 [ 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:40:15.184433 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 16.10 MiB, free memory in arenas 0.00 B, will set to 139.55 MiB (RSS), difference: 129.65 MiB | ||
| 74 | 2024.10.09 22:40:15.184823 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.9168e-05 sec. | ||
| 75 | 2024.10.09 22:40:15.185268 [ 1 ] {} <Information> Application: Listening for http://[::1]:55863 | ||
| 76 | 2024.10.09 22:40:15.185339 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:58346 | ||
| 77 | 2024.10.09 22:40:15.185477 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:33285 | ||
| 78 | 2024.10.09 22:40:15.185566 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:44350 | ||
| 79 | 2024.10.09 22:40:15.185586 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 80 | 2024.10.09 22:40:27.655927 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 81 | 2024.10.09 22:40:27.656158 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 82 | 2024.10.09 22:40:27.656201 [ 3 ] {} <Debug> HTTP-Session: ede82eb0-10e0-4161-857e-c098954c6e73 Authenticating user 'default' from [::1]:58058 | ||
| 83 | 2024.10.09 22:40:27.656230 [ 3 ] {} <Debug> HTTP-Session: ede82eb0-10e0-4161-857e-c098954c6e73 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 84 | 2024.10.09 22:40:27.656245 [ 3 ] {} <Debug> HTTP-Session: ede82eb0-10e0-4161-857e-c098954c6e73 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 85 | 2024.10.09 22:40:27.656343 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 86 | 2024.10.09 22:40:27.656388 [ 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:40:27.656409 [ 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:40:27.656478 [ 3 ] {} <Trace> HTTP-Session: ede82eb0-10e0-4161-857e-c098954c6e73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 89 | 2024.10.09 22:40:27.657050 [ 3 ] {f078c186-fdb5-4516-8c97-64cbaaa4867f} <Debug> executeQuery: (from [::1]:58058) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 90 | 2024.10.09 22:40:27.666478 [ 3 ] {f078c186-fdb5-4516-8c97-64cbaaa4867f} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:58058) (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:40:27.666759 [ 3 ] {f078c186-fdb5-4516-8c97-64cbaaa4867f} <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:40:27.667121 [ 3 ] {} <Debug> HTTP-Session: ede82eb0-10e0-4161-857e-c098954c6e73 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 141 | 2024.10.09 22:40:27.669089 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 142 | 2024.10.09 22:40:27.669177 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 143 | 2024.10.09 22:40:27.669202 [ 3 ] {} <Debug> HTTP-Session: a8a2d109-537b-425b-a0f0-bd00f7183bcc Authenticating user 'default' from [::1]:58058 | ||
| 144 | 2024.10.09 22:40:27.669232 [ 3 ] {} <Debug> HTTP-Session: a8a2d109-537b-425b-a0f0-bd00f7183bcc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 145 | 2024.10.09 22:40:27.669249 [ 3 ] {} <Debug> HTTP-Session: a8a2d109-537b-425b-a0f0-bd00f7183bcc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 146 | 2024.10.09 22:40:27.669292 [ 3 ] {} <Trace> HTTP-Session: a8a2d109-537b-425b-a0f0-bd00f7183bcc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 147 | 2024.10.09 22:40:27.669525 [ 3 ] {6284d1dd-e51c-4c84-9061-bea58a1e1aee} <Debug> executeQuery: (from [::1]:58058) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 148 | 2024.10.09 22:40:27.669917 [ 3 ] {6284d1dd-e51c-4c84-9061-bea58a1e1aee} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:58058) (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:40:27.670100 [ 3 ] {6284d1dd-e51c-4c84-9061-bea58a1e1aee} <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:40:27.670383 [ 3 ] {} <Debug> HTTP-Session: a8a2d109-537b-425b-a0f0-bd00f7183bcc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 199 | 2024.10.09 22:40:27.671546 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 200 | 2024.10.09 22:40:27.671621 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 201 | 2024.10.09 22:40:27.671645 [ 3 ] {} <Debug> HTTP-Session: cfa56abc-e090-49bd-86fc-7a15a9283332 Authenticating user 'default' from [::1]:58058 | ||
| 202 | 2024.10.09 22:40:27.671674 [ 3 ] {} <Debug> HTTP-Session: cfa56abc-e090-49bd-86fc-7a15a9283332 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 203 | 2024.10.09 22:40:27.671690 [ 3 ] {} <Debug> HTTP-Session: cfa56abc-e090-49bd-86fc-7a15a9283332 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 204 | 2024.10.09 22:40:27.671734 [ 3 ] {} <Trace> HTTP-Session: cfa56abc-e090-49bd-86fc-7a15a9283332 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 205 | 2024.10.09 22:40:27.671955 [ 3 ] {a155a2d1-7dd3-4e75-b909-8a0a5b4ea246} <Debug> executeQuery: (from [::1]:58058) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 206 | 2024.10.09 22:40:27.672201 [ 3 ] {a155a2d1-7dd3-4e75-b909-8a0a5b4ea246} <Debug> DynamicQueryHandler: Done processing query | ||
| 207 | 2024.10.09 22:40:27.672226 [ 3 ] {} <Debug> HTTP-Session: cfa56abc-e090-49bd-86fc-7a15a9283332 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 208 | 2024.10.09 22:40:27.673547 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 209 | 2024.10.09 22:40:27.673621 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 210 | 2024.10.09 22:40:27.673642 [ 3 ] {} <Debug> HTTP-Session: 26d5d4fe-c2f3-4085-9010-b37771705f18 Authenticating user 'default' from [::1]:58058 | ||
| 211 | 2024.10.09 22:40:27.673670 [ 3 ] {} <Debug> HTTP-Session: 26d5d4fe-c2f3-4085-9010-b37771705f18 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 212 | 2024.10.09 22:40:27.673685 [ 3 ] {} <Debug> HTTP-Session: 26d5d4fe-c2f3-4085-9010-b37771705f18 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 213 | 2024.10.09 22:40:27.673727 [ 3 ] {} <Trace> HTTP-Session: 26d5d4fe-c2f3-4085-9010-b37771705f18 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 214 | 2024.10.09 22:40:27.673889 [ 3 ] {9c666124-5854-4727-b409-73476cd4e2d7} <Debug> executeQuery: (from [::1]:58058) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 215 | 2024.10.09 22:40:27.673972 [ 3 ] {9c666124-5854-4727-b409-73476cd4e2d7} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 216 | 2024.10.09 22:40:27.675452 [ 3 ] {9c666124-5854-4727-b409-73476cd4e2d7} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 217 | 2024.10.09 22:40:27.675490 [ 3 ] {9c666124-5854-4727-b409-73476cd4e2d7} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.8596e-05 sec | ||
| 218 | 2024.10.09 22:40:27.675508 [ 3 ] {9c666124-5854-4727-b409-73476cd4e2d7} <Trace> ReferentialDeps: No tables | ||
| 219 | 2024.10.09 22:40:27.675522 [ 3 ] {9c666124-5854-4727-b409-73476cd4e2d7} <Trace> LoadingDeps: No tables | ||
| 220 | 2024.10.09 22:40:27.675555 [ 3 ] {9c666124-5854-4727-b409-73476cd4e2d7} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 221 | 2024.10.09 22:40:27.675722 [ 3 ] {9c666124-5854-4727-b409-73476cd4e2d7} <Debug> DynamicQueryHandler: Done processing query | ||
| 222 | 2024.10.09 22:40:27.675748 [ 3 ] {} <Debug> HTTP-Session: 26d5d4fe-c2f3-4085-9010-b37771705f18 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 223 | 2024.10.09 22:40:27.761678 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 224 | 2024.10.09 22:40:27.761803 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 225 | 2024.10.09 22:40:27.761831 [ 3 ] {} <Debug> HTTP-Session: 5ef58db6-9271-4fc3-8653-0c8f5eeff2ae Authenticating user 'default' from [::1]:58058 | ||
| 226 | 2024.10.09 22:40:27.761857 [ 3 ] {} <Debug> HTTP-Session: 5ef58db6-9271-4fc3-8653-0c8f5eeff2ae Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 227 | 2024.10.09 22:40:27.761880 [ 3 ] {} <Debug> HTTP-Session: 5ef58db6-9271-4fc3-8653-0c8f5eeff2ae Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 228 | 2024.10.09 22:40:27.761935 [ 3 ] {} <Trace> HTTP-Session: 5ef58db6-9271-4fc3-8653-0c8f5eeff2ae Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 229 | 2024.10.09 22:40:27.762202 [ 3 ] {9fd33b6b-c3de-4bbd-a9e6-0c888839a0d0} <Debug> executeQuery: (from [::1]:58058) /* 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:40:27.762292 [ 3 ] {9fd33b6b-c3de-4bbd-a9e6-0c888839a0d0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 232 | 2024.10.09 22:40:27.764037 [ 3 ] {9fd33b6b-c3de-4bbd-a9e6-0c888839a0d0} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 233 | 2024.10.09 22:40:27.765376 [ 3 ] {9fd33b6b-c3de-4bbd-a9e6-0c888839a0d0} <Debug> oximeter.version (ddfac6e7-dc14-45c8-902c-8ebc63ee60fc): Loading data parts | ||
| 234 | 2024.10.09 22:40:27.766025 [ 3 ] {9fd33b6b-c3de-4bbd-a9e6-0c888839a0d0} <Debug> oximeter.version (ddfac6e7-dc14-45c8-902c-8ebc63ee60fc): There are no data parts | ||
| 235 | 2024.10.09 22:40:27.767871 [ 3 ] {9fd33b6b-c3de-4bbd-a9e6-0c888839a0d0} <Debug> DynamicQueryHandler: Done processing query | ||
| 236 | 2024.10.09 22:40:27.767912 [ 3 ] {} <Debug> HTTP-Session: 5ef58db6-9271-4fc3-8653-0c8f5eeff2ae Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 237 | 2024.10.09 22:40:27.769083 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 238 | 2024.10.09 22:40:27.769159 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 239 | 2024.10.09 22:40:27.769195 [ 3 ] {} <Debug> HTTP-Session: e366b7fc-1559-4e6a-8ea4-22e574d3de2d Authenticating user 'default' from [::1]:58058 | ||
| 240 | 2024.10.09 22:40:27.769222 [ 3 ] {} <Debug> HTTP-Session: e366b7fc-1559-4e6a-8ea4-22e574d3de2d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 241 | 2024.10.09 22:40:27.769240 [ 3 ] {} <Debug> HTTP-Session: e366b7fc-1559-4e6a-8ea4-22e574d3de2d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 242 | 2024.10.09 22:40:27.769297 [ 3 ] {} <Trace> HTTP-Session: e366b7fc-1559-4e6a-8ea4-22e574d3de2d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 243 | 2024.10.09 22:40:27.769641 [ 3 ] {03ebb368-7d24-4900-b3fc-cb1b867dbd61} <Debug> executeQuery: (from [::1]:58058) /* 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:40:27.769752 [ 3 ] {03ebb368-7d24-4900-b3fc-cb1b867dbd61} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 255 | 2024.10.09 22:40:27.772315 [ 3 ] {03ebb368-7d24-4900-b3fc-cb1b867dbd61} <Debug> oximeter.measurements_bool (bea5db27-e19e-4e07-b941-12865dc8caf5): Loading data parts | ||
| 256 | 2024.10.09 22:40:27.772686 [ 3 ] {03ebb368-7d24-4900-b3fc-cb1b867dbd61} <Debug> oximeter.measurements_bool (bea5db27-e19e-4e07-b941-12865dc8caf5): There are no data parts | ||
| 257 | 2024.10.09 22:40:27.774772 [ 3 ] {03ebb368-7d24-4900-b3fc-cb1b867dbd61} <Debug> DynamicQueryHandler: Done processing query | ||
| 258 | 2024.10.09 22:40:27.774802 [ 3 ] {} <Debug> HTTP-Session: e366b7fc-1559-4e6a-8ea4-22e574d3de2d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 259 | 2024.10.09 22:40:27.785127 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 260 | 2024.10.09 22:40:27.785253 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 261 | 2024.10.09 22:40:27.785283 [ 3 ] {} <Debug> HTTP-Session: 2f8805b7-3108-40a4-90ee-baf904de8e0b Authenticating user 'default' from [::1]:58058 | ||
| 262 | 2024.10.09 22:40:27.785311 [ 3 ] {} <Debug> HTTP-Session: 2f8805b7-3108-40a4-90ee-baf904de8e0b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 263 | 2024.10.09 22:40:27.785334 [ 3 ] {} <Debug> HTTP-Session: 2f8805b7-3108-40a4-90ee-baf904de8e0b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 264 | 2024.10.09 22:40:27.785401 [ 3 ] {} <Trace> HTTP-Session: 2f8805b7-3108-40a4-90ee-baf904de8e0b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 265 | 2024.10.09 22:40:27.785735 [ 3 ] {2a33abf8-f24d-46be-ba01-8b17415e7033} <Debug> executeQuery: (from [::1]:58058) 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:40:27.785813 [ 3 ] {2a33abf8-f24d-46be-ba01-8b17415e7033} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 267 | 2024.10.09 22:40:27.788211 [ 3 ] {2a33abf8-f24d-46be-ba01-8b17415e7033} <Debug> oximeter.measurements_i8 (6fe0aea2-46fe-408e-bce2-5fb22113c706): Loading data parts | ||
| 268 | 2024.10.09 22:40:27.788569 [ 3 ] {2a33abf8-f24d-46be-ba01-8b17415e7033} <Debug> oximeter.measurements_i8 (6fe0aea2-46fe-408e-bce2-5fb22113c706): There are no data parts | ||
| 269 | 2024.10.09 22:40:27.790260 [ 3 ] {2a33abf8-f24d-46be-ba01-8b17415e7033} <Debug> DynamicQueryHandler: Done processing query | ||
| 270 | 2024.10.09 22:40:27.790291 [ 3 ] {} <Debug> HTTP-Session: 2f8805b7-3108-40a4-90ee-baf904de8e0b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2024.10.09 22:40:27.890972 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 272 | 2024.10.09 22:40:27.891091 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 273 | 2024.10.09 22:40:27.891118 [ 3 ] {} <Debug> HTTP-Session: abdc4cdd-ea1d-4428-85f4-c42a4b9ca7e0 Authenticating user 'default' from [::1]:58058 | ||
| 274 | 2024.10.09 22:40:27.891157 [ 3 ] {} <Debug> HTTP-Session: abdc4cdd-ea1d-4428-85f4-c42a4b9ca7e0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2024.10.09 22:40:27.891172 [ 3 ] {} <Debug> HTTP-Session: abdc4cdd-ea1d-4428-85f4-c42a4b9ca7e0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 276 | 2024.10.09 22:40:27.891223 [ 3 ] {} <Trace> HTTP-Session: abdc4cdd-ea1d-4428-85f4-c42a4b9ca7e0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 277 | 2024.10.09 22:40:27.891561 [ 3 ] {47ea527d-0ca9-4783-85ef-45e642ff3f39} <Debug> executeQuery: (from [::1]:58058) 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:40:27.891683 [ 3 ] {47ea527d-0ca9-4783-85ef-45e642ff3f39} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 279 | 2024.10.09 22:40:27.894036 [ 3 ] {47ea527d-0ca9-4783-85ef-45e642ff3f39} <Debug> oximeter.measurements_u8 (206ddaf9-758a-4c1b-a053-8ade0371f549): Loading data parts | ||
| 280 | 2024.10.09 22:40:27.894335 [ 3 ] {47ea527d-0ca9-4783-85ef-45e642ff3f39} <Debug> oximeter.measurements_u8 (206ddaf9-758a-4c1b-a053-8ade0371f549): There are no data parts | ||
| 281 | 2024.10.09 22:40:27.896105 [ 3 ] {47ea527d-0ca9-4783-85ef-45e642ff3f39} <Debug> DynamicQueryHandler: Done processing query | ||
| 282 | 2024.10.09 22:40:27.896133 [ 3 ] {} <Debug> HTTP-Session: abdc4cdd-ea1d-4428-85f4-c42a4b9ca7e0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.10.09 22:40:27.971035 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 284 | 2024.10.09 22:40:27.971172 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 285 | 2024.10.09 22:40:27.971201 [ 3 ] {} <Debug> HTTP-Session: 8df5a36e-dfdb-43ab-9986-add649e97fea Authenticating user 'default' from [::1]:58058 | ||
| 286 | 2024.10.09 22:40:27.971229 [ 3 ] {} <Debug> HTTP-Session: 8df5a36e-dfdb-43ab-9986-add649e97fea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 287 | 2024.10.09 22:40:27.971249 [ 3 ] {} <Debug> HTTP-Session: 8df5a36e-dfdb-43ab-9986-add649e97fea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2024.10.09 22:40:27.971305 [ 3 ] {} <Trace> HTTP-Session: 8df5a36e-dfdb-43ab-9986-add649e97fea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 289 | 2024.10.09 22:40:27.971772 [ 3 ] {43b93a66-701a-45f9-9b01-e556ce486a7b} <Debug> executeQuery: (from [::1]:58058) 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:40:27.971859 [ 3 ] {43b93a66-701a-45f9-9b01-e556ce486a7b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 291 | 2024.10.09 22:40:27.974416 [ 3 ] {43b93a66-701a-45f9-9b01-e556ce486a7b} <Debug> oximeter.measurements_i16 (6f5f02e0-691f-4c1f-9719-36cbd8dc86bb): Loading data parts | ||
| 292 | 2024.10.09 22:40:27.974742 [ 3 ] {43b93a66-701a-45f9-9b01-e556ce486a7b} <Debug> oximeter.measurements_i16 (6f5f02e0-691f-4c1f-9719-36cbd8dc86bb): There are no data parts | ||
| 293 | 2024.10.09 22:40:27.976955 [ 3 ] {43b93a66-701a-45f9-9b01-e556ce486a7b} <Debug> DynamicQueryHandler: Done processing query | ||
| 294 | 2024.10.09 22:40:27.976989 [ 3 ] {} <Debug> HTTP-Session: 8df5a36e-dfdb-43ab-9986-add649e97fea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.10.09 22:40:27.977743 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 296 | 2024.10.09 22:40:27.977819 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 297 | 2024.10.09 22:40:27.977845 [ 3 ] {} <Debug> HTTP-Session: 40ab685b-49c8-41a8-bd90-7eff8f974495 Authenticating user 'default' from [::1]:58058 | ||
| 298 | 2024.10.09 22:40:27.977880 [ 3 ] {} <Debug> HTTP-Session: 40ab685b-49c8-41a8-bd90-7eff8f974495 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 299 | 2024.10.09 22:40:27.977897 [ 3 ] {} <Debug> HTTP-Session: 40ab685b-49c8-41a8-bd90-7eff8f974495 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 300 | 2024.10.09 22:40:27.977947 [ 3 ] {} <Trace> HTTP-Session: 40ab685b-49c8-41a8-bd90-7eff8f974495 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 301 | 2024.10.09 22:40:27.978304 [ 3 ] {67e476cc-d911-4c7c-bb5f-d7705509e45b} <Debug> executeQuery: (from [::1]:58058) 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:40:27.978373 [ 3 ] {67e476cc-d911-4c7c-bb5f-d7705509e45b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 303 | 2024.10.09 22:40:27.980968 [ 3 ] {67e476cc-d911-4c7c-bb5f-d7705509e45b} <Debug> oximeter.measurements_u16 (5913dd85-a379-4906-8727-bd25cfe427a0): Loading data parts | ||
| 304 | 2024.10.09 22:40:27.981239 [ 3 ] {67e476cc-d911-4c7c-bb5f-d7705509e45b} <Debug> oximeter.measurements_u16 (5913dd85-a379-4906-8727-bd25cfe427a0): There are no data parts | ||
| 305 | 2024.10.09 22:40:27.984445 [ 3 ] {67e476cc-d911-4c7c-bb5f-d7705509e45b} <Debug> DynamicQueryHandler: Done processing query | ||
| 306 | 2024.10.09 22:40:27.984488 [ 3 ] {} <Debug> HTTP-Session: 40ab685b-49c8-41a8-bd90-7eff8f974495 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.10.09 22:40:27.986536 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 308 | 2024.10.09 22:40:27.986625 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 309 | 2024.10.09 22:40:27.986663 [ 3 ] {} <Debug> HTTP-Session: 198d20eb-e920-45bf-a830-9cf3ed01e84f Authenticating user 'default' from [::1]:58058 | ||
| 310 | 2024.10.09 22:40:27.987199 [ 3 ] {} <Debug> HTTP-Session: 198d20eb-e920-45bf-a830-9cf3ed01e84f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2024.10.09 22:40:27.987227 [ 3 ] {} <Debug> HTTP-Session: 198d20eb-e920-45bf-a830-9cf3ed01e84f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 312 | 2024.10.09 22:40:27.987290 [ 3 ] {} <Trace> HTTP-Session: 198d20eb-e920-45bf-a830-9cf3ed01e84f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 313 | 2024.10.09 22:40:27.987629 [ 3 ] {171f56c3-2e43-4540-8313-5f33de0fcc14} <Debug> executeQuery: (from [::1]:58058) 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:40:27.987708 [ 3 ] {171f56c3-2e43-4540-8313-5f33de0fcc14} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 315 | 2024.10.09 22:40:27.990302 [ 3 ] {171f56c3-2e43-4540-8313-5f33de0fcc14} <Debug> oximeter.measurements_i32 (e5c46580-5e14-43b5-908a-98f83a86915c): Loading data parts | ||
| 316 | 2024.10.09 22:40:27.990684 [ 3 ] {171f56c3-2e43-4540-8313-5f33de0fcc14} <Debug> oximeter.measurements_i32 (e5c46580-5e14-43b5-908a-98f83a86915c): There are no data parts | ||
| 317 | 2024.10.09 22:40:27.992617 [ 3 ] {171f56c3-2e43-4540-8313-5f33de0fcc14} <Debug> DynamicQueryHandler: Done processing query | ||
| 318 | 2024.10.09 22:40:27.992649 [ 3 ] {} <Debug> HTTP-Session: 198d20eb-e920-45bf-a830-9cf3ed01e84f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.10.09 22:40:27.993705 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 320 | 2024.10.09 22:40:27.993794 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 321 | 2024.10.09 22:40:27.993823 [ 3 ] {} <Debug> HTTP-Session: b05cd65f-5581-44ac-963f-53c5fd5e3a54 Authenticating user 'default' from [::1]:58058 | ||
| 322 | 2024.10.09 22:40:27.993849 [ 3 ] {} <Debug> HTTP-Session: b05cd65f-5581-44ac-963f-53c5fd5e3a54 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 323 | 2024.10.09 22:40:27.993875 [ 3 ] {} <Debug> HTTP-Session: b05cd65f-5581-44ac-963f-53c5fd5e3a54 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 324 | 2024.10.09 22:40:27.993930 [ 3 ] {} <Trace> HTTP-Session: b05cd65f-5581-44ac-963f-53c5fd5e3a54 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 325 | 2024.10.09 22:40:27.994296 [ 3 ] {9ccb8a66-b406-4b63-a48c-1178061203b4} <Debug> executeQuery: (from [::1]:58058) 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:40:27.994370 [ 3 ] {9ccb8a66-b406-4b63-a48c-1178061203b4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 327 | 2024.10.09 22:40:27.998295 [ 3 ] {9ccb8a66-b406-4b63-a48c-1178061203b4} <Debug> oximeter.measurements_u32 (48cedaf2-c6f8-46d0-b3fd-07442dd77563): Loading data parts | ||
| 328 | 2024.10.09 22:40:27.998634 [ 3 ] {9ccb8a66-b406-4b63-a48c-1178061203b4} <Debug> oximeter.measurements_u32 (48cedaf2-c6f8-46d0-b3fd-07442dd77563): There are no data parts | ||
| 329 | 2024.10.09 22:40:28.000549 [ 245 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 141.66 MiB, peak 141.67 MiB, free memory in arenas 0.00 B, will set to 146.85 MiB (RSS), difference: 5.19 MiB | ||
| 330 | 2024.10.09 22:40:28.001353 [ 3 ] {9ccb8a66-b406-4b63-a48c-1178061203b4} <Debug> DynamicQueryHandler: Done processing query | ||
| 331 | 2024.10.09 22:40:28.001397 [ 3 ] {} <Debug> HTTP-Session: b05cd65f-5581-44ac-963f-53c5fd5e3a54 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 332 | 2024.10.09 22:40:28.004326 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 333 | 2024.10.09 22:40:28.004452 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 334 | 2024.10.09 22:40:28.004482 [ 3 ] {} <Debug> HTTP-Session: 68e0aa6b-7c59-4266-8cc9-b998b1ff64ac Authenticating user 'default' from [::1]:58058 | ||
| 335 | 2024.10.09 22:40:28.004510 [ 3 ] {} <Debug> HTTP-Session: 68e0aa6b-7c59-4266-8cc9-b998b1ff64ac Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 336 | 2024.10.09 22:40:28.004533 [ 3 ] {} <Debug> HTTP-Session: 68e0aa6b-7c59-4266-8cc9-b998b1ff64ac Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 337 | 2024.10.09 22:40:28.004590 [ 3 ] {} <Trace> HTTP-Session: 68e0aa6b-7c59-4266-8cc9-b998b1ff64ac Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 338 | 2024.10.09 22:40:28.005059 [ 3 ] {0fdabea9-1471-4b62-b725-975146cd030a} <Debug> executeQuery: (from [::1]:58058) 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) | ||
| 339 | 2024.10.09 22:40:28.005149 [ 3 ] {0fdabea9-1471-4b62-b725-975146cd030a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 340 | 2024.10.09 22:40:28.008041 [ 3 ] {0fdabea9-1471-4b62-b725-975146cd030a} <Debug> oximeter.measurements_i64 (695667d9-5ed3-46cf-8454-ffec9f249264): Loading data parts | ||
| 341 | 2024.10.09 22:40:28.008411 [ 3 ] {0fdabea9-1471-4b62-b725-975146cd030a} <Debug> oximeter.measurements_i64 (695667d9-5ed3-46cf-8454-ffec9f249264): There are no data parts | ||
| 342 | 2024.10.09 22:40:28.010877 [ 3 ] {0fdabea9-1471-4b62-b725-975146cd030a} <Debug> DynamicQueryHandler: Done processing query | ||
| 343 | 2024.10.09 22:40:28.010912 [ 3 ] {} <Debug> HTTP-Session: 68e0aa6b-7c59-4266-8cc9-b998b1ff64ac Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 344 | 2024.10.09 22:40:28.017806 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 345 | 2024.10.09 22:40:28.017934 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 346 | 2024.10.09 22:40:28.017961 [ 3 ] {} <Debug> HTTP-Session: 2ec0a6f1-68df-465c-be8b-d6d012eee22d Authenticating user 'default' from [::1]:58058 | ||
| 347 | 2024.10.09 22:40:28.018005 [ 3 ] {} <Debug> HTTP-Session: 2ec0a6f1-68df-465c-be8b-d6d012eee22d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 348 | 2024.10.09 22:40:28.018022 [ 3 ] {} <Debug> HTTP-Session: 2ec0a6f1-68df-465c-be8b-d6d012eee22d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 349 | 2024.10.09 22:40:28.018080 [ 3 ] {} <Trace> HTTP-Session: 2ec0a6f1-68df-465c-be8b-d6d012eee22d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 350 | 2024.10.09 22:40:28.018458 [ 3 ] {a22490f5-03fa-4f71-87e5-a0ad56d7d408} <Debug> executeQuery: (from [::1]:58058) 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) | ||
| 351 | 2024.10.09 22:40:28.018552 [ 3 ] {a22490f5-03fa-4f71-87e5-a0ad56d7d408} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 352 | 2024.10.09 22:40:28.021069 [ 3 ] {a22490f5-03fa-4f71-87e5-a0ad56d7d408} <Debug> oximeter.measurements_u64 (51dc3f24-5866-4b08-b873-3d50c5db6a06): Loading data parts | ||
| 353 | 2024.10.09 22:40:28.021401 [ 3 ] {a22490f5-03fa-4f71-87e5-a0ad56d7d408} <Debug> oximeter.measurements_u64 (51dc3f24-5866-4b08-b873-3d50c5db6a06): There are no data parts | ||
| 354 | 2024.10.09 22:40:28.023142 [ 3 ] {a22490f5-03fa-4f71-87e5-a0ad56d7d408} <Debug> DynamicQueryHandler: Done processing query | ||
| 355 | 2024.10.09 22:40:28.023176 [ 3 ] {} <Debug> HTTP-Session: 2ec0a6f1-68df-465c-be8b-d6d012eee22d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 356 | 2024.10.09 22:40:28.024191 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 357 | 2024.10.09 22:40:28.024292 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 358 | 2024.10.09 22:40:28.024316 [ 3 ] {} <Debug> HTTP-Session: d6af4665-7196-4440-9f0d-785a8fdc7dcd Authenticating user 'default' from [::1]:58058 | ||
| 359 | 2024.10.09 22:40:28.024383 [ 3 ] {} <Debug> HTTP-Session: d6af4665-7196-4440-9f0d-785a8fdc7dcd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 360 | 2024.10.09 22:40:28.024405 [ 3 ] {} <Debug> HTTP-Session: d6af4665-7196-4440-9f0d-785a8fdc7dcd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 361 | 2024.10.09 22:40:28.024463 [ 3 ] {} <Trace> HTTP-Session: d6af4665-7196-4440-9f0d-785a8fdc7dcd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 362 | 2024.10.09 22:40:28.024775 [ 3 ] {feb68eee-bdbe-4562-ae3d-cb0baafa75b3} <Debug> executeQuery: (from [::1]:58058) 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) | ||
| 363 | 2024.10.09 22:40:28.024855 [ 3 ] {feb68eee-bdbe-4562-ae3d-cb0baafa75b3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 364 | 2024.10.09 22:40:28.027468 [ 3 ] {feb68eee-bdbe-4562-ae3d-cb0baafa75b3} <Debug> oximeter.measurements_f32 (df7d9bb6-01a2-4f73-8e0f-7d0c29610c4a): Loading data parts | ||
| 365 | 2024.10.09 22:40:28.027873 [ 3 ] {feb68eee-bdbe-4562-ae3d-cb0baafa75b3} <Debug> oximeter.measurements_f32 (df7d9bb6-01a2-4f73-8e0f-7d0c29610c4a): There are no data parts | ||
| 366 | 2024.10.09 22:40:28.029677 [ 3 ] {feb68eee-bdbe-4562-ae3d-cb0baafa75b3} <Debug> DynamicQueryHandler: Done processing query | ||
| 367 | 2024.10.09 22:40:28.029703 [ 3 ] {} <Debug> HTTP-Session: d6af4665-7196-4440-9f0d-785a8fdc7dcd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 368 | 2024.10.09 22:40:28.030847 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 369 | 2024.10.09 22:40:28.030919 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 370 | 2024.10.09 22:40:28.030941 [ 3 ] {} <Debug> HTTP-Session: 5b8340b7-5fd6-4b2d-b250-f89b15403ff9 Authenticating user 'default' from [::1]:58058 | ||
| 371 | 2024.10.09 22:40:28.030974 [ 3 ] {} <Debug> HTTP-Session: 5b8340b7-5fd6-4b2d-b250-f89b15403ff9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 372 | 2024.10.09 22:40:28.030988 [ 3 ] {} <Debug> HTTP-Session: 5b8340b7-5fd6-4b2d-b250-f89b15403ff9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 373 | 2024.10.09 22:40:28.031086 [ 3 ] {} <Trace> HTTP-Session: 5b8340b7-5fd6-4b2d-b250-f89b15403ff9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 374 | 2024.10.09 22:40:28.031467 [ 3 ] {df1be139-6316-4a8b-9b85-4c8a0e27cc9c} <Debug> executeQuery: (from [::1]:58058) 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) | ||
| 375 | 2024.10.09 22:40:28.031536 [ 3 ] {df1be139-6316-4a8b-9b85-4c8a0e27cc9c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 376 | 2024.10.09 22:40:28.033922 [ 3 ] {df1be139-6316-4a8b-9b85-4c8a0e27cc9c} <Debug> oximeter.measurements_f64 (2e36f736-5893-4425-8a65-3937f10429de): Loading data parts | ||
| 377 | 2024.10.09 22:40:28.034235 [ 3 ] {df1be139-6316-4a8b-9b85-4c8a0e27cc9c} <Debug> oximeter.measurements_f64 (2e36f736-5893-4425-8a65-3937f10429de): There are no data parts | ||
| 378 | 2024.10.09 22:40:28.035851 [ 3 ] {df1be139-6316-4a8b-9b85-4c8a0e27cc9c} <Debug> DynamicQueryHandler: Done processing query | ||
| 379 | 2024.10.09 22:40:28.035893 [ 3 ] {} <Debug> HTTP-Session: 5b8340b7-5fd6-4b2d-b250-f89b15403ff9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 380 | 2024.10.09 22:40:28.037016 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 381 | 2024.10.09 22:40:28.037099 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 382 | 2024.10.09 22:40:28.037142 [ 3 ] {} <Debug> HTTP-Session: 2d0884d4-5464-4ded-9b14-63e6ac04d684 Authenticating user 'default' from [::1]:58058 | ||
| 383 | 2024.10.09 22:40:28.037173 [ 3 ] {} <Debug> HTTP-Session: 2d0884d4-5464-4ded-9b14-63e6ac04d684 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 384 | 2024.10.09 22:40:28.037192 [ 3 ] {} <Debug> HTTP-Session: 2d0884d4-5464-4ded-9b14-63e6ac04d684 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 385 | 2024.10.09 22:40:28.037361 [ 3 ] {} <Trace> HTTP-Session: 2d0884d4-5464-4ded-9b14-63e6ac04d684 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 386 | 2024.10.09 22:40:28.037751 [ 3 ] {886f0784-5884-45c7-8fc2-0ce10ce3303f} <Debug> executeQuery: (from [::1]:58058) 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:40:28.037840 [ 3 ] {886f0784-5884-45c7-8fc2-0ce10ce3303f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 388 | 2024.10.09 22:40:28.040861 [ 3 ] {886f0784-5884-45c7-8fc2-0ce10ce3303f} <Debug> oximeter.measurements_string (3d175a3e-75b8-47e1-9f68-35bf6c2adcfc): Loading data parts | ||
| 389 | 2024.10.09 22:40:28.041198 [ 3 ] {886f0784-5884-45c7-8fc2-0ce10ce3303f} <Debug> oximeter.measurements_string (3d175a3e-75b8-47e1-9f68-35bf6c2adcfc): There are no data parts | ||
| 390 | 2024.10.09 22:40:28.043162 [ 3 ] {886f0784-5884-45c7-8fc2-0ce10ce3303f} <Debug> DynamicQueryHandler: Done processing query | ||
| 391 | 2024.10.09 22:40:28.043191 [ 3 ] {} <Debug> HTTP-Session: 2d0884d4-5464-4ded-9b14-63e6ac04d684 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 392 | 2024.10.09 22:40:28.044294 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 393 | 2024.10.09 22:40:28.044546 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 394 | 2024.10.09 22:40:28.044583 [ 3 ] {} <Debug> HTTP-Session: d7971904-f0be-48e7-bdf6-f9de4016254b Authenticating user 'default' from [::1]:58058 | ||
| 395 | 2024.10.09 22:40:28.044612 [ 3 ] {} <Debug> HTTP-Session: d7971904-f0be-48e7-bdf6-f9de4016254b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 396 | 2024.10.09 22:40:28.044640 [ 3 ] {} <Debug> HTTP-Session: d7971904-f0be-48e7-bdf6-f9de4016254b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 397 | 2024.10.09 22:40:28.044697 [ 3 ] {} <Trace> HTTP-Session: d7971904-f0be-48e7-bdf6-f9de4016254b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 398 | 2024.10.09 22:40:28.045036 [ 3 ] {a5b0dc69-9517-4b18-a0c1-5b93118781d0} <Debug> executeQuery: (from [::1]:58058) 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:40:28.045123 [ 3 ] {a5b0dc69-9517-4b18-a0c1-5b93118781d0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 407 | 2024.10.09 22:40:28.047846 [ 3 ] {a5b0dc69-9517-4b18-a0c1-5b93118781d0} <Debug> oximeter.measurements_bytes (74f6e0c9-581a-4fb7-b0e1-ecfd8c9b47d0): Loading data parts | ||
| 408 | 2024.10.09 22:40:28.048394 [ 3 ] {a5b0dc69-9517-4b18-a0c1-5b93118781d0} <Debug> oximeter.measurements_bytes (74f6e0c9-581a-4fb7-b0e1-ecfd8c9b47d0): There are no data parts | ||
| 409 | 2024.10.09 22:40:28.050340 [ 3 ] {a5b0dc69-9517-4b18-a0c1-5b93118781d0} <Debug> DynamicQueryHandler: Done processing query | ||
| 410 | 2024.10.09 22:40:28.050378 [ 3 ] {} <Debug> HTTP-Session: d7971904-f0be-48e7-bdf6-f9de4016254b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 411 | 2024.10.09 22:40:28.051253 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 412 | 2024.10.09 22:40:28.051352 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 413 | 2024.10.09 22:40:28.051385 [ 3 ] {} <Debug> HTTP-Session: 21d2e21d-e98a-456e-a026-4b00c4197020 Authenticating user 'default' from [::1]:58058 | ||
| 414 | 2024.10.09 22:40:28.051411 [ 3 ] {} <Debug> HTTP-Session: 21d2e21d-e98a-456e-a026-4b00c4197020 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 415 | 2024.10.09 22:40:28.051465 [ 3 ] {} <Debug> HTTP-Session: 21d2e21d-e98a-456e-a026-4b00c4197020 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 416 | 2024.10.09 22:40:28.051524 [ 3 ] {} <Trace> HTTP-Session: 21d2e21d-e98a-456e-a026-4b00c4197020 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 417 | 2024.10.09 22:40:28.051897 [ 3 ] {fde48689-738d-4429-a2e4-9726bf0b5209} <Debug> executeQuery: (from [::1]:58058) 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:40:28.051981 [ 3 ] {fde48689-738d-4429-a2e4-9726bf0b5209} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 419 | 2024.10.09 22:40:28.054919 [ 3 ] {fde48689-738d-4429-a2e4-9726bf0b5209} <Debug> oximeter.measurements_cumulativei64 (25936ffd-aa59-4905-b663-45ab8172147d): Loading data parts | ||
| 420 | 2024.10.09 22:40:28.055492 [ 3 ] {fde48689-738d-4429-a2e4-9726bf0b5209} <Debug> oximeter.measurements_cumulativei64 (25936ffd-aa59-4905-b663-45ab8172147d): There are no data parts | ||
| 421 | 2024.10.09 22:40:28.057425 [ 3 ] {fde48689-738d-4429-a2e4-9726bf0b5209} <Debug> DynamicQueryHandler: Done processing query | ||
| 422 | 2024.10.09 22:40:28.057466 [ 3 ] {} <Debug> HTTP-Session: 21d2e21d-e98a-456e-a026-4b00c4197020 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 423 | 2024.10.09 22:40:28.058186 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 424 | 2024.10.09 22:40:28.058297 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 425 | 2024.10.09 22:40:28.058339 [ 3 ] {} <Debug> HTTP-Session: 17a714af-4b2b-4295-a025-77b98a4237fa Authenticating user 'default' from [::1]:58058 | ||
| 426 | 2024.10.09 22:40:28.058408 [ 3 ] {} <Debug> HTTP-Session: 17a714af-4b2b-4295-a025-77b98a4237fa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 427 | 2024.10.09 22:40:28.058439 [ 3 ] {} <Debug> HTTP-Session: 17a714af-4b2b-4295-a025-77b98a4237fa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 428 | 2024.10.09 22:40:28.058507 [ 3 ] {} <Trace> HTTP-Session: 17a714af-4b2b-4295-a025-77b98a4237fa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 429 | 2024.10.09 22:40:28.058871 [ 3 ] {83aaac6b-0e34-4386-9655-d1af5caa4677} <Debug> executeQuery: (from [::1]:58058) 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:40:28.058957 [ 3 ] {83aaac6b-0e34-4386-9655-d1af5caa4677} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 431 | 2024.10.09 22:40:28.061604 [ 3 ] {83aaac6b-0e34-4386-9655-d1af5caa4677} <Debug> oximeter.measurements_cumulativeu64 (15f2d399-534c-43ca-b02a-98de3fe0b8de): Loading data parts | ||
| 432 | 2024.10.09 22:40:28.062192 [ 3 ] {83aaac6b-0e34-4386-9655-d1af5caa4677} <Debug> oximeter.measurements_cumulativeu64 (15f2d399-534c-43ca-b02a-98de3fe0b8de): There are no data parts | ||
| 433 | 2024.10.09 22:40:28.064265 [ 3 ] {83aaac6b-0e34-4386-9655-d1af5caa4677} <Debug> DynamicQueryHandler: Done processing query | ||
| 434 | 2024.10.09 22:40:28.064308 [ 3 ] {} <Debug> HTTP-Session: 17a714af-4b2b-4295-a025-77b98a4237fa Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 435 | 2024.10.09 22:40:28.065453 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 436 | 2024.10.09 22:40:28.065550 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 437 | 2024.10.09 22:40:28.065605 [ 3 ] {} <Debug> HTTP-Session: 5d6df4cb-fb6a-43ac-8be6-0b7e05528287 Authenticating user 'default' from [::1]:58058 | ||
| 438 | 2024.10.09 22:40:28.065666 [ 3 ] {} <Debug> HTTP-Session: 5d6df4cb-fb6a-43ac-8be6-0b7e05528287 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 439 | 2024.10.09 22:40:28.065685 [ 3 ] {} <Debug> HTTP-Session: 5d6df4cb-fb6a-43ac-8be6-0b7e05528287 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 440 | 2024.10.09 22:40:28.065750 [ 3 ] {} <Trace> HTTP-Session: 5d6df4cb-fb6a-43ac-8be6-0b7e05528287 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 441 | 2024.10.09 22:40:28.066178 [ 3 ] {b4de8d86-0d09-4342-bb27-dc34981dceef} <Debug> executeQuery: (from [::1]:58058) 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:40:28.066334 [ 3 ] {b4de8d86-0d09-4342-bb27-dc34981dceef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 443 | 2024.10.09 22:40:28.069910 [ 3 ] {b4de8d86-0d09-4342-bb27-dc34981dceef} <Debug> oximeter.measurements_cumulativef32 (835310e1-5eec-49bf-8d4b-ac4cf7177477): Loading data parts | ||
| 444 | 2024.10.09 22:40:28.070274 [ 3 ] {b4de8d86-0d09-4342-bb27-dc34981dceef} <Debug> oximeter.measurements_cumulativef32 (835310e1-5eec-49bf-8d4b-ac4cf7177477): There are no data parts | ||
| 445 | 2024.10.09 22:40:28.072735 [ 3 ] {b4de8d86-0d09-4342-bb27-dc34981dceef} <Debug> DynamicQueryHandler: Done processing query | ||
| 446 | 2024.10.09 22:40:28.072768 [ 3 ] {} <Debug> HTTP-Session: 5d6df4cb-fb6a-43ac-8be6-0b7e05528287 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 447 | 2024.10.09 22:40:28.073473 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 448 | 2024.10.09 22:40:28.073572 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 449 | 2024.10.09 22:40:28.073601 [ 3 ] {} <Debug> HTTP-Session: 614b5d84-5cb8-45f2-915a-8bf8ca175b2b Authenticating user 'default' from [::1]:58058 | ||
| 450 | 2024.10.09 22:40:28.073769 [ 3 ] {} <Debug> HTTP-Session: 614b5d84-5cb8-45f2-915a-8bf8ca175b2b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 451 | 2024.10.09 22:40:28.073802 [ 3 ] {} <Debug> HTTP-Session: 614b5d84-5cb8-45f2-915a-8bf8ca175b2b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 452 | 2024.10.09 22:40:28.073992 [ 3 ] {} <Trace> HTTP-Session: 614b5d84-5cb8-45f2-915a-8bf8ca175b2b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 453 | 2024.10.09 22:40:28.074349 [ 3 ] {0ef399f3-2644-4083-87fb-8b4867bc67ca} <Debug> executeQuery: (from [::1]:58058) 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:40:28.074436 [ 3 ] {0ef399f3-2644-4083-87fb-8b4867bc67ca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 455 | 2024.10.09 22:40:28.077379 [ 3 ] {0ef399f3-2644-4083-87fb-8b4867bc67ca} <Debug> oximeter.measurements_cumulativef64 (8eb5d99b-d4fc-4635-b6ca-3ecc1d03a75d): Loading data parts | ||
| 456 | 2024.10.09 22:40:28.077722 [ 3 ] {0ef399f3-2644-4083-87fb-8b4867bc67ca} <Debug> oximeter.measurements_cumulativef64 (8eb5d99b-d4fc-4635-b6ca-3ecc1d03a75d): There are no data parts | ||
| 457 | 2024.10.09 22:40:28.079841 [ 3 ] {0ef399f3-2644-4083-87fb-8b4867bc67ca} <Debug> DynamicQueryHandler: Done processing query | ||
| 458 | 2024.10.09 22:40:28.079935 [ 3 ] {} <Debug> HTTP-Session: 614b5d84-5cb8-45f2-915a-8bf8ca175b2b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 459 | 2024.10.09 22:40:28.082032 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 460 | 2024.10.09 22:40:28.082114 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 461 | 2024.10.09 22:40:28.082153 [ 3 ] {} <Debug> HTTP-Session: b2744b26-aa29-4aea-9926-b094e1e5d5eb Authenticating user 'default' from [::1]:58058 | ||
| 462 | 2024.10.09 22:40:28.082180 [ 3 ] {} <Debug> HTTP-Session: b2744b26-aa29-4aea-9926-b094e1e5d5eb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 463 | 2024.10.09 22:40:28.082197 [ 3 ] {} <Debug> HTTP-Session: b2744b26-aa29-4aea-9926-b094e1e5d5eb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 464 | 2024.10.09 22:40:28.082248 [ 3 ] {} <Trace> HTTP-Session: b2744b26-aa29-4aea-9926-b094e1e5d5eb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 465 | 2024.10.09 22:40:28.082854 [ 3 ] {698fd0d8-851e-4725-adad-4e56c8a502ee} <Debug> executeQuery: (from [::1]:58058) 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:40:28.082967 [ 3 ] {698fd0d8-851e-4725-adad-4e56c8a502ee} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 477 | 2024.10.09 22:40:28.086040 [ 3 ] {698fd0d8-851e-4725-adad-4e56c8a502ee} <Debug> oximeter.measurements_histogrami8 (460ed086-6021-4317-82a4-61c342d891b3): Loading data parts | ||
| 478 | 2024.10.09 22:40:28.086546 [ 3 ] {698fd0d8-851e-4725-adad-4e56c8a502ee} <Debug> oximeter.measurements_histogrami8 (460ed086-6021-4317-82a4-61c342d891b3): There are no data parts | ||
| 479 | 2024.10.09 22:40:28.088659 [ 3 ] {698fd0d8-851e-4725-adad-4e56c8a502ee} <Debug> DynamicQueryHandler: Done processing query | ||
| 480 | 2024.10.09 22:40:28.088692 [ 3 ] {} <Debug> HTTP-Session: b2744b26-aa29-4aea-9926-b094e1e5d5eb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 481 | 2024.10.09 22:40:28.092418 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 482 | 2024.10.09 22:40:28.092528 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 483 | 2024.10.09 22:40:28.092555 [ 3 ] {} <Debug> HTTP-Session: a054377f-7fed-4985-8672-70eb08550c3a Authenticating user 'default' from [::1]:58058 | ||
| 484 | 2024.10.09 22:40:28.092580 [ 3 ] {} <Debug> HTTP-Session: a054377f-7fed-4985-8672-70eb08550c3a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 485 | 2024.10.09 22:40:28.092595 [ 3 ] {} <Debug> HTTP-Session: a054377f-7fed-4985-8672-70eb08550c3a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 486 | 2024.10.09 22:40:28.092653 [ 3 ] {} <Trace> HTTP-Session: a054377f-7fed-4985-8672-70eb08550c3a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 487 | 2024.10.09 22:40:28.094715 [ 3 ] {6892a4cb-21a5-4195-9d2e-90102c344518} <Debug> executeQuery: (from [::1]:58058) 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:40:28.094846 [ 3 ] {6892a4cb-21a5-4195-9d2e-90102c344518} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 489 | 2024.10.09 22:40:28.100311 [ 3 ] {6892a4cb-21a5-4195-9d2e-90102c344518} <Debug> oximeter.measurements_histogramu8 (450a961b-d16e-4f88-8bc6-e29621e3ea55): Loading data parts | ||
| 490 | 2024.10.09 22:40:28.100674 [ 3 ] {6892a4cb-21a5-4195-9d2e-90102c344518} <Debug> oximeter.measurements_histogramu8 (450a961b-d16e-4f88-8bc6-e29621e3ea55): There are no data parts | ||
| 491 | 2024.10.09 22:40:28.102810 [ 3 ] {6892a4cb-21a5-4195-9d2e-90102c344518} <Debug> DynamicQueryHandler: Done processing query | ||
| 492 | 2024.10.09 22:40:28.102944 [ 3 ] {} <Debug> HTTP-Session: a054377f-7fed-4985-8672-70eb08550c3a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 493 | 2024.10.09 22:40:28.106521 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 494 | 2024.10.09 22:40:28.106617 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 495 | 2024.10.09 22:40:28.106650 [ 3 ] {} <Debug> HTTP-Session: 315c0816-9a0b-407c-8216-192e3f278ee1 Authenticating user 'default' from [::1]:58058 | ||
| 496 | 2024.10.09 22:40:28.106705 [ 3 ] {} <Debug> HTTP-Session: 315c0816-9a0b-407c-8216-192e3f278ee1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 497 | 2024.10.09 22:40:28.106720 [ 3 ] {} <Debug> HTTP-Session: 315c0816-9a0b-407c-8216-192e3f278ee1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 498 | 2024.10.09 22:40:28.106774 [ 3 ] {} <Trace> HTTP-Session: 315c0816-9a0b-407c-8216-192e3f278ee1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 499 | 2024.10.09 22:40:28.107356 [ 3 ] {6f9bff6f-61b5-4cd1-a541-a54e289e01eb} <Debug> executeQuery: (from [::1]:58058) 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:40:28.107490 [ 3 ] {6f9bff6f-61b5-4cd1-a541-a54e289e01eb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 501 | 2024.10.09 22:40:28.110753 [ 3 ] {6f9bff6f-61b5-4cd1-a541-a54e289e01eb} <Debug> oximeter.measurements_histogrami16 (728a79ba-09f7-4281-b27c-5c126a12226d): Loading data parts | ||
| 502 | 2024.10.09 22:40:28.111040 [ 3 ] {6f9bff6f-61b5-4cd1-a541-a54e289e01eb} <Debug> oximeter.measurements_histogrami16 (728a79ba-09f7-4281-b27c-5c126a12226d): There are no data parts | ||
| 503 | 2024.10.09 22:40:28.113280 [ 3 ] {6f9bff6f-61b5-4cd1-a541-a54e289e01eb} <Debug> DynamicQueryHandler: Done processing query | ||
| 504 | 2024.10.09 22:40:28.113382 [ 3 ] {} <Debug> HTTP-Session: 315c0816-9a0b-407c-8216-192e3f278ee1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 505 | 2024.10.09 22:40:28.114335 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 506 | 2024.10.09 22:40:28.114453 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 507 | 2024.10.09 22:40:28.114504 [ 3 ] {} <Debug> HTTP-Session: 0d3676b8-9723-4eb6-b106-6863717cb974 Authenticating user 'default' from [::1]:58058 | ||
| 508 | 2024.10.09 22:40:28.114533 [ 3 ] {} <Debug> HTTP-Session: 0d3676b8-9723-4eb6-b106-6863717cb974 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 509 | 2024.10.09 22:40:28.114600 [ 3 ] {} <Debug> HTTP-Session: 0d3676b8-9723-4eb6-b106-6863717cb974 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 510 | 2024.10.09 22:40:28.114667 [ 3 ] {} <Trace> HTTP-Session: 0d3676b8-9723-4eb6-b106-6863717cb974 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 511 | 2024.10.09 22:40:28.115770 [ 3 ] {07b60560-f0b4-48ff-8b1c-e25ff7f56f3d} <Debug> executeQuery: (from [::1]:58058) 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:40:28.115879 [ 3 ] {07b60560-f0b4-48ff-8b1c-e25ff7f56f3d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 513 | 2024.10.09 22:40:28.119282 [ 3 ] {07b60560-f0b4-48ff-8b1c-e25ff7f56f3d} <Debug> oximeter.measurements_histogramu16 (c3eb26ba-417b-4152-804d-ae9faa1711e1): Loading data parts | ||
| 514 | 2024.10.09 22:40:28.119661 [ 3 ] {07b60560-f0b4-48ff-8b1c-e25ff7f56f3d} <Debug> oximeter.measurements_histogramu16 (c3eb26ba-417b-4152-804d-ae9faa1711e1): There are no data parts | ||
| 515 | 2024.10.09 22:40:28.121583 [ 3 ] {07b60560-f0b4-48ff-8b1c-e25ff7f56f3d} <Debug> DynamicQueryHandler: Done processing query | ||
| 516 | 2024.10.09 22:40:28.121614 [ 3 ] {} <Debug> HTTP-Session: 0d3676b8-9723-4eb6-b106-6863717cb974 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 517 | 2024.10.09 22:40:28.123966 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 518 | 2024.10.09 22:40:28.124073 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 519 | 2024.10.09 22:40:28.124101 [ 3 ] {} <Debug> HTTP-Session: 4d343279-05f9-42f0-ba4d-7e74ceddd428 Authenticating user 'default' from [::1]:58058 | ||
| 520 | 2024.10.09 22:40:28.124127 [ 3 ] {} <Debug> HTTP-Session: 4d343279-05f9-42f0-ba4d-7e74ceddd428 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 521 | 2024.10.09 22:40:28.124151 [ 3 ] {} <Debug> HTTP-Session: 4d343279-05f9-42f0-ba4d-7e74ceddd428 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 522 | 2024.10.09 22:40:28.124204 [ 3 ] {} <Trace> HTTP-Session: 4d343279-05f9-42f0-ba4d-7e74ceddd428 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 523 | 2024.10.09 22:40:28.124846 [ 3 ] {ec1767d0-0741-4e1a-84b9-33a7d618ba33} <Debug> executeQuery: (from [::1]:58058) 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:40:28.124950 [ 3 ] {ec1767d0-0741-4e1a-84b9-33a7d618ba33} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 525 | 2024.10.09 22:40:28.127953 [ 3 ] {ec1767d0-0741-4e1a-84b9-33a7d618ba33} <Debug> oximeter.measurements_histogrami32 (9767f2f4-3fba-4cec-89ca-74cfc0e81b6b): Loading data parts | ||
| 526 | 2024.10.09 22:40:28.128320 [ 3 ] {ec1767d0-0741-4e1a-84b9-33a7d618ba33} <Debug> oximeter.measurements_histogrami32 (9767f2f4-3fba-4cec-89ca-74cfc0e81b6b): There are no data parts | ||
| 527 | 2024.10.09 22:40:28.131169 [ 3 ] {ec1767d0-0741-4e1a-84b9-33a7d618ba33} <Debug> DynamicQueryHandler: Done processing query | ||
| 528 | 2024.10.09 22:40:28.131229 [ 3 ] {} <Debug> HTTP-Session: 4d343279-05f9-42f0-ba4d-7e74ceddd428 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 529 | 2024.10.09 22:40:28.132463 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 530 | 2024.10.09 22:40:28.132542 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 531 | 2024.10.09 22:40:28.132580 [ 3 ] {} <Debug> HTTP-Session: 9dafc07e-0510-4399-a9cf-f79da2ecc821 Authenticating user 'default' from [::1]:58058 | ||
| 532 | 2024.10.09 22:40:28.132606 [ 3 ] {} <Debug> HTTP-Session: 9dafc07e-0510-4399-a9cf-f79da2ecc821 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 533 | 2024.10.09 22:40:28.132622 [ 3 ] {} <Debug> HTTP-Session: 9dafc07e-0510-4399-a9cf-f79da2ecc821 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 534 | 2024.10.09 22:40:28.132682 [ 3 ] {} <Trace> HTTP-Session: 9dafc07e-0510-4399-a9cf-f79da2ecc821 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 535 | 2024.10.09 22:40:28.133117 [ 3 ] {c3fadfdc-4205-4d88-b68c-91576501fd41} <Debug> executeQuery: (from [::1]:58058) 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:40:28.133211 [ 3 ] {c3fadfdc-4205-4d88-b68c-91576501fd41} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 537 | 2024.10.09 22:40:28.136340 [ 3 ] {c3fadfdc-4205-4d88-b68c-91576501fd41} <Debug> oximeter.measurements_histogramu32 (b08fb595-de4a-4532-901b-f48bdb49f0af): Loading data parts | ||
| 538 | 2024.10.09 22:40:28.136636 [ 3 ] {c3fadfdc-4205-4d88-b68c-91576501fd41} <Debug> oximeter.measurements_histogramu32 (b08fb595-de4a-4532-901b-f48bdb49f0af): There are no data parts | ||
| 539 | 2024.10.09 22:40:28.138602 [ 3 ] {c3fadfdc-4205-4d88-b68c-91576501fd41} <Debug> DynamicQueryHandler: Done processing query | ||
| 540 | 2024.10.09 22:40:28.138632 [ 3 ] {} <Debug> HTTP-Session: 9dafc07e-0510-4399-a9cf-f79da2ecc821 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 541 | 2024.10.09 22:40:28.139252 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 542 | 2024.10.09 22:40:28.139435 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 543 | 2024.10.09 22:40:28.139465 [ 3 ] {} <Debug> HTTP-Session: 5a9c1287-5205-4d4e-8edd-d27dc42b0d96 Authenticating user 'default' from [::1]:58058 | ||
| 544 | 2024.10.09 22:40:28.139843 [ 3 ] {} <Debug> HTTP-Session: 5a9c1287-5205-4d4e-8edd-d27dc42b0d96 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 545 | 2024.10.09 22:40:28.140343 [ 3 ] {} <Debug> HTTP-Session: 5a9c1287-5205-4d4e-8edd-d27dc42b0d96 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 546 | 2024.10.09 22:40:28.140435 [ 3 ] {} <Trace> HTTP-Session: 5a9c1287-5205-4d4e-8edd-d27dc42b0d96 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 547 | 2024.10.09 22:40:28.140907 [ 3 ] {ffc196cb-b422-4010-8930-48ce09244270} <Debug> executeQuery: (from [::1]:58058) 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:40:28.141053 [ 3 ] {ffc196cb-b422-4010-8930-48ce09244270} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 549 | 2024.10.09 22:40:28.145108 [ 3 ] {ffc196cb-b422-4010-8930-48ce09244270} <Debug> oximeter.measurements_histogrami64 (d165b9b0-b939-4c51-9606-3f855f7c8c71): Loading data parts | ||
| 550 | 2024.10.09 22:40:28.145446 [ 3 ] {ffc196cb-b422-4010-8930-48ce09244270} <Debug> oximeter.measurements_histogrami64 (d165b9b0-b939-4c51-9606-3f855f7c8c71): There are no data parts | ||
| 551 | 2024.10.09 22:40:28.147743 [ 3 ] {ffc196cb-b422-4010-8930-48ce09244270} <Debug> DynamicQueryHandler: Done processing query | ||
| 552 | 2024.10.09 22:40:28.147779 [ 3 ] {} <Debug> HTTP-Session: 5a9c1287-5205-4d4e-8edd-d27dc42b0d96 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 553 | 2024.10.09 22:40:28.148672 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 554 | 2024.10.09 22:40:28.148825 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 555 | 2024.10.09 22:40:28.148862 [ 3 ] {} <Debug> HTTP-Session: ef8058a8-8b39-435a-a60f-b10f2c72357d Authenticating user 'default' from [::1]:58058 | ||
| 556 | 2024.10.09 22:40:28.148903 [ 3 ] {} <Debug> HTTP-Session: ef8058a8-8b39-435a-a60f-b10f2c72357d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 557 | 2024.10.09 22:40:28.148920 [ 3 ] {} <Debug> HTTP-Session: ef8058a8-8b39-435a-a60f-b10f2c72357d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 558 | 2024.10.09 22:40:28.148974 [ 3 ] {} <Trace> HTTP-Session: ef8058a8-8b39-435a-a60f-b10f2c72357d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 559 | 2024.10.09 22:40:28.149429 [ 3 ] {c01cf349-544d-4f50-a33a-4df74ff1f789} <Debug> executeQuery: (from [::1]:58058) 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:40:28.149531 [ 3 ] {c01cf349-544d-4f50-a33a-4df74ff1f789} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 561 | 2024.10.09 22:40:28.152710 [ 3 ] {c01cf349-544d-4f50-a33a-4df74ff1f789} <Debug> oximeter.measurements_histogramu64 (12ce3707-0153-443c-b353-6093e6b01849): Loading data parts | ||
| 562 | 2024.10.09 22:40:28.153006 [ 3 ] {c01cf349-544d-4f50-a33a-4df74ff1f789} <Debug> oximeter.measurements_histogramu64 (12ce3707-0153-443c-b353-6093e6b01849): There are no data parts | ||
| 563 | 2024.10.09 22:40:28.154942 [ 3 ] {c01cf349-544d-4f50-a33a-4df74ff1f789} <Debug> DynamicQueryHandler: Done processing query | ||
| 564 | 2024.10.09 22:40:28.154971 [ 3 ] {} <Debug> HTTP-Session: ef8058a8-8b39-435a-a60f-b10f2c72357d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 565 | 2024.10.09 22:40:28.155661 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 566 | 2024.10.09 22:40:28.155749 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 567 | 2024.10.09 22:40:28.155773 [ 3 ] {} <Debug> HTTP-Session: cc165a8f-a41a-43c4-9d83-6887a330e120 Authenticating user 'default' from [::1]:58058 | ||
| 568 | 2024.10.09 22:40:28.155797 [ 3 ] {} <Debug> HTTP-Session: cc165a8f-a41a-43c4-9d83-6887a330e120 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 569 | 2024.10.09 22:40:28.155811 [ 3 ] {} <Debug> HTTP-Session: cc165a8f-a41a-43c4-9d83-6887a330e120 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 570 | 2024.10.09 22:40:28.155868 [ 3 ] {} <Trace> HTTP-Session: cc165a8f-a41a-43c4-9d83-6887a330e120 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 571 | 2024.10.09 22:40:28.156270 [ 3 ] {d90f523a-7530-446c-94a3-9a89e3c03254} <Debug> executeQuery: (from [::1]:58058) 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:40:28.156356 [ 3 ] {d90f523a-7530-446c-94a3-9a89e3c03254} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 573 | 2024.10.09 22:40:28.159107 [ 3 ] {d90f523a-7530-446c-94a3-9a89e3c03254} <Debug> oximeter.measurements_histogramf32 (9f6be9c5-7695-434c-a740-215519667d7e): Loading data parts | ||
| 574 | 2024.10.09 22:40:28.159415 [ 3 ] {d90f523a-7530-446c-94a3-9a89e3c03254} <Debug> oximeter.measurements_histogramf32 (9f6be9c5-7695-434c-a740-215519667d7e): There are no data parts | ||
| 575 | 2024.10.09 22:40:28.161261 [ 3 ] {d90f523a-7530-446c-94a3-9a89e3c03254} <Debug> DynamicQueryHandler: Done processing query | ||
| 576 | 2024.10.09 22:40:28.161291 [ 3 ] {} <Debug> HTTP-Session: cc165a8f-a41a-43c4-9d83-6887a330e120 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 577 | 2024.10.09 22:40:28.162041 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 578 | 2024.10.09 22:40:28.162146 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 579 | 2024.10.09 22:40:28.162172 [ 3 ] {} <Debug> HTTP-Session: 8ed246b8-0294-4477-89dc-8f822f603649 Authenticating user 'default' from [::1]:58058 | ||
| 580 | 2024.10.09 22:40:28.162213 [ 3 ] {} <Debug> HTTP-Session: 8ed246b8-0294-4477-89dc-8f822f603649 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 581 | 2024.10.09 22:40:28.162230 [ 3 ] {} <Debug> HTTP-Session: 8ed246b8-0294-4477-89dc-8f822f603649 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 582 | 2024.10.09 22:40:28.162279 [ 3 ] {} <Trace> HTTP-Session: 8ed246b8-0294-4477-89dc-8f822f603649 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 583 | 2024.10.09 22:40:28.162721 [ 3 ] {c19571ac-bed2-4137-a8eb-8fb649dd42f3} <Debug> executeQuery: (from [::1]:58058) 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:40:28.162811 [ 3 ] {c19571ac-bed2-4137-a8eb-8fb649dd42f3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 585 | 2024.10.09 22:40:28.166188 [ 3 ] {c19571ac-bed2-4137-a8eb-8fb649dd42f3} <Debug> oximeter.measurements_histogramf64 (95dd205d-2171-46b9-abce-5adea324ee1a): Loading data parts | ||
| 586 | 2024.10.09 22:40:28.166466 [ 3 ] {c19571ac-bed2-4137-a8eb-8fb649dd42f3} <Debug> oximeter.measurements_histogramf64 (95dd205d-2171-46b9-abce-5adea324ee1a): There are no data parts | ||
| 587 | 2024.10.09 22:40:28.168621 [ 3 ] {c19571ac-bed2-4137-a8eb-8fb649dd42f3} <Debug> DynamicQueryHandler: Done processing query | ||
| 588 | 2024.10.09 22:40:28.168678 [ 3 ] {} <Debug> HTTP-Session: 8ed246b8-0294-4477-89dc-8f822f603649 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 589 | 2024.10.09 22:40:28.169673 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 590 | 2024.10.09 22:40:28.169784 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 591 | 2024.10.09 22:40:28.169830 [ 3 ] {} <Debug> HTTP-Session: 635e3ff4-c243-4039-a8e0-880b2db98e1e Authenticating user 'default' from [::1]:58058 | ||
| 592 | 2024.10.09 22:40:28.169856 [ 3 ] {} <Debug> HTTP-Session: 635e3ff4-c243-4039-a8e0-880b2db98e1e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 593 | 2024.10.09 22:40:28.169872 [ 3 ] {} <Debug> HTTP-Session: 635e3ff4-c243-4039-a8e0-880b2db98e1e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 594 | 2024.10.09 22:40:28.169930 [ 3 ] {} <Trace> HTTP-Session: 635e3ff4-c243-4039-a8e0-880b2db98e1e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 595 | 2024.10.09 22:40:28.170575 [ 3 ] {eb63d541-98d5-4697-898e-6194a71bafb9} <Debug> executeQuery: (from [::1]:58058) /* 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:40:28.170697 [ 3 ] {eb63d541-98d5-4697-898e-6194a71bafb9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 622 | 2024.10.09 22:40:28.173448 [ 3 ] {eb63d541-98d5-4697-898e-6194a71bafb9} <Debug> oximeter.fields_bool (ee085e09-f931-4003-9ea3-bc3176f3b4f0): Loading data parts | ||
| 623 | 2024.10.09 22:40:28.173752 [ 3 ] {eb63d541-98d5-4697-898e-6194a71bafb9} <Debug> oximeter.fields_bool (ee085e09-f931-4003-9ea3-bc3176f3b4f0): There are no data parts | ||
| 624 | 2024.10.09 22:40:28.176022 [ 3 ] {eb63d541-98d5-4697-898e-6194a71bafb9} <Debug> DynamicQueryHandler: Done processing query | ||
| 625 | 2024.10.09 22:40:28.176056 [ 3 ] {} <Debug> HTTP-Session: 635e3ff4-c243-4039-a8e0-880b2db98e1e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 626 | 2024.10.09 22:40:28.177066 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 627 | 2024.10.09 22:40:28.177214 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 628 | 2024.10.09 22:40:28.177282 [ 3 ] {} <Debug> HTTP-Session: e423ad9c-5c82-45df-9fde-5a9f05ab44b6 Authenticating user 'default' from [::1]:58058 | ||
| 629 | 2024.10.09 22:40:28.177303 [ 3 ] {} <Debug> HTTP-Session: e423ad9c-5c82-45df-9fde-5a9f05ab44b6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 630 | 2024.10.09 22:40:28.177336 [ 3 ] {} <Debug> HTTP-Session: e423ad9c-5c82-45df-9fde-5a9f05ab44b6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 631 | 2024.10.09 22:40:28.177391 [ 3 ] {} <Trace> HTTP-Session: e423ad9c-5c82-45df-9fde-5a9f05ab44b6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 632 | 2024.10.09 22:40:28.178172 [ 3 ] {a243def1-4d8b-4fdb-b637-b75d27db1599} <Debug> executeQuery: (from [::1]:58058) 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:40:28.178346 [ 3 ] {a243def1-4d8b-4fdb-b637-b75d27db1599} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 634 | 2024.10.09 22:40:28.181601 [ 3 ] {a243def1-4d8b-4fdb-b637-b75d27db1599} <Debug> oximeter.fields_i8 (4636c5e1-7415-4b4a-9139-2a74a5a14359): Loading data parts | ||
| 635 | 2024.10.09 22:40:28.181922 [ 3 ] {a243def1-4d8b-4fdb-b637-b75d27db1599} <Debug> oximeter.fields_i8 (4636c5e1-7415-4b4a-9139-2a74a5a14359): There are no data parts | ||
| 636 | 2024.10.09 22:40:28.185588 [ 3 ] {a243def1-4d8b-4fdb-b637-b75d27db1599} <Debug> DynamicQueryHandler: Done processing query | ||
| 637 | 2024.10.09 22:40:28.185616 [ 3 ] {} <Debug> HTTP-Session: e423ad9c-5c82-45df-9fde-5a9f05ab44b6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 638 | 2024.10.09 22:40:28.188194 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 639 | 2024.10.09 22:40:28.188460 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 640 | 2024.10.09 22:40:28.188496 [ 3 ] {} <Debug> HTTP-Session: bff0ca1b-4461-45b7-a48e-fea50cccea56 Authenticating user 'default' from [::1]:58058 | ||
| 641 | 2024.10.09 22:40:28.188545 [ 3 ] {} <Debug> HTTP-Session: bff0ca1b-4461-45b7-a48e-fea50cccea56 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 642 | 2024.10.09 22:40:28.188562 [ 3 ] {} <Debug> HTTP-Session: bff0ca1b-4461-45b7-a48e-fea50cccea56 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 643 | 2024.10.09 22:40:28.188616 [ 3 ] {} <Trace> HTTP-Session: bff0ca1b-4461-45b7-a48e-fea50cccea56 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 644 | 2024.10.09 22:40:28.189649 [ 3 ] {2f568600-9b62-4061-af06-1341511d4f9f} <Debug> executeQuery: (from [::1]:58058) 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:40:28.190189 [ 3 ] {2f568600-9b62-4061-af06-1341511d4f9f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 646 | 2024.10.09 22:40:28.201913 [ 3 ] {2f568600-9b62-4061-af06-1341511d4f9f} <Debug> oximeter.fields_u8 (a5b87029-7ba7-47b5-bb0c-d97930361aec): Loading data parts | ||
| 647 | 2024.10.09 22:40:28.202324 [ 3 ] {2f568600-9b62-4061-af06-1341511d4f9f} <Debug> oximeter.fields_u8 (a5b87029-7ba7-47b5-bb0c-d97930361aec): There are no data parts | ||
| 648 | 2024.10.09 22:40:28.208458 [ 3 ] {2f568600-9b62-4061-af06-1341511d4f9f} <Debug> DynamicQueryHandler: Done processing query | ||
| 649 | 2024.10.09 22:40:28.208503 [ 3 ] {} <Debug> HTTP-Session: bff0ca1b-4461-45b7-a48e-fea50cccea56 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 650 | 2024.10.09 22:40:28.212062 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 651 | 2024.10.09 22:40:28.212236 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 652 | 2024.10.09 22:40:28.212363 [ 3 ] {} <Debug> HTTP-Session: 092449e1-46ac-4f7b-b890-d7f2d3738ee2 Authenticating user 'default' from [::1]:58058 | ||
| 653 | 2024.10.09 22:40:28.212401 [ 3 ] {} <Debug> HTTP-Session: 092449e1-46ac-4f7b-b890-d7f2d3738ee2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 654 | 2024.10.09 22:40:28.212432 [ 3 ] {} <Debug> HTTP-Session: 092449e1-46ac-4f7b-b890-d7f2d3738ee2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 655 | 2024.10.09 22:40:28.214815 [ 3 ] {} <Trace> HTTP-Session: 092449e1-46ac-4f7b-b890-d7f2d3738ee2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 656 | 2024.10.09 22:40:28.215296 [ 3 ] {40e94a03-41c1-4b18-9790-52d432298185} <Debug> executeQuery: (from [::1]:58058) 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:40:28.215401 [ 3 ] {40e94a03-41c1-4b18-9790-52d432298185} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 658 | 2024.10.09 22:40:28.240128 [ 3 ] {40e94a03-41c1-4b18-9790-52d432298185} <Debug> oximeter.fields_i16 (fd30cddd-e418-4911-9597-136a049bac2a): Loading data parts | ||
| 659 | 2024.10.09 22:40:28.240966 [ 3 ] {40e94a03-41c1-4b18-9790-52d432298185} <Debug> oximeter.fields_i16 (fd30cddd-e418-4911-9597-136a049bac2a): There are no data parts | ||
| 660 | 2024.10.09 22:40:28.243052 [ 3 ] {40e94a03-41c1-4b18-9790-52d432298185} <Debug> DynamicQueryHandler: Done processing query | ||
| 661 | 2024.10.09 22:40:28.243083 [ 3 ] {} <Debug> HTTP-Session: 092449e1-46ac-4f7b-b890-d7f2d3738ee2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 662 | 2024.10.09 22:40:28.244335 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 663 | 2024.10.09 22:40:28.244415 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 664 | 2024.10.09 22:40:28.244443 [ 3 ] {} <Debug> HTTP-Session: 238c1e10-62da-4f97-ba7e-fd5f063db57b Authenticating user 'default' from [::1]:58058 | ||
| 665 | 2024.10.09 22:40:28.244487 [ 3 ] {} <Debug> HTTP-Session: 238c1e10-62da-4f97-ba7e-fd5f063db57b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 666 | 2024.10.09 22:40:28.244504 [ 3 ] {} <Debug> HTTP-Session: 238c1e10-62da-4f97-ba7e-fd5f063db57b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 667 | 2024.10.09 22:40:28.244557 [ 3 ] {} <Trace> HTTP-Session: 238c1e10-62da-4f97-ba7e-fd5f063db57b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 668 | 2024.10.09 22:40:28.245006 [ 3 ] {a8a2b7bb-aff1-4183-b391-93d533019576} <Debug> executeQuery: (from [::1]:58058) 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:40:28.245096 [ 3 ] {a8a2b7bb-aff1-4183-b391-93d533019576} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 670 | 2024.10.09 22:40:28.247964 [ 3 ] {a8a2b7bb-aff1-4183-b391-93d533019576} <Debug> oximeter.fields_u16 (4e500963-e078-4646-ad31-a319a43cdc09): Loading data parts | ||
| 671 | 2024.10.09 22:40:28.248415 [ 3 ] {a8a2b7bb-aff1-4183-b391-93d533019576} <Debug> oximeter.fields_u16 (4e500963-e078-4646-ad31-a319a43cdc09): There are no data parts | ||
| 672 | 2024.10.09 22:40:28.251655 [ 3 ] {a8a2b7bb-aff1-4183-b391-93d533019576} <Debug> DynamicQueryHandler: Done processing query | ||
| 673 | 2024.10.09 22:40:28.251690 [ 3 ] {} <Debug> HTTP-Session: 238c1e10-62da-4f97-ba7e-fd5f063db57b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 674 | 2024.10.09 22:40:28.258942 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 675 | 2024.10.09 22:40:28.259133 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 676 | 2024.10.09 22:40:28.259167 [ 3 ] {} <Debug> HTTP-Session: 501b9e1a-9322-4b6e-a91f-bb2544808d5f Authenticating user 'default' from [::1]:58058 | ||
| 677 | 2024.10.09 22:40:28.259196 [ 3 ] {} <Debug> HTTP-Session: 501b9e1a-9322-4b6e-a91f-bb2544808d5f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 678 | 2024.10.09 22:40:28.259213 [ 3 ] {} <Debug> HTTP-Session: 501b9e1a-9322-4b6e-a91f-bb2544808d5f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 679 | 2024.10.09 22:40:28.259279 [ 3 ] {} <Trace> HTTP-Session: 501b9e1a-9322-4b6e-a91f-bb2544808d5f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 680 | 2024.10.09 22:40:28.259767 [ 3 ] {4c8422c8-4f54-4841-bf4c-ef52feebecc8} <Debug> executeQuery: (from [::1]:58058) 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:40:28.260653 [ 3 ] {4c8422c8-4f54-4841-bf4c-ef52feebecc8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 682 | 2024.10.09 22:40:28.263733 [ 3 ] {4c8422c8-4f54-4841-bf4c-ef52feebecc8} <Debug> oximeter.fields_i32 (a9d431fe-6b4c-4996-84aa-5996c1e58333): Loading data parts | ||
| 683 | 2024.10.09 22:40:28.264029 [ 3 ] {4c8422c8-4f54-4841-bf4c-ef52feebecc8} <Debug> oximeter.fields_i32 (a9d431fe-6b4c-4996-84aa-5996c1e58333): There are no data parts | ||
| 684 | 2024.10.09 22:40:28.266147 [ 3 ] {4c8422c8-4f54-4841-bf4c-ef52feebecc8} <Debug> DynamicQueryHandler: Done processing query | ||
| 685 | 2024.10.09 22:40:28.266176 [ 3 ] {} <Debug> HTTP-Session: 501b9e1a-9322-4b6e-a91f-bb2544808d5f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 686 | 2024.10.09 22:40:28.267304 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 687 | 2024.10.09 22:40:28.267418 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 688 | 2024.10.09 22:40:28.267558 [ 3 ] {} <Debug> HTTP-Session: 55986f5e-1c5a-414c-81fe-c64f0c534d34 Authenticating user 'default' from [::1]:58058 | ||
| 689 | 2024.10.09 22:40:28.267602 [ 3 ] {} <Debug> HTTP-Session: 55986f5e-1c5a-414c-81fe-c64f0c534d34 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 690 | 2024.10.09 22:40:28.267620 [ 3 ] {} <Debug> HTTP-Session: 55986f5e-1c5a-414c-81fe-c64f0c534d34 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 691 | 2024.10.09 22:40:28.267676 [ 3 ] {} <Trace> HTTP-Session: 55986f5e-1c5a-414c-81fe-c64f0c534d34 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 692 | 2024.10.09 22:40:28.268031 [ 3 ] {acc524fa-9e37-40cf-ba5c-7999c8daebac} <Debug> executeQuery: (from [::1]:58058) 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:40:28.268258 [ 3 ] {acc524fa-9e37-40cf-ba5c-7999c8daebac} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 694 | 2024.10.09 22:40:28.271290 [ 3 ] {acc524fa-9e37-40cf-ba5c-7999c8daebac} <Debug> oximeter.fields_u32 (d52d1f07-bf60-4621-be5c-3c4427bcde44): Loading data parts | ||
| 695 | 2024.10.09 22:40:28.272859 [ 3 ] {acc524fa-9e37-40cf-ba5c-7999c8daebac} <Debug> oximeter.fields_u32 (d52d1f07-bf60-4621-be5c-3c4427bcde44): There are no data parts | ||
| 696 | 2024.10.09 22:40:28.275271 [ 3 ] {acc524fa-9e37-40cf-ba5c-7999c8daebac} <Debug> DynamicQueryHandler: Done processing query | ||
| 697 | 2024.10.09 22:40:28.275447 [ 3 ] {} <Debug> HTTP-Session: 55986f5e-1c5a-414c-81fe-c64f0c534d34 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 698 | 2024.10.09 22:40:28.277203 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 699 | 2024.10.09 22:40:28.277292 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 700 | 2024.10.09 22:40:28.277343 [ 3 ] {} <Debug> HTTP-Session: 5d2a5d01-1895-41d8-b3f9-9ea725e74cd0 Authenticating user 'default' from [::1]:58058 | ||
| 701 | 2024.10.09 22:40:28.277391 [ 3 ] {} <Debug> HTTP-Session: 5d2a5d01-1895-41d8-b3f9-9ea725e74cd0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 702 | 2024.10.09 22:40:28.277411 [ 3 ] {} <Debug> HTTP-Session: 5d2a5d01-1895-41d8-b3f9-9ea725e74cd0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 703 | 2024.10.09 22:40:28.277473 [ 3 ] {} <Trace> HTTP-Session: 5d2a5d01-1895-41d8-b3f9-9ea725e74cd0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 704 | 2024.10.09 22:40:28.277964 [ 3 ] {6a27db9d-da50-4d14-a61d-ae4adac3d135} <Debug> executeQuery: (from [::1]:58058) 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:40:28.278063 [ 3 ] {6a27db9d-da50-4d14-a61d-ae4adac3d135} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 706 | 2024.10.09 22:40:28.281261 [ 3 ] {6a27db9d-da50-4d14-a61d-ae4adac3d135} <Debug> oximeter.fields_i64 (8d0713c2-b721-403d-9852-47bec709e4cc): Loading data parts | ||
| 707 | 2024.10.09 22:40:28.282062 [ 3 ] {6a27db9d-da50-4d14-a61d-ae4adac3d135} <Debug> oximeter.fields_i64 (8d0713c2-b721-403d-9852-47bec709e4cc): There are no data parts | ||
| 708 | 2024.10.09 22:40:28.284840 [ 3 ] {6a27db9d-da50-4d14-a61d-ae4adac3d135} <Debug> DynamicQueryHandler: Done processing query | ||
| 709 | 2024.10.09 22:40:28.284878 [ 3 ] {} <Debug> HTTP-Session: 5d2a5d01-1895-41d8-b3f9-9ea725e74cd0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 710 | 2024.10.09 22:40:28.288077 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 711 | 2024.10.09 22:40:28.288447 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 712 | 2024.10.09 22:40:28.288486 [ 3 ] {} <Debug> HTTP-Session: 91970292-dc4a-401d-88eb-f920cec62e5c Authenticating user 'default' from [::1]:58058 | ||
| 713 | 2024.10.09 22:40:28.288514 [ 3 ] {} <Debug> HTTP-Session: 91970292-dc4a-401d-88eb-f920cec62e5c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 714 | 2024.10.09 22:40:28.288530 [ 3 ] {} <Debug> HTTP-Session: 91970292-dc4a-401d-88eb-f920cec62e5c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 715 | 2024.10.09 22:40:28.288588 [ 3 ] {} <Trace> HTTP-Session: 91970292-dc4a-401d-88eb-f920cec62e5c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 716 | 2024.10.09 22:40:28.288970 [ 3 ] {06ce59b6-6b7f-4b3e-938e-77147d513ef8} <Debug> executeQuery: (from [::1]:58058) 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:40:28.289051 [ 3 ] {06ce59b6-6b7f-4b3e-938e-77147d513ef8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 718 | 2024.10.09 22:40:28.292482 [ 3 ] {06ce59b6-6b7f-4b3e-938e-77147d513ef8} <Debug> oximeter.fields_u64 (cb33d557-b8c5-4f50-9121-aef1c9076b6b): Loading data parts | ||
| 719 | 2024.10.09 22:40:28.292834 [ 3 ] {06ce59b6-6b7f-4b3e-938e-77147d513ef8} <Debug> oximeter.fields_u64 (cb33d557-b8c5-4f50-9121-aef1c9076b6b): There are no data parts | ||
| 720 | 2024.10.09 22:40:28.296049 [ 3 ] {06ce59b6-6b7f-4b3e-938e-77147d513ef8} <Debug> DynamicQueryHandler: Done processing query | ||
| 721 | 2024.10.09 22:40:28.296085 [ 3 ] {} <Debug> HTTP-Session: 91970292-dc4a-401d-88eb-f920cec62e5c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 722 | 2024.10.09 22:40:28.300661 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 723 | 2024.10.09 22:40:28.300754 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 724 | 2024.10.09 22:40:28.300775 [ 3 ] {} <Debug> HTTP-Session: 8f37c083-706e-44ef-8566-ea899d13518d Authenticating user 'default' from [::1]:58058 | ||
| 725 | 2024.10.09 22:40:28.300797 [ 3 ] {} <Debug> HTTP-Session: 8f37c083-706e-44ef-8566-ea899d13518d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 726 | 2024.10.09 22:40:28.300811 [ 3 ] {} <Debug> HTTP-Session: 8f37c083-706e-44ef-8566-ea899d13518d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 727 | 2024.10.09 22:40:28.300855 [ 3 ] {} <Trace> HTTP-Session: 8f37c083-706e-44ef-8566-ea899d13518d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 728 | 2024.10.09 22:40:28.301207 [ 3 ] {44ff7428-79a9-49ae-a569-ff7e17ad7c60} <Debug> executeQuery: (from [::1]:58058) 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:40:28.301309 [ 3 ] {44ff7428-79a9-49ae-a569-ff7e17ad7c60} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 730 | 2024.10.09 22:40:28.304437 [ 3 ] {44ff7428-79a9-49ae-a569-ff7e17ad7c60} <Debug> oximeter.fields_ipaddr (92435ff8-8654-4287-991b-24a00386b9cc): Loading data parts | ||
| 731 | 2024.10.09 22:40:28.306512 [ 3 ] {44ff7428-79a9-49ae-a569-ff7e17ad7c60} <Debug> oximeter.fields_ipaddr (92435ff8-8654-4287-991b-24a00386b9cc): There are no data parts | ||
| 732 | 2024.10.09 22:40:28.309590 [ 3 ] {44ff7428-79a9-49ae-a569-ff7e17ad7c60} <Debug> DynamicQueryHandler: Done processing query | ||
| 733 | 2024.10.09 22:40:28.309623 [ 3 ] {} <Debug> HTTP-Session: 8f37c083-706e-44ef-8566-ea899d13518d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2024.10.09 22:40:28.311759 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 735 | 2024.10.09 22:40:28.311836 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 736 | 2024.10.09 22:40:28.311859 [ 3 ] {} <Debug> HTTP-Session: 4367768a-fa4e-4805-b47f-8b20fb8e3547 Authenticating user 'default' from [::1]:58058 | ||
| 737 | 2024.10.09 22:40:28.311881 [ 3 ] {} <Debug> HTTP-Session: 4367768a-fa4e-4805-b47f-8b20fb8e3547 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 738 | 2024.10.09 22:40:28.311896 [ 3 ] {} <Debug> HTTP-Session: 4367768a-fa4e-4805-b47f-8b20fb8e3547 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 739 | 2024.10.09 22:40:28.311939 [ 3 ] {} <Trace> HTTP-Session: 4367768a-fa4e-4805-b47f-8b20fb8e3547 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 740 | 2024.10.09 22:40:28.312223 [ 3 ] {02b08f62-4c06-48e6-b542-1594c0c09943} <Debug> executeQuery: (from [::1]:58058) 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:40:28.312288 [ 3 ] {02b08f62-4c06-48e6-b542-1594c0c09943} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 742 | 2024.10.09 22:40:28.316390 [ 3 ] {02b08f62-4c06-48e6-b542-1594c0c09943} <Debug> oximeter.fields_string (a079241f-9a85-48da-89b9-dd84c5953e4a): Loading data parts | ||
| 743 | 2024.10.09 22:40:28.316765 [ 3 ] {02b08f62-4c06-48e6-b542-1594c0c09943} <Debug> oximeter.fields_string (a079241f-9a85-48da-89b9-dd84c5953e4a): There are no data parts | ||
| 744 | 2024.10.09 22:40:28.322260 [ 3 ] {02b08f62-4c06-48e6-b542-1594c0c09943} <Debug> DynamicQueryHandler: Done processing query | ||
| 745 | 2024.10.09 22:40:28.322297 [ 3 ] {} <Debug> HTTP-Session: 4367768a-fa4e-4805-b47f-8b20fb8e3547 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 746 | 2024.10.09 22:40:28.325305 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 747 | 2024.10.09 22:40:28.325420 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 748 | 2024.10.09 22:40:28.325447 [ 3 ] {} <Debug> HTTP-Session: cd509985-5c99-42e3-89ea-d990ecc6651f Authenticating user 'default' from [::1]:58058 | ||
| 749 | 2024.10.09 22:40:28.325526 [ 3 ] {} <Debug> HTTP-Session: cd509985-5c99-42e3-89ea-d990ecc6651f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 750 | 2024.10.09 22:40:28.325545 [ 3 ] {} <Debug> HTTP-Session: cd509985-5c99-42e3-89ea-d990ecc6651f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 751 | 2024.10.09 22:40:28.325773 [ 3 ] {} <Trace> HTTP-Session: cd509985-5c99-42e3-89ea-d990ecc6651f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 752 | 2024.10.09 22:40:28.326240 [ 3 ] {9cfe4ef0-7349-453f-ba05-342de2b4c21c} <Debug> executeQuery: (from [::1]:58058) 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:40:28.326324 [ 3 ] {9cfe4ef0-7349-453f-ba05-342de2b4c21c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 754 | 2024.10.09 22:40:28.330305 [ 3 ] {9cfe4ef0-7349-453f-ba05-342de2b4c21c} <Debug> oximeter.fields_uuid (b6becb69-1536-4656-98c8-7746d05371ef): Loading data parts | ||
| 755 | 2024.10.09 22:40:28.330760 [ 3 ] {9cfe4ef0-7349-453f-ba05-342de2b4c21c} <Debug> oximeter.fields_uuid (b6becb69-1536-4656-98c8-7746d05371ef): There are no data parts | ||
| 756 | 2024.10.09 22:40:28.335142 [ 3 ] {9cfe4ef0-7349-453f-ba05-342de2b4c21c} <Debug> DynamicQueryHandler: Done processing query | ||
| 757 | 2024.10.09 22:40:28.335177 [ 3 ] {} <Debug> HTTP-Session: cd509985-5c99-42e3-89ea-d990ecc6651f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 758 | 2024.10.09 22:40:28.339685 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 759 | 2024.10.09 22:40:28.339778 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 760 | 2024.10.09 22:40:28.339798 [ 3 ] {} <Debug> HTTP-Session: 93b698c3-5ae7-44af-a9fe-45c2736a3dcc Authenticating user 'default' from [::1]:58058 | ||
| 761 | 2024.10.09 22:40:28.339817 [ 3 ] {} <Debug> HTTP-Session: 93b698c3-5ae7-44af-a9fe-45c2736a3dcc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 762 | 2024.10.09 22:40:28.339829 [ 3 ] {} <Debug> HTTP-Session: 93b698c3-5ae7-44af-a9fe-45c2736a3dcc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 763 | 2024.10.09 22:40:28.339871 [ 3 ] {} <Trace> HTTP-Session: 93b698c3-5ae7-44af-a9fe-45c2736a3dcc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 764 | 2024.10.09 22:40:28.340416 [ 3 ] {018f8976-0e50-4447-8bcb-0ff7181f968f} <Debug> executeQuery: (from [::1]:58058) /* 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:40:28.340502 [ 3 ] {018f8976-0e50-4447-8bcb-0ff7181f968f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 769 | 2024.10.09 22:40:28.344635 [ 3 ] {018f8976-0e50-4447-8bcb-0ff7181f968f} <Debug> oximeter.timeseries_schema (2d0d7ab6-3525-4b49-8071-c729e9ec0922): Loading data parts | ||
| 770 | 2024.10.09 22:40:28.345045 [ 3 ] {018f8976-0e50-4447-8bcb-0ff7181f968f} <Debug> oximeter.timeseries_schema (2d0d7ab6-3525-4b49-8071-c729e9ec0922): There are no data parts | ||
| 771 | 2024.10.09 22:40:28.348851 [ 3 ] {018f8976-0e50-4447-8bcb-0ff7181f968f} <Debug> DynamicQueryHandler: Done processing query | ||
| 772 | 2024.10.09 22:40:28.351421 [ 3 ] {} <Debug> HTTP-Session: 93b698c3-5ae7-44af-a9fe-45c2736a3dcc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 773 | 2024.10.09 22:40:28.353461 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:58058, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 774 | 2024.10.09 22:40:28.353936 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 775 | 2024.10.09 22:40:28.353988 [ 3 ] {} <Debug> HTTP-Session: a2c001dc-39cd-4086-9ba2-d004fbc61846 Authenticating user 'default' from [::1]:58058 | ||
| 776 | 2024.10.09 22:40:28.354016 [ 3 ] {} <Debug> HTTP-Session: a2c001dc-39cd-4086-9ba2-d004fbc61846 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 777 | 2024.10.09 22:40:28.354034 [ 3 ] {} <Debug> HTTP-Session: a2c001dc-39cd-4086-9ba2-d004fbc61846 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 778 | 2024.10.09 22:40:28.354084 [ 3 ] {} <Trace> HTTP-Session: a2c001dc-39cd-4086-9ba2-d004fbc61846 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 779 | 2024.10.09 22:40:28.354312 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Debug> executeQuery: (from [::1]:58058) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 780 | 2024.10.09 22:40:28.354539 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 781 | 2024.10.09 22:40:28.356794 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Trace> oximeter.version (ddfac6e7-dc14-45c8-902c-8ebc63ee60fc): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 782 | 2024.10.09 22:40:28.356953 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.24 GiB. | ||
| 783 | 2024.10.09 22:40:28.358384 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 784 | 2024.10.09 22:40:28.359153 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Trace> oximeter.version (ddfac6e7-dc14-45c8-902c-8ebc63ee60fc): 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:40:28.359623 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.005397 sec., 185.2881230313137 rows/sec., 2.90 KiB/sec. | ||
| 786 | 2024.10.09 22:40:28.360413 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Debug> DynamicQueryHandler: Done processing query | ||
| 787 | 2024.10.09 22:40:28.360446 [ 3 ] {36272809-7bfe-44d5-b2fa-9d26c6f142c3} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 788 | 2024.10.09 22:40:28.360467 [ 3 ] {} <Debug> HTTP-Session: a2c001dc-39cd-4086-9ba2-d004fbc61846 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 789 | 2024.10.09 22:40:30.094573 [ 14 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 790 | 2024.10.09 22:40:30.094630 [ 14 ] {} <Debug> DNSResolver: Updated DNS cache | ||