| 1 | [ Aug 2 04:44:31 Enabled. ] | ||
| 2 | [ Aug 2 04:44:31 Rereading configuration. ] | ||
| 3 | [ Aug 2 04:44:33 Rereading configuration. ] | ||
| 4 | [ Aug 2 04:44:46 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ] | ||
| 5 | + set -o errexit | ||
| 6 | + set -o pipefail | ||
| 7 | + . /lib/svc/share/smf_include.sh | ||
| 8 | ++ SMF_EXIT_OK=0 | ||
| 9 | ++ SMF_EXIT_NODAEMON=94 | ||
| 10 | ++ SMF_EXIT_ERR_FATAL=95 | ||
| 11 | ++ SMF_EXIT_ERR_CONFIG=96 | ||
| 12 | ++ SMF_EXIT_MON_DEGRADE=97 | ||
| 13 | ++ SMF_EXIT_MON_OFFLINE=98 | ||
| 14 | ++ SMF_EXIT_ERR_NOSMF=99 | ||
| 15 | ++ SMF_EXIT_ERR_PERM=100 | ||
| 16 | ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default | ||
| 17 | + LISTEN_ADDR=fd00:1122:3344:101::e | ||
| 18 | ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default | ||
| 19 | + LISTEN_PORT=8123 | ||
| 20 | ++ svcprop -c -p config/store svc:/oxide/clickhouse:default | ||
| 21 | + DATASTORE=/data | ||
| 22 | + single_node=true | ||
| 23 | + command=() | ||
| 24 | + true | ||
| 25 | + command+=("/opt/oxide/clickhouse/clickhouse" "server" "--log-file" "/var/tmp/clickhouse-server.log" "--errorlog-file" "/var/tmp/clickhouse-server.errlog" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
| 26 | + exec /opt/oxide/clickhouse/clickhouse server --log-file /var/tmp/clickhouse-server.log --errorlog-file /var/tmp/clickhouse-server.errlog -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123 | ||
| 27 | [ Aug 2 04:44:46 Method "start" exited with status 0. ] | ||
| 28 | Processing configuration file 'config.xml'. | ||
| 29 | There is no file 'config.xml', will use embedded config. | ||
| 30 | Logging trace to /var/tmp/clickhouse-server.log | ||
| 31 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
| 32 | 2024.08.02 04:44:47.438065 [ 1 ] {} <Information> Application: Will watch for the process with pid 24265 | ||
| 33 | 2024.08.02 04:44:47.438652 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 34 | 2024.08.02 04:44:47.863409 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 24265 | ||
| 35 | 2024.08.02 04:44:47.864165 [ 1 ] {} <Information> Application: starting up | ||
| 36 | 2024.08.02 04:44:47.864878 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 37 | 2024.08.02 04:44:47.954305 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
| 38 | 2024.08.02 04:44:48.003087 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 39 | 2024.08.02 04:44:48.003145 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 40 | 2024.08.02 04:44:48.003164 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 41 | 2024.08.02 04:44:48.003246 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
| 42 | 2024.08.02 04:44:48.003553 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 43 | 2024.08.02 04:44:48.005100 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 44 | Processing configuration file 'config.xml'. | ||
| 45 | There is no file 'config.xml', will use embedded config. | ||
| 46 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 47 | 2024.08.02 04:44:48.005615 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 48 | 2024.08.02 04:44:48.006473 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 49 | 2024.08.02 04:44:48.006499 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 50 | 2024.08.02 04:44:48.006512 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
| 51 | 2024.08.02 04:44:48.006701 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 52 | 2024.08.02 04:44:48.007750 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 53 | 2024.08.02 04:44:48.013401 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 54 | 2024.08.02 04:44:48.014206 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 55 | 2024.08.02 04:44:48.015738 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 56 | 2024.08.02 04:44:48.015810 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 57 | 2024.08.02 04:44:48.017358 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 58 | Processing configuration file 'config.xml'. | ||
| 59 | There is no file 'config.xml', will use embedded config. | ||
| 60 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 61 | 2024.08.02 04:44:48.017683 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 62 | 2024.08.02 04:44:48.022099 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 63 | 2024.08.02 04:44:48.022598 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 64 | 2024.08.02 04:44:48.024229 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 65 | 2024.08.02 04:44:48.024695 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 66 | 2024.08.02 04:44:48.025108 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 67 | 2024.08.02 04:44:48.025519 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 68 | 2024.08.02 04:44:48.026957 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 69 | 2024.08.02 04:44:48.026986 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 70 | 2024.08.02 04:44:48.027078 [ 29 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 71 | 2024.08.02 04:44:48.027247 [ 29 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 72 | 2024.08.02 04:44:48.046158 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 73 | 2024.08.02 04:44:48.046193 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000159504 sec | ||
| 74 | 2024.08.02 04:44:48.046230 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 75 | 2024.08.02 04:44:48.046242 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 76 | 2024.08.02 04:44:48.047374 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 77 | 2024.08.02 04:44:48.048440 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 78 | 2024.08.02 04:44:48.048463 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 79 | 2024.08.02 04:44:48.048495 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 80 | 2024.08.02 04:44:48.048510 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 81 | 2024.08.02 04:44:48.048523 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 82 | 2024.08.02 04:44:48.048557 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 83 | 2024.08.02 04:44:48.048571 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 84 | 2024.08.02 04:44:48.048587 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 85 | 2024.08.02 04:44:48.048623 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 86 | 2024.08.02 04:44:48.048639 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 87 | 2024.08.02 04:44:48.048653 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 88 | 2024.08.02 04:44:48.048669 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 89 | 2024.08.02 04:44:48.048702 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 90 | 2024.08.02 04:44:48.048717 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 91 | 2024.08.02 04:44:48.048732 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 92 | 2024.08.02 04:44:48.048759 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 93 | 2024.08.02 04:44:48.048774 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 94 | 2024.08.02 04:44:48.086257 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 95 | 2024.08.02 04:44:48.089139 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 96 | 2024.08.02 04:44:48.089173 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.4632e-05 sec | ||
| 97 | 2024.08.02 04:44:48.089189 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 98 | 2024.08.02 04:44:48.089207 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 99 | 2024.08.02 04:44:48.089235 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 100 | 2024.08.02 04:44:48.089436 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
| 101 | 2024.08.02 04:44:48.089485 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 102 | 2024.08.02 04:44:48.089501 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 103 | 2024.08.02 04:44:48.089521 [ 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). | ||
| 104 | 2024.08.02 04:44:48.089537 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 105 | 2024.08.02 04:44:48.136161 [ 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) | ||
| 106 | 2024.08.02 04:44:48.343761 [ 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) | ||
| 107 | 2024.08.02 04:44:48.343848 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 108 | 2024.08.02 04:44:48.469101 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 109 | 2024.08.02 04:44:48.469366 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.07 MiB, free memory in arenas 0.00 B, will set to 157.08 MiB (RSS), difference: 147.21 MiB | ||
| 110 | 2024.08.02 04:44:48.470340 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.9251e-05 sec. | ||
| 111 | 2024.08.02 04:44:48.470698 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 112 | 2024.08.02 04:44:48.470804 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 113 | 2024.08.02 04:44:48.470851 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [fd00:1122:3344:101::e]:9004 | ||
| 114 | 2024.08.02 04:44:48.470910 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 115 | 2024.08.02 04:44:52.330759 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 116 | 2024.08.02 04:44:52.330994 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 117 | 2024.08.02 04:44:52.331030 [ 3 ] {} <Debug> HTTP-Session: 95d06f82-c693-49eb-ac99-cae5673555a8 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 118 | 2024.08.02 04:44:52.331063 [ 3 ] {} <Debug> HTTP-Session: 95d06f82-c693-49eb-ac99-cae5673555a8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 119 | 2024.08.02 04:44:52.331083 [ 3 ] {} <Debug> HTTP-Session: 95d06f82-c693-49eb-ac99-cae5673555a8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 120 | 2024.08.02 04:44:52.331169 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 121 | 2024.08.02 04:44:52.331205 [ 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 | ||
| 122 | 2024.08.02 04:44:52.331226 [ 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 | ||
| 123 | 2024.08.02 04:44:52.331293 [ 3 ] {} <Trace> HTTP-Session: 95d06f82-c693-49eb-ac99-cae5673555a8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 124 | 2024.08.02 04:44:52.332423 [ 3 ] {a2ad2e9c-d2a0-4b25-af93-a22c18d40d9b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 125 | 2024.08.02 04:44:52.370888 [ 3 ] {a2ad2e9c-d2a0-4b25-af93-a22c18d40d9b} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:63561) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 126 | |||
| 127 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 128 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 129 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 130 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 131 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 132 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 133 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 134 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 135 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 136 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 137 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 138 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 139 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 140 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /opt/oxide/clickhouse/clickhouse | ||
| 141 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 142 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 143 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 144 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 145 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 146 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 147 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 148 | 21. _thrp_setup @ 0x0000000000114307 in /system/lib/amd64/libc.so.1 | ||
| 149 | |||
| 150 | 2024.08.02 04:44:52.371634 [ 3 ] {a2ad2e9c-d2a0-4b25-af93-a22c18d40d9b} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 151 | |||
| 152 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 153 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 154 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 155 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 156 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 157 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 158 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 159 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 160 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 161 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 162 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 163 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 164 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 165 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /opt/oxide/clickhouse/clickhouse | ||
| 166 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 167 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 168 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 169 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 170 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 171 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 172 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 173 | 21. _thrp_setup @ 0x0000000000114307 in /system/lib/amd64/libc.so.1 | ||
| 174 | (version 23.8.7.1) | ||
| 175 | 2024.08.02 04:44:52.372993 [ 3 ] {} <Debug> HTTP-Session: 95d06f82-c693-49eb-ac99-cae5673555a8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 176 | 2024.08.02 04:44:52.375250 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 33, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 177 | 2024.08.02 04:44:52.375323 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 178 | 2024.08.02 04:44:52.375348 [ 3 ] {} <Debug> HTTP-Session: 156afa76-34f3-4f9d-ad01-9684be4f7a3c Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 179 | 2024.08.02 04:44:52.375376 [ 3 ] {} <Debug> HTTP-Session: 156afa76-34f3-4f9d-ad01-9684be4f7a3c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 180 | 2024.08.02 04:44:52.375389 [ 3 ] {} <Debug> HTTP-Session: 156afa76-34f3-4f9d-ad01-9684be4f7a3c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 181 | 2024.08.02 04:44:52.375435 [ 3 ] {} <Trace> HTTP-Session: 156afa76-34f3-4f9d-ad01-9684be4f7a3c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 182 | 2024.08.02 04:44:52.376571 [ 3 ] {8975755a-d1c1-46fd-8cab-0a95fe190d4e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) SHOW CLUSTERS FORMAT JSONEachRow; (stage: Complete) | ||
| 183 | 2024.08.02 04:44:52.376695 [ 3 ] {8975755a-d1c1-46fd-8cab-0a95fe190d4e} <Debug> executeQuery: (internal) SELECT DISTINCT cluster FROM system.clusters ORDER BY cluster (stage: Complete) | ||
| 184 | 2024.08.02 04:44:52.378739 [ 3 ] {8975755a-d1c1-46fd-8cab-0a95fe190d4e} <Trace> ContextAccess (default): Access granted: SELECT(cluster) ON system.clusters | ||
| 185 | 2024.08.02 04:44:52.381551 [ 3 ] {8975755a-d1c1-46fd-8cab-0a95fe190d4e} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 186 | 2024.08.02 04:44:52.387407 [ 3 ] {8975755a-d1c1-46fd-8cab-0a95fe190d4e} <Debug> DynamicQueryHandler: Done processing query | ||
| 187 | 2024.08.02 04:44:52.387442 [ 3 ] {8975755a-d1c1-46fd-8cab-0a95fe190d4e} <Debug> MemoryTracker: Peak memory usage (for query): 3.00 MiB. | ||
| 188 | 2024.08.02 04:44:52.387463 [ 3 ] {} <Debug> HTTP-Session: 156afa76-34f3-4f9d-ad01-9684be4f7a3c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 189 | 2024.08.02 04:44:52.397390 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 190 | 2024.08.02 04:44:52.397459 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 191 | 2024.08.02 04:44:52.397486 [ 3 ] {} <Debug> HTTP-Session: e8e6b104-196b-48c6-afe2-6f7c0d676343 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 192 | 2024.08.02 04:44:52.397505 [ 3 ] {} <Debug> HTTP-Session: e8e6b104-196b-48c6-afe2-6f7c0d676343 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 193 | 2024.08.02 04:44:52.397522 [ 3 ] {} <Debug> HTTP-Session: e8e6b104-196b-48c6-afe2-6f7c0d676343 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 194 | 2024.08.02 04:44:52.397562 [ 3 ] {} <Trace> HTTP-Session: e8e6b104-196b-48c6-afe2-6f7c0d676343 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 195 | 2024.08.02 04:44:52.397701 [ 3 ] {fba6cf7c-c985-43fd-972c-821c08605699} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 196 | 2024.08.02 04:44:52.397967 [ 3 ] {fba6cf7c-c985-43fd-972c-821c08605699} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:63561) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 197 | |||
| 198 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 199 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 200 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 201 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 202 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 203 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 204 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 205 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 206 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 207 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 208 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 209 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 210 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 211 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /opt/oxide/clickhouse/clickhouse | ||
| 212 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 213 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 214 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 215 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 216 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 217 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 218 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 219 | 21. _thrp_setup @ 0x0000000000114307 in /system/lib/amd64/libc.so.1 | ||
| 220 | |||
| 221 | 2024.08.02 04:44:52.398098 [ 3 ] {fba6cf7c-c985-43fd-972c-821c08605699} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 222 | |||
| 223 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 224 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 225 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 226 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 227 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 228 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 229 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 230 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 231 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 232 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 233 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 234 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 235 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 236 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /opt/oxide/clickhouse/clickhouse | ||
| 237 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 238 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 239 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 240 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 241 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 242 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 243 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 244 | 21. _thrp_setup @ 0x0000000000114307 in /system/lib/amd64/libc.so.1 | ||
| 245 | (version 23.8.7.1) | ||
| 246 | 2024.08.02 04:44:52.398249 [ 3 ] {} <Debug> HTTP-Session: e8e6b104-196b-48c6-afe2-6f7c0d676343 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 247 | 2024.08.02 04:44:52.402259 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 248 | 2024.08.02 04:44:52.402314 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 249 | 2024.08.02 04:44:52.402332 [ 3 ] {} <Debug> HTTP-Session: d3518df6-e969-47b3-81e8-09478c6d982f Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 250 | 2024.08.02 04:44:52.402353 [ 3 ] {} <Debug> HTTP-Session: d3518df6-e969-47b3-81e8-09478c6d982f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 251 | 2024.08.02 04:44:52.402370 [ 3 ] {} <Debug> HTTP-Session: d3518df6-e969-47b3-81e8-09478c6d982f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 252 | 2024.08.02 04:44:52.402400 [ 3 ] {} <Trace> HTTP-Session: d3518df6-e969-47b3-81e8-09478c6d982f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 253 | 2024.08.02 04:44:52.402573 [ 3 ] {b2fd2167-7773-489e-83b5-d1ac5776f91f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 254 | 2024.08.02 04:44:52.402738 [ 3 ] {b2fd2167-7773-489e-83b5-d1ac5776f91f} <Debug> DynamicQueryHandler: Done processing query | ||
| 255 | 2024.08.02 04:44:52.402765 [ 3 ] {} <Debug> HTTP-Session: d3518df6-e969-47b3-81e8-09478c6d982f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 256 | 2024.08.02 04:44:52.402899 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 257 | 2024.08.02 04:44:52.402949 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 258 | 2024.08.02 04:44:52.402973 [ 3 ] {} <Debug> HTTP-Session: 1f91d3ae-b772-4c59-9068-ae50ee69f19f Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 259 | 2024.08.02 04:44:52.402989 [ 3 ] {} <Debug> HTTP-Session: 1f91d3ae-b772-4c59-9068-ae50ee69f19f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 260 | 2024.08.02 04:44:52.403006 [ 3 ] {} <Debug> HTTP-Session: 1f91d3ae-b772-4c59-9068-ae50ee69f19f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 261 | 2024.08.02 04:44:52.403038 [ 3 ] {} <Trace> HTTP-Session: 1f91d3ae-b772-4c59-9068-ae50ee69f19f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 262 | 2024.08.02 04:44:52.403126 [ 3 ] {b87366d2-594d-4904-94ac-13286c2db095} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 263 | 2024.08.02 04:44:52.403187 [ 3 ] {b87366d2-594d-4904-94ac-13286c2db095} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 264 | 2024.08.02 04:44:52.404267 [ 3 ] {b87366d2-594d-4904-94ac-13286c2db095} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 265 | 2024.08.02 04:44:52.404298 [ 3 ] {b87366d2-594d-4904-94ac-13286c2db095} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.4071e-05 sec | ||
| 266 | 2024.08.02 04:44:52.404311 [ 3 ] {b87366d2-594d-4904-94ac-13286c2db095} <Trace> ReferentialDeps: No tables | ||
| 267 | 2024.08.02 04:44:52.404327 [ 3 ] {b87366d2-594d-4904-94ac-13286c2db095} <Trace> LoadingDeps: No tables | ||
| 268 | 2024.08.02 04:44:52.404351 [ 3 ] {b87366d2-594d-4904-94ac-13286c2db095} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 269 | 2024.08.02 04:44:52.404511 [ 3 ] {b87366d2-594d-4904-94ac-13286c2db095} <Debug> DynamicQueryHandler: Done processing query | ||
| 270 | 2024.08.02 04:44:52.404536 [ 3 ] {} <Debug> HTTP-Session: 1f91d3ae-b772-4c59-9068-ae50ee69f19f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2024.08.02 04:44:52.404650 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 272 | 2024.08.02 04:44:52.404701 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 273 | 2024.08.02 04:44:52.404719 [ 3 ] {} <Debug> HTTP-Session: 2897ac6c-4dcf-4fe8-935f-4e763b6bd96f Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 274 | 2024.08.02 04:44:52.404741 [ 3 ] {} <Debug> HTTP-Session: 2897ac6c-4dcf-4fe8-935f-4e763b6bd96f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2024.08.02 04:44:52.404760 [ 3 ] {} <Debug> HTTP-Session: 2897ac6c-4dcf-4fe8-935f-4e763b6bd96f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 276 | 2024.08.02 04:44:52.404789 [ 3 ] {} <Trace> HTTP-Session: 2897ac6c-4dcf-4fe8-935f-4e763b6bd96f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 277 | 2024.08.02 04:44:52.404931 [ 3 ] {3369d229-63ad-483d-ad07-8aa0382f449f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) /* The version table contains metadata about the `oximeter` database */ | ||
| 278 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 279 | 2024.08.02 04:44:52.404980 [ 3 ] {3369d229-63ad-483d-ad07-8aa0382f449f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 280 | 2024.08.02 04:44:52.408410 [ 3 ] {3369d229-63ad-483d-ad07-8aa0382f449f} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 281 | 2024.08.02 04:44:52.409326 [ 3 ] {3369d229-63ad-483d-ad07-8aa0382f449f} <Debug> oximeter.version (f3f88617-a9c7-4943-b9bd-8c79c9ba3fbd): Loading data parts | ||
| 282 | 2024.08.02 04:44:52.409712 [ 3 ] {3369d229-63ad-483d-ad07-8aa0382f449f} <Debug> oximeter.version (f3f88617-a9c7-4943-b9bd-8c79c9ba3fbd): There are no data parts | ||
| 283 | 2024.08.02 04:44:52.412474 [ 3 ] {3369d229-63ad-483d-ad07-8aa0382f449f} <Debug> DynamicQueryHandler: Done processing query | ||
| 284 | 2024.08.02 04:44:52.412501 [ 3 ] {} <Debug> HTTP-Session: 2897ac6c-4dcf-4fe8-935f-4e763b6bd96f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 285 | 2024.08.02 04:44:52.412634 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 286 | 2024.08.02 04:44:52.412686 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 287 | 2024.08.02 04:44:52.412709 [ 3 ] {} <Debug> HTTP-Session: d78d5db0-6fba-4097-ac79-f6f26d98a4f9 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 288 | 2024.08.02 04:44:52.412725 [ 3 ] {} <Debug> HTTP-Session: d78d5db0-6fba-4097-ac79-f6f26d98a4f9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 289 | 2024.08.02 04:44:52.412742 [ 3 ] {} <Debug> HTTP-Session: d78d5db0-6fba-4097-ac79-f6f26d98a4f9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 290 | 2024.08.02 04:44:52.412775 [ 3 ] {} <Trace> HTTP-Session: d78d5db0-6fba-4097-ac79-f6f26d98a4f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 291 | 2024.08.02 04:44:52.412969 [ 3 ] {2a9ab29a-7778-4fb6-b7a4-39f3ae0397c9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) /* The measurement tables contain all individual samples from each timeseries. | ||
| 292 | * | ||
| 293 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 294 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 295 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 296 | * by all samples from the same timeseries. | ||
| 297 | * | ||
| 298 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 299 | * and then uses that to index quickly into the measurements tables. | ||
| 300 | */ | ||
| 301 | 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) | ||
| 302 | 2024.08.02 04:44:52.413023 [ 3 ] {2a9ab29a-7778-4fb6-b7a4-39f3ae0397c9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 303 | 2024.08.02 04:44:52.419405 [ 3 ] {2a9ab29a-7778-4fb6-b7a4-39f3ae0397c9} <Debug> oximeter.measurements_bool (c7445d88-6f2a-4bbe-a844-c476e8775d7e): Loading data parts | ||
| 304 | 2024.08.02 04:44:52.419572 [ 3 ] {2a9ab29a-7778-4fb6-b7a4-39f3ae0397c9} <Debug> oximeter.measurements_bool (c7445d88-6f2a-4bbe-a844-c476e8775d7e): There are no data parts | ||
| 305 | 2024.08.02 04:44:52.420741 [ 3 ] {2a9ab29a-7778-4fb6-b7a4-39f3ae0397c9} <Debug> DynamicQueryHandler: Done processing query | ||
| 306 | 2024.08.02 04:44:52.420768 [ 3 ] {} <Debug> HTTP-Session: d78d5db0-6fba-4097-ac79-f6f26d98a4f9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.08.02 04:44:52.420914 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 308 | 2024.08.02 04:44:52.420996 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 309 | 2024.08.02 04:44:52.421031 [ 3 ] {} <Debug> HTTP-Session: be6ecbdc-ad2f-47db-beda-cf7a8a91d973 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 310 | 2024.08.02 04:44:52.421057 [ 3 ] {} <Debug> HTTP-Session: be6ecbdc-ad2f-47db-beda-cf7a8a91d973 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2024.08.02 04:44:52.421083 [ 3 ] {} <Debug> HTTP-Session: be6ecbdc-ad2f-47db-beda-cf7a8a91d973 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 312 | 2024.08.02 04:44:52.421113 [ 3 ] {} <Trace> HTTP-Session: be6ecbdc-ad2f-47db-beda-cf7a8a91d973 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 313 | 2024.08.02 04:44:52.421313 [ 3 ] {b6e50d86-8316-4022-9dde-ed13b1de85e3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 314 | 2024.08.02 04:44:52.421361 [ 3 ] {b6e50d86-8316-4022-9dde-ed13b1de85e3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 315 | 2024.08.02 04:44:52.422880 [ 3 ] {b6e50d86-8316-4022-9dde-ed13b1de85e3} <Debug> oximeter.measurements_i8 (dfdfa766-4a96-4b9b-bab6-a00b377d88d0): Loading data parts | ||
| 316 | 2024.08.02 04:44:52.423045 [ 3 ] {b6e50d86-8316-4022-9dde-ed13b1de85e3} <Debug> oximeter.measurements_i8 (dfdfa766-4a96-4b9b-bab6-a00b377d88d0): There are no data parts | ||
| 317 | 2024.08.02 04:44:52.424381 [ 3 ] {b6e50d86-8316-4022-9dde-ed13b1de85e3} <Debug> DynamicQueryHandler: Done processing query | ||
| 318 | 2024.08.02 04:44:52.424416 [ 3 ] {} <Debug> HTTP-Session: be6ecbdc-ad2f-47db-beda-cf7a8a91d973 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.08.02 04:44:52.424538 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 320 | 2024.08.02 04:44:52.424590 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 321 | 2024.08.02 04:44:52.424613 [ 3 ] {} <Debug> HTTP-Session: e5828d7d-0886-49d6-980f-54f7528c1a55 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 322 | 2024.08.02 04:44:52.424629 [ 3 ] {} <Debug> HTTP-Session: e5828d7d-0886-49d6-980f-54f7528c1a55 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 323 | 2024.08.02 04:44:52.424646 [ 3 ] {} <Debug> HTTP-Session: e5828d7d-0886-49d6-980f-54f7528c1a55 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 324 | 2024.08.02 04:44:52.424678 [ 3 ] {} <Trace> HTTP-Session: e5828d7d-0886-49d6-980f-54f7528c1a55 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 325 | 2024.08.02 04:44:52.424848 [ 3 ] {7332be04-22a3-4c3d-a8ca-c8eb2dd41a1d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 326 | 2024.08.02 04:44:52.424898 [ 3 ] {7332be04-22a3-4c3d-a8ca-c8eb2dd41a1d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 327 | 2024.08.02 04:44:52.426641 [ 3 ] {7332be04-22a3-4c3d-a8ca-c8eb2dd41a1d} <Debug> oximeter.measurements_u8 (c6666ded-98f0-432d-9cb9-478cc0f17e2a): Loading data parts | ||
| 328 | 2024.08.02 04:44:52.426807 [ 3 ] {7332be04-22a3-4c3d-a8ca-c8eb2dd41a1d} <Debug> oximeter.measurements_u8 (c6666ded-98f0-432d-9cb9-478cc0f17e2a): There are no data parts | ||
| 329 | 2024.08.02 04:44:52.427956 [ 3 ] {7332be04-22a3-4c3d-a8ca-c8eb2dd41a1d} <Debug> DynamicQueryHandler: Done processing query | ||
| 330 | 2024.08.02 04:44:52.427982 [ 3 ] {} <Debug> HTTP-Session: e5828d7d-0886-49d6-980f-54f7528c1a55 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 331 | 2024.08.02 04:44:52.428131 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 332 | 2024.08.02 04:44:52.428185 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 333 | 2024.08.02 04:44:52.428214 [ 3 ] {} <Debug> HTTP-Session: 95d3b6ec-277f-47a2-9956-b1f7c66947ea Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 334 | 2024.08.02 04:44:52.428230 [ 3 ] {} <Debug> HTTP-Session: 95d3b6ec-277f-47a2-9956-b1f7c66947ea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 335 | 2024.08.02 04:44:52.428248 [ 3 ] {} <Debug> HTTP-Session: 95d3b6ec-277f-47a2-9956-b1f7c66947ea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 336 | 2024.08.02 04:44:52.428280 [ 3 ] {} <Trace> HTTP-Session: 95d3b6ec-277f-47a2-9956-b1f7c66947ea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 337 | 2024.08.02 04:44:52.428456 [ 3 ] {cd6a2eda-9e6a-4490-b980-83b9f32c5849} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 338 | 2024.08.02 04:44:52.428504 [ 3 ] {cd6a2eda-9e6a-4490-b980-83b9f32c5849} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 339 | 2024.08.02 04:44:52.430170 [ 3 ] {cd6a2eda-9e6a-4490-b980-83b9f32c5849} <Debug> oximeter.measurements_i16 (abe4f45a-1cd5-4155-b047-b56e7b938d93): Loading data parts | ||
| 340 | 2024.08.02 04:44:52.430330 [ 3 ] {cd6a2eda-9e6a-4490-b980-83b9f32c5849} <Debug> oximeter.measurements_i16 (abe4f45a-1cd5-4155-b047-b56e7b938d93): There are no data parts | ||
| 341 | 2024.08.02 04:44:52.431972 [ 3 ] {cd6a2eda-9e6a-4490-b980-83b9f32c5849} <Debug> DynamicQueryHandler: Done processing query | ||
| 342 | 2024.08.02 04:44:52.432005 [ 3 ] {} <Debug> HTTP-Session: 95d3b6ec-277f-47a2-9956-b1f7c66947ea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2024.08.02 04:44:52.432124 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 344 | 2024.08.02 04:44:52.432175 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 345 | 2024.08.02 04:44:52.432197 [ 3 ] {} <Debug> HTTP-Session: 7fc88723-7718-4be5-b038-db0149149d11 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 346 | 2024.08.02 04:44:52.432212 [ 3 ] {} <Debug> HTTP-Session: 7fc88723-7718-4be5-b038-db0149149d11 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 347 | 2024.08.02 04:44:52.432229 [ 3 ] {} <Debug> HTTP-Session: 7fc88723-7718-4be5-b038-db0149149d11 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 348 | 2024.08.02 04:44:52.432262 [ 3 ] {} <Trace> HTTP-Session: 7fc88723-7718-4be5-b038-db0149149d11 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 349 | 2024.08.02 04:44:52.432430 [ 3 ] {56b1324e-4b47-4d73-a5f0-e2c063b09855} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 350 | 2024.08.02 04:44:52.432484 [ 3 ] {56b1324e-4b47-4d73-a5f0-e2c063b09855} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 351 | 2024.08.02 04:44:52.434692 [ 3 ] {56b1324e-4b47-4d73-a5f0-e2c063b09855} <Debug> oximeter.measurements_u16 (b4e0da85-af97-4236-ae9e-acbf547db9a9): Loading data parts | ||
| 352 | 2024.08.02 04:44:52.434871 [ 3 ] {56b1324e-4b47-4d73-a5f0-e2c063b09855} <Debug> oximeter.measurements_u16 (b4e0da85-af97-4236-ae9e-acbf547db9a9): There are no data parts | ||
| 353 | 2024.08.02 04:44:52.436187 [ 3 ] {56b1324e-4b47-4d73-a5f0-e2c063b09855} <Debug> DynamicQueryHandler: Done processing query | ||
| 354 | 2024.08.02 04:44:52.436217 [ 3 ] {} <Debug> HTTP-Session: 7fc88723-7718-4be5-b038-db0149149d11 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 355 | 2024.08.02 04:44:52.436327 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 356 | 2024.08.02 04:44:52.436379 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 357 | 2024.08.02 04:44:52.436401 [ 3 ] {} <Debug> HTTP-Session: 18c46dde-e0df-4a45-8706-16110c585662 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 358 | 2024.08.02 04:44:52.436423 [ 3 ] {} <Debug> HTTP-Session: 18c46dde-e0df-4a45-8706-16110c585662 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 359 | 2024.08.02 04:44:52.436436 [ 3 ] {} <Debug> HTTP-Session: 18c46dde-e0df-4a45-8706-16110c585662 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 360 | 2024.08.02 04:44:52.436469 [ 3 ] {} <Trace> HTTP-Session: 18c46dde-e0df-4a45-8706-16110c585662 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 361 | 2024.08.02 04:44:52.436647 [ 3 ] {8b844b38-56e3-4aca-8677-e332ab4a2920} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 362 | 2024.08.02 04:44:52.436696 [ 3 ] {8b844b38-56e3-4aca-8677-e332ab4a2920} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 363 | 2024.08.02 04:44:52.438195 [ 3 ] {8b844b38-56e3-4aca-8677-e332ab4a2920} <Debug> oximeter.measurements_i32 (2cf57c9a-a103-4cb7-8ea9-bbe4b6d5d620): Loading data parts | ||
| 364 | 2024.08.02 04:44:52.438359 [ 3 ] {8b844b38-56e3-4aca-8677-e332ab4a2920} <Debug> oximeter.measurements_i32 (2cf57c9a-a103-4cb7-8ea9-bbe4b6d5d620): There are no data parts | ||
| 365 | 2024.08.02 04:44:52.439652 [ 3 ] {8b844b38-56e3-4aca-8677-e332ab4a2920} <Debug> DynamicQueryHandler: Done processing query | ||
| 366 | 2024.08.02 04:44:52.439684 [ 3 ] {} <Debug> HTTP-Session: 18c46dde-e0df-4a45-8706-16110c585662 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 367 | 2024.08.02 04:44:52.439799 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 368 | 2024.08.02 04:44:52.439852 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 369 | 2024.08.02 04:44:52.439881 [ 3 ] {} <Debug> HTTP-Session: 84cd63e0-64bc-4f58-aa1b-cb59f3e5c5f3 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 370 | 2024.08.02 04:44:52.439897 [ 3 ] {} <Debug> HTTP-Session: 84cd63e0-64bc-4f58-aa1b-cb59f3e5c5f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 371 | 2024.08.02 04:44:52.439914 [ 3 ] {} <Debug> HTTP-Session: 84cd63e0-64bc-4f58-aa1b-cb59f3e5c5f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 372 | 2024.08.02 04:44:52.439947 [ 3 ] {} <Trace> HTTP-Session: 84cd63e0-64bc-4f58-aa1b-cb59f3e5c5f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 373 | 2024.08.02 04:44:52.440119 [ 3 ] {fda075ef-cfb4-4699-b9e8-fbb4983bf72b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 374 | 2024.08.02 04:44:52.440168 [ 3 ] {fda075ef-cfb4-4699-b9e8-fbb4983bf72b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 375 | 2024.08.02 04:44:52.441654 [ 3 ] {fda075ef-cfb4-4699-b9e8-fbb4983bf72b} <Debug> oximeter.measurements_u32 (d6c29855-34b9-4b89-b0ad-72a7fe6f7572): Loading data parts | ||
| 376 | 2024.08.02 04:44:52.441817 [ 3 ] {fda075ef-cfb4-4699-b9e8-fbb4983bf72b} <Debug> oximeter.measurements_u32 (d6c29855-34b9-4b89-b0ad-72a7fe6f7572): There are no data parts | ||
| 377 | 2024.08.02 04:44:52.443484 [ 3 ] {fda075ef-cfb4-4699-b9e8-fbb4983bf72b} <Debug> DynamicQueryHandler: Done processing query | ||
| 378 | 2024.08.02 04:44:52.443515 [ 3 ] {} <Debug> HTTP-Session: 84cd63e0-64bc-4f58-aa1b-cb59f3e5c5f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 379 | 2024.08.02 04:44:52.443645 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 380 | 2024.08.02 04:44:52.443699 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 381 | 2024.08.02 04:44:52.443722 [ 3 ] {} <Debug> HTTP-Session: 1f74f172-4170-4094-8f53-39d3a6538a9a Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 382 | 2024.08.02 04:44:52.443743 [ 3 ] {} <Debug> HTTP-Session: 1f74f172-4170-4094-8f53-39d3a6538a9a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 383 | 2024.08.02 04:44:52.443756 [ 3 ] {} <Debug> HTTP-Session: 1f74f172-4170-4094-8f53-39d3a6538a9a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 384 | 2024.08.02 04:44:52.443787 [ 3 ] {} <Trace> HTTP-Session: 1f74f172-4170-4094-8f53-39d3a6538a9a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 385 | 2024.08.02 04:44:52.443961 [ 3 ] {74ed065e-f3e0-4b22-8d9a-dd4c628cf694} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 386 | 2024.08.02 04:44:52.444014 [ 3 ] {74ed065e-f3e0-4b22-8d9a-dd4c628cf694} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 387 | 2024.08.02 04:44:52.445766 [ 3 ] {74ed065e-f3e0-4b22-8d9a-dd4c628cf694} <Debug> oximeter.measurements_i64 (2aea2b8a-438c-48db-8d10-dc7d42de8263): Loading data parts | ||
| 388 | 2024.08.02 04:44:52.445937 [ 3 ] {74ed065e-f3e0-4b22-8d9a-dd4c628cf694} <Debug> oximeter.measurements_i64 (2aea2b8a-438c-48db-8d10-dc7d42de8263): There are no data parts | ||
| 389 | 2024.08.02 04:44:52.447208 [ 3 ] {74ed065e-f3e0-4b22-8d9a-dd4c628cf694} <Debug> DynamicQueryHandler: Done processing query | ||
| 390 | 2024.08.02 04:44:52.447243 [ 3 ] {} <Debug> HTTP-Session: 1f74f172-4170-4094-8f53-39d3a6538a9a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 391 | 2024.08.02 04:44:52.447376 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 392 | 2024.08.02 04:44:52.447435 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 393 | 2024.08.02 04:44:52.447455 [ 3 ] {} <Debug> HTTP-Session: 2a748674-5fa0-4fe4-929b-027227e53840 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 394 | 2024.08.02 04:44:52.447475 [ 3 ] {} <Debug> HTTP-Session: 2a748674-5fa0-4fe4-929b-027227e53840 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 395 | 2024.08.02 04:44:52.447488 [ 3 ] {} <Debug> HTTP-Session: 2a748674-5fa0-4fe4-929b-027227e53840 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 396 | 2024.08.02 04:44:52.447522 [ 3 ] {} <Trace> HTTP-Session: 2a748674-5fa0-4fe4-929b-027227e53840 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 397 | 2024.08.02 04:44:52.447697 [ 3 ] {37814c59-a47b-4342-98d4-0563c0f94f5c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 398 | 2024.08.02 04:44:52.447746 [ 3 ] {37814c59-a47b-4342-98d4-0563c0f94f5c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 399 | 2024.08.02 04:44:52.449635 [ 3 ] {37814c59-a47b-4342-98d4-0563c0f94f5c} <Debug> oximeter.measurements_u64 (f80d0717-b713-4318-bd26-beb03d68e169): Loading data parts | ||
| 400 | 2024.08.02 04:44:52.449807 [ 3 ] {37814c59-a47b-4342-98d4-0563c0f94f5c} <Debug> oximeter.measurements_u64 (f80d0717-b713-4318-bd26-beb03d68e169): There are no data parts | ||
| 401 | 2024.08.02 04:44:52.451016 [ 3 ] {37814c59-a47b-4342-98d4-0563c0f94f5c} <Debug> DynamicQueryHandler: Done processing query | ||
| 402 | 2024.08.02 04:44:52.451053 [ 3 ] {} <Debug> HTTP-Session: 2a748674-5fa0-4fe4-929b-027227e53840 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 403 | 2024.08.02 04:44:52.451188 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 404 | 2024.08.02 04:44:52.451236 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 405 | 2024.08.02 04:44:52.451263 [ 3 ] {} <Debug> HTTP-Session: cff002b6-b93a-4b36-85b6-9f03cf86515b Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 406 | 2024.08.02 04:44:52.451287 [ 3 ] {} <Debug> HTTP-Session: cff002b6-b93a-4b36-85b6-9f03cf86515b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 407 | 2024.08.02 04:44:52.451300 [ 3 ] {} <Debug> HTTP-Session: cff002b6-b93a-4b36-85b6-9f03cf86515b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 408 | 2024.08.02 04:44:52.451337 [ 3 ] {} <Trace> HTTP-Session: cff002b6-b93a-4b36-85b6-9f03cf86515b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 409 | 2024.08.02 04:44:52.451517 [ 3 ] {891653ad-8dfa-48c6-86e9-f483f738ad2c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 410 | 2024.08.02 04:44:52.451620 [ 3 ] {891653ad-8dfa-48c6-86e9-f483f738ad2c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 411 | 2024.08.02 04:44:52.453287 [ 3 ] {891653ad-8dfa-48c6-86e9-f483f738ad2c} <Debug> oximeter.measurements_f32 (72b4243d-a808-4499-8e69-bf2bdee7fb48): Loading data parts | ||
| 412 | 2024.08.02 04:44:52.453471 [ 3 ] {891653ad-8dfa-48c6-86e9-f483f738ad2c} <Debug> oximeter.measurements_f32 (72b4243d-a808-4499-8e69-bf2bdee7fb48): There are no data parts | ||
| 413 | 2024.08.02 04:44:52.454743 [ 3 ] {891653ad-8dfa-48c6-86e9-f483f738ad2c} <Debug> DynamicQueryHandler: Done processing query | ||
| 414 | 2024.08.02 04:44:52.454770 [ 3 ] {} <Debug> HTTP-Session: cff002b6-b93a-4b36-85b6-9f03cf86515b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 415 | 2024.08.02 04:44:52.454886 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 416 | 2024.08.02 04:44:52.454948 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 417 | 2024.08.02 04:44:52.454968 [ 3 ] {} <Debug> HTTP-Session: d4130ecd-beb2-44c4-90a9-0550793254d7 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 418 | 2024.08.02 04:44:52.454990 [ 3 ] {} <Debug> HTTP-Session: d4130ecd-beb2-44c4-90a9-0550793254d7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 419 | 2024.08.02 04:44:52.455009 [ 3 ] {} <Debug> HTTP-Session: d4130ecd-beb2-44c4-90a9-0550793254d7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 420 | 2024.08.02 04:44:52.455040 [ 3 ] {} <Trace> HTTP-Session: d4130ecd-beb2-44c4-90a9-0550793254d7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 421 | 2024.08.02 04:44:52.455215 [ 3 ] {17727a99-c1d7-484d-83cf-49ad8c79d6cd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 422 | 2024.08.02 04:44:52.455276 [ 3 ] {17727a99-c1d7-484d-83cf-49ad8c79d6cd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 423 | 2024.08.02 04:44:52.456976 [ 3 ] {17727a99-c1d7-484d-83cf-49ad8c79d6cd} <Debug> oximeter.measurements_f64 (e677b282-9afb-4c17-a88d-a690c977d9a4): Loading data parts | ||
| 424 | 2024.08.02 04:44:52.457152 [ 3 ] {17727a99-c1d7-484d-83cf-49ad8c79d6cd} <Debug> oximeter.measurements_f64 (e677b282-9afb-4c17-a88d-a690c977d9a4): There are no data parts | ||
| 425 | 2024.08.02 04:44:52.458353 [ 3 ] {17727a99-c1d7-484d-83cf-49ad8c79d6cd} <Debug> DynamicQueryHandler: Done processing query | ||
| 426 | 2024.08.02 04:44:52.458387 [ 3 ] {} <Debug> HTTP-Session: d4130ecd-beb2-44c4-90a9-0550793254d7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 427 | 2024.08.02 04:44:52.458512 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 428 | 2024.08.02 04:44:52.458563 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 429 | 2024.08.02 04:44:52.458592 [ 3 ] {} <Debug> HTTP-Session: 3f767044-b0ee-4b30-a5eb-60d372c45888 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 430 | 2024.08.02 04:44:52.458614 [ 3 ] {} <Debug> HTTP-Session: 3f767044-b0ee-4b30-a5eb-60d372c45888 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 431 | 2024.08.02 04:44:52.458627 [ 3 ] {} <Debug> HTTP-Session: 3f767044-b0ee-4b30-a5eb-60d372c45888 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 432 | 2024.08.02 04:44:52.458661 [ 3 ] {} <Trace> HTTP-Session: 3f767044-b0ee-4b30-a5eb-60d372c45888 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 433 | 2024.08.02 04:44:52.458836 [ 3 ] {186fe9ed-b879-46bc-98ce-28b13a869813} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 434 | 2024.08.02 04:44:52.458891 [ 3 ] {186fe9ed-b879-46bc-98ce-28b13a869813} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 435 | 2024.08.02 04:44:52.460597 [ 3 ] {186fe9ed-b879-46bc-98ce-28b13a869813} <Debug> oximeter.measurements_string (5b511f0f-826f-4d50-902e-8b0315ccdd81): Loading data parts | ||
| 436 | 2024.08.02 04:44:52.460764 [ 3 ] {186fe9ed-b879-46bc-98ce-28b13a869813} <Debug> oximeter.measurements_string (5b511f0f-826f-4d50-902e-8b0315ccdd81): There are no data parts | ||
| 437 | 2024.08.02 04:44:52.461915 [ 3 ] {186fe9ed-b879-46bc-98ce-28b13a869813} <Debug> DynamicQueryHandler: Done processing query | ||
| 438 | 2024.08.02 04:44:52.461942 [ 3 ] {} <Debug> HTTP-Session: 3f767044-b0ee-4b30-a5eb-60d372c45888 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 439 | 2024.08.02 04:44:52.462077 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 440 | 2024.08.02 04:44:52.462131 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 441 | 2024.08.02 04:44:52.462150 [ 3 ] {} <Debug> HTTP-Session: 7a78e949-bc05-4389-8a8f-8390b52edb9e Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 442 | 2024.08.02 04:44:52.462172 [ 3 ] {} <Debug> HTTP-Session: 7a78e949-bc05-4389-8a8f-8390b52edb9e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 443 | 2024.08.02 04:44:52.462191 [ 3 ] {} <Debug> HTTP-Session: 7a78e949-bc05-4389-8a8f-8390b52edb9e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 444 | 2024.08.02 04:44:52.462225 [ 3 ] {} <Trace> HTTP-Session: 7a78e949-bc05-4389-8a8f-8390b52edb9e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 445 | 2024.08.02 04:44:52.462402 [ 3 ] {0c2eaa3d-47b1-4ad6-a6c1-1e61c3977b3d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 446 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 447 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 448 | * a string isn't palatable for a few reasons. | ||
| 449 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 450 | * details. | ||
| 451 | */ | ||
| 452 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 453 | 2024.08.02 04:44:52.462457 [ 3 ] {0c2eaa3d-47b1-4ad6-a6c1-1e61c3977b3d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 454 | 2024.08.02 04:44:52.464910 [ 3 ] {0c2eaa3d-47b1-4ad6-a6c1-1e61c3977b3d} <Debug> oximeter.measurements_bytes (23542550-f067-42ea-b8af-0ea444f7bdd9): Loading data parts | ||
| 455 | 2024.08.02 04:44:52.465082 [ 3 ] {0c2eaa3d-47b1-4ad6-a6c1-1e61c3977b3d} <Debug> oximeter.measurements_bytes (23542550-f067-42ea-b8af-0ea444f7bdd9): There are no data parts | ||
| 456 | 2024.08.02 04:44:52.466457 [ 3 ] {0c2eaa3d-47b1-4ad6-a6c1-1e61c3977b3d} <Debug> DynamicQueryHandler: Done processing query | ||
| 457 | 2024.08.02 04:44:52.466489 [ 3 ] {} <Debug> HTTP-Session: 7a78e949-bc05-4389-8a8f-8390b52edb9e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 458 | 2024.08.02 04:44:52.466673 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 459 | 2024.08.02 04:44:52.466762 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 460 | 2024.08.02 04:44:52.466780 [ 3 ] {} <Debug> HTTP-Session: 13c5636d-c152-45bb-937c-2a209d8c219d Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 461 | 2024.08.02 04:44:52.466846 [ 3 ] {} <Debug> HTTP-Session: 13c5636d-c152-45bb-937c-2a209d8c219d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 462 | 2024.08.02 04:44:52.466897 [ 3 ] {} <Debug> HTTP-Session: 13c5636d-c152-45bb-937c-2a209d8c219d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 463 | 2024.08.02 04:44:52.466928 [ 3 ] {} <Trace> HTTP-Session: 13c5636d-c152-45bb-937c-2a209d8c219d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 464 | 2024.08.02 04:44:52.467183 [ 3 ] {13765136-769a-4104-a442-46ad859d194b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 465 | 2024.08.02 04:44:52.467269 [ 3 ] {13765136-769a-4104-a442-46ad859d194b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 466 | 2024.08.02 04:44:52.469120 [ 3 ] {13765136-769a-4104-a442-46ad859d194b} <Debug> oximeter.measurements_cumulativei64 (12b5b1dc-bc76-451e-acbf-3e77a69f4f50): Loading data parts | ||
| 467 | 2024.08.02 04:44:52.469315 [ 3 ] {13765136-769a-4104-a442-46ad859d194b} <Debug> oximeter.measurements_cumulativei64 (12b5b1dc-bc76-451e-acbf-3e77a69f4f50): There are no data parts | ||
| 468 | 2024.08.02 04:44:52.470651 [ 3 ] {13765136-769a-4104-a442-46ad859d194b} <Debug> DynamicQueryHandler: Done processing query | ||
| 469 | 2024.08.02 04:44:52.470715 [ 3 ] {} <Debug> HTTP-Session: 13c5636d-c152-45bb-937c-2a209d8c219d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 470 | 2024.08.02 04:44:52.470835 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 471 | 2024.08.02 04:44:52.470948 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 472 | 2024.08.02 04:44:52.470968 [ 3 ] {} <Debug> HTTP-Session: 785f5de9-8504-45c3-8a42-211ece086132 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 473 | 2024.08.02 04:44:52.471015 [ 3 ] {} <Debug> HTTP-Session: 785f5de9-8504-45c3-8a42-211ece086132 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 474 | 2024.08.02 04:44:52.471031 [ 3 ] {} <Debug> HTTP-Session: 785f5de9-8504-45c3-8a42-211ece086132 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 475 | 2024.08.02 04:44:52.471094 [ 3 ] {} <Trace> HTTP-Session: 785f5de9-8504-45c3-8a42-211ece086132 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 476 | 2024.08.02 04:44:52.471308 [ 3 ] {69f94115-75a7-4335-a21b-a1f516399ae5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 477 | 2024.08.02 04:44:52.471422 [ 3 ] {69f94115-75a7-4335-a21b-a1f516399ae5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 478 | 2024.08.02 04:44:52.473215 [ 3 ] {69f94115-75a7-4335-a21b-a1f516399ae5} <Debug> oximeter.measurements_cumulativeu64 (b5f02e86-2ba5-45f8-a488-29a30602a42b): Loading data parts | ||
| 479 | 2024.08.02 04:44:52.473412 [ 3 ] {69f94115-75a7-4335-a21b-a1f516399ae5} <Debug> oximeter.measurements_cumulativeu64 (b5f02e86-2ba5-45f8-a488-29a30602a42b): There are no data parts | ||
| 480 | 2024.08.02 04:44:52.474823 [ 3 ] {69f94115-75a7-4335-a21b-a1f516399ae5} <Debug> DynamicQueryHandler: Done processing query | ||
| 481 | 2024.08.02 04:44:52.474849 [ 3 ] {} <Debug> HTTP-Session: 785f5de9-8504-45c3-8a42-211ece086132 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 482 | 2024.08.02 04:44:52.475014 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 483 | 2024.08.02 04:44:52.475176 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 484 | 2024.08.02 04:44:52.475202 [ 3 ] {} <Debug> HTTP-Session: 108b60be-bb1a-4234-9a27-a3a94c42f994 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 485 | 2024.08.02 04:44:52.475253 [ 3 ] {} <Debug> HTTP-Session: 108b60be-bb1a-4234-9a27-a3a94c42f994 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 486 | 2024.08.02 04:44:52.475298 [ 3 ] {} <Debug> HTTP-Session: 108b60be-bb1a-4234-9a27-a3a94c42f994 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 487 | 2024.08.02 04:44:52.475331 [ 3 ] {} <Trace> HTTP-Session: 108b60be-bb1a-4234-9a27-a3a94c42f994 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 488 | 2024.08.02 04:44:52.475554 [ 3 ] {67949ce4-5a0d-4b91-a6e9-929256d0a411} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 489 | 2024.08.02 04:44:52.475687 [ 3 ] {67949ce4-5a0d-4b91-a6e9-929256d0a411} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 490 | 2024.08.02 04:44:52.477563 [ 3 ] {67949ce4-5a0d-4b91-a6e9-929256d0a411} <Debug> oximeter.measurements_cumulativef32 (c3085089-2a82-40a2-a1ee-a0f9e4b52b1f): Loading data parts | ||
| 491 | 2024.08.02 04:44:52.477769 [ 3 ] {67949ce4-5a0d-4b91-a6e9-929256d0a411} <Debug> oximeter.measurements_cumulativef32 (c3085089-2a82-40a2-a1ee-a0f9e4b52b1f): There are no data parts | ||
| 492 | 2024.08.02 04:44:52.479236 [ 3 ] {67949ce4-5a0d-4b91-a6e9-929256d0a411} <Debug> DynamicQueryHandler: Done processing query | ||
| 493 | 2024.08.02 04:44:52.479299 [ 3 ] {} <Debug> HTTP-Session: 108b60be-bb1a-4234-9a27-a3a94c42f994 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 494 | 2024.08.02 04:44:52.479428 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 495 | 2024.08.02 04:44:52.479509 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 496 | 2024.08.02 04:44:52.479563 [ 3 ] {} <Debug> HTTP-Session: efd9572a-da5d-4a4f-a145-2e52e6c3a3b8 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 497 | 2024.08.02 04:44:52.479612 [ 3 ] {} <Debug> HTTP-Session: efd9572a-da5d-4a4f-a145-2e52e6c3a3b8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 498 | 2024.08.02 04:44:52.479626 [ 3 ] {} <Debug> HTTP-Session: efd9572a-da5d-4a4f-a145-2e52e6c3a3b8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 499 | 2024.08.02 04:44:52.479685 [ 3 ] {} <Trace> HTTP-Session: efd9572a-da5d-4a4f-a145-2e52e6c3a3b8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 500 | 2024.08.02 04:44:52.479912 [ 3 ] {a0e75d83-e19f-4f49-afbd-268f370dd809} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 501 | 2024.08.02 04:44:52.480041 [ 3 ] {a0e75d83-e19f-4f49-afbd-268f370dd809} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 502 | 2024.08.02 04:44:52.481767 [ 3 ] {a0e75d83-e19f-4f49-afbd-268f370dd809} <Debug> oximeter.measurements_cumulativef64 (578f39e8-3b78-4034-9f4c-5ec2725550a7): Loading data parts | ||
| 503 | 2024.08.02 04:44:52.481976 [ 3 ] {a0e75d83-e19f-4f49-afbd-268f370dd809} <Debug> oximeter.measurements_cumulativef64 (578f39e8-3b78-4034-9f4c-5ec2725550a7): There are no data parts | ||
| 504 | 2024.08.02 04:44:52.484790 [ 3 ] {a0e75d83-e19f-4f49-afbd-268f370dd809} <Debug> DynamicQueryHandler: Done processing query | ||
| 505 | 2024.08.02 04:44:52.484816 [ 3 ] {} <Debug> HTTP-Session: efd9572a-da5d-4a4f-a145-2e52e6c3a3b8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 506 | 2024.08.02 04:44:52.484986 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 507 | 2024.08.02 04:44:52.485065 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 508 | 2024.08.02 04:44:52.485084 [ 3 ] {} <Debug> HTTP-Session: ff862a50-4b8c-46ee-ad84-76194837ac54 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 509 | 2024.08.02 04:44:52.485132 [ 3 ] {} <Debug> HTTP-Session: ff862a50-4b8c-46ee-ad84-76194837ac54 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 510 | 2024.08.02 04:44:52.485178 [ 3 ] {} <Debug> HTTP-Session: ff862a50-4b8c-46ee-ad84-76194837ac54 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 511 | 2024.08.02 04:44:52.485207 [ 3 ] {} <Trace> HTTP-Session: ff862a50-4b8c-46ee-ad84-76194837ac54 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 512 | 2024.08.02 04:44:52.485486 [ 3 ] {77043362-119b-4567-ab52-69b73388b3de} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 513 | * NOTE: Array types cannot be Nullable, see | ||
| 514 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 515 | * for more details. | ||
| 516 | * | ||
| 517 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 518 | * is unfortunate, and at this point relies on the fact that an | ||
| 519 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 520 | * to figure out another way to represent missing samples here. | ||
| 521 | */ | ||
| 522 | 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) | ||
| 523 | 2024.08.02 04:44:52.485607 [ 3 ] {77043362-119b-4567-ab52-69b73388b3de} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 524 | 2024.08.02 04:44:52.488363 [ 3 ] {77043362-119b-4567-ab52-69b73388b3de} <Debug> oximeter.measurements_histogrami8 (b829c266-65c1-4ede-9eaa-1dd6836aa7ac): Loading data parts | ||
| 525 | 2024.08.02 04:44:52.488564 [ 3 ] {77043362-119b-4567-ab52-69b73388b3de} <Debug> oximeter.measurements_histogrami8 (b829c266-65c1-4ede-9eaa-1dd6836aa7ac): There are no data parts | ||
| 526 | 2024.08.02 04:44:52.490100 [ 3 ] {77043362-119b-4567-ab52-69b73388b3de} <Debug> DynamicQueryHandler: Done processing query | ||
| 527 | 2024.08.02 04:44:52.490161 [ 3 ] {} <Debug> HTTP-Session: ff862a50-4b8c-46ee-ad84-76194837ac54 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 528 | 2024.08.02 04:44:52.490319 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 529 | 2024.08.02 04:44:52.490367 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 530 | 2024.08.02 04:44:52.490417 [ 3 ] {} <Debug> HTTP-Session: c2f46812-6923-4ff1-960a-1af263b1f23f Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 531 | 2024.08.02 04:44:52.490465 [ 3 ] {} <Debug> HTTP-Session: c2f46812-6923-4ff1-960a-1af263b1f23f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 532 | 2024.08.02 04:44:52.490479 [ 3 ] {} <Debug> HTTP-Session: c2f46812-6923-4ff1-960a-1af263b1f23f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 533 | 2024.08.02 04:44:52.490538 [ 3 ] {} <Trace> HTTP-Session: c2f46812-6923-4ff1-960a-1af263b1f23f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 534 | 2024.08.02 04:44:52.490819 [ 3 ] {c1c4511c-5cbf-4160-ab2f-bfd5c311e9e0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 535 | 2024.08.02 04:44:52.490937 [ 3 ] {c1c4511c-5cbf-4160-ab2f-bfd5c311e9e0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 536 | 2024.08.02 04:44:52.493419 [ 3 ] {c1c4511c-5cbf-4160-ab2f-bfd5c311e9e0} <Debug> oximeter.measurements_histogramu8 (055ff03c-c937-4904-ad8e-f1334dbabeb1): Loading data parts | ||
| 537 | 2024.08.02 04:44:52.493619 [ 3 ] {c1c4511c-5cbf-4160-ab2f-bfd5c311e9e0} <Debug> oximeter.measurements_histogramu8 (055ff03c-c937-4904-ad8e-f1334dbabeb1): There are no data parts | ||
| 538 | 2024.08.02 04:44:52.495185 [ 3 ] {c1c4511c-5cbf-4160-ab2f-bfd5c311e9e0} <Debug> DynamicQueryHandler: Done processing query | ||
| 539 | 2024.08.02 04:44:52.495213 [ 3 ] {} <Debug> HTTP-Session: c2f46812-6923-4ff1-960a-1af263b1f23f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 540 | 2024.08.02 04:44:52.495338 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 541 | 2024.08.02 04:44:52.495459 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 542 | 2024.08.02 04:44:52.495479 [ 3 ] {} <Debug> HTTP-Session: 89e46952-3842-4a79-bca3-465dfb43be7a Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 543 | 2024.08.02 04:44:52.495531 [ 3 ] {} <Debug> HTTP-Session: 89e46952-3842-4a79-bca3-465dfb43be7a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 544 | 2024.08.02 04:44:52.495547 [ 3 ] {} <Debug> HTTP-Session: 89e46952-3842-4a79-bca3-465dfb43be7a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 545 | 2024.08.02 04:44:52.495611 [ 3 ] {} <Trace> HTTP-Session: 89e46952-3842-4a79-bca3-465dfb43be7a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 546 | 2024.08.02 04:44:52.495887 [ 3 ] {5ac50d4d-780d-4280-b965-a8bbe3c74341} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 547 | 2024.08.02 04:44:52.496019 [ 3 ] {5ac50d4d-780d-4280-b965-a8bbe3c74341} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 548 | 2024.08.02 04:44:52.498415 [ 3 ] {5ac50d4d-780d-4280-b965-a8bbe3c74341} <Debug> oximeter.measurements_histogrami16 (af6ec19e-f6a7-46ed-89b3-1c8df90763e4): Loading data parts | ||
| 549 | 2024.08.02 04:44:52.498614 [ 3 ] {5ac50d4d-780d-4280-b965-a8bbe3c74341} <Debug> oximeter.measurements_histogrami16 (af6ec19e-f6a7-46ed-89b3-1c8df90763e4): There are no data parts | ||
| 550 | 2024.08.02 04:44:52.499946 [ 3 ] {5ac50d4d-780d-4280-b965-a8bbe3c74341} <Debug> DynamicQueryHandler: Done processing query | ||
| 551 | 2024.08.02 04:44:52.500012 [ 3 ] {} <Debug> HTTP-Session: 89e46952-3842-4a79-bca3-465dfb43be7a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 552 | 2024.08.02 04:44:52.500180 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 553 | 2024.08.02 04:44:52.500227 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 554 | 2024.08.02 04:44:52.500283 [ 3 ] {} <Debug> HTTP-Session: 5ec91d8f-32f9-4f45-800f-01cf31c26f7e Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 555 | 2024.08.02 04:44:52.500335 [ 3 ] {} <Debug> HTTP-Session: 5ec91d8f-32f9-4f45-800f-01cf31c26f7e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 556 | 2024.08.02 04:44:52.500349 [ 3 ] {} <Debug> HTTP-Session: 5ec91d8f-32f9-4f45-800f-01cf31c26f7e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 557 | 2024.08.02 04:44:52.500413 [ 3 ] {} <Trace> HTTP-Session: 5ec91d8f-32f9-4f45-800f-01cf31c26f7e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 558 | 2024.08.02 04:44:52.500695 [ 3 ] {f5897ad6-71b3-44b6-b3c6-7f775a387dfe} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 559 | 2024.08.02 04:44:52.500820 [ 3 ] {f5897ad6-71b3-44b6-b3c6-7f775a387dfe} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 560 | 2024.08.02 04:44:52.503585 [ 3 ] {f5897ad6-71b3-44b6-b3c6-7f775a387dfe} <Debug> oximeter.measurements_histogramu16 (02b4dd53-898b-433b-9ed2-c63fb16fee47): Loading data parts | ||
| 561 | 2024.08.02 04:44:52.503795 [ 3 ] {f5897ad6-71b3-44b6-b3c6-7f775a387dfe} <Debug> oximeter.measurements_histogramu16 (02b4dd53-898b-433b-9ed2-c63fb16fee47): There are no data parts | ||
| 562 | 2024.08.02 04:44:52.505306 [ 3 ] {f5897ad6-71b3-44b6-b3c6-7f775a387dfe} <Debug> DynamicQueryHandler: Done processing query | ||
| 563 | 2024.08.02 04:44:52.505335 [ 3 ] {} <Debug> HTTP-Session: 5ec91d8f-32f9-4f45-800f-01cf31c26f7e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 564 | 2024.08.02 04:44:52.505499 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 565 | 2024.08.02 04:44:52.505583 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 566 | 2024.08.02 04:44:52.505608 [ 3 ] {} <Debug> HTTP-Session: 6e92fb75-bd67-4d62-9686-1cf1ca2ef902 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 567 | 2024.08.02 04:44:52.505671 [ 3 ] {} <Debug> HTTP-Session: 6e92fb75-bd67-4d62-9686-1cf1ca2ef902 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 568 | 2024.08.02 04:44:52.505722 [ 3 ] {} <Debug> HTTP-Session: 6e92fb75-bd67-4d62-9686-1cf1ca2ef902 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 569 | 2024.08.02 04:44:52.505754 [ 3 ] {} <Trace> HTTP-Session: 6e92fb75-bd67-4d62-9686-1cf1ca2ef902 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 570 | 2024.08.02 04:44:52.506079 [ 3 ] {f92a0de0-5cef-48e1-a3de-ec23dacc1a69} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 571 | 2024.08.02 04:44:52.506208 [ 3 ] {f92a0de0-5cef-48e1-a3de-ec23dacc1a69} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 572 | 2024.08.02 04:44:52.508127 [ 3 ] {f92a0de0-5cef-48e1-a3de-ec23dacc1a69} <Debug> oximeter.measurements_histogrami32 (9a66a0e2-ed2b-45d3-a68f-d5081a66e210): Loading data parts | ||
| 573 | 2024.08.02 04:44:52.508324 [ 3 ] {f92a0de0-5cef-48e1-a3de-ec23dacc1a69} <Debug> oximeter.measurements_histogrami32 (9a66a0e2-ed2b-45d3-a68f-d5081a66e210): There are no data parts | ||
| 574 | 2024.08.02 04:44:52.509733 [ 3 ] {f92a0de0-5cef-48e1-a3de-ec23dacc1a69} <Debug> DynamicQueryHandler: Done processing query | ||
| 575 | 2024.08.02 04:44:52.509760 [ 3 ] {} <Debug> HTTP-Session: 6e92fb75-bd67-4d62-9686-1cf1ca2ef902 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 576 | 2024.08.02 04:44:52.509917 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 577 | 2024.08.02 04:44:52.510002 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 578 | 2024.08.02 04:44:52.510022 [ 3 ] {} <Debug> HTTP-Session: 224d004e-8438-486a-aafb-e6e67827d0e1 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 579 | 2024.08.02 04:44:52.510076 [ 3 ] {} <Debug> HTTP-Session: 224d004e-8438-486a-aafb-e6e67827d0e1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 580 | 2024.08.02 04:44:52.510090 [ 3 ] {} <Debug> HTTP-Session: 224d004e-8438-486a-aafb-e6e67827d0e1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 581 | 2024.08.02 04:44:52.510156 [ 3 ] {} <Trace> HTTP-Session: 224d004e-8438-486a-aafb-e6e67827d0e1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 582 | 2024.08.02 04:44:52.510439 [ 3 ] {ce7e1029-f870-494c-8893-84eb2dd45623} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 583 | 2024.08.02 04:44:52.510563 [ 3 ] {ce7e1029-f870-494c-8893-84eb2dd45623} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 584 | 2024.08.02 04:44:52.512841 [ 3 ] {ce7e1029-f870-494c-8893-84eb2dd45623} <Debug> oximeter.measurements_histogramu32 (2d564e2f-883d-432b-8770-a5c3d15e2168): Loading data parts | ||
| 585 | 2024.08.02 04:44:52.513033 [ 3 ] {ce7e1029-f870-494c-8893-84eb2dd45623} <Debug> oximeter.measurements_histogramu32 (2d564e2f-883d-432b-8770-a5c3d15e2168): There are no data parts | ||
| 586 | 2024.08.02 04:44:52.514622 [ 3 ] {ce7e1029-f870-494c-8893-84eb2dd45623} <Debug> DynamicQueryHandler: Done processing query | ||
| 587 | 2024.08.02 04:44:52.514648 [ 3 ] {} <Debug> HTTP-Session: 224d004e-8438-486a-aafb-e6e67827d0e1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 588 | 2024.08.02 04:44:52.514809 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 589 | 2024.08.02 04:44:52.514890 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 590 | 2024.08.02 04:44:52.514908 [ 3 ] {} <Debug> HTTP-Session: cf40fbde-3bf5-4814-a1c1-04215a7cadf1 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 591 | 2024.08.02 04:44:52.514955 [ 3 ] {} <Debug> HTTP-Session: cf40fbde-3bf5-4814-a1c1-04215a7cadf1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 592 | 2024.08.02 04:44:52.515002 [ 3 ] {} <Debug> HTTP-Session: cf40fbde-3bf5-4814-a1c1-04215a7cadf1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 593 | 2024.08.02 04:44:52.515033 [ 3 ] {} <Trace> HTTP-Session: cf40fbde-3bf5-4814-a1c1-04215a7cadf1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 594 | 2024.08.02 04:44:52.515306 [ 3 ] {45a81157-fd6f-4f58-9b9d-fc23405c2761} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 595 | 2024.08.02 04:44:52.515430 [ 3 ] {45a81157-fd6f-4f58-9b9d-fc23405c2761} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 596 | 2024.08.02 04:44:52.517629 [ 3 ] {45a81157-fd6f-4f58-9b9d-fc23405c2761} <Debug> oximeter.measurements_histogrami64 (3b99d34b-5a1f-4478-a45c-ff7fe600f2a2): Loading data parts | ||
| 597 | 2024.08.02 04:44:52.517797 [ 3 ] {45a81157-fd6f-4f58-9b9d-fc23405c2761} <Debug> oximeter.measurements_histogrami64 (3b99d34b-5a1f-4478-a45c-ff7fe600f2a2): There are no data parts | ||
| 598 | 2024.08.02 04:44:52.519441 [ 3 ] {45a81157-fd6f-4f58-9b9d-fc23405c2761} <Debug> DynamicQueryHandler: Done processing query | ||
| 599 | 2024.08.02 04:44:52.519468 [ 3 ] {} <Debug> HTTP-Session: cf40fbde-3bf5-4814-a1c1-04215a7cadf1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 600 | 2024.08.02 04:44:52.519627 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 601 | 2024.08.02 04:44:52.519709 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 602 | 2024.08.02 04:44:52.519762 [ 3 ] {} <Debug> HTTP-Session: 20776d9a-8e1b-4a2b-8f94-78a887ed0cf9 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 603 | 2024.08.02 04:44:52.519778 [ 3 ] {} <Debug> HTTP-Session: 20776d9a-8e1b-4a2b-8f94-78a887ed0cf9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 604 | 2024.08.02 04:44:52.519821 [ 3 ] {} <Debug> HTTP-Session: 20776d9a-8e1b-4a2b-8f94-78a887ed0cf9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 605 | 2024.08.02 04:44:52.519854 [ 3 ] {} <Trace> HTTP-Session: 20776d9a-8e1b-4a2b-8f94-78a887ed0cf9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 606 | 2024.08.02 04:44:52.520134 [ 3 ] {a5a958ae-4e76-41e9-a765-20f057983773} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 607 | 2024.08.02 04:44:52.520266 [ 3 ] {a5a958ae-4e76-41e9-a765-20f057983773} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 608 | 2024.08.02 04:44:52.522214 [ 3 ] {a5a958ae-4e76-41e9-a765-20f057983773} <Debug> oximeter.measurements_histogramu64 (c3b08c74-9636-4703-81c2-00032d8808d5): Loading data parts | ||
| 609 | 2024.08.02 04:44:52.522410 [ 3 ] {a5a958ae-4e76-41e9-a765-20f057983773} <Debug> oximeter.measurements_histogramu64 (c3b08c74-9636-4703-81c2-00032d8808d5): There are no data parts | ||
| 610 | 2024.08.02 04:44:52.524001 [ 3 ] {a5a958ae-4e76-41e9-a765-20f057983773} <Debug> DynamicQueryHandler: Done processing query | ||
| 611 | 2024.08.02 04:44:52.524029 [ 3 ] {} <Debug> HTTP-Session: 20776d9a-8e1b-4a2b-8f94-78a887ed0cf9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 612 | 2024.08.02 04:44:52.524198 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 613 | 2024.08.02 04:44:52.524278 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 614 | 2024.08.02 04:44:52.524296 [ 3 ] {} <Debug> HTTP-Session: 99c9f20e-b50c-4501-ae05-10ea013dc485 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 615 | 2024.08.02 04:44:52.524344 [ 3 ] {} <Debug> HTTP-Session: 99c9f20e-b50c-4501-ae05-10ea013dc485 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 616 | 2024.08.02 04:44:52.524391 [ 3 ] {} <Debug> HTTP-Session: 99c9f20e-b50c-4501-ae05-10ea013dc485 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 617 | 2024.08.02 04:44:52.524421 [ 3 ] {} <Trace> HTTP-Session: 99c9f20e-b50c-4501-ae05-10ea013dc485 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 618 | 2024.08.02 04:44:52.524692 [ 3 ] {e32824c1-05d9-4d17-a3f7-ed052703d199} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 619 | 2024.08.02 04:44:52.524812 [ 3 ] {e32824c1-05d9-4d17-a3f7-ed052703d199} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 620 | 2024.08.02 04:44:52.526917 [ 3 ] {e32824c1-05d9-4d17-a3f7-ed052703d199} <Debug> oximeter.measurements_histogramf32 (a95d2ab6-4502-4503-858a-3e3588efed0e): Loading data parts | ||
| 621 | 2024.08.02 04:44:52.527072 [ 3 ] {e32824c1-05d9-4d17-a3f7-ed052703d199} <Debug> oximeter.measurements_histogramf32 (a95d2ab6-4502-4503-858a-3e3588efed0e): There are no data parts | ||
| 622 | 2024.08.02 04:44:52.528381 [ 3 ] {e32824c1-05d9-4d17-a3f7-ed052703d199} <Debug> DynamicQueryHandler: Done processing query | ||
| 623 | 2024.08.02 04:44:52.528446 [ 3 ] {} <Debug> HTTP-Session: 99c9f20e-b50c-4501-ae05-10ea013dc485 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 624 | 2024.08.02 04:44:52.528573 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 625 | 2024.08.02 04:44:52.528672 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 626 | 2024.08.02 04:44:52.528734 [ 3 ] {} <Debug> HTTP-Session: f9b4a7e8-973c-43d2-a9e2-e6e1e098d74e Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 627 | 2024.08.02 04:44:52.528751 [ 3 ] {} <Debug> HTTP-Session: f9b4a7e8-973c-43d2-a9e2-e6e1e098d74e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 628 | 2024.08.02 04:44:52.528800 [ 3 ] {} <Debug> HTTP-Session: f9b4a7e8-973c-43d2-a9e2-e6e1e098d74e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 629 | 2024.08.02 04:44:52.528874 [ 3 ] {} <Trace> HTTP-Session: f9b4a7e8-973c-43d2-a9e2-e6e1e098d74e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 630 | 2024.08.02 04:44:52.529117 [ 3 ] {853bc062-1b8b-43ee-a415-4c1dcdc72591} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) 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) | ||
| 631 | 2024.08.02 04:44:52.529245 [ 3 ] {853bc062-1b8b-43ee-a415-4c1dcdc72591} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 632 | 2024.08.02 04:44:52.531197 [ 3 ] {853bc062-1b8b-43ee-a415-4c1dcdc72591} <Debug> oximeter.measurements_histogramf64 (191437a2-d3de-42dc-839b-adf3a7288ea8): Loading data parts | ||
| 633 | 2024.08.02 04:44:52.531366 [ 3 ] {853bc062-1b8b-43ee-a415-4c1dcdc72591} <Debug> oximeter.measurements_histogramf64 (191437a2-d3de-42dc-839b-adf3a7288ea8): There are no data parts | ||
| 634 | 2024.08.02 04:44:52.532749 [ 3 ] {853bc062-1b8b-43ee-a415-4c1dcdc72591} <Debug> DynamicQueryHandler: Done processing query | ||
| 635 | 2024.08.02 04:44:52.532776 [ 3 ] {} <Debug> HTTP-Session: f9b4a7e8-973c-43d2-a9e2-e6e1e098d74e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 636 | 2024.08.02 04:44:52.532941 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 1196, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 637 | 2024.08.02 04:44:52.533026 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 638 | 2024.08.02 04:44:52.533078 [ 3 ] {} <Debug> HTTP-Session: 4019b68d-b260-411f-9f8f-7ca5267891d4 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 639 | 2024.08.02 04:44:52.533095 [ 3 ] {} <Debug> HTTP-Session: 4019b68d-b260-411f-9f8f-7ca5267891d4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 640 | 2024.08.02 04:44:52.533176 [ 3 ] {} <Debug> HTTP-Session: 4019b68d-b260-411f-9f8f-7ca5267891d4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 641 | 2024.08.02 04:44:52.533255 [ 3 ] {} <Trace> HTTP-Session: 4019b68d-b260-411f-9f8f-7ca5267891d4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 642 | 2024.08.02 04:44:52.533445 [ 3 ] {77428ba4-80c9-40ba-ae5c-5b4111ffeaed} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) /* The field tables store named dimensions of each timeseries. | ||
| 643 | * | ||
| 644 | * As with the measurement tables, there is one field table for each field data | ||
| 645 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 646 | * this behavior **must not** be relied upon for query correctness. | ||
| 647 | * | ||
| 648 | * The index for the fields differs from the measurements, however. Rows are | ||
| 649 | * sorted by timeseries name, then field name, field value, and finally | ||
| 650 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 651 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 652 | * usually then used to look up measurements. | ||
| 653 | * | ||
| 654 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 655 | * timeseries name and then key, since it would improve lookups where one | ||
| 656 | * already has the key. Realistically though, these tables are quite small and | ||
| 657 | * so performance benefits will be low in absolute terms. | ||
| 658 | */ | ||
| 659 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 660 | 2024.08.02 04:44:52.533556 [ 3 ] {77428ba4-80c9-40ba-ae5c-5b4111ffeaed} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 661 | 2024.08.02 04:44:52.535489 [ 3 ] {77428ba4-80c9-40ba-ae5c-5b4111ffeaed} <Debug> oximeter.fields_bool (68da3430-0eb7-490f-82c6-c6cd6bc4a944): Loading data parts | ||
| 662 | 2024.08.02 04:44:52.535717 [ 3 ] {77428ba4-80c9-40ba-ae5c-5b4111ffeaed} <Debug> oximeter.fields_bool (68da3430-0eb7-490f-82c6-c6cd6bc4a944): There are no data parts | ||
| 663 | 2024.08.02 04:44:52.537123 [ 3 ] {77428ba4-80c9-40ba-ae5c-5b4111ffeaed} <Debug> DynamicQueryHandler: Done processing query | ||
| 664 | 2024.08.02 04:44:52.537187 [ 3 ] {} <Debug> HTTP-Session: 4019b68d-b260-411f-9f8f-7ca5267891d4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 665 | 2024.08.02 04:44:52.537362 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 248, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 666 | 2024.08.02 04:44:52.537445 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 667 | 2024.08.02 04:44:52.537466 [ 3 ] {} <Debug> HTTP-Session: 51f19a9a-11ba-4afb-9d10-85c9920dacd6 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 668 | 2024.08.02 04:44:52.537518 [ 3 ] {} <Debug> HTTP-Session: 51f19a9a-11ba-4afb-9d10-85c9920dacd6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 669 | 2024.08.02 04:44:52.537532 [ 3 ] {} <Debug> HTTP-Session: 51f19a9a-11ba-4afb-9d10-85c9920dacd6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 670 | 2024.08.02 04:44:52.537597 [ 3 ] {} <Trace> HTTP-Session: 51f19a9a-11ba-4afb-9d10-85c9920dacd6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 671 | 2024.08.02 04:44:52.537774 [ 3 ] {8ae48c99-d4ae-4b7d-b091-243e29ab8b8f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 672 | 2024.08.02 04:44:52.537887 [ 3 ] {8ae48c99-d4ae-4b7d-b091-243e29ab8b8f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 673 | 2024.08.02 04:44:52.539523 [ 3 ] {8ae48c99-d4ae-4b7d-b091-243e29ab8b8f} <Debug> oximeter.fields_i8 (2cb45e51-4e95-4fbc-9482-a6e29598fcdc): Loading data parts | ||
| 674 | 2024.08.02 04:44:52.539749 [ 3 ] {8ae48c99-d4ae-4b7d-b091-243e29ab8b8f} <Debug> oximeter.fields_i8 (2cb45e51-4e95-4fbc-9482-a6e29598fcdc): There are no data parts | ||
| 675 | 2024.08.02 04:44:52.541150 [ 3 ] {8ae48c99-d4ae-4b7d-b091-243e29ab8b8f} <Debug> DynamicQueryHandler: Done processing query | ||
| 676 | 2024.08.02 04:44:52.541211 [ 3 ] {} <Debug> HTTP-Session: 51f19a9a-11ba-4afb-9d10-85c9920dacd6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 677 | 2024.08.02 04:44:52.541329 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 249, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 678 | 2024.08.02 04:44:52.541439 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 679 | 2024.08.02 04:44:52.541460 [ 3 ] {} <Debug> HTTP-Session: e727456a-44a9-4152-9f86-81086ab544d4 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 680 | 2024.08.02 04:44:52.541506 [ 3 ] {} <Debug> HTTP-Session: e727456a-44a9-4152-9f86-81086ab544d4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 681 | 2024.08.02 04:44:52.541522 [ 3 ] {} <Debug> HTTP-Session: e727456a-44a9-4152-9f86-81086ab544d4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 682 | 2024.08.02 04:44:52.541584 [ 3 ] {} <Trace> HTTP-Session: e727456a-44a9-4152-9f86-81086ab544d4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 683 | 2024.08.02 04:44:52.541756 [ 3 ] {ec70eb1b-3258-4db2-95db-e71f12446777} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 684 | 2024.08.02 04:44:52.541832 [ 3 ] {ec70eb1b-3258-4db2-95db-e71f12446777} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 685 | 2024.08.02 04:44:52.543481 [ 3 ] {ec70eb1b-3258-4db2-95db-e71f12446777} <Debug> oximeter.fields_u8 (f60ad5af-31a8-4cc3-aa14-17881dd9ca83): Loading data parts | ||
| 686 | 2024.08.02 04:44:52.543700 [ 3 ] {ec70eb1b-3258-4db2-95db-e71f12446777} <Debug> oximeter.fields_u8 (f60ad5af-31a8-4cc3-aa14-17881dd9ca83): There are no data parts | ||
| 687 | 2024.08.02 04:44:52.545011 [ 3 ] {ec70eb1b-3258-4db2-95db-e71f12446777} <Debug> DynamicQueryHandler: Done processing query | ||
| 688 | 2024.08.02 04:44:52.545071 [ 3 ] {} <Debug> HTTP-Session: e727456a-44a9-4152-9f86-81086ab544d4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 689 | 2024.08.02 04:44:52.545200 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 690 | 2024.08.02 04:44:52.545281 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 691 | 2024.08.02 04:44:52.545335 [ 3 ] {} <Debug> HTTP-Session: 46980d47-fd79-4055-9e88-dc3d26acc112 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 692 | 2024.08.02 04:44:52.545387 [ 3 ] {} <Debug> HTTP-Session: 46980d47-fd79-4055-9e88-dc3d26acc112 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 693 | 2024.08.02 04:44:52.545402 [ 3 ] {} <Debug> HTTP-Session: 46980d47-fd79-4055-9e88-dc3d26acc112 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 694 | 2024.08.02 04:44:52.545464 [ 3 ] {} <Trace> HTTP-Session: 46980d47-fd79-4055-9e88-dc3d26acc112 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 695 | 2024.08.02 04:44:52.545682 [ 3 ] {f9ebd0c5-c36c-4bc6-b183-4cd153d53c3f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 696 | 2024.08.02 04:44:52.545759 [ 3 ] {f9ebd0c5-c36c-4bc6-b183-4cd153d53c3f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 697 | 2024.08.02 04:44:52.547444 [ 3 ] {f9ebd0c5-c36c-4bc6-b183-4cd153d53c3f} <Debug> oximeter.fields_i16 (a54cd6cc-f17d-4170-9910-783452b590a6): Loading data parts | ||
| 698 | 2024.08.02 04:44:52.547630 [ 3 ] {f9ebd0c5-c36c-4bc6-b183-4cd153d53c3f} <Debug> oximeter.fields_i16 (a54cd6cc-f17d-4170-9910-783452b590a6): There are no data parts | ||
| 699 | 2024.08.02 04:44:52.548880 [ 3 ] {f9ebd0c5-c36c-4bc6-b183-4cd153d53c3f} <Debug> DynamicQueryHandler: Done processing query | ||
| 700 | 2024.08.02 04:44:52.548948 [ 3 ] {} <Debug> HTTP-Session: 46980d47-fd79-4055-9e88-dc3d26acc112 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 701 | 2024.08.02 04:44:52.549068 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 702 | 2024.08.02 04:44:52.549150 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 703 | 2024.08.02 04:44:52.549204 [ 3 ] {} <Debug> HTTP-Session: 802b6775-caf6-4db5-8f08-bda268ea54eb Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 704 | 2024.08.02 04:44:52.549221 [ 3 ] {} <Debug> HTTP-Session: 802b6775-caf6-4db5-8f08-bda268ea54eb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 705 | 2024.08.02 04:44:52.549267 [ 3 ] {} <Debug> HTTP-Session: 802b6775-caf6-4db5-8f08-bda268ea54eb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 706 | 2024.08.02 04:44:52.549330 [ 3 ] {} <Trace> HTTP-Session: 802b6775-caf6-4db5-8f08-bda268ea54eb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 707 | 2024.08.02 04:44:52.549475 [ 3 ] {45a821da-0268-4594-973b-3e663f5e28a4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 708 | 2024.08.02 04:44:52.549580 [ 3 ] {45a821da-0268-4594-973b-3e663f5e28a4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 709 | 2024.08.02 04:44:52.551303 [ 3 ] {45a821da-0268-4594-973b-3e663f5e28a4} <Debug> oximeter.fields_u16 (e4860bcb-d72b-4d7b-9640-6d2b59a96c88): Loading data parts | ||
| 710 | 2024.08.02 04:44:52.551502 [ 3 ] {45a821da-0268-4594-973b-3e663f5e28a4} <Debug> oximeter.fields_u16 (e4860bcb-d72b-4d7b-9640-6d2b59a96c88): There are no data parts | ||
| 711 | 2024.08.02 04:44:52.552827 [ 3 ] {45a821da-0268-4594-973b-3e663f5e28a4} <Debug> DynamicQueryHandler: Done processing query | ||
| 712 | 2024.08.02 04:44:52.552851 [ 3 ] {} <Debug> HTTP-Session: 802b6775-caf6-4db5-8f08-bda268ea54eb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 713 | 2024.08.02 04:44:52.553008 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 714 | 2024.08.02 04:44:52.553089 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 715 | 2024.08.02 04:44:52.553107 [ 3 ] {} <Debug> HTTP-Session: 413884ae-61d2-41c3-80e9-16b3143b0ee7 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 716 | 2024.08.02 04:44:52.553172 [ 3 ] {} <Debug> HTTP-Session: 413884ae-61d2-41c3-80e9-16b3143b0ee7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 717 | 2024.08.02 04:44:52.553229 [ 3 ] {} <Debug> HTTP-Session: 413884ae-61d2-41c3-80e9-16b3143b0ee7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 718 | 2024.08.02 04:44:52.553263 [ 3 ] {} <Trace> HTTP-Session: 413884ae-61d2-41c3-80e9-16b3143b0ee7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 719 | 2024.08.02 04:44:52.553444 [ 3 ] {5062144b-1a75-408f-91b9-01985c26f629} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 720 | 2024.08.02 04:44:52.553556 [ 3 ] {5062144b-1a75-408f-91b9-01985c26f629} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 721 | 2024.08.02 04:44:52.555076 [ 3 ] {5062144b-1a75-408f-91b9-01985c26f629} <Debug> oximeter.fields_i32 (32dde22b-5cd3-43bf-ba3c-4c192d2e6b40): Loading data parts | ||
| 722 | 2024.08.02 04:44:52.555287 [ 3 ] {5062144b-1a75-408f-91b9-01985c26f629} <Debug> oximeter.fields_i32 (32dde22b-5cd3-43bf-ba3c-4c192d2e6b40): There are no data parts | ||
| 723 | 2024.08.02 04:44:52.556689 [ 3 ] {5062144b-1a75-408f-91b9-01985c26f629} <Debug> DynamicQueryHandler: Done processing query | ||
| 724 | 2024.08.02 04:44:52.556715 [ 3 ] {} <Debug> HTTP-Session: 413884ae-61d2-41c3-80e9-16b3143b0ee7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 725 | 2024.08.02 04:44:52.556876 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 726 | 2024.08.02 04:44:52.556958 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 727 | 2024.08.02 04:44:52.556979 [ 3 ] {} <Debug> HTTP-Session: 2f8177a2-1979-49df-befb-3f87d989dc56 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 728 | 2024.08.02 04:44:52.557030 [ 3 ] {} <Debug> HTTP-Session: 2f8177a2-1979-49df-befb-3f87d989dc56 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 729 | 2024.08.02 04:44:52.557044 [ 3 ] {} <Debug> HTTP-Session: 2f8177a2-1979-49df-befb-3f87d989dc56 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 730 | 2024.08.02 04:44:52.557106 [ 3 ] {} <Trace> HTTP-Session: 2f8177a2-1979-49df-befb-3f87d989dc56 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 731 | 2024.08.02 04:44:52.557287 [ 3 ] {691cb178-9b28-40b6-afd6-7e6e65eebddb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 732 | 2024.08.02 04:44:52.557395 [ 3 ] {691cb178-9b28-40b6-afd6-7e6e65eebddb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 733 | 2024.08.02 04:44:52.558989 [ 3 ] {691cb178-9b28-40b6-afd6-7e6e65eebddb} <Debug> oximeter.fields_u32 (7edfa1c0-5eaf-4abd-9ec5-b8997b5ec67a): Loading data parts | ||
| 734 | 2024.08.02 04:44:52.559194 [ 3 ] {691cb178-9b28-40b6-afd6-7e6e65eebddb} <Debug> oximeter.fields_u32 (7edfa1c0-5eaf-4abd-9ec5-b8997b5ec67a): There are no data parts | ||
| 735 | 2024.08.02 04:44:52.560562 [ 3 ] {691cb178-9b28-40b6-afd6-7e6e65eebddb} <Debug> DynamicQueryHandler: Done processing query | ||
| 736 | 2024.08.02 04:44:52.560588 [ 3 ] {} <Debug> HTTP-Session: 2f8177a2-1979-49df-befb-3f87d989dc56 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 737 | 2024.08.02 04:44:52.560711 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 738 | 2024.08.02 04:44:52.560836 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 739 | 2024.08.02 04:44:52.560857 [ 3 ] {} <Debug> HTTP-Session: 8da09871-8b0a-4aab-b403-2c259580725d Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 740 | 2024.08.02 04:44:52.560904 [ 3 ] {} <Debug> HTTP-Session: 8da09871-8b0a-4aab-b403-2c259580725d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 741 | 2024.08.02 04:44:52.560925 [ 3 ] {} <Debug> HTTP-Session: 8da09871-8b0a-4aab-b403-2c259580725d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 742 | 2024.08.02 04:44:52.560955 [ 3 ] {} <Trace> HTTP-Session: 8da09871-8b0a-4aab-b403-2c259580725d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 743 | 2024.08.02 04:44:52.561128 [ 3 ] {fe8659cc-3d7e-475e-a892-0be1ba7b2115} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 744 | 2024.08.02 04:44:52.561169 [ 3 ] {fe8659cc-3d7e-475e-a892-0be1ba7b2115} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 745 | 2024.08.02 04:44:52.563206 [ 3 ] {fe8659cc-3d7e-475e-a892-0be1ba7b2115} <Debug> oximeter.fields_i64 (744652d4-f752-4f37-9895-2090e0bf9e1e): Loading data parts | ||
| 746 | 2024.08.02 04:44:52.563378 [ 3 ] {fe8659cc-3d7e-475e-a892-0be1ba7b2115} <Debug> oximeter.fields_i64 (744652d4-f752-4f37-9895-2090e0bf9e1e): There are no data parts | ||
| 747 | 2024.08.02 04:44:52.564668 [ 3 ] {fe8659cc-3d7e-475e-a892-0be1ba7b2115} <Debug> DynamicQueryHandler: Done processing query | ||
| 748 | 2024.08.02 04:44:52.564739 [ 3 ] {} <Debug> HTTP-Session: 8da09871-8b0a-4aab-b403-2c259580725d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 749 | 2024.08.02 04:44:52.564862 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 750 | 2024.08.02 04:44:52.564920 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 751 | 2024.08.02 04:44:52.564950 [ 3 ] {} <Debug> HTTP-Session: e8b78154-f5fc-4594-a885-f060b67537b7 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 752 | 2024.08.02 04:44:52.564974 [ 3 ] {} <Debug> HTTP-Session: e8b78154-f5fc-4594-a885-f060b67537b7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 753 | 2024.08.02 04:44:52.564990 [ 3 ] {} <Debug> HTTP-Session: e8b78154-f5fc-4594-a885-f060b67537b7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 754 | 2024.08.02 04:44:52.565021 [ 3 ] {} <Trace> HTTP-Session: e8b78154-f5fc-4594-a885-f060b67537b7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 755 | 2024.08.02 04:44:52.565166 [ 3 ] {d7395dbf-332e-46a6-ba38-12a46867ce3a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 756 | 2024.08.02 04:44:52.565205 [ 3 ] {d7395dbf-332e-46a6-ba38-12a46867ce3a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 757 | 2024.08.02 04:44:52.566836 [ 3 ] {d7395dbf-332e-46a6-ba38-12a46867ce3a} <Debug> oximeter.fields_u64 (f0a8d58a-d5e5-4b00-9e39-5127110ba646): Loading data parts | ||
| 758 | 2024.08.02 04:44:52.567005 [ 3 ] {d7395dbf-332e-46a6-ba38-12a46867ce3a} <Debug> oximeter.fields_u64 (f0a8d58a-d5e5-4b00-9e39-5127110ba646): There are no data parts | ||
| 759 | 2024.08.02 04:44:52.568164 [ 3 ] {d7395dbf-332e-46a6-ba38-12a46867ce3a} <Debug> DynamicQueryHandler: Done processing query | ||
| 760 | 2024.08.02 04:44:52.568191 [ 3 ] {} <Debug> HTTP-Session: e8b78154-f5fc-4594-a885-f060b67537b7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 761 | 2024.08.02 04:44:52.568314 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 252, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 762 | 2024.08.02 04:44:52.568361 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 763 | 2024.08.02 04:44:52.568380 [ 3 ] {} <Debug> HTTP-Session: baf87a31-7266-4dc7-bd1f-321ed0283a43 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 764 | 2024.08.02 04:44:52.568398 [ 3 ] {} <Debug> HTTP-Session: baf87a31-7266-4dc7-bd1f-321ed0283a43 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 765 | 2024.08.02 04:44:52.568412 [ 3 ] {} <Debug> HTTP-Session: baf87a31-7266-4dc7-bd1f-321ed0283a43 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 766 | 2024.08.02 04:44:52.568456 [ 3 ] {} <Trace> HTTP-Session: baf87a31-7266-4dc7-bd1f-321ed0283a43 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 767 | 2024.08.02 04:44:52.568606 [ 3 ] {6daf1fa1-c9f5-4d29-ae16-ee3e3d18f3ae} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 768 | 2024.08.02 04:44:52.568645 [ 3 ] {6daf1fa1-c9f5-4d29-ae16-ee3e3d18f3ae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 769 | 2024.08.02 04:44:52.570239 [ 3 ] {6daf1fa1-c9f5-4d29-ae16-ee3e3d18f3ae} <Debug> oximeter.fields_ipaddr (35740401-35fe-4ff8-b65f-af7cd5381c8a): Loading data parts | ||
| 770 | 2024.08.02 04:44:52.570414 [ 3 ] {6daf1fa1-c9f5-4d29-ae16-ee3e3d18f3ae} <Debug> oximeter.fields_ipaddr (35740401-35fe-4ff8-b65f-af7cd5381c8a): There are no data parts | ||
| 771 | 2024.08.02 04:44:52.571755 [ 3 ] {6daf1fa1-c9f5-4d29-ae16-ee3e3d18f3ae} <Debug> DynamicQueryHandler: Done processing query | ||
| 772 | 2024.08.02 04:44:52.571781 [ 3 ] {} <Debug> HTTP-Session: baf87a31-7266-4dc7-bd1f-321ed0283a43 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 773 | 2024.08.02 04:44:52.571906 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 254, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 774 | 2024.08.02 04:44:52.571961 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 775 | 2024.08.02 04:44:52.571982 [ 3 ] {} <Debug> HTTP-Session: 73b865f2-53df-4d07-967b-59bbc1196958 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 776 | 2024.08.02 04:44:52.571999 [ 3 ] {} <Debug> HTTP-Session: 73b865f2-53df-4d07-967b-59bbc1196958 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 777 | 2024.08.02 04:44:52.572013 [ 3 ] {} <Debug> HTTP-Session: 73b865f2-53df-4d07-967b-59bbc1196958 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 778 | 2024.08.02 04:44:52.572042 [ 3 ] {} <Trace> HTTP-Session: 73b865f2-53df-4d07-967b-59bbc1196958 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 779 | 2024.08.02 04:44:52.572181 [ 3 ] {ecd1e556-259a-4b05-b2d6-5ec60dff9ead} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 780 | 2024.08.02 04:44:52.572219 [ 3 ] {ecd1e556-259a-4b05-b2d6-5ec60dff9ead} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 781 | 2024.08.02 04:44:52.574282 [ 3 ] {ecd1e556-259a-4b05-b2d6-5ec60dff9ead} <Debug> oximeter.fields_string (b083a773-f137-46c6-8133-99aeb14898f7): Loading data parts | ||
| 782 | 2024.08.02 04:44:52.574466 [ 3 ] {ecd1e556-259a-4b05-b2d6-5ec60dff9ead} <Debug> oximeter.fields_string (b083a773-f137-46c6-8133-99aeb14898f7): There are no data parts | ||
| 783 | 2024.08.02 04:44:52.575705 [ 3 ] {ecd1e556-259a-4b05-b2d6-5ec60dff9ead} <Debug> DynamicQueryHandler: Done processing query | ||
| 784 | 2024.08.02 04:44:52.575731 [ 3 ] {} <Debug> HTTP-Session: 73b865f2-53df-4d07-967b-59bbc1196958 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 785 | 2024.08.02 04:44:52.575856 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 786 | 2024.08.02 04:44:52.575906 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 787 | 2024.08.02 04:44:52.575924 [ 3 ] {} <Debug> HTTP-Session: 09a17586-eb43-4beb-b351-26f8c3a52a40 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 788 | 2024.08.02 04:44:52.575941 [ 3 ] {} <Debug> HTTP-Session: 09a17586-eb43-4beb-b351-26f8c3a52a40 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 789 | 2024.08.02 04:44:52.575955 [ 3 ] {} <Debug> HTTP-Session: 09a17586-eb43-4beb-b351-26f8c3a52a40 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 790 | 2024.08.02 04:44:52.575985 [ 3 ] {} <Trace> HTTP-Session: 09a17586-eb43-4beb-b351-26f8c3a52a40 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 791 | 2024.08.02 04:44:52.576125 [ 3 ] {e7d57386-c1dc-45c7-a329-02d0da4ff9bd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 792 | 2024.08.02 04:44:52.576165 [ 3 ] {e7d57386-c1dc-45c7-a329-02d0da4ff9bd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 793 | 2024.08.02 04:44:52.577681 [ 3 ] {e7d57386-c1dc-45c7-a329-02d0da4ff9bd} <Debug> oximeter.fields_uuid (25d80245-dedd-4376-a781-99b2da9160f5): Loading data parts | ||
| 794 | 2024.08.02 04:44:52.577850 [ 3 ] {e7d57386-c1dc-45c7-a329-02d0da4ff9bd} <Debug> oximeter.fields_uuid (25d80245-dedd-4376-a781-99b2da9160f5): There are no data parts | ||
| 795 | 2024.08.02 04:44:52.579285 [ 3 ] {e7d57386-c1dc-45c7-a329-02d0da4ff9bd} <Debug> DynamicQueryHandler: Done processing query | ||
| 796 | 2024.08.02 04:44:52.579314 [ 3 ] {} <Debug> HTTP-Session: 09a17586-eb43-4beb-b351-26f8c3a52a40 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 797 | 2024.08.02 04:44:52.579446 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 798 | 2024.08.02 04:44:52.579493 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 799 | 2024.08.02 04:44:52.579512 [ 3 ] {} <Debug> HTTP-Session: 428a023e-3af7-4a3c-a305-3ed4f9a9ea9b Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 800 | 2024.08.02 04:44:52.579528 [ 3 ] {} <Debug> HTTP-Session: 428a023e-3af7-4a3c-a305-3ed4f9a9ea9b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 801 | 2024.08.02 04:44:52.579541 [ 3 ] {} <Debug> HTTP-Session: 428a023e-3af7-4a3c-a305-3ed4f9a9ea9b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 802 | 2024.08.02 04:44:52.579573 [ 3 ] {} <Trace> HTTP-Session: 428a023e-3af7-4a3c-a305-3ed4f9a9ea9b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 803 | 2024.08.02 04:44:52.579790 [ 3 ] {89081896-4e7c-4210-8ae2-bf8ab0ffa0a4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) /* The timeseries schema table stores the extracted schema for the samples | ||
| 804 | * oximeter collects. | ||
| 805 | */ | ||
| 806 | 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) | ||
| 807 | 2024.08.02 04:44:52.579849 [ 3 ] {89081896-4e7c-4210-8ae2-bf8ab0ffa0a4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 808 | 2024.08.02 04:44:52.581552 [ 3 ] {89081896-4e7c-4210-8ae2-bf8ab0ffa0a4} <Debug> oximeter.timeseries_schema (f01cc2ca-b201-4c0d-9dd8-77446afa53f6): Loading data parts | ||
| 809 | 2024.08.02 04:44:52.581735 [ 3 ] {89081896-4e7c-4210-8ae2-bf8ab0ffa0a4} <Debug> oximeter.timeseries_schema (f01cc2ca-b201-4c0d-9dd8-77446afa53f6): There are no data parts | ||
| 810 | 2024.08.02 04:44:52.583154 [ 3 ] {89081896-4e7c-4210-8ae2-bf8ab0ffa0a4} <Debug> DynamicQueryHandler: Done processing query | ||
| 811 | 2024.08.02 04:44:52.583181 [ 3 ] {} <Debug> HTTP-Session: 428a023e-3af7-4a3c-a305-3ed4f9a9ea9b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 812 | 2024.08.02 04:44:52.583331 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63561, User-Agent: (none), Length: 51, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 813 | 2024.08.02 04:44:52.583380 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 814 | 2024.08.02 04:44:52.583399 [ 3 ] {} <Debug> HTTP-Session: 4eb50559-b048-4c5a-b93b-b3bd06cb4b50 Authenticating user 'default' from [fd00:1122:3344:101::d]:63561 | ||
| 815 | 2024.08.02 04:44:52.583416 [ 3 ] {} <Debug> HTTP-Session: 4eb50559-b048-4c5a-b93b-b3bd06cb4b50 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 816 | 2024.08.02 04:44:52.583429 [ 3 ] {} <Debug> HTTP-Session: 4eb50559-b048-4c5a-b93b-b3bd06cb4b50 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 817 | 2024.08.02 04:44:52.583459 [ 3 ] {} <Trace> HTTP-Session: 4eb50559-b048-4c5a-b93b-b3bd06cb4b50 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 818 | 2024.08.02 04:44:52.583624 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63561) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 819 | 2024.08.02 04:44:52.585621 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 820 | 2024.08.02 04:44:52.589781 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Trace> oximeter.version (f3f88617-a9c7-4943-b9bd-8c79c9ba3fbd): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 821 | 2024.08.02 04:44:52.589818 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.60 GiB. | ||
| 822 | 2024.08.02 04:44:52.594691 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 823 | 2024.08.02 04:44:52.595990 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Trace> oximeter.version (f3f88617-a9c7-4943-b9bd-8c79c9ba3fbd): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 824 | 2024.08.02 04:44:52.596264 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.012719 sec., 78.6225332180203 rows/sec., 1.23 KiB/sec. | ||
| 825 | 2024.08.02 04:44:52.596446 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Debug> DynamicQueryHandler: Done processing query | ||
| 826 | 2024.08.02 04:44:52.596472 [ 3 ] {d203044d-fff3-4d78-aaa0-02e6683fc361} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 827 | 2024.08.02 04:44:52.596490 [ 3 ] {} <Debug> HTTP-Session: 4eb50559-b048-4c5a-b93b-b3bd06cb4b50 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 828 | 2024.08.02 04:44:53.000162 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 161.23 MiB, peak 166.37 MiB, free memory in arenas 0.00 B, will set to 173.67 MiB (RSS), difference: 12.44 MiB | ||