| 1 | [ Dec 13 22:29:32 Enabled. ] | ||
| 2 | [ Dec 13 22:29:32 Rereading configuration. ] | ||
| 3 | [ Dec 13 22:29:34 Rereading configuration. ] | ||
| 4 | [ Dec 13 22:29:46 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 | [ Dec 13 22:29:46 Method "start" exited with status 0. ] | ||
| 25 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 26 | Logging trace to /var/tmp/clickhouse-server.log | ||
| 27 | Logging errors to /var/tmp/clickhouse-server.errlog | ||
| 28 | 2024.12.13 22:29:47.803914 [ 1 ] {} <Information> Application: Will watch for the process with pid 23951 | ||
| 29 | 2024.12.13 22:29:47.804328 [ 1 ] {} <Information> Application: Forked a child process to watch | ||
| 30 | 2024.12.13 22:29:48.022139 [ 1 ] {} <Information> Application: Starting ClickHouse 23.8.7.1 (revision: 54477, git hash: b6a391579f09dde47a1aa5602e154e7fcde80d1e, build id: <unknown>), PID 23951 | ||
| 31 | 2024.12.13 22:29:48.022919 [ 1 ] {} <Information> Application: starting up | ||
| 32 | 2024.12.13 22:29:48.023646 [ 1 ] {} <Information> Application: OS name: SunOS, version: 5.11, architecture: i86pc | ||
| 33 | 2024.12.13 22:29:48.125740 [ 1 ] {} <Information> Application: Available RAM: 95.88 GiB; physical cores: 48; logical cores: 48. | ||
| 34 | 2024.12.13 22:29:48.173205 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 65536 | ||
| 35 | 2024.12.13 22:29:48.173293 [ 1 ] {} <Debug> Application: Initializing DateLUT. | ||
| 36 | 2024.12.13 22:29:48.173306 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone 'UTC'. | ||
| 37 | 2024.12.13 22:29:48.173379 [ 1 ] {} <Debug> Context: Setting up /data/tmp/ to store temporary data in it | ||
| 38 | 2024.12.13 22:29:48.173956 [ 1 ] {} <Debug> Application: Initializing interserver credentials. | ||
| 39 | 2024.12.13 22:29:48.175696 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
| 40 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 41 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 42 | 2024.12.13 22:29:48.176527 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 43 | 2024.12.13 22:29:48.177403 [ 1 ] {} <Information> Application: Setting max_server_memory_usage was set to 86.29 GiB (95.88 GiB available * 0.90 max_server_memory_usage_to_ram_ratio) | ||
| 44 | 2024.12.13 22:29:48.177476 [ 1 ] {} <Information> Application: Setting merges_mutations_memory_usage_soft_limit was set to 47.94 GiB (95.88 GiB available * 0.50 merges_mutations_memory_usage_to_ram_ratio) | ||
| 45 | 2024.12.13 22:29:48.177522 [ 1 ] {} <Information> Application: Merges and mutations memory limit is set to 47.94 GiB | ||
| 46 | 2024.12.13 22:29:48.177710 [ 1 ] {} <Information> BackgroundSchedulePool/BgBufSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 47 | 2024.12.13 22:29:48.178787 [ 1 ] {} <Information> BackgroundSchedulePool/BgSchPool: Create BackgroundSchedulePool with 128 threads | ||
| 48 | 2024.12.13 22:29:48.184243 [ 1 ] {} <Information> BackgroundSchedulePool/BgMBSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 49 | 2024.12.13 22:29:48.185218 [ 1 ] {} <Information> BackgroundSchedulePool/BgDistSchPool: Create BackgroundSchedulePool with 16 threads | ||
| 50 | 2024.12.13 22:29:48.186573 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 51 | 2024.12.13 22:29:48.186674 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 52 | 2024.12.13 22:29:48.188479 [ 1 ] {} <Debug> ConfigReloader: Loading config '/opt/oxide/clickhouse/config.xml' | ||
| 53 | Processing configuration file '/opt/oxide/clickhouse/config.xml'. | ||
| 54 | Saved preprocessed configuration to '/data/preprocessed_configs/config.xml'. | ||
| 55 | 2024.12.13 22:29:48.189044 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performing update on configuration | ||
| 56 | 2024.12.13 22:29:48.194093 [ 1 ] {} <Debug> ConfigReloader: Loaded config '/opt/oxide/clickhouse/config.xml', performed update on configuration | ||
| 57 | 2024.12.13 22:29:48.194811 [ 1 ] {} <Debug> Access(user directories): Added users_xml access storage 'users_xml', path: /opt/oxide/clickhouse/config.xml | ||
| 58 | 2024.12.13 22:29:48.196459 [ 1 ] {} <Information> Context: Initialized background executor for merges and mutations with num_threads=16, num_tasks=32, scheduling_policy=round_robin | ||
| 59 | 2024.12.13 22:29:48.196914 [ 1 ] {} <Information> Context: Initialized background executor for move operations with num_threads=8, num_tasks=8 | ||
| 60 | 2024.12.13 22:29:48.197510 [ 1 ] {} <Information> Context: Initialized background executor for fetches with num_threads=8, num_tasks=8 | ||
| 61 | 2024.12.13 22:29:48.197948 [ 1 ] {} <Information> Context: Initialized background executor for common operations (e.g. clearing old parts) with num_threads=8, num_tasks=8 | ||
| 62 | 2024.12.13 22:29:48.199425 [ 1 ] {} <Information> DNSCacheUpdater: Update period 15 seconds | ||
| 63 | 2024.12.13 22:29:48.199454 [ 1 ] {} <Information> Application: Loading metadata from /data/ | ||
| 64 | 2024.12.13 22:29:48.199525 [ 24 ] {} <Debug> DNSResolver: Updating DNS cache | ||
| 65 | 2024.12.13 22:29:48.199648 [ 24 ] {} <Debug> DNSResolver: Updated DNS cache | ||
| 66 | 2024.12.13 22:29:48.211842 [ 1 ] {} <Information> DatabaseAtomic (system): Metadata processed, database system has 0 tables and 0 dictionaries in total. | ||
| 67 | 2024.12.13 22:29:48.211870 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000160685 sec | ||
| 68 | 2024.12.13 22:29:48.211958 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 69 | 2024.12.13 22:29:48.212008 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 70 | 2024.12.13 22:29:48.213285 [ 1 ] {} <Information> DatabaseAtomic (system): Starting up tables. | ||
| 71 | 2024.12.13 22:29:48.214571 [ 1 ] {} <Debug> SystemLog: Creating system.query_log from query_log | ||
| 72 | 2024.12.13 22:29:48.226695 [ 1 ] {} <Debug> SystemLog: Not creating system.query_thread_log since corresponding section 'query_thread_log' is missing from config | ||
| 73 | 2024.12.13 22:29:48.226745 [ 1 ] {} <Debug> SystemLog: Not creating system.part_log since corresponding section 'part_log' is missing from config | ||
| 74 | 2024.12.13 22:29:48.226846 [ 1 ] {} <Debug> SystemLog: Not creating system.trace_log since corresponding section 'trace_log' is missing from config | ||
| 75 | 2024.12.13 22:29:48.226862 [ 1 ] {} <Debug> SystemLog: Not creating system.crash_log since corresponding section 'crash_log' is missing from config | ||
| 76 | 2024.12.13 22:29:48.226896 [ 1 ] {} <Debug> SystemLog: Not creating system.text_log since corresponding section 'text_log' is missing from config | ||
| 77 | 2024.12.13 22:29:48.226973 [ 1 ] {} <Debug> SystemLog: Creating system.metric_log from metric_log | ||
| 78 | 2024.12.13 22:29:48.230306 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_cache_log since corresponding section 'filesystem_cache_log' is missing from config | ||
| 79 | 2024.12.13 22:29:48.230354 [ 1 ] {} <Debug> SystemLog: Not creating system.filesystem_read_prefetches_log since corresponding section 'filesystem_read_prefetches_log' is missing from config | ||
| 80 | 2024.12.13 22:29:48.230412 [ 1 ] {} <Debug> SystemLog: Creating system.asynchronous_metric_log from asynchronous_metric_log | ||
| 81 | 2024.12.13 22:29:48.230625 [ 1 ] {} <Debug> SystemLog: Not creating system.opentelemetry_span_log since corresponding section 'opentelemetry_span_log' is missing from config | ||
| 82 | 2024.12.13 22:29:48.230651 [ 1 ] {} <Debug> SystemLog: Not creating system.query_views_log since corresponding section 'query_views_log' is missing from config | ||
| 83 | 2024.12.13 22:29:48.230687 [ 1 ] {} <Debug> SystemLog: Not creating system.zookeeper_log since corresponding section 'zookeeper_log' is missing from config | ||
| 84 | 2024.12.13 22:29:48.230764 [ 1 ] {} <Debug> SystemLog: Not creating system.session_log since corresponding section 'session_log' is missing from config | ||
| 85 | 2024.12.13 22:29:48.230778 [ 1 ] {} <Debug> SystemLog: Not creating system.transactions_info_log since corresponding section 'transactions_info_log' is missing from config | ||
| 86 | 2024.12.13 22:29:48.230808 [ 1 ] {} <Debug> SystemLog: Not creating system.processors_profile_log since corresponding section 'processors_profile_log' is missing from config | ||
| 87 | 2024.12.13 22:29:48.230879 [ 1 ] {} <Debug> SystemLog: Not creating system.asynchronous_insert_log since corresponding section 'asynchronous_insert_log' is missing from config | ||
| 88 | 2024.12.13 22:29:48.260104 [ 1 ] {} <Information> DatabaseCatalog: Found 0 partially dropped tables. Will load them and retry removal. | ||
| 89 | 2024.12.13 22:29:48.261707 [ 1 ] {} <Information> DatabaseAtomic (default): Metadata processed, database default has 0 tables and 0 dictionaries in total. | ||
| 90 | 2024.12.13 22:29:48.261856 [ 1 ] {} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 0.000175475 sec | ||
| 91 | 2024.12.13 22:29:48.261871 [ 1 ] {} <Trace> ReferentialDeps: No tables | ||
| 92 | 2024.12.13 22:29:48.261883 [ 1 ] {} <Trace> LoadingDeps: No tables | ||
| 93 | 2024.12.13 22:29:48.261909 [ 1 ] {} <Information> DatabaseAtomic (default): Starting up tables. | ||
| 94 | 2024.12.13 22:29:48.262140 [ 1 ] {} <Information> UserDefinedSQLObjectsLoaderFromDisk: Loading user defined objects from /data/user_defined/ | ||
| 95 | 2024.12.13 22:29:48.262246 [ 1 ] {} <Debug> UserDefinedSQLObjectsLoaderFromDisk: User defined objects loaded | ||
| 96 | 2024.12.13 22:29:48.262262 [ 1 ] {} <Debug> Application: Loaded metadata. | ||
| 97 | 2024.12.13 22:29:48.262274 [ 1 ] {} <Information> Application: Query Profiler and TraceCollector are disabled because they require PHDR cache to be created (otherwise the function 'dl_iterate_phdr' is not lock free and not async-signal safe). | ||
| 98 | 2024.12.13 22:29:48.262286 [ 1 ] {} <Information> Application: TaskStats is not implemented for this OS. IO accounting will be disabled. | ||
| 99 | 2024.12.13 22:29:48.272777 [ 1 ] {} <Information> CertificateReloader: One of paths is empty. Cannot apply new configuration for certificates. Fill all paths and try again. | ||
| 100 | 2024.12.13 22:29:48.273000 [ 1 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 24.78 MiB, peak 24.78 MiB, free memory in arenas 0.00 B, will set to 117.12 MiB (RSS), difference: 92.34 MiB | ||
| 101 | 2024.12.13 22:29:48.273946 [ 1 ] {} <Trace> AsynchronousMetrics: Update heavy metrics. Update period 1 sec. Update heavy metrics period 120 sec. Heavy metrics calculation elapsed: 2.3841e-05 sec. | ||
| 102 | 2024.12.13 22:29:48.275127 [ 1 ] {} <Information> Application: Listening for http://[fd00:1122:3344:101::e]:8123 | ||
| 103 | 2024.12.13 22:29:48.275224 [ 1 ] {} <Information> Application: Listening for native protocol (tcp): [fd00:1122:3344:101::e]:9000 | ||
| 104 | 2024.12.13 22:29:48.275243 [ 1 ] {} <Information> Application: Ready for connections. | ||
| 105 | 2024.12.13 22:29:48.276654 [ 3 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:45709 | ||
| 106 | 2024.12.13 22:29:48.276967 [ 3 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 107 | 2024.12.13 22:29:48.277025 [ 3 ] {} <Debug> TCP-Session: ecfaf43e-44ca-4b00-ab1e-725315531f39 Authenticating user 'default' from [fd00:1122:3344:101::a]:45709 | ||
| 108 | 2024.12.13 22:29:48.277057 [ 3 ] {} <Debug> TCP-Session: ecfaf43e-44ca-4b00-ab1e-725315531f39 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 109 | 2024.12.13 22:29:48.277131 [ 3 ] {} <Debug> TCP-Session: ecfaf43e-44ca-4b00-ab1e-725315531f39 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 110 | 2024.12.13 22:29:48.277222 [ 3 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 111 | 2024.12.13 22:29:48.277250 [ 3 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 112 | 2024.12.13 22:29:48.277335 [ 3 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 113 | 2024.12.13 22:29:48.278383 [ 4 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:64172 | ||
| 114 | 2024.12.13 22:29:48.278459 [ 5 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:63490 | ||
| 115 | 2024.12.13 22:29:48.278502 [ 4 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 116 | 2024.12.13 22:29:48.278548 [ 4 ] {} <Debug> TCP-Session: 7f55f7ee-640d-47c9-aa01-6c73d3dd4a03 Authenticating user 'default' from [fd00:1122:3344:101::a]:64172 | ||
| 117 | 2024.12.13 22:29:48.278573 [ 5 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 118 | 2024.12.13 22:29:48.278659 [ 4 ] {} <Debug> TCP-Session: 7f55f7ee-640d-47c9-aa01-6c73d3dd4a03 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 119 | 2024.12.13 22:29:48.278671 [ 5 ] {} <Debug> TCP-Session: 6c3ecc7f-1b2d-408d-b00a-6d8f407055f1 Authenticating user 'default' from [fd00:1122:3344:101::a]:63490 | ||
| 120 | 2024.12.13 22:29:48.278688 [ 4 ] {} <Debug> TCP-Session: 7f55f7ee-640d-47c9-aa01-6c73d3dd4a03 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 121 | 2024.12.13 22:29:48.278783 [ 5 ] {} <Debug> TCP-Session: 6c3ecc7f-1b2d-408d-b00a-6d8f407055f1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 122 | 2024.12.13 22:29:48.278820 [ 5 ] {} <Debug> TCP-Session: 6c3ecc7f-1b2d-408d-b00a-6d8f407055f1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 123 | 2024.12.13 22:29:48.279409 [ 253 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:50877 | ||
| 124 | 2024.12.13 22:29:48.279557 [ 253 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 125 | 2024.12.13 22:29:48.279568 [ 254 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:53075 | ||
| 126 | 2024.12.13 22:29:48.279594 [ 253 ] {} <Debug> TCP-Session: 77813a66-c725-49a8-9bc3-e6268122fa1c Authenticating user 'default' from [fd00:1122:3344:101::a]:50877 | ||
| 127 | 2024.12.13 22:29:48.279822 [ 253 ] {} <Debug> TCP-Session: 77813a66-c725-49a8-9bc3-e6268122fa1c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 128 | 2024.12.13 22:29:48.279852 [ 255 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:36672 | ||
| 129 | 2024.12.13 22:29:48.279867 [ 254 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 130 | 2024.12.13 22:29:48.279871 [ 253 ] {} <Debug> TCP-Session: 77813a66-c725-49a8-9bc3-e6268122fa1c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 131 | 2024.12.13 22:29:48.280022 [ 256 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:43137 | ||
| 132 | 2024.12.13 22:29:48.280154 [ 255 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 133 | 2024.12.13 22:29:48.280206 [ 255 ] {} <Debug> TCP-Session: 1c172a0e-3f4a-4814-8ff1-185f2b03a6b2 Authenticating user 'default' from [fd00:1122:3344:101::a]:36672 | ||
| 134 | 2024.12.13 22:29:48.280216 [ 257 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::a]:38456 | ||
| 135 | 2024.12.13 22:29:48.280350 [ 256 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 136 | 2024.12.13 22:29:48.280362 [ 254 ] {} <Debug> TCP-Session: 2f81878c-470e-440e-a5e1-0fb51da1b25d Authenticating user 'default' from [fd00:1122:3344:101::a]:53075 | ||
| 137 | 2024.12.13 22:29:48.281242 [ 255 ] {} <Debug> TCP-Session: 1c172a0e-3f4a-4814-8ff1-185f2b03a6b2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 138 | 2024.12.13 22:29:48.281375 [ 254 ] {} <Debug> TCP-Session: 2f81878c-470e-440e-a5e1-0fb51da1b25d Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 139 | 2024.12.13 22:29:48.281392 [ 256 ] {} <Debug> TCP-Session: 509d0634-08b1-4a3a-b138-cb3715c45f9c Authenticating user 'default' from [fd00:1122:3344:101::a]:43137 | ||
| 140 | 2024.12.13 22:29:48.281425 [ 254 ] {} <Debug> TCP-Session: 2f81878c-470e-440e-a5e1-0fb51da1b25d Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 141 | 2024.12.13 22:29:48.281415 [ 255 ] {} <Debug> TCP-Session: 1c172a0e-3f4a-4814-8ff1-185f2b03a6b2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 142 | 2024.12.13 22:29:48.281523 [ 256 ] {} <Debug> TCP-Session: 509d0634-08b1-4a3a-b138-cb3715c45f9c Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 143 | 2024.12.13 22:29:48.281384 [ 257 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 144 | 2024.12.13 22:29:48.281657 [ 257 ] {} <Debug> TCP-Session: 8040173f-7000-4504-9012-21017035ea60 Authenticating user 'default' from [fd00:1122:3344:101::a]:38456 | ||
| 145 | 2024.12.13 22:29:48.281710 [ 256 ] {} <Debug> TCP-Session: 509d0634-08b1-4a3a-b138-cb3715c45f9c Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 146 | 2024.12.13 22:29:48.281722 [ 257 ] {} <Debug> TCP-Session: 8040173f-7000-4504-9012-21017035ea60 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 147 | 2024.12.13 22:29:48.281824 [ 257 ] {} <Debug> TCP-Session: 8040173f-7000-4504-9012-21017035ea60 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 148 | 2024.12.13 22:29:48.301964 [ 258 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:49183 | ||
| 149 | 2024.12.13 22:29:48.302112 [ 258 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 150 | 2024.12.13 22:29:48.302215 [ 258 ] {} <Debug> TCP-Session: 6e052b03-0911-4fa1-bb39-8e0d3c70dea0 Authenticating user 'default' from [fd00:1122:3344:101::b]:49183 | ||
| 151 | 2024.12.13 22:29:48.302239 [ 258 ] {} <Debug> TCP-Session: 6e052b03-0911-4fa1-bb39-8e0d3c70dea0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 152 | 2024.12.13 22:29:48.302253 [ 258 ] {} <Debug> TCP-Session: 6e052b03-0911-4fa1-bb39-8e0d3c70dea0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 153 | 2024.12.13 22:29:48.302377 [ 258 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 154 | 2024.12.13 22:29:48.302405 [ 258 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 155 | 2024.12.13 22:29:48.302482 [ 258 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 156 | 2024.12.13 22:29:48.303582 [ 259 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:57545 | ||
| 157 | 2024.12.13 22:29:48.303687 [ 260 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:53809 | ||
| 158 | 2024.12.13 22:29:48.303817 [ 261 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:63702 | ||
| 159 | 2024.12.13 22:29:48.303953 [ 259 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 160 | 2024.12.13 22:29:48.303986 [ 262 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:41769 | ||
| 161 | 2024.12.13 22:29:48.303964 [ 260 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 162 | 2024.12.13 22:29:48.304189 [ 263 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:39972 | ||
| 163 | 2024.12.13 22:29:48.304193 [ 259 ] {} <Debug> TCP-Session: 6145f2d9-0f3d-4b23-a905-53c6c63158df Authenticating user 'default' from [fd00:1122:3344:101::b]:57545 | ||
| 164 | 2024.12.13 22:29:48.304204 [ 261 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 165 | 2024.12.13 22:29:48.304342 [ 259 ] {} <Debug> TCP-Session: 6145f2d9-0f3d-4b23-a905-53c6c63158df Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 166 | 2024.12.13 22:29:48.304382 [ 262 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 167 | 2024.12.13 22:29:48.304558 [ 261 ] {} <Debug> TCP-Session: f4cb99b8-a063-4b7b-a895-817e766604c2 Authenticating user 'default' from [fd00:1122:3344:101::b]:63702 | ||
| 168 | 2024.12.13 22:29:48.304609 [ 262 ] {} <Debug> TCP-Session: 09020cc6-0b5d-4e47-9f8e-03d0814dc1e3 Authenticating user 'default' from [fd00:1122:3344:101::b]:41769 | ||
| 169 | 2024.12.13 22:29:48.304619 [ 264 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:39847 | ||
| 170 | 2024.12.13 22:29:48.304636 [ 260 ] {} <Debug> TCP-Session: 3d3c3270-4ff1-4923-a004-b64cc98c099e Authenticating user 'default' from [fd00:1122:3344:101::b]:53809 | ||
| 171 | 2024.12.13 22:29:48.304600 [ 259 ] {} <Debug> TCP-Session: 6145f2d9-0f3d-4b23-a905-53c6c63158df Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 172 | 2024.12.13 22:29:48.304696 [ 260 ] {} <Debug> TCP-Session: 3d3c3270-4ff1-4923-a004-b64cc98c099e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 173 | 2024.12.13 22:29:48.304682 [ 261 ] {} <Debug> TCP-Session: f4cb99b8-a063-4b7b-a895-817e766604c2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 174 | 2024.12.13 22:29:48.304589 [ 263 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 175 | 2024.12.13 22:29:48.304564 [ 265 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::b]:50753 | ||
| 176 | 2024.12.13 22:29:48.304841 [ 262 ] {} <Debug> TCP-Session: 09020cc6-0b5d-4e47-9f8e-03d0814dc1e3 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 177 | 2024.12.13 22:29:48.304874 [ 264 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 178 | 2024.12.13 22:29:48.305065 [ 263 ] {} <Debug> TCP-Session: 676528fe-b6fb-4e04-a87b-39eb37e393b5 Authenticating user 'default' from [fd00:1122:3344:101::b]:39972 | ||
| 179 | 2024.12.13 22:29:48.305083 [ 260 ] {} <Debug> TCP-Session: 3d3c3270-4ff1-4923-a004-b64cc98c099e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 180 | 2024.12.13 22:29:48.305138 [ 264 ] {} <Debug> TCP-Session: 28c996e6-2975-4baf-a088-162bca9ddec9 Authenticating user 'default' from [fd00:1122:3344:101::b]:39847 | ||
| 181 | 2024.12.13 22:29:48.305232 [ 263 ] {} <Debug> TCP-Session: 676528fe-b6fb-4e04-a87b-39eb37e393b5 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 182 | 2024.12.13 22:29:48.305205 [ 265 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 183 | 2024.12.13 22:29:48.305204 [ 261 ] {} <Debug> TCP-Session: f4cb99b8-a063-4b7b-a895-817e766604c2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 184 | 2024.12.13 22:29:48.305317 [ 263 ] {} <Debug> TCP-Session: 676528fe-b6fb-4e04-a87b-39eb37e393b5 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 185 | 2024.12.13 22:29:48.305332 [ 265 ] {} <Debug> TCP-Session: d4cc0424-c0fd-4dad-9e87-c24539544a1b Authenticating user 'default' from [fd00:1122:3344:101::b]:50753 | ||
| 186 | 2024.12.13 22:29:48.305302 [ 264 ] {} <Debug> TCP-Session: 28c996e6-2975-4baf-a088-162bca9ddec9 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 187 | 2024.12.13 22:29:48.304988 [ 262 ] {} <Debug> TCP-Session: 09020cc6-0b5d-4e47-9f8e-03d0814dc1e3 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 188 | 2024.12.13 22:29:48.305451 [ 265 ] {} <Debug> TCP-Session: d4cc0424-c0fd-4dad-9e87-c24539544a1b Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 189 | 2024.12.13 22:29:48.305504 [ 264 ] {} <Debug> TCP-Session: 28c996e6-2975-4baf-a088-162bca9ddec9 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 190 | 2024.12.13 22:29:48.305523 [ 265 ] {} <Debug> TCP-Session: d4cc0424-c0fd-4dad-9e87-c24539544a1b Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 191 | 2024.12.13 22:29:48.525163 [ 266 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:37732 | ||
| 192 | 2024.12.13 22:29:48.525347 [ 266 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 193 | 2024.12.13 22:29:48.525378 [ 266 ] {} <Debug> TCP-Session: 72184c0a-9afb-4286-a3d8-490afe931670 Authenticating user 'default' from [fd00:1122:3344:101::c]:37732 | ||
| 194 | 2024.12.13 22:29:48.525488 [ 266 ] {} <Debug> TCP-Session: 72184c0a-9afb-4286-a3d8-490afe931670 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 195 | 2024.12.13 22:29:48.525504 [ 266 ] {} <Debug> TCP-Session: 72184c0a-9afb-4286-a3d8-490afe931670 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 196 | 2024.12.13 22:29:48.525575 [ 266 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 197 | 2024.12.13 22:29:48.525691 [ 266 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 198 | 2024.12.13 22:29:48.525715 [ 266 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 199 | 2024.12.13 22:29:48.526926 [ 267 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:49921 | ||
| 200 | 2024.12.13 22:29:48.527018 [ 268 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:38417 | ||
| 201 | 2024.12.13 22:29:48.527136 [ 267 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 202 | 2024.12.13 22:29:48.527146 [ 269 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:42963 | ||
| 203 | 2024.12.13 22:29:48.527208 [ 270 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:37418 | ||
| 204 | 2024.12.13 22:29:48.527439 [ 267 ] {} <Debug> TCP-Session: 323437a0-9865-4e1f-8683-46be8a67bf7e Authenticating user 'default' from [fd00:1122:3344:101::c]:49921 | ||
| 205 | 2024.12.13 22:29:48.527442 [ 271 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:50885 | ||
| 206 | 2024.12.13 22:29:48.527518 [ 268 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 207 | 2024.12.13 22:29:48.527592 [ 272 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:35789 | ||
| 208 | 2024.12.13 22:29:48.527598 [ 269 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 209 | 2024.12.13 22:29:48.527692 [ 270 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 210 | 2024.12.13 22:29:48.527851 [ 273 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::c]:37962 | ||
| 211 | 2024.12.13 22:29:48.527840 [ 268 ] {} <Debug> TCP-Session: d0874744-d59a-4bfc-ac4d-2abcacc3d807 Authenticating user 'default' from [fd00:1122:3344:101::c]:38417 | ||
| 212 | 2024.12.13 22:29:48.527878 [ 269 ] {} <Debug> TCP-Session: c5ca3213-491e-4487-a37a-a9d9571484c0 Authenticating user 'default' from [fd00:1122:3344:101::c]:42963 | ||
| 213 | 2024.12.13 22:29:48.527931 [ 271 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 214 | 2024.12.13 22:29:48.527871 [ 270 ] {} <Debug> TCP-Session: da475368-f048-434c-81a5-912900e7d9a4 Authenticating user 'default' from [fd00:1122:3344:101::c]:37418 | ||
| 215 | 2024.12.13 22:29:48.528085 [ 270 ] {} <Debug> TCP-Session: da475368-f048-434c-81a5-912900e7d9a4 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 216 | 2024.12.13 22:29:48.528090 [ 273 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 217 | 2024.12.13 22:29:48.528086 [ 267 ] {} <Debug> TCP-Session: 323437a0-9865-4e1f-8683-46be8a67bf7e Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 218 | 2024.12.13 22:29:48.528223 [ 269 ] {} <Debug> TCP-Session: c5ca3213-491e-4487-a37a-a9d9571484c0 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 219 | 2024.12.13 22:29:48.528287 [ 270 ] {} <Debug> TCP-Session: da475368-f048-434c-81a5-912900e7d9a4 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 220 | 2024.12.13 22:29:48.528291 [ 272 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 221 | 2024.12.13 22:29:48.528248 [ 268 ] {} <Debug> TCP-Session: d0874744-d59a-4bfc-ac4d-2abcacc3d807 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 222 | 2024.12.13 22:29:48.528359 [ 271 ] {} <Debug> TCP-Session: 683bd010-c7cc-4522-8c37-9048bb000198 Authenticating user 'default' from [fd00:1122:3344:101::c]:50885 | ||
| 223 | 2024.12.13 22:29:48.528373 [ 267 ] {} <Debug> TCP-Session: 323437a0-9865-4e1f-8683-46be8a67bf7e Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 224 | 2024.12.13 22:29:48.528375 [ 273 ] {} <Debug> TCP-Session: 0f10cfc8-4ee8-4c66-b51e-cda73f954d37 Authenticating user 'default' from [fd00:1122:3344:101::c]:37962 | ||
| 225 | 2024.12.13 22:29:48.528429 [ 268 ] {} <Debug> TCP-Session: d0874744-d59a-4bfc-ac4d-2abcacc3d807 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 226 | 2024.12.13 22:29:48.528437 [ 271 ] {} <Debug> TCP-Session: 683bd010-c7cc-4522-8c37-9048bb000198 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 227 | 2024.12.13 22:29:48.528412 [ 269 ] {} <Debug> TCP-Session: c5ca3213-491e-4487-a37a-a9d9571484c0 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 228 | 2024.12.13 22:29:48.528505 [ 273 ] {} <Debug> TCP-Session: 0f10cfc8-4ee8-4c66-b51e-cda73f954d37 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 229 | 2024.12.13 22:29:48.528473 [ 272 ] {} <Debug> TCP-Session: 364ef5f6-f623-4140-bb8b-de4eb2841347 Authenticating user 'default' from [fd00:1122:3344:101::c]:35789 | ||
| 230 | 2024.12.13 22:29:48.528736 [ 273 ] {} <Debug> TCP-Session: 0f10cfc8-4ee8-4c66-b51e-cda73f954d37 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 231 | 2024.12.13 22:29:48.528760 [ 272 ] {} <Debug> TCP-Session: 364ef5f6-f623-4140-bb8b-de4eb2841347 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 232 | 2024.12.13 22:29:48.528785 [ 271 ] {} <Debug> TCP-Session: 683bd010-c7cc-4522-8c37-9048bb000198 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 233 | 2024.12.13 22:29:48.528921 [ 272 ] {} <Debug> TCP-Session: 364ef5f6-f623-4140-bb8b-de4eb2841347 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 234 | 2024.12.13 22:29:48.950853 [ 274 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:64221 | ||
| 235 | 2024.12.13 22:29:48.951061 [ 274 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 236 | 2024.12.13 22:29:48.951112 [ 274 ] {} <Debug> TCP-Session: a0c34a85-4fd9-4a84-84b6-f217fcf358d2 Authenticating user 'default' from [fd00:1122:3344:101::e]:64221 | ||
| 237 | 2024.12.13 22:29:48.951194 [ 274 ] {} <Debug> TCP-Session: a0c34a85-4fd9-4a84-84b6-f217fcf358d2 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 238 | 2024.12.13 22:29:48.951259 [ 274 ] {} <Debug> TCP-Session: a0c34a85-4fd9-4a84-84b6-f217fcf358d2 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 239 | 2024.12.13 22:29:48.951333 [ 274 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 240 | 2024.12.13 22:29:48.951360 [ 274 ] {} <Trace> ContextAccess (default): List of all grants: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 241 | 2024.12.13 22:29:48.951460 [ 274 ] {} <Trace> ContextAccess (default): List of all grants including implicit: GRANT SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, SYSTEM, dictGet, displaySecretsInShowAndSelect, INTROSPECTION, SOURCES, CLUSTER ON *.* WITH GRANT OPTION | ||
| 242 | 2024.12.13 22:29:48.952527 [ 275 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:57730 | ||
| 243 | 2024.12.13 22:29:48.952761 [ 277 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:36549 | ||
| 244 | 2024.12.13 22:29:48.952765 [ 275 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 245 | 2024.12.13 22:29:48.952764 [ 276 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:37587 | ||
| 246 | 2024.12.13 22:29:48.953006 [ 278 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:59730 | ||
| 247 | 2024.12.13 22:29:48.953033 [ 277 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 248 | 2024.12.13 22:29:48.953106 [ 279 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:50770 | ||
| 249 | 2024.12.13 22:29:48.953141 [ 277 ] {} <Debug> TCP-Session: 89c6bd3c-9bc4-4275-b2ee-55fba2a93d3f Authenticating user 'default' from [fd00:1122:3344:101::e]:36549 | ||
| 250 | 2024.12.13 22:29:48.953111 [ 275 ] {} <Debug> TCP-Session: b16a6a22-24c5-49ed-b605-fbc7541f4f10 Authenticating user 'default' from [fd00:1122:3344:101::e]:57730 | ||
| 251 | 2024.12.13 22:29:48.953355 [ 280 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:49327 | ||
| 252 | 2024.12.13 22:29:48.953519 [ 275 ] {} <Debug> TCP-Session: b16a6a22-24c5-49ed-b605-fbc7541f4f10 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 253 | 2024.12.13 22:29:48.953533 [ 278 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 254 | 2024.12.13 22:29:48.953641 [ 281 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::e]:36977 | ||
| 255 | 2024.12.13 22:29:48.953688 [ 277 ] {} <Debug> TCP-Session: 89c6bd3c-9bc4-4275-b2ee-55fba2a93d3f Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 256 | 2024.12.13 22:29:48.953519 [ 276 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 257 | 2024.12.13 22:29:48.953737 [ 275 ] {} <Debug> TCP-Session: b16a6a22-24c5-49ed-b605-fbc7541f4f10 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 258 | 2024.12.13 22:29:48.953728 [ 279 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 259 | 2024.12.13 22:29:48.953761 [ 278 ] {} <Debug> TCP-Session: 25d5ad4a-28b5-472e-8c98-d75c169a01d7 Authenticating user 'default' from [fd00:1122:3344:101::e]:59730 | ||
| 260 | 2024.12.13 22:29:48.954016 [ 279 ] {} <Debug> TCP-Session: 72783080-ee9e-437f-804d-d9a03a5c81af Authenticating user 'default' from [fd00:1122:3344:101::e]:50770 | ||
| 261 | 2024.12.13 22:29:48.954034 [ 277 ] {} <Debug> TCP-Session: 89c6bd3c-9bc4-4275-b2ee-55fba2a93d3f Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 262 | 2024.12.13 22:29:48.954222 [ 281 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 263 | 2024.12.13 22:29:48.954206 [ 276 ] {} <Debug> TCP-Session: f719b4ca-1dad-400f-b80e-6e8e3742b891 Authenticating user 'default' from [fd00:1122:3344:101::e]:37587 | ||
| 264 | 2024.12.13 22:29:48.954233 [ 279 ] {} <Debug> TCP-Session: 72783080-ee9e-437f-804d-d9a03a5c81af Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 265 | 2024.12.13 22:29:48.954042 [ 280 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 266 | 2024.12.13 22:29:48.954392 [ 281 ] {} <Debug> TCP-Session: 23016934-44d2-43e9-9612-2c3ca82b7fb7 Authenticating user 'default' from [fd00:1122:3344:101::e]:36977 | ||
| 267 | 2024.12.13 22:29:48.954425 [ 279 ] {} <Debug> TCP-Session: 72783080-ee9e-437f-804d-d9a03a5c81af Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 268 | 2024.12.13 22:29:48.954444 [ 278 ] {} <Debug> TCP-Session: 25d5ad4a-28b5-472e-8c98-d75c169a01d7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 269 | 2024.12.13 22:29:48.954508 [ 281 ] {} <Debug> TCP-Session: 23016934-44d2-43e9-9612-2c3ca82b7fb7 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 270 | 2024.12.13 22:29:48.954461 [ 276 ] {} <Debug> TCP-Session: f719b4ca-1dad-400f-b80e-6e8e3742b891 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 271 | 2024.12.13 22:29:48.954492 [ 280 ] {} <Debug> TCP-Session: ee502059-b15f-4a1b-85da-de3079345e18 Authenticating user 'default' from [fd00:1122:3344:101::e]:49327 | ||
| 272 | 2024.12.13 22:29:48.954584 [ 281 ] {} <Debug> TCP-Session: 23016934-44d2-43e9-9612-2c3ca82b7fb7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 273 | 2024.12.13 22:29:48.954571 [ 276 ] {} <Debug> TCP-Session: f719b4ca-1dad-400f-b80e-6e8e3742b891 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 274 | 2024.12.13 22:29:48.954563 [ 278 ] {} <Debug> TCP-Session: 25d5ad4a-28b5-472e-8c98-d75c169a01d7 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 275 | 2024.12.13 22:29:48.954645 [ 280 ] {} <Debug> TCP-Session: ee502059-b15f-4a1b-85da-de3079345e18 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 276 | 2024.12.13 22:29:48.954801 [ 280 ] {} <Debug> TCP-Session: ee502059-b15f-4a1b-85da-de3079345e18 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 277 | 2024.12.13 22:29:49.001154 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 117.32 MiB, peak 117.32 MiB, free memory in arenas 0.00 B, will set to 120.95 MiB (RSS), difference: 3.63 MiB | ||
| 278 | 2024.12.13 22:29:52.570104 [ 282 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:47756 | ||
| 279 | 2024.12.13 22:29:52.571974 [ 282 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 280 | 2024.12.13 22:29:52.572034 [ 282 ] {} <Debug> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Authenticating user 'default' from [fd00:1122:3344:101::d]:47756 | ||
| 281 | 2024.12.13 22:29:52.572086 [ 282 ] {} <Debug> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 282 | 2024.12.13 22:29:52.572107 [ 282 ] {} <Debug> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 283 | 2024.12.13 22:29:52.572205 [ 282 ] {} <Trace> ContextAccess (default): Settings: readonly = 0, allow_ddl = true, allow_introspection_functions = false | ||
| 284 | 2024.12.13 22:29:52.572254 [ 282 ] {} <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 | ||
| 285 | 2024.12.13 22:29:52.572278 [ 282 ] {} <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 | ||
| 286 | 2024.12.13 22:29:52.576705 [ 283 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:53900 | ||
| 287 | 2024.12.13 22:29:52.576924 [ 283 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 288 | 2024.12.13 22:29:52.576927 [ 284 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:60812 | ||
| 289 | 2024.12.13 22:29:52.576984 [ 286 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:56808 | ||
| 290 | 2024.12.13 22:29:52.577006 [ 283 ] {} <Debug> TCP-Session: f31535c1-af2b-4aa0-934f-ad7f234b4ade Authenticating user 'default' from [fd00:1122:3344:101::d]:53900 | ||
| 291 | 2024.12.13 22:29:52.576925 [ 285 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:50696 | ||
| 292 | 2024.12.13 22:29:52.577285 [ 283 ] {} <Debug> TCP-Session: f31535c1-af2b-4aa0-934f-ad7f234b4ade Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 293 | 2024.12.13 22:29:52.577332 [ 287 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:63516 | ||
| 294 | 2024.12.13 22:29:52.577359 [ 284 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 295 | 2024.12.13 22:29:52.577368 [ 288 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:52999 | ||
| 296 | 2024.12.13 22:29:52.577403 [ 283 ] {} <Debug> TCP-Session: f31535c1-af2b-4aa0-934f-ad7f234b4ade Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 297 | 2024.12.13 22:29:52.577453 [ 289 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:42897 | ||
| 298 | 2024.12.13 22:29:52.577840 [ 284 ] {} <Debug> TCP-Session: 04b68e98-2feb-483d-b414-28b5b2b4f476 Authenticating user 'default' from [fd00:1122:3344:101::d]:60812 | ||
| 299 | 2024.12.13 22:29:52.578101 [ 284 ] {} <Debug> TCP-Session: 04b68e98-2feb-483d-b414-28b5b2b4f476 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 300 | 2024.12.13 22:29:52.578117 [ 284 ] {} <Debug> TCP-Session: 04b68e98-2feb-483d-b414-28b5b2b4f476 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 301 | 2024.12.13 22:29:52.578647 [ 286 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 302 | 2024.12.13 22:29:52.578676 [ 288 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 303 | 2024.12.13 22:29:52.578733 [ 289 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 304 | 2024.12.13 22:29:52.578735 [ 286 ] {} <Debug> TCP-Session: acf85139-f8dd-410d-a1e8-6ca19bb5cac1 Authenticating user 'default' from [fd00:1122:3344:101::d]:56808 | ||
| 305 | 2024.12.13 22:29:52.578763 [ 287 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 306 | 2024.12.13 22:29:52.578815 [ 286 ] {} <Debug> TCP-Session: acf85139-f8dd-410d-a1e8-6ca19bb5cac1 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 307 | 2024.12.13 22:29:52.578803 [ 289 ] {} <Debug> TCP-Session: cb9b6784-36b6-4956-a89a-c8dbca11c7bc Authenticating user 'default' from [fd00:1122:3344:101::d]:42897 | ||
| 308 | 2024.12.13 22:29:52.578784 [ 285 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 309 | 2024.12.13 22:29:52.578895 [ 287 ] {} <Debug> TCP-Session: a31f9f26-d6b6-4cc3-a625-908c7663b9fa Authenticating user 'default' from [fd00:1122:3344:101::d]:63516 | ||
| 310 | 2024.12.13 22:29:52.578932 [ 289 ] {} <Debug> TCP-Session: cb9b6784-36b6-4956-a89a-c8dbca11c7bc Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 311 | 2024.12.13 22:29:52.578948 [ 290 ] {} <Trace> TCPHandlerFactory: TCP Request. Address: [fd00:1122:3344:101::d]:51884 | ||
| 312 | 2024.12.13 22:29:52.578883 [ 286 ] {} <Debug> TCP-Session: acf85139-f8dd-410d-a1e8-6ca19bb5cac1 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 313 | 2024.12.13 22:29:52.579031 [ 287 ] {} <Debug> TCP-Session: a31f9f26-d6b6-4cc3-a625-908c7663b9fa Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 314 | 2024.12.13 22:29:52.579009 [ 285 ] {} <Debug> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Authenticating user 'default' from [fd00:1122:3344:101::d]:50696 | ||
| 315 | 2024.12.13 22:29:52.579047 [ 289 ] {} <Debug> TCP-Session: cb9b6784-36b6-4956-a89a-c8dbca11c7bc Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 316 | 2024.12.13 22:29:52.578763 [ 288 ] {} <Debug> TCP-Session: d50c1f6f-7c92-48ae-9cc7-d91e9e11caec Authenticating user 'default' from [fd00:1122:3344:101::d]:52999 | ||
| 317 | 2024.12.13 22:29:52.579145 [ 287 ] {} <Debug> TCP-Session: a31f9f26-d6b6-4cc3-a625-908c7663b9fa Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 318 | 2024.12.13 22:29:52.579434 [ 285 ] {} <Debug> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 319 | 2024.12.13 22:29:52.579486 [ 290 ] {} <Debug> TCPHandler: Connected oximeter version 23.8.0, revision: 54465, database: default, user: default. | ||
| 320 | 2024.12.13 22:29:52.579489 [ 288 ] {} <Debug> TCP-Session: d50c1f6f-7c92-48ae-9cc7-d91e9e11caec Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 321 | 2024.12.13 22:29:52.579545 [ 285 ] {} <Debug> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 322 | 2024.12.13 22:29:52.579557 [ 290 ] {} <Debug> TCP-Session: 651aa18e-df40-43ce-ac2f-c2ab20212dab Authenticating user 'default' from [fd00:1122:3344:101::d]:51884 | ||
| 323 | 2024.12.13 22:29:52.579567 [ 288 ] {} <Debug> TCP-Session: d50c1f6f-7c92-48ae-9cc7-d91e9e11caec Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 324 | 2024.12.13 22:29:52.579635 [ 290 ] {} <Debug> TCP-Session: 651aa18e-df40-43ce-ac2f-c2ab20212dab Authenticated with global context as user 94309d50-4f52-5250-31bd-74fecac179db | ||
| 325 | 2024.12.13 22:29:52.579684 [ 290 ] {} <Debug> TCP-Session: 651aa18e-df40-43ce-ac2f-c2ab20212dab Creating session context with user_id: 94309d50-4f52-5250-31bd-74fecac179db | ||
| 326 | 2024.12.13 22:29:52.585321 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 327 | 2024.12.13 22:29:52.588589 [ 282 ] {b4048325-bdb3-4d23-b056-6bd787198507} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 328 | 2024.12.13 22:29:52.646359 [ 282 ] {b4048325-bdb3-4d23-b056-6bd787198507} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:47756) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 329 | |||
| 330 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 331 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 332 | 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 | ||
| 333 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 334 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 335 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 336 | 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 | ||
| 337 | 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 | ||
| 338 | 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 | ||
| 339 | 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 | ||
| 340 | 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 | ||
| 341 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 342 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 343 | 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 | ||
| 344 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 345 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 346 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 347 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 348 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 349 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 350 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 351 | |||
| 352 | 2024.12.13 22:29:52.647729 [ 282 ] {b4048325-bdb3-4d23-b056-6bd787198507} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 353 | |||
| 354 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 355 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 356 | 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 | ||
| 357 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 358 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 359 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 360 | 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 | ||
| 361 | 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 | ||
| 362 | 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 | ||
| 363 | 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 | ||
| 364 | 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 | ||
| 365 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 366 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 367 | 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 | ||
| 368 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 369 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 370 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 371 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 372 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 373 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 374 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 375 | |||
| 376 | 2024.12.13 22:29:52.647863 [ 282 ] {b4048325-bdb3-4d23-b056-6bd787198507} <Debug> TCPHandler: Processed in 0.064082336 sec. | ||
| 377 | 2024.12.13 22:29:52.648239 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 378 | 2024.12.13 22:29:52.648418 [ 285 ] {4b25f1c3-2f8d-44d5-87e8-464a5947e853} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) SELECT MAX(value) AS max_version FROM oximeter.version; (stage: Complete) | ||
| 379 | 2024.12.13 22:29:52.648730 [ 285 ] {4b25f1c3-2f8d-44d5-87e8-464a5947e853} <Error> executeQuery: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE) (version 23.8.7.1) (from [fd00:1122:3344:101::d]:50696) (in query: SELECT MAX(value) AS max_version FROM oximeter.version;), Stack trace (when copying this message, always include the lines below): | ||
| 380 | |||
| 381 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 382 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 383 | 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 | ||
| 384 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 385 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 386 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 387 | 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 | ||
| 388 | 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 | ||
| 389 | 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 | ||
| 390 | 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 | ||
| 391 | 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 | ||
| 392 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 393 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 394 | 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 | ||
| 395 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 396 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 397 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 398 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 399 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 400 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 401 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 402 | |||
| 403 | 2024.12.13 22:29:52.648877 [ 285 ] {4b25f1c3-2f8d-44d5-87e8-464a5947e853} <Error> TCPHandler: Code: 81. DB::Exception: Database oximeter does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below): | ||
| 404 | |||
| 405 | 0. StackTrace::tryCapture() @ 0x0000000010014f57 in /opt/oxide/clickhouse/clickhouse | ||
| 406 | 1. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000ffe797f in /opt/oxide/clickhouse/clickhouse | ||
| 407 | 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 | ||
| 408 | 3. DB::DatabaseCatalog::getDatabase(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) const @ 0x0000000014ed7a51 in /opt/oxide/clickhouse/clickhouse | ||
| 409 | 4. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x0000000014e8de3d in /opt/oxide/clickhouse/clickhouse | ||
| 410 | 5. DB::JoinedTables::getLeftTableStorage() @ 0x0000000015016a4b in /opt/oxide/clickhouse/clickhouse | ||
| 411 | 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 | ||
| 412 | 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 | ||
| 413 | 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 | ||
| 414 | 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 | ||
| 415 | 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 | ||
| 416 | 11. DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000014f67295 in /opt/oxide/clickhouse/clickhouse | ||
| 417 | 12. DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000015189bd6 in /opt/oxide/clickhouse/clickhouse | ||
| 418 | 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 | ||
| 419 | 14. DB::TCPHandler::runImpl() @ 0x0000000015b2646a in /opt/oxide/clickhouse/clickhouse | ||
| 420 | 15. DB::TCPHandler::run() @ 0x0000000015b3661c in /opt/oxide/clickhouse/clickhouse | ||
| 421 | 16. Poco::Net::TCPServerConnection::start() @ 0x000000001954534c in /opt/oxide/clickhouse/clickhouse | ||
| 422 | 17. Poco::Net::TCPServerDispatcher::run() @ 0x0000000019545821 in /opt/oxide/clickhouse/clickhouse | ||
| 423 | 18. Poco::PooledThread::run() @ 0x00000000195aa732 in /opt/oxide/clickhouse/clickhouse | ||
| 424 | 19. Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000195a81e5 in /opt/oxide/clickhouse/clickhouse | ||
| 425 | 20. _thrp_setup @ 0x0000000000116ef7 in /system/lib/amd64/libc.so.1 | ||
| 426 | |||
| 427 | 2024.12.13 22:29:52.648984 [ 285 ] {4b25f1c3-2f8d-44d5-87e8-464a5947e853} <Debug> TCPHandler: Processed in 0.000893045 sec. | ||
| 428 | 2024.12.13 22:29:52.650397 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 429 | 2024.12.13 22:29:52.651729 [ 282 ] {6c2c6ddb-a49e-4533-8b4b-ea4a390dcf14} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) DROP DATABASE IF EXISTS oximeter (stage: Complete) | ||
| 430 | 2024.12.13 22:29:52.652424 [ 282 ] {6c2c6ddb-a49e-4533-8b4b-ea4a390dcf14} <Debug> TCPHandler: Processed in 0.00213973 sec. | ||
| 431 | 2024.12.13 22:29:52.652608 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 432 | 2024.12.13 22:29:52.652724 [ 285 ] {de4f15f2-ee8a-4a7c-9344-e6168ac9843a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE DATABASE IF NOT EXISTS oximeter (stage: Complete) | ||
| 433 | 2024.12.13 22:29:52.652832 [ 285 ] {de4f15f2-ee8a-4a7c-9344-e6168ac9843a} <Trace> ContextAccess (default): Access granted: CREATE DATABASE ON oximeter.* | ||
| 434 | 2024.12.13 22:29:52.655076 [ 285 ] {de4f15f2-ee8a-4a7c-9344-e6168ac9843a} <Information> DatabaseAtomic (oximeter): Metadata processed, database oximeter has 0 tables and 0 dictionaries in total. | ||
| 435 | 2024.12.13 22:29:52.655118 [ 285 ] {de4f15f2-ee8a-4a7c-9344-e6168ac9843a} <Information> TablesLoader: Parsed metadata of 0 tables in 1 databases in 7.9672e-05 sec | ||
| 436 | 2024.12.13 22:29:52.655134 [ 285 ] {de4f15f2-ee8a-4a7c-9344-e6168ac9843a} <Trace> ReferentialDeps: No tables | ||
| 437 | 2024.12.13 22:29:52.655146 [ 285 ] {de4f15f2-ee8a-4a7c-9344-e6168ac9843a} <Trace> LoadingDeps: No tables | ||
| 438 | 2024.12.13 22:29:52.655170 [ 285 ] {de4f15f2-ee8a-4a7c-9344-e6168ac9843a} <Information> DatabaseAtomic (oximeter): Starting up tables. | ||
| 439 | 2024.12.13 22:29:52.655233 [ 285 ] {de4f15f2-ee8a-4a7c-9344-e6168ac9843a} <Debug> TCPHandler: Processed in 0.002677515 sec. | ||
| 440 | 2024.12.13 22:29:52.655433 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 441 | 2024.12.13 22:29:52.655605 [ 282 ] {e1a8c17c-e5d6-4b43-bdc4-4a16407e1882} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) /* The version table contains metadata about the `oximeter` database */ | ||
| 442 | CREATE TABLE IF NOT EXISTS oximeter.version ( value UInt64, timestamp DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (value, timestamp) (stage: Complete) | ||
| 443 | 2024.12.13 22:29:52.655672 [ 282 ] {e1a8c17c-e5d6-4b43-bdc4-4a16407e1882} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.version | ||
| 444 | 2024.12.13 22:29:52.662772 [ 282 ] {e1a8c17c-e5d6-4b43-bdc4-4a16407e1882} <Trace> StoragePolicy (default): Storage policy default created, total volumes 1 | ||
| 445 | 2024.12.13 22:29:52.664079 [ 282 ] {e1a8c17c-e5d6-4b43-bdc4-4a16407e1882} <Debug> oximeter.version (bacb2f14-56fe-4ed8-af06-495448e7b2d7): Loading data parts | ||
| 446 | 2024.12.13 22:29:52.664610 [ 282 ] {e1a8c17c-e5d6-4b43-bdc4-4a16407e1882} <Debug> oximeter.version (bacb2f14-56fe-4ed8-af06-495448e7b2d7): There are no data parts | ||
| 447 | 2024.12.13 22:29:52.667141 [ 282 ] {e1a8c17c-e5d6-4b43-bdc4-4a16407e1882} <Debug> TCPHandler: Processed in 0.01176853 sec. | ||
| 448 | 2024.12.13 22:29:52.667353 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 449 | 2024.12.13 22:29:52.667577 [ 285 ] {61643ad3-072f-4e74-9069-a21eda44915b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) /* The measurement tables contain all individual samples from each timeseries. | ||
| 450 | * | ||
| 451 | * Each table stores a single datum type, and otherwise contains nearly the same | ||
| 452 | * structure. The primary sorting key is on the timeseries name, key, and then | ||
| 453 | * timestamp, so that all timeseries from the same schema are grouped, followed | ||
| 454 | * by all samples from the same timeseries. | ||
| 455 | * | ||
| 456 | * This reflects that one usually looks up the _key_ in one or more field table, | ||
| 457 | * and then uses that to index quickly into the measurements tables. | ||
| 458 | */ | ||
| 459 | CREATE TABLE IF NOT EXISTS oximeter.measurements_bool ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Bool) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 460 | 2024.12.13 22:29:52.667655 [ 285 ] {61643ad3-072f-4e74-9069-a21eda44915b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bool | ||
| 461 | 2024.12.13 22:29:52.675993 [ 285 ] {61643ad3-072f-4e74-9069-a21eda44915b} <Debug> oximeter.measurements_bool (596cb973-1ac6-49c8-a0de-8ca2e2709ef6): Loading data parts | ||
| 462 | 2024.12.13 22:29:52.676255 [ 285 ] {61643ad3-072f-4e74-9069-a21eda44915b} <Debug> oximeter.measurements_bool (596cb973-1ac6-49c8-a0de-8ca2e2709ef6): There are no data parts | ||
| 463 | 2024.12.13 22:29:52.678684 [ 285 ] {61643ad3-072f-4e74-9069-a21eda44915b} <Debug> TCPHandler: Processed in 0.011387999 sec. | ||
| 464 | 2024.12.13 22:29:52.678909 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 465 | 2024.12.13 22:29:52.679125 [ 282 ] {d5883314-f861-4ea0-8bbd-066b2ec8be2f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_i8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 466 | 2024.12.13 22:29:52.679194 [ 282 ] {d5883314-f861-4ea0-8bbd-066b2ec8be2f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i8 | ||
| 467 | 2024.12.13 22:29:52.682604 [ 282 ] {d5883314-f861-4ea0-8bbd-066b2ec8be2f} <Debug> oximeter.measurements_i8 (5fd37a6e-3434-489f-b02f-a9c6d6865d5d): Loading data parts | ||
| 468 | 2024.12.13 22:29:52.682913 [ 282 ] {d5883314-f861-4ea0-8bbd-066b2ec8be2f} <Debug> oximeter.measurements_i8 (5fd37a6e-3434-489f-b02f-a9c6d6865d5d): There are no data parts | ||
| 469 | 2024.12.13 22:29:52.684829 [ 282 ] {d5883314-f861-4ea0-8bbd-066b2ec8be2f} <Debug> TCPHandler: Processed in 0.005987008 sec. | ||
| 470 | 2024.12.13 22:29:52.685027 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 471 | 2024.12.13 22:29:52.685247 [ 285 ] {9e7ef74c-fb90-4d56-8897-97827e76017e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_u8 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 472 | 2024.12.13 22:29:52.685306 [ 285 ] {9e7ef74c-fb90-4d56-8897-97827e76017e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u8 | ||
| 473 | 2024.12.13 22:29:52.688277 [ 285 ] {9e7ef74c-fb90-4d56-8897-97827e76017e} <Debug> oximeter.measurements_u8 (d8007815-32b5-45a4-9f68-00849981d967): Loading data parts | ||
| 474 | 2024.12.13 22:29:52.688466 [ 285 ] {9e7ef74c-fb90-4d56-8897-97827e76017e} <Debug> oximeter.measurements_u8 (d8007815-32b5-45a4-9f68-00849981d967): There are no data parts | ||
| 475 | 2024.12.13 22:29:52.691546 [ 285 ] {9e7ef74c-fb90-4d56-8897-97827e76017e} <Debug> TCPHandler: Processed in 0.006575885 sec. | ||
| 476 | 2024.12.13 22:29:52.691764 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 477 | 2024.12.13 22:29:52.691973 [ 282 ] {921303b0-c034-4f7f-8c03-f3a818dcc4b8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_i16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 478 | 2024.12.13 22:29:52.692043 [ 282 ] {921303b0-c034-4f7f-8c03-f3a818dcc4b8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i16 | ||
| 479 | 2024.12.13 22:29:52.694081 [ 282 ] {921303b0-c034-4f7f-8c03-f3a818dcc4b8} <Debug> oximeter.measurements_i16 (965f5c9e-844d-432d-96ba-142dababb18c): Loading data parts | ||
| 480 | 2024.12.13 22:29:52.694282 [ 282 ] {921303b0-c034-4f7f-8c03-f3a818dcc4b8} <Debug> oximeter.measurements_i16 (965f5c9e-844d-432d-96ba-142dababb18c): There are no data parts | ||
| 481 | 2024.12.13 22:29:52.695945 [ 282 ] {921303b0-c034-4f7f-8c03-f3a818dcc4b8} <Debug> TCPHandler: Processed in 0.004236239 sec. | ||
| 482 | 2024.12.13 22:29:52.696132 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 483 | 2024.12.13 22:29:52.696344 [ 285 ] {5ddad3b0-d924-47fe-8376-a87753108d46} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_u16 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt16) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 484 | 2024.12.13 22:29:52.696404 [ 285 ] {5ddad3b0-d924-47fe-8376-a87753108d46} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u16 | ||
| 485 | 2024.12.13 22:29:52.699202 [ 285 ] {5ddad3b0-d924-47fe-8376-a87753108d46} <Debug> oximeter.measurements_u16 (66ea9add-1874-4eb0-80fe-8a82c1c91f5a): Loading data parts | ||
| 486 | 2024.12.13 22:29:52.699383 [ 285 ] {5ddad3b0-d924-47fe-8376-a87753108d46} <Debug> oximeter.measurements_u16 (66ea9add-1874-4eb0-80fe-8a82c1c91f5a): There are no data parts | ||
| 487 | 2024.12.13 22:29:52.705643 [ 285 ] {5ddad3b0-d924-47fe-8376-a87753108d46} <Debug> TCPHandler: Processed in 0.009565368 sec. | ||
| 488 | 2024.12.13 22:29:52.705838 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 489 | 2024.12.13 22:29:52.706040 [ 282 ] {b45a0db4-4d58-47d1-ac34-6f4076386a0f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_i32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 490 | 2024.12.13 22:29:52.706105 [ 282 ] {b45a0db4-4d58-47d1-ac34-6f4076386a0f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i32 | ||
| 491 | 2024.12.13 22:29:52.709697 [ 282 ] {b45a0db4-4d58-47d1-ac34-6f4076386a0f} <Debug> oximeter.measurements_i32 (abc62925-f915-4fb8-bf49-75d8037961c6): Loading data parts | ||
| 492 | 2024.12.13 22:29:52.709893 [ 282 ] {b45a0db4-4d58-47d1-ac34-6f4076386a0f} <Debug> oximeter.measurements_i32 (abc62925-f915-4fb8-bf49-75d8037961c6): There are no data parts | ||
| 493 | 2024.12.13 22:29:52.713449 [ 282 ] {b45a0db4-4d58-47d1-ac34-6f4076386a0f} <Debug> TCPHandler: Processed in 0.007667326 sec. | ||
| 494 | 2024.12.13 22:29:52.713641 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 495 | 2024.12.13 22:29:52.713855 [ 285 ] {702cf74d-f99e-42ff-90c1-b896e2cce44a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_u32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 496 | 2024.12.13 22:29:52.713918 [ 285 ] {702cf74d-f99e-42ff-90c1-b896e2cce44a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u32 | ||
| 497 | 2024.12.13 22:29:52.716946 [ 285 ] {702cf74d-f99e-42ff-90c1-b896e2cce44a} <Debug> oximeter.measurements_u32 (d731d660-4371-41f9-af4c-f672f73a2768): Loading data parts | ||
| 498 | 2024.12.13 22:29:52.717129 [ 285 ] {702cf74d-f99e-42ff-90c1-b896e2cce44a} <Debug> oximeter.measurements_u32 (d731d660-4371-41f9-af4c-f672f73a2768): There are no data parts | ||
| 499 | 2024.12.13 22:29:52.723093 [ 285 ] {702cf74d-f99e-42ff-90c1-b896e2cce44a} <Debug> TCPHandler: Processed in 0.009508937 sec. | ||
| 500 | 2024.12.13 22:29:52.723287 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 501 | 2024.12.13 22:29:52.723512 [ 282 ] {f57e99f4-9f11-4f5e-bbd0-957c68ce3cd5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_i64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 502 | 2024.12.13 22:29:52.723584 [ 282 ] {f57e99f4-9f11-4f5e-bbd0-957c68ce3cd5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_i64 | ||
| 503 | 2024.12.13 22:29:52.727070 [ 282 ] {f57e99f4-9f11-4f5e-bbd0-957c68ce3cd5} <Debug> oximeter.measurements_i64 (76cb6477-faa8-44a3-8ac2-854ada45bcbc): Loading data parts | ||
| 504 | 2024.12.13 22:29:52.727248 [ 282 ] {f57e99f4-9f11-4f5e-bbd0-957c68ce3cd5} <Debug> oximeter.measurements_i64 (76cb6477-faa8-44a3-8ac2-854ada45bcbc): There are no data parts | ||
| 505 | 2024.12.13 22:29:52.730654 [ 282 ] {f57e99f4-9f11-4f5e-bbd0-957c68ce3cd5} <Debug> TCPHandler: Processed in 0.007420838 sec. | ||
| 506 | 2024.12.13 22:29:52.730832 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 507 | 2024.12.13 22:29:52.731043 [ 285 ] {8c2db8d8-bcb3-4fd1-8986-b8d8ef96dacf} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_u64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 508 | 2024.12.13 22:29:52.731109 [ 285 ] {8c2db8d8-bcb3-4fd1-8986-b8d8ef96dacf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_u64 | ||
| 509 | 2024.12.13 22:29:52.734115 [ 285 ] {8c2db8d8-bcb3-4fd1-8986-b8d8ef96dacf} <Debug> oximeter.measurements_u64 (da799346-b8cd-4d6e-a289-36dcfcaff9a2): Loading data parts | ||
| 510 | 2024.12.13 22:29:52.734286 [ 285 ] {8c2db8d8-bcb3-4fd1-8986-b8d8ef96dacf} <Debug> oximeter.measurements_u64 (da799346-b8cd-4d6e-a289-36dcfcaff9a2): There are no data parts | ||
| 511 | 2024.12.13 22:29:52.738563 [ 285 ] {8c2db8d8-bcb3-4fd1-8986-b8d8ef96dacf} <Debug> TCPHandler: Processed in 0.007786788 sec. | ||
| 512 | 2024.12.13 22:29:52.738759 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 513 | 2024.12.13 22:29:52.738954 [ 282 ] {5576699d-a8d2-4f02-88fa-e595d3cd5537} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_f32 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 514 | 2024.12.13 22:29:52.739028 [ 282 ] {5576699d-a8d2-4f02-88fa-e595d3cd5537} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f32 | ||
| 515 | 2024.12.13 22:29:52.741345 [ 282 ] {5576699d-a8d2-4f02-88fa-e595d3cd5537} <Debug> oximeter.measurements_f32 (6a38c0e9-fb4b-4d6b-ade3-ce4c18e30ee3): Loading data parts | ||
| 516 | 2024.12.13 22:29:52.741537 [ 282 ] {5576699d-a8d2-4f02-88fa-e595d3cd5537} <Debug> oximeter.measurements_f32 (6a38c0e9-fb4b-4d6b-ade3-ce4c18e30ee3): There are no data parts | ||
| 517 | 2024.12.13 22:29:52.742762 [ 282 ] {5576699d-a8d2-4f02-88fa-e595d3cd5537} <Debug> TCPHandler: Processed in 0.004055264 sec. | ||
| 518 | 2024.12.13 22:29:52.742956 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 519 | 2024.12.13 22:29:52.743165 [ 285 ] {8387b498-781c-4380-97a3-739699ea9e1a} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_f64 ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 520 | 2024.12.13 22:29:52.743224 [ 285 ] {8387b498-781c-4380-97a3-739699ea9e1a} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_f64 | ||
| 521 | 2024.12.13 22:29:52.747685 [ 285 ] {8387b498-781c-4380-97a3-739699ea9e1a} <Debug> oximeter.measurements_f64 (649ff173-91ab-4855-8511-f9a8421968a9): Loading data parts | ||
| 522 | 2024.12.13 22:29:52.747860 [ 285 ] {8387b498-781c-4380-97a3-739699ea9e1a} <Debug> oximeter.measurements_f64 (649ff173-91ab-4855-8511-f9a8421968a9): There are no data parts | ||
| 523 | 2024.12.13 22:29:52.751909 [ 285 ] {8387b498-781c-4380-97a3-739699ea9e1a} <Debug> TCPHandler: Processed in 0.009007892 sec. | ||
| 524 | 2024.12.13 22:29:52.752105 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 525 | 2024.12.13 22:29:52.752302 [ 282 ] {c0925999-7e78-46d0-968a-5d4f15efb5d5} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_string ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), datum Nullable(String) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 526 | 2024.12.13 22:29:52.752368 [ 282 ] {c0925999-7e78-46d0-968a-5d4f15efb5d5} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_string | ||
| 527 | 2024.12.13 22:29:52.757498 [ 282 ] {c0925999-7e78-46d0-968a-5d4f15efb5d5} <Debug> oximeter.measurements_string (5d8ab893-ae5f-4c81-97bd-1916a4333140): Loading data parts | ||
| 528 | 2024.12.13 22:29:52.757690 [ 282 ] {c0925999-7e78-46d0-968a-5d4f15efb5d5} <Debug> oximeter.measurements_string (5d8ab893-ae5f-4c81-97bd-1916a4333140): There are no data parts | ||
| 529 | 2024.12.13 22:29:52.760802 [ 282 ] {c0925999-7e78-46d0-968a-5d4f15efb5d5} <Debug> TCPHandler: Processed in 0.008750995 sec. | ||
| 530 | 2024.12.13 22:29:52.760980 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 531 | 2024.12.13 22:29:52.761188 [ 285 ] {7facca96-26a4-4de3-9ed6-5b1b4699fda1} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_bytes ( timeseries_name String, timeseries_key UInt64, timestamp DateTime64(9, 'UTC'), /* | ||
| 532 | * NOTE: Right now we can't unambiguously record a nullable byte array. | ||
| 533 | * Arrays cannot be nested in `Nullable()` types, and encoding the array as | ||
| 534 | * a string isn't palatable for a few reasons. | ||
| 535 | * See: https://github.com/oxidecomputer/omicron/issues/4551 for more | ||
| 536 | * details. | ||
| 537 | */ | ||
| 538 | datum Array(UInt8) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 539 | 2024.12.13 22:29:52.761246 [ 285 ] {7facca96-26a4-4de3-9ed6-5b1b4699fda1} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_bytes | ||
| 540 | 2024.12.13 22:29:52.764726 [ 285 ] {7facca96-26a4-4de3-9ed6-5b1b4699fda1} <Debug> oximeter.measurements_bytes (60b91494-7942-44c0-8db4-1e5a556584f7): Loading data parts | ||
| 541 | 2024.12.13 22:29:52.764899 [ 285 ] {7facca96-26a4-4de3-9ed6-5b1b4699fda1} <Debug> oximeter.measurements_bytes (60b91494-7942-44c0-8db4-1e5a556584f7): There are no data parts | ||
| 542 | 2024.12.13 22:29:52.766440 [ 285 ] {7facca96-26a4-4de3-9ed6-5b1b4699fda1} <Debug> TCPHandler: Processed in 0.005514065 sec. | ||
| 543 | 2024.12.13 22:29:52.766624 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 544 | 2024.12.13 22:29:52.766839 [ 282 ] {cfe189b3-c6bf-479d-b56d-96b9d25d729b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativei64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Int64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 545 | 2024.12.13 22:29:52.766900 [ 282 ] {cfe189b3-c6bf-479d-b56d-96b9d25d729b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativei64 | ||
| 546 | 2024.12.13 22:29:52.770142 [ 282 ] {cfe189b3-c6bf-479d-b56d-96b9d25d729b} <Debug> oximeter.measurements_cumulativei64 (f304fb20-1d02-465d-a7c0-1412f884ea85): Loading data parts | ||
| 547 | 2024.12.13 22:29:52.770343 [ 282 ] {cfe189b3-c6bf-479d-b56d-96b9d25d729b} <Debug> oximeter.measurements_cumulativei64 (f304fb20-1d02-465d-a7c0-1412f884ea85): There are no data parts | ||
| 548 | 2024.12.13 22:29:52.774418 [ 282 ] {cfe189b3-c6bf-479d-b56d-96b9d25d729b} <Debug> TCPHandler: Processed in 0.00784514 sec. | ||
| 549 | 2024.12.13 22:29:52.774608 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 550 | 2024.12.13 22:29:52.774827 [ 285 ] {5e758a2a-0438-46ba-bdeb-83b60a5033fb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativeu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(UInt64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 551 | 2024.12.13 22:29:52.774882 [ 285 ] {5e758a2a-0438-46ba-bdeb-83b60a5033fb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativeu64 | ||
| 552 | 2024.12.13 22:29:52.776776 [ 285 ] {5e758a2a-0438-46ba-bdeb-83b60a5033fb} <Debug> oximeter.measurements_cumulativeu64 (9735b2bc-40ad-4e9b-b163-9d92f0a7ebf9): Loading data parts | ||
| 553 | 2024.12.13 22:29:52.777008 [ 285 ] {5e758a2a-0438-46ba-bdeb-83b60a5033fb} <Debug> oximeter.measurements_cumulativeu64 (9735b2bc-40ad-4e9b-b163-9d92f0a7ebf9): There are no data parts | ||
| 554 | 2024.12.13 22:29:52.780182 [ 285 ] {5e758a2a-0438-46ba-bdeb-83b60a5033fb} <Debug> TCPHandler: Processed in 0.005626788 sec. | ||
| 555 | 2024.12.13 22:29:52.780394 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 556 | 2024.12.13 22:29:52.780606 [ 282 ] {0f460a09-e9bc-4d23-a8d5-d7d30fe9c591} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float32) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 557 | 2024.12.13 22:29:52.780673 [ 282 ] {0f460a09-e9bc-4d23-a8d5-d7d30fe9c591} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef32 | ||
| 558 | 2024.12.13 22:29:52.784654 [ 282 ] {0f460a09-e9bc-4d23-a8d5-d7d30fe9c591} <Debug> oximeter.measurements_cumulativef32 (1b49d54d-dffa-4f1a-8086-75c4b6f4f82c): Loading data parts | ||
| 559 | 2024.12.13 22:29:52.784865 [ 282 ] {0f460a09-e9bc-4d23-a8d5-d7d30fe9c591} <Debug> oximeter.measurements_cumulativef32 (1b49d54d-dffa-4f1a-8086-75c4b6f4f82c): There are no data parts | ||
| 560 | 2024.12.13 22:29:52.787556 [ 282 ] {0f460a09-e9bc-4d23-a8d5-d7d30fe9c591} <Debug> TCPHandler: Processed in 0.007220603 sec. | ||
| 561 | 2024.12.13 22:29:52.787732 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 562 | 2024.12.13 22:29:52.787958 [ 285 ] {60fca9d9-7e9f-4c8a-a075-8d36d4cc230d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_cumulativef64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), datum Nullable(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 563 | 2024.12.13 22:29:52.788021 [ 285 ] {60fca9d9-7e9f-4c8a-a075-8d36d4cc230d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_cumulativef64 | ||
| 564 | 2024.12.13 22:29:52.789865 [ 285 ] {60fca9d9-7e9f-4c8a-a075-8d36d4cc230d} <Debug> oximeter.measurements_cumulativef64 (3d18754c-1504-4fba-9392-3d9bce4d5fbc): Loading data parts | ||
| 565 | 2024.12.13 22:29:52.790041 [ 285 ] {60fca9d9-7e9f-4c8a-a075-8d36d4cc230d} <Debug> oximeter.measurements_cumulativef64 (3d18754c-1504-4fba-9392-3d9bce4d5fbc): There are no data parts | ||
| 566 | 2024.12.13 22:29:52.792885 [ 285 ] {60fca9d9-7e9f-4c8a-a075-8d36d4cc230d} <Debug> TCPHandler: Processed in 0.005207106 sec. | ||
| 567 | 2024.12.13 22:29:52.793094 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 568 | 2024.12.13 22:29:52.793392 [ 282 ] {1c9129e2-e63b-4ecb-a288-57a4c0920f3e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), /* | ||
| 569 | * NOTE: Array types cannot be Nullable, see | ||
| 570 | * https://clickhouse.com/docs/en/sql-reference/data-types/nullable | ||
| 571 | * for more details. | ||
| 572 | * | ||
| 573 | * This means we need to use empty arrays to indicate a missing value. This | ||
| 574 | * is unfortunate, and at this point relies on the fact that an | ||
| 575 | * `oximeter::Histogram` cannot have zero bins. If that changes, we'll need | ||
| 576 | * to figure out another way to represent missing samples here. | ||
| 577 | */ | ||
| 578 | bins Array(Int8), counts Array(UInt64), min Int8, max Int8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 579 | 2024.12.13 22:29:52.793464 [ 282 ] {1c9129e2-e63b-4ecb-a288-57a4c0920f3e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami8 | ||
| 580 | 2024.12.13 22:29:52.797787 [ 282 ] {1c9129e2-e63b-4ecb-a288-57a4c0920f3e} <Debug> oximeter.measurements_histogrami8 (91c14dfb-362d-4033-8c8d-5e764977f15f): Loading data parts | ||
| 581 | 2024.12.13 22:29:52.797965 [ 282 ] {1c9129e2-e63b-4ecb-a288-57a4c0920f3e} <Debug> oximeter.measurements_histogrami8 (91c14dfb-362d-4033-8c8d-5e764977f15f): There are no data parts | ||
| 582 | 2024.12.13 22:29:52.799858 [ 282 ] {1c9129e2-e63b-4ecb-a288-57a4c0920f3e} <Debug> TCPHandler: Processed in 0.00681962 sec. | ||
| 583 | 2024.12.13 22:29:52.800038 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 584 | 2024.12.13 22:29:52.800366 [ 285 ] {574235cf-484b-494f-ba9c-67ec0223530d} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu8 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt8), counts Array(UInt64), min UInt8, max UInt8, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 585 | 2024.12.13 22:29:52.800441 [ 285 ] {574235cf-484b-494f-ba9c-67ec0223530d} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu8 | ||
| 586 | 2024.12.13 22:29:52.802768 [ 285 ] {574235cf-484b-494f-ba9c-67ec0223530d} <Debug> oximeter.measurements_histogramu8 (68e6962d-f02a-40dd-8daf-948af9f82bea): Loading data parts | ||
| 587 | 2024.12.13 22:29:52.802950 [ 285 ] {574235cf-484b-494f-ba9c-67ec0223530d} <Debug> oximeter.measurements_histogramu8 (68e6962d-f02a-40dd-8daf-948af9f82bea): There are no data parts | ||
| 588 | 2024.12.13 22:29:52.805374 [ 285 ] {574235cf-484b-494f-ba9c-67ec0223530d} <Debug> TCPHandler: Processed in 0.005391841 sec. | ||
| 589 | 2024.12.13 22:29:52.805576 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 590 | 2024.12.13 22:29:52.805849 [ 282 ] {898b0003-f749-405c-8d5b-0d1a75b22af4} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int16), counts Array(UInt64), min Int16, max Int16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 591 | 2024.12.13 22:29:52.805930 [ 282 ] {898b0003-f749-405c-8d5b-0d1a75b22af4} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami16 | ||
| 592 | 2024.12.13 22:29:52.808391 [ 282 ] {898b0003-f749-405c-8d5b-0d1a75b22af4} <Debug> oximeter.measurements_histogrami16 (1a053e37-9f99-4db6-a690-1eb19d113729): Loading data parts | ||
| 593 | 2024.12.13 22:29:52.808569 [ 282 ] {898b0003-f749-405c-8d5b-0d1a75b22af4} <Debug> oximeter.measurements_histogrami16 (1a053e37-9f99-4db6-a690-1eb19d113729): There are no data parts | ||
| 594 | 2024.12.13 22:29:52.809828 [ 282 ] {898b0003-f749-405c-8d5b-0d1a75b22af4} <Debug> TCPHandler: Processed in 0.004305141 sec. | ||
| 595 | 2024.12.13 22:29:52.810032 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 596 | 2024.12.13 22:29:52.810335 [ 285 ] {84cc61da-8907-4f45-b9b3-eccb4cdc9dcc} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu16 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt16), counts Array(UInt64), min UInt16, max UInt16, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 597 | 2024.12.13 22:29:52.810417 [ 285 ] {84cc61da-8907-4f45-b9b3-eccb4cdc9dcc} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu16 | ||
| 598 | 2024.12.13 22:29:52.813673 [ 285 ] {84cc61da-8907-4f45-b9b3-eccb4cdc9dcc} <Debug> oximeter.measurements_histogramu16 (1b9466fe-f42f-468e-87e5-bf9c67810061): Loading data parts | ||
| 599 | 2024.12.13 22:29:52.813853 [ 285 ] {84cc61da-8907-4f45-b9b3-eccb4cdc9dcc} <Debug> oximeter.measurements_histogramu16 (1b9466fe-f42f-468e-87e5-bf9c67810061): There are no data parts | ||
| 600 | 2024.12.13 22:29:52.815500 [ 285 ] {84cc61da-8907-4f45-b9b3-eccb4cdc9dcc} <Debug> TCPHandler: Processed in 0.005523055 sec. | ||
| 601 | 2024.12.13 22:29:52.815692 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 602 | 2024.12.13 22:29:52.815977 [ 282 ] {86a18d02-34a9-4ef4-8787-b18e2311d426} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int32), counts Array(UInt64), min Int32, max Int32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 603 | 2024.12.13 22:29:52.816067 [ 282 ] {86a18d02-34a9-4ef4-8787-b18e2311d426} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami32 | ||
| 604 | 2024.12.13 22:29:52.818298 [ 282 ] {86a18d02-34a9-4ef4-8787-b18e2311d426} <Debug> oximeter.measurements_histogrami32 (211be0ee-4903-4199-bb70-9b6ef9000695): Loading data parts | ||
| 605 | 2024.12.13 22:29:52.818505 [ 282 ] {86a18d02-34a9-4ef4-8787-b18e2311d426} <Debug> oximeter.measurements_histogrami32 (211be0ee-4903-4199-bb70-9b6ef9000695): There are no data parts | ||
| 606 | 2024.12.13 22:29:52.820335 [ 282 ] {86a18d02-34a9-4ef4-8787-b18e2311d426} <Debug> TCPHandler: Processed in 0.004695331 sec. | ||
| 607 | 2024.12.13 22:29:52.820519 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 608 | 2024.12.13 22:29:52.820823 [ 285 ] {0c47cb5e-7d63-4ec3-a90d-2ec7626b1974} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt32), counts Array(UInt64), min UInt32, max UInt32, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 609 | 2024.12.13 22:29:52.820900 [ 285 ] {0c47cb5e-7d63-4ec3-a90d-2ec7626b1974} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu32 | ||
| 610 | 2024.12.13 22:29:52.826352 [ 285 ] {0c47cb5e-7d63-4ec3-a90d-2ec7626b1974} <Debug> oximeter.measurements_histogramu32 (02e7ac8a-dd71-48e2-9d39-146d14878fad): Loading data parts | ||
| 611 | 2024.12.13 22:29:52.826529 [ 285 ] {0c47cb5e-7d63-4ec3-a90d-2ec7626b1974} <Debug> oximeter.measurements_histogramu32 (02e7ac8a-dd71-48e2-9d39-146d14878fad): There are no data parts | ||
| 612 | 2024.12.13 22:29:52.830744 [ 285 ] {0c47cb5e-7d63-4ec3-a90d-2ec7626b1974} <Debug> TCPHandler: Processed in 0.010278008 sec. | ||
| 613 | 2024.12.13 22:29:52.830947 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 614 | 2024.12.13 22:29:52.831218 [ 282 ] {3bf156cb-3b94-4d67-bde9-d63b088ce51b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogrami64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Int64), counts Array(UInt64), min Int64, max Int64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 615 | 2024.12.13 22:29:52.831299 [ 282 ] {3bf156cb-3b94-4d67-bde9-d63b088ce51b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogrami64 | ||
| 616 | 2024.12.13 22:29:52.833803 [ 282 ] {3bf156cb-3b94-4d67-bde9-d63b088ce51b} <Debug> oximeter.measurements_histogrami64 (9bf2bfe1-939d-424b-a2e8-5327ef046cf1): Loading data parts | ||
| 617 | 2024.12.13 22:29:52.833981 [ 282 ] {3bf156cb-3b94-4d67-bde9-d63b088ce51b} <Debug> oximeter.measurements_histogrami64 (9bf2bfe1-939d-424b-a2e8-5327ef046cf1): There are no data parts | ||
| 618 | 2024.12.13 22:29:52.836110 [ 282 ] {3bf156cb-3b94-4d67-bde9-d63b088ce51b} <Debug> TCPHandler: Processed in 0.005220276 sec. | ||
| 619 | 2024.12.13 22:29:52.836296 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 620 | 2024.12.13 22:29:52.836586 [ 285 ] {c5c9cc73-c30e-4504-bbd1-afb80f575386} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramu64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(UInt64), counts Array(UInt64), min UInt64, max UInt64, sum_of_samples Int64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 621 | 2024.12.13 22:29:52.836660 [ 285 ] {c5c9cc73-c30e-4504-bbd1-afb80f575386} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramu64 | ||
| 622 | 2024.12.13 22:29:52.839465 [ 285 ] {c5c9cc73-c30e-4504-bbd1-afb80f575386} <Debug> oximeter.measurements_histogramu64 (19db12b8-9552-4eb4-b473-1c1eda4e552e): Loading data parts | ||
| 623 | 2024.12.13 22:29:52.839622 [ 285 ] {c5c9cc73-c30e-4504-bbd1-afb80f575386} <Debug> oximeter.measurements_histogramu64 (19db12b8-9552-4eb4-b473-1c1eda4e552e): There are no data parts | ||
| 624 | 2024.12.13 22:29:52.841232 [ 285 ] {c5c9cc73-c30e-4504-bbd1-afb80f575386} <Debug> TCPHandler: Processed in 0.00499722 sec. | ||
| 625 | 2024.12.13 22:29:52.841425 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 626 | 2024.12.13 22:29:52.841693 [ 282 ] {9728f355-6350-4ec2-bf2d-56ddb4fd0bfd} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf32 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float32), counts Array(UInt64), min Float32, max Float32, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 627 | 2024.12.13 22:29:52.841774 [ 282 ] {9728f355-6350-4ec2-bf2d-56ddb4fd0bfd} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf32 | ||
| 628 | 2024.12.13 22:29:52.844911 [ 282 ] {9728f355-6350-4ec2-bf2d-56ddb4fd0bfd} <Debug> oximeter.measurements_histogramf32 (4dd61a61-23bb-4ad5-a1a3-b91fd5e6d956): Loading data parts | ||
| 629 | 2024.12.13 22:29:52.845100 [ 282 ] {9728f355-6350-4ec2-bf2d-56ddb4fd0bfd} <Debug> oximeter.measurements_histogramf32 (4dd61a61-23bb-4ad5-a1a3-b91fd5e6d956): There are no data parts | ||
| 630 | 2024.12.13 22:29:52.848644 [ 282 ] {9728f355-6350-4ec2-bf2d-56ddb4fd0bfd} <Debug> TCPHandler: Processed in 0.007273894 sec. | ||
| 631 | 2024.12.13 22:29:52.848853 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 632 | 2024.12.13 22:29:52.849177 [ 285 ] {213988a8-b5f0-4e7a-bc41-b04a775798b0} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.measurements_histogramf64 ( timeseries_name String, timeseries_key UInt64, start_time DateTime64(9, 'UTC'), timestamp DateTime64(9, 'UTC'), bins Array(Float64), counts Array(UInt64), min Float64, max Float64, sum_of_samples Float64, squared_mean Float64, p50_marker_heights Array(Float64), p50_marker_positions Array(UInt64), p50_desired_marker_positions Array(Float64), p90_marker_heights Array(Float64), p90_marker_positions Array(UInt64), p90_desired_marker_positions Array(Float64), p99_marker_heights Array(Float64), p99_marker_positions Array(UInt64), p99_desired_marker_positions Array(Float64) ) ENGINE = MergeTree() ORDER BY (timeseries_name, timeseries_key, start_time, timestamp) TTL toDateTime(timestamp) + INTERVAL 30 DAY (stage: Complete) | ||
| 633 | 2024.12.13 22:29:52.849261 [ 285 ] {213988a8-b5f0-4e7a-bc41-b04a775798b0} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.measurements_histogramf64 | ||
| 634 | 2024.12.13 22:29:52.853829 [ 285 ] {213988a8-b5f0-4e7a-bc41-b04a775798b0} <Debug> oximeter.measurements_histogramf64 (1553741e-2d74-43f9-88cb-23bcead5f72e): Loading data parts | ||
| 635 | 2024.12.13 22:29:52.854004 [ 285 ] {213988a8-b5f0-4e7a-bc41-b04a775798b0} <Debug> oximeter.measurements_histogramf64 (1553741e-2d74-43f9-88cb-23bcead5f72e): There are no data parts | ||
| 636 | 2024.12.13 22:29:52.855950 [ 285 ] {213988a8-b5f0-4e7a-bc41-b04a775798b0} <Debug> TCPHandler: Processed in 0.007162151 sec. | ||
| 637 | 2024.12.13 22:29:52.856160 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 638 | 2024.12.13 22:29:52.856359 [ 282 ] {784b9538-34f4-4f0a-96bf-e77213186005} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) /* The field tables store named dimensions of each timeseries. | ||
| 639 | * | ||
| 640 | * As with the measurement tables, there is one field table for each field data | ||
| 641 | * type. Fields are deduplicated by using the "replacing merge tree", though | ||
| 642 | * this behavior **must not** be relied upon for query correctness. | ||
| 643 | * | ||
| 644 | * The index for the fields differs from the measurements, however. Rows are | ||
| 645 | * sorted by timeseries name, then field name, field value, and finally | ||
| 646 | * timeseries key. This reflects the most common pattern for looking them up: | ||
| 647 | * by field name and possibly value, within a timeseries. The resulting keys are | ||
| 648 | * usually then used to look up measurements. | ||
| 649 | * | ||
| 650 | * NOTE: We may want to consider a secondary index on these tables, sorting by | ||
| 651 | * timeseries name and then key, since it would improve lookups where one | ||
| 652 | * already has the key. Realistically though, these tables are quite small and | ||
| 653 | * so performance benefits will be low in absolute terms. | ||
| 654 | * | ||
| 655 | * TTL: We use a materialized column to expire old field table records. This | ||
| 656 | * column is generated automatically by the database whenever a new row is | ||
| 657 | * inserted. It cannot be inserted directly, nor is it returned in a `SELECT *` | ||
| 658 | * query. Since these tables are `ReplacingMergeTree`s, that means the last | ||
| 659 | * record will remain during a deduplication, which will have the last | ||
| 660 | * timestamp. ClickHouse will then expire old data for us, similar to the | ||
| 661 | * measurement tables. | ||
| 662 | */ | ||
| 663 | CREATE TABLE IF NOT EXISTS oximeter.fields_bool ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Bool, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 664 | 2024.12.13 22:29:52.856434 [ 282 ] {784b9538-34f4-4f0a-96bf-e77213186005} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_bool | ||
| 665 | 2024.12.13 22:29:52.860164 [ 282 ] {784b9538-34f4-4f0a-96bf-e77213186005} <Debug> oximeter.fields_bool (c6735742-a012-4db3-90c2-3823b3bccbce): Loading data parts | ||
| 666 | 2024.12.13 22:29:52.860357 [ 282 ] {784b9538-34f4-4f0a-96bf-e77213186005} <Debug> oximeter.fields_bool (c6735742-a012-4db3-90c2-3823b3bccbce): There are no data parts | ||
| 667 | 2024.12.13 22:29:52.864802 [ 282 ] {784b9538-34f4-4f0a-96bf-e77213186005} <Debug> TCPHandler: Processed in 0.008704944 sec. | ||
| 668 | 2024.12.13 22:29:52.865013 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 669 | 2024.12.13 22:29:52.865240 [ 285 ] {6bccc933-27d5-43c3-bb8c-d51b2753718e} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.fields_i8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 670 | 2024.12.13 22:29:52.865313 [ 285 ] {6bccc933-27d5-43c3-bb8c-d51b2753718e} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i8 | ||
| 671 | 2024.12.13 22:29:52.868484 [ 285 ] {6bccc933-27d5-43c3-bb8c-d51b2753718e} <Debug> oximeter.fields_i8 (c0bcf43d-dbc1-4e1d-a551-dd2cdef59ec6): Loading data parts | ||
| 672 | 2024.12.13 22:29:52.868669 [ 285 ] {6bccc933-27d5-43c3-bb8c-d51b2753718e} <Debug> oximeter.fields_i8 (c0bcf43d-dbc1-4e1d-a551-dd2cdef59ec6): There are no data parts | ||
| 673 | 2024.12.13 22:29:52.870313 [ 285 ] {6bccc933-27d5-43c3-bb8c-d51b2753718e} <Debug> TCPHandler: Processed in 0.005356381 sec. | ||
| 674 | 2024.12.13 22:29:52.870521 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 675 | 2024.12.13 22:29:52.870725 [ 282 ] {fee6f911-6af6-4767-80cf-415d9c04bfeb} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.fields_u8 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt8, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 676 | 2024.12.13 22:29:52.870802 [ 282 ] {fee6f911-6af6-4767-80cf-415d9c04bfeb} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u8 | ||
| 677 | 2024.12.13 22:29:52.873606 [ 282 ] {fee6f911-6af6-4767-80cf-415d9c04bfeb} <Debug> oximeter.fields_u8 (bc454132-1a34-45d1-b203-8939673eb54a): Loading data parts | ||
| 678 | 2024.12.13 22:29:52.873804 [ 282 ] {fee6f911-6af6-4767-80cf-415d9c04bfeb} <Debug> oximeter.fields_u8 (bc454132-1a34-45d1-b203-8939673eb54a): There are no data parts | ||
| 679 | 2024.12.13 22:29:52.879152 [ 282 ] {fee6f911-6af6-4767-80cf-415d9c04bfeb} <Debug> TCPHandler: Processed in 0.008684323 sec. | ||
| 680 | 2024.12.13 22:29:52.879345 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 681 | 2024.12.13 22:29:52.879565 [ 285 ] {1d363342-659e-4d8c-9997-506e9079a31c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.fields_i16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 682 | 2024.12.13 22:29:52.879626 [ 285 ] {1d363342-659e-4d8c-9997-506e9079a31c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i16 | ||
| 683 | 2024.12.13 22:29:52.882974 [ 285 ] {1d363342-659e-4d8c-9997-506e9079a31c} <Debug> oximeter.fields_i16 (1be1d475-b066-4164-afa3-2cbe38afae58): Loading data parts | ||
| 684 | 2024.12.13 22:29:52.883128 [ 285 ] {1d363342-659e-4d8c-9997-506e9079a31c} <Debug> oximeter.fields_i16 (1be1d475-b066-4164-afa3-2cbe38afae58): There are no data parts | ||
| 685 | 2024.12.13 22:29:52.884445 [ 285 ] {1d363342-659e-4d8c-9997-506e9079a31c} <Debug> TCPHandler: Processed in 0.005153675 sec. | ||
| 686 | 2024.12.13 22:29:52.884642 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 687 | 2024.12.13 22:29:52.884842 [ 282 ] {fda9cfdd-4019-4486-998c-36f0fd419658} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.fields_u16 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt16, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 688 | 2024.12.13 22:29:52.884909 [ 282 ] {fda9cfdd-4019-4486-998c-36f0fd419658} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u16 | ||
| 689 | 2024.12.13 22:29:52.888719 [ 282 ] {fda9cfdd-4019-4486-998c-36f0fd419658} <Debug> oximeter.fields_u16 (a8e7cb83-b55d-4b4d-be0d-c7dce0730258): Loading data parts | ||
| 690 | 2024.12.13 22:29:52.888929 [ 282 ] {fda9cfdd-4019-4486-998c-36f0fd419658} <Debug> oximeter.fields_u16 (a8e7cb83-b55d-4b4d-be0d-c7dce0730258): There are no data parts | ||
| 691 | 2024.12.13 22:29:52.892489 [ 282 ] {fda9cfdd-4019-4486-998c-36f0fd419658} <Debug> TCPHandler: Processed in 0.007899721 sec. | ||
| 692 | 2024.12.13 22:29:52.892676 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 693 | 2024.12.13 22:29:52.892905 [ 285 ] {e111ba94-321d-40e6-b75f-5e7c4ff12e63} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.fields_i32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 694 | 2024.12.13 22:29:52.892969 [ 285 ] {e111ba94-321d-40e6-b75f-5e7c4ff12e63} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i32 | ||
| 695 | 2024.12.13 22:29:52.895102 [ 285 ] {e111ba94-321d-40e6-b75f-5e7c4ff12e63} <Debug> oximeter.fields_i32 (5bec2b3a-2015-4328-a044-287583bc8621): Loading data parts | ||
| 696 | 2024.12.13 22:29:52.895296 [ 285 ] {e111ba94-321d-40e6-b75f-5e7c4ff12e63} <Debug> oximeter.fields_i32 (5bec2b3a-2015-4328-a044-287583bc8621): There are no data parts | ||
| 697 | 2024.12.13 22:29:52.899720 [ 285 ] {e111ba94-321d-40e6-b75f-5e7c4ff12e63} <Debug> TCPHandler: Processed in 0.007098889 sec. | ||
| 698 | 2024.12.13 22:29:52.899935 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 699 | 2024.12.13 22:29:52.900171 [ 282 ] {32923e16-6d32-478c-b552-b5aa32901a12} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.fields_u32 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt32, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 700 | 2024.12.13 22:29:52.900239 [ 282 ] {32923e16-6d32-478c-b552-b5aa32901a12} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u32 | ||
| 701 | 2024.12.13 22:29:52.902903 [ 282 ] {32923e16-6d32-478c-b552-b5aa32901a12} <Debug> oximeter.fields_u32 (632703f6-fdd4-435e-a823-94267fde42ca): Loading data parts | ||
| 702 | 2024.12.13 22:29:52.903137 [ 282 ] {32923e16-6d32-478c-b552-b5aa32901a12} <Debug> oximeter.fields_u32 (632703f6-fdd4-435e-a823-94267fde42ca): There are no data parts | ||
| 703 | 2024.12.13 22:29:52.904880 [ 282 ] {32923e16-6d32-478c-b552-b5aa32901a12} <Debug> TCPHandler: Processed in 0.005012311 sec. | ||
| 704 | 2024.12.13 22:29:52.905079 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 705 | 2024.12.13 22:29:52.905309 [ 285 ] {fe5c5691-404c-4809-905d-528c250d28cf} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.fields_i64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value Int64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 706 | 2024.12.13 22:29:52.905371 [ 285 ] {fe5c5691-404c-4809-905d-528c250d28cf} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_i64 | ||
| 707 | 2024.12.13 22:29:52.907466 [ 285 ] {fe5c5691-404c-4809-905d-528c250d28cf} <Debug> oximeter.fields_i64 (77ebc474-fc3c-41d3-ac26-24f5c79a591b): Loading data parts | ||
| 708 | 2024.12.13 22:29:52.907639 [ 285 ] {fe5c5691-404c-4809-905d-528c250d28cf} <Debug> oximeter.fields_i64 (77ebc474-fc3c-41d3-ac26-24f5c79a591b): There are no data parts | ||
| 709 | 2024.12.13 22:29:52.909340 [ 285 ] {fe5c5691-404c-4809-905d-528c250d28cf} <Debug> TCPHandler: Processed in 0.004321802 sec. | ||
| 710 | 2024.12.13 22:29:52.909549 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 711 | 2024.12.13 22:29:52.909780 [ 282 ] {331c7e57-901c-4545-9be6-37482cc3641b} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.fields_u64 ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UInt64, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 712 | 2024.12.13 22:29:52.909854 [ 282 ] {331c7e57-901c-4545-9be6-37482cc3641b} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_u64 | ||
| 713 | 2024.12.13 22:29:52.912085 [ 282 ] {331c7e57-901c-4545-9be6-37482cc3641b} <Debug> oximeter.fields_u64 (8d8814ae-b6ca-41f5-9ab8-470820158f9b): Loading data parts | ||
| 714 | 2024.12.13 22:29:52.912260 [ 282 ] {331c7e57-901c-4545-9be6-37482cc3641b} <Debug> oximeter.fields_u64 (8d8814ae-b6ca-41f5-9ab8-470820158f9b): There are no data parts | ||
| 715 | 2024.12.13 22:29:52.914510 [ 282 ] {331c7e57-901c-4545-9be6-37482cc3641b} <Debug> TCPHandler: Processed in 0.00501725 sec. | ||
| 716 | 2024.12.13 22:29:52.914706 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 717 | 2024.12.13 22:29:52.914962 [ 285 ] {bda138cb-ad5a-4cfe-a440-3e36c7ed514c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.fields_ipaddr ( timeseries_name String, timeseries_key UInt64, field_name String, field_value IPv6, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 718 | 2024.12.13 22:29:52.915035 [ 285 ] {bda138cb-ad5a-4cfe-a440-3e36c7ed514c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_ipaddr | ||
| 719 | 2024.12.13 22:29:52.916930 [ 285 ] {bda138cb-ad5a-4cfe-a440-3e36c7ed514c} <Debug> oximeter.fields_ipaddr (d8c149c0-5aa6-41ac-89a2-2d4480770c56): Loading data parts | ||
| 720 | 2024.12.13 22:29:52.917085 [ 285 ] {bda138cb-ad5a-4cfe-a440-3e36c7ed514c} <Debug> oximeter.fields_ipaddr (d8c149c0-5aa6-41ac-89a2-2d4480770c56): There are no data parts | ||
| 721 | 2024.12.13 22:29:52.918709 [ 285 ] {bda138cb-ad5a-4cfe-a440-3e36c7ed514c} <Debug> TCPHandler: Processed in 0.004066384 sec. | ||
| 722 | 2024.12.13 22:29:52.918910 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 723 | 2024.12.13 22:29:52.919109 [ 282 ] {5908b975-741a-498d-bac5-916ec894e2e8} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) CREATE TABLE IF NOT EXISTS oximeter.fields_string ( timeseries_name String, timeseries_key UInt64, field_name String, field_value String, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 724 | 2024.12.13 22:29:52.919180 [ 282 ] {5908b975-741a-498d-bac5-916ec894e2e8} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_string | ||
| 725 | 2024.12.13 22:29:52.922330 [ 282 ] {5908b975-741a-498d-bac5-916ec894e2e8} <Debug> oximeter.fields_string (efd7c6e7-2c86-4487-a762-f3e5bbc3ddee): Loading data parts | ||
| 726 | 2024.12.13 22:29:52.922504 [ 282 ] {5908b975-741a-498d-bac5-916ec894e2e8} <Debug> oximeter.fields_string (efd7c6e7-2c86-4487-a762-f3e5bbc3ddee): There are no data parts | ||
| 727 | 2024.12.13 22:29:52.923771 [ 282 ] {5908b975-741a-498d-bac5-916ec894e2e8} <Debug> TCPHandler: Processed in 0.004915258 sec. | ||
| 728 | 2024.12.13 22:29:52.924013 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 729 | 2024.12.13 22:29:52.924230 [ 285 ] {42b46730-4a67-4425-911b-dc33270bb65c} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) CREATE TABLE IF NOT EXISTS oximeter.fields_uuid ( timeseries_name String, timeseries_key UInt64, field_name String, field_value UUID, last_updated_at DateTime MATERIALIZED now() ) ENGINE = ReplacingMergeTree() ORDER BY (timeseries_name, field_name, field_value, timeseries_key) TTL last_updated_at + INTERVAL 30 DAY (stage: Complete) | ||
| 730 | 2024.12.13 22:29:52.924306 [ 285 ] {42b46730-4a67-4425-911b-dc33270bb65c} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.fields_uuid | ||
| 731 | 2024.12.13 22:29:52.927962 [ 285 ] {42b46730-4a67-4425-911b-dc33270bb65c} <Debug> oximeter.fields_uuid (74eb909a-78d5-4bc3-91f2-b78331f51f9b): Loading data parts | ||
| 732 | 2024.12.13 22:29:52.928144 [ 285 ] {42b46730-4a67-4425-911b-dc33270bb65c} <Debug> oximeter.fields_uuid (74eb909a-78d5-4bc3-91f2-b78331f51f9b): There are no data parts | ||
| 733 | 2024.12.13 22:29:52.934614 [ 285 ] {42b46730-4a67-4425-911b-dc33270bb65c} <Debug> TCPHandler: Processed in 0.010684129 sec. | ||
| 734 | 2024.12.13 22:29:52.934828 [ 282 ] {} <Trace> TCP-Session: 77f4c29f-75b2-429e-8a9a-50102b4dd404 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 735 | 2024.12.13 22:29:52.935124 [ 282 ] {2a7232fe-639a-4a15-b410-23223e2c453f} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:47756) /* The timeseries schema table stores the extracted schema for the samples | ||
| 736 | * oximeter collects. | ||
| 737 | */ | ||
| 738 | CREATE TABLE IF NOT EXISTS oximeter.timeseries_schema ( timeseries_name String, fields Nested( name String, type Enum( 'Bool' = 1, 'I64' = 2, 'IpAddr' = 3, 'String' = 4, 'Uuid' = 6, 'I8' = 7, 'U8' = 8, 'I16' = 9, 'U16' = 10, 'I32' = 11, 'U32' = 12, 'U64' = 13 ), source Enum( 'Target' = 1, 'Metric' = 2 ) ), datum_type Enum( 'Bool' = 1, 'I64' = 2, 'F64' = 3, 'String' = 4, 'Bytes' = 5, 'CumulativeI64' = 6, 'CumulativeF64' = 7, 'HistogramI64' = 8, 'HistogramF64' = 9, 'I8' = 10, 'U8' = 11, 'I16' = 12, 'U16' = 13, 'I32' = 14, 'U32' = 15, 'U64' = 16, 'F32' = 17, 'CumulativeU64' = 18, 'CumulativeF32' = 19, 'HistogramI8' = 20, 'HistogramU8' = 21, 'HistogramI16' = 22, 'HistogramU16' = 23, 'HistogramI32' = 24, 'HistogramU32' = 25, 'HistogramU64' = 26, 'HistogramF32' = 27 ), created DateTime64(9, 'UTC') ) ENGINE = MergeTree() ORDER BY (timeseries_name, fields.name) (stage: Complete) | ||
| 739 | 2024.12.13 22:29:52.935207 [ 282 ] {2a7232fe-639a-4a15-b410-23223e2c453f} <Trace> ContextAccess (default): Access granted: CREATE TABLE ON oximeter.timeseries_schema | ||
| 740 | 2024.12.13 22:29:52.938495 [ 282 ] {2a7232fe-639a-4a15-b410-23223e2c453f} <Debug> oximeter.timeseries_schema (56c5af61-889d-43a0-82f2-cc27dedfb65b): Loading data parts | ||
| 741 | 2024.12.13 22:29:52.938656 [ 282 ] {2a7232fe-639a-4a15-b410-23223e2c453f} <Debug> oximeter.timeseries_schema (56c5af61-889d-43a0-82f2-cc27dedfb65b): There are no data parts | ||
| 742 | 2024.12.13 22:29:52.940549 [ 282 ] {2a7232fe-639a-4a15-b410-23223e2c453f} <Debug> TCPHandler: Processed in 0.005777902 sec. | ||
| 743 | 2024.12.13 22:29:52.940755 [ 285 ] {} <Trace> TCP-Session: 45b201df-604d-4ac7-b37c-9a9f43f02c74 Creating query context from session context, user_id: 94309d50-4f52-5250-31bd-74fecac179db, parent context user: default | ||
| 744 | 2024.12.13 22:29:52.940941 [ 285 ] {e2e9fcdf-b3b0-46e7-a418-43d5377b0c53} <Debug> executeQuery: (from [fd00:1122:3344:101::d]:50696) INSERT INTO oximeter.version (*) VALUES (stage: Complete) | ||
| 745 | 2024.12.13 22:29:52.942740 [ 285 ] {e2e9fcdf-b3b0-46e7-a418-43d5377b0c53} <Trace> ContextAccess (default): Access granted: INSERT(value, timestamp) ON oximeter.version | ||
| 746 | 2024.12.13 22:29:52.951063 [ 292 ] {e2e9fcdf-b3b0-46e7-a418-43d5377b0c53} <Trace> oximeter.version (bacb2f14-56fe-4ed8-af06-495448e7b2d7): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 747 | 2024.12.13 22:29:52.951128 [ 292 ] {e2e9fcdf-b3b0-46e7-a418-43d5377b0c53} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.35 GiB. | ||
| 748 | 2024.12.13 22:29:52.955792 [ 292 ] {e2e9fcdf-b3b0-46e7-a418-43d5377b0c53} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 749 | 2024.12.13 22:29:52.956176 [ 292 ] {e2e9fcdf-b3b0-46e7-a418-43d5377b0c53} <Trace> oximeter.version (bacb2f14-56fe-4ed8-af06-495448e7b2d7): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 750 | 2024.12.13 22:29:52.956540 [ 285 ] {e2e9fcdf-b3b0-46e7-a418-43d5377b0c53} <Debug> executeQuery: Read 1 rows, 16.00 B in 0.015662 sec., 63.84880602732729 rows/sec., 1021.58 B/sec. | ||
| 751 | 2024.12.13 22:29:52.956856 [ 285 ] {e2e9fcdf-b3b0-46e7-a418-43d5377b0c53} <Debug> TCPHandler: Processed in 0.016152153 sec. | ||
| 752 | 2024.12.13 22:29:53.000156 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 128.34 MiB, peak 128.34 MiB, free memory in arenas 0.00 B, will set to 141.46 MiB (RSS), difference: 13.12 MiB | ||
| 753 | 2024.12.13 22:29:55.731180 [ 244 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush up to offset 8 | ||
| 754 | 2024.12.13 22:29:55.731181 [ 243 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushing system log, 488 entries to flush up to offset 488 | ||
| 755 | 2024.12.13 22:29:55.731294 [ 244 ] {} <Debug> SystemLog (system.metric_log): Creating new table system.metric_log for MetricLog | ||
| 756 | 2024.12.13 22:29:55.731318 [ 243 ] {} <Debug> SystemLog (system.asynchronous_metric_log): Creating new table system.asynchronous_metric_log for AsynchronousMetricLog | ||
| 757 | 2024.12.13 22:29:55.738038 [ 243 ] {} <Debug> system.asynchronous_metric_log (9fbfda46-836b-4239-87f6-7eeff1ccc75a): Loading data parts | ||
| 758 | 2024.12.13 22:29:55.738457 [ 243 ] {} <Debug> system.asynchronous_metric_log (9fbfda46-836b-4239-87f6-7eeff1ccc75a): There are no data parts | ||
| 759 | 2024.12.13 22:29:55.746290 [ 243 ] {} <Trace> system.asynchronous_metric_log (9fbfda46-836b-4239-87f6-7eeff1ccc75a): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 760 | 2024.12.13 22:29:55.746372 [ 243 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.35 GiB. | ||
| 761 | 2024.12.13 22:29:55.749435 [ 243 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 762 | 2024.12.13 22:29:55.750179 [ 243 ] {} <Trace> system.asynchronous_metric_log (9fbfda46-836b-4239-87f6-7eeff1ccc75a): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 763 | 2024.12.13 22:29:55.750733 [ 243 ] {} <Trace> SystemLog (system.asynchronous_metric_log): Flushed system log up to offset 488 | ||
| 764 | 2024.12.13 22:29:55.757179 [ 244 ] {} <Debug> system.metric_log (c766688b-2bb8-4f18-a587-7d33699abce7): Loading data parts | ||
| 765 | 2024.12.13 22:29:55.757377 [ 244 ] {} <Debug> system.metric_log (c766688b-2bb8-4f18-a587-7d33699abce7): There are no data parts | ||
| 766 | 2024.12.13 22:29:55.780299 [ 244 ] {} <Trace> system.metric_log (c766688b-2bb8-4f18-a587-7d33699abce7): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 767 | 2024.12.13 22:29:55.780358 [ 244 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.35 GiB. | ||
| 768 | 2024.12.13 22:29:55.787537 [ 244 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 769 | 2024.12.13 22:29:55.788332 [ 244 ] {} <Trace> system.metric_log (c766688b-2bb8-4f18-a587-7d33699abce7): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 770 | 2024.12.13 22:29:55.790911 [ 244 ] {} <Trace> SystemLog (system.metric_log): Flushed system log up to offset 8 | ||
| 771 | 2024.12.13 22:29:56.000669 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 146.45 MiB, peak 150.45 MiB, free memory in arenas 0.00 B, will set to 150.93 MiB (RSS), difference: 4.48 MiB | ||
| 772 | 2024.12.13 22:29:58.231206 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushing system log, 90 entries to flush up to offset 90 | ||
| 773 | 2024.12.13 22:29:58.231318 [ 242 ] {} <Debug> SystemLog (system.query_log): Creating new table system.query_log for QueryLog | ||
| 774 | 2024.12.13 22:29:58.236481 [ 242 ] {} <Debug> system.query_log (ed646fe6-4d54-4051-852b-723abd148035): Loading data parts | ||
| 775 | 2024.12.13 22:29:58.236721 [ 242 ] {} <Debug> system.query_log (ed646fe6-4d54-4051-852b-723abd148035): There are no data parts | ||
| 776 | 2024.12.13 22:29:58.242480 [ 242 ] {} <Trace> system.query_log (ed646fe6-4d54-4051-852b-723abd148035): Trying to reserve 1.00 MiB using storage policy from min volume index 0 | ||
| 777 | 2024.12.13 22:29:58.242521 [ 242 ] {} <Trace> DiskLocal: Reserved 1.00 MiB on local disk `default`, having unreserved 14.35 GiB. | ||
| 778 | 2024.12.13 22:29:58.244291 [ 242 ] {} <Trace> MergedBlockOutputStream: filled checksums all_1_1_0 (state Temporary) | ||
| 779 | 2024.12.13 22:29:58.244652 [ 242 ] {} <Trace> system.query_log (ed646fe6-4d54-4051-852b-723abd148035): Renaming temporary part tmp_insert_all_1_1_0 to all_1_1_0 with tid (1, 1, 00000000-0000-0000-0000-000000000000). | ||
| 780 | 2024.12.13 22:29:58.245267 [ 242 ] {} <Trace> SystemLog (system.query_log): Flushed system log up to offset 90 | ||
| 781 | 2024.12.13 22:29:59.000219 [ 247 ] {} <Trace> AsynchronousMetrics: MemoryTracking: was 155.13 MiB, peak 155.13 MiB, free memory in arenas 0.00 B, will set to 151.33 MiB (RSS), difference: -3.80 MiB | ||