1 | 2024.10.09 22:30:46.904874 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 11860 | ||
2 | 2024.10.09 22:30:46.905120 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.10.09 22:30:46.905196 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.10.09 22:30:46.937553 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.10.09 22:30:46.944984 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.10.09 22:30:46.945034 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.10.09 22:30:46.945048 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.10.09 22:30:46.945116 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_saga_basic_usage_succeeds.11849.1-clickhouse-lfATXO/datastore/tmp/ to store temporary data in it | ||
9 | 2024.10.09 22:30:46.945689 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.10.09 22:30:46.946896 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
11 | 2024.10.09 22:30:46.947407 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
12 | 2024.10.09 22:30:46.947957 [ 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:30:46.947979 [ 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:30:46.947995 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.10.09 22:30:46.948119 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.10.09 22:30:46.948981 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.10.09 22:30:46.997585 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.10.09 22:30:47.007793 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.10.09 22:30:47.008845 [ 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:30:47.008905 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
21 | 2024.10.09 22:30:47.010151 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
22 | 2024.10.09 22:30:47.010719 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
23 | 2024.10.09 22:30:47.012658 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
24 | 2024.10.09 22:30:47.013236 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
25 | 2024.10.09 22:30:47.014499 [ 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:30:47.014917 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.10.09 22:30:47.015301 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.10.09 22:30:47.015648 [ 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:30:47.025724 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.10.09 22:30:47.025771 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_saga_basic_usage_succeeds.11849.1-clickhouse-lfATXO/datastore/ | ||
31 | 2024.10.09 22:30:47.033080 [ 173 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.10.09 22:30:47.033166 [ 173 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.10.09 22:30:47.048388 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.10.09 22:30:47.048432 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000199871 sec | ||
35 | 2024.10.09 22:30:47.048464 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.10.09 22:30:47.048474 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.10.09 22:30:47.048603 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.10.09 22:30:47.048649 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
39 | 2024.10.09 22:30:47.048662 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
40 | 2024.10.09 22:30:47.048689 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.10.09 22:30:47.048704 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.10.09 22:30:47.048714 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.10.09 22:30:47.048741 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.10.09 22:30:47.048752 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
45 | 2024.10.09 22:30:47.048767 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2024.10.09 22:30:47.048793 [ 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:30:47.048805 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
48 | 2024.10.09 22:30:47.048819 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2024.10.09 22:30:47.048830 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2024.10.09 22:30:47.048855 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.10.09 22:30:47.048869 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.10.09 22:30:47.048881 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2024.10.09 22:30:47.048939 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2024.10.09 22:30:47.048959 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2024.10.09 22:30:47.094454 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.10.09 22:30:47.096244 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.10.09 22:30:47.096414 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00020505 sec | ||
58 | 2024.10.09 22:30:47.096442 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.10.09 22:30:47.096453 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.10.09 22:30:47.096486 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.10.09 22:30:47.096680 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/omicron_nexus-400000b7063eede6-test_saga_basic_usage_succeeds.11849.1-clickhouse-lfATXO/datastore/user_defined/ | ||
62 | 2024.10.09 22:30:47.097377 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.10.09 22:30:47.097420 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.10.09 22:30:47.097435 [ 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:30:47.097496 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.10.09 22:30:47.097771 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 63220 | ||
67 | 2024.10.09 22:30:47.097980 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 45032 | ||
68 | 2024.10.09 22:30:47.099806 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1) | ||
69 | 2024.10.09 22:30:47.203224 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1) | ||
70 | 2024.10.09 22:30:47.203270 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
71 | 2024.10.09 22:30:47.298804 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 37943 | ||
72 | 2024.10.09 22:30:47.298948 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 39698 | ||
73 | 2024.10.09 22:30:47.299201 [ 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> | ||
74 | 2024.10.09 22:30:47.299267 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
75 | 2024.10.09 22:30:47.299632 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.88 MiB, peak 15.97 MiB, free memory in arenas 0.00 B, will set to 178.91 MiB (RSS), difference: 169.02 MiB | ||
76 | 2024.10.09 22:30:47.300060 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 3.8598e-05 sec. | ||
77 | 2024.10.09 22:30:47.300745 [ 1 ] {} <Information> Application: Listening for http://[::1]:63220 | ||
78 | 2024.10.09 22:30:47.300859 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:45032 | ||
79 | 2024.10.09 22:30:47.300926 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004 | ||
80 | 2024.10.09 22:30:47.301661 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:37943 | ||
81 | 2024.10.09 22:30:47.301763 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:39698 | ||
82 | 2024.10.09 22:30:47.301784 [ 1 ] {} <Information> Application: Ready for connections. | ||
83 | 2024.10.09 22:31:00.142856 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
84 | 2024.10.09 22:31:00.143097 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
85 | 2024.10.09 22:31:00.143134 [ 3 ] {} <Debug> HTTP-Session: 7118925e-1dbe-479c-ae5c-4132ff3f803c Authenticating user 'default' from [::1]:46893 | ||
86 | 2024.10.09 22:31:00.143164 [ 3 ] {} <Debug> HTTP-Session: 7118925e-1dbe-479c-ae5c-4132ff3f803c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
87 | 2024.10.09 22:31:00.143189 [ 3 ] {} <Debug> HTTP-Session: 7118925e-1dbe-479c-ae5c-4132ff3f803c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
88 | 2024.10.09 22:31:00.143310 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
89 | 2024.10.09 22:31:00.143356 [ 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 | ||
90 | 2024.10.09 22:31:00.143383 [ 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 | ||
91 | 2024.10.09 22:31:00.143442 [ 3 ] {} <Trace> HTTP-Session: 7118925e-1dbe-479c-ae5c-4132ff3f803c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
92 | 2024.10.09 22:31:00.144062 [ 3 ] {06993c15-14c7-466d-ba0d-88375eb51c67} <Debug> executeQuery: (from [::1]:46893) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
93 | 2024.10.09 22:31:00.152710 [ 3 ] {06993c15-14c7-466d-ba0d-88375eb51c67} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:46893) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
94 | |||
95 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
96 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
97 | 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 | ||
98 | 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 | ||
99 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
100 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
101 | 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 | ||
102 | 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 | ||
103 | 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 | ||
104 | 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 | ||
105 | 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 | ||
106 | 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 | ||
107 | 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 | ||
108 | 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 | ||
109 | 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 | ||
110 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
111 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
112 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
113 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
114 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
115 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
116 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
117 | |||
118 | 2024.10.09 22:31:00.153013 [ 3 ] {06993c15-14c7-466d-ba0d-88375eb51c67} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
119 | |||
120 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
121 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
122 | 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 | ||
123 | 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 | ||
124 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
125 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
126 | 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 | ||
127 | 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 | ||
128 | 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 | ||
129 | 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 | ||
130 | 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 | ||
131 | 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 | ||
132 | 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 | ||
133 | 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 | ||
134 | 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 | ||
135 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
136 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
137 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
138 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
139 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
140 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
141 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
142 | (version 23.8.7.1) | ||
143 | 2024.10.09 22:31:00.153319 [ 3 ] {} <Debug> HTTP-Session: 7118925e-1dbe-479c-ae5c-4132ff3f803c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
144 | 2024.10.09 22:31:00.155072 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
145 | 2024.10.09 22:31:00.155174 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
146 | 2024.10.09 22:31:00.155200 [ 3 ] {} <Debug> HTTP-Session: 5dc3b10a-d987-42de-af2e-ec945c6ac4c8 Authenticating user 'default' from [::1]:46893 | ||
147 | 2024.10.09 22:31:00.155227 [ 3 ] {} <Debug> HTTP-Session: 5dc3b10a-d987-42de-af2e-ec945c6ac4c8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
148 | 2024.10.09 22:31:00.155241 [ 3 ] {} <Debug> HTTP-Session: 5dc3b10a-d987-42de-af2e-ec945c6ac4c8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
149 | 2024.10.09 22:31:00.155305 [ 3 ] {} <Trace> HTTP-Session: 5dc3b10a-d987-42de-af2e-ec945c6ac4c8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
150 | 2024.10.09 22:31:00.155540 [ 3 ] {9a417734-7665-4cb4-b716-17a21fb27843} <Debug> executeQuery: (from [::1]:46893) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
151 | 2024.10.09 22:31:00.155933 [ 3 ] {9a417734-7665-4cb4-b716-17a21fb27843} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:46893) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
152 | |||
153 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
154 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
155 | 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 | ||
156 | 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 | ||
157 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
158 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
159 | 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 | ||
160 | 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 | ||
161 | 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 | ||
162 | 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 | ||
163 | 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 | ||
164 | 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 | ||
165 | 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 | ||
166 | 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 | ||
167 | 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 | ||
168 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
169 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
170 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
171 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
172 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
173 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
174 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
175 | |||
176 | 2024.10.09 22:31:00.156101 [ 3 ] {9a417734-7665-4cb4-b716-17a21fb27843} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
177 | |||
178 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
179 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
180 | 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 | ||
181 | 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 | ||
182 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
183 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
184 | 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 | ||
185 | 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 | ||
186 | 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 | ||
187 | 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 | ||
188 | 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 | ||
189 | 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 | ||
190 | 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 | ||
191 | 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 | ||
192 | 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 | ||
193 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
197 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
198 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
199 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
200 | (version 23.8.7.1) | ||
201 | 2024.10.09 22:31:00.156281 [ 3 ] {} <Debug> HTTP-Session: 5dc3b10a-d987-42de-af2e-ec945c6ac4c8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
202 | 2024.10.09 22:31:00.208382 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
203 | 2024.10.09 22:31:00.208519 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
204 | 2024.10.09 22:31:00.208545 [ 3 ] {} <Debug> HTTP-Session: 4639ea96-9240-4297-8e86-8ec405172d6d Authenticating user 'default' from [::1]:46893 | ||
205 | 2024.10.09 22:31:00.208568 [ 3 ] {} <Debug> HTTP-Session: 4639ea96-9240-4297-8e86-8ec405172d6d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
206 | 2024.10.09 22:31:00.208580 [ 3 ] {} <Debug> HTTP-Session: 4639ea96-9240-4297-8e86-8ec405172d6d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
207 | 2024.10.09 22:31:00.208638 [ 3 ] {} <Trace> HTTP-Session: 4639ea96-9240-4297-8e86-8ec405172d6d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
208 | 2024.10.09 22:31:00.208860 [ 3 ] {c5cae148-c09c-4ba3-a6ce-254927aedf79} <Debug> executeQuery: (from [::1]:46893) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
209 | 2024.10.09 22:31:00.209086 [ 3 ] {c5cae148-c09c-4ba3-a6ce-254927aedf79} <Debug> DynamicQueryHandler: Done processing query | ||
210 | 2024.10.09 22:31:00.209110 [ 3 ] {} <Debug> HTTP-Session: 4639ea96-9240-4297-8e86-8ec405172d6d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
211 | 2024.10.09 22:31:00.216467 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
212 | 2024.10.09 22:31:00.216580 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
213 | 2024.10.09 22:31:00.216610 [ 3 ] {} <Debug> HTTP-Session: ae76cac5-4180-4543-93bb-2a227e59e75b Authenticating user 'default' from [::1]:46893 | ||
214 | 2024.10.09 22:31:00.216636 [ 3 ] {} <Debug> HTTP-Session: ae76cac5-4180-4543-93bb-2a227e59e75b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
215 | 2024.10.09 22:31:00.216652 [ 3 ] {} <Debug> HTTP-Session: ae76cac5-4180-4543-93bb-2a227e59e75b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
216 | 2024.10.09 22:31:00.216715 [ 3 ] {} <Trace> HTTP-Session: ae76cac5-4180-4543-93bb-2a227e59e75b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
217 | 2024.10.09 22:31:00.216915 [ 3 ] {0a126da9-4df4-4270-85a1-06c975730003} <Debug> executeQuery: (from [::1]:46893) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
218 | 2024.10.09 22:31:00.217004 [ 3 ] {0a126da9-4df4-4270-85a1-06c975730003} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
219 | 2024.10.09 22:31:00.218555 [ 3 ] {0a126da9-4df4-4270-85a1-06c975730003} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
220 | 2024.10.09 22:31:00.218580 [ 3 ] {0a126da9-4df4-4270-85a1-06c975730003} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.3427e-05 sec | ||
221 | 2024.10.09 22:31:00.218597 [ 3 ] {0a126da9-4df4-4270-85a1-06c975730003} <Trace> ReferentialDeps: No tables | ||
222 | 2024.10.09 22:31:00.218619 [ 3 ] {0a126da9-4df4-4270-85a1-06c975730003} <Trace> LoadingDeps: No tables | ||
223 | 2024.10.09 22:31:00.218647 [ 3 ] {0a126da9-4df4-4270-85a1-06c975730003} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
224 | 2024.10.09 22:31:00.218842 [ 3 ] {0a126da9-4df4-4270-85a1-06c975730003} <Debug> DynamicQueryHandler: Done processing query | ||
225 | 2024.10.09 22:31:00.218883 [ 3 ] {} <Debug> HTTP-Session: ae76cac5-4180-4543-93bb-2a227e59e75b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
226 | 2024.10.09 22:31:00.477766 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
227 | 2024.10.09 22:31:00.477882 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
228 | 2024.10.09 22:31:00.477907 [ 3 ] {} <Debug> HTTP-Session: 526c96f4-6e30-4f9d-bb25-6772525ed058 Authenticating user 'default' from [::1]:46893 | ||
229 | 2024.10.09 22:31:00.477970 [ 3 ] {} <Debug> HTTP-Session: 526c96f4-6e30-4f9d-bb25-6772525ed058 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
230 | 2024.10.09 22:31:00.477983 [ 3 ] {} <Debug> HTTP-Session: 526c96f4-6e30-4f9d-bb25-6772525ed058 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
231 | 2024.10.09 22:31:00.478036 [ 3 ] {} <Trace> HTTP-Session: 526c96f4-6e30-4f9d-bb25-6772525ed058 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
232 | 2024.10.09 22:31:00.478301 [ 3 ] {00ea1dbb-7366-4565-85bc-3de356d26f7b} <Debug> executeQuery: (from [::1]:46893) /* The version table contains metadata about the `oximeter` database */ | ||
233 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
234 | 2024.10.09 22:31:00.478374 [ 3 ] {00ea1dbb-7366-4565-85bc-3de356d26f7b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
235 | 2024.10.09 22:31:00.479602 [ 3 ] {00ea1dbb-7366-4565-85bc-3de356d26f7b} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
236 | 2024.10.09 22:31:00.485353 [ 3 ] {00ea1dbb-7366-4565-85bc-3de356d26f7b} <Debug> oximeter.version (451944c3-7c07-4bad-8bde-97d08910f8dd): Loading data parts | ||
237 | 2024.10.09 22:31:00.485891 [ 3 ] {00ea1dbb-7366-4565-85bc-3de356d26f7b} <Debug> oximeter.version (451944c3-7c07-4bad-8bde-97d08910f8dd): There are no data parts | ||
238 | 2024.10.09 22:31:00.487953 [ 3 ] {00ea1dbb-7366-4565-85bc-3de356d26f7b} <Debug> DynamicQueryHandler: Done processing query | ||
239 | 2024.10.09 22:31:00.487987 [ 3 ] {} <Debug> HTTP-Session: 526c96f4-6e30-4f9d-bb25-6772525ed058 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
240 | 2024.10.09 22:31:00.674982 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
241 | 2024.10.09 22:31:00.675119 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
242 | 2024.10.09 22:31:00.675144 [ 3 ] {} <Debug> HTTP-Session: b41b1e0c-dbcd-4ee7-b24f-ae057c4ca04e Authenticating user 'default' from [::1]:46893 | ||
243 | 2024.10.09 22:31:00.675170 [ 3 ] {} <Debug> HTTP-Session: b41b1e0c-dbcd-4ee7-b24f-ae057c4ca04e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
244 | 2024.10.09 22:31:00.675188 [ 3 ] {} <Debug> HTTP-Session: b41b1e0c-dbcd-4ee7-b24f-ae057c4ca04e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
245 | 2024.10.09 22:31:00.675248 [ 3 ] {} <Trace> HTTP-Session: b41b1e0c-dbcd-4ee7-b24f-ae057c4ca04e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
246 | 2024.10.09 22:31:00.675646 [ 3 ] {534dcd96-91e2-4155-8599-ac23e065aa4a} <Debug> executeQuery: (from [::1]:46893) /* The measurement tables contain all individual samples from each timeseries. | ||
247 | * | ||
248 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
249 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
250 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
251 | * by all samples from the same timeseries. | ||
252 | * | ||
253 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
254 | * and then uses that to index quickly into the measurements tables. | ||
255 | */ | ||
256 | 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) | ||
257 | 2024.10.09 22:31:00.675725 [ 3 ] {534dcd96-91e2-4155-8599-ac23e065aa4a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
258 | 2024.10.09 22:31:00.678111 [ 3 ] {534dcd96-91e2-4155-8599-ac23e065aa4a} <Debug> oximeter.measurements_bool (7cfccb84-e05f-4f64-b894-8eea0aff34c4): Loading data parts | ||
259 | 2024.10.09 22:31:00.679349 [ 3 ] {534dcd96-91e2-4155-8599-ac23e065aa4a} <Debug> oximeter.measurements_bool (7cfccb84-e05f-4f64-b894-8eea0aff34c4): There are no data parts | ||
260 | 2024.10.09 22:31:00.680958 [ 3 ] {534dcd96-91e2-4155-8599-ac23e065aa4a} <Debug> DynamicQueryHandler: Done processing query | ||
261 | 2024.10.09 22:31:00.680985 [ 3 ] {} <Debug> HTTP-Session: b41b1e0c-dbcd-4ee7-b24f-ae057c4ca04e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
262 | 2024.10.09 22:31:00.709412 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
263 | 2024.10.09 22:31:00.709539 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
264 | 2024.10.09 22:31:00.709569 [ 3 ] {} <Debug> HTTP-Session: 51bce635-2c0f-49ea-a152-12fd163f250e Authenticating user 'default' from [::1]:46893 | ||
265 | 2024.10.09 22:31:00.709614 [ 3 ] {} <Debug> HTTP-Session: 51bce635-2c0f-49ea-a152-12fd163f250e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
266 | 2024.10.09 22:31:00.709631 [ 3 ] {} <Debug> HTTP-Session: 51bce635-2c0f-49ea-a152-12fd163f250e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
267 | 2024.10.09 22:31:00.709691 [ 3 ] {} <Trace> HTTP-Session: 51bce635-2c0f-49ea-a152-12fd163f250e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
268 | 2024.10.09 22:31:00.710076 [ 3 ] {84f4070d-f7ec-4545-9094-4274fbd548ea} <Debug> executeQuery: (from [::1]:46893) 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) | ||
269 | 2024.10.09 22:31:00.710162 [ 3 ] {84f4070d-f7ec-4545-9094-4274fbd548ea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
270 | 2024.10.09 22:31:00.712688 [ 3 ] {84f4070d-f7ec-4545-9094-4274fbd548ea} <Debug> oximeter.measurements_i8 (55d04254-02b7-4721-a4af-bbfe1a48bf55): Loading data parts | ||
271 | 2024.10.09 22:31:00.713021 [ 3 ] {84f4070d-f7ec-4545-9094-4274fbd548ea} <Debug> oximeter.measurements_i8 (55d04254-02b7-4721-a4af-bbfe1a48bf55): There are no data parts | ||
272 | 2024.10.09 22:31:00.714599 [ 3 ] {84f4070d-f7ec-4545-9094-4274fbd548ea} <Debug> DynamicQueryHandler: Done processing query | ||
273 | 2024.10.09 22:31:00.714627 [ 3 ] {} <Debug> HTTP-Session: 51bce635-2c0f-49ea-a152-12fd163f250e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
274 | 2024.10.09 22:31:00.724343 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
275 | 2024.10.09 22:31:00.724480 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
276 | 2024.10.09 22:31:00.724506 [ 3 ] {} <Debug> HTTP-Session: a9afadbb-62dd-424e-bd74-cd800e12e805 Authenticating user 'default' from [::1]:46893 | ||
277 | 2024.10.09 22:31:00.724535 [ 3 ] {} <Debug> HTTP-Session: a9afadbb-62dd-424e-bd74-cd800e12e805 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
278 | 2024.10.09 22:31:00.724551 [ 3 ] {} <Debug> HTTP-Session: a9afadbb-62dd-424e-bd74-cd800e12e805 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
279 | 2024.10.09 22:31:00.724624 [ 3 ] {} <Trace> HTTP-Session: a9afadbb-62dd-424e-bd74-cd800e12e805 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
280 | 2024.10.09 22:31:00.725006 [ 3 ] {b1c315e8-0b49-4d35-a47c-1814b4ec8492} <Debug> executeQuery: (from [::1]:46893) 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) | ||
281 | 2024.10.09 22:31:00.725100 [ 3 ] {b1c315e8-0b49-4d35-a47c-1814b4ec8492} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
282 | 2024.10.09 22:31:00.727513 [ 3 ] {b1c315e8-0b49-4d35-a47c-1814b4ec8492} <Debug> oximeter.measurements_u8 (6fd87666-99f7-4a97-9a19-23c1daed6f53): Loading data parts | ||
283 | 2024.10.09 22:31:00.727924 [ 3 ] {b1c315e8-0b49-4d35-a47c-1814b4ec8492} <Debug> oximeter.measurements_u8 (6fd87666-99f7-4a97-9a19-23c1daed6f53): There are no data parts | ||
284 | 2024.10.09 22:31:00.729664 [ 3 ] {b1c315e8-0b49-4d35-a47c-1814b4ec8492} <Debug> DynamicQueryHandler: Done processing query | ||
285 | 2024.10.09 22:31:00.729695 [ 3 ] {} <Debug> HTTP-Session: a9afadbb-62dd-424e-bd74-cd800e12e805 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
286 | 2024.10.09 22:31:00.745172 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
287 | 2024.10.09 22:31:00.745312 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
288 | 2024.10.09 22:31:00.745341 [ 3 ] {} <Debug> HTTP-Session: d7e6f3d9-4b19-4c65-ba2d-f7910523f42a Authenticating user 'default' from [::1]:46893 | ||
289 | 2024.10.09 22:31:00.745430 [ 3 ] {} <Debug> HTTP-Session: d7e6f3d9-4b19-4c65-ba2d-f7910523f42a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
290 | 2024.10.09 22:31:00.745450 [ 3 ] {} <Debug> HTTP-Session: d7e6f3d9-4b19-4c65-ba2d-f7910523f42a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
291 | 2024.10.09 22:31:00.745633 [ 3 ] {} <Trace> HTTP-Session: d7e6f3d9-4b19-4c65-ba2d-f7910523f42a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
292 | 2024.10.09 22:31:00.746034 [ 3 ] {a3eb5776-6a18-48c7-9d05-c4796ed27b9b} <Debug> executeQuery: (from [::1]:46893) 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) | ||
293 | 2024.10.09 22:31:00.746104 [ 3 ] {a3eb5776-6a18-48c7-9d05-c4796ed27b9b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
294 | 2024.10.09 22:31:00.748460 [ 3 ] {a3eb5776-6a18-48c7-9d05-c4796ed27b9b} <Debug> oximeter.measurements_i16 (018b73d7-b44f-4e9c-9deb-528755ffd29a): Loading data parts | ||
295 | 2024.10.09 22:31:00.748764 [ 3 ] {a3eb5776-6a18-48c7-9d05-c4796ed27b9b} <Debug> oximeter.measurements_i16 (018b73d7-b44f-4e9c-9deb-528755ffd29a): There are no data parts | ||
296 | 2024.10.09 22:31:00.750506 [ 3 ] {a3eb5776-6a18-48c7-9d05-c4796ed27b9b} <Debug> DynamicQueryHandler: Done processing query | ||
297 | 2024.10.09 22:31:00.750543 [ 3 ] {} <Debug> HTTP-Session: d7e6f3d9-4b19-4c65-ba2d-f7910523f42a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
298 | 2024.10.09 22:31:00.846209 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
299 | 2024.10.09 22:31:00.846334 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
300 | 2024.10.09 22:31:00.846434 [ 3 ] {} <Debug> HTTP-Session: 378ecbed-6c3d-4d75-8b53-1e99c413ceba Authenticating user 'default' from [::1]:46893 | ||
301 | 2024.10.09 22:31:00.846466 [ 3 ] {} <Debug> HTTP-Session: 378ecbed-6c3d-4d75-8b53-1e99c413ceba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
302 | 2024.10.09 22:31:00.846483 [ 3 ] {} <Debug> HTTP-Session: 378ecbed-6c3d-4d75-8b53-1e99c413ceba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
303 | 2024.10.09 22:31:00.846553 [ 3 ] {} <Trace> HTTP-Session: 378ecbed-6c3d-4d75-8b53-1e99c413ceba Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
304 | 2024.10.09 22:31:00.846958 [ 3 ] {60f90ab0-1095-4472-be06-ab6bbfe69836} <Debug> executeQuery: (from [::1]:46893) 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) | ||
305 | 2024.10.09 22:31:00.847074 [ 3 ] {60f90ab0-1095-4472-be06-ab6bbfe69836} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
306 | 2024.10.09 22:31:00.849558 [ 3 ] {60f90ab0-1095-4472-be06-ab6bbfe69836} <Debug> oximeter.measurements_u16 (371144f2-2e4e-47ff-8647-d9bdff1c8efd): Loading data parts | ||
307 | 2024.10.09 22:31:00.849907 [ 3 ] {60f90ab0-1095-4472-be06-ab6bbfe69836} <Debug> oximeter.measurements_u16 (371144f2-2e4e-47ff-8647-d9bdff1c8efd): There are no data parts | ||
308 | 2024.10.09 22:31:00.851632 [ 3 ] {60f90ab0-1095-4472-be06-ab6bbfe69836} <Debug> DynamicQueryHandler: Done processing query | ||
309 | 2024.10.09 22:31:00.851666 [ 3 ] {} <Debug> HTTP-Session: 378ecbed-6c3d-4d75-8b53-1e99c413ceba Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
310 | 2024.10.09 22:31:00.864786 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
311 | 2024.10.09 22:31:00.864971 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
312 | 2024.10.09 22:31:00.865001 [ 3 ] {} <Debug> HTTP-Session: 305aa3fc-8823-49c8-ab31-b5a52ff23b7a Authenticating user 'default' from [::1]:46893 | ||
313 | 2024.10.09 22:31:00.865029 [ 3 ] {} <Debug> HTTP-Session: 305aa3fc-8823-49c8-ab31-b5a52ff23b7a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
314 | 2024.10.09 22:31:00.865052 [ 3 ] {} <Debug> HTTP-Session: 305aa3fc-8823-49c8-ab31-b5a52ff23b7a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
315 | 2024.10.09 22:31:00.865111 [ 3 ] {} <Trace> HTTP-Session: 305aa3fc-8823-49c8-ab31-b5a52ff23b7a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
316 | 2024.10.09 22:31:00.865512 [ 3 ] {919458d3-a74f-4aa8-9d6b-be334957f9a6} <Debug> executeQuery: (from [::1]:46893) 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) | ||
317 | 2024.10.09 22:31:00.865589 [ 3 ] {919458d3-a74f-4aa8-9d6b-be334957f9a6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
318 | 2024.10.09 22:31:00.867959 [ 3 ] {919458d3-a74f-4aa8-9d6b-be334957f9a6} <Debug> oximeter.measurements_i32 (4151ac2f-5af0-4699-8d61-7fa73272b7c0): Loading data parts | ||
319 | 2024.10.09 22:31:00.868262 [ 3 ] {919458d3-a74f-4aa8-9d6b-be334957f9a6} <Debug> oximeter.measurements_i32 (4151ac2f-5af0-4699-8d61-7fa73272b7c0): There are no data parts | ||
320 | 2024.10.09 22:31:00.869852 [ 3 ] {919458d3-a74f-4aa8-9d6b-be334957f9a6} <Debug> DynamicQueryHandler: Done processing query | ||
321 | 2024.10.09 22:31:00.869898 [ 3 ] {} <Debug> HTTP-Session: 305aa3fc-8823-49c8-ab31-b5a52ff23b7a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
322 | 2024.10.09 22:31:00.900097 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
323 | 2024.10.09 22:31:00.900223 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
324 | 2024.10.09 22:31:00.900271 [ 3 ] {} <Debug> HTTP-Session: 90bee204-47a1-447c-a404-a54bfc4e828d Authenticating user 'default' from [::1]:46893 | ||
325 | 2024.10.09 22:31:00.900301 [ 3 ] {} <Debug> HTTP-Session: 90bee204-47a1-447c-a404-a54bfc4e828d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
326 | 2024.10.09 22:31:00.900318 [ 3 ] {} <Debug> HTTP-Session: 90bee204-47a1-447c-a404-a54bfc4e828d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
327 | 2024.10.09 22:31:00.900387 [ 3 ] {} <Trace> HTTP-Session: 90bee204-47a1-447c-a404-a54bfc4e828d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
328 | 2024.10.09 22:31:00.900753 [ 3 ] {4edfd7c0-fcb2-4476-b042-575c17cf1b47} <Debug> executeQuery: (from [::1]:46893) 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) | ||
329 | 2024.10.09 22:31:00.900840 [ 3 ] {4edfd7c0-fcb2-4476-b042-575c17cf1b47} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
330 | 2024.10.09 22:31:00.904349 [ 3 ] {4edfd7c0-fcb2-4476-b042-575c17cf1b47} <Debug> oximeter.measurements_u32 (eb21aa67-ca86-46af-825f-faa8cde003fa): Loading data parts | ||
331 | 2024.10.09 22:31:00.904701 [ 3 ] {4edfd7c0-fcb2-4476-b042-575c17cf1b47} <Debug> oximeter.measurements_u32 (eb21aa67-ca86-46af-825f-faa8cde003fa): There are no data parts | ||
332 | 2024.10.09 22:31:00.906758 [ 3 ] {4edfd7c0-fcb2-4476-b042-575c17cf1b47} <Debug> DynamicQueryHandler: Done processing query | ||
333 | 2024.10.09 22:31:00.906790 [ 3 ] {} <Debug> HTTP-Session: 90bee204-47a1-447c-a404-a54bfc4e828d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
334 | 2024.10.09 22:31:00.935056 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
335 | 2024.10.09 22:31:00.935206 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
336 | 2024.10.09 22:31:00.935265 [ 3 ] {} <Debug> HTTP-Session: 4ca2f538-cd4d-481c-8574-6116f0cdab2e Authenticating user 'default' from [::1]:46893 | ||
337 | 2024.10.09 22:31:00.935392 [ 3 ] {} <Debug> HTTP-Session: 4ca2f538-cd4d-481c-8574-6116f0cdab2e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
338 | 2024.10.09 22:31:00.935423 [ 3 ] {} <Debug> HTTP-Session: 4ca2f538-cd4d-481c-8574-6116f0cdab2e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
339 | 2024.10.09 22:31:00.935485 [ 3 ] {} <Trace> HTTP-Session: 4ca2f538-cd4d-481c-8574-6116f0cdab2e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
340 | 2024.10.09 22:31:00.935874 [ 3 ] {76aecb57-b7a1-4c97-8915-c72e603e2afd} <Debug> executeQuery: (from [::1]:46893) 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) | ||
341 | 2024.10.09 22:31:00.935964 [ 3 ] {76aecb57-b7a1-4c97-8915-c72e603e2afd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
342 | 2024.10.09 22:31:00.938526 [ 3 ] {76aecb57-b7a1-4c97-8915-c72e603e2afd} <Debug> oximeter.measurements_i64 (b1bbb503-f8b7-4cb2-8f7c-faeba821f47c): Loading data parts | ||
343 | 2024.10.09 22:31:00.938912 [ 3 ] {76aecb57-b7a1-4c97-8915-c72e603e2afd} <Debug> oximeter.measurements_i64 (b1bbb503-f8b7-4cb2-8f7c-faeba821f47c): There are no data parts | ||
344 | 2024.10.09 22:31:00.940612 [ 3 ] {76aecb57-b7a1-4c97-8915-c72e603e2afd} <Debug> DynamicQueryHandler: Done processing query | ||
345 | 2024.10.09 22:31:00.940638 [ 3 ] {} <Debug> HTTP-Session: 4ca2f538-cd4d-481c-8574-6116f0cdab2e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
346 | 2024.10.09 22:31:00.949559 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
347 | 2024.10.09 22:31:00.949680 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
348 | 2024.10.09 22:31:00.949706 [ 3 ] {} <Debug> HTTP-Session: 1baa9944-7655-4003-8d3b-cf9add9f013b Authenticating user 'default' from [::1]:46893 | ||
349 | 2024.10.09 22:31:00.949750 [ 3 ] {} <Debug> HTTP-Session: 1baa9944-7655-4003-8d3b-cf9add9f013b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
350 | 2024.10.09 22:31:00.949766 [ 3 ] {} <Debug> HTTP-Session: 1baa9944-7655-4003-8d3b-cf9add9f013b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
351 | 2024.10.09 22:31:00.949841 [ 3 ] {} <Trace> HTTP-Session: 1baa9944-7655-4003-8d3b-cf9add9f013b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
352 | 2024.10.09 22:31:00.950265 [ 3 ] {9d6bcddc-109e-420a-9a5f-9d77a7a86e84} <Debug> executeQuery: (from [::1]:46893) 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) | ||
353 | 2024.10.09 22:31:00.950357 [ 3 ] {9d6bcddc-109e-420a-9a5f-9d77a7a86e84} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
354 | 2024.10.09 22:31:00.952913 [ 3 ] {9d6bcddc-109e-420a-9a5f-9d77a7a86e84} <Debug> oximeter.measurements_u64 (2f5c225f-426a-4862-8036-9f08158f454a): Loading data parts | ||
355 | 2024.10.09 22:31:00.953331 [ 3 ] {9d6bcddc-109e-420a-9a5f-9d77a7a86e84} <Debug> oximeter.measurements_u64 (2f5c225f-426a-4862-8036-9f08158f454a): There are no data parts | ||
356 | 2024.10.09 22:31:00.955247 [ 3 ] {9d6bcddc-109e-420a-9a5f-9d77a7a86e84} <Debug> DynamicQueryHandler: Done processing query | ||
357 | 2024.10.09 22:31:00.955275 [ 3 ] {} <Debug> HTTP-Session: 1baa9944-7655-4003-8d3b-cf9add9f013b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
358 | 2024.10.09 22:31:00.956409 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
359 | 2024.10.09 22:31:00.956499 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
360 | 2024.10.09 22:31:00.956529 [ 3 ] {} <Debug> HTTP-Session: 2d37d598-31e7-4411-91e2-b0fa34e06a39 Authenticating user 'default' from [::1]:46893 | ||
361 | 2024.10.09 22:31:00.956556 [ 3 ] {} <Debug> HTTP-Session: 2d37d598-31e7-4411-91e2-b0fa34e06a39 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
362 | 2024.10.09 22:31:00.956571 [ 3 ] {} <Debug> HTTP-Session: 2d37d598-31e7-4411-91e2-b0fa34e06a39 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
363 | 2024.10.09 22:31:00.956633 [ 3 ] {} <Trace> HTTP-Session: 2d37d598-31e7-4411-91e2-b0fa34e06a39 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
364 | 2024.10.09 22:31:00.956941 [ 3 ] {4284370d-c5c5-4189-a61b-b56f51830759} <Debug> executeQuery: (from [::1]:46893) 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) | ||
365 | 2024.10.09 22:31:00.957070 [ 3 ] {4284370d-c5c5-4189-a61b-b56f51830759} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
366 | 2024.10.09 22:31:00.959500 [ 3 ] {4284370d-c5c5-4189-a61b-b56f51830759} <Debug> oximeter.measurements_f32 (b7de3190-c55c-4458-9782-f46e9356369a): Loading data parts | ||
367 | 2024.10.09 22:31:00.959814 [ 3 ] {4284370d-c5c5-4189-a61b-b56f51830759} <Debug> oximeter.measurements_f32 (b7de3190-c55c-4458-9782-f46e9356369a): There are no data parts | ||
368 | 2024.10.09 22:31:00.961493 [ 3 ] {4284370d-c5c5-4189-a61b-b56f51830759} <Debug> DynamicQueryHandler: Done processing query | ||
369 | 2024.10.09 22:31:00.961520 [ 3 ] {} <Debug> HTTP-Session: 2d37d598-31e7-4411-91e2-b0fa34e06a39 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
370 | 2024.10.09 22:31:00.963830 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
371 | 2024.10.09 22:31:00.963934 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
372 | 2024.10.09 22:31:00.963963 [ 3 ] {} <Debug> HTTP-Session: c6b38586-d37f-415e-9da2-74b944d72b6f Authenticating user 'default' from [::1]:46893 | ||
373 | 2024.10.09 22:31:00.964021 [ 3 ] {} <Debug> HTTP-Session: c6b38586-d37f-415e-9da2-74b944d72b6f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
374 | 2024.10.09 22:31:00.964043 [ 3 ] {} <Debug> HTTP-Session: c6b38586-d37f-415e-9da2-74b944d72b6f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
375 | 2024.10.09 22:31:00.964098 [ 3 ] {} <Trace> HTTP-Session: c6b38586-d37f-415e-9da2-74b944d72b6f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
376 | 2024.10.09 22:31:00.964466 [ 3 ] {af3309db-7069-4a25-8596-016a7f4bbffa} <Debug> executeQuery: (from [::1]:46893) 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) | ||
377 | 2024.10.09 22:31:00.964541 [ 3 ] {af3309db-7069-4a25-8596-016a7f4bbffa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
378 | 2024.10.09 22:31:00.967033 [ 3 ] {af3309db-7069-4a25-8596-016a7f4bbffa} <Debug> oximeter.measurements_f64 (5dccff18-f51e-442e-8848-306bd2c5d55f): Loading data parts | ||
379 | 2024.10.09 22:31:00.967343 [ 3 ] {af3309db-7069-4a25-8596-016a7f4bbffa} <Debug> oximeter.measurements_f64 (5dccff18-f51e-442e-8848-306bd2c5d55f): There are no data parts | ||
380 | 2024.10.09 22:31:00.969103 [ 3 ] {af3309db-7069-4a25-8596-016a7f4bbffa} <Debug> DynamicQueryHandler: Done processing query | ||
381 | 2024.10.09 22:31:00.969146 [ 3 ] {} <Debug> HTTP-Session: c6b38586-d37f-415e-9da2-74b944d72b6f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
382 | 2024.10.09 22:31:00.969846 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
383 | 2024.10.09 22:31:00.969916 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
384 | 2024.10.09 22:31:00.969956 [ 3 ] {} <Debug> HTTP-Session: 065a1b29-a473-4201-a70b-6d4aa8ad774a Authenticating user 'default' from [::1]:46893 | ||
385 | 2024.10.09 22:31:00.969980 [ 3 ] {} <Debug> HTTP-Session: 065a1b29-a473-4201-a70b-6d4aa8ad774a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
386 | 2024.10.09 22:31:00.970019 [ 3 ] {} <Debug> HTTP-Session: 065a1b29-a473-4201-a70b-6d4aa8ad774a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
387 | 2024.10.09 22:31:00.970125 [ 3 ] {} <Trace> HTTP-Session: 065a1b29-a473-4201-a70b-6d4aa8ad774a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
388 | 2024.10.09 22:31:00.970444 [ 3 ] {828187e7-9fde-4495-b7f0-1ed458142e58} <Debug> executeQuery: (from [::1]:46893) 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) | ||
389 | 2024.10.09 22:31:00.970539 [ 3 ] {828187e7-9fde-4495-b7f0-1ed458142e58} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
390 | 2024.10.09 22:31:00.972969 [ 3 ] {828187e7-9fde-4495-b7f0-1ed458142e58} <Debug> oximeter.measurements_string (c4617c99-1a81-4236-bdb2-9d7c03a8ece2): Loading data parts | ||
391 | 2024.10.09 22:31:00.973336 [ 3 ] {828187e7-9fde-4495-b7f0-1ed458142e58} <Debug> oximeter.measurements_string (c4617c99-1a81-4236-bdb2-9d7c03a8ece2): There are no data parts | ||
392 | 2024.10.09 22:31:00.975126 [ 3 ] {828187e7-9fde-4495-b7f0-1ed458142e58} <Debug> DynamicQueryHandler: Done processing query | ||
393 | 2024.10.09 22:31:00.975173 [ 3 ] {} <Debug> HTTP-Session: 065a1b29-a473-4201-a70b-6d4aa8ad774a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
394 | 2024.10.09 22:31:00.981612 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
395 | 2024.10.09 22:31:00.981739 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
396 | 2024.10.09 22:31:00.981770 [ 3 ] {} <Debug> HTTP-Session: 6c8bf04e-c65b-4618-ae16-3a2f9e88dd45 Authenticating user 'default' from [::1]:46893 | ||
397 | 2024.10.09 22:31:00.981800 [ 3 ] {} <Debug> HTTP-Session: 6c8bf04e-c65b-4618-ae16-3a2f9e88dd45 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
398 | 2024.10.09 22:31:00.981827 [ 3 ] {} <Debug> HTTP-Session: 6c8bf04e-c65b-4618-ae16-3a2f9e88dd45 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
399 | 2024.10.09 22:31:00.981906 [ 3 ] {} <Trace> HTTP-Session: 6c8bf04e-c65b-4618-ae16-3a2f9e88dd45 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
400 | 2024.10.09 22:31:00.982313 [ 3 ] {78d8f520-00ed-470f-b512-ca5780a1eaa7} <Debug> executeQuery: (from [::1]:46893) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
401 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
402 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
403 | * a string isn't palatable for a few reasons. | ||
404 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
405 | * details. | ||
406 | */ | ||
407 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
408 | 2024.10.09 22:31:00.982397 [ 3 ] {78d8f520-00ed-470f-b512-ca5780a1eaa7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
409 | 2024.10.09 22:31:00.984832 [ 3 ] {78d8f520-00ed-470f-b512-ca5780a1eaa7} <Debug> oximeter.measurements_bytes (4cf783ea-a012-4119-b6f1-a3750c21117d): Loading data parts | ||
410 | 2024.10.09 22:31:00.985212 [ 3 ] {78d8f520-00ed-470f-b512-ca5780a1eaa7} <Debug> oximeter.measurements_bytes (4cf783ea-a012-4119-b6f1-a3750c21117d): There are no data parts | ||
411 | 2024.10.09 22:31:00.987047 [ 3 ] {78d8f520-00ed-470f-b512-ca5780a1eaa7} <Debug> DynamicQueryHandler: Done processing query | ||
412 | 2024.10.09 22:31:00.987078 [ 3 ] {} <Debug> HTTP-Session: 6c8bf04e-c65b-4618-ae16-3a2f9e88dd45 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
413 | 2024.10.09 22:31:00.991823 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
414 | 2024.10.09 22:31:00.991937 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
415 | 2024.10.09 22:31:00.991966 [ 3 ] {} <Debug> HTTP-Session: 1cb551e6-8990-44a6-b541-73c8d9b978a0 Authenticating user 'default' from [::1]:46893 | ||
416 | 2024.10.09 22:31:00.991991 [ 3 ] {} <Debug> HTTP-Session: 1cb551e6-8990-44a6-b541-73c8d9b978a0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
417 | 2024.10.09 22:31:00.992045 [ 3 ] {} <Debug> HTTP-Session: 1cb551e6-8990-44a6-b541-73c8d9b978a0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
418 | 2024.10.09 22:31:00.992098 [ 3 ] {} <Trace> HTTP-Session: 1cb551e6-8990-44a6-b541-73c8d9b978a0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
419 | 2024.10.09 22:31:00.992449 [ 3 ] {b2d6b199-7a15-4b71-a64c-7e4b78f66c9d} <Debug> executeQuery: (from [::1]:46893) 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) | ||
420 | 2024.10.09 22:31:00.992524 [ 3 ] {b2d6b199-7a15-4b71-a64c-7e4b78f66c9d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
421 | 2024.10.09 22:31:00.995237 [ 3 ] {b2d6b199-7a15-4b71-a64c-7e4b78f66c9d} <Debug> oximeter.measurements_cumulativei64 (1967233d-e9ff-4793-b37a-ef08212fa24a): Loading data parts | ||
422 | 2024.10.09 22:31:00.995590 [ 3 ] {b2d6b199-7a15-4b71-a64c-7e4b78f66c9d} <Debug> oximeter.measurements_cumulativei64 (1967233d-e9ff-4793-b37a-ef08212fa24a): There are no data parts | ||
423 | 2024.10.09 22:31:00.997394 [ 3 ] {b2d6b199-7a15-4b71-a64c-7e4b78f66c9d} <Debug> DynamicQueryHandler: Done processing query | ||
424 | 2024.10.09 22:31:00.997456 [ 3 ] {} <Debug> HTTP-Session: 1cb551e6-8990-44a6-b541-73c8d9b978a0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
425 | 2024.10.09 22:31:01.000566 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 180.67 MiB, peak 181.69 MiB, free memory in arenas 0.00 B, will set to 186.26 MiB (RSS), difference: 5.58 MiB | ||
426 | 2024.10.09 22:31:01.013578 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
427 | 2024.10.09 22:31:01.013726 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
428 | 2024.10.09 22:31:01.013758 [ 3 ] {} <Debug> HTTP-Session: 5aa6b6fc-77d3-4523-aec2-3f68cb915464 Authenticating user 'default' from [::1]:46893 | ||
429 | 2024.10.09 22:31:01.013823 [ 3 ] {} <Debug> HTTP-Session: 5aa6b6fc-77d3-4523-aec2-3f68cb915464 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
430 | 2024.10.09 22:31:01.013858 [ 3 ] {} <Debug> HTTP-Session: 5aa6b6fc-77d3-4523-aec2-3f68cb915464 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
431 | 2024.10.09 22:31:01.013919 [ 3 ] {} <Trace> HTTP-Session: 5aa6b6fc-77d3-4523-aec2-3f68cb915464 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
432 | 2024.10.09 22:31:01.014345 [ 3 ] {cc2b0f3e-b18f-4f03-8530-5854884e6bc3} <Debug> executeQuery: (from [::1]:46893) 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) | ||
433 | 2024.10.09 22:31:01.014422 [ 3 ] {cc2b0f3e-b18f-4f03-8530-5854884e6bc3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
434 | 2024.10.09 22:31:01.017467 [ 3 ] {cc2b0f3e-b18f-4f03-8530-5854884e6bc3} <Debug> oximeter.measurements_cumulativeu64 (fb512d8b-62bf-4891-ad57-26a66f172b3d): Loading data parts | ||
435 | 2024.10.09 22:31:01.018161 [ 3 ] {cc2b0f3e-b18f-4f03-8530-5854884e6bc3} <Debug> oximeter.measurements_cumulativeu64 (fb512d8b-62bf-4891-ad57-26a66f172b3d): There are no data parts | ||
436 | 2024.10.09 22:31:01.020098 [ 3 ] {cc2b0f3e-b18f-4f03-8530-5854884e6bc3} <Debug> DynamicQueryHandler: Done processing query | ||
437 | 2024.10.09 22:31:01.020140 [ 3 ] {} <Debug> HTTP-Session: 5aa6b6fc-77d3-4523-aec2-3f68cb915464 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
438 | 2024.10.09 22:31:01.027719 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
439 | 2024.10.09 22:31:01.027842 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
440 | 2024.10.09 22:31:01.027888 [ 3 ] {} <Debug> HTTP-Session: 84b7006c-b20f-4a3e-80d3-20d268460c07 Authenticating user 'default' from [::1]:46893 | ||
441 | 2024.10.09 22:31:01.027916 [ 3 ] {} <Debug> HTTP-Session: 84b7006c-b20f-4a3e-80d3-20d268460c07 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
442 | 2024.10.09 22:31:01.027930 [ 3 ] {} <Debug> HTTP-Session: 84b7006c-b20f-4a3e-80d3-20d268460c07 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
443 | 2024.10.09 22:31:01.027995 [ 3 ] {} <Trace> HTTP-Session: 84b7006c-b20f-4a3e-80d3-20d268460c07 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
444 | 2024.10.09 22:31:01.028390 [ 3 ] {77fef7bf-d303-4d4c-8925-d1d5cb93fbc5} <Debug> executeQuery: (from [::1]:46893) 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) | ||
445 | 2024.10.09 22:31:01.028477 [ 3 ] {77fef7bf-d303-4d4c-8925-d1d5cb93fbc5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
446 | 2024.10.09 22:31:01.031101 [ 3 ] {77fef7bf-d303-4d4c-8925-d1d5cb93fbc5} <Debug> oximeter.measurements_cumulativef32 (e5d6d102-2b3c-4041-90db-53af3e922783): Loading data parts | ||
447 | 2024.10.09 22:31:01.032774 [ 3 ] {77fef7bf-d303-4d4c-8925-d1d5cb93fbc5} <Debug> oximeter.measurements_cumulativef32 (e5d6d102-2b3c-4041-90db-53af3e922783): There are no data parts | ||
448 | 2024.10.09 22:31:01.038562 [ 3 ] {77fef7bf-d303-4d4c-8925-d1d5cb93fbc5} <Debug> DynamicQueryHandler: Done processing query | ||
449 | 2024.10.09 22:31:01.038604 [ 3 ] {} <Debug> HTTP-Session: 84b7006c-b20f-4a3e-80d3-20d268460c07 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
450 | 2024.10.09 22:31:01.158495 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
451 | 2024.10.09 22:31:01.158802 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
452 | 2024.10.09 22:31:01.158889 [ 3 ] {} <Debug> HTTP-Session: 2ac16d14-39eb-48fe-a7eb-0272e3bc15dd Authenticating user 'default' from [::1]:46893 | ||
453 | 2024.10.09 22:31:01.158977 [ 3 ] {} <Debug> HTTP-Session: 2ac16d14-39eb-48fe-a7eb-0272e3bc15dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
454 | 2024.10.09 22:31:01.158994 [ 3 ] {} <Debug> HTTP-Session: 2ac16d14-39eb-48fe-a7eb-0272e3bc15dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
455 | 2024.10.09 22:31:01.159054 [ 3 ] {} <Trace> HTTP-Session: 2ac16d14-39eb-48fe-a7eb-0272e3bc15dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
456 | 2024.10.09 22:31:01.159446 [ 3 ] {e42bb8d3-4405-4f80-b879-08a8da663a9c} <Debug> executeQuery: (from [::1]:46893) 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) | ||
457 | 2024.10.09 22:31:01.159540 [ 3 ] {e42bb8d3-4405-4f80-b879-08a8da663a9c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
458 | 2024.10.09 22:31:01.162573 [ 3 ] {e42bb8d3-4405-4f80-b879-08a8da663a9c} <Debug> oximeter.measurements_cumulativef64 (4fb57070-a089-4a67-aac9-e376e25e220a): Loading data parts | ||
459 | 2024.10.09 22:31:01.162884 [ 3 ] {e42bb8d3-4405-4f80-b879-08a8da663a9c} <Debug> oximeter.measurements_cumulativef64 (4fb57070-a089-4a67-aac9-e376e25e220a): There are no data parts | ||
460 | 2024.10.09 22:31:01.164853 [ 3 ] {e42bb8d3-4405-4f80-b879-08a8da663a9c} <Debug> DynamicQueryHandler: Done processing query | ||
461 | 2024.10.09 22:31:01.164882 [ 3 ] {} <Debug> HTTP-Session: 2ac16d14-39eb-48fe-a7eb-0272e3bc15dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
462 | 2024.10.09 22:31:01.193006 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
463 | 2024.10.09 22:31:01.193179 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
464 | 2024.10.09 22:31:01.193208 [ 3 ] {} <Debug> HTTP-Session: 081bcfaa-22c9-43ff-8b3d-52d8f8a64fdd Authenticating user 'default' from [::1]:46893 | ||
465 | 2024.10.09 22:31:01.193278 [ 3 ] {} <Debug> HTTP-Session: 081bcfaa-22c9-43ff-8b3d-52d8f8a64fdd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
466 | 2024.10.09 22:31:01.193311 [ 3 ] {} <Debug> HTTP-Session: 081bcfaa-22c9-43ff-8b3d-52d8f8a64fdd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
467 | 2024.10.09 22:31:01.193373 [ 3 ] {} <Trace> HTTP-Session: 081bcfaa-22c9-43ff-8b3d-52d8f8a64fdd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
468 | 2024.10.09 22:31:01.193883 [ 3 ] {f9e1bdb5-9a9e-462a-a807-7b40d746fe63} <Debug> executeQuery: (from [::1]:46893) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
469 | * NOTE: Array types cannot be Nullable, see | ||
470 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
471 | * for more details. | ||
472 | * | ||
473 | * This means we need to use empty arrays to indicate a missing value. This | ||
474 | * is unfortunate, and at this point relies on the fact that an | ||
475 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
476 | * to figure out another way to represent missing samples here. | ||
477 | */ | ||
478 | 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) | ||
479 | 2024.10.09 22:31:01.194039 [ 3 ] {f9e1bdb5-9a9e-462a-a807-7b40d746fe63} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
480 | 2024.10.09 22:31:01.197332 [ 3 ] {f9e1bdb5-9a9e-462a-a807-7b40d746fe63} <Debug> oximeter.measurements_histogrami8 (f67487f4-bdd7-4b18-85ee-e9ec0440fc17): Loading data parts | ||
481 | 2024.10.09 22:31:01.197689 [ 3 ] {f9e1bdb5-9a9e-462a-a807-7b40d746fe63} <Debug> oximeter.measurements_histogrami8 (f67487f4-bdd7-4b18-85ee-e9ec0440fc17): There are no data parts | ||
482 | 2024.10.09 22:31:01.199591 [ 3 ] {f9e1bdb5-9a9e-462a-a807-7b40d746fe63} <Debug> DynamicQueryHandler: Done processing query | ||
483 | 2024.10.09 22:31:01.199619 [ 3 ] {} <Debug> HTTP-Session: 081bcfaa-22c9-43ff-8b3d-52d8f8a64fdd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
484 | 2024.10.09 22:31:01.205058 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
485 | 2024.10.09 22:31:01.205181 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
486 | 2024.10.09 22:31:01.205208 [ 3 ] {} <Debug> HTTP-Session: 032a4ee6-58c2-4ce2-b67a-a6094545eb4c Authenticating user 'default' from [::1]:46893 | ||
487 | 2024.10.09 22:31:01.205243 [ 3 ] {} <Debug> HTTP-Session: 032a4ee6-58c2-4ce2-b67a-a6094545eb4c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
488 | 2024.10.09 22:31:01.205259 [ 3 ] {} <Debug> HTTP-Session: 032a4ee6-58c2-4ce2-b67a-a6094545eb4c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
489 | 2024.10.09 22:31:01.205368 [ 3 ] {} <Trace> HTTP-Session: 032a4ee6-58c2-4ce2-b67a-a6094545eb4c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
490 | 2024.10.09 22:31:01.205866 [ 3 ] {509828ba-9a24-4cc4-9cfd-fc0bea48997e} <Debug> executeQuery: (from [::1]:46893) 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) | ||
491 | 2024.10.09 22:31:01.205963 [ 3 ] {509828ba-9a24-4cc4-9cfd-fc0bea48997e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
492 | 2024.10.09 22:31:01.209074 [ 3 ] {509828ba-9a24-4cc4-9cfd-fc0bea48997e} <Debug> oximeter.measurements_histogramu8 (851b3be7-be97-4e89-a644-f3ba68807352): Loading data parts | ||
493 | 2024.10.09 22:31:01.209402 [ 3 ] {509828ba-9a24-4cc4-9cfd-fc0bea48997e} <Debug> oximeter.measurements_histogramu8 (851b3be7-be97-4e89-a644-f3ba68807352): There are no data parts | ||
494 | 2024.10.09 22:31:01.211389 [ 3 ] {509828ba-9a24-4cc4-9cfd-fc0bea48997e} <Debug> DynamicQueryHandler: Done processing query | ||
495 | 2024.10.09 22:31:01.211431 [ 3 ] {} <Debug> HTTP-Session: 032a4ee6-58c2-4ce2-b67a-a6094545eb4c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
496 | 2024.10.09 22:31:01.212398 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
497 | 2024.10.09 22:31:01.212466 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
498 | 2024.10.09 22:31:01.212499 [ 3 ] {} <Debug> HTTP-Session: 296f4c45-812e-4efa-9420-3a1ff20d2c44 Authenticating user 'default' from [::1]:46893 | ||
499 | 2024.10.09 22:31:01.212559 [ 3 ] {} <Debug> HTTP-Session: 296f4c45-812e-4efa-9420-3a1ff20d2c44 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
500 | 2024.10.09 22:31:01.212582 [ 3 ] {} <Debug> HTTP-Session: 296f4c45-812e-4efa-9420-3a1ff20d2c44 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
501 | 2024.10.09 22:31:01.212643 [ 3 ] {} <Trace> HTTP-Session: 296f4c45-812e-4efa-9420-3a1ff20d2c44 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
502 | 2024.10.09 22:31:01.213033 [ 3 ] {ba9adcb6-c5a1-42f2-8541-ba1c67413eb7} <Debug> executeQuery: (from [::1]:46893) 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) | ||
503 | 2024.10.09 22:31:01.213121 [ 3 ] {ba9adcb6-c5a1-42f2-8541-ba1c67413eb7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
504 | 2024.10.09 22:31:01.215994 [ 3 ] {ba9adcb6-c5a1-42f2-8541-ba1c67413eb7} <Debug> oximeter.measurements_histogrami16 (94476df1-ecde-4475-b21d-42bb610536b3): Loading data parts | ||
505 | 2024.10.09 22:31:01.216303 [ 3 ] {ba9adcb6-c5a1-42f2-8541-ba1c67413eb7} <Debug> oximeter.measurements_histogrami16 (94476df1-ecde-4475-b21d-42bb610536b3): There are no data parts | ||
506 | 2024.10.09 22:31:01.218275 [ 3 ] {ba9adcb6-c5a1-42f2-8541-ba1c67413eb7} <Debug> DynamicQueryHandler: Done processing query | ||
507 | 2024.10.09 22:31:01.218305 [ 3 ] {} <Debug> HTTP-Session: 296f4c45-812e-4efa-9420-3a1ff20d2c44 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
508 | 2024.10.09 22:31:01.219222 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
509 | 2024.10.09 22:31:01.219331 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
510 | 2024.10.09 22:31:01.219359 [ 3 ] {} <Debug> HTTP-Session: d3741b9b-c421-4271-830b-bf833dd8b51a Authenticating user 'default' from [::1]:46893 | ||
511 | 2024.10.09 22:31:01.219385 [ 3 ] {} <Debug> HTTP-Session: d3741b9b-c421-4271-830b-bf833dd8b51a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
512 | 2024.10.09 22:31:01.219411 [ 3 ] {} <Debug> HTTP-Session: d3741b9b-c421-4271-830b-bf833dd8b51a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
513 | 2024.10.09 22:31:01.219463 [ 3 ] {} <Trace> HTTP-Session: d3741b9b-c421-4271-830b-bf833dd8b51a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
514 | 2024.10.09 22:31:01.219999 [ 3 ] {b579cbdf-9a31-4629-8378-65f57d980146} <Debug> executeQuery: (from [::1]:46893) 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) | ||
515 | 2024.10.09 22:31:01.220104 [ 3 ] {b579cbdf-9a31-4629-8378-65f57d980146} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
516 | 2024.10.09 22:31:01.223343 [ 3 ] {b579cbdf-9a31-4629-8378-65f57d980146} <Debug> oximeter.measurements_histogramu16 (85273834-edac-444a-b615-deeda99b16c0): Loading data parts | ||
517 | 2024.10.09 22:31:01.223659 [ 3 ] {b579cbdf-9a31-4629-8378-65f57d980146} <Debug> oximeter.measurements_histogramu16 (85273834-edac-444a-b615-deeda99b16c0): There are no data parts | ||
518 | 2024.10.09 22:31:01.225558 [ 3 ] {b579cbdf-9a31-4629-8378-65f57d980146} <Debug> DynamicQueryHandler: Done processing query | ||
519 | 2024.10.09 22:31:01.225590 [ 3 ] {} <Debug> HTTP-Session: d3741b9b-c421-4271-830b-bf833dd8b51a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
520 | 2024.10.09 22:31:01.228175 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
521 | 2024.10.09 22:31:01.228289 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
522 | 2024.10.09 22:31:01.228333 [ 3 ] {} <Debug> HTTP-Session: 9eaf50b7-5cb9-409e-840a-2237f37039f5 Authenticating user 'default' from [::1]:46893 | ||
523 | 2024.10.09 22:31:01.228359 [ 3 ] {} <Debug> HTTP-Session: 9eaf50b7-5cb9-409e-840a-2237f37039f5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
524 | 2024.10.09 22:31:01.228373 [ 3 ] {} <Debug> HTTP-Session: 9eaf50b7-5cb9-409e-840a-2237f37039f5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
525 | 2024.10.09 22:31:01.228422 [ 3 ] {} <Trace> HTTP-Session: 9eaf50b7-5cb9-409e-840a-2237f37039f5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
526 | 2024.10.09 22:31:01.228930 [ 3 ] {d8f3aee7-5080-4239-926a-41c379319c32} <Debug> executeQuery: (from [::1]:46893) 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) | ||
527 | 2024.10.09 22:31:01.229033 [ 3 ] {d8f3aee7-5080-4239-926a-41c379319c32} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
528 | 2024.10.09 22:31:01.232163 [ 3 ] {d8f3aee7-5080-4239-926a-41c379319c32} <Debug> oximeter.measurements_histogrami32 (29a28da7-91ba-4ce4-b275-8b98c801980c): Loading data parts | ||
529 | 2024.10.09 22:31:01.232514 [ 3 ] {d8f3aee7-5080-4239-926a-41c379319c32} <Debug> oximeter.measurements_histogrami32 (29a28da7-91ba-4ce4-b275-8b98c801980c): There are no data parts | ||
530 | 2024.10.09 22:31:01.234385 [ 3 ] {d8f3aee7-5080-4239-926a-41c379319c32} <Debug> DynamicQueryHandler: Done processing query | ||
531 | 2024.10.09 22:31:01.234413 [ 3 ] {} <Debug> HTTP-Session: 9eaf50b7-5cb9-409e-840a-2237f37039f5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
532 | 2024.10.09 22:31:01.236639 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
533 | 2024.10.09 22:31:01.236752 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
534 | 2024.10.09 22:31:01.236776 [ 3 ] {} <Debug> HTTP-Session: 5626dbf3-6205-4a34-ad36-ffc8e9ce795c Authenticating user 'default' from [::1]:46893 | ||
535 | 2024.10.09 22:31:01.236800 [ 3 ] {} <Debug> HTTP-Session: 5626dbf3-6205-4a34-ad36-ffc8e9ce795c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
536 | 2024.10.09 22:31:01.236836 [ 3 ] {} <Debug> HTTP-Session: 5626dbf3-6205-4a34-ad36-ffc8e9ce795c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
537 | 2024.10.09 22:31:01.236886 [ 3 ] {} <Trace> HTTP-Session: 5626dbf3-6205-4a34-ad36-ffc8e9ce795c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
538 | 2024.10.09 22:31:01.237387 [ 3 ] {09ac7fa2-7f24-4403-8b3c-e4f46124bd31} <Debug> executeQuery: (from [::1]:46893) 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) | ||
539 | 2024.10.09 22:31:01.237491 [ 3 ] {09ac7fa2-7f24-4403-8b3c-e4f46124bd31} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
540 | 2024.10.09 22:31:01.240549 [ 3 ] {09ac7fa2-7f24-4403-8b3c-e4f46124bd31} <Debug> oximeter.measurements_histogramu32 (3b8b2787-1fbd-4a58-91cc-136449907d56): Loading data parts | ||
541 | 2024.10.09 22:31:01.240881 [ 3 ] {09ac7fa2-7f24-4403-8b3c-e4f46124bd31} <Debug> oximeter.measurements_histogramu32 (3b8b2787-1fbd-4a58-91cc-136449907d56): There are no data parts | ||
542 | 2024.10.09 22:31:01.242812 [ 3 ] {09ac7fa2-7f24-4403-8b3c-e4f46124bd31} <Debug> DynamicQueryHandler: Done processing query | ||
543 | 2024.10.09 22:31:01.242841 [ 3 ] {} <Debug> HTTP-Session: 5626dbf3-6205-4a34-ad36-ffc8e9ce795c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
544 | 2024.10.09 22:31:01.259559 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
545 | 2024.10.09 22:31:01.259691 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
546 | 2024.10.09 22:31:01.259719 [ 3 ] {} <Debug> HTTP-Session: b1de0b6e-8252-4b98-bb99-9d7d1f96f3de Authenticating user 'default' from [::1]:46893 | ||
547 | 2024.10.09 22:31:01.259768 [ 3 ] {} <Debug> HTTP-Session: b1de0b6e-8252-4b98-bb99-9d7d1f96f3de Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
548 | 2024.10.09 22:31:01.259784 [ 3 ] {} <Debug> HTTP-Session: b1de0b6e-8252-4b98-bb99-9d7d1f96f3de Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
549 | 2024.10.09 22:31:01.259879 [ 3 ] {} <Trace> HTTP-Session: b1de0b6e-8252-4b98-bb99-9d7d1f96f3de Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
550 | 2024.10.09 22:31:01.260420 [ 3 ] {d286f98d-0ec1-41eb-97e7-03cad687dac7} <Debug> executeQuery: (from [::1]:46893) 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) | ||
551 | 2024.10.09 22:31:01.260532 [ 3 ] {d286f98d-0ec1-41eb-97e7-03cad687dac7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
552 | 2024.10.09 22:31:01.263931 [ 3 ] {d286f98d-0ec1-41eb-97e7-03cad687dac7} <Debug> oximeter.measurements_histogrami64 (3524ab47-a709-406a-9696-7d492a64ef7e): Loading data parts | ||
553 | 2024.10.09 22:31:01.264329 [ 3 ] {d286f98d-0ec1-41eb-97e7-03cad687dac7} <Debug> oximeter.measurements_histogrami64 (3524ab47-a709-406a-9696-7d492a64ef7e): There are no data parts | ||
554 | 2024.10.09 22:31:01.268660 [ 3 ] {d286f98d-0ec1-41eb-97e7-03cad687dac7} <Debug> DynamicQueryHandler: Done processing query | ||
555 | 2024.10.09 22:31:01.268694 [ 3 ] {} <Debug> HTTP-Session: b1de0b6e-8252-4b98-bb99-9d7d1f96f3de Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
556 | 2024.10.09 22:31:01.271416 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
557 | 2024.10.09 22:31:01.271528 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
558 | 2024.10.09 22:31:01.271619 [ 3 ] {} <Debug> HTTP-Session: 54ddde2b-9d98-44f9-aba6-6581a716c785 Authenticating user 'default' from [::1]:46893 | ||
559 | 2024.10.09 22:31:01.271653 [ 3 ] {} <Debug> HTTP-Session: 54ddde2b-9d98-44f9-aba6-6581a716c785 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
560 | 2024.10.09 22:31:01.271668 [ 3 ] {} <Debug> HTTP-Session: 54ddde2b-9d98-44f9-aba6-6581a716c785 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
561 | 2024.10.09 22:31:01.271733 [ 3 ] {} <Trace> HTTP-Session: 54ddde2b-9d98-44f9-aba6-6581a716c785 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
562 | 2024.10.09 22:31:01.272262 [ 3 ] {89bf458a-ef36-4536-a92c-866c2eef8e99} <Debug> executeQuery: (from [::1]:46893) 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) | ||
563 | 2024.10.09 22:31:01.272427 [ 3 ] {89bf458a-ef36-4536-a92c-866c2eef8e99} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
564 | 2024.10.09 22:31:01.276182 [ 3 ] {89bf458a-ef36-4536-a92c-866c2eef8e99} <Debug> oximeter.measurements_histogramu64 (d5bc47bc-c87d-445a-bebd-6f7fa97f8a85): Loading data parts | ||
565 | 2024.10.09 22:31:01.276558 [ 3 ] {89bf458a-ef36-4536-a92c-866c2eef8e99} <Debug> oximeter.measurements_histogramu64 (d5bc47bc-c87d-445a-bebd-6f7fa97f8a85): There are no data parts | ||
566 | 2024.10.09 22:31:01.280837 [ 3 ] {89bf458a-ef36-4536-a92c-866c2eef8e99} <Debug> DynamicQueryHandler: Done processing query | ||
567 | 2024.10.09 22:31:01.280873 [ 3 ] {} <Debug> HTTP-Session: 54ddde2b-9d98-44f9-aba6-6581a716c785 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
568 | 2024.10.09 22:31:01.282078 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
569 | 2024.10.09 22:31:01.282179 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
570 | 2024.10.09 22:31:01.282211 [ 3 ] {} <Debug> HTTP-Session: b3a1c645-9aa4-4af7-b99f-40719aaab513 Authenticating user 'default' from [::1]:46893 | ||
571 | 2024.10.09 22:31:01.282255 [ 3 ] {} <Debug> HTTP-Session: b3a1c645-9aa4-4af7-b99f-40719aaab513 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
572 | 2024.10.09 22:31:01.282272 [ 3 ] {} <Debug> HTTP-Session: b3a1c645-9aa4-4af7-b99f-40719aaab513 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
573 | 2024.10.09 22:31:01.282325 [ 3 ] {} <Trace> HTTP-Session: b3a1c645-9aa4-4af7-b99f-40719aaab513 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
574 | 2024.10.09 22:31:01.282796 [ 3 ] {d085475b-1fe1-4a6d-a53e-1f7a7a123173} <Debug> executeQuery: (from [::1]:46893) 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) | ||
575 | 2024.10.09 22:31:01.282898 [ 3 ] {d085475b-1fe1-4a6d-a53e-1f7a7a123173} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
576 | 2024.10.09 22:31:01.310304 [ 3 ] {d085475b-1fe1-4a6d-a53e-1f7a7a123173} <Debug> oximeter.measurements_histogramf32 (6a123629-4185-4534-98a5-e288fa94e7ec): Loading data parts | ||
577 | 2024.10.09 22:31:01.310736 [ 3 ] {d085475b-1fe1-4a6d-a53e-1f7a7a123173} <Debug> oximeter.measurements_histogramf32 (6a123629-4185-4534-98a5-e288fa94e7ec): There are no data parts | ||
578 | 2024.10.09 22:31:01.313255 [ 3 ] {d085475b-1fe1-4a6d-a53e-1f7a7a123173} <Debug> DynamicQueryHandler: Done processing query | ||
579 | 2024.10.09 22:31:01.313308 [ 3 ] {} <Debug> HTTP-Session: b3a1c645-9aa4-4af7-b99f-40719aaab513 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
580 | 2024.10.09 22:31:01.314363 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
581 | 2024.10.09 22:31:01.314495 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
582 | 2024.10.09 22:31:01.314540 [ 3 ] {} <Debug> HTTP-Session: 18f587f4-cf08-43fe-b719-4567f96db26f Authenticating user 'default' from [::1]:46893 | ||
583 | 2024.10.09 22:31:01.314569 [ 3 ] {} <Debug> HTTP-Session: 18f587f4-cf08-43fe-b719-4567f96db26f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
584 | 2024.10.09 22:31:01.314585 [ 3 ] {} <Debug> HTTP-Session: 18f587f4-cf08-43fe-b719-4567f96db26f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
585 | 2024.10.09 22:31:01.314648 [ 3 ] {} <Trace> HTTP-Session: 18f587f4-cf08-43fe-b719-4567f96db26f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
586 | 2024.10.09 22:31:01.332260 [ 3 ] {395c3806-73e3-49c6-a0b1-73ecd7ce9fa2} <Debug> executeQuery: (from [::1]:46893) 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) | ||
587 | 2024.10.09 22:31:01.332449 [ 3 ] {395c3806-73e3-49c6-a0b1-73ecd7ce9fa2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
588 | 2024.10.09 22:31:01.337585 [ 3 ] {395c3806-73e3-49c6-a0b1-73ecd7ce9fa2} <Debug> oximeter.measurements_histogramf64 (cf631b5c-6b61-4cab-986f-1cc9cef6a76e): Loading data parts | ||
589 | 2024.10.09 22:31:01.338023 [ 3 ] {395c3806-73e3-49c6-a0b1-73ecd7ce9fa2} <Debug> oximeter.measurements_histogramf64 (cf631b5c-6b61-4cab-986f-1cc9cef6a76e): There are no data parts | ||
590 | 2024.10.09 22:31:01.340012 [ 3 ] {395c3806-73e3-49c6-a0b1-73ecd7ce9fa2} <Debug> DynamicQueryHandler: Done processing query | ||
591 | 2024.10.09 22:31:01.340043 [ 3 ] {} <Debug> HTTP-Session: 18f587f4-cf08-43fe-b719-4567f96db26f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
592 | 2024.10.09 22:31:01.341574 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
593 | 2024.10.09 22:31:01.341718 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
594 | 2024.10.09 22:31:01.341743 [ 3 ] {} <Debug> HTTP-Session: 0589286c-7c56-4334-a1c7-f053cdf53523 Authenticating user 'default' from [::1]:46893 | ||
595 | 2024.10.09 22:31:01.341847 [ 3 ] {} <Debug> HTTP-Session: 0589286c-7c56-4334-a1c7-f053cdf53523 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
596 | 2024.10.09 22:31:01.341885 [ 3 ] {} <Debug> HTTP-Session: 0589286c-7c56-4334-a1c7-f053cdf53523 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
597 | 2024.10.09 22:31:01.341938 [ 3 ] {} <Trace> HTTP-Session: 0589286c-7c56-4334-a1c7-f053cdf53523 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
598 | 2024.10.09 22:31:01.342369 [ 3 ] {851e4835-89d9-4bac-85f1-bfb727324950} <Debug> executeQuery: (from [::1]:46893) /* The field tables store named dimensions of each timeseries. | ||
599 | * | ||
600 | * As with the measurement tables, there is one field table for each field data | ||
601 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
602 | * this behavior **must not** be relied upon for query correctness. | ||
603 | * | ||
604 | * The index for the fields differs from the measurements, however. Rows are | ||
605 | * sorted by timeseries name, then field name, field value, and finally | ||
606 | * timeseries key. This reflects the most common pattern for looking them up: | ||
607 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
608 | * usually then used to look up measurements. | ||
609 | * | ||
610 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
611 | * timeseries name and then key, since it would improve lookups where one | ||
612 | * already has the key. Realistically though, these tables are quite small and | ||
613 | * so performance benefits will be low in absolute terms. | ||
614 | * | ||
615 | * TTL: We use a materialized column to expire old field table records. This | ||
616 | * column is generated automatically by the database whenever a new row is | ||
617 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
618 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
619 | * record will remain during a deduplication, which will have the last | ||
620 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
621 | * measurement tables. | ||
622 | */ | ||
623 | 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) | ||
624 | 2024.10.09 22:31:01.342456 [ 3 ] {851e4835-89d9-4bac-85f1-bfb727324950} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
625 | 2024.10.09 22:31:01.349848 [ 3 ] {851e4835-89d9-4bac-85f1-bfb727324950} <Debug> oximeter.fields_bool (5f2ef40c-f112-415d-94a5-8d0cd471c82b): Loading data parts | ||
626 | 2024.10.09 22:31:01.350357 [ 3 ] {851e4835-89d9-4bac-85f1-bfb727324950} <Debug> oximeter.fields_bool (5f2ef40c-f112-415d-94a5-8d0cd471c82b): There are no data parts | ||
627 | 2024.10.09 22:31:01.366083 [ 3 ] {851e4835-89d9-4bac-85f1-bfb727324950} <Debug> DynamicQueryHandler: Done processing query | ||
628 | 2024.10.09 22:31:01.366131 [ 3 ] {} <Debug> HTTP-Session: 0589286c-7c56-4334-a1c7-f053cdf53523 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
629 | 2024.10.09 22:31:01.367162 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
630 | 2024.10.09 22:31:01.367253 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
631 | 2024.10.09 22:31:01.367282 [ 3 ] {} <Debug> HTTP-Session: 04ca5c8d-aaa1-4938-9f19-726317b7b08c Authenticating user 'default' from [::1]:46893 | ||
632 | 2024.10.09 22:31:01.367325 [ 3 ] {} <Debug> HTTP-Session: 04ca5c8d-aaa1-4938-9f19-726317b7b08c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
633 | 2024.10.09 22:31:01.367344 [ 3 ] {} <Debug> HTTP-Session: 04ca5c8d-aaa1-4938-9f19-726317b7b08c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
634 | 2024.10.09 22:31:01.367396 [ 3 ] {} <Trace> HTTP-Session: 04ca5c8d-aaa1-4938-9f19-726317b7b08c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
635 | 2024.10.09 22:31:01.367752 [ 3 ] {926dcc4b-ee64-4518-bef9-31b3ef41d3c5} <Debug> executeQuery: (from [::1]:46893) 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) | ||
636 | 2024.10.09 22:31:01.367843 [ 3 ] {926dcc4b-ee64-4518-bef9-31b3ef41d3c5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
637 | 2024.10.09 22:31:01.373251 [ 3 ] {926dcc4b-ee64-4518-bef9-31b3ef41d3c5} <Debug> oximeter.fields_i8 (1053333f-b452-4c6e-9224-38577934024f): Loading data parts | ||
638 | 2024.10.09 22:31:01.374056 [ 3 ] {926dcc4b-ee64-4518-bef9-31b3ef41d3c5} <Debug> oximeter.fields_i8 (1053333f-b452-4c6e-9224-38577934024f): There are no data parts | ||
639 | 2024.10.09 22:31:01.389696 [ 3 ] {926dcc4b-ee64-4518-bef9-31b3ef41d3c5} <Debug> DynamicQueryHandler: Done processing query | ||
640 | 2024.10.09 22:31:01.389746 [ 3 ] {} <Debug> HTTP-Session: 04ca5c8d-aaa1-4938-9f19-726317b7b08c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
641 | 2024.10.09 22:31:01.391712 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
642 | 2024.10.09 22:31:01.391831 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
643 | 2024.10.09 22:31:01.391859 [ 3 ] {} <Debug> HTTP-Session: 644e777e-d1ec-4c9f-af19-72eb970f0e55 Authenticating user 'default' from [::1]:46893 | ||
644 | 2024.10.09 22:31:01.391887 [ 3 ] {} <Debug> HTTP-Session: 644e777e-d1ec-4c9f-af19-72eb970f0e55 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
645 | 2024.10.09 22:31:01.391904 [ 3 ] {} <Debug> HTTP-Session: 644e777e-d1ec-4c9f-af19-72eb970f0e55 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
646 | 2024.10.09 22:31:01.391968 [ 3 ] {} <Trace> HTTP-Session: 644e777e-d1ec-4c9f-af19-72eb970f0e55 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
647 | 2024.10.09 22:31:01.392311 [ 3 ] {c77a748b-af75-4558-bf04-454bda47f370} <Debug> executeQuery: (from [::1]:46893) 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) | ||
648 | 2024.10.09 22:31:01.392400 [ 3 ] {c77a748b-af75-4558-bf04-454bda47f370} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
649 | 2024.10.09 22:31:01.403116 [ 3 ] {c77a748b-af75-4558-bf04-454bda47f370} <Debug> oximeter.fields_u8 (1cf917f0-6c70-48a7-bd8c-b4f0bd13fa38): Loading data parts | ||
650 | 2024.10.09 22:31:01.404820 [ 3 ] {c77a748b-af75-4558-bf04-454bda47f370} <Debug> oximeter.fields_u8 (1cf917f0-6c70-48a7-bd8c-b4f0bd13fa38): There are no data parts | ||
651 | 2024.10.09 22:31:01.406878 [ 3 ] {c77a748b-af75-4558-bf04-454bda47f370} <Debug> DynamicQueryHandler: Done processing query | ||
652 | 2024.10.09 22:31:01.406914 [ 3 ] {} <Debug> HTTP-Session: 644e777e-d1ec-4c9f-af19-72eb970f0e55 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
653 | 2024.10.09 22:31:01.407889 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
654 | 2024.10.09 22:31:01.408042 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
655 | 2024.10.09 22:31:01.408074 [ 3 ] {} <Debug> HTTP-Session: ac2c6392-3ae7-4d0a-94b3-92a9d14be934 Authenticating user 'default' from [::1]:46893 | ||
656 | 2024.10.09 22:31:01.408114 [ 3 ] {} <Debug> HTTP-Session: ac2c6392-3ae7-4d0a-94b3-92a9d14be934 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
657 | 2024.10.09 22:31:01.408132 [ 3 ] {} <Debug> HTTP-Session: ac2c6392-3ae7-4d0a-94b3-92a9d14be934 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
658 | 2024.10.09 22:31:01.408214 [ 3 ] {} <Trace> HTTP-Session: ac2c6392-3ae7-4d0a-94b3-92a9d14be934 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
659 | 2024.10.09 22:31:01.408550 [ 3 ] {fe79de91-05e8-4f9d-b54e-b5f50691d62a} <Debug> executeQuery: (from [::1]:46893) 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) | ||
660 | 2024.10.09 22:31:01.408630 [ 3 ] {fe79de91-05e8-4f9d-b54e-b5f50691d62a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
661 | 2024.10.09 22:31:01.411549 [ 3 ] {fe79de91-05e8-4f9d-b54e-b5f50691d62a} <Debug> oximeter.fields_i16 (994e8bbc-011e-4506-9562-c2e9d1ccfb0b): Loading data parts | ||
662 | 2024.10.09 22:31:01.412689 [ 3 ] {fe79de91-05e8-4f9d-b54e-b5f50691d62a} <Debug> oximeter.fields_i16 (994e8bbc-011e-4506-9562-c2e9d1ccfb0b): There are no data parts | ||
663 | 2024.10.09 22:31:01.414474 [ 3 ] {fe79de91-05e8-4f9d-b54e-b5f50691d62a} <Debug> DynamicQueryHandler: Done processing query | ||
664 | 2024.10.09 22:31:01.414519 [ 3 ] {} <Debug> HTTP-Session: ac2c6392-3ae7-4d0a-94b3-92a9d14be934 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
665 | 2024.10.09 22:31:01.434141 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
666 | 2024.10.09 22:31:01.434299 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
667 | 2024.10.09 22:31:01.434370 [ 3 ] {} <Debug> HTTP-Session: d103f40d-c970-4a36-948f-0eeaf7903513 Authenticating user 'default' from [::1]:46893 | ||
668 | 2024.10.09 22:31:01.434406 [ 3 ] {} <Debug> HTTP-Session: d103f40d-c970-4a36-948f-0eeaf7903513 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
669 | 2024.10.09 22:31:01.434437 [ 3 ] {} <Debug> HTTP-Session: d103f40d-c970-4a36-948f-0eeaf7903513 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
670 | 2024.10.09 22:31:01.434531 [ 3 ] {} <Trace> HTTP-Session: d103f40d-c970-4a36-948f-0eeaf7903513 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
671 | 2024.10.09 22:31:01.435073 [ 3 ] {1a920240-c2c9-4c16-b5f9-db6ff6c0b3ef} <Debug> executeQuery: (from [::1]:46893) 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) | ||
672 | 2024.10.09 22:31:01.435226 [ 3 ] {1a920240-c2c9-4c16-b5f9-db6ff6c0b3ef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
673 | 2024.10.09 22:31:01.438333 [ 3 ] {1a920240-c2c9-4c16-b5f9-db6ff6c0b3ef} <Debug> oximeter.fields_u16 (230be621-e70c-4bb7-aa48-851a841a2462): Loading data parts | ||
674 | 2024.10.09 22:31:01.438764 [ 3 ] {1a920240-c2c9-4c16-b5f9-db6ff6c0b3ef} <Debug> oximeter.fields_u16 (230be621-e70c-4bb7-aa48-851a841a2462): There are no data parts | ||
675 | 2024.10.09 22:31:01.440802 [ 3 ] {1a920240-c2c9-4c16-b5f9-db6ff6c0b3ef} <Debug> DynamicQueryHandler: Done processing query | ||
676 | 2024.10.09 22:31:01.440839 [ 3 ] {} <Debug> HTTP-Session: d103f40d-c970-4a36-948f-0eeaf7903513 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
677 | 2024.10.09 22:31:01.464781 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
678 | 2024.10.09 22:31:01.466712 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
679 | 2024.10.09 22:31:01.466748 [ 3 ] {} <Debug> HTTP-Session: 48d547a2-cece-4eea-8de7-5390a8e7eed2 Authenticating user 'default' from [::1]:46893 | ||
680 | 2024.10.09 22:31:01.466788 [ 3 ] {} <Debug> HTTP-Session: 48d547a2-cece-4eea-8de7-5390a8e7eed2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
681 | 2024.10.09 22:31:01.466819 [ 3 ] {} <Debug> HTTP-Session: 48d547a2-cece-4eea-8de7-5390a8e7eed2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
682 | 2024.10.09 22:31:01.466879 [ 3 ] {} <Trace> HTTP-Session: 48d547a2-cece-4eea-8de7-5390a8e7eed2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
683 | 2024.10.09 22:31:01.467289 [ 3 ] {9c187097-884d-4934-88fe-d41f602ff4b3} <Debug> executeQuery: (from [::1]:46893) 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) | ||
684 | 2024.10.09 22:31:01.467368 [ 3 ] {9c187097-884d-4934-88fe-d41f602ff4b3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
685 | 2024.10.09 22:31:01.469976 [ 3 ] {9c187097-884d-4934-88fe-d41f602ff4b3} <Debug> oximeter.fields_i32 (ec5df750-bb52-4ee1-9fdf-cd0e49c6956f): Loading data parts | ||
686 | 2024.10.09 22:31:01.474295 [ 3 ] {9c187097-884d-4934-88fe-d41f602ff4b3} <Debug> oximeter.fields_i32 (ec5df750-bb52-4ee1-9fdf-cd0e49c6956f): There are no data parts | ||
687 | 2024.10.09 22:31:01.476216 [ 3 ] {9c187097-884d-4934-88fe-d41f602ff4b3} <Debug> DynamicQueryHandler: Done processing query | ||
688 | 2024.10.09 22:31:01.476270 [ 3 ] {} <Debug> HTTP-Session: 48d547a2-cece-4eea-8de7-5390a8e7eed2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
689 | 2024.10.09 22:31:01.478951 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
690 | 2024.10.09 22:31:01.479038 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
691 | 2024.10.09 22:31:01.479080 [ 3 ] {} <Debug> HTTP-Session: 2e9ed599-c000-4e7e-b8dc-f4aa0ac62822 Authenticating user 'default' from [::1]:46893 | ||
692 | 2024.10.09 22:31:01.479107 [ 3 ] {} <Debug> HTTP-Session: 2e9ed599-c000-4e7e-b8dc-f4aa0ac62822 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
693 | 2024.10.09 22:31:01.479123 [ 3 ] {} <Debug> HTTP-Session: 2e9ed599-c000-4e7e-b8dc-f4aa0ac62822 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
694 | 2024.10.09 22:31:01.479180 [ 3 ] {} <Trace> HTTP-Session: 2e9ed599-c000-4e7e-b8dc-f4aa0ac62822 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
695 | 2024.10.09 22:31:01.483238 [ 3 ] {6fb64f9f-be12-41f0-bc47-41b588bd395b} <Debug> executeQuery: (from [::1]:46893) 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) | ||
696 | 2024.10.09 22:31:01.483374 [ 3 ] {6fb64f9f-be12-41f0-bc47-41b588bd395b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
697 | 2024.10.09 22:31:01.489271 [ 3 ] {6fb64f9f-be12-41f0-bc47-41b588bd395b} <Debug> oximeter.fields_u32 (9dba5e38-09ac-4a67-adf3-364b83110f81): Loading data parts | ||
698 | 2024.10.09 22:31:01.489626 [ 3 ] {6fb64f9f-be12-41f0-bc47-41b588bd395b} <Debug> oximeter.fields_u32 (9dba5e38-09ac-4a67-adf3-364b83110f81): There are no data parts | ||
699 | 2024.10.09 22:31:01.491368 [ 3 ] {6fb64f9f-be12-41f0-bc47-41b588bd395b} <Debug> DynamicQueryHandler: Done processing query | ||
700 | 2024.10.09 22:31:01.491401 [ 3 ] {} <Debug> HTTP-Session: 2e9ed599-c000-4e7e-b8dc-f4aa0ac62822 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
701 | 2024.10.09 22:31:01.492095 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
702 | 2024.10.09 22:31:01.492188 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
703 | 2024.10.09 22:31:01.492216 [ 3 ] {} <Debug> HTTP-Session: 016a7a48-2e1d-40e9-a986-704a65697171 Authenticating user 'default' from [::1]:46893 | ||
704 | 2024.10.09 22:31:01.492243 [ 3 ] {} <Debug> HTTP-Session: 016a7a48-2e1d-40e9-a986-704a65697171 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
705 | 2024.10.09 22:31:01.492271 [ 3 ] {} <Debug> HTTP-Session: 016a7a48-2e1d-40e9-a986-704a65697171 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
706 | 2024.10.09 22:31:01.492323 [ 3 ] {} <Trace> HTTP-Session: 016a7a48-2e1d-40e9-a986-704a65697171 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
707 | 2024.10.09 22:31:01.492653 [ 3 ] {a2de9e13-5b92-42d0-918b-3ae925999fb5} <Debug> executeQuery: (from [::1]:46893) 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) | ||
708 | 2024.10.09 22:31:01.492777 [ 3 ] {a2de9e13-5b92-42d0-918b-3ae925999fb5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
709 | 2024.10.09 22:31:01.497920 [ 3 ] {a2de9e13-5b92-42d0-918b-3ae925999fb5} <Debug> oximeter.fields_i64 (04178dbf-752b-4e8b-86e6-71d12f21a863): Loading data parts | ||
710 | 2024.10.09 22:31:01.498315 [ 3 ] {a2de9e13-5b92-42d0-918b-3ae925999fb5} <Debug> oximeter.fields_i64 (04178dbf-752b-4e8b-86e6-71d12f21a863): There are no data parts | ||
711 | 2024.10.09 22:31:01.505150 [ 3 ] {a2de9e13-5b92-42d0-918b-3ae925999fb5} <Debug> DynamicQueryHandler: Done processing query | ||
712 | 2024.10.09 22:31:01.505215 [ 3 ] {} <Debug> HTTP-Session: 016a7a48-2e1d-40e9-a986-704a65697171 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
713 | 2024.10.09 22:31:01.506245 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
714 | 2024.10.09 22:31:01.506336 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
715 | 2024.10.09 22:31:01.506368 [ 3 ] {} <Debug> HTTP-Session: 84b4ee41-4d45-4aac-96c8-237876bc265e Authenticating user 'default' from [::1]:46893 | ||
716 | 2024.10.09 22:31:01.506397 [ 3 ] {} <Debug> HTTP-Session: 84b4ee41-4d45-4aac-96c8-237876bc265e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
717 | 2024.10.09 22:31:01.506415 [ 3 ] {} <Debug> HTTP-Session: 84b4ee41-4d45-4aac-96c8-237876bc265e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
718 | 2024.10.09 22:31:01.506470 [ 3 ] {} <Trace> HTTP-Session: 84b4ee41-4d45-4aac-96c8-237876bc265e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
719 | 2024.10.09 22:31:01.511158 [ 3 ] {cf97dc47-389a-4d5c-95d7-0b7f1b550227} <Debug> executeQuery: (from [::1]:46893) 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) | ||
720 | 2024.10.09 22:31:01.511245 [ 3 ] {cf97dc47-389a-4d5c-95d7-0b7f1b550227} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
721 | 2024.10.09 22:31:01.514205 [ 3 ] {cf97dc47-389a-4d5c-95d7-0b7f1b550227} <Debug> oximeter.fields_u64 (edf2fc21-1094-43f3-981b-3b6172f7ede3): Loading data parts | ||
722 | 2024.10.09 22:31:01.514554 [ 3 ] {cf97dc47-389a-4d5c-95d7-0b7f1b550227} <Debug> oximeter.fields_u64 (edf2fc21-1094-43f3-981b-3b6172f7ede3): There are no data parts | ||
723 | 2024.10.09 22:31:01.518567 [ 3 ] {cf97dc47-389a-4d5c-95d7-0b7f1b550227} <Debug> DynamicQueryHandler: Done processing query | ||
724 | 2024.10.09 22:31:01.518598 [ 3 ] {} <Debug> HTTP-Session: 84b4ee41-4d45-4aac-96c8-237876bc265e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
725 | 2024.10.09 22:31:01.531108 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
726 | 2024.10.09 22:31:01.531310 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
727 | 2024.10.09 22:31:01.531344 [ 3 ] {} <Debug> HTTP-Session: 561d2d26-b3f9-48c3-9abc-9ff4ca4bab58 Authenticating user 'default' from [::1]:46893 | ||
728 | 2024.10.09 22:31:01.531374 [ 3 ] {} <Debug> HTTP-Session: 561d2d26-b3f9-48c3-9abc-9ff4ca4bab58 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
729 | 2024.10.09 22:31:01.531390 [ 3 ] {} <Debug> HTTP-Session: 561d2d26-b3f9-48c3-9abc-9ff4ca4bab58 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
730 | 2024.10.09 22:31:01.531475 [ 3 ] {} <Trace> HTTP-Session: 561d2d26-b3f9-48c3-9abc-9ff4ca4bab58 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
731 | 2024.10.09 22:31:01.531950 [ 3 ] {0b2b0a9e-9de8-41a3-86eb-6b0192f68990} <Debug> executeQuery: (from [::1]:46893) 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) | ||
732 | 2024.10.09 22:31:01.532033 [ 3 ] {0b2b0a9e-9de8-41a3-86eb-6b0192f68990} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
733 | 2024.10.09 22:31:01.535501 [ 3 ] {0b2b0a9e-9de8-41a3-86eb-6b0192f68990} <Debug> oximeter.fields_ipaddr (4af21c80-0636-4678-8975-6e3b0ea78c13): Loading data parts | ||
734 | 2024.10.09 22:31:01.540285 [ 3 ] {0b2b0a9e-9de8-41a3-86eb-6b0192f68990} <Debug> oximeter.fields_ipaddr (4af21c80-0636-4678-8975-6e3b0ea78c13): There are no data parts | ||
735 | 2024.10.09 22:31:01.548300 [ 3 ] {0b2b0a9e-9de8-41a3-86eb-6b0192f68990} <Debug> DynamicQueryHandler: Done processing query | ||
736 | 2024.10.09 22:31:01.548347 [ 3 ] {} <Debug> HTTP-Session: 561d2d26-b3f9-48c3-9abc-9ff4ca4bab58 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
737 | 2024.10.09 22:31:01.553389 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
738 | 2024.10.09 22:31:01.553492 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
739 | 2024.10.09 22:31:01.553517 [ 3 ] {} <Debug> HTTP-Session: 29229b53-70d8-44c8-8a2f-3a48f94f09cd Authenticating user 'default' from [::1]:46893 | ||
740 | 2024.10.09 22:31:01.553543 [ 3 ] {} <Debug> HTTP-Session: 29229b53-70d8-44c8-8a2f-3a48f94f09cd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
741 | 2024.10.09 22:31:01.553559 [ 3 ] {} <Debug> HTTP-Session: 29229b53-70d8-44c8-8a2f-3a48f94f09cd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
742 | 2024.10.09 22:31:01.553614 [ 3 ] {} <Trace> HTTP-Session: 29229b53-70d8-44c8-8a2f-3a48f94f09cd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
743 | 2024.10.09 22:31:01.553977 [ 3 ] {d39ab71b-c2d1-407c-85ad-e6b501ce1eb0} <Debug> executeQuery: (from [::1]:46893) 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) | ||
744 | 2024.10.09 22:31:01.554054 [ 3 ] {d39ab71b-c2d1-407c-85ad-e6b501ce1eb0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
745 | 2024.10.09 22:31:01.561136 [ 3 ] {d39ab71b-c2d1-407c-85ad-e6b501ce1eb0} <Debug> oximeter.fields_string (6353254e-0d4b-402e-b4c9-571cc8e6c0c7): Loading data parts | ||
746 | 2024.10.09 22:31:01.561438 [ 3 ] {d39ab71b-c2d1-407c-85ad-e6b501ce1eb0} <Debug> oximeter.fields_string (6353254e-0d4b-402e-b4c9-571cc8e6c0c7): There are no data parts | ||
747 | 2024.10.09 22:31:01.563475 [ 3 ] {d39ab71b-c2d1-407c-85ad-e6b501ce1eb0} <Debug> DynamicQueryHandler: Done processing query | ||
748 | 2024.10.09 22:31:01.563580 [ 3 ] {} <Debug> HTTP-Session: 29229b53-70d8-44c8-8a2f-3a48f94f09cd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
749 | 2024.10.09 22:31:01.565660 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
750 | 2024.10.09 22:31:01.565797 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
751 | 2024.10.09 22:31:01.565828 [ 3 ] {} <Debug> HTTP-Session: 952dc5b1-a63f-4c30-8947-12c69e2deca9 Authenticating user 'default' from [::1]:46893 | ||
752 | 2024.10.09 22:31:01.565855 [ 3 ] {} <Debug> HTTP-Session: 952dc5b1-a63f-4c30-8947-12c69e2deca9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
753 | 2024.10.09 22:31:01.565873 [ 3 ] {} <Debug> HTTP-Session: 952dc5b1-a63f-4c30-8947-12c69e2deca9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
754 | 2024.10.09 22:31:01.565926 [ 3 ] {} <Trace> HTTP-Session: 952dc5b1-a63f-4c30-8947-12c69e2deca9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
755 | 2024.10.09 22:31:01.566248 [ 3 ] {8cc107d4-ad21-445a-9815-faee2e426151} <Debug> executeQuery: (from [::1]:46893) 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) | ||
756 | 2024.10.09 22:31:01.566321 [ 3 ] {8cc107d4-ad21-445a-9815-faee2e426151} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
757 | 2024.10.09 22:31:01.569393 [ 3 ] {8cc107d4-ad21-445a-9815-faee2e426151} <Debug> oximeter.fields_uuid (b5f0bf2a-a6ca-4e31-aaea-a0ae9870ddb7): Loading data parts | ||
758 | 2024.10.09 22:31:01.569790 [ 3 ] {8cc107d4-ad21-445a-9815-faee2e426151} <Debug> oximeter.fields_uuid (b5f0bf2a-a6ca-4e31-aaea-a0ae9870ddb7): There are no data parts | ||
759 | 2024.10.09 22:31:01.571620 [ 3 ] {8cc107d4-ad21-445a-9815-faee2e426151} <Debug> DynamicQueryHandler: Done processing query | ||
760 | 2024.10.09 22:31:01.571653 [ 3 ] {} <Debug> HTTP-Session: 952dc5b1-a63f-4c30-8947-12c69e2deca9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
761 | 2024.10.09 22:31:01.585554 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
762 | 2024.10.09 22:31:01.585671 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
763 | 2024.10.09 22:31:01.585701 [ 3 ] {} <Debug> HTTP-Session: 34368ac4-86e8-4fc8-a8fd-6a840c9e16f5 Authenticating user 'default' from [::1]:46893 | ||
764 | 2024.10.09 22:31:01.585731 [ 3 ] {} <Debug> HTTP-Session: 34368ac4-86e8-4fc8-a8fd-6a840c9e16f5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
765 | 2024.10.09 22:31:01.585747 [ 3 ] {} <Debug> HTTP-Session: 34368ac4-86e8-4fc8-a8fd-6a840c9e16f5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
766 | 2024.10.09 22:31:01.585802 [ 3 ] {} <Trace> HTTP-Session: 34368ac4-86e8-4fc8-a8fd-6a840c9e16f5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
767 | 2024.10.09 22:31:01.586239 [ 3 ] {fed2c714-9237-4864-8c3a-5955a27593bd} <Debug> executeQuery: (from [::1]:46893) /* The timeseries schema table stores the extracted schema for the samples | ||
768 | * oximeter collects. | ||
769 | */ | ||
770 | 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) | ||
771 | 2024.10.09 22:31:01.586443 [ 3 ] {fed2c714-9237-4864-8c3a-5955a27593bd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
772 | 2024.10.09 22:31:01.589395 [ 3 ] {fed2c714-9237-4864-8c3a-5955a27593bd} <Debug> oximeter.timeseries_schema (badd20fc-6eb2-4816-a553-c7dcb150e3a4): Loading data parts | ||
773 | 2024.10.09 22:31:01.589745 [ 3 ] {fed2c714-9237-4864-8c3a-5955a27593bd} <Debug> oximeter.timeseries_schema (badd20fc-6eb2-4816-a553-c7dcb150e3a4): There are no data parts | ||
774 | 2024.10.09 22:31:01.591949 [ 3 ] {fed2c714-9237-4864-8c3a-5955a27593bd} <Debug> DynamicQueryHandler: Done processing query | ||
775 | 2024.10.09 22:31:01.591979 [ 3 ] {} <Debug> HTTP-Session: 34368ac4-86e8-4fc8-a8fd-6a840c9e16f5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
776 | 2024.10.09 22:31:01.603645 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:46893, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
777 | 2024.10.09 22:31:01.603771 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
778 | 2024.10.09 22:31:01.603801 [ 3 ] {} <Debug> HTTP-Session: dcb15a44-1886-4073-bb6f-005c47cf1c49 Authenticating user 'default' from [::1]:46893 | ||
779 | 2024.10.09 22:31:01.603832 [ 3 ] {} <Debug> HTTP-Session: dcb15a44-1886-4073-bb6f-005c47cf1c49 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
780 | 2024.10.09 22:31:01.603848 [ 3 ] {} <Debug> HTTP-Session: dcb15a44-1886-4073-bb6f-005c47cf1c49 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
781 | 2024.10.09 22:31:01.603981 [ 3 ] {} <Trace> HTTP-Session: dcb15a44-1886-4073-bb6f-005c47cf1c49 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
782 | 2024.10.09 22:31:01.604251 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Debug> executeQuery: (from [::1]:46893) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
783 | 2024.10.09 22:31:01.604434 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
784 | 2024.10.09 22:31:01.605854 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Trace> oximeter.version (451944c3-7c07-4bad-8bde-97d08910f8dd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
785 | 2024.10.09 22:31:01.605910 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.34 GiB. | ||
786 | 2024.10.09 22:31:01.607223 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
787 | 2024.10.09 22:31:01.607762 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Trace> oximeter.version (451944c3-7c07-4bad-8bde-97d08910f8dd): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
788 | 2024.10.09 22:31:01.608074 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.003886 sec., 257.3340195573855 rows/sec., 4.02 KiB/sec. | ||
789 | 2024.10.09 22:31:01.608434 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Debug> DynamicQueryHandler: Done processing query | ||
790 | 2024.10.09 22:31:01.608468 [ 3 ] {f763073e-aff6-4f88-bc5c-c49d84478473} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
791 | 2024.10.09 22:31:01.608488 [ 3 ] {} <Debug> HTTP-Session: dcb15a44-1886-4073-bb6f-005c47cf1c49 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
792 | 2024.10.09 22:31:02.000291 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 188.53 MiB, peak 193.67 MiB, free memory in arenas 0.00 B, will set to 187.44 MiB (RSS), difference: -1.10 MiB | ||
793 | 2024.10.09 22:31:02.033945 [ 201 ] {} <Debug> DNSResolver: Updating DNS cache | ||
794 | 2024.10.09 22:31:02.033986 [ 201 ] {} <Debug> DNSResolver: Updated DNS cache |