1 | 2024.10.09 22:52:30.974922 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 20162 | ||
2 | 2024.10.09 22:52:30.975243 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.10.09 22:52:30.975343 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.10.09 22:52:30.997814 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.10.09 22:52:31.020298 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.10.09 22:52:31.020353 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.10.09 22:52:31.020368 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.10.09 22:52:31.020444 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_delete_image_order_4.20155.1-clickhouse-O85bKg/datastore/tmp/ to store temporary data in it | ||
9 | 2024.10.09 22:52:31.021032 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.10.09 22:52:31.021858 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
11 | 2024.10.09 22:52:31.022406 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
12 | 2024.10.09 22:52:31.022915 [ 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:31.022943 [ 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:31.022966 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.10.09 22:52:31.023092 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.10.09 22:52:31.024118 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.10.09 22:52:31.086784 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.10.09 22:52:31.087551 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.10.09 22:52:31.088382 [ 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:31.088431 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
21 | 2024.10.09 22:52:31.089475 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
22 | 2024.10.09 22:52:31.090015 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
23 | 2024.10.09 22:52:31.091766 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
24 | 2024.10.09 22:52:31.092371 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
25 | 2024.10.09 22:52:31.093509 [ 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:31.093920 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.10.09 22:52:31.094357 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.10.09 22:52:31.094761 [ 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:31.095597 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.10.09 22:52:31.095625 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_delete_image_order_4.20155.1-clickhouse-O85bKg/datastore/ | ||
31 | 2024.10.09 22:52:31.103630 [ 203 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.10.09 22:52:31.103734 [ 203 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.10.09 22:52:31.117982 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.10.09 22:52:31.118021 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000192091 sec | ||
35 | 2024.10.09 22:52:31.118042 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.10.09 22:52:31.118054 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.10.09 22:52:31.118136 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.10.09 22:52:31.118188 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
39 | 2024.10.09 22:52:31.118228 [ 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:31.118244 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.10.09 22:52:31.118263 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.10.09 22:52:31.118295 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.10.09 22:52:31.118308 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.10.09 22:52:31.118321 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
45 | 2024.10.09 22:52:31.118359 [ 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:31.118374 [ 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:31.118387 [ 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:31.118405 [ 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:31.118424 [ 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:31.118446 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.10.09 22:52:31.118463 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.10.09 22:52:31.118495 [ 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:31.118509 [ 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:31.118526 [ 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:31.259936 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.10.09 22:52:31.269515 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.10.09 22:52:31.269561 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.7145e-05 sec | ||
58 | 2024.10.09 22:52:31.269574 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.10.09 22:52:31.269584 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.10.09 22:52:31.269613 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.10.09 22:52:31.269811 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_delete_image_order_4.20155.1-clickhouse-O85bKg/datastore/user_defined/ | ||
62 | 2024.10.09 22:52:31.269871 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.10.09 22:52:31.269884 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.10.09 22:52:31.269894 [ 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:31.269908 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.10.09 22:52:31.270108 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 61467 | ||
67 | 2024.10.09 22:52:31.270275 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 35206 | ||
68 | 2024.10.09 22:52:31.271322 [ 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:31.271559 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 62471 | ||
70 | 2024.10.09 22:52:31.271788 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 46746 | ||
71 | 2024.10.09 22:52:31.271878 [ 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:31.271919 [ 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:31.272271 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 15.56 MiB, free memory in arenas 0.00 B, will set to 127.31 MiB (RSS), difference: 117.41 MiB | ||
74 | 2024.10.09 22:52:31.272630 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.2009e-05 sec. | ||
75 | 2024.10.09 22:52:31.272984 [ 1 ] {} <Information> Application: Listening for http://[::1]:61467 | ||
76 | 2024.10.09 22:52:31.273039 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:35206 | ||
77 | 2024.10.09 22:52:31.273084 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:62471 | ||
78 | 2024.10.09 22:52:31.273134 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:46746 | ||
79 | 2024.10.09 22:52:31.273161 [ 1 ] {} <Information> Application: Ready for connections. | ||
80 | 2024.10.09 22:52:44.804874 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
81 | 2024.10.09 22:52:44.805071 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
82 | 2024.10.09 22:52:44.805124 [ 3 ] {} <Debug> HTTP-Session: e5a88678-1117-4a60-9737-a024404823ee Authenticating user 'default' from [::1]:65504 | ||
83 | 2024.10.09 22:52:44.805162 [ 3 ] {} <Debug> HTTP-Session: e5a88678-1117-4a60-9737-a024404823ee Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2024.10.09 22:52:44.805179 [ 3 ] {} <Debug> HTTP-Session: e5a88678-1117-4a60-9737-a024404823ee Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
85 | 2024.10.09 22:52:44.805309 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
86 | 2024.10.09 22:52:44.805357 [ 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:44.805383 [ 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:44.805432 [ 3 ] {} <Trace> HTTP-Session: e5a88678-1117-4a60-9737-a024404823ee Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
89 | 2024.10.09 22:52:44.805960 [ 3 ] {0adf8e93-b9fd-4792-aca7-37e0515adf7d} <Debug> executeQuery: (from [::1]:65504) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
90 | 2024.10.09 22:52:44.814996 [ 3 ] {0adf8e93-b9fd-4792-aca7-37e0515adf7d} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:65504) (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:44.815285 [ 3 ] {0adf8e93-b9fd-4792-aca7-37e0515adf7d} <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:44.815612 [ 3 ] {} <Debug> HTTP-Session: e5a88678-1117-4a60-9737-a024404823ee Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
141 | 2024.10.09 22:52:44.993603 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
142 | 2024.10.09 22:52:44.993763 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
143 | 2024.10.09 22:52:44.993792 [ 3 ] {} <Debug> HTTP-Session: 35716ce2-e5b9-46d4-a550-2d07d733666d Authenticating user 'default' from [::1]:65504 | ||
144 | 2024.10.09 22:52:44.993837 [ 3 ] {} <Debug> HTTP-Session: 35716ce2-e5b9-46d4-a550-2d07d733666d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
145 | 2024.10.09 22:52:44.993853 [ 3 ] {} <Debug> HTTP-Session: 35716ce2-e5b9-46d4-a550-2d07d733666d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2024.10.09 22:52:44.993916 [ 3 ] {} <Trace> HTTP-Session: 35716ce2-e5b9-46d4-a550-2d07d733666d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
147 | 2024.10.09 22:52:44.994194 [ 3 ] {f6b65302-b409-42c8-bb5e-6816e60ff562} <Debug> executeQuery: (from [::1]:65504) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
148 | 2024.10.09 22:52:44.994664 [ 3 ] {f6b65302-b409-42c8-bb5e-6816e60ff562} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:65504) (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:44.994840 [ 3 ] {f6b65302-b409-42c8-bb5e-6816e60ff562} <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:44.995047 [ 3 ] {} <Debug> HTTP-Session: 35716ce2-e5b9-46d4-a550-2d07d733666d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
199 | 2024.10.09 22:52:45.000271 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 127.70 MiB, peak 128.72 MiB, free memory in arenas 0.00 B, will set to 133.02 MiB (RSS), difference: 5.32 MiB | ||
200 | 2024.10.09 22:52:45.006905 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
201 | 2024.10.09 22:52:45.007079 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
202 | 2024.10.09 22:52:45.007116 [ 3 ] {} <Debug> HTTP-Session: 7368f23e-6661-4148-ba1f-c4d6c78ad34f Authenticating user 'default' from [::1]:65504 | ||
203 | 2024.10.09 22:52:45.007146 [ 3 ] {} <Debug> HTTP-Session: 7368f23e-6661-4148-ba1f-c4d6c78ad34f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
204 | 2024.10.09 22:52:45.007164 [ 3 ] {} <Debug> HTTP-Session: 7368f23e-6661-4148-ba1f-c4d6c78ad34f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
205 | 2024.10.09 22:52:45.007232 [ 3 ] {} <Trace> HTTP-Session: 7368f23e-6661-4148-ba1f-c4d6c78ad34f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
206 | 2024.10.09 22:52:45.007558 [ 3 ] {63bf9bf7-8478-4830-b911-09c5d8f02ce9} <Debug> executeQuery: (from [::1]:65504) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
207 | 2024.10.09 22:52:45.007863 [ 3 ] {63bf9bf7-8478-4830-b911-09c5d8f02ce9} <Debug> DynamicQueryHandler: Done processing query | ||
208 | 2024.10.09 22:52:45.007903 [ 3 ] {} <Debug> HTTP-Session: 7368f23e-6661-4148-ba1f-c4d6c78ad34f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
209 | 2024.10.09 22:52:45.059685 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
210 | 2024.10.09 22:52:45.059809 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
211 | 2024.10.09 22:52:45.059852 [ 3 ] {} <Debug> HTTP-Session: e0e08267-a9b9-4954-9161-6e5ab5911faf Authenticating user 'default' from [::1]:65504 | ||
212 | 2024.10.09 22:52:45.059882 [ 3 ] {} <Debug> HTTP-Session: e0e08267-a9b9-4954-9161-6e5ab5911faf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
213 | 2024.10.09 22:52:45.059901 [ 3 ] {} <Debug> HTTP-Session: e0e08267-a9b9-4954-9161-6e5ab5911faf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
214 | 2024.10.09 22:52:45.059973 [ 3 ] {} <Trace> HTTP-Session: e0e08267-a9b9-4954-9161-6e5ab5911faf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
215 | 2024.10.09 22:52:45.060178 [ 3 ] {f140ba44-e069-4762-8f2c-dfd5c3d647ca} <Debug> executeQuery: (from [::1]:65504) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
216 | 2024.10.09 22:52:45.060264 [ 3 ] {f140ba44-e069-4762-8f2c-dfd5c3d647ca} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
217 | 2024.10.09 22:52:45.061812 [ 3 ] {f140ba44-e069-4762-8f2c-dfd5c3d647ca} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
218 | 2024.10.09 22:52:45.061843 [ 3 ] {f140ba44-e069-4762-8f2c-dfd5c3d647ca} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.2307e-05 sec | ||
219 | 2024.10.09 22:52:45.061860 [ 3 ] {f140ba44-e069-4762-8f2c-dfd5c3d647ca} <Trace> ReferentialDeps: No tables | ||
220 | 2024.10.09 22:52:45.061884 [ 3 ] {f140ba44-e069-4762-8f2c-dfd5c3d647ca} <Trace> LoadingDeps: No tables | ||
221 | 2024.10.09 22:52:45.061913 [ 3 ] {f140ba44-e069-4762-8f2c-dfd5c3d647ca} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
222 | 2024.10.09 22:52:45.062122 [ 3 ] {f140ba44-e069-4762-8f2c-dfd5c3d647ca} <Debug> DynamicQueryHandler: Done processing query | ||
223 | 2024.10.09 22:52:45.062153 [ 3 ] {} <Debug> HTTP-Session: e0e08267-a9b9-4954-9161-6e5ab5911faf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
224 | 2024.10.09 22:52:45.087972 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
225 | 2024.10.09 22:52:45.088092 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
226 | 2024.10.09 22:52:45.088117 [ 3 ] {} <Debug> HTTP-Session: 125324f7-2219-4e48-9364-5841a68507a2 Authenticating user 'default' from [::1]:65504 | ||
227 | 2024.10.09 22:52:45.088151 [ 3 ] {} <Debug> HTTP-Session: 125324f7-2219-4e48-9364-5841a68507a2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
228 | 2024.10.09 22:52:45.088165 [ 3 ] {} <Debug> HTTP-Session: 125324f7-2219-4e48-9364-5841a68507a2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
229 | 2024.10.09 22:52:45.088219 [ 3 ] {} <Trace> HTTP-Session: 125324f7-2219-4e48-9364-5841a68507a2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
230 | 2024.10.09 22:52:45.088504 [ 3 ] {02ded616-3f63-4539-ab1e-190cdf44c1f9} <Debug> executeQuery: (from [::1]:65504) /* The version table contains metadata about the `oximeter` database */ | ||
231 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
232 | 2024.10.09 22:52:45.088578 [ 3 ] {02ded616-3f63-4539-ab1e-190cdf44c1f9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
233 | 2024.10.09 22:52:45.089883 [ 3 ] {02ded616-3f63-4539-ab1e-190cdf44c1f9} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
234 | 2024.10.09 22:52:45.091150 [ 3 ] {02ded616-3f63-4539-ab1e-190cdf44c1f9} <Debug> oximeter.version (974b8fb9-5b6e-40cd-a68a-8a3ea1872509): Loading data parts | ||
235 | 2024.10.09 22:52:45.091752 [ 3 ] {02ded616-3f63-4539-ab1e-190cdf44c1f9} <Debug> oximeter.version (974b8fb9-5b6e-40cd-a68a-8a3ea1872509): There are no data parts | ||
236 | 2024.10.09 22:52:45.093537 [ 3 ] {02ded616-3f63-4539-ab1e-190cdf44c1f9} <Debug> DynamicQueryHandler: Done processing query | ||
237 | 2024.10.09 22:52:45.093569 [ 3 ] {} <Debug> HTTP-Session: 125324f7-2219-4e48-9364-5841a68507a2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
238 | 2024.10.09 22:52:45.095631 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
239 | 2024.10.09 22:52:45.095730 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
240 | 2024.10.09 22:52:45.095754 [ 3 ] {} <Debug> HTTP-Session: 18a9a681-676f-4cb8-ae5d-6bc64002521a Authenticating user 'default' from [::1]:65504 | ||
241 | 2024.10.09 22:52:45.095781 [ 3 ] {} <Debug> HTTP-Session: 18a9a681-676f-4cb8-ae5d-6bc64002521a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
242 | 2024.10.09 22:52:45.095800 [ 3 ] {} <Debug> HTTP-Session: 18a9a681-676f-4cb8-ae5d-6bc64002521a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
243 | 2024.10.09 22:52:45.095854 [ 3 ] {} <Trace> HTTP-Session: 18a9a681-676f-4cb8-ae5d-6bc64002521a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
244 | 2024.10.09 22:52:45.096257 [ 3 ] {c446c662-dfd3-41ec-8321-7470ec729b68} <Debug> executeQuery: (from [::1]:65504) /* The measurement tables contain all individual samples from each timeseries. | ||
245 | * | ||
246 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
247 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
248 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
249 | * by all samples from the same timeseries. | ||
250 | * | ||
251 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
252 | * and then uses that to index quickly into the measurements tables. | ||
253 | */ | ||
254 | 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) | ||
255 | 2024.10.09 22:52:45.096371 [ 3 ] {c446c662-dfd3-41ec-8321-7470ec729b68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
256 | 2024.10.09 22:52:45.099006 [ 3 ] {c446c662-dfd3-41ec-8321-7470ec729b68} <Debug> oximeter.measurements_bool (53f8bad2-7835-4b5c-8eac-22f9166243b4): Loading data parts | ||
257 | 2024.10.09 22:52:45.099374 [ 3 ] {c446c662-dfd3-41ec-8321-7470ec729b68} <Debug> oximeter.measurements_bool (53f8bad2-7835-4b5c-8eac-22f9166243b4): There are no data parts | ||
258 | 2024.10.09 22:52:45.101154 [ 3 ] {c446c662-dfd3-41ec-8321-7470ec729b68} <Debug> DynamicQueryHandler: Done processing query | ||
259 | 2024.10.09 22:52:45.101185 [ 3 ] {} <Debug> HTTP-Session: 18a9a681-676f-4cb8-ae5d-6bc64002521a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
260 | 2024.10.09 22:52:45.105643 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
261 | 2024.10.09 22:52:45.105747 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
262 | 2024.10.09 22:52:45.105770 [ 3 ] {} <Debug> HTTP-Session: e6de13c4-6d97-4cba-b036-372e3332d799 Authenticating user 'default' from [::1]:65504 | ||
263 | 2024.10.09 22:52:45.105809 [ 3 ] {} <Debug> HTTP-Session: e6de13c4-6d97-4cba-b036-372e3332d799 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
264 | 2024.10.09 22:52:45.105821 [ 3 ] {} <Debug> HTTP-Session: e6de13c4-6d97-4cba-b036-372e3332d799 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
265 | 2024.10.09 22:52:45.105871 [ 3 ] {} <Trace> HTTP-Session: e6de13c4-6d97-4cba-b036-372e3332d799 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
266 | 2024.10.09 22:52:45.106194 [ 3 ] {49992d07-15e8-4b8c-a1b7-a9bc9336c6ae} <Debug> executeQuery: (from [::1]:65504) 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) | ||
267 | 2024.10.09 22:52:45.106268 [ 3 ] {49992d07-15e8-4b8c-a1b7-a9bc9336c6ae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
268 | 2024.10.09 22:52:45.109007 [ 3 ] {49992d07-15e8-4b8c-a1b7-a9bc9336c6ae} <Debug> oximeter.measurements_i8 (07e5b6ec-7d10-48ff-90be-50a5d03154ea): Loading data parts | ||
269 | 2024.10.09 22:52:45.109330 [ 3 ] {49992d07-15e8-4b8c-a1b7-a9bc9336c6ae} <Debug> oximeter.measurements_i8 (07e5b6ec-7d10-48ff-90be-50a5d03154ea): There are no data parts | ||
270 | 2024.10.09 22:52:45.111228 [ 3 ] {49992d07-15e8-4b8c-a1b7-a9bc9336c6ae} <Debug> DynamicQueryHandler: Done processing query | ||
271 | 2024.10.09 22:52:45.111262 [ 3 ] {} <Debug> HTTP-Session: e6de13c4-6d97-4cba-b036-372e3332d799 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
272 | 2024.10.09 22:52:45.125150 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
273 | 2024.10.09 22:52:45.125299 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
274 | 2024.10.09 22:52:45.125328 [ 3 ] {} <Debug> HTTP-Session: f0c49012-0bd4-47b9-ae01-ad4e3049862e Authenticating user 'default' from [::1]:65504 | ||
275 | 2024.10.09 22:52:45.125357 [ 3 ] {} <Debug> HTTP-Session: f0c49012-0bd4-47b9-ae01-ad4e3049862e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
276 | 2024.10.09 22:52:45.125371 [ 3 ] {} <Debug> HTTP-Session: f0c49012-0bd4-47b9-ae01-ad4e3049862e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
277 | 2024.10.09 22:52:45.125440 [ 3 ] {} <Trace> HTTP-Session: f0c49012-0bd4-47b9-ae01-ad4e3049862e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
278 | 2024.10.09 22:52:45.125851 [ 3 ] {242888f0-ffae-4661-845d-469061d61b39} <Debug> executeQuery: (from [::1]:65504) 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) | ||
279 | 2024.10.09 22:52:45.125934 [ 3 ] {242888f0-ffae-4661-845d-469061d61b39} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
280 | 2024.10.09 22:52:45.128407 [ 3 ] {242888f0-ffae-4661-845d-469061d61b39} <Debug> oximeter.measurements_u8 (45a45adf-77a0-4df3-8db0-32f101f35f6a): Loading data parts | ||
281 | 2024.10.09 22:52:45.128719 [ 3 ] {242888f0-ffae-4661-845d-469061d61b39} <Debug> oximeter.measurements_u8 (45a45adf-77a0-4df3-8db0-32f101f35f6a): There are no data parts | ||
282 | 2024.10.09 22:52:45.135349 [ 3 ] {242888f0-ffae-4661-845d-469061d61b39} <Debug> DynamicQueryHandler: Done processing query | ||
283 | 2024.10.09 22:52:45.135397 [ 3 ] {} <Debug> HTTP-Session: f0c49012-0bd4-47b9-ae01-ad4e3049862e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
284 | 2024.10.09 22:52:45.149430 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
285 | 2024.10.09 22:52:45.149570 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
286 | 2024.10.09 22:52:45.149597 [ 3 ] {} <Debug> HTTP-Session: 2d547a82-fbe3-408b-abca-a0db0d7b2196 Authenticating user 'default' from [::1]:65504 | ||
287 | 2024.10.09 22:52:45.149631 [ 3 ] {} <Debug> HTTP-Session: 2d547a82-fbe3-408b-abca-a0db0d7b2196 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
288 | 2024.10.09 22:52:45.149648 [ 3 ] {} <Debug> HTTP-Session: 2d547a82-fbe3-408b-abca-a0db0d7b2196 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
289 | 2024.10.09 22:52:45.149709 [ 3 ] {} <Trace> HTTP-Session: 2d547a82-fbe3-408b-abca-a0db0d7b2196 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
290 | 2024.10.09 22:52:45.150108 [ 3 ] {a04dce54-8ded-4b98-9abb-39c42e1e9812} <Debug> executeQuery: (from [::1]:65504) 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) | ||
291 | 2024.10.09 22:52:45.150187 [ 3 ] {a04dce54-8ded-4b98-9abb-39c42e1e9812} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
292 | 2024.10.09 22:52:45.152901 [ 3 ] {a04dce54-8ded-4b98-9abb-39c42e1e9812} <Debug> oximeter.measurements_i16 (9ab67e5f-7e01-4ed7-bd3d-ea8b8a9a385e): Loading data parts | ||
293 | 2024.10.09 22:52:45.153567 [ 3 ] {a04dce54-8ded-4b98-9abb-39c42e1e9812} <Debug> oximeter.measurements_i16 (9ab67e5f-7e01-4ed7-bd3d-ea8b8a9a385e): There are no data parts | ||
294 | 2024.10.09 22:52:45.155429 [ 3 ] {a04dce54-8ded-4b98-9abb-39c42e1e9812} <Debug> DynamicQueryHandler: Done processing query | ||
295 | 2024.10.09 22:52:45.155506 [ 3 ] {} <Debug> HTTP-Session: 2d547a82-fbe3-408b-abca-a0db0d7b2196 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
296 | 2024.10.09 22:52:45.167847 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
297 | 2024.10.09 22:52:45.167976 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
298 | 2024.10.09 22:52:45.168021 [ 3 ] {} <Debug> HTTP-Session: becaba34-11af-46e4-b3d4-db5f9bba2e74 Authenticating user 'default' from [::1]:65504 | ||
299 | 2024.10.09 22:52:45.168051 [ 3 ] {} <Debug> HTTP-Session: becaba34-11af-46e4-b3d4-db5f9bba2e74 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
300 | 2024.10.09 22:52:45.168066 [ 3 ] {} <Debug> HTTP-Session: becaba34-11af-46e4-b3d4-db5f9bba2e74 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
301 | 2024.10.09 22:52:45.168135 [ 3 ] {} <Trace> HTTP-Session: becaba34-11af-46e4-b3d4-db5f9bba2e74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
302 | 2024.10.09 22:52:45.168529 [ 3 ] {cacbc7fd-de1b-4070-9f57-c4d65c8fdfca} <Debug> executeQuery: (from [::1]:65504) 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) | ||
303 | 2024.10.09 22:52:45.168611 [ 3 ] {cacbc7fd-de1b-4070-9f57-c4d65c8fdfca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
304 | 2024.10.09 22:52:45.171046 [ 3 ] {cacbc7fd-de1b-4070-9f57-c4d65c8fdfca} <Debug> oximeter.measurements_u16 (761d0e3c-fec8-48d8-87d3-1d94dd812631): Loading data parts | ||
305 | 2024.10.09 22:52:45.171330 [ 3 ] {cacbc7fd-de1b-4070-9f57-c4d65c8fdfca} <Debug> oximeter.measurements_u16 (761d0e3c-fec8-48d8-87d3-1d94dd812631): There are no data parts | ||
306 | 2024.10.09 22:52:45.173186 [ 3 ] {cacbc7fd-de1b-4070-9f57-c4d65c8fdfca} <Debug> DynamicQueryHandler: Done processing query | ||
307 | 2024.10.09 22:52:45.173212 [ 3 ] {} <Debug> HTTP-Session: becaba34-11af-46e4-b3d4-db5f9bba2e74 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
308 | 2024.10.09 22:52:45.194368 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
309 | 2024.10.09 22:52:45.194498 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
310 | 2024.10.09 22:52:45.194527 [ 3 ] {} <Debug> HTTP-Session: 0ed88c1a-13ef-42cb-aeb5-a706c101fadb Authenticating user 'default' from [::1]:65504 | ||
311 | 2024.10.09 22:52:45.194555 [ 3 ] {} <Debug> HTTP-Session: 0ed88c1a-13ef-42cb-aeb5-a706c101fadb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
312 | 2024.10.09 22:52:45.194577 [ 3 ] {} <Debug> HTTP-Session: 0ed88c1a-13ef-42cb-aeb5-a706c101fadb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
313 | 2024.10.09 22:52:45.194636 [ 3 ] {} <Trace> HTTP-Session: 0ed88c1a-13ef-42cb-aeb5-a706c101fadb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
314 | 2024.10.09 22:52:45.195278 [ 3 ] {a777c830-d36a-44ab-a681-5278f02773d3} <Debug> executeQuery: (from [::1]:65504) 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) | ||
315 | 2024.10.09 22:52:45.195457 [ 3 ] {a777c830-d36a-44ab-a681-5278f02773d3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
316 | 2024.10.09 22:52:45.198580 [ 3 ] {a777c830-d36a-44ab-a681-5278f02773d3} <Debug> oximeter.measurements_i32 (fe25689b-222e-40b2-9329-fa0c5264a06c): Loading data parts | ||
317 | 2024.10.09 22:52:45.199504 [ 3 ] {a777c830-d36a-44ab-a681-5278f02773d3} <Debug> oximeter.measurements_i32 (fe25689b-222e-40b2-9329-fa0c5264a06c): There are no data parts | ||
318 | 2024.10.09 22:52:45.201539 [ 3 ] {a777c830-d36a-44ab-a681-5278f02773d3} <Debug> DynamicQueryHandler: Done processing query | ||
319 | 2024.10.09 22:52:45.201570 [ 3 ] {} <Debug> HTTP-Session: 0ed88c1a-13ef-42cb-aeb5-a706c101fadb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
320 | 2024.10.09 22:52:45.208157 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
321 | 2024.10.09 22:52:45.208267 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
322 | 2024.10.09 22:52:45.208308 [ 3 ] {} <Debug> HTTP-Session: 82b60434-b86c-4c4a-b7b2-faa538c288f3 Authenticating user 'default' from [::1]:65504 | ||
323 | 2024.10.09 22:52:45.208336 [ 3 ] {} <Debug> HTTP-Session: 82b60434-b86c-4c4a-b7b2-faa538c288f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
324 | 2024.10.09 22:52:45.208352 [ 3 ] {} <Debug> HTTP-Session: 82b60434-b86c-4c4a-b7b2-faa538c288f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
325 | 2024.10.09 22:52:45.208413 [ 3 ] {} <Trace> HTTP-Session: 82b60434-b86c-4c4a-b7b2-faa538c288f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
326 | 2024.10.09 22:52:45.208772 [ 3 ] {370473f6-d1d2-41cb-888e-3b628d1af89d} <Debug> executeQuery: (from [::1]:65504) 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) | ||
327 | 2024.10.09 22:52:45.208854 [ 3 ] {370473f6-d1d2-41cb-888e-3b628d1af89d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
328 | 2024.10.09 22:52:45.211353 [ 3 ] {370473f6-d1d2-41cb-888e-3b628d1af89d} <Debug> oximeter.measurements_u32 (e8773c21-e7d3-4f6e-9275-70ea7034ed67): Loading data parts | ||
329 | 2024.10.09 22:52:45.211715 [ 3 ] {370473f6-d1d2-41cb-888e-3b628d1af89d} <Debug> oximeter.measurements_u32 (e8773c21-e7d3-4f6e-9275-70ea7034ed67): There are no data parts | ||
330 | 2024.10.09 22:52:45.213612 [ 3 ] {370473f6-d1d2-41cb-888e-3b628d1af89d} <Debug> DynamicQueryHandler: Done processing query | ||
331 | 2024.10.09 22:52:45.213641 [ 3 ] {} <Debug> HTTP-Session: 82b60434-b86c-4c4a-b7b2-faa538c288f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
332 | 2024.10.09 22:52:45.215853 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
333 | 2024.10.09 22:52:45.215953 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
334 | 2024.10.09 22:52:45.215980 [ 3 ] {} <Debug> HTTP-Session: bafcb402-c91c-42f7-892b-ac747e9bd5cd Authenticating user 'default' from [::1]:65504 | ||
335 | 2024.10.09 22:52:45.216008 [ 3 ] {} <Debug> HTTP-Session: bafcb402-c91c-42f7-892b-ac747e9bd5cd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
336 | 2024.10.09 22:52:45.216033 [ 3 ] {} <Debug> HTTP-Session: bafcb402-c91c-42f7-892b-ac747e9bd5cd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
337 | 2024.10.09 22:52:45.216087 [ 3 ] {} <Trace> HTTP-Session: bafcb402-c91c-42f7-892b-ac747e9bd5cd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
338 | 2024.10.09 22:52:45.216406 [ 3 ] {1b1b4ad9-a068-43ff-aaa6-0a3fb1a39d48} <Debug> executeQuery: (from [::1]:65504) 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) | ||
339 | 2024.10.09 22:52:45.216487 [ 3 ] {1b1b4ad9-a068-43ff-aaa6-0a3fb1a39d48} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
340 | 2024.10.09 22:52:45.218913 [ 3 ] {1b1b4ad9-a068-43ff-aaa6-0a3fb1a39d48} <Debug> oximeter.measurements_i64 (a8419d27-e0a0-4e48-9aca-10004069fe21): Loading data parts | ||
341 | 2024.10.09 22:52:45.219250 [ 3 ] {1b1b4ad9-a068-43ff-aaa6-0a3fb1a39d48} <Debug> oximeter.measurements_i64 (a8419d27-e0a0-4e48-9aca-10004069fe21): There are no data parts | ||
342 | 2024.10.09 22:52:45.221059 [ 3 ] {1b1b4ad9-a068-43ff-aaa6-0a3fb1a39d48} <Debug> DynamicQueryHandler: Done processing query | ||
343 | 2024.10.09 22:52:45.221086 [ 3 ] {} <Debug> HTTP-Session: bafcb402-c91c-42f7-892b-ac747e9bd5cd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
344 | 2024.10.09 22:52:45.229785 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
345 | 2024.10.09 22:52:45.229875 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
346 | 2024.10.09 22:52:45.229898 [ 3 ] {} <Debug> HTTP-Session: 5d4ac950-3c26-4d9b-a92d-33d4d7acfece Authenticating user 'default' from [::1]:65504 | ||
347 | 2024.10.09 22:52:45.229932 [ 3 ] {} <Debug> HTTP-Session: 5d4ac950-3c26-4d9b-a92d-33d4d7acfece Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
348 | 2024.10.09 22:52:45.229946 [ 3 ] {} <Debug> HTTP-Session: 5d4ac950-3c26-4d9b-a92d-33d4d7acfece Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
349 | 2024.10.09 22:52:45.229999 [ 3 ] {} <Trace> HTTP-Session: 5d4ac950-3c26-4d9b-a92d-33d4d7acfece Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
350 | 2024.10.09 22:52:45.230687 [ 3 ] {28d9d095-a7bb-4ad0-a9a3-ab873f4e3a2d} <Debug> executeQuery: (from [::1]:65504) 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) | ||
351 | 2024.10.09 22:52:45.230764 [ 3 ] {28d9d095-a7bb-4ad0-a9a3-ab873f4e3a2d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
352 | 2024.10.09 22:52:45.233038 [ 3 ] {28d9d095-a7bb-4ad0-a9a3-ab873f4e3a2d} <Debug> oximeter.measurements_u64 (8c6ecf57-607a-45ac-80d4-43c475e7b2a7): Loading data parts | ||
353 | 2024.10.09 22:52:45.233382 [ 3 ] {28d9d095-a7bb-4ad0-a9a3-ab873f4e3a2d} <Debug> oximeter.measurements_u64 (8c6ecf57-607a-45ac-80d4-43c475e7b2a7): There are no data parts | ||
354 | 2024.10.09 22:52:45.234954 [ 3 ] {28d9d095-a7bb-4ad0-a9a3-ab873f4e3a2d} <Debug> DynamicQueryHandler: Done processing query | ||
355 | 2024.10.09 22:52:45.234980 [ 3 ] {} <Debug> HTTP-Session: 5d4ac950-3c26-4d9b-a92d-33d4d7acfece Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
356 | 2024.10.09 22:52:45.237995 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
357 | 2024.10.09 22:52:45.238093 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
358 | 2024.10.09 22:52:45.238120 [ 3 ] {} <Debug> HTTP-Session: 186bfd65-2127-4a86-b4df-f60c82aaebfb Authenticating user 'default' from [::1]:65504 | ||
359 | 2024.10.09 22:52:45.238145 [ 3 ] {} <Debug> HTTP-Session: 186bfd65-2127-4a86-b4df-f60c82aaebfb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
360 | 2024.10.09 22:52:45.238160 [ 3 ] {} <Debug> HTTP-Session: 186bfd65-2127-4a86-b4df-f60c82aaebfb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
361 | 2024.10.09 22:52:45.238216 [ 3 ] {} <Trace> HTTP-Session: 186bfd65-2127-4a86-b4df-f60c82aaebfb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
362 | 2024.10.09 22:52:45.238575 [ 3 ] {a1ce5a1e-5177-466a-9314-e71c4962f481} <Debug> executeQuery: (from [::1]:65504) 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) | ||
363 | 2024.10.09 22:52:45.238661 [ 3 ] {a1ce5a1e-5177-466a-9314-e71c4962f481} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
364 | 2024.10.09 22:52:45.242046 [ 3 ] {a1ce5a1e-5177-466a-9314-e71c4962f481} <Debug> oximeter.measurements_f32 (55d371d9-2a2a-4773-a304-db1732f4ee01): Loading data parts | ||
365 | 2024.10.09 22:52:45.243657 [ 3 ] {a1ce5a1e-5177-466a-9314-e71c4962f481} <Debug> oximeter.measurements_f32 (55d371d9-2a2a-4773-a304-db1732f4ee01): There are no data parts | ||
366 | 2024.10.09 22:52:45.245394 [ 3 ] {a1ce5a1e-5177-466a-9314-e71c4962f481} <Debug> DynamicQueryHandler: Done processing query | ||
367 | 2024.10.09 22:52:45.245425 [ 3 ] {} <Debug> HTTP-Session: 186bfd65-2127-4a86-b4df-f60c82aaebfb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
368 | 2024.10.09 22:52:45.278987 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
369 | 2024.10.09 22:52:45.279118 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
370 | 2024.10.09 22:52:45.279144 [ 3 ] {} <Debug> HTTP-Session: 1e74963a-2849-4106-bb07-9ccec459cc7b Authenticating user 'default' from [::1]:65504 | ||
371 | 2024.10.09 22:52:45.279180 [ 3 ] {} <Debug> HTTP-Session: 1e74963a-2849-4106-bb07-9ccec459cc7b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
372 | 2024.10.09 22:52:45.279195 [ 3 ] {} <Debug> HTTP-Session: 1e74963a-2849-4106-bb07-9ccec459cc7b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
373 | 2024.10.09 22:52:45.279252 [ 3 ] {} <Trace> HTTP-Session: 1e74963a-2849-4106-bb07-9ccec459cc7b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
374 | 2024.10.09 22:52:45.279646 [ 3 ] {5c04d30f-1d24-40e3-b6d5-5de728250e20} <Debug> executeQuery: (from [::1]:65504) 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) | ||
375 | 2024.10.09 22:52:45.279721 [ 3 ] {5c04d30f-1d24-40e3-b6d5-5de728250e20} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
376 | 2024.10.09 22:52:45.283036 [ 3 ] {5c04d30f-1d24-40e3-b6d5-5de728250e20} <Debug> oximeter.measurements_f64 (e7a5a3f3-3531-40b5-8ff8-ae1c796d3849): Loading data parts | ||
377 | 2024.10.09 22:52:45.283412 [ 3 ] {5c04d30f-1d24-40e3-b6d5-5de728250e20} <Debug> oximeter.measurements_f64 (e7a5a3f3-3531-40b5-8ff8-ae1c796d3849): There are no data parts | ||
378 | 2024.10.09 22:52:45.288558 [ 3 ] {5c04d30f-1d24-40e3-b6d5-5de728250e20} <Debug> DynamicQueryHandler: Done processing query | ||
379 | 2024.10.09 22:52:45.288602 [ 3 ] {} <Debug> HTTP-Session: 1e74963a-2849-4106-bb07-9ccec459cc7b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
380 | 2024.10.09 22:52:45.293565 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
381 | 2024.10.09 22:52:45.293657 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
382 | 2024.10.09 22:52:45.293700 [ 3 ] {} <Debug> HTTP-Session: e7642151-8f5b-4120-a594-67b25e281305 Authenticating user 'default' from [::1]:65504 | ||
383 | 2024.10.09 22:52:45.293727 [ 3 ] {} <Debug> HTTP-Session: e7642151-8f5b-4120-a594-67b25e281305 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
384 | 2024.10.09 22:52:45.293743 [ 3 ] {} <Debug> HTTP-Session: e7642151-8f5b-4120-a594-67b25e281305 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
385 | 2024.10.09 22:52:45.293804 [ 3 ] {} <Trace> HTTP-Session: e7642151-8f5b-4120-a594-67b25e281305 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
386 | 2024.10.09 22:52:45.294159 [ 3 ] {2ff96fc9-9892-4d35-a92c-2ae9daa00e62} <Debug> executeQuery: (from [::1]:65504) 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) | ||
387 | 2024.10.09 22:52:45.294246 [ 3 ] {2ff96fc9-9892-4d35-a92c-2ae9daa00e62} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
388 | 2024.10.09 22:52:45.298863 [ 3 ] {2ff96fc9-9892-4d35-a92c-2ae9daa00e62} <Debug> oximeter.measurements_string (22e59f59-7e0b-4e03-ad36-2c6e5a663757): Loading data parts | ||
389 | 2024.10.09 22:52:45.299200 [ 3 ] {2ff96fc9-9892-4d35-a92c-2ae9daa00e62} <Debug> oximeter.measurements_string (22e59f59-7e0b-4e03-ad36-2c6e5a663757): There are no data parts | ||
390 | 2024.10.09 22:52:45.301150 [ 3 ] {2ff96fc9-9892-4d35-a92c-2ae9daa00e62} <Debug> DynamicQueryHandler: Done processing query | ||
391 | 2024.10.09 22:52:45.301183 [ 3 ] {} <Debug> HTTP-Session: e7642151-8f5b-4120-a594-67b25e281305 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
392 | 2024.10.09 22:52:45.304913 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
393 | 2024.10.09 22:52:45.305027 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
394 | 2024.10.09 22:52:45.305057 [ 3 ] {} <Debug> HTTP-Session: e7fe1f7f-f391-4291-b945-ee1ee5d21b47 Authenticating user 'default' from [::1]:65504 | ||
395 | 2024.10.09 22:52:45.305084 [ 3 ] {} <Debug> HTTP-Session: e7fe1f7f-f391-4291-b945-ee1ee5d21b47 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
396 | 2024.10.09 22:52:45.305109 [ 3 ] {} <Debug> HTTP-Session: e7fe1f7f-f391-4291-b945-ee1ee5d21b47 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
397 | 2024.10.09 22:52:45.305167 [ 3 ] {} <Trace> HTTP-Session: e7fe1f7f-f391-4291-b945-ee1ee5d21b47 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
398 | 2024.10.09 22:52:45.306249 [ 3 ] {a3727dfa-6fdb-438a-927d-6619a754e1c5} <Debug> executeQuery: (from [::1]:65504) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
399 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
400 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
401 | * a string isn't palatable for a few reasons. | ||
402 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
403 | * details. | ||
404 | */ | ||
405 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
406 | 2024.10.09 22:52:45.306343 [ 3 ] {a3727dfa-6fdb-438a-927d-6619a754e1c5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
407 | 2024.10.09 22:52:45.309935 [ 3 ] {a3727dfa-6fdb-438a-927d-6619a754e1c5} <Debug> oximeter.measurements_bytes (0eaa7dff-bd0f-4a68-8b27-d2c605b72864): Loading data parts | ||
408 | 2024.10.09 22:52:45.310511 [ 3 ] {a3727dfa-6fdb-438a-927d-6619a754e1c5} <Debug> oximeter.measurements_bytes (0eaa7dff-bd0f-4a68-8b27-d2c605b72864): There are no data parts | ||
409 | 2024.10.09 22:52:45.313639 [ 3 ] {a3727dfa-6fdb-438a-927d-6619a754e1c5} <Debug> DynamicQueryHandler: Done processing query | ||
410 | 2024.10.09 22:52:45.313673 [ 3 ] {} <Debug> HTTP-Session: e7fe1f7f-f391-4291-b945-ee1ee5d21b47 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
411 | 2024.10.09 22:52:45.316145 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
412 | 2024.10.09 22:52:45.316357 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
413 | 2024.10.09 22:52:45.316393 [ 3 ] {} <Debug> HTTP-Session: d69aa29b-0ce4-417f-a344-c36403fe1e54 Authenticating user 'default' from [::1]:65504 | ||
414 | 2024.10.09 22:52:45.316421 [ 3 ] {} <Debug> HTTP-Session: d69aa29b-0ce4-417f-a344-c36403fe1e54 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
415 | 2024.10.09 22:52:45.316446 [ 3 ] {} <Debug> HTTP-Session: d69aa29b-0ce4-417f-a344-c36403fe1e54 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
416 | 2024.10.09 22:52:45.316499 [ 3 ] {} <Trace> HTTP-Session: d69aa29b-0ce4-417f-a344-c36403fe1e54 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
417 | 2024.10.09 22:52:45.316848 [ 3 ] {1521647e-227f-4bed-b58c-fcc260677ae4} <Debug> executeQuery: (from [::1]:65504) 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) | ||
418 | 2024.10.09 22:52:45.316920 [ 3 ] {1521647e-227f-4bed-b58c-fcc260677ae4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
419 | 2024.10.09 22:52:45.320100 [ 3 ] {1521647e-227f-4bed-b58c-fcc260677ae4} <Debug> oximeter.measurements_cumulativei64 (5fa7402c-f63d-4e5a-bc52-96f6168f2e55): Loading data parts | ||
420 | 2024.10.09 22:52:45.320459 [ 3 ] {1521647e-227f-4bed-b58c-fcc260677ae4} <Debug> oximeter.measurements_cumulativei64 (5fa7402c-f63d-4e5a-bc52-96f6168f2e55): There are no data parts | ||
421 | 2024.10.09 22:52:45.323580 [ 3 ] {1521647e-227f-4bed-b58c-fcc260677ae4} <Debug> DynamicQueryHandler: Done processing query | ||
422 | 2024.10.09 22:52:45.323629 [ 3 ] {} <Debug> HTTP-Session: d69aa29b-0ce4-417f-a344-c36403fe1e54 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
423 | 2024.10.09 22:52:45.327801 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
424 | 2024.10.09 22:52:45.327886 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
425 | 2024.10.09 22:52:45.327923 [ 3 ] {} <Debug> HTTP-Session: ba0512b7-4767-4a72-b089-8ac4bbad4221 Authenticating user 'default' from [::1]:65504 | ||
426 | 2024.10.09 22:52:45.327948 [ 3 ] {} <Debug> HTTP-Session: ba0512b7-4767-4a72-b089-8ac4bbad4221 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
427 | 2024.10.09 22:52:45.327962 [ 3 ] {} <Debug> HTTP-Session: ba0512b7-4767-4a72-b089-8ac4bbad4221 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
428 | 2024.10.09 22:52:45.328041 [ 3 ] {} <Trace> HTTP-Session: ba0512b7-4767-4a72-b089-8ac4bbad4221 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
429 | 2024.10.09 22:52:45.328430 [ 3 ] {5e19dd21-9793-4643-b413-bb6d5ee6587d} <Debug> executeQuery: (from [::1]:65504) 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) | ||
430 | 2024.10.09 22:52:45.328557 [ 3 ] {5e19dd21-9793-4643-b413-bb6d5ee6587d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
431 | 2024.10.09 22:52:45.330944 [ 3 ] {5e19dd21-9793-4643-b413-bb6d5ee6587d} <Debug> oximeter.measurements_cumulativeu64 (75789c29-cd22-4fd2-aaed-c74ea44d316a): Loading data parts | ||
432 | 2024.10.09 22:52:45.331312 [ 3 ] {5e19dd21-9793-4643-b413-bb6d5ee6587d} <Debug> oximeter.measurements_cumulativeu64 (75789c29-cd22-4fd2-aaed-c74ea44d316a): There are no data parts | ||
433 | 2024.10.09 22:52:45.333150 [ 3 ] {5e19dd21-9793-4643-b413-bb6d5ee6587d} <Debug> DynamicQueryHandler: Done processing query | ||
434 | 2024.10.09 22:52:45.333177 [ 3 ] {} <Debug> HTTP-Session: ba0512b7-4767-4a72-b089-8ac4bbad4221 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
435 | 2024.10.09 22:52:45.336874 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
436 | 2024.10.09 22:52:45.336960 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
437 | 2024.10.09 22:52:45.336983 [ 3 ] {} <Debug> HTTP-Session: 7c24e7d5-ceed-455e-8d3c-16341101426f Authenticating user 'default' from [::1]:65504 | ||
438 | 2024.10.09 22:52:45.337022 [ 3 ] {} <Debug> HTTP-Session: 7c24e7d5-ceed-455e-8d3c-16341101426f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
439 | 2024.10.09 22:52:45.337036 [ 3 ] {} <Debug> HTTP-Session: 7c24e7d5-ceed-455e-8d3c-16341101426f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
440 | 2024.10.09 22:52:45.337089 [ 3 ] {} <Trace> HTTP-Session: 7c24e7d5-ceed-455e-8d3c-16341101426f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
441 | 2024.10.09 22:52:45.337433 [ 3 ] {37222eb9-71a2-4f0f-8665-d104aa714392} <Debug> executeQuery: (from [::1]:65504) 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) | ||
442 | 2024.10.09 22:52:45.337511 [ 3 ] {37222eb9-71a2-4f0f-8665-d104aa714392} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
443 | 2024.10.09 22:52:45.345740 [ 3 ] {37222eb9-71a2-4f0f-8665-d104aa714392} <Debug> oximeter.measurements_cumulativef32 (23a4a12f-f370-41c5-aba6-fd9cd45cc65e): Loading data parts | ||
444 | 2024.10.09 22:52:45.346128 [ 3 ] {37222eb9-71a2-4f0f-8665-d104aa714392} <Debug> oximeter.measurements_cumulativef32 (23a4a12f-f370-41c5-aba6-fd9cd45cc65e): There are no data parts | ||
445 | 2024.10.09 22:52:45.348851 [ 3 ] {37222eb9-71a2-4f0f-8665-d104aa714392} <Debug> DynamicQueryHandler: Done processing query | ||
446 | 2024.10.09 22:52:45.348891 [ 3 ] {} <Debug> HTTP-Session: 7c24e7d5-ceed-455e-8d3c-16341101426f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
447 | 2024.10.09 22:52:45.360331 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
448 | 2024.10.09 22:52:45.360526 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
449 | 2024.10.09 22:52:45.360559 [ 3 ] {} <Debug> HTTP-Session: 237c46bd-29cd-4f1d-9288-db67cb1e92c7 Authenticating user 'default' from [::1]:65504 | ||
450 | 2024.10.09 22:52:45.360588 [ 3 ] {} <Debug> HTTP-Session: 237c46bd-29cd-4f1d-9288-db67cb1e92c7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
451 | 2024.10.09 22:52:45.360614 [ 3 ] {} <Debug> HTTP-Session: 237c46bd-29cd-4f1d-9288-db67cb1e92c7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
452 | 2024.10.09 22:52:45.360672 [ 3 ] {} <Trace> HTTP-Session: 237c46bd-29cd-4f1d-9288-db67cb1e92c7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
453 | 2024.10.09 22:52:45.361027 [ 3 ] {7d985e03-9fa9-4a5b-82fd-97fb98aa8bd7} <Debug> executeQuery: (from [::1]:65504) 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) | ||
454 | 2024.10.09 22:52:45.361114 [ 3 ] {7d985e03-9fa9-4a5b-82fd-97fb98aa8bd7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
455 | 2024.10.09 22:52:45.365127 [ 3 ] {7d985e03-9fa9-4a5b-82fd-97fb98aa8bd7} <Debug> oximeter.measurements_cumulativef64 (3e27cef7-f019-4fb4-aa53-0572f6331b3a): Loading data parts | ||
456 | 2024.10.09 22:52:45.365484 [ 3 ] {7d985e03-9fa9-4a5b-82fd-97fb98aa8bd7} <Debug> oximeter.measurements_cumulativef64 (3e27cef7-f019-4fb4-aa53-0572f6331b3a): There are no data parts | ||
457 | 2024.10.09 22:52:45.367548 [ 3 ] {7d985e03-9fa9-4a5b-82fd-97fb98aa8bd7} <Debug> DynamicQueryHandler: Done processing query | ||
458 | 2024.10.09 22:52:45.367575 [ 3 ] {} <Debug> HTTP-Session: 237c46bd-29cd-4f1d-9288-db67cb1e92c7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
459 | 2024.10.09 22:52:45.380407 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
460 | 2024.10.09 22:52:45.380519 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
461 | 2024.10.09 22:52:45.380572 [ 3 ] {} <Debug> HTTP-Session: c985b581-c36e-4d42-9056-18a75f336d26 Authenticating user 'default' from [::1]:65504 | ||
462 | 2024.10.09 22:52:45.380602 [ 3 ] {} <Debug> HTTP-Session: c985b581-c36e-4d42-9056-18a75f336d26 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
463 | 2024.10.09 22:52:45.380619 [ 3 ] {} <Debug> HTTP-Session: c985b581-c36e-4d42-9056-18a75f336d26 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
464 | 2024.10.09 22:52:45.380681 [ 3 ] {} <Trace> HTTP-Session: c985b581-c36e-4d42-9056-18a75f336d26 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
465 | 2024.10.09 22:52:45.381391 [ 3 ] {c10ef83e-909f-4d6d-b406-cd121be761af} <Debug> executeQuery: (from [::1]:65504) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
466 | * NOTE: Array types cannot be Nullable, see | ||
467 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
468 | * for more details. | ||
469 | * | ||
470 | * This means we need to use empty arrays to indicate a missing value. This | ||
471 | * is unfortunate, and at this point relies on the fact that an | ||
472 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
473 | * to figure out another way to represent missing samples here. | ||
474 | */ | ||
475 | 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) | ||
476 | 2024.10.09 22:52:45.381502 [ 3 ] {c10ef83e-909f-4d6d-b406-cd121be761af} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
477 | 2024.10.09 22:52:45.384558 [ 3 ] {c10ef83e-909f-4d6d-b406-cd121be761af} <Debug> oximeter.measurements_histogrami8 (a73fbbf2-be1a-49de-9d21-8aaaeb8ccada): Loading data parts | ||
478 | 2024.10.09 22:52:45.384842 [ 3 ] {c10ef83e-909f-4d6d-b406-cd121be761af} <Debug> oximeter.measurements_histogrami8 (a73fbbf2-be1a-49de-9d21-8aaaeb8ccada): There are no data parts | ||
479 | 2024.10.09 22:52:45.386832 [ 3 ] {c10ef83e-909f-4d6d-b406-cd121be761af} <Debug> DynamicQueryHandler: Done processing query | ||
480 | 2024.10.09 22:52:45.386864 [ 3 ] {} <Debug> HTTP-Session: c985b581-c36e-4d42-9056-18a75f336d26 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
481 | 2024.10.09 22:52:45.390457 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
482 | 2024.10.09 22:52:45.390571 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
483 | 2024.10.09 22:52:45.390599 [ 3 ] {} <Debug> HTTP-Session: ef82039a-abbc-421f-b586-3a996a5d2bac Authenticating user 'default' from [::1]:65504 | ||
484 | 2024.10.09 22:52:45.390625 [ 3 ] {} <Debug> HTTP-Session: ef82039a-abbc-421f-b586-3a996a5d2bac Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
485 | 2024.10.09 22:52:45.390641 [ 3 ] {} <Debug> HTTP-Session: ef82039a-abbc-421f-b586-3a996a5d2bac Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
486 | 2024.10.09 22:52:45.390748 [ 3 ] {} <Trace> HTTP-Session: ef82039a-abbc-421f-b586-3a996a5d2bac Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
487 | 2024.10.09 22:52:45.391264 [ 3 ] {cb67a7b1-c051-4e9b-a24b-466da5e06871} <Debug> executeQuery: (from [::1]:65504) 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) | ||
488 | 2024.10.09 22:52:45.391727 [ 3 ] {cb67a7b1-c051-4e9b-a24b-466da5e06871} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
489 | 2024.10.09 22:52:45.395095 [ 3 ] {cb67a7b1-c051-4e9b-a24b-466da5e06871} <Debug> oximeter.measurements_histogramu8 (f9f5793f-dfe4-45e1-824b-ae8ca7bed185): Loading data parts | ||
490 | 2024.10.09 22:52:45.395603 [ 3 ] {cb67a7b1-c051-4e9b-a24b-466da5e06871} <Debug> oximeter.measurements_histogramu8 (f9f5793f-dfe4-45e1-824b-ae8ca7bed185): There are no data parts | ||
491 | 2024.10.09 22:52:45.398817 [ 3 ] {cb67a7b1-c051-4e9b-a24b-466da5e06871} <Debug> DynamicQueryHandler: Done processing query | ||
492 | 2024.10.09 22:52:45.398853 [ 3 ] {} <Debug> HTTP-Session: ef82039a-abbc-421f-b586-3a996a5d2bac Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
493 | 2024.10.09 22:52:45.403669 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
494 | 2024.10.09 22:52:45.403793 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
495 | 2024.10.09 22:52:45.403823 [ 3 ] {} <Debug> HTTP-Session: 6a28b8ec-23ff-4bcf-a1c3-87e52f482f27 Authenticating user 'default' from [::1]:65504 | ||
496 | 2024.10.09 22:52:45.403862 [ 3 ] {} <Debug> HTTP-Session: 6a28b8ec-23ff-4bcf-a1c3-87e52f482f27 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
497 | 2024.10.09 22:52:45.403880 [ 3 ] {} <Debug> HTTP-Session: 6a28b8ec-23ff-4bcf-a1c3-87e52f482f27 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
498 | 2024.10.09 22:52:45.403937 [ 3 ] {} <Trace> HTTP-Session: 6a28b8ec-23ff-4bcf-a1c3-87e52f482f27 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
499 | 2024.10.09 22:52:45.404459 [ 3 ] {b1c558b5-f90e-4449-a84d-ac1c80b47c6b} <Debug> executeQuery: (from [::1]:65504) 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) | ||
500 | 2024.10.09 22:52:45.404561 [ 3 ] {b1c558b5-f90e-4449-a84d-ac1c80b47c6b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
501 | 2024.10.09 22:52:45.409130 [ 3 ] {b1c558b5-f90e-4449-a84d-ac1c80b47c6b} <Debug> oximeter.measurements_histogrami16 (cbad8a13-c79d-4f93-99a1-a8f705fd7852): Loading data parts | ||
502 | 2024.10.09 22:52:45.409491 [ 3 ] {b1c558b5-f90e-4449-a84d-ac1c80b47c6b} <Debug> oximeter.measurements_histogrami16 (cbad8a13-c79d-4f93-99a1-a8f705fd7852): There are no data parts | ||
503 | 2024.10.09 22:52:45.412503 [ 3 ] {b1c558b5-f90e-4449-a84d-ac1c80b47c6b} <Debug> DynamicQueryHandler: Done processing query | ||
504 | 2024.10.09 22:52:45.412648 [ 3 ] {} <Debug> HTTP-Session: 6a28b8ec-23ff-4bcf-a1c3-87e52f482f27 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
505 | 2024.10.09 22:52:45.421572 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
506 | 2024.10.09 22:52:45.421700 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
507 | 2024.10.09 22:52:45.421754 [ 3 ] {} <Debug> HTTP-Session: b3b0931e-1454-4dc0-b375-10e062bce0a8 Authenticating user 'default' from [::1]:65504 | ||
508 | 2024.10.09 22:52:45.421828 [ 3 ] {} <Debug> HTTP-Session: b3b0931e-1454-4dc0-b375-10e062bce0a8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
509 | 2024.10.09 22:52:45.421857 [ 3 ] {} <Debug> HTTP-Session: b3b0931e-1454-4dc0-b375-10e062bce0a8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
510 | 2024.10.09 22:52:45.421930 [ 3 ] {} <Trace> HTTP-Session: b3b0931e-1454-4dc0-b375-10e062bce0a8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
511 | 2024.10.09 22:52:45.422467 [ 3 ] {2922fa42-d0e3-492d-954c-1da1941c938d} <Debug> executeQuery: (from [::1]:65504) 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) | ||
512 | 2024.10.09 22:52:45.422569 [ 3 ] {2922fa42-d0e3-492d-954c-1da1941c938d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
513 | 2024.10.09 22:52:45.427150 [ 3 ] {2922fa42-d0e3-492d-954c-1da1941c938d} <Debug> oximeter.measurements_histogramu16 (89376a03-953d-46ba-8bc2-9ddf2f822dc9): Loading data parts | ||
514 | 2024.10.09 22:52:45.427539 [ 3 ] {2922fa42-d0e3-492d-954c-1da1941c938d} <Debug> oximeter.measurements_histogramu16 (89376a03-953d-46ba-8bc2-9ddf2f822dc9): There are no data parts | ||
515 | 2024.10.09 22:52:45.429686 [ 3 ] {2922fa42-d0e3-492d-954c-1da1941c938d} <Debug> DynamicQueryHandler: Done processing query | ||
516 | 2024.10.09 22:52:45.429720 [ 3 ] {} <Debug> HTTP-Session: b3b0931e-1454-4dc0-b375-10e062bce0a8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
517 | 2024.10.09 22:52:45.432233 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
518 | 2024.10.09 22:52:45.432348 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
519 | 2024.10.09 22:52:45.432379 [ 3 ] {} <Debug> HTTP-Session: ac989e23-8c5f-447c-a70d-a17e26203448 Authenticating user 'default' from [::1]:65504 | ||
520 | 2024.10.09 22:52:45.432407 [ 3 ] {} <Debug> HTTP-Session: ac989e23-8c5f-447c-a70d-a17e26203448 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
521 | 2024.10.09 22:52:45.432434 [ 3 ] {} <Debug> HTTP-Session: ac989e23-8c5f-447c-a70d-a17e26203448 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
522 | 2024.10.09 22:52:45.432492 [ 3 ] {} <Trace> HTTP-Session: ac989e23-8c5f-447c-a70d-a17e26203448 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
523 | 2024.10.09 22:52:45.432950 [ 3 ] {b02cca77-8612-498f-a2ad-a99a2b0d1334} <Debug> executeQuery: (from [::1]:65504) 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) | ||
524 | 2024.10.09 22:52:45.433055 [ 3 ] {b02cca77-8612-498f-a2ad-a99a2b0d1334} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
525 | 2024.10.09 22:52:45.437450 [ 3 ] {b02cca77-8612-498f-a2ad-a99a2b0d1334} <Debug> oximeter.measurements_histogrami32 (2c6d5e0f-fbb7-4e8d-8e1a-185a85e1af0f): Loading data parts | ||
526 | 2024.10.09 22:52:45.438043 [ 3 ] {b02cca77-8612-498f-a2ad-a99a2b0d1334} <Debug> oximeter.measurements_histogrami32 (2c6d5e0f-fbb7-4e8d-8e1a-185a85e1af0f): There are no data parts | ||
527 | 2024.10.09 22:52:45.441526 [ 3 ] {b02cca77-8612-498f-a2ad-a99a2b0d1334} <Debug> DynamicQueryHandler: Done processing query | ||
528 | 2024.10.09 22:52:45.441561 [ 3 ] {} <Debug> HTTP-Session: ac989e23-8c5f-447c-a70d-a17e26203448 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
529 | 2024.10.09 22:52:45.445171 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
530 | 2024.10.09 22:52:45.445269 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
531 | 2024.10.09 22:52:45.445318 [ 3 ] {} <Debug> HTTP-Session: 5fd7c1e7-2f52-4e48-9eaf-721aa8c6110b Authenticating user 'default' from [::1]:65504 | ||
532 | 2024.10.09 22:52:45.445348 [ 3 ] {} <Debug> HTTP-Session: 5fd7c1e7-2f52-4e48-9eaf-721aa8c6110b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
533 | 2024.10.09 22:52:45.445366 [ 3 ] {} <Debug> HTTP-Session: 5fd7c1e7-2f52-4e48-9eaf-721aa8c6110b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
534 | 2024.10.09 22:52:45.445426 [ 3 ] {} <Trace> HTTP-Session: 5fd7c1e7-2f52-4e48-9eaf-721aa8c6110b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
535 | 2024.10.09 22:52:45.445929 [ 3 ] {f3d5cb29-906e-4d1f-a754-73548b556a0d} <Debug> executeQuery: (from [::1]:65504) 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) | ||
536 | 2024.10.09 22:52:45.446046 [ 3 ] {f3d5cb29-906e-4d1f-a754-73548b556a0d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
537 | 2024.10.09 22:52:45.449331 [ 3 ] {f3d5cb29-906e-4d1f-a754-73548b556a0d} <Debug> oximeter.measurements_histogramu32 (4e3c0975-069e-4f02-b524-300af282404f): Loading data parts | ||
538 | 2024.10.09 22:52:45.449824 [ 3 ] {f3d5cb29-906e-4d1f-a754-73548b556a0d} <Debug> oximeter.measurements_histogramu32 (4e3c0975-069e-4f02-b524-300af282404f): There are no data parts | ||
539 | 2024.10.09 22:52:45.464207 [ 3 ] {f3d5cb29-906e-4d1f-a754-73548b556a0d} <Debug> DynamicQueryHandler: Done processing query | ||
540 | 2024.10.09 22:52:45.464261 [ 3 ] {} <Debug> HTTP-Session: 5fd7c1e7-2f52-4e48-9eaf-721aa8c6110b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
541 | 2024.10.09 22:52:45.471458 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
542 | 2024.10.09 22:52:45.471613 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
543 | 2024.10.09 22:52:45.471762 [ 3 ] {} <Debug> HTTP-Session: d3bb285a-ffeb-4617-8255-dd2329b189d6 Authenticating user 'default' from [::1]:65504 | ||
544 | 2024.10.09 22:52:45.471801 [ 3 ] {} <Debug> HTTP-Session: d3bb285a-ffeb-4617-8255-dd2329b189d6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
545 | 2024.10.09 22:52:45.471832 [ 3 ] {} <Debug> HTTP-Session: d3bb285a-ffeb-4617-8255-dd2329b189d6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
546 | 2024.10.09 22:52:45.471896 [ 3 ] {} <Trace> HTTP-Session: d3bb285a-ffeb-4617-8255-dd2329b189d6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
547 | 2024.10.09 22:52:45.472427 [ 3 ] {2cc3888a-2202-4599-82f2-e0a9a1f9b66b} <Debug> executeQuery: (from [::1]:65504) 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) | ||
548 | 2024.10.09 22:52:45.472652 [ 3 ] {2cc3888a-2202-4599-82f2-e0a9a1f9b66b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
549 | 2024.10.09 22:52:45.476862 [ 3 ] {2cc3888a-2202-4599-82f2-e0a9a1f9b66b} <Debug> oximeter.measurements_histogrami64 (dbf80405-586f-4305-a55b-3aeb6eb9eca6): Loading data parts | ||
550 | 2024.10.09 22:52:45.477250 [ 3 ] {2cc3888a-2202-4599-82f2-e0a9a1f9b66b} <Debug> oximeter.measurements_histogrami64 (dbf80405-586f-4305-a55b-3aeb6eb9eca6): There are no data parts | ||
551 | 2024.10.09 22:52:45.485339 [ 3 ] {2cc3888a-2202-4599-82f2-e0a9a1f9b66b} <Debug> DynamicQueryHandler: Done processing query | ||
552 | 2024.10.09 22:52:45.485389 [ 3 ] {} <Debug> HTTP-Session: d3bb285a-ffeb-4617-8255-dd2329b189d6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
553 | 2024.10.09 22:52:45.499248 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
554 | 2024.10.09 22:52:45.499375 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
555 | 2024.10.09 22:52:45.499407 [ 3 ] {} <Debug> HTTP-Session: 7078e29c-5c55-4a8e-8cbb-65b88fd65b1b Authenticating user 'default' from [::1]:65504 | ||
556 | 2024.10.09 22:52:45.499454 [ 3 ] {} <Debug> HTTP-Session: 7078e29c-5c55-4a8e-8cbb-65b88fd65b1b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
557 | 2024.10.09 22:52:45.499485 [ 3 ] {} <Debug> HTTP-Session: 7078e29c-5c55-4a8e-8cbb-65b88fd65b1b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
558 | 2024.10.09 22:52:45.499549 [ 3 ] {} <Trace> HTTP-Session: 7078e29c-5c55-4a8e-8cbb-65b88fd65b1b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
559 | 2024.10.09 22:52:45.500560 [ 3 ] {efc3d097-1b7b-486d-8294-710f5b412b72} <Debug> executeQuery: (from [::1]:65504) 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) | ||
560 | 2024.10.09 22:52:45.500676 [ 3 ] {efc3d097-1b7b-486d-8294-710f5b412b72} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
561 | 2024.10.09 22:52:45.504175 [ 3 ] {efc3d097-1b7b-486d-8294-710f5b412b72} <Debug> oximeter.measurements_histogramu64 (e750e47e-0ff8-4489-a278-326ae50a0974): Loading data parts | ||
562 | 2024.10.09 22:52:45.504477 [ 3 ] {efc3d097-1b7b-486d-8294-710f5b412b72} <Debug> oximeter.measurements_histogramu64 (e750e47e-0ff8-4489-a278-326ae50a0974): There are no data parts | ||
563 | 2024.10.09 22:52:45.507205 [ 3 ] {efc3d097-1b7b-486d-8294-710f5b412b72} <Debug> DynamicQueryHandler: Done processing query | ||
564 | 2024.10.09 22:52:45.507244 [ 3 ] {} <Debug> HTTP-Session: 7078e29c-5c55-4a8e-8cbb-65b88fd65b1b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
565 | 2024.10.09 22:52:45.508212 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
566 | 2024.10.09 22:52:45.508333 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
567 | 2024.10.09 22:52:45.508375 [ 3 ] {} <Debug> HTTP-Session: 182cd9f7-5dd1-4732-b2cb-46889578bc2b Authenticating user 'default' from [::1]:65504 | ||
568 | 2024.10.09 22:52:45.508404 [ 3 ] {} <Debug> HTTP-Session: 182cd9f7-5dd1-4732-b2cb-46889578bc2b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
569 | 2024.10.09 22:52:45.508432 [ 3 ] {} <Debug> HTTP-Session: 182cd9f7-5dd1-4732-b2cb-46889578bc2b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
570 | 2024.10.09 22:52:45.508510 [ 3 ] {} <Trace> HTTP-Session: 182cd9f7-5dd1-4732-b2cb-46889578bc2b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
571 | 2024.10.09 22:52:45.509046 [ 3 ] {fad6fb27-3a41-4eca-b7c4-325081813b43} <Debug> executeQuery: (from [::1]:65504) 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) | ||
572 | 2024.10.09 22:52:45.509168 [ 3 ] {fad6fb27-3a41-4eca-b7c4-325081813b43} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
573 | 2024.10.09 22:52:45.515382 [ 3 ] {fad6fb27-3a41-4eca-b7c4-325081813b43} <Debug> oximeter.measurements_histogramf32 (dea12e0c-8941-415d-8c08-971a6e3daa99): Loading data parts | ||
574 | 2024.10.09 22:52:45.516062 [ 3 ] {fad6fb27-3a41-4eca-b7c4-325081813b43} <Debug> oximeter.measurements_histogramf32 (dea12e0c-8941-415d-8c08-971a6e3daa99): There are no data parts | ||
575 | 2024.10.09 22:52:45.529452 [ 3 ] {fad6fb27-3a41-4eca-b7c4-325081813b43} <Debug> DynamicQueryHandler: Done processing query | ||
576 | 2024.10.09 22:52:45.529506 [ 3 ] {} <Debug> HTTP-Session: 182cd9f7-5dd1-4732-b2cb-46889578bc2b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
577 | 2024.10.09 22:52:45.530330 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
578 | 2024.10.09 22:52:45.530464 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
579 | 2024.10.09 22:52:45.530681 [ 3 ] {} <Debug> HTTP-Session: d1e9586a-1d6c-4265-9422-d64683d5a275 Authenticating user 'default' from [::1]:65504 | ||
580 | 2024.10.09 22:52:45.530753 [ 3 ] {} <Debug> HTTP-Session: d1e9586a-1d6c-4265-9422-d64683d5a275 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
581 | 2024.10.09 22:52:45.530775 [ 3 ] {} <Debug> HTTP-Session: d1e9586a-1d6c-4265-9422-d64683d5a275 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
582 | 2024.10.09 22:52:45.530835 [ 3 ] {} <Trace> HTTP-Session: d1e9586a-1d6c-4265-9422-d64683d5a275 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
583 | 2024.10.09 22:52:45.531371 [ 3 ] {5d70b622-0513-4cfa-ade7-4c2c8c3cafe4} <Debug> executeQuery: (from [::1]:65504) 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) | ||
584 | 2024.10.09 22:52:45.531524 [ 3 ] {5d70b622-0513-4cfa-ade7-4c2c8c3cafe4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
585 | 2024.10.09 22:52:45.535660 [ 3 ] {5d70b622-0513-4cfa-ade7-4c2c8c3cafe4} <Debug> oximeter.measurements_histogramf64 (6e652d8b-d727-4c2a-b4e2-47e952c99a66): Loading data parts | ||
586 | 2024.10.09 22:52:45.536057 [ 3 ] {5d70b622-0513-4cfa-ade7-4c2c8c3cafe4} <Debug> oximeter.measurements_histogramf64 (6e652d8b-d727-4c2a-b4e2-47e952c99a66): There are no data parts | ||
587 | 2024.10.09 22:52:45.541102 [ 3 ] {5d70b622-0513-4cfa-ade7-4c2c8c3cafe4} <Debug> DynamicQueryHandler: Done processing query | ||
588 | 2024.10.09 22:52:45.541192 [ 3 ] {} <Debug> HTTP-Session: d1e9586a-1d6c-4265-9422-d64683d5a275 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
589 | 2024.10.09 22:52:45.572015 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
590 | 2024.10.09 22:52:45.572153 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
591 | 2024.10.09 22:52:45.572205 [ 3 ] {} <Debug> HTTP-Session: 20d87b57-c7e3-48bc-a95d-ab285c9b6131 Authenticating user 'default' from [::1]:65504 | ||
592 | 2024.10.09 22:52:45.572237 [ 3 ] {} <Debug> HTTP-Session: 20d87b57-c7e3-48bc-a95d-ab285c9b6131 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
593 | 2024.10.09 22:52:45.572253 [ 3 ] {} <Debug> HTTP-Session: 20d87b57-c7e3-48bc-a95d-ab285c9b6131 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
594 | 2024.10.09 22:52:45.572327 [ 3 ] {} <Trace> HTTP-Session: 20d87b57-c7e3-48bc-a95d-ab285c9b6131 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
595 | 2024.10.09 22:52:45.572809 [ 3 ] {2b12b5e9-0500-40ad-85c5-f7e9a43a7b5d} <Debug> executeQuery: (from [::1]:65504) /* 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:45.572911 [ 3 ] {2b12b5e9-0500-40ad-85c5-f7e9a43a7b5d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
622 | 2024.10.09 22:52:45.594087 [ 3 ] {2b12b5e9-0500-40ad-85c5-f7e9a43a7b5d} <Debug> oximeter.fields_bool (63b7ab14-e5f4-4c81-b566-c774054632ff): Loading data parts | ||
623 | 2024.10.09 22:52:45.594543 [ 3 ] {2b12b5e9-0500-40ad-85c5-f7e9a43a7b5d} <Debug> oximeter.fields_bool (63b7ab14-e5f4-4c81-b566-c774054632ff): There are no data parts | ||
624 | 2024.10.09 22:52:45.596448 [ 3 ] {2b12b5e9-0500-40ad-85c5-f7e9a43a7b5d} <Debug> DynamicQueryHandler: Done processing query | ||
625 | 2024.10.09 22:52:45.596482 [ 3 ] {} <Debug> HTTP-Session: 20d87b57-c7e3-48bc-a95d-ab285c9b6131 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
626 | 2024.10.09 22:52:45.806559 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
627 | 2024.10.09 22:52:45.806715 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
628 | 2024.10.09 22:52:45.806745 [ 3 ] {} <Debug> HTTP-Session: b79084cd-da85-4d93-9251-9f513c8dbd81 Authenticating user 'default' from [::1]:65504 | ||
629 | 2024.10.09 22:52:45.806773 [ 3 ] {} <Debug> HTTP-Session: b79084cd-da85-4d93-9251-9f513c8dbd81 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
630 | 2024.10.09 22:52:45.806804 [ 3 ] {} <Debug> HTTP-Session: b79084cd-da85-4d93-9251-9f513c8dbd81 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
631 | 2024.10.09 22:52:45.806863 [ 3 ] {} <Trace> HTTP-Session: b79084cd-da85-4d93-9251-9f513c8dbd81 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
632 | 2024.10.09 22:52:45.807247 [ 3 ] {2c429127-81b2-4dd0-87d4-7252903f3ab7} <Debug> executeQuery: (from [::1]:65504) 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:45.807372 [ 3 ] {2c429127-81b2-4dd0-87d4-7252903f3ab7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
634 | 2024.10.09 22:52:45.810837 [ 3 ] {2c429127-81b2-4dd0-87d4-7252903f3ab7} <Debug> oximeter.fields_i8 (8167ae26-aeeb-4207-8b2c-6062c717e315): Loading data parts | ||
635 | 2024.10.09 22:52:45.811160 [ 3 ] {2c429127-81b2-4dd0-87d4-7252903f3ab7} <Debug> oximeter.fields_i8 (8167ae26-aeeb-4207-8b2c-6062c717e315): There are no data parts | ||
636 | 2024.10.09 22:52:45.816192 [ 3 ] {2c429127-81b2-4dd0-87d4-7252903f3ab7} <Debug> DynamicQueryHandler: Done processing query | ||
637 | 2024.10.09 22:52:45.816228 [ 3 ] {} <Debug> HTTP-Session: b79084cd-da85-4d93-9251-9f513c8dbd81 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
638 | 2024.10.09 22:52:45.847891 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
639 | 2024.10.09 22:52:45.847998 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
640 | 2024.10.09 22:52:45.848026 [ 3 ] {} <Debug> HTTP-Session: 71ab9933-2d48-49bb-b894-e3afdce89833 Authenticating user 'default' from [::1]:65504 | ||
641 | 2024.10.09 22:52:45.848075 [ 3 ] {} <Debug> HTTP-Session: 71ab9933-2d48-49bb-b894-e3afdce89833 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
642 | 2024.10.09 22:52:45.848092 [ 3 ] {} <Debug> HTTP-Session: 71ab9933-2d48-49bb-b894-e3afdce89833 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
643 | 2024.10.09 22:52:45.848144 [ 3 ] {} <Trace> HTTP-Session: 71ab9933-2d48-49bb-b894-e3afdce89833 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
644 | 2024.10.09 22:52:45.848496 [ 3 ] {b5d1cf81-4cd5-41f2-be15-a838424dc095} <Debug> executeQuery: (from [::1]:65504) 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:45.848583 [ 3 ] {b5d1cf81-4cd5-41f2-be15-a838424dc095} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
646 | 2024.10.09 22:52:45.855333 [ 3 ] {b5d1cf81-4cd5-41f2-be15-a838424dc095} <Debug> oximeter.fields_u8 (3866a4ab-b5b3-4746-8aac-896349756f7e): Loading data parts | ||
647 | 2024.10.09 22:52:45.855686 [ 3 ] {b5d1cf81-4cd5-41f2-be15-a838424dc095} <Debug> oximeter.fields_u8 (3866a4ab-b5b3-4746-8aac-896349756f7e): There are no data parts | ||
648 | 2024.10.09 22:52:45.860700 [ 3 ] {b5d1cf81-4cd5-41f2-be15-a838424dc095} <Debug> DynamicQueryHandler: Done processing query | ||
649 | 2024.10.09 22:52:45.860735 [ 3 ] {} <Debug> HTTP-Session: 71ab9933-2d48-49bb-b894-e3afdce89833 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
650 | 2024.10.09 22:52:45.899243 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
651 | 2024.10.09 22:52:45.899505 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
652 | 2024.10.09 22:52:45.899541 [ 3 ] {} <Debug> HTTP-Session: 81884afd-5110-4f98-9ffb-0be4459557e7 Authenticating user 'default' from [::1]:65504 | ||
653 | 2024.10.09 22:52:45.899569 [ 3 ] {} <Debug> HTTP-Session: 81884afd-5110-4f98-9ffb-0be4459557e7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
654 | 2024.10.09 22:52:45.899586 [ 3 ] {} <Debug> HTTP-Session: 81884afd-5110-4f98-9ffb-0be4459557e7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
655 | 2024.10.09 22:52:45.899661 [ 3 ] {} <Trace> HTTP-Session: 81884afd-5110-4f98-9ffb-0be4459557e7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
656 | 2024.10.09 22:52:45.900077 [ 3 ] {b6e66a3f-2768-46ad-80ed-056920fedf39} <Debug> executeQuery: (from [::1]:65504) 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:45.900166 [ 3 ] {b6e66a3f-2768-46ad-80ed-056920fedf39} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
658 | 2024.10.09 22:52:45.903192 [ 3 ] {b6e66a3f-2768-46ad-80ed-056920fedf39} <Debug> oximeter.fields_i16 (f3082417-7661-4c4f-95cd-ea353be56a0f): Loading data parts | ||
659 | 2024.10.09 22:52:45.903561 [ 3 ] {b6e66a3f-2768-46ad-80ed-056920fedf39} <Debug> oximeter.fields_i16 (f3082417-7661-4c4f-95cd-ea353be56a0f): There are no data parts | ||
660 | 2024.10.09 22:52:45.905952 [ 3 ] {b6e66a3f-2768-46ad-80ed-056920fedf39} <Debug> DynamicQueryHandler: Done processing query | ||
661 | 2024.10.09 22:52:45.906016 [ 3 ] {} <Debug> HTTP-Session: 81884afd-5110-4f98-9ffb-0be4459557e7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
662 | 2024.10.09 22:52:45.915469 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
663 | 2024.10.09 22:52:45.915589 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
664 | 2024.10.09 22:52:45.915618 [ 3 ] {} <Debug> HTTP-Session: 7e8041f8-78f6-44d0-95dd-5c0ffe701545 Authenticating user 'default' from [::1]:65504 | ||
665 | 2024.10.09 22:52:45.915669 [ 3 ] {} <Debug> HTTP-Session: 7e8041f8-78f6-44d0-95dd-5c0ffe701545 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
666 | 2024.10.09 22:52:45.915726 [ 3 ] {} <Debug> HTTP-Session: 7e8041f8-78f6-44d0-95dd-5c0ffe701545 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
667 | 2024.10.09 22:52:45.915800 [ 3 ] {} <Trace> HTTP-Session: 7e8041f8-78f6-44d0-95dd-5c0ffe701545 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
668 | 2024.10.09 22:52:45.916363 [ 3 ] {3950ffb1-a89e-4475-bc96-80b858458b08} <Debug> executeQuery: (from [::1]:65504) 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:45.916463 [ 3 ] {3950ffb1-a89e-4475-bc96-80b858458b08} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
670 | 2024.10.09 22:52:45.919300 [ 3 ] {3950ffb1-a89e-4475-bc96-80b858458b08} <Debug> oximeter.fields_u16 (209433b3-dfba-4fc9-a74e-956fdf427d9c): Loading data parts | ||
671 | 2024.10.09 22:52:45.919667 [ 3 ] {3950ffb1-a89e-4475-bc96-80b858458b08} <Debug> oximeter.fields_u16 (209433b3-dfba-4fc9-a74e-956fdf427d9c): There are no data parts | ||
672 | 2024.10.09 22:52:45.921581 [ 3 ] {3950ffb1-a89e-4475-bc96-80b858458b08} <Debug> DynamicQueryHandler: Done processing query | ||
673 | 2024.10.09 22:52:45.921615 [ 3 ] {} <Debug> HTTP-Session: 7e8041f8-78f6-44d0-95dd-5c0ffe701545 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
674 | 2024.10.09 22:52:45.934658 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
675 | 2024.10.09 22:52:45.934796 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
676 | 2024.10.09 22:52:45.934827 [ 3 ] {} <Debug> HTTP-Session: 043c1385-d7ad-41a1-9ade-23a525f334ef Authenticating user 'default' from [::1]:65504 | ||
677 | 2024.10.09 22:52:45.934857 [ 3 ] {} <Debug> HTTP-Session: 043c1385-d7ad-41a1-9ade-23a525f334ef Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
678 | 2024.10.09 22:52:45.934873 [ 3 ] {} <Debug> HTTP-Session: 043c1385-d7ad-41a1-9ade-23a525f334ef Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
679 | 2024.10.09 22:52:45.934949 [ 3 ] {} <Trace> HTTP-Session: 043c1385-d7ad-41a1-9ade-23a525f334ef Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
680 | 2024.10.09 22:52:45.935409 [ 3 ] {beb0122a-12aa-45a1-8014-7a5ce979a432} <Debug> executeQuery: (from [::1]:65504) 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:45.936544 [ 3 ] {beb0122a-12aa-45a1-8014-7a5ce979a432} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
682 | 2024.10.09 22:52:45.939259 [ 3 ] {beb0122a-12aa-45a1-8014-7a5ce979a432} <Debug> oximeter.fields_i32 (99b6caf1-4758-4cf3-b461-541ec211f3ad): Loading data parts | ||
683 | 2024.10.09 22:52:45.939759 [ 3 ] {beb0122a-12aa-45a1-8014-7a5ce979a432} <Debug> oximeter.fields_i32 (99b6caf1-4758-4cf3-b461-541ec211f3ad): There are no data parts | ||
684 | 2024.10.09 22:52:45.941759 [ 3 ] {beb0122a-12aa-45a1-8014-7a5ce979a432} <Debug> DynamicQueryHandler: Done processing query | ||
685 | 2024.10.09 22:52:45.941792 [ 3 ] {} <Debug> HTTP-Session: 043c1385-d7ad-41a1-9ade-23a525f334ef Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
686 | 2024.10.09 22:52:45.981054 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
687 | 2024.10.09 22:52:45.981195 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
688 | 2024.10.09 22:52:45.981227 [ 3 ] {} <Debug> HTTP-Session: d8bd1403-d8e7-4c55-9685-4a0e25a6df39 Authenticating user 'default' from [::1]:65504 | ||
689 | 2024.10.09 22:52:45.981286 [ 3 ] {} <Debug> HTTP-Session: d8bd1403-d8e7-4c55-9685-4a0e25a6df39 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
690 | 2024.10.09 22:52:45.981304 [ 3 ] {} <Debug> HTTP-Session: d8bd1403-d8e7-4c55-9685-4a0e25a6df39 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
691 | 2024.10.09 22:52:45.981366 [ 3 ] {} <Trace> HTTP-Session: d8bd1403-d8e7-4c55-9685-4a0e25a6df39 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
692 | 2024.10.09 22:52:45.981774 [ 3 ] {cb6ecd60-1aad-490c-a75c-9d18b0144a00} <Debug> executeQuery: (from [::1]:65504) 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:45.981868 [ 3 ] {cb6ecd60-1aad-490c-a75c-9d18b0144a00} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
694 | 2024.10.09 22:52:45.993628 [ 3 ] {cb6ecd60-1aad-490c-a75c-9d18b0144a00} <Debug> oximeter.fields_u32 (5d2c2208-ba0d-45dc-875d-92208c7972fd): Loading data parts | ||
695 | 2024.10.09 22:52:45.994068 [ 3 ] {cb6ecd60-1aad-490c-a75c-9d18b0144a00} <Debug> oximeter.fields_u32 (5d2c2208-ba0d-45dc-875d-92208c7972fd): There are no data parts | ||
696 | 2024.10.09 22:52:45.996557 [ 3 ] {cb6ecd60-1aad-490c-a75c-9d18b0144a00} <Debug> DynamicQueryHandler: Done processing query | ||
697 | 2024.10.09 22:52:45.996614 [ 3 ] {} <Debug> HTTP-Session: d8bd1403-d8e7-4c55-9685-4a0e25a6df39 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
698 | 2024.10.09 22:52:45.999317 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
699 | 2024.10.09 22:52:45.999403 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
700 | 2024.10.09 22:52:45.999460 [ 3 ] {} <Debug> HTTP-Session: 56aa695c-e7f7-47a1-bc6a-9410666b8d4e Authenticating user 'default' from [::1]:65504 | ||
701 | 2024.10.09 22:52:45.999490 [ 3 ] {} <Debug> HTTP-Session: 56aa695c-e7f7-47a1-bc6a-9410666b8d4e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
702 | 2024.10.09 22:52:45.999579 [ 3 ] {} <Debug> HTTP-Session: 56aa695c-e7f7-47a1-bc6a-9410666b8d4e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
703 | 2024.10.09 22:52:45.999652 [ 3 ] {} <Trace> HTTP-Session: 56aa695c-e7f7-47a1-bc6a-9410666b8d4e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
704 | 2024.10.09 22:52:45.999986 [ 3 ] {bacf7bae-b7f7-4ff5-b958-7badbf0a298e} <Debug> executeQuery: (from [::1]:65504) 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:46.000073 [ 3 ] {bacf7bae-b7f7-4ff5-b958-7badbf0a298e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
706 | 2024.10.09 22:52:46.000355 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 137.05 MiB, peak 137.07 MiB, free memory in arenas 0.00 B, will set to 134.23 MiB (RSS), difference: -2.82 MiB | ||
707 | 2024.10.09 22:52:46.003124 [ 3 ] {bacf7bae-b7f7-4ff5-b958-7badbf0a298e} <Debug> oximeter.fields_i64 (2b093fc5-4130-4c7a-9c7e-67eafaae235c): Loading data parts | ||
708 | 2024.10.09 22:52:46.003471 [ 3 ] {bacf7bae-b7f7-4ff5-b958-7badbf0a298e} <Debug> oximeter.fields_i64 (2b093fc5-4130-4c7a-9c7e-67eafaae235c): There are no data parts | ||
709 | 2024.10.09 22:52:46.005437 [ 3 ] {bacf7bae-b7f7-4ff5-b958-7badbf0a298e} <Debug> DynamicQueryHandler: Done processing query | ||
710 | 2024.10.09 22:52:46.005521 [ 3 ] {} <Debug> HTTP-Session: 56aa695c-e7f7-47a1-bc6a-9410666b8d4e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
711 | 2024.10.09 22:52:46.009054 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
712 | 2024.10.09 22:52:46.009253 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
713 | 2024.10.09 22:52:46.009289 [ 3 ] {} <Debug> HTTP-Session: 43350f2b-c901-4e63-a22c-8af4606609ee Authenticating user 'default' from [::1]:65504 | ||
714 | 2024.10.09 22:52:46.009315 [ 3 ] {} <Debug> HTTP-Session: 43350f2b-c901-4e63-a22c-8af4606609ee Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
715 | 2024.10.09 22:52:46.009330 [ 3 ] {} <Debug> HTTP-Session: 43350f2b-c901-4e63-a22c-8af4606609ee Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
716 | 2024.10.09 22:52:46.009387 [ 3 ] {} <Trace> HTTP-Session: 43350f2b-c901-4e63-a22c-8af4606609ee Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
717 | 2024.10.09 22:52:46.009730 [ 3 ] {1108d9a4-1381-4c10-89bd-25c3bfa6aa0e} <Debug> executeQuery: (from [::1]:65504) 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) | ||
718 | 2024.10.09 22:52:46.009802 [ 3 ] {1108d9a4-1381-4c10-89bd-25c3bfa6aa0e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
719 | 2024.10.09 22:52:46.012413 [ 3 ] {1108d9a4-1381-4c10-89bd-25c3bfa6aa0e} <Debug> oximeter.fields_u64 (fc7b2a86-8ca7-4780-ac99-72cea1e32e38): Loading data parts | ||
720 | 2024.10.09 22:52:46.012721 [ 3 ] {1108d9a4-1381-4c10-89bd-25c3bfa6aa0e} <Debug> oximeter.fields_u64 (fc7b2a86-8ca7-4780-ac99-72cea1e32e38): There are no data parts | ||
721 | 2024.10.09 22:52:46.016535 [ 3 ] {1108d9a4-1381-4c10-89bd-25c3bfa6aa0e} <Debug> DynamicQueryHandler: Done processing query | ||
722 | 2024.10.09 22:52:46.016565 [ 3 ] {} <Debug> HTTP-Session: 43350f2b-c901-4e63-a22c-8af4606609ee Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
723 | 2024.10.09 22:52:46.062513 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
724 | 2024.10.09 22:52:46.062633 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
725 | 2024.10.09 22:52:46.062662 [ 3 ] {} <Debug> HTTP-Session: d8a8c121-b742-4bf1-b10f-909cf71339f3 Authenticating user 'default' from [::1]:65504 | ||
726 | 2024.10.09 22:52:46.062691 [ 3 ] {} <Debug> HTTP-Session: d8a8c121-b742-4bf1-b10f-909cf71339f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
727 | 2024.10.09 22:52:46.062707 [ 3 ] {} <Debug> HTTP-Session: d8a8c121-b742-4bf1-b10f-909cf71339f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
728 | 2024.10.09 22:52:46.062764 [ 3 ] {} <Trace> HTTP-Session: d8a8c121-b742-4bf1-b10f-909cf71339f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
729 | 2024.10.09 22:52:46.063208 [ 3 ] {93956187-cf4d-40eb-988d-083fb7d8976b} <Debug> executeQuery: (from [::1]:65504) 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) | ||
730 | 2024.10.09 22:52:46.063286 [ 3 ] {93956187-cf4d-40eb-988d-083fb7d8976b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
731 | 2024.10.09 22:52:46.087184 [ 3 ] {93956187-cf4d-40eb-988d-083fb7d8976b} <Debug> oximeter.fields_ipaddr (763598b3-ebf4-4cf6-ab7e-2f236dfc39b8): Loading data parts | ||
732 | 2024.10.09 22:52:46.087880 [ 3 ] {93956187-cf4d-40eb-988d-083fb7d8976b} <Debug> oximeter.fields_ipaddr (763598b3-ebf4-4cf6-ab7e-2f236dfc39b8): There are no data parts | ||
733 | 2024.10.09 22:52:46.090311 [ 3 ] {93956187-cf4d-40eb-988d-083fb7d8976b} <Debug> DynamicQueryHandler: Done processing query | ||
734 | 2024.10.09 22:52:46.090341 [ 3 ] {} <Debug> HTTP-Session: d8a8c121-b742-4bf1-b10f-909cf71339f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
735 | 2024.10.09 22:52:46.103885 [ 204 ] {} <Debug> DNSResolver: Updating DNS cache | ||
736 | 2024.10.09 22:52:46.103938 [ 204 ] {} <Debug> DNSResolver: Updated DNS cache | ||
737 | 2024.10.09 22:52:46.145115 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
738 | 2024.10.09 22:52:46.145241 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
739 | 2024.10.09 22:52:46.145274 [ 3 ] {} <Debug> HTTP-Session: c23f3ee7-6622-464e-b915-5704ae3ce3fe Authenticating user 'default' from [::1]:65504 | ||
740 | 2024.10.09 22:52:46.145304 [ 3 ] {} <Debug> HTTP-Session: c23f3ee7-6622-464e-b915-5704ae3ce3fe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
741 | 2024.10.09 22:52:46.145321 [ 3 ] {} <Debug> HTTP-Session: c23f3ee7-6622-464e-b915-5704ae3ce3fe Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
742 | 2024.10.09 22:52:46.145383 [ 3 ] {} <Trace> HTTP-Session: c23f3ee7-6622-464e-b915-5704ae3ce3fe Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
743 | 2024.10.09 22:52:46.145790 [ 3 ] {2fbb2d22-2e97-4795-97e0-58170c98450b} <Debug> executeQuery: (from [::1]:65504) 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) | ||
744 | 2024.10.09 22:52:46.146035 [ 3 ] {2fbb2d22-2e97-4795-97e0-58170c98450b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
745 | 2024.10.09 22:52:46.149157 [ 3 ] {2fbb2d22-2e97-4795-97e0-58170c98450b} <Debug> oximeter.fields_string (04de9879-e4f2-4df9-8a89-602d213af76b): Loading data parts | ||
746 | 2024.10.09 22:52:46.149782 [ 3 ] {2fbb2d22-2e97-4795-97e0-58170c98450b} <Debug> oximeter.fields_string (04de9879-e4f2-4df9-8a89-602d213af76b): There are no data parts | ||
747 | 2024.10.09 22:52:46.151805 [ 3 ] {2fbb2d22-2e97-4795-97e0-58170c98450b} <Debug> DynamicQueryHandler: Done processing query | ||
748 | 2024.10.09 22:52:46.151835 [ 3 ] {} <Debug> HTTP-Session: c23f3ee7-6622-464e-b915-5704ae3ce3fe Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
749 | 2024.10.09 22:52:46.160847 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
750 | 2024.10.09 22:52:46.160971 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
751 | 2024.10.09 22:52:46.160998 [ 3 ] {} <Debug> HTTP-Session: 3ab0eb95-9841-47a9-a9f8-5f3e4d5caedc Authenticating user 'default' from [::1]:65504 | ||
752 | 2024.10.09 22:52:46.161026 [ 3 ] {} <Debug> HTTP-Session: 3ab0eb95-9841-47a9-a9f8-5f3e4d5caedc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
753 | 2024.10.09 22:52:46.161040 [ 3 ] {} <Debug> HTTP-Session: 3ab0eb95-9841-47a9-a9f8-5f3e4d5caedc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
754 | 2024.10.09 22:52:46.161097 [ 3 ] {} <Trace> HTTP-Session: 3ab0eb95-9841-47a9-a9f8-5f3e4d5caedc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
755 | 2024.10.09 22:52:46.161469 [ 3 ] {5df47f6d-a727-4868-8152-079079b08110} <Debug> executeQuery: (from [::1]:65504) 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) | ||
756 | 2024.10.09 22:52:46.161591 [ 3 ] {5df47f6d-a727-4868-8152-079079b08110} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
757 | 2024.10.09 22:52:46.164149 [ 3 ] {5df47f6d-a727-4868-8152-079079b08110} <Debug> oximeter.fields_uuid (da9f39b5-8198-441a-8725-db133cedf4d2): Loading data parts | ||
758 | 2024.10.09 22:52:46.164456 [ 3 ] {5df47f6d-a727-4868-8152-079079b08110} <Debug> oximeter.fields_uuid (da9f39b5-8198-441a-8725-db133cedf4d2): There are no data parts | ||
759 | 2024.10.09 22:52:46.166285 [ 3 ] {5df47f6d-a727-4868-8152-079079b08110} <Debug> DynamicQueryHandler: Done processing query | ||
760 | 2024.10.09 22:52:46.166313 [ 3 ] {} <Debug> HTTP-Session: 3ab0eb95-9841-47a9-a9f8-5f3e4d5caedc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
761 | 2024.10.09 22:52:46.174274 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
762 | 2024.10.09 22:52:46.174397 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
763 | 2024.10.09 22:52:46.174428 [ 3 ] {} <Debug> HTTP-Session: 579f7775-d4c4-412b-83db-641a6a2b9901 Authenticating user 'default' from [::1]:65504 | ||
764 | 2024.10.09 22:52:46.174459 [ 3 ] {} <Debug> HTTP-Session: 579f7775-d4c4-412b-83db-641a6a2b9901 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
765 | 2024.10.09 22:52:46.174478 [ 3 ] {} <Debug> HTTP-Session: 579f7775-d4c4-412b-83db-641a6a2b9901 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
766 | 2024.10.09 22:52:46.174541 [ 3 ] {} <Trace> HTTP-Session: 579f7775-d4c4-412b-83db-641a6a2b9901 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
767 | 2024.10.09 22:52:46.175211 [ 3 ] {5de25bb7-9a96-4653-8d5b-df915d5f559e} <Debug> executeQuery: (from [::1]:65504) /* The timeseries schema table stores the extracted schema for the samples | ||
768 | * oximeter collects. | ||
769 | */ | ||
770 | 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) | ||
771 | 2024.10.09 22:52:46.175317 [ 3 ] {5de25bb7-9a96-4653-8d5b-df915d5f559e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
772 | 2024.10.09 22:52:46.177968 [ 3 ] {5de25bb7-9a96-4653-8d5b-df915d5f559e} <Debug> oximeter.timeseries_schema (fa4e852e-f6fb-4166-ba66-4b13a8ed7a82): Loading data parts | ||
773 | 2024.10.09 22:52:46.178401 [ 3 ] {5de25bb7-9a96-4653-8d5b-df915d5f559e} <Debug> oximeter.timeseries_schema (fa4e852e-f6fb-4166-ba66-4b13a8ed7a82): There are no data parts | ||
774 | 2024.10.09 22:52:46.180405 [ 3 ] {5de25bb7-9a96-4653-8d5b-df915d5f559e} <Debug> DynamicQueryHandler: Done processing query | ||
775 | 2024.10.09 22:52:46.180436 [ 3 ] {} <Debug> HTTP-Session: 579f7775-d4c4-412b-83db-641a6a2b9901 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
776 | 2024.10.09 22:52:46.189663 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65504, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
777 | 2024.10.09 22:52:46.189869 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
778 | 2024.10.09 22:52:46.189909 [ 3 ] {} <Debug> HTTP-Session: 2b4843f8-fea3-4339-8c23-614a312c3e14 Authenticating user 'default' from [::1]:65504 | ||
779 | 2024.10.09 22:52:46.189940 [ 3 ] {} <Debug> HTTP-Session: 2b4843f8-fea3-4339-8c23-614a312c3e14 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
780 | 2024.10.09 22:52:46.189958 [ 3 ] {} <Debug> HTTP-Session: 2b4843f8-fea3-4339-8c23-614a312c3e14 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
781 | 2024.10.09 22:52:46.190023 [ 3 ] {} <Trace> HTTP-Session: 2b4843f8-fea3-4339-8c23-614a312c3e14 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
782 | 2024.10.09 22:52:46.190299 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Debug> executeQuery: (from [::1]:65504) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
783 | 2024.10.09 22:52:46.190554 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
784 | 2024.10.09 22:52:46.192232 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Trace> oximeter.version (974b8fb9-5b6e-40cd-a68a-8a3ea1872509): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
785 | 2024.10.09 22:52:46.192293 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.12 GiB. | ||
786 | 2024.10.09 22:52:46.193183 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
787 | 2024.10.09 22:52:46.193816 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Trace> oximeter.version (974b8fb9-5b6e-40cd-a68a-8a3ea1872509): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
788 | 2024.10.09 22:52:46.194066 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003877 sec., 257.9313902501935 rows/sec., 4.03 KiB/sec. | ||
789 | 2024.10.09 22:52:46.194298 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Debug> DynamicQueryHandler: Done processing query | ||
790 | 2024.10.09 22:52:46.194323 [ 3 ] {6fe7ce7a-69d8-4974-891f-4addac8f8e06} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
791 | 2024.10.09 22:52:46.194339 [ 3 ] {} <Debug> HTTP-Session: 2b4843f8-fea3-4339-8c23-614a312c3e14 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
792 | 2024.10.09 22:52:47.000425 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 133.79 MiB, peak 138.93 MiB, free memory in arenas 0.00 B, will set to 135.68 MiB (RSS), difference: 1.89 MiB |