| 1 | [ Jan 15 00:44:41 Enabled. ] | ||
| 2 | [ Jan 15 00:44:41 Rereading configuration. ] | ||
| 3 | [ Jan 15 00:44:42 Rereading configuration. ] | ||
| 4 | [ Jan 15 00:44:45 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 | [ Jan 15 00:44:45 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 | 2025.01.15 00:44:46.429042 [ 1 ] {} <Information> Application: Will watch for the process with pid 25069 | ||
| 29 | 2025.01.15 00:44:46.429601 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 30 | 2025.01.15 00:44:46.910599 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 25069 | ||
| 31 | 2025.01.15 00:44:46.911387 [ 1 ] {} <Information> Application: starting up | ||
| 32 | 2025.01.15 00:44:46.912124 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 33 | 2025.01.15 00:44:47.006316 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
| 34 | 2025.01.15 00:44:47.048196 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 35 | 2025.01.15 00:44:47.048290 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 36 | 2025.01.15 00:44:47.048307 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 37 | 2025.01.15 00:44:47.048384 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
| 38 | 2025.01.15 00:44:47.049051 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 39 | 2025.01.15 00:44:47.050736 [ 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 | 2025.01.15 00:44:47.051584 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 43 | 2025.01.15 00:44:47.052471 [ 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 | 2025.01.15 00:44:47.052523 [ 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 | 2025.01.15 00:44:47.052566 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
| 46 | 2025.01.15 00:44:47.052748 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 47 | 2025.01.15 00:44:47.053697 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 48 | 2025.01.15 00:44:47.059754 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 49 | 2025.01.15 00:44:47.060597 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 50 | 2025.01.15 00:44:47.061963 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 51 | 2025.01.15 00:44:47.062054 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 52 | 2025.01.15 00:44:47.063640 [ 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 | 2025.01.15 00:44:47.064193 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 56 | 2025.01.15 00:44:47.068195 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 57 | 2025.01.15 00:44:47.068888 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml | ||
| 58 | 2025.01.15 00:44:47.070436 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 59 | 2025.01.15 00:44:47.070820 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 60 | 2025.01.15 00:44:47.071289 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 61 | 2025.01.15 00:44:47.071684 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 62 | 2025.01.15 00:44:47.073212 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 63 | 2025.01.15 00:44:47.073244 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 64 | 2025.01.15 00:44:47.073315 [ 127 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 65 | 2025.01.15 00:44:47.073432 [ 127 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 66 | 2025.01.15 00:44:47.104909 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 67 | 2025.01.15 00:44:47.104941 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000175004 sec | ||
| 68 | 2025.01.15 00:44:47.105025 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 69 | 2025.01.15 00:44:47.105069 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 70 | 2025.01.15 00:44:47.106398 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 71 | 2025.01.15 00:44:47.107509 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 72 | 2025.01.15 00:44:47.121073 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 73 | 2025.01.15 00:44:47.121120 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 74 | 2025.01.15 00:44:47.121201 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 75 | 2025.01.15 00:44:47.121215 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 76 | 2025.01.15 00:44:47.121251 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 77 | 2025.01.15 00:44:47.121322 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 78 | 2025.01.15 00:44:47.126037 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 79 | 2025.01.15 00:44:47.126086 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 80 | 2025.01.15 00:44:47.126134 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 81 | 2025.01.15 00:44:47.126342 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 82 | 2025.01.15 00:44:47.126363 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 83 | 2025.01.15 00:44:47.126402 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 84 | 2025.01.15 00:44:47.126482 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 85 | 2025.01.15 00:44:47.126497 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 86 | 2025.01.15 00:44:47.126531 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 87 | 2025.01.15 00:44:47.126671 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 88 | 2025.01.15 00:44:47.155613 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 89 | 2025.01.15 00:44:47.169576 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 90 | 2025.01.15 00:44:47.169849 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000307986 sec | ||
| 91 | 2025.01.15 00:44:47.169878 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 92 | 2025.01.15 00:44:47.169897 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 93 | 2025.01.15 00:44:47.169936 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 94 | 2025.01.15 00:44:47.170261 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
| 95 | 2025.01.15 00:44:47.170404 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 96 | 2025.01.15 00:44:47.170425 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 97 | 2025.01.15 00:44:47.170439 [ 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 | 2025.01.15 00:44:47.170454 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 99 | 2025.01.15 00:44:47.191784 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 100 | 2025.01.15 00:44:47.192005 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.78 MiB, peak 24.78 MiB, free memory in arenas 0.00 B, will set to 117.12 MiB (RSS), difference: 92.35 MiB | ||
| 101 | 2025.01.15 00:44:47.192941 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.472e-05 sec. | ||
| 102 | 2025.01.15 00:44:47.194040 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 103 | 2025.01.15 00:44:47.194126 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 104 | 2025.01.15 00:44:47.194143 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 105 | 2025.01.15 00:44:47.528210 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:36749 | ||
| 106 | 2025.01.15 00:44:47.528534 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2025.01.15 00:44:47.528595 [ 3 ] {} <Debug> TCP-Session: 5ec62e96-571c-4086-8b62-17003337d49e Authenticating user 'default' from [fd00:1122:3344:101::b]:36749 | ||
| 108 | 2025.01.15 00:44:47.528630 [ 3 ] {} <Debug> TCP-Session: 5ec62e96-571c-4086-8b62-17003337d49e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2025.01.15 00:44:47.528709 [ 3 ] {} <Debug> TCP-Session: 5ec62e96-571c-4086-8b62-17003337d49e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2025.01.15 00:44:47.528806 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 111 | 2025.01.15 00:44:47.528832 [ 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 | 2025.01.15 00:44:47.528904 [ 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 | 2025.01.15 00:44:47.531271 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:46667 | ||
| 114 | 2025.01.15 00:44:47.531399 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 115 | 2025.01.15 00:44:47.531438 [ 4 ] {} <Debug> TCP-Session: 2102ce71-a223-4f52-b8e4-ccc184f50744 Authenticating user 'default' from [fd00:1122:3344:101::b]:46667 | ||
| 116 | 2025.01.15 00:44:47.531466 [ 4 ] {} <Debug> TCP-Session: 2102ce71-a223-4f52-b8e4-ccc184f50744 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 117 | 2025.01.15 00:44:47.531562 [ 4 ] {} <Debug> TCP-Session: 2102ce71-a223-4f52-b8e4-ccc184f50744 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 118 | 2025.01.15 00:44:47.532237 [ 253 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:65010 | ||
| 119 | 2025.01.15 00:44:47.532250 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:45232 | ||
| 120 | 2025.01.15 00:44:47.532326 [ 253 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 121 | 2025.01.15 00:44:47.532353 [ 254 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:36389 | ||
| 122 | 2025.01.15 00:44:47.532431 [ 253 ] {} <Debug> TCP-Session: 928d5fb1-3c06-41eb-b66d-dbdfa1821118 Authenticating user 'default' from [fd00:1122:3344:101::b]:65010 | ||
| 123 | 2025.01.15 00:44:47.532453 [ 253 ] {} <Debug> TCP-Session: 928d5fb1-3c06-41eb-b66d-dbdfa1821118 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 124 | 2025.01.15 00:44:47.532650 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 125 | 2025.01.15 00:44:47.532653 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:54799 | ||
| 126 | 2025.01.15 00:44:47.532669 [ 254 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 127 | 2025.01.15 00:44:47.532776 [ 5 ] {} <Debug> TCP-Session: 3af1ee17-327a-4080-bfa1-ca89e1767679 Authenticating user 'default' from [fd00:1122:3344:101::b]:45232 | ||
| 128 | 2025.01.15 00:44:47.532744 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:58586 | ||
| 129 | 2025.01.15 00:44:47.532742 [ 253 ] {} <Debug> TCP-Session: 928d5fb1-3c06-41eb-b66d-dbdfa1821118 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2025.01.15 00:44:47.532917 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:33551 | ||
| 131 | 2025.01.15 00:44:47.532917 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 132 | 2025.01.15 00:44:47.532977 [ 5 ] {} <Debug> TCP-Session: 3af1ee17-327a-4080-bfa1-ca89e1767679 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 133 | 2025.01.15 00:44:47.533186 [ 5 ] {} <Debug> TCP-Session: 3af1ee17-327a-4080-bfa1-ca89e1767679 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 134 | 2025.01.15 00:44:47.533190 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 135 | 2025.01.15 00:44:47.533232 [ 254 ] {} <Debug> TCP-Session: d169fe26-49ee-44bd-81b9-141e294d868a Authenticating user 'default' from [fd00:1122:3344:101::b]:36389 | ||
| 136 | 2025.01.15 00:44:47.533277 [ 255 ] {} <Debug> TCP-Session: d4eadbec-23d8-4c89-b794-de93b143f2ef Authenticating user 'default' from [fd00:1122:3344:101::b]:54799 | ||
| 137 | 2025.01.15 00:44:47.533353 [ 254 ] {} <Debug> TCP-Session: d169fe26-49ee-44bd-81b9-141e294d868a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 138 | 2025.01.15 00:44:47.533284 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 139 | 2025.01.15 00:44:47.533372 [ 256 ] {} <Debug> TCP-Session: 7a7248ae-b084-4305-8cc7-e9dffa993263 Authenticating user 'default' from [fd00:1122:3344:101::b]:58586 | ||
| 140 | 2025.01.15 00:44:47.533390 [ 255 ] {} <Debug> TCP-Session: d4eadbec-23d8-4c89-b794-de93b143f2ef Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 141 | 2025.01.15 00:44:47.533463 [ 257 ] {} <Debug> TCP-Session: 29da694c-1891-408d-bb8c-36c6da3c7946 Authenticating user 'default' from [fd00:1122:3344:101::b]:33551 | ||
| 142 | 2025.01.15 00:44:47.533446 [ 256 ] {} <Debug> TCP-Session: 7a7248ae-b084-4305-8cc7-e9dffa993263 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 143 | 2025.01.15 00:44:47.533427 [ 254 ] {} <Debug> TCP-Session: d169fe26-49ee-44bd-81b9-141e294d868a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 144 | 2025.01.15 00:44:47.533553 [ 257 ] {} <Debug> TCP-Session: 29da694c-1891-408d-bb8c-36c6da3c7946 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 145 | 2025.01.15 00:44:47.533537 [ 256 ] {} <Debug> TCP-Session: 7a7248ae-b084-4305-8cc7-e9dffa993263 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 146 | 2025.01.15 00:44:47.533524 [ 255 ] {} <Debug> TCP-Session: d4eadbec-23d8-4c89-b794-de93b143f2ef Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2025.01.15 00:44:47.533678 [ 257 ] {} <Debug> TCP-Session: 29da694c-1891-408d-bb8c-36c6da3c7946 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 148 | 2025.01.15 00:44:47.697985 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:62525 | ||
| 149 | 2025.01.15 00:44:47.701409 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 150 | 2025.01.15 00:44:47.701505 [ 258 ] {} <Debug> TCP-Session: 7a29499f-f3d0-4bd5-b143-1dc99030ff3c Authenticating user 'default' from [fd00:1122:3344:101::c]:62525 | ||
| 151 | 2025.01.15 00:44:47.701530 [ 258 ] {} <Debug> TCP-Session: 7a29499f-f3d0-4bd5-b143-1dc99030ff3c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 152 | 2025.01.15 00:44:47.701544 [ 258 ] {} <Debug> TCP-Session: 7a29499f-f3d0-4bd5-b143-1dc99030ff3c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 153 | 2025.01.15 00:44:47.701683 [ 258 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 154 | 2025.01.15 00:44:47.701711 [ 258 ] {} <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 | ||
| 155 | 2025.01.15 00:44:47.701827 [ 258 ] {} <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 | ||
| 156 | 2025.01.15 00:44:47.715021 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:50232 | ||
| 157 | 2025.01.15 00:44:47.715283 [ 260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:65396 | ||
| 158 | 2025.01.15 00:44:47.715287 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:56240 | ||
| 159 | 2025.01.15 00:44:47.715331 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 160 | 2025.01.15 00:44:47.715351 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:57359 | ||
| 161 | 2025.01.15 00:44:47.715404 [ 259 ] {} <Debug> TCP-Session: 2592a292-ff31-4d8c-8f9e-205cd2828e97 Authenticating user 'default' from [fd00:1122:3344:101::c]:50232 | ||
| 162 | 2025.01.15 00:44:47.715523 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:63310 | ||
| 163 | 2025.01.15 00:44:47.715847 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 164 | 2025.01.15 00:44:47.715824 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 165 | 2025.01.15 00:44:47.715908 [ 262 ] {} <Debug> TCP-Session: a87c25b5-9d77-420f-b3a4-0ada83a80389 Authenticating user 'default' from [fd00:1122:3344:101::c]:57359 | ||
| 166 | 2025.01.15 00:44:47.715898 [ 259 ] {} <Debug> TCP-Session: 2592a292-ff31-4d8c-8f9e-205cd2828e97 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 167 | 2025.01.15 00:44:47.715872 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 168 | 2025.01.15 00:44:47.715976 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:49766 | ||
| 169 | 2025.01.15 00:44:47.716016 [ 261 ] {} <Debug> TCP-Session: 3465d4ea-91a2-4fbe-b153-c096095546ac Authenticating user 'default' from [fd00:1122:3344:101::c]:56240 | ||
| 170 | 2025.01.15 00:44:47.716040 [ 262 ] {} <Debug> TCP-Session: a87c25b5-9d77-420f-b3a4-0ada83a80389 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 171 | 2025.01.15 00:44:47.716090 [ 263 ] {} <Debug> TCP-Session: ed380cd4-706e-43e8-91a8-eadbde9e2501 Authenticating user 'default' from [fd00:1122:3344:101::c]:63310 | ||
| 172 | 2025.01.15 00:44:47.716007 [ 259 ] {} <Debug> TCP-Session: 2592a292-ff31-4d8c-8f9e-205cd2828e97 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 173 | 2025.01.15 00:44:47.716112 [ 261 ] {} <Debug> TCP-Session: 3465d4ea-91a2-4fbe-b153-c096095546ac Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 174 | 2025.01.15 00:44:47.716148 [ 262 ] {} <Debug> TCP-Session: a87c25b5-9d77-420f-b3a4-0ada83a80389 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 175 | 2025.01.15 00:44:47.715963 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:35182 | ||
| 176 | 2025.01.15 00:44:47.715826 [ 260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 177 | 2025.01.15 00:44:47.716527 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 178 | 2025.01.15 00:44:47.716524 [ 261 ] {} <Debug> TCP-Session: 3465d4ea-91a2-4fbe-b153-c096095546ac Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 179 | 2025.01.15 00:44:47.716526 [ 263 ] {} <Debug> TCP-Session: ed380cd4-706e-43e8-91a8-eadbde9e2501 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 180 | 2025.01.15 00:44:47.716622 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 181 | 2025.01.15 00:44:47.716731 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:44535 | ||
| 182 | 2025.01.15 00:44:47.716772 [ 265 ] {} <Debug> TCP-Session: d4f18d84-1033-4947-9227-91e2ef330070 Authenticating user 'default' from [fd00:1122:3344:101::c]:35182 | ||
| 183 | 2025.01.15 00:44:47.716768 [ 263 ] {} <Debug> TCP-Session: ed380cd4-706e-43e8-91a8-eadbde9e2501 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 184 | 2025.01.15 00:44:47.716668 [ 260 ] {} <Debug> TCP-Session: 91bd3756-9cdd-4081-b3ad-928dcf7106df Authenticating user 'default' from [fd00:1122:3344:101::c]:65396 | ||
| 185 | 2025.01.15 00:44:47.716859 [ 264 ] {} <Debug> TCP-Session: f01d2222-fa5a-4511-a94d-e03371c0cceb Authenticating user 'default' from [fd00:1122:3344:101::c]:49766 | ||
| 186 | 2025.01.15 00:44:47.716956 [ 265 ] {} <Debug> TCP-Session: d4f18d84-1033-4947-9227-91e2ef330070 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 187 | 2025.01.15 00:44:47.717042 [ 265 ] {} <Debug> TCP-Session: d4f18d84-1033-4947-9227-91e2ef330070 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 188 | 2025.01.15 00:44:47.717060 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 189 | 2025.01.15 00:44:47.717082 [ 260 ] {} <Debug> TCP-Session: 91bd3756-9cdd-4081-b3ad-928dcf7106df Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 190 | 2025.01.15 00:44:47.717062 [ 264 ] {} <Debug> TCP-Session: f01d2222-fa5a-4511-a94d-e03371c0cceb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 191 | 2025.01.15 00:44:47.717160 [ 260 ] {} <Debug> TCP-Session: 91bd3756-9cdd-4081-b3ad-928dcf7106df Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 192 | 2025.01.15 00:44:47.717200 [ 266 ] {} <Debug> TCP-Session: 06d7bda5-923e-49b9-81ae-786b1053221f Authenticating user 'default' from [fd00:1122:3344:101::a]:44535 | ||
| 193 | 2025.01.15 00:44:47.717253 [ 264 ] {} <Debug> TCP-Session: f01d2222-fa5a-4511-a94d-e03371c0cceb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 194 | 2025.01.15 00:44:47.717277 [ 266 ] {} <Debug> TCP-Session: 06d7bda5-923e-49b9-81ae-786b1053221f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 195 | 2025.01.15 00:44:47.717393 [ 266 ] {} <Debug> TCP-Session: 06d7bda5-923e-49b9-81ae-786b1053221f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 196 | 2025.01.15 00:44:47.717492 [ 266 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 197 | 2025.01.15 00:44:47.717640 [ 266 ] {} <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 | ||
| 198 | 2025.01.15 00:44:47.717660 [ 266 ] {} <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 | ||
| 199 | 2025.01.15 00:44:47.720062 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:47839 | ||
| 200 | 2025.01.15 00:44:47.720239 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:61278 | ||
| 201 | 2025.01.15 00:44:47.720247 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 202 | 2025.01.15 00:44:47.720333 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:35484 | ||
| 203 | 2025.01.15 00:44:47.720472 [ 267 ] {} <Debug> TCP-Session: fe6d9d24-2dbd-45c6-8987-f622caf7c4db Authenticating user 'default' from [fd00:1122:3344:101::a]:47839 | ||
| 204 | 2025.01.15 00:44:47.720541 [ 270 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:53094 | ||
| 205 | 2025.01.15 00:44:47.720570 [ 267 ] {} <Debug> TCP-Session: fe6d9d24-2dbd-45c6-8987-f622caf7c4db Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 206 | 2025.01.15 00:44:47.720552 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 207 | 2025.01.15 00:44:47.720656 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 208 | 2025.01.15 00:44:47.720723 [ 269 ] {} <Debug> TCP-Session: c8217782-66c5-40d2-ba59-439ddb56cc0c Authenticating user 'default' from [fd00:1122:3344:101::a]:35484 | ||
| 209 | 2025.01.15 00:44:47.720701 [ 267 ] {} <Debug> TCP-Session: fe6d9d24-2dbd-45c6-8987-f622caf7c4db Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 210 | 2025.01.15 00:44:47.720668 [ 271 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:56063 | ||
| 211 | 2025.01.15 00:44:47.720965 [ 268 ] {} <Debug> TCP-Session: f6201a97-eda3-4c2f-bdfc-8cbfec5f9fe0 Authenticating user 'default' from [fd00:1122:3344:101::a]:61278 | ||
| 212 | 2025.01.15 00:44:47.721073 [ 273 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:46059 | ||
| 213 | 2025.01.15 00:44:47.721106 [ 272 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:37263 | ||
| 214 | 2025.01.15 00:44:47.721113 [ 270 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 215 | 2025.01.15 00:44:47.721180 [ 269 ] {} <Debug> TCP-Session: c8217782-66c5-40d2-ba59-439ddb56cc0c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 216 | 2025.01.15 00:44:47.721132 [ 271 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 217 | 2025.01.15 00:44:47.721194 [ 268 ] {} <Debug> TCP-Session: f6201a97-eda3-4c2f-bdfc-8cbfec5f9fe0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 218 | 2025.01.15 00:44:47.721500 [ 272 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 219 | 2025.01.15 00:44:47.721562 [ 271 ] {} <Debug> TCP-Session: 7c6e443a-d965-43c9-9f01-c40c17944673 Authenticating user 'default' from [fd00:1122:3344:101::a]:56063 | ||
| 220 | 2025.01.15 00:44:47.721530 [ 269 ] {} <Debug> TCP-Session: c8217782-66c5-40d2-ba59-439ddb56cc0c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 221 | 2025.01.15 00:44:47.721530 [ 273 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 222 | 2025.01.15 00:44:47.721502 [ 268 ] {} <Debug> TCP-Session: f6201a97-eda3-4c2f-bdfc-8cbfec5f9fe0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 223 | 2025.01.15 00:44:47.721651 [ 272 ] {} <Debug> TCP-Session: f1f5e38d-1279-4d94-b368-199cc671208c Authenticating user 'default' from [fd00:1122:3344:101::a]:37263 | ||
| 224 | 2025.01.15 00:44:47.721547 [ 270 ] {} <Debug> TCP-Session: b85d1d99-b1f2-4d36-b4bb-325febda912f Authenticating user 'default' from [fd00:1122:3344:101::a]:53094 | ||
| 225 | 2025.01.15 00:44:47.721723 [ 271 ] {} <Debug> TCP-Session: 7c6e443a-d965-43c9-9f01-c40c17944673 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 226 | 2025.01.15 00:44:47.721827 [ 272 ] {} <Debug> TCP-Session: f1f5e38d-1279-4d94-b368-199cc671208c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 227 | 2025.01.15 00:44:47.721760 [ 273 ] {} <Debug> TCP-Session: 10fc880e-cd69-4842-908e-ad0895b87ddd Authenticating user 'default' from [fd00:1122:3344:101::a]:46059 | ||
| 228 | 2025.01.15 00:44:47.721896 [ 272 ] {} <Debug> TCP-Session: f1f5e38d-1279-4d94-b368-199cc671208c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 229 | 2025.01.15 00:44:47.721917 [ 270 ] {} <Debug> TCP-Session: b85d1d99-b1f2-4d36-b4bb-325febda912f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 230 | 2025.01.15 00:44:47.721885 [ 271 ] {} <Debug> TCP-Session: 7c6e443a-d965-43c9-9f01-c40c17944673 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 231 | 2025.01.15 00:44:47.722042 [ 273 ] {} <Debug> TCP-Session: 10fc880e-cd69-4842-908e-ad0895b87ddd Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 232 | 2025.01.15 00:44:47.722067 [ 270 ] {} <Debug> TCP-Session: b85d1d99-b1f2-4d36-b4bb-325febda912f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 233 | 2025.01.15 00:44:47.722220 [ 273 ] {} <Debug> TCP-Session: 10fc880e-cd69-4842-908e-ad0895b87ddd Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 234 | 2025.01.15 00:44:47.891586 [ 274 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:63195 | ||
| 235 | 2025.01.15 00:44:47.891781 [ 274 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 236 | 2025.01.15 00:44:47.891811 [ 274 ] {} <Debug> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Authenticating user 'default' from [fd00:1122:3344:101::d]:63195 | ||
| 237 | 2025.01.15 00:44:47.891889 [ 274 ] {} <Debug> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 238 | 2025.01.15 00:44:47.891943 [ 274 ] {} <Debug> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 239 | 2025.01.15 00:44:47.892017 [ 274 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 240 | 2025.01.15 00:44:47.892043 [ 274 ] {} <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 | ||
| 241 | 2025.01.15 00:44:47.892133 [ 274 ] {} <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 | ||
| 242 | 2025.01.15 00:44:47.892849 [ 276 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:49616 | ||
| 243 | 2025.01.15 00:44:47.892995 [ 277 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:49573 | ||
| 244 | 2025.01.15 00:44:47.892991 [ 275 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:51713 | ||
| 245 | 2025.01.15 00:44:47.893066 [ 278 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:64583 | ||
| 246 | 2025.01.15 00:44:47.893068 [ 276 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 247 | 2025.01.15 00:44:47.893197 [ 277 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 248 | 2025.01.15 00:44:47.893565 [ 278 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 249 | 2025.01.15 00:44:47.893473 [ 279 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:35244 | ||
| 250 | 2025.01.15 00:44:47.893610 [ 277 ] {} <Debug> TCP-Session: 44607c39-5fa9-4077-bea5-1f99dd973fce Authenticating user 'default' from [fd00:1122:3344:101::d]:49573 | ||
| 251 | 2025.01.15 00:44:47.893619 [ 276 ] {} <Debug> TCP-Session: 07324e34-ac9d-4dfd-a0d6-be1ea023a8e2 Authenticating user 'default' from [fd00:1122:3344:101::d]:49616 | ||
| 252 | 2025.01.15 00:44:47.893771 [ 282 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:56930 | ||
| 253 | 2025.01.15 00:44:47.893785 [ 281 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:38568 | ||
| 254 | 2025.01.15 00:44:47.893739 [ 277 ] {} <Debug> TCP-Session: 44607c39-5fa9-4077-bea5-1f99dd973fce Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 255 | 2025.01.15 00:44:47.893728 [ 278 ] {} <Debug> TCP-Session: 76e2cadb-9c96-47f3-ae33-67b8ef5789d7 Authenticating user 'default' from [fd00:1122:3344:101::d]:64583 | ||
| 256 | 2025.01.15 00:44:47.893602 [ 280 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:51060 | ||
| 257 | 2025.01.15 00:44:47.893569 [ 275 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 258 | 2025.01.15 00:44:47.894026 [ 279 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 259 | 2025.01.15 00:44:47.894023 [ 277 ] {} <Debug> TCP-Session: 44607c39-5fa9-4077-bea5-1f99dd973fce Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 260 | 2025.01.15 00:44:47.894425 [ 282 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 261 | 2025.01.15 00:44:47.894437 [ 275 ] {} <Debug> TCP-Session: 5035cbf8-563a-4896-87a9-3ef03dca1100 Authenticating user 'default' from [fd00:1122:3344:101::d]:51713 | ||
| 262 | 2025.01.15 00:44:47.894456 [ 279 ] {} <Debug> TCP-Session: 7796782a-cf94-420f-99b1-9a4d03020f1b Authenticating user 'default' from [fd00:1122:3344:101::d]:35244 | ||
| 263 | 2025.01.15 00:44:47.894475 [ 281 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 264 | 2025.01.15 00:44:47.894736 [ 282 ] {} <Debug> TCP-Session: 46f2bb18-03e0-422e-b6e4-22d8e3eb283e Authenticating user 'default' from [fd00:1122:3344:101::d]:56930 | ||
| 265 | 2025.01.15 00:44:47.894762 [ 281 ] {} <Debug> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Authenticating user 'default' from [fd00:1122:3344:101::d]:38568 | ||
| 266 | 2025.01.15 00:44:47.894813 [ 275 ] {} <Debug> TCP-Session: 5035cbf8-563a-4896-87a9-3ef03dca1100 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 267 | 2025.01.15 00:44:47.894780 [ 276 ] {} <Debug> TCP-Session: 07324e34-ac9d-4dfd-a0d6-be1ea023a8e2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 268 | 2025.01.15 00:44:47.894843 [ 282 ] {} <Debug> TCP-Session: 46f2bb18-03e0-422e-b6e4-22d8e3eb283e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2025.01.15 00:44:47.894837 [ 279 ] {} <Debug> TCP-Session: 7796782a-cf94-420f-99b1-9a4d03020f1b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2025.01.15 00:44:47.894918 [ 275 ] {} <Debug> TCP-Session: 5035cbf8-563a-4896-87a9-3ef03dca1100 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2025.01.15 00:44:47.894755 [ 280 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 272 | 2025.01.15 00:44:47.895002 [ 276 ] {} <Debug> TCP-Session: 07324e34-ac9d-4dfd-a0d6-be1ea023a8e2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2025.01.15 00:44:47.894964 [ 282 ] {} <Debug> TCP-Session: 46f2bb18-03e0-422e-b6e4-22d8e3eb283e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 274 | 2025.01.15 00:44:47.895024 [ 279 ] {} <Debug> TCP-Session: 7796782a-cf94-420f-99b1-9a4d03020f1b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2025.01.15 00:44:47.895045 [ 280 ] {} <Debug> TCP-Session: 7ba4b4aa-bbd7-4673-9ec4-36e83fda20de Authenticating user 'default' from [fd00:1122:3344:101::d]:51060 | ||
| 276 | 2025.01.15 00:44:47.894956 [ 281 ] {} <Debug> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2025.01.15 00:44:47.894738 [ 278 ] {} <Debug> TCP-Session: 76e2cadb-9c96-47f3-ae33-67b8ef5789d7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 278 | 2025.01.15 00:44:47.895401 [ 278 ] {} <Debug> TCP-Session: 76e2cadb-9c96-47f3-ae33-67b8ef5789d7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2025.01.15 00:44:47.895388 [ 281 ] {} <Debug> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 280 | 2025.01.15 00:44:47.895594 [ 280 ] {} <Debug> TCP-Session: 7ba4b4aa-bbd7-4673-9ec4-36e83fda20de Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 281 | 2025.01.15 00:44:47.896249 [ 280 ] {} <Debug> TCP-Session: 7ba4b4aa-bbd7-4673-9ec4-36e83fda20de Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2025.01.15 00:44:47.896415 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 283 | 2025.01.15 00:44:47.899961 [ 274 ] {80a82035-6156-4087-b1e5-dbd8718f2cbc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 284 | 2025.01.15 00:44:47.958396 [ 283 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:42203 | ||
| 285 | 2025.01.15 00:44:47.958396 [ 274 ] {80a82035-6156-4087-b1e5-dbd8718f2cbc} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:63195) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 286 | |||
| 287 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 288 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 289 | 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 | ||
| 290 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 291 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 292 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 293 | 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 | ||
| 294 | 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 | ||
| 295 | 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 | ||
| 296 | 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 | ||
| 297 | 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 | ||
| 298 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 299 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 300 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
| 301 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 302 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 303 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 304 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 305 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 306 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 307 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 308 | |||
| 309 | 2025.01.15 00:44:47.958580 [ 283 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 310 | 2025.01.15 00:44:47.958660 [ 283 ] {} <Debug> TCP-Session: 7fa938f7-e367-4a0b-a3a3-9c2d981fd4f0 Authenticating user 'default' from [fd00:1122:3344:101::e]:42203 | ||
| 311 | 2025.01.15 00:44:47.958796 [ 283 ] {} <Debug> TCP-Session: 7fa938f7-e367-4a0b-a3a3-9c2d981fd4f0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 312 | 2025.01.15 00:44:47.958811 [ 283 ] {} <Debug> TCP-Session: 7fa938f7-e367-4a0b-a3a3-9c2d981fd4f0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 313 | 2025.01.15 00:44:47.958945 [ 283 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 314 | 2025.01.15 00:44:47.958972 [ 283 ] {} <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 | ||
| 315 | 2025.01.15 00:44:47.959059 [ 283 ] {} <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 | ||
| 316 | 2025.01.15 00:44:47.959963 [ 284 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:33302 | ||
| 317 | 2025.01.15 00:44:47.960049 [ 274 ] {80a82035-6156-4087-b1e5-dbd8718f2cbc} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 318 | |||
| 319 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 320 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 321 | 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 | ||
| 322 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 323 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 324 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 325 | 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 | ||
| 326 | 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 | ||
| 327 | 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 | ||
| 328 | 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 | ||
| 329 | 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 | ||
| 330 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 331 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 332 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
| 333 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 334 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 335 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 336 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 337 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 338 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 339 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 340 | |||
| 341 | 2025.01.15 00:44:47.960077 [ 285 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:37963 | ||
| 342 | 2025.01.15 00:44:47.960241 [ 286 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:63807 | ||
| 343 | 2025.01.15 00:44:47.960260 [ 284 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 344 | 2025.01.15 00:44:47.960709 [ 285 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 345 | 2025.01.15 00:44:47.960779 [ 288 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:60423 | ||
| 346 | 2025.01.15 00:44:47.960624 [ 287 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:51854 | ||
| 347 | 2025.01.15 00:44:47.960748 [ 284 ] {} <Debug> TCP-Session: 12b2f295-5293-40d7-9eb2-1dc6019dd6c0 Authenticating user 'default' from [fd00:1122:3344:101::e]:33302 | ||
| 348 | 2025.01.15 00:44:47.960868 [ 289 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:45631 | ||
| 349 | 2025.01.15 00:44:47.960873 [ 285 ] {} <Debug> TCP-Session: 1b3243be-7040-4dca-9438-e1ce9c166023 Authenticating user 'default' from [fd00:1122:3344:101::e]:37963 | ||
| 350 | 2025.01.15 00:44:47.960770 [ 286 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 351 | 2025.01.15 00:44:47.960452 [ 274 ] {80a82035-6156-4087-b1e5-dbd8718f2cbc} <Debug> TCPHandler: Processed in 0.066559191 sec. | ||
| 352 | 2025.01.15 00:44:47.961301 [ 288 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 353 | 2025.01.15 00:44:47.961355 [ 284 ] {} <Debug> TCP-Session: 12b2f295-5293-40d7-9eb2-1dc6019dd6c0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 354 | 2025.01.15 00:44:47.961378 [ 287 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 355 | 2025.01.15 00:44:47.961422 [ 285 ] {} <Debug> TCP-Session: 1b3243be-7040-4dca-9438-e1ce9c166023 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 356 | 2025.01.15 00:44:47.961481 [ 288 ] {} <Debug> TCP-Session: 3ab6481b-29a7-4c1a-8cc8-68c5d7d091be Authenticating user 'default' from [fd00:1122:3344:101::e]:60423 | ||
| 357 | 2025.01.15 00:44:47.961511 [ 284 ] {} <Debug> TCP-Session: 12b2f295-5293-40d7-9eb2-1dc6019dd6c0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 358 | 2025.01.15 00:44:47.961564 [ 286 ] {} <Debug> TCP-Session: 1eed6214-621f-446b-9d60-221e6d5bfdfa Authenticating user 'default' from [fd00:1122:3344:101::e]:63807 | ||
| 359 | 2025.01.15 00:44:47.961603 [ 287 ] {} <Debug> TCP-Session: 0b9f5906-7528-45cb-a823-29b44474f8c4 Authenticating user 'default' from [fd00:1122:3344:101::e]:51854 | ||
| 360 | 2025.01.15 00:44:47.961571 [ 290 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:50795 | ||
| 361 | 2025.01.15 00:44:47.961676 [ 289 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 362 | 2025.01.15 00:44:47.961776 [ 287 ] {} <Debug> TCP-Session: 0b9f5906-7528-45cb-a823-29b44474f8c4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 363 | 2025.01.15 00:44:47.961760 [ 286 ] {} <Debug> TCP-Session: 1eed6214-621f-446b-9d60-221e6d5bfdfa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 364 | 2025.01.15 00:44:47.961733 [ 288 ] {} <Debug> TCP-Session: 3ab6481b-29a7-4c1a-8cc8-68c5d7d091be Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 365 | 2025.01.15 00:44:47.961701 [ 285 ] {} <Debug> TCP-Session: 1b3243be-7040-4dca-9438-e1ce9c166023 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 366 | 2025.01.15 00:44:47.961572 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 367 | 2025.01.15 00:44:47.961973 [ 287 ] {} <Debug> TCP-Session: 0b9f5906-7528-45cb-a823-29b44474f8c4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 368 | 2025.01.15 00:44:47.962040 [ 289 ] {} <Debug> TCP-Session: 82a140e3-6ff1-4c9f-a66e-f7bd1deae1d0 Authenticating user 'default' from [fd00:1122:3344:101::e]:45631 | ||
| 369 | 2025.01.15 00:44:47.962074 [ 288 ] {} <Debug> TCP-Session: 3ab6481b-29a7-4c1a-8cc8-68c5d7d091be Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 370 | 2025.01.15 00:44:47.961969 [ 290 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 371 | 2025.01.15 00:44:47.962014 [ 286 ] {} <Debug> TCP-Session: 1eed6214-621f-446b-9d60-221e6d5bfdfa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 372 | 2025.01.15 00:44:47.962402 [ 290 ] {} <Debug> TCP-Session: f5300f96-46e6-49bc-83ce-c237e628ae78 Authenticating user 'default' from [fd00:1122:3344:101::e]:50795 | ||
| 373 | 2025.01.15 00:44:47.962445 [ 289 ] {} <Debug> TCP-Session: 82a140e3-6ff1-4c9f-a66e-f7bd1deae1d0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 374 | 2025.01.15 00:44:47.962505 [ 281 ] {46d75e33-b468-4bc5-b2b9-39a45bd26448} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 375 | 2025.01.15 00:44:47.962468 [ 290 ] {} <Debug> TCP-Session: f5300f96-46e6-49bc-83ce-c237e628ae78 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 376 | 2025.01.15 00:44:47.962582 [ 289 ] {} <Debug> TCP-Session: 82a140e3-6ff1-4c9f-a66e-f7bd1deae1d0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 377 | 2025.01.15 00:44:47.962595 [ 290 ] {} <Debug> TCP-Session: f5300f96-46e6-49bc-83ce-c237e628ae78 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 378 | 2025.01.15 00:44:47.963100 [ 281 ] {46d75e33-b468-4bc5-b2b9-39a45bd26448} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:38568) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 379 | |||
| 380 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 381 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 382 | 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 | ||
| 383 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 384 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 385 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 386 | 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 | ||
| 387 | 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 | ||
| 388 | 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 | ||
| 389 | 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 | ||
| 390 | 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 | ||
| 391 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 392 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 393 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
| 394 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 395 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 396 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 397 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 398 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 399 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 400 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 401 | |||
| 402 | 2025.01.15 00:44:47.963408 [ 281 ] {46d75e33-b468-4bc5-b2b9-39a45bd26448} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 403 | |||
| 404 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 405 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 406 | 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 | ||
| 407 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 408 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 409 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 410 | 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 | ||
| 411 | 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 | ||
| 412 | 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 | ||
| 413 | 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 | ||
| 414 | 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 | ||
| 415 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 416 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 417 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
| 418 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 419 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 420 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 421 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 422 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 423 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 424 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 425 | |||
| 426 | 2025.01.15 00:44:47.963715 [ 281 ] {46d75e33-b468-4bc5-b2b9-39a45bd26448} <Debug> TCPHandler: Processed in 0.003087969 sec. | ||
| 427 | 2025.01.15 00:44:47.966445 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 428 | 2025.01.15 00:44:47.967777 [ 274 ] {92cb1fa7-806b-4649-bad8-5ad0a36ebd04} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 429 | 2025.01.15 00:44:47.968462 [ 274 ] {92cb1fa7-806b-4649-bad8-5ad0a36ebd04} <Debug> TCPHandler: Processed in 0.002069469 sec. | ||
| 430 | 2025.01.15 00:44:47.968745 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 431 | 2025.01.15 00:44:47.968847 [ 281 ] {b4105498-fb10-4e3b-9b87-60d4dc108f5a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 432 | 2025.01.15 00:44:47.968992 [ 281 ] {b4105498-fb10-4e3b-9b87-60d4dc108f5a} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 433 | 2025.01.15 00:44:47.984974 [ 281 ] {b4105498-fb10-4e3b-9b87-60d4dc108f5a} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 434 | 2025.01.15 00:44:47.984998 [ 281 ] {b4105498-fb10-4e3b-9b87-60d4dc108f5a} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 6.4851e-05 sec | ||
| 435 | 2025.01.15 00:44:47.985066 [ 281 ] {b4105498-fb10-4e3b-9b87-60d4dc108f5a} <Trace> ReferentialDeps: No tables | ||
| 436 | 2025.01.15 00:44:47.985121 [ 281 ] {b4105498-fb10-4e3b-9b87-60d4dc108f5a} <Trace> LoadingDeps: No tables | ||
| 437 | 2025.01.15 00:44:47.985147 [ 281 ] {b4105498-fb10-4e3b-9b87-60d4dc108f5a} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 438 | 2025.01.15 00:44:47.985203 [ 281 ] {b4105498-fb10-4e3b-9b87-60d4dc108f5a} <Debug> TCPHandler: Processed in 0.016511977 sec. | ||
| 439 | 2025.01.15 00:44:47.985411 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 440 | 2025.01.15 00:44:47.985699 [ 274 ] {652b2b9c-e10f-4c77-839b-fdd9003aae0c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) /* The version table contains metadata about the `oximeter` database */ | ||
| 441 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 442 | 2025.01.15 00:44:47.985848 [ 274 ] {652b2b9c-e10f-4c77-839b-fdd9003aae0c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 443 | 2025.01.15 00:44:47.993781 [ 274 ] {652b2b9c-e10f-4c77-839b-fdd9003aae0c} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 444 | 2025.01.15 00:44:47.997889 [ 274 ] {652b2b9c-e10f-4c77-839b-fdd9003aae0c} <Debug> oximeter.version (d5141d5d-8f47-4ad9-b48b-c2a188ef065d): Loading data parts | ||
| 445 | 2025.01.15 00:44:47.998457 [ 274 ] {652b2b9c-e10f-4c77-839b-fdd9003aae0c} <Debug> oximeter.version (d5141d5d-8f47-4ad9-b48b-c2a188ef065d): There are no data parts | ||
| 446 | 2025.01.15 00:44:48.000159 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 121.50 MiB, peak 121.50 MiB, free memory in arenas 0.00 B, will set to 133.49 MiB (RSS), difference: 11.99 MiB | ||
| 447 | 2025.01.15 00:44:48.012099 [ 274 ] {652b2b9c-e10f-4c77-839b-fdd9003aae0c} <Debug> TCPHandler: Processed in 0.026752755 sec. | ||
| 448 | 2025.01.15 00:44:48.012362 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 449 | 2025.01.15 00:44:48.012660 [ 281 ] {972873bf-b332-4f72-8e71-7ee787079cd2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) /* The measurement tables contain all individual samples from each timeseries. | ||
| 450 | * | ||
| 451 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 452 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 453 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 454 | * by all samples from the same timeseries. | ||
| 455 | * | ||
| 456 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 457 | * and then uses that to index quickly into the measurements tables. | ||
| 458 | */ | ||
| 459 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Bool) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 460 | 2025.01.15 00:44:48.012800 [ 281 ] {972873bf-b332-4f72-8e71-7ee787079cd2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 461 | 2025.01.15 00:44:48.023331 [ 281 ] {972873bf-b332-4f72-8e71-7ee787079cd2} <Debug> oximeter.measurements_bool (9efc6f58-d5d6-4b94-8bf2-98ad8700721f): Loading data parts | ||
| 462 | 2025.01.15 00:44:48.023606 [ 281 ] {972873bf-b332-4f72-8e71-7ee787079cd2} <Debug> oximeter.measurements_bool (9efc6f58-d5d6-4b94-8bf2-98ad8700721f): There are no data parts | ||
| 463 | 2025.01.15 00:44:48.033584 [ 281 ] {972873bf-b332-4f72-8e71-7ee787079cd2} <Debug> TCPHandler: Processed in 0.02128363 sec. | ||
| 464 | 2025.01.15 00:44:48.033792 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 465 | 2025.01.15 00:44:48.033995 [ 274 ] {b23c92bf-f7b5-437c-9520-ee91766af3ce} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 466 | 2025.01.15 00:44:48.034131 [ 274 ] {b23c92bf-f7b5-437c-9520-ee91766af3ce} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 467 | 2025.01.15 00:44:48.040056 [ 274 ] {b23c92bf-f7b5-437c-9520-ee91766af3ce} <Debug> oximeter.measurements_i8 (d010818b-ad7d-4b3f-a1fa-fd6212967b84): Loading data parts | ||
| 468 | 2025.01.15 00:44:48.040304 [ 274 ] {b23c92bf-f7b5-437c-9520-ee91766af3ce} <Debug> oximeter.measurements_i8 (d010818b-ad7d-4b3f-a1fa-fd6212967b84): There are no data parts | ||
| 469 | 2025.01.15 00:44:48.046387 [ 274 ] {b23c92bf-f7b5-437c-9520-ee91766af3ce} <Debug> TCPHandler: Processed in 0.012654693 sec. | ||
| 470 | 2025.01.15 00:44:48.046594 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 471 | 2025.01.15 00:44:48.046881 [ 281 ] {98cb455b-1cf8-43e3-ba68-da3d8d50981b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 472 | 2025.01.15 00:44:48.047004 [ 281 ] {98cb455b-1cf8-43e3-ba68-da3d8d50981b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 473 | 2025.01.15 00:44:48.050495 [ 281 ] {98cb455b-1cf8-43e3-ba68-da3d8d50981b} <Debug> oximeter.measurements_u8 (8d538454-76cd-43c1-a15b-157b67772cd1): Loading data parts | ||
| 474 | 2025.01.15 00:44:48.050658 [ 281 ] {98cb455b-1cf8-43e3-ba68-da3d8d50981b} <Debug> oximeter.measurements_u8 (8d538454-76cd-43c1-a15b-157b67772cd1): There are no data parts | ||
| 475 | 2025.01.15 00:44:48.058083 [ 281 ] {98cb455b-1cf8-43e3-ba68-da3d8d50981b} <Debug> TCPHandler: Processed in 0.011543722 sec. | ||
| 476 | 2025.01.15 00:44:48.058279 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 477 | 2025.01.15 00:44:48.058505 [ 274 ] {2dafaf38-b0d9-4201-a44c-c4b92eb80775} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 478 | 2025.01.15 00:44:48.058646 [ 274 ] {2dafaf38-b0d9-4201-a44c-c4b92eb80775} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 479 | 2025.01.15 00:44:48.064715 [ 274 ] {2dafaf38-b0d9-4201-a44c-c4b92eb80775} <Debug> oximeter.measurements_i16 (aaec7c5f-0c4a-4e7a-a7e0-638066b660fb): Loading data parts | ||
| 480 | 2025.01.15 00:44:48.064941 [ 274 ] {2dafaf38-b0d9-4201-a44c-c4b92eb80775} <Debug> oximeter.measurements_i16 (aaec7c5f-0c4a-4e7a-a7e0-638066b660fb): There are no data parts | ||
| 481 | 2025.01.15 00:44:48.071408 [ 274 ] {2dafaf38-b0d9-4201-a44c-c4b92eb80775} <Debug> TCPHandler: Processed in 0.013181793 sec. | ||
| 482 | 2025.01.15 00:44:48.071597 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 483 | 2025.01.15 00:44:48.071886 [ 281 ] {96980429-b2ef-4980-ac48-8f31a8e41f35} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 484 | 2025.01.15 00:44:48.072011 [ 281 ] {96980429-b2ef-4980-ac48-8f31a8e41f35} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 485 | 2025.01.15 00:44:48.075698 [ 281 ] {96980429-b2ef-4980-ac48-8f31a8e41f35} <Debug> oximeter.measurements_u16 (68c35831-de2f-4b70-a373-759198843c11): Loading data parts | ||
| 486 | 2025.01.15 00:44:48.075872 [ 281 ] {96980429-b2ef-4980-ac48-8f31a8e41f35} <Debug> oximeter.measurements_u16 (68c35831-de2f-4b70-a373-759198843c11): There are no data parts | ||
| 487 | 2025.01.15 00:44:48.082632 [ 281 ] {96980429-b2ef-4980-ac48-8f31a8e41f35} <Debug> TCPHandler: Processed in 0.011088343 sec. | ||
| 488 | 2025.01.15 00:44:48.082837 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 489 | 2025.01.15 00:44:48.083030 [ 274 ] {9bbe8850-644f-4461-8775-9599a63122c4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 490 | 2025.01.15 00:44:48.083165 [ 274 ] {9bbe8850-644f-4461-8775-9599a63122c4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 491 | 2025.01.15 00:44:48.088859 [ 274 ] {9bbe8850-644f-4461-8775-9599a63122c4} <Debug> oximeter.measurements_i32 (07b40565-dc5e-4625-b41d-176f735fe06a): Loading data parts | ||
| 492 | 2025.01.15 00:44:48.089111 [ 274 ] {9bbe8850-644f-4461-8775-9599a63122c4} <Debug> oximeter.measurements_i32 (07b40565-dc5e-4625-b41d-176f735fe06a): There are no data parts | ||
| 493 | 2025.01.15 00:44:48.095323 [ 274 ] {9bbe8850-644f-4461-8775-9599a63122c4} <Debug> TCPHandler: Processed in 0.012549462 sec. | ||
| 494 | 2025.01.15 00:44:48.095534 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 495 | 2025.01.15 00:44:48.095879 [ 281 ] {874ebf7e-08c2-453c-a6b8-d0e1bc73d14d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 496 | 2025.01.15 00:44:48.096002 [ 281 ] {874ebf7e-08c2-453c-a6b8-d0e1bc73d14d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 497 | 2025.01.15 00:44:48.108211 [ 281 ] {874ebf7e-08c2-453c-a6b8-d0e1bc73d14d} <Debug> oximeter.measurements_u32 (d02124e4-72b5-4ed7-8cec-147b12a2eb47): Loading data parts | ||
| 498 | 2025.01.15 00:44:48.108390 [ 281 ] {874ebf7e-08c2-453c-a6b8-d0e1bc73d14d} <Debug> oximeter.measurements_u32 (d02124e4-72b5-4ed7-8cec-147b12a2eb47): There are no data parts | ||
| 499 | 2025.01.15 00:44:48.118971 [ 281 ] {874ebf7e-08c2-453c-a6b8-d0e1bc73d14d} <Debug> TCPHandler: Processed in 0.023504202 sec. | ||
| 500 | 2025.01.15 00:44:48.119167 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 501 | 2025.01.15 00:44:48.119362 [ 274 ] {b18b15b4-612c-46f4-840d-0ba4bec5c5c1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 502 | 2025.01.15 00:44:48.119493 [ 274 ] {b18b15b4-612c-46f4-840d-0ba4bec5c5c1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 503 | 2025.01.15 00:44:48.143419 [ 274 ] {b18b15b4-612c-46f4-840d-0ba4bec5c5c1} <Debug> oximeter.measurements_i64 (5d91df46-a4b1-4527-8598-f10dbb8d78ea): Loading data parts | ||
| 504 | 2025.01.15 00:44:48.143711 [ 274 ] {b18b15b4-612c-46f4-840d-0ba4bec5c5c1} <Debug> oximeter.measurements_i64 (5d91df46-a4b1-4527-8598-f10dbb8d78ea): There are no data parts | ||
| 505 | 2025.01.15 00:44:48.154393 [ 274 ] {b18b15b4-612c-46f4-840d-0ba4bec5c5c1} <Debug> TCPHandler: Processed in 0.035281098 sec. | ||
| 506 | 2025.01.15 00:44:48.154595 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 507 | 2025.01.15 00:44:48.154874 [ 281 ] {394e9ff6-8f9b-4757-b5c6-561cb98a8e7a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 508 | 2025.01.15 00:44:48.155002 [ 281 ] {394e9ff6-8f9b-4757-b5c6-561cb98a8e7a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 509 | 2025.01.15 00:44:48.176043 [ 281 ] {394e9ff6-8f9b-4757-b5c6-561cb98a8e7a} <Debug> oximeter.measurements_u64 (1ad8693b-98c9-4d8f-8856-58e4da1e5eea): Loading data parts | ||
| 510 | 2025.01.15 00:44:48.176289 [ 281 ] {394e9ff6-8f9b-4757-b5c6-561cb98a8e7a} <Debug> oximeter.measurements_u64 (1ad8693b-98c9-4d8f-8856-58e4da1e5eea): There are no data parts | ||
| 511 | 2025.01.15 00:44:48.182098 [ 281 ] {394e9ff6-8f9b-4757-b5c6-561cb98a8e7a} <Debug> TCPHandler: Processed in 0.02755763 sec. | ||
| 512 | 2025.01.15 00:44:48.182316 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 513 | 2025.01.15 00:44:48.182551 [ 274 ] {4542af02-7ca3-4116-8b34-39fb68648d25} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 514 | 2025.01.15 00:44:48.182703 [ 274 ] {4542af02-7ca3-4116-8b34-39fb68648d25} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 515 | 2025.01.15 00:44:48.191745 [ 274 ] {4542af02-7ca3-4116-8b34-39fb68648d25} <Debug> oximeter.measurements_f32 (165a4ab1-9899-4a01-bbe9-b035e253039d): Loading data parts | ||
| 516 | 2025.01.15 00:44:48.192022 [ 274 ] {4542af02-7ca3-4116-8b34-39fb68648d25} <Debug> oximeter.measurements_f32 (165a4ab1-9899-4a01-bbe9-b035e253039d): There are no data parts | ||
| 517 | 2025.01.15 00:44:48.203005 [ 274 ] {4542af02-7ca3-4116-8b34-39fb68648d25} <Debug> TCPHandler: Processed in 0.02075676 sec. | ||
| 518 | 2025.01.15 00:44:48.203215 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 519 | 2025.01.15 00:44:48.203499 [ 281 ] {16fdfefd-6844-4f92-a08c-3c4efa37629d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 520 | 2025.01.15 00:44:48.203615 [ 281 ] {16fdfefd-6844-4f92-a08c-3c4efa37629d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 521 | 2025.01.15 00:44:48.216221 [ 281 ] {16fdfefd-6844-4f92-a08c-3c4efa37629d} <Debug> oximeter.measurements_f64 (92beacad-1229-40b2-9419-92db03ca9b99): Loading data parts | ||
| 522 | 2025.01.15 00:44:48.216413 [ 281 ] {16fdfefd-6844-4f92-a08c-3c4efa37629d} <Debug> oximeter.measurements_f64 (92beacad-1229-40b2-9419-92db03ca9b99): There are no data parts | ||
| 523 | 2025.01.15 00:44:48.227347 [ 281 ] {16fdfefd-6844-4f92-a08c-3c4efa37629d} <Debug> TCPHandler: Processed in 0.024185875 sec. | ||
| 524 | 2025.01.15 00:44:48.227554 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 525 | 2025.01.15 00:44:48.227750 [ 274 ] {dde8df02-e32e-4963-914f-9a85c6652e8e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 526 | 2025.01.15 00:44:48.227888 [ 274 ] {dde8df02-e32e-4963-914f-9a85c6652e8e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 527 | 2025.01.15 00:44:48.233941 [ 274 ] {dde8df02-e32e-4963-914f-9a85c6652e8e} <Debug> oximeter.measurements_string (424ea8ed-9559-4de1-bbe1-b1ee5b0d3c3d): Loading data parts | ||
| 528 | 2025.01.15 00:44:48.234215 [ 274 ] {dde8df02-e32e-4963-914f-9a85c6652e8e} <Debug> oximeter.measurements_string (424ea8ed-9559-4de1-bbe1-b1ee5b0d3c3d): There are no data parts | ||
| 529 | 2025.01.15 00:44:48.240421 [ 274 ] {dde8df02-e32e-4963-914f-9a85c6652e8e} <Debug> TCPHandler: Processed in 0.012921229 sec. | ||
| 530 | 2025.01.15 00:44:48.240628 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 531 | 2025.01.15 00:44:48.240930 [ 281 ] {ea41b1ea-a9e5-4567-affd-5b86af96f0e7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 532 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 533 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 534 | * a string isn't palatable for a few reasons. | ||
| 535 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 536 | * details. | ||
| 537 | */ | ||
| 538 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 539 | 2025.01.15 00:44:48.241104 [ 281 ] {ea41b1ea-a9e5-4567-affd-5b86af96f0e7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 540 | 2025.01.15 00:44:48.254309 [ 281 ] {ea41b1ea-a9e5-4567-affd-5b86af96f0e7} <Debug> oximeter.measurements_bytes (4d046be3-c108-4a17-8a4a-0de60637fc43): Loading data parts | ||
| 541 | 2025.01.15 00:44:48.254500 [ 281 ] {ea41b1ea-a9e5-4567-affd-5b86af96f0e7} <Debug> oximeter.measurements_bytes (4d046be3-c108-4a17-8a4a-0de60637fc43): There are no data parts | ||
| 542 | 2025.01.15 00:44:48.265317 [ 281 ] {ea41b1ea-a9e5-4567-affd-5b86af96f0e7} <Debug> TCPHandler: Processed in 0.024753836 sec. | ||
| 543 | 2025.01.15 00:44:48.265525 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 544 | 2025.01.15 00:44:48.265833 [ 274 ] {06129098-956f-4b56-8f54-95fcf67d6823} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 545 | 2025.01.15 00:44:48.265963 [ 274 ] {06129098-956f-4b56-8f54-95fcf67d6823} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 546 | 2025.01.15 00:44:48.275961 [ 274 ] {06129098-956f-4b56-8f54-95fcf67d6823} <Debug> oximeter.measurements_cumulativei64 (8e002770-8518-4fdb-8512-0a719a6f1de6): Loading data parts | ||
| 547 | 2025.01.15 00:44:48.276190 [ 274 ] {06129098-956f-4b56-8f54-95fcf67d6823} <Debug> oximeter.measurements_cumulativei64 (8e002770-8518-4fdb-8512-0a719a6f1de6): There are no data parts | ||
| 548 | 2025.01.15 00:44:48.288924 [ 274 ] {06129098-956f-4b56-8f54-95fcf67d6823} <Debug> TCPHandler: Processed in 0.023457061 sec. | ||
| 549 | 2025.01.15 00:44:48.289132 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 550 | 2025.01.15 00:44:48.289428 [ 281 ] {9faa7464-a995-430e-a1a4-4a3f1f3f2ce9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 551 | 2025.01.15 00:44:48.289523 [ 281 ] {9faa7464-a995-430e-a1a4-4a3f1f3f2ce9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 552 | 2025.01.15 00:44:48.302116 [ 281 ] {9faa7464-a995-430e-a1a4-4a3f1f3f2ce9} <Debug> oximeter.measurements_cumulativeu64 (44414b9d-eff8-481f-b042-2c004d8b0568): Loading data parts | ||
| 553 | 2025.01.15 00:44:48.302279 [ 281 ] {9faa7464-a995-430e-a1a4-4a3f1f3f2ce9} <Debug> oximeter.measurements_cumulativeu64 (44414b9d-eff8-481f-b042-2c004d8b0568): There are no data parts | ||
| 554 | 2025.01.15 00:44:48.312942 [ 281 ] {9faa7464-a995-430e-a1a4-4a3f1f3f2ce9} <Debug> TCPHandler: Processed in 0.023874879 sec. | ||
| 555 | 2025.01.15 00:44:48.313195 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 556 | 2025.01.15 00:44:48.313405 [ 274 ] {2404599a-36ae-4ca0-84ef-5549aa5d7f43} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 557 | 2025.01.15 00:44:48.313534 [ 274 ] {2404599a-36ae-4ca0-84ef-5549aa5d7f43} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 558 | 2025.01.15 00:44:48.323648 [ 274 ] {2404599a-36ae-4ca0-84ef-5549aa5d7f43} <Debug> oximeter.measurements_cumulativef32 (4d8fda80-eedb-476a-83bb-e8e82f31a6a9): Loading data parts | ||
| 559 | 2025.01.15 00:44:48.323911 [ 274 ] {2404599a-36ae-4ca0-84ef-5549aa5d7f43} <Debug> oximeter.measurements_cumulativef32 (4d8fda80-eedb-476a-83bb-e8e82f31a6a9): There are no data parts | ||
| 560 | 2025.01.15 00:44:48.329436 [ 274 ] {2404599a-36ae-4ca0-84ef-5549aa5d7f43} <Debug> TCPHandler: Processed in 0.016296614 sec. | ||
| 561 | 2025.01.15 00:44:48.329629 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 562 | 2025.01.15 00:44:48.329970 [ 281 ] {7d5626f1-89b2-48aa-868a-bcc0c3d568f8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 563 | 2025.01.15 00:44:48.330117 [ 281 ] {7d5626f1-89b2-48aa-868a-bcc0c3d568f8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 564 | 2025.01.15 00:44:48.336887 [ 281 ] {7d5626f1-89b2-48aa-868a-bcc0c3d568f8} <Debug> oximeter.measurements_cumulativef64 (f65afe1c-3b8a-4058-b1d4-bec40a7a0458): Loading data parts | ||
| 565 | 2025.01.15 00:44:48.337063 [ 281 ] {7d5626f1-89b2-48aa-868a-bcc0c3d568f8} <Debug> oximeter.measurements_cumulativef64 (f65afe1c-3b8a-4058-b1d4-bec40a7a0458): There are no data parts | ||
| 566 | 2025.01.15 00:44:48.350703 [ 281 ] {7d5626f1-89b2-48aa-868a-bcc0c3d568f8} <Debug> TCPHandler: Processed in 0.021136066 sec. | ||
| 567 | 2025.01.15 00:44:48.350893 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 568 | 2025.01.15 00:44:48.351223 [ 274 ] {42c2d49d-65b3-4017-b71e-416172fb9edf} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 569 | * NOTE: Array types cannot be Nullable, see | ||
| 570 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 571 | * for more details. | ||
| 572 | * | ||
| 573 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 574 | * is unfortunate, and at this point relies on the fact that an | ||
| 575 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 576 | * to figure out another way to represent missing samples here. | ||
| 577 | */ | ||
| 578 | 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) | ||
| 579 | 2025.01.15 00:44:48.351361 [ 274 ] {42c2d49d-65b3-4017-b71e-416172fb9edf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 580 | 2025.01.15 00:44:48.361073 [ 274 ] {42c2d49d-65b3-4017-b71e-416172fb9edf} <Debug> oximeter.measurements_histogrami8 (b349f0a2-f7ac-4e44-b2c3-20318d192297): Loading data parts | ||
| 581 | 2025.01.15 00:44:48.361300 [ 274 ] {42c2d49d-65b3-4017-b71e-416172fb9edf} <Debug> oximeter.measurements_histogrami8 (b349f0a2-f7ac-4e44-b2c3-20318d192297): There are no data parts | ||
| 582 | 2025.01.15 00:44:48.371970 [ 274 ] {42c2d49d-65b3-4017-b71e-416172fb9edf} <Debug> TCPHandler: Processed in 0.021129606 sec. | ||
| 583 | 2025.01.15 00:44:48.372251 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 584 | 2025.01.15 00:44:48.372868 [ 281 ] {8839de27-1ec9-47d3-92d8-6aba8bdef2fa} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 585 | 2025.01.15 00:44:48.373007 [ 281 ] {8839de27-1ec9-47d3-92d8-6aba8bdef2fa} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 586 | 2025.01.15 00:44:48.384416 [ 281 ] {8839de27-1ec9-47d3-92d8-6aba8bdef2fa} <Debug> oximeter.measurements_histogramu8 (63b74504-c4e7-4a73-9b52-0e2a3b5af5a3): Loading data parts | ||
| 587 | 2025.01.15 00:44:48.384685 [ 281 ] {8839de27-1ec9-47d3-92d8-6aba8bdef2fa} <Debug> oximeter.measurements_histogramu8 (63b74504-c4e7-4a73-9b52-0e2a3b5af5a3): There are no data parts | ||
| 588 | 2025.01.15 00:44:48.395386 [ 281 ] {8839de27-1ec9-47d3-92d8-6aba8bdef2fa} <Debug> TCPHandler: Processed in 0.023236917 sec. | ||
| 589 | 2025.01.15 00:44:48.395607 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 590 | 2025.01.15 00:44:48.395918 [ 274 ] {acff4043-78cd-4415-86f9-efcf78112d4d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 591 | 2025.01.15 00:44:48.396073 [ 274 ] {acff4043-78cd-4415-86f9-efcf78112d4d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 592 | 2025.01.15 00:44:48.408173 [ 274 ] {acff4043-78cd-4415-86f9-efcf78112d4d} <Debug> oximeter.measurements_histogrami16 (a0094d51-f16b-47ea-b6c6-07d4fec89c02): Loading data parts | ||
| 593 | 2025.01.15 00:44:48.408452 [ 274 ] {acff4043-78cd-4415-86f9-efcf78112d4d} <Debug> oximeter.measurements_histogrami16 (a0094d51-f16b-47ea-b6c6-07d4fec89c02): There are no data parts | ||
| 594 | 2025.01.15 00:44:48.419105 [ 274 ] {acff4043-78cd-4415-86f9-efcf78112d4d} <Debug> TCPHandler: Processed in 0.023562754 sec. | ||
| 595 | 2025.01.15 00:44:48.419315 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 596 | 2025.01.15 00:44:48.419743 [ 281 ] {fd262241-293b-4a44-9898-50d892d51541} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 597 | 2025.01.15 00:44:48.419905 [ 281 ] {fd262241-293b-4a44-9898-50d892d51541} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 598 | 2025.01.15 00:44:48.431658 [ 281 ] {fd262241-293b-4a44-9898-50d892d51541} <Debug> oximeter.measurements_histogramu16 (bee30a7f-0ad4-4fe7-b139-bd538265fae0): Loading data parts | ||
| 599 | 2025.01.15 00:44:48.431849 [ 281 ] {fd262241-293b-4a44-9898-50d892d51541} <Debug> oximeter.measurements_histogramu16 (bee30a7f-0ad4-4fe7-b139-bd538265fae0): There are no data parts | ||
| 600 | 2025.01.15 00:44:48.442832 [ 281 ] {fd262241-293b-4a44-9898-50d892d51541} <Debug> TCPHandler: Processed in 0.023581513 sec. | ||
| 601 | 2025.01.15 00:44:48.443121 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 602 | 2025.01.15 00:44:48.443546 [ 274 ] {5c2eab18-aa1d-4fb9-b62d-b10a59ed50b2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 603 | 2025.01.15 00:44:48.443743 [ 274 ] {5c2eab18-aa1d-4fb9-b62d-b10a59ed50b2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 604 | 2025.01.15 00:44:48.455575 [ 274 ] {5c2eab18-aa1d-4fb9-b62d-b10a59ed50b2} <Debug> oximeter.measurements_histogrami32 (6a623cae-b4a3-44cf-b76f-c32a3e371bbe): Loading data parts | ||
| 605 | 2025.01.15 00:44:48.455852 [ 274 ] {5c2eab18-aa1d-4fb9-b62d-b10a59ed50b2} <Debug> oximeter.measurements_histogrami32 (6a623cae-b4a3-44cf-b76f-c32a3e371bbe): There are no data parts | ||
| 606 | 2025.01.15 00:44:48.467354 [ 274 ] {5c2eab18-aa1d-4fb9-b62d-b10a59ed50b2} <Debug> TCPHandler: Processed in 0.024358929 sec. | ||
| 607 | 2025.01.15 00:44:48.467554 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 608 | 2025.01.15 00:44:48.467959 [ 281 ] {cc6a8430-7f52-49cc-8bfc-3901dc4f9efb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 609 | 2025.01.15 00:44:48.468124 [ 281 ] {cc6a8430-7f52-49cc-8bfc-3901dc4f9efb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 610 | 2025.01.15 00:44:48.489543 [ 281 ] {cc6a8430-7f52-49cc-8bfc-3901dc4f9efb} <Debug> oximeter.measurements_histogramu32 (6f8aedfb-17df-43f0-8720-712f8b0747de): Loading data parts | ||
| 611 | 2025.01.15 00:44:48.489709 [ 281 ] {cc6a8430-7f52-49cc-8bfc-3901dc4f9efb} <Debug> oximeter.measurements_histogramu32 (6f8aedfb-17df-43f0-8720-712f8b0747de): There are no data parts | ||
| 612 | 2025.01.15 00:44:48.494481 [ 281 ] {cc6a8430-7f52-49cc-8bfc-3901dc4f9efb} <Debug> TCPHandler: Processed in 0.026985479 sec. | ||
| 613 | 2025.01.15 00:44:48.494679 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 614 | 2025.01.15 00:44:48.494957 [ 274 ] {b4f073b7-97a9-4731-aacc-fdc1c04b039f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 615 | 2025.01.15 00:44:48.495101 [ 274 ] {b4f073b7-97a9-4731-aacc-fdc1c04b039f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 616 | 2025.01.15 00:44:48.499207 [ 274 ] {b4f073b7-97a9-4731-aacc-fdc1c04b039f} <Debug> oximeter.measurements_histogrami64 (18d127a5-0c65-488c-bd2b-4dcc4ed7e506): Loading data parts | ||
| 617 | 2025.01.15 00:44:48.499519 [ 274 ] {b4f073b7-97a9-4731-aacc-fdc1c04b039f} <Debug> oximeter.measurements_histogrami64 (18d127a5-0c65-488c-bd2b-4dcc4ed7e506): There are no data parts | ||
| 618 | 2025.01.15 00:44:48.512448 [ 274 ] {b4f073b7-97a9-4731-aacc-fdc1c04b039f} <Debug> TCPHandler: Processed in 0.017821943 sec. | ||
| 619 | 2025.01.15 00:44:48.512742 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 620 | 2025.01.15 00:44:48.513152 [ 281 ] {4046a211-f3bd-4678-8a03-5156316e57f5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 621 | 2025.01.15 00:44:48.513297 [ 281 ] {4046a211-f3bd-4678-8a03-5156316e57f5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 622 | 2025.01.15 00:44:48.523013 [ 281 ] {4046a211-f3bd-4678-8a03-5156316e57f5} <Debug> oximeter.measurements_histogramu64 (81569ab4-3a66-41fe-8d43-38218579c287): Loading data parts | ||
| 623 | 2025.01.15 00:44:48.523197 [ 281 ] {4046a211-f3bd-4678-8a03-5156316e57f5} <Debug> oximeter.measurements_histogramu64 (81569ab4-3a66-41fe-8d43-38218579c287): There are no data parts | ||
| 624 | 2025.01.15 00:44:48.536429 [ 281 ] {4046a211-f3bd-4678-8a03-5156316e57f5} <Debug> TCPHandler: Processed in 0.023787278 sec. | ||
| 625 | 2025.01.15 00:44:48.536660 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 626 | 2025.01.15 00:44:48.536960 [ 274 ] {06d0d16d-8a0b-46d8-9b58-2240e1a1863f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 627 | 2025.01.15 00:44:48.537105 [ 274 ] {06d0d16d-8a0b-46d8-9b58-2240e1a1863f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 628 | 2025.01.15 00:44:48.556045 [ 274 ] {06d0d16d-8a0b-46d8-9b58-2240e1a1863f} <Debug> oximeter.measurements_histogramf32 (eb45db2d-7bcf-4850-9868-c08432190f94): Loading data parts | ||
| 629 | 2025.01.15 00:44:48.556348 [ 274 ] {06d0d16d-8a0b-46d8-9b58-2240e1a1863f} <Debug> oximeter.measurements_histogramf32 (eb45db2d-7bcf-4850-9868-c08432190f94): There are no data parts | ||
| 630 | 2025.01.15 00:44:48.563038 [ 274 ] {06d0d16d-8a0b-46d8-9b58-2240e1a1863f} <Debug> TCPHandler: Processed in 0.026443319 sec. | ||
| 631 | 2025.01.15 00:44:48.563228 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 632 | 2025.01.15 00:44:48.563621 [ 281 ] {5690f330-7b5d-41c9-b9f6-9ea42378e965} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 633 | 2025.01.15 00:44:48.563779 [ 281 ] {5690f330-7b5d-41c9-b9f6-9ea42378e965} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 634 | 2025.01.15 00:44:48.572090 [ 281 ] {5690f330-7b5d-41c9-b9f6-9ea42378e965} <Debug> oximeter.measurements_histogramf64 (ce693bee-1650-49c9-ba39-e35e0123e6f5): Loading data parts | ||
| 635 | 2025.01.15 00:44:48.572290 [ 281 ] {5690f330-7b5d-41c9-b9f6-9ea42378e965} <Debug> oximeter.measurements_histogramf64 (ce693bee-1650-49c9-ba39-e35e0123e6f5): There are no data parts | ||
| 636 | 2025.01.15 00:44:48.585884 [ 281 ] {5690f330-7b5d-41c9-b9f6-9ea42378e965} <Debug> TCPHandler: Processed in 0.022711947 sec. | ||
| 637 | 2025.01.15 00:44:48.586131 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 638 | 2025.01.15 00:44:48.586390 [ 274 ] {e003cfe7-2ad8-4a3e-9faa-f0bbba1928dc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) /* The field tables store named dimensions of each timeseries. | ||
| 639 | * | ||
| 640 | * As with the measurement tables, there is one field table for each field data | ||
| 641 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 642 | * this behavior **must not** be relied upon for query correctness. | ||
| 643 | * | ||
| 644 | * The index for the fields differs from the measurements, however. Rows are | ||
| 645 | * sorted by timeseries name, then field name, field value, and finally | ||
| 646 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 647 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 648 | * usually then used to look up measurements. | ||
| 649 | * | ||
| 650 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 651 | * timeseries name and then key, since it would improve lookups where one | ||
| 652 | * already has the key. Realistically though, these tables are quite small and | ||
| 653 | * so performance benefits will be low in absolute terms. | ||
| 654 | * | ||
| 655 | * TTL: We use a materialized column to expire old field table records. This | ||
| 656 | * column is generated automatically by the database whenever a new row is | ||
| 657 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 658 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 659 | * record will remain during a deduplication, which will have the last | ||
| 660 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 661 | * measurement tables. | ||
| 662 | */ | ||
| 663 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 664 | 2025.01.15 00:44:48.586562 [ 274 ] {e003cfe7-2ad8-4a3e-9faa-f0bbba1928dc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 665 | 2025.01.15 00:44:48.596568 [ 274 ] {e003cfe7-2ad8-4a3e-9faa-f0bbba1928dc} <Debug> oximeter.fields_bool (853bcc3f-1fd0-42df-bd66-55509a04cf81): Loading data parts | ||
| 666 | 2025.01.15 00:44:48.596825 [ 274 ] {e003cfe7-2ad8-4a3e-9faa-f0bbba1928dc} <Debug> oximeter.fields_bool (853bcc3f-1fd0-42df-bd66-55509a04cf81): There are no data parts | ||
| 667 | 2025.01.15 00:44:48.609306 [ 274 ] {e003cfe7-2ad8-4a3e-9faa-f0bbba1928dc} <Debug> TCPHandler: Processed in 0.023231597 sec. | ||
| 668 | 2025.01.15 00:44:48.609542 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 669 | 2025.01.15 00:44:48.609873 [ 281 ] {17a25e51-23ba-484c-b76f-b05515f715be} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 670 | 2025.01.15 00:44:48.610015 [ 281 ] {17a25e51-23ba-484c-b76f-b05515f715be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 671 | 2025.01.15 00:44:48.619645 [ 281 ] {17a25e51-23ba-484c-b76f-b05515f715be} <Debug> oximeter.fields_i8 (0108dccc-0184-49ac-9906-5a6f695b0aab): Loading data parts | ||
| 672 | 2025.01.15 00:44:48.619816 [ 281 ] {17a25e51-23ba-484c-b76f-b05515f715be} <Debug> oximeter.fields_i8 (0108dccc-0184-49ac-9906-5a6f695b0aab): There are no data parts | ||
| 673 | 2025.01.15 00:44:48.632973 [ 281 ] {17a25e51-23ba-484c-b76f-b05515f715be} <Debug> TCPHandler: Processed in 0.023494333 sec. | ||
| 674 | 2025.01.15 00:44:48.633233 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 675 | 2025.01.15 00:44:48.633431 [ 274 ] {f74af9a9-1c6f-4b69-86b5-cf4a4b720255} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 676 | 2025.01.15 00:44:48.633583 [ 274 ] {f74af9a9-1c6f-4b69-86b5-cf4a4b720255} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 677 | 2025.01.15 00:44:48.643149 [ 274 ] {f74af9a9-1c6f-4b69-86b5-cf4a4b720255} <Debug> oximeter.fields_u8 (c7a8ab77-fd07-4645-bd30-fc90f9c022aa): Loading data parts | ||
| 678 | 2025.01.15 00:44:48.643420 [ 274 ] {f74af9a9-1c6f-4b69-86b5-cf4a4b720255} <Debug> oximeter.fields_u8 (c7a8ab77-fd07-4645-bd30-fc90f9c022aa): There are no data parts | ||
| 679 | 2025.01.15 00:44:48.656465 [ 274 ] {f74af9a9-1c6f-4b69-86b5-cf4a4b720255} <Debug> TCPHandler: Processed in 0.023299558 sec. | ||
| 680 | 2025.01.15 00:44:48.656688 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 681 | 2025.01.15 00:44:48.656999 [ 281 ] {206082c7-c342-4b96-8326-3103cb55166a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 682 | 2025.01.15 00:44:48.657138 [ 281 ] {206082c7-c342-4b96-8326-3103cb55166a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 683 | 2025.01.15 00:44:48.666747 [ 281 ] {206082c7-c342-4b96-8326-3103cb55166a} <Debug> oximeter.fields_i16 (72280d6f-41d9-44c2-b1a9-04ec0b910cfe): Loading data parts | ||
| 684 | 2025.01.15 00:44:48.666925 [ 281 ] {206082c7-c342-4b96-8326-3103cb55166a} <Debug> oximeter.fields_i16 (72280d6f-41d9-44c2-b1a9-04ec0b910cfe): There are no data parts | ||
| 685 | 2025.01.15 00:44:48.679735 [ 281 ] {206082c7-c342-4b96-8326-3103cb55166a} <Debug> TCPHandler: Processed in 0.023111825 sec. | ||
| 686 | 2025.01.15 00:44:48.679937 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 687 | 2025.01.15 00:44:48.680227 [ 274 ] {af092369-6ce7-4ce1-a472-323a4240d3a5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 688 | 2025.01.15 00:44:48.680409 [ 274 ] {af092369-6ce7-4ce1-a472-323a4240d3a5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 689 | 2025.01.15 00:44:48.690810 [ 274 ] {af092369-6ce7-4ce1-a472-323a4240d3a5} <Debug> oximeter.fields_u16 (fee2db43-471c-4fa4-9748-62fac20c79ed): Loading data parts | ||
| 690 | 2025.01.15 00:44:48.691080 [ 274 ] {af092369-6ce7-4ce1-a472-323a4240d3a5} <Debug> oximeter.fields_u16 (fee2db43-471c-4fa4-9748-62fac20c79ed): There are no data parts | ||
| 691 | 2025.01.15 00:44:48.704677 [ 274 ] {af092369-6ce7-4ce1-a472-323a4240d3a5} <Debug> TCPHandler: Processed in 0.024792467 sec. | ||
| 692 | 2025.01.15 00:44:48.704895 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 693 | 2025.01.15 00:44:48.705187 [ 281 ] {75ed2b4f-f5ab-4468-9359-70ecddd61dd5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 694 | 2025.01.15 00:44:48.705320 [ 281 ] {75ed2b4f-f5ab-4468-9359-70ecddd61dd5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 695 | 2025.01.15 00:44:48.715516 [ 281 ] {75ed2b4f-f5ab-4468-9359-70ecddd61dd5} <Debug> oximeter.fields_i32 (a9e2354f-35c3-4b63-aa42-85b44c25cd41): Loading data parts | ||
| 696 | 2025.01.15 00:44:48.715719 [ 281 ] {75ed2b4f-f5ab-4468-9359-70ecddd61dd5} <Debug> oximeter.fields_i32 (a9e2354f-35c3-4b63-aa42-85b44c25cd41): There are no data parts | ||
| 697 | 2025.01.15 00:44:48.729449 [ 281 ] {75ed2b4f-f5ab-4468-9359-70ecddd61dd5} <Debug> TCPHandler: Processed in 0.024615873 sec. | ||
| 698 | 2025.01.15 00:44:48.729669 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 699 | 2025.01.15 00:44:48.729899 [ 274 ] {1738f099-29a2-4ca8-9845-aadecc982268} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 700 | 2025.01.15 00:44:48.730104 [ 274 ] {1738f099-29a2-4ca8-9845-aadecc982268} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 701 | 2025.01.15 00:44:48.740417 [ 274 ] {1738f099-29a2-4ca8-9845-aadecc982268} <Debug> oximeter.fields_u32 (46ae6eea-7358-40a9-82c3-833c3d0a48ec): Loading data parts | ||
| 702 | 2025.01.15 00:44:48.740644 [ 274 ] {1738f099-29a2-4ca8-9845-aadecc982268} <Debug> oximeter.fields_u32 (46ae6eea-7358-40a9-82c3-833c3d0a48ec): There are no data parts | ||
| 703 | 2025.01.15 00:44:48.753215 [ 274 ] {1738f099-29a2-4ca8-9845-aadecc982268} <Debug> TCPHandler: Processed in 0.023618685 sec. | ||
| 704 | 2025.01.15 00:44:48.753415 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 705 | 2025.01.15 00:44:48.753701 [ 281 ] {87050adc-89b6-443c-835f-52370162c0cf} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 706 | 2025.01.15 00:44:48.753842 [ 281 ] {87050adc-89b6-443c-835f-52370162c0cf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 707 | 2025.01.15 00:44:48.776363 [ 281 ] {87050adc-89b6-443c-835f-52370162c0cf} <Debug> oximeter.fields_i64 (415d3e17-15e5-4986-a50d-3b3ba44a966a): Loading data parts | ||
| 708 | 2025.01.15 00:44:48.776553 [ 281 ] {87050adc-89b6-443c-835f-52370162c0cf} <Debug> oximeter.fields_i64 (415d3e17-15e5-4986-a50d-3b3ba44a966a): There are no data parts | ||
| 709 | 2025.01.15 00:44:48.787651 [ 281 ] {87050adc-89b6-443c-835f-52370162c0cf} <Debug> TCPHandler: Processed in 0.034292069 sec. | ||
| 710 | 2025.01.15 00:44:48.787841 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 711 | 2025.01.15 00:44:48.788033 [ 274 ] {897fcbd5-c479-4f69-b11f-25957e9bca32} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 712 | 2025.01.15 00:44:48.788196 [ 274 ] {897fcbd5-c479-4f69-b11f-25957e9bca32} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 713 | 2025.01.15 00:44:48.811938 [ 274 ] {897fcbd5-c479-4f69-b11f-25957e9bca32} <Debug> oximeter.fields_u64 (8a0fb6ef-9340-4566-82b6-3f0a69859fe6): Loading data parts | ||
| 714 | 2025.01.15 00:44:48.812123 [ 274 ] {897fcbd5-c479-4f69-b11f-25957e9bca32} <Debug> oximeter.fields_u64 (8a0fb6ef-9340-4566-82b6-3f0a69859fe6): There are no data parts | ||
| 715 | 2025.01.15 00:44:48.821906 [ 274 ] {897fcbd5-c479-4f69-b11f-25957e9bca32} <Debug> TCPHandler: Processed in 0.034115277 sec. | ||
| 716 | 2025.01.15 00:44:48.822128 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 717 | 2025.01.15 00:44:48.822424 [ 281 ] {5419b081-c95e-48bf-951c-7f198df1eac5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 718 | 2025.01.15 00:44:48.822559 [ 281 ] {5419b081-c95e-48bf-951c-7f198df1eac5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 719 | 2025.01.15 00:44:48.838468 [ 281 ] {5419b081-c95e-48bf-951c-7f198df1eac5} <Debug> oximeter.fields_ipaddr (632f25ef-275a-4870-9599-a49cb7d3b05b): Loading data parts | ||
| 720 | 2025.01.15 00:44:48.838645 [ 281 ] {5419b081-c95e-48bf-951c-7f198df1eac5} <Debug> oximeter.fields_ipaddr (632f25ef-275a-4870-9599-a49cb7d3b05b): There are no data parts | ||
| 721 | 2025.01.15 00:44:48.852002 [ 281 ] {5419b081-c95e-48bf-951c-7f198df1eac5} <Debug> TCPHandler: Processed in 0.029932086 sec. | ||
| 722 | 2025.01.15 00:44:48.852230 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 723 | 2025.01.15 00:44:48.852479 [ 274 ] {456c2687-136a-4c79-adfe-db653dbae18b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) 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) | ||
| 724 | 2025.01.15 00:44:48.852634 [ 274 ] {456c2687-136a-4c79-adfe-db653dbae18b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 725 | 2025.01.15 00:44:48.862840 [ 274 ] {456c2687-136a-4c79-adfe-db653dbae18b} <Debug> oximeter.fields_string (7e4afd8f-28a7-44ef-9198-b998aa5855f0): Loading data parts | ||
| 726 | 2025.01.15 00:44:48.863020 [ 274 ] {456c2687-136a-4c79-adfe-db653dbae18b} <Debug> oximeter.fields_string (7e4afd8f-28a7-44ef-9198-b998aa5855f0): There are no data parts | ||
| 727 | 2025.01.15 00:44:48.876122 [ 274 ] {456c2687-136a-4c79-adfe-db653dbae18b} <Debug> TCPHandler: Processed in 0.023968171 sec. | ||
| 728 | 2025.01.15 00:44:48.876432 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 729 | 2025.01.15 00:44:48.876638 [ 281 ] {61453fab-8687-424e-ba5f-e2f95b5a7b57} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) 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) | ||
| 730 | 2025.01.15 00:44:48.876777 [ 281 ] {61453fab-8687-424e-ba5f-e2f95b5a7b57} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 731 | 2025.01.15 00:44:48.889304 [ 281 ] {61453fab-8687-424e-ba5f-e2f95b5a7b57} <Debug> oximeter.fields_uuid (0ca30d6f-fe2c-44ff-acf3-74e7795eda06): Loading data parts | ||
| 732 | 2025.01.15 00:44:48.889530 [ 281 ] {61453fab-8687-424e-ba5f-e2f95b5a7b57} <Debug> oximeter.fields_uuid (0ca30d6f-fe2c-44ff-acf3-74e7795eda06): There are no data parts | ||
| 733 | 2025.01.15 00:44:48.911189 [ 281 ] {61453fab-8687-424e-ba5f-e2f95b5a7b57} <Debug> TCPHandler: Processed in 0.03482524 sec. | ||
| 734 | 2025.01.15 00:44:48.911418 [ 274 ] {} <Trace> TCP-Session: 5cb3323a-a748-457c-b551-9db95749d3e8 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 735 | 2025.01.15 00:44:48.911804 [ 274 ] {504e97ce-463b-4cc6-9617-1b2fd04cbc21} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:63195) /* The timeseries schema table stores the extracted schema for the samples | ||
| 736 | * oximeter collects. | ||
| 737 | */ | ||
| 738 | 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) | ||
| 739 | 2025.01.15 00:44:48.911962 [ 274 ] {504e97ce-463b-4cc6-9617-1b2fd04cbc21} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 740 | 2025.01.15 00:44:48.923819 [ 274 ] {504e97ce-463b-4cc6-9617-1b2fd04cbc21} <Debug> oximeter.timeseries_schema (5fe3f435-4b29-4706-9898-fa0c7b14f361): Loading data parts | ||
| 741 | 2025.01.15 00:44:48.924059 [ 274 ] {504e97ce-463b-4cc6-9617-1b2fd04cbc21} <Debug> oximeter.timeseries_schema (5fe3f435-4b29-4706-9898-fa0c7b14f361): There are no data parts | ||
| 742 | 2025.01.15 00:44:48.944914 [ 274 ] {504e97ce-463b-4cc6-9617-1b2fd04cbc21} <Debug> TCPHandler: Processed in 0.033564066 sec. | ||
| 743 | 2025.01.15 00:44:48.945268 [ 281 ] {} <Trace> TCP-Session: c3121a81-1051-4510-a96a-d64e072bfa31 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 744 | 2025.01.15 00:44:48.945593 [ 281 ] {9e048763-a2bd-45ea-b50b-a6e0108ed379} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:38568) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 745 | 2025.01.15 00:44:48.946541 [ 281 ] {9e048763-a2bd-45ea-b50b-a6e0108ed379} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 746 | 2025.01.15 00:44:48.954994 [ 292 ] {9e048763-a2bd-45ea-b50b-a6e0108ed379} <Trace> oximeter.version (d5141d5d-8f47-4ad9-b48b-c2a188ef065d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 747 | 2025.01.15 00:44:48.955049 [ 292 ] {9e048763-a2bd-45ea-b50b-a6e0108ed379} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.55 GiB. | ||
| 748 | 2025.01.15 00:44:48.960175 [ 292 ] {9e048763-a2bd-45ea-b50b-a6e0108ed379} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 749 | 2025.01.15 00:44:48.960780 [ 292 ] {9e048763-a2bd-45ea-b50b-a6e0108ed379} <Trace> oximeter.version (d5141d5d-8f47-4ad9-b48b-c2a188ef065d): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 750 | 2025.01.15 00:44:48.961130 [ 281 ] {9e048763-a2bd-45ea-b50b-a6e0108ed379} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.015672 sec., 63.80806533945891 rows/sec., 1020.93 B/sec. | ||
| 751 | 2025.01.15 00:44:48.961449 [ 281 ] {9e048763-a2bd-45ea-b50b-a6e0108ed379} <Debug> TCPHandler: Processed in 0.016293423 sec. | ||
| 752 | 2025.01.15 00:44:49.001163 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 136.68 MiB, peak 136.68 MiB, free memory in arenas 0.00 B, will set to 141.46 MiB (RSS), difference: 4.77 MiB | ||
| 753 | 2025.01.15 00:44:54.627932 [ 244 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 754 | 2025.01.15 00:44:54.627933 [ 243 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488 | ||
| 755 | 2025.01.15 00:44:54.628051 [ 244 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 756 | 2025.01.15 00:44:54.628084 [ 243 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 757 | 2025.01.15 00:44:54.644479 [ 243 ] {} <Debug> system.asynchronous_metric_log (2ba0caf7-6104-44d4-8971-9a8ae7e8c61b): Loading data parts | ||
| 758 | 2025.01.15 00:44:54.644726 [ 243 ] {} <Debug> system.asynchronous_metric_log (2ba0caf7-6104-44d4-8971-9a8ae7e8c61b): There are no data parts | ||
| 759 | 2025.01.15 00:44:54.653197 [ 244 ] {} <Debug> system.metric_log (5a35ad84-562b-4a36-a315-2066b118562d): Loading data parts | ||
| 760 | 2025.01.15 00:44:54.653528 [ 244 ] {} <Debug> system.metric_log (5a35ad84-562b-4a36-a315-2066b118562d): There are no data parts | ||
| 761 | 2025.01.15 00:44:54.657724 [ 243 ] {} <Trace> system.asynchronous_metric_log (2ba0caf7-6104-44d4-8971-9a8ae7e8c61b): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 762 | 2025.01.15 00:44:54.657833 [ 243 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.54 GiB. | ||
| 763 | 2025.01.15 00:44:54.660662 [ 243 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 764 | 2025.01.15 00:44:54.661184 [ 243 ] {} <Trace> system.asynchronous_metric_log (2ba0caf7-6104-44d4-8971-9a8ae7e8c61b): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 765 | 2025.01.15 00:44:54.661437 [ 243 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488 | ||
| 766 | 2025.01.15 00:44:54.684259 [ 244 ] {} <Trace> system.metric_log (5a35ad84-562b-4a36-a315-2066b118562d): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 767 | 2025.01.15 00:44:54.684305 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.54 GiB. | ||
| 768 | 2025.01.15 00:44:54.691581 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 769 | 2025.01.15 00:44:54.692719 [ 244 ] {} <Trace> system.metric_log (5a35ad84-562b-4a36-a315-2066b118562d): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 770 | 2025.01.15 00:44:54.695048 [ 244 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 771 | 2025.01.15 00:44:55.000187 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 146.49 MiB, peak 150.49 MiB, free memory in arenas 0.00 B, will set to 150.99 MiB (RSS), difference: 4.50 MiB | ||
| 772 | 2025.01.15 00:44:57.127802 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 90 entries to flush up to offset 90 | ||
| 773 | 2025.01.15 00:44:57.127903 [ 242 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
| 774 | 2025.01.15 00:44:57.134314 [ 242 ] {} <Debug> system.query_log (d78407cc-3b25-4dd6-b6d1-805faf7e25f7): Loading data parts | ||
| 775 | 2025.01.15 00:44:57.134480 [ 242 ] {} <Debug> system.query_log (d78407cc-3b25-4dd6-b6d1-805faf7e25f7): There are no data parts | ||
| 776 | 2025.01.15 00:44:57.143453 [ 242 ] {} <Trace> system.query_log (d78407cc-3b25-4dd6-b6d1-805faf7e25f7): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 777 | 2025.01.15 00:44:57.143496 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.54 GiB. | ||
| 778 | 2025.01.15 00:44:57.145310 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 779 | 2025.01.15 00:44:57.145871 [ 242 ] {} <Trace> system.query_log (d78407cc-3b25-4dd6-b6d1-805faf7e25f7): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 780 | 2025.01.15 00:44:57.146409 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 90 | ||
| 781 | 2025.01.15 00:44:58.000148 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 155.18 MiB, peak 155.18 MiB, free memory in arenas 0.00 B, will set to 151.47 MiB (RSS), difference: -3.71 MiB | ||