Max level shown:
1 2024.10.09 22:41:12.824910 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 15859
2 2024.10.09 22:41:12.825107 [ 1 ] {} <Information> Application: starting up
3 2024.10.09 22:41:12.825181 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc
4 2024.10.09 22:41:12.836169 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8.
5 2024.10.09 22:41:12.844482 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536
6 2024.10.09 22:41:12.844531 [ 1 ] {} <Debug> Application: Initializing DateLUT.
7 2024.10.09 22:41:12.844544 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
8 2024.10.09 22:41:12.844963 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disks_detached_when_instance_destroyed.15852.1-clickhouse-9A94Bf/datastore/tmp/ to store temporary data in it
9 2024.10.09 22:41:12.845459 [ 1 ] {} <Debug> Application: Initializing interserver credentials.
10 2024.10.09 22:41:12.846216 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
11 2024.10.09 22:41:12.846855 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
12 2024.10.09 22:41:12.847523 [ 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:41:12.847554 [ 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:41:12.847578 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB
15 2024.10.09 22:41:12.847686 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
16 2024.10.09 22:41:12.855082 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
17 2024.10.09 22:41:12.899325 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
18 2024.10.09 22:41:12.900243 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
19 2024.10.09 22:41:12.901543 [ 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:41:12.901600 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
21 2024.10.09 22:41:12.902963 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
22 2024.10.09 22:41:12.903755 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
23 2024.10.09 22:41:12.907914 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
24 2024.10.09 22:41:12.908511 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml
25 2024.10.09 22:41:12.911181 [ 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:41:12.916344 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
27 2024.10.09 22:41:12.917777 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
28 2024.10.09 22:41:12.920353 [ 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:41:12.921713 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
30 2024.10.09 22:41:12.921756 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disks_detached_when_instance_destroyed.15852.1-clickhouse-9A94Bf/datastore/
31 2024.10.09 22:41:12.921830 [ 41 ] {} <Debug> DNSResolver: Updating DNS cache
32 2024.10.09 22:41:12.921897 [ 41 ] {} <Debug> DNSResolver: Updated DNS cache
33 2024.10.09 22:41:12.932316 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
34 2024.10.09 22:41:12.932353 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00020506 sec
35 2024.10.09 22:41:12.932385 [ 1 ] {} <Trace> ReferentialDeps: No tables
36 2024.10.09 22:41:12.932397 [ 1 ] {} <Trace> LoadingDeps: No tables
37 2024.10.09 22:41:12.932531 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables.
38 2024.10.09 22:41:12.932618 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config
39 2024.10.09 22:41:12.932638 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
40 2024.10.09 22:41:12.932666 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
41 2024.10.09 22:41:12.932761 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
42 2024.10.09 22:41:12.932787 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
43 2024.10.09 22:41:12.932820 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
44 2024.10.09 22:41:12.932834 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config
45 2024.10.09 22:41:12.932853 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
46 2024.10.09 22:41:12.932883 [ 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:41:12.932897 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config
48 2024.10.09 22:41:12.932917 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
49 2024.10.09 22:41:12.932929 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
50 2024.10.09 22:41:12.932957 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
51 2024.10.09 22:41:12.932974 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
52 2024.10.09 22:41:12.932988 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
53 2024.10.09 22:41:12.933019 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
54 2024.10.09 22:41:12.933040 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
55 2024.10.09 22:41:12.996153 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
56 2024.10.09 22:41:13.009269 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
57 2024.10.09 22:41:13.009327 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000126554 sec
58 2024.10.09 22:41:13.009343 [ 1 ] {} <Trace> ReferentialDeps: No tables
59 2024.10.09 22:41:13.009355 [ 1 ] {} <Trace> LoadingDeps: No tables
60 2024.10.09 22:41:13.009471 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables.
61 2024.10.09 22:41:13.010307 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disks_detached_when_instance_destroyed.15852.1-clickhouse-9A94Bf/datastore/user_defined/
62 2024.10.09 22:41:13.010627 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
63 2024.10.09 22:41:13.010653 [ 1 ] {} <Debug> Application: Loaded metadata.
64 2024.10.09 22:41:13.010668 [ 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:41:13.010688 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled.
66 2024.10.09 22:41:13.011442 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40607
67 2024.10.09 22:41:13.012061 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41712
68 2024.10.09 22:41:13.053535 [ 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:41:13.181311 [ 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:41:13.181386 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
71 2024.10.09 22:41:13.281992 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40028
72 2024.10.09 22:41:13.282138 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 42993
73 2024.10.09 22:41:13.282290 [ 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:41:13.333532 [ 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:41:13.333575 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
76 2024.10.09 22:41:13.538657 [ 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:41:13.538948 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.03 MiB, free memory in arenas 0.00 B, will set to 178.31 MiB (RSS), difference: 168.44 MiB
78 2024.10.09 22:41:13.539504 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.1848e-05 sec.
79 2024.10.09 22:41:13.540645 [ 1 ] {} <Information> Application: Listening for http://[::1]:40607
80 2024.10.09 22:41:13.540725 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:41712
81 2024.10.09 22:41:13.540790 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
82 2024.10.09 22:41:13.540847 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:40028
83 2024.10.09 22:41:13.540900 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:42993
84 2024.10.09 22:41:13.540954 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
85 2024.10.09 22:41:13.540974 [ 1 ] {} <Information> Application: Ready for connections.
86 2024.10.09 22:41:23.320352 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
87 2024.10.09 22:41:23.320635 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
88 2024.10.09 22:41:23.320667 [ 3 ] {} <Debug> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Authenticating user 'default' from [::1]:54088
89 2024.10.09 22:41:23.320700 [ 3 ] {} <Debug> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
90 2024.10.09 22:41:23.320711 [ 3 ] {} <Debug> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
91 2024.10.09 22:41:23.320825 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
92 2024.10.09 22:41:23.320893 [ 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:41:23.320913 [ 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:41:23.320972 [ 3 ] {} <Trace> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
95 2024.10.09 22:41:23.321577 [ 3 ] {73247b7d-d8ba-491f-8a01-8dc84959b59b} <Debug> executeQuery: (from [::1]:54088) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
96 2024.10.09 22:41:23.330998 [ 3 ] {73247b7d-d8ba-491f-8a01-8dc84959b59b} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:54088) (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:41:23.331271 [ 3 ] {73247b7d-d8ba-491f-8a01-8dc84959b59b} <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:41:23.331623 [ 3 ] {} <Debug> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
147 2024.10.09 22:41:23.427542 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
148 2024.10.09 22:41:23.427690 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
149 2024.10.09 22:41:23.427719 [ 3 ] {} <Debug> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Authenticating user 'default' from [::1]:54088
150 2024.10.09 22:41:23.427747 [ 3 ] {} <Debug> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
151 2024.10.09 22:41:23.427770 [ 3 ] {} <Debug> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
152 2024.10.09 22:41:23.427830 [ 3 ] {} <Trace> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
153 2024.10.09 22:41:23.428157 [ 3 ] {a3e4040a-5031-442e-acf2-8cd6d505fae0} <Debug> executeQuery: (from [::1]:54088) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
154 2024.10.09 22:41:23.428654 [ 3 ] {a3e4040a-5031-442e-acf2-8cd6d505fae0} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:54088) (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:41:23.428842 [ 3 ] {a3e4040a-5031-442e-acf2-8cd6d505fae0} <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:41:23.429061 [ 3 ] {} <Debug> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
205 2024.10.09 22:41:23.432702 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
206 2024.10.09 22:41:23.432847 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
207 2024.10.09 22:41:23.432880 [ 3 ] {} <Debug> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Authenticating user 'default' from [::1]:54088
208 2024.10.09 22:41:23.432911 [ 3 ] {} <Debug> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
209 2024.10.09 22:41:23.432927 [ 3 ] {} <Debug> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
210 2024.10.09 22:41:23.432982 [ 3 ] {} <Trace> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
211 2024.10.09 22:41:23.433256 [ 3 ] {b99b3c35-2081-4209-b760-4498a76113e9} <Debug> executeQuery: (from [::1]:54088) DROP DATABASE IF EXISTS oximeter (stage: Complete)
212 2024.10.09 22:41:23.433566 [ 3 ] {b99b3c35-2081-4209-b760-4498a76113e9} <Debug> DynamicQueryHandler: Done processing query
213 2024.10.09 22:41:23.433593 [ 3 ] {} <Debug> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
214 2024.10.09 22:41:23.434720 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
215 2024.10.09 22:41:23.434800 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
216 2024.10.09 22:41:23.434824 [ 3 ] {} <Debug> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Authenticating user 'default' from [::1]:54088
217 2024.10.09 22:41:23.434844 [ 3 ] {} <Debug> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
218 2024.10.09 22:41:23.434864 [ 3 ] {} <Debug> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
219 2024.10.09 22:41:23.434904 [ 3 ] {} <Trace> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
220 2024.10.09 22:41:23.435032 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Debug> executeQuery: (from [::1]:54088) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
221 2024.10.09 22:41:23.435113 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
222 2024.10.09 22:41:23.436715 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
223 2024.10.09 22:41:23.436751 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.8526e-05 sec
224 2024.10.09 22:41:23.436766 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Trace> ReferentialDeps: No tables
225 2024.10.09 22:41:23.436777 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Trace> LoadingDeps: No tables
226 2024.10.09 22:41:23.436802 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Information> DatabaseAtomic (oximeter): Starting up tables.
227 2024.10.09 22:41:23.436984 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Debug> DynamicQueryHandler: Done processing query
228 2024.10.09 22:41:23.437011 [ 3 ] {} <Debug> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
229 2024.10.09 22:41:23.440454 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
230 2024.10.09 22:41:23.440569 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
231 2024.10.09 22:41:23.440599 [ 3 ] {} <Debug> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Authenticating user 'default' from [::1]:54088
232 2024.10.09 22:41:23.440625 [ 3 ] {} <Debug> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
233 2024.10.09 22:41:23.440641 [ 3 ] {} <Debug> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
234 2024.10.09 22:41:23.440700 [ 3 ] {} <Trace> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
235 2024.10.09 22:41:23.440968 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Debug> executeQuery: (from [::1]:54088) /* 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:41:23.441054 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
238 2024.10.09 22:41:23.442836 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
239 2024.10.09 22:41:23.444090 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Debug> oximeter.version (ecf87412-7125-42ca-af4b-146907caf653): Loading data parts
240 2024.10.09 22:41:23.445838 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Debug> oximeter.version (ecf87412-7125-42ca-af4b-146907caf653): There are no data parts
241 2024.10.09 22:41:23.447763 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Debug> DynamicQueryHandler: Done processing query
242 2024.10.09 22:41:23.447797 [ 3 ] {} <Debug> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
243 2024.10.09 22:41:23.449339 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
244 2024.10.09 22:41:23.449422 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
245 2024.10.09 22:41:23.449447 [ 3 ] {} <Debug> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Authenticating user 'default' from [::1]:54088
246 2024.10.09 22:41:23.449483 [ 3 ] {} <Debug> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
247 2024.10.09 22:41:23.449500 [ 3 ] {} <Debug> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
248 2024.10.09 22:41:23.449551 [ 3 ] {} <Trace> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
249 2024.10.09 22:41:23.449884 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Debug> executeQuery: (from [::1]:54088) /* 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:41:23.449961 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
261 2024.10.09 22:41:23.452566 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Debug> oximeter.measurements_bool (eadd5c04-3804-43a7-94c3-ee8c1a0abf0b): Loading data parts
262 2024.10.09 22:41:23.452943 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Debug> oximeter.measurements_bool (eadd5c04-3804-43a7-94c3-ee8c1a0abf0b): There are no data parts
263 2024.10.09 22:41:23.454755 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Debug> DynamicQueryHandler: Done processing query
264 2024.10.09 22:41:23.454786 [ 3 ] {} <Debug> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
265 2024.10.09 22:41:23.456246 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
266 2024.10.09 22:41:23.456336 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
267 2024.10.09 22:41:23.456360 [ 3 ] {} <Debug> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Authenticating user 'default' from [::1]:54088
268 2024.10.09 22:41:23.456384 [ 3 ] {} <Debug> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
269 2024.10.09 22:41:23.456399 [ 3 ] {} <Debug> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
270 2024.10.09 22:41:23.456460 [ 3 ] {} <Trace> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
271 2024.10.09 22:41:23.456786 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Debug> executeQuery: (from [::1]:54088) 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:41:23.456863 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
273 2024.10.09 22:41:23.459339 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Debug> oximeter.measurements_i8 (9277c57e-a806-4559-abc5-ec6a36a049ad): Loading data parts
274 2024.10.09 22:41:23.459751 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Debug> oximeter.measurements_i8 (9277c57e-a806-4559-abc5-ec6a36a049ad): There are no data parts
275 2024.10.09 22:41:23.461706 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Debug> DynamicQueryHandler: Done processing query
276 2024.10.09 22:41:23.461740 [ 3 ] {} <Debug> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
277 2024.10.09 22:41:23.466389 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
278 2024.10.09 22:41:23.466545 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
279 2024.10.09 22:41:23.466581 [ 3 ] {} <Debug> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Authenticating user 'default' from [::1]:54088
280 2024.10.09 22:41:23.466625 [ 3 ] {} <Debug> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
281 2024.10.09 22:41:23.466641 [ 3 ] {} <Debug> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
282 2024.10.09 22:41:23.466701 [ 3 ] {} <Trace> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
283 2024.10.09 22:41:23.467112 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Debug> executeQuery: (from [::1]:54088) 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:41:23.467185 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
285 2024.10.09 22:41:23.469643 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Debug> oximeter.measurements_u8 (01b47331-4741-4f7c-91bc-6fb5adbac76e): Loading data parts
286 2024.10.09 22:41:23.469930 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Debug> oximeter.measurements_u8 (01b47331-4741-4f7c-91bc-6fb5adbac76e): There are no data parts
287 2024.10.09 22:41:23.471697 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Debug> DynamicQueryHandler: Done processing query
288 2024.10.09 22:41:23.471742 [ 3 ] {} <Debug> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
289 2024.10.09 22:41:23.473243 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
290 2024.10.09 22:41:23.473341 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
291 2024.10.09 22:41:23.473384 [ 3 ] {} <Debug> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Authenticating user 'default' from [::1]:54088
292 2024.10.09 22:41:23.473446 [ 3 ] {} <Debug> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
293 2024.10.09 22:41:23.473472 [ 3 ] {} <Debug> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
294 2024.10.09 22:41:23.473537 [ 3 ] {} <Trace> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
295 2024.10.09 22:41:23.473874 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Debug> executeQuery: (from [::1]:54088) 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:41:23.473959 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
297 2024.10.09 22:41:23.476884 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Debug> oximeter.measurements_i16 (c2d89c15-84ed-4c60-ab88-f764575f311d): Loading data parts
298 2024.10.09 22:41:23.477403 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Debug> oximeter.measurements_i16 (c2d89c15-84ed-4c60-ab88-f764575f311d): There are no data parts
299 2024.10.09 22:41:23.479784 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Debug> DynamicQueryHandler: Done processing query
300 2024.10.09 22:41:23.479818 [ 3 ] {} <Debug> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
301 2024.10.09 22:41:23.483253 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
302 2024.10.09 22:41:23.483376 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
303 2024.10.09 22:41:23.483407 [ 3 ] {} <Debug> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Authenticating user 'default' from [::1]:54088
304 2024.10.09 22:41:23.483436 [ 3 ] {} <Debug> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
305 2024.10.09 22:41:23.483461 [ 3 ] {} <Debug> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
306 2024.10.09 22:41:23.483517 [ 3 ] {} <Trace> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
307 2024.10.09 22:41:23.483963 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Debug> executeQuery: (from [::1]:54088) 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:41:23.484051 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
309 2024.10.09 22:41:23.486765 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Debug> oximeter.measurements_u16 (a78c3eea-3335-43a6-b953-637564bc0df7): Loading data parts
310 2024.10.09 22:41:23.487169 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Debug> oximeter.measurements_u16 (a78c3eea-3335-43a6-b953-637564bc0df7): There are no data parts
311 2024.10.09 22:41:23.488839 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Debug> DynamicQueryHandler: Done processing query
312 2024.10.09 22:41:23.488867 [ 3 ] {} <Debug> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
313 2024.10.09 22:41:23.491156 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
314 2024.10.09 22:41:23.491307 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
315 2024.10.09 22:41:23.491369 [ 3 ] {} <Debug> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Authenticating user 'default' from [::1]:54088
316 2024.10.09 22:41:23.491399 [ 3 ] {} <Debug> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
317 2024.10.09 22:41:23.491416 [ 3 ] {} <Debug> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
318 2024.10.09 22:41:23.491471 [ 3 ] {} <Trace> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
319 2024.10.09 22:41:23.491883 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Debug> executeQuery: (from [::1]:54088) 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:41:23.491975 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
321 2024.10.09 22:41:23.495425 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Debug> oximeter.measurements_i32 (0ecb1402-020f-48ee-9bd6-d557651bb572): Loading data parts
322 2024.10.09 22:41:23.495824 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Debug> oximeter.measurements_i32 (0ecb1402-020f-48ee-9bd6-d557651bb572): There are no data parts
323 2024.10.09 22:41:23.497809 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Debug> DynamicQueryHandler: Done processing query
324 2024.10.09 22:41:23.497846 [ 3 ] {} <Debug> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
325 2024.10.09 22:41:23.502226 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
326 2024.10.09 22:41:23.502357 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
327 2024.10.09 22:41:23.502387 [ 3 ] {} <Debug> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Authenticating user 'default' from [::1]:54088
328 2024.10.09 22:41:23.502414 [ 3 ] {} <Debug> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
329 2024.10.09 22:41:23.502483 [ 3 ] {} <Debug> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
330 2024.10.09 22:41:23.502553 [ 3 ] {} <Trace> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
331 2024.10.09 22:41:23.502931 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Debug> executeQuery: (from [::1]:54088) 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:41:23.503019 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
333 2024.10.09 22:41:23.505592 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Debug> oximeter.measurements_u32 (be5ec839-a0a8-4f52-b92c-1b9af2d4375e): Loading data parts
334 2024.10.09 22:41:23.505969 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Debug> oximeter.measurements_u32 (be5ec839-a0a8-4f52-b92c-1b9af2d4375e): There are no data parts
335 2024.10.09 22:41:23.509623 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Debug> DynamicQueryHandler: Done processing query
336 2024.10.09 22:41:23.509662 [ 3 ] {} <Debug> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
337 2024.10.09 22:41:23.510835 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
338 2024.10.09 22:41:23.511249 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
339 2024.10.09 22:41:23.511286 [ 3 ] {} <Debug> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Authenticating user 'default' from [::1]:54088
340 2024.10.09 22:41:23.511347 [ 3 ] {} <Debug> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
341 2024.10.09 22:41:23.511374 [ 3 ] {} <Debug> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
342 2024.10.09 22:41:23.511433 [ 3 ] {} <Trace> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
343 2024.10.09 22:41:23.511794 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Debug> executeQuery: (from [::1]:54088) 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:41:23.511879 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
345 2024.10.09 22:41:23.514379 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Debug> oximeter.measurements_i64 (b13a9387-fb7d-4029-be93-ae47ae604ff3): Loading data parts
346 2024.10.09 22:41:23.514802 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Debug> oximeter.measurements_i64 (b13a9387-fb7d-4029-be93-ae47ae604ff3): There are no data parts
347 2024.10.09 22:41:23.516619 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Debug> DynamicQueryHandler: Done processing query
348 2024.10.09 22:41:23.516686 [ 3 ] {} <Debug> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
349 2024.10.09 22:41:23.519320 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
350 2024.10.09 22:41:23.519451 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
351 2024.10.09 22:41:23.519484 [ 3 ] {} <Debug> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Authenticating user 'default' from [::1]:54088
352 2024.10.09 22:41:23.519936 [ 3 ] {} <Debug> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
353 2024.10.09 22:41:23.519971 [ 3 ] {} <Debug> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
354 2024.10.09 22:41:23.520070 [ 3 ] {} <Trace> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
355 2024.10.09 22:41:23.520433 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Debug> executeQuery: (from [::1]:54088) 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:41:23.520643 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
357 2024.10.09 22:41:23.523260 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Debug> oximeter.measurements_u64 (51d53275-c66c-4742-a99a-171335ce4c21): Loading data parts
358 2024.10.09 22:41:23.523676 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Debug> oximeter.measurements_u64 (51d53275-c66c-4742-a99a-171335ce4c21): There are no data parts
359 2024.10.09 22:41:23.525510 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Debug> DynamicQueryHandler: Done processing query
360 2024.10.09 22:41:23.525545 [ 3 ] {} <Debug> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
361 2024.10.09 22:41:23.526744 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
362 2024.10.09 22:41:23.526838 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
363 2024.10.09 22:41:23.526862 [ 3 ] {} <Debug> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Authenticating user 'default' from [::1]:54088
364 2024.10.09 22:41:23.526889 [ 3 ] {} <Debug> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
365 2024.10.09 22:41:23.527028 [ 3 ] {} <Debug> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
366 2024.10.09 22:41:23.527100 [ 3 ] {} <Trace> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
367 2024.10.09 22:41:23.527488 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Debug> executeQuery: (from [::1]:54088) 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:41:23.527563 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
369 2024.10.09 22:41:23.530103 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Debug> oximeter.measurements_f32 (1dc49642-ca40-4738-9c5b-222ad09cda9f): Loading data parts
370 2024.10.09 22:41:23.530492 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Debug> oximeter.measurements_f32 (1dc49642-ca40-4738-9c5b-222ad09cda9f): There are no data parts
371 2024.10.09 22:41:23.532265 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Debug> DynamicQueryHandler: Done processing query
372 2024.10.09 22:41:23.532305 [ 3 ] {} <Debug> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
373 2024.10.09 22:41:23.535229 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
374 2024.10.09 22:41:23.535328 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
375 2024.10.09 22:41:23.535382 [ 3 ] {} <Debug> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Authenticating user 'default' from [::1]:54088
376 2024.10.09 22:41:23.535409 [ 3 ] {} <Debug> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
377 2024.10.09 22:41:23.535425 [ 3 ] {} <Debug> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
378 2024.10.09 22:41:23.535489 [ 3 ] {} <Trace> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
379 2024.10.09 22:41:23.535925 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Debug> executeQuery: (from [::1]:54088) 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:41:23.536039 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
381 2024.10.09 22:41:23.538538 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Debug> oximeter.measurements_f64 (460fe727-3d51-4dbc-9fc8-26324ba1640e): Loading data parts
382 2024.10.09 22:41:23.538871 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Debug> oximeter.measurements_f64 (460fe727-3d51-4dbc-9fc8-26324ba1640e): There are no data parts
383 2024.10.09 22:41:23.540777 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Debug> DynamicQueryHandler: Done processing query
384 2024.10.09 22:41:23.540811 [ 3 ] {} <Debug> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
385 2024.10.09 22:41:23.541606 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
386 2024.10.09 22:41:23.541696 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
387 2024.10.09 22:41:23.541725 [ 3 ] {} <Debug> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Authenticating user 'default' from [::1]:54088
388 2024.10.09 22:41:23.541794 [ 3 ] {} <Debug> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
389 2024.10.09 22:41:23.541828 [ 3 ] {} <Debug> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
390 2024.10.09 22:41:23.541885 [ 3 ] {} <Trace> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
391 2024.10.09 22:41:23.542247 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Debug> executeQuery: (from [::1]:54088) 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:41:23.542332 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
393 2024.10.09 22:41:23.545026 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Debug> oximeter.measurements_string (5053afa9-77d6-4d0e-83d5-f09da09d60d1): Loading data parts
394 2024.10.09 22:41:23.545389 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Debug> oximeter.measurements_string (5053afa9-77d6-4d0e-83d5-f09da09d60d1): There are no data parts
395 2024.10.09 22:41:23.547200 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Debug> DynamicQueryHandler: Done processing query
396 2024.10.09 22:41:23.547236 [ 3 ] {} <Debug> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
397 2024.10.09 22:41:23.548379 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
398 2024.10.09 22:41:23.548460 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
399 2024.10.09 22:41:23.548558 [ 3 ] {} <Debug> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Authenticating user 'default' from [::1]:54088
400 2024.10.09 22:41:23.548596 [ 3 ] {} <Debug> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
401 2024.10.09 22:41:23.548616 [ 3 ] {} <Debug> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
402 2024.10.09 22:41:23.548673 [ 3 ] {} <Trace> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
403 2024.10.09 22:41:23.549001 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Debug> executeQuery: (from [::1]:54088) 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:41:23.549082 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
412 2024.10.09 22:41:23.551731 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Debug> oximeter.measurements_bytes (b9ce8d1d-ad9b-47f7-beb1-6252648cac9c): Loading data parts
413 2024.10.09 22:41:23.552356 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Debug> oximeter.measurements_bytes (b9ce8d1d-ad9b-47f7-beb1-6252648cac9c): There are no data parts
414 2024.10.09 22:41:23.554150 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Debug> DynamicQueryHandler: Done processing query
415 2024.10.09 22:41:23.554197 [ 3 ] {} <Debug> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
416 2024.10.09 22:41:23.557251 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
417 2024.10.09 22:41:23.557505 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
418 2024.10.09 22:41:23.557554 [ 3 ] {} <Debug> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Authenticating user 'default' from [::1]:54088
419 2024.10.09 22:41:23.557590 [ 3 ] {} <Debug> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
420 2024.10.09 22:41:23.557606 [ 3 ] {} <Debug> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
421 2024.10.09 22:41:23.557678 [ 3 ] {} <Trace> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
422 2024.10.09 22:41:23.558568 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Debug> executeQuery: (from [::1]:54088) 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:41:23.558715 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
424 2024.10.09 22:41:23.562975 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Debug> oximeter.measurements_cumulativei64 (39ea44c7-908f-4a15-8750-4349363f3bf9): Loading data parts
425 2024.10.09 22:41:23.563384 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Debug> oximeter.measurements_cumulativei64 (39ea44c7-908f-4a15-8750-4349363f3bf9): There are no data parts
426 2024.10.09 22:41:23.565875 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Debug> DynamicQueryHandler: Done processing query
427 2024.10.09 22:41:23.565909 [ 3 ] {} <Debug> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
428 2024.10.09 22:41:23.567459 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
429 2024.10.09 22:41:23.567597 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
430 2024.10.09 22:41:23.567633 [ 3 ] {} <Debug> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Authenticating user 'default' from [::1]:54088
431 2024.10.09 22:41:23.567673 [ 3 ] {} <Debug> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
432 2024.10.09 22:41:23.567700 [ 3 ] {} <Debug> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
433 2024.10.09 22:41:23.567764 [ 3 ] {} <Trace> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
434 2024.10.09 22:41:23.568193 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Debug> executeQuery: (from [::1]:54088) 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:41:23.568348 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
436 2024.10.09 22:41:23.571531 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Debug> oximeter.measurements_cumulativeu64 (ae0bf2c8-240c-47e8-a0ab-8bb743ea420a): Loading data parts
437 2024.10.09 22:41:23.571982 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Debug> oximeter.measurements_cumulativeu64 (ae0bf2c8-240c-47e8-a0ab-8bb743ea420a): There are no data parts
438 2024.10.09 22:41:23.574092 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Debug> DynamicQueryHandler: Done processing query
439 2024.10.09 22:41:23.574143 [ 3 ] {} <Debug> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
440 2024.10.09 22:41:23.575852 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
441 2024.10.09 22:41:23.575928 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
442 2024.10.09 22:41:23.575961 [ 3 ] {} <Debug> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Authenticating user 'default' from [::1]:54088
443 2024.10.09 22:41:23.575982 [ 3 ] {} <Debug> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
444 2024.10.09 22:41:23.575995 [ 3 ] {} <Debug> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
445 2024.10.09 22:41:23.576042 [ 3 ] {} <Trace> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
446 2024.10.09 22:41:23.576707 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Debug> executeQuery: (from [::1]:54088) 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:41:23.576787 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
448 2024.10.09 22:41:23.579770 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Debug> oximeter.measurements_cumulativef32 (1642f5c5-0d5c-4ad7-8661-bbe1e4a8f1cd): Loading data parts
449 2024.10.09 22:41:23.580089 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Debug> oximeter.measurements_cumulativef32 (1642f5c5-0d5c-4ad7-8661-bbe1e4a8f1cd): There are no data parts
450 2024.10.09 22:41:23.582004 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Debug> DynamicQueryHandler: Done processing query
451 2024.10.09 22:41:23.582037 [ 3 ] {} <Debug> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
452 2024.10.09 22:41:23.582759 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
453 2024.10.09 22:41:23.582881 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
454 2024.10.09 22:41:23.582965 [ 3 ] {} <Debug> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Authenticating user 'default' from [::1]:54088
455 2024.10.09 22:41:23.583003 [ 3 ] {} <Debug> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
456 2024.10.09 22:41:23.583020 [ 3 ] {} <Debug> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
457 2024.10.09 22:41:23.583072 [ 3 ] {} <Trace> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
458 2024.10.09 22:41:23.583438 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Debug> executeQuery: (from [::1]:54088) 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:41:23.583550 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
460 2024.10.09 22:41:23.586243 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Debug> oximeter.measurements_cumulativef64 (586e87bd-d9af-4114-bf9a-e05bbccf02ac): Loading data parts
461 2024.10.09 22:41:23.586602 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Debug> oximeter.measurements_cumulativef64 (586e87bd-d9af-4114-bf9a-e05bbccf02ac): There are no data parts
462 2024.10.09 22:41:23.588316 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Debug> DynamicQueryHandler: Done processing query
463 2024.10.09 22:41:23.588343 [ 3 ] {} <Debug> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
464 2024.10.09 22:41:23.595419 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
465 2024.10.09 22:41:23.595599 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
466 2024.10.09 22:41:23.595636 [ 3 ] {} <Debug> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Authenticating user 'default' from [::1]:54088
467 2024.10.09 22:41:23.595667 [ 3 ] {} <Debug> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
468 2024.10.09 22:41:23.595695 [ 3 ] {} <Debug> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
469 2024.10.09 22:41:23.595758 [ 3 ] {} <Trace> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
470 2024.10.09 22:41:23.596644 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Debug> executeQuery: (from [::1]:54088) 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:41:23.596759 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
482 2024.10.09 22:41:23.599936 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Debug> oximeter.measurements_histogrami8 (45ac226b-bc4c-42e1-9760-32db67f94611): Loading data parts
483 2024.10.09 22:41:23.600305 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Debug> oximeter.measurements_histogrami8 (45ac226b-bc4c-42e1-9760-32db67f94611): There are no data parts
484 2024.10.09 22:41:23.602465 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Debug> DynamicQueryHandler: Done processing query
485 2024.10.09 22:41:23.602524 [ 3 ] {} <Debug> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
486 2024.10.09 22:41:23.603649 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
487 2024.10.09 22:41:23.604143 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
488 2024.10.09 22:41:23.604215 [ 3 ] {} <Debug> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Authenticating user 'default' from [::1]:54088
489 2024.10.09 22:41:23.604262 [ 3 ] {} <Debug> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
490 2024.10.09 22:41:23.604281 [ 3 ] {} <Debug> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
491 2024.10.09 22:41:23.604366 [ 3 ] {} <Trace> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
492 2024.10.09 22:41:23.604960 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Debug> executeQuery: (from [::1]:54088) 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:41:23.605062 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
494 2024.10.09 22:41:23.608682 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Debug> oximeter.measurements_histogramu8 (ba5db2b4-1dfd-45ca-80c7-ec22f9386cc9): Loading data parts
495 2024.10.09 22:41:23.609096 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Debug> oximeter.measurements_histogramu8 (ba5db2b4-1dfd-45ca-80c7-ec22f9386cc9): There are no data parts
496 2024.10.09 22:41:23.611349 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Debug> DynamicQueryHandler: Done processing query
497 2024.10.09 22:41:23.611398 [ 3 ] {} <Debug> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
498 2024.10.09 22:41:23.612614 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
499 2024.10.09 22:41:23.612874 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
500 2024.10.09 22:41:23.612924 [ 3 ] {} <Debug> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Authenticating user 'default' from [::1]:54088
501 2024.10.09 22:41:23.612953 [ 3 ] {} <Debug> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
502 2024.10.09 22:41:23.613023 [ 3 ] {} <Debug> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
503 2024.10.09 22:41:23.613140 [ 3 ] {} <Trace> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
504 2024.10.09 22:41:23.613805 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Debug> executeQuery: (from [::1]:54088) 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:41:23.613907 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
506 2024.10.09 22:41:23.616988 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Debug> oximeter.measurements_histogrami16 (7179b1ee-68d3-44b6-827d-8fee16e36810): Loading data parts
507 2024.10.09 22:41:23.617490 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Debug> oximeter.measurements_histogrami16 (7179b1ee-68d3-44b6-827d-8fee16e36810): There are no data parts
508 2024.10.09 22:41:23.619722 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Debug> DynamicQueryHandler: Done processing query
509 2024.10.09 22:41:23.619761 [ 3 ] {} <Debug> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
510 2024.10.09 22:41:23.621445 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
511 2024.10.09 22:41:23.621580 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
512 2024.10.09 22:41:23.621607 [ 3 ] {} <Debug> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Authenticating user 'default' from [::1]:54088
513 2024.10.09 22:41:23.621635 [ 3 ] {} <Debug> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
514 2024.10.09 22:41:23.621661 [ 3 ] {} <Debug> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
515 2024.10.09 22:41:23.622265 [ 3 ] {} <Trace> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
516 2024.10.09 22:41:23.624717 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Debug> executeQuery: (from [::1]:54088) 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:41:23.624929 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
518 2024.10.09 22:41:23.628738 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Debug> oximeter.measurements_histogramu16 (ed3f3bf7-f69b-48cc-964d-d7359c3ebe13): Loading data parts
519 2024.10.09 22:41:23.629341 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Debug> oximeter.measurements_histogramu16 (ed3f3bf7-f69b-48cc-964d-d7359c3ebe13): There are no data parts
520 2024.10.09 22:41:23.631819 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Debug> DynamicQueryHandler: Done processing query
521 2024.10.09 22:41:23.631857 [ 3 ] {} <Debug> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
522 2024.10.09 22:41:23.637728 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
523 2024.10.09 22:41:23.637890 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
524 2024.10.09 22:41:23.637946 [ 3 ] {} <Debug> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Authenticating user 'default' from [::1]:54088
525 2024.10.09 22:41:23.637977 [ 3 ] {} <Debug> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
526 2024.10.09 22:41:23.637994 [ 3 ] {} <Debug> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
527 2024.10.09 22:41:23.638058 [ 3 ] {} <Trace> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
528 2024.10.09 22:41:23.638625 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Debug> executeQuery: (from [::1]:54088) 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:41:23.638729 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
530 2024.10.09 22:41:23.641765 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Debug> oximeter.measurements_histogrami32 (3f33e11b-077b-4f44-9128-fd7f4edfe479): Loading data parts
531 2024.10.09 22:41:23.642114 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Debug> oximeter.measurements_histogrami32 (3f33e11b-077b-4f44-9128-fd7f4edfe479): There are no data parts
532 2024.10.09 22:41:23.644157 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Debug> DynamicQueryHandler: Done processing query
533 2024.10.09 22:41:23.644190 [ 3 ] {} <Debug> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
534 2024.10.09 22:41:23.656638 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
535 2024.10.09 22:41:23.656790 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
536 2024.10.09 22:41:23.656821 [ 3 ] {} <Debug> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Authenticating user 'default' from [::1]:54088
537 2024.10.09 22:41:23.656849 [ 3 ] {} <Debug> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
538 2024.10.09 22:41:23.656880 [ 3 ] {} <Debug> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
539 2024.10.09 22:41:23.656967 [ 3 ] {} <Trace> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
540 2024.10.09 22:41:23.658345 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Debug> executeQuery: (from [::1]:54088) 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:41:23.658460 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
542 2024.10.09 22:41:23.663463 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Debug> oximeter.measurements_histogramu32 (5813191b-7478-483c-a717-9a636b356290): Loading data parts
543 2024.10.09 22:41:23.663809 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Debug> oximeter.measurements_histogramu32 (5813191b-7478-483c-a717-9a636b356290): There are no data parts
544 2024.10.09 22:41:23.665752 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Debug> DynamicQueryHandler: Done processing query
545 2024.10.09 22:41:23.665786 [ 3 ] {} <Debug> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
546 2024.10.09 22:41:23.671881 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
547 2024.10.09 22:41:23.672108 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
548 2024.10.09 22:41:23.672148 [ 3 ] {} <Debug> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Authenticating user 'default' from [::1]:54088
549 2024.10.09 22:41:23.672197 [ 3 ] {} <Debug> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
550 2024.10.09 22:41:23.672216 [ 3 ] {} <Debug> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
551 2024.10.09 22:41:23.672277 [ 3 ] {} <Trace> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
552 2024.10.09 22:41:23.672868 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Debug> executeQuery: (from [::1]:54088) 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:41:23.672976 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
554 2024.10.09 22:41:23.677382 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Debug> oximeter.measurements_histogrami64 (497cebb0-af08-45a9-be93-fbeb47b403b9): Loading data parts
555 2024.10.09 22:41:23.677709 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Debug> oximeter.measurements_histogrami64 (497cebb0-af08-45a9-be93-fbeb47b403b9): There are no data parts
556 2024.10.09 22:41:23.680308 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Debug> DynamicQueryHandler: Done processing query
557 2024.10.09 22:41:23.680374 [ 3 ] {} <Debug> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
558 2024.10.09 22:41:23.681191 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
559 2024.10.09 22:41:23.681286 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
560 2024.10.09 22:41:23.681318 [ 3 ] {} <Debug> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Authenticating user 'default' from [::1]:54088
561 2024.10.09 22:41:23.681347 [ 3 ] {} <Debug> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
562 2024.10.09 22:41:23.681363 [ 3 ] {} <Debug> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
563 2024.10.09 22:41:23.681419 [ 3 ] {} <Trace> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
564 2024.10.09 22:41:23.681879 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Debug> executeQuery: (from [::1]:54088) 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:41:23.682067 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
566 2024.10.09 22:41:23.685176 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Debug> oximeter.measurements_histogramu64 (0fc8a449-d565-42b6-9187-9d9c5f0774fe): Loading data parts
567 2024.10.09 22:41:23.685544 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Debug> oximeter.measurements_histogramu64 (0fc8a449-d565-42b6-9187-9d9c5f0774fe): There are no data parts
568 2024.10.09 22:41:23.688658 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Debug> DynamicQueryHandler: Done processing query
569 2024.10.09 22:41:23.688700 [ 3 ] {} <Debug> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
570 2024.10.09 22:41:23.689775 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
571 2024.10.09 22:41:23.689877 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
572 2024.10.09 22:41:23.689903 [ 3 ] {} <Debug> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Authenticating user 'default' from [::1]:54088
573 2024.10.09 22:41:23.689938 [ 3 ] {} <Debug> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
574 2024.10.09 22:41:23.689955 [ 3 ] {} <Debug> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
575 2024.10.09 22:41:23.690008 [ 3 ] {} <Trace> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
576 2024.10.09 22:41:23.690505 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Debug> executeQuery: (from [::1]:54088) 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:41:23.690960 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
578 2024.10.09 22:41:23.697708 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Debug> oximeter.measurements_histogramf32 (783a716b-0a56-49b8-ae35-edad640637e7): Loading data parts
579 2024.10.09 22:41:23.698259 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Debug> oximeter.measurements_histogramf32 (783a716b-0a56-49b8-ae35-edad640637e7): There are no data parts
580 2024.10.09 22:41:23.704977 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Debug> DynamicQueryHandler: Done processing query
581 2024.10.09 22:41:23.705196 [ 3 ] {} <Debug> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
582 2024.10.09 22:41:23.707403 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
583 2024.10.09 22:41:23.708489 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
584 2024.10.09 22:41:23.708547 [ 3 ] {} <Debug> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Authenticating user 'default' from [::1]:54088
585 2024.10.09 22:41:23.708576 [ 3 ] {} <Debug> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
586 2024.10.09 22:41:23.708593 [ 3 ] {} <Debug> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
587 2024.10.09 22:41:23.708664 [ 3 ] {} <Trace> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
588 2024.10.09 22:41:23.709265 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Debug> executeQuery: (from [::1]:54088) 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:41:23.709458 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
590 2024.10.09 22:41:23.713298 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Debug> oximeter.measurements_histogramf64 (17937a97-76ae-4562-a78c-06bd6714e32f): Loading data parts
591 2024.10.09 22:41:23.716400 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Debug> oximeter.measurements_histogramf64 (17937a97-76ae-4562-a78c-06bd6714e32f): There are no data parts
592 2024.10.09 22:41:23.719432 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Debug> DynamicQueryHandler: Done processing query
593 2024.10.09 22:41:23.719476 [ 3 ] {} <Debug> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
594 2024.10.09 22:41:23.720884 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
595 2024.10.09 22:41:23.721008 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
596 2024.10.09 22:41:23.721163 [ 3 ] {} <Debug> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Authenticating user 'default' from [::1]:54088
597 2024.10.09 22:41:23.721226 [ 3 ] {} <Debug> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
598 2024.10.09 22:41:23.721258 [ 3 ] {} <Debug> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
599 2024.10.09 22:41:23.721325 [ 3 ] {} <Trace> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
600 2024.10.09 22:41:23.721726 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Debug> executeQuery: (from [::1]:54088) /* 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:41:23.721834 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
627 2024.10.09 22:41:23.726835 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Debug> oximeter.fields_bool (ed36daec-6774-4d6c-870c-bed28b883af8): Loading data parts
628 2024.10.09 22:41:23.727455 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Debug> oximeter.fields_bool (ed36daec-6774-4d6c-870c-bed28b883af8): There are no data parts
629 2024.10.09 22:41:23.729679 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Debug> DynamicQueryHandler: Done processing query
630 2024.10.09 22:41:23.729714 [ 3 ] {} <Debug> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
631 2024.10.09 22:41:23.731964 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
632 2024.10.09 22:41:23.732059 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
633 2024.10.09 22:41:23.732088 [ 3 ] {} <Debug> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Authenticating user 'default' from [::1]:54088
634 2024.10.09 22:41:23.732133 [ 3 ] {} <Debug> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
635 2024.10.09 22:41:23.732150 [ 3 ] {} <Debug> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
636 2024.10.09 22:41:23.732206 [ 3 ] {} <Trace> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
637 2024.10.09 22:41:23.732581 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Debug> executeQuery: (from [::1]:54088) 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:41:23.732664 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
639 2024.10.09 22:41:23.736066 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Debug> oximeter.fields_i8 (3f3df83a-1f59-4bcc-81d4-79a15fa46019): Loading data parts
640 2024.10.09 22:41:23.736394 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Debug> oximeter.fields_i8 (3f3df83a-1f59-4bcc-81d4-79a15fa46019): There are no data parts
641 2024.10.09 22:41:23.738423 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Debug> DynamicQueryHandler: Done processing query
642 2024.10.09 22:41:23.738455 [ 3 ] {} <Debug> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
643 2024.10.09 22:41:23.739285 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
644 2024.10.09 22:41:23.739413 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
645 2024.10.09 22:41:23.739438 [ 3 ] {} <Debug> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Authenticating user 'default' from [::1]:54088
646 2024.10.09 22:41:23.739464 [ 3 ] {} <Debug> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
647 2024.10.09 22:41:23.739479 [ 3 ] {} <Debug> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
648 2024.10.09 22:41:23.739542 [ 3 ] {} <Trace> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
649 2024.10.09 22:41:23.739966 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Debug> executeQuery: (from [::1]:54088) 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:41:23.740064 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
651 2024.10.09 22:41:23.743863 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Debug> oximeter.fields_u8 (8fb5e568-aa74-439c-9859-0374410f93c3): Loading data parts
652 2024.10.09 22:41:23.744351 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Debug> oximeter.fields_u8 (8fb5e568-aa74-439c-9859-0374410f93c3): There are no data parts
653 2024.10.09 22:41:23.746278 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Debug> DynamicQueryHandler: Done processing query
654 2024.10.09 22:41:23.746313 [ 3 ] {} <Debug> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
655 2024.10.09 22:41:23.747637 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
656 2024.10.09 22:41:23.747764 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
657 2024.10.09 22:41:23.747796 [ 3 ] {} <Debug> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Authenticating user 'default' from [::1]:54088
658 2024.10.09 22:41:23.747843 [ 3 ] {} <Debug> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
659 2024.10.09 22:41:23.747860 [ 3 ] {} <Debug> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
660 2024.10.09 22:41:23.747915 [ 3 ] {} <Trace> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
661 2024.10.09 22:41:23.748703 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Debug> executeQuery: (from [::1]:54088) 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:41:23.748801 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
663 2024.10.09 22:41:23.751712 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Debug> oximeter.fields_i16 (fb715786-d474-4282-886a-08e6cb30c064): Loading data parts
664 2024.10.09 22:41:23.752086 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Debug> oximeter.fields_i16 (fb715786-d474-4282-886a-08e6cb30c064): There are no data parts
665 2024.10.09 22:41:23.754301 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Debug> DynamicQueryHandler: Done processing query
666 2024.10.09 22:41:23.754397 [ 3 ] {} <Debug> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
667 2024.10.09 22:41:23.757167 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
668 2024.10.09 22:41:23.757309 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
669 2024.10.09 22:41:23.757367 [ 3 ] {} <Debug> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Authenticating user 'default' from [::1]:54088
670 2024.10.09 22:41:23.757398 [ 3 ] {} <Debug> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
671 2024.10.09 22:41:23.757415 [ 3 ] {} <Debug> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
672 2024.10.09 22:41:23.757484 [ 3 ] {} <Trace> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
673 2024.10.09 22:41:23.758095 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Debug> executeQuery: (from [::1]:54088) 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:41:23.758196 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
675 2024.10.09 22:41:23.761107 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Debug> oximeter.fields_u16 (37816018-572c-4706-88e8-668be7d2d444): Loading data parts
676 2024.10.09 22:41:23.761775 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Debug> oximeter.fields_u16 (37816018-572c-4706-88e8-668be7d2d444): There are no data parts
677 2024.10.09 22:41:23.763591 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Debug> DynamicQueryHandler: Done processing query
678 2024.10.09 22:41:23.763616 [ 3 ] {} <Debug> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
679 2024.10.09 22:41:23.764646 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
680 2024.10.09 22:41:23.764752 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
681 2024.10.09 22:41:23.764782 [ 3 ] {} <Debug> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Authenticating user 'default' from [::1]:54088
682 2024.10.09 22:41:23.764811 [ 3 ] {} <Debug> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
683 2024.10.09 22:41:23.764840 [ 3 ] {} <Debug> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
684 2024.10.09 22:41:23.764894 [ 3 ] {} <Trace> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
685 2024.10.09 22:41:23.765411 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Debug> executeQuery: (from [::1]:54088) 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:41:23.765487 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
687 2024.10.09 22:41:23.768641 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Debug> oximeter.fields_i32 (ccd5b38f-6ff3-428f-9607-c97dcbb31827): Loading data parts
688 2024.10.09 22:41:23.769102 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Debug> oximeter.fields_i32 (ccd5b38f-6ff3-428f-9607-c97dcbb31827): There are no data parts
689 2024.10.09 22:41:23.771303 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Debug> DynamicQueryHandler: Done processing query
690 2024.10.09 22:41:23.771355 [ 3 ] {} <Debug> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
691 2024.10.09 22:41:23.773409 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
692 2024.10.09 22:41:23.773505 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
693 2024.10.09 22:41:23.773556 [ 3 ] {} <Debug> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Authenticating user 'default' from [::1]:54088
694 2024.10.09 22:41:23.773585 [ 3 ] {} <Debug> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
695 2024.10.09 22:41:23.773603 [ 3 ] {} <Debug> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
696 2024.10.09 22:41:23.773654 [ 3 ] {} <Trace> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
697 2024.10.09 22:41:23.773998 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Debug> executeQuery: (from [::1]:54088) 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:41:23.774084 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
699 2024.10.09 22:41:23.777091 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Debug> oximeter.fields_u32 (24bf77c0-3fe2-441d-87ab-673fdb3337f2): Loading data parts
700 2024.10.09 22:41:23.777584 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Debug> oximeter.fields_u32 (24bf77c0-3fe2-441d-87ab-673fdb3337f2): There are no data parts
701 2024.10.09 22:41:23.779797 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Debug> DynamicQueryHandler: Done processing query
702 2024.10.09 22:41:23.779875 [ 3 ] {} <Debug> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
703 2024.10.09 22:41:23.782898 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
704 2024.10.09 22:41:23.783081 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
705 2024.10.09 22:41:23.783116 [ 3 ] {} <Debug> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Authenticating user 'default' from [::1]:54088
706 2024.10.09 22:41:23.783143 [ 3 ] {} <Debug> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
707 2024.10.09 22:41:23.783184 [ 3 ] {} <Debug> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
708 2024.10.09 22:41:23.783238 [ 3 ] {} <Trace> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
709 2024.10.09 22:41:23.783597 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Debug> executeQuery: (from [::1]:54088) 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:41:23.783666 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
711 2024.10.09 22:41:23.786338 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Debug> oximeter.fields_i64 (85811726-6eb4-49ae-a9d5-076dd87d8baf): Loading data parts
712 2024.10.09 22:41:23.786607 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Debug> oximeter.fields_i64 (85811726-6eb4-49ae-a9d5-076dd87d8baf): There are no data parts
713 2024.10.09 22:41:23.788701 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Debug> DynamicQueryHandler: Done processing query
714 2024.10.09 22:41:23.788755 [ 3 ] {} <Debug> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
715 2024.10.09 22:41:23.789523 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
716 2024.10.09 22:41:23.789605 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
717 2024.10.09 22:41:23.789637 [ 3 ] {} <Debug> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Authenticating user 'default' from [::1]:54088
718 2024.10.09 22:41:23.789664 [ 3 ] {} <Debug> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
719 2024.10.09 22:41:23.789681 [ 3 ] {} <Debug> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
720 2024.10.09 22:41:23.789735 [ 3 ] {} <Trace> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
721 2024.10.09 22:41:23.790117 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Debug> executeQuery: (from [::1]:54088) 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:41:23.790189 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
723 2024.10.09 22:41:23.793157 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Debug> oximeter.fields_u64 (e437b084-2d3e-4e43-b801-d7d0db79a59b): Loading data parts
724 2024.10.09 22:41:23.793458 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Debug> oximeter.fields_u64 (e437b084-2d3e-4e43-b801-d7d0db79a59b): There are no data parts
725 2024.10.09 22:41:23.795505 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Debug> DynamicQueryHandler: Done processing query
726 2024.10.09 22:41:23.795537 [ 3 ] {} <Debug> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
727 2024.10.09 22:41:23.796341 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
728 2024.10.09 22:41:23.796423 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
729 2024.10.09 22:41:23.796451 [ 3 ] {} <Debug> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Authenticating user 'default' from [::1]:54088
730 2024.10.09 22:41:23.796477 [ 3 ] {} <Debug> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
731 2024.10.09 22:41:23.796494 [ 3 ] {} <Debug> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
732 2024.10.09 22:41:23.796543 [ 3 ] {} <Trace> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
733 2024.10.09 22:41:23.796884 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Debug> executeQuery: (from [::1]:54088) 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:41:23.796956 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
735 2024.10.09 22:41:23.799413 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Debug> oximeter.fields_ipaddr (e93e7381-f555-4de7-a688-84d95418259a): Loading data parts
736 2024.10.09 22:41:23.799675 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Debug> oximeter.fields_ipaddr (e93e7381-f555-4de7-a688-84d95418259a): There are no data parts
737 2024.10.09 22:41:23.801492 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Debug> DynamicQueryHandler: Done processing query
738 2024.10.09 22:41:23.801519 [ 3 ] {} <Debug> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
739 2024.10.09 22:41:23.802507 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
740 2024.10.09 22:41:23.802585 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
741 2024.10.09 22:41:23.802611 [ 3 ] {} <Debug> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Authenticating user 'default' from [::1]:54088
742 2024.10.09 22:41:23.802636 [ 3 ] {} <Debug> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
743 2024.10.09 22:41:23.802652 [ 3 ] {} <Debug> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
744 2024.10.09 22:41:23.802703 [ 3 ] {} <Trace> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
745 2024.10.09 22:41:23.803389 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Debug> executeQuery: (from [::1]:54088) 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:41:23.803483 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
747 2024.10.09 22:41:23.805958 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Debug> oximeter.fields_string (87e857ad-4d2f-4733-9059-f1633fb0615f): Loading data parts
748 2024.10.09 22:41:23.806463 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Debug> oximeter.fields_string (87e857ad-4d2f-4733-9059-f1633fb0615f): There are no data parts
749 2024.10.09 22:41:23.808327 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Debug> DynamicQueryHandler: Done processing query
750 2024.10.09 22:41:23.808355 [ 3 ] {} <Debug> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
751 2024.10.09 22:41:23.809044 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
752 2024.10.09 22:41:23.809121 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
753 2024.10.09 22:41:23.809148 [ 3 ] {} <Debug> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Authenticating user 'default' from [::1]:54088
754 2024.10.09 22:41:23.809177 [ 3 ] {} <Debug> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
755 2024.10.09 22:41:23.809218 [ 3 ] {} <Debug> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
756 2024.10.09 22:41:23.809271 [ 3 ] {} <Trace> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
757 2024.10.09 22:41:23.809609 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Debug> executeQuery: (from [::1]:54088) 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:41:23.809685 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
759 2024.10.09 22:41:23.812735 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Debug> oximeter.fields_uuid (69348aab-5b0d-419a-a76d-75c800f5331d): Loading data parts
760 2024.10.09 22:41:23.813116 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Debug> oximeter.fields_uuid (69348aab-5b0d-419a-a76d-75c800f5331d): There are no data parts
761 2024.10.09 22:41:23.815264 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Debug> DynamicQueryHandler: Done processing query
762 2024.10.09 22:41:23.815307 [ 3 ] {} <Debug> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
763 2024.10.09 22:41:23.816097 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
764 2024.10.09 22:41:23.816181 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
765 2024.10.09 22:41:23.816211 [ 3 ] {} <Debug> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Authenticating user 'default' from [::1]:54088
766 2024.10.09 22:41:23.816236 [ 3 ] {} <Debug> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
767 2024.10.09 22:41:23.816253 [ 3 ] {} <Debug> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
768 2024.10.09 22:41:23.816301 [ 3 ] {} <Trace> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
769 2024.10.09 22:41:23.816622 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Debug> executeQuery: (from [::1]:54088) /* 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:41:23.816697 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
774 2024.10.09 22:41:23.819706 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Debug> oximeter.timeseries_schema (b68a53fa-74e3-4408-a16e-170346656c9f): Loading data parts
775 2024.10.09 22:41:23.819982 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Debug> oximeter.timeseries_schema (b68a53fa-74e3-4408-a16e-170346656c9f): There are no data parts
776 2024.10.09 22:41:23.822007 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Debug> DynamicQueryHandler: Done processing query
777 2024.10.09 22:41:23.822046 [ 3 ] {} <Debug> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
778 2024.10.09 22:41:23.822805 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
779 2024.10.09 22:41:23.822927 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
780 2024.10.09 22:41:23.822959 [ 3 ] {} <Debug> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Authenticating user 'default' from [::1]:54088
781 2024.10.09 22:41:23.822987 [ 3 ] {} <Debug> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
782 2024.10.09 22:41:23.823004 [ 3 ] {} <Debug> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
783 2024.10.09 22:41:23.823103 [ 3 ] {} <Trace> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
784 2024.10.09 22:41:23.823370 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Debug> executeQuery: (from [::1]:54088) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
785 2024.10.09 22:41:23.823590 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
786 2024.10.09 22:41:23.825449 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> oximeter.version (ecf87412-7125-42ca-af4b-146907caf653): Trying to reserve 1.00 MiB using storage policy from min volume index 0
787 2024.10.09 22:41:23.825510 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.21 GiB.
788 2024.10.09 22:41:23.826463 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
789 2024.10.09 22:41:23.827054 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> oximeter.version (ecf87412-7125-42ca-af4b-146907caf653): 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:41:23.827419 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.004177 sec., 239.40627244433804 rows/sec., 3.74 KiB/sec.
791 2024.10.09 22:41:23.827655 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Debug> DynamicQueryHandler: Done processing query
792 2024.10.09 22:41:23.827686 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB.
793 2024.10.09 22:41:23.827704 [ 3 ] {} <Debug> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
794 2024.10.09 22:41:24.000687 [ 246 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 182.38 MiB, peak 187.52 MiB, free memory in arenas 0.00 B, will set to 187.00 MiB (RSS), difference: 4.62 MiB