| 1 | [ Dec 13 05:14:33 Enabled. ] | ||
| 2 | [ Dec 13 05:14:33 Rereading configuration. ] | ||
| 3 | [ Dec 13 05:14:37 Rereading configuration. ] | ||
| 4 | [ Dec 13 05:14:43 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 | ++ svcprop -c -p config/datalink svc:/oxide/clickhouse:default | ||
| 23 | + DATALINK=oxControlService14 | ||
| 24 | ++ svcprop -c -p config/gateway svc:/oxide/clickhouse:default | ||
| 25 | + GATEWAY=fd00:1122:3344:101::1 | ||
| 26 | + [[ oxControlService14 == unknown ]] | ||
| 27 | + [[ fd00:1122:3344:101::1 == unknown ]] | ||
| 28 | + ipadm delete-if oxControlService14 | ||
| 29 | ipadm: Could not delete oxControlService14: Interface does not exist | ||
| 30 | + true | ||
| 31 | + ipadm create-if -t oxControlService14 | ||
| 32 | + ipadm set-ifprop -t -p mtu=9000 -m ipv4 oxControlService14 | ||
| 33 | + ipadm set-ifprop -t -p mtu=9000 -m ipv6 oxControlService14 | ||
| 34 | + ipadm show-addr oxControlService14/ll | ||
| 35 | ipadm: Address object not found | ||
| 36 | + ipadm create-addr -t -T addrconf oxControlService14/ll | ||
| 37 | + ipadm show-addr oxControlService14/omicron6 | ||
| 38 | ipadm: Address object not found | ||
| 39 | + ipadm create-addr -t -T static -a fd00:1122:3344:101::e oxControlService14/omicron6 | ||
| 40 | + route get -inet6 default -inet6 fd00:1122:3344:101::1 | ||
| 41 | default: not in table | ||
| 42 | + route add -inet6 default -inet6 fd00:1122:3344:101::1 | ||
| 43 | add net default: gateway fd00:1122:3344:101::1 | ||
| 44 | + single_node=true | ||
| 45 | + command=() | ||
| 46 | + true | ||
| 47 | + command+=("/opt/oxide/clickhouse/clickhouse" "server" "--log-file" "/var/tmp/clickhouse-server.log" "--errorlog-file" "/var/tmp/clickhouse-server.errlog" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
| 48 | + 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 | ||
| 49 | [ Dec 13 05:14:43 Method "start" exited with status 0. ] | ||
| 50 | Processing configuration file 'config.xml'. | ||
| 51 | There is no file 'config.xml', will use embedded config. | ||
| 52 | Logging trace to /var/tmp/clickhouse-server.log | ||
| 53 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
| 54 | 2023.12.13 05:14:44.281176 [ 1 ] {} <Information> Application: Will watch for the process with pid 22247 | ||
| 55 | 2023.12.13 05:14:44.281270 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 56 | 2023.12.13 05:14:45.183185 [ 1 ] {} <Information> : Starting ClickHouse 22.8.9.1 with revision 54465, no build id, PID 22247 | ||
| 57 | 2023.12.13 05:14:45.183353 [ 1 ] {} <Information> Application: starting up | ||
| 58 | 2023.12.13 05:14:45.183612 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 59 | 2023.12.13 05:14:45.269802 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 60 | 2023.12.13 05:14:45.269871 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 61 | 2023.12.13 05:14:45.269887 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 62 | 2023.12.13 05:14:45.269925 [ 1 ] {} <Debug> Application: Setting up /data/tmp/ to store temporary data in it | ||
| 63 | 2023.12.13 05:14:45.270472 [ 1 ] {} <Debug> Application: Initiailizing interserver credentials. | ||
| 64 | 2023.12.13 05:14:45.271228 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 65 | Processing configuration file 'config.xml'. | ||
| 66 | There is no file 'config.xml', will use embedded config. | ||
| 67 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 68 | 2023.12.13 05:14:45.271817 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 69 | 2023.12.13 05:14:45.272054 [ 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) | ||
| 70 | 2023.12.13 05:14:45.274804 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 71 | 2023.12.13 05:14:45.274895 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 72 | 2023.12.13 05:14:45.275562 [ 1 ] {} <Debug> ConfigReloader: Loading config 'config.xml' | ||
| 73 | Processing configuration file 'config.xml'. | ||
| 74 | There is no file 'config.xml', will use embedded config. | ||
| 75 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 76 | 2023.12.13 05:14:45.275853 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration | ||
| 77 | 2023.12.13 05:14:45.282270 [ 1 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration | ||
| 78 | 2023.12.13 05:14:45.282815 [ 1 ] {} <Debug> Access(user directories): Added users.xml access storage 'users.xml', path: config.xml | ||
| 79 | 2023.12.13 05:14:45.282864 [ 1 ] {} <Information> Application: Uncompressed cache policy name | ||
| 80 | 2023.12.13 05:14:45.284168 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32 | ||
| 81 | 2023.12.13 05:14:45.284651 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 82 | 2023.12.13 05:14:45.285133 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 83 | 2023.12.13 05:14:45.285525 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 84 | 2023.12.13 05:14:45.286453 [ 1 ] {} <Information> Application: Loading user defined objects from /data/ | ||
| 85 | 2023.12.13 05:14:45.286494 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoader: Loading user defined objects | ||
| 86 | 2023.12.13 05:14:45.286549 [ 1 ] {} <Debug> Application: Loaded user defined objects | ||
| 87 | 2023.12.13 05:14:45.286591 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 88 | 2023.12.13 05:14:45.295364 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 89 | 2023.12.13 05:14:45.295415 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000136222 sec | ||
| 90 | 2023.12.13 05:14:45.296031 [ 1 ] {} <Information> TablesLoader: Loading 0 tables with 0 dependency level | ||
| 91 | 2023.12.13 05:14:45.296130 [ 1 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config | ||
| 92 | 2023.12.13 05:14:45.296154 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 93 | 2023.12.13 05:14:45.296195 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 94 | 2023.12.13 05:14:45.296207 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 95 | 2023.12.13 05:14:45.296245 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 96 | 2023.12.13 05:14:45.296286 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 97 | 2023.12.13 05:14:45.296318 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 98 | 2023.12.13 05:14:45.296363 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 99 | 2023.12.13 05:14:45.296420 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 100 | 2023.12.13 05:14:45.296433 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 101 | 2023.12.13 05:14:45.296469 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 102 | 2023.12.13 05:14:45.296508 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 103 | 2023.12.13 05:14:45.296539 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 104 | 2023.12.13 05:14:45.296576 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 105 | 2023.12.13 05:14:45.296590 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 106 | 2023.12.13 05:14:45.333281 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 107 | 2023.12.13 05:14:45.334575 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 108 | 2023.12.13 05:14:45.334625 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.9541e-05 sec | ||
| 109 | 2023.12.13 05:14:45.334671 [ 1 ] {} <Information> TablesLoader: Loading 0 tables with 0 dependency level | ||
| 110 | 2023.12.13 05:14:45.334686 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 111 | 2023.12.13 05:14:45.334705 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 112 | 2023.12.13 05:14:45.336986 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 113 | 2023.12.13 05:14:45.342443 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 114 | 2023.12.13 05:14:45.342564 [ 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). | ||
| 115 | 2023.12.13 05:14:45.342606 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 116 | 2023.12.13 05:14:45.579563 [ 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 22.8.9.1) | ||
| 117 | 2023.12.13 05:14:45.597205 [ 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 22.8.9.1) | ||
| 118 | 2023.12.13 05:14:45.597273 [ 1 ] {} <Trace> MySQLHandlerFactory: Generating new RSA key pair. | ||
| 119 | 2023.12.13 05:14:45.624580 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 120 | 2023.12.13 05:14:45.625373 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 5.95 MiB, peak 10.41 MiB, will set to 216.66 MiB (RSS), difference: 210.71 MiB | ||
| 121 | 2023.12.13 05:14:45.625831 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 122 | 2023.12.13 05:14:45.625899 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 24; logical cores: 48. | ||
| 123 | 2023.12.13 05:14:45.625914 [ 161 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 124 | 2023.12.13 05:14:45.626021 [ 161 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 125 | 2023.12.13 05:14:45.626034 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 126 | 2023.12.13 05:14:45.626082 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 127 | 2023.12.13 05:14:45.626736 [ 1 ] {} <Information> Application: Listening for MySQL compatibility protocol: [fd00:1122:3344:101::e]:9004 | ||
| 128 | 2023.12.13 05:14:45.626782 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 129 | 2023.12.13 05:14:46.243534 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 130 | 2023.12.13 05:14:46.243733 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 131 | 2023.12.13 05:14:46.244411 [ 3 ] {} <Debug> HTTP-Session: 6aba8cc8-19f8-4d92-9521-aa90ddc1199c Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 132 | 2023.12.13 05:14:46.244491 [ 3 ] {} <Debug> HTTP-Session: 6aba8cc8-19f8-4d92-9521-aa90ddc1199c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 133 | 2023.12.13 05:14:46.244641 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly=0, allow_ddl=true, allow_introspection_functions=false | ||
| 134 | 2023.12.13 05:14:46.244668 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT ALL ON *.* WITH GRANT OPTION | ||
| 135 | 2023.12.13 05:14:46.244711 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT ALL ON *.* WITH GRANT OPTION | ||
| 136 | 2023.12.13 05:14:46.246215 [ 3 ] {dcfd380f-e929-403f-9964-7bfb6ec04bb6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 137 | 2023.12.13 05:14:46.268260 [ 3 ] {dcfd380f-e929-403f-9964-7bfb6ec04bb6} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter doesn't exist. (UNKNOWN_DATABASE) (version 22.8.9.1) (from [fd00:1122:3344:101::d]:41902) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 138 | |||
| 139 | 0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 14d95872 in /opt/oxide/clickhouse/clickhouse | ||
| 140 | 1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ d61d720 in /opt/oxide/clickhouse/clickhouse | ||
| 141 | 2. DB::DatabaseCatalog::assertDatabaseExistsUnlocked(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 118d4d88 in /opt/oxide/clickhouse/clickhouse | ||
| 142 | 3. DB::DatabaseCatalog::getDatabase(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 118d6b27 in /opt/oxide/clickhouse/clickhouse | ||
| 143 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 11897ed6 in /opt/oxide/clickhouse/clickhouse | ||
| 144 | 5. DB::JoinedTables::getLeftTableStorage() @ 119cfaa7 in /opt/oxide/clickhouse/clickhouse | ||
| 145 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 1196673d in /opt/oxide/clickhouse/clickhouse | ||
| 146 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119659af in /opt/oxide/clickhouse/clickhouse | ||
| 147 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::__1::shared_ptr<DB::IAST> const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119a1a1b in /opt/oxide/clickhouse/clickhouse | ||
| 148 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119a0081 in /opt/oxide/clickhouse/clickhouse | ||
| 149 | 10. std::__1::__unique_if<DB::InterpreterSelectWithUnionQuery>::__unique_single std::__1::make_unique<DB::InterpreterSelectWithUnionQuery, std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 11949637 in /opt/oxide/clickhouse/clickhouse | ||
| 150 | 11. DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 119486e5 in /opt/oxide/clickhouse/clickhouse | ||
| 151 | 12. DB::executeQueryImpl(char const*, char const*, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 11aee531 in /opt/oxide/clickhouse/clickhouse | ||
| 152 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::__1::shared_ptr<DB::Context>, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)>, std::__1::optional<DB::FormatSettings> const&) @ 11af283f in /opt/oxide/clickhouse/clickhouse | ||
| 153 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optional<DB::CurrentThread::QueryScope>&) @ 12e38c4b in /opt/oxide/clickhouse/clickhouse | ||
| 154 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 12e3c6c8 in /opt/oxide/clickhouse/clickhouse | ||
| 155 | 16. DB::HTTPServerConnection::run() @ 12e57a95 in /opt/oxide/clickhouse/clickhouse | ||
| 156 | 17. Poco::Net::TCPServerConnection::start() @ 14d8358c in /opt/oxide/clickhouse/clickhouse | ||
| 157 | 18. Poco::Net::TCPServerDispatcher::run() @ 14d83a7a in /opt/oxide/clickhouse/clickhouse | ||
| 158 | 19. Poco::PooledThread::run() @ 14df0b87 in /opt/oxide/clickhouse/clickhouse | ||
| 159 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 14dee74f in /opt/oxide/clickhouse/clickhouse | ||
| 160 | 21. _thrp_setup @ 111ef7 in /system/lib/amd64/libc.so.1 | ||
| 161 | |||
| 162 | 2023.12.13 05:14:46.269170 [ 3 ] {dcfd380f-e929-403f-9964-7bfb6ec04bb6} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter doesn't exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 163 | |||
| 164 | 0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 14d95872 in /opt/oxide/clickhouse/clickhouse | ||
| 165 | 1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ d61d720 in /opt/oxide/clickhouse/clickhouse | ||
| 166 | 2. DB::DatabaseCatalog::assertDatabaseExistsUnlocked(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 118d4d88 in /opt/oxide/clickhouse/clickhouse | ||
| 167 | 3. DB::DatabaseCatalog::getDatabase(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 118d6b27 in /opt/oxide/clickhouse/clickhouse | ||
| 168 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 11897ed6 in /opt/oxide/clickhouse/clickhouse | ||
| 169 | 5. DB::JoinedTables::getLeftTableStorage() @ 119cfaa7 in /opt/oxide/clickhouse/clickhouse | ||
| 170 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 1196673d in /opt/oxide/clickhouse/clickhouse | ||
| 171 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119659af in /opt/oxide/clickhouse/clickhouse | ||
| 172 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::__1::shared_ptr<DB::IAST> const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119a1a1b in /opt/oxide/clickhouse/clickhouse | ||
| 173 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119a0081 in /opt/oxide/clickhouse/clickhouse | ||
| 174 | 10. std::__1::__unique_if<DB::InterpreterSelectWithUnionQuery>::__unique_single std::__1::make_unique<DB::InterpreterSelectWithUnionQuery, std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 11949637 in /opt/oxide/clickhouse/clickhouse | ||
| 175 | 11. DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 119486e5 in /opt/oxide/clickhouse/clickhouse | ||
| 176 | 12. DB::executeQueryImpl(char const*, char const*, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 11aee531 in /opt/oxide/clickhouse/clickhouse | ||
| 177 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::__1::shared_ptr<DB::Context>, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)>, std::__1::optional<DB::FormatSettings> const&) @ 11af283f in /opt/oxide/clickhouse/clickhouse | ||
| 178 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optional<DB::CurrentThread::QueryScope>&) @ 12e38c4b in /opt/oxide/clickhouse/clickhouse | ||
| 179 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 12e3c6c8 in /opt/oxide/clickhouse/clickhouse | ||
| 180 | 16. DB::HTTPServerConnection::run() @ 12e57a95 in /opt/oxide/clickhouse/clickhouse | ||
| 181 | 17. Poco::Net::TCPServerConnection::start() @ 14d8358c in /opt/oxide/clickhouse/clickhouse | ||
| 182 | 18. Poco::Net::TCPServerDispatcher::run() @ 14d83a7a in /opt/oxide/clickhouse/clickhouse | ||
| 183 | 19. Poco::PooledThread::run() @ 14df0b87 in /opt/oxide/clickhouse/clickhouse | ||
| 184 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 14dee74f in /opt/oxide/clickhouse/clickhouse | ||
| 185 | 21. _thrp_setup @ 111ef7 in /system/lib/amd64/libc.so.1 | ||
| 186 | (version 22.8.9.1) | ||
| 187 | 2023.12.13 05:14:46.270007 [ 3 ] {dcfd380f-e929-403f-9964-7bfb6ec04bb6} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 188 | 2023.12.13 05:14:46.270031 [ 3 ] {} <Debug> HTTP-Session: 6aba8cc8-19f8-4d92-9521-aa90ddc1199c Destroying unnamed session | ||
| 189 | 2023.12.13 05:14:46.272254 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 33, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 190 | 2023.12.13 05:14:46.272353 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 191 | 2023.12.13 05:14:46.272444 [ 3 ] {} <Debug> HTTP-Session: 0aa01901-d4a6-4b08-b110-7a20c6d6d9f1 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 192 | 2023.12.13 05:14:46.272499 [ 3 ] {} <Debug> HTTP-Session: 0aa01901-d4a6-4b08-b110-7a20c6d6d9f1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 193 | 2023.12.13 05:14:46.272602 [ 3 ] {334d9b30-b2c6-454d-8237-7b7fb7b0da57} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) SHOW CLUSTERS FORMAT JSONEachRow; (stage: Complete) | ||
| 194 | 2023.12.13 05:14:46.272722 [ 3 ] {334d9b30-b2c6-454d-8237-7b7fb7b0da57} <Debug> executeQuery: (internal) SELECT DISTINCT cluster FROM system.clusters (stage: Complete) | ||
| 195 | 2023.12.13 05:14:46.273780 [ 3 ] {334d9b30-b2c6-454d-8237-7b7fb7b0da57} <Trace> ContextAccess (default): Access granted: SELECT(cluster) ON system.clusters | ||
| 196 | 2023.12.13 05:14:46.275647 [ 3 ] {334d9b30-b2c6-454d-8237-7b7fb7b0da57} <Trace> InterpreterSelectQuery: FetchColumns -> Complete | ||
| 197 | 2023.12.13 05:14:46.279741 [ 3 ] {334d9b30-b2c6-454d-8237-7b7fb7b0da57} <Debug> DynamicQueryHandler: Done processing query | ||
| 198 | 2023.12.13 05:14:46.279801 [ 3 ] {334d9b30-b2c6-454d-8237-7b7fb7b0da57} <Debug> MemoryTracker: Peak memory usage (for query): 4.00 MiB. | ||
| 199 | 2023.12.13 05:14:46.279817 [ 3 ] {} <Debug> HTTP-Session: 0aa01901-d4a6-4b08-b110-7a20c6d6d9f1 Destroying unnamed session | ||
| 200 | 2023.12.13 05:14:46.279951 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 201 | 2023.12.13 05:14:46.280053 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 202 | 2023.12.13 05:14:46.280074 [ 3 ] {} <Debug> HTTP-Session: 9083ff6e-86a5-4845-a6ce-ff904e02141c Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 203 | 2023.12.13 05:14:46.280091 [ 3 ] {} <Debug> HTTP-Session: 9083ff6e-86a5-4845-a6ce-ff904e02141c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 204 | 2023.12.13 05:14:46.280215 [ 3 ] {ca67a577-fd64-49cb-a762-3637f244d772} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 205 | 2023.12.13 05:14:46.280551 [ 3 ] {ca67a577-fd64-49cb-a762-3637f244d772} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter doesn't exist. (UNKNOWN_DATABASE) (version 22.8.9.1) (from [fd00:1122:3344:101::d]:41902) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 206 | |||
| 207 | 0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 14d95872 in /opt/oxide/clickhouse/clickhouse | ||
| 208 | 1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ d61d720 in /opt/oxide/clickhouse/clickhouse | ||
| 209 | 2. DB::DatabaseCatalog::assertDatabaseExistsUnlocked(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 118d4d88 in /opt/oxide/clickhouse/clickhouse | ||
| 210 | 3. DB::DatabaseCatalog::getDatabase(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 118d6b27 in /opt/oxide/clickhouse/clickhouse | ||
| 211 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 11897ed6 in /opt/oxide/clickhouse/clickhouse | ||
| 212 | 5. DB::JoinedTables::getLeftTableStorage() @ 119cfaa7 in /opt/oxide/clickhouse/clickhouse | ||
| 213 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 1196673d in /opt/oxide/clickhouse/clickhouse | ||
| 214 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119659af in /opt/oxide/clickhouse/clickhouse | ||
| 215 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::__1::shared_ptr<DB::IAST> const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119a1a1b in /opt/oxide/clickhouse/clickhouse | ||
| 216 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119a0081 in /opt/oxide/clickhouse/clickhouse | ||
| 217 | 10. std::__1::__unique_if<DB::InterpreterSelectWithUnionQuery>::__unique_single std::__1::make_unique<DB::InterpreterSelectWithUnionQuery, std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 11949637 in /opt/oxide/clickhouse/clickhouse | ||
| 218 | 11. DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 119486e5 in /opt/oxide/clickhouse/clickhouse | ||
| 219 | 12. DB::executeQueryImpl(char const*, char const*, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 11aee531 in /opt/oxide/clickhouse/clickhouse | ||
| 220 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::__1::shared_ptr<DB::Context>, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)>, std::__1::optional<DB::FormatSettings> const&) @ 11af283f in /opt/oxide/clickhouse/clickhouse | ||
| 221 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optional<DB::CurrentThread::QueryScope>&) @ 12e38c4b in /opt/oxide/clickhouse/clickhouse | ||
| 222 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 12e3c6c8 in /opt/oxide/clickhouse/clickhouse | ||
| 223 | 16. DB::HTTPServerConnection::run() @ 12e57a95 in /opt/oxide/clickhouse/clickhouse | ||
| 224 | 17. Poco::Net::TCPServerConnection::start() @ 14d8358c in /opt/oxide/clickhouse/clickhouse | ||
| 225 | 18. Poco::Net::TCPServerDispatcher::run() @ 14d83a7a in /opt/oxide/clickhouse/clickhouse | ||
| 226 | 19. Poco::PooledThread::run() @ 14df0b87 in /opt/oxide/clickhouse/clickhouse | ||
| 227 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 14dee74f in /opt/oxide/clickhouse/clickhouse | ||
| 228 | 21. _thrp_setup @ 111ef7 in /system/lib/amd64/libc.so.1 | ||
| 229 | |||
| 230 | 2023.12.13 05:14:46.280802 [ 3 ] {ca67a577-fd64-49cb-a762-3637f244d772} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter doesn't exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 231 | |||
| 232 | 0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 14d95872 in /opt/oxide/clickhouse/clickhouse | ||
| 233 | 1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ d61d720 in /opt/oxide/clickhouse/clickhouse | ||
| 234 | 2. DB::DatabaseCatalog::assertDatabaseExistsUnlocked(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 118d4d88 in /opt/oxide/clickhouse/clickhouse | ||
| 235 | 3. DB::DatabaseCatalog::getDatabase(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 118d6b27 in /opt/oxide/clickhouse/clickhouse | ||
| 236 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 11897ed6 in /opt/oxide/clickhouse/clickhouse | ||
| 237 | 5. DB::JoinedTables::getLeftTableStorage() @ 119cfaa7 in /opt/oxide/clickhouse/clickhouse | ||
| 238 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 1196673d in /opt/oxide/clickhouse/clickhouse | ||
| 239 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119659af in /opt/oxide/clickhouse/clickhouse | ||
| 240 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::__1::shared_ptr<DB::IAST> const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119a1a1b in /opt/oxide/clickhouse/clickhouse | ||
| 241 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 119a0081 in /opt/oxide/clickhouse/clickhouse | ||
| 242 | 10. std::__1::__unique_if<DB::InterpreterSelectWithUnionQuery>::__unique_single std::__1::make_unique<DB::InterpreterSelectWithUnionQuery, std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 11949637 in /opt/oxide/clickhouse/clickhouse | ||
| 243 | 11. DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 119486e5 in /opt/oxide/clickhouse/clickhouse | ||
| 244 | 12. DB::executeQueryImpl(char const*, char const*, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 11aee531 in /opt/oxide/clickhouse/clickhouse | ||
| 245 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::__1::shared_ptr<DB::Context>, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)>, std::__1::optional<DB::FormatSettings> const&) @ 11af283f in /opt/oxide/clickhouse/clickhouse | ||
| 246 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optional<DB::CurrentThread::QueryScope>&) @ 12e38c4b in /opt/oxide/clickhouse/clickhouse | ||
| 247 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 12e3c6c8 in /opt/oxide/clickhouse/clickhouse | ||
| 248 | 16. DB::HTTPServerConnection::run() @ 12e57a95 in /opt/oxide/clickhouse/clickhouse | ||
| 249 | 17. Poco::Net::TCPServerConnection::start() @ 14d8358c in /opt/oxide/clickhouse/clickhouse | ||
| 250 | 18. Poco::Net::TCPServerDispatcher::run() @ 14d83a7a in /opt/oxide/clickhouse/clickhouse | ||
| 251 | 19. Poco::PooledThread::run() @ 14df0b87 in /opt/oxide/clickhouse/clickhouse | ||
| 252 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 14dee74f in /opt/oxide/clickhouse/clickhouse | ||
| 253 | 21. _thrp_setup @ 111ef7 in /system/lib/amd64/libc.so.1 | ||
| 254 | (version 22.8.9.1) | ||
| 255 | 2023.12.13 05:14:46.281025 [ 3 ] {ca67a577-fd64-49cb-a762-3637f244d772} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 256 | 2023.12.13 05:14:46.281045 [ 3 ] {} <Debug> HTTP-Session: 9083ff6e-86a5-4845-a6ce-ff904e02141c Destroying unnamed session | ||
| 257 | 2023.12.13 05:14:46.283239 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 258 | 2023.12.13 05:14:46.283309 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 259 | 2023.12.13 05:14:46.283328 [ 3 ] {} <Debug> HTTP-Session: a6222aca-62bd-4bbe-a26d-bcb58b3f6312 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 260 | 2023.12.13 05:14:46.283372 [ 3 ] {} <Debug> HTTP-Session: a6222aca-62bd-4bbe-a26d-bcb58b3f6312 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 261 | 2023.12.13 05:14:46.283570 [ 3 ] {0a7621ab-c8ff-4116-b16d-234766463c41} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 262 | 2023.12.13 05:14:46.283667 [ 3 ] {0a7621ab-c8ff-4116-b16d-234766463c41} <Debug> DynamicQueryHandler: Done processing query | ||
| 263 | 2023.12.13 05:14:46.283712 [ 3 ] {0a7621ab-c8ff-4116-b16d-234766463c41} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 264 | 2023.12.13 05:14:46.283728 [ 3 ] {} <Debug> HTTP-Session: a6222aca-62bd-4bbe-a26d-bcb58b3f6312 Destroying unnamed session | ||
| 265 | 2023.12.13 05:14:46.285698 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 266 | 2023.12.13 05:14:46.285778 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 267 | 2023.12.13 05:14:46.285802 [ 3 ] {} <Debug> HTTP-Session: 5366fc98-e8b1-4cfd-84fc-53c86d0c11dc Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 268 | 2023.12.13 05:14:46.285856 [ 3 ] {} <Debug> HTTP-Session: 5366fc98-e8b1-4cfd-84fc-53c86d0c11dc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2023.12.13 05:14:46.285923 [ 3 ] {c06231d4-e8cc-47c4-b160-b72dd1a6d63e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 270 | 2023.12.13 05:14:46.286012 [ 3 ] {c06231d4-e8cc-47c4-b160-b72dd1a6d63e} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 271 | 2023.12.13 05:14:46.287118 [ 3 ] {c06231d4-e8cc-47c4-b160-b72dd1a6d63e} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 272 | 2023.12.13 05:14:46.287138 [ 3 ] {c06231d4-e8cc-47c4-b160-b72dd1a6d63e} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 4.215e-05 sec | ||
| 273 | 2023.12.13 05:14:46.287186 [ 3 ] {c06231d4-e8cc-47c4-b160-b72dd1a6d63e} <Information> TablesLoader: Loading 0 tables with 0 dependency level | ||
| 274 | 2023.12.13 05:14:46.287231 [ 3 ] {c06231d4-e8cc-47c4-b160-b72dd1a6d63e} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 275 | 2023.12.13 05:14:46.287296 [ 3 ] {c06231d4-e8cc-47c4-b160-b72dd1a6d63e} <Debug> DynamicQueryHandler: Done processing query | ||
| 276 | 2023.12.13 05:14:46.287347 [ 3 ] {c06231d4-e8cc-47c4-b160-b72dd1a6d63e} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 277 | 2023.12.13 05:14:46.287363 [ 3 ] {} <Debug> HTTP-Session: 5366fc98-e8b1-4cfd-84fc-53c86d0c11dc Destroying unnamed session | ||
| 278 | 2023.12.13 05:14:46.287563 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 279 | 2023.12.13 05:14:46.287630 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 280 | 2023.12.13 05:14:46.287650 [ 3 ] {} <Debug> HTTP-Session: a5765dab-9e02-40f9-9cd8-d98643592a74 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 281 | 2023.12.13 05:14:46.287697 [ 3 ] {} <Debug> HTTP-Session: a5765dab-9e02-40f9-9cd8-d98643592a74 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2023.12.13 05:14:46.287827 [ 3 ] {79fd5e24-0fe3-4db2-bfe4-5f827ac9777a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) /* The version table contains metadata about the `oximeter` database */ | ||
| 283 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 284 | 2023.12.13 05:14:46.287931 [ 3 ] {79fd5e24-0fe3-4db2-bfe4-5f827ac9777a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 285 | 2023.12.13 05:14:46.291799 [ 3 ] {79fd5e24-0fe3-4db2-bfe4-5f827ac9777a} <Debug> oximeter.version (ff04410b-72ff-48a5-b402-f5e86fdf31e4): Loading data parts | ||
| 286 | 2023.12.13 05:14:46.291944 [ 3 ] {79fd5e24-0fe3-4db2-bfe4-5f827ac9777a} <Debug> oximeter.version (ff04410b-72ff-48a5-b402-f5e86fdf31e4): There are no data parts | ||
| 287 | 2023.12.13 05:14:46.293769 [ 3 ] {79fd5e24-0fe3-4db2-bfe4-5f827ac9777a} <Debug> DynamicQueryHandler: Done processing query | ||
| 288 | 2023.12.13 05:14:46.293794 [ 3 ] {79fd5e24-0fe3-4db2-bfe4-5f827ac9777a} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 289 | 2023.12.13 05:14:46.293836 [ 3 ] {} <Debug> HTTP-Session: a5765dab-9e02-40f9-9cd8-d98643592a74 Destroying unnamed session | ||
| 290 | 2023.12.13 05:14:46.293990 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 291 | 2023.12.13 05:14:46.294062 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 292 | 2023.12.13 05:14:46.294103 [ 3 ] {} <Debug> HTTP-Session: 5129be79-7ecf-4c8a-b00a-075e5e318162 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 293 | 2023.12.13 05:14:46.294121 [ 3 ] {} <Debug> HTTP-Session: 5129be79-7ecf-4c8a-b00a-075e5e318162 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2023.12.13 05:14:46.294347 [ 3 ] {d05ee4bf-8dfc-4029-a481-65e484bbd1ab} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) /* The measurement tables contain all individual samples from each timeseries. | ||
| 295 | * | ||
| 296 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 297 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 298 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 299 | * by all samples from the same timeseries. | ||
| 300 | * | ||
| 301 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 302 | * and then uses that to index quickly into the measurements tables. | ||
| 303 | */ | ||
| 304 | 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) | ||
| 305 | 2023.12.13 05:14:46.294518 [ 3 ] {d05ee4bf-8dfc-4029-a481-65e484bbd1ab} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 306 | 2023.12.13 05:14:46.301198 [ 3 ] {d05ee4bf-8dfc-4029-a481-65e484bbd1ab} <Debug> oximeter.measurements_bool (967b58aa-30cd-4052-a429-ddd449c6491a): Loading data parts | ||
| 307 | 2023.12.13 05:14:46.301323 [ 3 ] {d05ee4bf-8dfc-4029-a481-65e484bbd1ab} <Debug> oximeter.measurements_bool (967b58aa-30cd-4052-a429-ddd449c6491a): There are no data parts | ||
| 308 | 2023.12.13 05:14:46.302612 [ 3 ] {d05ee4bf-8dfc-4029-a481-65e484bbd1ab} <Debug> DynamicQueryHandler: Done processing query | ||
| 309 | 2023.12.13 05:14:46.302637 [ 3 ] {d05ee4bf-8dfc-4029-a481-65e484bbd1ab} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 310 | 2023.12.13 05:14:46.302680 [ 3 ] {} <Debug> HTTP-Session: 5129be79-7ecf-4c8a-b00a-075e5e318162 Destroying unnamed session | ||
| 311 | 2023.12.13 05:14:46.302807 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 312 | 2023.12.13 05:14:46.302879 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 313 | 2023.12.13 05:14:46.302928 [ 3 ] {} <Debug> HTTP-Session: 5d85a7e4-8c4a-4e5c-8c81-1ac6698bec39 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 314 | 2023.12.13 05:14:46.302946 [ 3 ] {} <Debug> HTTP-Session: 5d85a7e4-8c4a-4e5c-8c81-1ac6698bec39 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 315 | 2023.12.13 05:14:46.303156 [ 3 ] {c97123a3-d390-49e3-8b39-48b99ee54997} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 316 | 2023.12.13 05:14:46.303257 [ 3 ] {c97123a3-d390-49e3-8b39-48b99ee54997} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 317 | 2023.12.13 05:14:46.304734 [ 3 ] {c97123a3-d390-49e3-8b39-48b99ee54997} <Debug> oximeter.measurements_i8 (7d295dd8-b4fb-4ef4-91ac-8cb18e48b0d6): Loading data parts | ||
| 318 | 2023.12.13 05:14:46.304848 [ 3 ] {c97123a3-d390-49e3-8b39-48b99ee54997} <Debug> oximeter.measurements_i8 (7d295dd8-b4fb-4ef4-91ac-8cb18e48b0d6): There are no data parts | ||
| 319 | 2023.12.13 05:14:46.306261 [ 3 ] {c97123a3-d390-49e3-8b39-48b99ee54997} <Debug> DynamicQueryHandler: Done processing query | ||
| 320 | 2023.12.13 05:14:46.306285 [ 3 ] {c97123a3-d390-49e3-8b39-48b99ee54997} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 321 | 2023.12.13 05:14:46.306300 [ 3 ] {} <Debug> HTTP-Session: 5d85a7e4-8c4a-4e5c-8c81-1ac6698bec39 Destroying unnamed session | ||
| 322 | 2023.12.13 05:14:46.306446 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 323 | 2023.12.13 05:14:46.306588 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 324 | 2023.12.13 05:14:46.306607 [ 3 ] {} <Debug> HTTP-Session: d8da4781-77d2-462e-a6e6-a2ef8af6148f Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 325 | 2023.12.13 05:14:46.306660 [ 3 ] {} <Debug> HTTP-Session: d8da4781-77d2-462e-a6e6-a2ef8af6148f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 326 | 2023.12.13 05:14:46.306867 [ 3 ] {c56b8b40-3b80-4b30-8951-4142c4a87c5b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 327 | 2023.12.13 05:14:46.306970 [ 3 ] {c56b8b40-3b80-4b30-8951-4142c4a87c5b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 328 | 2023.12.13 05:14:46.308448 [ 3 ] {c56b8b40-3b80-4b30-8951-4142c4a87c5b} <Debug> oximeter.measurements_u8 (252101f9-2ff3-43c6-b463-7d296cbfdb88): Loading data parts | ||
| 329 | 2023.12.13 05:14:46.308626 [ 3 ] {c56b8b40-3b80-4b30-8951-4142c4a87c5b} <Debug> oximeter.measurements_u8 (252101f9-2ff3-43c6-b463-7d296cbfdb88): There are no data parts | ||
| 330 | 2023.12.13 05:14:46.309935 [ 3 ] {c56b8b40-3b80-4b30-8951-4142c4a87c5b} <Debug> DynamicQueryHandler: Done processing query | ||
| 331 | 2023.12.13 05:14:46.309990 [ 3 ] {c56b8b40-3b80-4b30-8951-4142c4a87c5b} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 332 | 2023.12.13 05:14:46.310005 [ 3 ] {} <Debug> HTTP-Session: d8da4781-77d2-462e-a6e6-a2ef8af6148f Destroying unnamed session | ||
| 333 | 2023.12.13 05:14:46.310136 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 334 | 2023.12.13 05:14:46.310205 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 335 | 2023.12.13 05:14:46.310222 [ 3 ] {} <Debug> HTTP-Session: 92d14964-3865-4f64-8a4c-b88a25d1f4be Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 336 | 2023.12.13 05:14:46.310267 [ 3 ] {} <Debug> HTTP-Session: 92d14964-3865-4f64-8a4c-b88a25d1f4be Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 337 | 2023.12.13 05:14:46.310543 [ 3 ] {660c1887-9a2a-4f11-b650-a34193dcf769} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 338 | 2023.12.13 05:14:46.310617 [ 3 ] {660c1887-9a2a-4f11-b650-a34193dcf769} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 339 | 2023.12.13 05:14:46.314303 [ 3 ] {660c1887-9a2a-4f11-b650-a34193dcf769} <Debug> oximeter.measurements_i16 (c9050b50-bedf-47ed-8232-a9f84dc8a3fc): Loading data parts | ||
| 340 | 2023.12.13 05:14:46.314410 [ 3 ] {660c1887-9a2a-4f11-b650-a34193dcf769} <Debug> oximeter.measurements_i16 (c9050b50-bedf-47ed-8232-a9f84dc8a3fc): There are no data parts | ||
| 341 | 2023.12.13 05:14:46.315771 [ 3 ] {660c1887-9a2a-4f11-b650-a34193dcf769} <Debug> DynamicQueryHandler: Done processing query | ||
| 342 | 2023.12.13 05:14:46.315843 [ 3 ] {660c1887-9a2a-4f11-b650-a34193dcf769} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 343 | 2023.12.13 05:14:46.315860 [ 3 ] {} <Debug> HTTP-Session: 92d14964-3865-4f64-8a4c-b88a25d1f4be Destroying unnamed session | ||
| 344 | 2023.12.13 05:14:46.316029 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 345 | 2023.12.13 05:14:46.316108 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 346 | 2023.12.13 05:14:46.316126 [ 3 ] {} <Debug> HTTP-Session: b90a4dd1-23f7-48a5-bb52-476ecb4a48fa Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 347 | 2023.12.13 05:14:46.316180 [ 3 ] {} <Debug> HTTP-Session: b90a4dd1-23f7-48a5-bb52-476ecb4a48fa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 348 | 2023.12.13 05:14:46.316553 [ 3 ] {7d1649c3-9c5e-4fa4-8776-f4f10e6fd0f0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 349 | 2023.12.13 05:14:46.316686 [ 3 ] {7d1649c3-9c5e-4fa4-8776-f4f10e6fd0f0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 350 | 2023.12.13 05:14:46.318205 [ 3 ] {7d1649c3-9c5e-4fa4-8776-f4f10e6fd0f0} <Debug> oximeter.measurements_u16 (96619ef0-e572-48ff-9851-6828feca942f): Loading data parts | ||
| 351 | 2023.12.13 05:14:46.318282 [ 3 ] {7d1649c3-9c5e-4fa4-8776-f4f10e6fd0f0} <Debug> oximeter.measurements_u16 (96619ef0-e572-48ff-9851-6828feca942f): There are no data parts | ||
| 352 | 2023.12.13 05:14:46.319801 [ 3 ] {7d1649c3-9c5e-4fa4-8776-f4f10e6fd0f0} <Debug> DynamicQueryHandler: Done processing query | ||
| 353 | 2023.12.13 05:14:46.319856 [ 3 ] {7d1649c3-9c5e-4fa4-8776-f4f10e6fd0f0} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 354 | 2023.12.13 05:14:46.319871 [ 3 ] {} <Debug> HTTP-Session: b90a4dd1-23f7-48a5-bb52-476ecb4a48fa Destroying unnamed session | ||
| 355 | 2023.12.13 05:14:46.320056 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 356 | 2023.12.13 05:14:46.320149 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 357 | 2023.12.13 05:14:46.320173 [ 3 ] {} <Debug> HTTP-Session: 8a67263f-d525-46e3-8cd2-15ecc0f8ae32 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 358 | 2023.12.13 05:14:46.320224 [ 3 ] {} <Debug> HTTP-Session: 8a67263f-d525-46e3-8cd2-15ecc0f8ae32 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 359 | 2023.12.13 05:14:46.320445 [ 3 ] {62d5364e-a99b-48d0-8cf4-52d32017693a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 360 | 2023.12.13 05:14:46.320580 [ 3 ] {62d5364e-a99b-48d0-8cf4-52d32017693a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 361 | 2023.12.13 05:14:46.322069 [ 3 ] {62d5364e-a99b-48d0-8cf4-52d32017693a} <Debug> oximeter.measurements_i32 (dda2cf37-e5c7-4ea9-a7b8-641f44a746dc): Loading data parts | ||
| 362 | 2023.12.13 05:14:46.322149 [ 3 ] {62d5364e-a99b-48d0-8cf4-52d32017693a} <Debug> oximeter.measurements_i32 (dda2cf37-e5c7-4ea9-a7b8-641f44a746dc): There are no data parts | ||
| 363 | 2023.12.13 05:14:46.323306 [ 3 ] {62d5364e-a99b-48d0-8cf4-52d32017693a} <Debug> DynamicQueryHandler: Done processing query | ||
| 364 | 2023.12.13 05:14:46.323364 [ 3 ] {62d5364e-a99b-48d0-8cf4-52d32017693a} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 365 | 2023.12.13 05:14:46.323380 [ 3 ] {} <Debug> HTTP-Session: 8a67263f-d525-46e3-8cd2-15ecc0f8ae32 Destroying unnamed session | ||
| 366 | 2023.12.13 05:14:46.323572 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 367 | 2023.12.13 05:14:46.323674 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 368 | 2023.12.13 05:14:46.323694 [ 3 ] {} <Debug> HTTP-Session: d3bfaa95-b3dd-4ab0-83a1-39e2e9ee3982 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 369 | 2023.12.13 05:14:46.323741 [ 3 ] {} <Debug> HTTP-Session: d3bfaa95-b3dd-4ab0-83a1-39e2e9ee3982 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 370 | 2023.12.13 05:14:46.323918 [ 3 ] {0fe8dfba-50b2-4064-bd58-60e55b867fb5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 371 | 2023.12.13 05:14:46.324021 [ 3 ] {0fe8dfba-50b2-4064-bd58-60e55b867fb5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 372 | 2023.12.13 05:14:46.325647 [ 3 ] {0fe8dfba-50b2-4064-bd58-60e55b867fb5} <Debug> oximeter.measurements_u32 (46dfda48-76c4-4931-a1ed-bf27d35a02ee): Loading data parts | ||
| 373 | 2023.12.13 05:14:46.325728 [ 3 ] {0fe8dfba-50b2-4064-bd58-60e55b867fb5} <Debug> oximeter.measurements_u32 (46dfda48-76c4-4931-a1ed-bf27d35a02ee): There are no data parts | ||
| 374 | 2023.12.13 05:14:46.327194 [ 3 ] {0fe8dfba-50b2-4064-bd58-60e55b867fb5} <Debug> DynamicQueryHandler: Done processing query | ||
| 375 | 2023.12.13 05:14:46.327250 [ 3 ] {0fe8dfba-50b2-4064-bd58-60e55b867fb5} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 376 | 2023.12.13 05:14:46.327266 [ 3 ] {} <Debug> HTTP-Session: d3bfaa95-b3dd-4ab0-83a1-39e2e9ee3982 Destroying unnamed session | ||
| 377 | 2023.12.13 05:14:46.327384 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 378 | 2023.12.13 05:14:46.327510 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 379 | 2023.12.13 05:14:46.327607 [ 3 ] {} <Debug> HTTP-Session: 8ed04334-b61f-4d5c-82a3-ad14c242e0dd Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 380 | 2023.12.13 05:14:46.327622 [ 3 ] {} <Debug> HTTP-Session: 8ed04334-b61f-4d5c-82a3-ad14c242e0dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 381 | 2023.12.13 05:14:46.327857 [ 3 ] {bced51e9-4fd8-420e-80ce-454616c22a86} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 382 | 2023.12.13 05:14:46.327959 [ 3 ] {bced51e9-4fd8-420e-80ce-454616c22a86} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 383 | 2023.12.13 05:14:46.329461 [ 3 ] {bced51e9-4fd8-420e-80ce-454616c22a86} <Debug> oximeter.measurements_i64 (81d55abf-ab1f-4dd7-a03d-ee9260c0e9fe): Loading data parts | ||
| 384 | 2023.12.13 05:14:46.329621 [ 3 ] {bced51e9-4fd8-420e-80ce-454616c22a86} <Debug> oximeter.measurements_i64 (81d55abf-ab1f-4dd7-a03d-ee9260c0e9fe): There are no data parts | ||
| 385 | 2023.12.13 05:14:46.331130 [ 3 ] {bced51e9-4fd8-420e-80ce-454616c22a86} <Debug> DynamicQueryHandler: Done processing query | ||
| 386 | 2023.12.13 05:14:46.331156 [ 3 ] {bced51e9-4fd8-420e-80ce-454616c22a86} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 387 | 2023.12.13 05:14:46.331206 [ 3 ] {} <Debug> HTTP-Session: 8ed04334-b61f-4d5c-82a3-ad14c242e0dd Destroying unnamed session | ||
| 388 | 2023.12.13 05:14:46.331323 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 389 | 2023.12.13 05:14:46.331395 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 390 | 2023.12.13 05:14:46.331446 [ 3 ] {} <Debug> HTTP-Session: 9130bde3-5b91-4605-98c6-f464c7b314be Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 391 | 2023.12.13 05:14:46.331461 [ 3 ] {} <Debug> HTTP-Session: 9130bde3-5b91-4605-98c6-f464c7b314be Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 392 | 2023.12.13 05:14:46.331741 [ 3 ] {4decb962-2933-4845-8f02-96bc3a7cebec} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 393 | 2023.12.13 05:14:46.331843 [ 3 ] {4decb962-2933-4845-8f02-96bc3a7cebec} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 394 | 2023.12.13 05:14:46.333302 [ 3 ] {4decb962-2933-4845-8f02-96bc3a7cebec} <Debug> oximeter.measurements_u64 (351ff0b4-0e8c-4b04-906e-9057862e5fec): Loading data parts | ||
| 395 | 2023.12.13 05:14:46.333375 [ 3 ] {4decb962-2933-4845-8f02-96bc3a7cebec} <Debug> oximeter.measurements_u64 (351ff0b4-0e8c-4b04-906e-9057862e5fec): There are no data parts | ||
| 396 | 2023.12.13 05:14:46.334483 [ 3 ] {4decb962-2933-4845-8f02-96bc3a7cebec} <Debug> DynamicQueryHandler: Done processing query | ||
| 397 | 2023.12.13 05:14:46.334506 [ 3 ] {4decb962-2933-4845-8f02-96bc3a7cebec} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 398 | 2023.12.13 05:14:46.334631 [ 3 ] {} <Debug> HTTP-Session: 9130bde3-5b91-4605-98c6-f464c7b314be Destroying unnamed session | ||
| 399 | 2023.12.13 05:14:46.334753 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 400 | 2023.12.13 05:14:46.334826 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 401 | 2023.12.13 05:14:46.334879 [ 3 ] {} <Debug> HTTP-Session: cefe3bdc-7391-4ad9-8fb9-b021da6d11cf Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 402 | 2023.12.13 05:14:46.334895 [ 3 ] {} <Debug> HTTP-Session: cefe3bdc-7391-4ad9-8fb9-b021da6d11cf Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 403 | 2023.12.13 05:14:46.335099 [ 3 ] {54d0b703-9b98-4750-ac61-5d977b7933ed} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 404 | 2023.12.13 05:14:46.335203 [ 3 ] {54d0b703-9b98-4750-ac61-5d977b7933ed} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 405 | 2023.12.13 05:14:46.337144 [ 3 ] {54d0b703-9b98-4750-ac61-5d977b7933ed} <Debug> oximeter.measurements_f32 (8275eb07-21cb-4908-8d88-b93b1ba3d430): Loading data parts | ||
| 406 | 2023.12.13 05:14:46.337257 [ 3 ] {54d0b703-9b98-4750-ac61-5d977b7933ed} <Debug> oximeter.measurements_f32 (8275eb07-21cb-4908-8d88-b93b1ba3d430): There are no data parts | ||
| 407 | 2023.12.13 05:14:46.338443 [ 3 ] {54d0b703-9b98-4750-ac61-5d977b7933ed} <Debug> DynamicQueryHandler: Done processing query | ||
| 408 | 2023.12.13 05:14:46.338467 [ 3 ] {54d0b703-9b98-4750-ac61-5d977b7933ed} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 409 | 2023.12.13 05:14:46.338520 [ 3 ] {} <Debug> HTTP-Session: cefe3bdc-7391-4ad9-8fb9-b021da6d11cf Destroying unnamed session | ||
| 410 | 2023.12.13 05:14:46.338709 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 411 | 2023.12.13 05:14:46.338781 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 412 | 2023.12.13 05:14:46.338832 [ 3 ] {} <Debug> HTTP-Session: 4ff424f6-3e33-4edf-a832-676f036aeab6 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 413 | 2023.12.13 05:14:46.338847 [ 3 ] {} <Debug> HTTP-Session: 4ff424f6-3e33-4edf-a832-676f036aeab6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 414 | 2023.12.13 05:14:46.339050 [ 3 ] {8834f569-7512-4423-b568-4a29a2d48b38} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 415 | 2023.12.13 05:14:46.339122 [ 3 ] {8834f569-7512-4423-b568-4a29a2d48b38} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 416 | 2023.12.13 05:14:46.341682 [ 3 ] {8834f569-7512-4423-b568-4a29a2d48b38} <Debug> oximeter.measurements_f64 (37d9bd71-14cd-467a-b071-083458795507): Loading data parts | ||
| 417 | 2023.12.13 05:14:46.341790 [ 3 ] {8834f569-7512-4423-b568-4a29a2d48b38} <Debug> oximeter.measurements_f64 (37d9bd71-14cd-467a-b071-083458795507): There are no data parts | ||
| 418 | 2023.12.13 05:14:46.343013 [ 3 ] {8834f569-7512-4423-b568-4a29a2d48b38} <Debug> DynamicQueryHandler: Done processing query | ||
| 419 | 2023.12.13 05:14:46.343073 [ 3 ] {8834f569-7512-4423-b568-4a29a2d48b38} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 420 | 2023.12.13 05:14:46.343125 [ 3 ] {} <Debug> HTTP-Session: 4ff424f6-3e33-4edf-a832-676f036aeab6 Destroying unnamed session | ||
| 421 | 2023.12.13 05:14:46.343228 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 422 | 2023.12.13 05:14:46.343308 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 423 | 2023.12.13 05:14:46.343366 [ 3 ] {} <Debug> HTTP-Session: c110103d-201e-4d21-ac59-9aad88b7b90b Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 424 | 2023.12.13 05:14:46.343382 [ 3 ] {} <Debug> HTTP-Session: c110103d-201e-4d21-ac59-9aad88b7b90b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 425 | 2023.12.13 05:14:46.343653 [ 3 ] {1a62b3e1-0a94-4aad-bb18-b4ffb6d93f32} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 426 | 2023.12.13 05:14:46.343729 [ 3 ] {1a62b3e1-0a94-4aad-bb18-b4ffb6d93f32} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 427 | 2023.12.13 05:14:46.345439 [ 3 ] {1a62b3e1-0a94-4aad-bb18-b4ffb6d93f32} <Debug> oximeter.measurements_string (ad9eeedf-2be2-4c79-ab9e-bc2e76fd2e28): Loading data parts | ||
| 428 | 2023.12.13 05:14:46.345639 [ 3 ] {1a62b3e1-0a94-4aad-bb18-b4ffb6d93f32} <Debug> oximeter.measurements_string (ad9eeedf-2be2-4c79-ab9e-bc2e76fd2e28): There are no data parts | ||
| 429 | 2023.12.13 05:14:46.347567 [ 3 ] {1a62b3e1-0a94-4aad-bb18-b4ffb6d93f32} <Debug> DynamicQueryHandler: Done processing query | ||
| 430 | 2023.12.13 05:14:46.347697 [ 3 ] {1a62b3e1-0a94-4aad-bb18-b4ffb6d93f32} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 431 | 2023.12.13 05:14:46.347751 [ 3 ] {} <Debug> HTTP-Session: c110103d-201e-4d21-ac59-9aad88b7b90b Destroying unnamed session | ||
| 432 | 2023.12.13 05:14:46.347876 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 433 | 2023.12.13 05:14:46.347951 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 434 | 2023.12.13 05:14:46.348010 [ 3 ] {} <Debug> HTTP-Session: 64759ec0-3bd7-4d8a-8548-862e41ff1995 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 435 | 2023.12.13 05:14:46.348026 [ 3 ] {} <Debug> HTTP-Session: 64759ec0-3bd7-4d8a-8548-862e41ff1995 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 436 | 2023.12.13 05:14:46.348236 [ 3 ] {2ded2944-3fe4-419b-9b00-1275a2ca343a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 437 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 438 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 439 | * a string isn't palatable for a few reasons. | ||
| 440 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 441 | * details. | ||
| 442 | */ | ||
| 443 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 444 | 2023.12.13 05:14:46.348397 [ 3 ] {2ded2944-3fe4-419b-9b00-1275a2ca343a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 445 | 2023.12.13 05:14:46.350191 [ 3 ] {2ded2944-3fe4-419b-9b00-1275a2ca343a} <Debug> oximeter.measurements_bytes (5c7e1388-9d59-461b-be57-396caa0678c3): Loading data parts | ||
| 446 | 2023.12.13 05:14:46.350304 [ 3 ] {2ded2944-3fe4-419b-9b00-1275a2ca343a} <Debug> oximeter.measurements_bytes (5c7e1388-9d59-461b-be57-396caa0678c3): There are no data parts | ||
| 447 | 2023.12.13 05:14:46.351800 [ 3 ] {2ded2944-3fe4-419b-9b00-1275a2ca343a} <Debug> DynamicQueryHandler: Done processing query | ||
| 448 | 2023.12.13 05:14:46.351824 [ 3 ] {2ded2944-3fe4-419b-9b00-1275a2ca343a} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 449 | 2023.12.13 05:14:46.351839 [ 3 ] {} <Debug> HTTP-Session: 64759ec0-3bd7-4d8a-8548-862e41ff1995 Destroying unnamed session | ||
| 450 | 2023.12.13 05:14:46.351978 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 451 | 2023.12.13 05:14:46.352054 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 452 | 2023.12.13 05:14:46.352073 [ 3 ] {} <Debug> HTTP-Session: 8e07db14-f2c5-4a8c-bea3-14151caebb94 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 453 | 2023.12.13 05:14:46.352121 [ 3 ] {} <Debug> HTTP-Session: 8e07db14-f2c5-4a8c-bea3-14151caebb94 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 454 | 2023.12.13 05:14:46.352346 [ 3 ] {fdf726d6-f8ec-4e35-b74f-0dd8df002a02} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 455 | 2023.12.13 05:14:46.352453 [ 3 ] {fdf726d6-f8ec-4e35-b74f-0dd8df002a02} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 456 | 2023.12.13 05:14:46.354517 [ 3 ] {fdf726d6-f8ec-4e35-b74f-0dd8df002a02} <Debug> oximeter.measurements_cumulativei64 (646aa2c5-730b-4a50-aed5-b66ef822de54): Loading data parts | ||
| 457 | 2023.12.13 05:14:46.354719 [ 3 ] {fdf726d6-f8ec-4e35-b74f-0dd8df002a02} <Debug> oximeter.measurements_cumulativei64 (646aa2c5-730b-4a50-aed5-b66ef822de54): There are no data parts | ||
| 458 | 2023.12.13 05:14:46.355870 [ 3 ] {fdf726d6-f8ec-4e35-b74f-0dd8df002a02} <Debug> DynamicQueryHandler: Done processing query | ||
| 459 | 2023.12.13 05:14:46.355894 [ 3 ] {fdf726d6-f8ec-4e35-b74f-0dd8df002a02} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 460 | 2023.12.13 05:14:46.355943 [ 3 ] {} <Debug> HTTP-Session: 8e07db14-f2c5-4a8c-bea3-14151caebb94 Destroying unnamed session | ||
| 461 | 2023.12.13 05:14:46.356050 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 462 | 2023.12.13 05:14:46.356124 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 463 | 2023.12.13 05:14:46.356175 [ 3 ] {} <Debug> HTTP-Session: 6890e4ed-b4ca-4f08-ad1b-4c7d092c70bc Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 464 | 2023.12.13 05:14:46.356192 [ 3 ] {} <Debug> HTTP-Session: 6890e4ed-b4ca-4f08-ad1b-4c7d092c70bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 465 | 2023.12.13 05:14:46.356415 [ 3 ] {5e6e1c5b-30c7-4987-919b-c39e75e0a18c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 466 | 2023.12.13 05:14:46.356523 [ 3 ] {5e6e1c5b-30c7-4987-919b-c39e75e0a18c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 467 | 2023.12.13 05:14:46.358022 [ 3 ] {5e6e1c5b-30c7-4987-919b-c39e75e0a18c} <Debug> oximeter.measurements_cumulativeu64 (e26c1ae0-4a78-4ce6-b62f-4ef279ce0329): Loading data parts | ||
| 468 | 2023.12.13 05:14:46.358102 [ 3 ] {5e6e1c5b-30c7-4987-919b-c39e75e0a18c} <Debug> oximeter.measurements_cumulativeu64 (e26c1ae0-4a78-4ce6-b62f-4ef279ce0329): There are no data parts | ||
| 469 | 2023.12.13 05:14:46.359368 [ 3 ] {5e6e1c5b-30c7-4987-919b-c39e75e0a18c} <Debug> DynamicQueryHandler: Done processing query | ||
| 470 | 2023.12.13 05:14:46.359392 [ 3 ] {5e6e1c5b-30c7-4987-919b-c39e75e0a18c} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 471 | 2023.12.13 05:14:46.359440 [ 3 ] {} <Debug> HTTP-Session: 6890e4ed-b4ca-4f08-ad1b-4c7d092c70bc Destroying unnamed session | ||
| 472 | 2023.12.13 05:14:46.359575 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 473 | 2023.12.13 05:14:46.359685 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 474 | 2023.12.13 05:14:46.359737 [ 3 ] {} <Debug> HTTP-Session: 15f1f248-2790-4939-8fab-af263e535710 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 475 | 2023.12.13 05:14:46.359785 [ 3 ] {} <Debug> HTTP-Session: 15f1f248-2790-4939-8fab-af263e535710 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 476 | 2023.12.13 05:14:46.359992 [ 3 ] {e9ee381e-3951-403e-b51a-86dba27b35eb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 477 | 2023.12.13 05:14:46.360108 [ 3 ] {e9ee381e-3951-403e-b51a-86dba27b35eb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 478 | 2023.12.13 05:14:46.361768 [ 3 ] {e9ee381e-3951-403e-b51a-86dba27b35eb} <Debug> oximeter.measurements_cumulativef32 (7bdcb2e5-6aea-4114-b42d-571ca80b2ef4): Loading data parts | ||
| 479 | 2023.12.13 05:14:46.361889 [ 3 ] {e9ee381e-3951-403e-b51a-86dba27b35eb} <Debug> oximeter.measurements_cumulativef32 (7bdcb2e5-6aea-4114-b42d-571ca80b2ef4): There are no data parts | ||
| 480 | 2023.12.13 05:14:46.363260 [ 3 ] {e9ee381e-3951-403e-b51a-86dba27b35eb} <Debug> DynamicQueryHandler: Done processing query | ||
| 481 | 2023.12.13 05:14:46.363321 [ 3 ] {e9ee381e-3951-403e-b51a-86dba27b35eb} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 482 | 2023.12.13 05:14:46.363339 [ 3 ] {} <Debug> HTTP-Session: 15f1f248-2790-4939-8fab-af263e535710 Destroying unnamed session | ||
| 483 | 2023.12.13 05:14:46.363505 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 484 | 2023.12.13 05:14:46.363579 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 485 | 2023.12.13 05:14:46.363600 [ 3 ] {} <Debug> HTTP-Session: d6ddbaba-ac89-45e8-8a8a-bded4315b5d5 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 486 | 2023.12.13 05:14:46.363716 [ 3 ] {} <Debug> HTTP-Session: d6ddbaba-ac89-45e8-8a8a-bded4315b5d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 487 | 2023.12.13 05:14:46.363913 [ 3 ] {ab61ae42-3a65-410c-982b-cc7c226e2eef} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) | ||
| 488 | 2023.12.13 05:14:46.364019 [ 3 ] {ab61ae42-3a65-410c-982b-cc7c226e2eef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 489 | 2023.12.13 05:14:46.366124 [ 3 ] {ab61ae42-3a65-410c-982b-cc7c226e2eef} <Debug> oximeter.measurements_cumulativef64 (ef9824e9-5097-4abe-9a4c-0887767abc05): Loading data parts | ||
| 490 | 2023.12.13 05:14:46.366243 [ 3 ] {ab61ae42-3a65-410c-982b-cc7c226e2eef} <Debug> oximeter.measurements_cumulativef64 (ef9824e9-5097-4abe-9a4c-0887767abc05): There are no data parts | ||
| 491 | 2023.12.13 05:14:46.367616 [ 3 ] {ab61ae42-3a65-410c-982b-cc7c226e2eef} <Debug> DynamicQueryHandler: Done processing query | ||
| 492 | 2023.12.13 05:14:46.367745 [ 3 ] {ab61ae42-3a65-410c-982b-cc7c226e2eef} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 493 | 2023.12.13 05:14:46.367795 [ 3 ] {} <Debug> HTTP-Session: d6ddbaba-ac89-45e8-8a8a-bded4315b5d5 Destroying unnamed session | ||
| 494 | 2023.12.13 05:14:46.367928 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 836, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 495 | 2023.12.13 05:14:46.368006 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 496 | 2023.12.13 05:14:46.368114 [ 3 ] {} <Debug> HTTP-Session: d2b233fb-1549-46a3-b0bf-202720066925 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 497 | 2023.12.13 05:14:46.368129 [ 3 ] {} <Debug> HTTP-Session: d2b233fb-1549-46a3-b0bf-202720066925 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 498 | 2023.12.13 05:14:46.368364 [ 3 ] {bdbb97e5-deda-49d2-bb3c-d4472cfa6d84} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 499 | * NOTE: Array types cannot be Nullable, see | ||
| 500 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 501 | * for more details. | ||
| 502 | * | ||
| 503 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 504 | * is unfortunate, and at this point relies on the fact that an | ||
| 505 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 506 | * to figure out another way to represent missing samples here. | ||
| 507 | */ | ||
| 508 | bins Array(Int8), counts Array(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 509 | 2023.12.13 05:14:46.368478 [ 3 ] {bdbb97e5-deda-49d2-bb3c-d4472cfa6d84} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 510 | 2023.12.13 05:14:46.370041 [ 3 ] {bdbb97e5-deda-49d2-bb3c-d4472cfa6d84} <Debug> oximeter.measurements_histogrami8 (da731fc8-c6e3-4bf6-b6aa-e00118f7e466): Loading data parts | ||
| 511 | 2023.12.13 05:14:46.370155 [ 3 ] {bdbb97e5-deda-49d2-bb3c-d4472cfa6d84} <Debug> oximeter.measurements_histogrami8 (da731fc8-c6e3-4bf6-b6aa-e00118f7e466): There are no data parts | ||
| 512 | 2023.12.13 05:14:46.371213 [ 3 ] {bdbb97e5-deda-49d2-bb3c-d4472cfa6d84} <Debug> DynamicQueryHandler: Done processing query | ||
| 513 | 2023.12.13 05:14:46.371276 [ 3 ] {bdbb97e5-deda-49d2-bb3c-d4472cfa6d84} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 514 | 2023.12.13 05:14:46.371326 [ 3 ] {} <Debug> HTTP-Session: d2b233fb-1549-46a3-b0bf-202720066925 Destroying unnamed session | ||
| 515 | 2023.12.13 05:14:46.371443 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 373, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 516 | 2023.12.13 05:14:46.371515 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 517 | 2023.12.13 05:14:46.371566 [ 3 ] {} <Debug> HTTP-Session: 76f6cf07-66e0-4b84-bfdb-2e78fa9073c4 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 518 | 2023.12.13 05:14:46.371581 [ 3 ] {} <Debug> HTTP-Session: 76f6cf07-66e0-4b84-bfdb-2e78fa9073c4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 519 | 2023.12.13 05:14:46.371875 [ 3 ] {8558e373-9781-488f-bbc5-73d47ac17cb4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 520 | 2023.12.13 05:14:46.371984 [ 3 ] {8558e373-9781-488f-bbc5-73d47ac17cb4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 521 | 2023.12.13 05:14:46.373446 [ 3 ] {8558e373-9781-488f-bbc5-73d47ac17cb4} <Debug> oximeter.measurements_histogramu8 (25511f21-4794-40b7-809b-69728be19174): Loading data parts | ||
| 522 | 2023.12.13 05:14:46.373558 [ 3 ] {8558e373-9781-488f-bbc5-73d47ac17cb4} <Debug> oximeter.measurements_histogramu8 (25511f21-4794-40b7-809b-69728be19174): There are no data parts | ||
| 523 | 2023.12.13 05:14:46.374790 [ 3 ] {8558e373-9781-488f-bbc5-73d47ac17cb4} <Debug> DynamicQueryHandler: Done processing query | ||
| 524 | 2023.12.13 05:14:46.374814 [ 3 ] {8558e373-9781-488f-bbc5-73d47ac17cb4} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 525 | 2023.12.13 05:14:46.374873 [ 3 ] {} <Debug> HTTP-Session: 76f6cf07-66e0-4b84-bfdb-2e78fa9073c4 Destroying unnamed session | ||
| 526 | 2023.12.13 05:14:46.374987 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 374, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 527 | 2023.12.13 05:14:46.375067 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 528 | 2023.12.13 05:14:46.375124 [ 3 ] {} <Debug> HTTP-Session: 9a052a96-51a8-479d-b6d4-87781d1b2831 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 529 | 2023.12.13 05:14:46.375139 [ 3 ] {} <Debug> HTTP-Session: 9a052a96-51a8-479d-b6d4-87781d1b2831 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 530 | 2023.12.13 05:14:46.375376 [ 3 ] {829d07c6-884a-4620-bc28-3aa827451155} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 531 | 2023.12.13 05:14:46.375485 [ 3 ] {829d07c6-884a-4620-bc28-3aa827451155} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 532 | 2023.12.13 05:14:46.377121 [ 3 ] {829d07c6-884a-4620-bc28-3aa827451155} <Debug> oximeter.measurements_histogrami16 (06aaeb60-9ac4-45dd-ae5d-50ab85a5dba1): Loading data parts | ||
| 533 | 2023.12.13 05:14:46.377208 [ 3 ] {829d07c6-884a-4620-bc28-3aa827451155} <Debug> oximeter.measurements_histogrami16 (06aaeb60-9ac4-45dd-ae5d-50ab85a5dba1): There are no data parts | ||
| 534 | 2023.12.13 05:14:46.378378 [ 3 ] {829d07c6-884a-4620-bc28-3aa827451155} <Debug> DynamicQueryHandler: Done processing query | ||
| 535 | 2023.12.13 05:14:46.378444 [ 3 ] {829d07c6-884a-4620-bc28-3aa827451155} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 536 | 2023.12.13 05:14:46.378459 [ 3 ] {} <Debug> HTTP-Session: 9a052a96-51a8-479d-b6d4-87781d1b2831 Destroying unnamed session | ||
| 537 | 2023.12.13 05:14:46.378563 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 375, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 538 | 2023.12.13 05:14:46.378734 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 539 | 2023.12.13 05:14:46.378753 [ 3 ] {} <Debug> HTTP-Session: 8e23d4ae-8afe-4493-9751-61cbb9f865b3 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 540 | 2023.12.13 05:14:46.378805 [ 3 ] {} <Debug> HTTP-Session: 8e23d4ae-8afe-4493-9751-61cbb9f865b3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 541 | 2023.12.13 05:14:46.379000 [ 3 ] {ef005752-3379-4f24-8c3e-4c99f1da0648} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 542 | 2023.12.13 05:14:46.379162 [ 3 ] {ef005752-3379-4f24-8c3e-4c99f1da0648} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 543 | 2023.12.13 05:14:46.380640 [ 3 ] {ef005752-3379-4f24-8c3e-4c99f1da0648} <Debug> oximeter.measurements_histogramu16 (b93125e9-9674-4030-8e9d-877cc90324ef): Loading data parts | ||
| 544 | 2023.12.13 05:14:46.380833 [ 3 ] {ef005752-3379-4f24-8c3e-4c99f1da0648} <Debug> oximeter.measurements_histogramu16 (b93125e9-9674-4030-8e9d-877cc90324ef): There are no data parts | ||
| 545 | 2023.12.13 05:14:46.382528 [ 3 ] {ef005752-3379-4f24-8c3e-4c99f1da0648} <Debug> DynamicQueryHandler: Done processing query | ||
| 546 | 2023.12.13 05:14:46.382592 [ 3 ] {ef005752-3379-4f24-8c3e-4c99f1da0648} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 547 | 2023.12.13 05:14:46.382606 [ 3 ] {} <Debug> HTTP-Session: 8e23d4ae-8afe-4493-9751-61cbb9f865b3 Destroying unnamed session | ||
| 548 | 2023.12.13 05:14:46.382833 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 374, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 549 | 2023.12.13 05:14:46.382917 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 550 | 2023.12.13 05:14:46.382935 [ 3 ] {} <Debug> HTTP-Session: af997695-4bf5-4683-a68d-48df9279bd93 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 551 | 2023.12.13 05:14:46.382984 [ 3 ] {} <Debug> HTTP-Session: af997695-4bf5-4683-a68d-48df9279bd93 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 552 | 2023.12.13 05:14:46.383220 [ 3 ] {673e41e0-12a7-4e2b-824a-e5d409060b37} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 553 | 2023.12.13 05:14:46.383329 [ 3 ] {673e41e0-12a7-4e2b-824a-e5d409060b37} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 554 | 2023.12.13 05:14:46.384942 [ 3 ] {673e41e0-12a7-4e2b-824a-e5d409060b37} <Debug> oximeter.measurements_histogrami32 (ca8e08af-ccb2-4226-adf7-21d7451a4c29): Loading data parts | ||
| 555 | 2023.12.13 05:14:46.385064 [ 3 ] {673e41e0-12a7-4e2b-824a-e5d409060b37} <Debug> oximeter.measurements_histogrami32 (ca8e08af-ccb2-4226-adf7-21d7451a4c29): There are no data parts | ||
| 556 | 2023.12.13 05:14:46.386215 [ 3 ] {673e41e0-12a7-4e2b-824a-e5d409060b37} <Debug> DynamicQueryHandler: Done processing query | ||
| 557 | 2023.12.13 05:14:46.386239 [ 3 ] {673e41e0-12a7-4e2b-824a-e5d409060b37} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 558 | 2023.12.13 05:14:46.386290 [ 3 ] {} <Debug> HTTP-Session: af997695-4bf5-4683-a68d-48df9279bd93 Destroying unnamed session | ||
| 559 | 2023.12.13 05:14:46.386405 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 375, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 560 | 2023.12.13 05:14:46.386485 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 561 | 2023.12.13 05:14:46.386504 [ 3 ] {} <Debug> HTTP-Session: c683c342-2303-44be-9941-6a9a918f9463 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 562 | 2023.12.13 05:14:46.386621 [ 3 ] {} <Debug> HTTP-Session: c683c342-2303-44be-9941-6a9a918f9463 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 563 | 2023.12.13 05:14:46.386930 [ 3 ] {174fb397-e0e1-48c5-b4c8-6d25206a4490} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 564 | 2023.12.13 05:14:46.387043 [ 3 ] {174fb397-e0e1-48c5-b4c8-6d25206a4490} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 565 | 2023.12.13 05:14:46.388620 [ 3 ] {174fb397-e0e1-48c5-b4c8-6d25206a4490} <Debug> oximeter.measurements_histogramu32 (31d9f383-969e-4767-83df-5f0e7d70e77c): Loading data parts | ||
| 566 | 2023.12.13 05:14:46.388823 [ 3 ] {174fb397-e0e1-48c5-b4c8-6d25206a4490} <Debug> oximeter.measurements_histogramu32 (31d9f383-969e-4767-83df-5f0e7d70e77c): There are no data parts | ||
| 567 | 2023.12.13 05:14:46.390125 [ 3 ] {174fb397-e0e1-48c5-b4c8-6d25206a4490} <Debug> DynamicQueryHandler: Done processing query | ||
| 568 | 2023.12.13 05:14:46.390154 [ 3 ] {174fb397-e0e1-48c5-b4c8-6d25206a4490} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 569 | 2023.12.13 05:14:46.390207 [ 3 ] {} <Debug> HTTP-Session: c683c342-2303-44be-9941-6a9a918f9463 Destroying unnamed session | ||
| 570 | 2023.12.13 05:14:46.390326 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 374, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 571 | 2023.12.13 05:14:46.390406 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 572 | 2023.12.13 05:14:46.390457 [ 3 ] {} <Debug> HTTP-Session: 510f438f-0078-48b6-bbf4-c6df4d7abc99 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 573 | 2023.12.13 05:14:46.390508 [ 3 ] {} <Debug> HTTP-Session: 510f438f-0078-48b6-bbf4-c6df4d7abc99 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 574 | 2023.12.13 05:14:46.390778 [ 3 ] {c0aa386d-8c03-4398-a7cf-8ba0e095ec83} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 575 | 2023.12.13 05:14:46.390902 [ 3 ] {c0aa386d-8c03-4398-a7cf-8ba0e095ec83} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 576 | 2023.12.13 05:14:46.392861 [ 3 ] {c0aa386d-8c03-4398-a7cf-8ba0e095ec83} <Debug> oximeter.measurements_histogrami64 (5fa456e0-751c-493e-8632-5c228ccd9364): Loading data parts | ||
| 577 | 2023.12.13 05:14:46.392979 [ 3 ] {c0aa386d-8c03-4398-a7cf-8ba0e095ec83} <Debug> oximeter.measurements_histogrami64 (5fa456e0-751c-493e-8632-5c228ccd9364): There are no data parts | ||
| 578 | 2023.12.13 05:14:46.394110 [ 3 ] {c0aa386d-8c03-4398-a7cf-8ba0e095ec83} <Debug> DynamicQueryHandler: Done processing query | ||
| 579 | 2023.12.13 05:14:46.394170 [ 3 ] {c0aa386d-8c03-4398-a7cf-8ba0e095ec83} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 580 | 2023.12.13 05:14:46.394185 [ 3 ] {} <Debug> HTTP-Session: 510f438f-0078-48b6-bbf4-c6df4d7abc99 Destroying unnamed session | ||
| 581 | 2023.12.13 05:14:46.394324 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 375, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 582 | 2023.12.13 05:14:46.394397 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 583 | 2023.12.13 05:14:46.394416 [ 3 ] {} <Debug> HTTP-Session: 12185a35-5a5a-4e42-8241-af15919ba114 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 584 | 2023.12.13 05:14:46.394465 [ 3 ] {} <Debug> HTTP-Session: 12185a35-5a5a-4e42-8241-af15919ba114 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 585 | 2023.12.13 05:14:46.394662 [ 3 ] {0a83a368-8452-4a47-a2c1-f3b719ce19a3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 586 | 2023.12.13 05:14:46.394844 [ 3 ] {0a83a368-8452-4a47-a2c1-f3b719ce19a3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 587 | 2023.12.13 05:14:46.396465 [ 3 ] {0a83a368-8452-4a47-a2c1-f3b719ce19a3} <Debug> oximeter.measurements_histogramu64 (1dfc78c7-90d1-4855-9efb-375e90e13123): Loading data parts | ||
| 588 | 2023.12.13 05:14:46.396586 [ 3 ] {0a83a368-8452-4a47-a2c1-f3b719ce19a3} <Debug> oximeter.measurements_histogramu64 (1dfc78c7-90d1-4855-9efb-375e90e13123): There are no data parts | ||
| 589 | 2023.12.13 05:14:46.397994 [ 3 ] {0a83a368-8452-4a47-a2c1-f3b719ce19a3} <Debug> DynamicQueryHandler: Done processing query | ||
| 590 | 2023.12.13 05:14:46.398055 [ 3 ] {0a83a368-8452-4a47-a2c1-f3b719ce19a3} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 591 | 2023.12.13 05:14:46.398104 [ 3 ] {} <Debug> HTTP-Session: 12185a35-5a5a-4e42-8241-af15919ba114 Destroying unnamed session | ||
| 592 | 2023.12.13 05:14:46.398215 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 376, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 593 | 2023.12.13 05:14:46.398289 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 594 | 2023.12.13 05:14:46.398308 [ 3 ] {} <Debug> HTTP-Session: e6c5f9f0-995b-4624-aa79-28b4cbd80de0 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 595 | 2023.12.13 05:14:46.398358 [ 3 ] {} <Debug> HTTP-Session: e6c5f9f0-995b-4624-aa79-28b4cbd80de0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 596 | 2023.12.13 05:14:46.398590 [ 3 ] {f9c639db-85a8-4723-abe0-08b4c7533133} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 597 | 2023.12.13 05:14:46.398795 [ 3 ] {f9c639db-85a8-4723-abe0-08b4c7533133} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 598 | 2023.12.13 05:14:46.400315 [ 3 ] {f9c639db-85a8-4723-abe0-08b4c7533133} <Debug> oximeter.measurements_histogramf32 (4a339616-4b59-44c0-8ede-c8619453e43d): Loading data parts | ||
| 599 | 2023.12.13 05:14:46.400434 [ 3 ] {f9c639db-85a8-4723-abe0-08b4c7533133} <Debug> oximeter.measurements_histogramf32 (4a339616-4b59-44c0-8ede-c8619453e43d): There are no data parts | ||
| 600 | 2023.12.13 05:14:46.401576 [ 3 ] {f9c639db-85a8-4723-abe0-08b4c7533133} <Debug> DynamicQueryHandler: Done processing query | ||
| 601 | 2023.12.13 05:14:46.401606 [ 3 ] {f9c639db-85a8-4723-abe0-08b4c7533133} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 602 | 2023.12.13 05:14:46.401668 [ 3 ] {} <Debug> HTTP-Session: e6c5f9f0-995b-4624-aa79-28b4cbd80de0 Destroying unnamed session | ||
| 603 | 2023.12.13 05:14:46.401853 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 376, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 604 | 2023.12.13 05:14:46.401939 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 605 | 2023.12.13 05:14:46.402006 [ 3 ] {} <Debug> HTTP-Session: dd04d225-2d26-4df2-b175-ae5c0eb06779 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 606 | 2023.12.13 05:14:46.402025 [ 3 ] {} <Debug> HTTP-Session: dd04d225-2d26-4df2-b175-ae5c0eb06779 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 607 | 2023.12.13 05:14:46.402308 [ 3 ] {0bfdf47b-51e4-4177-8b31-7b54e9e74303} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) 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) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 608 | 2023.12.13 05:14:46.402435 [ 3 ] {0bfdf47b-51e4-4177-8b31-7b54e9e74303} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 609 | 2023.12.13 05:14:46.404070 [ 3 ] {0bfdf47b-51e4-4177-8b31-7b54e9e74303} <Debug> oximeter.measurements_histogramf64 (6db5a9b6-fb4f-4a04-8059-26e50f2c5da9): Loading data parts | ||
| 610 | 2023.12.13 05:14:46.404149 [ 3 ] {0bfdf47b-51e4-4177-8b31-7b54e9e74303} <Debug> oximeter.measurements_histogramf64 (6db5a9b6-fb4f-4a04-8059-26e50f2c5da9): There are no data parts | ||
| 611 | 2023.12.13 05:14:46.405383 [ 3 ] {0bfdf47b-51e4-4177-8b31-7b54e9e74303} <Debug> DynamicQueryHandler: Done processing query | ||
| 612 | 2023.12.13 05:14:46.405449 [ 3 ] {0bfdf47b-51e4-4177-8b31-7b54e9e74303} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 613 | 2023.12.13 05:14:46.405463 [ 3 ] {} <Debug> HTTP-Session: dd04d225-2d26-4df2-b175-ae5c0eb06779 Destroying unnamed session | ||
| 614 | 2023.12.13 05:14:46.405611 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 1196, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 615 | 2023.12.13 05:14:46.405721 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 616 | 2023.12.13 05:14:46.405808 [ 3 ] {} <Debug> HTTP-Session: 53e37512-2b66-467d-895d-dfa21ec8d81a Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 617 | 2023.12.13 05:14:46.405860 [ 3 ] {} <Debug> HTTP-Session: 53e37512-2b66-467d-895d-dfa21ec8d81a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 618 | 2023.12.13 05:14:46.406014 [ 3 ] {4b1f539b-e549-4a34-8c0a-dc7a1c4f1f7b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) /* The field tables store named dimensions of each timeseries. | ||
| 619 | * | ||
| 620 | * As with the measurement tables, there is one field table for each field data | ||
| 621 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 622 | * this behavior **must not** be relied upon for query correctness. | ||
| 623 | * | ||
| 624 | * The index for the fields differs from the measurements, however. Rows are | ||
| 625 | * sorted by timeseries name, then field name, field value, and finally | ||
| 626 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 627 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 628 | * usually then used to look up measurements. | ||
| 629 | * | ||
| 630 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 631 | * timeseries name and then key, since it would improve lookups where one | ||
| 632 | * already has the key. Realistically though, these tables are quite small and | ||
| 633 | * so performance benefits will be low in absolute terms. | ||
| 634 | */ | ||
| 635 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 636 | 2023.12.13 05:14:46.406125 [ 3 ] {4b1f539b-e549-4a34-8c0a-dc7a1c4f1f7b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 637 | 2023.12.13 05:14:46.407481 [ 3 ] {4b1f539b-e549-4a34-8c0a-dc7a1c4f1f7b} <Debug> oximeter.fields_bool (8694ba4c-f1f4-40de-a997-39a75d069d64): Loading data parts | ||
| 638 | 2023.12.13 05:14:46.407593 [ 3 ] {4b1f539b-e549-4a34-8c0a-dc7a1c4f1f7b} <Debug> oximeter.fields_bool (8694ba4c-f1f4-40de-a997-39a75d069d64): There are no data parts | ||
| 639 | 2023.12.13 05:14:46.409533 [ 3 ] {4b1f539b-e549-4a34-8c0a-dc7a1c4f1f7b} <Debug> DynamicQueryHandler: Done processing query | ||
| 640 | 2023.12.13 05:14:46.409598 [ 3 ] {4b1f539b-e549-4a34-8c0a-dc7a1c4f1f7b} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 641 | 2023.12.13 05:14:46.409614 [ 3 ] {} <Debug> HTTP-Session: 53e37512-2b66-467d-895d-dfa21ec8d81a Destroying unnamed session | ||
| 642 | 2023.12.13 05:14:46.409833 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 248, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 643 | 2023.12.13 05:14:46.409910 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 644 | 2023.12.13 05:14:46.409930 [ 3 ] {} <Debug> HTTP-Session: b3eba68e-3053-4657-9b80-2c2b0072c34d Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 645 | 2023.12.13 05:14:46.409982 [ 3 ] {} <Debug> HTTP-Session: b3eba68e-3053-4657-9b80-2c2b0072c34d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 646 | 2023.12.13 05:14:46.410160 [ 3 ] {c7f40947-8897-4101-9aa9-9b982f864a8b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 647 | 2023.12.13 05:14:46.410233 [ 3 ] {c7f40947-8897-4101-9aa9-9b982f864a8b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 648 | 2023.12.13 05:14:46.412081 [ 3 ] {c7f40947-8897-4101-9aa9-9b982f864a8b} <Debug> oximeter.fields_i8 (562f5b92-e73a-49af-88bb-2584c631e281): Loading data parts | ||
| 649 | 2023.12.13 05:14:46.412163 [ 3 ] {c7f40947-8897-4101-9aa9-9b982f864a8b} <Debug> oximeter.fields_i8 (562f5b92-e73a-49af-88bb-2584c631e281): There are no data parts | ||
| 650 | 2023.12.13 05:14:46.413498 [ 3 ] {c7f40947-8897-4101-9aa9-9b982f864a8b} <Debug> DynamicQueryHandler: Done processing query | ||
| 651 | 2023.12.13 05:14:46.413521 [ 3 ] {c7f40947-8897-4101-9aa9-9b982f864a8b} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 652 | 2023.12.13 05:14:46.413573 [ 3 ] {} <Debug> HTTP-Session: b3eba68e-3053-4657-9b80-2c2b0072c34d Destroying unnamed session | ||
| 653 | 2023.12.13 05:14:46.413715 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 249, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 654 | 2023.12.13 05:14:46.413822 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 655 | 2023.12.13 05:14:46.413870 [ 3 ] {} <Debug> HTTP-Session: a580dab4-ba85-4cdc-a34e-1c34b759a87d Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 656 | 2023.12.13 05:14:46.413923 [ 3 ] {} <Debug> HTTP-Session: a580dab4-ba85-4cdc-a34e-1c34b759a87d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 657 | 2023.12.13 05:14:46.414067 [ 3 ] {8bd08a41-e3aa-4224-981a-50f3942e4d0e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 658 | 2023.12.13 05:14:46.414166 [ 3 ] {8bd08a41-e3aa-4224-981a-50f3942e4d0e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 659 | 2023.12.13 05:14:46.415454 [ 3 ] {8bd08a41-e3aa-4224-981a-50f3942e4d0e} <Debug> oximeter.fields_u8 (a2f40cc3-1d20-405a-9114-e801ed5dbf3f): Loading data parts | ||
| 660 | 2023.12.13 05:14:46.415556 [ 3 ] {8bd08a41-e3aa-4224-981a-50f3942e4d0e} <Debug> oximeter.fields_u8 (a2f40cc3-1d20-405a-9114-e801ed5dbf3f): There are no data parts | ||
| 661 | 2023.12.13 05:14:46.416909 [ 3 ] {8bd08a41-e3aa-4224-981a-50f3942e4d0e} <Debug> DynamicQueryHandler: Done processing query | ||
| 662 | 2023.12.13 05:14:46.416932 [ 3 ] {8bd08a41-e3aa-4224-981a-50f3942e4d0e} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 663 | 2023.12.13 05:14:46.416979 [ 3 ] {} <Debug> HTTP-Session: a580dab4-ba85-4cdc-a34e-1c34b759a87d Destroying unnamed session | ||
| 664 | 2023.12.13 05:14:46.417084 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 665 | 2023.12.13 05:14:46.417153 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 666 | 2023.12.13 05:14:46.417171 [ 3 ] {} <Debug> HTTP-Session: 163d94b0-5afc-4c47-82ee-410d53d1c1fe Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 667 | 2023.12.13 05:14:46.417217 [ 3 ] {} <Debug> HTTP-Session: 163d94b0-5afc-4c47-82ee-410d53d1c1fe Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 668 | 2023.12.13 05:14:46.417394 [ 3 ] {11cf6f5e-ab9d-4891-8df7-804dff99e56d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 669 | 2023.12.13 05:14:46.417460 [ 3 ] {11cf6f5e-ab9d-4891-8df7-804dff99e56d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 670 | 2023.12.13 05:14:46.418870 [ 3 ] {11cf6f5e-ab9d-4891-8df7-804dff99e56d} <Debug> oximeter.fields_i16 (c6cd9ffe-f438-4286-b718-6a9814d2f280): Loading data parts | ||
| 671 | 2023.12.13 05:14:46.418977 [ 3 ] {11cf6f5e-ab9d-4891-8df7-804dff99e56d} <Debug> oximeter.fields_i16 (c6cd9ffe-f438-4286-b718-6a9814d2f280): There are no data parts | ||
| 672 | 2023.12.13 05:14:46.420036 [ 3 ] {11cf6f5e-ab9d-4891-8df7-804dff99e56d} <Debug> DynamicQueryHandler: Done processing query | ||
| 673 | 2023.12.13 05:14:46.420103 [ 3 ] {11cf6f5e-ab9d-4891-8df7-804dff99e56d} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 674 | 2023.12.13 05:14:46.420117 [ 3 ] {} <Debug> HTTP-Session: 163d94b0-5afc-4c47-82ee-410d53d1c1fe Destroying unnamed session | ||
| 675 | 2023.12.13 05:14:46.420270 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 676 | 2023.12.13 05:14:46.420346 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 677 | 2023.12.13 05:14:46.420365 [ 3 ] {} <Debug> HTTP-Session: 510f9c4b-5add-4cec-8cab-38fd0d122ca1 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 678 | 2023.12.13 05:14:46.420414 [ 3 ] {} <Debug> HTTP-Session: 510f9c4b-5add-4cec-8cab-38fd0d122ca1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 679 | 2023.12.13 05:14:46.420598 [ 3 ] {1ca3d404-b8eb-4a6d-aefd-430a8780e9c2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 680 | 2023.12.13 05:14:46.420671 [ 3 ] {1ca3d404-b8eb-4a6d-aefd-430a8780e9c2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 681 | 2023.12.13 05:14:46.422664 [ 3 ] {1ca3d404-b8eb-4a6d-aefd-430a8780e9c2} <Debug> oximeter.fields_u16 (4fbdc4a7-3249-4a49-9d88-9b2777caec61): Loading data parts | ||
| 682 | 2023.12.13 05:14:46.422729 [ 3 ] {1ca3d404-b8eb-4a6d-aefd-430a8780e9c2} <Debug> oximeter.fields_u16 (4fbdc4a7-3249-4a49-9d88-9b2777caec61): There are no data parts | ||
| 683 | 2023.12.13 05:14:46.424684 [ 3 ] {1ca3d404-b8eb-4a6d-aefd-430a8780e9c2} <Debug> DynamicQueryHandler: Done processing query | ||
| 684 | 2023.12.13 05:14:46.424707 [ 3 ] {1ca3d404-b8eb-4a6d-aefd-430a8780e9c2} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 685 | 2023.12.13 05:14:46.424891 [ 3 ] {} <Debug> HTTP-Session: 510f9c4b-5add-4cec-8cab-38fd0d122ca1 Destroying unnamed session | ||
| 686 | 2023.12.13 05:14:46.425018 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 687 | 2023.12.13 05:14:46.425096 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 688 | 2023.12.13 05:14:46.425154 [ 3 ] {} <Debug> HTTP-Session: 0769b6a6-70cf-429d-be04-07ab79f345dd Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 689 | 2023.12.13 05:14:46.425171 [ 3 ] {} <Debug> HTTP-Session: 0769b6a6-70cf-429d-be04-07ab79f345dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 690 | 2023.12.13 05:14:46.425353 [ 3 ] {5eaf64e4-6827-4269-8ff5-c8715bef4f22} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 691 | 2023.12.13 05:14:46.425491 [ 3 ] {5eaf64e4-6827-4269-8ff5-c8715bef4f22} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 692 | 2023.12.13 05:14:46.427278 [ 3 ] {5eaf64e4-6827-4269-8ff5-c8715bef4f22} <Debug> oximeter.fields_i32 (2337a54e-bed3-4301-a33c-4fb01f085d9c): Loading data parts | ||
| 693 | 2023.12.13 05:14:46.427385 [ 3 ] {5eaf64e4-6827-4269-8ff5-c8715bef4f22} <Debug> oximeter.fields_i32 (2337a54e-bed3-4301-a33c-4fb01f085d9c): There are no data parts | ||
| 694 | 2023.12.13 05:14:46.428615 [ 3 ] {5eaf64e4-6827-4269-8ff5-c8715bef4f22} <Debug> DynamicQueryHandler: Done processing query | ||
| 695 | 2023.12.13 05:14:46.428680 [ 3 ] {5eaf64e4-6827-4269-8ff5-c8715bef4f22} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 696 | 2023.12.13 05:14:46.428739 [ 3 ] {} <Debug> HTTP-Session: 0769b6a6-70cf-429d-be04-07ab79f345dd Destroying unnamed session | ||
| 697 | 2023.12.13 05:14:46.428958 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 698 | 2023.12.13 05:14:46.429041 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 699 | 2023.12.13 05:14:46.429100 [ 3 ] {} <Debug> HTTP-Session: 57f8cd83-0b10-4366-aa73-37c7ad5e505c Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 700 | 2023.12.13 05:14:46.429115 [ 3 ] {} <Debug> HTTP-Session: 57f8cd83-0b10-4366-aa73-37c7ad5e505c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 701 | 2023.12.13 05:14:46.429349 [ 3 ] {634222c2-8a03-4854-bb51-a93dcb9032a4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 702 | 2023.12.13 05:14:46.429424 [ 3 ] {634222c2-8a03-4854-bb51-a93dcb9032a4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 703 | 2023.12.13 05:14:46.430752 [ 3 ] {634222c2-8a03-4854-bb51-a93dcb9032a4} <Debug> oximeter.fields_u32 (530e7182-dba2-45ca-abda-2d6a8f308a7b): Loading data parts | ||
| 704 | 2023.12.13 05:14:46.430914 [ 3 ] {634222c2-8a03-4854-bb51-a93dcb9032a4} <Debug> oximeter.fields_u32 (530e7182-dba2-45ca-abda-2d6a8f308a7b): There are no data parts | ||
| 705 | 2023.12.13 05:14:46.432043 [ 3 ] {634222c2-8a03-4854-bb51-a93dcb9032a4} <Debug> DynamicQueryHandler: Done processing query | ||
| 706 | 2023.12.13 05:14:46.432110 [ 3 ] {634222c2-8a03-4854-bb51-a93dcb9032a4} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 707 | 2023.12.13 05:14:46.432127 [ 3 ] {} <Debug> HTTP-Session: 57f8cd83-0b10-4366-aa73-37c7ad5e505c Destroying unnamed session | ||
| 708 | 2023.12.13 05:14:46.432270 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 709 | 2023.12.13 05:14:46.432346 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 710 | 2023.12.13 05:14:46.432366 [ 3 ] {} <Debug> HTTP-Session: 284adf16-3161-479b-8d91-5ee77b463a1c Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 711 | 2023.12.13 05:14:46.432421 [ 3 ] {} <Debug> HTTP-Session: 284adf16-3161-479b-8d91-5ee77b463a1c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 712 | 2023.12.13 05:14:46.432563 [ 3 ] {a96b1061-11d7-403c-9219-d3d9240e1a84} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 713 | 2023.12.13 05:14:46.432672 [ 3 ] {a96b1061-11d7-403c-9219-d3d9240e1a84} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 714 | 2023.12.13 05:14:46.435010 [ 3 ] {a96b1061-11d7-403c-9219-d3d9240e1a84} <Debug> oximeter.fields_i64 (2aee00d3-30a0-46df-95c8-7b48b7d8297a): Loading data parts | ||
| 715 | 2023.12.13 05:14:46.435119 [ 3 ] {a96b1061-11d7-403c-9219-d3d9240e1a84} <Debug> oximeter.fields_i64 (2aee00d3-30a0-46df-95c8-7b48b7d8297a): There are no data parts | ||
| 716 | 2023.12.13 05:14:46.436530 [ 3 ] {a96b1061-11d7-403c-9219-d3d9240e1a84} <Debug> DynamicQueryHandler: Done processing query | ||
| 717 | 2023.12.13 05:14:46.436555 [ 3 ] {a96b1061-11d7-403c-9219-d3d9240e1a84} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 718 | 2023.12.13 05:14:46.436614 [ 3 ] {} <Debug> HTTP-Session: 284adf16-3161-479b-8d91-5ee77b463a1c Destroying unnamed session | ||
| 719 | 2023.12.13 05:14:46.436732 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 720 | 2023.12.13 05:14:46.436887 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 721 | 2023.12.13 05:14:46.436959 [ 3 ] {} <Debug> HTTP-Session: 0b54fd71-6cfe-4195-9148-3fb34d0112d5 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 722 | 2023.12.13 05:14:46.437023 [ 3 ] {} <Debug> HTTP-Session: 0b54fd71-6cfe-4195-9148-3fb34d0112d5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 723 | 2023.12.13 05:14:46.437174 [ 3 ] {4d00760f-7d9b-40af-9942-29a4a8dafcc2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 724 | 2023.12.13 05:14:46.437285 [ 3 ] {4d00760f-7d9b-40af-9942-29a4a8dafcc2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 725 | 2023.12.13 05:14:46.438920 [ 3 ] {4d00760f-7d9b-40af-9942-29a4a8dafcc2} <Debug> oximeter.fields_u64 (98454411-e346-4b71-aa0e-43b9466f09a1): Loading data parts | ||
| 726 | 2023.12.13 05:14:46.439029 [ 3 ] {4d00760f-7d9b-40af-9942-29a4a8dafcc2} <Debug> oximeter.fields_u64 (98454411-e346-4b71-aa0e-43b9466f09a1): There are no data parts | ||
| 727 | 2023.12.13 05:14:46.440141 [ 3 ] {4d00760f-7d9b-40af-9942-29a4a8dafcc2} <Debug> DynamicQueryHandler: Done processing query | ||
| 728 | 2023.12.13 05:14:46.440165 [ 3 ] {4d00760f-7d9b-40af-9942-29a4a8dafcc2} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 729 | 2023.12.13 05:14:46.440179 [ 3 ] {} <Debug> HTTP-Session: 0b54fd71-6cfe-4195-9148-3fb34d0112d5 Destroying unnamed session | ||
| 730 | 2023.12.13 05:14:46.440326 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 252, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 731 | 2023.12.13 05:14:46.440417 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 732 | 2023.12.13 05:14:46.440446 [ 3 ] {} <Debug> HTTP-Session: 75deb6ac-24ad-4450-948c-963131438810 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 733 | 2023.12.13 05:14:46.440501 [ 3 ] {} <Debug> HTTP-Session: 75deb6ac-24ad-4450-948c-963131438810 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 734 | 2023.12.13 05:14:46.440682 [ 3 ] {d8f13001-c473-4a37-817d-ba276162fab6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6 ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 735 | 2023.12.13 05:14:46.440749 [ 3 ] {d8f13001-c473-4a37-817d-ba276162fab6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 736 | 2023.12.13 05:14:46.442309 [ 3 ] {d8f13001-c473-4a37-817d-ba276162fab6} <Debug> oximeter.fields_ipaddr (96a2f04c-b660-4d14-9b20-b05fa693bf29): Loading data parts | ||
| 737 | 2023.12.13 05:14:46.442372 [ 3 ] {d8f13001-c473-4a37-817d-ba276162fab6} <Debug> oximeter.fields_ipaddr (96a2f04c-b660-4d14-9b20-b05fa693bf29): There are no data parts | ||
| 738 | 2023.12.13 05:14:46.443491 [ 3 ] {d8f13001-c473-4a37-817d-ba276162fab6} <Debug> DynamicQueryHandler: Done processing query | ||
| 739 | 2023.12.13 05:14:46.443546 [ 3 ] {d8f13001-c473-4a37-817d-ba276162fab6} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 740 | 2023.12.13 05:14:46.443561 [ 3 ] {} <Debug> HTTP-Session: 75deb6ac-24ad-4450-948c-963131438810 Destroying unnamed session | ||
| 741 | 2023.12.13 05:14:46.443702 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 254, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 742 | 2023.12.13 05:14:46.443775 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 743 | 2023.12.13 05:14:46.443793 [ 3 ] {} <Debug> HTTP-Session: d630cf8b-ffa2-436d-a722-b4872172ddd3 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 744 | 2023.12.13 05:14:46.443905 [ 3 ] {} <Debug> HTTP-Session: d630cf8b-ffa2-436d-a722-b4872172ddd3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 745 | 2023.12.13 05:14:46.444082 [ 3 ] {8d768e26-3556-41ff-bbbc-1eab7887de48} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 746 | 2023.12.13 05:14:46.444151 [ 3 ] {8d768e26-3556-41ff-bbbc-1eab7887de48} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 747 | 2023.12.13 05:14:46.445995 [ 3 ] {8d768e26-3556-41ff-bbbc-1eab7887de48} <Debug> oximeter.fields_string (34ad7323-8054-49df-b614-56ccb73c68b3): Loading data parts | ||
| 748 | 2023.12.13 05:14:46.446061 [ 3 ] {8d768e26-3556-41ff-bbbc-1eab7887de48} <Debug> oximeter.fields_string (34ad7323-8054-49df-b614-56ccb73c68b3): There are no data parts | ||
| 749 | 2023.12.13 05:14:46.447295 [ 3 ] {8d768e26-3556-41ff-bbbc-1eab7887de48} <Debug> DynamicQueryHandler: Done processing query | ||
| 750 | 2023.12.13 05:14:46.447318 [ 3 ] {8d768e26-3556-41ff-bbbc-1eab7887de48} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 751 | 2023.12.13 05:14:46.447369 [ 3 ] {} <Debug> HTTP-Session: d630cf8b-ffa2-436d-a722-b4872172ddd3 Destroying unnamed session | ||
| 752 | 2023.12.13 05:14:46.447481 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 753 | 2023.12.13 05:14:46.447550 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 754 | 2023.12.13 05:14:46.447601 [ 3 ] {} <Debug> HTTP-Session: 571eca2b-8c61-4e0e-915c-86a2c8e2b16d Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 755 | 2023.12.13 05:14:46.447616 [ 3 ] {} <Debug> HTTP-Session: 571eca2b-8c61-4e0e-915c-86a2c8e2b16d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 756 | 2023.12.13 05:14:46.447790 [ 3 ] {f05ddcf6-6226-4351-82bb-30fde757e83c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) (stage: Complete) | ||
| 757 | 2023.12.13 05:14:46.447956 [ 3 ] {f05ddcf6-6226-4351-82bb-30fde757e83c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 758 | 2023.12.13 05:14:46.449230 [ 3 ] {f05ddcf6-6226-4351-82bb-30fde757e83c} <Debug> oximeter.fields_uuid (bdaecfb5-a7e6-45c3-84e5-6daeb498480b): Loading data parts | ||
| 759 | 2023.12.13 05:14:46.449317 [ 3 ] {f05ddcf6-6226-4351-82bb-30fde757e83c} <Debug> oximeter.fields_uuid (bdaecfb5-a7e6-45c3-84e5-6daeb498480b): There are no data parts | ||
| 760 | 2023.12.13 05:14:46.450355 [ 3 ] {f05ddcf6-6226-4351-82bb-30fde757e83c} <Debug> DynamicQueryHandler: Done processing query | ||
| 761 | 2023.12.13 05:14:46.450413 [ 3 ] {f05ddcf6-6226-4351-82bb-30fde757e83c} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 762 | 2023.12.13 05:14:46.450460 [ 3 ] {} <Debug> HTTP-Session: 571eca2b-8c61-4e0e-915c-86a2c8e2b16d Destroying unnamed session | ||
| 763 | 2023.12.13 05:14:46.450571 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 764 | 2023.12.13 05:14:46.450640 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 765 | 2023.12.13 05:14:46.450695 [ 3 ] {} <Debug> HTTP-Session: dadf7059-0bbf-41e8-adf0-f8848818b753 Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 766 | 2023.12.13 05:14:46.450711 [ 3 ] {} <Debug> HTTP-Session: dadf7059-0bbf-41e8-adf0-f8848818b753 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 767 | 2023.12.13 05:14:46.451015 [ 3 ] {2f4e25d7-48d6-44b4-8f00-c1098c9dff60} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) /* The timeseries schema table stores the extracted schema for the samples | ||
| 768 | * oximeter collects. | ||
| 769 | */ | ||
| 770 | 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) | ||
| 771 | 2023.12.13 05:14:46.451132 [ 3 ] {2f4e25d7-48d6-44b4-8f00-c1098c9dff60} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 772 | 2023.12.13 05:14:46.452544 [ 3 ] {2f4e25d7-48d6-44b4-8f00-c1098c9dff60} <Debug> oximeter.timeseries_schema (171d7c0f-eb7e-41e5-aebb-5dc58f435076): Loading data parts | ||
| 773 | 2023.12.13 05:14:46.452600 [ 3 ] {2f4e25d7-48d6-44b4-8f00-c1098c9dff60} <Debug> oximeter.timeseries_schema (171d7c0f-eb7e-41e5-aebb-5dc58f435076): There are no data parts | ||
| 774 | 2023.12.13 05:14:46.453768 [ 3 ] {2f4e25d7-48d6-44b4-8f00-c1098c9dff60} <Debug> DynamicQueryHandler: Done processing query | ||
| 775 | 2023.12.13 05:14:46.453822 [ 3 ] {2f4e25d7-48d6-44b4-8f00-c1098c9dff60} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. | ||
| 776 | 2023.12.13 05:14:46.453839 [ 3 ] {} <Debug> HTTP-Session: dadf7059-0bbf-41e8-adf0-f8848818b753 Destroying unnamed session | ||
| 777 | 2023.12.13 05:14:46.454061 [ 3 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:41902, User-Agent: (none), Length: 51, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 778 | 2023.12.13 05:14:46.454132 [ 3 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0 | ||
| 779 | 2023.12.13 05:14:46.454150 [ 3 ] {} <Debug> HTTP-Session: 53d825e5-fee2-4c28-907a-0c29d6e7620e Authenticating user 'default' from [fd00:1122:3344:101::d]:41902 | ||
| 780 | 2023.12.13 05:14:46.454196 [ 3 ] {} <Debug> HTTP-Session: 53d825e5-fee2-4c28-907a-0c29d6e7620e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 781 | 2023.12.13 05:14:46.454300 [ 3 ] {dd263738-3e95-4407-8852-c2cf4f18139d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:41902) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 782 | 2023.12.13 05:14:46.455023 [ 3 ] {dd263738-3e95-4407-8852-c2cf4f18139d} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 783 | 2023.12.13 05:14:46.460527 [ 3 ] {dd263738-3e95-4407-8852-c2cf4f18139d} <Debug> DiskLocal: Reserving 1.00 MiB on disk `default`, having unreserved 16.95 GiB. | ||
| 784 | 2023.12.13 05:14:46.463434 [ 3 ] {dd263738-3e95-4407-8852-c2cf4f18139d} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 785 | 2023.12.13 05:14:46.463806 [ 3 ] {dd263738-3e95-4407-8852-c2cf4f18139d} <Trace> oximeter.version (ff04410b-72ff-48a5-b402-f5e86fdf31e4): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0. | ||
| 786 | 2023.12.13 05:14:46.464128 [ 3 ] {dd263738-3e95-4407-8852-c2cf4f18139d} <Information> executeQuery: Read 1 rows, 16.00 B in 0.00971895 sec., 102 rows/sec., 1.61 KiB/sec. | ||
| 787 | 2023.12.13 05:14:46.464266 [ 3 ] {dd263738-3e95-4407-8852-c2cf4f18139d} <Debug> DynamicQueryHandler: Done processing query | ||
| 788 | 2023.12.13 05:14:46.464285 [ 3 ] {dd263738-3e95-4407-8852-c2cf4f18139d} <Debug> MemoryTracker: Peak memory usage (for query): 4.09 MiB. | ||
| 789 | 2023.12.13 05:14:46.464301 [ 3 ] {} <Debug> HTTP-Session: 53d825e5-fee2-4c28-907a-0c29d6e7620e Destroying unnamed session | ||
| 790 | 2023.12.13 05:14:47.002838 [ 180 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 219.00 MiB, peak 224.07 MiB, will set to 228.29 MiB (RSS), difference: 9.29 MiB | ||
| 791 | 2023.12.13 05:15:00.626064 [ 157 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 792 | 2023.12.13 05:15:00.626116 [ 157 ] {} <Debug> DNSResolver: Updated DNS cache | ||