| 1 | [ Sep 3 21:29:53 Enabled. ] | ||
| 2 | [ Sep 3 21:29:53 Rereading configuration. ] | ||
| 3 | [ Sep 3 21:29:54 Rereading configuration. ] | ||
| 4 | [ Sep 3 21:29:55 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 3 21:29:55 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.03 21:29:56.963986 [ 1 ] {} <Information> Application: Will watch for the process with pid 22608 | ||
| 30 | 2024.09.03 21:29:56.964471 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 31 | 2024.09.03 21:29:57.215105 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 22608 | ||
| 32 | 2024.09.03 21:29:57.215861 [ 1 ] {} <Information> Application: starting up | ||
| 33 | 2024.09.03 21:29:57.218460 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 34 | 2024.09.03 21:29:57.311556 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
| 35 | 2024.09.03 21:29:57.344400 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 36 | 2024.09.03 21:29:57.344453 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 37 | 2024.09.03 21:29:57.344470 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 38 | 2024.09.03 21:29:57.344541 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
| 39 | 2024.09.03 21:29:57.344826 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 40 | 2024.09.03 21:29:57.346344 [ 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.03 21:29:57.346829 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 45 | 2024.09.03 21:29:57.347669 [ 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.03 21:29:57.347693 [ 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.03 21:29:57.347706 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
| 48 | 2024.09.03 21:29:57.347879 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 49 | 2024.09.03 21:29:57.348739 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 50 | 2024.09.03 21:29:57.354440 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 51 | 2024.09.03 21:29:57.355165 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 52 | 2024.09.03 21:29:57.356523 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 53 | 2024.09.03 21:29:57.356587 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 54 | 2024.09.03 21:29:57.358168 [ 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.03 21:29:57.358441 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 59 | 2024.09.03 21:29:57.362837 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 60 | 2024.09.03 21:29:57.363227 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml | ||
| 61 | 2024.09.03 21:29:57.364702 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 62 | 2024.09.03 21:29:57.365173 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 63 | 2024.09.03 21:29:57.365580 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 64 | 2024.09.03 21:29:57.365960 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 65 | 2024.09.03 21:29:57.367314 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 66 | 2024.09.03 21:29:57.367346 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 67 | 2024.09.03 21:29:57.367439 [ 136 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 68 | 2024.09.03 21:29:57.367600 [ 136 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 69 | 2024.09.03 21:29:57.376722 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 70 | 2024.09.03 21:29:57.376752 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000158604 sec | ||
| 71 | 2024.09.03 21:29:57.376796 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 72 | 2024.09.03 21:29:57.376809 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 73 | 2024.09.03 21:29:57.377966 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 74 | 2024.09.03 21:29:57.379035 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 75 | 2024.09.03 21:29:57.379057 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 76 | 2024.09.03 21:29:57.379094 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 77 | 2024.09.03 21:29:57.379112 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 78 | 2024.09.03 21:29:57.379124 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 79 | 2024.09.03 21:29:57.379156 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 80 | 2024.09.03 21:29:57.379168 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 81 | 2024.09.03 21:29:57.379184 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 82 | 2024.09.03 21:29:57.379216 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 83 | 2024.09.03 21:29:57.379233 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 84 | 2024.09.03 21:29:57.379248 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 85 | 2024.09.03 21:29:57.379263 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 86 | 2024.09.03 21:29:57.379295 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 87 | 2024.09.03 21:29:57.379310 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 88 | 2024.09.03 21:29:57.379324 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 89 | 2024.09.03 21:29:57.379356 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 90 | 2024.09.03 21:29:57.379371 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 91 | 2024.09.03 21:29:57.418468 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 92 | 2024.09.03 21:29:57.419977 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 93 | 2024.09.03 21:29:57.420005 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.9261e-05 sec | ||
| 94 | 2024.09.03 21:29:57.420020 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 95 | 2024.09.03 21:29:57.420033 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 96 | 2024.09.03 21:29:57.420061 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 97 | 2024.09.03 21:29:57.420243 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
| 98 | 2024.09.03 21:29:57.420285 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 99 | 2024.09.03 21:29:57.420299 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 100 | 2024.09.03 21:29:57.420311 [ 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.03 21:29:57.420326 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 102 | 2024.09.03 21:29:57.494897 [ 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.03 21:29:58.230599 [ 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.03 21:29:58.230653 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 105 | 2024.09.03 21:29:58.269655 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 106 | 2024.09.03 21:29:58.269864 [ 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.03 21:29:58.270783 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.5141e-05 sec. | ||
| 108 | 2024.09.03 21:29:58.271124 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 109 | 2024.09.03 21:29:58.271216 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 110 | 2024.09.03 21:29:58.271268 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [fd00:1122:3344:101::e]:9004 | ||
| 111 | 2024.09.03 21:29:58.271289 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 112 | 2024.09.03 21:29:58.713953 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 113 | 2024.09.03 21:29:58.714178 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 114 | 2024.09.03 21:29:58.714215 [ 3 ] {} <Debug> HTTP-Session: 806e9c3d-d8d3-4d65-bc80-95ebf9e48408 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 115 | 2024.09.03 21:29:58.714247 [ 3 ] {} <Debug> HTTP-Session: 806e9c3d-d8d3-4d65-bc80-95ebf9e48408 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 116 | 2024.09.03 21:29:58.714266 [ 3 ] {} <Debug> HTTP-Session: 806e9c3d-d8d3-4d65-bc80-95ebf9e48408 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 117 | 2024.09.03 21:29:58.714354 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 118 | 2024.09.03 21:29:58.714389 [ 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.03 21:29:58.714422 [ 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.03 21:29:58.714488 [ 3 ] {} <Trace> HTTP-Session: 806e9c3d-d8d3-4d65-bc80-95ebf9e48408 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 121 | 2024.09.03 21:29:58.715625 [ 3 ] {de453555-f4fc-4b9d-9c5d-633ee2092548} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 122 | 2024.09.03 21:29:58.756774 [ 3 ] {de453555-f4fc-4b9d-9c5d-633ee2092548} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:51244) (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.03 21:29:58.757520 [ 3 ] {de453555-f4fc-4b9d-9c5d-633ee2092548} <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.03 21:29:58.762390 [ 3 ] {} <Debug> HTTP-Session: 806e9c3d-d8d3-4d65-bc80-95ebf9e48408 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 173 | 2024.09.03 21:29:58.763907 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 174 | 2024.09.03 21:29:58.763989 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 175 | 2024.09.03 21:29:58.764016 [ 3 ] {} <Debug> HTTP-Session: d2f4bb02-cca0-4294-8c09-f0a75b264115 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 176 | 2024.09.03 21:29:58.764043 [ 3 ] {} <Debug> HTTP-Session: d2f4bb02-cca0-4294-8c09-f0a75b264115 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 177 | 2024.09.03 21:29:58.764058 [ 3 ] {} <Debug> HTTP-Session: d2f4bb02-cca0-4294-8c09-f0a75b264115 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 178 | 2024.09.03 21:29:58.764107 [ 3 ] {} <Trace> HTTP-Session: d2f4bb02-cca0-4294-8c09-f0a75b264115 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 179 | 2024.09.03 21:29:58.764266 [ 3 ] {201d6a46-5600-466a-862f-64f40f0e1eee} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 180 | 2024.09.03 21:29:58.764536 [ 3 ] {201d6a46-5600-466a-862f-64f40f0e1eee} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:51244) (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.03 21:29:58.764648 [ 3 ] {201d6a46-5600-466a-862f-64f40f0e1eee} <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.03 21:29:58.764788 [ 3 ] {} <Debug> HTTP-Session: d2f4bb02-cca0-4294-8c09-f0a75b264115 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 231 | 2024.09.03 21:29:58.766099 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 232 | 2024.09.03 21:29:58.766154 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 233 | 2024.09.03 21:29:58.766178 [ 3 ] {} <Debug> HTTP-Session: aa262854-f3fe-41a0-b716-f4721f93ff89 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 234 | 2024.09.03 21:29:58.766197 [ 3 ] {} <Debug> HTTP-Session: aa262854-f3fe-41a0-b716-f4721f93ff89 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 235 | 2024.09.03 21:29:58.766210 [ 3 ] {} <Debug> HTTP-Session: aa262854-f3fe-41a0-b716-f4721f93ff89 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 236 | 2024.09.03 21:29:58.766243 [ 3 ] {} <Trace> HTTP-Session: aa262854-f3fe-41a0-b716-f4721f93ff89 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 237 | 2024.09.03 21:29:58.767436 [ 3 ] {c501159b-8609-42ba-998b-e633a635805a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 238 | 2024.09.03 21:29:58.768135 [ 3 ] {c501159b-8609-42ba-998b-e633a635805a} <Debug> DynamicQueryHandler: Done processing query | ||
| 239 | 2024.09.03 21:29:58.768168 [ 3 ] {} <Debug> HTTP-Session: aa262854-f3fe-41a0-b716-f4721f93ff89 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 240 | 2024.09.03 21:29:58.769368 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 241 | 2024.09.03 21:29:58.769413 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 242 | 2024.09.03 21:29:58.769438 [ 3 ] {} <Debug> HTTP-Session: 7ca63d12-4539-4b68-95d1-39499609d8c7 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 243 | 2024.09.03 21:29:58.769460 [ 3 ] {} <Debug> HTTP-Session: 7ca63d12-4539-4b68-95d1-39499609d8c7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 244 | 2024.09.03 21:29:58.769473 [ 3 ] {} <Debug> HTTP-Session: 7ca63d12-4539-4b68-95d1-39499609d8c7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 245 | 2024.09.03 21:29:58.769506 [ 3 ] {} <Trace> HTTP-Session: 7ca63d12-4539-4b68-95d1-39499609d8c7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 246 | 2024.09.03 21:29:58.769591 [ 3 ] {7a8b2333-2c18-4b0f-b93a-e74bddf18c76} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 247 | 2024.09.03 21:29:58.769687 [ 3 ] {7a8b2333-2c18-4b0f-b93a-e74bddf18c76} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 248 | 2024.09.03 21:29:58.770726 [ 3 ] {7a8b2333-2c18-4b0f-b93a-e74bddf18c76} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 249 | 2024.09.03 21:29:58.770754 [ 3 ] {7a8b2333-2c18-4b0f-b93a-e74bddf18c76} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.1172e-05 sec | ||
| 250 | 2024.09.03 21:29:58.770769 [ 3 ] {7a8b2333-2c18-4b0f-b93a-e74bddf18c76} <Trace> ReferentialDeps: No tables | ||
| 251 | 2024.09.03 21:29:58.770787 [ 3 ] {7a8b2333-2c18-4b0f-b93a-e74bddf18c76} <Trace> LoadingDeps: No tables | ||
| 252 | 2024.09.03 21:29:58.770807 [ 3 ] {7a8b2333-2c18-4b0f-b93a-e74bddf18c76} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 253 | 2024.09.03 21:29:58.770928 [ 3 ] {7a8b2333-2c18-4b0f-b93a-e74bddf18c76} <Debug> DynamicQueryHandler: Done processing query | ||
| 254 | 2024.09.03 21:29:58.770951 [ 3 ] {} <Debug> HTTP-Session: 7ca63d12-4539-4b68-95d1-39499609d8c7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 255 | 2024.09.03 21:29:58.771078 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 256 | 2024.09.03 21:29:58.771128 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 257 | 2024.09.03 21:29:58.771146 [ 3 ] {} <Debug> HTTP-Session: 15e0712c-7214-4439-9eb4-9618994d870e Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 258 | 2024.09.03 21:29:58.771167 [ 3 ] {} <Debug> HTTP-Session: 15e0712c-7214-4439-9eb4-9618994d870e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 259 | 2024.09.03 21:29:58.771184 [ 3 ] {} <Debug> HTTP-Session: 15e0712c-7214-4439-9eb4-9618994d870e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 260 | 2024.09.03 21:29:58.771214 [ 3 ] {} <Trace> HTTP-Session: 15e0712c-7214-4439-9eb4-9618994d870e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 261 | 2024.09.03 21:29:58.771356 [ 3 ] {bb5fc72d-63e8-47e8-b8b1-b928b1ea02b7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) /* 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.03 21:29:58.771409 [ 3 ] {bb5fc72d-63e8-47e8-b8b1-b928b1ea02b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 264 | 2024.09.03 21:29:58.778896 [ 3 ] {bb5fc72d-63e8-47e8-b8b1-b928b1ea02b7} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 265 | 2024.09.03 21:29:58.779925 [ 3 ] {bb5fc72d-63e8-47e8-b8b1-b928b1ea02b7} <Debug> oximeter.version (b409d17c-4e3b-4f2d-8ac1-19d3923d30ae): Loading data parts | ||
| 266 | 2024.09.03 21:29:58.780426 [ 3 ] {bb5fc72d-63e8-47e8-b8b1-b928b1ea02b7} <Debug> oximeter.version (b409d17c-4e3b-4f2d-8ac1-19d3923d30ae): There are no data parts | ||
| 267 | 2024.09.03 21:29:58.783040 [ 3 ] {bb5fc72d-63e8-47e8-b8b1-b928b1ea02b7} <Debug> DynamicQueryHandler: Done processing query | ||
| 268 | 2024.09.03 21:29:58.783070 [ 3 ] {} <Debug> HTTP-Session: 15e0712c-7214-4439-9eb4-9618994d870e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2024.09.03 21:29:58.783205 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 270 | 2024.09.03 21:29:58.783259 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 271 | 2024.09.03 21:29:58.783281 [ 3 ] {} <Debug> HTTP-Session: d13669ec-4a8b-40d3-b16d-b5b08817ab3d Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 272 | 2024.09.03 21:29:58.783297 [ 3 ] {} <Debug> HTTP-Session: d13669ec-4a8b-40d3-b16d-b5b08817ab3d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2024.09.03 21:29:58.783316 [ 3 ] {} <Debug> HTTP-Session: d13669ec-4a8b-40d3-b16d-b5b08817ab3d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 274 | 2024.09.03 21:29:58.783349 [ 3 ] {} <Trace> HTTP-Session: d13669ec-4a8b-40d3-b16d-b5b08817ab3d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 275 | 2024.09.03 21:29:58.783564 [ 3 ] {38ef216d-3c43-4c23-b42d-a732ab9702e5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) /* 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.03 21:29:58.783620 [ 3 ] {38ef216d-3c43-4c23-b42d-a732ab9702e5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 287 | 2024.09.03 21:29:58.792647 [ 3 ] {38ef216d-3c43-4c23-b42d-a732ab9702e5} <Debug> oximeter.measurements_bool (8464e6af-d80a-4845-bf27-6dca1b4c8b7d): Loading data parts | ||
| 288 | 2024.09.03 21:29:58.792869 [ 3 ] {38ef216d-3c43-4c23-b42d-a732ab9702e5} <Debug> oximeter.measurements_bool (8464e6af-d80a-4845-bf27-6dca1b4c8b7d): There are no data parts | ||
| 289 | 2024.09.03 21:29:58.796485 [ 3 ] {38ef216d-3c43-4c23-b42d-a732ab9702e5} <Debug> DynamicQueryHandler: Done processing query | ||
| 290 | 2024.09.03 21:29:58.796518 [ 3 ] {} <Debug> HTTP-Session: d13669ec-4a8b-40d3-b16d-b5b08817ab3d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 291 | 2024.09.03 21:29:58.796660 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 292 | 2024.09.03 21:29:58.796715 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 293 | 2024.09.03 21:29:58.796738 [ 3 ] {} <Debug> HTTP-Session: 66d902f9-f72a-496b-a7f6-84a22de4fd09 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 294 | 2024.09.03 21:29:58.796758 [ 3 ] {} <Debug> HTTP-Session: 66d902f9-f72a-496b-a7f6-84a22de4fd09 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 295 | 2024.09.03 21:29:58.796772 [ 3 ] {} <Debug> HTTP-Session: 66d902f9-f72a-496b-a7f6-84a22de4fd09 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 296 | 2024.09.03 21:29:58.796807 [ 3 ] {} <Trace> HTTP-Session: 66d902f9-f72a-496b-a7f6-84a22de4fd09 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 297 | 2024.09.03 21:29:58.796987 [ 3 ] {22d8d8aa-c7d8-46d8-8fd0-7ea450ef90ae} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.797044 [ 3 ] {22d8d8aa-c7d8-46d8-8fd0-7ea450ef90ae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 299 | 2024.09.03 21:29:58.799611 [ 3 ] {22d8d8aa-c7d8-46d8-8fd0-7ea450ef90ae} <Debug> oximeter.measurements_i8 (c210997f-79dd-4bb5-9b6c-ef9284da95b2): Loading data parts | ||
| 300 | 2024.09.03 21:29:58.799773 [ 3 ] {22d8d8aa-c7d8-46d8-8fd0-7ea450ef90ae} <Debug> oximeter.measurements_i8 (c210997f-79dd-4bb5-9b6c-ef9284da95b2): There are no data parts | ||
| 301 | 2024.09.03 21:29:58.802925 [ 3 ] {22d8d8aa-c7d8-46d8-8fd0-7ea450ef90ae} <Debug> DynamicQueryHandler: Done processing query | ||
| 302 | 2024.09.03 21:29:58.802962 [ 3 ] {} <Debug> HTTP-Session: 66d902f9-f72a-496b-a7f6-84a22de4fd09 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 303 | 2024.09.03 21:29:58.803114 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 304 | 2024.09.03 21:29:58.803173 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 305 | 2024.09.03 21:29:58.803196 [ 3 ] {} <Debug> HTTP-Session: 22696426-d20d-43ee-b789-7ddd2df36a8a Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 306 | 2024.09.03 21:29:58.803215 [ 3 ] {} <Debug> HTTP-Session: 22696426-d20d-43ee-b789-7ddd2df36a8a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.09.03 21:29:58.803228 [ 3 ] {} <Debug> HTTP-Session: 22696426-d20d-43ee-b789-7ddd2df36a8a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 308 | 2024.09.03 21:29:58.803267 [ 3 ] {} <Trace> HTTP-Session: 22696426-d20d-43ee-b789-7ddd2df36a8a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 309 | 2024.09.03 21:29:58.803440 [ 3 ] {1157195f-c151-4eef-995b-d85d386513f5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.803487 [ 3 ] {1157195f-c151-4eef-995b-d85d386513f5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 311 | 2024.09.03 21:29:58.805512 [ 3 ] {1157195f-c151-4eef-995b-d85d386513f5} <Debug> oximeter.measurements_u8 (646949b1-6650-40ed-b476-1481c9f6ae7a): Loading data parts | ||
| 312 | 2024.09.03 21:29:58.805700 [ 3 ] {1157195f-c151-4eef-995b-d85d386513f5} <Debug> oximeter.measurements_u8 (646949b1-6650-40ed-b476-1481c9f6ae7a): There are no data parts | ||
| 313 | 2024.09.03 21:29:58.807185 [ 3 ] {1157195f-c151-4eef-995b-d85d386513f5} <Debug> DynamicQueryHandler: Done processing query | ||
| 314 | 2024.09.03 21:29:58.807224 [ 3 ] {} <Debug> HTTP-Session: 22696426-d20d-43ee-b789-7ddd2df36a8a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 315 | 2024.09.03 21:29:58.807373 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 316 | 2024.09.03 21:29:58.807425 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 317 | 2024.09.03 21:29:58.807454 [ 3 ] {} <Debug> HTTP-Session: 65e6083e-99a5-40d5-8161-bacfd7687bd0 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 318 | 2024.09.03 21:29:58.807476 [ 3 ] {} <Debug> HTTP-Session: 65e6083e-99a5-40d5-8161-bacfd7687bd0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.09.03 21:29:58.807490 [ 3 ] {} <Debug> HTTP-Session: 65e6083e-99a5-40d5-8161-bacfd7687bd0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 320 | 2024.09.03 21:29:58.807529 [ 3 ] {} <Trace> HTTP-Session: 65e6083e-99a5-40d5-8161-bacfd7687bd0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 321 | 2024.09.03 21:29:58.807714 [ 3 ] {61f40dd7-0a77-43e3-a537-2dab31a6bd5d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.807773 [ 3 ] {61f40dd7-0a77-43e3-a537-2dab31a6bd5d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 323 | 2024.09.03 21:29:58.810229 [ 3 ] {61f40dd7-0a77-43e3-a537-2dab31a6bd5d} <Debug> oximeter.measurements_i16 (5e4c60ab-9728-45ba-a67f-35e8f8c7fe2c): Loading data parts | ||
| 324 | 2024.09.03 21:29:58.810395 [ 3 ] {61f40dd7-0a77-43e3-a537-2dab31a6bd5d} <Debug> oximeter.measurements_i16 (5e4c60ab-9728-45ba-a67f-35e8f8c7fe2c): There are no data parts | ||
| 325 | 2024.09.03 21:29:58.811792 [ 3 ] {61f40dd7-0a77-43e3-a537-2dab31a6bd5d} <Debug> DynamicQueryHandler: Done processing query | ||
| 326 | 2024.09.03 21:29:58.811818 [ 3 ] {} <Debug> HTTP-Session: 65e6083e-99a5-40d5-8161-bacfd7687bd0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 327 | 2024.09.03 21:29:58.811954 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 328 | 2024.09.03 21:29:58.812019 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 329 | 2024.09.03 21:29:58.812046 [ 3 ] {} <Debug> HTTP-Session: 349f6873-2365-4029-b335-191495c1a4b1 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 330 | 2024.09.03 21:29:58.812070 [ 3 ] {} <Debug> HTTP-Session: 349f6873-2365-4029-b335-191495c1a4b1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 331 | 2024.09.03 21:29:58.812083 [ 3 ] {} <Debug> HTTP-Session: 349f6873-2365-4029-b335-191495c1a4b1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 332 | 2024.09.03 21:29:58.812119 [ 3 ] {} <Trace> HTTP-Session: 349f6873-2365-4029-b335-191495c1a4b1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 333 | 2024.09.03 21:29:58.812300 [ 3 ] {d5853692-3f3b-4758-8d2b-ff671b6d1a4d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.812360 [ 3 ] {d5853692-3f3b-4758-8d2b-ff671b6d1a4d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 335 | 2024.09.03 21:29:58.815404 [ 3 ] {d5853692-3f3b-4758-8d2b-ff671b6d1a4d} <Debug> oximeter.measurements_u16 (f4e27490-e86b-47ef-a79d-14b26142af2c): Loading data parts | ||
| 336 | 2024.09.03 21:29:58.815580 [ 3 ] {d5853692-3f3b-4758-8d2b-ff671b6d1a4d} <Debug> oximeter.measurements_u16 (f4e27490-e86b-47ef-a79d-14b26142af2c): There are no data parts | ||
| 337 | 2024.09.03 21:29:58.816953 [ 3 ] {d5853692-3f3b-4758-8d2b-ff671b6d1a4d} <Debug> DynamicQueryHandler: Done processing query | ||
| 338 | 2024.09.03 21:29:58.816988 [ 3 ] {} <Debug> HTTP-Session: 349f6873-2365-4029-b335-191495c1a4b1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 339 | 2024.09.03 21:29:58.817127 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 340 | 2024.09.03 21:29:58.817184 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 341 | 2024.09.03 21:29:58.817203 [ 3 ] {} <Debug> HTTP-Session: 8e2e42cc-a354-4fa8-a994-420d0ef263e0 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 342 | 2024.09.03 21:29:58.817227 [ 3 ] {} <Debug> HTTP-Session: 8e2e42cc-a354-4fa8-a994-420d0ef263e0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 343 | 2024.09.03 21:29:58.817241 [ 3 ] {} <Debug> HTTP-Session: 8e2e42cc-a354-4fa8-a994-420d0ef263e0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 344 | 2024.09.03 21:29:58.817278 [ 3 ] {} <Trace> HTTP-Session: 8e2e42cc-a354-4fa8-a994-420d0ef263e0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 345 | 2024.09.03 21:29:58.817459 [ 3 ] {ea20b1e7-d6df-406d-87f3-9dcb495350d8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.817519 [ 3 ] {ea20b1e7-d6df-406d-87f3-9dcb495350d8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 347 | 2024.09.03 21:29:58.819299 [ 3 ] {ea20b1e7-d6df-406d-87f3-9dcb495350d8} <Debug> oximeter.measurements_i32 (5c3ecb35-3ce1-45ed-89ac-5ecff63426e4): Loading data parts | ||
| 348 | 2024.09.03 21:29:58.819461 [ 3 ] {ea20b1e7-d6df-406d-87f3-9dcb495350d8} <Debug> oximeter.measurements_i32 (5c3ecb35-3ce1-45ed-89ac-5ecff63426e4): There are no data parts | ||
| 349 | 2024.09.03 21:29:58.822161 [ 3 ] {ea20b1e7-d6df-406d-87f3-9dcb495350d8} <Debug> DynamicQueryHandler: Done processing query | ||
| 350 | 2024.09.03 21:29:58.822187 [ 3 ] {} <Debug> HTTP-Session: 8e2e42cc-a354-4fa8-a994-420d0ef263e0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 351 | 2024.09.03 21:29:58.822336 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 352 | 2024.09.03 21:29:58.822394 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 353 | 2024.09.03 21:29:58.822413 [ 3 ] {} <Debug> HTTP-Session: 885c73ba-7e62-4caf-818b-65fb5666c8d0 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 354 | 2024.09.03 21:29:58.822437 [ 3 ] {} <Debug> HTTP-Session: 885c73ba-7e62-4caf-818b-65fb5666c8d0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 355 | 2024.09.03 21:29:58.822458 [ 3 ] {} <Debug> HTTP-Session: 885c73ba-7e62-4caf-818b-65fb5666c8d0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 356 | 2024.09.03 21:29:58.822487 [ 3 ] {} <Trace> HTTP-Session: 885c73ba-7e62-4caf-818b-65fb5666c8d0 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 357 | 2024.09.03 21:29:58.822668 [ 3 ] {d617e141-91ca-4d3e-bfe7-bee0f0a4cd06} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.822730 [ 3 ] {d617e141-91ca-4d3e-bfe7-bee0f0a4cd06} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 359 | 2024.09.03 21:29:58.824619 [ 3 ] {d617e141-91ca-4d3e-bfe7-bee0f0a4cd06} <Debug> oximeter.measurements_u32 (03db6f68-ca66-461a-a678-d8d52e3a28ce): Loading data parts | ||
| 360 | 2024.09.03 21:29:58.824788 [ 3 ] {d617e141-91ca-4d3e-bfe7-bee0f0a4cd06} <Debug> oximeter.measurements_u32 (03db6f68-ca66-461a-a678-d8d52e3a28ce): There are no data parts | ||
| 361 | 2024.09.03 21:29:58.826313 [ 3 ] {d617e141-91ca-4d3e-bfe7-bee0f0a4cd06} <Debug> DynamicQueryHandler: Done processing query | ||
| 362 | 2024.09.03 21:29:58.826344 [ 3 ] {} <Debug> HTTP-Session: 885c73ba-7e62-4caf-818b-65fb5666c8d0 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 363 | 2024.09.03 21:29:58.826492 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 364 | 2024.09.03 21:29:58.826553 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 365 | 2024.09.03 21:29:58.826574 [ 3 ] {} <Debug> HTTP-Session: ddba6977-cfaf-47db-8644-db3fd913e607 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 366 | 2024.09.03 21:29:58.826600 [ 3 ] {} <Debug> HTTP-Session: ddba6977-cfaf-47db-8644-db3fd913e607 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 367 | 2024.09.03 21:29:58.826624 [ 3 ] {} <Debug> HTTP-Session: ddba6977-cfaf-47db-8644-db3fd913e607 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 368 | 2024.09.03 21:29:58.826657 [ 3 ] {} <Trace> HTTP-Session: ddba6977-cfaf-47db-8644-db3fd913e607 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 369 | 2024.09.03 21:29:58.826841 [ 3 ] {7bb8f0e1-ea4b-41b2-a658-8135caff9a13} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.826905 [ 3 ] {7bb8f0e1-ea4b-41b2-a658-8135caff9a13} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 371 | 2024.09.03 21:29:58.828900 [ 3 ] {7bb8f0e1-ea4b-41b2-a658-8135caff9a13} <Debug> oximeter.measurements_i64 (a0a927b5-dd0b-4f8e-be91-73e95daae546): Loading data parts | ||
| 372 | 2024.09.03 21:29:58.829078 [ 3 ] {7bb8f0e1-ea4b-41b2-a658-8135caff9a13} <Debug> oximeter.measurements_i64 (a0a927b5-dd0b-4f8e-be91-73e95daae546): There are no data parts | ||
| 373 | 2024.09.03 21:29:58.830305 [ 3 ] {7bb8f0e1-ea4b-41b2-a658-8135caff9a13} <Debug> DynamicQueryHandler: Done processing query | ||
| 374 | 2024.09.03 21:29:58.830330 [ 3 ] {} <Debug> HTTP-Session: ddba6977-cfaf-47db-8644-db3fd913e607 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 375 | 2024.09.03 21:29:58.830471 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 376 | 2024.09.03 21:29:58.830529 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 377 | 2024.09.03 21:29:58.830547 [ 3 ] {} <Debug> HTTP-Session: 431374c8-eb8b-4bdb-924b-835638fa13e4 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 378 | 2024.09.03 21:29:58.830579 [ 3 ] {} <Debug> HTTP-Session: 431374c8-eb8b-4bdb-924b-835638fa13e4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 379 | 2024.09.03 21:29:58.830611 [ 3 ] {} <Debug> HTTP-Session: 431374c8-eb8b-4bdb-924b-835638fa13e4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 380 | 2024.09.03 21:29:58.830652 [ 3 ] {} <Trace> HTTP-Session: 431374c8-eb8b-4bdb-924b-835638fa13e4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 381 | 2024.09.03 21:29:58.830845 [ 3 ] {44d64623-ed5b-41b5-8bed-4cb61b7b8ff8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.830909 [ 3 ] {44d64623-ed5b-41b5-8bed-4cb61b7b8ff8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 383 | 2024.09.03 21:29:58.834065 [ 3 ] {44d64623-ed5b-41b5-8bed-4cb61b7b8ff8} <Debug> oximeter.measurements_u64 (6bb173e9-d74c-42d7-aba5-770314c31e9b): Loading data parts | ||
| 384 | 2024.09.03 21:29:58.834233 [ 3 ] {44d64623-ed5b-41b5-8bed-4cb61b7b8ff8} <Debug> oximeter.measurements_u64 (6bb173e9-d74c-42d7-aba5-770314c31e9b): There are no data parts | ||
| 385 | 2024.09.03 21:29:58.836484 [ 3 ] {44d64623-ed5b-41b5-8bed-4cb61b7b8ff8} <Debug> DynamicQueryHandler: Done processing query | ||
| 386 | 2024.09.03 21:29:58.836510 [ 3 ] {} <Debug> HTTP-Session: 431374c8-eb8b-4bdb-924b-835638fa13e4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 387 | 2024.09.03 21:29:58.836655 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 388 | 2024.09.03 21:29:58.836714 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 389 | 2024.09.03 21:29:58.836734 [ 3 ] {} <Debug> HTTP-Session: 2943f496-50ef-4ca3-b2cb-873728e1f6c9 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 390 | 2024.09.03 21:29:58.836759 [ 3 ] {} <Debug> HTTP-Session: 2943f496-50ef-4ca3-b2cb-873728e1f6c9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 391 | 2024.09.03 21:29:58.836785 [ 3 ] {} <Debug> HTTP-Session: 2943f496-50ef-4ca3-b2cb-873728e1f6c9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 392 | 2024.09.03 21:29:58.836815 [ 3 ] {} <Trace> HTTP-Session: 2943f496-50ef-4ca3-b2cb-873728e1f6c9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 393 | 2024.09.03 21:29:58.837001 [ 3 ] {6f5af5df-a018-41c6-9048-4ed48b1a2f98} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.837062 [ 3 ] {6f5af5df-a018-41c6-9048-4ed48b1a2f98} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 395 | 2024.09.03 21:29:58.839046 [ 3 ] {6f5af5df-a018-41c6-9048-4ed48b1a2f98} <Debug> oximeter.measurements_f32 (3868b8a3-ee54-4736-8e65-d85b3a9c1197): Loading data parts | ||
| 396 | 2024.09.03 21:29:58.839219 [ 3 ] {6f5af5df-a018-41c6-9048-4ed48b1a2f98} <Debug> oximeter.measurements_f32 (3868b8a3-ee54-4736-8e65-d85b3a9c1197): There are no data parts | ||
| 397 | 2024.09.03 21:29:58.840445 [ 3 ] {6f5af5df-a018-41c6-9048-4ed48b1a2f98} <Debug> DynamicQueryHandler: Done processing query | ||
| 398 | 2024.09.03 21:29:58.840471 [ 3 ] {} <Debug> HTTP-Session: 2943f496-50ef-4ca3-b2cb-873728e1f6c9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 399 | 2024.09.03 21:29:58.840612 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 400 | 2024.09.03 21:29:58.840669 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 401 | 2024.09.03 21:29:58.840689 [ 3 ] {} <Debug> HTTP-Session: ad3c34cc-86a2-48c1-b2b4-815e87a3f63d Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 402 | 2024.09.03 21:29:58.840714 [ 3 ] {} <Debug> HTTP-Session: ad3c34cc-86a2-48c1-b2b4-815e87a3f63d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 403 | 2024.09.03 21:29:58.840734 [ 3 ] {} <Debug> HTTP-Session: ad3c34cc-86a2-48c1-b2b4-815e87a3f63d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 404 | 2024.09.03 21:29:58.840764 [ 3 ] {} <Trace> HTTP-Session: ad3c34cc-86a2-48c1-b2b4-815e87a3f63d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 405 | 2024.09.03 21:29:58.840944 [ 3 ] {554350f1-8f8d-40b9-84f8-79a15445b8dc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.841002 [ 3 ] {554350f1-8f8d-40b9-84f8-79a15445b8dc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 407 | 2024.09.03 21:29:58.842633 [ 3 ] {554350f1-8f8d-40b9-84f8-79a15445b8dc} <Debug> oximeter.measurements_f64 (856caddb-85cd-41d3-bad0-0422250d1bd5): Loading data parts | ||
| 408 | 2024.09.03 21:29:58.842810 [ 3 ] {554350f1-8f8d-40b9-84f8-79a15445b8dc} <Debug> oximeter.measurements_f64 (856caddb-85cd-41d3-bad0-0422250d1bd5): There are no data parts | ||
| 409 | 2024.09.03 21:29:58.845797 [ 3 ] {554350f1-8f8d-40b9-84f8-79a15445b8dc} <Debug> DynamicQueryHandler: Done processing query | ||
| 410 | 2024.09.03 21:29:58.845823 [ 3 ] {} <Debug> HTTP-Session: ad3c34cc-86a2-48c1-b2b4-815e87a3f63d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 411 | 2024.09.03 21:29:58.845970 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 412 | 2024.09.03 21:29:58.846029 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 413 | 2024.09.03 21:29:58.846056 [ 3 ] {} <Debug> HTTP-Session: 0e93a3cd-c66a-46bb-acee-33422a524ee2 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 414 | 2024.09.03 21:29:58.846074 [ 3 ] {} <Debug> HTTP-Session: 0e93a3cd-c66a-46bb-acee-33422a524ee2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 415 | 2024.09.03 21:29:58.846095 [ 3 ] {} <Debug> HTTP-Session: 0e93a3cd-c66a-46bb-acee-33422a524ee2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 416 | 2024.09.03 21:29:58.846133 [ 3 ] {} <Trace> HTTP-Session: 0e93a3cd-c66a-46bb-acee-33422a524ee2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 417 | 2024.09.03 21:29:58.846306 [ 3 ] {8426635e-605d-4e5d-b0df-e86c9db2d6dd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.846366 [ 3 ] {8426635e-605d-4e5d-b0df-e86c9db2d6dd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 419 | 2024.09.03 21:29:58.848811 [ 3 ] {8426635e-605d-4e5d-b0df-e86c9db2d6dd} <Debug> oximeter.measurements_string (6434d957-da52-4a0d-bdd3-548ca2afc970): Loading data parts | ||
| 420 | 2024.09.03 21:29:58.848960 [ 3 ] {8426635e-605d-4e5d-b0df-e86c9db2d6dd} <Debug> oximeter.measurements_string (6434d957-da52-4a0d-bdd3-548ca2afc970): There are no data parts | ||
| 421 | 2024.09.03 21:29:58.850722 [ 3 ] {8426635e-605d-4e5d-b0df-e86c9db2d6dd} <Debug> DynamicQueryHandler: Done processing query | ||
| 422 | 2024.09.03 21:29:58.850749 [ 3 ] {} <Debug> HTTP-Session: 0e93a3cd-c66a-46bb-acee-33422a524ee2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 423 | 2024.09.03 21:29:58.850893 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 424 | 2024.09.03 21:29:58.850949 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 425 | 2024.09.03 21:29:58.850975 [ 3 ] {} <Debug> HTTP-Session: 434c6958-073a-4241-b8dd-690f514b8e07 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 426 | 2024.09.03 21:29:58.850993 [ 3 ] {} <Debug> HTTP-Session: 434c6958-073a-4241-b8dd-690f514b8e07 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 427 | 2024.09.03 21:29:58.851013 [ 3 ] {} <Debug> HTTP-Session: 434c6958-073a-4241-b8dd-690f514b8e07 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 428 | 2024.09.03 21:29:58.851051 [ 3 ] {} <Trace> HTTP-Session: 434c6958-073a-4241-b8dd-690f514b8e07 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 429 | 2024.09.03 21:29:58.851240 [ 3 ] {19a1e20d-94ae-433a-beb8-3fd8405428ef} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.851298 [ 3 ] {19a1e20d-94ae-433a-beb8-3fd8405428ef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 438 | 2024.09.03 21:29:58.852865 [ 3 ] {19a1e20d-94ae-433a-beb8-3fd8405428ef} <Debug> oximeter.measurements_bytes (f3204069-3b30-4ce9-9189-2b16fcf63c60): Loading data parts | ||
| 439 | 2024.09.03 21:29:58.853026 [ 3 ] {19a1e20d-94ae-433a-beb8-3fd8405428ef} <Debug> oximeter.measurements_bytes (f3204069-3b30-4ce9-9189-2b16fcf63c60): There are no data parts | ||
| 440 | 2024.09.03 21:29:58.854753 [ 3 ] {19a1e20d-94ae-433a-beb8-3fd8405428ef} <Debug> DynamicQueryHandler: Done processing query | ||
| 441 | 2024.09.03 21:29:58.854787 [ 3 ] {} <Debug> HTTP-Session: 434c6958-073a-4241-b8dd-690f514b8e07 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 442 | 2024.09.03 21:29:58.854905 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 443 | 2024.09.03 21:29:58.854959 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 444 | 2024.09.03 21:29:58.854984 [ 3 ] {} <Debug> HTTP-Session: 45ff57f3-7fef-41de-bd99-f8bceb4d05e8 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 445 | 2024.09.03 21:29:58.855005 [ 3 ] {} <Debug> HTTP-Session: 45ff57f3-7fef-41de-bd99-f8bceb4d05e8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 446 | 2024.09.03 21:29:58.855020 [ 3 ] {} <Debug> HTTP-Session: 45ff57f3-7fef-41de-bd99-f8bceb4d05e8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 447 | 2024.09.03 21:29:58.855061 [ 3 ] {} <Trace> HTTP-Session: 45ff57f3-7fef-41de-bd99-f8bceb4d05e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 448 | 2024.09.03 21:29:58.855247 [ 3 ] {3058964c-92ce-48a1-bf7c-71dbfe9db1ec} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.855303 [ 3 ] {3058964c-92ce-48a1-bf7c-71dbfe9db1ec} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 450 | 2024.09.03 21:29:58.857571 [ 3 ] {3058964c-92ce-48a1-bf7c-71dbfe9db1ec} <Debug> oximeter.measurements_cumulativei64 (ec5091fa-48da-4447-a3c9-3d9ae64e5a55): Loading data parts | ||
| 451 | 2024.09.03 21:29:58.857727 [ 3 ] {3058964c-92ce-48a1-bf7c-71dbfe9db1ec} <Debug> oximeter.measurements_cumulativei64 (ec5091fa-48da-4447-a3c9-3d9ae64e5a55): There are no data parts | ||
| 452 | 2024.09.03 21:29:58.859323 [ 3 ] {3058964c-92ce-48a1-bf7c-71dbfe9db1ec} <Debug> DynamicQueryHandler: Done processing query | ||
| 453 | 2024.09.03 21:29:58.859348 [ 3 ] {} <Debug> HTTP-Session: 45ff57f3-7fef-41de-bd99-f8bceb4d05e8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 454 | 2024.09.03 21:29:58.859514 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 455 | 2024.09.03 21:29:58.859571 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 456 | 2024.09.03 21:29:58.859591 [ 3 ] {} <Debug> HTTP-Session: bd36ec50-1fc7-402d-8243-28890fab4e3a Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 457 | 2024.09.03 21:29:58.859614 [ 3 ] {} <Debug> HTTP-Session: bd36ec50-1fc7-402d-8243-28890fab4e3a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 458 | 2024.09.03 21:29:58.859632 [ 3 ] {} <Debug> HTTP-Session: bd36ec50-1fc7-402d-8243-28890fab4e3a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 459 | 2024.09.03 21:29:58.859662 [ 3 ] {} <Trace> HTTP-Session: bd36ec50-1fc7-402d-8243-28890fab4e3a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 460 | 2024.09.03 21:29:58.859849 [ 3 ] {ac466daf-c378-4df7-9548-8c627ce39eb5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.859909 [ 3 ] {ac466daf-c378-4df7-9548-8c627ce39eb5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 462 | 2024.09.03 21:29:58.861767 [ 3 ] {ac466daf-c378-4df7-9548-8c627ce39eb5} <Debug> oximeter.measurements_cumulativeu64 (aeb0d7f1-2fb3-42f6-a870-035c187a85df): Loading data parts | ||
| 463 | 2024.09.03 21:29:58.861933 [ 3 ] {ac466daf-c378-4df7-9548-8c627ce39eb5} <Debug> oximeter.measurements_cumulativeu64 (aeb0d7f1-2fb3-42f6-a870-035c187a85df): There are no data parts | ||
| 464 | 2024.09.03 21:29:58.863353 [ 3 ] {ac466daf-c378-4df7-9548-8c627ce39eb5} <Debug> DynamicQueryHandler: Done processing query | ||
| 465 | 2024.09.03 21:29:58.863385 [ 3 ] {} <Debug> HTTP-Session: bd36ec50-1fc7-402d-8243-28890fab4e3a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 466 | 2024.09.03 21:29:58.863514 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 467 | 2024.09.03 21:29:58.863569 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 468 | 2024.09.03 21:29:58.863594 [ 3 ] {} <Debug> HTTP-Session: 8644187f-cbb0-424c-8628-c4a6e1be75e1 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 469 | 2024.09.03 21:29:58.863612 [ 3 ] {} <Debug> HTTP-Session: 8644187f-cbb0-424c-8628-c4a6e1be75e1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 470 | 2024.09.03 21:29:58.863631 [ 3 ] {} <Debug> HTTP-Session: 8644187f-cbb0-424c-8628-c4a6e1be75e1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 471 | 2024.09.03 21:29:58.863665 [ 3 ] {} <Trace> HTTP-Session: 8644187f-cbb0-424c-8628-c4a6e1be75e1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 472 | 2024.09.03 21:29:58.863871 [ 3 ] {4a24b552-8baf-4c05-8b53-4a1a08a74842} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.863928 [ 3 ] {4a24b552-8baf-4c05-8b53-4a1a08a74842} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 474 | 2024.09.03 21:29:58.865745 [ 3 ] {4a24b552-8baf-4c05-8b53-4a1a08a74842} <Debug> oximeter.measurements_cumulativef32 (20035a2f-0d85-4c09-80c0-ea46142a157f): Loading data parts | ||
| 475 | 2024.09.03 21:29:58.865973 [ 3 ] {4a24b552-8baf-4c05-8b53-4a1a08a74842} <Debug> oximeter.measurements_cumulativef32 (20035a2f-0d85-4c09-80c0-ea46142a157f): There are no data parts | ||
| 476 | 2024.09.03 21:29:58.867400 [ 3 ] {4a24b552-8baf-4c05-8b53-4a1a08a74842} <Debug> DynamicQueryHandler: Done processing query | ||
| 477 | 2024.09.03 21:29:58.867433 [ 3 ] {} <Debug> HTTP-Session: 8644187f-cbb0-424c-8628-c4a6e1be75e1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 478 | 2024.09.03 21:29:58.867547 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 479 | 2024.09.03 21:29:58.867596 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 480 | 2024.09.03 21:29:58.867623 [ 3 ] {} <Debug> HTTP-Session: d41f0b6b-4a2e-4b8e-9f64-2cda15943c27 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 481 | 2024.09.03 21:29:58.867644 [ 3 ] {} <Debug> HTTP-Session: d41f0b6b-4a2e-4b8e-9f64-2cda15943c27 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 482 | 2024.09.03 21:29:58.867658 [ 3 ] {} <Debug> HTTP-Session: d41f0b6b-4a2e-4b8e-9f64-2cda15943c27 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 483 | 2024.09.03 21:29:58.867694 [ 3 ] {} <Trace> HTTP-Session: d41f0b6b-4a2e-4b8e-9f64-2cda15943c27 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 484 | 2024.09.03 21:29:58.867884 [ 3 ] {9e85d4ee-dce0-440a-84cc-438740162f3a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.867948 [ 3 ] {9e85d4ee-dce0-440a-84cc-438740162f3a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 486 | 2024.09.03 21:29:58.869583 [ 3 ] {9e85d4ee-dce0-440a-84cc-438740162f3a} <Debug> oximeter.measurements_cumulativef64 (2087bf48-ba42-4755-8ce2-2aa9b7950ca6): Loading data parts | ||
| 487 | 2024.09.03 21:29:58.869774 [ 3 ] {9e85d4ee-dce0-440a-84cc-438740162f3a} <Debug> oximeter.measurements_cumulativef64 (2087bf48-ba42-4755-8ce2-2aa9b7950ca6): There are no data parts | ||
| 488 | 2024.09.03 21:29:58.871167 [ 3 ] {9e85d4ee-dce0-440a-84cc-438740162f3a} <Debug> DynamicQueryHandler: Done processing query | ||
| 489 | 2024.09.03 21:29:58.871194 [ 3 ] {} <Debug> HTTP-Session: d41f0b6b-4a2e-4b8e-9f64-2cda15943c27 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 490 | 2024.09.03 21:29:58.871388 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 491 | 2024.09.03 21:29:58.871454 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 492 | 2024.09.03 21:29:58.871475 [ 3 ] {} <Debug> HTTP-Session: 211e22c1-62c5-4716-92f2-0ed731abb684 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 493 | 2024.09.03 21:29:58.871503 [ 3 ] {} <Debug> HTTP-Session: 211e22c1-62c5-4716-92f2-0ed731abb684 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 494 | 2024.09.03 21:29:58.871527 [ 3 ] {} <Debug> HTTP-Session: 211e22c1-62c5-4716-92f2-0ed731abb684 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 495 | 2024.09.03 21:29:58.871558 [ 3 ] {} <Trace> HTTP-Session: 211e22c1-62c5-4716-92f2-0ed731abb684 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 496 | 2024.09.03 21:29:58.871831 [ 3 ] {38933cc5-2d25-4bef-b56a-e8dfbd065270} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.871906 [ 3 ] {38933cc5-2d25-4bef-b56a-e8dfbd065270} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 508 | 2024.09.03 21:29:58.875457 [ 3 ] {38933cc5-2d25-4bef-b56a-e8dfbd065270} <Debug> oximeter.measurements_histogrami8 (e5caeaef-4884-495b-ae92-7cee1310b118): Loading data parts | ||
| 509 | 2024.09.03 21:29:58.875639 [ 3 ] {38933cc5-2d25-4bef-b56a-e8dfbd065270} <Debug> oximeter.measurements_histogrami8 (e5caeaef-4884-495b-ae92-7cee1310b118): There are no data parts | ||
| 510 | 2024.09.03 21:29:58.877987 [ 3 ] {38933cc5-2d25-4bef-b56a-e8dfbd065270} <Debug> DynamicQueryHandler: Done processing query | ||
| 511 | 2024.09.03 21:29:58.878014 [ 3 ] {} <Debug> HTTP-Session: 211e22c1-62c5-4716-92f2-0ed731abb684 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 512 | 2024.09.03 21:29:58.878185 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 513 | 2024.09.03 21:29:58.878246 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 514 | 2024.09.03 21:29:58.878268 [ 3 ] {} <Debug> HTTP-Session: b55fad9e-1091-4a7d-88e4-e452a4396997 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 515 | 2024.09.03 21:29:58.878294 [ 3 ] {} <Debug> HTTP-Session: b55fad9e-1091-4a7d-88e4-e452a4396997 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 516 | 2024.09.03 21:29:58.878331 [ 3 ] {} <Debug> HTTP-Session: b55fad9e-1091-4a7d-88e4-e452a4396997 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 517 | 2024.09.03 21:29:58.878379 [ 3 ] {} <Trace> HTTP-Session: b55fad9e-1091-4a7d-88e4-e452a4396997 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 518 | 2024.09.03 21:29:58.878648 [ 3 ] {ea91f33e-dcc7-494f-bdf7-78aeba7436c4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.878728 [ 3 ] {ea91f33e-dcc7-494f-bdf7-78aeba7436c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 520 | 2024.09.03 21:29:58.880838 [ 3 ] {ea91f33e-dcc7-494f-bdf7-78aeba7436c4} <Debug> oximeter.measurements_histogramu8 (b6c00854-b922-41cd-adec-7d941b3bac93): Loading data parts | ||
| 521 | 2024.09.03 21:29:58.881013 [ 3 ] {ea91f33e-dcc7-494f-bdf7-78aeba7436c4} <Debug> oximeter.measurements_histogramu8 (b6c00854-b922-41cd-adec-7d941b3bac93): There are no data parts | ||
| 522 | 2024.09.03 21:29:58.882531 [ 3 ] {ea91f33e-dcc7-494f-bdf7-78aeba7436c4} <Debug> DynamicQueryHandler: Done processing query | ||
| 523 | 2024.09.03 21:29:58.882558 [ 3 ] {} <Debug> HTTP-Session: b55fad9e-1091-4a7d-88e4-e452a4396997 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 524 | 2024.09.03 21:29:58.882710 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 525 | 2024.09.03 21:29:58.882771 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 526 | 2024.09.03 21:29:58.882793 [ 3 ] {} <Debug> HTTP-Session: e8da6338-60e5-4a4a-9e70-d0897fbfe855 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 527 | 2024.09.03 21:29:58.882820 [ 3 ] {} <Debug> HTTP-Session: e8da6338-60e5-4a4a-9e70-d0897fbfe855 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 528 | 2024.09.03 21:29:58.882844 [ 3 ] {} <Debug> HTTP-Session: e8da6338-60e5-4a4a-9e70-d0897fbfe855 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 529 | 2024.09.03 21:29:58.882874 [ 3 ] {} <Trace> HTTP-Session: e8da6338-60e5-4a4a-9e70-d0897fbfe855 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 530 | 2024.09.03 21:29:58.883136 [ 3 ] {7e3cb6dd-321a-47a0-8d57-9da0207d2ea0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.883215 [ 3 ] {7e3cb6dd-321a-47a0-8d57-9da0207d2ea0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 532 | 2024.09.03 21:29:58.886872 [ 3 ] {7e3cb6dd-321a-47a0-8d57-9da0207d2ea0} <Debug> oximeter.measurements_histogrami16 (2ebd3fe4-e4d7-4cf6-94fb-184023de3d0d): Loading data parts | ||
| 533 | 2024.09.03 21:29:58.887040 [ 3 ] {7e3cb6dd-321a-47a0-8d57-9da0207d2ea0} <Debug> oximeter.measurements_histogrami16 (2ebd3fe4-e4d7-4cf6-94fb-184023de3d0d): There are no data parts | ||
| 534 | 2024.09.03 21:29:58.889412 [ 3 ] {7e3cb6dd-321a-47a0-8d57-9da0207d2ea0} <Debug> DynamicQueryHandler: Done processing query | ||
| 535 | 2024.09.03 21:29:58.889438 [ 3 ] {} <Debug> HTTP-Session: e8da6338-60e5-4a4a-9e70-d0897fbfe855 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 536 | 2024.09.03 21:29:58.889585 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 537 | 2024.09.03 21:29:58.889646 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 538 | 2024.09.03 21:29:58.889676 [ 3 ] {} <Debug> HTTP-Session: a2ad2259-d458-4a34-a6f8-0734a312c3bc Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 539 | 2024.09.03 21:29:58.889693 [ 3 ] {} <Debug> HTTP-Session: a2ad2259-d458-4a34-a6f8-0734a312c3bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 540 | 2024.09.03 21:29:58.889718 [ 3 ] {} <Debug> HTTP-Session: a2ad2259-d458-4a34-a6f8-0734a312c3bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 541 | 2024.09.03 21:29:58.889748 [ 3 ] {} <Trace> HTTP-Session: a2ad2259-d458-4a34-a6f8-0734a312c3bc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 542 | 2024.09.03 21:29:58.890005 [ 3 ] {42daedac-4964-4607-ade0-1a2159e31443} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.890081 [ 3 ] {42daedac-4964-4607-ade0-1a2159e31443} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 544 | 2024.09.03 21:29:58.891978 [ 3 ] {42daedac-4964-4607-ade0-1a2159e31443} <Debug> oximeter.measurements_histogramu16 (7a5887a8-7fa1-4b28-a208-e4bd829976d6): Loading data parts | ||
| 545 | 2024.09.03 21:29:58.892162 [ 3 ] {42daedac-4964-4607-ade0-1a2159e31443} <Debug> oximeter.measurements_histogramu16 (7a5887a8-7fa1-4b28-a208-e4bd829976d6): There are no data parts | ||
| 546 | 2024.09.03 21:29:58.894492 [ 3 ] {42daedac-4964-4607-ade0-1a2159e31443} <Debug> DynamicQueryHandler: Done processing query | ||
| 547 | 2024.09.03 21:29:58.894519 [ 3 ] {} <Debug> HTTP-Session: a2ad2259-d458-4a34-a6f8-0734a312c3bc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 548 | 2024.09.03 21:29:58.894653 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 549 | 2024.09.03 21:29:58.894707 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 550 | 2024.09.03 21:29:58.894728 [ 3 ] {} <Debug> HTTP-Session: 19b0d199-e0c8-4656-bdb1-a25152a333c8 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 551 | 2024.09.03 21:29:58.894751 [ 3 ] {} <Debug> HTTP-Session: 19b0d199-e0c8-4656-bdb1-a25152a333c8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 552 | 2024.09.03 21:29:58.894771 [ 3 ] {} <Debug> HTTP-Session: 19b0d199-e0c8-4656-bdb1-a25152a333c8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 553 | 2024.09.03 21:29:58.894805 [ 3 ] {} <Trace> HTTP-Session: 19b0d199-e0c8-4656-bdb1-a25152a333c8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 554 | 2024.09.03 21:29:58.895058 [ 3 ] {3a9babc1-8121-42c8-88f9-17d36b1941c2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.895124 [ 3 ] {3a9babc1-8121-42c8-88f9-17d36b1941c2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 556 | 2024.09.03 21:29:58.897037 [ 3 ] {3a9babc1-8121-42c8-88f9-17d36b1941c2} <Debug> oximeter.measurements_histogrami32 (57077185-140e-4067-8ffb-6261c26607f7): Loading data parts | ||
| 557 | 2024.09.03 21:29:58.897206 [ 3 ] {3a9babc1-8121-42c8-88f9-17d36b1941c2} <Debug> oximeter.measurements_histogrami32 (57077185-140e-4067-8ffb-6261c26607f7): There are no data parts | ||
| 558 | 2024.09.03 21:29:58.900163 [ 3 ] {3a9babc1-8121-42c8-88f9-17d36b1941c2} <Debug> DynamicQueryHandler: Done processing query | ||
| 559 | 2024.09.03 21:29:58.900189 [ 3 ] {} <Debug> HTTP-Session: 19b0d199-e0c8-4656-bdb1-a25152a333c8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 560 | 2024.09.03 21:29:58.900340 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 561 | 2024.09.03 21:29:58.900397 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 562 | 2024.09.03 21:29:58.900422 [ 3 ] {} <Debug> HTTP-Session: c44fb497-97a5-46c9-bd0c-b0a9744babbb Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 563 | 2024.09.03 21:29:58.900440 [ 3 ] {} <Debug> HTTP-Session: c44fb497-97a5-46c9-bd0c-b0a9744babbb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 564 | 2024.09.03 21:29:58.900466 [ 3 ] {} <Debug> HTTP-Session: c44fb497-97a5-46c9-bd0c-b0a9744babbb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 565 | 2024.09.03 21:29:58.900501 [ 3 ] {} <Trace> HTTP-Session: c44fb497-97a5-46c9-bd0c-b0a9744babbb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 566 | 2024.09.03 21:29:58.900747 [ 3 ] {220062a1-57d7-42d0-8095-24321d544a0b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.900819 [ 3 ] {220062a1-57d7-42d0-8095-24321d544a0b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 568 | 2024.09.03 21:29:58.902985 [ 3 ] {220062a1-57d7-42d0-8095-24321d544a0b} <Debug> oximeter.measurements_histogramu32 (0fbcda72-cf55-4e32-8738-fcea3079e1e5): Loading data parts | ||
| 569 | 2024.09.03 21:29:58.903152 [ 3 ] {220062a1-57d7-42d0-8095-24321d544a0b} <Debug> oximeter.measurements_histogramu32 (0fbcda72-cf55-4e32-8738-fcea3079e1e5): There are no data parts | ||
| 570 | 2024.09.03 21:29:58.904634 [ 3 ] {220062a1-57d7-42d0-8095-24321d544a0b} <Debug> DynamicQueryHandler: Done processing query | ||
| 571 | 2024.09.03 21:29:58.904661 [ 3 ] {} <Debug> HTTP-Session: c44fb497-97a5-46c9-bd0c-b0a9744babbb Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 572 | 2024.09.03 21:29:58.904807 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 573 | 2024.09.03 21:29:58.904861 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 574 | 2024.09.03 21:29:58.904887 [ 3 ] {} <Debug> HTTP-Session: 154a77f2-45dc-4f29-9e29-0b8ec430ca80 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 575 | 2024.09.03 21:29:58.904904 [ 3 ] {} <Debug> HTTP-Session: 154a77f2-45dc-4f29-9e29-0b8ec430ca80 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 576 | 2024.09.03 21:29:58.904924 [ 3 ] {} <Debug> HTTP-Session: 154a77f2-45dc-4f29-9e29-0b8ec430ca80 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 577 | 2024.09.03 21:29:58.904961 [ 3 ] {} <Trace> HTTP-Session: 154a77f2-45dc-4f29-9e29-0b8ec430ca80 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 578 | 2024.09.03 21:29:58.905215 [ 3 ] {7dfb6de8-1da4-45b9-9a33-1ff9a3b91f6b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.905283 [ 3 ] {7dfb6de8-1da4-45b9-9a33-1ff9a3b91f6b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 580 | 2024.09.03 21:29:58.907341 [ 3 ] {7dfb6de8-1da4-45b9-9a33-1ff9a3b91f6b} <Debug> oximeter.measurements_histogrami64 (e4a4403f-7508-46f9-959e-e5db55218df9): Loading data parts | ||
| 581 | 2024.09.03 21:29:58.907510 [ 3 ] {7dfb6de8-1da4-45b9-9a33-1ff9a3b91f6b} <Debug> oximeter.measurements_histogrami64 (e4a4403f-7508-46f9-959e-e5db55218df9): There are no data parts | ||
| 582 | 2024.09.03 21:29:58.909031 [ 3 ] {7dfb6de8-1da4-45b9-9a33-1ff9a3b91f6b} <Debug> DynamicQueryHandler: Done processing query | ||
| 583 | 2024.09.03 21:29:58.909065 [ 3 ] {} <Debug> HTTP-Session: 154a77f2-45dc-4f29-9e29-0b8ec430ca80 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 584 | 2024.09.03 21:29:58.909197 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 585 | 2024.09.03 21:29:58.909253 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 586 | 2024.09.03 21:29:58.909280 [ 3 ] {} <Debug> HTTP-Session: 92816dac-cb77-41d1-bd4a-8d7d6e20f30c Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 587 | 2024.09.03 21:29:58.909299 [ 3 ] {} <Debug> HTTP-Session: 92816dac-cb77-41d1-bd4a-8d7d6e20f30c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 588 | 2024.09.03 21:29:58.909320 [ 3 ] {} <Debug> HTTP-Session: 92816dac-cb77-41d1-bd4a-8d7d6e20f30c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 589 | 2024.09.03 21:29:58.909356 [ 3 ] {} <Trace> HTTP-Session: 92816dac-cb77-41d1-bd4a-8d7d6e20f30c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 590 | 2024.09.03 21:29:58.909602 [ 3 ] {c2db34df-b2f2-461e-bb62-227c87a15375} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.909669 [ 3 ] {c2db34df-b2f2-461e-bb62-227c87a15375} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 592 | 2024.09.03 21:29:58.911521 [ 3 ] {c2db34df-b2f2-461e-bb62-227c87a15375} <Debug> oximeter.measurements_histogramu64 (51dc7c6a-fe48-44c3-a09d-aa442a943d8b): Loading data parts | ||
| 593 | 2024.09.03 21:29:58.911693 [ 3 ] {c2db34df-b2f2-461e-bb62-227c87a15375} <Debug> oximeter.measurements_histogramu64 (51dc7c6a-fe48-44c3-a09d-aa442a943d8b): There are no data parts | ||
| 594 | 2024.09.03 21:29:58.913976 [ 3 ] {c2db34df-b2f2-461e-bb62-227c87a15375} <Debug> DynamicQueryHandler: Done processing query | ||
| 595 | 2024.09.03 21:29:58.914012 [ 3 ] {} <Debug> HTTP-Session: 92816dac-cb77-41d1-bd4a-8d7d6e20f30c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 596 | 2024.09.03 21:29:58.914152 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 597 | 2024.09.03 21:29:58.914209 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 598 | 2024.09.03 21:29:58.914236 [ 3 ] {} <Debug> HTTP-Session: fbf8ccfb-8ab1-49c2-99bb-83cf06f433c7 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 599 | 2024.09.03 21:29:58.914253 [ 3 ] {} <Debug> HTTP-Session: fbf8ccfb-8ab1-49c2-99bb-83cf06f433c7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 600 | 2024.09.03 21:29:58.914275 [ 3 ] {} <Debug> HTTP-Session: fbf8ccfb-8ab1-49c2-99bb-83cf06f433c7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 601 | 2024.09.03 21:29:58.914314 [ 3 ] {} <Trace> HTTP-Session: fbf8ccfb-8ab1-49c2-99bb-83cf06f433c7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 602 | 2024.09.03 21:29:58.914571 [ 3 ] {db2ecc88-3f6d-4e17-8923-8fab750b1fc5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.914640 [ 3 ] {db2ecc88-3f6d-4e17-8923-8fab750b1fc5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 604 | 2024.09.03 21:29:58.917142 [ 3 ] {db2ecc88-3f6d-4e17-8923-8fab750b1fc5} <Debug> oximeter.measurements_histogramf32 (ae296078-1974-4706-a4f5-5194973acacf): Loading data parts | ||
| 605 | 2024.09.03 21:29:58.917305 [ 3 ] {db2ecc88-3f6d-4e17-8923-8fab750b1fc5} <Debug> oximeter.measurements_histogramf32 (ae296078-1974-4706-a4f5-5194973acacf): There are no data parts | ||
| 606 | 2024.09.03 21:29:58.919531 [ 3 ] {db2ecc88-3f6d-4e17-8923-8fab750b1fc5} <Debug> DynamicQueryHandler: Done processing query | ||
| 607 | 2024.09.03 21:29:58.919565 [ 3 ] {} <Debug> HTTP-Session: fbf8ccfb-8ab1-49c2-99bb-83cf06f433c7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 608 | 2024.09.03 21:29:58.919704 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 609 | 2024.09.03 21:29:58.919760 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 610 | 2024.09.03 21:29:58.919785 [ 3 ] {} <Debug> HTTP-Session: 6eaeaa59-e470-4b29-83f7-ce0d0e9abcc8 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 611 | 2024.09.03 21:29:58.919803 [ 3 ] {} <Debug> HTTP-Session: 6eaeaa59-e470-4b29-83f7-ce0d0e9abcc8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 612 | 2024.09.03 21:29:58.919826 [ 3 ] {} <Debug> HTTP-Session: 6eaeaa59-e470-4b29-83f7-ce0d0e9abcc8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 613 | 2024.09.03 21:29:58.919862 [ 3 ] {} <Trace> HTTP-Session: 6eaeaa59-e470-4b29-83f7-ce0d0e9abcc8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 614 | 2024.09.03 21:29:58.920115 [ 3 ] {dd42cb46-7dd2-4d4b-aac1-f09e45bb4d34} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.920180 [ 3 ] {dd42cb46-7dd2-4d4b-aac1-f09e45bb4d34} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 616 | 2024.09.03 21:29:58.922444 [ 3 ] {dd42cb46-7dd2-4d4b-aac1-f09e45bb4d34} <Debug> oximeter.measurements_histogramf64 (893aa64f-76e4-4036-a1a1-c025e5ffbf7d): Loading data parts | ||
| 617 | 2024.09.03 21:29:58.922620 [ 3 ] {dd42cb46-7dd2-4d4b-aac1-f09e45bb4d34} <Debug> oximeter.measurements_histogramf64 (893aa64f-76e4-4036-a1a1-c025e5ffbf7d): There are no data parts | ||
| 618 | 2024.09.03 21:29:58.923894 [ 3 ] {dd42cb46-7dd2-4d4b-aac1-f09e45bb4d34} <Debug> DynamicQueryHandler: Done processing query | ||
| 619 | 2024.09.03 21:29:58.923929 [ 3 ] {} <Debug> HTTP-Session: 6eaeaa59-e470-4b29-83f7-ce0d0e9abcc8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 620 | 2024.09.03 21:29:58.924072 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 621 | 2024.09.03 21:29:58.924130 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 622 | 2024.09.03 21:29:58.924157 [ 3 ] {} <Debug> HTTP-Session: dda00b72-e691-4b3b-b565-1eb7aa3f1de9 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 623 | 2024.09.03 21:29:58.924179 [ 3 ] {} <Debug> HTTP-Session: dda00b72-e691-4b3b-b565-1eb7aa3f1de9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 624 | 2024.09.03 21:29:58.924194 [ 3 ] {} <Debug> HTTP-Session: dda00b72-e691-4b3b-b565-1eb7aa3f1de9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 625 | 2024.09.03 21:29:58.924232 [ 3 ] {} <Trace> HTTP-Session: dda00b72-e691-4b3b-b565-1eb7aa3f1de9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 626 | 2024.09.03 21:29:58.924419 [ 3 ] {ea7d33d4-da54-470f-b985-b862c7c00af3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) /* 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.03 21:29:58.924486 [ 3 ] {ea7d33d4-da54-470f-b985-b862c7c00af3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 653 | 2024.09.03 21:29:58.926530 [ 3 ] {ea7d33d4-da54-470f-b985-b862c7c00af3} <Debug> oximeter.fields_bool (e920a888-5fde-4e94-9fdf-e7d9b7191533): Loading data parts | ||
| 654 | 2024.09.03 21:29:58.926702 [ 3 ] {ea7d33d4-da54-470f-b985-b862c7c00af3} <Debug> oximeter.fields_bool (e920a888-5fde-4e94-9fdf-e7d9b7191533): There are no data parts | ||
| 655 | 2024.09.03 21:29:58.928189 [ 3 ] {ea7d33d4-da54-470f-b985-b862c7c00af3} <Debug> DynamicQueryHandler: Done processing query | ||
| 656 | 2024.09.03 21:29:58.928223 [ 3 ] {} <Debug> HTTP-Session: dda00b72-e691-4b3b-b565-1eb7aa3f1de9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 657 | 2024.09.03 21:29:58.928358 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 658 | 2024.09.03 21:29:58.928413 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 659 | 2024.09.03 21:29:58.928439 [ 3 ] {} <Debug> HTTP-Session: 42250822-90ea-4b5c-a9f8-d03576d3f1cc Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 660 | 2024.09.03 21:29:58.928456 [ 3 ] {} <Debug> HTTP-Session: 42250822-90ea-4b5c-a9f8-d03576d3f1cc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 661 | 2024.09.03 21:29:58.928479 [ 3 ] {} <Debug> HTTP-Session: 42250822-90ea-4b5c-a9f8-d03576d3f1cc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 662 | 2024.09.03 21:29:58.928515 [ 3 ] {} <Trace> HTTP-Session: 42250822-90ea-4b5c-a9f8-d03576d3f1cc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 663 | 2024.09.03 21:29:58.928698 [ 3 ] {720ae698-4d51-4a07-900c-15cc965c407b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.928765 [ 3 ] {720ae698-4d51-4a07-900c-15cc965c407b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 665 | 2024.09.03 21:29:58.932394 [ 3 ] {720ae698-4d51-4a07-900c-15cc965c407b} <Debug> oximeter.fields_i8 (53551d9b-0b2b-4006-8c6a-6cc2a42a0354): Loading data parts | ||
| 666 | 2024.09.03 21:29:58.932558 [ 3 ] {720ae698-4d51-4a07-900c-15cc965c407b} <Debug> oximeter.fields_i8 (53551d9b-0b2b-4006-8c6a-6cc2a42a0354): There are no data parts | ||
| 667 | 2024.09.03 21:29:58.934492 [ 3 ] {720ae698-4d51-4a07-900c-15cc965c407b} <Debug> DynamicQueryHandler: Done processing query | ||
| 668 | 2024.09.03 21:29:58.934535 [ 3 ] {} <Debug> HTTP-Session: 42250822-90ea-4b5c-a9f8-d03576d3f1cc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 669 | 2024.09.03 21:29:58.934671 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 670 | 2024.09.03 21:29:58.934734 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 671 | 2024.09.03 21:29:58.934769 [ 3 ] {} <Debug> HTTP-Session: 0ae688b7-5736-4156-a14f-b9dc8e20ab7d Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 672 | 2024.09.03 21:29:58.934797 [ 3 ] {} <Debug> HTTP-Session: 0ae688b7-5736-4156-a14f-b9dc8e20ab7d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 673 | 2024.09.03 21:29:58.934811 [ 3 ] {} <Debug> HTTP-Session: 0ae688b7-5736-4156-a14f-b9dc8e20ab7d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 674 | 2024.09.03 21:29:58.934853 [ 3 ] {} <Trace> HTTP-Session: 0ae688b7-5736-4156-a14f-b9dc8e20ab7d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 675 | 2024.09.03 21:29:58.935042 [ 3 ] {96490055-20e2-455e-a50e-c92fff173834} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.935110 [ 3 ] {96490055-20e2-455e-a50e-c92fff173834} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 677 | 2024.09.03 21:29:58.937744 [ 3 ] {96490055-20e2-455e-a50e-c92fff173834} <Debug> oximeter.fields_u8 (89eb79ca-54f4-4ddf-a3e8-37e98c5db3d4): Loading data parts | ||
| 678 | 2024.09.03 21:29:58.937906 [ 3 ] {96490055-20e2-455e-a50e-c92fff173834} <Debug> oximeter.fields_u8 (89eb79ca-54f4-4ddf-a3e8-37e98c5db3d4): There are no data parts | ||
| 679 | 2024.09.03 21:29:58.941134 [ 3 ] {96490055-20e2-455e-a50e-c92fff173834} <Debug> DynamicQueryHandler: Done processing query | ||
| 680 | 2024.09.03 21:29:58.941179 [ 3 ] {} <Debug> HTTP-Session: 0ae688b7-5736-4156-a14f-b9dc8e20ab7d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 681 | 2024.09.03 21:29:58.941322 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 682 | 2024.09.03 21:29:58.941394 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 683 | 2024.09.03 21:29:58.941433 [ 3 ] {} <Debug> HTTP-Session: 0ee984a4-87a3-4f5e-b73f-f3772ac20bab Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 684 | 2024.09.03 21:29:58.941468 [ 3 ] {} <Debug> HTTP-Session: 0ee984a4-87a3-4f5e-b73f-f3772ac20bab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 685 | 2024.09.03 21:29:58.941485 [ 3 ] {} <Debug> HTTP-Session: 0ee984a4-87a3-4f5e-b73f-f3772ac20bab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 686 | 2024.09.03 21:29:58.941539 [ 3 ] {} <Trace> HTTP-Session: 0ee984a4-87a3-4f5e-b73f-f3772ac20bab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 687 | 2024.09.03 21:29:58.941769 [ 3 ] {7f27c2c5-50b2-4837-8f67-4e84afddd49d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.941849 [ 3 ] {7f27c2c5-50b2-4837-8f67-4e84afddd49d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 689 | 2024.09.03 21:29:58.943687 [ 3 ] {7f27c2c5-50b2-4837-8f67-4e84afddd49d} <Debug> oximeter.fields_i16 (6bcfa69d-9c31-4481-b7bb-52363b166f69): Loading data parts | ||
| 690 | 2024.09.03 21:29:58.943885 [ 3 ] {7f27c2c5-50b2-4837-8f67-4e84afddd49d} <Debug> oximeter.fields_i16 (6bcfa69d-9c31-4481-b7bb-52363b166f69): There are no data parts | ||
| 691 | 2024.09.03 21:29:58.945052 [ 3 ] {7f27c2c5-50b2-4837-8f67-4e84afddd49d} <Debug> DynamicQueryHandler: Done processing query | ||
| 692 | 2024.09.03 21:29:58.945093 [ 3 ] {} <Debug> HTTP-Session: 0ee984a4-87a3-4f5e-b73f-f3772ac20bab Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 693 | 2024.09.03 21:29:58.945248 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 694 | 2024.09.03 21:29:58.945296 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 695 | 2024.09.03 21:29:58.945330 [ 3 ] {} <Debug> HTTP-Session: 646a63df-dff9-4f34-b79c-9028e89bf29f Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 696 | 2024.09.03 21:29:58.945359 [ 3 ] {} <Debug> HTTP-Session: 646a63df-dff9-4f34-b79c-9028e89bf29f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 697 | 2024.09.03 21:29:58.945373 [ 3 ] {} <Debug> HTTP-Session: 646a63df-dff9-4f34-b79c-9028e89bf29f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 698 | 2024.09.03 21:29:58.945417 [ 3 ] {} <Trace> HTTP-Session: 646a63df-dff9-4f34-b79c-9028e89bf29f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 699 | 2024.09.03 21:29:58.945606 [ 3 ] {d55d4f89-46e4-4595-833e-941886b48986} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.945676 [ 3 ] {d55d4f89-46e4-4595-833e-941886b48986} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 701 | 2024.09.03 21:29:58.947500 [ 3 ] {d55d4f89-46e4-4595-833e-941886b48986} <Debug> oximeter.fields_u16 (26cd7520-81f3-4f2e-a942-24284221d40b): Loading data parts | ||
| 702 | 2024.09.03 21:29:58.947679 [ 3 ] {d55d4f89-46e4-4595-833e-941886b48986} <Debug> oximeter.fields_u16 (26cd7520-81f3-4f2e-a942-24284221d40b): There are no data parts | ||
| 703 | 2024.09.03 21:29:58.948947 [ 3 ] {d55d4f89-46e4-4595-833e-941886b48986} <Debug> DynamicQueryHandler: Done processing query | ||
| 704 | 2024.09.03 21:29:58.948972 [ 3 ] {} <Debug> HTTP-Session: 646a63df-dff9-4f34-b79c-9028e89bf29f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 705 | 2024.09.03 21:29:58.949104 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 706 | 2024.09.03 21:29:58.949166 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 707 | 2024.09.03 21:29:58.949186 [ 3 ] {} <Debug> HTTP-Session: 2fd07ae3-1e90-4d83-9a41-4978c129b460 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 708 | 2024.09.03 21:29:58.949216 [ 3 ] {} <Debug> HTTP-Session: 2fd07ae3-1e90-4d83-9a41-4978c129b460 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 709 | 2024.09.03 21:29:58.949242 [ 3 ] {} <Debug> HTTP-Session: 2fd07ae3-1e90-4d83-9a41-4978c129b460 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 710 | 2024.09.03 21:29:58.949272 [ 3 ] {} <Trace> HTTP-Session: 2fd07ae3-1e90-4d83-9a41-4978c129b460 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 711 | 2024.09.03 21:29:58.949457 [ 3 ] {6828aa3a-610c-4ff8-a60a-f63ccdba3e1d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.949517 [ 3 ] {6828aa3a-610c-4ff8-a60a-f63ccdba3e1d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 713 | 2024.09.03 21:29:58.951382 [ 3 ] {6828aa3a-610c-4ff8-a60a-f63ccdba3e1d} <Debug> oximeter.fields_i32 (aef120bc-5daa-4157-b98f-fd92fa880039): Loading data parts | ||
| 714 | 2024.09.03 21:29:58.951542 [ 3 ] {6828aa3a-610c-4ff8-a60a-f63ccdba3e1d} <Debug> oximeter.fields_i32 (aef120bc-5daa-4157-b98f-fd92fa880039): There are no data parts | ||
| 715 | 2024.09.03 21:29:58.952922 [ 3 ] {6828aa3a-610c-4ff8-a60a-f63ccdba3e1d} <Debug> DynamicQueryHandler: Done processing query | ||
| 716 | 2024.09.03 21:29:58.952949 [ 3 ] {} <Debug> HTTP-Session: 2fd07ae3-1e90-4d83-9a41-4978c129b460 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 717 | 2024.09.03 21:29:58.953079 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 718 | 2024.09.03 21:29:58.953137 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 719 | 2024.09.03 21:29:58.953156 [ 3 ] {} <Debug> HTTP-Session: 54932e0e-9585-401d-8c53-24ff451071a1 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 720 | 2024.09.03 21:29:58.953180 [ 3 ] {} <Debug> HTTP-Session: 54932e0e-9585-401d-8c53-24ff451071a1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 721 | 2024.09.03 21:29:58.953205 [ 3 ] {} <Debug> HTTP-Session: 54932e0e-9585-401d-8c53-24ff451071a1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 722 | 2024.09.03 21:29:58.953235 [ 3 ] {} <Trace> HTTP-Session: 54932e0e-9585-401d-8c53-24ff451071a1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 723 | 2024.09.03 21:29:58.953417 [ 3 ] {8cd144d1-162e-4519-b67e-1dd0f6e178f1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.953481 [ 3 ] {8cd144d1-162e-4519-b67e-1dd0f6e178f1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 725 | 2024.09.03 21:29:58.955382 [ 3 ] {8cd144d1-162e-4519-b67e-1dd0f6e178f1} <Debug> oximeter.fields_u32 (10cb4f92-099f-4ff1-806e-d54e5270a029): Loading data parts | ||
| 726 | 2024.09.03 21:29:58.955542 [ 3 ] {8cd144d1-162e-4519-b67e-1dd0f6e178f1} <Debug> oximeter.fields_u32 (10cb4f92-099f-4ff1-806e-d54e5270a029): There are no data parts | ||
| 727 | 2024.09.03 21:29:58.958923 [ 3 ] {8cd144d1-162e-4519-b67e-1dd0f6e178f1} <Debug> DynamicQueryHandler: Done processing query | ||
| 728 | 2024.09.03 21:29:58.958949 [ 3 ] {} <Debug> HTTP-Session: 54932e0e-9585-401d-8c53-24ff451071a1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 729 | 2024.09.03 21:29:58.959110 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 730 | 2024.09.03 21:29:58.959181 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 731 | 2024.09.03 21:29:58.959201 [ 3 ] {} <Debug> HTTP-Session: 70c8f9ac-b0d5-4b2a-8514-3692348b36dd Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 732 | 2024.09.03 21:29:58.959232 [ 3 ] {} <Debug> HTTP-Session: 70c8f9ac-b0d5-4b2a-8514-3692348b36dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 733 | 2024.09.03 21:29:58.959259 [ 3 ] {} <Debug> HTTP-Session: 70c8f9ac-b0d5-4b2a-8514-3692348b36dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2024.09.03 21:29:58.959290 [ 3 ] {} <Trace> HTTP-Session: 70c8f9ac-b0d5-4b2a-8514-3692348b36dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 735 | 2024.09.03 21:29:58.959487 [ 3 ] {379b43be-dfa0-4ecd-a9b7-727e73d2a653} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.959565 [ 3 ] {379b43be-dfa0-4ecd-a9b7-727e73d2a653} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 737 | 2024.09.03 21:29:58.963121 [ 3 ] {379b43be-dfa0-4ecd-a9b7-727e73d2a653} <Debug> oximeter.fields_i64 (91ed8e9f-668c-4b95-b044-3b9c5e883df7): Loading data parts | ||
| 738 | 2024.09.03 21:29:58.963292 [ 3 ] {379b43be-dfa0-4ecd-a9b7-727e73d2a653} <Debug> oximeter.fields_i64 (91ed8e9f-668c-4b95-b044-3b9c5e883df7): There are no data parts | ||
| 739 | 2024.09.03 21:29:58.965862 [ 3 ] {379b43be-dfa0-4ecd-a9b7-727e73d2a653} <Debug> DynamicQueryHandler: Done processing query | ||
| 740 | 2024.09.03 21:29:58.965905 [ 3 ] {} <Debug> HTTP-Session: 70c8f9ac-b0d5-4b2a-8514-3692348b36dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 741 | 2024.09.03 21:29:58.966040 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 742 | 2024.09.03 21:29:58.966089 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 743 | 2024.09.03 21:29:58.966123 [ 3 ] {} <Debug> HTTP-Session: 444b63ae-1e51-4275-8349-22c365ce0290 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 744 | 2024.09.03 21:29:58.966141 [ 3 ] {} <Debug> HTTP-Session: 444b63ae-1e51-4275-8349-22c365ce0290 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 745 | 2024.09.03 21:29:58.966155 [ 3 ] {} <Debug> HTTP-Session: 444b63ae-1e51-4275-8349-22c365ce0290 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 746 | 2024.09.03 21:29:58.966201 [ 3 ] {} <Trace> HTTP-Session: 444b63ae-1e51-4275-8349-22c365ce0290 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 747 | 2024.09.03 21:29:58.966379 [ 3 ] {b1facd98-222b-4fbe-99b1-5628351c432b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.966424 [ 3 ] {b1facd98-222b-4fbe-99b1-5628351c432b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 749 | 2024.09.03 21:29:58.968484 [ 3 ] {b1facd98-222b-4fbe-99b1-5628351c432b} <Debug> oximeter.fields_u64 (9d0d448c-d39e-43a0-91b7-d476a30ef9dd): Loading data parts | ||
| 750 | 2024.09.03 21:29:58.968644 [ 3 ] {b1facd98-222b-4fbe-99b1-5628351c432b} <Debug> oximeter.fields_u64 (9d0d448c-d39e-43a0-91b7-d476a30ef9dd): There are no data parts | ||
| 751 | 2024.09.03 21:29:58.970693 [ 3 ] {b1facd98-222b-4fbe-99b1-5628351c432b} <Debug> DynamicQueryHandler: Done processing query | ||
| 752 | 2024.09.03 21:29:58.970721 [ 3 ] {} <Debug> HTTP-Session: 444b63ae-1e51-4275-8349-22c365ce0290 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 753 | 2024.09.03 21:29:58.970854 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 754 | 2024.09.03 21:29:58.970902 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 755 | 2024.09.03 21:29:58.970922 [ 3 ] {} <Debug> HTTP-Session: ed5e0334-a6eb-4284-9b2c-fbc3fb0ac0a8 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 756 | 2024.09.03 21:29:58.970939 [ 3 ] {} <Debug> HTTP-Session: ed5e0334-a6eb-4284-9b2c-fbc3fb0ac0a8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 757 | 2024.09.03 21:29:58.970953 [ 3 ] {} <Debug> HTTP-Session: ed5e0334-a6eb-4284-9b2c-fbc3fb0ac0a8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 758 | 2024.09.03 21:29:58.970984 [ 3 ] {} <Trace> HTTP-Session: ed5e0334-a6eb-4284-9b2c-fbc3fb0ac0a8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 759 | 2024.09.03 21:29:58.971155 [ 3 ] {8da16223-ac10-4746-ba08-9114f9436399} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.971200 [ 3 ] {8da16223-ac10-4746-ba08-9114f9436399} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 761 | 2024.09.03 21:29:58.973077 [ 3 ] {8da16223-ac10-4746-ba08-9114f9436399} <Debug> oximeter.fields_ipaddr (c77110b2-ccc1-4ac3-a314-f8f91762b4a3): Loading data parts | ||
| 762 | 2024.09.03 21:29:58.973234 [ 3 ] {8da16223-ac10-4746-ba08-9114f9436399} <Debug> oximeter.fields_ipaddr (c77110b2-ccc1-4ac3-a314-f8f91762b4a3): There are no data parts | ||
| 763 | 2024.09.03 21:29:58.974773 [ 3 ] {8da16223-ac10-4746-ba08-9114f9436399} <Debug> DynamicQueryHandler: Done processing query | ||
| 764 | 2024.09.03 21:29:58.974799 [ 3 ] {} <Debug> HTTP-Session: ed5e0334-a6eb-4284-9b2c-fbc3fb0ac0a8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 765 | 2024.09.03 21:29:58.974926 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 766 | 2024.09.03 21:29:58.974973 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 767 | 2024.09.03 21:29:58.974994 [ 3 ] {} <Debug> HTTP-Session: 8d28aca6-849e-46bb-8af2-61951cbea501 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 768 | 2024.09.03 21:29:58.975011 [ 3 ] {} <Debug> HTTP-Session: 8d28aca6-849e-46bb-8af2-61951cbea501 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 769 | 2024.09.03 21:29:58.975028 [ 3 ] {} <Debug> HTTP-Session: 8d28aca6-849e-46bb-8af2-61951cbea501 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 770 | 2024.09.03 21:29:58.975059 [ 3 ] {} <Trace> HTTP-Session: 8d28aca6-849e-46bb-8af2-61951cbea501 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 771 | 2024.09.03 21:29:58.975234 [ 3 ] {7932da79-9222-4705-9e6f-d7f5d94b35d2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.975278 [ 3 ] {7932da79-9222-4705-9e6f-d7f5d94b35d2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 773 | 2024.09.03 21:29:58.979048 [ 3 ] {7932da79-9222-4705-9e6f-d7f5d94b35d2} <Debug> oximeter.fields_string (055df996-2729-4af8-9cd9-3a4d0831c08e): Loading data parts | ||
| 774 | 2024.09.03 21:29:58.979214 [ 3 ] {7932da79-9222-4705-9e6f-d7f5d94b35d2} <Debug> oximeter.fields_string (055df996-2729-4af8-9cd9-3a4d0831c08e): There are no data parts | ||
| 775 | 2024.09.03 21:29:58.980668 [ 3 ] {7932da79-9222-4705-9e6f-d7f5d94b35d2} <Debug> DynamicQueryHandler: Done processing query | ||
| 776 | 2024.09.03 21:29:58.980695 [ 3 ] {} <Debug> HTTP-Session: 8d28aca6-849e-46bb-8af2-61951cbea501 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 777 | 2024.09.03 21:29:58.980827 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 778 | 2024.09.03 21:29:58.980876 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 779 | 2024.09.03 21:29:58.980896 [ 3 ] {} <Debug> HTTP-Session: 31e6010d-a8da-4d85-b5a2-8942222ca54f Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 780 | 2024.09.03 21:29:58.980913 [ 3 ] {} <Debug> HTTP-Session: 31e6010d-a8da-4d85-b5a2-8942222ca54f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 781 | 2024.09.03 21:29:58.980927 [ 3 ] {} <Debug> HTTP-Session: 31e6010d-a8da-4d85-b5a2-8942222ca54f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 782 | 2024.09.03 21:29:58.980957 [ 3 ] {} <Trace> HTTP-Session: 31e6010d-a8da-4d85-b5a2-8942222ca54f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 783 | 2024.09.03 21:29:58.981132 [ 3 ] {de1acd13-b61c-41f9-a58a-988d855fcb43} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) 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.03 21:29:58.981176 [ 3 ] {de1acd13-b61c-41f9-a58a-988d855fcb43} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 785 | 2024.09.03 21:29:58.983016 [ 3 ] {de1acd13-b61c-41f9-a58a-988d855fcb43} <Debug> oximeter.fields_uuid (7cbfcaf9-4c31-4987-a0f6-2c18ae0fa803): Loading data parts | ||
| 786 | 2024.09.03 21:29:58.983188 [ 3 ] {de1acd13-b61c-41f9-a58a-988d855fcb43} <Debug> oximeter.fields_uuid (7cbfcaf9-4c31-4987-a0f6-2c18ae0fa803): There are no data parts | ||
| 787 | 2024.09.03 21:29:58.984591 [ 3 ] {de1acd13-b61c-41f9-a58a-988d855fcb43} <Debug> DynamicQueryHandler: Done processing query | ||
| 788 | 2024.09.03 21:29:58.984618 [ 3 ] {} <Debug> HTTP-Session: 31e6010d-a8da-4d85-b5a2-8942222ca54f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 789 | 2024.09.03 21:29:58.984751 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 790 | 2024.09.03 21:29:58.984801 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 791 | 2024.09.03 21:29:58.984820 [ 3 ] {} <Debug> HTTP-Session: 71935942-9079-42a7-9004-e464a245ee7e Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 792 | 2024.09.03 21:29:58.984837 [ 3 ] {} <Debug> HTTP-Session: 71935942-9079-42a7-9004-e464a245ee7e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 793 | 2024.09.03 21:29:58.984852 [ 3 ] {} <Debug> HTTP-Session: 71935942-9079-42a7-9004-e464a245ee7e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 794 | 2024.09.03 21:29:58.984883 [ 3 ] {} <Trace> HTTP-Session: 71935942-9079-42a7-9004-e464a245ee7e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 795 | 2024.09.03 21:29:58.985096 [ 3 ] {97ae8cfc-893c-4cc7-af6b-374b638e2993} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) /* 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.03 21:29:58.985156 [ 3 ] {97ae8cfc-893c-4cc7-af6b-374b638e2993} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 800 | 2024.09.03 21:29:58.986730 [ 3 ] {97ae8cfc-893c-4cc7-af6b-374b638e2993} <Debug> oximeter.timeseries_schema (adfa7df6-f9a1-4fae-9b06-1c518fc9621f): Loading data parts | ||
| 801 | 2024.09.03 21:29:58.986886 [ 3 ] {97ae8cfc-893c-4cc7-af6b-374b638e2993} <Debug> oximeter.timeseries_schema (adfa7df6-f9a1-4fae-9b06-1c518fc9621f): There are no data parts | ||
| 802 | 2024.09.03 21:29:58.988170 [ 3 ] {97ae8cfc-893c-4cc7-af6b-374b638e2993} <Debug> DynamicQueryHandler: Done processing query | ||
| 803 | 2024.09.03 21:29:58.988197 [ 3 ] {} <Debug> HTTP-Session: 71935942-9079-42a7-9004-e464a245ee7e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 804 | 2024.09.03 21:29:58.988332 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:51244, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 805 | 2024.09.03 21:29:58.988381 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 806 | 2024.09.03 21:29:58.988401 [ 3 ] {} <Debug> HTTP-Session: e1d8755b-5f1e-4adb-92da-9f8041b24702 Authenticating user 'default' from [fd00:1122:3344:101::d]:51244 | ||
| 807 | 2024.09.03 21:29:58.988418 [ 3 ] {} <Debug> HTTP-Session: e1d8755b-5f1e-4adb-92da-9f8041b24702 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 808 | 2024.09.03 21:29:58.988434 [ 3 ] {} <Debug> HTTP-Session: e1d8755b-5f1e-4adb-92da-9f8041b24702 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 809 | 2024.09.03 21:29:58.988464 [ 3 ] {} <Trace> HTTP-Session: e1d8755b-5f1e-4adb-92da-9f8041b24702 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 810 | 2024.09.03 21:29:58.988628 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:51244) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 811 | 2024.09.03 21:29:58.990341 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 812 | 2024.09.03 21:29:58.995955 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Trace> oximeter.version (b409d17c-4e3b-4f2d-8ac1-19d3923d30ae): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 813 | 2024.09.03 21:29:58.995993 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.34 GiB. | ||
| 814 | 2024.09.03 21:29:59.000161 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 165.88 MiB, peak 165.88 MiB, free memory in arenas 0.00 B, will set to 171.02 MiB (RSS), difference: 5.13 MiB | ||
| 815 | 2024.09.03 21:29:59.000345 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 816 | 2024.09.03 21:29:59.001461 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Trace> oximeter.version (b409d17c-4e3b-4f2d-8ac1-19d3923d30ae): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 817 | 2024.09.03 21:29:59.001734 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.013185 sec., 75.84376185058778 rows/sec., 1.19 KiB/sec. | ||
| 818 | 2024.09.03 21:29:59.001910 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Debug> DynamicQueryHandler: Done processing query | ||
| 819 | 2024.09.03 21:29:59.001936 [ 3 ] {48e5037b-2cf6-4473-ace2-3dd28c23451d} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 820 | 2024.09.03 21:29:59.001952 [ 3 ] {} <Debug> HTTP-Session: e1d8755b-5f1e-4adb-92da-9f8041b24702 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 821 | 2024.09.03 21:30:00.001148 [ 243 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 165.88 MiB, peak 171.02 MiB, free memory in arenas 0.00 B, will set to 171.66 MiB (RSS), difference: 5.78 MiB | ||