1 | 2024.10.09 22:37:43.858986 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 14104 | ||
2 | 2024.10.09 22:37:43.859197 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.10.09 22:37:43.859266 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.10.09 22:37:43.889047 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.10.09 22:37:44.024419 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.10.09 22:37:44.024487 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.10.09 22:37:44.024499 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.10.09 22:37:44.024587 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_delete_volume_region_replacement_state_replacement_done.14093.1-clickhouse-OWhmRl/datastore/tmp/ to store temporary data in it | ||
9 | 2024.10.09 22:37:44.028291 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.10.09 22:37:44.029769 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
11 | 2024.10.09 22:37:44.030374 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
12 | 2024.10.09 22:37:44.031096 [ 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:37:44.032155 [ 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:37:44.032245 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.10.09 22:37:44.032367 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.10.09 22:37:44.033308 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.10.09 22:37:44.191047 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.10.09 22:37:44.192594 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.10.09 22:37:44.196765 [ 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:37:44.196849 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
21 | 2024.10.09 22:37:44.209002 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
22 | 2024.10.09 22:37:44.209631 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
23 | 2024.10.09 22:37:44.211877 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
24 | 2024.10.09 22:37:44.212602 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
25 | 2024.10.09 22:37:44.214034 [ 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:37:44.215567 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.10.09 22:37:44.218305 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.10.09 22:37:44.225909 [ 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:37:44.233120 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.10.09 22:37:44.233171 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_delete_volume_region_replacement_state_replacement_done.14093.1-clickhouse-OWhmRl/datastore/ | ||
31 | 2024.10.09 22:37:44.233243 [ 47 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.10.09 22:37:44.233501 [ 47 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.10.09 22:37:44.281425 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.10.09 22:37:44.281468 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00021842 sec | ||
35 | 2024.10.09 22:37:44.281506 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.10.09 22:37:44.281519 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.10.09 22:37:44.281680 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.10.09 22:37:44.281737 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
39 | 2024.10.09 22:37:44.281755 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
40 | 2024.10.09 22:37:44.281784 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.10.09 22:37:44.281803 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.10.09 22:37:44.281816 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.10.09 22:37:44.281844 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.10.09 22:37:44.281909 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
45 | 2024.10.09 22:37:44.281933 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2024.10.09 22:37:44.281966 [ 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:37:44.282080 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
48 | 2024.10.09 22:37:44.282108 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2024.10.09 22:37:44.282122 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2024.10.09 22:37:44.282198 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.10.09 22:37:44.282222 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.10.09 22:37:44.282236 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2024.10.09 22:37:44.282267 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2024.10.09 22:37:44.282289 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2024.10.09 22:37:44.368042 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.10.09 22:37:44.372604 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.10.09 22:37:44.372642 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.1397e-05 sec | ||
58 | 2024.10.09 22:37:44.372658 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.10.09 22:37:44.372669 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.10.09 22:37:44.372728 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.10.09 22:37:44.372970 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_delete_volume_region_replacement_state_replacement_done.14093.1-clickhouse-OWhmRl/datastore/user_defined/ | ||
62 | 2024.10.09 22:37:44.374062 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.10.09 22:37:44.374090 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.10.09 22:37:44.374104 [ 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:37:44.374132 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.10.09 22:37:44.376550 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 59946 | ||
67 | 2024.10.09 22:37:44.376831 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 37841 | ||
68 | 2024.10.09 22:37:44.379761 [ 1 ] {} <Warning> Application: Listen [::1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: [::1]:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host> | ||
69 | 2024.10.09 22:37:44.379927 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 44232 | ||
70 | 2024.10.09 22:37:44.380009 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 58768 | ||
71 | 2024.10.09 22:37:44.380129 [ 1 ] {} <Warning> Application: Listen [127.0.0.1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 125, Net Exception: Address already in use: 127.0.0.1:9004 (version 23.8.7.1). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host> | ||
72 | 2024.10.09 22:37:44.380190 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
73 | 2024.10.09 22:37:44.384128 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.88 MiB, peak 16.06 MiB, free memory in arenas 0.00 B, will set to 139.55 MiB (RSS), difference: 129.67 MiB | ||
74 | 2024.10.09 22:37:44.387750 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.0098e-05 sec. | ||
75 | 2024.10.09 22:37:44.389361 [ 1 ] {} <Information> Application: Listening for http://[::1]:59946 | ||
76 | 2024.10.09 22:37:44.389506 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:37841 | ||
77 | 2024.10.09 22:37:44.389570 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:44232 | ||
78 | 2024.10.09 22:37:44.389626 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:58768 | ||
79 | 2024.10.09 22:37:44.389642 [ 1 ] {} <Information> Application: Ready for connections. | ||
80 | 2024.10.09 22:37:54.286839 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
81 | 2024.10.09 22:37:54.287103 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
82 | 2024.10.09 22:37:54.287141 [ 3 ] {} <Debug> HTTP-Session: d80b4a23-d736-4124-a7ce-b039f5fdb774 Authenticating user 'default' from [::1]:41514 | ||
83 | 2024.10.09 22:37:54.287172 [ 3 ] {} <Debug> HTTP-Session: d80b4a23-d736-4124-a7ce-b039f5fdb774 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
84 | 2024.10.09 22:37:54.287189 [ 3 ] {} <Debug> HTTP-Session: d80b4a23-d736-4124-a7ce-b039f5fdb774 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
85 | 2024.10.09 22:37:54.287300 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
86 | 2024.10.09 22:37:54.287351 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
87 | 2024.10.09 22:37:54.287379 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
88 | 2024.10.09 22:37:54.287441 [ 3 ] {} <Trace> HTTP-Session: d80b4a23-d736-4124-a7ce-b039f5fdb774 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
89 | 2024.10.09 22:37:54.288074 [ 3 ] {952a993d-f93c-44e2-a277-32df714bb7fc} <Debug> executeQuery: (from [::1]:41514) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
90 | 2024.10.09 22:37:54.297671 [ 3 ] {952a993d-f93c-44e2-a277-32df714bb7fc} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:41514) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
91 | |||
92 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
93 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
94 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
95 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
96 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
97 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
98 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
99 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
100 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
101 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
102 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
103 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
104 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
105 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
106 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
107 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
108 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
109 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
110 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
111 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
112 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
113 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
114 | |||
115 | 2024.10.09 22:37:54.297969 [ 3 ] {952a993d-f93c-44e2-a277-32df714bb7fc} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
116 | |||
117 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
118 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
119 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
120 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
121 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
122 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
123 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
124 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
125 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
126 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
127 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
128 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
129 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
130 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
131 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
132 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
133 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
134 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
135 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
136 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
137 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
138 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
139 | (version 23.8.7.1) | ||
140 | 2024.10.09 22:37:54.298376 [ 3 ] {} <Debug> HTTP-Session: d80b4a23-d736-4124-a7ce-b039f5fdb774 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
141 | 2024.10.09 22:37:54.364229 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
142 | 2024.10.09 22:37:54.364370 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
143 | 2024.10.09 22:37:54.364421 [ 3 ] {} <Debug> HTTP-Session: 67388f43-e9bf-472e-8bf6-eaf53f6d953d Authenticating user 'default' from [::1]:41514 | ||
144 | 2024.10.09 22:37:54.364450 [ 3 ] {} <Debug> HTTP-Session: 67388f43-e9bf-472e-8bf6-eaf53f6d953d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
145 | 2024.10.09 22:37:54.364467 [ 3 ] {} <Debug> HTTP-Session: 67388f43-e9bf-472e-8bf6-eaf53f6d953d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
146 | 2024.10.09 22:37:54.364534 [ 3 ] {} <Trace> HTTP-Session: 67388f43-e9bf-472e-8bf6-eaf53f6d953d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
147 | 2024.10.09 22:37:54.364841 [ 3 ] {0f34cd5a-3180-422b-a539-cad0156c84ac} <Debug> executeQuery: (from [::1]:41514) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
148 | 2024.10.09 22:37:54.365268 [ 3 ] {0f34cd5a-3180-422b-a539-cad0156c84ac} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:41514) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
149 | |||
150 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
151 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
152 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
153 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
154 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
155 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
156 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
157 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
158 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
159 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
160 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
161 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
162 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
163 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
164 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
165 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
166 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
167 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
168 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
169 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
170 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
171 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
172 | |||
173 | 2024.10.09 22:37:54.365447 [ 3 ] {0f34cd5a-3180-422b-a539-cad0156c84ac} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
174 | |||
175 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
176 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
177 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
178 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
179 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
180 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
181 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
182 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
183 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
184 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
185 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
186 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
187 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
188 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
189 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
190 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
191 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
192 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
193 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
194 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
195 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
196 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
197 | (version 23.8.7.1) | ||
198 | 2024.10.09 22:37:54.365659 [ 3 ] {} <Debug> HTTP-Session: 67388f43-e9bf-472e-8bf6-eaf53f6d953d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
199 | 2024.10.09 22:37:54.429608 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
200 | 2024.10.09 22:37:54.429719 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
201 | 2024.10.09 22:37:54.429780 [ 3 ] {} <Debug> HTTP-Session: 92b64c2c-a8bd-40a1-a10f-eb339c8c60a1 Authenticating user 'default' from [::1]:41514 | ||
202 | 2024.10.09 22:37:54.429808 [ 3 ] {} <Debug> HTTP-Session: 92b64c2c-a8bd-40a1-a10f-eb339c8c60a1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
203 | 2024.10.09 22:37:54.429826 [ 3 ] {} <Debug> HTTP-Session: 92b64c2c-a8bd-40a1-a10f-eb339c8c60a1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
204 | 2024.10.09 22:37:54.429891 [ 3 ] {} <Trace> HTTP-Session: 92b64c2c-a8bd-40a1-a10f-eb339c8c60a1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
205 | 2024.10.09 22:37:54.430183 [ 3 ] {cbb8b1da-cf61-4106-8bce-344ecce1e56e} <Debug> executeQuery: (from [::1]:41514) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
206 | 2024.10.09 22:37:54.430516 [ 3 ] {cbb8b1da-cf61-4106-8bce-344ecce1e56e} <Debug> DynamicQueryHandler: Done processing query | ||
207 | 2024.10.09 22:37:54.430551 [ 3 ] {} <Debug> HTTP-Session: 92b64c2c-a8bd-40a1-a10f-eb339c8c60a1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
208 | 2024.10.09 22:37:54.431823 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
209 | 2024.10.09 22:37:54.431902 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
210 | 2024.10.09 22:37:54.431941 [ 3 ] {} <Debug> HTTP-Session: 8af23a39-2895-4199-b0c9-93a81229a8eb Authenticating user 'default' from [::1]:41514 | ||
211 | 2024.10.09 22:37:54.431963 [ 3 ] {} <Debug> HTTP-Session: 8af23a39-2895-4199-b0c9-93a81229a8eb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
212 | 2024.10.09 22:37:54.431981 [ 3 ] {} <Debug> HTTP-Session: 8af23a39-2895-4199-b0c9-93a81229a8eb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
213 | 2024.10.09 22:37:54.432033 [ 3 ] {} <Trace> HTTP-Session: 8af23a39-2895-4199-b0c9-93a81229a8eb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
214 | 2024.10.09 22:37:54.432177 [ 3 ] {0216fc2c-8a2a-44b0-8138-c45b2082d478} <Debug> executeQuery: (from [::1]:41514) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
215 | 2024.10.09 22:37:54.432264 [ 3 ] {0216fc2c-8a2a-44b0-8138-c45b2082d478} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
216 | 2024.10.09 22:37:54.433789 [ 3 ] {0216fc2c-8a2a-44b0-8138-c45b2082d478} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
217 | 2024.10.09 22:37:54.433817 [ 3 ] {0216fc2c-8a2a-44b0-8138-c45b2082d478} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.9796e-05 sec | ||
218 | 2024.10.09 22:37:54.433832 [ 3 ] {0216fc2c-8a2a-44b0-8138-c45b2082d478} <Trace> ReferentialDeps: No tables | ||
219 | 2024.10.09 22:37:54.433844 [ 3 ] {0216fc2c-8a2a-44b0-8138-c45b2082d478} <Trace> LoadingDeps: No tables | ||
220 | 2024.10.09 22:37:54.433883 [ 3 ] {0216fc2c-8a2a-44b0-8138-c45b2082d478} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
221 | 2024.10.09 22:37:54.434070 [ 3 ] {0216fc2c-8a2a-44b0-8138-c45b2082d478} <Debug> DynamicQueryHandler: Done processing query | ||
222 | 2024.10.09 22:37:54.434100 [ 3 ] {} <Debug> HTTP-Session: 8af23a39-2895-4199-b0c9-93a81229a8eb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
223 | 2024.10.09 22:37:54.436482 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
224 | 2024.10.09 22:37:54.436604 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
225 | 2024.10.09 22:37:54.436636 [ 3 ] {} <Debug> HTTP-Session: a5e56756-1f53-46be-97bd-7ac773aa51fd Authenticating user 'default' from [::1]:41514 | ||
226 | 2024.10.09 22:37:54.436670 [ 3 ] {} <Debug> HTTP-Session: a5e56756-1f53-46be-97bd-7ac773aa51fd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
227 | 2024.10.09 22:37:54.436687 [ 3 ] {} <Debug> HTTP-Session: a5e56756-1f53-46be-97bd-7ac773aa51fd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
228 | 2024.10.09 22:37:54.436738 [ 3 ] {} <Trace> HTTP-Session: a5e56756-1f53-46be-97bd-7ac773aa51fd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
229 | 2024.10.09 22:37:54.437021 [ 3 ] {01ad3683-40fe-4f0c-bb47-c7645adc1bf1} <Debug> executeQuery: (from [::1]:41514) /* The version table contains metadata about the `oximeter` database */ | ||
230 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
231 | 2024.10.09 22:37:54.437107 [ 3 ] {01ad3683-40fe-4f0c-bb47-c7645adc1bf1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
232 | 2024.10.09 22:37:54.439088 [ 3 ] {01ad3683-40fe-4f0c-bb47-c7645adc1bf1} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
233 | 2024.10.09 22:37:54.440425 [ 3 ] {01ad3683-40fe-4f0c-bb47-c7645adc1bf1} <Debug> oximeter.version (d7692977-8387-4cc2-9e28-a82e99944a62): Loading data parts | ||
234 | 2024.10.09 22:37:54.441280 [ 3 ] {01ad3683-40fe-4f0c-bb47-c7645adc1bf1} <Debug> oximeter.version (d7692977-8387-4cc2-9e28-a82e99944a62): There are no data parts | ||
235 | 2024.10.09 22:37:54.443231 [ 3 ] {01ad3683-40fe-4f0c-bb47-c7645adc1bf1} <Debug> DynamicQueryHandler: Done processing query | ||
236 | 2024.10.09 22:37:54.443269 [ 3 ] {} <Debug> HTTP-Session: a5e56756-1f53-46be-97bd-7ac773aa51fd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
237 | 2024.10.09 22:37:54.449656 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
238 | 2024.10.09 22:37:54.449768 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
239 | 2024.10.09 22:37:54.449815 [ 3 ] {} <Debug> HTTP-Session: dbd26086-6045-4c6e-925b-96c09fa1a390 Authenticating user 'default' from [::1]:41514 | ||
240 | 2024.10.09 22:37:54.449842 [ 3 ] {} <Debug> HTTP-Session: dbd26086-6045-4c6e-925b-96c09fa1a390 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
241 | 2024.10.09 22:37:54.449854 [ 3 ] {} <Debug> HTTP-Session: dbd26086-6045-4c6e-925b-96c09fa1a390 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
242 | 2024.10.09 22:37:54.449917 [ 3 ] {} <Trace> HTTP-Session: dbd26086-6045-4c6e-925b-96c09fa1a390 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
243 | 2024.10.09 22:37:54.450280 [ 3 ] {a51e0e58-72f1-446a-8ba5-13c378e2073d} <Debug> executeQuery: (from [::1]:41514) /* The measurement tables contain all individual samples from each timeseries. | ||
244 | * | ||
245 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
246 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
247 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
248 | * by all samples from the same timeseries. | ||
249 | * | ||
250 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
251 | * and then uses that to index quickly into the measurements tables. | ||
252 | */ | ||
253 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
254 | 2024.10.09 22:37:54.450359 [ 3 ] {a51e0e58-72f1-446a-8ba5-13c378e2073d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
255 | 2024.10.09 22:37:54.452800 [ 3 ] {a51e0e58-72f1-446a-8ba5-13c378e2073d} <Debug> oximeter.measurements_bool (d344d840-6ac3-4c61-a789-c836d97b7160): Loading data parts | ||
256 | 2024.10.09 22:37:54.453161 [ 3 ] {a51e0e58-72f1-446a-8ba5-13c378e2073d} <Debug> oximeter.measurements_bool (d344d840-6ac3-4c61-a789-c836d97b7160): There are no data parts | ||
257 | 2024.10.09 22:37:54.455005 [ 3 ] {a51e0e58-72f1-446a-8ba5-13c378e2073d} <Debug> DynamicQueryHandler: Done processing query | ||
258 | 2024.10.09 22:37:54.455042 [ 3 ] {} <Debug> HTTP-Session: dbd26086-6045-4c6e-925b-96c09fa1a390 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
259 | 2024.10.09 22:37:54.455870 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
260 | 2024.10.09 22:37:54.455977 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
261 | 2024.10.09 22:37:54.456004 [ 3 ] {} <Debug> HTTP-Session: 5c9ea468-f409-4ee4-b6e8-1d2da742770a Authenticating user 'default' from [::1]:41514 | ||
262 | 2024.10.09 22:37:54.456045 [ 3 ] {} <Debug> HTTP-Session: 5c9ea468-f409-4ee4-b6e8-1d2da742770a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
263 | 2024.10.09 22:37:54.456061 [ 3 ] {} <Debug> HTTP-Session: 5c9ea468-f409-4ee4-b6e8-1d2da742770a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
264 | 2024.10.09 22:37:54.456114 [ 3 ] {} <Trace> HTTP-Session: 5c9ea468-f409-4ee4-b6e8-1d2da742770a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
265 | 2024.10.09 22:37:54.456408 [ 3 ] {3dc2eacf-f1bf-4ca5-9b28-44e6d7c3fcb6} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
266 | 2024.10.09 22:37:54.456477 [ 3 ] {3dc2eacf-f1bf-4ca5-9b28-44e6d7c3fcb6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
267 | 2024.10.09 22:37:54.459301 [ 3 ] {3dc2eacf-f1bf-4ca5-9b28-44e6d7c3fcb6} <Debug> oximeter.measurements_i8 (12f36b43-f0dd-465c-a7b7-73f8b85f7f19): Loading data parts | ||
268 | 2024.10.09 22:37:54.459774 [ 3 ] {3dc2eacf-f1bf-4ca5-9b28-44e6d7c3fcb6} <Debug> oximeter.measurements_i8 (12f36b43-f0dd-465c-a7b7-73f8b85f7f19): There are no data parts | ||
269 | 2024.10.09 22:37:54.461703 [ 3 ] {3dc2eacf-f1bf-4ca5-9b28-44e6d7c3fcb6} <Debug> DynamicQueryHandler: Done processing query | ||
270 | 2024.10.09 22:37:54.461751 [ 3 ] {} <Debug> HTTP-Session: 5c9ea468-f409-4ee4-b6e8-1d2da742770a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
271 | 2024.10.09 22:37:54.462591 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
272 | 2024.10.09 22:37:54.462667 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
273 | 2024.10.09 22:37:54.462708 [ 3 ] {} <Debug> HTTP-Session: b99b8c3c-e081-47ac-9146-ef27708d6364 Authenticating user 'default' from [::1]:41514 | ||
274 | 2024.10.09 22:37:54.462739 [ 3 ] {} <Debug> HTTP-Session: b99b8c3c-e081-47ac-9146-ef27708d6364 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
275 | 2024.10.09 22:37:54.462753 [ 3 ] {} <Debug> HTTP-Session: b99b8c3c-e081-47ac-9146-ef27708d6364 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
276 | 2024.10.09 22:37:54.462823 [ 3 ] {} <Trace> HTTP-Session: b99b8c3c-e081-47ac-9146-ef27708d6364 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
277 | 2024.10.09 22:37:54.463228 [ 3 ] {70da3f71-e897-439d-a230-ea8a527243a6} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
278 | 2024.10.09 22:37:54.463317 [ 3 ] {70da3f71-e897-439d-a230-ea8a527243a6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
279 | 2024.10.09 22:37:54.465718 [ 3 ] {70da3f71-e897-439d-a230-ea8a527243a6} <Debug> oximeter.measurements_u8 (dcdd781b-4534-4e0b-9d32-8d871bbc60ad): Loading data parts | ||
280 | 2024.10.09 22:37:54.466025 [ 3 ] {70da3f71-e897-439d-a230-ea8a527243a6} <Debug> oximeter.measurements_u8 (dcdd781b-4534-4e0b-9d32-8d871bbc60ad): There are no data parts | ||
281 | 2024.10.09 22:37:54.467817 [ 3 ] {70da3f71-e897-439d-a230-ea8a527243a6} <Debug> DynamicQueryHandler: Done processing query | ||
282 | 2024.10.09 22:37:54.467848 [ 3 ] {} <Debug> HTTP-Session: b99b8c3c-e081-47ac-9146-ef27708d6364 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
283 | 2024.10.09 22:37:54.468566 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
284 | 2024.10.09 22:37:54.468648 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
285 | 2024.10.09 22:37:54.468671 [ 3 ] {} <Debug> HTTP-Session: a703f7f7-17d6-40b9-b039-5896f964c59b Authenticating user 'default' from [::1]:41514 | ||
286 | 2024.10.09 22:37:54.468694 [ 3 ] {} <Debug> HTTP-Session: a703f7f7-17d6-40b9-b039-5896f964c59b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
287 | 2024.10.09 22:37:54.468713 [ 3 ] {} <Debug> HTTP-Session: a703f7f7-17d6-40b9-b039-5896f964c59b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
288 | 2024.10.09 22:37:54.468759 [ 3 ] {} <Trace> HTTP-Session: a703f7f7-17d6-40b9-b039-5896f964c59b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
289 | 2024.10.09 22:37:54.469043 [ 3 ] {dffec250-1edf-47ad-820b-35c03018b725} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
290 | 2024.10.09 22:37:54.469112 [ 3 ] {dffec250-1edf-47ad-820b-35c03018b725} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
291 | 2024.10.09 22:37:54.471466 [ 3 ] {dffec250-1edf-47ad-820b-35c03018b725} <Debug> oximeter.measurements_i16 (b19bd7e1-361d-47c7-9d47-a0b30bb50ce1): Loading data parts | ||
292 | 2024.10.09 22:37:54.471802 [ 3 ] {dffec250-1edf-47ad-820b-35c03018b725} <Debug> oximeter.measurements_i16 (b19bd7e1-361d-47c7-9d47-a0b30bb50ce1): There are no data parts | ||
293 | 2024.10.09 22:37:54.473625 [ 3 ] {dffec250-1edf-47ad-820b-35c03018b725} <Debug> DynamicQueryHandler: Done processing query | ||
294 | 2024.10.09 22:37:54.473679 [ 3 ] {} <Debug> HTTP-Session: a703f7f7-17d6-40b9-b039-5896f964c59b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
295 | 2024.10.09 22:37:54.474478 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
296 | 2024.10.09 22:37:54.474556 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
297 | 2024.10.09 22:37:54.474585 [ 3 ] {} <Debug> HTTP-Session: 8743b40b-f0f2-4081-9c4a-e01c1e86f258 Authenticating user 'default' from [::1]:41514 | ||
298 | 2024.10.09 22:37:54.474621 [ 3 ] {} <Debug> HTTP-Session: 8743b40b-f0f2-4081-9c4a-e01c1e86f258 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
299 | 2024.10.09 22:37:54.474640 [ 3 ] {} <Debug> HTTP-Session: 8743b40b-f0f2-4081-9c4a-e01c1e86f258 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
300 | 2024.10.09 22:37:54.474685 [ 3 ] {} <Trace> HTTP-Session: 8743b40b-f0f2-4081-9c4a-e01c1e86f258 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
301 | 2024.10.09 22:37:54.475003 [ 3 ] {a7e6bceb-a987-49b7-b49c-169db10b6c8d} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
302 | 2024.10.09 22:37:54.475086 [ 3 ] {a7e6bceb-a987-49b7-b49c-169db10b6c8d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
303 | 2024.10.09 22:37:54.477358 [ 3 ] {a7e6bceb-a987-49b7-b49c-169db10b6c8d} <Debug> oximeter.measurements_u16 (8756f4c6-27be-477c-8e71-82ee2220fcd0): Loading data parts | ||
304 | 2024.10.09 22:37:54.477652 [ 3 ] {a7e6bceb-a987-49b7-b49c-169db10b6c8d} <Debug> oximeter.measurements_u16 (8756f4c6-27be-477c-8e71-82ee2220fcd0): There are no data parts | ||
305 | 2024.10.09 22:37:54.479493 [ 3 ] {a7e6bceb-a987-49b7-b49c-169db10b6c8d} <Debug> DynamicQueryHandler: Done processing query | ||
306 | 2024.10.09 22:37:54.479527 [ 3 ] {} <Debug> HTTP-Session: 8743b40b-f0f2-4081-9c4a-e01c1e86f258 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
307 | 2024.10.09 22:37:54.480158 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
308 | 2024.10.09 22:37:54.480232 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
309 | 2024.10.09 22:37:54.480251 [ 3 ] {} <Debug> HTTP-Session: 806dbb6e-8e5f-44b4-a551-c4dbc0eeafe5 Authenticating user 'default' from [::1]:41514 | ||
310 | 2024.10.09 22:37:54.480269 [ 3 ] {} <Debug> HTTP-Session: 806dbb6e-8e5f-44b4-a551-c4dbc0eeafe5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
311 | 2024.10.09 22:37:54.480286 [ 3 ] {} <Debug> HTTP-Session: 806dbb6e-8e5f-44b4-a551-c4dbc0eeafe5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
312 | 2024.10.09 22:37:54.480323 [ 3 ] {} <Trace> HTTP-Session: 806dbb6e-8e5f-44b4-a551-c4dbc0eeafe5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
313 | 2024.10.09 22:37:54.480544 [ 3 ] {7abb9dcc-d205-463c-ad32-05e46ce02336} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
314 | 2024.10.09 22:37:54.480665 [ 3 ] {7abb9dcc-d205-463c-ad32-05e46ce02336} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
315 | 2024.10.09 22:37:54.482967 [ 3 ] {7abb9dcc-d205-463c-ad32-05e46ce02336} <Debug> oximeter.measurements_i32 (4674ebe9-2da8-4cb3-bccf-c9ba11f7e909): Loading data parts | ||
316 | 2024.10.09 22:37:54.483331 [ 3 ] {7abb9dcc-d205-463c-ad32-05e46ce02336} <Debug> oximeter.measurements_i32 (4674ebe9-2da8-4cb3-bccf-c9ba11f7e909): There are no data parts | ||
317 | 2024.10.09 22:37:54.485060 [ 3 ] {7abb9dcc-d205-463c-ad32-05e46ce02336} <Debug> DynamicQueryHandler: Done processing query | ||
318 | 2024.10.09 22:37:54.485093 [ 3 ] {} <Debug> HTTP-Session: 806dbb6e-8e5f-44b4-a551-c4dbc0eeafe5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
319 | 2024.10.09 22:37:54.486787 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
320 | 2024.10.09 22:37:54.486868 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
321 | 2024.10.09 22:37:54.486896 [ 3 ] {} <Debug> HTTP-Session: 6468634a-0bba-4912-ae3d-d6691d0c664d Authenticating user 'default' from [::1]:41514 | ||
322 | 2024.10.09 22:37:54.486936 [ 3 ] {} <Debug> HTTP-Session: 6468634a-0bba-4912-ae3d-d6691d0c664d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
323 | 2024.10.09 22:37:54.486955 [ 3 ] {} <Debug> HTTP-Session: 6468634a-0bba-4912-ae3d-d6691d0c664d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
324 | 2024.10.09 22:37:54.487008 [ 3 ] {} <Trace> HTTP-Session: 6468634a-0bba-4912-ae3d-d6691d0c664d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
325 | 2024.10.09 22:37:54.487349 [ 3 ] {1ff887a7-a1c4-4761-9233-aea814984614} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
326 | 2024.10.09 22:37:54.487428 [ 3 ] {1ff887a7-a1c4-4761-9233-aea814984614} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
327 | 2024.10.09 22:37:54.489486 [ 3 ] {1ff887a7-a1c4-4761-9233-aea814984614} <Debug> oximeter.measurements_u32 (7fe1bce2-d6fc-4008-a1cf-7dfda09b5927): Loading data parts | ||
328 | 2024.10.09 22:37:54.489880 [ 3 ] {1ff887a7-a1c4-4761-9233-aea814984614} <Debug> oximeter.measurements_u32 (7fe1bce2-d6fc-4008-a1cf-7dfda09b5927): There are no data parts | ||
329 | 2024.10.09 22:37:54.491633 [ 3 ] {1ff887a7-a1c4-4761-9233-aea814984614} <Debug> DynamicQueryHandler: Done processing query | ||
330 | 2024.10.09 22:37:54.491679 [ 3 ] {} <Debug> HTTP-Session: 6468634a-0bba-4912-ae3d-d6691d0c664d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
331 | 2024.10.09 22:37:54.498198 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
332 | 2024.10.09 22:37:54.498326 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
333 | 2024.10.09 22:37:54.498373 [ 3 ] {} <Debug> HTTP-Session: 1a801817-739a-4873-a996-dd6920748ecd Authenticating user 'default' from [::1]:41514 | ||
334 | 2024.10.09 22:37:54.498401 [ 3 ] {} <Debug> HTTP-Session: 1a801817-739a-4873-a996-dd6920748ecd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
335 | 2024.10.09 22:37:54.498417 [ 3 ] {} <Debug> HTTP-Session: 1a801817-739a-4873-a996-dd6920748ecd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
336 | 2024.10.09 22:37:54.498483 [ 3 ] {} <Trace> HTTP-Session: 1a801817-739a-4873-a996-dd6920748ecd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
337 | 2024.10.09 22:37:54.498884 [ 3 ] {5a8b8e79-2c33-4e46-958c-787d077b0068} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
338 | 2024.10.09 22:37:54.498970 [ 3 ] {5a8b8e79-2c33-4e46-958c-787d077b0068} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
339 | 2024.10.09 22:37:54.501635 [ 3 ] {5a8b8e79-2c33-4e46-958c-787d077b0068} <Debug> oximeter.measurements_i64 (66b1ed0d-6fe0-458e-ba33-f7a2dc1ed6b7): Loading data parts | ||
340 | 2024.10.09 22:37:54.502053 [ 3 ] {5a8b8e79-2c33-4e46-958c-787d077b0068} <Debug> oximeter.measurements_i64 (66b1ed0d-6fe0-458e-ba33-f7a2dc1ed6b7): There are no data parts | ||
341 | 2024.10.09 22:37:54.503914 [ 3 ] {5a8b8e79-2c33-4e46-958c-787d077b0068} <Debug> DynamicQueryHandler: Done processing query | ||
342 | 2024.10.09 22:37:54.503946 [ 3 ] {} <Debug> HTTP-Session: 1a801817-739a-4873-a996-dd6920748ecd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
343 | 2024.10.09 22:37:54.506342 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
344 | 2024.10.09 22:37:54.506450 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
345 | 2024.10.09 22:37:54.506481 [ 3 ] {} <Debug> HTTP-Session: 1cda7387-96ea-4c3a-9247-f63840ce3d08 Authenticating user 'default' from [::1]:41514 | ||
346 | 2024.10.09 22:37:54.506505 [ 3 ] {} <Debug> HTTP-Session: 1cda7387-96ea-4c3a-9247-f63840ce3d08 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
347 | 2024.10.09 22:37:54.506526 [ 3 ] {} <Debug> HTTP-Session: 1cda7387-96ea-4c3a-9247-f63840ce3d08 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
348 | 2024.10.09 22:37:54.506580 [ 3 ] {} <Trace> HTTP-Session: 1cda7387-96ea-4c3a-9247-f63840ce3d08 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
349 | 2024.10.09 22:37:54.506880 [ 3 ] {075cdb90-ccad-41ca-9ce9-9156c2d40914} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
350 | 2024.10.09 22:37:54.506948 [ 3 ] {075cdb90-ccad-41ca-9ce9-9156c2d40914} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
351 | 2024.10.09 22:37:54.509286 [ 3 ] {075cdb90-ccad-41ca-9ce9-9156c2d40914} <Debug> oximeter.measurements_u64 (d5a1760b-220a-441f-9184-7a7e4eb75854): Loading data parts | ||
352 | 2024.10.09 22:37:54.509589 [ 3 ] {075cdb90-ccad-41ca-9ce9-9156c2d40914} <Debug> oximeter.measurements_u64 (d5a1760b-220a-441f-9184-7a7e4eb75854): There are no data parts | ||
353 | 2024.10.09 22:37:54.511297 [ 3 ] {075cdb90-ccad-41ca-9ce9-9156c2d40914} <Debug> DynamicQueryHandler: Done processing query | ||
354 | 2024.10.09 22:37:54.511333 [ 3 ] {} <Debug> HTTP-Session: 1cda7387-96ea-4c3a-9247-f63840ce3d08 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
355 | 2024.10.09 22:37:54.513163 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
356 | 2024.10.09 22:37:54.513232 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
357 | 2024.10.09 22:37:54.513275 [ 3 ] {} <Debug> HTTP-Session: aa11c825-4ce6-4d19-abbf-6d5db1bbafcd Authenticating user 'default' from [::1]:41514 | ||
358 | 2024.10.09 22:37:54.513303 [ 3 ] {} <Debug> HTTP-Session: aa11c825-4ce6-4d19-abbf-6d5db1bbafcd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
359 | 2024.10.09 22:37:54.513319 [ 3 ] {} <Debug> HTTP-Session: aa11c825-4ce6-4d19-abbf-6d5db1bbafcd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
360 | 2024.10.09 22:37:54.513375 [ 3 ] {} <Trace> HTTP-Session: aa11c825-4ce6-4d19-abbf-6d5db1bbafcd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
361 | 2024.10.09 22:37:54.513740 [ 3 ] {bc770379-f5af-47f1-8ce5-333ff5c54404} <Debug> executeQuery: (from [::1]:41514) 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) | ||
362 | 2024.10.09 22:37:54.513828 [ 3 ] {bc770379-f5af-47f1-8ce5-333ff5c54404} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
363 | 2024.10.09 22:37:54.516320 [ 3 ] {bc770379-f5af-47f1-8ce5-333ff5c54404} <Debug> oximeter.measurements_f32 (a495a621-9737-4b2f-8846-4a4efc63b999): Loading data parts | ||
364 | 2024.10.09 22:37:54.516623 [ 3 ] {bc770379-f5af-47f1-8ce5-333ff5c54404} <Debug> oximeter.measurements_f32 (a495a621-9737-4b2f-8846-4a4efc63b999): There are no data parts | ||
365 | 2024.10.09 22:37:54.518531 [ 3 ] {bc770379-f5af-47f1-8ce5-333ff5c54404} <Debug> DynamicQueryHandler: Done processing query | ||
366 | 2024.10.09 22:37:54.518563 [ 3 ] {} <Debug> HTTP-Session: aa11c825-4ce6-4d19-abbf-6d5db1bbafcd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
367 | 2024.10.09 22:37:54.519353 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
368 | 2024.10.09 22:37:54.519428 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
369 | 2024.10.09 22:37:54.519445 [ 3 ] {} <Debug> HTTP-Session: 96de7dd9-f9de-4410-a9d7-26ba0b29fd80 Authenticating user 'default' from [::1]:41514 | ||
370 | 2024.10.09 22:37:54.519465 [ 3 ] {} <Debug> HTTP-Session: 96de7dd9-f9de-4410-a9d7-26ba0b29fd80 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
371 | 2024.10.09 22:37:54.519490 [ 3 ] {} <Debug> HTTP-Session: 96de7dd9-f9de-4410-a9d7-26ba0b29fd80 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
372 | 2024.10.09 22:37:54.519537 [ 3 ] {} <Trace> HTTP-Session: 96de7dd9-f9de-4410-a9d7-26ba0b29fd80 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
373 | 2024.10.09 22:37:54.519802 [ 3 ] {2eddecef-f1a9-4df6-a911-3aad0ec190e8} <Debug> executeQuery: (from [::1]:41514) 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) | ||
374 | 2024.10.09 22:37:54.519883 [ 3 ] {2eddecef-f1a9-4df6-a911-3aad0ec190e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
375 | 2024.10.09 22:37:54.522513 [ 3 ] {2eddecef-f1a9-4df6-a911-3aad0ec190e8} <Debug> oximeter.measurements_f64 (221e5136-fa91-4540-86a6-ef76b84969e6): Loading data parts | ||
376 | 2024.10.09 22:37:54.522841 [ 3 ] {2eddecef-f1a9-4df6-a911-3aad0ec190e8} <Debug> oximeter.measurements_f64 (221e5136-fa91-4540-86a6-ef76b84969e6): There are no data parts | ||
377 | 2024.10.09 22:37:54.524608 [ 3 ] {2eddecef-f1a9-4df6-a911-3aad0ec190e8} <Debug> DynamicQueryHandler: Done processing query | ||
378 | 2024.10.09 22:37:54.524640 [ 3 ] {} <Debug> HTTP-Session: 96de7dd9-f9de-4410-a9d7-26ba0b29fd80 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
379 | 2024.10.09 22:37:54.525363 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
380 | 2024.10.09 22:37:54.525434 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
381 | 2024.10.09 22:37:54.525458 [ 3 ] {} <Debug> HTTP-Session: 82ed5d74-fc18-4ca0-84db-0015acc12639 Authenticating user 'default' from [::1]:41514 | ||
382 | 2024.10.09 22:37:54.525492 [ 3 ] {} <Debug> HTTP-Session: 82ed5d74-fc18-4ca0-84db-0015acc12639 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
383 | 2024.10.09 22:37:54.525509 [ 3 ] {} <Debug> HTTP-Session: 82ed5d74-fc18-4ca0-84db-0015acc12639 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
384 | 2024.10.09 22:37:54.525557 [ 3 ] {} <Trace> HTTP-Session: 82ed5d74-fc18-4ca0-84db-0015acc12639 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
385 | 2024.10.09 22:37:54.525895 [ 3 ] {270e4807-cd01-4c98-a656-574eb827a080} <Debug> executeQuery: (from [::1]:41514) 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) | ||
386 | 2024.10.09 22:37:54.525973 [ 3 ] {270e4807-cd01-4c98-a656-574eb827a080} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
387 | 2024.10.09 22:37:54.528388 [ 3 ] {270e4807-cd01-4c98-a656-574eb827a080} <Debug> oximeter.measurements_string (93f1af4b-4d0b-48fc-b31c-e788ba9230bb): Loading data parts | ||
388 | 2024.10.09 22:37:54.528697 [ 3 ] {270e4807-cd01-4c98-a656-574eb827a080} <Debug> oximeter.measurements_string (93f1af4b-4d0b-48fc-b31c-e788ba9230bb): There are no data parts | ||
389 | 2024.10.09 22:37:54.530446 [ 3 ] {270e4807-cd01-4c98-a656-574eb827a080} <Debug> DynamicQueryHandler: Done processing query | ||
390 | 2024.10.09 22:37:54.530476 [ 3 ] {} <Debug> HTTP-Session: 82ed5d74-fc18-4ca0-84db-0015acc12639 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
391 | 2024.10.09 22:37:54.531264 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
392 | 2024.10.09 22:37:54.531366 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
393 | 2024.10.09 22:37:54.531394 [ 3 ] {} <Debug> HTTP-Session: 22c09092-9cc0-49d2-83ee-3663e30a7825 Authenticating user 'default' from [::1]:41514 | ||
394 | 2024.10.09 22:37:54.531420 [ 3 ] {} <Debug> HTTP-Session: 22c09092-9cc0-49d2-83ee-3663e30a7825 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
395 | 2024.10.09 22:37:54.531445 [ 3 ] {} <Debug> HTTP-Session: 22c09092-9cc0-49d2-83ee-3663e30a7825 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
396 | 2024.10.09 22:37:54.531495 [ 3 ] {} <Trace> HTTP-Session: 22c09092-9cc0-49d2-83ee-3663e30a7825 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
397 | 2024.10.09 22:37:54.531773 [ 3 ] {2f7b02f4-8a37-4660-aa54-1d478072d80a} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
398 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
399 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
400 | * a string isn't palatable for a few reasons. | ||
401 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
402 | * details. | ||
403 | */ | ||
404 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
405 | 2024.10.09 22:37:54.531839 [ 3 ] {2f7b02f4-8a37-4660-aa54-1d478072d80a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
406 | 2024.10.09 22:37:54.534162 [ 3 ] {2f7b02f4-8a37-4660-aa54-1d478072d80a} <Debug> oximeter.measurements_bytes (bddaa6cf-52e0-4f31-b0f1-f3aac6dfacc4): Loading data parts | ||
407 | 2024.10.09 22:37:54.534498 [ 3 ] {2f7b02f4-8a37-4660-aa54-1d478072d80a} <Debug> oximeter.measurements_bytes (bddaa6cf-52e0-4f31-b0f1-f3aac6dfacc4): There are no data parts | ||
408 | 2024.10.09 22:37:54.536190 [ 3 ] {2f7b02f4-8a37-4660-aa54-1d478072d80a} <Debug> DynamicQueryHandler: Done processing query | ||
409 | 2024.10.09 22:37:54.536220 [ 3 ] {} <Debug> HTTP-Session: 22c09092-9cc0-49d2-83ee-3663e30a7825 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
410 | 2024.10.09 22:37:54.537047 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
411 | 2024.10.09 22:37:54.537143 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
412 | 2024.10.09 22:37:54.537167 [ 3 ] {} <Debug> HTTP-Session: 26fedb9f-35df-4d59-8e13-cf7fccb75c1e Authenticating user 'default' from [::1]:41514 | ||
413 | 2024.10.09 22:37:54.537190 [ 3 ] {} <Debug> HTTP-Session: 26fedb9f-35df-4d59-8e13-cf7fccb75c1e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
414 | 2024.10.09 22:37:54.537212 [ 3 ] {} <Debug> HTTP-Session: 26fedb9f-35df-4d59-8e13-cf7fccb75c1e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
415 | 2024.10.09 22:37:54.537250 [ 3 ] {} <Trace> HTTP-Session: 26fedb9f-35df-4d59-8e13-cf7fccb75c1e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
416 | 2024.10.09 22:37:54.537636 [ 3 ] {ba97cccc-a0fc-45fc-bd5d-0e0e8a881f97} <Debug> executeQuery: (from [::1]:41514) 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) | ||
417 | 2024.10.09 22:37:54.537724 [ 3 ] {ba97cccc-a0fc-45fc-bd5d-0e0e8a881f97} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
418 | 2024.10.09 22:37:54.540284 [ 3 ] {ba97cccc-a0fc-45fc-bd5d-0e0e8a881f97} <Debug> oximeter.measurements_cumulativei64 (38f543f1-76fe-447b-9249-d9dcfc73bd70): Loading data parts | ||
419 | 2024.10.09 22:37:54.540629 [ 3 ] {ba97cccc-a0fc-45fc-bd5d-0e0e8a881f97} <Debug> oximeter.measurements_cumulativei64 (38f543f1-76fe-447b-9249-d9dcfc73bd70): There are no data parts | ||
420 | 2024.10.09 22:37:54.542727 [ 3 ] {ba97cccc-a0fc-45fc-bd5d-0e0e8a881f97} <Debug> DynamicQueryHandler: Done processing query | ||
421 | 2024.10.09 22:37:54.542778 [ 3 ] {} <Debug> HTTP-Session: 26fedb9f-35df-4d59-8e13-cf7fccb75c1e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
422 | 2024.10.09 22:37:54.543442 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
423 | 2024.10.09 22:37:54.543526 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
424 | 2024.10.09 22:37:54.543568 [ 3 ] {} <Debug> HTTP-Session: 4e2543d0-cab5-402a-982b-ad2f7a601cc7 Authenticating user 'default' from [::1]:41514 | ||
425 | 2024.10.09 22:37:54.543597 [ 3 ] {} <Debug> HTTP-Session: 4e2543d0-cab5-402a-982b-ad2f7a601cc7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
426 | 2024.10.09 22:37:54.543614 [ 3 ] {} <Debug> HTTP-Session: 4e2543d0-cab5-402a-982b-ad2f7a601cc7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
427 | 2024.10.09 22:37:54.543666 [ 3 ] {} <Trace> HTTP-Session: 4e2543d0-cab5-402a-982b-ad2f7a601cc7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
428 | 2024.10.09 22:37:54.544055 [ 3 ] {ec3f7c38-fc98-46c0-a068-ab7d52312365} <Debug> executeQuery: (from [::1]:41514) 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) | ||
429 | 2024.10.09 22:37:54.544151 [ 3 ] {ec3f7c38-fc98-46c0-a068-ab7d52312365} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
430 | 2024.10.09 22:37:54.546666 [ 3 ] {ec3f7c38-fc98-46c0-a068-ab7d52312365} <Debug> oximeter.measurements_cumulativeu64 (bf3d467d-8b58-45f8-a057-eca03dd76dd8): Loading data parts | ||
431 | 2024.10.09 22:37:54.547137 [ 3 ] {ec3f7c38-fc98-46c0-a068-ab7d52312365} <Debug> oximeter.measurements_cumulativeu64 (bf3d467d-8b58-45f8-a057-eca03dd76dd8): There are no data parts | ||
432 | 2024.10.09 22:37:54.548991 [ 3 ] {ec3f7c38-fc98-46c0-a068-ab7d52312365} <Debug> DynamicQueryHandler: Done processing query | ||
433 | 2024.10.09 22:37:54.549022 [ 3 ] {} <Debug> HTTP-Session: 4e2543d0-cab5-402a-982b-ad2f7a601cc7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
434 | 2024.10.09 22:37:54.591697 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
435 | 2024.10.09 22:37:54.591849 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
436 | 2024.10.09 22:37:54.591882 [ 3 ] {} <Debug> HTTP-Session: 7434f75b-a7e5-4209-bd48-1502bc1b0556 Authenticating user 'default' from [::1]:41514 | ||
437 | 2024.10.09 22:37:54.591910 [ 3 ] {} <Debug> HTTP-Session: 7434f75b-a7e5-4209-bd48-1502bc1b0556 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
438 | 2024.10.09 22:37:54.591935 [ 3 ] {} <Debug> HTTP-Session: 7434f75b-a7e5-4209-bd48-1502bc1b0556 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
439 | 2024.10.09 22:37:54.591993 [ 3 ] {} <Trace> HTTP-Session: 7434f75b-a7e5-4209-bd48-1502bc1b0556 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
440 | 2024.10.09 22:37:54.592437 [ 3 ] {e1e8f062-51c0-4b42-a93f-8ddd987ce2e6} <Debug> executeQuery: (from [::1]:41514) 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) | ||
441 | 2024.10.09 22:37:54.592563 [ 3 ] {e1e8f062-51c0-4b42-a93f-8ddd987ce2e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
442 | 2024.10.09 22:37:54.596514 [ 3 ] {e1e8f062-51c0-4b42-a93f-8ddd987ce2e6} <Debug> oximeter.measurements_cumulativef32 (08139fbc-ee5a-43e3-ae5f-9516e437d765): Loading data parts | ||
443 | 2024.10.09 22:37:54.596871 [ 3 ] {e1e8f062-51c0-4b42-a93f-8ddd987ce2e6} <Debug> oximeter.measurements_cumulativef32 (08139fbc-ee5a-43e3-ae5f-9516e437d765): There are no data parts | ||
444 | 2024.10.09 22:37:54.600210 [ 3 ] {e1e8f062-51c0-4b42-a93f-8ddd987ce2e6} <Debug> DynamicQueryHandler: Done processing query | ||
445 | 2024.10.09 22:37:54.600263 [ 3 ] {} <Debug> HTTP-Session: 7434f75b-a7e5-4209-bd48-1502bc1b0556 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
446 | 2024.10.09 22:37:54.601750 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
447 | 2024.10.09 22:37:54.601824 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
448 | 2024.10.09 22:37:54.601859 [ 3 ] {} <Debug> HTTP-Session: 465498da-f5dc-4c8b-a262-90eb765487a2 Authenticating user 'default' from [::1]:41514 | ||
449 | 2024.10.09 22:37:54.601880 [ 3 ] {} <Debug> HTTP-Session: 465498da-f5dc-4c8b-a262-90eb765487a2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
450 | 2024.10.09 22:37:54.601890 [ 3 ] {} <Debug> HTTP-Session: 465498da-f5dc-4c8b-a262-90eb765487a2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
451 | 2024.10.09 22:37:54.601941 [ 3 ] {} <Trace> HTTP-Session: 465498da-f5dc-4c8b-a262-90eb765487a2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
452 | 2024.10.09 22:37:54.602307 [ 3 ] {bba38267-c614-419b-aae3-811d918c1096} <Debug> executeQuery: (from [::1]:41514) 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) | ||
453 | 2024.10.09 22:37:54.602441 [ 3 ] {bba38267-c614-419b-aae3-811d918c1096} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
454 | 2024.10.09 22:37:54.612201 [ 3 ] {bba38267-c614-419b-aae3-811d918c1096} <Debug> oximeter.measurements_cumulativef64 (0f3900ea-85e7-4001-99a3-b5e241fc2838): Loading data parts | ||
455 | 2024.10.09 22:37:54.612628 [ 3 ] {bba38267-c614-419b-aae3-811d918c1096} <Debug> oximeter.measurements_cumulativef64 (0f3900ea-85e7-4001-99a3-b5e241fc2838): There are no data parts | ||
456 | 2024.10.09 22:37:54.617206 [ 3 ] {bba38267-c614-419b-aae3-811d918c1096} <Debug> DynamicQueryHandler: Done processing query | ||
457 | 2024.10.09 22:37:54.617244 [ 3 ] {} <Debug> HTTP-Session: 465498da-f5dc-4c8b-a262-90eb765487a2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
458 | 2024.10.09 22:37:54.618748 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
459 | 2024.10.09 22:37:54.618829 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
460 | 2024.10.09 22:37:54.618893 [ 3 ] {} <Debug> HTTP-Session: 3d0bd38c-b431-4a1d-9df2-65f4660cb794 Authenticating user 'default' from [::1]:41514 | ||
461 | 2024.10.09 22:37:54.618938 [ 3 ] {} <Debug> HTTP-Session: 3d0bd38c-b431-4a1d-9df2-65f4660cb794 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
462 | 2024.10.09 22:37:54.618956 [ 3 ] {} <Debug> HTTP-Session: 3d0bd38c-b431-4a1d-9df2-65f4660cb794 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
463 | 2024.10.09 22:37:54.619077 [ 3 ] {} <Trace> HTTP-Session: 3d0bd38c-b431-4a1d-9df2-65f4660cb794 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
464 | 2024.10.09 22:37:54.619702 [ 3 ] {6c620027-5fa5-4dd4-a4ab-6acc39fa8c21} <Debug> executeQuery: (from [::1]:41514) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
465 | * NOTE: Array types cannot be Nullable, see | ||
466 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
467 | * for more details. | ||
468 | * | ||
469 | * This means we need to use empty arrays to indicate a missing value. This | ||
470 | * is unfortunate, and at this point relies on the fact that an | ||
471 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
472 | * to figure out another way to represent missing samples here. | ||
473 | */ | ||
474 | 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) | ||
475 | 2024.10.09 22:37:54.619813 [ 3 ] {6c620027-5fa5-4dd4-a4ab-6acc39fa8c21} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
476 | 2024.10.09 22:37:54.631487 [ 3 ] {6c620027-5fa5-4dd4-a4ab-6acc39fa8c21} <Debug> oximeter.measurements_histogrami8 (8974432d-049c-4115-a72b-a4a6f405d9bb): Loading data parts | ||
477 | 2024.10.09 22:37:54.631960 [ 3 ] {6c620027-5fa5-4dd4-a4ab-6acc39fa8c21} <Debug> oximeter.measurements_histogrami8 (8974432d-049c-4115-a72b-a4a6f405d9bb): There are no data parts | ||
478 | 2024.10.09 22:37:54.634311 [ 3 ] {6c620027-5fa5-4dd4-a4ab-6acc39fa8c21} <Debug> DynamicQueryHandler: Done processing query | ||
479 | 2024.10.09 22:37:54.634361 [ 3 ] {} <Debug> HTTP-Session: 3d0bd38c-b431-4a1d-9df2-65f4660cb794 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
480 | 2024.10.09 22:37:54.636323 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
481 | 2024.10.09 22:37:54.636411 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
482 | 2024.10.09 22:37:54.636457 [ 3 ] {} <Debug> HTTP-Session: dd9948f7-ca09-4dc3-9303-6be5ef7d90e1 Authenticating user 'default' from [::1]:41514 | ||
483 | 2024.10.09 22:37:54.636486 [ 3 ] {} <Debug> HTTP-Session: dd9948f7-ca09-4dc3-9303-6be5ef7d90e1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
484 | 2024.10.09 22:37:54.636504 [ 3 ] {} <Debug> HTTP-Session: dd9948f7-ca09-4dc3-9303-6be5ef7d90e1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
485 | 2024.10.09 22:37:54.636649 [ 3 ] {} <Trace> HTTP-Session: dd9948f7-ca09-4dc3-9303-6be5ef7d90e1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
486 | 2024.10.09 22:37:54.637185 [ 3 ] {3887e653-89cd-4ade-864a-1ca8368fe3ca} <Debug> executeQuery: (from [::1]:41514) 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) | ||
487 | 2024.10.09 22:37:54.637285 [ 3 ] {3887e653-89cd-4ade-864a-1ca8368fe3ca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
488 | 2024.10.09 22:37:54.640465 [ 3 ] {3887e653-89cd-4ade-864a-1ca8368fe3ca} <Debug> oximeter.measurements_histogramu8 (a49ab68c-2745-4e19-9999-6bfa1cec6440): Loading data parts | ||
489 | 2024.10.09 22:37:54.640970 [ 3 ] {3887e653-89cd-4ade-864a-1ca8368fe3ca} <Debug> oximeter.measurements_histogramu8 (a49ab68c-2745-4e19-9999-6bfa1cec6440): There are no data parts | ||
490 | 2024.10.09 22:37:54.642585 [ 3 ] {3887e653-89cd-4ade-864a-1ca8368fe3ca} <Debug> DynamicQueryHandler: Done processing query | ||
491 | 2024.10.09 22:37:54.642616 [ 3 ] {} <Debug> HTTP-Session: dd9948f7-ca09-4dc3-9303-6be5ef7d90e1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
492 | 2024.10.09 22:37:54.643689 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
493 | 2024.10.09 22:37:54.643780 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
494 | 2024.10.09 22:37:54.643810 [ 3 ] {} <Debug> HTTP-Session: 9e5d6be1-7fc3-4a48-bde0-98dbb66dff9d Authenticating user 'default' from [::1]:41514 | ||
495 | 2024.10.09 22:37:54.643836 [ 3 ] {} <Debug> HTTP-Session: 9e5d6be1-7fc3-4a48-bde0-98dbb66dff9d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
496 | 2024.10.09 22:37:54.643861 [ 3 ] {} <Debug> HTTP-Session: 9e5d6be1-7fc3-4a48-bde0-98dbb66dff9d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
497 | 2024.10.09 22:37:54.643911 [ 3 ] {} <Trace> HTTP-Session: 9e5d6be1-7fc3-4a48-bde0-98dbb66dff9d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
498 | 2024.10.09 22:37:54.644472 [ 3 ] {27bcd72f-ffd6-49f9-baed-4f18221db780} <Debug> executeQuery: (from [::1]:41514) 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) | ||
499 | 2024.10.09 22:37:54.644581 [ 3 ] {27bcd72f-ffd6-49f9-baed-4f18221db780} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
500 | 2024.10.09 22:37:54.647435 [ 3 ] {27bcd72f-ffd6-49f9-baed-4f18221db780} <Debug> oximeter.measurements_histogrami16 (b9913829-6bb1-4fd2-8852-23cb66345d4a): Loading data parts | ||
501 | 2024.10.09 22:37:54.647776 [ 3 ] {27bcd72f-ffd6-49f9-baed-4f18221db780} <Debug> oximeter.measurements_histogrami16 (b9913829-6bb1-4fd2-8852-23cb66345d4a): There are no data parts | ||
502 | 2024.10.09 22:37:54.649317 [ 3 ] {27bcd72f-ffd6-49f9-baed-4f18221db780} <Debug> DynamicQueryHandler: Done processing query | ||
503 | 2024.10.09 22:37:54.649346 [ 3 ] {} <Debug> HTTP-Session: 9e5d6be1-7fc3-4a48-bde0-98dbb66dff9d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
504 | 2024.10.09 22:37:54.650742 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
505 | 2024.10.09 22:37:54.650876 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
506 | 2024.10.09 22:37:54.650909 [ 3 ] {} <Debug> HTTP-Session: 80394db1-01b4-4e6e-8386-20cdfccd176d Authenticating user 'default' from [::1]:41514 | ||
507 | 2024.10.09 22:37:54.650948 [ 3 ] {} <Debug> HTTP-Session: 80394db1-01b4-4e6e-8386-20cdfccd176d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
508 | 2024.10.09 22:37:54.650967 [ 3 ] {} <Debug> HTTP-Session: 80394db1-01b4-4e6e-8386-20cdfccd176d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
509 | 2024.10.09 22:37:54.651016 [ 3 ] {} <Trace> HTTP-Session: 80394db1-01b4-4e6e-8386-20cdfccd176d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
510 | 2024.10.09 22:37:54.651496 [ 3 ] {7a41e0ab-b5b7-4597-9cc3-36e866739794} <Debug> executeQuery: (from [::1]:41514) 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) | ||
511 | 2024.10.09 22:37:54.651641 [ 3 ] {7a41e0ab-b5b7-4597-9cc3-36e866739794} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
512 | 2024.10.09 22:37:54.654527 [ 3 ] {7a41e0ab-b5b7-4597-9cc3-36e866739794} <Debug> oximeter.measurements_histogramu16 (b7e67867-ebb2-4415-9d8f-4295f12b378b): Loading data parts | ||
513 | 2024.10.09 22:37:54.654881 [ 3 ] {7a41e0ab-b5b7-4597-9cc3-36e866739794} <Debug> oximeter.measurements_histogramu16 (b7e67867-ebb2-4415-9d8f-4295f12b378b): There are no data parts | ||
514 | 2024.10.09 22:37:54.656501 [ 3 ] {7a41e0ab-b5b7-4597-9cc3-36e866739794} <Debug> DynamicQueryHandler: Done processing query | ||
515 | 2024.10.09 22:37:54.656533 [ 3 ] {} <Debug> HTTP-Session: 80394db1-01b4-4e6e-8386-20cdfccd176d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
516 | 2024.10.09 22:37:54.662720 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
517 | 2024.10.09 22:37:54.662857 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
518 | 2024.10.09 22:37:54.662894 [ 3 ] {} <Debug> HTTP-Session: 81b625fe-a5b9-4cbd-86f9-2d1d975c83a4 Authenticating user 'default' from [::1]:41514 | ||
519 | 2024.10.09 22:37:54.662924 [ 3 ] {} <Debug> HTTP-Session: 81b625fe-a5b9-4cbd-86f9-2d1d975c83a4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
520 | 2024.10.09 22:37:54.662957 [ 3 ] {} <Debug> HTTP-Session: 81b625fe-a5b9-4cbd-86f9-2d1d975c83a4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
521 | 2024.10.09 22:37:54.663061 [ 3 ] {} <Trace> HTTP-Session: 81b625fe-a5b9-4cbd-86f9-2d1d975c83a4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
522 | 2024.10.09 22:37:54.663514 [ 3 ] {c3493653-db76-4819-988d-ad2e548d84df} <Debug> executeQuery: (from [::1]:41514) 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) | ||
523 | 2024.10.09 22:37:54.663602 [ 3 ] {c3493653-db76-4819-988d-ad2e548d84df} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
524 | 2024.10.09 22:37:54.666280 [ 3 ] {c3493653-db76-4819-988d-ad2e548d84df} <Debug> oximeter.measurements_histogrami32 (fac17600-2e75-4bd3-9eca-fa992fbfd334): Loading data parts | ||
525 | 2024.10.09 22:37:54.666588 [ 3 ] {c3493653-db76-4819-988d-ad2e548d84df} <Debug> oximeter.measurements_histogrami32 (fac17600-2e75-4bd3-9eca-fa992fbfd334): There are no data parts | ||
526 | 2024.10.09 22:37:54.669896 [ 3 ] {c3493653-db76-4819-988d-ad2e548d84df} <Debug> DynamicQueryHandler: Done processing query | ||
527 | 2024.10.09 22:37:54.669931 [ 3 ] {} <Debug> HTTP-Session: 81b625fe-a5b9-4cbd-86f9-2d1d975c83a4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
528 | 2024.10.09 22:37:54.671898 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
529 | 2024.10.09 22:37:54.671976 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
530 | 2024.10.09 22:37:54.672006 [ 3 ] {} <Debug> HTTP-Session: 4decb693-2f79-4e8b-b289-f3f2a25a2e7f Authenticating user 'default' from [::1]:41514 | ||
531 | 2024.10.09 22:37:54.672048 [ 3 ] {} <Debug> HTTP-Session: 4decb693-2f79-4e8b-b289-f3f2a25a2e7f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
532 | 2024.10.09 22:37:54.672068 [ 3 ] {} <Debug> HTTP-Session: 4decb693-2f79-4e8b-b289-f3f2a25a2e7f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
533 | 2024.10.09 22:37:54.672123 [ 3 ] {} <Trace> HTTP-Session: 4decb693-2f79-4e8b-b289-f3f2a25a2e7f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
534 | 2024.10.09 22:37:54.672657 [ 3 ] {0c5860d1-cffa-40a8-9a94-24f195e15f44} <Debug> executeQuery: (from [::1]:41514) 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) | ||
535 | 2024.10.09 22:37:54.672769 [ 3 ] {0c5860d1-cffa-40a8-9a94-24f195e15f44} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
536 | 2024.10.09 22:37:54.676398 [ 3 ] {0c5860d1-cffa-40a8-9a94-24f195e15f44} <Debug> oximeter.measurements_histogramu32 (91bf596a-2691-44c0-9c55-0260483368a9): Loading data parts | ||
537 | 2024.10.09 22:37:54.676799 [ 3 ] {0c5860d1-cffa-40a8-9a94-24f195e15f44} <Debug> oximeter.measurements_histogramu32 (91bf596a-2691-44c0-9c55-0260483368a9): There are no data parts | ||
538 | 2024.10.09 22:37:54.680135 [ 3 ] {0c5860d1-cffa-40a8-9a94-24f195e15f44} <Debug> DynamicQueryHandler: Done processing query | ||
539 | 2024.10.09 22:37:54.680189 [ 3 ] {} <Debug> HTTP-Session: 4decb693-2f79-4e8b-b289-f3f2a25a2e7f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
540 | 2024.10.09 22:37:54.681484 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
541 | 2024.10.09 22:37:54.681563 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
542 | 2024.10.09 22:37:54.681608 [ 3 ] {} <Debug> HTTP-Session: 4adafc3f-61ee-4427-9066-f3724224dea4 Authenticating user 'default' from [::1]:41514 | ||
543 | 2024.10.09 22:37:54.681635 [ 3 ] {} <Debug> HTTP-Session: 4adafc3f-61ee-4427-9066-f3724224dea4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
544 | 2024.10.09 22:37:54.681653 [ 3 ] {} <Debug> HTTP-Session: 4adafc3f-61ee-4427-9066-f3724224dea4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
545 | 2024.10.09 22:37:54.681718 [ 3 ] {} <Trace> HTTP-Session: 4adafc3f-61ee-4427-9066-f3724224dea4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
546 | 2024.10.09 22:37:54.682153 [ 3 ] {e39a0a74-ba75-473d-a06c-7acf15f7d07c} <Debug> executeQuery: (from [::1]:41514) 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) | ||
547 | 2024.10.09 22:37:54.682257 [ 3 ] {e39a0a74-ba75-473d-a06c-7acf15f7d07c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
548 | 2024.10.09 22:37:54.687177 [ 3 ] {e39a0a74-ba75-473d-a06c-7acf15f7d07c} <Debug> oximeter.measurements_histogrami64 (3f1f726c-6983-49cf-b5d8-847bb9e9db43): Loading data parts | ||
549 | 2024.10.09 22:37:54.687557 [ 3 ] {e39a0a74-ba75-473d-a06c-7acf15f7d07c} <Debug> oximeter.measurements_histogrami64 (3f1f726c-6983-49cf-b5d8-847bb9e9db43): There are no data parts | ||
550 | 2024.10.09 22:37:54.691405 [ 3 ] {e39a0a74-ba75-473d-a06c-7acf15f7d07c} <Debug> DynamicQueryHandler: Done processing query | ||
551 | 2024.10.09 22:37:54.691439 [ 3 ] {} <Debug> HTTP-Session: 4adafc3f-61ee-4427-9066-f3724224dea4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
552 | 2024.10.09 22:37:54.692071 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
553 | 2024.10.09 22:37:54.692167 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
554 | 2024.10.09 22:37:54.692198 [ 3 ] {} <Debug> HTTP-Session: ed8fbcc9-403d-4dd0-b782-5f122cde9f12 Authenticating user 'default' from [::1]:41514 | ||
555 | 2024.10.09 22:37:54.692227 [ 3 ] {} <Debug> HTTP-Session: ed8fbcc9-403d-4dd0-b782-5f122cde9f12 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
556 | 2024.10.09 22:37:54.692258 [ 3 ] {} <Debug> HTTP-Session: ed8fbcc9-403d-4dd0-b782-5f122cde9f12 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
557 | 2024.10.09 22:37:54.692313 [ 3 ] {} <Trace> HTTP-Session: ed8fbcc9-403d-4dd0-b782-5f122cde9f12 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
558 | 2024.10.09 22:37:54.692924 [ 3 ] {9fc734c5-3edb-4ae3-a4dc-e4f75a66ba94} <Debug> executeQuery: (from [::1]:41514) 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) | ||
559 | 2024.10.09 22:37:54.693064 [ 3 ] {9fc734c5-3edb-4ae3-a4dc-e4f75a66ba94} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
560 | 2024.10.09 22:37:54.697414 [ 3 ] {9fc734c5-3edb-4ae3-a4dc-e4f75a66ba94} <Debug> oximeter.measurements_histogramu64 (f0f72151-c288-444b-a1d0-ef7d5ce1e0a7): Loading data parts | ||
561 | 2024.10.09 22:37:54.697708 [ 3 ] {9fc734c5-3edb-4ae3-a4dc-e4f75a66ba94} <Debug> oximeter.measurements_histogramu64 (f0f72151-c288-444b-a1d0-ef7d5ce1e0a7): There are no data parts | ||
562 | 2024.10.09 22:37:54.700283 [ 3 ] {9fc734c5-3edb-4ae3-a4dc-e4f75a66ba94} <Debug> DynamicQueryHandler: Done processing query | ||
563 | 2024.10.09 22:37:54.700383 [ 3 ] {} <Debug> HTTP-Session: ed8fbcc9-403d-4dd0-b782-5f122cde9f12 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
564 | 2024.10.09 22:37:54.701172 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
565 | 2024.10.09 22:37:54.701257 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
566 | 2024.10.09 22:37:54.701302 [ 3 ] {} <Debug> HTTP-Session: 46db0f94-20d9-484b-85f6-9f570735d868 Authenticating user 'default' from [::1]:41514 | ||
567 | 2024.10.09 22:37:54.701330 [ 3 ] {} <Debug> HTTP-Session: 46db0f94-20d9-484b-85f6-9f570735d868 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
568 | 2024.10.09 22:37:54.701347 [ 3 ] {} <Debug> HTTP-Session: 46db0f94-20d9-484b-85f6-9f570735d868 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
569 | 2024.10.09 22:37:54.701407 [ 3 ] {} <Trace> HTTP-Session: 46db0f94-20d9-484b-85f6-9f570735d868 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
570 | 2024.10.09 22:37:54.702013 [ 3 ] {76ed4d5e-d477-46f0-86fa-69760d1d08a5} <Debug> executeQuery: (from [::1]:41514) 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) | ||
571 | 2024.10.09 22:37:54.702117 [ 3 ] {76ed4d5e-d477-46f0-86fa-69760d1d08a5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
572 | 2024.10.09 22:37:54.704460 [ 3 ] {76ed4d5e-d477-46f0-86fa-69760d1d08a5} <Debug> oximeter.measurements_histogramf32 (8b14c873-726a-469f-89f9-7a56e54c02bc): Loading data parts | ||
573 | 2024.10.09 22:37:54.704760 [ 3 ] {76ed4d5e-d477-46f0-86fa-69760d1d08a5} <Debug> oximeter.measurements_histogramf32 (8b14c873-726a-469f-89f9-7a56e54c02bc): There are no data parts | ||
574 | 2024.10.09 22:37:54.706328 [ 3 ] {76ed4d5e-d477-46f0-86fa-69760d1d08a5} <Debug> DynamicQueryHandler: Done processing query | ||
575 | 2024.10.09 22:37:54.706359 [ 3 ] {} <Debug> HTTP-Session: 46db0f94-20d9-484b-85f6-9f570735d868 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
576 | 2024.10.09 22:37:54.707569 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
577 | 2024.10.09 22:37:54.707664 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
578 | 2024.10.09 22:37:54.707692 [ 3 ] {} <Debug> HTTP-Session: 22b5a39c-3356-4fc5-b127-9f00b0a31ba0 Authenticating user 'default' from [::1]:41514 | ||
579 | 2024.10.09 22:37:54.707716 [ 3 ] {} <Debug> HTTP-Session: 22b5a39c-3356-4fc5-b127-9f00b0a31ba0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
580 | 2024.10.09 22:37:54.707742 [ 3 ] {} <Debug> HTTP-Session: 22b5a39c-3356-4fc5-b127-9f00b0a31ba0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
581 | 2024.10.09 22:37:54.707792 [ 3 ] {} <Trace> HTTP-Session: 22b5a39c-3356-4fc5-b127-9f00b0a31ba0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
582 | 2024.10.09 22:37:54.708323 [ 3 ] {abd856b1-9ad0-4f5d-a3ae-f72d876cff5d} <Debug> executeQuery: (from [::1]:41514) 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) | ||
583 | 2024.10.09 22:37:54.708431 [ 3 ] {abd856b1-9ad0-4f5d-a3ae-f72d876cff5d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
584 | 2024.10.09 22:37:54.712251 [ 3 ] {abd856b1-9ad0-4f5d-a3ae-f72d876cff5d} <Debug> oximeter.measurements_histogramf64 (12e291fa-e4b3-4f5b-b90c-7db612389305): Loading data parts | ||
585 | 2024.10.09 22:37:54.712705 [ 3 ] {abd856b1-9ad0-4f5d-a3ae-f72d876cff5d} <Debug> oximeter.measurements_histogramf64 (12e291fa-e4b3-4f5b-b90c-7db612389305): There are no data parts | ||
586 | 2024.10.09 22:37:54.714548 [ 3 ] {abd856b1-9ad0-4f5d-a3ae-f72d876cff5d} <Debug> DynamicQueryHandler: Done processing query | ||
587 | 2024.10.09 22:37:54.714579 [ 3 ] {} <Debug> HTTP-Session: 22b5a39c-3356-4fc5-b127-9f00b0a31ba0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
588 | 2024.10.09 22:37:54.715530 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
589 | 2024.10.09 22:37:54.715607 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
590 | 2024.10.09 22:37:54.715650 [ 3 ] {} <Debug> HTTP-Session: a5a10360-90e8-4721-b2ac-e2a5da67149f Authenticating user 'default' from [::1]:41514 | ||
591 | 2024.10.09 22:37:54.715677 [ 3 ] {} <Debug> HTTP-Session: a5a10360-90e8-4721-b2ac-e2a5da67149f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
592 | 2024.10.09 22:37:54.715694 [ 3 ] {} <Debug> HTTP-Session: a5a10360-90e8-4721-b2ac-e2a5da67149f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
593 | 2024.10.09 22:37:54.715775 [ 3 ] {} <Trace> HTTP-Session: a5a10360-90e8-4721-b2ac-e2a5da67149f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
594 | 2024.10.09 22:37:54.716150 [ 3 ] {d3e78426-3f4c-40b7-a48d-292617c1f84c} <Debug> executeQuery: (from [::1]:41514) /* The field tables store named dimensions of each timeseries. | ||
595 | * | ||
596 | * As with the measurement tables, there is one field table for each field data | ||
597 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
598 | * this behavior **must not** be relied upon for query correctness. | ||
599 | * | ||
600 | * The index for the fields differs from the measurements, however. Rows are | ||
601 | * sorted by timeseries name, then field name, field value, and finally | ||
602 | * timeseries key. This reflects the most common pattern for looking them up: | ||
603 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
604 | * usually then used to look up measurements. | ||
605 | * | ||
606 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
607 | * timeseries name and then key, since it would improve lookups where one | ||
608 | * already has the key. Realistically though, these tables are quite small and | ||
609 | * so performance benefits will be low in absolute terms. | ||
610 | * | ||
611 | * TTL: We use a materialized column to expire old field table records. This | ||
612 | * column is generated automatically by the database whenever a new row is | ||
613 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
614 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
615 | * record will remain during a deduplication, which will have the last | ||
616 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
617 | * measurement tables. | ||
618 | */ | ||
619 | 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) | ||
620 | 2024.10.09 22:37:54.716237 [ 3 ] {d3e78426-3f4c-40b7-a48d-292617c1f84c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
621 | 2024.10.09 22:37:54.718871 [ 3 ] {d3e78426-3f4c-40b7-a48d-292617c1f84c} <Debug> oximeter.fields_bool (31636eee-da1c-4521-90ed-87e5c201ff52): Loading data parts | ||
622 | 2024.10.09 22:37:54.719134 [ 3 ] {d3e78426-3f4c-40b7-a48d-292617c1f84c} <Debug> oximeter.fields_bool (31636eee-da1c-4521-90ed-87e5c201ff52): There are no data parts | ||
623 | 2024.10.09 22:37:54.720653 [ 3 ] {d3e78426-3f4c-40b7-a48d-292617c1f84c} <Debug> DynamicQueryHandler: Done processing query | ||
624 | 2024.10.09 22:37:54.720706 [ 3 ] {} <Debug> HTTP-Session: a5a10360-90e8-4721-b2ac-e2a5da67149f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
625 | 2024.10.09 22:37:54.721602 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
626 | 2024.10.09 22:37:54.721775 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
627 | 2024.10.09 22:37:54.721826 [ 3 ] {} <Debug> HTTP-Session: c502332a-6943-4629-8c6d-ba4365a802e8 Authenticating user 'default' from [::1]:41514 | ||
628 | 2024.10.09 22:37:54.721852 [ 3 ] {} <Debug> HTTP-Session: c502332a-6943-4629-8c6d-ba4365a802e8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
629 | 2024.10.09 22:37:54.721868 [ 3 ] {} <Debug> HTTP-Session: c502332a-6943-4629-8c6d-ba4365a802e8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
630 | 2024.10.09 22:37:54.722087 [ 3 ] {} <Trace> HTTP-Session: c502332a-6943-4629-8c6d-ba4365a802e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
631 | 2024.10.09 22:37:54.722438 [ 3 ] {f6834c54-1a69-4d49-b2d1-c91ad4b14c68} <Debug> executeQuery: (from [::1]:41514) 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) | ||
632 | 2024.10.09 22:37:54.722509 [ 3 ] {f6834c54-1a69-4d49-b2d1-c91ad4b14c68} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
633 | 2024.10.09 22:37:54.724625 [ 3 ] {f6834c54-1a69-4d49-b2d1-c91ad4b14c68} <Debug> oximeter.fields_i8 (829bfa35-c726-4dde-b659-8eff32168ff9): Loading data parts | ||
634 | 2024.10.09 22:37:54.724969 [ 3 ] {f6834c54-1a69-4d49-b2d1-c91ad4b14c68} <Debug> oximeter.fields_i8 (829bfa35-c726-4dde-b659-8eff32168ff9): There are no data parts | ||
635 | 2024.10.09 22:37:54.726411 [ 3 ] {f6834c54-1a69-4d49-b2d1-c91ad4b14c68} <Debug> DynamicQueryHandler: Done processing query | ||
636 | 2024.10.09 22:37:54.726440 [ 3 ] {} <Debug> HTTP-Session: c502332a-6943-4629-8c6d-ba4365a802e8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
637 | 2024.10.09 22:37:54.727245 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
638 | 2024.10.09 22:37:54.727336 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
639 | 2024.10.09 22:37:54.727365 [ 3 ] {} <Debug> HTTP-Session: 5a1ebf6a-a110-4f89-9be3-975055cdd0c1 Authenticating user 'default' from [::1]:41514 | ||
640 | 2024.10.09 22:37:54.727389 [ 3 ] {} <Debug> HTTP-Session: 5a1ebf6a-a110-4f89-9be3-975055cdd0c1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
641 | 2024.10.09 22:37:54.727416 [ 3 ] {} <Debug> HTTP-Session: 5a1ebf6a-a110-4f89-9be3-975055cdd0c1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
642 | 2024.10.09 22:37:54.727461 [ 3 ] {} <Trace> HTTP-Session: 5a1ebf6a-a110-4f89-9be3-975055cdd0c1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
643 | 2024.10.09 22:37:54.727788 [ 3 ] {0bea4126-6faa-44ea-a450-e27fc3878474} <Debug> executeQuery: (from [::1]:41514) 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) | ||
644 | 2024.10.09 22:37:54.727857 [ 3 ] {0bea4126-6faa-44ea-a450-e27fc3878474} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
645 | 2024.10.09 22:37:54.730799 [ 3 ] {0bea4126-6faa-44ea-a450-e27fc3878474} <Debug> oximeter.fields_u8 (d110cfd8-90b3-4134-a6f4-e4a70cd69275): Loading data parts | ||
646 | 2024.10.09 22:37:54.731181 [ 3 ] {0bea4126-6faa-44ea-a450-e27fc3878474} <Debug> oximeter.fields_u8 (d110cfd8-90b3-4134-a6f4-e4a70cd69275): There are no data parts | ||
647 | 2024.10.09 22:37:54.738749 [ 3 ] {0bea4126-6faa-44ea-a450-e27fc3878474} <Debug> DynamicQueryHandler: Done processing query | ||
648 | 2024.10.09 22:37:54.738892 [ 3 ] {} <Debug> HTTP-Session: 5a1ebf6a-a110-4f89-9be3-975055cdd0c1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
649 | 2024.10.09 22:37:54.739981 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
650 | 2024.10.09 22:37:54.740093 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
651 | 2024.10.09 22:37:54.740137 [ 3 ] {} <Debug> HTTP-Session: 47a95503-e300-492a-b4d4-d511d36c61a1 Authenticating user 'default' from [::1]:41514 | ||
652 | 2024.10.09 22:37:54.740166 [ 3 ] {} <Debug> HTTP-Session: 47a95503-e300-492a-b4d4-d511d36c61a1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
653 | 2024.10.09 22:37:54.740183 [ 3 ] {} <Debug> HTTP-Session: 47a95503-e300-492a-b4d4-d511d36c61a1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
654 | 2024.10.09 22:37:54.740245 [ 3 ] {} <Trace> HTTP-Session: 47a95503-e300-492a-b4d4-d511d36c61a1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
655 | 2024.10.09 22:37:54.740774 [ 3 ] {0c80a564-6437-4915-97eb-963a7362a553} <Debug> executeQuery: (from [::1]:41514) 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) | ||
656 | 2024.10.09 22:37:54.740864 [ 3 ] {0c80a564-6437-4915-97eb-963a7362a553} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
657 | 2024.10.09 22:37:54.742908 [ 3 ] {0c80a564-6437-4915-97eb-963a7362a553} <Debug> oximeter.fields_i16 (1a4f2be4-e524-4bd5-818a-ba86bf6155e7): Loading data parts | ||
658 | 2024.10.09 22:37:54.743233 [ 3 ] {0c80a564-6437-4915-97eb-963a7362a553} <Debug> oximeter.fields_i16 (1a4f2be4-e524-4bd5-818a-ba86bf6155e7): There are no data parts | ||
659 | 2024.10.09 22:37:54.744699 [ 3 ] {0c80a564-6437-4915-97eb-963a7362a553} <Debug> DynamicQueryHandler: Done processing query | ||
660 | 2024.10.09 22:37:54.744732 [ 3 ] {} <Debug> HTTP-Session: 47a95503-e300-492a-b4d4-d511d36c61a1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
661 | 2024.10.09 22:37:54.745419 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
662 | 2024.10.09 22:37:54.745500 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
663 | 2024.10.09 22:37:54.745519 [ 3 ] {} <Debug> HTTP-Session: 72c14643-4e05-4b8e-8812-d1adf8b5dd03 Authenticating user 'default' from [::1]:41514 | ||
664 | 2024.10.09 22:37:54.745536 [ 3 ] {} <Debug> HTTP-Session: 72c14643-4e05-4b8e-8812-d1adf8b5dd03 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
665 | 2024.10.09 22:37:54.745557 [ 3 ] {} <Debug> HTTP-Session: 72c14643-4e05-4b8e-8812-d1adf8b5dd03 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
666 | 2024.10.09 22:37:54.745604 [ 3 ] {} <Trace> HTTP-Session: 72c14643-4e05-4b8e-8812-d1adf8b5dd03 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
667 | 2024.10.09 22:37:54.745936 [ 3 ] {ba2fe6e6-fdb2-4fa2-a1d0-1d71fc688f9a} <Debug> executeQuery: (from [::1]:41514) 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) | ||
668 | 2024.10.09 22:37:54.746004 [ 3 ] {ba2fe6e6-fdb2-4fa2-a1d0-1d71fc688f9a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
669 | 2024.10.09 22:37:54.748340 [ 3 ] {ba2fe6e6-fdb2-4fa2-a1d0-1d71fc688f9a} <Debug> oximeter.fields_u16 (deebf211-55b2-4bdc-b78d-a47b4264d0d6): Loading data parts | ||
670 | 2024.10.09 22:37:54.748708 [ 3 ] {ba2fe6e6-fdb2-4fa2-a1d0-1d71fc688f9a} <Debug> oximeter.fields_u16 (deebf211-55b2-4bdc-b78d-a47b4264d0d6): There are no data parts | ||
671 | 2024.10.09 22:37:54.750246 [ 3 ] {ba2fe6e6-fdb2-4fa2-a1d0-1d71fc688f9a} <Debug> DynamicQueryHandler: Done processing query | ||
672 | 2024.10.09 22:37:54.750339 [ 3 ] {} <Debug> HTTP-Session: 72c14643-4e05-4b8e-8812-d1adf8b5dd03 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
673 | 2024.10.09 22:37:54.750968 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
674 | 2024.10.09 22:37:54.751041 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
675 | 2024.10.09 22:37:54.751087 [ 3 ] {} <Debug> HTTP-Session: 06e81640-7627-4c09-9eba-e4501aa1d204 Authenticating user 'default' from [::1]:41514 | ||
676 | 2024.10.09 22:37:54.751160 [ 3 ] {} <Debug> HTTP-Session: 06e81640-7627-4c09-9eba-e4501aa1d204 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
677 | 2024.10.09 22:37:54.751178 [ 3 ] {} <Debug> HTTP-Session: 06e81640-7627-4c09-9eba-e4501aa1d204 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
678 | 2024.10.09 22:37:54.751383 [ 3 ] {} <Trace> HTTP-Session: 06e81640-7627-4c09-9eba-e4501aa1d204 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
679 | 2024.10.09 22:37:54.751788 [ 3 ] {ae568d14-81e4-4103-a162-092fb3f73002} <Debug> executeQuery: (from [::1]:41514) 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) | ||
680 | 2024.10.09 22:37:54.751874 [ 3 ] {ae568d14-81e4-4103-a162-092fb3f73002} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
681 | 2024.10.09 22:37:54.754482 [ 3 ] {ae568d14-81e4-4103-a162-092fb3f73002} <Debug> oximeter.fields_i32 (417a76b7-44e5-46d0-b07b-e35eca40dfc6): Loading data parts | ||
682 | 2024.10.09 22:37:54.754937 [ 3 ] {ae568d14-81e4-4103-a162-092fb3f73002} <Debug> oximeter.fields_i32 (417a76b7-44e5-46d0-b07b-e35eca40dfc6): There are no data parts | ||
683 | 2024.10.09 22:37:54.757237 [ 3 ] {ae568d14-81e4-4103-a162-092fb3f73002} <Debug> DynamicQueryHandler: Done processing query | ||
684 | 2024.10.09 22:37:54.757275 [ 3 ] {} <Debug> HTTP-Session: 06e81640-7627-4c09-9eba-e4501aa1d204 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
685 | 2024.10.09 22:37:54.758024 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
686 | 2024.10.09 22:37:54.758170 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
687 | 2024.10.09 22:37:54.758202 [ 3 ] {} <Debug> HTTP-Session: 52d3e0b1-cea1-4e47-a532-b23a47a88291 Authenticating user 'default' from [::1]:41514 | ||
688 | 2024.10.09 22:37:54.758226 [ 3 ] {} <Debug> HTTP-Session: 52d3e0b1-cea1-4e47-a532-b23a47a88291 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
689 | 2024.10.09 22:37:54.758299 [ 3 ] {} <Debug> HTTP-Session: 52d3e0b1-cea1-4e47-a532-b23a47a88291 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
690 | 2024.10.09 22:37:54.758423 [ 3 ] {} <Trace> HTTP-Session: 52d3e0b1-cea1-4e47-a532-b23a47a88291 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
691 | 2024.10.09 22:37:54.758818 [ 3 ] {e66b9cc1-8bad-460a-b0b8-883d217ab071} <Debug> executeQuery: (from [::1]:41514) 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) | ||
692 | 2024.10.09 22:37:54.758942 [ 3 ] {e66b9cc1-8bad-460a-b0b8-883d217ab071} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
693 | 2024.10.09 22:37:54.761847 [ 3 ] {e66b9cc1-8bad-460a-b0b8-883d217ab071} <Debug> oximeter.fields_u32 (40ef6451-37b2-494f-878b-47647e8a218f): Loading data parts | ||
694 | 2024.10.09 22:37:54.762102 [ 3 ] {e66b9cc1-8bad-460a-b0b8-883d217ab071} <Debug> oximeter.fields_u32 (40ef6451-37b2-494f-878b-47647e8a218f): There are no data parts | ||
695 | 2024.10.09 22:37:54.763887 [ 3 ] {e66b9cc1-8bad-460a-b0b8-883d217ab071} <Debug> DynamicQueryHandler: Done processing query | ||
696 | 2024.10.09 22:37:54.763938 [ 3 ] {} <Debug> HTTP-Session: 52d3e0b1-cea1-4e47-a532-b23a47a88291 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
697 | 2024.10.09 22:37:54.764645 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
698 | 2024.10.09 22:37:54.764718 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
699 | 2024.10.09 22:37:54.764754 [ 3 ] {} <Debug> HTTP-Session: 1cbdfe55-f7b9-4f8e-b7aa-d823ee867140 Authenticating user 'default' from [::1]:41514 | ||
700 | 2024.10.09 22:37:54.764778 [ 3 ] {} <Debug> HTTP-Session: 1cbdfe55-f7b9-4f8e-b7aa-d823ee867140 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
701 | 2024.10.09 22:37:54.764793 [ 3 ] {} <Debug> HTTP-Session: 1cbdfe55-f7b9-4f8e-b7aa-d823ee867140 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
702 | 2024.10.09 22:37:54.764828 [ 3 ] {} <Trace> HTTP-Session: 1cbdfe55-f7b9-4f8e-b7aa-d823ee867140 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
703 | 2024.10.09 22:37:54.765048 [ 3 ] {ab0ed67a-02bf-4c8a-915b-085d380cb8ea} <Debug> executeQuery: (from [::1]:41514) 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) | ||
704 | 2024.10.09 22:37:54.765106 [ 3 ] {ab0ed67a-02bf-4c8a-915b-085d380cb8ea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
705 | 2024.10.09 22:37:54.767593 [ 3 ] {ab0ed67a-02bf-4c8a-915b-085d380cb8ea} <Debug> oximeter.fields_i64 (01fd2454-4cd6-498f-8fd3-8365deac284e): Loading data parts | ||
706 | 2024.10.09 22:37:54.767933 [ 3 ] {ab0ed67a-02bf-4c8a-915b-085d380cb8ea} <Debug> oximeter.fields_i64 (01fd2454-4cd6-498f-8fd3-8365deac284e): There are no data parts | ||
707 | 2024.10.09 22:37:54.769175 [ 3 ] {ab0ed67a-02bf-4c8a-915b-085d380cb8ea} <Debug> DynamicQueryHandler: Done processing query | ||
708 | 2024.10.09 22:37:54.769205 [ 3 ] {} <Debug> HTTP-Session: 1cbdfe55-f7b9-4f8e-b7aa-d823ee867140 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
709 | 2024.10.09 22:37:54.770005 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
710 | 2024.10.09 22:37:54.770108 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
711 | 2024.10.09 22:37:54.770139 [ 3 ] {} <Debug> HTTP-Session: c68f3a3d-f09a-4cfe-bfe4-4826fa18103a Authenticating user 'default' from [::1]:41514 | ||
712 | 2024.10.09 22:37:54.770162 [ 3 ] {} <Debug> HTTP-Session: c68f3a3d-f09a-4cfe-bfe4-4826fa18103a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
713 | 2024.10.09 22:37:54.770179 [ 3 ] {} <Debug> HTTP-Session: c68f3a3d-f09a-4cfe-bfe4-4826fa18103a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
714 | 2024.10.09 22:37:54.770223 [ 3 ] {} <Trace> HTTP-Session: c68f3a3d-f09a-4cfe-bfe4-4826fa18103a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
715 | 2024.10.09 22:37:54.770610 [ 3 ] {17a86908-4dee-42b2-9d02-eedcbbe5e344} <Debug> executeQuery: (from [::1]:41514) 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) | ||
716 | 2024.10.09 22:37:54.770758 [ 3 ] {17a86908-4dee-42b2-9d02-eedcbbe5e344} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
717 | 2024.10.09 22:37:54.773717 [ 3 ] {17a86908-4dee-42b2-9d02-eedcbbe5e344} <Debug> oximeter.fields_u64 (a64dbbc2-a660-452b-b3a1-54363c7c438d): Loading data parts | ||
718 | 2024.10.09 22:37:54.774051 [ 3 ] {17a86908-4dee-42b2-9d02-eedcbbe5e344} <Debug> oximeter.fields_u64 (a64dbbc2-a660-452b-b3a1-54363c7c438d): There are no data parts | ||
719 | 2024.10.09 22:37:54.775866 [ 3 ] {17a86908-4dee-42b2-9d02-eedcbbe5e344} <Debug> DynamicQueryHandler: Done processing query | ||
720 | 2024.10.09 22:37:54.775997 [ 3 ] {} <Debug> HTTP-Session: c68f3a3d-f09a-4cfe-bfe4-4826fa18103a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
721 | 2024.10.09 22:37:54.777330 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
722 | 2024.10.09 22:37:54.777409 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
723 | 2024.10.09 22:37:54.777432 [ 3 ] {} <Debug> HTTP-Session: af8035f6-b658-47f6-8a04-cdc766a79e1d Authenticating user 'default' from [::1]:41514 | ||
724 | 2024.10.09 22:37:54.777461 [ 3 ] {} <Debug> HTTP-Session: af8035f6-b658-47f6-8a04-cdc766a79e1d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
725 | 2024.10.09 22:37:54.777481 [ 3 ] {} <Debug> HTTP-Session: af8035f6-b658-47f6-8a04-cdc766a79e1d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
726 | 2024.10.09 22:37:54.777532 [ 3 ] {} <Trace> HTTP-Session: af8035f6-b658-47f6-8a04-cdc766a79e1d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
727 | 2024.10.09 22:37:54.777934 [ 3 ] {a5a8e734-d2da-4797-8df4-fa3b723260f4} <Debug> executeQuery: (from [::1]:41514) 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) | ||
728 | 2024.10.09 22:37:54.778012 [ 3 ] {a5a8e734-d2da-4797-8df4-fa3b723260f4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
729 | 2024.10.09 22:37:54.780385 [ 3 ] {a5a8e734-d2da-4797-8df4-fa3b723260f4} <Debug> oximeter.fields_ipaddr (dbd3827e-e481-43d3-91e7-64d35d1f84a9): Loading data parts | ||
730 | 2024.10.09 22:37:54.780779 [ 3 ] {a5a8e734-d2da-4797-8df4-fa3b723260f4} <Debug> oximeter.fields_ipaddr (dbd3827e-e481-43d3-91e7-64d35d1f84a9): There are no data parts | ||
731 | 2024.10.09 22:37:54.782300 [ 3 ] {a5a8e734-d2da-4797-8df4-fa3b723260f4} <Debug> DynamicQueryHandler: Done processing query | ||
732 | 2024.10.09 22:37:54.782333 [ 3 ] {} <Debug> HTTP-Session: af8035f6-b658-47f6-8a04-cdc766a79e1d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
733 | 2024.10.09 22:37:54.783122 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
734 | 2024.10.09 22:37:54.783241 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
735 | 2024.10.09 22:37:54.783286 [ 3 ] {} <Debug> HTTP-Session: 5a2a2ed5-22eb-4ba5-96ca-d67a0f6ebf08 Authenticating user 'default' from [::1]:41514 | ||
736 | 2024.10.09 22:37:54.783313 [ 3 ] {} <Debug> HTTP-Session: 5a2a2ed5-22eb-4ba5-96ca-d67a0f6ebf08 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
737 | 2024.10.09 22:37:54.783330 [ 3 ] {} <Debug> HTTP-Session: 5a2a2ed5-22eb-4ba5-96ca-d67a0f6ebf08 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
738 | 2024.10.09 22:37:54.783379 [ 3 ] {} <Trace> HTTP-Session: 5a2a2ed5-22eb-4ba5-96ca-d67a0f6ebf08 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
739 | 2024.10.09 22:37:54.783718 [ 3 ] {a1b01718-a518-46b3-b6f8-5fd87c6d4b2e} <Debug> executeQuery: (from [::1]:41514) 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) | ||
740 | 2024.10.09 22:37:54.783793 [ 3 ] {a1b01718-a518-46b3-b6f8-5fd87c6d4b2e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
741 | 2024.10.09 22:37:54.786310 [ 3 ] {a1b01718-a518-46b3-b6f8-5fd87c6d4b2e} <Debug> oximeter.fields_string (63d03380-4ef4-443c-b561-e10c040914b5): Loading data parts | ||
742 | 2024.10.09 22:37:54.786617 [ 3 ] {a1b01718-a518-46b3-b6f8-5fd87c6d4b2e} <Debug> oximeter.fields_string (63d03380-4ef4-443c-b561-e10c040914b5): There are no data parts | ||
743 | 2024.10.09 22:37:54.788732 [ 3 ] {a1b01718-a518-46b3-b6f8-5fd87c6d4b2e} <Debug> DynamicQueryHandler: Done processing query | ||
744 | 2024.10.09 22:37:54.788763 [ 3 ] {} <Debug> HTTP-Session: 5a2a2ed5-22eb-4ba5-96ca-d67a0f6ebf08 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
745 | 2024.10.09 22:37:54.789621 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
746 | 2024.10.09 22:37:54.789697 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
747 | 2024.10.09 22:37:54.789725 [ 3 ] {} <Debug> HTTP-Session: 0e170423-5854-4ad6-8e30-8a216655b704 Authenticating user 'default' from [::1]:41514 | ||
748 | 2024.10.09 22:37:54.789751 [ 3 ] {} <Debug> HTTP-Session: 0e170423-5854-4ad6-8e30-8a216655b704 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
749 | 2024.10.09 22:37:54.789769 [ 3 ] {} <Debug> HTTP-Session: 0e170423-5854-4ad6-8e30-8a216655b704 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
750 | 2024.10.09 22:37:54.789817 [ 3 ] {} <Trace> HTTP-Session: 0e170423-5854-4ad6-8e30-8a216655b704 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
751 | 2024.10.09 22:37:54.790194 [ 3 ] {c60f6da9-b87f-4002-9f7b-43dd902bbc41} <Debug> executeQuery: (from [::1]:41514) 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) | ||
752 | 2024.10.09 22:37:54.790268 [ 3 ] {c60f6da9-b87f-4002-9f7b-43dd902bbc41} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
753 | 2024.10.09 22:37:54.792393 [ 3 ] {c60f6da9-b87f-4002-9f7b-43dd902bbc41} <Debug> oximeter.fields_uuid (3dcdea19-1b86-4229-8ac6-2e71fc7272f8): Loading data parts | ||
754 | 2024.10.09 22:37:54.792762 [ 3 ] {c60f6da9-b87f-4002-9f7b-43dd902bbc41} <Debug> oximeter.fields_uuid (3dcdea19-1b86-4229-8ac6-2e71fc7272f8): There are no data parts | ||
755 | 2024.10.09 22:37:54.794508 [ 3 ] {c60f6da9-b87f-4002-9f7b-43dd902bbc41} <Debug> DynamicQueryHandler: Done processing query | ||
756 | 2024.10.09 22:37:54.794543 [ 3 ] {} <Debug> HTTP-Session: 0e170423-5854-4ad6-8e30-8a216655b704 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
757 | 2024.10.09 22:37:54.795327 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
758 | 2024.10.09 22:37:54.795403 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
759 | 2024.10.09 22:37:54.795433 [ 3 ] {} <Debug> HTTP-Session: bbb3ea8f-1aaf-4b41-8baa-0f6f4226bb87 Authenticating user 'default' from [::1]:41514 | ||
760 | 2024.10.09 22:37:54.795458 [ 3 ] {} <Debug> HTTP-Session: bbb3ea8f-1aaf-4b41-8baa-0f6f4226bb87 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
761 | 2024.10.09 22:37:54.795475 [ 3 ] {} <Debug> HTTP-Session: bbb3ea8f-1aaf-4b41-8baa-0f6f4226bb87 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
762 | 2024.10.09 22:37:54.795527 [ 3 ] {} <Trace> HTTP-Session: bbb3ea8f-1aaf-4b41-8baa-0f6f4226bb87 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
763 | 2024.10.09 22:37:54.796076 [ 3 ] {bfde428a-7896-47a0-8a19-9ce3fc0777f0} <Debug> executeQuery: (from [::1]:41514) /* The timeseries schema table stores the extracted schema for the samples | ||
764 | * oximeter collects. | ||
765 | */ | ||
766 | 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) | ||
767 | 2024.10.09 22:37:54.796178 [ 3 ] {bfde428a-7896-47a0-8a19-9ce3fc0777f0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
768 | 2024.10.09 22:37:54.798744 [ 3 ] {bfde428a-7896-47a0-8a19-9ce3fc0777f0} <Debug> oximeter.timeseries_schema (9fc921f1-ee35-4575-89aa-44c6e82bcffa): Loading data parts | ||
769 | 2024.10.09 22:37:54.799108 [ 3 ] {bfde428a-7896-47a0-8a19-9ce3fc0777f0} <Debug> oximeter.timeseries_schema (9fc921f1-ee35-4575-89aa-44c6e82bcffa): There are no data parts | ||
770 | 2024.10.09 22:37:54.800759 [ 3 ] {bfde428a-7896-47a0-8a19-9ce3fc0777f0} <Debug> DynamicQueryHandler: Done processing query | ||
771 | 2024.10.09 22:37:54.800791 [ 3 ] {} <Debug> HTTP-Session: bbb3ea8f-1aaf-4b41-8baa-0f6f4226bb87 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
772 | 2024.10.09 22:37:54.801726 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:41514, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
773 | 2024.10.09 22:37:54.801816 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
774 | 2024.10.09 22:37:54.801871 [ 3 ] {} <Debug> HTTP-Session: 0bd8a627-0219-4d5a-b7e6-b583068478bf Authenticating user 'default' from [::1]:41514 | ||
775 | 2024.10.09 22:37:54.801907 [ 3 ] {} <Debug> HTTP-Session: 0bd8a627-0219-4d5a-b7e6-b583068478bf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
776 | 2024.10.09 22:37:54.801924 [ 3 ] {} <Debug> HTTP-Session: 0bd8a627-0219-4d5a-b7e6-b583068478bf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
777 | 2024.10.09 22:37:54.801973 [ 3 ] {} <Trace> HTTP-Session: 0bd8a627-0219-4d5a-b7e6-b583068478bf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
778 | 2024.10.09 22:37:54.802200 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Debug> executeQuery: (from [::1]:41514) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
779 | 2024.10.09 22:37:54.802415 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
780 | 2024.10.09 22:37:54.805402 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Trace> oximeter.version (d7692977-8387-4cc2-9e28-a82e99944a62): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
781 | 2024.10.09 22:37:54.805461 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.30 GiB. | ||
782 | 2024.10.09 22:37:54.806427 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
783 | 2024.10.09 22:37:54.807803 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Trace> oximeter.version (d7692977-8387-4cc2-9e28-a82e99944a62): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
784 | 2024.10.09 22:37:54.808239 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.006138 sec., 162.91951775822744 rows/sec., 2.55 KiB/sec. | ||
785 | 2024.10.09 22:37:54.808538 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Debug> DynamicQueryHandler: Done processing query | ||
786 | 2024.10.09 22:37:54.808573 [ 3 ] {4fe0523f-0789-49e1-bab0-f406512b067b} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
787 | 2024.10.09 22:37:54.808594 [ 3 ] {} <Debug> HTTP-Session: 0bd8a627-0219-4d5a-b7e6-b583068478bf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
788 | 2024.10.09 22:37:55.000251 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 143.57 MiB, peak 148.71 MiB, free memory in arenas 0.00 B, will set to 148.08 MiB (RSS), difference: 4.51 MiB |