| 1 | 2024.10.09 22:39:14.473149 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 14857 | ||
| 2 | 2024.10.09 22:39:14.474273 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.10.09 22:39:14.474354 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.10.09 22:39:14.487048 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.10.09 22:39:14.490641 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.10.09 22:39:14.490678 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.10.09 22:39:14.490692 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2024.10.09 22:39:14.490781 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_region_allocation_strategy_random_is_idempotent_arbitrary.14845.1-clickhouse-gvzDdw/datastore/tmp/ to store temporary data in it | ||
| 9 | 2024.10.09 22:39:14.491273 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.10.09 22:39:14.492115 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.10.09 22:39:14.492670 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 2024.10.09 22:39:14.493311 [ 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:39:14.493343 [ 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:39:14.493365 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.10.09 22:39:14.493465 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.10.09 22:39:14.494422 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.10.09 22:39:14.504103 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.10.09 22:39:14.504918 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2024.10.09 22:39:14.529792 [ 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:39:14.529862 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.10.09 22:39:14.532412 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.10.09 22:39:14.533227 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.10.09 22:39:14.535640 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.10.09 22:39:14.537282 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 2024.10.09 22:39:14.538927 [ 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:39:14.539413 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.10.09 22:39:14.539841 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2024.10.09 22:39:14.540231 [ 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:39:14.541422 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2024.10.09 22:39:14.541459 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_region_allocation_strategy_random_is_idempotent_arbitrary.14845.1-clickhouse-gvzDdw/datastore/ | ||
| 31 | 2024.10.09 22:39:14.542671 [ 138 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 32 | 2024.10.09 22:39:14.542795 [ 138 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 33 | 2024.10.09 22:39:14.575377 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 34 | 2024.10.09 22:39:14.575411 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000174172 sec | ||
| 35 | 2024.10.09 22:39:14.575446 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 36 | 2024.10.09 22:39:14.575458 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 37 | 2024.10.09 22:39:14.575596 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 38 | 2024.10.09 22:39:14.575653 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 39 | 2024.10.09 22:39:14.575669 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 40 | 2024.10.09 22:39:14.575699 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 41 | 2024.10.09 22:39:14.575719 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 42 | 2024.10.09 22:39:14.575732 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 43 | 2024.10.09 22:39:14.575760 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 44 | 2024.10.09 22:39:14.575780 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 45 | 2024.10.09 22:39:14.575793 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 46 | 2024.10.09 22:39:14.575823 [ 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:39:14.575841 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 48 | 2024.10.09 22:39:14.575854 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 49 | 2024.10.09 22:39:14.575866 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 50 | 2024.10.09 22:39:14.575900 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2024.10.09 22:39:14.575915 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 2024.10.09 22:39:14.575929 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 53 | 2024.10.09 22:39:14.576444 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 54 | 2024.10.09 22:39:14.576695 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 55 | 2024.10.09 22:39:14.716038 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.10.09 22:39:14.720457 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.10.09 22:39:14.720494 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.2296e-05 sec | ||
| 58 | 2024.10.09 22:39:14.720507 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.10.09 22:39:14.720517 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.10.09 22:39:14.720541 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2024.10.09 22:39:14.720717 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_region_allocation_strategy_random_is_idempotent_arbitrary.14845.1-clickhouse-gvzDdw/datastore/user_defined/ | ||
| 62 | 2024.10.09 22:39:14.720774 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.10.09 22:39:14.720789 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2024.10.09 22:39:14.720800 [ 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:39:14.720815 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.10.09 22:39:14.721183 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 33406 | ||
| 67 | 2024.10.09 22:39:14.721406 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 50704 | ||
| 68 | 2024.10.09 22:39:14.724516 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1) | ||
| 69 | 2024.10.09 22:39:14.846507 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1) | ||
| 70 | 2024.10.09 22:39:14.846550 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 71 | 2024.10.09 22:39:15.071693 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 61023 | ||
| 72 | 2024.10.09 22:39:15.071792 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 43695 | ||
| 73 | 2024.10.09 22:39:15.071899 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1) | ||
| 74 | 2024.10.09 22:39:15.130657 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1) | ||
| 75 | 2024.10.09 22:39:15.130703 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 76 | 2024.10.09 22:39:15.249416 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 77 | 2024.10.09 22:39:15.249707 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 15.66 MiB, free memory in arenas 0.00 B, will set to 178.72 MiB (RSS), difference: 168.82 MiB | ||
| 78 | 2024.10.09 22:39:15.250105 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.9088e-05 sec. | ||
| 79 | 2024.10.09 22:39:15.250498 [ 1 ] {} <Information> Application: Listening for http://[::1]:33406 | ||
| 80 | 2024.10.09 22:39:15.250580 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:50704 | ||
| 81 | 2024.10.09 22:39:15.250630 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004 | ||
| 82 | 2024.10.09 22:39:15.250691 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:61023 | ||
| 83 | 2024.10.09 22:39:15.250754 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:43695 | ||
| 84 | 2024.10.09 22:39:15.250798 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004 | ||
| 85 | 2024.10.09 22:39:15.250813 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 86 | 2024.10.09 22:39:28.485818 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 87 | 2024.10.09 22:39:28.486010 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 88 | 2024.10.09 22:39:28.486057 [ 3 ] {} <Debug> HTTP-Session: 7404f394-37da-4dce-931d-d397b0338231 Authenticating user 'default' from [::1]:35174 | ||
| 89 | 2024.10.09 22:39:28.486085 [ 3 ] {} <Debug> HTTP-Session: 7404f394-37da-4dce-931d-d397b0338231 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 90 | 2024.10.09 22:39:28.486099 [ 3 ] {} <Debug> HTTP-Session: 7404f394-37da-4dce-931d-d397b0338231 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2024.10.09 22:39:28.486195 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 92 | 2024.10.09 22:39:28.486235 [ 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 | ||
| 93 | 2024.10.09 22:39:28.486256 [ 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 | ||
| 94 | 2024.10.09 22:39:28.486299 [ 3 ] {} <Trace> HTTP-Session: 7404f394-37da-4dce-931d-d397b0338231 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 95 | 2024.10.09 22:39:28.486758 [ 3 ] {dac27713-f15f-44d3-aa16-02a38d70118b} <Debug> executeQuery: (from [::1]:35174) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 96 | 2024.10.09 22:39:28.494844 [ 3 ] {dac27713-f15f-44d3-aa16-02a38d70118b} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:35174) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 97 | |||
| 98 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 99 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 100 | 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 | ||
| 101 | 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 | ||
| 102 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 103 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 104 | 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 | ||
| 105 | 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 | ||
| 106 | 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 | ||
| 107 | 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 | ||
| 108 | 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 | ||
| 109 | 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 | ||
| 110 | 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 | ||
| 111 | 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 | ||
| 112 | 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 | ||
| 113 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 114 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 115 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 116 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 117 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 118 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 119 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 120 | |||
| 121 | 2024.10.09 22:39:28.495113 [ 3 ] {dac27713-f15f-44d3-aa16-02a38d70118b} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 122 | |||
| 123 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 124 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 125 | 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 | ||
| 126 | 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 | ||
| 127 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 128 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 129 | 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 | ||
| 130 | 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 | ||
| 131 | 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 | ||
| 132 | 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 | ||
| 133 | 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 | ||
| 134 | 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 | ||
| 135 | 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 | ||
| 136 | 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 | ||
| 137 | 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 | ||
| 138 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 139 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 140 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 141 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 142 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 143 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 144 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 145 | (version 23.8.7.1) | ||
| 146 | 2024.10.09 22:39:28.495426 [ 3 ] {} <Debug> HTTP-Session: 7404f394-37da-4dce-931d-d397b0338231 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2024.10.09 22:39:28.498054 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 148 | 2024.10.09 22:39:28.498162 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 149 | 2024.10.09 22:39:28.498189 [ 3 ] {} <Debug> HTTP-Session: b1d5e6b3-6773-4c0e-af1d-521cf33dd37a Authenticating user 'default' from [::1]:35174 | ||
| 150 | 2024.10.09 22:39:28.498224 [ 3 ] {} <Debug> HTTP-Session: b1d5e6b3-6773-4c0e-af1d-521cf33dd37a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 151 | 2024.10.09 22:39:28.498239 [ 3 ] {} <Debug> HTTP-Session: b1d5e6b3-6773-4c0e-af1d-521cf33dd37a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 152 | 2024.10.09 22:39:28.498294 [ 3 ] {} <Trace> HTTP-Session: b1d5e6b3-6773-4c0e-af1d-521cf33dd37a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 153 | 2024.10.09 22:39:28.498539 [ 3 ] {98d4cb87-a6b0-4788-b4e0-e9740b4d5bd1} <Debug> executeQuery: (from [::1]:35174) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 154 | 2024.10.09 22:39:28.498943 [ 3 ] {98d4cb87-a6b0-4788-b4e0-e9740b4d5bd1} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:35174) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 155 | |||
| 156 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 157 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 158 | 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 | ||
| 159 | 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 | ||
| 160 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 161 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 162 | 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 | ||
| 163 | 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 | ||
| 164 | 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 | ||
| 165 | 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 | ||
| 166 | 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 | ||
| 167 | 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 | ||
| 168 | 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 | ||
| 169 | 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 | ||
| 170 | 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 | ||
| 171 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 172 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 173 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 174 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 175 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 176 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 177 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 178 | |||
| 179 | 2024.10.09 22:39:28.499101 [ 3 ] {98d4cb87-a6b0-4788-b4e0-e9740b4d5bd1} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 180 | |||
| 181 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 182 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 183 | 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 | ||
| 184 | 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 | ||
| 185 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 186 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 187 | 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 | ||
| 188 | 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 | ||
| 189 | 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 | ||
| 190 | 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 | ||
| 191 | 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 | ||
| 192 | 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 | ||
| 193 | 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 | ||
| 194 | 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 | ||
| 195 | 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 | ||
| 196 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 197 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 198 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 199 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 200 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 201 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 202 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 203 | (version 23.8.7.1) | ||
| 204 | 2024.10.09 22:39:28.499287 [ 3 ] {} <Debug> HTTP-Session: b1d5e6b3-6773-4c0e-af1d-521cf33dd37a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 205 | 2024.10.09 22:39:28.503430 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 206 | 2024.10.09 22:39:28.503545 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 207 | 2024.10.09 22:39:28.503570 [ 3 ] {} <Debug> HTTP-Session: be0a5370-ad97-4b3b-80e8-e68acd716d58 Authenticating user 'default' from [::1]:35174 | ||
| 208 | 2024.10.09 22:39:28.503610 [ 3 ] {} <Debug> HTTP-Session: be0a5370-ad97-4b3b-80e8-e68acd716d58 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 209 | 2024.10.09 22:39:28.503624 [ 3 ] {} <Debug> HTTP-Session: be0a5370-ad97-4b3b-80e8-e68acd716d58 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 210 | 2024.10.09 22:39:28.503677 [ 3 ] {} <Trace> HTTP-Session: be0a5370-ad97-4b3b-80e8-e68acd716d58 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 211 | 2024.10.09 22:39:28.503915 [ 3 ] {20315a17-dd71-45ee-b07c-bfacdfe83e60} <Debug> executeQuery: (from [::1]:35174) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 212 | 2024.10.09 22:39:28.504152 [ 3 ] {20315a17-dd71-45ee-b07c-bfacdfe83e60} <Debug> DynamicQueryHandler: Done processing query | ||
| 213 | 2024.10.09 22:39:28.504178 [ 3 ] {} <Debug> HTTP-Session: be0a5370-ad97-4b3b-80e8-e68acd716d58 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 214 | 2024.10.09 22:39:28.509231 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 215 | 2024.10.09 22:39:28.509341 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 216 | 2024.10.09 22:39:28.509365 [ 3 ] {} <Debug> HTTP-Session: 2439acbe-8097-4bcd-bbef-9813abe54753 Authenticating user 'default' from [::1]:35174 | ||
| 217 | 2024.10.09 22:39:28.509405 [ 3 ] {} <Debug> HTTP-Session: 2439acbe-8097-4bcd-bbef-9813abe54753 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 218 | 2024.10.09 22:39:28.509422 [ 3 ] {} <Debug> HTTP-Session: 2439acbe-8097-4bcd-bbef-9813abe54753 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 219 | 2024.10.09 22:39:28.509472 [ 3 ] {} <Trace> HTTP-Session: 2439acbe-8097-4bcd-bbef-9813abe54753 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 220 | 2024.10.09 22:39:28.509657 [ 3 ] {ff40564f-eaff-418f-9a3f-82bc216a4d66} <Debug> executeQuery: (from [::1]:35174) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 221 | 2024.10.09 22:39:28.509743 [ 3 ] {ff40564f-eaff-418f-9a3f-82bc216a4d66} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 222 | 2024.10.09 22:39:28.511314 [ 3 ] {ff40564f-eaff-418f-9a3f-82bc216a4d66} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 223 | 2024.10.09 22:39:28.511349 [ 3 ] {ff40564f-eaff-418f-9a3f-82bc216a4d66} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.3746e-05 sec | ||
| 224 | 2024.10.09 22:39:28.511372 [ 3 ] {ff40564f-eaff-418f-9a3f-82bc216a4d66} <Trace> ReferentialDeps: No tables | ||
| 225 | 2024.10.09 22:39:28.511384 [ 3 ] {ff40564f-eaff-418f-9a3f-82bc216a4d66} <Trace> LoadingDeps: No tables | ||
| 226 | 2024.10.09 22:39:28.511410 [ 3 ] {ff40564f-eaff-418f-9a3f-82bc216a4d66} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 227 | 2024.10.09 22:39:28.511634 [ 3 ] {ff40564f-eaff-418f-9a3f-82bc216a4d66} <Debug> DynamicQueryHandler: Done processing query | ||
| 228 | 2024.10.09 22:39:28.511659 [ 3 ] {} <Debug> HTTP-Session: 2439acbe-8097-4bcd-bbef-9813abe54753 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 229 | 2024.10.09 22:39:28.630308 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 230 | 2024.10.09 22:39:28.630459 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 231 | 2024.10.09 22:39:28.630492 [ 3 ] {} <Debug> HTTP-Session: 0ee3d6bc-344e-40ad-9326-f0bc7843f9f1 Authenticating user 'default' from [::1]:35174 | ||
| 232 | 2024.10.09 22:39:28.630519 [ 3 ] {} <Debug> HTTP-Session: 0ee3d6bc-344e-40ad-9326-f0bc7843f9f1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 233 | 2024.10.09 22:39:28.630541 [ 3 ] {} <Debug> HTTP-Session: 0ee3d6bc-344e-40ad-9326-f0bc7843f9f1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 234 | 2024.10.09 22:39:28.630603 [ 3 ] {} <Trace> HTTP-Session: 0ee3d6bc-344e-40ad-9326-f0bc7843f9f1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 235 | 2024.10.09 22:39:28.630918 [ 3 ] {a766b0d2-45ae-43aa-9470-0a5ebf52624c} <Debug> executeQuery: (from [::1]:35174) /* The version table contains metadata about the `oximeter` database */ | ||
| 236 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 237 | 2024.10.09 22:39:28.631005 [ 3 ] {a766b0d2-45ae-43aa-9470-0a5ebf52624c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 238 | 2024.10.09 22:39:28.632425 [ 3 ] {a766b0d2-45ae-43aa-9470-0a5ebf52624c} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 239 | 2024.10.09 22:39:28.633775 [ 3 ] {a766b0d2-45ae-43aa-9470-0a5ebf52624c} <Debug> oximeter.version (07a80639-98d9-4fcd-9910-db49c5953a0f): Loading data parts | ||
| 240 | 2024.10.09 22:39:28.635310 [ 3 ] {a766b0d2-45ae-43aa-9470-0a5ebf52624c} <Debug> oximeter.version (07a80639-98d9-4fcd-9910-db49c5953a0f): There are no data parts | ||
| 241 | 2024.10.09 22:39:28.637188 [ 3 ] {a766b0d2-45ae-43aa-9470-0a5ebf52624c} <Debug> DynamicQueryHandler: Done processing query | ||
| 242 | 2024.10.09 22:39:28.637220 [ 3 ] {} <Debug> HTTP-Session: 0ee3d6bc-344e-40ad-9326-f0bc7843f9f1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 243 | 2024.10.09 22:39:28.658518 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 244 | 2024.10.09 22:39:28.658657 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 245 | 2024.10.09 22:39:28.658704 [ 3 ] {} <Debug> HTTP-Session: 7f650843-b40b-4602-9b42-d1c7e23c017f Authenticating user 'default' from [::1]:35174 | ||
| 246 | 2024.10.09 22:39:28.658732 [ 3 ] {} <Debug> HTTP-Session: 7f650843-b40b-4602-9b42-d1c7e23c017f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 247 | 2024.10.09 22:39:28.658748 [ 3 ] {} <Debug> HTTP-Session: 7f650843-b40b-4602-9b42-d1c7e23c017f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 248 | 2024.10.09 22:39:28.658812 [ 3 ] {} <Trace> HTTP-Session: 7f650843-b40b-4602-9b42-d1c7e23c017f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 249 | 2024.10.09 22:39:28.659236 [ 3 ] {c61cdc4d-66f2-42f4-b83b-5fdfd408662b} <Debug> executeQuery: (from [::1]:35174) /* The measurement tables contain all individual samples from each timeseries. | ||
| 250 | * | ||
| 251 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 252 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 253 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 254 | * by all samples from the same timeseries. | ||
| 255 | * | ||
| 256 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 257 | * and then uses that to index quickly into the measurements tables. | ||
| 258 | */ | ||
| 259 | 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) | ||
| 260 | 2024.10.09 22:39:28.659324 [ 3 ] {c61cdc4d-66f2-42f4-b83b-5fdfd408662b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 261 | 2024.10.09 22:39:28.662065 [ 3 ] {c61cdc4d-66f2-42f4-b83b-5fdfd408662b} <Debug> oximeter.measurements_bool (c59a5a7e-3458-4239-827d-8507da18badc): Loading data parts | ||
| 262 | 2024.10.09 22:39:28.662423 [ 3 ] {c61cdc4d-66f2-42f4-b83b-5fdfd408662b} <Debug> oximeter.measurements_bool (c59a5a7e-3458-4239-827d-8507da18badc): There are no data parts | ||
| 263 | 2024.10.09 22:39:28.664212 [ 3 ] {c61cdc4d-66f2-42f4-b83b-5fdfd408662b} <Debug> DynamicQueryHandler: Done processing query | ||
| 264 | 2024.10.09 22:39:28.664243 [ 3 ] {} <Debug> HTTP-Session: 7f650843-b40b-4602-9b42-d1c7e23c017f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2024.10.09 22:39:28.667847 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 266 | 2024.10.09 22:39:28.667982 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 267 | 2024.10.09 22:39:28.668012 [ 3 ] {} <Debug> HTTP-Session: 4cbf5962-4b89-4626-aa23-8d898c7dc114 Authenticating user 'default' from [::1]:35174 | ||
| 268 | 2024.10.09 22:39:28.668040 [ 3 ] {} <Debug> HTTP-Session: 4cbf5962-4b89-4626-aa23-8d898c7dc114 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2024.10.09 22:39:28.668063 [ 3 ] {} <Debug> HTTP-Session: 4cbf5962-4b89-4626-aa23-8d898c7dc114 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2024.10.09 22:39:28.668120 [ 3 ] {} <Trace> HTTP-Session: 4cbf5962-4b89-4626-aa23-8d898c7dc114 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 271 | 2024.10.09 22:39:28.668487 [ 3 ] {21eb7e11-33e9-485d-8abd-7feabaa1b2b3} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 272 | 2024.10.09 22:39:28.668569 [ 3 ] {21eb7e11-33e9-485d-8abd-7feabaa1b2b3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 273 | 2024.10.09 22:39:28.671154 [ 3 ] {21eb7e11-33e9-485d-8abd-7feabaa1b2b3} <Debug> oximeter.measurements_i8 (b6ac43f5-a5d5-4dc5-a687-260d57b134c9): Loading data parts | ||
| 274 | 2024.10.09 22:39:28.671486 [ 3 ] {21eb7e11-33e9-485d-8abd-7feabaa1b2b3} <Debug> oximeter.measurements_i8 (b6ac43f5-a5d5-4dc5-a687-260d57b134c9): There are no data parts | ||
| 275 | 2024.10.09 22:39:28.673379 [ 3 ] {21eb7e11-33e9-485d-8abd-7feabaa1b2b3} <Debug> DynamicQueryHandler: Done processing query | ||
| 276 | 2024.10.09 22:39:28.673410 [ 3 ] {} <Debug> HTTP-Session: 4cbf5962-4b89-4626-aa23-8d898c7dc114 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2024.10.09 22:39:28.678092 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 278 | 2024.10.09 22:39:28.678218 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 279 | 2024.10.09 22:39:28.678245 [ 3 ] {} <Debug> HTTP-Session: 6fc7d13f-0c82-40a8-9203-b783ed5ef1a2 Authenticating user 'default' from [::1]:35174 | ||
| 280 | 2024.10.09 22:39:28.678291 [ 3 ] {} <Debug> HTTP-Session: 6fc7d13f-0c82-40a8-9203-b783ed5ef1a2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 281 | 2024.10.09 22:39:28.678308 [ 3 ] {} <Debug> HTTP-Session: 6fc7d13f-0c82-40a8-9203-b783ed5ef1a2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2024.10.09 22:39:28.678366 [ 3 ] {} <Trace> HTTP-Session: 6fc7d13f-0c82-40a8-9203-b783ed5ef1a2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 283 | 2024.10.09 22:39:28.678761 [ 3 ] {29769777-b349-4a68-a122-e9ba1df026f9} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 284 | 2024.10.09 22:39:28.678846 [ 3 ] {29769777-b349-4a68-a122-e9ba1df026f9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 285 | 2024.10.09 22:39:28.681470 [ 3 ] {29769777-b349-4a68-a122-e9ba1df026f9} <Debug> oximeter.measurements_u8 (06bb552b-29ba-45f1-9ce8-5ca2390acab6): Loading data parts | ||
| 286 | 2024.10.09 22:39:28.681837 [ 3 ] {29769777-b349-4a68-a122-e9ba1df026f9} <Debug> oximeter.measurements_u8 (06bb552b-29ba-45f1-9ce8-5ca2390acab6): There are no data parts | ||
| 287 | 2024.10.09 22:39:28.683693 [ 3 ] {29769777-b349-4a68-a122-e9ba1df026f9} <Debug> DynamicQueryHandler: Done processing query | ||
| 288 | 2024.10.09 22:39:28.683725 [ 3 ] {} <Debug> HTTP-Session: 6fc7d13f-0c82-40a8-9203-b783ed5ef1a2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 289 | 2024.10.09 22:39:28.684946 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 290 | 2024.10.09 22:39:28.685036 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 291 | 2024.10.09 22:39:28.685063 [ 3 ] {} <Debug> HTTP-Session: c69711f7-995e-4b53-8293-f2d30e5e2292 Authenticating user 'default' from [::1]:35174 | ||
| 292 | 2024.10.09 22:39:28.685090 [ 3 ] {} <Debug> HTTP-Session: c69711f7-995e-4b53-8293-f2d30e5e2292 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2024.10.09 22:39:28.685106 [ 3 ] {} <Debug> HTTP-Session: c69711f7-995e-4b53-8293-f2d30e5e2292 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2024.10.09 22:39:28.685248 [ 3 ] {} <Trace> HTTP-Session: c69711f7-995e-4b53-8293-f2d30e5e2292 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 295 | 2024.10.09 22:39:28.686412 [ 3 ] {ec616388-244c-46f5-9162-741b8a32ea4e} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 296 | 2024.10.09 22:39:28.686501 [ 3 ] {ec616388-244c-46f5-9162-741b8a32ea4e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 297 | 2024.10.09 22:39:28.689103 [ 3 ] {ec616388-244c-46f5-9162-741b8a32ea4e} <Debug> oximeter.measurements_i16 (06d64e55-2e6e-43b0-8672-45f404d8351a): Loading data parts | ||
| 298 | 2024.10.09 22:39:28.689400 [ 3 ] {ec616388-244c-46f5-9162-741b8a32ea4e} <Debug> oximeter.measurements_i16 (06d64e55-2e6e-43b0-8672-45f404d8351a): There are no data parts | ||
| 299 | 2024.10.09 22:39:28.691203 [ 3 ] {ec616388-244c-46f5-9162-741b8a32ea4e} <Debug> DynamicQueryHandler: Done processing query | ||
| 300 | 2024.10.09 22:39:28.691234 [ 3 ] {} <Debug> HTTP-Session: c69711f7-995e-4b53-8293-f2d30e5e2292 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 301 | 2024.10.09 22:39:28.696789 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 302 | 2024.10.09 22:39:28.696943 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 303 | 2024.10.09 22:39:28.696971 [ 3 ] {} <Debug> HTTP-Session: 6270c1fb-8551-4660-908e-5fac377a5505 Authenticating user 'default' from [::1]:35174 | ||
| 304 | 2024.10.09 22:39:28.696999 [ 3 ] {} <Debug> HTTP-Session: 6270c1fb-8551-4660-908e-5fac377a5505 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 305 | 2024.10.09 22:39:28.697053 [ 3 ] {} <Debug> HTTP-Session: 6270c1fb-8551-4660-908e-5fac377a5505 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 306 | 2024.10.09 22:39:28.697118 [ 3 ] {} <Trace> HTTP-Session: 6270c1fb-8551-4660-908e-5fac377a5505 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 307 | 2024.10.09 22:39:28.697526 [ 3 ] {5d6fe627-5184-42c9-88d8-37c98946fe29} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 308 | 2024.10.09 22:39:28.697608 [ 3 ] {5d6fe627-5184-42c9-88d8-37c98946fe29} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 309 | 2024.10.09 22:39:28.700440 [ 3 ] {5d6fe627-5184-42c9-88d8-37c98946fe29} <Debug> oximeter.measurements_u16 (33f2a7c2-b5c8-401a-8251-bd6e4f995f35): Loading data parts | ||
| 310 | 2024.10.09 22:39:28.700789 [ 3 ] {5d6fe627-5184-42c9-88d8-37c98946fe29} <Debug> oximeter.measurements_u16 (33f2a7c2-b5c8-401a-8251-bd6e4f995f35): There are no data parts | ||
| 311 | 2024.10.09 22:39:28.702732 [ 3 ] {5d6fe627-5184-42c9-88d8-37c98946fe29} <Debug> DynamicQueryHandler: Done processing query | ||
| 312 | 2024.10.09 22:39:28.702776 [ 3 ] {} <Debug> HTTP-Session: 6270c1fb-8551-4660-908e-5fac377a5505 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 313 | 2024.10.09 22:39:28.743225 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 314 | 2024.10.09 22:39:28.743359 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 315 | 2024.10.09 22:39:28.743412 [ 3 ] {} <Debug> HTTP-Session: d6905c5f-ec06-4223-a5a3-d40299fa71d1 Authenticating user 'default' from [::1]:35174 | ||
| 316 | 2024.10.09 22:39:28.743473 [ 3 ] {} <Debug> HTTP-Session: d6905c5f-ec06-4223-a5a3-d40299fa71d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 317 | 2024.10.09 22:39:28.743490 [ 3 ] {} <Debug> HTTP-Session: d6905c5f-ec06-4223-a5a3-d40299fa71d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 318 | 2024.10.09 22:39:28.743559 [ 3 ] {} <Trace> HTTP-Session: d6905c5f-ec06-4223-a5a3-d40299fa71d1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 319 | 2024.10.09 22:39:28.743971 [ 3 ] {e4fe72de-7e6e-486b-a138-ca6c64cdcf12} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 320 | 2024.10.09 22:39:28.744058 [ 3 ] {e4fe72de-7e6e-486b-a138-ca6c64cdcf12} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 321 | 2024.10.09 22:39:28.746670 [ 3 ] {e4fe72de-7e6e-486b-a138-ca6c64cdcf12} <Debug> oximeter.measurements_i32 (968de5b3-e061-482a-bd01-9b71212afab2): Loading data parts | ||
| 322 | 2024.10.09 22:39:28.747074 [ 3 ] {e4fe72de-7e6e-486b-a138-ca6c64cdcf12} <Debug> oximeter.measurements_i32 (968de5b3-e061-482a-bd01-9b71212afab2): There are no data parts | ||
| 323 | 2024.10.09 22:39:28.748989 [ 3 ] {e4fe72de-7e6e-486b-a138-ca6c64cdcf12} <Debug> DynamicQueryHandler: Done processing query | ||
| 324 | 2024.10.09 22:39:28.749019 [ 3 ] {} <Debug> HTTP-Session: d6905c5f-ec06-4223-a5a3-d40299fa71d1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 325 | 2024.10.09 22:39:28.755392 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 326 | 2024.10.09 22:39:28.755599 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 327 | 2024.10.09 22:39:28.755634 [ 3 ] {} <Debug> HTTP-Session: be9409bd-964a-495e-9d05-35d9787a7fd6 Authenticating user 'default' from [::1]:35174 | ||
| 328 | 2024.10.09 22:39:28.755663 [ 3 ] {} <Debug> HTTP-Session: be9409bd-964a-495e-9d05-35d9787a7fd6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 329 | 2024.10.09 22:39:28.755686 [ 3 ] {} <Debug> HTTP-Session: be9409bd-964a-495e-9d05-35d9787a7fd6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 330 | 2024.10.09 22:39:28.755749 [ 3 ] {} <Trace> HTTP-Session: be9409bd-964a-495e-9d05-35d9787a7fd6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 331 | 2024.10.09 22:39:28.758193 [ 3 ] {28a68c2a-9c89-49c4-a24f-cb01bc3988b8} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 332 | 2024.10.09 22:39:28.758296 [ 3 ] {28a68c2a-9c89-49c4-a24f-cb01bc3988b8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 333 | 2024.10.09 22:39:28.761069 [ 3 ] {28a68c2a-9c89-49c4-a24f-cb01bc3988b8} <Debug> oximeter.measurements_u32 (c08aa5a3-9a9a-4cda-958d-e035e627c6e6): Loading data parts | ||
| 334 | 2024.10.09 22:39:28.761575 [ 3 ] {28a68c2a-9c89-49c4-a24f-cb01bc3988b8} <Debug> oximeter.measurements_u32 (c08aa5a3-9a9a-4cda-958d-e035e627c6e6): There are no data parts | ||
| 335 | 2024.10.09 22:39:28.763834 [ 3 ] {28a68c2a-9c89-49c4-a24f-cb01bc3988b8} <Debug> DynamicQueryHandler: Done processing query | ||
| 336 | 2024.10.09 22:39:28.763869 [ 3 ] {} <Debug> HTTP-Session: be9409bd-964a-495e-9d05-35d9787a7fd6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 337 | 2024.10.09 22:39:28.854289 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 338 | 2024.10.09 22:39:28.854472 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 339 | 2024.10.09 22:39:28.854507 [ 3 ] {} <Debug> HTTP-Session: 90a5da8d-aa2a-4e81-ad49-d702507f6a42 Authenticating user 'default' from [::1]:35174 | ||
| 340 | 2024.10.09 22:39:28.854559 [ 3 ] {} <Debug> HTTP-Session: 90a5da8d-aa2a-4e81-ad49-d702507f6a42 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 341 | 2024.10.09 22:39:28.854575 [ 3 ] {} <Debug> HTTP-Session: 90a5da8d-aa2a-4e81-ad49-d702507f6a42 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 342 | 2024.10.09 22:39:28.854640 [ 3 ] {} <Trace> HTTP-Session: 90a5da8d-aa2a-4e81-ad49-d702507f6a42 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 343 | 2024.10.09 22:39:28.855196 [ 3 ] {15b5756f-1db4-43c0-84fb-7b2fd0cf4cc7} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 344 | 2024.10.09 22:39:28.855289 [ 3 ] {15b5756f-1db4-43c0-84fb-7b2fd0cf4cc7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 345 | 2024.10.09 22:39:28.858047 [ 3 ] {15b5756f-1db4-43c0-84fb-7b2fd0cf4cc7} <Debug> oximeter.measurements_i64 (0b9307f1-d366-4fac-8fe3-b89ed9362d05): Loading data parts | ||
| 346 | 2024.10.09 22:39:28.858441 [ 3 ] {15b5756f-1db4-43c0-84fb-7b2fd0cf4cc7} <Debug> oximeter.measurements_i64 (0b9307f1-d366-4fac-8fe3-b89ed9362d05): There are no data parts | ||
| 347 | 2024.10.09 22:39:28.860479 [ 3 ] {15b5756f-1db4-43c0-84fb-7b2fd0cf4cc7} <Debug> DynamicQueryHandler: Done processing query | ||
| 348 | 2024.10.09 22:39:28.860510 [ 3 ] {} <Debug> HTTP-Session: 90a5da8d-aa2a-4e81-ad49-d702507f6a42 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 349 | 2024.10.09 22:39:28.971498 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 350 | 2024.10.09 22:39:28.971664 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 351 | 2024.10.09 22:39:28.971693 [ 3 ] {} <Debug> HTTP-Session: f1236077-e1ee-4b16-9c19-3f2c0581f0b8 Authenticating user 'default' from [::1]:35174 | ||
| 352 | 2024.10.09 22:39:28.971722 [ 3 ] {} <Debug> HTTP-Session: f1236077-e1ee-4b16-9c19-3f2c0581f0b8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 353 | 2024.10.09 22:39:28.971744 [ 3 ] {} <Debug> HTTP-Session: f1236077-e1ee-4b16-9c19-3f2c0581f0b8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 354 | 2024.10.09 22:39:28.971810 [ 3 ] {} <Trace> HTTP-Session: f1236077-e1ee-4b16-9c19-3f2c0581f0b8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 355 | 2024.10.09 22:39:28.972359 [ 3 ] {c0add78f-20c3-4434-a1b1-116e1151b43b} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 356 | 2024.10.09 22:39:28.972451 [ 3 ] {c0add78f-20c3-4434-a1b1-116e1151b43b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 357 | 2024.10.09 22:39:28.976121 [ 3 ] {c0add78f-20c3-4434-a1b1-116e1151b43b} <Debug> oximeter.measurements_u64 (c953f7a4-0ff1-466f-a01a-d31a281f604a): Loading data parts | ||
| 358 | 2024.10.09 22:39:28.976538 [ 3 ] {c0add78f-20c3-4434-a1b1-116e1151b43b} <Debug> oximeter.measurements_u64 (c953f7a4-0ff1-466f-a01a-d31a281f604a): There are no data parts | ||
| 359 | 2024.10.09 22:39:28.978488 [ 3 ] {c0add78f-20c3-4434-a1b1-116e1151b43b} <Debug> DynamicQueryHandler: Done processing query | ||
| 360 | 2024.10.09 22:39:28.978522 [ 3 ] {} <Debug> HTTP-Session: f1236077-e1ee-4b16-9c19-3f2c0581f0b8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 361 | 2024.10.09 22:39:28.984089 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 362 | 2024.10.09 22:39:28.984220 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 363 | 2024.10.09 22:39:28.984252 [ 3 ] {} <Debug> HTTP-Session: 1eaaca63-eb31-4926-b174-a2121e5a4c20 Authenticating user 'default' from [::1]:35174 | ||
| 364 | 2024.10.09 22:39:28.984298 [ 3 ] {} <Debug> HTTP-Session: 1eaaca63-eb31-4926-b174-a2121e5a4c20 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 365 | 2024.10.09 22:39:28.984317 [ 3 ] {} <Debug> HTTP-Session: 1eaaca63-eb31-4926-b174-a2121e5a4c20 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 366 | 2024.10.09 22:39:28.984381 [ 3 ] {} <Trace> HTTP-Session: 1eaaca63-eb31-4926-b174-a2121e5a4c20 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 367 | 2024.10.09 22:39:28.984848 [ 3 ] {44585f9b-25e9-4ee1-a114-98c159d3fccd} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 368 | 2024.10.09 22:39:28.984941 [ 3 ] {44585f9b-25e9-4ee1-a114-98c159d3fccd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 369 | 2024.10.09 22:39:28.989177 [ 3 ] {44585f9b-25e9-4ee1-a114-98c159d3fccd} <Debug> oximeter.measurements_f32 (ed243e2d-b7e7-4565-ac0b-60139d324f3a): Loading data parts | ||
| 370 | 2024.10.09 22:39:28.989549 [ 3 ] {44585f9b-25e9-4ee1-a114-98c159d3fccd} <Debug> oximeter.measurements_f32 (ed243e2d-b7e7-4565-ac0b-60139d324f3a): There are no data parts | ||
| 371 | 2024.10.09 22:39:28.991403 [ 3 ] {44585f9b-25e9-4ee1-a114-98c159d3fccd} <Debug> DynamicQueryHandler: Done processing query | ||
| 372 | 2024.10.09 22:39:28.991450 [ 3 ] {} <Debug> HTTP-Session: 1eaaca63-eb31-4926-b174-a2121e5a4c20 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 373 | 2024.10.09 22:39:29.000234 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 180.19 MiB, peak 181.20 MiB, free memory in arenas 0.00 B, will set to 186.10 MiB (RSS), difference: 5.92 MiB | ||
| 374 | 2024.10.09 22:39:29.025383 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 375 | 2024.10.09 22:39:29.025549 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 376 | 2024.10.09 22:39:29.025580 [ 3 ] {} <Debug> HTTP-Session: d112606f-b357-4802-a230-dccb28a71e59 Authenticating user 'default' from [::1]:35174 | ||
| 377 | 2024.10.09 22:39:29.025609 [ 3 ] {} <Debug> HTTP-Session: d112606f-b357-4802-a230-dccb28a71e59 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 378 | 2024.10.09 22:39:29.025643 [ 3 ] {} <Debug> HTTP-Session: d112606f-b357-4802-a230-dccb28a71e59 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 379 | 2024.10.09 22:39:29.025707 [ 3 ] {} <Trace> HTTP-Session: d112606f-b357-4802-a230-dccb28a71e59 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 380 | 2024.10.09 22:39:29.026170 [ 3 ] {a2da1684-aabe-4837-8d42-2190a9a371be} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 381 | 2024.10.09 22:39:29.026255 [ 3 ] {a2da1684-aabe-4837-8d42-2190a9a371be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 382 | 2024.10.09 22:39:29.028843 [ 3 ] {a2da1684-aabe-4837-8d42-2190a9a371be} <Debug> oximeter.measurements_f64 (dbca9655-20fc-4f64-9dbf-601b52032a65): Loading data parts | ||
| 383 | 2024.10.09 22:39:29.029224 [ 3 ] {a2da1684-aabe-4837-8d42-2190a9a371be} <Debug> oximeter.measurements_f64 (dbca9655-20fc-4f64-9dbf-601b52032a65): There are no data parts | ||
| 384 | 2024.10.09 22:39:29.031230 [ 3 ] {a2da1684-aabe-4837-8d42-2190a9a371be} <Debug> DynamicQueryHandler: Done processing query | ||
| 385 | 2024.10.09 22:39:29.031301 [ 3 ] {} <Debug> HTTP-Session: d112606f-b357-4802-a230-dccb28a71e59 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 386 | 2024.10.09 22:39:29.032277 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 387 | 2024.10.09 22:39:29.032363 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 388 | 2024.10.09 22:39:29.032400 [ 3 ] {} <Debug> HTTP-Session: 5bd8b0b8-7cf0-4761-b02c-75c94ca43366 Authenticating user 'default' from [::1]:35174 | ||
| 389 | 2024.10.09 22:39:29.032428 [ 3 ] {} <Debug> HTTP-Session: 5bd8b0b8-7cf0-4761-b02c-75c94ca43366 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 390 | 2024.10.09 22:39:29.032445 [ 3 ] {} <Debug> HTTP-Session: 5bd8b0b8-7cf0-4761-b02c-75c94ca43366 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 391 | 2024.10.09 22:39:29.032506 [ 3 ] {} <Trace> HTTP-Session: 5bd8b0b8-7cf0-4761-b02c-75c94ca43366 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 392 | 2024.10.09 22:39:29.032888 [ 3 ] {b5046595-e5fe-40b2-91d7-c8c873b2a610} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 393 | 2024.10.09 22:39:29.032974 [ 3 ] {b5046595-e5fe-40b2-91d7-c8c873b2a610} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 394 | 2024.10.09 22:39:29.035559 [ 3 ] {b5046595-e5fe-40b2-91d7-c8c873b2a610} <Debug> oximeter.measurements_string (623779e3-cf28-46ca-965a-2b030f2f9c87): Loading data parts | ||
| 395 | 2024.10.09 22:39:29.035893 [ 3 ] {b5046595-e5fe-40b2-91d7-c8c873b2a610} <Debug> oximeter.measurements_string (623779e3-cf28-46ca-965a-2b030f2f9c87): There are no data parts | ||
| 396 | 2024.10.09 22:39:29.040010 [ 3 ] {b5046595-e5fe-40b2-91d7-c8c873b2a610} <Debug> DynamicQueryHandler: Done processing query | ||
| 397 | 2024.10.09 22:39:29.040055 [ 3 ] {} <Debug> HTTP-Session: 5bd8b0b8-7cf0-4761-b02c-75c94ca43366 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 398 | 2024.10.09 22:39:29.042977 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 399 | 2024.10.09 22:39:29.043105 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 400 | 2024.10.09 22:39:29.043135 [ 3 ] {} <Debug> HTTP-Session: 390b606e-dad0-43ed-961c-7f341ff6aba8 Authenticating user 'default' from [::1]:35174 | ||
| 401 | 2024.10.09 22:39:29.043260 [ 3 ] {} <Debug> HTTP-Session: 390b606e-dad0-43ed-961c-7f341ff6aba8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 402 | 2024.10.09 22:39:29.043292 [ 3 ] {} <Debug> HTTP-Session: 390b606e-dad0-43ed-961c-7f341ff6aba8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 403 | 2024.10.09 22:39:29.043348 [ 3 ] {} <Trace> HTTP-Session: 390b606e-dad0-43ed-961c-7f341ff6aba8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 404 | 2024.10.09 22:39:29.043708 [ 3 ] {a5528637-a3e0-4005-bed7-8ff05a55d4d7} <Debug> executeQuery: (from [::1]:35174) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 405 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 406 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 407 | * a string isn't palatable for a few reasons. | ||
| 408 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 409 | * details. | ||
| 410 | */ | ||
| 411 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 412 | 2024.10.09 22:39:29.043792 [ 3 ] {a5528637-a3e0-4005-bed7-8ff05a55d4d7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 413 | 2024.10.09 22:39:29.046283 [ 3 ] {a5528637-a3e0-4005-bed7-8ff05a55d4d7} <Debug> oximeter.measurements_bytes (7f86d50d-33bf-4eb9-8108-42a0d78c4be5): Loading data parts | ||
| 414 | 2024.10.09 22:39:29.046597 [ 3 ] {a5528637-a3e0-4005-bed7-8ff05a55d4d7} <Debug> oximeter.measurements_bytes (7f86d50d-33bf-4eb9-8108-42a0d78c4be5): There are no data parts | ||
| 415 | 2024.10.09 22:39:29.048594 [ 3 ] {a5528637-a3e0-4005-bed7-8ff05a55d4d7} <Debug> DynamicQueryHandler: Done processing query | ||
| 416 | 2024.10.09 22:39:29.048627 [ 3 ] {} <Debug> HTTP-Session: 390b606e-dad0-43ed-961c-7f341ff6aba8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 417 | 2024.10.09 22:39:29.049890 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 418 | 2024.10.09 22:39:29.049987 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 419 | 2024.10.09 22:39:29.050014 [ 3 ] {} <Debug> HTTP-Session: 204ae30f-c65d-413c-bb12-668b5fde5559 Authenticating user 'default' from [::1]:35174 | ||
| 420 | 2024.10.09 22:39:29.050040 [ 3 ] {} <Debug> HTTP-Session: 204ae30f-c65d-413c-bb12-668b5fde5559 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 421 | 2024.10.09 22:39:29.050064 [ 3 ] {} <Debug> HTTP-Session: 204ae30f-c65d-413c-bb12-668b5fde5559 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 422 | 2024.10.09 22:39:29.050117 [ 3 ] {} <Trace> HTTP-Session: 204ae30f-c65d-413c-bb12-668b5fde5559 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 423 | 2024.10.09 22:39:29.050457 [ 3 ] {6a7e4463-b216-4921-a64a-1eca34ae53b5} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 424 | 2024.10.09 22:39:29.050538 [ 3 ] {6a7e4463-b216-4921-a64a-1eca34ae53b5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 425 | 2024.10.09 22:39:29.053093 [ 3 ] {6a7e4463-b216-4921-a64a-1eca34ae53b5} <Debug> oximeter.measurements_cumulativei64 (5a2ec7a0-a1d0-497f-a0dc-47fbec0f2d3a): Loading data parts | ||
| 426 | 2024.10.09 22:39:29.053439 [ 3 ] {6a7e4463-b216-4921-a64a-1eca34ae53b5} <Debug> oximeter.measurements_cumulativei64 (5a2ec7a0-a1d0-497f-a0dc-47fbec0f2d3a): There are no data parts | ||
| 427 | 2024.10.09 22:39:29.056183 [ 3 ] {6a7e4463-b216-4921-a64a-1eca34ae53b5} <Debug> DynamicQueryHandler: Done processing query | ||
| 428 | 2024.10.09 22:39:29.056235 [ 3 ] {} <Debug> HTTP-Session: 204ae30f-c65d-413c-bb12-668b5fde5559 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 429 | 2024.10.09 22:39:29.057981 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 430 | 2024.10.09 22:39:29.058113 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 431 | 2024.10.09 22:39:29.058158 [ 3 ] {} <Debug> HTTP-Session: f3f953e3-b160-4833-887b-6e326ab732cb Authenticating user 'default' from [::1]:35174 | ||
| 432 | 2024.10.09 22:39:29.058187 [ 3 ] {} <Debug> HTTP-Session: f3f953e3-b160-4833-887b-6e326ab732cb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 433 | 2024.10.09 22:39:29.058203 [ 3 ] {} <Debug> HTTP-Session: f3f953e3-b160-4833-887b-6e326ab732cb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 434 | 2024.10.09 22:39:29.058269 [ 3 ] {} <Trace> HTTP-Session: f3f953e3-b160-4833-887b-6e326ab732cb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 435 | 2024.10.09 22:39:29.058661 [ 3 ] {2fd07e79-fab0-4ac6-9f7e-bca1ba06e5ab} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 436 | 2024.10.09 22:39:29.058749 [ 3 ] {2fd07e79-fab0-4ac6-9f7e-bca1ba06e5ab} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 437 | 2024.10.09 22:39:29.061774 [ 3 ] {2fd07e79-fab0-4ac6-9f7e-bca1ba06e5ab} <Debug> oximeter.measurements_cumulativeu64 (e1dfef19-4434-42de-ad26-9e55e6a70422): Loading data parts | ||
| 438 | 2024.10.09 22:39:29.062163 [ 3 ] {2fd07e79-fab0-4ac6-9f7e-bca1ba06e5ab} <Debug> oximeter.measurements_cumulativeu64 (e1dfef19-4434-42de-ad26-9e55e6a70422): There are no data parts | ||
| 439 | 2024.10.09 22:39:29.064251 [ 3 ] {2fd07e79-fab0-4ac6-9f7e-bca1ba06e5ab} <Debug> DynamicQueryHandler: Done processing query | ||
| 440 | 2024.10.09 22:39:29.064283 [ 3 ] {} <Debug> HTTP-Session: f3f953e3-b160-4833-887b-6e326ab732cb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 441 | 2024.10.09 22:39:29.068681 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 442 | 2024.10.09 22:39:29.068828 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 443 | 2024.10.09 22:39:29.068861 [ 3 ] {} <Debug> HTTP-Session: 684b3dfb-f9a3-4ea8-9f49-ce93619b4cce Authenticating user 'default' from [::1]:35174 | ||
| 444 | 2024.10.09 22:39:29.068900 [ 3 ] {} <Debug> HTTP-Session: 684b3dfb-f9a3-4ea8-9f49-ce93619b4cce Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 445 | 2024.10.09 22:39:29.068916 [ 3 ] {} <Debug> HTTP-Session: 684b3dfb-f9a3-4ea8-9f49-ce93619b4cce Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 446 | 2024.10.09 22:39:29.068975 [ 3 ] {} <Trace> HTTP-Session: 684b3dfb-f9a3-4ea8-9f49-ce93619b4cce Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 447 | 2024.10.09 22:39:29.069402 [ 3 ] {9349a458-a29a-44f0-b15e-581dc488de70} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 448 | 2024.10.09 22:39:29.069547 [ 3 ] {9349a458-a29a-44f0-b15e-581dc488de70} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 449 | 2024.10.09 22:39:29.072279 [ 3 ] {9349a458-a29a-44f0-b15e-581dc488de70} <Debug> oximeter.measurements_cumulativef32 (3dcf3e35-75cc-4f61-b247-2cd7aea1602e): Loading data parts | ||
| 450 | 2024.10.09 22:39:29.072591 [ 3 ] {9349a458-a29a-44f0-b15e-581dc488de70} <Debug> oximeter.measurements_cumulativef32 (3dcf3e35-75cc-4f61-b247-2cd7aea1602e): There are no data parts | ||
| 451 | 2024.10.09 22:39:29.076379 [ 3 ] {9349a458-a29a-44f0-b15e-581dc488de70} <Debug> DynamicQueryHandler: Done processing query | ||
| 452 | 2024.10.09 22:39:29.076426 [ 3 ] {} <Debug> HTTP-Session: 684b3dfb-f9a3-4ea8-9f49-ce93619b4cce Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 453 | 2024.10.09 22:39:29.078562 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 454 | 2024.10.09 22:39:29.079691 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 455 | 2024.10.09 22:39:29.079726 [ 3 ] {} <Debug> HTTP-Session: 5d3693cd-c9bc-442f-9448-8026d912cb5c Authenticating user 'default' from [::1]:35174 | ||
| 456 | 2024.10.09 22:39:29.079753 [ 3 ] {} <Debug> HTTP-Session: 5d3693cd-c9bc-442f-9448-8026d912cb5c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 457 | 2024.10.09 22:39:29.079771 [ 3 ] {} <Debug> HTTP-Session: 5d3693cd-c9bc-442f-9448-8026d912cb5c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 458 | 2024.10.09 22:39:29.079851 [ 3 ] {} <Trace> HTTP-Session: 5d3693cd-c9bc-442f-9448-8026d912cb5c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 459 | 2024.10.09 22:39:29.080252 [ 3 ] {74d87813-a3ab-46f0-affb-2c4fe72167b9} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 460 | 2024.10.09 22:39:29.080339 [ 3 ] {74d87813-a3ab-46f0-affb-2c4fe72167b9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 461 | 2024.10.09 22:39:29.088464 [ 3 ] {74d87813-a3ab-46f0-affb-2c4fe72167b9} <Debug> oximeter.measurements_cumulativef64 (c3cf3f5a-7ac1-41ab-b422-214d4dcfae13): Loading data parts | ||
| 462 | 2024.10.09 22:39:29.088973 [ 3 ] {74d87813-a3ab-46f0-affb-2c4fe72167b9} <Debug> oximeter.measurements_cumulativef64 (c3cf3f5a-7ac1-41ab-b422-214d4dcfae13): There are no data parts | ||
| 463 | 2024.10.09 22:39:29.094279 [ 3 ] {74d87813-a3ab-46f0-affb-2c4fe72167b9} <Debug> DynamicQueryHandler: Done processing query | ||
| 464 | 2024.10.09 22:39:29.094324 [ 3 ] {} <Debug> HTTP-Session: 5d3693cd-c9bc-442f-9448-8026d912cb5c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 465 | 2024.10.09 22:39:29.098153 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 466 | 2024.10.09 22:39:29.098277 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 467 | 2024.10.09 22:39:29.098305 [ 3 ] {} <Debug> HTTP-Session: 21432259-0cca-4db7-938b-aa4d57d5285e Authenticating user 'default' from [::1]:35174 | ||
| 468 | 2024.10.09 22:39:29.098356 [ 3 ] {} <Debug> HTTP-Session: 21432259-0cca-4db7-938b-aa4d57d5285e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 469 | 2024.10.09 22:39:29.098400 [ 3 ] {} <Debug> HTTP-Session: 21432259-0cca-4db7-938b-aa4d57d5285e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 470 | 2024.10.09 22:39:29.098462 [ 3 ] {} <Trace> HTTP-Session: 21432259-0cca-4db7-938b-aa4d57d5285e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 471 | 2024.10.09 22:39:29.099046 [ 3 ] {7b0dcb0e-8663-491c-a868-8a981e4f0aa0} <Debug> executeQuery: (from [::1]:35174) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 472 | * NOTE: Array types cannot be Nullable, see | ||
| 473 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 474 | * for more details. | ||
| 475 | * | ||
| 476 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 477 | * is unfortunate, and at this point relies on the fact that an | ||
| 478 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 479 | * to figure out another way to represent missing samples here. | ||
| 480 | */ | ||
| 481 | 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) | ||
| 482 | 2024.10.09 22:39:29.099156 [ 3 ] {7b0dcb0e-8663-491c-a868-8a981e4f0aa0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 483 | 2024.10.09 22:39:29.102395 [ 3 ] {7b0dcb0e-8663-491c-a868-8a981e4f0aa0} <Debug> oximeter.measurements_histogrami8 (a3710606-92b9-49f8-a3a2-98d0932dfe08): Loading data parts | ||
| 484 | 2024.10.09 22:39:29.102713 [ 3 ] {7b0dcb0e-8663-491c-a868-8a981e4f0aa0} <Debug> oximeter.measurements_histogrami8 (a3710606-92b9-49f8-a3a2-98d0932dfe08): There are no data parts | ||
| 485 | 2024.10.09 22:39:29.105529 [ 3 ] {7b0dcb0e-8663-491c-a868-8a981e4f0aa0} <Debug> DynamicQueryHandler: Done processing query | ||
| 486 | 2024.10.09 22:39:29.105583 [ 3 ] {} <Debug> HTTP-Session: 21432259-0cca-4db7-938b-aa4d57d5285e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 487 | 2024.10.09 22:39:29.112310 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 488 | 2024.10.09 22:39:29.112705 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 489 | 2024.10.09 22:39:29.112764 [ 3 ] {} <Debug> HTTP-Session: 9f6280e7-aa42-465e-8ba5-7f0fa2b74f52 Authenticating user 'default' from [::1]:35174 | ||
| 490 | 2024.10.09 22:39:29.113017 [ 3 ] {} <Debug> HTTP-Session: 9f6280e7-aa42-465e-8ba5-7f0fa2b74f52 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 491 | 2024.10.09 22:39:29.113101 [ 3 ] {} <Debug> HTTP-Session: 9f6280e7-aa42-465e-8ba5-7f0fa2b74f52 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 492 | 2024.10.09 22:39:29.113181 [ 3 ] {} <Trace> HTTP-Session: 9f6280e7-aa42-465e-8ba5-7f0fa2b74f52 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 493 | 2024.10.09 22:39:29.114554 [ 3 ] {edad56c4-d69a-42db-8243-026356b10dda} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 494 | 2024.10.09 22:39:29.114670 [ 3 ] {edad56c4-d69a-42db-8243-026356b10dda} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 495 | 2024.10.09 22:39:29.120582 [ 3 ] {edad56c4-d69a-42db-8243-026356b10dda} <Debug> oximeter.measurements_histogramu8 (e5569c81-473e-42a4-b90c-1768e8c346a3): Loading data parts | ||
| 496 | 2024.10.09 22:39:29.121229 [ 3 ] {edad56c4-d69a-42db-8243-026356b10dda} <Debug> oximeter.measurements_histogramu8 (e5569c81-473e-42a4-b90c-1768e8c346a3): There are no data parts | ||
| 497 | 2024.10.09 22:39:29.123493 [ 3 ] {edad56c4-d69a-42db-8243-026356b10dda} <Debug> DynamicQueryHandler: Done processing query | ||
| 498 | 2024.10.09 22:39:29.123530 [ 3 ] {} <Debug> HTTP-Session: 9f6280e7-aa42-465e-8ba5-7f0fa2b74f52 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 499 | 2024.10.09 22:39:29.125242 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 500 | 2024.10.09 22:39:29.125717 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 501 | 2024.10.09 22:39:29.125831 [ 3 ] {} <Debug> HTTP-Session: 83ae4d44-2b91-4ef0-a78d-9663434c92e7 Authenticating user 'default' from [::1]:35174 | ||
| 502 | 2024.10.09 22:39:29.125947 [ 3 ] {} <Debug> HTTP-Session: 83ae4d44-2b91-4ef0-a78d-9663434c92e7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 503 | 2024.10.09 22:39:29.125987 [ 3 ] {} <Debug> HTTP-Session: 83ae4d44-2b91-4ef0-a78d-9663434c92e7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 504 | 2024.10.09 22:39:29.126210 [ 3 ] {} <Trace> HTTP-Session: 83ae4d44-2b91-4ef0-a78d-9663434c92e7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 505 | 2024.10.09 22:39:29.127677 [ 3 ] {31df5f4e-cfc3-4974-9cf6-ed8e9b26e9fe} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 506 | 2024.10.09 22:39:29.127854 [ 3 ] {31df5f4e-cfc3-4974-9cf6-ed8e9b26e9fe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 507 | 2024.10.09 22:39:29.132477 [ 3 ] {31df5f4e-cfc3-4974-9cf6-ed8e9b26e9fe} <Debug> oximeter.measurements_histogrami16 (06800d60-fd3f-43e4-9bc0-f58c2ab8082f): Loading data parts | ||
| 508 | 2024.10.09 22:39:29.133052 [ 3 ] {31df5f4e-cfc3-4974-9cf6-ed8e9b26e9fe} <Debug> oximeter.measurements_histogrami16 (06800d60-fd3f-43e4-9bc0-f58c2ab8082f): There are no data parts | ||
| 509 | 2024.10.09 22:39:29.135210 [ 3 ] {31df5f4e-cfc3-4974-9cf6-ed8e9b26e9fe} <Debug> DynamicQueryHandler: Done processing query | ||
| 510 | 2024.10.09 22:39:29.135271 [ 3 ] {} <Debug> HTTP-Session: 83ae4d44-2b91-4ef0-a78d-9663434c92e7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 511 | 2024.10.09 22:39:29.136886 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 512 | 2024.10.09 22:39:29.137032 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 513 | 2024.10.09 22:39:29.137084 [ 3 ] {} <Debug> HTTP-Session: 178c9c6d-77d4-4666-993d-1547213c82da Authenticating user 'default' from [::1]:35174 | ||
| 514 | 2024.10.09 22:39:29.137112 [ 3 ] {} <Debug> HTTP-Session: 178c9c6d-77d4-4666-993d-1547213c82da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 515 | 2024.10.09 22:39:29.137129 [ 3 ] {} <Debug> HTTP-Session: 178c9c6d-77d4-4666-993d-1547213c82da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 516 | 2024.10.09 22:39:29.137193 [ 3 ] {} <Trace> HTTP-Session: 178c9c6d-77d4-4666-993d-1547213c82da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 517 | 2024.10.09 22:39:29.137719 [ 3 ] {d6d1b028-fd8b-4a07-a715-6e34e1958ca1} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 518 | 2024.10.09 22:39:29.137860 [ 3 ] {d6d1b028-fd8b-4a07-a715-6e34e1958ca1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 519 | 2024.10.09 22:39:29.141082 [ 3 ] {d6d1b028-fd8b-4a07-a715-6e34e1958ca1} <Debug> oximeter.measurements_histogramu16 (70bb219d-5596-4889-a2e6-fbc0d0d85a0c): Loading data parts | ||
| 520 | 2024.10.09 22:39:29.141427 [ 3 ] {d6d1b028-fd8b-4a07-a715-6e34e1958ca1} <Debug> oximeter.measurements_histogramu16 (70bb219d-5596-4889-a2e6-fbc0d0d85a0c): There are no data parts | ||
| 521 | 2024.10.09 22:39:29.143472 [ 3 ] {d6d1b028-fd8b-4a07-a715-6e34e1958ca1} <Debug> DynamicQueryHandler: Done processing query | ||
| 522 | 2024.10.09 22:39:29.143503 [ 3 ] {} <Debug> HTTP-Session: 178c9c6d-77d4-4666-993d-1547213c82da Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 523 | 2024.10.09 22:39:29.145733 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 524 | 2024.10.09 22:39:29.145856 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 525 | 2024.10.09 22:39:29.145883 [ 3 ] {} <Debug> HTTP-Session: 86ef79ef-d875-4038-8a7c-d1c4f9ae88e1 Authenticating user 'default' from [::1]:35174 | ||
| 526 | 2024.10.09 22:39:29.145910 [ 3 ] {} <Debug> HTTP-Session: 86ef79ef-d875-4038-8a7c-d1c4f9ae88e1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 527 | 2024.10.09 22:39:29.145936 [ 3 ] {} <Debug> HTTP-Session: 86ef79ef-d875-4038-8a7c-d1c4f9ae88e1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 528 | 2024.10.09 22:39:29.145997 [ 3 ] {} <Trace> HTTP-Session: 86ef79ef-d875-4038-8a7c-d1c4f9ae88e1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 529 | 2024.10.09 22:39:29.146528 [ 3 ] {d1760c12-d232-483a-9e10-c32bf93e17ce} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 530 | 2024.10.09 22:39:29.146636 [ 3 ] {d1760c12-d232-483a-9e10-c32bf93e17ce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 531 | 2024.10.09 22:39:29.149932 [ 3 ] {d1760c12-d232-483a-9e10-c32bf93e17ce} <Debug> oximeter.measurements_histogrami32 (6d3915aa-591e-4418-9da7-59989983ee0e): Loading data parts | ||
| 532 | 2024.10.09 22:39:29.150275 [ 3 ] {d1760c12-d232-483a-9e10-c32bf93e17ce} <Debug> oximeter.measurements_histogrami32 (6d3915aa-591e-4418-9da7-59989983ee0e): There are no data parts | ||
| 533 | 2024.10.09 22:39:29.152519 [ 3 ] {d1760c12-d232-483a-9e10-c32bf93e17ce} <Debug> DynamicQueryHandler: Done processing query | ||
| 534 | 2024.10.09 22:39:29.152555 [ 3 ] {} <Debug> HTTP-Session: 86ef79ef-d875-4038-8a7c-d1c4f9ae88e1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 535 | 2024.10.09 22:39:29.155856 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 536 | 2024.10.09 22:39:29.155969 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 537 | 2024.10.09 22:39:29.156000 [ 3 ] {} <Debug> HTTP-Session: 15847c69-eb0f-4d3f-b6f2-c8ca1eb93350 Authenticating user 'default' from [::1]:35174 | ||
| 538 | 2024.10.09 22:39:29.156049 [ 3 ] {} <Debug> HTTP-Session: 15847c69-eb0f-4d3f-b6f2-c8ca1eb93350 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 539 | 2024.10.09 22:39:29.156069 [ 3 ] {} <Debug> HTTP-Session: 15847c69-eb0f-4d3f-b6f2-c8ca1eb93350 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 540 | 2024.10.09 22:39:29.156339 [ 3 ] {} <Trace> HTTP-Session: 15847c69-eb0f-4d3f-b6f2-c8ca1eb93350 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 541 | 2024.10.09 22:39:29.157225 [ 3 ] {bdd566c0-ab81-46d9-af82-727b4bba78ee} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 542 | 2024.10.09 22:39:29.157335 [ 3 ] {bdd566c0-ab81-46d9-af82-727b4bba78ee} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 543 | 2024.10.09 22:39:29.160930 [ 3 ] {bdd566c0-ab81-46d9-af82-727b4bba78ee} <Debug> oximeter.measurements_histogramu32 (08439b18-0c19-4210-b4d5-799b33e2596b): Loading data parts | ||
| 544 | 2024.10.09 22:39:29.161400 [ 3 ] {bdd566c0-ab81-46d9-af82-727b4bba78ee} <Debug> oximeter.measurements_histogramu32 (08439b18-0c19-4210-b4d5-799b33e2596b): There are no data parts | ||
| 545 | 2024.10.09 22:39:29.163440 [ 3 ] {bdd566c0-ab81-46d9-af82-727b4bba78ee} <Debug> DynamicQueryHandler: Done processing query | ||
| 546 | 2024.10.09 22:39:29.163475 [ 3 ] {} <Debug> HTTP-Session: 15847c69-eb0f-4d3f-b6f2-c8ca1eb93350 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 547 | 2024.10.09 22:39:29.164735 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 548 | 2024.10.09 22:39:29.164840 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 549 | 2024.10.09 22:39:29.164870 [ 3 ] {} <Debug> HTTP-Session: 7cff3150-3247-4e8c-b1b7-7bf4e4d80f51 Authenticating user 'default' from [::1]:35174 | ||
| 550 | 2024.10.09 22:39:29.164938 [ 3 ] {} <Debug> HTTP-Session: 7cff3150-3247-4e8c-b1b7-7bf4e4d80f51 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 551 | 2024.10.09 22:39:29.164965 [ 3 ] {} <Debug> HTTP-Session: 7cff3150-3247-4e8c-b1b7-7bf4e4d80f51 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 552 | 2024.10.09 22:39:29.165034 [ 3 ] {} <Trace> HTTP-Session: 7cff3150-3247-4e8c-b1b7-7bf4e4d80f51 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 553 | 2024.10.09 22:39:29.165556 [ 3 ] {6056f690-2423-44ab-863c-568b3e021f89} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 554 | 2024.10.09 22:39:29.165679 [ 3 ] {6056f690-2423-44ab-863c-568b3e021f89} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 555 | 2024.10.09 22:39:29.169110 [ 3 ] {6056f690-2423-44ab-863c-568b3e021f89} <Debug> oximeter.measurements_histogrami64 (cac2e88d-9dd7-433d-9fef-864c7086e808): Loading data parts | ||
| 556 | 2024.10.09 22:39:29.169484 [ 3 ] {6056f690-2423-44ab-863c-568b3e021f89} <Debug> oximeter.measurements_histogrami64 (cac2e88d-9dd7-433d-9fef-864c7086e808): There are no data parts | ||
| 557 | 2024.10.09 22:39:29.171714 [ 3 ] {6056f690-2423-44ab-863c-568b3e021f89} <Debug> DynamicQueryHandler: Done processing query | ||
| 558 | 2024.10.09 22:39:29.171750 [ 3 ] {} <Debug> HTTP-Session: 7cff3150-3247-4e8c-b1b7-7bf4e4d80f51 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 559 | 2024.10.09 22:39:29.173498 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 560 | 2024.10.09 22:39:29.173591 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 561 | 2024.10.09 22:39:29.173629 [ 3 ] {} <Debug> HTTP-Session: 2d06f5bc-8546-4a07-a2a4-696c2e616fb2 Authenticating user 'default' from [::1]:35174 | ||
| 562 | 2024.10.09 22:39:29.173673 [ 3 ] {} <Debug> HTTP-Session: 2d06f5bc-8546-4a07-a2a4-696c2e616fb2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 563 | 2024.10.09 22:39:29.173692 [ 3 ] {} <Debug> HTTP-Session: 2d06f5bc-8546-4a07-a2a4-696c2e616fb2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 564 | 2024.10.09 22:39:29.173750 [ 3 ] {} <Trace> HTTP-Session: 2d06f5bc-8546-4a07-a2a4-696c2e616fb2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 565 | 2024.10.09 22:39:29.174309 [ 3 ] {5d9ecd2d-9d96-4f50-846d-1ac51c804f17} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 566 | 2024.10.09 22:39:29.174414 [ 3 ] {5d9ecd2d-9d96-4f50-846d-1ac51c804f17} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 567 | 2024.10.09 22:39:29.177597 [ 3 ] {5d9ecd2d-9d96-4f50-846d-1ac51c804f17} <Debug> oximeter.measurements_histogramu64 (e5fd76a1-b217-44c5-ba0d-7e837d581df6): Loading data parts | ||
| 568 | 2024.10.09 22:39:29.177980 [ 3 ] {5d9ecd2d-9d96-4f50-846d-1ac51c804f17} <Debug> oximeter.measurements_histogramu64 (e5fd76a1-b217-44c5-ba0d-7e837d581df6): There are no data parts | ||
| 569 | 2024.10.09 22:39:29.184437 [ 3 ] {5d9ecd2d-9d96-4f50-846d-1ac51c804f17} <Debug> DynamicQueryHandler: Done processing query | ||
| 570 | 2024.10.09 22:39:29.184497 [ 3 ] {} <Debug> HTTP-Session: 2d06f5bc-8546-4a07-a2a4-696c2e616fb2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 571 | 2024.10.09 22:39:29.189876 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 572 | 2024.10.09 22:39:29.190000 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 573 | 2024.10.09 22:39:29.190056 [ 3 ] {} <Debug> HTTP-Session: 90bc7762-5de2-40ae-b38a-df020df703b2 Authenticating user 'default' from [::1]:35174 | ||
| 574 | 2024.10.09 22:39:29.190085 [ 3 ] {} <Debug> HTTP-Session: 90bc7762-5de2-40ae-b38a-df020df703b2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 575 | 2024.10.09 22:39:29.190101 [ 3 ] {} <Debug> HTTP-Session: 90bc7762-5de2-40ae-b38a-df020df703b2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 576 | 2024.10.09 22:39:29.190175 [ 3 ] {} <Trace> HTTP-Session: 90bc7762-5de2-40ae-b38a-df020df703b2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 577 | 2024.10.09 22:39:29.191002 [ 3 ] {f7577606-52b6-4dd3-abaf-c234ca4972a6} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 578 | 2024.10.09 22:39:29.191582 [ 3 ] {f7577606-52b6-4dd3-abaf-c234ca4972a6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 579 | 2024.10.09 22:39:29.195131 [ 3 ] {f7577606-52b6-4dd3-abaf-c234ca4972a6} <Debug> oximeter.measurements_histogramf32 (1de7c847-1069-4181-a248-07a6c605cb8d): Loading data parts | ||
| 580 | 2024.10.09 22:39:29.195501 [ 3 ] {f7577606-52b6-4dd3-abaf-c234ca4972a6} <Debug> oximeter.measurements_histogramf32 (1de7c847-1069-4181-a248-07a6c605cb8d): There are no data parts | ||
| 581 | 2024.10.09 22:39:29.197592 [ 3 ] {f7577606-52b6-4dd3-abaf-c234ca4972a6} <Debug> DynamicQueryHandler: Done processing query | ||
| 582 | 2024.10.09 22:39:29.197676 [ 3 ] {} <Debug> HTTP-Session: 90bc7762-5de2-40ae-b38a-df020df703b2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 583 | 2024.10.09 22:39:29.199653 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 584 | 2024.10.09 22:39:29.199827 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 585 | 2024.10.09 22:39:29.199864 [ 3 ] {} <Debug> HTTP-Session: e8414eef-e702-4cf0-94dd-167663ecc1e7 Authenticating user 'default' from [::1]:35174 | ||
| 586 | 2024.10.09 22:39:29.199892 [ 3 ] {} <Debug> HTTP-Session: e8414eef-e702-4cf0-94dd-167663ecc1e7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 587 | 2024.10.09 22:39:29.199927 [ 3 ] {} <Debug> HTTP-Session: e8414eef-e702-4cf0-94dd-167663ecc1e7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 588 | 2024.10.09 22:39:29.199987 [ 3 ] {} <Trace> HTTP-Session: e8414eef-e702-4cf0-94dd-167663ecc1e7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 589 | 2024.10.09 22:39:29.200940 [ 3 ] {d997b6ad-c7fe-4d43-af48-5cb03740abfb} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 590 | 2024.10.09 22:39:29.201095 [ 3 ] {d997b6ad-c7fe-4d43-af48-5cb03740abfb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 591 | 2024.10.09 22:39:29.205450 [ 3 ] {d997b6ad-c7fe-4d43-af48-5cb03740abfb} <Debug> oximeter.measurements_histogramf64 (f6a26027-6026-4cce-9aa6-dce15ea670f6): Loading data parts | ||
| 592 | 2024.10.09 22:39:29.205923 [ 3 ] {d997b6ad-c7fe-4d43-af48-5cb03740abfb} <Debug> oximeter.measurements_histogramf64 (f6a26027-6026-4cce-9aa6-dce15ea670f6): There are no data parts | ||
| 593 | 2024.10.09 22:39:29.208211 [ 3 ] {d997b6ad-c7fe-4d43-af48-5cb03740abfb} <Debug> DynamicQueryHandler: Done processing query | ||
| 594 | 2024.10.09 22:39:29.208266 [ 3 ] {} <Debug> HTTP-Session: e8414eef-e702-4cf0-94dd-167663ecc1e7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 595 | 2024.10.09 22:39:29.209437 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 596 | 2024.10.09 22:39:29.209529 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 597 | 2024.10.09 22:39:29.209575 [ 3 ] {} <Debug> HTTP-Session: 57406179-3bff-4cb2-a166-79e1f09a89db Authenticating user 'default' from [::1]:35174 | ||
| 598 | 2024.10.09 22:39:29.209606 [ 3 ] {} <Debug> HTTP-Session: 57406179-3bff-4cb2-a166-79e1f09a89db Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 599 | 2024.10.09 22:39:29.209638 [ 3 ] {} <Debug> HTTP-Session: 57406179-3bff-4cb2-a166-79e1f09a89db Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 600 | 2024.10.09 22:39:29.209742 [ 3 ] {} <Trace> HTTP-Session: 57406179-3bff-4cb2-a166-79e1f09a89db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 601 | 2024.10.09 22:39:29.210284 [ 3 ] {7d87f652-d0d2-46be-93c1-a808688d3d5c} <Debug> executeQuery: (from [::1]:35174) /* The field tables store named dimensions of each timeseries. | ||
| 602 | * | ||
| 603 | * As with the measurement tables, there is one field table for each field data | ||
| 604 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 605 | * this behavior **must not** be relied upon for query correctness. | ||
| 606 | * | ||
| 607 | * The index for the fields differs from the measurements, however. Rows are | ||
| 608 | * sorted by timeseries name, then field name, field value, and finally | ||
| 609 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 610 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 611 | * usually then used to look up measurements. | ||
| 612 | * | ||
| 613 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 614 | * timeseries name and then key, since it would improve lookups where one | ||
| 615 | * already has the key. Realistically though, these tables are quite small and | ||
| 616 | * so performance benefits will be low in absolute terms. | ||
| 617 | * | ||
| 618 | * TTL: We use a materialized column to expire old field table records. This | ||
| 619 | * column is generated automatically by the database whenever a new row is | ||
| 620 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 621 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 622 | * record will remain during a deduplication, which will have the last | ||
| 623 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 624 | * measurement tables. | ||
| 625 | */ | ||
| 626 | 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) | ||
| 627 | 2024.10.09 22:39:29.210390 [ 3 ] {7d87f652-d0d2-46be-93c1-a808688d3d5c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 628 | 2024.10.09 22:39:29.213352 [ 3 ] {7d87f652-d0d2-46be-93c1-a808688d3d5c} <Debug> oximeter.fields_bool (ee3a4bff-7e71-44ce-9edd-dadaf508b31e): Loading data parts | ||
| 629 | 2024.10.09 22:39:29.213738 [ 3 ] {7d87f652-d0d2-46be-93c1-a808688d3d5c} <Debug> oximeter.fields_bool (ee3a4bff-7e71-44ce-9edd-dadaf508b31e): There are no data parts | ||
| 630 | 2024.10.09 22:39:29.215583 [ 3 ] {7d87f652-d0d2-46be-93c1-a808688d3d5c} <Debug> DynamicQueryHandler: Done processing query | ||
| 631 | 2024.10.09 22:39:29.215616 [ 3 ] {} <Debug> HTTP-Session: 57406179-3bff-4cb2-a166-79e1f09a89db Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 632 | 2024.10.09 22:39:29.306364 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 633 | 2024.10.09 22:39:29.306587 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 634 | 2024.10.09 22:39:29.306623 [ 3 ] {} <Debug> HTTP-Session: d70b0884-1962-4845-9db3-316555aceb78 Authenticating user 'default' from [::1]:35174 | ||
| 635 | 2024.10.09 22:39:29.306651 [ 3 ] {} <Debug> HTTP-Session: d70b0884-1962-4845-9db3-316555aceb78 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 636 | 2024.10.09 22:39:29.306666 [ 3 ] {} <Debug> HTTP-Session: d70b0884-1962-4845-9db3-316555aceb78 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 637 | 2024.10.09 22:39:29.306745 [ 3 ] {} <Trace> HTTP-Session: d70b0884-1962-4845-9db3-316555aceb78 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 638 | 2024.10.09 22:39:29.307192 [ 3 ] {0198d45a-4b01-4a29-866a-c6b9e07ec730} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 639 | 2024.10.09 22:39:29.307287 [ 3 ] {0198d45a-4b01-4a29-866a-c6b9e07ec730} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 640 | 2024.10.09 22:39:29.311014 [ 3 ] {0198d45a-4b01-4a29-866a-c6b9e07ec730} <Debug> oximeter.fields_i8 (fc4edf85-ba88-40e9-91c2-a53355567478): Loading data parts | ||
| 641 | 2024.10.09 22:39:29.311444 [ 3 ] {0198d45a-4b01-4a29-866a-c6b9e07ec730} <Debug> oximeter.fields_i8 (fc4edf85-ba88-40e9-91c2-a53355567478): There are no data parts | ||
| 642 | 2024.10.09 22:39:29.314250 [ 3 ] {0198d45a-4b01-4a29-866a-c6b9e07ec730} <Debug> DynamicQueryHandler: Done processing query | ||
| 643 | 2024.10.09 22:39:29.314287 [ 3 ] {} <Debug> HTTP-Session: d70b0884-1962-4845-9db3-316555aceb78 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 644 | 2024.10.09 22:39:29.315359 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 645 | 2024.10.09 22:39:29.315448 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 646 | 2024.10.09 22:39:29.315475 [ 3 ] {} <Debug> HTTP-Session: 006aca9a-7416-4da7-96d4-a8e090d3fc79 Authenticating user 'default' from [::1]:35174 | ||
| 647 | 2024.10.09 22:39:29.315516 [ 3 ] {} <Debug> HTTP-Session: 006aca9a-7416-4da7-96d4-a8e090d3fc79 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 648 | 2024.10.09 22:39:29.315533 [ 3 ] {} <Debug> HTTP-Session: 006aca9a-7416-4da7-96d4-a8e090d3fc79 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 649 | 2024.10.09 22:39:29.315589 [ 3 ] {} <Trace> HTTP-Session: 006aca9a-7416-4da7-96d4-a8e090d3fc79 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 650 | 2024.10.09 22:39:29.315979 [ 3 ] {9387fccd-0422-4f38-9be9-9c954bd16eaf} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 651 | 2024.10.09 22:39:29.316122 [ 3 ] {9387fccd-0422-4f38-9be9-9c954bd16eaf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 652 | 2024.10.09 22:39:29.320779 [ 3 ] {9387fccd-0422-4f38-9be9-9c954bd16eaf} <Debug> oximeter.fields_u8 (5774e010-f576-4e91-bfcf-12bbd4f6692e): Loading data parts | ||
| 653 | 2024.10.09 22:39:29.362067 [ 3 ] {9387fccd-0422-4f38-9be9-9c954bd16eaf} <Debug> oximeter.fields_u8 (5774e010-f576-4e91-bfcf-12bbd4f6692e): There are no data parts | ||
| 654 | 2024.10.09 22:39:29.365000 [ 3 ] {9387fccd-0422-4f38-9be9-9c954bd16eaf} <Debug> DynamicQueryHandler: Done processing query | ||
| 655 | 2024.10.09 22:39:29.365290 [ 3 ] {} <Debug> HTTP-Session: 006aca9a-7416-4da7-96d4-a8e090d3fc79 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 656 | 2024.10.09 22:39:29.372156 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 657 | 2024.10.09 22:39:29.372314 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 658 | 2024.10.09 22:39:29.372345 [ 3 ] {} <Debug> HTTP-Session: 67e2890d-ef9a-4014-8a24-a1eea202bdb7 Authenticating user 'default' from [::1]:35174 | ||
| 659 | 2024.10.09 22:39:29.372373 [ 3 ] {} <Debug> HTTP-Session: 67e2890d-ef9a-4014-8a24-a1eea202bdb7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 660 | 2024.10.09 22:39:29.372390 [ 3 ] {} <Debug> HTTP-Session: 67e2890d-ef9a-4014-8a24-a1eea202bdb7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 661 | 2024.10.09 22:39:29.372612 [ 3 ] {} <Trace> HTTP-Session: 67e2890d-ef9a-4014-8a24-a1eea202bdb7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 662 | 2024.10.09 22:39:29.373527 [ 3 ] {f5f1cccc-1f52-45bc-939f-fe61695a09d3} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 663 | 2024.10.09 22:39:29.373632 [ 3 ] {f5f1cccc-1f52-45bc-939f-fe61695a09d3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 664 | 2024.10.09 22:39:29.385178 [ 3 ] {f5f1cccc-1f52-45bc-939f-fe61695a09d3} <Debug> oximeter.fields_i16 (e7033b24-9bc0-4ee4-894c-d8549621550f): Loading data parts | ||
| 665 | 2024.10.09 22:39:29.395338 [ 3 ] {f5f1cccc-1f52-45bc-939f-fe61695a09d3} <Debug> oximeter.fields_i16 (e7033b24-9bc0-4ee4-894c-d8549621550f): There are no data parts | ||
| 666 | 2024.10.09 22:39:29.399313 [ 3 ] {f5f1cccc-1f52-45bc-939f-fe61695a09d3} <Debug> DynamicQueryHandler: Done processing query | ||
| 667 | 2024.10.09 22:39:29.399362 [ 3 ] {} <Debug> HTTP-Session: 67e2890d-ef9a-4014-8a24-a1eea202bdb7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 668 | 2024.10.09 22:39:29.400356 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 669 | 2024.10.09 22:39:29.400456 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 670 | 2024.10.09 22:39:29.400481 [ 3 ] {} <Debug> HTTP-Session: 4fecdc1f-56b5-4ac4-9906-0d7a4f71dce0 Authenticating user 'default' from [::1]:35174 | ||
| 671 | 2024.10.09 22:39:29.400526 [ 3 ] {} <Debug> HTTP-Session: 4fecdc1f-56b5-4ac4-9906-0d7a4f71dce0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 672 | 2024.10.09 22:39:29.400545 [ 3 ] {} <Debug> HTTP-Session: 4fecdc1f-56b5-4ac4-9906-0d7a4f71dce0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 673 | 2024.10.09 22:39:29.400603 [ 3 ] {} <Trace> HTTP-Session: 4fecdc1f-56b5-4ac4-9906-0d7a4f71dce0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 674 | 2024.10.09 22:39:29.401010 [ 3 ] {d2404ea6-c48c-47d5-9218-e150ce8c82a5} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 675 | 2024.10.09 22:39:29.401156 [ 3 ] {d2404ea6-c48c-47d5-9218-e150ce8c82a5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 676 | 2024.10.09 22:39:29.406886 [ 3 ] {d2404ea6-c48c-47d5-9218-e150ce8c82a5} <Debug> oximeter.fields_u16 (308b5b05-2b12-4cbb-9128-c8a3b961a9fe): Loading data parts | ||
| 677 | 2024.10.09 22:39:29.408189 [ 3 ] {d2404ea6-c48c-47d5-9218-e150ce8c82a5} <Debug> oximeter.fields_u16 (308b5b05-2b12-4cbb-9128-c8a3b961a9fe): There are no data parts | ||
| 678 | 2024.10.09 22:39:29.410665 [ 3 ] {d2404ea6-c48c-47d5-9218-e150ce8c82a5} <Debug> DynamicQueryHandler: Done processing query | ||
| 679 | 2024.10.09 22:39:29.410724 [ 3 ] {} <Debug> HTTP-Session: 4fecdc1f-56b5-4ac4-9906-0d7a4f71dce0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 680 | 2024.10.09 22:39:29.411622 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 681 | 2024.10.09 22:39:29.411710 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 682 | 2024.10.09 22:39:29.411755 [ 3 ] {} <Debug> HTTP-Session: 4d6a66da-a5e2-4ec9-a05e-3ae850ce9533 Authenticating user 'default' from [::1]:35174 | ||
| 683 | 2024.10.09 22:39:29.411785 [ 3 ] {} <Debug> HTTP-Session: 4d6a66da-a5e2-4ec9-a05e-3ae850ce9533 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 684 | 2024.10.09 22:39:29.411802 [ 3 ] {} <Debug> HTTP-Session: 4d6a66da-a5e2-4ec9-a05e-3ae850ce9533 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 685 | 2024.10.09 22:39:29.411868 [ 3 ] {} <Trace> HTTP-Session: 4d6a66da-a5e2-4ec9-a05e-3ae850ce9533 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 686 | 2024.10.09 22:39:29.412222 [ 3 ] {5f818e17-9148-45de-862e-e740a0e966f6} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 687 | 2024.10.09 22:39:29.412308 [ 3 ] {5f818e17-9148-45de-862e-e740a0e966f6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 688 | 2024.10.09 22:39:29.415345 [ 3 ] {5f818e17-9148-45de-862e-e740a0e966f6} <Debug> oximeter.fields_i32 (4c5fbda7-573b-4d94-936c-40eddc897374): Loading data parts | ||
| 689 | 2024.10.09 22:39:29.415900 [ 3 ] {5f818e17-9148-45de-862e-e740a0e966f6} <Debug> oximeter.fields_i32 (4c5fbda7-573b-4d94-936c-40eddc897374): There are no data parts | ||
| 690 | 2024.10.09 22:39:29.430605 [ 3 ] {5f818e17-9148-45de-862e-e740a0e966f6} <Debug> DynamicQueryHandler: Done processing query | ||
| 691 | 2024.10.09 22:39:29.430658 [ 3 ] {} <Debug> HTTP-Session: 4d6a66da-a5e2-4ec9-a05e-3ae850ce9533 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 692 | 2024.10.09 22:39:29.441116 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 693 | 2024.10.09 22:39:29.441271 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 694 | 2024.10.09 22:39:29.441298 [ 3 ] {} <Debug> HTTP-Session: 016f3b8d-0cb6-4857-80d6-59d206b33cfc Authenticating user 'default' from [::1]:35174 | ||
| 695 | 2024.10.09 22:39:29.441323 [ 3 ] {} <Debug> HTTP-Session: 016f3b8d-0cb6-4857-80d6-59d206b33cfc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 696 | 2024.10.09 22:39:29.441347 [ 3 ] {} <Debug> HTTP-Session: 016f3b8d-0cb6-4857-80d6-59d206b33cfc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 697 | 2024.10.09 22:39:29.441406 [ 3 ] {} <Trace> HTTP-Session: 016f3b8d-0cb6-4857-80d6-59d206b33cfc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 698 | 2024.10.09 22:39:29.441815 [ 3 ] {28469c7c-261e-413d-bf12-6adbbe63a069} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 699 | 2024.10.09 22:39:29.441893 [ 3 ] {28469c7c-261e-413d-bf12-6adbbe63a069} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 700 | 2024.10.09 22:39:29.453170 [ 3 ] {28469c7c-261e-413d-bf12-6adbbe63a069} <Debug> oximeter.fields_u32 (84edebce-0da1-4606-a0f7-06727ee575e0): Loading data parts | ||
| 701 | 2024.10.09 22:39:29.453700 [ 3 ] {28469c7c-261e-413d-bf12-6adbbe63a069} <Debug> oximeter.fields_u32 (84edebce-0da1-4606-a0f7-06727ee575e0): There are no data parts | ||
| 702 | 2024.10.09 22:39:29.458150 [ 3 ] {28469c7c-261e-413d-bf12-6adbbe63a069} <Debug> DynamicQueryHandler: Done processing query | ||
| 703 | 2024.10.09 22:39:29.458221 [ 3 ] {} <Debug> HTTP-Session: 016f3b8d-0cb6-4857-80d6-59d206b33cfc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 704 | 2024.10.09 22:39:29.459245 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 705 | 2024.10.09 22:39:29.459347 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 706 | 2024.10.09 22:39:29.459400 [ 3 ] {} <Debug> HTTP-Session: e6d404a4-b54c-4d73-85b2-8649c674a1d0 Authenticating user 'default' from [::1]:35174 | ||
| 707 | 2024.10.09 22:39:29.459428 [ 3 ] {} <Debug> HTTP-Session: e6d404a4-b54c-4d73-85b2-8649c674a1d0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 708 | 2024.10.09 22:39:29.459444 [ 3 ] {} <Debug> HTTP-Session: e6d404a4-b54c-4d73-85b2-8649c674a1d0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 709 | 2024.10.09 22:39:29.459529 [ 3 ] {} <Trace> HTTP-Session: e6d404a4-b54c-4d73-85b2-8649c674a1d0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 710 | 2024.10.09 22:39:29.460507 [ 3 ] {0d3ed347-8424-4753-89f1-14df9fb4e508} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 711 | 2024.10.09 22:39:29.460628 [ 3 ] {0d3ed347-8424-4753-89f1-14df9fb4e508} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 712 | 2024.10.09 22:39:29.464123 [ 3 ] {0d3ed347-8424-4753-89f1-14df9fb4e508} <Debug> oximeter.fields_i64 (fd76a98a-6408-4a9f-91ca-19137b7ce716): Loading data parts | ||
| 713 | 2024.10.09 22:39:29.465024 [ 3 ] {0d3ed347-8424-4753-89f1-14df9fb4e508} <Debug> oximeter.fields_i64 (fd76a98a-6408-4a9f-91ca-19137b7ce716): There are no data parts | ||
| 714 | 2024.10.09 22:39:29.469198 [ 3 ] {0d3ed347-8424-4753-89f1-14df9fb4e508} <Debug> DynamicQueryHandler: Done processing query | ||
| 715 | 2024.10.09 22:39:29.469241 [ 3 ] {} <Debug> HTTP-Session: e6d404a4-b54c-4d73-85b2-8649c674a1d0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 716 | 2024.10.09 22:39:29.470710 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 717 | 2024.10.09 22:39:29.470849 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 718 | 2024.10.09 22:39:29.470882 [ 3 ] {} <Debug> HTTP-Session: 781069f2-6c83-4936-a474-537360b35055 Authenticating user 'default' from [::1]:35174 | ||
| 719 | 2024.10.09 22:39:29.470909 [ 3 ] {} <Debug> HTTP-Session: 781069f2-6c83-4936-a474-537360b35055 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 720 | 2024.10.09 22:39:29.470925 [ 3 ] {} <Debug> HTTP-Session: 781069f2-6c83-4936-a474-537360b35055 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 721 | 2024.10.09 22:39:29.471107 [ 3 ] {} <Trace> HTTP-Session: 781069f2-6c83-4936-a474-537360b35055 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 722 | 2024.10.09 22:39:29.472221 [ 3 ] {e7b0703b-d9d5-4831-913f-2dadf5f03e1a} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 723 | 2024.10.09 22:39:29.472335 [ 3 ] {e7b0703b-d9d5-4831-913f-2dadf5f03e1a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 724 | 2024.10.09 22:39:29.477840 [ 3 ] {e7b0703b-d9d5-4831-913f-2dadf5f03e1a} <Debug> oximeter.fields_u64 (3517ab5e-5c8b-44ca-91b4-3fb40acc60b0): Loading data parts | ||
| 725 | 2024.10.09 22:39:29.478224 [ 3 ] {e7b0703b-d9d5-4831-913f-2dadf5f03e1a} <Debug> oximeter.fields_u64 (3517ab5e-5c8b-44ca-91b4-3fb40acc60b0): There are no data parts | ||
| 726 | 2024.10.09 22:39:29.491255 [ 3 ] {e7b0703b-d9d5-4831-913f-2dadf5f03e1a} <Debug> DynamicQueryHandler: Done processing query | ||
| 727 | 2024.10.09 22:39:29.491304 [ 3 ] {} <Debug> HTTP-Session: 781069f2-6c83-4936-a474-537360b35055 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 728 | 2024.10.09 22:39:29.542856 [ 148 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 729 | 2024.10.09 22:39:29.542910 [ 148 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 730 | 2024.10.09 22:39:29.562444 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 731 | 2024.10.09 22:39:29.562579 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 732 | 2024.10.09 22:39:29.562610 [ 3 ] {} <Debug> HTTP-Session: ba6bd750-61ad-4bbc-92de-1c780d8c9eee Authenticating user 'default' from [::1]:35174 | ||
| 733 | 2024.10.09 22:39:29.562636 [ 3 ] {} <Debug> HTTP-Session: ba6bd750-61ad-4bbc-92de-1c780d8c9eee Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2024.10.09 22:39:29.562651 [ 3 ] {} <Debug> HTTP-Session: ba6bd750-61ad-4bbc-92de-1c780d8c9eee Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 735 | 2024.10.09 22:39:29.562771 [ 3 ] {} <Trace> HTTP-Session: ba6bd750-61ad-4bbc-92de-1c780d8c9eee Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 736 | 2024.10.09 22:39:29.574356 [ 3 ] {7156a9b8-947f-414a-b11e-72d28c1fbf4e} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 737 | 2024.10.09 22:39:29.574463 [ 3 ] {7156a9b8-947f-414a-b11e-72d28c1fbf4e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 738 | 2024.10.09 22:39:29.590543 [ 3 ] {7156a9b8-947f-414a-b11e-72d28c1fbf4e} <Debug> oximeter.fields_ipaddr (2e5a3a34-75a0-4169-9826-f9e18b868234): Loading data parts | ||
| 739 | 2024.10.09 22:39:29.590962 [ 3 ] {7156a9b8-947f-414a-b11e-72d28c1fbf4e} <Debug> oximeter.fields_ipaddr (2e5a3a34-75a0-4169-9826-f9e18b868234): There are no data parts | ||
| 740 | 2024.10.09 22:39:29.617607 [ 3 ] {7156a9b8-947f-414a-b11e-72d28c1fbf4e} <Debug> DynamicQueryHandler: Done processing query | ||
| 741 | 2024.10.09 22:39:29.617663 [ 3 ] {} <Debug> HTTP-Session: ba6bd750-61ad-4bbc-92de-1c780d8c9eee Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 742 | 2024.10.09 22:39:29.647137 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 743 | 2024.10.09 22:39:29.647275 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 744 | 2024.10.09 22:39:29.647309 [ 3 ] {} <Debug> HTTP-Session: 726a2a92-b526-4bdc-82c1-882f0a5fd255 Authenticating user 'default' from [::1]:35174 | ||
| 745 | 2024.10.09 22:39:29.647339 [ 3 ] {} <Debug> HTTP-Session: 726a2a92-b526-4bdc-82c1-882f0a5fd255 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 746 | 2024.10.09 22:39:29.647357 [ 3 ] {} <Debug> HTTP-Session: 726a2a92-b526-4bdc-82c1-882f0a5fd255 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 747 | 2024.10.09 22:39:29.647418 [ 3 ] {} <Trace> HTTP-Session: 726a2a92-b526-4bdc-82c1-882f0a5fd255 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 748 | 2024.10.09 22:39:29.647928 [ 3 ] {aa5cefa1-2da3-4aa3-81e2-fe34695e85e8} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 749 | 2024.10.09 22:39:29.648011 [ 3 ] {aa5cefa1-2da3-4aa3-81e2-fe34695e85e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 750 | 2024.10.09 22:39:29.653786 [ 3 ] {aa5cefa1-2da3-4aa3-81e2-fe34695e85e8} <Debug> oximeter.fields_string (b588d1e0-83cb-477e-8899-740aa1353ab1): Loading data parts | ||
| 751 | 2024.10.09 22:39:29.655006 [ 3 ] {aa5cefa1-2da3-4aa3-81e2-fe34695e85e8} <Debug> oximeter.fields_string (b588d1e0-83cb-477e-8899-740aa1353ab1): There are no data parts | ||
| 752 | 2024.10.09 22:39:29.659301 [ 3 ] {aa5cefa1-2da3-4aa3-81e2-fe34695e85e8} <Debug> DynamicQueryHandler: Done processing query | ||
| 753 | 2024.10.09 22:39:29.659346 [ 3 ] {} <Debug> HTTP-Session: 726a2a92-b526-4bdc-82c1-882f0a5fd255 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 754 | 2024.10.09 22:39:29.677971 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 755 | 2024.10.09 22:39:29.678256 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 756 | 2024.10.09 22:39:29.678297 [ 3 ] {} <Debug> HTTP-Session: 90115d88-f047-42b0-af09-d6bfeef99106 Authenticating user 'default' from [::1]:35174 | ||
| 757 | 2024.10.09 22:39:29.678326 [ 3 ] {} <Debug> HTTP-Session: 90115d88-f047-42b0-af09-d6bfeef99106 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 758 | 2024.10.09 22:39:29.678342 [ 3 ] {} <Debug> HTTP-Session: 90115d88-f047-42b0-af09-d6bfeef99106 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 759 | 2024.10.09 22:39:29.678404 [ 3 ] {} <Trace> HTTP-Session: 90115d88-f047-42b0-af09-d6bfeef99106 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 760 | 2024.10.09 22:39:29.678822 [ 3 ] {1291d227-a168-443d-8fb3-b7867a5d3797} <Debug> executeQuery: (from [::1]:35174) 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) | ||
| 761 | 2024.10.09 22:39:29.678908 [ 3 ] {1291d227-a168-443d-8fb3-b7867a5d3797} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 762 | 2024.10.09 22:39:29.696410 [ 3 ] {1291d227-a168-443d-8fb3-b7867a5d3797} <Debug> oximeter.fields_uuid (9ba298d6-8968-43df-923a-05dd864c1d73): Loading data parts | ||
| 763 | 2024.10.09 22:39:29.697462 [ 3 ] {1291d227-a168-443d-8fb3-b7867a5d3797} <Debug> oximeter.fields_uuid (9ba298d6-8968-43df-923a-05dd864c1d73): There are no data parts | ||
| 764 | 2024.10.09 22:39:29.705521 [ 3 ] {1291d227-a168-443d-8fb3-b7867a5d3797} <Debug> DynamicQueryHandler: Done processing query | ||
| 765 | 2024.10.09 22:39:29.705570 [ 3 ] {} <Debug> HTTP-Session: 90115d88-f047-42b0-af09-d6bfeef99106 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 766 | 2024.10.09 22:39:29.737135 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 767 | 2024.10.09 22:39:29.737433 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 768 | 2024.10.09 22:39:29.737468 [ 3 ] {} <Debug> HTTP-Session: 868ae7a3-cdcc-4c52-9f8b-6990d47e495b Authenticating user 'default' from [::1]:35174 | ||
| 769 | 2024.10.09 22:39:29.737495 [ 3 ] {} <Debug> HTTP-Session: 868ae7a3-cdcc-4c52-9f8b-6990d47e495b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 770 | 2024.10.09 22:39:29.737510 [ 3 ] {} <Debug> HTTP-Session: 868ae7a3-cdcc-4c52-9f8b-6990d47e495b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 771 | 2024.10.09 22:39:29.737568 [ 3 ] {} <Trace> HTTP-Session: 868ae7a3-cdcc-4c52-9f8b-6990d47e495b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 772 | 2024.10.09 22:39:29.738161 [ 3 ] {e390d7c4-37d4-4dbc-a14d-c21b47650034} <Debug> executeQuery: (from [::1]:35174) /* The timeseries schema table stores the extracted schema for the samples | ||
| 773 | * oximeter collects. | ||
| 774 | */ | ||
| 775 | 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) | ||
| 776 | 2024.10.09 22:39:29.738334 [ 3 ] {e390d7c4-37d4-4dbc-a14d-c21b47650034} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 777 | 2024.10.09 22:39:29.742657 [ 3 ] {e390d7c4-37d4-4dbc-a14d-c21b47650034} <Debug> oximeter.timeseries_schema (4fa07043-b073-4c4c-bac7-0607c5b5db02): Loading data parts | ||
| 778 | 2024.10.09 22:39:29.757518 [ 3 ] {e390d7c4-37d4-4dbc-a14d-c21b47650034} <Debug> oximeter.timeseries_schema (4fa07043-b073-4c4c-bac7-0607c5b5db02): There are no data parts | ||
| 779 | 2024.10.09 22:39:29.760090 [ 3 ] {e390d7c4-37d4-4dbc-a14d-c21b47650034} <Debug> DynamicQueryHandler: Done processing query | ||
| 780 | 2024.10.09 22:39:29.760132 [ 3 ] {} <Debug> HTTP-Session: 868ae7a3-cdcc-4c52-9f8b-6990d47e495b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 781 | 2024.10.09 22:39:29.761009 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:35174, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 782 | 2024.10.09 22:39:29.761097 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 783 | 2024.10.09 22:39:29.761122 [ 3 ] {} <Debug> HTTP-Session: 65388cc8-eb9c-4ca3-abfd-08d4df6d83fd Authenticating user 'default' from [::1]:35174 | ||
| 784 | 2024.10.09 22:39:29.761149 [ 3 ] {} <Debug> HTTP-Session: 65388cc8-eb9c-4ca3-abfd-08d4df6d83fd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 785 | 2024.10.09 22:39:29.761165 [ 3 ] {} <Debug> HTTP-Session: 65388cc8-eb9c-4ca3-abfd-08d4df6d83fd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 786 | 2024.10.09 22:39:29.761218 [ 3 ] {} <Trace> HTTP-Session: 65388cc8-eb9c-4ca3-abfd-08d4df6d83fd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 787 | 2024.10.09 22:39:29.761729 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Debug> executeQuery: (from [::1]:35174) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 788 | 2024.10.09 22:39:29.761917 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 789 | 2024.10.09 22:39:29.763638 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Trace> oximeter.version (07a80639-98d9-4fcd-9910-db49c5953a0f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 790 | 2024.10.09 22:39:29.763695 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.25 GiB. | ||
| 791 | 2024.10.09 22:39:29.768585 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 792 | 2024.10.09 22:39:29.769323 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Trace> oximeter.version (07a80639-98d9-4fcd-9910-db49c5953a0f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 793 | 2024.10.09 22:39:29.770334 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.008973 sec., 111.44544745347153 rows/sec., 1.74 KiB/sec. | ||
| 794 | 2024.10.09 22:39:29.770894 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Debug> DynamicQueryHandler: Done processing query | ||
| 795 | 2024.10.09 22:39:29.770929 [ 3 ] {a5bd9384-a31b-4862-9745-d35ef9ed47db} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 796 | 2024.10.09 22:39:29.770948 [ 3 ] {} <Debug> HTTP-Session: 65388cc8-eb9c-4ca3-abfd-08d4df6d83fd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 797 | 2024.10.09 22:39:30.000253 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 188.70 MiB, peak 193.84 MiB, free memory in arenas 0.00 B, will set to 187.31 MiB (RSS), difference: -1.39 MiB | ||