Max level shown:
1 [ Oct 15 23:29:41 Enabled. ]
2 [ Oct 15 23:29:41 Rereading configuration. ]
3 [ Oct 15 23:29:42 Rereading configuration. ]
4 [ Oct 15 23:29:44 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 + args=("--log-file" "/var/tmp/clickhouse-server.log" "--errorlog-file" "/var/tmp/clickhouse-server.errlog" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT")
23 + 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
24 [ Oct 15 23:29:44 Method "start" exited with status 0. ]
25 Processing configuration file 'config.xml'.
26 There is no file 'config.xml', will use embedded config.
27 Logging trace to /var/tmp/clickhouse-server.log
28 Logging errors to /var/tmp/clickhouse-server.errlog
29 2024.10.15 23:29:46.118991 [ 1 ] {} <Information> Application: Will watch for the process with pid 22573
30 2024.10.15 23:29:46.119524 [ 1 ] {} <Information> Application: Forked a child process to watch
31 2024.10.15 23:29:46.433898 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 22573
32 2024.10.15 23:29:46.434874 [ 1 ] {} <Information> Application: starting up
33 2024.10.15 23:29:46.435936 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc
34 2024.10.15 23:29:46.553212 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48.
35 2024.10.15 23:29:46.597663 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536
36 2024.10.15 23:29:46.597716 [ 1 ] {} <Debug> Application: Initializing DateLUT.
37 2024.10.15 23:29:46.597740 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
38 2024.10.15 23:29:46.597821 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it
39 2024.10.15 23:29:46.598185 [ 1 ] {} <Debug> Application: Initializing interserver credentials.
40 2024.10.15 23:29:46.600438 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
41 Processing configuration file 'config.xml'.
42 There is no file 'config.xml', will use embedded config.
43 Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'.
44 2024.10.15 23:29:46.601129 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
45 2024.10.15 23:29:46.602340 [ 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)
46 2024.10.15 23:29:46.602380 [ 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)
47 2024.10.15 23:29:46.602400 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB
48 2024.10.15 23:29:46.602647 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
49 2024.10.15 23:29:46.603782 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
50 2024.10.15 23:29:46.610762 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
51 2024.10.15 23:29:46.611787 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
52 2024.10.15 23:29:46.613739 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
53 2024.10.15 23:29:46.613834 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
54 2024.10.15 23:29:46.616039 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
55 Processing configuration file 'config.xml'.
56 There is no file 'config.xml', will use embedded config.
57 Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'.
58 2024.10.15 23:29:46.616496 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
59 2024.10.15 23:29:46.623013 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
60 2024.10.15 23:29:46.623423 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml
61 2024.10.15 23:29:46.625244 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
62 2024.10.15 23:29:46.625672 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
63 2024.10.15 23:29:46.626049 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
64 2024.10.15 23:29:46.626914 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
65 2024.10.15 23:29:46.628672 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
66 2024.10.15 23:29:46.628709 [ 1 ] {} <Information> Application: Loading metadata from /data/
67 2024.10.15 23:29:46.628786 [ 133 ] {} <Debug> DNSResolver: Updating DNS cache
68 2024.10.15 23:29:46.628962 [ 133 ] {} <Debug> DNSResolver: Updated DNS cache
69 2024.10.15 23:29:46.653747 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
70 2024.10.15 23:29:46.653782 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000190004 sec
71 2024.10.15 23:29:46.653845 [ 1 ] {} <Trace> ReferentialDeps: No tables
72 2024.10.15 23:29:46.653862 [ 1 ] {} <Trace> LoadingDeps: No tables
73 2024.10.15 23:29:46.655409 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables.
74 2024.10.15 23:29:46.656905 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config
75 2024.10.15 23:29:46.656939 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
76 2024.10.15 23:29:46.657005 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
77 2024.10.15 23:29:46.657027 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
78 2024.10.15 23:29:46.657044 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
79 2024.10.15 23:29:46.657090 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
80 2024.10.15 23:29:46.657107 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config
81 2024.10.15 23:29:46.657128 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
82 2024.10.15 23:29:46.657174 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
83 2024.10.15 23:29:46.657197 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config
84 2024.10.15 23:29:46.657221 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
85 2024.10.15 23:29:46.657249 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
86 2024.10.15 23:29:46.657298 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
87 2024.10.15 23:29:46.657324 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
88 2024.10.15 23:29:46.657343 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
89 2024.10.15 23:29:46.657394 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
90 2024.10.15 23:29:46.657417 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
91 2024.10.15 23:29:46.706182 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
92 2024.10.15 23:29:46.712701 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
93 2024.10.15 23:29:46.712741 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.9851e-05 sec
94 2024.10.15 23:29:46.712756 [ 1 ] {} <Trace> ReferentialDeps: No tables
95 2024.10.15 23:29:46.712768 [ 1 ] {} <Trace> LoadingDeps: No tables
96 2024.10.15 23:29:46.712799 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables.
97 2024.10.15 23:29:46.713003 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/
98 2024.10.15 23:29:46.713052 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
99 2024.10.15 23:29:46.713067 [ 1 ] {} <Debug> Application: Loaded metadata.
100 2024.10.15 23:29:46.713079 [ 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).
101 2024.10.15 23:29:46.713101 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled.
102 2024.10.15 23:29:46.738936 [ 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)
103 2024.10.15 23:29:46.979616 [ 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)
104 2024.10.15 23:29:46.979690 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair.
105 2024.10.15 23:29:47.136712 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
106 2024.10.15 23:29:47.137006 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.07 MiB, free memory in arenas 0.00 B, will set to 157.11 MiB (RSS), difference: 147.23 MiB
107 2024.10.15 23:29:47.138169 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.0361e-05 sec.
108 2024.10.15 23:29:47.138608 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123
109 2024.10.15 23:29:47.138677 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000
110 2024.10.15 23:29:47.138758 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [fd00:1122:3344:101::e]:9004
111 2024.10.15 23:29:47.138788 [ 1 ] {} <Information> Application: Ready for connections.
112 2024.10.15 23:29:47.140167 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
113 2024.10.15 23:29:47.140462 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
114 2024.10.15 23:29:47.140517 [ 3 ] {} <Debug> HTTP-Session: aa33cd1b-51a3-4c1c-b7ce-22f7daef70dc Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
115 2024.10.15 23:29:47.140561 [ 3 ] {} <Debug> HTTP-Session: aa33cd1b-51a3-4c1c-b7ce-22f7daef70dc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
116 2024.10.15 23:29:47.140584 [ 3 ] {} <Debug> HTTP-Session: aa33cd1b-51a3-4c1c-b7ce-22f7daef70dc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
117 2024.10.15 23:29:47.140708 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
118 2024.10.15 23:29:47.140754 [ 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
119 2024.10.15 23:29:47.140787 [ 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
120 2024.10.15 23:29:47.140877 [ 3 ] {} <Trace> HTTP-Session: aa33cd1b-51a3-4c1c-b7ce-22f7daef70dc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
121 2024.10.15 23:29:47.142267 [ 3 ] {daf671f0-5fcc-42ae-b06e-3221601b1557} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
122 2024.10.15 23:29:47.199989 [ 3 ] {daf671f0-5fcc-42ae-b06e-3221601b1557} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:33953) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
123 
124 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse
125 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse
126 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
127 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse
128 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse
129 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse
130 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
131 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
132 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
133 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
134 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
135 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse
136 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse
137 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
138 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse
139 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse
140 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse
141 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse
142 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse
143 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse
144 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse
145 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1
146 
147 2024.10.15 23:29:47.201109 [ 3 ] {daf671f0-5fcc-42ae-b06e-3221601b1557} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
148 
149 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse
150 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse
151 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
152 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse
153 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse
154 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse
155 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
156 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
157 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
158 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
159 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
160 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse
161 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse
162 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
163 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse
164 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse
165 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse
166 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse
167 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse
168 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse
169 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse
170 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1
171 (version 23.8.7.1)
172 2024.10.15 23:29:47.201407 [ 3 ] {} <Debug> HTTP-Session: aa33cd1b-51a3-4c1c-b7ce-22f7daef70dc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
173 2024.10.15 23:29:47.201961 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
174 2024.10.15 23:29:47.202076 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
175 2024.10.15 23:29:47.202110 [ 3 ] {} <Debug> HTTP-Session: f5dc64ba-e004-4334-bb9a-400ce8e3219d Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
176 2024.10.15 23:29:47.202145 [ 3 ] {} <Debug> HTTP-Session: f5dc64ba-e004-4334-bb9a-400ce8e3219d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
177 2024.10.15 23:29:47.202171 [ 3 ] {} <Debug> HTTP-Session: f5dc64ba-e004-4334-bb9a-400ce8e3219d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
178 2024.10.15 23:29:47.202237 [ 3 ] {} <Trace> HTTP-Session: f5dc64ba-e004-4334-bb9a-400ce8e3219d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
179 2024.10.15 23:29:47.203998 [ 3 ] {52566071-83e7-44dc-a391-ea9197eb771a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) DROP DATABASE IF EXISTS oximeter (stage: Complete)
180 2024.10.15 23:29:47.205041 [ 3 ] {52566071-83e7-44dc-a391-ea9197eb771a} <Debug> DynamicQueryHandler: Done processing query
181 2024.10.15 23:29:47.205080 [ 3 ] {} <Debug> HTTP-Session: f5dc64ba-e004-4334-bb9a-400ce8e3219d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
182 2024.10.15 23:29:47.205324 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
183 2024.10.15 23:29:47.205399 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
184 2024.10.15 23:29:47.205433 [ 3 ] {} <Debug> HTTP-Session: 8d24fc03-2675-4c9b-a1c3-70fd73b69a62 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
185 2024.10.15 23:29:47.205458 [ 3 ] {} <Debug> HTTP-Session: 8d24fc03-2675-4c9b-a1c3-70fd73b69a62 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
186 2024.10.15 23:29:47.205486 [ 3 ] {} <Debug> HTTP-Session: 8d24fc03-2675-4c9b-a1c3-70fd73b69a62 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
187 2024.10.15 23:29:47.205536 [ 3 ] {} <Trace> HTTP-Session: 8d24fc03-2675-4c9b-a1c3-70fd73b69a62 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
188 2024.10.15 23:29:47.205618 [ 3 ] {e63be71a-7fd1-4f0b-af78-e85e5463d63e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
189 2024.10.15 23:29:47.205745 [ 3 ] {e63be71a-7fd1-4f0b-af78-e85e5463d63e} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
190 2024.10.15 23:29:47.212163 [ 3 ] {e63be71a-7fd1-4f0b-af78-e85e5463d63e} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
191 2024.10.15 23:29:47.212219 [ 3 ] {e63be71a-7fd1-4f0b-af78-e85e5463d63e} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000101052 sec
192 2024.10.15 23:29:47.212246 [ 3 ] {e63be71a-7fd1-4f0b-af78-e85e5463d63e} <Trace> ReferentialDeps: No tables
193 2024.10.15 23:29:47.212275 [ 3 ] {e63be71a-7fd1-4f0b-af78-e85e5463d63e} <Trace> LoadingDeps: No tables
194 2024.10.15 23:29:47.212319 [ 3 ] {e63be71a-7fd1-4f0b-af78-e85e5463d63e} <Information> DatabaseAtomic (oximeter): Starting up tables.
195 2024.10.15 23:29:47.212467 [ 3 ] {e63be71a-7fd1-4f0b-af78-e85e5463d63e} <Debug> DynamicQueryHandler: Done processing query
196 2024.10.15 23:29:47.212509 [ 3 ] {} <Debug> HTTP-Session: 8d24fc03-2675-4c9b-a1c3-70fd73b69a62 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
197 2024.10.15 23:29:47.212715 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
198 2024.10.15 23:29:47.212811 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
199 2024.10.15 23:29:47.212837 [ 3 ] {} <Debug> HTTP-Session: b05bf400-704f-4d91-b87c-960aa0efb8eb Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
200 2024.10.15 23:29:47.212866 [ 3 ] {} <Debug> HTTP-Session: b05bf400-704f-4d91-b87c-960aa0efb8eb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
201 2024.10.15 23:29:47.212892 [ 3 ] {} <Debug> HTTP-Session: b05bf400-704f-4d91-b87c-960aa0efb8eb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
202 2024.10.15 23:29:47.212935 [ 3 ] {} <Trace> HTTP-Session: b05bf400-704f-4d91-b87c-960aa0efb8eb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
203 2024.10.15 23:29:47.213114 [ 3 ] {ba827e60-b463-463f-a6c5-15e29caf87e9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) /* The version table contains metadata about the `oximeter` database */
204 CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete)
205 2024.10.15 23:29:47.213183 [ 3 ] {ba827e60-b463-463f-a6c5-15e29caf87e9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
206 2024.10.15 23:29:47.222956 [ 3 ] {ba827e60-b463-463f-a6c5-15e29caf87e9} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
207 2024.10.15 23:29:47.227123 [ 3 ] {ba827e60-b463-463f-a6c5-15e29caf87e9} <Debug> oximeter.version (b05a19ef-8dd5-424a-8a53-68f0b504aa8b): Loading data parts
208 2024.10.15 23:29:47.227799 [ 3 ] {ba827e60-b463-463f-a6c5-15e29caf87e9} <Debug> oximeter.version (b05a19ef-8dd5-424a-8a53-68f0b504aa8b): There are no data parts
209 2024.10.15 23:29:47.231181 [ 3 ] {ba827e60-b463-463f-a6c5-15e29caf87e9} <Debug> DynamicQueryHandler: Done processing query
210 2024.10.15 23:29:47.231214 [ 3 ] {} <Debug> HTTP-Session: b05bf400-704f-4d91-b87c-960aa0efb8eb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
211 2024.10.15 23:29:47.231411 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
212 2024.10.15 23:29:47.231477 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
213 2024.10.15 23:29:47.231568 [ 3 ] {} <Debug> HTTP-Session: 960fea80-276d-4493-bf20-2d32f00bcda3 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
214 2024.10.15 23:29:47.231596 [ 3 ] {} <Debug> HTTP-Session: 960fea80-276d-4493-bf20-2d32f00bcda3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
215 2024.10.15 23:29:47.231618 [ 3 ] {} <Debug> HTTP-Session: 960fea80-276d-4493-bf20-2d32f00bcda3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
216 2024.10.15 23:29:47.231660 [ 3 ] {} <Trace> HTTP-Session: 960fea80-276d-4493-bf20-2d32f00bcda3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
217 2024.10.15 23:29:47.231902 [ 3 ] {2f5c9bcb-87ed-4498-8139-1a6ae295a38c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) /* The measurement tables contain all individual samples from each timeseries.
218 *
219 * Each table stores a single datum type, and otherwise contains nearly the same
220 * structure. The primary sorting key is on the timeseries name, key, and then
221 * timestamp, so that all timeseries from the same schema are grouped, followed
222 * by all samples from the same timeseries.
223 *
224 * This reflects that one usually looks up the _key_ in one or more field table,
225 * and then uses that to index quickly into the measurements tables.
226 */
227 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)
228 2024.10.15 23:29:47.231974 [ 3 ] {2f5c9bcb-87ed-4498-8139-1a6ae295a38c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
229 2024.10.15 23:29:47.242667 [ 3 ] {2f5c9bcb-87ed-4498-8139-1a6ae295a38c} <Debug> oximeter.measurements_bool (39886dbc-9635-44b1-88fc-37b5a40a69ba): Loading data parts
230 2024.10.15 23:29:47.242991 [ 3 ] {2f5c9bcb-87ed-4498-8139-1a6ae295a38c} <Debug> oximeter.measurements_bool (39886dbc-9635-44b1-88fc-37b5a40a69ba): There are no data parts
231 2024.10.15 23:29:47.250274 [ 3 ] {2f5c9bcb-87ed-4498-8139-1a6ae295a38c} <Debug> DynamicQueryHandler: Done processing query
232 2024.10.15 23:29:47.250329 [ 3 ] {} <Debug> HTTP-Session: 960fea80-276d-4493-bf20-2d32f00bcda3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
233 2024.10.15 23:29:47.250511 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
234 2024.10.15 23:29:47.250592 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
235 2024.10.15 23:29:47.250627 [ 3 ] {} <Debug> HTTP-Session: 89255177-2025-4435-bd86-c265a9666eaa Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
236 2024.10.15 23:29:47.250653 [ 3 ] {} <Debug> HTTP-Session: 89255177-2025-4435-bd86-c265a9666eaa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
237 2024.10.15 23:29:47.250686 [ 3 ] {} <Debug> HTTP-Session: 89255177-2025-4435-bd86-c265a9666eaa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
238 2024.10.15 23:29:47.250736 [ 3 ] {} <Trace> HTTP-Session: 89255177-2025-4435-bd86-c265a9666eaa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
239 2024.10.15 23:29:47.250931 [ 3 ] {af825e90-1fb8-48d7-aab3-ee0a77fbeecd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
240 2024.10.15 23:29:47.250993 [ 3 ] {af825e90-1fb8-48d7-aab3-ee0a77fbeecd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
241 2024.10.15 23:29:47.258445 [ 3 ] {af825e90-1fb8-48d7-aab3-ee0a77fbeecd} <Debug> oximeter.measurements_i8 (d493cc06-f881-40dc-9327-0dc7cc8af2c0): Loading data parts
242 2024.10.15 23:29:47.258648 [ 3 ] {af825e90-1fb8-48d7-aab3-ee0a77fbeecd} <Debug> oximeter.measurements_i8 (d493cc06-f881-40dc-9327-0dc7cc8af2c0): There are no data parts
243 2024.10.15 23:29:47.265523 [ 3 ] {af825e90-1fb8-48d7-aab3-ee0a77fbeecd} <Debug> DynamicQueryHandler: Done processing query
244 2024.10.15 23:29:47.265567 [ 3 ] {} <Debug> HTTP-Session: 89255177-2025-4435-bd86-c265a9666eaa Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
245 2024.10.15 23:29:47.265737 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
246 2024.10.15 23:29:47.265815 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
247 2024.10.15 23:29:47.265841 [ 3 ] {} <Debug> HTTP-Session: d44dbbcb-3f79-4476-8448-c29c7173c6ab Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
248 2024.10.15 23:29:47.265867 [ 3 ] {} <Debug> HTTP-Session: d44dbbcb-3f79-4476-8448-c29c7173c6ab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
249 2024.10.15 23:29:47.265887 [ 3 ] {} <Debug> HTTP-Session: d44dbbcb-3f79-4476-8448-c29c7173c6ab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
250 2024.10.15 23:29:47.265931 [ 3 ] {} <Trace> HTTP-Session: d44dbbcb-3f79-4476-8448-c29c7173c6ab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
251 2024.10.15 23:29:47.266117 [ 3 ] {e468971f-7fc4-4558-90d6-43f9778b415a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
252 2024.10.15 23:29:47.266179 [ 3 ] {e468971f-7fc4-4558-90d6-43f9778b415a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
253 2024.10.15 23:29:47.273403 [ 3 ] {e468971f-7fc4-4558-90d6-43f9778b415a} <Debug> oximeter.measurements_u8 (31c28cb5-44db-4a8b-8263-7c30a0b76064): Loading data parts
254 2024.10.15 23:29:47.273736 [ 3 ] {e468971f-7fc4-4558-90d6-43f9778b415a} <Debug> oximeter.measurements_u8 (31c28cb5-44db-4a8b-8263-7c30a0b76064): There are no data parts
255 2024.10.15 23:29:47.275709 [ 3 ] {e468971f-7fc4-4558-90d6-43f9778b415a} <Debug> DynamicQueryHandler: Done processing query
256 2024.10.15 23:29:47.275745 [ 3 ] {} <Debug> HTTP-Session: d44dbbcb-3f79-4476-8448-c29c7173c6ab Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
257 2024.10.15 23:29:47.275911 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
258 2024.10.15 23:29:47.275976 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
259 2024.10.15 23:29:47.276004 [ 3 ] {} <Debug> HTTP-Session: 34558142-e1a5-4c22-a479-164d10520e44 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
260 2024.10.15 23:29:47.276024 [ 3 ] {} <Debug> HTTP-Session: 34558142-e1a5-4c22-a479-164d10520e44 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
261 2024.10.15 23:29:47.276042 [ 3 ] {} <Debug> HTTP-Session: 34558142-e1a5-4c22-a479-164d10520e44 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
262 2024.10.15 23:29:47.276085 [ 3 ] {} <Trace> HTTP-Session: 34558142-e1a5-4c22-a479-164d10520e44 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
263 2024.10.15 23:29:47.276279 [ 3 ] {25f32814-439b-49b6-863c-48a49a04af67} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
264 2024.10.15 23:29:47.276348 [ 3 ] {25f32814-439b-49b6-863c-48a49a04af67} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
265 2024.10.15 23:29:47.278301 [ 3 ] {25f32814-439b-49b6-863c-48a49a04af67} <Debug> oximeter.measurements_i16 (b6de9458-f111-49ec-bad8-543825e1ca96): Loading data parts
266 2024.10.15 23:29:47.278489 [ 3 ] {25f32814-439b-49b6-863c-48a49a04af67} <Debug> oximeter.measurements_i16 (b6de9458-f111-49ec-bad8-543825e1ca96): There are no data parts
267 2024.10.15 23:29:47.279887 [ 3 ] {25f32814-439b-49b6-863c-48a49a04af67} <Debug> DynamicQueryHandler: Done processing query
268 2024.10.15 23:29:47.279918 [ 3 ] {} <Debug> HTTP-Session: 34558142-e1a5-4c22-a479-164d10520e44 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
269 2024.10.15 23:29:47.280072 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
270 2024.10.15 23:29:47.280135 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
271 2024.10.15 23:29:47.280158 [ 3 ] {} <Debug> HTTP-Session: 8b35537c-71ea-40fa-b5a6-1e43fe67cbea Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
272 2024.10.15 23:29:47.280184 [ 3 ] {} <Debug> HTTP-Session: 8b35537c-71ea-40fa-b5a6-1e43fe67cbea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
273 2024.10.15 23:29:47.280203 [ 3 ] {} <Debug> HTTP-Session: 8b35537c-71ea-40fa-b5a6-1e43fe67cbea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
274 2024.10.15 23:29:47.280241 [ 3 ] {} <Trace> HTTP-Session: 8b35537c-71ea-40fa-b5a6-1e43fe67cbea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
275 2024.10.15 23:29:47.280423 [ 3 ] {bff8a22f-7a00-463c-b346-93a9a4eb67f9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
276 2024.10.15 23:29:47.280483 [ 3 ] {bff8a22f-7a00-463c-b346-93a9a4eb67f9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
277 2024.10.15 23:29:47.282388 [ 3 ] {bff8a22f-7a00-463c-b346-93a9a4eb67f9} <Debug> oximeter.measurements_u16 (ac87a2ff-0ff9-4624-b094-f088572e961c): Loading data parts
278 2024.10.15 23:29:47.282832 [ 3 ] {bff8a22f-7a00-463c-b346-93a9a4eb67f9} <Debug> oximeter.measurements_u16 (ac87a2ff-0ff9-4624-b094-f088572e961c): There are no data parts
279 2024.10.15 23:29:47.284244 [ 3 ] {bff8a22f-7a00-463c-b346-93a9a4eb67f9} <Debug> DynamicQueryHandler: Done processing query
280 2024.10.15 23:29:47.284277 [ 3 ] {} <Debug> HTTP-Session: 8b35537c-71ea-40fa-b5a6-1e43fe67cbea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
281 2024.10.15 23:29:47.284408 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
282 2024.10.15 23:29:47.284473 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
283 2024.10.15 23:29:47.284500 [ 3 ] {} <Debug> HTTP-Session: 9733b0b7-d68b-4026-a9a9-9068bf39106c Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
284 2024.10.15 23:29:47.284589 [ 3 ] {} <Debug> HTTP-Session: 9733b0b7-d68b-4026-a9a9-9068bf39106c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
285 2024.10.15 23:29:47.284612 [ 3 ] {} <Debug> HTTP-Session: 9733b0b7-d68b-4026-a9a9-9068bf39106c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
286 2024.10.15 23:29:47.284652 [ 3 ] {} <Trace> HTTP-Session: 9733b0b7-d68b-4026-a9a9-9068bf39106c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
287 2024.10.15 23:29:47.284838 [ 3 ] {f4f12e65-845f-457d-bcd5-35ae1c38d870} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
288 2024.10.15 23:29:47.284906 [ 3 ] {f4f12e65-845f-457d-bcd5-35ae1c38d870} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
289 2024.10.15 23:29:47.286777 [ 3 ] {f4f12e65-845f-457d-bcd5-35ae1c38d870} <Debug> oximeter.measurements_i32 (9ae63231-8116-48cb-83f6-27ed835b7dc3): Loading data parts
290 2024.10.15 23:29:47.286982 [ 3 ] {f4f12e65-845f-457d-bcd5-35ae1c38d870} <Debug> oximeter.measurements_i32 (9ae63231-8116-48cb-83f6-27ed835b7dc3): There are no data parts
291 2024.10.15 23:29:47.288265 [ 3 ] {f4f12e65-845f-457d-bcd5-35ae1c38d870} <Debug> DynamicQueryHandler: Done processing query
292 2024.10.15 23:29:47.288296 [ 3 ] {} <Debug> HTTP-Session: 9733b0b7-d68b-4026-a9a9-9068bf39106c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
293 2024.10.15 23:29:47.288445 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
294 2024.10.15 23:29:47.288505 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
295 2024.10.15 23:29:47.288593 [ 3 ] {} <Debug> HTTP-Session: 17344dae-a8ac-48a4-adf0-541b19d00f65 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
296 2024.10.15 23:29:47.288620 [ 3 ] {} <Debug> HTTP-Session: 17344dae-a8ac-48a4-adf0-541b19d00f65 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
297 2024.10.15 23:29:47.288643 [ 3 ] {} <Debug> HTTP-Session: 17344dae-a8ac-48a4-adf0-541b19d00f65 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
298 2024.10.15 23:29:47.288676 [ 3 ] {} <Trace> HTTP-Session: 17344dae-a8ac-48a4-adf0-541b19d00f65 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
299 2024.10.15 23:29:47.288851 [ 3 ] {4520c7b4-41b7-4163-ae25-99ef7d04af85} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
300 2024.10.15 23:29:47.288912 [ 3 ] {4520c7b4-41b7-4163-ae25-99ef7d04af85} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
301 2024.10.15 23:29:47.290804 [ 3 ] {4520c7b4-41b7-4163-ae25-99ef7d04af85} <Debug> oximeter.measurements_u32 (d4e1bf4b-eb0c-41be-82c1-3d040a376b90): Loading data parts
302 2024.10.15 23:29:47.290998 [ 3 ] {4520c7b4-41b7-4163-ae25-99ef7d04af85} <Debug> oximeter.measurements_u32 (d4e1bf4b-eb0c-41be-82c1-3d040a376b90): There are no data parts
303 2024.10.15 23:29:47.292428 [ 3 ] {4520c7b4-41b7-4163-ae25-99ef7d04af85} <Debug> DynamicQueryHandler: Done processing query
304 2024.10.15 23:29:47.292461 [ 3 ] {} <Debug> HTTP-Session: 17344dae-a8ac-48a4-adf0-541b19d00f65 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
305 2024.10.15 23:29:47.292599 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
306 2024.10.15 23:29:47.292664 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
307 2024.10.15 23:29:47.292686 [ 3 ] {} <Debug> HTTP-Session: db3bb7fa-d7cb-4429-b328-b1ebcbff5392 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
308 2024.10.15 23:29:47.292712 [ 3 ] {} <Debug> HTTP-Session: db3bb7fa-d7cb-4429-b328-b1ebcbff5392 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
309 2024.10.15 23:29:47.292733 [ 3 ] {} <Debug> HTTP-Session: db3bb7fa-d7cb-4429-b328-b1ebcbff5392 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
310 2024.10.15 23:29:47.292766 [ 3 ] {} <Trace> HTTP-Session: db3bb7fa-d7cb-4429-b328-b1ebcbff5392 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
311 2024.10.15 23:29:47.292935 [ 3 ] {8c359ed1-9688-41ca-a854-75c25df8ca7e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
312 2024.10.15 23:29:47.293001 [ 3 ] {8c359ed1-9688-41ca-a854-75c25df8ca7e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
313 2024.10.15 23:29:47.294879 [ 3 ] {8c359ed1-9688-41ca-a854-75c25df8ca7e} <Debug> oximeter.measurements_i64 (dee9ddec-a142-49a0-b736-0d9ece91a5c0): Loading data parts
314 2024.10.15 23:29:47.295083 [ 3 ] {8c359ed1-9688-41ca-a854-75c25df8ca7e} <Debug> oximeter.measurements_i64 (dee9ddec-a142-49a0-b736-0d9ece91a5c0): There are no data parts
315 2024.10.15 23:29:47.296390 [ 3 ] {8c359ed1-9688-41ca-a854-75c25df8ca7e} <Debug> DynamicQueryHandler: Done processing query
316 2024.10.15 23:29:47.296424 [ 3 ] {} <Debug> HTTP-Session: db3bb7fa-d7cb-4429-b328-b1ebcbff5392 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
317 2024.10.15 23:29:47.296571 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
318 2024.10.15 23:29:47.296638 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
319 2024.10.15 23:29:47.296660 [ 3 ] {} <Debug> HTTP-Session: e63c6d27-6c38-4ba7-9bd0-16f980958372 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
320 2024.10.15 23:29:47.296686 [ 3 ] {} <Debug> HTTP-Session: e63c6d27-6c38-4ba7-9bd0-16f980958372 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
321 2024.10.15 23:29:47.296709 [ 3 ] {} <Debug> HTTP-Session: e63c6d27-6c38-4ba7-9bd0-16f980958372 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
322 2024.10.15 23:29:47.296743 [ 3 ] {} <Trace> HTTP-Session: e63c6d27-6c38-4ba7-9bd0-16f980958372 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
323 2024.10.15 23:29:47.296919 [ 3 ] {43a8e561-923a-4e48-b2ad-782032b1e2fd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
324 2024.10.15 23:29:47.296986 [ 3 ] {43a8e561-923a-4e48-b2ad-782032b1e2fd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
325 2024.10.15 23:29:47.298932 [ 3 ] {43a8e561-923a-4e48-b2ad-782032b1e2fd} <Debug> oximeter.measurements_u64 (f7d1d729-cb1c-44d0-9cba-655e709e28ec): Loading data parts
326 2024.10.15 23:29:47.299120 [ 3 ] {43a8e561-923a-4e48-b2ad-782032b1e2fd} <Debug> oximeter.measurements_u64 (f7d1d729-cb1c-44d0-9cba-655e709e28ec): There are no data parts
327 2024.10.15 23:29:47.300338 [ 3 ] {43a8e561-923a-4e48-b2ad-782032b1e2fd} <Debug> DynamicQueryHandler: Done processing query
328 2024.10.15 23:29:47.300368 [ 3 ] {} <Debug> HTTP-Session: e63c6d27-6c38-4ba7-9bd0-16f980958372 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
329 2024.10.15 23:29:47.300497 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
330 2024.10.15 23:29:47.300627 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
331 2024.10.15 23:29:47.300649 [ 3 ] {} <Debug> HTTP-Session: 5134252d-94d1-4787-8268-b4b45edf5267 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
332 2024.10.15 23:29:47.300678 [ 3 ] {} <Debug> HTTP-Session: 5134252d-94d1-4787-8268-b4b45edf5267 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
333 2024.10.15 23:29:47.300701 [ 3 ] {} <Debug> HTTP-Session: 5134252d-94d1-4787-8268-b4b45edf5267 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
334 2024.10.15 23:29:47.300736 [ 3 ] {} <Trace> HTTP-Session: 5134252d-94d1-4787-8268-b4b45edf5267 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
335 2024.10.15 23:29:47.300915 [ 3 ] {0719d6c2-5410-4c0e-8b3d-f72753fbf7d7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
336 2024.10.15 23:29:47.300985 [ 3 ] {0719d6c2-5410-4c0e-8b3d-f72753fbf7d7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
337 2024.10.15 23:29:47.302823 [ 3 ] {0719d6c2-5410-4c0e-8b3d-f72753fbf7d7} <Debug> oximeter.measurements_f32 (ae45d7e5-2e7e-4c49-b0d3-5f85d1553712): Loading data parts
338 2024.10.15 23:29:47.303067 [ 3 ] {0719d6c2-5410-4c0e-8b3d-f72753fbf7d7} <Debug> oximeter.measurements_f32 (ae45d7e5-2e7e-4c49-b0d3-5f85d1553712): There are no data parts
339 2024.10.15 23:29:47.304331 [ 3 ] {0719d6c2-5410-4c0e-8b3d-f72753fbf7d7} <Debug> DynamicQueryHandler: Done processing query
340 2024.10.15 23:29:47.304362 [ 3 ] {} <Debug> HTTP-Session: 5134252d-94d1-4787-8268-b4b45edf5267 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
341 2024.10.15 23:29:47.304490 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
342 2024.10.15 23:29:47.304615 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
343 2024.10.15 23:29:47.304639 [ 3 ] {} <Debug> HTTP-Session: 78f0306d-533a-4479-a640-b774635ea400 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
344 2024.10.15 23:29:47.304666 [ 3 ] {} <Debug> HTTP-Session: 78f0306d-533a-4479-a640-b774635ea400 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
345 2024.10.15 23:29:47.304689 [ 3 ] {} <Debug> HTTP-Session: 78f0306d-533a-4479-a640-b774635ea400 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
346 2024.10.15 23:29:47.304726 [ 3 ] {} <Trace> HTTP-Session: 78f0306d-533a-4479-a640-b774635ea400 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
347 2024.10.15 23:29:47.304914 [ 3 ] {ccfa575c-19e9-4ad7-8eb7-ab5c1088b056} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
348 2024.10.15 23:29:47.304981 [ 3 ] {ccfa575c-19e9-4ad7-8eb7-ab5c1088b056} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
349 2024.10.15 23:29:47.306848 [ 3 ] {ccfa575c-19e9-4ad7-8eb7-ab5c1088b056} <Debug> oximeter.measurements_f64 (36be3d85-ac08-4e3a-96aa-203e3f9a78d5): Loading data parts
350 2024.10.15 23:29:47.307044 [ 3 ] {ccfa575c-19e9-4ad7-8eb7-ab5c1088b056} <Debug> oximeter.measurements_f64 (36be3d85-ac08-4e3a-96aa-203e3f9a78d5): There are no data parts
351 2024.10.15 23:29:47.308324 [ 3 ] {ccfa575c-19e9-4ad7-8eb7-ab5c1088b056} <Debug> DynamicQueryHandler: Done processing query
352 2024.10.15 23:29:47.308354 [ 3 ] {} <Debug> HTTP-Session: 78f0306d-533a-4479-a640-b774635ea400 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
353 2024.10.15 23:29:47.308488 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
354 2024.10.15 23:29:47.308614 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
355 2024.10.15 23:29:47.308636 [ 3 ] {} <Debug> HTTP-Session: 6a44f3a5-8f17-4a3e-998f-7e306dea696c Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
356 2024.10.15 23:29:47.308662 [ 3 ] {} <Debug> HTTP-Session: 6a44f3a5-8f17-4a3e-998f-7e306dea696c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
357 2024.10.15 23:29:47.308687 [ 3 ] {} <Debug> HTTP-Session: 6a44f3a5-8f17-4a3e-998f-7e306dea696c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
358 2024.10.15 23:29:47.308720 [ 3 ] {} <Trace> HTTP-Session: 6a44f3a5-8f17-4a3e-998f-7e306dea696c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
359 2024.10.15 23:29:47.308883 [ 3 ] {c12cc827-5d2e-4ce8-a9b2-4f95cb54b93c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
360 2024.10.15 23:29:47.308943 [ 3 ] {c12cc827-5d2e-4ce8-a9b2-4f95cb54b93c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
361 2024.10.15 23:29:47.310760 [ 3 ] {c12cc827-5d2e-4ce8-a9b2-4f95cb54b93c} <Debug> oximeter.measurements_string (bbd4beb8-bc7d-430f-abf5-043332d3d3e8): Loading data parts
362 2024.10.15 23:29:47.310981 [ 3 ] {c12cc827-5d2e-4ce8-a9b2-4f95cb54b93c} <Debug> oximeter.measurements_string (bbd4beb8-bc7d-430f-abf5-043332d3d3e8): There are no data parts
363 2024.10.15 23:29:47.312334 [ 3 ] {c12cc827-5d2e-4ce8-a9b2-4f95cb54b93c} <Debug> DynamicQueryHandler: Done processing query
364 2024.10.15 23:29:47.312365 [ 3 ] {} <Debug> HTTP-Session: 6a44f3a5-8f17-4a3e-998f-7e306dea696c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
365 2024.10.15 23:29:47.312510 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
366 2024.10.15 23:29:47.312576 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
367 2024.10.15 23:29:47.312599 [ 3 ] {} <Debug> HTTP-Session: 488298bd-d21c-48ea-9267-03901c1e6723 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
368 2024.10.15 23:29:47.312629 [ 3 ] {} <Debug> HTTP-Session: 488298bd-d21c-48ea-9267-03901c1e6723 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
369 2024.10.15 23:29:47.312651 [ 3 ] {} <Debug> HTTP-Session: 488298bd-d21c-48ea-9267-03901c1e6723 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
370 2024.10.15 23:29:47.312683 [ 3 ] {} <Trace> HTTP-Session: 488298bd-d21c-48ea-9267-03901c1e6723 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
371 2024.10.15 23:29:47.312854 [ 3 ] {f52a6589-ab23-41db-9b6e-330af4f85881} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /*
372 * NOTE: Right now we can't unambiguously record a nullable byte array.
373 * Arrays cannot be nested in `Nullable()` types, and encoding the array as
374 * a string isn't palatable for a few reasons.
375 * See: https://github.com/oxidecomputer/omicron/issues/4551 for more
376 * details.
377 */
378 datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
379 2024.10.15 23:29:47.312921 [ 3 ] {f52a6589-ab23-41db-9b6e-330af4f85881} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
380 2024.10.15 23:29:47.314775 [ 3 ] {f52a6589-ab23-41db-9b6e-330af4f85881} <Debug> oximeter.measurements_bytes (a9e2271b-df2e-4596-9968-efbfbe3e19dd): Loading data parts
381 2024.10.15 23:29:47.314967 [ 3 ] {f52a6589-ab23-41db-9b6e-330af4f85881} <Debug> oximeter.measurements_bytes (a9e2271b-df2e-4596-9968-efbfbe3e19dd): There are no data parts
382 2024.10.15 23:29:47.316312 [ 3 ] {f52a6589-ab23-41db-9b6e-330af4f85881} <Debug> DynamicQueryHandler: Done processing query
383 2024.10.15 23:29:47.316344 [ 3 ] {} <Debug> HTTP-Session: 488298bd-d21c-48ea-9267-03901c1e6723 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
384 2024.10.15 23:29:47.316484 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
385 2024.10.15 23:29:47.316545 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
386 2024.10.15 23:29:47.316578 [ 3 ] {} <Debug> HTTP-Session: 3bfda58b-ac29-4038-a7d2-9cdfc3e51277 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
387 2024.10.15 23:29:47.316600 [ 3 ] {} <Debug> HTTP-Session: 3bfda58b-ac29-4038-a7d2-9cdfc3e51277 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
388 2024.10.15 23:29:47.316623 [ 3 ] {} <Debug> HTTP-Session: 3bfda58b-ac29-4038-a7d2-9cdfc3e51277 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
389 2024.10.15 23:29:47.316661 [ 3 ] {} <Trace> HTTP-Session: 3bfda58b-ac29-4038-a7d2-9cdfc3e51277 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
390 2024.10.15 23:29:47.316828 [ 3 ] {d36cea3a-1df0-4963-9ba5-44661455d806} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
391 2024.10.15 23:29:47.316894 [ 3 ] {d36cea3a-1df0-4963-9ba5-44661455d806} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
392 2024.10.15 23:29:47.318793 [ 3 ] {d36cea3a-1df0-4963-9ba5-44661455d806} <Debug> oximeter.measurements_cumulativei64 (509251db-4aef-4e40-804c-6f1331695c29): Loading data parts
393 2024.10.15 23:29:47.318966 [ 3 ] {d36cea3a-1df0-4963-9ba5-44661455d806} <Debug> oximeter.measurements_cumulativei64 (509251db-4aef-4e40-804c-6f1331695c29): There are no data parts
394 2024.10.15 23:29:47.320209 [ 3 ] {d36cea3a-1df0-4963-9ba5-44661455d806} <Debug> DynamicQueryHandler: Done processing query
395 2024.10.15 23:29:47.320249 [ 3 ] {} <Debug> HTTP-Session: 3bfda58b-ac29-4038-a7d2-9cdfc3e51277 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
396 2024.10.15 23:29:47.320376 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
397 2024.10.15 23:29:47.320445 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
398 2024.10.15 23:29:47.320467 [ 3 ] {} <Debug> HTTP-Session: 1eb7bd67-e365-41c5-9c8d-7f617da5a323 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
399 2024.10.15 23:29:47.320484 [ 3 ] {} <Debug> HTTP-Session: 1eb7bd67-e365-41c5-9c8d-7f617da5a323 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
400 2024.10.15 23:29:47.320509 [ 3 ] {} <Debug> HTTP-Session: 1eb7bd67-e365-41c5-9c8d-7f617da5a323 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
401 2024.10.15 23:29:47.320615 [ 3 ] {} <Trace> HTTP-Session: 1eb7bd67-e365-41c5-9c8d-7f617da5a323 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
402 2024.10.15 23:29:47.320808 [ 3 ] {23b7cb04-3a02-4c2e-a410-93391f0a220f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
403 2024.10.15 23:29:47.320877 [ 3 ] {23b7cb04-3a02-4c2e-a410-93391f0a220f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
404 2024.10.15 23:29:47.322767 [ 3 ] {23b7cb04-3a02-4c2e-a410-93391f0a220f} <Debug> oximeter.measurements_cumulativeu64 (7c339cfd-1eaf-4dfd-a82a-3e7d41c9635b): Loading data parts
405 2024.10.15 23:29:47.322974 [ 3 ] {23b7cb04-3a02-4c2e-a410-93391f0a220f} <Debug> oximeter.measurements_cumulativeu64 (7c339cfd-1eaf-4dfd-a82a-3e7d41c9635b): There are no data parts
406 2024.10.15 23:29:47.324282 [ 3 ] {23b7cb04-3a02-4c2e-a410-93391f0a220f} <Debug> DynamicQueryHandler: Done processing query
407 2024.10.15 23:29:47.324312 [ 3 ] {} <Debug> HTTP-Session: 1eb7bd67-e365-41c5-9c8d-7f617da5a323 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
408 2024.10.15 23:29:47.324444 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
409 2024.10.15 23:29:47.324508 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
410 2024.10.15 23:29:47.324530 [ 3 ] {} <Debug> HTTP-Session: f7edf3a3-0557-40f7-ade2-e1cd21a08a5f Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
411 2024.10.15 23:29:47.324625 [ 3 ] {} <Debug> HTTP-Session: f7edf3a3-0557-40f7-ade2-e1cd21a08a5f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
412 2024.10.15 23:29:47.324642 [ 3 ] {} <Debug> HTTP-Session: f7edf3a3-0557-40f7-ade2-e1cd21a08a5f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
413 2024.10.15 23:29:47.324687 [ 3 ] {} <Trace> HTTP-Session: f7edf3a3-0557-40f7-ade2-e1cd21a08a5f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
414 2024.10.15 23:29:47.324883 [ 3 ] {ffd83bb3-7034-4343-832c-bdde2dcad25e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
415 2024.10.15 23:29:47.324955 [ 3 ] {ffd83bb3-7034-4343-832c-bdde2dcad25e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
416 2024.10.15 23:29:47.326938 [ 3 ] {ffd83bb3-7034-4343-832c-bdde2dcad25e} <Debug> oximeter.measurements_cumulativef32 (d2a7cdaf-af21-43ea-acab-30033e95d35a): Loading data parts
417 2024.10.15 23:29:47.327159 [ 3 ] {ffd83bb3-7034-4343-832c-bdde2dcad25e} <Debug> oximeter.measurements_cumulativef32 (d2a7cdaf-af21-43ea-acab-30033e95d35a): There are no data parts
418 2024.10.15 23:29:47.328559 [ 3 ] {ffd83bb3-7034-4343-832c-bdde2dcad25e} <Debug> DynamicQueryHandler: Done processing query
419 2024.10.15 23:29:47.328591 [ 3 ] {} <Debug> HTTP-Session: f7edf3a3-0557-40f7-ade2-e1cd21a08a5f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
420 2024.10.15 23:29:47.328720 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
421 2024.10.15 23:29:47.328782 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
422 2024.10.15 23:29:47.328803 [ 3 ] {} <Debug> HTTP-Session: 4d303c34-174c-4be9-9752-80e5b2cd9bae Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
423 2024.10.15 23:29:47.328832 [ 3 ] {} <Debug> HTTP-Session: 4d303c34-174c-4be9-9752-80e5b2cd9bae Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
424 2024.10.15 23:29:47.328856 [ 3 ] {} <Debug> HTTP-Session: 4d303c34-174c-4be9-9752-80e5b2cd9bae Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
425 2024.10.15 23:29:47.328890 [ 3 ] {} <Trace> HTTP-Session: 4d303c34-174c-4be9-9752-80e5b2cd9bae Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
426 2024.10.15 23:29:47.329072 [ 3 ] {3b59b1dc-5cba-43b4-9124-9d8c7b6ab74b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) 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)
427 2024.10.15 23:29:47.329140 [ 3 ] {3b59b1dc-5cba-43b4-9124-9d8c7b6ab74b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
428 2024.10.15 23:29:47.331097 [ 3 ] {3b59b1dc-5cba-43b4-9124-9d8c7b6ab74b} <Debug> oximeter.measurements_cumulativef64 (2c343c1f-ed02-4f79-86a0-708b911f3618): Loading data parts
429 2024.10.15 23:29:47.331292 [ 3 ] {3b59b1dc-5cba-43b4-9124-9d8c7b6ab74b} <Debug> oximeter.measurements_cumulativef64 (2c343c1f-ed02-4f79-86a0-708b911f3618): There are no data parts
430 2024.10.15 23:29:47.332669 [ 3 ] {3b59b1dc-5cba-43b4-9124-9d8c7b6ab74b} <Debug> DynamicQueryHandler: Done processing query
431 2024.10.15 23:29:47.332712 [ 3 ] {} <Debug> HTTP-Session: 4d303c34-174c-4be9-9752-80e5b2cd9bae Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
432 2024.10.15 23:29:47.332836 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
433 2024.10.15 23:29:47.332901 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
434 2024.10.15 23:29:47.332930 [ 3 ] {} <Debug> HTTP-Session: d2d1678a-4fd0-437d-ae53-113cfd2e4781 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
435 2024.10.15 23:29:47.332950 [ 3 ] {} <Debug> HTTP-Session: d2d1678a-4fd0-437d-ae53-113cfd2e4781 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
436 2024.10.15 23:29:47.332974 [ 3 ] {} <Debug> HTTP-Session: d2d1678a-4fd0-437d-ae53-113cfd2e4781 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
437 2024.10.15 23:29:47.333015 [ 3 ] {} <Trace> HTTP-Session: d2d1678a-4fd0-437d-ae53-113cfd2e4781 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
438 2024.10.15 23:29:47.333274 [ 3 ] {01c8ad9a-0526-4d98-b6ef-730e73b58cc9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /*
439 * NOTE: Array types cannot be Nullable, see
440 * https://clickhouse.com/docs/en/sql-reference/data-types/nullable
441 * for more details.
442 *
443 * This means we need to use empty arrays to indicate a missing value. This
444 * is unfortunate, and at this point relies on the fact that an
445 * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need
446 * to figure out another way to represent missing samples here.
447 */
448 bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
449 2024.10.15 23:29:47.333353 [ 3 ] {01c8ad9a-0526-4d98-b6ef-730e73b58cc9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
450 2024.10.15 23:29:47.335693 [ 3 ] {01c8ad9a-0526-4d98-b6ef-730e73b58cc9} <Debug> oximeter.measurements_histogrami8 (6066a522-0804-4df2-9e2f-c5b679a699be): Loading data parts
451 2024.10.15 23:29:47.335949 [ 3 ] {01c8ad9a-0526-4d98-b6ef-730e73b58cc9} <Debug> oximeter.measurements_histogrami8 (6066a522-0804-4df2-9e2f-c5b679a699be): There are no data parts
452 2024.10.15 23:29:47.337334 [ 3 ] {01c8ad9a-0526-4d98-b6ef-730e73b58cc9} <Debug> DynamicQueryHandler: Done processing query
453 2024.10.15 23:29:47.337376 [ 3 ] {} <Debug> HTTP-Session: d2d1678a-4fd0-437d-ae53-113cfd2e4781 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
454 2024.10.15 23:29:47.337494 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
455 2024.10.15 23:29:47.337621 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
456 2024.10.15 23:29:47.337653 [ 3 ] {} <Debug> HTTP-Session: c9ca9d5b-4220-491b-a57e-0d64d8eec271 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
457 2024.10.15 23:29:47.337671 [ 3 ] {} <Debug> HTTP-Session: c9ca9d5b-4220-491b-a57e-0d64d8eec271 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
458 2024.10.15 23:29:47.337694 [ 3 ] {} <Debug> HTTP-Session: c9ca9d5b-4220-491b-a57e-0d64d8eec271 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
459 2024.10.15 23:29:47.337736 [ 3 ] {} <Trace> HTTP-Session: c9ca9d5b-4220-491b-a57e-0d64d8eec271 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
460 2024.10.15 23:29:47.337991 [ 3 ] {c8c6af57-f290-43c9-b68a-923c580e4004} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
461 2024.10.15 23:29:47.338070 [ 3 ] {c8c6af57-f290-43c9-b68a-923c580e4004} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
462 2024.10.15 23:29:47.340310 [ 3 ] {c8c6af57-f290-43c9-b68a-923c580e4004} <Debug> oximeter.measurements_histogramu8 (61a66f05-2af6-4c8f-a174-8a0b3e705e68): Loading data parts
463 2024.10.15 23:29:47.340496 [ 3 ] {c8c6af57-f290-43c9-b68a-923c580e4004} <Debug> oximeter.measurements_histogramu8 (61a66f05-2af6-4c8f-a174-8a0b3e705e68): There are no data parts
464 2024.10.15 23:29:47.341954 [ 3 ] {c8c6af57-f290-43c9-b68a-923c580e4004} <Debug> DynamicQueryHandler: Done processing query
465 2024.10.15 23:29:47.341996 [ 3 ] {} <Debug> HTTP-Session: c9ca9d5b-4220-491b-a57e-0d64d8eec271 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
466 2024.10.15 23:29:47.342115 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
467 2024.10.15 23:29:47.342181 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
468 2024.10.15 23:29:47.342212 [ 3 ] {} <Debug> HTTP-Session: 59b519e5-3118-490c-9a16-fd6b2c4b803f Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
469 2024.10.15 23:29:47.342231 [ 3 ] {} <Debug> HTTP-Session: 59b519e5-3118-490c-9a16-fd6b2c4b803f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
470 2024.10.15 23:29:47.342256 [ 3 ] {} <Debug> HTTP-Session: 59b519e5-3118-490c-9a16-fd6b2c4b803f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
471 2024.10.15 23:29:47.342297 [ 3 ] {} <Trace> HTTP-Session: 59b519e5-3118-490c-9a16-fd6b2c4b803f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
472 2024.10.15 23:29:47.342607 [ 3 ] {abcdbef7-099e-4024-8bd6-e1acea5dc3a9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
473 2024.10.15 23:29:47.342695 [ 3 ] {abcdbef7-099e-4024-8bd6-e1acea5dc3a9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
474 2024.10.15 23:29:47.344895 [ 3 ] {abcdbef7-099e-4024-8bd6-e1acea5dc3a9} <Debug> oximeter.measurements_histogrami16 (a24e73db-42c3-474f-94f7-490d85f774b6): Loading data parts
475 2024.10.15 23:29:47.345109 [ 3 ] {abcdbef7-099e-4024-8bd6-e1acea5dc3a9} <Debug> oximeter.measurements_histogrami16 (a24e73db-42c3-474f-94f7-490d85f774b6): There are no data parts
476 2024.10.15 23:29:47.346477 [ 3 ] {abcdbef7-099e-4024-8bd6-e1acea5dc3a9} <Debug> DynamicQueryHandler: Done processing query
477 2024.10.15 23:29:47.346509 [ 3 ] {} <Debug> HTTP-Session: 59b519e5-3118-490c-9a16-fd6b2c4b803f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
478 2024.10.15 23:29:47.346732 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
479 2024.10.15 23:29:47.346796 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
480 2024.10.15 23:29:47.346828 [ 3 ] {} <Debug> HTTP-Session: 1f02a60d-94f2-4b09-8adf-cb20f6304957 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
481 2024.10.15 23:29:47.346846 [ 3 ] {} <Debug> HTTP-Session: 1f02a60d-94f2-4b09-8adf-cb20f6304957 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
482 2024.10.15 23:29:47.346871 [ 3 ] {} <Debug> HTTP-Session: 1f02a60d-94f2-4b09-8adf-cb20f6304957 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
483 2024.10.15 23:29:47.346912 [ 3 ] {} <Trace> HTTP-Session: 1f02a60d-94f2-4b09-8adf-cb20f6304957 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
484 2024.10.15 23:29:47.347153 [ 3 ] {93c618ee-a5c8-4303-aa5c-ca7b8450ca8e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
485 2024.10.15 23:29:47.347235 [ 3 ] {93c618ee-a5c8-4303-aa5c-ca7b8450ca8e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
486 2024.10.15 23:29:47.349416 [ 3 ] {93c618ee-a5c8-4303-aa5c-ca7b8450ca8e} <Debug> oximeter.measurements_histogramu16 (1a85e876-3562-481a-8f59-f6e16900f908): Loading data parts
487 2024.10.15 23:29:47.349668 [ 3 ] {93c618ee-a5c8-4303-aa5c-ca7b8450ca8e} <Debug> oximeter.measurements_histogramu16 (1a85e876-3562-481a-8f59-f6e16900f908): There are no data parts
488 2024.10.15 23:29:47.351088 [ 3 ] {93c618ee-a5c8-4303-aa5c-ca7b8450ca8e} <Debug> DynamicQueryHandler: Done processing query
489 2024.10.15 23:29:47.351135 [ 3 ] {} <Debug> HTTP-Session: 1f02a60d-94f2-4b09-8adf-cb20f6304957 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
490 2024.10.15 23:29:47.351254 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
491 2024.10.15 23:29:47.351321 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
492 2024.10.15 23:29:47.351354 [ 3 ] {} <Debug> HTTP-Session: 536d8b46-de80-4873-8523-adb2afd19c84 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
493 2024.10.15 23:29:47.351374 [ 3 ] {} <Debug> HTTP-Session: 536d8b46-de80-4873-8523-adb2afd19c84 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
494 2024.10.15 23:29:47.351401 [ 3 ] {} <Debug> HTTP-Session: 536d8b46-de80-4873-8523-adb2afd19c84 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
495 2024.10.15 23:29:47.351445 [ 3 ] {} <Trace> HTTP-Session: 536d8b46-de80-4873-8523-adb2afd19c84 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
496 2024.10.15 23:29:47.351762 [ 3 ] {83288011-75c7-4848-92c3-fb1a79b20733} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
497 2024.10.15 23:29:47.351854 [ 3 ] {83288011-75c7-4848-92c3-fb1a79b20733} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
498 2024.10.15 23:29:47.354051 [ 3 ] {83288011-75c7-4848-92c3-fb1a79b20733} <Debug> oximeter.measurements_histogrami32 (3619be29-b2f7-45e7-aed4-e13af80189be): Loading data parts
499 2024.10.15 23:29:47.354262 [ 3 ] {83288011-75c7-4848-92c3-fb1a79b20733} <Debug> oximeter.measurements_histogrami32 (3619be29-b2f7-45e7-aed4-e13af80189be): There are no data parts
500 2024.10.15 23:29:47.355625 [ 3 ] {83288011-75c7-4848-92c3-fb1a79b20733} <Debug> DynamicQueryHandler: Done processing query
501 2024.10.15 23:29:47.355656 [ 3 ] {} <Debug> HTTP-Session: 536d8b46-de80-4873-8523-adb2afd19c84 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
502 2024.10.15 23:29:47.355786 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
503 2024.10.15 23:29:47.355851 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
504 2024.10.15 23:29:47.355886 [ 3 ] {} <Debug> HTTP-Session: df75de79-98d4-4e7c-a961-e689e6904d9e Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
505 2024.10.15 23:29:47.355905 [ 3 ] {} <Debug> HTTP-Session: df75de79-98d4-4e7c-a961-e689e6904d9e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
506 2024.10.15 23:29:47.355933 [ 3 ] {} <Debug> HTTP-Session: df75de79-98d4-4e7c-a961-e689e6904d9e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
507 2024.10.15 23:29:47.355965 [ 3 ] {} <Trace> HTTP-Session: df75de79-98d4-4e7c-a961-e689e6904d9e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
508 2024.10.15 23:29:47.356218 [ 3 ] {b1a9c8ac-39e8-4c88-ba02-88929797b479} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
509 2024.10.15 23:29:47.356301 [ 3 ] {b1a9c8ac-39e8-4c88-ba02-88929797b479} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
510 2024.10.15 23:29:47.358486 [ 3 ] {b1a9c8ac-39e8-4c88-ba02-88929797b479} <Debug> oximeter.measurements_histogramu32 (81a43677-8377-4740-bd5b-0ea180b63df1): Loading data parts
511 2024.10.15 23:29:47.358775 [ 3 ] {b1a9c8ac-39e8-4c88-ba02-88929797b479} <Debug> oximeter.measurements_histogramu32 (81a43677-8377-4740-bd5b-0ea180b63df1): There are no data parts
512 2024.10.15 23:29:47.360204 [ 3 ] {b1a9c8ac-39e8-4c88-ba02-88929797b479} <Debug> DynamicQueryHandler: Done processing query
513 2024.10.15 23:29:47.360254 [ 3 ] {} <Debug> HTTP-Session: df75de79-98d4-4e7c-a961-e689e6904d9e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
514 2024.10.15 23:29:47.360384 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
515 2024.10.15 23:29:47.360459 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
516 2024.10.15 23:29:47.360495 [ 3 ] {} <Debug> HTTP-Session: 206a48bf-df11-456a-b70e-24427a4c114f Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
517 2024.10.15 23:29:47.360517 [ 3 ] {} <Debug> HTTP-Session: 206a48bf-df11-456a-b70e-24427a4c114f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
518 2024.10.15 23:29:47.360546 [ 3 ] {} <Debug> HTTP-Session: 206a48bf-df11-456a-b70e-24427a4c114f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
519 2024.10.15 23:29:47.360663 [ 3 ] {} <Trace> HTTP-Session: 206a48bf-df11-456a-b70e-24427a4c114f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
520 2024.10.15 23:29:47.360962 [ 3 ] {e912dfbd-acd4-4456-8adf-e94b4825a893} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
521 2024.10.15 23:29:47.361049 [ 3 ] {e912dfbd-acd4-4456-8adf-e94b4825a893} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
522 2024.10.15 23:29:47.363258 [ 3 ] {e912dfbd-acd4-4456-8adf-e94b4825a893} <Debug> oximeter.measurements_histogrami64 (29163f54-a824-4a55-92d5-61eba820edb9): Loading data parts
523 2024.10.15 23:29:47.363467 [ 3 ] {e912dfbd-acd4-4456-8adf-e94b4825a893} <Debug> oximeter.measurements_histogrami64 (29163f54-a824-4a55-92d5-61eba820edb9): There are no data parts
524 2024.10.15 23:29:47.364815 [ 3 ] {e912dfbd-acd4-4456-8adf-e94b4825a893} <Debug> DynamicQueryHandler: Done processing query
525 2024.10.15 23:29:47.364845 [ 3 ] {} <Debug> HTTP-Session: 206a48bf-df11-456a-b70e-24427a4c114f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
526 2024.10.15 23:29:47.364990 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
527 2024.10.15 23:29:47.365055 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
528 2024.10.15 23:29:47.365077 [ 3 ] {} <Debug> HTTP-Session: 88dfb5b9-a8d6-44ad-a66d-68bfe0483ae4 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
529 2024.10.15 23:29:47.365107 [ 3 ] {} <Debug> HTTP-Session: 88dfb5b9-a8d6-44ad-a66d-68bfe0483ae4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
530 2024.10.15 23:29:47.365135 [ 3 ] {} <Debug> HTTP-Session: 88dfb5b9-a8d6-44ad-a66d-68bfe0483ae4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
531 2024.10.15 23:29:47.365169 [ 3 ] {} <Trace> HTTP-Session: 88dfb5b9-a8d6-44ad-a66d-68bfe0483ae4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
532 2024.10.15 23:29:47.365431 [ 3 ] {99f95a5c-4d7c-4ee7-ab1e-2a02e0c36c21} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
533 2024.10.15 23:29:47.365515 [ 3 ] {99f95a5c-4d7c-4ee7-ab1e-2a02e0c36c21} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
534 2024.10.15 23:29:47.367692 [ 3 ] {99f95a5c-4d7c-4ee7-ab1e-2a02e0c36c21} <Debug> oximeter.measurements_histogramu64 (fd6665fe-5d8f-410a-951c-5fdaed0488f4): Loading data parts
535 2024.10.15 23:29:47.367880 [ 3 ] {99f95a5c-4d7c-4ee7-ab1e-2a02e0c36c21} <Debug> oximeter.measurements_histogramu64 (fd6665fe-5d8f-410a-951c-5fdaed0488f4): There are no data parts
536 2024.10.15 23:29:47.369207 [ 3 ] {99f95a5c-4d7c-4ee7-ab1e-2a02e0c36c21} <Debug> DynamicQueryHandler: Done processing query
537 2024.10.15 23:29:47.369255 [ 3 ] {} <Debug> HTTP-Session: 88dfb5b9-a8d6-44ad-a66d-68bfe0483ae4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
538 2024.10.15 23:29:47.369376 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
539 2024.10.15 23:29:47.369439 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
540 2024.10.15 23:29:47.369470 [ 3 ] {} <Debug> HTTP-Session: 42ec4028-47de-4485-85bd-72252fdb5e31 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
541 2024.10.15 23:29:47.369487 [ 3 ] {} <Debug> HTTP-Session: 42ec4028-47de-4485-85bd-72252fdb5e31 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
542 2024.10.15 23:29:47.369512 [ 3 ] {} <Debug> HTTP-Session: 42ec4028-47de-4485-85bd-72252fdb5e31 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
543 2024.10.15 23:29:47.369555 [ 3 ] {} <Trace> HTTP-Session: 42ec4028-47de-4485-85bd-72252fdb5e31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
544 2024.10.15 23:29:47.369867 [ 3 ] {309074c5-a268-4305-8c6d-354a5f95f5e3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
545 2024.10.15 23:29:47.369952 [ 3 ] {309074c5-a268-4305-8c6d-354a5f95f5e3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
546 2024.10.15 23:29:47.372232 [ 3 ] {309074c5-a268-4305-8c6d-354a5f95f5e3} <Debug> oximeter.measurements_histogramf32 (020e29c0-f830-4dd4-b525-9466fda5a5ba): Loading data parts
547 2024.10.15 23:29:47.372421 [ 3 ] {309074c5-a268-4305-8c6d-354a5f95f5e3} <Debug> oximeter.measurements_histogramf32 (020e29c0-f830-4dd4-b525-9466fda5a5ba): There are no data parts
548 2024.10.15 23:29:47.373781 [ 3 ] {309074c5-a268-4305-8c6d-354a5f95f5e3} <Debug> DynamicQueryHandler: Done processing query
549 2024.10.15 23:29:47.373810 [ 3 ] {} <Debug> HTTP-Session: 42ec4028-47de-4485-85bd-72252fdb5e31 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
550 2024.10.15 23:29:47.373954 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
551 2024.10.15 23:29:47.374019 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
552 2024.10.15 23:29:47.374052 [ 3 ] {} <Debug> HTTP-Session: 83f99cd8-74c0-4a72-8bf7-533148dd3921 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
553 2024.10.15 23:29:47.374070 [ 3 ] {} <Debug> HTTP-Session: 83f99cd8-74c0-4a72-8bf7-533148dd3921 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
554 2024.10.15 23:29:47.374096 [ 3 ] {} <Debug> HTTP-Session: 83f99cd8-74c0-4a72-8bf7-533148dd3921 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
555 2024.10.15 23:29:47.374130 [ 3 ] {} <Trace> HTTP-Session: 83f99cd8-74c0-4a72-8bf7-533148dd3921 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
556 2024.10.15 23:29:47.374385 [ 3 ] {cb973c54-cce6-4f3e-a510-b6975215dd23} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
557 2024.10.15 23:29:47.374471 [ 3 ] {cb973c54-cce6-4f3e-a510-b6975215dd23} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
558 2024.10.15 23:29:47.376708 [ 3 ] {cb973c54-cce6-4f3e-a510-b6975215dd23} <Debug> oximeter.measurements_histogramf64 (0f83320c-53db-4302-adfe-c725aa443c28): Loading data parts
559 2024.10.15 23:29:47.376912 [ 3 ] {cb973c54-cce6-4f3e-a510-b6975215dd23} <Debug> oximeter.measurements_histogramf64 (0f83320c-53db-4302-adfe-c725aa443c28): There are no data parts
560 2024.10.15 23:29:47.378221 [ 3 ] {cb973c54-cce6-4f3e-a510-b6975215dd23} <Debug> DynamicQueryHandler: Done processing query
561 2024.10.15 23:29:47.378262 [ 3 ] {} <Debug> HTTP-Session: 83f99cd8-74c0-4a72-8bf7-533148dd3921 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
562 2024.10.15 23:29:47.378381 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
563 2024.10.15 23:29:47.378442 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
564 2024.10.15 23:29:47.378475 [ 3 ] {} <Debug> HTTP-Session: 7aaa1736-4e6c-43df-b81a-ea03c617b16f Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
565 2024.10.15 23:29:47.378491 [ 3 ] {} <Debug> HTTP-Session: 7aaa1736-4e6c-43df-b81a-ea03c617b16f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
566 2024.10.15 23:29:47.378518 [ 3 ] {} <Debug> HTTP-Session: 7aaa1736-4e6c-43df-b81a-ea03c617b16f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
567 2024.10.15 23:29:47.378559 [ 3 ] {} <Trace> HTTP-Session: 7aaa1736-4e6c-43df-b81a-ea03c617b16f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
568 2024.10.15 23:29:47.378790 [ 3 ] {c8b18674-ab9f-480d-a12a-5737a52635e8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) /* The field tables store named dimensions of each timeseries.
569 *
570 * As with the measurement tables, there is one field table for each field data
571 * type. Fields are deduplicated by using the "replacing merge tree", though
572 * this behavior **must not** be relied upon for query correctness.
573 *
574 * The index for the fields differs from the measurements, however. Rows are
575 * sorted by timeseries name, then field name, field value, and finally
576 * timeseries key. This reflects the most common pattern for looking them up:
577 * by field name and possibly value, within a timeseries. The resulting keys are
578 * usually then used to look up measurements.
579 *
580 * NOTE: We may want to consider a secondary index on these tables, sorting by
581 * timeseries name and then key, since it would improve lookups where one
582 * already has the key. Realistically though, these tables are quite small and
583 * so performance benefits will be low in absolute terms.
584 *
585 * TTL: We use a materialized column to expire old field table records. This
586 * column is generated automatically by the database whenever a new row is
587 * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *`
588 * query. Since these tables are `ReplacingMergeTree`s, that means the last
589 * record will remain during a deduplication, which will have the last
590 * timestamp. ClickHouse will then expire old data for us, similar to the
591 * measurement tables.
592 */
593 CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
594 2024.10.15 23:29:47.378866 [ 3 ] {c8b18674-ab9f-480d-a12a-5737a52635e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
595 2024.10.15 23:29:47.380898 [ 3 ] {c8b18674-ab9f-480d-a12a-5737a52635e8} <Debug> oximeter.fields_bool (06961237-8cbc-4da3-aef7-82ed44430052): Loading data parts
596 2024.10.15 23:29:47.381121 [ 3 ] {c8b18674-ab9f-480d-a12a-5737a52635e8} <Debug> oximeter.fields_bool (06961237-8cbc-4da3-aef7-82ed44430052): There are no data parts
597 2024.10.15 23:29:47.382350 [ 3 ] {c8b18674-ab9f-480d-a12a-5737a52635e8} <Debug> DynamicQueryHandler: Done processing query
598 2024.10.15 23:29:47.382377 [ 3 ] {} <Debug> HTTP-Session: 7aaa1736-4e6c-43df-b81a-ea03c617b16f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
599 2024.10.15 23:29:47.382502 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
600 2024.10.15 23:29:47.382629 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
601 2024.10.15 23:29:47.382649 [ 3 ] {} <Debug> HTTP-Session: fc288b2f-b824-4aec-9ec2-7a56db984ba7 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
602 2024.10.15 23:29:47.382682 [ 3 ] {} <Debug> HTTP-Session: fc288b2f-b824-4aec-9ec2-7a56db984ba7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
603 2024.10.15 23:29:47.382708 [ 3 ] {} <Debug> HTTP-Session: fc288b2f-b824-4aec-9ec2-7a56db984ba7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
604 2024.10.15 23:29:47.382740 [ 3 ] {} <Trace> HTTP-Session: fc288b2f-b824-4aec-9ec2-7a56db984ba7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
605 2024.10.15 23:29:47.382917 [ 3 ] {593a3c4c-964d-49ad-a625-e46902c0e23f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
606 2024.10.15 23:29:47.382992 [ 3 ] {593a3c4c-964d-49ad-a625-e46902c0e23f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
607 2024.10.15 23:29:47.385025 [ 3 ] {593a3c4c-964d-49ad-a625-e46902c0e23f} <Debug> oximeter.fields_i8 (1288f751-db8e-4704-9fd8-f37ec232794a): Loading data parts
608 2024.10.15 23:29:47.385184 [ 3 ] {593a3c4c-964d-49ad-a625-e46902c0e23f} <Debug> oximeter.fields_i8 (1288f751-db8e-4704-9fd8-f37ec232794a): There are no data parts
609 2024.10.15 23:29:47.386413 [ 3 ] {593a3c4c-964d-49ad-a625-e46902c0e23f} <Debug> DynamicQueryHandler: Done processing query
610 2024.10.15 23:29:47.386440 [ 3 ] {} <Debug> HTTP-Session: fc288b2f-b824-4aec-9ec2-7a56db984ba7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
611 2024.10.15 23:29:47.386629 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
612 2024.10.15 23:29:47.386694 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
613 2024.10.15 23:29:47.386714 [ 3 ] {} <Debug> HTTP-Session: 13e5b9c7-1f88-40a4-8ca8-9f9de556eea7 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
614 2024.10.15 23:29:47.386743 [ 3 ] {} <Debug> HTTP-Session: 13e5b9c7-1f88-40a4-8ca8-9f9de556eea7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
615 2024.10.15 23:29:47.386767 [ 3 ] {} <Debug> HTTP-Session: 13e5b9c7-1f88-40a4-8ca8-9f9de556eea7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
616 2024.10.15 23:29:47.386801 [ 3 ] {} <Trace> HTTP-Session: 13e5b9c7-1f88-40a4-8ca8-9f9de556eea7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
617 2024.10.15 23:29:47.386965 [ 3 ] {74ea921d-3827-40af-a721-adc31609d07c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
618 2024.10.15 23:29:47.387034 [ 3 ] {74ea921d-3827-40af-a721-adc31609d07c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
619 2024.10.15 23:29:47.389130 [ 3 ] {74ea921d-3827-40af-a721-adc31609d07c} <Debug> oximeter.fields_u8 (cf9e06bb-c8d6-4031-a97c-789bd428b6c2): Loading data parts
620 2024.10.15 23:29:47.389331 [ 3 ] {74ea921d-3827-40af-a721-adc31609d07c} <Debug> oximeter.fields_u8 (cf9e06bb-c8d6-4031-a97c-789bd428b6c2): There are no data parts
621 2024.10.15 23:29:47.390629 [ 3 ] {74ea921d-3827-40af-a721-adc31609d07c} <Debug> DynamicQueryHandler: Done processing query
622 2024.10.15 23:29:47.390656 [ 3 ] {} <Debug> HTTP-Session: 13e5b9c7-1f88-40a4-8ca8-9f9de556eea7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
623 2024.10.15 23:29:47.390793 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
624 2024.10.15 23:29:47.390853 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
625 2024.10.15 23:29:47.390873 [ 3 ] {} <Debug> HTTP-Session: e39c2d01-dbc7-4a02-940f-5c79824c8d6e Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
626 2024.10.15 23:29:47.390901 [ 3 ] {} <Debug> HTTP-Session: e39c2d01-dbc7-4a02-940f-5c79824c8d6e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
627 2024.10.15 23:29:47.390920 [ 3 ] {} <Debug> HTTP-Session: e39c2d01-dbc7-4a02-940f-5c79824c8d6e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
628 2024.10.15 23:29:47.390950 [ 3 ] {} <Trace> HTTP-Session: e39c2d01-dbc7-4a02-940f-5c79824c8d6e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
629 2024.10.15 23:29:47.391114 [ 3 ] {2cb7ed7a-374b-4257-a400-91f653cdcfe0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
630 2024.10.15 23:29:47.391172 [ 3 ] {2cb7ed7a-374b-4257-a400-91f653cdcfe0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
631 2024.10.15 23:29:47.393177 [ 3 ] {2cb7ed7a-374b-4257-a400-91f653cdcfe0} <Debug> oximeter.fields_i16 (a9dcf1de-e122-41d6-87c6-7c0979546746): Loading data parts
632 2024.10.15 23:29:47.393349 [ 3 ] {2cb7ed7a-374b-4257-a400-91f653cdcfe0} <Debug> oximeter.fields_i16 (a9dcf1de-e122-41d6-87c6-7c0979546746): There are no data parts
633 2024.10.15 23:29:47.394667 [ 3 ] {2cb7ed7a-374b-4257-a400-91f653cdcfe0} <Debug> DynamicQueryHandler: Done processing query
634 2024.10.15 23:29:47.394693 [ 3 ] {} <Debug> HTTP-Session: e39c2d01-dbc7-4a02-940f-5c79824c8d6e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
635 2024.10.15 23:29:47.394815 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
636 2024.10.15 23:29:47.394873 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
637 2024.10.15 23:29:47.394892 [ 3 ] {} <Debug> HTTP-Session: bdf947ff-5ee0-4fdd-960a-eb2c78061514 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
638 2024.10.15 23:29:47.394916 [ 3 ] {} <Debug> HTTP-Session: bdf947ff-5ee0-4fdd-960a-eb2c78061514 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
639 2024.10.15 23:29:47.394939 [ 3 ] {} <Debug> HTTP-Session: bdf947ff-5ee0-4fdd-960a-eb2c78061514 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
640 2024.10.15 23:29:47.394969 [ 3 ] {} <Trace> HTTP-Session: bdf947ff-5ee0-4fdd-960a-eb2c78061514 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
641 2024.10.15 23:29:47.395125 [ 3 ] {9847c692-807c-4b65-a836-a9c8ef04f659} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
642 2024.10.15 23:29:47.395183 [ 3 ] {9847c692-807c-4b65-a836-a9c8ef04f659} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
643 2024.10.15 23:29:47.397096 [ 3 ] {9847c692-807c-4b65-a836-a9c8ef04f659} <Debug> oximeter.fields_u16 (780b971e-2ddc-4ad7-8553-080d8a25645a): Loading data parts
644 2024.10.15 23:29:47.397309 [ 3 ] {9847c692-807c-4b65-a836-a9c8ef04f659} <Debug> oximeter.fields_u16 (780b971e-2ddc-4ad7-8553-080d8a25645a): There are no data parts
645 2024.10.15 23:29:47.398541 [ 3 ] {9847c692-807c-4b65-a836-a9c8ef04f659} <Debug> DynamicQueryHandler: Done processing query
646 2024.10.15 23:29:47.398569 [ 3 ] {} <Debug> HTTP-Session: bdf947ff-5ee0-4fdd-960a-eb2c78061514 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
647 2024.10.15 23:29:47.398761 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
648 2024.10.15 23:29:47.398824 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
649 2024.10.15 23:29:47.398845 [ 3 ] {} <Debug> HTTP-Session: 35a78d14-1ebe-4a08-9801-06b9be087d9c Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
650 2024.10.15 23:29:47.398871 [ 3 ] {} <Debug> HTTP-Session: 35a78d14-1ebe-4a08-9801-06b9be087d9c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
651 2024.10.15 23:29:47.398896 [ 3 ] {} <Debug> HTTP-Session: 35a78d14-1ebe-4a08-9801-06b9be087d9c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
652 2024.10.15 23:29:47.398929 [ 3 ] {} <Trace> HTTP-Session: 35a78d14-1ebe-4a08-9801-06b9be087d9c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
653 2024.10.15 23:29:47.399103 [ 3 ] {a84edcc6-fb78-4cc2-b65d-197f6ef8521b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
654 2024.10.15 23:29:47.399168 [ 3 ] {a84edcc6-fb78-4cc2-b65d-197f6ef8521b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
655 2024.10.15 23:29:47.401088 [ 3 ] {a84edcc6-fb78-4cc2-b65d-197f6ef8521b} <Debug> oximeter.fields_i32 (81251b51-7e3e-44c2-9a3a-6a6ab90873e8): Loading data parts
656 2024.10.15 23:29:47.401271 [ 3 ] {a84edcc6-fb78-4cc2-b65d-197f6ef8521b} <Debug> oximeter.fields_i32 (81251b51-7e3e-44c2-9a3a-6a6ab90873e8): There are no data parts
657 2024.10.15 23:29:47.402495 [ 3 ] {a84edcc6-fb78-4cc2-b65d-197f6ef8521b} <Debug> DynamicQueryHandler: Done processing query
658 2024.10.15 23:29:47.402533 [ 3 ] {} <Debug> HTTP-Session: 35a78d14-1ebe-4a08-9801-06b9be087d9c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
659 2024.10.15 23:29:47.402712 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
660 2024.10.15 23:29:47.402780 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
661 2024.10.15 23:29:47.402809 [ 3 ] {} <Debug> HTTP-Session: 9b778ee4-f38d-4f39-a43c-af012ad8cae3 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
662 2024.10.15 23:29:47.402828 [ 3 ] {} <Debug> HTTP-Session: 9b778ee4-f38d-4f39-a43c-af012ad8cae3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
663 2024.10.15 23:29:47.402851 [ 3 ] {} <Debug> HTTP-Session: 9b778ee4-f38d-4f39-a43c-af012ad8cae3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
664 2024.10.15 23:29:47.402891 [ 3 ] {} <Trace> HTTP-Session: 9b778ee4-f38d-4f39-a43c-af012ad8cae3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
665 2024.10.15 23:29:47.403052 [ 3 ] {0db1dbd5-2b8b-4631-80c0-c0dfe0d30a59} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
666 2024.10.15 23:29:47.403114 [ 3 ] {0db1dbd5-2b8b-4631-80c0-c0dfe0d30a59} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
667 2024.10.15 23:29:47.404985 [ 3 ] {0db1dbd5-2b8b-4631-80c0-c0dfe0d30a59} <Debug> oximeter.fields_u32 (4dbfca76-8ee1-434f-9783-a23faeac986d): Loading data parts
668 2024.10.15 23:29:47.405159 [ 3 ] {0db1dbd5-2b8b-4631-80c0-c0dfe0d30a59} <Debug> oximeter.fields_u32 (4dbfca76-8ee1-434f-9783-a23faeac986d): There are no data parts
669 2024.10.15 23:29:47.406507 [ 3 ] {0db1dbd5-2b8b-4631-80c0-c0dfe0d30a59} <Debug> DynamicQueryHandler: Done processing query
670 2024.10.15 23:29:47.406540 [ 3 ] {} <Debug> HTTP-Session: 9b778ee4-f38d-4f39-a43c-af012ad8cae3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
671 2024.10.15 23:29:47.406667 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
672 2024.10.15 23:29:47.406724 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
673 2024.10.15 23:29:47.406754 [ 3 ] {} <Debug> HTTP-Session: a1b0a4dd-7dc6-4787-ad3b-7bb7a364c2d5 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
674 2024.10.15 23:29:47.406769 [ 3 ] {} <Debug> HTTP-Session: a1b0a4dd-7dc6-4787-ad3b-7bb7a364c2d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
675 2024.10.15 23:29:47.406791 [ 3 ] {} <Debug> HTTP-Session: a1b0a4dd-7dc6-4787-ad3b-7bb7a364c2d5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
676 2024.10.15 23:29:47.406820 [ 3 ] {} <Trace> HTTP-Session: a1b0a4dd-7dc6-4787-ad3b-7bb7a364c2d5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
677 2024.10.15 23:29:47.406977 [ 3 ] {d766b1f6-67eb-4fe7-ac0e-ff5edaf0d97d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
678 2024.10.15 23:29:47.407036 [ 3 ] {d766b1f6-67eb-4fe7-ac0e-ff5edaf0d97d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
679 2024.10.15 23:29:47.409050 [ 3 ] {d766b1f6-67eb-4fe7-ac0e-ff5edaf0d97d} <Debug> oximeter.fields_i64 (b227f422-363d-4fc4-a6cd-5df7274e87db): Loading data parts
680 2024.10.15 23:29:47.409216 [ 3 ] {d766b1f6-67eb-4fe7-ac0e-ff5edaf0d97d} <Debug> oximeter.fields_i64 (b227f422-363d-4fc4-a6cd-5df7274e87db): There are no data parts
681 2024.10.15 23:29:47.410538 [ 3 ] {d766b1f6-67eb-4fe7-ac0e-ff5edaf0d97d} <Debug> DynamicQueryHandler: Done processing query
682 2024.10.15 23:29:47.410579 [ 3 ] {} <Debug> HTTP-Session: a1b0a4dd-7dc6-4787-ad3b-7bb7a364c2d5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
683 2024.10.15 23:29:47.410689 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
684 2024.10.15 23:29:47.410748 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
685 2024.10.15 23:29:47.410777 [ 3 ] {} <Debug> HTTP-Session: 2620cbea-7cf6-4334-9b62-67d796e44531 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
686 2024.10.15 23:29:47.410795 [ 3 ] {} <Debug> HTTP-Session: 2620cbea-7cf6-4334-9b62-67d796e44531 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
687 2024.10.15 23:29:47.410817 [ 3 ] {} <Debug> HTTP-Session: 2620cbea-7cf6-4334-9b62-67d796e44531 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
688 2024.10.15 23:29:47.410855 [ 3 ] {} <Trace> HTTP-Session: 2620cbea-7cf6-4334-9b62-67d796e44531 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
689 2024.10.15 23:29:47.411009 [ 3 ] {361b9046-8299-4d02-8c26-7153bac96d6b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
690 2024.10.15 23:29:47.411069 [ 3 ] {361b9046-8299-4d02-8c26-7153bac96d6b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
691 2024.10.15 23:29:47.413078 [ 3 ] {361b9046-8299-4d02-8c26-7153bac96d6b} <Debug> oximeter.fields_u64 (2bb6e030-e8bb-4e08-9da6-f68329acdbe3): Loading data parts
692 2024.10.15 23:29:47.413251 [ 3 ] {361b9046-8299-4d02-8c26-7153bac96d6b} <Debug> oximeter.fields_u64 (2bb6e030-e8bb-4e08-9da6-f68329acdbe3): There are no data parts
693 2024.10.15 23:29:47.414559 [ 3 ] {361b9046-8299-4d02-8c26-7153bac96d6b} <Debug> DynamicQueryHandler: Done processing query
694 2024.10.15 23:29:47.414607 [ 3 ] {} <Debug> HTTP-Session: 2620cbea-7cf6-4334-9b62-67d796e44531 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
695 2024.10.15 23:29:47.414717 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
696 2024.10.15 23:29:47.414776 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
697 2024.10.15 23:29:47.414803 [ 3 ] {} <Debug> HTTP-Session: 689bdca9-9f62-4bf0-b41c-6f3b27e5a1a9 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
698 2024.10.15 23:29:47.414821 [ 3 ] {} <Debug> HTTP-Session: 689bdca9-9f62-4bf0-b41c-6f3b27e5a1a9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
699 2024.10.15 23:29:47.414843 [ 3 ] {} <Debug> HTTP-Session: 689bdca9-9f62-4bf0-b41c-6f3b27e5a1a9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
700 2024.10.15 23:29:47.414880 [ 3 ] {} <Trace> HTTP-Session: 689bdca9-9f62-4bf0-b41c-6f3b27e5a1a9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
701 2024.10.15 23:29:47.415041 [ 3 ] {098eb375-ca43-42fc-9769-3f4512730464} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
702 2024.10.15 23:29:47.415097 [ 3 ] {098eb375-ca43-42fc-9769-3f4512730464} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
703 2024.10.15 23:29:47.417115 [ 3 ] {098eb375-ca43-42fc-9769-3f4512730464} <Debug> oximeter.fields_ipaddr (89747164-e198-4820-9237-7d28f7001602): Loading data parts
704 2024.10.15 23:29:47.417302 [ 3 ] {098eb375-ca43-42fc-9769-3f4512730464} <Debug> oximeter.fields_ipaddr (89747164-e198-4820-9237-7d28f7001602): There are no data parts
705 2024.10.15 23:29:47.418518 [ 3 ] {098eb375-ca43-42fc-9769-3f4512730464} <Debug> DynamicQueryHandler: Done processing query
706 2024.10.15 23:29:47.418556 [ 3 ] {} <Debug> HTTP-Session: 689bdca9-9f62-4bf0-b41c-6f3b27e5a1a9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
707 2024.10.15 23:29:47.418735 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
708 2024.10.15 23:29:47.418797 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
709 2024.10.15 23:29:47.418825 [ 3 ] {} <Debug> HTTP-Session: 6cbce9e9-6670-49cd-9763-7227370eb1af Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
710 2024.10.15 23:29:47.418844 [ 3 ] {} <Debug> HTTP-Session: 6cbce9e9-6670-49cd-9763-7227370eb1af Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
711 2024.10.15 23:29:47.418867 [ 3 ] {} <Debug> HTTP-Session: 6cbce9e9-6670-49cd-9763-7227370eb1af Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
712 2024.10.15 23:29:47.418907 [ 3 ] {} <Trace> HTTP-Session: 6cbce9e9-6670-49cd-9763-7227370eb1af Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
713 2024.10.15 23:29:47.419075 [ 3 ] {f200ccd6-2f1b-428c-86b0-064607118648} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
714 2024.10.15 23:29:47.419131 [ 3 ] {f200ccd6-2f1b-428c-86b0-064607118648} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
715 2024.10.15 23:29:47.421150 [ 3 ] {f200ccd6-2f1b-428c-86b0-064607118648} <Debug> oximeter.fields_string (4bf41aac-2450-4f59-988f-f23f8164a004): Loading data parts
716 2024.10.15 23:29:47.421337 [ 3 ] {f200ccd6-2f1b-428c-86b0-064607118648} <Debug> oximeter.fields_string (4bf41aac-2450-4f59-988f-f23f8164a004): There are no data parts
717 2024.10.15 23:29:47.422514 [ 3 ] {f200ccd6-2f1b-428c-86b0-064607118648} <Debug> DynamicQueryHandler: Done processing query
718 2024.10.15 23:29:47.422552 [ 3 ] {} <Debug> HTTP-Session: 6cbce9e9-6670-49cd-9763-7227370eb1af Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
719 2024.10.15 23:29:47.422750 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
720 2024.10.15 23:29:47.422802 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
721 2024.10.15 23:29:47.422834 [ 3 ] {} <Debug> HTTP-Session: d0379da9-a685-42b5-b456-eb90838da655 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
722 2024.10.15 23:29:47.422860 [ 3 ] {} <Debug> HTTP-Session: d0379da9-a685-42b5-b456-eb90838da655 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
723 2024.10.15 23:29:47.422877 [ 3 ] {} <Debug> HTTP-Session: d0379da9-a685-42b5-b456-eb90838da655 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
724 2024.10.15 23:29:47.422917 [ 3 ] {} <Trace> HTTP-Session: d0379da9-a685-42b5-b456-eb90838da655 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
725 2024.10.15 23:29:47.423088 [ 3 ] {21182f96-72ad-454c-b5fa-ba10899264ea} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete)
726 2024.10.15 23:29:47.423153 [ 3 ] {21182f96-72ad-454c-b5fa-ba10899264ea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
727 2024.10.15 23:29:47.425110 [ 3 ] {21182f96-72ad-454c-b5fa-ba10899264ea} <Debug> oximeter.fields_uuid (9d6f6431-5d9a-43d0-9ee1-54a46323ef79): Loading data parts
728 2024.10.15 23:29:47.425296 [ 3 ] {21182f96-72ad-454c-b5fa-ba10899264ea} <Debug> oximeter.fields_uuid (9d6f6431-5d9a-43d0-9ee1-54a46323ef79): There are no data parts
729 2024.10.15 23:29:47.426634 [ 3 ] {21182f96-72ad-454c-b5fa-ba10899264ea} <Debug> DynamicQueryHandler: Done processing query
730 2024.10.15 23:29:47.426666 [ 3 ] {} <Debug> HTTP-Session: d0379da9-a685-42b5-b456-eb90838da655 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
731 2024.10.15 23:29:47.426778 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
732 2024.10.15 23:29:47.426843 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
733 2024.10.15 23:29:47.426865 [ 3 ] {} <Debug> HTTP-Session: bfae22ce-7a92-4fc9-a476-159f8a1a07ab Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
734 2024.10.15 23:29:47.426890 [ 3 ] {} <Debug> HTTP-Session: bfae22ce-7a92-4fc9-a476-159f8a1a07ab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
735 2024.10.15 23:29:47.426905 [ 3 ] {} <Debug> HTTP-Session: bfae22ce-7a92-4fc9-a476-159f8a1a07ab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
736 2024.10.15 23:29:47.426943 [ 3 ] {} <Trace> HTTP-Session: bfae22ce-7a92-4fc9-a476-159f8a1a07ab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
737 2024.10.15 23:29:47.427147 [ 3 ] {02ae1baa-636c-4d97-ac4a-f648fd2fb1d0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) /* The timeseries schema table stores the extracted schema for the samples
738 * oximeter collects.
739 */
740 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)
741 2024.10.15 23:29:47.427243 [ 3 ] {02ae1baa-636c-4d97-ac4a-f648fd2fb1d0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
742 2024.10.15 23:29:47.429070 [ 3 ] {02ae1baa-636c-4d97-ac4a-f648fd2fb1d0} <Debug> oximeter.timeseries_schema (7d550a86-6192-4785-93e7-45828ebf5bc5): Loading data parts
743 2024.10.15 23:29:47.429287 [ 3 ] {02ae1baa-636c-4d97-ac4a-f648fd2fb1d0} <Debug> oximeter.timeseries_schema (7d550a86-6192-4785-93e7-45828ebf5bc5): There are no data parts
744 2024.10.15 23:29:47.430672 [ 3 ] {02ae1baa-636c-4d97-ac4a-f648fd2fb1d0} <Debug> DynamicQueryHandler: Done processing query
745 2024.10.15 23:29:47.430711 [ 3 ] {} <Debug> HTTP-Session: bfae22ce-7a92-4fc9-a476-159f8a1a07ab Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
746 2024.10.15 23:29:47.430827 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
747 2024.10.15 23:29:47.430878 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0
748 2024.10.15 23:29:47.430905 [ 3 ] {} <Debug> HTTP-Session: 847af239-6312-4e97-b67f-c655440e04a4 Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
749 2024.10.15 23:29:47.430924 [ 3 ] {} <Debug> HTTP-Session: 847af239-6312-4e97-b67f-c655440e04a4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
750 2024.10.15 23:29:47.430939 [ 3 ] {} <Debug> HTTP-Session: 847af239-6312-4e97-b67f-c655440e04a4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
751 2024.10.15 23:29:47.430981 [ 3 ] {} <Trace> HTTP-Session: 847af239-6312-4e97-b67f-c655440e04a4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
752 2024.10.15 23:29:47.431126 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
753 2024.10.15 23:29:47.433100 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
754 2024.10.15 23:29:47.439607 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Trace> oximeter.version (b05a19ef-8dd5-424a-8a53-68f0b504aa8b): Trying to reserve 1.00 MiB using storage policy from min volume index 0
755 2024.10.15 23:29:47.439651 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.97 GiB.
756 2024.10.15 23:29:47.444828 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
757 2024.10.15 23:29:47.446073 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Trace> oximeter.version (b05a19ef-8dd5-424a-8a53-68f0b504aa8b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
758 2024.10.15 23:29:47.446387 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.01531 sec., 65.31678641410842 rows/sec., 1.02 KiB/sec.
759 2024.10.15 23:29:47.446529 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Debug> DynamicQueryHandler: Done processing query
760 2024.10.15 23:29:47.446554 [ 3 ] {4bba94ed-71c3-48bb-b3e6-0d7908e979f7} <Debug> MemoryTracker: Peak memory usage (for query): 4.26 MiB.
761 2024.10.15 23:29:47.446570 [ 3 ] {} <Debug> HTTP-Session: 847af239-6312-4e97-b67f-c655440e04a4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
762 2024.10.15 23:29:47.446922 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
763 2024.10.15 23:29:47.446976 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
764 2024.10.15 23:29:47.446997 [ 3 ] {} <Debug> HTTP-Session: aeb05225-2d98-4aa0-a994-13e4f95c9bce Authenticating user 'default' from [fd00:1122:3344:101::d]:33953
765 2024.10.15 23:29:47.447015 [ 3 ] {} <Debug> HTTP-Session: aeb05225-2d98-4aa0-a994-13e4f95c9bce Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
766 2024.10.15 23:29:47.447031 [ 3 ] {} <Debug> HTTP-Session: aeb05225-2d98-4aa0-a994-13e4f95c9bce Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
767 2024.10.15 23:29:47.447067 [ 3 ] {} <Trace> HTTP-Session: aeb05225-2d98-4aa0-a994-13e4f95c9bce Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
768 2024.10.15 23:29:47.447252 [ 3 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33953) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
769 2024.10.15 23:29:47.447567 [ 3 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Trace> ContextAccess (default): Access granted: SELECT(value) ON oximeter.version
770 2024.10.15 23:29:47.447966 [ 3 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
771 2024.10.15 23:29:47.449997 [ 3 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Debug> oximeter.version (b05a19ef-8dd5-424a-8a53-68f0b504aa8b) (SelectExecutor): Key condition: unknown
772 2024.10.15 23:29:47.456910 [ 255 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Trace> AggregatingTransform: Aggregating
773 2024.10.15 23:29:47.457021 [ 255 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Trace> Aggregator: Aggregation method: without_key
774 2024.10.15 23:29:47.457823 [ 255 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Trace> AggregatingTransform: Aggregated. 1 to 1 rows (from 40.00 B) in 0.004555216 sec. (219.529 rows/sec., 8.58 KiB/sec.)
775 2024.10.15 23:29:47.457857 [ 255 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Trace> Aggregator: Merging aggregated data
776 2024.10.15 23:29:47.457891 [ 255 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Trace> Aggregator: Statistics updated for key=4896758355805104663: new sum_of_sizes=1, median_size=1
777 2024.10.15 23:29:47.459819 [ 3 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Debug> executeQuery: Read 1 rows, 40.00 B in 0.012577 sec., 79.51021706289258 rows/sec., 3.11 KiB/sec.
778 2024.10.15 23:29:47.460945 [ 3 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Debug> DynamicQueryHandler: Done processing query
779 2024.10.15 23:29:47.460976 [ 3 ] {cb83261e-eb04-4bc9-960c-ebf09dd4151d} <Debug> MemoryTracker: Peak memory usage (for query): 4.02 MiB.
780 2024.10.15 23:29:47.460999 [ 3 ] {} <Debug> HTTP-Session: aeb05225-2d98-4aa0-a994-13e4f95c9bce Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
781 2024.10.15 23:29:47.461311 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:33953, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
782 2024.10.15 23:29:48.000736 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 160.98 MiB, peak 165.96 MiB, free memory in arenas 0.00 B, will set to 175.48 MiB (RSS), difference: 14.49 MiB
783 2024.10.15 23:30:01.629037 [ 149 ] {} <Debug> DNSResolver: Updating DNS cache
784 2024.10.15 23:30:01.629099 [ 149 ] {} <Debug> DNSResolver: Updated DNS cache