| 1 | 2024.10.09 22:38:34.394161 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 14507 | ||
| 2 | 2024.10.09 22:38:34.394355 [ 1 ] {} <Information> Application: starting up | ||
| 3 | 2024.10.09 22:38:34.394424 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 4 | 2024.10.09 22:38:34.407111 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
| 5 | 2024.10.09 22:38:34.412517 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 6 | 2024.10.09 22:38:34.412600 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 7 | 2024.10.09 22:38:34.412630 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 8 | 2024.10.09 22:38:34.412701 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_region_creation_failure.14493.1-clickhouse-CEurwp/datastore/tmp/ to store temporary data in it | ||
| 9 | 2024.10.09 22:38:34.413329 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 10 | 2024.10.09 22:38:34.415188 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 11 | 2024.10.09 22:38:34.415754 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 12 | 2024.10.09 22:38:34.416386 [ 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:34.416419 [ 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:34.416438 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
| 15 | 2024.10.09 22:38:34.416548 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 16 | 2024.10.09 22:38:34.417375 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 17 | 2024.10.09 22:38:34.424108 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 18 | 2024.10.09 22:38:34.424535 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 19 | 2024.10.09 22:38:34.425085 [ 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:34.425148 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 21 | 2024.10.09 22:38:34.426225 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 22 | 2024.10.09 22:38:34.426794 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 23 | 2024.10.09 22:38:34.428703 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 24 | 2024.10.09 22:38:34.429345 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 25 | 2024.10.09 22:38:34.430532 [ 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:34.431043 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 27 | 2024.10.09 22:38:34.431528 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 28 | 2024.10.09 22:38:34.432198 [ 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:34.434392 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 30 | 2024.10.09 22:38:34.434419 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_region_creation_failure.14493.1-clickhouse-CEurwp/datastore/ | ||
| 31 | 2024.10.09 22:38:34.435789 [ 157 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 32 | 2024.10.09 22:38:34.435848 [ 157 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 33 | 2024.10.09 22:38:34.443116 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 34 | 2024.10.09 22:38:34.443143 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000133914 sec | ||
| 35 | 2024.10.09 22:38:34.443170 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 36 | 2024.10.09 22:38:34.443180 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 37 | 2024.10.09 22:38:34.443282 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 38 | 2024.10.09 22:38:34.443331 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 39 | 2024.10.09 22:38:34.443346 [ 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:34.443371 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 41 | 2024.10.09 22:38:34.443442 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 42 | 2024.10.09 22:38:34.443454 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 43 | 2024.10.09 22:38:34.443479 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 44 | 2024.10.09 22:38:34.443490 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 45 | 2024.10.09 22:38:34.443506 [ 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:34.443528 [ 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:34.443540 [ 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:34.443670 [ 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:34.443691 [ 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:34.443718 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 51 | 2024.10.09 22:38:34.443734 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 52 | 2024.10.09 22:38:34.443859 [ 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:34.443889 [ 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:34.443906 [ 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:34.483794 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 56 | 2024.10.09 22:38:34.486830 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 57 | 2024.10.09 22:38:34.486868 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.4187e-05 sec | ||
| 58 | 2024.10.09 22:38:34.486883 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 59 | 2024.10.09 22:38:34.486894 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 60 | 2024.10.09 22:38:34.486922 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 61 | 2024.10.09 22:38:34.487121 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disk_region_creation_failure.14493.1-clickhouse-CEurwp/datastore/user_defined/ | ||
| 62 | 2024.10.09 22:38:34.487187 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 63 | 2024.10.09 22:38:34.487203 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 64 | 2024.10.09 22:38:34.487216 [ 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:34.487277 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 66 | 2024.10.09 22:38:34.487557 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 49518 | ||
| 67 | 2024.10.09 22:38:34.487804 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 62288 | ||
| 68 | 2024.10.09 22:38:34.489038 [ 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:34.594849 [ 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:34.594896 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 71 | 2024.10.09 22:38:34.832021 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 59339 | ||
| 72 | 2024.10.09 22:38:34.832160 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41538 | ||
| 73 | 2024.10.09 22:38:34.832266 [ 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:35.008918 [ 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:35.009030 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 76 | 2024.10.09 22:38:35.134871 [ 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:35.135301 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 15.73 MiB, free memory in arenas 0.00 B, will set to 178.64 MiB (RSS), difference: 168.74 MiB | ||
| 78 | 2024.10.09 22:38:35.135767 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.8868e-05 sec. | ||
| 79 | 2024.10.09 22:38:35.136368 [ 1 ] {} <Information> Application: Listening for http://[::1]:49518 | ||
| 80 | 2024.10.09 22:38:35.136430 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:62288 | ||
| 81 | 2024.10.09 22:38:35.136491 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004 | ||
| 82 | 2024.10.09 22:38:35.136536 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:59339 | ||
| 83 | 2024.10.09 22:38:35.136584 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:41538 | ||
| 84 | 2024.10.09 22:38:35.136638 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004 | ||
| 85 | 2024.10.09 22:38:35.136659 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 86 | 2024.10.09 22:38:49.374516 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 87 | 2024.10.09 22:38:49.374716 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 88 | 2024.10.09 22:38:49.374756 [ 3 ] {} <Debug> HTTP-Session: a3ed6e07-2823-435f-9b63-743880901bc2 Authenticating user 'default' from [::1]:63207 | ||
| 89 | 2024.10.09 22:38:49.374800 [ 3 ] {} <Debug> HTTP-Session: a3ed6e07-2823-435f-9b63-743880901bc2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 90 | 2024.10.09 22:38:49.374819 [ 3 ] {} <Debug> HTTP-Session: a3ed6e07-2823-435f-9b63-743880901bc2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 91 | 2024.10.09 22:38:49.374927 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 92 | 2024.10.09 22:38:49.374986 [ 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:38:49.375006 [ 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:38:49.375063 [ 3 ] {} <Trace> HTTP-Session: a3ed6e07-2823-435f-9b63-743880901bc2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 95 | 2024.10.09 22:38:49.375606 [ 3 ] {bc442c31-b10f-47b0-bc90-00a04b9a2113} <Debug> executeQuery: (from [::1]:63207) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 96 | 2024.10.09 22:38:49.384442 [ 3 ] {bc442c31-b10f-47b0-bc90-00a04b9a2113} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:63207) (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:38:49.384719 [ 3 ] {bc442c31-b10f-47b0-bc90-00a04b9a2113} <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:38:49.385021 [ 3 ] {} <Debug> HTTP-Session: a3ed6e07-2823-435f-9b63-743880901bc2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2024.10.09 22:38:49.394073 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 148 | 2024.10.09 22:38:49.394230 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 149 | 2024.10.09 22:38:49.394263 [ 3 ] {} <Debug> HTTP-Session: 489f1411-5634-49fe-88e5-93ba5ec525da Authenticating user 'default' from [::1]:63207 | ||
| 150 | 2024.10.09 22:38:49.394290 [ 3 ] {} <Debug> HTTP-Session: 489f1411-5634-49fe-88e5-93ba5ec525da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 151 | 2024.10.09 22:38:49.394310 [ 3 ] {} <Debug> HTTP-Session: 489f1411-5634-49fe-88e5-93ba5ec525da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 152 | 2024.10.09 22:38:49.394370 [ 3 ] {} <Trace> HTTP-Session: 489f1411-5634-49fe-88e5-93ba5ec525da Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 153 | 2024.10.09 22:38:49.394704 [ 3 ] {5a8ae6ea-89f8-47cf-934a-e52f5073bf20} <Debug> executeQuery: (from [::1]:63207) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 154 | 2024.10.09 22:38:49.395148 [ 3 ] {5a8ae6ea-89f8-47cf-934a-e52f5073bf20} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:63207) (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:38:49.395333 [ 3 ] {5a8ae6ea-89f8-47cf-934a-e52f5073bf20} <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:38:49.395561 [ 3 ] {} <Debug> HTTP-Session: 489f1411-5634-49fe-88e5-93ba5ec525da Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 205 | 2024.10.09 22:38:49.402774 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 206 | 2024.10.09 22:38:49.402919 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 207 | 2024.10.09 22:38:49.402952 [ 3 ] {} <Debug> HTTP-Session: 9cff8abe-0387-4c92-a22a-2fa45a5095d0 Authenticating user 'default' from [::1]:63207 | ||
| 208 | 2024.10.09 22:38:49.402979 [ 3 ] {} <Debug> HTTP-Session: 9cff8abe-0387-4c92-a22a-2fa45a5095d0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 209 | 2024.10.09 22:38:49.403002 [ 3 ] {} <Debug> HTTP-Session: 9cff8abe-0387-4c92-a22a-2fa45a5095d0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 210 | 2024.10.09 22:38:49.403065 [ 3 ] {} <Trace> HTTP-Session: 9cff8abe-0387-4c92-a22a-2fa45a5095d0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 211 | 2024.10.09 22:38:49.403346 [ 3 ] {7452eaf0-8f76-4108-884c-4d654326a9bb} <Debug> executeQuery: (from [::1]:63207) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 212 | 2024.10.09 22:38:49.403623 [ 3 ] {7452eaf0-8f76-4108-884c-4d654326a9bb} <Debug> DynamicQueryHandler: Done processing query | ||
| 213 | 2024.10.09 22:38:49.403651 [ 3 ] {} <Debug> HTTP-Session: 9cff8abe-0387-4c92-a22a-2fa45a5095d0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 214 | 2024.10.09 22:38:49.409250 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 215 | 2024.10.09 22:38:49.409380 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 216 | 2024.10.09 22:38:49.409413 [ 3 ] {} <Debug> HTTP-Session: cde8a6b6-8a73-4502-bf6b-89fdb555b210 Authenticating user 'default' from [::1]:63207 | ||
| 217 | 2024.10.09 22:38:49.409441 [ 3 ] {} <Debug> HTTP-Session: cde8a6b6-8a73-4502-bf6b-89fdb555b210 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 218 | 2024.10.09 22:38:49.409464 [ 3 ] {} <Debug> HTTP-Session: cde8a6b6-8a73-4502-bf6b-89fdb555b210 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 219 | 2024.10.09 22:38:49.409526 [ 3 ] {} <Trace> HTTP-Session: cde8a6b6-8a73-4502-bf6b-89fdb555b210 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 220 | 2024.10.09 22:38:49.409776 [ 3 ] {a425a334-8cf2-464d-9e50-583e42469892} <Debug> executeQuery: (from [::1]:63207) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 221 | 2024.10.09 22:38:49.409869 [ 3 ] {a425a334-8cf2-464d-9e50-583e42469892} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 222 | 2024.10.09 22:38:49.411628 [ 3 ] {a425a334-8cf2-464d-9e50-583e42469892} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 223 | 2024.10.09 22:38:49.411688 [ 3 ] {a425a334-8cf2-464d-9e50-583e42469892} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000100536 sec | ||
| 224 | 2024.10.09 22:38:49.411708 [ 3 ] {a425a334-8cf2-464d-9e50-583e42469892} <Trace> ReferentialDeps: No tables | ||
| 225 | 2024.10.09 22:38:49.411720 [ 3 ] {a425a334-8cf2-464d-9e50-583e42469892} <Trace> LoadingDeps: No tables | ||
| 226 | 2024.10.09 22:38:49.411746 [ 3 ] {a425a334-8cf2-464d-9e50-583e42469892} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 227 | 2024.10.09 22:38:49.411954 [ 3 ] {a425a334-8cf2-464d-9e50-583e42469892} <Debug> DynamicQueryHandler: Done processing query | ||
| 228 | 2024.10.09 22:38:49.411981 [ 3 ] {} <Debug> HTTP-Session: cde8a6b6-8a73-4502-bf6b-89fdb555b210 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 229 | 2024.10.09 22:38:49.417543 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 230 | 2024.10.09 22:38:49.417681 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 231 | 2024.10.09 22:38:49.417714 [ 3 ] {} <Debug> HTTP-Session: e584c41c-cc68-459f-a372-33578c3fc900 Authenticating user 'default' from [::1]:63207 | ||
| 232 | 2024.10.09 22:38:49.417743 [ 3 ] {} <Debug> HTTP-Session: e584c41c-cc68-459f-a372-33578c3fc900 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 233 | 2024.10.09 22:38:49.417760 [ 3 ] {} <Debug> HTTP-Session: e584c41c-cc68-459f-a372-33578c3fc900 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 234 | 2024.10.09 22:38:49.417826 [ 3 ] {} <Trace> HTTP-Session: e584c41c-cc68-459f-a372-33578c3fc900 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 235 | 2024.10.09 22:38:49.418140 [ 3 ] {66b2a4a1-70d5-4280-81f9-9c15e4ed855d} <Debug> executeQuery: (from [::1]:63207) /* 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:38:49.418234 [ 3 ] {66b2a4a1-70d5-4280-81f9-9c15e4ed855d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 238 | 2024.10.09 22:38:49.419779 [ 3 ] {66b2a4a1-70d5-4280-81f9-9c15e4ed855d} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 239 | 2024.10.09 22:38:49.421276 [ 3 ] {66b2a4a1-70d5-4280-81f9-9c15e4ed855d} <Debug> oximeter.version (ca6c66ba-f20b-4193-9817-4cba10a882f0): Loading data parts | ||
| 240 | 2024.10.09 22:38:49.422990 [ 3 ] {66b2a4a1-70d5-4280-81f9-9c15e4ed855d} <Debug> oximeter.version (ca6c66ba-f20b-4193-9817-4cba10a882f0): There are no data parts | ||
| 241 | 2024.10.09 22:38:49.424942 [ 3 ] {66b2a4a1-70d5-4280-81f9-9c15e4ed855d} <Debug> DynamicQueryHandler: Done processing query | ||
| 242 | 2024.10.09 22:38:49.424977 [ 3 ] {} <Debug> HTTP-Session: e584c41c-cc68-459f-a372-33578c3fc900 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 243 | 2024.10.09 22:38:49.426136 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 244 | 2024.10.09 22:38:49.426216 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 245 | 2024.10.09 22:38:49.426242 [ 3 ] {} <Debug> HTTP-Session: a1cd7708-de9d-4783-ab37-c482dbb81466 Authenticating user 'default' from [::1]:63207 | ||
| 246 | 2024.10.09 22:38:49.426277 [ 3 ] {} <Debug> HTTP-Session: a1cd7708-de9d-4783-ab37-c482dbb81466 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 247 | 2024.10.09 22:38:49.426295 [ 3 ] {} <Debug> HTTP-Session: a1cd7708-de9d-4783-ab37-c482dbb81466 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 248 | 2024.10.09 22:38:49.426350 [ 3 ] {} <Trace> HTTP-Session: a1cd7708-de9d-4783-ab37-c482dbb81466 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 249 | 2024.10.09 22:38:49.426696 [ 3 ] {b90fe04e-9244-4710-b4ed-e16adfcd1ee2} <Debug> executeQuery: (from [::1]:63207) /* 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:38:49.426778 [ 3 ] {b90fe04e-9244-4710-b4ed-e16adfcd1ee2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 261 | 2024.10.09 22:38:49.429562 [ 3 ] {b90fe04e-9244-4710-b4ed-e16adfcd1ee2} <Debug> oximeter.measurements_bool (490ef79b-806b-40a2-81c2-960ff000ce8c): Loading data parts | ||
| 262 | 2024.10.09 22:38:49.429890 [ 3 ] {b90fe04e-9244-4710-b4ed-e16adfcd1ee2} <Debug> oximeter.measurements_bool (490ef79b-806b-40a2-81c2-960ff000ce8c): There are no data parts | ||
| 263 | 2024.10.09 22:38:49.431820 [ 3 ] {b90fe04e-9244-4710-b4ed-e16adfcd1ee2} <Debug> DynamicQueryHandler: Done processing query | ||
| 264 | 2024.10.09 22:38:49.431853 [ 3 ] {} <Debug> HTTP-Session: a1cd7708-de9d-4783-ab37-c482dbb81466 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2024.10.09 22:38:49.435399 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 266 | 2024.10.09 22:38:49.435522 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 267 | 2024.10.09 22:38:49.435556 [ 3 ] {} <Debug> HTTP-Session: cca8ae8c-fc6c-4dd2-8d39-e0f677294b4e Authenticating user 'default' from [::1]:63207 | ||
| 268 | 2024.10.09 22:38:49.435587 [ 3 ] {} <Debug> HTTP-Session: cca8ae8c-fc6c-4dd2-8d39-e0f677294b4e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2024.10.09 22:38:49.435606 [ 3 ] {} <Debug> HTTP-Session: cca8ae8c-fc6c-4dd2-8d39-e0f677294b4e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2024.10.09 22:38:49.435696 [ 3 ] {} <Trace> HTTP-Session: cca8ae8c-fc6c-4dd2-8d39-e0f677294b4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 271 | 2024.10.09 22:38:49.436033 [ 3 ] {3661a499-6d32-48f6-a82f-586b42e115ae} <Debug> executeQuery: (from [::1]:63207) 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:38:49.436112 [ 3 ] {3661a499-6d32-48f6-a82f-586b42e115ae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 273 | 2024.10.09 22:38:49.436145 [ 146 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 274 | 2024.10.09 22:38:49.436173 [ 146 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 275 | 2024.10.09 22:38:49.438509 [ 3 ] {3661a499-6d32-48f6-a82f-586b42e115ae} <Debug> oximeter.measurements_i8 (2c72c568-8d7f-4713-a404-06ee502b5cc5): Loading data parts | ||
| 276 | 2024.10.09 22:38:49.438872 [ 3 ] {3661a499-6d32-48f6-a82f-586b42e115ae} <Debug> oximeter.measurements_i8 (2c72c568-8d7f-4713-a404-06ee502b5cc5): There are no data parts | ||
| 277 | 2024.10.09 22:38:49.440753 [ 3 ] {3661a499-6d32-48f6-a82f-586b42e115ae} <Debug> DynamicQueryHandler: Done processing query | ||
| 278 | 2024.10.09 22:38:49.440780 [ 3 ] {} <Debug> HTTP-Session: cca8ae8c-fc6c-4dd2-8d39-e0f677294b4e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2024.10.09 22:38:49.449049 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 280 | 2024.10.09 22:38:49.449221 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 281 | 2024.10.09 22:38:49.449282 [ 3 ] {} <Debug> HTTP-Session: 36fa969c-4264-4c3e-a3fb-118e7a348afe Authenticating user 'default' from [::1]:63207 | ||
| 282 | 2024.10.09 22:38:49.449311 [ 3 ] {} <Debug> HTTP-Session: 36fa969c-4264-4c3e-a3fb-118e7a348afe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.10.09 22:38:49.449338 [ 3 ] {} <Debug> HTTP-Session: 36fa969c-4264-4c3e-a3fb-118e7a348afe Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 284 | 2024.10.09 22:38:49.449408 [ 3 ] {} <Trace> HTTP-Session: 36fa969c-4264-4c3e-a3fb-118e7a348afe Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 285 | 2024.10.09 22:38:49.449911 [ 3 ] {d930a59b-f64c-4a9a-81bd-f1455f9b9d35} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 286 | 2024.10.09 22:38:49.450014 [ 3 ] {d930a59b-f64c-4a9a-81bd-f1455f9b9d35} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 287 | 2024.10.09 22:38:49.452973 [ 3 ] {d930a59b-f64c-4a9a-81bd-f1455f9b9d35} <Debug> oximeter.measurements_u8 (0d48face-c237-4db9-8a58-60ef233e6bc4): Loading data parts | ||
| 288 | 2024.10.09 22:38:49.453451 [ 3 ] {d930a59b-f64c-4a9a-81bd-f1455f9b9d35} <Debug> oximeter.measurements_u8 (0d48face-c237-4db9-8a58-60ef233e6bc4): There are no data parts | ||
| 289 | 2024.10.09 22:38:49.455499 [ 3 ] {d930a59b-f64c-4a9a-81bd-f1455f9b9d35} <Debug> DynamicQueryHandler: Done processing query | ||
| 290 | 2024.10.09 22:38:49.455534 [ 3 ] {} <Debug> HTTP-Session: 36fa969c-4264-4c3e-a3fb-118e7a348afe Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 291 | 2024.10.09 22:38:49.464465 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 292 | 2024.10.09 22:38:49.464672 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 293 | 2024.10.09 22:38:49.464712 [ 3 ] {} <Debug> HTTP-Session: 582c042e-319f-40a9-994f-0f9d98e9ef1a Authenticating user 'default' from [::1]:63207 | ||
| 294 | 2024.10.09 22:38:49.464742 [ 3 ] {} <Debug> HTTP-Session: 582c042e-319f-40a9-994f-0f9d98e9ef1a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.10.09 22:38:49.464767 [ 3 ] {} <Debug> HTTP-Session: 582c042e-319f-40a9-994f-0f9d98e9ef1a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 296 | 2024.10.09 22:38:49.464830 [ 3 ] {} <Trace> HTTP-Session: 582c042e-319f-40a9-994f-0f9d98e9ef1a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 297 | 2024.10.09 22:38:49.465253 [ 3 ] {429c3655-b746-4c7f-a79d-ce84663984e4} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 298 | 2024.10.09 22:38:49.465337 [ 3 ] {429c3655-b746-4c7f-a79d-ce84663984e4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 299 | 2024.10.09 22:38:49.468058 [ 3 ] {429c3655-b746-4c7f-a79d-ce84663984e4} <Debug> oximeter.measurements_i16 (c72b7988-645f-4dfb-b706-ace7c166010b): Loading data parts | ||
| 300 | 2024.10.09 22:38:49.468435 [ 3 ] {429c3655-b746-4c7f-a79d-ce84663984e4} <Debug> oximeter.measurements_i16 (c72b7988-645f-4dfb-b706-ace7c166010b): There are no data parts | ||
| 301 | 2024.10.09 22:38:49.470305 [ 3 ] {429c3655-b746-4c7f-a79d-ce84663984e4} <Debug> DynamicQueryHandler: Done processing query | ||
| 302 | 2024.10.09 22:38:49.470339 [ 3 ] {} <Debug> HTTP-Session: 582c042e-319f-40a9-994f-0f9d98e9ef1a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 303 | 2024.10.09 22:38:49.471676 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 304 | 2024.10.09 22:38:49.472304 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 305 | 2024.10.09 22:38:49.472340 [ 3 ] {} <Debug> HTTP-Session: 44c6c0cc-1c79-408b-adc9-776b782cded2 Authenticating user 'default' from [::1]:63207 | ||
| 306 | 2024.10.09 22:38:49.472378 [ 3 ] {} <Debug> HTTP-Session: 44c6c0cc-1c79-408b-adc9-776b782cded2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.10.09 22:38:49.472393 [ 3 ] {} <Debug> HTTP-Session: 44c6c0cc-1c79-408b-adc9-776b782cded2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 308 | 2024.10.09 22:38:49.472450 [ 3 ] {} <Trace> HTTP-Session: 44c6c0cc-1c79-408b-adc9-776b782cded2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 309 | 2024.10.09 22:38:49.472858 [ 3 ] {014e6e7b-ecec-43df-949f-34b8743d96ba} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 310 | 2024.10.09 22:38:49.472946 [ 3 ] {014e6e7b-ecec-43df-949f-34b8743d96ba} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 311 | 2024.10.09 22:38:49.476354 [ 3 ] {014e6e7b-ecec-43df-949f-34b8743d96ba} <Debug> oximeter.measurements_u16 (3e337154-dde5-455f-a112-b616e4042146): Loading data parts | ||
| 312 | 2024.10.09 22:38:49.476715 [ 3 ] {014e6e7b-ecec-43df-949f-34b8743d96ba} <Debug> oximeter.measurements_u16 (3e337154-dde5-455f-a112-b616e4042146): There are no data parts | ||
| 313 | 2024.10.09 22:38:49.478610 [ 3 ] {014e6e7b-ecec-43df-949f-34b8743d96ba} <Debug> DynamicQueryHandler: Done processing query | ||
| 314 | 2024.10.09 22:38:49.478653 [ 3 ] {} <Debug> HTTP-Session: 44c6c0cc-1c79-408b-adc9-776b782cded2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 315 | 2024.10.09 22:38:49.479678 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 316 | 2024.10.09 22:38:49.479759 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 317 | 2024.10.09 22:38:49.479794 [ 3 ] {} <Debug> HTTP-Session: 79f04569-27d1-4e49-a180-dd78f5af11ff Authenticating user 'default' from [::1]:63207 | ||
| 318 | 2024.10.09 22:38:49.479821 [ 3 ] {} <Debug> HTTP-Session: 79f04569-27d1-4e49-a180-dd78f5af11ff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.10.09 22:38:49.479836 [ 3 ] {} <Debug> HTTP-Session: 79f04569-27d1-4e49-a180-dd78f5af11ff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 320 | 2024.10.09 22:38:49.479895 [ 3 ] {} <Trace> HTTP-Session: 79f04569-27d1-4e49-a180-dd78f5af11ff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 321 | 2024.10.09 22:38:49.480268 [ 3 ] {3b0e8031-d82b-4c4b-884a-c0bc08ef156f} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 322 | 2024.10.09 22:38:49.480355 [ 3 ] {3b0e8031-d82b-4c4b-884a-c0bc08ef156f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 323 | 2024.10.09 22:38:49.482983 [ 3 ] {3b0e8031-d82b-4c4b-884a-c0bc08ef156f} <Debug> oximeter.measurements_i32 (0020d1e5-b557-482d-8a2b-34d4044bfa33): Loading data parts | ||
| 324 | 2024.10.09 22:38:49.483404 [ 3 ] {3b0e8031-d82b-4c4b-884a-c0bc08ef156f} <Debug> oximeter.measurements_i32 (0020d1e5-b557-482d-8a2b-34d4044bfa33): There are no data parts | ||
| 325 | 2024.10.09 22:38:49.485293 [ 3 ] {3b0e8031-d82b-4c4b-884a-c0bc08ef156f} <Debug> DynamicQueryHandler: Done processing query | ||
| 326 | 2024.10.09 22:38:49.485323 [ 3 ] {} <Debug> HTTP-Session: 79f04569-27d1-4e49-a180-dd78f5af11ff Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 327 | 2024.10.09 22:38:49.488268 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 328 | 2024.10.09 22:38:49.488379 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 329 | 2024.10.09 22:38:49.488407 [ 3 ] {} <Debug> HTTP-Session: 60946359-cee6-4d06-8e70-7d4890a60d89 Authenticating user 'default' from [::1]:63207 | ||
| 330 | 2024.10.09 22:38:49.488434 [ 3 ] {} <Debug> HTTP-Session: 60946359-cee6-4d06-8e70-7d4890a60d89 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 331 | 2024.10.09 22:38:49.488458 [ 3 ] {} <Debug> HTTP-Session: 60946359-cee6-4d06-8e70-7d4890a60d89 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 332 | 2024.10.09 22:38:49.488550 [ 3 ] {} <Trace> HTTP-Session: 60946359-cee6-4d06-8e70-7d4890a60d89 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 333 | 2024.10.09 22:38:49.488921 [ 3 ] {2a956d5a-babb-4806-8a09-6fcac455007f} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 334 | 2024.10.09 22:38:49.488996 [ 3 ] {2a956d5a-babb-4806-8a09-6fcac455007f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 335 | 2024.10.09 22:38:49.492514 [ 3 ] {2a956d5a-babb-4806-8a09-6fcac455007f} <Debug> oximeter.measurements_u32 (d8dd29e7-910d-440f-90be-f035d84876c1): Loading data parts | ||
| 336 | 2024.10.09 22:38:49.492879 [ 3 ] {2a956d5a-babb-4806-8a09-6fcac455007f} <Debug> oximeter.measurements_u32 (d8dd29e7-910d-440f-90be-f035d84876c1): There are no data parts | ||
| 337 | 2024.10.09 22:38:49.494854 [ 3 ] {2a956d5a-babb-4806-8a09-6fcac455007f} <Debug> DynamicQueryHandler: Done processing query | ||
| 338 | 2024.10.09 22:38:49.494897 [ 3 ] {} <Debug> HTTP-Session: 60946359-cee6-4d06-8e70-7d4890a60d89 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 339 | 2024.10.09 22:38:49.496670 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 340 | 2024.10.09 22:38:49.496755 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 341 | 2024.10.09 22:38:49.496792 [ 3 ] {} <Debug> HTTP-Session: f90d6913-6625-4216-86ff-b339e5258a47 Authenticating user 'default' from [::1]:63207 | ||
| 342 | 2024.10.09 22:38:49.496820 [ 3 ] {} <Debug> HTTP-Session: f90d6913-6625-4216-86ff-b339e5258a47 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2024.10.09 22:38:49.496835 [ 3 ] {} <Debug> HTTP-Session: f90d6913-6625-4216-86ff-b339e5258a47 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 344 | 2024.10.09 22:38:49.496895 [ 3 ] {} <Trace> HTTP-Session: f90d6913-6625-4216-86ff-b339e5258a47 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 345 | 2024.10.09 22:38:49.497265 [ 3 ] {721f2e65-0577-4c1b-ba65-7c0ac710c307} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 346 | 2024.10.09 22:38:49.497376 [ 3 ] {721f2e65-0577-4c1b-ba65-7c0ac710c307} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 347 | 2024.10.09 22:38:49.499874 [ 3 ] {721f2e65-0577-4c1b-ba65-7c0ac710c307} <Debug> oximeter.measurements_i64 (545444f0-3be4-46a7-b082-47b9da78c083): Loading data parts | ||
| 348 | 2024.10.09 22:38:49.500255 [ 3 ] {721f2e65-0577-4c1b-ba65-7c0ac710c307} <Debug> oximeter.measurements_i64 (545444f0-3be4-46a7-b082-47b9da78c083): There are no data parts | ||
| 349 | 2024.10.09 22:38:49.502252 [ 3 ] {721f2e65-0577-4c1b-ba65-7c0ac710c307} <Debug> DynamicQueryHandler: Done processing query | ||
| 350 | 2024.10.09 22:38:49.502284 [ 3 ] {} <Debug> HTTP-Session: f90d6913-6625-4216-86ff-b339e5258a47 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 351 | 2024.10.09 22:38:49.503617 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 352 | 2024.10.09 22:38:49.503712 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 353 | 2024.10.09 22:38:49.503738 [ 3 ] {} <Debug> HTTP-Session: ed6b6a7b-e21c-43a6-acee-b8bdf5b38b67 Authenticating user 'default' from [::1]:63207 | ||
| 354 | 2024.10.09 22:38:49.503763 [ 3 ] {} <Debug> HTTP-Session: ed6b6a7b-e21c-43a6-acee-b8bdf5b38b67 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 355 | 2024.10.09 22:38:49.503786 [ 3 ] {} <Debug> HTTP-Session: ed6b6a7b-e21c-43a6-acee-b8bdf5b38b67 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 356 | 2024.10.09 22:38:49.503841 [ 3 ] {} <Trace> HTTP-Session: ed6b6a7b-e21c-43a6-acee-b8bdf5b38b67 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 357 | 2024.10.09 22:38:49.504171 [ 3 ] {93613984-316a-412e-a9d6-446eb2bb7e56} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 358 | 2024.10.09 22:38:49.504250 [ 3 ] {93613984-316a-412e-a9d6-446eb2bb7e56} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 359 | 2024.10.09 22:38:49.506866 [ 3 ] {93613984-316a-412e-a9d6-446eb2bb7e56} <Debug> oximeter.measurements_u64 (ad48884c-9e72-4fb5-bdf4-f6ec6032c303): Loading data parts | ||
| 360 | 2024.10.09 22:38:49.507204 [ 3 ] {93613984-316a-412e-a9d6-446eb2bb7e56} <Debug> oximeter.measurements_u64 (ad48884c-9e72-4fb5-bdf4-f6ec6032c303): There are no data parts | ||
| 361 | 2024.10.09 22:38:49.509078 [ 3 ] {93613984-316a-412e-a9d6-446eb2bb7e56} <Debug> DynamicQueryHandler: Done processing query | ||
| 362 | 2024.10.09 22:38:49.509108 [ 3 ] {} <Debug> HTTP-Session: ed6b6a7b-e21c-43a6-acee-b8bdf5b38b67 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 363 | 2024.10.09 22:38:49.510724 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 364 | 2024.10.09 22:38:49.510805 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 365 | 2024.10.09 22:38:49.510830 [ 3 ] {} <Debug> HTTP-Session: 2e864453-8111-4e81-9579-9ee8717477d3 Authenticating user 'default' from [::1]:63207 | ||
| 366 | 2024.10.09 22:38:49.510868 [ 3 ] {} <Debug> HTTP-Session: 2e864453-8111-4e81-9579-9ee8717477d3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 367 | 2024.10.09 22:38:49.510884 [ 3 ] {} <Debug> HTTP-Session: 2e864453-8111-4e81-9579-9ee8717477d3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 368 | 2024.10.09 22:38:49.510937 [ 3 ] {} <Trace> HTTP-Session: 2e864453-8111-4e81-9579-9ee8717477d3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 369 | 2024.10.09 22:38:49.511265 [ 3 ] {086d856c-7a3e-4d90-b81d-19f3cbf2eeae} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 370 | 2024.10.09 22:38:49.511344 [ 3 ] {086d856c-7a3e-4d90-b81d-19f3cbf2eeae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 371 | 2024.10.09 22:38:49.513918 [ 3 ] {086d856c-7a3e-4d90-b81d-19f3cbf2eeae} <Debug> oximeter.measurements_f32 (137b6a32-85a5-4f5a-8cfa-988c441257db): Loading data parts | ||
| 372 | 2024.10.09 22:38:49.514222 [ 3 ] {086d856c-7a3e-4d90-b81d-19f3cbf2eeae} <Debug> oximeter.measurements_f32 (137b6a32-85a5-4f5a-8cfa-988c441257db): There are no data parts | ||
| 373 | 2024.10.09 22:38:49.516182 [ 3 ] {086d856c-7a3e-4d90-b81d-19f3cbf2eeae} <Debug> DynamicQueryHandler: Done processing query | ||
| 374 | 2024.10.09 22:38:49.516216 [ 3 ] {} <Debug> HTTP-Session: 2e864453-8111-4e81-9579-9ee8717477d3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 375 | 2024.10.09 22:38:49.517241 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 376 | 2024.10.09 22:38:49.517346 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 377 | 2024.10.09 22:38:49.517370 [ 3 ] {} <Debug> HTTP-Session: 75c8a394-0185-4a49-9774-c57573b7b117 Authenticating user 'default' from [::1]:63207 | ||
| 378 | 2024.10.09 22:38:49.517398 [ 3 ] {} <Debug> HTTP-Session: 75c8a394-0185-4a49-9774-c57573b7b117 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 379 | 2024.10.09 22:38:49.517422 [ 3 ] {} <Debug> HTTP-Session: 75c8a394-0185-4a49-9774-c57573b7b117 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 380 | 2024.10.09 22:38:49.517476 [ 3 ] {} <Trace> HTTP-Session: 75c8a394-0185-4a49-9774-c57573b7b117 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 381 | 2024.10.09 22:38:49.517808 [ 3 ] {0b9eb955-fd3e-4987-9dde-43e9424c8f54} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 382 | 2024.10.09 22:38:49.517890 [ 3 ] {0b9eb955-fd3e-4987-9dde-43e9424c8f54} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 383 | 2024.10.09 22:38:49.520517 [ 3 ] {0b9eb955-fd3e-4987-9dde-43e9424c8f54} <Debug> oximeter.measurements_f64 (dd1a16c8-84a7-468e-9232-0143d5c100ca): Loading data parts | ||
| 384 | 2024.10.09 22:38:49.520910 [ 3 ] {0b9eb955-fd3e-4987-9dde-43e9424c8f54} <Debug> oximeter.measurements_f64 (dd1a16c8-84a7-468e-9232-0143d5c100ca): There are no data parts | ||
| 385 | 2024.10.09 22:38:49.522748 [ 3 ] {0b9eb955-fd3e-4987-9dde-43e9424c8f54} <Debug> DynamicQueryHandler: Done processing query | ||
| 386 | 2024.10.09 22:38:49.522779 [ 3 ] {} <Debug> HTTP-Session: 75c8a394-0185-4a49-9774-c57573b7b117 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 387 | 2024.10.09 22:38:49.524211 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 388 | 2024.10.09 22:38:49.524302 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 389 | 2024.10.09 22:38:49.524331 [ 3 ] {} <Debug> HTTP-Session: 53688e85-b7ef-46e1-850d-a868ae95e217 Authenticating user 'default' from [::1]:63207 | ||
| 390 | 2024.10.09 22:38:49.524369 [ 3 ] {} <Debug> HTTP-Session: 53688e85-b7ef-46e1-850d-a868ae95e217 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 391 | 2024.10.09 22:38:49.524387 [ 3 ] {} <Debug> HTTP-Session: 53688e85-b7ef-46e1-850d-a868ae95e217 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 392 | 2024.10.09 22:38:49.524445 [ 3 ] {} <Trace> HTTP-Session: 53688e85-b7ef-46e1-850d-a868ae95e217 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 393 | 2024.10.09 22:38:49.524925 [ 3 ] {096d6b6b-e269-4aa8-ba51-11cbe3eac503} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 394 | 2024.10.09 22:38:49.525017 [ 3 ] {096d6b6b-e269-4aa8-ba51-11cbe3eac503} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 395 | 2024.10.09 22:38:49.527912 [ 3 ] {096d6b6b-e269-4aa8-ba51-11cbe3eac503} <Debug> oximeter.measurements_string (35ab6c41-f5c3-4111-8a77-a776267d49f5): Loading data parts | ||
| 396 | 2024.10.09 22:38:49.528400 [ 3 ] {096d6b6b-e269-4aa8-ba51-11cbe3eac503} <Debug> oximeter.measurements_string (35ab6c41-f5c3-4111-8a77-a776267d49f5): There are no data parts | ||
| 397 | 2024.10.09 22:38:49.530520 [ 3 ] {096d6b6b-e269-4aa8-ba51-11cbe3eac503} <Debug> DynamicQueryHandler: Done processing query | ||
| 398 | 2024.10.09 22:38:49.530568 [ 3 ] {} <Debug> HTTP-Session: 53688e85-b7ef-46e1-850d-a868ae95e217 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 399 | 2024.10.09 22:38:49.531771 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 400 | 2024.10.09 22:38:49.531860 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 401 | 2024.10.09 22:38:49.531898 [ 3 ] {} <Debug> HTTP-Session: 587da230-ef1f-46aa-b141-a651c56c1ebb Authenticating user 'default' from [::1]:63207 | ||
| 402 | 2024.10.09 22:38:49.531926 [ 3 ] {} <Debug> HTTP-Session: 587da230-ef1f-46aa-b141-a651c56c1ebb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 403 | 2024.10.09 22:38:49.531942 [ 3 ] {} <Debug> HTTP-Session: 587da230-ef1f-46aa-b141-a651c56c1ebb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 404 | 2024.10.09 22:38:49.532001 [ 3 ] {} <Trace> HTTP-Session: 587da230-ef1f-46aa-b141-a651c56c1ebb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 405 | 2024.10.09 22:38:49.532399 [ 3 ] {3a0c00c7-7f52-4603-970c-31faacfa5aec} <Debug> executeQuery: (from [::1]:63207) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 406 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 407 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 408 | * a string isn't palatable for a few reasons. | ||
| 409 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 410 | * details. | ||
| 411 | */ | ||
| 412 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 413 | 2024.10.09 22:38:49.532487 [ 3 ] {3a0c00c7-7f52-4603-970c-31faacfa5aec} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 414 | 2024.10.09 22:38:49.534989 [ 3 ] {3a0c00c7-7f52-4603-970c-31faacfa5aec} <Debug> oximeter.measurements_bytes (275bbafa-6c63-463d-a984-6dd9ed1a3bf8): Loading data parts | ||
| 415 | 2024.10.09 22:38:49.535338 [ 3 ] {3a0c00c7-7f52-4603-970c-31faacfa5aec} <Debug> oximeter.measurements_bytes (275bbafa-6c63-463d-a984-6dd9ed1a3bf8): There are no data parts | ||
| 416 | 2024.10.09 22:38:49.537214 [ 3 ] {3a0c00c7-7f52-4603-970c-31faacfa5aec} <Debug> DynamicQueryHandler: Done processing query | ||
| 417 | 2024.10.09 22:38:49.537243 [ 3 ] {} <Debug> HTTP-Session: 587da230-ef1f-46aa-b141-a651c56c1ebb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 418 | 2024.10.09 22:38:49.541825 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 419 | 2024.10.09 22:38:49.541948 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 420 | 2024.10.09 22:38:49.541974 [ 3 ] {} <Debug> HTTP-Session: be211320-1538-4c5d-92cc-102665643e77 Authenticating user 'default' from [::1]:63207 | ||
| 421 | 2024.10.09 22:38:49.542003 [ 3 ] {} <Debug> HTTP-Session: be211320-1538-4c5d-92cc-102665643e77 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 422 | 2024.10.09 22:38:49.542019 [ 3 ] {} <Debug> HTTP-Session: be211320-1538-4c5d-92cc-102665643e77 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 423 | 2024.10.09 22:38:49.542083 [ 3 ] {} <Trace> HTTP-Session: be211320-1538-4c5d-92cc-102665643e77 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 424 | 2024.10.09 22:38:49.542519 [ 3 ] {ab23517a-898d-4930-9ef9-41dce1ccbb6f} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 425 | 2024.10.09 22:38:49.542609 [ 3 ] {ab23517a-898d-4930-9ef9-41dce1ccbb6f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 426 | 2024.10.09 22:38:49.545600 [ 3 ] {ab23517a-898d-4930-9ef9-41dce1ccbb6f} <Debug> oximeter.measurements_cumulativei64 (1aefdeee-c6a2-4753-aadb-17d454708b4b): Loading data parts | ||
| 427 | 2024.10.09 22:38:49.545993 [ 3 ] {ab23517a-898d-4930-9ef9-41dce1ccbb6f} <Debug> oximeter.measurements_cumulativei64 (1aefdeee-c6a2-4753-aadb-17d454708b4b): There are no data parts | ||
| 428 | 2024.10.09 22:38:49.547836 [ 3 ] {ab23517a-898d-4930-9ef9-41dce1ccbb6f} <Debug> DynamicQueryHandler: Done processing query | ||
| 429 | 2024.10.09 22:38:49.547867 [ 3 ] {} <Debug> HTTP-Session: be211320-1538-4c5d-92cc-102665643e77 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 430 | 2024.10.09 22:38:49.562036 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 431 | 2024.10.09 22:38:49.562213 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 432 | 2024.10.09 22:38:49.562248 [ 3 ] {} <Debug> HTTP-Session: d73bd52e-cab4-4ca6-8da6-96a243aecbc2 Authenticating user 'default' from [::1]:63207 | ||
| 433 | 2024.10.09 22:38:49.562300 [ 3 ] {} <Debug> HTTP-Session: d73bd52e-cab4-4ca6-8da6-96a243aecbc2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 434 | 2024.10.09 22:38:49.562316 [ 3 ] {} <Debug> HTTP-Session: d73bd52e-cab4-4ca6-8da6-96a243aecbc2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 435 | 2024.10.09 22:38:49.562377 [ 3 ] {} <Trace> HTTP-Session: d73bd52e-cab4-4ca6-8da6-96a243aecbc2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 436 | 2024.10.09 22:38:49.562811 [ 3 ] {62d604a4-2c99-41ee-a43e-b14c547d6c05} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 437 | 2024.10.09 22:38:49.562904 [ 3 ] {62d604a4-2c99-41ee-a43e-b14c547d6c05} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 438 | 2024.10.09 22:38:49.565637 [ 3 ] {62d604a4-2c99-41ee-a43e-b14c547d6c05} <Debug> oximeter.measurements_cumulativeu64 (60eb969c-461a-49fb-9fb7-3330226b4fad): Loading data parts | ||
| 439 | 2024.10.09 22:38:49.565966 [ 3 ] {62d604a4-2c99-41ee-a43e-b14c547d6c05} <Debug> oximeter.measurements_cumulativeu64 (60eb969c-461a-49fb-9fb7-3330226b4fad): There are no data parts | ||
| 440 | 2024.10.09 22:38:49.567905 [ 3 ] {62d604a4-2c99-41ee-a43e-b14c547d6c05} <Debug> DynamicQueryHandler: Done processing query | ||
| 441 | 2024.10.09 22:38:49.567937 [ 3 ] {} <Debug> HTTP-Session: d73bd52e-cab4-4ca6-8da6-96a243aecbc2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 442 | 2024.10.09 22:38:49.574068 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 443 | 2024.10.09 22:38:49.576350 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 444 | 2024.10.09 22:38:49.576400 [ 3 ] {} <Debug> HTTP-Session: d852d5f0-c180-4318-952b-975ba8b430eb Authenticating user 'default' from [::1]:63207 | ||
| 445 | 2024.10.09 22:38:49.576431 [ 3 ] {} <Debug> HTTP-Session: d852d5f0-c180-4318-952b-975ba8b430eb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 446 | 2024.10.09 22:38:49.576464 [ 3 ] {} <Debug> HTTP-Session: d852d5f0-c180-4318-952b-975ba8b430eb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 447 | 2024.10.09 22:38:49.576538 [ 3 ] {} <Trace> HTTP-Session: d852d5f0-c180-4318-952b-975ba8b430eb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 448 | 2024.10.09 22:38:49.577013 [ 3 ] {48ef3643-3832-4010-8cd2-1b5c6eaaf399} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 449 | 2024.10.09 22:38:49.577115 [ 3 ] {48ef3643-3832-4010-8cd2-1b5c6eaaf399} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 450 | 2024.10.09 22:38:49.579844 [ 3 ] {48ef3643-3832-4010-8cd2-1b5c6eaaf399} <Debug> oximeter.measurements_cumulativef32 (8e381efa-db0d-41c2-a953-bc7a986a5099): Loading data parts | ||
| 451 | 2024.10.09 22:38:49.580172 [ 3 ] {48ef3643-3832-4010-8cd2-1b5c6eaaf399} <Debug> oximeter.measurements_cumulativef32 (8e381efa-db0d-41c2-a953-bc7a986a5099): There are no data parts | ||
| 452 | 2024.10.09 22:38:49.582045 [ 3 ] {48ef3643-3832-4010-8cd2-1b5c6eaaf399} <Debug> DynamicQueryHandler: Done processing query | ||
| 453 | 2024.10.09 22:38:49.582089 [ 3 ] {} <Debug> HTTP-Session: d852d5f0-c180-4318-952b-975ba8b430eb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 454 | 2024.10.09 22:38:49.806750 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 455 | 2024.10.09 22:38:49.806879 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 456 | 2024.10.09 22:38:49.806927 [ 3 ] {} <Debug> HTTP-Session: 69771f3a-6646-4a7b-9c65-942d3902724f Authenticating user 'default' from [::1]:63207 | ||
| 457 | 2024.10.09 22:38:49.806960 [ 3 ] {} <Debug> HTTP-Session: 69771f3a-6646-4a7b-9c65-942d3902724f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 458 | 2024.10.09 22:38:49.806977 [ 3 ] {} <Debug> HTTP-Session: 69771f3a-6646-4a7b-9c65-942d3902724f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 459 | 2024.10.09 22:38:49.807051 [ 3 ] {} <Trace> HTTP-Session: 69771f3a-6646-4a7b-9c65-942d3902724f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 460 | 2024.10.09 22:38:49.807464 [ 3 ] {bc7fdf80-0ad7-45be-8693-a558b25997df} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 461 | 2024.10.09 22:38:49.807558 [ 3 ] {bc7fdf80-0ad7-45be-8693-a558b25997df} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 462 | 2024.10.09 22:38:49.810047 [ 3 ] {bc7fdf80-0ad7-45be-8693-a558b25997df} <Debug> oximeter.measurements_cumulativef64 (23e06653-68f1-4585-9c6b-b8b051cf4293): Loading data parts | ||
| 463 | 2024.10.09 22:38:49.810378 [ 3 ] {bc7fdf80-0ad7-45be-8693-a558b25997df} <Debug> oximeter.measurements_cumulativef64 (23e06653-68f1-4585-9c6b-b8b051cf4293): There are no data parts | ||
| 464 | 2024.10.09 22:38:49.811982 [ 3 ] {bc7fdf80-0ad7-45be-8693-a558b25997df} <Debug> DynamicQueryHandler: Done processing query | ||
| 465 | 2024.10.09 22:38:49.812012 [ 3 ] {} <Debug> HTTP-Session: 69771f3a-6646-4a7b-9c65-942d3902724f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 466 | 2024.10.09 22:38:49.911829 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 467 | 2024.10.09 22:38:49.911981 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 468 | 2024.10.09 22:38:49.912011 [ 3 ] {} <Debug> HTTP-Session: 0b825ed1-5578-43bf-8505-533fe82a2fc3 Authenticating user 'default' from [::1]:63207 | ||
| 469 | 2024.10.09 22:38:49.912039 [ 3 ] {} <Debug> HTTP-Session: 0b825ed1-5578-43bf-8505-533fe82a2fc3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 470 | 2024.10.09 22:38:49.912065 [ 3 ] {} <Debug> HTTP-Session: 0b825ed1-5578-43bf-8505-533fe82a2fc3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 471 | 2024.10.09 22:38:49.912126 [ 3 ] {} <Trace> HTTP-Session: 0b825ed1-5578-43bf-8505-533fe82a2fc3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 472 | 2024.10.09 22:38:49.912695 [ 3 ] {d33c781f-68aa-4a5e-9083-86f1befdabd1} <Debug> executeQuery: (from [::1]:63207) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 473 | * NOTE: Array types cannot be Nullable, see | ||
| 474 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 475 | * for more details. | ||
| 476 | * | ||
| 477 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 478 | * is unfortunate, and at this point relies on the fact that an | ||
| 479 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 480 | * to figure out another way to represent missing samples here. | ||
| 481 | */ | ||
| 482 | 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) | ||
| 483 | 2024.10.09 22:38:49.912805 [ 3 ] {d33c781f-68aa-4a5e-9083-86f1befdabd1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 484 | 2024.10.09 22:38:49.915938 [ 3 ] {d33c781f-68aa-4a5e-9083-86f1befdabd1} <Debug> oximeter.measurements_histogrami8 (52bf1e84-f421-46e1-bac4-47017eb74cf3): Loading data parts | ||
| 485 | 2024.10.09 22:38:49.916308 [ 3 ] {d33c781f-68aa-4a5e-9083-86f1befdabd1} <Debug> oximeter.measurements_histogrami8 (52bf1e84-f421-46e1-bac4-47017eb74cf3): There are no data parts | ||
| 486 | 2024.10.09 22:38:49.918440 [ 3 ] {d33c781f-68aa-4a5e-9083-86f1befdabd1} <Debug> DynamicQueryHandler: Done processing query | ||
| 487 | 2024.10.09 22:38:49.918474 [ 3 ] {} <Debug> HTTP-Session: 0b825ed1-5578-43bf-8505-533fe82a2fc3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 488 | 2024.10.09 22:38:49.921946 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 489 | 2024.10.09 22:38:49.922051 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 490 | 2024.10.09 22:38:49.922083 [ 3 ] {} <Debug> HTTP-Session: 23cc8b42-24e5-4d4e-9dd8-04c2c5437b75 Authenticating user 'default' from [::1]:63207 | ||
| 491 | 2024.10.09 22:38:49.922129 [ 3 ] {} <Debug> HTTP-Session: 23cc8b42-24e5-4d4e-9dd8-04c2c5437b75 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 492 | 2024.10.09 22:38:49.922146 [ 3 ] {} <Debug> HTTP-Session: 23cc8b42-24e5-4d4e-9dd8-04c2c5437b75 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 493 | 2024.10.09 22:38:49.922204 [ 3 ] {} <Trace> HTTP-Session: 23cc8b42-24e5-4d4e-9dd8-04c2c5437b75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 494 | 2024.10.09 22:38:49.922717 [ 3 ] {5a48a4ad-b370-4f02-b4b0-9b8204068365} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 495 | 2024.10.09 22:38:49.922825 [ 3 ] {5a48a4ad-b370-4f02-b4b0-9b8204068365} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 496 | 2024.10.09 22:38:49.925973 [ 3 ] {5a48a4ad-b370-4f02-b4b0-9b8204068365} <Debug> oximeter.measurements_histogramu8 (6797c51c-9228-488a-94b8-d332827d2df9): Loading data parts | ||
| 497 | 2024.10.09 22:38:49.926376 [ 3 ] {5a48a4ad-b370-4f02-b4b0-9b8204068365} <Debug> oximeter.measurements_histogramu8 (6797c51c-9228-488a-94b8-d332827d2df9): There are no data parts | ||
| 498 | 2024.10.09 22:38:49.928359 [ 3 ] {5a48a4ad-b370-4f02-b4b0-9b8204068365} <Debug> DynamicQueryHandler: Done processing query | ||
| 499 | 2024.10.09 22:38:49.928391 [ 3 ] {} <Debug> HTTP-Session: 23cc8b42-24e5-4d4e-9dd8-04c2c5437b75 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 500 | 2024.10.09 22:38:49.959203 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 501 | 2024.10.09 22:38:49.959362 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 502 | 2024.10.09 22:38:49.959390 [ 3 ] {} <Debug> HTTP-Session: a63d02e4-eb25-4c77-8c36-8f2a398a9252 Authenticating user 'default' from [::1]:63207 | ||
| 503 | 2024.10.09 22:38:49.959416 [ 3 ] {} <Debug> HTTP-Session: a63d02e4-eb25-4c77-8c36-8f2a398a9252 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 504 | 2024.10.09 22:38:49.959440 [ 3 ] {} <Debug> HTTP-Session: a63d02e4-eb25-4c77-8c36-8f2a398a9252 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 505 | 2024.10.09 22:38:49.959497 [ 3 ] {} <Trace> HTTP-Session: a63d02e4-eb25-4c77-8c36-8f2a398a9252 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 506 | 2024.10.09 22:38:49.960039 [ 3 ] {b03e45fd-0ef7-40e8-8053-9908986d192d} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 507 | 2024.10.09 22:38:49.960141 [ 3 ] {b03e45fd-0ef7-40e8-8053-9908986d192d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 508 | 2024.10.09 22:38:49.963038 [ 3 ] {b03e45fd-0ef7-40e8-8053-9908986d192d} <Debug> oximeter.measurements_histogrami16 (c882a04a-1bf1-45ad-88f9-dd021d3b6433): Loading data parts | ||
| 509 | 2024.10.09 22:38:49.963386 [ 3 ] {b03e45fd-0ef7-40e8-8053-9908986d192d} <Debug> oximeter.measurements_histogrami16 (c882a04a-1bf1-45ad-88f9-dd021d3b6433): There are no data parts | ||
| 510 | 2024.10.09 22:38:49.965421 [ 3 ] {b03e45fd-0ef7-40e8-8053-9908986d192d} <Debug> DynamicQueryHandler: Done processing query | ||
| 511 | 2024.10.09 22:38:49.965455 [ 3 ] {} <Debug> HTTP-Session: a63d02e4-eb25-4c77-8c36-8f2a398a9252 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 512 | 2024.10.09 22:38:49.966375 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 513 | 2024.10.09 22:38:49.966459 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 514 | 2024.10.09 22:38:49.966487 [ 3 ] {} <Debug> HTTP-Session: ac5fc2d9-4f85-43bc-8cd4-0ce4cad2719f Authenticating user 'default' from [::1]:63207 | ||
| 515 | 2024.10.09 22:38:49.966528 [ 3 ] {} <Debug> HTTP-Session: ac5fc2d9-4f85-43bc-8cd4-0ce4cad2719f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 516 | 2024.10.09 22:38:49.966548 [ 3 ] {} <Debug> HTTP-Session: ac5fc2d9-4f85-43bc-8cd4-0ce4cad2719f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 517 | 2024.10.09 22:38:49.966599 [ 3 ] {} <Trace> HTTP-Session: ac5fc2d9-4f85-43bc-8cd4-0ce4cad2719f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 518 | 2024.10.09 22:38:49.967280 [ 3 ] {9a2d5784-ab56-4c94-b462-2394b652fef9} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 519 | 2024.10.09 22:38:49.967394 [ 3 ] {9a2d5784-ab56-4c94-b462-2394b652fef9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 520 | 2024.10.09 22:38:49.972380 [ 3 ] {9a2d5784-ab56-4c94-b462-2394b652fef9} <Debug> oximeter.measurements_histogramu16 (7fbdeca2-0b23-4509-9327-f83a6c3fc938): Loading data parts | ||
| 521 | 2024.10.09 22:38:49.972740 [ 3 ] {9a2d5784-ab56-4c94-b462-2394b652fef9} <Debug> oximeter.measurements_histogramu16 (7fbdeca2-0b23-4509-9327-f83a6c3fc938): There are no data parts | ||
| 522 | 2024.10.09 22:38:49.974657 [ 3 ] {9a2d5784-ab56-4c94-b462-2394b652fef9} <Debug> DynamicQueryHandler: Done processing query | ||
| 523 | 2024.10.09 22:38:49.974712 [ 3 ] {} <Debug> HTTP-Session: ac5fc2d9-4f85-43bc-8cd4-0ce4cad2719f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 524 | 2024.10.09 22:38:49.980932 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 525 | 2024.10.09 22:38:49.981089 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 526 | 2024.10.09 22:38:49.981149 [ 3 ] {} <Debug> HTTP-Session: 210dcce0-0b97-4bdb-ae7d-eea70c732523 Authenticating user 'default' from [::1]:63207 | ||
| 527 | 2024.10.09 22:38:49.981184 [ 3 ] {} <Debug> HTTP-Session: 210dcce0-0b97-4bdb-ae7d-eea70c732523 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 528 | 2024.10.09 22:38:49.981202 [ 3 ] {} <Debug> HTTP-Session: 210dcce0-0b97-4bdb-ae7d-eea70c732523 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 529 | 2024.10.09 22:38:49.981276 [ 3 ] {} <Trace> HTTP-Session: 210dcce0-0b97-4bdb-ae7d-eea70c732523 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 530 | 2024.10.09 22:38:49.981827 [ 3 ] {0cab2bab-6519-4c2a-b29c-30f958b97a68} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 531 | 2024.10.09 22:38:49.981936 [ 3 ] {0cab2bab-6519-4c2a-b29c-30f958b97a68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 532 | 2024.10.09 22:38:49.985075 [ 3 ] {0cab2bab-6519-4c2a-b29c-30f958b97a68} <Debug> oximeter.measurements_histogrami32 (732e07cb-b380-4ca4-9e34-f77222151082): Loading data parts | ||
| 533 | 2024.10.09 22:38:49.985461 [ 3 ] {0cab2bab-6519-4c2a-b29c-30f958b97a68} <Debug> oximeter.measurements_histogrami32 (732e07cb-b380-4ca4-9e34-f77222151082): There are no data parts | ||
| 534 | 2024.10.09 22:38:49.987369 [ 3 ] {0cab2bab-6519-4c2a-b29c-30f958b97a68} <Debug> DynamicQueryHandler: Done processing query | ||
| 535 | 2024.10.09 22:38:49.987409 [ 3 ] {} <Debug> HTTP-Session: 210dcce0-0b97-4bdb-ae7d-eea70c732523 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 536 | 2024.10.09 22:38:50.001018 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 181.13 MiB, peak 182.15 MiB, free memory in arenas 0.00 B, will set to 186.03 MiB (RSS), difference: 4.90 MiB | ||
| 537 | 2024.10.09 22:38:50.012049 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 538 | 2024.10.09 22:38:50.012234 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 539 | 2024.10.09 22:38:50.012292 [ 3 ] {} <Debug> HTTP-Session: e8b29430-4521-4740-8006-b61ad3e8ef37 Authenticating user 'default' from [::1]:63207 | ||
| 540 | 2024.10.09 22:38:50.012323 [ 3 ] {} <Debug> HTTP-Session: e8b29430-4521-4740-8006-b61ad3e8ef37 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 541 | 2024.10.09 22:38:50.012338 [ 3 ] {} <Debug> HTTP-Session: e8b29430-4521-4740-8006-b61ad3e8ef37 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 542 | 2024.10.09 22:38:50.012414 [ 3 ] {} <Trace> HTTP-Session: e8b29430-4521-4740-8006-b61ad3e8ef37 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 543 | 2024.10.09 22:38:50.012975 [ 3 ] {289537ef-6386-488d-adc9-610f6aa707f4} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 544 | 2024.10.09 22:38:50.013136 [ 3 ] {289537ef-6386-488d-adc9-610f6aa707f4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 545 | 2024.10.09 22:38:50.016386 [ 3 ] {289537ef-6386-488d-adc9-610f6aa707f4} <Debug> oximeter.measurements_histogramu32 (4b8808a5-c04f-444e-8609-69d6d2084776): Loading data parts | ||
| 546 | 2024.10.09 22:38:50.016784 [ 3 ] {289537ef-6386-488d-adc9-610f6aa707f4} <Debug> oximeter.measurements_histogramu32 (4b8808a5-c04f-444e-8609-69d6d2084776): There are no data parts | ||
| 547 | 2024.10.09 22:38:50.018899 [ 3 ] {289537ef-6386-488d-adc9-610f6aa707f4} <Debug> DynamicQueryHandler: Done processing query | ||
| 548 | 2024.10.09 22:38:50.018930 [ 3 ] {} <Debug> HTTP-Session: e8b29430-4521-4740-8006-b61ad3e8ef37 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 549 | 2024.10.09 22:38:50.022522 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 550 | 2024.10.09 22:38:50.022641 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 551 | 2024.10.09 22:38:50.022672 [ 3 ] {} <Debug> HTTP-Session: ddf3db7e-5438-4d61-aa42-28c5ed5b86af Authenticating user 'default' from [::1]:63207 | ||
| 552 | 2024.10.09 22:38:50.022747 [ 3 ] {} <Debug> HTTP-Session: ddf3db7e-5438-4d61-aa42-28c5ed5b86af Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 553 | 2024.10.09 22:38:50.022785 [ 3 ] {} <Debug> HTTP-Session: ddf3db7e-5438-4d61-aa42-28c5ed5b86af Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 554 | 2024.10.09 22:38:50.022843 [ 3 ] {} <Trace> HTTP-Session: ddf3db7e-5438-4d61-aa42-28c5ed5b86af Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 555 | 2024.10.09 22:38:50.023337 [ 3 ] {835b36f9-11ac-4f66-9d86-b2ca19335601} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 556 | 2024.10.09 22:38:50.023437 [ 3 ] {835b36f9-11ac-4f66-9d86-b2ca19335601} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 557 | 2024.10.09 22:38:50.028040 [ 3 ] {835b36f9-11ac-4f66-9d86-b2ca19335601} <Debug> oximeter.measurements_histogrami64 (0ecf8c6c-cede-47f0-9107-dcb76ecd98d3): Loading data parts | ||
| 558 | 2024.10.09 22:38:50.028430 [ 3 ] {835b36f9-11ac-4f66-9d86-b2ca19335601} <Debug> oximeter.measurements_histogrami64 (0ecf8c6c-cede-47f0-9107-dcb76ecd98d3): There are no data parts | ||
| 559 | 2024.10.09 22:38:50.030417 [ 3 ] {835b36f9-11ac-4f66-9d86-b2ca19335601} <Debug> DynamicQueryHandler: Done processing query | ||
| 560 | 2024.10.09 22:38:50.030447 [ 3 ] {} <Debug> HTTP-Session: ddf3db7e-5438-4d61-aa42-28c5ed5b86af Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 561 | 2024.10.09 22:38:50.055431 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 562 | 2024.10.09 22:38:50.055567 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 563 | 2024.10.09 22:38:50.055604 [ 3 ] {} <Debug> HTTP-Session: 83c1e1e6-e585-4910-8677-d000baed9f8a Authenticating user 'default' from [::1]:63207 | ||
| 564 | 2024.10.09 22:38:50.055657 [ 3 ] {} <Debug> HTTP-Session: 83c1e1e6-e585-4910-8677-d000baed9f8a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 565 | 2024.10.09 22:38:50.055674 [ 3 ] {} <Debug> HTTP-Session: 83c1e1e6-e585-4910-8677-d000baed9f8a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 566 | 2024.10.09 22:38:50.055733 [ 3 ] {} <Trace> HTTP-Session: 83c1e1e6-e585-4910-8677-d000baed9f8a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 567 | 2024.10.09 22:38:50.056267 [ 3 ] {53abd07b-2a8b-4640-abae-b3887932fa9b} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 568 | 2024.10.09 22:38:50.056371 [ 3 ] {53abd07b-2a8b-4640-abae-b3887932fa9b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 569 | 2024.10.09 22:38:50.059583 [ 3 ] {53abd07b-2a8b-4640-abae-b3887932fa9b} <Debug> oximeter.measurements_histogramu64 (06a9baad-e3e7-47be-ac4e-fe9f17d1ba9d): Loading data parts | ||
| 570 | 2024.10.09 22:38:50.059916 [ 3 ] {53abd07b-2a8b-4640-abae-b3887932fa9b} <Debug> oximeter.measurements_histogramu64 (06a9baad-e3e7-47be-ac4e-fe9f17d1ba9d): There are no data parts | ||
| 571 | 2024.10.09 22:38:50.061726 [ 3 ] {53abd07b-2a8b-4640-abae-b3887932fa9b} <Debug> DynamicQueryHandler: Done processing query | ||
| 572 | 2024.10.09 22:38:50.061755 [ 3 ] {} <Debug> HTTP-Session: 83c1e1e6-e585-4910-8677-d000baed9f8a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 573 | 2024.10.09 22:38:50.067483 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 574 | 2024.10.09 22:38:50.067643 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 575 | 2024.10.09 22:38:50.067676 [ 3 ] {} <Debug> HTTP-Session: 9b208e23-787b-43e5-80e5-7677ab762358 Authenticating user 'default' from [::1]:63207 | ||
| 576 | 2024.10.09 22:38:50.067705 [ 3 ] {} <Debug> HTTP-Session: 9b208e23-787b-43e5-80e5-7677ab762358 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 577 | 2024.10.09 22:38:50.067721 [ 3 ] {} <Debug> HTTP-Session: 9b208e23-787b-43e5-80e5-7677ab762358 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 578 | 2024.10.09 22:38:50.067789 [ 3 ] {} <Trace> HTTP-Session: 9b208e23-787b-43e5-80e5-7677ab762358 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 579 | 2024.10.09 22:38:50.068283 [ 3 ] {5ab37439-8447-4fe6-81bd-9408f2b5366f} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 580 | 2024.10.09 22:38:50.068441 [ 3 ] {5ab37439-8447-4fe6-81bd-9408f2b5366f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 581 | 2024.10.09 22:38:50.071860 [ 3 ] {5ab37439-8447-4fe6-81bd-9408f2b5366f} <Debug> oximeter.measurements_histogramf32 (94e49bc4-14d2-448d-b67f-91baa7e4d725): Loading data parts | ||
| 582 | 2024.10.09 22:38:50.072229 [ 3 ] {5ab37439-8447-4fe6-81bd-9408f2b5366f} <Debug> oximeter.measurements_histogramf32 (94e49bc4-14d2-448d-b67f-91baa7e4d725): There are no data parts | ||
| 583 | 2024.10.09 22:38:50.074327 [ 3 ] {5ab37439-8447-4fe6-81bd-9408f2b5366f} <Debug> DynamicQueryHandler: Done processing query | ||
| 584 | 2024.10.09 22:38:50.074358 [ 3 ] {} <Debug> HTTP-Session: 9b208e23-787b-43e5-80e5-7677ab762358 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 585 | 2024.10.09 22:38:50.077958 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 586 | 2024.10.09 22:38:50.078060 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 587 | 2024.10.09 22:38:50.078090 [ 3 ] {} <Debug> HTTP-Session: b2d8c1e2-fd3b-420b-bc63-0a850d338caa Authenticating user 'default' from [::1]:63207 | ||
| 588 | 2024.10.09 22:38:50.078136 [ 3 ] {} <Debug> HTTP-Session: b2d8c1e2-fd3b-420b-bc63-0a850d338caa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 589 | 2024.10.09 22:38:50.078156 [ 3 ] {} <Debug> HTTP-Session: b2d8c1e2-fd3b-420b-bc63-0a850d338caa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 590 | 2024.10.09 22:38:50.078214 [ 3 ] {} <Trace> HTTP-Session: b2d8c1e2-fd3b-420b-bc63-0a850d338caa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 591 | 2024.10.09 22:38:50.078797 [ 3 ] {4f9e2aaf-50b1-4529-b188-080f7451c67a} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 592 | 2024.10.09 22:38:50.078900 [ 3 ] {4f9e2aaf-50b1-4529-b188-080f7451c67a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 593 | 2024.10.09 22:38:50.082189 [ 3 ] {4f9e2aaf-50b1-4529-b188-080f7451c67a} <Debug> oximeter.measurements_histogramf64 (799ff2a0-3d6a-456f-80ec-921be60729c4): Loading data parts | ||
| 594 | 2024.10.09 22:38:50.082562 [ 3 ] {4f9e2aaf-50b1-4529-b188-080f7451c67a} <Debug> oximeter.measurements_histogramf64 (799ff2a0-3d6a-456f-80ec-921be60729c4): There are no data parts | ||
| 595 | 2024.10.09 22:38:50.084556 [ 3 ] {4f9e2aaf-50b1-4529-b188-080f7451c67a} <Debug> DynamicQueryHandler: Done processing query | ||
| 596 | 2024.10.09 22:38:50.084637 [ 3 ] {} <Debug> HTTP-Session: b2d8c1e2-fd3b-420b-bc63-0a850d338caa Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 597 | 2024.10.09 22:38:50.086460 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 598 | 2024.10.09 22:38:50.086546 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 599 | 2024.10.09 22:38:50.086588 [ 3 ] {} <Debug> HTTP-Session: 3d15d9ac-41b6-4d72-a5a8-d14ddc1887d0 Authenticating user 'default' from [::1]:63207 | ||
| 600 | 2024.10.09 22:38:50.086613 [ 3 ] {} <Debug> HTTP-Session: 3d15d9ac-41b6-4d72-a5a8-d14ddc1887d0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 601 | 2024.10.09 22:38:50.086628 [ 3 ] {} <Debug> HTTP-Session: 3d15d9ac-41b6-4d72-a5a8-d14ddc1887d0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 602 | 2024.10.09 22:38:50.087347 [ 3 ] {} <Trace> HTTP-Session: 3d15d9ac-41b6-4d72-a5a8-d14ddc1887d0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 603 | 2024.10.09 22:38:50.087739 [ 3 ] {2b98fed4-1b40-4355-8c2e-c54888ecb578} <Debug> executeQuery: (from [::1]:63207) /* The field tables store named dimensions of each timeseries. | ||
| 604 | * | ||
| 605 | * As with the measurement tables, there is one field table for each field data | ||
| 606 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 607 | * this behavior **must not** be relied upon for query correctness. | ||
| 608 | * | ||
| 609 | * The index for the fields differs from the measurements, however. Rows are | ||
| 610 | * sorted by timeseries name, then field name, field value, and finally | ||
| 611 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 612 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 613 | * usually then used to look up measurements. | ||
| 614 | * | ||
| 615 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 616 | * timeseries name and then key, since it would improve lookups where one | ||
| 617 | * already has the key. Realistically though, these tables are quite small and | ||
| 618 | * so performance benefits will be low in absolute terms. | ||
| 619 | * | ||
| 620 | * TTL: We use a materialized column to expire old field table records. This | ||
| 621 | * column is generated automatically by the database whenever a new row is | ||
| 622 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 623 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 624 | * record will remain during a deduplication, which will have the last | ||
| 625 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 626 | * measurement tables. | ||
| 627 | */ | ||
| 628 | 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) | ||
| 629 | 2024.10.09 22:38:50.087835 [ 3 ] {2b98fed4-1b40-4355-8c2e-c54888ecb578} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 630 | 2024.10.09 22:38:50.091621 [ 3 ] {2b98fed4-1b40-4355-8c2e-c54888ecb578} <Debug> oximeter.fields_bool (53e0edad-ffd0-4a40-bd06-4427aa3fc76c): Loading data parts | ||
| 631 | 2024.10.09 22:38:50.091984 [ 3 ] {2b98fed4-1b40-4355-8c2e-c54888ecb578} <Debug> oximeter.fields_bool (53e0edad-ffd0-4a40-bd06-4427aa3fc76c): There are no data parts | ||
| 632 | 2024.10.09 22:38:50.093970 [ 3 ] {2b98fed4-1b40-4355-8c2e-c54888ecb578} <Debug> DynamicQueryHandler: Done processing query | ||
| 633 | 2024.10.09 22:38:50.094006 [ 3 ] {} <Debug> HTTP-Session: 3d15d9ac-41b6-4d72-a5a8-d14ddc1887d0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 634 | 2024.10.09 22:38:50.106929 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 635 | 2024.10.09 22:38:50.107089 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 636 | 2024.10.09 22:38:50.107122 [ 3 ] {} <Debug> HTTP-Session: 3d2ce47d-9b30-4066-ab91-96e73f47cf5d Authenticating user 'default' from [::1]:63207 | ||
| 637 | 2024.10.09 22:38:50.107310 [ 3 ] {} <Debug> HTTP-Session: 3d2ce47d-9b30-4066-ab91-96e73f47cf5d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 638 | 2024.10.09 22:38:50.107352 [ 3 ] {} <Debug> HTTP-Session: 3d2ce47d-9b30-4066-ab91-96e73f47cf5d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 639 | 2024.10.09 22:38:50.107415 [ 3 ] {} <Trace> HTTP-Session: 3d2ce47d-9b30-4066-ab91-96e73f47cf5d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 640 | 2024.10.09 22:38:50.107884 [ 3 ] {b93d098d-36a9-458c-9bee-8c6d9f14ba83} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 641 | 2024.10.09 22:38:50.108064 [ 3 ] {b93d098d-36a9-458c-9bee-8c6d9f14ba83} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 642 | 2024.10.09 22:38:50.110986 [ 3 ] {b93d098d-36a9-458c-9bee-8c6d9f14ba83} <Debug> oximeter.fields_i8 (5f5ca2ac-08b2-4825-b9a8-97ea650b1fc4): Loading data parts | ||
| 643 | 2024.10.09 22:38:50.111336 [ 3 ] {b93d098d-36a9-458c-9bee-8c6d9f14ba83} <Debug> oximeter.fields_i8 (5f5ca2ac-08b2-4825-b9a8-97ea650b1fc4): There are no data parts | ||
| 644 | 2024.10.09 22:38:50.113863 [ 3 ] {b93d098d-36a9-458c-9bee-8c6d9f14ba83} <Debug> DynamicQueryHandler: Done processing query | ||
| 645 | 2024.10.09 22:38:50.113906 [ 3 ] {} <Debug> HTTP-Session: 3d2ce47d-9b30-4066-ab91-96e73f47cf5d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 646 | 2024.10.09 22:38:50.115190 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 647 | 2024.10.09 22:38:50.115281 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 648 | 2024.10.09 22:38:50.115313 [ 3 ] {} <Debug> HTTP-Session: 019f78b2-4efa-4efa-b19a-d719200ac558 Authenticating user 'default' from [::1]:63207 | ||
| 649 | 2024.10.09 22:38:50.115363 [ 3 ] {} <Debug> HTTP-Session: 019f78b2-4efa-4efa-b19a-d719200ac558 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 650 | 2024.10.09 22:38:50.115383 [ 3 ] {} <Debug> HTTP-Session: 019f78b2-4efa-4efa-b19a-d719200ac558 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 651 | 2024.10.09 22:38:50.115474 [ 3 ] {} <Trace> HTTP-Session: 019f78b2-4efa-4efa-b19a-d719200ac558 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 652 | 2024.10.09 22:38:50.115924 [ 3 ] {9f8cf6f7-540a-451d-9428-1d47450cba3c} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 653 | 2024.10.09 22:38:50.116048 [ 3 ] {9f8cf6f7-540a-451d-9428-1d47450cba3c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 654 | 2024.10.09 22:38:50.118753 [ 3 ] {9f8cf6f7-540a-451d-9428-1d47450cba3c} <Debug> oximeter.fields_u8 (e63119ce-38ba-40b7-98ed-dc78ba9e453e): Loading data parts | ||
| 655 | 2024.10.09 22:38:50.119131 [ 3 ] {9f8cf6f7-540a-451d-9428-1d47450cba3c} <Debug> oximeter.fields_u8 (e63119ce-38ba-40b7-98ed-dc78ba9e453e): There are no data parts | ||
| 656 | 2024.10.09 22:38:50.121192 [ 3 ] {9f8cf6f7-540a-451d-9428-1d47450cba3c} <Debug> DynamicQueryHandler: Done processing query | ||
| 657 | 2024.10.09 22:38:50.121222 [ 3 ] {} <Debug> HTTP-Session: 019f78b2-4efa-4efa-b19a-d719200ac558 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 658 | 2024.10.09 22:38:50.123089 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 659 | 2024.10.09 22:38:50.123324 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 660 | 2024.10.09 22:38:50.123358 [ 3 ] {} <Debug> HTTP-Session: 9e98599e-39ea-4250-b066-64bc0b5ea9f5 Authenticating user 'default' from [::1]:63207 | ||
| 661 | 2024.10.09 22:38:50.123391 [ 3 ] {} <Debug> HTTP-Session: 9e98599e-39ea-4250-b066-64bc0b5ea9f5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 662 | 2024.10.09 22:38:50.123419 [ 3 ] {} <Debug> HTTP-Session: 9e98599e-39ea-4250-b066-64bc0b5ea9f5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 663 | 2024.10.09 22:38:50.123478 [ 3 ] {} <Trace> HTTP-Session: 9e98599e-39ea-4250-b066-64bc0b5ea9f5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 664 | 2024.10.09 22:38:50.123831 [ 3 ] {0c612852-18cf-4e4e-9228-c30b7a0ee80c} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 665 | 2024.10.09 22:38:50.123952 [ 3 ] {0c612852-18cf-4e4e-9228-c30b7a0ee80c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 666 | 2024.10.09 22:38:50.127242 [ 3 ] {0c612852-18cf-4e4e-9228-c30b7a0ee80c} <Debug> oximeter.fields_i16 (af13a067-02e1-4a8d-a395-8441d1670dca): Loading data parts | ||
| 667 | 2024.10.09 22:38:50.127617 [ 3 ] {0c612852-18cf-4e4e-9228-c30b7a0ee80c} <Debug> oximeter.fields_i16 (af13a067-02e1-4a8d-a395-8441d1670dca): There are no data parts | ||
| 668 | 2024.10.09 22:38:50.129578 [ 3 ] {0c612852-18cf-4e4e-9228-c30b7a0ee80c} <Debug> DynamicQueryHandler: Done processing query | ||
| 669 | 2024.10.09 22:38:50.129608 [ 3 ] {} <Debug> HTTP-Session: 9e98599e-39ea-4250-b066-64bc0b5ea9f5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 670 | 2024.10.09 22:38:50.130604 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 671 | 2024.10.09 22:38:50.130688 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 672 | 2024.10.09 22:38:50.130725 [ 3 ] {} <Debug> HTTP-Session: 3d617f5e-e204-4631-97da-c9ca045ec189 Authenticating user 'default' from [::1]:63207 | ||
| 673 | 2024.10.09 22:38:50.130770 [ 3 ] {} <Debug> HTTP-Session: 3d617f5e-e204-4631-97da-c9ca045ec189 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 674 | 2024.10.09 22:38:50.130797 [ 3 ] {} <Debug> HTTP-Session: 3d617f5e-e204-4631-97da-c9ca045ec189 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 675 | 2024.10.09 22:38:50.130861 [ 3 ] {} <Trace> HTTP-Session: 3d617f5e-e204-4631-97da-c9ca045ec189 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 676 | 2024.10.09 22:38:50.131812 [ 3 ] {fcef6906-51ce-451f-b140-eb7ad62caf0d} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 677 | 2024.10.09 22:38:50.132002 [ 3 ] {fcef6906-51ce-451f-b140-eb7ad62caf0d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 678 | 2024.10.09 22:38:50.134981 [ 3 ] {fcef6906-51ce-451f-b140-eb7ad62caf0d} <Debug> oximeter.fields_u16 (a3ad5224-f701-4b47-8a3c-516a105ecf9e): Loading data parts | ||
| 679 | 2024.10.09 22:38:50.135293 [ 3 ] {fcef6906-51ce-451f-b140-eb7ad62caf0d} <Debug> oximeter.fields_u16 (a3ad5224-f701-4b47-8a3c-516a105ecf9e): There are no data parts | ||
| 680 | 2024.10.09 22:38:50.137273 [ 3 ] {fcef6906-51ce-451f-b140-eb7ad62caf0d} <Debug> DynamicQueryHandler: Done processing query | ||
| 681 | 2024.10.09 22:38:50.137320 [ 3 ] {} <Debug> HTTP-Session: 3d617f5e-e204-4631-97da-c9ca045ec189 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 682 | 2024.10.09 22:38:50.138467 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 683 | 2024.10.09 22:38:50.138585 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 684 | 2024.10.09 22:38:50.138610 [ 3 ] {} <Debug> HTTP-Session: 60ae5be7-8d7a-46e0-af0f-7a8d706918b4 Authenticating user 'default' from [::1]:63207 | ||
| 685 | 2024.10.09 22:38:50.138643 [ 3 ] {} <Debug> HTTP-Session: 60ae5be7-8d7a-46e0-af0f-7a8d706918b4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 686 | 2024.10.09 22:38:50.138659 [ 3 ] {} <Debug> HTTP-Session: 60ae5be7-8d7a-46e0-af0f-7a8d706918b4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 687 | 2024.10.09 22:38:50.138726 [ 3 ] {} <Trace> HTTP-Session: 60ae5be7-8d7a-46e0-af0f-7a8d706918b4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 688 | 2024.10.09 22:38:50.139052 [ 3 ] {2cfb6b25-c6e6-483d-8e65-83cab5cd6ac3} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 689 | 2024.10.09 22:38:50.139137 [ 3 ] {2cfb6b25-c6e6-483d-8e65-83cab5cd6ac3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 690 | 2024.10.09 22:38:50.142011 [ 3 ] {2cfb6b25-c6e6-483d-8e65-83cab5cd6ac3} <Debug> oximeter.fields_i32 (5bc38449-773a-4ef3-8095-caddd722a5a0): Loading data parts | ||
| 691 | 2024.10.09 22:38:50.142418 [ 3 ] {2cfb6b25-c6e6-483d-8e65-83cab5cd6ac3} <Debug> oximeter.fields_i32 (5bc38449-773a-4ef3-8095-caddd722a5a0): There are no data parts | ||
| 692 | 2024.10.09 22:38:50.144248 [ 3 ] {2cfb6b25-c6e6-483d-8e65-83cab5cd6ac3} <Debug> DynamicQueryHandler: Done processing query | ||
| 693 | 2024.10.09 22:38:50.144279 [ 3 ] {} <Debug> HTTP-Session: 60ae5be7-8d7a-46e0-af0f-7a8d706918b4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 694 | 2024.10.09 22:38:50.145584 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 695 | 2024.10.09 22:38:50.145664 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 696 | 2024.10.09 22:38:50.145790 [ 3 ] {} <Debug> HTTP-Session: 43b2d2cb-0925-407b-8559-9c9aaa9e0b5b Authenticating user 'default' from [::1]:63207 | ||
| 697 | 2024.10.09 22:38:50.145846 [ 3 ] {} <Debug> HTTP-Session: 43b2d2cb-0925-407b-8559-9c9aaa9e0b5b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 698 | 2024.10.09 22:38:50.145863 [ 3 ] {} <Debug> HTTP-Session: 43b2d2cb-0925-407b-8559-9c9aaa9e0b5b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 699 | 2024.10.09 22:38:50.145913 [ 3 ] {} <Trace> HTTP-Session: 43b2d2cb-0925-407b-8559-9c9aaa9e0b5b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 700 | 2024.10.09 22:38:50.146301 [ 3 ] {f914b095-37d6-4d19-b4f9-1a9feb0cb92e} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 701 | 2024.10.09 22:38:50.146388 [ 3 ] {f914b095-37d6-4d19-b4f9-1a9feb0cb92e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 702 | 2024.10.09 22:38:50.149110 [ 3 ] {f914b095-37d6-4d19-b4f9-1a9feb0cb92e} <Debug> oximeter.fields_u32 (0902006f-5759-43f3-a38b-b7d11475669a): Loading data parts | ||
| 703 | 2024.10.09 22:38:50.149459 [ 3 ] {f914b095-37d6-4d19-b4f9-1a9feb0cb92e} <Debug> oximeter.fields_u32 (0902006f-5759-43f3-a38b-b7d11475669a): There are no data parts | ||
| 704 | 2024.10.09 22:38:50.151298 [ 3 ] {f914b095-37d6-4d19-b4f9-1a9feb0cb92e} <Debug> DynamicQueryHandler: Done processing query | ||
| 705 | 2024.10.09 22:38:50.151330 [ 3 ] {} <Debug> HTTP-Session: 43b2d2cb-0925-407b-8559-9c9aaa9e0b5b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 706 | 2024.10.09 22:38:50.152449 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 707 | 2024.10.09 22:38:50.152564 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 708 | 2024.10.09 22:38:50.152594 [ 3 ] {} <Debug> HTTP-Session: a4c3d959-6f41-48b0-ab2f-c5e5d85d34f2 Authenticating user 'default' from [::1]:63207 | ||
| 709 | 2024.10.09 22:38:50.152622 [ 3 ] {} <Debug> HTTP-Session: a4c3d959-6f41-48b0-ab2f-c5e5d85d34f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 710 | 2024.10.09 22:38:50.152641 [ 3 ] {} <Debug> HTTP-Session: a4c3d959-6f41-48b0-ab2f-c5e5d85d34f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 711 | 2024.10.09 22:38:50.152710 [ 3 ] {} <Trace> HTTP-Session: a4c3d959-6f41-48b0-ab2f-c5e5d85d34f2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 712 | 2024.10.09 22:38:50.153122 [ 3 ] {a0674dd3-eacd-4116-a1ee-fd0e4fdeb2b0} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 713 | 2024.10.09 22:38:50.153207 [ 3 ] {a0674dd3-eacd-4116-a1ee-fd0e4fdeb2b0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 714 | 2024.10.09 22:38:50.155982 [ 3 ] {a0674dd3-eacd-4116-a1ee-fd0e4fdeb2b0} <Debug> oximeter.fields_i64 (aa054f2b-2d31-4ec2-963e-8e880a0fc7dd): Loading data parts | ||
| 715 | 2024.10.09 22:38:50.156509 [ 3 ] {a0674dd3-eacd-4116-a1ee-fd0e4fdeb2b0} <Debug> oximeter.fields_i64 (aa054f2b-2d31-4ec2-963e-8e880a0fc7dd): There are no data parts | ||
| 716 | 2024.10.09 22:38:50.158328 [ 3 ] {a0674dd3-eacd-4116-a1ee-fd0e4fdeb2b0} <Debug> DynamicQueryHandler: Done processing query | ||
| 717 | 2024.10.09 22:38:50.158362 [ 3 ] {} <Debug> HTTP-Session: a4c3d959-6f41-48b0-ab2f-c5e5d85d34f2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 718 | 2024.10.09 22:38:50.159305 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 719 | 2024.10.09 22:38:50.159385 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 720 | 2024.10.09 22:38:50.159414 [ 3 ] {} <Debug> HTTP-Session: b23eba26-5157-46e1-9708-afdd6e36f3f3 Authenticating user 'default' from [::1]:63207 | ||
| 721 | 2024.10.09 22:38:50.159441 [ 3 ] {} <Debug> HTTP-Session: b23eba26-5157-46e1-9708-afdd6e36f3f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 722 | 2024.10.09 22:38:50.159459 [ 3 ] {} <Debug> HTTP-Session: b23eba26-5157-46e1-9708-afdd6e36f3f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 723 | 2024.10.09 22:38:50.159513 [ 3 ] {} <Trace> HTTP-Session: b23eba26-5157-46e1-9708-afdd6e36f3f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 724 | 2024.10.09 22:38:50.159835 [ 3 ] {b455ed02-6cd9-444a-b555-af4766c6a4f9} <Debug> executeQuery: (from [::1]:63207) 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) | ||
| 725 | 2024.10.09 22:38:50.159909 [ 3 ] {b455ed02-6cd9-444a-b555-af4766c6a4f9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 726 | 2024.10.09 22:38:50.162533 [ 3 ] {b455ed02-6cd9-444a-b555-af4766c6a4f9} <Debug> oximeter.fields_u64 (dc8d6f2d-8093-4992-a680-73a1d1f61fd7): Loading data parts | ||
| 727 | 2024.10.09 22:38:50.162863 [ 3 ] {b455ed02-6cd9-444a-b555-af4766c6a4f9} <Debug> oximeter.fields_u64 (dc8d6f2d-8093-4992-a680-73a1d1f61fd7): There are no data parts | ||
| 728 | 2024.10.09 22:38:50.164608 [ 3 ] {b455ed02-6cd9-444a-b555-af4766c6a4f9} <Debug> DynamicQueryHandler: Done processing query | ||
| 729 | 2024.10.09 22:38:50.164641 [ 3 ] {} <Debug> HTTP-Session: b23eba26-5157-46e1-9708-afdd6e36f3f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 730 | 2024.10.09 22:38:50.166415 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 731 | 2024.10.09 22:38:50.166507 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 732 | 2024.10.09 22:38:50.166540 [ 3 ] {} <Debug> HTTP-Session: c8820a16-a6f1-42f3-8ddc-ab38e4e70ca8 Authenticating user 'default' from [::1]:63207 | ||
| 733 | 2024.10.09 22:38:50.166566 [ 3 ] {} <Debug> HTTP-Session: c8820a16-a6f1-42f3-8ddc-ab38e4e70ca8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2024.10.09 22:38:50.166582 [ 3 ] {} <Debug> HTTP-Session: c8820a16-a6f1-42f3-8ddc-ab38e4e70ca8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 735 | 2024.10.09 22:38:50.166802 [ 3 ] {} <Trace> HTTP-Session: c8820a16-a6f1-42f3-8ddc-ab38e4e70ca8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 736 | 2024.10.09 22:38:50.167355 [ 3 ] {f07ab19c-acad-4ee8-a64e-8d430dac73cf} <Debug> executeQuery: (from [::1]:63207) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 737 | 2024.10.09 22:38:50.167434 [ 3 ] {f07ab19c-acad-4ee8-a64e-8d430dac73cf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 738 | 2024.10.09 22:38:50.172279 [ 3 ] {f07ab19c-acad-4ee8-a64e-8d430dac73cf} <Debug> oximeter.fields_ipaddr (af8afbac-7b85-434d-929e-a13a90c72618): Loading data parts | ||
| 739 | 2024.10.09 22:38:50.172584 [ 3 ] {f07ab19c-acad-4ee8-a64e-8d430dac73cf} <Debug> oximeter.fields_ipaddr (af8afbac-7b85-434d-929e-a13a90c72618): There are no data parts | ||
| 740 | 2024.10.09 22:38:50.179751 [ 3 ] {f07ab19c-acad-4ee8-a64e-8d430dac73cf} <Debug> DynamicQueryHandler: Done processing query | ||
| 741 | 2024.10.09 22:38:50.179793 [ 3 ] {} <Debug> HTTP-Session: c8820a16-a6f1-42f3-8ddc-ab38e4e70ca8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 742 | 2024.10.09 22:38:50.182231 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 743 | 2024.10.09 22:38:50.183620 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 744 | 2024.10.09 22:38:50.183660 [ 3 ] {} <Debug> HTTP-Session: e7ede0f9-01e7-4448-8071-470421022487 Authenticating user 'default' from [::1]:63207 | ||
| 745 | 2024.10.09 22:38:50.183689 [ 3 ] {} <Debug> HTTP-Session: e7ede0f9-01e7-4448-8071-470421022487 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 746 | 2024.10.09 22:38:50.183705 [ 3 ] {} <Debug> HTTP-Session: e7ede0f9-01e7-4448-8071-470421022487 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 747 | 2024.10.09 22:38:50.183765 [ 3 ] {} <Trace> HTTP-Session: e7ede0f9-01e7-4448-8071-470421022487 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 748 | 2024.10.09 22:38:50.184138 [ 3 ] {1de83b80-1b73-4d98-b149-885ca000f5c4} <Debug> executeQuery: (from [::1]:63207) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 749 | 2024.10.09 22:38:50.184215 [ 3 ] {1de83b80-1b73-4d98-b149-885ca000f5c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 750 | 2024.10.09 22:38:50.193453 [ 3 ] {1de83b80-1b73-4d98-b149-885ca000f5c4} <Debug> oximeter.fields_string (5a146f00-3259-489c-9459-fc112b8d9e10): Loading data parts | ||
| 751 | 2024.10.09 22:38:50.193885 [ 3 ] {1de83b80-1b73-4d98-b149-885ca000f5c4} <Debug> oximeter.fields_string (5a146f00-3259-489c-9459-fc112b8d9e10): There are no data parts | ||
| 752 | 2024.10.09 22:38:50.221210 [ 3 ] {1de83b80-1b73-4d98-b149-885ca000f5c4} <Debug> DynamicQueryHandler: Done processing query | ||
| 753 | 2024.10.09 22:38:50.221261 [ 3 ] {} <Debug> HTTP-Session: e7ede0f9-01e7-4448-8071-470421022487 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 754 | 2024.10.09 22:38:50.231531 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 755 | 2024.10.09 22:38:50.231670 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 756 | 2024.10.09 22:38:50.231705 [ 3 ] {} <Debug> HTTP-Session: 29158ec3-6d22-4648-9f4b-de2f98d79ece Authenticating user 'default' from [::1]:63207 | ||
| 757 | 2024.10.09 22:38:50.231734 [ 3 ] {} <Debug> HTTP-Session: 29158ec3-6d22-4648-9f4b-de2f98d79ece Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 758 | 2024.10.09 22:38:50.231751 [ 3 ] {} <Debug> HTTP-Session: 29158ec3-6d22-4648-9f4b-de2f98d79ece Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 759 | 2024.10.09 22:38:50.231813 [ 3 ] {} <Trace> HTTP-Session: 29158ec3-6d22-4648-9f4b-de2f98d79ece Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 760 | 2024.10.09 22:38:50.232283 [ 3 ] {bfa75999-cec8-417b-b74f-fb80ffea8460} <Debug> executeQuery: (from [::1]:63207) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 761 | 2024.10.09 22:38:50.232368 [ 3 ] {bfa75999-cec8-417b-b74f-fb80ffea8460} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 762 | 2024.10.09 22:38:50.235993 [ 3 ] {bfa75999-cec8-417b-b74f-fb80ffea8460} <Debug> oximeter.fields_uuid (047b05b6-e5c1-4564-921d-3938b1a887bc): Loading data parts | ||
| 763 | 2024.10.09 22:38:50.236326 [ 3 ] {bfa75999-cec8-417b-b74f-fb80ffea8460} <Debug> oximeter.fields_uuid (047b05b6-e5c1-4564-921d-3938b1a887bc): There are no data parts | ||
| 764 | 2024.10.09 22:38:50.238692 [ 3 ] {bfa75999-cec8-417b-b74f-fb80ffea8460} <Debug> DynamicQueryHandler: Done processing query | ||
| 765 | 2024.10.09 22:38:50.238722 [ 3 ] {} <Debug> HTTP-Session: 29158ec3-6d22-4648-9f4b-de2f98d79ece Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 766 | 2024.10.09 22:38:50.254667 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 767 | 2024.10.09 22:38:50.254798 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 768 | 2024.10.09 22:38:50.254918 [ 3 ] {} <Debug> HTTP-Session: a252c016-ff5a-4846-8981-a6271f0b7b1a Authenticating user 'default' from [::1]:63207 | ||
| 769 | 2024.10.09 22:38:50.254952 [ 3 ] {} <Debug> HTTP-Session: a252c016-ff5a-4846-8981-a6271f0b7b1a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 770 | 2024.10.09 22:38:50.254971 [ 3 ] {} <Debug> HTTP-Session: a252c016-ff5a-4846-8981-a6271f0b7b1a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 771 | 2024.10.09 22:38:50.255036 [ 3 ] {} <Trace> HTTP-Session: a252c016-ff5a-4846-8981-a6271f0b7b1a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 772 | 2024.10.09 22:38:50.255508 [ 3 ] {957dddc6-fa33-40b4-a04c-8444d72505db} <Debug> executeQuery: (from [::1]:63207) /* The timeseries schema table stores the extracted schema for the samples | ||
| 773 | * oximeter collects. | ||
| 774 | */ | ||
| 775 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
| 776 | 2024.10.09 22:38:50.255614 [ 3 ] {957dddc6-fa33-40b4-a04c-8444d72505db} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 777 | 2024.10.09 22:38:50.258544 [ 3 ] {957dddc6-fa33-40b4-a04c-8444d72505db} <Debug> oximeter.timeseries_schema (18a7aea2-e384-474d-88e5-d13b18eb5147): Loading data parts | ||
| 778 | 2024.10.09 22:38:50.258892 [ 3 ] {957dddc6-fa33-40b4-a04c-8444d72505db} <Debug> oximeter.timeseries_schema (18a7aea2-e384-474d-88e5-d13b18eb5147): There are no data parts | ||
| 779 | 2024.10.09 22:38:50.273063 [ 3 ] {957dddc6-fa33-40b4-a04c-8444d72505db} <Debug> DynamicQueryHandler: Done processing query | ||
| 780 | 2024.10.09 22:38:50.273111 [ 3 ] {} <Debug> HTTP-Session: a252c016-ff5a-4846-8981-a6271f0b7b1a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 781 | 2024.10.09 22:38:50.278305 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:63207, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 782 | 2024.10.09 22:38:50.278766 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 783 | 2024.10.09 22:38:50.278803 [ 3 ] {} <Debug> HTTP-Session: 44b0cf18-7777-4177-9dcc-20bfa7fd15bd Authenticating user 'default' from [::1]:63207 | ||
| 784 | 2024.10.09 22:38:50.278833 [ 3 ] {} <Debug> HTTP-Session: 44b0cf18-7777-4177-9dcc-20bfa7fd15bd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 785 | 2024.10.09 22:38:50.278849 [ 3 ] {} <Debug> HTTP-Session: 44b0cf18-7777-4177-9dcc-20bfa7fd15bd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 786 | 2024.10.09 22:38:50.278906 [ 3 ] {} <Trace> HTTP-Session: 44b0cf18-7777-4177-9dcc-20bfa7fd15bd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 787 | 2024.10.09 22:38:50.279195 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Debug> executeQuery: (from [::1]:63207) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 788 | 2024.10.09 22:38:50.279504 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 789 | 2024.10.09 22:38:50.281288 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Trace> oximeter.version (ca6c66ba-f20b-4193-9817-4cba10a882f0): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 790 | 2024.10.09 22:38:50.281348 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.27 GiB. | ||
| 791 | 2024.10.09 22:38:50.283618 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 792 | 2024.10.09 22:38:50.285305 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Trace> oximeter.version (ca6c66ba-f20b-4193-9817-4cba10a882f0): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 793 | 2024.10.09 22:38:50.285633 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.006538 sec., 152.95197308045272 rows/sec., 2.39 KiB/sec. | ||
| 794 | 2024.10.09 22:38:50.286048 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Debug> DynamicQueryHandler: Done processing query | ||
| 795 | 2024.10.09 22:38:50.286082 [ 3 ] {b57fa72f-8825-417c-976e-47d66add7ac5} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 796 | 2024.10.09 22:38:50.286102 [ 3 ] {} <Debug> HTTP-Session: 44b0cf18-7777-4177-9dcc-20bfa7fd15bd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||