Max level shown:
1 [ May 14 09:44:44 Enabled. ]
2 [ May 14 09:44:44 Rereading configuration. ]
3 [ May 14 09:44:48 Rereading configuration. ]
4 [ May 14 09:44:54 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ]
5 + set -o errexit
6 + set -o pipefail
7 + . /lib/svc/share/smf_include.sh
8 ++ SMF_EXIT_OK=0
9 ++ SMF_EXIT_NODAEMON=94
10 ++ SMF_EXIT_ERR_FATAL=95
11 ++ SMF_EXIT_ERR_CONFIG=96
12 ++ SMF_EXIT_MON_DEGRADE=97
13 ++ SMF_EXIT_MON_OFFLINE=98
14 ++ SMF_EXIT_ERR_NOSMF=99
15 ++ SMF_EXIT_ERR_PERM=100
16 ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default
17 + LISTEN_ADDR=fd00:1122:3344:101::e
18 ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default
19 + LISTEN_PORT=8123
20 ++ svcprop -c -p config/store svc:/oxide/clickhouse:default
21 + DATASTORE=/data
22 + single_node=true
23 + command=()
24 + true
25 + command+=("/opt/oxide/clickhouse/clickhouse" "server" "--log-file" "/var/tmp/clickhouse-server.log" "--errorlog-file" "/var/tmp/clickhouse-server.errlog" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT")
26 + exec /opt/oxide/clickhouse/clickhouse server --log-file /var/tmp/clickhouse-server.log --errorlog-file /var/tmp/clickhouse-server.errlog -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123
27 [ May 14 09:44:54 Method "start" exited with status 0. ]
28 Processing configuration file 'config.xml'.
29 There is no file 'config.xml', will use embedded config.
30 Logging trace to /var/tmp/clickhouse-server.log
31 Logging errors to /var/tmp/clickhouse-server.errlog
32 2024.05.14 09:44:55.251926 [ 1 ] {} <Information> Application: Will watch for the process with pid 25840
33 2024.05.14 09:44:55.252786 [ 1 ] {} <Information> Application: Forked a child process to watch
34 2024.05.14 09:44:55.462380 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 25840
35 2024.05.14 09:44:55.463055 [ 1 ] {} <Information> Application: starting up
36 2024.05.14 09:44:55.463737 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc
37 2024.05.14 09:44:55.549165 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48.
38 2024.05.14 09:44:55.587653 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536
39 2024.05.14 09:44:55.587721 [ 1 ] {} <Debug> Application: Initializing DateLUT.
40 2024.05.14 09:44:55.587755 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
41 2024.05.14 09:44:55.587862 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it
42 2024.05.14 09:44:55.588141 [ 1 ] {} <Debug> Application: Initializing interserver credentials.
43 2024.05.14 09:44:55.589588 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
44 Processing configuration file 'config.xml'.
45 There is no file 'config.xml', will use embedded config.
46 Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'.
47 2024.05.14 09:44:55.590058 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
48 2024.05.14 09:44:55.590863 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
49 2024.05.14 09:44:55.590889 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
50 2024.05.14 09:44:55.590902 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB
51 2024.05.14 09:44:55.591069 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
52 2024.05.14 09:44:55.592090 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
53 2024.05.14 09:44:55.598089 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
54 2024.05.14 09:44:55.598846 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
55 2024.05.14 09:44:55.600170 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
56 2024.05.14 09:44:55.600232 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
57 2024.05.14 09:44:55.601227 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
58 Processing configuration file 'config.xml'.
59 There is no file 'config.xml', will use embedded config.
60 Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'.
61 2024.05.14 09:44:55.601552 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
62 2024.05.14 09:44:55.605241 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
63 2024.05.14 09:44:55.605493 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml
64 2024.05.14 09:44:55.607012 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
65 2024.05.14 09:44:55.607442 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
66 2024.05.14 09:44:55.607810 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
67 2024.05.14 09:44:55.608166 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
68 2024.05.14 09:44:55.609631 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
69 2024.05.14 09:44:55.609659 [ 1 ] {} <Information> Application: Loading metadata from /data/
70 2024.05.14 09:44:55.609742 [ 140 ] {} <Debug> DNSResolver: Updating DNS cache
71 2024.05.14 09:44:55.609915 [ 140 ] {} <Debug> DNSResolver: Updated DNS cache
72 2024.05.14 09:44:55.627189 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
73 2024.05.14 09:44:55.627220 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000155884 sec
74 2024.05.14 09:44:55.627257 [ 1 ] {} <Trace> ReferentialDeps: No tables
75 2024.05.14 09:44:55.627269 [ 1 ] {} <Trace> LoadingDeps: No tables
76 2024.05.14 09:44:55.628344 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables.
77 2024.05.14 09:44:55.629341 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config
78 2024.05.14 09:44:55.629364 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
79 2024.05.14 09:44:55.629396 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
80 2024.05.14 09:44:55.629411 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
81 2024.05.14 09:44:55.629423 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
82 2024.05.14 09:44:55.629455 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
83 2024.05.14 09:44:55.629468 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config
84 2024.05.14 09:44:55.629482 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
85 2024.05.14 09:44:55.629515 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
86 2024.05.14 09:44:55.629528 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config
87 2024.05.14 09:44:55.629542 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
88 2024.05.14 09:44:55.629557 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
89 2024.05.14 09:44:55.629589 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
90 2024.05.14 09:44:55.629603 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
91 2024.05.14 09:44:55.629618 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
92 2024.05.14 09:44:55.629645 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
93 2024.05.14 09:44:55.629658 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
94 2024.05.14 09:44:55.664527 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
95 2024.05.14 09:44:55.671464 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
96 2024.05.14 09:44:55.671491 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.4981e-05 sec
97 2024.05.14 09:44:55.671504 [ 1 ] {} <Trace> ReferentialDeps: No tables
98 2024.05.14 09:44:55.671518 [ 1 ] {} <Trace> LoadingDeps: No tables
99 2024.05.14 09:44:55.671539 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables.
100 2024.05.14 09:44:55.671716 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/
101 2024.05.14 09:44:55.671756 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
102 2024.05.14 09:44:55.671768 [ 1 ] {} <Debug> Application: Loaded metadata.
103 2024.05.14 09:44:55.671783 [ 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).
104 2024.05.14 09:44:55.671795 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled.
105 2024.05.14 09:44:55.717587 [ 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)
106 2024.05.14 09:44:56.273478 [ 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)
107 2024.05.14 09:44:56.273534 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
108 2024.05.14 09:44:56.340285 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
109 2024.05.14 09:44:56.340502 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.86 MiB, peak 16.07 MiB, free memory in arenas 0.00 B, will set to 157.07 MiB (RSS), difference: 147.21 MiB
110 2024.05.14 09:44:56.341369 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.283e-05 sec.
111 2024.05.14 09:44:56.341750 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123
112 2024.05.14 09:44:56.341840 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000
113 2024.05.14 09:44:56.341900 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [fd00:1122:3344:101::e]:9004
114 2024.05.14 09:44:56.341926 [ 1 ] {} <Information> Application: Ready for connections.
115 2024.05.14 09:44:56.342769 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
116 2024.05.14 09:44:56.342974 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
117 2024.05.14 09:44:56.343007 [ 3 ] {} <Debug> HTTP-Session: 53d4b1d3-2345-400d-a844-67fb7abd6402 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
118 2024.05.14 09:44:56.343036 [ 3 ] {} <Debug> HTTP-Session: 53d4b1d3-2345-400d-a844-67fb7abd6402 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
119 2024.05.14 09:44:56.343053 [ 3 ] {} <Debug> HTTP-Session: 53d4b1d3-2345-400d-a844-67fb7abd6402 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
120 2024.05.14 09:44:56.343137 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
121 2024.05.14 09:44:56.343170 [ 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
122 2024.05.14 09:44:56.343190 [ 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
123 2024.05.14 09:44:56.343254 [ 3 ] {} <Trace> HTTP-Session: 53d4b1d3-2345-400d-a844-67fb7abd6402 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
124 2024.05.14 09:44:56.344326 [ 3 ] {f626453d-82e6-4889-85e1-ff269a80e906} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
125 2024.05.14 09:44:56.388200 [ 3 ] {f626453d-82e6-4889-85e1-ff269a80e906} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:49435) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
126 
127 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse
128 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse
129 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 /opt/oxide/clickhouse/clickhouse
130 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse
131 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse
132 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse
133 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 /opt/oxide/clickhouse/clickhouse
134 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 /opt/oxide/clickhouse/clickhouse
135 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 /opt/oxide/clickhouse/clickhouse
136 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 /opt/oxide/clickhouse/clickhouse
137 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 /opt/oxide/clickhouse/clickhouse
138 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse
139 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse
140 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 /opt/oxide/clickhouse/clickhouse
141 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse
142 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse
143 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse
144 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse
145 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse
146 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse
147 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse
148 21. _thrp_setup @ 0x0000000000114257 in /system/lib/amd64/libc.so.1
149 
150 2024.05.14 09:44:56.388906 [ 3 ] {f626453d-82e6-4889-85e1-ff269a80e906} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
151 
152 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse
153 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse
154 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 /opt/oxide/clickhouse/clickhouse
155 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse
156 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse
157 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse
158 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 /opt/oxide/clickhouse/clickhouse
159 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 /opt/oxide/clickhouse/clickhouse
160 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 /opt/oxide/clickhouse/clickhouse
161 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 /opt/oxide/clickhouse/clickhouse
162 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 /opt/oxide/clickhouse/clickhouse
163 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse
164 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse
165 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 /opt/oxide/clickhouse/clickhouse
166 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse
167 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse
168 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse
169 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse
170 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse
171 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse
172 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse
173 21. _thrp_setup @ 0x0000000000114257 in /system/lib/amd64/libc.so.1
174 (version 23.8.7.1)
175 2024.05.14 09:44:56.390298 [ 3 ] {} <Debug> HTTP-Session: 53d4b1d3-2345-400d-a844-67fb7abd6402 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
176 2024.05.14 09:44:56.391211 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 33, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
177 2024.05.14 09:44:56.391282 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
178 2024.05.14 09:44:56.391308 [ 3 ] {} <Debug> HTTP-Session: cb217231-2240-45fc-9b58-26c5287609ef Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
179 2024.05.14 09:44:56.391333 [ 3 ] {} <Debug> HTTP-Session: cb217231-2240-45fc-9b58-26c5287609ef Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
180 2024.05.14 09:44:56.391347 [ 3 ] {} <Debug> HTTP-Session: cb217231-2240-45fc-9b58-26c5287609ef Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
181 2024.05.14 09:44:56.391391 [ 3 ] {} <Trace> HTTP-Session: cb217231-2240-45fc-9b58-26c5287609ef Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
182 2024.05.14 09:44:56.392524 [ 3 ] {d38b2601-3aef-43f9-9e16-73b7395b59af} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) SHOW CLUSTERS FORMAT JSONEachRow; (stage: Complete)
183 2024.05.14 09:44:56.392643 [ 3 ] {d38b2601-3aef-43f9-9e16-73b7395b59af} <Debug> executeQuery: (internal) SELECT DISTINCT cluster FROM system.clusters ORDER BY cluster (stage: Complete)
184 2024.05.14 09:44:56.394690 [ 3 ] {d38b2601-3aef-43f9-9e16-73b7395b59af} <Trace> ContextAccess (default): Access granted: SELECT(cluster) ON system.clusters
185 2024.05.14 09:44:56.397479 [ 3 ] {d38b2601-3aef-43f9-9e16-73b7395b59af} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
186 2024.05.14 09:44:56.403703 [ 3 ] {d38b2601-3aef-43f9-9e16-73b7395b59af} <Debug> DynamicQueryHandler: Done processing query
187 2024.05.14 09:44:56.403738 [ 3 ] {d38b2601-3aef-43f9-9e16-73b7395b59af} <Debug> MemoryTracker: Peak memory usage (for query): 3.00 MiB.
188 2024.05.14 09:44:56.403761 [ 3 ] {} <Debug> HTTP-Session: cb217231-2240-45fc-9b58-26c5287609ef Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
189 2024.05.14 09:44:56.406147 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
190 2024.05.14 09:44:56.406205 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
191 2024.05.14 09:44:56.406229 [ 3 ] {} <Debug> HTTP-Session: 8b72ea4a-4a57-4f79-a62e-fe1a02d8a708 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
192 2024.05.14 09:44:56.406246 [ 3 ] {} <Debug> HTTP-Session: 8b72ea4a-4a57-4f79-a62e-fe1a02d8a708 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
193 2024.05.14 09:44:56.406262 [ 3 ] {} <Debug> HTTP-Session: 8b72ea4a-4a57-4f79-a62e-fe1a02d8a708 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
194 2024.05.14 09:44:56.406301 [ 3 ] {} <Trace> HTTP-Session: 8b72ea4a-4a57-4f79-a62e-fe1a02d8a708 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
195 2024.05.14 09:44:56.406430 [ 3 ] {f018339c-9b16-4eaf-b151-bc204253a2d0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
196 2024.05.14 09:44:56.406679 [ 3 ] {f018339c-9b16-4eaf-b151-bc204253a2d0} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:49435) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
197 
198 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse
199 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse
200 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 /opt/oxide/clickhouse/clickhouse
201 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse
202 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse
203 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse
204 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 /opt/oxide/clickhouse/clickhouse
205 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 /opt/oxide/clickhouse/clickhouse
206 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 /opt/oxide/clickhouse/clickhouse
207 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 /opt/oxide/clickhouse/clickhouse
208 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 /opt/oxide/clickhouse/clickhouse
209 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse
210 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse
211 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 /opt/oxide/clickhouse/clickhouse
212 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse
213 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse
214 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse
215 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse
216 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse
217 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse
218 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse
219 21. _thrp_setup @ 0x0000000000114257 in /system/lib/amd64/libc.so.1
220 
221 2024.05.14 09:44:56.406793 [ 3 ] {f018339c-9b16-4eaf-b151-bc204253a2d0} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
222 
223 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse
224 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse
225 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 /opt/oxide/clickhouse/clickhouse
226 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse
227 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse
228 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse
229 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 /opt/oxide/clickhouse/clickhouse
230 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 /opt/oxide/clickhouse/clickhouse
231 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 /opt/oxide/clickhouse/clickhouse
232 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 /opt/oxide/clickhouse/clickhouse
233 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 /opt/oxide/clickhouse/clickhouse
234 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse
235 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse
236 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 /opt/oxide/clickhouse/clickhouse
237 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse
238 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse
239 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse
240 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse
241 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse
242 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse
243 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse
244 21. _thrp_setup @ 0x0000000000114257 in /system/lib/amd64/libc.so.1
245 (version 23.8.7.1)
246 2024.05.14 09:44:56.406931 [ 3 ] {} <Debug> HTTP-Session: 8b72ea4a-4a57-4f79-a62e-fe1a02d8a708 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
247 2024.05.14 09:44:56.407141 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
248 2024.05.14 09:44:56.407190 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
249 2024.05.14 09:44:56.407209 [ 3 ] {} <Debug> HTTP-Session: f58abb63-572e-40bc-9482-884adc306ec5 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
250 2024.05.14 09:44:56.407229 [ 3 ] {} <Debug> HTTP-Session: f58abb63-572e-40bc-9482-884adc306ec5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
251 2024.05.14 09:44:56.407246 [ 3 ] {} <Debug> HTTP-Session: f58abb63-572e-40bc-9482-884adc306ec5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
252 2024.05.14 09:44:56.407275 [ 3 ] {} <Trace> HTTP-Session: f58abb63-572e-40bc-9482-884adc306ec5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
253 2024.05.14 09:44:56.407443 [ 3 ] {715620d1-b972-4e25-97a6-10974e8ffd39} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) DROP DATABASE IF EXISTS oximeter (stage: Complete)
254 2024.05.14 09:44:56.407601 [ 3 ] {715620d1-b972-4e25-97a6-10974e8ffd39} <Debug> DynamicQueryHandler: Done processing query
255 2024.05.14 09:44:56.407624 [ 3 ] {} <Debug> HTTP-Session: f58abb63-572e-40bc-9482-884adc306ec5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
256 2024.05.14 09:44:56.407755 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
257 2024.05.14 09:44:56.407804 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
258 2024.05.14 09:44:56.407826 [ 3 ] {} <Debug> HTTP-Session: 9e9f0f05-1de3-4b27-850f-18f0ea11d191 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
259 2024.05.14 09:44:56.407842 [ 3 ] {} <Debug> HTTP-Session: 9e9f0f05-1de3-4b27-850f-18f0ea11d191 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
260 2024.05.14 09:44:56.407857 [ 3 ] {} <Debug> HTTP-Session: 9e9f0f05-1de3-4b27-850f-18f0ea11d191 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
261 2024.05.14 09:44:56.407888 [ 3 ] {} <Trace> HTTP-Session: 9e9f0f05-1de3-4b27-850f-18f0ea11d191 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
262 2024.05.14 09:44:56.407971 [ 3 ] {fb24c162-59d8-43e3-a140-6b06f9ba8cce} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
263 2024.05.14 09:44:56.408028 [ 3 ] {fb24c162-59d8-43e3-a140-6b06f9ba8cce} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
264 2024.05.14 09:44:56.409663 [ 3 ] {fb24c162-59d8-43e3-a140-6b06f9ba8cce} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
265 2024.05.14 09:44:56.409693 [ 3 ] {fb24c162-59d8-43e3-a140-6b06f9ba8cce} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.1532e-05 sec
266 2024.05.14 09:44:56.409706 [ 3 ] {fb24c162-59d8-43e3-a140-6b06f9ba8cce} <Trace> ReferentialDeps: No tables
267 2024.05.14 09:44:56.409720 [ 3 ] {fb24c162-59d8-43e3-a140-6b06f9ba8cce} <Trace> LoadingDeps: No tables
268 2024.05.14 09:44:56.409742 [ 3 ] {fb24c162-59d8-43e3-a140-6b06f9ba8cce} <Information> DatabaseAtomic (oximeter): Starting up tables.
269 2024.05.14 09:44:56.409860 [ 3 ] {fb24c162-59d8-43e3-a140-6b06f9ba8cce} <Debug> DynamicQueryHandler: Done processing query
270 2024.05.14 09:44:56.409883 [ 3 ] {} <Debug> HTTP-Session: 9e9f0f05-1de3-4b27-850f-18f0ea11d191 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
271 2024.05.14 09:44:56.409996 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
272 2024.05.14 09:44:56.410043 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
273 2024.05.14 09:44:56.410061 [ 3 ] {} <Debug> HTTP-Session: 7164acf8-b7b8-4395-b633-78a926983efd Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
274 2024.05.14 09:44:56.410081 [ 3 ] {} <Debug> HTTP-Session: 7164acf8-b7b8-4395-b633-78a926983efd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
275 2024.05.14 09:44:56.410099 [ 3 ] {} <Debug> HTTP-Session: 7164acf8-b7b8-4395-b633-78a926983efd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
276 2024.05.14 09:44:56.410127 [ 3 ] {} <Trace> HTTP-Session: 7164acf8-b7b8-4395-b633-78a926983efd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
277 2024.05.14 09:44:56.410262 [ 3 ] {f4f78799-a513-464c-bbf8-001ce3b05bc6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) /* The version table contains metadata about the `oximeter` database */
278 CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete)
279 2024.05.14 09:44:56.410307 [ 3 ] {f4f78799-a513-464c-bbf8-001ce3b05bc6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
280 2024.05.14 09:44:56.414504 [ 3 ] {f4f78799-a513-464c-bbf8-001ce3b05bc6} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
281 2024.05.14 09:44:56.423297 [ 3 ] {f4f78799-a513-464c-bbf8-001ce3b05bc6} <Debug> oximeter.version (59999636-6651-4b9e-9754-42bb6995b91d): Loading data parts
282 2024.05.14 09:44:56.423659 [ 3 ] {f4f78799-a513-464c-bbf8-001ce3b05bc6} <Debug> oximeter.version (59999636-6651-4b9e-9754-42bb6995b91d): There are no data parts
283 2024.05.14 09:44:56.426784 [ 3 ] {f4f78799-a513-464c-bbf8-001ce3b05bc6} <Debug> DynamicQueryHandler: Done processing query
284 2024.05.14 09:44:56.426810 [ 3 ] {} <Debug> HTTP-Session: 7164acf8-b7b8-4395-b633-78a926983efd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
285 2024.05.14 09:44:56.426963 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
286 2024.05.14 09:44:56.427015 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
287 2024.05.14 09:44:56.427037 [ 3 ] {} <Debug> HTTP-Session: e497e252-68a4-4396-afed-83b0b3ca038f Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
288 2024.05.14 09:44:56.427053 [ 3 ] {} <Debug> HTTP-Session: e497e252-68a4-4396-afed-83b0b3ca038f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
289 2024.05.14 09:44:56.427069 [ 3 ] {} <Debug> HTTP-Session: e497e252-68a4-4396-afed-83b0b3ca038f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
290 2024.05.14 09:44:56.427101 [ 3 ] {} <Trace> HTTP-Session: e497e252-68a4-4396-afed-83b0b3ca038f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
291 2024.05.14 09:44:56.427287 [ 3 ] {073ab280-0273-42bd-959b-3194acd08964} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) /* The measurement tables contain all individual samples from each timeseries.
292 *
293 * Each table stores a single datum type, and otherwise contains nearly the same
294 * structure. The primary sorting key is on the timeseries name, key, and then
295 * timestamp, so that all timeseries from the same schema are grouped, followed
296 * by all samples from the same timeseries.
297 *
298 * This reflects that one usually looks up the _key_ in one or more field table,
299 * and then uses that to index quickly into the measurements tables.
300 */
301 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)
302 2024.05.14 09:44:56.427340 [ 3 ] {073ab280-0273-42bd-959b-3194acd08964} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
303 2024.05.14 09:44:56.434741 [ 3 ] {073ab280-0273-42bd-959b-3194acd08964} <Debug> oximeter.measurements_bool (e377855e-cf0e-49eb-9f45-593b95b7b3ff): Loading data parts
304 2024.05.14 09:44:56.434922 [ 3 ] {073ab280-0273-42bd-959b-3194acd08964} <Debug> oximeter.measurements_bool (e377855e-cf0e-49eb-9f45-593b95b7b3ff): There are no data parts
305 2024.05.14 09:44:56.436279 [ 3 ] {073ab280-0273-42bd-959b-3194acd08964} <Debug> DynamicQueryHandler: Done processing query
306 2024.05.14 09:44:56.436305 [ 3 ] {} <Debug> HTTP-Session: e497e252-68a4-4396-afed-83b0b3ca038f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
307 2024.05.14 09:44:56.436441 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
308 2024.05.14 09:44:56.436493 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
309 2024.05.14 09:44:56.436517 [ 3 ] {} <Debug> HTTP-Session: c2b12949-0f20-476c-b1fa-fb5ccae61084 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
310 2024.05.14 09:44:56.436533 [ 3 ] {} <Debug> HTTP-Session: c2b12949-0f20-476c-b1fa-fb5ccae61084 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
311 2024.05.14 09:44:56.436550 [ 3 ] {} <Debug> HTTP-Session: c2b12949-0f20-476c-b1fa-fb5ccae61084 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
312 2024.05.14 09:44:56.436580 [ 3 ] {} <Trace> HTTP-Session: c2b12949-0f20-476c-b1fa-fb5ccae61084 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
313 2024.05.14 09:44:56.436753 [ 3 ] {1576d17c-6786-4610-8537-a7339f0aa65b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
314 2024.05.14 09:44:56.436801 [ 3 ] {1576d17c-6786-4610-8537-a7339f0aa65b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
315 2024.05.14 09:44:56.444977 [ 3 ] {1576d17c-6786-4610-8537-a7339f0aa65b} <Debug> oximeter.measurements_i8 (fb945f21-7e8d-48a9-8fdc-98c908ebdc3c): Loading data parts
316 2024.05.14 09:44:56.445221 [ 3 ] {1576d17c-6786-4610-8537-a7339f0aa65b} <Debug> oximeter.measurements_i8 (fb945f21-7e8d-48a9-8fdc-98c908ebdc3c): There are no data parts
317 2024.05.14 09:44:56.447108 [ 3 ] {1576d17c-6786-4610-8537-a7339f0aa65b} <Debug> DynamicQueryHandler: Done processing query
318 2024.05.14 09:44:56.447143 [ 3 ] {} <Debug> HTTP-Session: c2b12949-0f20-476c-b1fa-fb5ccae61084 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
319 2024.05.14 09:44:56.447262 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
320 2024.05.14 09:44:56.447314 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
321 2024.05.14 09:44:56.447339 [ 3 ] {} <Debug> HTTP-Session: 3261183e-224c-4018-a883-bc22e7e4d727 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
322 2024.05.14 09:44:56.447359 [ 3 ] {} <Debug> HTTP-Session: 3261183e-224c-4018-a883-bc22e7e4d727 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
323 2024.05.14 09:44:56.447376 [ 3 ] {} <Debug> HTTP-Session: 3261183e-224c-4018-a883-bc22e7e4d727 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
324 2024.05.14 09:44:56.447409 [ 3 ] {} <Trace> HTTP-Session: 3261183e-224c-4018-a883-bc22e7e4d727 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
325 2024.05.14 09:44:56.447579 [ 3 ] {98053a4c-979a-4bbd-baeb-8e456f9b4743} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
326 2024.05.14 09:44:56.447632 [ 3 ] {98053a4c-979a-4bbd-baeb-8e456f9b4743} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
327 2024.05.14 09:44:56.450393 [ 3 ] {98053a4c-979a-4bbd-baeb-8e456f9b4743} <Debug> oximeter.measurements_u8 (b9131c87-b7b4-4ba1-b86e-00109a191a6c): Loading data parts
328 2024.05.14 09:44:56.450579 [ 3 ] {98053a4c-979a-4bbd-baeb-8e456f9b4743} <Debug> oximeter.measurements_u8 (b9131c87-b7b4-4ba1-b86e-00109a191a6c): There are no data parts
329 2024.05.14 09:44:56.451903 [ 3 ] {98053a4c-979a-4bbd-baeb-8e456f9b4743} <Debug> DynamicQueryHandler: Done processing query
330 2024.05.14 09:44:56.451928 [ 3 ] {} <Debug> HTTP-Session: 3261183e-224c-4018-a883-bc22e7e4d727 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
331 2024.05.14 09:44:56.452042 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
332 2024.05.14 09:44:56.452094 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
333 2024.05.14 09:44:56.452117 [ 3 ] {} <Debug> HTTP-Session: 5a68d3cf-5676-4360-a7cd-07fc90f3b950 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
334 2024.05.14 09:44:56.452134 [ 3 ] {} <Debug> HTTP-Session: 5a68d3cf-5676-4360-a7cd-07fc90f3b950 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
335 2024.05.14 09:44:56.452151 [ 3 ] {} <Debug> HTTP-Session: 5a68d3cf-5676-4360-a7cd-07fc90f3b950 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
336 2024.05.14 09:44:56.452184 [ 3 ] {} <Trace> HTTP-Session: 5a68d3cf-5676-4360-a7cd-07fc90f3b950 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
337 2024.05.14 09:44:56.452361 [ 3 ] {470b4216-4ac2-4953-bab5-689f184ee701} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
338 2024.05.14 09:44:56.452411 [ 3 ] {470b4216-4ac2-4953-bab5-689f184ee701} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
339 2024.05.14 09:44:56.462563 [ 3 ] {470b4216-4ac2-4953-bab5-689f184ee701} <Debug> oximeter.measurements_i16 (8d9a4920-d8dd-4378-af68-2ddd74192421): Loading data parts
340 2024.05.14 09:44:56.462725 [ 3 ] {470b4216-4ac2-4953-bab5-689f184ee701} <Debug> oximeter.measurements_i16 (8d9a4920-d8dd-4378-af68-2ddd74192421): There are no data parts
341 2024.05.14 09:44:56.464741 [ 3 ] {470b4216-4ac2-4953-bab5-689f184ee701} <Debug> DynamicQueryHandler: Done processing query
342 2024.05.14 09:44:56.464773 [ 3 ] {} <Debug> HTTP-Session: 5a68d3cf-5676-4360-a7cd-07fc90f3b950 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
343 2024.05.14 09:44:56.464888 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
344 2024.05.14 09:44:56.464941 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
345 2024.05.14 09:44:56.464965 [ 3 ] {} <Debug> HTTP-Session: 174aff9a-ae29-4d3b-af29-1efd23ed7a74 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
346 2024.05.14 09:44:56.464981 [ 3 ] {} <Debug> HTTP-Session: 174aff9a-ae29-4d3b-af29-1efd23ed7a74 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
347 2024.05.14 09:44:56.464998 [ 3 ] {} <Debug> HTTP-Session: 174aff9a-ae29-4d3b-af29-1efd23ed7a74 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
348 2024.05.14 09:44:56.465032 [ 3 ] {} <Trace> HTTP-Session: 174aff9a-ae29-4d3b-af29-1efd23ed7a74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
349 2024.05.14 09:44:56.465201 [ 3 ] {5a53f1a6-d39c-40db-a15b-97ef7f34d41d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
350 2024.05.14 09:44:56.465254 [ 3 ] {5a53f1a6-d39c-40db-a15b-97ef7f34d41d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
351 2024.05.14 09:44:56.468007 [ 3 ] {5a53f1a6-d39c-40db-a15b-97ef7f34d41d} <Debug> oximeter.measurements_u16 (93b41fa6-882d-4cd3-b5f9-78cc034b93dd): Loading data parts
352 2024.05.14 09:44:56.468169 [ 3 ] {5a53f1a6-d39c-40db-a15b-97ef7f34d41d} <Debug> oximeter.measurements_u16 (93b41fa6-882d-4cd3-b5f9-78cc034b93dd): There are no data parts
353 2024.05.14 09:44:56.469420 [ 3 ] {5a53f1a6-d39c-40db-a15b-97ef7f34d41d} <Debug> DynamicQueryHandler: Done processing query
354 2024.05.14 09:44:56.469451 [ 3 ] {} <Debug> HTTP-Session: 174aff9a-ae29-4d3b-af29-1efd23ed7a74 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
355 2024.05.14 09:44:56.469562 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
356 2024.05.14 09:44:56.469614 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
357 2024.05.14 09:44:56.469637 [ 3 ] {} <Debug> HTTP-Session: e4b0e409-0cd4-4ec8-a3e8-81f37fced2d9 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
358 2024.05.14 09:44:56.469661 [ 3 ] {} <Debug> HTTP-Session: e4b0e409-0cd4-4ec8-a3e8-81f37fced2d9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
359 2024.05.14 09:44:56.469674 [ 3 ] {} <Debug> HTTP-Session: e4b0e409-0cd4-4ec8-a3e8-81f37fced2d9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
360 2024.05.14 09:44:56.469707 [ 3 ] {} <Trace> HTTP-Session: e4b0e409-0cd4-4ec8-a3e8-81f37fced2d9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
361 2024.05.14 09:44:56.469886 [ 3 ] {93990a77-8ae6-4739-a1a3-1e688d0c35e5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
362 2024.05.14 09:44:56.469935 [ 3 ] {93990a77-8ae6-4739-a1a3-1e688d0c35e5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
363 2024.05.14 09:44:56.478140 [ 3 ] {93990a77-8ae6-4739-a1a3-1e688d0c35e5} <Debug> oximeter.measurements_i32 (d08560ff-93db-4ecd-ac80-0dab2dee7924): Loading data parts
364 2024.05.14 09:44:56.478281 [ 3 ] {93990a77-8ae6-4739-a1a3-1e688d0c35e5} <Debug> oximeter.measurements_i32 (d08560ff-93db-4ecd-ac80-0dab2dee7924): There are no data parts
365 2024.05.14 09:44:56.480105 [ 3 ] {93990a77-8ae6-4739-a1a3-1e688d0c35e5} <Debug> DynamicQueryHandler: Done processing query
366 2024.05.14 09:44:56.480136 [ 3 ] {} <Debug> HTTP-Session: e4b0e409-0cd4-4ec8-a3e8-81f37fced2d9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
367 2024.05.14 09:44:56.480258 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
368 2024.05.14 09:44:56.480312 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
369 2024.05.14 09:44:56.480340 [ 3 ] {} <Debug> HTTP-Session: 8e12466f-b63b-496e-8100-12517cbc4878 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
370 2024.05.14 09:44:56.480358 [ 3 ] {} <Debug> HTTP-Session: 8e12466f-b63b-496e-8100-12517cbc4878 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
371 2024.05.14 09:44:56.480375 [ 3 ] {} <Debug> HTTP-Session: 8e12466f-b63b-496e-8100-12517cbc4878 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
372 2024.05.14 09:44:56.480409 [ 3 ] {} <Trace> HTTP-Session: 8e12466f-b63b-496e-8100-12517cbc4878 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
373 2024.05.14 09:44:56.480580 [ 3 ] {be120cae-7c7d-466a-9f77-7ad16cf178ba} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
374 2024.05.14 09:44:56.480629 [ 3 ] {be120cae-7c7d-466a-9f77-7ad16cf178ba} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
375 2024.05.14 09:44:56.483377 [ 3 ] {be120cae-7c7d-466a-9f77-7ad16cf178ba} <Debug> oximeter.measurements_u32 (d55d0775-c1f6-494c-bdce-d6d95b5601d0): Loading data parts
376 2024.05.14 09:44:56.483540 [ 3 ] {be120cae-7c7d-466a-9f77-7ad16cf178ba} <Debug> oximeter.measurements_u32 (d55d0775-c1f6-494c-bdce-d6d95b5601d0): There are no data parts
377 2024.05.14 09:44:56.484802 [ 3 ] {be120cae-7c7d-466a-9f77-7ad16cf178ba} <Debug> DynamicQueryHandler: Done processing query
378 2024.05.14 09:44:56.484832 [ 3 ] {} <Debug> HTTP-Session: 8e12466f-b63b-496e-8100-12517cbc4878 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
379 2024.05.14 09:44:56.484947 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
380 2024.05.14 09:44:56.484999 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
381 2024.05.14 09:44:56.485023 [ 3 ] {} <Debug> HTTP-Session: 4cde059c-5cfa-4282-b9c3-6ce8d4e6fea0 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
382 2024.05.14 09:44:56.485043 [ 3 ] {} <Debug> HTTP-Session: 4cde059c-5cfa-4282-b9c3-6ce8d4e6fea0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
383 2024.05.14 09:44:56.485056 [ 3 ] {} <Debug> HTTP-Session: 4cde059c-5cfa-4282-b9c3-6ce8d4e6fea0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
384 2024.05.14 09:44:56.485090 [ 3 ] {} <Trace> HTTP-Session: 4cde059c-5cfa-4282-b9c3-6ce8d4e6fea0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
385 2024.05.14 09:44:56.485268 [ 3 ] {c92b477f-5142-4b42-b117-84650dfd8674} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
386 2024.05.14 09:44:56.485321 [ 3 ] {c92b477f-5142-4b42-b117-84650dfd8674} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
387 2024.05.14 09:44:56.495529 [ 3 ] {c92b477f-5142-4b42-b117-84650dfd8674} <Debug> oximeter.measurements_i64 (e09fbc8e-bc3f-4f98-aad3-f8bb030ecfce): Loading data parts
388 2024.05.14 09:44:56.495705 [ 3 ] {c92b477f-5142-4b42-b117-84650dfd8674} <Debug> oximeter.measurements_i64 (e09fbc8e-bc3f-4f98-aad3-f8bb030ecfce): There are no data parts
389 2024.05.14 09:44:56.497815 [ 3 ] {c92b477f-5142-4b42-b117-84650dfd8674} <Debug> DynamicQueryHandler: Done processing query
390 2024.05.14 09:44:56.497859 [ 3 ] {} <Debug> HTTP-Session: 4cde059c-5cfa-4282-b9c3-6ce8d4e6fea0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
391 2024.05.14 09:44:56.497975 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
392 2024.05.14 09:44:56.498040 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
393 2024.05.14 09:44:56.498060 [ 3 ] {} <Debug> HTTP-Session: dbda2b3c-e094-437a-82c9-dc7621414da8 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
394 2024.05.14 09:44:56.498084 [ 3 ] {} <Debug> HTTP-Session: dbda2b3c-e094-437a-82c9-dc7621414da8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
395 2024.05.14 09:44:56.498097 [ 3 ] {} <Debug> HTTP-Session: dbda2b3c-e094-437a-82c9-dc7621414da8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
396 2024.05.14 09:44:56.498135 [ 3 ] {} <Trace> HTTP-Session: dbda2b3c-e094-437a-82c9-dc7621414da8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
397 2024.05.14 09:44:56.498316 [ 3 ] {b8b2918e-34de-4b73-b0bb-9a03ee73e48a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
398 2024.05.14 09:44:56.498371 [ 3 ] {b8b2918e-34de-4b73-b0bb-9a03ee73e48a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
399 2024.05.14 09:44:56.501145 [ 3 ] {b8b2918e-34de-4b73-b0bb-9a03ee73e48a} <Debug> oximeter.measurements_u64 (db2b6e00-a5db-480f-8363-f18b7c0783a2): Loading data parts
400 2024.05.14 09:44:56.501315 [ 3 ] {b8b2918e-34de-4b73-b0bb-9a03ee73e48a} <Debug> oximeter.measurements_u64 (db2b6e00-a5db-480f-8363-f18b7c0783a2): There are no data parts
401 2024.05.14 09:44:56.511442 [ 3 ] {b8b2918e-34de-4b73-b0bb-9a03ee73e48a} <Debug> DynamicQueryHandler: Done processing query
402 2024.05.14 09:44:56.511485 [ 3 ] {} <Debug> HTTP-Session: dbda2b3c-e094-437a-82c9-dc7621414da8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
403 2024.05.14 09:44:56.511622 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
404 2024.05.14 09:44:56.511681 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
405 2024.05.14 09:44:56.511714 [ 3 ] {} <Debug> HTTP-Session: 4c9a605a-02c4-4504-b7d0-92bbc4d89b7e Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
406 2024.05.14 09:44:56.511743 [ 3 ] {} <Debug> HTTP-Session: 4c9a605a-02c4-4504-b7d0-92bbc4d89b7e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
407 2024.05.14 09:44:56.511760 [ 3 ] {} <Debug> HTTP-Session: 4c9a605a-02c4-4504-b7d0-92bbc4d89b7e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
408 2024.05.14 09:44:56.511804 [ 3 ] {} <Trace> HTTP-Session: 4c9a605a-02c4-4504-b7d0-92bbc4d89b7e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
409 2024.05.14 09:44:56.511992 [ 3 ] {d524735a-f498-44b8-b5e8-a5b7fbec3aa8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
410 2024.05.14 09:44:56.512052 [ 3 ] {d524735a-f498-44b8-b5e8-a5b7fbec3aa8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
411 2024.05.14 09:44:56.514441 [ 3 ] {d524735a-f498-44b8-b5e8-a5b7fbec3aa8} <Debug> oximeter.measurements_f32 (757c7a82-a482-4218-b777-5d8027da2310): Loading data parts
412 2024.05.14 09:44:56.514605 [ 3 ] {d524735a-f498-44b8-b5e8-a5b7fbec3aa8} <Debug> oximeter.measurements_f32 (757c7a82-a482-4218-b777-5d8027da2310): There are no data parts
413 2024.05.14 09:44:56.517046 [ 3 ] {d524735a-f498-44b8-b5e8-a5b7fbec3aa8} <Debug> DynamicQueryHandler: Done processing query
414 2024.05.14 09:44:56.517076 [ 3 ] {} <Debug> HTTP-Session: 4c9a605a-02c4-4504-b7d0-92bbc4d89b7e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
415 2024.05.14 09:44:56.517199 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
416 2024.05.14 09:44:56.517277 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
417 2024.05.14 09:44:56.517300 [ 3 ] {} <Debug> HTTP-Session: ff5902e5-20f6-49f4-b06d-a618a0ccbf1c Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
418 2024.05.14 09:44:56.517325 [ 3 ] {} <Debug> HTTP-Session: ff5902e5-20f6-49f4-b06d-a618a0ccbf1c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
419 2024.05.14 09:44:56.517349 [ 3 ] {} <Debug> HTTP-Session: ff5902e5-20f6-49f4-b06d-a618a0ccbf1c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
420 2024.05.14 09:44:56.517386 [ 3 ] {} <Trace> HTTP-Session: ff5902e5-20f6-49f4-b06d-a618a0ccbf1c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
421 2024.05.14 09:44:56.517601 [ 3 ] {af17b26d-e418-4a58-a2ae-b319f144fdf3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
422 2024.05.14 09:44:56.517666 [ 3 ] {af17b26d-e418-4a58-a2ae-b319f144fdf3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
423 2024.05.14 09:44:56.529174 [ 3 ] {af17b26d-e418-4a58-a2ae-b319f144fdf3} <Debug> oximeter.measurements_f64 (e579300d-c27a-4fd5-97b5-af88f5c0452a): Loading data parts
424 2024.05.14 09:44:56.529339 [ 3 ] {af17b26d-e418-4a58-a2ae-b319f144fdf3} <Debug> oximeter.measurements_f64 (e579300d-c27a-4fd5-97b5-af88f5c0452a): There are no data parts
425 2024.05.14 09:44:56.532532 [ 3 ] {af17b26d-e418-4a58-a2ae-b319f144fdf3} <Debug> DynamicQueryHandler: Done processing query
426 2024.05.14 09:44:56.532570 [ 3 ] {} <Debug> HTTP-Session: ff5902e5-20f6-49f4-b06d-a618a0ccbf1c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
427 2024.05.14 09:44:56.532695 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
428 2024.05.14 09:44:56.532760 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
429 2024.05.14 09:44:56.532783 [ 3 ] {} <Debug> HTTP-Session: c5289ee2-65a1-48d1-a83b-2c7aabbedf46 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
430 2024.05.14 09:44:56.532808 [ 3 ] {} <Debug> HTTP-Session: c5289ee2-65a1-48d1-a83b-2c7aabbedf46 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
431 2024.05.14 09:44:56.532824 [ 3 ] {} <Debug> HTTP-Session: c5289ee2-65a1-48d1-a83b-2c7aabbedf46 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
432 2024.05.14 09:44:56.532864 [ 3 ] {} <Trace> HTTP-Session: c5289ee2-65a1-48d1-a83b-2c7aabbedf46 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
433 2024.05.14 09:44:56.533039 [ 3 ] {408c35c6-d01d-4e2e-930c-369ae35f4277} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
434 2024.05.14 09:44:56.533095 [ 3 ] {408c35c6-d01d-4e2e-930c-369ae35f4277} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
435 2024.05.14 09:44:56.542217 [ 3 ] {408c35c6-d01d-4e2e-930c-369ae35f4277} <Debug> oximeter.measurements_string (d75b5e82-7a58-404e-bc57-54a7be0faab2): Loading data parts
436 2024.05.14 09:44:56.542384 [ 3 ] {408c35c6-d01d-4e2e-930c-369ae35f4277} <Debug> oximeter.measurements_string (d75b5e82-7a58-404e-bc57-54a7be0faab2): There are no data parts
437 2024.05.14 09:44:56.544314 [ 3 ] {408c35c6-d01d-4e2e-930c-369ae35f4277} <Debug> DynamicQueryHandler: Done processing query
438 2024.05.14 09:44:56.544341 [ 3 ] {} <Debug> HTTP-Session: c5289ee2-65a1-48d1-a83b-2c7aabbedf46 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
439 2024.05.14 09:44:56.544463 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
440 2024.05.14 09:44:56.544518 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
441 2024.05.14 09:44:56.544537 [ 3 ] {} <Debug> HTTP-Session: 7d8b9374-1547-40b1-93a4-0930426ae24c Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
442 2024.05.14 09:44:56.544558 [ 3 ] {} <Debug> HTTP-Session: 7d8b9374-1547-40b1-93a4-0930426ae24c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
443 2024.05.14 09:44:56.544576 [ 3 ] {} <Debug> HTTP-Session: 7d8b9374-1547-40b1-93a4-0930426ae24c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
444 2024.05.14 09:44:56.544605 [ 3 ] {} <Trace> HTTP-Session: 7d8b9374-1547-40b1-93a4-0930426ae24c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
445 2024.05.14 09:44:56.544778 [ 3 ] {e9656c09-6934-48b3-a2ed-4cb8a8d7b589} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /*
446 * NOTE: Right now we can't unambiguously record a nullable byte array.
447 * Arrays cannot be nested in `Nullable()` types, and encoding the array as
448 * a string isn't palatable for a few reasons.
449 * See: https://github.com/oxidecomputer/omicron/issues/4551 for more
450 * details.
451 */
452 datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
453 2024.05.14 09:44:56.544831 [ 3 ] {e9656c09-6934-48b3-a2ed-4cb8a8d7b589} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
454 2024.05.14 09:44:56.547571 [ 3 ] {e9656c09-6934-48b3-a2ed-4cb8a8d7b589} <Debug> oximeter.measurements_bytes (33c8daa1-2f1c-4b3b-a51b-13855b873c97): Loading data parts
455 2024.05.14 09:44:56.547727 [ 3 ] {e9656c09-6934-48b3-a2ed-4cb8a8d7b589} <Debug> oximeter.measurements_bytes (33c8daa1-2f1c-4b3b-a51b-13855b873c97): There are no data parts
456 2024.05.14 09:44:56.549005 [ 3 ] {e9656c09-6934-48b3-a2ed-4cb8a8d7b589} <Debug> DynamicQueryHandler: Done processing query
457 2024.05.14 09:44:56.549031 [ 3 ] {} <Debug> HTTP-Session: 7d8b9374-1547-40b1-93a4-0930426ae24c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
458 2024.05.14 09:44:56.549148 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
459 2024.05.14 09:44:56.549203 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
460 2024.05.14 09:44:56.549222 [ 3 ] {} <Debug> HTTP-Session: 8168f1eb-e8c3-41c8-87b0-75bce9b63cea Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
461 2024.05.14 09:44:56.549243 [ 3 ] {} <Debug> HTTP-Session: 8168f1eb-e8c3-41c8-87b0-75bce9b63cea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
462 2024.05.14 09:44:56.549262 [ 3 ] {} <Debug> HTTP-Session: 8168f1eb-e8c3-41c8-87b0-75bce9b63cea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
463 2024.05.14 09:44:56.549293 [ 3 ] {} <Trace> HTTP-Session: 8168f1eb-e8c3-41c8-87b0-75bce9b63cea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
464 2024.05.14 09:44:56.549482 [ 3 ] {fd002aee-4f77-4492-859a-80f1e9e13e8c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
465 2024.05.14 09:44:56.549531 [ 3 ] {fd002aee-4f77-4492-859a-80f1e9e13e8c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
466 2024.05.14 09:44:56.559736 [ 3 ] {fd002aee-4f77-4492-859a-80f1e9e13e8c} <Debug> oximeter.measurements_cumulativei64 (caf3c960-7632-498b-ad56-4877bf515084): Loading data parts
467 2024.05.14 09:44:56.559934 [ 3 ] {fd002aee-4f77-4492-859a-80f1e9e13e8c} <Debug> oximeter.measurements_cumulativei64 (caf3c960-7632-498b-ad56-4877bf515084): There are no data parts
468 2024.05.14 09:44:56.561989 [ 3 ] {fd002aee-4f77-4492-859a-80f1e9e13e8c} <Debug> DynamicQueryHandler: Done processing query
469 2024.05.14 09:44:56.562022 [ 3 ] {} <Debug> HTTP-Session: 8168f1eb-e8c3-41c8-87b0-75bce9b63cea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
470 2024.05.14 09:44:56.562138 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
471 2024.05.14 09:44:56.562199 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
472 2024.05.14 09:44:56.562219 [ 3 ] {} <Debug> HTTP-Session: 3658f778-7d51-4bda-a212-c89e9ffa8ff6 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
473 2024.05.14 09:44:56.562240 [ 3 ] {} <Debug> HTTP-Session: 3658f778-7d51-4bda-a212-c89e9ffa8ff6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
474 2024.05.14 09:44:56.562254 [ 3 ] {} <Debug> HTTP-Session: 3658f778-7d51-4bda-a212-c89e9ffa8ff6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
475 2024.05.14 09:44:56.562289 [ 3 ] {} <Trace> HTTP-Session: 3658f778-7d51-4bda-a212-c89e9ffa8ff6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
476 2024.05.14 09:44:56.562474 [ 3 ] {ad499a0a-018b-4a7a-878c-7626a55b6413} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
477 2024.05.14 09:44:56.562529 [ 3 ] {ad499a0a-018b-4a7a-878c-7626a55b6413} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
478 2024.05.14 09:44:56.565311 [ 3 ] {ad499a0a-018b-4a7a-878c-7626a55b6413} <Debug> oximeter.measurements_cumulativeu64 (e98b65ec-bf72-4dce-9f7d-6f41be1dc4e8): Loading data parts
479 2024.05.14 09:44:56.565491 [ 3 ] {ad499a0a-018b-4a7a-878c-7626a55b6413} <Debug> oximeter.measurements_cumulativeu64 (e98b65ec-bf72-4dce-9f7d-6f41be1dc4e8): There are no data parts
480 2024.05.14 09:44:56.566780 [ 3 ] {ad499a0a-018b-4a7a-878c-7626a55b6413} <Debug> DynamicQueryHandler: Done processing query
481 2024.05.14 09:44:56.566807 [ 3 ] {} <Debug> HTTP-Session: 3658f778-7d51-4bda-a212-c89e9ffa8ff6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
482 2024.05.14 09:44:56.566923 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
483 2024.05.14 09:44:56.566977 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
484 2024.05.14 09:44:56.566997 [ 3 ] {} <Debug> HTTP-Session: bf5d9d65-933e-45df-bcaf-bca4cdc219a8 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
485 2024.05.14 09:44:56.567019 [ 3 ] {} <Debug> HTTP-Session: bf5d9d65-933e-45df-bcaf-bca4cdc219a8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
486 2024.05.14 09:44:56.567038 [ 3 ] {} <Debug> HTTP-Session: bf5d9d65-933e-45df-bcaf-bca4cdc219a8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
487 2024.05.14 09:44:56.567068 [ 3 ] {} <Trace> HTTP-Session: bf5d9d65-933e-45df-bcaf-bca4cdc219a8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
488 2024.05.14 09:44:56.567251 [ 3 ] {71f6fa55-69bd-438e-9128-1a5c27e98ee9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
489 2024.05.14 09:44:56.567312 [ 3 ] {71f6fa55-69bd-438e-9128-1a5c27e98ee9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
490 2024.05.14 09:44:56.575877 [ 3 ] {71f6fa55-69bd-438e-9128-1a5c27e98ee9} <Debug> oximeter.measurements_cumulativef32 (75a3ea69-b451-4214-a3c7-47f826258941): Loading data parts
491 2024.05.14 09:44:56.576049 [ 3 ] {71f6fa55-69bd-438e-9128-1a5c27e98ee9} <Debug> oximeter.measurements_cumulativef32 (75a3ea69-b451-4214-a3c7-47f826258941): There are no data parts
492 2024.05.14 09:44:56.577968 [ 3 ] {71f6fa55-69bd-438e-9128-1a5c27e98ee9} <Debug> DynamicQueryHandler: Done processing query
493 2024.05.14 09:44:56.578001 [ 3 ] {} <Debug> HTTP-Session: bf5d9d65-933e-45df-bcaf-bca4cdc219a8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
494 2024.05.14 09:44:56.578103 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
495 2024.05.14 09:44:56.578158 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
496 2024.05.14 09:44:56.578183 [ 3 ] {} <Debug> HTTP-Session: dec159ab-eafa-4e2f-8556-62d392a98139 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
497 2024.05.14 09:44:56.578204 [ 3 ] {} <Debug> HTTP-Session: dec159ab-eafa-4e2f-8556-62d392a98139 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
498 2024.05.14 09:44:56.578217 [ 3 ] {} <Debug> HTTP-Session: dec159ab-eafa-4e2f-8556-62d392a98139 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
499 2024.05.14 09:44:56.578251 [ 3 ] {} <Trace> HTTP-Session: dec159ab-eafa-4e2f-8556-62d392a98139 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
500 2024.05.14 09:44:56.578442 [ 3 ] {52700bd8-ff72-41d5-b724-22cddc664a7a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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)
501 2024.05.14 09:44:56.578497 [ 3 ] {52700bd8-ff72-41d5-b724-22cddc664a7a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
502 2024.05.14 09:44:56.581276 [ 3 ] {52700bd8-ff72-41d5-b724-22cddc664a7a} <Debug> oximeter.measurements_cumulativef64 (bd7993e7-c5cb-4956-90bd-7d57aa9fad41): Loading data parts
503 2024.05.14 09:44:56.581445 [ 3 ] {52700bd8-ff72-41d5-b724-22cddc664a7a} <Debug> oximeter.measurements_cumulativef64 (bd7993e7-c5cb-4956-90bd-7d57aa9fad41): There are no data parts
504 2024.05.14 09:44:56.582779 [ 3 ] {52700bd8-ff72-41d5-b724-22cddc664a7a} <Debug> DynamicQueryHandler: Done processing query
505 2024.05.14 09:44:56.582805 [ 3 ] {} <Debug> HTTP-Session: dec159ab-eafa-4e2f-8556-62d392a98139 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
506 2024.05.14 09:44:56.582912 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 836, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
507 2024.05.14 09:44:56.582969 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
508 2024.05.14 09:44:56.582987 [ 3 ] {} <Debug> HTTP-Session: 9b872060-29b3-48e4-8bf0-c2aa1b9b3d32 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
509 2024.05.14 09:44:56.583009 [ 3 ] {} <Debug> HTTP-Session: 9b872060-29b3-48e4-8bf0-c2aa1b9b3d32 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
510 2024.05.14 09:44:56.583027 [ 3 ] {} <Debug> HTTP-Session: 9b872060-29b3-48e4-8bf0-c2aa1b9b3d32 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
511 2024.05.14 09:44:56.583057 [ 3 ] {} <Trace> HTTP-Session: 9b872060-29b3-48e4-8bf0-c2aa1b9b3d32 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
512 2024.05.14 09:44:56.583253 [ 3 ] {f7b7a790-5e70-4005-a429-d2d04f7ba651} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /*
513 * NOTE: Array types cannot be Nullable, see
514 * https://clickhouse.com/docs/en/sql-reference/data-types/nullable
515 * for more details.
516 *
517 * This means we need to use empty arrays to indicate a missing value. This
518 * is unfortunate, and at this point relies on the fact that an
519 * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need
520 * to figure out another way to represent missing samples here.
521 */
522 bins Array(Int8), counts Array(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
523 2024.05.14 09:44:56.583312 [ 3 ] {f7b7a790-5e70-4005-a429-d2d04f7ba651} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
524 2024.05.14 09:44:56.593620 [ 3 ] {f7b7a790-5e70-4005-a429-d2d04f7ba651} <Debug> oximeter.measurements_histogrami8 (4ec31a06-6857-43d5-a773-bdc3954bacf0): Loading data parts
525 2024.05.14 09:44:56.593786 [ 3 ] {f7b7a790-5e70-4005-a429-d2d04f7ba651} <Debug> oximeter.measurements_histogrami8 (4ec31a06-6857-43d5-a773-bdc3954bacf0): There are no data parts
526 2024.05.14 09:44:56.595919 [ 3 ] {f7b7a790-5e70-4005-a429-d2d04f7ba651} <Debug> DynamicQueryHandler: Done processing query
527 2024.05.14 09:44:56.595950 [ 3 ] {} <Debug> HTTP-Session: 9b872060-29b3-48e4-8bf0-c2aa1b9b3d32 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
528 2024.05.14 09:44:56.596084 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 373, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
529 2024.05.14 09:44:56.596149 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
530 2024.05.14 09:44:56.596181 [ 3 ] {} <Debug> HTTP-Session: 95897678-9fe7-4040-8b1b-bff6cbbcf557 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
531 2024.05.14 09:44:56.596201 [ 3 ] {} <Debug> HTTP-Session: 95897678-9fe7-4040-8b1b-bff6cbbcf557 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
532 2024.05.14 09:44:56.596222 [ 3 ] {} <Debug> HTTP-Session: 95897678-9fe7-4040-8b1b-bff6cbbcf557 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
533 2024.05.14 09:44:56.596259 [ 3 ] {} <Trace> HTTP-Session: 95897678-9fe7-4040-8b1b-bff6cbbcf557 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
534 2024.05.14 09:44:56.596493 [ 3 ] {a408e6b4-9702-4258-b959-11ee229887c7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
535 2024.05.14 09:44:56.596561 [ 3 ] {a408e6b4-9702-4258-b959-11ee229887c7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
536 2024.05.14 09:44:56.599434 [ 3 ] {a408e6b4-9702-4258-b959-11ee229887c7} <Debug> oximeter.measurements_histogramu8 (36d782a3-1480-4dca-9a11-1cd93d85167c): Loading data parts
537 2024.05.14 09:44:56.599590 [ 3 ] {a408e6b4-9702-4258-b959-11ee229887c7} <Debug> oximeter.measurements_histogramu8 (36d782a3-1480-4dca-9a11-1cd93d85167c): There are no data parts
538 2024.05.14 09:44:56.610190 [ 3 ] {a408e6b4-9702-4258-b959-11ee229887c7} <Debug> DynamicQueryHandler: Done processing query
539 2024.05.14 09:44:56.610229 [ 3 ] {} <Debug> HTTP-Session: 95897678-9fe7-4040-8b1b-bff6cbbcf557 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
540 2024.05.14 09:44:56.610375 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 374, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
541 2024.05.14 09:44:56.610442 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
542 2024.05.14 09:44:56.610472 [ 3 ] {} <Debug> HTTP-Session: d250b119-d884-434a-b12d-d2fe5740c938 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
543 2024.05.14 09:44:56.610498 [ 3 ] {} <Debug> HTTP-Session: d250b119-d884-434a-b12d-d2fe5740c938 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
544 2024.05.14 09:44:56.610514 [ 3 ] {} <Debug> HTTP-Session: d250b119-d884-434a-b12d-d2fe5740c938 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
545 2024.05.14 09:44:56.610556 [ 3 ] {} <Trace> HTTP-Session: d250b119-d884-434a-b12d-d2fe5740c938 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
546 2024.05.14 09:44:56.610792 [ 3 ] {f456bac9-0e77-42c1-887d-7c822af0b932} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
547 2024.05.14 09:44:56.610861 [ 3 ] {f456bac9-0e77-42c1-887d-7c822af0b932} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
548 2024.05.14 09:44:56.613374 [ 3 ] {f456bac9-0e77-42c1-887d-7c822af0b932} <Debug> oximeter.measurements_histogrami16 (9dde1e60-c12d-424a-92d0-e03eaa92d96a): Loading data parts
549 2024.05.14 09:44:56.613535 [ 3 ] {f456bac9-0e77-42c1-887d-7c822af0b932} <Debug> oximeter.measurements_histogrami16 (9dde1e60-c12d-424a-92d0-e03eaa92d96a): There are no data parts
550 2024.05.14 09:44:56.615933 [ 3 ] {f456bac9-0e77-42c1-887d-7c822af0b932} <Debug> DynamicQueryHandler: Done processing query
551 2024.05.14 09:44:56.615963 [ 3 ] {} <Debug> HTTP-Session: d250b119-d884-434a-b12d-d2fe5740c938 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
552 2024.05.14 09:44:56.616085 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 375, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
553 2024.05.14 09:44:56.616152 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
554 2024.05.14 09:44:56.616175 [ 3 ] {} <Debug> HTTP-Session: ba4edba8-3d8a-44bf-8bdf-1f644de03487 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
555 2024.05.14 09:44:56.616201 [ 3 ] {} <Debug> HTTP-Session: ba4edba8-3d8a-44bf-8bdf-1f644de03487 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
556 2024.05.14 09:44:56.616223 [ 3 ] {} <Debug> HTTP-Session: ba4edba8-3d8a-44bf-8bdf-1f644de03487 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
557 2024.05.14 09:44:56.616259 [ 3 ] {} <Trace> HTTP-Session: ba4edba8-3d8a-44bf-8bdf-1f644de03487 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
558 2024.05.14 09:44:56.616491 [ 3 ] {339dc8dc-d373-41c2-8ce4-b7b4d278f669} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
559 2024.05.14 09:44:56.616560 [ 3 ] {339dc8dc-d373-41c2-8ce4-b7b4d278f669} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
560 2024.05.14 09:44:56.627934 [ 3 ] {339dc8dc-d373-41c2-8ce4-b7b4d278f669} <Debug> oximeter.measurements_histogramu16 (f223435a-df35-45eb-8ba1-e33ce9bbddb5): Loading data parts
561 2024.05.14 09:44:56.628098 [ 3 ] {339dc8dc-d373-41c2-8ce4-b7b4d278f669} <Debug> oximeter.measurements_histogramu16 (f223435a-df35-45eb-8ba1-e33ce9bbddb5): There are no data parts
562 2024.05.14 09:44:56.631670 [ 3 ] {339dc8dc-d373-41c2-8ce4-b7b4d278f669} <Debug> DynamicQueryHandler: Done processing query
563 2024.05.14 09:44:56.631710 [ 3 ] {} <Debug> HTTP-Session: ba4edba8-3d8a-44bf-8bdf-1f644de03487 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
564 2024.05.14 09:44:56.631841 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 374, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
565 2024.05.14 09:44:56.631896 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
566 2024.05.14 09:44:56.631922 [ 3 ] {} <Debug> HTTP-Session: dd997457-0419-430c-9298-997c4963a8fb Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
567 2024.05.14 09:44:56.631938 [ 3 ] {} <Debug> HTTP-Session: dd997457-0419-430c-9298-997c4963a8fb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
568 2024.05.14 09:44:56.631957 [ 3 ] {} <Debug> HTTP-Session: dd997457-0419-430c-9298-997c4963a8fb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
569 2024.05.14 09:44:56.631992 [ 3 ] {} <Trace> HTTP-Session: dd997457-0419-430c-9298-997c4963a8fb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
570 2024.05.14 09:44:56.632176 [ 3 ] {b2abaa8a-ff14-45a2-a2a7-50ea367a73d6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
571 2024.05.14 09:44:56.632233 [ 3 ] {b2abaa8a-ff14-45a2-a2a7-50ea367a73d6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
572 2024.05.14 09:44:56.641535 [ 3 ] {b2abaa8a-ff14-45a2-a2a7-50ea367a73d6} <Debug> oximeter.measurements_histogrami32 (de9e7d51-061d-4087-af74-e5260a6d8013): Loading data parts
573 2024.05.14 09:44:56.641727 [ 3 ] {b2abaa8a-ff14-45a2-a2a7-50ea367a73d6} <Debug> oximeter.measurements_histogrami32 (de9e7d51-061d-4087-af74-e5260a6d8013): There are no data parts
574 2024.05.14 09:44:56.643707 [ 3 ] {b2abaa8a-ff14-45a2-a2a7-50ea367a73d6} <Debug> DynamicQueryHandler: Done processing query
575 2024.05.14 09:44:56.643740 [ 3 ] {} <Debug> HTTP-Session: dd997457-0419-430c-9298-997c4963a8fb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
576 2024.05.14 09:44:56.643870 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 375, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
577 2024.05.14 09:44:56.643927 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
578 2024.05.14 09:44:56.643946 [ 3 ] {} <Debug> HTTP-Session: 01014a51-52d6-43db-96c3-deb46e57933e Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
579 2024.05.14 09:44:56.643974 [ 3 ] {} <Debug> HTTP-Session: 01014a51-52d6-43db-96c3-deb46e57933e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
580 2024.05.14 09:44:56.643987 [ 3 ] {} <Debug> HTTP-Session: 01014a51-52d6-43db-96c3-deb46e57933e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
581 2024.05.14 09:44:56.644023 [ 3 ] {} <Trace> HTTP-Session: 01014a51-52d6-43db-96c3-deb46e57933e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
582 2024.05.14 09:44:56.644218 [ 3 ] {61eed3dd-91bd-46c5-8583-825bd16b5b6d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
583 2024.05.14 09:44:56.644275 [ 3 ] {61eed3dd-91bd-46c5-8583-825bd16b5b6d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
584 2024.05.14 09:44:56.647121 [ 3 ] {61eed3dd-91bd-46c5-8583-825bd16b5b6d} <Debug> oximeter.measurements_histogramu32 (39e4c4bd-9dd2-427c-835e-c23831b71499): Loading data parts
585 2024.05.14 09:44:56.647282 [ 3 ] {61eed3dd-91bd-46c5-8583-825bd16b5b6d} <Debug> oximeter.measurements_histogramu32 (39e4c4bd-9dd2-427c-835e-c23831b71499): There are no data parts
586 2024.05.14 09:44:56.648624 [ 3 ] {61eed3dd-91bd-46c5-8583-825bd16b5b6d} <Debug> DynamicQueryHandler: Done processing query
587 2024.05.14 09:44:56.648650 [ 3 ] {} <Debug> HTTP-Session: 01014a51-52d6-43db-96c3-deb46e57933e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
588 2024.05.14 09:44:56.648764 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 374, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
589 2024.05.14 09:44:56.648827 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
590 2024.05.14 09:44:56.648856 [ 3 ] {} <Debug> HTTP-Session: a90bdb77-db89-4100-b5e1-27c7c16aa9f3 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
591 2024.05.14 09:44:56.648874 [ 3 ] {} <Debug> HTTP-Session: a90bdb77-db89-4100-b5e1-27c7c16aa9f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
592 2024.05.14 09:44:56.648898 [ 3 ] {} <Debug> HTTP-Session: a90bdb77-db89-4100-b5e1-27c7c16aa9f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
593 2024.05.14 09:44:56.648928 [ 3 ] {} <Trace> HTTP-Session: a90bdb77-db89-4100-b5e1-27c7c16aa9f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
594 2024.05.14 09:44:56.649134 [ 3 ] {5957274f-9f39-4fc7-bd0f-e26fd8a6c5f7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
595 2024.05.14 09:44:56.649203 [ 3 ] {5957274f-9f39-4fc7-bd0f-e26fd8a6c5f7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
596 2024.05.14 09:44:56.659404 [ 3 ] {5957274f-9f39-4fc7-bd0f-e26fd8a6c5f7} <Debug> oximeter.measurements_histogrami64 (da42cc69-2f5b-470d-9008-976fd99a424f): Loading data parts
597 2024.05.14 09:44:56.659574 [ 3 ] {5957274f-9f39-4fc7-bd0f-e26fd8a6c5f7} <Debug> oximeter.measurements_histogrami64 (da42cc69-2f5b-470d-9008-976fd99a424f): There are no data parts
598 2024.05.14 09:44:56.661578 [ 3 ] {5957274f-9f39-4fc7-bd0f-e26fd8a6c5f7} <Debug> DynamicQueryHandler: Done processing query
599 2024.05.14 09:44:56.661604 [ 3 ] {} <Debug> HTTP-Session: a90bdb77-db89-4100-b5e1-27c7c16aa9f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
600 2024.05.14 09:44:56.661705 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 375, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
601 2024.05.14 09:44:56.661779 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
602 2024.05.14 09:44:56.661798 [ 3 ] {} <Debug> HTTP-Session: 4a250b01-1ee3-414b-9927-5fbf9a1ea1a5 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
603 2024.05.14 09:44:56.661825 [ 3 ] {} <Debug> HTTP-Session: 4a250b01-1ee3-414b-9927-5fbf9a1ea1a5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
604 2024.05.14 09:44:56.661840 [ 3 ] {} <Debug> HTTP-Session: 4a250b01-1ee3-414b-9927-5fbf9a1ea1a5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
605 2024.05.14 09:44:56.661878 [ 3 ] {} <Trace> HTTP-Session: 4a250b01-1ee3-414b-9927-5fbf9a1ea1a5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
606 2024.05.14 09:44:56.662072 [ 3 ] {9e39de2b-36e1-45c0-bfdf-9dd51582e5b5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
607 2024.05.14 09:44:56.662139 [ 3 ] {9e39de2b-36e1-45c0-bfdf-9dd51582e5b5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
608 2024.05.14 09:44:56.664961 [ 3 ] {9e39de2b-36e1-45c0-bfdf-9dd51582e5b5} <Debug> oximeter.measurements_histogramu64 (2d6a4bed-1764-484d-863b-35aaf8045e7f): Loading data parts
609 2024.05.14 09:44:56.665212 [ 3 ] {9e39de2b-36e1-45c0-bfdf-9dd51582e5b5} <Debug> oximeter.measurements_histogramu64 (2d6a4bed-1764-484d-863b-35aaf8045e7f): There are no data parts
610 2024.05.14 09:44:56.667047 [ 3 ] {9e39de2b-36e1-45c0-bfdf-9dd51582e5b5} <Debug> DynamicQueryHandler: Done processing query
611 2024.05.14 09:44:56.667072 [ 3 ] {} <Debug> HTTP-Session: 4a250b01-1ee3-414b-9927-5fbf9a1ea1a5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
612 2024.05.14 09:44:56.667185 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 376, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
613 2024.05.14 09:44:56.667244 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
614 2024.05.14 09:44:56.667270 [ 3 ] {} <Debug> HTTP-Session: 0015ba1e-47a3-4b4b-a70f-6efd559cadaf Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
615 2024.05.14 09:44:56.667287 [ 3 ] {} <Debug> HTTP-Session: 0015ba1e-47a3-4b4b-a70f-6efd559cadaf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
616 2024.05.14 09:44:56.667307 [ 3 ] {} <Debug> HTTP-Session: 0015ba1e-47a3-4b4b-a70f-6efd559cadaf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
617 2024.05.14 09:44:56.667345 [ 3 ] {} <Trace> HTTP-Session: 0015ba1e-47a3-4b4b-a70f-6efd559cadaf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
618 2024.05.14 09:44:56.667533 [ 3 ] {f5f5132d-7cd2-4031-abb4-9afd5d1fc954} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
619 2024.05.14 09:44:56.667591 [ 3 ] {f5f5132d-7cd2-4031-abb4-9afd5d1fc954} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
620 2024.05.14 09:44:56.675110 [ 3 ] {f5f5132d-7cd2-4031-abb4-9afd5d1fc954} <Debug> oximeter.measurements_histogramf32 (67cae6bb-c8db-4291-b2fb-950baf475755): Loading data parts
621 2024.05.14 09:44:56.675327 [ 3 ] {f5f5132d-7cd2-4031-abb4-9afd5d1fc954} <Debug> oximeter.measurements_histogramf32 (67cae6bb-c8db-4291-b2fb-950baf475755): There are no data parts
622 2024.05.14 09:44:56.677435 [ 3 ] {f5f5132d-7cd2-4031-abb4-9afd5d1fc954} <Debug> DynamicQueryHandler: Done processing query
623 2024.05.14 09:44:56.677470 [ 3 ] {} <Debug> HTTP-Session: 0015ba1e-47a3-4b4b-a70f-6efd559cadaf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
624 2024.05.14 09:44:56.677589 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 376, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
625 2024.05.14 09:44:56.677637 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
626 2024.05.14 09:44:56.677664 [ 3 ] {} <Debug> HTTP-Session: afada9bd-5472-429a-9c9e-1f1ce58a9345 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
627 2024.05.14 09:44:56.677688 [ 3 ] {} <Debug> HTTP-Session: afada9bd-5472-429a-9c9e-1f1ce58a9345 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
628 2024.05.14 09:44:56.677701 [ 3 ] {} <Debug> HTTP-Session: afada9bd-5472-429a-9c9e-1f1ce58a9345 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
629 2024.05.14 09:44:56.677737 [ 3 ] {} <Trace> HTTP-Session: afada9bd-5472-429a-9c9e-1f1ce58a9345 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
630 2024.05.14 09:44:56.677929 [ 3 ] {f5b783e3-b67d-490a-b17a-d336be3ec291} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
631 2024.05.14 09:44:56.677986 [ 3 ] {f5b783e3-b67d-490a-b17a-d336be3ec291} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
632 2024.05.14 09:44:56.680843 [ 3 ] {f5b783e3-b67d-490a-b17a-d336be3ec291} <Debug> oximeter.measurements_histogramf64 (bdb247a3-52ed-4b31-a121-541f9815c2d4): Loading data parts
633 2024.05.14 09:44:56.681014 [ 3 ] {f5b783e3-b67d-490a-b17a-d336be3ec291} <Debug> oximeter.measurements_histogramf64 (bdb247a3-52ed-4b31-a121-541f9815c2d4): There are no data parts
634 2024.05.14 09:44:56.682648 [ 3 ] {f5b783e3-b67d-490a-b17a-d336be3ec291} <Debug> DynamicQueryHandler: Done processing query
635 2024.05.14 09:44:56.682674 [ 3 ] {} <Debug> HTTP-Session: afada9bd-5472-429a-9c9e-1f1ce58a9345 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
636 2024.05.14 09:44:56.682787 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 1196, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
637 2024.05.14 09:44:56.682844 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
638 2024.05.14 09:44:56.682862 [ 3 ] {} <Debug> HTTP-Session: af674110-248e-455a-8fb8-8fd3bbf36fbc Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
639 2024.05.14 09:44:56.682884 [ 3 ] {} <Debug> HTTP-Session: af674110-248e-455a-8fb8-8fd3bbf36fbc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
640 2024.05.14 09:44:56.682905 [ 3 ] {} <Debug> HTTP-Session: af674110-248e-455a-8fb8-8fd3bbf36fbc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
641 2024.05.14 09:44:56.682934 [ 3 ] {} <Trace> HTTP-Session: af674110-248e-455a-8fb8-8fd3bbf36fbc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
642 2024.05.14 09:44:56.683084 [ 3 ] {68874fdc-3f8e-4b0b-a9ac-48ddd35dffdd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) /* The field tables store named dimensions of each timeseries.
643 *
644 * As with the measurement tables, there is one field table for each field data
645 * type. Fields are deduplicated by using the "replacing merge tree", though
646 * this behavior **must not** be relied upon for query correctness.
647 *
648 * The index for the fields differs from the measurements, however. Rows are
649 * sorted by timeseries name, then field name, field value, and finally
650 * timeseries key. This reflects the most common pattern for looking them up:
651 * by field name and possibly value, within a timeseries. The resulting keys are
652 * usually then used to look up measurements.
653 *
654 * NOTE: We may want to consider a secondary index on these tables, sorting by
655 * timeseries name and then key, since it would improve lookups where one
656 * already has the key. Realistically though, these tables are quite small and
657 * so performance benefits will be low in absolute terms.
658 */
659 CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
660 2024.05.14 09:44:56.683139 [ 3 ] {68874fdc-3f8e-4b0b-a9ac-48ddd35dffdd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
661 2024.05.14 09:44:56.693257 [ 3 ] {68874fdc-3f8e-4b0b-a9ac-48ddd35dffdd} <Debug> oximeter.fields_bool (6ae0e99e-80c4-44cc-aab3-96df35a41572): Loading data parts
662 2024.05.14 09:44:56.693546 [ 3 ] {68874fdc-3f8e-4b0b-a9ac-48ddd35dffdd} <Debug> oximeter.fields_bool (6ae0e99e-80c4-44cc-aab3-96df35a41572): There are no data parts
663 2024.05.14 09:44:56.696037 [ 3 ] {68874fdc-3f8e-4b0b-a9ac-48ddd35dffdd} <Debug> DynamicQueryHandler: Done processing query
664 2024.05.14 09:44:56.696077 [ 3 ] {} <Debug> HTTP-Session: af674110-248e-455a-8fb8-8fd3bbf36fbc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
665 2024.05.14 09:44:56.696215 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 248, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
666 2024.05.14 09:44:56.696272 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
667 2024.05.14 09:44:56.696305 [ 3 ] {} <Debug> HTTP-Session: 2da0e2ef-f2fb-49e1-8876-8b58a243d37d Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
668 2024.05.14 09:44:56.696333 [ 3 ] {} <Debug> HTTP-Session: 2da0e2ef-f2fb-49e1-8876-8b58a243d37d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
669 2024.05.14 09:44:56.696349 [ 3 ] {} <Debug> HTTP-Session: 2da0e2ef-f2fb-49e1-8876-8b58a243d37d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
670 2024.05.14 09:44:56.696394 [ 3 ] {} <Trace> HTTP-Session: 2da0e2ef-f2fb-49e1-8876-8b58a243d37d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
671 2024.05.14 09:44:56.696573 [ 3 ] {f33dacdc-7acf-4a3c-b1d9-e35542fcef00} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
672 2024.05.14 09:44:56.696628 [ 3 ] {f33dacdc-7acf-4a3c-b1d9-e35542fcef00} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
673 2024.05.14 09:44:56.699951 [ 3 ] {f33dacdc-7acf-4a3c-b1d9-e35542fcef00} <Debug> oximeter.fields_i8 (36039df2-557d-4a2e-a84c-f932d393c26b): Loading data parts
674 2024.05.14 09:44:56.700226 [ 3 ] {f33dacdc-7acf-4a3c-b1d9-e35542fcef00} <Debug> oximeter.fields_i8 (36039df2-557d-4a2e-a84c-f932d393c26b): There are no data parts
675 2024.05.14 09:44:56.702044 [ 3 ] {f33dacdc-7acf-4a3c-b1d9-e35542fcef00} <Debug> DynamicQueryHandler: Done processing query
676 2024.05.14 09:44:56.702085 [ 3 ] {} <Debug> HTTP-Session: 2da0e2ef-f2fb-49e1-8876-8b58a243d37d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
677 2024.05.14 09:44:56.702182 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 249, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
678 2024.05.14 09:44:56.702237 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
679 2024.05.14 09:44:56.702264 [ 3 ] {} <Debug> HTTP-Session: 2f09c6b3-97e6-4e56-b266-768305967a08 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
680 2024.05.14 09:44:56.702280 [ 3 ] {} <Debug> HTTP-Session: 2f09c6b3-97e6-4e56-b266-768305967a08 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
681 2024.05.14 09:44:56.702299 [ 3 ] {} <Debug> HTTP-Session: 2f09c6b3-97e6-4e56-b266-768305967a08 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
682 2024.05.14 09:44:56.702336 [ 3 ] {} <Trace> HTTP-Session: 2f09c6b3-97e6-4e56-b266-768305967a08 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
683 2024.05.14 09:44:56.702476 [ 3 ] {595f8a56-31ae-4784-a7ee-3ce86ba4cdc8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
684 2024.05.14 09:44:56.702530 [ 3 ] {595f8a56-31ae-4784-a7ee-3ce86ba4cdc8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
685 2024.05.14 09:44:56.710180 [ 3 ] {595f8a56-31ae-4784-a7ee-3ce86ba4cdc8} <Debug> oximeter.fields_u8 (95c1ad1c-b0fb-4189-a0b3-f8f6a88b2adc): Loading data parts
686 2024.05.14 09:44:56.710349 [ 3 ] {595f8a56-31ae-4784-a7ee-3ce86ba4cdc8} <Debug> oximeter.fields_u8 (95c1ad1c-b0fb-4189-a0b3-f8f6a88b2adc): There are no data parts
687 2024.05.14 09:44:56.712511 [ 3 ] {595f8a56-31ae-4784-a7ee-3ce86ba4cdc8} <Debug> DynamicQueryHandler: Done processing query
688 2024.05.14 09:44:56.712536 [ 3 ] {} <Debug> HTTP-Session: 2f09c6b3-97e6-4e56-b266-768305967a08 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
689 2024.05.14 09:44:56.712649 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
690 2024.05.14 09:44:56.712706 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
691 2024.05.14 09:44:56.712726 [ 3 ] {} <Debug> HTTP-Session: 257da319-c8c1-42ba-857b-bf765da93724 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
692 2024.05.14 09:44:56.712748 [ 3 ] {} <Debug> HTTP-Session: 257da319-c8c1-42ba-857b-bf765da93724 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
693 2024.05.14 09:44:56.712768 [ 3 ] {} <Debug> HTTP-Session: 257da319-c8c1-42ba-857b-bf765da93724 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
694 2024.05.14 09:44:56.712798 [ 3 ] {} <Trace> HTTP-Session: 257da319-c8c1-42ba-857b-bf765da93724 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
695 2024.05.14 09:44:56.712949 [ 3 ] {260183fb-5682-4633-921a-4a1129c73e09} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
696 2024.05.14 09:44:56.713001 [ 3 ] {260183fb-5682-4633-921a-4a1129c73e09} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
697 2024.05.14 09:44:56.715761 [ 3 ] {260183fb-5682-4633-921a-4a1129c73e09} <Debug> oximeter.fields_i16 (3b174484-6281-4978-876f-cae6618a2594): Loading data parts
698 2024.05.14 09:44:56.715973 [ 3 ] {260183fb-5682-4633-921a-4a1129c73e09} <Debug> oximeter.fields_i16 (3b174484-6281-4978-876f-cae6618a2594): There are no data parts
699 2024.05.14 09:44:56.717757 [ 3 ] {260183fb-5682-4633-921a-4a1129c73e09} <Debug> DynamicQueryHandler: Done processing query
700 2024.05.14 09:44:56.717782 [ 3 ] {} <Debug> HTTP-Session: 257da319-c8c1-42ba-857b-bf765da93724 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
701 2024.05.14 09:44:56.717907 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
702 2024.05.14 09:44:56.717972 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
703 2024.05.14 09:44:56.717996 [ 3 ] {} <Debug> HTTP-Session: 9c6b2518-f88b-4891-ab1a-493e95aa1d7b Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
704 2024.05.14 09:44:56.718024 [ 3 ] {} <Debug> HTTP-Session: 9c6b2518-f88b-4891-ab1a-493e95aa1d7b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
705 2024.05.14 09:44:56.718047 [ 3 ] {} <Debug> HTTP-Session: 9c6b2518-f88b-4891-ab1a-493e95aa1d7b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
706 2024.05.14 09:44:56.718087 [ 3 ] {} <Trace> HTTP-Session: 9c6b2518-f88b-4891-ab1a-493e95aa1d7b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
707 2024.05.14 09:44:56.718265 [ 3 ] {67a323a3-f46c-48cd-aba5-8879b9ea6283} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
708 2024.05.14 09:44:56.718328 [ 3 ] {67a323a3-f46c-48cd-aba5-8879b9ea6283} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
709 2024.05.14 09:44:56.728144 [ 3 ] {67a323a3-f46c-48cd-aba5-8879b9ea6283} <Debug> oximeter.fields_u16 (996d6d89-19d7-4764-9fe3-e0391e7030bf): Loading data parts
710 2024.05.14 09:44:56.728432 [ 3 ] {67a323a3-f46c-48cd-aba5-8879b9ea6283} <Debug> oximeter.fields_u16 (996d6d89-19d7-4764-9fe3-e0391e7030bf): There are no data parts
711 2024.05.14 09:44:56.730790 [ 3 ] {67a323a3-f46c-48cd-aba5-8879b9ea6283} <Debug> DynamicQueryHandler: Done processing query
712 2024.05.14 09:44:56.730817 [ 3 ] {} <Debug> HTTP-Session: 9c6b2518-f88b-4891-ab1a-493e95aa1d7b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
713 2024.05.14 09:44:56.730936 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
714 2024.05.14 09:44:56.731003 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
715 2024.05.14 09:44:56.731026 [ 3 ] {} <Debug> HTTP-Session: d2b9d4d7-3c2e-4caa-837a-e78e392fd2e6 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
716 2024.05.14 09:44:56.731053 [ 3 ] {} <Debug> HTTP-Session: d2b9d4d7-3c2e-4caa-837a-e78e392fd2e6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
717 2024.05.14 09:44:56.731078 [ 3 ] {} <Debug> HTTP-Session: d2b9d4d7-3c2e-4caa-837a-e78e392fd2e6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
718 2024.05.14 09:44:56.731114 [ 3 ] {} <Trace> HTTP-Session: d2b9d4d7-3c2e-4caa-837a-e78e392fd2e6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
719 2024.05.14 09:44:56.731293 [ 3 ] {5e5b4d75-fb4e-41ec-8f04-0f44e13b6163} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
720 2024.05.14 09:44:56.731351 [ 3 ] {5e5b4d75-fb4e-41ec-8f04-0f44e13b6163} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
721 2024.05.14 09:44:56.734108 [ 3 ] {5e5b4d75-fb4e-41ec-8f04-0f44e13b6163} <Debug> oximeter.fields_i32 (8ceb8b76-6662-4569-8f4b-0a5bf0e08e41): Loading data parts
722 2024.05.14 09:44:56.734240 [ 3 ] {5e5b4d75-fb4e-41ec-8f04-0f44e13b6163} <Debug> oximeter.fields_i32 (8ceb8b76-6662-4569-8f4b-0a5bf0e08e41): There are no data parts
723 2024.05.14 09:44:56.735851 [ 3 ] {5e5b4d75-fb4e-41ec-8f04-0f44e13b6163} <Debug> DynamicQueryHandler: Done processing query
724 2024.05.14 09:44:56.735883 [ 3 ] {} <Debug> HTTP-Session: d2b9d4d7-3c2e-4caa-837a-e78e392fd2e6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
725 2024.05.14 09:44:56.735998 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
726 2024.05.14 09:44:56.736043 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
727 2024.05.14 09:44:56.736071 [ 3 ] {} <Debug> HTTP-Session: bbad110a-40da-4aab-82ca-63965097fece Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
728 2024.05.14 09:44:56.736094 [ 3 ] {} <Debug> HTTP-Session: bbad110a-40da-4aab-82ca-63965097fece Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
729 2024.05.14 09:44:56.736107 [ 3 ] {} <Debug> HTTP-Session: bbad110a-40da-4aab-82ca-63965097fece Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
730 2024.05.14 09:44:56.736143 [ 3 ] {} <Trace> HTTP-Session: bbad110a-40da-4aab-82ca-63965097fece Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
731 2024.05.14 09:44:56.736287 [ 3 ] {42dd615c-5226-49ca-aa27-3e7dbd0c2b8c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
732 2024.05.14 09:44:56.736333 [ 3 ] {42dd615c-5226-49ca-aa27-3e7dbd0c2b8c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
733 2024.05.14 09:44:56.744280 [ 3 ] {42dd615c-5226-49ca-aa27-3e7dbd0c2b8c} <Debug> oximeter.fields_u32 (283c1063-6593-4018-9e0e-f85efc2d4b15): Loading data parts
734 2024.05.14 09:44:56.744436 [ 3 ] {42dd615c-5226-49ca-aa27-3e7dbd0c2b8c} <Debug> oximeter.fields_u32 (283c1063-6593-4018-9e0e-f85efc2d4b15): There are no data parts
735 2024.05.14 09:44:56.746641 [ 3 ] {42dd615c-5226-49ca-aa27-3e7dbd0c2b8c} <Debug> DynamicQueryHandler: Done processing query
736 2024.05.14 09:44:56.746675 [ 3 ] {} <Debug> HTTP-Session: bbad110a-40da-4aab-82ca-63965097fece Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
737 2024.05.14 09:44:56.746785 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
738 2024.05.14 09:44:56.746840 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
739 2024.05.14 09:44:56.746867 [ 3 ] {} <Debug> HTTP-Session: b942aef0-24e8-4a5f-924d-0ce0e6fff0b1 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
740 2024.05.14 09:44:56.746882 [ 3 ] {} <Debug> HTTP-Session: b942aef0-24e8-4a5f-924d-0ce0e6fff0b1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
741 2024.05.14 09:44:56.746902 [ 3 ] {} <Debug> HTTP-Session: b942aef0-24e8-4a5f-924d-0ce0e6fff0b1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
742 2024.05.14 09:44:56.746940 [ 3 ] {} <Trace> HTTP-Session: b942aef0-24e8-4a5f-924d-0ce0e6fff0b1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
743 2024.05.14 09:44:56.747087 [ 3 ] {07920d51-05b6-4ca2-a500-d1d2439f169d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
744 2024.05.14 09:44:56.747133 [ 3 ] {07920d51-05b6-4ca2-a500-d1d2439f169d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
745 2024.05.14 09:44:56.758742 [ 3 ] {07920d51-05b6-4ca2-a500-d1d2439f169d} <Debug> oximeter.fields_i64 (eeb4980f-e021-40ee-a3c2-66075a8f3137): Loading data parts
746 2024.05.14 09:44:56.758883 [ 3 ] {07920d51-05b6-4ca2-a500-d1d2439f169d} <Debug> oximeter.fields_i64 (eeb4980f-e021-40ee-a3c2-66075a8f3137): There are no data parts
747 2024.05.14 09:44:56.762346 [ 3 ] {07920d51-05b6-4ca2-a500-d1d2439f169d} <Debug> DynamicQueryHandler: Done processing query
748 2024.05.14 09:44:56.762381 [ 3 ] {} <Debug> HTTP-Session: b942aef0-24e8-4a5f-924d-0ce0e6fff0b1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
749 2024.05.14 09:44:56.762523 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
750 2024.05.14 09:44:56.762593 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
751 2024.05.14 09:44:56.762625 [ 3 ] {} <Debug> HTTP-Session: 9198825c-951b-419a-9d2e-ae198cb40a50 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
752 2024.05.14 09:44:56.762645 [ 3 ] {} <Debug> HTTP-Session: 9198825c-951b-419a-9d2e-ae198cb40a50 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
753 2024.05.14 09:44:56.762672 [ 3 ] {} <Debug> HTTP-Session: 9198825c-951b-419a-9d2e-ae198cb40a50 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
754 2024.05.14 09:44:56.762721 [ 3 ] {} <Trace> HTTP-Session: 9198825c-951b-419a-9d2e-ae198cb40a50 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
755 2024.05.14 09:44:56.762920 [ 3 ] {4d8856a7-07fb-4a0f-93a4-dd36cfe3f90d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
756 2024.05.14 09:44:56.762979 [ 3 ] {4d8856a7-07fb-4a0f-93a4-dd36cfe3f90d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
757 2024.05.14 09:44:56.764553 [ 3 ] {4d8856a7-07fb-4a0f-93a4-dd36cfe3f90d} <Debug> oximeter.fields_u64 (72245dae-c77e-464d-a4da-7fbb105ab374): Loading data parts
758 2024.05.14 09:44:56.764671 [ 3 ] {4d8856a7-07fb-4a0f-93a4-dd36cfe3f90d} <Debug> oximeter.fields_u64 (72245dae-c77e-464d-a4da-7fbb105ab374): There are no data parts
759 2024.05.14 09:44:56.773020 [ 3 ] {4d8856a7-07fb-4a0f-93a4-dd36cfe3f90d} <Debug> DynamicQueryHandler: Done processing query
760 2024.05.14 09:44:56.773051 [ 3 ] {} <Debug> HTTP-Session: 9198825c-951b-419a-9d2e-ae198cb40a50 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
761 2024.05.14 09:44:56.773184 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 252, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
762 2024.05.14 09:44:56.773259 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
763 2024.05.14 09:44:56.773283 [ 3 ] {} <Debug> HTTP-Session: 3c76cd92-d663-4828-9cba-aa2094e0a1b2 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
764 2024.05.14 09:44:56.773304 [ 3 ] {} <Debug> HTTP-Session: 3c76cd92-d663-4828-9cba-aa2094e0a1b2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
765 2024.05.14 09:44:56.773329 [ 3 ] {} <Debug> HTTP-Session: 3c76cd92-d663-4828-9cba-aa2094e0a1b2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
766 2024.05.14 09:44:56.773367 [ 3 ] {} <Trace> HTTP-Session: 3c76cd92-d663-4828-9cba-aa2094e0a1b2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
767 2024.05.14 09:44:56.773540 [ 3 ] {b974dbe9-8b11-4ad0-b315-121381cc33b1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
768 2024.05.14 09:44:56.773597 [ 3 ] {b974dbe9-8b11-4ad0-b315-121381cc33b1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
769 2024.05.14 09:44:56.775746 [ 3 ] {b974dbe9-8b11-4ad0-b315-121381cc33b1} <Debug> oximeter.fields_ipaddr (04a52d7a-901b-423f-9eba-56aad2b0a96b): Loading data parts
770 2024.05.14 09:44:56.775896 [ 3 ] {b974dbe9-8b11-4ad0-b315-121381cc33b1} <Debug> oximeter.fields_ipaddr (04a52d7a-901b-423f-9eba-56aad2b0a96b): There are no data parts
771 2024.05.14 09:44:56.778311 [ 3 ] {b974dbe9-8b11-4ad0-b315-121381cc33b1} <Debug> DynamicQueryHandler: Done processing query
772 2024.05.14 09:44:56.778342 [ 3 ] {} <Debug> HTTP-Session: 3c76cd92-d663-4828-9cba-aa2094e0a1b2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
773 2024.05.14 09:44:56.778467 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 254, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
774 2024.05.14 09:44:56.778524 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
775 2024.05.14 09:44:56.778549 [ 3 ] {} <Debug> HTTP-Session: 43b2ea52-3e87-41e6-8e56-b88c89e079a2 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
776 2024.05.14 09:44:56.778568 [ 3 ] {} <Debug> HTTP-Session: 43b2ea52-3e87-41e6-8e56-b88c89e079a2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
777 2024.05.14 09:44:56.778585 [ 3 ] {} <Debug> HTTP-Session: 43b2ea52-3e87-41e6-8e56-b88c89e079a2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
778 2024.05.14 09:44:56.778621 [ 3 ] {} <Trace> HTTP-Session: 43b2ea52-3e87-41e6-8e56-b88c89e079a2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
779 2024.05.14 09:44:56.778792 [ 3 ] {d065e2ba-7aad-4287-86a5-016aa3786326} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
780 2024.05.14 09:44:56.778840 [ 3 ] {d065e2ba-7aad-4287-86a5-016aa3786326} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
781 2024.05.14 09:44:56.780379 [ 3 ] {d065e2ba-7aad-4287-86a5-016aa3786326} <Debug> oximeter.fields_string (e5270689-1e17-4a86-9212-8dbb5bc10b5b): Loading data parts
782 2024.05.14 09:44:56.780507 [ 3 ] {d065e2ba-7aad-4287-86a5-016aa3786326} <Debug> oximeter.fields_string (e5270689-1e17-4a86-9212-8dbb5bc10b5b): There are no data parts
783 2024.05.14 09:44:56.790645 [ 3 ] {d065e2ba-7aad-4287-86a5-016aa3786326} <Debug> DynamicQueryHandler: Done processing query
784 2024.05.14 09:44:56.790677 [ 3 ] {} <Debug> HTTP-Session: 43b2ea52-3e87-41e6-8e56-b88c89e079a2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
785 2024.05.14 09:44:56.790827 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
786 2024.05.14 09:44:56.790881 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
787 2024.05.14 09:44:56.790901 [ 3 ] {} <Debug> HTTP-Session: 041a6be7-0aa8-4479-8202-481e1c01717f Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
788 2024.05.14 09:44:56.790918 [ 3 ] {} <Debug> HTTP-Session: 041a6be7-0aa8-4479-8202-481e1c01717f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
789 2024.05.14 09:44:56.790931 [ 3 ] {} <Debug> HTTP-Session: 041a6be7-0aa8-4479-8202-481e1c01717f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
790 2024.05.14 09:44:56.790961 [ 3 ] {} <Trace> HTTP-Session: 041a6be7-0aa8-4479-8202-481e1c01717f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
791 2024.05.14 09:44:56.791103 [ 3 ] {9fdb8a6e-e168-43bd-99df-857128dd6708} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete)
792 2024.05.14 09:44:56.791141 [ 3 ] {9fdb8a6e-e168-43bd-99df-857128dd6708} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
793 2024.05.14 09:44:56.793442 [ 3 ] {9fdb8a6e-e168-43bd-99df-857128dd6708} <Debug> oximeter.fields_uuid (d5425b9a-6a5c-4c17-b97d-3893bdb85653): Loading data parts
794 2024.05.14 09:44:56.793574 [ 3 ] {9fdb8a6e-e168-43bd-99df-857128dd6708} <Debug> oximeter.fields_uuid (d5425b9a-6a5c-4c17-b97d-3893bdb85653): There are no data parts
795 2024.05.14 09:44:56.795910 [ 3 ] {9fdb8a6e-e168-43bd-99df-857128dd6708} <Debug> DynamicQueryHandler: Done processing query
796 2024.05.14 09:44:56.795936 [ 3 ] {} <Debug> HTTP-Session: 041a6be7-0aa8-4479-8202-481e1c01717f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
797 2024.05.14 09:44:56.796051 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
798 2024.05.14 09:44:56.796098 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
799 2024.05.14 09:44:56.796118 [ 3 ] {} <Debug> HTTP-Session: 2cf7c16c-a32d-449f-a7e6-5d24952c9639 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
800 2024.05.14 09:44:56.796134 [ 3 ] {} <Debug> HTTP-Session: 2cf7c16c-a32d-449f-a7e6-5d24952c9639 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
801 2024.05.14 09:44:56.796148 [ 3 ] {} <Debug> HTTP-Session: 2cf7c16c-a32d-449f-a7e6-5d24952c9639 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
802 2024.05.14 09:44:56.796177 [ 3 ] {} <Trace> HTTP-Session: 2cf7c16c-a32d-449f-a7e6-5d24952c9639 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
803 2024.05.14 09:44:56.796385 [ 3 ] {8d3ba728-a7c6-4e14-b22e-bb76b48b9e91} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) /* The timeseries schema table stores the extracted schema for the samples
804 * oximeter collects.
805 */
806 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)
807 2024.05.14 09:44:56.796444 [ 3 ] {8d3ba728-a7c6-4e14-b22e-bb76b48b9e91} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
808 2024.05.14 09:44:56.798052 [ 3 ] {8d3ba728-a7c6-4e14-b22e-bb76b48b9e91} <Debug> oximeter.timeseries_schema (27d0c9fe-a196-437b-8c5e-39da511be4c4): Loading data parts
809 2024.05.14 09:44:56.798184 [ 3 ] {8d3ba728-a7c6-4e14-b22e-bb76b48b9e91} <Debug> oximeter.timeseries_schema (27d0c9fe-a196-437b-8c5e-39da511be4c4): There are no data parts
810 2024.05.14 09:44:56.806306 [ 3 ] {8d3ba728-a7c6-4e14-b22e-bb76b48b9e91} <Debug> DynamicQueryHandler: Done processing query
811 2024.05.14 09:44:56.806337 [ 3 ] {} <Debug> HTTP-Session: 2cf7c16c-a32d-449f-a7e6-5d24952c9639 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
812 2024.05.14 09:44:56.806455 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49435, User-Agent: (none), Length: 51, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
813 2024.05.14 09:44:56.806503 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
814 2024.05.14 09:44:56.806522 [ 3 ] {} <Debug> HTTP-Session: 05138401-e01f-4e03-bba2-6f546ee34ae0 Authenticating user 'default' from [fd00:1122:3344:101::d]:49435
815 2024.05.14 09:44:56.806538 [ 3 ] {} <Debug> HTTP-Session: 05138401-e01f-4e03-bba2-6f546ee34ae0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
816 2024.05.14 09:44:56.806552 [ 3 ] {} <Debug> HTTP-Session: 05138401-e01f-4e03-bba2-6f546ee34ae0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
817 2024.05.14 09:44:56.806582 [ 3 ] {} <Trace> HTTP-Session: 05138401-e01f-4e03-bba2-6f546ee34ae0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
818 2024.05.14 09:44:56.806747 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49435) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
819 2024.05.14 09:44:56.808379 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
820 2024.05.14 09:44:56.812126 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Trace> oximeter.version (59999636-6651-4b9e-9754-42bb6995b91d): Trying to reserve 1.00 MiB using storage policy from min volume index 0
821 2024.05.14 09:44:56.812163 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.38 GiB.
822 2024.05.14 09:44:56.816435 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
823 2024.05.14 09:44:56.817464 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Trace> oximeter.version (59999636-6651-4b9e-9754-42bb6995b91d): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
824 2024.05.14 09:44:56.817741 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.011071 sec., 90.32607713846988 rows/sec., 1.41 KiB/sec.
825 2024.05.14 09:44:56.817895 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Debug> DynamicQueryHandler: Done processing query
826 2024.05.14 09:44:56.817919 [ 3 ] {ab5b47d7-a037-408f-92bf-b82ecdfb7e53} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB.
827 2024.05.14 09:44:56.817934 [ 3 ] {} <Debug> HTTP-Session: 05138401-e01f-4e03-bba2-6f546ee34ae0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
828 2024.05.14 09:44:57.000202 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 160.62 MiB, peak 165.76 MiB, free memory in arenas 0.00 B, will set to 173.66 MiB (RSS), difference: 13.04 MiB