1 | 2024.10.09 22:35:32.650638 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 12956 | ||
2 | 2024.10.09 22:35:32.650825 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.10.09 22:35:32.650914 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.10.09 22:35:32.672511 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.10.09 22:35:32.677881 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.10.09 22:35:32.677929 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.10.09 22:35:32.677944 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.10.09 22:35:32.678014 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_region_replacement_start_saga.12949.1-clickhouse-Qp2B1l/datastore/tmp/ to store temporary data in it | ||
9 | 2024.10.09 22:35:32.678625 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.10.09 22:35:32.681346 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
11 | 2024.10.09 22:35:32.683339 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
12 | 2024.10.09 22:35:32.683987 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 28.18 GiB (31.32 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
13 | 2024.10.09 22:35:32.684016 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.66 GiB (31.32 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
14 | 2024.10.09 22:35:32.684037 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.10.09 22:35:32.684225 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.10.09 22:35:32.685244 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.10.09 22:35:32.718577 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.10.09 22:35:32.719576 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.10.09 22:35:32.722015 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
20 | 2024.10.09 22:35:32.722073 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
21 | 2024.10.09 22:35:32.723250 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
22 | 2024.10.09 22:35:32.723685 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
23 | 2024.10.09 22:35:32.725522 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
24 | 2024.10.09 22:35:32.726149 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
25 | 2024.10.09 22:35:32.727217 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
26 | 2024.10.09 22:35:32.727591 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.10.09 22:35:32.727917 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.10.09 22:35:32.728564 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
29 | 2024.10.09 22:35:32.774755 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.10.09 22:35:32.774798 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_region_replacement_start_saga.12949.1-clickhouse-Qp2B1l/datastore/ | ||
31 | 2024.10.09 22:35:32.777005 [ 212 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.10.09 22:35:32.777408 [ 212 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.10.09 22:35:32.798664 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.10.09 22:35:32.798705 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00064121 sec | ||
35 | 2024.10.09 22:35:32.798744 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.10.09 22:35:32.798758 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.10.09 22:35:32.800386 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.10.09 22:35:32.800463 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
39 | 2024.10.09 22:35:32.800485 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
40 | 2024.10.09 22:35:32.801871 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.10.09 22:35:32.801964 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.10.09 22:35:32.801990 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.10.09 22:35:32.802028 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.10.09 22:35:32.802044 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
45 | 2024.10.09 22:35:32.802064 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2024.10.09 22:35:32.802099 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
47 | 2024.10.09 22:35:32.802116 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
48 | 2024.10.09 22:35:32.802135 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2024.10.09 22:35:32.802204 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2024.10.09 22:35:32.802240 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.10.09 22:35:32.802259 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.10.09 22:35:32.802274 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2024.10.09 22:35:32.802304 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2024.10.09 22:35:32.802325 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2024.10.09 22:35:32.881424 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.10.09 22:35:32.886881 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.10.09 22:35:32.886924 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.5186e-05 sec | ||
58 | 2024.10.09 22:35:32.886948 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.10.09 22:35:32.886958 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.10.09 22:35:32.886993 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.10.09 22:35:32.887758 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_region_replacement_start_saga.12949.1-clickhouse-Qp2B1l/datastore/user_defined/ | ||
62 | 2024.10.09 22:35:32.887851 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.10.09 22:35:32.887869 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.10.09 22:35:32.887880 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
65 | 2024.10.09 22:35:32.887896 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.10.09 22:35:32.888152 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 63190 | ||
67 | 2024.10.09 22:35:32.888363 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41014 | ||
68 | 2024.10.09 22:35:32.891217 [ 1 ] {} <Warning> Application: Listen [::1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: [::1]:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host> | ||
69 | 2024.10.09 22:35:32.891518 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40701 | ||
70 | 2024.10.09 22:35:32.891612 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 61752 | ||
71 | 2024.10.09 22:35:32.891706 [ 1 ] {} <Warning> Application: Listen [127.0.0.1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: 127.0.0.1:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host> | ||
72 | 2024.10.09 22:35:32.891772 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
73 | 2024.10.09 22:35:32.892051 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.90 MiB, peak 15.49 MiB, free memory in arenas 0.00 B, will set to 139.55 MiB (RSS), difference: 129.65 MiB | ||
74 | 2024.10.09 22:35:32.892640 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.3488e-05 sec. | ||
75 | 2024.10.09 22:35:32.893135 [ 1 ] {} <Information> Application: Listening for http://[::1]:63190 | ||
76 | 2024.10.09 22:35:32.893209 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:41014 | ||
77 | 2024.10.09 22:35:32.893267 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:40701 | ||
78 | 2024.10.09 22:35:32.893325 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:61752 | ||
79 | 2024.10.09 22:35:32.893338 [ 1 ] {} <Information> Application: Ready for connections. | ||
80 | 2024.10.09 22:35:42.700612 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
81 | 2024.10.09 22:35:42.700849 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
82 | 2024.10.09 22:35:42.700897 [ 3 ] {} <Debug> HTTP-Session: 6245453c-b03d-4fbf-8281-1ac63fa7162e Authenticating user 'default' from [::1]:54509 | ||
83 | 2024.10.09 22:35:42.700929 [ 3 ] {} <Debug> HTTP-Session: 6245453c-b03d-4fbf-8281-1ac63fa7162e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2024.10.09 22:35:42.700948 [ 3 ] {} <Debug> HTTP-Session: 6245453c-b03d-4fbf-8281-1ac63fa7162e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
85 | 2024.10.09 22:35:42.701058 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
86 | 2024.10.09 22:35:42.701107 [ 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 | ||
87 | 2024.10.09 22:35:42.701136 [ 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 | ||
88 | 2024.10.09 22:35:42.701208 [ 3 ] {} <Trace> HTTP-Session: 6245453c-b03d-4fbf-8281-1ac63fa7162e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
89 | 2024.10.09 22:35:42.701817 [ 3 ] {cb3f3f14-1b1c-451e-8ee4-73f5488d128e} <Debug> executeQuery: (from [::1]:54509) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
90 | 2024.10.09 22:35:42.711213 [ 3 ] {cb3f3f14-1b1c-451e-8ee4-73f5488d128e} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:54509) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
91 | |||
92 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
93 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
94 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
95 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
96 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
97 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
98 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
99 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
100 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
101 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
102 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
103 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
104 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
105 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
106 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
107 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
108 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
109 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
110 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
111 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
112 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
113 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
114 | |||
115 | 2024.10.09 22:35:42.711534 [ 3 ] {cb3f3f14-1b1c-451e-8ee4-73f5488d128e} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
116 | |||
117 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
118 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
119 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
120 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
121 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
122 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
123 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
124 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
125 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
126 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
127 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
128 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
129 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
130 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
131 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
132 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
133 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
134 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
135 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
136 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
137 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
138 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
139 | (version 23.8.7.1) | ||
140 | 2024.10.09 22:35:42.711863 [ 3 ] {} <Debug> HTTP-Session: 6245453c-b03d-4fbf-8281-1ac63fa7162e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
141 | 2024.10.09 22:35:42.714492 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
142 | 2024.10.09 22:35:42.714591 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
143 | 2024.10.09 22:35:42.714654 [ 3 ] {} <Debug> HTTP-Session: c5c55072-db12-4db8-a517-e9eb7650e94c Authenticating user 'default' from [::1]:54509 | ||
144 | 2024.10.09 22:35:42.714696 [ 3 ] {} <Debug> HTTP-Session: c5c55072-db12-4db8-a517-e9eb7650e94c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
145 | 2024.10.09 22:35:42.714714 [ 3 ] {} <Debug> HTTP-Session: c5c55072-db12-4db8-a517-e9eb7650e94c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2024.10.09 22:35:42.714773 [ 3 ] {} <Trace> HTTP-Session: c5c55072-db12-4db8-a517-e9eb7650e94c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
147 | 2024.10.09 22:35:42.715021 [ 3 ] {a4361c85-ec69-42ab-b9f8-0968e89d0e87} <Debug> executeQuery: (from [::1]:54509) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
148 | 2024.10.09 22:35:42.715429 [ 3 ] {a4361c85-ec69-42ab-b9f8-0968e89d0e87} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:54509) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
149 | |||
150 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
151 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
152 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
153 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
154 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
155 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
156 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
157 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
158 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
159 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
160 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
161 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
162 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
163 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
164 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
165 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
166 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
167 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
168 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
169 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
170 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
171 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
172 | |||
173 | 2024.10.09 22:35:42.715603 [ 3 ] {a4361c85-ec69-42ab-b9f8-0968e89d0e87} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
174 | |||
175 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
176 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
177 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
178 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
179 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
180 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
181 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
182 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
183 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
184 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
185 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
186 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
187 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
188 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
189 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
190 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
191 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
192 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
193 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
197 | (version 23.8.7.1) | ||
198 | 2024.10.09 22:35:42.715828 [ 3 ] {} <Debug> HTTP-Session: c5c55072-db12-4db8-a517-e9eb7650e94c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
199 | 2024.10.09 22:35:42.807016 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
200 | 2024.10.09 22:35:42.807144 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
201 | 2024.10.09 22:35:42.807179 [ 3 ] {} <Debug> HTTP-Session: 08d65ad2-0f00-4a73-98df-6421fd2bf1ed Authenticating user 'default' from [::1]:54509 | ||
202 | 2024.10.09 22:35:42.807225 [ 3 ] {} <Debug> HTTP-Session: 08d65ad2-0f00-4a73-98df-6421fd2bf1ed Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
203 | 2024.10.09 22:35:42.807241 [ 3 ] {} <Debug> HTTP-Session: 08d65ad2-0f00-4a73-98df-6421fd2bf1ed Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
204 | 2024.10.09 22:35:42.807299 [ 3 ] {} <Trace> HTTP-Session: 08d65ad2-0f00-4a73-98df-6421fd2bf1ed Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
205 | 2024.10.09 22:35:42.807635 [ 3 ] {dbf08291-bb6b-41a4-9582-1ea0c85692bc} <Debug> executeQuery: (from [::1]:54509) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
206 | 2024.10.09 22:35:42.808029 [ 3 ] {dbf08291-bb6b-41a4-9582-1ea0c85692bc} <Debug> DynamicQueryHandler: Done processing query | ||
207 | 2024.10.09 22:35:42.808062 [ 3 ] {} <Debug> HTTP-Session: 08d65ad2-0f00-4a73-98df-6421fd2bf1ed Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
208 | 2024.10.09 22:35:42.811235 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
209 | 2024.10.09 22:35:42.811341 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
210 | 2024.10.09 22:35:42.811371 [ 3 ] {} <Debug> HTTP-Session: e0a0efac-329c-4628-a9b1-53b78929585e Authenticating user 'default' from [::1]:54509 | ||
211 | 2024.10.09 22:35:42.811406 [ 3 ] {} <Debug> HTTP-Session: e0a0efac-329c-4628-a9b1-53b78929585e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
212 | 2024.10.09 22:35:42.811422 [ 3 ] {} <Debug> HTTP-Session: e0a0efac-329c-4628-a9b1-53b78929585e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
213 | 2024.10.09 22:35:42.811470 [ 3 ] {} <Trace> HTTP-Session: e0a0efac-329c-4628-a9b1-53b78929585e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
214 | 2024.10.09 22:35:42.811621 [ 3 ] {5fe6d343-db04-46c4-ae02-28cd1ff9856e} <Debug> executeQuery: (from [::1]:54509) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
215 | 2024.10.09 22:35:42.811704 [ 3 ] {5fe6d343-db04-46c4-ae02-28cd1ff9856e} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
216 | 2024.10.09 22:35:42.813186 [ 3 ] {5fe6d343-db04-46c4-ae02-28cd1ff9856e} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
217 | 2024.10.09 22:35:42.813221 [ 3 ] {5fe6d343-db04-46c4-ae02-28cd1ff9856e} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.3976e-05 sec | ||
218 | 2024.10.09 22:35:42.813237 [ 3 ] {5fe6d343-db04-46c4-ae02-28cd1ff9856e} <Trace> ReferentialDeps: No tables | ||
219 | 2024.10.09 22:35:42.813249 [ 3 ] {5fe6d343-db04-46c4-ae02-28cd1ff9856e} <Trace> LoadingDeps: No tables | ||
220 | 2024.10.09 22:35:42.813280 [ 3 ] {5fe6d343-db04-46c4-ae02-28cd1ff9856e} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
221 | 2024.10.09 22:35:42.813449 [ 3 ] {5fe6d343-db04-46c4-ae02-28cd1ff9856e} <Debug> DynamicQueryHandler: Done processing query | ||
222 | 2024.10.09 22:35:42.813473 [ 3 ] {} <Debug> HTTP-Session: e0a0efac-329c-4628-a9b1-53b78929585e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
223 | 2024.10.09 22:35:42.816115 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
224 | 2024.10.09 22:35:42.816260 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
225 | 2024.10.09 22:35:42.816299 [ 3 ] {} <Debug> HTTP-Session: fa0c798d-ee01-406c-bbb1-9a92da97699e Authenticating user 'default' from [::1]:54509 | ||
226 | 2024.10.09 22:35:42.816324 [ 3 ] {} <Debug> HTTP-Session: fa0c798d-ee01-406c-bbb1-9a92da97699e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
227 | 2024.10.09 22:35:42.816349 [ 3 ] {} <Debug> HTTP-Session: fa0c798d-ee01-406c-bbb1-9a92da97699e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
228 | 2024.10.09 22:35:42.816406 [ 3 ] {} <Trace> HTTP-Session: fa0c798d-ee01-406c-bbb1-9a92da97699e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
229 | 2024.10.09 22:35:42.816753 [ 3 ] {16cbbe9d-2bab-4a99-8ba2-a0544d8ac270} <Debug> executeQuery: (from [::1]:54509) /* The version table contains metadata about the `oximeter` database */ | ||
230 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
231 | 2024.10.09 22:35:42.816848 [ 3 ] {16cbbe9d-2bab-4a99-8ba2-a0544d8ac270} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
232 | 2024.10.09 22:35:42.818848 [ 3 ] {16cbbe9d-2bab-4a99-8ba2-a0544d8ac270} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
233 | 2024.10.09 22:35:42.820228 [ 3 ] {16cbbe9d-2bab-4a99-8ba2-a0544d8ac270} <Debug> oximeter.version (f6df3b01-420e-4572-a8cb-7abea5814f98): Loading data parts | ||
234 | 2024.10.09 22:35:42.821052 [ 3 ] {16cbbe9d-2bab-4a99-8ba2-a0544d8ac270} <Debug> oximeter.version (f6df3b01-420e-4572-a8cb-7abea5814f98): There are no data parts | ||
235 | 2024.10.09 22:35:42.823393 [ 3 ] {16cbbe9d-2bab-4a99-8ba2-a0544d8ac270} <Debug> DynamicQueryHandler: Done processing query | ||
236 | 2024.10.09 22:35:42.823444 [ 3 ] {} <Debug> HTTP-Session: fa0c798d-ee01-406c-bbb1-9a92da97699e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
237 | 2024.10.09 22:35:42.834120 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
238 | 2024.10.09 22:35:42.834247 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
239 | 2024.10.09 22:35:42.834294 [ 3 ] {} <Debug> HTTP-Session: 88c16766-da1e-44f6-9739-6948d1a76110 Authenticating user 'default' from [::1]:54509 | ||
240 | 2024.10.09 22:35:42.834323 [ 3 ] {} <Debug> HTTP-Session: 88c16766-da1e-44f6-9739-6948d1a76110 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
241 | 2024.10.09 22:35:42.834340 [ 3 ] {} <Debug> HTTP-Session: 88c16766-da1e-44f6-9739-6948d1a76110 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
242 | 2024.10.09 22:35:42.834404 [ 3 ] {} <Trace> HTTP-Session: 88c16766-da1e-44f6-9739-6948d1a76110 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
243 | 2024.10.09 22:35:42.834840 [ 3 ] {43dfcd07-7b85-4361-ace5-58291f4bb20c} <Debug> executeQuery: (from [::1]:54509) /* The measurement tables contain all individual samples from each timeseries. | ||
244 | * | ||
245 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
246 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
247 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
248 | * by all samples from the same timeseries. | ||
249 | * | ||
250 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
251 | * and then uses that to index quickly into the measurements tables. | ||
252 | */ | ||
253 | 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) | ||
254 | 2024.10.09 22:35:42.834926 [ 3 ] {43dfcd07-7b85-4361-ace5-58291f4bb20c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
255 | 2024.10.09 22:35:42.837584 [ 3 ] {43dfcd07-7b85-4361-ace5-58291f4bb20c} <Debug> oximeter.measurements_bool (45fe0073-c228-4d5a-b496-259746b76453): Loading data parts | ||
256 | 2024.10.09 22:35:42.837974 [ 3 ] {43dfcd07-7b85-4361-ace5-58291f4bb20c} <Debug> oximeter.measurements_bool (45fe0073-c228-4d5a-b496-259746b76453): There are no data parts | ||
257 | 2024.10.09 22:35:42.839865 [ 3 ] {43dfcd07-7b85-4361-ace5-58291f4bb20c} <Debug> DynamicQueryHandler: Done processing query | ||
258 | 2024.10.09 22:35:42.839895 [ 3 ] {} <Debug> HTTP-Session: 88c16766-da1e-44f6-9739-6948d1a76110 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
259 | 2024.10.09 22:35:42.841355 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
260 | 2024.10.09 22:35:42.841437 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
261 | 2024.10.09 22:35:42.841463 [ 3 ] {} <Debug> HTTP-Session: 632a1db6-f4d6-4f67-bb81-a4e5bbb49a40 Authenticating user 'default' from [::1]:54509 | ||
262 | 2024.10.09 22:35:42.841487 [ 3 ] {} <Debug> HTTP-Session: 632a1db6-f4d6-4f67-bb81-a4e5bbb49a40 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
263 | 2024.10.09 22:35:42.841509 [ 3 ] {} <Debug> HTTP-Session: 632a1db6-f4d6-4f67-bb81-a4e5bbb49a40 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
264 | 2024.10.09 22:35:42.841557 [ 3 ] {} <Trace> HTTP-Session: 632a1db6-f4d6-4f67-bb81-a4e5bbb49a40 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
265 | 2024.10.09 22:35:42.841961 [ 3 ] {d513eb45-8dc9-462b-accf-53ad3654d54a} <Debug> executeQuery: (from [::1]:54509) 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) | ||
266 | 2024.10.09 22:35:42.842039 [ 3 ] {d513eb45-8dc9-462b-accf-53ad3654d54a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
267 | 2024.10.09 22:35:42.844443 [ 3 ] {d513eb45-8dc9-462b-accf-53ad3654d54a} <Debug> oximeter.measurements_i8 (954ac5ca-d800-43d9-a6ac-fe247d1f9eff): Loading data parts | ||
268 | 2024.10.09 22:35:42.844766 [ 3 ] {d513eb45-8dc9-462b-accf-53ad3654d54a} <Debug> oximeter.measurements_i8 (954ac5ca-d800-43d9-a6ac-fe247d1f9eff): There are no data parts | ||
269 | 2024.10.09 22:35:42.846848 [ 3 ] {d513eb45-8dc9-462b-accf-53ad3654d54a} <Debug> DynamicQueryHandler: Done processing query | ||
270 | 2024.10.09 22:35:42.846884 [ 3 ] {} <Debug> HTTP-Session: 632a1db6-f4d6-4f67-bb81-a4e5bbb49a40 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
271 | 2024.10.09 22:35:42.848639 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
272 | 2024.10.09 22:35:42.848718 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
273 | 2024.10.09 22:35:42.848754 [ 3 ] {} <Debug> HTTP-Session: bcf0b4ac-1993-4e1d-974a-306db2a9b280 Authenticating user 'default' from [::1]:54509 | ||
274 | 2024.10.09 22:35:42.848781 [ 3 ] {} <Debug> HTTP-Session: bcf0b4ac-1993-4e1d-974a-306db2a9b280 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
275 | 2024.10.09 22:35:42.848796 [ 3 ] {} <Debug> HTTP-Session: bcf0b4ac-1993-4e1d-974a-306db2a9b280 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
276 | 2024.10.09 22:35:42.848847 [ 3 ] {} <Trace> HTTP-Session: bcf0b4ac-1993-4e1d-974a-306db2a9b280 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
277 | 2024.10.09 22:35:42.849376 [ 3 ] {66907af0-9aa2-46a8-8f45-c5777e9661a0} <Debug> executeQuery: (from [::1]:54509) 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) | ||
278 | 2024.10.09 22:35:42.849459 [ 3 ] {66907af0-9aa2-46a8-8f45-c5777e9661a0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
279 | 2024.10.09 22:35:42.852918 [ 3 ] {66907af0-9aa2-46a8-8f45-c5777e9661a0} <Debug> oximeter.measurements_u8 (512eb51c-2499-41e5-8383-b9e50c508009): Loading data parts | ||
280 | 2024.10.09 22:35:42.853193 [ 3 ] {66907af0-9aa2-46a8-8f45-c5777e9661a0} <Debug> oximeter.measurements_u8 (512eb51c-2499-41e5-8383-b9e50c508009): There are no data parts | ||
281 | 2024.10.09 22:35:42.855048 [ 3 ] {66907af0-9aa2-46a8-8f45-c5777e9661a0} <Debug> DynamicQueryHandler: Done processing query | ||
282 | 2024.10.09 22:35:42.855078 [ 3 ] {} <Debug> HTTP-Session: bcf0b4ac-1993-4e1d-974a-306db2a9b280 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
283 | 2024.10.09 22:35:42.859007 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
284 | 2024.10.09 22:35:42.859128 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
285 | 2024.10.09 22:35:42.859156 [ 3 ] {} <Debug> HTTP-Session: a40b4d45-b0e2-4a89-a110-31c265585ffd Authenticating user 'default' from [::1]:54509 | ||
286 | 2024.10.09 22:35:42.859183 [ 3 ] {} <Debug> HTTP-Session: a40b4d45-b0e2-4a89-a110-31c265585ffd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
287 | 2024.10.09 22:35:42.859291 [ 3 ] {} <Debug> HTTP-Session: a40b4d45-b0e2-4a89-a110-31c265585ffd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
288 | 2024.10.09 22:35:42.859358 [ 3 ] {} <Trace> HTTP-Session: a40b4d45-b0e2-4a89-a110-31c265585ffd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
289 | 2024.10.09 22:35:42.859760 [ 3 ] {f15b1da7-61e8-435a-84bd-67c3347da44c} <Debug> executeQuery: (from [::1]:54509) 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) | ||
290 | 2024.10.09 22:35:42.859843 [ 3 ] {f15b1da7-61e8-435a-84bd-67c3347da44c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
291 | 2024.10.09 22:35:42.862485 [ 3 ] {f15b1da7-61e8-435a-84bd-67c3347da44c} <Debug> oximeter.measurements_i16 (2c97ff76-8fbb-4a7b-ade0-010ca594c3e1): Loading data parts | ||
292 | 2024.10.09 22:35:42.862851 [ 3 ] {f15b1da7-61e8-435a-84bd-67c3347da44c} <Debug> oximeter.measurements_i16 (2c97ff76-8fbb-4a7b-ade0-010ca594c3e1): There are no data parts | ||
293 | 2024.10.09 22:35:42.866719 [ 3 ] {f15b1da7-61e8-435a-84bd-67c3347da44c} <Debug> DynamicQueryHandler: Done processing query | ||
294 | 2024.10.09 22:35:42.867170 [ 3 ] {} <Debug> HTTP-Session: a40b4d45-b0e2-4a89-a110-31c265585ffd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
295 | 2024.10.09 22:35:42.868580 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
296 | 2024.10.09 22:35:42.868658 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
297 | 2024.10.09 22:35:42.868682 [ 3 ] {} <Debug> HTTP-Session: 3b6910e4-fa26-4944-9460-8f7d2c7a4851 Authenticating user 'default' from [::1]:54509 | ||
298 | 2024.10.09 22:35:42.868718 [ 3 ] {} <Debug> HTTP-Session: 3b6910e4-fa26-4944-9460-8f7d2c7a4851 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
299 | 2024.10.09 22:35:42.868733 [ 3 ] {} <Debug> HTTP-Session: 3b6910e4-fa26-4944-9460-8f7d2c7a4851 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
300 | 2024.10.09 22:35:42.868784 [ 3 ] {} <Trace> HTTP-Session: 3b6910e4-fa26-4944-9460-8f7d2c7a4851 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
301 | 2024.10.09 22:35:42.869366 [ 3 ] {995a0642-63a6-45c8-bf3f-8a82137b5845} <Debug> executeQuery: (from [::1]:54509) 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) | ||
302 | 2024.10.09 22:35:42.869448 [ 3 ] {995a0642-63a6-45c8-bf3f-8a82137b5845} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
303 | 2024.10.09 22:35:42.872291 [ 3 ] {995a0642-63a6-45c8-bf3f-8a82137b5845} <Debug> oximeter.measurements_u16 (917d5fa8-9f0d-41d4-b56d-87bf129f831c): Loading data parts | ||
304 | 2024.10.09 22:35:42.872628 [ 3 ] {995a0642-63a6-45c8-bf3f-8a82137b5845} <Debug> oximeter.measurements_u16 (917d5fa8-9f0d-41d4-b56d-87bf129f831c): There are no data parts | ||
305 | 2024.10.09 22:35:42.874525 [ 3 ] {995a0642-63a6-45c8-bf3f-8a82137b5845} <Debug> DynamicQueryHandler: Done processing query | ||
306 | 2024.10.09 22:35:42.874557 [ 3 ] {} <Debug> HTTP-Session: 3b6910e4-fa26-4944-9460-8f7d2c7a4851 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
307 | 2024.10.09 22:35:42.878679 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
308 | 2024.10.09 22:35:42.878800 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
309 | 2024.10.09 22:35:42.878829 [ 3 ] {} <Debug> HTTP-Session: b8fb21b5-ad36-4a19-9570-2394290fedce Authenticating user 'default' from [::1]:54509 | ||
310 | 2024.10.09 22:35:42.878857 [ 3 ] {} <Debug> HTTP-Session: b8fb21b5-ad36-4a19-9570-2394290fedce Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
311 | 2024.10.09 22:35:42.878895 [ 3 ] {} <Debug> HTTP-Session: b8fb21b5-ad36-4a19-9570-2394290fedce Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
312 | 2024.10.09 22:35:42.878963 [ 3 ] {} <Trace> HTTP-Session: b8fb21b5-ad36-4a19-9570-2394290fedce Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
313 | 2024.10.09 22:35:42.879401 [ 3 ] {de8801ed-b3b2-4e6f-a972-90f8f9035e37} <Debug> executeQuery: (from [::1]:54509) 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) | ||
314 | 2024.10.09 22:35:42.879487 [ 3 ] {de8801ed-b3b2-4e6f-a972-90f8f9035e37} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
315 | 2024.10.09 22:35:42.883289 [ 3 ] {de8801ed-b3b2-4e6f-a972-90f8f9035e37} <Debug> oximeter.measurements_i32 (febc8549-82b7-4253-b981-41c06cf3485e): Loading data parts | ||
316 | 2024.10.09 22:35:42.883811 [ 3 ] {de8801ed-b3b2-4e6f-a972-90f8f9035e37} <Debug> oximeter.measurements_i32 (febc8549-82b7-4253-b981-41c06cf3485e): There are no data parts | ||
317 | 2024.10.09 22:35:42.886232 [ 3 ] {de8801ed-b3b2-4e6f-a972-90f8f9035e37} <Debug> DynamicQueryHandler: Done processing query | ||
318 | 2024.10.09 22:35:42.886267 [ 3 ] {} <Debug> HTTP-Session: b8fb21b5-ad36-4a19-9570-2394290fedce Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
319 | 2024.10.09 22:35:42.894895 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
320 | 2024.10.09 22:35:42.895051 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
321 | 2024.10.09 22:35:42.895086 [ 3 ] {} <Debug> HTTP-Session: 6779d455-b3ff-49f7-9713-f572f117b1c3 Authenticating user 'default' from [::1]:54509 | ||
322 | 2024.10.09 22:35:42.895114 [ 3 ] {} <Debug> HTTP-Session: 6779d455-b3ff-49f7-9713-f572f117b1c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
323 | 2024.10.09 22:35:42.895140 [ 3 ] {} <Debug> HTTP-Session: 6779d455-b3ff-49f7-9713-f572f117b1c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
324 | 2024.10.09 22:35:42.895197 [ 3 ] {} <Trace> HTTP-Session: 6779d455-b3ff-49f7-9713-f572f117b1c3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
325 | 2024.10.09 22:35:42.895648 [ 3 ] {1b2e3a43-2f24-413d-b9f4-4a344ba1031f} <Debug> executeQuery: (from [::1]:54509) 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) | ||
326 | 2024.10.09 22:35:42.895726 [ 3 ] {1b2e3a43-2f24-413d-b9f4-4a344ba1031f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
327 | 2024.10.09 22:35:42.898209 [ 3 ] {1b2e3a43-2f24-413d-b9f4-4a344ba1031f} <Debug> oximeter.measurements_u32 (c35c2a5d-2a33-4f08-9420-a96ce5f3b605): Loading data parts | ||
328 | 2024.10.09 22:35:42.898521 [ 3 ] {1b2e3a43-2f24-413d-b9f4-4a344ba1031f} <Debug> oximeter.measurements_u32 (c35c2a5d-2a33-4f08-9420-a96ce5f3b605): There are no data parts | ||
329 | 2024.10.09 22:35:42.900450 [ 3 ] {1b2e3a43-2f24-413d-b9f4-4a344ba1031f} <Debug> DynamicQueryHandler: Done processing query | ||
330 | 2024.10.09 22:35:42.900490 [ 3 ] {} <Debug> HTTP-Session: 6779d455-b3ff-49f7-9713-f572f117b1c3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
331 | 2024.10.09 22:35:42.907126 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
332 | 2024.10.09 22:35:42.907238 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
333 | 2024.10.09 22:35:42.907288 [ 3 ] {} <Debug> HTTP-Session: 83f95802-520a-4b43-9157-3612c793a92d Authenticating user 'default' from [::1]:54509 | ||
334 | 2024.10.09 22:35:42.907318 [ 3 ] {} <Debug> HTTP-Session: 83f95802-520a-4b43-9157-3612c793a92d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
335 | 2024.10.09 22:35:42.907338 [ 3 ] {} <Debug> HTTP-Session: 83f95802-520a-4b43-9157-3612c793a92d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
336 | 2024.10.09 22:35:42.907407 [ 3 ] {} <Trace> HTTP-Session: 83f95802-520a-4b43-9157-3612c793a92d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
337 | 2024.10.09 22:35:42.907818 [ 3 ] {b189f957-cc17-43f8-8a2d-f21e85b10166} <Debug> executeQuery: (from [::1]:54509) 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) | ||
338 | 2024.10.09 22:35:42.907907 [ 3 ] {b189f957-cc17-43f8-8a2d-f21e85b10166} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
339 | 2024.10.09 22:35:42.910545 [ 3 ] {b189f957-cc17-43f8-8a2d-f21e85b10166} <Debug> oximeter.measurements_i64 (bc21e7ad-960e-47f9-a489-fa0bb41e6526): Loading data parts | ||
340 | 2024.10.09 22:35:42.910978 [ 3 ] {b189f957-cc17-43f8-8a2d-f21e85b10166} <Debug> oximeter.measurements_i64 (bc21e7ad-960e-47f9-a489-fa0bb41e6526): There are no data parts | ||
341 | 2024.10.09 22:35:42.913206 [ 3 ] {b189f957-cc17-43f8-8a2d-f21e85b10166} <Debug> DynamicQueryHandler: Done processing query | ||
342 | 2024.10.09 22:35:42.913236 [ 3 ] {} <Debug> HTTP-Session: 83f95802-520a-4b43-9157-3612c793a92d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
343 | 2024.10.09 22:35:42.919344 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
344 | 2024.10.09 22:35:42.919482 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
345 | 2024.10.09 22:35:42.919512 [ 3 ] {} <Debug> HTTP-Session: aec49bf5-c499-4843-ba9d-0b4c82a3f749 Authenticating user 'default' from [::1]:54509 | ||
346 | 2024.10.09 22:35:42.919536 [ 3 ] {} <Debug> HTTP-Session: aec49bf5-c499-4843-ba9d-0b4c82a3f749 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
347 | 2024.10.09 22:35:42.919558 [ 3 ] {} <Debug> HTTP-Session: aec49bf5-c499-4843-ba9d-0b4c82a3f749 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
348 | 2024.10.09 22:35:42.919609 [ 3 ] {} <Trace> HTTP-Session: aec49bf5-c499-4843-ba9d-0b4c82a3f749 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
349 | 2024.10.09 22:35:42.919979 [ 3 ] {26c89450-f141-490f-b0a6-d168055dbdc2} <Debug> executeQuery: (from [::1]:54509) 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) | ||
350 | 2024.10.09 22:35:42.920084 [ 3 ] {26c89450-f141-490f-b0a6-d168055dbdc2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
351 | 2024.10.09 22:35:42.923334 [ 3 ] {26c89450-f141-490f-b0a6-d168055dbdc2} <Debug> oximeter.measurements_u64 (2cfce7f2-eefc-4d42-b335-d82e0a2818f3): Loading data parts | ||
352 | 2024.10.09 22:35:42.923628 [ 3 ] {26c89450-f141-490f-b0a6-d168055dbdc2} <Debug> oximeter.measurements_u64 (2cfce7f2-eefc-4d42-b335-d82e0a2818f3): There are no data parts | ||
353 | 2024.10.09 22:35:42.925414 [ 3 ] {26c89450-f141-490f-b0a6-d168055dbdc2} <Debug> DynamicQueryHandler: Done processing query | ||
354 | 2024.10.09 22:35:42.925446 [ 3 ] {} <Debug> HTTP-Session: aec49bf5-c499-4843-ba9d-0b4c82a3f749 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
355 | 2024.10.09 22:35:43.000441 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 140.89 MiB, peak 141.90 MiB, free memory in arenas 0.00 B, will set to 146.88 MiB (RSS), difference: 6.00 MiB | ||
356 | 2024.10.09 22:35:43.001494 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
357 | 2024.10.09 22:35:43.001652 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
358 | 2024.10.09 22:35:43.001686 [ 3 ] {} <Debug> HTTP-Session: d31877b0-3b5f-4532-ad1d-31f9204fbb16 Authenticating user 'default' from [::1]:54509 | ||
359 | 2024.10.09 22:35:43.001711 [ 3 ] {} <Debug> HTTP-Session: d31877b0-3b5f-4532-ad1d-31f9204fbb16 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
360 | 2024.10.09 22:35:43.001726 [ 3 ] {} <Debug> HTTP-Session: d31877b0-3b5f-4532-ad1d-31f9204fbb16 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
361 | 2024.10.09 22:35:43.001793 [ 3 ] {} <Trace> HTTP-Session: d31877b0-3b5f-4532-ad1d-31f9204fbb16 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
362 | 2024.10.09 22:35:43.002172 [ 3 ] {21178c9f-19d5-4ead-885f-2fcfe6e15185} <Debug> executeQuery: (from [::1]:54509) 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) | ||
363 | 2024.10.09 22:35:43.002336 [ 3 ] {21178c9f-19d5-4ead-885f-2fcfe6e15185} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
364 | 2024.10.09 22:35:43.005621 [ 3 ] {21178c9f-19d5-4ead-885f-2fcfe6e15185} <Debug> oximeter.measurements_f32 (e4f80808-da57-42d7-81d0-a73a21985b6c): Loading data parts | ||
365 | 2024.10.09 22:35:43.005994 [ 3 ] {21178c9f-19d5-4ead-885f-2fcfe6e15185} <Debug> oximeter.measurements_f32 (e4f80808-da57-42d7-81d0-a73a21985b6c): There are no data parts | ||
366 | 2024.10.09 22:35:43.007939 [ 3 ] {21178c9f-19d5-4ead-885f-2fcfe6e15185} <Debug> DynamicQueryHandler: Done processing query | ||
367 | 2024.10.09 22:35:43.007972 [ 3 ] {} <Debug> HTTP-Session: d31877b0-3b5f-4532-ad1d-31f9204fbb16 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
368 | 2024.10.09 22:35:43.130738 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
369 | 2024.10.09 22:35:43.130866 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
370 | 2024.10.09 22:35:43.130897 [ 3 ] {} <Debug> HTTP-Session: 7cf625af-bf1c-4db0-a531-92c1534c158d Authenticating user 'default' from [::1]:54509 | ||
371 | 2024.10.09 22:35:43.130939 [ 3 ] {} <Debug> HTTP-Session: 7cf625af-bf1c-4db0-a531-92c1534c158d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
372 | 2024.10.09 22:35:43.130955 [ 3 ] {} <Debug> HTTP-Session: 7cf625af-bf1c-4db0-a531-92c1534c158d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
373 | 2024.10.09 22:35:43.131013 [ 3 ] {} <Trace> HTTP-Session: 7cf625af-bf1c-4db0-a531-92c1534c158d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
374 | 2024.10.09 22:35:43.131508 [ 3 ] {35e81d39-afde-417e-b914-a447e7a1d829} <Debug> executeQuery: (from [::1]:54509) 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) | ||
375 | 2024.10.09 22:35:43.131595 [ 3 ] {35e81d39-afde-417e-b914-a447e7a1d829} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
376 | 2024.10.09 22:35:43.134481 [ 3 ] {35e81d39-afde-417e-b914-a447e7a1d829} <Debug> oximeter.measurements_f64 (2726138c-3402-4d7e-8232-ed6080e1fb3d): Loading data parts | ||
377 | 2024.10.09 22:35:43.134884 [ 3 ] {35e81d39-afde-417e-b914-a447e7a1d829} <Debug> oximeter.measurements_f64 (2726138c-3402-4d7e-8232-ed6080e1fb3d): There are no data parts | ||
378 | 2024.10.09 22:35:43.137040 [ 3 ] {35e81d39-afde-417e-b914-a447e7a1d829} <Debug> DynamicQueryHandler: Done processing query | ||
379 | 2024.10.09 22:35:43.137088 [ 3 ] {} <Debug> HTTP-Session: 7cf625af-bf1c-4db0-a531-92c1534c158d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
380 | 2024.10.09 22:35:43.142967 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
381 | 2024.10.09 22:35:43.143174 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
382 | 2024.10.09 22:35:43.143226 [ 3 ] {} <Debug> HTTP-Session: a912f257-9b91-4003-ac62-8fa303da3ba2 Authenticating user 'default' from [::1]:54509 | ||
383 | 2024.10.09 22:35:43.143253 [ 3 ] {} <Debug> HTTP-Session: a912f257-9b91-4003-ac62-8fa303da3ba2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
384 | 2024.10.09 22:35:43.143267 [ 3 ] {} <Debug> HTTP-Session: a912f257-9b91-4003-ac62-8fa303da3ba2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
385 | 2024.10.09 22:35:43.143328 [ 3 ] {} <Trace> HTTP-Session: a912f257-9b91-4003-ac62-8fa303da3ba2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
386 | 2024.10.09 22:35:43.143745 [ 3 ] {c87666eb-9155-4352-b9ce-70e99390eb7e} <Debug> executeQuery: (from [::1]:54509) 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) | ||
387 | 2024.10.09 22:35:43.143833 [ 3 ] {c87666eb-9155-4352-b9ce-70e99390eb7e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
388 | 2024.10.09 22:35:43.147498 [ 3 ] {c87666eb-9155-4352-b9ce-70e99390eb7e} <Debug> oximeter.measurements_string (51ace0e1-78ef-41bc-bd12-da231e5f3d41): Loading data parts | ||
389 | 2024.10.09 22:35:43.147906 [ 3 ] {c87666eb-9155-4352-b9ce-70e99390eb7e} <Debug> oximeter.measurements_string (51ace0e1-78ef-41bc-bd12-da231e5f3d41): There are no data parts | ||
390 | 2024.10.09 22:35:43.149711 [ 3 ] {c87666eb-9155-4352-b9ce-70e99390eb7e} <Debug> DynamicQueryHandler: Done processing query | ||
391 | 2024.10.09 22:35:43.149740 [ 3 ] {} <Debug> HTTP-Session: a912f257-9b91-4003-ac62-8fa303da3ba2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
392 | 2024.10.09 22:35:43.173967 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
393 | 2024.10.09 22:35:43.174105 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
394 | 2024.10.09 22:35:43.174133 [ 3 ] {} <Debug> HTTP-Session: f2f5dae3-ca63-4ea5-9c66-b525423ef4cb Authenticating user 'default' from [::1]:54509 | ||
395 | 2024.10.09 22:35:43.174160 [ 3 ] {} <Debug> HTTP-Session: f2f5dae3-ca63-4ea5-9c66-b525423ef4cb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
396 | 2024.10.09 22:35:43.174195 [ 3 ] {} <Debug> HTTP-Session: f2f5dae3-ca63-4ea5-9c66-b525423ef4cb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
397 | 2024.10.09 22:35:43.174254 [ 3 ] {} <Trace> HTTP-Session: f2f5dae3-ca63-4ea5-9c66-b525423ef4cb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
398 | 2024.10.09 22:35:43.174684 [ 3 ] {3188431d-2e7c-4d80-bc80-3df7314e459d} <Debug> executeQuery: (from [::1]:54509) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
399 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
400 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
401 | * a string isn't palatable for a few reasons. | ||
402 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
403 | * details. | ||
404 | */ | ||
405 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
406 | 2024.10.09 22:35:43.174769 [ 3 ] {3188431d-2e7c-4d80-bc80-3df7314e459d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
407 | 2024.10.09 22:35:43.177143 [ 3 ] {3188431d-2e7c-4d80-bc80-3df7314e459d} <Debug> oximeter.measurements_bytes (b0d2d7df-b3c2-4099-9eb6-14de51d708aa): Loading data parts | ||
408 | 2024.10.09 22:35:43.177476 [ 3 ] {3188431d-2e7c-4d80-bc80-3df7314e459d} <Debug> oximeter.measurements_bytes (b0d2d7df-b3c2-4099-9eb6-14de51d708aa): There are no data parts | ||
409 | 2024.10.09 22:35:43.179542 [ 3 ] {3188431d-2e7c-4d80-bc80-3df7314e459d} <Debug> DynamicQueryHandler: Done processing query | ||
410 | 2024.10.09 22:35:43.179573 [ 3 ] {} <Debug> HTTP-Session: f2f5dae3-ca63-4ea5-9c66-b525423ef4cb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
411 | 2024.10.09 22:35:43.248020 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
412 | 2024.10.09 22:35:43.248170 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
413 | 2024.10.09 22:35:43.248201 [ 3 ] {} <Debug> HTTP-Session: c1ff8447-d27d-4a87-bbe8-a621048d58d9 Authenticating user 'default' from [::1]:54509 | ||
414 | 2024.10.09 22:35:43.248230 [ 3 ] {} <Debug> HTTP-Session: c1ff8447-d27d-4a87-bbe8-a621048d58d9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
415 | 2024.10.09 22:35:43.248258 [ 3 ] {} <Debug> HTTP-Session: c1ff8447-d27d-4a87-bbe8-a621048d58d9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
416 | 2024.10.09 22:35:43.248320 [ 3 ] {} <Trace> HTTP-Session: c1ff8447-d27d-4a87-bbe8-a621048d58d9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
417 | 2024.10.09 22:35:43.248734 [ 3 ] {2d79bcc1-7120-4f97-95ac-7da04fb802dd} <Debug> executeQuery: (from [::1]:54509) 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) | ||
418 | 2024.10.09 22:35:43.248818 [ 3 ] {2d79bcc1-7120-4f97-95ac-7da04fb802dd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
419 | 2024.10.09 22:35:43.251473 [ 3 ] {2d79bcc1-7120-4f97-95ac-7da04fb802dd} <Debug> oximeter.measurements_cumulativei64 (c15cedb8-25c3-4e71-aa0e-06890576b732): Loading data parts | ||
420 | 2024.10.09 22:35:43.251794 [ 3 ] {2d79bcc1-7120-4f97-95ac-7da04fb802dd} <Debug> oximeter.measurements_cumulativei64 (c15cedb8-25c3-4e71-aa0e-06890576b732): There are no data parts | ||
421 | 2024.10.09 22:35:43.253584 [ 3 ] {2d79bcc1-7120-4f97-95ac-7da04fb802dd} <Debug> DynamicQueryHandler: Done processing query | ||
422 | 2024.10.09 22:35:43.253613 [ 3 ] {} <Debug> HTTP-Session: c1ff8447-d27d-4a87-bbe8-a621048d58d9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
423 | 2024.10.09 22:35:43.266400 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
424 | 2024.10.09 22:35:43.266542 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
425 | 2024.10.09 22:35:43.266575 [ 3 ] {} <Debug> HTTP-Session: c9c28a92-a657-4bdb-a466-276bc1ff0fc2 Authenticating user 'default' from [::1]:54509 | ||
426 | 2024.10.09 22:35:43.266604 [ 3 ] {} <Debug> HTTP-Session: c9c28a92-a657-4bdb-a466-276bc1ff0fc2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
427 | 2024.10.09 22:35:43.266620 [ 3 ] {} <Debug> HTTP-Session: c9c28a92-a657-4bdb-a466-276bc1ff0fc2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
428 | 2024.10.09 22:35:43.266692 [ 3 ] {} <Trace> HTTP-Session: c9c28a92-a657-4bdb-a466-276bc1ff0fc2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
429 | 2024.10.09 22:35:43.267214 [ 3 ] {b1e4698f-e88c-431c-9ea1-cea165cd9de3} <Debug> executeQuery: (from [::1]:54509) 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) | ||
430 | 2024.10.09 22:35:43.267304 [ 3 ] {b1e4698f-e88c-431c-9ea1-cea165cd9de3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
431 | 2024.10.09 22:35:43.272887 [ 3 ] {b1e4698f-e88c-431c-9ea1-cea165cd9de3} <Debug> oximeter.measurements_cumulativeu64 (8f961391-1208-4f36-8e2a-c15bc0168b55): Loading data parts | ||
432 | 2024.10.09 22:35:43.275108 [ 3 ] {b1e4698f-e88c-431c-9ea1-cea165cd9de3} <Debug> oximeter.measurements_cumulativeu64 (8f961391-1208-4f36-8e2a-c15bc0168b55): There are no data parts | ||
433 | 2024.10.09 22:35:43.277332 [ 3 ] {b1e4698f-e88c-431c-9ea1-cea165cd9de3} <Debug> DynamicQueryHandler: Done processing query | ||
434 | 2024.10.09 22:35:43.277364 [ 3 ] {} <Debug> HTTP-Session: c9c28a92-a657-4bdb-a466-276bc1ff0fc2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
435 | 2024.10.09 22:35:43.285624 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
436 | 2024.10.09 22:35:43.285741 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
437 | 2024.10.09 22:35:43.285766 [ 3 ] {} <Debug> HTTP-Session: ceeaaf47-959a-4595-aa33-c618ccb672f3 Authenticating user 'default' from [::1]:54509 | ||
438 | 2024.10.09 22:35:43.285809 [ 3 ] {} <Debug> HTTP-Session: ceeaaf47-959a-4595-aa33-c618ccb672f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
439 | 2024.10.09 22:35:43.285824 [ 3 ] {} <Debug> HTTP-Session: ceeaaf47-959a-4595-aa33-c618ccb672f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
440 | 2024.10.09 22:35:43.285878 [ 3 ] {} <Trace> HTTP-Session: ceeaaf47-959a-4595-aa33-c618ccb672f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
441 | 2024.10.09 22:35:43.286291 [ 3 ] {4e702352-7094-4e9f-bced-0effd326dced} <Debug> executeQuery: (from [::1]:54509) 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) | ||
442 | 2024.10.09 22:35:43.286372 [ 3 ] {4e702352-7094-4e9f-bced-0effd326dced} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
443 | 2024.10.09 22:35:43.293011 [ 3 ] {4e702352-7094-4e9f-bced-0effd326dced} <Debug> oximeter.measurements_cumulativef32 (5c0ead53-98c4-413e-ac19-90d02007293b): Loading data parts | ||
444 | 2024.10.09 22:35:43.293515 [ 3 ] {4e702352-7094-4e9f-bced-0effd326dced} <Debug> oximeter.measurements_cumulativef32 (5c0ead53-98c4-413e-ac19-90d02007293b): There are no data parts | ||
445 | 2024.10.09 22:35:43.295554 [ 3 ] {4e702352-7094-4e9f-bced-0effd326dced} <Debug> DynamicQueryHandler: Done processing query | ||
446 | 2024.10.09 22:35:43.295585 [ 3 ] {} <Debug> HTTP-Session: ceeaaf47-959a-4595-aa33-c618ccb672f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
447 | 2024.10.09 22:35:43.313231 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
448 | 2024.10.09 22:35:43.313364 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
449 | 2024.10.09 22:35:43.313438 [ 3 ] {} <Debug> HTTP-Session: bded29b4-bade-489c-98ff-f550adbece07 Authenticating user 'default' from [::1]:54509 | ||
450 | 2024.10.09 22:35:43.313475 [ 3 ] {} <Debug> HTTP-Session: bded29b4-bade-489c-98ff-f550adbece07 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
451 | 2024.10.09 22:35:43.313499 [ 3 ] {} <Debug> HTTP-Session: bded29b4-bade-489c-98ff-f550adbece07 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
452 | 2024.10.09 22:35:43.313555 [ 3 ] {} <Trace> HTTP-Session: bded29b4-bade-489c-98ff-f550adbece07 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
453 | 2024.10.09 22:35:43.313927 [ 3 ] {14b180c8-2daa-4e28-bc25-b4a2d0f46e6d} <Debug> executeQuery: (from [::1]:54509) 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) | ||
454 | 2024.10.09 22:35:43.314017 [ 3 ] {14b180c8-2daa-4e28-bc25-b4a2d0f46e6d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
455 | 2024.10.09 22:35:43.317016 [ 3 ] {14b180c8-2daa-4e28-bc25-b4a2d0f46e6d} <Debug> oximeter.measurements_cumulativef64 (cb6dc28b-8e2b-4bb1-8484-acae97d59086): Loading data parts | ||
456 | 2024.10.09 22:35:43.317339 [ 3 ] {14b180c8-2daa-4e28-bc25-b4a2d0f46e6d} <Debug> oximeter.measurements_cumulativef64 (cb6dc28b-8e2b-4bb1-8484-acae97d59086): There are no data parts | ||
457 | 2024.10.09 22:35:43.319133 [ 3 ] {14b180c8-2daa-4e28-bc25-b4a2d0f46e6d} <Debug> DynamicQueryHandler: Done processing query | ||
458 | 2024.10.09 22:35:43.319171 [ 3 ] {} <Debug> HTTP-Session: bded29b4-bade-489c-98ff-f550adbece07 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
459 | 2024.10.09 22:35:43.321392 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
460 | 2024.10.09 22:35:43.321460 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
461 | 2024.10.09 22:35:43.321611 [ 3 ] {} <Debug> HTTP-Session: 80b5f774-0c09-4ec3-b476-19460076839c Authenticating user 'default' from [::1]:54509 | ||
462 | 2024.10.09 22:35:43.321647 [ 3 ] {} <Debug> HTTP-Session: 80b5f774-0c09-4ec3-b476-19460076839c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
463 | 2024.10.09 22:35:43.321666 [ 3 ] {} <Debug> HTTP-Session: 80b5f774-0c09-4ec3-b476-19460076839c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
464 | 2024.10.09 22:35:43.321721 [ 3 ] {} <Trace> HTTP-Session: 80b5f774-0c09-4ec3-b476-19460076839c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
465 | 2024.10.09 22:35:43.322126 [ 3 ] {b9abcb72-c19a-43a7-9a0d-75bf1f9069ae} <Debug> executeQuery: (from [::1]:54509) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
466 | * NOTE: Array types cannot be Nullable, see | ||
467 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
468 | * for more details. | ||
469 | * | ||
470 | * This means we need to use empty arrays to indicate a missing value. This | ||
471 | * is unfortunate, and at this point relies on the fact that an | ||
472 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
473 | * to figure out another way to represent missing samples here. | ||
474 | */ | ||
475 | 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) | ||
476 | 2024.10.09 22:35:43.322226 [ 3 ] {b9abcb72-c19a-43a7-9a0d-75bf1f9069ae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
477 | 2024.10.09 22:35:43.324990 [ 3 ] {b9abcb72-c19a-43a7-9a0d-75bf1f9069ae} <Debug> oximeter.measurements_histogrami8 (9ec9c52a-d5f6-4e0e-ba84-81280e73aec6): Loading data parts | ||
478 | 2024.10.09 22:35:43.325347 [ 3 ] {b9abcb72-c19a-43a7-9a0d-75bf1f9069ae} <Debug> oximeter.measurements_histogrami8 (9ec9c52a-d5f6-4e0e-ba84-81280e73aec6): There are no data parts | ||
479 | 2024.10.09 22:35:43.327229 [ 3 ] {b9abcb72-c19a-43a7-9a0d-75bf1f9069ae} <Debug> DynamicQueryHandler: Done processing query | ||
480 | 2024.10.09 22:35:43.327261 [ 3 ] {} <Debug> HTTP-Session: 80b5f774-0c09-4ec3-b476-19460076839c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
481 | 2024.10.09 22:35:43.349929 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
482 | 2024.10.09 22:35:43.350073 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
483 | 2024.10.09 22:35:43.350105 [ 3 ] {} <Debug> HTTP-Session: 51a192f5-c5d8-4b20-88d8-047e06ac8380 Authenticating user 'default' from [::1]:54509 | ||
484 | 2024.10.09 22:35:43.350135 [ 3 ] {} <Debug> HTTP-Session: 51a192f5-c5d8-4b20-88d8-047e06ac8380 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
485 | 2024.10.09 22:35:43.350164 [ 3 ] {} <Debug> HTTP-Session: 51a192f5-c5d8-4b20-88d8-047e06ac8380 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
486 | 2024.10.09 22:35:43.350238 [ 3 ] {} <Trace> HTTP-Session: 51a192f5-c5d8-4b20-88d8-047e06ac8380 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
487 | 2024.10.09 22:35:43.350911 [ 3 ] {58900d94-4a41-4657-aefc-7c3c329c342b} <Debug> executeQuery: (from [::1]:54509) 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) | ||
488 | 2024.10.09 22:35:43.351014 [ 3 ] {58900d94-4a41-4657-aefc-7c3c329c342b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
489 | 2024.10.09 22:35:43.353994 [ 3 ] {58900d94-4a41-4657-aefc-7c3c329c342b} <Debug> oximeter.measurements_histogramu8 (99e467ac-f3c0-46d2-9b80-1b0be28ad39f): Loading data parts | ||
490 | 2024.10.09 22:35:43.354344 [ 3 ] {58900d94-4a41-4657-aefc-7c3c329c342b} <Debug> oximeter.measurements_histogramu8 (99e467ac-f3c0-46d2-9b80-1b0be28ad39f): There are no data parts | ||
491 | 2024.10.09 22:35:43.356358 [ 3 ] {58900d94-4a41-4657-aefc-7c3c329c342b} <Debug> DynamicQueryHandler: Done processing query | ||
492 | 2024.10.09 22:35:43.356389 [ 3 ] {} <Debug> HTTP-Session: 51a192f5-c5d8-4b20-88d8-047e06ac8380 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
493 | 2024.10.09 22:35:43.359666 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
494 | 2024.10.09 22:35:43.359830 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
495 | 2024.10.09 22:35:43.359860 [ 3 ] {} <Debug> HTTP-Session: 4bb3a1b2-c8ff-4eb0-ace2-3692492cc18e Authenticating user 'default' from [::1]:54509 | ||
496 | 2024.10.09 22:35:43.359897 [ 3 ] {} <Debug> HTTP-Session: 4bb3a1b2-c8ff-4eb0-ace2-3692492cc18e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
497 | 2024.10.09 22:35:43.359911 [ 3 ] {} <Debug> HTTP-Session: 4bb3a1b2-c8ff-4eb0-ace2-3692492cc18e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
498 | 2024.10.09 22:35:43.359958 [ 3 ] {} <Trace> HTTP-Session: 4bb3a1b2-c8ff-4eb0-ace2-3692492cc18e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
499 | 2024.10.09 22:35:43.360417 [ 3 ] {11d058fa-76ce-4d2b-b8e2-f7cd7879dbe9} <Debug> executeQuery: (from [::1]:54509) 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) | ||
500 | 2024.10.09 22:35:43.360507 [ 3 ] {11d058fa-76ce-4d2b-b8e2-f7cd7879dbe9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
501 | 2024.10.09 22:35:43.372298 [ 3 ] {11d058fa-76ce-4d2b-b8e2-f7cd7879dbe9} <Debug> oximeter.measurements_histogrami16 (914be3a1-1158-4adc-9686-ec2dd24527fd): Loading data parts | ||
502 | 2024.10.09 22:35:43.372737 [ 3 ] {11d058fa-76ce-4d2b-b8e2-f7cd7879dbe9} <Debug> oximeter.measurements_histogrami16 (914be3a1-1158-4adc-9686-ec2dd24527fd): There are no data parts | ||
503 | 2024.10.09 22:35:43.408518 [ 3 ] {11d058fa-76ce-4d2b-b8e2-f7cd7879dbe9} <Debug> DynamicQueryHandler: Done processing query | ||
504 | 2024.10.09 22:35:43.408589 [ 3 ] {} <Debug> HTTP-Session: 4bb3a1b2-c8ff-4eb0-ace2-3692492cc18e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
505 | 2024.10.09 22:35:43.490236 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
506 | 2024.10.09 22:35:43.490398 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
507 | 2024.10.09 22:35:43.490459 [ 3 ] {} <Debug> HTTP-Session: 599f5a80-46cc-43fe-a8ff-c72c063c3338 Authenticating user 'default' from [::1]:54509 | ||
508 | 2024.10.09 22:35:43.490491 [ 3 ] {} <Debug> HTTP-Session: 599f5a80-46cc-43fe-a8ff-c72c063c3338 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
509 | 2024.10.09 22:35:43.490511 [ 3 ] {} <Debug> HTTP-Session: 599f5a80-46cc-43fe-a8ff-c72c063c3338 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
510 | 2024.10.09 22:35:43.490585 [ 3 ] {} <Trace> HTTP-Session: 599f5a80-46cc-43fe-a8ff-c72c063c3338 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
511 | 2024.10.09 22:35:43.491619 [ 3 ] {3637f5c6-fca6-43b0-b1be-81b80dfd5f47} <Debug> executeQuery: (from [::1]:54509) 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) | ||
512 | 2024.10.09 22:35:43.491724 [ 3 ] {3637f5c6-fca6-43b0-b1be-81b80dfd5f47} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
513 | 2024.10.09 22:35:43.499108 [ 3 ] {3637f5c6-fca6-43b0-b1be-81b80dfd5f47} <Debug> oximeter.measurements_histogramu16 (f0dfd76d-7a3c-455a-aa04-2acd0160c1a0): Loading data parts | ||
514 | 2024.10.09 22:35:43.506051 [ 3 ] {3637f5c6-fca6-43b0-b1be-81b80dfd5f47} <Debug> oximeter.measurements_histogramu16 (f0dfd76d-7a3c-455a-aa04-2acd0160c1a0): There are no data parts | ||
515 | 2024.10.09 22:35:43.531272 [ 3 ] {3637f5c6-fca6-43b0-b1be-81b80dfd5f47} <Debug> DynamicQueryHandler: Done processing query | ||
516 | 2024.10.09 22:35:43.531318 [ 3 ] {} <Debug> HTTP-Session: 599f5a80-46cc-43fe-a8ff-c72c063c3338 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
517 | 2024.10.09 22:35:43.542778 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
518 | 2024.10.09 22:35:43.542948 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
519 | 2024.10.09 22:35:43.542977 [ 3 ] {} <Debug> HTTP-Session: 7184667f-f2e8-4cc3-80e4-6c39e4f8bf55 Authenticating user 'default' from [::1]:54509 | ||
520 | 2024.10.09 22:35:43.543003 [ 3 ] {} <Debug> HTTP-Session: 7184667f-f2e8-4cc3-80e4-6c39e4f8bf55 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
521 | 2024.10.09 22:35:43.543026 [ 3 ] {} <Debug> HTTP-Session: 7184667f-f2e8-4cc3-80e4-6c39e4f8bf55 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
522 | 2024.10.09 22:35:43.543083 [ 3 ] {} <Trace> HTTP-Session: 7184667f-f2e8-4cc3-80e4-6c39e4f8bf55 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
523 | 2024.10.09 22:35:43.543657 [ 3 ] {0d446c0a-b2c6-4166-a89b-50b726b6b695} <Debug> executeQuery: (from [::1]:54509) 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) | ||
524 | 2024.10.09 22:35:43.543755 [ 3 ] {0d446c0a-b2c6-4166-a89b-50b726b6b695} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
525 | 2024.10.09 22:35:43.551281 [ 3 ] {0d446c0a-b2c6-4166-a89b-50b726b6b695} <Debug> oximeter.measurements_histogrami32 (63697bfe-9492-439a-a2f0-ca0fb4e7bd44): Loading data parts | ||
526 | 2024.10.09 22:35:43.552076 [ 3 ] {0d446c0a-b2c6-4166-a89b-50b726b6b695} <Debug> oximeter.measurements_histogrami32 (63697bfe-9492-439a-a2f0-ca0fb4e7bd44): There are no data parts | ||
527 | 2024.10.09 22:35:43.565196 [ 3 ] {0d446c0a-b2c6-4166-a89b-50b726b6b695} <Debug> DynamicQueryHandler: Done processing query | ||
528 | 2024.10.09 22:35:43.565265 [ 3 ] {} <Debug> HTTP-Session: 7184667f-f2e8-4cc3-80e4-6c39e4f8bf55 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
529 | 2024.10.09 22:35:43.577137 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
530 | 2024.10.09 22:35:43.577710 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
531 | 2024.10.09 22:35:43.577774 [ 3 ] {} <Debug> HTTP-Session: 806bd014-064e-469e-8daf-f6ac8b2dcc43 Authenticating user 'default' from [::1]:54509 | ||
532 | 2024.10.09 22:35:43.577807 [ 3 ] {} <Debug> HTTP-Session: 806bd014-064e-469e-8daf-f6ac8b2dcc43 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
533 | 2024.10.09 22:35:43.577826 [ 3 ] {} <Debug> HTTP-Session: 806bd014-064e-469e-8daf-f6ac8b2dcc43 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
534 | 2024.10.09 22:35:43.577907 [ 3 ] {} <Trace> HTTP-Session: 806bd014-064e-469e-8daf-f6ac8b2dcc43 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
535 | 2024.10.09 22:35:43.578485 [ 3 ] {3471f6ef-4aa2-4e0c-bffb-5870dae581cf} <Debug> executeQuery: (from [::1]:54509) 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) | ||
536 | 2024.10.09 22:35:43.578734 [ 3 ] {3471f6ef-4aa2-4e0c-bffb-5870dae581cf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
537 | 2024.10.09 22:35:43.582444 [ 3 ] {3471f6ef-4aa2-4e0c-bffb-5870dae581cf} <Debug> oximeter.measurements_histogramu32 (132d0b2d-037e-4718-92ed-7ee15a693b08): Loading data parts | ||
538 | 2024.10.09 22:35:43.582922 [ 3 ] {3471f6ef-4aa2-4e0c-bffb-5870dae581cf} <Debug> oximeter.measurements_histogramu32 (132d0b2d-037e-4718-92ed-7ee15a693b08): There are no data parts | ||
539 | 2024.10.09 22:35:43.613136 [ 3 ] {3471f6ef-4aa2-4e0c-bffb-5870dae581cf} <Debug> DynamicQueryHandler: Done processing query | ||
540 | 2024.10.09 22:35:43.613183 [ 3 ] {} <Debug> HTTP-Session: 806bd014-064e-469e-8daf-f6ac8b2dcc43 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
541 | 2024.10.09 22:35:43.613989 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
542 | 2024.10.09 22:35:43.614098 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
543 | 2024.10.09 22:35:43.614126 [ 3 ] {} <Debug> HTTP-Session: 823ee851-15cf-47cd-8293-42755cc96e00 Authenticating user 'default' from [::1]:54509 | ||
544 | 2024.10.09 22:35:43.614168 [ 3 ] {} <Debug> HTTP-Session: 823ee851-15cf-47cd-8293-42755cc96e00 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
545 | 2024.10.09 22:35:43.614197 [ 3 ] {} <Debug> HTTP-Session: 823ee851-15cf-47cd-8293-42755cc96e00 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
546 | 2024.10.09 22:35:43.614253 [ 3 ] {} <Trace> HTTP-Session: 823ee851-15cf-47cd-8293-42755cc96e00 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
547 | 2024.10.09 22:35:43.614880 [ 3 ] {50a8d744-7a18-4016-95b5-b2e47d8c9852} <Debug> executeQuery: (from [::1]:54509) 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) | ||
548 | 2024.10.09 22:35:43.614986 [ 3 ] {50a8d744-7a18-4016-95b5-b2e47d8c9852} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
549 | 2024.10.09 22:35:43.618589 [ 3 ] {50a8d744-7a18-4016-95b5-b2e47d8c9852} <Debug> oximeter.measurements_histogrami64 (34f7388a-f0b8-4253-a3d4-c958a10f39c4): Loading data parts | ||
550 | 2024.10.09 22:35:43.618999 [ 3 ] {50a8d744-7a18-4016-95b5-b2e47d8c9852} <Debug> oximeter.measurements_histogrami64 (34f7388a-f0b8-4253-a3d4-c958a10f39c4): There are no data parts | ||
551 | 2024.10.09 22:35:43.621134 [ 3 ] {50a8d744-7a18-4016-95b5-b2e47d8c9852} <Debug> DynamicQueryHandler: Done processing query | ||
552 | 2024.10.09 22:35:43.621170 [ 3 ] {} <Debug> HTTP-Session: 823ee851-15cf-47cd-8293-42755cc96e00 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
553 | 2024.10.09 22:35:43.621982 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
554 | 2024.10.09 22:35:43.622097 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
555 | 2024.10.09 22:35:43.622132 [ 3 ] {} <Debug> HTTP-Session: 38cbc5fd-6bc5-408a-9b71-528ccce834ea Authenticating user 'default' from [::1]:54509 | ||
556 | 2024.10.09 22:35:43.622184 [ 3 ] {} <Debug> HTTP-Session: 38cbc5fd-6bc5-408a-9b71-528ccce834ea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
557 | 2024.10.09 22:35:43.622202 [ 3 ] {} <Debug> HTTP-Session: 38cbc5fd-6bc5-408a-9b71-528ccce834ea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
558 | 2024.10.09 22:35:43.622254 [ 3 ] {} <Trace> HTTP-Session: 38cbc5fd-6bc5-408a-9b71-528ccce834ea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
559 | 2024.10.09 22:35:43.622915 [ 3 ] {803ddc12-9100-4888-a56f-9f6ea308a274} <Debug> executeQuery: (from [::1]:54509) 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) | ||
560 | 2024.10.09 22:35:43.623017 [ 3 ] {803ddc12-9100-4888-a56f-9f6ea308a274} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
561 | 2024.10.09 22:35:43.632837 [ 3 ] {803ddc12-9100-4888-a56f-9f6ea308a274} <Debug> oximeter.measurements_histogramu64 (75b5620c-e966-4559-b021-99d409ffa072): Loading data parts | ||
562 | 2024.10.09 22:35:43.638404 [ 3 ] {803ddc12-9100-4888-a56f-9f6ea308a274} <Debug> oximeter.measurements_histogramu64 (75b5620c-e966-4559-b021-99d409ffa072): There are no data parts | ||
563 | 2024.10.09 22:35:43.644261 [ 3 ] {803ddc12-9100-4888-a56f-9f6ea308a274} <Debug> DynamicQueryHandler: Done processing query | ||
564 | 2024.10.09 22:35:43.644328 [ 3 ] {} <Debug> HTTP-Session: 38cbc5fd-6bc5-408a-9b71-528ccce834ea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
565 | 2024.10.09 22:35:43.651918 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
566 | 2024.10.09 22:35:43.652069 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
567 | 2024.10.09 22:35:43.652095 [ 3 ] {} <Debug> HTTP-Session: 62f342f6-a417-47a9-98ff-2caeff52e13e Authenticating user 'default' from [::1]:54509 | ||
568 | 2024.10.09 22:35:43.652121 [ 3 ] {} <Debug> HTTP-Session: 62f342f6-a417-47a9-98ff-2caeff52e13e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
569 | 2024.10.09 22:35:43.652148 [ 3 ] {} <Debug> HTTP-Session: 62f342f6-a417-47a9-98ff-2caeff52e13e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
570 | 2024.10.09 22:35:43.652611 [ 3 ] {} <Trace> HTTP-Session: 62f342f6-a417-47a9-98ff-2caeff52e13e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
571 | 2024.10.09 22:35:43.653203 [ 3 ] {8e9423c4-54ed-4618-b3ac-8b523baad2e5} <Debug> executeQuery: (from [::1]:54509) 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) | ||
572 | 2024.10.09 22:35:43.653306 [ 3 ] {8e9423c4-54ed-4618-b3ac-8b523baad2e5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
573 | 2024.10.09 22:35:43.656574 [ 3 ] {8e9423c4-54ed-4618-b3ac-8b523baad2e5} <Debug> oximeter.measurements_histogramf32 (564cc902-6b45-46c4-b31f-8183405474a5): Loading data parts | ||
574 | 2024.10.09 22:35:43.657217 [ 3 ] {8e9423c4-54ed-4618-b3ac-8b523baad2e5} <Debug> oximeter.measurements_histogramf32 (564cc902-6b45-46c4-b31f-8183405474a5): There are no data parts | ||
575 | 2024.10.09 22:35:43.659130 [ 3 ] {8e9423c4-54ed-4618-b3ac-8b523baad2e5} <Debug> DynamicQueryHandler: Done processing query | ||
576 | 2024.10.09 22:35:43.659159 [ 3 ] {} <Debug> HTTP-Session: 62f342f6-a417-47a9-98ff-2caeff52e13e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
577 | 2024.10.09 22:35:43.660094 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
578 | 2024.10.09 22:35:43.660164 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
579 | 2024.10.09 22:35:43.660187 [ 3 ] {} <Debug> HTTP-Session: b9b7d3a4-9703-42a8-8847-36928fd8c331 Authenticating user 'default' from [::1]:54509 | ||
580 | 2024.10.09 22:35:43.660225 [ 3 ] {} <Debug> HTTP-Session: b9b7d3a4-9703-42a8-8847-36928fd8c331 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
581 | 2024.10.09 22:35:43.660240 [ 3 ] {} <Debug> HTTP-Session: b9b7d3a4-9703-42a8-8847-36928fd8c331 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
582 | 2024.10.09 22:35:43.660286 [ 3 ] {} <Trace> HTTP-Session: b9b7d3a4-9703-42a8-8847-36928fd8c331 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
583 | 2024.10.09 22:35:43.660938 [ 3 ] {c9771166-c484-4bf7-bc2e-b20debb0b7e1} <Debug> executeQuery: (from [::1]:54509) 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) | ||
584 | 2024.10.09 22:35:43.661046 [ 3 ] {c9771166-c484-4bf7-bc2e-b20debb0b7e1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
585 | 2024.10.09 22:35:43.689933 [ 3 ] {c9771166-c484-4bf7-bc2e-b20debb0b7e1} <Debug> oximeter.measurements_histogramf64 (fd0c017c-e991-464a-bb3c-0c389b8517a2): Loading data parts | ||
586 | 2024.10.09 22:35:43.690317 [ 3 ] {c9771166-c484-4bf7-bc2e-b20debb0b7e1} <Debug> oximeter.measurements_histogramf64 (fd0c017c-e991-464a-bb3c-0c389b8517a2): There are no data parts | ||
587 | 2024.10.09 22:35:43.706103 [ 3 ] {c9771166-c484-4bf7-bc2e-b20debb0b7e1} <Debug> DynamicQueryHandler: Done processing query | ||
588 | 2024.10.09 22:35:43.706191 [ 3 ] {} <Debug> HTTP-Session: b9b7d3a4-9703-42a8-8847-36928fd8c331 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
589 | 2024.10.09 22:35:43.707710 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
590 | 2024.10.09 22:35:43.707817 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
591 | 2024.10.09 22:35:43.707861 [ 3 ] {} <Debug> HTTP-Session: 26005519-096b-4119-9a89-683361708411 Authenticating user 'default' from [::1]:54509 | ||
592 | 2024.10.09 22:35:43.707923 [ 3 ] {} <Debug> HTTP-Session: 26005519-096b-4119-9a89-683361708411 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
593 | 2024.10.09 22:35:43.707949 [ 3 ] {} <Debug> HTTP-Session: 26005519-096b-4119-9a89-683361708411 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
594 | 2024.10.09 22:35:43.708019 [ 3 ] {} <Trace> HTTP-Session: 26005519-096b-4119-9a89-683361708411 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
595 | 2024.10.09 22:35:43.708474 [ 3 ] {eaa76045-12f6-4f24-b4a9-601152ba3cdb} <Debug> executeQuery: (from [::1]:54509) /* The field tables store named dimensions of each timeseries. | ||
596 | * | ||
597 | * As with the measurement tables, there is one field table for each field data | ||
598 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
599 | * this behavior **must not** be relied upon for query correctness. | ||
600 | * | ||
601 | * The index for the fields differs from the measurements, however. Rows are | ||
602 | * sorted by timeseries name, then field name, field value, and finally | ||
603 | * timeseries key. This reflects the most common pattern for looking them up: | ||
604 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
605 | * usually then used to look up measurements. | ||
606 | * | ||
607 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
608 | * timeseries name and then key, since it would improve lookups where one | ||
609 | * already has the key. Realistically though, these tables are quite small and | ||
610 | * so performance benefits will be low in absolute terms. | ||
611 | * | ||
612 | * TTL: We use a materialized column to expire old field table records. This | ||
613 | * column is generated automatically by the database whenever a new row is | ||
614 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
615 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
616 | * record will remain during a deduplication, which will have the last | ||
617 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
618 | * measurement tables. | ||
619 | */ | ||
620 | 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) | ||
621 | 2024.10.09 22:35:43.708570 [ 3 ] {eaa76045-12f6-4f24-b4a9-601152ba3cdb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
622 | 2024.10.09 22:35:43.715185 [ 3 ] {eaa76045-12f6-4f24-b4a9-601152ba3cdb} <Debug> oximeter.fields_bool (66f2b44b-8222-4e26-a9b6-d61d4056f0ee): Loading data parts | ||
623 | 2024.10.09 22:35:43.715847 [ 3 ] {eaa76045-12f6-4f24-b4a9-601152ba3cdb} <Debug> oximeter.fields_bool (66f2b44b-8222-4e26-a9b6-d61d4056f0ee): There are no data parts | ||
624 | 2024.10.09 22:35:43.719555 [ 3 ] {eaa76045-12f6-4f24-b4a9-601152ba3cdb} <Debug> DynamicQueryHandler: Done processing query | ||
625 | 2024.10.09 22:35:43.719594 [ 3 ] {} <Debug> HTTP-Session: 26005519-096b-4119-9a89-683361708411 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
626 | 2024.10.09 22:35:43.722483 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
627 | 2024.10.09 22:35:43.722684 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
628 | 2024.10.09 22:35:43.722782 [ 3 ] {} <Debug> HTTP-Session: 4c4fb3c2-8fc7-4e29-a5ec-0005bac1d6e5 Authenticating user 'default' from [::1]:54509 | ||
629 | 2024.10.09 22:35:43.722829 [ 3 ] {} <Debug> HTTP-Session: 4c4fb3c2-8fc7-4e29-a5ec-0005bac1d6e5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
630 | 2024.10.09 22:35:43.722869 [ 3 ] {} <Debug> HTTP-Session: 4c4fb3c2-8fc7-4e29-a5ec-0005bac1d6e5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
631 | 2024.10.09 22:35:43.722932 [ 3 ] {} <Trace> HTTP-Session: 4c4fb3c2-8fc7-4e29-a5ec-0005bac1d6e5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
632 | 2024.10.09 22:35:43.723299 [ 3 ] {a3584daa-ea89-4f02-bc55-c4ca4a1a0fd9} <Debug> executeQuery: (from [::1]:54509) 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) | ||
633 | 2024.10.09 22:35:43.723389 [ 3 ] {a3584daa-ea89-4f02-bc55-c4ca4a1a0fd9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
634 | 2024.10.09 22:35:43.726705 [ 3 ] {a3584daa-ea89-4f02-bc55-c4ca4a1a0fd9} <Debug> oximeter.fields_i8 (b80fa47d-42db-4f48-9465-e95388483061): Loading data parts | ||
635 | 2024.10.09 22:35:43.727030 [ 3 ] {a3584daa-ea89-4f02-bc55-c4ca4a1a0fd9} <Debug> oximeter.fields_i8 (b80fa47d-42db-4f48-9465-e95388483061): There are no data parts | ||
636 | 2024.10.09 22:35:43.728896 [ 3 ] {a3584daa-ea89-4f02-bc55-c4ca4a1a0fd9} <Debug> DynamicQueryHandler: Done processing query | ||
637 | 2024.10.09 22:35:43.728926 [ 3 ] {} <Debug> HTTP-Session: 4c4fb3c2-8fc7-4e29-a5ec-0005bac1d6e5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
638 | 2024.10.09 22:35:43.730044 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
639 | 2024.10.09 22:35:43.730123 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
640 | 2024.10.09 22:35:43.730166 [ 3 ] {} <Debug> HTTP-Session: db8af46c-192c-45f2-8142-74b33315431f Authenticating user 'default' from [::1]:54509 | ||
641 | 2024.10.09 22:35:43.730211 [ 3 ] {} <Debug> HTTP-Session: db8af46c-192c-45f2-8142-74b33315431f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
642 | 2024.10.09 22:35:43.730231 [ 3 ] {} <Debug> HTTP-Session: db8af46c-192c-45f2-8142-74b33315431f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
643 | 2024.10.09 22:35:43.730284 [ 3 ] {} <Trace> HTTP-Session: db8af46c-192c-45f2-8142-74b33315431f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
644 | 2024.10.09 22:35:43.730619 [ 3 ] {24214fa5-e099-4dec-8b0a-5aa5aefda085} <Debug> executeQuery: (from [::1]:54509) 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) | ||
645 | 2024.10.09 22:35:43.730734 [ 3 ] {24214fa5-e099-4dec-8b0a-5aa5aefda085} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
646 | 2024.10.09 22:35:43.733341 [ 3 ] {24214fa5-e099-4dec-8b0a-5aa5aefda085} <Debug> oximeter.fields_u8 (901b07d8-dbd4-467e-8ece-2a5570953848): Loading data parts | ||
647 | 2024.10.09 22:35:43.733740 [ 3 ] {24214fa5-e099-4dec-8b0a-5aa5aefda085} <Debug> oximeter.fields_u8 (901b07d8-dbd4-467e-8ece-2a5570953848): There are no data parts | ||
648 | 2024.10.09 22:35:43.762195 [ 3 ] {24214fa5-e099-4dec-8b0a-5aa5aefda085} <Debug> DynamicQueryHandler: Done processing query | ||
649 | 2024.10.09 22:35:43.762245 [ 3 ] {} <Debug> HTTP-Session: db8af46c-192c-45f2-8142-74b33315431f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
650 | 2024.10.09 22:35:43.769065 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
651 | 2024.10.09 22:35:43.769252 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
652 | 2024.10.09 22:35:43.769418 [ 3 ] {} <Debug> HTTP-Session: 8984bcd4-8856-4caa-8818-e40b4e4cc013 Authenticating user 'default' from [::1]:54509 | ||
653 | 2024.10.09 22:35:43.769458 [ 3 ] {} <Debug> HTTP-Session: 8984bcd4-8856-4caa-8818-e40b4e4cc013 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
654 | 2024.10.09 22:35:43.771925 [ 3 ] {} <Debug> HTTP-Session: 8984bcd4-8856-4caa-8818-e40b4e4cc013 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
655 | 2024.10.09 22:35:43.773626 [ 3 ] {} <Trace> HTTP-Session: 8984bcd4-8856-4caa-8818-e40b4e4cc013 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
656 | 2024.10.09 22:35:43.774172 [ 3 ] {7eaa3101-4644-440b-b375-bf2714299e5c} <Debug> executeQuery: (from [::1]:54509) 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) | ||
657 | 2024.10.09 22:35:43.774467 [ 3 ] {7eaa3101-4644-440b-b375-bf2714299e5c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
658 | 2024.10.09 22:35:43.794376 [ 3 ] {7eaa3101-4644-440b-b375-bf2714299e5c} <Debug> oximeter.fields_i16 (41ff35a0-5bb6-4c02-9884-132cccf1f1a0): Loading data parts | ||
659 | 2024.10.09 22:35:43.794747 [ 3 ] {7eaa3101-4644-440b-b375-bf2714299e5c} <Debug> oximeter.fields_i16 (41ff35a0-5bb6-4c02-9884-132cccf1f1a0): There are no data parts | ||
660 | 2024.10.09 22:35:43.797026 [ 3 ] {7eaa3101-4644-440b-b375-bf2714299e5c} <Debug> DynamicQueryHandler: Done processing query | ||
661 | 2024.10.09 22:35:43.797058 [ 3 ] {} <Debug> HTTP-Session: 8984bcd4-8856-4caa-8818-e40b4e4cc013 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
662 | 2024.10.09 22:35:43.797864 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
663 | 2024.10.09 22:35:43.797934 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
664 | 2024.10.09 22:35:43.797991 [ 3 ] {} <Debug> HTTP-Session: d42aa0d3-7101-4fd5-a861-8e507ce73250 Authenticating user 'default' from [::1]:54509 | ||
665 | 2024.10.09 22:35:43.798074 [ 3 ] {} <Debug> HTTP-Session: d42aa0d3-7101-4fd5-a861-8e507ce73250 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
666 | 2024.10.09 22:35:43.798093 [ 3 ] {} <Debug> HTTP-Session: d42aa0d3-7101-4fd5-a861-8e507ce73250 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
667 | 2024.10.09 22:35:43.798155 [ 3 ] {} <Trace> HTTP-Session: d42aa0d3-7101-4fd5-a861-8e507ce73250 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
668 | 2024.10.09 22:35:43.798871 [ 3 ] {cb81688e-bbdf-4052-80f2-5d9a3b5410b8} <Debug> executeQuery: (from [::1]:54509) 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) | ||
669 | 2024.10.09 22:35:43.798967 [ 3 ] {cb81688e-bbdf-4052-80f2-5d9a3b5410b8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
670 | 2024.10.09 22:35:43.813545 [ 3 ] {cb81688e-bbdf-4052-80f2-5d9a3b5410b8} <Debug> oximeter.fields_u16 (b44b4cb3-7d65-40d5-8d96-8f3949372ec6): Loading data parts | ||
671 | 2024.10.09 22:35:43.813871 [ 3 ] {cb81688e-bbdf-4052-80f2-5d9a3b5410b8} <Debug> oximeter.fields_u16 (b44b4cb3-7d65-40d5-8d96-8f3949372ec6): There are no data parts | ||
672 | 2024.10.09 22:35:43.840177 [ 3 ] {cb81688e-bbdf-4052-80f2-5d9a3b5410b8} <Debug> DynamicQueryHandler: Done processing query | ||
673 | 2024.10.09 22:35:43.840232 [ 3 ] {} <Debug> HTTP-Session: d42aa0d3-7101-4fd5-a861-8e507ce73250 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
674 | 2024.10.09 22:35:43.843929 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
675 | 2024.10.09 22:35:43.844052 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
676 | 2024.10.09 22:35:43.844084 [ 3 ] {} <Debug> HTTP-Session: 365d0a50-75c9-43ba-942b-7dfb2817c3ab Authenticating user 'default' from [::1]:54509 | ||
677 | 2024.10.09 22:35:43.844114 [ 3 ] {} <Debug> HTTP-Session: 365d0a50-75c9-43ba-942b-7dfb2817c3ab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
678 | 2024.10.09 22:35:43.844131 [ 3 ] {} <Debug> HTTP-Session: 365d0a50-75c9-43ba-942b-7dfb2817c3ab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
679 | 2024.10.09 22:35:43.844202 [ 3 ] {} <Trace> HTTP-Session: 365d0a50-75c9-43ba-942b-7dfb2817c3ab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
680 | 2024.10.09 22:35:43.844602 [ 3 ] {31d9b433-a602-4882-b77c-295fd8bf8d8e} <Debug> executeQuery: (from [::1]:54509) 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) | ||
681 | 2024.10.09 22:35:43.844691 [ 3 ] {31d9b433-a602-4882-b77c-295fd8bf8d8e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
682 | 2024.10.09 22:35:43.852695 [ 3 ] {31d9b433-a602-4882-b77c-295fd8bf8d8e} <Debug> oximeter.fields_i32 (4309835a-e9be-4024-8dcd-64c324407e59): Loading data parts | ||
683 | 2024.10.09 22:35:43.853027 [ 3 ] {31d9b433-a602-4882-b77c-295fd8bf8d8e} <Debug> oximeter.fields_i32 (4309835a-e9be-4024-8dcd-64c324407e59): There are no data parts | ||
684 | 2024.10.09 22:35:43.861228 [ 3 ] {31d9b433-a602-4882-b77c-295fd8bf8d8e} <Debug> DynamicQueryHandler: Done processing query | ||
685 | 2024.10.09 22:35:43.861269 [ 3 ] {} <Debug> HTTP-Session: 365d0a50-75c9-43ba-942b-7dfb2817c3ab Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
686 | 2024.10.09 22:35:43.863586 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
687 | 2024.10.09 22:35:43.863714 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
688 | 2024.10.09 22:35:43.863841 [ 3 ] {} <Debug> HTTP-Session: 06b40d2f-0486-4790-b61e-5aaeb336a4af Authenticating user 'default' from [::1]:54509 | ||
689 | 2024.10.09 22:35:43.864384 [ 3 ] {} <Debug> HTTP-Session: 06b40d2f-0486-4790-b61e-5aaeb336a4af Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
690 | 2024.10.09 22:35:43.864418 [ 3 ] {} <Debug> HTTP-Session: 06b40d2f-0486-4790-b61e-5aaeb336a4af Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
691 | 2024.10.09 22:35:43.864504 [ 3 ] {} <Trace> HTTP-Session: 06b40d2f-0486-4790-b61e-5aaeb336a4af Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
692 | 2024.10.09 22:35:43.865247 [ 3 ] {c9eb7ddc-0c6f-4351-a46f-6852d362a49e} <Debug> executeQuery: (from [::1]:54509) 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) | ||
693 | 2024.10.09 22:35:43.865385 [ 3 ] {c9eb7ddc-0c6f-4351-a46f-6852d362a49e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
694 | 2024.10.09 22:35:43.874197 [ 3 ] {c9eb7ddc-0c6f-4351-a46f-6852d362a49e} <Debug> oximeter.fields_u32 (0b2da5e1-129c-4cf5-803a-082816790cb6): Loading data parts | ||
695 | 2024.10.09 22:35:43.874994 [ 3 ] {c9eb7ddc-0c6f-4351-a46f-6852d362a49e} <Debug> oximeter.fields_u32 (0b2da5e1-129c-4cf5-803a-082816790cb6): There are no data parts | ||
696 | 2024.10.09 22:35:43.877679 [ 3 ] {c9eb7ddc-0c6f-4351-a46f-6852d362a49e} <Debug> DynamicQueryHandler: Done processing query | ||
697 | 2024.10.09 22:35:43.877711 [ 3 ] {} <Debug> HTTP-Session: 06b40d2f-0486-4790-b61e-5aaeb336a4af Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
698 | 2024.10.09 22:35:43.878831 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
699 | 2024.10.09 22:35:43.878926 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
700 | 2024.10.09 22:35:43.878956 [ 3 ] {} <Debug> HTTP-Session: 99edceea-3d95-4021-8d5c-723e86f8119d Authenticating user 'default' from [::1]:54509 | ||
701 | 2024.10.09 22:35:43.878982 [ 3 ] {} <Debug> HTTP-Session: 99edceea-3d95-4021-8d5c-723e86f8119d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
702 | 2024.10.09 22:35:43.878996 [ 3 ] {} <Debug> HTTP-Session: 99edceea-3d95-4021-8d5c-723e86f8119d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
703 | 2024.10.09 22:35:43.879055 [ 3 ] {} <Trace> HTTP-Session: 99edceea-3d95-4021-8d5c-723e86f8119d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
704 | 2024.10.09 22:35:43.879376 [ 3 ] {7a37e664-cf86-4753-94c1-cad8011480b5} <Debug> executeQuery: (from [::1]:54509) 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) | ||
705 | 2024.10.09 22:35:43.879461 [ 3 ] {7a37e664-cf86-4753-94c1-cad8011480b5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
706 | 2024.10.09 22:35:43.886145 [ 3 ] {7a37e664-cf86-4753-94c1-cad8011480b5} <Debug> oximeter.fields_i64 (58a9e98c-266d-47c0-beec-67301c784cfc): Loading data parts | ||
707 | 2024.10.09 22:35:43.887591 [ 3 ] {7a37e664-cf86-4753-94c1-cad8011480b5} <Debug> oximeter.fields_i64 (58a9e98c-266d-47c0-beec-67301c784cfc): There are no data parts | ||
708 | 2024.10.09 22:35:43.895712 [ 3 ] {7a37e664-cf86-4753-94c1-cad8011480b5} <Debug> DynamicQueryHandler: Done processing query | ||
709 | 2024.10.09 22:35:43.895757 [ 3 ] {} <Debug> HTTP-Session: 99edceea-3d95-4021-8d5c-723e86f8119d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
710 | 2024.10.09 22:35:43.896564 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
711 | 2024.10.09 22:35:43.896645 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
712 | 2024.10.09 22:35:43.896713 [ 3 ] {} <Debug> HTTP-Session: 2c110aa9-f62c-4def-9507-0f410ebc0130 Authenticating user 'default' from [::1]:54509 | ||
713 | 2024.10.09 22:35:43.896738 [ 3 ] {} <Debug> HTTP-Session: 2c110aa9-f62c-4def-9507-0f410ebc0130 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
714 | 2024.10.09 22:35:43.896753 [ 3 ] {} <Debug> HTTP-Session: 2c110aa9-f62c-4def-9507-0f410ebc0130 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
715 | 2024.10.09 22:35:43.896803 [ 3 ] {} <Trace> HTTP-Session: 2c110aa9-f62c-4def-9507-0f410ebc0130 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
716 | 2024.10.09 22:35:43.897157 [ 3 ] {57b4efea-8ec6-49cb-88f2-b04fd6880536} <Debug> executeQuery: (from [::1]:54509) 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) | ||
717 | 2024.10.09 22:35:43.897229 [ 3 ] {57b4efea-8ec6-49cb-88f2-b04fd6880536} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
718 | 2024.10.09 22:35:43.899905 [ 3 ] {57b4efea-8ec6-49cb-88f2-b04fd6880536} <Debug> oximeter.fields_u64 (11c73158-9298-4535-9b94-21dd4ba6fda2): Loading data parts | ||
719 | 2024.10.09 22:35:43.900250 [ 3 ] {57b4efea-8ec6-49cb-88f2-b04fd6880536} <Debug> oximeter.fields_u64 (11c73158-9298-4535-9b94-21dd4ba6fda2): There are no data parts | ||
720 | 2024.10.09 22:35:43.902444 [ 3 ] {57b4efea-8ec6-49cb-88f2-b04fd6880536} <Debug> DynamicQueryHandler: Done processing query | ||
721 | 2024.10.09 22:35:43.902476 [ 3 ] {} <Debug> HTTP-Session: 2c110aa9-f62c-4def-9507-0f410ebc0130 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
722 | 2024.10.09 22:35:43.903109 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
723 | 2024.10.09 22:35:43.903179 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
724 | 2024.10.09 22:35:43.903203 [ 3 ] {} <Debug> HTTP-Session: 7818938c-607b-4a28-a2ee-92a29b60b752 Authenticating user 'default' from [::1]:54509 | ||
725 | 2024.10.09 22:35:43.903225 [ 3 ] {} <Debug> HTTP-Session: 7818938c-607b-4a28-a2ee-92a29b60b752 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
726 | 2024.10.09 22:35:43.903278 [ 3 ] {} <Debug> HTTP-Session: 7818938c-607b-4a28-a2ee-92a29b60b752 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
727 | 2024.10.09 22:35:43.903335 [ 3 ] {} <Trace> HTTP-Session: 7818938c-607b-4a28-a2ee-92a29b60b752 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
728 | 2024.10.09 22:35:43.903718 [ 3 ] {ce04fbf2-ab1e-4816-83c8-99cd4f666896} <Debug> executeQuery: (from [::1]:54509) 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) | ||
729 | 2024.10.09 22:35:43.903788 [ 3 ] {ce04fbf2-ab1e-4816-83c8-99cd4f666896} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
730 | 2024.10.09 22:35:43.907164 [ 3 ] {ce04fbf2-ab1e-4816-83c8-99cd4f666896} <Debug> oximeter.fields_ipaddr (965aacd6-832d-4a13-a2e7-2113a32a9cef): Loading data parts | ||
731 | 2024.10.09 22:35:43.907547 [ 3 ] {ce04fbf2-ab1e-4816-83c8-99cd4f666896} <Debug> oximeter.fields_ipaddr (965aacd6-832d-4a13-a2e7-2113a32a9cef): There are no data parts | ||
732 | 2024.10.09 22:35:43.909957 [ 3 ] {ce04fbf2-ab1e-4816-83c8-99cd4f666896} <Debug> DynamicQueryHandler: Done processing query | ||
733 | 2024.10.09 22:35:43.909988 [ 3 ] {} <Debug> HTTP-Session: 7818938c-607b-4a28-a2ee-92a29b60b752 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
734 | 2024.10.09 22:35:43.910636 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
735 | 2024.10.09 22:35:43.910709 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
736 | 2024.10.09 22:35:43.910735 [ 3 ] {} <Debug> HTTP-Session: b632b5d1-c99a-44de-b898-46bdd8cb480e Authenticating user 'default' from [::1]:54509 | ||
737 | 2024.10.09 22:35:43.910760 [ 3 ] {} <Debug> HTTP-Session: b632b5d1-c99a-44de-b898-46bdd8cb480e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
738 | 2024.10.09 22:35:43.910774 [ 3 ] {} <Debug> HTTP-Session: b632b5d1-c99a-44de-b898-46bdd8cb480e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
739 | 2024.10.09 22:35:43.910822 [ 3 ] {} <Trace> HTTP-Session: b632b5d1-c99a-44de-b898-46bdd8cb480e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
740 | 2024.10.09 22:35:43.911242 [ 3 ] {d2350380-b3b8-4868-99f4-86f53cc381ea} <Debug> executeQuery: (from [::1]:54509) 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) | ||
741 | 2024.10.09 22:35:43.911315 [ 3 ] {d2350380-b3b8-4868-99f4-86f53cc381ea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
742 | 2024.10.09 22:35:43.915970 [ 3 ] {d2350380-b3b8-4868-99f4-86f53cc381ea} <Debug> oximeter.fields_string (d631fba9-6a57-4515-9b8f-b63c63a1edbe): Loading data parts | ||
743 | 2024.10.09 22:35:43.916379 [ 3 ] {d2350380-b3b8-4868-99f4-86f53cc381ea} <Debug> oximeter.fields_string (d631fba9-6a57-4515-9b8f-b63c63a1edbe): There are no data parts | ||
744 | 2024.10.09 22:35:43.918676 [ 3 ] {d2350380-b3b8-4868-99f4-86f53cc381ea} <Debug> DynamicQueryHandler: Done processing query | ||
745 | 2024.10.09 22:35:43.918709 [ 3 ] {} <Debug> HTTP-Session: b632b5d1-c99a-44de-b898-46bdd8cb480e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
746 | 2024.10.09 22:35:43.921109 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
747 | 2024.10.09 22:35:43.921187 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
748 | 2024.10.09 22:35:43.921214 [ 3 ] {} <Debug> HTTP-Session: 89f01e55-05b0-415a-a6b1-70502861b2f0 Authenticating user 'default' from [::1]:54509 | ||
749 | 2024.10.09 22:35:43.921240 [ 3 ] {} <Debug> HTTP-Session: 89f01e55-05b0-415a-a6b1-70502861b2f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
750 | 2024.10.09 22:35:43.921254 [ 3 ] {} <Debug> HTTP-Session: 89f01e55-05b0-415a-a6b1-70502861b2f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
751 | 2024.10.09 22:35:43.921303 [ 3 ] {} <Trace> HTTP-Session: 89f01e55-05b0-415a-a6b1-70502861b2f0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
752 | 2024.10.09 22:35:43.921671 [ 3 ] {69defb3f-6fcd-4e81-af44-59878e7d4f40} <Debug> executeQuery: (from [::1]:54509) 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) | ||
753 | 2024.10.09 22:35:43.921748 [ 3 ] {69defb3f-6fcd-4e81-af44-59878e7d4f40} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
754 | 2024.10.09 22:35:43.924857 [ 3 ] {69defb3f-6fcd-4e81-af44-59878e7d4f40} <Debug> oximeter.fields_uuid (b0313088-b271-4c88-9e39-cfde220678f6): Loading data parts | ||
755 | 2024.10.09 22:35:43.925241 [ 3 ] {69defb3f-6fcd-4e81-af44-59878e7d4f40} <Debug> oximeter.fields_uuid (b0313088-b271-4c88-9e39-cfde220678f6): There are no data parts | ||
756 | 2024.10.09 22:35:43.927527 [ 3 ] {69defb3f-6fcd-4e81-af44-59878e7d4f40} <Debug> DynamicQueryHandler: Done processing query | ||
757 | 2024.10.09 22:35:43.927563 [ 3 ] {} <Debug> HTTP-Session: 89f01e55-05b0-415a-a6b1-70502861b2f0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
758 | 2024.10.09 22:35:43.928077 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
759 | 2024.10.09 22:35:43.928150 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
760 | 2024.10.09 22:35:43.928176 [ 3 ] {} <Debug> HTTP-Session: 354f9ca2-e8cc-4b99-9a0e-f98cb76aefd9 Authenticating user 'default' from [::1]:54509 | ||
761 | 2024.10.09 22:35:43.928199 [ 3 ] {} <Debug> HTTP-Session: 354f9ca2-e8cc-4b99-9a0e-f98cb76aefd9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
762 | 2024.10.09 22:35:43.928214 [ 3 ] {} <Debug> HTTP-Session: 354f9ca2-e8cc-4b99-9a0e-f98cb76aefd9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
763 | 2024.10.09 22:35:43.928261 [ 3 ] {} <Trace> HTTP-Session: 354f9ca2-e8cc-4b99-9a0e-f98cb76aefd9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
764 | 2024.10.09 22:35:43.928605 [ 3 ] {71f8e140-21dc-47c8-b75e-cdf1d48fc164} <Debug> executeQuery: (from [::1]:54509) /* The timeseries schema table stores the extracted schema for the samples | ||
765 | * oximeter collects. | ||
766 | */ | ||
767 | 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) | ||
768 | 2024.10.09 22:35:43.928693 [ 3 ] {71f8e140-21dc-47c8-b75e-cdf1d48fc164} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
769 | 2024.10.09 22:35:43.945503 [ 3 ] {71f8e140-21dc-47c8-b75e-cdf1d48fc164} <Debug> oximeter.timeseries_schema (bda5576c-2424-4bd8-b5b5-705664aac9e8): Loading data parts | ||
770 | 2024.10.09 22:35:43.945845 [ 3 ] {71f8e140-21dc-47c8-b75e-cdf1d48fc164} <Debug> oximeter.timeseries_schema (bda5576c-2424-4bd8-b5b5-705664aac9e8): There are no data parts | ||
771 | 2024.10.09 22:35:43.963696 [ 3 ] {71f8e140-21dc-47c8-b75e-cdf1d48fc164} <Debug> DynamicQueryHandler: Done processing query | ||
772 | 2024.10.09 22:35:43.963742 [ 3 ] {} <Debug> HTTP-Session: 354f9ca2-e8cc-4b99-9a0e-f98cb76aefd9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
773 | 2024.10.09 22:35:43.966895 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54509, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
774 | 2024.10.09 22:35:43.966990 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
775 | 2024.10.09 22:35:43.967014 [ 3 ] {} <Debug> HTTP-Session: 6ffc7e12-9092-4288-b0a6-5608a034c35d Authenticating user 'default' from [::1]:54509 | ||
776 | 2024.10.09 22:35:43.967039 [ 3 ] {} <Debug> HTTP-Session: 6ffc7e12-9092-4288-b0a6-5608a034c35d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
777 | 2024.10.09 22:35:43.967053 [ 3 ] {} <Debug> HTTP-Session: 6ffc7e12-9092-4288-b0a6-5608a034c35d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
778 | 2024.10.09 22:35:43.967103 [ 3 ] {} <Trace> HTTP-Session: 6ffc7e12-9092-4288-b0a6-5608a034c35d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
779 | 2024.10.09 22:35:43.967321 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Debug> executeQuery: (from [::1]:54509) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
780 | 2024.10.09 22:35:43.967710 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
781 | 2024.10.09 22:35:43.969734 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Trace> oximeter.version (f6df3b01-420e-4572-a8cb-7abea5814f98): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
782 | 2024.10.09 22:35:43.969789 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.31 GiB. | ||
783 | 2024.10.09 22:35:43.970681 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
784 | 2024.10.09 22:35:43.971237 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Trace> oximeter.version (f6df3b01-420e-4572-a8cb-7abea5814f98): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
785 | 2024.10.09 22:35:43.971516 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.004289 sec., 233.1545814875262 rows/sec., 3.64 KiB/sec. | ||
786 | 2024.10.09 22:35:43.971876 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Debug> DynamicQueryHandler: Done processing query | ||
787 | 2024.10.09 22:35:43.971900 [ 3 ] {bb5c0b3d-6baa-4d8b-bce4-f80df67ca27e} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
788 | 2024.10.09 22:35:43.971917 [ 3 ] {} <Debug> HTTP-Session: 6ffc7e12-9092-4288-b0a6-5608a034c35d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
789 | 2024.10.09 22:35:44.000430 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 149.57 MiB, peak 154.70 MiB, free memory in arenas 0.00 B, will set to 148.31 MiB (RSS), difference: -1.26 MiB |