1 | 2024.10.09 22:52:05.752910 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 20008 | ||
2 | 2024.10.09 22:52:05.753083 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.10.09 22:52:05.753143 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.10.09 22:52:05.767224 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.10.09 22:52:05.771485 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.10.09 22:52:05.771527 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.10.09 22:52:05.771539 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.10.09 22:52:05.771592 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_utilization.19959.1-clickhouse-yXpeE9/datastore/tmp/ to store temporary data in it | ||
9 | 2024.10.09 22:52:05.772088 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.10.09 22:52:05.772947 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
11 | 2024.10.09 22:52:05.773417 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
12 | 2024.10.09 22:52:05.773885 [ 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:52:05.773906 [ 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:52:05.773923 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.10.09 22:52:05.773992 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.10.09 22:52:05.775605 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.10.09 22:52:05.807214 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.10.09 22:52:05.808122 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.10.09 22:52:05.809071 [ 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:52:05.809122 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
21 | 2024.10.09 22:52:05.810318 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
22 | 2024.10.09 22:52:05.810898 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
23 | 2024.10.09 22:52:05.814302 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
24 | 2024.10.09 22:52:05.814920 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
25 | 2024.10.09 22:52:05.821007 [ 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:52:05.828061 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.10.09 22:52:05.828427 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.10.09 22:52:05.829206 [ 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:52:05.831381 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.10.09 22:52:05.836692 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_utilization.19959.1-clickhouse-yXpeE9/datastore/ | ||
31 | 2024.10.09 22:52:05.842545 [ 204 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.10.09 22:52:05.842605 [ 204 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.10.09 22:52:05.858397 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.10.09 22:52:05.858446 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000188031 sec | ||
35 | 2024.10.09 22:52:05.858467 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.10.09 22:52:05.858477 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.10.09 22:52:05.858551 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.10.09 22:52:05.858601 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
39 | 2024.10.09 22:52:05.858632 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
40 | 2024.10.09 22:52:05.858644 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.10.09 22:52:05.858656 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.10.09 22:52:05.858689 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.10.09 22:52:05.858701 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.10.09 22:52:05.858712 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
45 | 2024.10.09 22:52:05.858745 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2024.10.09 22:52:05.858759 [ 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:52:05.858772 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
48 | 2024.10.09 22:52:05.858788 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2024.10.09 22:52:05.858807 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2024.10.09 22:52:05.858827 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.10.09 22:52:05.858842 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.10.09 22:52:05.858871 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2024.10.09 22:52:05.858884 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2024.10.09 22:52:05.858899 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2024.10.09 22:52:05.917758 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.10.09 22:52:05.920445 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.10.09 22:52:05.920636 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000277077 sec | ||
58 | 2024.10.09 22:52:05.920661 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.10.09 22:52:05.920672 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.10.09 22:52:05.920774 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.10.09 22:52:05.920987 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_utilization.19959.1-clickhouse-yXpeE9/datastore/user_defined/ | ||
62 | 2024.10.09 22:52:05.921055 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.10.09 22:52:05.921073 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.10.09 22:52:05.921085 [ 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:52:05.921104 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.10.09 22:52:05.921499 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 36390 | ||
67 | 2024.10.09 22:52:05.921684 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40824 | ||
68 | 2024.10.09 22:52:05.923366 [ 1 ] {} <Warning> Application: Listen [::1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: [::1]:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host> | ||
69 | 2024.10.09 22:52:05.926803 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 56466 | ||
70 | 2024.10.09 22:52:05.927353 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 32779 | ||
71 | 2024.10.09 22:52:05.927464 [ 1 ] {} <Warning> Application: Listen [127.0.0.1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: 127.0.0.1:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host> | ||
72 | 2024.10.09 22:52:05.927514 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
73 | 2024.10.09 22:52:05.937732 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 16.00 MiB, free memory in arenas 0.00 B, will set to 127.18 MiB (RSS), difference: 117.28 MiB | ||
74 | 2024.10.09 22:52:05.938184 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.1398e-05 sec. | ||
75 | 2024.10.09 22:52:05.938724 [ 1 ] {} <Information> Application: Listening for http://[::1]:36390 | ||
76 | 2024.10.09 22:52:05.938800 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:40824 | ||
77 | 2024.10.09 22:52:05.938861 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:56466 | ||
78 | 2024.10.09 22:52:05.938917 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:32779 | ||
79 | 2024.10.09 22:52:05.938940 [ 1 ] {} <Information> Application: Ready for connections. | ||
80 | 2024.10.09 22:52:17.769671 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
81 | 2024.10.09 22:52:17.769894 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
82 | 2024.10.09 22:52:17.769939 [ 3 ] {} <Debug> HTTP-Session: 9e3c8ec7-5192-4451-8818-a191dbc29116 Authenticating user 'default' from [::1]:45501 | ||
83 | 2024.10.09 22:52:17.769974 [ 3 ] {} <Debug> HTTP-Session: 9e3c8ec7-5192-4451-8818-a191dbc29116 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2024.10.09 22:52:17.769988 [ 3 ] {} <Debug> HTTP-Session: 9e3c8ec7-5192-4451-8818-a191dbc29116 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
85 | 2024.10.09 22:52:17.770083 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
86 | 2024.10.09 22:52:17.770124 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
87 | 2024.10.09 22:52:17.770150 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
88 | 2024.10.09 22:52:17.770200 [ 3 ] {} <Trace> HTTP-Session: 9e3c8ec7-5192-4451-8818-a191dbc29116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
89 | 2024.10.09 22:52:17.770711 [ 3 ] {adb62f48-9b6a-431e-9da5-e7bc9ae43bfc} <Debug> executeQuery: (from [::1]:45501) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
90 | 2024.10.09 22:52:17.779155 [ 3 ] {adb62f48-9b6a-431e-9da5-e7bc9ae43bfc} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:45501) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
91 | |||
92 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
93 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
94 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
95 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
96 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
97 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
98 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
99 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
100 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
101 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
102 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
103 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
104 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
105 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
106 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
107 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
108 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
109 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
110 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
111 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
112 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
113 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
114 | |||
115 | 2024.10.09 22:52:17.779378 [ 3 ] {adb62f48-9b6a-431e-9da5-e7bc9ae43bfc} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
116 | |||
117 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
118 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
119 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
120 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
121 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
122 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
123 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
124 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
125 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
126 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
127 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
128 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
129 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
130 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
131 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
132 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
133 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
134 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
135 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
136 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
137 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
138 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
139 | (version 23.8.7.1) | ||
140 | 2024.10.09 22:52:17.779686 [ 3 ] {} <Debug> HTTP-Session: 9e3c8ec7-5192-4451-8818-a191dbc29116 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
141 | 2024.10.09 22:52:17.780904 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
142 | 2024.10.09 22:52:17.781010 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
143 | 2024.10.09 22:52:17.781037 [ 3 ] {} <Debug> HTTP-Session: 480047f6-ca06-4d77-9df1-16ac3a5d6697 Authenticating user 'default' from [::1]:45501 | ||
144 | 2024.10.09 22:52:17.781069 [ 3 ] {} <Debug> HTTP-Session: 480047f6-ca06-4d77-9df1-16ac3a5d6697 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
145 | 2024.10.09 22:52:17.781086 [ 3 ] {} <Debug> HTTP-Session: 480047f6-ca06-4d77-9df1-16ac3a5d6697 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2024.10.09 22:52:17.781136 [ 3 ] {} <Trace> HTTP-Session: 480047f6-ca06-4d77-9df1-16ac3a5d6697 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
147 | 2024.10.09 22:52:17.781346 [ 3 ] {09eaa89a-a582-4268-bf85-1fd96276fa95} <Debug> executeQuery: (from [::1]:45501) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
148 | 2024.10.09 22:52:17.781738 [ 3 ] {09eaa89a-a582-4268-bf85-1fd96276fa95} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:45501) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
149 | |||
150 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
151 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
152 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
153 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
154 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
155 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
156 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
157 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
158 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
159 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
160 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
161 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
162 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
163 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
164 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
165 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
166 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
167 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
168 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
169 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
170 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
171 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
172 | |||
173 | 2024.10.09 22:52:17.781903 [ 3 ] {09eaa89a-a582-4268-bf85-1fd96276fa95} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
174 | |||
175 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
176 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
177 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
178 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
179 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
180 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
181 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
182 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
183 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
184 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
185 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
186 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
187 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
188 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
189 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
190 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
191 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
192 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
193 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
197 | (version 23.8.7.1) | ||
198 | 2024.10.09 22:52:17.782102 [ 3 ] {} <Debug> HTTP-Session: 480047f6-ca06-4d77-9df1-16ac3a5d6697 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
199 | 2024.10.09 22:52:17.782724 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
200 | 2024.10.09 22:52:17.782788 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
201 | 2024.10.09 22:52:17.782811 [ 3 ] {} <Debug> HTTP-Session: 95b03534-9d24-4c69-a5fc-2f5d054b083d Authenticating user 'default' from [::1]:45501 | ||
202 | 2024.10.09 22:52:17.782837 [ 3 ] {} <Debug> HTTP-Session: 95b03534-9d24-4c69-a5fc-2f5d054b083d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
203 | 2024.10.09 22:52:17.782853 [ 3 ] {} <Debug> HTTP-Session: 95b03534-9d24-4c69-a5fc-2f5d054b083d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
204 | 2024.10.09 22:52:17.782891 [ 3 ] {} <Trace> HTTP-Session: 95b03534-9d24-4c69-a5fc-2f5d054b083d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
205 | 2024.10.09 22:52:17.783105 [ 3 ] {95d2d662-f648-40cf-aedd-a442394794e0} <Debug> executeQuery: (from [::1]:45501) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
206 | 2024.10.09 22:52:17.783351 [ 3 ] {95d2d662-f648-40cf-aedd-a442394794e0} <Debug> DynamicQueryHandler: Done processing query | ||
207 | 2024.10.09 22:52:17.783376 [ 3 ] {} <Debug> HTTP-Session: 95b03534-9d24-4c69-a5fc-2f5d054b083d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
208 | 2024.10.09 22:52:17.784018 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
209 | 2024.10.09 22:52:17.784111 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
210 | 2024.10.09 22:52:17.784139 [ 3 ] {} <Debug> HTTP-Session: 1cdd9fe8-b4f5-44ba-b4ed-c589fb221318 Authenticating user 'default' from [::1]:45501 | ||
211 | 2024.10.09 22:52:17.784164 [ 3 ] {} <Debug> HTTP-Session: 1cdd9fe8-b4f5-44ba-b4ed-c589fb221318 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
212 | 2024.10.09 22:52:17.784179 [ 3 ] {} <Debug> HTTP-Session: 1cdd9fe8-b4f5-44ba-b4ed-c589fb221318 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
213 | 2024.10.09 22:52:17.784213 [ 3 ] {} <Trace> HTTP-Session: 1cdd9fe8-b4f5-44ba-b4ed-c589fb221318 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
214 | 2024.10.09 22:52:17.784330 [ 3 ] {58c3ddb6-69f5-486d-833f-bf2f41291942} <Debug> executeQuery: (from [::1]:45501) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
215 | 2024.10.09 22:52:17.784442 [ 3 ] {58c3ddb6-69f5-486d-833f-bf2f41291942} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
216 | 2024.10.09 22:52:17.785642 [ 3 ] {58c3ddb6-69f5-486d-833f-bf2f41291942} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
217 | 2024.10.09 22:52:17.785680 [ 3 ] {58c3ddb6-69f5-486d-833f-bf2f41291942} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.3746e-05 sec | ||
218 | 2024.10.09 22:52:17.785696 [ 3 ] {58c3ddb6-69f5-486d-833f-bf2f41291942} <Trace> ReferentialDeps: No tables | ||
219 | 2024.10.09 22:52:17.785708 [ 3 ] {58c3ddb6-69f5-486d-833f-bf2f41291942} <Trace> LoadingDeps: No tables | ||
220 | 2024.10.09 22:52:17.785732 [ 3 ] {58c3ddb6-69f5-486d-833f-bf2f41291942} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
221 | 2024.10.09 22:52:17.785914 [ 3 ] {58c3ddb6-69f5-486d-833f-bf2f41291942} <Debug> DynamicQueryHandler: Done processing query | ||
222 | 2024.10.09 22:52:17.785941 [ 3 ] {} <Debug> HTTP-Session: 1cdd9fe8-b4f5-44ba-b4ed-c589fb221318 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
223 | 2024.10.09 22:52:17.786448 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
224 | 2024.10.09 22:52:17.786552 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
225 | 2024.10.09 22:52:17.786579 [ 3 ] {} <Debug> HTTP-Session: f42d1819-5e44-466a-9d98-e4e5061e4a9e Authenticating user 'default' from [::1]:45501 | ||
226 | 2024.10.09 22:52:17.786598 [ 3 ] {} <Debug> HTTP-Session: f42d1819-5e44-466a-9d98-e4e5061e4a9e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
227 | 2024.10.09 22:52:17.786621 [ 3 ] {} <Debug> HTTP-Session: f42d1819-5e44-466a-9d98-e4e5061e4a9e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
228 | 2024.10.09 22:52:17.786658 [ 3 ] {} <Trace> HTTP-Session: f42d1819-5e44-466a-9d98-e4e5061e4a9e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
229 | 2024.10.09 22:52:17.786862 [ 3 ] {f1569a17-674a-4422-b3cb-9da3050fa3d5} <Debug> executeQuery: (from [::1]:45501) /* The version table contains metadata about the `oximeter` database */ | ||
230 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
231 | 2024.10.09 22:52:17.786933 [ 3 ] {f1569a17-674a-4422-b3cb-9da3050fa3d5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
232 | 2024.10.09 22:52:17.788601 [ 3 ] {f1569a17-674a-4422-b3cb-9da3050fa3d5} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
233 | 2024.10.09 22:52:17.789437 [ 3 ] {f1569a17-674a-4422-b3cb-9da3050fa3d5} <Debug> oximeter.version (dbfb0f09-44c8-44fd-83f2-7b580a37864e): Loading data parts | ||
234 | 2024.10.09 22:52:17.790079 [ 3 ] {f1569a17-674a-4422-b3cb-9da3050fa3d5} <Debug> oximeter.version (dbfb0f09-44c8-44fd-83f2-7b580a37864e): There are no data parts | ||
235 | 2024.10.09 22:52:17.791400 [ 3 ] {f1569a17-674a-4422-b3cb-9da3050fa3d5} <Debug> DynamicQueryHandler: Done processing query | ||
236 | 2024.10.09 22:52:17.791434 [ 3 ] {} <Debug> HTTP-Session: f42d1819-5e44-466a-9d98-e4e5061e4a9e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
237 | 2024.10.09 22:52:17.792097 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
238 | 2024.10.09 22:52:17.792164 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
239 | 2024.10.09 22:52:17.792208 [ 3 ] {} <Debug> HTTP-Session: 2fabcd27-d943-49cc-8949-43fd11c71e83 Authenticating user 'default' from [::1]:45501 | ||
240 | 2024.10.09 22:52:17.792231 [ 3 ] {} <Debug> HTTP-Session: 2fabcd27-d943-49cc-8949-43fd11c71e83 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
241 | 2024.10.09 22:52:17.792247 [ 3 ] {} <Debug> HTTP-Session: 2fabcd27-d943-49cc-8949-43fd11c71e83 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
242 | 2024.10.09 22:52:17.792291 [ 3 ] {} <Trace> HTTP-Session: 2fabcd27-d943-49cc-8949-43fd11c71e83 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
243 | 2024.10.09 22:52:17.792574 [ 3 ] {79afacbe-06b6-4190-ba40-f95ec59a7de2} <Debug> executeQuery: (from [::1]:45501) /* The measurement tables contain all individual samples from each timeseries. | ||
244 | * | ||
245 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
246 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
247 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
248 | * by all samples from the same timeseries. | ||
249 | * | ||
250 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
251 | * and then uses that to index quickly into the measurements tables. | ||
252 | */ | ||
253 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
254 | 2024.10.09 22:52:17.792713 [ 3 ] {79afacbe-06b6-4190-ba40-f95ec59a7de2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
255 | 2024.10.09 22:52:17.794651 [ 3 ] {79afacbe-06b6-4190-ba40-f95ec59a7de2} <Debug> oximeter.measurements_bool (f130bf69-e846-47c1-ba85-350f1ca491c2): Loading data parts | ||
256 | 2024.10.09 22:52:17.794875 [ 3 ] {79afacbe-06b6-4190-ba40-f95ec59a7de2} <Debug> oximeter.measurements_bool (f130bf69-e846-47c1-ba85-350f1ca491c2): There are no data parts | ||
257 | 2024.10.09 22:52:17.795988 [ 3 ] {79afacbe-06b6-4190-ba40-f95ec59a7de2} <Debug> DynamicQueryHandler: Done processing query | ||
258 | 2024.10.09 22:52:17.796017 [ 3 ] {} <Debug> HTTP-Session: 2fabcd27-d943-49cc-8949-43fd11c71e83 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
259 | 2024.10.09 22:52:17.796495 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
260 | 2024.10.09 22:52:17.796559 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
261 | 2024.10.09 22:52:17.796575 [ 3 ] {} <Debug> HTTP-Session: da08c789-b558-442e-94df-779ada0aec9a Authenticating user 'default' from [::1]:45501 | ||
262 | 2024.10.09 22:52:17.796589 [ 3 ] {} <Debug> HTTP-Session: da08c789-b558-442e-94df-779ada0aec9a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
263 | 2024.10.09 22:52:17.796603 [ 3 ] {} <Debug> HTTP-Session: da08c789-b558-442e-94df-779ada0aec9a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
264 | 2024.10.09 22:52:17.796632 [ 3 ] {} <Trace> HTTP-Session: da08c789-b558-442e-94df-779ada0aec9a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
265 | 2024.10.09 22:52:17.796817 [ 3 ] {910e1e0a-a790-49bb-91f7-d6ffd86c473b} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
266 | 2024.10.09 22:52:17.796864 [ 3 ] {910e1e0a-a790-49bb-91f7-d6ffd86c473b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
267 | 2024.10.09 22:52:17.798473 [ 3 ] {910e1e0a-a790-49bb-91f7-d6ffd86c473b} <Debug> oximeter.measurements_i8 (d3bc2e9f-370c-4426-b294-6e5cd1d158f0): Loading data parts | ||
268 | 2024.10.09 22:52:17.798716 [ 3 ] {910e1e0a-a790-49bb-91f7-d6ffd86c473b} <Debug> oximeter.measurements_i8 (d3bc2e9f-370c-4426-b294-6e5cd1d158f0): There are no data parts | ||
269 | 2024.10.09 22:52:17.799880 [ 3 ] {910e1e0a-a790-49bb-91f7-d6ffd86c473b} <Debug> DynamicQueryHandler: Done processing query | ||
270 | 2024.10.09 22:52:17.799905 [ 3 ] {} <Debug> HTTP-Session: da08c789-b558-442e-94df-779ada0aec9a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
271 | 2024.10.09 22:52:17.800538 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
272 | 2024.10.09 22:52:17.800600 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
273 | 2024.10.09 22:52:17.800618 [ 3 ] {} <Debug> HTTP-Session: 0e627c41-f680-4dff-afa5-510dbd5ec3d1 Authenticating user 'default' from [::1]:45501 | ||
274 | 2024.10.09 22:52:17.800639 [ 3 ] {} <Debug> HTTP-Session: 0e627c41-f680-4dff-afa5-510dbd5ec3d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
275 | 2024.10.09 22:52:17.800649 [ 3 ] {} <Debug> HTTP-Session: 0e627c41-f680-4dff-afa5-510dbd5ec3d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
276 | 2024.10.09 22:52:17.800676 [ 3 ] {} <Trace> HTTP-Session: 0e627c41-f680-4dff-afa5-510dbd5ec3d1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
277 | 2024.10.09 22:52:17.800866 [ 3 ] {edb92dc9-ad2a-42e3-bddc-aaa67a3b0998} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
278 | 2024.10.09 22:52:17.800915 [ 3 ] {edb92dc9-ad2a-42e3-bddc-aaa67a3b0998} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
279 | 2024.10.09 22:52:17.802333 [ 3 ] {edb92dc9-ad2a-42e3-bddc-aaa67a3b0998} <Debug> oximeter.measurements_u8 (7722098e-4d05-4ea6-9b4e-4553e7783c00): Loading data parts | ||
280 | 2024.10.09 22:52:17.802562 [ 3 ] {edb92dc9-ad2a-42e3-bddc-aaa67a3b0998} <Debug> oximeter.measurements_u8 (7722098e-4d05-4ea6-9b4e-4553e7783c00): There are no data parts | ||
281 | 2024.10.09 22:52:17.803805 [ 3 ] {edb92dc9-ad2a-42e3-bddc-aaa67a3b0998} <Debug> DynamicQueryHandler: Done processing query | ||
282 | 2024.10.09 22:52:17.803836 [ 3 ] {} <Debug> HTTP-Session: 0e627c41-f680-4dff-afa5-510dbd5ec3d1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
283 | 2024.10.09 22:52:17.804348 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
284 | 2024.10.09 22:52:17.804417 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
285 | 2024.10.09 22:52:17.804438 [ 3 ] {} <Debug> HTTP-Session: c9b2102d-6652-44a2-8cc3-c598f026339e Authenticating user 'default' from [::1]:45501 | ||
286 | 2024.10.09 22:52:17.804455 [ 3 ] {} <Debug> HTTP-Session: c9b2102d-6652-44a2-8cc3-c598f026339e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
287 | 2024.10.09 22:52:17.804469 [ 3 ] {} <Debug> HTTP-Session: c9b2102d-6652-44a2-8cc3-c598f026339e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
288 | 2024.10.09 22:52:17.804511 [ 3 ] {} <Trace> HTTP-Session: c9b2102d-6652-44a2-8cc3-c598f026339e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
289 | 2024.10.09 22:52:17.804766 [ 3 ] {3e839af6-1df8-494d-8ab6-5e2a9887ff39} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
290 | 2024.10.09 22:52:17.804822 [ 3 ] {3e839af6-1df8-494d-8ab6-5e2a9887ff39} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
291 | 2024.10.09 22:52:17.806520 [ 3 ] {3e839af6-1df8-494d-8ab6-5e2a9887ff39} <Debug> oximeter.measurements_i16 (7e7e68de-4ace-4946-9468-271093ff104b): Loading data parts | ||
292 | 2024.10.09 22:52:17.806794 [ 3 ] {3e839af6-1df8-494d-8ab6-5e2a9887ff39} <Debug> oximeter.measurements_i16 (7e7e68de-4ace-4946-9468-271093ff104b): There are no data parts | ||
293 | 2024.10.09 22:52:17.808612 [ 3 ] {3e839af6-1df8-494d-8ab6-5e2a9887ff39} <Debug> DynamicQueryHandler: Done processing query | ||
294 | 2024.10.09 22:52:17.808638 [ 3 ] {} <Debug> HTTP-Session: c9b2102d-6652-44a2-8cc3-c598f026339e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
295 | 2024.10.09 22:52:17.809097 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
296 | 2024.10.09 22:52:17.809170 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
297 | 2024.10.09 22:52:17.809191 [ 3 ] {} <Debug> HTTP-Session: aa59c2a7-96ef-4755-9bc6-a8e0bac53879 Authenticating user 'default' from [::1]:45501 | ||
298 | 2024.10.09 22:52:17.809218 [ 3 ] {} <Debug> HTTP-Session: aa59c2a7-96ef-4755-9bc6-a8e0bac53879 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
299 | 2024.10.09 22:52:17.809234 [ 3 ] {} <Debug> HTTP-Session: aa59c2a7-96ef-4755-9bc6-a8e0bac53879 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
300 | 2024.10.09 22:52:17.809267 [ 3 ] {} <Trace> HTTP-Session: aa59c2a7-96ef-4755-9bc6-a8e0bac53879 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
301 | 2024.10.09 22:52:17.809502 [ 3 ] {3e3aba36-dfcb-4890-831f-6604c83ee704} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
302 | 2024.10.09 22:52:17.809563 [ 3 ] {3e3aba36-dfcb-4890-831f-6604c83ee704} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
303 | 2024.10.09 22:52:17.811203 [ 3 ] {3e3aba36-dfcb-4890-831f-6604c83ee704} <Debug> oximeter.measurements_u16 (917c65f9-3f2a-4625-9bef-f309f584df12): Loading data parts | ||
304 | 2024.10.09 22:52:17.811480 [ 3 ] {3e3aba36-dfcb-4890-831f-6604c83ee704} <Debug> oximeter.measurements_u16 (917c65f9-3f2a-4625-9bef-f309f584df12): There are no data parts | ||
305 | 2024.10.09 22:52:17.812563 [ 3 ] {3e3aba36-dfcb-4890-831f-6604c83ee704} <Debug> DynamicQueryHandler: Done processing query | ||
306 | 2024.10.09 22:52:17.812593 [ 3 ] {} <Debug> HTTP-Session: aa59c2a7-96ef-4755-9bc6-a8e0bac53879 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
307 | 2024.10.09 22:52:17.813111 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
308 | 2024.10.09 22:52:17.813164 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
309 | 2024.10.09 22:52:17.813194 [ 3 ] {} <Debug> HTTP-Session: e45d2df7-1e42-49ee-8835-4a6aaff9eed1 Authenticating user 'default' from [::1]:45501 | ||
310 | 2024.10.09 22:52:17.813213 [ 3 ] {} <Debug> HTTP-Session: e45d2df7-1e42-49ee-8835-4a6aaff9eed1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
311 | 2024.10.09 22:52:17.813227 [ 3 ] {} <Debug> HTTP-Session: e45d2df7-1e42-49ee-8835-4a6aaff9eed1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
312 | 2024.10.09 22:52:17.813271 [ 3 ] {} <Trace> HTTP-Session: e45d2df7-1e42-49ee-8835-4a6aaff9eed1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
313 | 2024.10.09 22:52:17.813492 [ 3 ] {916112c6-0062-4240-8afb-3a1adcccd014} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
314 | 2024.10.09 22:52:17.813568 [ 3 ] {916112c6-0062-4240-8afb-3a1adcccd014} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
315 | 2024.10.09 22:52:17.815184 [ 3 ] {916112c6-0062-4240-8afb-3a1adcccd014} <Debug> oximeter.measurements_i32 (157022c7-5d65-42dc-8c0f-5c72e52d2fc3): Loading data parts | ||
316 | 2024.10.09 22:52:17.815487 [ 3 ] {916112c6-0062-4240-8afb-3a1adcccd014} <Debug> oximeter.measurements_i32 (157022c7-5d65-42dc-8c0f-5c72e52d2fc3): There are no data parts | ||
317 | 2024.10.09 22:52:17.816990 [ 3 ] {916112c6-0062-4240-8afb-3a1adcccd014} <Debug> DynamicQueryHandler: Done processing query | ||
318 | 2024.10.09 22:52:17.817037 [ 3 ] {} <Debug> HTTP-Session: e45d2df7-1e42-49ee-8835-4a6aaff9eed1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
319 | 2024.10.09 22:52:17.817902 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
320 | 2024.10.09 22:52:17.817970 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
321 | 2024.10.09 22:52:17.817989 [ 3 ] {} <Debug> HTTP-Session: 8b8aff05-7a35-425b-ad26-fb9b5497e823 Authenticating user 'default' from [::1]:45501 | ||
322 | 2024.10.09 22:52:17.818005 [ 3 ] {} <Debug> HTTP-Session: 8b8aff05-7a35-425b-ad26-fb9b5497e823 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
323 | 2024.10.09 22:52:17.818024 [ 3 ] {} <Debug> HTTP-Session: 8b8aff05-7a35-425b-ad26-fb9b5497e823 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
324 | 2024.10.09 22:52:17.818088 [ 3 ] {} <Trace> HTTP-Session: 8b8aff05-7a35-425b-ad26-fb9b5497e823 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
325 | 2024.10.09 22:52:17.818393 [ 3 ] {047152b2-a638-4039-a4e1-fd05a4cf51b7} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
326 | 2024.10.09 22:52:17.818497 [ 3 ] {047152b2-a638-4039-a4e1-fd05a4cf51b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
327 | 2024.10.09 22:52:17.820422 [ 3 ] {047152b2-a638-4039-a4e1-fd05a4cf51b7} <Debug> oximeter.measurements_u32 (18d02e30-4f9c-439a-b8da-e1711f263039): Loading data parts | ||
328 | 2024.10.09 22:52:17.820819 [ 3 ] {047152b2-a638-4039-a4e1-fd05a4cf51b7} <Debug> oximeter.measurements_u32 (18d02e30-4f9c-439a-b8da-e1711f263039): There are no data parts | ||
329 | 2024.10.09 22:52:17.822080 [ 3 ] {047152b2-a638-4039-a4e1-fd05a4cf51b7} <Debug> DynamicQueryHandler: Done processing query | ||
330 | 2024.10.09 22:52:17.822104 [ 3 ] {} <Debug> HTTP-Session: 8b8aff05-7a35-425b-ad26-fb9b5497e823 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
331 | 2024.10.09 22:52:17.822700 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
332 | 2024.10.09 22:52:17.822762 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
333 | 2024.10.09 22:52:17.822789 [ 3 ] {} <Debug> HTTP-Session: 05cd273b-76bc-4a58-98a8-29f2fd08a074 Authenticating user 'default' from [::1]:45501 | ||
334 | 2024.10.09 22:52:17.822807 [ 3 ] {} <Debug> HTTP-Session: 05cd273b-76bc-4a58-98a8-29f2fd08a074 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
335 | 2024.10.09 22:52:17.822816 [ 3 ] {} <Debug> HTTP-Session: 05cd273b-76bc-4a58-98a8-29f2fd08a074 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
336 | 2024.10.09 22:52:17.822845 [ 3 ] {} <Trace> HTTP-Session: 05cd273b-76bc-4a58-98a8-29f2fd08a074 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
337 | 2024.10.09 22:52:17.823086 [ 3 ] {63e8957f-95fa-4e54-89b0-0aacf66a37a9} <Debug> executeQuery: (from [::1]:45501) 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) | ||
338 | 2024.10.09 22:52:17.823155 [ 3 ] {63e8957f-95fa-4e54-89b0-0aacf66a37a9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
339 | 2024.10.09 22:52:17.824686 [ 3 ] {63e8957f-95fa-4e54-89b0-0aacf66a37a9} <Debug> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Loading data parts | ||
340 | 2024.10.09 22:52:17.824987 [ 3 ] {63e8957f-95fa-4e54-89b0-0aacf66a37a9} <Debug> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): There are no data parts | ||
341 | 2024.10.09 22:52:17.826317 [ 3 ] {63e8957f-95fa-4e54-89b0-0aacf66a37a9} <Debug> DynamicQueryHandler: Done processing query | ||
342 | 2024.10.09 22:52:17.826345 [ 3 ] {} <Debug> HTTP-Session: 05cd273b-76bc-4a58-98a8-29f2fd08a074 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
343 | 2024.10.09 22:52:17.826909 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
344 | 2024.10.09 22:52:17.826989 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
345 | 2024.10.09 22:52:17.827016 [ 3 ] {} <Debug> HTTP-Session: 78954773-d442-49b9-ba2a-a0673ecf681b Authenticating user 'default' from [::1]:45501 | ||
346 | 2024.10.09 22:52:17.827037 [ 3 ] {} <Debug> HTTP-Session: 78954773-d442-49b9-ba2a-a0673ecf681b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
347 | 2024.10.09 22:52:17.827062 [ 3 ] {} <Debug> HTTP-Session: 78954773-d442-49b9-ba2a-a0673ecf681b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
348 | 2024.10.09 22:52:17.827140 [ 3 ] {} <Trace> HTTP-Session: 78954773-d442-49b9-ba2a-a0673ecf681b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
349 | 2024.10.09 22:52:17.827404 [ 3 ] {ffcdffa7-ad37-4358-a8a5-1a6b3d84b8c1} <Debug> executeQuery: (from [::1]:45501) 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) | ||
350 | 2024.10.09 22:52:17.827470 [ 3 ] {ffcdffa7-ad37-4358-a8a5-1a6b3d84b8c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
351 | 2024.10.09 22:52:17.829501 [ 3 ] {ffcdffa7-ad37-4358-a8a5-1a6b3d84b8c1} <Debug> oximeter.measurements_u64 (ca041873-f16d-4a92-bb7f-e40cb12b249c): Loading data parts | ||
352 | 2024.10.09 22:52:17.829859 [ 3 ] {ffcdffa7-ad37-4358-a8a5-1a6b3d84b8c1} <Debug> oximeter.measurements_u64 (ca041873-f16d-4a92-bb7f-e40cb12b249c): There are no data parts | ||
353 | 2024.10.09 22:52:17.831117 [ 3 ] {ffcdffa7-ad37-4358-a8a5-1a6b3d84b8c1} <Debug> DynamicQueryHandler: Done processing query | ||
354 | 2024.10.09 22:52:17.831147 [ 3 ] {} <Debug> HTTP-Session: 78954773-d442-49b9-ba2a-a0673ecf681b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
355 | 2024.10.09 22:52:17.831846 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
356 | 2024.10.09 22:52:17.831901 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
357 | 2024.10.09 22:52:17.831919 [ 3 ] {} <Debug> HTTP-Session: 133c2509-92e5-4203-9a15-735786f03573 Authenticating user 'default' from [::1]:45501 | ||
358 | 2024.10.09 22:52:17.831951 [ 3 ] {} <Debug> HTTP-Session: 133c2509-92e5-4203-9a15-735786f03573 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
359 | 2024.10.09 22:52:17.831969 [ 3 ] {} <Debug> HTTP-Session: 133c2509-92e5-4203-9a15-735786f03573 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
360 | 2024.10.09 22:52:17.832010 [ 3 ] {} <Trace> HTTP-Session: 133c2509-92e5-4203-9a15-735786f03573 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
361 | 2024.10.09 22:52:17.832292 [ 3 ] {5df84a0c-c664-4a02-888c-df13c188a67d} <Debug> executeQuery: (from [::1]:45501) 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) | ||
362 | 2024.10.09 22:52:17.832371 [ 3 ] {5df84a0c-c664-4a02-888c-df13c188a67d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
363 | 2024.10.09 22:52:17.834016 [ 3 ] {5df84a0c-c664-4a02-888c-df13c188a67d} <Debug> oximeter.measurements_f32 (a30daba7-97e6-4423-a749-e2f9494b35af): Loading data parts | ||
364 | 2024.10.09 22:52:17.834252 [ 3 ] {5df84a0c-c664-4a02-888c-df13c188a67d} <Debug> oximeter.measurements_f32 (a30daba7-97e6-4423-a749-e2f9494b35af): There are no data parts | ||
365 | 2024.10.09 22:52:17.835422 [ 3 ] {5df84a0c-c664-4a02-888c-df13c188a67d} <Debug> DynamicQueryHandler: Done processing query | ||
366 | 2024.10.09 22:52:17.835449 [ 3 ] {} <Debug> HTTP-Session: 133c2509-92e5-4203-9a15-735786f03573 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
367 | 2024.10.09 22:52:17.836007 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
368 | 2024.10.09 22:52:17.836082 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
369 | 2024.10.09 22:52:17.836108 [ 3 ] {} <Debug> HTTP-Session: e41a7a75-ffc3-4135-a7e5-018a87936217 Authenticating user 'default' from [::1]:45501 | ||
370 | 2024.10.09 22:52:17.836128 [ 3 ] {} <Debug> HTTP-Session: e41a7a75-ffc3-4135-a7e5-018a87936217 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
371 | 2024.10.09 22:52:17.836144 [ 3 ] {} <Debug> HTTP-Session: e41a7a75-ffc3-4135-a7e5-018a87936217 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
372 | 2024.10.09 22:52:17.836190 [ 3 ] {} <Trace> HTTP-Session: e41a7a75-ffc3-4135-a7e5-018a87936217 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
373 | 2024.10.09 22:52:17.836456 [ 3 ] {36395323-1229-44c9-b022-2e8a78e5305e} <Debug> executeQuery: (from [::1]:45501) 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) | ||
374 | 2024.10.09 22:52:17.836521 [ 3 ] {36395323-1229-44c9-b022-2e8a78e5305e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
375 | 2024.10.09 22:52:17.838183 [ 3 ] {36395323-1229-44c9-b022-2e8a78e5305e} <Debug> oximeter.measurements_f64 (a176560c-6931-4058-9df0-51c8157ac5cf): Loading data parts | ||
376 | 2024.10.09 22:52:17.838435 [ 3 ] {36395323-1229-44c9-b022-2e8a78e5305e} <Debug> oximeter.measurements_f64 (a176560c-6931-4058-9df0-51c8157ac5cf): There are no data parts | ||
377 | 2024.10.09 22:52:17.839952 [ 3 ] {36395323-1229-44c9-b022-2e8a78e5305e} <Debug> DynamicQueryHandler: Done processing query | ||
378 | 2024.10.09 22:52:17.839985 [ 3 ] {} <Debug> HTTP-Session: e41a7a75-ffc3-4135-a7e5-018a87936217 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
379 | 2024.10.09 22:52:17.840717 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
380 | 2024.10.09 22:52:17.840797 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
381 | 2024.10.09 22:52:17.840818 [ 3 ] {} <Debug> HTTP-Session: 738b1080-5766-4126-843d-eacff79f1cc8 Authenticating user 'default' from [::1]:45501 | ||
382 | 2024.10.09 22:52:17.840837 [ 3 ] {} <Debug> HTTP-Session: 738b1080-5766-4126-843d-eacff79f1cc8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
383 | 2024.10.09 22:52:17.840860 [ 3 ] {} <Debug> HTTP-Session: 738b1080-5766-4126-843d-eacff79f1cc8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
384 | 2024.10.09 22:52:17.840900 [ 3 ] {} <Trace> HTTP-Session: 738b1080-5766-4126-843d-eacff79f1cc8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
385 | 2024.10.09 22:52:17.841172 [ 3 ] {414529c1-4b3d-4925-902b-86775030a08f} <Debug> executeQuery: (from [::1]:45501) 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) | ||
386 | 2024.10.09 22:52:17.841229 [ 3 ] {414529c1-4b3d-4925-902b-86775030a08f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
387 | 2024.10.09 22:52:17.843194 [ 3 ] {414529c1-4b3d-4925-902b-86775030a08f} <Debug> oximeter.measurements_string (19896a65-186e-48b0-839d-93c0034721a8): Loading data parts | ||
388 | 2024.10.09 22:52:17.843509 [ 3 ] {414529c1-4b3d-4925-902b-86775030a08f} <Debug> oximeter.measurements_string (19896a65-186e-48b0-839d-93c0034721a8): There are no data parts | ||
389 | 2024.10.09 22:52:17.844891 [ 3 ] {414529c1-4b3d-4925-902b-86775030a08f} <Debug> DynamicQueryHandler: Done processing query | ||
390 | 2024.10.09 22:52:17.844953 [ 3 ] {} <Debug> HTTP-Session: 738b1080-5766-4126-843d-eacff79f1cc8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
391 | 2024.10.09 22:52:17.845757 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
392 | 2024.10.09 22:52:17.845826 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
393 | 2024.10.09 22:52:17.845861 [ 3 ] {} <Debug> HTTP-Session: 9be2ffb2-dc76-410d-9936-0439faec7814 Authenticating user 'default' from [::1]:45501 | ||
394 | 2024.10.09 22:52:17.845913 [ 3 ] {} <Debug> HTTP-Session: 9be2ffb2-dc76-410d-9936-0439faec7814 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
395 | 2024.10.09 22:52:17.845939 [ 3 ] {} <Debug> HTTP-Session: 9be2ffb2-dc76-410d-9936-0439faec7814 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
396 | 2024.10.09 22:52:17.845998 [ 3 ] {} <Trace> HTTP-Session: 9be2ffb2-dc76-410d-9936-0439faec7814 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
397 | 2024.10.09 22:52:17.846339 [ 3 ] {e424e669-d254-4dd5-8a58-cffd31e39902} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
398 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
399 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
400 | * a string isn't palatable for a few reasons. | ||
401 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
402 | * details. | ||
403 | */ | ||
404 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
405 | 2024.10.09 22:52:17.846421 [ 3 ] {e424e669-d254-4dd5-8a58-cffd31e39902} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
406 | 2024.10.09 22:52:17.848265 [ 3 ] {e424e669-d254-4dd5-8a58-cffd31e39902} <Debug> oximeter.measurements_bytes (048e71d1-eb97-4df6-ac96-dcafd75d36bf): Loading data parts | ||
407 | 2024.10.09 22:52:17.848513 [ 3 ] {e424e669-d254-4dd5-8a58-cffd31e39902} <Debug> oximeter.measurements_bytes (048e71d1-eb97-4df6-ac96-dcafd75d36bf): There are no data parts | ||
408 | 2024.10.09 22:52:17.849774 [ 3 ] {e424e669-d254-4dd5-8a58-cffd31e39902} <Debug> DynamicQueryHandler: Done processing query | ||
409 | 2024.10.09 22:52:17.849814 [ 3 ] {} <Debug> HTTP-Session: 9be2ffb2-dc76-410d-9936-0439faec7814 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
410 | 2024.10.09 22:52:17.850900 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
411 | 2024.10.09 22:52:17.850995 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
412 | 2024.10.09 22:52:17.851032 [ 3 ] {} <Debug> HTTP-Session: 1c4aa741-d9c5-41f0-ada3-185705d18922 Authenticating user 'default' from [::1]:45501 | ||
413 | 2024.10.09 22:52:17.851053 [ 3 ] {} <Debug> HTTP-Session: 1c4aa741-d9c5-41f0-ada3-185705d18922 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
414 | 2024.10.09 22:52:17.851069 [ 3 ] {} <Debug> HTTP-Session: 1c4aa741-d9c5-41f0-ada3-185705d18922 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
415 | 2024.10.09 22:52:17.851120 [ 3 ] {} <Trace> HTTP-Session: 1c4aa741-d9c5-41f0-ada3-185705d18922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
416 | 2024.10.09 22:52:17.851505 [ 3 ] {303025c8-d2f4-4b94-b4fa-3884b2bc9fdf} <Debug> executeQuery: (from [::1]:45501) 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) | ||
417 | 2024.10.09 22:52:17.851608 [ 3 ] {303025c8-d2f4-4b94-b4fa-3884b2bc9fdf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
418 | 2024.10.09 22:52:17.853938 [ 3 ] {303025c8-d2f4-4b94-b4fa-3884b2bc9fdf} <Debug> oximeter.measurements_cumulativei64 (1ddf11eb-03a9-4e41-bd67-27e375108324): Loading data parts | ||
419 | 2024.10.09 22:52:17.854269 [ 3 ] {303025c8-d2f4-4b94-b4fa-3884b2bc9fdf} <Debug> oximeter.measurements_cumulativei64 (1ddf11eb-03a9-4e41-bd67-27e375108324): There are no data parts | ||
420 | 2024.10.09 22:52:17.855813 [ 3 ] {303025c8-d2f4-4b94-b4fa-3884b2bc9fdf} <Debug> DynamicQueryHandler: Done processing query | ||
421 | 2024.10.09 22:52:17.855839 [ 3 ] {} <Debug> HTTP-Session: 1c4aa741-d9c5-41f0-ada3-185705d18922 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
422 | 2024.10.09 22:52:17.860865 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
423 | 2024.10.09 22:52:17.860988 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
424 | 2024.10.09 22:52:17.861039 [ 3 ] {} <Debug> HTTP-Session: 8bc652c6-113e-4cf6-8423-d3f527125cbb Authenticating user 'default' from [::1]:45501 | ||
425 | 2024.10.09 22:52:17.861088 [ 3 ] {} <Debug> HTTP-Session: 8bc652c6-113e-4cf6-8423-d3f527125cbb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
426 | 2024.10.09 22:52:17.861105 [ 3 ] {} <Debug> HTTP-Session: 8bc652c6-113e-4cf6-8423-d3f527125cbb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
427 | 2024.10.09 22:52:17.861161 [ 3 ] {} <Trace> HTTP-Session: 8bc652c6-113e-4cf6-8423-d3f527125cbb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
428 | 2024.10.09 22:52:17.861662 [ 3 ] {d4baaa6e-53ef-4793-905d-1f59b9ed0690} <Debug> executeQuery: (from [::1]:45501) 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) | ||
429 | 2024.10.09 22:52:17.861748 [ 3 ] {d4baaa6e-53ef-4793-905d-1f59b9ed0690} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
430 | 2024.10.09 22:52:17.863953 [ 3 ] {d4baaa6e-53ef-4793-905d-1f59b9ed0690} <Debug> oximeter.measurements_cumulativeu64 (c7576068-7e6c-4ded-a663-169933c3b0ed): Loading data parts | ||
431 | 2024.10.09 22:52:17.864227 [ 3 ] {d4baaa6e-53ef-4793-905d-1f59b9ed0690} <Debug> oximeter.measurements_cumulativeu64 (c7576068-7e6c-4ded-a663-169933c3b0ed): There are no data parts | ||
432 | 2024.10.09 22:52:17.865814 [ 3 ] {d4baaa6e-53ef-4793-905d-1f59b9ed0690} <Debug> DynamicQueryHandler: Done processing query | ||
433 | 2024.10.09 22:52:17.865837 [ 3 ] {} <Debug> HTTP-Session: 8bc652c6-113e-4cf6-8423-d3f527125cbb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
434 | 2024.10.09 22:52:17.866680 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
435 | 2024.10.09 22:52:17.866769 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
436 | 2024.10.09 22:52:17.866793 [ 3 ] {} <Debug> HTTP-Session: 84c7df78-4a96-4f74-8334-3592f7a396ef Authenticating user 'default' from [::1]:45501 | ||
437 | 2024.10.09 22:52:17.866815 [ 3 ] {} <Debug> HTTP-Session: 84c7df78-4a96-4f74-8334-3592f7a396ef Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
438 | 2024.10.09 22:52:17.866841 [ 3 ] {} <Debug> HTTP-Session: 84c7df78-4a96-4f74-8334-3592f7a396ef Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
439 | 2024.10.09 22:52:17.866888 [ 3 ] {} <Trace> HTTP-Session: 84c7df78-4a96-4f74-8334-3592f7a396ef Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
440 | 2024.10.09 22:52:17.867206 [ 3 ] {515b0ca0-9b2a-42bb-ba52-e4dbb0d825bd} <Debug> executeQuery: (from [::1]:45501) 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) | ||
441 | 2024.10.09 22:52:17.867291 [ 3 ] {515b0ca0-9b2a-42bb-ba52-e4dbb0d825bd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
442 | 2024.10.09 22:52:17.869482 [ 3 ] {515b0ca0-9b2a-42bb-ba52-e4dbb0d825bd} <Debug> oximeter.measurements_cumulativef32 (762daed1-e079-4f74-b7ac-0975600fa63a): Loading data parts | ||
443 | 2024.10.09 22:52:17.869731 [ 3 ] {515b0ca0-9b2a-42bb-ba52-e4dbb0d825bd} <Debug> oximeter.measurements_cumulativef32 (762daed1-e079-4f74-b7ac-0975600fa63a): There are no data parts | ||
444 | 2024.10.09 22:52:17.871475 [ 3 ] {515b0ca0-9b2a-42bb-ba52-e4dbb0d825bd} <Debug> DynamicQueryHandler: Done processing query | ||
445 | 2024.10.09 22:52:17.871504 [ 3 ] {} <Debug> HTTP-Session: 84c7df78-4a96-4f74-8334-3592f7a396ef Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
446 | 2024.10.09 22:52:17.872083 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
447 | 2024.10.09 22:52:17.872151 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
448 | 2024.10.09 22:52:17.872175 [ 3 ] {} <Debug> HTTP-Session: 0efd5274-aefd-4c0b-b9e5-4a55ff18f215 Authenticating user 'default' from [::1]:45501 | ||
449 | 2024.10.09 22:52:17.872210 [ 3 ] {} <Debug> HTTP-Session: 0efd5274-aefd-4c0b-b9e5-4a55ff18f215 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
450 | 2024.10.09 22:52:17.872226 [ 3 ] {} <Debug> HTTP-Session: 0efd5274-aefd-4c0b-b9e5-4a55ff18f215 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
451 | 2024.10.09 22:52:17.872267 [ 3 ] {} <Trace> HTTP-Session: 0efd5274-aefd-4c0b-b9e5-4a55ff18f215 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
452 | 2024.10.09 22:52:17.872569 [ 3 ] {e3175d24-b1de-43ca-a304-e4f8cdd19558} <Debug> executeQuery: (from [::1]:45501) 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) | ||
453 | 2024.10.09 22:52:17.872641 [ 3 ] {e3175d24-b1de-43ca-a304-e4f8cdd19558} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
454 | 2024.10.09 22:52:17.874765 [ 3 ] {e3175d24-b1de-43ca-a304-e4f8cdd19558} <Debug> oximeter.measurements_cumulativef64 (62fb7e13-b9a9-47b9-a718-a8e8837c8723): Loading data parts | ||
455 | 2024.10.09 22:52:17.875063 [ 3 ] {e3175d24-b1de-43ca-a304-e4f8cdd19558} <Debug> oximeter.measurements_cumulativef64 (62fb7e13-b9a9-47b9-a718-a8e8837c8723): There are no data parts | ||
456 | 2024.10.09 22:52:17.876593 [ 3 ] {e3175d24-b1de-43ca-a304-e4f8cdd19558} <Debug> DynamicQueryHandler: Done processing query | ||
457 | 2024.10.09 22:52:17.876622 [ 3 ] {} <Debug> HTTP-Session: 0efd5274-aefd-4c0b-b9e5-4a55ff18f215 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
458 | 2024.10.09 22:52:17.877356 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
459 | 2024.10.09 22:52:17.877439 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
460 | 2024.10.09 22:52:17.877462 [ 3 ] {} <Debug> HTTP-Session: afe9a512-ddf5-43c3-bb42-eafa3bf1a320 Authenticating user 'default' from [::1]:45501 | ||
461 | 2024.10.09 22:52:17.877484 [ 3 ] {} <Debug> HTTP-Session: afe9a512-ddf5-43c3-bb42-eafa3bf1a320 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
462 | 2024.10.09 22:52:17.877508 [ 3 ] {} <Debug> HTTP-Session: afe9a512-ddf5-43c3-bb42-eafa3bf1a320 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
463 | 2024.10.09 22:52:17.877565 [ 3 ] {} <Trace> HTTP-Session: afe9a512-ddf5-43c3-bb42-eafa3bf1a320 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
464 | 2024.10.09 22:52:17.877996 [ 3 ] {4dffadb5-f620-4f77-9663-fc2e8473ec78} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
465 | * NOTE: Array types cannot be Nullable, see | ||
466 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
467 | * for more details. | ||
468 | * | ||
469 | * This means we need to use empty arrays to indicate a missing value. This | ||
470 | * is unfortunate, and at this point relies on the fact that an | ||
471 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
472 | * to figure out another way to represent missing samples here. | ||
473 | */ | ||
474 | 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) | ||
475 | 2024.10.09 22:52:17.878091 [ 3 ] {4dffadb5-f620-4f77-9663-fc2e8473ec78} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
476 | 2024.10.09 22:52:17.880805 [ 3 ] {4dffadb5-f620-4f77-9663-fc2e8473ec78} <Debug> oximeter.measurements_histogrami8 (994d7bb9-e492-4b12-92e1-bea928a06e45): Loading data parts | ||
477 | 2024.10.09 22:52:17.881137 [ 3 ] {4dffadb5-f620-4f77-9663-fc2e8473ec78} <Debug> oximeter.measurements_histogrami8 (994d7bb9-e492-4b12-92e1-bea928a06e45): There are no data parts | ||
478 | 2024.10.09 22:52:17.882907 [ 3 ] {4dffadb5-f620-4f77-9663-fc2e8473ec78} <Debug> DynamicQueryHandler: Done processing query | ||
479 | 2024.10.09 22:52:17.882937 [ 3 ] {} <Debug> HTTP-Session: afe9a512-ddf5-43c3-bb42-eafa3bf1a320 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
480 | 2024.10.09 22:52:17.932534 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
481 | 2024.10.09 22:52:17.932645 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
482 | 2024.10.09 22:52:17.932713 [ 3 ] {} <Debug> HTTP-Session: 61426078-f527-41f0-8389-5453a4b554e2 Authenticating user 'default' from [::1]:45501 | ||
483 | 2024.10.09 22:52:17.932785 [ 3 ] {} <Debug> HTTP-Session: 61426078-f527-41f0-8389-5453a4b554e2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
484 | 2024.10.09 22:52:17.932825 [ 3 ] {} <Debug> HTTP-Session: 61426078-f527-41f0-8389-5453a4b554e2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
485 | 2024.10.09 22:52:17.932903 [ 3 ] {} <Trace> HTTP-Session: 61426078-f527-41f0-8389-5453a4b554e2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
486 | 2024.10.09 22:52:17.933522 [ 3 ] {9df07795-c0b4-4069-9130-fff00008a3e7} <Debug> executeQuery: (from [::1]:45501) 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) | ||
487 | 2024.10.09 22:52:17.933630 [ 3 ] {9df07795-c0b4-4069-9130-fff00008a3e7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
488 | 2024.10.09 22:52:17.936750 [ 3 ] {9df07795-c0b4-4069-9130-fff00008a3e7} <Debug> oximeter.measurements_histogramu8 (d15140ad-748b-4815-adb0-e90eac394cf0): Loading data parts | ||
489 | 2024.10.09 22:52:17.937147 [ 3 ] {9df07795-c0b4-4069-9130-fff00008a3e7} <Debug> oximeter.measurements_histogramu8 (d15140ad-748b-4815-adb0-e90eac394cf0): There are no data parts | ||
490 | 2024.10.09 22:52:17.939187 [ 3 ] {9df07795-c0b4-4069-9130-fff00008a3e7} <Debug> DynamicQueryHandler: Done processing query | ||
491 | 2024.10.09 22:52:17.939219 [ 3 ] {} <Debug> HTTP-Session: 61426078-f527-41f0-8389-5453a4b554e2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
492 | 2024.10.09 22:52:17.939954 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
493 | 2024.10.09 22:52:17.940103 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
494 | 2024.10.09 22:52:17.940143 [ 3 ] {} <Debug> HTTP-Session: ea1e4f94-cece-4645-a90a-53c2862d3a3b Authenticating user 'default' from [::1]:45501 | ||
495 | 2024.10.09 22:52:17.940170 [ 3 ] {} <Debug> HTTP-Session: ea1e4f94-cece-4645-a90a-53c2862d3a3b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
496 | 2024.10.09 22:52:17.940188 [ 3 ] {} <Debug> HTTP-Session: ea1e4f94-cece-4645-a90a-53c2862d3a3b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
497 | 2024.10.09 22:52:17.940256 [ 3 ] {} <Trace> HTTP-Session: ea1e4f94-cece-4645-a90a-53c2862d3a3b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
498 | 2024.10.09 22:52:17.940760 [ 3 ] {cc800561-b873-45c6-88ba-e7c30464f28a} <Debug> executeQuery: (from [::1]:45501) 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) | ||
499 | 2024.10.09 22:52:17.940860 [ 3 ] {cc800561-b873-45c6-88ba-e7c30464f28a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
500 | 2024.10.09 22:52:17.943881 [ 3 ] {cc800561-b873-45c6-88ba-e7c30464f28a} <Debug> oximeter.measurements_histogrami16 (c48f95aa-a19a-4b3e-b1bd-17bc426313f3): Loading data parts | ||
501 | 2024.10.09 22:52:17.944235 [ 3 ] {cc800561-b873-45c6-88ba-e7c30464f28a} <Debug> oximeter.measurements_histogrami16 (c48f95aa-a19a-4b3e-b1bd-17bc426313f3): There are no data parts | ||
502 | 2024.10.09 22:52:17.946092 [ 3 ] {cc800561-b873-45c6-88ba-e7c30464f28a} <Debug> DynamicQueryHandler: Done processing query | ||
503 | 2024.10.09 22:52:17.946123 [ 3 ] {} <Debug> HTTP-Session: ea1e4f94-cece-4645-a90a-53c2862d3a3b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
504 | 2024.10.09 22:52:17.946795 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
505 | 2024.10.09 22:52:17.946880 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
506 | 2024.10.09 22:52:17.946905 [ 3 ] {} <Debug> HTTP-Session: 1713d838-00e6-4a33-b66a-e39784e191f0 Authenticating user 'default' from [::1]:45501 | ||
507 | 2024.10.09 22:52:17.946938 [ 3 ] {} <Debug> HTTP-Session: 1713d838-00e6-4a33-b66a-e39784e191f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
508 | 2024.10.09 22:52:17.946954 [ 3 ] {} <Debug> HTTP-Session: 1713d838-00e6-4a33-b66a-e39784e191f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
509 | 2024.10.09 22:52:17.946998 [ 3 ] {} <Trace> HTTP-Session: 1713d838-00e6-4a33-b66a-e39784e191f0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
510 | 2024.10.09 22:52:17.947476 [ 3 ] {61596d13-cd32-48c9-b4d1-220e49fec160} <Debug> executeQuery: (from [::1]:45501) 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) | ||
511 | 2024.10.09 22:52:17.947573 [ 3 ] {61596d13-cd32-48c9-b4d1-220e49fec160} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
512 | 2024.10.09 22:52:17.950591 [ 3 ] {61596d13-cd32-48c9-b4d1-220e49fec160} <Debug> oximeter.measurements_histogramu16 (4a6fd2fe-a528-4cee-90a9-efbcec2ca789): Loading data parts | ||
513 | 2024.10.09 22:52:17.950886 [ 3 ] {61596d13-cd32-48c9-b4d1-220e49fec160} <Debug> oximeter.measurements_histogramu16 (4a6fd2fe-a528-4cee-90a9-efbcec2ca789): There are no data parts | ||
514 | 2024.10.09 22:52:17.952853 [ 3 ] {61596d13-cd32-48c9-b4d1-220e49fec160} <Debug> DynamicQueryHandler: Done processing query | ||
515 | 2024.10.09 22:52:17.952897 [ 3 ] {} <Debug> HTTP-Session: 1713d838-00e6-4a33-b66a-e39784e191f0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
516 | 2024.10.09 22:52:17.953497 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
517 | 2024.10.09 22:52:17.953576 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
518 | 2024.10.09 22:52:17.953609 [ 3 ] {} <Debug> HTTP-Session: 1e7e7f09-2c30-436b-b9b5-956767eec088 Authenticating user 'default' from [::1]:45501 | ||
519 | 2024.10.09 22:52:17.953633 [ 3 ] {} <Debug> HTTP-Session: 1e7e7f09-2c30-436b-b9b5-956767eec088 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
520 | 2024.10.09 22:52:17.953649 [ 3 ] {} <Debug> HTTP-Session: 1e7e7f09-2c30-436b-b9b5-956767eec088 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
521 | 2024.10.09 22:52:17.953699 [ 3 ] {} <Trace> HTTP-Session: 1e7e7f09-2c30-436b-b9b5-956767eec088 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
522 | 2024.10.09 22:52:17.954149 [ 3 ] {953ec029-b74d-4c4e-8e96-37f54b92434e} <Debug> executeQuery: (from [::1]:45501) 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) | ||
523 | 2024.10.09 22:52:17.954238 [ 3 ] {953ec029-b74d-4c4e-8e96-37f54b92434e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
524 | 2024.10.09 22:52:17.956902 [ 3 ] {953ec029-b74d-4c4e-8e96-37f54b92434e} <Debug> oximeter.measurements_histogrami32 (6647a27b-2320-4d90-b6c1-ee54cf899f00): Loading data parts | ||
525 | 2024.10.09 22:52:17.957184 [ 3 ] {953ec029-b74d-4c4e-8e96-37f54b92434e} <Debug> oximeter.measurements_histogrami32 (6647a27b-2320-4d90-b6c1-ee54cf899f00): There are no data parts | ||
526 | 2024.10.09 22:52:17.959025 [ 3 ] {953ec029-b74d-4c4e-8e96-37f54b92434e} <Debug> DynamicQueryHandler: Done processing query | ||
527 | 2024.10.09 22:52:17.959058 [ 3 ] {} <Debug> HTTP-Session: 1e7e7f09-2c30-436b-b9b5-956767eec088 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
528 | 2024.10.09 22:52:17.959715 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
529 | 2024.10.09 22:52:17.959788 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
530 | 2024.10.09 22:52:17.959805 [ 3 ] {} <Debug> HTTP-Session: 4613d87b-7b9f-4dc0-8b69-be9d1c6da3c4 Authenticating user 'default' from [::1]:45501 | ||
531 | 2024.10.09 22:52:17.959822 [ 3 ] {} <Debug> HTTP-Session: 4613d87b-7b9f-4dc0-8b69-be9d1c6da3c4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
532 | 2024.10.09 22:52:17.959840 [ 3 ] {} <Debug> HTTP-Session: 4613d87b-7b9f-4dc0-8b69-be9d1c6da3c4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
533 | 2024.10.09 22:52:17.959874 [ 3 ] {} <Trace> HTTP-Session: 4613d87b-7b9f-4dc0-8b69-be9d1c6da3c4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
534 | 2024.10.09 22:52:17.960244 [ 3 ] {b11ae782-0e34-408b-b9c4-b5d7ddf0ebaf} <Debug> executeQuery: (from [::1]:45501) 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) | ||
535 | 2024.10.09 22:52:17.960343 [ 3 ] {b11ae782-0e34-408b-b9c4-b5d7ddf0ebaf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
536 | 2024.10.09 22:52:17.963249 [ 3 ] {b11ae782-0e34-408b-b9c4-b5d7ddf0ebaf} <Debug> oximeter.measurements_histogramu32 (fe9641b5-b8e9-416d-8e56-f3dbacf62a9b): Loading data parts | ||
537 | 2024.10.09 22:52:17.963511 [ 3 ] {b11ae782-0e34-408b-b9c4-b5d7ddf0ebaf} <Debug> oximeter.measurements_histogramu32 (fe9641b5-b8e9-416d-8e56-f3dbacf62a9b): There are no data parts | ||
538 | 2024.10.09 22:52:17.965364 [ 3 ] {b11ae782-0e34-408b-b9c4-b5d7ddf0ebaf} <Debug> DynamicQueryHandler: Done processing query | ||
539 | 2024.10.09 22:52:17.965395 [ 3 ] {} <Debug> HTTP-Session: 4613d87b-7b9f-4dc0-8b69-be9d1c6da3c4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
540 | 2024.10.09 22:52:17.966001 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
541 | 2024.10.09 22:52:17.966068 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
542 | 2024.10.09 22:52:17.966103 [ 3 ] {} <Debug> HTTP-Session: d38b53c0-30da-4178-9f27-4fde9501182c Authenticating user 'default' from [::1]:45501 | ||
543 | 2024.10.09 22:52:17.966123 [ 3 ] {} <Debug> HTTP-Session: d38b53c0-30da-4178-9f27-4fde9501182c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
544 | 2024.10.09 22:52:17.966135 [ 3 ] {} <Debug> HTTP-Session: d38b53c0-30da-4178-9f27-4fde9501182c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
545 | 2024.10.09 22:52:17.966175 [ 3 ] {} <Trace> HTTP-Session: d38b53c0-30da-4178-9f27-4fde9501182c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
546 | 2024.10.09 22:52:17.966607 [ 3 ] {41fab0be-28af-4126-9c80-9048ac40f4cb} <Debug> executeQuery: (from [::1]:45501) 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) | ||
547 | 2024.10.09 22:52:17.966703 [ 3 ] {41fab0be-28af-4126-9c80-9048ac40f4cb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
548 | 2024.10.09 22:52:17.969395 [ 3 ] {41fab0be-28af-4126-9c80-9048ac40f4cb} <Debug> oximeter.measurements_histogrami64 (a677403a-b019-4f45-8ae9-f930fe651c80): Loading data parts | ||
549 | 2024.10.09 22:52:17.969732 [ 3 ] {41fab0be-28af-4126-9c80-9048ac40f4cb} <Debug> oximeter.measurements_histogrami64 (a677403a-b019-4f45-8ae9-f930fe651c80): There are no data parts | ||
550 | 2024.10.09 22:52:17.974541 [ 3 ] {41fab0be-28af-4126-9c80-9048ac40f4cb} <Debug> DynamicQueryHandler: Done processing query | ||
551 | 2024.10.09 22:52:17.974576 [ 3 ] {} <Debug> HTTP-Session: d38b53c0-30da-4178-9f27-4fde9501182c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
552 | 2024.10.09 22:52:17.975968 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
553 | 2024.10.09 22:52:17.976066 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
554 | 2024.10.09 22:52:17.976093 [ 3 ] {} <Debug> HTTP-Session: 94d46fc1-7e17-49b3-9f96-2c820a14e72a Authenticating user 'default' from [::1]:45501 | ||
555 | 2024.10.09 22:52:17.976118 [ 3 ] {} <Debug> HTTP-Session: 94d46fc1-7e17-49b3-9f96-2c820a14e72a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
556 | 2024.10.09 22:52:17.976142 [ 3 ] {} <Debug> HTTP-Session: 94d46fc1-7e17-49b3-9f96-2c820a14e72a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
557 | 2024.10.09 22:52:17.976191 [ 3 ] {} <Trace> HTTP-Session: 94d46fc1-7e17-49b3-9f96-2c820a14e72a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
558 | 2024.10.09 22:52:17.976643 [ 3 ] {fd73c23d-3f20-4b4f-b38e-6801ee61ad1c} <Debug> executeQuery: (from [::1]:45501) 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) | ||
559 | 2024.10.09 22:52:17.976739 [ 3 ] {fd73c23d-3f20-4b4f-b38e-6801ee61ad1c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
560 | 2024.10.09 22:52:17.979782 [ 3 ] {fd73c23d-3f20-4b4f-b38e-6801ee61ad1c} <Debug> oximeter.measurements_histogramu64 (810a8e96-c314-44c3-a416-a0ff7982b9ad): Loading data parts | ||
561 | 2024.10.09 22:52:17.980922 [ 3 ] {fd73c23d-3f20-4b4f-b38e-6801ee61ad1c} <Debug> oximeter.measurements_histogramu64 (810a8e96-c314-44c3-a416-a0ff7982b9ad): There are no data parts | ||
562 | 2024.10.09 22:52:17.982871 [ 3 ] {fd73c23d-3f20-4b4f-b38e-6801ee61ad1c} <Debug> DynamicQueryHandler: Done processing query | ||
563 | 2024.10.09 22:52:17.982901 [ 3 ] {} <Debug> HTTP-Session: 94d46fc1-7e17-49b3-9f96-2c820a14e72a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
564 | 2024.10.09 22:52:17.984869 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
565 | 2024.10.09 22:52:17.984981 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
566 | 2024.10.09 22:52:17.985009 [ 3 ] {} <Debug> HTTP-Session: a5d21547-5496-4d37-b35a-8c6e20bf4135 Authenticating user 'default' from [::1]:45501 | ||
567 | 2024.10.09 22:52:17.985054 [ 3 ] {} <Debug> HTTP-Session: a5d21547-5496-4d37-b35a-8c6e20bf4135 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
568 | 2024.10.09 22:52:17.985072 [ 3 ] {} <Debug> HTTP-Session: a5d21547-5496-4d37-b35a-8c6e20bf4135 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
569 | 2024.10.09 22:52:17.985152 [ 3 ] {} <Trace> HTTP-Session: a5d21547-5496-4d37-b35a-8c6e20bf4135 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
570 | 2024.10.09 22:52:17.985699 [ 3 ] {11397f50-872a-4f8e-ab4c-a71e74eca7fa} <Debug> executeQuery: (from [::1]:45501) 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) | ||
571 | 2024.10.09 22:52:17.985798 [ 3 ] {11397f50-872a-4f8e-ab4c-a71e74eca7fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
572 | 2024.10.09 22:52:17.989064 [ 3 ] {11397f50-872a-4f8e-ab4c-a71e74eca7fa} <Debug> oximeter.measurements_histogramf32 (7f594b5c-8c14-4bca-bc2c-b055d25c9527): Loading data parts | ||
573 | 2024.10.09 22:52:17.989398 [ 3 ] {11397f50-872a-4f8e-ab4c-a71e74eca7fa} <Debug> oximeter.measurements_histogramf32 (7f594b5c-8c14-4bca-bc2c-b055d25c9527): There are no data parts | ||
574 | 2024.10.09 22:52:17.991125 [ 3 ] {11397f50-872a-4f8e-ab4c-a71e74eca7fa} <Debug> DynamicQueryHandler: Done processing query | ||
575 | 2024.10.09 22:52:17.991151 [ 3 ] {} <Debug> HTTP-Session: a5d21547-5496-4d37-b35a-8c6e20bf4135 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
576 | 2024.10.09 22:52:17.992239 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
577 | 2024.10.09 22:52:17.992331 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
578 | 2024.10.09 22:52:17.992359 [ 3 ] {} <Debug> HTTP-Session: 169793ae-2339-4b0c-ab0a-40675a0831ec Authenticating user 'default' from [::1]:45501 | ||
579 | 2024.10.09 22:52:17.992383 [ 3 ] {} <Debug> HTTP-Session: 169793ae-2339-4b0c-ab0a-40675a0831ec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
580 | 2024.10.09 22:52:17.992399 [ 3 ] {} <Debug> HTTP-Session: 169793ae-2339-4b0c-ab0a-40675a0831ec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
581 | 2024.10.09 22:52:17.992452 [ 3 ] {} <Trace> HTTP-Session: 169793ae-2339-4b0c-ab0a-40675a0831ec Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
582 | 2024.10.09 22:52:17.993143 [ 3 ] {59332a3b-5366-4320-af0a-a2b547cb82d4} <Debug> executeQuery: (from [::1]:45501) 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) | ||
583 | 2024.10.09 22:52:17.993241 [ 3 ] {59332a3b-5366-4320-af0a-a2b547cb82d4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
584 | 2024.10.09 22:52:17.996274 [ 3 ] {59332a3b-5366-4320-af0a-a2b547cb82d4} <Debug> oximeter.measurements_histogramf64 (48595898-3c46-42ee-b41b-3fee52284cd1): Loading data parts | ||
585 | 2024.10.09 22:52:17.996636 [ 3 ] {59332a3b-5366-4320-af0a-a2b547cb82d4} <Debug> oximeter.measurements_histogramf64 (48595898-3c46-42ee-b41b-3fee52284cd1): There are no data parts | ||
586 | 2024.10.09 22:52:17.999057 [ 3 ] {59332a3b-5366-4320-af0a-a2b547cb82d4} <Debug> DynamicQueryHandler: Done processing query | ||
587 | 2024.10.09 22:52:17.999086 [ 3 ] {} <Debug> HTTP-Session: 169793ae-2339-4b0c-ab0a-40675a0831ec Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
588 | 2024.10.09 22:52:17.999934 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
589 | 2024.10.09 22:52:18.000259 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 131.03 MiB, peak 131.04 MiB, free memory in arenas 0.00 B, will set to 134.24 MiB (RSS), difference: 3.21 MiB | ||
590 | 2024.10.09 22:52:18.000756 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
591 | 2024.10.09 22:52:18.000806 [ 3 ] {} <Debug> HTTP-Session: 817cfdc0-9c95-4fee-a51d-97c5c80cb9cf Authenticating user 'default' from [::1]:45501 | ||
592 | 2024.10.09 22:52:18.000832 [ 3 ] {} <Debug> HTTP-Session: 817cfdc0-9c95-4fee-a51d-97c5c80cb9cf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
593 | 2024.10.09 22:52:18.000847 [ 3 ] {} <Debug> HTTP-Session: 817cfdc0-9c95-4fee-a51d-97c5c80cb9cf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
594 | 2024.10.09 22:52:18.000957 [ 3 ] {} <Trace> HTTP-Session: 817cfdc0-9c95-4fee-a51d-97c5c80cb9cf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
595 | 2024.10.09 22:52:18.001298 [ 3 ] {b341e762-8d8e-47d7-80ea-68cab2923c1f} <Debug> executeQuery: (from [::1]:45501) /* The field tables store named dimensions of each timeseries. | ||
596 | * | ||
597 | * As with the measurement tables, there is one field table for each field data | ||
598 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
599 | * this behavior **must not** be relied upon for query correctness. | ||
600 | * | ||
601 | * The index for the fields differs from the measurements, however. Rows are | ||
602 | * sorted by timeseries name, then field name, field value, and finally | ||
603 | * timeseries key. This reflects the most common pattern for looking them up: | ||
604 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
605 | * usually then used to look up measurements. | ||
606 | * | ||
607 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
608 | * timeseries name and then key, since it would improve lookups where one | ||
609 | * already has the key. Realistically though, these tables are quite small and | ||
610 | * so performance benefits will be low in absolute terms. | ||
611 | * | ||
612 | * TTL: We use a materialized column to expire old field table records. This | ||
613 | * column is generated automatically by the database whenever a new row is | ||
614 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
615 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
616 | * record will remain during a deduplication, which will have the last | ||
617 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
618 | * measurement tables. | ||
619 | */ | ||
620 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
621 | 2024.10.09 22:52:18.001378 [ 3 ] {b341e762-8d8e-47d7-80ea-68cab2923c1f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
622 | 2024.10.09 22:52:18.004351 [ 3 ] {b341e762-8d8e-47d7-80ea-68cab2923c1f} <Debug> oximeter.fields_bool (21b1d5a5-ff67-4c6a-8525-006e582f55b8): Loading data parts | ||
623 | 2024.10.09 22:52:18.004724 [ 3 ] {b341e762-8d8e-47d7-80ea-68cab2923c1f} <Debug> oximeter.fields_bool (21b1d5a5-ff67-4c6a-8525-006e582f55b8): There are no data parts | ||
624 | 2024.10.09 22:52:18.007317 [ 3 ] {b341e762-8d8e-47d7-80ea-68cab2923c1f} <Debug> DynamicQueryHandler: Done processing query | ||
625 | 2024.10.09 22:52:18.007351 [ 3 ] {} <Debug> HTTP-Session: 817cfdc0-9c95-4fee-a51d-97c5c80cb9cf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
626 | 2024.10.09 22:52:18.008333 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
627 | 2024.10.09 22:52:18.008414 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
628 | 2024.10.09 22:52:18.008441 [ 3 ] {} <Debug> HTTP-Session: 1e95c6d9-e9bd-40f3-a745-9d4921214c0c Authenticating user 'default' from [::1]:45501 | ||
629 | 2024.10.09 22:52:18.008465 [ 3 ] {} <Debug> HTTP-Session: 1e95c6d9-e9bd-40f3-a745-9d4921214c0c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
630 | 2024.10.09 22:52:18.008484 [ 3 ] {} <Debug> HTTP-Session: 1e95c6d9-e9bd-40f3-a745-9d4921214c0c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
631 | 2024.10.09 22:52:18.008527 [ 3 ] {} <Trace> HTTP-Session: 1e95c6d9-e9bd-40f3-a745-9d4921214c0c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
632 | 2024.10.09 22:52:18.008859 [ 3 ] {5170cf01-fcda-4b82-9159-b7fbf01e8428} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
633 | 2024.10.09 22:52:18.008937 [ 3 ] {5170cf01-fcda-4b82-9159-b7fbf01e8428} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
634 | 2024.10.09 22:52:18.017280 [ 3 ] {5170cf01-fcda-4b82-9159-b7fbf01e8428} <Debug> oximeter.fields_i8 (ef08be18-bea3-4c37-a9cd-f467e71fd70e): Loading data parts | ||
635 | 2024.10.09 22:52:18.017656 [ 3 ] {5170cf01-fcda-4b82-9159-b7fbf01e8428} <Debug> oximeter.fields_i8 (ef08be18-bea3-4c37-a9cd-f467e71fd70e): There are no data parts | ||
636 | 2024.10.09 22:52:18.020989 [ 3 ] {5170cf01-fcda-4b82-9159-b7fbf01e8428} <Debug> DynamicQueryHandler: Done processing query | ||
637 | 2024.10.09 22:52:18.021023 [ 3 ] {} <Debug> HTTP-Session: 1e95c6d9-e9bd-40f3-a745-9d4921214c0c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
638 | 2024.10.09 22:52:18.025991 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
639 | 2024.10.09 22:52:18.026686 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
640 | 2024.10.09 22:52:18.026725 [ 3 ] {} <Debug> HTTP-Session: 1b16cb6f-f26a-438a-8082-82c0419a8066 Authenticating user 'default' from [::1]:45501 | ||
641 | 2024.10.09 22:52:18.026775 [ 3 ] {} <Debug> HTTP-Session: 1b16cb6f-f26a-438a-8082-82c0419a8066 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
642 | 2024.10.09 22:52:18.026795 [ 3 ] {} <Debug> HTTP-Session: 1b16cb6f-f26a-438a-8082-82c0419a8066 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
643 | 2024.10.09 22:52:18.026850 [ 3 ] {} <Trace> HTTP-Session: 1b16cb6f-f26a-438a-8082-82c0419a8066 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
644 | 2024.10.09 22:52:18.027267 [ 3 ] {8ea3d518-0d1f-4be9-83d2-8b0c7fc33db8} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
645 | 2024.10.09 22:52:18.028243 [ 3 ] {8ea3d518-0d1f-4be9-83d2-8b0c7fc33db8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
646 | 2024.10.09 22:52:18.035725 [ 3 ] {8ea3d518-0d1f-4be9-83d2-8b0c7fc33db8} <Debug> oximeter.fields_u8 (2a527c2c-db86-496d-8f69-b0c8c9c1a142): Loading data parts | ||
647 | 2024.10.09 22:52:18.036046 [ 3 ] {8ea3d518-0d1f-4be9-83d2-8b0c7fc33db8} <Debug> oximeter.fields_u8 (2a527c2c-db86-496d-8f69-b0c8c9c1a142): There are no data parts | ||
648 | 2024.10.09 22:52:18.046067 [ 3 ] {8ea3d518-0d1f-4be9-83d2-8b0c7fc33db8} <Debug> DynamicQueryHandler: Done processing query | ||
649 | 2024.10.09 22:52:18.046108 [ 3 ] {} <Debug> HTTP-Session: 1b16cb6f-f26a-438a-8082-82c0419a8066 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
650 | 2024.10.09 22:52:18.050161 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
651 | 2024.10.09 22:52:18.050285 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
652 | 2024.10.09 22:52:18.050312 [ 3 ] {} <Debug> HTTP-Session: 0b92dbe3-1eca-4295-841e-8ac66bcd40bc Authenticating user 'default' from [::1]:45501 | ||
653 | 2024.10.09 22:52:18.050338 [ 3 ] {} <Debug> HTTP-Session: 0b92dbe3-1eca-4295-841e-8ac66bcd40bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
654 | 2024.10.09 22:52:18.050352 [ 3 ] {} <Debug> HTTP-Session: 0b92dbe3-1eca-4295-841e-8ac66bcd40bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
655 | 2024.10.09 22:52:18.050466 [ 3 ] {} <Trace> HTTP-Session: 0b92dbe3-1eca-4295-841e-8ac66bcd40bc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
656 | 2024.10.09 22:52:18.050836 [ 3 ] {f8c1de9d-7bdf-40e2-a56d-f72165e065ce} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
657 | 2024.10.09 22:52:18.050919 [ 3 ] {f8c1de9d-7bdf-40e2-a56d-f72165e065ce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
658 | 2024.10.09 22:52:18.055719 [ 3 ] {f8c1de9d-7bdf-40e2-a56d-f72165e065ce} <Debug> oximeter.fields_i16 (b37ebd13-743e-4ef7-b346-28b9f8dff571): Loading data parts | ||
659 | 2024.10.09 22:52:18.056074 [ 3 ] {f8c1de9d-7bdf-40e2-a56d-f72165e065ce} <Debug> oximeter.fields_i16 (b37ebd13-743e-4ef7-b346-28b9f8dff571): There are no data parts | ||
660 | 2024.10.09 22:52:18.058311 [ 3 ] {f8c1de9d-7bdf-40e2-a56d-f72165e065ce} <Debug> DynamicQueryHandler: Done processing query | ||
661 | 2024.10.09 22:52:18.058345 [ 3 ] {} <Debug> HTTP-Session: 0b92dbe3-1eca-4295-841e-8ac66bcd40bc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
662 | 2024.10.09 22:52:18.062092 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
663 | 2024.10.09 22:52:18.062380 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
664 | 2024.10.09 22:52:18.062416 [ 3 ] {} <Debug> HTTP-Session: ffcab050-ac99-4b86-9825-a86a206bbc77 Authenticating user 'default' from [::1]:45501 | ||
665 | 2024.10.09 22:52:18.062461 [ 3 ] {} <Debug> HTTP-Session: ffcab050-ac99-4b86-9825-a86a206bbc77 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
666 | 2024.10.09 22:52:18.062481 [ 3 ] {} <Debug> HTTP-Session: ffcab050-ac99-4b86-9825-a86a206bbc77 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
667 | 2024.10.09 22:52:18.062535 [ 3 ] {} <Trace> HTTP-Session: ffcab050-ac99-4b86-9825-a86a206bbc77 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
668 | 2024.10.09 22:52:18.062890 [ 3 ] {be8a5940-2f8a-4d4f-9fd9-6edcde297f42} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
669 | 2024.10.09 22:52:18.063032 [ 3 ] {be8a5940-2f8a-4d4f-9fd9-6edcde297f42} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
670 | 2024.10.09 22:52:18.066160 [ 3 ] {be8a5940-2f8a-4d4f-9fd9-6edcde297f42} <Debug> oximeter.fields_u16 (48fd5169-68a5-49fa-b749-0a46281a62ad): Loading data parts | ||
671 | 2024.10.09 22:52:18.067818 [ 3 ] {be8a5940-2f8a-4d4f-9fd9-6edcde297f42} <Debug> oximeter.fields_u16 (48fd5169-68a5-49fa-b749-0a46281a62ad): There are no data parts | ||
672 | 2024.10.09 22:52:18.069482 [ 3 ] {be8a5940-2f8a-4d4f-9fd9-6edcde297f42} <Debug> DynamicQueryHandler: Done processing query | ||
673 | 2024.10.09 22:52:18.069538 [ 3 ] {} <Debug> HTTP-Session: ffcab050-ac99-4b86-9825-a86a206bbc77 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
674 | 2024.10.09 22:52:18.070954 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
675 | 2024.10.09 22:52:18.071034 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
676 | 2024.10.09 22:52:18.071081 [ 3 ] {} <Debug> HTTP-Session: 4cd6ce7a-7cc2-45f6-9fb5-614a2c4de14e Authenticating user 'default' from [::1]:45501 | ||
677 | 2024.10.09 22:52:18.071110 [ 3 ] {} <Debug> HTTP-Session: 4cd6ce7a-7cc2-45f6-9fb5-614a2c4de14e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
678 | 2024.10.09 22:52:18.071128 [ 3 ] {} <Debug> HTTP-Session: 4cd6ce7a-7cc2-45f6-9fb5-614a2c4de14e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
679 | 2024.10.09 22:52:18.071186 [ 3 ] {} <Trace> HTTP-Session: 4cd6ce7a-7cc2-45f6-9fb5-614a2c4de14e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
680 | 2024.10.09 22:52:18.071640 [ 3 ] {421f9f28-3f5d-45c6-b488-a0090f13ca6a} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
681 | 2024.10.09 22:52:18.071740 [ 3 ] {421f9f28-3f5d-45c6-b488-a0090f13ca6a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
682 | 2024.10.09 22:52:18.074667 [ 3 ] {421f9f28-3f5d-45c6-b488-a0090f13ca6a} <Debug> oximeter.fields_i32 (43f05375-214c-4ca6-847a-2743db151679): Loading data parts | ||
683 | 2024.10.09 22:52:18.075013 [ 3 ] {421f9f28-3f5d-45c6-b488-a0090f13ca6a} <Debug> oximeter.fields_i32 (43f05375-214c-4ca6-847a-2743db151679): There are no data parts | ||
684 | 2024.10.09 22:52:18.076938 [ 3 ] {421f9f28-3f5d-45c6-b488-a0090f13ca6a} <Debug> DynamicQueryHandler: Done processing query | ||
685 | 2024.10.09 22:52:18.076969 [ 3 ] {} <Debug> HTTP-Session: 4cd6ce7a-7cc2-45f6-9fb5-614a2c4de14e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
686 | 2024.10.09 22:52:18.077785 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
687 | 2024.10.09 22:52:18.077875 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
688 | 2024.10.09 22:52:18.077897 [ 3 ] {} <Debug> HTTP-Session: 5ec04a3c-1717-4167-8f4f-ea41e0d16191 Authenticating user 'default' from [::1]:45501 | ||
689 | 2024.10.09 22:52:18.077919 [ 3 ] {} <Debug> HTTP-Session: 5ec04a3c-1717-4167-8f4f-ea41e0d16191 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
690 | 2024.10.09 22:52:18.077942 [ 3 ] {} <Debug> HTTP-Session: 5ec04a3c-1717-4167-8f4f-ea41e0d16191 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
691 | 2024.10.09 22:52:18.077985 [ 3 ] {} <Trace> HTTP-Session: 5ec04a3c-1717-4167-8f4f-ea41e0d16191 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
692 | 2024.10.09 22:52:18.078280 [ 3 ] {3a97286a-76bf-456b-86e2-7a3b03a8690f} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
693 | 2024.10.09 22:52:18.078343 [ 3 ] {3a97286a-76bf-456b-86e2-7a3b03a8690f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
694 | 2024.10.09 22:52:18.082645 [ 3 ] {3a97286a-76bf-456b-86e2-7a3b03a8690f} <Debug> oximeter.fields_u32 (6c3e4bd9-c0f6-4217-ab3e-80f3982d3f6d): Loading data parts | ||
695 | 2024.10.09 22:52:18.082909 [ 3 ] {3a97286a-76bf-456b-86e2-7a3b03a8690f} <Debug> oximeter.fields_u32 (6c3e4bd9-c0f6-4217-ab3e-80f3982d3f6d): There are no data parts | ||
696 | 2024.10.09 22:52:18.084926 [ 3 ] {3a97286a-76bf-456b-86e2-7a3b03a8690f} <Debug> DynamicQueryHandler: Done processing query | ||
697 | 2024.10.09 22:52:18.084973 [ 3 ] {} <Debug> HTTP-Session: 5ec04a3c-1717-4167-8f4f-ea41e0d16191 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
698 | 2024.10.09 22:52:18.085594 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
699 | 2024.10.09 22:52:18.085662 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
700 | 2024.10.09 22:52:18.085704 [ 3 ] {} <Debug> HTTP-Session: 71b5a995-f95e-43ea-92a7-fe680ad4f96c Authenticating user 'default' from [::1]:45501 | ||
701 | 2024.10.09 22:52:18.085727 [ 3 ] {} <Debug> HTTP-Session: 71b5a995-f95e-43ea-92a7-fe680ad4f96c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
702 | 2024.10.09 22:52:18.085742 [ 3 ] {} <Debug> HTTP-Session: 71b5a995-f95e-43ea-92a7-fe680ad4f96c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
703 | 2024.10.09 22:52:18.085788 [ 3 ] {} <Trace> HTTP-Session: 71b5a995-f95e-43ea-92a7-fe680ad4f96c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
704 | 2024.10.09 22:52:18.086284 [ 3 ] {ad8a222e-8e1b-415a-8ed6-1dc3c41eaf54} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
705 | 2024.10.09 22:52:18.086381 [ 3 ] {ad8a222e-8e1b-415a-8ed6-1dc3c41eaf54} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
706 | 2024.10.09 22:52:18.088729 [ 3 ] {ad8a222e-8e1b-415a-8ed6-1dc3c41eaf54} <Debug> oximeter.fields_i64 (2e272a14-1ccd-4786-a44e-bb14b79b8be5): Loading data parts | ||
707 | 2024.10.09 22:52:18.089037 [ 3 ] {ad8a222e-8e1b-415a-8ed6-1dc3c41eaf54} <Debug> oximeter.fields_i64 (2e272a14-1ccd-4786-a44e-bb14b79b8be5): There are no data parts | ||
708 | 2024.10.09 22:52:18.090847 [ 3 ] {ad8a222e-8e1b-415a-8ed6-1dc3c41eaf54} <Debug> DynamicQueryHandler: Done processing query | ||
709 | 2024.10.09 22:52:18.090874 [ 3 ] {} <Debug> HTTP-Session: 71b5a995-f95e-43ea-92a7-fe680ad4f96c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
710 | 2024.10.09 22:52:18.093789 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
711 | 2024.10.09 22:52:18.093896 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
712 | 2024.10.09 22:52:18.093922 [ 3 ] {} <Debug> HTTP-Session: 18cb75a5-9cae-48b9-bc77-7b399820b70e Authenticating user 'default' from [::1]:45501 | ||
713 | 2024.10.09 22:52:18.093947 [ 3 ] {} <Debug> HTTP-Session: 18cb75a5-9cae-48b9-bc77-7b399820b70e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
714 | 2024.10.09 22:52:18.093961 [ 3 ] {} <Debug> HTTP-Session: 18cb75a5-9cae-48b9-bc77-7b399820b70e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
715 | 2024.10.09 22:52:18.094011 [ 3 ] {} <Trace> HTTP-Session: 18cb75a5-9cae-48b9-bc77-7b399820b70e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
716 | 2024.10.09 22:52:18.094517 [ 3 ] {20e48ff5-d9c2-40ef-a123-23ee1d0cc758} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
717 | 2024.10.09 22:52:18.094593 [ 3 ] {20e48ff5-d9c2-40ef-a123-23ee1d0cc758} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
718 | 2024.10.09 22:52:18.097682 [ 3 ] {20e48ff5-d9c2-40ef-a123-23ee1d0cc758} <Debug> oximeter.fields_u64 (126f4d68-2641-4b0c-b260-b58c40fec5e1): Loading data parts | ||
719 | 2024.10.09 22:52:18.097950 [ 3 ] {20e48ff5-d9c2-40ef-a123-23ee1d0cc758} <Debug> oximeter.fields_u64 (126f4d68-2641-4b0c-b260-b58c40fec5e1): There are no data parts | ||
720 | 2024.10.09 22:52:18.099734 [ 3 ] {20e48ff5-d9c2-40ef-a123-23ee1d0cc758} <Debug> DynamicQueryHandler: Done processing query | ||
721 | 2024.10.09 22:52:18.099762 [ 3 ] {} <Debug> HTTP-Session: 18cb75a5-9cae-48b9-bc77-7b399820b70e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
722 | 2024.10.09 22:52:18.100447 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
723 | 2024.10.09 22:52:18.100509 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
724 | 2024.10.09 22:52:18.100529 [ 3 ] {} <Debug> HTTP-Session: 3c04348b-4ab4-4001-b93d-296ec5cda005 Authenticating user 'default' from [::1]:45501 | ||
725 | 2024.10.09 22:52:18.100549 [ 3 ] {} <Debug> HTTP-Session: 3c04348b-4ab4-4001-b93d-296ec5cda005 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
726 | 2024.10.09 22:52:18.100562 [ 3 ] {} <Debug> HTTP-Session: 3c04348b-4ab4-4001-b93d-296ec5cda005 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
727 | 2024.10.09 22:52:18.100602 [ 3 ] {} <Trace> HTTP-Session: 3c04348b-4ab4-4001-b93d-296ec5cda005 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
728 | 2024.10.09 22:52:18.100881 [ 3 ] {edc7ff81-beee-40ba-88d9-76698e5d0a4e} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
729 | 2024.10.09 22:52:18.100939 [ 3 ] {edc7ff81-beee-40ba-88d9-76698e5d0a4e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
730 | 2024.10.09 22:52:18.103164 [ 3 ] {edc7ff81-beee-40ba-88d9-76698e5d0a4e} <Debug> oximeter.fields_ipaddr (fcd09365-c5ef-4256-afc4-57cdf0d97cde): Loading data parts | ||
731 | 2024.10.09 22:52:18.103419 [ 3 ] {edc7ff81-beee-40ba-88d9-76698e5d0a4e} <Debug> oximeter.fields_ipaddr (fcd09365-c5ef-4256-afc4-57cdf0d97cde): There are no data parts | ||
732 | 2024.10.09 22:52:18.105079 [ 3 ] {edc7ff81-beee-40ba-88d9-76698e5d0a4e} <Debug> DynamicQueryHandler: Done processing query | ||
733 | 2024.10.09 22:52:18.105106 [ 3 ] {} <Debug> HTTP-Session: 3c04348b-4ab4-4001-b93d-296ec5cda005 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
734 | 2024.10.09 22:52:18.105915 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
735 | 2024.10.09 22:52:18.105974 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
736 | 2024.10.09 22:52:18.105994 [ 3 ] {} <Debug> HTTP-Session: e0787b28-7652-47e6-9c48-d6b795d2bc0f Authenticating user 'default' from [::1]:45501 | ||
737 | 2024.10.09 22:52:18.106012 [ 3 ] {} <Debug> HTTP-Session: e0787b28-7652-47e6-9c48-d6b795d2bc0f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
738 | 2024.10.09 22:52:18.106025 [ 3 ] {} <Debug> HTTP-Session: e0787b28-7652-47e6-9c48-d6b795d2bc0f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
739 | 2024.10.09 22:52:18.106062 [ 3 ] {} <Trace> HTTP-Session: e0787b28-7652-47e6-9c48-d6b795d2bc0f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
740 | 2024.10.09 22:52:18.106303 [ 3 ] {ce49f913-f2fb-4fc1-b982-33bdf39baa30} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
741 | 2024.10.09 22:52:18.106359 [ 3 ] {ce49f913-f2fb-4fc1-b982-33bdf39baa30} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
742 | 2024.10.09 22:52:18.108647 [ 3 ] {ce49f913-f2fb-4fc1-b982-33bdf39baa30} <Debug> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Loading data parts | ||
743 | 2024.10.09 22:52:18.108901 [ 3 ] {ce49f913-f2fb-4fc1-b982-33bdf39baa30} <Debug> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): There are no data parts | ||
744 | 2024.10.09 22:52:18.110615 [ 3 ] {ce49f913-f2fb-4fc1-b982-33bdf39baa30} <Debug> DynamicQueryHandler: Done processing query | ||
745 | 2024.10.09 22:52:18.110643 [ 3 ] {} <Debug> HTTP-Session: e0787b28-7652-47e6-9c48-d6b795d2bc0f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
746 | 2024.10.09 22:52:18.111194 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
747 | 2024.10.09 22:52:18.111256 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
748 | 2024.10.09 22:52:18.111276 [ 3 ] {} <Debug> HTTP-Session: b6ff190a-205a-4cab-bc56-6043f40305c6 Authenticating user 'default' from [::1]:45501 | ||
749 | 2024.10.09 22:52:18.111295 [ 3 ] {} <Debug> HTTP-Session: b6ff190a-205a-4cab-bc56-6043f40305c6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
750 | 2024.10.09 22:52:18.111309 [ 3 ] {} <Debug> HTTP-Session: b6ff190a-205a-4cab-bc56-6043f40305c6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
751 | 2024.10.09 22:52:18.111347 [ 3 ] {} <Trace> HTTP-Session: b6ff190a-205a-4cab-bc56-6043f40305c6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
752 | 2024.10.09 22:52:18.111605 [ 3 ] {8408e1e6-94a2-4415-8a5d-c4ff53ba7310} <Debug> executeQuery: (from [::1]:45501) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
753 | 2024.10.09 22:52:18.111659 [ 3 ] {8408e1e6-94a2-4415-8a5d-c4ff53ba7310} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
754 | 2024.10.09 22:52:18.113910 [ 3 ] {8408e1e6-94a2-4415-8a5d-c4ff53ba7310} <Debug> oximeter.fields_uuid (58fc659d-0c8a-4c42-a410-30fbb54ace46): Loading data parts | ||
755 | 2024.10.09 22:52:18.114206 [ 3 ] {8408e1e6-94a2-4415-8a5d-c4ff53ba7310} <Debug> oximeter.fields_uuid (58fc659d-0c8a-4c42-a410-30fbb54ace46): There are no data parts | ||
756 | 2024.10.09 22:52:18.115854 [ 3 ] {8408e1e6-94a2-4415-8a5d-c4ff53ba7310} <Debug> DynamicQueryHandler: Done processing query | ||
757 | 2024.10.09 22:52:18.115889 [ 3 ] {} <Debug> HTTP-Session: b6ff190a-205a-4cab-bc56-6043f40305c6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
758 | 2024.10.09 22:52:18.116328 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
759 | 2024.10.09 22:52:18.116394 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
760 | 2024.10.09 22:52:18.116419 [ 3 ] {} <Debug> HTTP-Session: 94981894-2589-487b-a65f-8bc906dd5c98 Authenticating user 'default' from [::1]:45501 | ||
761 | 2024.10.09 22:52:18.116440 [ 3 ] {} <Debug> HTTP-Session: 94981894-2589-487b-a65f-8bc906dd5c98 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
762 | 2024.10.09 22:52:18.116456 [ 3 ] {} <Debug> HTTP-Session: 94981894-2589-487b-a65f-8bc906dd5c98 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
763 | 2024.10.09 22:52:18.116547 [ 3 ] {} <Trace> HTTP-Session: 94981894-2589-487b-a65f-8bc906dd5c98 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
764 | 2024.10.09 22:52:18.116970 [ 3 ] {793cd308-3fc6-4d63-b45a-5db707db7d80} <Debug> executeQuery: (from [::1]:45501) /* The timeseries schema table stores the extracted schema for the samples | ||
765 | * oximeter collects. | ||
766 | */ | ||
767 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
768 | 2024.10.09 22:52:18.117053 [ 3 ] {793cd308-3fc6-4d63-b45a-5db707db7d80} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
769 | 2024.10.09 22:52:18.119261 [ 3 ] {793cd308-3fc6-4d63-b45a-5db707db7d80} <Debug> oximeter.timeseries_schema (76eb52cc-0909-486c-8961-23576b9aa710): Loading data parts | ||
770 | 2024.10.09 22:52:18.119515 [ 3 ] {793cd308-3fc6-4d63-b45a-5db707db7d80} <Debug> oximeter.timeseries_schema (76eb52cc-0909-486c-8961-23576b9aa710): There are no data parts | ||
771 | 2024.10.09 22:52:18.121362 [ 3 ] {793cd308-3fc6-4d63-b45a-5db707db7d80} <Debug> DynamicQueryHandler: Done processing query | ||
772 | 2024.10.09 22:52:18.121388 [ 3 ] {} <Debug> HTTP-Session: 94981894-2589-487b-a65f-8bc906dd5c98 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
773 | 2024.10.09 22:52:18.121871 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
774 | 2024.10.09 22:52:18.121929 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
775 | 2024.10.09 22:52:18.121948 [ 3 ] {} <Debug> HTTP-Session: b80694aa-1d3a-471d-97b6-e1e04edc82db Authenticating user 'default' from [::1]:45501 | ||
776 | 2024.10.09 22:52:18.121965 [ 3 ] {} <Debug> HTTP-Session: b80694aa-1d3a-471d-97b6-e1e04edc82db Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
777 | 2024.10.09 22:52:18.121979 [ 3 ] {} <Debug> HTTP-Session: b80694aa-1d3a-471d-97b6-e1e04edc82db Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
778 | 2024.10.09 22:52:18.122012 [ 3 ] {} <Trace> HTTP-Session: b80694aa-1d3a-471d-97b6-e1e04edc82db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
779 | 2024.10.09 22:52:18.122253 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
780 | 2024.10.09 22:52:18.122430 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
781 | 2024.10.09 22:52:18.124026 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Trace> oximeter.version (dbfb0f09-44c8-44fd-83f2-7b580a37864e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
782 | 2024.10.09 22:52:18.124080 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
783 | 2024.10.09 22:52:18.124983 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
784 | 2024.10.09 22:52:18.125682 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Trace> oximeter.version (dbfb0f09-44c8-44fd-83f2-7b580a37864e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
785 | 2024.10.09 22:52:18.125999 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003895 sec., 256.73940949935815 rows/sec., 4.01 KiB/sec. | ||
786 | 2024.10.09 22:52:18.126228 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Debug> DynamicQueryHandler: Done processing query | ||
787 | 2024.10.09 22:52:18.126261 [ 3 ] {86779997-f02b-4bf2-b5b5-d19d7eeb84f3} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
788 | 2024.10.09 22:52:18.126279 [ 3 ] {} <Debug> HTTP-Session: b80694aa-1d3a-471d-97b6-e1e04edc82db Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
789 | 2024.10.09 22:52:19.000437 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 134.36 MiB, peak 139.50 MiB, free memory in arenas 0.00 B, will set to 135.66 MiB (RSS), difference: 1.30 MiB | ||
790 | 2024.10.09 22:52:20.203114 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 60, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
791 | 2024.10.09 22:52:20.203239 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
792 | 2024.10.09 22:52:20.203271 [ 3 ] {} <Debug> HTTP-Session: 66570316-b48f-476c-b87c-5801aada77d6 Authenticating user 'default' from [::1]:45501 | ||
793 | 2024.10.09 22:52:20.203298 [ 3 ] {} <Debug> HTTP-Session: 66570316-b48f-476c-b87c-5801aada77d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
794 | 2024.10.09 22:52:20.203310 [ 3 ] {} <Debug> HTTP-Session: 66570316-b48f-476c-b87c-5801aada77d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
795 | 2024.10.09 22:52:20.203354 [ 3 ] {} <Trace> HTTP-Session: 66570316-b48f-476c-b87c-5801aada77d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
796 | 2024.10.09 22:52:20.203583 [ 3 ] {f908d259-8673-4c1f-8732-923cf7b73e37} <Debug> executeQuery: (from [::1]:45501) SELECT * FROM oximeter.timeseries_schema FORMAT JSONEachRow; (stage: Complete) | ||
797 | 2024.10.09 22:52:20.204043 [ 3 ] {f908d259-8673-4c1f-8732-923cf7b73e37} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
798 | 2024.10.09 22:52:20.204188 [ 3 ] {f908d259-8673-4c1f-8732-923cf7b73e37} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
799 | 2024.10.09 22:52:20.206587 [ 3 ] {f908d259-8673-4c1f-8732-923cf7b73e37} <Debug> DynamicQueryHandler: Done processing query | ||
800 | 2024.10.09 22:52:20.206624 [ 3 ] {f908d259-8673-4c1f-8732-923cf7b73e37} <Debug> MemoryTracker: Peak memory usage (for query): 3.00 MiB. | ||
801 | 2024.10.09 22:52:20.206645 [ 3 ] {} <Debug> HTTP-Session: 66570316-b48f-476c-b87c-5801aada77d6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
802 | 2024.10.09 22:52:20.208283 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
803 | 2024.10.09 22:52:20.208361 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
804 | 2024.10.09 22:52:20.208384 [ 3 ] {} <Debug> HTTP-Session: 77bebe4f-4e9c-4d03-b8dd-3eda54710ad0 Authenticating user 'default' from [::1]:45501 | ||
805 | 2024.10.09 22:52:20.208406 [ 3 ] {} <Debug> HTTP-Session: 77bebe4f-4e9c-4d03-b8dd-3eda54710ad0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
806 | 2024.10.09 22:52:20.208420 [ 3 ] {} <Debug> HTTP-Session: 77bebe4f-4e9c-4d03-b8dd-3eda54710ad0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
807 | 2024.10.09 22:52:20.208467 [ 3 ] {} <Trace> HTTP-Session: 77bebe4f-4e9c-4d03-b8dd-3eda54710ad0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
808 | 2024.10.09 22:52:20.208649 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.timeseries_schema FORMAT JSONEachRow (stage: Complete) | ||
809 | 2024.10.09 22:52:20.208721 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema | ||
810 | 2024.10.09 22:52:20.208951 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
811 | 2024.10.09 22:52:20.209503 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Trace> oximeter.timeseries_schema (76eb52cc-0909-486c-8961-23576b9aa710): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
812 | 2024.10.09 22:52:20.209554 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
813 | 2024.10.09 22:52:20.210383 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
814 | 2024.10.09 22:52:20.210918 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Trace> oximeter.timeseries_schema (76eb52cc-0909-486c-8961-23576b9aa710): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
815 | 2024.10.09 22:52:20.211144 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.002554 sec., 391.5426781519186 rows/sec., 47.03 KiB/sec. | ||
816 | 2024.10.09 22:52:20.211462 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Debug> DynamicQueryHandler: Done processing query | ||
817 | 2024.10.09 22:52:20.211492 [ 3 ] {e729d4a5-4e47-4a02-a7ba-6b2e16928388} <Debug> MemoryTracker: Peak memory usage (for query): 4.25 MiB. | ||
818 | 2024.10.09 22:52:20.211511 [ 3 ] {} <Debug> HTTP-Session: 77bebe4f-4e9c-4d03-b8dd-3eda54710ad0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
819 | 2024.10.09 22:52:20.216525 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
820 | 2024.10.09 22:52:20.216640 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
821 | 2024.10.09 22:52:20.216665 [ 3 ] {} <Debug> HTTP-Session: 51d89b91-06a4-4e63-aa6c-b1b672c308ec Authenticating user 'default' from [::1]:45501 | ||
822 | 2024.10.09 22:52:20.216688 [ 3 ] {} <Debug> HTTP-Session: 51d89b91-06a4-4e63-aa6c-b1b672c308ec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
823 | 2024.10.09 22:52:20.216737 [ 3 ] {} <Debug> HTTP-Session: 51d89b91-06a4-4e63-aa6c-b1b672c308ec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
824 | 2024.10.09 22:52:20.216798 [ 3 ] {} <Trace> HTTP-Session: 51d89b91-06a4-4e63-aa6c-b1b672c308ec Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
825 | 2024.10.09 22:52:20.217074 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete) | ||
826 | 2024.10.09 22:52:20.217161 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
827 | 2024.10.09 22:52:20.217654 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
828 | 2024.10.09 22:52:20.218279 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
829 | 2024.10.09 22:52:20.218332 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
830 | 2024.10.09 22:52:20.218956 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
831 | 2024.10.09 22:52:20.219702 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
832 | 2024.10.09 22:52:20.219928 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002926 sec., 683.5269993164729 rows/sec., 70.76 KiB/sec. | ||
833 | 2024.10.09 22:52:20.220183 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Debug> DynamicQueryHandler: Done processing query | ||
834 | 2024.10.09 22:52:20.220210 [ 3 ] {c68f819f-a489-4b56-a1ce-316c07a875eb} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB. | ||
835 | 2024.10.09 22:52:20.220228 [ 3 ] {} <Debug> HTTP-Session: 51d89b91-06a4-4e63-aa6c-b1b672c308ec Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
836 | 2024.10.09 22:52:20.221552 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
837 | 2024.10.09 22:52:20.221657 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
838 | 2024.10.09 22:52:20.221683 [ 3 ] {} <Debug> HTTP-Session: 9499f545-cc40-451d-bca2-398725043e2e Authenticating user 'default' from [::1]:45501 | ||
839 | 2024.10.09 22:52:20.221707 [ 3 ] {} <Debug> HTTP-Session: 9499f545-cc40-451d-bca2-398725043e2e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
840 | 2024.10.09 22:52:20.221722 [ 3 ] {} <Debug> HTTP-Session: 9499f545-cc40-451d-bca2-398725043e2e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
841 | 2024.10.09 22:52:20.221774 [ 3 ] {} <Trace> HTTP-Session: 9499f545-cc40-451d-bca2-398725043e2e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
842 | 2024.10.09 22:52:20.221957 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete) | ||
843 | 2024.10.09 22:52:20.222054 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
844 | 2024.10.09 22:52:20.222285 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
845 | 2024.10.09 22:52:20.222705 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
846 | 2024.10.09 22:52:20.222743 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
847 | 2024.10.09 22:52:20.223353 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
848 | 2024.10.09 22:52:20.223843 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
849 | 2024.10.09 22:52:20.224038 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002138 sec., 467.72684752104766 rows/sec., 32.43 KiB/sec. | ||
850 | 2024.10.09 22:52:20.224282 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Debug> DynamicQueryHandler: Done processing query | ||
851 | 2024.10.09 22:52:20.224311 [ 3 ] {2c288d6c-bfe7-4e2b-af5d-2a4edb027461} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
852 | 2024.10.09 22:52:20.224329 [ 3 ] {} <Debug> HTTP-Session: 9499f545-cc40-451d-bca2-398725043e2e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
853 | 2024.10.09 22:52:20.842695 [ 201 ] {} <Debug> DNSResolver: Updating DNS cache | ||
854 | 2024.10.09 22:52:20.842774 [ 201 ] {} <Debug> DNSResolver: Updated DNS cache | ||
855 | 2024.10.09 22:52:21.000235 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 135.96 MiB, peak 141.10 MiB, free memory in arenas 0.00 B, will set to 137.22 MiB (RSS), difference: 1.26 MiB | ||
856 | 2024.10.09 22:52:21.203090 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
857 | 2024.10.09 22:52:21.203243 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
858 | 2024.10.09 22:52:21.203272 [ 3 ] {} <Debug> HTTP-Session: f983a7b6-4359-4740-b0a0-c794c92b09af Authenticating user 'default' from [::1]:45501 | ||
859 | 2024.10.09 22:52:21.203300 [ 3 ] {} <Debug> HTTP-Session: f983a7b6-4359-4740-b0a0-c794c92b09af Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
860 | 2024.10.09 22:52:21.203317 [ 3 ] {} <Debug> HTTP-Session: f983a7b6-4359-4740-b0a0-c794c92b09af Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
861 | 2024.10.09 22:52:21.203377 [ 3 ] {} <Trace> HTTP-Session: f983a7b6-4359-4740-b0a0-c794c92b09af Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
862 | 2024.10.09 22:52:21.203613 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete) | ||
863 | 2024.10.09 22:52:21.203695 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
864 | 2024.10.09 22:52:21.204144 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
865 | 2024.10.09 22:52:21.204744 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
866 | 2024.10.09 22:52:21.204798 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
867 | 2024.10.09 22:52:21.205506 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
868 | 2024.10.09 22:52:21.206130 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
869 | 2024.10.09 22:52:21.206358 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.00282 sec., 709.2198581560284 rows/sec., 73.42 KiB/sec. | ||
870 | 2024.10.09 22:52:21.206645 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Debug> DynamicQueryHandler: Done processing query | ||
871 | 2024.10.09 22:52:21.206676 [ 3 ] {69af042b-1181-4796-8c0b-25b650d071c3} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB. | ||
872 | 2024.10.09 22:52:21.206695 [ 3 ] {} <Debug> HTTP-Session: f983a7b6-4359-4740-b0a0-c794c92b09af Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
873 | 2024.10.09 22:52:21.207482 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
874 | 2024.10.09 22:52:21.207552 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
875 | 2024.10.09 22:52:21.207601 [ 3 ] {} <Debug> HTTP-Session: e11be7e0-b9d9-4001-9a05-e47a957aa47a Authenticating user 'default' from [::1]:45501 | ||
876 | 2024.10.09 22:52:21.207624 [ 3 ] {} <Debug> HTTP-Session: e11be7e0-b9d9-4001-9a05-e47a957aa47a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
877 | 2024.10.09 22:52:21.207641 [ 3 ] {} <Debug> HTTP-Session: e11be7e0-b9d9-4001-9a05-e47a957aa47a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
878 | 2024.10.09 22:52:21.207689 [ 3 ] {} <Trace> HTTP-Session: e11be7e0-b9d9-4001-9a05-e47a957aa47a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
879 | 2024.10.09 22:52:21.207855 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete) | ||
880 | 2024.10.09 22:52:21.207924 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
881 | 2024.10.09 22:52:21.208153 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
882 | 2024.10.09 22:52:21.208547 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
883 | 2024.10.09 22:52:21.208594 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
884 | 2024.10.09 22:52:21.209198 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary) | ||
885 | 2024.10.09 22:52:21.209778 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
886 | 2024.10.09 22:52:21.209992 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002181 sec., 458.5052728106373 rows/sec., 31.79 KiB/sec. | ||
887 | 2024.10.09 22:52:21.210271 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Debug> DynamicQueryHandler: Done processing query | ||
888 | 2024.10.09 22:52:21.210298 [ 3 ] {b9ac1311-7b98-4842-bfa4-bf98e4e28365} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
889 | 2024.10.09 22:52:21.210316 [ 3 ] {} <Debug> HTTP-Session: e11be7e0-b9d9-4001-9a05-e47a957aa47a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
890 | 2024.10.09 22:52:22.203544 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
891 | 2024.10.09 22:52:22.203668 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
892 | 2024.10.09 22:52:22.203694 [ 3 ] {} <Debug> HTTP-Session: d02dabc8-ff93-47d0-b893-801d523af8eb Authenticating user 'default' from [::1]:45501 | ||
893 | 2024.10.09 22:52:22.203745 [ 3 ] {} <Debug> HTTP-Session: d02dabc8-ff93-47d0-b893-801d523af8eb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
894 | 2024.10.09 22:52:22.203760 [ 3 ] {} <Debug> HTTP-Session: d02dabc8-ff93-47d0-b893-801d523af8eb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
895 | 2024.10.09 22:52:22.203814 [ 3 ] {} <Trace> HTTP-Session: d02dabc8-ff93-47d0-b893-801d523af8eb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
896 | 2024.10.09 22:52:22.204033 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete) | ||
897 | 2024.10.09 22:52:22.204110 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
898 | 2024.10.09 22:52:22.204545 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
899 | 2024.10.09 22:52:22.205077 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
900 | 2024.10.09 22:52:22.205122 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
901 | 2024.10.09 22:52:22.205937 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
902 | 2024.10.09 22:52:22.206542 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
903 | 2024.10.09 22:52:22.206734 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.00277 sec., 722.0216606498195 rows/sec., 74.74 KiB/sec. | ||
904 | 2024.10.09 22:52:22.207025 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Debug> DynamicQueryHandler: Done processing query | ||
905 | 2024.10.09 22:52:22.207058 [ 3 ] {8f4916b1-ebcb-467c-9042-89315982f708} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB. | ||
906 | 2024.10.09 22:52:22.207078 [ 3 ] {} <Debug> HTTP-Session: d02dabc8-ff93-47d0-b893-801d523af8eb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
907 | 2024.10.09 22:52:22.207909 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
908 | 2024.10.09 22:52:22.207978 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
909 | 2024.10.09 22:52:22.208001 [ 3 ] {} <Debug> HTTP-Session: b0d09de3-f840-4d98-96af-3c5ca0c8e26d Authenticating user 'default' from [::1]:45501 | ||
910 | 2024.10.09 22:52:22.208025 [ 3 ] {} <Debug> HTTP-Session: b0d09de3-f840-4d98-96af-3c5ca0c8e26d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
911 | 2024.10.09 22:52:22.208040 [ 3 ] {} <Debug> HTTP-Session: b0d09de3-f840-4d98-96af-3c5ca0c8e26d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
912 | 2024.10.09 22:52:22.208085 [ 3 ] {} <Trace> HTTP-Session: b0d09de3-f840-4d98-96af-3c5ca0c8e26d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
913 | 2024.10.09 22:52:22.208235 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete) | ||
914 | 2024.10.09 22:52:22.208297 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
915 | 2024.10.09 22:52:22.208497 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
916 | 2024.10.09 22:52:22.208964 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
917 | 2024.10.09 22:52:22.209005 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
918 | 2024.10.09 22:52:22.209611 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Trace> MergedBlockOutputStream: filled checksums all_3_3_0 (state Temporary) | ||
919 | 2024.10.09 22:52:22.210266 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Renaming temporary part tmp_insert_all_3_3_0 to all_3_3_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
920 | 2024.10.09 22:52:22.210462 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002272 sec., 440.14084507042253 rows/sec., 30.52 KiB/sec. | ||
921 | 2024.10.09 22:52:22.210774 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Debug> DynamicQueryHandler: Done processing query | ||
922 | 2024.10.09 22:52:22.210804 [ 3 ] {dd4bf1d4-390e-485c-8c51-f614f7cf20e4} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
923 | 2024.10.09 22:52:22.210839 [ 3 ] {} <Debug> HTTP-Session: b0d09de3-f840-4d98-96af-3c5ca0c8e26d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
924 | 2024.10.09 22:52:23.204816 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
925 | 2024.10.09 22:52:23.204926 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
926 | 2024.10.09 22:52:23.204953 [ 3 ] {} <Debug> HTTP-Session: 3c7c3829-5909-4d63-8c5b-02776451d1a9 Authenticating user 'default' from [::1]:45501 | ||
927 | 2024.10.09 22:52:23.204977 [ 3 ] {} <Debug> HTTP-Session: 3c7c3829-5909-4d63-8c5b-02776451d1a9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
928 | 2024.10.09 22:52:23.204991 [ 3 ] {} <Debug> HTTP-Session: 3c7c3829-5909-4d63-8c5b-02776451d1a9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
929 | 2024.10.09 22:52:23.205065 [ 3 ] {} <Trace> HTTP-Session: 3c7c3829-5909-4d63-8c5b-02776451d1a9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
930 | 2024.10.09 22:52:23.205332 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete) | ||
931 | 2024.10.09 22:52:23.205415 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
932 | 2024.10.09 22:52:23.205825 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
933 | 2024.10.09 22:52:23.206378 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
934 | 2024.10.09 22:52:23.206427 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
935 | 2024.10.09 22:52:23.206988 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
936 | 2024.10.09 22:52:23.207557 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
937 | 2024.10.09 22:52:23.207770 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002498 sec., 800.640512409928 rows/sec., 82.88 KiB/sec. | ||
938 | 2024.10.09 22:52:23.208132 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Debug> DynamicQueryHandler: Done processing query | ||
939 | 2024.10.09 22:52:23.208159 [ 3 ] {337a8c29-eaed-4aab-8218-ab897355a7a3} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB. | ||
940 | 2024.10.09 22:52:23.208176 [ 3 ] {} <Debug> HTTP-Session: 3c7c3829-5909-4d63-8c5b-02776451d1a9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
941 | 2024.10.09 22:52:23.210271 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
942 | 2024.10.09 22:52:23.210347 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
943 | 2024.10.09 22:52:23.210373 [ 3 ] {} <Debug> HTTP-Session: efa9ea55-51e9-4dd4-9e8f-672ae293eae9 Authenticating user 'default' from [::1]:45501 | ||
944 | 2024.10.09 22:52:23.210396 [ 3 ] {} <Debug> HTTP-Session: efa9ea55-51e9-4dd4-9e8f-672ae293eae9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
945 | 2024.10.09 22:52:23.210411 [ 3 ] {} <Debug> HTTP-Session: efa9ea55-51e9-4dd4-9e8f-672ae293eae9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
946 | 2024.10.09 22:52:23.210459 [ 3 ] {} <Trace> HTTP-Session: efa9ea55-51e9-4dd4-9e8f-672ae293eae9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
947 | 2024.10.09 22:52:23.210620 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete) | ||
948 | 2024.10.09 22:52:23.210689 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
949 | 2024.10.09 22:52:23.210897 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
950 | 2024.10.09 22:52:23.211323 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
951 | 2024.10.09 22:52:23.211369 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
952 | 2024.10.09 22:52:23.211968 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Trace> MergedBlockOutputStream: filled checksums all_4_4_0 (state Temporary) | ||
953 | 2024.10.09 22:52:23.212549 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Renaming temporary part tmp_insert_all_4_4_0 to all_4_4_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
954 | 2024.10.09 22:52:23.212754 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002175 sec., 459.7701149425288 rows/sec., 31.88 KiB/sec. | ||
955 | 2024.10.09 22:52:23.213035 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Debug> DynamicQueryHandler: Done processing query | ||
956 | 2024.10.09 22:52:23.213066 [ 3 ] {e1fd7e2d-a967-4bfa-96bf-48027b1a2a8c} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
957 | 2024.10.09 22:52:23.213086 [ 3 ] {} <Debug> HTTP-Session: efa9ea55-51e9-4dd4-9e8f-672ae293eae9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
958 | 2024.10.09 22:52:24.211275 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
959 | 2024.10.09 22:52:24.211414 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
960 | 2024.10.09 22:52:24.211447 [ 3 ] {} <Debug> HTTP-Session: 5e5321ad-9f7e-4615-b193-34e7d514ad39 Authenticating user 'default' from [::1]:45501 | ||
961 | 2024.10.09 22:52:24.211475 [ 3 ] {} <Debug> HTTP-Session: 5e5321ad-9f7e-4615-b193-34e7d514ad39 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
962 | 2024.10.09 22:52:24.211492 [ 3 ] {} <Debug> HTTP-Session: 5e5321ad-9f7e-4615-b193-34e7d514ad39 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
963 | 2024.10.09 22:52:24.211551 [ 3 ] {} <Trace> HTTP-Session: 5e5321ad-9f7e-4615-b193-34e7d514ad39 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
964 | 2024.10.09 22:52:24.211790 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete) | ||
965 | 2024.10.09 22:52:24.211874 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
966 | 2024.10.09 22:52:24.212332 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
967 | 2024.10.09 22:52:24.212882 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
968 | 2024.10.09 22:52:24.212935 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
969 | 2024.10.09 22:52:24.213553 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
970 | 2024.10.09 22:52:24.214151 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
971 | 2024.10.09 22:52:24.214436 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002715 sec., 736.6482504604052 rows/sec., 76.25 KiB/sec. | ||
972 | 2024.10.09 22:52:24.214448 [ 105 ] {} <Debug> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
973 | 2024.10.09 22:52:24.214534 [ 105 ] {} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
974 | 2024.10.09 22:52:24.214565 [ 105 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
975 | 2024.10.09 22:52:24.214771 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
976 | 2024.10.09 22:52:24.214840 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Debug> DynamicQueryHandler: Done processing query | ||
977 | 2024.10.09 22:52:24.214866 [ 3 ] {853e2713-c36a-402f-ba2c-5d73eeb3bc2e} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB. | ||
978 | 2024.10.09 22:52:24.214885 [ 3 ] {} <Debug> HTTP-Session: 5e5321ad-9f7e-4615-b193-34e7d514ad39 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
979 | 2024.10.09 22:52:24.214946 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
980 | 2024.10.09 22:52:24.215030 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 2 rows starting from the beginning of the part | ||
981 | 2024.10.09 22:52:24.215172 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 2 rows starting from the beginning of the part | ||
982 | 2024.10.09 22:52:24.215260 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 2 rows starting from the beginning of the part | ||
983 | 2024.10.09 22:52:24.215451 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 2 rows starting from the beginning of the part | ||
984 | 2024.10.09 22:52:24.215633 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 2 rows starting from the beginning of the part | ||
985 | 2024.10.09 22:52:24.216981 [ 220 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 10 rows, containing 5 columns (5 merged, 0 gathered) in 0.002311579 sec., 4326.0472603359 rows/sec., 464.71 KiB/sec. | ||
986 | 2024.10.09 22:52:24.217179 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
987 | 2024.10.09 22:52:24.217757 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
988 | 2024.10.09 22:52:24.217858 [ 225 ] {8bac079e-28c3-4e25-9c26-5e2b6b9bded2::all_1_5_1} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
989 | 2024.10.09 22:52:24.217958 [ 225 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.32 MiB. | ||
990 | 2024.10.09 22:52:24.219228 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
991 | 2024.10.09 22:52:24.219302 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
992 | 2024.10.09 22:52:24.219328 [ 3 ] {} <Debug> HTTP-Session: 8db2f7e6-12cf-4108-831c-9b51930e2cb5 Authenticating user 'default' from [::1]:45501 | ||
993 | 2024.10.09 22:52:24.219350 [ 3 ] {} <Debug> HTTP-Session: 8db2f7e6-12cf-4108-831c-9b51930e2cb5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
994 | 2024.10.09 22:52:24.219365 [ 3 ] {} <Debug> HTTP-Session: 8db2f7e6-12cf-4108-831c-9b51930e2cb5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
995 | 2024.10.09 22:52:24.219413 [ 3 ] {} <Trace> HTTP-Session: 8db2f7e6-12cf-4108-831c-9b51930e2cb5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
996 | 2024.10.09 22:52:24.219575 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete) | ||
997 | 2024.10.09 22:52:24.219644 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
998 | 2024.10.09 22:52:24.219849 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
999 | 2024.10.09 22:52:24.220491 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
1000 | 2024.10.09 22:52:24.220536 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
1001 | 2024.10.09 22:52:24.221125 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Trace> MergedBlockOutputStream: filled checksums all_5_5_0 (state Temporary) | ||
1002 | 2024.10.09 22:52:24.221658 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Renaming temporary part tmp_insert_all_5_5_0 to all_5_5_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
1003 | 2024.10.09 22:52:24.221856 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002333 sec., 428.6326618088298 rows/sec., 29.72 KiB/sec. | ||
1004 | 2024.10.09 22:52:24.221862 [ 105 ] {} <Debug> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065) (MergerMutator): Selected 5 parts from all_1_1_0 to all_5_5_0 | ||
1005 | 2024.10.09 22:52:24.221917 [ 105 ] {} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
1006 | 2024.10.09 22:52:24.221951 [ 105 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
1007 | 2024.10.09 22:52:24.222168 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Debug> MergeTask::PrepareStage: Merging 5 parts: from all_1_1_0 to all_5_5_0 into Compact with storage Full | ||
1008 | 2024.10.09 22:52:24.222228 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Debug> DynamicQueryHandler: Done processing query | ||
1009 | 2024.10.09 22:52:24.222273 [ 3 ] {21447ddd-0422-4367-9548-b9cb52cdd290} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
1010 | 2024.10.09 22:52:24.222303 [ 3 ] {} <Debug> HTTP-Session: 8db2f7e6-12cf-4108-831c-9b51930e2cb5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
1011 | 2024.10.09 22:52:24.222364 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Debug> MergeTask::PrepareStage: Selected MergeAlgorithm: Horizontal | ||
1012 | 2024.10.09 22:52:24.222407 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_1_1_0, total 1 rows starting from the beginning of the part | ||
1013 | 2024.10.09 22:52:24.222506 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_2_2_0, total 1 rows starting from the beginning of the part | ||
1014 | 2024.10.09 22:52:24.222628 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_3_3_0, total 1 rows starting from the beginning of the part | ||
1015 | 2024.10.09 22:52:24.222784 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_4_4_0, total 1 rows starting from the beginning of the part | ||
1016 | 2024.10.09 22:52:24.222888 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Debug> MergeTreeSequentialSource: Reading 2 marks from part all_5_5_0, total 1 rows starting from the beginning of the part | ||
1017 | 2024.10.09 22:52:24.224308 [ 216 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Debug> MergeTask::MergeProjectionsStage: Merge sorted 5 rows, containing 4 columns (4 merged, 0 gathered) in 0.002256292 sec., 2216.0252307768674 rows/sec., 153.65 KiB/sec. | ||
1018 | 2024.10.09 22:52:24.224472 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Trace> MergedBlockOutputStream: filled checksums all_1_5_1 (state Temporary) | ||
1019 | 2024.10.09 22:52:24.225148 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Renaming temporary part tmp_merge_all_1_5_1 to all_1_5_1 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
1020 | 2024.10.09 22:52:24.225257 [ 218 ] {16f4ef57-9d92-4b24-8047-3d8264823065::all_1_5_1} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065) (MergerMutator): Merged 5 parts: [all_1_1_0, all_5_5_0] -> all_1_5_1 | ||
1021 | 2024.10.09 22:52:24.225340 [ 218 ] {} <Debug> MemoryTracker: Peak memory usage background process to apply mutate/merge in table: 3.24 MiB. | ||
1022 | 2024.10.09 22:52:25.204366 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
1023 | 2024.10.09 22:52:25.204498 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
1024 | 2024.10.09 22:52:25.204533 [ 3 ] {} <Debug> HTTP-Session: e403d724-8bae-4368-b7e0-d1942d73f63e Authenticating user 'default' from [::1]:45501 | ||
1025 | 2024.10.09 22:52:25.204566 [ 3 ] {} <Debug> HTTP-Session: e403d724-8bae-4368-b7e0-d1942d73f63e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
1026 | 2024.10.09 22:52:25.204587 [ 3 ] {} <Debug> HTTP-Session: e403d724-8bae-4368-b7e0-d1942d73f63e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
1027 | 2024.10.09 22:52:25.204653 [ 3 ] {} <Trace> HTTP-Session: e403d724-8bae-4368-b7e0-d1942d73f63e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
1028 | 2024.10.09 22:52:25.204911 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete) | ||
1029 | 2024.10.09 22:52:25.205010 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
1030 | 2024.10.09 22:52:25.205488 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
1031 | 2024.10.09 22:52:25.206020 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
1032 | 2024.10.09 22:52:25.206065 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
1033 | 2024.10.09 22:52:25.206643 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
1034 | 2024.10.09 22:52:25.207227 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
1035 | 2024.10.09 22:52:25.207424 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002591 sec., 771.9027402547279 rows/sec., 79.90 KiB/sec. | ||
1036 | 2024.10.09 22:52:25.207702 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Debug> DynamicQueryHandler: Done processing query | ||
1037 | 2024.10.09 22:52:25.207730 [ 3 ] {f84e587c-da55-4706-8c75-9d280ae6d92c} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB. | ||
1038 | 2024.10.09 22:52:25.207746 [ 3 ] {} <Debug> HTTP-Session: e403d724-8bae-4368-b7e0-d1942d73f63e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
1039 | 2024.10.09 22:52:25.209950 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
1040 | 2024.10.09 22:52:25.210036 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
1041 | 2024.10.09 22:52:25.210079 [ 3 ] {} <Debug> HTTP-Session: 1773d04d-fd48-40c6-a84a-9ad3d75bd4de Authenticating user 'default' from [::1]:45501 | ||
1042 | 2024.10.09 22:52:25.210103 [ 3 ] {} <Debug> HTTP-Session: 1773d04d-fd48-40c6-a84a-9ad3d75bd4de Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
1043 | 2024.10.09 22:52:25.210117 [ 3 ] {} <Debug> HTTP-Session: 1773d04d-fd48-40c6-a84a-9ad3d75bd4de Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
1044 | 2024.10.09 22:52:25.210167 [ 3 ] {} <Trace> HTTP-Session: 1773d04d-fd48-40c6-a84a-9ad3d75bd4de Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
1045 | 2024.10.09 22:52:25.210343 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete) | ||
1046 | 2024.10.09 22:52:25.210420 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
1047 | 2024.10.09 22:52:25.210642 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
1048 | 2024.10.09 22:52:25.211089 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
1049 | 2024.10.09 22:52:25.211134 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
1050 | 2024.10.09 22:52:25.211734 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Trace> MergedBlockOutputStream: filled checksums all_6_6_0 (state Temporary) | ||
1051 | 2024.10.09 22:52:25.212330 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Renaming temporary part tmp_insert_all_6_6_0 to all_6_6_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
1052 | 2024.10.09 22:52:25.212527 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002243 sec., 445.83147570218455 rows/sec., 30.91 KiB/sec. | ||
1053 | 2024.10.09 22:52:25.212827 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Debug> DynamicQueryHandler: Done processing query | ||
1054 | 2024.10.09 22:52:25.212856 [ 3 ] {5cb3f9b4-a7e4-4879-b2b0-a95d671c4d9b} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
1055 | 2024.10.09 22:52:25.212876 [ 3 ] {} <Debug> HTTP-Session: 1773d04d-fd48-40c6-a84a-9ad3d75bd4de Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
1056 | 2024.10.09 22:52:26.231805 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
1057 | 2024.10.09 22:52:26.231935 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
1058 | 2024.10.09 22:52:26.231964 [ 3 ] {} <Debug> HTTP-Session: a8d70208-dfdf-4ba8-a846-8a51fd695f77 Authenticating user 'default' from [::1]:45501 | ||
1059 | 2024.10.09 22:52:26.231990 [ 3 ] {} <Debug> HTTP-Session: a8d70208-dfdf-4ba8-a846-8a51fd695f77 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
1060 | 2024.10.09 22:52:26.232004 [ 3 ] {} <Debug> HTTP-Session: a8d70208-dfdf-4ba8-a846-8a51fd695f77 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
1061 | 2024.10.09 22:52:26.232067 [ 3 ] {} <Trace> HTTP-Session: a8d70208-dfdf-4ba8-a846-8a51fd695f77 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
1062 | 2024.10.09 22:52:26.232363 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete) | ||
1063 | 2024.10.09 22:52:26.232453 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string | ||
1064 | 2024.10.09 22:52:26.232921 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
1065 | 2024.10.09 22:52:26.233462 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
1066 | 2024.10.09 22:52:26.233509 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
1067 | 2024.10.09 22:52:26.234119 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
1068 | 2024.10.09 22:52:26.234766 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Trace> oximeter.fields_string (8bac079e-28c3-4e25-9c26-5e2b6b9bded2): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
1069 | 2024.10.09 22:52:26.234991 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002728 sec., 733.1378299120234 rows/sec., 75.89 KiB/sec. | ||
1070 | 2024.10.09 22:52:26.235306 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Debug> DynamicQueryHandler: Done processing query | ||
1071 | 2024.10.09 22:52:26.235337 [ 3 ] {5b13ca45-4dde-4b29-af54-7da4346e371c} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB. | ||
1072 | 2024.10.09 22:52:26.235354 [ 3 ] {} <Debug> HTTP-Session: a8d70208-dfdf-4ba8-a846-8a51fd695f77 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
1073 | 2024.10.09 22:52:26.257860 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:45501, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
1074 | 2024.10.09 22:52:26.257990 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
1075 | 2024.10.09 22:52:26.258020 [ 3 ] {} <Debug> HTTP-Session: 07931e57-e6bb-40df-8e0e-2b25843190a2 Authenticating user 'default' from [::1]:45501 | ||
1076 | 2024.10.09 22:52:26.258048 [ 3 ] {} <Debug> HTTP-Session: 07931e57-e6bb-40df-8e0e-2b25843190a2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
1077 | 2024.10.09 22:52:26.258063 [ 3 ] {} <Debug> HTTP-Session: 07931e57-e6bb-40df-8e0e-2b25843190a2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
1078 | 2024.10.09 22:52:26.258124 [ 3 ] {} <Trace> HTTP-Session: 07931e57-e6bb-40df-8e0e-2b25843190a2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
1079 | 2024.10.09 22:52:26.258355 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Debug> executeQuery: (from [::1]:45501) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete) | ||
1080 | 2024.10.09 22:52:26.258445 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64 | ||
1081 | 2024.10.09 22:52:26.258764 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Trace> ParallelParsingInputFormat: Parallel parsing is used | ||
1082 | 2024.10.09 22:52:26.259344 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
1083 | 2024.10.09 22:52:26.259395 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.13 GiB. | ||
1084 | 2024.10.09 22:52:26.260020 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Trace> MergedBlockOutputStream: filled checksums all_7_7_0 (state Temporary) | ||
1085 | 2024.10.09 22:52:26.260627 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Trace> oximeter.measurements_i64 (16f4ef57-9d92-4b24-8047-3d8264823065): Renaming temporary part tmp_insert_all_7_7_0 to all_7_7_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
1086 | 2024.10.09 22:52:26.260839 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002554 sec., 391.5426781519186 rows/sec., 27.15 KiB/sec. | ||
1087 | 2024.10.09 22:52:26.261103 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Debug> DynamicQueryHandler: Done processing query | ||
1088 | 2024.10.09 22:52:26.261131 [ 3 ] {74481558-ff7b-46db-9352-ee8f8d3d3958} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
1089 | 2024.10.09 22:52:26.261149 [ 3 ] {} <Debug> HTTP-Session: 07931e57-e6bb-40df-8e0e-2b25843190a2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db |