| 1 | 2024.10.09 22:40:19.705751 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 15325 | ||
| 2 | 2024.10.09 22:40:19.705994 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.10.09 22:40:19.706064 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.10.09 22:40:19.717587 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.10.09 22:40:19.727799 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.10.09 22:40:19.727848 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.10.09 22:40:19.727863 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2024.10.09 22:40:19.727935 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_image_promotion.15311.1-clickhouse-aWqSwa/datastore/tmp/ to store temporary data in it | ||
| 9 | 2024.10.09 22:40:19.729678 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.10.09 22:40:19.740926 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.10.09 22:40:19.741676 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 2024.10.09 22:40:19.742861 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.18 GiB (31.32 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 13 | 2024.10.09 22:40:19.742984 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.66 GiB (31.32 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 14 | 2024.10.09 22:40:19.743013 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.10.09 22:40:19.743126 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.10.09 22:40:19.743921 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.10.09 22:40:19.757050 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.10.09 22:40:19.763540 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2024.10.09 22:40:19.787811 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 20 | 2024.10.09 22:40:19.788170 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.10.09 22:40:19.791111 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.10.09 22:40:19.791717 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.10.09 22:40:19.793403 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.10.09 22:40:19.794005 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 2024.10.09 22:40:19.795466 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 26 | 2024.10.09 22:40:19.800181 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.10.09 22:40:19.803233 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2024.10.09 22:40:19.815042 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 29 | 2024.10.09 22:40:19.816728 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2024.10.09 22:40:19.816871 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_image_promotion.15311.1-clickhouse-aWqSwa/datastore/ | ||
| 31 | 2024.10.09 22:40:19.822431 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 32 | 2024.10.09 22:40:19.822472 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000172632 sec | ||
| 33 | 2024.10.09 22:40:19.822505 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 34 | 2024.10.09 22:40:19.822515 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 35 | 2024.10.09 22:40:19.822649 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 36 | 2024.10.09 22:40:19.822698 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 37 | 2024.10.09 22:40:19.822718 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 38 | 2024.10.09 22:40:19.822749 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 39 | 2024.10.09 22:40:19.822761 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 40 | 2024.10.09 22:40:19.822772 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 41 | 2024.10.09 22:40:19.822804 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 42 | 2024.10.09 22:40:19.822815 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 43 | 2024.10.09 22:40:19.822827 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 44 | 2024.10.09 22:40:19.822858 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 45 | 2024.10.09 22:40:19.822870 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 46 | 2024.10.09 22:40:19.822882 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 47 | 2024.10.09 22:40:19.822896 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 48 | 2024.10.09 22:40:19.822925 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 49 | 2024.10.09 22:40:19.822936 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 50 | 2024.10.09 22:40:19.822951 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 51 | 2024.10.09 22:40:19.822980 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 52 | 2024.10.09 22:40:19.822992 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 53 | 2024.10.09 22:40:19.824107 [ 73 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 54 | 2024.10.09 22:40:19.824191 [ 73 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 55 | 2024.10.09 22:40:19.928343 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.10.09 22:40:19.932766 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.10.09 22:40:19.932807 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000135523 sec | ||
| 58 | 2024.10.09 22:40:19.932820 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.10.09 22:40:19.932829 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.10.09 22:40:19.933027 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2024.10.09 22:40:19.933242 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_image_promotion.15311.1-clickhouse-aWqSwa/datastore/user_defined/ | ||
| 62 | 2024.10.09 22:40:19.933300 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.10.09 22:40:19.933313 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2024.10.09 22:40:19.933323 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
| 65 | 2024.10.09 22:40:19.933337 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.10.09 22:40:19.933622 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41303 | ||
| 67 | 2024.10.09 22:40:19.933805 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34440 | ||
| 68 | 2024.10.09 22:40:19.935099 [ 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:40:20.092501 [ 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:40:20.092545 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 71 | 2024.10.09 22:40:20.157643 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 64758 | ||
| 72 | 2024.10.09 22:40:20.157778 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 59927 | ||
| 73 | 2024.10.09 22:40:20.157903 [ 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:40:20.216595 [ 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:40:20.216681 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 76 | 2024.10.09 22:40:21.141689 [ 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:40:21.142105 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 15.62 MiB, free memory in arenas 0.00 B, will set to 178.59 MiB (RSS), difference: 168.69 MiB | ||
| 78 | 2024.10.09 22:40:21.142552 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.8438e-05 sec. | ||
| 79 | 2024.10.09 22:40:21.142979 [ 1 ] {} <Information> Application: Listening for http://[::1]:41303 | ||
| 80 | 2024.10.09 22:40:21.143085 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:34440 | ||
| 81 | 2024.10.09 22:40:21.143156 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004 | ||
| 82 | 2024.10.09 22:40:21.143210 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:64758 | ||
| 83 | 2024.10.09 22:40:21.143319 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:59927 | ||
| 84 | 2024.10.09 22:40:21.143381 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004 | ||
| 85 | 2024.10.09 22:40:21.143396 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 86 | 2024.10.09 22:40:32.447870 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 87 | 2024.10.09 22:40:32.448043 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 88 | 2024.10.09 22:40:32.448080 [ 3 ] {} <Debug> HTTP-Session: 8af145b8-dd6a-4091-8280-dfc316d2a6a0 Authenticating user 'default' from [::1]:47948 | ||
| 89 | 2024.10.09 22:40:32.448119 [ 3 ] {} <Debug> HTTP-Session: 8af145b8-dd6a-4091-8280-dfc316d2a6a0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 90 | 2024.10.09 22:40:32.448137 [ 3 ] {} <Debug> HTTP-Session: 8af145b8-dd6a-4091-8280-dfc316d2a6a0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2024.10.09 22:40:32.448237 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 92 | 2024.10.09 22:40:32.448289 [ 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:40:32.448309 [ 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:40:32.448364 [ 3 ] {} <Trace> HTTP-Session: 8af145b8-dd6a-4091-8280-dfc316d2a6a0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 95 | 2024.10.09 22:40:32.448858 [ 3 ] {94d60e9f-9664-4283-b20d-1c2925d58895} <Debug> executeQuery: (from [::1]:47948) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 96 | 2024.10.09 22:40:32.457661 [ 3 ] {94d60e9f-9664-4283-b20d-1c2925d58895} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:47948) (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:40:32.457934 [ 3 ] {94d60e9f-9664-4283-b20d-1c2925d58895} <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:40:32.458239 [ 3 ] {} <Debug> HTTP-Session: 8af145b8-dd6a-4091-8280-dfc316d2a6a0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2024.10.09 22:40:32.503945 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 148 | 2024.10.09 22:40:32.504077 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 149 | 2024.10.09 22:40:32.504102 [ 3 ] {} <Debug> HTTP-Session: 279901ac-f14f-46f0-aee3-69dc72ad81f2 Authenticating user 'default' from [::1]:47948 | ||
| 150 | 2024.10.09 22:40:32.504127 [ 3 ] {} <Debug> HTTP-Session: 279901ac-f14f-46f0-aee3-69dc72ad81f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 151 | 2024.10.09 22:40:32.504145 [ 3 ] {} <Debug> HTTP-Session: 279901ac-f14f-46f0-aee3-69dc72ad81f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 152 | 2024.10.09 22:40:32.504200 [ 3 ] {} <Trace> HTTP-Session: 279901ac-f14f-46f0-aee3-69dc72ad81f2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 153 | 2024.10.09 22:40:32.504445 [ 3 ] {6ddce503-1788-4efc-8402-fc85f740e4d7} <Debug> executeQuery: (from [::1]:47948) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 154 | 2024.10.09 22:40:32.504871 [ 3 ] {6ddce503-1788-4efc-8402-fc85f740e4d7} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:47948) (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:40:32.505058 [ 3 ] {6ddce503-1788-4efc-8402-fc85f740e4d7} <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:40:32.505282 [ 3 ] {} <Debug> HTTP-Session: 279901ac-f14f-46f0-aee3-69dc72ad81f2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 205 | 2024.10.09 22:40:32.526294 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 206 | 2024.10.09 22:40:32.526433 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 207 | 2024.10.09 22:40:32.526461 [ 3 ] {} <Debug> HTTP-Session: 78de8e7d-bafa-4c37-86ca-500e70125d13 Authenticating user 'default' from [::1]:47948 | ||
| 208 | 2024.10.09 22:40:32.526488 [ 3 ] {} <Debug> HTTP-Session: 78de8e7d-bafa-4c37-86ca-500e70125d13 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 209 | 2024.10.09 22:40:32.526509 [ 3 ] {} <Debug> HTTP-Session: 78de8e7d-bafa-4c37-86ca-500e70125d13 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 210 | 2024.10.09 22:40:32.526568 [ 3 ] {} <Trace> HTTP-Session: 78de8e7d-bafa-4c37-86ca-500e70125d13 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 211 | 2024.10.09 22:40:32.526850 [ 3 ] {77489cf2-ba86-498f-9019-efbf1af68012} <Debug> executeQuery: (from [::1]:47948) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 212 | 2024.10.09 22:40:32.527109 [ 3 ] {77489cf2-ba86-498f-9019-efbf1af68012} <Debug> DynamicQueryHandler: Done processing query | ||
| 213 | 2024.10.09 22:40:32.527134 [ 3 ] {} <Debug> HTTP-Session: 78de8e7d-bafa-4c37-86ca-500e70125d13 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 214 | 2024.10.09 22:40:32.536402 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 215 | 2024.10.09 22:40:32.536549 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 216 | 2024.10.09 22:40:32.536580 [ 3 ] {} <Debug> HTTP-Session: 6b1e35a7-962b-4ebe-bfa9-4857e69d8df2 Authenticating user 'default' from [::1]:47948 | ||
| 217 | 2024.10.09 22:40:32.536606 [ 3 ] {} <Debug> HTTP-Session: 6b1e35a7-962b-4ebe-bfa9-4857e69d8df2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 218 | 2024.10.09 22:40:32.536629 [ 3 ] {} <Debug> HTTP-Session: 6b1e35a7-962b-4ebe-bfa9-4857e69d8df2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 219 | 2024.10.09 22:40:32.536690 [ 3 ] {} <Trace> HTTP-Session: 6b1e35a7-962b-4ebe-bfa9-4857e69d8df2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 220 | 2024.10.09 22:40:32.536921 [ 3 ] {dc671527-b90d-4c46-94ee-2e71bcec4a7d} <Debug> executeQuery: (from [::1]:47948) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 221 | 2024.10.09 22:40:32.537013 [ 3 ] {dc671527-b90d-4c46-94ee-2e71bcec4a7d} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 222 | 2024.10.09 22:40:32.538633 [ 3 ] {dc671527-b90d-4c46-94ee-2e71bcec4a7d} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 223 | 2024.10.09 22:40:32.538663 [ 3 ] {dc671527-b90d-4c46-94ee-2e71bcec4a7d} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.0777e-05 sec | ||
| 224 | 2024.10.09 22:40:32.538688 [ 3 ] {dc671527-b90d-4c46-94ee-2e71bcec4a7d} <Trace> ReferentialDeps: No tables | ||
| 225 | 2024.10.09 22:40:32.538702 [ 3 ] {dc671527-b90d-4c46-94ee-2e71bcec4a7d} <Trace> LoadingDeps: No tables | ||
| 226 | 2024.10.09 22:40:32.538731 [ 3 ] {dc671527-b90d-4c46-94ee-2e71bcec4a7d} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 227 | 2024.10.09 22:40:32.538929 [ 3 ] {dc671527-b90d-4c46-94ee-2e71bcec4a7d} <Debug> DynamicQueryHandler: Done processing query | ||
| 228 | 2024.10.09 22:40:32.538966 [ 3 ] {} <Debug> HTTP-Session: 6b1e35a7-962b-4ebe-bfa9-4857e69d8df2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 229 | 2024.10.09 22:40:32.545602 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 230 | 2024.10.09 22:40:32.545727 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 231 | 2024.10.09 22:40:32.545775 [ 3 ] {} <Debug> HTTP-Session: b06c8172-76ee-45f3-ac9b-bde4058ad8c5 Authenticating user 'default' from [::1]:47948 | ||
| 232 | 2024.10.09 22:40:32.545805 [ 3 ] {} <Debug> HTTP-Session: b06c8172-76ee-45f3-ac9b-bde4058ad8c5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 233 | 2024.10.09 22:40:32.545822 [ 3 ] {} <Debug> HTTP-Session: b06c8172-76ee-45f3-ac9b-bde4058ad8c5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 234 | 2024.10.09 22:40:32.545890 [ 3 ] {} <Trace> HTTP-Session: b06c8172-76ee-45f3-ac9b-bde4058ad8c5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 235 | 2024.10.09 22:40:32.546226 [ 3 ] {56efe9cd-4e43-4a14-9218-35917aa7b31f} <Debug> executeQuery: (from [::1]:47948) /* 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:40:32.546320 [ 3 ] {56efe9cd-4e43-4a14-9218-35917aa7b31f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 238 | 2024.10.09 22:40:32.547987 [ 3 ] {56efe9cd-4e43-4a14-9218-35917aa7b31f} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 239 | 2024.10.09 22:40:32.549286 [ 3 ] {56efe9cd-4e43-4a14-9218-35917aa7b31f} <Debug> oximeter.version (0df667ad-b2e3-4615-8e6f-3f5d8cb8667e): Loading data parts | ||
| 240 | 2024.10.09 22:40:32.551100 [ 3 ] {56efe9cd-4e43-4a14-9218-35917aa7b31f} <Debug> oximeter.version (0df667ad-b2e3-4615-8e6f-3f5d8cb8667e): There are no data parts | ||
| 241 | 2024.10.09 22:40:32.553069 [ 3 ] {56efe9cd-4e43-4a14-9218-35917aa7b31f} <Debug> DynamicQueryHandler: Done processing query | ||
| 242 | 2024.10.09 22:40:32.553101 [ 3 ] {} <Debug> HTTP-Session: b06c8172-76ee-45f3-ac9b-bde4058ad8c5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 243 | 2024.10.09 22:40:32.563185 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 244 | 2024.10.09 22:40:32.563313 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 245 | 2024.10.09 22:40:32.563346 [ 3 ] {} <Debug> HTTP-Session: 5381ffd2-2a9d-4db1-b532-50f9b892a9ea Authenticating user 'default' from [::1]:47948 | ||
| 246 | 2024.10.09 22:40:32.563386 [ 3 ] {} <Debug> HTTP-Session: 5381ffd2-2a9d-4db1-b532-50f9b892a9ea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 247 | 2024.10.09 22:40:32.563402 [ 3 ] {} <Debug> HTTP-Session: 5381ffd2-2a9d-4db1-b532-50f9b892a9ea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 248 | 2024.10.09 22:40:32.563461 [ 3 ] {} <Trace> HTTP-Session: 5381ffd2-2a9d-4db1-b532-50f9b892a9ea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 249 | 2024.10.09 22:40:32.563932 [ 3 ] {d92b0edf-839a-49cf-bad3-db5c273434a2} <Debug> executeQuery: (from [::1]:47948) /* 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:40:32.564023 [ 3 ] {d92b0edf-839a-49cf-bad3-db5c273434a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 261 | 2024.10.09 22:40:32.566840 [ 3 ] {d92b0edf-839a-49cf-bad3-db5c273434a2} <Debug> oximeter.measurements_bool (247aed10-c99a-4f19-951d-c7bdd66b602a): Loading data parts | ||
| 262 | 2024.10.09 22:40:32.567216 [ 3 ] {d92b0edf-839a-49cf-bad3-db5c273434a2} <Debug> oximeter.measurements_bool (247aed10-c99a-4f19-951d-c7bdd66b602a): There are no data parts | ||
| 263 | 2024.10.09 22:40:32.568938 [ 3 ] {d92b0edf-839a-49cf-bad3-db5c273434a2} <Debug> DynamicQueryHandler: Done processing query | ||
| 264 | 2024.10.09 22:40:32.569049 [ 3 ] {} <Debug> HTTP-Session: 5381ffd2-2a9d-4db1-b532-50f9b892a9ea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2024.10.09 22:40:32.574458 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 266 | 2024.10.09 22:40:32.574574 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 267 | 2024.10.09 22:40:32.574624 [ 3 ] {} <Debug> HTTP-Session: 5f07df21-033b-4d94-b13b-a394e6c7c0f7 Authenticating user 'default' from [::1]:47948 | ||
| 268 | 2024.10.09 22:40:32.574654 [ 3 ] {} <Debug> HTTP-Session: 5f07df21-033b-4d94-b13b-a394e6c7c0f7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2024.10.09 22:40:32.574672 [ 3 ] {} <Debug> HTTP-Session: 5f07df21-033b-4d94-b13b-a394e6c7c0f7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2024.10.09 22:40:32.574739 [ 3 ] {} <Trace> HTTP-Session: 5f07df21-033b-4d94-b13b-a394e6c7c0f7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 271 | 2024.10.09 22:40:32.575182 [ 3 ] {e14135b4-d8b2-47c6-9714-9aa3dfce3499} <Debug> executeQuery: (from [::1]:47948) 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:40:32.575280 [ 3 ] {e14135b4-d8b2-47c6-9714-9aa3dfce3499} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 273 | 2024.10.09 22:40:32.577718 [ 3 ] {e14135b4-d8b2-47c6-9714-9aa3dfce3499} <Debug> oximeter.measurements_i8 (567d8a59-d86d-4c09-be80-f59ce27e606c): Loading data parts | ||
| 274 | 2024.10.09 22:40:32.578074 [ 3 ] {e14135b4-d8b2-47c6-9714-9aa3dfce3499} <Debug> oximeter.measurements_i8 (567d8a59-d86d-4c09-be80-f59ce27e606c): There are no data parts | ||
| 275 | 2024.10.09 22:40:32.579777 [ 3 ] {e14135b4-d8b2-47c6-9714-9aa3dfce3499} <Debug> DynamicQueryHandler: Done processing query | ||
| 276 | 2024.10.09 22:40:32.579809 [ 3 ] {} <Debug> HTTP-Session: 5f07df21-033b-4d94-b13b-a394e6c7c0f7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2024.10.09 22:40:32.580955 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 278 | 2024.10.09 22:40:32.581055 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 279 | 2024.10.09 22:40:32.581084 [ 3 ] {} <Debug> HTTP-Session: 82710984-6a87-4bbe-a586-7d3f5bcd3ff7 Authenticating user 'default' from [::1]:47948 | ||
| 280 | 2024.10.09 22:40:32.581109 [ 3 ] {} <Debug> HTTP-Session: 82710984-6a87-4bbe-a586-7d3f5bcd3ff7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 281 | 2024.10.09 22:40:32.581135 [ 3 ] {} <Debug> HTTP-Session: 82710984-6a87-4bbe-a586-7d3f5bcd3ff7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2024.10.09 22:40:32.581184 [ 3 ] {} <Trace> HTTP-Session: 82710984-6a87-4bbe-a586-7d3f5bcd3ff7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 283 | 2024.10.09 22:40:32.581500 [ 3 ] {ec7d8528-97dd-4703-85a1-d9ffb42a8371} <Debug> executeQuery: (from [::1]:47948) 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:40:32.581581 [ 3 ] {ec7d8528-97dd-4703-85a1-d9ffb42a8371} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 285 | 2024.10.09 22:40:32.583952 [ 3 ] {ec7d8528-97dd-4703-85a1-d9ffb42a8371} <Debug> oximeter.measurements_u8 (c131a23b-55be-4049-895d-a17c66b4e2e4): Loading data parts | ||
| 286 | 2024.10.09 22:40:32.584255 [ 3 ] {ec7d8528-97dd-4703-85a1-d9ffb42a8371} <Debug> oximeter.measurements_u8 (c131a23b-55be-4049-895d-a17c66b4e2e4): There are no data parts | ||
| 287 | 2024.10.09 22:40:32.586163 [ 3 ] {ec7d8528-97dd-4703-85a1-d9ffb42a8371} <Debug> DynamicQueryHandler: Done processing query | ||
| 288 | 2024.10.09 22:40:32.586194 [ 3 ] {} <Debug> HTTP-Session: 82710984-6a87-4bbe-a586-7d3f5bcd3ff7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 289 | 2024.10.09 22:40:32.587172 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 290 | 2024.10.09 22:40:32.587251 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 291 | 2024.10.09 22:40:32.587287 [ 3 ] {} <Debug> HTTP-Session: a9a8584a-16f6-4c09-be8e-5ef1b3430632 Authenticating user 'default' from [::1]:47948 | ||
| 292 | 2024.10.09 22:40:32.587312 [ 3 ] {} <Debug> HTTP-Session: a9a8584a-16f6-4c09-be8e-5ef1b3430632 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2024.10.09 22:40:32.587328 [ 3 ] {} <Debug> HTTP-Session: a9a8584a-16f6-4c09-be8e-5ef1b3430632 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2024.10.09 22:40:32.587402 [ 3 ] {} <Trace> HTTP-Session: a9a8584a-16f6-4c09-be8e-5ef1b3430632 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 295 | 2024.10.09 22:40:32.587777 [ 3 ] {b7eb8d9f-fab4-47ac-9c0e-fec59094ab2e} <Debug> executeQuery: (from [::1]:47948) 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:40:32.587860 [ 3 ] {b7eb8d9f-fab4-47ac-9c0e-fec59094ab2e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 297 | 2024.10.09 22:40:32.590391 [ 3 ] {b7eb8d9f-fab4-47ac-9c0e-fec59094ab2e} <Debug> oximeter.measurements_i16 (e073d0e9-6100-401d-a458-a20e4b9adc19): Loading data parts | ||
| 298 | 2024.10.09 22:40:32.590672 [ 3 ] {b7eb8d9f-fab4-47ac-9c0e-fec59094ab2e} <Debug> oximeter.measurements_i16 (e073d0e9-6100-401d-a458-a20e4b9adc19): There are no data parts | ||
| 299 | 2024.10.09 22:40:32.592513 [ 3 ] {b7eb8d9f-fab4-47ac-9c0e-fec59094ab2e} <Debug> DynamicQueryHandler: Done processing query | ||
| 300 | 2024.10.09 22:40:32.592576 [ 3 ] {} <Debug> HTTP-Session: a9a8584a-16f6-4c09-be8e-5ef1b3430632 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 301 | 2024.10.09 22:40:32.593545 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 302 | 2024.10.09 22:40:32.593637 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 303 | 2024.10.09 22:40:32.593663 [ 3 ] {} <Debug> HTTP-Session: 7610ee7f-44dd-44cd-aaf1-f6ea0ddd8678 Authenticating user 'default' from [::1]:47948 | ||
| 304 | 2024.10.09 22:40:32.593688 [ 3 ] {} <Debug> HTTP-Session: 7610ee7f-44dd-44cd-aaf1-f6ea0ddd8678 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 305 | 2024.10.09 22:40:32.593730 [ 3 ] {} <Debug> HTTP-Session: 7610ee7f-44dd-44cd-aaf1-f6ea0ddd8678 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 306 | 2024.10.09 22:40:32.593779 [ 3 ] {} <Trace> HTTP-Session: 7610ee7f-44dd-44cd-aaf1-f6ea0ddd8678 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 307 | 2024.10.09 22:40:32.594111 [ 3 ] {e1632974-23c2-470d-98b7-ff2322f1a752} <Debug> executeQuery: (from [::1]:47948) 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:40:32.594185 [ 3 ] {e1632974-23c2-470d-98b7-ff2322f1a752} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 309 | 2024.10.09 22:40:32.596514 [ 3 ] {e1632974-23c2-470d-98b7-ff2322f1a752} <Debug> oximeter.measurements_u16 (795daa16-189e-4fd7-9a6c-ffc851f1b37f): Loading data parts | ||
| 310 | 2024.10.09 22:40:32.596855 [ 3 ] {e1632974-23c2-470d-98b7-ff2322f1a752} <Debug> oximeter.measurements_u16 (795daa16-189e-4fd7-9a6c-ffc851f1b37f): There are no data parts | ||
| 311 | 2024.10.09 22:40:32.598778 [ 3 ] {e1632974-23c2-470d-98b7-ff2322f1a752} <Debug> DynamicQueryHandler: Done processing query | ||
| 312 | 2024.10.09 22:40:32.598807 [ 3 ] {} <Debug> HTTP-Session: 7610ee7f-44dd-44cd-aaf1-f6ea0ddd8678 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 313 | 2024.10.09 22:40:32.600079 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 314 | 2024.10.09 22:40:32.600155 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 315 | 2024.10.09 22:40:32.600178 [ 3 ] {} <Debug> HTTP-Session: c59f1052-d9b7-49d2-a792-b79c45e8dbd6 Authenticating user 'default' from [::1]:47948 | ||
| 316 | 2024.10.09 22:40:32.600214 [ 3 ] {} <Debug> HTTP-Session: c59f1052-d9b7-49d2-a792-b79c45e8dbd6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 317 | 2024.10.09 22:40:32.600231 [ 3 ] {} <Debug> HTTP-Session: c59f1052-d9b7-49d2-a792-b79c45e8dbd6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 318 | 2024.10.09 22:40:32.600278 [ 3 ] {} <Trace> HTTP-Session: c59f1052-d9b7-49d2-a792-b79c45e8dbd6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 319 | 2024.10.09 22:40:32.600641 [ 3 ] {d1d0feea-f512-45f7-aff6-2cede1c3fdd8} <Debug> executeQuery: (from [::1]:47948) 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:40:32.600720 [ 3 ] {d1d0feea-f512-45f7-aff6-2cede1c3fdd8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 321 | 2024.10.09 22:40:32.603128 [ 3 ] {d1d0feea-f512-45f7-aff6-2cede1c3fdd8} <Debug> oximeter.measurements_i32 (286201b2-5fc7-4fe1-929a-117da462d411): Loading data parts | ||
| 322 | 2024.10.09 22:40:32.603473 [ 3 ] {d1d0feea-f512-45f7-aff6-2cede1c3fdd8} <Debug> oximeter.measurements_i32 (286201b2-5fc7-4fe1-929a-117da462d411): There are no data parts | ||
| 323 | 2024.10.09 22:40:32.605434 [ 3 ] {d1d0feea-f512-45f7-aff6-2cede1c3fdd8} <Debug> DynamicQueryHandler: Done processing query | ||
| 324 | 2024.10.09 22:40:32.605462 [ 3 ] {} <Debug> HTTP-Session: c59f1052-d9b7-49d2-a792-b79c45e8dbd6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 325 | 2024.10.09 22:40:32.606930 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 326 | 2024.10.09 22:40:32.607021 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 327 | 2024.10.09 22:40:32.607046 [ 3 ] {} <Debug> HTTP-Session: 581bbe89-c273-4f5a-bf9f-6c5504de1d74 Authenticating user 'default' from [::1]:47948 | ||
| 328 | 2024.10.09 22:40:32.607070 [ 3 ] {} <Debug> HTTP-Session: 581bbe89-c273-4f5a-bf9f-6c5504de1d74 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 329 | 2024.10.09 22:40:32.607132 [ 3 ] {} <Debug> HTTP-Session: 581bbe89-c273-4f5a-bf9f-6c5504de1d74 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 330 | 2024.10.09 22:40:32.607188 [ 3 ] {} <Trace> HTTP-Session: 581bbe89-c273-4f5a-bf9f-6c5504de1d74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 331 | 2024.10.09 22:40:32.607553 [ 3 ] {dda7fa41-7994-438e-8b51-66f2096be0e7} <Debug> executeQuery: (from [::1]:47948) 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:40:32.607637 [ 3 ] {dda7fa41-7994-438e-8b51-66f2096be0e7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 333 | 2024.10.09 22:40:32.609971 [ 3 ] {dda7fa41-7994-438e-8b51-66f2096be0e7} <Debug> oximeter.measurements_u32 (fd5a0433-4491-4899-9a43-69a3ebafe841): Loading data parts | ||
| 334 | 2024.10.09 22:40:32.610336 [ 3 ] {dda7fa41-7994-438e-8b51-66f2096be0e7} <Debug> oximeter.measurements_u32 (fd5a0433-4491-4899-9a43-69a3ebafe841): There are no data parts | ||
| 335 | 2024.10.09 22:40:32.612342 [ 3 ] {dda7fa41-7994-438e-8b51-66f2096be0e7} <Debug> DynamicQueryHandler: Done processing query | ||
| 336 | 2024.10.09 22:40:32.612377 [ 3 ] {} <Debug> HTTP-Session: 581bbe89-c273-4f5a-bf9f-6c5504de1d74 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 337 | 2024.10.09 22:40:32.613420 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 338 | 2024.10.09 22:40:32.613523 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 339 | 2024.10.09 22:40:32.613552 [ 3 ] {} <Debug> HTTP-Session: e0108b77-06a1-4a42-bbb6-a9084e5972c9 Authenticating user 'default' from [::1]:47948 | ||
| 340 | 2024.10.09 22:40:32.613585 [ 3 ] {} <Debug> HTTP-Session: e0108b77-06a1-4a42-bbb6-a9084e5972c9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 341 | 2024.10.09 22:40:32.613601 [ 3 ] {} <Debug> HTTP-Session: e0108b77-06a1-4a42-bbb6-a9084e5972c9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 342 | 2024.10.09 22:40:32.613649 [ 3 ] {} <Trace> HTTP-Session: e0108b77-06a1-4a42-bbb6-a9084e5972c9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 343 | 2024.10.09 22:40:32.613984 [ 3 ] {c06c99ea-a0f6-4d74-b14d-b212acc40e7d} <Debug> executeQuery: (from [::1]:47948) 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:40:32.614074 [ 3 ] {c06c99ea-a0f6-4d74-b14d-b212acc40e7d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 345 | 2024.10.09 22:40:32.616691 [ 3 ] {c06c99ea-a0f6-4d74-b14d-b212acc40e7d} <Debug> oximeter.measurements_i64 (fd098262-ddc6-4bc0-af3f-d76031eb90d9): Loading data parts | ||
| 346 | 2024.10.09 22:40:32.617094 [ 3 ] {c06c99ea-a0f6-4d74-b14d-b212acc40e7d} <Debug> oximeter.measurements_i64 (fd098262-ddc6-4bc0-af3f-d76031eb90d9): There are no data parts | ||
| 347 | 2024.10.09 22:40:32.618981 [ 3 ] {c06c99ea-a0f6-4d74-b14d-b212acc40e7d} <Debug> DynamicQueryHandler: Done processing query | ||
| 348 | 2024.10.09 22:40:32.619044 [ 3 ] {} <Debug> HTTP-Session: e0108b77-06a1-4a42-bbb6-a9084e5972c9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 349 | 2024.10.09 22:40:32.620031 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 350 | 2024.10.09 22:40:32.620107 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 351 | 2024.10.09 22:40:32.620144 [ 3 ] {} <Debug> HTTP-Session: 4251f91a-640d-481a-bcbf-52843193e6e8 Authenticating user 'default' from [::1]:47948 | ||
| 352 | 2024.10.09 22:40:32.620170 [ 3 ] {} <Debug> HTTP-Session: 4251f91a-640d-481a-bcbf-52843193e6e8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 353 | 2024.10.09 22:40:32.620188 [ 3 ] {} <Debug> HTTP-Session: 4251f91a-640d-481a-bcbf-52843193e6e8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 354 | 2024.10.09 22:40:32.620246 [ 3 ] {} <Trace> HTTP-Session: 4251f91a-640d-481a-bcbf-52843193e6e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 355 | 2024.10.09 22:40:32.620630 [ 3 ] {8cc5d87f-10bf-4b3a-bb3f-44eb22a75545} <Debug> executeQuery: (from [::1]:47948) 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:40:32.620714 [ 3 ] {8cc5d87f-10bf-4b3a-bb3f-44eb22a75545} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 357 | 2024.10.09 22:40:32.623299 [ 3 ] {8cc5d87f-10bf-4b3a-bb3f-44eb22a75545} <Debug> oximeter.measurements_u64 (75d1c4c6-d632-4416-8802-bfb94038f8e8): Loading data parts | ||
| 358 | 2024.10.09 22:40:32.623720 [ 3 ] {8cc5d87f-10bf-4b3a-bb3f-44eb22a75545} <Debug> oximeter.measurements_u64 (75d1c4c6-d632-4416-8802-bfb94038f8e8): There are no data parts | ||
| 359 | 2024.10.09 22:40:32.625533 [ 3 ] {8cc5d87f-10bf-4b3a-bb3f-44eb22a75545} <Debug> DynamicQueryHandler: Done processing query | ||
| 360 | 2024.10.09 22:40:32.625565 [ 3 ] {} <Debug> HTTP-Session: 4251f91a-640d-481a-bcbf-52843193e6e8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 361 | 2024.10.09 22:40:32.626377 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 362 | 2024.10.09 22:40:32.626467 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 363 | 2024.10.09 22:40:32.626493 [ 3 ] {} <Debug> HTTP-Session: b618a68f-128a-4534-94cf-abbecf8fcbc0 Authenticating user 'default' from [::1]:47948 | ||
| 364 | 2024.10.09 22:40:32.626519 [ 3 ] {} <Debug> HTTP-Session: b618a68f-128a-4534-94cf-abbecf8fcbc0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 365 | 2024.10.09 22:40:32.626545 [ 3 ] {} <Debug> HTTP-Session: b618a68f-128a-4534-94cf-abbecf8fcbc0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 366 | 2024.10.09 22:40:32.626597 [ 3 ] {} <Trace> HTTP-Session: b618a68f-128a-4534-94cf-abbecf8fcbc0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 367 | 2024.10.09 22:40:32.626941 [ 3 ] {83294231-46c6-4fea-a4ed-8ad89111aa16} <Debug> executeQuery: (from [::1]:47948) 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:40:32.627026 [ 3 ] {83294231-46c6-4fea-a4ed-8ad89111aa16} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 369 | 2024.10.09 22:40:32.629387 [ 3 ] {83294231-46c6-4fea-a4ed-8ad89111aa16} <Debug> oximeter.measurements_f32 (0fc407e5-79b5-44dc-b665-4d0ba3efe34b): Loading data parts | ||
| 370 | 2024.10.09 22:40:32.629952 [ 3 ] {83294231-46c6-4fea-a4ed-8ad89111aa16} <Debug> oximeter.measurements_f32 (0fc407e5-79b5-44dc-b665-4d0ba3efe34b): There are no data parts | ||
| 371 | 2024.10.09 22:40:32.631917 [ 3 ] {83294231-46c6-4fea-a4ed-8ad89111aa16} <Debug> DynamicQueryHandler: Done processing query | ||
| 372 | 2024.10.09 22:40:32.631951 [ 3 ] {} <Debug> HTTP-Session: b618a68f-128a-4534-94cf-abbecf8fcbc0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 373 | 2024.10.09 22:40:32.634370 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 374 | 2024.10.09 22:40:32.634464 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 375 | 2024.10.09 22:40:32.634506 [ 3 ] {} <Debug> HTTP-Session: af3585bf-6364-484e-93b8-4d3af87d18e7 Authenticating user 'default' from [::1]:47948 | ||
| 376 | 2024.10.09 22:40:32.634535 [ 3 ] {} <Debug> HTTP-Session: af3585bf-6364-484e-93b8-4d3af87d18e7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 377 | 2024.10.09 22:40:32.634551 [ 3 ] {} <Debug> HTTP-Session: af3585bf-6364-484e-93b8-4d3af87d18e7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 378 | 2024.10.09 22:40:32.634605 [ 3 ] {} <Trace> HTTP-Session: af3585bf-6364-484e-93b8-4d3af87d18e7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 379 | 2024.10.09 22:40:32.634998 [ 3 ] {153a70b2-d341-46ae-b969-2e089184025a} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 380 | 2024.10.09 22:40:32.635093 [ 3 ] {153a70b2-d341-46ae-b969-2e089184025a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 381 | 2024.10.09 22:40:32.637275 [ 3 ] {153a70b2-d341-46ae-b969-2e089184025a} <Debug> oximeter.measurements_f64 (4920a2d1-054e-4264-89cd-1184fb95f6fc): Loading data parts | ||
| 382 | 2024.10.09 22:40:32.637612 [ 3 ] {153a70b2-d341-46ae-b969-2e089184025a} <Debug> oximeter.measurements_f64 (4920a2d1-054e-4264-89cd-1184fb95f6fc): There are no data parts | ||
| 383 | 2024.10.09 22:40:32.639303 [ 3 ] {153a70b2-d341-46ae-b969-2e089184025a} <Debug> DynamicQueryHandler: Done processing query | ||
| 384 | 2024.10.09 22:40:32.639331 [ 3 ] {} <Debug> HTTP-Session: af3585bf-6364-484e-93b8-4d3af87d18e7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 385 | 2024.10.09 22:40:32.640076 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 386 | 2024.10.09 22:40:32.640156 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 387 | 2024.10.09 22:40:32.640196 [ 3 ] {} <Debug> HTTP-Session: ddc356fb-4a28-48b1-8f18-82d43f5b529e Authenticating user 'default' from [::1]:47948 | ||
| 388 | 2024.10.09 22:40:32.640222 [ 3 ] {} <Debug> HTTP-Session: ddc356fb-4a28-48b1-8f18-82d43f5b529e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 389 | 2024.10.09 22:40:32.640241 [ 3 ] {} <Debug> HTTP-Session: ddc356fb-4a28-48b1-8f18-82d43f5b529e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 390 | 2024.10.09 22:40:32.640277 [ 3 ] {} <Trace> HTTP-Session: ddc356fb-4a28-48b1-8f18-82d43f5b529e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 391 | 2024.10.09 22:40:32.640632 [ 3 ] {3c106a8b-896b-498b-9227-c4836879d4e6} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 392 | 2024.10.09 22:40:32.640718 [ 3 ] {3c106a8b-896b-498b-9227-c4836879d4e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 393 | 2024.10.09 22:40:32.643083 [ 3 ] {3c106a8b-896b-498b-9227-c4836879d4e6} <Debug> oximeter.measurements_string (921d417a-89f6-4bb9-ba64-641b1ce29ab7): Loading data parts | ||
| 394 | 2024.10.09 22:40:32.643444 [ 3 ] {3c106a8b-896b-498b-9227-c4836879d4e6} <Debug> oximeter.measurements_string (921d417a-89f6-4bb9-ba64-641b1ce29ab7): There are no data parts | ||
| 395 | 2024.10.09 22:40:32.645100 [ 3 ] {3c106a8b-896b-498b-9227-c4836879d4e6} <Debug> DynamicQueryHandler: Done processing query | ||
| 396 | 2024.10.09 22:40:32.645131 [ 3 ] {} <Debug> HTTP-Session: ddc356fb-4a28-48b1-8f18-82d43f5b529e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 397 | 2024.10.09 22:40:32.645793 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 398 | 2024.10.09 22:40:32.645864 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 399 | 2024.10.09 22:40:32.645886 [ 3 ] {} <Debug> HTTP-Session: 1f146d46-74e3-4268-b78e-16511f8ab5e6 Authenticating user 'default' from [::1]:47948 | ||
| 400 | 2024.10.09 22:40:32.645919 [ 3 ] {} <Debug> HTTP-Session: 1f146d46-74e3-4268-b78e-16511f8ab5e6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 401 | 2024.10.09 22:40:32.645936 [ 3 ] {} <Debug> HTTP-Session: 1f146d46-74e3-4268-b78e-16511f8ab5e6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 402 | 2024.10.09 22:40:32.645984 [ 3 ] {} <Trace> HTTP-Session: 1f146d46-74e3-4268-b78e-16511f8ab5e6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 403 | 2024.10.09 22:40:32.646291 [ 3 ] {a0cfe79f-692e-40c7-bea8-1472b5938300} <Debug> executeQuery: (from [::1]:47948) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 404 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 405 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 406 | * a string isn't palatable for a few reasons. | ||
| 407 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 408 | * details. | ||
| 409 | */ | ||
| 410 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 411 | 2024.10.09 22:40:32.646362 [ 3 ] {a0cfe79f-692e-40c7-bea8-1472b5938300} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 412 | 2024.10.09 22:40:32.648759 [ 3 ] {a0cfe79f-692e-40c7-bea8-1472b5938300} <Debug> oximeter.measurements_bytes (001951e1-6096-4d7f-92ab-3d0b0c890f14): Loading data parts | ||
| 413 | 2024.10.09 22:40:32.649148 [ 3 ] {a0cfe79f-692e-40c7-bea8-1472b5938300} <Debug> oximeter.measurements_bytes (001951e1-6096-4d7f-92ab-3d0b0c890f14): There are no data parts | ||
| 414 | 2024.10.09 22:40:32.651238 [ 3 ] {a0cfe79f-692e-40c7-bea8-1472b5938300} <Debug> DynamicQueryHandler: Done processing query | ||
| 415 | 2024.10.09 22:40:32.651307 [ 3 ] {} <Debug> HTTP-Session: 1f146d46-74e3-4268-b78e-16511f8ab5e6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 416 | 2024.10.09 22:40:32.652459 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 417 | 2024.10.09 22:40:32.652600 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 418 | 2024.10.09 22:40:32.652637 [ 3 ] {} <Debug> HTTP-Session: 15218cc5-76f7-4063-8b44-e36951780752 Authenticating user 'default' from [::1]:47948 | ||
| 419 | 2024.10.09 22:40:32.652681 [ 3 ] {} <Debug> HTTP-Session: 15218cc5-76f7-4063-8b44-e36951780752 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 420 | 2024.10.09 22:40:32.652700 [ 3 ] {} <Debug> HTTP-Session: 15218cc5-76f7-4063-8b44-e36951780752 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 421 | 2024.10.09 22:40:32.652751 [ 3 ] {} <Trace> HTTP-Session: 15218cc5-76f7-4063-8b44-e36951780752 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 422 | 2024.10.09 22:40:32.653165 [ 3 ] {3f8bf5d3-3af0-4b91-b725-d37fc434ed1e} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 423 | 2024.10.09 22:40:32.653280 [ 3 ] {3f8bf5d3-3af0-4b91-b725-d37fc434ed1e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 424 | 2024.10.09 22:40:32.660686 [ 3 ] {3f8bf5d3-3af0-4b91-b725-d37fc434ed1e} <Debug> oximeter.measurements_cumulativei64 (f6442108-c88a-4d8e-ba4d-c274f3e4b03e): Loading data parts | ||
| 425 | 2024.10.09 22:40:32.661122 [ 3 ] {3f8bf5d3-3af0-4b91-b725-d37fc434ed1e} <Debug> oximeter.measurements_cumulativei64 (f6442108-c88a-4d8e-ba4d-c274f3e4b03e): There are no data parts | ||
| 426 | 2024.10.09 22:40:32.663339 [ 3 ] {3f8bf5d3-3af0-4b91-b725-d37fc434ed1e} <Debug> DynamicQueryHandler: Done processing query | ||
| 427 | 2024.10.09 22:40:32.663373 [ 3 ] {} <Debug> HTTP-Session: 15218cc5-76f7-4063-8b44-e36951780752 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 428 | 2024.10.09 22:40:32.664355 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 429 | 2024.10.09 22:40:32.664469 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 430 | 2024.10.09 22:40:32.664500 [ 3 ] {} <Debug> HTTP-Session: 8dde3ec0-018a-4e93-853e-c4c75bfb6ba4 Authenticating user 'default' from [::1]:47948 | ||
| 431 | 2024.10.09 22:40:32.664537 [ 3 ] {} <Debug> HTTP-Session: 8dde3ec0-018a-4e93-853e-c4c75bfb6ba4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 432 | 2024.10.09 22:40:32.664571 [ 3 ] {} <Debug> HTTP-Session: 8dde3ec0-018a-4e93-853e-c4c75bfb6ba4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 433 | 2024.10.09 22:40:32.664634 [ 3 ] {} <Trace> HTTP-Session: 8dde3ec0-018a-4e93-853e-c4c75bfb6ba4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 434 | 2024.10.09 22:40:32.665105 [ 3 ] {5776667a-a70a-44ac-a147-cbbf95b02bca} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 435 | 2024.10.09 22:40:32.665282 [ 3 ] {5776667a-a70a-44ac-a147-cbbf95b02bca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 436 | 2024.10.09 22:40:32.668100 [ 3 ] {5776667a-a70a-44ac-a147-cbbf95b02bca} <Debug> oximeter.measurements_cumulativeu64 (fbc8fba7-08c0-41c6-a867-4d3be452e1e3): Loading data parts | ||
| 437 | 2024.10.09 22:40:32.668492 [ 3 ] {5776667a-a70a-44ac-a147-cbbf95b02bca} <Debug> oximeter.measurements_cumulativeu64 (fbc8fba7-08c0-41c6-a867-4d3be452e1e3): There are no data parts | ||
| 438 | 2024.10.09 22:40:32.670426 [ 3 ] {5776667a-a70a-44ac-a147-cbbf95b02bca} <Debug> DynamicQueryHandler: Done processing query | ||
| 439 | 2024.10.09 22:40:32.670478 [ 3 ] {} <Debug> HTTP-Session: 8dde3ec0-018a-4e93-853e-c4c75bfb6ba4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 440 | 2024.10.09 22:40:32.681530 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 441 | 2024.10.09 22:40:32.681655 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 442 | 2024.10.09 22:40:32.681705 [ 3 ] {} <Debug> HTTP-Session: 53d8c2d2-53ea-4558-9ec7-5076540bdf26 Authenticating user 'default' from [::1]:47948 | ||
| 443 | 2024.10.09 22:40:32.681735 [ 3 ] {} <Debug> HTTP-Session: 53d8c2d2-53ea-4558-9ec7-5076540bdf26 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 444 | 2024.10.09 22:40:32.681838 [ 3 ] {} <Debug> HTTP-Session: 53d8c2d2-53ea-4558-9ec7-5076540bdf26 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 445 | 2024.10.09 22:40:32.681916 [ 3 ] {} <Trace> HTTP-Session: 53d8c2d2-53ea-4558-9ec7-5076540bdf26 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 446 | 2024.10.09 22:40:32.682479 [ 3 ] {30256e31-2d5c-4abb-aeb0-02bbb2d3dced} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 447 | 2024.10.09 22:40:32.682571 [ 3 ] {30256e31-2d5c-4abb-aeb0-02bbb2d3dced} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 448 | 2024.10.09 22:40:32.685243 [ 3 ] {30256e31-2d5c-4abb-aeb0-02bbb2d3dced} <Debug> oximeter.measurements_cumulativef32 (3f53d883-5214-4949-a3be-8c2ea0a2dbb8): Loading data parts | ||
| 449 | 2024.10.09 22:40:32.685582 [ 3 ] {30256e31-2d5c-4abb-aeb0-02bbb2d3dced} <Debug> oximeter.measurements_cumulativef32 (3f53d883-5214-4949-a3be-8c2ea0a2dbb8): There are no data parts | ||
| 450 | 2024.10.09 22:40:32.688146 [ 3 ] {30256e31-2d5c-4abb-aeb0-02bbb2d3dced} <Debug> DynamicQueryHandler: Done processing query | ||
| 451 | 2024.10.09 22:40:32.688176 [ 3 ] {} <Debug> HTTP-Session: 53d8c2d2-53ea-4558-9ec7-5076540bdf26 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 452 | 2024.10.09 22:40:32.697681 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 453 | 2024.10.09 22:40:32.697821 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 454 | 2024.10.09 22:40:32.697850 [ 3 ] {} <Debug> HTTP-Session: 4a066fd0-1095-4df8-919f-affbaecfce41 Authenticating user 'default' from [::1]:47948 | ||
| 455 | 2024.10.09 22:40:32.697893 [ 3 ] {} <Debug> HTTP-Session: 4a066fd0-1095-4df8-919f-affbaecfce41 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 456 | 2024.10.09 22:40:32.697982 [ 3 ] {} <Debug> HTTP-Session: 4a066fd0-1095-4df8-919f-affbaecfce41 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 457 | 2024.10.09 22:40:32.698047 [ 3 ] {} <Trace> HTTP-Session: 4a066fd0-1095-4df8-919f-affbaecfce41 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 458 | 2024.10.09 22:40:32.698475 [ 3 ] {033ce632-acb4-42f6-9ffc-4ecb596edd63} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 459 | 2024.10.09 22:40:32.698556 [ 3 ] {033ce632-acb4-42f6-9ffc-4ecb596edd63} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 460 | 2024.10.09 22:40:32.701262 [ 3 ] {033ce632-acb4-42f6-9ffc-4ecb596edd63} <Debug> oximeter.measurements_cumulativef64 (815b74da-8ce9-4291-b237-07dd855cf6eb): Loading data parts | ||
| 461 | 2024.10.09 22:40:32.701790 [ 3 ] {033ce632-acb4-42f6-9ffc-4ecb596edd63} <Debug> oximeter.measurements_cumulativef64 (815b74da-8ce9-4291-b237-07dd855cf6eb): There are no data parts | ||
| 462 | 2024.10.09 22:40:32.703761 [ 3 ] {033ce632-acb4-42f6-9ffc-4ecb596edd63} <Debug> DynamicQueryHandler: Done processing query | ||
| 463 | 2024.10.09 22:40:32.703793 [ 3 ] {} <Debug> HTTP-Session: 4a066fd0-1095-4df8-919f-affbaecfce41 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 464 | 2024.10.09 22:40:32.705765 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 465 | 2024.10.09 22:40:32.705861 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 466 | 2024.10.09 22:40:32.705886 [ 3 ] {} <Debug> HTTP-Session: d1c32179-8156-471f-98db-798b96d3fea7 Authenticating user 'default' from [::1]:47948 | ||
| 467 | 2024.10.09 22:40:32.705912 [ 3 ] {} <Debug> HTTP-Session: d1c32179-8156-471f-98db-798b96d3fea7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 468 | 2024.10.09 22:40:32.705927 [ 3 ] {} <Debug> HTTP-Session: d1c32179-8156-471f-98db-798b96d3fea7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 469 | 2024.10.09 22:40:32.705988 [ 3 ] {} <Trace> HTTP-Session: d1c32179-8156-471f-98db-798b96d3fea7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 470 | 2024.10.09 22:40:32.706621 [ 3 ] {32730c2a-1f2b-4719-a45c-546428f31708} <Debug> executeQuery: (from [::1]:47948) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 471 | * NOTE: Array types cannot be Nullable, see | ||
| 472 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 473 | * for more details. | ||
| 474 | * | ||
| 475 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 476 | * is unfortunate, and at this point relies on the fact that an | ||
| 477 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 478 | * to figure out another way to represent missing samples here. | ||
| 479 | */ | ||
| 480 | 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) | ||
| 481 | 2024.10.09 22:40:32.706734 [ 3 ] {32730c2a-1f2b-4719-a45c-546428f31708} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 482 | 2024.10.09 22:40:32.710192 [ 3 ] {32730c2a-1f2b-4719-a45c-546428f31708} <Debug> oximeter.measurements_histogrami8 (f6ff4962-cf74-475c-a3c4-12505022711c): Loading data parts | ||
| 483 | 2024.10.09 22:40:32.710513 [ 3 ] {32730c2a-1f2b-4719-a45c-546428f31708} <Debug> oximeter.measurements_histogrami8 (f6ff4962-cf74-475c-a3c4-12505022711c): There are no data parts | ||
| 484 | 2024.10.09 22:40:32.712949 [ 3 ] {32730c2a-1f2b-4719-a45c-546428f31708} <Debug> DynamicQueryHandler: Done processing query | ||
| 485 | 2024.10.09 22:40:32.712982 [ 3 ] {} <Debug> HTTP-Session: d1c32179-8156-471f-98db-798b96d3fea7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 486 | 2024.10.09 22:40:32.715136 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 487 | 2024.10.09 22:40:32.715247 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 488 | 2024.10.09 22:40:32.715282 [ 3 ] {} <Debug> HTTP-Session: 726de165-ba52-4b56-9cba-0ed7008ddc01 Authenticating user 'default' from [::1]:47948 | ||
| 489 | 2024.10.09 22:40:32.715323 [ 3 ] {} <Debug> HTTP-Session: 726de165-ba52-4b56-9cba-0ed7008ddc01 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 490 | 2024.10.09 22:40:32.715349 [ 3 ] {} <Debug> HTTP-Session: 726de165-ba52-4b56-9cba-0ed7008ddc01 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 491 | 2024.10.09 22:40:32.715406 [ 3 ] {} <Trace> HTTP-Session: 726de165-ba52-4b56-9cba-0ed7008ddc01 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 492 | 2024.10.09 22:40:32.715961 [ 3 ] {6f983f68-a4c9-4d1f-a049-69d36931a8de} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 493 | 2024.10.09 22:40:32.716061 [ 3 ] {6f983f68-a4c9-4d1f-a049-69d36931a8de} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 494 | 2024.10.09 22:40:32.719456 [ 3 ] {6f983f68-a4c9-4d1f-a049-69d36931a8de} <Debug> oximeter.measurements_histogramu8 (0cf7a28c-002b-4291-b32b-5abaad1e6c07): Loading data parts | ||
| 495 | 2024.10.09 22:40:32.719804 [ 3 ] {6f983f68-a4c9-4d1f-a049-69d36931a8de} <Debug> oximeter.measurements_histogramu8 (0cf7a28c-002b-4291-b32b-5abaad1e6c07): There are no data parts | ||
| 496 | 2024.10.09 22:40:32.721787 [ 3 ] {6f983f68-a4c9-4d1f-a049-69d36931a8de} <Debug> DynamicQueryHandler: Done processing query | ||
| 497 | 2024.10.09 22:40:32.721819 [ 3 ] {} <Debug> HTTP-Session: 726de165-ba52-4b56-9cba-0ed7008ddc01 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 498 | 2024.10.09 22:40:32.728221 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 499 | 2024.10.09 22:40:32.728347 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 500 | 2024.10.09 22:40:32.728391 [ 3 ] {} <Debug> HTTP-Session: 9044f2e0-7193-48cb-ba0f-666a3a549f83 Authenticating user 'default' from [::1]:47948 | ||
| 501 | 2024.10.09 22:40:32.728419 [ 3 ] {} <Debug> HTTP-Session: 9044f2e0-7193-48cb-ba0f-666a3a549f83 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 502 | 2024.10.09 22:40:32.728436 [ 3 ] {} <Debug> HTTP-Session: 9044f2e0-7193-48cb-ba0f-666a3a549f83 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 503 | 2024.10.09 22:40:32.728737 [ 3 ] {} <Trace> HTTP-Session: 9044f2e0-7193-48cb-ba0f-666a3a549f83 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 504 | 2024.10.09 22:40:32.729320 [ 3 ] {5c0f0922-e7a4-4113-a774-e21b0cd89959} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 505 | 2024.10.09 22:40:32.729423 [ 3 ] {5c0f0922-e7a4-4113-a774-e21b0cd89959} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 506 | 2024.10.09 22:40:32.733402 [ 3 ] {5c0f0922-e7a4-4113-a774-e21b0cd89959} <Debug> oximeter.measurements_histogrami16 (820fce3a-6a7a-443b-876a-a61412f0ea91): Loading data parts | ||
| 507 | 2024.10.09 22:40:32.733829 [ 3 ] {5c0f0922-e7a4-4113-a774-e21b0cd89959} <Debug> oximeter.measurements_histogrami16 (820fce3a-6a7a-443b-876a-a61412f0ea91): There are no data parts | ||
| 508 | 2024.10.09 22:40:32.735884 [ 3 ] {5c0f0922-e7a4-4113-a774-e21b0cd89959} <Debug> DynamicQueryHandler: Done processing query | ||
| 509 | 2024.10.09 22:40:32.735916 [ 3 ] {} <Debug> HTTP-Session: 9044f2e0-7193-48cb-ba0f-666a3a549f83 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 510 | 2024.10.09 22:40:32.741802 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 511 | 2024.10.09 22:40:32.741940 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 512 | 2024.10.09 22:40:32.741973 [ 3 ] {} <Debug> HTTP-Session: 22f6c31d-8fe5-4ed5-a26f-c80e3cb6dbef Authenticating user 'default' from [::1]:47948 | ||
| 513 | 2024.10.09 22:40:32.742001 [ 3 ] {} <Debug> HTTP-Session: 22f6c31d-8fe5-4ed5-a26f-c80e3cb6dbef Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 514 | 2024.10.09 22:40:32.742042 [ 3 ] {} <Debug> HTTP-Session: 22f6c31d-8fe5-4ed5-a26f-c80e3cb6dbef Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 515 | 2024.10.09 22:40:32.742101 [ 3 ] {} <Trace> HTTP-Session: 22f6c31d-8fe5-4ed5-a26f-c80e3cb6dbef Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 516 | 2024.10.09 22:40:32.742978 [ 3 ] {e3ee72ff-1ed0-4533-a8a3-d6c97d16d7b7} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 517 | 2024.10.09 22:40:32.743084 [ 3 ] {e3ee72ff-1ed0-4533-a8a3-d6c97d16d7b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 518 | 2024.10.09 22:40:32.747804 [ 3 ] {e3ee72ff-1ed0-4533-a8a3-d6c97d16d7b7} <Debug> oximeter.measurements_histogramu16 (8a52ef03-74cd-42b3-9d73-12ef99a02034): Loading data parts | ||
| 519 | 2024.10.09 22:40:32.748178 [ 3 ] {e3ee72ff-1ed0-4533-a8a3-d6c97d16d7b7} <Debug> oximeter.measurements_histogramu16 (8a52ef03-74cd-42b3-9d73-12ef99a02034): There are no data parts | ||
| 520 | 2024.10.09 22:40:32.750237 [ 3 ] {e3ee72ff-1ed0-4533-a8a3-d6c97d16d7b7} <Debug> DynamicQueryHandler: Done processing query | ||
| 521 | 2024.10.09 22:40:32.750269 [ 3 ] {} <Debug> HTTP-Session: 22f6c31d-8fe5-4ed5-a26f-c80e3cb6dbef Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 522 | 2024.10.09 22:40:32.751999 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 523 | 2024.10.09 22:40:32.752085 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 524 | 2024.10.09 22:40:32.752113 [ 3 ] {} <Debug> HTTP-Session: b8990d9e-c6a3-4786-a03a-abe280323826 Authenticating user 'default' from [::1]:47948 | ||
| 525 | 2024.10.09 22:40:32.752153 [ 3 ] {} <Debug> HTTP-Session: b8990d9e-c6a3-4786-a03a-abe280323826 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 526 | 2024.10.09 22:40:32.752170 [ 3 ] {} <Debug> HTTP-Session: b8990d9e-c6a3-4786-a03a-abe280323826 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 527 | 2024.10.09 22:40:32.752290 [ 3 ] {} <Trace> HTTP-Session: b8990d9e-c6a3-4786-a03a-abe280323826 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 528 | 2024.10.09 22:40:32.752772 [ 3 ] {066cf3e8-2b72-4f5a-ac73-4904b46ce148} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 529 | 2024.10.09 22:40:32.752868 [ 3 ] {066cf3e8-2b72-4f5a-ac73-4904b46ce148} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 530 | 2024.10.09 22:40:32.756003 [ 3 ] {066cf3e8-2b72-4f5a-ac73-4904b46ce148} <Debug> oximeter.measurements_histogrami32 (ce9f8753-624c-4e83-94e2-65c6b6f409fd): Loading data parts | ||
| 531 | 2024.10.09 22:40:32.756386 [ 3 ] {066cf3e8-2b72-4f5a-ac73-4904b46ce148} <Debug> oximeter.measurements_histogrami32 (ce9f8753-624c-4e83-94e2-65c6b6f409fd): There are no data parts | ||
| 532 | 2024.10.09 22:40:32.758480 [ 3 ] {066cf3e8-2b72-4f5a-ac73-4904b46ce148} <Debug> DynamicQueryHandler: Done processing query | ||
| 533 | 2024.10.09 22:40:32.758511 [ 3 ] {} <Debug> HTTP-Session: b8990d9e-c6a3-4786-a03a-abe280323826 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 534 | 2024.10.09 22:40:32.763356 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 535 | 2024.10.09 22:40:32.763515 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 536 | 2024.10.09 22:40:32.763550 [ 3 ] {} <Debug> HTTP-Session: 1205c908-9a4e-47ef-bb56-7ddad8f83ed3 Authenticating user 'default' from [::1]:47948 | ||
| 537 | 2024.10.09 22:40:32.763579 [ 3 ] {} <Debug> HTTP-Session: 1205c908-9a4e-47ef-bb56-7ddad8f83ed3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 538 | 2024.10.09 22:40:32.763596 [ 3 ] {} <Debug> HTTP-Session: 1205c908-9a4e-47ef-bb56-7ddad8f83ed3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 539 | 2024.10.09 22:40:32.763669 [ 3 ] {} <Trace> HTTP-Session: 1205c908-9a4e-47ef-bb56-7ddad8f83ed3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 540 | 2024.10.09 22:40:32.764417 [ 3 ] {916ffc37-415d-4248-82b2-fe8c08e2fa6b} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 541 | 2024.10.09 22:40:32.764612 [ 3 ] {916ffc37-415d-4248-82b2-fe8c08e2fa6b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 542 | 2024.10.09 22:40:32.779078 [ 3 ] {916ffc37-415d-4248-82b2-fe8c08e2fa6b} <Debug> oximeter.measurements_histogramu32 (908fb906-fb74-42a3-93d0-90501a4aee13): Loading data parts | ||
| 543 | 2024.10.09 22:40:32.783077 [ 3 ] {916ffc37-415d-4248-82b2-fe8c08e2fa6b} <Debug> oximeter.measurements_histogramu32 (908fb906-fb74-42a3-93d0-90501a4aee13): There are no data parts | ||
| 544 | 2024.10.09 22:40:32.803076 [ 3 ] {916ffc37-415d-4248-82b2-fe8c08e2fa6b} <Debug> DynamicQueryHandler: Done processing query | ||
| 545 | 2024.10.09 22:40:32.803126 [ 3 ] {} <Debug> HTTP-Session: 1205c908-9a4e-47ef-bb56-7ddad8f83ed3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 546 | 2024.10.09 22:40:32.813154 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 547 | 2024.10.09 22:40:32.813290 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 548 | 2024.10.09 22:40:32.813314 [ 3 ] {} <Debug> HTTP-Session: 9137c216-664c-42de-b32f-e8d889400f27 Authenticating user 'default' from [::1]:47948 | ||
| 549 | 2024.10.09 22:40:32.813347 [ 3 ] {} <Debug> HTTP-Session: 9137c216-664c-42de-b32f-e8d889400f27 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 550 | 2024.10.09 22:40:32.813361 [ 3 ] {} <Debug> HTTP-Session: 9137c216-664c-42de-b32f-e8d889400f27 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 551 | 2024.10.09 22:40:32.813414 [ 3 ] {} <Trace> HTTP-Session: 9137c216-664c-42de-b32f-e8d889400f27 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 552 | 2024.10.09 22:40:32.813971 [ 3 ] {2190f719-48d4-4347-ace0-e6ede20cb292} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 553 | 2024.10.09 22:40:32.814067 [ 3 ] {2190f719-48d4-4347-ace0-e6ede20cb292} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 554 | 2024.10.09 22:40:32.819099 [ 3 ] {2190f719-48d4-4347-ace0-e6ede20cb292} <Debug> oximeter.measurements_histogrami64 (2d47627d-59f6-428c-9b79-d3762db42df0): Loading data parts | ||
| 555 | 2024.10.09 22:40:32.822501 [ 3 ] {2190f719-48d4-4347-ace0-e6ede20cb292} <Debug> oximeter.measurements_histogrami64 (2d47627d-59f6-428c-9b79-d3762db42df0): There are no data parts | ||
| 556 | 2024.10.09 22:40:32.825741 [ 3 ] {2190f719-48d4-4347-ace0-e6ede20cb292} <Debug> DynamicQueryHandler: Done processing query | ||
| 557 | 2024.10.09 22:40:32.825963 [ 3 ] {} <Debug> HTTP-Session: 9137c216-664c-42de-b32f-e8d889400f27 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 558 | 2024.10.09 22:40:32.826800 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 559 | 2024.10.09 22:40:32.826875 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 560 | 2024.10.09 22:40:32.826909 [ 3 ] {} <Debug> HTTP-Session: 26979df9-ca75-432d-a21d-2164d2f088b0 Authenticating user 'default' from [::1]:47948 | ||
| 561 | 2024.10.09 22:40:32.826932 [ 3 ] {} <Debug> HTTP-Session: 26979df9-ca75-432d-a21d-2164d2f088b0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 562 | 2024.10.09 22:40:32.826945 [ 3 ] {} <Debug> HTTP-Session: 26979df9-ca75-432d-a21d-2164d2f088b0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 563 | 2024.10.09 22:40:32.828098 [ 3 ] {} <Trace> HTTP-Session: 26979df9-ca75-432d-a21d-2164d2f088b0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 564 | 2024.10.09 22:40:32.828605 [ 3 ] {ad943ebc-5131-40a2-b535-72269b17bfad} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 565 | 2024.10.09 22:40:32.828703 [ 3 ] {ad943ebc-5131-40a2-b535-72269b17bfad} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 566 | 2024.10.09 22:40:32.831632 [ 3 ] {ad943ebc-5131-40a2-b535-72269b17bfad} <Debug> oximeter.measurements_histogramu64 (22e6ba7c-93b3-4307-b3fb-8c2efb01a3dd): Loading data parts | ||
| 567 | 2024.10.09 22:40:32.832266 [ 3 ] {ad943ebc-5131-40a2-b535-72269b17bfad} <Debug> oximeter.measurements_histogramu64 (22e6ba7c-93b3-4307-b3fb-8c2efb01a3dd): There are no data parts | ||
| 568 | 2024.10.09 22:40:32.835069 [ 3 ] {ad943ebc-5131-40a2-b535-72269b17bfad} <Debug> DynamicQueryHandler: Done processing query | ||
| 569 | 2024.10.09 22:40:32.835105 [ 3 ] {} <Debug> HTTP-Session: 26979df9-ca75-432d-a21d-2164d2f088b0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 570 | 2024.10.09 22:40:32.835979 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 571 | 2024.10.09 22:40:32.837834 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 572 | 2024.10.09 22:40:32.837876 [ 3 ] {} <Debug> HTTP-Session: 059806b2-f005-4208-835e-0d7913f952a9 Authenticating user 'default' from [::1]:47948 | ||
| 573 | 2024.10.09 22:40:32.837906 [ 3 ] {} <Debug> HTTP-Session: 059806b2-f005-4208-835e-0d7913f952a9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 574 | 2024.10.09 22:40:32.837958 [ 3 ] {} <Debug> HTTP-Session: 059806b2-f005-4208-835e-0d7913f952a9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 575 | 2024.10.09 22:40:32.838044 [ 3 ] {} <Trace> HTTP-Session: 059806b2-f005-4208-835e-0d7913f952a9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 576 | 2024.10.09 22:40:32.838542 [ 3 ] {4afeb069-d518-445b-ad8c-9dc4f4348d77} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 577 | 2024.10.09 22:40:32.838640 [ 3 ] {4afeb069-d518-445b-ad8c-9dc4f4348d77} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 578 | 2024.10.09 22:40:32.843648 [ 3 ] {4afeb069-d518-445b-ad8c-9dc4f4348d77} <Debug> oximeter.measurements_histogramf32 (90f9e490-948c-4c94-b926-3738cc91cf5f): Loading data parts | ||
| 579 | 2024.10.09 22:40:32.843962 [ 3 ] {4afeb069-d518-445b-ad8c-9dc4f4348d77} <Debug> oximeter.measurements_histogramf32 (90f9e490-948c-4c94-b926-3738cc91cf5f): There are no data parts | ||
| 580 | 2024.10.09 22:40:32.845945 [ 3 ] {4afeb069-d518-445b-ad8c-9dc4f4348d77} <Debug> DynamicQueryHandler: Done processing query | ||
| 581 | 2024.10.09 22:40:32.846144 [ 3 ] {} <Debug> HTTP-Session: 059806b2-f005-4208-835e-0d7913f952a9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 582 | 2024.10.09 22:40:32.847012 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 583 | 2024.10.09 22:40:32.847097 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 584 | 2024.10.09 22:40:32.847144 [ 3 ] {} <Debug> HTTP-Session: befe122a-3de2-4450-ba70-b4f6ef0689c6 Authenticating user 'default' from [::1]:47948 | ||
| 585 | 2024.10.09 22:40:32.847172 [ 3 ] {} <Debug> HTTP-Session: befe122a-3de2-4450-ba70-b4f6ef0689c6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 586 | 2024.10.09 22:40:32.847189 [ 3 ] {} <Debug> HTTP-Session: befe122a-3de2-4450-ba70-b4f6ef0689c6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 587 | 2024.10.09 22:40:32.847241 [ 3 ] {} <Trace> HTTP-Session: befe122a-3de2-4450-ba70-b4f6ef0689c6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 588 | 2024.10.09 22:40:32.847777 [ 3 ] {8476e880-0c4f-44f0-80a1-868adea1fe68} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 589 | 2024.10.09 22:40:32.847881 [ 3 ] {8476e880-0c4f-44f0-80a1-868adea1fe68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 590 | 2024.10.09 22:40:32.851165 [ 3 ] {8476e880-0c4f-44f0-80a1-868adea1fe68} <Debug> oximeter.measurements_histogramf64 (471acf2c-4ecf-4bd0-8a8d-cda90357554e): Loading data parts | ||
| 591 | 2024.10.09 22:40:32.851495 [ 3 ] {8476e880-0c4f-44f0-80a1-868adea1fe68} <Debug> oximeter.measurements_histogramf64 (471acf2c-4ecf-4bd0-8a8d-cda90357554e): There are no data parts | ||
| 592 | 2024.10.09 22:40:32.853501 [ 3 ] {8476e880-0c4f-44f0-80a1-868adea1fe68} <Debug> DynamicQueryHandler: Done processing query | ||
| 593 | 2024.10.09 22:40:32.853531 [ 3 ] {} <Debug> HTTP-Session: befe122a-3de2-4450-ba70-b4f6ef0689c6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 594 | 2024.10.09 22:40:32.854322 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 595 | 2024.10.09 22:40:32.854436 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 596 | 2024.10.09 22:40:32.854472 [ 3 ] {} <Debug> HTTP-Session: 9c28f2ef-2dfa-4184-a79c-a033c2b1387f Authenticating user 'default' from [::1]:47948 | ||
| 597 | 2024.10.09 22:40:32.854496 [ 3 ] {} <Debug> HTTP-Session: 9c28f2ef-2dfa-4184-a79c-a033c2b1387f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 598 | 2024.10.09 22:40:32.854527 [ 3 ] {} <Debug> HTTP-Session: 9c28f2ef-2dfa-4184-a79c-a033c2b1387f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 599 | 2024.10.09 22:40:32.854574 [ 3 ] {} <Trace> HTTP-Session: 9c28f2ef-2dfa-4184-a79c-a033c2b1387f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 600 | 2024.10.09 22:40:32.854887 [ 3 ] {74d9644d-6f94-4503-bf4e-8f186775169d} <Debug> executeQuery: (from [::1]:47948) /* The field tables store named dimensions of each timeseries. | ||
| 601 | * | ||
| 602 | * As with the measurement tables, there is one field table for each field data | ||
| 603 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 604 | * this behavior **must not** be relied upon for query correctness. | ||
| 605 | * | ||
| 606 | * The index for the fields differs from the measurements, however. Rows are | ||
| 607 | * sorted by timeseries name, then field name, field value, and finally | ||
| 608 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 609 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 610 | * usually then used to look up measurements. | ||
| 611 | * | ||
| 612 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 613 | * timeseries name and then key, since it would improve lookups where one | ||
| 614 | * already has the key. Realistically though, these tables are quite small and | ||
| 615 | * so performance benefits will be low in absolute terms. | ||
| 616 | * | ||
| 617 | * TTL: We use a materialized column to expire old field table records. This | ||
| 618 | * column is generated automatically by the database whenever a new row is | ||
| 619 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 620 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 621 | * record will remain during a deduplication, which will have the last | ||
| 622 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 623 | * measurement tables. | ||
| 624 | */ | ||
| 625 | 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) | ||
| 626 | 2024.10.09 22:40:32.854972 [ 3 ] {74d9644d-6f94-4503-bf4e-8f186775169d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 627 | 2024.10.09 22:40:32.857557 [ 3 ] {74d9644d-6f94-4503-bf4e-8f186775169d} <Debug> oximeter.fields_bool (467f790e-597e-421c-a2e1-07bdf96bbce0): Loading data parts | ||
| 628 | 2024.10.09 22:40:32.857938 [ 3 ] {74d9644d-6f94-4503-bf4e-8f186775169d} <Debug> oximeter.fields_bool (467f790e-597e-421c-a2e1-07bdf96bbce0): There are no data parts | ||
| 629 | 2024.10.09 22:40:32.860129 [ 3 ] {74d9644d-6f94-4503-bf4e-8f186775169d} <Debug> DynamicQueryHandler: Done processing query | ||
| 630 | 2024.10.09 22:40:32.860158 [ 3 ] {} <Debug> HTTP-Session: 9c28f2ef-2dfa-4184-a79c-a033c2b1387f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 631 | 2024.10.09 22:40:32.860833 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 632 | 2024.10.09 22:40:32.860922 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 633 | 2024.10.09 22:40:32.860944 [ 3 ] {} <Debug> HTTP-Session: 1e3d2195-ee9d-4f12-b6dd-a50b9885e987 Authenticating user 'default' from [::1]:47948 | ||
| 634 | 2024.10.09 22:40:32.861008 [ 3 ] {} <Debug> HTTP-Session: 1e3d2195-ee9d-4f12-b6dd-a50b9885e987 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 635 | 2024.10.09 22:40:32.861067 [ 3 ] {} <Debug> HTTP-Session: 1e3d2195-ee9d-4f12-b6dd-a50b9885e987 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 636 | 2024.10.09 22:40:32.861119 [ 3 ] {} <Trace> HTTP-Session: 1e3d2195-ee9d-4f12-b6dd-a50b9885e987 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 637 | 2024.10.09 22:40:32.861503 [ 3 ] {0869ed1a-89ec-43ce-9b78-f413735979b3} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 638 | 2024.10.09 22:40:32.861569 [ 3 ] {0869ed1a-89ec-43ce-9b78-f413735979b3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 639 | 2024.10.09 22:40:32.864325 [ 3 ] {0869ed1a-89ec-43ce-9b78-f413735979b3} <Debug> oximeter.fields_i8 (a5629abb-bc80-44a8-a63f-bc7ea46a4715): Loading data parts | ||
| 640 | 2024.10.09 22:40:32.864599 [ 3 ] {0869ed1a-89ec-43ce-9b78-f413735979b3} <Debug> oximeter.fields_i8 (a5629abb-bc80-44a8-a63f-bc7ea46a4715): There are no data parts | ||
| 641 | 2024.10.09 22:40:32.866492 [ 3 ] {0869ed1a-89ec-43ce-9b78-f413735979b3} <Debug> DynamicQueryHandler: Done processing query | ||
| 642 | 2024.10.09 22:40:32.866530 [ 3 ] {} <Debug> HTTP-Session: 1e3d2195-ee9d-4f12-b6dd-a50b9885e987 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 643 | 2024.10.09 22:40:32.868107 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 644 | 2024.10.09 22:40:32.868176 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 645 | 2024.10.09 22:40:32.868211 [ 3 ] {} <Debug> HTTP-Session: f173059b-162e-4089-87f5-f06a22b37a14 Authenticating user 'default' from [::1]:47948 | ||
| 646 | 2024.10.09 22:40:32.868233 [ 3 ] {} <Debug> HTTP-Session: f173059b-162e-4089-87f5-f06a22b37a14 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 647 | 2024.10.09 22:40:32.868247 [ 3 ] {} <Debug> HTTP-Session: f173059b-162e-4089-87f5-f06a22b37a14 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 648 | 2024.10.09 22:40:32.868485 [ 3 ] {} <Trace> HTTP-Session: f173059b-162e-4089-87f5-f06a22b37a14 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 649 | 2024.10.09 22:40:32.868814 [ 3 ] {0a059103-4f11-4c38-a7da-04d6a71be26c} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 650 | 2024.10.09 22:40:32.868892 [ 3 ] {0a059103-4f11-4c38-a7da-04d6a71be26c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 651 | 2024.10.09 22:40:32.871827 [ 3 ] {0a059103-4f11-4c38-a7da-04d6a71be26c} <Debug> oximeter.fields_u8 (559b7edc-726c-45eb-9567-e1b322b08aed): Loading data parts | ||
| 652 | 2024.10.09 22:40:32.872169 [ 3 ] {0a059103-4f11-4c38-a7da-04d6a71be26c} <Debug> oximeter.fields_u8 (559b7edc-726c-45eb-9567-e1b322b08aed): There are no data parts | ||
| 653 | 2024.10.09 22:40:32.874050 [ 3 ] {0a059103-4f11-4c38-a7da-04d6a71be26c} <Debug> DynamicQueryHandler: Done processing query | ||
| 654 | 2024.10.09 22:40:32.874081 [ 3 ] {} <Debug> HTTP-Session: f173059b-162e-4089-87f5-f06a22b37a14 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 655 | 2024.10.09 22:40:32.874816 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 656 | 2024.10.09 22:40:32.874920 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 657 | 2024.10.09 22:40:32.875035 [ 3 ] {} <Debug> HTTP-Session: 0f180714-9899-48a1-90d0-b6a811115354 Authenticating user 'default' from [::1]:47948 | ||
| 658 | 2024.10.09 22:40:32.875070 [ 3 ] {} <Debug> HTTP-Session: 0f180714-9899-48a1-90d0-b6a811115354 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 659 | 2024.10.09 22:40:32.875107 [ 3 ] {} <Debug> HTTP-Session: 0f180714-9899-48a1-90d0-b6a811115354 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 660 | 2024.10.09 22:40:32.875154 [ 3 ] {} <Trace> HTTP-Session: 0f180714-9899-48a1-90d0-b6a811115354 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 661 | 2024.10.09 22:40:32.875558 [ 3 ] {d8c1e016-7b24-432e-bfc5-4c85517b7599} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 662 | 2024.10.09 22:40:32.875641 [ 3 ] {d8c1e016-7b24-432e-bfc5-4c85517b7599} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 663 | 2024.10.09 22:40:32.878666 [ 3 ] {d8c1e016-7b24-432e-bfc5-4c85517b7599} <Debug> oximeter.fields_i16 (51737054-45af-49aa-ab54-352b790b1318): Loading data parts | ||
| 664 | 2024.10.09 22:40:32.878992 [ 3 ] {d8c1e016-7b24-432e-bfc5-4c85517b7599} <Debug> oximeter.fields_i16 (51737054-45af-49aa-ab54-352b790b1318): There are no data parts | ||
| 665 | 2024.10.09 22:40:32.881059 [ 3 ] {d8c1e016-7b24-432e-bfc5-4c85517b7599} <Debug> DynamicQueryHandler: Done processing query | ||
| 666 | 2024.10.09 22:40:32.881114 [ 3 ] {} <Debug> HTTP-Session: 0f180714-9899-48a1-90d0-b6a811115354 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 667 | 2024.10.09 22:40:32.882245 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 668 | 2024.10.09 22:40:32.882375 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 669 | 2024.10.09 22:40:32.882431 [ 3 ] {} <Debug> HTTP-Session: 0206c967-6a86-457d-a45f-0fcfe7af5e1f Authenticating user 'default' from [::1]:47948 | ||
| 670 | 2024.10.09 22:40:32.882467 [ 3 ] {} <Debug> HTTP-Session: 0206c967-6a86-457d-a45f-0fcfe7af5e1f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 671 | 2024.10.09 22:40:32.882484 [ 3 ] {} <Debug> HTTP-Session: 0206c967-6a86-457d-a45f-0fcfe7af5e1f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 672 | 2024.10.09 22:40:32.882549 [ 3 ] {} <Trace> HTTP-Session: 0206c967-6a86-457d-a45f-0fcfe7af5e1f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 673 | 2024.10.09 22:40:32.882937 [ 3 ] {faf906dc-983b-4ec0-942d-bb9c47fc6447} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 674 | 2024.10.09 22:40:32.883025 [ 3 ] {faf906dc-983b-4ec0-942d-bb9c47fc6447} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 675 | 2024.10.09 22:40:32.894051 [ 3 ] {faf906dc-983b-4ec0-942d-bb9c47fc6447} <Debug> oximeter.fields_u16 (ce4e4aad-a896-4fbd-9be9-b84369f9327d): Loading data parts | ||
| 676 | 2024.10.09 22:40:32.894400 [ 3 ] {faf906dc-983b-4ec0-942d-bb9c47fc6447} <Debug> oximeter.fields_u16 (ce4e4aad-a896-4fbd-9be9-b84369f9327d): There are no data parts | ||
| 677 | 2024.10.09 22:40:32.896602 [ 3 ] {faf906dc-983b-4ec0-942d-bb9c47fc6447} <Debug> DynamicQueryHandler: Done processing query | ||
| 678 | 2024.10.09 22:40:32.896633 [ 3 ] {} <Debug> HTTP-Session: 0206c967-6a86-457d-a45f-0fcfe7af5e1f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 679 | 2024.10.09 22:40:32.897685 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 680 | 2024.10.09 22:40:32.897786 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 681 | 2024.10.09 22:40:32.897810 [ 3 ] {} <Debug> HTTP-Session: 248e54aa-b0e8-46db-bc02-417b8f2123b4 Authenticating user 'default' from [::1]:47948 | ||
| 682 | 2024.10.09 22:40:32.897834 [ 3 ] {} <Debug> HTTP-Session: 248e54aa-b0e8-46db-bc02-417b8f2123b4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 683 | 2024.10.09 22:40:32.897857 [ 3 ] {} <Debug> HTTP-Session: 248e54aa-b0e8-46db-bc02-417b8f2123b4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 684 | 2024.10.09 22:40:32.897905 [ 3 ] {} <Trace> HTTP-Session: 248e54aa-b0e8-46db-bc02-417b8f2123b4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 685 | 2024.10.09 22:40:32.898250 [ 3 ] {efa54821-eb6a-461a-99cb-864893ecc13b} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 686 | 2024.10.09 22:40:32.898335 [ 3 ] {efa54821-eb6a-461a-99cb-864893ecc13b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 687 | 2024.10.09 22:40:32.901739 [ 3 ] {efa54821-eb6a-461a-99cb-864893ecc13b} <Debug> oximeter.fields_i32 (79b8514e-990e-4542-94dc-eb6f991b031d): Loading data parts | ||
| 688 | 2024.10.09 22:40:32.902286 [ 3 ] {efa54821-eb6a-461a-99cb-864893ecc13b} <Debug> oximeter.fields_i32 (79b8514e-990e-4542-94dc-eb6f991b031d): There are no data parts | ||
| 689 | 2024.10.09 22:40:32.904338 [ 3 ] {efa54821-eb6a-461a-99cb-864893ecc13b} <Debug> DynamicQueryHandler: Done processing query | ||
| 690 | 2024.10.09 22:40:32.904381 [ 3 ] {} <Debug> HTTP-Session: 248e54aa-b0e8-46db-bc02-417b8f2123b4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 691 | 2024.10.09 22:40:32.905114 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 692 | 2024.10.09 22:40:32.905184 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 693 | 2024.10.09 22:40:32.905218 [ 3 ] {} <Debug> HTTP-Session: 67879746-e795-480f-9b74-e550e42c4497 Authenticating user 'default' from [::1]:47948 | ||
| 694 | 2024.10.09 22:40:32.905241 [ 3 ] {} <Debug> HTTP-Session: 67879746-e795-480f-9b74-e550e42c4497 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 695 | 2024.10.09 22:40:32.905254 [ 3 ] {} <Debug> HTTP-Session: 67879746-e795-480f-9b74-e550e42c4497 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 696 | 2024.10.09 22:40:32.905307 [ 3 ] {} <Trace> HTTP-Session: 67879746-e795-480f-9b74-e550e42c4497 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 697 | 2024.10.09 22:40:32.905583 [ 3 ] {20aeade4-e70a-4355-81b4-22868ca08231} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 698 | 2024.10.09 22:40:32.905650 [ 3 ] {20aeade4-e70a-4355-81b4-22868ca08231} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 699 | 2024.10.09 22:40:32.908347 [ 3 ] {20aeade4-e70a-4355-81b4-22868ca08231} <Debug> oximeter.fields_u32 (6ee3e901-6516-437a-a47a-469fa6efd050): Loading data parts | ||
| 700 | 2024.10.09 22:40:32.908686 [ 3 ] {20aeade4-e70a-4355-81b4-22868ca08231} <Debug> oximeter.fields_u32 (6ee3e901-6516-437a-a47a-469fa6efd050): There are no data parts | ||
| 701 | 2024.10.09 22:40:32.910287 [ 3 ] {20aeade4-e70a-4355-81b4-22868ca08231} <Debug> DynamicQueryHandler: Done processing query | ||
| 702 | 2024.10.09 22:40:32.910351 [ 3 ] {} <Debug> HTTP-Session: 67879746-e795-480f-9b74-e550e42c4497 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 703 | 2024.10.09 22:40:32.911120 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 704 | 2024.10.09 22:40:32.911202 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 705 | 2024.10.09 22:40:32.911224 [ 3 ] {} <Debug> HTTP-Session: 29c0a3de-0f8b-4053-9c8b-63f0935d1758 Authenticating user 'default' from [::1]:47948 | ||
| 706 | 2024.10.09 22:40:32.911295 [ 3 ] {} <Debug> HTTP-Session: 29c0a3de-0f8b-4053-9c8b-63f0935d1758 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 707 | 2024.10.09 22:40:32.911334 [ 3 ] {} <Debug> HTTP-Session: 29c0a3de-0f8b-4053-9c8b-63f0935d1758 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 708 | 2024.10.09 22:40:32.911382 [ 3 ] {} <Trace> HTTP-Session: 29c0a3de-0f8b-4053-9c8b-63f0935d1758 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 709 | 2024.10.09 22:40:32.912238 [ 3 ] {fa00dd1d-4b60-4c28-bcb2-262779d98637} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 710 | 2024.10.09 22:40:32.912324 [ 3 ] {fa00dd1d-4b60-4c28-bcb2-262779d98637} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 711 | 2024.10.09 22:40:32.915654 [ 3 ] {fa00dd1d-4b60-4c28-bcb2-262779d98637} <Debug> oximeter.fields_i64 (5b4182c4-e6b5-4c19-a1fd-d9d59ba7d59b): Loading data parts | ||
| 712 | 2024.10.09 22:40:32.916222 [ 3 ] {fa00dd1d-4b60-4c28-bcb2-262779d98637} <Debug> oximeter.fields_i64 (5b4182c4-e6b5-4c19-a1fd-d9d59ba7d59b): There are no data parts | ||
| 713 | 2024.10.09 22:40:32.917960 [ 3 ] {fa00dd1d-4b60-4c28-bcb2-262779d98637} <Debug> DynamicQueryHandler: Done processing query | ||
| 714 | 2024.10.09 22:40:32.917990 [ 3 ] {} <Debug> HTTP-Session: 29c0a3de-0f8b-4053-9c8b-63f0935d1758 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 715 | 2024.10.09 22:40:32.920605 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 716 | 2024.10.09 22:40:32.920682 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 717 | 2024.10.09 22:40:32.920711 [ 3 ] {} <Debug> HTTP-Session: c56a170f-b192-46bf-93a0-fbb1d55eaa09 Authenticating user 'default' from [::1]:47948 | ||
| 718 | 2024.10.09 22:40:32.920735 [ 3 ] {} <Debug> HTTP-Session: c56a170f-b192-46bf-93a0-fbb1d55eaa09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 719 | 2024.10.09 22:40:32.920750 [ 3 ] {} <Debug> HTTP-Session: c56a170f-b192-46bf-93a0-fbb1d55eaa09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 720 | 2024.10.09 22:40:32.920798 [ 3 ] {} <Trace> HTTP-Session: c56a170f-b192-46bf-93a0-fbb1d55eaa09 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 721 | 2024.10.09 22:40:32.921349 [ 3 ] {00f2c5dc-f9e5-4fa1-bf13-6a52235d3887} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 722 | 2024.10.09 22:40:32.921416 [ 3 ] {00f2c5dc-f9e5-4fa1-bf13-6a52235d3887} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 723 | 2024.10.09 22:40:32.924800 [ 3 ] {00f2c5dc-f9e5-4fa1-bf13-6a52235d3887} <Debug> oximeter.fields_u64 (c1a7681e-b37b-4093-8696-3f8a914fb3d4): Loading data parts | ||
| 724 | 2024.10.09 22:40:32.925094 [ 3 ] {00f2c5dc-f9e5-4fa1-bf13-6a52235d3887} <Debug> oximeter.fields_u64 (c1a7681e-b37b-4093-8696-3f8a914fb3d4): There are no data parts | ||
| 725 | 2024.10.09 22:40:32.930694 [ 3 ] {00f2c5dc-f9e5-4fa1-bf13-6a52235d3887} <Debug> DynamicQueryHandler: Done processing query | ||
| 726 | 2024.10.09 22:40:32.930726 [ 3 ] {} <Debug> HTTP-Session: c56a170f-b192-46bf-93a0-fbb1d55eaa09 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 727 | 2024.10.09 22:40:32.935159 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 728 | 2024.10.09 22:40:32.935242 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 729 | 2024.10.09 22:40:32.935264 [ 3 ] {} <Debug> HTTP-Session: d3388181-bb77-4ac2-a59b-7ad3a1b7bb06 Authenticating user 'default' from [::1]:47948 | ||
| 730 | 2024.10.09 22:40:32.935287 [ 3 ] {} <Debug> HTTP-Session: d3388181-bb77-4ac2-a59b-7ad3a1b7bb06 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 731 | 2024.10.09 22:40:32.935299 [ 3 ] {} <Debug> HTTP-Session: d3388181-bb77-4ac2-a59b-7ad3a1b7bb06 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 732 | 2024.10.09 22:40:32.935346 [ 3 ] {} <Trace> HTTP-Session: d3388181-bb77-4ac2-a59b-7ad3a1b7bb06 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 733 | 2024.10.09 22:40:32.935722 [ 3 ] {83f2156d-ff50-49fd-88ca-65a58f0a4581} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 734 | 2024.10.09 22:40:32.935789 [ 3 ] {83f2156d-ff50-49fd-88ca-65a58f0a4581} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 735 | 2024.10.09 22:40:32.938300 [ 3 ] {83f2156d-ff50-49fd-88ca-65a58f0a4581} <Debug> oximeter.fields_ipaddr (b0703155-adbb-4d6d-ad5d-e8e0f63f7f32): Loading data parts | ||
| 736 | 2024.10.09 22:40:32.947377 [ 3 ] {83f2156d-ff50-49fd-88ca-65a58f0a4581} <Debug> oximeter.fields_ipaddr (b0703155-adbb-4d6d-ad5d-e8e0f63f7f32): There are no data parts | ||
| 737 | 2024.10.09 22:40:32.949779 [ 3 ] {83f2156d-ff50-49fd-88ca-65a58f0a4581} <Debug> DynamicQueryHandler: Done processing query | ||
| 738 | 2024.10.09 22:40:32.949814 [ 3 ] {} <Debug> HTTP-Session: d3388181-bb77-4ac2-a59b-7ad3a1b7bb06 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 739 | 2024.10.09 22:40:32.950636 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 740 | 2024.10.09 22:40:32.950712 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 741 | 2024.10.09 22:40:32.950735 [ 3 ] {} <Debug> HTTP-Session: 77847784-c666-4cc2-967c-6b99e94aed09 Authenticating user 'default' from [::1]:47948 | ||
| 742 | 2024.10.09 22:40:32.950758 [ 3 ] {} <Debug> HTTP-Session: 77847784-c666-4cc2-967c-6b99e94aed09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 743 | 2024.10.09 22:40:32.950772 [ 3 ] {} <Debug> HTTP-Session: 77847784-c666-4cc2-967c-6b99e94aed09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 744 | 2024.10.09 22:40:32.950821 [ 3 ] {} <Trace> HTTP-Session: 77847784-c666-4cc2-967c-6b99e94aed09 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 745 | 2024.10.09 22:40:32.951412 [ 3 ] {8cf8a7af-212a-4245-a97b-6fdab15e2a23} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 746 | 2024.10.09 22:40:32.951482 [ 3 ] {8cf8a7af-212a-4245-a97b-6fdab15e2a23} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 747 | 2024.10.09 22:40:32.954472 [ 3 ] {8cf8a7af-212a-4245-a97b-6fdab15e2a23} <Debug> oximeter.fields_string (9e65568a-2c58-44b6-a71f-37be0b0963dc): Loading data parts | ||
| 748 | 2024.10.09 22:40:32.954868 [ 3 ] {8cf8a7af-212a-4245-a97b-6fdab15e2a23} <Debug> oximeter.fields_string (9e65568a-2c58-44b6-a71f-37be0b0963dc): There are no data parts | ||
| 749 | 2024.10.09 22:40:32.956681 [ 3 ] {8cf8a7af-212a-4245-a97b-6fdab15e2a23} <Debug> DynamicQueryHandler: Done processing query | ||
| 750 | 2024.10.09 22:40:32.956709 [ 3 ] {} <Debug> HTTP-Session: 77847784-c666-4cc2-967c-6b99e94aed09 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 751 | 2024.10.09 22:40:32.957594 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 752 | 2024.10.09 22:40:32.957665 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 753 | 2024.10.09 22:40:32.957693 [ 3 ] {} <Debug> HTTP-Session: 551d0690-fb05-463f-b802-d2a995ef15fd Authenticating user 'default' from [::1]:47948 | ||
| 754 | 2024.10.09 22:40:32.957715 [ 3 ] {} <Debug> HTTP-Session: 551d0690-fb05-463f-b802-d2a995ef15fd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 755 | 2024.10.09 22:40:32.957730 [ 3 ] {} <Debug> HTTP-Session: 551d0690-fb05-463f-b802-d2a995ef15fd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 756 | 2024.10.09 22:40:32.957820 [ 3 ] {} <Trace> HTTP-Session: 551d0690-fb05-463f-b802-d2a995ef15fd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 757 | 2024.10.09 22:40:32.958131 [ 3 ] {e1670721-ed8b-48b2-b1b3-e4ced832cd38} <Debug> executeQuery: (from [::1]:47948) 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) | ||
| 758 | 2024.10.09 22:40:32.958196 [ 3 ] {e1670721-ed8b-48b2-b1b3-e4ced832cd38} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 759 | 2024.10.09 22:40:32.960927 [ 3 ] {e1670721-ed8b-48b2-b1b3-e4ced832cd38} <Debug> oximeter.fields_uuid (60abd4bf-51f8-4d33-9a6e-428545232dce): Loading data parts | ||
| 760 | 2024.10.09 22:40:32.961308 [ 3 ] {e1670721-ed8b-48b2-b1b3-e4ced832cd38} <Debug> oximeter.fields_uuid (60abd4bf-51f8-4d33-9a6e-428545232dce): There are no data parts | ||
| 761 | 2024.10.09 22:40:32.963064 [ 3 ] {e1670721-ed8b-48b2-b1b3-e4ced832cd38} <Debug> DynamicQueryHandler: Done processing query | ||
| 762 | 2024.10.09 22:40:32.963094 [ 3 ] {} <Debug> HTTP-Session: 551d0690-fb05-463f-b802-d2a995ef15fd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 763 | 2024.10.09 22:40:32.964270 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 764 | 2024.10.09 22:40:32.964381 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 765 | 2024.10.09 22:40:32.964407 [ 3 ] {} <Debug> HTTP-Session: 7d66a408-8d89-4d7d-8468-5253cdab5e94 Authenticating user 'default' from [::1]:47948 | ||
| 766 | 2024.10.09 22:40:32.964432 [ 3 ] {} <Debug> HTTP-Session: 7d66a408-8d89-4d7d-8468-5253cdab5e94 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 767 | 2024.10.09 22:40:32.964449 [ 3 ] {} <Debug> HTTP-Session: 7d66a408-8d89-4d7d-8468-5253cdab5e94 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 768 | 2024.10.09 22:40:32.964499 [ 3 ] {} <Trace> HTTP-Session: 7d66a408-8d89-4d7d-8468-5253cdab5e94 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 769 | 2024.10.09 22:40:32.964771 [ 3 ] {d4ec334c-b872-4ecb-8544-d41a41df193b} <Debug> executeQuery: (from [::1]:47948) /* The timeseries schema table stores the extracted schema for the samples | ||
| 770 | * oximeter collects. | ||
| 771 | */ | ||
| 772 | 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) | ||
| 773 | 2024.10.09 22:40:32.964861 [ 3 ] {d4ec334c-b872-4ecb-8544-d41a41df193b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 774 | 2024.10.09 22:40:32.968143 [ 3 ] {d4ec334c-b872-4ecb-8544-d41a41df193b} <Debug> oximeter.timeseries_schema (8caebb25-f516-47bb-820b-592527b6985f): Loading data parts | ||
| 775 | 2024.10.09 22:40:32.968459 [ 3 ] {d4ec334c-b872-4ecb-8544-d41a41df193b} <Debug> oximeter.timeseries_schema (8caebb25-f516-47bb-820b-592527b6985f): There are no data parts | ||
| 776 | 2024.10.09 22:40:32.970541 [ 3 ] {d4ec334c-b872-4ecb-8544-d41a41df193b} <Debug> DynamicQueryHandler: Done processing query | ||
| 777 | 2024.10.09 22:40:32.970569 [ 3 ] {} <Debug> HTTP-Session: 7d66a408-8d89-4d7d-8468-5253cdab5e94 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 778 | 2024.10.09 22:40:32.971498 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:47948, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 779 | 2024.10.09 22:40:32.971570 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 780 | 2024.10.09 22:40:32.971595 [ 3 ] {} <Debug> HTTP-Session: 5349df8a-1595-4843-8ad7-67d57040ca5a Authenticating user 'default' from [::1]:47948 | ||
| 781 | 2024.10.09 22:40:32.971618 [ 3 ] {} <Debug> HTTP-Session: 5349df8a-1595-4843-8ad7-67d57040ca5a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 782 | 2024.10.09 22:40:32.971633 [ 3 ] {} <Debug> HTTP-Session: 5349df8a-1595-4843-8ad7-67d57040ca5a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 783 | 2024.10.09 22:40:32.971681 [ 3 ] {} <Trace> HTTP-Session: 5349df8a-1595-4843-8ad7-67d57040ca5a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 784 | 2024.10.09 22:40:32.972293 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Debug> executeQuery: (from [::1]:47948) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 785 | 2024.10.09 22:40:32.972474 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 786 | 2024.10.09 22:40:32.982634 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Trace> oximeter.version (0df667ad-b2e3-4615-8e6f-3f5d8cb8667e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 787 | 2024.10.09 22:40:32.982754 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.23 GiB. | ||
| 788 | 2024.10.09 22:40:32.983921 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 789 | 2024.10.09 22:40:32.984528 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Trace> oximeter.version (0df667ad-b2e3-4615-8e6f-3f5d8cb8667e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 790 | 2024.10.09 22:40:32.984822 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.012895 sec., 77.54943776657619 rows/sec., 1.21 KiB/sec. | ||
| 791 | 2024.10.09 22:40:32.985069 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Debug> DynamicQueryHandler: Done processing query | ||
| 792 | 2024.10.09 22:40:32.985095 [ 3 ] {ff3538ef-eda4-4221-8a6d-51604c70415a} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 793 | 2024.10.09 22:40:32.985110 [ 3 ] {} <Debug> HTTP-Session: 5349df8a-1595-4843-8ad7-67d57040ca5a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 794 | 2024.10.09 22:40:33.000716 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 182.66 MiB, peak 187.80 MiB, free memory in arenas 0.00 B, will set to 187.12 MiB (RSS), difference: 4.46 MiB | ||
| 795 | 2024.10.09 22:40:34.826212 [ 164 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 796 | 2024.10.09 22:40:34.826265 [ 164 ] {} <Debug> DNSResolver: Updated DNS cache | ||