| 1 | [ Oct 21 22:14:48 Enabled. ] | ||
| 2 | [ Oct 21 22:14:48 Rereading configuration. ] | ||
| 3 | [ Oct 21 22:14:50 Rereading configuration. ] | ||
| 4 | [ Oct 21 22:14:51 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ] | ||
| 5 | + set -o errexit | ||
| 6 | + set -o pipefail | ||
| 7 | + . /lib/svc/share/smf_include.sh | ||
| 8 | ++ SMF_EXIT_OK=0 | ||
| 9 | ++ SMF_EXIT_NODAEMON=94 | ||
| 10 | ++ SMF_EXIT_ERR_FATAL=95 | ||
| 11 | ++ SMF_EXIT_ERR_CONFIG=96 | ||
| 12 | ++ SMF_EXIT_MON_DEGRADE=97 | ||
| 13 | ++ SMF_EXIT_MON_OFFLINE=98 | ||
| 14 | ++ SMF_EXIT_ERR_NOSMF=99 | ||
| 15 | ++ SMF_EXIT_ERR_PERM=100 | ||
| 16 | ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default | ||
| 17 | + LISTEN_ADDR=fd00:1122:3344:101::e | ||
| 18 | ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default | ||
| 19 | + LISTEN_PORT=8123 | ||
| 20 | ++ svcprop -c -p config/store svc:/oxide/clickhouse:default | ||
| 21 | + DATASTORE=/data | ||
| 22 | + args=("--config-file" "/opt/oxide/clickhouse/config.xml" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
| 23 | + exec /opt/oxide/clickhouse/clickhouse server --config-file /opt/oxide/clickhouse/config.xml -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123 | ||
| 24 | [ Oct 21 22:14:52 Method "start" exited with status 0. ] | ||
| 25 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 26 | Logging trace to /var/tmp/clickhouse-server.log | ||
| 27 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
| 28 | 2024.10.21 22:14:53.309546 [ 1 ] {} <Information> Application: Will watch for the process with pid 22221 | ||
| 29 | 2024.10.21 22:14:53.310184 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 30 | 2024.10.21 22:14:53.677359 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 22221 | ||
| 31 | 2024.10.21 22:14:53.678517 [ 1 ] {} <Information> Application: starting up | ||
| 32 | 2024.10.21 22:14:53.679615 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 33 | 2024.10.21 22:14:53.810945 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
| 34 | 2024.10.21 22:14:53.855068 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 35 | 2024.10.21 22:14:53.855125 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 36 | 2024.10.21 22:14:53.855142 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 37 | 2024.10.21 22:14:53.855212 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
| 38 | 2024.10.21 22:14:53.855655 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 39 | 2024.10.21 22:14:53.857521 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
| 40 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 41 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 42 | 2024.10.21 22:14:53.858156 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 43 | 2024.10.21 22:14:53.859115 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 44 | 2024.10.21 22:14:53.859144 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 45 | 2024.10.21 22:14:53.859162 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
| 46 | 2024.10.21 22:14:53.859359 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 47 | 2024.10.21 22:14:53.860371 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 48 | 2024.10.21 22:14:53.867150 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 49 | 2024.10.21 22:14:53.867996 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 50 | 2024.10.21 22:14:53.869530 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 51 | 2024.10.21 22:14:53.869600 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 52 | 2024.10.21 22:14:53.871400 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
| 53 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 54 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 55 | 2024.10.21 22:14:53.871750 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 56 | 2024.10.21 22:14:53.877066 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 57 | 2024.10.21 22:14:53.877855 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml | ||
| 58 | 2024.10.21 22:14:53.879670 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 59 | 2024.10.21 22:14:53.880185 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 60 | 2024.10.21 22:14:53.880681 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 61 | 2024.10.21 22:14:53.881128 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 62 | 2024.10.21 22:14:53.882799 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 63 | 2024.10.21 22:14:53.882830 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 64 | 2024.10.21 22:14:53.882922 [ 152 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 65 | 2024.10.21 22:14:53.883121 [ 152 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 66 | 2024.10.21 22:14:53.899893 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 67 | 2024.10.21 22:14:53.899922 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000166765 sec | ||
| 68 | 2024.10.21 22:14:53.899977 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 69 | 2024.10.21 22:14:53.900001 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 70 | 2024.10.21 22:14:53.901839 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 71 | 2024.10.21 22:14:53.903149 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 72 | 2024.10.21 22:14:53.922136 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 73 | 2024.10.21 22:14:53.922199 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 74 | 2024.10.21 22:14:53.922239 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 75 | 2024.10.21 22:14:53.922260 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 76 | 2024.10.21 22:14:53.922306 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 77 | 2024.10.21 22:14:53.922334 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 78 | 2024.10.21 22:14:53.922354 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 79 | 2024.10.21 22:14:53.922406 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 80 | 2024.10.21 22:14:53.922435 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 81 | 2024.10.21 22:14:53.922455 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 82 | 2024.10.21 22:14:53.922471 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 83 | 2024.10.21 22:14:53.922540 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 84 | 2024.10.21 22:14:53.922560 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 85 | 2024.10.21 22:14:53.922579 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 86 | 2024.10.21 22:14:53.922636 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 87 | 2024.10.21 22:14:53.922655 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 88 | 2024.10.21 22:14:53.962682 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 89 | 2024.10.21 22:14:53.970707 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 90 | 2024.10.21 22:14:53.970759 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 8.0032e-05 sec | ||
| 91 | 2024.10.21 22:14:53.970781 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 92 | 2024.10.21 22:14:53.970797 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 93 | 2024.10.21 22:14:53.970830 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 94 | 2024.10.21 22:14:53.971139 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
| 95 | 2024.10.21 22:14:53.971207 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 96 | 2024.10.21 22:14:53.971229 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 97 | 2024.10.21 22:14:53.971250 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
| 98 | 2024.10.21 22:14:53.971285 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 99 | 2024.10.21 22:14:53.977216 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 100 | 2024.10.21 22:14:53.977452 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.71 MiB, peak 24.71 MiB, free memory in arenas 0.00 B, will set to 116.71 MiB (RSS), difference: 92.00 MiB | ||
| 101 | 2024.10.21 22:14:53.978565 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.765e-05 sec. | ||
| 102 | 2024.10.21 22:14:53.978965 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 103 | 2024.10.21 22:14:53.979069 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 104 | 2024.10.21 22:14:53.979095 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 105 | 2024.10.21 22:14:54.033876 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:48845 | ||
| 106 | 2024.10.21 22:14:54.034130 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2024.10.21 22:14:54.034186 [ 3 ] {} <Debug> TCP-Session: aea4981c-fb2f-4279-91f7-69e7633f0c50 Authenticating user 'default' from [fd00:1122:3344:101::d]:48845 | ||
| 108 | 2024.10.21 22:14:54.034220 [ 3 ] {} <Debug> TCP-Session: aea4981c-fb2f-4279-91f7-69e7633f0c50 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2024.10.21 22:14:54.034260 [ 3 ] {} <Debug> TCP-Session: aea4981c-fb2f-4279-91f7-69e7633f0c50 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2024.10.21 22:14:54.034341 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 111 | 2024.10.21 22:14:54.034372 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 112 | 2024.10.21 22:14:54.034402 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 113 | 2024.10.21 22:14:54.280737 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:39659 | ||
| 114 | 2024.10.21 22:14:54.280866 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 115 | 2024.10.21 22:14:54.280897 [ 4 ] {} <Debug> TCP-Session: 64793263-92e8-4a5a-bc6c-bea293f277f3 Authenticating user 'default' from [fd00:1122:3344:101::d]:39659 | ||
| 116 | 2024.10.21 22:14:54.280936 [ 4 ] {} <Debug> TCP-Session: 64793263-92e8-4a5a-bc6c-bea293f277f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 117 | 2024.10.21 22:14:54.280952 [ 4 ] {} <Debug> TCP-Session: 64793263-92e8-4a5a-bc6c-bea293f277f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 118 | 2024.10.21 22:14:54.606328 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:40538 | ||
| 119 | 2024.10.21 22:14:54.606459 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 120 | 2024.10.21 22:14:54.606491 [ 5 ] {} <Debug> TCP-Session: ff6a61ef-5512-46af-93ce-deba7628e894 Authenticating user 'default' from [fd00:1122:3344:101::d]:40538 | ||
| 121 | 2024.10.21 22:14:54.606515 [ 5 ] {} <Debug> TCP-Session: ff6a61ef-5512-46af-93ce-deba7628e894 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 122 | 2024.10.21 22:14:54.606529 [ 5 ] {} <Debug> TCP-Session: ff6a61ef-5512-46af-93ce-deba7628e894 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 123 | 2024.10.21 22:14:54.606832 [ 250 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:37157 | ||
| 124 | 2024.10.21 22:14:54.606907 [ 251 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:56968 | ||
| 125 | 2024.10.21 22:14:54.606980 [ 250 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 126 | 2024.10.21 22:14:54.607098 [ 250 ] {} <Debug> TCP-Session: e678c464-7944-4454-8345-1d4a9955625d Authenticating user 'default' from [fd00:1122:3344:101::d]:37157 | ||
| 127 | 2024.10.21 22:14:54.607107 [ 251 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 128 | 2024.10.21 22:14:54.607108 [ 252 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:52773 | ||
| 129 | 2024.10.21 22:14:54.607145 [ 251 ] {} <Debug> TCP-Session: 888cba33-4e47-4923-983b-4ca1ec3646da Authenticating user 'default' from [fd00:1122:3344:101::d]:56968 | ||
| 130 | 2024.10.21 22:14:54.607132 [ 250 ] {} <Debug> TCP-Session: e678c464-7944-4454-8345-1d4a9955625d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 131 | 2024.10.21 22:14:54.607194 [ 251 ] {} <Debug> TCP-Session: 888cba33-4e47-4923-983b-4ca1ec3646da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 132 | 2024.10.21 22:14:54.607199 [ 250 ] {} <Debug> TCP-Session: e678c464-7944-4454-8345-1d4a9955625d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 133 | 2024.10.21 22:14:54.607225 [ 251 ] {} <Debug> TCP-Session: 888cba33-4e47-4923-983b-4ca1ec3646da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 134 | 2024.10.21 22:14:54.607342 [ 252 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 135 | 2024.10.21 22:14:54.607391 [ 252 ] {} <Debug> TCP-Session: 8909a501-7ea3-41ee-9344-4957c8d2513e Authenticating user 'default' from [fd00:1122:3344:101::d]:52773 | ||
| 136 | 2024.10.21 22:14:54.607432 [ 252 ] {} <Debug> TCP-Session: 8909a501-7ea3-41ee-9344-4957c8d2513e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 137 | 2024.10.21 22:14:54.607449 [ 252 ] {} <Debug> TCP-Session: 8909a501-7ea3-41ee-9344-4957c8d2513e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 138 | 2024.10.21 22:14:54.607882 [ 253 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:45849 | ||
| 139 | 2024.10.21 22:14:54.607956 [ 254 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:39769 | ||
| 140 | 2024.10.21 22:14:54.608161 [ 253 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 141 | 2024.10.21 22:14:54.608197 [ 254 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 142 | 2024.10.21 22:14:54.608233 [ 253 ] {} <Debug> TCP-Session: 6f17d362-2fa2-4aa9-986a-865e96bfcba1 Authenticating user 'default' from [fd00:1122:3344:101::d]:45849 | ||
| 143 | 2024.10.21 22:14:54.608244 [ 254 ] {} <Debug> TCP-Session: f9b33e3b-b816-4b91-b0d9-e4e6b9aaa7ba Authenticating user 'default' from [fd00:1122:3344:101::d]:39769 | ||
| 144 | 2024.10.21 22:14:54.608289 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:58837 | ||
| 145 | 2024.10.21 22:14:54.608317 [ 253 ] {} <Debug> TCP-Session: 6f17d362-2fa2-4aa9-986a-865e96bfcba1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 146 | 2024.10.21 22:14:54.608322 [ 254 ] {} <Debug> TCP-Session: f9b33e3b-b816-4b91-b0d9-e4e6b9aaa7ba Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2024.10.21 22:14:54.608292 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:35556 | ||
| 148 | 2024.10.21 22:14:54.608384 [ 254 ] {} <Debug> TCP-Session: f9b33e3b-b816-4b91-b0d9-e4e6b9aaa7ba Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 149 | 2024.10.21 22:14:54.608376 [ 253 ] {} <Debug> TCP-Session: 6f17d362-2fa2-4aa9-986a-865e96bfcba1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 150 | 2024.10.21 22:14:54.608566 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 151 | 2024.10.21 22:14:54.608596 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 152 | 2024.10.21 22:14:54.608655 [ 256 ] {} <Debug> TCP-Session: ab40339b-03a4-4425-8997-7ef614affa90 Authenticating user 'default' from [fd00:1122:3344:101::d]:58837 | ||
| 153 | 2024.10.21 22:14:54.608676 [ 255 ] {} <Debug> TCP-Session: 63e66206-51ce-4f1a-957f-66533a120d90 Authenticating user 'default' from [fd00:1122:3344:101::d]:35556 | ||
| 154 | 2024.10.21 22:14:54.608713 [ 256 ] {} <Debug> TCP-Session: ab40339b-03a4-4425-8997-7ef614affa90 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 155 | 2024.10.21 22:14:54.608728 [ 255 ] {} <Debug> TCP-Session: 63e66206-51ce-4f1a-957f-66533a120d90 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 156 | 2024.10.21 22:14:54.608743 [ 256 ] {} <Debug> TCP-Session: ab40339b-03a4-4425-8997-7ef614affa90 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 157 | 2024.10.21 22:14:54.608793 [ 255 ] {} <Debug> TCP-Session: 63e66206-51ce-4f1a-957f-66533a120d90 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 158 | 2024.10.21 22:14:54.641032 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59635, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 159 | 2024.10.21 22:14:54.641224 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 160 | 2024.10.21 22:14:54.641253 [ 257 ] {} <Debug> HTTP-Session: fabcfab0-db18-4b17-97c5-a241731784fc Authenticating user 'default' from [fd00:1122:3344:101::d]:59635 | ||
| 161 | 2024.10.21 22:14:54.641271 [ 257 ] {} <Debug> HTTP-Session: fabcfab0-db18-4b17-97c5-a241731784fc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 162 | 2024.10.21 22:14:54.641297 [ 257 ] {} <Debug> HTTP-Session: fabcfab0-db18-4b17-97c5-a241731784fc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 163 | 2024.10.21 22:14:54.641340 [ 257 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 164 | 2024.10.21 22:14:54.641373 [ 257 ] {} <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 | ||
| 165 | 2024.10.21 22:14:54.641401 [ 257 ] {} <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 | ||
| 166 | 2024.10.21 22:14:54.641444 [ 257 ] {} <Trace> HTTP-Session: fabcfab0-db18-4b17-97c5-a241731784fc Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 167 | 2024.10.21 22:14:54.642582 [ 257 ] {b33d5b0a-c1eb-4ac3-b7ee-cd286c688465} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59635) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 168 | 2024.10.21 22:14:54.703947 [ 257 ] {b33d5b0a-c1eb-4ac3-b7ee-cd286c688465} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:59635) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 169 | |||
| 170 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 171 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 172 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 173 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 174 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 175 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 176 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 177 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 178 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 179 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 180 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 181 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 182 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 183 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /opt/oxide/clickhouse/clickhouse | ||
| 184 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 185 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 186 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 187 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 188 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 189 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 190 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 191 | 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 192 | |||
| 193 | 2024.10.21 22:14:54.704906 [ 257 ] {b33d5b0a-c1eb-4ac3-b7ee-cd286c688465} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 194 | |||
| 195 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 196 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 197 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 198 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 199 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 200 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 201 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 202 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 203 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 204 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 205 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 206 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 207 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 208 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /opt/oxide/clickhouse/clickhouse | ||
| 209 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 210 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 211 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 212 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 213 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 214 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 215 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 216 | 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 217 | (version 23.8.7.1) | ||
| 218 | 2024.10.21 22:14:54.706770 [ 257 ] {} <Debug> HTTP-Session: fabcfab0-db18-4b17-97c5-a241731784fc Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 219 | 2024.10.21 22:14:54.707091 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:59635, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 220 | 2024.10.21 22:14:54.707500 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:64894, User-Agent: (none), Length: 40, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 221 | 2024.10.21 22:14:54.707597 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 222 | 2024.10.21 22:14:54.707624 [ 257 ] {} <Debug> HTTP-Session: a62dd5be-1021-4b01-be85-b1a426bd5b59 Authenticating user 'default' from [fd00:1122:3344:101::d]:64894 | ||
| 223 | 2024.10.21 22:14:54.707651 [ 257 ] {} <Debug> HTTP-Session: a62dd5be-1021-4b01-be85-b1a426bd5b59 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 224 | 2024.10.21 22:14:54.707681 [ 257 ] {} <Debug> HTTP-Session: a62dd5be-1021-4b01-be85-b1a426bd5b59 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 225 | 2024.10.21 22:14:54.707739 [ 257 ] {} <Trace> HTTP-Session: a62dd5be-1021-4b01-be85-b1a426bd5b59 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 226 | 2024.10.21 22:14:54.707946 [ 257 ] {962eb0c3-0778-41f7-9ea7-8d5a841f96ea} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:64894) SELECT MAX(value) FROM oximeter.version; (stage: Complete) | ||
| 227 | 2024.10.21 22:14:54.708284 [ 257 ] {962eb0c3-0778-41f7-9ea7-8d5a841f96ea} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:64894) (in query: SELECT MAX(value) FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 228 | |||
| 229 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 230 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 231 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 232 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 233 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 234 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 235 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 236 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 237 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 238 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 239 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 240 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 241 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 242 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /opt/oxide/clickhouse/clickhouse | ||
| 243 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 244 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 245 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 246 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 247 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 248 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 249 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 250 | 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 251 | |||
| 252 | 2024.10.21 22:14:54.708436 [ 257 ] {962eb0c3-0778-41f7-9ea7-8d5a841f96ea} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 253 | |||
| 254 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 255 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 256 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 257 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 258 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 259 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 260 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 261 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 262 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 263 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 264 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 265 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 266 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 267 | 13. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::shared_ptr<DB::Context>, std::function<void (DB::QueryResultDetails const&)>, std::optional<DB::FormatSettings> const&) @ 0x000000001518d019 in /opt/oxide/clickhouse/clickhouse | ||
| 268 | 14. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&) @ 0x00000000168a421a in /opt/oxide/clickhouse/clickhouse | ||
| 269 | 15. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x00000000168a714c in /opt/oxide/clickhouse/clickhouse | ||
| 270 | 16. DB::HTTPServerConnection::run() @ 0x00000000168c50ab in /opt/oxide/clickhouse/clickhouse | ||
| 271 | 17. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 272 | 18. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 273 | 19. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 274 | 20. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 275 | 21. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 276 | (version 23.8.7.1) | ||
| 277 | 2024.10.21 22:14:54.708632 [ 257 ] {} <Debug> HTTP-Session: a62dd5be-1021-4b01-be85-b1a426bd5b59 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 278 | 2024.10.21 22:14:54.708801 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:64894, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 279 | 2024.10.21 22:14:54.709646 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:34322, User-Agent: (none), Length: 32, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 280 | 2024.10.21 22:14:54.709709 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 281 | 2024.10.21 22:14:54.709730 [ 257 ] {} <Debug> HTTP-Session: b41b1ff5-8c2c-4b1c-bc4e-7896db79f65c Authenticating user 'default' from [fd00:1122:3344:101::d]:34322 | ||
| 282 | 2024.10.21 22:14:54.709746 [ 257 ] {} <Debug> HTTP-Session: b41b1ff5-8c2c-4b1c-bc4e-7896db79f65c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.10.21 22:14:54.709766 [ 257 ] {} <Debug> HTTP-Session: b41b1ff5-8c2c-4b1c-bc4e-7896db79f65c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 284 | 2024.10.21 22:14:54.709799 [ 257 ] {} <Trace> HTTP-Session: b41b1ff5-8c2c-4b1c-bc4e-7896db79f65c Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 285 | 2024.10.21 22:14:54.711060 [ 257 ] {ba5db31b-76ae-4014-9f33-ca60d438469d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:34322) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 286 | 2024.10.21 22:14:54.711906 [ 257 ] {ba5db31b-76ae-4014-9f33-ca60d438469d} <Debug> DynamicQueryHandler: Done processing query | ||
| 287 | 2024.10.21 22:14:54.711930 [ 257 ] {} <Debug> HTTP-Session: b41b1ff5-8c2c-4b1c-bc4e-7896db79f65c Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 288 | 2024.10.21 22:14:54.713033 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:34322, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 289 | 2024.10.21 22:14:54.713342 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:38064, User-Agent: (none), Length: 38, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 290 | 2024.10.21 22:14:54.713391 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 291 | 2024.10.21 22:14:54.713410 [ 257 ] {} <Debug> HTTP-Session: 4ae7480f-e57d-4ec2-ba71-d55b182a6bee Authenticating user 'default' from [fd00:1122:3344:101::d]:38064 | ||
| 292 | 2024.10.21 22:14:54.713435 [ 257 ] {} <Debug> HTTP-Session: 4ae7480f-e57d-4ec2-ba71-d55b182a6bee Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2024.10.21 22:14:54.713448 [ 257 ] {} <Debug> HTTP-Session: 4ae7480f-e57d-4ec2-ba71-d55b182a6bee Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 294 | 2024.10.21 22:14:54.713477 [ 257 ] {} <Trace> HTTP-Session: 4ae7480f-e57d-4ec2-ba71-d55b182a6bee Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 295 | 2024.10.21 22:14:54.713576 [ 257 ] {5e3fc699-8864-4325-823c-95fc8d173b9d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38064) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 296 | 2024.10.21 22:14:54.713664 [ 257 ] {5e3fc699-8864-4325-823c-95fc8d173b9d} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 297 | 2024.10.21 22:14:54.720225 [ 257 ] {5e3fc699-8864-4325-823c-95fc8d173b9d} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 298 | 2024.10.21 22:14:54.720254 [ 257 ] {5e3fc699-8864-4325-823c-95fc8d173b9d} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.3501e-05 sec | ||
| 299 | 2024.10.21 22:14:54.720268 [ 257 ] {5e3fc699-8864-4325-823c-95fc8d173b9d} <Trace> ReferentialDeps: No tables | ||
| 300 | 2024.10.21 22:14:54.720280 [ 257 ] {5e3fc699-8864-4325-823c-95fc8d173b9d} <Trace> LoadingDeps: No tables | ||
| 301 | 2024.10.21 22:14:54.720308 [ 257 ] {5e3fc699-8864-4325-823c-95fc8d173b9d} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 302 | 2024.10.21 22:14:54.720437 [ 257 ] {5e3fc699-8864-4325-823c-95fc8d173b9d} <Debug> DynamicQueryHandler: Done processing query | ||
| 303 | 2024.10.21 22:14:54.720459 [ 257 ] {} <Debug> HTTP-Session: 4ae7480f-e57d-4ec2-ba71-d55b182a6bee Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 304 | 2024.10.21 22:14:54.720596 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:38064, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 305 | 2024.10.21 22:14:54.720903 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:43611, User-Agent: (none), Length: 223, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 306 | 2024.10.21 22:14:54.720951 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 307 | 2024.10.21 22:14:54.720987 [ 257 ] {} <Debug> HTTP-Session: 094ec694-6206-4f8d-9caa-297de775a270 Authenticating user 'default' from [fd00:1122:3344:101::d]:43611 | ||
| 308 | 2024.10.21 22:14:54.721003 [ 257 ] {} <Debug> HTTP-Session: 094ec694-6206-4f8d-9caa-297de775a270 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 309 | 2024.10.21 22:14:54.721016 [ 257 ] {} <Debug> HTTP-Session: 094ec694-6206-4f8d-9caa-297de775a270 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 310 | 2024.10.21 22:14:54.721058 [ 257 ] {} <Trace> HTTP-Session: 094ec694-6206-4f8d-9caa-297de775a270 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 311 | 2024.10.21 22:14:54.721199 [ 257 ] {2637be29-3aa3-4a26-99e9-24fd51b0188e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43611) /* The version table contains metadata about the `oximeter` database */ | ||
| 312 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 313 | 2024.10.21 22:14:54.721252 [ 257 ] {2637be29-3aa3-4a26-99e9-24fd51b0188e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 314 | 2024.10.21 22:14:54.729762 [ 257 ] {2637be29-3aa3-4a26-99e9-24fd51b0188e} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 315 | 2024.10.21 22:14:54.736929 [ 257 ] {2637be29-3aa3-4a26-99e9-24fd51b0188e} <Debug> oximeter.version (8a488be3-3438-4894-8f57-3148f961fb7e): Loading data parts | ||
| 316 | 2024.10.21 22:14:54.737497 [ 257 ] {2637be29-3aa3-4a26-99e9-24fd51b0188e} <Debug> oximeter.version (8a488be3-3438-4894-8f57-3148f961fb7e): There are no data parts | ||
| 317 | 2024.10.21 22:14:54.745784 [ 257 ] {2637be29-3aa3-4a26-99e9-24fd51b0188e} <Debug> DynamicQueryHandler: Done processing query | ||
| 318 | 2024.10.21 22:14:54.745810 [ 257 ] {} <Debug> HTTP-Session: 094ec694-6206-4f8d-9caa-297de775a270 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.10.21 22:14:54.745982 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:43611, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 320 | 2024.10.21 22:14:54.746254 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:37911, User-Agent: (none), Length: 818, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 321 | 2024.10.21 22:14:54.746319 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 322 | 2024.10.21 22:14:54.746339 [ 257 ] {} <Debug> HTTP-Session: 4174941b-c4a9-44be-b653-09f0e0338ec4 Authenticating user 'default' from [fd00:1122:3344:101::d]:37911 | ||
| 323 | 2024.10.21 22:14:54.746356 [ 257 ] {} <Debug> HTTP-Session: 4174941b-c4a9-44be-b653-09f0e0338ec4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 324 | 2024.10.21 22:14:54.746379 [ 257 ] {} <Debug> HTTP-Session: 4174941b-c4a9-44be-b653-09f0e0338ec4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 325 | 2024.10.21 22:14:54.746410 [ 257 ] {} <Trace> HTTP-Session: 4174941b-c4a9-44be-b653-09f0e0338ec4 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 326 | 2024.10.21 22:14:54.746592 [ 257 ] {ff8c17b1-f2ea-4a9c-89d7-74b042d39b7b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:37911) /* The measurement tables contain all individual samples from each timeseries. | ||
| 327 | * | ||
| 328 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 329 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 330 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 331 | * by all samples from the same timeseries. | ||
| 332 | * | ||
| 333 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 334 | * and then uses that to index quickly into the measurements tables. | ||
| 335 | */ | ||
| 336 | 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) | ||
| 337 | 2024.10.21 22:14:54.746653 [ 257 ] {ff8c17b1-f2ea-4a9c-89d7-74b042d39b7b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 338 | 2024.10.21 22:14:54.756902 [ 257 ] {ff8c17b1-f2ea-4a9c-89d7-74b042d39b7b} <Debug> oximeter.measurements_bool (d2c9fbaf-9299-476a-b4a9-c9466726a882): Loading data parts | ||
| 339 | 2024.10.21 22:14:54.757205 [ 257 ] {ff8c17b1-f2ea-4a9c-89d7-74b042d39b7b} <Debug> oximeter.measurements_bool (d2c9fbaf-9299-476a-b4a9-c9466726a882): There are no data parts | ||
| 340 | 2024.10.21 22:14:54.760688 [ 257 ] {ff8c17b1-f2ea-4a9c-89d7-74b042d39b7b} <Debug> DynamicQueryHandler: Done processing query | ||
| 341 | 2024.10.21 22:14:54.760720 [ 257 ] {} <Debug> HTTP-Session: 4174941b-c4a9-44be-b653-09f0e0338ec4 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 342 | 2024.10.21 22:14:54.760898 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:37911, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 343 | 2024.10.21 22:14:54.761241 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:36578, User-Agent: (none), Length: 292, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 344 | 2024.10.21 22:14:54.761302 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 345 | 2024.10.21 22:14:54.761322 [ 257 ] {} <Debug> HTTP-Session: 1298cc93-03ed-48b1-9936-d85b5548b283 Authenticating user 'default' from [fd00:1122:3344:101::d]:36578 | ||
| 346 | 2024.10.21 22:14:54.761338 [ 257 ] {} <Debug> HTTP-Session: 1298cc93-03ed-48b1-9936-d85b5548b283 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 347 | 2024.10.21 22:14:54.761366 [ 257 ] {} <Debug> HTTP-Session: 1298cc93-03ed-48b1-9936-d85b5548b283 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 348 | 2024.10.21 22:14:54.761396 [ 257 ] {} <Trace> HTTP-Session: 1298cc93-03ed-48b1-9936-d85b5548b283 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 349 | 2024.10.21 22:14:54.761572 [ 257 ] {083cd57e-dc0c-4aee-9b81-26ee21e0b8e7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:36578) 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) | ||
| 350 | 2024.10.21 22:14:54.761625 [ 257 ] {083cd57e-dc0c-4aee-9b81-26ee21e0b8e7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 351 | 2024.10.21 22:14:54.765568 [ 257 ] {083cd57e-dc0c-4aee-9b81-26ee21e0b8e7} <Debug> oximeter.measurements_i8 (58312a3d-f1e3-4351-a233-f715f3fc0352): Loading data parts | ||
| 352 | 2024.10.21 22:14:54.765772 [ 257 ] {083cd57e-dc0c-4aee-9b81-26ee21e0b8e7} <Debug> oximeter.measurements_i8 (58312a3d-f1e3-4351-a233-f715f3fc0352): There are no data parts | ||
| 353 | 2024.10.21 22:14:54.771707 [ 257 ] {083cd57e-dc0c-4aee-9b81-26ee21e0b8e7} <Debug> DynamicQueryHandler: Done processing query | ||
| 354 | 2024.10.21 22:14:54.771738 [ 257 ] {} <Debug> HTTP-Session: 1298cc93-03ed-48b1-9936-d85b5548b283 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 355 | 2024.10.21 22:14:54.771913 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:36578, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 356 | 2024.10.21 22:14:54.772269 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:34927, User-Agent: (none), Length: 293, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 357 | 2024.10.21 22:14:54.772339 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 358 | 2024.10.21 22:14:54.772359 [ 257 ] {} <Debug> HTTP-Session: 473a1daf-ff3d-44fe-9462-4028cafb6302 Authenticating user 'default' from [fd00:1122:3344:101::d]:34927 | ||
| 359 | 2024.10.21 22:14:54.772375 [ 257 ] {} <Debug> HTTP-Session: 473a1daf-ff3d-44fe-9462-4028cafb6302 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 360 | 2024.10.21 22:14:54.772405 [ 257 ] {} <Debug> HTTP-Session: 473a1daf-ff3d-44fe-9462-4028cafb6302 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 361 | 2024.10.21 22:14:54.772435 [ 257 ] {} <Trace> HTTP-Session: 473a1daf-ff3d-44fe-9462-4028cafb6302 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 362 | 2024.10.21 22:14:54.772605 [ 257 ] {dc5e731e-075b-4151-b8f9-bc09ecc28955} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:34927) 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) | ||
| 363 | 2024.10.21 22:14:54.772657 [ 257 ] {dc5e731e-075b-4151-b8f9-bc09ecc28955} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 364 | 2024.10.21 22:14:54.778165 [ 257 ] {dc5e731e-075b-4151-b8f9-bc09ecc28955} <Debug> oximeter.measurements_u8 (83e2dc7b-bc31-47a6-b59c-0619fe2e6177): Loading data parts | ||
| 365 | 2024.10.21 22:14:54.778342 [ 257 ] {dc5e731e-075b-4151-b8f9-bc09ecc28955} <Debug> oximeter.measurements_u8 (83e2dc7b-bc31-47a6-b59c-0619fe2e6177): There are no data parts | ||
| 366 | 2024.10.21 22:14:54.784407 [ 257 ] {dc5e731e-075b-4151-b8f9-bc09ecc28955} <Debug> DynamicQueryHandler: Done processing query | ||
| 367 | 2024.10.21 22:14:54.784446 [ 257 ] {} <Debug> HTTP-Session: 473a1daf-ff3d-44fe-9462-4028cafb6302 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 368 | 2024.10.21 22:14:54.784632 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:34927, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 369 | 2024.10.21 22:14:54.784913 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:64340, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 370 | 2024.10.21 22:14:54.784971 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 371 | 2024.10.21 22:14:54.784990 [ 257 ] {} <Debug> HTTP-Session: 4dd0afb0-bcf0-4250-9eef-39d300bf2c62 Authenticating user 'default' from [fd00:1122:3344:101::d]:64340 | ||
| 372 | 2024.10.21 22:14:54.785007 [ 257 ] {} <Debug> HTTP-Session: 4dd0afb0-bcf0-4250-9eef-39d300bf2c62 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 373 | 2024.10.21 22:14:54.785027 [ 257 ] {} <Debug> HTTP-Session: 4dd0afb0-bcf0-4250-9eef-39d300bf2c62 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 374 | 2024.10.21 22:14:54.785056 [ 257 ] {} <Trace> HTTP-Session: 4dd0afb0-bcf0-4250-9eef-39d300bf2c62 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 375 | 2024.10.21 22:14:54.785234 [ 257 ] {ad9f54d5-8f22-49ee-a539-22468fc64744} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:64340) 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) | ||
| 376 | 2024.10.21 22:14:54.785282 [ 257 ] {ad9f54d5-8f22-49ee-a539-22468fc64744} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 377 | 2024.10.21 22:14:54.791624 [ 257 ] {ad9f54d5-8f22-49ee-a539-22468fc64744} <Debug> oximeter.measurements_i16 (7a1f762c-ebb3-4e54-90bd-d420ae445e4a): Loading data parts | ||
| 378 | 2024.10.21 22:14:54.791782 [ 257 ] {ad9f54d5-8f22-49ee-a539-22468fc64744} <Debug> oximeter.measurements_i16 (7a1f762c-ebb3-4e54-90bd-d420ae445e4a): There are no data parts | ||
| 379 | 2024.10.21 22:14:54.798077 [ 257 ] {ad9f54d5-8f22-49ee-a539-22468fc64744} <Debug> DynamicQueryHandler: Done processing query | ||
| 380 | 2024.10.21 22:14:54.798125 [ 257 ] {} <Debug> HTTP-Session: 4dd0afb0-bcf0-4250-9eef-39d300bf2c62 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 381 | 2024.10.21 22:14:54.798254 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:64340, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 382 | 2024.10.21 22:14:54.798593 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:38055, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 383 | 2024.10.21 22:14:54.798652 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 384 | 2024.10.21 22:14:54.798671 [ 257 ] {} <Debug> HTTP-Session: d13ebda6-a37b-4250-9213-cd657726f058 Authenticating user 'default' from [fd00:1122:3344:101::d]:38055 | ||
| 385 | 2024.10.21 22:14:54.798687 [ 257 ] {} <Debug> HTTP-Session: d13ebda6-a37b-4250-9213-cd657726f058 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 386 | 2024.10.21 22:14:54.798709 [ 257 ] {} <Debug> HTTP-Session: d13ebda6-a37b-4250-9213-cd657726f058 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 387 | 2024.10.21 22:14:54.798738 [ 257 ] {} <Trace> HTTP-Session: d13ebda6-a37b-4250-9213-cd657726f058 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 388 | 2024.10.21 22:14:54.798925 [ 257 ] {fcec80be-45d8-4981-bbdf-82a2b731be08} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38055) 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) | ||
| 389 | 2024.10.21 22:14:54.798967 [ 257 ] {fcec80be-45d8-4981-bbdf-82a2b731be08} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 390 | 2024.10.21 22:14:54.805273 [ 257 ] {fcec80be-45d8-4981-bbdf-82a2b731be08} <Debug> oximeter.measurements_u16 (68038d3f-302c-4030-832a-2c0bdff0082e): Loading data parts | ||
| 391 | 2024.10.21 22:14:54.805441 [ 257 ] {fcec80be-45d8-4981-bbdf-82a2b731be08} <Debug> oximeter.measurements_u16 (68038d3f-302c-4030-832a-2c0bdff0082e): There are no data parts | ||
| 392 | 2024.10.21 22:14:54.813383 [ 257 ] {fcec80be-45d8-4981-bbdf-82a2b731be08} <Debug> DynamicQueryHandler: Done processing query | ||
| 393 | 2024.10.21 22:14:54.813418 [ 257 ] {} <Debug> HTTP-Session: d13ebda6-a37b-4250-9213-cd657726f058 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 394 | 2024.10.21 22:14:54.813553 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:38055, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 395 | 2024.10.21 22:14:54.813921 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:47546, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 396 | 2024.10.21 22:14:54.813981 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 397 | 2024.10.21 22:14:54.814001 [ 257 ] {} <Debug> HTTP-Session: beef38c8-79d6-4c49-a4fd-703b50618245 Authenticating user 'default' from [fd00:1122:3344:101::d]:47546 | ||
| 398 | 2024.10.21 22:14:54.814032 [ 257 ] {} <Debug> HTTP-Session: beef38c8-79d6-4c49-a4fd-703b50618245 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 399 | 2024.10.21 22:14:54.814048 [ 257 ] {} <Debug> HTTP-Session: beef38c8-79d6-4c49-a4fd-703b50618245 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 400 | 2024.10.21 22:14:54.814077 [ 257 ] {} <Trace> HTTP-Session: beef38c8-79d6-4c49-a4fd-703b50618245 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 401 | 2024.10.21 22:14:54.814263 [ 257 ] {60facd4b-3ba6-424f-957a-35b9672b11df} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47546) 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) | ||
| 402 | 2024.10.21 22:14:54.814305 [ 257 ] {60facd4b-3ba6-424f-957a-35b9672b11df} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 403 | 2024.10.21 22:14:54.816286 [ 257 ] {60facd4b-3ba6-424f-957a-35b9672b11df} <Debug> oximeter.measurements_i32 (18e99261-ec96-4430-bd66-20febd7db254): Loading data parts | ||
| 404 | 2024.10.21 22:14:54.816460 [ 257 ] {60facd4b-3ba6-424f-957a-35b9672b11df} <Debug> oximeter.measurements_i32 (18e99261-ec96-4430-bd66-20febd7db254): There are no data parts | ||
| 405 | 2024.10.21 22:14:54.817607 [ 257 ] {60facd4b-3ba6-424f-957a-35b9672b11df} <Debug> DynamicQueryHandler: Done processing query | ||
| 406 | 2024.10.21 22:14:54.817647 [ 257 ] {} <Debug> HTTP-Session: beef38c8-79d6-4c49-a4fd-703b50618245 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 407 | 2024.10.21 22:14:54.817775 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:47546, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 408 | 2024.10.21 22:14:54.818076 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:55810, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 409 | 2024.10.21 22:14:54.818142 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 410 | 2024.10.21 22:14:54.818162 [ 257 ] {} <Debug> HTTP-Session: f121254d-33f3-4f84-892a-a3af8217407a Authenticating user 'default' from [fd00:1122:3344:101::d]:55810 | ||
| 411 | 2024.10.21 22:14:54.818186 [ 257 ] {} <Debug> HTTP-Session: f121254d-33f3-4f84-892a-a3af8217407a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 412 | 2024.10.21 22:14:54.818199 [ 257 ] {} <Debug> HTTP-Session: f121254d-33f3-4f84-892a-a3af8217407a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 413 | 2024.10.21 22:14:54.818229 [ 257 ] {} <Trace> HTTP-Session: f121254d-33f3-4f84-892a-a3af8217407a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 414 | 2024.10.21 22:14:54.818406 [ 257 ] {9885d356-b5cc-4206-a153-e278ff8e1577} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:55810) 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) | ||
| 415 | 2024.10.21 22:14:54.818455 [ 257 ] {9885d356-b5cc-4206-a153-e278ff8e1577} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 416 | 2024.10.21 22:14:54.820000 [ 257 ] {9885d356-b5cc-4206-a153-e278ff8e1577} <Debug> oximeter.measurements_u32 (35f262cd-76f9-4e13-a4bf-ec31e5be7ecb): Loading data parts | ||
| 417 | 2024.10.21 22:14:54.820165 [ 257 ] {9885d356-b5cc-4206-a153-e278ff8e1577} <Debug> oximeter.measurements_u32 (35f262cd-76f9-4e13-a4bf-ec31e5be7ecb): There are no data parts | ||
| 418 | 2024.10.21 22:14:54.821385 [ 257 ] {9885d356-b5cc-4206-a153-e278ff8e1577} <Debug> DynamicQueryHandler: Done processing query | ||
| 419 | 2024.10.21 22:14:54.821418 [ 257 ] {} <Debug> HTTP-Session: f121254d-33f3-4f84-892a-a3af8217407a Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 420 | 2024.10.21 22:14:54.821549 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:55810, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 421 | 2024.10.21 22:14:54.821842 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:55442, User-Agent: (none), Length: 294, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 422 | 2024.10.21 22:14:54.821893 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 423 | 2024.10.21 22:14:54.821912 [ 257 ] {} <Debug> HTTP-Session: 233a5819-abae-472a-85d9-9013f87448ab Authenticating user 'default' from [fd00:1122:3344:101::d]:55442 | ||
| 424 | 2024.10.21 22:14:54.821938 [ 257 ] {} <Debug> HTTP-Session: 233a5819-abae-472a-85d9-9013f87448ab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 425 | 2024.10.21 22:14:54.821952 [ 257 ] {} <Debug> HTTP-Session: 233a5819-abae-472a-85d9-9013f87448ab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 426 | 2024.10.21 22:14:54.821981 [ 257 ] {} <Trace> HTTP-Session: 233a5819-abae-472a-85d9-9013f87448ab Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 427 | 2024.10.21 22:14:54.822156 [ 257 ] {80bd7cc1-ccee-4c5b-b790-e07de4cd4630} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:55442) 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) | ||
| 428 | 2024.10.21 22:14:54.822209 [ 257 ] {80bd7cc1-ccee-4c5b-b790-e07de4cd4630} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 429 | 2024.10.21 22:14:54.823688 [ 257 ] {80bd7cc1-ccee-4c5b-b790-e07de4cd4630} <Debug> oximeter.measurements_i64 (1ae3a49b-011e-4cf1-aa66-6104f09e3b8f): Loading data parts | ||
| 430 | 2024.10.21 22:14:54.823843 [ 257 ] {80bd7cc1-ccee-4c5b-b790-e07de4cd4630} <Debug> oximeter.measurements_i64 (1ae3a49b-011e-4cf1-aa66-6104f09e3b8f): There are no data parts | ||
| 431 | 2024.10.21 22:14:54.825087 [ 257 ] {80bd7cc1-ccee-4c5b-b790-e07de4cd4630} <Debug> DynamicQueryHandler: Done processing query | ||
| 432 | 2024.10.21 22:14:54.825113 [ 257 ] {} <Debug> HTTP-Session: 233a5819-abae-472a-85d9-9013f87448ab Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 433 | 2024.10.21 22:14:54.825321 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:55442, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 434 | 2024.10.21 22:14:54.825643 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:34197, User-Agent: (none), Length: 295, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 435 | 2024.10.21 22:14:54.825693 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 436 | 2024.10.21 22:14:54.825712 [ 257 ] {} <Debug> HTTP-Session: cc91b0b3-415f-41ae-b1f5-757f96c94bd1 Authenticating user 'default' from [fd00:1122:3344:101::d]:34197 | ||
| 437 | 2024.10.21 22:14:54.825738 [ 257 ] {} <Debug> HTTP-Session: cc91b0b3-415f-41ae-b1f5-757f96c94bd1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 438 | 2024.10.21 22:14:54.825751 [ 257 ] {} <Debug> HTTP-Session: cc91b0b3-415f-41ae-b1f5-757f96c94bd1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 439 | 2024.10.21 22:14:54.825779 [ 257 ] {} <Trace> HTTP-Session: cc91b0b3-415f-41ae-b1f5-757f96c94bd1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 440 | 2024.10.21 22:14:54.825956 [ 257 ] {6da82ed2-dea1-46a1-bfff-e2a958965c39} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:34197) 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) | ||
| 441 | 2024.10.21 22:14:54.826008 [ 257 ] {6da82ed2-dea1-46a1-bfff-e2a958965c39} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 442 | 2024.10.21 22:14:54.827635 [ 257 ] {6da82ed2-dea1-46a1-bfff-e2a958965c39} <Debug> oximeter.measurements_u64 (548b3514-25e0-4a15-a55b-4c413fad77e4): Loading data parts | ||
| 443 | 2024.10.21 22:14:54.827792 [ 257 ] {6da82ed2-dea1-46a1-bfff-e2a958965c39} <Debug> oximeter.measurements_u64 (548b3514-25e0-4a15-a55b-4c413fad77e4): There are no data parts | ||
| 444 | 2024.10.21 22:14:54.829057 [ 257 ] {6da82ed2-dea1-46a1-bfff-e2a958965c39} <Debug> DynamicQueryHandler: Done processing query | ||
| 445 | 2024.10.21 22:14:54.829082 [ 257 ] {} <Debug> HTTP-Session: cc91b0b3-415f-41ae-b1f5-757f96c94bd1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 446 | 2024.10.21 22:14:54.829203 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:34197, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 447 | 2024.10.21 22:14:54.829529 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33252, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 448 | 2024.10.21 22:14:54.829578 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 449 | 2024.10.21 22:14:54.829597 [ 257 ] {} <Debug> HTTP-Session: ed8ce4b1-2d5b-44dc-b22e-aa24197a3de2 Authenticating user 'default' from [fd00:1122:3344:101::d]:33252 | ||
| 450 | 2024.10.21 22:14:54.829622 [ 257 ] {} <Debug> HTTP-Session: ed8ce4b1-2d5b-44dc-b22e-aa24197a3de2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 451 | 2024.10.21 22:14:54.829636 [ 257 ] {} <Debug> HTTP-Session: ed8ce4b1-2d5b-44dc-b22e-aa24197a3de2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 452 | 2024.10.21 22:14:54.829665 [ 257 ] {} <Trace> HTTP-Session: ed8ce4b1-2d5b-44dc-b22e-aa24197a3de2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 453 | 2024.10.21 22:14:54.829841 [ 257 ] {aa7b2341-4f8d-498f-8072-5ce49d17de96} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33252) 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) | ||
| 454 | 2024.10.21 22:14:54.829895 [ 257 ] {aa7b2341-4f8d-498f-8072-5ce49d17de96} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 455 | 2024.10.21 22:14:54.831474 [ 257 ] {aa7b2341-4f8d-498f-8072-5ce49d17de96} <Debug> oximeter.measurements_f32 (21280276-918d-4146-99d7-b34b1482e461): Loading data parts | ||
| 456 | 2024.10.21 22:14:54.831637 [ 260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:44118 | ||
| 457 | 2024.10.21 22:14:54.831759 [ 260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 458 | 2024.10.21 22:14:54.831789 [ 260 ] {} <Debug> TCP-Session: 4185aadf-c4fe-447a-a883-9ba700fe8db3 Authenticating user 'default' from [fd00:1122:3344:101::d]:44118 | ||
| 459 | 2024.10.21 22:14:54.831811 [ 260 ] {} <Debug> TCP-Session: 4185aadf-c4fe-447a-a883-9ba700fe8db3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 460 | 2024.10.21 22:14:54.831835 [ 260 ] {} <Debug> TCP-Session: 4185aadf-c4fe-447a-a883-9ba700fe8db3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 461 | 2024.10.21 22:14:54.832014 [ 257 ] {aa7b2341-4f8d-498f-8072-5ce49d17de96} <Debug> oximeter.measurements_f32 (21280276-918d-4146-99d7-b34b1482e461): There are no data parts | ||
| 462 | 2024.10.21 22:14:54.833306 [ 257 ] {aa7b2341-4f8d-498f-8072-5ce49d17de96} <Debug> DynamicQueryHandler: Done processing query | ||
| 463 | 2024.10.21 22:14:54.833336 [ 257 ] {} <Debug> HTTP-Session: ed8ce4b1-2d5b-44dc-b22e-aa24197a3de2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 464 | 2024.10.21 22:14:54.833483 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:33252, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 465 | 2024.10.21 22:14:54.833721 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33252, User-Agent: (none), Length: 296, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 466 | 2024.10.21 22:14:54.833789 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 467 | 2024.10.21 22:14:54.833813 [ 257 ] {} <Debug> HTTP-Session: 334eb040-0b88-4d4b-9876-b2d227974398 Authenticating user 'default' from [fd00:1122:3344:101::d]:33252 | ||
| 468 | 2024.10.21 22:14:54.833833 [ 257 ] {} <Debug> HTTP-Session: 334eb040-0b88-4d4b-9876-b2d227974398 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 469 | 2024.10.21 22:14:54.833862 [ 257 ] {} <Debug> HTTP-Session: 334eb040-0b88-4d4b-9876-b2d227974398 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 470 | 2024.10.21 22:14:54.833897 [ 257 ] {} <Trace> HTTP-Session: 334eb040-0b88-4d4b-9876-b2d227974398 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 471 | 2024.10.21 22:14:54.834092 [ 257 ] {8c640dff-1934-4cf2-958d-b4c506fb4506} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33252) 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) | ||
| 472 | 2024.10.21 22:14:54.834154 [ 257 ] {8c640dff-1934-4cf2-958d-b4c506fb4506} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 473 | 2024.10.21 22:14:54.835883 [ 257 ] {8c640dff-1934-4cf2-958d-b4c506fb4506} <Debug> oximeter.measurements_f64 (a953d4ec-5d5f-406f-b984-b2a2c78a2ba0): Loading data parts | ||
| 474 | 2024.10.21 22:14:54.836089 [ 257 ] {8c640dff-1934-4cf2-958d-b4c506fb4506} <Debug> oximeter.measurements_f64 (a953d4ec-5d5f-406f-b984-b2a2c78a2ba0): There are no data parts | ||
| 475 | 2024.10.21 22:14:54.837337 [ 257 ] {8c640dff-1934-4cf2-958d-b4c506fb4506} <Debug> DynamicQueryHandler: Done processing query | ||
| 476 | 2024.10.21 22:14:54.837374 [ 257 ] {} <Debug> HTTP-Session: 334eb040-0b88-4d4b-9876-b2d227974398 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 477 | 2024.10.21 22:14:54.837535 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:33252, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 478 | 2024.10.21 22:14:54.838631 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:61922, User-Agent: (none), Length: 298, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 479 | 2024.10.21 22:14:54.838816 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 480 | 2024.10.21 22:14:54.838859 [ 261 ] {} <Debug> HTTP-Session: a6551af3-4926-4198-9a08-e0ec4417f2f6 Authenticating user 'default' from [fd00:1122:3344:101::d]:61922 | ||
| 481 | 2024.10.21 22:14:54.838882 [ 261 ] {} <Debug> HTTP-Session: a6551af3-4926-4198-9a08-e0ec4417f2f6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 482 | 2024.10.21 22:14:54.838916 [ 261 ] {} <Debug> HTTP-Session: a6551af3-4926-4198-9a08-e0ec4417f2f6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 483 | 2024.10.21 22:14:54.838973 [ 261 ] {} <Trace> HTTP-Session: a6551af3-4926-4198-9a08-e0ec4417f2f6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 484 | 2024.10.21 22:14:54.839293 [ 261 ] {7c5c8cd1-b27e-4738-a826-c184d8858d6f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:61922) 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) | ||
| 485 | 2024.10.21 22:14:54.839395 [ 257 ] {} <Error> ServerErrorHandler: Poco::Exception. Code: 1000, e.code() = 32, I/O error: Broken pipe, Stack trace (when copying this message, always include the lines below): | ||
| 486 | |||
| 487 | (version 23.8.7.1) | ||
| 488 | 2024.10.21 22:14:54.839403 [ 261 ] {7c5c8cd1-b27e-4738-a826-c184d8858d6f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 489 | 2024.10.21 22:14:54.841406 [ 261 ] {7c5c8cd1-b27e-4738-a826-c184d8858d6f} <Debug> oximeter.measurements_string (4ea83e4c-e692-4441-aee5-7184e44a767c): Loading data parts | ||
| 490 | 2024.10.21 22:14:54.841613 [ 261 ] {7c5c8cd1-b27e-4738-a826-c184d8858d6f} <Debug> oximeter.measurements_string (4ea83e4c-e692-4441-aee5-7184e44a767c): There are no data parts | ||
| 491 | 2024.10.21 22:14:54.843002 [ 261 ] {7c5c8cd1-b27e-4738-a826-c184d8858d6f} <Debug> DynamicQueryHandler: Done processing query | ||
| 492 | 2024.10.21 22:14:54.843035 [ 261 ] {} <Debug> HTTP-Session: a6551af3-4926-4198-9a08-e0ec4417f2f6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 493 | 2024.10.21 22:14:54.843204 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:61922, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 494 | 2024.10.21 22:14:54.843638 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:54660, User-Agent: (none), Length: 605, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 495 | 2024.10.21 22:14:54.843701 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 496 | 2024.10.21 22:14:54.843758 [ 261 ] {} <Debug> HTTP-Session: cfd61230-e84f-4393-b33f-2d7b99fc86dd Authenticating user 'default' from [fd00:1122:3344:101::d]:54660 | ||
| 497 | 2024.10.21 22:14:54.843780 [ 261 ] {} <Debug> HTTP-Session: cfd61230-e84f-4393-b33f-2d7b99fc86dd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 498 | 2024.10.21 22:14:54.843798 [ 261 ] {} <Debug> HTTP-Session: cfd61230-e84f-4393-b33f-2d7b99fc86dd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 499 | 2024.10.21 22:14:54.843883 [ 261 ] {} <Trace> HTTP-Session: cfd61230-e84f-4393-b33f-2d7b99fc86dd Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 500 | 2024.10.21 22:14:54.844126 [ 261 ] {6169e4ed-be17-4c50-b6c7-0e82852b5bb7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:54660) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 501 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 502 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 503 | * a string isn't palatable for a few reasons. | ||
| 504 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 505 | * details. | ||
| 506 | */ | ||
| 507 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 508 | 2024.10.21 22:14:54.844207 [ 261 ] {6169e4ed-be17-4c50-b6c7-0e82852b5bb7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 509 | 2024.10.21 22:14:54.846066 [ 261 ] {6169e4ed-be17-4c50-b6c7-0e82852b5bb7} <Debug> oximeter.measurements_bytes (a2da71f6-579b-4ea3-b81f-bef3e9258a08): Loading data parts | ||
| 510 | 2024.10.21 22:14:54.846282 [ 261 ] {6169e4ed-be17-4c50-b6c7-0e82852b5bb7} <Debug> oximeter.measurements_bytes (a2da71f6-579b-4ea3-b81f-bef3e9258a08): There are no data parts | ||
| 511 | 2024.10.21 22:14:54.847548 [ 261 ] {6169e4ed-be17-4c50-b6c7-0e82852b5bb7} <Debug> DynamicQueryHandler: Done processing query | ||
| 512 | 2024.10.21 22:14:54.847609 [ 261 ] {} <Debug> HTTP-Session: cfd61230-e84f-4393-b33f-2d7b99fc86dd Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 513 | 2024.10.21 22:14:54.847793 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:54660, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 514 | 2024.10.21 22:14:54.848162 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:50789, User-Agent: (none), Length: 353, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 515 | 2024.10.21 22:14:54.848249 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 516 | 2024.10.21 22:14:54.848272 [ 261 ] {} <Debug> HTTP-Session: 121c01c8-9b27-436b-8329-7c7e90606582 Authenticating user 'default' from [fd00:1122:3344:101::d]:50789 | ||
| 517 | 2024.10.21 22:14:54.848318 [ 261 ] {} <Debug> HTTP-Session: 121c01c8-9b27-436b-8329-7c7e90606582 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 518 | 2024.10.21 22:14:54.848335 [ 261 ] {} <Debug> HTTP-Session: 121c01c8-9b27-436b-8329-7c7e90606582 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 519 | 2024.10.21 22:14:54.848373 [ 261 ] {} <Trace> HTTP-Session: 121c01c8-9b27-436b-8329-7c7e90606582 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 520 | 2024.10.21 22:14:54.848635 [ 261 ] {5ba6ed62-707f-48f1-9329-f9a3cf821894} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50789) 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) | ||
| 521 | 2024.10.21 22:14:54.848716 [ 261 ] {5ba6ed62-707f-48f1-9329-f9a3cf821894} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 522 | 2024.10.21 22:14:54.850541 [ 261 ] {5ba6ed62-707f-48f1-9329-f9a3cf821894} <Debug> oximeter.measurements_cumulativei64 (2cb173d7-b9a8-4fa6-8515-dee47a74c8de): Loading data parts | ||
| 523 | 2024.10.21 22:14:54.850741 [ 261 ] {5ba6ed62-707f-48f1-9329-f9a3cf821894} <Debug> oximeter.measurements_cumulativei64 (2cb173d7-b9a8-4fa6-8515-dee47a74c8de): There are no data parts | ||
| 524 | 2024.10.21 22:14:54.852002 [ 261 ] {5ba6ed62-707f-48f1-9329-f9a3cf821894} <Debug> DynamicQueryHandler: Done processing query | ||
| 525 | 2024.10.21 22:14:54.852031 [ 261 ] {} <Debug> HTTP-Session: 121c01c8-9b27-436b-8329-7c7e90606582 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 526 | 2024.10.21 22:14:54.852173 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:50789, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 527 | 2024.10.21 22:14:54.852571 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:37744, User-Agent: (none), Length: 354, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 528 | 2024.10.21 22:14:54.852629 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 529 | 2024.10.21 22:14:54.852676 [ 261 ] {} <Debug> HTTP-Session: 14c4829c-44ba-4a70-bfb0-42fe136860c3 Authenticating user 'default' from [fd00:1122:3344:101::d]:37744 | ||
| 530 | 2024.10.21 22:14:54.852710 [ 261 ] {} <Debug> HTTP-Session: 14c4829c-44ba-4a70-bfb0-42fe136860c3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 531 | 2024.10.21 22:14:54.852732 [ 261 ] {} <Debug> HTTP-Session: 14c4829c-44ba-4a70-bfb0-42fe136860c3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 532 | 2024.10.21 22:14:54.852785 [ 261 ] {} <Trace> HTTP-Session: 14c4829c-44ba-4a70-bfb0-42fe136860c3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 533 | 2024.10.21 22:14:54.853035 [ 261 ] {550f314f-84e1-46c1-b528-4c77da3ce8d2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:37744) 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) | ||
| 534 | 2024.10.21 22:14:54.853121 [ 261 ] {550f314f-84e1-46c1-b528-4c77da3ce8d2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 535 | 2024.10.21 22:14:54.854863 [ 261 ] {550f314f-84e1-46c1-b528-4c77da3ce8d2} <Debug> oximeter.measurements_cumulativeu64 (168d023a-9841-4ca5-b460-f83289216a5d): Loading data parts | ||
| 536 | 2024.10.21 22:14:54.855082 [ 261 ] {550f314f-84e1-46c1-b528-4c77da3ce8d2} <Debug> oximeter.measurements_cumulativeu64 (168d023a-9841-4ca5-b460-f83289216a5d): There are no data parts | ||
| 537 | 2024.10.21 22:14:54.856342 [ 261 ] {550f314f-84e1-46c1-b528-4c77da3ce8d2} <Debug> DynamicQueryHandler: Done processing query | ||
| 538 | 2024.10.21 22:14:54.856372 [ 261 ] {} <Debug> HTTP-Session: 14c4829c-44ba-4a70-bfb0-42fe136860c3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 539 | 2024.10.21 22:14:54.856525 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:37744, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 540 | 2024.10.21 22:14:54.856914 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59202, User-Agent: (none), Length: 355, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 541 | 2024.10.21 22:14:54.856973 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 542 | 2024.10.21 22:14:54.857010 [ 261 ] {} <Debug> HTTP-Session: c38563b4-d9d3-4773-a392-12456397f7c7 Authenticating user 'default' from [fd00:1122:3344:101::d]:59202 | ||
| 543 | 2024.10.21 22:14:54.857031 [ 261 ] {} <Debug> HTTP-Session: c38563b4-d9d3-4773-a392-12456397f7c7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 544 | 2024.10.21 22:14:54.857049 [ 261 ] {} <Debug> HTTP-Session: c38563b4-d9d3-4773-a392-12456397f7c7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 545 | 2024.10.21 22:14:54.857101 [ 261 ] {} <Trace> HTTP-Session: c38563b4-d9d3-4773-a392-12456397f7c7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 546 | 2024.10.21 22:14:54.857322 [ 261 ] {e1472971-2a29-459c-9b2f-74f057b2ffbf} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59202) 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) | ||
| 547 | 2024.10.21 22:14:54.857387 [ 261 ] {e1472971-2a29-459c-9b2f-74f057b2ffbf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 548 | 2024.10.21 22:14:54.859260 [ 261 ] {e1472971-2a29-459c-9b2f-74f057b2ffbf} <Debug> oximeter.measurements_cumulativef32 (9bbadc38-f1bd-4067-89ef-d1315a09a6c8): Loading data parts | ||
| 549 | 2024.10.21 22:14:54.859502 [ 261 ] {e1472971-2a29-459c-9b2f-74f057b2ffbf} <Debug> oximeter.measurements_cumulativef32 (9bbadc38-f1bd-4067-89ef-d1315a09a6c8): There are no data parts | ||
| 550 | 2024.10.21 22:14:54.860732 [ 261 ] {e1472971-2a29-459c-9b2f-74f057b2ffbf} <Debug> DynamicQueryHandler: Done processing query | ||
| 551 | 2024.10.21 22:14:54.860758 [ 261 ] {} <Debug> HTTP-Session: c38563b4-d9d3-4773-a392-12456397f7c7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 552 | 2024.10.21 22:14:54.860925 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:59202, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 553 | 2024.10.21 22:14:54.861217 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59202, User-Agent: (none), Length: 356, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 554 | 2024.10.21 22:14:54.861278 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 555 | 2024.10.21 22:14:54.861297 [ 261 ] {} <Debug> HTTP-Session: 46120c10-5fef-48e2-b7ea-9aafa64b9ace Authenticating user 'default' from [fd00:1122:3344:101::d]:59202 | ||
| 556 | 2024.10.21 22:14:54.861313 [ 261 ] {} <Debug> HTTP-Session: 46120c10-5fef-48e2-b7ea-9aafa64b9ace Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 557 | 2024.10.21 22:14:54.861338 [ 261 ] {} <Debug> HTTP-Session: 46120c10-5fef-48e2-b7ea-9aafa64b9ace Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 558 | 2024.10.21 22:14:54.861368 [ 261 ] {} <Trace> HTTP-Session: 46120c10-5fef-48e2-b7ea-9aafa64b9ace Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 559 | 2024.10.21 22:14:54.861596 [ 261 ] {b9e8fe51-6d0d-4827-b5af-412093f84126} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59202) 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) | ||
| 560 | 2024.10.21 22:14:54.861660 [ 261 ] {b9e8fe51-6d0d-4827-b5af-412093f84126} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 561 | 2024.10.21 22:14:54.863342 [ 261 ] {b9e8fe51-6d0d-4827-b5af-412093f84126} <Debug> oximeter.measurements_cumulativef64 (0d259e11-90b3-4033-8c66-c239afb6f849): Loading data parts | ||
| 562 | 2024.10.21 22:14:54.863516 [ 261 ] {b9e8fe51-6d0d-4827-b5af-412093f84126} <Debug> oximeter.measurements_cumulativef64 (0d259e11-90b3-4033-8c66-c239afb6f849): There are no data parts | ||
| 563 | 2024.10.21 22:14:54.864719 [ 261 ] {b9e8fe51-6d0d-4827-b5af-412093f84126} <Debug> DynamicQueryHandler: Done processing query | ||
| 564 | 2024.10.21 22:14:54.864781 [ 261 ] {} <Debug> HTTP-Session: 46120c10-5fef-48e2-b7ea-9aafa64b9ace Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 565 | 2024.10.21 22:14:54.864980 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:59202, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 566 | 2024.10.21 22:14:54.865189 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59202, User-Agent: (none), Length: 1300, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 567 | 2024.10.21 22:14:54.865260 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 568 | 2024.10.21 22:14:54.865279 [ 261 ] {} <Debug> HTTP-Session: 60db1192-b6e1-44ac-a98b-2fc8ce1adcaa Authenticating user 'default' from [fd00:1122:3344:101::d]:59202 | ||
| 569 | 2024.10.21 22:14:54.865314 [ 261 ] {} <Debug> HTTP-Session: 60db1192-b6e1-44ac-a98b-2fc8ce1adcaa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 570 | 2024.10.21 22:14:54.865338 [ 261 ] {} <Debug> HTTP-Session: 60db1192-b6e1-44ac-a98b-2fc8ce1adcaa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 571 | 2024.10.21 22:14:54.865369 [ 261 ] {} <Trace> HTTP-Session: 60db1192-b6e1-44ac-a98b-2fc8ce1adcaa Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 572 | 2024.10.21 22:14:54.865656 [ 261 ] {e79c452e-97c5-4f35-83cf-245de576b840} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59202) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 573 | * NOTE: Array types cannot be Nullable, see | ||
| 574 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 575 | * for more details. | ||
| 576 | * | ||
| 577 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 578 | * is unfortunate, and at this point relies on the fact that an | ||
| 579 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 580 | * to figure out another way to represent missing samples here. | ||
| 581 | */ | ||
| 582 | 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) | ||
| 583 | 2024.10.21 22:14:54.865729 [ 261 ] {e79c452e-97c5-4f35-83cf-245de576b840} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 584 | 2024.10.21 22:14:54.867770 [ 261 ] {e79c452e-97c5-4f35-83cf-245de576b840} <Debug> oximeter.measurements_histogrami8 (a903c1fd-c5b4-4cf0-83a1-3d91452178c5): Loading data parts | ||
| 585 | 2024.10.21 22:14:54.867962 [ 261 ] {e79c452e-97c5-4f35-83cf-245de576b840} <Debug> oximeter.measurements_histogrami8 (a903c1fd-c5b4-4cf0-83a1-3d91452178c5): There are no data parts | ||
| 586 | 2024.10.21 22:14:54.869232 [ 261 ] {e79c452e-97c5-4f35-83cf-245de576b840} <Debug> DynamicQueryHandler: Done processing query | ||
| 587 | 2024.10.21 22:14:54.869281 [ 261 ] {} <Debug> HTTP-Session: 60db1192-b6e1-44ac-a98b-2fc8ce1adcaa Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 588 | 2024.10.21 22:14:54.869450 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:59202, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 589 | 2024.10.21 22:14:54.869817 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:44522, User-Agent: (none), Length: 839, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 590 | 2024.10.21 22:14:54.869882 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 591 | 2024.10.21 22:14:54.869901 [ 261 ] {} <Debug> HTTP-Session: fbe3ddb3-d0ee-4b17-86d4-9b723ca190b7 Authenticating user 'default' from [fd00:1122:3344:101::d]:44522 | ||
| 592 | 2024.10.21 22:14:54.869917 [ 261 ] {} <Debug> HTTP-Session: fbe3ddb3-d0ee-4b17-86d4-9b723ca190b7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 593 | 2024.10.21 22:14:54.869943 [ 261 ] {} <Debug> HTTP-Session: fbe3ddb3-d0ee-4b17-86d4-9b723ca190b7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 594 | 2024.10.21 22:14:54.869973 [ 261 ] {} <Trace> HTTP-Session: fbe3ddb3-d0ee-4b17-86d4-9b723ca190b7 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 595 | 2024.10.21 22:14:54.870244 [ 261 ] {78910d6b-8808-4c64-b0a9-f027472a66ed} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44522) 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) | ||
| 596 | 2024.10.21 22:14:54.870316 [ 261 ] {78910d6b-8808-4c64-b0a9-f027472a66ed} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 597 | 2024.10.21 22:14:54.872159 [ 261 ] {78910d6b-8808-4c64-b0a9-f027472a66ed} <Debug> oximeter.measurements_histogramu8 (4b6ae8cc-ebf8-49d6-a106-e16f9d18e8da): Loading data parts | ||
| 598 | 2024.10.21 22:14:54.872372 [ 261 ] {78910d6b-8808-4c64-b0a9-f027472a66ed} <Debug> oximeter.measurements_histogramu8 (4b6ae8cc-ebf8-49d6-a106-e16f9d18e8da): There are no data parts | ||
| 599 | 2024.10.21 22:14:54.873656 [ 261 ] {78910d6b-8808-4c64-b0a9-f027472a66ed} <Debug> DynamicQueryHandler: Done processing query | ||
| 600 | 2024.10.21 22:14:54.873708 [ 261 ] {} <Debug> HTTP-Session: fbe3ddb3-d0ee-4b17-86d4-9b723ca190b7 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 601 | 2024.10.21 22:14:54.873870 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:44522, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 602 | 2024.10.21 22:14:54.874084 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:44522, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 603 | 2024.10.21 22:14:54.874150 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 604 | 2024.10.21 22:14:54.874169 [ 261 ] {} <Debug> HTTP-Session: 7eb03df6-a29c-49dc-baf5-e441759572e6 Authenticating user 'default' from [fd00:1122:3344:101::d]:44522 | ||
| 605 | 2024.10.21 22:14:54.874193 [ 261 ] {} <Debug> HTTP-Session: 7eb03df6-a29c-49dc-baf5-e441759572e6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 606 | 2024.10.21 22:14:54.874212 [ 261 ] {} <Debug> HTTP-Session: 7eb03df6-a29c-49dc-baf5-e441759572e6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 607 | 2024.10.21 22:14:54.874244 [ 261 ] {} <Trace> HTTP-Session: 7eb03df6-a29c-49dc-baf5-e441759572e6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 608 | 2024.10.21 22:14:54.874516 [ 261 ] {3fabd40d-8f57-4457-af3b-c2dad79faaf9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:44522) 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) | ||
| 609 | 2024.10.21 22:14:54.874586 [ 261 ] {3fabd40d-8f57-4457-af3b-c2dad79faaf9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 610 | 2024.10.21 22:14:54.876463 [ 261 ] {3fabd40d-8f57-4457-af3b-c2dad79faaf9} <Debug> oximeter.measurements_histogrami16 (66434aad-1918-4dc5-966b-54d966460c68): Loading data parts | ||
| 611 | 2024.10.21 22:14:54.876639 [ 261 ] {3fabd40d-8f57-4457-af3b-c2dad79faaf9} <Debug> oximeter.measurements_histogrami16 (66434aad-1918-4dc5-966b-54d966460c68): There are no data parts | ||
| 612 | 2024.10.21 22:14:54.877925 [ 261 ] {3fabd40d-8f57-4457-af3b-c2dad79faaf9} <Debug> DynamicQueryHandler: Done processing query | ||
| 613 | 2024.10.21 22:14:54.877981 [ 261 ] {} <Debug> HTTP-Session: 7eb03df6-a29c-49dc-baf5-e441759572e6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 614 | 2024.10.21 22:14:54.878117 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:44522, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 615 | 2024.10.21 22:14:54.878434 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33622, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 616 | 2024.10.21 22:14:54.878499 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 617 | 2024.10.21 22:14:54.878519 [ 261 ] {} <Debug> HTTP-Session: 3e159524-bbb5-4790-b55c-1ca95980d8e6 Authenticating user 'default' from [fd00:1122:3344:101::d]:33622 | ||
| 618 | 2024.10.21 22:14:54.878549 [ 261 ] {} <Debug> HTTP-Session: 3e159524-bbb5-4790-b55c-1ca95980d8e6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 619 | 2024.10.21 22:14:54.878563 [ 261 ] {} <Debug> HTTP-Session: 3e159524-bbb5-4790-b55c-1ca95980d8e6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 620 | 2024.10.21 22:14:54.878594 [ 261 ] {} <Trace> HTTP-Session: 3e159524-bbb5-4790-b55c-1ca95980d8e6 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 621 | 2024.10.21 22:14:54.878862 [ 261 ] {7e71fe97-3abc-46d8-a2a1-896cd4c23129} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33622) 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) | ||
| 622 | 2024.10.21 22:14:54.878939 [ 261 ] {7e71fe97-3abc-46d8-a2a1-896cd4c23129} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 623 | 2024.10.21 22:14:54.880835 [ 261 ] {7e71fe97-3abc-46d8-a2a1-896cd4c23129} <Debug> oximeter.measurements_histogramu16 (503b182a-0fb6-46ce-ac30-cb30f03a6542): Loading data parts | ||
| 624 | 2024.10.21 22:14:54.881036 [ 261 ] {7e71fe97-3abc-46d8-a2a1-896cd4c23129} <Debug> oximeter.measurements_histogramu16 (503b182a-0fb6-46ce-ac30-cb30f03a6542): There are no data parts | ||
| 625 | 2024.10.21 22:14:54.882318 [ 261 ] {7e71fe97-3abc-46d8-a2a1-896cd4c23129} <Debug> DynamicQueryHandler: Done processing query | ||
| 626 | 2024.10.21 22:14:54.882352 [ 261 ] {} <Debug> HTTP-Session: 3e159524-bbb5-4790-b55c-1ca95980d8e6 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 627 | 2024.10.21 22:14:54.882504 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:33622, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 628 | 2024.10.21 22:14:54.882731 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:33622, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 629 | 2024.10.21 22:14:54.882798 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 630 | 2024.10.21 22:14:54.882826 [ 261 ] {} <Debug> HTTP-Session: 77bfd940-71ee-4444-8c12-0d06379caf57 Authenticating user 'default' from [fd00:1122:3344:101::d]:33622 | ||
| 631 | 2024.10.21 22:14:54.882863 [ 261 ] {} <Debug> HTTP-Session: 77bfd940-71ee-4444-8c12-0d06379caf57 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 632 | 2024.10.21 22:14:54.882877 [ 261 ] {} <Debug> HTTP-Session: 77bfd940-71ee-4444-8c12-0d06379caf57 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 633 | 2024.10.21 22:14:54.882908 [ 261 ] {} <Trace> HTTP-Session: 77bfd940-71ee-4444-8c12-0d06379caf57 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 634 | 2024.10.21 22:14:54.883210 [ 261 ] {c75745e2-3776-4039-99d1-77f0eff4afbd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:33622) 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) | ||
| 635 | 2024.10.21 22:14:54.883280 [ 261 ] {c75745e2-3776-4039-99d1-77f0eff4afbd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 636 | 2024.10.21 22:14:54.885165 [ 261 ] {c75745e2-3776-4039-99d1-77f0eff4afbd} <Debug> oximeter.measurements_histogrami32 (9ce8fa3e-d50f-46d1-814b-c5bba9878d8b): Loading data parts | ||
| 637 | 2024.10.21 22:14:54.885347 [ 261 ] {c75745e2-3776-4039-99d1-77f0eff4afbd} <Debug> oximeter.measurements_histogrami32 (9ce8fa3e-d50f-46d1-814b-c5bba9878d8b): There are no data parts | ||
| 638 | 2024.10.21 22:14:54.886686 [ 261 ] {c75745e2-3776-4039-99d1-77f0eff4afbd} <Debug> DynamicQueryHandler: Done processing query | ||
| 639 | 2024.10.21 22:14:54.886714 [ 261 ] {} <Debug> HTTP-Session: 77bfd940-71ee-4444-8c12-0d06379caf57 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 640 | 2024.10.21 22:14:54.886865 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:33622, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 641 | 2024.10.21 22:14:54.887225 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49786, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 642 | 2024.10.21 22:14:54.887277 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 643 | 2024.10.21 22:14:54.887295 [ 261 ] {} <Debug> HTTP-Session: 85d0427d-9746-47ab-9dcc-9f4c2f356d83 Authenticating user 'default' from [fd00:1122:3344:101::d]:49786 | ||
| 644 | 2024.10.21 22:14:54.887325 [ 261 ] {} <Debug> HTTP-Session: 85d0427d-9746-47ab-9dcc-9f4c2f356d83 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 645 | 2024.10.21 22:14:54.887339 [ 261 ] {} <Debug> HTTP-Session: 85d0427d-9746-47ab-9dcc-9f4c2f356d83 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 646 | 2024.10.21 22:14:54.887369 [ 261 ] {} <Trace> HTTP-Session: 85d0427d-9746-47ab-9dcc-9f4c2f356d83 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 647 | 2024.10.21 22:14:54.887639 [ 261 ] {d40d8f3b-7e56-4ebe-af7a-115317aa60fa} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49786) 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) | ||
| 648 | 2024.10.21 22:14:54.887718 [ 261 ] {d40d8f3b-7e56-4ebe-af7a-115317aa60fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 649 | 2024.10.21 22:14:54.889583 [ 261 ] {d40d8f3b-7e56-4ebe-af7a-115317aa60fa} <Debug> oximeter.measurements_histogramu32 (012e2990-685f-4166-bdad-c0910e43cbb4): Loading data parts | ||
| 650 | 2024.10.21 22:14:54.889781 [ 261 ] {d40d8f3b-7e56-4ebe-af7a-115317aa60fa} <Debug> oximeter.measurements_histogramu32 (012e2990-685f-4166-bdad-c0910e43cbb4): There are no data parts | ||
| 651 | 2024.10.21 22:14:54.891222 [ 261 ] {d40d8f3b-7e56-4ebe-af7a-115317aa60fa} <Debug> DynamicQueryHandler: Done processing query | ||
| 652 | 2024.10.21 22:14:54.891254 [ 261 ] {} <Debug> HTTP-Session: 85d0427d-9746-47ab-9dcc-9f4c2f356d83 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 653 | 2024.10.21 22:14:54.891401 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:49786, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 654 | 2024.10.21 22:14:54.891680 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49786, User-Agent: (none), Length: 840, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 655 | 2024.10.21 22:14:54.891736 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 656 | 2024.10.21 22:14:54.891762 [ 261 ] {} <Debug> HTTP-Session: 69d04f5c-6150-4f2a-be0d-b28b694cf1f2 Authenticating user 'default' from [fd00:1122:3344:101::d]:49786 | ||
| 657 | 2024.10.21 22:14:54.891797 [ 261 ] {} <Debug> HTTP-Session: 69d04f5c-6150-4f2a-be0d-b28b694cf1f2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 658 | 2024.10.21 22:14:54.891815 [ 261 ] {} <Debug> HTTP-Session: 69d04f5c-6150-4f2a-be0d-b28b694cf1f2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 659 | 2024.10.21 22:14:54.891851 [ 261 ] {} <Trace> HTTP-Session: 69d04f5c-6150-4f2a-be0d-b28b694cf1f2 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 660 | 2024.10.21 22:14:54.892184 [ 261 ] {44aa8cc5-33b9-4508-b44e-253e4a68e484} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49786) 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) | ||
| 661 | 2024.10.21 22:14:54.892274 [ 261 ] {44aa8cc5-33b9-4508-b44e-253e4a68e484} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 662 | 2024.10.21 22:14:54.894443 [ 261 ] {44aa8cc5-33b9-4508-b44e-253e4a68e484} <Debug> oximeter.measurements_histogrami64 (960401f8-5fff-44e5-81c5-31e933c913b9): Loading data parts | ||
| 663 | 2024.10.21 22:14:54.894646 [ 261 ] {44aa8cc5-33b9-4508-b44e-253e4a68e484} <Debug> oximeter.measurements_histogrami64 (960401f8-5fff-44e5-81c5-31e933c913b9): There are no data parts | ||
| 664 | 2024.10.21 22:14:54.896130 [ 261 ] {44aa8cc5-33b9-4508-b44e-253e4a68e484} <Debug> DynamicQueryHandler: Done processing query | ||
| 665 | 2024.10.21 22:14:54.896161 [ 261 ] {} <Debug> HTTP-Session: 69d04f5c-6150-4f2a-be0d-b28b694cf1f2 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 666 | 2024.10.21 22:14:54.896315 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:49786, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 667 | 2024.10.21 22:14:54.896724 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:61400, User-Agent: (none), Length: 843, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 668 | 2024.10.21 22:14:54.896782 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 669 | 2024.10.21 22:14:54.896816 [ 261 ] {} <Debug> HTTP-Session: 39325abf-f6a2-4534-9080-477491497a96 Authenticating user 'default' from [fd00:1122:3344:101::d]:61400 | ||
| 670 | 2024.10.21 22:14:54.896843 [ 261 ] {} <Debug> HTTP-Session: 39325abf-f6a2-4534-9080-477491497a96 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 671 | 2024.10.21 22:14:54.896862 [ 261 ] {} <Debug> HTTP-Session: 39325abf-f6a2-4534-9080-477491497a96 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 672 | 2024.10.21 22:14:54.896911 [ 261 ] {} <Trace> HTTP-Session: 39325abf-f6a2-4534-9080-477491497a96 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 673 | 2024.10.21 22:14:54.897228 [ 261 ] {f1e876c9-ee97-4bb7-85a7-b5d854af52c5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:61400) 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) | ||
| 674 | 2024.10.21 22:14:54.897308 [ 261 ] {f1e876c9-ee97-4bb7-85a7-b5d854af52c5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 675 | 2024.10.21 22:14:54.899589 [ 261 ] {f1e876c9-ee97-4bb7-85a7-b5d854af52c5} <Debug> oximeter.measurements_histogramu64 (5788c7f8-a000-4b3b-99e1-cfc7b9221a32): Loading data parts | ||
| 676 | 2024.10.21 22:14:54.899797 [ 261 ] {f1e876c9-ee97-4bb7-85a7-b5d854af52c5} <Debug> oximeter.measurements_histogramu64 (5788c7f8-a000-4b3b-99e1-cfc7b9221a32): There are no data parts | ||
| 677 | 2024.10.21 22:14:54.901258 [ 261 ] {f1e876c9-ee97-4bb7-85a7-b5d854af52c5} <Debug> DynamicQueryHandler: Done processing query | ||
| 678 | 2024.10.21 22:14:54.901283 [ 261 ] {} <Debug> HTTP-Session: 39325abf-f6a2-4534-9080-477491497a96 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 679 | 2024.10.21 22:14:54.901443 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:61400, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 680 | 2024.10.21 22:14:54.901802 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:61400, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 681 | 2024.10.21 22:14:54.901890 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 682 | 2024.10.21 22:14:54.901967 [ 261 ] {} <Debug> HTTP-Session: 77813c7f-a0d9-4eef-92ab-30570236b7f9 Authenticating user 'default' from [fd00:1122:3344:101::d]:61400 | ||
| 683 | 2024.10.21 22:14:54.901988 [ 261 ] {} <Debug> HTTP-Session: 77813c7f-a0d9-4eef-92ab-30570236b7f9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 684 | 2024.10.21 22:14:54.902006 [ 261 ] {} <Debug> HTTP-Session: 77813c7f-a0d9-4eef-92ab-30570236b7f9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 685 | 2024.10.21 22:14:54.902059 [ 261 ] {} <Trace> HTTP-Session: 77813c7f-a0d9-4eef-92ab-30570236b7f9 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 686 | 2024.10.21 22:14:54.902320 [ 261 ] {442299f0-03ec-41ef-9eee-632d6e6e8061} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:61400) 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) | ||
| 687 | 2024.10.21 22:14:54.902387 [ 261 ] {442299f0-03ec-41ef-9eee-632d6e6e8061} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 688 | 2024.10.21 22:14:54.904239 [ 261 ] {442299f0-03ec-41ef-9eee-632d6e6e8061} <Debug> oximeter.measurements_histogramf32 (d3f5b49a-a98b-4578-bf62-2b6a9f3f266c): Loading data parts | ||
| 689 | 2024.10.21 22:14:54.904428 [ 261 ] {442299f0-03ec-41ef-9eee-632d6e6e8061} <Debug> oximeter.measurements_histogramf32 (d3f5b49a-a98b-4578-bf62-2b6a9f3f266c): There are no data parts | ||
| 690 | 2024.10.21 22:14:54.905745 [ 261 ] {442299f0-03ec-41ef-9eee-632d6e6e8061} <Debug> DynamicQueryHandler: Done processing query | ||
| 691 | 2024.10.21 22:14:54.905770 [ 261 ] {} <Debug> HTTP-Session: 77813c7f-a0d9-4eef-92ab-30570236b7f9 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 692 | 2024.10.21 22:14:54.905947 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:61400, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 693 | 2024.10.21 22:14:54.906400 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:35581, User-Agent: (none), Length: 848, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 694 | 2024.10.21 22:14:54.906467 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 695 | 2024.10.21 22:14:54.906534 [ 261 ] {} <Debug> HTTP-Session: 82d489ae-5ce2-4f3e-80fb-cc17a6090cea Authenticating user 'default' from [fd00:1122:3344:101::d]:35581 | ||
| 696 | 2024.10.21 22:14:54.906555 [ 261 ] {} <Debug> HTTP-Session: 82d489ae-5ce2-4f3e-80fb-cc17a6090cea Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 697 | 2024.10.21 22:14:54.906575 [ 261 ] {} <Debug> HTTP-Session: 82d489ae-5ce2-4f3e-80fb-cc17a6090cea Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 698 | 2024.10.21 22:14:54.906634 [ 261 ] {} <Trace> HTTP-Session: 82d489ae-5ce2-4f3e-80fb-cc17a6090cea Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 699 | 2024.10.21 22:14:54.906955 [ 261 ] {93e898f9-9998-403c-87c7-09a8abf4457c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35581) 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) | ||
| 700 | 2024.10.21 22:14:54.907038 [ 261 ] {93e898f9-9998-403c-87c7-09a8abf4457c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 701 | 2024.10.21 22:14:54.909148 [ 261 ] {93e898f9-9998-403c-87c7-09a8abf4457c} <Debug> oximeter.measurements_histogramf64 (4f93f2d9-c7d6-4015-9518-30b31389d834): Loading data parts | ||
| 702 | 2024.10.21 22:14:54.909361 [ 261 ] {93e898f9-9998-403c-87c7-09a8abf4457c} <Debug> oximeter.measurements_histogramf64 (4f93f2d9-c7d6-4015-9518-30b31389d834): There are no data parts | ||
| 703 | 2024.10.21 22:14:54.910826 [ 261 ] {93e898f9-9998-403c-87c7-09a8abf4457c} <Debug> DynamicQueryHandler: Done processing query | ||
| 704 | 2024.10.21 22:14:54.910858 [ 261 ] {} <Debug> HTTP-Session: 82d489ae-5ce2-4f3e-80fb-cc17a6090cea Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 705 | 2024.10.21 22:14:54.911003 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:35581, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 706 | 2024.10.21 22:14:54.911430 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:63681, User-Agent: (none), Length: 1762, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 707 | 2024.10.21 22:14:54.911487 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 708 | 2024.10.21 22:14:54.911527 [ 261 ] {} <Debug> HTTP-Session: d89f4b3f-1914-4ecb-bbf4-e3360861214d Authenticating user 'default' from [fd00:1122:3344:101::d]:63681 | ||
| 709 | 2024.10.21 22:14:54.911547 [ 261 ] {} <Debug> HTTP-Session: d89f4b3f-1914-4ecb-bbf4-e3360861214d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 710 | 2024.10.21 22:14:54.911564 [ 261 ] {} <Debug> HTTP-Session: d89f4b3f-1914-4ecb-bbf4-e3360861214d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 711 | 2024.10.21 22:14:54.911614 [ 261 ] {} <Trace> HTTP-Session: d89f4b3f-1914-4ecb-bbf4-e3360861214d Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 712 | 2024.10.21 22:14:54.911843 [ 261 ] {bcbe860b-a7ac-4148-a02c-26958632456e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63681) /* The field tables store named dimensions of each timeseries. | ||
| 713 | * | ||
| 714 | * As with the measurement tables, there is one field table for each field data | ||
| 715 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 716 | * this behavior **must not** be relied upon for query correctness. | ||
| 717 | * | ||
| 718 | * The index for the fields differs from the measurements, however. Rows are | ||
| 719 | * sorted by timeseries name, then field name, field value, and finally | ||
| 720 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 721 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 722 | * usually then used to look up measurements. | ||
| 723 | * | ||
| 724 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 725 | * timeseries name and then key, since it would improve lookups where one | ||
| 726 | * already has the key. Realistically though, these tables are quite small and | ||
| 727 | * so performance benefits will be low in absolute terms. | ||
| 728 | * | ||
| 729 | * TTL: We use a materialized column to expire old field table records. This | ||
| 730 | * column is generated automatically by the database whenever a new row is | ||
| 731 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 732 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 733 | * record will remain during a deduplication, which will have the last | ||
| 734 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 735 | * measurement tables. | ||
| 736 | */ | ||
| 737 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 738 | 2024.10.21 22:14:54.911996 [ 261 ] {bcbe860b-a7ac-4148-a02c-26958632456e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 739 | 2024.10.21 22:14:54.913706 [ 261 ] {bcbe860b-a7ac-4148-a02c-26958632456e} <Debug> oximeter.fields_bool (fb46401c-f401-42b2-86af-6a29fd51e96a): Loading data parts | ||
| 740 | 2024.10.21 22:14:54.913901 [ 261 ] {bcbe860b-a7ac-4148-a02c-26958632456e} <Debug> oximeter.fields_bool (fb46401c-f401-42b2-86af-6a29fd51e96a): There are no data parts | ||
| 741 | 2024.10.21 22:14:54.915082 [ 261 ] {bcbe860b-a7ac-4148-a02c-26958632456e} <Debug> DynamicQueryHandler: Done processing query | ||
| 742 | 2024.10.21 22:14:54.915117 [ 261 ] {} <Debug> HTTP-Session: d89f4b3f-1914-4ecb-bbf4-e3360861214d Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 743 | 2024.10.21 22:14:54.915259 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:63681, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 744 | 2024.10.21 22:14:54.915620 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:64907, User-Agent: (none), Length: 335, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 745 | 2024.10.21 22:14:54.915694 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 746 | 2024.10.21 22:14:54.915715 [ 257 ] {} <Debug> HTTP-Session: 6c46a8be-9234-4a80-a89e-046271077881 Authenticating user 'default' from [fd00:1122:3344:101::d]:64907 | ||
| 747 | 2024.10.21 22:14:54.915733 [ 257 ] {} <Debug> HTTP-Session: 6c46a8be-9234-4a80-a89e-046271077881 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 748 | 2024.10.21 22:14:54.915746 [ 257 ] {} <Debug> HTTP-Session: 6c46a8be-9234-4a80-a89e-046271077881 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 749 | 2024.10.21 22:14:54.915785 [ 257 ] {} <Trace> HTTP-Session: 6c46a8be-9234-4a80-a89e-046271077881 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 750 | 2024.10.21 22:14:54.916008 [ 257 ] {7ef26c90-8879-49d8-97fd-bfa661b24c19} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:64907) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 751 | 2024.10.21 22:14:54.916056 [ 257 ] {7ef26c90-8879-49d8-97fd-bfa661b24c19} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 752 | 2024.10.21 22:14:54.917769 [ 257 ] {7ef26c90-8879-49d8-97fd-bfa661b24c19} <Debug> oximeter.fields_i8 (33241c9e-83d4-40cd-8903-0514d5eede4c): Loading data parts | ||
| 753 | 2024.10.21 22:14:54.917966 [ 257 ] {7ef26c90-8879-49d8-97fd-bfa661b24c19} <Debug> oximeter.fields_i8 (33241c9e-83d4-40cd-8903-0514d5eede4c): There are no data parts | ||
| 754 | 2024.10.21 22:14:54.919316 [ 257 ] {7ef26c90-8879-49d8-97fd-bfa661b24c19} <Debug> DynamicQueryHandler: Done processing query | ||
| 755 | 2024.10.21 22:14:54.919344 [ 257 ] {} <Debug> HTTP-Session: 6c46a8be-9234-4a80-a89e-046271077881 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 756 | 2024.10.21 22:14:54.919507 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:64907, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 757 | 2024.10.21 22:14:54.919768 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:64907, User-Agent: (none), Length: 336, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 758 | 2024.10.21 22:14:54.919829 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 759 | 2024.10.21 22:14:54.919854 [ 257 ] {} <Debug> HTTP-Session: 22b420c8-db76-4518-92ec-3862c837220b Authenticating user 'default' from [fd00:1122:3344:101::d]:64907 | ||
| 760 | 2024.10.21 22:14:54.919875 [ 257 ] {} <Debug> HTTP-Session: 22b420c8-db76-4518-92ec-3862c837220b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 761 | 2024.10.21 22:14:54.919894 [ 257 ] {} <Debug> HTTP-Session: 22b420c8-db76-4518-92ec-3862c837220b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 762 | 2024.10.21 22:14:54.919934 [ 257 ] {} <Trace> HTTP-Session: 22b420c8-db76-4518-92ec-3862c837220b Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 763 | 2024.10.21 22:14:54.920153 [ 257 ] {a4452f9b-1d56-4531-a10a-63971435a839} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:64907) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 764 | 2024.10.21 22:14:54.920204 [ 257 ] {a4452f9b-1d56-4531-a10a-63971435a839} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 765 | 2024.10.21 22:14:54.922310 [ 257 ] {a4452f9b-1d56-4531-a10a-63971435a839} <Debug> oximeter.fields_u8 (fd6b9e80-7627-4296-8df3-152c7a59d958): Loading data parts | ||
| 766 | 2024.10.21 22:14:54.922539 [ 257 ] {a4452f9b-1d56-4531-a10a-63971435a839} <Debug> oximeter.fields_u8 (fd6b9e80-7627-4296-8df3-152c7a59d958): There are no data parts | ||
| 767 | 2024.10.21 22:14:54.923905 [ 257 ] {a4452f9b-1d56-4531-a10a-63971435a839} <Debug> DynamicQueryHandler: Done processing query | ||
| 768 | 2024.10.21 22:14:54.923936 [ 257 ] {} <Debug> HTTP-Session: 22b420c8-db76-4518-92ec-3862c837220b Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 769 | 2024.10.21 22:14:54.924125 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:64907, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 770 | 2024.10.21 22:14:54.924957 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:47672, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 771 | 2024.10.21 22:14:54.925023 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 772 | 2024.10.21 22:14:54.925048 [ 257 ] {} <Debug> HTTP-Session: 4dae9665-6b50-4c1d-84fa-0170b81f1002 Authenticating user 'default' from [fd00:1122:3344:101::d]:47672 | ||
| 773 | 2024.10.21 22:14:54.925069 [ 257 ] {} <Debug> HTTP-Session: 4dae9665-6b50-4c1d-84fa-0170b81f1002 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 774 | 2024.10.21 22:14:54.925088 [ 257 ] {} <Debug> HTTP-Session: 4dae9665-6b50-4c1d-84fa-0170b81f1002 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 775 | 2024.10.21 22:14:54.925126 [ 257 ] {} <Trace> HTTP-Session: 4dae9665-6b50-4c1d-84fa-0170b81f1002 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 776 | 2024.10.21 22:14:54.925345 [ 257 ] {63b0b062-bb41-48ac-98eb-9c63e78e4b5c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47672) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 777 | 2024.10.21 22:14:54.925399 [ 257 ] {63b0b062-bb41-48ac-98eb-9c63e78e4b5c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 778 | 2024.10.21 22:14:54.927476 [ 257 ] {63b0b062-bb41-48ac-98eb-9c63e78e4b5c} <Debug> oximeter.fields_i16 (f82bba94-196a-4764-933c-760340d07f2e): Loading data parts | ||
| 779 | 2024.10.21 22:14:54.927678 [ 257 ] {63b0b062-bb41-48ac-98eb-9c63e78e4b5c} <Debug> oximeter.fields_i16 (f82bba94-196a-4764-933c-760340d07f2e): There are no data parts | ||
| 780 | 2024.10.21 22:14:54.929056 [ 257 ] {63b0b062-bb41-48ac-98eb-9c63e78e4b5c} <Debug> DynamicQueryHandler: Done processing query | ||
| 781 | 2024.10.21 22:14:54.929090 [ 257 ] {} <Debug> HTTP-Session: 4dae9665-6b50-4c1d-84fa-0170b81f1002 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 782 | 2024.10.21 22:14:54.929266 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:47672, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 783 | 2024.10.21 22:14:54.929668 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:57878, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 784 | 2024.10.21 22:14:54.929727 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 785 | 2024.10.21 22:14:54.929747 [ 257 ] {} <Debug> HTTP-Session: 0db7bcb6-aea5-4085-8a22-926ac55a634e Authenticating user 'default' from [fd00:1122:3344:101::d]:57878 | ||
| 786 | 2024.10.21 22:14:54.929764 [ 257 ] {} <Debug> HTTP-Session: 0db7bcb6-aea5-4085-8a22-926ac55a634e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 787 | 2024.10.21 22:14:54.929778 [ 257 ] {} <Debug> HTTP-Session: 0db7bcb6-aea5-4085-8a22-926ac55a634e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 788 | 2024.10.21 22:14:54.929808 [ 257 ] {} <Trace> HTTP-Session: 0db7bcb6-aea5-4085-8a22-926ac55a634e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 789 | 2024.10.21 22:14:54.929986 [ 257 ] {8bed3215-7349-4ec2-b224-30f28144a4b7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57878) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 790 | 2024.10.21 22:14:54.930031 [ 257 ] {8bed3215-7349-4ec2-b224-30f28144a4b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 791 | 2024.10.21 22:14:54.931755 [ 257 ] {8bed3215-7349-4ec2-b224-30f28144a4b7} <Debug> oximeter.fields_u16 (a57e105e-89cc-4064-a6db-f8138212a15d): Loading data parts | ||
| 792 | 2024.10.21 22:14:54.931969 [ 257 ] {8bed3215-7349-4ec2-b224-30f28144a4b7} <Debug> oximeter.fields_u16 (a57e105e-89cc-4064-a6db-f8138212a15d): There are no data parts | ||
| 793 | 2024.10.21 22:14:54.933276 [ 257 ] {8bed3215-7349-4ec2-b224-30f28144a4b7} <Debug> DynamicQueryHandler: Done processing query | ||
| 794 | 2024.10.21 22:14:54.933308 [ 257 ] {} <Debug> HTTP-Session: 0db7bcb6-aea5-4085-8a22-926ac55a634e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 795 | 2024.10.21 22:14:54.933495 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:57878, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 796 | 2024.10.21 22:14:54.933860 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:57817, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 797 | 2024.10.21 22:14:54.933920 [ 257 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 798 | 2024.10.21 22:14:54.933946 [ 257 ] {} <Debug> HTTP-Session: de80d595-0c28-4c2e-9953-08fbc82f97d1 Authenticating user 'default' from [fd00:1122:3344:101::d]:57817 | ||
| 799 | 2024.10.21 22:14:54.933967 [ 257 ] {} <Debug> HTTP-Session: de80d595-0c28-4c2e-9953-08fbc82f97d1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 800 | 2024.10.21 22:14:54.933987 [ 257 ] {} <Debug> HTTP-Session: de80d595-0c28-4c2e-9953-08fbc82f97d1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 801 | 2024.10.21 22:14:54.934025 [ 257 ] {} <Trace> HTTP-Session: de80d595-0c28-4c2e-9953-08fbc82f97d1 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 802 | 2024.10.21 22:14:54.934235 [ 257 ] {40332006-f0e3-459c-a568-c5f521354c12} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57817) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 803 | 2024.10.21 22:14:54.934285 [ 257 ] {40332006-f0e3-459c-a568-c5f521354c12} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 804 | 2024.10.21 22:14:54.936197 [ 257 ] {40332006-f0e3-459c-a568-c5f521354c12} <Debug> oximeter.fields_i32 (c96a67a5-d391-4571-9e6e-1d30b3d78c47): Loading data parts | ||
| 805 | 2024.10.21 22:14:54.936402 [ 257 ] {40332006-f0e3-459c-a568-c5f521354c12} <Debug> oximeter.fields_i32 (c96a67a5-d391-4571-9e6e-1d30b3d78c47): There are no data parts | ||
| 806 | 2024.10.21 22:14:54.938940 [ 257 ] {40332006-f0e3-459c-a568-c5f521354c12} <Debug> DynamicQueryHandler: Done processing query | ||
| 807 | 2024.10.21 22:14:54.938970 [ 257 ] {} <Debug> HTTP-Session: de80d595-0c28-4c2e-9953-08fbc82f97d1 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 808 | 2024.10.21 22:14:54.939146 [ 257 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:57817, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 809 | 2024.10.21 22:14:54.939567 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:57521, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 810 | 2024.10.21 22:14:54.939651 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 811 | 2024.10.21 22:14:54.939679 [ 261 ] {} <Debug> HTTP-Session: 8af0ccdf-a808-45eb-ba7d-5395541683ae Authenticating user 'default' from [fd00:1122:3344:101::d]:57521 | ||
| 812 | 2024.10.21 22:14:54.939703 [ 261 ] {} <Debug> HTTP-Session: 8af0ccdf-a808-45eb-ba7d-5395541683ae Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 813 | 2024.10.21 22:14:54.939722 [ 261 ] {} <Debug> HTTP-Session: 8af0ccdf-a808-45eb-ba7d-5395541683ae Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 814 | 2024.10.21 22:14:54.939771 [ 261 ] {} <Trace> HTTP-Session: 8af0ccdf-a808-45eb-ba7d-5395541683ae Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 815 | 2024.10.21 22:14:54.940039 [ 261 ] {5873408d-f36a-4077-b6d6-507a6727902c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:57521) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 816 | 2024.10.21 22:14:54.940099 [ 261 ] {5873408d-f36a-4077-b6d6-507a6727902c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 817 | 2024.10.21 22:14:54.942082 [ 261 ] {5873408d-f36a-4077-b6d6-507a6727902c} <Debug> oximeter.fields_u32 (bb3dd6a3-bec0-43d9-960a-2f49cbf0f5aa): Loading data parts | ||
| 818 | 2024.10.21 22:14:54.942296 [ 261 ] {5873408d-f36a-4077-b6d6-507a6727902c} <Debug> oximeter.fields_u32 (bb3dd6a3-bec0-43d9-960a-2f49cbf0f5aa): There are no data parts | ||
| 819 | 2024.10.21 22:14:54.943945 [ 261 ] {5873408d-f36a-4077-b6d6-507a6727902c} <Debug> DynamicQueryHandler: Done processing query | ||
| 820 | 2024.10.21 22:14:54.943976 [ 261 ] {} <Debug> HTTP-Session: 8af0ccdf-a808-45eb-ba7d-5395541683ae Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 821 | 2024.10.21 22:14:54.944159 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:57521, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 822 | 2024.10.21 22:14:54.945194 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:55577, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 823 | 2024.10.21 22:14:54.945261 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 824 | 2024.10.21 22:14:54.945286 [ 261 ] {} <Debug> HTTP-Session: 393be6cd-b49c-48c7-897b-7b1f5f3be07f Authenticating user 'default' from [fd00:1122:3344:101::d]:55577 | ||
| 825 | 2024.10.21 22:14:54.945306 [ 261 ] {} <Debug> HTTP-Session: 393be6cd-b49c-48c7-897b-7b1f5f3be07f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 826 | 2024.10.21 22:14:54.945324 [ 261 ] {} <Debug> HTTP-Session: 393be6cd-b49c-48c7-897b-7b1f5f3be07f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 827 | 2024.10.21 22:14:54.945360 [ 261 ] {} <Trace> HTTP-Session: 393be6cd-b49c-48c7-897b-7b1f5f3be07f Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 828 | 2024.10.21 22:14:54.945564 [ 261 ] {5d81c4e1-89f9-4f8e-971f-47fb42c2e009} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:55577) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 829 | 2024.10.21 22:14:54.945614 [ 261 ] {5d81c4e1-89f9-4f8e-971f-47fb42c2e009} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 830 | 2024.10.21 22:14:54.947457 [ 261 ] {5d81c4e1-89f9-4f8e-971f-47fb42c2e009} <Debug> oximeter.fields_i64 (633fa830-3cc4-45d9-8180-64fb7717ed78): Loading data parts | ||
| 831 | 2024.10.21 22:14:54.947645 [ 261 ] {5d81c4e1-89f9-4f8e-971f-47fb42c2e009} <Debug> oximeter.fields_i64 (633fa830-3cc4-45d9-8180-64fb7717ed78): There are no data parts | ||
| 832 | 2024.10.21 22:14:54.949294 [ 261 ] {5d81c4e1-89f9-4f8e-971f-47fb42c2e009} <Debug> DynamicQueryHandler: Done processing query | ||
| 833 | 2024.10.21 22:14:54.949325 [ 261 ] {} <Debug> HTTP-Session: 393be6cd-b49c-48c7-897b-7b1f5f3be07f Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 834 | 2024.10.21 22:14:54.949494 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:55577, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 835 | 2024.10.21 22:14:55.000231 [ 245 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 121.56 MiB, peak 122.56 MiB, free memory in arenas 0.00 B, will set to 134.26 MiB (RSS), difference: 12.70 MiB | ||
| 836 | 2024.10.21 22:14:55.636809 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:55097, User-Agent: (none), Length: 338, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 837 | 2024.10.21 22:14:55.636948 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 838 | 2024.10.21 22:14:55.636978 [ 261 ] {} <Debug> HTTP-Session: ce07b344-d713-4a1c-8398-d52b8d534622 Authenticating user 'default' from [fd00:1122:3344:101::d]:55097 | ||
| 839 | 2024.10.21 22:14:55.637010 [ 261 ] {} <Debug> HTTP-Session: ce07b344-d713-4a1c-8398-d52b8d534622 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 840 | 2024.10.21 22:14:55.637029 [ 261 ] {} <Debug> HTTP-Session: ce07b344-d713-4a1c-8398-d52b8d534622 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 841 | 2024.10.21 22:14:55.637092 [ 261 ] {} <Trace> HTTP-Session: ce07b344-d713-4a1c-8398-d52b8d534622 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 842 | 2024.10.21 22:14:55.637439 [ 261 ] {a61a9b0b-1fed-4875-adb5-0f34216754e2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:55097) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 843 | 2024.10.21 22:14:55.637519 [ 261 ] {a61a9b0b-1fed-4875-adb5-0f34216754e2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 844 | 2024.10.21 22:14:55.643400 [ 261 ] {a61a9b0b-1fed-4875-adb5-0f34216754e2} <Debug> oximeter.fields_u64 (4f38749d-b21c-4f50-bec0-271480603323): Loading data parts | ||
| 845 | 2024.10.21 22:14:55.643739 [ 261 ] {a61a9b0b-1fed-4875-adb5-0f34216754e2} <Debug> oximeter.fields_u64 (4f38749d-b21c-4f50-bec0-271480603323): There are no data parts | ||
| 846 | 2024.10.21 22:14:55.650623 [ 261 ] {a61a9b0b-1fed-4875-adb5-0f34216754e2} <Debug> DynamicQueryHandler: Done processing query | ||
| 847 | 2024.10.21 22:14:55.650662 [ 261 ] {} <Debug> HTTP-Session: ce07b344-d713-4a1c-8398-d52b8d534622 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 848 | 2024.10.21 22:14:55.651428 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:55097, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 849 | 2024.10.21 22:14:56.264894 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49519, User-Agent: (none), Length: 339, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 850 | 2024.10.21 22:14:56.265033 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 851 | 2024.10.21 22:14:56.265063 [ 261 ] {} <Debug> HTTP-Session: 19742112-8e73-40c3-ad65-a052ec232e95 Authenticating user 'default' from [fd00:1122:3344:101::d]:49519 | ||
| 852 | 2024.10.21 22:14:56.265096 [ 261 ] {} <Debug> HTTP-Session: 19742112-8e73-40c3-ad65-a052ec232e95 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 853 | 2024.10.21 22:14:56.265116 [ 261 ] {} <Debug> HTTP-Session: 19742112-8e73-40c3-ad65-a052ec232e95 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 854 | 2024.10.21 22:14:56.265182 [ 261 ] {} <Trace> HTTP-Session: 19742112-8e73-40c3-ad65-a052ec232e95 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 855 | 2024.10.21 22:14:56.265533 [ 261 ] {b0a4ac77-6228-44a3-8911-d4d3d2d41f9d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49519) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 856 | 2024.10.21 22:14:56.265603 [ 261 ] {b0a4ac77-6228-44a3-8911-d4d3d2d41f9d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 857 | 2024.10.21 22:14:56.268521 [ 261 ] {b0a4ac77-6228-44a3-8911-d4d3d2d41f9d} <Debug> oximeter.fields_ipaddr (1588e585-de80-4935-9d16-153f261f7b25): Loading data parts | ||
| 858 | 2024.10.21 22:14:56.268814 [ 261 ] {b0a4ac77-6228-44a3-8911-d4d3d2d41f9d} <Debug> oximeter.fields_ipaddr (1588e585-de80-4935-9d16-153f261f7b25): There are no data parts | ||
| 859 | 2024.10.21 22:14:56.271284 [ 261 ] {b0a4ac77-6228-44a3-8911-d4d3d2d41f9d} <Debug> DynamicQueryHandler: Done processing query | ||
| 860 | 2024.10.21 22:14:56.271316 [ 261 ] {} <Debug> HTTP-Session: 19742112-8e73-40c3-ad65-a052ec232e95 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 861 | 2024.10.21 22:14:56.274366 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:49519, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 862 | 2024.10.21 22:14:56.363161 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:49519, User-Agent: (none), Length: 341, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 863 | 2024.10.21 22:14:56.363240 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 864 | 2024.10.21 22:14:56.363265 [ 261 ] {} <Debug> HTTP-Session: 6c694e7d-72b8-4513-85d0-ae3e7a2ec28e Authenticating user 'default' from [fd00:1122:3344:101::d]:49519 | ||
| 865 | 2024.10.21 22:14:56.363293 [ 261 ] {} <Debug> HTTP-Session: 6c694e7d-72b8-4513-85d0-ae3e7a2ec28e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 866 | 2024.10.21 22:14:56.363313 [ 261 ] {} <Debug> HTTP-Session: 6c694e7d-72b8-4513-85d0-ae3e7a2ec28e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 867 | 2024.10.21 22:14:56.363358 [ 261 ] {} <Trace> HTTP-Session: 6c694e7d-72b8-4513-85d0-ae3e7a2ec28e Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 868 | 2024.10.21 22:14:56.363601 [ 261 ] {0f8047d9-53ed-4a3d-8849-6ea471920a21} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:49519) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 869 | 2024.10.21 22:14:56.363657 [ 261 ] {0f8047d9-53ed-4a3d-8849-6ea471920a21} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 870 | 2024.10.21 22:14:56.372236 [ 261 ] {0f8047d9-53ed-4a3d-8849-6ea471920a21} <Debug> oximeter.fields_string (79233b8d-93a7-4a8b-bdb6-0b783183f6ab): Loading data parts | ||
| 871 | 2024.10.21 22:14:56.372483 [ 261 ] {0f8047d9-53ed-4a3d-8849-6ea471920a21} <Debug> oximeter.fields_string (79233b8d-93a7-4a8b-bdb6-0b783183f6ab): There are no data parts | ||
| 872 | 2024.10.21 22:14:56.381852 [ 261 ] {0f8047d9-53ed-4a3d-8849-6ea471920a21} <Debug> DynamicQueryHandler: Done processing query | ||
| 873 | 2024.10.21 22:14:56.381882 [ 261 ] {} <Debug> HTTP-Session: 6c694e7d-72b8-4513-85d0-ae3e7a2ec28e Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 874 | 2024.10.21 22:14:56.383629 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:49519, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 875 | 2024.10.21 22:14:56.410354 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:43420, User-Agent: (none), Length: 337, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 876 | 2024.10.21 22:14:56.410428 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 877 | 2024.10.21 22:14:56.410455 [ 261 ] {} <Debug> HTTP-Session: e131ea01-58aa-406b-be8e-5523c84e67f3 Authenticating user 'default' from [fd00:1122:3344:101::d]:43420 | ||
| 878 | 2024.10.21 22:14:56.410478 [ 261 ] {} <Debug> HTTP-Session: e131ea01-58aa-406b-be8e-5523c84e67f3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 879 | 2024.10.21 22:14:56.410498 [ 261 ] {} <Debug> HTTP-Session: e131ea01-58aa-406b-be8e-5523c84e67f3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 880 | 2024.10.21 22:14:56.410540 [ 261 ] {} <Trace> HTTP-Session: e131ea01-58aa-406b-be8e-5523c84e67f3 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 881 | 2024.10.21 22:14:56.410774 [ 261 ] {cc1835a0-6b76-41b6-b8b1-648a94a67307} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43420) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 882 | 2024.10.21 22:14:56.410828 [ 261 ] {cc1835a0-6b76-41b6-b8b1-648a94a67307} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 883 | 2024.10.21 22:14:56.415944 [ 261 ] {cc1835a0-6b76-41b6-b8b1-648a94a67307} <Debug> oximeter.fields_uuid (c7a8b067-d7fc-49b6-b173-b784e1aba1d1): Loading data parts | ||
| 884 | 2024.10.21 22:14:56.416193 [ 261 ] {cc1835a0-6b76-41b6-b8b1-648a94a67307} <Debug> oximeter.fields_uuid (c7a8b067-d7fc-49b6-b173-b784e1aba1d1): There are no data parts | ||
| 885 | 2024.10.21 22:14:56.422280 [ 261 ] {cc1835a0-6b76-41b6-b8b1-648a94a67307} <Debug> DynamicQueryHandler: Done processing query | ||
| 886 | 2024.10.21 22:14:56.422314 [ 261 ] {} <Debug> HTTP-Session: e131ea01-58aa-406b-be8e-5523c84e67f3 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 887 | 2024.10.21 22:14:56.423425 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:43420, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 888 | 2024.10.21 22:14:56.448012 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:43420, User-Agent: (none), Length: 1416, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 889 | 2024.10.21 22:14:56.448175 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 890 | 2024.10.21 22:14:56.448210 [ 261 ] {} <Debug> HTTP-Session: 772dd765-fbf6-4c3a-9561-c28605c587a8 Authenticating user 'default' from [fd00:1122:3344:101::d]:43420 | ||
| 891 | 2024.10.21 22:14:56.448235 [ 261 ] {} <Debug> HTTP-Session: 772dd765-fbf6-4c3a-9561-c28605c587a8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 892 | 2024.10.21 22:14:56.448255 [ 261 ] {} <Debug> HTTP-Session: 772dd765-fbf6-4c3a-9561-c28605c587a8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 893 | 2024.10.21 22:14:56.448297 [ 261 ] {} <Trace> HTTP-Session: 772dd765-fbf6-4c3a-9561-c28605c587a8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 894 | 2024.10.21 22:14:56.448607 [ 261 ] {11a2822e-39ae-4c41-ac6c-c2d91d308099} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43420) /* The timeseries schema table stores the extracted schema for the samples | ||
| 895 | * oximeter collects. | ||
| 896 | */ | ||
| 897 | 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) | ||
| 898 | 2024.10.21 22:14:56.448695 [ 261 ] {11a2822e-39ae-4c41-ac6c-c2d91d308099} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 899 | 2024.10.21 22:14:56.455137 [ 261 ] {11a2822e-39ae-4c41-ac6c-c2d91d308099} <Debug> oximeter.timeseries_schema (4510549f-4852-4922-b099-2797b8ef5125): Loading data parts | ||
| 900 | 2024.10.21 22:14:56.455402 [ 261 ] {11a2822e-39ae-4c41-ac6c-c2d91d308099} <Debug> oximeter.timeseries_schema (4510549f-4852-4922-b099-2797b8ef5125): There are no data parts | ||
| 901 | 2024.10.21 22:14:56.461803 [ 261 ] {11a2822e-39ae-4c41-ac6c-c2d91d308099} <Debug> DynamicQueryHandler: Done processing query | ||
| 902 | 2024.10.21 22:14:56.461836 [ 261 ] {} <Debug> HTTP-Session: 772dd765-fbf6-4c3a-9561-c28605c587a8 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 903 | 2024.10.21 22:14:56.462178 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:43420, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 904 | 2024.10.21 22:14:56.597731 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: [fd00:1122:3344:101::d]:59481, User-Agent: (none), Length: 52, Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 905 | 2024.10.21 22:14:56.597806 [ 261 ] {} <Trace> DynamicQueryHandler: Request URI: /?output_format_json_quote_64bit_integers=0&wait_end_of_query=1 | ||
| 906 | 2024.10.21 22:14:56.597834 [ 261 ] {} <Debug> HTTP-Session: aa231d8a-0e80-46ef-83f8-06516d6365c5 Authenticating user 'default' from [fd00:1122:3344:101::d]:59481 | ||
| 907 | 2024.10.21 22:14:56.597889 [ 261 ] {} <Debug> HTTP-Session: aa231d8a-0e80-46ef-83f8-06516d6365c5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 908 | 2024.10.21 22:14:56.597910 [ 261 ] {} <Debug> HTTP-Session: aa231d8a-0e80-46ef-83f8-06516d6365c5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 909 | 2024.10.21 22:14:56.597955 [ 261 ] {} <Trace> HTTP-Session: aa231d8a-0e80-46ef-83f8-06516d6365c5 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 910 | 2024.10.21 22:14:56.598179 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:59481) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 911 | 2024.10.21 22:14:56.600045 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 912 | 2024.10.21 22:14:56.613196 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Trace> oximeter.version (8a488be3-3438-4894-8f57-3148f961fb7e): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 913 | 2024.10.21 22:14:56.613237 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.28 GiB. | ||
| 914 | 2024.10.21 22:14:56.620271 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 915 | 2024.10.21 22:14:56.621782 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Trace> oximeter.version (8a488be3-3438-4894-8f57-3148f961fb7e): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 916 | 2024.10.21 22:14:56.622142 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.024074 sec., 41.538589349505685 rows/sec., 664.62 B/sec. | ||
| 917 | 2024.10.21 22:14:56.622352 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Debug> DynamicQueryHandler: Done processing query | ||
| 918 | 2024.10.21 22:14:56.622380 [ 261 ] {a9e0b515-2d05-4f70-9d87-87ed6d206e8f} <Debug> MemoryTracker: Peak memory usage (for query): 4.19 MiB. | ||
| 919 | 2024.10.21 22:14:56.622402 [ 261 ] {} <Debug> HTTP-Session: aa231d8a-0e80-46ef-83f8-06516d6365c5 Logout, user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 920 | 2024.10.21 22:14:56.622582 [ 261 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: GET, Address: [fd00:1122:3344:101::d]:59481, User-Agent: (none), Content Type: , Transfer Encoding: identity, X-Forwarded-For: (none) | ||
| 921 | 2024.10.21 22:14:57.000224 [ 245 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 134.99 MiB, peak 140.11 MiB, free memory in arenas 0.00 B, will set to 138.24 MiB (RSS), difference: 3.25 MiB | ||