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 |