| 1 | 2024.10.09 22:38:54.845705 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 14677 | ||
| 2 | 2024.10.09 22:38:54.845914 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.10.09 22:38:54.845976 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.10.09 22:38:54.858312 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.10.09 22:38:54.861372 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.10.09 22:38:54.861418 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.10.09 22:38:54.861433 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2024.10.09 22:38:54.862089 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_virtual_provisioning_collection.14669.1-clickhouse-9gNXsB/datastore/tmp/ to store temporary data in it | ||
| 9 | 2024.10.09 22:38:54.862650 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.10.09 22:38:54.863649 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.10.09 22:38:54.864431 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 2024.10.09 22:38:54.864943 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.18 GiB (31.32 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 13 | 2024.10.09 22:38:54.864959 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.66 GiB (31.32 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 14 | 2024.10.09 22:38:54.864977 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.10.09 22:38:54.865070 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.10.09 22:38:54.866052 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.10.09 22:38:54.877397 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.10.09 22:38:54.878544 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2024.10.09 22:38:54.880262 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 20 | 2024.10.09 22:38:54.880315 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.10.09 22:38:54.881229 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.10.09 22:38:54.881858 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.10.09 22:38:54.883818 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.10.09 22:38:54.884409 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 2024.10.09 22:38:54.885377 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 26 | 2024.10.09 22:38:54.885779 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.10.09 22:38:54.887906 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2024.10.09 22:38:54.888298 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 29 | 2024.10.09 22:38:54.889735 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2024.10.09 22:38:54.889771 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_virtual_provisioning_collection.14669.1-clickhouse-9gNXsB/datastore/ | ||
| 31 | 2024.10.09 22:38:54.893215 [ 188 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 32 | 2024.10.09 22:38:54.893280 [ 188 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 33 | 2024.10.09 22:38:54.901076 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 34 | 2024.10.09 22:38:54.901173 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000409841 sec | ||
| 35 | 2024.10.09 22:38:54.901206 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 36 | 2024.10.09 22:38:54.907017 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 37 | 2024.10.09 22:38:54.907360 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 38 | 2024.10.09 22:38:54.907472 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 39 | 2024.10.09 22:38:54.908016 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 40 | 2024.10.09 22:38:54.908158 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 41 | 2024.10.09 22:38:54.908190 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 42 | 2024.10.09 22:38:54.908203 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 43 | 2024.10.09 22:38:54.908235 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 44 | 2024.10.09 22:38:54.908248 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 45 | 2024.10.09 22:38:54.908266 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 46 | 2024.10.09 22:38:54.908298 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 47 | 2024.10.09 22:38:54.908313 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 48 | 2024.10.09 22:38:54.908330 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 49 | 2024.10.09 22:38:54.908343 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 50 | 2024.10.09 22:38:54.908376 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2024.10.09 22:38:54.908392 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 2024.10.09 22:38:54.908405 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 53 | 2024.10.09 22:38:54.908433 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 54 | 2024.10.09 22:38:54.908452 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 55 | 2024.10.09 22:38:54.967485 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.10.09 22:38:54.969629 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.10.09 22:38:54.971992 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.002773338 sec | ||
| 58 | 2024.10.09 22:38:54.972192 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.10.09 22:38:54.972275 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.10.09 22:38:54.972309 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2024.10.09 22:38:54.972728 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_virtual_provisioning_collection.14669.1-clickhouse-9gNXsB/datastore/user_defined/ | ||
| 62 | 2024.10.09 22:38:54.972964 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.10.09 22:38:54.972987 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2024.10.09 22:38:54.973014 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
| 65 | 2024.10.09 22:38:54.973033 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.10.09 22:38:54.973304 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 52603 | ||
| 67 | 2024.10.09 22:38:54.973527 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 62057 | ||
| 68 | 2024.10.09 22:38:54.976839 [ 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:38:55.051324 [ 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:38:55.051371 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 71 | 2024.10.09 22:38:55.127776 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 61106 | ||
| 72 | 2024.10.09 22:38:55.127893 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 46098 | ||
| 73 | 2024.10.09 22:38:55.128044 [ 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:38:55.180900 [ 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:38:55.180949 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 76 | 2024.10.09 22:38:55.288499 [ 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:38:55.288980 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.88 MiB, peak 15.64 MiB, free memory in arenas 0.00 B, will set to 178.65 MiB (RSS), difference: 168.77 MiB | ||
| 78 | 2024.10.09 22:38:55.289442 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.1218e-05 sec. | ||
| 79 | 2024.10.09 22:38:55.290063 [ 1 ] {} <Information> Application: Listening for http://[::1]:52603 | ||
| 80 | 2024.10.09 22:38:55.290138 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:62057 | ||
| 81 | 2024.10.09 22:38:55.290251 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004 | ||
| 82 | 2024.10.09 22:38:55.290351 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:61106 | ||
| 83 | 2024.10.09 22:38:55.290495 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:46098 | ||
| 84 | 2024.10.09 22:38:55.290916 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004 | ||
| 85 | 2024.10.09 22:38:55.290952 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 86 | 2024.10.09 22:39:08.500867 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 87 | 2024.10.09 22:39:08.501088 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 88 | 2024.10.09 22:39:08.501126 [ 3 ] {} <Debug> HTTP-Session: c176c31b-ca24-4149-b2f7-e20a5f40481e Authenticating user 'default' from [::1]:43618 | ||
| 89 | 2024.10.09 22:39:08.501164 [ 3 ] {} <Debug> HTTP-Session: c176c31b-ca24-4149-b2f7-e20a5f40481e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 90 | 2024.10.09 22:39:08.501179 [ 3 ] {} <Debug> HTTP-Session: c176c31b-ca24-4149-b2f7-e20a5f40481e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2024.10.09 22:39:08.501276 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 92 | 2024.10.09 22:39:08.501332 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 93 | 2024.10.09 22:39:08.501352 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 94 | 2024.10.09 22:39:08.501408 [ 3 ] {} <Trace> HTTP-Session: c176c31b-ca24-4149-b2f7-e20a5f40481e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 95 | 2024.10.09 22:39:08.501918 [ 3 ] {c76be2b7-3a7a-423f-a8ba-2f98b5c79eba} <Debug> executeQuery: (from [::1]:43618) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 96 | 2024.10.09 22:39:08.510663 [ 3 ] {c76be2b7-3a7a-423f-a8ba-2f98b5c79eba} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:43618) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 97 | |||
| 98 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 99 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 100 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 101 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 102 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 103 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 104 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 105 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 106 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 107 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 108 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 109 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 110 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 111 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 112 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 113 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 114 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 115 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 116 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 117 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 118 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 119 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 120 | |||
| 121 | 2024.10.09 22:39:08.510930 [ 3 ] {c76be2b7-3a7a-423f-a8ba-2f98b5c79eba} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 122 | |||
| 123 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 124 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 125 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 126 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 127 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 128 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 129 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 130 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 131 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 132 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 133 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 134 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 135 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 136 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 137 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 138 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 139 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 140 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 141 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 142 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 143 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 144 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 145 | (version 23.8.7.1) | ||
| 146 | 2024.10.09 22:39:08.511283 [ 3 ] {} <Debug> HTTP-Session: c176c31b-ca24-4149-b2f7-e20a5f40481e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2024.10.09 22:39:08.524757 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 148 | 2024.10.09 22:39:08.524924 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 149 | 2024.10.09 22:39:08.524952 [ 3 ] {} <Debug> HTTP-Session: b5e0dd1c-cafa-400f-8312-6716ec8414e9 Authenticating user 'default' from [::1]:43618 | ||
| 150 | 2024.10.09 22:39:08.524975 [ 3 ] {} <Debug> HTTP-Session: b5e0dd1c-cafa-400f-8312-6716ec8414e9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 151 | 2024.10.09 22:39:08.524993 [ 3 ] {} <Debug> HTTP-Session: b5e0dd1c-cafa-400f-8312-6716ec8414e9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 152 | 2024.10.09 22:39:08.525048 [ 3 ] {} <Trace> HTTP-Session: b5e0dd1c-cafa-400f-8312-6716ec8414e9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 153 | 2024.10.09 22:39:08.525300 [ 3 ] {0524c7cd-aac9-468f-bad6-544c4129f492} <Debug> executeQuery: (from [::1]:43618) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 154 | 2024.10.09 22:39:08.525705 [ 3 ] {0524c7cd-aac9-468f-bad6-544c4129f492} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:43618) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 155 | |||
| 156 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 157 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 158 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 159 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 160 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 161 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 162 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 163 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 164 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 165 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 166 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 167 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 168 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 169 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 170 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 171 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 172 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 173 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 174 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 175 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 176 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 177 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 178 | |||
| 179 | 2024.10.09 22:39:08.525864 [ 3 ] {0524c7cd-aac9-468f-bad6-544c4129f492} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 180 | |||
| 181 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 182 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 183 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 184 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 185 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 186 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 187 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 188 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 189 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 190 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 191 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 192 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 193 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 194 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 195 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 196 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 197 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 198 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 199 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 200 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 201 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
| 202 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
| 203 | (version 23.8.7.1) | ||
| 204 | 2024.10.09 22:39:08.526059 [ 3 ] {} <Debug> HTTP-Session: b5e0dd1c-cafa-400f-8312-6716ec8414e9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 205 | 2024.10.09 22:39:08.543756 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 206 | 2024.10.09 22:39:08.543933 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 207 | 2024.10.09 22:39:08.543975 [ 3 ] {} <Debug> HTTP-Session: 80d0e97c-a08a-4269-8514-caa6e6b4316c Authenticating user 'default' from [::1]:43618 | ||
| 208 | 2024.10.09 22:39:08.544003 [ 3 ] {} <Debug> HTTP-Session: 80d0e97c-a08a-4269-8514-caa6e6b4316c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 209 | 2024.10.09 22:39:08.544036 [ 3 ] {} <Debug> HTTP-Session: 80d0e97c-a08a-4269-8514-caa6e6b4316c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 210 | 2024.10.09 22:39:08.544107 [ 3 ] {} <Trace> HTTP-Session: 80d0e97c-a08a-4269-8514-caa6e6b4316c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 211 | 2024.10.09 22:39:08.544429 [ 3 ] {14efe44a-8a49-4675-a07d-3b2d93a7f40d} <Debug> executeQuery: (from [::1]:43618) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 212 | 2024.10.09 22:39:08.544747 [ 3 ] {14efe44a-8a49-4675-a07d-3b2d93a7f40d} <Debug> DynamicQueryHandler: Done processing query | ||
| 213 | 2024.10.09 22:39:08.544785 [ 3 ] {} <Debug> HTTP-Session: 80d0e97c-a08a-4269-8514-caa6e6b4316c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 214 | 2024.10.09 22:39:08.550038 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 215 | 2024.10.09 22:39:08.550152 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 216 | 2024.10.09 22:39:08.550181 [ 3 ] {} <Debug> HTTP-Session: 1571dab6-1352-489d-9740-7e9462cb9d4e Authenticating user 'default' from [::1]:43618 | ||
| 217 | 2024.10.09 22:39:08.550212 [ 3 ] {} <Debug> HTTP-Session: 1571dab6-1352-489d-9740-7e9462cb9d4e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 218 | 2024.10.09 22:39:08.550235 [ 3 ] {} <Debug> HTTP-Session: 1571dab6-1352-489d-9740-7e9462cb9d4e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 219 | 2024.10.09 22:39:08.550293 [ 3 ] {} <Trace> HTTP-Session: 1571dab6-1352-489d-9740-7e9462cb9d4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 220 | 2024.10.09 22:39:08.550480 [ 3 ] {2fee71d0-f63b-4c92-b94a-15a31fff6602} <Debug> executeQuery: (from [::1]:43618) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 221 | 2024.10.09 22:39:08.550570 [ 3 ] {2fee71d0-f63b-4c92-b94a-15a31fff6602} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 222 | 2024.10.09 22:39:08.552793 [ 3 ] {2fee71d0-f63b-4c92-b94a-15a31fff6602} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 223 | 2024.10.09 22:39:08.552839 [ 3 ] {2fee71d0-f63b-4c92-b94a-15a31fff6602} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000101686 sec | ||
| 224 | 2024.10.09 22:39:08.552857 [ 3 ] {2fee71d0-f63b-4c92-b94a-15a31fff6602} <Trace> ReferentialDeps: No tables | ||
| 225 | 2024.10.09 22:39:08.552870 [ 3 ] {2fee71d0-f63b-4c92-b94a-15a31fff6602} <Trace> LoadingDeps: No tables | ||
| 226 | 2024.10.09 22:39:08.552907 [ 3 ] {2fee71d0-f63b-4c92-b94a-15a31fff6602} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 227 | 2024.10.09 22:39:08.553145 [ 3 ] {2fee71d0-f63b-4c92-b94a-15a31fff6602} <Debug> DynamicQueryHandler: Done processing query | ||
| 228 | 2024.10.09 22:39:08.553174 [ 3 ] {} <Debug> HTTP-Session: 1571dab6-1352-489d-9740-7e9462cb9d4e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 229 | 2024.10.09 22:39:08.554712 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 230 | 2024.10.09 22:39:08.554794 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 231 | 2024.10.09 22:39:08.554819 [ 3 ] {} <Debug> HTTP-Session: 5f796289-fdeb-474e-b1a0-c95ad2a94be2 Authenticating user 'default' from [::1]:43618 | ||
| 232 | 2024.10.09 22:39:08.554838 [ 3 ] {} <Debug> HTTP-Session: 5f796289-fdeb-474e-b1a0-c95ad2a94be2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 233 | 2024.10.09 22:39:08.554854 [ 3 ] {} <Debug> HTTP-Session: 5f796289-fdeb-474e-b1a0-c95ad2a94be2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 234 | 2024.10.09 22:39:08.554902 [ 3 ] {} <Trace> HTTP-Session: 5f796289-fdeb-474e-b1a0-c95ad2a94be2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 235 | 2024.10.09 22:39:08.555143 [ 3 ] {89a9a071-d3ce-4da3-b84c-4937d4c41b11} <Debug> executeQuery: (from [::1]:43618) /* The version table contains metadata about the `oximeter` database */ | ||
| 236 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 237 | 2024.10.09 22:39:08.555222 [ 3 ] {89a9a071-d3ce-4da3-b84c-4937d4c41b11} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 238 | 2024.10.09 22:39:08.556759 [ 3 ] {89a9a071-d3ce-4da3-b84c-4937d4c41b11} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 239 | 2024.10.09 22:39:08.557976 [ 3 ] {89a9a071-d3ce-4da3-b84c-4937d4c41b11} <Debug> oximeter.version (a526a091-64f0-495f-9adc-1fdca0f8b9a5): Loading data parts | ||
| 240 | 2024.10.09 22:39:08.559635 [ 3 ] {89a9a071-d3ce-4da3-b84c-4937d4c41b11} <Debug> oximeter.version (a526a091-64f0-495f-9adc-1fdca0f8b9a5): There are no data parts | ||
| 241 | 2024.10.09 22:39:08.561592 [ 3 ] {89a9a071-d3ce-4da3-b84c-4937d4c41b11} <Debug> DynamicQueryHandler: Done processing query | ||
| 242 | 2024.10.09 22:39:08.561624 [ 3 ] {} <Debug> HTTP-Session: 5f796289-fdeb-474e-b1a0-c95ad2a94be2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 243 | 2024.10.09 22:39:08.567810 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 244 | 2024.10.09 22:39:08.567895 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 245 | 2024.10.09 22:39:08.567923 [ 3 ] {} <Debug> HTTP-Session: e606573b-d031-437c-9821-b3a3709c5a5e Authenticating user 'default' from [::1]:43618 | ||
| 246 | 2024.10.09 22:39:08.567959 [ 3 ] {} <Debug> HTTP-Session: e606573b-d031-437c-9821-b3a3709c5a5e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 247 | 2024.10.09 22:39:08.567977 [ 3 ] {} <Debug> HTTP-Session: e606573b-d031-437c-9821-b3a3709c5a5e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 248 | 2024.10.09 22:39:08.568032 [ 3 ] {} <Trace> HTTP-Session: e606573b-d031-437c-9821-b3a3709c5a5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 249 | 2024.10.09 22:39:08.568381 [ 3 ] {c399ad19-e5a4-497f-9f11-c97962fe5959} <Debug> executeQuery: (from [::1]:43618) /* The measurement tables contain all individual samples from each timeseries. | ||
| 250 | * | ||
| 251 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 252 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 253 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 254 | * by all samples from the same timeseries. | ||
| 255 | * | ||
| 256 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 257 | * and then uses that to index quickly into the measurements tables. | ||
| 258 | */ | ||
| 259 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 260 | 2024.10.09 22:39:08.568464 [ 3 ] {c399ad19-e5a4-497f-9f11-c97962fe5959} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 261 | 2024.10.09 22:39:08.571156 [ 3 ] {c399ad19-e5a4-497f-9f11-c97962fe5959} <Debug> oximeter.measurements_bool (37f1d57a-d38f-4bf2-be3b-0a5a20881261): Loading data parts | ||
| 262 | 2024.10.09 22:39:08.571471 [ 3 ] {c399ad19-e5a4-497f-9f11-c97962fe5959} <Debug> oximeter.measurements_bool (37f1d57a-d38f-4bf2-be3b-0a5a20881261): There are no data parts | ||
| 263 | 2024.10.09 22:39:08.573284 [ 3 ] {c399ad19-e5a4-497f-9f11-c97962fe5959} <Debug> DynamicQueryHandler: Done processing query | ||
| 264 | 2024.10.09 22:39:08.573312 [ 3 ] {} <Debug> HTTP-Session: e606573b-d031-437c-9821-b3a3709c5a5e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2024.10.09 22:39:08.576538 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 266 | 2024.10.09 22:39:08.576621 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 267 | 2024.10.09 22:39:08.576645 [ 3 ] {} <Debug> HTTP-Session: 1f7c9257-2f00-43b4-9c6b-ae6f74852139 Authenticating user 'default' from [::1]:43618 | ||
| 268 | 2024.10.09 22:39:08.576667 [ 3 ] {} <Debug> HTTP-Session: 1f7c9257-2f00-43b4-9c6b-ae6f74852139 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2024.10.09 22:39:08.576681 [ 3 ] {} <Debug> HTTP-Session: 1f7c9257-2f00-43b4-9c6b-ae6f74852139 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2024.10.09 22:39:08.576735 [ 3 ] {} <Trace> HTTP-Session: 1f7c9257-2f00-43b4-9c6b-ae6f74852139 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 271 | 2024.10.09 22:39:08.577035 [ 3 ] {8ad7e4aa-3e27-442b-bd7b-24e44a29feb0} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 272 | 2024.10.09 22:39:08.577109 [ 3 ] {8ad7e4aa-3e27-442b-bd7b-24e44a29feb0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 273 | 2024.10.09 22:39:08.579431 [ 3 ] {8ad7e4aa-3e27-442b-bd7b-24e44a29feb0} <Debug> oximeter.measurements_i8 (5bf860c4-de75-4859-a7f7-d8fc5ec4fd82): Loading data parts | ||
| 274 | 2024.10.09 22:39:08.579791 [ 3 ] {8ad7e4aa-3e27-442b-bd7b-24e44a29feb0} <Debug> oximeter.measurements_i8 (5bf860c4-de75-4859-a7f7-d8fc5ec4fd82): There are no data parts | ||
| 275 | 2024.10.09 22:39:08.581578 [ 3 ] {8ad7e4aa-3e27-442b-bd7b-24e44a29feb0} <Debug> DynamicQueryHandler: Done processing query | ||
| 276 | 2024.10.09 22:39:08.581609 [ 3 ] {} <Debug> HTTP-Session: 1f7c9257-2f00-43b4-9c6b-ae6f74852139 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2024.10.09 22:39:08.588308 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 278 | 2024.10.09 22:39:08.588416 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 279 | 2024.10.09 22:39:08.588444 [ 3 ] {} <Debug> HTTP-Session: 56591999-e1f2-4a6d-8bde-9e1463c0e6d3 Authenticating user 'default' from [::1]:43618 | ||
| 280 | 2024.10.09 22:39:08.588485 [ 3 ] {} <Debug> HTTP-Session: 56591999-e1f2-4a6d-8bde-9e1463c0e6d3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 281 | 2024.10.09 22:39:08.588500 [ 3 ] {} <Debug> HTTP-Session: 56591999-e1f2-4a6d-8bde-9e1463c0e6d3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2024.10.09 22:39:08.588554 [ 3 ] {} <Trace> HTTP-Session: 56591999-e1f2-4a6d-8bde-9e1463c0e6d3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 283 | 2024.10.09 22:39:08.588905 [ 3 ] {4012946c-d71c-4ca2-8f6e-b4b61c9c2ad3} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 284 | 2024.10.09 22:39:08.588979 [ 3 ] {4012946c-d71c-4ca2-8f6e-b4b61c9c2ad3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 285 | 2024.10.09 22:39:08.591510 [ 3 ] {4012946c-d71c-4ca2-8f6e-b4b61c9c2ad3} <Debug> oximeter.measurements_u8 (8e38f636-52c3-4f2f-bc1d-7bccc4ad83ed): Loading data parts | ||
| 286 | 2024.10.09 22:39:08.591841 [ 3 ] {4012946c-d71c-4ca2-8f6e-b4b61c9c2ad3} <Debug> oximeter.measurements_u8 (8e38f636-52c3-4f2f-bc1d-7bccc4ad83ed): There are no data parts | ||
| 287 | 2024.10.09 22:39:08.593617 [ 3 ] {4012946c-d71c-4ca2-8f6e-b4b61c9c2ad3} <Debug> DynamicQueryHandler: Done processing query | ||
| 288 | 2024.10.09 22:39:08.593655 [ 3 ] {} <Debug> HTTP-Session: 56591999-e1f2-4a6d-8bde-9e1463c0e6d3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 289 | 2024.10.09 22:39:08.595175 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 290 | 2024.10.09 22:39:08.595247 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 291 | 2024.10.09 22:39:08.595282 [ 3 ] {} <Debug> HTTP-Session: a830fe4f-38af-41e8-8ba5-c3bea2deb2bb Authenticating user 'default' from [::1]:43618 | ||
| 292 | 2024.10.09 22:39:08.595306 [ 3 ] {} <Debug> HTTP-Session: a830fe4f-38af-41e8-8ba5-c3bea2deb2bb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2024.10.09 22:39:08.595322 [ 3 ] {} <Debug> HTTP-Session: a830fe4f-38af-41e8-8ba5-c3bea2deb2bb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2024.10.09 22:39:08.595380 [ 3 ] {} <Trace> HTTP-Session: a830fe4f-38af-41e8-8ba5-c3bea2deb2bb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 295 | 2024.10.09 22:39:08.595691 [ 3 ] {834bc340-693e-4686-819a-acecc4d8c6d5} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 296 | 2024.10.09 22:39:08.595762 [ 3 ] {834bc340-693e-4686-819a-acecc4d8c6d5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 297 | 2024.10.09 22:39:08.598525 [ 3 ] {834bc340-693e-4686-819a-acecc4d8c6d5} <Debug> oximeter.measurements_i16 (5a95fd30-afff-4d37-8ca7-10da866498f9): Loading data parts | ||
| 298 | 2024.10.09 22:39:08.598855 [ 3 ] {834bc340-693e-4686-819a-acecc4d8c6d5} <Debug> oximeter.measurements_i16 (5a95fd30-afff-4d37-8ca7-10da866498f9): There are no data parts | ||
| 299 | 2024.10.09 22:39:08.600622 [ 3 ] {834bc340-693e-4686-819a-acecc4d8c6d5} <Debug> DynamicQueryHandler: Done processing query | ||
| 300 | 2024.10.09 22:39:08.600653 [ 3 ] {} <Debug> HTTP-Session: a830fe4f-38af-41e8-8ba5-c3bea2deb2bb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 301 | 2024.10.09 22:39:08.601793 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 302 | 2024.10.09 22:39:08.601886 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 303 | 2024.10.09 22:39:08.601912 [ 3 ] {} <Debug> HTTP-Session: f8ff49da-6025-4969-b05a-dc95f2d088a1 Authenticating user 'default' from [::1]:43618 | ||
| 304 | 2024.10.09 22:39:08.601936 [ 3 ] {} <Debug> HTTP-Session: f8ff49da-6025-4969-b05a-dc95f2d088a1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 305 | 2024.10.09 22:39:08.601960 [ 3 ] {} <Debug> HTTP-Session: f8ff49da-6025-4969-b05a-dc95f2d088a1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 306 | 2024.10.09 22:39:08.602011 [ 3 ] {} <Trace> HTTP-Session: f8ff49da-6025-4969-b05a-dc95f2d088a1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 307 | 2024.10.09 22:39:08.602329 [ 3 ] {6c66a969-6eff-47cf-a604-566ed9cdbc53} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 308 | 2024.10.09 22:39:08.602406 [ 3 ] {6c66a969-6eff-47cf-a604-566ed9cdbc53} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 309 | 2024.10.09 22:39:08.604695 [ 3 ] {6c66a969-6eff-47cf-a604-566ed9cdbc53} <Debug> oximeter.measurements_u16 (b65c9554-ff8b-465a-ad7a-3f2ca58d013b): Loading data parts | ||
| 310 | 2024.10.09 22:39:08.604987 [ 3 ] {6c66a969-6eff-47cf-a604-566ed9cdbc53} <Debug> oximeter.measurements_u16 (b65c9554-ff8b-465a-ad7a-3f2ca58d013b): There are no data parts | ||
| 311 | 2024.10.09 22:39:08.606805 [ 3 ] {6c66a969-6eff-47cf-a604-566ed9cdbc53} <Debug> DynamicQueryHandler: Done processing query | ||
| 312 | 2024.10.09 22:39:08.606833 [ 3 ] {} <Debug> HTTP-Session: f8ff49da-6025-4969-b05a-dc95f2d088a1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 313 | 2024.10.09 22:39:08.609699 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 314 | 2024.10.09 22:39:08.609793 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 315 | 2024.10.09 22:39:08.609833 [ 3 ] {} <Debug> HTTP-Session: d5d52324-b56e-4301-828f-09ef3488466c Authenticating user 'default' from [::1]:43618 | ||
| 316 | 2024.10.09 22:39:08.609859 [ 3 ] {} <Debug> HTTP-Session: d5d52324-b56e-4301-828f-09ef3488466c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 317 | 2024.10.09 22:39:08.609873 [ 3 ] {} <Debug> HTTP-Session: d5d52324-b56e-4301-828f-09ef3488466c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 318 | 2024.10.09 22:39:08.609930 [ 3 ] {} <Trace> HTTP-Session: d5d52324-b56e-4301-828f-09ef3488466c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 319 | 2024.10.09 22:39:08.610301 [ 3 ] {06b74108-7ebc-4b9b-87c1-15eeeca81e64} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 320 | 2024.10.09 22:39:08.610389 [ 3 ] {06b74108-7ebc-4b9b-87c1-15eeeca81e64} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 321 | 2024.10.09 22:39:08.613584 [ 3 ] {06b74108-7ebc-4b9b-87c1-15eeeca81e64} <Debug> oximeter.measurements_i32 (3b13431b-1828-4369-84b4-290e7646cd08): Loading data parts | ||
| 322 | 2024.10.09 22:39:08.613977 [ 3 ] {06b74108-7ebc-4b9b-87c1-15eeeca81e64} <Debug> oximeter.measurements_i32 (3b13431b-1828-4369-84b4-290e7646cd08): There are no data parts | ||
| 323 | 2024.10.09 22:39:08.615971 [ 3 ] {06b74108-7ebc-4b9b-87c1-15eeeca81e64} <Debug> DynamicQueryHandler: Done processing query | ||
| 324 | 2024.10.09 22:39:08.616011 [ 3 ] {} <Debug> HTTP-Session: d5d52324-b56e-4301-828f-09ef3488466c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 325 | 2024.10.09 22:39:08.630018 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 326 | 2024.10.09 22:39:08.630173 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 327 | 2024.10.09 22:39:08.630207 [ 3 ] {} <Debug> HTTP-Session: 355e7559-a5c9-49a7-ad2e-758b770c4c38 Authenticating user 'default' from [::1]:43618 | ||
| 328 | 2024.10.09 22:39:08.630237 [ 3 ] {} <Debug> HTTP-Session: 355e7559-a5c9-49a7-ad2e-758b770c4c38 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 329 | 2024.10.09 22:39:08.630263 [ 3 ] {} <Debug> HTTP-Session: 355e7559-a5c9-49a7-ad2e-758b770c4c38 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 330 | 2024.10.09 22:39:08.630328 [ 3 ] {} <Trace> HTTP-Session: 355e7559-a5c9-49a7-ad2e-758b770c4c38 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 331 | 2024.10.09 22:39:08.630759 [ 3 ] {4a382619-7f77-41e8-b219-63a517a44a32} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 332 | 2024.10.09 22:39:08.630850 [ 3 ] {4a382619-7f77-41e8-b219-63a517a44a32} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 333 | 2024.10.09 22:39:08.633647 [ 3 ] {4a382619-7f77-41e8-b219-63a517a44a32} <Debug> oximeter.measurements_u32 (494ec5e7-9cfd-46ef-b652-42654620b238): Loading data parts | ||
| 334 | 2024.10.09 22:39:08.633997 [ 3 ] {4a382619-7f77-41e8-b219-63a517a44a32} <Debug> oximeter.measurements_u32 (494ec5e7-9cfd-46ef-b652-42654620b238): There are no data parts | ||
| 335 | 2024.10.09 22:39:08.636001 [ 3 ] {4a382619-7f77-41e8-b219-63a517a44a32} <Debug> DynamicQueryHandler: Done processing query | ||
| 336 | 2024.10.09 22:39:08.636037 [ 3 ] {} <Debug> HTTP-Session: 355e7559-a5c9-49a7-ad2e-758b770c4c38 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 337 | 2024.10.09 22:39:08.638509 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 338 | 2024.10.09 22:39:08.638601 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 339 | 2024.10.09 22:39:08.638633 [ 3 ] {} <Debug> HTTP-Session: 4ddca368-a3d5-4d80-8857-8a0e393ec0dd Authenticating user 'default' from [::1]:43618 | ||
| 340 | 2024.10.09 22:39:08.638675 [ 3 ] {} <Debug> HTTP-Session: 4ddca368-a3d5-4d80-8857-8a0e393ec0dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 341 | 2024.10.09 22:39:08.638695 [ 3 ] {} <Debug> HTTP-Session: 4ddca368-a3d5-4d80-8857-8a0e393ec0dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 342 | 2024.10.09 22:39:08.638753 [ 3 ] {} <Trace> HTTP-Session: 4ddca368-a3d5-4d80-8857-8a0e393ec0dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 343 | 2024.10.09 22:39:08.639672 [ 3 ] {6983ec2d-1bdf-47c5-aad2-ea6fb7357d13} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 344 | 2024.10.09 22:39:08.639757 [ 3 ] {6983ec2d-1bdf-47c5-aad2-ea6fb7357d13} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 345 | 2024.10.09 22:39:08.642076 [ 3 ] {6983ec2d-1bdf-47c5-aad2-ea6fb7357d13} <Debug> oximeter.measurements_i64 (9b0af355-3a97-4b55-92db-1991fab1de09): Loading data parts | ||
| 346 | 2024.10.09 22:39:08.642438 [ 3 ] {6983ec2d-1bdf-47c5-aad2-ea6fb7357d13} <Debug> oximeter.measurements_i64 (9b0af355-3a97-4b55-92db-1991fab1de09): There are no data parts | ||
| 347 | 2024.10.09 22:39:08.644878 [ 3 ] {6983ec2d-1bdf-47c5-aad2-ea6fb7357d13} <Debug> DynamicQueryHandler: Done processing query | ||
| 348 | 2024.10.09 22:39:08.644909 [ 3 ] {} <Debug> HTTP-Session: 4ddca368-a3d5-4d80-8857-8a0e393ec0dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 349 | 2024.10.09 22:39:08.649358 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 350 | 2024.10.09 22:39:08.649519 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 351 | 2024.10.09 22:39:08.649554 [ 3 ] {} <Debug> HTTP-Session: 28f58ce6-bb52-42e0-8fe7-765af277939f Authenticating user 'default' from [::1]:43618 | ||
| 352 | 2024.10.09 22:39:08.649580 [ 3 ] {} <Debug> HTTP-Session: 28f58ce6-bb52-42e0-8fe7-765af277939f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 353 | 2024.10.09 22:39:08.649595 [ 3 ] {} <Debug> HTTP-Session: 28f58ce6-bb52-42e0-8fe7-765af277939f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 354 | 2024.10.09 22:39:08.649665 [ 3 ] {} <Trace> HTTP-Session: 28f58ce6-bb52-42e0-8fe7-765af277939f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 355 | 2024.10.09 22:39:08.650071 [ 3 ] {71a0fd68-73ec-4c8e-a756-84ca1aa2d22d} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 356 | 2024.10.09 22:39:08.650162 [ 3 ] {71a0fd68-73ec-4c8e-a756-84ca1aa2d22d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 357 | 2024.10.09 22:39:08.652930 [ 3 ] {71a0fd68-73ec-4c8e-a756-84ca1aa2d22d} <Debug> oximeter.measurements_u64 (ff29b347-ad3b-4108-9b31-c3a8aec57e69): Loading data parts | ||
| 358 | 2024.10.09 22:39:08.653457 [ 3 ] {71a0fd68-73ec-4c8e-a756-84ca1aa2d22d} <Debug> oximeter.measurements_u64 (ff29b347-ad3b-4108-9b31-c3a8aec57e69): There are no data parts | ||
| 359 | 2024.10.09 22:39:08.655195 [ 3 ] {71a0fd68-73ec-4c8e-a756-84ca1aa2d22d} <Debug> DynamicQueryHandler: Done processing query | ||
| 360 | 2024.10.09 22:39:08.655224 [ 3 ] {} <Debug> HTTP-Session: 28f58ce6-bb52-42e0-8fe7-765af277939f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 361 | 2024.10.09 22:39:08.661431 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 362 | 2024.10.09 22:39:08.661574 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 363 | 2024.10.09 22:39:08.661602 [ 3 ] {} <Debug> HTTP-Session: a5c05c2d-ae83-48af-a1a9-75083d3d506f Authenticating user 'default' from [::1]:43618 | ||
| 364 | 2024.10.09 22:39:08.661630 [ 3 ] {} <Debug> HTTP-Session: a5c05c2d-ae83-48af-a1a9-75083d3d506f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 365 | 2024.10.09 22:39:08.661655 [ 3 ] {} <Debug> HTTP-Session: a5c05c2d-ae83-48af-a1a9-75083d3d506f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 366 | 2024.10.09 22:39:08.661713 [ 3 ] {} <Trace> HTTP-Session: a5c05c2d-ae83-48af-a1a9-75083d3d506f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 367 | 2024.10.09 22:39:08.662248 [ 3 ] {52ff5e28-ad75-416e-83ce-cf584744e6a2} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 368 | 2024.10.09 22:39:08.662331 [ 3 ] {52ff5e28-ad75-416e-83ce-cf584744e6a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 369 | 2024.10.09 22:39:08.664959 [ 3 ] {52ff5e28-ad75-416e-83ce-cf584744e6a2} <Debug> oximeter.measurements_f32 (2e80bcae-7cc0-4237-97c6-b3898e4b977f): Loading data parts | ||
| 370 | 2024.10.09 22:39:08.665330 [ 3 ] {52ff5e28-ad75-416e-83ce-cf584744e6a2} <Debug> oximeter.measurements_f32 (2e80bcae-7cc0-4237-97c6-b3898e4b977f): There are no data parts | ||
| 371 | 2024.10.09 22:39:08.667240 [ 3 ] {52ff5e28-ad75-416e-83ce-cf584744e6a2} <Debug> DynamicQueryHandler: Done processing query | ||
| 372 | 2024.10.09 22:39:08.667281 [ 3 ] {} <Debug> HTTP-Session: a5c05c2d-ae83-48af-a1a9-75083d3d506f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 373 | 2024.10.09 22:39:08.670886 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 374 | 2024.10.09 22:39:08.670980 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 375 | 2024.10.09 22:39:08.671022 [ 3 ] {} <Debug> HTTP-Session: e0783d8a-b7e6-4a56-a585-df81adf66d70 Authenticating user 'default' from [::1]:43618 | ||
| 376 | 2024.10.09 22:39:08.671048 [ 3 ] {} <Debug> HTTP-Session: e0783d8a-b7e6-4a56-a585-df81adf66d70 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 377 | 2024.10.09 22:39:08.671064 [ 3 ] {} <Debug> HTTP-Session: e0783d8a-b7e6-4a56-a585-df81adf66d70 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 378 | 2024.10.09 22:39:08.671139 [ 3 ] {} <Trace> HTTP-Session: e0783d8a-b7e6-4a56-a585-df81adf66d70 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 379 | 2024.10.09 22:39:08.671498 [ 3 ] {23984d65-bd74-4b8c-96d3-6a2568870260} <Debug> executeQuery: (from [::1]:43618) 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:39:08.671582 [ 3 ] {23984d65-bd74-4b8c-96d3-6a2568870260} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 381 | 2024.10.09 22:39:08.679635 [ 3 ] {23984d65-bd74-4b8c-96d3-6a2568870260} <Debug> oximeter.measurements_f64 (2f8feead-8188-4102-9200-c1c3e53add0d): Loading data parts | ||
| 382 | 2024.10.09 22:39:08.680000 [ 3 ] {23984d65-bd74-4b8c-96d3-6a2568870260} <Debug> oximeter.measurements_f64 (2f8feead-8188-4102-9200-c1c3e53add0d): There are no data parts | ||
| 383 | 2024.10.09 22:39:08.681820 [ 3 ] {23984d65-bd74-4b8c-96d3-6a2568870260} <Debug> DynamicQueryHandler: Done processing query | ||
| 384 | 2024.10.09 22:39:08.681852 [ 3 ] {} <Debug> HTTP-Session: e0783d8a-b7e6-4a56-a585-df81adf66d70 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 385 | 2024.10.09 22:39:08.699412 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 386 | 2024.10.09 22:39:08.699554 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 387 | 2024.10.09 22:39:08.699581 [ 3 ] {} <Debug> HTTP-Session: d6655ad2-676a-4247-8cfe-21e234d48c38 Authenticating user 'default' from [::1]:43618 | ||
| 388 | 2024.10.09 22:39:08.699607 [ 3 ] {} <Debug> HTTP-Session: d6655ad2-676a-4247-8cfe-21e234d48c38 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 389 | 2024.10.09 22:39:08.699629 [ 3 ] {} <Debug> HTTP-Session: d6655ad2-676a-4247-8cfe-21e234d48c38 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 390 | 2024.10.09 22:39:08.699686 [ 3 ] {} <Trace> HTTP-Session: d6655ad2-676a-4247-8cfe-21e234d48c38 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 391 | 2024.10.09 22:39:08.700056 [ 3 ] {d94015d6-80bc-4521-84dd-39fbd3d70198} <Debug> executeQuery: (from [::1]:43618) 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:39:08.700186 [ 3 ] {d94015d6-80bc-4521-84dd-39fbd3d70198} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 393 | 2024.10.09 22:39:08.702707 [ 3 ] {d94015d6-80bc-4521-84dd-39fbd3d70198} <Debug> oximeter.measurements_string (e519fab0-58f0-4abc-a781-a29a87348ae9): Loading data parts | ||
| 394 | 2024.10.09 22:39:08.703031 [ 3 ] {d94015d6-80bc-4521-84dd-39fbd3d70198} <Debug> oximeter.measurements_string (e519fab0-58f0-4abc-a781-a29a87348ae9): There are no data parts | ||
| 395 | 2024.10.09 22:39:08.704891 [ 3 ] {d94015d6-80bc-4521-84dd-39fbd3d70198} <Debug> DynamicQueryHandler: Done processing query | ||
| 396 | 2024.10.09 22:39:08.704921 [ 3 ] {} <Debug> HTTP-Session: d6655ad2-676a-4247-8cfe-21e234d48c38 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 397 | 2024.10.09 22:39:08.925553 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 398 | 2024.10.09 22:39:08.925686 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 399 | 2024.10.09 22:39:08.925741 [ 3 ] {} <Debug> HTTP-Session: d91c3bd0-6796-467a-9233-138e4c1aae6a Authenticating user 'default' from [::1]:43618 | ||
| 400 | 2024.10.09 22:39:08.925824 [ 3 ] {} <Debug> HTTP-Session: d91c3bd0-6796-467a-9233-138e4c1aae6a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 401 | 2024.10.09 22:39:08.925841 [ 3 ] {} <Debug> HTTP-Session: d91c3bd0-6796-467a-9233-138e4c1aae6a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 402 | 2024.10.09 22:39:08.925899 [ 3 ] {} <Trace> HTTP-Session: d91c3bd0-6796-467a-9233-138e4c1aae6a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 403 | 2024.10.09 22:39:08.926376 [ 3 ] {94eebaca-aab7-4f54-8443-46bc55d195c5} <Debug> executeQuery: (from [::1]:43618) 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:39:08.926463 [ 3 ] {94eebaca-aab7-4f54-8443-46bc55d195c5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 412 | 2024.10.09 22:39:08.929107 [ 3 ] {94eebaca-aab7-4f54-8443-46bc55d195c5} <Debug> oximeter.measurements_bytes (f3eb026c-ccf7-4e4b-800f-cfbf06f47c06): Loading data parts | ||
| 413 | 2024.10.09 22:39:08.929439 [ 3 ] {94eebaca-aab7-4f54-8443-46bc55d195c5} <Debug> oximeter.measurements_bytes (f3eb026c-ccf7-4e4b-800f-cfbf06f47c06): There are no data parts | ||
| 414 | 2024.10.09 22:39:08.931413 [ 3 ] {94eebaca-aab7-4f54-8443-46bc55d195c5} <Debug> DynamicQueryHandler: Done processing query | ||
| 415 | 2024.10.09 22:39:08.931453 [ 3 ] {} <Debug> HTTP-Session: d91c3bd0-6796-467a-9233-138e4c1aae6a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 416 | 2024.10.09 22:39:08.963504 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 417 | 2024.10.09 22:39:08.963639 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 418 | 2024.10.09 22:39:08.963722 [ 3 ] {} <Debug> HTTP-Session: bdbaa9fe-91a6-4ddb-84b8-9c2f154b138d Authenticating user 'default' from [::1]:43618 | ||
| 419 | 2024.10.09 22:39:08.963760 [ 3 ] {} <Debug> HTTP-Session: bdbaa9fe-91a6-4ddb-84b8-9c2f154b138d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 420 | 2024.10.09 22:39:08.963777 [ 3 ] {} <Debug> HTTP-Session: bdbaa9fe-91a6-4ddb-84b8-9c2f154b138d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 421 | 2024.10.09 22:39:08.963963 [ 3 ] {} <Trace> HTTP-Session: bdbaa9fe-91a6-4ddb-84b8-9c2f154b138d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 422 | 2024.10.09 22:39:08.964433 [ 3 ] {c5dfc881-fd3a-4d32-8311-a01d9bd92aab} <Debug> executeQuery: (from [::1]:43618) 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:39:08.964526 [ 3 ] {c5dfc881-fd3a-4d32-8311-a01d9bd92aab} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 424 | 2024.10.09 22:39:08.967048 [ 3 ] {c5dfc881-fd3a-4d32-8311-a01d9bd92aab} <Debug> oximeter.measurements_cumulativei64 (dda53db7-3edd-4a95-b53a-9850d379acca): Loading data parts | ||
| 425 | 2024.10.09 22:39:08.967386 [ 3 ] {c5dfc881-fd3a-4d32-8311-a01d9bd92aab} <Debug> oximeter.measurements_cumulativei64 (dda53db7-3edd-4a95-b53a-9850d379acca): There are no data parts | ||
| 426 | 2024.10.09 22:39:08.969101 [ 3 ] {c5dfc881-fd3a-4d32-8311-a01d9bd92aab} <Debug> DynamicQueryHandler: Done processing query | ||
| 427 | 2024.10.09 22:39:08.969128 [ 3 ] {} <Debug> HTTP-Session: bdbaa9fe-91a6-4ddb-84b8-9c2f154b138d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 428 | 2024.10.09 22:39:09.000455 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 180.44 MiB, peak 181.46 MiB, free memory in arenas 0.00 B, will set to 186.04 MiB (RSS), difference: 5.59 MiB | ||
| 429 | 2024.10.09 22:39:09.169180 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 430 | 2024.10.09 22:39:09.169332 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 431 | 2024.10.09 22:39:09.169389 [ 3 ] {} <Debug> HTTP-Session: 1e904aba-f67b-404e-a494-76fc8e41dd32 Authenticating user 'default' from [::1]:43618 | ||
| 432 | 2024.10.09 22:39:09.169416 [ 3 ] {} <Debug> HTTP-Session: 1e904aba-f67b-404e-a494-76fc8e41dd32 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 433 | 2024.10.09 22:39:09.169430 [ 3 ] {} <Debug> HTTP-Session: 1e904aba-f67b-404e-a494-76fc8e41dd32 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 434 | 2024.10.09 22:39:09.169488 [ 3 ] {} <Trace> HTTP-Session: 1e904aba-f67b-404e-a494-76fc8e41dd32 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 435 | 2024.10.09 22:39:09.169891 [ 3 ] {b379ba19-aba8-4d19-b215-c8c3d88e0f90} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 436 | 2024.10.09 22:39:09.169976 [ 3 ] {b379ba19-aba8-4d19-b215-c8c3d88e0f90} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 437 | 2024.10.09 22:39:09.172606 [ 3 ] {b379ba19-aba8-4d19-b215-c8c3d88e0f90} <Debug> oximeter.measurements_cumulativeu64 (97c54ce3-40c6-4a3c-b6ce-343a320dbdd0): Loading data parts | ||
| 438 | 2024.10.09 22:39:09.172909 [ 3 ] {b379ba19-aba8-4d19-b215-c8c3d88e0f90} <Debug> oximeter.measurements_cumulativeu64 (97c54ce3-40c6-4a3c-b6ce-343a320dbdd0): There are no data parts | ||
| 439 | 2024.10.09 22:39:09.174957 [ 3 ] {b379ba19-aba8-4d19-b215-c8c3d88e0f90} <Debug> DynamicQueryHandler: Done processing query | ||
| 440 | 2024.10.09 22:39:09.174993 [ 3 ] {} <Debug> HTTP-Session: 1e904aba-f67b-404e-a494-76fc8e41dd32 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 441 | 2024.10.09 22:39:09.179327 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 442 | 2024.10.09 22:39:09.179592 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 443 | 2024.10.09 22:39:09.179632 [ 3 ] {} <Debug> HTTP-Session: ed149d98-4726-45cd-83d6-00137274411c Authenticating user 'default' from [::1]:43618 | ||
| 444 | 2024.10.09 22:39:09.179662 [ 3 ] {} <Debug> HTTP-Session: ed149d98-4726-45cd-83d6-00137274411c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 445 | 2024.10.09 22:39:09.179693 [ 3 ] {} <Debug> HTTP-Session: ed149d98-4726-45cd-83d6-00137274411c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 446 | 2024.10.09 22:39:09.179754 [ 3 ] {} <Trace> HTTP-Session: ed149d98-4726-45cd-83d6-00137274411c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 447 | 2024.10.09 22:39:09.180224 [ 3 ] {0a9a33fd-b731-4620-aee6-a18268ce6676} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 448 | 2024.10.09 22:39:09.180315 [ 3 ] {0a9a33fd-b731-4620-aee6-a18268ce6676} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 449 | 2024.10.09 22:39:09.183182 [ 3 ] {0a9a33fd-b731-4620-aee6-a18268ce6676} <Debug> oximeter.measurements_cumulativef32 (cde951e0-812e-4b46-a808-4372adf4845c): Loading data parts | ||
| 450 | 2024.10.09 22:39:09.183536 [ 3 ] {0a9a33fd-b731-4620-aee6-a18268ce6676} <Debug> oximeter.measurements_cumulativef32 (cde951e0-812e-4b46-a808-4372adf4845c): There are no data parts | ||
| 451 | 2024.10.09 22:39:09.185576 [ 3 ] {0a9a33fd-b731-4620-aee6-a18268ce6676} <Debug> DynamicQueryHandler: Done processing query | ||
| 452 | 2024.10.09 22:39:09.185624 [ 3 ] {} <Debug> HTTP-Session: ed149d98-4726-45cd-83d6-00137274411c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 453 | 2024.10.09 22:39:09.210578 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 454 | 2024.10.09 22:39:09.210715 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 455 | 2024.10.09 22:39:09.210764 [ 3 ] {} <Debug> HTTP-Session: e8cb3ebf-b6e9-47ad-ab18-6095991465f3 Authenticating user 'default' from [::1]:43618 | ||
| 456 | 2024.10.09 22:39:09.210793 [ 3 ] {} <Debug> HTTP-Session: e8cb3ebf-b6e9-47ad-ab18-6095991465f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 457 | 2024.10.09 22:39:09.210808 [ 3 ] {} <Debug> HTTP-Session: e8cb3ebf-b6e9-47ad-ab18-6095991465f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 458 | 2024.10.09 22:39:09.210879 [ 3 ] {} <Trace> HTTP-Session: e8cb3ebf-b6e9-47ad-ab18-6095991465f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 459 | 2024.10.09 22:39:09.211313 [ 3 ] {3e012e46-c8ca-44f6-9514-95e2c851a70a} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 460 | 2024.10.09 22:39:09.211406 [ 3 ] {3e012e46-c8ca-44f6-9514-95e2c851a70a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 461 | 2024.10.09 22:39:09.214063 [ 3 ] {3e012e46-c8ca-44f6-9514-95e2c851a70a} <Debug> oximeter.measurements_cumulativef64 (6c5d5448-989f-4e1c-a3cd-e97444df6a85): Loading data parts | ||
| 462 | 2024.10.09 22:39:09.214434 [ 3 ] {3e012e46-c8ca-44f6-9514-95e2c851a70a} <Debug> oximeter.measurements_cumulativef64 (6c5d5448-989f-4e1c-a3cd-e97444df6a85): There are no data parts | ||
| 463 | 2024.10.09 22:39:09.216428 [ 3 ] {3e012e46-c8ca-44f6-9514-95e2c851a70a} <Debug> DynamicQueryHandler: Done processing query | ||
| 464 | 2024.10.09 22:39:09.216470 [ 3 ] {} <Debug> HTTP-Session: e8cb3ebf-b6e9-47ad-ab18-6095991465f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 465 | 2024.10.09 22:39:09.217795 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 466 | 2024.10.09 22:39:09.217900 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 467 | 2024.10.09 22:39:09.217940 [ 3 ] {} <Debug> HTTP-Session: 291411b3-aa56-4e27-b0d8-d0db8c8d80de Authenticating user 'default' from [::1]:43618 | ||
| 468 | 2024.10.09 22:39:09.217981 [ 3 ] {} <Debug> HTTP-Session: 291411b3-aa56-4e27-b0d8-d0db8c8d80de Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 469 | 2024.10.09 22:39:09.218011 [ 3 ] {} <Debug> HTTP-Session: 291411b3-aa56-4e27-b0d8-d0db8c8d80de Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 470 | 2024.10.09 22:39:09.218078 [ 3 ] {} <Trace> HTTP-Session: 291411b3-aa56-4e27-b0d8-d0db8c8d80de Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 471 | 2024.10.09 22:39:09.218740 [ 3 ] {fc7034d8-c267-4fdc-8f5b-af28c930d301} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 472 | * NOTE: Array types cannot be Nullable, see | ||
| 473 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 474 | * for more details. | ||
| 475 | * | ||
| 476 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 477 | * is unfortunate, and at this point relies on the fact that an | ||
| 478 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 479 | * to figure out another way to represent missing samples here. | ||
| 480 | */ | ||
| 481 | bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 482 | 2024.10.09 22:39:09.218857 [ 3 ] {fc7034d8-c267-4fdc-8f5b-af28c930d301} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 483 | 2024.10.09 22:39:09.222585 [ 3 ] {fc7034d8-c267-4fdc-8f5b-af28c930d301} <Debug> oximeter.measurements_histogrami8 (40372f40-1a04-4b06-9133-6d16c08d409a): Loading data parts | ||
| 484 | 2024.10.09 22:39:09.224295 [ 3 ] {fc7034d8-c267-4fdc-8f5b-af28c930d301} <Debug> oximeter.measurements_histogrami8 (40372f40-1a04-4b06-9133-6d16c08d409a): There are no data parts | ||
| 485 | 2024.10.09 22:39:09.227020 [ 3 ] {fc7034d8-c267-4fdc-8f5b-af28c930d301} <Debug> DynamicQueryHandler: Done processing query | ||
| 486 | 2024.10.09 22:39:09.227099 [ 3 ] {} <Debug> HTTP-Session: 291411b3-aa56-4e27-b0d8-d0db8c8d80de Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 487 | 2024.10.09 22:39:09.258781 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 488 | 2024.10.09 22:39:09.258915 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 489 | 2024.10.09 22:39:09.258968 [ 3 ] {} <Debug> HTTP-Session: a22004ea-e57e-4d5d-bd71-2c62085e64d9 Authenticating user 'default' from [::1]:43618 | ||
| 490 | 2024.10.09 22:39:09.258997 [ 3 ] {} <Debug> HTTP-Session: a22004ea-e57e-4d5d-bd71-2c62085e64d9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 491 | 2024.10.09 22:39:09.259014 [ 3 ] {} <Debug> HTTP-Session: a22004ea-e57e-4d5d-bd71-2c62085e64d9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 492 | 2024.10.09 22:39:09.259136 [ 3 ] {} <Trace> HTTP-Session: a22004ea-e57e-4d5d-bd71-2c62085e64d9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 493 | 2024.10.09 22:39:09.259758 [ 3 ] {8107eca9-003b-47cb-9e1e-8919eb22b327} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 494 | 2024.10.09 22:39:09.259901 [ 3 ] {8107eca9-003b-47cb-9e1e-8919eb22b327} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 495 | 2024.10.09 22:39:09.263633 [ 3 ] {8107eca9-003b-47cb-9e1e-8919eb22b327} <Debug> oximeter.measurements_histogramu8 (2fecac65-0e58-4717-beaa-21c5822a11a3): Loading data parts | ||
| 496 | 2024.10.09 22:39:09.263994 [ 3 ] {8107eca9-003b-47cb-9e1e-8919eb22b327} <Debug> oximeter.measurements_histogramu8 (2fecac65-0e58-4717-beaa-21c5822a11a3): There are no data parts | ||
| 497 | 2024.10.09 22:39:09.266530 [ 3 ] {8107eca9-003b-47cb-9e1e-8919eb22b327} <Debug> DynamicQueryHandler: Done processing query | ||
| 498 | 2024.10.09 22:39:09.266566 [ 3 ] {} <Debug> HTTP-Session: a22004ea-e57e-4d5d-bd71-2c62085e64d9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 499 | 2024.10.09 22:39:09.270804 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 500 | 2024.10.09 22:39:09.270956 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 501 | 2024.10.09 22:39:09.270984 [ 3 ] {} <Debug> HTTP-Session: f2e0f814-782d-4378-a44e-b53e648caf04 Authenticating user 'default' from [::1]:43618 | ||
| 502 | 2024.10.09 22:39:09.271012 [ 3 ] {} <Debug> HTTP-Session: f2e0f814-782d-4378-a44e-b53e648caf04 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 503 | 2024.10.09 22:39:09.271037 [ 3 ] {} <Debug> HTTP-Session: f2e0f814-782d-4378-a44e-b53e648caf04 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 504 | 2024.10.09 22:39:09.271112 [ 3 ] {} <Trace> HTTP-Session: f2e0f814-782d-4378-a44e-b53e648caf04 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 505 | 2024.10.09 22:39:09.271640 [ 3 ] {fc5a3503-c10c-4b41-8601-04e8e8b0595d} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 506 | 2024.10.09 22:39:09.271738 [ 3 ] {fc5a3503-c10c-4b41-8601-04e8e8b0595d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 507 | 2024.10.09 22:39:09.274644 [ 3 ] {fc5a3503-c10c-4b41-8601-04e8e8b0595d} <Debug> oximeter.measurements_histogrami16 (06d856ce-d9ef-4796-be08-a4a33ee6ffdf): Loading data parts | ||
| 508 | 2024.10.09 22:39:09.274948 [ 3 ] {fc5a3503-c10c-4b41-8601-04e8e8b0595d} <Debug> oximeter.measurements_histogrami16 (06d856ce-d9ef-4796-be08-a4a33ee6ffdf): There are no data parts | ||
| 509 | 2024.10.09 22:39:09.277055 [ 3 ] {fc5a3503-c10c-4b41-8601-04e8e8b0595d} <Debug> DynamicQueryHandler: Done processing query | ||
| 510 | 2024.10.09 22:39:09.277089 [ 3 ] {} <Debug> HTTP-Session: f2e0f814-782d-4378-a44e-b53e648caf04 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 511 | 2024.10.09 22:39:09.306581 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 512 | 2024.10.09 22:39:09.306733 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 513 | 2024.10.09 22:39:09.306767 [ 3 ] {} <Debug> HTTP-Session: 5bc73252-e0af-4e52-a35d-cd43ffdb9d1e Authenticating user 'default' from [::1]:43618 | ||
| 514 | 2024.10.09 22:39:09.306816 [ 3 ] {} <Debug> HTTP-Session: 5bc73252-e0af-4e52-a35d-cd43ffdb9d1e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 515 | 2024.10.09 22:39:09.306836 [ 3 ] {} <Debug> HTTP-Session: 5bc73252-e0af-4e52-a35d-cd43ffdb9d1e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 516 | 2024.10.09 22:39:09.306899 [ 3 ] {} <Trace> HTTP-Session: 5bc73252-e0af-4e52-a35d-cd43ffdb9d1e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 517 | 2024.10.09 22:39:09.307567 [ 3 ] {cd310957-8de4-4170-a413-10c3b987f654} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 518 | 2024.10.09 22:39:09.307690 [ 3 ] {cd310957-8de4-4170-a413-10c3b987f654} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 519 | 2024.10.09 22:39:09.310971 [ 3 ] {cd310957-8de4-4170-a413-10c3b987f654} <Debug> oximeter.measurements_histogramu16 (8b21e8ec-9e3d-485b-8cd0-59ce81c2d6b6): Loading data parts | ||
| 520 | 2024.10.09 22:39:09.311349 [ 3 ] {cd310957-8de4-4170-a413-10c3b987f654} <Debug> oximeter.measurements_histogramu16 (8b21e8ec-9e3d-485b-8cd0-59ce81c2d6b6): There are no data parts | ||
| 521 | 2024.10.09 22:39:09.313298 [ 3 ] {cd310957-8de4-4170-a413-10c3b987f654} <Debug> DynamicQueryHandler: Done processing query | ||
| 522 | 2024.10.09 22:39:09.313330 [ 3 ] {} <Debug> HTTP-Session: 5bc73252-e0af-4e52-a35d-cd43ffdb9d1e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 523 | 2024.10.09 22:39:09.322944 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 524 | 2024.10.09 22:39:09.323124 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 525 | 2024.10.09 22:39:09.323154 [ 3 ] {} <Debug> HTTP-Session: 876007c4-28a1-4f82-855b-a3f9aa35d0b1 Authenticating user 'default' from [::1]:43618 | ||
| 526 | 2024.10.09 22:39:09.327407 [ 3 ] {} <Debug> HTTP-Session: 876007c4-28a1-4f82-855b-a3f9aa35d0b1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 527 | 2024.10.09 22:39:09.327468 [ 3 ] {} <Debug> HTTP-Session: 876007c4-28a1-4f82-855b-a3f9aa35d0b1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 528 | 2024.10.09 22:39:09.327846 [ 3 ] {} <Trace> HTTP-Session: 876007c4-28a1-4f82-855b-a3f9aa35d0b1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 529 | 2024.10.09 22:39:09.328457 [ 3 ] {ef6df917-4e17-447b-94b6-3223400864c3} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 530 | 2024.10.09 22:39:09.328568 [ 3 ] {ef6df917-4e17-447b-94b6-3223400864c3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 531 | 2024.10.09 22:39:09.331677 [ 3 ] {ef6df917-4e17-447b-94b6-3223400864c3} <Debug> oximeter.measurements_histogrami32 (42fa5c23-5c5f-4d57-849c-d6edae063c1d): Loading data parts | ||
| 532 | 2024.10.09 22:39:09.332040 [ 3 ] {ef6df917-4e17-447b-94b6-3223400864c3} <Debug> oximeter.measurements_histogrami32 (42fa5c23-5c5f-4d57-849c-d6edae063c1d): There are no data parts | ||
| 533 | 2024.10.09 22:39:09.333989 [ 3 ] {ef6df917-4e17-447b-94b6-3223400864c3} <Debug> DynamicQueryHandler: Done processing query | ||
| 534 | 2024.10.09 22:39:09.334043 [ 3 ] {} <Debug> HTTP-Session: 876007c4-28a1-4f82-855b-a3f9aa35d0b1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 535 | 2024.10.09 22:39:09.334955 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 536 | 2024.10.09 22:39:09.335054 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 537 | 2024.10.09 22:39:09.335096 [ 3 ] {} <Debug> HTTP-Session: 9e16fd37-a888-46ab-8a98-fdb85136d866 Authenticating user 'default' from [::1]:43618 | ||
| 538 | 2024.10.09 22:39:09.335139 [ 3 ] {} <Debug> HTTP-Session: 9e16fd37-a888-46ab-8a98-fdb85136d866 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 539 | 2024.10.09 22:39:09.335156 [ 3 ] {} <Debug> HTTP-Session: 9e16fd37-a888-46ab-8a98-fdb85136d866 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 540 | 2024.10.09 22:39:09.335209 [ 3 ] {} <Trace> HTTP-Session: 9e16fd37-a888-46ab-8a98-fdb85136d866 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 541 | 2024.10.09 22:39:09.335835 [ 3 ] {a738991e-2760-47f0-984a-0c07eaae5998} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 542 | 2024.10.09 22:39:09.335941 [ 3 ] {a738991e-2760-47f0-984a-0c07eaae5998} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 543 | 2024.10.09 22:39:09.339164 [ 3 ] {a738991e-2760-47f0-984a-0c07eaae5998} <Debug> oximeter.measurements_histogramu32 (3d30ecf2-6305-452f-b345-6451aa8dffec): Loading data parts | ||
| 544 | 2024.10.09 22:39:09.339676 [ 3 ] {a738991e-2760-47f0-984a-0c07eaae5998} <Debug> oximeter.measurements_histogramu32 (3d30ecf2-6305-452f-b345-6451aa8dffec): There are no data parts | ||
| 545 | 2024.10.09 22:39:09.342493 [ 3 ] {a738991e-2760-47f0-984a-0c07eaae5998} <Debug> DynamicQueryHandler: Done processing query | ||
| 546 | 2024.10.09 22:39:09.342552 [ 3 ] {} <Debug> HTTP-Session: 9e16fd37-a888-46ab-8a98-fdb85136d866 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 547 | 2024.10.09 22:39:09.367750 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 548 | 2024.10.09 22:39:09.367893 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 549 | 2024.10.09 22:39:09.367977 [ 3 ] {} <Debug> HTTP-Session: b322458c-831f-483d-a09c-a74e4c6e1852 Authenticating user 'default' from [::1]:43618 | ||
| 550 | 2024.10.09 22:39:09.368025 [ 3 ] {} <Debug> HTTP-Session: b322458c-831f-483d-a09c-a74e4c6e1852 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 551 | 2024.10.09 22:39:09.368044 [ 3 ] {} <Debug> HTTP-Session: b322458c-831f-483d-a09c-a74e4c6e1852 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 552 | 2024.10.09 22:39:09.368117 [ 3 ] {} <Trace> HTTP-Session: b322458c-831f-483d-a09c-a74e4c6e1852 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 553 | 2024.10.09 22:39:09.368748 [ 3 ] {2d969a54-071d-4c29-a5d0-752244c8b0fa} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 554 | 2024.10.09 22:39:09.368860 [ 3 ] {2d969a54-071d-4c29-a5d0-752244c8b0fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 555 | 2024.10.09 22:39:09.372201 [ 3 ] {2d969a54-071d-4c29-a5d0-752244c8b0fa} <Debug> oximeter.measurements_histogrami64 (4f4a4947-02c5-4034-a740-57eab0bbac80): Loading data parts | ||
| 556 | 2024.10.09 22:39:09.372640 [ 3 ] {2d969a54-071d-4c29-a5d0-752244c8b0fa} <Debug> oximeter.measurements_histogrami64 (4f4a4947-02c5-4034-a740-57eab0bbac80): There are no data parts | ||
| 557 | 2024.10.09 22:39:09.374842 [ 3 ] {2d969a54-071d-4c29-a5d0-752244c8b0fa} <Debug> DynamicQueryHandler: Done processing query | ||
| 558 | 2024.10.09 22:39:09.374877 [ 3 ] {} <Debug> HTTP-Session: b322458c-831f-483d-a09c-a74e4c6e1852 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 559 | 2024.10.09 22:39:09.377847 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 560 | 2024.10.09 22:39:09.377975 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 561 | 2024.10.09 22:39:09.378021 [ 3 ] {} <Debug> HTTP-Session: 4a08232c-4b79-4805-893e-26a5ab4f708e Authenticating user 'default' from [::1]:43618 | ||
| 562 | 2024.10.09 22:39:09.378050 [ 3 ] {} <Debug> HTTP-Session: 4a08232c-4b79-4805-893e-26a5ab4f708e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 563 | 2024.10.09 22:39:09.378076 [ 3 ] {} <Debug> HTTP-Session: 4a08232c-4b79-4805-893e-26a5ab4f708e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 564 | 2024.10.09 22:39:09.378135 [ 3 ] {} <Trace> HTTP-Session: 4a08232c-4b79-4805-893e-26a5ab4f708e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 565 | 2024.10.09 22:39:09.378780 [ 3 ] {936430ac-5a8d-48df-9e37-3056a3f47c62} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 566 | 2024.10.09 22:39:09.378892 [ 3 ] {936430ac-5a8d-48df-9e37-3056a3f47c62} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 567 | 2024.10.09 22:39:09.382335 [ 3 ] {936430ac-5a8d-48df-9e37-3056a3f47c62} <Debug> oximeter.measurements_histogramu64 (f0e8fcc1-81a8-4a03-825a-6a0acc119b14): Loading data parts | ||
| 568 | 2024.10.09 22:39:09.382686 [ 3 ] {936430ac-5a8d-48df-9e37-3056a3f47c62} <Debug> oximeter.measurements_histogramu64 (f0e8fcc1-81a8-4a03-825a-6a0acc119b14): There are no data parts | ||
| 569 | 2024.10.09 22:39:09.384770 [ 3 ] {936430ac-5a8d-48df-9e37-3056a3f47c62} <Debug> DynamicQueryHandler: Done processing query | ||
| 570 | 2024.10.09 22:39:09.384817 [ 3 ] {} <Debug> HTTP-Session: 4a08232c-4b79-4805-893e-26a5ab4f708e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 571 | 2024.10.09 22:39:09.392092 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 572 | 2024.10.09 22:39:09.392223 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 573 | 2024.10.09 22:39:09.392276 [ 3 ] {} <Debug> HTTP-Session: 68a54833-2218-4fe9-b54b-0a61edd5dc50 Authenticating user 'default' from [::1]:43618 | ||
| 574 | 2024.10.09 22:39:09.392305 [ 3 ] {} <Debug> HTTP-Session: 68a54833-2218-4fe9-b54b-0a61edd5dc50 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 575 | 2024.10.09 22:39:09.392324 [ 3 ] {} <Debug> HTTP-Session: 68a54833-2218-4fe9-b54b-0a61edd5dc50 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 576 | 2024.10.09 22:39:09.392396 [ 3 ] {} <Trace> HTTP-Session: 68a54833-2218-4fe9-b54b-0a61edd5dc50 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 577 | 2024.10.09 22:39:09.392938 [ 3 ] {118cbbbe-65c7-4afd-817a-80e5c3203348} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 578 | 2024.10.09 22:39:09.393063 [ 3 ] {118cbbbe-65c7-4afd-817a-80e5c3203348} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 579 | 2024.10.09 22:39:09.401404 [ 3 ] {118cbbbe-65c7-4afd-817a-80e5c3203348} <Debug> oximeter.measurements_histogramf32 (02b5c3e2-4655-4c2b-a2f2-8a45a1e009ed): Loading data parts | ||
| 580 | 2024.10.09 22:39:09.401913 [ 3 ] {118cbbbe-65c7-4afd-817a-80e5c3203348} <Debug> oximeter.measurements_histogramf32 (02b5c3e2-4655-4c2b-a2f2-8a45a1e009ed): There are no data parts | ||
| 581 | 2024.10.09 22:39:09.405052 [ 3 ] {118cbbbe-65c7-4afd-817a-80e5c3203348} <Debug> DynamicQueryHandler: Done processing query | ||
| 582 | 2024.10.09 22:39:09.405086 [ 3 ] {} <Debug> HTTP-Session: 68a54833-2218-4fe9-b54b-0a61edd5dc50 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 583 | 2024.10.09 22:39:09.408471 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 584 | 2024.10.09 22:39:09.408624 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 585 | 2024.10.09 22:39:09.408659 [ 3 ] {} <Debug> HTTP-Session: 1c1b099e-0819-424e-a703-66979eb095ca Authenticating user 'default' from [::1]:43618 | ||
| 586 | 2024.10.09 22:39:09.408686 [ 3 ] {} <Debug> HTTP-Session: 1c1b099e-0819-424e-a703-66979eb095ca Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 587 | 2024.10.09 22:39:09.408713 [ 3 ] {} <Debug> HTTP-Session: 1c1b099e-0819-424e-a703-66979eb095ca Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 588 | 2024.10.09 22:39:09.408770 [ 3 ] {} <Trace> HTTP-Session: 1c1b099e-0819-424e-a703-66979eb095ca Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 589 | 2024.10.09 22:39:09.409828 [ 3 ] {ef3fac6c-e46a-4fc2-8672-43636a19057d} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 590 | 2024.10.09 22:39:09.409936 [ 3 ] {ef3fac6c-e46a-4fc2-8672-43636a19057d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 591 | 2024.10.09 22:39:09.414704 [ 3 ] {ef3fac6c-e46a-4fc2-8672-43636a19057d} <Debug> oximeter.measurements_histogramf64 (fbde305e-ed5e-470c-9ee4-fd612400d74b): Loading data parts | ||
| 592 | 2024.10.09 22:39:09.416047 [ 3 ] {ef3fac6c-e46a-4fc2-8672-43636a19057d} <Debug> oximeter.measurements_histogramf64 (fbde305e-ed5e-470c-9ee4-fd612400d74b): There are no data parts | ||
| 593 | 2024.10.09 22:39:09.419278 [ 3 ] {ef3fac6c-e46a-4fc2-8672-43636a19057d} <Debug> DynamicQueryHandler: Done processing query | ||
| 594 | 2024.10.09 22:39:09.419314 [ 3 ] {} <Debug> HTTP-Session: 1c1b099e-0819-424e-a703-66979eb095ca Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 595 | 2024.10.09 22:39:09.424798 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 596 | 2024.10.09 22:39:09.424916 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 597 | 2024.10.09 22:39:09.425070 [ 3 ] {} <Debug> HTTP-Session: d1e37d99-a6b5-4b5f-8172-2972f540451a Authenticating user 'default' from [::1]:43618 | ||
| 598 | 2024.10.09 22:39:09.425110 [ 3 ] {} <Debug> HTTP-Session: d1e37d99-a6b5-4b5f-8172-2972f540451a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 599 | 2024.10.09 22:39:09.425127 [ 3 ] {} <Debug> HTTP-Session: d1e37d99-a6b5-4b5f-8172-2972f540451a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 600 | 2024.10.09 22:39:09.425194 [ 3 ] {} <Trace> HTTP-Session: d1e37d99-a6b5-4b5f-8172-2972f540451a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 601 | 2024.10.09 22:39:09.425600 [ 3 ] {dce21a61-2369-4f6c-a848-77363062c319} <Debug> executeQuery: (from [::1]:43618) /* The field tables store named dimensions of each timeseries. | ||
| 602 | * | ||
| 603 | * As with the measurement tables, there is one field table for each field data | ||
| 604 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 605 | * this behavior **must not** be relied upon for query correctness. | ||
| 606 | * | ||
| 607 | * The index for the fields differs from the measurements, however. Rows are | ||
| 608 | * sorted by timeseries name, then field name, field value, and finally | ||
| 609 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 610 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 611 | * usually then used to look up measurements. | ||
| 612 | * | ||
| 613 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 614 | * timeseries name and then key, since it would improve lookups where one | ||
| 615 | * already has the key. Realistically though, these tables are quite small and | ||
| 616 | * so performance benefits will be low in absolute terms. | ||
| 617 | * | ||
| 618 | * TTL: We use a materialized column to expire old field table records. This | ||
| 619 | * column is generated automatically by the database whenever a new row is | ||
| 620 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 621 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 622 | * record will remain during a deduplication, which will have the last | ||
| 623 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 624 | * measurement tables. | ||
| 625 | */ | ||
| 626 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 627 | 2024.10.09 22:39:09.425718 [ 3 ] {dce21a61-2369-4f6c-a848-77363062c319} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 628 | 2024.10.09 22:39:09.428539 [ 3 ] {dce21a61-2369-4f6c-a848-77363062c319} <Debug> oximeter.fields_bool (38bb36d9-3fdb-4270-81fa-7d9f9e3a2f85): Loading data parts | ||
| 629 | 2024.10.09 22:39:09.429047 [ 3 ] {dce21a61-2369-4f6c-a848-77363062c319} <Debug> oximeter.fields_bool (38bb36d9-3fdb-4270-81fa-7d9f9e3a2f85): There are no data parts | ||
| 630 | 2024.10.09 22:39:09.431020 [ 3 ] {dce21a61-2369-4f6c-a848-77363062c319} <Debug> DynamicQueryHandler: Done processing query | ||
| 631 | 2024.10.09 22:39:09.431082 [ 3 ] {} <Debug> HTTP-Session: d1e37d99-a6b5-4b5f-8172-2972f540451a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 632 | 2024.10.09 22:39:09.438297 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 633 | 2024.10.09 22:39:09.438524 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 634 | 2024.10.09 22:39:09.438598 [ 3 ] {} <Debug> HTTP-Session: 3e1e1a3f-8530-4a02-80bb-86fc28363597 Authenticating user 'default' from [::1]:43618 | ||
| 635 | 2024.10.09 22:39:09.438630 [ 3 ] {} <Debug> HTTP-Session: 3e1e1a3f-8530-4a02-80bb-86fc28363597 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 636 | 2024.10.09 22:39:09.438658 [ 3 ] {} <Debug> HTTP-Session: 3e1e1a3f-8530-4a02-80bb-86fc28363597 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 637 | 2024.10.09 22:39:09.438740 [ 3 ] {} <Trace> HTTP-Session: 3e1e1a3f-8530-4a02-80bb-86fc28363597 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 638 | 2024.10.09 22:39:09.439296 [ 3 ] {1007a982-cbe7-4eb0-a20f-73f2c6c4a746} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 639 | 2024.10.09 22:39:09.439402 [ 3 ] {1007a982-cbe7-4eb0-a20f-73f2c6c4a746} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 640 | 2024.10.09 22:39:09.445127 [ 3 ] {1007a982-cbe7-4eb0-a20f-73f2c6c4a746} <Debug> oximeter.fields_i8 (e224d68f-cf0c-4cd8-b3ba-5a267aa44d10): Loading data parts | ||
| 641 | 2024.10.09 22:39:09.446923 [ 3 ] {1007a982-cbe7-4eb0-a20f-73f2c6c4a746} <Debug> oximeter.fields_i8 (e224d68f-cf0c-4cd8-b3ba-5a267aa44d10): There are no data parts | ||
| 642 | 2024.10.09 22:39:09.449175 [ 3 ] {1007a982-cbe7-4eb0-a20f-73f2c6c4a746} <Debug> DynamicQueryHandler: Done processing query | ||
| 643 | 2024.10.09 22:39:09.449215 [ 3 ] {} <Debug> HTTP-Session: 3e1e1a3f-8530-4a02-80bb-86fc28363597 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 644 | 2024.10.09 22:39:09.450637 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 645 | 2024.10.09 22:39:09.450758 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 646 | 2024.10.09 22:39:09.450786 [ 3 ] {} <Debug> HTTP-Session: 90cf526c-eb8a-42be-9b04-ec653a034a72 Authenticating user 'default' from [::1]:43618 | ||
| 647 | 2024.10.09 22:39:09.450870 [ 3 ] {} <Debug> HTTP-Session: 90cf526c-eb8a-42be-9b04-ec653a034a72 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 648 | 2024.10.09 22:39:09.451022 [ 3 ] {} <Debug> HTTP-Session: 90cf526c-eb8a-42be-9b04-ec653a034a72 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 649 | 2024.10.09 22:39:09.451125 [ 3 ] {} <Trace> HTTP-Session: 90cf526c-eb8a-42be-9b04-ec653a034a72 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 650 | 2024.10.09 22:39:09.451619 [ 3 ] {bec96cc1-3399-464b-852f-81bbe2e018bf} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 651 | 2024.10.09 22:39:09.453871 [ 3 ] {bec96cc1-3399-464b-852f-81bbe2e018bf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 652 | 2024.10.09 22:39:09.457031 [ 3 ] {bec96cc1-3399-464b-852f-81bbe2e018bf} <Debug> oximeter.fields_u8 (216a8678-5643-491a-b9a8-51e0ae229796): Loading data parts | ||
| 653 | 2024.10.09 22:39:09.457376 [ 3 ] {bec96cc1-3399-464b-852f-81bbe2e018bf} <Debug> oximeter.fields_u8 (216a8678-5643-491a-b9a8-51e0ae229796): There are no data parts | ||
| 654 | 2024.10.09 22:39:09.459477 [ 3 ] {bec96cc1-3399-464b-852f-81bbe2e018bf} <Debug> DynamicQueryHandler: Done processing query | ||
| 655 | 2024.10.09 22:39:09.459531 [ 3 ] {} <Debug> HTTP-Session: 90cf526c-eb8a-42be-9b04-ec653a034a72 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 656 | 2024.10.09 22:39:09.461857 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 657 | 2024.10.09 22:39:09.462378 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 658 | 2024.10.09 22:39:09.462439 [ 3 ] {} <Debug> HTTP-Session: 3ff69dab-718c-47e9-9c84-e28d4497efde Authenticating user 'default' from [::1]:43618 | ||
| 659 | 2024.10.09 22:39:09.462536 [ 3 ] {} <Debug> HTTP-Session: 3ff69dab-718c-47e9-9c84-e28d4497efde Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 660 | 2024.10.09 22:39:09.462567 [ 3 ] {} <Debug> HTTP-Session: 3ff69dab-718c-47e9-9c84-e28d4497efde Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 661 | 2024.10.09 22:39:09.462645 [ 3 ] {} <Trace> HTTP-Session: 3ff69dab-718c-47e9-9c84-e28d4497efde Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 662 | 2024.10.09 22:39:09.463054 [ 3 ] {babd8e0f-3382-44a0-951a-a479899adb54} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 663 | 2024.10.09 22:39:09.463194 [ 3 ] {babd8e0f-3382-44a0-951a-a479899adb54} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 664 | 2024.10.09 22:39:09.473291 [ 3 ] {babd8e0f-3382-44a0-951a-a479899adb54} <Debug> oximeter.fields_i16 (c8d3e2e8-2bbf-4d4e-984e-3cef60ab84dd): Loading data parts | ||
| 665 | 2024.10.09 22:39:09.473884 [ 3 ] {babd8e0f-3382-44a0-951a-a479899adb54} <Debug> oximeter.fields_i16 (c8d3e2e8-2bbf-4d4e-984e-3cef60ab84dd): There are no data parts | ||
| 666 | 2024.10.09 22:39:09.486134 [ 3 ] {babd8e0f-3382-44a0-951a-a479899adb54} <Debug> DynamicQueryHandler: Done processing query | ||
| 667 | 2024.10.09 22:39:09.486189 [ 3 ] {} <Debug> HTTP-Session: 3ff69dab-718c-47e9-9c84-e28d4497efde Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 668 | 2024.10.09 22:39:09.500165 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 669 | 2024.10.09 22:39:09.500324 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 670 | 2024.10.09 22:39:09.500359 [ 3 ] {} <Debug> HTTP-Session: c2697454-f49f-487e-9d50-57d66ecc5d21 Authenticating user 'default' from [::1]:43618 | ||
| 671 | 2024.10.09 22:39:09.500452 [ 3 ] {} <Debug> HTTP-Session: c2697454-f49f-487e-9d50-57d66ecc5d21 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 672 | 2024.10.09 22:39:09.500506 [ 3 ] {} <Debug> HTTP-Session: c2697454-f49f-487e-9d50-57d66ecc5d21 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 673 | 2024.10.09 22:39:09.500602 [ 3 ] {} <Trace> HTTP-Session: c2697454-f49f-487e-9d50-57d66ecc5d21 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 674 | 2024.10.09 22:39:09.501189 [ 3 ] {7d979070-e5ff-404d-82f7-12318d208fca} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 675 | 2024.10.09 22:39:09.501274 [ 3 ] {7d979070-e5ff-404d-82f7-12318d208fca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 676 | 2024.10.09 22:39:09.505849 [ 3 ] {7d979070-e5ff-404d-82f7-12318d208fca} <Debug> oximeter.fields_u16 (a4bc6e3d-9b0c-4731-b1a2-1116d57e2945): Loading data parts | ||
| 677 | 2024.10.09 22:39:09.508368 [ 3 ] {7d979070-e5ff-404d-82f7-12318d208fca} <Debug> oximeter.fields_u16 (a4bc6e3d-9b0c-4731-b1a2-1116d57e2945): There are no data parts | ||
| 678 | 2024.10.09 22:39:09.541718 [ 3 ] {7d979070-e5ff-404d-82f7-12318d208fca} <Debug> DynamicQueryHandler: Done processing query | ||
| 679 | 2024.10.09 22:39:09.541793 [ 3 ] {} <Debug> HTTP-Session: c2697454-f49f-487e-9d50-57d66ecc5d21 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 680 | 2024.10.09 22:39:09.564854 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 681 | 2024.10.09 22:39:09.565027 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 682 | 2024.10.09 22:39:09.565093 [ 3 ] {} <Debug> HTTP-Session: 747bfd3e-d469-489a-8b96-1d6976ea6cc9 Authenticating user 'default' from [::1]:43618 | ||
| 683 | 2024.10.09 22:39:09.565125 [ 3 ] {} <Debug> HTTP-Session: 747bfd3e-d469-489a-8b96-1d6976ea6cc9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 684 | 2024.10.09 22:39:09.565143 [ 3 ] {} <Debug> HTTP-Session: 747bfd3e-d469-489a-8b96-1d6976ea6cc9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 685 | 2024.10.09 22:39:09.565217 [ 3 ] {} <Trace> HTTP-Session: 747bfd3e-d469-489a-8b96-1d6976ea6cc9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 686 | 2024.10.09 22:39:09.565645 [ 3 ] {a935c24e-c9b3-4ba6-9774-4baf658264e6} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 687 | 2024.10.09 22:39:09.565740 [ 3 ] {a935c24e-c9b3-4ba6-9774-4baf658264e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 688 | 2024.10.09 22:39:09.569021 [ 3 ] {a935c24e-c9b3-4ba6-9774-4baf658264e6} <Debug> oximeter.fields_i32 (cdb6015e-454e-495d-8214-1027aee1d8d2): Loading data parts | ||
| 689 | 2024.10.09 22:39:09.575268 [ 3 ] {a935c24e-c9b3-4ba6-9774-4baf658264e6} <Debug> oximeter.fields_i32 (cdb6015e-454e-495d-8214-1027aee1d8d2): There are no data parts | ||
| 690 | 2024.10.09 22:39:09.584460 [ 3 ] {a935c24e-c9b3-4ba6-9774-4baf658264e6} <Debug> DynamicQueryHandler: Done processing query | ||
| 691 | 2024.10.09 22:39:09.584772 [ 3 ] {} <Debug> HTTP-Session: 747bfd3e-d469-489a-8b96-1d6976ea6cc9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 692 | 2024.10.09 22:39:09.689537 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 693 | 2024.10.09 22:39:09.689706 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 694 | 2024.10.09 22:39:09.689735 [ 3 ] {} <Debug> HTTP-Session: 58a2a4a1-de72-4c4e-997e-6a438f585164 Authenticating user 'default' from [::1]:43618 | ||
| 695 | 2024.10.09 22:39:09.689763 [ 3 ] {} <Debug> HTTP-Session: 58a2a4a1-de72-4c4e-997e-6a438f585164 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 696 | 2024.10.09 22:39:09.689792 [ 3 ] {} <Debug> HTTP-Session: 58a2a4a1-de72-4c4e-997e-6a438f585164 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 697 | 2024.10.09 22:39:09.689853 [ 3 ] {} <Trace> HTTP-Session: 58a2a4a1-de72-4c4e-997e-6a438f585164 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 698 | 2024.10.09 22:39:09.690531 [ 3 ] {641c3253-9f07-464e-b989-3d62db94e3ca} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 699 | 2024.10.09 22:39:09.690627 [ 3 ] {641c3253-9f07-464e-b989-3d62db94e3ca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 700 | 2024.10.09 22:39:09.709699 [ 3 ] {641c3253-9f07-464e-b989-3d62db94e3ca} <Debug> oximeter.fields_u32 (75e3e35d-6fed-4ffc-a097-9492fbc82d69): Loading data parts | ||
| 701 | 2024.10.09 22:39:09.710102 [ 3 ] {641c3253-9f07-464e-b989-3d62db94e3ca} <Debug> oximeter.fields_u32 (75e3e35d-6fed-4ffc-a097-9492fbc82d69): There are no data parts | ||
| 702 | 2024.10.09 22:39:09.720408 [ 3 ] {641c3253-9f07-464e-b989-3d62db94e3ca} <Debug> DynamicQueryHandler: Done processing query | ||
| 703 | 2024.10.09 22:39:09.720456 [ 3 ] {} <Debug> HTTP-Session: 58a2a4a1-de72-4c4e-997e-6a438f585164 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 704 | 2024.10.09 22:39:09.733481 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 705 | 2024.10.09 22:39:09.733641 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 706 | 2024.10.09 22:39:09.733704 [ 3 ] {} <Debug> HTTP-Session: 1d5aec19-4646-4c71-af8a-14e6438cabb0 Authenticating user 'default' from [::1]:43618 | ||
| 707 | 2024.10.09 22:39:09.733738 [ 3 ] {} <Debug> HTTP-Session: 1d5aec19-4646-4c71-af8a-14e6438cabb0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 708 | 2024.10.09 22:39:09.733754 [ 3 ] {} <Debug> HTTP-Session: 1d5aec19-4646-4c71-af8a-14e6438cabb0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 709 | 2024.10.09 22:39:09.733812 [ 3 ] {} <Trace> HTTP-Session: 1d5aec19-4646-4c71-af8a-14e6438cabb0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 710 | 2024.10.09 22:39:09.734215 [ 3 ] {709cdd11-d505-43c2-9261-e9a5ece098d6} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 711 | 2024.10.09 22:39:09.734307 [ 3 ] {709cdd11-d505-43c2-9261-e9a5ece098d6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 712 | 2024.10.09 22:39:09.738676 [ 3 ] {709cdd11-d505-43c2-9261-e9a5ece098d6} <Debug> oximeter.fields_i64 (8197abce-81bf-4327-8ae8-5e51e65c423a): Loading data parts | ||
| 713 | 2024.10.09 22:39:09.739025 [ 3 ] {709cdd11-d505-43c2-9261-e9a5ece098d6} <Debug> oximeter.fields_i64 (8197abce-81bf-4327-8ae8-5e51e65c423a): There are no data parts | ||
| 714 | 2024.10.09 22:39:09.741183 [ 3 ] {709cdd11-d505-43c2-9261-e9a5ece098d6} <Debug> DynamicQueryHandler: Done processing query | ||
| 715 | 2024.10.09 22:39:09.741220 [ 3 ] {} <Debug> HTTP-Session: 1d5aec19-4646-4c71-af8a-14e6438cabb0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 716 | 2024.10.09 22:39:09.744861 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 717 | 2024.10.09 22:39:09.745010 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 718 | 2024.10.09 22:39:09.745059 [ 3 ] {} <Debug> HTTP-Session: c39179ad-0ce4-4f9f-8f21-23ac7f4ea529 Authenticating user 'default' from [::1]:43618 | ||
| 719 | 2024.10.09 22:39:09.745089 [ 3 ] {} <Debug> HTTP-Session: c39179ad-0ce4-4f9f-8f21-23ac7f4ea529 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 720 | 2024.10.09 22:39:09.745107 [ 3 ] {} <Debug> HTTP-Session: c39179ad-0ce4-4f9f-8f21-23ac7f4ea529 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 721 | 2024.10.09 22:39:09.745166 [ 3 ] {} <Trace> HTTP-Session: c39179ad-0ce4-4f9f-8f21-23ac7f4ea529 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 722 | 2024.10.09 22:39:09.746232 [ 3 ] {651d8276-c338-4f8a-ac75-6bf255592c5c} <Debug> executeQuery: (from [::1]:43618) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 723 | 2024.10.09 22:39:09.746412 [ 3 ] {651d8276-c338-4f8a-ac75-6bf255592c5c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 724 | 2024.10.09 22:39:09.777529 [ 3 ] {651d8276-c338-4f8a-ac75-6bf255592c5c} <Debug> oximeter.fields_u64 (be0225f8-18e9-4a85-b86e-526c789b946f): Loading data parts | ||
| 725 | 2024.10.09 22:39:09.777933 [ 3 ] {651d8276-c338-4f8a-ac75-6bf255592c5c} <Debug> oximeter.fields_u64 (be0225f8-18e9-4a85-b86e-526c789b946f): There are no data parts | ||
| 726 | 2024.10.09 22:39:09.784724 [ 3 ] {651d8276-c338-4f8a-ac75-6bf255592c5c} <Debug> DynamicQueryHandler: Done processing query | ||
| 727 | 2024.10.09 22:39:09.784811 [ 3 ] {} <Debug> HTTP-Session: c39179ad-0ce4-4f9f-8f21-23ac7f4ea529 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 728 | 2024.10.09 22:39:09.790239 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 729 | 2024.10.09 22:39:09.790359 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 730 | 2024.10.09 22:39:09.790388 [ 3 ] {} <Debug> HTTP-Session: 58e4310d-2a71-4827-97e7-7146389c3ee3 Authenticating user 'default' from [::1]:43618 | ||
| 731 | 2024.10.09 22:39:09.790415 [ 3 ] {} <Debug> HTTP-Session: 58e4310d-2a71-4827-97e7-7146389c3ee3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 732 | 2024.10.09 22:39:09.790432 [ 3 ] {} <Debug> HTTP-Session: 58e4310d-2a71-4827-97e7-7146389c3ee3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 733 | 2024.10.09 22:39:09.790492 [ 3 ] {} <Trace> HTTP-Session: 58e4310d-2a71-4827-97e7-7146389c3ee3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 734 | 2024.10.09 22:39:09.790886 [ 3 ] {18823a11-7c1a-45cf-ba67-ec1747e9a825} <Debug> executeQuery: (from [::1]:43618) 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) | ||
| 735 | 2024.10.09 22:39:09.790967 [ 3 ] {18823a11-7c1a-45cf-ba67-ec1747e9a825} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 736 | 2024.10.09 22:39:09.794609 [ 3 ] {18823a11-7c1a-45cf-ba67-ec1747e9a825} <Debug> oximeter.fields_ipaddr (18b35761-de4d-4d5a-8228-d6408386515b): Loading data parts | ||
| 737 | 2024.10.09 22:39:09.794910 [ 3 ] {18823a11-7c1a-45cf-ba67-ec1747e9a825} <Debug> oximeter.fields_ipaddr (18b35761-de4d-4d5a-8228-d6408386515b): There are no data parts | ||
| 738 | 2024.10.09 22:39:09.797837 [ 3 ] {18823a11-7c1a-45cf-ba67-ec1747e9a825} <Debug> DynamicQueryHandler: Done processing query | ||
| 739 | 2024.10.09 22:39:09.797872 [ 3 ] {} <Debug> HTTP-Session: 58e4310d-2a71-4827-97e7-7146389c3ee3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 740 | 2024.10.09 22:39:09.800121 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 741 | 2024.10.09 22:39:09.800572 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 742 | 2024.10.09 22:39:09.800665 [ 3 ] {} <Debug> HTTP-Session: 3236fd2a-a435-4300-857a-8142ff69633e Authenticating user 'default' from [::1]:43618 | ||
| 743 | 2024.10.09 22:39:09.800695 [ 3 ] {} <Debug> HTTP-Session: 3236fd2a-a435-4300-857a-8142ff69633e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 744 | 2024.10.09 22:39:09.800713 [ 3 ] {} <Debug> HTTP-Session: 3236fd2a-a435-4300-857a-8142ff69633e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 745 | 2024.10.09 22:39:09.800770 [ 3 ] {} <Trace> HTTP-Session: 3236fd2a-a435-4300-857a-8142ff69633e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 746 | 2024.10.09 22:39:09.801347 [ 3 ] {5fa0f0bd-ef32-4a2f-bc55-d8f96b75b2c9} <Debug> executeQuery: (from [::1]:43618) 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) | ||
| 747 | 2024.10.09 22:39:09.801425 [ 3 ] {5fa0f0bd-ef32-4a2f-bc55-d8f96b75b2c9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 748 | 2024.10.09 22:39:09.814278 [ 3 ] {5fa0f0bd-ef32-4a2f-bc55-d8f96b75b2c9} <Debug> oximeter.fields_string (de78bf46-b413-4ec9-8a92-cabb7d9fd833): Loading data parts | ||
| 749 | 2024.10.09 22:39:09.821059 [ 3 ] {5fa0f0bd-ef32-4a2f-bc55-d8f96b75b2c9} <Debug> oximeter.fields_string (de78bf46-b413-4ec9-8a92-cabb7d9fd833): There are no data parts | ||
| 750 | 2024.10.09 22:39:09.823094 [ 3 ] {5fa0f0bd-ef32-4a2f-bc55-d8f96b75b2c9} <Debug> DynamicQueryHandler: Done processing query | ||
| 751 | 2024.10.09 22:39:09.823130 [ 3 ] {} <Debug> HTTP-Session: 3236fd2a-a435-4300-857a-8142ff69633e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 752 | 2024.10.09 22:39:09.824105 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 753 | 2024.10.09 22:39:09.824190 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 754 | 2024.10.09 22:39:09.824217 [ 3 ] {} <Debug> HTTP-Session: 3ae55975-ffe4-439a-be8d-5f2c5005d4da Authenticating user 'default' from [::1]:43618 | ||
| 755 | 2024.10.09 22:39:09.824245 [ 3 ] {} <Debug> HTTP-Session: 3ae55975-ffe4-439a-be8d-5f2c5005d4da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 756 | 2024.10.09 22:39:09.824262 [ 3 ] {} <Debug> HTTP-Session: 3ae55975-ffe4-439a-be8d-5f2c5005d4da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 757 | 2024.10.09 22:39:09.824316 [ 3 ] {} <Trace> HTTP-Session: 3ae55975-ffe4-439a-be8d-5f2c5005d4da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 758 | 2024.10.09 22:39:09.824644 [ 3 ] {e3477909-3754-4839-aebe-3d6ca082f34b} <Debug> executeQuery: (from [::1]:43618) 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) | ||
| 759 | 2024.10.09 22:39:09.824716 [ 3 ] {e3477909-3754-4839-aebe-3d6ca082f34b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 760 | 2024.10.09 22:39:09.827554 [ 3 ] {e3477909-3754-4839-aebe-3d6ca082f34b} <Debug> oximeter.fields_uuid (4a300ab0-bff6-4bca-b755-19b3da9fd629): Loading data parts | ||
| 761 | 2024.10.09 22:39:09.827897 [ 3 ] {e3477909-3754-4839-aebe-3d6ca082f34b} <Debug> oximeter.fields_uuid (4a300ab0-bff6-4bca-b755-19b3da9fd629): There are no data parts | ||
| 762 | 2024.10.09 22:39:09.834973 [ 3 ] {e3477909-3754-4839-aebe-3d6ca082f34b} <Debug> DynamicQueryHandler: Done processing query | ||
| 763 | 2024.10.09 22:39:09.835058 [ 3 ] {} <Debug> HTTP-Session: 3ae55975-ffe4-439a-be8d-5f2c5005d4da Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 764 | 2024.10.09 22:39:09.836924 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 765 | 2024.10.09 22:39:09.839834 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 766 | 2024.10.09 22:39:09.839872 [ 3 ] {} <Debug> HTTP-Session: 53ccc81a-72fe-467f-a53e-6dddb43139ff Authenticating user 'default' from [::1]:43618 | ||
| 767 | 2024.10.09 22:39:09.839903 [ 3 ] {} <Debug> HTTP-Session: 53ccc81a-72fe-467f-a53e-6dddb43139ff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 768 | 2024.10.09 22:39:09.839922 [ 3 ] {} <Debug> HTTP-Session: 53ccc81a-72fe-467f-a53e-6dddb43139ff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 769 | 2024.10.09 22:39:09.839979 [ 3 ] {} <Trace> HTTP-Session: 53ccc81a-72fe-467f-a53e-6dddb43139ff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 770 | 2024.10.09 22:39:09.840444 [ 3 ] {5a8cfe72-bbe7-4662-bf67-ff4168cf4938} <Debug> executeQuery: (from [::1]:43618) /* The timeseries schema table stores the extracted schema for the samples | ||
| 771 | * oximeter collects. | ||
| 772 | */ | ||
| 773 | 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) | ||
| 774 | 2024.10.09 22:39:09.840546 [ 3 ] {5a8cfe72-bbe7-4662-bf67-ff4168cf4938} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 775 | 2024.10.09 22:39:09.852454 [ 3 ] {5a8cfe72-bbe7-4662-bf67-ff4168cf4938} <Debug> oximeter.timeseries_schema (9414d34b-ce51-4e15-a9dc-7d5ab73e7550): Loading data parts | ||
| 776 | 2024.10.09 22:39:09.855227 [ 3 ] {5a8cfe72-bbe7-4662-bf67-ff4168cf4938} <Debug> oximeter.timeseries_schema (9414d34b-ce51-4e15-a9dc-7d5ab73e7550): There are no data parts | ||
| 777 | 2024.10.09 22:39:09.857427 [ 3 ] {5a8cfe72-bbe7-4662-bf67-ff4168cf4938} <Debug> DynamicQueryHandler: Done processing query | ||
| 778 | 2024.10.09 22:39:09.857463 [ 3 ] {} <Debug> HTTP-Session: 53ccc81a-72fe-467f-a53e-6dddb43139ff Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 779 | 2024.10.09 22:39:09.858300 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:43618, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 780 | 2024.10.09 22:39:09.858375 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 781 | 2024.10.09 22:39:09.858399 [ 3 ] {} <Debug> HTTP-Session: 63cb0709-d3f6-432c-bc7a-74be69c35456 Authenticating user 'default' from [::1]:43618 | ||
| 782 | 2024.10.09 22:39:09.858423 [ 3 ] {} <Debug> HTTP-Session: 63cb0709-d3f6-432c-bc7a-74be69c35456 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 783 | 2024.10.09 22:39:09.858437 [ 3 ] {} <Debug> HTTP-Session: 63cb0709-d3f6-432c-bc7a-74be69c35456 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 784 | 2024.10.09 22:39:09.858488 [ 3 ] {} <Trace> HTTP-Session: 63cb0709-d3f6-432c-bc7a-74be69c35456 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 785 | 2024.10.09 22:39:09.858703 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Debug> executeQuery: (from [::1]:43618) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 786 | 2024.10.09 22:39:09.858877 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 787 | 2024.10.09 22:39:09.860273 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Trace> oximeter.version (a526a091-64f0-495f-9adc-1fdca0f8b9a5): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 788 | 2024.10.09 22:39:09.860325 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.26 GiB. | ||
| 789 | 2024.10.09 22:39:09.861094 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 790 | 2024.10.09 22:39:09.861608 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Trace> oximeter.version (a526a091-64f0-495f-9adc-1fdca0f8b9a5): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 791 | 2024.10.09 22:39:09.861887 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003283 sec., 304.5994517209869 rows/sec., 4.76 KiB/sec. | ||
| 792 | 2024.10.09 22:39:09.862094 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Debug> DynamicQueryHandler: Done processing query | ||
| 793 | 2024.10.09 22:39:09.862119 [ 3 ] {e16a9746-3a28-441e-92c9-9e2c2206cd6c} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 794 | 2024.10.09 22:39:09.862135 [ 3 ] {} <Debug> HTTP-Session: 63cb0709-d3f6-432c-bc7a-74be69c35456 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 795 | 2024.10.09 22:39:09.893366 [ 173 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 796 | 2024.10.09 22:39:09.893421 [ 173 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 797 | 2024.10.09 22:39:10.000718 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 188.31 MiB, peak 193.45 MiB, free memory in arenas 0.00 B, will set to 187.21 MiB (RSS), difference: -1.10 MiB | ||