Max level shown:
1 2024.10.09 22:55:33.949688 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 23284
2 2024.10.09 22:55:33.949812 [ 1 ] {} <Information> Application: starting up
3 2024.10.09 22:55:33.949848 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc
4 2024.10.09 22:55:33.958201 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8.
5 2024.10.09 22:55:33.960591 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536
6 2024.10.09 22:55:33.960621 [ 1 ] {} <Debug> Application: Initializing DateLUT.
7 2024.10.09 22:55:33.960631 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
8 2024.10.09 22:55:33.960673 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_basic-bf0e85416c80c4ce-test_blueprint_edit.23235.1-clickhouse-lqtBRF/datastore/tmp/ to store temporary data in it
9 2024.10.09 22:55:33.961072 [ 1 ] {} <Debug> Application: Initializing interserver credentials.
10 2024.10.09 22:55:33.961658 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
11 2024.10.09 22:55:33.962013 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
12 2024.10.09 22:55:33.962321 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.18 GiB (31.32 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
13 2024.10.09 22:55:33.962333 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.66 GiB (31.32 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
14 2024.10.09 22:55:33.962346 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB
15 2024.10.09 22:55:33.962403 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
16 2024.10.09 22:55:33.963400 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
17 2024.10.09 22:55:33.979934 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
18 2024.10.09 22:55:33.981115 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
19 2024.10.09 22:55:33.982295 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
20 2024.10.09 22:55:33.982366 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
21 2024.10.09 22:55:33.983425 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
22 2024.10.09 22:55:33.983947 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
23 2024.10.09 22:55:33.984980 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
24 2024.10.09 22:55:33.985318 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml
25 2024.10.09 22:55:33.986585 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
26 2024.10.09 22:55:33.987306 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
27 2024.10.09 22:55:33.987915 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
28 2024.10.09 22:55:33.988621 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
29 2024.10.09 22:55:33.989929 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
30 2024.10.09 22:55:33.989971 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_basic-bf0e85416c80c4ce-test_blueprint_edit.23235.1-clickhouse-lqtBRF/datastore/
31 2024.10.09 22:55:33.990005 [ 132 ] {} <Debug> DNSResolver: Updating DNS cache
32 2024.10.09 22:55:33.990059 [ 132 ] {} <Debug> DNSResolver: Updated DNS cache
33 2024.10.09 22:55:33.995094 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
34 2024.10.09 22:55:33.995116 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000116324 sec
35 2024.10.09 22:55:33.995136 [ 1 ] {} <Trace> ReferentialDeps: No tables
36 2024.10.09 22:55:33.995143 [ 1 ] {} <Trace> LoadingDeps: No tables
37 2024.10.09 22:55:33.995204 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables.
38 2024.10.09 22:55:33.995250 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config
39 2024.10.09 22:55:33.995262 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
40 2024.10.09 22:55:33.995281 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
41 2024.10.09 22:55:33.995292 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
42 2024.10.09 22:55:33.995300 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
43 2024.10.09 22:55:33.995317 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
44 2024.10.09 22:55:33.995325 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config
45 2024.10.09 22:55:33.995335 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
46 2024.10.09 22:55:33.995354 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
47 2024.10.09 22:55:33.995362 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config
48 2024.10.09 22:55:33.995373 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
49 2024.10.09 22:55:33.995381 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
50 2024.10.09 22:55:33.995394 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
51 2024.10.09 22:55:33.995404 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
52 2024.10.09 22:55:33.995421 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
53 2024.10.09 22:55:33.995429 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
54 2024.10.09 22:55:33.995440 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
55 2024.10.09 22:55:34.026486 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
56 2024.10.09 22:55:34.029799 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
57 2024.10.09 22:55:34.029842 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.7056e-05 sec
58 2024.10.09 22:55:34.029931 [ 1 ] {} <Trace> ReferentialDeps: No tables
59 2024.10.09 22:55:34.029942 [ 1 ] {} <Trace> LoadingDeps: No tables
60 2024.10.09 22:55:34.029968 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables.
61 2024.10.09 22:55:34.030761 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_basic-bf0e85416c80c4ce-test_blueprint_edit.23235.1-clickhouse-lqtBRF/datastore/user_defined/
62 2024.10.09 22:55:34.030955 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
63 2024.10.09 22:55:34.030999 [ 1 ] {} <Debug> Application: Loaded metadata.
64 2024.10.09 22:55:34.031015 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe).
65 2024.10.09 22:55:34.031110 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled.
66 2024.10.09 22:55:34.031540 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 64588
67 2024.10.09 22:55:34.031772 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 50790
68 2024.10.09 22:55:34.033342 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1)
69 2024.10.09 22:55:34.114298 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1)
70 2024.10.09 22:55:34.114333 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
71 2024.10.09 22:55:34.193186 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 50169
72 2024.10.09 22:55:34.193274 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 64152
73 2024.10.09 22:55:34.193354 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1)
74 2024.10.09 22:55:34.232156 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1)
75 2024.10.09 22:55:34.232198 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
76 2024.10.09 22:55:34.472619 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
77 2024.10.09 22:55:34.472896 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.08 MiB, free memory in arenas 0.00 B, will set to 170.77 MiB (RSS), difference: 160.90 MiB
78 2024.10.09 22:55:34.473203 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.3389e-05 sec.
79 2024.10.09 22:55:34.473741 [ 1 ] {} <Information> Application: Listening for http://[::1]:64588
80 2024.10.09 22:55:34.473820 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:50790
81 2024.10.09 22:55:34.473891 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
82 2024.10.09 22:55:34.473979 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:50169
83 2024.10.09 22:55:34.474079 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:64152
84 2024.10.09 22:55:34.474168 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
85 2024.10.09 22:55:34.474192 [ 1 ] {} <Information> Application: Ready for connections.
86 2024.10.09 22:55:41.527067 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
87 2024.10.09 22:55:41.527312 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
88 2024.10.09 22:55:41.527361 [ 3 ] {} <Debug> HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Authenticating user 'default' from [::1]:33250
89 2024.10.09 22:55:41.527413 [ 3 ] {} <Debug> HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
90 2024.10.09 22:55:41.527430 [ 3 ] {} <Debug> HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
91 2024.10.09 22:55:41.527546 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
92 2024.10.09 22:55:41.527602 [ 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
93 2024.10.09 22:55:41.527622 [ 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
94 2024.10.09 22:55:41.527690 [ 3 ] {} <Trace> HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
95 2024.10.09 22:55:41.528304 [ 3 ] {cb42f087-aedf-4666-8e6f-3068e21ab79d} <Debug> executeQuery: (from [::1]:33250) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
96 2024.10.09 22:55:41.536477 [ 3 ] {cb42f087-aedf-4666-8e6f-3068e21ab79d} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:33250) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
97 
98 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
99 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
100 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
101 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
102 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
103 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
104 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
105 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
106 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
107 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
108 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
109 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
110 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
111 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
112 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
113 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
114 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
115 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
116 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
117 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
118 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
119 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1
120 
121 2024.10.09 22:55:41.536722 [ 3 ] {cb42f087-aedf-4666-8e6f-3068e21ab79d} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
122 
123 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
124 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
125 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
126 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
127 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
128 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
129 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
130 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
131 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
132 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
133 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
134 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
135 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
136 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
137 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
138 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
139 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
140 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
141 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
142 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
143 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
144 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1
145 (version 23.8.7.1)
146 2024.10.09 22:55:41.537054 [ 3 ] {} <Debug> HTTP-Session: b3c860d3-c185-422d-b230-d343185be11d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
147 2024.10.09 22:55:41.538279 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
148 2024.10.09 22:55:41.538376 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
149 2024.10.09 22:55:41.538454 [ 3 ] {} <Debug> HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Authenticating user 'default' from [::1]:33250
150 2024.10.09 22:55:41.538484 [ 3 ] {} <Debug> HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
151 2024.10.09 22:55:41.538522 [ 3 ] {} <Debug> HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
152 2024.10.09 22:55:41.538573 [ 3 ] {} <Trace> HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
153 2024.10.09 22:55:41.538796 [ 3 ] {e1b1eb1d-bf82-47e4-bd41-fc7495876555} <Debug> executeQuery: (from [::1]:33250) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
154 2024.10.09 22:55:41.539147 [ 3 ] {e1b1eb1d-bf82-47e4-bd41-fc7495876555} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:33250) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
155 
156 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
157 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
158 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
159 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
160 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
161 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
162 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
163 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
164 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
165 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
166 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
167 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
168 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
169 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
170 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
171 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
172 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
173 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
174 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
175 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
176 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
177 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1
178 
179 2024.10.09 22:55:41.539301 [ 3 ] {e1b1eb1d-bf82-47e4-bd41-fc7495876555} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
180 
181 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
182 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
183 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
184 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
185 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
186 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
187 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
188 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
189 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
190 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
191 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
192 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
193 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
194 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
195 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
196 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
197 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
198 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
199 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
200 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
201 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
202 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1
203 (version 23.8.7.1)
204 2024.10.09 22:55:41.539501 [ 3 ] {} <Debug> HTTP-Session: daf301ba-4af7-43e5-a164-3eec4a15fc84 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
205 2024.10.09 22:55:41.540659 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
206 2024.10.09 22:55:41.540735 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
207 2024.10.09 22:55:41.540757 [ 3 ] {} <Debug> HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Authenticating user 'default' from [::1]:33250
208 2024.10.09 22:55:41.540773 [ 3 ] {} <Debug> HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
209 2024.10.09 22:55:41.540794 [ 3 ] {} <Debug> HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
210 2024.10.09 22:55:41.540831 [ 3 ] {} <Trace> HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
211 2024.10.09 22:55:41.541059 [ 3 ] {1f08e7b2-8b3f-492b-b05b-7b0e220a45c6} <Debug> executeQuery: (from [::1]:33250) DROP DATABASE IF EXISTS oximeter (stage: Complete)
212 2024.10.09 22:55:41.541375 [ 3 ] {1f08e7b2-8b3f-492b-b05b-7b0e220a45c6} <Debug> DynamicQueryHandler: Done processing query
213 2024.10.09 22:55:41.541447 [ 3 ] {} <Debug> HTTP-Session: 8cc30d58-52c6-4e05-b1de-14d81bf47b79 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
214 2024.10.09 22:55:41.544721 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
215 2024.10.09 22:55:41.544845 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
216 2024.10.09 22:55:41.544874 [ 3 ] {} <Debug> HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Authenticating user 'default' from [::1]:33250
217 2024.10.09 22:55:41.544892 [ 3 ] {} <Debug> HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
218 2024.10.09 22:55:41.544914 [ 3 ] {} <Debug> HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
219 2024.10.09 22:55:41.544976 [ 3 ] {} <Trace> HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
220 2024.10.09 22:55:41.545105 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} <Debug> executeQuery: (from [::1]:33250) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
221 2024.10.09 22:55:41.545185 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
222 2024.10.09 22:55:41.546654 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
223 2024.10.09 22:55:41.546678 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.3758e-05 sec
224 2024.10.09 22:55:41.546712 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} <Trace> ReferentialDeps: No tables
225 2024.10.09 22:55:41.546724 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} <Trace> LoadingDeps: No tables
226 2024.10.09 22:55:41.546747 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} <Information> DatabaseAtomic (oximeter): Starting up tables.
227 2024.10.09 22:55:41.546896 [ 3 ] {598be3af-1b01-4f90-97bb-68c0d27cdc06} <Debug> DynamicQueryHandler: Done processing query
228 2024.10.09 22:55:41.546928 [ 3 ] {} <Debug> HTTP-Session: 8823106e-661c-4a18-ba25-ad90889ee52f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
229 2024.10.09 22:55:41.549746 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
230 2024.10.09 22:55:41.549806 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
231 2024.10.09 22:55:41.549855 [ 3 ] {} <Debug> HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Authenticating user 'default' from [::1]:33250
232 2024.10.09 22:55:41.549875 [ 3 ] {} <Debug> HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
233 2024.10.09 22:55:41.549891 [ 3 ] {} <Debug> HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
234 2024.10.09 22:55:41.549973 [ 3 ] {} <Trace> HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
235 2024.10.09 22:55:41.550679 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} <Debug> executeQuery: (from [::1]:33250) /* The version table contains metadata about the `oximeter` database */
236 CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete)
237 2024.10.09 22:55:41.550775 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
238 2024.10.09 22:55:41.552487 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
239 2024.10.09 22:55:41.554244 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} <Debug> oximeter.version (fcc73285-839e-4734-a652-af3fe4b1b91e): Loading data parts
240 2024.10.09 22:55:41.555819 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} <Debug> oximeter.version (fcc73285-839e-4734-a652-af3fe4b1b91e): There are no data parts
241 2024.10.09 22:55:41.557813 [ 3 ] {ebe1d77d-7155-4f18-84f8-3ae3149d49bb} <Debug> DynamicQueryHandler: Done processing query
242 2024.10.09 22:55:41.557840 [ 3 ] {} <Debug> HTTP-Session: 2bb4cf3a-1176-4756-9353-37a2760c0511 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
243 2024.10.09 22:55:41.559381 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
244 2024.10.09 22:55:41.559444 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
245 2024.10.09 22:55:41.559510 [ 3 ] {} <Debug> HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Authenticating user 'default' from [::1]:33250
246 2024.10.09 22:55:41.559540 [ 3 ] {} <Debug> HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
247 2024.10.09 22:55:41.559557 [ 3 ] {} <Debug> HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
248 2024.10.09 22:55:41.559597 [ 3 ] {} <Trace> HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
249 2024.10.09 22:55:41.559860 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} <Debug> executeQuery: (from [::1]:33250) /* The measurement tables contain all individual samples from each timeseries.
250 *
251 * Each table stores a single datum type, and otherwise contains nearly the same
252 * structure. The primary sorting key is on the timeseries name, key, and then
253 * timestamp, so that all timeseries from the same schema are grouped, followed
254 * by all samples from the same timeseries.
255 *
256 * This reflects that one usually looks up the _key_ in one or more field table,
257 * and then uses that to index quickly into the measurements tables.
258 */
259 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)
260 2024.10.09 22:55:41.559957 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
261 2024.10.09 22:55:41.562428 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} <Debug> oximeter.measurements_bool (8c3fc2e4-d5ad-44e4-9d62-9c8d0ae921a7): Loading data parts
262 2024.10.09 22:55:41.562740 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} <Debug> oximeter.measurements_bool (8c3fc2e4-d5ad-44e4-9d62-9c8d0ae921a7): There are no data parts
263 2024.10.09 22:55:41.564347 [ 3 ] {fd59c1ec-c1c3-4c38-9eb0-f8758ca5600b} <Debug> DynamicQueryHandler: Done processing query
264 2024.10.09 22:55:41.564386 [ 3 ] {} <Debug> HTTP-Session: 74069d84-178b-4389-91b8-3c253e77e0e6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
265 2024.10.09 22:55:41.566335 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
266 2024.10.09 22:55:41.566399 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
267 2024.10.09 22:55:41.566433 [ 3 ] {} <Debug> HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Authenticating user 'default' from [::1]:33250
268 2024.10.09 22:55:41.566455 [ 3 ] {} <Debug> HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
269 2024.10.09 22:55:41.566470 [ 3 ] {} <Debug> HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
270 2024.10.09 22:55:41.566519 [ 3 ] {} <Trace> HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
271 2024.10.09 22:55:41.566825 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} <Debug> executeQuery: (from [::1]:33250) 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)
272 2024.10.09 22:55:41.566903 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
273 2024.10.09 22:55:41.569087 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} <Debug> oximeter.measurements_i8 (9d5b4d2d-e744-44f6-a846-54700ed93cf2): Loading data parts
274 2024.10.09 22:55:41.569377 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} <Debug> oximeter.measurements_i8 (9d5b4d2d-e744-44f6-a846-54700ed93cf2): There are no data parts
275 2024.10.09 22:55:41.571206 [ 3 ] {1d6ed8a2-ca2e-47cc-bee5-782dc188e216} <Debug> DynamicQueryHandler: Done processing query
276 2024.10.09 22:55:41.571232 [ 3 ] {} <Debug> HTTP-Session: c7b94885-3e70-44dd-9248-f89c2b91dde0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
277 2024.10.09 22:55:41.575443 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
278 2024.10.09 22:55:41.575571 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
279 2024.10.09 22:55:41.575601 [ 3 ] {} <Debug> HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Authenticating user 'default' from [::1]:33250
280 2024.10.09 22:55:41.575624 [ 3 ] {} <Debug> HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
281 2024.10.09 22:55:41.575652 [ 3 ] {} <Debug> HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
282 2024.10.09 22:55:41.575696 [ 3 ] {} <Trace> HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
283 2024.10.09 22:55:41.575966 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} <Debug> executeQuery: (from [::1]:33250) 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)
284 2024.10.09 22:55:41.576034 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
285 2024.10.09 22:55:41.578267 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} <Debug> oximeter.measurements_u8 (b8b0a85b-60bd-4c12-b177-c5a6a005db57): Loading data parts
286 2024.10.09 22:55:41.578549 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} <Debug> oximeter.measurements_u8 (b8b0a85b-60bd-4c12-b177-c5a6a005db57): There are no data parts
287 2024.10.09 22:55:41.580180 [ 3 ] {896c7b49-d005-46fb-b971-685cbe060a49} <Debug> DynamicQueryHandler: Done processing query
288 2024.10.09 22:55:41.580213 [ 3 ] {} <Debug> HTTP-Session: 67c98099-9094-4cd2-af8b-d5bdbcaf5970 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
289 2024.10.09 22:55:41.583524 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
290 2024.10.09 22:55:41.583594 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
291 2024.10.09 22:55:41.583625 [ 3 ] {} <Debug> HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Authenticating user 'default' from [::1]:33250
292 2024.10.09 22:55:41.583646 [ 3 ] {} <Debug> HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
293 2024.10.09 22:55:41.583661 [ 3 ] {} <Debug> HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
294 2024.10.09 22:55:41.583703 [ 3 ] {} <Trace> HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
295 2024.10.09 22:55:41.583967 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} <Debug> executeQuery: (from [::1]:33250) 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)
296 2024.10.09 22:55:41.584032 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
297 2024.10.09 22:55:41.586188 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} <Debug> oximeter.measurements_i16 (07890d97-3c17-41c7-a400-31a6454bb616): Loading data parts
298 2024.10.09 22:55:41.586432 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} <Debug> oximeter.measurements_i16 (07890d97-3c17-41c7-a400-31a6454bb616): There are no data parts
299 2024.10.09 22:55:41.588610 [ 3 ] {3bdcccd1-3ef7-4655-91f1-331448b18b1c} <Debug> DynamicQueryHandler: Done processing query
300 2024.10.09 22:55:41.588638 [ 3 ] {} <Debug> HTTP-Session: 55b4989e-38ed-4aa7-b1fc-5aa8681a1796 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
301 2024.10.09 22:55:41.592629 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
302 2024.10.09 22:55:41.592805 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
303 2024.10.09 22:55:41.592833 [ 3 ] {} <Debug> HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Authenticating user 'default' from [::1]:33250
304 2024.10.09 22:55:41.592852 [ 3 ] {} <Debug> HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
305 2024.10.09 22:55:41.592876 [ 3 ] {} <Debug> HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
306 2024.10.09 22:55:41.592914 [ 3 ] {} <Trace> HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
307 2024.10.09 22:55:41.601454 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} <Debug> executeQuery: (from [::1]:33250) 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)
308 2024.10.09 22:55:41.601577 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
309 2024.10.09 22:55:41.603694 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} <Debug> oximeter.measurements_u16 (a12119ac-1a35-4181-a502-c4e3a18a86a5): Loading data parts
310 2024.10.09 22:55:41.604036 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} <Debug> oximeter.measurements_u16 (a12119ac-1a35-4181-a502-c4e3a18a86a5): There are no data parts
311 2024.10.09 22:55:41.605576 [ 3 ] {3e8f9e0c-5d7c-472f-89cf-42c4bbb01803} <Debug> DynamicQueryHandler: Done processing query
312 2024.10.09 22:55:41.605602 [ 3 ] {} <Debug> HTTP-Session: fd5346b9-b1be-4865-83a5-32195806e393 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
313 2024.10.09 22:55:41.606403 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
314 2024.10.09 22:55:41.606539 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
315 2024.10.09 22:55:41.606579 [ 3 ] {} <Debug> HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Authenticating user 'default' from [::1]:33250
316 2024.10.09 22:55:41.606628 [ 3 ] {} <Debug> HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
317 2024.10.09 22:55:41.606642 [ 3 ] {} <Debug> HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
318 2024.10.09 22:55:41.606680 [ 3 ] {} <Trace> HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
319 2024.10.09 22:55:41.606969 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} <Debug> executeQuery: (from [::1]:33250) 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)
320 2024.10.09 22:55:41.607036 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
321 2024.10.09 22:55:41.609188 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} <Debug> oximeter.measurements_i32 (02695081-6199-46ad-a200-11203d5df21e): Loading data parts
322 2024.10.09 22:55:41.609451 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} <Debug> oximeter.measurements_i32 (02695081-6199-46ad-a200-11203d5df21e): There are no data parts
323 2024.10.09 22:55:41.611206 [ 3 ] {2f9c5391-e8e4-4697-95da-0c1d153dbeb9} <Debug> DynamicQueryHandler: Done processing query
324 2024.10.09 22:55:41.611232 [ 3 ] {} <Debug> HTTP-Session: cf7399d7-50ab-4f04-9076-795b83e56df7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
325 2024.10.09 22:55:41.611747 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
326 2024.10.09 22:55:41.611814 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
327 2024.10.09 22:55:41.611837 [ 3 ] {} <Debug> HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Authenticating user 'default' from [::1]:33250
328 2024.10.09 22:55:41.611856 [ 3 ] {} <Debug> HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
329 2024.10.09 22:55:41.611866 [ 3 ] {} <Debug> HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
330 2024.10.09 22:55:41.611900 [ 3 ] {} <Trace> HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
331 2024.10.09 22:55:41.612112 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} <Debug> executeQuery: (from [::1]:33250) 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)
332 2024.10.09 22:55:41.612165 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
333 2024.10.09 22:55:41.613969 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} <Debug> oximeter.measurements_u32 (0fc7ac17-3c2b-4a70-92cd-292b986d9307): Loading data parts
334 2024.10.09 22:55:41.614281 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} <Debug> oximeter.measurements_u32 (0fc7ac17-3c2b-4a70-92cd-292b986d9307): There are no data parts
335 2024.10.09 22:55:41.615940 [ 3 ] {526a4d8e-8208-4820-881b-e316dc89c0ce} <Debug> DynamicQueryHandler: Done processing query
336 2024.10.09 22:55:41.615964 [ 3 ] {} <Debug> HTTP-Session: 3f055ea1-4851-499f-8ea7-056097f6dbac Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
337 2024.10.09 22:55:41.616496 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
338 2024.10.09 22:55:41.616571 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
339 2024.10.09 22:55:41.616595 [ 3 ] {} <Debug> HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Authenticating user 'default' from [::1]:33250
340 2024.10.09 22:55:41.616622 [ 3 ] {} <Debug> HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
341 2024.10.09 22:55:41.616638 [ 3 ] {} <Debug> HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
342 2024.10.09 22:55:41.616676 [ 3 ] {} <Trace> HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
343 2024.10.09 22:55:41.616940 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} <Debug> executeQuery: (from [::1]:33250) 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)
344 2024.10.09 22:55:41.616994 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
345 2024.10.09 22:55:41.619174 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} <Debug> oximeter.measurements_i64 (e2e9aa12-bb57-4a2a-aaae-3d0866d536d1): Loading data parts
346 2024.10.09 22:55:41.619460 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} <Debug> oximeter.measurements_i64 (e2e9aa12-bb57-4a2a-aaae-3d0866d536d1): There are no data parts
347 2024.10.09 22:55:41.621060 [ 3 ] {7c8c1f92-1055-441b-ac62-e73b66baf30a} <Debug> DynamicQueryHandler: Done processing query
348 2024.10.09 22:55:41.621127 [ 3 ] {} <Debug> HTTP-Session: dcf48f01-689e-44cf-bfb7-de012fc3b11e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
349 2024.10.09 22:55:41.621531 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
350 2024.10.09 22:55:41.621580 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
351 2024.10.09 22:55:41.621604 [ 3 ] {} <Debug> HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Authenticating user 'default' from [::1]:33250
352 2024.10.09 22:55:41.621618 [ 3 ] {} <Debug> HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
353 2024.10.09 22:55:41.621628 [ 3 ] {} <Debug> HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
354 2024.10.09 22:55:41.621666 [ 3 ] {} <Trace> HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
355 2024.10.09 22:55:41.621856 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} <Debug> executeQuery: (from [::1]:33250) 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)
356 2024.10.09 22:55:41.621903 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
357 2024.10.09 22:55:41.623815 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} <Debug> oximeter.measurements_u64 (83fb8ff2-a618-4de5-82e1-2d80bf206a8f): Loading data parts
358 2024.10.09 22:55:41.624088 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} <Debug> oximeter.measurements_u64 (83fb8ff2-a618-4de5-82e1-2d80bf206a8f): There are no data parts
359 2024.10.09 22:55:41.625722 [ 3 ] {e7d2b062-1a14-4b9c-b0dd-2e2d19c1c6b2} <Debug> DynamicQueryHandler: Done processing query
360 2024.10.09 22:55:41.625747 [ 3 ] {} <Debug> HTTP-Session: 2a04fdee-d28d-410c-bee8-f1c88f875ae5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
361 2024.10.09 22:55:41.626228 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
362 2024.10.09 22:55:41.626352 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
363 2024.10.09 22:55:41.626374 [ 3 ] {} <Debug> HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Authenticating user 'default' from [::1]:33250
364 2024.10.09 22:55:41.626393 [ 3 ] {} <Debug> HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
365 2024.10.09 22:55:41.626417 [ 3 ] {} <Debug> HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
366 2024.10.09 22:55:41.626452 [ 3 ] {} <Trace> HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
367 2024.10.09 22:55:41.626701 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} <Debug> executeQuery: (from [::1]:33250) 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)
368 2024.10.09 22:55:41.626766 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
369 2024.10.09 22:55:41.629022 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} <Debug> oximeter.measurements_f32 (d3c26788-af2a-425b-ba47-b41654f63e6c): Loading data parts
370 2024.10.09 22:55:41.629733 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} <Debug> oximeter.measurements_f32 (d3c26788-af2a-425b-ba47-b41654f63e6c): There are no data parts
371 2024.10.09 22:55:41.631426 [ 3 ] {7c128f7d-0cf9-4d79-8811-b57bad38472c} <Debug> DynamicQueryHandler: Done processing query
372 2024.10.09 22:55:41.631481 [ 3 ] {} <Debug> HTTP-Session: 4a4d8540-ac0f-4065-a8c3-dab6c4be24bb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
373 2024.10.09 22:55:41.632501 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
374 2024.10.09 22:55:41.632557 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
375 2024.10.09 22:55:41.632585 [ 3 ] {} <Debug> HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Authenticating user 'default' from [::1]:33250
376 2024.10.09 22:55:41.632604 [ 3 ] {} <Debug> HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
377 2024.10.09 22:55:41.632617 [ 3 ] {} <Debug> HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
378 2024.10.09 22:55:41.632653 [ 3 ] {} <Trace> HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
379 2024.10.09 22:55:41.633500 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} <Debug> executeQuery: (from [::1]:33250) 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)
380 2024.10.09 22:55:41.633636 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
381 2024.10.09 22:55:41.636162 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} <Debug> oximeter.measurements_f64 (78c03f87-9f53-4fba-ab08-5504e9cb2fda): Loading data parts
382 2024.10.09 22:55:41.636436 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} <Debug> oximeter.measurements_f64 (78c03f87-9f53-4fba-ab08-5504e9cb2fda): There are no data parts
383 2024.10.09 22:55:41.638167 [ 3 ] {2ae1a155-feb1-4770-9ca2-bf74a1b57083} <Debug> DynamicQueryHandler: Done processing query
384 2024.10.09 22:55:41.638194 [ 3 ] {} <Debug> HTTP-Session: 35f3914c-9e6c-4277-b17b-4c9c28a6aad7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
385 2024.10.09 22:55:41.639165 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
386 2024.10.09 22:55:41.639269 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
387 2024.10.09 22:55:41.639295 [ 3 ] {} <Debug> HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Authenticating user 'default' from [::1]:33250
388 2024.10.09 22:55:41.639314 [ 3 ] {} <Debug> HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
389 2024.10.09 22:55:41.639341 [ 3 ] {} <Debug> HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
390 2024.10.09 22:55:41.639398 [ 3 ] {} <Trace> HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
391 2024.10.09 22:55:41.639597 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} <Debug> executeQuery: (from [::1]:33250) 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)
392 2024.10.09 22:55:41.639665 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
393 2024.10.09 22:55:41.643434 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} <Debug> oximeter.measurements_string (b9d61580-a40a-49ad-9fa1-5073eae36896): Loading data parts
394 2024.10.09 22:55:41.643766 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} <Debug> oximeter.measurements_string (b9d61580-a40a-49ad-9fa1-5073eae36896): There are no data parts
395 2024.10.09 22:55:41.646489 [ 3 ] {c6c4189d-eae8-4fc3-8820-23ce4e7d14fa} <Debug> DynamicQueryHandler: Done processing query
396 2024.10.09 22:55:41.646518 [ 3 ] {} <Debug> HTTP-Session: 4bcccb2a-56e8-4a06-a03e-2d84fb1fd55c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
397 2024.10.09 22:55:41.650506 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
398 2024.10.09 22:55:41.650948 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
399 2024.10.09 22:55:41.650982 [ 3 ] {} <Debug> HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Authenticating user 'default' from [::1]:33250
400 2024.10.09 22:55:41.651158 [ 3 ] {} <Debug> HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
401 2024.10.09 22:55:41.651223 [ 3 ] {} <Debug> HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
402 2024.10.09 22:55:41.651281 [ 3 ] {} <Trace> HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
403 2024.10.09 22:55:41.651890 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} <Debug> executeQuery: (from [::1]:33250) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /*
404 * NOTE: Right now we can't unambiguously record a nullable byte array.
405 * Arrays cannot be nested in `Nullable()` types, and encoding the array as
406 * a string isn't palatable for a few reasons.
407 * See: https://github.com/oxidecomputer/omicron/issues/4551 for more
408 * details.
409 */
410 datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
411 2024.10.09 22:55:41.651983 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
412 2024.10.09 22:55:41.655701 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} <Debug> oximeter.measurements_bytes (1787bff8-de9f-4e90-994e-134e9e9a99e5): Loading data parts
413 2024.10.09 22:55:41.656289 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} <Debug> oximeter.measurements_bytes (1787bff8-de9f-4e90-994e-134e9e9a99e5): There are no data parts
414 2024.10.09 22:55:41.658204 [ 3 ] {2806b86a-a9ea-455d-b1ef-f3140d0b2800} <Debug> DynamicQueryHandler: Done processing query
415 2024.10.09 22:55:41.658231 [ 3 ] {} <Debug> HTTP-Session: 7a0b6e88-37da-4363-a466-0b9cd6892753 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
416 2024.10.09 22:55:41.659727 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
417 2024.10.09 22:55:41.659790 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
418 2024.10.09 22:55:41.659810 [ 3 ] {} <Debug> HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Authenticating user 'default' from [::1]:33250
419 2024.10.09 22:55:41.659846 [ 3 ] {} <Debug> HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
420 2024.10.09 22:55:41.659860 [ 3 ] {} <Debug> HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
421 2024.10.09 22:55:41.659950 [ 3 ] {} <Trace> HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
422 2024.10.09 22:55:41.660248 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} <Debug> executeQuery: (from [::1]:33250) 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)
423 2024.10.09 22:55:41.660354 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
424 2024.10.09 22:55:41.662585 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} <Debug> oximeter.measurements_cumulativei64 (d3f9e3b8-9c91-4856-88d5-70d8d9fa4b9f): Loading data parts
425 2024.10.09 22:55:41.662903 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} <Debug> oximeter.measurements_cumulativei64 (d3f9e3b8-9c91-4856-88d5-70d8d9fa4b9f): There are no data parts
426 2024.10.09 22:55:41.664937 [ 3 ] {33a35d91-1924-4b1f-a5a2-e1744fbbbe69} <Debug> DynamicQueryHandler: Done processing query
427 2024.10.09 22:55:41.664966 [ 3 ] {} <Debug> HTTP-Session: f2e704d5-5159-4d32-83bb-8f1e47b7ae3f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
428 2024.10.09 22:55:41.666133 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
429 2024.10.09 22:55:41.666317 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
430 2024.10.09 22:55:41.666348 [ 3 ] {} <Debug> HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Authenticating user 'default' from [::1]:33250
431 2024.10.09 22:55:41.666370 [ 3 ] {} <Debug> HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
432 2024.10.09 22:55:41.666397 [ 3 ] {} <Debug> HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
433 2024.10.09 22:55:41.666439 [ 3 ] {} <Trace> HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
434 2024.10.09 22:55:41.666743 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} <Debug> executeQuery: (from [::1]:33250) 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)
435 2024.10.09 22:55:41.666844 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
436 2024.10.09 22:55:41.670707 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} <Debug> oximeter.measurements_cumulativeu64 (a7ad0f82-8a7c-42a0-912f-74f079bcb834): Loading data parts
437 2024.10.09 22:55:41.671065 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} <Debug> oximeter.measurements_cumulativeu64 (a7ad0f82-8a7c-42a0-912f-74f079bcb834): There are no data parts
438 2024.10.09 22:55:41.673128 [ 3 ] {e0463474-cd77-463d-a757-32cc9fdc553e} <Debug> DynamicQueryHandler: Done processing query
439 2024.10.09 22:55:41.673174 [ 3 ] {} <Debug> HTTP-Session: d63a4b21-9b60-4dbe-adfd-3467bd48effd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
440 2024.10.09 22:55:41.677562 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
441 2024.10.09 22:55:41.677637 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
442 2024.10.09 22:55:41.677680 [ 3 ] {} <Debug> HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Authenticating user 'default' from [::1]:33250
443 2024.10.09 22:55:41.677706 [ 3 ] {} <Debug> HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
444 2024.10.09 22:55:41.677721 [ 3 ] {} <Debug> HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
445 2024.10.09 22:55:41.677778 [ 3 ] {} <Trace> HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
446 2024.10.09 22:55:41.678309 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} <Debug> executeQuery: (from [::1]:33250) 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)
447 2024.10.09 22:55:41.678394 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
448 2024.10.09 22:55:41.683247 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} <Debug> oximeter.measurements_cumulativef32 (d361cd63-5409-4772-8694-a1e356ae217a): Loading data parts
449 2024.10.09 22:55:41.683596 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} <Debug> oximeter.measurements_cumulativef32 (d361cd63-5409-4772-8694-a1e356ae217a): There are no data parts
450 2024.10.09 22:55:41.686705 [ 3 ] {34fa354f-5d3c-4ba3-8c63-87fa065a6470} <Debug> DynamicQueryHandler: Done processing query
451 2024.10.09 22:55:41.686735 [ 3 ] {} <Debug> HTTP-Session: df4a0d17-6036-40b6-90f8-5ac744bcc1a3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
452 2024.10.09 22:55:41.688215 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
453 2024.10.09 22:55:41.688372 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
454 2024.10.09 22:55:41.688440 [ 3 ] {} <Debug> HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Authenticating user 'default' from [::1]:33250
455 2024.10.09 22:55:41.688507 [ 3 ] {} <Debug> HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
456 2024.10.09 22:55:41.688609 [ 3 ] {} <Debug> HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
457 2024.10.09 22:55:41.688668 [ 3 ] {} <Trace> HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
458 2024.10.09 22:55:41.688996 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} <Debug> executeQuery: (from [::1]:33250) 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)
459 2024.10.09 22:55:41.689334 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
460 2024.10.09 22:55:41.691976 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} <Debug> oximeter.measurements_cumulativef64 (4b7d39e3-662a-4cbf-b375-5bf4c51500e0): Loading data parts
461 2024.10.09 22:55:41.692300 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} <Debug> oximeter.measurements_cumulativef64 (4b7d39e3-662a-4cbf-b375-5bf4c51500e0): There are no data parts
462 2024.10.09 22:55:41.694485 [ 3 ] {f2e61170-7eb6-4736-b9a7-a0f718e4a709} <Debug> DynamicQueryHandler: Done processing query
463 2024.10.09 22:55:41.694514 [ 3 ] {} <Debug> HTTP-Session: 38ce322b-57ce-4ad8-a7d0-fd7428fc12de Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
464 2024.10.09 22:55:41.699662 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
465 2024.10.09 22:55:41.699757 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
466 2024.10.09 22:55:41.699782 [ 3 ] {} <Debug> HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Authenticating user 'default' from [::1]:33250
467 2024.10.09 22:55:41.699807 [ 3 ] {} <Debug> HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
468 2024.10.09 22:55:41.699820 [ 3 ] {} <Debug> HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
469 2024.10.09 22:55:41.699877 [ 3 ] {} <Trace> HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
470 2024.10.09 22:55:41.700315 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} <Debug> executeQuery: (from [::1]:33250) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /*
471 * NOTE: Array types cannot be Nullable, see
472 * https://clickhouse.com/docs/en/sql-reference/data-types/nullable
473 * for more details.
474 *
475 * This means we need to use empty arrays to indicate a missing value. This
476 * is unfortunate, and at this point relies on the fact that an
477 * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need
478 * to figure out another way to represent missing samples here.
479 */
480 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)
481 2024.10.09 22:55:41.700408 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
482 2024.10.09 22:55:41.703102 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} <Debug> oximeter.measurements_histogrami8 (e562d6a8-a28f-4ce4-b975-73f6ccd65ea3): Loading data parts
483 2024.10.09 22:55:41.703431 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} <Debug> oximeter.measurements_histogrami8 (e562d6a8-a28f-4ce4-b975-73f6ccd65ea3): There are no data parts
484 2024.10.09 22:55:41.704963 [ 3 ] {a8f468fb-23c3-43d4-9916-fdfc1d14c8a3} <Debug> DynamicQueryHandler: Done processing query
485 2024.10.09 22:55:41.704989 [ 3 ] {} <Debug> HTTP-Session: c81a812e-bd75-4842-b780-94d732bde7bc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
486 2024.10.09 22:55:41.707973 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
487 2024.10.09 22:55:41.708064 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
488 2024.10.09 22:55:41.708094 [ 3 ] {} <Debug> HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Authenticating user 'default' from [::1]:33250
489 2024.10.09 22:55:41.708116 [ 3 ] {} <Debug> HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
490 2024.10.09 22:55:41.708144 [ 3 ] {} <Debug> HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
491 2024.10.09 22:55:41.708191 [ 3 ] {} <Trace> HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
492 2024.10.09 22:55:41.708591 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} <Debug> executeQuery: (from [::1]:33250) 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)
493 2024.10.09 22:55:41.708664 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
494 2024.10.09 22:55:41.711123 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} <Debug> oximeter.measurements_histogramu8 (be25e011-6d4b-40ae-aaf6-e373e87318c7): Loading data parts
495 2024.10.09 22:55:41.711426 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} <Debug> oximeter.measurements_histogramu8 (be25e011-6d4b-40ae-aaf6-e373e87318c7): There are no data parts
496 2024.10.09 22:55:41.713597 [ 3 ] {f8068415-1930-4242-8316-79acd12bfce3} <Debug> DynamicQueryHandler: Done processing query
497 2024.10.09 22:55:41.713632 [ 3 ] {} <Debug> HTTP-Session: 73cb0d48-29ae-425d-9e67-24ef6b8d6b73 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
498 2024.10.09 22:55:41.715570 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
499 2024.10.09 22:55:41.715627 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
500 2024.10.09 22:55:41.715655 [ 3 ] {} <Debug> HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Authenticating user 'default' from [::1]:33250
501 2024.10.09 22:55:41.715671 [ 3 ] {} <Debug> HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
502 2024.10.09 22:55:41.715683 [ 3 ] {} <Debug> HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
503 2024.10.09 22:55:41.715723 [ 3 ] {} <Trace> HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
504 2024.10.09 22:55:41.716110 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} <Debug> executeQuery: (from [::1]:33250) 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)
505 2024.10.09 22:55:41.716179 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
506 2024.10.09 22:55:41.718674 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} <Debug> oximeter.measurements_histogrami16 (e09dfd1c-b2c9-4817-b0a7-17fb097d5802): Loading data parts
507 2024.10.09 22:55:41.718920 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} <Debug> oximeter.measurements_histogrami16 (e09dfd1c-b2c9-4817-b0a7-17fb097d5802): There are no data parts
508 2024.10.09 22:55:41.720580 [ 3 ] {e0ed6895-2ddf-4d5f-9193-07e81f013966} <Debug> DynamicQueryHandler: Done processing query
509 2024.10.09 22:55:41.720602 [ 3 ] {} <Debug> HTTP-Session: 8247583e-c11c-44d8-8284-21f0731c11fb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
510 2024.10.09 22:55:41.782789 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
511 2024.10.09 22:55:41.783051 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
512 2024.10.09 22:55:41.783086 [ 3 ] {} <Debug> HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Authenticating user 'default' from [::1]:33250
513 2024.10.09 22:55:41.783118 [ 3 ] {} <Debug> HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
514 2024.10.09 22:55:41.783159 [ 3 ] {} <Debug> HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
515 2024.10.09 22:55:41.783217 [ 3 ] {} <Trace> HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
516 2024.10.09 22:55:41.783761 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} <Debug> executeQuery: (from [::1]:33250) 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)
517 2024.10.09 22:55:41.783867 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
518 2024.10.09 22:55:41.787948 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} <Debug> oximeter.measurements_histogramu16 (caa8ba1b-044e-4a0b-9546-dfd2c8a7da96): Loading data parts
519 2024.10.09 22:55:41.788359 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} <Debug> oximeter.measurements_histogramu16 (caa8ba1b-044e-4a0b-9546-dfd2c8a7da96): There are no data parts
520 2024.10.09 22:55:41.790440 [ 3 ] {d989b529-0360-4a6b-8403-198127feb5de} <Debug> DynamicQueryHandler: Done processing query
521 2024.10.09 22:55:41.790481 [ 3 ] {} <Debug> HTTP-Session: 56023c48-2e50-47cb-af9e-031b65a0cb80 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
522 2024.10.09 22:55:41.799213 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
523 2024.10.09 22:55:41.799327 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
524 2024.10.09 22:55:41.799356 [ 3 ] {} <Debug> HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Authenticating user 'default' from [::1]:33250
525 2024.10.09 22:55:41.799401 [ 3 ] {} <Debug> HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
526 2024.10.09 22:55:41.799417 [ 3 ] {} <Debug> HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
527 2024.10.09 22:55:41.799539 [ 3 ] {} <Trace> HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
528 2024.10.09 22:55:41.800439 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} <Debug> executeQuery: (from [::1]:33250) 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)
529 2024.10.09 22:55:41.800960 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
530 2024.10.09 22:55:41.804836 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} <Debug> oximeter.measurements_histogrami32 (2ee06efc-1459-49c0-9c89-f9b572f5b35f): Loading data parts
531 2024.10.09 22:55:41.805113 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} <Debug> oximeter.measurements_histogrami32 (2ee06efc-1459-49c0-9c89-f9b572f5b35f): There are no data parts
532 2024.10.09 22:55:41.807622 [ 3 ] {5b09739a-292b-4a45-ae1f-ec7b4b3e81ab} <Debug> DynamicQueryHandler: Done processing query
533 2024.10.09 22:55:41.807655 [ 3 ] {} <Debug> HTTP-Session: 431cf9cd-2533-4f29-ab30-892ed8b30c18 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
534 2024.10.09 22:55:41.808918 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
535 2024.10.09 22:55:41.809132 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
536 2024.10.09 22:55:41.809165 [ 3 ] {} <Debug> HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Authenticating user 'default' from [::1]:33250
537 2024.10.09 22:55:41.809186 [ 3 ] {} <Debug> HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
538 2024.10.09 22:55:41.809207 [ 3 ] {} <Debug> HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
539 2024.10.09 22:55:41.809320 [ 3 ] {} <Trace> HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
540 2024.10.09 22:55:41.809811 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} <Debug> executeQuery: (from [::1]:33250) 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)
541 2024.10.09 22:55:41.810271 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
542 2024.10.09 22:55:41.814253 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} <Debug> oximeter.measurements_histogramu32 (a8ac0791-1f74-4264-9902-b3f9217f6d6d): Loading data parts
543 2024.10.09 22:55:41.814721 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} <Debug> oximeter.measurements_histogramu32 (a8ac0791-1f74-4264-9902-b3f9217f6d6d): There are no data parts
544 2024.10.09 22:55:41.816798 [ 3 ] {1ba0b956-5f17-4ddb-9dfc-d0eeffed3196} <Debug> DynamicQueryHandler: Done processing query
545 2024.10.09 22:55:41.816824 [ 3 ] {} <Debug> HTTP-Session: 22638f82-b168-48ed-8af7-803fe76d7ace Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
546 2024.10.09 22:55:41.819337 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
547 2024.10.09 22:55:41.819495 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
548 2024.10.09 22:55:41.819525 [ 3 ] {} <Debug> HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Authenticating user 'default' from [::1]:33250
549 2024.10.09 22:55:41.819565 [ 3 ] {} <Debug> HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
550 2024.10.09 22:55:41.819580 [ 3 ] {} <Debug> HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
551 2024.10.09 22:55:41.819630 [ 3 ] {} <Trace> HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
552 2024.10.09 22:55:41.820203 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} <Debug> executeQuery: (from [::1]:33250) 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)
553 2024.10.09 22:55:41.820324 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
554 2024.10.09 22:55:41.823176 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} <Debug> oximeter.measurements_histogrami64 (79fd0448-5740-48f8-a4a3-458ee231c737): Loading data parts
555 2024.10.09 22:55:41.823523 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} <Debug> oximeter.measurements_histogrami64 (79fd0448-5740-48f8-a4a3-458ee231c737): There are no data parts
556 2024.10.09 22:55:41.825334 [ 3 ] {9fec87b1-d11d-43ca-af13-2e26ee2a4a2a} <Debug> DynamicQueryHandler: Done processing query
557 2024.10.09 22:55:41.825427 [ 3 ] {} <Debug> HTTP-Session: 7220e067-5631-4bc0-bdd5-5e236e45e6f2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
558 2024.10.09 22:55:41.826070 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
559 2024.10.09 22:55:41.826132 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
560 2024.10.09 22:55:41.826164 [ 3 ] {} <Debug> HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Authenticating user 'default' from [::1]:33250
561 2024.10.09 22:55:41.826186 [ 3 ] {} <Debug> HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
562 2024.10.09 22:55:41.826198 [ 3 ] {} <Debug> HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
563 2024.10.09 22:55:41.826248 [ 3 ] {} <Trace> HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
564 2024.10.09 22:55:41.826631 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} <Debug> executeQuery: (from [::1]:33250) 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)
565 2024.10.09 22:55:41.826767 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
566 2024.10.09 22:55:41.829945 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} <Debug> oximeter.measurements_histogramu64 (c1fb6300-d85c-4c42-b202-aa0647cf61f0): Loading data parts
567 2024.10.09 22:55:41.830434 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} <Debug> oximeter.measurements_histogramu64 (c1fb6300-d85c-4c42-b202-aa0647cf61f0): There are no data parts
568 2024.10.09 22:55:41.832324 [ 3 ] {2267cc86-b76a-49fd-8097-d3bce5f22f8c} <Debug> DynamicQueryHandler: Done processing query
569 2024.10.09 22:55:41.832356 [ 3 ] {} <Debug> HTTP-Session: b06f4a60-a96f-4571-b124-3a983488c813 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
570 2024.10.09 22:55:41.833180 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
571 2024.10.09 22:55:41.833330 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
572 2024.10.09 22:55:41.833359 [ 3 ] {} <Debug> HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Authenticating user 'default' from [::1]:33250
573 2024.10.09 22:55:41.833383 [ 3 ] {} <Debug> HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
574 2024.10.09 22:55:41.833413 [ 3 ] {} <Debug> HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
575 2024.10.09 22:55:41.833459 [ 3 ] {} <Trace> HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
576 2024.10.09 22:55:41.834135 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} <Debug> executeQuery: (from [::1]:33250) 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)
577 2024.10.09 22:55:41.834479 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
578 2024.10.09 22:55:41.837629 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} <Debug> oximeter.measurements_histogramf32 (16d66e33-0b7c-4d24-be1b-64a6d2bd4566): Loading data parts
579 2024.10.09 22:55:41.837915 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} <Debug> oximeter.measurements_histogramf32 (16d66e33-0b7c-4d24-be1b-64a6d2bd4566): There are no data parts
580 2024.10.09 22:55:41.839898 [ 3 ] {f24f739c-fed9-4b14-b6a5-9fdcff5789c1} <Debug> DynamicQueryHandler: Done processing query
581 2024.10.09 22:55:41.840005 [ 3 ] {} <Debug> HTTP-Session: 076a2daf-26d6-43bd-aed8-6f3f84a01b91 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
582 2024.10.09 22:55:41.840692 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
583 2024.10.09 22:55:41.840749 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
584 2024.10.09 22:55:41.840827 [ 3 ] {} <Debug> HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Authenticating user 'default' from [::1]:33250
585 2024.10.09 22:55:41.840849 [ 3 ] {} <Debug> HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
586 2024.10.09 22:55:41.840859 [ 3 ] {} <Debug> HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
587 2024.10.09 22:55:41.840920 [ 3 ] {} <Trace> HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
588 2024.10.09 22:55:41.841351 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} <Debug> executeQuery: (from [::1]:33250) 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)
589 2024.10.09 22:55:41.841449 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
590 2024.10.09 22:55:41.844457 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} <Debug> oximeter.measurements_histogramf64 (808318be-2f94-4db2-ac81-570104f3ae88): Loading data parts
591 2024.10.09 22:55:41.844775 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} <Debug> oximeter.measurements_histogramf64 (808318be-2f94-4db2-ac81-570104f3ae88): There are no data parts
592 2024.10.09 22:55:41.846823 [ 3 ] {22d35037-373c-4608-927f-8e8e7cad4b34} <Debug> DynamicQueryHandler: Done processing query
593 2024.10.09 22:55:41.846855 [ 3 ] {} <Debug> HTTP-Session: 4277c4fc-bd97-489d-a40a-7058676bf413 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
594 2024.10.09 22:55:41.848120 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
595 2024.10.09 22:55:41.848249 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
596 2024.10.09 22:55:41.848274 [ 3 ] {} <Debug> HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Authenticating user 'default' from [::1]:33250
597 2024.10.09 22:55:41.848299 [ 3 ] {} <Debug> HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
598 2024.10.09 22:55:41.848325 [ 3 ] {} <Debug> HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
599 2024.10.09 22:55:41.848372 [ 3 ] {} <Trace> HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
600 2024.10.09 22:55:41.848614 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} <Debug> executeQuery: (from [::1]:33250) /* The field tables store named dimensions of each timeseries.
601 *
602 * As with the measurement tables, there is one field table for each field data
603 * type. Fields are deduplicated by using the "replacing merge tree", though
604 * this behavior **must not** be relied upon for query correctness.
605 *
606 * The index for the fields differs from the measurements, however. Rows are
607 * sorted by timeseries name, then field name, field value, and finally
608 * timeseries key. This reflects the most common pattern for looking them up:
609 * by field name and possibly value, within a timeseries. The resulting keys are
610 * usually then used to look up measurements.
611 *
612 * NOTE: We may want to consider a secondary index on these tables, sorting by
613 * timeseries name and then key, since it would improve lookups where one
614 * already has the key. Realistically though, these tables are quite small and
615 * so performance benefits will be low in absolute terms.
616 *
617 * TTL: We use a materialized column to expire old field table records. This
618 * column is generated automatically by the database whenever a new row is
619 * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *`
620 * query. Since these tables are `ReplacingMergeTree`s, that means the last
621 * record will remain during a deduplication, which will have the last
622 * timestamp. ClickHouse will then expire old data for us, similar to the
623 * measurement tables.
624 */
625 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)
626 2024.10.09 22:55:41.848723 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
627 2024.10.09 22:55:41.851248 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} <Debug> oximeter.fields_bool (03b31b64-8ac4-408a-9ffb-922a41d4d9bb): Loading data parts
628 2024.10.09 22:55:41.851537 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} <Debug> oximeter.fields_bool (03b31b64-8ac4-408a-9ffb-922a41d4d9bb): There are no data parts
629 2024.10.09 22:55:41.853147 [ 3 ] {461caa96-e911-4b42-b8ed-f48e85bc5a4f} <Debug> DynamicQueryHandler: Done processing query
630 2024.10.09 22:55:41.853194 [ 3 ] {} <Debug> HTTP-Session: 2535a509-31f1-48e9-b160-6dddea96e638 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
631 2024.10.09 22:55:41.853824 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
632 2024.10.09 22:55:41.853889 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
633 2024.10.09 22:55:41.853912 [ 3 ] {} <Debug> HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Authenticating user 'default' from [::1]:33250
634 2024.10.09 22:55:41.854007 [ 3 ] {} <Debug> HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
635 2024.10.09 22:55:41.854022 [ 3 ] {} <Debug> HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
636 2024.10.09 22:55:41.854062 [ 3 ] {} <Trace> HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
637 2024.10.09 22:55:41.854371 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} <Debug> executeQuery: (from [::1]:33250) 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)
638 2024.10.09 22:55:41.854432 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
639 2024.10.09 22:55:41.856781 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} <Debug> oximeter.fields_i8 (efc11e9f-db80-457e-bc37-c0403686a281): Loading data parts
640 2024.10.09 22:55:41.857090 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} <Debug> oximeter.fields_i8 (efc11e9f-db80-457e-bc37-c0403686a281): There are no data parts
641 2024.10.09 22:55:41.858846 [ 3 ] {e4ec0543-3778-44d6-894c-11a945b584ee} <Debug> DynamicQueryHandler: Done processing query
642 2024.10.09 22:55:41.858948 [ 3 ] {} <Debug> HTTP-Session: 34ff3655-42a7-4c9c-a14d-a13731a7eb9f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
643 2024.10.09 22:55:41.859500 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
644 2024.10.09 22:55:41.859626 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
645 2024.10.09 22:55:41.859756 [ 3 ] {} <Debug> HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Authenticating user 'default' from [::1]:33250
646 2024.10.09 22:55:41.859781 [ 3 ] {} <Debug> HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
647 2024.10.09 22:55:41.859797 [ 3 ] {} <Debug> HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
648 2024.10.09 22:55:41.859849 [ 3 ] {} <Trace> HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
649 2024.10.09 22:55:41.860113 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} <Debug> executeQuery: (from [::1]:33250) 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)
650 2024.10.09 22:55:41.860178 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
651 2024.10.09 22:55:41.862561 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} <Debug> oximeter.fields_u8 (e3bfbcb7-89df-464b-948e-dff70951e494): Loading data parts
652 2024.10.09 22:55:41.862834 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} <Debug> oximeter.fields_u8 (e3bfbcb7-89df-464b-948e-dff70951e494): There are no data parts
653 2024.10.09 22:55:41.864594 [ 3 ] {b8a945d8-7b47-4f23-b264-b7d79b29f42b} <Debug> DynamicQueryHandler: Done processing query
654 2024.10.09 22:55:41.864627 [ 3 ] {} <Debug> HTTP-Session: fb742b49-cc57-476e-a490-590fc795d6fc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
655 2024.10.09 22:55:41.865309 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
656 2024.10.09 22:55:41.865443 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
657 2024.10.09 22:55:41.865465 [ 3 ] {} <Debug> HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Authenticating user 'default' from [::1]:33250
658 2024.10.09 22:55:41.865491 [ 3 ] {} <Debug> HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
659 2024.10.09 22:55:41.865515 [ 3 ] {} <Debug> HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
660 2024.10.09 22:55:41.865551 [ 3 ] {} <Trace> HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
661 2024.10.09 22:55:41.866244 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} <Debug> executeQuery: (from [::1]:33250) 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)
662 2024.10.09 22:55:41.866308 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
663 2024.10.09 22:55:41.869133 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} <Debug> oximeter.fields_i16 (8516586c-c896-49e3-9d53-7d9ee3c81c54): Loading data parts
664 2024.10.09 22:55:41.869394 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} <Debug> oximeter.fields_i16 (8516586c-c896-49e3-9d53-7d9ee3c81c54): There are no data parts
665 2024.10.09 22:55:41.871303 [ 3 ] {70adad21-881a-4c1a-b75e-f9c026cd7fef} <Debug> DynamicQueryHandler: Done processing query
666 2024.10.09 22:55:41.871378 [ 3 ] {} <Debug> HTTP-Session: 956012c7-19c3-482b-9f80-122cbfd0dd7c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
667 2024.10.09 22:55:41.872145 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
668 2024.10.09 22:55:41.872210 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
669 2024.10.09 22:55:41.872323 [ 3 ] {} <Debug> HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Authenticating user 'default' from [::1]:33250
670 2024.10.09 22:55:41.872351 [ 3 ] {} <Debug> HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
671 2024.10.09 22:55:41.872366 [ 3 ] {} <Debug> HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
672 2024.10.09 22:55:41.872425 [ 3 ] {} <Trace> HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
673 2024.10.09 22:55:41.872844 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} <Debug> executeQuery: (from [::1]:33250) 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)
674 2024.10.09 22:55:41.872927 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
675 2024.10.09 22:55:41.875614 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} <Debug> oximeter.fields_u16 (b6ed26de-9e6a-40cf-9f27-2fb4a3df9767): Loading data parts
676 2024.10.09 22:55:41.875962 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} <Debug> oximeter.fields_u16 (b6ed26de-9e6a-40cf-9f27-2fb4a3df9767): There are no data parts
677 2024.10.09 22:55:41.877741 [ 3 ] {570bb446-64bd-411e-aaf8-4f9897d0dbc8} <Debug> DynamicQueryHandler: Done processing query
678 2024.10.09 22:55:41.877770 [ 3 ] {} <Debug> HTTP-Session: 0378f285-e065-40b0-80c3-0e9f1ff2d83c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
679 2024.10.09 22:55:41.878315 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
680 2024.10.09 22:55:41.878440 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
681 2024.10.09 22:55:41.878467 [ 3 ] {} <Debug> HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Authenticating user 'default' from [::1]:33250
682 2024.10.09 22:55:41.878486 [ 3 ] {} <Debug> HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
683 2024.10.09 22:55:41.878574 [ 3 ] {} <Debug> HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
684 2024.10.09 22:55:41.878614 [ 3 ] {} <Trace> HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
685 2024.10.09 22:55:41.878924 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} <Debug> executeQuery: (from [::1]:33250) 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)
686 2024.10.09 22:55:41.879002 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
687 2024.10.09 22:55:41.881212 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} <Debug> oximeter.fields_i32 (52047e55-858e-4489-b426-b63002d8587f): Loading data parts
688 2024.10.09 22:55:41.881671 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} <Debug> oximeter.fields_i32 (52047e55-858e-4489-b426-b63002d8587f): There are no data parts
689 2024.10.09 22:55:41.883319 [ 3 ] {83e5b5a1-c060-47a1-a241-9156aaca2b80} <Debug> DynamicQueryHandler: Done processing query
690 2024.10.09 22:55:41.883441 [ 3 ] {} <Debug> HTTP-Session: c45cb320-0c7e-4f25-95df-a130f585bc1f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
691 2024.10.09 22:55:41.884143 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
692 2024.10.09 22:55:41.884267 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
693 2024.10.09 22:55:41.884321 [ 3 ] {} <Debug> HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Authenticating user 'default' from [::1]:33250
694 2024.10.09 22:55:41.884342 [ 3 ] {} <Debug> HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
695 2024.10.09 22:55:41.884358 [ 3 ] {} <Debug> HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
696 2024.10.09 22:55:41.884409 [ 3 ] {} <Trace> HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
697 2024.10.09 22:55:41.884758 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} <Debug> executeQuery: (from [::1]:33250) 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)
698 2024.10.09 22:55:41.884934 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
699 2024.10.09 22:55:41.887710 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} <Debug> oximeter.fields_u32 (0aa338a0-4c78-4185-87d6-402c0b9ee35f): Loading data parts
700 2024.10.09 22:55:41.887956 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} <Debug> oximeter.fields_u32 (0aa338a0-4c78-4185-87d6-402c0b9ee35f): There are no data parts
701 2024.10.09 22:55:41.889700 [ 3 ] {44919c88-8a63-4079-85a2-0ef9563793e9} <Debug> DynamicQueryHandler: Done processing query
702 2024.10.09 22:55:41.889758 [ 3 ] {} <Debug> HTTP-Session: 244ce8f5-134b-4329-b617-bdfb88ede5a4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
703 2024.10.09 22:55:41.890262 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
704 2024.10.09 22:55:41.890380 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
705 2024.10.09 22:55:41.890401 [ 3 ] {} <Debug> HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Authenticating user 'default' from [::1]:33250
706 2024.10.09 22:55:41.890426 [ 3 ] {} <Debug> HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
707 2024.10.09 22:55:41.890451 [ 3 ] {} <Debug> HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
708 2024.10.09 22:55:41.890515 [ 3 ] {} <Trace> HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
709 2024.10.09 22:55:41.890731 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} <Debug> executeQuery: (from [::1]:33250) 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)
710 2024.10.09 22:55:41.890839 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
711 2024.10.09 22:55:41.893148 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} <Debug> oximeter.fields_i64 (6f5c8688-0a01-4560-8537-15b148ce17fc): Loading data parts
712 2024.10.09 22:55:41.893411 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} <Debug> oximeter.fields_i64 (6f5c8688-0a01-4560-8537-15b148ce17fc): There are no data parts
713 2024.10.09 22:55:41.895778 [ 3 ] {6d423377-da37-41e4-8251-c256d2a041d8} <Debug> DynamicQueryHandler: Done processing query
714 2024.10.09 22:55:41.895847 [ 3 ] {} <Debug> HTTP-Session: 7a825e67-affb-4d13-991a-446895009f30 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
715 2024.10.09 22:55:41.896836 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
716 2024.10.09 22:55:41.896905 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
717 2024.10.09 22:55:41.896966 [ 3 ] {} <Debug> HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Authenticating user 'default' from [::1]:33250
718 2024.10.09 22:55:41.896985 [ 3 ] {} <Debug> HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
719 2024.10.09 22:55:41.896996 [ 3 ] {} <Debug> HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
720 2024.10.09 22:55:41.897033 [ 3 ] {} <Trace> HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
721 2024.10.09 22:55:41.897304 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} <Debug> executeQuery: (from [::1]:33250) 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)
722 2024.10.09 22:55:41.897401 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
723 2024.10.09 22:55:41.900466 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} <Debug> oximeter.fields_u64 (a41071e0-9a43-46db-a5b2-414659af02ce): Loading data parts
724 2024.10.09 22:55:41.900851 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} <Debug> oximeter.fields_u64 (a41071e0-9a43-46db-a5b2-414659af02ce): There are no data parts
725 2024.10.09 22:55:41.902748 [ 3 ] {3feee57d-697b-48df-a3dc-a31ef0985f32} <Debug> DynamicQueryHandler: Done processing query
726 2024.10.09 22:55:41.902779 [ 3 ] {} <Debug> HTTP-Session: 0e0d7ccb-cfaf-472d-a975-00dc75eba0b1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
727 2024.10.09 22:55:41.903862 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
728 2024.10.09 22:55:41.903925 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
729 2024.10.09 22:55:41.903948 [ 3 ] {} <Debug> HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Authenticating user 'default' from [::1]:33250
730 2024.10.09 22:55:41.903971 [ 3 ] {} <Debug> HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
731 2024.10.09 22:55:41.903987 [ 3 ] {} <Debug> HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
732 2024.10.09 22:55:41.904030 [ 3 ] {} <Trace> HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
733 2024.10.09 22:55:41.904342 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} <Debug> executeQuery: (from [::1]:33250) 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)
734 2024.10.09 22:55:41.904389 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
735 2024.10.09 22:55:41.906925 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} <Debug> oximeter.fields_ipaddr (1c157377-1674-46b7-a423-509ee51ffb37): Loading data parts
736 2024.10.09 22:55:41.907236 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} <Debug> oximeter.fields_ipaddr (1c157377-1674-46b7-a423-509ee51ffb37): There are no data parts
737 2024.10.09 22:55:41.909195 [ 3 ] {a2456480-65cb-4df3-ae69-f91557ae7c93} <Debug> DynamicQueryHandler: Done processing query
738 2024.10.09 22:55:41.909223 [ 3 ] {} <Debug> HTTP-Session: 6a468ab6-b89e-4382-9378-7863994393f1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
739 2024.10.09 22:55:41.910183 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
740 2024.10.09 22:55:41.910237 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
741 2024.10.09 22:55:41.910261 [ 3 ] {} <Debug> HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Authenticating user 'default' from [::1]:33250
742 2024.10.09 22:55:41.910316 [ 3 ] {} <Debug> HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
743 2024.10.09 22:55:41.910353 [ 3 ] {} <Debug> HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
744 2024.10.09 22:55:41.910446 [ 3 ] {} <Trace> HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
745 2024.10.09 22:55:41.910722 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} <Debug> executeQuery: (from [::1]:33250) 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)
746 2024.10.09 22:55:41.910786 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
747 2024.10.09 22:55:41.913507 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} <Debug> oximeter.fields_string (f3f960c8-59eb-4d52-a021-e1e894158eba): Loading data parts
748 2024.10.09 22:55:41.913776 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} <Debug> oximeter.fields_string (f3f960c8-59eb-4d52-a021-e1e894158eba): There are no data parts
749 2024.10.09 22:55:41.915646 [ 3 ] {182f5c2e-91b6-40c6-80f9-a322e153de83} <Debug> DynamicQueryHandler: Done processing query
750 2024.10.09 22:55:41.915678 [ 3 ] {} <Debug> HTTP-Session: d7f82341-e6d7-4662-b1a6-b23080eca4ec Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
751 2024.10.09 22:55:41.916230 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
752 2024.10.09 22:55:41.916304 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
753 2024.10.09 22:55:41.916327 [ 3 ] {} <Debug> HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Authenticating user 'default' from [::1]:33250
754 2024.10.09 22:55:41.916349 [ 3 ] {} <Debug> HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
755 2024.10.09 22:55:41.916364 [ 3 ] {} <Debug> HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
756 2024.10.09 22:55:41.916403 [ 3 ] {} <Trace> HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
757 2024.10.09 22:55:41.916664 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} <Debug> executeQuery: (from [::1]:33250) 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)
758 2024.10.09 22:55:41.916727 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
759 2024.10.09 22:55:41.919389 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} <Debug> oximeter.fields_uuid (fbe08b88-8716-4cbd-9288-5f75d28cfa73): Loading data parts
760 2024.10.09 22:55:41.919646 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} <Debug> oximeter.fields_uuid (fbe08b88-8716-4cbd-9288-5f75d28cfa73): There are no data parts
761 2024.10.09 22:55:41.921398 [ 3 ] {02d4039f-9abd-420f-a63c-38d7188d21a8} <Debug> DynamicQueryHandler: Done processing query
762 2024.10.09 22:55:41.921427 [ 3 ] {} <Debug> HTTP-Session: b4f0979d-8f85-497a-a71e-64530edef279 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
763 2024.10.09 22:55:41.922040 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
764 2024.10.09 22:55:41.922105 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
765 2024.10.09 22:55:41.922129 [ 3 ] {} <Debug> HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Authenticating user 'default' from [::1]:33250
766 2024.10.09 22:55:41.922151 [ 3 ] {} <Debug> HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
767 2024.10.09 22:55:41.922164 [ 3 ] {} <Debug> HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
768 2024.10.09 22:55:41.922199 [ 3 ] {} <Trace> HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
769 2024.10.09 22:55:41.922541 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} <Debug> executeQuery: (from [::1]:33250) /* The timeseries schema table stores the extracted schema for the samples
770 * oximeter collects.
771 */
772 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)
773 2024.10.09 22:55:41.922626 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
774 2024.10.09 22:55:41.925072 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} <Debug> oximeter.timeseries_schema (d05637a4-532c-4743-bf1b-84f5194ebe8f): Loading data parts
775 2024.10.09 22:55:41.925306 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} <Debug> oximeter.timeseries_schema (d05637a4-532c-4743-bf1b-84f5194ebe8f): There are no data parts
776 2024.10.09 22:55:41.927012 [ 3 ] {3fd5b8a3-628b-4b78-905c-21b4d07599ef} <Debug> DynamicQueryHandler: Done processing query
777 2024.10.09 22:55:41.927034 [ 3 ] {} <Debug> HTTP-Session: fe366447-f719-4bef-93ed-4d6a9224ccdf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
778 2024.10.09 22:55:41.927609 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:33250, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
779 2024.10.09 22:55:41.927671 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
780 2024.10.09 22:55:41.927694 [ 3 ] {} <Debug> HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Authenticating user 'default' from [::1]:33250
781 2024.10.09 22:55:41.927718 [ 3 ] {} <Debug> HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
782 2024.10.09 22:55:41.927735 [ 3 ] {} <Debug> HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
783 2024.10.09 22:55:41.927778 [ 3 ] {} <Trace> HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
784 2024.10.09 22:55:41.927969 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Debug> executeQuery: (from [::1]:33250) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
785 2024.10.09 22:55:41.928152 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
786 2024.10.09 22:55:41.929592 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Trace> oximeter.version (fcc73285-839e-4734-a652-af3fe4b1b91e): Trying to reserve 1.00 MiB using storage policy from min volume index 0
787 2024.10.09 22:55:41.929643 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.09 GiB.
788 2024.10.09 22:55:41.930421 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
789 2024.10.09 22:55:41.930951 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Trace> oximeter.version (fcc73285-839e-4734-a652-af3fe4b1b91e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
790 2024.10.09 22:55:41.931239 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003347 sec., 298.7750224081267 rows/sec., 4.67 KiB/sec.
791 2024.10.09 22:55:41.931427 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Debug> DynamicQueryHandler: Done processing query
792 2024.10.09 22:55:41.931449 [ 3 ] {f453dbf6-dfc7-4351-9a57-53c98fd6b3d3} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB.
793 2024.10.09 22:55:41.931464 [ 3 ] {} <Debug> HTTP-Session: a0f19c43-dc48-4b85-b36f-f07b1a826d97 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
794 2024.10.09 22:55:42.000538 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 174.77 MiB, peak 179.91 MiB, free memory in arenas 0.00 B, will set to 180.19 MiB (RSS), difference: 5.42 MiB