| 1 | [ Feb 28 10:59:47 Enabled. ] | ||
| 2 | [ Feb 28 10:59:47 Rereading configuration. ] | ||
| 3 | [ Feb 28 10:59:48 Rereading configuration. ] | ||
| 4 | [ Feb 28 10:59:51 Executing start method ("/opt/oxide/lib/svc/manifest/clickhouse.sh"). ] | ||
| 5 | + set -o errexit | ||
| 6 | + set -o pipefail | ||
| 7 | + . /lib/svc/share/smf_include.sh | ||
| 8 | ++ SMF_EXIT_OK=0 | ||
| 9 | ++ SMF_EXIT_NODAEMON=94 | ||
| 10 | ++ SMF_EXIT_ERR_FATAL=95 | ||
| 11 | ++ SMF_EXIT_ERR_CONFIG=96 | ||
| 12 | ++ SMF_EXIT_MON_DEGRADE=97 | ||
| 13 | ++ SMF_EXIT_MON_OFFLINE=98 | ||
| 14 | ++ SMF_EXIT_ERR_NOSMF=99 | ||
| 15 | ++ SMF_EXIT_ERR_PERM=100 | ||
| 16 | ++ svcprop -c -p config/listen_addr svc:/oxide/clickhouse:default | ||
| 17 | + LISTEN_ADDR=fd00:1122:3344:101::e | ||
| 18 | ++ svcprop -c -p config/listen_port svc:/oxide/clickhouse:default | ||
| 19 | + LISTEN_PORT=8123 | ||
| 20 | ++ svcprop -c -p config/store svc:/oxide/clickhouse:default | ||
| 21 | + DATASTORE=/data | ||
| 22 | + args=("--config-file" "/opt/oxide/clickhouse/config.xml" "--" "--path" "${DATASTORE}" "--listen_host" "$LISTEN_ADDR" "--http_port" "$LISTEN_PORT") | ||
| 23 | + exec /opt/oxide/clickhouse/clickhouse server --config-file /opt/oxide/clickhouse/config.xml -- --path /data --listen_host fd00:1122:3344:101::e --http_port 8123 | ||
| 24 | [ Feb 28 10:59:51 Method "start" exited with status 0. ] | ||
| 25 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 26 | Logging trace to /var/tmp/clickhouse-server.log | ||
| 27 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
| 28 | 2025.02.28 10:59:52.036676 [ 1 ] {} <Information> Application: Will watch for the process with pid 23046 | ||
| 29 | 2025.02.28 10:59:52.037236 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 30 | 2025.02.28 10:59:52.263556 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 23046 | ||
| 31 | 2025.02.28 10:59:52.264286 [ 1 ] {} <Information> Application: starting up | ||
| 32 | 2025.02.28 10:59:52.264968 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 33 | 2025.02.28 10:59:52.351468 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
| 34 | 2025.02.28 10:59:52.412577 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 35 | 2025.02.28 10:59:52.412633 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 36 | 2025.02.28 10:59:52.412649 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 37 | 2025.02.28 10:59:52.412722 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
| 38 | 2025.02.28 10:59:52.413159 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 39 | 2025.02.28 10:59:52.414840 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
| 40 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 41 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 42 | 2025.02.28 10:59:52.415991 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 43 | 2025.02.28 10:59:52.416843 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 44 | 2025.02.28 10:59:52.416864 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 45 | 2025.02.28 10:59:52.416879 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
| 46 | 2025.02.28 10:59:52.417051 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 47 | 2025.02.28 10:59:52.418022 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 48 | 2025.02.28 10:59:52.423767 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 49 | 2025.02.28 10:59:52.424411 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 50 | 2025.02.28 10:59:52.425703 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 51 | 2025.02.28 10:59:52.425765 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 52 | 2025.02.28 10:59:52.427371 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
| 53 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 54 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 55 | 2025.02.28 10:59:52.427844 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 56 | 2025.02.28 10:59:52.431809 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 57 | 2025.02.28 10:59:52.432170 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml | ||
| 58 | 2025.02.28 10:59:52.433688 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 59 | 2025.02.28 10:59:52.434095 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 60 | 2025.02.28 10:59:52.434410 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 61 | 2025.02.28 10:59:52.434848 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 62 | 2025.02.28 10:59:52.436189 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 63 | 2025.02.28 10:59:52.436214 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 64 | 2025.02.28 10:59:52.436287 [ 150 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 65 | 2025.02.28 10:59:52.436465 [ 150 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 66 | 2025.02.28 10:59:52.473741 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 67 | 2025.02.28 10:59:52.473772 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000179631 sec | ||
| 68 | 2025.02.28 10:59:52.473824 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 69 | 2025.02.28 10:59:52.473841 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 70 | 2025.02.28 10:59:52.475118 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 71 | 2025.02.28 10:59:52.475705 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 72 | 2025.02.28 10:59:52.488482 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 73 | 2025.02.28 10:59:52.488536 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 74 | 2025.02.28 10:59:52.488559 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 75 | 2025.02.28 10:59:52.488571 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 76 | 2025.02.28 10:59:52.488605 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 77 | 2025.02.28 10:59:52.488625 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 78 | 2025.02.28 10:59:52.491328 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 79 | 2025.02.28 10:59:52.491379 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 80 | 2025.02.28 10:59:52.491405 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 81 | 2025.02.28 10:59:52.491592 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 82 | 2025.02.28 10:59:52.491611 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 83 | 2025.02.28 10:59:52.491650 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 84 | 2025.02.28 10:59:52.491671 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 85 | 2025.02.28 10:59:52.491684 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 86 | 2025.02.28 10:59:52.491715 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 87 | 2025.02.28 10:59:52.491733 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 88 | 2025.02.28 10:59:52.519082 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 89 | 2025.02.28 10:59:52.543757 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 90 | 2025.02.28 10:59:52.543807 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.974e-05 sec | ||
| 91 | 2025.02.28 10:59:52.543831 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 92 | 2025.02.28 10:59:52.543849 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 93 | 2025.02.28 10:59:52.543887 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 94 | 2025.02.28 10:59:52.544161 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
| 95 | 2025.02.28 10:59:52.544223 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 96 | 2025.02.28 10:59:52.544243 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 97 | 2025.02.28 10:59:52.544260 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
| 98 | 2025.02.28 10:59:52.544278 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 99 | 2025.02.28 10:59:52.563635 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 100 | 2025.02.28 10:59:52.563827 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.77 MiB, peak 24.77 MiB, free memory in arenas 0.00 B, will set to 117.13 MiB (RSS), difference: 92.35 MiB | ||
| 101 | 2025.02.28 10:59:52.564809 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.199e-05 sec. | ||
| 102 | 2025.02.28 10:59:52.565726 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 103 | 2025.02.28 10:59:52.565819 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 104 | 2025.02.28 10:59:52.565846 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 105 | 2025.02.28 10:59:52.853057 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:63784 | ||
| 106 | 2025.02.28 10:59:52.853408 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2025.02.28 10:59:52.853492 [ 3 ] {} <Debug> TCP-Session: 682ac8da-205b-454e-a724-89b30e2f407d Authenticating user 'default' from [fd00:1122:3344:101::a]:63784 | ||
| 108 | 2025.02.28 10:59:52.853526 [ 3 ] {} <Debug> TCP-Session: 682ac8da-205b-454e-a724-89b30e2f407d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2025.02.28 10:59:52.853548 [ 3 ] {} <Debug> TCP-Session: 682ac8da-205b-454e-a724-89b30e2f407d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2025.02.28 10:59:52.853632 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 111 | 2025.02.28 10:59:52.853659 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 112 | 2025.02.28 10:59:52.853682 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 113 | 2025.02.28 10:59:52.854501 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:38381 | ||
| 114 | 2025.02.28 10:59:52.854625 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 115 | 2025.02.28 10:59:52.854658 [ 4 ] {} <Debug> TCP-Session: bbf56074-8e9e-4dd0-9307-05ddcb686ad5 Authenticating user 'default' from [fd00:1122:3344:101::a]:38381 | ||
| 116 | 2025.02.28 10:59:52.854686 [ 4 ] {} <Debug> TCP-Session: bbf56074-8e9e-4dd0-9307-05ddcb686ad5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 117 | 2025.02.28 10:59:52.854718 [ 4 ] {} <Debug> TCP-Session: bbf56074-8e9e-4dd0-9307-05ddcb686ad5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 118 | 2025.02.28 10:59:52.855630 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:57829 | ||
| 119 | 2025.02.28 10:59:52.855639 [ 253 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:60476 | ||
| 120 | 2025.02.28 10:59:52.855719 [ 254 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:33057 | ||
| 121 | 2025.02.28 10:59:52.855752 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 122 | 2025.02.28 10:59:52.855960 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:58008 | ||
| 123 | 2025.02.28 10:59:52.856062 [ 254 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 124 | 2025.02.28 10:59:52.856082 [ 5 ] {} <Debug> TCP-Session: 077b353b-2144-4bc6-b738-688b94c43dc9 Authenticating user 'default' from [fd00:1122:3344:101::a]:57829 | ||
| 125 | 2025.02.28 10:59:52.856099 [ 253 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 126 | 2025.02.28 10:59:52.856264 [ 253 ] {} <Debug> TCP-Session: 5eeb76b2-7b6b-44ea-a792-0a65e255a76d Authenticating user 'default' from [fd00:1122:3344:101::a]:60476 | ||
| 127 | 2025.02.28 10:59:52.856274 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 128 | 2025.02.28 10:59:52.856296 [ 5 ] {} <Debug> TCP-Session: 077b353b-2144-4bc6-b738-688b94c43dc9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 129 | 2025.02.28 10:59:52.856307 [ 254 ] {} <Debug> TCP-Session: adf77f81-7684-46a3-b3ef-f9e4b154f20a Authenticating user 'default' from [fd00:1122:3344:101::a]:33057 | ||
| 130 | 2025.02.28 10:59:52.856271 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:53519 | ||
| 131 | 2025.02.28 10:59:52.856348 [ 253 ] {} <Debug> TCP-Session: 5eeb76b2-7b6b-44ea-a792-0a65e255a76d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 132 | 2025.02.28 10:59:52.856384 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:61644 | ||
| 133 | 2025.02.28 10:59:52.856415 [ 255 ] {} <Debug> TCP-Session: dac390ab-1726-429d-9167-fd3f3e02821e Authenticating user 'default' from [fd00:1122:3344:101::a]:58008 | ||
| 134 | 2025.02.28 10:59:52.856417 [ 5 ] {} <Debug> TCP-Session: 077b353b-2144-4bc6-b738-688b94c43dc9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 135 | 2025.02.28 10:59:52.856466 [ 253 ] {} <Debug> TCP-Session: 5eeb76b2-7b6b-44ea-a792-0a65e255a76d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 136 | 2025.02.28 10:59:52.856494 [ 254 ] {} <Debug> TCP-Session: adf77f81-7684-46a3-b3ef-f9e4b154f20a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 137 | 2025.02.28 10:59:52.856689 [ 255 ] {} <Debug> TCP-Session: dac390ab-1726-429d-9167-fd3f3e02821e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 138 | 2025.02.28 10:59:52.856690 [ 254 ] {} <Debug> TCP-Session: adf77f81-7684-46a3-b3ef-f9e4b154f20a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 139 | 2025.02.28 10:59:52.856712 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 140 | 2025.02.28 10:59:52.856748 [ 255 ] {} <Debug> TCP-Session: dac390ab-1726-429d-9167-fd3f3e02821e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 141 | 2025.02.28 10:59:52.856918 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 142 | 2025.02.28 10:59:52.856943 [ 256 ] {} <Debug> TCP-Session: 2a7522c8-9178-44ed-979f-339893530a01 Authenticating user 'default' from [fd00:1122:3344:101::a]:53519 | ||
| 143 | 2025.02.28 10:59:52.857001 [ 256 ] {} <Debug> TCP-Session: 2a7522c8-9178-44ed-979f-339893530a01 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 144 | 2025.02.28 10:59:52.857010 [ 257 ] {} <Debug> TCP-Session: 49c4f0e2-f909-47e0-9cd3-39bf62d90c1d Authenticating user 'default' from [fd00:1122:3344:101::a]:61644 | ||
| 145 | 2025.02.28 10:59:52.857041 [ 256 ] {} <Debug> TCP-Session: 2a7522c8-9178-44ed-979f-339893530a01 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 146 | 2025.02.28 10:59:52.857051 [ 257 ] {} <Debug> TCP-Session: 49c4f0e2-f909-47e0-9cd3-39bf62d90c1d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2025.02.28 10:59:52.857118 [ 257 ] {} <Debug> TCP-Session: 49c4f0e2-f909-47e0-9cd3-39bf62d90c1d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 148 | 2025.02.28 10:59:53.000153 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 117.19 MiB, peak 117.19 MiB, free memory in arenas 0.00 B, will set to 119.41 MiB (RSS), difference: 2.23 MiB | ||
| 149 | 2025.02.28 10:59:53.017304 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:57427 | ||
| 150 | 2025.02.28 10:59:53.017467 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 151 | 2025.02.28 10:59:53.017498 [ 258 ] {} <Debug> TCP-Session: 23ebf694-ab86-4a18-a25f-818ef0032221 Authenticating user 'default' from [fd00:1122:3344:101::c]:57427 | ||
| 152 | 2025.02.28 10:59:53.017521 [ 258 ] {} <Debug> TCP-Session: 23ebf694-ab86-4a18-a25f-818ef0032221 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 153 | 2025.02.28 10:59:53.017545 [ 258 ] {} <Debug> TCP-Session: 23ebf694-ab86-4a18-a25f-818ef0032221 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 154 | 2025.02.28 10:59:53.017613 [ 258 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 155 | 2025.02.28 10:59:53.017640 [ 258 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 156 | 2025.02.28 10:59:53.017666 [ 258 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 157 | 2025.02.28 10:59:53.020032 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:46953 | ||
| 158 | 2025.02.28 10:59:53.020158 [ 260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:48724 | ||
| 159 | 2025.02.28 10:59:53.020215 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 160 | 2025.02.28 10:59:53.020385 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:51022 | ||
| 161 | 2025.02.28 10:59:53.020398 [ 259 ] {} <Debug> TCP-Session: 1789c058-35c1-4c2d-902c-ce650498eeb5 Authenticating user 'default' from [fd00:1122:3344:101::c]:46953 | ||
| 162 | 2025.02.28 10:59:53.020431 [ 260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 163 | 2025.02.28 10:59:53.020411 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:41474 | ||
| 164 | 2025.02.28 10:59:53.020587 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:60805 | ||
| 165 | 2025.02.28 10:59:53.020596 [ 259 ] {} <Debug> TCP-Session: 1789c058-35c1-4c2d-902c-ce650498eeb5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 166 | 2025.02.28 10:59:53.020604 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 167 | 2025.02.28 10:59:53.020643 [ 260 ] {} <Debug> TCP-Session: f1b61d01-3803-4e87-8197-9b45b97fe696 Authenticating user 'default' from [fd00:1122:3344:101::c]:48724 | ||
| 168 | 2025.02.28 10:59:53.020831 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:62253 | ||
| 169 | 2025.02.28 10:59:53.020956 [ 259 ] {} <Debug> TCP-Session: 1789c058-35c1-4c2d-902c-ce650498eeb5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 170 | 2025.02.28 10:59:53.020956 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 171 | 2025.02.28 10:59:53.020986 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 172 | 2025.02.28 10:59:53.021181 [ 263 ] {} <Debug> TCP-Session: 42e65925-6531-4587-a1f9-12bc77978990 Authenticating user 'default' from [fd00:1122:3344:101::c]:60805 | ||
| 173 | 2025.02.28 10:59:53.021180 [ 262 ] {} <Debug> TCP-Session: f4c3d890-eaae-482e-82ac-86f3f54acfc2 Authenticating user 'default' from [fd00:1122:3344:101::c]:51022 | ||
| 174 | 2025.02.28 10:59:53.021185 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 175 | 2025.02.28 10:59:53.021228 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:55084 | ||
| 176 | 2025.02.28 10:59:53.021282 [ 263 ] {} <Debug> TCP-Session: 42e65925-6531-4587-a1f9-12bc77978990 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 177 | 2025.02.28 10:59:53.021249 [ 260 ] {} <Debug> TCP-Session: f1b61d01-3803-4e87-8197-9b45b97fe696 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 178 | 2025.02.28 10:59:53.021317 [ 261 ] {} <Debug> TCP-Session: d8151ab9-a7e5-4303-8674-bf840770e03c Authenticating user 'default' from [fd00:1122:3344:101::c]:41474 | ||
| 179 | 2025.02.28 10:59:53.021307 [ 262 ] {} <Debug> TCP-Session: f4c3d890-eaae-482e-82ac-86f3f54acfc2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 180 | 2025.02.28 10:59:53.021463 [ 260 ] {} <Debug> TCP-Session: f1b61d01-3803-4e87-8197-9b45b97fe696 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 181 | 2025.02.28 10:59:53.021486 [ 262 ] {} <Debug> TCP-Session: f4c3d890-eaae-482e-82ac-86f3f54acfc2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 182 | 2025.02.28 10:59:53.021503 [ 263 ] {} <Debug> TCP-Session: 42e65925-6531-4587-a1f9-12bc77978990 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 183 | 2025.02.28 10:59:53.021527 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 184 | 2025.02.28 10:59:53.021678 [ 264 ] {} <Debug> TCP-Session: 8a7f0280-7cfa-46c0-84bc-b8cab50d71e7 Authenticating user 'default' from [fd00:1122:3344:101::c]:62253 | ||
| 185 | 2025.02.28 10:59:53.021732 [ 265 ] {} <Debug> TCP-Session: 5a6c077c-1976-473c-85f7-346aed824bb2 Authenticating user 'default' from [fd00:1122:3344:101::c]:55084 | ||
| 186 | 2025.02.28 10:59:53.021762 [ 261 ] {} <Debug> TCP-Session: d8151ab9-a7e5-4303-8674-bf840770e03c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 187 | 2025.02.28 10:59:53.021779 [ 264 ] {} <Debug> TCP-Session: 8a7f0280-7cfa-46c0-84bc-b8cab50d71e7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 188 | 2025.02.28 10:59:53.021831 [ 265 ] {} <Debug> TCP-Session: 5a6c077c-1976-473c-85f7-346aed824bb2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 189 | 2025.02.28 10:59:53.021855 [ 261 ] {} <Debug> TCP-Session: d8151ab9-a7e5-4303-8674-bf840770e03c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 190 | 2025.02.28 10:59:53.021861 [ 264 ] {} <Debug> TCP-Session: 8a7f0280-7cfa-46c0-84bc-b8cab50d71e7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 191 | 2025.02.28 10:59:53.021882 [ 265 ] {} <Debug> TCP-Session: 5a6c077c-1976-473c-85f7-346aed824bb2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 192 | 2025.02.28 10:59:53.139777 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:38372 | ||
| 193 | 2025.02.28 10:59:53.139941 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 194 | 2025.02.28 10:59:53.139982 [ 266 ] {} <Debug> TCP-Session: 43c4c882-5c0c-4565-bbd4-e1e3c5c60b68 Authenticating user 'default' from [fd00:1122:3344:101::b]:38372 | ||
| 195 | 2025.02.28 10:59:53.140005 [ 266 ] {} <Debug> TCP-Session: 43c4c882-5c0c-4565-bbd4-e1e3c5c60b68 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 196 | 2025.02.28 10:59:53.140032 [ 266 ] {} <Debug> TCP-Session: 43c4c882-5c0c-4565-bbd4-e1e3c5c60b68 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 197 | 2025.02.28 10:59:53.140117 [ 266 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 198 | 2025.02.28 10:59:53.140153 [ 266 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 199 | 2025.02.28 10:59:53.140187 [ 266 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 200 | 2025.02.28 10:59:53.141088 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:42397 | ||
| 201 | 2025.02.28 10:59:53.141254 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:52309 | ||
| 202 | 2025.02.28 10:59:53.141260 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 203 | 2025.02.28 10:59:53.141416 [ 267 ] {} <Debug> TCP-Session: aec5763f-7b71-43ac-8887-c9b6b621b27b Authenticating user 'default' from [fd00:1122:3344:101::b]:42397 | ||
| 204 | 2025.02.28 10:59:53.141396 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:60114 | ||
| 205 | 2025.02.28 10:59:53.141465 [ 270 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:61435 | ||
| 206 | 2025.02.28 10:59:53.141501 [ 267 ] {} <Debug> TCP-Session: aec5763f-7b71-43ac-8887-c9b6b621b27b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 207 | 2025.02.28 10:59:53.141557 [ 267 ] {} <Debug> TCP-Session: aec5763f-7b71-43ac-8887-c9b6b621b27b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 208 | 2025.02.28 10:59:53.141800 [ 271 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:55111 | ||
| 209 | 2025.02.28 10:59:53.141925 [ 272 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:35200 | ||
| 210 | 2025.02.28 10:59:53.142082 [ 273 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:35065 | ||
| 211 | 2025.02.28 10:59:53.142150 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 212 | 2025.02.28 10:59:53.142207 [ 270 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 213 | 2025.02.28 10:59:53.142223 [ 272 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 214 | 2025.02.28 10:59:53.142417 [ 270 ] {} <Debug> TCP-Session: 0e978cf9-a93a-474e-ab78-15157cc702da Authenticating user 'default' from [fd00:1122:3344:101::b]:61435 | ||
| 215 | 2025.02.28 10:59:53.142434 [ 272 ] {} <Debug> TCP-Session: 54cc4f41-3f03-4e85-8e6a-178a75fd242d Authenticating user 'default' from [fd00:1122:3344:101::b]:35200 | ||
| 216 | 2025.02.28 10:59:53.142276 [ 268 ] {} <Debug> TCP-Session: 67fea822-2ddf-4478-8c69-7a282b795fdb Authenticating user 'default' from [fd00:1122:3344:101::b]:52309 | ||
| 217 | 2025.02.28 10:59:53.142484 [ 270 ] {} <Debug> TCP-Session: 0e978cf9-a93a-474e-ab78-15157cc702da Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 218 | 2025.02.28 10:59:53.142505 [ 268 ] {} <Debug> TCP-Session: 67fea822-2ddf-4478-8c69-7a282b795fdb Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 219 | 2025.02.28 10:59:53.142526 [ 270 ] {} <Debug> TCP-Session: 0e978cf9-a93a-474e-ab78-15157cc702da Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 220 | 2025.02.28 10:59:53.142502 [ 272 ] {} <Debug> TCP-Session: 54cc4f41-3f03-4e85-8e6a-178a75fd242d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 221 | 2025.02.28 10:59:53.142564 [ 268 ] {} <Debug> TCP-Session: 67fea822-2ddf-4478-8c69-7a282b795fdb Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 222 | 2025.02.28 10:59:53.142670 [ 272 ] {} <Debug> TCP-Session: 54cc4f41-3f03-4e85-8e6a-178a75fd242d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 223 | 2025.02.28 10:59:53.142692 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 224 | 2025.02.28 10:59:53.142703 [ 271 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 225 | 2025.02.28 10:59:53.142792 [ 273 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 226 | 2025.02.28 10:59:53.142851 [ 271 ] {} <Debug> TCP-Session: 1ce6ad1f-e24d-41f6-9944-c1a10bc8e5ab Authenticating user 'default' from [fd00:1122:3344:101::b]:55111 | ||
| 227 | 2025.02.28 10:59:53.142883 [ 273 ] {} <Debug> TCP-Session: f303ff54-729a-4a32-8b0d-00112b545d8b Authenticating user 'default' from [fd00:1122:3344:101::b]:35065 | ||
| 228 | 2025.02.28 10:59:53.142911 [ 271 ] {} <Debug> TCP-Session: 1ce6ad1f-e24d-41f6-9944-c1a10bc8e5ab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 229 | 2025.02.28 10:59:53.142874 [ 269 ] {} <Debug> TCP-Session: d009a75f-7218-4525-9c4d-03c41e85e9c6 Authenticating user 'default' from [fd00:1122:3344:101::b]:60114 | ||
| 230 | 2025.02.28 10:59:53.142946 [ 271 ] {} <Debug> TCP-Session: 1ce6ad1f-e24d-41f6-9944-c1a10bc8e5ab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 231 | 2025.02.28 10:59:53.142972 [ 269 ] {} <Debug> TCP-Session: d009a75f-7218-4525-9c4d-03c41e85e9c6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 232 | 2025.02.28 10:59:53.142941 [ 273 ] {} <Debug> TCP-Session: f303ff54-729a-4a32-8b0d-00112b545d8b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 233 | 2025.02.28 10:59:53.143037 [ 269 ] {} <Debug> TCP-Session: d009a75f-7218-4525-9c4d-03c41e85e9c6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 234 | 2025.02.28 10:59:53.143059 [ 273 ] {} <Debug> TCP-Session: f303ff54-729a-4a32-8b0d-00112b545d8b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 235 | 2025.02.28 10:59:53.891831 [ 274 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:39449 | ||
| 236 | 2025.02.28 10:59:53.891995 [ 274 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 237 | 2025.02.28 10:59:53.892040 [ 274 ] {} <Debug> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Authenticating user 'default' from [fd00:1122:3344:101::d]:39449 | ||
| 238 | 2025.02.28 10:59:53.892064 [ 274 ] {} <Debug> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 239 | 2025.02.28 10:59:53.892077 [ 274 ] {} <Debug> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 240 | 2025.02.28 10:59:53.892155 [ 274 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 241 | 2025.02.28 10:59:53.892181 [ 274 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 242 | 2025.02.28 10:59:53.892207 [ 274 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 243 | 2025.02.28 10:59:53.893265 [ 275 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:55416 | ||
| 244 | 2025.02.28 10:59:53.893472 [ 277 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:38175 | ||
| 245 | 2025.02.28 10:59:53.893513 [ 275 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 246 | 2025.02.28 10:59:53.893503 [ 276 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:47928 | ||
| 247 | 2025.02.28 10:59:53.893643 [ 275 ] {} <Debug> TCP-Session: 59b928d8-f3de-4311-827c-736c31a3d6f1 Authenticating user 'default' from [fd00:1122:3344:101::d]:55416 | ||
| 248 | 2025.02.28 10:59:53.893736 [ 278 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:43781 | ||
| 249 | 2025.02.28 10:59:53.893753 [ 275 ] {} <Debug> TCP-Session: 59b928d8-f3de-4311-827c-736c31a3d6f1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 250 | 2025.02.28 10:59:53.893838 [ 279 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:42906 | ||
| 251 | 2025.02.28 10:59:53.894051 [ 277 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 252 | 2025.02.28 10:59:53.894080 [ 276 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 253 | 2025.02.28 10:59:53.894174 [ 275 ] {} <Debug> TCP-Session: 59b928d8-f3de-4311-827c-736c31a3d6f1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 254 | 2025.02.28 10:59:53.894194 [ 280 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:56386 | ||
| 255 | 2025.02.28 10:59:53.894367 [ 279 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 256 | 2025.02.28 10:59:53.894362 [ 277 ] {} <Debug> TCP-Session: 19532b7a-920b-491e-be5c-ddd610d146a0 Authenticating user 'default' from [fd00:1122:3344:101::d]:38175 | ||
| 257 | 2025.02.28 10:59:53.894568 [ 277 ] {} <Debug> TCP-Session: 19532b7a-920b-491e-be5c-ddd610d146a0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 258 | 2025.02.28 10:59:53.895249 [ 279 ] {} <Debug> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Authenticating user 'default' from [fd00:1122:3344:101::d]:42906 | ||
| 259 | 2025.02.28 10:59:53.895344 [ 282 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:36169 | ||
| 260 | 2025.02.28 10:59:53.895374 [ 277 ] {} <Debug> TCP-Session: 19532b7a-920b-491e-be5c-ddd610d146a0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 261 | 2025.02.28 10:59:53.895372 [ 280 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 262 | 2025.02.28 10:59:53.895423 [ 276 ] {} <Debug> TCP-Session: 28b9486a-2833-4ba0-9638-824d9b1c04b6 Authenticating user 'default' from [fd00:1122:3344:101::d]:47928 | ||
| 263 | 2025.02.28 10:59:53.894501 [ 278 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 264 | 2025.02.28 10:59:53.895450 [ 279 ] {} <Debug> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2025.02.28 10:59:53.895263 [ 281 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:48642 | ||
| 266 | 2025.02.28 10:59:53.896296 [ 279 ] {} <Debug> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 267 | 2025.02.28 10:59:53.896370 [ 282 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 268 | 2025.02.28 10:59:53.896419 [ 278 ] {} <Debug> TCP-Session: 82facefe-59ef-4a67-8a24-65835b6046ae Authenticating user 'default' from [fd00:1122:3344:101::d]:43781 | ||
| 269 | 2025.02.28 10:59:53.896591 [ 281 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 270 | 2025.02.28 10:59:53.896666 [ 282 ] {} <Debug> TCP-Session: 5bc8dfd1-9b67-41fa-89bd-b61a106c41e0 Authenticating user 'default' from [fd00:1122:3344:101::d]:36169 | ||
| 271 | 2025.02.28 10:59:53.896695 [ 280 ] {} <Debug> TCP-Session: 1ec91394-8296-4bd9-bfac-c1d68c9fbb9a Authenticating user 'default' from [fd00:1122:3344:101::d]:56386 | ||
| 272 | 2025.02.28 10:59:53.896735 [ 278 ] {} <Debug> TCP-Session: 82facefe-59ef-4a67-8a24-65835b6046ae Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2025.02.28 10:59:53.896743 [ 281 ] {} <Debug> TCP-Session: 38fbc7fa-584f-4687-af09-ddb74f6ad5a6 Authenticating user 'default' from [fd00:1122:3344:101::d]:48642 | ||
| 274 | 2025.02.28 10:59:53.896760 [ 282 ] {} <Debug> TCP-Session: 5bc8dfd1-9b67-41fa-89bd-b61a106c41e0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2025.02.28 10:59:53.896798 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 276 | 2025.02.28 10:59:53.896822 [ 278 ] {} <Debug> TCP-Session: 82facefe-59ef-4a67-8a24-65835b6046ae Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2025.02.28 10:59:53.896838 [ 280 ] {} <Debug> TCP-Session: 1ec91394-8296-4bd9-bfac-c1d68c9fbb9a Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 278 | 2025.02.28 10:59:53.896883 [ 282 ] {} <Debug> TCP-Session: 5bc8dfd1-9b67-41fa-89bd-b61a106c41e0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 279 | 2025.02.28 10:59:53.896857 [ 281 ] {} <Debug> TCP-Session: 38fbc7fa-584f-4687-af09-ddb74f6ad5a6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 280 | 2025.02.28 10:59:53.896723 [ 276 ] {} <Debug> TCP-Session: 28b9486a-2833-4ba0-9638-824d9b1c04b6 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 281 | 2025.02.28 10:59:53.897025 [ 281 ] {} <Debug> TCP-Session: 38fbc7fa-584f-4687-af09-ddb74f6ad5a6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2025.02.28 10:59:53.897035 [ 280 ] {} <Debug> TCP-Session: 1ec91394-8296-4bd9-bfac-c1d68c9fbb9a Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2025.02.28 10:59:53.897062 [ 276 ] {} <Debug> TCP-Session: 28b9486a-2833-4ba0-9638-824d9b1c04b6 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 284 | 2025.02.28 10:59:53.900562 [ 274 ] {c9ea74ed-6001-483b-adce-b41bed1613a4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 285 | 2025.02.28 10:59:53.958367 [ 274 ] {c9ea74ed-6001-483b-adce-b41bed1613a4} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:39449) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 286 | |||
| 287 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 288 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 289 | 2. DB::Exception::Exception<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >(int, FormatStringHelperImpl<std::type_identity<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > >::type>, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&&) @ 0x000000000aa2f697 in /opt/oxide/clickhouse/clickhouse | ||
| 290 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 291 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 292 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 293 | 6. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000014f910c1 in /opt/oxide/clickhouse/clickhouse | ||
| 294 | 7. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014f8f926 in /opt/oxide/clickhouse/clickhouse | ||
| 295 | 8. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fde706 in /opt/oxide/clickhouse/clickhouse | ||
| 296 | 9. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >, std::allocator<std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > > > const&) @ 0x0000000014fdd443 in /opt/oxide/clickhouse/clickhouse | ||
| 297 | 10. std::__detail::_MakeUniq<DB::InterpreterSelectWithUnionQuery>::__single_object std::make_unique<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000014f67dc7 in /opt/oxide/clickhouse/clickhouse | ||
| 298 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 299 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 300 | 13. DB::executeQuery(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000015186706 in /opt/oxide/clickhouse/clickhouse | ||
| 301 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 302 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 303 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 304 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 305 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 306 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 307 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 308 | |||
| 309 | 2025.02.28 10:59:53.959678 [ 274 ] {c9ea74ed-6001-483b-adce-b41bed1613a4} <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 @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 332 | |||
| 333 | 2025.02.28 10:59:53.959785 [ 274 ] {c9ea74ed-6001-483b-adce-b41bed1613a4} <Debug> TCPHandler: Processed in 0.065735996 sec. | ||
| 334 | 2025.02.28 10:59:53.960163 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 335 | 2025.02.28 10:59:53.960389 [ 279 ] {2d7e6331-f731-49a5-895c-7d64cceaf391} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 336 | 2025.02.28 10:59:53.960753 [ 279 ] {2d7e6331-f731-49a5-895c-7d64cceaf391} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:42906) (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 @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 359 | |||
| 360 | 2025.02.28 10:59:53.960909 [ 279 ] {2d7e6331-f731-49a5-895c-7d64cceaf391} <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 @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 383 | |||
| 384 | 2025.02.28 10:59:53.961010 [ 279 ] {2d7e6331-f731-49a5-895c-7d64cceaf391} <Debug> TCPHandler: Processed in 0.001009438 sec. | ||
| 385 | 2025.02.28 10:59:53.961815 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 386 | 2025.02.28 10:59:53.963129 [ 274 ] {4f6a877b-8a62-4103-843f-c5f9ff17c314} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 387 | 2025.02.28 10:59:53.963228 [ 274 ] {4f6a877b-8a62-4103-843f-c5f9ff17c314} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 388 | 2025.02.28 10:59:53.972448 [ 274 ] {4f6a877b-8a62-4103-843f-c5f9ff17c314} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 389 | 2025.02.28 10:59:53.972501 [ 274 ] {4f6a877b-8a62-4103-843f-c5f9ff17c314} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 9.7151e-05 sec | ||
| 390 | 2025.02.28 10:59:53.972529 [ 274 ] {4f6a877b-8a62-4103-843f-c5f9ff17c314} <Trace> ReferentialDeps: No tables | ||
| 391 | 2025.02.28 10:59:53.972547 [ 274 ] {4f6a877b-8a62-4103-843f-c5f9ff17c314} <Trace> LoadingDeps: No tables | ||
| 392 | 2025.02.28 10:59:53.972584 [ 274 ] {4f6a877b-8a62-4103-843f-c5f9ff17c314} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 393 | 2025.02.28 10:59:53.973329 [ 274 ] {4f6a877b-8a62-4103-843f-c5f9ff17c314} <Debug> TCPHandler: Processed in 0.01163879 sec. | ||
| 394 | 2025.02.28 10:59:53.973598 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 395 | 2025.02.28 10:59:53.973785 [ 279 ] {601a0191-368a-4b1c-b44d-d8f53ab8abdd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) /* The version table contains metadata about the `oximeter` database */ | ||
| 396 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 397 | 2025.02.28 10:59:53.973865 [ 279 ] {601a0191-368a-4b1c-b44d-d8f53ab8abdd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 398 | 2025.02.28 10:59:53.981789 [ 279 ] {601a0191-368a-4b1c-b44d-d8f53ab8abdd} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 399 | 2025.02.28 10:59:53.986963 [ 279 ] {601a0191-368a-4b1c-b44d-d8f53ab8abdd} <Debug> oximeter.version (712547d3-72e5-4035-bd7a-4eca71f163ef): Loading data parts | ||
| 400 | 2025.02.28 10:59:53.987451 [ 279 ] {601a0191-368a-4b1c-b44d-d8f53ab8abdd} <Debug> oximeter.version (712547d3-72e5-4035-bd7a-4eca71f163ef): There are no data parts | ||
| 401 | 2025.02.28 10:59:54.000154 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 123.67 MiB, peak 123.67 MiB, free memory in arenas 0.00 B, will set to 132.88 MiB (RSS), difference: 9.21 MiB | ||
| 402 | 2025.02.28 10:59:54.009889 [ 279 ] {601a0191-368a-4b1c-b44d-d8f53ab8abdd} <Debug> TCPHandler: Processed in 0.036356133 sec. | ||
| 403 | 2025.02.28 10:59:54.010135 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 404 | 2025.02.28 10:59:54.010381 [ 274 ] {c04c45d1-73ac-47e6-b3cf-328811dcf9e8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) /* The measurement tables contain all individual samples from each timeseries. | ||
| 405 | * | ||
| 406 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 407 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 408 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 409 | * by all samples from the same timeseries. | ||
| 410 | * | ||
| 411 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 412 | * and then uses that to index quickly into the measurements tables. | ||
| 413 | */ | ||
| 414 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Bool) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 415 | 2025.02.28 10:59:54.010479 [ 274 ] {c04c45d1-73ac-47e6-b3cf-328811dcf9e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 416 | 2025.02.28 10:59:54.040771 [ 274 ] {c04c45d1-73ac-47e6-b3cf-328811dcf9e8} <Debug> oximeter.measurements_bool (f935e4ef-d84e-4464-bf79-915281c339f9): Loading data parts | ||
| 417 | 2025.02.28 10:59:54.041028 [ 274 ] {c04c45d1-73ac-47e6-b3cf-328811dcf9e8} <Debug> oximeter.measurements_bool (f935e4ef-d84e-4464-bf79-915281c339f9): There are no data parts | ||
| 418 | 2025.02.28 10:59:54.088281 [ 274 ] {c04c45d1-73ac-47e6-b3cf-328811dcf9e8} <Debug> TCPHandler: Processed in 0.078217783 sec. | ||
| 419 | 2025.02.28 10:59:54.088594 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 420 | 2025.02.28 10:59:54.088906 [ 279 ] {5b7d0dec-fc4a-4cf5-891a-ef1ab398ac58} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 421 | 2025.02.28 10:59:54.089003 [ 279 ] {5b7d0dec-fc4a-4cf5-891a-ef1ab398ac58} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 422 | 2025.02.28 10:59:54.116252 [ 279 ] {5b7d0dec-fc4a-4cf5-891a-ef1ab398ac58} <Debug> oximeter.measurements_i8 (3b1d9976-20e5-4fc0-8bc7-9a6155e3cbcb): Loading data parts | ||
| 423 | 2025.02.28 10:59:54.116421 [ 279 ] {5b7d0dec-fc4a-4cf5-891a-ef1ab398ac58} <Debug> oximeter.measurements_i8 (3b1d9976-20e5-4fc0-8bc7-9a6155e3cbcb): There are no data parts | ||
| 424 | 2025.02.28 10:59:54.120959 [ 279 ] {5b7d0dec-fc4a-4cf5-891a-ef1ab398ac58} <Debug> TCPHandler: Processed in 0.032470409 sec. | ||
| 425 | 2025.02.28 10:59:54.121250 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 426 | 2025.02.28 10:59:54.121535 [ 274 ] {c7d6e8d4-b43f-4d9f-b7ec-01ab7f76d0e7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 427 | 2025.02.28 10:59:54.121641 [ 274 ] {c7d6e8d4-b43f-4d9f-b7ec-01ab7f76d0e7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 428 | 2025.02.28 10:59:54.143436 [ 274 ] {c7d6e8d4-b43f-4d9f-b7ec-01ab7f76d0e7} <Debug> oximeter.measurements_u8 (63bc4be8-a2c3-41c7-b697-794881dbdf8d): Loading data parts | ||
| 429 | 2025.02.28 10:59:54.143632 [ 274 ] {c7d6e8d4-b43f-4d9f-b7ec-01ab7f76d0e7} <Debug> oximeter.measurements_u8 (63bc4be8-a2c3-41c7-b697-794881dbdf8d): There are no data parts | ||
| 430 | 2025.02.28 10:59:54.159107 [ 274 ] {c7d6e8d4-b43f-4d9f-b7ec-01ab7f76d0e7} <Debug> TCPHandler: Processed in 0.037962916 sec. | ||
| 431 | 2025.02.28 10:59:54.159374 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 432 | 2025.02.28 10:59:54.159625 [ 279 ] {c260c841-3e53-4323-9d33-e4c07fa7984f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 433 | 2025.02.28 10:59:54.159708 [ 279 ] {c260c841-3e53-4323-9d33-e4c07fa7984f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 434 | 2025.02.28 10:59:54.179727 [ 279 ] {c260c841-3e53-4323-9d33-e4c07fa7984f} <Debug> oximeter.measurements_i16 (68bc78bd-5db7-444f-8cbc-988ee2b9ba34): Loading data parts | ||
| 435 | 2025.02.28 10:59:54.179906 [ 279 ] {c260c841-3e53-4323-9d33-e4c07fa7984f} <Debug> oximeter.measurements_i16 (68bc78bd-5db7-444f-8cbc-988ee2b9ba34): There are no data parts | ||
| 436 | 2025.02.28 10:59:54.209225 [ 279 ] {c260c841-3e53-4323-9d33-e4c07fa7984f} <Debug> TCPHandler: Processed in 0.04993413 sec. | ||
| 437 | 2025.02.28 10:59:54.209465 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 438 | 2025.02.28 10:59:54.209747 [ 274 ] {042fd64c-f991-4917-9e3d-cfa8995cdef6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 439 | 2025.02.28 10:59:54.209843 [ 274 ] {042fd64c-f991-4917-9e3d-cfa8995cdef6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 440 | 2025.02.28 10:59:54.221164 [ 274 ] {042fd64c-f991-4917-9e3d-cfa8995cdef6} <Debug> oximeter.measurements_u16 (b4cf5b23-9d32-464f-a7df-0578b3d2c568): Loading data parts | ||
| 441 | 2025.02.28 10:59:54.221360 [ 274 ] {042fd64c-f991-4917-9e3d-cfa8995cdef6} <Debug> oximeter.measurements_u16 (b4cf5b23-9d32-464f-a7df-0578b3d2c568): There are no data parts | ||
| 442 | 2025.02.28 10:59:54.226788 [ 274 ] {042fd64c-f991-4917-9e3d-cfa8995cdef6} <Debug> TCPHandler: Processed in 0.01740336 sec. | ||
| 443 | 2025.02.28 10:59:54.227037 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 444 | 2025.02.28 10:59:54.227292 [ 279 ] {fc83ecf6-1055-4a23-974f-16326e792d02} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 445 | 2025.02.28 10:59:54.227367 [ 279 ] {fc83ecf6-1055-4a23-974f-16326e792d02} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 446 | 2025.02.28 10:59:54.261434 [ 279 ] {fc83ecf6-1055-4a23-974f-16326e792d02} <Debug> oximeter.measurements_i32 (9da267a3-4261-4deb-adf5-dbac08fb0be0): Loading data parts | ||
| 447 | 2025.02.28 10:59:54.261618 [ 279 ] {fc83ecf6-1055-4a23-974f-16326e792d02} <Debug> oximeter.measurements_i32 (9da267a3-4261-4deb-adf5-dbac08fb0be0): There are no data parts | ||
| 448 | 2025.02.28 10:59:54.298569 [ 279 ] {fc83ecf6-1055-4a23-974f-16326e792d02} <Debug> TCPHandler: Processed in 0.071608426 sec. | ||
| 449 | 2025.02.28 10:59:54.298870 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 450 | 2025.02.28 10:59:54.299097 [ 274 ] {45fa4321-53b0-4b34-9c3d-ed0ad7890453} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 451 | 2025.02.28 10:59:54.299180 [ 274 ] {45fa4321-53b0-4b34-9c3d-ed0ad7890453} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 452 | 2025.02.28 10:59:54.324540 [ 274 ] {45fa4321-53b0-4b34-9c3d-ed0ad7890453} <Debug> oximeter.measurements_u32 (6f0a2ad4-a642-4653-a835-7a9969515541): Loading data parts | ||
| 453 | 2025.02.28 10:59:54.324735 [ 274 ] {45fa4321-53b0-4b34-9c3d-ed0ad7890453} <Debug> oximeter.measurements_u32 (6f0a2ad4-a642-4653-a835-7a9969515541): There are no data parts | ||
| 454 | 2025.02.28 10:59:54.328326 [ 274 ] {45fa4321-53b0-4b34-9c3d-ed0ad7890453} <Debug> TCPHandler: Processed in 0.029523674 sec. | ||
| 455 | 2025.02.28 10:59:54.328552 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 456 | 2025.02.28 10:59:54.328800 [ 279 ] {f98e28e8-fc2f-4d23-8fe4-2facad1b5d9d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 457 | 2025.02.28 10:59:54.328872 [ 279 ] {f98e28e8-fc2f-4d23-8fe4-2facad1b5d9d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 458 | 2025.02.28 10:59:54.352429 [ 279 ] {f98e28e8-fc2f-4d23-8fe4-2facad1b5d9d} <Debug> oximeter.measurements_i64 (e3a14b2e-cbf9-45a8-a14c-8c586e19b9bf): Loading data parts | ||
| 459 | 2025.02.28 10:59:54.352572 [ 279 ] {f98e28e8-fc2f-4d23-8fe4-2facad1b5d9d} <Debug> oximeter.measurements_i64 (e3a14b2e-cbf9-45a8-a14c-8c586e19b9bf): There are no data parts | ||
| 460 | 2025.02.28 10:59:54.376137 [ 279 ] {f98e28e8-fc2f-4d23-8fe4-2facad1b5d9d} <Debug> TCPHandler: Processed in 0.04764576 sec. | ||
| 461 | 2025.02.28 10:59:54.376371 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 462 | 2025.02.28 10:59:54.376641 [ 274 ] {4cbe8e92-5e34-4952-9f4d-1e20fc2313b7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 463 | 2025.02.28 10:59:54.376741 [ 274 ] {4cbe8e92-5e34-4952-9f4d-1e20fc2313b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 464 | 2025.02.28 10:59:54.412359 [ 274 ] {4cbe8e92-5e34-4952-9f4d-1e20fc2313b7} <Debug> oximeter.measurements_u64 (a1b94999-50ca-4bad-be44-89f14b6ec7a0): Loading data parts | ||
| 465 | 2025.02.28 10:59:54.412573 [ 274 ] {4cbe8e92-5e34-4952-9f4d-1e20fc2313b7} <Debug> oximeter.measurements_u64 (a1b94999-50ca-4bad-be44-89f14b6ec7a0): There are no data parts | ||
| 466 | 2025.02.28 10:59:54.426768 [ 274 ] {4cbe8e92-5e34-4952-9f4d-1e20fc2313b7} <Debug> TCPHandler: Processed in 0.050471904 sec. | ||
| 467 | 2025.02.28 10:59:54.426976 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 468 | 2025.02.28 10:59:54.427226 [ 279 ] {90933278-ac41-4f3e-b098-f30dc77de05d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 469 | 2025.02.28 10:59:54.427301 [ 279 ] {90933278-ac41-4f3e-b098-f30dc77de05d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 470 | 2025.02.28 10:59:54.431060 [ 279 ] {90933278-ac41-4f3e-b098-f30dc77de05d} <Debug> oximeter.measurements_f32 (6edce104-68ed-4e3d-889d-c6ef7a33f90d): Loading data parts | ||
| 471 | 2025.02.28 10:59:54.431193 [ 279 ] {90933278-ac41-4f3e-b098-f30dc77de05d} <Debug> oximeter.measurements_f32 (6edce104-68ed-4e3d-889d-c6ef7a33f90d): There are no data parts | ||
| 472 | 2025.02.28 10:59:54.455045 [ 279 ] {90933278-ac41-4f3e-b098-f30dc77de05d} <Debug> TCPHandler: Processed in 0.028129022 sec. | ||
| 473 | 2025.02.28 10:59:54.455264 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 474 | 2025.02.28 10:59:54.455517 [ 274 ] {382c95c7-d35a-4784-b853-bd123e123c54} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 475 | 2025.02.28 10:59:54.455605 [ 274 ] {382c95c7-d35a-4784-b853-bd123e123c54} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 476 | 2025.02.28 10:59:54.501849 [ 274 ] {382c95c7-d35a-4784-b853-bd123e123c54} <Debug> oximeter.measurements_f64 (ad8df6a2-f548-4fd4-925d-29580e59d08f): Loading data parts | ||
| 477 | 2025.02.28 10:59:54.502039 [ 274 ] {382c95c7-d35a-4784-b853-bd123e123c54} <Debug> oximeter.measurements_f64 (ad8df6a2-f548-4fd4-925d-29580e59d08f): There are no data parts | ||
| 478 | 2025.02.28 10:59:54.510000 [ 274 ] {382c95c7-d35a-4784-b853-bd123e123c54} <Debug> TCPHandler: Processed in 0.054808992 sec. | ||
| 479 | 2025.02.28 10:59:54.510243 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 480 | 2025.02.28 10:59:54.510502 [ 279 ] {4ea84b6a-df6e-4093-8a82-49fddd4676f9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 481 | 2025.02.28 10:59:54.510580 [ 279 ] {4ea84b6a-df6e-4093-8a82-49fddd4676f9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 482 | 2025.02.28 10:59:54.544222 [ 279 ] {4ea84b6a-df6e-4093-8a82-49fddd4676f9} <Debug> oximeter.measurements_string (0877f5b3-4c19-4b8c-a1c3-5101c6915f92): Loading data parts | ||
| 483 | 2025.02.28 10:59:54.544368 [ 279 ] {4ea84b6a-df6e-4093-8a82-49fddd4676f9} <Debug> oximeter.measurements_string (0877f5b3-4c19-4b8c-a1c3-5101c6915f92): There are no data parts | ||
| 484 | 2025.02.28 10:59:54.558780 [ 279 ] {4ea84b6a-df6e-4093-8a82-49fddd4676f9} <Debug> TCPHandler: Processed in 0.048600828 sec. | ||
| 485 | 2025.02.28 10:59:54.559002 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 486 | 2025.02.28 10:59:54.559233 [ 274 ] {e8142b0b-68b8-4a8f-9362-de494f9112f9} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 487 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 488 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 489 | * a string isn't palatable for a few reasons. | ||
| 490 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 491 | * details. | ||
| 492 | */ | ||
| 493 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 494 | 2025.02.28 10:59:54.559325 [ 274 ] {e8142b0b-68b8-4a8f-9362-de494f9112f9} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 495 | 2025.02.28 10:59:54.585059 [ 274 ] {e8142b0b-68b8-4a8f-9362-de494f9112f9} <Debug> oximeter.measurements_bytes (61655660-7632-4262-9cc9-0c7ab1b5bd39): Loading data parts | ||
| 496 | 2025.02.28 10:59:54.585257 [ 274 ] {e8142b0b-68b8-4a8f-9362-de494f9112f9} <Debug> oximeter.measurements_bytes (61655660-7632-4262-9cc9-0c7ab1b5bd39): There are no data parts | ||
| 497 | 2025.02.28 10:59:54.594597 [ 274 ] {e8142b0b-68b8-4a8f-9362-de494f9112f9} <Debug> TCPHandler: Processed in 0.035661217 sec. | ||
| 498 | 2025.02.28 10:59:54.594842 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 499 | 2025.02.28 10:59:54.595126 [ 279 ] {527087bb-e97f-4389-9007-503471b03910} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 500 | 2025.02.28 10:59:54.595230 [ 279 ] {527087bb-e97f-4389-9007-503471b03910} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 501 | 2025.02.28 10:59:54.602125 [ 279 ] {527087bb-e97f-4389-9007-503471b03910} <Debug> oximeter.measurements_cumulativei64 (0bd96769-fa6b-4aa3-83f8-3b1a4c47e4b7): Loading data parts | ||
| 502 | 2025.02.28 10:59:54.602263 [ 279 ] {527087bb-e97f-4389-9007-503471b03910} <Debug> oximeter.measurements_cumulativei64 (0bd96769-fa6b-4aa3-83f8-3b1a4c47e4b7): There are no data parts | ||
| 503 | 2025.02.28 10:59:54.623863 [ 279 ] {527087bb-e97f-4389-9007-503471b03910} <Debug> TCPHandler: Processed in 0.02910039 sec. | ||
| 504 | 2025.02.28 10:59:54.624131 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 505 | 2025.02.28 10:59:54.624368 [ 274 ] {3abd4a42-b88c-433c-9334-08e63cbfa296} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 506 | 2025.02.28 10:59:54.624460 [ 274 ] {3abd4a42-b88c-433c-9334-08e63cbfa296} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 507 | 2025.02.28 10:59:54.646320 [ 274 ] {3abd4a42-b88c-433c-9334-08e63cbfa296} <Debug> oximeter.measurements_cumulativeu64 (0403681f-1473-4aa5-97a4-ddd02bb90591): Loading data parts | ||
| 508 | 2025.02.28 10:59:54.646526 [ 274 ] {3abd4a42-b88c-433c-9334-08e63cbfa296} <Debug> oximeter.measurements_cumulativeu64 (0403681f-1473-4aa5-97a4-ddd02bb90591): There are no data parts | ||
| 509 | 2025.02.28 10:59:54.667426 [ 274 ] {3abd4a42-b88c-433c-9334-08e63cbfa296} <Debug> TCPHandler: Processed in 0.043364082 sec. | ||
| 510 | 2025.02.28 10:59:54.667644 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 511 | 2025.02.28 10:59:54.667969 [ 279 ] {6b9e990c-eec6-4afc-9957-d8ff69bd2ae1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 512 | 2025.02.28 10:59:54.668104 [ 279 ] {6b9e990c-eec6-4afc-9957-d8ff69bd2ae1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 513 | 2025.02.28 10:59:54.694654 [ 279 ] {6b9e990c-eec6-4afc-9957-d8ff69bd2ae1} <Debug> oximeter.measurements_cumulativef32 (c9891a56-0a83-4472-a031-27e505a960cc): Loading data parts | ||
| 514 | 2025.02.28 10:59:54.694795 [ 279 ] {6b9e990c-eec6-4afc-9957-d8ff69bd2ae1} <Debug> oximeter.measurements_cumulativef32 (c9891a56-0a83-4472-a031-27e505a960cc): There are no data parts | ||
| 515 | 2025.02.28 10:59:54.706255 [ 279 ] {6b9e990c-eec6-4afc-9957-d8ff69bd2ae1} <Debug> TCPHandler: Processed in 0.038671633 sec. | ||
| 516 | 2025.02.28 10:59:54.706471 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 517 | 2025.02.28 10:59:54.706745 [ 274 ] {299c3c7f-a681-453d-b07c-11c22a7ec4be} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 518 | 2025.02.28 10:59:54.706911 [ 274 ] {299c3c7f-a681-453d-b07c-11c22a7ec4be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 519 | 2025.02.28 10:59:54.723305 [ 274 ] {299c3c7f-a681-453d-b07c-11c22a7ec4be} <Debug> oximeter.measurements_cumulativef64 (be841ad3-8bbc-4ae6-9d53-e41217d42530): Loading data parts | ||
| 520 | 2025.02.28 10:59:54.723474 [ 274 ] {299c3c7f-a681-453d-b07c-11c22a7ec4be} <Debug> oximeter.measurements_cumulativef64 (be841ad3-8bbc-4ae6-9d53-e41217d42530): There are no data parts | ||
| 521 | 2025.02.28 10:59:54.744063 [ 274 ] {299c3c7f-a681-453d-b07c-11c22a7ec4be} <Debug> TCPHandler: Processed in 0.037665833 sec. | ||
| 522 | 2025.02.28 10:59:54.744385 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 523 | 2025.02.28 10:59:54.744696 [ 279 ] {112304f5-d861-4317-8ded-38c8ed788f8b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 524 | * NOTE: Array types cannot be Nullable, see | ||
| 525 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 526 | * for more details. | ||
| 527 | * | ||
| 528 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 529 | * is unfortunate, and at this point relies on the fact that an | ||
| 530 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 531 | * to figure out another way to represent missing samples here. | ||
| 532 | */ | ||
| 533 | 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) | ||
| 534 | 2025.02.28 10:59:54.744848 [ 279 ] {112304f5-d861-4317-8ded-38c8ed788f8b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 535 | 2025.02.28 10:59:54.759583 [ 279 ] {112304f5-d861-4317-8ded-38c8ed788f8b} <Debug> oximeter.measurements_histogrami8 (009a090f-564f-4107-92b0-64144aadc836): Loading data parts | ||
| 536 | 2025.02.28 10:59:54.759739 [ 279 ] {112304f5-d861-4317-8ded-38c8ed788f8b} <Debug> oximeter.measurements_histogrami8 (009a090f-564f-4107-92b0-64144aadc836): There are no data parts | ||
| 537 | 2025.02.28 10:59:54.783634 [ 279 ] {112304f5-d861-4317-8ded-38c8ed788f8b} <Debug> TCPHandler: Processed in 0.039308238 sec. | ||
| 538 | 2025.02.28 10:59:54.783865 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 539 | 2025.02.28 10:59:54.784228 [ 274 ] {d7f1b69d-cd47-40b2-ba2f-c641142df1ee} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 540 | 2025.02.28 10:59:54.784404 [ 274 ] {d7f1b69d-cd47-40b2-ba2f-c641142df1ee} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 541 | 2025.02.28 10:59:54.819812 [ 274 ] {d7f1b69d-cd47-40b2-ba2f-c641142df1ee} <Debug> oximeter.measurements_histogramu8 (ecc1a259-4795-4d4a-8c4c-b4abb8e595bc): Loading data parts | ||
| 542 | 2025.02.28 10:59:54.820001 [ 274 ] {d7f1b69d-cd47-40b2-ba2f-c641142df1ee} <Debug> oximeter.measurements_histogramu8 (ecc1a259-4795-4d4a-8c4c-b4abb8e595bc): There are no data parts | ||
| 543 | 2025.02.28 10:59:54.835424 [ 274 ] {d7f1b69d-cd47-40b2-ba2f-c641142df1ee} <Debug> TCPHandler: Processed in 0.051632114 sec. | ||
| 544 | 2025.02.28 10:59:54.835678 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 545 | 2025.02.28 10:59:54.836023 [ 279 ] {cb5a13ff-a884-4c60-9a2d-2172e6eb236d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 546 | 2025.02.28 10:59:54.836169 [ 279 ] {cb5a13ff-a884-4c60-9a2d-2172e6eb236d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 547 | 2025.02.28 10:59:54.860618 [ 279 ] {cb5a13ff-a884-4c60-9a2d-2172e6eb236d} <Debug> oximeter.measurements_histogrami16 (cb50bc29-5c81-466c-917a-f231257a387f): Loading data parts | ||
| 548 | 2025.02.28 10:59:54.860768 [ 279 ] {cb5a13ff-a884-4c60-9a2d-2172e6eb236d} <Debug> oximeter.measurements_histogrami16 (cb50bc29-5c81-466c-917a-f231257a387f): There are no data parts | ||
| 549 | 2025.02.28 10:59:54.867202 [ 279 ] {cb5a13ff-a884-4c60-9a2d-2172e6eb236d} <Debug> TCPHandler: Processed in 0.031581682 sec. | ||
| 550 | 2025.02.28 10:59:54.867433 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 551 | 2025.02.28 10:59:54.867798 [ 274 ] {c23751be-8088-4a95-8664-5f1f9e8b5474} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 552 | 2025.02.28 10:59:54.867970 [ 274 ] {c23751be-8088-4a95-8664-5f1f9e8b5474} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 553 | 2025.02.28 10:59:54.893517 [ 274 ] {c23751be-8088-4a95-8664-5f1f9e8b5474} <Debug> oximeter.measurements_histogramu16 (749e5de7-647b-4dbf-b638-e3c78792398d): Loading data parts | ||
| 554 | 2025.02.28 10:59:54.893690 [ 274 ] {c23751be-8088-4a95-8664-5f1f9e8b5474} <Debug> oximeter.measurements_histogramu16 (749e5de7-647b-4dbf-b638-e3c78792398d): There are no data parts | ||
| 555 | 2025.02.28 10:59:54.911669 [ 274 ] {c23751be-8088-4a95-8664-5f1f9e8b5474} <Debug> TCPHandler: Processed in 0.044305942 sec. | ||
| 556 | 2025.02.28 10:59:54.911940 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 557 | 2025.02.28 10:59:54.912291 [ 279 ] {ae7c5d3f-9f13-4001-bad8-f8a7239d1ce6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 558 | 2025.02.28 10:59:54.912440 [ 279 ] {ae7c5d3f-9f13-4001-bad8-f8a7239d1ce6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 559 | 2025.02.28 10:59:54.920632 [ 279 ] {ae7c5d3f-9f13-4001-bad8-f8a7239d1ce6} <Debug> oximeter.measurements_histogrami32 (3c2edad3-e6c6-438b-b859-7d5f3da08e1b): Loading data parts | ||
| 560 | 2025.02.28 10:59:54.920796 [ 279 ] {ae7c5d3f-9f13-4001-bad8-f8a7239d1ce6} <Debug> oximeter.measurements_histogrami32 (3c2edad3-e6c6-438b-b859-7d5f3da08e1b): There are no data parts | ||
| 561 | 2025.02.28 10:59:54.926180 [ 279 ] {ae7c5d3f-9f13-4001-bad8-f8a7239d1ce6} <Debug> TCPHandler: Processed in 0.014299533 sec. | ||
| 562 | 2025.02.28 10:59:54.926412 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 563 | 2025.02.28 10:59:54.926773 [ 274 ] {e9990e3b-768a-467b-81b1-d32d9ecfa895} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 564 | 2025.02.28 10:59:54.926940 [ 274 ] {e9990e3b-768a-467b-81b1-d32d9ecfa895} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 565 | 2025.02.28 10:59:54.960665 [ 274 ] {e9990e3b-768a-467b-81b1-d32d9ecfa895} <Debug> oximeter.measurements_histogramu32 (50f56126-40d5-4899-9f88-1db832271094): Loading data parts | ||
| 566 | 2025.02.28 10:59:54.960874 [ 274 ] {e9990e3b-768a-467b-81b1-d32d9ecfa895} <Debug> oximeter.measurements_histogramu32 (50f56126-40d5-4899-9f88-1db832271094): There are no data parts | ||
| 567 | 2025.02.28 10:59:54.974662 [ 274 ] {e9990e3b-768a-467b-81b1-d32d9ecfa895} <Debug> TCPHandler: Processed in 0.048323666 sec. | ||
| 568 | 2025.02.28 10:59:54.974867 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 569 | 2025.02.28 10:59:54.975206 [ 279 ] {04a44cd3-3dd5-4174-a757-10012c62abea} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 570 | 2025.02.28 10:59:54.975292 [ 279 ] {04a44cd3-3dd5-4174-a757-10012c62abea} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 571 | 2025.02.28 10:59:54.995545 [ 279 ] {04a44cd3-3dd5-4174-a757-10012c62abea} <Debug> oximeter.measurements_histogrami64 (39b86942-1db2-4863-b9c4-8b3fad502b57): Loading data parts | ||
| 572 | 2025.02.28 10:59:54.995706 [ 279 ] {04a44cd3-3dd5-4174-a757-10012c62abea} <Debug> oximeter.measurements_histogrami64 (39b86942-1db2-4863-b9c4-8b3fad502b57): There are no data parts | ||
| 573 | 2025.02.28 10:59:55.000219 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 134.70 MiB, peak 134.70 MiB, free memory in arenas 0.00 B, will set to 135.86 MiB (RSS), difference: 1.16 MiB | ||
| 574 | 2025.02.28 10:59:55.009140 [ 279 ] {04a44cd3-3dd5-4174-a757-10012c62abea} <Debug> TCPHandler: Processed in 0.034332335 sec. | ||
| 575 | 2025.02.28 10:59:55.009364 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 576 | 2025.02.28 10:59:55.009723 [ 274 ] {5869a160-ecfb-4e4f-bf1b-4057168849be} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 577 | 2025.02.28 10:59:55.009829 [ 274 ] {5869a160-ecfb-4e4f-bf1b-4057168849be} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 578 | 2025.02.28 10:59:55.033086 [ 274 ] {5869a160-ecfb-4e4f-bf1b-4057168849be} <Debug> oximeter.measurements_histogramu64 (e474aff8-004c-4eac-a92a-2570bb42230d): Loading data parts | ||
| 579 | 2025.02.28 10:59:55.033275 [ 274 ] {5869a160-ecfb-4e4f-bf1b-4057168849be} <Debug> oximeter.measurements_histogramu64 (e474aff8-004c-4eac-a92a-2570bb42230d): There are no data parts | ||
| 580 | 2025.02.28 10:59:55.042519 [ 274 ] {5869a160-ecfb-4e4f-bf1b-4057168849be} <Debug> TCPHandler: Processed in 0.033221845 sec. | ||
| 581 | 2025.02.28 10:59:55.042756 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 582 | 2025.02.28 10:59:55.043112 [ 279 ] {1119e4e9-6312-4461-aa90-9d77300364b6} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 583 | 2025.02.28 10:59:55.043228 [ 279 ] {1119e4e9-6312-4461-aa90-9d77300364b6} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 584 | 2025.02.28 10:59:55.058353 [ 279 ] {1119e4e9-6312-4461-aa90-9d77300364b6} <Debug> oximeter.measurements_histogramf32 (3aa7f90a-1778-4914-923e-c6ea1b64a53d): Loading data parts | ||
| 585 | 2025.02.28 10:59:55.058530 [ 279 ] {1119e4e9-6312-4461-aa90-9d77300364b6} <Debug> oximeter.measurements_histogramf32 (3aa7f90a-1778-4914-923e-c6ea1b64a53d): There are no data parts | ||
| 586 | 2025.02.28 10:59:55.078610 [ 279 ] {1119e4e9-6312-4461-aa90-9d77300364b6} <Debug> TCPHandler: Processed in 0.035918539 sec. | ||
| 587 | 2025.02.28 10:59:55.078976 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 588 | 2025.02.28 10:59:55.079588 [ 274 ] {be174fa9-e0f0-48f6-8d9f-93f12770c468} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 589 | 2025.02.28 10:59:55.079753 [ 274 ] {be174fa9-e0f0-48f6-8d9f-93f12770c468} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 590 | 2025.02.28 10:59:55.092836 [ 274 ] {be174fa9-e0f0-48f6-8d9f-93f12770c468} <Debug> oximeter.measurements_histogramf64 (44769ace-fa48-474d-8317-cfb16fcb63ae): Loading data parts | ||
| 591 | 2025.02.28 10:59:55.092999 [ 274 ] {be174fa9-e0f0-48f6-8d9f-93f12770c468} <Debug> oximeter.measurements_histogramf64 (44769ace-fa48-474d-8317-cfb16fcb63ae): There are no data parts | ||
| 592 | 2025.02.28 10:59:55.105995 [ 274 ] {be174fa9-e0f0-48f6-8d9f-93f12770c468} <Debug> TCPHandler: Processed in 0.027124883 sec. | ||
| 593 | 2025.02.28 10:59:55.106213 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 594 | 2025.02.28 10:59:55.106470 [ 279 ] {a69a843e-556f-484a-8265-53fa506e9741} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) /* The field tables store named dimensions of each timeseries. | ||
| 595 | * | ||
| 596 | * As with the measurement tables, there is one field table for each field data | ||
| 597 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 598 | * this behavior **must not** be relied upon for query correctness. | ||
| 599 | * | ||
| 600 | * The index for the fields differs from the measurements, however. Rows are | ||
| 601 | * sorted by timeseries name, then field name, field value, and finally | ||
| 602 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 603 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 604 | * usually then used to look up measurements. | ||
| 605 | * | ||
| 606 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 607 | * timeseries name and then key, since it would improve lookups where one | ||
| 608 | * already has the key. Realistically though, these tables are quite small and | ||
| 609 | * so performance benefits will be low in absolute terms. | ||
| 610 | * | ||
| 611 | * TTL: We use a materialized column to expire old field table records. This | ||
| 612 | * column is generated automatically by the database whenever a new row is | ||
| 613 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 614 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 615 | * record will remain during a deduplication, which will have the last | ||
| 616 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 617 | * measurement tables. | ||
| 618 | */ | ||
| 619 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 620 | 2025.02.28 10:59:55.106571 [ 279 ] {a69a843e-556f-484a-8265-53fa506e9741} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 621 | 2025.02.28 10:59:55.130143 [ 279 ] {a69a843e-556f-484a-8265-53fa506e9741} <Debug> oximeter.fields_bool (b94dec72-d677-4501-9c44-0136d3207b03): Loading data parts | ||
| 622 | 2025.02.28 10:59:55.130359 [ 279 ] {a69a843e-556f-484a-8265-53fa506e9741} <Debug> oximeter.fields_bool (b94dec72-d677-4501-9c44-0136d3207b03): There are no data parts | ||
| 623 | 2025.02.28 10:59:55.141358 [ 279 ] {a69a843e-556f-484a-8265-53fa506e9741} <Debug> TCPHandler: Processed in 0.035214973 sec. | ||
| 624 | 2025.02.28 10:59:55.141567 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 625 | 2025.02.28 10:59:55.141826 [ 274 ] {6a303927-7291-49b0-97ab-98f19880f461} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 626 | 2025.02.28 10:59:55.141891 [ 274 ] {6a303927-7291-49b0-97ab-98f19880f461} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 627 | 2025.02.28 10:59:55.154387 [ 274 ] {6a303927-7291-49b0-97ab-98f19880f461} <Debug> oximeter.fields_i8 (01a0eabd-51b0-46bd-8c7f-14da0e81e16f): Loading data parts | ||
| 628 | 2025.02.28 10:59:55.154591 [ 274 ] {6a303927-7291-49b0-97ab-98f19880f461} <Debug> oximeter.fields_i8 (01a0eabd-51b0-46bd-8c7f-14da0e81e16f): There are no data parts | ||
| 629 | 2025.02.28 10:59:55.165869 [ 274 ] {6a303927-7291-49b0-97ab-98f19880f461} <Debug> TCPHandler: Processed in 0.02436291 sec. | ||
| 630 | 2025.02.28 10:59:55.166158 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 631 | 2025.02.28 10:59:55.166413 [ 279 ] {50273b0f-de92-40ac-b138-b095dc8c75af} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 632 | 2025.02.28 10:59:55.166516 [ 279 ] {50273b0f-de92-40ac-b138-b095dc8c75af} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 633 | 2025.02.28 10:59:55.188217 [ 279 ] {50273b0f-de92-40ac-b138-b095dc8c75af} <Debug> oximeter.fields_u8 (6112c10b-e986-46b7-b595-7e043f2a0350): Loading data parts | ||
| 634 | 2025.02.28 10:59:55.188559 [ 279 ] {50273b0f-de92-40ac-b138-b095dc8c75af} <Debug> oximeter.fields_u8 (6112c10b-e986-46b7-b595-7e043f2a0350): There are no data parts | ||
| 635 | 2025.02.28 10:59:55.201042 [ 279 ] {50273b0f-de92-40ac-b138-b095dc8c75af} <Debug> TCPHandler: Processed in 0.034951191 sec. | ||
| 636 | 2025.02.28 10:59:55.201320 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 637 | 2025.02.28 10:59:55.201597 [ 274 ] {939304ed-8519-4e3a-9726-5b2b4308bdac} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 638 | 2025.02.28 10:59:55.201676 [ 274 ] {939304ed-8519-4e3a-9726-5b2b4308bdac} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 639 | 2025.02.28 10:59:55.215106 [ 274 ] {939304ed-8519-4e3a-9726-5b2b4308bdac} <Debug> oximeter.fields_i16 (dbe97eb2-0e9a-4d77-a1d1-9640005479f4): Loading data parts | ||
| 640 | 2025.02.28 10:59:55.215305 [ 274 ] {939304ed-8519-4e3a-9726-5b2b4308bdac} <Debug> oximeter.fields_i16 (dbe97eb2-0e9a-4d77-a1d1-9640005479f4): There are no data parts | ||
| 641 | 2025.02.28 10:59:55.228577 [ 274 ] {939304ed-8519-4e3a-9726-5b2b4308bdac} <Debug> TCPHandler: Processed in 0.027318295 sec. | ||
| 642 | 2025.02.28 10:59:55.228904 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 643 | 2025.02.28 10:59:55.229303 [ 279 ] {8c66e850-3f21-42cc-b8b7-627247dbbaf8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 644 | 2025.02.28 10:59:55.229456 [ 279 ] {8c66e850-3f21-42cc-b8b7-627247dbbaf8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 645 | 2025.02.28 10:59:55.239486 [ 279 ] {8c66e850-3f21-42cc-b8b7-627247dbbaf8} <Debug> oximeter.fields_u16 (19a30a36-0c2f-4544-a5eb-e31ea8277b86): Loading data parts | ||
| 646 | 2025.02.28 10:59:55.239748 [ 279 ] {8c66e850-3f21-42cc-b8b7-627247dbbaf8} <Debug> oximeter.fields_u16 (19a30a36-0c2f-4544-a5eb-e31ea8277b86): There are no data parts | ||
| 647 | 2025.02.28 10:59:55.261441 [ 279 ] {8c66e850-3f21-42cc-b8b7-627247dbbaf8} <Debug> TCPHandler: Processed in 0.032649651 sec. | ||
| 648 | 2025.02.28 10:59:55.261665 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 649 | 2025.02.28 10:59:55.261966 [ 274 ] {5a12cf1e-80de-4bd1-94f1-89bc09f79a7d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 650 | 2025.02.28 10:59:55.262053 [ 274 ] {5a12cf1e-80de-4bd1-94f1-89bc09f79a7d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 651 | 2025.02.28 10:59:55.268804 [ 274 ] {5a12cf1e-80de-4bd1-94f1-89bc09f79a7d} <Debug> oximeter.fields_i32 (a83448a1-99a8-46f8-9847-60bee0cb8034): Loading data parts | ||
| 652 | 2025.02.28 10:59:55.269074 [ 274 ] {5a12cf1e-80de-4bd1-94f1-89bc09f79a7d} <Debug> oximeter.fields_i32 (a83448a1-99a8-46f8-9847-60bee0cb8034): There are no data parts | ||
| 653 | 2025.02.28 10:59:55.278319 [ 274 ] {5a12cf1e-80de-4bd1-94f1-89bc09f79a7d} <Debug> TCPHandler: Processed in 0.016722254 sec. | ||
| 654 | 2025.02.28 10:59:55.278553 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 655 | 2025.02.28 10:59:55.278766 [ 279 ] {dde7505c-fd22-46b5-a8da-94953ceef742} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 656 | 2025.02.28 10:59:55.278862 [ 279 ] {dde7505c-fd22-46b5-a8da-94953ceef742} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 657 | 2025.02.28 10:59:55.291423 [ 279 ] {dde7505c-fd22-46b5-a8da-94953ceef742} <Debug> oximeter.fields_u32 (2eaa95de-593f-4fd4-bb25-90408aa9e11b): Loading data parts | ||
| 658 | 2025.02.28 10:59:55.291613 [ 279 ] {dde7505c-fd22-46b5-a8da-94953ceef742} <Debug> oximeter.fields_u32 (2eaa95de-593f-4fd4-bb25-90408aa9e11b): There are no data parts | ||
| 659 | 2025.02.28 10:59:55.301838 [ 279 ] {dde7505c-fd22-46b5-a8da-94953ceef742} <Debug> TCPHandler: Processed in 0.02334721 sec. | ||
| 660 | 2025.02.28 10:59:55.302098 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 661 | 2025.02.28 10:59:55.302419 [ 274 ] {4854615d-b786-4264-8aa9-d338d5f199b7} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 662 | 2025.02.28 10:59:55.302507 [ 274 ] {4854615d-b786-4264-8aa9-d338d5f199b7} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 663 | 2025.02.28 10:59:55.314859 [ 274 ] {4854615d-b786-4264-8aa9-d338d5f199b7} <Debug> oximeter.fields_i64 (aa6db183-5d75-4c54-9517-b28f725d0d71): Loading data parts | ||
| 664 | 2025.02.28 10:59:55.315029 [ 274 ] {4854615d-b786-4264-8aa9-d338d5f199b7} <Debug> oximeter.fields_i64 (aa6db183-5d75-4c54-9517-b28f725d0d71): There are no data parts | ||
| 665 | 2025.02.28 10:59:55.325548 [ 274 ] {4854615d-b786-4264-8aa9-d338d5f199b7} <Debug> TCPHandler: Processed in 0.023521272 sec. | ||
| 666 | 2025.02.28 10:59:55.325757 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 667 | 2025.02.28 10:59:55.325967 [ 279 ] {2b21878e-d563-4a86-94e7-10f3a1d6bb64} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 668 | 2025.02.28 10:59:55.326060 [ 279 ] {2b21878e-d563-4a86-94e7-10f3a1d6bb64} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 669 | 2025.02.28 10:59:55.339071 [ 279 ] {2b21878e-d563-4a86-94e7-10f3a1d6bb64} <Debug> oximeter.fields_u64 (bc890227-5ac4-4e96-96f4-375956c91a79): Loading data parts | ||
| 670 | 2025.02.28 10:59:55.339233 [ 279 ] {2b21878e-d563-4a86-94e7-10f3a1d6bb64} <Debug> oximeter.fields_u64 (bc890227-5ac4-4e96-96f4-375956c91a79): There are no data parts | ||
| 671 | 2025.02.28 10:59:55.349645 [ 279 ] {2b21878e-d563-4a86-94e7-10f3a1d6bb64} <Debug> TCPHandler: Processed in 0.023947416 sec. | ||
| 672 | 2025.02.28 10:59:55.349890 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 673 | 2025.02.28 10:59:55.350191 [ 274 ] {008f363f-dfc4-4045-8908-024319e4b97d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 674 | 2025.02.28 10:59:55.350281 [ 274 ] {008f363f-dfc4-4045-8908-024319e4b97d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 675 | 2025.02.28 10:59:55.363161 [ 274 ] {008f363f-dfc4-4045-8908-024319e4b97d} <Debug> oximeter.fields_ipaddr (6e2e50dc-d4a0-46ba-b44d-8ade448b3fc9): Loading data parts | ||
| 676 | 2025.02.28 10:59:55.363332 [ 274 ] {008f363f-dfc4-4045-8908-024319e4b97d} <Debug> oximeter.fields_ipaddr (6e2e50dc-d4a0-46ba-b44d-8ade448b3fc9): There are no data parts | ||
| 677 | 2025.02.28 10:59:55.374000 [ 274 ] {008f363f-dfc4-4045-8908-024319e4b97d} <Debug> TCPHandler: Processed in 0.024177868 sec. | ||
| 678 | 2025.02.28 10:59:55.374337 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 679 | 2025.02.28 10:59:55.374721 [ 279 ] {015f4e49-dfb2-4939-9853-0c8db4e201e5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) 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) | ||
| 680 | 2025.02.28 10:59:55.374821 [ 279 ] {015f4e49-dfb2-4939-9853-0c8db4e201e5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 681 | 2025.02.28 10:59:55.387294 [ 279 ] {015f4e49-dfb2-4939-9853-0c8db4e201e5} <Debug> oximeter.fields_string (6d335b59-4d0c-4e82-b5a0-8e719b9876af): Loading data parts | ||
| 682 | 2025.02.28 10:59:55.387437 [ 279 ] {015f4e49-dfb2-4939-9853-0c8db4e201e5} <Debug> oximeter.fields_string (6d335b59-4d0c-4e82-b5a0-8e719b9876af): There are no data parts | ||
| 683 | 2025.02.28 10:59:55.398481 [ 279 ] {015f4e49-dfb2-4939-9853-0c8db4e201e5} <Debug> TCPHandler: Processed in 0.024260739 sec. | ||
| 684 | 2025.02.28 10:59:55.398746 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 685 | 2025.02.28 10:59:55.399024 [ 274 ] {a643a36a-7825-4f2b-986e-630889685e05} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) 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) | ||
| 686 | 2025.02.28 10:59:55.399127 [ 274 ] {a643a36a-7825-4f2b-986e-630889685e05} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 687 | 2025.02.28 10:59:55.411776 [ 274 ] {a643a36a-7825-4f2b-986e-630889685e05} <Debug> oximeter.fields_uuid (87e7a04a-061c-4847-9c03-54618577c205): Loading data parts | ||
| 688 | 2025.02.28 10:59:55.411970 [ 274 ] {a643a36a-7825-4f2b-986e-630889685e05} <Debug> oximeter.fields_uuid (87e7a04a-061c-4847-9c03-54618577c205): There are no data parts | ||
| 689 | 2025.02.28 10:59:55.422277 [ 274 ] {a643a36a-7825-4f2b-986e-630889685e05} <Debug> TCPHandler: Processed in 0.023600243 sec. | ||
| 690 | 2025.02.28 10:59:55.422529 [ 279 ] {} <Trace> TCP-Session: e6e897ba-8a91-4bd3-9049-69b022311116 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 691 | 2025.02.28 10:59:55.422900 [ 279 ] {f584527d-bc79-439b-912f-0234a53da9ac} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:42906) /* The timeseries schema table stores the extracted schema for the samples | ||
| 692 | * oximeter collects. | ||
| 693 | */ | ||
| 694 | 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) | ||
| 695 | 2025.02.28 10:59:55.423034 [ 279 ] {f584527d-bc79-439b-912f-0234a53da9ac} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 696 | 2025.02.28 10:59:55.435506 [ 279 ] {f584527d-bc79-439b-912f-0234a53da9ac} <Debug> oximeter.timeseries_schema (c25b39e1-ad34-4152-b32b-f3a3b63335c3): Loading data parts | ||
| 697 | 2025.02.28 10:59:55.435641 [ 279 ] {f584527d-bc79-439b-912f-0234a53da9ac} <Debug> oximeter.timeseries_schema (c25b39e1-ad34-4152-b32b-f3a3b63335c3): There are no data parts | ||
| 698 | 2025.02.28 10:59:55.446528 [ 279 ] {f584527d-bc79-439b-912f-0234a53da9ac} <Debug> TCPHandler: Processed in 0.024086637 sec. | ||
| 699 | 2025.02.28 10:59:55.446802 [ 274 ] {} <Trace> TCP-Session: cddd95d0-0472-4831-b1f4-00e82855d86a Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 700 | 2025.02.28 10:59:55.447070 [ 274 ] {9496c3a7-f71e-4616-b20a-dd823fa23904} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:39449) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 701 | 2025.02.28 10:59:55.448346 [ 274 ] {9496c3a7-f71e-4616-b20a-dd823fa23904} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 702 | 2025.02.28 10:59:55.456208 [ 284 ] {9496c3a7-f71e-4616-b20a-dd823fa23904} <Trace> oximeter.version (712547d3-72e5-4035-bd7a-4eca71f163ef): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 703 | 2025.02.28 10:59:55.456247 [ 284 ] {9496c3a7-f71e-4616-b20a-dd823fa23904} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.09 GiB. | ||
| 704 | 2025.02.28 10:59:55.460757 [ 284 ] {9496c3a7-f71e-4616-b20a-dd823fa23904} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 705 | 2025.02.28 10:59:55.461100 [ 284 ] {9496c3a7-f71e-4616-b20a-dd823fa23904} <Trace> oximeter.version (712547d3-72e5-4035-bd7a-4eca71f163ef): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 706 | 2025.02.28 10:59:55.461421 [ 274 ] {9496c3a7-f71e-4616-b20a-dd823fa23904} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.014478 sec., 69.07031357922365 rows/sec., 1.08 KiB/sec. | ||
| 707 | 2025.02.28 10:59:55.461785 [ 274 ] {9496c3a7-f71e-4616-b20a-dd823fa23904} <Debug> TCPHandler: Processed in 0.015053699 sec. | ||
| 708 | 2025.02.28 10:59:56.000168 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 137.23 MiB, peak 137.23 MiB, free memory in arenas 0.00 B, will set to 140.98 MiB (RSS), difference: 3.75 MiB | ||
| 709 | 2025.02.28 10:59:59.991990 [ 242 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 710 | 2025.02.28 10:59:59.992041 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488 | ||
| 711 | 2025.02.28 10:59:59.992152 [ 242 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 712 | 2025.02.28 10:59:59.992173 [ 244 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 713 | 2025.02.28 11:00:00.000176 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 141.06 MiB, peak 141.06 MiB, free memory in arenas 0.00 B, will set to 142.42 MiB (RSS), difference: 1.36 MiB | ||
| 714 | 2025.02.28 11:00:00.003701 [ 244 ] {} <Debug> system.asynchronous_metric_log (185bd73b-c1aa-414c-83d6-6c562429fcb8): Loading data parts | ||
| 715 | 2025.02.28 11:00:00.004056 [ 244 ] {} <Debug> system.asynchronous_metric_log (185bd73b-c1aa-414c-83d6-6c562429fcb8): There are no data parts | ||
| 716 | 2025.02.28 11:00:00.011618 [ 244 ] {} <Trace> system.asynchronous_metric_log (185bd73b-c1aa-414c-83d6-6c562429fcb8): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 717 | 2025.02.28 11:00:00.011657 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.08 GiB. | ||
| 718 | 2025.02.28 11:00:00.013746 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 719 | 2025.02.28 11:00:00.014232 [ 244 ] {} <Trace> system.asynchronous_metric_log (185bd73b-c1aa-414c-83d6-6c562429fcb8): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 720 | 2025.02.28 11:00:00.014514 [ 244 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488 | ||
| 721 | 2025.02.28 11:00:00.016673 [ 242 ] {} <Debug> system.metric_log (d3e56e57-fa4b-4e00-8388-1bebee22f779): Loading data parts | ||
| 722 | 2025.02.28 11:00:00.016841 [ 242 ] {} <Debug> system.metric_log (d3e56e57-fa4b-4e00-8388-1bebee22f779): There are no data parts | ||
| 723 | 2025.02.28 11:00:00.053692 [ 242 ] {} <Trace> system.metric_log (d3e56e57-fa4b-4e00-8388-1bebee22f779): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 724 | 2025.02.28 11:00:00.053741 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 15.08 GiB. | ||
| 725 | 2025.02.28 11:00:00.062027 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 726 | 2025.02.28 11:00:00.063412 [ 242 ] {} <Trace> system.metric_log (d3e56e57-fa4b-4e00-8388-1bebee22f779): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 727 | 2025.02.28 11:00:00.066803 [ 242 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||