1 | 2024.10.09 22:51:44.909835 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 19782 | ||
2 | 2024.10.09 22:51:44.909996 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.10.09 22:51:44.910035 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.10.09 22:51:44.917511 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.10.09 22:51:44.921962 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.10.09 22:51:44.922011 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.10.09 22:51:44.922024 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.10.09 22:51:44.922103 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_snapshot_stopped_instance.19775.1-clickhouse-3pPF3A/datastore/tmp/ to store temporary data in it | ||
9 | 2024.10.09 22:51:44.923339 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.10.09 22:51:44.924095 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
11 | 2024.10.09 22:51:44.924599 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
12 | 2024.10.09 22:51:44.925246 [ 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:51:44.925389 [ 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:51:44.925411 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.10.09 22:51:44.925501 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.10.09 22:51:44.926513 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.10.09 22:51:44.942546 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.10.09 22:51:44.943266 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.10.09 22:51:44.944116 [ 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:51:44.944171 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
21 | 2024.10.09 22:51:44.945457 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
22 | 2024.10.09 22:51:44.948224 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
23 | 2024.10.09 22:51:44.950622 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
24 | 2024.10.09 22:51:44.951311 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
25 | 2024.10.09 22:51:44.991433 [ 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:51:44.991905 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.10.09 22:51:44.992355 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.10.09 22:51:44.992680 [ 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:51:44.994988 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.10.09 22:51:44.995017 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_snapshot_stopped_instance.19775.1-clickhouse-3pPF3A/datastore/ | ||
31 | 2024.10.09 22:51:44.996551 [ 183 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.10.09 22:51:44.996608 [ 183 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.10.09 22:51:45.002780 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.10.09 22:51:45.002819 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000186781 sec | ||
35 | 2024.10.09 22:51:45.002841 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.10.09 22:51:45.002853 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.10.09 22:51:45.002944 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.10.09 22:51:45.003008 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
39 | 2024.10.09 22:51:45.003047 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
40 | 2024.10.09 22:51:45.003063 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.10.09 22:51:45.003081 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.10.09 22:51:45.003111 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.10.09 22:51:45.003124 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.10.09 22:51:45.003145 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
45 | 2024.10.09 22:51:45.003183 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2024.10.09 22:51:45.003199 [ 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:51:45.003213 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
48 | 2024.10.09 22:51:45.003231 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2024.10.09 22:51:45.003250 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2024.10.09 22:51:45.003275 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.10.09 22:51:45.003295 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.10.09 22:51:45.003328 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2024.10.09 22:51:45.003343 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2024.10.09 22:51:45.003360 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2024.10.09 22:51:45.047858 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.10.09 22:51:45.058916 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.10.09 22:51:45.059017 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000154073 sec | ||
58 | 2024.10.09 22:51:45.059039 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.10.09 22:51:45.059049 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.10.09 22:51:45.059083 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.10.09 22:51:45.059331 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_snapshot_stopped_instance.19775.1-clickhouse-3pPF3A/datastore/user_defined/ | ||
62 | 2024.10.09 22:51:45.059395 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.10.09 22:51:45.059408 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.10.09 22:51:45.059419 [ 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:51:45.059435 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.10.09 22:51:45.059637 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44291 | ||
67 | 2024.10.09 22:51:45.059803 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 36880 | ||
68 | 2024.10.09 22:51:45.061294 [ 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:51:45.061461 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 50809 | ||
70 | 2024.10.09 22:51:45.061534 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 56011 | ||
71 | 2024.10.09 22:51:45.061661 [ 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:51:45.061708 [ 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:51:45.062457 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.88 MiB, peak 16.09 MiB, free memory in arenas 0.00 B, will set to 127.19 MiB (RSS), difference: 117.31 MiB | ||
74 | 2024.10.09 22:51:45.063017 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.3449e-05 sec. | ||
75 | 2024.10.09 22:51:45.063717 [ 1 ] {} <Information> Application: Listening for http://[::1]:44291 | ||
76 | 2024.10.09 22:51:45.063783 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:36880 | ||
77 | 2024.10.09 22:51:45.063835 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:50809 | ||
78 | 2024.10.09 22:51:45.063936 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:56011 | ||
79 | 2024.10.09 22:51:45.063955 [ 1 ] {} <Information> Application: Ready for connections. | ||
80 | 2024.10.09 22:51:55.196242 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
81 | 2024.10.09 22:51:55.196456 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
82 | 2024.10.09 22:51:55.196502 [ 3 ] {} <Debug> HTTP-Session: b4678df2-64b8-4b1e-a55a-2543a8b46c5e Authenticating user 'default' from [::1]:65139 | ||
83 | 2024.10.09 22:51:55.196536 [ 3 ] {} <Debug> HTTP-Session: b4678df2-64b8-4b1e-a55a-2543a8b46c5e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2024.10.09 22:51:55.196549 [ 3 ] {} <Debug> HTTP-Session: b4678df2-64b8-4b1e-a55a-2543a8b46c5e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
85 | 2024.10.09 22:51:55.196650 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
86 | 2024.10.09 22:51:55.196696 [ 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:51:55.196724 [ 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:51:55.196777 [ 3 ] {} <Trace> HTTP-Session: b4678df2-64b8-4b1e-a55a-2543a8b46c5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
89 | 2024.10.09 22:51:55.197377 [ 3 ] {c13bafea-b39f-4494-8634-b5b1b6626e16} <Debug> executeQuery: (from [::1]:65139) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
90 | 2024.10.09 22:51:55.206165 [ 3 ] {c13bafea-b39f-4494-8634-b5b1b6626e16} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:65139) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
91 | |||
92 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
93 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
94 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
95 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
96 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
97 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
98 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
99 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
100 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
101 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
102 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
103 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
104 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
105 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
106 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
107 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
108 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
109 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
110 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
111 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
112 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
113 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
114 | |||
115 | 2024.10.09 22:51:55.206432 [ 3 ] {c13bafea-b39f-4494-8634-b5b1b6626e16} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
116 | |||
117 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
118 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
119 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
120 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
121 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
122 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
123 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
124 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
125 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
126 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
127 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
128 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
129 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
130 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
131 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
132 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
133 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
134 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
135 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
136 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
137 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
138 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
139 | (version 23.8.7.1) | ||
140 | 2024.10.09 22:51:55.206738 [ 3 ] {} <Debug> HTTP-Session: b4678df2-64b8-4b1e-a55a-2543a8b46c5e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
141 | 2024.10.09 22:51:55.268263 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
142 | 2024.10.09 22:51:55.268392 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
143 | 2024.10.09 22:51:55.268426 [ 3 ] {} <Debug> HTTP-Session: 07db9cff-3dc6-4041-892e-795afa7af0af Authenticating user 'default' from [::1]:65139 | ||
144 | 2024.10.09 22:51:55.268467 [ 3 ] {} <Debug> HTTP-Session: 07db9cff-3dc6-4041-892e-795afa7af0af Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
145 | 2024.10.09 22:51:55.268484 [ 3 ] {} <Debug> HTTP-Session: 07db9cff-3dc6-4041-892e-795afa7af0af Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2024.10.09 22:51:55.268545 [ 3 ] {} <Trace> HTTP-Session: 07db9cff-3dc6-4041-892e-795afa7af0af Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
147 | 2024.10.09 22:51:55.268795 [ 3 ] {27b5a70b-bc93-4397-b19d-fd18634f2eda} <Debug> executeQuery: (from [::1]:65139) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
148 | 2024.10.09 22:51:55.269225 [ 3 ] {27b5a70b-bc93-4397-b19d-fd18634f2eda} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:65139) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
149 | |||
150 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
151 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
152 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
153 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
154 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
155 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
156 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
157 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
158 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
159 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
160 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
161 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
162 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
163 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
164 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
165 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
166 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
167 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
168 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
169 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
170 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
171 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
172 | |||
173 | 2024.10.09 22:51:55.269410 [ 3 ] {27b5a70b-bc93-4397-b19d-fd18634f2eda} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
174 | |||
175 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
176 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
177 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
178 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
179 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
180 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
181 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
182 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
183 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
184 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
185 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
186 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
187 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
188 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
189 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
190 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
191 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
192 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
193 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
197 | (version 23.8.7.1) | ||
198 | 2024.10.09 22:51:55.269627 [ 3 ] {} <Debug> HTTP-Session: 07db9cff-3dc6-4041-892e-795afa7af0af Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
199 | 2024.10.09 22:51:55.279888 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
200 | 2024.10.09 22:51:55.280009 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
201 | 2024.10.09 22:51:55.280041 [ 3 ] {} <Debug> HTTP-Session: ea9701d8-35a4-4452-baca-26e7e92bb078 Authenticating user 'default' from [::1]:65139 | ||
202 | 2024.10.09 22:51:55.280084 [ 3 ] {} <Debug> HTTP-Session: ea9701d8-35a4-4452-baca-26e7e92bb078 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
203 | 2024.10.09 22:51:55.280102 [ 3 ] {} <Debug> HTTP-Session: ea9701d8-35a4-4452-baca-26e7e92bb078 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
204 | 2024.10.09 22:51:55.280161 [ 3 ] {} <Trace> HTTP-Session: ea9701d8-35a4-4452-baca-26e7e92bb078 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
205 | 2024.10.09 22:51:55.280477 [ 3 ] {f55da51c-4122-49c4-922d-e99b163f4c5b} <Debug> executeQuery: (from [::1]:65139) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
206 | 2024.10.09 22:51:55.280783 [ 3 ] {f55da51c-4122-49c4-922d-e99b163f4c5b} <Debug> DynamicQueryHandler: Done processing query | ||
207 | 2024.10.09 22:51:55.280815 [ 3 ] {} <Debug> HTTP-Session: ea9701d8-35a4-4452-baca-26e7e92bb078 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
208 | 2024.10.09 22:51:55.293088 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
209 | 2024.10.09 22:51:55.293213 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
210 | 2024.10.09 22:51:55.293246 [ 3 ] {} <Debug> HTTP-Session: 3a82f1d5-1b3a-4b3c-96a1-9b9d9fea5105 Authenticating user 'default' from [::1]:65139 | ||
211 | 2024.10.09 22:51:55.293290 [ 3 ] {} <Debug> HTTP-Session: 3a82f1d5-1b3a-4b3c-96a1-9b9d9fea5105 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
212 | 2024.10.09 22:51:55.293309 [ 3 ] {} <Debug> HTTP-Session: 3a82f1d5-1b3a-4b3c-96a1-9b9d9fea5105 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
213 | 2024.10.09 22:51:55.293369 [ 3 ] {} <Trace> HTTP-Session: 3a82f1d5-1b3a-4b3c-96a1-9b9d9fea5105 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
214 | 2024.10.09 22:51:55.293582 [ 3 ] {f992db56-9243-48b0-a3e2-d023307f7c3d} <Debug> executeQuery: (from [::1]:65139) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
215 | 2024.10.09 22:51:55.293675 [ 3 ] {f992db56-9243-48b0-a3e2-d023307f7c3d} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
216 | 2024.10.09 22:51:55.295218 [ 3 ] {f992db56-9243-48b0-a3e2-d023307f7c3d} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
217 | 2024.10.09 22:51:55.295258 [ 3 ] {f992db56-9243-48b0-a3e2-d023307f7c3d} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.4925e-05 sec | ||
218 | 2024.10.09 22:51:55.295274 [ 3 ] {f992db56-9243-48b0-a3e2-d023307f7c3d} <Trace> ReferentialDeps: No tables | ||
219 | 2024.10.09 22:51:55.295285 [ 3 ] {f992db56-9243-48b0-a3e2-d023307f7c3d} <Trace> LoadingDeps: No tables | ||
220 | 2024.10.09 22:51:55.295315 [ 3 ] {f992db56-9243-48b0-a3e2-d023307f7c3d} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
221 | 2024.10.09 22:51:55.295598 [ 3 ] {f992db56-9243-48b0-a3e2-d023307f7c3d} <Debug> DynamicQueryHandler: Done processing query | ||
222 | 2024.10.09 22:51:55.295632 [ 3 ] {} <Debug> HTTP-Session: 3a82f1d5-1b3a-4b3c-96a1-9b9d9fea5105 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
223 | 2024.10.09 22:51:55.303263 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
224 | 2024.10.09 22:51:55.303390 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
225 | 2024.10.09 22:51:55.303421 [ 3 ] {} <Debug> HTTP-Session: 613720f3-371c-4fd5-b3d0-fcf1b7b6e4b6 Authenticating user 'default' from [::1]:65139 | ||
226 | 2024.10.09 22:51:55.303449 [ 3 ] {} <Debug> HTTP-Session: 613720f3-371c-4fd5-b3d0-fcf1b7b6e4b6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
227 | 2024.10.09 22:51:55.303475 [ 3 ] {} <Debug> HTTP-Session: 613720f3-371c-4fd5-b3d0-fcf1b7b6e4b6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
228 | 2024.10.09 22:51:55.303532 [ 3 ] {} <Trace> HTTP-Session: 613720f3-371c-4fd5-b3d0-fcf1b7b6e4b6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
229 | 2024.10.09 22:51:55.303859 [ 3 ] {f196560e-575c-4faf-8de2-f5c1fe984328} <Debug> executeQuery: (from [::1]:65139) /* The version table contains metadata about the `oximeter` database */ | ||
230 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
231 | 2024.10.09 22:51:55.303951 [ 3 ] {f196560e-575c-4faf-8de2-f5c1fe984328} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
232 | 2024.10.09 22:51:55.305718 [ 3 ] {f196560e-575c-4faf-8de2-f5c1fe984328} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
233 | 2024.10.09 22:51:55.307045 [ 3 ] {f196560e-575c-4faf-8de2-f5c1fe984328} <Debug> oximeter.version (64ef1028-bbea-4aca-a242-a56a21010998): Loading data parts | ||
234 | 2024.10.09 22:51:55.307696 [ 3 ] {f196560e-575c-4faf-8de2-f5c1fe984328} <Debug> oximeter.version (64ef1028-bbea-4aca-a242-a56a21010998): There are no data parts | ||
235 | 2024.10.09 22:51:55.309582 [ 3 ] {f196560e-575c-4faf-8de2-f5c1fe984328} <Debug> DynamicQueryHandler: Done processing query | ||
236 | 2024.10.09 22:51:55.309624 [ 3 ] {} <Debug> HTTP-Session: 613720f3-371c-4fd5-b3d0-fcf1b7b6e4b6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
237 | 2024.10.09 22:51:55.312635 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
238 | 2024.10.09 22:51:55.312724 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
239 | 2024.10.09 22:51:55.312764 [ 3 ] {} <Debug> HTTP-Session: d76aedf3-e2e6-40c2-af40-2f8a5d566829 Authenticating user 'default' from [::1]:65139 | ||
240 | 2024.10.09 22:51:55.312792 [ 3 ] {} <Debug> HTTP-Session: d76aedf3-e2e6-40c2-af40-2f8a5d566829 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
241 | 2024.10.09 22:51:55.312809 [ 3 ] {} <Debug> HTTP-Session: d76aedf3-e2e6-40c2-af40-2f8a5d566829 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
242 | 2024.10.09 22:51:55.312872 [ 3 ] {} <Trace> HTTP-Session: d76aedf3-e2e6-40c2-af40-2f8a5d566829 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
243 | 2024.10.09 22:51:55.313237 [ 3 ] {cf677aac-21c3-4916-a637-e72e2182a1d4} <Debug> executeQuery: (from [::1]:65139) /* The measurement tables contain all individual samples from each timeseries. | ||
244 | * | ||
245 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
246 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
247 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
248 | * by all samples from the same timeseries. | ||
249 | * | ||
250 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
251 | * and then uses that to index quickly into the measurements tables. | ||
252 | */ | ||
253 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
254 | 2024.10.09 22:51:55.313321 [ 3 ] {cf677aac-21c3-4916-a637-e72e2182a1d4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
255 | 2024.10.09 22:51:55.316003 [ 3 ] {cf677aac-21c3-4916-a637-e72e2182a1d4} <Debug> oximeter.measurements_bool (52939e0c-39c6-404e-9b47-456ae3e3ce3a): Loading data parts | ||
256 | 2024.10.09 22:51:55.316394 [ 3 ] {cf677aac-21c3-4916-a637-e72e2182a1d4} <Debug> oximeter.measurements_bool (52939e0c-39c6-404e-9b47-456ae3e3ce3a): There are no data parts | ||
257 | 2024.10.09 22:51:55.321021 [ 3 ] {cf677aac-21c3-4916-a637-e72e2182a1d4} <Debug> DynamicQueryHandler: Done processing query | ||
258 | 2024.10.09 22:51:55.321060 [ 3 ] {} <Debug> HTTP-Session: d76aedf3-e2e6-40c2-af40-2f8a5d566829 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
259 | 2024.10.09 22:51:55.321879 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
260 | 2024.10.09 22:51:55.321970 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
261 | 2024.10.09 22:51:55.322014 [ 3 ] {} <Debug> HTTP-Session: f1b26de5-66c5-458d-9bb0-e8da4a0d6799 Authenticating user 'default' from [::1]:65139 | ||
262 | 2024.10.09 22:51:55.322041 [ 3 ] {} <Debug> HTTP-Session: f1b26de5-66c5-458d-9bb0-e8da4a0d6799 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
263 | 2024.10.09 22:51:55.322065 [ 3 ] {} <Debug> HTTP-Session: f1b26de5-66c5-458d-9bb0-e8da4a0d6799 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
264 | 2024.10.09 22:51:55.322114 [ 3 ] {} <Trace> HTTP-Session: f1b26de5-66c5-458d-9bb0-e8da4a0d6799 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
265 | 2024.10.09 22:51:55.322419 [ 3 ] {c74dec49-99ad-43ed-84bf-bdb2ff356e6d} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
266 | 2024.10.09 22:51:55.322492 [ 3 ] {c74dec49-99ad-43ed-84bf-bdb2ff356e6d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
267 | 2024.10.09 22:51:55.324404 [ 3 ] {c74dec49-99ad-43ed-84bf-bdb2ff356e6d} <Debug> oximeter.measurements_i8 (8fe206c6-211a-4c29-ad82-c6137918d148): Loading data parts | ||
268 | 2024.10.09 22:51:55.324884 [ 3 ] {c74dec49-99ad-43ed-84bf-bdb2ff356e6d} <Debug> oximeter.measurements_i8 (8fe206c6-211a-4c29-ad82-c6137918d148): There are no data parts | ||
269 | 2024.10.09 22:51:55.326487 [ 3 ] {c74dec49-99ad-43ed-84bf-bdb2ff356e6d} <Debug> DynamicQueryHandler: Done processing query | ||
270 | 2024.10.09 22:51:55.326521 [ 3 ] {} <Debug> HTTP-Session: f1b26de5-66c5-458d-9bb0-e8da4a0d6799 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
271 | 2024.10.09 22:51:55.327263 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
272 | 2024.10.09 22:51:55.327337 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
273 | 2024.10.09 22:51:55.327366 [ 3 ] {} <Debug> HTTP-Session: b16354f5-1517-4937-bf80-f3ff4c598a8c Authenticating user 'default' from [::1]:65139 | ||
274 | 2024.10.09 22:51:55.327395 [ 3 ] {} <Debug> HTTP-Session: b16354f5-1517-4937-bf80-f3ff4c598a8c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
275 | 2024.10.09 22:51:55.327408 [ 3 ] {} <Debug> HTTP-Session: b16354f5-1517-4937-bf80-f3ff4c598a8c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
276 | 2024.10.09 22:51:55.327457 [ 3 ] {} <Trace> HTTP-Session: b16354f5-1517-4937-bf80-f3ff4c598a8c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
277 | 2024.10.09 22:51:55.327806 [ 3 ] {b54b528a-c351-40ee-acc3-35cd962377c2} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
278 | 2024.10.09 22:51:55.327884 [ 3 ] {b54b528a-c351-40ee-acc3-35cd962377c2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
279 | 2024.10.09 22:51:55.330289 [ 3 ] {b54b528a-c351-40ee-acc3-35cd962377c2} <Debug> oximeter.measurements_u8 (9e503712-bb02-4ac6-977c-01126d65a97e): Loading data parts | ||
280 | 2024.10.09 22:51:55.330736 [ 3 ] {b54b528a-c351-40ee-acc3-35cd962377c2} <Debug> oximeter.measurements_u8 (9e503712-bb02-4ac6-977c-01126d65a97e): There are no data parts | ||
281 | 2024.10.09 22:51:55.332528 [ 3 ] {b54b528a-c351-40ee-acc3-35cd962377c2} <Debug> DynamicQueryHandler: Done processing query | ||
282 | 2024.10.09 22:51:55.332569 [ 3 ] {} <Debug> HTTP-Session: b16354f5-1517-4937-bf80-f3ff4c598a8c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
283 | 2024.10.09 22:51:55.333410 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
284 | 2024.10.09 22:51:55.333514 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
285 | 2024.10.09 22:51:55.333567 [ 3 ] {} <Debug> HTTP-Session: cf47e9bd-9180-4baa-9aca-0ac5aed86135 Authenticating user 'default' from [::1]:65139 | ||
286 | 2024.10.09 22:51:55.333591 [ 3 ] {} <Debug> HTTP-Session: cf47e9bd-9180-4baa-9aca-0ac5aed86135 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
287 | 2024.10.09 22:51:55.333626 [ 3 ] {} <Debug> HTTP-Session: cf47e9bd-9180-4baa-9aca-0ac5aed86135 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
288 | 2024.10.09 22:51:55.333756 [ 3 ] {} <Trace> HTTP-Session: cf47e9bd-9180-4baa-9aca-0ac5aed86135 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
289 | 2024.10.09 22:51:55.334210 [ 3 ] {47ce8ee3-e169-40d0-9557-48833c213374} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
290 | 2024.10.09 22:51:55.334304 [ 3 ] {47ce8ee3-e169-40d0-9557-48833c213374} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
291 | 2024.10.09 22:51:55.337116 [ 3 ] {47ce8ee3-e169-40d0-9557-48833c213374} <Debug> oximeter.measurements_i16 (c073266f-1805-47cd-9276-fc1a2343978b): Loading data parts | ||
292 | 2024.10.09 22:51:55.337694 [ 3 ] {47ce8ee3-e169-40d0-9557-48833c213374} <Debug> oximeter.measurements_i16 (c073266f-1805-47cd-9276-fc1a2343978b): There are no data parts | ||
293 | 2024.10.09 22:51:55.339413 [ 3 ] {47ce8ee3-e169-40d0-9557-48833c213374} <Debug> DynamicQueryHandler: Done processing query | ||
294 | 2024.10.09 22:51:55.339445 [ 3 ] {} <Debug> HTTP-Session: cf47e9bd-9180-4baa-9aca-0ac5aed86135 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
295 | 2024.10.09 22:51:55.340282 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
296 | 2024.10.09 22:51:55.340352 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
297 | 2024.10.09 22:51:55.340377 [ 3 ] {} <Debug> HTTP-Session: 00cc33a9-1e82-432c-8727-bb080f2f3b89 Authenticating user 'default' from [::1]:65139 | ||
298 | 2024.10.09 22:51:55.340409 [ 3 ] {} <Debug> HTTP-Session: 00cc33a9-1e82-432c-8727-bb080f2f3b89 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
299 | 2024.10.09 22:51:55.340424 [ 3 ] {} <Debug> HTTP-Session: 00cc33a9-1e82-432c-8727-bb080f2f3b89 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
300 | 2024.10.09 22:51:55.340469 [ 3 ] {} <Trace> HTTP-Session: 00cc33a9-1e82-432c-8727-bb080f2f3b89 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
301 | 2024.10.09 22:51:55.341029 [ 3 ] {6e7a1bdf-9cbc-4236-82c8-bb872856dbd3} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
302 | 2024.10.09 22:51:55.341099 [ 3 ] {6e7a1bdf-9cbc-4236-82c8-bb872856dbd3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
303 | 2024.10.09 22:51:55.344555 [ 3 ] {6e7a1bdf-9cbc-4236-82c8-bb872856dbd3} <Debug> oximeter.measurements_u16 (c659eed7-dbac-406e-8e4a-eed989c55a3b): Loading data parts | ||
304 | 2024.10.09 22:51:55.344900 [ 3 ] {6e7a1bdf-9cbc-4236-82c8-bb872856dbd3} <Debug> oximeter.measurements_u16 (c659eed7-dbac-406e-8e4a-eed989c55a3b): There are no data parts | ||
305 | 2024.10.09 22:51:55.346658 [ 3 ] {6e7a1bdf-9cbc-4236-82c8-bb872856dbd3} <Debug> DynamicQueryHandler: Done processing query | ||
306 | 2024.10.09 22:51:55.346699 [ 3 ] {} <Debug> HTTP-Session: 00cc33a9-1e82-432c-8727-bb080f2f3b89 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
307 | 2024.10.09 22:51:55.347637 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
308 | 2024.10.09 22:51:55.347711 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
309 | 2024.10.09 22:51:55.347747 [ 3 ] {} <Debug> HTTP-Session: 7f57a81b-a732-4eb8-b594-e65a09779947 Authenticating user 'default' from [::1]:65139 | ||
310 | 2024.10.09 22:51:55.347771 [ 3 ] {} <Debug> HTTP-Session: 7f57a81b-a732-4eb8-b594-e65a09779947 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
311 | 2024.10.09 22:51:55.347787 [ 3 ] {} <Debug> HTTP-Session: 7f57a81b-a732-4eb8-b594-e65a09779947 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
312 | 2024.10.09 22:51:55.347844 [ 3 ] {} <Trace> HTTP-Session: 7f57a81b-a732-4eb8-b594-e65a09779947 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
313 | 2024.10.09 22:51:55.348276 [ 3 ] {ff26cbcf-2289-4637-a2cc-42f3c48f027a} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
314 | 2024.10.09 22:51:55.348436 [ 3 ] {ff26cbcf-2289-4637-a2cc-42f3c48f027a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
315 | 2024.10.09 22:51:55.351457 [ 3 ] {ff26cbcf-2289-4637-a2cc-42f3c48f027a} <Debug> oximeter.measurements_i32 (5bb7116d-549d-43bc-b00f-03e34835fbc1): Loading data parts | ||
316 | 2024.10.09 22:51:55.351771 [ 3 ] {ff26cbcf-2289-4637-a2cc-42f3c48f027a} <Debug> oximeter.measurements_i32 (5bb7116d-549d-43bc-b00f-03e34835fbc1): There are no data parts | ||
317 | 2024.10.09 22:51:55.353588 [ 3 ] {ff26cbcf-2289-4637-a2cc-42f3c48f027a} <Debug> DynamicQueryHandler: Done processing query | ||
318 | 2024.10.09 22:51:55.353622 [ 3 ] {} <Debug> HTTP-Session: 7f57a81b-a732-4eb8-b594-e65a09779947 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
319 | 2024.10.09 22:51:55.354627 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
320 | 2024.10.09 22:51:55.354716 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
321 | 2024.10.09 22:51:55.354769 [ 3 ] {} <Debug> HTTP-Session: e6a38868-f435-4d82-a89d-88358821440e Authenticating user 'default' from [::1]:65139 | ||
322 | 2024.10.09 22:51:55.354795 [ 3 ] {} <Debug> HTTP-Session: e6a38868-f435-4d82-a89d-88358821440e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
323 | 2024.10.09 22:51:55.354822 [ 3 ] {} <Debug> HTTP-Session: e6a38868-f435-4d82-a89d-88358821440e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
324 | 2024.10.09 22:51:55.354871 [ 3 ] {} <Trace> HTTP-Session: e6a38868-f435-4d82-a89d-88358821440e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
325 | 2024.10.09 22:51:55.355862 [ 3 ] {f7d2c370-d0b8-474c-8333-1f246c41151c} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
326 | 2024.10.09 22:51:55.355937 [ 3 ] {f7d2c370-d0b8-474c-8333-1f246c41151c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
327 | 2024.10.09 22:51:55.359250 [ 3 ] {f7d2c370-d0b8-474c-8333-1f246c41151c} <Debug> oximeter.measurements_u32 (316899da-810e-4979-84e9-8a8c4acfeaba): Loading data parts | ||
328 | 2024.10.09 22:51:55.359697 [ 3 ] {f7d2c370-d0b8-474c-8333-1f246c41151c} <Debug> oximeter.measurements_u32 (316899da-810e-4979-84e9-8a8c4acfeaba): There are no data parts | ||
329 | 2024.10.09 22:51:55.362594 [ 3 ] {f7d2c370-d0b8-474c-8333-1f246c41151c} <Debug> DynamicQueryHandler: Done processing query | ||
330 | 2024.10.09 22:51:55.364303 [ 3 ] {} <Debug> HTTP-Session: e6a38868-f435-4d82-a89d-88358821440e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
331 | 2024.10.09 22:51:55.364799 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
332 | 2024.10.09 22:51:55.364878 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
333 | 2024.10.09 22:51:55.364924 [ 3 ] {} <Debug> HTTP-Session: 31d04e0f-654f-4aa7-8c44-4b23faaebcc8 Authenticating user 'default' from [::1]:65139 | ||
334 | 2024.10.09 22:51:55.364950 [ 3 ] {} <Debug> HTTP-Session: 31d04e0f-654f-4aa7-8c44-4b23faaebcc8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
335 | 2024.10.09 22:51:55.364966 [ 3 ] {} <Debug> HTTP-Session: 31d04e0f-654f-4aa7-8c44-4b23faaebcc8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
336 | 2024.10.09 22:51:55.365023 [ 3 ] {} <Trace> HTTP-Session: 31d04e0f-654f-4aa7-8c44-4b23faaebcc8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
337 | 2024.10.09 22:51:55.365441 [ 3 ] {e1d65616-c98a-4750-930a-6f640a34a604} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
338 | 2024.10.09 22:51:55.365533 [ 3 ] {e1d65616-c98a-4750-930a-6f640a34a604} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
339 | 2024.10.09 22:51:55.368031 [ 3 ] {e1d65616-c98a-4750-930a-6f640a34a604} <Debug> oximeter.measurements_i64 (86779fc7-2194-4342-9bc3-11c7e53bc05e): Loading data parts | ||
340 | 2024.10.09 22:51:55.368324 [ 3 ] {e1d65616-c98a-4750-930a-6f640a34a604} <Debug> oximeter.measurements_i64 (86779fc7-2194-4342-9bc3-11c7e53bc05e): There are no data parts | ||
341 | 2024.10.09 22:51:55.370270 [ 3 ] {e1d65616-c98a-4750-930a-6f640a34a604} <Debug> DynamicQueryHandler: Done processing query | ||
342 | 2024.10.09 22:51:55.370303 [ 3 ] {} <Debug> HTTP-Session: 31d04e0f-654f-4aa7-8c44-4b23faaebcc8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
343 | 2024.10.09 22:51:55.371408 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
344 | 2024.10.09 22:51:55.371497 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
345 | 2024.10.09 22:51:55.371548 [ 3 ] {} <Debug> HTTP-Session: 25a2e690-e4cd-41ef-8542-00373fd46330 Authenticating user 'default' from [::1]:65139 | ||
346 | 2024.10.09 22:51:55.371577 [ 3 ] {} <Debug> HTTP-Session: 25a2e690-e4cd-41ef-8542-00373fd46330 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
347 | 2024.10.09 22:51:55.371601 [ 3 ] {} <Debug> HTTP-Session: 25a2e690-e4cd-41ef-8542-00373fd46330 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
348 | 2024.10.09 22:51:55.371649 [ 3 ] {} <Trace> HTTP-Session: 25a2e690-e4cd-41ef-8542-00373fd46330 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
349 | 2024.10.09 22:51:55.371958 [ 3 ] {ba0e85c7-0898-4466-a7a8-2beee7e4ce61} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
350 | 2024.10.09 22:51:55.372038 [ 3 ] {ba0e85c7-0898-4466-a7a8-2beee7e4ce61} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
351 | 2024.10.09 22:51:55.376353 [ 3 ] {ba0e85c7-0898-4466-a7a8-2beee7e4ce61} <Debug> oximeter.measurements_u64 (62681866-15ff-4af0-9195-96f47c4f4a3b): Loading data parts | ||
352 | 2024.10.09 22:51:55.376839 [ 3 ] {ba0e85c7-0898-4466-a7a8-2beee7e4ce61} <Debug> oximeter.measurements_u64 (62681866-15ff-4af0-9195-96f47c4f4a3b): There are no data parts | ||
353 | 2024.10.09 22:51:55.378688 [ 3 ] {ba0e85c7-0898-4466-a7a8-2beee7e4ce61} <Debug> DynamicQueryHandler: Done processing query | ||
354 | 2024.10.09 22:51:55.378721 [ 3 ] {} <Debug> HTTP-Session: 25a2e690-e4cd-41ef-8542-00373fd46330 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
355 | 2024.10.09 22:51:55.379718 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
356 | 2024.10.09 22:51:55.379797 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
357 | 2024.10.09 22:51:55.379875 [ 3 ] {} <Debug> HTTP-Session: 04a874f3-c06f-48a3-9377-1e3ffe781511 Authenticating user 'default' from [::1]:65139 | ||
358 | 2024.10.09 22:51:55.379917 [ 3 ] {} <Debug> HTTP-Session: 04a874f3-c06f-48a3-9377-1e3ffe781511 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
359 | 2024.10.09 22:51:55.379936 [ 3 ] {} <Debug> HTTP-Session: 04a874f3-c06f-48a3-9377-1e3ffe781511 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
360 | 2024.10.09 22:51:55.380077 [ 3 ] {} <Trace> HTTP-Session: 04a874f3-c06f-48a3-9377-1e3ffe781511 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
361 | 2024.10.09 22:51:55.380483 [ 3 ] {3cf46386-947e-4d78-9152-70cdd4448369} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
362 | 2024.10.09 22:51:55.380569 [ 3 ] {3cf46386-947e-4d78-9152-70cdd4448369} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
363 | 2024.10.09 22:51:55.382951 [ 3 ] {3cf46386-947e-4d78-9152-70cdd4448369} <Debug> oximeter.measurements_f32 (8038aee5-dd04-4813-89c9-b047d8698b67): Loading data parts | ||
364 | 2024.10.09 22:51:55.383247 [ 3 ] {3cf46386-947e-4d78-9152-70cdd4448369} <Debug> oximeter.measurements_f32 (8038aee5-dd04-4813-89c9-b047d8698b67): There are no data parts | ||
365 | 2024.10.09 22:51:55.384930 [ 3 ] {3cf46386-947e-4d78-9152-70cdd4448369} <Debug> DynamicQueryHandler: Done processing query | ||
366 | 2024.10.09 22:51:55.384967 [ 3 ] {} <Debug> HTTP-Session: 04a874f3-c06f-48a3-9377-1e3ffe781511 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
367 | 2024.10.09 22:51:55.385729 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
368 | 2024.10.09 22:51:55.385810 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
369 | 2024.10.09 22:51:55.385832 [ 3 ] {} <Debug> HTTP-Session: 2e5f5db0-8ca3-4339-9178-f65494344195 Authenticating user 'default' from [::1]:65139 | ||
370 | 2024.10.09 22:51:55.385852 [ 3 ] {} <Debug> HTTP-Session: 2e5f5db0-8ca3-4339-9178-f65494344195 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
371 | 2024.10.09 22:51:55.385867 [ 3 ] {} <Debug> HTTP-Session: 2e5f5db0-8ca3-4339-9178-f65494344195 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
372 | 2024.10.09 22:51:55.386655 [ 3 ] {} <Trace> HTTP-Session: 2e5f5db0-8ca3-4339-9178-f65494344195 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
373 | 2024.10.09 22:51:55.386985 [ 3 ] {8789ddc7-9ad1-4b7a-a9c8-455931213734} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_f64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
374 | 2024.10.09 22:51:55.387077 [ 3 ] {8789ddc7-9ad1-4b7a-a9c8-455931213734} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
375 | 2024.10.09 22:51:55.390003 [ 3 ] {8789ddc7-9ad1-4b7a-a9c8-455931213734} <Debug> oximeter.measurements_f64 (5c56ae13-676e-4bc9-9920-3fb8b51ca6da): Loading data parts | ||
376 | 2024.10.09 22:51:55.390388 [ 3 ] {8789ddc7-9ad1-4b7a-a9c8-455931213734} <Debug> oximeter.measurements_f64 (5c56ae13-676e-4bc9-9920-3fb8b51ca6da): There are no data parts | ||
377 | 2024.10.09 22:51:55.392250 [ 3 ] {8789ddc7-9ad1-4b7a-a9c8-455931213734} <Debug> DynamicQueryHandler: Done processing query | ||
378 | 2024.10.09 22:51:55.392283 [ 3 ] {} <Debug> HTTP-Session: 2e5f5db0-8ca3-4339-9178-f65494344195 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
379 | 2024.10.09 22:51:55.393000 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
380 | 2024.10.09 22:51:55.393071 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
381 | 2024.10.09 22:51:55.393100 [ 3 ] {} <Debug> HTTP-Session: 64802073-d660-4293-b878-a10327fcb144 Authenticating user 'default' from [::1]:65139 | ||
382 | 2024.10.09 22:51:55.393139 [ 3 ] {} <Debug> HTTP-Session: 64802073-d660-4293-b878-a10327fcb144 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
383 | 2024.10.09 22:51:55.393159 [ 3 ] {} <Debug> HTTP-Session: 64802073-d660-4293-b878-a10327fcb144 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
384 | 2024.10.09 22:51:55.393259 [ 3 ] {} <Trace> HTTP-Session: 64802073-d660-4293-b878-a10327fcb144 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
385 | 2024.10.09 22:51:55.393587 [ 3 ] {8a4d0712-8ed9-422c-8fcc-49247f1f6f2c} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_string ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(String) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
386 | 2024.10.09 22:51:55.393656 [ 3 ] {8a4d0712-8ed9-422c-8fcc-49247f1f6f2c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
387 | 2024.10.09 22:51:55.396109 [ 3 ] {8a4d0712-8ed9-422c-8fcc-49247f1f6f2c} <Debug> oximeter.measurements_string (9a82dc9c-6813-43ba-8ea9-dfb922c4b72b): Loading data parts | ||
388 | 2024.10.09 22:51:55.396388 [ 3 ] {8a4d0712-8ed9-422c-8fcc-49247f1f6f2c} <Debug> oximeter.measurements_string (9a82dc9c-6813-43ba-8ea9-dfb922c4b72b): There are no data parts | ||
389 | 2024.10.09 22:51:55.398383 [ 3 ] {8a4d0712-8ed9-422c-8fcc-49247f1f6f2c} <Debug> DynamicQueryHandler: Done processing query | ||
390 | 2024.10.09 22:51:55.398444 [ 3 ] {} <Debug> HTTP-Session: 64802073-d660-4293-b878-a10327fcb144 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
391 | 2024.10.09 22:51:55.399350 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
392 | 2024.10.09 22:51:55.399434 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
393 | 2024.10.09 22:51:55.399472 [ 3 ] {} <Debug> HTTP-Session: 14af4336-44fe-4513-9b28-978dd45d9705 Authenticating user 'default' from [::1]:65139 | ||
394 | 2024.10.09 22:51:55.399972 [ 3 ] {} <Debug> HTTP-Session: 14af4336-44fe-4513-9b28-978dd45d9705 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
395 | 2024.10.09 22:51:55.400055 [ 3 ] {} <Debug> HTTP-Session: 14af4336-44fe-4513-9b28-978dd45d9705 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
396 | 2024.10.09 22:51:55.400153 [ 3 ] {} <Trace> HTTP-Session: 14af4336-44fe-4513-9b28-978dd45d9705 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
397 | 2024.10.09 22:51:55.400562 [ 3 ] {2a9b993d-bc09-4fa6-9064-2524a00b272b} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
398 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
399 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
400 | * a string isn't palatable for a few reasons. | ||
401 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
402 | * details. | ||
403 | */ | ||
404 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
405 | 2024.10.09 22:51:55.400670 [ 3 ] {2a9b993d-bc09-4fa6-9064-2524a00b272b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
406 | 2024.10.09 22:51:55.403608 [ 3 ] {2a9b993d-bc09-4fa6-9064-2524a00b272b} <Debug> oximeter.measurements_bytes (d4a81d88-ef3c-47c7-a7db-fee01b64bfe8): Loading data parts | ||
407 | 2024.10.09 22:51:55.404130 [ 3 ] {2a9b993d-bc09-4fa6-9064-2524a00b272b} <Debug> oximeter.measurements_bytes (d4a81d88-ef3c-47c7-a7db-fee01b64bfe8): There are no data parts | ||
408 | 2024.10.09 22:51:55.406113 [ 3 ] {2a9b993d-bc09-4fa6-9064-2524a00b272b} <Debug> DynamicQueryHandler: Done processing query | ||
409 | 2024.10.09 22:51:55.406140 [ 3 ] {} <Debug> HTTP-Session: 14af4336-44fe-4513-9b28-978dd45d9705 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
410 | 2024.10.09 22:51:55.406895 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
411 | 2024.10.09 22:51:55.406975 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
412 | 2024.10.09 22:51:55.406994 [ 3 ] {} <Debug> HTTP-Session: 95966d83-fe26-4d49-afb9-846aad72b1db Authenticating user 'default' from [::1]:65139 | ||
413 | 2024.10.09 22:51:55.407012 [ 3 ] {} <Debug> HTTP-Session: 95966d83-fe26-4d49-afb9-846aad72b1db Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
414 | 2024.10.09 22:51:55.407022 [ 3 ] {} <Debug> HTTP-Session: 95966d83-fe26-4d49-afb9-846aad72b1db Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
415 | 2024.10.09 22:51:55.407067 [ 3 ] {} <Trace> HTTP-Session: 95966d83-fe26-4d49-afb9-846aad72b1db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
416 | 2024.10.09 22:51:55.407357 [ 3 ] {cf7ba14b-d58b-4f2a-b4d7-07749126a457} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativei64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
417 | 2024.10.09 22:51:55.407471 [ 3 ] {cf7ba14b-d58b-4f2a-b4d7-07749126a457} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
418 | 2024.10.09 22:51:55.410452 [ 3 ] {cf7ba14b-d58b-4f2a-b4d7-07749126a457} <Debug> oximeter.measurements_cumulativei64 (bca98fb7-f369-41a7-aade-8be32025a4a9): Loading data parts | ||
419 | 2024.10.09 22:51:55.410762 [ 3 ] {cf7ba14b-d58b-4f2a-b4d7-07749126a457} <Debug> oximeter.measurements_cumulativei64 (bca98fb7-f369-41a7-aade-8be32025a4a9): There are no data parts | ||
420 | 2024.10.09 22:51:55.417228 [ 3 ] {cf7ba14b-d58b-4f2a-b4d7-07749126a457} <Debug> DynamicQueryHandler: Done processing query | ||
421 | 2024.10.09 22:51:55.417305 [ 3 ] {} <Debug> HTTP-Session: 95966d83-fe26-4d49-afb9-846aad72b1db Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
422 | 2024.10.09 22:51:55.418320 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
423 | 2024.10.09 22:51:55.418410 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
424 | 2024.10.09 22:51:55.418434 [ 3 ] {} <Debug> HTTP-Session: 86f4cf94-3032-455c-ac52-b195971e5f09 Authenticating user 'default' from [::1]:65139 | ||
425 | 2024.10.09 22:51:55.418468 [ 3 ] {} <Debug> HTTP-Session: 86f4cf94-3032-455c-ac52-b195971e5f09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
426 | 2024.10.09 22:51:55.418479 [ 3 ] {} <Debug> HTTP-Session: 86f4cf94-3032-455c-ac52-b195971e5f09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
427 | 2024.10.09 22:51:55.418519 [ 3 ] {} <Trace> HTTP-Session: 86f4cf94-3032-455c-ac52-b195971e5f09 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
428 | 2024.10.09 22:51:55.418785 [ 3 ] {e044d1df-f9fc-49bc-a61e-202ae88e3bb0} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
429 | 2024.10.09 22:51:55.418860 [ 3 ] {e044d1df-f9fc-49bc-a61e-202ae88e3bb0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
430 | 2024.10.09 22:51:55.421315 [ 3 ] {e044d1df-f9fc-49bc-a61e-202ae88e3bb0} <Debug> oximeter.measurements_cumulativeu64 (b2ef98b8-cd6e-4234-a649-de438486b504): Loading data parts | ||
431 | 2024.10.09 22:51:55.421646 [ 3 ] {e044d1df-f9fc-49bc-a61e-202ae88e3bb0} <Debug> oximeter.measurements_cumulativeu64 (b2ef98b8-cd6e-4234-a649-de438486b504): There are no data parts | ||
432 | 2024.10.09 22:51:55.423381 [ 3 ] {e044d1df-f9fc-49bc-a61e-202ae88e3bb0} <Debug> DynamicQueryHandler: Done processing query | ||
433 | 2024.10.09 22:51:55.423408 [ 3 ] {} <Debug> HTTP-Session: 86f4cf94-3032-455c-ac52-b195971e5f09 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
434 | 2024.10.09 22:51:55.424025 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
435 | 2024.10.09 22:51:55.424101 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
436 | 2024.10.09 22:51:55.424126 [ 3 ] {} <Debug> HTTP-Session: 7e8372b8-f732-4a89-885f-0d4049da933f Authenticating user 'default' from [::1]:65139 | ||
437 | 2024.10.09 22:51:55.424150 [ 3 ] {} <Debug> HTTP-Session: 7e8372b8-f732-4a89-885f-0d4049da933f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
438 | 2024.10.09 22:51:55.424174 [ 3 ] {} <Debug> HTTP-Session: 7e8372b8-f732-4a89-885f-0d4049da933f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
439 | 2024.10.09 22:51:55.424218 [ 3 ] {} <Trace> HTTP-Session: 7e8372b8-f732-4a89-885f-0d4049da933f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
440 | 2024.10.09 22:51:55.424527 [ 3 ] {7d39afad-d568-4371-919e-ef8a657cc966} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
441 | 2024.10.09 22:51:55.424601 [ 3 ] {7d39afad-d568-4371-919e-ef8a657cc966} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
442 | 2024.10.09 22:51:55.426904 [ 3 ] {7d39afad-d568-4371-919e-ef8a657cc966} <Debug> oximeter.measurements_cumulativef32 (0bc6b11c-13dc-473c-96be-715a9e80cc90): Loading data parts | ||
443 | 2024.10.09 22:51:55.427258 [ 3 ] {7d39afad-d568-4371-919e-ef8a657cc966} <Debug> oximeter.measurements_cumulativef32 (0bc6b11c-13dc-473c-96be-715a9e80cc90): There are no data parts | ||
444 | 2024.10.09 22:51:55.428960 [ 3 ] {7d39afad-d568-4371-919e-ef8a657cc966} <Debug> DynamicQueryHandler: Done processing query | ||
445 | 2024.10.09 22:51:55.429003 [ 3 ] {} <Debug> HTTP-Session: 7e8372b8-f732-4a89-885f-0d4049da933f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
446 | 2024.10.09 22:51:55.429549 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
447 | 2024.10.09 22:51:55.429604 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
448 | 2024.10.09 22:51:55.429631 [ 3 ] {} <Debug> HTTP-Session: 67c9a49d-5b8f-460f-9749-41a6fce619db Authenticating user 'default' from [::1]:65139 | ||
449 | 2024.10.09 22:51:55.429647 [ 3 ] {} <Debug> HTTP-Session: 67c9a49d-5b8f-460f-9749-41a6fce619db Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
450 | 2024.10.09 22:51:55.429656 [ 3 ] {} <Debug> HTTP-Session: 67c9a49d-5b8f-460f-9749-41a6fce619db Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
451 | 2024.10.09 22:51:55.429695 [ 3 ] {} <Trace> HTTP-Session: 67c9a49d-5b8f-460f-9749-41a6fce619db Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
452 | 2024.10.09 22:51:55.429903 [ 3 ] {90491d52-42b0-4d18-b2b8-28678cc48179} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
453 | 2024.10.09 22:51:55.429972 [ 3 ] {90491d52-42b0-4d18-b2b8-28678cc48179} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
454 | 2024.10.09 22:51:55.432056 [ 3 ] {90491d52-42b0-4d18-b2b8-28678cc48179} <Debug> oximeter.measurements_cumulativef64 (3d6e49d8-bbe0-4270-b603-7cd878a20262): Loading data parts | ||
455 | 2024.10.09 22:51:55.432330 [ 3 ] {90491d52-42b0-4d18-b2b8-28678cc48179} <Debug> oximeter.measurements_cumulativef64 (3d6e49d8-bbe0-4270-b603-7cd878a20262): There are no data parts | ||
456 | 2024.10.09 22:51:55.434244 [ 3 ] {90491d52-42b0-4d18-b2b8-28678cc48179} <Debug> DynamicQueryHandler: Done processing query | ||
457 | 2024.10.09 22:51:55.434267 [ 3 ] {} <Debug> HTTP-Session: 67c9a49d-5b8f-460f-9749-41a6fce619db Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
458 | 2024.10.09 22:51:55.434890 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
459 | 2024.10.09 22:51:55.434975 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
460 | 2024.10.09 22:51:55.434998 [ 3 ] {} <Debug> HTTP-Session: ed2e079b-941b-4f3d-880f-938fbb0fbca5 Authenticating user 'default' from [::1]:65139 | ||
461 | 2024.10.09 22:51:55.435019 [ 3 ] {} <Debug> HTTP-Session: ed2e079b-941b-4f3d-880f-938fbb0fbca5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
462 | 2024.10.09 22:51:55.435043 [ 3 ] {} <Debug> HTTP-Session: ed2e079b-941b-4f3d-880f-938fbb0fbca5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
463 | 2024.10.09 22:51:55.435084 [ 3 ] {} <Trace> HTTP-Session: ed2e079b-941b-4f3d-880f-938fbb0fbca5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
464 | 2024.10.09 22:51:55.435528 [ 3 ] {f1f3efd1-1ae5-45bb-a84b-9e1fb7c0570e} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
465 | * NOTE: Array types cannot be Nullable, see | ||
466 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
467 | * for more details. | ||
468 | * | ||
469 | * This means we need to use empty arrays to indicate a missing value. This | ||
470 | * is unfortunate, and at this point relies on the fact that an | ||
471 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
472 | * to figure out another way to represent missing samples here. | ||
473 | */ | ||
474 | bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
475 | 2024.10.09 22:51:55.435612 [ 3 ] {f1f3efd1-1ae5-45bb-a84b-9e1fb7c0570e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
476 | 2024.10.09 22:51:55.438408 [ 3 ] {f1f3efd1-1ae5-45bb-a84b-9e1fb7c0570e} <Debug> oximeter.measurements_histogrami8 (b6d32bdc-1244-42ee-93ec-0d679ca6e244): Loading data parts | ||
477 | 2024.10.09 22:51:55.438741 [ 3 ] {f1f3efd1-1ae5-45bb-a84b-9e1fb7c0570e} <Debug> oximeter.measurements_histogrami8 (b6d32bdc-1244-42ee-93ec-0d679ca6e244): There are no data parts | ||
478 | 2024.10.09 22:51:55.440422 [ 3 ] {f1f3efd1-1ae5-45bb-a84b-9e1fb7c0570e} <Debug> DynamicQueryHandler: Done processing query | ||
479 | 2024.10.09 22:51:55.440445 [ 3 ] {} <Debug> HTTP-Session: ed2e079b-941b-4f3d-880f-938fbb0fbca5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
480 | 2024.10.09 22:51:55.441116 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
481 | 2024.10.09 22:51:55.441170 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
482 | 2024.10.09 22:51:55.441187 [ 3 ] {} <Debug> HTTP-Session: 08389046-1d6c-4f81-9a8a-3869b96fe60f Authenticating user 'default' from [::1]:65139 | ||
483 | 2024.10.09 22:51:55.441215 [ 3 ] {} <Debug> HTTP-Session: 08389046-1d6c-4f81-9a8a-3869b96fe60f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
484 | 2024.10.09 22:51:55.441226 [ 3 ] {} <Debug> HTTP-Session: 08389046-1d6c-4f81-9a8a-3869b96fe60f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
485 | 2024.10.09 22:51:55.441255 [ 3 ] {} <Trace> HTTP-Session: 08389046-1d6c-4f81-9a8a-3869b96fe60f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
486 | 2024.10.09 22:51:55.441533 [ 3 ] {6e57f46c-0013-4b65-a384-38cc98198f82} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
487 | 2024.10.09 22:51:55.441692 [ 3 ] {6e57f46c-0013-4b65-a384-38cc98198f82} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
488 | 2024.10.09 22:51:55.444454 [ 3 ] {6e57f46c-0013-4b65-a384-38cc98198f82} <Debug> oximeter.measurements_histogramu8 (e0e18517-9d9d-4b48-a4b2-2addb35ed068): Loading data parts | ||
489 | 2024.10.09 22:51:55.444679 [ 3 ] {6e57f46c-0013-4b65-a384-38cc98198f82} <Debug> oximeter.measurements_histogramu8 (e0e18517-9d9d-4b48-a4b2-2addb35ed068): There are no data parts | ||
490 | 2024.10.09 22:51:55.446476 [ 3 ] {6e57f46c-0013-4b65-a384-38cc98198f82} <Debug> DynamicQueryHandler: Done processing query | ||
491 | 2024.10.09 22:51:55.446505 [ 3 ] {} <Debug> HTTP-Session: 08389046-1d6c-4f81-9a8a-3869b96fe60f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
492 | 2024.10.09 22:51:55.447249 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
493 | 2024.10.09 22:51:55.447327 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
494 | 2024.10.09 22:51:55.447350 [ 3 ] {} <Debug> HTTP-Session: 35542fce-f5eb-45cc-82d2-22f505bf445c Authenticating user 'default' from [::1]:65139 | ||
495 | 2024.10.09 22:51:55.447372 [ 3 ] {} <Debug> HTTP-Session: 35542fce-f5eb-45cc-82d2-22f505bf445c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
496 | 2024.10.09 22:51:55.447396 [ 3 ] {} <Debug> HTTP-Session: 35542fce-f5eb-45cc-82d2-22f505bf445c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
497 | 2024.10.09 22:51:55.447438 [ 3 ] {} <Trace> HTTP-Session: 35542fce-f5eb-45cc-82d2-22f505bf445c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
498 | 2024.10.09 22:51:55.448031 [ 3 ] {e73b678c-44c0-4147-a565-41dbfc26975d} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
499 | 2024.10.09 22:51:55.448126 [ 3 ] {e73b678c-44c0-4147-a565-41dbfc26975d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
500 | 2024.10.09 22:51:55.451001 [ 3 ] {e73b678c-44c0-4147-a565-41dbfc26975d} <Debug> oximeter.measurements_histogrami16 (73f4f282-cb16-4dd7-beb0-8e91acb5023c): Loading data parts | ||
501 | 2024.10.09 22:51:55.451346 [ 3 ] {e73b678c-44c0-4147-a565-41dbfc26975d} <Debug> oximeter.measurements_histogrami16 (73f4f282-cb16-4dd7-beb0-8e91acb5023c): There are no data parts | ||
502 | 2024.10.09 22:51:55.453226 [ 3 ] {e73b678c-44c0-4147-a565-41dbfc26975d} <Debug> DynamicQueryHandler: Done processing query | ||
503 | 2024.10.09 22:51:55.453251 [ 3 ] {} <Debug> HTTP-Session: 35542fce-f5eb-45cc-82d2-22f505bf445c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
504 | 2024.10.09 22:51:55.453803 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
505 | 2024.10.09 22:51:55.453864 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
506 | 2024.10.09 22:51:55.453883 [ 3 ] {} <Debug> HTTP-Session: ec686e23-1ae0-44d7-af28-246ed3efbbad Authenticating user 'default' from [::1]:65139 | ||
507 | 2024.10.09 22:51:55.453910 [ 3 ] {} <Debug> HTTP-Session: ec686e23-1ae0-44d7-af28-246ed3efbbad Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
508 | 2024.10.09 22:51:55.453920 [ 3 ] {} <Debug> HTTP-Session: ec686e23-1ae0-44d7-af28-246ed3efbbad Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
509 | 2024.10.09 22:51:55.453955 [ 3 ] {} <Trace> HTTP-Session: ec686e23-1ae0-44d7-af28-246ed3efbbad Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
510 | 2024.10.09 22:51:55.454342 [ 3 ] {6ca9f14e-6e9b-408d-b9ad-4fe47a99f10c} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
511 | 2024.10.09 22:51:55.454467 [ 3 ] {6ca9f14e-6e9b-408d-b9ad-4fe47a99f10c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
512 | 2024.10.09 22:51:55.457366 [ 3 ] {6ca9f14e-6e9b-408d-b9ad-4fe47a99f10c} <Debug> oximeter.measurements_histogramu16 (9a84ef7b-9554-4a43-9b51-753b734d5a2c): Loading data parts | ||
513 | 2024.10.09 22:51:55.457690 [ 3 ] {6ca9f14e-6e9b-408d-b9ad-4fe47a99f10c} <Debug> oximeter.measurements_histogramu16 (9a84ef7b-9554-4a43-9b51-753b734d5a2c): There are no data parts | ||
514 | 2024.10.09 22:51:55.459692 [ 3 ] {6ca9f14e-6e9b-408d-b9ad-4fe47a99f10c} <Debug> DynamicQueryHandler: Done processing query | ||
515 | 2024.10.09 22:51:55.459746 [ 3 ] {} <Debug> HTTP-Session: ec686e23-1ae0-44d7-af28-246ed3efbbad Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
516 | 2024.10.09 22:51:55.460516 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
517 | 2024.10.09 22:51:55.460580 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
518 | 2024.10.09 22:51:55.460622 [ 3 ] {} <Debug> HTTP-Session: 17ae3892-8a73-45d5-b0c5-cf7e47fe3351 Authenticating user 'default' from [::1]:65139 | ||
519 | 2024.10.09 22:51:55.460647 [ 3 ] {} <Debug> HTTP-Session: 17ae3892-8a73-45d5-b0c5-cf7e47fe3351 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
520 | 2024.10.09 22:51:55.460664 [ 3 ] {} <Debug> HTTP-Session: 17ae3892-8a73-45d5-b0c5-cf7e47fe3351 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
521 | 2024.10.09 22:51:55.460724 [ 3 ] {} <Trace> HTTP-Session: 17ae3892-8a73-45d5-b0c5-cf7e47fe3351 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
522 | 2024.10.09 22:51:55.461159 [ 3 ] {44ddf502-9e1f-4633-b984-a242ad43e328} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
523 | 2024.10.09 22:51:55.461265 [ 3 ] {44ddf502-9e1f-4633-b984-a242ad43e328} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
524 | 2024.10.09 22:51:55.464002 [ 3 ] {44ddf502-9e1f-4633-b984-a242ad43e328} <Debug> oximeter.measurements_histogrami32 (ee87b0ce-cb8e-459e-8e5d-49f0bafb0f23): Loading data parts | ||
525 | 2024.10.09 22:51:55.464438 [ 3 ] {44ddf502-9e1f-4633-b984-a242ad43e328} <Debug> oximeter.measurements_histogrami32 (ee87b0ce-cb8e-459e-8e5d-49f0bafb0f23): There are no data parts | ||
526 | 2024.10.09 22:51:55.466228 [ 3 ] {44ddf502-9e1f-4633-b984-a242ad43e328} <Debug> DynamicQueryHandler: Done processing query | ||
527 | 2024.10.09 22:51:55.466261 [ 3 ] {} <Debug> HTTP-Session: 17ae3892-8a73-45d5-b0c5-cf7e47fe3351 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
528 | 2024.10.09 22:51:55.467456 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
529 | 2024.10.09 22:51:55.467546 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
530 | 2024.10.09 22:51:55.467571 [ 3 ] {} <Debug> HTTP-Session: df9975ef-c4b4-443b-9261-ae8763f48355 Authenticating user 'default' from [::1]:65139 | ||
531 | 2024.10.09 22:51:55.467594 [ 3 ] {} <Debug> HTTP-Session: df9975ef-c4b4-443b-9261-ae8763f48355 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
532 | 2024.10.09 22:51:55.467617 [ 3 ] {} <Debug> HTTP-Session: df9975ef-c4b4-443b-9261-ae8763f48355 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
533 | 2024.10.09 22:51:55.467667 [ 3 ] {} <Trace> HTTP-Session: df9975ef-c4b4-443b-9261-ae8763f48355 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
534 | 2024.10.09 22:51:55.468150 [ 3 ] {14ac863d-97f8-4840-9bef-6ca6ed91599c} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
535 | 2024.10.09 22:51:55.468247 [ 3 ] {14ac863d-97f8-4840-9bef-6ca6ed91599c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
536 | 2024.10.09 22:51:55.471512 [ 3 ] {14ac863d-97f8-4840-9bef-6ca6ed91599c} <Debug> oximeter.measurements_histogramu32 (430bf2a2-190d-4e9c-9938-23c7c36b809a): Loading data parts | ||
537 | 2024.10.09 22:51:55.471876 [ 3 ] {14ac863d-97f8-4840-9bef-6ca6ed91599c} <Debug> oximeter.measurements_histogramu32 (430bf2a2-190d-4e9c-9938-23c7c36b809a): There are no data parts | ||
538 | 2024.10.09 22:51:55.474039 [ 3 ] {14ac863d-97f8-4840-9bef-6ca6ed91599c} <Debug> DynamicQueryHandler: Done processing query | ||
539 | 2024.10.09 22:51:55.474085 [ 3 ] {} <Debug> HTTP-Session: df9975ef-c4b4-443b-9261-ae8763f48355 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
540 | 2024.10.09 22:51:55.474842 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
541 | 2024.10.09 22:51:55.474921 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
542 | 2024.10.09 22:51:55.474964 [ 3 ] {} <Debug> HTTP-Session: a1156ab1-8d2c-4333-bd81-84d025c8c061 Authenticating user 'default' from [::1]:65139 | ||
543 | 2024.10.09 22:51:55.474989 [ 3 ] {} <Debug> HTTP-Session: a1156ab1-8d2c-4333-bd81-84d025c8c061 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
544 | 2024.10.09 22:51:55.475005 [ 3 ] {} <Debug> HTTP-Session: a1156ab1-8d2c-4333-bd81-84d025c8c061 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
545 | 2024.10.09 22:51:55.475063 [ 3 ] {} <Trace> HTTP-Session: a1156ab1-8d2c-4333-bd81-84d025c8c061 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
546 | 2024.10.09 22:51:55.475402 [ 3 ] {21b1307c-3cc6-4967-b5c9-36866d6451e6} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
547 | 2024.10.09 22:51:55.475480 [ 3 ] {21b1307c-3cc6-4967-b5c9-36866d6451e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
548 | 2024.10.09 22:51:55.478989 [ 3 ] {21b1307c-3cc6-4967-b5c9-36866d6451e6} <Debug> oximeter.measurements_histogrami64 (22a2efa9-457e-4a2b-8517-bf8a981d0ef4): Loading data parts | ||
549 | 2024.10.09 22:51:55.479393 [ 3 ] {21b1307c-3cc6-4967-b5c9-36866d6451e6} <Debug> oximeter.measurements_histogrami64 (22a2efa9-457e-4a2b-8517-bf8a981d0ef4): There are no data parts | ||
550 | 2024.10.09 22:51:55.481635 [ 3 ] {21b1307c-3cc6-4967-b5c9-36866d6451e6} <Debug> DynamicQueryHandler: Done processing query | ||
551 | 2024.10.09 22:51:55.481666 [ 3 ] {} <Debug> HTTP-Session: a1156ab1-8d2c-4333-bd81-84d025c8c061 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
552 | 2024.10.09 22:51:55.482244 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
553 | 2024.10.09 22:51:55.482339 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
554 | 2024.10.09 22:51:55.482365 [ 3 ] {} <Debug> HTTP-Session: 6e1b889a-70f5-4554-9b68-1d0100aab649 Authenticating user 'default' from [::1]:65139 | ||
555 | 2024.10.09 22:51:55.482391 [ 3 ] {} <Debug> HTTP-Session: 6e1b889a-70f5-4554-9b68-1d0100aab649 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
556 | 2024.10.09 22:51:55.482416 [ 3 ] {} <Debug> HTTP-Session: 6e1b889a-70f5-4554-9b68-1d0100aab649 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
557 | 2024.10.09 22:51:55.482463 [ 3 ] {} <Trace> HTTP-Session: 6e1b889a-70f5-4554-9b68-1d0100aab649 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
558 | 2024.10.09 22:51:55.483024 [ 3 ] {5cca0a08-d74d-4b5b-a7ec-4e97edbc86b8} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
559 | 2024.10.09 22:51:55.483128 [ 3 ] {5cca0a08-d74d-4b5b-a7ec-4e97edbc86b8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
560 | 2024.10.09 22:51:55.486375 [ 3 ] {5cca0a08-d74d-4b5b-a7ec-4e97edbc86b8} <Debug> oximeter.measurements_histogramu64 (17b337b4-7bfe-4d5a-9ace-c3cd1e8e6537): Loading data parts | ||
561 | 2024.10.09 22:51:55.486740 [ 3 ] {5cca0a08-d74d-4b5b-a7ec-4e97edbc86b8} <Debug> oximeter.measurements_histogramu64 (17b337b4-7bfe-4d5a-9ace-c3cd1e8e6537): There are no data parts | ||
562 | 2024.10.09 22:51:55.488783 [ 3 ] {5cca0a08-d74d-4b5b-a7ec-4e97edbc86b8} <Debug> DynamicQueryHandler: Done processing query | ||
563 | 2024.10.09 22:51:55.488812 [ 3 ] {} <Debug> HTTP-Session: 6e1b889a-70f5-4554-9b68-1d0100aab649 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
564 | 2024.10.09 22:51:55.489500 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
565 | 2024.10.09 22:51:55.489572 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
566 | 2024.10.09 22:51:55.489594 [ 3 ] {} <Debug> HTTP-Session: 4538f199-2a36-481a-b894-ad4aaf532cc3 Authenticating user 'default' from [::1]:65139 | ||
567 | 2024.10.09 22:51:55.489627 [ 3 ] {} <Debug> HTTP-Session: 4538f199-2a36-481a-b894-ad4aaf532cc3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
568 | 2024.10.09 22:51:55.489638 [ 3 ] {} <Debug> HTTP-Session: 4538f199-2a36-481a-b894-ad4aaf532cc3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
569 | 2024.10.09 22:51:55.489756 [ 3 ] {} <Trace> HTTP-Session: 4538f199-2a36-481a-b894-ad4aaf532cc3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
570 | 2024.10.09 22:51:55.490309 [ 3 ] {c7c29008-f9dd-4c97-b2bb-cc9ca6657416} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
571 | 2024.10.09 22:51:55.490412 [ 3 ] {c7c29008-f9dd-4c97-b2bb-cc9ca6657416} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
572 | 2024.10.09 22:51:55.493728 [ 3 ] {c7c29008-f9dd-4c97-b2bb-cc9ca6657416} <Debug> oximeter.measurements_histogramf32 (3fd46c8e-d9fc-462d-935f-82d2a7bccca7): Loading data parts | ||
573 | 2024.10.09 22:51:55.494037 [ 3 ] {c7c29008-f9dd-4c97-b2bb-cc9ca6657416} <Debug> oximeter.measurements_histogramf32 (3fd46c8e-d9fc-462d-935f-82d2a7bccca7): There are no data parts | ||
574 | 2024.10.09 22:51:55.495861 [ 3 ] {c7c29008-f9dd-4c97-b2bb-cc9ca6657416} <Debug> DynamicQueryHandler: Done processing query | ||
575 | 2024.10.09 22:51:55.495890 [ 3 ] {} <Debug> HTTP-Session: 4538f199-2a36-481a-b894-ad4aaf532cc3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
576 | 2024.10.09 22:51:55.496692 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
577 | 2024.10.09 22:51:55.496784 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
578 | 2024.10.09 22:51:55.496810 [ 3 ] {} <Debug> HTTP-Session: f48132e8-a50d-4b60-a7a1-d77b8c0eacc0 Authenticating user 'default' from [::1]:65139 | ||
579 | 2024.10.09 22:51:55.496835 [ 3 ] {} <Debug> HTTP-Session: f48132e8-a50d-4b60-a7a1-d77b8c0eacc0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
580 | 2024.10.09 22:51:55.496862 [ 3 ] {} <Debug> HTTP-Session: f48132e8-a50d-4b60-a7a1-d77b8c0eacc0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
581 | 2024.10.09 22:51:55.496910 [ 3 ] {} <Trace> HTTP-Session: f48132e8-a50d-4b60-a7a1-d77b8c0eacc0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
582 | 2024.10.09 22:51:55.497371 [ 3 ] {e4e42c02-a3f0-4b9b-817e-81e73d97966c} <Debug> executeQuery: (from [::1]:65139) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
583 | 2024.10.09 22:51:55.497471 [ 3 ] {e4e42c02-a3f0-4b9b-817e-81e73d97966c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
584 | 2024.10.09 22:51:55.500197 [ 3 ] {e4e42c02-a3f0-4b9b-817e-81e73d97966c} <Debug> oximeter.measurements_histogramf64 (bec3c92b-7121-454c-9955-fb0bf7a67c50): Loading data parts | ||
585 | 2024.10.09 22:51:55.500542 [ 3 ] {e4e42c02-a3f0-4b9b-817e-81e73d97966c} <Debug> oximeter.measurements_histogramf64 (bec3c92b-7121-454c-9955-fb0bf7a67c50): There are no data parts | ||
586 | 2024.10.09 22:51:55.503017 [ 3 ] {e4e42c02-a3f0-4b9b-817e-81e73d97966c} <Debug> DynamicQueryHandler: Done processing query | ||
587 | 2024.10.09 22:51:55.503050 [ 3 ] {} <Debug> HTTP-Session: f48132e8-a50d-4b60-a7a1-d77b8c0eacc0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
588 | 2024.10.09 22:51:55.503826 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
589 | 2024.10.09 22:51:55.503902 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
590 | 2024.10.09 22:51:55.503932 [ 3 ] {} <Debug> HTTP-Session: b4750ca1-e47b-4383-93f8-6ac6e951c8ba Authenticating user 'default' from [::1]:65139 | ||
591 | 2024.10.09 22:51:55.503975 [ 3 ] {} <Debug> HTTP-Session: b4750ca1-e47b-4383-93f8-6ac6e951c8ba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
592 | 2024.10.09 22:51:55.503995 [ 3 ] {} <Debug> HTTP-Session: b4750ca1-e47b-4383-93f8-6ac6e951c8ba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
593 | 2024.10.09 22:51:55.504045 [ 3 ] {} <Trace> HTTP-Session: b4750ca1-e47b-4383-93f8-6ac6e951c8ba Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
594 | 2024.10.09 22:51:55.504488 [ 3 ] {757031af-f97b-4225-9080-46d1aea07840} <Debug> executeQuery: (from [::1]:65139) /* The field tables store named dimensions of each timeseries. | ||
595 | * | ||
596 | * As with the measurement tables, there is one field table for each field data | ||
597 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
598 | * this behavior **must not** be relied upon for query correctness. | ||
599 | * | ||
600 | * The index for the fields differs from the measurements, however. Rows are | ||
601 | * sorted by timeseries name, then field name, field value, and finally | ||
602 | * timeseries key. This reflects the most common pattern for looking them up: | ||
603 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
604 | * usually then used to look up measurements. | ||
605 | * | ||
606 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
607 | * timeseries name and then key, since it would improve lookups where one | ||
608 | * already has the key. Realistically though, these tables are quite small and | ||
609 | * so performance benefits will be low in absolute terms. | ||
610 | * | ||
611 | * TTL: We use a materialized column to expire old field table records. This | ||
612 | * column is generated automatically by the database whenever a new row is | ||
613 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
614 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
615 | * record will remain during a deduplication, which will have the last | ||
616 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
617 | * measurement tables. | ||
618 | */ | ||
619 | 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) | ||
620 | 2024.10.09 22:51:55.504747 [ 3 ] {757031af-f97b-4225-9080-46d1aea07840} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
621 | 2024.10.09 22:51:55.507288 [ 3 ] {757031af-f97b-4225-9080-46d1aea07840} <Debug> oximeter.fields_bool (6dfa82e5-3284-4130-ade8-f2f31af1aefc): Loading data parts | ||
622 | 2024.10.09 22:51:55.507573 [ 3 ] {757031af-f97b-4225-9080-46d1aea07840} <Debug> oximeter.fields_bool (6dfa82e5-3284-4130-ade8-f2f31af1aefc): There are no data parts | ||
623 | 2024.10.09 22:51:55.509249 [ 3 ] {757031af-f97b-4225-9080-46d1aea07840} <Debug> DynamicQueryHandler: Done processing query | ||
624 | 2024.10.09 22:51:55.509297 [ 3 ] {} <Debug> HTTP-Session: b4750ca1-e47b-4383-93f8-6ac6e951c8ba Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
625 | 2024.10.09 22:51:55.509971 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
626 | 2024.10.09 22:51:55.510064 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
627 | 2024.10.09 22:51:55.510108 [ 3 ] {} <Debug> HTTP-Session: 02efa201-f724-491a-b1ef-d9d5d7a5ef58 Authenticating user 'default' from [::1]:65139 | ||
628 | 2024.10.09 22:51:55.510132 [ 3 ] {} <Debug> HTTP-Session: 02efa201-f724-491a-b1ef-d9d5d7a5ef58 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
629 | 2024.10.09 22:51:55.510148 [ 3 ] {} <Debug> HTTP-Session: 02efa201-f724-491a-b1ef-d9d5d7a5ef58 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
630 | 2024.10.09 22:51:55.510196 [ 3 ] {} <Trace> HTTP-Session: 02efa201-f724-491a-b1ef-d9d5d7a5ef58 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
631 | 2024.10.09 22:51:55.510478 [ 3 ] {b6a9933c-54a8-4a51-a8d5-bbe51bbf5778} <Debug> executeQuery: (from [::1]:65139) 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) | ||
632 | 2024.10.09 22:51:55.510548 [ 3 ] {b6a9933c-54a8-4a51-a8d5-bbe51bbf5778} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
633 | 2024.10.09 22:51:55.513443 [ 3 ] {b6a9933c-54a8-4a51-a8d5-bbe51bbf5778} <Debug> oximeter.fields_i8 (f85841db-2da2-46d3-bab6-16cd14cc546c): Loading data parts | ||
634 | 2024.10.09 22:51:55.513726 [ 3 ] {b6a9933c-54a8-4a51-a8d5-bbe51bbf5778} <Debug> oximeter.fields_i8 (f85841db-2da2-46d3-bab6-16cd14cc546c): There are no data parts | ||
635 | 2024.10.09 22:51:55.515650 [ 3 ] {b6a9933c-54a8-4a51-a8d5-bbe51bbf5778} <Debug> DynamicQueryHandler: Done processing query | ||
636 | 2024.10.09 22:51:55.515682 [ 3 ] {} <Debug> HTTP-Session: 02efa201-f724-491a-b1ef-d9d5d7a5ef58 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
637 | 2024.10.09 22:51:55.516356 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
638 | 2024.10.09 22:51:55.516494 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
639 | 2024.10.09 22:51:55.516531 [ 3 ] {} <Debug> HTTP-Session: 7e5f5e1e-a753-49de-8bbe-ef8aa094a49e Authenticating user 'default' from [::1]:65139 | ||
640 | 2024.10.09 22:51:55.516557 [ 3 ] {} <Debug> HTTP-Session: 7e5f5e1e-a753-49de-8bbe-ef8aa094a49e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
641 | 2024.10.09 22:51:55.516590 [ 3 ] {} <Debug> HTTP-Session: 7e5f5e1e-a753-49de-8bbe-ef8aa094a49e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
642 | 2024.10.09 22:51:55.516642 [ 3 ] {} <Trace> HTTP-Session: 7e5f5e1e-a753-49de-8bbe-ef8aa094a49e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
643 | 2024.10.09 22:51:55.516951 [ 3 ] {c812ff6b-44de-44f5-93b7-03ee7b0980b5} <Debug> executeQuery: (from [::1]:65139) 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) | ||
644 | 2024.10.09 22:51:55.517045 [ 3 ] {c812ff6b-44de-44f5-93b7-03ee7b0980b5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
645 | 2024.10.09 22:51:55.519407 [ 3 ] {c812ff6b-44de-44f5-93b7-03ee7b0980b5} <Debug> oximeter.fields_u8 (eef38307-78c2-40c7-91ee-93913a30524a): Loading data parts | ||
646 | 2024.10.09 22:51:55.519749 [ 3 ] {c812ff6b-44de-44f5-93b7-03ee7b0980b5} <Debug> oximeter.fields_u8 (eef38307-78c2-40c7-91ee-93913a30524a): There are no data parts | ||
647 | 2024.10.09 22:51:55.521457 [ 3 ] {c812ff6b-44de-44f5-93b7-03ee7b0980b5} <Debug> DynamicQueryHandler: Done processing query | ||
648 | 2024.10.09 22:51:55.521524 [ 3 ] {} <Debug> HTTP-Session: 7e5f5e1e-a753-49de-8bbe-ef8aa094a49e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
649 | 2024.10.09 22:51:55.522209 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
650 | 2024.10.09 22:51:55.522318 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
651 | 2024.10.09 22:51:55.522360 [ 3 ] {} <Debug> HTTP-Session: aaccedf5-9b40-4b97-8a08-96e7830e25eb Authenticating user 'default' from [::1]:65139 | ||
652 | 2024.10.09 22:51:55.522382 [ 3 ] {} <Debug> HTTP-Session: aaccedf5-9b40-4b97-8a08-96e7830e25eb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
653 | 2024.10.09 22:51:55.522393 [ 3 ] {} <Debug> HTTP-Session: aaccedf5-9b40-4b97-8a08-96e7830e25eb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
654 | 2024.10.09 22:51:55.522433 [ 3 ] {} <Trace> HTTP-Session: aaccedf5-9b40-4b97-8a08-96e7830e25eb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
655 | 2024.10.09 22:51:55.522796 [ 3 ] {3e83b0c4-757d-4d9f-9bbc-b60f31add394} <Debug> executeQuery: (from [::1]:65139) 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) | ||
656 | 2024.10.09 22:51:55.522862 [ 3 ] {3e83b0c4-757d-4d9f-9bbc-b60f31add394} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
657 | 2024.10.09 22:51:55.525492 [ 3 ] {3e83b0c4-757d-4d9f-9bbc-b60f31add394} <Debug> oximeter.fields_i16 (b6662e48-fd55-4b0c-8862-129dbedb48e3): Loading data parts | ||
658 | 2024.10.09 22:51:55.525775 [ 3 ] {3e83b0c4-757d-4d9f-9bbc-b60f31add394} <Debug> oximeter.fields_i16 (b6662e48-fd55-4b0c-8862-129dbedb48e3): There are no data parts | ||
659 | 2024.10.09 22:51:55.527568 [ 3 ] {3e83b0c4-757d-4d9f-9bbc-b60f31add394} <Debug> DynamicQueryHandler: Done processing query | ||
660 | 2024.10.09 22:51:55.527589 [ 3 ] {} <Debug> HTTP-Session: aaccedf5-9b40-4b97-8a08-96e7830e25eb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
661 | 2024.10.09 22:51:55.528100 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
662 | 2024.10.09 22:51:55.528175 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
663 | 2024.10.09 22:51:55.528198 [ 3 ] {} <Debug> HTTP-Session: 0e554ae6-90cb-4537-b350-c736965ce51d Authenticating user 'default' from [::1]:65139 | ||
664 | 2024.10.09 22:51:55.528216 [ 3 ] {} <Debug> HTTP-Session: 0e554ae6-90cb-4537-b350-c736965ce51d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
665 | 2024.10.09 22:51:55.528237 [ 3 ] {} <Debug> HTTP-Session: 0e554ae6-90cb-4537-b350-c736965ce51d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
666 | 2024.10.09 22:51:55.528270 [ 3 ] {} <Trace> HTTP-Session: 0e554ae6-90cb-4537-b350-c736965ce51d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
667 | 2024.10.09 22:51:55.528480 [ 3 ] {c9f5b950-f9c3-435c-972a-4cb86042e92b} <Debug> executeQuery: (from [::1]:65139) 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) | ||
668 | 2024.10.09 22:51:55.528537 [ 3 ] {c9f5b950-f9c3-435c-972a-4cb86042e92b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
669 | 2024.10.09 22:51:55.530758 [ 3 ] {c9f5b950-f9c3-435c-972a-4cb86042e92b} <Debug> oximeter.fields_u16 (e62cda02-d116-46a9-9641-79476f4ecc59): Loading data parts | ||
670 | 2024.10.09 22:51:55.531070 [ 3 ] {c9f5b950-f9c3-435c-972a-4cb86042e92b} <Debug> oximeter.fields_u16 (e62cda02-d116-46a9-9641-79476f4ecc59): There are no data parts | ||
671 | 2024.10.09 22:51:55.532941 [ 3 ] {c9f5b950-f9c3-435c-972a-4cb86042e92b} <Debug> DynamicQueryHandler: Done processing query | ||
672 | 2024.10.09 22:51:55.532975 [ 3 ] {} <Debug> HTTP-Session: 0e554ae6-90cb-4537-b350-c736965ce51d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
673 | 2024.10.09 22:51:55.533635 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
674 | 2024.10.09 22:51:55.533697 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
675 | 2024.10.09 22:51:55.533716 [ 3 ] {} <Debug> HTTP-Session: cbcf048b-d10e-4e20-a9d5-c8ddba54ad9c Authenticating user 'default' from [::1]:65139 | ||
676 | 2024.10.09 22:51:55.533744 [ 3 ] {} <Debug> HTTP-Session: cbcf048b-d10e-4e20-a9d5-c8ddba54ad9c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
677 | 2024.10.09 22:51:55.533760 [ 3 ] {} <Debug> HTTP-Session: cbcf048b-d10e-4e20-a9d5-c8ddba54ad9c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
678 | 2024.10.09 22:51:55.533797 [ 3 ] {} <Trace> HTTP-Session: cbcf048b-d10e-4e20-a9d5-c8ddba54ad9c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
679 | 2024.10.09 22:51:55.534037 [ 3 ] {7fa84941-b715-4c21-923d-f5023950dd4b} <Debug> executeQuery: (from [::1]:65139) 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) | ||
680 | 2024.10.09 22:51:55.534091 [ 3 ] {7fa84941-b715-4c21-923d-f5023950dd4b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
681 | 2024.10.09 22:51:55.536292 [ 3 ] {7fa84941-b715-4c21-923d-f5023950dd4b} <Debug> oximeter.fields_i32 (0d020c4f-dd2d-418e-9f26-82e61f5941be): Loading data parts | ||
682 | 2024.10.09 22:51:55.536603 [ 3 ] {7fa84941-b715-4c21-923d-f5023950dd4b} <Debug> oximeter.fields_i32 (0d020c4f-dd2d-418e-9f26-82e61f5941be): There are no data parts | ||
683 | 2024.10.09 22:51:55.538362 [ 3 ] {7fa84941-b715-4c21-923d-f5023950dd4b} <Debug> DynamicQueryHandler: Done processing query | ||
684 | 2024.10.09 22:51:55.538394 [ 3 ] {} <Debug> HTTP-Session: cbcf048b-d10e-4e20-a9d5-c8ddba54ad9c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
685 | 2024.10.09 22:51:55.538992 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
686 | 2024.10.09 22:51:55.539264 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
687 | 2024.10.09 22:51:55.539300 [ 3 ] {} <Debug> HTTP-Session: dedcdaf3-9eaa-49c3-ae7e-fcbf12f28fc1 Authenticating user 'default' from [::1]:65139 | ||
688 | 2024.10.09 22:51:55.539325 [ 3 ] {} <Debug> HTTP-Session: dedcdaf3-9eaa-49c3-ae7e-fcbf12f28fc1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
689 | 2024.10.09 22:51:55.539361 [ 3 ] {} <Debug> HTTP-Session: dedcdaf3-9eaa-49c3-ae7e-fcbf12f28fc1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
690 | 2024.10.09 22:51:55.539404 [ 3 ] {} <Trace> HTTP-Session: dedcdaf3-9eaa-49c3-ae7e-fcbf12f28fc1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
691 | 2024.10.09 22:51:55.539651 [ 3 ] {5c98648f-405d-499d-9150-264a88a35e46} <Debug> executeQuery: (from [::1]:65139) 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) | ||
692 | 2024.10.09 22:51:55.539724 [ 3 ] {5c98648f-405d-499d-9150-264a88a35e46} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
693 | 2024.10.09 22:51:55.542103 [ 3 ] {5c98648f-405d-499d-9150-264a88a35e46} <Debug> oximeter.fields_u32 (2254593e-cb1d-41ca-89b8-73dcce3768b9): Loading data parts | ||
694 | 2024.10.09 22:51:55.542387 [ 3 ] {5c98648f-405d-499d-9150-264a88a35e46} <Debug> oximeter.fields_u32 (2254593e-cb1d-41ca-89b8-73dcce3768b9): There are no data parts | ||
695 | 2024.10.09 22:51:55.544003 [ 3 ] {5c98648f-405d-499d-9150-264a88a35e46} <Debug> DynamicQueryHandler: Done processing query | ||
696 | 2024.10.09 22:51:55.544037 [ 3 ] {} <Debug> HTTP-Session: dedcdaf3-9eaa-49c3-ae7e-fcbf12f28fc1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
697 | 2024.10.09 22:51:55.544567 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
698 | 2024.10.09 22:51:55.544669 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
699 | 2024.10.09 22:51:55.544703 [ 3 ] {} <Debug> HTTP-Session: 5037e55a-38f5-4f4f-bbce-0bd5eb70188b Authenticating user 'default' from [::1]:65139 | ||
700 | 2024.10.09 22:51:55.544744 [ 3 ] {} <Debug> HTTP-Session: 5037e55a-38f5-4f4f-bbce-0bd5eb70188b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
701 | 2024.10.09 22:51:55.544762 [ 3 ] {} <Debug> HTTP-Session: 5037e55a-38f5-4f4f-bbce-0bd5eb70188b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
702 | 2024.10.09 22:51:55.544801 [ 3 ] {} <Trace> HTTP-Session: 5037e55a-38f5-4f4f-bbce-0bd5eb70188b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
703 | 2024.10.09 22:51:55.545094 [ 3 ] {dba0d944-baf7-4032-846e-77972da6411e} <Debug> executeQuery: (from [::1]:65139) 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) | ||
704 | 2024.10.09 22:51:55.545195 [ 3 ] {dba0d944-baf7-4032-846e-77972da6411e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
705 | 2024.10.09 22:51:55.547851 [ 3 ] {dba0d944-baf7-4032-846e-77972da6411e} <Debug> oximeter.fields_i64 (4ad059f7-66b3-424d-8167-b71635a5a46c): Loading data parts | ||
706 | 2024.10.09 22:51:55.548146 [ 3 ] {dba0d944-baf7-4032-846e-77972da6411e} <Debug> oximeter.fields_i64 (4ad059f7-66b3-424d-8167-b71635a5a46c): There are no data parts | ||
707 | 2024.10.09 22:51:55.549947 [ 3 ] {dba0d944-baf7-4032-846e-77972da6411e} <Debug> DynamicQueryHandler: Done processing query | ||
708 | 2024.10.09 22:51:55.549985 [ 3 ] {} <Debug> HTTP-Session: 5037e55a-38f5-4f4f-bbce-0bd5eb70188b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
709 | 2024.10.09 22:51:55.554417 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
710 | 2024.10.09 22:51:55.554542 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
711 | 2024.10.09 22:51:55.554600 [ 3 ] {} <Debug> HTTP-Session: 2fa79c5e-8a55-49fc-8767-7ff8a58246c0 Authenticating user 'default' from [::1]:65139 | ||
712 | 2024.10.09 22:51:55.554629 [ 3 ] {} <Debug> HTTP-Session: 2fa79c5e-8a55-49fc-8767-7ff8a58246c0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
713 | 2024.10.09 22:51:55.554645 [ 3 ] {} <Debug> HTTP-Session: 2fa79c5e-8a55-49fc-8767-7ff8a58246c0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
714 | 2024.10.09 22:51:55.554702 [ 3 ] {} <Trace> HTTP-Session: 2fa79c5e-8a55-49fc-8767-7ff8a58246c0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
715 | 2024.10.09 22:51:55.555064 [ 3 ] {cf7bce9f-25be-42ba-8738-614652d5772d} <Debug> executeQuery: (from [::1]:65139) 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) | ||
716 | 2024.10.09 22:51:55.555143 [ 3 ] {cf7bce9f-25be-42ba-8738-614652d5772d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
717 | 2024.10.09 22:51:55.557954 [ 3 ] {cf7bce9f-25be-42ba-8738-614652d5772d} <Debug> oximeter.fields_u64 (c28b9bc8-1db3-4bff-a754-399f43be0263): Loading data parts | ||
718 | 2024.10.09 22:51:55.558213 [ 3 ] {cf7bce9f-25be-42ba-8738-614652d5772d} <Debug> oximeter.fields_u64 (c28b9bc8-1db3-4bff-a754-399f43be0263): There are no data parts | ||
719 | 2024.10.09 22:51:55.560240 [ 3 ] {cf7bce9f-25be-42ba-8738-614652d5772d} <Debug> DynamicQueryHandler: Done processing query | ||
720 | 2024.10.09 22:51:55.560278 [ 3 ] {} <Debug> HTTP-Session: 2fa79c5e-8a55-49fc-8767-7ff8a58246c0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
721 | 2024.10.09 22:51:55.560975 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
722 | 2024.10.09 22:51:55.561126 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
723 | 2024.10.09 22:51:55.561160 [ 3 ] {} <Debug> HTTP-Session: 100c704f-2826-491b-ab97-ca6928d554bd Authenticating user 'default' from [::1]:65139 | ||
724 | 2024.10.09 22:51:55.561186 [ 3 ] {} <Debug> HTTP-Session: 100c704f-2826-491b-ab97-ca6928d554bd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
725 | 2024.10.09 22:51:55.561203 [ 3 ] {} <Debug> HTTP-Session: 100c704f-2826-491b-ab97-ca6928d554bd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
726 | 2024.10.09 22:51:55.561255 [ 3 ] {} <Trace> HTTP-Session: 100c704f-2826-491b-ab97-ca6928d554bd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
727 | 2024.10.09 22:51:55.561637 [ 3 ] {61fec9b4-34c9-4c9b-8261-491f3155d720} <Debug> executeQuery: (from [::1]:65139) 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) | ||
728 | 2024.10.09 22:51:55.561706 [ 3 ] {61fec9b4-34c9-4c9b-8261-491f3155d720} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
729 | 2024.10.09 22:51:55.563928 [ 3 ] {61fec9b4-34c9-4c9b-8261-491f3155d720} <Debug> oximeter.fields_ipaddr (3d52bf9e-30ca-44a9-b21c-b859f4f16892): Loading data parts | ||
730 | 2024.10.09 22:51:55.564227 [ 3 ] {61fec9b4-34c9-4c9b-8261-491f3155d720} <Debug> oximeter.fields_ipaddr (3d52bf9e-30ca-44a9-b21c-b859f4f16892): There are no data parts | ||
731 | 2024.10.09 22:51:55.576129 [ 3 ] {61fec9b4-34c9-4c9b-8261-491f3155d720} <Debug> DynamicQueryHandler: Done processing query | ||
732 | 2024.10.09 22:51:55.576192 [ 3 ] {} <Debug> HTTP-Session: 100c704f-2826-491b-ab97-ca6928d554bd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
733 | 2024.10.09 22:51:55.576901 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
734 | 2024.10.09 22:51:55.576985 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
735 | 2024.10.09 22:51:55.577034 [ 3 ] {} <Debug> HTTP-Session: 6e37ef40-d90f-42cd-91b6-d0ff9788719f Authenticating user 'default' from [::1]:65139 | ||
736 | 2024.10.09 22:51:55.577057 [ 3 ] {} <Debug> HTTP-Session: 6e37ef40-d90f-42cd-91b6-d0ff9788719f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
737 | 2024.10.09 22:51:55.577180 [ 3 ] {} <Debug> HTTP-Session: 6e37ef40-d90f-42cd-91b6-d0ff9788719f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
738 | 2024.10.09 22:51:55.577243 [ 3 ] {} <Trace> HTTP-Session: 6e37ef40-d90f-42cd-91b6-d0ff9788719f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
739 | 2024.10.09 22:51:55.577704 [ 3 ] {4c6486a4-4183-4dd2-895c-2594c50a64f2} <Debug> executeQuery: (from [::1]:65139) 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) | ||
740 | 2024.10.09 22:51:55.577781 [ 3 ] {4c6486a4-4183-4dd2-895c-2594c50a64f2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
741 | 2024.10.09 22:51:55.580950 [ 3 ] {4c6486a4-4183-4dd2-895c-2594c50a64f2} <Debug> oximeter.fields_string (a9fc56c1-a8fa-4d93-989b-54dadad54a64): Loading data parts | ||
742 | 2024.10.09 22:51:55.581255 [ 3 ] {4c6486a4-4183-4dd2-895c-2594c50a64f2} <Debug> oximeter.fields_string (a9fc56c1-a8fa-4d93-989b-54dadad54a64): There are no data parts | ||
743 | 2024.10.09 22:51:55.582898 [ 3 ] {4c6486a4-4183-4dd2-895c-2594c50a64f2} <Debug> DynamicQueryHandler: Done processing query | ||
744 | 2024.10.09 22:51:55.582922 [ 3 ] {} <Debug> HTTP-Session: 6e37ef40-d90f-42cd-91b6-d0ff9788719f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
745 | 2024.10.09 22:51:55.583635 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
746 | 2024.10.09 22:51:55.583706 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
747 | 2024.10.09 22:51:55.583735 [ 3 ] {} <Debug> HTTP-Session: d141dbc4-0822-459a-b7f1-4237261f1e09 Authenticating user 'default' from [::1]:65139 | ||
748 | 2024.10.09 22:51:55.583761 [ 3 ] {} <Debug> HTTP-Session: d141dbc4-0822-459a-b7f1-4237261f1e09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
749 | 2024.10.09 22:51:55.583778 [ 3 ] {} <Debug> HTTP-Session: d141dbc4-0822-459a-b7f1-4237261f1e09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
750 | 2024.10.09 22:51:55.583828 [ 3 ] {} <Trace> HTTP-Session: d141dbc4-0822-459a-b7f1-4237261f1e09 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
751 | 2024.10.09 22:51:55.584221 [ 3 ] {013fd9c7-734a-47a1-b7d5-225a2fce2ddb} <Debug> executeQuery: (from [::1]:65139) 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) | ||
752 | 2024.10.09 22:51:55.584295 [ 3 ] {013fd9c7-734a-47a1-b7d5-225a2fce2ddb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
753 | 2024.10.09 22:51:55.587028 [ 3 ] {013fd9c7-734a-47a1-b7d5-225a2fce2ddb} <Debug> oximeter.fields_uuid (633865da-def0-4024-8d7a-f32f08b424eb): Loading data parts | ||
754 | 2024.10.09 22:51:55.587324 [ 3 ] {013fd9c7-734a-47a1-b7d5-225a2fce2ddb} <Debug> oximeter.fields_uuid (633865da-def0-4024-8d7a-f32f08b424eb): There are no data parts | ||
755 | 2024.10.09 22:51:55.589144 [ 3 ] {013fd9c7-734a-47a1-b7d5-225a2fce2ddb} <Debug> DynamicQueryHandler: Done processing query | ||
756 | 2024.10.09 22:51:55.589172 [ 3 ] {} <Debug> HTTP-Session: d141dbc4-0822-459a-b7f1-4237261f1e09 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
757 | 2024.10.09 22:51:55.589826 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
758 | 2024.10.09 22:51:55.589895 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
759 | 2024.10.09 22:51:55.589966 [ 3 ] {} <Debug> HTTP-Session: 8b8531ba-6b03-4285-b15c-228963216c32 Authenticating user 'default' from [::1]:65139 | ||
760 | 2024.10.09 22:51:55.590019 [ 3 ] {} <Debug> HTTP-Session: 8b8531ba-6b03-4285-b15c-228963216c32 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
761 | 2024.10.09 22:51:55.590038 [ 3 ] {} <Debug> HTTP-Session: 8b8531ba-6b03-4285-b15c-228963216c32 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
762 | 2024.10.09 22:51:55.590084 [ 3 ] {} <Trace> HTTP-Session: 8b8531ba-6b03-4285-b15c-228963216c32 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
763 | 2024.10.09 22:51:55.590424 [ 3 ] {782bbf47-cfeb-41c2-933a-db1d7cde18bd} <Debug> executeQuery: (from [::1]:65139) /* The timeseries schema table stores the extracted schema for the samples | ||
764 | * oximeter collects. | ||
765 | */ | ||
766 | 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) | ||
767 | 2024.10.09 22:51:55.590516 [ 3 ] {782bbf47-cfeb-41c2-933a-db1d7cde18bd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
768 | 2024.10.09 22:51:55.592802 [ 3 ] {782bbf47-cfeb-41c2-933a-db1d7cde18bd} <Debug> oximeter.timeseries_schema (952dd929-dfd4-45a9-93f8-f29564fed90a): Loading data parts | ||
769 | 2024.10.09 22:51:55.593150 [ 3 ] {782bbf47-cfeb-41c2-933a-db1d7cde18bd} <Debug> oximeter.timeseries_schema (952dd929-dfd4-45a9-93f8-f29564fed90a): There are no data parts | ||
770 | 2024.10.09 22:51:55.594877 [ 3 ] {782bbf47-cfeb-41c2-933a-db1d7cde18bd} <Debug> DynamicQueryHandler: Done processing query | ||
771 | 2024.10.09 22:51:55.594910 [ 3 ] {} <Debug> HTTP-Session: 8b8531ba-6b03-4285-b15c-228963216c32 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
772 | 2024.10.09 22:51:55.595659 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:65139, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
773 | 2024.10.09 22:51:55.595733 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
774 | 2024.10.09 22:51:55.595761 [ 3 ] {} <Debug> HTTP-Session: 1b29d3be-8ce2-4bb1-ab42-7847ee8bc636 Authenticating user 'default' from [::1]:65139 | ||
775 | 2024.10.09 22:51:55.595785 [ 3 ] {} <Debug> HTTP-Session: 1b29d3be-8ce2-4bb1-ab42-7847ee8bc636 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
776 | 2024.10.09 22:51:55.595798 [ 3 ] {} <Debug> HTTP-Session: 1b29d3be-8ce2-4bb1-ab42-7847ee8bc636 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
777 | 2024.10.09 22:51:55.595841 [ 3 ] {} <Trace> HTTP-Session: 1b29d3be-8ce2-4bb1-ab42-7847ee8bc636 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
778 | 2024.10.09 22:51:55.596051 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Debug> executeQuery: (from [::1]:65139) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
779 | 2024.10.09 22:51:55.596236 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
780 | 2024.10.09 22:51:55.598617 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Trace> oximeter.version (64ef1028-bbea-4aca-a242-a56a21010998): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
781 | 2024.10.09 22:51:55.598682 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.14 GiB. | ||
782 | 2024.10.09 22:51:55.599690 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
783 | 2024.10.09 22:51:55.600438 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Trace> oximeter.version (64ef1028-bbea-4aca-a242-a56a21010998): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
784 | 2024.10.09 22:51:55.600842 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.004887 sec., 204.62451401677922 rows/sec., 3.20 KiB/sec. | ||
785 | 2024.10.09 22:51:55.601066 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Debug> DynamicQueryHandler: Done processing query | ||
786 | 2024.10.09 22:51:55.601095 [ 3 ] {d07bcbcb-475a-4b45-a0ef-85fb0829e0aa} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
787 | 2024.10.09 22:51:55.601114 [ 3 ] {} <Debug> HTTP-Session: 1b29d3be-8ce2-4bb1-ab42-7847ee8bc636 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
788 | 2024.10.09 22:51:56.000445 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 131.16 MiB, peak 136.30 MiB, free memory in arenas 0.00 B, will set to 135.65 MiB (RSS), difference: 4.49 MiB |