Max level shown:
1 2024.08.12 20:52:11.477967 [ 71413 ] {} <Information> SentryWriter: Sending crash reports is disabled
2 2024.08.12 20:52:11.478031 [ 71413 ] {} <Trace> Pipe: Pipe capacity is 1.00 MiB
3 2024.08.12 20:52:11.525304 [ 71413 ] {} <Information> Application: Starting ClickHouse 23.8.7.24 (revision: 54477, git hash: 812b95e14ba8cf744bf1d70e6de607cf130a79fa, build id: 6484B75ECB16F4FF87A88E10249A45E1BDBDE2E5), PID 71413
4 2024.08.12 20:52:11.525352 [ 71413 ] {} <Information> Application: starting up
5 2024.08.12 20:52:11.525367 [ 71413 ] {} <Information> Application: OS name: Linux, version: 5.15.0-1015-aws, architecture: x86_64
6 2024.08.12 20:52:11.527991 [ 71413 ] {} <Information> Application: Available RAM: 30.68 GiB; physical cores: 8; logical cores: 8.
7 2024.08.12 20:52:11.539745 [ 71413 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/thermal
8 2024.08.12 20:52:11.540831 [ 71413 ] {} <Trace> AsynchronousMetrics: Scanning /sys/block
9 2024.08.12 20:52:11.540907 [ 71413 ] {} <Trace> AsynchronousMetrics: Scanning /sys/devices/system/edac
10 2024.08.12 20:52:11.542331 [ 71413 ] {} <Trace> AsynchronousMetrics: Scanning /sys/class/hwmon
11 2024.08.12 20:52:11.725671 [ 71413 ] {} <Information> Application: Integrity check of the executable successfully passed (checksum: 63E397DB90569A93F13765E06F4A1FBF)
12 2024.08.12 20:52:11.725735 [ 71413 ] {} <Information> Application: It looks like the process has no CAP_IPC_LOCK capability, binary mlock will be disabled. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_ipc_lock=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
13 2024.08.12 20:52:11.731060 [ 71413 ] {} <Debug> Application: Set max number of file descriptors to 524288 (was 1024).
14 2024.08.12 20:52:11.731084 [ 71413 ] {} <Debug> Application: rlimit on number of threads is 125612
15 2024.08.12 20:52:11.731092 [ 71413 ] {} <Debug> Application: Initializing DateLUT.
16 2024.08.12 20:52:11.731097 [ 71413 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'.
17 2024.08.12 20:52:11.731120 [ 71413 ] {} <Debug> Context: Setting up /var/tmp/omicron_tmp/test_all-030be00079bcbe79-test_demo_saga.71314.1-clickhouse-oPXfee/datastore/tmp/ to store temporary data in it
18 2024.08.12 20:52:11.731398 [ 71413 ] {} <Debug> Application: Initializing interserver credentials.
19 2024.08.12 20:52:11.731872 [ 71413 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
20 2024.08.12 20:52:11.733517 [ 71413 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
21 2024.08.12 20:52:11.734169 [ 71413 ] {} <Information> Application: Setting max_server_memory_usage was set to 27.61 GiB (30.68 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)
22 2024.08.12 20:52:11.735263 [ 71413 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 15.34 GiB (30.68 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio)
23 2024.08.12 20:52:11.735276 [ 71413 ] {} <Information> Application: Merges and mutations memory limit is set to 15.34 GiB
24 2024.08.12 20:52:11.735340 [ 71413 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads
25 2024.08.12 20:52:11.736606 [ 71413 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads
26 2024.08.12 20:52:11.753964 [ 71413 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads
27 2024.08.12 20:52:11.771648 [ 71413 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads
28 2024.08.12 20:52:11.774057 [ 71413 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
29 2024.08.12 20:52:11.774087 [ 71413 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
30 2024.08.12 20:52:11.774807 [ 71413 ] {} <Debug> ConfigReloader: Loading config 'config.xml'
31 2024.08.12 20:52:11.777203 [ 71413 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performing update on configuration
32 2024.08.12 20:52:11.779162 [ 71413 ] {} <Debug> ConfigReloader: Loaded config 'config.xml', performed update on configuration
33 2024.08.12 20:52:11.779509 [ 71413 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: config.xml
34 2024.08.12 20:52:11.782066 [ 71413 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin
35 2024.08.12 20:52:11.782541 [ 71413 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8
36 2024.08.12 20:52:11.782921 [ 71413 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8
37 2024.08.12 20:52:11.783580 [ 71413 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8
38 2024.08.12 20:52:11.784436 [ 71413 ] {} <Information> DNSCacheUpdater: Update period 15 seconds
39 2024.08.12 20:52:11.785314 [ 71413 ] {} <Information> Application: Loading metadata from /var/tmp/omicron_tmp/test_all-030be00079bcbe79-test_demo_saga.71314.1-clickhouse-oPXfee/datastore/
40 2024.08.12 20:52:11.805860 [ 71445 ] {} <Debug> DNSResolver: Updating DNS cache
41 2024.08.12 20:52:11.806908 [ 71445 ] {} <Debug> DNSResolver: Updated DNS cache
42 2024.08.12 20:52:11.809744 [ 71413 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total.
43 2024.08.12 20:52:11.809762 [ 71413 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.861e-05 sec
44 2024.08.12 20:52:11.809769 [ 71413 ] {} <Trace> ReferentialDeps: No tables
45 2024.08.12 20:52:11.809775 [ 71413 ] {} <Trace> LoadingDeps: No tables
46 2024.08.12 20:52:11.809795 [ 71413 ] {} <Information> DatabaseAtomic (system): Starting up tables.
47 2024.08.12 20:52:11.809810 [ 71413 ] {} <Debug> SystemLog: Not creating system.query_log since corresponding section 'query_log' is missing from config
48 2024.08.12 20:52:11.809819 [ 71413 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config
49 2024.08.12 20:52:11.809829 [ 71413 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config
50 2024.08.12 20:52:11.809836 [ 71413 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config
51 2024.08.12 20:52:11.809844 [ 71413 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config
52 2024.08.12 20:52:11.809852 [ 71413 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config
53 2024.08.12 20:52:11.809858 [ 71413 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config
54 2024.08.12 20:52:11.809865 [ 71413 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config
55 2024.08.12 20:52:11.809873 [ 71413 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config
56 2024.08.12 20:52:11.809880 [ 71413 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config
57 2024.08.12 20:52:11.809887 [ 71413 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config
58 2024.08.12 20:52:11.809894 [ 71413 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config
59 2024.08.12 20:52:11.809900 [ 71413 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config
60 2024.08.12 20:52:11.809914 [ 71413 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config
61 2024.08.12 20:52:11.809922 [ 71413 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config
62 2024.08.12 20:52:11.809928 [ 71413 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config
63 2024.08.12 20:52:11.809933 [ 71413 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config
64 2024.08.12 20:52:11.822373 [ 71413 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal.
65 2024.08.12 20:52:11.826156 [ 71413 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total.
66 2024.08.12 20:52:11.826176 [ 71413 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.857e-05 sec
67 2024.08.12 20:52:11.826183 [ 71413 ] {} <Trace> ReferentialDeps: No tables
68 2024.08.12 20:52:11.826188 [ 71413 ] {} <Trace> LoadingDeps: No tables
69 2024.08.12 20:52:11.826207 [ 71413 ] {} <Information> DatabaseAtomic (default): Starting up tables.
70 2024.08.12 20:52:11.826301 [ 71413 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /var/tmp/omicron_tmp/test_all-030be00079bcbe79-test_demo_saga.71314.1-clickhouse-oPXfee/datastore/user_defined/
71 2024.08.12 20:52:11.826334 [ 71413 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded
72 2024.08.12 20:52:11.826342 [ 71413 ] {} <Debug> Application: Loaded metadata.
73 2024.08.12 20:52:11.826379 [ 71413 ] {} <Information> Application: Tasks stats provider: procfs
74 2024.08.12 20:52:11.826388 [ 71413 ] {} <Information> Application: It looks like the process has no CAP_SYS_NICE capability, the setting 'os_thread_priority' will have no effect. It could happen due to incorrect ClickHouse package installation. You could resolve the problem manually with 'sudo setcap cap_sys_nice=+ep /work/oxidecomputer/omicron/out/clickhouse/clickhouse'. Note that it will not work on 'nosuid' mounted filesystems.
75 2024.08.12 20:52:11.826458 [ 71413 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 42839
76 2024.08.12 20:52:11.826756 [ 71413 ] {} <Warning> Application: Listen [::1]:9000 failed: Poco::Exception. Code: 1000, e.code() = 98, Net Exception: Address already in use: [::1]:9000 (version 23.8.7.24 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
77 2024.08.12 20:52:11.826900 [ 71413 ] {} <Warning> Application: Listen [::1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 98, Net Exception: Address already in use: [::1]:9004 (version 23.8.7.24 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
78 2024.08.12 20:52:11.826933 [ 71413 ] {} <Debug> Application: Requested any available port (port == 0), actual port is 41357
79 2024.08.12 20:52:11.827071 [ 71413 ] {} <Warning> Application: Listen [127.0.0.1]:9000 failed: Poco::Exception. Code: 1000, e.code() = 98, Net Exception: Address already in use: 127.0.0.1:9000 (version 23.8.7.24 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
80 2024.08.12 20:52:11.828863 [ 71413 ] {} <Warning> Application: Listen [127.0.0.1]:9004 failed: Poco::Exception. Code: 1000, e.code() = 98, Net Exception: Address already in use: 127.0.0.1:9004 (version 23.8.7.24 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
81 2024.08.12 20:52:11.828881 [ 71413 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again.
82 2024.08.12 20:52:11.829217 [ 71413 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 8.48 MiB, peak 13.11 MiB, free memory in arenas 15.33 MiB, will set to 381.73 MiB (RSS), difference: 373.25 MiB
83 2024.08.12 20:52:11.829756 [ 71413 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.19e-05 sec.
84 2024.08.12 20:52:11.831113 [ 71413 ] {} <Information> Application: Listening for http://[::1]:42839
85 2024.08.12 20:52:11.831154 [ 71413 ] {} <Information> Application: Listening for http://127.0.0.1:41357
86 2024.08.12 20:52:11.831160 [ 71413 ] {} <Information> Application: Ready for connections.
87 2024.08.12 20:52:12.001622 [ 71658 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 381.75 MiB, peak 381.75 MiB, free memory in arenas 15.27 MiB, will set to 383.89 MiB (RSS), difference: 2.14 MiB
88 2024.08.12 20:52:18.782589 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
89 2024.08.12 20:52:18.782901 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
90 2024.08.12 20:52:18.782938 [ 71415 ] {} <Debug> HTTP-Session: e0157da1-7bfa-406b-a85d-25cc3167399b Authenticating user 'default' from [::1]:52972
91 2024.08.12 20:52:18.782956 [ 71415 ] {} <Debug> HTTP-Session: e0157da1-7bfa-406b-a85d-25cc3167399b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
92 2024.08.12 20:52:18.782966 [ 71415 ] {} <Debug> HTTP-Session: e0157da1-7bfa-406b-a85d-25cc3167399b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
93 2024.08.12 20:52:18.783061 [ 71415 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false
94 2024.08.12 20:52:18.783092 [ 71415 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION
95 2024.08.12 20:52:18.783106 [ 71415 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION
96 2024.08.12 20:52:18.783141 [ 71415 ] {} <Trace> HTTP-Session: e0157da1-7bfa-406b-a85d-25cc3167399b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
97 2024.08.12 20:52:18.783396 [ 71415 ] {43963e54-2f7d-4bf2-8bea-5ed989cf297f} <Debug> executeQuery: (from [::1]:52972) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
98 2024.08.12 20:52:18.784020 [ 71415 ] {43963e54-2f7d-4bf2-8bea-5ed989cf297f} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:52972) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
99 
100 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
101 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
102 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
103 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
104 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
105 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
106 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
107 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
108 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
109 9. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x00000000122e8c91 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
110 10. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000130fd60f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
111 11. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x0000000013101ee9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
112 12. DB::HTTPServerConnection::run() @ 0x0000000013172ad2 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
113 13. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
114 14. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
115 15. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
116 16. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
117 17. ? @ 0x00007f0e84d27ac3 in ?
118 18. ? @ 0x00007f0e84db9850 in ?
119 
120 2024.08.12 20:52:18.785514 [ 71415 ] {43963e54-2f7d-4bf2-8bea-5ed989cf297f} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
121 
122 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
123 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
124 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
125 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
126 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
127 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
128 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
129 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
130 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
131 9. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x00000000122e8c91 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
132 10. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000130fd60f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
133 11. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x0000000013101ee9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
134 12. DB::HTTPServerConnection::run() @ 0x0000000013172ad2 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
135 13. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
136 14. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
137 15. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
138 16. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
139 17. ? @ 0x00007f0e84d27ac3 in ?
140 18. ? @ 0x00007f0e84db9850 in ?
141 (version 23.8.7.24 (official build))
142 2024.08.12 20:52:18.785691 [ 71415 ] {} <Debug> HTTP-Session: e0157da1-7bfa-406b-a85d-25cc3167399b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
143 2024.08.12 20:52:18.786922 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 33, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
144 2024.08.12 20:52:18.786964 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
145 2024.08.12 20:52:18.786976 [ 71415 ] {} <Debug> HTTP-Session: 19e53462-1915-4a03-ab12-d03925214f9e Authenticating user 'default' from [::1]:52972
146 2024.08.12 20:52:18.786989 [ 71415 ] {} <Debug> HTTP-Session: 19e53462-1915-4a03-ab12-d03925214f9e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
147 2024.08.12 20:52:18.786995 [ 71415 ] {} <Debug> HTTP-Session: 19e53462-1915-4a03-ab12-d03925214f9e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
148 2024.08.12 20:52:18.787028 [ 71415 ] {} <Trace> HTTP-Session: 19e53462-1915-4a03-ab12-d03925214f9e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
149 2024.08.12 20:52:18.787146 [ 71415 ] {22fd43e2-5443-494c-be73-bbcaf4e608f6} <Debug> executeQuery: (from [::1]:52972) SHOW CLUSTERS FORMAT JSONEachRow; (stage: Complete)
150 2024.08.12 20:52:18.787219 [ 71415 ] {22fd43e2-5443-494c-be73-bbcaf4e608f6} <Debug> executeQuery: (internal) SELECT DISTINCT cluster FROM system.clusters ORDER BY cluster (stage: Complete)
151 2024.08.12 20:52:18.787410 [ 71415 ] {22fd43e2-5443-494c-be73-bbcaf4e608f6} <Trace> ContextAccess (default): Access granted: SELECT(cluster) ON system.clusters
152 2024.08.12 20:52:18.788364 [ 71415 ] {22fd43e2-5443-494c-be73-bbcaf4e608f6} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
153 2024.08.12 20:52:18.791373 [ 71415 ] {22fd43e2-5443-494c-be73-bbcaf4e608f6} <Debug> DynamicQueryHandler: Done processing query
154 2024.08.12 20:52:18.791396 [ 71415 ] {22fd43e2-5443-494c-be73-bbcaf4e608f6} <Debug> MemoryTracker: Peak memory usage (for query): 3.00 MiB.
155 2024.08.12 20:52:18.791406 [ 71415 ] {} <Debug> HTTP-Session: 19e53462-1915-4a03-ab12-d03925214f9e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
156 2024.08.12 20:52:18.792352 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
157 2024.08.12 20:52:18.792384 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
158 2024.08.12 20:52:18.792392 [ 71415 ] {} <Debug> HTTP-Session: b70aea41-432d-478a-9334-2fe15e118f84 Authenticating user 'default' from [::1]:52972
159 2024.08.12 20:52:18.792400 [ 71415 ] {} <Debug> HTTP-Session: b70aea41-432d-478a-9334-2fe15e118f84 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
160 2024.08.12 20:52:18.792405 [ 71415 ] {} <Debug> HTTP-Session: b70aea41-432d-478a-9334-2fe15e118f84 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
161 2024.08.12 20:52:18.792431 [ 71415 ] {} <Trace> HTTP-Session: b70aea41-432d-478a-9334-2fe15e118f84 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
162 2024.08.12 20:52:18.792557 [ 71415 ] {5f49a589-a634-4497-9dc5-377f59bbf913} <Debug> executeQuery: (from [::1]:52972) SELECT MAX(value) FROM oximeter.version; (stage: Complete)
163 2024.08.12 20:52:18.792770 [ 71415 ] {5f49a589-a634-4497-9dc5-377f59bbf913} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.24 (official build)) (from [::1]:52972) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below):
164 
165 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
166 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
167 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
168 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
169 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
170 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
171 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
172 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
173 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
174 9. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x00000000122e8c91 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
175 10. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000130fd60f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
176 11. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x0000000013101ee9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
177 12. DB::HTTPServerConnection::run() @ 0x0000000013172ad2 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
178 13. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
179 14. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
180 15. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
181 16. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
182 17. ? @ 0x00007f0e84d27ac3 in ?
183 18. ? @ 0x00007f0e84db9850 in ?
184 
185 2024.08.12 20:52:18.793792 [ 71415 ] {5f49a589-a634-4497-9dc5-377f59bbf913} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
186 
187 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c6487f7 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
188 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x000000000715892d in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
189 2. DB::DatabaseCatalog::getDatabase(String const&) const @ 0x000000001170be95 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
190 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x00000000116810de in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
191 4. DB::JoinedTables::getLeftTableStorage() @ 0x0000000011fde326 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
192 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000011ee92e3 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
193 6. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000011f9c308 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
194 7. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000011ea331e in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
195 8. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x00000000122e55ea in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
196 9. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x00000000122e8c91 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
197 10. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000130fd60f in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
198 11. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x0000000013101ee9 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
199 12. DB::HTTPServerConnection::run() @ 0x0000000013172ad2 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
200 13. Poco::Net::TCPServerConnection::start() @ 0x0000000015b5f7f4 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
201 14. Poco::Net::TCPServerDispatcher::run() @ 0x0000000015b609f1 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
202 15. Poco::PooledThread::run() @ 0x0000000015c97227 in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
203 16. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000015c954fc in /work/oxidecomputer/omicron/out/clickhouse/clickhouse
204 17. ? @ 0x00007f0e84d27ac3 in ?
205 18. ? @ 0x00007f0e84db9850 in ?
206 (version 23.8.7.24 (official build))
207 2024.08.12 20:52:18.793916 [ 71415 ] {} <Debug> HTTP-Session: b70aea41-432d-478a-9334-2fe15e118f84 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
208 2024.08.12 20:52:18.794662 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
209 2024.08.12 20:52:18.795576 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
210 2024.08.12 20:52:18.795593 [ 71415 ] {} <Debug> HTTP-Session: c45bb14a-29ea-4202-b0a4-6f6d78b2c2de Authenticating user 'default' from [::1]:52972
211 2024.08.12 20:52:18.795605 [ 71415 ] {} <Debug> HTTP-Session: c45bb14a-29ea-4202-b0a4-6f6d78b2c2de Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
212 2024.08.12 20:52:18.795611 [ 71415 ] {} <Debug> HTTP-Session: c45bb14a-29ea-4202-b0a4-6f6d78b2c2de Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
213 2024.08.12 20:52:18.795641 [ 71415 ] {} <Trace> HTTP-Session: c45bb14a-29ea-4202-b0a4-6f6d78b2c2de Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
214 2024.08.12 20:52:18.795764 [ 71415 ] {1a2b576c-90a7-4f94-ad04-9026cbc53d54} <Debug> executeQuery: (from [::1]:52972) DROP DATABASE IF EXISTS oximeter (stage: Complete)
215 2024.08.12 20:52:18.795927 [ 71415 ] {1a2b576c-90a7-4f94-ad04-9026cbc53d54} <Debug> DynamicQueryHandler: Done processing query
216 2024.08.12 20:52:18.795943 [ 71415 ] {} <Debug> HTTP-Session: c45bb14a-29ea-4202-b0a4-6f6d78b2c2de Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
217 2024.08.12 20:52:18.796639 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
218 2024.08.12 20:52:18.798238 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
219 2024.08.12 20:52:18.798256 [ 71415 ] {} <Debug> HTTP-Session: 8ae78afe-8ab3-4771-b320-be39bff1050f Authenticating user 'default' from [::1]:52972
220 2024.08.12 20:52:18.798268 [ 71415 ] {} <Debug> HTTP-Session: 8ae78afe-8ab3-4771-b320-be39bff1050f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
221 2024.08.12 20:52:18.798275 [ 71415 ] {} <Debug> HTTP-Session: 8ae78afe-8ab3-4771-b320-be39bff1050f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
222 2024.08.12 20:52:18.798304 [ 71415 ] {} <Trace> HTTP-Session: 8ae78afe-8ab3-4771-b320-be39bff1050f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
223 2024.08.12 20:52:18.798458 [ 71415 ] {e4e145d0-9a39-4496-a44c-138e99318022} <Debug> executeQuery: (from [::1]:52972) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete)
224 2024.08.12 20:52:18.798489 [ 71415 ] {e4e145d0-9a39-4496-a44c-138e99318022} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.*
225 2024.08.12 20:52:18.804344 [ 71415 ] {e4e145d0-9a39-4496-a44c-138e99318022} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total.
226 2024.08.12 20:52:18.804364 [ 71415 ] {e4e145d0-9a39-4496-a44c-138e99318022} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.831e-05 sec
227 2024.08.12 20:52:18.804373 [ 71415 ] {e4e145d0-9a39-4496-a44c-138e99318022} <Trace> ReferentialDeps: No tables
228 2024.08.12 20:52:18.804379 [ 71415 ] {e4e145d0-9a39-4496-a44c-138e99318022} <Trace> LoadingDeps: No tables
229 2024.08.12 20:52:18.804399 [ 71415 ] {e4e145d0-9a39-4496-a44c-138e99318022} <Information> DatabaseAtomic (oximeter): Starting up tables.
230 2024.08.12 20:52:18.804579 [ 71415 ] {e4e145d0-9a39-4496-a44c-138e99318022} <Debug> DynamicQueryHandler: Done processing query
231 2024.08.12 20:52:18.804598 [ 71415 ] {} <Debug> HTTP-Session: 8ae78afe-8ab3-4771-b320-be39bff1050f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
232 2024.08.12 20:52:18.806626 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
233 2024.08.12 20:52:18.806669 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
234 2024.08.12 20:52:18.806683 [ 71415 ] {} <Debug> HTTP-Session: 2c8b6c85-f5fe-46b5-a87d-da5f53d03c20 Authenticating user 'default' from [::1]:52972
235 2024.08.12 20:52:18.806696 [ 71415 ] {} <Debug> HTTP-Session: 2c8b6c85-f5fe-46b5-a87d-da5f53d03c20 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
236 2024.08.12 20:52:18.806702 [ 71415 ] {} <Debug> HTTP-Session: 2c8b6c85-f5fe-46b5-a87d-da5f53d03c20 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
237 2024.08.12 20:52:18.806737 [ 71415 ] {} <Trace> HTTP-Session: 2c8b6c85-f5fe-46b5-a87d-da5f53d03c20 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
238 2024.08.12 20:52:18.806944 [ 71415 ] {21ff78c8-2c87-4fab-8803-cdbc44455f4b} <Debug> executeQuery: (from [::1]:52972) /* The version table contains metadata about the `oximeter` database */
239 CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete)
240 2024.08.12 20:52:18.806991 [ 71415 ] {21ff78c8-2c87-4fab-8803-cdbc44455f4b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version
241 2024.08.12 20:52:18.807754 [ 71415 ] {21ff78c8-2c87-4fab-8803-cdbc44455f4b} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1
242 2024.08.12 20:52:18.810757 [ 71415 ] {21ff78c8-2c87-4fab-8803-cdbc44455f4b} <Debug> oximeter.version (28f2f4d8-d9e8-45d4-966c-065c1a2bd74f): Loading data parts
243 2024.08.12 20:52:18.816904 [ 71415 ] {21ff78c8-2c87-4fab-8803-cdbc44455f4b} <Debug> oximeter.version (28f2f4d8-d9e8-45d4-966c-065c1a2bd74f): There are no data parts
244 2024.08.12 20:52:18.830780 [ 71415 ] {21ff78c8-2c87-4fab-8803-cdbc44455f4b} <Debug> DynamicQueryHandler: Done processing query
245 2024.08.12 20:52:18.830806 [ 71415 ] {} <Debug> HTTP-Session: 2c8b6c85-f5fe-46b5-a87d-da5f53d03c20 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
246 2024.08.12 20:52:18.832195 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
247 2024.08.12 20:52:18.833291 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
248 2024.08.12 20:52:18.833320 [ 71415 ] {} <Debug> HTTP-Session: a11bd1f2-644d-4dae-8312-1eda11f50e14 Authenticating user 'default' from [::1]:52972
249 2024.08.12 20:52:18.833336 [ 71415 ] {} <Debug> HTTP-Session: a11bd1f2-644d-4dae-8312-1eda11f50e14 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
250 2024.08.12 20:52:18.833344 [ 71415 ] {} <Debug> HTTP-Session: a11bd1f2-644d-4dae-8312-1eda11f50e14 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
251 2024.08.12 20:52:18.833386 [ 71415 ] {} <Trace> HTTP-Session: a11bd1f2-644d-4dae-8312-1eda11f50e14 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
252 2024.08.12 20:52:18.833686 [ 71415 ] {aa1f1430-d574-449c-87d7-028b73e7509a} <Debug> executeQuery: (from [::1]:52972) /* The measurement tables contain all individual samples from each timeseries.
253 *
254 * Each table stores a single datum type, and otherwise contains nearly the same
255 * structure. The primary sorting key is on the timeseries name, key, and then
256 * timestamp, so that all timeseries from the same schema are grouped, followed
257 * by all samples from the same timeseries.
258 *
259 * This reflects that one usually looks up the _key_ in one or more field table,
260 * and then uses that to index quickly into the measurements tables.
261 */
262 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)
263 2024.08.12 20:52:18.833731 [ 71415 ] {aa1f1430-d574-449c-87d7-028b73e7509a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool
264 2024.08.12 20:52:18.838564 [ 71415 ] {aa1f1430-d574-449c-87d7-028b73e7509a} <Debug> oximeter.measurements_bool (ef70e806-060f-4546-9b5f-f2d83d02b180): Loading data parts
265 2024.08.12 20:52:18.839333 [ 71415 ] {aa1f1430-d574-449c-87d7-028b73e7509a} <Debug> oximeter.measurements_bool (ef70e806-060f-4546-9b5f-f2d83d02b180): There are no data parts
266 2024.08.12 20:52:18.846192 [ 71415 ] {aa1f1430-d574-449c-87d7-028b73e7509a} <Debug> DynamicQueryHandler: Done processing query
267 2024.08.12 20:52:18.846214 [ 71415 ] {} <Debug> HTTP-Session: a11bd1f2-644d-4dae-8312-1eda11f50e14 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
268 2024.08.12 20:52:18.847172 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
269 2024.08.12 20:52:18.847776 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
270 2024.08.12 20:52:18.847792 [ 71415 ] {} <Debug> HTTP-Session: c97f9b20-6cb9-45b1-8bbf-e32b1f2f5b75 Authenticating user 'default' from [::1]:52972
271 2024.08.12 20:52:18.847813 [ 71415 ] {} <Debug> HTTP-Session: c97f9b20-6cb9-45b1-8bbf-e32b1f2f5b75 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
272 2024.08.12 20:52:18.847821 [ 71415 ] {} <Debug> HTTP-Session: c97f9b20-6cb9-45b1-8bbf-e32b1f2f5b75 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
273 2024.08.12 20:52:18.847859 [ 71415 ] {} <Trace> HTTP-Session: c97f9b20-6cb9-45b1-8bbf-e32b1f2f5b75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
274 2024.08.12 20:52:18.848102 [ 71415 ] {30c0ae4d-c08c-4df5-ac48-56b2968fdb2e} <Debug> executeQuery: (from [::1]:52972) 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)
275 2024.08.12 20:52:18.848146 [ 71415 ] {30c0ae4d-c08c-4df5-ac48-56b2968fdb2e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8
276 2024.08.12 20:52:18.852601 [ 71415 ] {30c0ae4d-c08c-4df5-ac48-56b2968fdb2e} <Debug> oximeter.measurements_i8 (ae821573-87c3-40b7-a9e2-e0c98bdef14c): Loading data parts
277 2024.08.12 20:52:18.852980 [ 71415 ] {30c0ae4d-c08c-4df5-ac48-56b2968fdb2e} <Debug> oximeter.measurements_i8 (ae821573-87c3-40b7-a9e2-e0c98bdef14c): There are no data parts
278 2024.08.12 20:52:18.865835 [ 71415 ] {30c0ae4d-c08c-4df5-ac48-56b2968fdb2e} <Debug> DynamicQueryHandler: Done processing query
279 2024.08.12 20:52:18.865864 [ 71415 ] {} <Debug> HTTP-Session: c97f9b20-6cb9-45b1-8bbf-e32b1f2f5b75 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
280 2024.08.12 20:52:18.866884 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
281 2024.08.12 20:52:18.867965 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
282 2024.08.12 20:52:18.867985 [ 71415 ] {} <Debug> HTTP-Session: 34805c94-2e71-45a5-b0c0-5850b68dce0c Authenticating user 'default' from [::1]:52972
283 2024.08.12 20:52:18.868000 [ 71415 ] {} <Debug> HTTP-Session: 34805c94-2e71-45a5-b0c0-5850b68dce0c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
284 2024.08.12 20:52:18.868007 [ 71415 ] {} <Debug> HTTP-Session: 34805c94-2e71-45a5-b0c0-5850b68dce0c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
285 2024.08.12 20:52:18.868045 [ 71415 ] {} <Trace> HTTP-Session: 34805c94-2e71-45a5-b0c0-5850b68dce0c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
286 2024.08.12 20:52:18.868312 [ 71415 ] {03b16de4-db0a-402c-83d5-91ecd4afde82} <Debug> executeQuery: (from [::1]:52972) 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)
287 2024.08.12 20:52:18.868359 [ 71415 ] {03b16de4-db0a-402c-83d5-91ecd4afde82} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8
288 2024.08.12 20:52:18.873508 [ 71415 ] {03b16de4-db0a-402c-83d5-91ecd4afde82} <Debug> oximeter.measurements_u8 (ea1e2372-a829-465f-878b-89216b5a46c6): Loading data parts
289 2024.08.12 20:52:18.874270 [ 71415 ] {03b16de4-db0a-402c-83d5-91ecd4afde82} <Debug> oximeter.measurements_u8 (ea1e2372-a829-465f-878b-89216b5a46c6): There are no data parts
290 2024.08.12 20:52:18.877417 [ 71415 ] {03b16de4-db0a-402c-83d5-91ecd4afde82} <Debug> DynamicQueryHandler: Done processing query
291 2024.08.12 20:52:18.877440 [ 71415 ] {} <Debug> HTTP-Session: 34805c94-2e71-45a5-b0c0-5850b68dce0c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
292 2024.08.12 20:52:18.878660 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
293 2024.08.12 20:52:18.880086 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
294 2024.08.12 20:52:18.880105 [ 71415 ] {} <Debug> HTTP-Session: 6ce45bac-2bbf-46e7-a03a-8865ebcb6e86 Authenticating user 'default' from [::1]:52972
295 2024.08.12 20:52:18.880121 [ 71415 ] {} <Debug> HTTP-Session: 6ce45bac-2bbf-46e7-a03a-8865ebcb6e86 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
296 2024.08.12 20:52:18.880129 [ 71415 ] {} <Debug> HTTP-Session: 6ce45bac-2bbf-46e7-a03a-8865ebcb6e86 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
297 2024.08.12 20:52:18.880170 [ 71415 ] {} <Trace> HTTP-Session: 6ce45bac-2bbf-46e7-a03a-8865ebcb6e86 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
298 2024.08.12 20:52:18.880461 [ 71415 ] {65dcd5ff-5811-482a-83c9-f7073f6dda4a} <Debug> executeQuery: (from [::1]:52972) 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)
299 2024.08.12 20:52:18.880502 [ 71415 ] {65dcd5ff-5811-482a-83c9-f7073f6dda4a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16
300 2024.08.12 20:52:18.885803 [ 71415 ] {65dcd5ff-5811-482a-83c9-f7073f6dda4a} <Debug> oximeter.measurements_i16 (83740de9-1377-4a2d-8537-432c6275085e): Loading data parts
301 2024.08.12 20:52:18.886739 [ 71415 ] {65dcd5ff-5811-482a-83c9-f7073f6dda4a} <Debug> oximeter.measurements_i16 (83740de9-1377-4a2d-8537-432c6275085e): There are no data parts
302 2024.08.12 20:52:18.896169 [ 71415 ] {65dcd5ff-5811-482a-83c9-f7073f6dda4a} <Debug> DynamicQueryHandler: Done processing query
303 2024.08.12 20:52:18.896197 [ 71415 ] {} <Debug> HTTP-Session: 6ce45bac-2bbf-46e7-a03a-8865ebcb6e86 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
304 2024.08.12 20:52:18.897155 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
305 2024.08.12 20:52:18.904408 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
306 2024.08.12 20:52:18.904441 [ 71415 ] {} <Debug> HTTP-Session: 5f5b7680-0981-4de8-a0f5-895b305f1cfd Authenticating user 'default' from [::1]:52972
307 2024.08.12 20:52:18.904456 [ 71415 ] {} <Debug> HTTP-Session: 5f5b7680-0981-4de8-a0f5-895b305f1cfd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
308 2024.08.12 20:52:18.904465 [ 71415 ] {} <Debug> HTTP-Session: 5f5b7680-0981-4de8-a0f5-895b305f1cfd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
309 2024.08.12 20:52:18.904509 [ 71415 ] {} <Trace> HTTP-Session: 5f5b7680-0981-4de8-a0f5-895b305f1cfd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
310 2024.08.12 20:52:18.904862 [ 71415 ] {16609e08-38f6-4287-95ec-a047baa45e10} <Debug> executeQuery: (from [::1]:52972) 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)
311 2024.08.12 20:52:18.904914 [ 71415 ] {16609e08-38f6-4287-95ec-a047baa45e10} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16
312 2024.08.12 20:52:18.930089 [ 71415 ] {16609e08-38f6-4287-95ec-a047baa45e10} <Debug> oximeter.measurements_u16 (ef5fb056-ca74-4ced-979f-18c2594dfef2): Loading data parts
313 2024.08.12 20:52:18.931051 [ 71415 ] {16609e08-38f6-4287-95ec-a047baa45e10} <Debug> oximeter.measurements_u16 (ef5fb056-ca74-4ced-979f-18c2594dfef2): There are no data parts
314 2024.08.12 20:52:18.936990 [ 71415 ] {16609e08-38f6-4287-95ec-a047baa45e10} <Debug> DynamicQueryHandler: Done processing query
315 2024.08.12 20:52:18.937019 [ 71415 ] {} <Debug> HTTP-Session: 5f5b7680-0981-4de8-a0f5-895b305f1cfd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
316 2024.08.12 20:52:18.940308 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
317 2024.08.12 20:52:18.940359 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
318 2024.08.12 20:52:18.940373 [ 71415 ] {} <Debug> HTTP-Session: ae1ed42b-b622-4b01-a15f-f492af5aba06 Authenticating user 'default' from [::1]:52972
319 2024.08.12 20:52:18.940393 [ 71415 ] {} <Debug> HTTP-Session: ae1ed42b-b622-4b01-a15f-f492af5aba06 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
320 2024.08.12 20:52:18.940407 [ 71415 ] {} <Debug> HTTP-Session: ae1ed42b-b622-4b01-a15f-f492af5aba06 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
321 2024.08.12 20:52:18.940448 [ 71415 ] {} <Trace> HTTP-Session: ae1ed42b-b622-4b01-a15f-f492af5aba06 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
322 2024.08.12 20:52:18.942310 [ 71415 ] {9e36aa09-b38d-41a7-a7e2-c8bee95bb3dd} <Debug> executeQuery: (from [::1]:52972) 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)
323 2024.08.12 20:52:18.942378 [ 71415 ] {9e36aa09-b38d-41a7-a7e2-c8bee95bb3dd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32
324 2024.08.12 20:52:18.948214 [ 71415 ] {9e36aa09-b38d-41a7-a7e2-c8bee95bb3dd} <Debug> oximeter.measurements_i32 (0f769856-7994-4922-bee5-683d2fa3857c): Loading data parts
325 2024.08.12 20:52:18.948760 [ 71415 ] {9e36aa09-b38d-41a7-a7e2-c8bee95bb3dd} <Debug> oximeter.measurements_i32 (0f769856-7994-4922-bee5-683d2fa3857c): There are no data parts
326 2024.08.12 20:52:18.956227 [ 71415 ] {9e36aa09-b38d-41a7-a7e2-c8bee95bb3dd} <Debug> DynamicQueryHandler: Done processing query
327 2024.08.12 20:52:18.956256 [ 71415 ] {} <Debug> HTTP-Session: ae1ed42b-b622-4b01-a15f-f492af5aba06 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
328 2024.08.12 20:52:18.957404 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
329 2024.08.12 20:52:18.957452 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
330 2024.08.12 20:52:18.957469 [ 71415 ] {} <Debug> HTTP-Session: 8aec3742-2957-43d3-9cff-81aa7c4fbdac Authenticating user 'default' from [::1]:52972
331 2024.08.12 20:52:18.957484 [ 71415 ] {} <Debug> HTTP-Session: 8aec3742-2957-43d3-9cff-81aa7c4fbdac Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
332 2024.08.12 20:52:18.957493 [ 71415 ] {} <Debug> HTTP-Session: 8aec3742-2957-43d3-9cff-81aa7c4fbdac Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
333 2024.08.12 20:52:18.957533 [ 71415 ] {} <Trace> HTTP-Session: 8aec3742-2957-43d3-9cff-81aa7c4fbdac Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
334 2024.08.12 20:52:18.957837 [ 71415 ] {72efec27-a8e1-4a6d-8118-1b27e7299303} <Debug> executeQuery: (from [::1]:52972) 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)
335 2024.08.12 20:52:18.957890 [ 71415 ] {72efec27-a8e1-4a6d-8118-1b27e7299303} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32
336 2024.08.12 20:52:18.965778 [ 71415 ] {72efec27-a8e1-4a6d-8118-1b27e7299303} <Debug> oximeter.measurements_u32 (18312e81-69b4-470b-84d4-de5b938189a0): Loading data parts
337 2024.08.12 20:52:18.966076 [ 71415 ] {72efec27-a8e1-4a6d-8118-1b27e7299303} <Debug> oximeter.measurements_u32 (18312e81-69b4-470b-84d4-de5b938189a0): There are no data parts
338 2024.08.12 20:52:18.971118 [ 71415 ] {72efec27-a8e1-4a6d-8118-1b27e7299303} <Debug> DynamicQueryHandler: Done processing query
339 2024.08.12 20:52:18.971142 [ 71415 ] {} <Debug> HTTP-Session: 8aec3742-2957-43d3-9cff-81aa7c4fbdac Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
340 2024.08.12 20:52:18.973948 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
341 2024.08.12 20:52:18.975293 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
342 2024.08.12 20:52:18.975309 [ 71415 ] {} <Debug> HTTP-Session: 78df2f03-ea10-46b8-bfc9-80664864448e Authenticating user 'default' from [::1]:52972
343 2024.08.12 20:52:18.975320 [ 71415 ] {} <Debug> HTTP-Session: 78df2f03-ea10-46b8-bfc9-80664864448e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
344 2024.08.12 20:52:18.975327 [ 71415 ] {} <Debug> HTTP-Session: 78df2f03-ea10-46b8-bfc9-80664864448e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
345 2024.08.12 20:52:18.975355 [ 71415 ] {} <Trace> HTTP-Session: 78df2f03-ea10-46b8-bfc9-80664864448e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
346 2024.08.12 20:52:18.975636 [ 71415 ] {33bb861b-2b33-4944-a90d-f5a5b509a96c} <Debug> executeQuery: (from [::1]:52972) 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)
347 2024.08.12 20:52:18.982317 [ 71415 ] {33bb861b-2b33-4944-a90d-f5a5b509a96c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64
348 2024.08.12 20:52:18.994855 [ 71415 ] {33bb861b-2b33-4944-a90d-f5a5b509a96c} <Debug> oximeter.measurements_i64 (197250b5-e54a-4937-abbf-9b6a5a6a40a7): Loading data parts
349 2024.08.12 20:52:19.000613 [ 71658 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 385.35 MiB, peak 387.92 MiB, free memory in arenas 38.09 MiB, will set to 387.68 MiB (RSS), difference: 2.33 MiB
350 2024.08.12 20:52:19.003968 [ 71415 ] {33bb861b-2b33-4944-a90d-f5a5b509a96c} <Debug> oximeter.measurements_i64 (197250b5-e54a-4937-abbf-9b6a5a6a40a7): There are no data parts
351 2024.08.12 20:52:19.007365 [ 71415 ] {33bb861b-2b33-4944-a90d-f5a5b509a96c} <Debug> DynamicQueryHandler: Done processing query
352 2024.08.12 20:52:19.007386 [ 71415 ] {} <Debug> HTTP-Session: 78df2f03-ea10-46b8-bfc9-80664864448e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
353 2024.08.12 20:52:19.045685 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
354 2024.08.12 20:52:19.047448 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
355 2024.08.12 20:52:19.047470 [ 71415 ] {} <Debug> HTTP-Session: f7d5e104-9d6e-4934-aeb7-2077ddbe9a9e Authenticating user 'default' from [::1]:52972
356 2024.08.12 20:52:19.047486 [ 71415 ] {} <Debug> HTTP-Session: f7d5e104-9d6e-4934-aeb7-2077ddbe9a9e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
357 2024.08.12 20:52:19.047495 [ 71415 ] {} <Debug> HTTP-Session: f7d5e104-9d6e-4934-aeb7-2077ddbe9a9e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
358 2024.08.12 20:52:19.047553 [ 71415 ] {} <Trace> HTTP-Session: f7d5e104-9d6e-4934-aeb7-2077ddbe9a9e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
359 2024.08.12 20:52:19.048615 [ 71415 ] {6b94278a-bb0b-40cb-aaa9-d360b39002a4} <Debug> executeQuery: (from [::1]:52972) 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)
360 2024.08.12 20:52:19.048663 [ 71415 ] {6b94278a-bb0b-40cb-aaa9-d360b39002a4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64
361 2024.08.12 20:52:19.054937 [ 71415 ] {6b94278a-bb0b-40cb-aaa9-d360b39002a4} <Debug> oximeter.measurements_u64 (efeb60fe-9c0b-49af-a3e6-50ae03445f76): Loading data parts
362 2024.08.12 20:52:19.055194 [ 71415 ] {6b94278a-bb0b-40cb-aaa9-d360b39002a4} <Debug> oximeter.measurements_u64 (efeb60fe-9c0b-49af-a3e6-50ae03445f76): There are no data parts
363 2024.08.12 20:52:19.058029 [ 71415 ] {6b94278a-bb0b-40cb-aaa9-d360b39002a4} <Debug> DynamicQueryHandler: Done processing query
364 2024.08.12 20:52:19.058049 [ 71415 ] {} <Debug> HTTP-Session: f7d5e104-9d6e-4934-aeb7-2077ddbe9a9e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
365 2024.08.12 20:52:19.059732 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
366 2024.08.12 20:52:19.059771 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
367 2024.08.12 20:52:19.059784 [ 71415 ] {} <Debug> HTTP-Session: 5e20c1ef-8352-4301-80a7-1d59ced8893d Authenticating user 'default' from [::1]:52972
368 2024.08.12 20:52:19.059796 [ 71415 ] {} <Debug> HTTP-Session: 5e20c1ef-8352-4301-80a7-1d59ced8893d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
369 2024.08.12 20:52:19.059803 [ 71415 ] {} <Debug> HTTP-Session: 5e20c1ef-8352-4301-80a7-1d59ced8893d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
370 2024.08.12 20:52:19.059834 [ 71415 ] {} <Trace> HTTP-Session: 5e20c1ef-8352-4301-80a7-1d59ced8893d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
371 2024.08.12 20:52:19.060059 [ 71415 ] {80edd6d6-4c6a-4e84-8ea6-28a1d37d4b7e} <Debug> executeQuery: (from [::1]:52972) 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)
372 2024.08.12 20:52:19.060100 [ 71415 ] {80edd6d6-4c6a-4e84-8ea6-28a1d37d4b7e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32
373 2024.08.12 20:52:19.066328 [ 71415 ] {80edd6d6-4c6a-4e84-8ea6-28a1d37d4b7e} <Debug> oximeter.measurements_f32 (252fc1a8-ec0c-48dd-8e98-2770dbf6c96e): Loading data parts
374 2024.08.12 20:52:19.073008 [ 71415 ] {80edd6d6-4c6a-4e84-8ea6-28a1d37d4b7e} <Debug> oximeter.measurements_f32 (252fc1a8-ec0c-48dd-8e98-2770dbf6c96e): There are no data parts
375 2024.08.12 20:52:19.078202 [ 71415 ] {80edd6d6-4c6a-4e84-8ea6-28a1d37d4b7e} <Debug> DynamicQueryHandler: Done processing query
376 2024.08.12 20:52:19.078245 [ 71415 ] {} <Debug> HTTP-Session: 5e20c1ef-8352-4301-80a7-1d59ced8893d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
377 2024.08.12 20:52:19.079288 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
378 2024.08.12 20:52:19.079331 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
379 2024.08.12 20:52:19.079423 [ 71415 ] {} <Debug> HTTP-Session: 13a512bc-bd0b-4017-b934-3981947a2384 Authenticating user 'default' from [::1]:52972
380 2024.08.12 20:52:19.079449 [ 71415 ] {} <Debug> HTTP-Session: 13a512bc-bd0b-4017-b934-3981947a2384 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
381 2024.08.12 20:52:19.079458 [ 71415 ] {} <Debug> HTTP-Session: 13a512bc-bd0b-4017-b934-3981947a2384 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
382 2024.08.12 20:52:19.079498 [ 71415 ] {} <Trace> HTTP-Session: 13a512bc-bd0b-4017-b934-3981947a2384 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
383 2024.08.12 20:52:19.079812 [ 71415 ] {f7541ace-2de9-4ebc-8d43-2bcd2f700086} <Debug> executeQuery: (from [::1]:52972) 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)
384 2024.08.12 20:52:19.079892 [ 71415 ] {f7541ace-2de9-4ebc-8d43-2bcd2f700086} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64
385 2024.08.12 20:52:19.086961 [ 71415 ] {f7541ace-2de9-4ebc-8d43-2bcd2f700086} <Debug> oximeter.measurements_f64 (0dd9f954-92be-496b-9730-07c7ad66272b): Loading data parts
386 2024.08.12 20:52:19.087264 [ 71415 ] {f7541ace-2de9-4ebc-8d43-2bcd2f700086} <Debug> oximeter.measurements_f64 (0dd9f954-92be-496b-9730-07c7ad66272b): There are no data parts
387 2024.08.12 20:52:19.093047 [ 71415 ] {f7541ace-2de9-4ebc-8d43-2bcd2f700086} <Debug> DynamicQueryHandler: Done processing query
388 2024.08.12 20:52:19.093070 [ 71415 ] {} <Debug> HTTP-Session: 13a512bc-bd0b-4017-b934-3981947a2384 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
389 2024.08.12 20:52:19.094703 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
390 2024.08.12 20:52:19.095169 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
391 2024.08.12 20:52:19.095186 [ 71415 ] {} <Debug> HTTP-Session: f24d1ef8-73e2-4592-87fc-aa7658500179 Authenticating user 'default' from [::1]:52972
392 2024.08.12 20:52:19.095213 [ 71415 ] {} <Debug> HTTP-Session: f24d1ef8-73e2-4592-87fc-aa7658500179 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
393 2024.08.12 20:52:19.095221 [ 71415 ] {} <Debug> HTTP-Session: f24d1ef8-73e2-4592-87fc-aa7658500179 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
394 2024.08.12 20:52:19.095259 [ 71415 ] {} <Trace> HTTP-Session: f24d1ef8-73e2-4592-87fc-aa7658500179 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
395 2024.08.12 20:52:19.095505 [ 71415 ] {1b82edc8-2645-45fb-9fd6-81c9d991fc4c} <Debug> executeQuery: (from [::1]:52972) 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)
396 2024.08.12 20:52:19.095590 [ 71415 ] {1b82edc8-2645-45fb-9fd6-81c9d991fc4c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string
397 2024.08.12 20:52:19.114407 [ 71415 ] {1b82edc8-2645-45fb-9fd6-81c9d991fc4c} <Debug> oximeter.measurements_string (d3af55e0-9afa-4a40-a0da-6a3281811b21): Loading data parts
398 2024.08.12 20:52:19.115758 [ 71415 ] {1b82edc8-2645-45fb-9fd6-81c9d991fc4c} <Debug> oximeter.measurements_string (d3af55e0-9afa-4a40-a0da-6a3281811b21): There are no data parts
399 2024.08.12 20:52:19.119700 [ 71415 ] {1b82edc8-2645-45fb-9fd6-81c9d991fc4c} <Debug> DynamicQueryHandler: Done processing query
400 2024.08.12 20:52:19.119724 [ 71415 ] {} <Debug> HTTP-Session: f24d1ef8-73e2-4592-87fc-aa7658500179 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
401 2024.08.12 20:52:19.120546 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
402 2024.08.12 20:52:19.120596 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
403 2024.08.12 20:52:19.120609 [ 71415 ] {} <Debug> HTTP-Session: 1ec67577-ef22-4a33-9c8f-0f9def222013 Authenticating user 'default' from [::1]:52972
404 2024.08.12 20:52:19.120622 [ 71415 ] {} <Debug> HTTP-Session: 1ec67577-ef22-4a33-9c8f-0f9def222013 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
405 2024.08.12 20:52:19.120635 [ 71415 ] {} <Debug> HTTP-Session: 1ec67577-ef22-4a33-9c8f-0f9def222013 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
406 2024.08.12 20:52:19.120672 [ 71415 ] {} <Trace> HTTP-Session: 1ec67577-ef22-4a33-9c8f-0f9def222013 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
407 2024.08.12 20:52:19.121370 [ 71415 ] {e72ad391-b84b-49a1-bb4b-ae3bfab07f92} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /*
408 * NOTE: Right now we can't unambiguously record a nullable byte array.
409 * Arrays cannot be nested in `Nullable()` types, and encoding the array as
410 * a string isn't palatable for a few reasons.
411 * See: https://github.com/oxidecomputer/omicron/issues/4551 for more
412 * details.
413 */
414 datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
415 2024.08.12 20:52:19.121417 [ 71415 ] {e72ad391-b84b-49a1-bb4b-ae3bfab07f92} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes
416 2024.08.12 20:52:19.126341 [ 71415 ] {e72ad391-b84b-49a1-bb4b-ae3bfab07f92} <Debug> oximeter.measurements_bytes (655b15e2-f975-49ef-a0af-70a5553c4f92): Loading data parts
417 2024.08.12 20:52:19.127205 [ 71415 ] {e72ad391-b84b-49a1-bb4b-ae3bfab07f92} <Debug> oximeter.measurements_bytes (655b15e2-f975-49ef-a0af-70a5553c4f92): There are no data parts
418 2024.08.12 20:52:19.133136 [ 71415 ] {e72ad391-b84b-49a1-bb4b-ae3bfab07f92} <Debug> DynamicQueryHandler: Done processing query
419 2024.08.12 20:52:19.133158 [ 71415 ] {} <Debug> HTTP-Session: 1ec67577-ef22-4a33-9c8f-0f9def222013 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
420 2024.08.12 20:52:19.134167 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
421 2024.08.12 20:52:19.134420 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
422 2024.08.12 20:52:19.135394 [ 71415 ] {} <Debug> HTTP-Session: 7ae87aa6-da59-44f3-afb5-cb11b28e18fd Authenticating user 'default' from [::1]:52972
423 2024.08.12 20:52:19.135416 [ 71415 ] {} <Debug> HTTP-Session: 7ae87aa6-da59-44f3-afb5-cb11b28e18fd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
424 2024.08.12 20:52:19.135425 [ 71415 ] {} <Debug> HTTP-Session: 7ae87aa6-da59-44f3-afb5-cb11b28e18fd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
425 2024.08.12 20:52:19.135468 [ 71415 ] {} <Trace> HTTP-Session: 7ae87aa6-da59-44f3-afb5-cb11b28e18fd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
426 2024.08.12 20:52:19.135779 [ 71415 ] {130b26f8-2f3a-46bc-8488-1c337e245c6f} <Debug> executeQuery: (from [::1]:52972) 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)
427 2024.08.12 20:52:19.135855 [ 71415 ] {130b26f8-2f3a-46bc-8488-1c337e245c6f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64
428 2024.08.12 20:52:19.141850 [ 71415 ] {130b26f8-2f3a-46bc-8488-1c337e245c6f} <Debug> oximeter.measurements_cumulativei64 (da0dd6db-4276-4860-bf7a-3bb92e3c558a): Loading data parts
429 2024.08.12 20:52:19.142122 [ 71415 ] {130b26f8-2f3a-46bc-8488-1c337e245c6f} <Debug> oximeter.measurements_cumulativei64 (da0dd6db-4276-4860-bf7a-3bb92e3c558a): There are no data parts
430 2024.08.12 20:52:19.145337 [ 71415 ] {130b26f8-2f3a-46bc-8488-1c337e245c6f} <Debug> DynamicQueryHandler: Done processing query
431 2024.08.12 20:52:19.145358 [ 71415 ] {} <Debug> HTTP-Session: 7ae87aa6-da59-44f3-afb5-cb11b28e18fd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
432 2024.08.12 20:52:19.146462 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
433 2024.08.12 20:52:19.148801 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
434 2024.08.12 20:52:19.148819 [ 71415 ] {} <Debug> HTTP-Session: 2a4733cf-0d85-41aa-a2b8-43878ef1ce29 Authenticating user 'default' from [::1]:52972
435 2024.08.12 20:52:19.148833 [ 71415 ] {} <Debug> HTTP-Session: 2a4733cf-0d85-41aa-a2b8-43878ef1ce29 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
436 2024.08.12 20:52:19.148840 [ 71415 ] {} <Debug> HTTP-Session: 2a4733cf-0d85-41aa-a2b8-43878ef1ce29 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
437 2024.08.12 20:52:19.148875 [ 71415 ] {} <Trace> HTTP-Session: 2a4733cf-0d85-41aa-a2b8-43878ef1ce29 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
438 2024.08.12 20:52:19.149121 [ 71415 ] {b663d781-c66c-438d-a74f-c89a2c428a8b} <Debug> executeQuery: (from [::1]:52972) 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)
439 2024.08.12 20:52:19.149168 [ 71415 ] {b663d781-c66c-438d-a74f-c89a2c428a8b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64
440 2024.08.12 20:52:19.157783 [ 71415 ] {b663d781-c66c-438d-a74f-c89a2c428a8b} <Debug> oximeter.measurements_cumulativeu64 (c0fa24b6-7bf6-4f26-b102-d13455ceb7b8): Loading data parts
441 2024.08.12 20:52:19.158099 [ 71415 ] {b663d781-c66c-438d-a74f-c89a2c428a8b} <Debug> oximeter.measurements_cumulativeu64 (c0fa24b6-7bf6-4f26-b102-d13455ceb7b8): There are no data parts
442 2024.08.12 20:52:19.162133 [ 71415 ] {b663d781-c66c-438d-a74f-c89a2c428a8b} <Debug> DynamicQueryHandler: Done processing query
443 2024.08.12 20:52:19.162153 [ 71415 ] {} <Debug> HTTP-Session: 2a4733cf-0d85-41aa-a2b8-43878ef1ce29 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
444 2024.08.12 20:52:19.163146 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
445 2024.08.12 20:52:19.164893 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
446 2024.08.12 20:52:19.164910 [ 71415 ] {} <Debug> HTTP-Session: b8b7ac9f-eaf4-43a4-afba-89cd439777c8 Authenticating user 'default' from [::1]:52972
447 2024.08.12 20:52:19.164923 [ 71415 ] {} <Debug> HTTP-Session: b8b7ac9f-eaf4-43a4-afba-89cd439777c8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
448 2024.08.12 20:52:19.164929 [ 71415 ] {} <Debug> HTTP-Session: b8b7ac9f-eaf4-43a4-afba-89cd439777c8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
449 2024.08.12 20:52:19.164965 [ 71415 ] {} <Trace> HTTP-Session: b8b7ac9f-eaf4-43a4-afba-89cd439777c8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
450 2024.08.12 20:52:19.165230 [ 71415 ] {fe85f694-9454-43d2-8697-4e8c261fba55} <Debug> executeQuery: (from [::1]:52972) 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)
451 2024.08.12 20:52:19.165281 [ 71415 ] {fe85f694-9454-43d2-8697-4e8c261fba55} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32
452 2024.08.12 20:52:19.170397 [ 71415 ] {fe85f694-9454-43d2-8697-4e8c261fba55} <Debug> oximeter.measurements_cumulativef32 (eb5dfa5d-adec-4d74-8b8c-36e94c7a7753): Loading data parts
453 2024.08.12 20:52:19.170672 [ 71415 ] {fe85f694-9454-43d2-8697-4e8c261fba55} <Debug> oximeter.measurements_cumulativef32 (eb5dfa5d-adec-4d74-8b8c-36e94c7a7753): There are no data parts
454 2024.08.12 20:52:19.180946 [ 71415 ] {fe85f694-9454-43d2-8697-4e8c261fba55} <Debug> DynamicQueryHandler: Done processing query
455 2024.08.12 20:52:19.180979 [ 71415 ] {} <Debug> HTTP-Session: b8b7ac9f-eaf4-43a4-afba-89cd439777c8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
456 2024.08.12 20:52:19.181870 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
457 2024.08.12 20:52:19.181923 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
458 2024.08.12 20:52:19.181936 [ 71415 ] {} <Debug> HTTP-Session: 96c43eb8-92ef-46f8-b9b3-6d42cab886fd Authenticating user 'default' from [::1]:52972
459 2024.08.12 20:52:19.181949 [ 71415 ] {} <Debug> HTTP-Session: 96c43eb8-92ef-46f8-b9b3-6d42cab886fd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
460 2024.08.12 20:52:19.181956 [ 71415 ] {} <Debug> HTTP-Session: 96c43eb8-92ef-46f8-b9b3-6d42cab886fd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
461 2024.08.12 20:52:19.181994 [ 71415 ] {} <Trace> HTTP-Session: 96c43eb8-92ef-46f8-b9b3-6d42cab886fd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
462 2024.08.12 20:52:19.182255 [ 71415 ] {2527bb3c-fd87-42ef-8849-4ba5c9557f70} <Debug> executeQuery: (from [::1]:52972) 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)
463 2024.08.12 20:52:19.183789 [ 71415 ] {2527bb3c-fd87-42ef-8849-4ba5c9557f70} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64
464 2024.08.12 20:52:19.190774 [ 71415 ] {2527bb3c-fd87-42ef-8849-4ba5c9557f70} <Debug> oximeter.measurements_cumulativef64 (744e6c3c-9318-468f-b0a3-021831e12259): Loading data parts
465 2024.08.12 20:52:19.191265 [ 71415 ] {2527bb3c-fd87-42ef-8849-4ba5c9557f70} <Debug> oximeter.measurements_cumulativef64 (744e6c3c-9318-468f-b0a3-021831e12259): There are no data parts
466 2024.08.12 20:52:19.194858 [ 71415 ] {2527bb3c-fd87-42ef-8849-4ba5c9557f70} <Debug> DynamicQueryHandler: Done processing query
467 2024.08.12 20:52:19.194882 [ 71415 ] {} <Debug> HTTP-Session: 96c43eb8-92ef-46f8-b9b3-6d42cab886fd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
468 2024.08.12 20:52:19.195821 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
469 2024.08.12 20:52:19.196534 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
470 2024.08.12 20:52:19.196554 [ 71415 ] {} <Debug> HTTP-Session: 1f1076e7-3e9b-41ca-9519-d6667f4726dd Authenticating user 'default' from [::1]:52972
471 2024.08.12 20:52:19.196569 [ 71415 ] {} <Debug> HTTP-Session: 1f1076e7-3e9b-41ca-9519-d6667f4726dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
472 2024.08.12 20:52:19.196585 [ 71415 ] {} <Debug> HTTP-Session: 1f1076e7-3e9b-41ca-9519-d6667f4726dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
473 2024.08.12 20:52:19.196644 [ 71415 ] {} <Trace> HTTP-Session: 1f1076e7-3e9b-41ca-9519-d6667f4726dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
474 2024.08.12 20:52:19.196990 [ 71415 ] {6b492404-46d2-4c8a-91fb-c4404c6a7bef} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /*
475 * NOTE: Array types cannot be Nullable, see
476 * https://clickhouse.com/docs/en/sql-reference/data-types/nullable
477 * for more details.
478 *
479 * This means we need to use empty arrays to indicate a missing value. This
480 * is unfortunate, and at this point relies on the fact that an
481 * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need
482 * to figure out another way to represent missing samples here.
483 */
484 bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
485 2024.08.12 20:52:19.197047 [ 71415 ] {6b492404-46d2-4c8a-91fb-c4404c6a7bef} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8
486 2024.08.12 20:52:19.206129 [ 71415 ] {6b492404-46d2-4c8a-91fb-c4404c6a7bef} <Debug> oximeter.measurements_histogrami8 (8febf9b6-8335-4c90-a283-3c0fcea3c299): Loading data parts
487 2024.08.12 20:52:19.206452 [ 71415 ] {6b492404-46d2-4c8a-91fb-c4404c6a7bef} <Debug> oximeter.measurements_histogrami8 (8febf9b6-8335-4c90-a283-3c0fcea3c299): There are no data parts
488 2024.08.12 20:52:19.210290 [ 71415 ] {6b492404-46d2-4c8a-91fb-c4404c6a7bef} <Debug> DynamicQueryHandler: Done processing query
489 2024.08.12 20:52:19.210309 [ 71415 ] {} <Debug> HTTP-Session: 1f1076e7-3e9b-41ca-9519-d6667f4726dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
490 2024.08.12 20:52:19.211411 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
491 2024.08.12 20:52:19.211818 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
492 2024.08.12 20:52:19.211833 [ 71415 ] {} <Debug> HTTP-Session: ceea191a-a8a5-47c5-b60b-1a13a3fb129f Authenticating user 'default' from [::1]:52972
493 2024.08.12 20:52:19.211847 [ 71415 ] {} <Debug> HTTP-Session: ceea191a-a8a5-47c5-b60b-1a13a3fb129f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
494 2024.08.12 20:52:19.211854 [ 71415 ] {} <Debug> HTTP-Session: ceea191a-a8a5-47c5-b60b-1a13a3fb129f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
495 2024.08.12 20:52:19.211888 [ 71415 ] {} <Trace> HTTP-Session: ceea191a-a8a5-47c5-b60b-1a13a3fb129f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
496 2024.08.12 20:52:19.212182 [ 71415 ] {dd7911f4-3944-42f5-9659-9f8c4aa3451f} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
497 2024.08.12 20:52:19.212241 [ 71415 ] {dd7911f4-3944-42f5-9659-9f8c4aa3451f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8
498 2024.08.12 20:52:19.218198 [ 71415 ] {dd7911f4-3944-42f5-9659-9f8c4aa3451f} <Debug> oximeter.measurements_histogramu8 (878f30fe-cdbc-449f-bef3-0331a88b92ab): Loading data parts
499 2024.08.12 20:52:19.218466 [ 71415 ] {dd7911f4-3944-42f5-9659-9f8c4aa3451f} <Debug> oximeter.measurements_histogramu8 (878f30fe-cdbc-449f-bef3-0331a88b92ab): There are no data parts
500 2024.08.12 20:52:19.222141 [ 71415 ] {dd7911f4-3944-42f5-9659-9f8c4aa3451f} <Debug> DynamicQueryHandler: Done processing query
501 2024.08.12 20:52:19.222161 [ 71415 ] {} <Debug> HTTP-Session: ceea191a-a8a5-47c5-b60b-1a13a3fb129f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
502 2024.08.12 20:52:19.223271 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
503 2024.08.12 20:52:19.224436 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
504 2024.08.12 20:52:19.224452 [ 71415 ] {} <Debug> HTTP-Session: 8b7175fc-c423-4ac8-a773-e72d3d661582 Authenticating user 'default' from [::1]:52972
505 2024.08.12 20:52:19.224465 [ 71415 ] {} <Debug> HTTP-Session: 8b7175fc-c423-4ac8-a773-e72d3d661582 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
506 2024.08.12 20:52:19.224471 [ 71415 ] {} <Debug> HTTP-Session: 8b7175fc-c423-4ac8-a773-e72d3d661582 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
507 2024.08.12 20:52:19.224501 [ 71415 ] {} <Trace> HTTP-Session: 8b7175fc-c423-4ac8-a773-e72d3d661582 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
508 2024.08.12 20:52:19.224801 [ 71415 ] {b8fb685a-6f9e-4a6e-b8fb-9cdedbcfc9c8} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
509 2024.08.12 20:52:19.224849 [ 71415 ] {b8fb685a-6f9e-4a6e-b8fb-9cdedbcfc9c8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16
510 2024.08.12 20:52:19.238765 [ 71415 ] {b8fb685a-6f9e-4a6e-b8fb-9cdedbcfc9c8} <Debug> oximeter.measurements_histogrami16 (c1ce7d11-3730-4d98-a594-45fcd6bd7303): Loading data parts
511 2024.08.12 20:52:19.239019 [ 71415 ] {b8fb685a-6f9e-4a6e-b8fb-9cdedbcfc9c8} <Debug> oximeter.measurements_histogrami16 (c1ce7d11-3730-4d98-a594-45fcd6bd7303): There are no data parts
512 2024.08.12 20:52:19.245661 [ 71415 ] {b8fb685a-6f9e-4a6e-b8fb-9cdedbcfc9c8} <Debug> DynamicQueryHandler: Done processing query
513 2024.08.12 20:52:19.245687 [ 71415 ] {} <Debug> HTTP-Session: 8b7175fc-c423-4ac8-a773-e72d3d661582 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
514 2024.08.12 20:52:19.246602 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
515 2024.08.12 20:52:19.247188 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
516 2024.08.12 20:52:19.247228 [ 71415 ] {} <Debug> HTTP-Session: 4920ca3e-420a-4300-9c91-97834bb512ff Authenticating user 'default' from [::1]:52972
517 2024.08.12 20:52:19.247243 [ 71415 ] {} <Debug> HTTP-Session: 4920ca3e-420a-4300-9c91-97834bb512ff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
518 2024.08.12 20:52:19.247250 [ 71415 ] {} <Debug> HTTP-Session: 4920ca3e-420a-4300-9c91-97834bb512ff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
519 2024.08.12 20:52:19.247286 [ 71415 ] {} <Trace> HTTP-Session: 4920ca3e-420a-4300-9c91-97834bb512ff Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
520 2024.08.12 20:52:19.247624 [ 71415 ] {ebd6e7a2-bda8-4d1e-906e-57a0f231ecbd} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
521 2024.08.12 20:52:19.247679 [ 71415 ] {ebd6e7a2-bda8-4d1e-906e-57a0f231ecbd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16
522 2024.08.12 20:52:19.251845 [ 71415 ] {ebd6e7a2-bda8-4d1e-906e-57a0f231ecbd} <Debug> oximeter.measurements_histogramu16 (12522d23-5cf1-47a9-9626-1596df99a45e): Loading data parts
523 2024.08.12 20:52:19.252070 [ 71415 ] {ebd6e7a2-bda8-4d1e-906e-57a0f231ecbd} <Debug> oximeter.measurements_histogramu16 (12522d23-5cf1-47a9-9626-1596df99a45e): There are no data parts
524 2024.08.12 20:52:19.256754 [ 71415 ] {ebd6e7a2-bda8-4d1e-906e-57a0f231ecbd} <Debug> DynamicQueryHandler: Done processing query
525 2024.08.12 20:52:19.256774 [ 71415 ] {} <Debug> HTTP-Session: 4920ca3e-420a-4300-9c91-97834bb512ff Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
526 2024.08.12 20:52:19.257808 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
527 2024.08.12 20:52:19.259481 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
528 2024.08.12 20:52:19.259496 [ 71415 ] {} <Debug> HTTP-Session: 94dc936b-c3d4-49b2-b415-19616409775a Authenticating user 'default' from [::1]:52972
529 2024.08.12 20:52:19.259510 [ 71415 ] {} <Debug> HTTP-Session: 94dc936b-c3d4-49b2-b415-19616409775a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
530 2024.08.12 20:52:19.259517 [ 71415 ] {} <Debug> HTTP-Session: 94dc936b-c3d4-49b2-b415-19616409775a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
531 2024.08.12 20:52:19.259566 [ 71415 ] {} <Trace> HTTP-Session: 94dc936b-c3d4-49b2-b415-19616409775a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
532 2024.08.12 20:52:19.259915 [ 71415 ] {748058e2-b504-4461-a628-3f2b2d4d7263} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
533 2024.08.12 20:52:19.259976 [ 71415 ] {748058e2-b504-4461-a628-3f2b2d4d7263} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32
534 2024.08.12 20:52:19.266278 [ 71415 ] {748058e2-b504-4461-a628-3f2b2d4d7263} <Debug> oximeter.measurements_histogrami32 (6720c9bd-2062-434d-ad1c-3356cf443e70): Loading data parts
535 2024.08.12 20:52:19.266555 [ 71415 ] {748058e2-b504-4461-a628-3f2b2d4d7263} <Debug> oximeter.measurements_histogrami32 (6720c9bd-2062-434d-ad1c-3356cf443e70): There are no data parts
536 2024.08.12 20:52:19.270153 [ 71415 ] {748058e2-b504-4461-a628-3f2b2d4d7263} <Debug> DynamicQueryHandler: Done processing query
537 2024.08.12 20:52:19.270174 [ 71415 ] {} <Debug> HTTP-Session: 94dc936b-c3d4-49b2-b415-19616409775a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
538 2024.08.12 20:52:19.271300 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
539 2024.08.12 20:52:19.271335 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
540 2024.08.12 20:52:19.271345 [ 71415 ] {} <Debug> HTTP-Session: 6f30c0e8-fe65-4d97-90b0-0420c77f0acd Authenticating user 'default' from [::1]:52972
541 2024.08.12 20:52:19.271357 [ 71415 ] {} <Debug> HTTP-Session: 6f30c0e8-fe65-4d97-90b0-0420c77f0acd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
542 2024.08.12 20:52:19.272805 [ 71415 ] {} <Debug> HTTP-Session: 6f30c0e8-fe65-4d97-90b0-0420c77f0acd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
543 2024.08.12 20:52:19.272852 [ 71415 ] {} <Trace> HTTP-Session: 6f30c0e8-fe65-4d97-90b0-0420c77f0acd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
544 2024.08.12 20:52:19.273169 [ 71415 ] {8384f69d-38bc-47f5-8e5f-2221061b6644} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
545 2024.08.12 20:52:19.273227 [ 71415 ] {8384f69d-38bc-47f5-8e5f-2221061b6644} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32
546 2024.08.12 20:52:19.278444 [ 71415 ] {8384f69d-38bc-47f5-8e5f-2221061b6644} <Debug> oximeter.measurements_histogramu32 (80a9b530-8081-4353-b530-b314bfa45ed6): Loading data parts
547 2024.08.12 20:52:19.278854 [ 71415 ] {8384f69d-38bc-47f5-8e5f-2221061b6644} <Debug> oximeter.measurements_histogramu32 (80a9b530-8081-4353-b530-b314bfa45ed6): There are no data parts
548 2024.08.12 20:52:19.283556 [ 71415 ] {8384f69d-38bc-47f5-8e5f-2221061b6644} <Debug> DynamicQueryHandler: Done processing query
549 2024.08.12 20:52:19.283577 [ 71415 ] {} <Debug> HTTP-Session: 6f30c0e8-fe65-4d97-90b0-0420c77f0acd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
550 2024.08.12 20:52:19.284528 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
551 2024.08.12 20:52:19.284563 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
552 2024.08.12 20:52:19.284573 [ 71415 ] {} <Debug> HTTP-Session: 56c04324-e139-4cbf-abb8-01de097c8431 Authenticating user 'default' from [::1]:52972
553 2024.08.12 20:52:19.284583 [ 71415 ] {} <Debug> HTTP-Session: 56c04324-e139-4cbf-abb8-01de097c8431 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
554 2024.08.12 20:52:19.284589 [ 71415 ] {} <Debug> HTTP-Session: 56c04324-e139-4cbf-abb8-01de097c8431 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
555 2024.08.12 20:52:19.284616 [ 71415 ] {} <Trace> HTTP-Session: 56c04324-e139-4cbf-abb8-01de097c8431 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
556 2024.08.12 20:52:19.284900 [ 71415 ] {37fd43f7-e7a7-48da-a71c-184a611fa63e} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
557 2024.08.12 20:52:19.284950 [ 71415 ] {37fd43f7-e7a7-48da-a71c-184a611fa63e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64
558 2024.08.12 20:52:19.290018 [ 71415 ] {37fd43f7-e7a7-48da-a71c-184a611fa63e} <Debug> oximeter.measurements_histogrami64 (0682e0d7-62f4-4b41-840c-803788093858): Loading data parts
559 2024.08.12 20:52:19.290259 [ 71415 ] {37fd43f7-e7a7-48da-a71c-184a611fa63e} <Debug> oximeter.measurements_histogrami64 (0682e0d7-62f4-4b41-840c-803788093858): There are no data parts
560 2024.08.12 20:52:19.296732 [ 71415 ] {37fd43f7-e7a7-48da-a71c-184a611fa63e} <Debug> DynamicQueryHandler: Done processing query
561 2024.08.12 20:52:19.296758 [ 71415 ] {} <Debug> HTTP-Session: 56c04324-e139-4cbf-abb8-01de097c8431 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
562 2024.08.12 20:52:19.298827 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
563 2024.08.12 20:52:19.300306 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
564 2024.08.12 20:52:19.300343 [ 71415 ] {} <Debug> HTTP-Session: 0789a2dd-c65d-4478-bb69-12ba6bcb285c Authenticating user 'default' from [::1]:52972
565 2024.08.12 20:52:19.300359 [ 71415 ] {} <Debug> HTTP-Session: 0789a2dd-c65d-4478-bb69-12ba6bcb285c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
566 2024.08.12 20:52:19.300367 [ 71415 ] {} <Debug> HTTP-Session: 0789a2dd-c65d-4478-bb69-12ba6bcb285c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
567 2024.08.12 20:52:19.300413 [ 71415 ] {} <Trace> HTTP-Session: 0789a2dd-c65d-4478-bb69-12ba6bcb285c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
568 2024.08.12 20:52:19.300737 [ 71415 ] {8853ff77-dd71-4ed6-a60c-9c85b6e4cf57} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
569 2024.08.12 20:52:19.300792 [ 71415 ] {8853ff77-dd71-4ed6-a60c-9c85b6e4cf57} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64
570 2024.08.12 20:52:19.305377 [ 71415 ] {8853ff77-dd71-4ed6-a60c-9c85b6e4cf57} <Debug> oximeter.measurements_histogramu64 (ee6b91ba-371d-4df3-b14a-6f0c14a9fce8): Loading data parts
571 2024.08.12 20:52:19.306151 [ 71415 ] {8853ff77-dd71-4ed6-a60c-9c85b6e4cf57} <Debug> oximeter.measurements_histogramu64 (ee6b91ba-371d-4df3-b14a-6f0c14a9fce8): There are no data parts
572 2024.08.12 20:52:19.310493 [ 71415 ] {8853ff77-dd71-4ed6-a60c-9c85b6e4cf57} <Debug> DynamicQueryHandler: Done processing query
573 2024.08.12 20:52:19.310510 [ 71415 ] {} <Debug> HTTP-Session: 0789a2dd-c65d-4478-bb69-12ba6bcb285c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
574 2024.08.12 20:52:19.376519 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
575 2024.08.12 20:52:19.378026 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
576 2024.08.12 20:52:19.378051 [ 71415 ] {} <Debug> HTTP-Session: 2394d5cc-2031-4631-96b3-4dfbb703593e Authenticating user 'default' from [::1]:52972
577 2024.08.12 20:52:19.378067 [ 71415 ] {} <Debug> HTTP-Session: 2394d5cc-2031-4631-96b3-4dfbb703593e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
578 2024.08.12 20:52:19.378075 [ 71415 ] {} <Debug> HTTP-Session: 2394d5cc-2031-4631-96b3-4dfbb703593e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
579 2024.08.12 20:52:19.378131 [ 71415 ] {} <Trace> HTTP-Session: 2394d5cc-2031-4631-96b3-4dfbb703593e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
580 2024.08.12 20:52:19.378518 [ 71415 ] {d45c8c1b-6d8c-42a0-a3fc-279584321de8} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
581 2024.08.12 20:52:19.378579 [ 71415 ] {d45c8c1b-6d8c-42a0-a3fc-279584321de8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32
582 2024.08.12 20:52:19.383824 [ 71415 ] {d45c8c1b-6d8c-42a0-a3fc-279584321de8} <Debug> oximeter.measurements_histogramf32 (741dbfc0-891a-45d2-8810-0d544c8436e9): Loading data parts
583 2024.08.12 20:52:19.384781 [ 71415 ] {d45c8c1b-6d8c-42a0-a3fc-279584321de8} <Debug> oximeter.measurements_histogramf32 (741dbfc0-891a-45d2-8810-0d544c8436e9): There are no data parts
584 2024.08.12 20:52:19.387974 [ 71415 ] {d45c8c1b-6d8c-42a0-a3fc-279584321de8} <Debug> DynamicQueryHandler: Done processing query
585 2024.08.12 20:52:19.387995 [ 71415 ] {} <Debug> HTTP-Session: 2394d5cc-2031-4631-96b3-4dfbb703593e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
586 2024.08.12 20:52:19.393764 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
587 2024.08.12 20:52:19.393819 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
588 2024.08.12 20:52:19.393834 [ 71415 ] {} <Debug> HTTP-Session: e9e2df9a-4b0c-4944-9d74-86e8867d378f Authenticating user 'default' from [::1]:52972
589 2024.08.12 20:52:19.393848 [ 71415 ] {} <Debug> HTTP-Session: e9e2df9a-4b0c-4944-9d74-86e8867d378f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
590 2024.08.12 20:52:19.393855 [ 71415 ] {} <Debug> HTTP-Session: e9e2df9a-4b0c-4944-9d74-86e8867d378f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
591 2024.08.12 20:52:19.393897 [ 71415 ] {} <Trace> HTTP-Session: e9e2df9a-4b0c-4944-9d74-86e8867d378f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
592 2024.08.12 20:52:19.394241 [ 71415 ] {bf0523e4-9e2b-4b6c-97ff-39c16302c361} <Debug> executeQuery: (from [::1]:52972) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete)
593 2024.08.12 20:52:19.394305 [ 71415 ] {bf0523e4-9e2b-4b6c-97ff-39c16302c361} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64
594 2024.08.12 20:52:19.399870 [ 71415 ] {bf0523e4-9e2b-4b6c-97ff-39c16302c361} <Debug> oximeter.measurements_histogramf64 (842515bb-9f02-4009-9d08-ac2559f9f3b4): Loading data parts
595 2024.08.12 20:52:19.400166 [ 71415 ] {bf0523e4-9e2b-4b6c-97ff-39c16302c361} <Debug> oximeter.measurements_histogramf64 (842515bb-9f02-4009-9d08-ac2559f9f3b4): There are no data parts
596 2024.08.12 20:52:19.404530 [ 71415 ] {bf0523e4-9e2b-4b6c-97ff-39c16302c361} <Debug> DynamicQueryHandler: Done processing query
597 2024.08.12 20:52:19.404551 [ 71415 ] {} <Debug> HTTP-Session: e9e2df9a-4b0c-4944-9d74-86e8867d378f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
598 2024.08.12 20:52:19.405707 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 1196, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
599 2024.08.12 20:52:19.405748 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
600 2024.08.12 20:52:19.405761 [ 71415 ] {} <Debug> HTTP-Session: b54284ec-a983-4e67-aeaa-a7963cd3fce7 Authenticating user 'default' from [::1]:52972
601 2024.08.12 20:52:19.405776 [ 71415 ] {} <Debug> HTTP-Session: b54284ec-a983-4e67-aeaa-a7963cd3fce7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
602 2024.08.12 20:52:19.405791 [ 71415 ] {} <Debug> HTTP-Session: b54284ec-a983-4e67-aeaa-a7963cd3fce7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
603 2024.08.12 20:52:19.405830 [ 71415 ] {} <Trace> HTTP-Session: b54284ec-a983-4e67-aeaa-a7963cd3fce7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
604 2024.08.12 20:52:19.406052 [ 71415 ] {e5eaf9a1-2cd4-4ee1-a8a5-5257e38ba20b} <Debug> executeQuery: (from [::1]:52972) /* The field tables store named dimensions of each timeseries.
605 *
606 * As with the measurement tables, there is one field table for each field data
607 * type. Fields are deduplicated by using the "replacing merge tree", though
608 * this behavior **must not** be relied upon for query correctness.
609 *
610 * The index for the fields differs from the measurements, however. Rows are
611 * sorted by timeseries name, then field name, field value, and finally
612 * timeseries key. This reflects the most common pattern for looking them up:
613 * by field name and possibly value, within a timeseries. The resulting keys are
614 * usually then used to look up measurements.
615 *
616 * NOTE: We may want to consider a secondary index on these tables, sorting by
617 * timeseries name and then key, since it would improve lookups where one
618 * already has the key. Realistically though, these tables are quite small and
619 * so performance benefits will be low in absolute terms.
620 */
621 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)
622 2024.08.12 20:52:19.406099 [ 71415 ] {e5eaf9a1-2cd4-4ee1-a8a5-5257e38ba20b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool
623 2024.08.12 20:52:19.410544 [ 71415 ] {e5eaf9a1-2cd4-4ee1-a8a5-5257e38ba20b} <Debug> oximeter.fields_bool (35bdbc61-4aee-483f-b9d4-81f4e286ff92): Loading data parts
624 2024.08.12 20:52:19.414549 [ 71415 ] {e5eaf9a1-2cd4-4ee1-a8a5-5257e38ba20b} <Debug> oximeter.fields_bool (35bdbc61-4aee-483f-b9d4-81f4e286ff92): There are no data parts
625 2024.08.12 20:52:19.417924 [ 71415 ] {e5eaf9a1-2cd4-4ee1-a8a5-5257e38ba20b} <Debug> DynamicQueryHandler: Done processing query
626 2024.08.12 20:52:19.417946 [ 71415 ] {} <Debug> HTTP-Session: b54284ec-a983-4e67-aeaa-a7963cd3fce7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
627 2024.08.12 20:52:19.418836 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 248, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
628 2024.08.12 20:52:19.419974 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
629 2024.08.12 20:52:19.419991 [ 71415 ] {} <Debug> HTTP-Session: 56a587e3-d989-44db-93b4-569415360816 Authenticating user 'default' from [::1]:52972
630 2024.08.12 20:52:19.420006 [ 71415 ] {} <Debug> HTTP-Session: 56a587e3-d989-44db-93b4-569415360816 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
631 2024.08.12 20:52:19.420014 [ 71415 ] {} <Debug> HTTP-Session: 56a587e3-d989-44db-93b4-569415360816 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
632 2024.08.12 20:52:19.420051 [ 71415 ] {} <Trace> HTTP-Session: 56a587e3-d989-44db-93b4-569415360816 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
633 2024.08.12 20:52:19.420274 [ 71415 ] {61cfbacb-ab0c-4f8d-b157-901b514a4d62} <Debug> executeQuery: (from [::1]:52972) 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)
634 2024.08.12 20:52:19.420323 [ 71415 ] {61cfbacb-ab0c-4f8d-b157-901b514a4d62} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8
635 2024.08.12 20:52:19.424631 [ 71415 ] {61cfbacb-ab0c-4f8d-b157-901b514a4d62} <Debug> oximeter.fields_i8 (ed9b8da3-6ba6-437f-b39f-892217c1b15f): Loading data parts
636 2024.08.12 20:52:19.424900 [ 71415 ] {61cfbacb-ab0c-4f8d-b157-901b514a4d62} <Debug> oximeter.fields_i8 (ed9b8da3-6ba6-437f-b39f-892217c1b15f): There are no data parts
637 2024.08.12 20:52:19.427862 [ 71415 ] {61cfbacb-ab0c-4f8d-b157-901b514a4d62} <Debug> DynamicQueryHandler: Done processing query
638 2024.08.12 20:52:19.427881 [ 71415 ] {} <Debug> HTTP-Session: 56a587e3-d989-44db-93b4-569415360816 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
639 2024.08.12 20:52:19.428666 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 249, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
640 2024.08.12 20:52:19.430186 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
641 2024.08.12 20:52:19.430202 [ 71415 ] {} <Debug> HTTP-Session: db3df388-ed90-4055-9df4-25e95d4e239f Authenticating user 'default' from [::1]:52972
642 2024.08.12 20:52:19.430216 [ 71415 ] {} <Debug> HTTP-Session: db3df388-ed90-4055-9df4-25e95d4e239f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
643 2024.08.12 20:52:19.430223 [ 71415 ] {} <Debug> HTTP-Session: db3df388-ed90-4055-9df4-25e95d4e239f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
644 2024.08.12 20:52:19.430257 [ 71415 ] {} <Trace> HTTP-Session: db3df388-ed90-4055-9df4-25e95d4e239f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
645 2024.08.12 20:52:19.430541 [ 71415 ] {3bef0ddd-358d-48cf-bc4c-9f3bb5a98342} <Debug> executeQuery: (from [::1]:52972) 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)
646 2024.08.12 20:52:19.430579 [ 71415 ] {3bef0ddd-358d-48cf-bc4c-9f3bb5a98342} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8
647 2024.08.12 20:52:19.434535 [ 71415 ] {3bef0ddd-358d-48cf-bc4c-9f3bb5a98342} <Debug> oximeter.fields_u8 (8ece25f8-e378-4570-8686-c9440d757ff7): Loading data parts
648 2024.08.12 20:52:19.434724 [ 71415 ] {3bef0ddd-358d-48cf-bc4c-9f3bb5a98342} <Debug> oximeter.fields_u8 (8ece25f8-e378-4570-8686-c9440d757ff7): There are no data parts
649 2024.08.12 20:52:19.437925 [ 71415 ] {3bef0ddd-358d-48cf-bc4c-9f3bb5a98342} <Debug> DynamicQueryHandler: Done processing query
650 2024.08.12 20:52:19.437943 [ 71415 ] {} <Debug> HTTP-Session: db3df388-ed90-4055-9df4-25e95d4e239f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
651 2024.08.12 20:52:19.443435 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
652 2024.08.12 20:52:19.443472 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
653 2024.08.12 20:52:19.443483 [ 71415 ] {} <Debug> HTTP-Session: 11fbb0c4-e6ad-4349-b4f7-7f62f0928516 Authenticating user 'default' from [::1]:52972
654 2024.08.12 20:52:19.443494 [ 71415 ] {} <Debug> HTTP-Session: 11fbb0c4-e6ad-4349-b4f7-7f62f0928516 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
655 2024.08.12 20:52:19.443500 [ 71415 ] {} <Debug> HTTP-Session: 11fbb0c4-e6ad-4349-b4f7-7f62f0928516 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
656 2024.08.12 20:52:19.443528 [ 71415 ] {} <Trace> HTTP-Session: 11fbb0c4-e6ad-4349-b4f7-7f62f0928516 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
657 2024.08.12 20:52:19.443748 [ 71415 ] {dffd4341-ff4f-4692-a962-82237c20a2ae} <Debug> executeQuery: (from [::1]:52972) 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)
658 2024.08.12 20:52:19.443785 [ 71415 ] {dffd4341-ff4f-4692-a962-82237c20a2ae} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16
659 2024.08.12 20:52:19.448773 [ 71415 ] {dffd4341-ff4f-4692-a962-82237c20a2ae} <Debug> oximeter.fields_i16 (65ceae1c-7b61-4683-9ec4-324bc5241ac4): Loading data parts
660 2024.08.12 20:52:19.448996 [ 71415 ] {dffd4341-ff4f-4692-a962-82237c20a2ae} <Debug> oximeter.fields_i16 (65ceae1c-7b61-4683-9ec4-324bc5241ac4): There are no data parts
661 2024.08.12 20:52:19.453337 [ 71415 ] {dffd4341-ff4f-4692-a962-82237c20a2ae} <Debug> DynamicQueryHandler: Done processing query
662 2024.08.12 20:52:19.453355 [ 71415 ] {} <Debug> HTTP-Session: 11fbb0c4-e6ad-4349-b4f7-7f62f0928516 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
663 2024.08.12 20:52:19.454282 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
664 2024.08.12 20:52:19.455846 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
665 2024.08.12 20:52:19.455882 [ 71415 ] {} <Debug> HTTP-Session: f12e0ce8-6150-4d5e-b57a-73a91c0568b5 Authenticating user 'default' from [::1]:52972
666 2024.08.12 20:52:19.455896 [ 71415 ] {} <Debug> HTTP-Session: f12e0ce8-6150-4d5e-b57a-73a91c0568b5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
667 2024.08.12 20:52:19.455902 [ 71415 ] {} <Debug> HTTP-Session: f12e0ce8-6150-4d5e-b57a-73a91c0568b5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
668 2024.08.12 20:52:19.455938 [ 71415 ] {} <Trace> HTTP-Session: f12e0ce8-6150-4d5e-b57a-73a91c0568b5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
669 2024.08.12 20:52:19.456123 [ 71415 ] {1a020b69-7a6d-4a99-ad3e-bc885917e33a} <Debug> executeQuery: (from [::1]:52972) 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)
670 2024.08.12 20:52:19.456159 [ 71415 ] {1a020b69-7a6d-4a99-ad3e-bc885917e33a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16
671 2024.08.12 20:52:19.459805 [ 71415 ] {1a020b69-7a6d-4a99-ad3e-bc885917e33a} <Debug> oximeter.fields_u16 (7dfbe533-9453-4b9c-a108-1e379b3aa428): Loading data parts
672 2024.08.12 20:52:19.460030 [ 71415 ] {1a020b69-7a6d-4a99-ad3e-bc885917e33a} <Debug> oximeter.fields_u16 (7dfbe533-9453-4b9c-a108-1e379b3aa428): There are no data parts
673 2024.08.12 20:52:19.463976 [ 71415 ] {1a020b69-7a6d-4a99-ad3e-bc885917e33a} <Debug> DynamicQueryHandler: Done processing query
674 2024.08.12 20:52:19.463994 [ 71415 ] {} <Debug> HTTP-Session: f12e0ce8-6150-4d5e-b57a-73a91c0568b5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
675 2024.08.12 20:52:19.464869 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
676 2024.08.12 20:52:19.466001 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
677 2024.08.12 20:52:19.466016 [ 71415 ] {} <Debug> HTTP-Session: b78690a6-c90c-47f9-8c87-ac9e0f84d1b8 Authenticating user 'default' from [::1]:52972
678 2024.08.12 20:52:19.466027 [ 71415 ] {} <Debug> HTTP-Session: b78690a6-c90c-47f9-8c87-ac9e0f84d1b8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
679 2024.08.12 20:52:19.466039 [ 71415 ] {} <Debug> HTTP-Session: b78690a6-c90c-47f9-8c87-ac9e0f84d1b8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
680 2024.08.12 20:52:19.466067 [ 71415 ] {} <Trace> HTTP-Session: b78690a6-c90c-47f9-8c87-ac9e0f84d1b8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
681 2024.08.12 20:52:19.466264 [ 71415 ] {6f6111a9-6a14-4bc1-921c-532e181895af} <Debug> executeQuery: (from [::1]:52972) 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)
682 2024.08.12 20:52:19.466299 [ 71415 ] {6f6111a9-6a14-4bc1-921c-532e181895af} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32
683 2024.08.12 20:52:19.471729 [ 71415 ] {6f6111a9-6a14-4bc1-921c-532e181895af} <Debug> oximeter.fields_i32 (2aa0fc38-0ce8-471b-ac20-2230f6830749): Loading data parts
684 2024.08.12 20:52:19.471984 [ 71415 ] {6f6111a9-6a14-4bc1-921c-532e181895af} <Debug> oximeter.fields_i32 (2aa0fc38-0ce8-471b-ac20-2230f6830749): There are no data parts
685 2024.08.12 20:52:19.477130 [ 71415 ] {6f6111a9-6a14-4bc1-921c-532e181895af} <Debug> DynamicQueryHandler: Done processing query
686 2024.08.12 20:52:19.477150 [ 71415 ] {} <Debug> HTTP-Session: b78690a6-c90c-47f9-8c87-ac9e0f84d1b8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
687 2024.08.12 20:52:19.478040 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
688 2024.08.12 20:52:19.478079 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
689 2024.08.12 20:52:19.478090 [ 71415 ] {} <Debug> HTTP-Session: 455ac55f-05b6-48bc-b9f8-567175cf72a6 Authenticating user 'default' from [::1]:52972
690 2024.08.12 20:52:19.478101 [ 71415 ] {} <Debug> HTTP-Session: 455ac55f-05b6-48bc-b9f8-567175cf72a6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
691 2024.08.12 20:52:19.478108 [ 71415 ] {} <Debug> HTTP-Session: 455ac55f-05b6-48bc-b9f8-567175cf72a6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
692 2024.08.12 20:52:19.478138 [ 71415 ] {} <Trace> HTTP-Session: 455ac55f-05b6-48bc-b9f8-567175cf72a6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
693 2024.08.12 20:52:19.478404 [ 71415 ] {eeb1b489-f219-49fd-84ad-4abe8d4974de} <Debug> executeQuery: (from [::1]:52972) 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)
694 2024.08.12 20:52:19.483860 [ 71415 ] {eeb1b489-f219-49fd-84ad-4abe8d4974de} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32
695 2024.08.12 20:52:19.489204 [ 71415 ] {eeb1b489-f219-49fd-84ad-4abe8d4974de} <Debug> oximeter.fields_u32 (05ce29bb-753c-4851-8cd3-fe43035c585b): Loading data parts
696 2024.08.12 20:52:19.489606 [ 71415 ] {eeb1b489-f219-49fd-84ad-4abe8d4974de} <Debug> oximeter.fields_u32 (05ce29bb-753c-4851-8cd3-fe43035c585b): There are no data parts
697 2024.08.12 20:52:19.497436 [ 71415 ] {eeb1b489-f219-49fd-84ad-4abe8d4974de} <Debug> DynamicQueryHandler: Done processing query
698 2024.08.12 20:52:19.497459 [ 71415 ] {} <Debug> HTTP-Session: 455ac55f-05b6-48bc-b9f8-567175cf72a6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
699 2024.08.12 20:52:19.500605 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
700 2024.08.12 20:52:19.500694 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
701 2024.08.12 20:52:19.500707 [ 71415 ] {} <Debug> HTTP-Session: 716acac7-7a57-4ac2-a985-9de2440ef419 Authenticating user 'default' from [::1]:52972
702 2024.08.12 20:52:19.500721 [ 71415 ] {} <Debug> HTTP-Session: 716acac7-7a57-4ac2-a985-9de2440ef419 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
703 2024.08.12 20:52:19.500727 [ 71415 ] {} <Debug> HTTP-Session: 716acac7-7a57-4ac2-a985-9de2440ef419 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
704 2024.08.12 20:52:19.500762 [ 71415 ] {} <Trace> HTTP-Session: 716acac7-7a57-4ac2-a985-9de2440ef419 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
705 2024.08.12 20:52:19.501021 [ 71415 ] {849e1396-a1da-4efa-a5b4-42e4772fe8a2} <Debug> executeQuery: (from [::1]:52972) 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)
706 2024.08.12 20:52:19.501062 [ 71415 ] {849e1396-a1da-4efa-a5b4-42e4772fe8a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64
707 2024.08.12 20:52:19.506646 [ 71415 ] {849e1396-a1da-4efa-a5b4-42e4772fe8a2} <Debug> oximeter.fields_i64 (dd5cb5aa-29af-4f4c-ba79-2dea40913a6a): Loading data parts
708 2024.08.12 20:52:19.506924 [ 71415 ] {849e1396-a1da-4efa-a5b4-42e4772fe8a2} <Debug> oximeter.fields_i64 (dd5cb5aa-29af-4f4c-ba79-2dea40913a6a): There are no data parts
709 2024.08.12 20:52:19.515685 [ 71415 ] {849e1396-a1da-4efa-a5b4-42e4772fe8a2} <Debug> DynamicQueryHandler: Done processing query
710 2024.08.12 20:52:19.515726 [ 71415 ] {} <Debug> HTTP-Session: 716acac7-7a57-4ac2-a985-9de2440ef419 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
711 2024.08.12 20:52:19.519325 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 251, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
712 2024.08.12 20:52:19.521235 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
713 2024.08.12 20:52:19.521294 [ 71415 ] {} <Debug> HTTP-Session: 4d280621-51af-49ae-9ae0-6c8b5ce0c21a Authenticating user 'default' from [::1]:52972
714 2024.08.12 20:52:19.521350 [ 71415 ] {} <Debug> HTTP-Session: 4d280621-51af-49ae-9ae0-6c8b5ce0c21a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
715 2024.08.12 20:52:19.521375 [ 71415 ] {} <Debug> HTTP-Session: 4d280621-51af-49ae-9ae0-6c8b5ce0c21a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
716 2024.08.12 20:52:19.521467 [ 71415 ] {} <Trace> HTTP-Session: 4d280621-51af-49ae-9ae0-6c8b5ce0c21a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
717 2024.08.12 20:52:19.522061 [ 71415 ] {b8554e85-7034-4aee-9557-31237f55b583} <Debug> executeQuery: (from [::1]:52972) 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)
718 2024.08.12 20:52:19.523416 [ 71415 ] {b8554e85-7034-4aee-9557-31237f55b583} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64
719 2024.08.12 20:52:19.527885 [ 71415 ] {b8554e85-7034-4aee-9557-31237f55b583} <Debug> oximeter.fields_u64 (2f1666f3-6c18-4f3f-8583-c0d16cdc64a4): Loading data parts
720 2024.08.12 20:52:19.528209 [ 71415 ] {b8554e85-7034-4aee-9557-31237f55b583} <Debug> oximeter.fields_u64 (2f1666f3-6c18-4f3f-8583-c0d16cdc64a4): There are no data parts
721 2024.08.12 20:52:19.537501 [ 71415 ] {b8554e85-7034-4aee-9557-31237f55b583} <Debug> DynamicQueryHandler: Done processing query
722 2024.08.12 20:52:19.537535 [ 71415 ] {} <Debug> HTTP-Session: 4d280621-51af-49ae-9ae0-6c8b5ce0c21a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
723 2024.08.12 20:52:19.538546 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 252, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
724 2024.08.12 20:52:19.538587 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
725 2024.08.12 20:52:19.538600 [ 71415 ] {} <Debug> HTTP-Session: 50f27150-c103-4ed1-8f97-723bbe188510 Authenticating user 'default' from [::1]:52972
726 2024.08.12 20:52:19.538614 [ 71415 ] {} <Debug> HTTP-Session: 50f27150-c103-4ed1-8f97-723bbe188510 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
727 2024.08.12 20:52:19.538620 [ 71415 ] {} <Debug> HTTP-Session: 50f27150-c103-4ed1-8f97-723bbe188510 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
728 2024.08.12 20:52:19.538678 [ 71415 ] {} <Trace> HTTP-Session: 50f27150-c103-4ed1-8f97-723bbe188510 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
729 2024.08.12 20:52:19.539074 [ 71415 ] {4b2ba41d-2001-4a55-9290-64bea84f50bd} <Debug> executeQuery: (from [::1]:52972) 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)
730 2024.08.12 20:52:19.544951 [ 71415 ] {4b2ba41d-2001-4a55-9290-64bea84f50bd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr
731 2024.08.12 20:52:19.551657 [ 71415 ] {4b2ba41d-2001-4a55-9290-64bea84f50bd} <Debug> oximeter.fields_ipaddr (cfda5fc0-9d7c-43ff-8fe5-cda0d648cb4f): Loading data parts
732 2024.08.12 20:52:19.551951 [ 71415 ] {4b2ba41d-2001-4a55-9290-64bea84f50bd} <Debug> oximeter.fields_ipaddr (cfda5fc0-9d7c-43ff-8fe5-cda0d648cb4f): There are no data parts
733 2024.08.12 20:52:19.559602 [ 71415 ] {4b2ba41d-2001-4a55-9290-64bea84f50bd} <Debug> DynamicQueryHandler: Done processing query
734 2024.08.12 20:52:19.559632 [ 71415 ] {} <Debug> HTTP-Session: 50f27150-c103-4ed1-8f97-723bbe188510 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
735 2024.08.12 20:52:19.560472 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 254, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
736 2024.08.12 20:52:19.560509 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
737 2024.08.12 20:52:19.560521 [ 71415 ] {} <Debug> HTTP-Session: 630553f4-ea39-493d-9a7e-dfff6ed397c7 Authenticating user 'default' from [::1]:52972
738 2024.08.12 20:52:19.560533 [ 71415 ] {} <Debug> HTTP-Session: 630553f4-ea39-493d-9a7e-dfff6ed397c7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
739 2024.08.12 20:52:19.560539 [ 71415 ] {} <Debug> HTTP-Session: 630553f4-ea39-493d-9a7e-dfff6ed397c7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
740 2024.08.12 20:52:19.560574 [ 71415 ] {} <Trace> HTTP-Session: 630553f4-ea39-493d-9a7e-dfff6ed397c7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
741 2024.08.12 20:52:19.560762 [ 71415 ] {be739114-a78c-4735-bdd3-08ccfae4b35f} <Debug> executeQuery: (from [::1]:52972) 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)
742 2024.08.12 20:52:19.560801 [ 71415 ] {be739114-a78c-4735-bdd3-08ccfae4b35f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string
743 2024.08.12 20:52:19.565551 [ 71415 ] {be739114-a78c-4735-bdd3-08ccfae4b35f} <Debug> oximeter.fields_string (1ba9d5a8-f74a-4811-8ce8-9600344cff13): Loading data parts
744 2024.08.12 20:52:19.567951 [ 71415 ] {be739114-a78c-4735-bdd3-08ccfae4b35f} <Debug> oximeter.fields_string (1ba9d5a8-f74a-4811-8ce8-9600344cff13): There are no data parts
745 2024.08.12 20:52:19.583218 [ 71415 ] {be739114-a78c-4735-bdd3-08ccfae4b35f} <Debug> DynamicQueryHandler: Done processing query
746 2024.08.12 20:52:19.583246 [ 71415 ] {} <Debug> HTTP-Session: 630553f4-ea39-493d-9a7e-dfff6ed397c7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
747 2024.08.12 20:52:19.584005 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 250, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
748 2024.08.12 20:52:19.585404 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
749 2024.08.12 20:52:19.585419 [ 71415 ] {} <Debug> HTTP-Session: 02b0b960-8994-44d7-973d-f43c3c2e6688 Authenticating user 'default' from [::1]:52972
750 2024.08.12 20:52:19.585431 [ 71415 ] {} <Debug> HTTP-Session: 02b0b960-8994-44d7-973d-f43c3c2e6688 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
751 2024.08.12 20:52:19.585438 [ 71415 ] {} <Debug> HTTP-Session: 02b0b960-8994-44d7-973d-f43c3c2e6688 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
752 2024.08.12 20:52:19.585470 [ 71415 ] {} <Trace> HTTP-Session: 02b0b960-8994-44d7-973d-f43c3c2e6688 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
753 2024.08.12 20:52:19.585648 [ 71415 ] {0fed0276-4aa6-41e5-b78b-fbd0c0a07b5a} <Debug> executeQuery: (from [::1]:52972) 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)
754 2024.08.12 20:52:19.585685 [ 71415 ] {0fed0276-4aa6-41e5-b78b-fbd0c0a07b5a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid
755 2024.08.12 20:52:19.597584 [ 71415 ] {0fed0276-4aa6-41e5-b78b-fbd0c0a07b5a} <Debug> oximeter.fields_uuid (9fdc6278-a2fe-4c4a-b0f2-bd6e6531a1d3): Loading data parts
756 2024.08.12 20:52:19.599907 [ 71415 ] {0fed0276-4aa6-41e5-b78b-fbd0c0a07b5a} <Debug> oximeter.fields_uuid (9fdc6278-a2fe-4c4a-b0f2-bd6e6531a1d3): There are no data parts
757 2024.08.12 20:52:19.613335 [ 71415 ] {0fed0276-4aa6-41e5-b78b-fbd0c0a07b5a} <Debug> DynamicQueryHandler: Done processing query
758 2024.08.12 20:52:19.613377 [ 71415 ] {} <Debug> HTTP-Session: 02b0b960-8994-44d7-973d-f43c3c2e6688 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
759 2024.08.12 20:52:19.614731 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
760 2024.08.12 20:52:19.618308 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
761 2024.08.12 20:52:19.618324 [ 71415 ] {} <Debug> HTTP-Session: 9c7b4412-535b-4753-90e0-e8f9bf56185f Authenticating user 'default' from [::1]:52972
762 2024.08.12 20:52:19.618338 [ 71415 ] {} <Debug> HTTP-Session: 9c7b4412-535b-4753-90e0-e8f9bf56185f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
763 2024.08.12 20:52:19.618345 [ 71415 ] {} <Debug> HTTP-Session: 9c7b4412-535b-4753-90e0-e8f9bf56185f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
764 2024.08.12 20:52:19.618407 [ 71415 ] {} <Trace> HTTP-Session: 9c7b4412-535b-4753-90e0-e8f9bf56185f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
765 2024.08.12 20:52:19.618768 [ 71415 ] {6f34be0e-238c-4e9b-9d7a-46d308e41431} <Debug> executeQuery: (from [::1]:52972) /* The timeseries schema table stores the extracted schema for the samples
766 * oximeter collects.
767 */
768 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)
769 2024.08.12 20:52:19.618838 [ 71415 ] {6f34be0e-238c-4e9b-9d7a-46d308e41431} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema
770 2024.08.12 20:52:19.625529 [ 71415 ] {6f34be0e-238c-4e9b-9d7a-46d308e41431} <Debug> oximeter.timeseries_schema (42023e0c-68a5-44c1-833a-9f97494b73f2): Loading data parts
771 2024.08.12 20:52:19.625782 [ 71415 ] {6f34be0e-238c-4e9b-9d7a-46d308e41431} <Debug> oximeter.timeseries_schema (42023e0c-68a5-44c1-833a-9f97494b73f2): There are no data parts
772 2024.08.12 20:52:19.632420 [ 71415 ] {6f34be0e-238c-4e9b-9d7a-46d308e41431} <Debug> DynamicQueryHandler: Done processing query
773 2024.08.12 20:52:19.632442 [ 71415 ] {} <Debug> HTTP-Session: 9c7b4412-535b-4753-90e0-e8f9bf56185f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
774 2024.08.12 20:52:19.633845 [ 71415 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [::1]:52972, User-Agent: (none), Length: 51, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none)
775 2024.08.12 20:52:19.633884 [ 71415 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1
776 2024.08.12 20:52:19.633896 [ 71415 ] {} <Debug> HTTP-Session: f357c14a-dfe5-4ffd-8dfa-1b6521c0275d Authenticating user 'default' from [::1]:52972
777 2024.08.12 20:52:19.633910 [ 71415 ] {} <Debug> HTTP-Session: f357c14a-dfe5-4ffd-8dfa-1b6521c0275d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db
778 2024.08.12 20:52:19.633917 [ 71415 ] {} <Debug> HTTP-Session: f357c14a-dfe5-4ffd-8dfa-1b6521c0275d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db
779 2024.08.12 20:52:19.633955 [ 71415 ] {} <Trace> HTTP-Session: f357c14a-dfe5-4ffd-8dfa-1b6521c0275d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default
780 2024.08.12 20:52:19.634115 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Debug> executeQuery: (from [::1]:52972) INSERT INTO oximeter.version (*) VALUES (stage: Complete)
781 2024.08.12 20:52:19.634199 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version
782 2024.08.12 20:52:19.634926 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Trace> oximeter.version (28f2f4d8-d9e8-45d4-966c-065c1a2bd74f): Trying to reserve 1.00 MiB using storage policy from min volume index 0
783 2024.08.12 20:52:19.634953 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 168.00 GiB.
784 2024.08.12 20:52:19.635258 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary)
785 2024.08.12 20:52:19.635424 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Trace> oximeter.version (28f2f4d8-d9e8-45d4-966c-065c1a2bd74f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000).
786 2024.08.12 20:52:19.635558 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.001497 sec., 668.002672010688 rows/sec., 10.44 KiB/sec.
787 2024.08.12 20:52:19.635684 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Debug> DynamicQueryHandler: Done processing query
788 2024.08.12 20:52:19.635699 [ 71415 ] {fa99586d-dda9-43a5-b17a-dd7d60d887fd} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB.
789 2024.08.12 20:52:19.635707 [ 71415 ] {} <Debug> HTTP-Session: f357c14a-dfe5-4ffd-8dfa-1b6521c0275d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db
790 2024.08.12 20:52:20.000558 [ 71658 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 388.35 MiB, peak 393.52 MiB, free memory in arenas 57.63 MiB, will set to 390.04 MiB (RSS), difference: 1.69 MiB