Max level shown:
1 2024.09.12 19:21:31.687471 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 10144
2 2024.09.12 19:21:31.687790 [ 1 ] {} <Information> Application: starting up
3 2024.09.12 19:21:31.687859 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc
4 2024.09.12 19:21:31.699477 [ 1 ] {} <Information> Application: Available RAM: 31.99 GiB; physical cores: 8; logical cores: 8.
5 2024.09.12 19:21:31.707305 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536
6 2024.09.12 19:21:31.711734 [ 1 ] {} <Debug> Application: Initializing DateLUT.
7 2024.09.12 19:21:31.711826 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
8 2024.09.12 19:21:31.711905 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/omicron_nexus-5f590c67750dc30c-test_deploy_omicron_zones.10132.1-clickhouse-LirrEm/datastore/tmp/ to store temporary data in it
9 2024.09.12 19:21:31.713701 [ 1 ] {} <Debug> Application: Initializing interserver credentials.
10 2024.09.12 19:21:31.716194 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
11 2024.09.12 19:21:31.718289 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
12 2024.09.12 19:21:31.718929 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.79 GiB (31.99 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
13 2024.09.12 19:21:31.718957 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 16.00 GiB (31.99 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
14 2024.09.12 19:21:31.718979 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 16.00 GiB
15 2024.09.12 19:21:31.719090 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
16 2024.09.12 19:21:31.723995 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
17 2024.09.12 19:21:31.767540 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
18 2024.09.12 19:21:31.769437 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
19 2024.09.12 19:21:31.770675 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
20 2024.09.12 19:21:31.771185 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
21 2024.09.12 19:21:31.772510 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
22 2024.09.12 19:21:31.774650 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
23 2024.09.12 19:21:31.786069 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
24 2024.09.12 19:21:31.787036 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml
25 2024.09.12 19:21:31.794083 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
26 2024.09.12 19:21:31.794866 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
27 2024.09.12 19:21:31.795613 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
28 2024.09.12 19:21:31.796922 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
29 2024.09.12 19:21:31.798312 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
30 2024.09.12 19:21:31.798376 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/omicron_nexus-5f590c67750dc30c-test_deploy_omicron_zones.10132.1-clickhouse-LirrEm/datastore/
31 2024.09.12 19:21:31.798471 [ 8 ] {} <Debug> DNSResolver: Updating DNS cache
32 2024.09.12 19:21:31.798696 [ 8 ] {} <Debug> DNSResolver: Updated DNS cache
33 2024.09.12 19:21:31.807662 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
34 2024.09.12 19:21:31.807702 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000207313 sec
35 2024.09.12 19:21:31.807740 [ 1 ] {} <Trace> ReferentialDeps: No tables
36 2024.09.12 19:21:31.807750 [ 1 ] {} <Trace> LoadingDeps: No tables
37 2024.09.12 19:21:31.808117 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables.
38 2024.09.12 19:21:31.808251 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config
39 2024.09.12 19:21:31.808272 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
40 2024.09.12 19:21:31.808379 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
41 2024.09.12 19:21:31.808407 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
42 2024.09.12 19:21:31.808418 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
43 2024.09.12 19:21:31.808448 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
44 2024.09.12 19:21:31.808502 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config
45 2024.09.12 19:21:31.808530 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
46 2024.09.12 19:21:31.808563 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
47 2024.09.12 19:21:31.808575 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config
48 2024.09.12 19:21:31.808591 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
49 2024.09.12 19:21:31.808602 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
50 2024.09.12 19:21:31.808634 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
51 2024.09.12 19:21:31.808650 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
52 2024.09.12 19:21:31.808663 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
53 2024.09.12 19:21:31.808690 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
54 2024.09.12 19:21:31.808707 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
55 2024.09.12 19:21:31.884720 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
56 2024.09.12 19:21:31.887212 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
57 2024.09.12 19:21:31.887285 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00024114 sec
58 2024.09.12 19:21:31.887344 [ 1 ] {} <Trace> ReferentialDeps: No tables
59 2024.09.12 19:21:31.887355 [ 1 ] {} <Trace> LoadingDeps: No tables
60 2024.09.12 19:21:31.887396 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables.
61 2024.09.12 19:21:31.887691 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/omicron_nexus-5f590c67750dc30c-test_deploy_omicron_zones.10132.1-clickhouse-LirrEm/datastore/user_defined/
62 2024.09.12 19:21:31.887768 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
63 2024.09.12 19:21:31.887781 [ 1 ] {} <Debug> Application: Loaded metadata.
64 2024.09.12 19:21:31.887790 [ 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.09.12 19:21:31.887804 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled.
66 2024.09.12 19:21:31.891952 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41015
67 2024.09.12 19:21:31.894117 [ 1 ] {} <Warning> Application: Listen [::1]:9000 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: [::1]:9000 (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>
68 2024.09.12 19:21:31.896018 [ 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.09.12 19:21:31.896123 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 58633
70 2024.09.12 19:21:31.896282 [ 1 ] {} <Warning> Application: Listen [127.0.0.1]:9000 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: 127.0.0.1:9000 (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>
71 2024.09.12 19:21:31.896418 [ 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.09.12 19:21:31.896467 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
73 2024.09.12 19:21:31.897125 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.08 MiB, free memory in arenas 0.00 B, will set to 139.38 MiB (RSS), difference: 129.51 MiB
74 2024.09.12 19:21:31.897700 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.5531e-05 sec.
75 2024.09.12 19:21:31.898403 [ 1 ] {} <Information> Application: Listening for http://[::1]:41015
76 2024.09.12 19:21:31.898507 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:58633
77 2024.09.12 19:21:31.898521 [ 1 ] {} <Information> Application: Ready for connections.
78 2024.09.12 19:21:44.257998 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
79 2024.09.12 19:21:44.259008 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
80 2024.09.12 19:21:44.259058 [ 3 ] {} <Debug> HTTP-Session: 804a0ac0-b793-422a-ba9e-938a0b374113 Authenticating user 'default' from [::1]:40717
81 2024.09.12 19:21:44.259086 [ 3 ] {} <Debug> HTTP-Session: 804a0ac0-b793-422a-ba9e-938a0b374113 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
82 2024.09.12 19:21:44.259100 [ 3 ] {} <Debug> HTTP-Session: 804a0ac0-b793-422a-ba9e-938a0b374113 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
83 2024.09.12 19:21:44.259212 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
84 2024.09.12 19:21:44.259246 [ 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
85 2024.09.12 19:21:44.259269 [ 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
86 2024.09.12 19:21:44.259321 [ 3 ] {} <Trace> HTTP-Session: 804a0ac0-b793-422a-ba9e-938a0b374113 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
87 2024.09.12 19:21:44.259807 [ 3 ] {7bd84676-2163-4bfd-929e-fef0634778ea} <Debug> executeQuery: (from [::1]:40717) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
88 2024.09.12 19:21:44.269102 [ 3 ] {7bd84676-2163-4bfd-929e-fef0634778ea} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:40717) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
89 
90 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
91 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
92 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
93 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
94 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
95 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
96 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
97 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
98 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
99 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
100 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
101 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
102 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
103 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
104 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
105 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
106 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
107 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
108 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
109 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
110 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
111 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1
112 
113 2024.09.12 19:21:44.269337 [ 3 ] {7bd84676-2163-4bfd-929e-fef0634778ea} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
114 
115 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
116 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
117 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
118 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
119 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
120 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
121 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
122 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
123 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
124 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
125 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
126 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
127 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
128 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
129 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
130 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
131 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
132 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
133 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
134 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
135 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
136 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1
137 (version 23.8.7.1)
138 2024.09.12 19:21:44.269654 [ 3 ] {} <Debug> HTTP-Session: 804a0ac0-b793-422a-ba9e-938a0b374113 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
139 2024.09.12 19:21:44.277106 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
140 2024.09.12 19:21:44.277296 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
141 2024.09.12 19:21:44.277355 [ 3 ] {} <Debug> HTTP-Session: 253dac4d-1044-46c8-84a4-ded51f39b2ac Authenticating user 'default' from [::1]:40717
142 2024.09.12 19:21:44.277385 [ 3 ] {} <Debug> HTTP-Session: 253dac4d-1044-46c8-84a4-ded51f39b2ac Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
143 2024.09.12 19:21:44.277397 [ 3 ] {} <Debug> HTTP-Session: 253dac4d-1044-46c8-84a4-ded51f39b2ac Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
144 2024.09.12 19:21:44.277473 [ 3 ] {} <Trace> HTTP-Session: 253dac4d-1044-46c8-84a4-ded51f39b2ac Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
145 2024.09.12 19:21:44.277987 [ 3 ] {63c4a3e4-b9a2-40ef-a9da-682a11aece26} <Debug> executeQuery: (from [::1]:40717) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
146 2024.09.12 19:21:44.278518 [ 3 ] {63c4a3e4-b9a2-40ef-a9da-682a11aece26} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:40717) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
147 
148 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
149 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
150 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
151 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
152 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
153 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
154 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
155 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
156 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
157 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
158 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
159 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
160 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
161 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
162 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
163 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
164 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
165 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
166 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
167 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
168 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
169 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1
170 
171 2024.09.12 19:21:44.278726 [ 3 ] {63c4a3e4-b9a2-40ef-a9da-682a11aece26} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
172 
173 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
174 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
175 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
176 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
177 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
178 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
179 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
180 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
181 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
182 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
183 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
184 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
185 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
186 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
187 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
188 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
189 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
190 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
191 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
192 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
193 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
194 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1
195 (version 23.8.7.1)
196 2024.09.12 19:21:44.279066 [ 3 ] {} <Debug> HTTP-Session: 253dac4d-1044-46c8-84a4-ded51f39b2ac Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
197 2024.09.12 19:21:44.299782 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
198 2024.09.12 19:21:44.299926 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
199 2024.09.12 19:21:44.299973 [ 3 ] {} <Debug> HTTP-Session: e69d2b5d-a74b-4bfa-b09e-52f2fabfa0bd Authenticating user 'default' from [::1]:40717
200 2024.09.12 19:21:44.300046 [ 3 ] {} <Debug> HTTP-Session: e69d2b5d-a74b-4bfa-b09e-52f2fabfa0bd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
201 2024.09.12 19:21:44.300179 [ 3 ] {} <Debug> HTTP-Session: e69d2b5d-a74b-4bfa-b09e-52f2fabfa0bd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
202 2024.09.12 19:21:44.300247 [ 3 ] {} <Trace> HTTP-Session: e69d2b5d-a74b-4bfa-b09e-52f2fabfa0bd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
203 2024.09.12 19:21:44.300643 [ 3 ] {c1bfc2fe-db5a-4bd2-8110-dc38abb9bb05} <Debug> executeQuery: (from [::1]:40717) DROP DATABASE IF EXISTS oximeter (stage: Complete)
204 2024.09.12 19:21:44.300938 [ 3 ] {c1bfc2fe-db5a-4bd2-8110-dc38abb9bb05} <Debug> DynamicQueryHandler: Done processing query
205 2024.09.12 19:21:44.300966 [ 3 ] {} <Debug> HTTP-Session: e69d2b5d-a74b-4bfa-b09e-52f2fabfa0bd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
206 2024.09.12 19:21:44.305236 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
207 2024.09.12 19:21:44.305432 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
208 2024.09.12 19:21:44.305476 [ 3 ] {} <Debug> HTTP-Session: b7b65194-bb71-4635-864c-3bf4bfeae6fd Authenticating user 'default' from [::1]:40717
209 2024.09.12 19:21:44.305496 [ 3 ] {} <Debug> HTTP-Session: b7b65194-bb71-4635-864c-3bf4bfeae6fd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
210 2024.09.12 19:21:44.305509 [ 3 ] {} <Debug> HTTP-Session: b7b65194-bb71-4635-864c-3bf4bfeae6fd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
211 2024.09.12 19:21:44.305552 [ 3 ] {} <Trace> HTTP-Session: b7b65194-bb71-4635-864c-3bf4bfeae6fd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
212 2024.09.12 19:21:44.305713 [ 3 ] {513f98b6-d9fa-45a5-b462-2137a693da97} <Debug> executeQuery: (from [::1]:40717) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
213 2024.09.12 19:21:44.305805 [ 3 ] {513f98b6-d9fa-45a5-b462-2137a693da97} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
214 2024.09.12 19:21:44.307192 [ 3 ] {513f98b6-d9fa-45a5-b462-2137a693da97} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
215 2024.09.12 19:21:44.307218 [ 3 ] {513f98b6-d9fa-45a5-b462-2137a693da97} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.8406e-05 sec
216 2024.09.12 19:21:44.307231 [ 3 ] {513f98b6-d9fa-45a5-b462-2137a693da97} <Trace> ReferentialDeps: No tables
217 2024.09.12 19:21:44.307242 [ 3 ] {513f98b6-d9fa-45a5-b462-2137a693da97} <Trace> LoadingDeps: No tables
218 2024.09.12 19:21:44.307279 [ 3 ] {513f98b6-d9fa-45a5-b462-2137a693da97} <Information> DatabaseAtomic (oximeter): Starting up tables.
219 2024.09.12 19:21:44.307440 [ 3 ] {513f98b6-d9fa-45a5-b462-2137a693da97} <Debug> DynamicQueryHandler: Done processing query
220 2024.09.12 19:21:44.307465 [ 3 ] {} <Debug> HTTP-Session: b7b65194-bb71-4635-864c-3bf4bfeae6fd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
221 2024.09.12 19:21:44.309176 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
222 2024.09.12 19:21:44.309307 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
223 2024.09.12 19:21:44.309328 [ 3 ] {} <Debug> HTTP-Session: 86884a26-a995-44ae-84db-e97f030a25d1 Authenticating user 'default' from [::1]:40717
224 2024.09.12 19:21:44.309345 [ 3 ] {} <Debug> HTTP-Session: 86884a26-a995-44ae-84db-e97f030a25d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
225 2024.09.12 19:21:44.309363 [ 3 ] {} <Debug> HTTP-Session: 86884a26-a995-44ae-84db-e97f030a25d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
226 2024.09.12 19:21:44.309447 [ 3 ] {} <Trace> HTTP-Session: 86884a26-a995-44ae-84db-e97f030a25d1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
227 2024.09.12 19:21:44.309678 [ 3 ] {b00911fb-ae08-4f2e-a522-21af5ff21490} <Debug> executeQuery: (from [::1]:40717) /* The version table contains metadata about the `oximeter` database */
228 CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete)
229 2024.09.12 19:21:44.309752 [ 3 ] {b00911fb-ae08-4f2e-a522-21af5ff21490} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
230 2024.09.12 19:21:44.311647 [ 3 ] {b00911fb-ae08-4f2e-a522-21af5ff21490} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
231 2024.09.12 19:21:44.313039 [ 3 ] {b00911fb-ae08-4f2e-a522-21af5ff21490} <Debug> oximeter.version (2ec1e53b-12bf-4274-a5c1-5777ab22df23): Loading data parts
232 2024.09.12 19:21:44.314388 [ 3 ] {b00911fb-ae08-4f2e-a522-21af5ff21490} <Debug> oximeter.version (2ec1e53b-12bf-4274-a5c1-5777ab22df23): There are no data parts
233 2024.09.12 19:21:44.316163 [ 3 ] {b00911fb-ae08-4f2e-a522-21af5ff21490} <Debug> DynamicQueryHandler: Done processing query
234 2024.09.12 19:21:44.316204 [ 3 ] {} <Debug> HTTP-Session: 86884a26-a995-44ae-84db-e97f030a25d1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
235 2024.09.12 19:21:44.323587 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
236 2024.09.12 19:21:44.323770 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
237 2024.09.12 19:21:44.323821 [ 3 ] {} <Debug> HTTP-Session: cae8e63d-cb73-48d8-8021-e0c05c3bd6b2 Authenticating user 'default' from [::1]:40717
238 2024.09.12 19:21:44.323851 [ 3 ] {} <Debug> HTTP-Session: cae8e63d-cb73-48d8-8021-e0c05c3bd6b2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
239 2024.09.12 19:21:44.323945 [ 3 ] {} <Debug> HTTP-Session: cae8e63d-cb73-48d8-8021-e0c05c3bd6b2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
240 2024.09.12 19:21:44.324040 [ 3 ] {} <Trace> HTTP-Session: cae8e63d-cb73-48d8-8021-e0c05c3bd6b2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
241 2024.09.12 19:21:44.324492 [ 3 ] {a0bcb30f-104b-454a-9ec9-1cfd64893e05} <Debug> executeQuery: (from [::1]:40717) /* The measurement tables contain all individual samples from each timeseries.
242 *
243 * Each table stores a single datum type, and otherwise contains nearly the same
244 * structure. The primary sorting key is on the timeseries name, key, and then
245 * timestamp, so that all timeseries from the same schema are grouped, followed
246 * by all samples from the same timeseries.
247 *
248 * This reflects that one usually looks up the _key_ in one or more field table,
249 * and then uses that to index quickly into the measurements tables.
250 */
251 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)
252 2024.09.12 19:21:44.324587 [ 3 ] {a0bcb30f-104b-454a-9ec9-1cfd64893e05} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
253 2024.09.12 19:21:44.327720 [ 3 ] {a0bcb30f-104b-454a-9ec9-1cfd64893e05} <Debug> oximeter.measurements_bool (dc22ed5e-c0a0-4eac-968d-f13d218ae329): Loading data parts
254 2024.09.12 19:21:44.328778 [ 3 ] {a0bcb30f-104b-454a-9ec9-1cfd64893e05} <Debug> oximeter.measurements_bool (dc22ed5e-c0a0-4eac-968d-f13d218ae329): There are no data parts
255 2024.09.12 19:21:44.330670 [ 3 ] {a0bcb30f-104b-454a-9ec9-1cfd64893e05} <Debug> DynamicQueryHandler: Done processing query
256 2024.09.12 19:21:44.330713 [ 3 ] {} <Debug> HTTP-Session: cae8e63d-cb73-48d8-8021-e0c05c3bd6b2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
257 2024.09.12 19:21:44.332826 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
258 2024.09.12 19:21:44.332953 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
259 2024.09.12 19:21:44.332980 [ 3 ] {} <Debug> HTTP-Session: 0d6be092-785f-4459-b390-07de368766f2 Authenticating user 'default' from [::1]:40717
260 2024.09.12 19:21:44.333009 [ 3 ] {} <Debug> HTTP-Session: 0d6be092-785f-4459-b390-07de368766f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
261 2024.09.12 19:21:44.333031 [ 3 ] {} <Debug> HTTP-Session: 0d6be092-785f-4459-b390-07de368766f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
262 2024.09.12 19:21:44.333087 [ 3 ] {} <Trace> HTTP-Session: 0d6be092-785f-4459-b390-07de368766f2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
263 2024.09.12 19:21:44.333611 [ 3 ] {1ac3eca6-a1fa-417e-b4ce-636cebb5a6ff} <Debug> executeQuery: (from [::1]:40717) 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)
264 2024.09.12 19:21:44.333695 [ 3 ] {1ac3eca6-a1fa-417e-b4ce-636cebb5a6ff} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
265 2024.09.12 19:21:44.335924 [ 3 ] {1ac3eca6-a1fa-417e-b4ce-636cebb5a6ff} <Debug> oximeter.measurements_i8 (a5b8bf9e-a963-4404-b241-66ff33f42cf6): Loading data parts
266 2024.09.12 19:21:44.336423 [ 3 ] {1ac3eca6-a1fa-417e-b4ce-636cebb5a6ff} <Debug> oximeter.measurements_i8 (a5b8bf9e-a963-4404-b241-66ff33f42cf6): There are no data parts
267 2024.09.12 19:21:44.338087 [ 3 ] {1ac3eca6-a1fa-417e-b4ce-636cebb5a6ff} <Debug> DynamicQueryHandler: Done processing query
268 2024.09.12 19:21:44.338129 [ 3 ] {} <Debug> HTTP-Session: 0d6be092-785f-4459-b390-07de368766f2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
269 2024.09.12 19:21:44.341754 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
270 2024.09.12 19:21:44.341850 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
271 2024.09.12 19:21:44.341890 [ 3 ] {} <Debug> HTTP-Session: 0f1a6030-042a-44fa-9afc-d208733f08ed Authenticating user 'default' from [::1]:40717
272 2024.09.12 19:21:44.341913 [ 3 ] {} <Debug> HTTP-Session: 0f1a6030-042a-44fa-9afc-d208733f08ed Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
273 2024.09.12 19:21:44.341926 [ 3 ] {} <Debug> HTTP-Session: 0f1a6030-042a-44fa-9afc-d208733f08ed Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
274 2024.09.12 19:21:44.342084 [ 3 ] {} <Trace> HTTP-Session: 0f1a6030-042a-44fa-9afc-d208733f08ed Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
275 2024.09.12 19:21:44.342379 [ 3 ] {5dca7dce-ae0b-43ad-9700-e743598420a2} <Debug> executeQuery: (from [::1]:40717) 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)
276 2024.09.12 19:21:44.342459 [ 3 ] {5dca7dce-ae0b-43ad-9700-e743598420a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
277 2024.09.12 19:21:44.348707 [ 3 ] {5dca7dce-ae0b-43ad-9700-e743598420a2} <Debug> oximeter.measurements_u8 (25c0e1f0-fe26-42c7-a205-e49057742969): Loading data parts
278 2024.09.12 19:21:44.353914 [ 3 ] {5dca7dce-ae0b-43ad-9700-e743598420a2} <Debug> oximeter.measurements_u8 (25c0e1f0-fe26-42c7-a205-e49057742969): There are no data parts
279 2024.09.12 19:21:44.355608 [ 3 ] {5dca7dce-ae0b-43ad-9700-e743598420a2} <Debug> DynamicQueryHandler: Done processing query
280 2024.09.12 19:21:44.355639 [ 3 ] {} <Debug> HTTP-Session: 0f1a6030-042a-44fa-9afc-d208733f08ed Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
281 2024.09.12 19:21:44.358763 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
282 2024.09.12 19:21:44.358989 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
283 2024.09.12 19:21:44.359025 [ 3 ] {} <Debug> HTTP-Session: 1108a825-208d-47ef-acc3-16040debfb32 Authenticating user 'default' from [::1]:40717
284 2024.09.12 19:21:44.359051 [ 3 ] {} <Debug> HTTP-Session: 1108a825-208d-47ef-acc3-16040debfb32 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
285 2024.09.12 19:21:44.359074 [ 3 ] {} <Debug> HTTP-Session: 1108a825-208d-47ef-acc3-16040debfb32 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
286 2024.09.12 19:21:44.359123 [ 3 ] {} <Trace> HTTP-Session: 1108a825-208d-47ef-acc3-16040debfb32 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
287 2024.09.12 19:21:44.359412 [ 3 ] {45b8d03e-4537-4c67-a4c0-b47bc4aa529c} <Debug> executeQuery: (from [::1]:40717) 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)
288 2024.09.12 19:21:44.359530 [ 3 ] {45b8d03e-4537-4c67-a4c0-b47bc4aa529c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
289 2024.09.12 19:21:44.362561 [ 3 ] {45b8d03e-4537-4c67-a4c0-b47bc4aa529c} <Debug> oximeter.measurements_i16 (cc605520-78b8-4aeb-aa65-13c038ab42a6): Loading data parts
290 2024.09.12 19:21:44.363162 [ 3 ] {45b8d03e-4537-4c67-a4c0-b47bc4aa529c} <Debug> oximeter.measurements_i16 (cc605520-78b8-4aeb-aa65-13c038ab42a6): There are no data parts
291 2024.09.12 19:21:44.367509 [ 3 ] {45b8d03e-4537-4c67-a4c0-b47bc4aa529c} <Debug> DynamicQueryHandler: Done processing query
292 2024.09.12 19:21:44.367559 [ 3 ] {} <Debug> HTTP-Session: 1108a825-208d-47ef-acc3-16040debfb32 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
293 2024.09.12 19:21:44.377218 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
294 2024.09.12 19:21:44.377345 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
295 2024.09.12 19:21:44.377377 [ 3 ] {} <Debug> HTTP-Session: 29060f64-1083-499c-b111-2c3e22219160 Authenticating user 'default' from [::1]:40717
296 2024.09.12 19:21:44.377420 [ 3 ] {} <Debug> HTTP-Session: 29060f64-1083-499c-b111-2c3e22219160 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
297 2024.09.12 19:21:44.377436 [ 3 ] {} <Debug> HTTP-Session: 29060f64-1083-499c-b111-2c3e22219160 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
298 2024.09.12 19:21:44.377496 [ 3 ] {} <Trace> HTTP-Session: 29060f64-1083-499c-b111-2c3e22219160 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
299 2024.09.12 19:21:44.378236 [ 3 ] {43604f6c-ae96-49cf-9d93-e1f529dd5dd7} <Debug> executeQuery: (from [::1]:40717) 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)
300 2024.09.12 19:21:44.378366 [ 3 ] {43604f6c-ae96-49cf-9d93-e1f529dd5dd7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
301 2024.09.12 19:21:44.382061 [ 3 ] {43604f6c-ae96-49cf-9d93-e1f529dd5dd7} <Debug> oximeter.measurements_u16 (aaba5e20-8f87-4f4a-9117-b025e7c85cac): Loading data parts
302 2024.09.12 19:21:44.382654 [ 3 ] {43604f6c-ae96-49cf-9d93-e1f529dd5dd7} <Debug> oximeter.measurements_u16 (aaba5e20-8f87-4f4a-9117-b025e7c85cac): There are no data parts
303 2024.09.12 19:21:44.385010 [ 3 ] {43604f6c-ae96-49cf-9d93-e1f529dd5dd7} <Debug> DynamicQueryHandler: Done processing query
304 2024.09.12 19:21:44.385048 [ 3 ] {} <Debug> HTTP-Session: 29060f64-1083-499c-b111-2c3e22219160 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
305 2024.09.12 19:21:44.571102 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
306 2024.09.12 19:21:44.571320 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
307 2024.09.12 19:21:44.571354 [ 3 ] {} <Debug> HTTP-Session: 6c50a777-baf4-49a5-b282-57a2410cec3a Authenticating user 'default' from [::1]:40717
308 2024.09.12 19:21:44.571383 [ 3 ] {} <Debug> HTTP-Session: 6c50a777-baf4-49a5-b282-57a2410cec3a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
309 2024.09.12 19:21:44.571396 [ 3 ] {} <Debug> HTTP-Session: 6c50a777-baf4-49a5-b282-57a2410cec3a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
310 2024.09.12 19:21:44.571492 [ 3 ] {} <Trace> HTTP-Session: 6c50a777-baf4-49a5-b282-57a2410cec3a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
311 2024.09.12 19:21:44.571966 [ 3 ] {b8cfabb4-1deb-4c0d-9d84-0fc37f491d4d} <Debug> executeQuery: (from [::1]:40717) 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)
312 2024.09.12 19:21:44.572065 [ 3 ] {b8cfabb4-1deb-4c0d-9d84-0fc37f491d4d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
313 2024.09.12 19:21:44.574495 [ 3 ] {b8cfabb4-1deb-4c0d-9d84-0fc37f491d4d} <Debug> oximeter.measurements_i32 (7cb4d0b6-69a0-49d2-87e4-78c93e9090f4): Loading data parts
314 2024.09.12 19:21:44.574889 [ 3 ] {b8cfabb4-1deb-4c0d-9d84-0fc37f491d4d} <Debug> oximeter.measurements_i32 (7cb4d0b6-69a0-49d2-87e4-78c93e9090f4): There are no data parts
315 2024.09.12 19:21:44.576459 [ 3 ] {b8cfabb4-1deb-4c0d-9d84-0fc37f491d4d} <Debug> DynamicQueryHandler: Done processing query
316 2024.09.12 19:21:44.576489 [ 3 ] {} <Debug> HTTP-Session: 6c50a777-baf4-49a5-b282-57a2410cec3a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
317 2024.09.12 19:21:44.584576 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
318 2024.09.12 19:21:44.584664 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
319 2024.09.12 19:21:44.584690 [ 3 ] {} <Debug> HTTP-Session: 7c73305e-2c57-4e14-84bb-2ac16eabb180 Authenticating user 'default' from [::1]:40717
320 2024.09.12 19:21:44.584727 [ 3 ] {} <Debug> HTTP-Session: 7c73305e-2c57-4e14-84bb-2ac16eabb180 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
321 2024.09.12 19:21:44.584739 [ 3 ] {} <Debug> HTTP-Session: 7c73305e-2c57-4e14-84bb-2ac16eabb180 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
322 2024.09.12 19:21:44.584783 [ 3 ] {} <Trace> HTTP-Session: 7c73305e-2c57-4e14-84bb-2ac16eabb180 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
323 2024.09.12 19:21:44.585150 [ 3 ] {c6b8c7c9-2fa4-4170-a92c-8f1351bdc00e} <Debug> executeQuery: (from [::1]:40717) 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)
324 2024.09.12 19:21:44.585235 [ 3 ] {c6b8c7c9-2fa4-4170-a92c-8f1351bdc00e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
325 2024.09.12 19:21:44.587441 [ 3 ] {c6b8c7c9-2fa4-4170-a92c-8f1351bdc00e} <Debug> oximeter.measurements_u32 (5aae8531-7d23-4cbe-93ff-7e88612f904a): Loading data parts
326 2024.09.12 19:21:44.587886 [ 3 ] {c6b8c7c9-2fa4-4170-a92c-8f1351bdc00e} <Debug> oximeter.measurements_u32 (5aae8531-7d23-4cbe-93ff-7e88612f904a): There are no data parts
327 2024.09.12 19:21:44.590043 [ 3 ] {c6b8c7c9-2fa4-4170-a92c-8f1351bdc00e} <Debug> DynamicQueryHandler: Done processing query
328 2024.09.12 19:21:44.590088 [ 3 ] {} <Debug> HTTP-Session: 7c73305e-2c57-4e14-84bb-2ac16eabb180 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
329 2024.09.12 19:21:44.681278 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
330 2024.09.12 19:21:44.681731 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
331 2024.09.12 19:21:44.681793 [ 3 ] {} <Debug> HTTP-Session: fee4300f-c039-4000-965d-8ebd69651c68 Authenticating user 'default' from [::1]:40717
332 2024.09.12 19:21:44.682024 [ 3 ] {} <Debug> HTTP-Session: fee4300f-c039-4000-965d-8ebd69651c68 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
333 2024.09.12 19:21:44.683381 [ 3 ] {} <Debug> HTTP-Session: fee4300f-c039-4000-965d-8ebd69651c68 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
334 2024.09.12 19:21:44.683626 [ 3 ] {} <Trace> HTTP-Session: fee4300f-c039-4000-965d-8ebd69651c68 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
335 2024.09.12 19:21:44.684093 [ 3 ] {d5a57315-7cf5-4f00-8a05-20c06e560365} <Debug> executeQuery: (from [::1]:40717) 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)
336 2024.09.12 19:21:44.684224 [ 3 ] {d5a57315-7cf5-4f00-8a05-20c06e560365} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
337 2024.09.12 19:21:44.692226 [ 3 ] {d5a57315-7cf5-4f00-8a05-20c06e560365} <Debug> oximeter.measurements_i64 (b78297e3-bbe0-43a4-92d0-d66b1626cc40): Loading data parts
338 2024.09.12 19:21:44.694090 [ 3 ] {d5a57315-7cf5-4f00-8a05-20c06e560365} <Debug> oximeter.measurements_i64 (b78297e3-bbe0-43a4-92d0-d66b1626cc40): There are no data parts
339 2024.09.12 19:21:44.696135 [ 3 ] {d5a57315-7cf5-4f00-8a05-20c06e560365} <Debug> DynamicQueryHandler: Done processing query
340 2024.09.12 19:21:44.696171 [ 3 ] {} <Debug> HTTP-Session: fee4300f-c039-4000-965d-8ebd69651c68 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
341 2024.09.12 19:21:44.703022 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
342 2024.09.12 19:21:44.703180 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
343 2024.09.12 19:21:44.703215 [ 3 ] {} <Debug> HTTP-Session: aad2bbf9-297d-4f86-ac47-96f4ec63e991 Authenticating user 'default' from [::1]:40717
344 2024.09.12 19:21:44.703243 [ 3 ] {} <Debug> HTTP-Session: aad2bbf9-297d-4f86-ac47-96f4ec63e991 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
345 2024.09.12 19:21:44.703265 [ 3 ] {} <Debug> HTTP-Session: aad2bbf9-297d-4f86-ac47-96f4ec63e991 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
346 2024.09.12 19:21:44.703318 [ 3 ] {} <Trace> HTTP-Session: aad2bbf9-297d-4f86-ac47-96f4ec63e991 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
347 2024.09.12 19:21:44.703728 [ 3 ] {25d73d15-484f-4920-9fa6-07ae2a1526f7} <Debug> executeQuery: (from [::1]:40717) 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)
348 2024.09.12 19:21:44.703817 [ 3 ] {25d73d15-484f-4920-9fa6-07ae2a1526f7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
349 2024.09.12 19:21:44.705959 [ 3 ] {25d73d15-484f-4920-9fa6-07ae2a1526f7} <Debug> oximeter.measurements_u64 (d71755be-31a1-49a2-b190-c7e344a704e7): Loading data parts
350 2024.09.12 19:21:44.706429 [ 3 ] {25d73d15-484f-4920-9fa6-07ae2a1526f7} <Debug> oximeter.measurements_u64 (d71755be-31a1-49a2-b190-c7e344a704e7): There are no data parts
351 2024.09.12 19:21:44.707907 [ 3 ] {25d73d15-484f-4920-9fa6-07ae2a1526f7} <Debug> DynamicQueryHandler: Done processing query
352 2024.09.12 19:21:44.707936 [ 3 ] {} <Debug> HTTP-Session: aad2bbf9-297d-4f86-ac47-96f4ec63e991 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
353 2024.09.12 19:21:44.736843 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
354 2024.09.12 19:21:44.737091 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
355 2024.09.12 19:21:44.737149 [ 3 ] {} <Debug> HTTP-Session: c247f91b-3a61-4559-8bb9-e178857f049f Authenticating user 'default' from [::1]:40717
356 2024.09.12 19:21:44.737338 [ 3 ] {} <Debug> HTTP-Session: c247f91b-3a61-4559-8bb9-e178857f049f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
357 2024.09.12 19:21:44.738053 [ 3 ] {} <Debug> HTTP-Session: c247f91b-3a61-4559-8bb9-e178857f049f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
358 2024.09.12 19:21:44.738145 [ 3 ] {} <Trace> HTTP-Session: c247f91b-3a61-4559-8bb9-e178857f049f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
359 2024.09.12 19:21:44.738715 [ 3 ] {db385c60-3be5-4f4a-8f8e-42e0fcf590d0} <Debug> executeQuery: (from [::1]:40717) 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)
360 2024.09.12 19:21:44.738874 [ 3 ] {db385c60-3be5-4f4a-8f8e-42e0fcf590d0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
361 2024.09.12 19:21:44.741151 [ 3 ] {db385c60-3be5-4f4a-8f8e-42e0fcf590d0} <Debug> oximeter.measurements_f32 (9631e8c2-e375-4edd-b0dd-043cba5571b5): Loading data parts
362 2024.09.12 19:21:44.741697 [ 3 ] {db385c60-3be5-4f4a-8f8e-42e0fcf590d0} <Debug> oximeter.measurements_f32 (9631e8c2-e375-4edd-b0dd-043cba5571b5): There are no data parts
363 2024.09.12 19:21:44.744043 [ 3 ] {db385c60-3be5-4f4a-8f8e-42e0fcf590d0} <Debug> DynamicQueryHandler: Done processing query
364 2024.09.12 19:21:44.744090 [ 3 ] {} <Debug> HTTP-Session: c247f91b-3a61-4559-8bb9-e178857f049f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
365 2024.09.12 19:21:44.748774 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
366 2024.09.12 19:21:44.748916 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
367 2024.09.12 19:21:44.748988 [ 3 ] {} <Debug> HTTP-Session: fee418b7-0fa2-42f6-9495-449cd720693c Authenticating user 'default' from [::1]:40717
368 2024.09.12 19:21:44.749030 [ 3 ] {} <Debug> HTTP-Session: fee418b7-0fa2-42f6-9495-449cd720693c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
369 2024.09.12 19:21:44.749054 [ 3 ] {} <Debug> HTTP-Session: fee418b7-0fa2-42f6-9495-449cd720693c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
370 2024.09.12 19:21:44.749108 [ 3 ] {} <Trace> HTTP-Session: fee418b7-0fa2-42f6-9495-449cd720693c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
371 2024.09.12 19:21:44.749440 [ 3 ] {6f415d76-c428-4233-aa66-886b386fe36b} <Debug> executeQuery: (from [::1]:40717) 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)
372 2024.09.12 19:21:44.749557 [ 3 ] {6f415d76-c428-4233-aa66-886b386fe36b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
373 2024.09.12 19:21:44.751975 [ 3 ] {6f415d76-c428-4233-aa66-886b386fe36b} <Debug> oximeter.measurements_f64 (6aab60bf-ed74-45f4-b007-69a7d1ce5cdb): Loading data parts
374 2024.09.12 19:21:44.752810 [ 3 ] {6f415d76-c428-4233-aa66-886b386fe36b} <Debug> oximeter.measurements_f64 (6aab60bf-ed74-45f4-b007-69a7d1ce5cdb): There are no data parts
375 2024.09.12 19:21:44.754454 [ 3 ] {6f415d76-c428-4233-aa66-886b386fe36b} <Debug> DynamicQueryHandler: Done processing query
376 2024.09.12 19:21:44.754490 [ 3 ] {} <Debug> HTTP-Session: fee418b7-0fa2-42f6-9495-449cd720693c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
377 2024.09.12 19:21:44.757693 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
378 2024.09.12 19:21:44.758333 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
379 2024.09.12 19:21:44.758397 [ 3 ] {} <Debug> HTTP-Session: d7d89f0b-780a-4c93-9f1f-60f789685c06 Authenticating user 'default' from [::1]:40717
380 2024.09.12 19:21:44.758448 [ 3 ] {} <Debug> HTTP-Session: d7d89f0b-780a-4c93-9f1f-60f789685c06 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
381 2024.09.12 19:21:44.758461 [ 3 ] {} <Debug> HTTP-Session: d7d89f0b-780a-4c93-9f1f-60f789685c06 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
382 2024.09.12 19:21:44.758522 [ 3 ] {} <Trace> HTTP-Session: d7d89f0b-780a-4c93-9f1f-60f789685c06 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
383 2024.09.12 19:21:44.758980 [ 3 ] {a2a70d2f-2049-4335-87bd-0c6af6f56e68} <Debug> executeQuery: (from [::1]:40717) 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)
384 2024.09.12 19:21:44.759195 [ 3 ] {a2a70d2f-2049-4335-87bd-0c6af6f56e68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
385 2024.09.12 19:21:44.761854 [ 3 ] {a2a70d2f-2049-4335-87bd-0c6af6f56e68} <Debug> oximeter.measurements_string (8739d922-13e5-4bc2-9f40-8b02fdcc27b8): Loading data parts
386 2024.09.12 19:21:44.762384 [ 3 ] {a2a70d2f-2049-4335-87bd-0c6af6f56e68} <Debug> oximeter.measurements_string (8739d922-13e5-4bc2-9f40-8b02fdcc27b8): There are no data parts
387 2024.09.12 19:21:44.764235 [ 3 ] {a2a70d2f-2049-4335-87bd-0c6af6f56e68} <Debug> DynamicQueryHandler: Done processing query
388 2024.09.12 19:21:44.764392 [ 3 ] {} <Debug> HTTP-Session: d7d89f0b-780a-4c93-9f1f-60f789685c06 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
389 2024.09.12 19:21:44.769643 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
390 2024.09.12 19:21:44.769761 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
391 2024.09.12 19:21:44.769786 [ 3 ] {} <Debug> HTTP-Session: 93f16530-6a14-4b4b-8ebc-342b5a86ccf9 Authenticating user 'default' from [::1]:40717
392 2024.09.12 19:21:44.769813 [ 3 ] {} <Debug> HTTP-Session: 93f16530-6a14-4b4b-8ebc-342b5a86ccf9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
393 2024.09.12 19:21:44.769825 [ 3 ] {} <Debug> HTTP-Session: 93f16530-6a14-4b4b-8ebc-342b5a86ccf9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
394 2024.09.12 19:21:44.769885 [ 3 ] {} <Trace> HTTP-Session: 93f16530-6a14-4b4b-8ebc-342b5a86ccf9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
395 2024.09.12 19:21:44.770214 [ 3 ] {e327c559-8cce-4c76-955f-cb2f55d66ee7} <Debug> executeQuery: (from [::1]:40717) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /*
396 * NOTE: Right now we can't unambiguously record a nullable byte array.
397 * Arrays cannot be nested in `Nullable()` types, and encoding the array as
398 * a string isn't palatable for a few reasons.
399 * See: https://github.com/oxidecomputer/omicron/issues/4551 for more
400 * details.
401 */
402 datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
403 2024.09.12 19:21:44.770301 [ 3 ] {e327c559-8cce-4c76-955f-cb2f55d66ee7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
404 2024.09.12 19:21:44.772548 [ 3 ] {e327c559-8cce-4c76-955f-cb2f55d66ee7} <Debug> oximeter.measurements_bytes (03210516-f83b-40f4-bb45-195d080d56ee): Loading data parts
405 2024.09.12 19:21:44.773171 [ 3 ] {e327c559-8cce-4c76-955f-cb2f55d66ee7} <Debug> oximeter.measurements_bytes (03210516-f83b-40f4-bb45-195d080d56ee): There are no data parts
406 2024.09.12 19:21:44.774718 [ 3 ] {e327c559-8cce-4c76-955f-cb2f55d66ee7} <Debug> DynamicQueryHandler: Done processing query
407 2024.09.12 19:21:44.774746 [ 3 ] {} <Debug> HTTP-Session: 93f16530-6a14-4b4b-8ebc-342b5a86ccf9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
408 2024.09.12 19:21:44.779061 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
409 2024.09.12 19:21:44.779209 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
410 2024.09.12 19:21:44.779240 [ 3 ] {} <Debug> HTTP-Session: f178acc1-1e04-4151-8a02-a5452ae49929 Authenticating user 'default' from [::1]:40717
411 2024.09.12 19:21:44.779267 [ 3 ] {} <Debug> HTTP-Session: f178acc1-1e04-4151-8a02-a5452ae49929 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
412 2024.09.12 19:21:44.779279 [ 3 ] {} <Debug> HTTP-Session: f178acc1-1e04-4151-8a02-a5452ae49929 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
413 2024.09.12 19:21:44.779348 [ 3 ] {} <Trace> HTTP-Session: f178acc1-1e04-4151-8a02-a5452ae49929 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
414 2024.09.12 19:21:44.779719 [ 3 ] {98ea3278-60bc-4412-95ee-f097c38922aa} <Debug> executeQuery: (from [::1]:40717) 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)
415 2024.09.12 19:21:44.779807 [ 3 ] {98ea3278-60bc-4412-95ee-f097c38922aa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
416 2024.09.12 19:21:44.781960 [ 3 ] {98ea3278-60bc-4412-95ee-f097c38922aa} <Debug> oximeter.measurements_cumulativei64 (66af2c31-2fb4-4abf-b1e8-a1e2478d0a66): Loading data parts
417 2024.09.12 19:21:44.782542 [ 3 ] {98ea3278-60bc-4412-95ee-f097c38922aa} <Debug> oximeter.measurements_cumulativei64 (66af2c31-2fb4-4abf-b1e8-a1e2478d0a66): There are no data parts
418 2024.09.12 19:21:44.792967 [ 3 ] {98ea3278-60bc-4412-95ee-f097c38922aa} <Debug> DynamicQueryHandler: Done processing query
419 2024.09.12 19:21:44.793108 [ 3 ] {} <Debug> HTTP-Session: f178acc1-1e04-4151-8a02-a5452ae49929 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
420 2024.09.12 19:21:44.800919 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
421 2024.09.12 19:21:44.801049 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
422 2024.09.12 19:21:44.801076 [ 3 ] {} <Debug> HTTP-Session: bd5d8e8d-2bba-4b6f-9861-770a553334cb Authenticating user 'default' from [::1]:40717
423 2024.09.12 19:21:44.801148 [ 3 ] {} <Debug> HTTP-Session: bd5d8e8d-2bba-4b6f-9861-770a553334cb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
424 2024.09.12 19:21:44.801165 [ 3 ] {} <Debug> HTTP-Session: bd5d8e8d-2bba-4b6f-9861-770a553334cb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
425 2024.09.12 19:21:44.801223 [ 3 ] {} <Trace> HTTP-Session: bd5d8e8d-2bba-4b6f-9861-770a553334cb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
426 2024.09.12 19:21:44.801604 [ 3 ] {65b8143a-afc5-42ab-b8f0-a11d64f4612d} <Debug> executeQuery: (from [::1]:40717) 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)
427 2024.09.12 19:21:44.801764 [ 3 ] {65b8143a-afc5-42ab-b8f0-a11d64f4612d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
428 2024.09.12 19:21:44.803972 [ 3 ] {65b8143a-afc5-42ab-b8f0-a11d64f4612d} <Debug> oximeter.measurements_cumulativeu64 (814f1053-e499-478b-acef-8aaafb8e381a): Loading data parts
429 2024.09.12 19:21:44.804291 [ 3 ] {65b8143a-afc5-42ab-b8f0-a11d64f4612d} <Debug> oximeter.measurements_cumulativeu64 (814f1053-e499-478b-acef-8aaafb8e381a): There are no data parts
430 2024.09.12 19:21:44.806088 [ 3 ] {65b8143a-afc5-42ab-b8f0-a11d64f4612d} <Debug> DynamicQueryHandler: Done processing query
431 2024.09.12 19:21:44.806118 [ 3 ] {} <Debug> HTTP-Session: bd5d8e8d-2bba-4b6f-9861-770a553334cb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
432 2024.09.12 19:21:44.809292 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
433 2024.09.12 19:21:44.809384 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
434 2024.09.12 19:21:44.809406 [ 3 ] {} <Debug> HTTP-Session: f3a67975-603d-4f37-a4de-04f21eff4b65 Authenticating user 'default' from [::1]:40717
435 2024.09.12 19:21:44.809428 [ 3 ] {} <Debug> HTTP-Session: f3a67975-603d-4f37-a4de-04f21eff4b65 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
436 2024.09.12 19:21:44.809494 [ 3 ] {} <Debug> HTTP-Session: f3a67975-603d-4f37-a4de-04f21eff4b65 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
437 2024.09.12 19:21:44.810268 [ 3 ] {} <Trace> HTTP-Session: f3a67975-603d-4f37-a4de-04f21eff4b65 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
438 2024.09.12 19:21:44.811519 [ 3 ] {5193aefa-942c-46f8-b1b7-a7665899a1c2} <Debug> executeQuery: (from [::1]:40717) 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)
439 2024.09.12 19:21:44.812548 [ 3 ] {5193aefa-942c-46f8-b1b7-a7665899a1c2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
440 2024.09.12 19:21:44.814382 [ 3 ] {5193aefa-942c-46f8-b1b7-a7665899a1c2} <Debug> oximeter.measurements_cumulativef32 (96e46302-d4d2-4a18-b67e-4b7de198f2cb): Loading data parts
441 2024.09.12 19:21:44.814772 [ 3 ] {5193aefa-942c-46f8-b1b7-a7665899a1c2} <Debug> oximeter.measurements_cumulativef32 (96e46302-d4d2-4a18-b67e-4b7de198f2cb): There are no data parts
442 2024.09.12 19:21:44.816378 [ 3 ] {5193aefa-942c-46f8-b1b7-a7665899a1c2} <Debug> DynamicQueryHandler: Done processing query
443 2024.09.12 19:21:44.816434 [ 3 ] {} <Debug> HTTP-Session: f3a67975-603d-4f37-a4de-04f21eff4b65 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
444 2024.09.12 19:21:44.821570 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
445 2024.09.12 19:21:44.821707 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
446 2024.09.12 19:21:44.821758 [ 3 ] {} <Debug> HTTP-Session: 01d7a395-d163-4a02-acc9-aa4e0c093582 Authenticating user 'default' from [::1]:40717
447 2024.09.12 19:21:44.821788 [ 3 ] {} <Debug> HTTP-Session: 01d7a395-d163-4a02-acc9-aa4e0c093582 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
448 2024.09.12 19:21:44.821800 [ 3 ] {} <Debug> HTTP-Session: 01d7a395-d163-4a02-acc9-aa4e0c093582 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
449 2024.09.12 19:21:44.821867 [ 3 ] {} <Trace> HTTP-Session: 01d7a395-d163-4a02-acc9-aa4e0c093582 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
450 2024.09.12 19:21:44.822469 [ 3 ] {a3f13573-12d3-4025-a6dd-934231120fc7} <Debug> executeQuery: (from [::1]:40717) 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)
451 2024.09.12 19:21:44.822701 [ 3 ] {a3f13573-12d3-4025-a6dd-934231120fc7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
452 2024.09.12 19:21:44.827153 [ 3 ] {a3f13573-12d3-4025-a6dd-934231120fc7} <Debug> oximeter.measurements_cumulativef64 (1851662e-624b-458b-808e-02bc7533efb6): Loading data parts
453 2024.09.12 19:21:44.827588 [ 3 ] {a3f13573-12d3-4025-a6dd-934231120fc7} <Debug> oximeter.measurements_cumulativef64 (1851662e-624b-458b-808e-02bc7533efb6): There are no data parts
454 2024.09.12 19:21:44.829973 [ 3 ] {a3f13573-12d3-4025-a6dd-934231120fc7} <Debug> DynamicQueryHandler: Done processing query
455 2024.09.12 19:21:44.830024 [ 3 ] {} <Debug> HTTP-Session: 01d7a395-d163-4a02-acc9-aa4e0c093582 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
456 2024.09.12 19:21:44.832134 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
457 2024.09.12 19:21:44.832242 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
458 2024.09.12 19:21:44.832269 [ 3 ] {} <Debug> HTTP-Session: a5786a1e-2375-4a26-992d-ba3bcc477e3a Authenticating user 'default' from [::1]:40717
459 2024.09.12 19:21:44.832364 [ 3 ] {} <Debug> HTTP-Session: a5786a1e-2375-4a26-992d-ba3bcc477e3a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
460 2024.09.12 19:21:44.832389 [ 3 ] {} <Debug> HTTP-Session: a5786a1e-2375-4a26-992d-ba3bcc477e3a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
461 2024.09.12 19:21:44.832446 [ 3 ] {} <Trace> HTTP-Session: a5786a1e-2375-4a26-992d-ba3bcc477e3a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
462 2024.09.12 19:21:44.832886 [ 3 ] {643f2037-4e1b-41d3-85ef-8c032a72261e} <Debug> executeQuery: (from [::1]:40717) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /*
463 * NOTE: Array types cannot be Nullable, see
464 * https://clickhouse.com/docs/en/sql-reference/data-types/nullable
465 * for more details.
466 *
467 * This means we need to use empty arrays to indicate a missing value. This
468 * is unfortunate, and at this point relies on the fact that an
469 * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need
470 * to figure out another way to represent missing samples here.
471 */
472 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)
473 2024.09.12 19:21:44.832986 [ 3 ] {643f2037-4e1b-41d3-85ef-8c032a72261e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
474 2024.09.12 19:21:44.837769 [ 3 ] {643f2037-4e1b-41d3-85ef-8c032a72261e} <Debug> oximeter.measurements_histogrami8 (125bccef-cd65-46ea-a872-70c7fe8cc36b): Loading data parts
475 2024.09.12 19:21:44.838417 [ 3 ] {643f2037-4e1b-41d3-85ef-8c032a72261e} <Debug> oximeter.measurements_histogrami8 (125bccef-cd65-46ea-a872-70c7fe8cc36b): There are no data parts
476 2024.09.12 19:21:44.840971 [ 3 ] {643f2037-4e1b-41d3-85ef-8c032a72261e} <Debug> DynamicQueryHandler: Done processing query
477 2024.09.12 19:21:44.841069 [ 3 ] {} <Debug> HTTP-Session: a5786a1e-2375-4a26-992d-ba3bcc477e3a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
478 2024.09.12 19:21:44.844572 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
479 2024.09.12 19:21:44.845068 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
480 2024.09.12 19:21:44.845246 [ 3 ] {} <Debug> HTTP-Session: c16d378f-a941-40af-81df-50a5a2217542 Authenticating user 'default' from [::1]:40717
481 2024.09.12 19:21:44.845337 [ 3 ] {} <Debug> HTTP-Session: c16d378f-a941-40af-81df-50a5a2217542 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
482 2024.09.12 19:21:44.845366 [ 3 ] {} <Debug> HTTP-Session: c16d378f-a941-40af-81df-50a5a2217542 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
483 2024.09.12 19:21:44.845477 [ 3 ] {} <Trace> HTTP-Session: c16d378f-a941-40af-81df-50a5a2217542 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
484 2024.09.12 19:21:44.846449 [ 3 ] {21038844-ea95-4943-8428-d67c20cc2954} <Debug> executeQuery: (from [::1]:40717) 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)
485 2024.09.12 19:21:44.846605 [ 3 ] {21038844-ea95-4943-8428-d67c20cc2954} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
486 2024.09.12 19:21:44.849667 [ 3 ] {21038844-ea95-4943-8428-d67c20cc2954} <Debug> oximeter.measurements_histogramu8 (f86365b1-832d-457b-a447-5be844ed050d): Loading data parts
487 2024.09.12 19:21:44.849966 [ 3 ] {21038844-ea95-4943-8428-d67c20cc2954} <Debug> oximeter.measurements_histogramu8 (f86365b1-832d-457b-a447-5be844ed050d): There are no data parts
488 2024.09.12 19:21:44.852355 [ 3 ] {21038844-ea95-4943-8428-d67c20cc2954} <Debug> DynamicQueryHandler: Done processing query
489 2024.09.12 19:21:44.852391 [ 3 ] {} <Debug> HTTP-Session: c16d378f-a941-40af-81df-50a5a2217542 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
490 2024.09.12 19:21:44.854521 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
491 2024.09.12 19:21:44.854635 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
492 2024.09.12 19:21:44.854662 [ 3 ] {} <Debug> HTTP-Session: e6197ea5-260c-48c2-8aba-d025e9ea0ff3 Authenticating user 'default' from [::1]:40717
493 2024.09.12 19:21:44.854690 [ 3 ] {} <Debug> HTTP-Session: e6197ea5-260c-48c2-8aba-d025e9ea0ff3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
494 2024.09.12 19:21:44.854710 [ 3 ] {} <Debug> HTTP-Session: e6197ea5-260c-48c2-8aba-d025e9ea0ff3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
495 2024.09.12 19:21:44.855154 [ 3 ] {} <Trace> HTTP-Session: e6197ea5-260c-48c2-8aba-d025e9ea0ff3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
496 2024.09.12 19:21:44.856007 [ 3 ] {40e196e2-0824-4642-919e-99d89e12c33c} <Debug> executeQuery: (from [::1]:40717) 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)
497 2024.09.12 19:21:44.856114 [ 3 ] {40e196e2-0824-4642-919e-99d89e12c33c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
498 2024.09.12 19:21:44.859729 [ 3 ] {40e196e2-0824-4642-919e-99d89e12c33c} <Debug> oximeter.measurements_histogrami16 (e8a4618f-1f2c-4e4d-837e-3a93c31697b8): Loading data parts
499 2024.09.12 19:21:44.860100 [ 3 ] {40e196e2-0824-4642-919e-99d89e12c33c} <Debug> oximeter.measurements_histogrami16 (e8a4618f-1f2c-4e4d-837e-3a93c31697b8): There are no data parts
500 2024.09.12 19:21:44.861980 [ 3 ] {40e196e2-0824-4642-919e-99d89e12c33c} <Debug> DynamicQueryHandler: Done processing query
501 2024.09.12 19:21:44.862010 [ 3 ] {} <Debug> HTTP-Session: e6197ea5-260c-48c2-8aba-d025e9ea0ff3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
502 2024.09.12 19:21:44.863933 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
503 2024.09.12 19:21:44.864164 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
504 2024.09.12 19:21:44.864204 [ 3 ] {} <Debug> HTTP-Session: 3eec74f5-f357-43e7-a401-347e59c1bd23 Authenticating user 'default' from [::1]:40717
505 2024.09.12 19:21:44.864260 [ 3 ] {} <Debug> HTTP-Session: 3eec74f5-f357-43e7-a401-347e59c1bd23 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
506 2024.09.12 19:21:44.864275 [ 3 ] {} <Debug> HTTP-Session: 3eec74f5-f357-43e7-a401-347e59c1bd23 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
507 2024.09.12 19:21:44.864337 [ 3 ] {} <Trace> HTTP-Session: 3eec74f5-f357-43e7-a401-347e59c1bd23 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
508 2024.09.12 19:21:44.864895 [ 3 ] {ba97a496-0c65-4047-b23a-5ec08b36aa84} <Debug> executeQuery: (from [::1]:40717) 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)
509 2024.09.12 19:21:44.865017 [ 3 ] {ba97a496-0c65-4047-b23a-5ec08b36aa84} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
510 2024.09.12 19:21:44.868065 [ 3 ] {ba97a496-0c65-4047-b23a-5ec08b36aa84} <Debug> oximeter.measurements_histogramu16 (524c4aca-bfa3-4196-bd55-ab611189202a): Loading data parts
511 2024.09.12 19:21:44.868773 [ 3 ] {ba97a496-0c65-4047-b23a-5ec08b36aa84} <Debug> oximeter.measurements_histogramu16 (524c4aca-bfa3-4196-bd55-ab611189202a): There are no data parts
512 2024.09.12 19:21:44.870967 [ 3 ] {ba97a496-0c65-4047-b23a-5ec08b36aa84} <Debug> DynamicQueryHandler: Done processing query
513 2024.09.12 19:21:44.871026 [ 3 ] {} <Debug> HTTP-Session: 3eec74f5-f357-43e7-a401-347e59c1bd23 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
514 2024.09.12 19:21:44.875301 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
515 2024.09.12 19:21:44.875425 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
516 2024.09.12 19:21:44.875454 [ 3 ] {} <Debug> HTTP-Session: 03a31b52-309a-43cd-81c2-ef209689effc Authenticating user 'default' from [::1]:40717
517 2024.09.12 19:21:44.875481 [ 3 ] {} <Debug> HTTP-Session: 03a31b52-309a-43cd-81c2-ef209689effc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
518 2024.09.12 19:21:44.875493 [ 3 ] {} <Debug> HTTP-Session: 03a31b52-309a-43cd-81c2-ef209689effc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
519 2024.09.12 19:21:44.875558 [ 3 ] {} <Trace> HTTP-Session: 03a31b52-309a-43cd-81c2-ef209689effc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
520 2024.09.12 19:21:44.876160 [ 3 ] {3f5bac05-b2d0-4c6c-a408-df34d252a066} <Debug> executeQuery: (from [::1]:40717) 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)
521 2024.09.12 19:21:44.876395 [ 3 ] {3f5bac05-b2d0-4c6c-a408-df34d252a066} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
522 2024.09.12 19:21:44.879912 [ 3 ] {3f5bac05-b2d0-4c6c-a408-df34d252a066} <Debug> oximeter.measurements_histogrami32 (5c096a6a-2142-48fe-b10f-7a9d33322392): Loading data parts
523 2024.09.12 19:21:44.880991 [ 3 ] {3f5bac05-b2d0-4c6c-a408-df34d252a066} <Debug> oximeter.measurements_histogrami32 (5c096a6a-2142-48fe-b10f-7a9d33322392): There are no data parts
524 2024.09.12 19:21:44.884621 [ 3 ] {3f5bac05-b2d0-4c6c-a408-df34d252a066} <Debug> DynamicQueryHandler: Done processing query
525 2024.09.12 19:21:44.884679 [ 3 ] {} <Debug> HTTP-Session: 03a31b52-309a-43cd-81c2-ef209689effc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
526 2024.09.12 19:21:44.887839 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
527 2024.09.12 19:21:44.887969 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
528 2024.09.12 19:21:44.887996 [ 3 ] {} <Debug> HTTP-Session: 12ad9e4b-7b7b-4244-a7d4-626cff3d4954 Authenticating user 'default' from [::1]:40717
529 2024.09.12 19:21:44.888258 [ 3 ] {} <Debug> HTTP-Session: 12ad9e4b-7b7b-4244-a7d4-626cff3d4954 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
530 2024.09.12 19:21:44.888312 [ 3 ] {} <Debug> HTTP-Session: 12ad9e4b-7b7b-4244-a7d4-626cff3d4954 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
531 2024.09.12 19:21:44.888383 [ 3 ] {} <Trace> HTTP-Session: 12ad9e4b-7b7b-4244-a7d4-626cff3d4954 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
532 2024.09.12 19:21:44.889347 [ 3 ] {0a86a8b9-c2e1-40d3-9c19-65dd25ffefc0} <Debug> executeQuery: (from [::1]:40717) 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)
533 2024.09.12 19:21:44.889501 [ 3 ] {0a86a8b9-c2e1-40d3-9c19-65dd25ffefc0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
534 2024.09.12 19:21:44.893351 [ 3 ] {0a86a8b9-c2e1-40d3-9c19-65dd25ffefc0} <Debug> oximeter.measurements_histogramu32 (0c595a3c-64fc-42a8-8362-7916e92f6d63): Loading data parts
535 2024.09.12 19:21:44.896345 [ 3 ] {0a86a8b9-c2e1-40d3-9c19-65dd25ffefc0} <Debug> oximeter.measurements_histogramu32 (0c595a3c-64fc-42a8-8362-7916e92f6d63): There are no data parts
536 2024.09.12 19:21:44.899480 [ 3 ] {0a86a8b9-c2e1-40d3-9c19-65dd25ffefc0} <Debug> DynamicQueryHandler: Done processing query
537 2024.09.12 19:21:44.899543 [ 3 ] {} <Debug> HTTP-Session: 12ad9e4b-7b7b-4244-a7d4-626cff3d4954 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
538 2024.09.12 19:21:44.902372 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
539 2024.09.12 19:21:44.902511 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
540 2024.09.12 19:21:44.902774 [ 3 ] {} <Debug> HTTP-Session: 34ed6e93-eab5-4c31-9182-594a9dd51efc Authenticating user 'default' from [::1]:40717
541 2024.09.12 19:21:44.902939 [ 3 ] {} <Debug> HTTP-Session: 34ed6e93-eab5-4c31-9182-594a9dd51efc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
542 2024.09.12 19:21:44.902968 [ 3 ] {} <Debug> HTTP-Session: 34ed6e93-eab5-4c31-9182-594a9dd51efc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
543 2024.09.12 19:21:44.903102 [ 3 ] {} <Trace> HTTP-Session: 34ed6e93-eab5-4c31-9182-594a9dd51efc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
544 2024.09.12 19:21:44.903877 [ 3 ] {a4c973a7-d1a3-465d-b999-a9839c7304e9} <Debug> executeQuery: (from [::1]:40717) 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)
545 2024.09.12 19:21:44.903995 [ 3 ] {a4c973a7-d1a3-465d-b999-a9839c7304e9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
546 2024.09.12 19:21:44.907655 [ 3 ] {a4c973a7-d1a3-465d-b999-a9839c7304e9} <Debug> oximeter.measurements_histogrami64 (22539add-96c0-40ce-8a76-966c65a0ad1c): Loading data parts
547 2024.09.12 19:21:44.908420 [ 3 ] {a4c973a7-d1a3-465d-b999-a9839c7304e9} <Debug> oximeter.measurements_histogrami64 (22539add-96c0-40ce-8a76-966c65a0ad1c): There are no data parts
548 2024.09.12 19:21:44.911020 [ 3 ] {a4c973a7-d1a3-465d-b999-a9839c7304e9} <Debug> DynamicQueryHandler: Done processing query
549 2024.09.12 19:21:44.911072 [ 3 ] {} <Debug> HTTP-Session: 34ed6e93-eab5-4c31-9182-594a9dd51efc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
550 2024.09.12 19:21:44.915921 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
551 2024.09.12 19:21:44.916091 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
552 2024.09.12 19:21:44.916119 [ 3 ] {} <Debug> HTTP-Session: 89b29627-b549-4d3a-b0a7-07febbc4d2aa Authenticating user 'default' from [::1]:40717
553 2024.09.12 19:21:44.916147 [ 3 ] {} <Debug> HTTP-Session: 89b29627-b549-4d3a-b0a7-07febbc4d2aa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
554 2024.09.12 19:21:44.916172 [ 3 ] {} <Debug> HTTP-Session: 89b29627-b549-4d3a-b0a7-07febbc4d2aa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
555 2024.09.12 19:21:44.916230 [ 3 ] {} <Trace> HTTP-Session: 89b29627-b549-4d3a-b0a7-07febbc4d2aa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
556 2024.09.12 19:21:44.916680 [ 3 ] {2fa0c016-a40c-4b2f-b438-884ed6466441} <Debug> executeQuery: (from [::1]:40717) 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)
557 2024.09.12 19:21:44.916826 [ 3 ] {2fa0c016-a40c-4b2f-b438-884ed6466441} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
558 2024.09.12 19:21:44.922555 [ 3 ] {2fa0c016-a40c-4b2f-b438-884ed6466441} <Debug> oximeter.measurements_histogramu64 (96af0102-3ce1-411c-a1ee-dcc991830035): Loading data parts
559 2024.09.12 19:21:44.923847 [ 3 ] {2fa0c016-a40c-4b2f-b438-884ed6466441} <Debug> oximeter.measurements_histogramu64 (96af0102-3ce1-411c-a1ee-dcc991830035): There are no data parts
560 2024.09.12 19:21:44.926594 [ 3 ] {2fa0c016-a40c-4b2f-b438-884ed6466441} <Debug> DynamicQueryHandler: Done processing query
561 2024.09.12 19:21:44.926669 [ 3 ] {} <Debug> HTTP-Session: 89b29627-b549-4d3a-b0a7-07febbc4d2aa Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
562 2024.09.12 19:21:44.928327 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
563 2024.09.12 19:21:44.928486 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
564 2024.09.12 19:21:44.928544 [ 3 ] {} <Debug> HTTP-Session: 307c07bf-0e0a-4e46-a40a-71bbdd126254 Authenticating user 'default' from [::1]:40717
565 2024.09.12 19:21:44.928574 [ 3 ] {} <Debug> HTTP-Session: 307c07bf-0e0a-4e46-a40a-71bbdd126254 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
566 2024.09.12 19:21:44.928586 [ 3 ] {} <Debug> HTTP-Session: 307c07bf-0e0a-4e46-a40a-71bbdd126254 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
567 2024.09.12 19:21:44.928651 [ 3 ] {} <Trace> HTTP-Session: 307c07bf-0e0a-4e46-a40a-71bbdd126254 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
568 2024.09.12 19:21:44.929191 [ 3 ] {74482cdc-3605-4967-a674-69a2d7271f5a} <Debug> executeQuery: (from [::1]:40717) 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)
569 2024.09.12 19:21:44.929326 [ 3 ] {74482cdc-3605-4967-a674-69a2d7271f5a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
570 2024.09.12 19:21:44.932747 [ 3 ] {74482cdc-3605-4967-a674-69a2d7271f5a} <Debug> oximeter.measurements_histogramf32 (62f9c6a8-cc67-48ef-9701-cad05d07191c): Loading data parts
571 2024.09.12 19:21:44.933268 [ 3 ] {74482cdc-3605-4967-a674-69a2d7271f5a} <Debug> oximeter.measurements_histogramf32 (62f9c6a8-cc67-48ef-9701-cad05d07191c): There are no data parts
572 2024.09.12 19:21:44.936711 [ 3 ] {74482cdc-3605-4967-a674-69a2d7271f5a} <Debug> DynamicQueryHandler: Done processing query
573 2024.09.12 19:21:44.936960 [ 3 ] {} <Debug> HTTP-Session: 307c07bf-0e0a-4e46-a40a-71bbdd126254 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
574 2024.09.12 19:21:44.949923 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
575 2024.09.12 19:21:44.950100 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
576 2024.09.12 19:21:44.950170 [ 3 ] {} <Debug> HTTP-Session: 4edcf328-270f-43b1-8ddf-34aec7e2c1bb Authenticating user 'default' from [::1]:40717
577 2024.09.12 19:21:44.950213 [ 3 ] {} <Debug> HTTP-Session: 4edcf328-270f-43b1-8ddf-34aec7e2c1bb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
578 2024.09.12 19:21:44.950242 [ 3 ] {} <Debug> HTTP-Session: 4edcf328-270f-43b1-8ddf-34aec7e2c1bb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
579 2024.09.12 19:21:44.950296 [ 3 ] {} <Trace> HTTP-Session: 4edcf328-270f-43b1-8ddf-34aec7e2c1bb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
580 2024.09.12 19:21:44.951397 [ 3 ] {d32df044-29ca-4d3c-ad9e-b760c1028150} <Debug> executeQuery: (from [::1]:40717) 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)
581 2024.09.12 19:21:44.951513 [ 3 ] {d32df044-29ca-4d3c-ad9e-b760c1028150} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
582 2024.09.12 19:21:44.955918 [ 3 ] {d32df044-29ca-4d3c-ad9e-b760c1028150} <Debug> oximeter.measurements_histogramf64 (3c77feaa-c6ed-4f38-aeb0-3da95d74ea27): Loading data parts
583 2024.09.12 19:21:44.956584 [ 3 ] {d32df044-29ca-4d3c-ad9e-b760c1028150} <Debug> oximeter.measurements_histogramf64 (3c77feaa-c6ed-4f38-aeb0-3da95d74ea27): There are no data parts
584 2024.09.12 19:21:44.958347 [ 3 ] {d32df044-29ca-4d3c-ad9e-b760c1028150} <Debug> DynamicQueryHandler: Done processing query
585 2024.09.12 19:21:44.958440 [ 3 ] {} <Debug> HTTP-Session: 4edcf328-270f-43b1-8ddf-34aec7e2c1bb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
586 2024.09.12 19:21:44.987255 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
587 2024.09.12 19:21:44.987486 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
588 2024.09.12 19:21:44.987520 [ 3 ] {} <Debug> HTTP-Session: 89f5af96-2fcb-4f4b-b2ac-c42381930d1d Authenticating user 'default' from [::1]:40717
589 2024.09.12 19:21:44.987591 [ 3 ] {} <Debug> HTTP-Session: 89f5af96-2fcb-4f4b-b2ac-c42381930d1d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
590 2024.09.12 19:21:44.987609 [ 3 ] {} <Debug> HTTP-Session: 89f5af96-2fcb-4f4b-b2ac-c42381930d1d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
591 2024.09.12 19:21:44.987888 [ 3 ] {} <Trace> HTTP-Session: 89f5af96-2fcb-4f4b-b2ac-c42381930d1d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
592 2024.09.12 19:21:44.988442 [ 3 ] {8c2b30ff-e716-4c8d-b20c-0625924ee9d6} <Debug> executeQuery: (from [::1]:40717) /* The field tables store named dimensions of each timeseries.
593 *
594 * As with the measurement tables, there is one field table for each field data
595 * type. Fields are deduplicated by using the "replacing merge tree", though
596 * this behavior **must not** be relied upon for query correctness.
597 *
598 * The index for the fields differs from the measurements, however. Rows are
599 * sorted by timeseries name, then field name, field value, and finally
600 * timeseries key. This reflects the most common pattern for looking them up:
601 * by field name and possibly value, within a timeseries. The resulting keys are
602 * usually then used to look up measurements.
603 *
604 * NOTE: We may want to consider a secondary index on these tables, sorting by
605 * timeseries name and then key, since it would improve lookups where one
606 * already has the key. Realistically though, these tables are quite small and
607 * so performance benefits will be low in absolute terms.
608 *
609 * TTL: We use a materialized column to expire old field table records. This
610 * column is generated automatically by the database whenever a new row is
611 * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *`
612 * query. Since these tables are `ReplacingMergeTree`s, that means the last
613 * record will remain during a deduplication, which will have the last
614 * timestamp. ClickHouse will then expire old data for us, similar to the
615 * measurement tables.
616 */
617 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)
618 2024.09.12 19:21:44.988550 [ 3 ] {8c2b30ff-e716-4c8d-b20c-0625924ee9d6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
619 2024.09.12 19:21:44.995954 [ 3 ] {8c2b30ff-e716-4c8d-b20c-0625924ee9d6} <Debug> oximeter.fields_bool (516b753a-165f-48a1-ba15-0804d2f4f91d): Loading data parts
620 2024.09.12 19:21:44.996749 [ 3 ] {8c2b30ff-e716-4c8d-b20c-0625924ee9d6} <Debug> oximeter.fields_bool (516b753a-165f-48a1-ba15-0804d2f4f91d): There are no data parts
621 2024.09.12 19:21:45.000359 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 143.23 MiB, peak 143.24 MiB, free memory in arenas 0.00 B, will set to 146.41 MiB (RSS), difference: 3.18 MiB
622 2024.09.12 19:21:45.012022 [ 3 ] {8c2b30ff-e716-4c8d-b20c-0625924ee9d6} <Debug> DynamicQueryHandler: Done processing query
623 2024.09.12 19:21:45.012084 [ 3 ] {} <Debug> HTTP-Session: 89f5af96-2fcb-4f4b-b2ac-c42381930d1d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
624 2024.09.12 19:21:45.019846 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
625 2024.09.12 19:21:45.020049 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
626 2024.09.12 19:21:45.020082 [ 3 ] {} <Debug> HTTP-Session: df1d256b-e53a-4282-a23a-bf14b9db8eed Authenticating user 'default' from [::1]:40717
627 2024.09.12 19:21:45.020112 [ 3 ] {} <Debug> HTTP-Session: df1d256b-e53a-4282-a23a-bf14b9db8eed Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
628 2024.09.12 19:21:45.020139 [ 3 ] {} <Debug> HTTP-Session: df1d256b-e53a-4282-a23a-bf14b9db8eed Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
629 2024.09.12 19:21:45.020210 [ 3 ] {} <Trace> HTTP-Session: df1d256b-e53a-4282-a23a-bf14b9db8eed Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
630 2024.09.12 19:21:45.021254 [ 3 ] {f2d12279-e6b9-447f-839b-d4cb2853f6be} <Debug> executeQuery: (from [::1]:40717) 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)
631 2024.09.12 19:21:45.021778 [ 3 ] {f2d12279-e6b9-447f-839b-d4cb2853f6be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
632 2024.09.12 19:21:45.026706 [ 3 ] {f2d12279-e6b9-447f-839b-d4cb2853f6be} <Debug> oximeter.fields_i8 (112a04ea-da37-411d-b6de-f3898edc5971): Loading data parts
633 2024.09.12 19:21:45.029065 [ 3 ] {f2d12279-e6b9-447f-839b-d4cb2853f6be} <Debug> oximeter.fields_i8 (112a04ea-da37-411d-b6de-f3898edc5971): There are no data parts
634 2024.09.12 19:21:45.031922 [ 3 ] {f2d12279-e6b9-447f-839b-d4cb2853f6be} <Debug> DynamicQueryHandler: Done processing query
635 2024.09.12 19:21:45.031963 [ 3 ] {} <Debug> HTTP-Session: df1d256b-e53a-4282-a23a-bf14b9db8eed Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
636 2024.09.12 19:21:45.043964 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
637 2024.09.12 19:21:45.044182 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
638 2024.09.12 19:21:45.044244 [ 3 ] {} <Debug> HTTP-Session: 5b17946b-28a0-4cb4-a759-51be17dcfd05 Authenticating user 'default' from [::1]:40717
639 2024.09.12 19:21:45.044278 [ 3 ] {} <Debug> HTTP-Session: 5b17946b-28a0-4cb4-a759-51be17dcfd05 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
640 2024.09.12 19:21:45.044292 [ 3 ] {} <Debug> HTTP-Session: 5b17946b-28a0-4cb4-a759-51be17dcfd05 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
641 2024.09.12 19:21:45.044362 [ 3 ] {} <Trace> HTTP-Session: 5b17946b-28a0-4cb4-a759-51be17dcfd05 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
642 2024.09.12 19:21:45.044806 [ 3 ] {b9f4ce5a-829e-4f33-b94b-4e3b5c0a9f7a} <Debug> executeQuery: (from [::1]:40717) 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)
643 2024.09.12 19:21:45.044914 [ 3 ] {b9f4ce5a-829e-4f33-b94b-4e3b5c0a9f7a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
644 2024.09.12 19:21:45.050163 [ 3 ] {b9f4ce5a-829e-4f33-b94b-4e3b5c0a9f7a} <Debug> oximeter.fields_u8 (e2d6ff2e-d23f-43d2-989a-50090cb5ca52): Loading data parts
645 2024.09.12 19:21:45.051821 [ 3 ] {b9f4ce5a-829e-4f33-b94b-4e3b5c0a9f7a} <Debug> oximeter.fields_u8 (e2d6ff2e-d23f-43d2-989a-50090cb5ca52): There are no data parts
646 2024.09.12 19:21:45.056582 [ 3 ] {b9f4ce5a-829e-4f33-b94b-4e3b5c0a9f7a} <Debug> DynamicQueryHandler: Done processing query
647 2024.09.12 19:21:45.056638 [ 3 ] {} <Debug> HTTP-Session: 5b17946b-28a0-4cb4-a759-51be17dcfd05 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
648 2024.09.12 19:21:45.181996 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
649 2024.09.12 19:21:45.182584 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
650 2024.09.12 19:21:45.182629 [ 3 ] {} <Debug> HTTP-Session: e69c11ca-9c2c-4ce4-8e2a-085d0ad18b70 Authenticating user 'default' from [::1]:40717
651 2024.09.12 19:21:45.182659 [ 3 ] {} <Debug> HTTP-Session: e69c11ca-9c2c-4ce4-8e2a-085d0ad18b70 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
652 2024.09.12 19:21:45.182690 [ 3 ] {} <Debug> HTTP-Session: e69c11ca-9c2c-4ce4-8e2a-085d0ad18b70 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
653 2024.09.12 19:21:45.182754 [ 3 ] {} <Trace> HTTP-Session: e69c11ca-9c2c-4ce4-8e2a-085d0ad18b70 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
654 2024.09.12 19:21:45.183157 [ 3 ] {f0ccbe40-49d7-4445-94b9-6ad1f443f60e} <Debug> executeQuery: (from [::1]:40717) 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)
655 2024.09.12 19:21:45.183257 [ 3 ] {f0ccbe40-49d7-4445-94b9-6ad1f443f60e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
656 2024.09.12 19:21:45.186240 [ 3 ] {f0ccbe40-49d7-4445-94b9-6ad1f443f60e} <Debug> oximeter.fields_i16 (73a3b676-d478-40df-8782-af336861804e): Loading data parts
657 2024.09.12 19:21:45.187346 [ 3 ] {f0ccbe40-49d7-4445-94b9-6ad1f443f60e} <Debug> oximeter.fields_i16 (73a3b676-d478-40df-8782-af336861804e): There are no data parts
658 2024.09.12 19:21:45.189715 [ 3 ] {f0ccbe40-49d7-4445-94b9-6ad1f443f60e} <Debug> DynamicQueryHandler: Done processing query
659 2024.09.12 19:21:45.189780 [ 3 ] {} <Debug> HTTP-Session: e69c11ca-9c2c-4ce4-8e2a-085d0ad18b70 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
660 2024.09.12 19:21:45.205350 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
661 2024.09.12 19:21:45.205537 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
662 2024.09.12 19:21:45.205569 [ 3 ] {} <Debug> HTTP-Session: 25a339f4-fa80-405b-8b26-44cf01a62d4d Authenticating user 'default' from [::1]:40717
663 2024.09.12 19:21:45.205630 [ 3 ] {} <Debug> HTTP-Session: 25a339f4-fa80-405b-8b26-44cf01a62d4d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
664 2024.09.12 19:21:45.205647 [ 3 ] {} <Debug> HTTP-Session: 25a339f4-fa80-405b-8b26-44cf01a62d4d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
665 2024.09.12 19:21:45.205710 [ 3 ] {} <Trace> HTTP-Session: 25a339f4-fa80-405b-8b26-44cf01a62d4d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
666 2024.09.12 19:21:45.206159 [ 3 ] {4c5652a9-4951-4bc9-b8d5-8f79716d5785} <Debug> executeQuery: (from [::1]:40717) 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)
667 2024.09.12 19:21:45.206351 [ 3 ] {4c5652a9-4951-4bc9-b8d5-8f79716d5785} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
668 2024.09.12 19:21:45.210912 [ 3 ] {4c5652a9-4951-4bc9-b8d5-8f79716d5785} <Debug> oximeter.fields_u16 (255f23db-bb58-49a8-9668-f0cdedda2681): Loading data parts
669 2024.09.12 19:21:45.211482 [ 3 ] {4c5652a9-4951-4bc9-b8d5-8f79716d5785} <Debug> oximeter.fields_u16 (255f23db-bb58-49a8-9668-f0cdedda2681): There are no data parts
670 2024.09.12 19:21:45.215154 [ 3 ] {4c5652a9-4951-4bc9-b8d5-8f79716d5785} <Debug> DynamicQueryHandler: Done processing query
671 2024.09.12 19:21:45.215197 [ 3 ] {} <Debug> HTTP-Session: 25a339f4-fa80-405b-8b26-44cf01a62d4d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
672 2024.09.12 19:21:45.292302 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
673 2024.09.12 19:21:45.292767 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
674 2024.09.12 19:21:45.293256 [ 3 ] {} <Debug> HTTP-Session: 041a5ae7-39a8-4860-9290-be3891e540bc Authenticating user 'default' from [::1]:40717
675 2024.09.12 19:21:45.293308 [ 3 ] {} <Debug> HTTP-Session: 041a5ae7-39a8-4860-9290-be3891e540bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
676 2024.09.12 19:21:45.293356 [ 3 ] {} <Debug> HTTP-Session: 041a5ae7-39a8-4860-9290-be3891e540bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
677 2024.09.12 19:21:45.293428 [ 3 ] {} <Trace> HTTP-Session: 041a5ae7-39a8-4860-9290-be3891e540bc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
678 2024.09.12 19:21:45.293912 [ 3 ] {c6b76a5a-009b-44e8-913a-6ac288b2e4a1} <Debug> executeQuery: (from [::1]:40717) 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)
679 2024.09.12 19:21:45.294032 [ 3 ] {c6b76a5a-009b-44e8-913a-6ac288b2e4a1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
680 2024.09.12 19:21:45.304356 [ 3 ] {c6b76a5a-009b-44e8-913a-6ac288b2e4a1} <Debug> oximeter.fields_i32 (30f0cddd-e0f5-4c8e-b895-0f88d9b1cca0): Loading data parts
681 2024.09.12 19:21:45.304785 [ 3 ] {c6b76a5a-009b-44e8-913a-6ac288b2e4a1} <Debug> oximeter.fields_i32 (30f0cddd-e0f5-4c8e-b895-0f88d9b1cca0): There are no data parts
682 2024.09.12 19:21:45.308461 [ 3 ] {c6b76a5a-009b-44e8-913a-6ac288b2e4a1} <Debug> DynamicQueryHandler: Done processing query
683 2024.09.12 19:21:45.308507 [ 3 ] {} <Debug> HTTP-Session: 041a5ae7-39a8-4860-9290-be3891e540bc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
684 2024.09.12 19:21:45.313477 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
685 2024.09.12 19:21:45.313694 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
686 2024.09.12 19:21:45.313726 [ 3 ] {} <Debug> HTTP-Session: 04009a52-ffec-4d06-967c-1799be0a929b Authenticating user 'default' from [::1]:40717
687 2024.09.12 19:21:45.313846 [ 3 ] {} <Debug> HTTP-Session: 04009a52-ffec-4d06-967c-1799be0a929b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
688 2024.09.12 19:21:45.313874 [ 3 ] {} <Debug> HTTP-Session: 04009a52-ffec-4d06-967c-1799be0a929b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
689 2024.09.12 19:21:45.313954 [ 3 ] {} <Trace> HTTP-Session: 04009a52-ffec-4d06-967c-1799be0a929b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
690 2024.09.12 19:21:45.314541 [ 3 ] {b6f043f6-d183-4341-8133-0f232322c05f} <Debug> executeQuery: (from [::1]:40717) 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)
691 2024.09.12 19:21:45.314680 [ 3 ] {b6f043f6-d183-4341-8133-0f232322c05f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
692 2024.09.12 19:21:45.318669 [ 3 ] {b6f043f6-d183-4341-8133-0f232322c05f} <Debug> oximeter.fields_u32 (1f54bc3f-15ab-4e6d-9fea-250154624b49): Loading data parts
693 2024.09.12 19:21:45.319345 [ 3 ] {b6f043f6-d183-4341-8133-0f232322c05f} <Debug> oximeter.fields_u32 (1f54bc3f-15ab-4e6d-9fea-250154624b49): There are no data parts
694 2024.09.12 19:21:45.323031 [ 3 ] {b6f043f6-d183-4341-8133-0f232322c05f} <Debug> DynamicQueryHandler: Done processing query
695 2024.09.12 19:21:45.323495 [ 3 ] {} <Debug> HTTP-Session: 04009a52-ffec-4d06-967c-1799be0a929b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
696 2024.09.12 19:21:45.339969 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
697 2024.09.12 19:21:45.340202 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
698 2024.09.12 19:21:45.340233 [ 3 ] {} <Debug> HTTP-Session: 10269607-852f-40cd-a244-35554436b165 Authenticating user 'default' from [::1]:40717
699 2024.09.12 19:21:45.340263 [ 3 ] {} <Debug> HTTP-Session: 10269607-852f-40cd-a244-35554436b165 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
700 2024.09.12 19:21:45.340277 [ 3 ] {} <Debug> HTTP-Session: 10269607-852f-40cd-a244-35554436b165 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
701 2024.09.12 19:21:45.340364 [ 3 ] {} <Trace> HTTP-Session: 10269607-852f-40cd-a244-35554436b165 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
702 2024.09.12 19:21:45.340969 [ 3 ] {ac397d2a-0d41-4faf-9668-40da5d79db43} <Debug> executeQuery: (from [::1]:40717) 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)
703 2024.09.12 19:21:45.341099 [ 3 ] {ac397d2a-0d41-4faf-9668-40da5d79db43} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
704 2024.09.12 19:21:45.348029 [ 3 ] {ac397d2a-0d41-4faf-9668-40da5d79db43} <Debug> oximeter.fields_i64 (08c48756-1376-403d-9055-69f7abdbd9e7): Loading data parts
705 2024.09.12 19:21:45.348336 [ 3 ] {ac397d2a-0d41-4faf-9668-40da5d79db43} <Debug> oximeter.fields_i64 (08c48756-1376-403d-9055-69f7abdbd9e7): There are no data parts
706 2024.09.12 19:21:45.350391 [ 3 ] {ac397d2a-0d41-4faf-9668-40da5d79db43} <Debug> DynamicQueryHandler: Done processing query
707 2024.09.12 19:21:45.350424 [ 3 ] {} <Debug> HTTP-Session: 10269607-852f-40cd-a244-35554436b165 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
708 2024.09.12 19:21:45.352073 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
709 2024.09.12 19:21:45.352154 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
710 2024.09.12 19:21:45.352311 [ 3 ] {} <Debug> HTTP-Session: 5da6f5d1-ee12-47a3-9523-a777eb85de1f Authenticating user 'default' from [::1]:40717
711 2024.09.12 19:21:45.352496 [ 3 ] {} <Debug> HTTP-Session: 5da6f5d1-ee12-47a3-9523-a777eb85de1f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
712 2024.09.12 19:21:45.352514 [ 3 ] {} <Debug> HTTP-Session: 5da6f5d1-ee12-47a3-9523-a777eb85de1f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
713 2024.09.12 19:21:45.352718 [ 3 ] {} <Trace> HTTP-Session: 5da6f5d1-ee12-47a3-9523-a777eb85de1f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
714 2024.09.12 19:21:45.353289 [ 3 ] {e84ef9b2-2103-483c-bd0b-9ca404b3c446} <Debug> executeQuery: (from [::1]:40717) 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)
715 2024.09.12 19:21:45.353361 [ 3 ] {e84ef9b2-2103-483c-bd0b-9ca404b3c446} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
716 2024.09.12 19:21:45.363425 [ 3 ] {e84ef9b2-2103-483c-bd0b-9ca404b3c446} <Debug> oximeter.fields_u64 (ca5f9c5c-aa3b-4892-bf3c-a80098dde713): Loading data parts
717 2024.09.12 19:21:45.364116 [ 3 ] {e84ef9b2-2103-483c-bd0b-9ca404b3c446} <Debug> oximeter.fields_u64 (ca5f9c5c-aa3b-4892-bf3c-a80098dde713): There are no data parts
718 2024.09.12 19:21:45.367494 [ 3 ] {e84ef9b2-2103-483c-bd0b-9ca404b3c446} <Debug> DynamicQueryHandler: Done processing query
719 2024.09.12 19:21:45.367544 [ 3 ] {} <Debug> HTTP-Session: 5da6f5d1-ee12-47a3-9523-a777eb85de1f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
720 2024.09.12 19:21:45.371703 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
721 2024.09.12 19:21:45.371971 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
722 2024.09.12 19:21:45.372021 [ 3 ] {} <Debug> HTTP-Session: b53e47ea-3020-40af-aa67-720024e48836 Authenticating user 'default' from [::1]:40717
723 2024.09.12 19:21:45.372091 [ 3 ] {} <Debug> HTTP-Session: b53e47ea-3020-40af-aa67-720024e48836 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
724 2024.09.12 19:21:45.372117 [ 3 ] {} <Debug> HTTP-Session: b53e47ea-3020-40af-aa67-720024e48836 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
725 2024.09.12 19:21:45.372182 [ 3 ] {} <Trace> HTTP-Session: b53e47ea-3020-40af-aa67-720024e48836 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
726 2024.09.12 19:21:45.372590 [ 3 ] {35b7b906-6a1b-4234-b2ae-a408c8adc4b0} <Debug> executeQuery: (from [::1]:40717) 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)
727 2024.09.12 19:21:45.372673 [ 3 ] {35b7b906-6a1b-4234-b2ae-a408c8adc4b0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
728 2024.09.12 19:21:45.378642 [ 3 ] {35b7b906-6a1b-4234-b2ae-a408c8adc4b0} <Debug> oximeter.fields_ipaddr (1f6389ee-ff20-4801-a327-e3aac14d281b): Loading data parts
729 2024.09.12 19:21:45.379791 [ 3 ] {35b7b906-6a1b-4234-b2ae-a408c8adc4b0} <Debug> oximeter.fields_ipaddr (1f6389ee-ff20-4801-a327-e3aac14d281b): There are no data parts
730 2024.09.12 19:21:45.382189 [ 3 ] {35b7b906-6a1b-4234-b2ae-a408c8adc4b0} <Debug> DynamicQueryHandler: Done processing query
731 2024.09.12 19:21:45.382237 [ 3 ] {} <Debug> HTTP-Session: b53e47ea-3020-40af-aa67-720024e48836 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
732 2024.09.12 19:21:45.384683 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
733 2024.09.12 19:21:45.384785 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
734 2024.09.12 19:21:45.384811 [ 3 ] {} <Debug> HTTP-Session: 7e05d2bb-3658-40b8-a332-fb30c014a6f4 Authenticating user 'default' from [::1]:40717
735 2024.09.12 19:21:45.384834 [ 3 ] {} <Debug> HTTP-Session: 7e05d2bb-3658-40b8-a332-fb30c014a6f4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
736 2024.09.12 19:21:45.384846 [ 3 ] {} <Debug> HTTP-Session: 7e05d2bb-3658-40b8-a332-fb30c014a6f4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
737 2024.09.12 19:21:45.384895 [ 3 ] {} <Trace> HTTP-Session: 7e05d2bb-3658-40b8-a332-fb30c014a6f4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
738 2024.09.12 19:21:45.385323 [ 3 ] {dc805f84-0769-420b-b5a6-e43500fe21bb} <Debug> executeQuery: (from [::1]:40717) 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)
739 2024.09.12 19:21:45.385402 [ 3 ] {dc805f84-0769-420b-b5a6-e43500fe21bb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
740 2024.09.12 19:21:45.388860 [ 3 ] {dc805f84-0769-420b-b5a6-e43500fe21bb} <Debug> oximeter.fields_string (8dd07cc5-c44d-4f38-8154-45a18a732b59): Loading data parts
741 2024.09.12 19:21:45.389329 [ 3 ] {dc805f84-0769-420b-b5a6-e43500fe21bb} <Debug> oximeter.fields_string (8dd07cc5-c44d-4f38-8154-45a18a732b59): There are no data parts
742 2024.09.12 19:21:45.391719 [ 3 ] {dc805f84-0769-420b-b5a6-e43500fe21bb} <Debug> DynamicQueryHandler: Done processing query
743 2024.09.12 19:21:45.391754 [ 3 ] {} <Debug> HTTP-Session: 7e05d2bb-3658-40b8-a332-fb30c014a6f4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
744 2024.09.12 19:21:45.393813 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
745 2024.09.12 19:21:45.393919 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
746 2024.09.12 19:21:45.393947 [ 3 ] {} <Debug> HTTP-Session: fcfacd28-2fc5-4119-872c-6c40b99c5d24 Authenticating user 'default' from [::1]:40717
747 2024.09.12 19:21:45.394044 [ 3 ] {} <Debug> HTTP-Session: fcfacd28-2fc5-4119-872c-6c40b99c5d24 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
748 2024.09.12 19:21:45.394075 [ 3 ] {} <Debug> HTTP-Session: fcfacd28-2fc5-4119-872c-6c40b99c5d24 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
749 2024.09.12 19:21:45.394143 [ 3 ] {} <Trace> HTTP-Session: fcfacd28-2fc5-4119-872c-6c40b99c5d24 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
750 2024.09.12 19:21:45.394555 [ 3 ] {b34e0986-2309-4bdc-b937-2276aab73fb7} <Debug> executeQuery: (from [::1]:40717) 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)
751 2024.09.12 19:21:45.394646 [ 3 ] {b34e0986-2309-4bdc-b937-2276aab73fb7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
752 2024.09.12 19:21:45.398658 [ 3 ] {b34e0986-2309-4bdc-b937-2276aab73fb7} <Debug> oximeter.fields_uuid (75ec74d6-0042-4053-96b2-2945fd88406a): Loading data parts
753 2024.09.12 19:21:45.399348 [ 3 ] {b34e0986-2309-4bdc-b937-2276aab73fb7} <Debug> oximeter.fields_uuid (75ec74d6-0042-4053-96b2-2945fd88406a): There are no data parts
754 2024.09.12 19:21:45.402067 [ 3 ] {b34e0986-2309-4bdc-b937-2276aab73fb7} <Debug> DynamicQueryHandler: Done processing query
755 2024.09.12 19:21:45.402109 [ 3 ] {} <Debug> HTTP-Session: fcfacd28-2fc5-4119-872c-6c40b99c5d24 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
756 2024.09.12 19:21:45.430542 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
757 2024.09.12 19:21:45.430984 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
758 2024.09.12 19:21:45.431033 [ 3 ] {} <Debug> HTTP-Session: adcee66b-1e80-4db0-a1f5-9282592dffec Authenticating user 'default' from [::1]:40717
759 2024.09.12 19:21:45.431205 [ 3 ] {} <Debug> HTTP-Session: adcee66b-1e80-4db0-a1f5-9282592dffec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
760 2024.09.12 19:21:45.431237 [ 3 ] {} <Debug> HTTP-Session: adcee66b-1e80-4db0-a1f5-9282592dffec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
761 2024.09.12 19:21:45.431443 [ 3 ] {} <Trace> HTTP-Session: adcee66b-1e80-4db0-a1f5-9282592dffec Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
762 2024.09.12 19:21:45.433642 [ 3 ] {0629d6b1-eb8d-4556-9033-cfede5bba682} <Debug> executeQuery: (from [::1]:40717) /* The timeseries schema table stores the extracted schema for the samples
763 * oximeter collects.
764 */
765 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)
766 2024.09.12 19:21:45.433898 [ 3 ] {0629d6b1-eb8d-4556-9033-cfede5bba682} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
767 2024.09.12 19:21:45.439641 [ 3 ] {0629d6b1-eb8d-4556-9033-cfede5bba682} <Debug> oximeter.timeseries_schema (8a5aafe0-e1b0-4edc-8203-91503e020e68): Loading data parts
768 2024.09.12 19:21:45.440583 [ 3 ] {0629d6b1-eb8d-4556-9033-cfede5bba682} <Debug> oximeter.timeseries_schema (8a5aafe0-e1b0-4edc-8203-91503e020e68): There are no data parts
769 2024.09.12 19:21:45.443606 [ 3 ] {0629d6b1-eb8d-4556-9033-cfede5bba682} <Debug> DynamicQueryHandler: Done processing query
770 2024.09.12 19:21:45.443647 [ 3 ] {} <Debug> HTTP-Session: adcee66b-1e80-4db0-a1f5-9282592dffec Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
771 2024.09.12 19:21:45.445857 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
772 2024.09.12 19:21:45.446957 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
773 2024.09.12 19:21:45.446996 [ 3 ] {} <Debug> HTTP-Session: 1165dc64-51db-4d64-9aa8-707f4bc3a7c2 Authenticating user 'default' from [::1]:40717
774 2024.09.12 19:21:45.447026 [ 3 ] {} <Debug> HTTP-Session: 1165dc64-51db-4d64-9aa8-707f4bc3a7c2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
775 2024.09.12 19:21:45.447041 [ 3 ] {} <Debug> HTTP-Session: 1165dc64-51db-4d64-9aa8-707f4bc3a7c2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
776 2024.09.12 19:21:45.447090 [ 3 ] {} <Trace> HTTP-Session: 1165dc64-51db-4d64-9aa8-707f4bc3a7c2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
777 2024.09.12 19:21:45.447453 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Debug> executeQuery: (from [::1]:40717) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
778 2024.09.12 19:21:45.447910 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
779 2024.09.12 19:21:45.452174 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Trace> oximeter.version (2ec1e53b-12bf-4274-a5c1-5777ab22df23): Trying to reserve 1.00 MiB using storage policy from min volume index 0
780 2024.09.12 19:21:45.452241 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 133.53 GiB.
781 2024.09.12 19:21:45.454676 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
782 2024.09.12 19:21:45.456092 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Trace> oximeter.version (2ec1e53b-12bf-4274-a5c1-5777ab22df23): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
783 2024.09.12 19:21:45.456674 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.009343 sec., 107.03200256876805 rows/sec., 1.67 KiB/sec.
784 2024.09.12 19:21:45.457231 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Debug> DynamicQueryHandler: Done processing query
785 2024.09.12 19:21:45.457275 [ 3 ] {1d3caf15-35d1-47c4-beac-94acfda454b7} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB.
786 2024.09.12 19:21:45.457443 [ 3 ] {} <Debug> HTTP-Session: 1165dc64-51db-4d64-9aa8-707f4bc3a7c2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
787 2024.09.12 19:21:46.000430 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 146.53 MiB, peak 151.67 MiB, free memory in arenas 0.00 B, will set to 147.73 MiB (RSS), difference: 1.20 MiB
788 2024.09.12 19:21:46.799033 [ 125 ] {} <Debug> DNSResolver: Updating DNS cache
789 2024.09.12 19:21:46.799094 [ 125 ] {} <Debug> DNSResolver: Updated DNS cache
790 2024.09.12 19:21:47.552106 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 60, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
791 2024.09.12 19:21:47.552262 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
792 2024.09.12 19:21:47.552293 [ 3 ] {} <Debug> HTTP-Session: c650b611-f27f-4044-b2f6-34885c8d062d Authenticating user 'default' from [::1]:40717
793 2024.09.12 19:21:47.552321 [ 3 ] {} <Debug> HTTP-Session: c650b611-f27f-4044-b2f6-34885c8d062d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
794 2024.09.12 19:21:47.552334 [ 3 ] {} <Debug> HTTP-Session: c650b611-f27f-4044-b2f6-34885c8d062d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
795 2024.09.12 19:21:47.552392 [ 3 ] {} <Trace> HTTP-Session: c650b611-f27f-4044-b2f6-34885c8d062d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
796 2024.09.12 19:21:47.552630 [ 3 ] {92d6d10f-0b6d-4c06-afef-6e2fa646e483} <Debug> executeQuery: (from [::1]:40717) SELECT * FROM oximeter.timeseries_schema FORMAT JSONEachRow; (stage: Complete)
797 2024.09.12 19:21:47.553085 [ 3 ] {92d6d10f-0b6d-4c06-afef-6e2fa646e483} <Trace> ContextAccess (default): Access granted: SELECT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema
798 2024.09.12 19:21:47.553272 [ 3 ] {92d6d10f-0b6d-4c06-afef-6e2fa646e483} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
799 2024.09.12 19:21:47.555254 [ 3 ] {92d6d10f-0b6d-4c06-afef-6e2fa646e483} <Debug> DynamicQueryHandler: Done processing query
800 2024.09.12 19:21:47.555290 [ 3 ] {92d6d10f-0b6d-4c06-afef-6e2fa646e483} <Debug> MemoryTracker: Peak memory usage (for query): 3.00 MiB.
801 2024.09.12 19:21:47.555307 [ 3 ] {} <Debug> HTTP-Session: c650b611-f27f-4044-b2f6-34885c8d062d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
802 2024.09.12 19:21:47.559223 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
803 2024.09.12 19:21:47.559312 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
804 2024.09.12 19:21:47.559336 [ 3 ] {} <Debug> HTTP-Session: 63ab1358-b091-4b47-9fa9-ceb58d9d9c6b Authenticating user 'default' from [::1]:40717
805 2024.09.12 19:21:47.559358 [ 3 ] {} <Debug> HTTP-Session: 63ab1358-b091-4b47-9fa9-ceb58d9d9c6b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
806 2024.09.12 19:21:47.559371 [ 3 ] {} <Debug> HTTP-Session: 63ab1358-b091-4b47-9fa9-ceb58d9d9c6b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
807 2024.09.12 19:21:47.559413 [ 3 ] {} <Trace> HTTP-Session: 63ab1358-b091-4b47-9fa9-ceb58d9d9c6b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
808 2024.09.12 19:21:47.559598 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Debug> executeQuery: (from [::1]:40717) INSERT INTO oximeter.timeseries_schema FORMAT JSONEachRow (stage: Complete)
809 2024.09.12 19:21:47.559667 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, `fields.name`, `fields.type`, `fields.source`, datum_type, created) ON oximeter.timeseries_schema
810 2024.09.12 19:21:47.559964 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Trace> ParallelParsingInputFormat: Parallel parsing is used
811 2024.09.12 19:21:47.560705 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Trace> oximeter.timeseries_schema (8a5aafe0-e1b0-4edc-8203-91503e020e68): Trying to reserve 1.00 MiB using storage policy from min volume index 0
812 2024.09.12 19:21:47.560767 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 133.53 GiB.
813 2024.09.12 19:21:47.561600 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
814 2024.09.12 19:21:47.562081 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Trace> oximeter.timeseries_schema (8a5aafe0-e1b0-4edc-8203-91503e020e68): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
815 2024.09.12 19:21:47.562325 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Debug> executeQuery: Read 1 rows, 123.00 B in 0.002778 sec., 359.9712023038157 rows/sec., 43.24 KiB/sec.
816 2024.09.12 19:21:47.562676 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Debug> DynamicQueryHandler: Done processing query
817 2024.09.12 19:21:47.562706 [ 3 ] {5c9003c1-3ce0-4a13-96bf-d3a4f9141f85} <Debug> MemoryTracker: Peak memory usage (for query): 4.25 MiB.
818 2024.09.12 19:21:47.562793 [ 3 ] {} <Debug> HTTP-Session: 63ab1358-b091-4b47-9fa9-ceb58d9d9c6b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
819 2024.09.12 19:21:47.565645 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
820 2024.09.12 19:21:47.565730 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
821 2024.09.12 19:21:47.565780 [ 3 ] {} <Debug> HTTP-Session: a0e69262-d1d8-4131-bb44-32ca2e248745 Authenticating user 'default' from [::1]:40717
822 2024.09.12 19:21:47.565803 [ 3 ] {} <Debug> HTTP-Session: a0e69262-d1d8-4131-bb44-32ca2e248745 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
823 2024.09.12 19:21:47.565818 [ 3 ] {} <Debug> HTTP-Session: a0e69262-d1d8-4131-bb44-32ca2e248745 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
824 2024.09.12 19:21:47.565858 [ 3 ] {} <Trace> HTTP-Session: a0e69262-d1d8-4131-bb44-32ca2e248745 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
825 2024.09.12 19:21:47.566014 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Debug> executeQuery: (from [::1]:40717) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete)
826 2024.09.12 19:21:47.566078 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
827 2024.09.12 19:21:47.566423 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Trace> ParallelParsingInputFormat: Parallel parsing is used
828 2024.09.12 19:21:47.567215 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Trace> oximeter.fields_string (8dd07cc5-c44d-4f38-8154-45a18a732b59): Trying to reserve 1.00 MiB using storage policy from min volume index 0
829 2024.09.12 19:21:47.567270 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 133.53 GiB.
830 2024.09.12 19:21:47.567845 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
831 2024.09.12 19:21:47.568648 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Trace> oximeter.fields_string (8dd07cc5-c44d-4f38-8154-45a18a732b59): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
832 2024.09.12 19:21:47.568854 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002869 sec., 697.1070059254096 rows/sec., 72.16 KiB/sec.
833 2024.09.12 19:21:47.569333 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Debug> DynamicQueryHandler: Done processing query
834 2024.09.12 19:21:47.569365 [ 3 ] {c1281522-2ccf-498d-8b33-ded3dbd43ac6} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB.
835 2024.09.12 19:21:47.569381 [ 3 ] {} <Debug> HTTP-Session: a0e69262-d1d8-4131-bb44-32ca2e248745 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
836 2024.09.12 19:21:47.570793 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
837 2024.09.12 19:21:47.570925 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
838 2024.09.12 19:21:47.570955 [ 3 ] {} <Debug> HTTP-Session: 86ea10ae-2c62-4db5-b0b9-4e411c91bce3 Authenticating user 'default' from [::1]:40717
839 2024.09.12 19:21:47.571534 [ 3 ] {} <Debug> HTTP-Session: 86ea10ae-2c62-4db5-b0b9-4e411c91bce3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
840 2024.09.12 19:21:47.571572 [ 3 ] {} <Debug> HTTP-Session: 86ea10ae-2c62-4db5-b0b9-4e411c91bce3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
841 2024.09.12 19:21:47.571769 [ 3 ] {} <Trace> HTTP-Session: 86ea10ae-2c62-4db5-b0b9-4e411c91bce3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
842 2024.09.12 19:21:47.572337 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Debug> executeQuery: (from [::1]:40717) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete)
843 2024.09.12 19:21:47.572475 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
844 2024.09.12 19:21:47.572799 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Trace> ParallelParsingInputFormat: Parallel parsing is used
845 2024.09.12 19:21:47.573426 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Trace> oximeter.measurements_i64 (b78297e3-bbe0-43a4-92d0-d66b1626cc40): Trying to reserve 1.00 MiB using storage policy from min volume index 0
846 2024.09.12 19:21:47.573489 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 133.53 GiB.
847 2024.09.12 19:21:47.574150 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
848 2024.09.12 19:21:47.574837 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Trace> oximeter.measurements_i64 (b78297e3-bbe0-43a4-92d0-d66b1626cc40): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
849 2024.09.12 19:21:47.575087 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002826 sec., 353.8570417551309 rows/sec., 24.54 KiB/sec.
850 2024.09.12 19:21:47.576135 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Debug> DynamicQueryHandler: Done processing query
851 2024.09.12 19:21:47.576287 [ 3 ] {12561f91-a028-4b37-9779-7b94caf44bae} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB.
852 2024.09.12 19:21:47.576302 [ 3 ] {} <Debug> HTTP-Session: 86ea10ae-2c62-4db5-b0b9-4e411c91bce3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
853 2024.09.12 19:21:48.560562 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 382, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
854 2024.09.12 19:21:48.560727 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
855 2024.09.12 19:21:48.560756 [ 3 ] {} <Debug> HTTP-Session: 41d1fdf4-0da6-4fc0-a09f-7c9f215985d1 Authenticating user 'default' from [::1]:40717
856 2024.09.12 19:21:48.560783 [ 3 ] {} <Debug> HTTP-Session: 41d1fdf4-0da6-4fc0-a09f-7c9f215985d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
857 2024.09.12 19:21:48.560797 [ 3 ] {} <Debug> HTTP-Session: 41d1fdf4-0da6-4fc0-a09f-7c9f215985d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
858 2024.09.12 19:21:48.560856 [ 3 ] {} <Trace> HTTP-Session: 41d1fdf4-0da6-4fc0-a09f-7c9f215985d1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
859 2024.09.12 19:21:48.561130 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Debug> executeQuery: (from [::1]:40717) INSERT INTO oximeter.fields_string FORMAT JSONEachRow (stage: Complete)
860 2024.09.12 19:21:48.561222 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, field_name, field_value) ON oximeter.fields_string
861 2024.09.12 19:21:48.561650 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Trace> ParallelParsingInputFormat: Parallel parsing is used
862 2024.09.12 19:21:48.562297 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Trace> oximeter.fields_string (8dd07cc5-c44d-4f38-8154-45a18a732b59): Trying to reserve 1.00 MiB using storage policy from min volume index 0
863 2024.09.12 19:21:48.562366 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 133.53 GiB.
864 2024.09.12 19:21:48.562978 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary)
865 2024.09.12 19:21:48.563508 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Trace> oximeter.fields_string (8dd07cc5-c44d-4f38-8154-45a18a732b59): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
866 2024.09.12 19:21:48.563755 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Debug> executeQuery: Read 2 rows, 212.00 B in 0.002704 sec., 739.6449704142012 rows/sec., 76.56 KiB/sec.
867 2024.09.12 19:21:48.564231 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Debug> DynamicQueryHandler: Done processing query
868 2024.09.12 19:21:48.564265 [ 3 ] {adeb244d-e3ee-4e28-a6d2-47781661ed2e} <Debug> MemoryTracker: Peak memory usage (for query): 4.22 MiB.
869 2024.09.12 19:21:48.564282 [ 3 ] {} <Debug> HTTP-Session: 41d1fdf4-0da6-4fc0-a09f-7c9f215985d1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
870 2024.09.12 19:21:48.567929 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:40717, User-Agent: (none), Length: 208, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
871 2024.09.12 19:21:48.568049 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
872 2024.09.12 19:21:48.568074 [ 3 ] {} <Debug> HTTP-Session: deb65684-ea96-41ca-a0e5-7e827b846989 Authenticating user 'default' from [::1]:40717
873 2024.09.12 19:21:48.568099 [ 3 ] {} <Debug> HTTP-Session: deb65684-ea96-41ca-a0e5-7e827b846989 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
874 2024.09.12 19:21:48.568112 [ 3 ] {} <Debug> HTTP-Session: deb65684-ea96-41ca-a0e5-7e827b846989 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
875 2024.09.12 19:21:48.568158 [ 3 ] {} <Trace> HTTP-Session: deb65684-ea96-41ca-a0e5-7e827b846989 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
876 2024.09.12 19:21:48.568326 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Debug> executeQuery: (from [::1]:40717) INSERT INTO oximeter.measurements_i64 FORMAT JSONEachRow (stage: Complete)
877 2024.09.12 19:21:48.568401 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Trace> ContextAccess (default): Access granted: INSERT(timeseries_name, timeseries_key, timestamp, datum) ON oximeter.measurements_i64
878 2024.09.12 19:21:48.568592 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Trace> ParallelParsingInputFormat: Parallel parsing is used
879 2024.09.12 19:21:48.569339 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Trace> oximeter.measurements_i64 (b78297e3-bbe0-43a4-92d0-d66b1626cc40): Trying to reserve 1.00 MiB using storage policy from min volume index 0
880 2024.09.12 19:21:48.569394 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 133.53 GiB.
881 2024.09.12 19:21:48.569990 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Trace> MergedBlockOutputStream: filled checksums all_2_2_0 (state Temporary)
882 2024.09.12 19:21:48.570477 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Trace> oximeter.measurements_i64 (b78297e3-bbe0-43a4-92d0-d66b1626cc40): Renaming temporary part tmp_insert_all_2_2_0 to all_2_2_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
883 2024.09.12 19:21:48.570744 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Debug> executeQuery: Read 1 rows, 71.00 B in 0.002427 sec., 412.0313143798929 rows/sec., 28.57 KiB/sec.
884 2024.09.12 19:21:48.571090 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Debug> DynamicQueryHandler: Done processing query
885 2024.09.12 19:21:48.571120 [ 3 ] {b887964e-c7f3-4c57-841e-f67db168abb3} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB.
886 2024.09.12 19:21:48.571136 [ 3 ] {} <Debug> HTTP-Session: deb65684-ea96-41ca-a0e5-7e827b846989 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db