| 1 | [ Sep 9 20:59:42 Enabled. ] | ||
| 2 | [ Sep 9 20:59:42 Rereading configuration. ] | ||
| 3 | [ Sep 9 20:59:43 Rereading configuration. ] | ||
| 4 | [ Sep 9 20:59: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 | + args=("--log-file" "/var/tmp/clickhouse-server.log" "--errorlog-file" "/var/tmp/clickhouse-server.errlog" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
| 23 | + 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 | ||
| 24 | [ Sep 9 20:59:46 Method "start" exited with status 0. ] | ||
| 25 | Processing configuration file 'config.xml'. | ||
| 26 | There is no file 'config.xml', will use embedded config. | ||
| 27 | Logging trace to /var/tmp/clickhouse-server.log | ||
| 28 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
| 29 | 2024.09.09 20:59:47.369487 [ 1 ] {} <Information> Application: Will watch for the process with pid 22527 | ||
| 30 | 2024.09.09 20:59:47.370121 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 31 | 2024.09.09 20:59:47.610641 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 22527 | ||
| 32 | 2024.09.09 20:59:47.611476 [ 1 ] {} <Information> Application: starting up | ||
| 33 | 2024.09.09 20:59:47.612290 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 34 | 2024.09.09 20:59:47.697509 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
| 35 | 2024.09.09 20:59:47.727982 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 36 | 2024.09.09 20:59:47.728038 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 37 | 2024.09.09 20:59:47.728056 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 38 | 2024.09.09 20:59:47.728134 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
| 39 | 2024.09.09 20:59:47.728447 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 40 | 2024.09.09 20:59:47.730033 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 41 | Processing configuration file 'config.xml'. | ||
| 42 | There is no file 'config.xml', will use embedded config. | ||
| 43 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 44 | 2024.09.09 20:59:47.730545 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 45 | 2024.09.09 20:59:47.731434 [ 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) | ||
| 46 | 2024.09.09 20:59:47.731461 [ 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) | ||
| 47 | 2024.09.09 20:59:47.731475 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
| 48 | 2024.09.09 20:59:47.731669 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 49 | 2024.09.09 20:59:47.732571 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 50 | 2024.09.09 20:59:47.737749 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 51 | 2024.09.09 20:59:47.738538 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 52 | 2024.09.09 20:59:47.740118 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 53 | 2024.09.09 20:59:47.740191 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 54 | 2024.09.09 20:59:47.741816 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 55 | Processing configuration file 'config.xml'. | ||
| 56 | There is no file 'config.xml', will use embedded config. | ||
| 57 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 58 | 2024.09.09 20:59:47.742112 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 59 | 2024.09.09 20:59:47.746208 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 60 | 2024.09.09 20:59:47.746564 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 61 | 2024.09.09 20:59:47.747835 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 62 | 2024.09.09 20:59:47.748274 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 63 | 2024.09.09 20:59:47.748651 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 64 | 2024.09.09 20:59:47.749058 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 65 | 2024.09.09 20:59:47.750536 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 66 | 2024.09.09 20:59:47.750577 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 67 | 2024.09.09 20:59:47.750659 [ 134 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 68 | 2024.09.09 20:59:47.750787 [ 134 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 69 | 2024.09.09 20:59:47.761134 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 70 | 2024.09.09 20:59:47.761161 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000156572 sec | ||
| 71 | 2024.09.09 20:59:47.761206 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 72 | 2024.09.09 20:59:47.761218 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 73 | 2024.09.09 20:59:47.762351 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 74 | 2024.09.09 20:59:47.762425 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 75 | 2024.09.09 20:59:47.762440 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 76 | 2024.09.09 20:59:47.762478 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 77 | 2024.09.09 20:59:47.762493 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 78 | 2024.09.09 20:59:47.762504 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 79 | 2024.09.09 20:59:47.762540 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 80 | 2024.09.09 20:59:47.762552 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 81 | 2024.09.09 20:59:47.762566 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 82 | 2024.09.09 20:59:47.762601 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 83 | 2024.09.09 20:59:47.762617 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 84 | 2024.09.09 20:59:47.762630 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 85 | 2024.09.09 20:59:47.762647 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 86 | 2024.09.09 20:59:47.762682 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 87 | 2024.09.09 20:59:47.762696 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 88 | 2024.09.09 20:59:47.762709 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 89 | 2024.09.09 20:59:47.762739 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 90 | 2024.09.09 20:59:47.762755 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 91 | 2024.09.09 20:59:47.797696 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 92 | 2024.09.09 20:59:47.799086 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 93 | 2024.09.09 20:59:47.799114 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.6911e-05 sec | ||
| 94 | 2024.09.09 20:59:47.799128 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 95 | 2024.09.09 20:59:47.799139 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 96 | 2024.09.09 20:59:47.799168 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 97 | 2024.09.09 20:59:47.799355 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
| 98 | 2024.09.09 20:59:47.799400 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 99 | 2024.09.09 20:59:47.799415 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 100 | 2024.09.09 20:59:47.799427 [ 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). | ||
| 101 | 2024.09.09 20:59:47.799443 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 102 | 2024.09.09 20:59:47.849871 [ 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) | ||
| 103 | 2024.09.09 20:59:48.332294 [ 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) | ||
| 104 | 2024.09.09 20:59:48.332352 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 105 | 2024.09.09 20:59:48.377043 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 106 | 2024.09.09 20:59:48.377253 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 9.87 MiB, peak 16.07 MiB, free memory in arenas 0.00 B, will set to 157.09 MiB (RSS), difference: 147.22 MiB | ||
| 107 | 2024.09.09 20:59:48.377634 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.4341e-05 sec. | ||
| 108 | 2024.09.09 20:59:48.377964 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 109 | 2024.09.09 20:59:48.378037 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 110 | 2024.09.09 20:59:48.378127 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [fd00:1122:3344:101::e]:9004 | ||
| 111 | 2024.09.09 20:59:48.378156 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 112 | 2024.09.09 20:59:48.379118 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 113 | 2024.09.09 20:59:48.379329 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 114 | 2024.09.09 20:59:48.379364 [ 3 ] {} <Debug> HTTP-Session: 5277e3b8-4d0a-4c0c-9292-e3b26e550ec0 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 115 | 2024.09.09 20:59:48.379392 [ 3 ] {} <Debug> HTTP-Session: 5277e3b8-4d0a-4c0c-9292-e3b26e550ec0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 116 | 2024.09.09 20:59:48.379411 [ 3 ] {} <Debug> HTTP-Session: 5277e3b8-4d0a-4c0c-9292-e3b26e550ec0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 117 | 2024.09.09 20:59:48.379495 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 118 | 2024.09.09 20:59:48.379528 [ 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 | ||
| 119 | 2024.09.09 20:59:48.379551 [ 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 | ||
| 120 | 2024.09.09 20:59:48.379617 [ 3 ] {} <Trace> HTTP-Session: 5277e3b8-4d0a-4c0c-9292-e3b26e550ec0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 121 | 2024.09.09 20:59:48.380235 [ 3 ] {9fac2edc-58df-4cc6-a7ef-ccb7ca22e4dc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 122 | 2024.09.09 20:59:48.402035 [ 3 ] {9fac2edc-58df-4cc6-a7ef-ccb7ca22e4dc} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:59594) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 123 | |||
| 124 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 125 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 126 | 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 | ||
| 127 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 128 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 129 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 130 | 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 | ||
| 131 | 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 | ||
| 132 | 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 | ||
| 133 | 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 | ||
| 134 | 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 | ||
| 135 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 136 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 137 | 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 | ||
| 138 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 139 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 140 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 141 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 142 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 143 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 144 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 145 | 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 146 | |||
| 147 | 2024.09.09 20:59:48.402708 [ 3 ] {9fac2edc-58df-4cc6-a7ef-ccb7ca22e4dc} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 148 | |||
| 149 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 150 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 151 | 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 | ||
| 152 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 153 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 154 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 155 | 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 | ||
| 156 | 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 | ||
| 157 | 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 | ||
| 158 | 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 | ||
| 159 | 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 | ||
| 160 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 161 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 162 | 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 | ||
| 163 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 164 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 165 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 166 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 167 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 168 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 169 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 170 | 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 171 | (version 23.8.7.1) | ||
| 172 | 2024.09.09 20:59:48.404031 [ 3 ] {} <Debug> HTTP-Session: 5277e3b8-4d0a-4c0c-9292-e3b26e550ec0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 173 | 2024.09.09 20:59:48.404573 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 174 | 2024.09.09 20:59:48.404634 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 175 | 2024.09.09 20:59:48.404656 [ 3 ] {} <Debug> HTTP-Session: 1a8d1fd9-afe8-497d-a395-53e5b4b3cc7c Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 176 | 2024.09.09 20:59:48.404677 [ 3 ] {} <Debug> HTTP-Session: 1a8d1fd9-afe8-497d-a395-53e5b4b3cc7c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 177 | 2024.09.09 20:59:48.404689 [ 3 ] {} <Debug> HTTP-Session: 1a8d1fd9-afe8-497d-a395-53e5b4b3cc7c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 178 | 2024.09.09 20:59:48.404728 [ 3 ] {} <Trace> HTTP-Session: 1a8d1fd9-afe8-497d-a395-53e5b4b3cc7c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 179 | 2024.09.09 20:59:48.404862 [ 3 ] {896d3e29-2d68-4abb-a0ea-2eb4a2d4a619} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 180 | 2024.09.09 20:59:48.405099 [ 3 ] {896d3e29-2d68-4abb-a0ea-2eb4a2d4a619} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:59594) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 181 | |||
| 182 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 183 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 184 | 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 | ||
| 185 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 186 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 187 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 188 | 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 | ||
| 189 | 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 | ||
| 190 | 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 | ||
| 191 | 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 | ||
| 192 | 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 | ||
| 193 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 194 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 195 | 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 | ||
| 196 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 197 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 198 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 199 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 200 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 201 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 202 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 203 | 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 204 | |||
| 205 | 2024.09.09 20:59:48.405207 [ 3 ] {896d3e29-2d68-4abb-a0ea-2eb4a2d4a619} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 206 | |||
| 207 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 208 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 209 | 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 | ||
| 210 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 211 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 212 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 213 | 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 | ||
| 214 | 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 | ||
| 215 | 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 | ||
| 216 | 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 | ||
| 217 | 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 | ||
| 218 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 219 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 220 | 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 | ||
| 221 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 222 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 223 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 224 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 225 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 226 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 227 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 228 | 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 229 | (version 23.8.7.1) | ||
| 230 | 2024.09.09 20:59:48.405342 [ 3 ] {} <Debug> HTTP-Session: 1a8d1fd9-afe8-497d-a395-53e5b4b3cc7c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 231 | 2024.09.09 20:59:48.405705 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 232 | 2024.09.09 20:59:48.405753 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 233 | 2024.09.09 20:59:48.405774 [ 3 ] {} <Debug> HTTP-Session: 71b52520-97ec-451f-a792-94b081f0119f Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 234 | 2024.09.09 20:59:48.405792 [ 3 ] {} <Debug> HTTP-Session: 71b52520-97ec-451f-a792-94b081f0119f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 235 | 2024.09.09 20:59:48.405805 [ 3 ] {} <Debug> HTTP-Session: 71b52520-97ec-451f-a792-94b081f0119f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 236 | 2024.09.09 20:59:48.405836 [ 3 ] {} <Trace> HTTP-Session: 71b52520-97ec-451f-a792-94b081f0119f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 237 | 2024.09.09 20:59:48.406984 [ 3 ] {c1db0fd6-ca38-4069-ba3c-fd31ebba9660} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 238 | 2024.09.09 20:59:48.407665 [ 3 ] {c1db0fd6-ca38-4069-ba3c-fd31ebba9660} <Debug> DynamicQueryHandler: Done processing query | ||
| 239 | 2024.09.09 20:59:48.407692 [ 3 ] {} <Debug> HTTP-Session: 71b52520-97ec-451f-a792-94b081f0119f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 240 | 2024.09.09 20:59:48.407951 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 241 | 2024.09.09 20:59:48.407995 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 242 | 2024.09.09 20:59:48.408018 [ 3 ] {} <Debug> HTTP-Session: b3509fda-815f-4fbc-ae68-8291fb5256c4 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 243 | 2024.09.09 20:59:48.408036 [ 3 ] {} <Debug> HTTP-Session: b3509fda-815f-4fbc-ae68-8291fb5256c4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 244 | 2024.09.09 20:59:48.408049 [ 3 ] {} <Debug> HTTP-Session: b3509fda-815f-4fbc-ae68-8291fb5256c4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 245 | 2024.09.09 20:59:48.408079 [ 3 ] {} <Trace> HTTP-Session: b3509fda-815f-4fbc-ae68-8291fb5256c4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 246 | 2024.09.09 20:59:48.408160 [ 3 ] {ff0aeb93-e5ba-4ce3-a18e-b3a4123d28be} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 247 | 2024.09.09 20:59:48.408252 [ 3 ] {ff0aeb93-e5ba-4ce3-a18e-b3a4123d28be} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 248 | 2024.09.09 20:59:48.409481 [ 3 ] {ff0aeb93-e5ba-4ce3-a18e-b3a4123d28be} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 249 | 2024.09.09 20:59:48.409506 [ 3 ] {ff0aeb93-e5ba-4ce3-a18e-b3a4123d28be} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.86e-05 sec | ||
| 250 | 2024.09.09 20:59:48.409521 [ 3 ] {ff0aeb93-e5ba-4ce3-a18e-b3a4123d28be} <Trace> ReferentialDeps: No tables | ||
| 251 | 2024.09.09 20:59:48.409536 [ 3 ] {ff0aeb93-e5ba-4ce3-a18e-b3a4123d28be} <Trace> LoadingDeps: No tables | ||
| 252 | 2024.09.09 20:59:48.409557 [ 3 ] {ff0aeb93-e5ba-4ce3-a18e-b3a4123d28be} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 253 | 2024.09.09 20:59:48.409671 [ 3 ] {ff0aeb93-e5ba-4ce3-a18e-b3a4123d28be} <Debug> DynamicQueryHandler: Done processing query | ||
| 254 | 2024.09.09 20:59:48.409693 [ 3 ] {} <Debug> HTTP-Session: b3509fda-815f-4fbc-ae68-8291fb5256c4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 255 | 2024.09.09 20:59:48.409804 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 256 | 2024.09.09 20:59:48.409851 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 257 | 2024.09.09 20:59:48.409869 [ 3 ] {} <Debug> HTTP-Session: 21ea0c9d-a64e-4cd4-b439-123859572531 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 258 | 2024.09.09 20:59:48.409887 [ 3 ] {} <Debug> HTTP-Session: 21ea0c9d-a64e-4cd4-b439-123859572531 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 259 | 2024.09.09 20:59:48.409903 [ 3 ] {} <Debug> HTTP-Session: 21ea0c9d-a64e-4cd4-b439-123859572531 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 260 | 2024.09.09 20:59:48.409931 [ 3 ] {} <Trace> HTTP-Session: 21ea0c9d-a64e-4cd4-b439-123859572531 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 261 | 2024.09.09 20:59:48.410067 [ 3 ] {f543453d-6dc3-44fc-9c45-9854480ec857} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) /* The version table contains metadata about the `oximeter` database */ | ||
| 262 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 263 | 2024.09.09 20:59:48.410117 [ 3 ] {f543453d-6dc3-44fc-9c45-9854480ec857} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 264 | 2024.09.09 20:59:48.416865 [ 3 ] {f543453d-6dc3-44fc-9c45-9854480ec857} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 265 | 2024.09.09 20:59:48.418213 [ 3 ] {f543453d-6dc3-44fc-9c45-9854480ec857} <Debug> oximeter.version (30acbb4e-ebd6-4d39-bff7-943f3ef232ef): Loading data parts | ||
| 266 | 2024.09.09 20:59:48.418651 [ 3 ] {f543453d-6dc3-44fc-9c45-9854480ec857} <Debug> oximeter.version (30acbb4e-ebd6-4d39-bff7-943f3ef232ef): There are no data parts | ||
| 267 | 2024.09.09 20:59:48.420698 [ 3 ] {f543453d-6dc3-44fc-9c45-9854480ec857} <Debug> DynamicQueryHandler: Done processing query | ||
| 268 | 2024.09.09 20:59:48.420733 [ 3 ] {} <Debug> HTTP-Session: 21ea0c9d-a64e-4cd4-b439-123859572531 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2024.09.09 20:59:48.420846 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 270 | 2024.09.09 20:59:48.420902 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 271 | 2024.09.09 20:59:48.420926 [ 3 ] {} <Debug> HTTP-Session: cc13cce0-ed57-4dad-9c7f-3e1d548d1615 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 272 | 2024.09.09 20:59:48.420942 [ 3 ] {} <Debug> HTTP-Session: cc13cce0-ed57-4dad-9c7f-3e1d548d1615 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2024.09.09 20:59:48.420962 [ 3 ] {} <Debug> HTTP-Session: cc13cce0-ed57-4dad-9c7f-3e1d548d1615 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 274 | 2024.09.09 20:59:48.420996 [ 3 ] {} <Trace> HTTP-Session: cc13cce0-ed57-4dad-9c7f-3e1d548d1615 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 275 | 2024.09.09 20:59:48.421200 [ 3 ] {f48756cf-8a03-481e-b4c0-550d509ac61c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) /* The measurement tables contain all individual samples from each timeseries. | ||
| 276 | * | ||
| 277 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 278 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 279 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 280 | * by all samples from the same timeseries. | ||
| 281 | * | ||
| 282 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 283 | * and then uses that to index quickly into the measurements tables. | ||
| 284 | */ | ||
| 285 | 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) | ||
| 286 | 2024.09.09 20:59:48.421266 [ 3 ] {f48756cf-8a03-481e-b4c0-550d509ac61c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 287 | 2024.09.09 20:59:48.427915 [ 3 ] {f48756cf-8a03-481e-b4c0-550d509ac61c} <Debug> oximeter.measurements_bool (e887acd9-01b5-45f6-a858-236c32bf0b54): Loading data parts | ||
| 288 | 2024.09.09 20:59:48.428119 [ 3 ] {f48756cf-8a03-481e-b4c0-550d509ac61c} <Debug> oximeter.measurements_bool (e887acd9-01b5-45f6-a858-236c32bf0b54): There are no data parts | ||
| 289 | 2024.09.09 20:59:48.429410 [ 3 ] {f48756cf-8a03-481e-b4c0-550d509ac61c} <Debug> DynamicQueryHandler: Done processing query | ||
| 290 | 2024.09.09 20:59:48.429443 [ 3 ] {} <Debug> HTTP-Session: cc13cce0-ed57-4dad-9c7f-3e1d548d1615 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 291 | 2024.09.09 20:59:48.429551 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 292 | 2024.09.09 20:59:48.429603 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 293 | 2024.09.09 20:59:48.429627 [ 3 ] {} <Debug> HTTP-Session: 48de2969-6439-4e74-b382-78b9a36a527e Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 294 | 2024.09.09 20:59:48.429646 [ 3 ] {} <Debug> HTTP-Session: 48de2969-6439-4e74-b382-78b9a36a527e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.09.09 20:59:48.429660 [ 3 ] {} <Debug> HTTP-Session: 48de2969-6439-4e74-b382-78b9a36a527e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 296 | 2024.09.09 20:59:48.429691 [ 3 ] {} <Trace> HTTP-Session: 48de2969-6439-4e74-b382-78b9a36a527e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 297 | 2024.09.09 20:59:48.429867 [ 3 ] {0cee3289-99f4-460d-ab21-49cdab7ab7c4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 298 | 2024.09.09 20:59:48.429914 [ 3 ] {0cee3289-99f4-460d-ab21-49cdab7ab7c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 299 | 2024.09.09 20:59:48.431740 [ 3 ] {0cee3289-99f4-460d-ab21-49cdab7ab7c4} <Debug> oximeter.measurements_i8 (6d9b7949-df12-439d-8ad4-406c5c761f7f): Loading data parts | ||
| 300 | 2024.09.09 20:59:48.431883 [ 3 ] {0cee3289-99f4-460d-ab21-49cdab7ab7c4} <Debug> oximeter.measurements_i8 (6d9b7949-df12-439d-8ad4-406c5c761f7f): There are no data parts | ||
| 301 | 2024.09.09 20:59:48.433116 [ 3 ] {0cee3289-99f4-460d-ab21-49cdab7ab7c4} <Debug> DynamicQueryHandler: Done processing query | ||
| 302 | 2024.09.09 20:59:48.433147 [ 3 ] {} <Debug> HTTP-Session: 48de2969-6439-4e74-b382-78b9a36a527e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 303 | 2024.09.09 20:59:48.433267 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 304 | 2024.09.09 20:59:48.433317 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 305 | 2024.09.09 20:59:48.433339 [ 3 ] {} <Debug> HTTP-Session: 28a1c56e-483a-4418-a2a0-f1a301993b2f Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 306 | 2024.09.09 20:59:48.433359 [ 3 ] {} <Debug> HTTP-Session: 28a1c56e-483a-4418-a2a0-f1a301993b2f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.09.09 20:59:48.433372 [ 3 ] {} <Debug> HTTP-Session: 28a1c56e-483a-4418-a2a0-f1a301993b2f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 308 | 2024.09.09 20:59:48.433405 [ 3 ] {} <Trace> HTTP-Session: 28a1c56e-483a-4418-a2a0-f1a301993b2f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 309 | 2024.09.09 20:59:48.433579 [ 3 ] {674591be-5918-495b-acb2-0708b0f65c36} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 310 | 2024.09.09 20:59:48.433626 [ 3 ] {674591be-5918-495b-acb2-0708b0f65c36} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 311 | 2024.09.09 20:59:48.435411 [ 3 ] {674591be-5918-495b-acb2-0708b0f65c36} <Debug> oximeter.measurements_u8 (5fbaabc3-59f7-40c8-8957-5f5cc187d1bc): Loading data parts | ||
| 312 | 2024.09.09 20:59:48.435535 [ 3 ] {674591be-5918-495b-acb2-0708b0f65c36} <Debug> oximeter.measurements_u8 (5fbaabc3-59f7-40c8-8957-5f5cc187d1bc): There are no data parts | ||
| 313 | 2024.09.09 20:59:48.436762 [ 3 ] {674591be-5918-495b-acb2-0708b0f65c36} <Debug> DynamicQueryHandler: Done processing query | ||
| 314 | 2024.09.09 20:59:48.436795 [ 3 ] {} <Debug> HTTP-Session: 28a1c56e-483a-4418-a2a0-f1a301993b2f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 315 | 2024.09.09 20:59:48.436910 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 316 | 2024.09.09 20:59:48.436956 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 317 | 2024.09.09 20:59:48.436980 [ 3 ] {} <Debug> HTTP-Session: 5f7d3a18-fa07-4697-b3da-bd011c38ef0b Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 318 | 2024.09.09 20:59:48.437000 [ 3 ] {} <Debug> HTTP-Session: 5f7d3a18-fa07-4697-b3da-bd011c38ef0b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.09.09 20:59:48.437013 [ 3 ] {} <Debug> HTTP-Session: 5f7d3a18-fa07-4697-b3da-bd011c38ef0b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 320 | 2024.09.09 20:59:48.437045 [ 3 ] {} <Trace> HTTP-Session: 5f7d3a18-fa07-4697-b3da-bd011c38ef0b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 321 | 2024.09.09 20:59:48.437222 [ 3 ] {1b1e7a3a-5174-46ae-992c-b946faa0930e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 322 | 2024.09.09 20:59:48.437277 [ 3 ] {1b1e7a3a-5174-46ae-992c-b946faa0930e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 323 | 2024.09.09 20:59:48.439057 [ 3 ] {1b1e7a3a-5174-46ae-992c-b946faa0930e} <Debug> oximeter.measurements_i16 (a669645b-89e5-4815-a94a-cc9b244439bb): Loading data parts | ||
| 324 | 2024.09.09 20:59:48.439200 [ 3 ] {1b1e7a3a-5174-46ae-992c-b946faa0930e} <Debug> oximeter.measurements_i16 (a669645b-89e5-4815-a94a-cc9b244439bb): There are no data parts | ||
| 325 | 2024.09.09 20:59:48.440455 [ 3 ] {1b1e7a3a-5174-46ae-992c-b946faa0930e} <Debug> DynamicQueryHandler: Done processing query | ||
| 326 | 2024.09.09 20:59:48.440480 [ 3 ] {} <Debug> HTTP-Session: 5f7d3a18-fa07-4697-b3da-bd011c38ef0b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 327 | 2024.09.09 20:59:48.440591 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 328 | 2024.09.09 20:59:48.440646 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 329 | 2024.09.09 20:59:48.440665 [ 3 ] {} <Debug> HTTP-Session: aa878556-69a6-4c8d-8141-f7263e20821b Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 330 | 2024.09.09 20:59:48.440685 [ 3 ] {} <Debug> HTTP-Session: aa878556-69a6-4c8d-8141-f7263e20821b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 331 | 2024.09.09 20:59:48.440699 [ 3 ] {} <Debug> HTTP-Session: aa878556-69a6-4c8d-8141-f7263e20821b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 332 | 2024.09.09 20:59:48.440731 [ 3 ] {} <Trace> HTTP-Session: aa878556-69a6-4c8d-8141-f7263e20821b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 333 | 2024.09.09 20:59:48.440909 [ 3 ] {585d3103-908e-4d11-a2ac-ab9e375ad0a8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 334 | 2024.09.09 20:59:48.440957 [ 3 ] {585d3103-908e-4d11-a2ac-ab9e375ad0a8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 335 | 2024.09.09 20:59:48.442807 [ 3 ] {585d3103-908e-4d11-a2ac-ab9e375ad0a8} <Debug> oximeter.measurements_u16 (312500d6-70d0-40bf-b6bb-8ae7967c2611): Loading data parts | ||
| 336 | 2024.09.09 20:59:48.442940 [ 3 ] {585d3103-908e-4d11-a2ac-ab9e375ad0a8} <Debug> oximeter.measurements_u16 (312500d6-70d0-40bf-b6bb-8ae7967c2611): There are no data parts | ||
| 337 | 2024.09.09 20:59:48.444199 [ 3 ] {585d3103-908e-4d11-a2ac-ab9e375ad0a8} <Debug> DynamicQueryHandler: Done processing query | ||
| 338 | 2024.09.09 20:59:48.444230 [ 3 ] {} <Debug> HTTP-Session: aa878556-69a6-4c8d-8141-f7263e20821b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 339 | 2024.09.09 20:59:48.444332 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 340 | 2024.09.09 20:59:48.444383 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 341 | 2024.09.09 20:59:48.444402 [ 3 ] {} <Debug> HTTP-Session: d692c19c-d4a7-4e4c-980f-5dbe1cd92825 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 342 | 2024.09.09 20:59:48.444422 [ 3 ] {} <Debug> HTTP-Session: d692c19c-d4a7-4e4c-980f-5dbe1cd92825 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2024.09.09 20:59:48.444436 [ 3 ] {} <Debug> HTTP-Session: d692c19c-d4a7-4e4c-980f-5dbe1cd92825 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 344 | 2024.09.09 20:59:48.444469 [ 3 ] {} <Trace> HTTP-Session: d692c19c-d4a7-4e4c-980f-5dbe1cd92825 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 345 | 2024.09.09 20:59:48.444643 [ 3 ] {e8c183bc-48a0-4671-b038-f81cddb9ef2f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 346 | 2024.09.09 20:59:48.444696 [ 3 ] {e8c183bc-48a0-4671-b038-f81cddb9ef2f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 347 | 2024.09.09 20:59:48.446497 [ 3 ] {e8c183bc-48a0-4671-b038-f81cddb9ef2f} <Debug> oximeter.measurements_i32 (d2f702c7-5a91-46ce-a82c-b54db7f03dd1): Loading data parts | ||
| 348 | 2024.09.09 20:59:48.446622 [ 3 ] {e8c183bc-48a0-4671-b038-f81cddb9ef2f} <Debug> oximeter.measurements_i32 (d2f702c7-5a91-46ce-a82c-b54db7f03dd1): There are no data parts | ||
| 349 | 2024.09.09 20:59:48.447885 [ 3 ] {e8c183bc-48a0-4671-b038-f81cddb9ef2f} <Debug> DynamicQueryHandler: Done processing query | ||
| 350 | 2024.09.09 20:59:48.447909 [ 3 ] {} <Debug> HTTP-Session: d692c19c-d4a7-4e4c-980f-5dbe1cd92825 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 351 | 2024.09.09 20:59:48.448016 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 352 | 2024.09.09 20:59:48.448064 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 353 | 2024.09.09 20:59:48.448081 [ 3 ] {} <Debug> HTTP-Session: 86caf005-5212-43af-bb3b-3127af2db2b9 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 354 | 2024.09.09 20:59:48.448103 [ 3 ] {} <Debug> HTTP-Session: 86caf005-5212-43af-bb3b-3127af2db2b9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 355 | 2024.09.09 20:59:48.448120 [ 3 ] {} <Debug> HTTP-Session: 86caf005-5212-43af-bb3b-3127af2db2b9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 356 | 2024.09.09 20:59:48.448148 [ 3 ] {} <Trace> HTTP-Session: 86caf005-5212-43af-bb3b-3127af2db2b9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 357 | 2024.09.09 20:59:48.448340 [ 3 ] {44a05f68-556f-4f5a-b0e6-daac66752bdb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 358 | 2024.09.09 20:59:48.448389 [ 3 ] {44a05f68-556f-4f5a-b0e6-daac66752bdb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 359 | 2024.09.09 20:59:48.450182 [ 3 ] {44a05f68-556f-4f5a-b0e6-daac66752bdb} <Debug> oximeter.measurements_u32 (ec91c084-4249-4ab4-993d-92dea5a6fc82): Loading data parts | ||
| 360 | 2024.09.09 20:59:48.450324 [ 3 ] {44a05f68-556f-4f5a-b0e6-daac66752bdb} <Debug> oximeter.measurements_u32 (ec91c084-4249-4ab4-993d-92dea5a6fc82): There are no data parts | ||
| 361 | 2024.09.09 20:59:48.451580 [ 3 ] {44a05f68-556f-4f5a-b0e6-daac66752bdb} <Debug> DynamicQueryHandler: Done processing query | ||
| 362 | 2024.09.09 20:59:48.451605 [ 3 ] {} <Debug> HTTP-Session: 86caf005-5212-43af-bb3b-3127af2db2b9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 363 | 2024.09.09 20:59:48.451722 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 364 | 2024.09.09 20:59:48.451793 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 365 | 2024.09.09 20:59:48.451813 [ 3 ] {} <Debug> HTTP-Session: b67e35dd-0df8-4ad4-8d3e-1ad9848be94d Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 366 | 2024.09.09 20:59:48.451832 [ 3 ] {} <Debug> HTTP-Session: b67e35dd-0df8-4ad4-8d3e-1ad9848be94d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 367 | 2024.09.09 20:59:48.451846 [ 3 ] {} <Debug> HTTP-Session: b67e35dd-0df8-4ad4-8d3e-1ad9848be94d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 368 | 2024.09.09 20:59:48.451879 [ 3 ] {} <Trace> HTTP-Session: b67e35dd-0df8-4ad4-8d3e-1ad9848be94d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 369 | 2024.09.09 20:59:48.452064 [ 3 ] {ea895f25-2bf6-4ea4-a232-13fec2d8d206} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 370 | 2024.09.09 20:59:48.452117 [ 3 ] {ea895f25-2bf6-4ea4-a232-13fec2d8d206} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 371 | 2024.09.09 20:59:48.453927 [ 3 ] {ea895f25-2bf6-4ea4-a232-13fec2d8d206} <Debug> oximeter.measurements_i64 (fa6e39fc-188a-488d-9ce4-0afec1350088): Loading data parts | ||
| 372 | 2024.09.09 20:59:48.454054 [ 3 ] {ea895f25-2bf6-4ea4-a232-13fec2d8d206} <Debug> oximeter.measurements_i64 (fa6e39fc-188a-488d-9ce4-0afec1350088): There are no data parts | ||
| 373 | 2024.09.09 20:59:48.455292 [ 3 ] {ea895f25-2bf6-4ea4-a232-13fec2d8d206} <Debug> DynamicQueryHandler: Done processing query | ||
| 374 | 2024.09.09 20:59:48.455317 [ 3 ] {} <Debug> HTTP-Session: b67e35dd-0df8-4ad4-8d3e-1ad9848be94d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 375 | 2024.09.09 20:59:48.455423 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 376 | 2024.09.09 20:59:48.455473 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 377 | 2024.09.09 20:59:48.455492 [ 3 ] {} <Debug> HTTP-Session: efee65db-5c99-4e43-be55-0f621317be99 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 378 | 2024.09.09 20:59:48.455513 [ 3 ] {} <Debug> HTTP-Session: efee65db-5c99-4e43-be55-0f621317be99 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 379 | 2024.09.09 20:59:48.455529 [ 3 ] {} <Debug> HTTP-Session: efee65db-5c99-4e43-be55-0f621317be99 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 380 | 2024.09.09 20:59:48.455558 [ 3 ] {} <Trace> HTTP-Session: efee65db-5c99-4e43-be55-0f621317be99 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 381 | 2024.09.09 20:59:48.455733 [ 3 ] {72536f45-7aee-4b7a-bd67-99b66edfa0b0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 382 | 2024.09.09 20:59:48.455784 [ 3 ] {72536f45-7aee-4b7a-bd67-99b66edfa0b0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 383 | 2024.09.09 20:59:48.457583 [ 3 ] {72536f45-7aee-4b7a-bd67-99b66edfa0b0} <Debug> oximeter.measurements_u64 (8144cd4e-dc7e-44e0-9f83-daa3eb636c75): Loading data parts | ||
| 384 | 2024.09.09 20:59:48.457791 [ 3 ] {72536f45-7aee-4b7a-bd67-99b66edfa0b0} <Debug> oximeter.measurements_u64 (8144cd4e-dc7e-44e0-9f83-daa3eb636c75): There are no data parts | ||
| 385 | 2024.09.09 20:59:48.459054 [ 3 ] {72536f45-7aee-4b7a-bd67-99b66edfa0b0} <Debug> DynamicQueryHandler: Done processing query | ||
| 386 | 2024.09.09 20:59:48.459078 [ 3 ] {} <Debug> HTTP-Session: efee65db-5c99-4e43-be55-0f621317be99 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 387 | 2024.09.09 20:59:48.459186 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 388 | 2024.09.09 20:59:48.459239 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 389 | 2024.09.09 20:59:48.459257 [ 3 ] {} <Debug> HTTP-Session: a12e644b-c55c-47e4-89d8-0a2c463d3b3c Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 390 | 2024.09.09 20:59:48.459278 [ 3 ] {} <Debug> HTTP-Session: a12e644b-c55c-47e4-89d8-0a2c463d3b3c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 391 | 2024.09.09 20:59:48.459297 [ 3 ] {} <Debug> HTTP-Session: a12e644b-c55c-47e4-89d8-0a2c463d3b3c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 392 | 2024.09.09 20:59:48.459326 [ 3 ] {} <Trace> HTTP-Session: a12e644b-c55c-47e4-89d8-0a2c463d3b3c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 393 | 2024.09.09 20:59:48.459498 [ 3 ] {eb7679a7-1b91-4247-8e7a-dc4c7bb73e2e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 394 | 2024.09.09 20:59:48.459551 [ 3 ] {eb7679a7-1b91-4247-8e7a-dc4c7bb73e2e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 395 | 2024.09.09 20:59:48.461358 [ 3 ] {eb7679a7-1b91-4247-8e7a-dc4c7bb73e2e} <Debug> oximeter.measurements_f32 (92c6eab8-984b-4949-9c16-a9e7029d0307): Loading data parts | ||
| 396 | 2024.09.09 20:59:48.461515 [ 3 ] {eb7679a7-1b91-4247-8e7a-dc4c7bb73e2e} <Debug> oximeter.measurements_f32 (92c6eab8-984b-4949-9c16-a9e7029d0307): There are no data parts | ||
| 397 | 2024.09.09 20:59:48.462768 [ 3 ] {eb7679a7-1b91-4247-8e7a-dc4c7bb73e2e} <Debug> DynamicQueryHandler: Done processing query | ||
| 398 | 2024.09.09 20:59:48.462793 [ 3 ] {} <Debug> HTTP-Session: a12e644b-c55c-47e4-89d8-0a2c463d3b3c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 399 | 2024.09.09 20:59:48.462900 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 400 | 2024.09.09 20:59:48.462954 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 401 | 2024.09.09 20:59:48.462973 [ 3 ] {} <Debug> HTTP-Session: 49ea7029-69f9-4d26-b6ec-6ad09dc6eaf2 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 402 | 2024.09.09 20:59:48.462994 [ 3 ] {} <Debug> HTTP-Session: 49ea7029-69f9-4d26-b6ec-6ad09dc6eaf2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 403 | 2024.09.09 20:59:48.463011 [ 3 ] {} <Debug> HTTP-Session: 49ea7029-69f9-4d26-b6ec-6ad09dc6eaf2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 404 | 2024.09.09 20:59:48.463041 [ 3 ] {} <Trace> HTTP-Session: 49ea7029-69f9-4d26-b6ec-6ad09dc6eaf2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 405 | 2024.09.09 20:59:48.463216 [ 3 ] {75e83cc4-6d52-4dec-b6b3-9f00d525d4c5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 406 | 2024.09.09 20:59:48.463268 [ 3 ] {75e83cc4-6d52-4dec-b6b3-9f00d525d4c5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 407 | 2024.09.09 20:59:48.465062 [ 3 ] {75e83cc4-6d52-4dec-b6b3-9f00d525d4c5} <Debug> oximeter.measurements_f64 (9415ad36-f2aa-4df2-9c5c-63bef50de63b): Loading data parts | ||
| 408 | 2024.09.09 20:59:48.465215 [ 3 ] {75e83cc4-6d52-4dec-b6b3-9f00d525d4c5} <Debug> oximeter.measurements_f64 (9415ad36-f2aa-4df2-9c5c-63bef50de63b): There are no data parts | ||
| 409 | 2024.09.09 20:59:48.466468 [ 3 ] {75e83cc4-6d52-4dec-b6b3-9f00d525d4c5} <Debug> DynamicQueryHandler: Done processing query | ||
| 410 | 2024.09.09 20:59:48.466493 [ 3 ] {} <Debug> HTTP-Session: 49ea7029-69f9-4d26-b6ec-6ad09dc6eaf2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 411 | 2024.09.09 20:59:48.466609 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 412 | 2024.09.09 20:59:48.466662 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 413 | 2024.09.09 20:59:48.466686 [ 3 ] {} <Debug> HTTP-Session: 36657663-efcf-46d4-9d5a-5d71331b15b8 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 414 | 2024.09.09 20:59:48.466702 [ 3 ] {} <Debug> HTTP-Session: 36657663-efcf-46d4-9d5a-5d71331b15b8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 415 | 2024.09.09 20:59:48.466720 [ 3 ] {} <Debug> HTTP-Session: 36657663-efcf-46d4-9d5a-5d71331b15b8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 416 | 2024.09.09 20:59:48.466753 [ 3 ] {} <Trace> HTTP-Session: 36657663-efcf-46d4-9d5a-5d71331b15b8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 417 | 2024.09.09 20:59:48.466923 [ 3 ] {9215e625-c5a0-4398-844e-ed1bb68adee1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 418 | 2024.09.09 20:59:48.466976 [ 3 ] {9215e625-c5a0-4398-844e-ed1bb68adee1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 419 | 2024.09.09 20:59:48.468717 [ 3 ] {9215e625-c5a0-4398-844e-ed1bb68adee1} <Debug> oximeter.measurements_string (58dcde93-3a37-4137-b16e-47bdf26c2b8e): Loading data parts | ||
| 420 | 2024.09.09 20:59:48.468913 [ 3 ] {9215e625-c5a0-4398-844e-ed1bb68adee1} <Debug> oximeter.measurements_string (58dcde93-3a37-4137-b16e-47bdf26c2b8e): There are no data parts | ||
| 421 | 2024.09.09 20:59:48.470150 [ 3 ] {9215e625-c5a0-4398-844e-ed1bb68adee1} <Debug> DynamicQueryHandler: Done processing query | ||
| 422 | 2024.09.09 20:59:48.470175 [ 3 ] {} <Debug> HTTP-Session: 36657663-efcf-46d4-9d5a-5d71331b15b8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 423 | 2024.09.09 20:59:48.470285 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 424 | 2024.09.09 20:59:48.470336 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 425 | 2024.09.09 20:59:48.470360 [ 3 ] {} <Debug> HTTP-Session: b644b303-b8f9-4db3-92dd-40442881a99f Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 426 | 2024.09.09 20:59:48.470376 [ 3 ] {} <Debug> HTTP-Session: b644b303-b8f9-4db3-92dd-40442881a99f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 427 | 2024.09.09 20:59:48.470393 [ 3 ] {} <Debug> HTTP-Session: b644b303-b8f9-4db3-92dd-40442881a99f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 428 | 2024.09.09 20:59:48.470426 [ 3 ] {} <Trace> HTTP-Session: b644b303-b8f9-4db3-92dd-40442881a99f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 429 | 2024.09.09 20:59:48.470601 [ 3 ] {4ef33a75-1fe0-4294-bf04-0ea2d227285f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 430 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 431 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 432 | * a string isn't palatable for a few reasons. | ||
| 433 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 434 | * details. | ||
| 435 | */ | ||
| 436 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 437 | 2024.09.09 20:59:48.470656 [ 3 ] {4ef33a75-1fe0-4294-bf04-0ea2d227285f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 438 | 2024.09.09 20:59:48.472458 [ 3 ] {4ef33a75-1fe0-4294-bf04-0ea2d227285f} <Debug> oximeter.measurements_bytes (db369b88-bd7e-49fb-9439-227c7e746e65): Loading data parts | ||
| 439 | 2024.09.09 20:59:48.472591 [ 3 ] {4ef33a75-1fe0-4294-bf04-0ea2d227285f} <Debug> oximeter.measurements_bytes (db369b88-bd7e-49fb-9439-227c7e746e65): There are no data parts | ||
| 440 | 2024.09.09 20:59:48.473842 [ 3 ] {4ef33a75-1fe0-4294-bf04-0ea2d227285f} <Debug> DynamicQueryHandler: Done processing query | ||
| 441 | 2024.09.09 20:59:48.473880 [ 3 ] {} <Debug> HTTP-Session: b644b303-b8f9-4db3-92dd-40442881a99f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 442 | 2024.09.09 20:59:48.473981 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 443 | 2024.09.09 20:59:48.474033 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 444 | 2024.09.09 20:59:48.474057 [ 3 ] {} <Debug> HTTP-Session: 6c8187dd-2107-4916-9cec-9ceda68632fa Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 445 | 2024.09.09 20:59:48.474077 [ 3 ] {} <Debug> HTTP-Session: 6c8187dd-2107-4916-9cec-9ceda68632fa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 446 | 2024.09.09 20:59:48.474092 [ 3 ] {} <Debug> HTTP-Session: 6c8187dd-2107-4916-9cec-9ceda68632fa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 447 | 2024.09.09 20:59:48.474126 [ 3 ] {} <Trace> HTTP-Session: 6c8187dd-2107-4916-9cec-9ceda68632fa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 448 | 2024.09.09 20:59:48.474311 [ 3 ] {4f9fdbc8-27bb-4fb5-882d-502598e9d77f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 449 | 2024.09.09 20:59:48.474366 [ 3 ] {4f9fdbc8-27bb-4fb5-882d-502598e9d77f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 450 | 2024.09.09 20:59:48.476198 [ 3 ] {4f9fdbc8-27bb-4fb5-882d-502598e9d77f} <Debug> oximeter.measurements_cumulativei64 (b83f8009-87c8-47cc-834e-711c8a232dab): Loading data parts | ||
| 451 | 2024.09.09 20:59:48.476327 [ 3 ] {4f9fdbc8-27bb-4fb5-882d-502598e9d77f} <Debug> oximeter.measurements_cumulativei64 (b83f8009-87c8-47cc-834e-711c8a232dab): There are no data parts | ||
| 452 | 2024.09.09 20:59:48.477606 [ 3 ] {4f9fdbc8-27bb-4fb5-882d-502598e9d77f} <Debug> DynamicQueryHandler: Done processing query | ||
| 453 | 2024.09.09 20:59:48.477632 [ 3 ] {} <Debug> HTTP-Session: 6c8187dd-2107-4916-9cec-9ceda68632fa Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 454 | 2024.09.09 20:59:48.477747 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 455 | 2024.09.09 20:59:48.477799 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 456 | 2024.09.09 20:59:48.477818 [ 3 ] {} <Debug> HTTP-Session: d783bf75-a38a-426f-b3b2-f92d4c744456 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 457 | 2024.09.09 20:59:48.477839 [ 3 ] {} <Debug> HTTP-Session: d783bf75-a38a-426f-b3b2-f92d4c744456 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 458 | 2024.09.09 20:59:48.477856 [ 3 ] {} <Debug> HTTP-Session: d783bf75-a38a-426f-b3b2-f92d4c744456 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 459 | 2024.09.09 20:59:48.477887 [ 3 ] {} <Trace> HTTP-Session: d783bf75-a38a-426f-b3b2-f92d4c744456 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 460 | 2024.09.09 20:59:48.478073 [ 3 ] {7683b62e-9555-4ec0-9706-76142119d256} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 461 | 2024.09.09 20:59:48.478127 [ 3 ] {7683b62e-9555-4ec0-9706-76142119d256} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 462 | 2024.09.09 20:59:48.479926 [ 3 ] {7683b62e-9555-4ec0-9706-76142119d256} <Debug> oximeter.measurements_cumulativeu64 (51f4ecae-76e7-47f9-83b2-78ab2a63ade0): Loading data parts | ||
| 463 | 2024.09.09 20:59:48.480063 [ 3 ] {7683b62e-9555-4ec0-9706-76142119d256} <Debug> oximeter.measurements_cumulativeu64 (51f4ecae-76e7-47f9-83b2-78ab2a63ade0): There are no data parts | ||
| 464 | 2024.09.09 20:59:48.481335 [ 3 ] {7683b62e-9555-4ec0-9706-76142119d256} <Debug> DynamicQueryHandler: Done processing query | ||
| 465 | 2024.09.09 20:59:48.481366 [ 3 ] {} <Debug> HTTP-Session: d783bf75-a38a-426f-b3b2-f92d4c744456 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 466 | 2024.09.09 20:59:48.481487 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 467 | 2024.09.09 20:59:48.481539 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 468 | 2024.09.09 20:59:48.481563 [ 3 ] {} <Debug> HTTP-Session: 95ed1c9b-81e0-4de5-877a-d8e678116ac0 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 469 | 2024.09.09 20:59:48.481579 [ 3 ] {} <Debug> HTTP-Session: 95ed1c9b-81e0-4de5-877a-d8e678116ac0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 470 | 2024.09.09 20:59:48.481597 [ 3 ] {} <Debug> HTTP-Session: 95ed1c9b-81e0-4de5-877a-d8e678116ac0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 471 | 2024.09.09 20:59:48.481630 [ 3 ] {} <Trace> HTTP-Session: 95ed1c9b-81e0-4de5-877a-d8e678116ac0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 472 | 2024.09.09 20:59:48.481811 [ 3 ] {82f84d94-ba5c-403c-94c2-08038de4226a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 473 | 2024.09.09 20:59:48.481868 [ 3 ] {82f84d94-ba5c-403c-94c2-08038de4226a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 474 | 2024.09.09 20:59:48.483663 [ 3 ] {82f84d94-ba5c-403c-94c2-08038de4226a} <Debug> oximeter.measurements_cumulativef32 (c681f915-4b9b-4e1d-a597-19d2d3bfae8c): Loading data parts | ||
| 475 | 2024.09.09 20:59:48.483795 [ 3 ] {82f84d94-ba5c-403c-94c2-08038de4226a} <Debug> oximeter.measurements_cumulativef32 (c681f915-4b9b-4e1d-a597-19d2d3bfae8c): There are no data parts | ||
| 476 | 2024.09.09 20:59:48.485054 [ 3 ] {82f84d94-ba5c-403c-94c2-08038de4226a} <Debug> DynamicQueryHandler: Done processing query | ||
| 477 | 2024.09.09 20:59:48.485085 [ 3 ] {} <Debug> HTTP-Session: 95ed1c9b-81e0-4de5-877a-d8e678116ac0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 478 | 2024.09.09 20:59:48.485197 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 479 | 2024.09.09 20:59:48.485241 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 480 | 2024.09.09 20:59:48.485266 [ 3 ] {} <Debug> HTTP-Session: d1399244-3065-4ee6-9a01-3675b0bb424b Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 481 | 2024.09.09 20:59:48.485287 [ 3 ] {} <Debug> HTTP-Session: d1399244-3065-4ee6-9a01-3675b0bb424b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 482 | 2024.09.09 20:59:48.485301 [ 3 ] {} <Debug> HTTP-Session: d1399244-3065-4ee6-9a01-3675b0bb424b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 483 | 2024.09.09 20:59:48.485335 [ 3 ] {} <Trace> HTTP-Session: d1399244-3065-4ee6-9a01-3675b0bb424b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 484 | 2024.09.09 20:59:48.485518 [ 3 ] {863ebebe-6af2-448d-8749-0f157de0322f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 485 | 2024.09.09 20:59:48.485578 [ 3 ] {863ebebe-6af2-448d-8749-0f157de0322f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 486 | 2024.09.09 20:59:48.487359 [ 3 ] {863ebebe-6af2-448d-8749-0f157de0322f} <Debug> oximeter.measurements_cumulativef64 (575081b5-17c4-4ab3-b5c8-a15309098f7b): Loading data parts | ||
| 487 | 2024.09.09 20:59:48.487512 [ 3 ] {863ebebe-6af2-448d-8749-0f157de0322f} <Debug> oximeter.measurements_cumulativef64 (575081b5-17c4-4ab3-b5c8-a15309098f7b): There are no data parts | ||
| 488 | 2024.09.09 20:59:48.488743 [ 3 ] {863ebebe-6af2-448d-8749-0f157de0322f} <Debug> DynamicQueryHandler: Done processing query | ||
| 489 | 2024.09.09 20:59:48.488767 [ 3 ] {} <Debug> HTTP-Session: d1399244-3065-4ee6-9a01-3675b0bb424b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 490 | 2024.09.09 20:59:48.488891 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 491 | 2024.09.09 20:59:48.488941 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 492 | 2024.09.09 20:59:48.488960 [ 3 ] {} <Debug> HTTP-Session: 9613f467-2a14-4729-82e0-906233c4e3a9 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 493 | 2024.09.09 20:59:48.488982 [ 3 ] {} <Debug> HTTP-Session: 9613f467-2a14-4729-82e0-906233c4e3a9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 494 | 2024.09.09 20:59:48.488999 [ 3 ] {} <Debug> HTTP-Session: 9613f467-2a14-4729-82e0-906233c4e3a9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 495 | 2024.09.09 20:59:48.489028 [ 3 ] {} <Trace> HTTP-Session: 9613f467-2a14-4729-82e0-906233c4e3a9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 496 | 2024.09.09 20:59:48.489306 [ 3 ] {f16334a3-b549-4f61-b3d3-e750b8309fb0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 497 | * NOTE: Array types cannot be Nullable, see | ||
| 498 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 499 | * for more details. | ||
| 500 | * | ||
| 501 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 502 | * is unfortunate, and at this point relies on the fact that an | ||
| 503 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 504 | * to figure out another way to represent missing samples here. | ||
| 505 | */ | ||
| 506 | 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) | ||
| 507 | 2024.09.09 20:59:48.489371 [ 3 ] {f16334a3-b549-4f61-b3d3-e750b8309fb0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 508 | 2024.09.09 20:59:48.491613 [ 3 ] {f16334a3-b549-4f61-b3d3-e750b8309fb0} <Debug> oximeter.measurements_histogrami8 (2f8622cc-bff4-4dc4-a7bc-422282dc5034): Loading data parts | ||
| 509 | 2024.09.09 20:59:48.491769 [ 3 ] {f16334a3-b549-4f61-b3d3-e750b8309fb0} <Debug> oximeter.measurements_histogrami8 (2f8622cc-bff4-4dc4-a7bc-422282dc5034): There are no data parts | ||
| 510 | 2024.09.09 20:59:48.493104 [ 3 ] {f16334a3-b549-4f61-b3d3-e750b8309fb0} <Debug> DynamicQueryHandler: Done processing query | ||
| 511 | 2024.09.09 20:59:48.493130 [ 3 ] {} <Debug> HTTP-Session: 9613f467-2a14-4729-82e0-906233c4e3a9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 512 | 2024.09.09 20:59:48.493245 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 513 | 2024.09.09 20:59:48.493299 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 514 | 2024.09.09 20:59:48.493318 [ 3 ] {} <Debug> HTTP-Session: 87b6f950-6b19-4fd5-8c85-03ac7496dba3 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 515 | 2024.09.09 20:59:48.493339 [ 3 ] {} <Debug> HTTP-Session: 87b6f950-6b19-4fd5-8c85-03ac7496dba3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 516 | 2024.09.09 20:59:48.493358 [ 3 ] {} <Debug> HTTP-Session: 87b6f950-6b19-4fd5-8c85-03ac7496dba3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 517 | 2024.09.09 20:59:48.493386 [ 3 ] {} <Trace> HTTP-Session: 87b6f950-6b19-4fd5-8c85-03ac7496dba3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 518 | 2024.09.09 20:59:48.493634 [ 3 ] {e9e4c199-e15b-436b-85c3-5c63edc5dfcf} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 519 | 2024.09.09 20:59:48.493698 [ 3 ] {e9e4c199-e15b-436b-85c3-5c63edc5dfcf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 520 | 2024.09.09 20:59:48.495863 [ 3 ] {e9e4c199-e15b-436b-85c3-5c63edc5dfcf} <Debug> oximeter.measurements_histogramu8 (f7311bc9-73a6-4a58-a7ea-29087f61d24c): Loading data parts | ||
| 521 | 2024.09.09 20:59:48.495999 [ 3 ] {e9e4c199-e15b-436b-85c3-5c63edc5dfcf} <Debug> oximeter.measurements_histogramu8 (f7311bc9-73a6-4a58-a7ea-29087f61d24c): There are no data parts | ||
| 522 | 2024.09.09 20:59:48.497327 [ 3 ] {e9e4c199-e15b-436b-85c3-5c63edc5dfcf} <Debug> DynamicQueryHandler: Done processing query | ||
| 523 | 2024.09.09 20:59:48.497352 [ 3 ] {} <Debug> HTTP-Session: 87b6f950-6b19-4fd5-8c85-03ac7496dba3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 524 | 2024.09.09 20:59:48.497468 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 525 | 2024.09.09 20:59:48.497522 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 526 | 2024.09.09 20:59:48.497540 [ 3 ] {} <Debug> HTTP-Session: 3ac3bc92-3e7a-4836-996a-2388353c846e Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 527 | 2024.09.09 20:59:48.497561 [ 3 ] {} <Debug> HTTP-Session: 3ac3bc92-3e7a-4836-996a-2388353c846e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 528 | 2024.09.09 20:59:48.497580 [ 3 ] {} <Debug> HTTP-Session: 3ac3bc92-3e7a-4836-996a-2388353c846e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 529 | 2024.09.09 20:59:48.497610 [ 3 ] {} <Trace> HTTP-Session: 3ac3bc92-3e7a-4836-996a-2388353c846e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 530 | 2024.09.09 20:59:48.497859 [ 3 ] {eea311c7-753a-404e-bb61-e17a26b2d95c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 531 | 2024.09.09 20:59:48.497924 [ 3 ] {eea311c7-753a-404e-bb61-e17a26b2d95c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 532 | 2024.09.09 20:59:48.499999 [ 3 ] {eea311c7-753a-404e-bb61-e17a26b2d95c} <Debug> oximeter.measurements_histogrami16 (13f5c815-3b18-4269-864d-fb414277741b): Loading data parts | ||
| 533 | 2024.09.09 20:59:48.500158 [ 3 ] {eea311c7-753a-404e-bb61-e17a26b2d95c} <Debug> oximeter.measurements_histogrami16 (13f5c815-3b18-4269-864d-fb414277741b): There are no data parts | ||
| 534 | 2024.09.09 20:59:48.501482 [ 3 ] {eea311c7-753a-404e-bb61-e17a26b2d95c} <Debug> DynamicQueryHandler: Done processing query | ||
| 535 | 2024.09.09 20:59:48.501507 [ 3 ] {} <Debug> HTTP-Session: 3ac3bc92-3e7a-4836-996a-2388353c846e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 536 | 2024.09.09 20:59:48.501623 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 537 | 2024.09.09 20:59:48.501677 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 538 | 2024.09.09 20:59:48.501701 [ 3 ] {} <Debug> HTTP-Session: e13e297c-e958-4645-9a8d-9d021327c368 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 539 | 2024.09.09 20:59:48.501716 [ 3 ] {} <Debug> HTTP-Session: e13e297c-e958-4645-9a8d-9d021327c368 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 540 | 2024.09.09 20:59:48.501735 [ 3 ] {} <Debug> HTTP-Session: e13e297c-e958-4645-9a8d-9d021327c368 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 541 | 2024.09.09 20:59:48.501765 [ 3 ] {} <Trace> HTTP-Session: e13e297c-e958-4645-9a8d-9d021327c368 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 542 | 2024.09.09 20:59:48.502016 [ 3 ] {b1af53c7-1736-4139-b0a7-5f4e21063967} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 543 | 2024.09.09 20:59:48.502081 [ 3 ] {b1af53c7-1736-4139-b0a7-5f4e21063967} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 544 | 2024.09.09 20:59:48.504203 [ 3 ] {b1af53c7-1736-4139-b0a7-5f4e21063967} <Debug> oximeter.measurements_histogramu16 (d96e3829-f992-444d-baa0-abca3bbd795c): Loading data parts | ||
| 545 | 2024.09.09 20:59:48.504362 [ 3 ] {b1af53c7-1736-4139-b0a7-5f4e21063967} <Debug> oximeter.measurements_histogramu16 (d96e3829-f992-444d-baa0-abca3bbd795c): There are no data parts | ||
| 546 | 2024.09.09 20:59:48.505706 [ 3 ] {b1af53c7-1736-4139-b0a7-5f4e21063967} <Debug> DynamicQueryHandler: Done processing query | ||
| 547 | 2024.09.09 20:59:48.505732 [ 3 ] {} <Debug> HTTP-Session: e13e297c-e958-4645-9a8d-9d021327c368 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 548 | 2024.09.09 20:59:48.505855 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 549 | 2024.09.09 20:59:48.505910 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 550 | 2024.09.09 20:59:48.505930 [ 3 ] {} <Debug> HTTP-Session: a42101bb-969d-41f6-81f3-f17ec50f39d3 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 551 | 2024.09.09 20:59:48.505951 [ 3 ] {} <Debug> HTTP-Session: a42101bb-969d-41f6-81f3-f17ec50f39d3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 552 | 2024.09.09 20:59:48.505970 [ 3 ] {} <Debug> HTTP-Session: a42101bb-969d-41f6-81f3-f17ec50f39d3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 553 | 2024.09.09 20:59:48.506001 [ 3 ] {} <Trace> HTTP-Session: a42101bb-969d-41f6-81f3-f17ec50f39d3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 554 | 2024.09.09 20:59:48.506253 [ 3 ] {98cbf2a1-5c9a-4224-a96c-ee2fa714c215} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 555 | 2024.09.09 20:59:48.506319 [ 3 ] {98cbf2a1-5c9a-4224-a96c-ee2fa714c215} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 556 | 2024.09.09 20:59:48.508430 [ 3 ] {98cbf2a1-5c9a-4224-a96c-ee2fa714c215} <Debug> oximeter.measurements_histogrami32 (7ab9dfe2-559c-43d5-8b36-c1315e6fd24d): Loading data parts | ||
| 557 | 2024.09.09 20:59:48.508580 [ 3 ] {98cbf2a1-5c9a-4224-a96c-ee2fa714c215} <Debug> oximeter.measurements_histogrami32 (7ab9dfe2-559c-43d5-8b36-c1315e6fd24d): There are no data parts | ||
| 558 | 2024.09.09 20:59:48.509929 [ 3 ] {98cbf2a1-5c9a-4224-a96c-ee2fa714c215} <Debug> DynamicQueryHandler: Done processing query | ||
| 559 | 2024.09.09 20:59:48.509954 [ 3 ] {} <Debug> HTTP-Session: a42101bb-969d-41f6-81f3-f17ec50f39d3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 560 | 2024.09.09 20:59:48.510065 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 561 | 2024.09.09 20:59:48.510119 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 562 | 2024.09.09 20:59:48.510143 [ 3 ] {} <Debug> HTTP-Session: a40ab632-bda8-459e-9162-8aa90fae9282 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 563 | 2024.09.09 20:59:48.510159 [ 3 ] {} <Debug> HTTP-Session: a40ab632-bda8-459e-9162-8aa90fae9282 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 564 | 2024.09.09 20:59:48.510185 [ 3 ] {} <Debug> HTTP-Session: a40ab632-bda8-459e-9162-8aa90fae9282 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 565 | 2024.09.09 20:59:48.510219 [ 3 ] {} <Trace> HTTP-Session: a40ab632-bda8-459e-9162-8aa90fae9282 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 566 | 2024.09.09 20:59:48.510464 [ 3 ] {2bea57e9-56d1-4dba-9a28-42abcbe9c08c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 567 | 2024.09.09 20:59:48.510533 [ 3 ] {2bea57e9-56d1-4dba-9a28-42abcbe9c08c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 568 | 2024.09.09 20:59:48.512605 [ 3 ] {2bea57e9-56d1-4dba-9a28-42abcbe9c08c} <Debug> oximeter.measurements_histogramu32 (aa03d441-2431-4d53-864f-53c392a8ba1c): Loading data parts | ||
| 569 | 2024.09.09 20:59:48.512764 [ 3 ] {2bea57e9-56d1-4dba-9a28-42abcbe9c08c} <Debug> oximeter.measurements_histogramu32 (aa03d441-2431-4d53-864f-53c392a8ba1c): There are no data parts | ||
| 570 | 2024.09.09 20:59:48.514179 [ 3 ] {2bea57e9-56d1-4dba-9a28-42abcbe9c08c} <Debug> DynamicQueryHandler: Done processing query | ||
| 571 | 2024.09.09 20:59:48.514210 [ 3 ] {} <Debug> HTTP-Session: a40ab632-bda8-459e-9162-8aa90fae9282 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 572 | 2024.09.09 20:59:48.514368 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 573 | 2024.09.09 20:59:48.514434 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 574 | 2024.09.09 20:59:48.514470 [ 3 ] {} <Debug> HTTP-Session: b53d8b09-e20e-4f6e-acbd-2305dad265ea Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 575 | 2024.09.09 20:59:48.514490 [ 3 ] {} <Debug> HTTP-Session: b53d8b09-e20e-4f6e-acbd-2305dad265ea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 576 | 2024.09.09 20:59:48.514515 [ 3 ] {} <Debug> HTTP-Session: b53d8b09-e20e-4f6e-acbd-2305dad265ea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 577 | 2024.09.09 20:59:48.514558 [ 3 ] {} <Trace> HTTP-Session: b53d8b09-e20e-4f6e-acbd-2305dad265ea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 578 | 2024.09.09 20:59:48.514873 [ 3 ] {28f654ac-ebb2-47dc-baa0-615962cdca1f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 579 | 2024.09.09 20:59:48.514953 [ 3 ] {28f654ac-ebb2-47dc-baa0-615962cdca1f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 580 | 2024.09.09 20:59:48.517288 [ 3 ] {28f654ac-ebb2-47dc-baa0-615962cdca1f} <Debug> oximeter.measurements_histogrami64 (c312ccf3-e2ea-4c9f-bf56-4c4a9ea004eb): Loading data parts | ||
| 581 | 2024.09.09 20:59:48.517435 [ 3 ] {28f654ac-ebb2-47dc-baa0-615962cdca1f} <Debug> oximeter.measurements_histogrami64 (c312ccf3-e2ea-4c9f-bf56-4c4a9ea004eb): There are no data parts | ||
| 582 | 2024.09.09 20:59:48.518795 [ 3 ] {28f654ac-ebb2-47dc-baa0-615962cdca1f} <Debug> DynamicQueryHandler: Done processing query | ||
| 583 | 2024.09.09 20:59:48.518826 [ 3 ] {} <Debug> HTTP-Session: b53d8b09-e20e-4f6e-acbd-2305dad265ea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 584 | 2024.09.09 20:59:48.518947 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 585 | 2024.09.09 20:59:48.519000 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 586 | 2024.09.09 20:59:48.519023 [ 3 ] {} <Debug> HTTP-Session: 3faf5069-6e2c-48ed-a5af-57fe1719c6b9 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 587 | 2024.09.09 20:59:48.519039 [ 3 ] {} <Debug> HTTP-Session: 3faf5069-6e2c-48ed-a5af-57fe1719c6b9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 588 | 2024.09.09 20:59:48.519058 [ 3 ] {} <Debug> HTTP-Session: 3faf5069-6e2c-48ed-a5af-57fe1719c6b9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 589 | 2024.09.09 20:59:48.519093 [ 3 ] {} <Trace> HTTP-Session: 3faf5069-6e2c-48ed-a5af-57fe1719c6b9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 590 | 2024.09.09 20:59:48.519335 [ 3 ] {7ee0f8ec-f1a8-4101-ad4c-9650935b0657} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 591 | 2024.09.09 20:59:48.519400 [ 3 ] {7ee0f8ec-f1a8-4101-ad4c-9650935b0657} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 592 | 2024.09.09 20:59:48.521512 [ 3 ] {7ee0f8ec-f1a8-4101-ad4c-9650935b0657} <Debug> oximeter.measurements_histogramu64 (7c7ae503-5fe6-40bb-8024-dd2c81141540): Loading data parts | ||
| 593 | 2024.09.09 20:59:48.521674 [ 3 ] {7ee0f8ec-f1a8-4101-ad4c-9650935b0657} <Debug> oximeter.measurements_histogramu64 (7c7ae503-5fe6-40bb-8024-dd2c81141540): There are no data parts | ||
| 594 | 2024.09.09 20:59:48.523002 [ 3 ] {7ee0f8ec-f1a8-4101-ad4c-9650935b0657} <Debug> DynamicQueryHandler: Done processing query | ||
| 595 | 2024.09.09 20:59:48.523035 [ 3 ] {} <Debug> HTTP-Session: 3faf5069-6e2c-48ed-a5af-57fe1719c6b9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 596 | 2024.09.09 20:59:48.523149 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 597 | 2024.09.09 20:59:48.523202 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 598 | 2024.09.09 20:59:48.523226 [ 3 ] {} <Debug> HTTP-Session: 8437aa0b-3fde-4cbb-ae35-568e0255cde3 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 599 | 2024.09.09 20:59:48.523242 [ 3 ] {} <Debug> HTTP-Session: 8437aa0b-3fde-4cbb-ae35-568e0255cde3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 600 | 2024.09.09 20:59:48.523260 [ 3 ] {} <Debug> HTTP-Session: 8437aa0b-3fde-4cbb-ae35-568e0255cde3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 601 | 2024.09.09 20:59:48.523295 [ 3 ] {} <Trace> HTTP-Session: 8437aa0b-3fde-4cbb-ae35-568e0255cde3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 602 | 2024.09.09 20:59:48.523543 [ 3 ] {f7367180-baf0-4b15-99e6-8f58caf5eac4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 603 | 2024.09.09 20:59:48.523607 [ 3 ] {f7367180-baf0-4b15-99e6-8f58caf5eac4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 604 | 2024.09.09 20:59:48.525679 [ 3 ] {f7367180-baf0-4b15-99e6-8f58caf5eac4} <Debug> oximeter.measurements_histogramf32 (89dc02e2-4c74-407d-bf61-52da28a8ddaf): Loading data parts | ||
| 605 | 2024.09.09 20:59:48.525832 [ 3 ] {f7367180-baf0-4b15-99e6-8f58caf5eac4} <Debug> oximeter.measurements_histogramf32 (89dc02e2-4c74-407d-bf61-52da28a8ddaf): There are no data parts | ||
| 606 | 2024.09.09 20:59:48.527145 [ 3 ] {f7367180-baf0-4b15-99e6-8f58caf5eac4} <Debug> DynamicQueryHandler: Done processing query | ||
| 607 | 2024.09.09 20:59:48.527177 [ 3 ] {} <Debug> HTTP-Session: 8437aa0b-3fde-4cbb-ae35-568e0255cde3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 608 | 2024.09.09 20:59:48.527282 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 609 | 2024.09.09 20:59:48.527336 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 610 | 2024.09.09 20:59:48.527361 [ 3 ] {} <Debug> HTTP-Session: 948bdd2b-9fa7-4737-b1f5-fb546a1df365 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 611 | 2024.09.09 20:59:48.527377 [ 3 ] {} <Debug> HTTP-Session: 948bdd2b-9fa7-4737-b1f5-fb546a1df365 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 612 | 2024.09.09 20:59:48.527396 [ 3 ] {} <Debug> HTTP-Session: 948bdd2b-9fa7-4737-b1f5-fb546a1df365 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 613 | 2024.09.09 20:59:48.527430 [ 3 ] {} <Trace> HTTP-Session: 948bdd2b-9fa7-4737-b1f5-fb546a1df365 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 614 | 2024.09.09 20:59:48.527680 [ 3 ] {3a0ba5b5-2614-4cac-82db-06ed52d907c7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) 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) | ||
| 615 | 2024.09.09 20:59:48.527745 [ 3 ] {3a0ba5b5-2614-4cac-82db-06ed52d907c7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 616 | 2024.09.09 20:59:48.529858 [ 3 ] {3a0ba5b5-2614-4cac-82db-06ed52d907c7} <Debug> oximeter.measurements_histogramf64 (6e7541be-80f7-4772-a39c-6d881f030fa8): Loading data parts | ||
| 617 | 2024.09.09 20:59:48.530020 [ 3 ] {3a0ba5b5-2614-4cac-82db-06ed52d907c7} <Debug> oximeter.measurements_histogramf64 (6e7541be-80f7-4772-a39c-6d881f030fa8): There are no data parts | ||
| 618 | 2024.09.09 20:59:48.531318 [ 3 ] {3a0ba5b5-2614-4cac-82db-06ed52d907c7} <Debug> DynamicQueryHandler: Done processing query | ||
| 619 | 2024.09.09 20:59:48.531350 [ 3 ] {} <Debug> HTTP-Session: 948bdd2b-9fa7-4737-b1f5-fb546a1df365 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 620 | 2024.09.09 20:59:48.531465 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 621 | 2024.09.09 20:59:48.531518 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 622 | 2024.09.09 20:59:48.531543 [ 3 ] {} <Debug> HTTP-Session: 24562682-c0c0-4b40-ba8e-b0b9a4901190 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 623 | 2024.09.09 20:59:48.531563 [ 3 ] {} <Debug> HTTP-Session: 24562682-c0c0-4b40-ba8e-b0b9a4901190 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 624 | 2024.09.09 20:59:48.531577 [ 3 ] {} <Debug> HTTP-Session: 24562682-c0c0-4b40-ba8e-b0b9a4901190 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 625 | 2024.09.09 20:59:48.531611 [ 3 ] {} <Trace> HTTP-Session: 24562682-c0c0-4b40-ba8e-b0b9a4901190 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 626 | 2024.09.09 20:59:48.531792 [ 3 ] {fbc647b6-0e60-4248-8234-d7f4c98e2031} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) /* The field tables store named dimensions of each timeseries. | ||
| 627 | * | ||
| 628 | * As with the measurement tables, there is one field table for each field data | ||
| 629 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 630 | * this behavior **must not** be relied upon for query correctness. | ||
| 631 | * | ||
| 632 | * The index for the fields differs from the measurements, however. Rows are | ||
| 633 | * sorted by timeseries name, then field name, field value, and finally | ||
| 634 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 635 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 636 | * usually then used to look up measurements. | ||
| 637 | * | ||
| 638 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 639 | * timeseries name and then key, since it would improve lookups where one | ||
| 640 | * already has the key. Realistically though, these tables are quite small and | ||
| 641 | * so performance benefits will be low in absolute terms. | ||
| 642 | * | ||
| 643 | * TTL: We use a materialized column to expire old field table records. This | ||
| 644 | * column is generated automatically by the database whenever a new row is | ||
| 645 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 646 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 647 | * record will remain during a deduplication, which will have the last | ||
| 648 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 649 | * measurement tables. | ||
| 650 | */ | ||
| 651 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 652 | 2024.09.09 20:59:48.531857 [ 3 ] {fbc647b6-0e60-4248-8234-d7f4c98e2031} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 653 | 2024.09.09 20:59:48.534711 [ 3 ] {fbc647b6-0e60-4248-8234-d7f4c98e2031} <Debug> oximeter.fields_bool (049c262b-aec9-40db-ad5e-755d3a582dc4): Loading data parts | ||
| 654 | 2024.09.09 20:59:48.535122 [ 3 ] {fbc647b6-0e60-4248-8234-d7f4c98e2031} <Debug> oximeter.fields_bool (049c262b-aec9-40db-ad5e-755d3a582dc4): There are no data parts | ||
| 655 | 2024.09.09 20:59:48.539645 [ 3 ] {fbc647b6-0e60-4248-8234-d7f4c98e2031} <Debug> DynamicQueryHandler: Done processing query | ||
| 656 | 2024.09.09 20:59:48.539689 [ 3 ] {} <Debug> HTTP-Session: 24562682-c0c0-4b40-ba8e-b0b9a4901190 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 657 | 2024.09.09 20:59:48.539822 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 658 | 2024.09.09 20:59:48.539886 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 659 | 2024.09.09 20:59:48.539914 [ 3 ] {} <Debug> HTTP-Session: 39509898-a44b-415c-8dee-e98f9b4df595 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 660 | 2024.09.09 20:59:48.539932 [ 3 ] {} <Debug> HTTP-Session: 39509898-a44b-415c-8dee-e98f9b4df595 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 661 | 2024.09.09 20:59:48.539953 [ 3 ] {} <Debug> HTTP-Session: 39509898-a44b-415c-8dee-e98f9b4df595 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 662 | 2024.09.09 20:59:48.539990 [ 3 ] {} <Trace> HTTP-Session: 39509898-a44b-415c-8dee-e98f9b4df595 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 663 | 2024.09.09 20:59:48.540169 [ 3 ] {87a1af53-e027-4820-b3e7-9f7363fc11da} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 664 | 2024.09.09 20:59:48.540234 [ 3 ] {87a1af53-e027-4820-b3e7-9f7363fc11da} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 665 | 2024.09.09 20:59:48.544180 [ 3 ] {87a1af53-e027-4820-b3e7-9f7363fc11da} <Debug> oximeter.fields_i8 (aa2d88fe-0bb8-433f-ab9a-a8ca3552100a): Loading data parts | ||
| 666 | 2024.09.09 20:59:48.544337 [ 3 ] {87a1af53-e027-4820-b3e7-9f7363fc11da} <Debug> oximeter.fields_i8 (aa2d88fe-0bb8-433f-ab9a-a8ca3552100a): There are no data parts | ||
| 667 | 2024.09.09 20:59:48.548050 [ 3 ] {87a1af53-e027-4820-b3e7-9f7363fc11da} <Debug> DynamicQueryHandler: Done processing query | ||
| 668 | 2024.09.09 20:59:48.548083 [ 3 ] {} <Debug> HTTP-Session: 39509898-a44b-415c-8dee-e98f9b4df595 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 669 | 2024.09.09 20:59:48.548197 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 670 | 2024.09.09 20:59:48.548252 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 671 | 2024.09.09 20:59:48.548278 [ 3 ] {} <Debug> HTTP-Session: 9f272496-a17c-4de2-8f65-79b950717969 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 672 | 2024.09.09 20:59:48.548300 [ 3 ] {} <Debug> HTTP-Session: 9f272496-a17c-4de2-8f65-79b950717969 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 673 | 2024.09.09 20:59:48.548315 [ 3 ] {} <Debug> HTTP-Session: 9f272496-a17c-4de2-8f65-79b950717969 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 674 | 2024.09.09 20:59:48.548352 [ 3 ] {} <Trace> HTTP-Session: 9f272496-a17c-4de2-8f65-79b950717969 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 675 | 2024.09.09 20:59:48.548530 [ 3 ] {8db8dd54-758e-4aa0-a778-7a33a006d9d6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 676 | 2024.09.09 20:59:48.548588 [ 3 ] {8db8dd54-758e-4aa0-a778-7a33a006d9d6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 677 | 2024.09.09 20:59:48.565374 [ 3 ] {8db8dd54-758e-4aa0-a778-7a33a006d9d6} <Debug> oximeter.fields_u8 (d3c4c59c-ed3a-4ffc-9ef6-3d1370e122a9): Loading data parts | ||
| 678 | 2024.09.09 20:59:48.565573 [ 3 ] {8db8dd54-758e-4aa0-a778-7a33a006d9d6} <Debug> oximeter.fields_u8 (d3c4c59c-ed3a-4ffc-9ef6-3d1370e122a9): There are no data parts | ||
| 679 | 2024.09.09 20:59:48.569684 [ 3 ] {8db8dd54-758e-4aa0-a778-7a33a006d9d6} <Debug> DynamicQueryHandler: Done processing query | ||
| 680 | 2024.09.09 20:59:48.569717 [ 3 ] {} <Debug> HTTP-Session: 9f272496-a17c-4de2-8f65-79b950717969 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 681 | 2024.09.09 20:59:48.569844 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 682 | 2024.09.09 20:59:48.569903 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 683 | 2024.09.09 20:59:48.569928 [ 3 ] {} <Debug> HTTP-Session: 5e30b581-7e8f-4995-ac12-d1a2a988cb71 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 684 | 2024.09.09 20:59:48.569952 [ 3 ] {} <Debug> HTTP-Session: 5e30b581-7e8f-4995-ac12-d1a2a988cb71 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 685 | 2024.09.09 20:59:48.569965 [ 3 ] {} <Debug> HTTP-Session: 5e30b581-7e8f-4995-ac12-d1a2a988cb71 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 686 | 2024.09.09 20:59:48.570001 [ 3 ] {} <Trace> HTTP-Session: 5e30b581-7e8f-4995-ac12-d1a2a988cb71 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 687 | 2024.09.09 20:59:48.570180 [ 3 ] {96cafeaf-f6b3-40b9-ac4b-703b5bc627ad} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 688 | 2024.09.09 20:59:48.570236 [ 3 ] {96cafeaf-f6b3-40b9-ac4b-703b5bc627ad} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 689 | 2024.09.09 20:59:48.574096 [ 3 ] {96cafeaf-f6b3-40b9-ac4b-703b5bc627ad} <Debug> oximeter.fields_i16 (cdb16c9f-5f9d-429c-8072-46ee01e52538): Loading data parts | ||
| 690 | 2024.09.09 20:59:48.574268 [ 3 ] {96cafeaf-f6b3-40b9-ac4b-703b5bc627ad} <Debug> oximeter.fields_i16 (cdb16c9f-5f9d-429c-8072-46ee01e52538): There are no data parts | ||
| 691 | 2024.09.09 20:59:48.578409 [ 3 ] {96cafeaf-f6b3-40b9-ac4b-703b5bc627ad} <Debug> DynamicQueryHandler: Done processing query | ||
| 692 | 2024.09.09 20:59:48.578444 [ 3 ] {} <Debug> HTTP-Session: 5e30b581-7e8f-4995-ac12-d1a2a988cb71 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 693 | 2024.09.09 20:59:48.578572 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 694 | 2024.09.09 20:59:48.578619 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 695 | 2024.09.09 20:59:48.578646 [ 3 ] {} <Debug> HTTP-Session: 61dfaf53-1865-4802-b301-72539c757e0e Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 696 | 2024.09.09 20:59:48.578669 [ 3 ] {} <Debug> HTTP-Session: 61dfaf53-1865-4802-b301-72539c757e0e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 697 | 2024.09.09 20:59:48.578682 [ 3 ] {} <Debug> HTTP-Session: 61dfaf53-1865-4802-b301-72539c757e0e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 698 | 2024.09.09 20:59:48.578718 [ 3 ] {} <Trace> HTTP-Session: 61dfaf53-1865-4802-b301-72539c757e0e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 699 | 2024.09.09 20:59:48.578899 [ 3 ] {f6213cb0-af78-415d-a3ea-5b12505902b1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 700 | 2024.09.09 20:59:48.578957 [ 3 ] {f6213cb0-af78-415d-a3ea-5b12505902b1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 701 | 2024.09.09 20:59:48.585696 [ 3 ] {f6213cb0-af78-415d-a3ea-5b12505902b1} <Debug> oximeter.fields_u16 (99efd81b-8758-403f-aa43-aa20e3079f5e): Loading data parts | ||
| 702 | 2024.09.09 20:59:48.585852 [ 3 ] {f6213cb0-af78-415d-a3ea-5b12505902b1} <Debug> oximeter.fields_u16 (99efd81b-8758-403f-aa43-aa20e3079f5e): There are no data parts | ||
| 703 | 2024.09.09 20:59:48.589196 [ 3 ] {f6213cb0-af78-415d-a3ea-5b12505902b1} <Debug> DynamicQueryHandler: Done processing query | ||
| 704 | 2024.09.09 20:59:48.589221 [ 3 ] {} <Debug> HTTP-Session: 61dfaf53-1865-4802-b301-72539c757e0e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 705 | 2024.09.09 20:59:48.589350 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 706 | 2024.09.09 20:59:48.589407 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 707 | 2024.09.09 20:59:48.589426 [ 3 ] {} <Debug> HTTP-Session: 8bb1b03a-845d-495e-8267-597dddcd8d86 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 708 | 2024.09.09 20:59:48.589449 [ 3 ] {} <Debug> HTTP-Session: 8bb1b03a-845d-495e-8267-597dddcd8d86 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 709 | 2024.09.09 20:59:48.589470 [ 3 ] {} <Debug> HTTP-Session: 8bb1b03a-845d-495e-8267-597dddcd8d86 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 710 | 2024.09.09 20:59:48.589501 [ 3 ] {} <Trace> HTTP-Session: 8bb1b03a-845d-495e-8267-597dddcd8d86 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 711 | 2024.09.09 20:59:48.589686 [ 3 ] {cd56699b-9718-4e2a-99ac-f408bbfd2f62} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 712 | 2024.09.09 20:59:48.589750 [ 3 ] {cd56699b-9718-4e2a-99ac-f408bbfd2f62} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 713 | 2024.09.09 20:59:48.595273 [ 3 ] {cd56699b-9718-4e2a-99ac-f408bbfd2f62} <Debug> oximeter.fields_i32 (bbaa3777-56ca-4f5f-9f37-673ed1f9dd00): Loading data parts | ||
| 714 | 2024.09.09 20:59:48.595405 [ 3 ] {cd56699b-9718-4e2a-99ac-f408bbfd2f62} <Debug> oximeter.fields_i32 (bbaa3777-56ca-4f5f-9f37-673ed1f9dd00): There are no data parts | ||
| 715 | 2024.09.09 20:59:48.597088 [ 3 ] {cd56699b-9718-4e2a-99ac-f408bbfd2f62} <Debug> DynamicQueryHandler: Done processing query | ||
| 716 | 2024.09.09 20:59:48.597114 [ 3 ] {} <Debug> HTTP-Session: 8bb1b03a-845d-495e-8267-597dddcd8d86 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 717 | 2024.09.09 20:59:48.597236 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 718 | 2024.09.09 20:59:48.597294 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 719 | 2024.09.09 20:59:48.597315 [ 3 ] {} <Debug> HTTP-Session: fbaed35a-0ced-4591-8325-b5c6f5bb40b9 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 720 | 2024.09.09 20:59:48.597340 [ 3 ] {} <Debug> HTTP-Session: fbaed35a-0ced-4591-8325-b5c6f5bb40b9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 721 | 2024.09.09 20:59:48.597363 [ 3 ] {} <Debug> HTTP-Session: fbaed35a-0ced-4591-8325-b5c6f5bb40b9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 722 | 2024.09.09 20:59:48.597392 [ 3 ] {} <Trace> HTTP-Session: fbaed35a-0ced-4591-8325-b5c6f5bb40b9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 723 | 2024.09.09 20:59:48.597580 [ 3 ] {888f591f-654a-4dcb-97dc-20b9ba05c67f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 724 | 2024.09.09 20:59:48.597639 [ 3 ] {888f591f-654a-4dcb-97dc-20b9ba05c67f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 725 | 2024.09.09 20:59:48.599955 [ 3 ] {888f591f-654a-4dcb-97dc-20b9ba05c67f} <Debug> oximeter.fields_u32 (959023df-7527-4ab1-89dc-dc6480354615): Loading data parts | ||
| 726 | 2024.09.09 20:59:48.600079 [ 3 ] {888f591f-654a-4dcb-97dc-20b9ba05c67f} <Debug> oximeter.fields_u32 (959023df-7527-4ab1-89dc-dc6480354615): There are no data parts | ||
| 727 | 2024.09.09 20:59:48.601401 [ 3 ] {888f591f-654a-4dcb-97dc-20b9ba05c67f} <Debug> DynamicQueryHandler: Done processing query | ||
| 728 | 2024.09.09 20:59:48.601426 [ 3 ] {} <Debug> HTTP-Session: fbaed35a-0ced-4591-8325-b5c6f5bb40b9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 729 | 2024.09.09 20:59:48.601576 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 730 | 2024.09.09 20:59:48.601631 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 731 | 2024.09.09 20:59:48.601651 [ 3 ] {} <Debug> HTTP-Session: 837491dc-03de-485e-a23a-8a8439a1a9d3 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 732 | 2024.09.09 20:59:48.601674 [ 3 ] {} <Debug> HTTP-Session: 837491dc-03de-485e-a23a-8a8439a1a9d3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 733 | 2024.09.09 20:59:48.601695 [ 3 ] {} <Debug> HTTP-Session: 837491dc-03de-485e-a23a-8a8439a1a9d3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2024.09.09 20:59:48.601725 [ 3 ] {} <Trace> HTTP-Session: 837491dc-03de-485e-a23a-8a8439a1a9d3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 735 | 2024.09.09 20:59:48.601904 [ 3 ] {3fb5b28e-f097-436c-9e37-1e129f29b53e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 736 | 2024.09.09 20:59:48.601980 [ 3 ] {3fb5b28e-f097-436c-9e37-1e129f29b53e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 737 | 2024.09.09 20:59:48.604343 [ 3 ] {3fb5b28e-f097-436c-9e37-1e129f29b53e} <Debug> oximeter.fields_i64 (06561445-5937-4229-908f-2656048dbd1e): Loading data parts | ||
| 738 | 2024.09.09 20:59:48.604478 [ 3 ] {3fb5b28e-f097-436c-9e37-1e129f29b53e} <Debug> oximeter.fields_i64 (06561445-5937-4229-908f-2656048dbd1e): There are no data parts | ||
| 739 | 2024.09.09 20:59:48.605835 [ 3 ] {3fb5b28e-f097-436c-9e37-1e129f29b53e} <Debug> DynamicQueryHandler: Done processing query | ||
| 740 | 2024.09.09 20:59:48.605873 [ 3 ] {} <Debug> HTTP-Session: 837491dc-03de-485e-a23a-8a8439a1a9d3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 741 | 2024.09.09 20:59:48.606002 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 742 | 2024.09.09 20:59:48.606049 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 743 | 2024.09.09 20:59:48.606077 [ 3 ] {} <Debug> HTTP-Session: 39dacfbe-35da-4531-a312-9acd3abdf089 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 744 | 2024.09.09 20:59:48.606094 [ 3 ] {} <Debug> HTTP-Session: 39dacfbe-35da-4531-a312-9acd3abdf089 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 745 | 2024.09.09 20:59:48.606107 [ 3 ] {} <Debug> HTTP-Session: 39dacfbe-35da-4531-a312-9acd3abdf089 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 746 | 2024.09.09 20:59:48.606146 [ 3 ] {} <Trace> HTTP-Session: 39dacfbe-35da-4531-a312-9acd3abdf089 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 747 | 2024.09.09 20:59:48.606318 [ 3 ] {415d79d8-a83f-4ffa-bd6c-2e6cc19e538c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 748 | 2024.09.09 20:59:48.606362 [ 3 ] {415d79d8-a83f-4ffa-bd6c-2e6cc19e538c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 749 | 2024.09.09 20:59:48.608268 [ 3 ] {415d79d8-a83f-4ffa-bd6c-2e6cc19e538c} <Debug> oximeter.fields_u64 (e51f5b43-f092-44ff-a5f4-864992f51730): Loading data parts | ||
| 750 | 2024.09.09 20:59:48.608388 [ 3 ] {415d79d8-a83f-4ffa-bd6c-2e6cc19e538c} <Debug> oximeter.fields_u64 (e51f5b43-f092-44ff-a5f4-864992f51730): There are no data parts | ||
| 751 | 2024.09.09 20:59:48.609618 [ 3 ] {415d79d8-a83f-4ffa-bd6c-2e6cc19e538c} <Debug> DynamicQueryHandler: Done processing query | ||
| 752 | 2024.09.09 20:59:48.609644 [ 3 ] {} <Debug> HTTP-Session: 39dacfbe-35da-4531-a312-9acd3abdf089 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 753 | 2024.09.09 20:59:48.609754 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 754 | 2024.09.09 20:59:48.609800 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 755 | 2024.09.09 20:59:48.609819 [ 3 ] {} <Debug> HTTP-Session: 731811d2-2097-4249-bf76-e174dbb2e031 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 756 | 2024.09.09 20:59:48.609835 [ 3 ] {} <Debug> HTTP-Session: 731811d2-2097-4249-bf76-e174dbb2e031 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 757 | 2024.09.09 20:59:48.609849 [ 3 ] {} <Debug> HTTP-Session: 731811d2-2097-4249-bf76-e174dbb2e031 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 758 | 2024.09.09 20:59:48.609878 [ 3 ] {} <Trace> HTTP-Session: 731811d2-2097-4249-bf76-e174dbb2e031 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 759 | 2024.09.09 20:59:48.610048 [ 3 ] {c3d48c46-b967-4171-bc30-c6086b8c58e6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 760 | 2024.09.09 20:59:48.610092 [ 3 ] {c3d48c46-b967-4171-bc30-c6086b8c58e6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 761 | 2024.09.09 20:59:48.611965 [ 3 ] {c3d48c46-b967-4171-bc30-c6086b8c58e6} <Debug> oximeter.fields_ipaddr (05bea8e7-dbed-4870-9168-58caec997acb): Loading data parts | ||
| 762 | 2024.09.09 20:59:48.612082 [ 3 ] {c3d48c46-b967-4171-bc30-c6086b8c58e6} <Debug> oximeter.fields_ipaddr (05bea8e7-dbed-4870-9168-58caec997acb): There are no data parts | ||
| 763 | 2024.09.09 20:59:48.613359 [ 3 ] {c3d48c46-b967-4171-bc30-c6086b8c58e6} <Debug> DynamicQueryHandler: Done processing query | ||
| 764 | 2024.09.09 20:59:48.613386 [ 3 ] {} <Debug> HTTP-Session: 731811d2-2097-4249-bf76-e174dbb2e031 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 765 | 2024.09.09 20:59:48.613509 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 766 | 2024.09.09 20:59:48.613556 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 767 | 2024.09.09 20:59:48.613575 [ 3 ] {} <Debug> HTTP-Session: 07f00a54-970a-457e-946d-037dd6be9918 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 768 | 2024.09.09 20:59:48.613592 [ 3 ] {} <Debug> HTTP-Session: 07f00a54-970a-457e-946d-037dd6be9918 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 769 | 2024.09.09 20:59:48.613606 [ 3 ] {} <Debug> HTTP-Session: 07f00a54-970a-457e-946d-037dd6be9918 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 770 | 2024.09.09 20:59:48.613635 [ 3 ] {} <Trace> HTTP-Session: 07f00a54-970a-457e-946d-037dd6be9918 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 771 | 2024.09.09 20:59:48.613806 [ 3 ] {36899ad3-a5d2-48b8-a765-e8d0ff1310bd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 772 | 2024.09.09 20:59:48.613849 [ 3 ] {36899ad3-a5d2-48b8-a765-e8d0ff1310bd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 773 | 2024.09.09 20:59:48.615727 [ 3 ] {36899ad3-a5d2-48b8-a765-e8d0ff1310bd} <Debug> oximeter.fields_string (b6aa2022-63e3-4ad5-a334-df48491b8be9): Loading data parts | ||
| 774 | 2024.09.09 20:59:48.615841 [ 3 ] {36899ad3-a5d2-48b8-a765-e8d0ff1310bd} <Debug> oximeter.fields_string (b6aa2022-63e3-4ad5-a334-df48491b8be9): There are no data parts | ||
| 775 | 2024.09.09 20:59:48.617110 [ 3 ] {36899ad3-a5d2-48b8-a765-e8d0ff1310bd} <Debug> DynamicQueryHandler: Done processing query | ||
| 776 | 2024.09.09 20:59:48.617135 [ 3 ] {} <Debug> HTTP-Session: 07f00a54-970a-457e-946d-037dd6be9918 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 777 | 2024.09.09 20:59:48.617252 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 778 | 2024.09.09 20:59:48.617299 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 779 | 2024.09.09 20:59:48.617317 [ 3 ] {} <Debug> HTTP-Session: 7a8f6897-161b-4a83-9b98-2c6e968a937f Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 780 | 2024.09.09 20:59:48.617333 [ 3 ] {} <Debug> HTTP-Session: 7a8f6897-161b-4a83-9b98-2c6e968a937f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 781 | 2024.09.09 20:59:48.617347 [ 3 ] {} <Debug> HTTP-Session: 7a8f6897-161b-4a83-9b98-2c6e968a937f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 782 | 2024.09.09 20:59:48.617376 [ 3 ] {} <Trace> HTTP-Session: 7a8f6897-161b-4a83-9b98-2c6e968a937f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 783 | 2024.09.09 20:59:48.617547 [ 3 ] {4a67f66b-75ef-4cd5-a866-19e1c9beafca} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 784 | 2024.09.09 20:59:48.617590 [ 3 ] {4a67f66b-75ef-4cd5-a866-19e1c9beafca} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 785 | 2024.09.09 20:59:48.619386 [ 3 ] {4a67f66b-75ef-4cd5-a866-19e1c9beafca} <Debug> oximeter.fields_uuid (8a663554-63a5-4014-9bee-73bf32d5665b): Loading data parts | ||
| 786 | 2024.09.09 20:59:48.619501 [ 3 ] {4a67f66b-75ef-4cd5-a866-19e1c9beafca} <Debug> oximeter.fields_uuid (8a663554-63a5-4014-9bee-73bf32d5665b): There are no data parts | ||
| 787 | 2024.09.09 20:59:48.620758 [ 3 ] {4a67f66b-75ef-4cd5-a866-19e1c9beafca} <Debug> DynamicQueryHandler: Done processing query | ||
| 788 | 2024.09.09 20:59:48.620783 [ 3 ] {} <Debug> HTTP-Session: 7a8f6897-161b-4a83-9b98-2c6e968a937f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 789 | 2024.09.09 20:59:48.620890 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 790 | 2024.09.09 20:59:48.620936 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 791 | 2024.09.09 20:59:48.620956 [ 3 ] {} <Debug> HTTP-Session: a8ead8ee-68ff-4994-995e-2dc43f42f1b7 Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 792 | 2024.09.09 20:59:48.620973 [ 3 ] {} <Debug> HTTP-Session: a8ead8ee-68ff-4994-995e-2dc43f42f1b7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 793 | 2024.09.09 20:59:48.620986 [ 3 ] {} <Debug> HTTP-Session: a8ead8ee-68ff-4994-995e-2dc43f42f1b7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 794 | 2024.09.09 20:59:48.621015 [ 3 ] {} <Trace> HTTP-Session: a8ead8ee-68ff-4994-995e-2dc43f42f1b7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 795 | 2024.09.09 20:59:48.621224 [ 3 ] {2ad65b09-1de5-4f4c-a569-14f86afdf1a4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) /* The timeseries schema table stores the extracted schema for the samples | ||
| 796 | * oximeter collects. | ||
| 797 | */ | ||
| 798 | 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) | ||
| 799 | 2024.09.09 20:59:48.621283 [ 3 ] {2ad65b09-1de5-4f4c-a569-14f86afdf1a4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 800 | 2024.09.09 20:59:48.623048 [ 3 ] {2ad65b09-1de5-4f4c-a569-14f86afdf1a4} <Debug> oximeter.timeseries_schema (ed300e06-cba6-443d-a7b5-dfe998783a5f): Loading data parts | ||
| 801 | 2024.09.09 20:59:48.623164 [ 3 ] {2ad65b09-1de5-4f4c-a569-14f86afdf1a4} <Debug> oximeter.timeseries_schema (ed300e06-cba6-443d-a7b5-dfe998783a5f): There are no data parts | ||
| 802 | 2024.09.09 20:59:48.624562 [ 3 ] {2ad65b09-1de5-4f4c-a569-14f86afdf1a4} <Debug> DynamicQueryHandler: Done processing query | ||
| 803 | 2024.09.09 20:59:48.624587 [ 3 ] {} <Debug> HTTP-Session: a8ead8ee-68ff-4994-995e-2dc43f42f1b7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 804 | 2024.09.09 20:59:48.624719 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59594, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 805 | 2024.09.09 20:59:48.624766 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 806 | 2024.09.09 20:59:48.624785 [ 3 ] {} <Debug> HTTP-Session: 1320b223-c73f-4e08-8d9c-952c750e5e6f Authenticating user 'default' from [fd00:1122:3344:101::d]:59594 | ||
| 807 | 2024.09.09 20:59:48.624801 [ 3 ] {} <Debug> HTTP-Session: 1320b223-c73f-4e08-8d9c-952c750e5e6f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 808 | 2024.09.09 20:59:48.624815 [ 3 ] {} <Debug> HTTP-Session: 1320b223-c73f-4e08-8d9c-952c750e5e6f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 809 | 2024.09.09 20:59:48.624845 [ 3 ] {} <Trace> HTTP-Session: 1320b223-c73f-4e08-8d9c-952c750e5e6f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 810 | 2024.09.09 20:59:48.625007 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59594) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 811 | 2024.09.09 20:59:48.626647 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 812 | 2024.09.09 20:59:48.632082 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Trace> oximeter.version (30acbb4e-ebd6-4d39-bff7-943f3ef232ef): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 813 | 2024.09.09 20:59:48.632119 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.06 GiB. | ||
| 814 | 2024.09.09 20:59:48.636447 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 815 | 2024.09.09 20:59:48.637473 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Trace> oximeter.version (30acbb4e-ebd6-4d39-bff7-943f3ef232ef): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 816 | 2024.09.09 20:59:48.637743 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.012814 sec., 78.03964413922272 rows/sec., 1.22 KiB/sec. | ||
| 817 | 2024.09.09 20:59:48.637908 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Debug> DynamicQueryHandler: Done processing query | ||
| 818 | 2024.09.09 20:59:48.637931 [ 3 ] {d03673e6-a731-4fe0-a7ad-3877539f3442} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 819 | 2024.09.09 20:59:48.637946 [ 3 ] {} <Debug> HTTP-Session: 1320b223-c73f-4e08-8d9c-952c750e5e6f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 820 | 2024.09.09 20:59:49.000173 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 160.75 MiB, peak 165.89 MiB, free memory in arenas 0.00 B, will set to 171.59 MiB (RSS), difference: 10.84 MiB | ||