Max level shown:
1 2024.10.09 22:40:56.452664 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 15690
2 2024.10.09 22:40:56.452834 [ 1 ] {} <Information> Application: starting up
3 2024.10.09 22:40:56.452892 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc
4 2024.10.09 22:40:56.462364 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8.
5 2024.10.09 22:40:56.473081 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536
6 2024.10.09 22:40:56.475741 [ 1 ] {} <Debug> Application: Initializing DateLUT.
7 2024.10.09 22:40:56.475768 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
8 2024.10.09 22:40:56.475852 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_cannot_attach_nine_disks_to_instance.15678.1-clickhouse-6mA1G1/datastore/tmp/ to store temporary data in it
9 2024.10.09 22:40:56.479388 [ 1 ] {} <Debug> Application: Initializing interserver credentials.
10 2024.10.09 22:40:56.480296 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
11 2024.10.09 22:40:56.480905 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
12 2024.10.09 22:40:56.481496 [ 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:40:56.481572 [ 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:40:56.481609 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB
15 2024.10.09 22:40:56.481724 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
16 2024.10.09 22:40:56.482639 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
17 2024.10.09 22:40:56.491880 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
18 2024.10.09 22:40:56.498006 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
19 2024.10.09 22:40:56.503110 [ 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:40:56.503165 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
21 2024.10.09 22:40:56.504050 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
22 2024.10.09 22:40:56.504713 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
23 2024.10.09 22:40:56.506534 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
24 2024.10.09 22:40:56.507041 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml
25 2024.10.09 22:40:56.508401 [ 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:40:56.508766 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
27 2024.10.09 22:40:56.509130 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
28 2024.10.09 22:40:56.509493 [ 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:40:56.510437 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
30 2024.10.09 22:40:56.510462 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_cannot_attach_nine_disks_to_instance.15678.1-clickhouse-6mA1G1/datastore/
31 2024.10.09 22:40:56.512764 [ 185 ] {} <Debug> DNSResolver: Updating DNS cache
32 2024.10.09 22:40:56.512817 [ 185 ] {} <Debug> DNSResolver: Updated DNS cache
33 2024.10.09 22:40:56.527381 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
34 2024.10.09 22:40:56.527425 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000202441 sec
35 2024.10.09 22:40:56.527460 [ 1 ] {} <Trace> ReferentialDeps: No tables
36 2024.10.09 22:40:56.527472 [ 1 ] {} <Trace> LoadingDeps: No tables
37 2024.10.09 22:40:56.527719 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables.
38 2024.10.09 22:40:56.527819 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config
39 2024.10.09 22:40:56.527868 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
40 2024.10.09 22:40:56.527906 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
41 2024.10.09 22:40:56.527929 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
42 2024.10.09 22:40:56.527942 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
43 2024.10.09 22:40:56.527974 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
44 2024.10.09 22:40:56.527989 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config
45 2024.10.09 22:40:56.528010 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
46 2024.10.09 22:40:56.528042 [ 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:40:56.528058 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config
48 2024.10.09 22:40:56.528077 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
49 2024.10.09 22:40:56.528090 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
50 2024.10.09 22:40:56.528146 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
51 2024.10.09 22:40:56.528168 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
52 2024.10.09 22:40:56.528182 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
53 2024.10.09 22:40:56.528211 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
54 2024.10.09 22:40:56.528232 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
55 2024.10.09 22:40:56.605738 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
56 2024.10.09 22:40:56.609810 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
57 2024.10.09 22:40:56.609866 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000114434 sec
58 2024.10.09 22:40:56.609890 [ 1 ] {} <Trace> ReferentialDeps: No tables
59 2024.10.09 22:40:56.609904 [ 1 ] {} <Trace> LoadingDeps: No tables
60 2024.10.09 22:40:56.609949 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables.
61 2024.10.09 22:40:56.610309 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_cannot_attach_nine_disks_to_instance.15678.1-clickhouse-6mA1G1/datastore/user_defined/
62 2024.10.09 22:40:56.610413 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
63 2024.10.09 22:40:56.610432 [ 1 ] {} <Debug> Application: Loaded metadata.
64 2024.10.09 22:40:56.610459 [ 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:40:56.610479 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled.
66 2024.10.09 22:40:56.610767 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 38453
67 2024.10.09 22:40:56.611164 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 64072
68 2024.10.09 22:40:56.614444 [ 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:40:56.729149 [ 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:40:56.729229 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
71 2024.10.09 22:40:56.890671 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 34922
72 2024.10.09 22:40:56.890796 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 48908
73 2024.10.09 22:40:56.890903 [ 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:40:56.964080 [ 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:40:56.964126 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
76 2024.10.09 22:40:57.172121 [ 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:40:57.172411 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.88 MiB, peak 16.00 MiB, free memory in arenas 0.00 B, will set to 178.31 MiB (RSS), difference: 168.43 MiB
78 2024.10.09 22:40:57.172845 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.9718e-05 sec.
79 2024.10.09 22:40:57.173532 [ 1 ] {} <Information> Application: Listening for http://[::1]:38453
80 2024.10.09 22:40:57.173602 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:64072
81 2024.10.09 22:40:57.173671 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004
82 2024.10.09 22:40:57.173731 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:34922
83 2024.10.09 22:40:57.173809 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:48908
84 2024.10.09 22:40:57.173928 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004
85 2024.10.09 22:40:57.173953 [ 1 ] {} <Information> Application: Ready for connections.
86 2024.10.09 22:41:07.221183 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
87 2024.10.09 22:41:07.221403 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
88 2024.10.09 22:41:07.221441 [ 3 ] {} <Debug> HTTP-Session: f20a2a13-ebfb-4088-9e28-de5961f617f7 Authenticating user 'default' from [::1]:52512
89 2024.10.09 22:41:07.221482 [ 3 ] {} <Debug> HTTP-Session: f20a2a13-ebfb-4088-9e28-de5961f617f7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
90 2024.10.09 22:41:07.221496 [ 3 ] {} <Debug> HTTP-Session: f20a2a13-ebfb-4088-9e28-de5961f617f7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
91 2024.10.09 22:41:07.221588 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
92 2024.10.09 22:41:07.221634 [ 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:07.221652 [ 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:07.221698 [ 3 ] {} <Trace> HTTP-Session: f20a2a13-ebfb-4088-9e28-de5961f617f7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
95 2024.10.09 22:41:07.222153 [ 3 ] {92153001-099e-435a-b15b-38bcb7c0577f} <Debug> executeQuery: (from [::1]:52512) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
96 2024.10.09 22:41:07.230893 [ 3 ] {92153001-099e-435a-b15b-38bcb7c0577f} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:52512) (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:07.231152 [ 3 ] {92153001-099e-435a-b15b-38bcb7c0577f} <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:07.231426 [ 3 ] {} <Debug> HTTP-Session: f20a2a13-ebfb-4088-9e28-de5961f617f7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
147 2024.10.09 22:41:07.308962 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
148 2024.10.09 22:41:07.309102 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
149 2024.10.09 22:41:07.309130 [ 3 ] {} <Debug> HTTP-Session: ac9ec060-db32-4c5a-a2d6-910820031eb4 Authenticating user 'default' from [::1]:52512
150 2024.10.09 22:41:07.309157 [ 3 ] {} <Debug> HTTP-Session: ac9ec060-db32-4c5a-a2d6-910820031eb4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
151 2024.10.09 22:41:07.309176 [ 3 ] {} <Debug> HTTP-Session: ac9ec060-db32-4c5a-a2d6-910820031eb4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
152 2024.10.09 22:41:07.309235 [ 3 ] {} <Trace> HTTP-Session: ac9ec060-db32-4c5a-a2d6-910820031eb4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
153 2024.10.09 22:41:07.309536 [ 3 ] {2f17f2a7-38eb-4977-aa76-dd2a925237d0} <Debug> executeQuery: (from [::1]:52512) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
154 2024.10.09 22:41:07.309970 [ 3 ] {2f17f2a7-38eb-4977-aa76-dd2a925237d0} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:52512) (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:07.310142 [ 3 ] {2f17f2a7-38eb-4977-aa76-dd2a925237d0} <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:07.310350 [ 3 ] {} <Debug> HTTP-Session: ac9ec060-db32-4c5a-a2d6-910820031eb4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
205 2024.10.09 22:41:07.344023 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
206 2024.10.09 22:41:07.344181 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
207 2024.10.09 22:41:07.344216 [ 3 ] {} <Debug> HTTP-Session: 989a50bd-3269-4489-a882-03ea2678e1cc Authenticating user 'default' from [::1]:52512
208 2024.10.09 22:41:07.344246 [ 3 ] {} <Debug> HTTP-Session: 989a50bd-3269-4489-a882-03ea2678e1cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
209 2024.10.09 22:41:07.344269 [ 3 ] {} <Debug> HTTP-Session: 989a50bd-3269-4489-a882-03ea2678e1cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
210 2024.10.09 22:41:07.344330 [ 3 ] {} <Trace> HTTP-Session: 989a50bd-3269-4489-a882-03ea2678e1cc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
211 2024.10.09 22:41:07.344621 [ 3 ] {53cf48e5-986d-45ed-ab07-036485b999dd} <Debug> executeQuery: (from [::1]:52512) DROP DATABASE IF EXISTS oximeter (stage: Complete)
212 2024.10.09 22:41:07.344890 [ 3 ] {53cf48e5-986d-45ed-ab07-036485b999dd} <Debug> DynamicQueryHandler: Done processing query
213 2024.10.09 22:41:07.344920 [ 3 ] {} <Debug> HTTP-Session: 989a50bd-3269-4489-a882-03ea2678e1cc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
214 2024.10.09 22:41:07.346992 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
215 2024.10.09 22:41:07.347090 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
216 2024.10.09 22:41:07.347115 [ 3 ] {} <Debug> HTTP-Session: be668c0f-9611-4ace-81b0-2aded4b20acf Authenticating user 'default' from [::1]:52512
217 2024.10.09 22:41:07.347140 [ 3 ] {} <Debug> HTTP-Session: be668c0f-9611-4ace-81b0-2aded4b20acf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
218 2024.10.09 22:41:07.347162 [ 3 ] {} <Debug> HTTP-Session: be668c0f-9611-4ace-81b0-2aded4b20acf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
219 2024.10.09 22:41:07.347213 [ 3 ] {} <Trace> HTTP-Session: be668c0f-9611-4ace-81b0-2aded4b20acf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
220 2024.10.09 22:41:07.347371 [ 3 ] {6a273e12-4988-4e60-a710-0e5ec37ab8c1} <Debug> executeQuery: (from [::1]:52512) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
221 2024.10.09 22:41:07.347450 [ 3 ] {6a273e12-4988-4e60-a710-0e5ec37ab8c1} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
222 2024.10.09 22:41:07.352296 [ 3 ] {6a273e12-4988-4e60-a710-0e5ec37ab8c1} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
223 2024.10.09 22:41:07.352359 [ 3 ] {6a273e12-4988-4e60-a710-0e5ec37ab8c1} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000129074 sec
224 2024.10.09 22:41:07.352381 [ 3 ] {6a273e12-4988-4e60-a710-0e5ec37ab8c1} <Trace> ReferentialDeps: No tables
225 2024.10.09 22:41:07.352396 [ 3 ] {6a273e12-4988-4e60-a710-0e5ec37ab8c1} <Trace> LoadingDeps: No tables
226 2024.10.09 22:41:07.352434 [ 3 ] {6a273e12-4988-4e60-a710-0e5ec37ab8c1} <Information> DatabaseAtomic (oximeter): Starting up tables.
227 2024.10.09 22:41:07.352695 [ 3 ] {6a273e12-4988-4e60-a710-0e5ec37ab8c1} <Debug> DynamicQueryHandler: Done processing query
228 2024.10.09 22:41:07.352730 [ 3 ] {} <Debug> HTTP-Session: be668c0f-9611-4ace-81b0-2aded4b20acf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
229 2024.10.09 22:41:07.367397 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
230 2024.10.09 22:41:07.367549 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
231 2024.10.09 22:41:07.367577 [ 3 ] {} <Debug> HTTP-Session: 779e6b70-af09-4976-813a-97b1ae642eb5 Authenticating user 'default' from [::1]:52512
232 2024.10.09 22:41:07.367605 [ 3 ] {} <Debug> HTTP-Session: 779e6b70-af09-4976-813a-97b1ae642eb5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
233 2024.10.09 22:41:07.367621 [ 3 ] {} <Debug> HTTP-Session: 779e6b70-af09-4976-813a-97b1ae642eb5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
234 2024.10.09 22:41:07.367687 [ 3 ] {} <Trace> HTTP-Session: 779e6b70-af09-4976-813a-97b1ae642eb5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
235 2024.10.09 22:41:07.367994 [ 3 ] {3f054da1-8e15-4b11-ae2f-685a56529a10} <Debug> executeQuery: (from [::1]:52512) /* 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:07.368086 [ 3 ] {3f054da1-8e15-4b11-ae2f-685a56529a10} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
238 2024.10.09 22:41:07.369587 [ 3 ] {3f054da1-8e15-4b11-ae2f-685a56529a10} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
239 2024.10.09 22:41:07.370989 [ 3 ] {3f054da1-8e15-4b11-ae2f-685a56529a10} <Debug> oximeter.version (14ff95b0-c8b5-4809-a3a0-36deecf96a66): Loading data parts
240 2024.10.09 22:41:07.372606 [ 3 ] {3f054da1-8e15-4b11-ae2f-685a56529a10} <Debug> oximeter.version (14ff95b0-c8b5-4809-a3a0-36deecf96a66): There are no data parts
241 2024.10.09 22:41:07.374662 [ 3 ] {3f054da1-8e15-4b11-ae2f-685a56529a10} <Debug> DynamicQueryHandler: Done processing query
242 2024.10.09 22:41:07.374697 [ 3 ] {} <Debug> HTTP-Session: 779e6b70-af09-4976-813a-97b1ae642eb5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
243 2024.10.09 22:41:07.376453 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
244 2024.10.09 22:41:07.376547 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
245 2024.10.09 22:41:07.376574 [ 3 ] {} <Debug> HTTP-Session: 8a350f1b-fe95-4b2a-87f2-2d9eafbf3c42 Authenticating user 'default' from [::1]:52512
246 2024.10.09 22:41:07.376618 [ 3 ] {} <Debug> HTTP-Session: 8a350f1b-fe95-4b2a-87f2-2d9eafbf3c42 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
247 2024.10.09 22:41:07.376636 [ 3 ] {} <Debug> HTTP-Session: 8a350f1b-fe95-4b2a-87f2-2d9eafbf3c42 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
248 2024.10.09 22:41:07.376694 [ 3 ] {} <Trace> HTTP-Session: 8a350f1b-fe95-4b2a-87f2-2d9eafbf3c42 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
249 2024.10.09 22:41:07.377111 [ 3 ] {34b73d9b-26a1-4261-9a9d-588e50fb649f} <Debug> executeQuery: (from [::1]:52512) /* 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:07.377199 [ 3 ] {34b73d9b-26a1-4261-9a9d-588e50fb649f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
261 2024.10.09 22:41:07.379962 [ 3 ] {34b73d9b-26a1-4261-9a9d-588e50fb649f} <Debug> oximeter.measurements_bool (d2d71245-ff68-4d24-ae6e-2cb25245fb73): Loading data parts
262 2024.10.09 22:41:07.380311 [ 3 ] {34b73d9b-26a1-4261-9a9d-588e50fb649f} <Debug> oximeter.measurements_bool (d2d71245-ff68-4d24-ae6e-2cb25245fb73): There are no data parts
263 2024.10.09 22:41:07.382192 [ 3 ] {34b73d9b-26a1-4261-9a9d-588e50fb649f} <Debug> DynamicQueryHandler: Done processing query
264 2024.10.09 22:41:07.382223 [ 3 ] {} <Debug> HTTP-Session: 8a350f1b-fe95-4b2a-87f2-2d9eafbf3c42 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
265 2024.10.09 22:41:07.494684 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
266 2024.10.09 22:41:07.494817 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
267 2024.10.09 22:41:07.494847 [ 3 ] {} <Debug> HTTP-Session: b4a47977-17f0-4148-9654-2dd0db92cf79 Authenticating user 'default' from [::1]:52512
268 2024.10.09 22:41:07.494876 [ 3 ] {} <Debug> HTTP-Session: b4a47977-17f0-4148-9654-2dd0db92cf79 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
269 2024.10.09 22:41:07.494892 [ 3 ] {} <Debug> HTTP-Session: b4a47977-17f0-4148-9654-2dd0db92cf79 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
270 2024.10.09 22:41:07.494956 [ 3 ] {} <Trace> HTTP-Session: b4a47977-17f0-4148-9654-2dd0db92cf79 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
271 2024.10.09 22:41:07.495339 [ 3 ] {f05e595b-a8b3-44d5-9411-386d261f3b87} <Debug> executeQuery: (from [::1]:52512) 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:07.495424 [ 3 ] {f05e595b-a8b3-44d5-9411-386d261f3b87} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
273 2024.10.09 22:41:07.498001 [ 3 ] {f05e595b-a8b3-44d5-9411-386d261f3b87} <Debug> oximeter.measurements_i8 (b169ec92-0f0e-4b32-b8a8-bd5a3c27d51d): Loading data parts
274 2024.10.09 22:41:07.498411 [ 3 ] {f05e595b-a8b3-44d5-9411-386d261f3b87} <Debug> oximeter.measurements_i8 (b169ec92-0f0e-4b32-b8a8-bd5a3c27d51d): There are no data parts
275 2024.10.09 22:41:07.500275 [ 3 ] {f05e595b-a8b3-44d5-9411-386d261f3b87} <Debug> DynamicQueryHandler: Done processing query
276 2024.10.09 22:41:07.500305 [ 3 ] {} <Debug> HTTP-Session: b4a47977-17f0-4148-9654-2dd0db92cf79 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
277 2024.10.09 22:41:07.501779 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
278 2024.10.09 22:41:07.501850 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
279 2024.10.09 22:41:07.501877 [ 3 ] {} <Debug> HTTP-Session: 360431a7-64c0-452d-800d-9a13646672a5 Authenticating user 'default' from [::1]:52512
280 2024.10.09 22:41:07.501916 [ 3 ] {} <Debug> HTTP-Session: 360431a7-64c0-452d-800d-9a13646672a5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
281 2024.10.09 22:41:07.501933 [ 3 ] {} <Debug> HTTP-Session: 360431a7-64c0-452d-800d-9a13646672a5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
282 2024.10.09 22:41:07.501985 [ 3 ] {} <Trace> HTTP-Session: 360431a7-64c0-452d-800d-9a13646672a5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
283 2024.10.09 22:41:07.502321 [ 3 ] {a7b3ccd4-0320-472c-adf9-6bdfb182af09} <Debug> executeQuery: (from [::1]:52512) 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:07.502400 [ 3 ] {a7b3ccd4-0320-472c-adf9-6bdfb182af09} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
285 2024.10.09 22:41:07.504846 [ 3 ] {a7b3ccd4-0320-472c-adf9-6bdfb182af09} <Debug> oximeter.measurements_u8 (a9c7edd8-ad04-4954-89b7-52df0ed5c9c0): Loading data parts
286 2024.10.09 22:41:07.505252 [ 3 ] {a7b3ccd4-0320-472c-adf9-6bdfb182af09} <Debug> oximeter.measurements_u8 (a9c7edd8-ad04-4954-89b7-52df0ed5c9c0): There are no data parts
287 2024.10.09 22:41:07.507193 [ 3 ] {a7b3ccd4-0320-472c-adf9-6bdfb182af09} <Debug> DynamicQueryHandler: Done processing query
288 2024.10.09 22:41:07.507240 [ 3 ] {} <Debug> HTTP-Session: 360431a7-64c0-452d-800d-9a13646672a5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
289 2024.10.09 22:41:07.521483 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
290 2024.10.09 22:41:07.521592 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
291 2024.10.09 22:41:07.521636 [ 3 ] {} <Debug> HTTP-Session: 6555b2c2-7a81-4b8e-9051-f6627dcbb9fa Authenticating user 'default' from [::1]:52512
292 2024.10.09 22:41:07.521666 [ 3 ] {} <Debug> HTTP-Session: 6555b2c2-7a81-4b8e-9051-f6627dcbb9fa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
293 2024.10.09 22:41:07.521683 [ 3 ] {} <Debug> HTTP-Session: 6555b2c2-7a81-4b8e-9051-f6627dcbb9fa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
294 2024.10.09 22:41:07.521746 [ 3 ] {} <Trace> HTTP-Session: 6555b2c2-7a81-4b8e-9051-f6627dcbb9fa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
295 2024.10.09 22:41:07.522170 [ 3 ] {41dd1b7d-b74e-4a19-a2f9-6a219ebe21b8} <Debug> executeQuery: (from [::1]:52512) 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:07.522258 [ 3 ] {41dd1b7d-b74e-4a19-a2f9-6a219ebe21b8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
297 2024.10.09 22:41:07.525422 [ 3 ] {41dd1b7d-b74e-4a19-a2f9-6a219ebe21b8} <Debug> oximeter.measurements_i16 (25cd4ce7-9663-4625-bda3-4405c90aa0f5): Loading data parts
298 2024.10.09 22:41:07.525822 [ 3 ] {41dd1b7d-b74e-4a19-a2f9-6a219ebe21b8} <Debug> oximeter.measurements_i16 (25cd4ce7-9663-4625-bda3-4405c90aa0f5): There are no data parts
299 2024.10.09 22:41:07.535204 [ 3 ] {41dd1b7d-b74e-4a19-a2f9-6a219ebe21b8} <Debug> DynamicQueryHandler: Done processing query
300 2024.10.09 22:41:07.535248 [ 3 ] {} <Debug> HTTP-Session: 6555b2c2-7a81-4b8e-9051-f6627dcbb9fa Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
301 2024.10.09 22:41:07.545236 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
302 2024.10.09 22:41:07.545375 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
303 2024.10.09 22:41:07.545409 [ 3 ] {} <Debug> HTTP-Session: be495af7-ca83-4905-b8b1-5d9d6a6ee5c0 Authenticating user 'default' from [::1]:52512
304 2024.10.09 22:41:07.545439 [ 3 ] {} <Debug> HTTP-Session: be495af7-ca83-4905-b8b1-5d9d6a6ee5c0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
305 2024.10.09 22:41:07.545466 [ 3 ] {} <Debug> HTTP-Session: be495af7-ca83-4905-b8b1-5d9d6a6ee5c0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
306 2024.10.09 22:41:07.545562 [ 3 ] {} <Trace> HTTP-Session: be495af7-ca83-4905-b8b1-5d9d6a6ee5c0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
307 2024.10.09 22:41:07.545981 [ 3 ] {e558346c-d356-433c-9ccf-fffa943963e3} <Debug> executeQuery: (from [::1]:52512) 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:07.546069 [ 3 ] {e558346c-d356-433c-9ccf-fffa943963e3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
309 2024.10.09 22:41:07.548593 [ 3 ] {e558346c-d356-433c-9ccf-fffa943963e3} <Debug> oximeter.measurements_u16 (a2065172-d851-4a5b-9abd-370f3cb0ef1c): Loading data parts
310 2024.10.09 22:41:07.548945 [ 3 ] {e558346c-d356-433c-9ccf-fffa943963e3} <Debug> oximeter.measurements_u16 (a2065172-d851-4a5b-9abd-370f3cb0ef1c): There are no data parts
311 2024.10.09 22:41:07.550893 [ 3 ] {e558346c-d356-433c-9ccf-fffa943963e3} <Debug> DynamicQueryHandler: Done processing query
312 2024.10.09 22:41:07.550922 [ 3 ] {} <Debug> HTTP-Session: be495af7-ca83-4905-b8b1-5d9d6a6ee5c0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
313 2024.10.09 22:41:07.564415 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
314 2024.10.09 22:41:07.564547 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
315 2024.10.09 22:41:07.564595 [ 3 ] {} <Debug> HTTP-Session: 95248901-d174-41bf-8892-ebb065902196 Authenticating user 'default' from [::1]:52512
316 2024.10.09 22:41:07.564624 [ 3 ] {} <Debug> HTTP-Session: 95248901-d174-41bf-8892-ebb065902196 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
317 2024.10.09 22:41:07.564641 [ 3 ] {} <Debug> HTTP-Session: 95248901-d174-41bf-8892-ebb065902196 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
318 2024.10.09 22:41:07.564703 [ 3 ] {} <Trace> HTTP-Session: 95248901-d174-41bf-8892-ebb065902196 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
319 2024.10.09 22:41:07.565133 [ 3 ] {3889bb65-9916-4901-aece-46cb1180b074} <Debug> executeQuery: (from [::1]:52512) 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:07.565220 [ 3 ] {3889bb65-9916-4901-aece-46cb1180b074} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
321 2024.10.09 22:41:07.567752 [ 3 ] {3889bb65-9916-4901-aece-46cb1180b074} <Debug> oximeter.measurements_i32 (08674396-9b37-4157-a483-757d46576511): Loading data parts
322 2024.10.09 22:41:07.568126 [ 3 ] {3889bb65-9916-4901-aece-46cb1180b074} <Debug> oximeter.measurements_i32 (08674396-9b37-4157-a483-757d46576511): There are no data parts
323 2024.10.09 22:41:07.569874 [ 3 ] {3889bb65-9916-4901-aece-46cb1180b074} <Debug> DynamicQueryHandler: Done processing query
324 2024.10.09 22:41:07.569903 [ 3 ] {} <Debug> HTTP-Session: 95248901-d174-41bf-8892-ebb065902196 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
325 2024.10.09 22:41:07.573912 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
326 2024.10.09 22:41:07.574064 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
327 2024.10.09 22:41:07.574095 [ 3 ] {} <Debug> HTTP-Session: 7742d494-7c2f-42d5-a45c-a9bb16ab6c38 Authenticating user 'default' from [::1]:52512
328 2024.10.09 22:41:07.574123 [ 3 ] {} <Debug> HTTP-Session: 7742d494-7c2f-42d5-a45c-a9bb16ab6c38 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
329 2024.10.09 22:41:07.574146 [ 3 ] {} <Debug> HTTP-Session: 7742d494-7c2f-42d5-a45c-a9bb16ab6c38 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
330 2024.10.09 22:41:07.574203 [ 3 ] {} <Trace> HTTP-Session: 7742d494-7c2f-42d5-a45c-a9bb16ab6c38 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
331 2024.10.09 22:41:07.574610 [ 3 ] {a082c2c8-f172-48f1-a995-ada11ea6a585} <Debug> executeQuery: (from [::1]:52512) 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:07.574698 [ 3 ] {a082c2c8-f172-48f1-a995-ada11ea6a585} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
333 2024.10.09 22:41:07.577129 [ 3 ] {a082c2c8-f172-48f1-a995-ada11ea6a585} <Debug> oximeter.measurements_u32 (d9071ace-6912-4216-a249-738a4a60c221): Loading data parts
334 2024.10.09 22:41:07.577449 [ 3 ] {a082c2c8-f172-48f1-a995-ada11ea6a585} <Debug> oximeter.measurements_u32 (d9071ace-6912-4216-a249-738a4a60c221): There are no data parts
335 2024.10.09 22:41:07.579188 [ 3 ] {a082c2c8-f172-48f1-a995-ada11ea6a585} <Debug> DynamicQueryHandler: Done processing query
336 2024.10.09 22:41:07.579219 [ 3 ] {} <Debug> HTTP-Session: 7742d494-7c2f-42d5-a45c-a9bb16ab6c38 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
337 2024.10.09 22:41:07.588056 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
338 2024.10.09 22:41:07.588191 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
339 2024.10.09 22:41:07.588222 [ 3 ] {} <Debug> HTTP-Session: c44796d2-4eba-4d17-8d56-2ab0c13e73bb Authenticating user 'default' from [::1]:52512
340 2024.10.09 22:41:07.588268 [ 3 ] {} <Debug> HTTP-Session: c44796d2-4eba-4d17-8d56-2ab0c13e73bb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
341 2024.10.09 22:41:07.588285 [ 3 ] {} <Debug> HTTP-Session: c44796d2-4eba-4d17-8d56-2ab0c13e73bb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
342 2024.10.09 22:41:07.588341 [ 3 ] {} <Trace> HTTP-Session: c44796d2-4eba-4d17-8d56-2ab0c13e73bb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
343 2024.10.09 22:41:07.588770 [ 3 ] {252972dd-d61f-4e42-a22d-1efc28964ee2} <Debug> executeQuery: (from [::1]:52512) 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:07.588865 [ 3 ] {252972dd-d61f-4e42-a22d-1efc28964ee2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
345 2024.10.09 22:41:07.594189 [ 3 ] {252972dd-d61f-4e42-a22d-1efc28964ee2} <Debug> oximeter.measurements_i64 (04e534d7-8cb7-4c46-91ee-793a45fdd342): Loading data parts
346 2024.10.09 22:41:07.595621 [ 3 ] {252972dd-d61f-4e42-a22d-1efc28964ee2} <Debug> oximeter.measurements_i64 (04e534d7-8cb7-4c46-91ee-793a45fdd342): There are no data parts
347 2024.10.09 22:41:07.597778 [ 3 ] {252972dd-d61f-4e42-a22d-1efc28964ee2} <Debug> DynamicQueryHandler: Done processing query
348 2024.10.09 22:41:07.597860 [ 3 ] {} <Debug> HTTP-Session: c44796d2-4eba-4d17-8d56-2ab0c13e73bb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
349 2024.10.09 22:41:07.619080 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
350 2024.10.09 22:41:07.619259 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
351 2024.10.09 22:41:07.619297 [ 3 ] {} <Debug> HTTP-Session: 40b1248e-b94c-4da8-be3c-54799de2046e Authenticating user 'default' from [::1]:52512
352 2024.10.09 22:41:07.619328 [ 3 ] {} <Debug> HTTP-Session: 40b1248e-b94c-4da8-be3c-54799de2046e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
353 2024.10.09 22:41:07.619386 [ 3 ] {} <Debug> HTTP-Session: 40b1248e-b94c-4da8-be3c-54799de2046e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
354 2024.10.09 22:41:07.619470 [ 3 ] {} <Trace> HTTP-Session: 40b1248e-b94c-4da8-be3c-54799de2046e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
355 2024.10.09 22:41:07.619911 [ 3 ] {5d5feb8a-1e16-4c70-846c-6ad001c1cfdc} <Debug> executeQuery: (from [::1]:52512) 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:07.620006 [ 3 ] {5d5feb8a-1e16-4c70-846c-6ad001c1cfdc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
357 2024.10.09 22:41:07.622885 [ 3 ] {5d5feb8a-1e16-4c70-846c-6ad001c1cfdc} <Debug> oximeter.measurements_u64 (3d380f00-5a96-4579-a4a8-d4658a93f238): Loading data parts
358 2024.10.09 22:41:07.623269 [ 3 ] {5d5feb8a-1e16-4c70-846c-6ad001c1cfdc} <Debug> oximeter.measurements_u64 (3d380f00-5a96-4579-a4a8-d4658a93f238): There are no data parts
359 2024.10.09 22:41:07.625086 [ 3 ] {5d5feb8a-1e16-4c70-846c-6ad001c1cfdc} <Debug> DynamicQueryHandler: Done processing query
360 2024.10.09 22:41:07.625115 [ 3 ] {} <Debug> HTTP-Session: 40b1248e-b94c-4da8-be3c-54799de2046e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
361 2024.10.09 22:41:07.634965 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
362 2024.10.09 22:41:07.635120 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
363 2024.10.09 22:41:07.635148 [ 3 ] {} <Debug> HTTP-Session: 974c92ca-d425-4415-ac64-808c0d66de15 Authenticating user 'default' from [::1]:52512
364 2024.10.09 22:41:07.635175 [ 3 ] {} <Debug> HTTP-Session: 974c92ca-d425-4415-ac64-808c0d66de15 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
365 2024.10.09 22:41:07.635197 [ 3 ] {} <Debug> HTTP-Session: 974c92ca-d425-4415-ac64-808c0d66de15 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
366 2024.10.09 22:41:07.635251 [ 3 ] {} <Trace> HTTP-Session: 974c92ca-d425-4415-ac64-808c0d66de15 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
367 2024.10.09 22:41:07.635603 [ 3 ] {8747e51b-2b75-424e-8e63-8e41fa03d932} <Debug> executeQuery: (from [::1]:52512) 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:07.635792 [ 3 ] {8747e51b-2b75-424e-8e63-8e41fa03d932} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
369 2024.10.09 22:41:07.638128 [ 3 ] {8747e51b-2b75-424e-8e63-8e41fa03d932} <Debug> oximeter.measurements_f32 (9a5bf31d-6957-43ba-938a-1ed0e980a828): Loading data parts
370 2024.10.09 22:41:07.638472 [ 3 ] {8747e51b-2b75-424e-8e63-8e41fa03d932} <Debug> oximeter.measurements_f32 (9a5bf31d-6957-43ba-938a-1ed0e980a828): There are no data parts
371 2024.10.09 22:41:07.640236 [ 3 ] {8747e51b-2b75-424e-8e63-8e41fa03d932} <Debug> DynamicQueryHandler: Done processing query
372 2024.10.09 22:41:07.640276 [ 3 ] {} <Debug> HTTP-Session: 974c92ca-d425-4415-ac64-808c0d66de15 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
373 2024.10.09 22:41:07.641049 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
374 2024.10.09 22:41:07.641156 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
375 2024.10.09 22:41:07.641196 [ 3 ] {} <Debug> HTTP-Session: 07b629a1-a5d4-4bac-9f7a-9c4093d74dc3 Authenticating user 'default' from [::1]:52512
376 2024.10.09 22:41:07.641221 [ 3 ] {} <Debug> HTTP-Session: 07b629a1-a5d4-4bac-9f7a-9c4093d74dc3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
377 2024.10.09 22:41:07.641235 [ 3 ] {} <Debug> HTTP-Session: 07b629a1-a5d4-4bac-9f7a-9c4093d74dc3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
378 2024.10.09 22:41:07.641288 [ 3 ] {} <Trace> HTTP-Session: 07b629a1-a5d4-4bac-9f7a-9c4093d74dc3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
379 2024.10.09 22:41:07.641569 [ 3 ] {9a842c99-5a12-49b1-b500-3b75dca04ab1} <Debug> executeQuery: (from [::1]:52512) 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:07.641641 [ 3 ] {9a842c99-5a12-49b1-b500-3b75dca04ab1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
381 2024.10.09 22:41:07.644154 [ 3 ] {9a842c99-5a12-49b1-b500-3b75dca04ab1} <Debug> oximeter.measurements_f64 (8a8f03e8-cf93-4121-9341-5a6579024913): Loading data parts
382 2024.10.09 22:41:07.644464 [ 3 ] {9a842c99-5a12-49b1-b500-3b75dca04ab1} <Debug> oximeter.measurements_f64 (8a8f03e8-cf93-4121-9341-5a6579024913): There are no data parts
383 2024.10.09 22:41:07.646308 [ 3 ] {9a842c99-5a12-49b1-b500-3b75dca04ab1} <Debug> DynamicQueryHandler: Done processing query
384 2024.10.09 22:41:07.646340 [ 3 ] {} <Debug> HTTP-Session: 07b629a1-a5d4-4bac-9f7a-9c4093d74dc3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
385 2024.10.09 22:41:07.658704 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
386 2024.10.09 22:41:07.658847 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
387 2024.10.09 22:41:07.658882 [ 3 ] {} <Debug> HTTP-Session: 6fa42f21-f0e3-4a93-9ef7-7ef41cdfd407 Authenticating user 'default' from [::1]:52512
388 2024.10.09 22:41:07.658914 [ 3 ] {} <Debug> HTTP-Session: 6fa42f21-f0e3-4a93-9ef7-7ef41cdfd407 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
389 2024.10.09 22:41:07.658942 [ 3 ] {} <Debug> HTTP-Session: 6fa42f21-f0e3-4a93-9ef7-7ef41cdfd407 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
390 2024.10.09 22:41:07.659008 [ 3 ] {} <Trace> HTTP-Session: 6fa42f21-f0e3-4a93-9ef7-7ef41cdfd407 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
391 2024.10.09 22:41:07.659409 [ 3 ] {fd9f38de-327a-4eb0-bf93-a1f1440f4082} <Debug> executeQuery: (from [::1]:52512) 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:07.659495 [ 3 ] {fd9f38de-327a-4eb0-bf93-a1f1440f4082} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
393 2024.10.09 22:41:07.662199 [ 3 ] {fd9f38de-327a-4eb0-bf93-a1f1440f4082} <Debug> oximeter.measurements_string (a894892b-9f77-4cad-8bde-8c4e28265950): Loading data parts
394 2024.10.09 22:41:07.662612 [ 3 ] {fd9f38de-327a-4eb0-bf93-a1f1440f4082} <Debug> oximeter.measurements_string (a894892b-9f77-4cad-8bde-8c4e28265950): There are no data parts
395 2024.10.09 22:41:07.664503 [ 3 ] {fd9f38de-327a-4eb0-bf93-a1f1440f4082} <Debug> DynamicQueryHandler: Done processing query
396 2024.10.09 22:41:07.664582 [ 3 ] {} <Debug> HTTP-Session: 6fa42f21-f0e3-4a93-9ef7-7ef41cdfd407 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
397 2024.10.09 22:41:07.674332 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
398 2024.10.09 22:41:07.674460 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
399 2024.10.09 22:41:07.674517 [ 3 ] {} <Debug> HTTP-Session: 94069b97-0774-4a04-81c6-7398a33f2fc8 Authenticating user 'default' from [::1]:52512
400 2024.10.09 22:41:07.674544 [ 3 ] {} <Debug> HTTP-Session: 94069b97-0774-4a04-81c6-7398a33f2fc8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
401 2024.10.09 22:41:07.674559 [ 3 ] {} <Debug> HTTP-Session: 94069b97-0774-4a04-81c6-7398a33f2fc8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
402 2024.10.09 22:41:07.674616 [ 3 ] {} <Trace> HTTP-Session: 94069b97-0774-4a04-81c6-7398a33f2fc8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
403 2024.10.09 22:41:07.675063 [ 3 ] {27a3f757-301e-4406-a948-77e60e3d7710} <Debug> executeQuery: (from [::1]:52512) 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:07.675153 [ 3 ] {27a3f757-301e-4406-a948-77e60e3d7710} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
412 2024.10.09 22:41:07.678084 [ 3 ] {27a3f757-301e-4406-a948-77e60e3d7710} <Debug> oximeter.measurements_bytes (7981d252-6465-4dda-95e4-b29876471862): Loading data parts
413 2024.10.09 22:41:07.678484 [ 3 ] {27a3f757-301e-4406-a948-77e60e3d7710} <Debug> oximeter.measurements_bytes (7981d252-6465-4dda-95e4-b29876471862): There are no data parts
414 2024.10.09 22:41:07.680433 [ 3 ] {27a3f757-301e-4406-a948-77e60e3d7710} <Debug> DynamicQueryHandler: Done processing query
415 2024.10.09 22:41:07.680478 [ 3 ] {} <Debug> HTTP-Session: 94069b97-0774-4a04-81c6-7398a33f2fc8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
416 2024.10.09 22:41:07.683070 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
417 2024.10.09 22:41:07.683276 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
418 2024.10.09 22:41:07.683326 [ 3 ] {} <Debug> HTTP-Session: b18c7cbf-17fa-4413-ac61-dea9da245d7f Authenticating user 'default' from [::1]:52512
419 2024.10.09 22:41:07.683354 [ 3 ] {} <Debug> HTTP-Session: b18c7cbf-17fa-4413-ac61-dea9da245d7f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
420 2024.10.09 22:41:07.683369 [ 3 ] {} <Debug> HTTP-Session: b18c7cbf-17fa-4413-ac61-dea9da245d7f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
421 2024.10.09 22:41:07.683431 [ 3 ] {} <Trace> HTTP-Session: b18c7cbf-17fa-4413-ac61-dea9da245d7f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
422 2024.10.09 22:41:07.683850 [ 3 ] {31e0e5cf-f134-44d0-becf-2ccbe6a4dc40} <Debug> executeQuery: (from [::1]:52512) 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:07.684002 [ 3 ] {31e0e5cf-f134-44d0-becf-2ccbe6a4dc40} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
424 2024.10.09 22:41:07.686750 [ 3 ] {31e0e5cf-f134-44d0-becf-2ccbe6a4dc40} <Debug> oximeter.measurements_cumulativei64 (8849f00f-3ed9-4eb3-b521-66474a7381c6): Loading data parts
425 2024.10.09 22:41:07.687094 [ 3 ] {31e0e5cf-f134-44d0-becf-2ccbe6a4dc40} <Debug> oximeter.measurements_cumulativei64 (8849f00f-3ed9-4eb3-b521-66474a7381c6): There are no data parts
426 2024.10.09 22:41:07.689023 [ 3 ] {31e0e5cf-f134-44d0-becf-2ccbe6a4dc40} <Debug> DynamicQueryHandler: Done processing query
427 2024.10.09 22:41:07.689051 [ 3 ] {} <Debug> HTTP-Session: b18c7cbf-17fa-4413-ac61-dea9da245d7f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
428 2024.10.09 22:41:07.703194 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
429 2024.10.09 22:41:07.703343 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
430 2024.10.09 22:41:07.703368 [ 3 ] {} <Debug> HTTP-Session: b4127c3d-b77b-42b2-a1f7-feb97a636968 Authenticating user 'default' from [::1]:52512
431 2024.10.09 22:41:07.703394 [ 3 ] {} <Debug> HTTP-Session: b4127c3d-b77b-42b2-a1f7-feb97a636968 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
432 2024.10.09 22:41:07.703415 [ 3 ] {} <Debug> HTTP-Session: b4127c3d-b77b-42b2-a1f7-feb97a636968 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
433 2024.10.09 22:41:07.703469 [ 3 ] {} <Trace> HTTP-Session: b4127c3d-b77b-42b2-a1f7-feb97a636968 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
434 2024.10.09 22:41:07.703875 [ 3 ] {9592a2a2-f795-4afd-9e0a-02deba770e37} <Debug> executeQuery: (from [::1]:52512) 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:07.703945 [ 3 ] {9592a2a2-f795-4afd-9e0a-02deba770e37} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
436 2024.10.09 22:41:07.706649 [ 3 ] {9592a2a2-f795-4afd-9e0a-02deba770e37} <Debug> oximeter.measurements_cumulativeu64 (4cc0c9b2-281f-40ff-b39f-c95e4722dd9b): Loading data parts
437 2024.10.09 22:41:07.707004 [ 3 ] {9592a2a2-f795-4afd-9e0a-02deba770e37} <Debug> oximeter.measurements_cumulativeu64 (4cc0c9b2-281f-40ff-b39f-c95e4722dd9b): There are no data parts
438 2024.10.09 22:41:07.710673 [ 3 ] {9592a2a2-f795-4afd-9e0a-02deba770e37} <Debug> DynamicQueryHandler: Done processing query
439 2024.10.09 22:41:07.710717 [ 3 ] {} <Debug> HTTP-Session: b4127c3d-b77b-42b2-a1f7-feb97a636968 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
440 2024.10.09 22:41:07.741446 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
441 2024.10.09 22:41:07.741567 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
442 2024.10.09 22:41:07.741609 [ 3 ] {} <Debug> HTTP-Session: dd0e4cb1-64a9-40b0-8348-3da200de4ad8 Authenticating user 'default' from [::1]:52512
443 2024.10.09 22:41:07.741636 [ 3 ] {} <Debug> HTTP-Session: dd0e4cb1-64a9-40b0-8348-3da200de4ad8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
444 2024.10.09 22:41:07.741651 [ 3 ] {} <Debug> HTTP-Session: dd0e4cb1-64a9-40b0-8348-3da200de4ad8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
445 2024.10.09 22:41:07.741712 [ 3 ] {} <Trace> HTTP-Session: dd0e4cb1-64a9-40b0-8348-3da200de4ad8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
446 2024.10.09 22:41:07.742087 [ 3 ] {e747bc0f-ca18-48e6-9654-7b18b065c481} <Debug> executeQuery: (from [::1]:52512) 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:07.742231 [ 3 ] {e747bc0f-ca18-48e6-9654-7b18b065c481} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
448 2024.10.09 22:41:07.744847 [ 3 ] {e747bc0f-ca18-48e6-9654-7b18b065c481} <Debug> oximeter.measurements_cumulativef32 (4c55b697-9ae9-4d9e-b499-f4b17f5b93ef): Loading data parts
449 2024.10.09 22:41:07.745219 [ 3 ] {e747bc0f-ca18-48e6-9654-7b18b065c481} <Debug> oximeter.measurements_cumulativef32 (4c55b697-9ae9-4d9e-b499-f4b17f5b93ef): There are no data parts
450 2024.10.09 22:41:07.746986 [ 3 ] {e747bc0f-ca18-48e6-9654-7b18b065c481} <Debug> DynamicQueryHandler: Done processing query
451 2024.10.09 22:41:07.747015 [ 3 ] {} <Debug> HTTP-Session: dd0e4cb1-64a9-40b0-8348-3da200de4ad8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
452 2024.10.09 22:41:07.758352 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
453 2024.10.09 22:41:07.758498 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
454 2024.10.09 22:41:07.758525 [ 3 ] {} <Debug> HTTP-Session: 16043697-4ce0-4c6a-b381-a97533153132 Authenticating user 'default' from [::1]:52512
455 2024.10.09 22:41:07.758574 [ 3 ] {} <Debug> HTTP-Session: 16043697-4ce0-4c6a-b381-a97533153132 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
456 2024.10.09 22:41:07.758589 [ 3 ] {} <Debug> HTTP-Session: 16043697-4ce0-4c6a-b381-a97533153132 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
457 2024.10.09 22:41:07.758647 [ 3 ] {} <Trace> HTTP-Session: 16043697-4ce0-4c6a-b381-a97533153132 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
458 2024.10.09 22:41:07.759038 [ 3 ] {fc6785f6-2b14-4231-bb02-b419383aec98} <Debug> executeQuery: (from [::1]:52512) 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:07.759123 [ 3 ] {fc6785f6-2b14-4231-bb02-b419383aec98} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
460 2024.10.09 22:41:07.761403 [ 3 ] {fc6785f6-2b14-4231-bb02-b419383aec98} <Debug> oximeter.measurements_cumulativef64 (7999364c-3714-4d0c-a5d2-61518a2d2afc): Loading data parts
461 2024.10.09 22:41:07.761745 [ 3 ] {fc6785f6-2b14-4231-bb02-b419383aec98} <Debug> oximeter.measurements_cumulativef64 (7999364c-3714-4d0c-a5d2-61518a2d2afc): There are no data parts
462 2024.10.09 22:41:07.763558 [ 3 ] {fc6785f6-2b14-4231-bb02-b419383aec98} <Debug> DynamicQueryHandler: Done processing query
463 2024.10.09 22:41:07.763588 [ 3 ] {} <Debug> HTTP-Session: 16043697-4ce0-4c6a-b381-a97533153132 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
464 2024.10.09 22:41:07.766173 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
465 2024.10.09 22:41:07.766312 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
466 2024.10.09 22:41:07.766344 [ 3 ] {} <Debug> HTTP-Session: 5cd59716-9d6f-495c-8bc6-aac5f76cb7b5 Authenticating user 'default' from [::1]:52512
467 2024.10.09 22:41:07.766369 [ 3 ] {} <Debug> HTTP-Session: 5cd59716-9d6f-495c-8bc6-aac5f76cb7b5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
468 2024.10.09 22:41:07.766391 [ 3 ] {} <Debug> HTTP-Session: 5cd59716-9d6f-495c-8bc6-aac5f76cb7b5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
469 2024.10.09 22:41:07.766512 [ 3 ] {} <Trace> HTTP-Session: 5cd59716-9d6f-495c-8bc6-aac5f76cb7b5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
470 2024.10.09 22:41:07.766933 [ 3 ] {1b0eb386-6f31-4a98-a8f3-f50b85693e09} <Debug> executeQuery: (from [::1]:52512) 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:07.767021 [ 3 ] {1b0eb386-6f31-4a98-a8f3-f50b85693e09} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
482 2024.10.09 22:41:07.769940 [ 3 ] {1b0eb386-6f31-4a98-a8f3-f50b85693e09} <Debug> oximeter.measurements_histogrami8 (e7837a3e-d329-4f13-9dc8-bd8ec676b5c6): Loading data parts
483 2024.10.09 22:41:07.770344 [ 3 ] {1b0eb386-6f31-4a98-a8f3-f50b85693e09} <Debug> oximeter.measurements_histogrami8 (e7837a3e-d329-4f13-9dc8-bd8ec676b5c6): There are no data parts
484 2024.10.09 22:41:07.772215 [ 3 ] {1b0eb386-6f31-4a98-a8f3-f50b85693e09} <Debug> DynamicQueryHandler: Done processing query
485 2024.10.09 22:41:07.772242 [ 3 ] {} <Debug> HTTP-Session: 5cd59716-9d6f-495c-8bc6-aac5f76cb7b5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
486 2024.10.09 22:41:07.780803 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
487 2024.10.09 22:41:07.780954 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
488 2024.10.09 22:41:07.780985 [ 3 ] {} <Debug> HTTP-Session: 19016deb-aa38-4dc0-b5ec-5e707042c8f8 Authenticating user 'default' from [::1]:52512
489 2024.10.09 22:41:07.781024 [ 3 ] {} <Debug> HTTP-Session: 19016deb-aa38-4dc0-b5ec-5e707042c8f8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
490 2024.10.09 22:41:07.781040 [ 3 ] {} <Debug> HTTP-Session: 19016deb-aa38-4dc0-b5ec-5e707042c8f8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
491 2024.10.09 22:41:07.781100 [ 3 ] {} <Trace> HTTP-Session: 19016deb-aa38-4dc0-b5ec-5e707042c8f8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
492 2024.10.09 22:41:07.781693 [ 3 ] {3f1f08dc-e7d4-4208-b43d-f2df6fbf87f7} <Debug> executeQuery: (from [::1]:52512) 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:07.781803 [ 3 ] {3f1f08dc-e7d4-4208-b43d-f2df6fbf87f7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
494 2024.10.09 22:41:07.786713 [ 3 ] {3f1f08dc-e7d4-4208-b43d-f2df6fbf87f7} <Debug> oximeter.measurements_histogramu8 (123ef654-b2f8-4bce-8039-2b51e3f3ff0c): Loading data parts
495 2024.10.09 22:41:07.787194 [ 3 ] {3f1f08dc-e7d4-4208-b43d-f2df6fbf87f7} <Debug> oximeter.measurements_histogramu8 (123ef654-b2f8-4bce-8039-2b51e3f3ff0c): There are no data parts
496 2024.10.09 22:41:07.789462 [ 3 ] {3f1f08dc-e7d4-4208-b43d-f2df6fbf87f7} <Debug> DynamicQueryHandler: Done processing query
497 2024.10.09 22:41:07.789516 [ 3 ] {} <Debug> HTTP-Session: 19016deb-aa38-4dc0-b5ec-5e707042c8f8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
498 2024.10.09 22:41:07.790572 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
499 2024.10.09 22:41:07.790655 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
500 2024.10.09 22:41:07.790699 [ 3 ] {} <Debug> HTTP-Session: 2fc8bc31-8408-4192-820f-22211ce02967 Authenticating user 'default' from [::1]:52512
501 2024.10.09 22:41:07.790731 [ 3 ] {} <Debug> HTTP-Session: 2fc8bc31-8408-4192-820f-22211ce02967 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
502 2024.10.09 22:41:07.790750 [ 3 ] {} <Debug> HTTP-Session: 2fc8bc31-8408-4192-820f-22211ce02967 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
503 2024.10.09 22:41:07.790817 [ 3 ] {} <Trace> HTTP-Session: 2fc8bc31-8408-4192-820f-22211ce02967 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
504 2024.10.09 22:41:07.791379 [ 3 ] {6e30a99f-a4b2-45b2-8ab9-491b92edad5c} <Debug> executeQuery: (from [::1]:52512) 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:07.791485 [ 3 ] {6e30a99f-a4b2-45b2-8ab9-491b92edad5c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
506 2024.10.09 22:41:07.795414 [ 3 ] {6e30a99f-a4b2-45b2-8ab9-491b92edad5c} <Debug> oximeter.measurements_histogrami16 (d2d6bd0e-84d9-4933-ac85-d4fefb58bab1): Loading data parts
507 2024.10.09 22:41:07.795728 [ 3 ] {6e30a99f-a4b2-45b2-8ab9-491b92edad5c} <Debug> oximeter.measurements_histogrami16 (d2d6bd0e-84d9-4933-ac85-d4fefb58bab1): There are no data parts
508 2024.10.09 22:41:07.797653 [ 3 ] {6e30a99f-a4b2-45b2-8ab9-491b92edad5c} <Debug> DynamicQueryHandler: Done processing query
509 2024.10.09 22:41:07.797686 [ 3 ] {} <Debug> HTTP-Session: 2fc8bc31-8408-4192-820f-22211ce02967 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
510 2024.10.09 22:41:07.808469 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
511 2024.10.09 22:41:07.808620 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
512 2024.10.09 22:41:07.808653 [ 3 ] {} <Debug> HTTP-Session: cdeefc0a-3c02-473c-9781-f1b56055062d Authenticating user 'default' from [::1]:52512
513 2024.10.09 22:41:07.808684 [ 3 ] {} <Debug> HTTP-Session: cdeefc0a-3c02-473c-9781-f1b56055062d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
514 2024.10.09 22:41:07.808711 [ 3 ] {} <Debug> HTTP-Session: cdeefc0a-3c02-473c-9781-f1b56055062d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
515 2024.10.09 22:41:07.808770 [ 3 ] {} <Trace> HTTP-Session: cdeefc0a-3c02-473c-9781-f1b56055062d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
516 2024.10.09 22:41:07.809331 [ 3 ] {23f39a55-a516-4290-890b-16a393802eda} <Debug> executeQuery: (from [::1]:52512) 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:07.809462 [ 3 ] {23f39a55-a516-4290-890b-16a393802eda} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
518 2024.10.09 22:41:07.812569 [ 3 ] {23f39a55-a516-4290-890b-16a393802eda} <Debug> oximeter.measurements_histogramu16 (bc77713c-e911-470d-8023-e3e9a6d1004f): Loading data parts
519 2024.10.09 22:41:07.813038 [ 3 ] {23f39a55-a516-4290-890b-16a393802eda} <Debug> oximeter.measurements_histogramu16 (bc77713c-e911-470d-8023-e3e9a6d1004f): There are no data parts
520 2024.10.09 22:41:07.815203 [ 3 ] {23f39a55-a516-4290-890b-16a393802eda} <Debug> DynamicQueryHandler: Done processing query
521 2024.10.09 22:41:07.815238 [ 3 ] {} <Debug> HTTP-Session: cdeefc0a-3c02-473c-9781-f1b56055062d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
522 2024.10.09 22:41:07.817745 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
523 2024.10.09 22:41:07.817830 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
524 2024.10.09 22:41:07.817870 [ 3 ] {} <Debug> HTTP-Session: 4ae8489d-ff2b-43ba-a256-eabb83908ae7 Authenticating user 'default' from [::1]:52512
525 2024.10.09 22:41:07.817897 [ 3 ] {} <Debug> HTTP-Session: 4ae8489d-ff2b-43ba-a256-eabb83908ae7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
526 2024.10.09 22:41:07.817913 [ 3 ] {} <Debug> HTTP-Session: 4ae8489d-ff2b-43ba-a256-eabb83908ae7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
527 2024.10.09 22:41:07.817964 [ 3 ] {} <Trace> HTTP-Session: 4ae8489d-ff2b-43ba-a256-eabb83908ae7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
528 2024.10.09 22:41:07.818439 [ 3 ] {1184fe9e-d043-451b-acfa-e073ebcd4866} <Debug> executeQuery: (from [::1]:52512) 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:07.818550 [ 3 ] {1184fe9e-d043-451b-acfa-e073ebcd4866} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
530 2024.10.09 22:41:07.821552 [ 3 ] {1184fe9e-d043-451b-acfa-e073ebcd4866} <Debug> oximeter.measurements_histogrami32 (0b1c997f-aa21-4c94-be20-19d23f78f691): Loading data parts
531 2024.10.09 22:41:07.821904 [ 3 ] {1184fe9e-d043-451b-acfa-e073ebcd4866} <Debug> oximeter.measurements_histogrami32 (0b1c997f-aa21-4c94-be20-19d23f78f691): There are no data parts
532 2024.10.09 22:41:07.823912 [ 3 ] {1184fe9e-d043-451b-acfa-e073ebcd4866} <Debug> DynamicQueryHandler: Done processing query
533 2024.10.09 22:41:07.823942 [ 3 ] {} <Debug> HTTP-Session: 4ae8489d-ff2b-43ba-a256-eabb83908ae7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
534 2024.10.09 22:41:07.835588 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
535 2024.10.09 22:41:07.836085 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
536 2024.10.09 22:41:07.836150 [ 3 ] {} <Debug> HTTP-Session: 822ab597-b88e-43a4-9b21-e2ea37bdc238 Authenticating user 'default' from [::1]:52512
537 2024.10.09 22:41:07.836183 [ 3 ] {} <Debug> HTTP-Session: 822ab597-b88e-43a4-9b21-e2ea37bdc238 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
538 2024.10.09 22:41:07.836214 [ 3 ] {} <Debug> HTTP-Session: 822ab597-b88e-43a4-9b21-e2ea37bdc238 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
539 2024.10.09 22:41:07.836271 [ 3 ] {} <Trace> HTTP-Session: 822ab597-b88e-43a4-9b21-e2ea37bdc238 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
540 2024.10.09 22:41:07.836850 [ 3 ] {3677454b-f278-4b50-89dd-3e0e64655389} <Debug> executeQuery: (from [::1]:52512) 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:07.836950 [ 3 ] {3677454b-f278-4b50-89dd-3e0e64655389} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
542 2024.10.09 22:41:07.845255 [ 3 ] {3677454b-f278-4b50-89dd-3e0e64655389} <Debug> oximeter.measurements_histogramu32 (904605ad-e0dc-43e0-b786-6ce1904c7a52): Loading data parts
543 2024.10.09 22:41:07.845614 [ 3 ] {3677454b-f278-4b50-89dd-3e0e64655389} <Debug> oximeter.measurements_histogramu32 (904605ad-e0dc-43e0-b786-6ce1904c7a52): There are no data parts
544 2024.10.09 22:41:07.847660 [ 3 ] {3677454b-f278-4b50-89dd-3e0e64655389} <Debug> DynamicQueryHandler: Done processing query
545 2024.10.09 22:41:07.847690 [ 3 ] {} <Debug> HTTP-Session: 822ab597-b88e-43a4-9b21-e2ea37bdc238 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
546 2024.10.09 22:41:07.851650 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
547 2024.10.09 22:41:07.851740 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
548 2024.10.09 22:41:07.851771 [ 3 ] {} <Debug> HTTP-Session: 36a55efc-9b0b-4a40-adf0-d0996f7e35fc Authenticating user 'default' from [::1]:52512
549 2024.10.09 22:41:07.851818 [ 3 ] {} <Debug> HTTP-Session: 36a55efc-9b0b-4a40-adf0-d0996f7e35fc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
550 2024.10.09 22:41:07.851836 [ 3 ] {} <Debug> HTTP-Session: 36a55efc-9b0b-4a40-adf0-d0996f7e35fc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
551 2024.10.09 22:41:07.851891 [ 3 ] {} <Trace> HTTP-Session: 36a55efc-9b0b-4a40-adf0-d0996f7e35fc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
552 2024.10.09 22:41:07.852494 [ 3 ] {0e94377f-8e1f-4420-abb8-06248db689e0} <Debug> executeQuery: (from [::1]:52512) 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:07.852594 [ 3 ] {0e94377f-8e1f-4420-abb8-06248db689e0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
554 2024.10.09 22:41:07.855680 [ 3 ] {0e94377f-8e1f-4420-abb8-06248db689e0} <Debug> oximeter.measurements_histogrami64 (75351c24-3ea7-4586-b1a2-9394254e66af): Loading data parts
555 2024.10.09 22:41:07.856009 [ 3 ] {0e94377f-8e1f-4420-abb8-06248db689e0} <Debug> oximeter.measurements_histogrami64 (75351c24-3ea7-4586-b1a2-9394254e66af): There are no data parts
556 2024.10.09 22:41:07.864060 [ 3 ] {0e94377f-8e1f-4420-abb8-06248db689e0} <Debug> DynamicQueryHandler: Done processing query
557 2024.10.09 22:41:07.864106 [ 3 ] {} <Debug> HTTP-Session: 36a55efc-9b0b-4a40-adf0-d0996f7e35fc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
558 2024.10.09 22:41:07.864867 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
559 2024.10.09 22:41:07.864996 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
560 2024.10.09 22:41:07.865026 [ 3 ] {} <Debug> HTTP-Session: 5594b8cf-4b55-498d-aea2-312d8a695af9 Authenticating user 'default' from [::1]:52512
561 2024.10.09 22:41:07.865054 [ 3 ] {} <Debug> HTTP-Session: 5594b8cf-4b55-498d-aea2-312d8a695af9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
562 2024.10.09 22:41:07.865071 [ 3 ] {} <Debug> HTTP-Session: 5594b8cf-4b55-498d-aea2-312d8a695af9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
563 2024.10.09 22:41:07.865138 [ 3 ] {} <Trace> HTTP-Session: 5594b8cf-4b55-498d-aea2-312d8a695af9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
564 2024.10.09 22:41:07.865650 [ 3 ] {f0b9d20d-fa15-4264-b537-21a2e4af31df} <Debug> executeQuery: (from [::1]:52512) 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:07.865760 [ 3 ] {f0b9d20d-fa15-4264-b537-21a2e4af31df} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
566 2024.10.09 22:41:07.873100 [ 3 ] {f0b9d20d-fa15-4264-b537-21a2e4af31df} <Debug> oximeter.measurements_histogramu64 (54f4f04e-2a02-40bd-b8e3-6a8a6b6b78fa): Loading data parts
567 2024.10.09 22:41:07.873688 [ 3 ] {f0b9d20d-fa15-4264-b537-21a2e4af31df} <Debug> oximeter.measurements_histogramu64 (54f4f04e-2a02-40bd-b8e3-6a8a6b6b78fa): There are no data parts
568 2024.10.09 22:41:07.896422 [ 3 ] {f0b9d20d-fa15-4264-b537-21a2e4af31df} <Debug> DynamicQueryHandler: Done processing query
569 2024.10.09 22:41:07.896469 [ 3 ] {} <Debug> HTTP-Session: 5594b8cf-4b55-498d-aea2-312d8a695af9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
570 2024.10.09 22:41:07.900811 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
571 2024.10.09 22:41:07.900950 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
572 2024.10.09 22:41:07.900978 [ 3 ] {} <Debug> HTTP-Session: 915e5635-1924-4c2a-953e-410c53d32c5e Authenticating user 'default' from [::1]:52512
573 2024.10.09 22:41:07.901081 [ 3 ] {} <Debug> HTTP-Session: 915e5635-1924-4c2a-953e-410c53d32c5e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
574 2024.10.09 22:41:07.901106 [ 3 ] {} <Debug> HTTP-Session: 915e5635-1924-4c2a-953e-410c53d32c5e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
575 2024.10.09 22:41:07.901319 [ 3 ] {} <Trace> HTTP-Session: 915e5635-1924-4c2a-953e-410c53d32c5e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
576 2024.10.09 22:41:07.913910 [ 3 ] {6b74de7e-a447-4fd7-8243-25ca503121de} <Debug> executeQuery: (from [::1]:52512) 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:07.914085 [ 3 ] {6b74de7e-a447-4fd7-8243-25ca503121de} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
578 2024.10.09 22:41:07.920570 [ 3 ] {6b74de7e-a447-4fd7-8243-25ca503121de} <Debug> oximeter.measurements_histogramf32 (effea4cc-9698-4dbb-811e-67e094f1aef8): Loading data parts
579 2024.10.09 22:41:07.920918 [ 3 ] {6b74de7e-a447-4fd7-8243-25ca503121de} <Debug> oximeter.measurements_histogramf32 (effea4cc-9698-4dbb-811e-67e094f1aef8): There are no data parts
580 2024.10.09 22:41:07.922979 [ 3 ] {6b74de7e-a447-4fd7-8243-25ca503121de} <Debug> DynamicQueryHandler: Done processing query
581 2024.10.09 22:41:07.923030 [ 3 ] {} <Debug> HTTP-Session: 915e5635-1924-4c2a-953e-410c53d32c5e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
582 2024.10.09 22:41:07.923746 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
583 2024.10.09 22:41:07.923824 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
584 2024.10.09 22:41:07.923938 [ 3 ] {} <Debug> HTTP-Session: 223c3c15-98f5-403e-924d-1144ad0b770a Authenticating user 'default' from [::1]:52512
585 2024.10.09 22:41:07.923976 [ 3 ] {} <Debug> HTTP-Session: 223c3c15-98f5-403e-924d-1144ad0b770a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
586 2024.10.09 22:41:07.923993 [ 3 ] {} <Debug> HTTP-Session: 223c3c15-98f5-403e-924d-1144ad0b770a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
587 2024.10.09 22:41:07.924058 [ 3 ] {} <Trace> HTTP-Session: 223c3c15-98f5-403e-924d-1144ad0b770a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
588 2024.10.09 22:41:07.924513 [ 3 ] {4b7407ad-d0e9-4a0e-9c84-bc84cdb9f38d} <Debug> executeQuery: (from [::1]:52512) 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:07.924613 [ 3 ] {4b7407ad-d0e9-4a0e-9c84-bc84cdb9f38d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
590 2024.10.09 22:41:07.927865 [ 3 ] {4b7407ad-d0e9-4a0e-9c84-bc84cdb9f38d} <Debug> oximeter.measurements_histogramf64 (e0d32284-26a5-479f-804a-8944fda98789): Loading data parts
591 2024.10.09 22:41:07.933329 [ 3 ] {4b7407ad-d0e9-4a0e-9c84-bc84cdb9f38d} <Debug> oximeter.measurements_histogramf64 (e0d32284-26a5-479f-804a-8944fda98789): There are no data parts
592 2024.10.09 22:41:07.940828 [ 3 ] {4b7407ad-d0e9-4a0e-9c84-bc84cdb9f38d} <Debug> DynamicQueryHandler: Done processing query
593 2024.10.09 22:41:07.940907 [ 3 ] {} <Debug> HTTP-Session: 223c3c15-98f5-403e-924d-1144ad0b770a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
594 2024.10.09 22:41:07.968172 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
595 2024.10.09 22:41:07.968379 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
596 2024.10.09 22:41:07.968411 [ 3 ] {} <Debug> HTTP-Session: 7dc76aaf-efa2-48f0-bdff-36e98a835922 Authenticating user 'default' from [::1]:52512
597 2024.10.09 22:41:07.968439 [ 3 ] {} <Debug> HTTP-Session: 7dc76aaf-efa2-48f0-bdff-36e98a835922 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
598 2024.10.09 22:41:07.968464 [ 3 ] {} <Debug> HTTP-Session: 7dc76aaf-efa2-48f0-bdff-36e98a835922 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
599 2024.10.09 22:41:07.968523 [ 3 ] {} <Trace> HTTP-Session: 7dc76aaf-efa2-48f0-bdff-36e98a835922 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
600 2024.10.09 22:41:07.968959 [ 3 ] {6e70ba08-cc40-4eb3-81d8-391538548f46} <Debug> executeQuery: (from [::1]:52512) /* 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:07.969056 [ 3 ] {6e70ba08-cc40-4eb3-81d8-391538548f46} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
627 2024.10.09 22:41:07.973183 [ 3 ] {6e70ba08-cc40-4eb3-81d8-391538548f46} <Debug> oximeter.fields_bool (72b93720-55e4-40b8-b09a-25ca73dcdc7c): Loading data parts
628 2024.10.09 22:41:07.975285 [ 3 ] {6e70ba08-cc40-4eb3-81d8-391538548f46} <Debug> oximeter.fields_bool (72b93720-55e4-40b8-b09a-25ca73dcdc7c): There are no data parts
629 2024.10.09 22:41:07.997496 [ 3 ] {6e70ba08-cc40-4eb3-81d8-391538548f46} <Debug> DynamicQueryHandler: Done processing query
630 2024.10.09 22:41:07.997561 [ 3 ] {} <Debug> HTTP-Session: 7dc76aaf-efa2-48f0-bdff-36e98a835922 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
631 2024.10.09 22:41:07.998280 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
632 2024.10.09 22:41:07.998424 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
633 2024.10.09 22:41:07.998470 [ 3 ] {} <Debug> HTTP-Session: 221ccb1a-5852-4c6b-8358-16b752c7556b Authenticating user 'default' from [::1]:52512
634 2024.10.09 22:41:07.998515 [ 3 ] {} <Debug> HTTP-Session: 221ccb1a-5852-4c6b-8358-16b752c7556b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
635 2024.10.09 22:41:07.998536 [ 3 ] {} <Debug> HTTP-Session: 221ccb1a-5852-4c6b-8358-16b752c7556b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
636 2024.10.09 22:41:07.998593 [ 3 ] {} <Trace> HTTP-Session: 221ccb1a-5852-4c6b-8358-16b752c7556b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
637 2024.10.09 22:41:07.999043 [ 3 ] {cb56ba3d-2d27-4a75-b12d-4faaf320364d} <Debug> executeQuery: (from [::1]:52512) 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:07.999495 [ 3 ] {cb56ba3d-2d27-4a75-b12d-4faaf320364d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
639 2024.10.09 22:41:08.004788 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 182.33 MiB, peak 182.35 MiB, free memory in arenas 0.00 B, will set to 185.72 MiB (RSS), difference: 3.39 MiB
640 2024.10.09 22:41:08.007095 [ 3 ] {cb56ba3d-2d27-4a75-b12d-4faaf320364d} <Debug> oximeter.fields_i8 (af7e9bc4-024c-44a5-a677-d2c5f06a1b6f): Loading data parts
641 2024.10.09 22:41:08.007444 [ 3 ] {cb56ba3d-2d27-4a75-b12d-4faaf320364d} <Debug> oximeter.fields_i8 (af7e9bc4-024c-44a5-a677-d2c5f06a1b6f): There are no data parts
642 2024.10.09 22:41:08.009639 [ 3 ] {cb56ba3d-2d27-4a75-b12d-4faaf320364d} <Debug> DynamicQueryHandler: Done processing query
643 2024.10.09 22:41:08.009671 [ 3 ] {} <Debug> HTTP-Session: 221ccb1a-5852-4c6b-8358-16b752c7556b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
644 2024.10.09 22:41:08.010600 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
645 2024.10.09 22:41:08.010698 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
646 2024.10.09 22:41:08.010726 [ 3 ] {} <Debug> HTTP-Session: 8796ba1c-9bc6-411e-b5e8-f4ff85a43ea8 Authenticating user 'default' from [::1]:52512
647 2024.10.09 22:41:08.010754 [ 3 ] {} <Debug> HTTP-Session: 8796ba1c-9bc6-411e-b5e8-f4ff85a43ea8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
648 2024.10.09 22:41:08.010782 [ 3 ] {} <Debug> HTTP-Session: 8796ba1c-9bc6-411e-b5e8-f4ff85a43ea8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
649 2024.10.09 22:41:08.010835 [ 3 ] {} <Trace> HTTP-Session: 8796ba1c-9bc6-411e-b5e8-f4ff85a43ea8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
650 2024.10.09 22:41:08.011214 [ 3 ] {c0b6a95e-7355-46f2-b032-78d2f73cd570} <Debug> executeQuery: (from [::1]:52512) 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)
651 2024.10.09 22:41:08.011291 [ 3 ] {c0b6a95e-7355-46f2-b032-78d2f73cd570} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
652 2024.10.09 22:41:08.014268 [ 3 ] {c0b6a95e-7355-46f2-b032-78d2f73cd570} <Debug> oximeter.fields_u8 (2a4bff66-2b21-4b3e-972a-2110971aed5f): Loading data parts
653 2024.10.09 22:41:08.014589 [ 3 ] {c0b6a95e-7355-46f2-b032-78d2f73cd570} <Debug> oximeter.fields_u8 (2a4bff66-2b21-4b3e-972a-2110971aed5f): There are no data parts
654 2024.10.09 22:41:08.016467 [ 3 ] {c0b6a95e-7355-46f2-b032-78d2f73cd570} <Debug> DynamicQueryHandler: Done processing query
655 2024.10.09 22:41:08.016518 [ 3 ] {} <Debug> HTTP-Session: 8796ba1c-9bc6-411e-b5e8-f4ff85a43ea8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
656 2024.10.09 22:41:08.017326 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
657 2024.10.09 22:41:08.017403 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
658 2024.10.09 22:41:08.017448 [ 3 ] {} <Debug> HTTP-Session: 27f0a726-b115-4940-af2c-1f2775f59956 Authenticating user 'default' from [::1]:52512
659 2024.10.09 22:41:08.017476 [ 3 ] {} <Debug> HTTP-Session: 27f0a726-b115-4940-af2c-1f2775f59956 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
660 2024.10.09 22:41:08.017494 [ 3 ] {} <Debug> HTTP-Session: 27f0a726-b115-4940-af2c-1f2775f59956 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
661 2024.10.09 22:41:08.017558 [ 3 ] {} <Trace> HTTP-Session: 27f0a726-b115-4940-af2c-1f2775f59956 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
662 2024.10.09 22:41:08.017876 [ 3 ] {f3342e9a-0241-4609-a98f-0d0baed7217d} <Debug> executeQuery: (from [::1]:52512) 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)
663 2024.10.09 22:41:08.017992 [ 3 ] {f3342e9a-0241-4609-a98f-0d0baed7217d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
664 2024.10.09 22:41:08.022100 [ 3 ] {f3342e9a-0241-4609-a98f-0d0baed7217d} <Debug> oximeter.fields_i16 (bd2795d2-d811-46af-a375-231cbc7c7ce6): Loading data parts
665 2024.10.09 22:41:08.022486 [ 3 ] {f3342e9a-0241-4609-a98f-0d0baed7217d} <Debug> oximeter.fields_i16 (bd2795d2-d811-46af-a375-231cbc7c7ce6): There are no data parts
666 2024.10.09 22:41:08.024391 [ 3 ] {f3342e9a-0241-4609-a98f-0d0baed7217d} <Debug> DynamicQueryHandler: Done processing query
667 2024.10.09 22:41:08.024421 [ 3 ] {} <Debug> HTTP-Session: 27f0a726-b115-4940-af2c-1f2775f59956 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
668 2024.10.09 22:41:08.025371 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
669 2024.10.09 22:41:08.025463 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
670 2024.10.09 22:41:08.025494 [ 3 ] {} <Debug> HTTP-Session: 31cacfb1-8231-4f7b-8360-fbf4cc322e40 Authenticating user 'default' from [::1]:52512
671 2024.10.09 22:41:08.025519 [ 3 ] {} <Debug> HTTP-Session: 31cacfb1-8231-4f7b-8360-fbf4cc322e40 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
672 2024.10.09 22:41:08.025548 [ 3 ] {} <Debug> HTTP-Session: 31cacfb1-8231-4f7b-8360-fbf4cc322e40 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
673 2024.10.09 22:41:08.025603 [ 3 ] {} <Trace> HTTP-Session: 31cacfb1-8231-4f7b-8360-fbf4cc322e40 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
674 2024.10.09 22:41:08.026200 [ 3 ] {af68d057-c8f0-48b0-a6b5-b8f3ae1d9cec} <Debug> executeQuery: (from [::1]:52512) 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)
675 2024.10.09 22:41:08.026308 [ 3 ] {af68d057-c8f0-48b0-a6b5-b8f3ae1d9cec} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
676 2024.10.09 22:41:08.063066 [ 3 ] {af68d057-c8f0-48b0-a6b5-b8f3ae1d9cec} <Debug> oximeter.fields_u16 (5df17580-e0ca-4a86-9acd-195ac9e3faf6): Loading data parts
677 2024.10.09 22:41:08.063633 [ 3 ] {af68d057-c8f0-48b0-a6b5-b8f3ae1d9cec} <Debug> oximeter.fields_u16 (5df17580-e0ca-4a86-9acd-195ac9e3faf6): There are no data parts
678 2024.10.09 22:41:08.065641 [ 3 ] {af68d057-c8f0-48b0-a6b5-b8f3ae1d9cec} <Debug> DynamicQueryHandler: Done processing query
679 2024.10.09 22:41:08.065694 [ 3 ] {} <Debug> HTTP-Session: 31cacfb1-8231-4f7b-8360-fbf4cc322e40 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
680 2024.10.09 22:41:08.066599 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
681 2024.10.09 22:41:08.066679 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
682 2024.10.09 22:41:08.066716 [ 3 ] {} <Debug> HTTP-Session: 768c2acc-8a0b-479f-b302-b4da29a69b63 Authenticating user 'default' from [::1]:52512
683 2024.10.09 22:41:08.066741 [ 3 ] {} <Debug> HTTP-Session: 768c2acc-8a0b-479f-b302-b4da29a69b63 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
684 2024.10.09 22:41:08.066757 [ 3 ] {} <Debug> HTTP-Session: 768c2acc-8a0b-479f-b302-b4da29a69b63 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
685 2024.10.09 22:41:08.066822 [ 3 ] {} <Trace> HTTP-Session: 768c2acc-8a0b-479f-b302-b4da29a69b63 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
686 2024.10.09 22:41:08.067159 [ 3 ] {7f3c514b-9fd1-4e9d-bc0b-2c8d8a93c2e5} <Debug> executeQuery: (from [::1]:52512) 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)
687 2024.10.09 22:41:08.067246 [ 3 ] {7f3c514b-9fd1-4e9d-bc0b-2c8d8a93c2e5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
688 2024.10.09 22:41:08.070848 [ 3 ] {7f3c514b-9fd1-4e9d-bc0b-2c8d8a93c2e5} <Debug> oximeter.fields_i32 (db21e1a4-e783-49ec-ae28-76090e715f26): Loading data parts
689 2024.10.09 22:41:08.073668 [ 3 ] {7f3c514b-9fd1-4e9d-bc0b-2c8d8a93c2e5} <Debug> oximeter.fields_i32 (db21e1a4-e783-49ec-ae28-76090e715f26): There are no data parts
690 2024.10.09 22:41:08.089623 [ 3 ] {7f3c514b-9fd1-4e9d-bc0b-2c8d8a93c2e5} <Debug> DynamicQueryHandler: Done processing query
691 2024.10.09 22:41:08.092378 [ 3 ] {} <Debug> HTTP-Session: 768c2acc-8a0b-479f-b302-b4da29a69b63 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
692 2024.10.09 22:41:08.095045 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
693 2024.10.09 22:41:08.095166 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
694 2024.10.09 22:41:08.095193 [ 3 ] {} <Debug> HTTP-Session: 3a1277de-8c0c-4799-8454-8a663c211a6b Authenticating user 'default' from [::1]:52512
695 2024.10.09 22:41:08.095223 [ 3 ] {} <Debug> HTTP-Session: 3a1277de-8c0c-4799-8454-8a663c211a6b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
696 2024.10.09 22:41:08.095251 [ 3 ] {} <Debug> HTTP-Session: 3a1277de-8c0c-4799-8454-8a663c211a6b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
697 2024.10.09 22:41:08.095308 [ 3 ] {} <Trace> HTTP-Session: 3a1277de-8c0c-4799-8454-8a663c211a6b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
698 2024.10.09 22:41:08.096441 [ 3 ] {b5508d11-2cb5-49c7-803a-cafee257da1a} <Debug> executeQuery: (from [::1]:52512) 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)
699 2024.10.09 22:41:08.096537 [ 3 ] {b5508d11-2cb5-49c7-803a-cafee257da1a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
700 2024.10.09 22:41:08.101518 [ 3 ] {b5508d11-2cb5-49c7-803a-cafee257da1a} <Debug> oximeter.fields_u32 (a22e0cc5-84d0-4fff-9d1d-40ed4709cd5c): Loading data parts
701 2024.10.09 22:41:08.102068 [ 3 ] {b5508d11-2cb5-49c7-803a-cafee257da1a} <Debug> oximeter.fields_u32 (a22e0cc5-84d0-4fff-9d1d-40ed4709cd5c): There are no data parts
702 2024.10.09 22:41:08.105972 [ 3 ] {b5508d11-2cb5-49c7-803a-cafee257da1a} <Debug> DynamicQueryHandler: Done processing query
703 2024.10.09 22:41:08.106007 [ 3 ] {} <Debug> HTTP-Session: 3a1277de-8c0c-4799-8454-8a663c211a6b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
704 2024.10.09 22:41:08.107002 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
705 2024.10.09 22:41:08.107085 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
706 2024.10.09 22:41:08.107124 [ 3 ] {} <Debug> HTTP-Session: 59831944-2fdb-4520-9e20-f2ea4ba7e52e Authenticating user 'default' from [::1]:52512
707 2024.10.09 22:41:08.107150 [ 3 ] {} <Debug> HTTP-Session: 59831944-2fdb-4520-9e20-f2ea4ba7e52e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
708 2024.10.09 22:41:08.107165 [ 3 ] {} <Debug> HTTP-Session: 59831944-2fdb-4520-9e20-f2ea4ba7e52e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
709 2024.10.09 22:41:08.107566 [ 3 ] {} <Trace> HTTP-Session: 59831944-2fdb-4520-9e20-f2ea4ba7e52e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
710 2024.10.09 22:41:08.113111 [ 3 ] {dee47a78-d7d5-4885-a390-1dbc3ce69f93} <Debug> executeQuery: (from [::1]:52512) 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)
711 2024.10.09 22:41:08.113239 [ 3 ] {dee47a78-d7d5-4885-a390-1dbc3ce69f93} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
712 2024.10.09 22:41:08.116189 [ 3 ] {dee47a78-d7d5-4885-a390-1dbc3ce69f93} <Debug> oximeter.fields_i64 (57648f75-2602-4e9e-81b0-c3f0a3afeee2): Loading data parts
713 2024.10.09 22:41:08.116524 [ 3 ] {dee47a78-d7d5-4885-a390-1dbc3ce69f93} <Debug> oximeter.fields_i64 (57648f75-2602-4e9e-81b0-c3f0a3afeee2): There are no data parts
714 2024.10.09 22:41:08.123856 [ 3 ] {dee47a78-d7d5-4885-a390-1dbc3ce69f93} <Debug> DynamicQueryHandler: Done processing query
715 2024.10.09 22:41:08.123890 [ 3 ] {} <Debug> HTTP-Session: 59831944-2fdb-4520-9e20-f2ea4ba7e52e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
716 2024.10.09 22:41:08.124724 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
717 2024.10.09 22:41:08.124819 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
718 2024.10.09 22:41:08.124845 [ 3 ] {} <Debug> HTTP-Session: 29783fe4-9ad8-411d-952b-5ce83ae4e3c3 Authenticating user 'default' from [::1]:52512
719 2024.10.09 22:41:08.124873 [ 3 ] {} <Debug> HTTP-Session: 29783fe4-9ad8-411d-952b-5ce83ae4e3c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
720 2024.10.09 22:41:08.124887 [ 3 ] {} <Debug> HTTP-Session: 29783fe4-9ad8-411d-952b-5ce83ae4e3c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
721 2024.10.09 22:41:08.124938 [ 3 ] {} <Trace> HTTP-Session: 29783fe4-9ad8-411d-952b-5ce83ae4e3c3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
722 2024.10.09 22:41:08.125263 [ 3 ] {8b9cf398-be8d-4a53-bdba-0da4fcca2434} <Debug> executeQuery: (from [::1]:52512) 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)
723 2024.10.09 22:41:08.125334 [ 3 ] {8b9cf398-be8d-4a53-bdba-0da4fcca2434} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
724 2024.10.09 22:41:08.127916 [ 3 ] {8b9cf398-be8d-4a53-bdba-0da4fcca2434} <Debug> oximeter.fields_u64 (329d3997-5ec4-423b-b271-16f66ee00389): Loading data parts
725 2024.10.09 22:41:08.128276 [ 3 ] {8b9cf398-be8d-4a53-bdba-0da4fcca2434} <Debug> oximeter.fields_u64 (329d3997-5ec4-423b-b271-16f66ee00389): There are no data parts
726 2024.10.09 22:41:08.129981 [ 3 ] {8b9cf398-be8d-4a53-bdba-0da4fcca2434} <Debug> DynamicQueryHandler: Done processing query
727 2024.10.09 22:41:08.130030 [ 3 ] {} <Debug> HTTP-Session: 29783fe4-9ad8-411d-952b-5ce83ae4e3c3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
728 2024.10.09 22:41:08.130770 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
729 2024.10.09 22:41:08.130834 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
730 2024.10.09 22:41:08.130860 [ 3 ] {} <Debug> HTTP-Session: 7fe950cc-e1b1-4755-8fc4-d0c968a7870c Authenticating user 'default' from [::1]:52512
731 2024.10.09 22:41:08.130885 [ 3 ] {} <Debug> HTTP-Session: 7fe950cc-e1b1-4755-8fc4-d0c968a7870c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
732 2024.10.09 22:41:08.130898 [ 3 ] {} <Debug> HTTP-Session: 7fe950cc-e1b1-4755-8fc4-d0c968a7870c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
733 2024.10.09 22:41:08.130942 [ 3 ] {} <Trace> HTTP-Session: 7fe950cc-e1b1-4755-8fc4-d0c968a7870c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
734 2024.10.09 22:41:08.141666 [ 3 ] {01fe777a-67fa-4a5f-b009-e941d637902f} <Debug> executeQuery: (from [::1]:52512) 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)
735 2024.10.09 22:41:08.141771 [ 3 ] {01fe777a-67fa-4a5f-b009-e941d637902f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
736 2024.10.09 22:41:08.146702 [ 3 ] {01fe777a-67fa-4a5f-b009-e941d637902f} <Debug> oximeter.fields_ipaddr (c2f0c6ee-c37b-474e-9d33-45b50ef40bd4): Loading data parts
737 2024.10.09 22:41:08.146957 [ 3 ] {01fe777a-67fa-4a5f-b009-e941d637902f} <Debug> oximeter.fields_ipaddr (c2f0c6ee-c37b-474e-9d33-45b50ef40bd4): There are no data parts
738 2024.10.09 22:41:08.161466 [ 3 ] {01fe777a-67fa-4a5f-b009-e941d637902f} <Debug> DynamicQueryHandler: Done processing query
739 2024.10.09 22:41:08.161512 [ 3 ] {} <Debug> HTTP-Session: 7fe950cc-e1b1-4755-8fc4-d0c968a7870c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
740 2024.10.09 22:41:08.181699 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
741 2024.10.09 22:41:08.185303 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
742 2024.10.09 22:41:08.186002 [ 3 ] {} <Debug> HTTP-Session: 3d240a31-cd55-4403-a680-0a9f40baf5cf Authenticating user 'default' from [::1]:52512
743 2024.10.09 22:41:08.186093 [ 3 ] {} <Debug> HTTP-Session: 3d240a31-cd55-4403-a680-0a9f40baf5cf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
744 2024.10.09 22:41:08.186113 [ 3 ] {} <Debug> HTTP-Session: 3d240a31-cd55-4403-a680-0a9f40baf5cf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
745 2024.10.09 22:41:08.186174 [ 3 ] {} <Trace> HTTP-Session: 3d240a31-cd55-4403-a680-0a9f40baf5cf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
746 2024.10.09 22:41:08.189120 [ 3 ] {cd989137-682e-4efc-a265-8ca758b83d76} <Debug> executeQuery: (from [::1]:52512) 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)
747 2024.10.09 22:41:08.189205 [ 3 ] {cd989137-682e-4efc-a265-8ca758b83d76} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
748 2024.10.09 22:41:08.197960 [ 3 ] {cd989137-682e-4efc-a265-8ca758b83d76} <Debug> oximeter.fields_string (3ae6b016-b56f-45b0-bb98-fbf609587319): Loading data parts
749 2024.10.09 22:41:08.231968 [ 3 ] {cd989137-682e-4efc-a265-8ca758b83d76} <Debug> oximeter.fields_string (3ae6b016-b56f-45b0-bb98-fbf609587319): There are no data parts
750 2024.10.09 22:41:08.238495 [ 3 ] {cd989137-682e-4efc-a265-8ca758b83d76} <Debug> DynamicQueryHandler: Done processing query
751 2024.10.09 22:41:08.238569 [ 3 ] {} <Debug> HTTP-Session: 3d240a31-cd55-4403-a680-0a9f40baf5cf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
752 2024.10.09 22:41:08.317376 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
753 2024.10.09 22:41:08.317503 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
754 2024.10.09 22:41:08.317532 [ 3 ] {} <Debug> HTTP-Session: 8852e1d3-c240-4b34-8ac0-818724ce6aa3 Authenticating user 'default' from [::1]:52512
755 2024.10.09 22:41:08.317561 [ 3 ] {} <Debug> HTTP-Session: 8852e1d3-c240-4b34-8ac0-818724ce6aa3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
756 2024.10.09 22:41:08.317579 [ 3 ] {} <Debug> HTTP-Session: 8852e1d3-c240-4b34-8ac0-818724ce6aa3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
757 2024.10.09 22:41:08.317641 [ 3 ] {} <Trace> HTTP-Session: 8852e1d3-c240-4b34-8ac0-818724ce6aa3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
758 2024.10.09 22:41:08.318114 [ 3 ] {5b0cf65e-cd67-4574-b515-4651824422fe} <Debug> executeQuery: (from [::1]:52512) 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)
759 2024.10.09 22:41:08.318192 [ 3 ] {5b0cf65e-cd67-4574-b515-4651824422fe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
760 2024.10.09 22:41:08.321460 [ 3 ] {5b0cf65e-cd67-4574-b515-4651824422fe} <Debug> oximeter.fields_uuid (09186a86-d7d1-4c94-8dde-d6df0d5cd37e): Loading data parts
761 2024.10.09 22:41:08.322147 [ 3 ] {5b0cf65e-cd67-4574-b515-4651824422fe} <Debug> oximeter.fields_uuid (09186a86-d7d1-4c94-8dde-d6df0d5cd37e): There are no data parts
762 2024.10.09 22:41:08.355325 [ 3 ] {5b0cf65e-cd67-4574-b515-4651824422fe} <Debug> DynamicQueryHandler: Done processing query
763 2024.10.09 22:41:08.355403 [ 3 ] {} <Debug> HTTP-Session: 8852e1d3-c240-4b34-8ac0-818724ce6aa3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
764 2024.10.09 22:41:08.361870 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
765 2024.10.09 22:41:08.361974 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
766 2024.10.09 22:41:08.362131 [ 3 ] {} <Debug> HTTP-Session: 718ef135-13b9-47d2-aeea-13a85a18923a Authenticating user 'default' from [::1]:52512
767 2024.10.09 22:41:08.362169 [ 3 ] {} <Debug> HTTP-Session: 718ef135-13b9-47d2-aeea-13a85a18923a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
768 2024.10.09 22:41:08.362958 [ 3 ] {} <Debug> HTTP-Session: 718ef135-13b9-47d2-aeea-13a85a18923a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
769 2024.10.09 22:41:08.363030 [ 3 ] {} <Trace> HTTP-Session: 718ef135-13b9-47d2-aeea-13a85a18923a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
770 2024.10.09 22:41:08.363476 [ 3 ] {0d0928bc-e20d-41d7-b0f4-50de0100b9f1} <Debug> executeQuery: (from [::1]:52512) /* The timeseries schema table stores the extracted schema for the samples
771 * oximeter collects.
772 */
773 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)
774 2024.10.09 22:41:08.363578 [ 3 ] {0d0928bc-e20d-41d7-b0f4-50de0100b9f1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
775 2024.10.09 22:41:08.369625 [ 3 ] {0d0928bc-e20d-41d7-b0f4-50de0100b9f1} <Debug> oximeter.timeseries_schema (0eb61de6-e568-46ca-a58f-51a4a55295a2): Loading data parts
776 2024.10.09 22:41:08.370267 [ 3 ] {0d0928bc-e20d-41d7-b0f4-50de0100b9f1} <Debug> oximeter.timeseries_schema (0eb61de6-e568-46ca-a58f-51a4a55295a2): There are no data parts
777 2024.10.09 22:41:08.377287 [ 3 ] {0d0928bc-e20d-41d7-b0f4-50de0100b9f1} <Debug> DynamicQueryHandler: Done processing query
778 2024.10.09 22:41:08.377333 [ 3 ] {} <Debug> HTTP-Session: 718ef135-13b9-47d2-aeea-13a85a18923a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
779 2024.10.09 22:41:08.382192 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52512, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
780 2024.10.09 22:41:08.382315 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
781 2024.10.09 22:41:08.382346 [ 3 ] {} <Debug> HTTP-Session: dd985637-291f-4bbe-9205-e9bd48523b44 Authenticating user 'default' from [::1]:52512
782 2024.10.09 22:41:08.382375 [ 3 ] {} <Debug> HTTP-Session: dd985637-291f-4bbe-9205-e9bd48523b44 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
783 2024.10.09 22:41:08.382392 [ 3 ] {} <Debug> HTTP-Session: dd985637-291f-4bbe-9205-e9bd48523b44 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
784 2024.10.09 22:41:08.382467 [ 3 ] {} <Trace> HTTP-Session: dd985637-291f-4bbe-9205-e9bd48523b44 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
785 2024.10.09 22:41:08.382725 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Debug> executeQuery: (from [::1]:52512) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
786 2024.10.09 22:41:08.382909 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
787 2024.10.09 22:41:08.384430 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Trace> oximeter.version (14ff95b0-c8b5-4809-a3a0-36deecf96a66): Trying to reserve 1.00 MiB using storage policy from min volume index 0
788 2024.10.09 22:41:08.384485 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.22 GiB.
789 2024.10.09 22:41:08.385301 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
790 2024.10.09 22:41:08.385983 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Trace> oximeter.version (14ff95b0-c8b5-4809-a3a0-36deecf96a66): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
791 2024.10.09 22:41:08.386839 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.004009 sec., 249.43876278373656 rows/sec., 3.90 KiB/sec.
792 2024.10.09 22:41:08.387261 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Debug> DynamicQueryHandler: Done processing query
793 2024.10.09 22:41:08.387292 [ 3 ] {f438d006-f95a-41fd-89fc-dc9c1761475e} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB.
794 2024.10.09 22:41:08.387312 [ 3 ] {} <Debug> HTTP-Session: dd985637-291f-4bbe-9205-e9bd48523b44 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
795 2024.10.09 22:41:09.000699 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 185.77 MiB, peak 190.91 MiB, free memory in arenas 0.00 B, will set to 186.90 MiB (RSS), difference: 1.14 MiB