1 | 2024.10.09 22:41:12.824910 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 15859 | ||
2 | 2024.10.09 22:41:12.825107 [ 1 ] {} <Information> Application: starting up | ||
3 | 2024.10.09 22:41:12.825181 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
4 | 2024.10.09 22:41:12.836169 [ 1 ] {} <Information> Application: Available RAM: 31.32 GiB; physical cores: 8; logical cores: 8. | ||
5 | 2024.10.09 22:41:12.844482 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
6 | 2024.10.09 22:41:12.844531 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
7 | 2024.10.09 22:41:12.844544 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
8 | 2024.10.09 22:41:12.844963 [ 1 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disks_detached_when_instance_destroyed.15852.1-clickhouse-9A94Bf/datastore/tmp/ to store temporary data in it | ||
9 | 2024.10.09 22:41:12.845459 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
10 | 2024.10.09 22:41:12.846216 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
11 | 2024.10.09 22:41:12.846855 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
12 | 2024.10.09 22:41:12.847523 [ 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:41:12.847554 [ 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:41:12.847578 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 15.66 GiB | ||
15 | 2024.10.09 22:41:12.847686 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
16 | 2024.10.09 22:41:12.855082 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
17 | 2024.10.09 22:41:12.899325 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
18 | 2024.10.09 22:41:12.900243 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
19 | 2024.10.09 22:41:12.901543 [ 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:41:12.901600 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
21 | 2024.10.09 22:41:12.902963 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
22 | 2024.10.09 22:41:12.903755 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
23 | 2024.10.09 22:41:12.907914 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
24 | 2024.10.09 22:41:12.908511 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
25 | 2024.10.09 22:41:12.911181 [ 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:41:12.916344 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
27 | 2024.10.09 22:41:12.917777 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
28 | 2024.10.09 22:41:12.920353 [ 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:41:12.921713 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
30 | 2024.10.09 22:41:12.921756 [ 1 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disks_detached_when_instance_destroyed.15852.1-clickhouse-9A94Bf/datastore/ | ||
31 | 2024.10.09 22:41:12.921830 [ 41 ] {} <Debug> DNSResolver: Updating DNS cache | ||
32 | 2024.10.09 22:41:12.921897 [ 41 ] {} <Debug> DNSResolver: Updated DNS cache | ||
33 | 2024.10.09 22:41:12.932316 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
34 | 2024.10.09 22:41:12.932353 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.00020506 sec | ||
35 | 2024.10.09 22:41:12.932385 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
36 | 2024.10.09 22:41:12.932397 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
37 | 2024.10.09 22:41:12.932531 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
38 | 2024.10.09 22:41:12.932618 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
39 | 2024.10.09 22:41:12.932638 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
40 | 2024.10.09 22:41:12.932666 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
41 | 2024.10.09 22:41:12.932761 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
42 | 2024.10.09 22:41:12.932787 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
43 | 2024.10.09 22:41:12.932820 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
44 | 2024.10.09 22:41:12.932834 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
45 | 2024.10.09 22:41:12.932853 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
46 | 2024.10.09 22:41:12.932883 [ 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:41:12.932897 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
48 | 2024.10.09 22:41:12.932917 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
49 | 2024.10.09 22:41:12.932929 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
50 | 2024.10.09 22:41:12.932957 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
51 | 2024.10.09 22:41:12.932974 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
52 | 2024.10.09 22:41:12.932988 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
53 | 2024.10.09 22:41:12.933019 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
54 | 2024.10.09 22:41:12.933040 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
55 | 2024.10.09 22:41:12.996153 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
56 | 2024.10.09 22:41:13.009269 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
57 | 2024.10.09 22:41:13.009327 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000126554 sec | ||
58 | 2024.10.09 22:41:13.009343 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
59 | 2024.10.09 22:41:13.009355 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
60 | 2024.10.09 22:41:13.009471 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
61 | 2024.10.09 22:41:13.010307 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-53ae591393305c22-test_disks_detached_when_instance_destroyed.15852.1-clickhouse-9A94Bf/datastore/user_defined/ | ||
62 | 2024.10.09 22:41:13.010627 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
63 | 2024.10.09 22:41:13.010653 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
64 | 2024.10.09 22:41:13.010668 [ 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:41:13.010688 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
66 | 2024.10.09 22:41:13.011442 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40607 | ||
67 | 2024.10.09 22:41:13.012061 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41712 | ||
68 | 2024.10.09 22:41:13.053535 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1) | ||
69 | 2024.10.09 22:41:13.181311 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1) | ||
70 | 2024.10.09 22:41:13.181386 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
71 | 2024.10.09 22:41:13.281992 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 40028 | ||
72 | 2024.10.09 22:41:13.282138 [ 1 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 42993 | ||
73 | 2024.10.09 22:41:13.282290 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to create SSL context. SSL will be disabled. Error: Poco::Exception. Code: 1000, e.code() = 0, SSL Exception: Configuration error: no certificate file has been specified (version 23.8.7.1) | ||
74 | 2024.10.09 22:41:13.333532 [ 1 ] {} <Trace> MySQLHandlerFactory: Failed to read RSA key pair from server certificate. Error: Code: 139. DB::Exception: Certificate file is not set. (NO_ELEMENTS_IN_CONFIG) (version 23.8.7.1) | ||
75 | 2024.10.09 22:41:13.333575 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
76 | 2024.10.09 22:41:13.538657 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
77 | 2024.10.09 22:41:13.538948 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.03 MiB, free memory in arenas 0.00 B, will set to 178.31 MiB (RSS), difference: 168.44 MiB | ||
78 | 2024.10.09 22:41:13.539504 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 4.1848e-05 sec. | ||
79 | 2024.10.09 22:41:13.540645 [ 1 ] {} <Information> Application: Listening for http://[::1]:40607 | ||
80 | 2024.10.09 22:41:13.540725 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [::1]:41712 | ||
81 | 2024.10.09 22:41:13.540790 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [::1]:9004 | ||
82 | 2024.10.09 22:41:13.540847 [ 1 ] {} <Information> Application: Listening for http://127.0.0.1:40028 | ||
83 | 2024.10.09 22:41:13.540900 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): 127.0.0.1:42993 | ||
84 | 2024.10.09 22:41:13.540954 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: 127.0.0.1:9004 | ||
85 | 2024.10.09 22:41:13.540974 [ 1 ] {} <Information> Application: Ready for connections. | ||
86 | 2024.10.09 22:41:23.320352 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
87 | 2024.10.09 22:41:23.320635 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
88 | 2024.10.09 22:41:23.320667 [ 3 ] {} <Debug> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Authenticating user 'default' from [::1]:54088 | ||
89 | 2024.10.09 22:41:23.320700 [ 3 ] {} <Debug> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
90 | 2024.10.09 22:41:23.320711 [ 3 ] {} <Debug> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
91 | 2024.10.09 22:41:23.320825 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
92 | 2024.10.09 22:41:23.320893 [ 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 | ||
93 | 2024.10.09 22:41:23.320913 [ 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 | ||
94 | 2024.10.09 22:41:23.320972 [ 3 ] {} <Trace> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
95 | 2024.10.09 22:41:23.321577 [ 3 ] {73247b7d-d8ba-491f-8a01-8dc84959b59b} <Debug> executeQuery: (from [::1]:54088) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
96 | 2024.10.09 22:41:23.330998 [ 3 ] {73247b7d-d8ba-491f-8a01-8dc84959b59b} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:54088) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
97 | |||
98 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
99 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
100 | 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 | ||
101 | 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 | ||
102 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
103 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
104 | 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 | ||
105 | 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 | ||
106 | 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 | ||
107 | 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 | ||
108 | 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 | ||
109 | 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 | ||
110 | 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 | ||
111 | 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 | ||
112 | 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 | ||
113 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
114 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
115 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
116 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
117 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
118 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
119 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
120 | |||
121 | 2024.10.09 22:41:23.331271 [ 3 ] {73247b7d-d8ba-491f-8a01-8dc84959b59b} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
122 | |||
123 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
124 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
125 | 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 | ||
126 | 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 | ||
127 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
128 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
129 | 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 | ||
130 | 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 | ||
131 | 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 | ||
132 | 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 | ||
133 | 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 | ||
134 | 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 | ||
135 | 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 | ||
136 | 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 | ||
137 | 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 | ||
138 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
139 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
140 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
141 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
142 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
143 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
144 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
145 | (version 23.8.7.1) | ||
146 | 2024.10.09 22:41:23.331623 [ 3 ] {} <Debug> HTTP-Session: d80d9e17-7696-4e68-8ed6-eb0771ff7fde Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
147 | 2024.10.09 22:41:23.427542 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
148 | 2024.10.09 22:41:23.427690 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
149 | 2024.10.09 22:41:23.427719 [ 3 ] {} <Debug> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Authenticating user 'default' from [::1]:54088 | ||
150 | 2024.10.09 22:41:23.427747 [ 3 ] {} <Debug> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
151 | 2024.10.09 22:41:23.427770 [ 3 ] {} <Debug> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
152 | 2024.10.09 22:41:23.427830 [ 3 ] {} <Trace> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
153 | 2024.10.09 22:41:23.428157 [ 3 ] {a3e4040a-5031-442e-acf2-8cd6d505fae0} <Debug> executeQuery: (from [::1]:54088) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
154 | 2024.10.09 22:41:23.428654 [ 3 ] {a3e4040a-5031-442e-acf2-8cd6d505fae0} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [::1]:54088) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
155 | |||
156 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
157 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
158 | 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 | ||
159 | 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 | ||
160 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
161 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
162 | 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 | ||
163 | 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 | ||
164 | 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 | ||
165 | 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 | ||
166 | 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 | ||
167 | 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 | ||
168 | 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 | ||
169 | 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 | ||
170 | 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 | ||
171 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
172 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
173 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
174 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
175 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
176 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
177 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
178 | |||
179 | 2024.10.09 22:41:23.428842 [ 3 ] {a3e4040a-5031-442e-acf2-8cd6d505fae0} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
180 | |||
181 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
182 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
183 | 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 | ||
184 | 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 | ||
185 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
186 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
187 | 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 | ||
188 | 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 | ||
189 | 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 | ||
190 | 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 | ||
191 | 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 | ||
192 | 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 | ||
193 | 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 | ||
194 | 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 | ||
195 | 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 | ||
196 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
197 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
198 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
199 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
200 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
201 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse | ||
202 | 21. _thrp_setup @ 0x0000000000114f37 in /lib/amd64/libc.so.1 | ||
203 | (version 23.8.7.1) | ||
204 | 2024.10.09 22:41:23.429061 [ 3 ] {} <Debug> HTTP-Session: 1a52d06c-31fc-45c6-a375-63ba1221b803 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
205 | 2024.10.09 22:41:23.432702 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
206 | 2024.10.09 22:41:23.432847 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
207 | 2024.10.09 22:41:23.432880 [ 3 ] {} <Debug> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Authenticating user 'default' from [::1]:54088 | ||
208 | 2024.10.09 22:41:23.432911 [ 3 ] {} <Debug> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
209 | 2024.10.09 22:41:23.432927 [ 3 ] {} <Debug> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
210 | 2024.10.09 22:41:23.432982 [ 3 ] {} <Trace> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
211 | 2024.10.09 22:41:23.433256 [ 3 ] {b99b3c35-2081-4209-b760-4498a76113e9} <Debug> executeQuery: (from [::1]:54088) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
212 | 2024.10.09 22:41:23.433566 [ 3 ] {b99b3c35-2081-4209-b760-4498a76113e9} <Debug> DynamicQueryHandler: Done processing query | ||
213 | 2024.10.09 22:41:23.433593 [ 3 ] {} <Debug> HTTP-Session: 2f7f73c1-6d9c-4db5-a821-b7b59d98f58d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
214 | 2024.10.09 22:41:23.434720 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
215 | 2024.10.09 22:41:23.434800 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
216 | 2024.10.09 22:41:23.434824 [ 3 ] {} <Debug> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Authenticating user 'default' from [::1]:54088 | ||
217 | 2024.10.09 22:41:23.434844 [ 3 ] {} <Debug> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
218 | 2024.10.09 22:41:23.434864 [ 3 ] {} <Debug> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
219 | 2024.10.09 22:41:23.434904 [ 3 ] {} <Trace> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
220 | 2024.10.09 22:41:23.435032 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Debug> executeQuery: (from [::1]:54088) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
221 | 2024.10.09 22:41:23.435113 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
222 | 2024.10.09 22:41:23.436715 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
223 | 2024.10.09 22:41:23.436751 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.8526e-05 sec | ||
224 | 2024.10.09 22:41:23.436766 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Trace> ReferentialDeps: No tables | ||
225 | 2024.10.09 22:41:23.436777 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Trace> LoadingDeps: No tables | ||
226 | 2024.10.09 22:41:23.436802 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
227 | 2024.10.09 22:41:23.436984 [ 3 ] {604136ad-8a8c-40e1-9c88-d5e0f3a8be55} <Debug> DynamicQueryHandler: Done processing query | ||
228 | 2024.10.09 22:41:23.437011 [ 3 ] {} <Debug> HTTP-Session: 14d83212-77e6-4316-9128-93f92410f4c3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
229 | 2024.10.09 22:41:23.440454 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
230 | 2024.10.09 22:41:23.440569 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
231 | 2024.10.09 22:41:23.440599 [ 3 ] {} <Debug> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Authenticating user 'default' from [::1]:54088 | ||
232 | 2024.10.09 22:41:23.440625 [ 3 ] {} <Debug> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
233 | 2024.10.09 22:41:23.440641 [ 3 ] {} <Debug> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
234 | 2024.10.09 22:41:23.440700 [ 3 ] {} <Trace> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
235 | 2024.10.09 22:41:23.440968 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Debug> executeQuery: (from [::1]:54088) /* The version table contains metadata about the `oximeter` database */ | ||
236 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
237 | 2024.10.09 22:41:23.441054 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
238 | 2024.10.09 22:41:23.442836 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
239 | 2024.10.09 22:41:23.444090 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Debug> oximeter.version (ecf87412-7125-42ca-af4b-146907caf653): Loading data parts | ||
240 | 2024.10.09 22:41:23.445838 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Debug> oximeter.version (ecf87412-7125-42ca-af4b-146907caf653): There are no data parts | ||
241 | 2024.10.09 22:41:23.447763 [ 3 ] {6f6b3db0-9758-44e4-bd12-68ef92480ceb} <Debug> DynamicQueryHandler: Done processing query | ||
242 | 2024.10.09 22:41:23.447797 [ 3 ] {} <Debug> HTTP-Session: 7bcba549-563d-4b7b-a029-2c11ec6182bd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
243 | 2024.10.09 22:41:23.449339 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
244 | 2024.10.09 22:41:23.449422 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
245 | 2024.10.09 22:41:23.449447 [ 3 ] {} <Debug> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Authenticating user 'default' from [::1]:54088 | ||
246 | 2024.10.09 22:41:23.449483 [ 3 ] {} <Debug> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
247 | 2024.10.09 22:41:23.449500 [ 3 ] {} <Debug> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
248 | 2024.10.09 22:41:23.449551 [ 3 ] {} <Trace> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
249 | 2024.10.09 22:41:23.449884 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Debug> executeQuery: (from [::1]:54088) /* The measurement tables contain all individual samples from each timeseries. | ||
250 | * | ||
251 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
252 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
253 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
254 | * by all samples from the same timeseries. | ||
255 | * | ||
256 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
257 | * and then uses that to index quickly into the measurements tables. | ||
258 | */ | ||
259 | 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) | ||
260 | 2024.10.09 22:41:23.449961 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
261 | 2024.10.09 22:41:23.452566 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Debug> oximeter.measurements_bool (eadd5c04-3804-43a7-94c3-ee8c1a0abf0b): Loading data parts | ||
262 | 2024.10.09 22:41:23.452943 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Debug> oximeter.measurements_bool (eadd5c04-3804-43a7-94c3-ee8c1a0abf0b): There are no data parts | ||
263 | 2024.10.09 22:41:23.454755 [ 3 ] {2be34b27-cd93-4b3e-a00f-209b16578825} <Debug> DynamicQueryHandler: Done processing query | ||
264 | 2024.10.09 22:41:23.454786 [ 3 ] {} <Debug> HTTP-Session: db54430b-e14d-4707-858d-83e857fd63e3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
265 | 2024.10.09 22:41:23.456246 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
266 | 2024.10.09 22:41:23.456336 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
267 | 2024.10.09 22:41:23.456360 [ 3 ] {} <Debug> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Authenticating user 'default' from [::1]:54088 | ||
268 | 2024.10.09 22:41:23.456384 [ 3 ] {} <Debug> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
269 | 2024.10.09 22:41:23.456399 [ 3 ] {} <Debug> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
270 | 2024.10.09 22:41:23.456460 [ 3 ] {} <Trace> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
271 | 2024.10.09 22:41:23.456786 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Debug> executeQuery: (from [::1]:54088) 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) | ||
272 | 2024.10.09 22:41:23.456863 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
273 | 2024.10.09 22:41:23.459339 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Debug> oximeter.measurements_i8 (9277c57e-a806-4559-abc5-ec6a36a049ad): Loading data parts | ||
274 | 2024.10.09 22:41:23.459751 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Debug> oximeter.measurements_i8 (9277c57e-a806-4559-abc5-ec6a36a049ad): There are no data parts | ||
275 | 2024.10.09 22:41:23.461706 [ 3 ] {79ef985c-5173-457c-87f2-fcf2feb739fa} <Debug> DynamicQueryHandler: Done processing query | ||
276 | 2024.10.09 22:41:23.461740 [ 3 ] {} <Debug> HTTP-Session: 47518210-b773-45f9-85bf-a0c68311fbba Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
277 | 2024.10.09 22:41:23.466389 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
278 | 2024.10.09 22:41:23.466545 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
279 | 2024.10.09 22:41:23.466581 [ 3 ] {} <Debug> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Authenticating user 'default' from [::1]:54088 | ||
280 | 2024.10.09 22:41:23.466625 [ 3 ] {} <Debug> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
281 | 2024.10.09 22:41:23.466641 [ 3 ] {} <Debug> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
282 | 2024.10.09 22:41:23.466701 [ 3 ] {} <Trace> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
283 | 2024.10.09 22:41:23.467112 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Debug> executeQuery: (from [::1]:54088) 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) | ||
284 | 2024.10.09 22:41:23.467185 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
285 | 2024.10.09 22:41:23.469643 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Debug> oximeter.measurements_u8 (01b47331-4741-4f7c-91bc-6fb5adbac76e): Loading data parts | ||
286 | 2024.10.09 22:41:23.469930 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Debug> oximeter.measurements_u8 (01b47331-4741-4f7c-91bc-6fb5adbac76e): There are no data parts | ||
287 | 2024.10.09 22:41:23.471697 [ 3 ] {bbd84729-5813-4900-bd19-47ff20cd0931} <Debug> DynamicQueryHandler: Done processing query | ||
288 | 2024.10.09 22:41:23.471742 [ 3 ] {} <Debug> HTTP-Session: 4be92dc4-f3b8-4be0-aed2-526fb7f7de41 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
289 | 2024.10.09 22:41:23.473243 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
290 | 2024.10.09 22:41:23.473341 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
291 | 2024.10.09 22:41:23.473384 [ 3 ] {} <Debug> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Authenticating user 'default' from [::1]:54088 | ||
292 | 2024.10.09 22:41:23.473446 [ 3 ] {} <Debug> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
293 | 2024.10.09 22:41:23.473472 [ 3 ] {} <Debug> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
294 | 2024.10.09 22:41:23.473537 [ 3 ] {} <Trace> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
295 | 2024.10.09 22:41:23.473874 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Debug> executeQuery: (from [::1]:54088) 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) | ||
296 | 2024.10.09 22:41:23.473959 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
297 | 2024.10.09 22:41:23.476884 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Debug> oximeter.measurements_i16 (c2d89c15-84ed-4c60-ab88-f764575f311d): Loading data parts | ||
298 | 2024.10.09 22:41:23.477403 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Debug> oximeter.measurements_i16 (c2d89c15-84ed-4c60-ab88-f764575f311d): There are no data parts | ||
299 | 2024.10.09 22:41:23.479784 [ 3 ] {ba0aaafe-568c-43f7-91e2-e1245dde2342} <Debug> DynamicQueryHandler: Done processing query | ||
300 | 2024.10.09 22:41:23.479818 [ 3 ] {} <Debug> HTTP-Session: 6e1d52b8-7093-42f6-a765-7c0e085dfd48 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
301 | 2024.10.09 22:41:23.483253 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
302 | 2024.10.09 22:41:23.483376 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
303 | 2024.10.09 22:41:23.483407 [ 3 ] {} <Debug> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Authenticating user 'default' from [::1]:54088 | ||
304 | 2024.10.09 22:41:23.483436 [ 3 ] {} <Debug> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
305 | 2024.10.09 22:41:23.483461 [ 3 ] {} <Debug> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
306 | 2024.10.09 22:41:23.483517 [ 3 ] {} <Trace> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
307 | 2024.10.09 22:41:23.483963 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Debug> executeQuery: (from [::1]:54088) 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) | ||
308 | 2024.10.09 22:41:23.484051 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
309 | 2024.10.09 22:41:23.486765 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Debug> oximeter.measurements_u16 (a78c3eea-3335-43a6-b953-637564bc0df7): Loading data parts | ||
310 | 2024.10.09 22:41:23.487169 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Debug> oximeter.measurements_u16 (a78c3eea-3335-43a6-b953-637564bc0df7): There are no data parts | ||
311 | 2024.10.09 22:41:23.488839 [ 3 ] {b6e21a46-717d-4a13-a633-98d003922609} <Debug> DynamicQueryHandler: Done processing query | ||
312 | 2024.10.09 22:41:23.488867 [ 3 ] {} <Debug> HTTP-Session: 354ffe45-1893-4335-b7e3-67d48e2ab622 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
313 | 2024.10.09 22:41:23.491156 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
314 | 2024.10.09 22:41:23.491307 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
315 | 2024.10.09 22:41:23.491369 [ 3 ] {} <Debug> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Authenticating user 'default' from [::1]:54088 | ||
316 | 2024.10.09 22:41:23.491399 [ 3 ] {} <Debug> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
317 | 2024.10.09 22:41:23.491416 [ 3 ] {} <Debug> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
318 | 2024.10.09 22:41:23.491471 [ 3 ] {} <Trace> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
319 | 2024.10.09 22:41:23.491883 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Debug> executeQuery: (from [::1]:54088) 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) | ||
320 | 2024.10.09 22:41:23.491975 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
321 | 2024.10.09 22:41:23.495425 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Debug> oximeter.measurements_i32 (0ecb1402-020f-48ee-9bd6-d557651bb572): Loading data parts | ||
322 | 2024.10.09 22:41:23.495824 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Debug> oximeter.measurements_i32 (0ecb1402-020f-48ee-9bd6-d557651bb572): There are no data parts | ||
323 | 2024.10.09 22:41:23.497809 [ 3 ] {78e61605-b6d7-4ac0-a61c-c61062229cf1} <Debug> DynamicQueryHandler: Done processing query | ||
324 | 2024.10.09 22:41:23.497846 [ 3 ] {} <Debug> HTTP-Session: 22605c18-59d5-4452-b3a6-a0a7cc8e3e91 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
325 | 2024.10.09 22:41:23.502226 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
326 | 2024.10.09 22:41:23.502357 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
327 | 2024.10.09 22:41:23.502387 [ 3 ] {} <Debug> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Authenticating user 'default' from [::1]:54088 | ||
328 | 2024.10.09 22:41:23.502414 [ 3 ] {} <Debug> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
329 | 2024.10.09 22:41:23.502483 [ 3 ] {} <Debug> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
330 | 2024.10.09 22:41:23.502553 [ 3 ] {} <Trace> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
331 | 2024.10.09 22:41:23.502931 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Debug> executeQuery: (from [::1]:54088) 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) | ||
332 | 2024.10.09 22:41:23.503019 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
333 | 2024.10.09 22:41:23.505592 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Debug> oximeter.measurements_u32 (be5ec839-a0a8-4f52-b92c-1b9af2d4375e): Loading data parts | ||
334 | 2024.10.09 22:41:23.505969 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Debug> oximeter.measurements_u32 (be5ec839-a0a8-4f52-b92c-1b9af2d4375e): There are no data parts | ||
335 | 2024.10.09 22:41:23.509623 [ 3 ] {552730e7-6198-48f4-bd70-d8fd8b71e1c1} <Debug> DynamicQueryHandler: Done processing query | ||
336 | 2024.10.09 22:41:23.509662 [ 3 ] {} <Debug> HTTP-Session: abeb537a-4c26-4473-91d2-e371b64980b8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
337 | 2024.10.09 22:41:23.510835 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
338 | 2024.10.09 22:41:23.511249 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
339 | 2024.10.09 22:41:23.511286 [ 3 ] {} <Debug> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Authenticating user 'default' from [::1]:54088 | ||
340 | 2024.10.09 22:41:23.511347 [ 3 ] {} <Debug> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
341 | 2024.10.09 22:41:23.511374 [ 3 ] {} <Debug> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
342 | 2024.10.09 22:41:23.511433 [ 3 ] {} <Trace> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
343 | 2024.10.09 22:41:23.511794 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Debug> executeQuery: (from [::1]:54088) 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) | ||
344 | 2024.10.09 22:41:23.511879 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
345 | 2024.10.09 22:41:23.514379 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Debug> oximeter.measurements_i64 (b13a9387-fb7d-4029-be93-ae47ae604ff3): Loading data parts | ||
346 | 2024.10.09 22:41:23.514802 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Debug> oximeter.measurements_i64 (b13a9387-fb7d-4029-be93-ae47ae604ff3): There are no data parts | ||
347 | 2024.10.09 22:41:23.516619 [ 3 ] {9957aec7-365d-4d7f-b846-47fe425aaf19} <Debug> DynamicQueryHandler: Done processing query | ||
348 | 2024.10.09 22:41:23.516686 [ 3 ] {} <Debug> HTTP-Session: 956d9b21-574f-4ebf-b7d9-d0f9cd999d48 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
349 | 2024.10.09 22:41:23.519320 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
350 | 2024.10.09 22:41:23.519451 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
351 | 2024.10.09 22:41:23.519484 [ 3 ] {} <Debug> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Authenticating user 'default' from [::1]:54088 | ||
352 | 2024.10.09 22:41:23.519936 [ 3 ] {} <Debug> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
353 | 2024.10.09 22:41:23.519971 [ 3 ] {} <Debug> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
354 | 2024.10.09 22:41:23.520070 [ 3 ] {} <Trace> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
355 | 2024.10.09 22:41:23.520433 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Debug> executeQuery: (from [::1]:54088) 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) | ||
356 | 2024.10.09 22:41:23.520643 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
357 | 2024.10.09 22:41:23.523260 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Debug> oximeter.measurements_u64 (51d53275-c66c-4742-a99a-171335ce4c21): Loading data parts | ||
358 | 2024.10.09 22:41:23.523676 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Debug> oximeter.measurements_u64 (51d53275-c66c-4742-a99a-171335ce4c21): There are no data parts | ||
359 | 2024.10.09 22:41:23.525510 [ 3 ] {7934602e-b2ba-4a61-98c3-948bf137a17c} <Debug> DynamicQueryHandler: Done processing query | ||
360 | 2024.10.09 22:41:23.525545 [ 3 ] {} <Debug> HTTP-Session: 7111dd0b-d2d8-4111-a519-45b0a34acd60 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
361 | 2024.10.09 22:41:23.526744 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
362 | 2024.10.09 22:41:23.526838 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
363 | 2024.10.09 22:41:23.526862 [ 3 ] {} <Debug> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Authenticating user 'default' from [::1]:54088 | ||
364 | 2024.10.09 22:41:23.526889 [ 3 ] {} <Debug> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
365 | 2024.10.09 22:41:23.527028 [ 3 ] {} <Debug> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
366 | 2024.10.09 22:41:23.527100 [ 3 ] {} <Trace> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
367 | 2024.10.09 22:41:23.527488 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Debug> executeQuery: (from [::1]:54088) 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) | ||
368 | 2024.10.09 22:41:23.527563 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
369 | 2024.10.09 22:41:23.530103 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Debug> oximeter.measurements_f32 (1dc49642-ca40-4738-9c5b-222ad09cda9f): Loading data parts | ||
370 | 2024.10.09 22:41:23.530492 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Debug> oximeter.measurements_f32 (1dc49642-ca40-4738-9c5b-222ad09cda9f): There are no data parts | ||
371 | 2024.10.09 22:41:23.532265 [ 3 ] {09559726-b87f-430c-8153-75aecd2a18bf} <Debug> DynamicQueryHandler: Done processing query | ||
372 | 2024.10.09 22:41:23.532305 [ 3 ] {} <Debug> HTTP-Session: ead7628a-d06f-4f48-a9e0-a7c4ffabdeec Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
373 | 2024.10.09 22:41:23.535229 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
374 | 2024.10.09 22:41:23.535328 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
375 | 2024.10.09 22:41:23.535382 [ 3 ] {} <Debug> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Authenticating user 'default' from [::1]:54088 | ||
376 | 2024.10.09 22:41:23.535409 [ 3 ] {} <Debug> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
377 | 2024.10.09 22:41:23.535425 [ 3 ] {} <Debug> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
378 | 2024.10.09 22:41:23.535489 [ 3 ] {} <Trace> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
379 | 2024.10.09 22:41:23.535925 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Debug> executeQuery: (from [::1]:54088) 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) | ||
380 | 2024.10.09 22:41:23.536039 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
381 | 2024.10.09 22:41:23.538538 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Debug> oximeter.measurements_f64 (460fe727-3d51-4dbc-9fc8-26324ba1640e): Loading data parts | ||
382 | 2024.10.09 22:41:23.538871 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Debug> oximeter.measurements_f64 (460fe727-3d51-4dbc-9fc8-26324ba1640e): There are no data parts | ||
383 | 2024.10.09 22:41:23.540777 [ 3 ] {c829901c-8b42-4a2b-887c-ad64371b390a} <Debug> DynamicQueryHandler: Done processing query | ||
384 | 2024.10.09 22:41:23.540811 [ 3 ] {} <Debug> HTTP-Session: d4a91eb4-32b9-4a07-813f-91321e397238 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
385 | 2024.10.09 22:41:23.541606 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
386 | 2024.10.09 22:41:23.541696 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
387 | 2024.10.09 22:41:23.541725 [ 3 ] {} <Debug> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Authenticating user 'default' from [::1]:54088 | ||
388 | 2024.10.09 22:41:23.541794 [ 3 ] {} <Debug> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
389 | 2024.10.09 22:41:23.541828 [ 3 ] {} <Debug> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
390 | 2024.10.09 22:41:23.541885 [ 3 ] {} <Trace> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
391 | 2024.10.09 22:41:23.542247 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Debug> executeQuery: (from [::1]:54088) 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) | ||
392 | 2024.10.09 22:41:23.542332 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
393 | 2024.10.09 22:41:23.545026 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Debug> oximeter.measurements_string (5053afa9-77d6-4d0e-83d5-f09da09d60d1): Loading data parts | ||
394 | 2024.10.09 22:41:23.545389 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Debug> oximeter.measurements_string (5053afa9-77d6-4d0e-83d5-f09da09d60d1): There are no data parts | ||
395 | 2024.10.09 22:41:23.547200 [ 3 ] {25f57fd3-0c19-4844-86aa-945c836b092a} <Debug> DynamicQueryHandler: Done processing query | ||
396 | 2024.10.09 22:41:23.547236 [ 3 ] {} <Debug> HTTP-Session: b1132c34-dc35-45ff-8fa7-af0d3dad1ddb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
397 | 2024.10.09 22:41:23.548379 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
398 | 2024.10.09 22:41:23.548460 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
399 | 2024.10.09 22:41:23.548558 [ 3 ] {} <Debug> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Authenticating user 'default' from [::1]:54088 | ||
400 | 2024.10.09 22:41:23.548596 [ 3 ] {} <Debug> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
401 | 2024.10.09 22:41:23.548616 [ 3 ] {} <Debug> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
402 | 2024.10.09 22:41:23.548673 [ 3 ] {} <Trace> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
403 | 2024.10.09 22:41:23.549001 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Debug> executeQuery: (from [::1]:54088) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
404 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
405 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
406 | * a string isn't palatable for a few reasons. | ||
407 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
408 | * details. | ||
409 | */ | ||
410 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
411 | 2024.10.09 22:41:23.549082 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
412 | 2024.10.09 22:41:23.551731 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Debug> oximeter.measurements_bytes (b9ce8d1d-ad9b-47f7-beb1-6252648cac9c): Loading data parts | ||
413 | 2024.10.09 22:41:23.552356 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Debug> oximeter.measurements_bytes (b9ce8d1d-ad9b-47f7-beb1-6252648cac9c): There are no data parts | ||
414 | 2024.10.09 22:41:23.554150 [ 3 ] {2dcd3b54-aecc-45f4-af6f-768a0122e506} <Debug> DynamicQueryHandler: Done processing query | ||
415 | 2024.10.09 22:41:23.554197 [ 3 ] {} <Debug> HTTP-Session: b50ddd61-6739-42aa-9a2a-696573615374 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
416 | 2024.10.09 22:41:23.557251 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
417 | 2024.10.09 22:41:23.557505 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
418 | 2024.10.09 22:41:23.557554 [ 3 ] {} <Debug> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Authenticating user 'default' from [::1]:54088 | ||
419 | 2024.10.09 22:41:23.557590 [ 3 ] {} <Debug> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
420 | 2024.10.09 22:41:23.557606 [ 3 ] {} <Debug> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
421 | 2024.10.09 22:41:23.557678 [ 3 ] {} <Trace> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
422 | 2024.10.09 22:41:23.558568 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Debug> executeQuery: (from [::1]:54088) 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) | ||
423 | 2024.10.09 22:41:23.558715 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
424 | 2024.10.09 22:41:23.562975 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Debug> oximeter.measurements_cumulativei64 (39ea44c7-908f-4a15-8750-4349363f3bf9): Loading data parts | ||
425 | 2024.10.09 22:41:23.563384 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Debug> oximeter.measurements_cumulativei64 (39ea44c7-908f-4a15-8750-4349363f3bf9): There are no data parts | ||
426 | 2024.10.09 22:41:23.565875 [ 3 ] {3c48509e-c2d6-4d2b-9fdc-3465aa0ed255} <Debug> DynamicQueryHandler: Done processing query | ||
427 | 2024.10.09 22:41:23.565909 [ 3 ] {} <Debug> HTTP-Session: 7b40d504-5fb2-4575-ad60-54366ba1db07 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
428 | 2024.10.09 22:41:23.567459 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
429 | 2024.10.09 22:41:23.567597 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
430 | 2024.10.09 22:41:23.567633 [ 3 ] {} <Debug> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Authenticating user 'default' from [::1]:54088 | ||
431 | 2024.10.09 22:41:23.567673 [ 3 ] {} <Debug> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
432 | 2024.10.09 22:41:23.567700 [ 3 ] {} <Debug> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
433 | 2024.10.09 22:41:23.567764 [ 3 ] {} <Trace> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
434 | 2024.10.09 22:41:23.568193 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Debug> executeQuery: (from [::1]:54088) 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) | ||
435 | 2024.10.09 22:41:23.568348 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
436 | 2024.10.09 22:41:23.571531 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Debug> oximeter.measurements_cumulativeu64 (ae0bf2c8-240c-47e8-a0ab-8bb743ea420a): Loading data parts | ||
437 | 2024.10.09 22:41:23.571982 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Debug> oximeter.measurements_cumulativeu64 (ae0bf2c8-240c-47e8-a0ab-8bb743ea420a): There are no data parts | ||
438 | 2024.10.09 22:41:23.574092 [ 3 ] {dd88cffe-4c70-47a3-9906-9474155d7481} <Debug> DynamicQueryHandler: Done processing query | ||
439 | 2024.10.09 22:41:23.574143 [ 3 ] {} <Debug> HTTP-Session: 5511f21b-e4a0-437c-85c7-3099221a28a8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
440 | 2024.10.09 22:41:23.575852 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
441 | 2024.10.09 22:41:23.575928 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
442 | 2024.10.09 22:41:23.575961 [ 3 ] {} <Debug> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Authenticating user 'default' from [::1]:54088 | ||
443 | 2024.10.09 22:41:23.575982 [ 3 ] {} <Debug> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
444 | 2024.10.09 22:41:23.575995 [ 3 ] {} <Debug> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
445 | 2024.10.09 22:41:23.576042 [ 3 ] {} <Trace> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
446 | 2024.10.09 22:41:23.576707 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Debug> executeQuery: (from [::1]:54088) 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) | ||
447 | 2024.10.09 22:41:23.576787 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
448 | 2024.10.09 22:41:23.579770 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Debug> oximeter.measurements_cumulativef32 (1642f5c5-0d5c-4ad7-8661-bbe1e4a8f1cd): Loading data parts | ||
449 | 2024.10.09 22:41:23.580089 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Debug> oximeter.measurements_cumulativef32 (1642f5c5-0d5c-4ad7-8661-bbe1e4a8f1cd): There are no data parts | ||
450 | 2024.10.09 22:41:23.582004 [ 3 ] {2c4bf74e-46b0-4d5c-8c48-6b45de04b2a0} <Debug> DynamicQueryHandler: Done processing query | ||
451 | 2024.10.09 22:41:23.582037 [ 3 ] {} <Debug> HTTP-Session: deafab8d-231e-4041-ba85-70bbbdab5d82 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
452 | 2024.10.09 22:41:23.582759 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
453 | 2024.10.09 22:41:23.582881 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
454 | 2024.10.09 22:41:23.582965 [ 3 ] {} <Debug> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Authenticating user 'default' from [::1]:54088 | ||
455 | 2024.10.09 22:41:23.583003 [ 3 ] {} <Debug> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
456 | 2024.10.09 22:41:23.583020 [ 3 ] {} <Debug> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
457 | 2024.10.09 22:41:23.583072 [ 3 ] {} <Trace> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
458 | 2024.10.09 22:41:23.583438 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Debug> executeQuery: (from [::1]:54088) 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) | ||
459 | 2024.10.09 22:41:23.583550 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
460 | 2024.10.09 22:41:23.586243 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Debug> oximeter.measurements_cumulativef64 (586e87bd-d9af-4114-bf9a-e05bbccf02ac): Loading data parts | ||
461 | 2024.10.09 22:41:23.586602 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Debug> oximeter.measurements_cumulativef64 (586e87bd-d9af-4114-bf9a-e05bbccf02ac): There are no data parts | ||
462 | 2024.10.09 22:41:23.588316 [ 3 ] {bbe66a8d-5eff-4e3c-b738-d8399ffa7d97} <Debug> DynamicQueryHandler: Done processing query | ||
463 | 2024.10.09 22:41:23.588343 [ 3 ] {} <Debug> HTTP-Session: 5f34da18-4c46-4c40-b394-710a67c45a37 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
464 | 2024.10.09 22:41:23.595419 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
465 | 2024.10.09 22:41:23.595599 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
466 | 2024.10.09 22:41:23.595636 [ 3 ] {} <Debug> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Authenticating user 'default' from [::1]:54088 | ||
467 | 2024.10.09 22:41:23.595667 [ 3 ] {} <Debug> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
468 | 2024.10.09 22:41:23.595695 [ 3 ] {} <Debug> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
469 | 2024.10.09 22:41:23.595758 [ 3 ] {} <Trace> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
470 | 2024.10.09 22:41:23.596644 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Debug> executeQuery: (from [::1]:54088) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
471 | * NOTE: Array types cannot be Nullable, see | ||
472 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
473 | * for more details. | ||
474 | * | ||
475 | * This means we need to use empty arrays to indicate a missing value. This | ||
476 | * is unfortunate, and at this point relies on the fact that an | ||
477 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
478 | * to figure out another way to represent missing samples here. | ||
479 | */ | ||
480 | 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) | ||
481 | 2024.10.09 22:41:23.596759 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
482 | 2024.10.09 22:41:23.599936 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Debug> oximeter.measurements_histogrami8 (45ac226b-bc4c-42e1-9760-32db67f94611): Loading data parts | ||
483 | 2024.10.09 22:41:23.600305 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Debug> oximeter.measurements_histogrami8 (45ac226b-bc4c-42e1-9760-32db67f94611): There are no data parts | ||
484 | 2024.10.09 22:41:23.602465 [ 3 ] {2a8f6b16-e547-41c6-bab8-7a1315c8edb5} <Debug> DynamicQueryHandler: Done processing query | ||
485 | 2024.10.09 22:41:23.602524 [ 3 ] {} <Debug> HTTP-Session: a84fb724-0cba-421b-b733-3b84854da449 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
486 | 2024.10.09 22:41:23.603649 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
487 | 2024.10.09 22:41:23.604143 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
488 | 2024.10.09 22:41:23.604215 [ 3 ] {} <Debug> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Authenticating user 'default' from [::1]:54088 | ||
489 | 2024.10.09 22:41:23.604262 [ 3 ] {} <Debug> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
490 | 2024.10.09 22:41:23.604281 [ 3 ] {} <Debug> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
491 | 2024.10.09 22:41:23.604366 [ 3 ] {} <Trace> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
492 | 2024.10.09 22:41:23.604960 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Debug> executeQuery: (from [::1]:54088) 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) | ||
493 | 2024.10.09 22:41:23.605062 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
494 | 2024.10.09 22:41:23.608682 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Debug> oximeter.measurements_histogramu8 (ba5db2b4-1dfd-45ca-80c7-ec22f9386cc9): Loading data parts | ||
495 | 2024.10.09 22:41:23.609096 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Debug> oximeter.measurements_histogramu8 (ba5db2b4-1dfd-45ca-80c7-ec22f9386cc9): There are no data parts | ||
496 | 2024.10.09 22:41:23.611349 [ 3 ] {17e4d664-fb0e-4b92-a7c3-57ea9c215f82} <Debug> DynamicQueryHandler: Done processing query | ||
497 | 2024.10.09 22:41:23.611398 [ 3 ] {} <Debug> HTTP-Session: be099911-5c45-4850-8523-3bdb55ad013f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
498 | 2024.10.09 22:41:23.612614 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
499 | 2024.10.09 22:41:23.612874 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
500 | 2024.10.09 22:41:23.612924 [ 3 ] {} <Debug> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Authenticating user 'default' from [::1]:54088 | ||
501 | 2024.10.09 22:41:23.612953 [ 3 ] {} <Debug> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
502 | 2024.10.09 22:41:23.613023 [ 3 ] {} <Debug> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
503 | 2024.10.09 22:41:23.613140 [ 3 ] {} <Trace> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
504 | 2024.10.09 22:41:23.613805 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Debug> executeQuery: (from [::1]:54088) 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) | ||
505 | 2024.10.09 22:41:23.613907 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
506 | 2024.10.09 22:41:23.616988 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Debug> oximeter.measurements_histogrami16 (7179b1ee-68d3-44b6-827d-8fee16e36810): Loading data parts | ||
507 | 2024.10.09 22:41:23.617490 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Debug> oximeter.measurements_histogrami16 (7179b1ee-68d3-44b6-827d-8fee16e36810): There are no data parts | ||
508 | 2024.10.09 22:41:23.619722 [ 3 ] {827f0f89-5d65-4c72-bbce-e73cd7c691fa} <Debug> DynamicQueryHandler: Done processing query | ||
509 | 2024.10.09 22:41:23.619761 [ 3 ] {} <Debug> HTTP-Session: 955c5414-2738-4ddb-82c5-264f43df9c38 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
510 | 2024.10.09 22:41:23.621445 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
511 | 2024.10.09 22:41:23.621580 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
512 | 2024.10.09 22:41:23.621607 [ 3 ] {} <Debug> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Authenticating user 'default' from [::1]:54088 | ||
513 | 2024.10.09 22:41:23.621635 [ 3 ] {} <Debug> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
514 | 2024.10.09 22:41:23.621661 [ 3 ] {} <Debug> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
515 | 2024.10.09 22:41:23.622265 [ 3 ] {} <Trace> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
516 | 2024.10.09 22:41:23.624717 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Debug> executeQuery: (from [::1]:54088) 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) | ||
517 | 2024.10.09 22:41:23.624929 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
518 | 2024.10.09 22:41:23.628738 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Debug> oximeter.measurements_histogramu16 (ed3f3bf7-f69b-48cc-964d-d7359c3ebe13): Loading data parts | ||
519 | 2024.10.09 22:41:23.629341 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Debug> oximeter.measurements_histogramu16 (ed3f3bf7-f69b-48cc-964d-d7359c3ebe13): There are no data parts | ||
520 | 2024.10.09 22:41:23.631819 [ 3 ] {a7322e06-bdd3-4837-be83-5fdd93d8f009} <Debug> DynamicQueryHandler: Done processing query | ||
521 | 2024.10.09 22:41:23.631857 [ 3 ] {} <Debug> HTTP-Session: 0ef89ef9-8bbc-4ac5-84b2-356043ca272f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
522 | 2024.10.09 22:41:23.637728 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
523 | 2024.10.09 22:41:23.637890 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
524 | 2024.10.09 22:41:23.637946 [ 3 ] {} <Debug> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Authenticating user 'default' from [::1]:54088 | ||
525 | 2024.10.09 22:41:23.637977 [ 3 ] {} <Debug> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
526 | 2024.10.09 22:41:23.637994 [ 3 ] {} <Debug> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
527 | 2024.10.09 22:41:23.638058 [ 3 ] {} <Trace> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
528 | 2024.10.09 22:41:23.638625 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Debug> executeQuery: (from [::1]:54088) 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) | ||
529 | 2024.10.09 22:41:23.638729 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
530 | 2024.10.09 22:41:23.641765 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Debug> oximeter.measurements_histogrami32 (3f33e11b-077b-4f44-9128-fd7f4edfe479): Loading data parts | ||
531 | 2024.10.09 22:41:23.642114 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Debug> oximeter.measurements_histogrami32 (3f33e11b-077b-4f44-9128-fd7f4edfe479): There are no data parts | ||
532 | 2024.10.09 22:41:23.644157 [ 3 ] {684e0c76-3c21-4c42-8779-e233d7ae929f} <Debug> DynamicQueryHandler: Done processing query | ||
533 | 2024.10.09 22:41:23.644190 [ 3 ] {} <Debug> HTTP-Session: ba79b29f-5abb-4603-a4a3-84e5b3249fab Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
534 | 2024.10.09 22:41:23.656638 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
535 | 2024.10.09 22:41:23.656790 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
536 | 2024.10.09 22:41:23.656821 [ 3 ] {} <Debug> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Authenticating user 'default' from [::1]:54088 | ||
537 | 2024.10.09 22:41:23.656849 [ 3 ] {} <Debug> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
538 | 2024.10.09 22:41:23.656880 [ 3 ] {} <Debug> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
539 | 2024.10.09 22:41:23.656967 [ 3 ] {} <Trace> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
540 | 2024.10.09 22:41:23.658345 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Debug> executeQuery: (from [::1]:54088) 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) | ||
541 | 2024.10.09 22:41:23.658460 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
542 | 2024.10.09 22:41:23.663463 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Debug> oximeter.measurements_histogramu32 (5813191b-7478-483c-a717-9a636b356290): Loading data parts | ||
543 | 2024.10.09 22:41:23.663809 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Debug> oximeter.measurements_histogramu32 (5813191b-7478-483c-a717-9a636b356290): There are no data parts | ||
544 | 2024.10.09 22:41:23.665752 [ 3 ] {7a50f055-3199-4bd8-8e9e-8a2400eaf67f} <Debug> DynamicQueryHandler: Done processing query | ||
545 | 2024.10.09 22:41:23.665786 [ 3 ] {} <Debug> HTTP-Session: a9668230-8072-45ed-9764-83afdb8a1fdf Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
546 | 2024.10.09 22:41:23.671881 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
547 | 2024.10.09 22:41:23.672108 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
548 | 2024.10.09 22:41:23.672148 [ 3 ] {} <Debug> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Authenticating user 'default' from [::1]:54088 | ||
549 | 2024.10.09 22:41:23.672197 [ 3 ] {} <Debug> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
550 | 2024.10.09 22:41:23.672216 [ 3 ] {} <Debug> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
551 | 2024.10.09 22:41:23.672277 [ 3 ] {} <Trace> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
552 | 2024.10.09 22:41:23.672868 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Debug> executeQuery: (from [::1]:54088) 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) | ||
553 | 2024.10.09 22:41:23.672976 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
554 | 2024.10.09 22:41:23.677382 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Debug> oximeter.measurements_histogrami64 (497cebb0-af08-45a9-be93-fbeb47b403b9): Loading data parts | ||
555 | 2024.10.09 22:41:23.677709 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Debug> oximeter.measurements_histogrami64 (497cebb0-af08-45a9-be93-fbeb47b403b9): There are no data parts | ||
556 | 2024.10.09 22:41:23.680308 [ 3 ] {49b0fee5-9d99-4ad4-926e-58f2e9425972} <Debug> DynamicQueryHandler: Done processing query | ||
557 | 2024.10.09 22:41:23.680374 [ 3 ] {} <Debug> HTTP-Session: c81087f8-270e-4d8f-821a-7c2493f5e2ea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
558 | 2024.10.09 22:41:23.681191 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
559 | 2024.10.09 22:41:23.681286 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
560 | 2024.10.09 22:41:23.681318 [ 3 ] {} <Debug> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Authenticating user 'default' from [::1]:54088 | ||
561 | 2024.10.09 22:41:23.681347 [ 3 ] {} <Debug> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
562 | 2024.10.09 22:41:23.681363 [ 3 ] {} <Debug> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
563 | 2024.10.09 22:41:23.681419 [ 3 ] {} <Trace> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
564 | 2024.10.09 22:41:23.681879 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Debug> executeQuery: (from [::1]:54088) 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) | ||
565 | 2024.10.09 22:41:23.682067 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
566 | 2024.10.09 22:41:23.685176 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Debug> oximeter.measurements_histogramu64 (0fc8a449-d565-42b6-9187-9d9c5f0774fe): Loading data parts | ||
567 | 2024.10.09 22:41:23.685544 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Debug> oximeter.measurements_histogramu64 (0fc8a449-d565-42b6-9187-9d9c5f0774fe): There are no data parts | ||
568 | 2024.10.09 22:41:23.688658 [ 3 ] {5d4c2fc5-2ff8-46ab-8e5e-65441faa5a33} <Debug> DynamicQueryHandler: Done processing query | ||
569 | 2024.10.09 22:41:23.688700 [ 3 ] {} <Debug> HTTP-Session: 222ccdb1-385b-496b-a15a-7af892170776 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
570 | 2024.10.09 22:41:23.689775 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
571 | 2024.10.09 22:41:23.689877 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
572 | 2024.10.09 22:41:23.689903 [ 3 ] {} <Debug> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Authenticating user 'default' from [::1]:54088 | ||
573 | 2024.10.09 22:41:23.689938 [ 3 ] {} <Debug> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
574 | 2024.10.09 22:41:23.689955 [ 3 ] {} <Debug> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
575 | 2024.10.09 22:41:23.690008 [ 3 ] {} <Trace> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
576 | 2024.10.09 22:41:23.690505 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Debug> executeQuery: (from [::1]:54088) 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) | ||
577 | 2024.10.09 22:41:23.690960 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
578 | 2024.10.09 22:41:23.697708 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Debug> oximeter.measurements_histogramf32 (783a716b-0a56-49b8-ae35-edad640637e7): Loading data parts | ||
579 | 2024.10.09 22:41:23.698259 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Debug> oximeter.measurements_histogramf32 (783a716b-0a56-49b8-ae35-edad640637e7): There are no data parts | ||
580 | 2024.10.09 22:41:23.704977 [ 3 ] {af06796d-a2ee-414b-8b3b-42fbc548a66f} <Debug> DynamicQueryHandler: Done processing query | ||
581 | 2024.10.09 22:41:23.705196 [ 3 ] {} <Debug> HTTP-Session: 8ac016c9-75fb-4a14-b396-e6847c2ca5f0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
582 | 2024.10.09 22:41:23.707403 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
583 | 2024.10.09 22:41:23.708489 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
584 | 2024.10.09 22:41:23.708547 [ 3 ] {} <Debug> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Authenticating user 'default' from [::1]:54088 | ||
585 | 2024.10.09 22:41:23.708576 [ 3 ] {} <Debug> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
586 | 2024.10.09 22:41:23.708593 [ 3 ] {} <Debug> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
587 | 2024.10.09 22:41:23.708664 [ 3 ] {} <Trace> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
588 | 2024.10.09 22:41:23.709265 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Debug> executeQuery: (from [::1]:54088) 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) | ||
589 | 2024.10.09 22:41:23.709458 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
590 | 2024.10.09 22:41:23.713298 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Debug> oximeter.measurements_histogramf64 (17937a97-76ae-4562-a78c-06bd6714e32f): Loading data parts | ||
591 | 2024.10.09 22:41:23.716400 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Debug> oximeter.measurements_histogramf64 (17937a97-76ae-4562-a78c-06bd6714e32f): There are no data parts | ||
592 | 2024.10.09 22:41:23.719432 [ 3 ] {ab77b26a-f8fd-4faf-a8c3-517a3dcb2985} <Debug> DynamicQueryHandler: Done processing query | ||
593 | 2024.10.09 22:41:23.719476 [ 3 ] {} <Debug> HTTP-Session: c1dee930-e76a-4c65-b9c8-94793522d12d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
594 | 2024.10.09 22:41:23.720884 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
595 | 2024.10.09 22:41:23.721008 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
596 | 2024.10.09 22:41:23.721163 [ 3 ] {} <Debug> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Authenticating user 'default' from [::1]:54088 | ||
597 | 2024.10.09 22:41:23.721226 [ 3 ] {} <Debug> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
598 | 2024.10.09 22:41:23.721258 [ 3 ] {} <Debug> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
599 | 2024.10.09 22:41:23.721325 [ 3 ] {} <Trace> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
600 | 2024.10.09 22:41:23.721726 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Debug> executeQuery: (from [::1]:54088) /* The field tables store named dimensions of each timeseries. | ||
601 | * | ||
602 | * As with the measurement tables, there is one field table for each field data | ||
603 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
604 | * this behavior **must not** be relied upon for query correctness. | ||
605 | * | ||
606 | * The index for the fields differs from the measurements, however. Rows are | ||
607 | * sorted by timeseries name, then field name, field value, and finally | ||
608 | * timeseries key. This reflects the most common pattern for looking them up: | ||
609 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
610 | * usually then used to look up measurements. | ||
611 | * | ||
612 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
613 | * timeseries name and then key, since it would improve lookups where one | ||
614 | * already has the key. Realistically though, these tables are quite small and | ||
615 | * so performance benefits will be low in absolute terms. | ||
616 | * | ||
617 | * TTL: We use a materialized column to expire old field table records. This | ||
618 | * column is generated automatically by the database whenever a new row is | ||
619 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
620 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
621 | * record will remain during a deduplication, which will have the last | ||
622 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
623 | * measurement tables. | ||
624 | */ | ||
625 | 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) | ||
626 | 2024.10.09 22:41:23.721834 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
627 | 2024.10.09 22:41:23.726835 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Debug> oximeter.fields_bool (ed36daec-6774-4d6c-870c-bed28b883af8): Loading data parts | ||
628 | 2024.10.09 22:41:23.727455 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Debug> oximeter.fields_bool (ed36daec-6774-4d6c-870c-bed28b883af8): There are no data parts | ||
629 | 2024.10.09 22:41:23.729679 [ 3 ] {5c36467c-03c0-44a5-90fa-74a4f1b999cd} <Debug> DynamicQueryHandler: Done processing query | ||
630 | 2024.10.09 22:41:23.729714 [ 3 ] {} <Debug> HTTP-Session: 955d40c4-6b68-432f-9133-b1431cf5e7b2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
631 | 2024.10.09 22:41:23.731964 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
632 | 2024.10.09 22:41:23.732059 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
633 | 2024.10.09 22:41:23.732088 [ 3 ] {} <Debug> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Authenticating user 'default' from [::1]:54088 | ||
634 | 2024.10.09 22:41:23.732133 [ 3 ] {} <Debug> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
635 | 2024.10.09 22:41:23.732150 [ 3 ] {} <Debug> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
636 | 2024.10.09 22:41:23.732206 [ 3 ] {} <Trace> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
637 | 2024.10.09 22:41:23.732581 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Debug> executeQuery: (from [::1]:54088) 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) | ||
638 | 2024.10.09 22:41:23.732664 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
639 | 2024.10.09 22:41:23.736066 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Debug> oximeter.fields_i8 (3f3df83a-1f59-4bcc-81d4-79a15fa46019): Loading data parts | ||
640 | 2024.10.09 22:41:23.736394 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Debug> oximeter.fields_i8 (3f3df83a-1f59-4bcc-81d4-79a15fa46019): There are no data parts | ||
641 | 2024.10.09 22:41:23.738423 [ 3 ] {8ca8bdbd-1ac3-433f-b9e3-ed68ea7de74c} <Debug> DynamicQueryHandler: Done processing query | ||
642 | 2024.10.09 22:41:23.738455 [ 3 ] {} <Debug> HTTP-Session: 6762b635-a4d1-44ea-a43f-041c01e96d84 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
643 | 2024.10.09 22:41:23.739285 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
644 | 2024.10.09 22:41:23.739413 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
645 | 2024.10.09 22:41:23.739438 [ 3 ] {} <Debug> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Authenticating user 'default' from [::1]:54088 | ||
646 | 2024.10.09 22:41:23.739464 [ 3 ] {} <Debug> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
647 | 2024.10.09 22:41:23.739479 [ 3 ] {} <Debug> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
648 | 2024.10.09 22:41:23.739542 [ 3 ] {} <Trace> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
649 | 2024.10.09 22:41:23.739966 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Debug> executeQuery: (from [::1]:54088) 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) | ||
650 | 2024.10.09 22:41:23.740064 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
651 | 2024.10.09 22:41:23.743863 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Debug> oximeter.fields_u8 (8fb5e568-aa74-439c-9859-0374410f93c3): Loading data parts | ||
652 | 2024.10.09 22:41:23.744351 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Debug> oximeter.fields_u8 (8fb5e568-aa74-439c-9859-0374410f93c3): There are no data parts | ||
653 | 2024.10.09 22:41:23.746278 [ 3 ] {126dd96c-579f-4347-96b0-899902545349} <Debug> DynamicQueryHandler: Done processing query | ||
654 | 2024.10.09 22:41:23.746313 [ 3 ] {} <Debug> HTTP-Session: 365e81cb-018a-40d2-992a-ebb65a9b67bc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
655 | 2024.10.09 22:41:23.747637 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
656 | 2024.10.09 22:41:23.747764 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
657 | 2024.10.09 22:41:23.747796 [ 3 ] {} <Debug> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Authenticating user 'default' from [::1]:54088 | ||
658 | 2024.10.09 22:41:23.747843 [ 3 ] {} <Debug> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
659 | 2024.10.09 22:41:23.747860 [ 3 ] {} <Debug> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
660 | 2024.10.09 22:41:23.747915 [ 3 ] {} <Trace> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
661 | 2024.10.09 22:41:23.748703 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Debug> executeQuery: (from [::1]:54088) 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) | ||
662 | 2024.10.09 22:41:23.748801 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
663 | 2024.10.09 22:41:23.751712 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Debug> oximeter.fields_i16 (fb715786-d474-4282-886a-08e6cb30c064): Loading data parts | ||
664 | 2024.10.09 22:41:23.752086 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Debug> oximeter.fields_i16 (fb715786-d474-4282-886a-08e6cb30c064): There are no data parts | ||
665 | 2024.10.09 22:41:23.754301 [ 3 ] {60037fd6-8bdd-4844-8a87-7d65461c39e8} <Debug> DynamicQueryHandler: Done processing query | ||
666 | 2024.10.09 22:41:23.754397 [ 3 ] {} <Debug> HTTP-Session: 4dc364c0-bdff-41af-9096-21b3e760bed0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
667 | 2024.10.09 22:41:23.757167 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
668 | 2024.10.09 22:41:23.757309 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
669 | 2024.10.09 22:41:23.757367 [ 3 ] {} <Debug> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Authenticating user 'default' from [::1]:54088 | ||
670 | 2024.10.09 22:41:23.757398 [ 3 ] {} <Debug> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
671 | 2024.10.09 22:41:23.757415 [ 3 ] {} <Debug> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
672 | 2024.10.09 22:41:23.757484 [ 3 ] {} <Trace> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
673 | 2024.10.09 22:41:23.758095 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Debug> executeQuery: (from [::1]:54088) 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) | ||
674 | 2024.10.09 22:41:23.758196 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
675 | 2024.10.09 22:41:23.761107 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Debug> oximeter.fields_u16 (37816018-572c-4706-88e8-668be7d2d444): Loading data parts | ||
676 | 2024.10.09 22:41:23.761775 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Debug> oximeter.fields_u16 (37816018-572c-4706-88e8-668be7d2d444): There are no data parts | ||
677 | 2024.10.09 22:41:23.763591 [ 3 ] {95f411e7-839d-4305-86eb-4d77e4939c2b} <Debug> DynamicQueryHandler: Done processing query | ||
678 | 2024.10.09 22:41:23.763616 [ 3 ] {} <Debug> HTTP-Session: 6e55add9-b64e-4aa0-a1f3-8af9cdee6d73 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
679 | 2024.10.09 22:41:23.764646 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
680 | 2024.10.09 22:41:23.764752 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
681 | 2024.10.09 22:41:23.764782 [ 3 ] {} <Debug> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Authenticating user 'default' from [::1]:54088 | ||
682 | 2024.10.09 22:41:23.764811 [ 3 ] {} <Debug> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
683 | 2024.10.09 22:41:23.764840 [ 3 ] {} <Debug> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
684 | 2024.10.09 22:41:23.764894 [ 3 ] {} <Trace> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
685 | 2024.10.09 22:41:23.765411 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Debug> executeQuery: (from [::1]:54088) 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) | ||
686 | 2024.10.09 22:41:23.765487 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
687 | 2024.10.09 22:41:23.768641 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Debug> oximeter.fields_i32 (ccd5b38f-6ff3-428f-9607-c97dcbb31827): Loading data parts | ||
688 | 2024.10.09 22:41:23.769102 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Debug> oximeter.fields_i32 (ccd5b38f-6ff3-428f-9607-c97dcbb31827): There are no data parts | ||
689 | 2024.10.09 22:41:23.771303 [ 3 ] {40724717-e7b1-44ec-b3ed-e08f771f2b50} <Debug> DynamicQueryHandler: Done processing query | ||
690 | 2024.10.09 22:41:23.771355 [ 3 ] {} <Debug> HTTP-Session: d211f951-208a-436d-a99b-e53c138688dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
691 | 2024.10.09 22:41:23.773409 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
692 | 2024.10.09 22:41:23.773505 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
693 | 2024.10.09 22:41:23.773556 [ 3 ] {} <Debug> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Authenticating user 'default' from [::1]:54088 | ||
694 | 2024.10.09 22:41:23.773585 [ 3 ] {} <Debug> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
695 | 2024.10.09 22:41:23.773603 [ 3 ] {} <Debug> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
696 | 2024.10.09 22:41:23.773654 [ 3 ] {} <Trace> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
697 | 2024.10.09 22:41:23.773998 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Debug> executeQuery: (from [::1]:54088) 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) | ||
698 | 2024.10.09 22:41:23.774084 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
699 | 2024.10.09 22:41:23.777091 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Debug> oximeter.fields_u32 (24bf77c0-3fe2-441d-87ab-673fdb3337f2): Loading data parts | ||
700 | 2024.10.09 22:41:23.777584 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Debug> oximeter.fields_u32 (24bf77c0-3fe2-441d-87ab-673fdb3337f2): There are no data parts | ||
701 | 2024.10.09 22:41:23.779797 [ 3 ] {d5a725c4-9a03-4d78-9b72-2867bb1b9b6c} <Debug> DynamicQueryHandler: Done processing query | ||
702 | 2024.10.09 22:41:23.779875 [ 3 ] {} <Debug> HTTP-Session: f093c804-3500-4d15-bbec-c721275db851 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
703 | 2024.10.09 22:41:23.782898 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
704 | 2024.10.09 22:41:23.783081 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
705 | 2024.10.09 22:41:23.783116 [ 3 ] {} <Debug> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Authenticating user 'default' from [::1]:54088 | ||
706 | 2024.10.09 22:41:23.783143 [ 3 ] {} <Debug> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
707 | 2024.10.09 22:41:23.783184 [ 3 ] {} <Debug> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
708 | 2024.10.09 22:41:23.783238 [ 3 ] {} <Trace> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
709 | 2024.10.09 22:41:23.783597 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Debug> executeQuery: (from [::1]:54088) 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) | ||
710 | 2024.10.09 22:41:23.783666 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
711 | 2024.10.09 22:41:23.786338 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Debug> oximeter.fields_i64 (85811726-6eb4-49ae-a9d5-076dd87d8baf): Loading data parts | ||
712 | 2024.10.09 22:41:23.786607 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Debug> oximeter.fields_i64 (85811726-6eb4-49ae-a9d5-076dd87d8baf): There are no data parts | ||
713 | 2024.10.09 22:41:23.788701 [ 3 ] {49beba20-fcd4-419b-8a2a-5347fbc2d0af} <Debug> DynamicQueryHandler: Done processing query | ||
714 | 2024.10.09 22:41:23.788755 [ 3 ] {} <Debug> HTTP-Session: bc74557d-a0ed-40fe-9aba-e509a8e5387b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
715 | 2024.10.09 22:41:23.789523 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
716 | 2024.10.09 22:41:23.789605 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
717 | 2024.10.09 22:41:23.789637 [ 3 ] {} <Debug> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Authenticating user 'default' from [::1]:54088 | ||
718 | 2024.10.09 22:41:23.789664 [ 3 ] {} <Debug> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
719 | 2024.10.09 22:41:23.789681 [ 3 ] {} <Debug> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
720 | 2024.10.09 22:41:23.789735 [ 3 ] {} <Trace> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
721 | 2024.10.09 22:41:23.790117 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Debug> executeQuery: (from [::1]:54088) 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) | ||
722 | 2024.10.09 22:41:23.790189 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
723 | 2024.10.09 22:41:23.793157 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Debug> oximeter.fields_u64 (e437b084-2d3e-4e43-b801-d7d0db79a59b): Loading data parts | ||
724 | 2024.10.09 22:41:23.793458 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Debug> oximeter.fields_u64 (e437b084-2d3e-4e43-b801-d7d0db79a59b): There are no data parts | ||
725 | 2024.10.09 22:41:23.795505 [ 3 ] {7e21e307-4f4d-49ca-847a-b2a0a8fbe530} <Debug> DynamicQueryHandler: Done processing query | ||
726 | 2024.10.09 22:41:23.795537 [ 3 ] {} <Debug> HTTP-Session: e50ce6f4-3598-4bab-9172-43433e885d9b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
727 | 2024.10.09 22:41:23.796341 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
728 | 2024.10.09 22:41:23.796423 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
729 | 2024.10.09 22:41:23.796451 [ 3 ] {} <Debug> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Authenticating user 'default' from [::1]:54088 | ||
730 | 2024.10.09 22:41:23.796477 [ 3 ] {} <Debug> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
731 | 2024.10.09 22:41:23.796494 [ 3 ] {} <Debug> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
732 | 2024.10.09 22:41:23.796543 [ 3 ] {} <Trace> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
733 | 2024.10.09 22:41:23.796884 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Debug> executeQuery: (from [::1]:54088) 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) | ||
734 | 2024.10.09 22:41:23.796956 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
735 | 2024.10.09 22:41:23.799413 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Debug> oximeter.fields_ipaddr (e93e7381-f555-4de7-a688-84d95418259a): Loading data parts | ||
736 | 2024.10.09 22:41:23.799675 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Debug> oximeter.fields_ipaddr (e93e7381-f555-4de7-a688-84d95418259a): There are no data parts | ||
737 | 2024.10.09 22:41:23.801492 [ 3 ] {9a881752-db81-4390-b3a2-575c7b5272dd} <Debug> DynamicQueryHandler: Done processing query | ||
738 | 2024.10.09 22:41:23.801519 [ 3 ] {} <Debug> HTTP-Session: a55f4e31-e536-4099-b0f4-7b8654e4de5c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
739 | 2024.10.09 22:41:23.802507 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
740 | 2024.10.09 22:41:23.802585 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
741 | 2024.10.09 22:41:23.802611 [ 3 ] {} <Debug> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Authenticating user 'default' from [::1]:54088 | ||
742 | 2024.10.09 22:41:23.802636 [ 3 ] {} <Debug> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
743 | 2024.10.09 22:41:23.802652 [ 3 ] {} <Debug> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
744 | 2024.10.09 22:41:23.802703 [ 3 ] {} <Trace> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
745 | 2024.10.09 22:41:23.803389 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Debug> executeQuery: (from [::1]:54088) 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) | ||
746 | 2024.10.09 22:41:23.803483 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
747 | 2024.10.09 22:41:23.805958 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Debug> oximeter.fields_string (87e857ad-4d2f-4733-9059-f1633fb0615f): Loading data parts | ||
748 | 2024.10.09 22:41:23.806463 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Debug> oximeter.fields_string (87e857ad-4d2f-4733-9059-f1633fb0615f): There are no data parts | ||
749 | 2024.10.09 22:41:23.808327 [ 3 ] {5cdb67df-0b57-4cf2-b13a-8ce78ccd30f3} <Debug> DynamicQueryHandler: Done processing query | ||
750 | 2024.10.09 22:41:23.808355 [ 3 ] {} <Debug> HTTP-Session: f0b86a07-ce9f-46c0-b1ef-0d4ea6c2cff7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
751 | 2024.10.09 22:41:23.809044 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
752 | 2024.10.09 22:41:23.809121 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
753 | 2024.10.09 22:41:23.809148 [ 3 ] {} <Debug> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Authenticating user 'default' from [::1]:54088 | ||
754 | 2024.10.09 22:41:23.809177 [ 3 ] {} <Debug> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
755 | 2024.10.09 22:41:23.809218 [ 3 ] {} <Debug> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
756 | 2024.10.09 22:41:23.809271 [ 3 ] {} <Trace> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
757 | 2024.10.09 22:41:23.809609 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Debug> executeQuery: (from [::1]:54088) 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) | ||
758 | 2024.10.09 22:41:23.809685 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
759 | 2024.10.09 22:41:23.812735 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Debug> oximeter.fields_uuid (69348aab-5b0d-419a-a76d-75c800f5331d): Loading data parts | ||
760 | 2024.10.09 22:41:23.813116 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Debug> oximeter.fields_uuid (69348aab-5b0d-419a-a76d-75c800f5331d): There are no data parts | ||
761 | 2024.10.09 22:41:23.815264 [ 3 ] {b30fc5e6-61c4-40f7-87d9-82b8a15dd8cd} <Debug> DynamicQueryHandler: Done processing query | ||
762 | 2024.10.09 22:41:23.815307 [ 3 ] {} <Debug> HTTP-Session: d3eeb888-f01b-4c50-81da-9e37f55a2e3d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
763 | 2024.10.09 22:41:23.816097 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
764 | 2024.10.09 22:41:23.816181 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
765 | 2024.10.09 22:41:23.816211 [ 3 ] {} <Debug> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Authenticating user 'default' from [::1]:54088 | ||
766 | 2024.10.09 22:41:23.816236 [ 3 ] {} <Debug> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
767 | 2024.10.09 22:41:23.816253 [ 3 ] {} <Debug> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
768 | 2024.10.09 22:41:23.816301 [ 3 ] {} <Trace> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
769 | 2024.10.09 22:41:23.816622 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Debug> executeQuery: (from [::1]:54088) /* The timeseries schema table stores the extracted schema for the samples | ||
770 | * oximeter collects. | ||
771 | */ | ||
772 | 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) | ||
773 | 2024.10.09 22:41:23.816697 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
774 | 2024.10.09 22:41:23.819706 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Debug> oximeter.timeseries_schema (b68a53fa-74e3-4408-a16e-170346656c9f): Loading data parts | ||
775 | 2024.10.09 22:41:23.819982 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Debug> oximeter.timeseries_schema (b68a53fa-74e3-4408-a16e-170346656c9f): There are no data parts | ||
776 | 2024.10.09 22:41:23.822007 [ 3 ] {775f9cca-eb49-4ce0-a24a-634b729779fe} <Debug> DynamicQueryHandler: Done processing query | ||
777 | 2024.10.09 22:41:23.822046 [ 3 ] {} <Debug> HTTP-Session: 33c44394-5806-4bb6-bb95-69a977ad737b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
778 | 2024.10.09 22:41:23.822805 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:54088, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
779 | 2024.10.09 22:41:23.822927 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
780 | 2024.10.09 22:41:23.822959 [ 3 ] {} <Debug> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Authenticating user 'default' from [::1]:54088 | ||
781 | 2024.10.09 22:41:23.822987 [ 3 ] {} <Debug> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
782 | 2024.10.09 22:41:23.823004 [ 3 ] {} <Debug> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
783 | 2024.10.09 22:41:23.823103 [ 3 ] {} <Trace> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
784 | 2024.10.09 22:41:23.823370 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Debug> executeQuery: (from [::1]:54088) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
785 | 2024.10.09 22:41:23.823590 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
786 | 2024.10.09 22:41:23.825449 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> oximeter.version (ecf87412-7125-42ca-af4b-146907caf653): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
787 | 2024.10.09 22:41:23.825510 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 140.21 GiB. | ||
788 | 2024.10.09 22:41:23.826463 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
789 | 2024.10.09 22:41:23.827054 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Trace> oximeter.version (ecf87412-7125-42ca-af4b-146907caf653): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
790 | 2024.10.09 22:41:23.827419 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.004177 sec., 239.40627244433804 rows/sec., 3.74 KiB/sec. | ||
791 | 2024.10.09 22:41:23.827655 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Debug> DynamicQueryHandler: Done processing query | ||
792 | 2024.10.09 22:41:23.827686 [ 3 ] {7c5e925a-e407-4687-9efc-25afa06508bc} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
793 | 2024.10.09 22:41:23.827704 [ 3 ] {} <Debug> HTTP-Session: 40ecfdd3-60e8-4f2b-8a46-dba4faf099f2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
794 | 2024.10.09 22:41:24.000687 [ 246 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 182.38 MiB, peak 187.52 MiB, free memory in arenas 0.00 B, will set to 187.00 MiB (RSS), difference: 4.62 MiB |