1 | 2024.10.09 22:52:42.084751 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 20263 | ||
2 | 2024.10.09 22:52:42.084916 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.10.09 22:52:42.084951 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.10.09 22:52:42.104827 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.10.09 22:52:42.139283 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.10.09 22:52:42.139335 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.10.09 22:52:42.139347 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.10.09 22:52:42.139432 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_keep_your_targets_straight.20233.1-clickhouse-UxIsnh/datastore/tmp/ to store temporary data in it | ||
9 | 2024.10.09 22:52:42.141954 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.10.09 22:52:42.142818 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
11 | 2024.10.09 22:52:42.143345 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
12 | 2024.10.09 22:52:42.143859 [ 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:42.143936 [ 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:42.143970 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.10.09 22:52:42.144061 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.10.09 22:52:42.144917 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.10.09 22:52:42.157541 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.10.09 22:52:42.158539 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.10.09 22:52:42.159404 [ 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:42.159455 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
21 | 2024.10.09 22:52:42.160778 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
22 | 2024.10.09 22:52:42.161878 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
23 | 2024.10.09 22:52:42.169391 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
24 | 2024.10.09 22:52:42.170158 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
25 | 2024.10.09 22:52:42.336987 [ 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:42.337326 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.10.09 22:52:42.337573 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.10.09 22:52:42.337853 [ 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:42.338512 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.10.09 22:52:42.338540 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_keep_your_targets_straight.20233.1-clickhouse-UxIsnh/datastore/ | ||
31 | 2024.10.09 22:52:42.350073 [ 184 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.10.09 22:52:42.350238 [ 184 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.10.09 22:52:42.359815 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.10.09 22:52:42.359853 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000178872 sec | ||
35 | 2024.10.09 22:52:42.359873 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.10.09 22:52:42.359884 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.10.09 22:52:42.363907 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.10.09 22:52:42.364237 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
39 | 2024.10.09 22:52:42.364524 [ 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:42.364549 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.10.09 22:52:42.364567 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.10.09 22:52:42.364635 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.10.09 22:52:42.364656 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.10.09 22:52:42.364667 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
45 | 2024.10.09 22:52:42.364699 [ 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:42.364712 [ 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:42.364723 [ 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:42.364739 [ 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:42.364755 [ 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:42.364773 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.10.09 22:52:42.364787 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.10.09 22:52:42.364812 [ 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:42.364824 [ 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:42.364841 [ 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:42.485051 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.10.09 22:52:42.487076 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.10.09 22:52:42.487121 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.8485e-05 sec | ||
58 | 2024.10.09 22:52:42.487138 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.10.09 22:52:42.487149 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.10.09 22:52:42.487186 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.10.09 22:52:42.487492 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_keep_your_targets_straight.20233.1-clickhouse-UxIsnh/datastore/user_defined/ | ||
62 | 2024.10.09 22:52:42.487557 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.10.09 22:52:42.487572 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.10.09 22:52:42.487582 [ 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:42.487598 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.10.09 22:52:42.487849 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 53548 | ||
67 | 2024.10.09 22:52:42.488093 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 53685 | ||
68 | 2024.10.09 22:52:42.489062 [ 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:42.489464 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 50354 | ||
70 | 2024.10.09 22:52:42.489551 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 39198 | ||
71 | 2024.10.09 22:52:42.489669 [ 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:42.489714 [ 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:42.489946 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 16.10 MiB, free memory in arenas 0.00 B, will set to 127.32 MiB (RSS), difference: 117.42 MiB | ||
74 | 2024.10.09 22:52:42.490364 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.3488e-05 sec. | ||
75 | 2024.10.09 22:52:42.490839 [ 1 ] {} <Information> Application: Listening for http://[::1]:53548 | ||
76 | 2024.10.09 22:52:42.490890 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:53685 | ||
77 | 2024.10.09 22:52:42.490947 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:50354 | ||
78 | 2024.10.09 22:52:42.491125 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:39198 | ||
79 | 2024.10.09 22:52:42.491148 [ 1 ] {} <Information> Application: Ready for connections. | ||
80 | 2024.10.09 22:52:54.996188 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
81 | 2024.10.09 22:52:54.996455 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
82 | 2024.10.09 22:52:54.996521 [ 3 ] {} <Debug> HTTP-Session: 6d50d8b9-2e76-4ad3-a93a-7844830b257f Authenticating user 'default' from [::1]:62818 | ||
83 | 2024.10.09 22:52:54.996572 [ 3 ] {} <Debug> HTTP-Session: 6d50d8b9-2e76-4ad3-a93a-7844830b257f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2024.10.09 22:52:54.996589 [ 3 ] {} <Debug> HTTP-Session: 6d50d8b9-2e76-4ad3-a93a-7844830b257f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
85 | 2024.10.09 22:52:54.996712 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
86 | 2024.10.09 22:52:54.996770 [ 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:54.996800 [ 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:54.996873 [ 3 ] {} <Trace> HTTP-Session: 6d50d8b9-2e76-4ad3-a93a-7844830b257f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
89 | 2024.10.09 22:52:54.997661 [ 3 ] {0ff5f0ae-888a-41a0-aa0e-cc54a88338df} <Debug> executeQuery: (from [::1]:62818) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
90 | 2024.10.09 22:52:55.002648 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 128.65 MiB, peak 128.65 MiB, free memory in arenas 0.00 B, will set to 132.89 MiB (RSS), difference: 4.24 MiB | ||
91 | 2024.10.09 22:52:55.007959 [ 3 ] {0ff5f0ae-888a-41a0-aa0e-cc54a88338df} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:62818) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
92 | |||
93 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
94 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
95 | 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 | ||
96 | 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 | ||
97 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
98 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
99 | 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 | ||
100 | 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 | ||
101 | 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 | ||
102 | 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 | ||
103 | 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 | ||
104 | 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 | ||
105 | 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 | ||
106 | 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 | ||
107 | 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 | ||
108 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
109 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
110 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
111 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
112 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
113 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
114 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
115 | |||
116 | 2024.10.09 22:52:55.008264 [ 3 ] {0ff5f0ae-888a-41a0-aa0e-cc54a88338df} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
117 | |||
118 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
119 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
120 | 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 | ||
121 | 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 | ||
122 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
123 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
124 | 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 | ||
125 | 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 | ||
126 | 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 | ||
127 | 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 | ||
128 | 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 | ||
129 | 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 | ||
130 | 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 | ||
131 | 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 | ||
132 | 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 | ||
133 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
134 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
135 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
136 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
137 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
138 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
139 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
140 | (version 23.8.7.1) | ||
141 | 2024.10.09 22:52:55.008626 [ 3 ] {} <Debug> HTTP-Session: 6d50d8b9-2e76-4ad3-a93a-7844830b257f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
142 | 2024.10.09 22:52:55.022291 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
143 | 2024.10.09 22:52:55.022435 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
144 | 2024.10.09 22:52:55.022470 [ 3 ] {} <Debug> HTTP-Session: ad78e80e-d74b-465d-a4e5-61d156030d71 Authenticating user 'default' from [::1]:62818 | ||
145 | 2024.10.09 22:52:55.022500 [ 3 ] {} <Debug> HTTP-Session: ad78e80e-d74b-465d-a4e5-61d156030d71 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2024.10.09 22:52:55.022517 [ 3 ] {} <Debug> HTTP-Session: ad78e80e-d74b-465d-a4e5-61d156030d71 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
147 | 2024.10.09 22:52:55.022591 [ 3 ] {} <Trace> HTTP-Session: ad78e80e-d74b-465d-a4e5-61d156030d71 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
148 | 2024.10.09 22:52:55.022876 [ 3 ] {115c1d77-a4aa-4339-ba28-04b90c822a2e} <Debug> executeQuery: (from [::1]:62818) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
149 | 2024.10.09 22:52:55.023380 [ 3 ] {115c1d77-a4aa-4339-ba28-04b90c822a2e} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:62818) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
150 | |||
151 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
152 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
153 | 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 | ||
154 | 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 | ||
155 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
156 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
157 | 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 | ||
158 | 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 | ||
159 | 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 | ||
160 | 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 | ||
161 | 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 | ||
162 | 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 | ||
163 | 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 | ||
164 | 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 | ||
165 | 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 | ||
166 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
167 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
168 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
169 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
170 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
171 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
172 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
173 | |||
174 | 2024.10.09 22:52:55.023575 [ 3 ] {115c1d77-a4aa-4339-ba28-04b90c822a2e} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
175 | |||
176 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
177 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
178 | 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 | ||
179 | 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 | ||
180 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
181 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
182 | 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 | ||
183 | 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 | ||
184 | 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 | ||
185 | 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 | ||
186 | 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 | ||
187 | 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 | ||
188 | 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 | ||
189 | 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 | ||
190 | 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 | ||
191 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
192 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
193 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
197 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
198 | (version 23.8.7.1) | ||
199 | 2024.10.09 22:52:55.023805 [ 3 ] {} <Debug> HTTP-Session: ad78e80e-d74b-465d-a4e5-61d156030d71 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
200 | 2024.10.09 22:52:55.031067 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
201 | 2024.10.09 22:52:55.031192 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
202 | 2024.10.09 22:52:55.031262 [ 3 ] {} <Debug> HTTP-Session: 14da105b-984e-4d90-9fbf-0ad9371b0b17 Authenticating user 'default' from [::1]:62818 | ||
203 | 2024.10.09 22:52:55.031297 [ 3 ] {} <Debug> HTTP-Session: 14da105b-984e-4d90-9fbf-0ad9371b0b17 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
204 | 2024.10.09 22:52:55.031314 [ 3 ] {} <Debug> HTTP-Session: 14da105b-984e-4d90-9fbf-0ad9371b0b17 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
205 | 2024.10.09 22:52:55.031377 [ 3 ] {} <Trace> HTTP-Session: 14da105b-984e-4d90-9fbf-0ad9371b0b17 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
206 | 2024.10.09 22:52:55.031710 [ 3 ] {374e6b91-0d3d-4499-894c-d915f4d2f788} <Debug> executeQuery: (from [::1]:62818) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
207 | 2024.10.09 22:52:55.032040 [ 3 ] {374e6b91-0d3d-4499-894c-d915f4d2f788} <Debug> DynamicQueryHandler: Done processing query | ||
208 | 2024.10.09 22:52:55.032074 [ 3 ] {} <Debug> HTTP-Session: 14da105b-984e-4d90-9fbf-0ad9371b0b17 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
209 | 2024.10.09 22:52:55.038263 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
210 | 2024.10.09 22:52:55.038393 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
211 | 2024.10.09 22:52:55.038422 [ 3 ] {} <Debug> HTTP-Session: 1cbdf0f6-158d-4a83-a15f-b573a991231c Authenticating user 'default' from [::1]:62818 | ||
212 | 2024.10.09 22:52:55.038448 [ 3 ] {} <Debug> HTTP-Session: 1cbdf0f6-158d-4a83-a15f-b573a991231c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
213 | 2024.10.09 22:52:55.038464 [ 3 ] {} <Debug> HTTP-Session: 1cbdf0f6-158d-4a83-a15f-b573a991231c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
214 | 2024.10.09 22:52:55.038530 [ 3 ] {} <Trace> HTTP-Session: 1cbdf0f6-158d-4a83-a15f-b573a991231c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
215 | 2024.10.09 22:52:55.038727 [ 3 ] {da6ef7ce-c7c2-497b-ad56-4489bfaa0465} <Debug> executeQuery: (from [::1]:62818) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
216 | 2024.10.09 22:52:55.038843 [ 3 ] {da6ef7ce-c7c2-497b-ad56-4489bfaa0465} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
217 | 2024.10.09 22:52:55.040333 [ 3 ] {da6ef7ce-c7c2-497b-ad56-4489bfaa0465} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
218 | 2024.10.09 22:52:55.040360 [ 3 ] {da6ef7ce-c7c2-497b-ad56-4489bfaa0465} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.9766e-05 sec | ||
219 | 2024.10.09 22:52:55.040376 [ 3 ] {da6ef7ce-c7c2-497b-ad56-4489bfaa0465} <Trace> ReferentialDeps: No tables | ||
220 | 2024.10.09 22:52:55.040398 [ 3 ] {da6ef7ce-c7c2-497b-ad56-4489bfaa0465} <Trace> LoadingDeps: No tables | ||
221 | 2024.10.09 22:52:55.040426 [ 3 ] {da6ef7ce-c7c2-497b-ad56-4489bfaa0465} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
222 | 2024.10.09 22:52:55.040653 [ 3 ] {da6ef7ce-c7c2-497b-ad56-4489bfaa0465} <Debug> DynamicQueryHandler: Done processing query | ||
223 | 2024.10.09 22:52:55.040680 [ 3 ] {} <Debug> HTTP-Session: 1cbdf0f6-158d-4a83-a15f-b573a991231c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
224 | 2024.10.09 22:52:55.049945 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
225 | 2024.10.09 22:52:55.050074 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
226 | 2024.10.09 22:52:55.050106 [ 3 ] {} <Debug> HTTP-Session: 3cb7368a-0f83-44a0-ae04-1a6a8a1f3d21 Authenticating user 'default' from [::1]:62818 | ||
227 | 2024.10.09 22:52:55.050145 [ 3 ] {} <Debug> HTTP-Session: 3cb7368a-0f83-44a0-ae04-1a6a8a1f3d21 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
228 | 2024.10.09 22:52:55.050161 [ 3 ] {} <Debug> HTTP-Session: 3cb7368a-0f83-44a0-ae04-1a6a8a1f3d21 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
229 | 2024.10.09 22:52:55.050221 [ 3 ] {} <Trace> HTTP-Session: 3cb7368a-0f83-44a0-ae04-1a6a8a1f3d21 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
230 | 2024.10.09 22:52:55.050568 [ 3 ] {ab4f9667-6767-4040-857c-3ed997b55196} <Debug> executeQuery: (from [::1]:62818) /* 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:55.050659 [ 3 ] {ab4f9667-6767-4040-857c-3ed997b55196} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
233 | 2024.10.09 22:52:55.052573 [ 3 ] {ab4f9667-6767-4040-857c-3ed997b55196} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
234 | 2024.10.09 22:52:55.054465 [ 3 ] {ab4f9667-6767-4040-857c-3ed997b55196} <Debug> oximeter.version (78817511-dcb8-4b84-a05d-c4fc1495b3c5): Loading data parts | ||
235 | 2024.10.09 22:52:55.055308 [ 3 ] {ab4f9667-6767-4040-857c-3ed997b55196} <Debug> oximeter.version (78817511-dcb8-4b84-a05d-c4fc1495b3c5): There are no data parts | ||
236 | 2024.10.09 22:52:55.057628 [ 3 ] {ab4f9667-6767-4040-857c-3ed997b55196} <Debug> DynamicQueryHandler: Done processing query | ||
237 | 2024.10.09 22:52:55.057662 [ 3 ] {} <Debug> HTTP-Session: 3cb7368a-0f83-44a0-ae04-1a6a8a1f3d21 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
238 | 2024.10.09 22:52:55.058660 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
239 | 2024.10.09 22:52:55.058781 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
240 | 2024.10.09 22:52:55.058812 [ 3 ] {} <Debug> HTTP-Session: 0d2ddbd7-e72a-49d2-999a-e5eb19dfcb83 Authenticating user 'default' from [::1]:62818 | ||
241 | 2024.10.09 22:52:55.058838 [ 3 ] {} <Debug> HTTP-Session: 0d2ddbd7-e72a-49d2-999a-e5eb19dfcb83 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
242 | 2024.10.09 22:52:55.058862 [ 3 ] {} <Debug> HTTP-Session: 0d2ddbd7-e72a-49d2-999a-e5eb19dfcb83 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
243 | 2024.10.09 22:52:55.058916 [ 3 ] {} <Trace> HTTP-Session: 0d2ddbd7-e72a-49d2-999a-e5eb19dfcb83 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
244 | 2024.10.09 22:52:55.059269 [ 3 ] {cbb21427-4c25-4b05-90c0-031ac2ac5962} <Debug> executeQuery: (from [::1]:62818) /* 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:55.059354 [ 3 ] {cbb21427-4c25-4b05-90c0-031ac2ac5962} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
256 | 2024.10.09 22:52:55.062277 [ 3 ] {cbb21427-4c25-4b05-90c0-031ac2ac5962} <Debug> oximeter.measurements_bool (98951cc1-1aaf-4e0c-8497-4c6e1409e9da): Loading data parts | ||
257 | 2024.10.09 22:52:55.062555 [ 3 ] {cbb21427-4c25-4b05-90c0-031ac2ac5962} <Debug> oximeter.measurements_bool (98951cc1-1aaf-4e0c-8497-4c6e1409e9da): There are no data parts | ||
258 | 2024.10.09 22:52:55.064289 [ 3 ] {cbb21427-4c25-4b05-90c0-031ac2ac5962} <Debug> DynamicQueryHandler: Done processing query | ||
259 | 2024.10.09 22:52:55.064343 [ 3 ] {} <Debug> HTTP-Session: 0d2ddbd7-e72a-49d2-999a-e5eb19dfcb83 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
260 | 2024.10.09 22:52:55.069129 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
261 | 2024.10.09 22:52:55.069240 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
262 | 2024.10.09 22:52:55.069270 [ 3 ] {} <Debug> HTTP-Session: 6ee26767-bcec-4755-95ef-bae2ad77aca2 Authenticating user 'default' from [::1]:62818 | ||
263 | 2024.10.09 22:52:55.069310 [ 3 ] {} <Debug> HTTP-Session: 6ee26767-bcec-4755-95ef-bae2ad77aca2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
264 | 2024.10.09 22:52:55.069328 [ 3 ] {} <Debug> HTTP-Session: 6ee26767-bcec-4755-95ef-bae2ad77aca2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
265 | 2024.10.09 22:52:55.069385 [ 3 ] {} <Trace> HTTP-Session: 6ee26767-bcec-4755-95ef-bae2ad77aca2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
266 | 2024.10.09 22:52:55.069726 [ 3 ] {c9cf0879-0911-46f3-bade-35cac4830c41} <Debug> executeQuery: (from [::1]:62818) 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:55.069807 [ 3 ] {c9cf0879-0911-46f3-bade-35cac4830c41} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
268 | 2024.10.09 22:52:55.072187 [ 3 ] {c9cf0879-0911-46f3-bade-35cac4830c41} <Debug> oximeter.measurements_i8 (ed8b40f7-88be-432f-8291-8df0f684a0c3): Loading data parts | ||
269 | 2024.10.09 22:52:55.072521 [ 3 ] {c9cf0879-0911-46f3-bade-35cac4830c41} <Debug> oximeter.measurements_i8 (ed8b40f7-88be-432f-8291-8df0f684a0c3): There are no data parts | ||
270 | 2024.10.09 22:52:55.074415 [ 3 ] {c9cf0879-0911-46f3-bade-35cac4830c41} <Debug> DynamicQueryHandler: Done processing query | ||
271 | 2024.10.09 22:52:55.074445 [ 3 ] {} <Debug> HTTP-Session: 6ee26767-bcec-4755-95ef-bae2ad77aca2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
272 | 2024.10.09 22:52:55.075131 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
273 | 2024.10.09 22:52:55.075216 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
274 | 2024.10.09 22:52:55.075245 [ 3 ] {} <Debug> HTTP-Session: 99fa2898-6470-4e51-b4af-0337cae6cddd Authenticating user 'default' from [::1]:62818 | ||
275 | 2024.10.09 22:52:55.075271 [ 3 ] {} <Debug> HTTP-Session: 99fa2898-6470-4e51-b4af-0337cae6cddd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
276 | 2024.10.09 22:52:55.075288 [ 3 ] {} <Debug> HTTP-Session: 99fa2898-6470-4e51-b4af-0337cae6cddd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
277 | 2024.10.09 22:52:55.075347 [ 3 ] {} <Trace> HTTP-Session: 99fa2898-6470-4e51-b4af-0337cae6cddd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
278 | 2024.10.09 22:52:55.075631 [ 3 ] {36b57f32-ca13-4731-9d80-c35eaee4bccc} <Debug> executeQuery: (from [::1]:62818) 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:55.075709 [ 3 ] {36b57f32-ca13-4731-9d80-c35eaee4bccc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
280 | 2024.10.09 22:52:55.078043 [ 3 ] {36b57f32-ca13-4731-9d80-c35eaee4bccc} <Debug> oximeter.measurements_u8 (76305e4e-cafe-417f-ad52-451fc4b9b7e4): Loading data parts | ||
281 | 2024.10.09 22:52:55.078451 [ 3 ] {36b57f32-ca13-4731-9d80-c35eaee4bccc} <Debug> oximeter.measurements_u8 (76305e4e-cafe-417f-ad52-451fc4b9b7e4): There are no data parts | ||
282 | 2024.10.09 22:52:55.080153 [ 3 ] {36b57f32-ca13-4731-9d80-c35eaee4bccc} <Debug> DynamicQueryHandler: Done processing query | ||
283 | 2024.10.09 22:52:55.080184 [ 3 ] {} <Debug> HTTP-Session: 99fa2898-6470-4e51-b4af-0337cae6cddd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
284 | 2024.10.09 22:52:55.080961 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
285 | 2024.10.09 22:52:55.081042 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
286 | 2024.10.09 22:52:55.081067 [ 3 ] {} <Debug> HTTP-Session: 3443c615-7431-49c5-b102-e419187a1d78 Authenticating user 'default' from [::1]:62818 | ||
287 | 2024.10.09 22:52:55.081099 [ 3 ] {} <Debug> HTTP-Session: 3443c615-7431-49c5-b102-e419187a1d78 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
288 | 2024.10.09 22:52:55.081115 [ 3 ] {} <Debug> HTTP-Session: 3443c615-7431-49c5-b102-e419187a1d78 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
289 | 2024.10.09 22:52:55.081161 [ 3 ] {} <Trace> HTTP-Session: 3443c615-7431-49c5-b102-e419187a1d78 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
290 | 2024.10.09 22:52:55.081482 [ 3 ] {2a88ffb7-80ce-47f5-bbf3-2db2be13a741} <Debug> executeQuery: (from [::1]:62818) 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:55.081546 [ 3 ] {2a88ffb7-80ce-47f5-bbf3-2db2be13a741} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
292 | 2024.10.09 22:52:55.083936 [ 3 ] {2a88ffb7-80ce-47f5-bbf3-2db2be13a741} <Debug> oximeter.measurements_i16 (6e0d01f8-5dde-4e49-a788-c76eea461be6): Loading data parts | ||
293 | 2024.10.09 22:52:55.084233 [ 3 ] {2a88ffb7-80ce-47f5-bbf3-2db2be13a741} <Debug> oximeter.measurements_i16 (6e0d01f8-5dde-4e49-a788-c76eea461be6): There are no data parts | ||
294 | 2024.10.09 22:52:55.086012 [ 3 ] {2a88ffb7-80ce-47f5-bbf3-2db2be13a741} <Debug> DynamicQueryHandler: Done processing query | ||
295 | 2024.10.09 22:52:55.086053 [ 3 ] {} <Debug> HTTP-Session: 3443c615-7431-49c5-b102-e419187a1d78 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
296 | 2024.10.09 22:52:55.086950 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
297 | 2024.10.09 22:52:55.087021 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
298 | 2024.10.09 22:52:55.087059 [ 3 ] {} <Debug> HTTP-Session: f83554c0-f06a-4045-b301-bdcdaed0261e Authenticating user 'default' from [::1]:62818 | ||
299 | 2024.10.09 22:52:55.087087 [ 3 ] {} <Debug> HTTP-Session: f83554c0-f06a-4045-b301-bdcdaed0261e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
300 | 2024.10.09 22:52:55.087105 [ 3 ] {} <Debug> HTTP-Session: f83554c0-f06a-4045-b301-bdcdaed0261e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
301 | 2024.10.09 22:52:55.087163 [ 3 ] {} <Trace> HTTP-Session: f83554c0-f06a-4045-b301-bdcdaed0261e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
302 | 2024.10.09 22:52:55.087470 [ 3 ] {c28c6a84-9cde-486c-9f40-d709612fe7a5} <Debug> executeQuery: (from [::1]:62818) 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:55.087549 [ 3 ] {c28c6a84-9cde-486c-9f40-d709612fe7a5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
304 | 2024.10.09 22:52:55.089918 [ 3 ] {c28c6a84-9cde-486c-9f40-d709612fe7a5} <Debug> oximeter.measurements_u16 (6a490b80-e404-4f9e-8d73-60e131c90462): Loading data parts | ||
305 | 2024.10.09 22:52:55.090336 [ 3 ] {c28c6a84-9cde-486c-9f40-d709612fe7a5} <Debug> oximeter.measurements_u16 (6a490b80-e404-4f9e-8d73-60e131c90462): There are no data parts | ||
306 | 2024.10.09 22:52:55.092160 [ 3 ] {c28c6a84-9cde-486c-9f40-d709612fe7a5} <Debug> DynamicQueryHandler: Done processing query | ||
307 | 2024.10.09 22:52:55.092190 [ 3 ] {} <Debug> HTTP-Session: f83554c0-f06a-4045-b301-bdcdaed0261e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
308 | 2024.10.09 22:52:55.092942 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
309 | 2024.10.09 22:52:55.093025 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
310 | 2024.10.09 22:52:55.093052 [ 3 ] {} <Debug> HTTP-Session: 03f9a92d-63f2-4d07-8daa-638e7933a3ef Authenticating user 'default' from [::1]:62818 | ||
311 | 2024.10.09 22:52:55.093077 [ 3 ] {} <Debug> HTTP-Session: 03f9a92d-63f2-4d07-8daa-638e7933a3ef Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
312 | 2024.10.09 22:52:55.093102 [ 3 ] {} <Debug> HTTP-Session: 03f9a92d-63f2-4d07-8daa-638e7933a3ef Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
313 | 2024.10.09 22:52:55.093151 [ 3 ] {} <Trace> HTTP-Session: 03f9a92d-63f2-4d07-8daa-638e7933a3ef Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
314 | 2024.10.09 22:52:55.093450 [ 3 ] {d13a441d-f472-4582-b65b-911d3829025c} <Debug> executeQuery: (from [::1]:62818) 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:55.093515 [ 3 ] {d13a441d-f472-4582-b65b-911d3829025c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
316 | 2024.10.09 22:52:55.095815 [ 3 ] {d13a441d-f472-4582-b65b-911d3829025c} <Debug> oximeter.measurements_i32 (adfa5423-b4ec-4edf-835e-31148e6c45c5): Loading data parts | ||
317 | 2024.10.09 22:52:55.096139 [ 3 ] {d13a441d-f472-4582-b65b-911d3829025c} <Debug> oximeter.measurements_i32 (adfa5423-b4ec-4edf-835e-31148e6c45c5): There are no data parts | ||
318 | 2024.10.09 22:52:55.097936 [ 3 ] {d13a441d-f472-4582-b65b-911d3829025c} <Debug> DynamicQueryHandler: Done processing query | ||
319 | 2024.10.09 22:52:55.097975 [ 3 ] {} <Debug> HTTP-Session: 03f9a92d-63f2-4d07-8daa-638e7933a3ef Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
320 | 2024.10.09 22:52:55.098943 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
321 | 2024.10.09 22:52:55.099034 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
322 | 2024.10.09 22:52:55.099089 [ 3 ] {} <Debug> HTTP-Session: fab10e2c-c8db-47d8-966c-20453b9ea6e9 Authenticating user 'default' from [::1]:62818 | ||
323 | 2024.10.09 22:52:55.099115 [ 3 ] {} <Debug> HTTP-Session: fab10e2c-c8db-47d8-966c-20453b9ea6e9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
324 | 2024.10.09 22:52:55.099130 [ 3 ] {} <Debug> HTTP-Session: fab10e2c-c8db-47d8-966c-20453b9ea6e9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
325 | 2024.10.09 22:52:55.099185 [ 3 ] {} <Trace> HTTP-Session: fab10e2c-c8db-47d8-966c-20453b9ea6e9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
326 | 2024.10.09 22:52:55.099477 [ 3 ] {d8a03007-c286-4540-8f67-6a7f79f178a2} <Debug> executeQuery: (from [::1]:62818) 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:55.099550 [ 3 ] {d8a03007-c286-4540-8f67-6a7f79f178a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
328 | 2024.10.09 22:52:55.101871 [ 3 ] {d8a03007-c286-4540-8f67-6a7f79f178a2} <Debug> oximeter.measurements_u32 (3456083b-1ac7-4859-9483-1966fe25bddc): Loading data parts | ||
329 | 2024.10.09 22:52:55.102140 [ 3 ] {d8a03007-c286-4540-8f67-6a7f79f178a2} <Debug> oximeter.measurements_u32 (3456083b-1ac7-4859-9483-1966fe25bddc): There are no data parts | ||
330 | 2024.10.09 22:52:55.103853 [ 3 ] {d8a03007-c286-4540-8f67-6a7f79f178a2} <Debug> DynamicQueryHandler: Done processing query | ||
331 | 2024.10.09 22:52:55.103880 [ 3 ] {} <Debug> HTTP-Session: fab10e2c-c8db-47d8-966c-20453b9ea6e9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
332 | 2024.10.09 22:52:55.108770 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
333 | 2024.10.09 22:52:55.108903 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
334 | 2024.10.09 22:52:55.108932 [ 3 ] {} <Debug> HTTP-Session: faf3e764-d922-411e-b526-1c2b42918b8f Authenticating user 'default' from [::1]:62818 | ||
335 | 2024.10.09 22:52:55.108985 [ 3 ] {} <Debug> HTTP-Session: faf3e764-d922-411e-b526-1c2b42918b8f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
336 | 2024.10.09 22:52:55.109015 [ 3 ] {} <Debug> HTTP-Session: faf3e764-d922-411e-b526-1c2b42918b8f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
337 | 2024.10.09 22:52:55.109074 [ 3 ] {} <Trace> HTTP-Session: faf3e764-d922-411e-b526-1c2b42918b8f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
338 | 2024.10.09 22:52:55.109448 [ 3 ] {d16d7137-176c-411b-b395-8b74694f737e} <Debug> executeQuery: (from [::1]:62818) 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:55.109535 [ 3 ] {d16d7137-176c-411b-b395-8b74694f737e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
340 | 2024.10.09 22:52:55.111917 [ 3 ] {d16d7137-176c-411b-b395-8b74694f737e} <Debug> oximeter.measurements_i64 (d66dbe62-4d9e-43ca-8e57-e2d8fca2c21b): Loading data parts | ||
341 | 2024.10.09 22:52:55.112325 [ 3 ] {d16d7137-176c-411b-b395-8b74694f737e} <Debug> oximeter.measurements_i64 (d66dbe62-4d9e-43ca-8e57-e2d8fca2c21b): There are no data parts | ||
342 | 2024.10.09 22:52:55.114037 [ 3 ] {d16d7137-176c-411b-b395-8b74694f737e} <Debug> DynamicQueryHandler: Done processing query | ||
343 | 2024.10.09 22:52:55.114066 [ 3 ] {} <Debug> HTTP-Session: faf3e764-d922-411e-b526-1c2b42918b8f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
344 | 2024.10.09 22:52:55.115180 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
345 | 2024.10.09 22:52:55.115283 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
346 | 2024.10.09 22:52:55.115310 [ 3 ] {} <Debug> HTTP-Session: a05970a6-6c49-43f7-9f6d-f790bcf48835 Authenticating user 'default' from [::1]:62818 | ||
347 | 2024.10.09 22:52:55.115346 [ 3 ] {} <Debug> HTTP-Session: a05970a6-6c49-43f7-9f6d-f790bcf48835 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
348 | 2024.10.09 22:52:55.115364 [ 3 ] {} <Debug> HTTP-Session: a05970a6-6c49-43f7-9f6d-f790bcf48835 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
349 | 2024.10.09 22:52:55.115410 [ 3 ] {} <Trace> HTTP-Session: a05970a6-6c49-43f7-9f6d-f790bcf48835 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
350 | 2024.10.09 22:52:55.115727 [ 3 ] {1fe2d2fb-506c-4c26-a4e0-b1f39549a3bd} <Debug> executeQuery: (from [::1]:62818) 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:55.115813 [ 3 ] {1fe2d2fb-506c-4c26-a4e0-b1f39549a3bd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
352 | 2024.10.09 22:52:55.118121 [ 3 ] {1fe2d2fb-506c-4c26-a4e0-b1f39549a3bd} <Debug> oximeter.measurements_u64 (c98ca766-00a3-4bed-bd39-daeaa9723c59): Loading data parts | ||
353 | 2024.10.09 22:52:55.118396 [ 3 ] {1fe2d2fb-506c-4c26-a4e0-b1f39549a3bd} <Debug> oximeter.measurements_u64 (c98ca766-00a3-4bed-bd39-daeaa9723c59): There are no data parts | ||
354 | 2024.10.09 22:52:55.120247 [ 3 ] {1fe2d2fb-506c-4c26-a4e0-b1f39549a3bd} <Debug> DynamicQueryHandler: Done processing query | ||
355 | 2024.10.09 22:52:55.120277 [ 3 ] {} <Debug> HTTP-Session: a05970a6-6c49-43f7-9f6d-f790bcf48835 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
356 | 2024.10.09 22:52:55.121013 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
357 | 2024.10.09 22:52:55.121114 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
358 | 2024.10.09 22:52:55.121137 [ 3 ] {} <Debug> HTTP-Session: 453e0ea8-e6ae-4687-8963-ceaee76fc550 Authenticating user 'default' from [::1]:62818 | ||
359 | 2024.10.09 22:52:55.121159 [ 3 ] {} <Debug> HTTP-Session: 453e0ea8-e6ae-4687-8963-ceaee76fc550 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
360 | 2024.10.09 22:52:55.121172 [ 3 ] {} <Debug> HTTP-Session: 453e0ea8-e6ae-4687-8963-ceaee76fc550 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
361 | 2024.10.09 22:52:55.121222 [ 3 ] {} <Trace> HTTP-Session: 453e0ea8-e6ae-4687-8963-ceaee76fc550 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
362 | 2024.10.09 22:52:55.121499 [ 3 ] {4556d55a-f8b7-47a3-a22b-ee488b22f589} <Debug> executeQuery: (from [::1]:62818) 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:55.121578 [ 3 ] {4556d55a-f8b7-47a3-a22b-ee488b22f589} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
364 | 2024.10.09 22:52:55.123717 [ 3 ] {4556d55a-f8b7-47a3-a22b-ee488b22f589} <Debug> oximeter.measurements_f32 (5edc9fc5-4a61-48a4-9a55-4fcf9076d644): Loading data parts | ||
365 | 2024.10.09 22:52:55.124131 [ 3 ] {4556d55a-f8b7-47a3-a22b-ee488b22f589} <Debug> oximeter.measurements_f32 (5edc9fc5-4a61-48a4-9a55-4fcf9076d644): There are no data parts | ||
366 | 2024.10.09 22:52:55.125884 [ 3 ] {4556d55a-f8b7-47a3-a22b-ee488b22f589} <Debug> DynamicQueryHandler: Done processing query | ||
367 | 2024.10.09 22:52:55.125911 [ 3 ] {} <Debug> HTTP-Session: 453e0ea8-e6ae-4687-8963-ceaee76fc550 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
368 | 2024.10.09 22:52:55.126984 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
369 | 2024.10.09 22:52:55.127056 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
370 | 2024.10.09 22:52:55.127080 [ 3 ] {} <Debug> HTTP-Session: 4c98c1a7-4eaf-4c6b-b8ca-45888b69cb5c Authenticating user 'default' from [::1]:62818 | ||
371 | 2024.10.09 22:52:55.127115 [ 3 ] {} <Debug> HTTP-Session: 4c98c1a7-4eaf-4c6b-b8ca-45888b69cb5c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
372 | 2024.10.09 22:52:55.127131 [ 3 ] {} <Debug> HTTP-Session: 4c98c1a7-4eaf-4c6b-b8ca-45888b69cb5c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
373 | 2024.10.09 22:52:55.127174 [ 3 ] {} <Trace> HTTP-Session: 4c98c1a7-4eaf-4c6b-b8ca-45888b69cb5c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
374 | 2024.10.09 22:52:55.127455 [ 3 ] {e23f88e9-ccf3-4579-9d3d-95989aa34e8c} <Debug> executeQuery: (from [::1]:62818) 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:55.127541 [ 3 ] {e23f88e9-ccf3-4579-9d3d-95989aa34e8c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
376 | 2024.10.09 22:52:55.129909 [ 3 ] {e23f88e9-ccf3-4579-9d3d-95989aa34e8c} <Debug> oximeter.measurements_f64 (3a907806-c4fa-44f8-8697-7e8c940ab232): Loading data parts | ||
377 | 2024.10.09 22:52:55.130238 [ 3 ] {e23f88e9-ccf3-4579-9d3d-95989aa34e8c} <Debug> oximeter.measurements_f64 (3a907806-c4fa-44f8-8697-7e8c940ab232): There are no data parts | ||
378 | 2024.10.09 22:52:55.132040 [ 3 ] {e23f88e9-ccf3-4579-9d3d-95989aa34e8c} <Debug> DynamicQueryHandler: Done processing query | ||
379 | 2024.10.09 22:52:55.132087 [ 3 ] {} <Debug> HTTP-Session: 4c98c1a7-4eaf-4c6b-b8ca-45888b69cb5c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
380 | 2024.10.09 22:52:55.132857 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
381 | 2024.10.09 22:52:55.132930 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
382 | 2024.10.09 22:52:55.132966 [ 3 ] {} <Debug> HTTP-Session: bf4783ec-90d8-4dd0-b29d-ae7d42178bce Authenticating user 'default' from [::1]:62818 | ||
383 | 2024.10.09 22:52:55.132990 [ 3 ] {} <Debug> HTTP-Session: bf4783ec-90d8-4dd0-b29d-ae7d42178bce Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
384 | 2024.10.09 22:52:55.133043 [ 3 ] {} <Debug> HTTP-Session: bf4783ec-90d8-4dd0-b29d-ae7d42178bce Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
385 | 2024.10.09 22:52:55.133099 [ 3 ] {} <Trace> HTTP-Session: bf4783ec-90d8-4dd0-b29d-ae7d42178bce Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
386 | 2024.10.09 22:52:55.133412 [ 3 ] {625fc483-9349-4518-87a4-ebb17508dc85} <Debug> executeQuery: (from [::1]:62818) 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:55.133488 [ 3 ] {625fc483-9349-4518-87a4-ebb17508dc85} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
388 | 2024.10.09 22:52:55.135774 [ 3 ] {625fc483-9349-4518-87a4-ebb17508dc85} <Debug> oximeter.measurements_string (f54beab9-c584-40a2-9dab-436aba2172bb): Loading data parts | ||
389 | 2024.10.09 22:52:55.136049 [ 3 ] {625fc483-9349-4518-87a4-ebb17508dc85} <Debug> oximeter.measurements_string (f54beab9-c584-40a2-9dab-436aba2172bb): There are no data parts | ||
390 | 2024.10.09 22:52:55.137804 [ 3 ] {625fc483-9349-4518-87a4-ebb17508dc85} <Debug> DynamicQueryHandler: Done processing query | ||
391 | 2024.10.09 22:52:55.137897 [ 3 ] {} <Debug> HTTP-Session: bf4783ec-90d8-4dd0-b29d-ae7d42178bce Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
392 | 2024.10.09 22:52:55.138712 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
393 | 2024.10.09 22:52:55.138810 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
394 | 2024.10.09 22:52:55.138835 [ 3 ] {} <Debug> HTTP-Session: b594c1dd-4c13-4469-b895-74fd4b790f05 Authenticating user 'default' from [::1]:62818 | ||
395 | 2024.10.09 22:52:55.138858 [ 3 ] {} <Debug> HTTP-Session: b594c1dd-4c13-4469-b895-74fd4b790f05 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
396 | 2024.10.09 22:52:55.138929 [ 3 ] {} <Debug> HTTP-Session: b594c1dd-4c13-4469-b895-74fd4b790f05 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
397 | 2024.10.09 22:52:55.138982 [ 3 ] {} <Trace> HTTP-Session: b594c1dd-4c13-4469-b895-74fd4b790f05 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
398 | 2024.10.09 22:52:55.139292 [ 3 ] {43420faf-4643-4824-bb06-5b9368b9eeb4} <Debug> executeQuery: (from [::1]:62818) 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:55.139451 [ 3 ] {43420faf-4643-4824-bb06-5b9368b9eeb4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
407 | 2024.10.09 22:52:55.141802 [ 3 ] {43420faf-4643-4824-bb06-5b9368b9eeb4} <Debug> oximeter.measurements_bytes (01e50f87-d057-4df4-b0e6-a8f9319f15d5): Loading data parts | ||
408 | 2024.10.09 22:52:55.142121 [ 3 ] {43420faf-4643-4824-bb06-5b9368b9eeb4} <Debug> oximeter.measurements_bytes (01e50f87-d057-4df4-b0e6-a8f9319f15d5): There are no data parts | ||
409 | 2024.10.09 22:52:55.143772 [ 3 ] {43420faf-4643-4824-bb06-5b9368b9eeb4} <Debug> DynamicQueryHandler: Done processing query | ||
410 | 2024.10.09 22:52:55.143798 [ 3 ] {} <Debug> HTTP-Session: b594c1dd-4c13-4469-b895-74fd4b790f05 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
411 | 2024.10.09 22:52:55.145768 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
412 | 2024.10.09 22:52:55.145861 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
413 | 2024.10.09 22:52:55.145911 [ 3 ] {} <Debug> HTTP-Session: 553153d7-54e3-4034-bb48-283598eee520 Authenticating user 'default' from [::1]:62818 | ||
414 | 2024.10.09 22:52:55.145939 [ 3 ] {} <Debug> HTTP-Session: 553153d7-54e3-4034-bb48-283598eee520 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
415 | 2024.10.09 22:52:55.145964 [ 3 ] {} <Debug> HTTP-Session: 553153d7-54e3-4034-bb48-283598eee520 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
416 | 2024.10.09 22:52:55.146017 [ 3 ] {} <Trace> HTTP-Session: 553153d7-54e3-4034-bb48-283598eee520 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
417 | 2024.10.09 22:52:55.146360 [ 3 ] {bb727fc9-7d66-4092-9cd5-6b04f5ab99f4} <Debug> executeQuery: (from [::1]:62818) 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:55.146432 [ 3 ] {bb727fc9-7d66-4092-9cd5-6b04f5ab99f4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
419 | 2024.10.09 22:52:55.148908 [ 3 ] {bb727fc9-7d66-4092-9cd5-6b04f5ab99f4} <Debug> oximeter.measurements_cumulativei64 (1b3b12fd-6dfd-4955-9420-69fdfc48bd3d): Loading data parts | ||
420 | 2024.10.09 22:52:55.149213 [ 3 ] {bb727fc9-7d66-4092-9cd5-6b04f5ab99f4} <Debug> oximeter.measurements_cumulativei64 (1b3b12fd-6dfd-4955-9420-69fdfc48bd3d): There are no data parts | ||
421 | 2024.10.09 22:52:55.151185 [ 3 ] {bb727fc9-7d66-4092-9cd5-6b04f5ab99f4} <Debug> DynamicQueryHandler: Done processing query | ||
422 | 2024.10.09 22:52:55.151228 [ 3 ] {} <Debug> HTTP-Session: 553153d7-54e3-4034-bb48-283598eee520 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
423 | 2024.10.09 22:52:55.151910 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
424 | 2024.10.09 22:52:55.151983 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
425 | 2024.10.09 22:52:55.152021 [ 3 ] {} <Debug> HTTP-Session: 874de325-61cd-4c40-bf30-4f8963f16b5c Authenticating user 'default' from [::1]:62818 | ||
426 | 2024.10.09 22:52:55.152048 [ 3 ] {} <Debug> HTTP-Session: 874de325-61cd-4c40-bf30-4f8963f16b5c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
427 | 2024.10.09 22:52:55.152062 [ 3 ] {} <Debug> HTTP-Session: 874de325-61cd-4c40-bf30-4f8963f16b5c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
428 | 2024.10.09 22:52:55.152114 [ 3 ] {} <Trace> HTTP-Session: 874de325-61cd-4c40-bf30-4f8963f16b5c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
429 | 2024.10.09 22:52:55.152427 [ 3 ] {c96e03b1-ab2b-45d0-8350-3f219cac5a0d} <Debug> executeQuery: (from [::1]:62818) 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:55.152524 [ 3 ] {c96e03b1-ab2b-45d0-8350-3f219cac5a0d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
431 | 2024.10.09 22:52:55.154958 [ 3 ] {c96e03b1-ab2b-45d0-8350-3f219cac5a0d} <Debug> oximeter.measurements_cumulativeu64 (f22535e8-024e-40f5-a135-b1341ba457c5): Loading data parts | ||
432 | 2024.10.09 22:52:55.155257 [ 3 ] {c96e03b1-ab2b-45d0-8350-3f219cac5a0d} <Debug> oximeter.measurements_cumulativeu64 (f22535e8-024e-40f5-a135-b1341ba457c5): There are no data parts | ||
433 | 2024.10.09 22:52:55.157214 [ 3 ] {c96e03b1-ab2b-45d0-8350-3f219cac5a0d} <Debug> DynamicQueryHandler: Done processing query | ||
434 | 2024.10.09 22:52:55.157242 [ 3 ] {} <Debug> HTTP-Session: 874de325-61cd-4c40-bf30-4f8963f16b5c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
435 | 2024.10.09 22:52:55.270867 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
436 | 2024.10.09 22:52:55.270999 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
437 | 2024.10.09 22:52:55.271029 [ 3 ] {} <Debug> HTTP-Session: 78cbf584-6c2b-4b07-b433-572c2b3cc4a6 Authenticating user 'default' from [::1]:62818 | ||
438 | 2024.10.09 22:52:55.271075 [ 3 ] {} <Debug> HTTP-Session: 78cbf584-6c2b-4b07-b433-572c2b3cc4a6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
439 | 2024.10.09 22:52:55.271089 [ 3 ] {} <Debug> HTTP-Session: 78cbf584-6c2b-4b07-b433-572c2b3cc4a6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
440 | 2024.10.09 22:52:55.271147 [ 3 ] {} <Trace> HTTP-Session: 78cbf584-6c2b-4b07-b433-572c2b3cc4a6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
441 | 2024.10.09 22:52:55.272960 [ 3 ] {a8253686-c027-4b0a-a901-50d480b63916} <Debug> executeQuery: (from [::1]:62818) 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:55.273063 [ 3 ] {a8253686-c027-4b0a-a901-50d480b63916} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
443 | 2024.10.09 22:52:55.276918 [ 3 ] {a8253686-c027-4b0a-a901-50d480b63916} <Debug> oximeter.measurements_cumulativef32 (25c78773-eaee-4b68-8e09-5c172a502c5e): Loading data parts | ||
444 | 2024.10.09 22:52:55.277802 [ 3 ] {a8253686-c027-4b0a-a901-50d480b63916} <Debug> oximeter.measurements_cumulativef32 (25c78773-eaee-4b68-8e09-5c172a502c5e): There are no data parts | ||
445 | 2024.10.09 22:52:55.279907 [ 3 ] {a8253686-c027-4b0a-a901-50d480b63916} <Debug> DynamicQueryHandler: Done processing query | ||
446 | 2024.10.09 22:52:55.280099 [ 3 ] {} <Debug> HTTP-Session: 78cbf584-6c2b-4b07-b433-572c2b3cc4a6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
447 | 2024.10.09 22:52:55.285092 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
448 | 2024.10.09 22:52:55.285300 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
449 | 2024.10.09 22:52:55.285335 [ 3 ] {} <Debug> HTTP-Session: dcb4e9c2-1353-4ace-8411-9cc3ff9f90c1 Authenticating user 'default' from [::1]:62818 | ||
450 | 2024.10.09 22:52:55.285366 [ 3 ] {} <Debug> HTTP-Session: dcb4e9c2-1353-4ace-8411-9cc3ff9f90c1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
451 | 2024.10.09 22:52:55.285393 [ 3 ] {} <Debug> HTTP-Session: dcb4e9c2-1353-4ace-8411-9cc3ff9f90c1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
452 | 2024.10.09 22:52:55.285487 [ 3 ] {} <Trace> HTTP-Session: dcb4e9c2-1353-4ace-8411-9cc3ff9f90c1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
453 | 2024.10.09 22:52:55.285877 [ 3 ] {dd92cace-d312-4489-b383-0547f05ef0f6} <Debug> executeQuery: (from [::1]:62818) 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:55.285969 [ 3 ] {dd92cace-d312-4489-b383-0547f05ef0f6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
455 | 2024.10.09 22:52:55.288633 [ 3 ] {dd92cace-d312-4489-b383-0547f05ef0f6} <Debug> oximeter.measurements_cumulativef64 (02382daf-524f-43ec-9663-d3caacd61306): Loading data parts | ||
456 | 2024.10.09 22:52:55.288976 [ 3 ] {dd92cace-d312-4489-b383-0547f05ef0f6} <Debug> oximeter.measurements_cumulativef64 (02382daf-524f-43ec-9663-d3caacd61306): There are no data parts | ||
457 | 2024.10.09 22:52:55.290840 [ 3 ] {dd92cace-d312-4489-b383-0547f05ef0f6} <Debug> DynamicQueryHandler: Done processing query | ||
458 | 2024.10.09 22:52:55.290884 [ 3 ] {} <Debug> HTTP-Session: dcb4e9c2-1353-4ace-8411-9cc3ff9f90c1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
459 | 2024.10.09 22:52:55.292986 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
460 | 2024.10.09 22:52:55.293091 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
461 | 2024.10.09 22:52:55.293132 [ 3 ] {} <Debug> HTTP-Session: 71977045-b133-4e72-b92e-955d574bd9ad Authenticating user 'default' from [::1]:62818 | ||
462 | 2024.10.09 22:52:55.293160 [ 3 ] {} <Debug> HTTP-Session: 71977045-b133-4e72-b92e-955d574bd9ad Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
463 | 2024.10.09 22:52:55.293176 [ 3 ] {} <Debug> HTTP-Session: 71977045-b133-4e72-b92e-955d574bd9ad Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
464 | 2024.10.09 22:52:55.293227 [ 3 ] {} <Trace> HTTP-Session: 71977045-b133-4e72-b92e-955d574bd9ad Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
465 | 2024.10.09 22:52:55.293693 [ 3 ] {77b28093-e124-4f11-a9b1-56014d525fce} <Debug> executeQuery: (from [::1]:62818) 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:55.293793 [ 3 ] {77b28093-e124-4f11-a9b1-56014d525fce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
477 | 2024.10.09 22:52:55.299405 [ 3 ] {77b28093-e124-4f11-a9b1-56014d525fce} <Debug> oximeter.measurements_histogrami8 (568215ac-29fd-415f-b85a-0ac0e8a94413): Loading data parts | ||
478 | 2024.10.09 22:52:55.299705 [ 3 ] {77b28093-e124-4f11-a9b1-56014d525fce} <Debug> oximeter.measurements_histogrami8 (568215ac-29fd-415f-b85a-0ac0e8a94413): There are no data parts | ||
479 | 2024.10.09 22:52:55.301741 [ 3 ] {77b28093-e124-4f11-a9b1-56014d525fce} <Debug> DynamicQueryHandler: Done processing query | ||
480 | 2024.10.09 22:52:55.301772 [ 3 ] {} <Debug> HTTP-Session: 71977045-b133-4e72-b92e-955d574bd9ad Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
481 | 2024.10.09 22:52:55.307514 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
482 | 2024.10.09 22:52:55.307626 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
483 | 2024.10.09 22:52:55.307650 [ 3 ] {} <Debug> HTTP-Session: bb96dfe1-b875-43a7-b3ed-6df18858e33f Authenticating user 'default' from [::1]:62818 | ||
484 | 2024.10.09 22:52:55.307675 [ 3 ] {} <Debug> HTTP-Session: bb96dfe1-b875-43a7-b3ed-6df18858e33f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
485 | 2024.10.09 22:52:55.307689 [ 3 ] {} <Debug> HTTP-Session: bb96dfe1-b875-43a7-b3ed-6df18858e33f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
486 | 2024.10.09 22:52:55.307749 [ 3 ] {} <Trace> HTTP-Session: bb96dfe1-b875-43a7-b3ed-6df18858e33f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
487 | 2024.10.09 22:52:55.308200 [ 3 ] {015ffe39-85ee-4523-9968-c52ea4b45e56} <Debug> executeQuery: (from [::1]:62818) 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:55.308299 [ 3 ] {015ffe39-85ee-4523-9968-c52ea4b45e56} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
489 | 2024.10.09 22:52:55.311551 [ 3 ] {015ffe39-85ee-4523-9968-c52ea4b45e56} <Debug> oximeter.measurements_histogramu8 (26c24b64-ed28-4367-9630-805b12074842): Loading data parts | ||
490 | 2024.10.09 22:52:55.311901 [ 3 ] {015ffe39-85ee-4523-9968-c52ea4b45e56} <Debug> oximeter.measurements_histogramu8 (26c24b64-ed28-4367-9630-805b12074842): There are no data parts | ||
491 | 2024.10.09 22:52:55.313731 [ 3 ] {015ffe39-85ee-4523-9968-c52ea4b45e56} <Debug> DynamicQueryHandler: Done processing query | ||
492 | 2024.10.09 22:52:55.313758 [ 3 ] {} <Debug> HTTP-Session: bb96dfe1-b875-43a7-b3ed-6df18858e33f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
493 | 2024.10.09 22:52:55.317965 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
494 | 2024.10.09 22:52:55.318060 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
495 | 2024.10.09 22:52:55.318091 [ 3 ] {} <Debug> HTTP-Session: 687ffd13-2bdd-4edb-b015-7ca06983f62c Authenticating user 'default' from [::1]:62818 | ||
496 | 2024.10.09 22:52:55.318137 [ 3 ] {} <Debug> HTTP-Session: 687ffd13-2bdd-4edb-b015-7ca06983f62c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
497 | 2024.10.09 22:52:55.318155 [ 3 ] {} <Debug> HTTP-Session: 687ffd13-2bdd-4edb-b015-7ca06983f62c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
498 | 2024.10.09 22:52:55.318211 [ 3 ] {} <Trace> HTTP-Session: 687ffd13-2bdd-4edb-b015-7ca06983f62c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
499 | 2024.10.09 22:52:55.318693 [ 3 ] {ab4f841f-0f12-41a1-861e-c455286a5006} <Debug> executeQuery: (from [::1]:62818) 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:55.318809 [ 3 ] {ab4f841f-0f12-41a1-861e-c455286a5006} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
501 | 2024.10.09 22:52:55.321900 [ 3 ] {ab4f841f-0f12-41a1-861e-c455286a5006} <Debug> oximeter.measurements_histogrami16 (603775b4-db85-44e3-a22f-4759d79f20cb): Loading data parts | ||
502 | 2024.10.09 22:52:55.322253 [ 3 ] {ab4f841f-0f12-41a1-861e-c455286a5006} <Debug> oximeter.measurements_histogrami16 (603775b4-db85-44e3-a22f-4759d79f20cb): There are no data parts | ||
503 | 2024.10.09 22:52:55.325563 [ 3 ] {ab4f841f-0f12-41a1-861e-c455286a5006} <Debug> DynamicQueryHandler: Done processing query | ||
504 | 2024.10.09 22:52:55.325607 [ 3 ] {} <Debug> HTTP-Session: 687ffd13-2bdd-4edb-b015-7ca06983f62c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
505 | 2024.10.09 22:52:55.338439 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
506 | 2024.10.09 22:52:55.338563 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
507 | 2024.10.09 22:52:55.338617 [ 3 ] {} <Debug> HTTP-Session: 1fb157ed-8468-41f0-822a-998994e8c0c2 Authenticating user 'default' from [::1]:62818 | ||
508 | 2024.10.09 22:52:55.338650 [ 3 ] {} <Debug> HTTP-Session: 1fb157ed-8468-41f0-822a-998994e8c0c2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
509 | 2024.10.09 22:52:55.338672 [ 3 ] {} <Debug> HTTP-Session: 1fb157ed-8468-41f0-822a-998994e8c0c2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
510 | 2024.10.09 22:52:55.338762 [ 3 ] {} <Trace> HTTP-Session: 1fb157ed-8468-41f0-822a-998994e8c0c2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
511 | 2024.10.09 22:52:55.339418 [ 3 ] {e59d611d-396c-4d76-ac41-028d0de55db8} <Debug> executeQuery: (from [::1]:62818) 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:55.339577 [ 3 ] {e59d611d-396c-4d76-ac41-028d0de55db8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
513 | 2024.10.09 22:52:55.342704 [ 3 ] {e59d611d-396c-4d76-ac41-028d0de55db8} <Debug> oximeter.measurements_histogramu16 (d66f41fc-323c-4bf8-b3a9-dd6c42d8cfef): Loading data parts | ||
514 | 2024.10.09 22:52:55.343090 [ 3 ] {e59d611d-396c-4d76-ac41-028d0de55db8} <Debug> oximeter.measurements_histogramu16 (d66f41fc-323c-4bf8-b3a9-dd6c42d8cfef): There are no data parts | ||
515 | 2024.10.09 22:52:55.345007 [ 3 ] {e59d611d-396c-4d76-ac41-028d0de55db8} <Debug> DynamicQueryHandler: Done processing query | ||
516 | 2024.10.09 22:52:55.345040 [ 3 ] {} <Debug> HTTP-Session: 1fb157ed-8468-41f0-822a-998994e8c0c2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
517 | 2024.10.09 22:52:55.353459 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
518 | 2024.10.09 22:52:55.353592 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
519 | 2024.10.09 22:52:55.353621 [ 3 ] {} <Debug> HTTP-Session: 192817c0-e82e-4d10-8f9e-d89c001715e4 Authenticating user 'default' from [::1]:62818 | ||
520 | 2024.10.09 22:52:55.353650 [ 3 ] {} <Debug> HTTP-Session: 192817c0-e82e-4d10-8f9e-d89c001715e4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
521 | 2024.10.09 22:52:55.355096 [ 3 ] {} <Debug> HTTP-Session: 192817c0-e82e-4d10-8f9e-d89c001715e4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
522 | 2024.10.09 22:52:55.355194 [ 3 ] {} <Trace> HTTP-Session: 192817c0-e82e-4d10-8f9e-d89c001715e4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
523 | 2024.10.09 22:52:55.355698 [ 3 ] {5fb081fe-b28a-4fcd-b8da-c0896fadea29} <Debug> executeQuery: (from [::1]:62818) 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:55.355799 [ 3 ] {5fb081fe-b28a-4fcd-b8da-c0896fadea29} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
525 | 2024.10.09 22:52:55.359037 [ 3 ] {5fb081fe-b28a-4fcd-b8da-c0896fadea29} <Debug> oximeter.measurements_histogrami32 (8a540025-9c52-4c3c-bffd-c793f127bd12): Loading data parts | ||
526 | 2024.10.09 22:52:55.359535 [ 3 ] {5fb081fe-b28a-4fcd-b8da-c0896fadea29} <Debug> oximeter.measurements_histogrami32 (8a540025-9c52-4c3c-bffd-c793f127bd12): There are no data parts | ||
527 | 2024.10.09 22:52:55.361350 [ 3 ] {5fb081fe-b28a-4fcd-b8da-c0896fadea29} <Debug> DynamicQueryHandler: Done processing query | ||
528 | 2024.10.09 22:52:55.361394 [ 3 ] {} <Debug> HTTP-Session: 192817c0-e82e-4d10-8f9e-d89c001715e4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
529 | 2024.10.09 22:52:55.362603 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
530 | 2024.10.09 22:52:55.362672 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
531 | 2024.10.09 22:52:55.362710 [ 3 ] {} <Debug> HTTP-Session: 92bcc449-bf3e-41e2-a33b-c83ea1135e2e Authenticating user 'default' from [::1]:62818 | ||
532 | 2024.10.09 22:52:55.362734 [ 3 ] {} <Debug> HTTP-Session: 92bcc449-bf3e-41e2-a33b-c83ea1135e2e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
533 | 2024.10.09 22:52:55.362859 [ 3 ] {} <Debug> HTTP-Session: 92bcc449-bf3e-41e2-a33b-c83ea1135e2e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
534 | 2024.10.09 22:52:55.362943 [ 3 ] {} <Trace> HTTP-Session: 92bcc449-bf3e-41e2-a33b-c83ea1135e2e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
535 | 2024.10.09 22:52:55.363369 [ 3 ] {3bbcefad-491e-404e-b72c-05f8b31f1535} <Debug> executeQuery: (from [::1]:62818) 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:55.363464 [ 3 ] {3bbcefad-491e-404e-b72c-05f8b31f1535} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
537 | 2024.10.09 22:52:55.366245 [ 3 ] {3bbcefad-491e-404e-b72c-05f8b31f1535} <Debug> oximeter.measurements_histogramu32 (bc4f0d41-2cc6-4952-9610-d41a3c814e7f): Loading data parts | ||
538 | 2024.10.09 22:52:55.366669 [ 3 ] {3bbcefad-491e-404e-b72c-05f8b31f1535} <Debug> oximeter.measurements_histogramu32 (bc4f0d41-2cc6-4952-9610-d41a3c814e7f): There are no data parts | ||
539 | 2024.10.09 22:52:55.369417 [ 3 ] {3bbcefad-491e-404e-b72c-05f8b31f1535} <Debug> DynamicQueryHandler: Done processing query | ||
540 | 2024.10.09 22:52:55.369443 [ 3 ] {} <Debug> HTTP-Session: 92bcc449-bf3e-41e2-a33b-c83ea1135e2e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
541 | 2024.10.09 22:52:55.380090 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
542 | 2024.10.09 22:52:55.380205 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
543 | 2024.10.09 22:52:55.380227 [ 3 ] {} <Debug> HTTP-Session: 1307f4dd-dcb3-4855-bea5-983f414b2ea7 Authenticating user 'default' from [::1]:62818 | ||
544 | 2024.10.09 22:52:55.380249 [ 3 ] {} <Debug> HTTP-Session: 1307f4dd-dcb3-4855-bea5-983f414b2ea7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
545 | 2024.10.09 22:52:55.380272 [ 3 ] {} <Debug> HTTP-Session: 1307f4dd-dcb3-4855-bea5-983f414b2ea7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
546 | 2024.10.09 22:52:55.380349 [ 3 ] {} <Trace> HTTP-Session: 1307f4dd-dcb3-4855-bea5-983f414b2ea7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
547 | 2024.10.09 22:52:55.380798 [ 3 ] {f5576680-e4fa-41f9-b9e3-02742766ecc9} <Debug> executeQuery: (from [::1]:62818) 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:55.380920 [ 3 ] {f5576680-e4fa-41f9-b9e3-02742766ecc9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
549 | 2024.10.09 22:52:55.384115 [ 3 ] {f5576680-e4fa-41f9-b9e3-02742766ecc9} <Debug> oximeter.measurements_histogrami64 (0e09d42d-ef69-49c8-957c-fcd1d2750b5d): Loading data parts | ||
550 | 2024.10.09 22:52:55.384644 [ 3 ] {f5576680-e4fa-41f9-b9e3-02742766ecc9} <Debug> oximeter.measurements_histogrami64 (0e09d42d-ef69-49c8-957c-fcd1d2750b5d): There are no data parts | ||
551 | 2024.10.09 22:52:55.386521 [ 3 ] {f5576680-e4fa-41f9-b9e3-02742766ecc9} <Debug> DynamicQueryHandler: Done processing query | ||
552 | 2024.10.09 22:52:55.386550 [ 3 ] {} <Debug> HTTP-Session: 1307f4dd-dcb3-4855-bea5-983f414b2ea7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
553 | 2024.10.09 22:52:55.387334 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
554 | 2024.10.09 22:52:55.387421 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
555 | 2024.10.09 22:52:55.387445 [ 3 ] {} <Debug> HTTP-Session: 60ba4f64-fa49-4761-ab35-54e41a702b35 Authenticating user 'default' from [::1]:62818 | ||
556 | 2024.10.09 22:52:55.387518 [ 3 ] {} <Debug> HTTP-Session: 60ba4f64-fa49-4761-ab35-54e41a702b35 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
557 | 2024.10.09 22:52:55.387540 [ 3 ] {} <Debug> HTTP-Session: 60ba4f64-fa49-4761-ab35-54e41a702b35 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
558 | 2024.10.09 22:52:55.387591 [ 3 ] {} <Trace> HTTP-Session: 60ba4f64-fa49-4761-ab35-54e41a702b35 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
559 | 2024.10.09 22:52:55.388087 [ 3 ] {01a8c021-6abb-4691-a2dc-b18e35ebbf53} <Debug> executeQuery: (from [::1]:62818) 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:55.388179 [ 3 ] {01a8c021-6abb-4691-a2dc-b18e35ebbf53} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
561 | 2024.10.09 22:52:55.399045 [ 3 ] {01a8c021-6abb-4691-a2dc-b18e35ebbf53} <Debug> oximeter.measurements_histogramu64 (bfdd0223-bf35-4c27-a42d-d8252150cb92): Loading data parts | ||
562 | 2024.10.09 22:52:55.408718 [ 3 ] {01a8c021-6abb-4691-a2dc-b18e35ebbf53} <Debug> oximeter.measurements_histogramu64 (bfdd0223-bf35-4c27-a42d-d8252150cb92): There are no data parts | ||
563 | 2024.10.09 22:52:55.429679 [ 3 ] {01a8c021-6abb-4691-a2dc-b18e35ebbf53} <Debug> DynamicQueryHandler: Done processing query | ||
564 | 2024.10.09 22:52:55.429730 [ 3 ] {} <Debug> HTTP-Session: 60ba4f64-fa49-4761-ab35-54e41a702b35 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
565 | 2024.10.09 22:52:55.430481 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
566 | 2024.10.09 22:52:55.430632 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
567 | 2024.10.09 22:52:55.430666 [ 3 ] {} <Debug> HTTP-Session: c61b8ca1-2b49-4e5f-890e-fd82138f6e86 Authenticating user 'default' from [::1]:62818 | ||
568 | 2024.10.09 22:52:55.430695 [ 3 ] {} <Debug> HTTP-Session: c61b8ca1-2b49-4e5f-890e-fd82138f6e86 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
569 | 2024.10.09 22:52:55.430711 [ 3 ] {} <Debug> HTTP-Session: c61b8ca1-2b49-4e5f-890e-fd82138f6e86 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
570 | 2024.10.09 22:52:55.430785 [ 3 ] {} <Trace> HTTP-Session: c61b8ca1-2b49-4e5f-890e-fd82138f6e86 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
571 | 2024.10.09 22:52:55.431388 [ 3 ] {49afaac6-c6cd-4349-9e08-901c219f51ce} <Debug> executeQuery: (from [::1]:62818) 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:55.431494 [ 3 ] {49afaac6-c6cd-4349-9e08-901c219f51ce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
573 | 2024.10.09 22:52:55.436034 [ 3 ] {49afaac6-c6cd-4349-9e08-901c219f51ce} <Debug> oximeter.measurements_histogramf32 (d5f3e50e-7620-424c-9f8b-ac69d49247d1): Loading data parts | ||
574 | 2024.10.09 22:52:55.436449 [ 3 ] {49afaac6-c6cd-4349-9e08-901c219f51ce} <Debug> oximeter.measurements_histogramf32 (d5f3e50e-7620-424c-9f8b-ac69d49247d1): There are no data parts | ||
575 | 2024.10.09 22:52:55.439202 [ 3 ] {49afaac6-c6cd-4349-9e08-901c219f51ce} <Debug> DynamicQueryHandler: Done processing query | ||
576 | 2024.10.09 22:52:55.439236 [ 3 ] {} <Debug> HTTP-Session: c61b8ca1-2b49-4e5f-890e-fd82138f6e86 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
577 | 2024.10.09 22:52:55.440238 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
578 | 2024.10.09 22:52:55.440320 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
579 | 2024.10.09 22:52:55.440349 [ 3 ] {} <Debug> HTTP-Session: 113d1b44-d24d-4b2b-a5ee-4fe6e8a85747 Authenticating user 'default' from [::1]:62818 | ||
580 | 2024.10.09 22:52:55.440387 [ 3 ] {} <Debug> HTTP-Session: 113d1b44-d24d-4b2b-a5ee-4fe6e8a85747 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
581 | 2024.10.09 22:52:55.440402 [ 3 ] {} <Debug> HTTP-Session: 113d1b44-d24d-4b2b-a5ee-4fe6e8a85747 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
582 | 2024.10.09 22:52:55.440450 [ 3 ] {} <Trace> HTTP-Session: 113d1b44-d24d-4b2b-a5ee-4fe6e8a85747 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
583 | 2024.10.09 22:52:55.440955 [ 3 ] {aea5e077-46dc-4c0f-8f10-e7f76ea152c1} <Debug> executeQuery: (from [::1]:62818) 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:55.442776 [ 3 ] {aea5e077-46dc-4c0f-8f10-e7f76ea152c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
585 | 2024.10.09 22:52:55.445938 [ 3 ] {aea5e077-46dc-4c0f-8f10-e7f76ea152c1} <Debug> oximeter.measurements_histogramf64 (d1eaf5b2-d269-47d4-9924-490570275016): Loading data parts | ||
586 | 2024.10.09 22:52:55.446251 [ 3 ] {aea5e077-46dc-4c0f-8f10-e7f76ea152c1} <Debug> oximeter.measurements_histogramf64 (d1eaf5b2-d269-47d4-9924-490570275016): There are no data parts | ||
587 | 2024.10.09 22:52:55.447980 [ 3 ] {aea5e077-46dc-4c0f-8f10-e7f76ea152c1} <Debug> DynamicQueryHandler: Done processing query | ||
588 | 2024.10.09 22:52:55.448023 [ 3 ] {} <Debug> HTTP-Session: 113d1b44-d24d-4b2b-a5ee-4fe6e8a85747 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
589 | 2024.10.09 22:52:55.448827 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
590 | 2024.10.09 22:52:55.448893 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
591 | 2024.10.09 22:52:55.448927 [ 3 ] {} <Debug> HTTP-Session: 3f4ae1fa-c816-42ca-a2ba-f1d0c7a0888d Authenticating user 'default' from [::1]:62818 | ||
592 | 2024.10.09 22:52:55.448953 [ 3 ] {} <Debug> HTTP-Session: 3f4ae1fa-c816-42ca-a2ba-f1d0c7a0888d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
593 | 2024.10.09 22:52:55.448968 [ 3 ] {} <Debug> HTTP-Session: 3f4ae1fa-c816-42ca-a2ba-f1d0c7a0888d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
594 | 2024.10.09 22:52:55.449022 [ 3 ] {} <Trace> HTTP-Session: 3f4ae1fa-c816-42ca-a2ba-f1d0c7a0888d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
595 | 2024.10.09 22:52:55.449311 [ 3 ] {a98638dc-72b4-4db2-a3fb-e815c8202719} <Debug> executeQuery: (from [::1]:62818) /* 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:55.449385 [ 3 ] {a98638dc-72b4-4db2-a3fb-e815c8202719} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
622 | 2024.10.09 22:52:55.452539 [ 3 ] {a98638dc-72b4-4db2-a3fb-e815c8202719} <Debug> oximeter.fields_bool (97447495-e4c6-4490-a40a-c8226dde8d7e): Loading data parts | ||
623 | 2024.10.09 22:52:55.453828 [ 3 ] {a98638dc-72b4-4db2-a3fb-e815c8202719} <Debug> oximeter.fields_bool (97447495-e4c6-4490-a40a-c8226dde8d7e): There are no data parts | ||
624 | 2024.10.09 22:52:55.461419 [ 3 ] {a98638dc-72b4-4db2-a3fb-e815c8202719} <Debug> DynamicQueryHandler: Done processing query | ||
625 | 2024.10.09 22:52:55.461462 [ 3 ] {} <Debug> HTTP-Session: 3f4ae1fa-c816-42ca-a2ba-f1d0c7a0888d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
626 | 2024.10.09 22:52:55.462280 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
627 | 2024.10.09 22:52:55.462391 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
628 | 2024.10.09 22:52:55.462415 [ 3 ] {} <Debug> HTTP-Session: 841b1b8d-77bd-4cd5-bad5-9c055349e992 Authenticating user 'default' from [::1]:62818 | ||
629 | 2024.10.09 22:52:55.462440 [ 3 ] {} <Debug> HTTP-Session: 841b1b8d-77bd-4cd5-bad5-9c055349e992 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
630 | 2024.10.09 22:52:55.462464 [ 3 ] {} <Debug> HTTP-Session: 841b1b8d-77bd-4cd5-bad5-9c055349e992 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
631 | 2024.10.09 22:52:55.462515 [ 3 ] {} <Trace> HTTP-Session: 841b1b8d-77bd-4cd5-bad5-9c055349e992 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
632 | 2024.10.09 22:52:55.462840 [ 3 ] {eab2952c-070a-4a1c-86e9-323b44e5fe8f} <Debug> executeQuery: (from [::1]:62818) 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:55.462918 [ 3 ] {eab2952c-070a-4a1c-86e9-323b44e5fe8f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
634 | 2024.10.09 22:52:55.470406 [ 3 ] {eab2952c-070a-4a1c-86e9-323b44e5fe8f} <Debug> oximeter.fields_i8 (c1c4f994-f7ef-4ef5-8cbf-ab7282fdc266): Loading data parts | ||
635 | 2024.10.09 22:52:55.470762 [ 3 ] {eab2952c-070a-4a1c-86e9-323b44e5fe8f} <Debug> oximeter.fields_i8 (c1c4f994-f7ef-4ef5-8cbf-ab7282fdc266): There are no data parts | ||
636 | 2024.10.09 22:52:55.472559 [ 3 ] {eab2952c-070a-4a1c-86e9-323b44e5fe8f} <Debug> DynamicQueryHandler: Done processing query | ||
637 | 2024.10.09 22:52:55.474556 [ 3 ] {} <Debug> HTTP-Session: 841b1b8d-77bd-4cd5-bad5-9c055349e992 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
638 | 2024.10.09 22:52:55.475166 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
639 | 2024.10.09 22:52:55.475245 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
640 | 2024.10.09 22:52:55.475269 [ 3 ] {} <Debug> HTTP-Session: f5de25b7-1485-457a-bc98-94fbce9ded8b Authenticating user 'default' from [::1]:62818 | ||
641 | 2024.10.09 22:52:55.475307 [ 3 ] {} <Debug> HTTP-Session: f5de25b7-1485-457a-bc98-94fbce9ded8b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
642 | 2024.10.09 22:52:55.475322 [ 3 ] {} <Debug> HTTP-Session: f5de25b7-1485-457a-bc98-94fbce9ded8b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
643 | 2024.10.09 22:52:55.475371 [ 3 ] {} <Trace> HTTP-Session: f5de25b7-1485-457a-bc98-94fbce9ded8b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
644 | 2024.10.09 22:52:55.475733 [ 3 ] {0b81a701-de48-4a43-b158-08f6dcfd2ab3} <Debug> executeQuery: (from [::1]:62818) 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:55.475819 [ 3 ] {0b81a701-de48-4a43-b158-08f6dcfd2ab3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
646 | 2024.10.09 22:52:55.479001 [ 3 ] {0b81a701-de48-4a43-b158-08f6dcfd2ab3} <Debug> oximeter.fields_u8 (8e647c5d-8752-451d-845d-2579af0d8a0a): Loading data parts | ||
647 | 2024.10.09 22:52:55.479316 [ 3 ] {0b81a701-de48-4a43-b158-08f6dcfd2ab3} <Debug> oximeter.fields_u8 (8e647c5d-8752-451d-845d-2579af0d8a0a): There are no data parts | ||
648 | 2024.10.09 22:52:55.481948 [ 3 ] {0b81a701-de48-4a43-b158-08f6dcfd2ab3} <Debug> DynamicQueryHandler: Done processing query | ||
649 | 2024.10.09 22:52:55.481981 [ 3 ] {} <Debug> HTTP-Session: f5de25b7-1485-457a-bc98-94fbce9ded8b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
650 | 2024.10.09 22:52:55.482642 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
651 | 2024.10.09 22:52:55.482817 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
652 | 2024.10.09 22:52:55.482850 [ 3 ] {} <Debug> HTTP-Session: bb27b5b8-2a66-468e-a262-c75a01bd96e4 Authenticating user 'default' from [::1]:62818 | ||
653 | 2024.10.09 22:52:55.482873 [ 3 ] {} <Debug> HTTP-Session: bb27b5b8-2a66-468e-a262-c75a01bd96e4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
654 | 2024.10.09 22:52:55.482935 [ 3 ] {} <Debug> HTTP-Session: bb27b5b8-2a66-468e-a262-c75a01bd96e4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
655 | 2024.10.09 22:52:55.482994 [ 3 ] {} <Trace> HTTP-Session: bb27b5b8-2a66-468e-a262-c75a01bd96e4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
656 | 2024.10.09 22:52:55.483277 [ 3 ] {86470ae2-4b8d-4097-beb7-0801e1c30c76} <Debug> executeQuery: (from [::1]:62818) 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:55.483349 [ 3 ] {86470ae2-4b8d-4097-beb7-0801e1c30c76} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
658 | 2024.10.09 22:52:55.498926 [ 3 ] {86470ae2-4b8d-4097-beb7-0801e1c30c76} <Debug> oximeter.fields_i16 (391b4988-0842-4b2a-90a5-03780d976f80): Loading data parts | ||
659 | 2024.10.09 22:52:55.508827 [ 3 ] {86470ae2-4b8d-4097-beb7-0801e1c30c76} <Debug> oximeter.fields_i16 (391b4988-0842-4b2a-90a5-03780d976f80): There are no data parts | ||
660 | 2024.10.09 22:52:55.513873 [ 3 ] {86470ae2-4b8d-4097-beb7-0801e1c30c76} <Debug> DynamicQueryHandler: Done processing query | ||
661 | 2024.10.09 22:52:55.513907 [ 3 ] {} <Debug> HTTP-Session: bb27b5b8-2a66-468e-a262-c75a01bd96e4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
662 | 2024.10.09 22:52:55.516287 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
663 | 2024.10.09 22:52:55.516378 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
664 | 2024.10.09 22:52:55.516407 [ 3 ] {} <Debug> HTTP-Session: e75d43c7-c382-489c-be32-7d84be79e026 Authenticating user 'default' from [::1]:62818 | ||
665 | 2024.10.09 22:52:55.516453 [ 3 ] {} <Debug> HTTP-Session: e75d43c7-c382-489c-be32-7d84be79e026 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
666 | 2024.10.09 22:52:55.516469 [ 3 ] {} <Debug> HTTP-Session: e75d43c7-c382-489c-be32-7d84be79e026 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
667 | 2024.10.09 22:52:55.516521 [ 3 ] {} <Trace> HTTP-Session: e75d43c7-c382-489c-be32-7d84be79e026 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
668 | 2024.10.09 22:52:55.516894 [ 3 ] {77d8d73a-da80-4735-b85a-1afd79ec0b8b} <Debug> executeQuery: (from [::1]:62818) 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:55.516983 [ 3 ] {77d8d73a-da80-4735-b85a-1afd79ec0b8b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
670 | 2024.10.09 22:52:55.521497 [ 3 ] {77d8d73a-da80-4735-b85a-1afd79ec0b8b} <Debug> oximeter.fields_u16 (aa2f88a0-537d-4a23-b977-dcded69fc51f): Loading data parts | ||
671 | 2024.10.09 22:52:55.523322 [ 3 ] {77d8d73a-da80-4735-b85a-1afd79ec0b8b} <Debug> oximeter.fields_u16 (aa2f88a0-537d-4a23-b977-dcded69fc51f): There are no data parts | ||
672 | 2024.10.09 22:52:55.525198 [ 3 ] {77d8d73a-da80-4735-b85a-1afd79ec0b8b} <Debug> DynamicQueryHandler: Done processing query | ||
673 | 2024.10.09 22:52:55.525232 [ 3 ] {} <Debug> HTTP-Session: e75d43c7-c382-489c-be32-7d84be79e026 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
674 | 2024.10.09 22:52:55.526889 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
675 | 2024.10.09 22:52:55.527025 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
676 | 2024.10.09 22:52:55.527063 [ 3 ] {} <Debug> HTTP-Session: fbff3652-bee0-4ed6-b536-534fcd449d2f Authenticating user 'default' from [::1]:62818 | ||
677 | 2024.10.09 22:52:55.527092 [ 3 ] {} <Debug> HTTP-Session: fbff3652-bee0-4ed6-b536-534fcd449d2f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
678 | 2024.10.09 22:52:55.527109 [ 3 ] {} <Debug> HTTP-Session: fbff3652-bee0-4ed6-b536-534fcd449d2f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
679 | 2024.10.09 22:52:55.527178 [ 3 ] {} <Trace> HTTP-Session: fbff3652-bee0-4ed6-b536-534fcd449d2f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
680 | 2024.10.09 22:52:55.527554 [ 3 ] {69f55b46-c832-4acc-9e0a-786ed3b42e33} <Debug> executeQuery: (from [::1]:62818) 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:55.527648 [ 3 ] {69f55b46-c832-4acc-9e0a-786ed3b42e33} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
682 | 2024.10.09 22:52:55.534204 [ 3 ] {69f55b46-c832-4acc-9e0a-786ed3b42e33} <Debug> oximeter.fields_i32 (e615cf68-3495-4f3e-8b3f-7395dc22cf44): Loading data parts | ||
683 | 2024.10.09 22:52:55.534513 [ 3 ] {69f55b46-c832-4acc-9e0a-786ed3b42e33} <Debug> oximeter.fields_i32 (e615cf68-3495-4f3e-8b3f-7395dc22cf44): There are no data parts | ||
684 | 2024.10.09 22:52:55.536315 [ 3 ] {69f55b46-c832-4acc-9e0a-786ed3b42e33} <Debug> DynamicQueryHandler: Done processing query | ||
685 | 2024.10.09 22:52:55.536345 [ 3 ] {} <Debug> HTTP-Session: fbff3652-bee0-4ed6-b536-534fcd449d2f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
686 | 2024.10.09 22:52:55.537290 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
687 | 2024.10.09 22:52:55.537365 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
688 | 2024.10.09 22:52:55.537389 [ 3 ] {} <Debug> HTTP-Session: 7332fb94-dd92-43fb-b0e0-caec628d4ffe Authenticating user 'default' from [::1]:62818 | ||
689 | 2024.10.09 22:52:55.537429 [ 3 ] {} <Debug> HTTP-Session: 7332fb94-dd92-43fb-b0e0-caec628d4ffe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
690 | 2024.10.09 22:52:55.537442 [ 3 ] {} <Debug> HTTP-Session: 7332fb94-dd92-43fb-b0e0-caec628d4ffe Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
691 | 2024.10.09 22:52:55.537491 [ 3 ] {} <Trace> HTTP-Session: 7332fb94-dd92-43fb-b0e0-caec628d4ffe Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
692 | 2024.10.09 22:52:55.537859 [ 3 ] {388631d3-3322-4805-ad16-5f3d4a6b06fd} <Debug> executeQuery: (from [::1]:62818) 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:55.537962 [ 3 ] {388631d3-3322-4805-ad16-5f3d4a6b06fd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
694 | 2024.10.09 22:52:55.541080 [ 3 ] {388631d3-3322-4805-ad16-5f3d4a6b06fd} <Debug> oximeter.fields_u32 (6bbcb7e2-7bc1-43e5-8c12-9cbfdd37113c): Loading data parts | ||
695 | 2024.10.09 22:52:55.541399 [ 3 ] {388631d3-3322-4805-ad16-5f3d4a6b06fd} <Debug> oximeter.fields_u32 (6bbcb7e2-7bc1-43e5-8c12-9cbfdd37113c): There are no data parts | ||
696 | 2024.10.09 22:52:55.546163 [ 3 ] {388631d3-3322-4805-ad16-5f3d4a6b06fd} <Debug> DynamicQueryHandler: Done processing query | ||
697 | 2024.10.09 22:52:55.546219 [ 3 ] {} <Debug> HTTP-Session: 7332fb94-dd92-43fb-b0e0-caec628d4ffe Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
698 | 2024.10.09 22:52:55.546966 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
699 | 2024.10.09 22:52:55.547063 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
700 | 2024.10.09 22:52:55.547103 [ 3 ] {} <Debug> HTTP-Session: 35325792-304c-44ae-8b38-0e8bdb6739a3 Authenticating user 'default' from [::1]:62818 | ||
701 | 2024.10.09 22:52:55.547129 [ 3 ] {} <Debug> HTTP-Session: 35325792-304c-44ae-8b38-0e8bdb6739a3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
702 | 2024.10.09 22:52:55.547144 [ 3 ] {} <Debug> HTTP-Session: 35325792-304c-44ae-8b38-0e8bdb6739a3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
703 | 2024.10.09 22:52:55.547207 [ 3 ] {} <Trace> HTTP-Session: 35325792-304c-44ae-8b38-0e8bdb6739a3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
704 | 2024.10.09 22:52:55.547518 [ 3 ] {34813a33-a928-447b-b51c-bd9309bb4b6b} <Debug> executeQuery: (from [::1]:62818) 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:55.547634 [ 3 ] {34813a33-a928-447b-b51c-bd9309bb4b6b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
706 | 2024.10.09 22:52:55.556192 [ 3 ] {34813a33-a928-447b-b51c-bd9309bb4b6b} <Debug> oximeter.fields_i64 (f613a11b-dc0e-4833-b3cc-94ce0d080119): Loading data parts | ||
707 | 2024.10.09 22:52:55.559249 [ 3 ] {34813a33-a928-447b-b51c-bd9309bb4b6b} <Debug> oximeter.fields_i64 (f613a11b-dc0e-4833-b3cc-94ce0d080119): There are no data parts | ||
708 | 2024.10.09 22:52:55.564186 [ 3 ] {34813a33-a928-447b-b51c-bd9309bb4b6b} <Debug> DynamicQueryHandler: Done processing query | ||
709 | 2024.10.09 22:52:55.564228 [ 3 ] {} <Debug> HTTP-Session: 35325792-304c-44ae-8b38-0e8bdb6739a3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
710 | 2024.10.09 22:52:55.565048 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
711 | 2024.10.09 22:52:55.565194 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
712 | 2024.10.09 22:52:55.565221 [ 3 ] {} <Debug> HTTP-Session: 10825380-72c9-4d39-81a2-92b4e79f7b6a Authenticating user 'default' from [::1]:62818 | ||
713 | 2024.10.09 22:52:55.565246 [ 3 ] {} <Debug> HTTP-Session: 10825380-72c9-4d39-81a2-92b4e79f7b6a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
714 | 2024.10.09 22:52:55.565260 [ 3 ] {} <Debug> HTTP-Session: 10825380-72c9-4d39-81a2-92b4e79f7b6a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
715 | 2024.10.09 22:52:55.565310 [ 3 ] {} <Trace> HTTP-Session: 10825380-72c9-4d39-81a2-92b4e79f7b6a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
716 | 2024.10.09 22:52:55.565613 [ 3 ] {af440aa3-b428-4fd2-a13d-a5e44ec8cb47} <Debug> executeQuery: (from [::1]:62818) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
717 | 2024.10.09 22:52:55.565682 [ 3 ] {af440aa3-b428-4fd2-a13d-a5e44ec8cb47} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
718 | 2024.10.09 22:52:55.569194 [ 3 ] {af440aa3-b428-4fd2-a13d-a5e44ec8cb47} <Debug> oximeter.fields_u64 (fcf73068-429a-43c6-be4b-997b4c186e9c): Loading data parts | ||
719 | 2024.10.09 22:52:55.569980 [ 3 ] {af440aa3-b428-4fd2-a13d-a5e44ec8cb47} <Debug> oximeter.fields_u64 (fcf73068-429a-43c6-be4b-997b4c186e9c): There are no data parts | ||
720 | 2024.10.09 22:52:55.572590 [ 3 ] {af440aa3-b428-4fd2-a13d-a5e44ec8cb47} <Debug> DynamicQueryHandler: Done processing query | ||
721 | 2024.10.09 22:52:55.572627 [ 3 ] {} <Debug> HTTP-Session: 10825380-72c9-4d39-81a2-92b4e79f7b6a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
722 | 2024.10.09 22:52:55.573393 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
723 | 2024.10.09 22:52:55.573536 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
724 | 2024.10.09 22:52:55.573566 [ 3 ] {} <Debug> HTTP-Session: 702625eb-9527-4b68-8c15-09567a8aca18 Authenticating user 'default' from [::1]:62818 | ||
725 | 2024.10.09 22:52:55.573590 [ 3 ] {} <Debug> HTTP-Session: 702625eb-9527-4b68-8c15-09567a8aca18 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
726 | 2024.10.09 22:52:55.573604 [ 3 ] {} <Debug> HTTP-Session: 702625eb-9527-4b68-8c15-09567a8aca18 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
727 | 2024.10.09 22:52:55.573652 [ 3 ] {} <Trace> HTTP-Session: 702625eb-9527-4b68-8c15-09567a8aca18 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
728 | 2024.10.09 22:52:55.574060 [ 3 ] {219c18cd-1a3c-4991-8fb2-75d1745b059d} <Debug> executeQuery: (from [::1]:62818) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
729 | 2024.10.09 22:52:55.574129 [ 3 ] {219c18cd-1a3c-4991-8fb2-75d1745b059d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
730 | 2024.10.09 22:52:55.577274 [ 3 ] {219c18cd-1a3c-4991-8fb2-75d1745b059d} <Debug> oximeter.fields_ipaddr (3e81bffc-1b4a-48be-8181-36b5446d7221): Loading data parts | ||
731 | 2024.10.09 22:52:55.577592 [ 3 ] {219c18cd-1a3c-4991-8fb2-75d1745b059d} <Debug> oximeter.fields_ipaddr (3e81bffc-1b4a-48be-8181-36b5446d7221): There are no data parts | ||
732 | 2024.10.09 22:52:55.579814 [ 3 ] {219c18cd-1a3c-4991-8fb2-75d1745b059d} <Debug> DynamicQueryHandler: Done processing query | ||
733 | 2024.10.09 22:52:55.579844 [ 3 ] {} <Debug> HTTP-Session: 702625eb-9527-4b68-8c15-09567a8aca18 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
734 | 2024.10.09 22:52:55.580452 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
735 | 2024.10.09 22:52:55.580525 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
736 | 2024.10.09 22:52:55.580554 [ 3 ] {} <Debug> HTTP-Session: ce3eb075-5e36-4d22-8b8d-6515735287ad Authenticating user 'default' from [::1]:62818 | ||
737 | 2024.10.09 22:52:55.580581 [ 3 ] {} <Debug> HTTP-Session: ce3eb075-5e36-4d22-8b8d-6515735287ad Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
738 | 2024.10.09 22:52:55.580674 [ 3 ] {} <Debug> HTTP-Session: ce3eb075-5e36-4d22-8b8d-6515735287ad Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
739 | 2024.10.09 22:52:55.580738 [ 3 ] {} <Trace> HTTP-Session: ce3eb075-5e36-4d22-8b8d-6515735287ad Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
740 | 2024.10.09 22:52:55.581030 [ 3 ] {3cf88e0d-6617-4913-ab57-36e527a505e2} <Debug> executeQuery: (from [::1]:62818) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
741 | 2024.10.09 22:52:55.581096 [ 3 ] {3cf88e0d-6617-4913-ab57-36e527a505e2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
742 | 2024.10.09 22:52:55.583743 [ 3 ] {3cf88e0d-6617-4913-ab57-36e527a505e2} <Debug> oximeter.fields_string (30c4502b-c6a5-47b7-bea6-55e7723682db): Loading data parts | ||
743 | 2024.10.09 22:52:55.584028 [ 3 ] {3cf88e0d-6617-4913-ab57-36e527a505e2} <Debug> oximeter.fields_string (30c4502b-c6a5-47b7-bea6-55e7723682db): There are no data parts | ||
744 | 2024.10.09 22:52:55.588133 [ 3 ] {3cf88e0d-6617-4913-ab57-36e527a505e2} <Debug> DynamicQueryHandler: Done processing query | ||
745 | 2024.10.09 22:52:55.588172 [ 3 ] {} <Debug> HTTP-Session: ce3eb075-5e36-4d22-8b8d-6515735287ad Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
746 | 2024.10.09 22:52:55.588808 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
747 | 2024.10.09 22:52:55.588883 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
748 | 2024.10.09 22:52:55.588910 [ 3 ] {} <Debug> HTTP-Session: 8bb5e867-9cb9-49d4-8ee6-065368c8766a Authenticating user 'default' from [::1]:62818 | ||
749 | 2024.10.09 22:52:55.588937 [ 3 ] {} <Debug> HTTP-Session: 8bb5e867-9cb9-49d4-8ee6-065368c8766a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
750 | 2024.10.09 22:52:55.588951 [ 3 ] {} <Debug> HTTP-Session: 8bb5e867-9cb9-49d4-8ee6-065368c8766a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
751 | 2024.10.09 22:52:55.588998 [ 3 ] {} <Trace> HTTP-Session: 8bb5e867-9cb9-49d4-8ee6-065368c8766a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
752 | 2024.10.09 22:52:55.589316 [ 3 ] {71bebba7-1339-4fdd-bbda-5aeb98aba133} <Debug> executeQuery: (from [::1]:62818) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
753 | 2024.10.09 22:52:55.589450 [ 3 ] {71bebba7-1339-4fdd-bbda-5aeb98aba133} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
754 | 2024.10.09 22:52:55.591903 [ 3 ] {71bebba7-1339-4fdd-bbda-5aeb98aba133} <Debug> oximeter.fields_uuid (efc20584-d440-45ff-b98e-b71fd4e12f87): Loading data parts | ||
755 | 2024.10.09 22:52:55.592202 [ 3 ] {71bebba7-1339-4fdd-bbda-5aeb98aba133} <Debug> oximeter.fields_uuid (efc20584-d440-45ff-b98e-b71fd4e12f87): There are no data parts | ||
756 | 2024.10.09 22:52:55.593837 [ 3 ] {71bebba7-1339-4fdd-bbda-5aeb98aba133} <Debug> DynamicQueryHandler: Done processing query | ||
757 | 2024.10.09 22:52:55.593866 [ 3 ] {} <Debug> HTTP-Session: 8bb5e867-9cb9-49d4-8ee6-065368c8766a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
758 | 2024.10.09 22:52:55.594542 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
759 | 2024.10.09 22:52:55.594609 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
760 | 2024.10.09 22:52:55.594634 [ 3 ] {} <Debug> HTTP-Session: 6e97fd32-5cbe-468b-850f-57aaee9e3643 Authenticating user 'default' from [::1]:62818 | ||
761 | 2024.10.09 22:52:55.594657 [ 3 ] {} <Debug> HTTP-Session: 6e97fd32-5cbe-468b-850f-57aaee9e3643 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
762 | 2024.10.09 22:52:55.594673 [ 3 ] {} <Debug> HTTP-Session: 6e97fd32-5cbe-468b-850f-57aaee9e3643 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
763 | 2024.10.09 22:52:55.594718 [ 3 ] {} <Trace> HTTP-Session: 6e97fd32-5cbe-468b-850f-57aaee9e3643 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
764 | 2024.10.09 22:52:55.595213 [ 3 ] {2909ddfa-505d-4473-b0a1-f0ce9acaa181} <Debug> executeQuery: (from [::1]:62818) /* The timeseries schema table stores the extracted schema for the samples | ||
765 | * oximeter collects. | ||
766 | */ | ||
767 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
768 | 2024.10.09 22:52:55.595308 [ 3 ] {2909ddfa-505d-4473-b0a1-f0ce9acaa181} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
769 | 2024.10.09 22:52:55.597545 [ 3 ] {2909ddfa-505d-4473-b0a1-f0ce9acaa181} <Debug> oximeter.timeseries_schema (05128770-78b5-4f87-8f64-1f42daedc902): Loading data parts | ||
770 | 2024.10.09 22:52:55.598153 [ 3 ] {2909ddfa-505d-4473-b0a1-f0ce9acaa181} <Debug> oximeter.timeseries_schema (05128770-78b5-4f87-8f64-1f42daedc902): There are no data parts | ||
771 | 2024.10.09 22:52:55.600026 [ 3 ] {2909ddfa-505d-4473-b0a1-f0ce9acaa181} <Debug> DynamicQueryHandler: Done processing query | ||
772 | 2024.10.09 22:52:55.600055 [ 3 ] {} <Debug> HTTP-Session: 6e97fd32-5cbe-468b-850f-57aaee9e3643 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
773 | 2024.10.09 22:52:55.600710 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:62818, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
774 | 2024.10.09 22:52:55.600842 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
775 | 2024.10.09 22:52:55.600872 [ 3 ] {} <Debug> HTTP-Session: 0c575b30-4744-4c7d-bca2-a81be4fa3666 Authenticating user 'default' from [::1]:62818 | ||
776 | 2024.10.09 22:52:55.600896 [ 3 ] {} <Debug> HTTP-Session: 0c575b30-4744-4c7d-bca2-a81be4fa3666 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
777 | 2024.10.09 22:52:55.600913 [ 3 ] {} <Debug> HTTP-Session: 0c575b30-4744-4c7d-bca2-a81be4fa3666 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
778 | 2024.10.09 22:52:55.600962 [ 3 ] {} <Trace> HTTP-Session: 0c575b30-4744-4c7d-bca2-a81be4fa3666 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
779 | 2024.10.09 22:52:55.601290 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Debug> executeQuery: (from [::1]:62818) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
780 | 2024.10.09 22:52:55.601957 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
781 | 2024.10.09 22:52:55.625197 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Trace> oximeter.version (78817511-dcb8-4b84-a05d-c4fc1495b3c5): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
782 | 2024.10.09 22:52:55.626939 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.12 GiB. | ||
783 | 2024.10.09 22:52:55.628059 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
784 | 2024.10.09 22:52:55.628646 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Trace> oximeter.version (78817511-dcb8-4b84-a05d-c4fc1495b3c5): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
785 | 2024.10.09 22:52:55.629070 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.02799 sec., 35.72704537334762 rows/sec., 571.63 B/sec. | ||
786 | 2024.10.09 22:52:55.629832 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Debug> DynamicQueryHandler: Done processing query | ||
787 | 2024.10.09 22:52:55.629867 [ 3 ] {87f28a0d-0c72-4ea9-93e0-607ad36e21b7} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
788 | 2024.10.09 22:52:55.629888 [ 3 ] {} <Debug> HTTP-Session: 0c575b30-4744-4c7d-bca2-a81be4fa3666 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
789 | 2024.10.09 22:52:57.350331 [ 173 ] {} <Debug> DNSResolver: Updating DNS cache | ||
790 | 2024.10.09 22:52:57.350401 [ 173 ] {} <Debug> DNSResolver: Updated DNS cache |