| 1 | [ Oct 31 00:14:35 Enabled. ] | ||
| 2 | [ Oct 31 00:14:35 Rereading configuration. ] | ||
| 3 | [ Oct 31 00:14:36 Rereading configuration. ] | ||
| 4 | [ Oct 31 00:14:47 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ] | ||
| 5 | + set -o errexit | ||
| 6 | + set -o pipefail | ||
| 7 | + . /lib/svc/share/smf_include.sh | ||
| 8 | ++ SMF_EXIT_OK=0 | ||
| 9 | ++ SMF_EXIT_NODAEMON=94 | ||
| 10 | ++ SMF_EXIT_ERR_FATAL=95 | ||
| 11 | ++ SMF_EXIT_ERR_CONFIG=96 | ||
| 12 | ++ SMF_EXIT_MON_DEGRADE=97 | ||
| 13 | ++ SMF_EXIT_MON_OFFLINE=98 | ||
| 14 | ++ SMF_EXIT_ERR_NOSMF=99 | ||
| 15 | ++ SMF_EXIT_ERR_PERM=100 | ||
| 16 | ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default | ||
| 17 | + LISTEN_ADDR=fd00:1122:3344:101::e | ||
| 18 | ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default | ||
| 19 | + LISTEN_PORT=8123 | ||
| 20 | ++ svcprop -c -p config/store svc:/oxide/clickhouse:default | ||
| 21 | + DATASTORE=/data | ||
| 22 | + args=("--config-file" "/opt/oxide/clickhouse/config.xml" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
| 23 | + exec /opt/oxide/clickhouse/clickhouse server --config-file /opt/oxide/clickhouse/config.xml -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123 | ||
| 24 | [ Oct 31 00:14:47 Method "start" exited with status 0. ] | ||
| 25 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 26 | Logging trace to /var/tmp/clickhouse-server.log | ||
| 27 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
| 28 | 2024.10.31 00:14:47.943352 [ 1 ] {} <Information> Application: Will watch for the process with pid 23318 | ||
| 29 | 2024.10.31 00:14:47.943903 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 30 | 2024.10.31 00:14:48.197892 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 23318 | ||
| 31 | 2024.10.31 00:14:48.198606 [ 1 ] {} <Information> Application: starting up | ||
| 32 | 2024.10.31 00:14:48.199286 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 33 | 2024.10.31 00:14:48.286898 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
| 34 | 2024.10.31 00:14:48.322310 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 35 | 2024.10.31 00:14:48.322387 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 36 | 2024.10.31 00:14:48.322400 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 37 | 2024.10.31 00:14:48.322476 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
| 38 | 2024.10.31 00:14:48.322930 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 39 | 2024.10.31 00:14:48.324513 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
| 40 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 41 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 42 | 2024.10.31 00:14:48.325090 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 43 | 2024.10.31 00:14:48.325923 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 44 | 2024.10.31 00:14:48.325946 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 45 | 2024.10.31 00:14:48.325961 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
| 46 | 2024.10.31 00:14:48.326136 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 47 | 2024.10.31 00:14:48.327027 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 48 | 2024.10.31 00:14:48.332489 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 49 | 2024.10.31 00:14:48.333308 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 50 | 2024.10.31 00:14:48.334683 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 51 | 2024.10.31 00:14:48.334748 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 52 | 2024.10.31 00:14:48.336284 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
| 53 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 54 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 55 | 2024.10.31 00:14:48.336599 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 56 | 2024.10.31 00:14:48.340878 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 57 | 2024.10.31 00:14:48.341380 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml | ||
| 58 | 2024.10.31 00:14:48.342867 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 59 | 2024.10.31 00:14:48.343238 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 60 | 2024.10.31 00:14:48.343622 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 61 | 2024.10.31 00:14:48.343953 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 62 | 2024.10.31 00:14:48.345345 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 63 | 2024.10.31 00:14:48.345372 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 64 | 2024.10.31 00:14:48.345447 [ 169 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 65 | 2024.10.31 00:14:48.345623 [ 169 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 66 | 2024.10.31 00:14:48.359942 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 67 | 2024.10.31 00:14:48.359974 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000171571 sec | ||
| 68 | 2024.10.31 00:14:48.360023 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 69 | 2024.10.31 00:14:48.360042 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 70 | 2024.10.31 00:14:48.361191 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 71 | 2024.10.31 00:14:48.362244 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 72 | 2024.10.31 00:14:48.374279 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 73 | 2024.10.31 00:14:48.374327 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 74 | 2024.10.31 00:14:48.374353 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 75 | 2024.10.31 00:14:48.374365 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 76 | 2024.10.31 00:14:48.374397 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 77 | 2024.10.31 00:14:48.374415 [ 1 ] {} <Debug> SystemLog: Not creating system.metric_log since corresponding section 'metric_log' is missing from config | ||
| 78 | 2024.10.31 00:14:48.374428 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 79 | 2024.10.31 00:14:48.374459 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 80 | 2024.10.31 00:14:48.374477 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_metric_log since corresponding section 'asynchronous_metric_log' is missing from config | ||
| 81 | 2024.10.31 00:14:48.374490 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 82 | 2024.10.31 00:14:48.374502 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 83 | 2024.10.31 00:14:48.374543 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 84 | 2024.10.31 00:14:48.374555 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 85 | 2024.10.31 00:14:48.374567 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 86 | 2024.10.31 00:14:48.374602 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 87 | 2024.10.31 00:14:48.374615 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 88 | 2024.10.31 00:14:48.402773 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 89 | 2024.10.31 00:14:48.407634 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 90 | 2024.10.31 00:14:48.407666 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.582e-05 sec | ||
| 91 | 2024.10.31 00:14:48.407683 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 92 | 2024.10.31 00:14:48.407697 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 93 | 2024.10.31 00:14:48.407726 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 94 | 2024.10.31 00:14:48.407989 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
| 95 | 2024.10.31 00:14:48.408046 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 96 | 2024.10.31 00:14:48.408064 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 97 | 2024.10.31 00:14:48.408086 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
| 98 | 2024.10.31 00:14:48.408120 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 99 | 2024.10.31 00:14:48.412158 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 100 | 2024.10.31 00:14:48.412380 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.71 MiB, peak 24.71 MiB, free memory in arenas 0.00 B, will set to 116.71 MiB (RSS), difference: 92.00 MiB | ||
| 101 | 2024.10.31 00:14:48.413326 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.72e-05 sec. | ||
| 102 | 2024.10.31 00:14:48.413789 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 103 | 2024.10.31 00:14:48.413919 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 104 | 2024.10.31 00:14:48.413954 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 105 | 2024.10.31 00:14:49.135088 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:33053 | ||
| 106 | 2024.10.31 00:14:49.135563 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2024.10.31 00:14:49.135626 [ 3 ] {} <Debug> TCP-Session: cacaa551-7636-474c-a5d4-3410fc4106c1 Authenticating user 'default' from [fd00:1122:3344:101::c]:33053 | ||
| 108 | 2024.10.31 00:14:49.135658 [ 3 ] {} <Debug> TCP-Session: cacaa551-7636-474c-a5d4-3410fc4106c1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2024.10.31 00:14:49.135685 [ 3 ] {} <Debug> TCP-Session: cacaa551-7636-474c-a5d4-3410fc4106c1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2024.10.31 00:14:49.135771 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 111 | 2024.10.31 00:14:49.135800 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 112 | 2024.10.31 00:14:49.135824 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 113 | 2024.10.31 00:14:49.136150 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:54567 | ||
| 114 | 2024.10.31 00:14:49.136305 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 115 | 2024.10.31 00:14:49.136362 [ 250 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:63658 | ||
| 116 | 2024.10.31 00:14:49.136381 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:59788 | ||
| 117 | 2024.10.31 00:14:49.136374 [ 4 ] {} <Debug> TCP-Session: 254b23d6-f987-4a9c-987c-c1ad73aabf08 Authenticating user 'default' from [fd00:1122:3344:101::c]:54567 | ||
| 118 | 2024.10.31 00:14:49.136490 [ 250 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 119 | 2024.10.31 00:14:49.136499 [ 4 ] {} <Debug> TCP-Session: 254b23d6-f987-4a9c-987c-c1ad73aabf08 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 120 | 2024.10.31 00:14:49.136621 [ 252 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:41027 | ||
| 121 | 2024.10.31 00:14:49.136633 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 122 | 2024.10.31 00:14:49.136660 [ 4 ] {} <Debug> TCP-Session: 254b23d6-f987-4a9c-987c-c1ad73aabf08 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 123 | 2024.10.31 00:14:49.136655 [ 250 ] {} <Debug> TCP-Session: ec830f3e-1b7a-47b4-97c8-d8deb6755c06 Authenticating user 'default' from [fd00:1122:3344:101::c]:63658 | ||
| 124 | 2024.10.31 00:14:49.136702 [ 5 ] {} <Debug> TCP-Session: 169cc0f5-3cdc-461c-b3ed-c6860142140c Authenticating user 'default' from [fd00:1122:3344:101::c]:59788 | ||
| 125 | 2024.10.31 00:14:49.136633 [ 251 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:33741 | ||
| 126 | 2024.10.31 00:14:49.136864 [ 5 ] {} <Debug> TCP-Session: 169cc0f5-3cdc-461c-b3ed-c6860142140c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 127 | 2024.10.31 00:14:49.136880 [ 250 ] {} <Debug> TCP-Session: ec830f3e-1b7a-47b4-97c8-d8deb6755c06 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 128 | 2024.10.31 00:14:49.136895 [ 252 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 129 | 2024.10.31 00:14:49.136939 [ 5 ] {} <Debug> TCP-Session: 169cc0f5-3cdc-461c-b3ed-c6860142140c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 130 | 2024.10.31 00:14:49.136946 [ 250 ] {} <Debug> TCP-Session: ec830f3e-1b7a-47b4-97c8-d8deb6755c06 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 131 | 2024.10.31 00:14:49.137089 [ 252 ] {} <Debug> TCP-Session: ec42120c-0560-4e93-a7c8-9ebb94442fb5 Authenticating user 'default' from [fd00:1122:3344:101::c]:41027 | ||
| 132 | 2024.10.31 00:14:49.137113 [ 251 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 133 | 2024.10.31 00:14:49.137146 [ 252 ] {} <Debug> TCP-Session: ec42120c-0560-4e93-a7c8-9ebb94442fb5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 134 | 2024.10.31 00:14:49.137190 [ 252 ] {} <Debug> TCP-Session: ec42120c-0560-4e93-a7c8-9ebb94442fb5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 135 | 2024.10.31 00:14:49.137199 [ 251 ] {} <Debug> TCP-Session: 09a54bb0-4602-4f38-8c60-04bc35812827 Authenticating user 'default' from [fd00:1122:3344:101::c]:33741 | ||
| 136 | 2024.10.31 00:14:49.137246 [ 251 ] {} <Debug> TCP-Session: 09a54bb0-4602-4f38-8c60-04bc35812827 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 137 | 2024.10.31 00:14:49.137262 [ 251 ] {} <Debug> TCP-Session: 09a54bb0-4602-4f38-8c60-04bc35812827 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 138 | 2024.10.31 00:14:49.137524 [ 253 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:48831 | ||
| 139 | 2024.10.31 00:14:49.137685 [ 254 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:54668 | ||
| 140 | 2024.10.31 00:14:49.137692 [ 253 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 141 | 2024.10.31 00:14:49.137736 [ 253 ] {} <Debug> TCP-Session: 6ca43cb8-6881-4745-b8d9-8a08d4b9058b Authenticating user 'default' from [fd00:1122:3344:101::c]:48831 | ||
| 142 | 2024.10.31 00:14:49.137813 [ 253 ] {} <Debug> TCP-Session: 6ca43cb8-6881-4745-b8d9-8a08d4b9058b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 143 | 2024.10.31 00:14:49.137818 [ 254 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 144 | 2024.10.31 00:14:49.137857 [ 253 ] {} <Debug> TCP-Session: 6ca43cb8-6881-4745-b8d9-8a08d4b9058b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 145 | 2024.10.31 00:14:49.137877 [ 254 ] {} <Debug> TCP-Session: 5f927fc3-4bc5-4ccb-aebe-00a4c486691d Authenticating user 'default' from [fd00:1122:3344:101::c]:54668 | ||
| 146 | 2024.10.31 00:14:49.137923 [ 254 ] {} <Debug> TCP-Session: 5f927fc3-4bc5-4ccb-aebe-00a4c486691d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2024.10.31 00:14:49.137936 [ 254 ] {} <Debug> TCP-Session: 5f927fc3-4bc5-4ccb-aebe-00a4c486691d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 148 | 2024.10.31 00:14:49.982915 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:38650 | ||
| 149 | 2024.10.31 00:14:49.983276 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 150 | 2024.10.31 00:14:49.983313 [ 255 ] {} <Debug> TCP-Session: 8c8780b9-ae9a-46cf-8ea9-c1e87c7e135d Authenticating user 'default' from [fd00:1122:3344:101::b]:38650 | ||
| 151 | 2024.10.31 00:14:49.983337 [ 255 ] {} <Debug> TCP-Session: 8c8780b9-ae9a-46cf-8ea9-c1e87c7e135d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 152 | 2024.10.31 00:14:49.983356 [ 255 ] {} <Debug> TCP-Session: 8c8780b9-ae9a-46cf-8ea9-c1e87c7e135d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 153 | 2024.10.31 00:14:49.983409 [ 255 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 154 | 2024.10.31 00:14:49.983433 [ 255 ] {} <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 | 2024.10.31 00:14:49.983457 [ 255 ] {} <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 | 2024.10.31 00:14:49.983950 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:56548 | ||
| 157 | 2024.10.31 00:14:49.984147 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 158 | 2024.10.31 00:14:49.984186 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:62506 | ||
| 159 | 2024.10.31 00:14:49.984220 [ 256 ] {} <Debug> TCP-Session: db21c5e9-57d8-43cb-8084-b98de4ac43c5 Authenticating user 'default' from [fd00:1122:3344:101::b]:56548 | ||
| 160 | 2024.10.31 00:14:49.984254 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:36557 | ||
| 161 | 2024.10.31 00:14:49.984206 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:56893 | ||
| 162 | 2024.10.31 00:14:49.984286 [ 256 ] {} <Debug> TCP-Session: db21c5e9-57d8-43cb-8084-b98de4ac43c5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 163 | 2024.10.31 00:14:49.984403 [ 260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:59489 | ||
| 164 | 2024.10.31 00:14:49.984505 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 165 | 2024.10.31 00:14:49.984573 [ 256 ] {} <Debug> TCP-Session: db21c5e9-57d8-43cb-8084-b98de4ac43c5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 166 | 2024.10.31 00:14:49.984581 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 167 | 2024.10.31 00:14:49.984624 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:51859 | ||
| 168 | 2024.10.31 00:14:49.984754 [ 258 ] {} <Debug> TCP-Session: 7679b19c-9edd-4feb-abd6-4fddacda10e3 Authenticating user 'default' from [fd00:1122:3344:101::b]:62506 | ||
| 169 | 2024.10.31 00:14:49.984927 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:55817 | ||
| 170 | 2024.10.31 00:14:49.984948 [ 258 ] {} <Debug> TCP-Session: 7679b19c-9edd-4feb-abd6-4fddacda10e3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 171 | 2024.10.31 00:14:49.984829 [ 260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 172 | 2024.10.31 00:14:49.984976 [ 259 ] {} <Debug> TCP-Session: bea37e23-a83e-4418-8419-e36b68512b04 Authenticating user 'default' from [fd00:1122:3344:101::b]:36557 | ||
| 173 | 2024.10.31 00:14:49.984959 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 174 | 2024.10.31 00:14:49.985045 [ 258 ] {} <Debug> TCP-Session: 7679b19c-9edd-4feb-abd6-4fddacda10e3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 175 | 2024.10.31 00:14:49.985114 [ 259 ] {} <Debug> TCP-Session: bea37e23-a83e-4418-8419-e36b68512b04 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 176 | 2024.10.31 00:14:49.985133 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 177 | 2024.10.31 00:14:49.985263 [ 259 ] {} <Debug> TCP-Session: bea37e23-a83e-4418-8419-e36b68512b04 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 178 | 2024.10.31 00:14:49.985272 [ 257 ] {} <Debug> TCP-Session: 72071302-b454-4e74-8a32-c9c0f4e21e13 Authenticating user 'default' from [fd00:1122:3344:101::b]:56893 | ||
| 179 | 2024.10.31 00:14:49.985288 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 180 | 2024.10.31 00:14:49.985313 [ 260 ] {} <Debug> TCP-Session: 5e7a14ee-9ae2-41f6-935f-ba1054c3225e Authenticating user 'default' from [fd00:1122:3344:101::b]:59489 | ||
| 181 | 2024.10.31 00:14:49.985417 [ 257 ] {} <Debug> TCP-Session: 72071302-b454-4e74-8a32-c9c0f4e21e13 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 182 | 2024.10.31 00:14:49.985399 [ 261 ] {} <Debug> TCP-Session: 616fb50c-c817-4335-80fc-9dbf72645e2b Authenticating user 'default' from [fd00:1122:3344:101::b]:51859 | ||
| 183 | 2024.10.31 00:14:49.985433 [ 260 ] {} <Debug> TCP-Session: 5e7a14ee-9ae2-41f6-935f-ba1054c3225e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 184 | 2024.10.31 00:14:49.985463 [ 257 ] {} <Debug> TCP-Session: 72071302-b454-4e74-8a32-c9c0f4e21e13 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 185 | 2024.10.31 00:14:49.985476 [ 261 ] {} <Debug> TCP-Session: 616fb50c-c817-4335-80fc-9dbf72645e2b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 186 | 2024.10.31 00:14:49.985489 [ 260 ] {} <Debug> TCP-Session: 5e7a14ee-9ae2-41f6-935f-ba1054c3225e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 187 | 2024.10.31 00:14:49.985427 [ 262 ] {} <Debug> TCP-Session: 96fe70e9-61de-4234-ba30-597682e32302 Authenticating user 'default' from [fd00:1122:3344:101::b]:55817 | ||
| 188 | 2024.10.31 00:14:49.985520 [ 261 ] {} <Debug> TCP-Session: 616fb50c-c817-4335-80fc-9dbf72645e2b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 189 | 2024.10.31 00:14:49.985573 [ 262 ] {} <Debug> TCP-Session: 96fe70e9-61de-4234-ba30-597682e32302 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 190 | 2024.10.31 00:14:49.985629 [ 262 ] {} <Debug> TCP-Session: 96fe70e9-61de-4234-ba30-597682e32302 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 191 | 2024.10.31 00:14:50.000151 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 117.33 MiB, peak 117.33 MiB, free memory in arenas 0.00 B, will set to 119.14 MiB (RSS), difference: 1.81 MiB | ||
| 192 | 2024.10.31 00:14:50.078528 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:51549 | ||
| 193 | 2024.10.31 00:14:50.078982 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 194 | 2024.10.31 00:14:50.079013 [ 263 ] {} <Debug> TCP-Session: caadbef8-6b9d-4005-a944-0db90c416051 Authenticating user 'default' from [fd00:1122:3344:101::a]:51549 | ||
| 195 | 2024.10.31 00:14:50.079038 [ 263 ] {} <Debug> TCP-Session: caadbef8-6b9d-4005-a944-0db90c416051 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 196 | 2024.10.31 00:14:50.079064 [ 263 ] {} <Debug> TCP-Session: caadbef8-6b9d-4005-a944-0db90c416051 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 197 | 2024.10.31 00:14:50.079117 [ 263 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 198 | 2024.10.31 00:14:50.079145 [ 263 ] {} <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 | ||
| 199 | 2024.10.31 00:14:50.079170 [ 263 ] {} <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 | ||
| 200 | 2024.10.31 00:14:50.079619 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:65082 | ||
| 201 | 2024.10.31 00:14:50.079693 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:42710 | ||
| 202 | 2024.10.31 00:14:50.079826 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 203 | 2024.10.31 00:14:50.079846 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:58771 | ||
| 204 | 2024.10.31 00:14:50.079945 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:35009 | ||
| 205 | 2024.10.31 00:14:50.079955 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 206 | 2024.10.31 00:14:50.080002 [ 264 ] {} <Debug> TCP-Session: 568a6fd5-12d1-424e-81dd-e4bb829a97ff Authenticating user 'default' from [fd00:1122:3344:101::a]:65082 | ||
| 207 | 2024.10.31 00:14:50.080112 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:49059 | ||
| 208 | 2024.10.31 00:14:50.080273 [ 264 ] {} <Debug> TCP-Session: 568a6fd5-12d1-424e-81dd-e4bb829a97ff Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 209 | 2024.10.31 00:14:50.080274 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 210 | 2024.10.31 00:14:50.080292 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 211 | 2024.10.31 00:14:50.080412 [ 264 ] {} <Debug> TCP-Session: 568a6fd5-12d1-424e-81dd-e4bb829a97ff Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 212 | 2024.10.31 00:14:50.080471 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 213 | 2024.10.31 00:14:50.080491 [ 270 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:47888 | ||
| 214 | 2024.10.31 00:14:50.080464 [ 267 ] {} <Debug> TCP-Session: 5443a3d7-e6ae-498f-b5fa-0eb5e76b6b5d Authenticating user 'default' from [fd00:1122:3344:101::a]:35009 | ||
| 215 | 2024.10.31 00:14:50.080524 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:36199 | ||
| 216 | 2024.10.31 00:14:50.080497 [ 266 ] {} <Debug> TCP-Session: 8bff5730-cbee-46be-9580-ed2c091df7f7 Authenticating user 'default' from [fd00:1122:3344:101::a]:58771 | ||
| 217 | 2024.10.31 00:14:50.080553 [ 265 ] {} <Debug> TCP-Session: 8c4fd60a-fbda-4c0d-8a40-e16761f6ee04 Authenticating user 'default' from [fd00:1122:3344:101::a]:42710 | ||
| 218 | 2024.10.31 00:14:50.080594 [ 268 ] {} <Debug> TCP-Session: c9062cd9-c977-4d9e-b406-aa6b53a482c9 Authenticating user 'default' from [fd00:1122:3344:101::a]:49059 | ||
| 219 | 2024.10.31 00:14:50.080759 [ 266 ] {} <Debug> TCP-Session: 8bff5730-cbee-46be-9580-ed2c091df7f7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 220 | 2024.10.31 00:14:50.080650 [ 267 ] {} <Debug> TCP-Session: 5443a3d7-e6ae-498f-b5fa-0eb5e76b6b5d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 221 | 2024.10.31 00:14:50.080889 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 222 | 2024.10.31 00:14:50.080887 [ 270 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 223 | 2024.10.31 00:14:50.080929 [ 266 ] {} <Debug> TCP-Session: 8bff5730-cbee-46be-9580-ed2c091df7f7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 224 | 2024.10.31 00:14:50.080937 [ 265 ] {} <Debug> TCP-Session: 8c4fd60a-fbda-4c0d-8a40-e16761f6ee04 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 225 | 2024.10.31 00:14:50.080981 [ 267 ] {} <Debug> TCP-Session: 5443a3d7-e6ae-498f-b5fa-0eb5e76b6b5d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 226 | 2024.10.31 00:14:50.081048 [ 270 ] {} <Debug> TCP-Session: 3237e01f-5500-4264-91d3-95c0739cc070 Authenticating user 'default' from [fd00:1122:3344:101::a]:47888 | ||
| 227 | 2024.10.31 00:14:50.081063 [ 269 ] {} <Debug> TCP-Session: 4a9afc10-da01-4131-9c94-3068481bfe98 Authenticating user 'default' from [fd00:1122:3344:101::a]:36199 | ||
| 228 | 2024.10.31 00:14:50.081082 [ 265 ] {} <Debug> TCP-Session: 8c4fd60a-fbda-4c0d-8a40-e16761f6ee04 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 229 | 2024.10.31 00:14:50.081169 [ 269 ] {} <Debug> TCP-Session: 4a9afc10-da01-4131-9c94-3068481bfe98 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 230 | 2024.10.31 00:14:50.081154 [ 270 ] {} <Debug> TCP-Session: 3237e01f-5500-4264-91d3-95c0739cc070 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 231 | 2024.10.31 00:14:50.081222 [ 268 ] {} <Debug> TCP-Session: c9062cd9-c977-4d9e-b406-aa6b53a482c9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 232 | 2024.10.31 00:14:50.081239 [ 270 ] {} <Debug> TCP-Session: 3237e01f-5500-4264-91d3-95c0739cc070 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 233 | 2024.10.31 00:14:50.081255 [ 268 ] {} <Debug> TCP-Session: c9062cd9-c977-4d9e-b406-aa6b53a482c9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 234 | 2024.10.31 00:14:50.081229 [ 269 ] {} <Debug> TCP-Session: 4a9afc10-da01-4131-9c94-3068481bfe98 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 235 | 2024.10.31 00:14:52.501827 [ 271 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:35209 | ||
| 236 | 2024.10.31 00:14:52.502301 [ 271 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 237 | 2024.10.31 00:14:52.502348 [ 271 ] {} <Debug> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Authenticating user 'default' from [fd00:1122:3344:101::d]:35209 | ||
| 238 | 2024.10.31 00:14:52.502371 [ 271 ] {} <Debug> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 239 | 2024.10.31 00:14:52.502385 [ 271 ] {} <Debug> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 240 | 2024.10.31 00:14:52.502448 [ 271 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 241 | 2024.10.31 00:14:52.502473 [ 271 ] {} <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 | ||
| 242 | 2024.10.31 00:14:52.502499 [ 271 ] {} <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 | ||
| 243 | 2024.10.31 00:14:52.503026 [ 273 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:54639 | ||
| 244 | 2024.10.31 00:14:52.503027 [ 272 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:51163 | ||
| 245 | 2024.10.31 00:14:52.503340 [ 275 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:43717 | ||
| 246 | 2024.10.31 00:14:52.503349 [ 272 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 247 | 2024.10.31 00:14:52.503370 [ 273 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 248 | 2024.10.31 00:14:52.503358 [ 274 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:61194 | ||
| 249 | 2024.10.31 00:14:52.503434 [ 276 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:57926 | ||
| 250 | 2024.10.31 00:14:52.503564 [ 272 ] {} <Debug> TCP-Session: d153fc19-af07-4cdc-b476-bc78717f14d4 Authenticating user 'default' from [fd00:1122:3344:101::d]:51163 | ||
| 251 | 2024.10.31 00:14:52.503591 [ 275 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 252 | 2024.10.31 00:14:52.503630 [ 277 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:42731 | ||
| 253 | 2024.10.31 00:14:52.503641 [ 273 ] {} <Debug> TCP-Session: d5c51243-9e22-44de-8c68-efeee412d6d8 Authenticating user 'default' from [fd00:1122:3344:101::d]:54639 | ||
| 254 | 2024.10.31 00:14:52.504494 [ 275 ] {} <Debug> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Authenticating user 'default' from [fd00:1122:3344:101::d]:43717 | ||
| 255 | 2024.10.31 00:14:52.504563 [ 273 ] {} <Debug> TCP-Session: d5c51243-9e22-44de-8c68-efeee412d6d8 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 256 | 2024.10.31 00:14:52.504589 [ 277 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 257 | 2024.10.31 00:14:52.504597 [ 279 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:39314 | ||
| 258 | 2024.10.31 00:14:52.504614 [ 278 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:37832 | ||
| 259 | 2024.10.31 00:14:52.504694 [ 273 ] {} <Debug> TCP-Session: d5c51243-9e22-44de-8c68-efeee412d6d8 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 260 | 2024.10.31 00:14:52.504708 [ 277 ] {} <Debug> TCP-Session: 826e7dbb-0c12-42a8-9d60-0ae3026b07e5 Authenticating user 'default' from [fd00:1122:3344:101::d]:42731 | ||
| 261 | 2024.10.31 00:14:52.504739 [ 275 ] {} <Debug> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 262 | 2024.10.31 00:14:52.505971 [ 274 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 263 | 2024.10.31 00:14:52.503671 [ 272 ] {} <Debug> TCP-Session: d153fc19-af07-4cdc-b476-bc78717f14d4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 264 | 2024.10.31 00:14:52.505981 [ 275 ] {} <Debug> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2024.10.31 00:14:52.506009 [ 278 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 266 | 2024.10.31 00:14:52.506058 [ 277 ] {} <Debug> TCP-Session: 826e7dbb-0c12-42a8-9d60-0ae3026b07e5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 267 | 2024.10.31 00:14:52.506012 [ 279 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 268 | 2024.10.31 00:14:52.506055 [ 276 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 269 | 2024.10.31 00:14:52.506163 [ 277 ] {} <Debug> TCP-Session: 826e7dbb-0c12-42a8-9d60-0ae3026b07e5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2024.10.31 00:14:52.506224 [ 279 ] {} <Debug> TCP-Session: dc11c10e-3eab-42fb-a113-12f3651e5674 Authenticating user 'default' from [fd00:1122:3344:101::d]:39314 | ||
| 271 | 2024.10.31 00:14:52.506226 [ 272 ] {} <Debug> TCP-Session: d153fc19-af07-4cdc-b476-bc78717f14d4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 272 | 2024.10.31 00:14:52.506268 [ 274 ] {} <Debug> TCP-Session: bc191125-a96b-416e-8fae-394493f475ca Authenticating user 'default' from [fd00:1122:3344:101::d]:61194 | ||
| 273 | 2024.10.31 00:14:52.506313 [ 276 ] {} <Debug> TCP-Session: 18097e6c-99e0-41f0-b5bf-e4cf2304bd13 Authenticating user 'default' from [fd00:1122:3344:101::d]:57926 | ||
| 274 | 2024.10.31 00:14:52.506355 [ 279 ] {} <Debug> TCP-Session: dc11c10e-3eab-42fb-a113-12f3651e5674 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2024.10.31 00:14:52.506413 [ 278 ] {} <Debug> TCP-Session: 62e5adaa-7c11-47d7-a3ae-e71e16be7c8c Authenticating user 'default' from [fd00:1122:3344:101::d]:37832 | ||
| 276 | 2024.10.31 00:14:52.506427 [ 274 ] {} <Debug> TCP-Session: bc191125-a96b-416e-8fae-394493f475ca Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2024.10.31 00:14:52.506479 [ 278 ] {} <Debug> TCP-Session: 62e5adaa-7c11-47d7-a3ae-e71e16be7c8c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 278 | 2024.10.31 00:14:52.506461 [ 279 ] {} <Debug> TCP-Session: dc11c10e-3eab-42fb-a113-12f3651e5674 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2024.10.31 00:14:52.506512 [ 274 ] {} <Debug> TCP-Session: bc191125-a96b-416e-8fae-394493f475ca Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 280 | 2024.10.31 00:14:52.506529 [ 278 ] {} <Debug> TCP-Session: 62e5adaa-7c11-47d7-a3ae-e71e16be7c8c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 281 | 2024.10.31 00:14:52.506461 [ 276 ] {} <Debug> TCP-Session: 18097e6c-99e0-41f0-b5bf-e4cf2304bd13 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2024.10.31 00:14:52.506607 [ 276 ] {} <Debug> TCP-Session: 18097e6c-99e0-41f0-b5bf-e4cf2304bd13 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.10.31 00:14:52.507149 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 284 | 2024.10.31 00:14:52.516350 [ 271 ] {16d7b59a-be31-4c7a-8426-c05338198b40} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 285 | 2024.10.31 00:14:52.571676 [ 271 ] {16d7b59a-be31-4c7a-8426-c05338198b40} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:35209) (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 @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 308 | |||
| 309 | 2024.10.31 00:14:52.572967 [ 271 ] {16d7b59a-be31-4c7a-8426-c05338198b40} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 310 | |||
| 311 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 312 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 313 | 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 | ||
| 314 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 315 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 316 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 317 | 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 | ||
| 318 | 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 | ||
| 319 | 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 | ||
| 320 | 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 | ||
| 321 | 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 | ||
| 322 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 323 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 324 | 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 | ||
| 325 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 326 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 327 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 328 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 329 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 330 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 331 | 20. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 332 | |||
| 333 | 2024.10.31 00:14:52.573079 [ 271 ] {16d7b59a-be31-4c7a-8426-c05338198b40} <Debug> TCPHandler: Processed in 0.069447521 sec. | ||
| 334 | 2024.10.31 00:14:52.573434 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 335 | 2024.10.31 00:14:52.573614 [ 275 ] {19507bb7-087a-47bd-8205-577e7765657b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 336 | 2024.10.31 00:14:52.573941 [ 275 ] {19507bb7-087a-47bd-8205-577e7765657b} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:43717) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 337 | |||
| 338 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 339 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 340 | 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 | ||
| 341 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 342 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 343 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 344 | 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 | ||
| 345 | 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 | ||
| 346 | 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 | ||
| 347 | 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 | ||
| 348 | 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 | ||
| 349 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 350 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 351 | 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 | ||
| 352 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 353 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 354 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 355 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 356 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 357 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 358 | 20. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 359 | |||
| 360 | 2024.10.31 00:14:52.574053 [ 275 ] {19507bb7-087a-47bd-8205-577e7765657b} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 361 | |||
| 362 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 363 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 364 | 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 | ||
| 365 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 366 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 367 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 368 | 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 | ||
| 369 | 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 | ||
| 370 | 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 | ||
| 371 | 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 | ||
| 372 | 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 | ||
| 373 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 374 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 375 | 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 | ||
| 376 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 377 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 378 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 379 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 380 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 381 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 382 | 20. _thrp_setup @ 0x0000000000114f37 in /system/lib/amd64/libc.so.1 | ||
| 383 | |||
| 384 | 2024.10.31 00:14:52.574143 [ 275 ] {19507bb7-087a-47bd-8205-577e7765657b} <Debug> TCPHandler: Processed in 0.000854889 sec. | ||
| 385 | 2024.10.31 00:14:52.574357 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 386 | 2024.10.31 00:14:52.575555 [ 271 ] {ae330187-e347-42dc-bd6d-828701668ed3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 387 | 2024.10.31 00:14:52.576170 [ 271 ] {ae330187-e347-42dc-bd6d-828701668ed3} <Debug> TCPHandler: Processed in 0.001867669 sec. | ||
| 388 | 2024.10.31 00:14:52.576377 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 389 | 2024.10.31 00:14:52.576484 [ 275 ] {226fef06-b722-44cf-89dc-1929ae8d2737} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 390 | 2024.10.31 00:14:52.576596 [ 275 ] {226fef06-b722-44cf-89dc-1929ae8d2737} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 391 | 2024.10.31 00:14:52.578097 [ 275 ] {226fef06-b722-44cf-89dc-1929ae8d2737} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 392 | 2024.10.31 00:14:52.578118 [ 275 ] {226fef06-b722-44cf-89dc-1929ae8d2737} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 5.4861e-05 sec | ||
| 393 | 2024.10.31 00:14:52.578136 [ 275 ] {226fef06-b722-44cf-89dc-1929ae8d2737} <Trace> ReferentialDeps: No tables | ||
| 394 | 2024.10.31 00:14:52.578154 [ 275 ] {226fef06-b722-44cf-89dc-1929ae8d2737} <Trace> LoadingDeps: No tables | ||
| 395 | 2024.10.31 00:14:52.578182 [ 275 ] {226fef06-b722-44cf-89dc-1929ae8d2737} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 396 | 2024.10.31 00:14:52.578220 [ 275 ] {226fef06-b722-44cf-89dc-1929ae8d2737} <Debug> TCPHandler: Processed in 0.001896169 sec. | ||
| 397 | 2024.10.31 00:14:52.578389 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 398 | 2024.10.31 00:14:52.578559 [ 271 ] {313e927b-364a-49d1-b517-c55bce47ea5a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) /* The version table contains metadata about the `oximeter` database */ | ||
| 399 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 400 | 2024.10.31 00:14:52.578610 [ 271 ] {313e927b-364a-49d1-b517-c55bce47ea5a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 401 | 2024.10.31 00:14:52.585024 [ 271 ] {313e927b-364a-49d1-b517-c55bce47ea5a} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 402 | 2024.10.31 00:14:52.586381 [ 271 ] {313e927b-364a-49d1-b517-c55bce47ea5a} <Debug> oximeter.version (76b7c84e-4c04-4980-a43e-870dab81e38f): Loading data parts | ||
| 403 | 2024.10.31 00:14:52.586912 [ 271 ] {313e927b-364a-49d1-b517-c55bce47ea5a} <Debug> oximeter.version (76b7c84e-4c04-4980-a43e-870dab81e38f): There are no data parts | ||
| 404 | 2024.10.31 00:14:52.589863 [ 271 ] {313e927b-364a-49d1-b517-c55bce47ea5a} <Debug> TCPHandler: Processed in 0.011526508 sec. | ||
| 405 | 2024.10.31 00:14:52.590058 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 406 | 2024.10.31 00:14:52.590256 [ 275 ] {9dfc13a0-6f42-431b-b035-6461df5886fc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) /* The measurement tables contain all individual samples from each timeseries. | ||
| 407 | * | ||
| 408 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 409 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 410 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 411 | * by all samples from the same timeseries. | ||
| 412 | * | ||
| 413 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 414 | * and then uses that to index quickly into the measurements tables. | ||
| 415 | */ | ||
| 416 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 417 | 2024.10.31 00:14:52.590315 [ 275 ] {9dfc13a0-6f42-431b-b035-6461df5886fc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 418 | 2024.10.31 00:14:52.596834 [ 275 ] {9dfc13a0-6f42-431b-b035-6461df5886fc} <Debug> oximeter.measurements_bool (8a08f01d-3d7c-40af-8140-2ccca01885cb): Loading data parts | ||
| 419 | 2024.10.31 00:14:52.597069 [ 275 ] {9dfc13a0-6f42-431b-b035-6461df5886fc} <Debug> oximeter.measurements_bool (8a08f01d-3d7c-40af-8140-2ccca01885cb): There are no data parts | ||
| 420 | 2024.10.31 00:14:52.598391 [ 275 ] {9dfc13a0-6f42-431b-b035-6461df5886fc} <Debug> TCPHandler: Processed in 0.008386795 sec. | ||
| 421 | 2024.10.31 00:14:52.598578 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 422 | 2024.10.31 00:14:52.598790 [ 271 ] {0c4e1326-466b-4a43-985b-d0dc257f0825} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 423 | 2024.10.31 00:14:52.598852 [ 271 ] {0c4e1326-466b-4a43-985b-d0dc257f0825} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 424 | 2024.10.31 00:14:52.600612 [ 271 ] {0c4e1326-466b-4a43-985b-d0dc257f0825} <Debug> oximeter.measurements_i8 (569c295c-e4a3-4773-a5e5-846cd54dbc84): Loading data parts | ||
| 425 | 2024.10.31 00:14:52.600875 [ 271 ] {0c4e1326-466b-4a43-985b-d0dc257f0825} <Debug> oximeter.measurements_i8 (569c295c-e4a3-4773-a5e5-846cd54dbc84): There are no data parts | ||
| 426 | 2024.10.31 00:14:52.602167 [ 271 ] {0c4e1326-466b-4a43-985b-d0dc257f0825} <Debug> TCPHandler: Processed in 0.003643297 sec. | ||
| 427 | 2024.10.31 00:14:52.602359 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 428 | 2024.10.31 00:14:52.602589 [ 275 ] {1577cead-7017-41f7-839b-4f78356573b7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 429 | 2024.10.31 00:14:52.602661 [ 275 ] {1577cead-7017-41f7-839b-4f78356573b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 430 | 2024.10.31 00:14:52.604584 [ 275 ] {1577cead-7017-41f7-839b-4f78356573b7} <Debug> oximeter.measurements_u8 (3038dfcb-8448-4a57-be00-4b8a7bb5de88): Loading data parts | ||
| 431 | 2024.10.31 00:14:52.604773 [ 275 ] {1577cead-7017-41f7-839b-4f78356573b7} <Debug> oximeter.measurements_u8 (3038dfcb-8448-4a57-be00-4b8a7bb5de88): There are no data parts | ||
| 432 | 2024.10.31 00:14:52.606064 [ 275 ] {1577cead-7017-41f7-839b-4f78356573b7} <Debug> TCPHandler: Processed in 0.003768059 sec. | ||
| 433 | 2024.10.31 00:14:52.606242 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 434 | 2024.10.31 00:14:52.606473 [ 271 ] {10ed3fcb-4309-4dfd-a6d7-b6882fb3cbfd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 435 | 2024.10.31 00:14:52.606540 [ 271 ] {10ed3fcb-4309-4dfd-a6d7-b6882fb3cbfd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 436 | 2024.10.31 00:14:52.608430 [ 271 ] {10ed3fcb-4309-4dfd-a6d7-b6882fb3cbfd} <Debug> oximeter.measurements_i16 (7a1b9f06-96e3-4cbe-a8bd-2943d68c198b): Loading data parts | ||
| 437 | 2024.10.31 00:14:52.608599 [ 271 ] {10ed3fcb-4309-4dfd-a6d7-b6882fb3cbfd} <Debug> oximeter.measurements_i16 (7a1b9f06-96e3-4cbe-a8bd-2943d68c198b): There are no data parts | ||
| 438 | 2024.10.31 00:14:52.609860 [ 271 ] {10ed3fcb-4309-4dfd-a6d7-b6882fb3cbfd} <Debug> TCPHandler: Processed in 0.003670398 sec. | ||
| 439 | 2024.10.31 00:14:52.610046 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 440 | 2024.10.31 00:14:52.610274 [ 275 ] {a5005add-65fe-4292-875a-f644e53060e1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 441 | 2024.10.31 00:14:52.610340 [ 275 ] {a5005add-65fe-4292-875a-f644e53060e1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 442 | 2024.10.31 00:14:52.612506 [ 275 ] {a5005add-65fe-4292-875a-f644e53060e1} <Debug> oximeter.measurements_u16 (f3b70410-a367-42cf-9c58-fa85b7f689ce): Loading data parts | ||
| 443 | 2024.10.31 00:14:52.612700 [ 275 ] {a5005add-65fe-4292-875a-f644e53060e1} <Debug> oximeter.measurements_u16 (f3b70410-a367-42cf-9c58-fa85b7f689ce): There are no data parts | ||
| 444 | 2024.10.31 00:14:52.613968 [ 275 ] {a5005add-65fe-4292-875a-f644e53060e1} <Debug> TCPHandler: Processed in 0.003984411 sec. | ||
| 445 | 2024.10.31 00:14:52.614162 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 446 | 2024.10.31 00:14:52.614378 [ 271 ] {cc4f84d6-6394-4867-bd48-23cb74504a98} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 447 | 2024.10.31 00:14:52.614435 [ 271 ] {cc4f84d6-6394-4867-bd48-23cb74504a98} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 448 | 2024.10.31 00:14:52.616633 [ 271 ] {cc4f84d6-6394-4867-bd48-23cb74504a98} <Debug> oximeter.measurements_i32 (bbbd6251-b57e-4aee-afe3-0843fe4d69bb): Loading data parts | ||
| 449 | 2024.10.31 00:14:52.616802 [ 271 ] {cc4f84d6-6394-4867-bd48-23cb74504a98} <Debug> oximeter.measurements_i32 (bbbd6251-b57e-4aee-afe3-0843fe4d69bb): There are no data parts | ||
| 450 | 2024.10.31 00:14:52.618211 [ 271 ] {cc4f84d6-6394-4867-bd48-23cb74504a98} <Debug> TCPHandler: Processed in 0.004114093 sec. | ||
| 451 | 2024.10.31 00:14:52.618393 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 452 | 2024.10.31 00:14:52.618582 [ 275 ] {11adcd9e-f57c-49a2-aaca-ed80b0fd13cb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 453 | 2024.10.31 00:14:52.618645 [ 275 ] {11adcd9e-f57c-49a2-aaca-ed80b0fd13cb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 454 | 2024.10.31 00:14:52.620511 [ 275 ] {11adcd9e-f57c-49a2-aaca-ed80b0fd13cb} <Debug> oximeter.measurements_u32 (f30858e4-ff96-49b2-8790-589cf2c40d5f): Loading data parts | ||
| 455 | 2024.10.31 00:14:52.620687 [ 275 ] {11adcd9e-f57c-49a2-aaca-ed80b0fd13cb} <Debug> oximeter.measurements_u32 (f30858e4-ff96-49b2-8790-589cf2c40d5f): There are no data parts | ||
| 456 | 2024.10.31 00:14:52.621982 [ 275 ] {11adcd9e-f57c-49a2-aaca-ed80b0fd13cb} <Debug> TCPHandler: Processed in 0.003641497 sec. | ||
| 457 | 2024.10.31 00:14:52.622181 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 458 | 2024.10.31 00:14:52.622386 [ 271 ] {7ceedf87-8c9d-4e09-870e-c5e0f38186db} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 459 | 2024.10.31 00:14:52.622443 [ 271 ] {7ceedf87-8c9d-4e09-870e-c5e0f38186db} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 460 | 2024.10.31 00:14:52.624416 [ 271 ] {7ceedf87-8c9d-4e09-870e-c5e0f38186db} <Debug> oximeter.measurements_i64 (38547efd-d33f-466c-8f46-b17a52b793bc): Loading data parts | ||
| 461 | 2024.10.31 00:14:52.624588 [ 271 ] {7ceedf87-8c9d-4e09-870e-c5e0f38186db} <Debug> oximeter.measurements_i64 (38547efd-d33f-466c-8f46-b17a52b793bc): There are no data parts | ||
| 462 | 2024.10.31 00:14:52.625934 [ 271 ] {7ceedf87-8c9d-4e09-870e-c5e0f38186db} <Debug> TCPHandler: Processed in 0.003807049 sec. | ||
| 463 | 2024.10.31 00:14:52.626114 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 464 | 2024.10.31 00:14:52.626300 [ 275 ] {9de5b0bd-887b-47cf-954b-ac58c28a0a02} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 465 | 2024.10.31 00:14:52.626357 [ 275 ] {9de5b0bd-887b-47cf-954b-ac58c28a0a02} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 466 | 2024.10.31 00:14:52.628147 [ 275 ] {9de5b0bd-887b-47cf-954b-ac58c28a0a02} <Debug> oximeter.measurements_u64 (cf5b9241-8bcf-4bd0-a10f-41ae09e70939): Loading data parts | ||
| 467 | 2024.10.31 00:14:52.628315 [ 275 ] {9de5b0bd-887b-47cf-954b-ac58c28a0a02} <Debug> oximeter.measurements_u64 (cf5b9241-8bcf-4bd0-a10f-41ae09e70939): There are no data parts | ||
| 468 | 2024.10.31 00:14:52.629913 [ 275 ] {9de5b0bd-887b-47cf-954b-ac58c28a0a02} <Debug> TCPHandler: Processed in 0.003852029 sec. | ||
| 469 | 2024.10.31 00:14:52.630106 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 470 | 2024.10.31 00:14:52.630307 [ 271 ] {3756c21f-ff5c-4623-81ac-541c51b953c0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 471 | 2024.10.31 00:14:52.630363 [ 271 ] {3756c21f-ff5c-4623-81ac-541c51b953c0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 472 | 2024.10.31 00:14:52.632213 [ 271 ] {3756c21f-ff5c-4623-81ac-541c51b953c0} <Debug> oximeter.measurements_f32 (4ff46521-ee24-4cb4-9d19-e50527504257): Loading data parts | ||
| 473 | 2024.10.31 00:14:52.632377 [ 271 ] {3756c21f-ff5c-4623-81ac-541c51b953c0} <Debug> oximeter.measurements_f32 (4ff46521-ee24-4cb4-9d19-e50527504257): There are no data parts | ||
| 474 | 2024.10.31 00:14:52.633757 [ 271 ] {3756c21f-ff5c-4623-81ac-541c51b953c0} <Debug> TCPHandler: Processed in 0.003704078 sec. | ||
| 475 | 2024.10.31 00:14:52.633949 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 476 | 2024.10.31 00:14:52.634177 [ 275 ] {16b576ba-7ab5-4c52-89ae-6cf4db67a15b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 477 | 2024.10.31 00:14:52.634246 [ 275 ] {16b576ba-7ab5-4c52-89ae-6cf4db67a15b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 478 | 2024.10.31 00:14:52.636142 [ 275 ] {16b576ba-7ab5-4c52-89ae-6cf4db67a15b} <Debug> oximeter.measurements_f64 (e1531a99-4fdd-44a7-93ce-9ab0c760a9b4): Loading data parts | ||
| 479 | 2024.10.31 00:14:52.636318 [ 275 ] {16b576ba-7ab5-4c52-89ae-6cf4db67a15b} <Debug> oximeter.measurements_f64 (e1531a99-4fdd-44a7-93ce-9ab0c760a9b4): There are no data parts | ||
| 480 | 2024.10.31 00:14:52.637609 [ 275 ] {16b576ba-7ab5-4c52-89ae-6cf4db67a15b} <Debug> TCPHandler: Processed in 0.003722958 sec. | ||
| 481 | 2024.10.31 00:14:52.637789 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 482 | 2024.10.31 00:14:52.638024 [ 271 ] {7c57d6b5-1310-4f42-aac2-0298c7820cb3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 483 | 2024.10.31 00:14:52.638092 [ 271 ] {7c57d6b5-1310-4f42-aac2-0298c7820cb3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 484 | 2024.10.31 00:14:52.639883 [ 271 ] {7c57d6b5-1310-4f42-aac2-0298c7820cb3} <Debug> oximeter.measurements_string (c0c48cff-4e4a-4b4c-b521-d45e44974750): Loading data parts | ||
| 485 | 2024.10.31 00:14:52.640052 [ 271 ] {7c57d6b5-1310-4f42-aac2-0298c7820cb3} <Debug> oximeter.measurements_string (c0c48cff-4e4a-4b4c-b521-d45e44974750): There are no data parts | ||
| 486 | 2024.10.31 00:14:52.641404 [ 271 ] {7c57d6b5-1310-4f42-aac2-0298c7820cb3} <Debug> TCPHandler: Processed in 0.003667937 sec. | ||
| 487 | 2024.10.31 00:14:52.641599 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 488 | 2024.10.31 00:14:52.641787 [ 275 ] {93092b0f-9724-4cea-af76-2ea196f0ecb6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 489 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 490 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 491 | * a string isn't palatable for a few reasons. | ||
| 492 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 493 | * details. | ||
| 494 | */ | ||
| 495 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 496 | 2024.10.31 00:14:52.641846 [ 275 ] {93092b0f-9724-4cea-af76-2ea196f0ecb6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 497 | 2024.10.31 00:14:52.643880 [ 275 ] {93092b0f-9724-4cea-af76-2ea196f0ecb6} <Debug> oximeter.measurements_bytes (c4b0518e-7a11-49d9-b90f-2955425d62f2): Loading data parts | ||
| 498 | 2024.10.31 00:14:52.644059 [ 275 ] {93092b0f-9724-4cea-af76-2ea196f0ecb6} <Debug> oximeter.measurements_bytes (c4b0518e-7a11-49d9-b90f-2955425d62f2): There are no data parts | ||
| 499 | 2024.10.31 00:14:52.645372 [ 275 ] {93092b0f-9724-4cea-af76-2ea196f0ecb6} <Debug> TCPHandler: Processed in 0.00382443 sec. | ||
| 500 | 2024.10.31 00:14:52.645545 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 501 | 2024.10.31 00:14:52.645740 [ 271 ] {d1e5212d-fc10-46e2-9ab9-864c1fc7f104} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 502 | 2024.10.31 00:14:52.645801 [ 271 ] {d1e5212d-fc10-46e2-9ab9-864c1fc7f104} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 503 | 2024.10.31 00:14:52.647686 [ 271 ] {d1e5212d-fc10-46e2-9ab9-864c1fc7f104} <Debug> oximeter.measurements_cumulativei64 (9546b4c7-85f0-4446-b170-a9612629784a): Loading data parts | ||
| 504 | 2024.10.31 00:14:52.647865 [ 271 ] {d1e5212d-fc10-46e2-9ab9-864c1fc7f104} <Debug> oximeter.measurements_cumulativei64 (9546b4c7-85f0-4446-b170-a9612629784a): There are no data parts | ||
| 505 | 2024.10.31 00:14:52.649075 [ 271 ] {d1e5212d-fc10-46e2-9ab9-864c1fc7f104} <Debug> TCPHandler: Processed in 0.003581217 sec. | ||
| 506 | 2024.10.31 00:14:52.649259 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 507 | 2024.10.31 00:14:52.649495 [ 275 ] {a0e026e7-56b7-4b92-8d6e-b460cabf4355} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 508 | 2024.10.31 00:14:52.649569 [ 275 ] {a0e026e7-56b7-4b92-8d6e-b460cabf4355} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 509 | 2024.10.31 00:14:52.651549 [ 275 ] {a0e026e7-56b7-4b92-8d6e-b460cabf4355} <Debug> oximeter.measurements_cumulativeu64 (35ee8a77-1f0a-4c6b-8810-e24cf72127f0): Loading data parts | ||
| 510 | 2024.10.31 00:14:52.651725 [ 275 ] {a0e026e7-56b7-4b92-8d6e-b460cabf4355} <Debug> oximeter.measurements_cumulativeu64 (35ee8a77-1f0a-4c6b-8810-e24cf72127f0): There are no data parts | ||
| 511 | 2024.10.31 00:14:52.653066 [ 275 ] {a0e026e7-56b7-4b92-8d6e-b460cabf4355} <Debug> TCPHandler: Processed in 0.003858209 sec. | ||
| 512 | 2024.10.31 00:14:52.653245 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 513 | 2024.10.31 00:14:52.653485 [ 271 ] {423d590a-78b9-48a7-845b-73c1cbaee026} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 514 | 2024.10.31 00:14:52.653554 [ 271 ] {423d590a-78b9-48a7-845b-73c1cbaee026} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 515 | 2024.10.31 00:14:52.655436 [ 271 ] {423d590a-78b9-48a7-845b-73c1cbaee026} <Debug> oximeter.measurements_cumulativef32 (4bb73a1e-a9e3-4be3-9faf-b719dc168315): Loading data parts | ||
| 516 | 2024.10.31 00:14:52.655601 [ 271 ] {423d590a-78b9-48a7-845b-73c1cbaee026} <Debug> oximeter.measurements_cumulativef32 (4bb73a1e-a9e3-4be3-9faf-b719dc168315): There are no data parts | ||
| 517 | 2024.10.31 00:14:52.656836 [ 271 ] {423d590a-78b9-48a7-845b-73c1cbaee026} <Debug> TCPHandler: Processed in 0.003645007 sec. | ||
| 518 | 2024.10.31 00:14:52.657026 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 519 | 2024.10.31 00:14:52.657267 [ 275 ] {2d6d9c25-ccb5-4ab3-9a58-31b4c00e4be0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 520 | 2024.10.31 00:14:52.657341 [ 275 ] {2d6d9c25-ccb5-4ab3-9a58-31b4c00e4be0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 521 | 2024.10.31 00:14:52.659288 [ 275 ] {2d6d9c25-ccb5-4ab3-9a58-31b4c00e4be0} <Debug> oximeter.measurements_cumulativef64 (cf70d559-a427-4b29-a54c-ed74486d4834): Loading data parts | ||
| 522 | 2024.10.31 00:14:52.659439 [ 275 ] {2d6d9c25-ccb5-4ab3-9a58-31b4c00e4be0} <Debug> oximeter.measurements_cumulativef64 (cf70d559-a427-4b29-a54c-ed74486d4834): There are no data parts | ||
| 523 | 2024.10.31 00:14:52.660711 [ 275 ] {2d6d9c25-ccb5-4ab3-9a58-31b4c00e4be0} <Debug> TCPHandler: Processed in 0.003747709 sec. | ||
| 524 | 2024.10.31 00:14:52.660915 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 525 | 2024.10.31 00:14:52.661255 [ 271 ] {a8402de3-0f38-49d2-8ad8-e7c9eb32a798} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 526 | * NOTE: Array types cannot be Nullable, see | ||
| 527 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 528 | * for more details. | ||
| 529 | * | ||
| 530 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 531 | * is unfortunate, and at this point relies on the fact that an | ||
| 532 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 533 | * to figure out another way to represent missing samples here. | ||
| 534 | */ | ||
| 535 | 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) | ||
| 536 | 2024.10.31 00:14:52.661337 [ 271 ] {a8402de3-0f38-49d2-8ad8-e7c9eb32a798} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 537 | 2024.10.31 00:14:52.663391 [ 271 ] {a8402de3-0f38-49d2-8ad8-e7c9eb32a798} <Debug> oximeter.measurements_histogrami8 (81c64f03-4244-42fd-9b37-8ef7287931f9): Loading data parts | ||
| 538 | 2024.10.31 00:14:52.663539 [ 271 ] {a8402de3-0f38-49d2-8ad8-e7c9eb32a798} <Debug> oximeter.measurements_histogrami8 (81c64f03-4244-42fd-9b37-8ef7287931f9): There are no data parts | ||
| 539 | 2024.10.31 00:14:52.664874 [ 271 ] {a8402de3-0f38-49d2-8ad8-e7c9eb32a798} <Debug> TCPHandler: Processed in 0.004022552 sec. | ||
| 540 | 2024.10.31 00:14:52.665057 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 541 | 2024.10.31 00:14:52.665374 [ 275 ] {bcde88ed-b239-4f03-b805-29ffd2c6ed86} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 542 | 2024.10.31 00:14:52.665441 [ 275 ] {bcde88ed-b239-4f03-b805-29ffd2c6ed86} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 543 | 2024.10.31 00:14:52.667412 [ 275 ] {bcde88ed-b239-4f03-b805-29ffd2c6ed86} <Debug> oximeter.measurements_histogramu8 (edebeb20-d43b-46f5-bae5-7dd0ae312761): Loading data parts | ||
| 544 | 2024.10.31 00:14:52.667571 [ 275 ] {bcde88ed-b239-4f03-b805-29ffd2c6ed86} <Debug> oximeter.measurements_histogramu8 (edebeb20-d43b-46f5-bae5-7dd0ae312761): There are no data parts | ||
| 545 | 2024.10.31 00:14:52.668876 [ 275 ] {bcde88ed-b239-4f03-b805-29ffd2c6ed86} <Debug> TCPHandler: Processed in 0.00388301 sec. | ||
| 546 | 2024.10.31 00:14:52.669059 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 547 | 2024.10.31 00:14:52.669382 [ 271 ] {48afeb49-0319-4d63-b490-5f0ddae4520a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 548 | 2024.10.31 00:14:52.669448 [ 271 ] {48afeb49-0319-4d63-b490-5f0ddae4520a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 549 | 2024.10.31 00:14:52.671586 [ 271 ] {48afeb49-0319-4d63-b490-5f0ddae4520a} <Debug> oximeter.measurements_histogrami16 (9f42c5e7-c9ec-4864-b5bd-117a8dd5253a): Loading data parts | ||
| 550 | 2024.10.31 00:14:52.671757 [ 271 ] {48afeb49-0319-4d63-b490-5f0ddae4520a} <Debug> oximeter.measurements_histogrami16 (9f42c5e7-c9ec-4864-b5bd-117a8dd5253a): There are no data parts | ||
| 551 | 2024.10.31 00:14:52.673285 [ 271 ] {48afeb49-0319-4d63-b490-5f0ddae4520a} <Debug> TCPHandler: Processed in 0.004288754 sec. | ||
| 552 | 2024.10.31 00:14:52.673481 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 553 | 2024.10.31 00:14:52.673740 [ 275 ] {62313a96-b5d5-4ce1-b63d-b764ad94f090} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 554 | 2024.10.31 00:14:52.673808 [ 275 ] {62313a96-b5d5-4ce1-b63d-b764ad94f090} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 555 | 2024.10.31 00:14:52.676162 [ 275 ] {62313a96-b5d5-4ce1-b63d-b764ad94f090} <Debug> oximeter.measurements_histogramu16 (717e5dfa-77e6-4a95-a6ce-80de89c0e7de): Loading data parts | ||
| 556 | 2024.10.31 00:14:52.676344 [ 275 ] {62313a96-b5d5-4ce1-b63d-b764ad94f090} <Debug> oximeter.measurements_histogramu16 (717e5dfa-77e6-4a95-a6ce-80de89c0e7de): There are no data parts | ||
| 557 | 2024.10.31 00:14:52.677815 [ 275 ] {62313a96-b5d5-4ce1-b63d-b764ad94f090} <Debug> TCPHandler: Processed in 0.004386015 sec. | ||
| 558 | 2024.10.31 00:14:52.677997 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 559 | 2024.10.31 00:14:52.678282 [ 271 ] {17efc91c-0f3b-4a93-8488-05eb0b9080a2} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 560 | 2024.10.31 00:14:52.678347 [ 271 ] {17efc91c-0f3b-4a93-8488-05eb0b9080a2} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 561 | 2024.10.31 00:14:52.680545 [ 271 ] {17efc91c-0f3b-4a93-8488-05eb0b9080a2} <Debug> oximeter.measurements_histogrami32 (49adcba1-22c6-4588-b089-abf564225d74): Loading data parts | ||
| 562 | 2024.10.31 00:14:52.680744 [ 271 ] {17efc91c-0f3b-4a93-8488-05eb0b9080a2} <Debug> oximeter.measurements_histogrami32 (49adcba1-22c6-4588-b089-abf564225d74): There are no data parts | ||
| 563 | 2024.10.31 00:14:52.682706 [ 271 ] {17efc91c-0f3b-4a93-8488-05eb0b9080a2} <Debug> TCPHandler: Processed in 0.004761549 sec. | ||
| 564 | 2024.10.31 00:14:52.682889 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 565 | 2024.10.31 00:14:52.683157 [ 275 ] {06994d30-37bc-46da-9436-36590c5ab119} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 566 | 2024.10.31 00:14:52.683239 [ 275 ] {06994d30-37bc-46da-9436-36590c5ab119} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 567 | 2024.10.31 00:14:52.685648 [ 275 ] {06994d30-37bc-46da-9436-36590c5ab119} <Debug> oximeter.measurements_histogramu32 (9f6e5635-e9a5-44d6-a0e5-9b7fcca3a963): Loading data parts | ||
| 568 | 2024.10.31 00:14:52.685878 [ 275 ] {06994d30-37bc-46da-9436-36590c5ab119} <Debug> oximeter.measurements_histogramu32 (9f6e5635-e9a5-44d6-a0e5-9b7fcca3a963): There are no data parts | ||
| 569 | 2024.10.31 00:14:52.687199 [ 275 ] {06994d30-37bc-46da-9436-36590c5ab119} <Debug> TCPHandler: Processed in 0.004363235 sec. | ||
| 570 | 2024.10.31 00:14:52.687456 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 571 | 2024.10.31 00:14:52.687746 [ 271 ] {eb9c93fa-5996-4dbe-9edd-bcdee4e4e6a3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 572 | 2024.10.31 00:14:52.687820 [ 271 ] {eb9c93fa-5996-4dbe-9edd-bcdee4e4e6a3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 573 | 2024.10.31 00:14:52.689968 [ 271 ] {eb9c93fa-5996-4dbe-9edd-bcdee4e4e6a3} <Debug> oximeter.measurements_histogrami64 (ce12d6de-29de-4a21-a2bf-a57502507a07): Loading data parts | ||
| 574 | 2024.10.31 00:14:52.690153 [ 271 ] {eb9c93fa-5996-4dbe-9edd-bcdee4e4e6a3} <Debug> oximeter.measurements_histogrami64 (ce12d6de-29de-4a21-a2bf-a57502507a07): There are no data parts | ||
| 575 | 2024.10.31 00:14:52.691607 [ 271 ] {eb9c93fa-5996-4dbe-9edd-bcdee4e4e6a3} <Debug> TCPHandler: Processed in 0.004206963 sec. | ||
| 576 | 2024.10.31 00:14:52.691787 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 577 | 2024.10.31 00:14:52.692048 [ 275 ] {59a1691d-f6d6-4d7c-bba4-f44a9a7c1451} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 578 | 2024.10.31 00:14:52.692123 [ 275 ] {59a1691d-f6d6-4d7c-bba4-f44a9a7c1451} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 579 | 2024.10.31 00:14:52.694184 [ 275 ] {59a1691d-f6d6-4d7c-bba4-f44a9a7c1451} <Debug> oximeter.measurements_histogramu64 (c945c84a-956e-4040-8e90-3a98d596e25b): Loading data parts | ||
| 580 | 2024.10.31 00:14:52.694368 [ 275 ] {59a1691d-f6d6-4d7c-bba4-f44a9a7c1451} <Debug> oximeter.measurements_histogramu64 (c945c84a-956e-4040-8e90-3a98d596e25b): There are no data parts | ||
| 581 | 2024.10.31 00:14:52.695767 [ 275 ] {59a1691d-f6d6-4d7c-bba4-f44a9a7c1451} <Debug> TCPHandler: Processed in 0.004030102 sec. | ||
| 582 | 2024.10.31 00:14:52.695948 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 583 | 2024.10.31 00:14:52.696236 [ 271 ] {8dece1fe-bbaa-4fff-ab34-f688fc2bf6b3} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 584 | 2024.10.31 00:14:52.696307 [ 271 ] {8dece1fe-bbaa-4fff-ab34-f688fc2bf6b3} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 585 | 2024.10.31 00:14:52.698534 [ 271 ] {8dece1fe-bbaa-4fff-ab34-f688fc2bf6b3} <Debug> oximeter.measurements_histogramf32 (e6c31cf4-c79c-4ff3-876d-71a1120bbf29): Loading data parts | ||
| 586 | 2024.10.31 00:14:52.698712 [ 271 ] {8dece1fe-bbaa-4fff-ab34-f688fc2bf6b3} <Debug> oximeter.measurements_histogramf32 (e6c31cf4-c79c-4ff3-876d-71a1120bbf29): There are no data parts | ||
| 587 | 2024.10.31 00:14:52.700037 [ 271 ] {8dece1fe-bbaa-4fff-ab34-f688fc2bf6b3} <Debug> TCPHandler: Processed in 0.004144583 sec. | ||
| 588 | 2024.10.31 00:14:52.700212 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 589 | 2024.10.31 00:14:52.700507 [ 275 ] {aadf65ed-2ff5-4559-869e-64d208f1de1a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 590 | 2024.10.31 00:14:52.700591 [ 275 ] {aadf65ed-2ff5-4559-869e-64d208f1de1a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 591 | 2024.10.31 00:14:52.702818 [ 275 ] {aadf65ed-2ff5-4559-869e-64d208f1de1a} <Debug> oximeter.measurements_histogramf64 (59a26198-bf21-4c9e-9de3-0ed1b322ff7f): Loading data parts | ||
| 592 | 2024.10.31 00:14:52.703023 [ 275 ] {aadf65ed-2ff5-4559-869e-64d208f1de1a} <Debug> oximeter.measurements_histogramf64 (59a26198-bf21-4c9e-9de3-0ed1b322ff7f): There are no data parts | ||
| 593 | 2024.10.31 00:14:52.704380 [ 275 ] {aadf65ed-2ff5-4559-869e-64d208f1de1a} <Debug> TCPHandler: Processed in 0.004218673 sec. | ||
| 594 | 2024.10.31 00:14:52.704581 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 595 | 2024.10.31 00:14:52.704839 [ 271 ] {315d4f06-838c-46d1-af57-44887f65d3dd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) /* The field tables store named dimensions of each timeseries. | ||
| 596 | * | ||
| 597 | * As with the measurement tables, there is one field table for each field data | ||
| 598 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 599 | * this behavior **must not** be relied upon for query correctness. | ||
| 600 | * | ||
| 601 | * The index for the fields differs from the measurements, however. Rows are | ||
| 602 | * sorted by timeseries name, then field name, field value, and finally | ||
| 603 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 604 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 605 | * usually then used to look up measurements. | ||
| 606 | * | ||
| 607 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 608 | * timeseries name and then key, since it would improve lookups where one | ||
| 609 | * already has the key. Realistically though, these tables are quite small and | ||
| 610 | * so performance benefits will be low in absolute terms. | ||
| 611 | * | ||
| 612 | * TTL: We use a materialized column to expire old field table records. This | ||
| 613 | * column is generated automatically by the database whenever a new row is | ||
| 614 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 615 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 616 | * record will remain during a deduplication, which will have the last | ||
| 617 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 618 | * measurement tables. | ||
| 619 | */ | ||
| 620 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 621 | 2024.10.31 00:14:52.704918 [ 271 ] {315d4f06-838c-46d1-af57-44887f65d3dd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 622 | 2024.10.31 00:14:52.706949 [ 271 ] {315d4f06-838c-46d1-af57-44887f65d3dd} <Debug> oximeter.fields_bool (56805fdf-7edd-411d-9a23-7015d37939ad): Loading data parts | ||
| 623 | 2024.10.31 00:14:52.707126 [ 271 ] {315d4f06-838c-46d1-af57-44887f65d3dd} <Debug> oximeter.fields_bool (56805fdf-7edd-411d-9a23-7015d37939ad): There are no data parts | ||
| 624 | 2024.10.31 00:14:52.708435 [ 271 ] {315d4f06-838c-46d1-af57-44887f65d3dd} <Debug> TCPHandler: Processed in 0.003919311 sec. | ||
| 625 | 2024.10.31 00:14:52.708665 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 626 | 2024.10.31 00:14:52.708897 [ 275 ] {5d779c19-58fa-4876-83e2-2a7ff9475199} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 627 | 2024.10.31 00:14:52.708973 [ 275 ] {5d779c19-58fa-4876-83e2-2a7ff9475199} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 628 | 2024.10.31 00:14:52.710900 [ 275 ] {5d779c19-58fa-4876-83e2-2a7ff9475199} <Debug> oximeter.fields_i8 (544f42d8-bafe-416a-b86e-fda3831a4b9c): Loading data parts | ||
| 629 | 2024.10.31 00:14:52.711086 [ 275 ] {5d779c19-58fa-4876-83e2-2a7ff9475199} <Debug> oximeter.fields_i8 (544f42d8-bafe-416a-b86e-fda3831a4b9c): There are no data parts | ||
| 630 | 2024.10.31 00:14:52.712290 [ 275 ] {5d779c19-58fa-4876-83e2-2a7ff9475199} <Debug> TCPHandler: Processed in 0.003685568 sec. | ||
| 631 | 2024.10.31 00:14:52.712522 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 632 | 2024.10.31 00:14:52.712739 [ 271 ] {039569e9-3501-447c-b645-cfd57d254418} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 633 | 2024.10.31 00:14:52.712797 [ 271 ] {039569e9-3501-447c-b645-cfd57d254418} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 634 | 2024.10.31 00:14:52.714670 [ 271 ] {039569e9-3501-447c-b645-cfd57d254418} <Debug> oximeter.fields_u8 (3764f3b1-824a-46e1-a903-18370faa6fe2): Loading data parts | ||
| 635 | 2024.10.31 00:14:52.714903 [ 271 ] {039569e9-3501-447c-b645-cfd57d254418} <Debug> oximeter.fields_u8 (3764f3b1-824a-46e1-a903-18370faa6fe2): There are no data parts | ||
| 636 | 2024.10.31 00:14:52.716182 [ 271 ] {039569e9-3501-447c-b645-cfd57d254418} <Debug> TCPHandler: Processed in 0.003710608 sec. | ||
| 637 | 2024.10.31 00:14:52.716381 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 638 | 2024.10.31 00:14:52.716569 [ 275 ] {86dc7aa2-5211-4ce4-a012-9eaf8d5b36c6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 639 | 2024.10.31 00:14:52.716631 [ 275 ] {86dc7aa2-5211-4ce4-a012-9eaf8d5b36c6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 640 | 2024.10.31 00:14:52.718523 [ 275 ] {86dc7aa2-5211-4ce4-a012-9eaf8d5b36c6} <Debug> oximeter.fields_i16 (92a678b2-f462-4e56-8d5d-3e839b47526d): Loading data parts | ||
| 641 | 2024.10.31 00:14:52.718700 [ 275 ] {86dc7aa2-5211-4ce4-a012-9eaf8d5b36c6} <Debug> oximeter.fields_i16 (92a678b2-f462-4e56-8d5d-3e839b47526d): There are no data parts | ||
| 642 | 2024.10.31 00:14:52.720108 [ 275 ] {86dc7aa2-5211-4ce4-a012-9eaf8d5b36c6} <Debug> TCPHandler: Processed in 0.003780789 sec. | ||
| 643 | 2024.10.31 00:14:52.720285 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 644 | 2024.10.31 00:14:52.720491 [ 271 ] {b702ae66-fef3-4736-93d4-e7fe09f2ea37} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 645 | 2024.10.31 00:14:52.720550 [ 271 ] {b702ae66-fef3-4736-93d4-e7fe09f2ea37} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 646 | 2024.10.31 00:14:52.722586 [ 271 ] {b702ae66-fef3-4736-93d4-e7fe09f2ea37} <Debug> oximeter.fields_u16 (e080c0b6-347a-46e3-b6d8-70cf83f8a1a6): Loading data parts | ||
| 647 | 2024.10.31 00:14:52.722763 [ 271 ] {b702ae66-fef3-4736-93d4-e7fe09f2ea37} <Debug> oximeter.fields_u16 (e080c0b6-347a-46e3-b6d8-70cf83f8a1a6): There are no data parts | ||
| 648 | 2024.10.31 00:14:52.724374 [ 271 ] {b702ae66-fef3-4736-93d4-e7fe09f2ea37} <Debug> TCPHandler: Processed in 0.004141333 sec. | ||
| 649 | 2024.10.31 00:14:52.724568 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 650 | 2024.10.31 00:14:52.724760 [ 275 ] {fd9b502f-c178-429e-b761-4b8736299964} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 651 | 2024.10.31 00:14:52.724820 [ 275 ] {fd9b502f-c178-429e-b761-4b8736299964} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 652 | 2024.10.31 00:14:52.726658 [ 275 ] {fd9b502f-c178-429e-b761-4b8736299964} <Debug> oximeter.fields_i32 (ee2daf02-9122-4f1f-9721-8237189c701f): Loading data parts | ||
| 653 | 2024.10.31 00:14:52.726850 [ 275 ] {fd9b502f-c178-429e-b761-4b8736299964} <Debug> oximeter.fields_i32 (ee2daf02-9122-4f1f-9721-8237189c701f): There are no data parts | ||
| 654 | 2024.10.31 00:14:52.729152 [ 275 ] {fd9b502f-c178-429e-b761-4b8736299964} <Debug> TCPHandler: Processed in 0.004637928 sec. | ||
| 655 | 2024.10.31 00:14:52.729340 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 656 | 2024.10.31 00:14:52.729620 [ 271 ] {b1369546-6785-42a2-93fa-2705576a614f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 657 | 2024.10.31 00:14:52.729708 [ 271 ] {b1369546-6785-42a2-93fa-2705576a614f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 658 | 2024.10.31 00:14:52.732409 [ 271 ] {b1369546-6785-42a2-93fa-2705576a614f} <Debug> oximeter.fields_u32 (24d4c6e9-8952-46c5-a6fc-30225229ff29): Loading data parts | ||
| 659 | 2024.10.31 00:14:52.732586 [ 271 ] {b1369546-6785-42a2-93fa-2705576a614f} <Debug> oximeter.fields_u32 (24d4c6e9-8952-46c5-a6fc-30225229ff29): There are no data parts | ||
| 660 | 2024.10.31 00:14:52.733881 [ 271 ] {b1369546-6785-42a2-93fa-2705576a614f} <Debug> TCPHandler: Processed in 0.004596737 sec. | ||
| 661 | 2024.10.31 00:14:52.734062 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 662 | 2024.10.31 00:14:52.734255 [ 275 ] {6bf5c952-d649-49e9-80a1-6aa85b8a8513} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 663 | 2024.10.31 00:14:52.734323 [ 275 ] {6bf5c952-d649-49e9-80a1-6aa85b8a8513} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 664 | 2024.10.31 00:14:52.736590 [ 275 ] {6bf5c952-d649-49e9-80a1-6aa85b8a8513} <Debug> oximeter.fields_i64 (1226b13b-69de-42fc-b8ca-f0bbf20ef20b): Loading data parts | ||
| 665 | 2024.10.31 00:14:52.736793 [ 275 ] {6bf5c952-d649-49e9-80a1-6aa85b8a8513} <Debug> oximeter.fields_i64 (1226b13b-69de-42fc-b8ca-f0bbf20ef20b): There are no data parts | ||
| 666 | 2024.10.31 00:14:52.738540 [ 275 ] {6bf5c952-d649-49e9-80a1-6aa85b8a8513} <Debug> TCPHandler: Processed in 0.004529686 sec. | ||
| 667 | 2024.10.31 00:14:52.738729 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 668 | 2024.10.31 00:14:52.738948 [ 271 ] {9bebd746-6f5e-4378-90e9-1b1a3404a723} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 669 | 2024.10.31 00:14:52.739010 [ 271 ] {9bebd746-6f5e-4378-90e9-1b1a3404a723} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 670 | 2024.10.31 00:14:52.741448 [ 271 ] {9bebd746-6f5e-4378-90e9-1b1a3404a723} <Debug> oximeter.fields_u64 (f3a983e5-849e-4a37-8609-b62680a6a78b): Loading data parts | ||
| 671 | 2024.10.31 00:14:52.741622 [ 271 ] {9bebd746-6f5e-4378-90e9-1b1a3404a723} <Debug> oximeter.fields_u64 (f3a983e5-849e-4a37-8609-b62680a6a78b): There are no data parts | ||
| 672 | 2024.10.31 00:14:52.743324 [ 271 ] {9bebd746-6f5e-4378-90e9-1b1a3404a723} <Debug> TCPHandler: Processed in 0.004646878 sec. | ||
| 673 | 2024.10.31 00:14:52.743510 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 674 | 2024.10.31 00:14:52.743701 [ 275 ] {6b351ad5-2393-48b9-9795-f304eefa6954} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 675 | 2024.10.31 00:14:52.743769 [ 275 ] {6b351ad5-2393-48b9-9795-f304eefa6954} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 676 | 2024.10.31 00:14:52.746174 [ 275 ] {6b351ad5-2393-48b9-9795-f304eefa6954} <Debug> oximeter.fields_ipaddr (8d8d6f90-b921-4e61-8fc0-9d1c09cbaae5): Loading data parts | ||
| 677 | 2024.10.31 00:14:52.746355 [ 275 ] {6b351ad5-2393-48b9-9795-f304eefa6954} <Debug> oximeter.fields_ipaddr (8d8d6f90-b921-4e61-8fc0-9d1c09cbaae5): There are no data parts | ||
| 678 | 2024.10.31 00:14:52.748510 [ 275 ] {6b351ad5-2393-48b9-9795-f304eefa6954} <Debug> TCPHandler: Processed in 0.005052732 sec. | ||
| 679 | 2024.10.31 00:14:52.748706 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 680 | 2024.10.31 00:14:52.748923 [ 271 ] {8d0bbbc9-baff-4bf4-9763-92f5127a9a76} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) 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) | ||
| 681 | 2024.10.31 00:14:52.748983 [ 271 ] {8d0bbbc9-baff-4bf4-9763-92f5127a9a76} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 682 | 2024.10.31 00:14:52.751496 [ 271 ] {8d0bbbc9-baff-4bf4-9763-92f5127a9a76} <Debug> oximeter.fields_string (5d354162-51a3-43f5-8a97-d2f1823a33be): Loading data parts | ||
| 683 | 2024.10.31 00:14:52.751657 [ 271 ] {8d0bbbc9-baff-4bf4-9763-92f5127a9a76} <Debug> oximeter.fields_string (5d354162-51a3-43f5-8a97-d2f1823a33be): There are no data parts | ||
| 684 | 2024.10.31 00:14:52.752950 [ 271 ] {8d0bbbc9-baff-4bf4-9763-92f5127a9a76} <Debug> TCPHandler: Processed in 0.004299004 sec. | ||
| 685 | 2024.10.31 00:14:52.753138 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 686 | 2024.10.31 00:14:52.753370 [ 275 ] {4afffb47-fbdc-461b-b828-bf3fb175a776} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) 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) | ||
| 687 | 2024.10.31 00:14:52.753454 [ 275 ] {4afffb47-fbdc-461b-b828-bf3fb175a776} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 688 | 2024.10.31 00:14:52.755593 [ 275 ] {4afffb47-fbdc-461b-b828-bf3fb175a776} <Debug> oximeter.fields_uuid (22895ecb-10ca-4df2-b774-8765b85ff45d): Loading data parts | ||
| 689 | 2024.10.31 00:14:52.755749 [ 275 ] {4afffb47-fbdc-461b-b828-bf3fb175a776} <Debug> oximeter.fields_uuid (22895ecb-10ca-4df2-b774-8765b85ff45d): There are no data parts | ||
| 690 | 2024.10.31 00:14:52.756949 [ 275 ] {4afffb47-fbdc-461b-b828-bf3fb175a776} <Debug> TCPHandler: Processed in 0.003874909 sec. | ||
| 691 | 2024.10.31 00:14:52.757137 [ 271 ] {} <Trace> TCP-Session: e9910785-6690-41fc-bc88-a27ebdbf6d75 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 692 | 2024.10.31 00:14:52.757409 [ 271 ] {04e2d083-fb7c-4a19-a959-1e2555090d03} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:35209) /* The timeseries schema table stores the extracted schema for the samples | ||
| 693 | * oximeter collects. | ||
| 694 | */ | ||
| 695 | 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) | ||
| 696 | 2024.10.31 00:14:52.757484 [ 271 ] {04e2d083-fb7c-4a19-a959-1e2555090d03} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 697 | 2024.10.31 00:14:52.759357 [ 271 ] {04e2d083-fb7c-4a19-a959-1e2555090d03} <Debug> oximeter.timeseries_schema (6ddf67a1-ebc2-44e9-b061-31676a324446): Loading data parts | ||
| 698 | 2024.10.31 00:14:52.759538 [ 271 ] {04e2d083-fb7c-4a19-a959-1e2555090d03} <Debug> oximeter.timeseries_schema (6ddf67a1-ebc2-44e9-b061-31676a324446): There are no data parts | ||
| 699 | 2024.10.31 00:14:52.760921 [ 271 ] {04e2d083-fb7c-4a19-a959-1e2555090d03} <Debug> TCPHandler: Processed in 0.003835749 sec. | ||
| 700 | 2024.10.31 00:14:52.761124 [ 275 ] {} <Trace> TCP-Session: ddc494ba-8ddf-44f9-8aff-aa811d8d4ddb Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 701 | 2024.10.31 00:14:52.761349 [ 275 ] {52304f17-7b35-48ac-aa3e-5f2d6f3b36ba} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:43717) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 702 | 2024.10.31 00:14:52.762084 [ 275 ] {52304f17-7b35-48ac-aa3e-5f2d6f3b36ba} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 703 | 2024.10.31 00:14:52.770091 [ 281 ] {52304f17-7b35-48ac-aa3e-5f2d6f3b36ba} <Trace> oximeter.version (76b7c84e-4c04-4980-a43e-870dab81e38f): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 704 | 2024.10.31 00:14:52.770182 [ 281 ] {52304f17-7b35-48ac-aa3e-5f2d6f3b36ba} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.29 GiB. | ||
| 705 | 2024.10.31 00:14:52.774745 [ 281 ] {52304f17-7b35-48ac-aa3e-5f2d6f3b36ba} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 706 | 2024.10.31 00:14:52.775797 [ 281 ] {52304f17-7b35-48ac-aa3e-5f2d6f3b36ba} <Trace> oximeter.version (76b7c84e-4c04-4980-a43e-870dab81e38f): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 707 | 2024.10.31 00:14:52.776126 [ 275 ] {52304f17-7b35-48ac-aa3e-5f2d6f3b36ba} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.014857 sec., 67.30833950326445 rows/sec., 1.05 KiB/sec. | ||
| 708 | 2024.10.31 00:14:52.776394 [ 275 ] {52304f17-7b35-48ac-aa3e-5f2d6f3b36ba} <Debug> TCPHandler: Processed in 0.015333798 sec. | ||
| 709 | 2024.10.31 00:14:53.000165 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 126.89 MiB, peak 126.89 MiB, free memory in arenas 0.00 B, will set to 139.96 MiB (RSS), difference: 13.07 MiB | ||
| 710 | 2024.10.31 00:14:58.374886 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 90 entries to flush up to offset 90 | ||
| 711 | 2024.10.31 00:14:58.374987 [ 242 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
| 712 | 2024.10.31 00:14:58.380503 [ 242 ] {} <Debug> system.query_log (5adcade9-2e2b-453f-b9be-45d98a026632): Loading data parts | ||
| 713 | 2024.10.31 00:14:58.380759 [ 242 ] {} <Debug> system.query_log (5adcade9-2e2b-453f-b9be-45d98a026632): There are no data parts | ||
| 714 | 2024.10.31 00:14:58.393191 [ 242 ] {} <Trace> system.query_log (5adcade9-2e2b-453f-b9be-45d98a026632): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 715 | 2024.10.31 00:14:58.393232 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.28 GiB. | ||
| 716 | 2024.10.31 00:14:58.397331 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 717 | 2024.10.31 00:14:58.398378 [ 242 ] {} <Trace> system.query_log (5adcade9-2e2b-453f-b9be-45d98a026632): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 718 | 2024.10.31 00:14:58.398839 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 90 | ||
| 719 | 2024.10.31 00:14:59.000165 [ 244 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 144.31 MiB, peak 144.31 MiB, free memory in arenas 0.00 B, will set to 141.93 MiB (RSS), difference: -2.39 MiB | ||